/** * with the handle of a successull query, echo each row into CSV and * send it directly * @param type $ret handle to a query * @param type $aheader double array, each item of the array contains * a key type (num) and a key title */ function query_to_csv($ret, $aheader) { $seq = ""; for ($i = 0; $i < count($aheader); $i++) { echo $seq . '"' . $aheader[$i]['title'] . '"'; $seq = ";"; } printf("\n\r"); // fetch all the rows for ($i = 0; $i < Database::num_row($ret); $i++) { $row = Database::fetch_array($ret, $i); $sep2 = ""; // for each rows, for each value for ($e = 0; $e < count($row) / 2; $e++) { switch ($aheader[$e]['type']) { case 'num': echo $sep2 . nb($row[$e]); break; default: echo $sep2 . '"' . $row[$e] . '"'; } $sep2 = ";"; } printf("\n\r"); } }
<h2 class="info2" style="margin:0 0"> <?php echo _("Solde crédit"); ?> : <?php echo nb($amount_cred); ?> </h2> <?php bcscale(2); $solde = bcsub($amount_deb, $amount_cred); if ($solde > 0) { ?> <h2 class="info2" style="margin:0 0"> <?php echo _("Solde débiteur"); ?> : <?php echo nb($solde); ?> </h2> <?php } else { ?> <h2 class="info2" style="margin:0 0"> <?php echo _("Solde créditeur"); ?> : <?php echo nb(abs($solde)); ?> </h2> <?php }
function display_csv() { $array = $this->load(); if (is_array($array) == false) { return $array; } $r = ""; foreach ($array as $row) { // the name and po_id $solde = $row['sum_cred'] > $row['sum_deb'] ? 'C' : 'D'; $solde = $row['sum_cred'] == $row['sum_deb'] ? '' : $solde; $r .= sprintf("'%s';", $row['po_id']); $r .= sprintf("'%s';", $row['po_name']); $r .= sprintf("%s;", nb($row['sum_deb'])); $r .= sprintf("%s;", nb($row['sum_cred'])); $r .= sprintf("%s;", nb($row['solde'])); $r .= sprintf("'%s'", $row['debit']); $r .= "\r\n"; } return $r; }
function export_csv() { bcscale(2); if ($this->check() != 0) { throw new Exception("DATE INVALIDE"); } if ($this->card_poste == '1') { $this->load_card(); echo '"Fiche"'; foreach ($this->aheader as $h) { echo ';"' . $h['po_name'] . '"'; } echo ';"Total"'; printf("\r\n"); /* * Show all the result */ for ($i = 0; $i < count($this->arow); $i++) { printf('"%s"', $this->arow[$i]['card_account'] . ' ' . $this->arow[$i]['name']); $tot_row = 0; for ($x = 0; $x < count($this->aheader); $x++) { $amount = $this->db->get_value($this->sql, array($this->arow[$i]['f_id'], $this->aheader[$x]['po_id'])); if ($amount == null) { $amount = 0; } if (isset($tot_col[$x])) { $tot_col[$x] = bcadd($tot_col[$x], $amount); } else { $tot_col[$x] = $amount; } printf(";%s", nb($amount)); $tot_row = bcadd($tot_row, $amount); } printf(";%s", nb($tot_row)); printf("\r\n"); } } if ($this->card_poste == '2') { $this->load_poste(); echo '"Poste"'; foreach ($this->aheader as $h) { echo ';"' . $h['po_name'] . '"'; } echo ';"Total"'; printf("\r\n"); /* * Show all the result */ for ($i = 0; $i < count($this->arow); $i++) { printf('"%s"', $this->arow[$i]['card_account'] . ' ' . $this->arow[$i]['name']); $tot_row = 0; for ($x = 0; $x < count($this->aheader); $x++) { $amount = $this->db->get_value($this->sql, array($this->arow[$i]['card_account'], $this->aheader[$x]['po_id'])); if ($amount == null) { $amount = 0; } if (isset($tot_col[$x])) { $tot_col[$x] = bcadd($tot_col[$x], $amount); } else { $tot_col[$x] = $amount; } printf(";%s", nb($amount)); $tot_row = bcadd($tot_row, $amount); } printf(";%s", nb($tot_row)); printf("\r\n"); } } }
} $solde_type = $tot_deb > $tot_cred ? "solde débiteur" : "solde créditeur"; $diff = abs($tot_deb - $tot_cred); printf(";;;" . '"' . _('total') . '";' . '"' . $current_exercice . '";' . '"' . "{$solde_type}" . '"' . ";" . nb($tot_deb) . ";" . nb($tot_cred) . ";" . nb($diff) . ";" . "\n"); } } else { /* detail of all operation */ if (count($a_poste) == 0) { exit; } foreach ($a_poste as $pos) { $Poste = new Acc_Account_Ledger($cn, $pos['pcm_val']); $Poste->get_name(); list($array, $tot_deb, $tot_cred) = $Poste->get_row_date($_REQUEST['from_periode'], $_REQUEST['to_periode'], $_GET['ople']); if (count($Poste->row) == 0) { continue; } echo '"Poste";' . '"Lib.";' . '"QuickCode";' . "\"Code interne\";" . "\"Date\";" . "\"Description\";" . "\"Montant\";" . "\"D/C\""; printf("\n"); foreach ($Poste->row as $a) { $op = new Acc_Operation($cn); $op->jr_id = $a['jr_id']; $result = $op->get_jrnx_detail(); foreach ($result as $r) { printf('"%s";"%s";"%s";"%s";"%s";"%s";"%s";%12.2f;"%s"', $r['j_poste'], $r['pcm_lib'], $r['j_qcode'], $r['jr_internal'], $r['jr_date'], $a['description'], $a['jr_pj_number'], nb($r['j_montant']), $r['debit']); printf("\r\n"); } } } exit; }
//--- for ($e = $_GET['from_periode']; $e <= $_GET['to_periode']; $e += $_GET['p_step']) { $periode = getPeriodeName($cn, $e); if ($periode == null) { continue; } $array[] = $Form->get_row($e, $e, $_GET['type_periode']); $periode_name[] = $periode; } // Display column heading //-- $x = ""; printf("Mois;"); foreach ($array[0] as $e) { printf("%s%s", $x, $e['desc']); $x = ";"; } printf("\n"); // Display value for each line //-- $a = 0; foreach ($array as $e) { print $periode_name[$a]; $a++; foreach ($e as $elt) { printf(";%s", nb($elt['montant'])); } printf("\n"); } } exit;
printf('"%s";', "Paiement"); printf('"%s";', "Piece"); printf('"%s";"";', "Tiers"); printf('"%s";', "Description"); printf('"%s";', "Note"); printf('"%s"', "Montant opération"); printf("\r\n"); for ($i = 0; $i < count($res); $i++) { printf('"%s";', $res[$i]['jr_internal']); printf('"%s";', $res[$i]['jrn_def_name']); printf('"%s";', $res[$i]['str_jr_date']); printf('"%s";', $res[$i]['str_jr_ech']); printf('"%s";', $res[$i]['str_jr_date_paid']); printf('"%s";', $res[$i]['jr_pj_number']); printf('"%s";', $res[$i]['quick_code']); printf('"%s %s";', $res[$i]['name'], $res[$i]['first_name']); printf('"%s";', $res[$i]['jr_comment']); printf('"%s";', $res[$i]['n_text']); $amount = $res[$i]['jr_montant']; if ($res[$i]['total_invoice'] != null && $res[$i]['jr_montant'] != $res[$i]['total_invoice']) { $amount = $res[$i]['total_invoice']; } if ($res[$i]['jrn_def_type'] == 'FIN') { $positive = $cn->get_value("select qf_amount from quant_fin where jr_id=\$1", array($res[$i]['jr_id'])); if ($positive != '') { $amount = $positive; } } printf('%s', nb($amount)); printf("\r\n"); }
function export_csv() { $array = $this->get_result(); printf('"groupe";"activité";"débit";"credit";"solde"'); printf("\r\n"); bcscale(2); for ($i = 0; $i < count($array); $i++) { printf('"%s";"%s";%s;%s;%s', $array[$i]['ga_id'], $array[$i]['po_name'], nb($array[$i]['sum_deb']), nb($array[$i]['sum_cred']), nb(bcsub($array[$i]['sum_cred'], $array[$i]['sum_deb']))); printf("\r\n"); } }
$amount_deb = bcadd($amount_deb, $row['j_montant']); $prog = bcadd($prog, $row['j_montant']); printf(";"); } else { printf(";"); printf("%s;", nb($row['j_montant'])); $amount_cred = bcadd($amount_cred, $row['j_montant']); $prog = bcsub($prog, $row['j_montant']); } printf("%s;\"%s\";", abs(nb($prog)), $fic->get_amount_side($prog)); if ($row['letter'] != -1) { printf('"%s";', strtoupper(base_convert($row['letter'], 10, 36))); printf("%s", nb($row['letter_diff'])); } else { printf(";"); } printf("\n"); } if ($prog < 0) { $msg = "Solde Debit"; } elseif ($prog > 0) { $msg = "Solde Credit"; } else { $msg = "soldé"; } printf(';;;"%s";%s;%s;%s;"%s"', $msg, nb($amount_deb), nb($amount_cred), nb(abs($prog)), $fic->get_amount_side($prog)); printf("\n"); } } } exit;
} break; } $bal->from_poste = $_GET['from_poste']; $bal->to_poste = $_GET['to_poste']; if (isset($_GET['unsold'])) { $bal->unsold = true; } $prev = isset($_GET['previous_exc']) ? 1 : 0; $row = $bal->get_row($_GET['from_periode'], $_GET['to_periode'], $prev); $prev = isset($row[0]['sum_cred_previous']) ? 1 : 0; echo 'poste;libelle;'; if ($prev == 1) { echo 'deb n-1;cred n-1;solde n-1;d/c;'; } echo 'deb;cred;solde;d/c'; printf("\n"); foreach ($row as $r) { echo $r['poste'] . ';' . $r['label'] . ';'; if ($prev == 1) { $delta = bcsub($r['solde_deb_previous'], $r['solde_cred_previous']); $sign = $delta < 0 ? 'C' : 'D'; $sign = $delta == 0 ? '=' : $sign; echo nb($r['sum_deb_previous']) . ';' . nb($r['sum_cred_previous']) . ';' . nb(abs($delta)) . ';' . "{$sign}" . ';'; } $delta = bcsub($r['solde_deb'], $r['solde_cred']); $sign = $delta < 0 ? 'C' : 'D'; $sign = $delta == 0 ? '=' : $sign; echo nb($r['sum_deb']) . ';' . nb($r['sum_cred']) . ';' . nb(abs($delta)) . ';' . "{$sign}"; printf("\n"); }
<html> <style> table, th, td { color: grey; border: 2px solid lightblue; border-collapse: collapse; padding: 30px; } </style> <?php function nb($s, $nbeleves) { return intval(mysql_fetch_assoc(mysql_query("SELECT COUNT(*) as total FROM Note where CodeMatiere=\"{$s}\""))['total']) / $nbeleves * 100; } mysql_connect('localhost', 'root', 'mohamed'); mysql_select_db('BDdevoir1'); echo "<table align='center'>"; // Obtenir le numero d'eleves $q = mysql_query("SELECT COUNT(*) as total FROM Eleve"); $nbeleves = mysql_fetch_assoc($q)['total']; $nbAlgo = nb("Algo", $nbeleves); $nbTic = nb("TIC", $nbeleves); $nbBD = nb("BD", $nbeleves); echo "<tr><td>Algorithmique</td><td>BD</td><td>TIC</td></tr>"; echo "<tr><td>{$nbAlgo}%</td> <td>{$nbBD}%</td> <td>{$nbTic}%</td> </tr>"; echo "</table>"; mysql_close(); ?> </html>
<?php } ?> <tfoot style="font-weight: bolder"> <tr> <td style="width: auto" colspan="<?php echo count($plan) + 1; ?> "> <?php echo _('Total'); ?> </td> <td class="num"> <span id="total_key"><?php echo nb($tot_key); ?> </span>% </td> </tr> </tfoot> </table> <input type="button" class="smallbutton" value="<?php echo _('Ajout ligne'); ?> " onclick="add_row_key('key_account_tb');"> <div> <div> <h2> <?php
if (isset($_GET['new']) && !empty($_GET['new'])) { echo "<div class=\"alert alert-warning alert-dismissible fade in\" role=\"alert\"> <a href=\"find.php?nextid=0\" type=\"button\" class=\"close\" \naria-label=\"Close\"><span aria-hidden=\"true\">×</span></a> <strong>New at Wikimedia Commons?</strong> You should probably read <a href=\"https://commons.wikimedia.org/wiki/Commons:Welcome\">Commons:Welcome</a> first! :-)</div>"; } ?> <div class="jumbotron"> <h2><?php par('data/find.txt'); ?> </h2> <br><br> <p> <a class="btn btn-lg btn-primary" href="find.php?nextid=<?php echo rand(111, 99999); ?> " role="button"><?php nb(); ?> »</a> </p> </div> <small><div style = "float: left;"><a href="index.php">home</a> | <a href="javascript:history.back()">back</a></div> <div style="text-align: right;"><?php help("<span class=\"caret\"></span> "); ?> <a href="find.php?help<?php help("back"); ?> ">help</a></div></small> <?php help("<br><div class=\"alert alert-info alert-dismissible fade in\" role=\"alert\"> <a href=\"find.php?nextid=0\" type=\"button\" class=\"close\" \naria-label=\"Close\"><span aria-hidden=\"true\">×</span></a> <strong>Help</strong><br>This pags shows random stuff/tasks which you can do for Wikimedia Commons.<br><br>\n If you are looking for a general overview you can take a look at <a href=\"https://commons.wikimedia.org/wiki/Commons:Welcome\">Commons:Welcome</a> and <a href=\"https://commons.wikimedia.org/wiki/Commons:Community_portal\">Commons:Community portal</a>.</div>"); echo "</div>"; footer();
function export_csv($p_date_start, $p_let) { $nb_fiche = count($this->afiche); $title = sprintf('"%s";', _('QuickCode')); $title .= sprintf('"%s";', _('Nom')); $title .= sprintf('"%s";', _('Prénom')); $title .= sprintf('"%s";', _('Date')); $title .= sprintf('"%s";', _('N° pièce')); $title .= sprintf('"%s";', _('Interne')); $title .= sprintf('"%s";', _('Fin')); $title .= sprintf('"%s";', _('<30 jours')); $title .= sprintf('"%s";', _('entre 30 et 60 jours')); $title .= sprintf('"%s";', _('entre 60 et 90 jours')); $title .= sprintf('"%s";', _('> 90 jours')); $title .= sprintf("\n\r"); $flag_title = false; for ($i = 0; $i < $nb_fiche; $i++) { $card = new Lettering_Card($this->cn, $this->afiche[$i]['quick_code']); $card->set_parameter('start', $p_date_start); $card->get_balance_ageing($p_let); if (empty($card->content)) { continue; } if (!$flag_title) { echo $title; $flag_title = true; } $nb_row = count($card->content); $sum_lt_30 = 0; $sum_gt_30_lt_60 = 0; $sum_gt_60_lt_90 = 0; $sum_gt_90 = 0; $sum_fin = 0; for ($j = 0; $j < $nb_row; $j++) { $show = true; printf('"%s";', str_replace('"', '', $this->afiche[$i]['quick_code'])); printf('"%s";', str_replace('"', '', $this->afiche[$i]['name'])); printf('"%s";', str_replace('"', '', $this->afiche[$i]['first_name'])); printf('"%s";', $card->content[$j]['j_date_fmt']); printf('"%s";', $card->content[$j]['jr_pj_number']); printf('"%s";', $card->content[$j]['jr_internal']); if ($card->content[$j]['jrn_def_type'] == 'FIN' || $card->content[$j]['jrn_def_type'] == 'ODS') { printf("%s;", nb($card->content[$j]['j_montant'])); $sum_fin = bcadd($sum_fin, $card->content[$j]['j_montant']); $show = false; } else { printf('0;'); } if ($show && $card->content[$j]['day_paid'] <= 30) { printf("%s;", nb($card->content[$j]['j_montant'])); $sum_lt_30 = bcadd($sum_lt_30, $card->content[$j]['j_montant']); $show = false; } else { printf('0;'); } if ($show && $card->content[$j]['day_paid'] > 30 && $card->content[$j]['day_paid'] <= 60) { printf("%s;", nb($card->content[$j]['j_montant'])); $sum_gt_30_lt_60 = bcadd($sum_gt_30_lt_60, $card->content[$j]['j_montant']); } else { printf('0;'); } if ($show && $card->content[$j]['day_paid'] > 60 && $card->content[$j]['day_paid'] <= 90) { printf("%s;", nb($card->content[$j]['j_montant'])); $sum_gt_60_lt_90 = bcadd($sum_gt_60_lt_90, $card->content[$j]['j_montant']); } else { printf('0;'); } if ($show && $card->content[$j]['day_paid'] > 90) { printf("%s", nb($card->content[$j]['j_montant'])); $sum_gt_90 = bcadd($sum_gt_90, $card->content[$j]['j_montant']); } else { printf('0;'); } printf("\n\r"); } printf('"%s";', _('Totaux')); printf('"";'); printf('"";'); printf('"";'); printf('"";'); printf('"";'); printf('%s;', nb($sum_fin)); printf('%s;', nb($sum_lt_30)); printf('%s;', nb($sum_gt_30_lt_60)); printf('%s;', nb($sum_gt_60_lt_90)); printf('%s', nb($sum_gt_90)); printf("\n\r"); } }
$tva_dna = $line['tva_dna'] == 0 ? "" : nbm($line['tva_dna']); $tot['tva_nd'] = bcadd($tot['tva_nd'], floatval($line['tva_dna'])); echo "<TD class=\"num\">" . $tva_dna . "</TD>"; $a_tva_amount = array(); foreach ($line['TVA'] as $lineTVA) { foreach ($a_Tva as $idx => $line_tva) { if ($line_tva['tva_id'] == $lineTVA[1][0]) { $a = $line_tva['tva_id']; $a_tva_amount[$a] = $lineTVA[1][2]; } } } foreach ($a_Tva as $line_tva) { $a = $line_tva['tva_id']; if (isset($a_tva_amount[$a])) { echo '<td class="num">' . nb($a_tva_amount[$a]) . '</td>'; $tot['tva'][$a] = isset($tot['tva'][$a]) ? bcadd($tot['tva'][$a], floatval($a_tva_amount[$a])) : floatval($a_tva_amount[$a]); } else { printf("<td class=\"num\"></td>"); } } } echo '<td class="num">' . $line['TVAC'] . '</td>'; $tot['tvac'] = bcadd($tot['tvac'], floatval($line['TVAC'])); /* * If reconcile print them */ echo '<td>'; $max = Database::num_row($ret_reconcile); if ($max > 0) { $sep = "";
/** * with the handle of a successull query, echo each row into CSV and * send it directly * @param type $array of data * @param type $aheader double array, each item of the array contains * a key type (num) and a key title */ static function array_to_csv($array, $aheader) { $seq = ""; for ($i = 0; $i < count($aheader); $i++) { echo $seq . '"' . $aheader[$i]['title'] . '"'; $seq = ";"; } printf("\r"); $seq = ""; // fetch all the rows for ($i = 0; $i < count($array); $i++) { $row = $array[$i]; $sep2 = ""; $e = 0; // for each rows, for each value foreach ($array[$i] as $key => $value) { if ($e > count($aheader)) { $e = 0; } if (isset($aheader[$e]['type'])) { switch ($aheader[$e]['type']) { case 'num': echo $sep2 . nb($value); break; default: echo $sep2 . '"' . $value . '"'; } } else { echo '"' . $value . '"' . $sep2; } $sep2 = ";"; $e++; } printf("\r"); } }
function export_csv() { bcscale(2); if ($this->check() != 0) { throw new Exception(_("date invalide")); } //--------------------------------------------------------------------------- // Card - Acc //--------------------------------------------------------------------------- if ($this->card_poste == '1') { $this->load_card(); /* * Show all the result */ $prev = ''; for ($i = 0; $i < count($this->arow); $i++) { printf('"%s";" %s"', $this->arow[$i]['j_qcode'], $this->arow[$i]['name']); $amount = $this->arow[$i]['sum_amount']; if ($amount == null) { $amount = 0; } printf(';"%s";" %s";', $this->arow[$i]['po_name'], $this->arow[$i]['po_description']); printf("%s", nb($amount)); printf("\r\n"); } } //--------------------------------------------------------------------------- // Accountancy - Analytic //--------------------------------------------------------------------------- if ($this->card_poste == '2') { $this->load_poste(); /* * Show all the result */ for ($i = 0; $i < count($this->arow); $i++) { printf('"%s";" %s"', $this->arow[$i]['j_poste'], $this->arow[$i]['name']); $amount = $this->arow[$i]['sum_amount']; if ($amount == null) { $amount = 0; } printf(';"%s";" %s";', $this->arow[$i]['po_name'], $this->arow[$i]['po_description']); printf("%s", nb($amount)); printf("\r\n"); } } //--------------------------------------------------------------------------- // Acc after card //--------------------------------------------------------------------------- if ($this->card_poste == '3') { $this->load_anc_card(); /* * Show all the result */ for ($i = 0; $i < count($this->arow); $i++) { printf('"%s";" %s";', $this->arow[$i]['po_name'], $this->arow[$i]['po_description']); $amount = $this->arow[$i]['sum_amount']; if ($amount == null) { $amount = 0; } printf('"%s";"%s";', $this->arow[$i]['j_qcode'], $this->arow[$i]['name']); printf("%s", nb($amount)); printf("\r\n"); } } //--------------------------------------------------------------------------- // Analytic - Accountancy //--------------------------------------------------------------------------- if ($this->card_poste == '4') { $this->load_anc_account(); /* * Show all the result */ for ($i = 0; $i < count($this->arow); $i++) { printf('"%s";"%s";', $this->arow[$i]['po_name'], $this->arow[$i]['po_description']); $amount = $this->arow[$i]['sum_amount']; if ($amount == null) { $amount = 0; } printf('"%s";"%s";', $this->arow[$i]['j_poste'], $this->arow[$i]['name']); printf("%s", nb($amount)); printf("\r\n"); } } }
*/ $progress = 0; $current_exercice = $op['p_exercice']; $tot_deb = 0; $tot_cred = 0; } $diff = bcsub($op['deb_montant'], $op['cred_montant']); $progress = bcadd($progress, $diff); $tot_deb = bcadd($tot_deb, $op['deb_montant']); $tot_cred = bcadd($tot_cred, $op['cred_montant']); echo '"' . $op['j_qcode'] . '";' . '"' . $op['j_date_fmt'] . '"' . ";" . '"' . $op['jr_pj_number'] . '"' . ";" . '"' . $op['jr_internal'] . '"' . ";" . '"' . $op['jrn_def_code'] . '"' . ";" . '"' . $op['jrn_def_name'] . '"' . ";" . '"' . $op['description'] . '"' . ";" . nb($op['deb_montant']) . ";" . nb($op['cred_montant']) . ";" . nb(abs($progress)) . ';' . '"' . ($op['letter'] == -1 ? '' : strtoupper(base_convert($op['letter'], 10, 36))) . '"'; printf("\n"); } } else { echo '"Poste";"Qcode";"date";"ref";"internal";'; echo "\"Description\";" . "\"Montant\";" . "\"D/C\""; printf("\r\n"); foreach ($Fiche->row as $op) { $acc = new Acc_Operation($cn); $acc->jr_id = $op['jr_id']; $result = $acc->get_jrnx_detail(); foreach ($result as $r) { printf('"%s";"%s";"%s";"%s";"%s";%s;%s;"%s"', $r['j_poste'], $r['j_qcode'], $r['jr_date'], $op['jr_pj_number'], $r['jr_internal'], $r['description'], nb($r['j_montant']), $r['debit']); printf("\r\n"); } } } $solde_type = $tot_deb > $tot_cred ? "solde débiteur" : "solde créditeur"; $diff = abs($tot_deb - $tot_cred); printf('"' . "{$solde_type}" . '"' . ";" . nb($diff) . ";" . nb($tot_deb) . ";" . nb($tot_cred) . "\n"); exit;
function display_csv() { $r = ""; $r .= '"Poste comptable Analytique";'; $r .= '"Poste comptable Analytique";'; $r .= '"Debit";'; $r .= '"Credit";'; $r .= '"Solde";'; $r .= '"D/C"'; $r .= "\r\n"; $array = $this->load(); if (is_array($array) == false) { return $array; } foreach ($array as $row) { $r .= sprintf('"%s";', $row['a_po_name']); $r .= sprintf('"%s";', $row['b_po_name']); $r .= sprintf("%s;", nb($row['a_d'])); $r .= sprintf("%s;", nb($row['a_c'])); $r .= sprintf("%s;", nb($row['a_solde'])); $r .= sprintf('"%s"', $row['a_debit']); $r .= "\r\n"; } return $r; }
$solde += $detail['deb_montant']; $solde_d += $detail['deb_montant']; } echo $detail['j_date_fmt'] . ";"; echo $detail['jr_internal'] . ";"; echo $detail['description'] . ";"; echo $detail['jr_pj_number'] . ";"; if ($detail['letter'] == -1) { echo ';'; } else { echo $detail['letter'] . ";"; } echo ($detail['deb_montant'] > 0 ? nb($detail['deb_montant']) : '') . ";"; echo ($detail['cred_montant'] > 0 ? nb($detail['cred_montant']) : '') . ";"; echo nb(abs($solde)) . ";"; echo $Poste->get_amount_side($solde); printf("\n"); } echo ";"; echo '"' . $current_exercice . '";'; echo ";"; echo ";"; echo 'Total du compte ' . $Poste->id . ";"; echo ($solde_d > 0 ? nb($solde_d) : '') . ";"; echo ($solde_c > 0 ? nb($solde_c) : '') . ";"; echo nb(abs($solde_c - $solde_d)) . ";"; echo ($solde_c > $solde_d ? 'C' : 'D') . ";"; printf("\n"); printf("\n"); } exit;
?> </td> <?php if ($this->content[$i]['j_debit'] == 't') { ?> <td style="text-align:right"> <?php echo nb($this->content[$i]['j_montant']); ?> </td> <td></td> <?php } else { ?> <td></td> <td style="text-align:right"> <?php echo nb($this->content[$i]['j_montant']); ?> </td> <?php } ?> <td style="text-align:center"> <?php // Rapprochement $rec = new Acc_Reconciliation($this->db); $rec->set_jr_id($this->content[$i]['jr_id']); $a = $rec->get(); if ($a != null) { foreach ($a as $key => $element) { $operation = new Acc_Operation($this->db); $operation->jr_id = $element;
//- set all TVA to 0 foreach ($a_Tva as $l) { $t_id = $l["tva_id"]; $a_tva_amount[$t_id] = 0; } foreach ($line['TVA'] as $lineTVA) { $idx_tva = $lineTVA[1][0]; $a_tva_amount[$idx_tva] = $lineTVA[1][2]; } if ($own->MY_TVA_USE == 'Y') { foreach ($a_Tva as $line_tva) { $a = $line_tva['tva_id']; echo nb($a_tva_amount[$a]) . ';'; } } echo nb($line['TVAC']); /** * Retrieve payment if any */ $ret_reconcile = $cn->execute('reconcile_date', array($line['jr_id'])); $max = Database::num_row($ret_reconcile); if ($max > 0) { $sep = ";"; for ($e = 0; $e < $max; $e++) { $row = Database::fetch_array($ret_reconcile, $e); echo $sep . $row['str_date'] . '; ' . $row['jr_internal']; } } printf("\r\n"); } }