* */ /** * @file * @brief show the result of balance ageing, included from Balance_Age::display_purchase * @see Balance_Age */ bcscale(2); ?> <?php $nb_fiche = count($a_fiche); for ($i = 0; $i < $nb_fiche; $i++) { $card = new Lettering_Card($this->cn, $a_fiche[$i]['quick_code']); $card->set_parameter('start', $p_date_start); $card->get_balance_ageing($p_let); if (empty($card->content)) { continue; } echo HtmlInput::card_detail($a_fiche[$i]['quick_code'], h($a_fiche[$i]['name']) . ' ' . h($a_fiche[$i]['first_name'])); ?> <table class="result"> <tr> <th> <?php echo _('Date opération'); ?> </th> <th> <?php echo _('Pièce');
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"); } }