27
28
29
30
31
32
33
34
35
36
37
38
39
40
|
SELECT j.*, strftime(\'%s\', j.date) AS date,
(CASE WHEN j.compte_debit = :compte THEN j.montant ELSE -(j.montant) END) AS solde,
r.date AS date_rapprochement
FROM compta_journal AS j
LEFT JOIN compta_rapprochement AS r ON r.id_operation = j.id
WHERE (compte_debit = :compte OR compte_credit = :compte)
AND j.date >= :debut AND j.date <= :fin
' . ($sauf_deja_rapprochees ? 'AND r.id_operation IS NULL' : '') . '
ORDER BY date ASC;';
$result = $db->get($query, [
'compte' => $compte,
'debut' => $debut,
'fin' => $fin,
|
>
|
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
|
SELECT j.*, strftime(\'%s\', j.date) AS date,
(CASE WHEN j.compte_debit = :compte THEN j.montant ELSE -(j.montant) END) AS solde,
r.date AS date_rapprochement
FROM compta_journal AS j
LEFT JOIN compta_rapprochement AS r ON r.id_operation = j.id
WHERE (compte_debit = :compte OR compte_credit = :compte)
AND j.date >= :debut AND j.date <= :fin
AND compte_debit IS NOT NULL AND compte_credit IS NOT NULL
' . ($sauf_deja_rapprochees ? 'AND r.id_operation IS NULL' : '') . '
ORDER BY date ASC;';
$result = $db->get($query, [
'compte' => $compte,
'debut' => $debut,
'fin' => $fin,
|