22if (!defined(
'ALLOWED'))
23 die(
'Appel direct ne sont pas permis');
33$row=
$cn->get_row(
"select distinct oa_group,
34 to_char(oa_date,'DD.MM.YYYY') as str_date ,
40 operation_analytique as oa
41 join poste_analytique using (po_id)
42 left join (select jr_id,jr_pj_number,j_id from jrn join jrnx on (jr_grpt_id=j_grpt) ) as m on (m.j_id=oa.j_id)
45echo
$row[
'str_date'],
' ',
47 h(
$row[
'jr_pj_number']);
48$a_row=
$cn->get_array(
"select distinct oa_row from operation_analytique where oa_group=$1",array(
$oa_group));
49$a_plan=
$cn->get_array(
"select distinct pa_id,pa_name from operation_analytique join poste_analytique using (po_id) join plan_analytique using (pa_id) where oa_group=$1 order by pa_name",array(
$oa_group));
52echo
'<table class="result">';
56echo
th(_(
'Montant'),
'style="text-align:right"');
63 echo
'<tr class="'.$class.
'">';
66 $f_id=
$cn->get_value(
"select distinct f_id from operation_analytique where oa_group = $1 and oa_row=$2",[
$oa_group,
$a_row[
$i][
'oa_row']]);
71 $detail_row=
$cn->get_row(
"select po_name , oa_amount,oa_positive ,oa_debit
72 from operation_analytique
73 join poste_analytique using (po_id)
74 join plan_analytique using (pa_id)
79 echo
td($detail_row[
'po_name']);
81 $amount=$detail_row[
'oa_amount'];
83 echo
td(
$amount,
'style="text-align:right"');
84 $debit=($detail_row[
'oa_debit'] ==
'f')?
"C":
"D";
90echo
'<ul class="aligned-block">';
th($p_string, $p_extra='', $raw='')
td($p_string='', $p_extra='')
surround the string with td
h( $row[ 'oa_description'])