{
return $this->getStats('SELECT strftime(\'%Y%m\', date) AS date,
SUM(montant) FROM compta_journal
+ LEFT JOIN compta_flux ON compta_journal.id = compta_flux.id_journal
WHERE id_categorie IN (SELECT id FROM compta_categories WHERE type = '.$type.')
AND id_exercice = (SELECT id FROM compta_exercices WHERE cloture = 0)
GROUP BY strftime(\'%Y-%m\', date) ORDER BY date;');
return $this->_parType(Compta_Categories::DEPENSES);
}
- public function soldeCompte($compte, $augmente = 'debit', $diminue = 'credit')
+ public function soldeCompte($compte)
{
$db = DB::getInstance();
$stats = $this->getStats('SELECT strftime(\'%Y%m\', date) AS date,
(COALESCE((SELECT SUM(montant) FROM compta_journal
- WHERE compte_'.$augmente.' '.$compte.' AND id_exercice = cj.id_exercice
- AND date >= strftime(\'%Y-%m-01\', cj.date)
- AND date <= strftime(\'%Y-%m-31\', cj.date)), 0)
- - COALESCE((SELECT SUM(montant) FROM compta_journal
- WHERE compte_'.$diminue.' '.$compte.' AND id_exercice = cj.id_exercice
+ LEFT JOIN compta_flux ON compta_journal.id = compta_flux.id_journal
+ WHERE compte '.$compte.' AND id_exercice = cj.id_exercice
AND date >= strftime(\'%Y-%m-01\', cj.date)
AND date <= strftime(\'%Y-%m-31\', cj.date)), 0)
) AS solde
FROM compta_journal AS cj
- WHERE (compte_debit '.$compte.' OR compte_credit '.$compte.')
+ WHERE (compte '.$compte.')
AND id_exercice = (SELECT id FROM compta_exercices WHERE cloture = 0)
GROUP BY strftime(\'%Y-%m\', date) ORDER BY date;');
}
}
-?>
\ No newline at end of file
+?>