'; echo '
'; echo HtmlInput::hidden('ac',$http->request('ac')); echo HtmlInput::hidden('type','gl_comptes'); echo dossier::hidden(); echo ''; $cn=Dossier::connect(); $periode=new Periode($cn); $a=$periode->get_limit($g_user->get_exercice()); // $a is an array $first_day=$a[0]->first_day(); $last_day=$a[1]->last_day(); // filter on period $date_from=new IDate('from_periode'); $date_to=new IDate('to_periode'); $year=$g_user->get_exercice(); $date_from->value=(isset($_REQUEST['from_periode'])&& isDate($_REQUEST['from_periode'])!=0)?$_REQUEST['from_periode']:$first_day; $date_to->value=(isset($_REQUEST['to_periode']) && isDate($_REQUEST['to_periode']) !=0 )?$_REQUEST['to_periode']:$last_day; echo td(_('Depuis').$date_from->input()); echo td(_('Jusque ').$date_to->input()); $letter=new ICheckbox('letter'); $letter->selected=(isset($_REQUEST['letter']))?true:false; $from_poste=new IPoste('from_poste'); $from_poste->value=$http->request('from_poste',"string",''); $from_poste->set_attribute('account','from_poste'); $to_poste=new IPoste('to_poste'); $to_poste->value=$http->request('to_poste',"string",''); $to_poste->set_attribute('account','to_poste'); $solded=new ICheckbox('solded'); $solded->selected=(isset($_REQUEST['solded']))?true:false; echo ''; echo td(_('Depuis le poste')).td($from_poste->input()); echo ''; echo ''; echo td(_("Jusqu'au poste")).td($to_poste->input()); echo ''; echo ''; echo td(_('Uniquement les opérations non lettrées')); echo td($letter->input()); echo ''; echo ''; echo td(_('Uniquement les comptes non soldés')); echo td($solded->input()); echo ''; // echo '
'; print HtmlInput::submit('bt_html',_('Visualisation')); echo '
'; echo '
'; echo ''; //----------------------------------------------------- // If print is asked // First time in html // after in pdf or cvs //----------------------------------------------------- if ( isset( $_REQUEST['bt_html'] ) ) { if ( DEBUGNOALYSS > 1 ) \Noalyss\Dbg::timer_start(); echo '
'; echo Acc_Account_Ledger::HtmlTableHeader("gl_comptes"); echo '
'; try { $from_periode=$http->request("from_periode","date"); $to_periode=$http->request("to_periode","date"); } catch (Exception $e) { echo alert(_('Date malformée, désolée')); return; } $a_accounting=Acc_Account_Ledger::get_used_accounting($from_periode,$to_periode,$from_poste->value,$to_poste->value); if ( sizeof($a_accounting) == 0 ) { echo_warning(_("Aucune donnée")); return; } echo '
'; echo ''; $l=(isset($_REQUEST['letter']))?2:0; $s=(isset($_REQUEST['solded']))?1:0; foreach ($a_accounting as $accounting_id ) { $acc_account_ledger=new Acc_Account_Ledger ($cn, $accounting_id['pcm_val']); $acc_account_ledger->get_row_date( $from_periode, $to_periode,$l,$s); if ( empty($acc_account_ledger->row)) { continue; } echo ''; echo ''; $solde = 0.0; $solde_d = 0.0; $solde_c = 0.0; bcscale(2); $i=0; $current_exercice=""; foreach ($acc_account_ledger->row as $detail) { /* * separation per exercice */ if ( $current_exercice == "") $current_exercice=$detail['p_exercice']; if ( $current_exercice != $detail['p_exercice']) { echo ''.td(""). ''. ''; /* * reset total and current_exercice */ $current_exercice=$detail['p_exercice']; $solde = 0.0; $solde_d = 0.0; $solde_c = 0.0; } if ($detail['cred_montant'] > 0) { $solde=bcsub($solde, $detail['cred_montant']); $solde_c=bcadd($solde_c,$detail['cred_montant']); } if ($detail['deb_montant'] > 0) { $solde = bcadd($solde,$detail['deb_montant']); $solde_d = bcadd($solde_d,$detail['deb_montant']); } $side=" ".$acc_account_ledger->get_amount_side($solde); $letter=""; $html_let=""; if ($detail['letter'] > 0) { $letter=strtoupper(base_convert($detail['letter'],10,36)); $html_let = HtmlInput::show_reconcile("", $letter); } $i++; if (($i % 2 ) == 0) $class="odd"; else $class="even"; echo ''; } echo ''.td(""). ''. ''; } echo '

'. $accounting_id['pcm_val'].' '.h($accounting_id['pcm_lib']).'

Date Référence Libellé Pièce Type Débit Crédit Solde Let.
'.$current_exercice.' '.''.' '._("Total du compte").$accounting_id['pcm_val'].' '.''.''.($solde_d > 0 ? nbm( $solde_d) : '').' '.($solde_c > 0 ? nbm( $solde_c) : '').' '.nbm( abs($solde_c-$solde_d)).' '; if ($solde_c > $solde_d ) echo _("Crédit"); if ($solde_c < $solde_d ) echo _("Débit"); if ($solde_c == $solde_d ) echo " "; echo '
'.$detail['j_date_fmt'].' '.HtmlInput::detail_op($detail['jr_id'],$detail['jr_internal']).' '.$detail['description'].' '.$detail['jr_pj_number'].' '.$detail['jr_optype'].' '.($detail['deb_montant'] > 0 ? nbm($detail['deb_montant']) : '').' '.($detail['cred_montant'] > 0 ? nbm($detail['cred_montant']) : '').' '.nbm(abs($solde)).$side.' '.$html_let.'
'.$current_exercice.' '.''.' '.''.'Total du compte '.$accounting_id['pcm_val'].''.' '.''.''.''.($solde_d > 0 ? nbm( $solde_d) : '').''.' '.''.($solde_c > 0 ? nbm( $solde_c) : '').''.' '.''.nbm( abs($solde_c-$solde_d)).''.' '; if ($solde_c > $solde_d ) echo "Crédit"; if ($solde_c < $solde_d ) echo "Débit"; if ($solde_c == $solde_d ) echo "="; echo '
'; echo Acc_Account_Ledger::HtmlTableHeader("gl_comptes"); echo "
"; if (DEBUGNOALYSS> 1) echo \Noalyss\Dbg::hidden_info("\$acc_account_ledger", $acc_account_ledger); if ( DEBUGNOALYSS > 1 ) \Noalyss\Dbg::timer_show(); return; } ?>