$m = $array[$i]->get_solde_detail($filter_year); $solde = $m['debit'] - $m['credit']; // print the result if the saldo is not equal to 0 if ($m['debit'] != 0.0 || $m['credit'] != 0.0) { /* get saldo for not reconcilied operations */ $saldo_not_reconcilied = $array[$i]->get_bk_balance($filter_year . " and (trim(jr_pj_number) ='' or jr_pj_number is null)"); /* get saldo for reconcilied operation */ $saldo_reconcilied = $array[$i]->get_bk_balance($filter_year . " and ( trim(jr_pj_number) != '' and jr_pj_number is not null)"); if ($idx % 2 != 0) { $odd = "odd"; } else { $odd = "even"; } $idx++; echo "<tr class=\"{$odd}\">"; echo "<TD >" . IButton::history_card($array[$i]->id, $array[$i]->strAttribut(ATTR_DEF_QUICKCODE)) . "</TD>"; $saldo_rec = bcsub($saldo_reconcilied['debit'], $saldo_reconcilied['credit']); $diff = bcsub($saldo_not_reconcilied['debit'], $saldo_not_reconcilied['credit']); echo "<TD >" . $array[$i]->strAttribut(ATTR_DEF_NAME) . "</TD>" . td(h($array[$i]->ledger_name)) . td(h($array[$i]->ledger_description)) . '<TD class="sorttable_numeric" sorttable_customkey="' . $solde . '" style="text-align:right">' . nbm($solde) . "</TD>" . '<TD class="sorttable_numeric" sorttable_customkey="' . $saldo_rec . '" style="text-align:right">' . nbm($saldo_rec) . "</TD>" . '<TD class="sorttable_numeric" sorttable_customkey="' . $diff . '" style="text-align:right">' . nbm($diff) . "</TD>" . "</TR>"; $tot_extrait = bcadd($tot_extrait, $solde); $tot_operation = bcadd($tot_operation, $saldo_rec); $tot_diff = bcadd($tot_diff, $diff); } } // for echo '<tfoot>'; echo '<tr class="highlight">'; echo td(''); echo td(''); echo td(''); echo td(' TOTAUX ', 'style="font-weight:bold"');