*
*/
/**
* @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");
}
}
