225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
|
{
$db = DB::getInstance();
$charges = array('comptes' => array(), 'total' => 0.0);
$produits = array('comptes' => array(), 'total' => 0.0);
$resultat = 0.0;
$res = $db->prepare('SELECT compte, debit, credit
FROM
(SELECT compte_debit AS compte, SUM(montant) AS debit, 0 AS credit
FROM compta_journal WHERE id_exercice = '.(int)$exercice.' GROUP BY compte_debit
UNION
SELECT compte_credit AS compte, 0 AS debit, SUM(montant) AS credit
FROM compta_journal WHERE id_exercice = '.(int)$exercice.' GROUP BY compte_credit)
WHERE compte LIKE \'6%\' OR compte LIKE \'7%\'
ORDER BY base64(compte) COLLATE BINARY ASC;'
)->execute();
while ($row = $res->fetchArray(SQLITE3_NUM))
{
list($compte, $debit, $credit) = $row;
$classe = substr($compte, 0, 1);
|
|
>
|
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
|
{
$db = DB::getInstance();
$charges = array('comptes' => array(), 'total' => 0.0);
$produits = array('comptes' => array(), 'total' => 0.0);
$resultat = 0.0;
$res = $db->prepare('SELECT compte, SUM(debit), SUM(credit)
FROM
(SELECT compte_debit AS compte, SUM(montant) AS debit, 0 AS credit
FROM compta_journal WHERE id_exercice = '.(int)$exercice.' GROUP BY compte_debit
UNION
SELECT compte_credit AS compte, 0 AS debit, SUM(montant) AS credit
FROM compta_journal WHERE id_exercice = '.(int)$exercice.' GROUP BY compte_credit)
WHERE compte LIKE \'6%\' OR compte LIKE \'7%\'
GROUP BY compte
ORDER BY base64(compte) COLLATE BINARY ASC;'
)->execute();
while ($row = $res->fetchArray(SQLITE3_NUM))
{
list($compte, $debit, $credit) = $row;
$classe = substr($compte, 0, 1);
|