Author: danydb Date: 2012-06-22 19:10:06 +0200 (Fri, 22 Jun 2012) New Revision: 4980
Added: phpcompta/trunk/include/fiche.inc.php Removed: phpcompta/trunk/include/impress_fiche.inc.php Log: rename impress_fiche.inc.php to fiche.inc.php Copied: phpcompta/trunk/include/fiche.inc.php (from rev 4979, phpcompta/trunk/include/impress_fiche.inc.php) =================================================================== --- phpcompta/trunk/include/fiche.inc.php (rev 0) +++ phpcompta/trunk/include/fiche.inc.php 2012-06-22 17:10:06 UTC (rev 4980) @@ -0,0 +1,368 @@ +<?php +/* + * This file is part of PhpCompta. + * + * PhpCompta is free software; you can redistribute it and/or modify + * it under the terms of the GNU General Public License as published by + * the Free Software Foundation; either version 2 of the License, or + * (at your option) any later version. + * + * PhpCompta is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + * GNU General Public License for more details. + * + * You should have received a copy of the GNU General Public License + * along with PhpCompta; if not, write to the Free Software + * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA +*/ +/* $Revision$ */ +// Copyright Author Dany De Bontridder [email protected] +/*!\file + * \brief printing of category of card : balance, historic + */ +include_once('class_database.php'); +include_once('class_fiche.php'); +require_once('class_lettering.php'); + +$gDossier=dossier::id(); +$cn=new Database($gDossier); +global $g_user,$g_failed;; + +/** + * Show first the form + */ +/* category */ +$categorie=new ISelect('cat'); +$categorie->value=$cn->make_array('select fd_id,fd_label from fiche_def order by fd_label'); +$categorie->selected=(isset($_GET['cat']))?$_GET['cat']:0; +$str_categorie=$categorie->input(); + +$icall=new ICheckBox("allcard",1); +$icall->selected=(isset($_GET['allcard']))?1:0; +$str_icall=$icall->input(); +/* periode */ +$exercice=$g_user->get_exercice(); +$iperiode=new Periode($cn); +list ($first,$last)=$iperiode->get_limit($exercice); + +$periode_start=new IDate('start'); +$periode_end=new IDate('end'); + +$periode_start->value=(isset($_GET['start']))?$_GET['start']:$first->first_day(); +$periode_end->value=(isset($_GET['end']))?$_GET['end']:$last->last_day(); + +$str_start=$periode_start->input(); +$str_end=$periode_end->input(); + +/* histo ou summary */ +$histo=new ISelect('histo'); +$histo->value=array( + array('value'=>0,'label'=>_('Historique')), + array('value'=>1,'label'=>_('Historique Lettré')), + array('value'=>6,'label'=>_('Historique Lettré et montants différents')), + array('value'=>2,'label'=>_('Historique non Lettré')), + array('value'=>3,'label'=>_('Résumé')), + array('value'=>4,'label'=>_('Balance')), + array('value'=>5,'label'=>_('Balance non soldée' )) + ); +$histo->javascript='onchange="if (this.value==3) { + g("trstart").style.display="none";g("trend").style.display="none";g("allcard").style.display="none";} + else {g("trstart").style.display="";g("trend").style.display="";g("allcard").style.display="";}"'; + +$histo->selected=(isset($_GET['histo']))?$_GET['histo']:3; +$str_histo=$histo->input(); +echo '<div class="content">'; +echo '<FORM method="GET">'; +echo dossier::hidden(); +echo HtmlInput::hidden('ac',$_GET['ac']); +require_once('template/impress_cat_card.php'); +echo HtmlInput::submit('cat_display',_('Recherche')); +echo '</FORM>'; +$str="if (g('histo').value==3) { + g('trstart').style.display='none';g('trend').style.display='none';g('allcard').style.display='none';} + else {g('trstart').style.display='';g('trend').style.display='';g('allcard').style.display='';}"; +echo create_script($str); +echo '<hr>'; +//----------------------------------------------------- +if ( ! isset($_GET['cat_display'])) + exit(); + +$array=Fiche::get_fiche_def($cn,$_GET['cat'],'name_asc'); + +/* + * You show now the result + */ +if ($array == null ) +{ + echo '<h2 class="info2"> Aucune fiche trouvée</h2>'; + exit(); +} + +$allcard=(isset($_GET['allcard']))?1:0; +// summary +if ( $_GET['histo'] == 3 ) +{ + $cat_card=new Fiche_Def($cn); + $cat_card->id=$_GET['cat']; + $aHeading=$cat_card->getAttribut(); + require_once('template/result_cat_card_summary.php'); + + $hid=new IHidden(); + echo '<form method="GET" ACTION="export.php">'.dossier::hidden(). + HtmlInput::submit('bt_csv',"Export CSV"). + HtmlInput::hidden('act',"CSV:fiche"). + $hid->input("type","fiche"). + $hid->input("ac",$_REQUEST['ac']). + $hid->input("fd_id",$_REQUEST['cat']); + echo "</form>"; + + exit(); +} +$export_pdf='<FORM METHOD="get" ACTION="export.php" style="display:inline">'; +$export_pdf.=HtmlInput::hidden('cat',$_GET['cat']); +$export_pdf.=HtmlInput::hidden('act',"PDF:fiche_balance"). +$export_pdf.=HtmlInput::hidden('start',$_GET['start']); +$export_pdf.=HtmlInput::hidden('end',$_GET['end']); +$export_pdf.=HtmlInput::hidden('histo',$_GET['histo']); +$export_pdf.=HtmlInput::request_to_hidden(array('allcard')); +$export_pdf.=dossier::hidden(); +$export_pdf.=HtmlInput::submit('pdf','Export en PDF'); +$export_pdf.='</FORM>'; + +$export_print=HtmlInput::print_window(); + +$export_csv='<FORM METHOD="get" ACTION="export.php" style="display:inline">'; +$export_csv.=HtmlInput::hidden('cat',$_GET['cat']); +$export_csv.=HtmlInput::hidden('act','CSV:fiche_balance'); +$export_csv.=HtmlInput::hidden('start',$_GET['start']); +$export_csv.=HtmlInput::hidden('end',$_GET['end']); +$export_csv.=HtmlInput::hidden('histo',$_GET['histo']); +$export_csv.=HtmlInput::request_to_hidden(array('allcard')); +$export_csv.=dossier::hidden(); +$export_csv.=HtmlInput::submit('CSV','Export en CSV'); +$export_csv.='</FORM>'; + +// Balance +if ( $_GET['histo'] == 4 || $_GET['histo']==5 ) +{ + if ( isDate($_REQUEST['start']) == null || isDate ($_REQUEST['end']) == null ) + { + echo h2('Date invalide !','class="error"'); + alert('Date invalide !'); + exit; + } + echo $export_pdf; + echo $export_csv; + echo $export_print; + + $fd=new Fiche_Def($cn,$_REQUEST['cat']); + if ( $allcard==0 && $fd->hasAttribute(ATTR_DEF_ACCOUNT) == false ) + { + echo alert("Cette catégorie n'ayant pas de poste comptable n'a pas de balance"); + exit; + } + // all card + if ($allcard==1) + { + $afiche=$cn->get_array("select fd_id from vw_fiche_def where ad_id=".ATTR_DEF_ACCOUNT." order by fd_label asc"); + } + else + { + $afiche[0]=array('fd_id'=>$_REQUEST['cat']); + } + + for ($e=0;$e<count($afiche);$e++) + { + $ret=$cn->exec_sql("select f_id,ad_value from fiche join fiche_detail using(f_id) where fd_id=$1 and ad_id=1 order by 2 ",array($afiche[$e]['fd_id'])); + if ( $cn->count()==0 ) + { + if ( $allcard==0) { + echo "Aucune fiche trouvée"; + exit; + } else + continue; + } + echo '<h2>'.$cn->get_value("select fd_label from fiche_def where fd_id=$1",array($afiche[$e]['fd_id'])).'</h2>'; + echo '<table class="result" style="width:80%;margin-left:10%">'; + echo tr( + th('Quick Code'). + th('Libellé'). + th('Débit','style="text-align:right"'). + th('Crédit','style="text-align:right"'). + th('Solde','style="text-align:right"'). + th('D/C','style="text-align:right"') + ); + $idx=0; + for ($i=0;$i < Database::num_row($ret);$i++) + { + $filter= " (j_date >= to_date('".$_REQUEST['start']."','DD.MM.YYYY') ". + " and j_date <= to_date('".$_REQUEST['end']."','DD.MM.YYYY')) "; + $aCard=Database::fetch_array($ret,$i); + $oCard=new Fiche($cn,$aCard['f_id']); + $solde=$oCard->get_solde_detail($filter); + if ( $solde['debit'] == 0 && $solde['credit']==0) continue; + /* only not purged card */ + if ($_GET['histo'] == 5 && $solde['debit'] == $solde['credit']) continue; + $class=''; + if ( $idx%2 == 0) $class='class="odd"'; + $idx++; + echo tr( + td(HtmlInput::history_card($oCard->id,$oCard->strAttribut(ATTR_DEF_QUICKCODE))). + td($oCard->strAttribut(ATTR_DEF_NAME)). + td(nbm($solde['debit']),'style="text-align:right"'). + td(nbm($solde['credit']),'style="text-align:right"'). + td(nbm(abs($solde['solde'])),'style="text-align:right"'). + td((($solde['debit']<$solde['credit'])?'CRED':'DEB'),'style="text-align:right"'), + $class + ); + + } + echo '</table>'; + } + echo $export_pdf; + echo $export_csv; + echo $export_print; + + exit(); +} +if ( isDate($_REQUEST['start']) == null || isDate ($_REQUEST['end']) == null ) +{ + echo h2('Date invalide !','class="error"'); + alert('Date invalide !'); + exit; +} +//---------------------------------------------------------------------------- +// for the lettering / history +//---------------------------------------------------------------------------- + +// all card +if ($allcard==1) +{ + $afiche=$cn->get_array("select fd_id from vw_fiche_def where ad_id=".ATTR_DEF_ACCOUNT." order by fd_label asc"); +} +else +{ + $afiche[0]=array('fd_id'=>$_REQUEST['cat']); +} +echo $export_csv; +echo $export_pdf; +echo $export_print; +$fiche=new Fiche($cn); +for ($e = 0; $e < count($afiche); $e++) +{ + $array = Fiche::get_fiche_def($cn, $afiche[$e]['fd_id'], 'name_asc'); + + foreach ($array as $card) + { + $row = new Fiche($cn, $card['f_id']); + $letter = new Lettering_Card($cn); + $letter->set_parameter('quick_code', $row->strAttribut(ATTR_DEF_QUICKCODE)); + $letter->set_parameter('start', $_GET['start']); + $letter->set_parameter('end', $_GET['end']); + // all + if ($_GET['histo'] == 0) + { + $letter->get_all(); + } + + // lettered + if ($_GET['histo'] == 1) + { + $letter->get_letter(); + } + // unlettered + if ($_GET['histo'] == 2) + { + $letter->get_unletter(); + } + if ( $_GET['histo'] == 6 ) + { + $letter->get_letter_diff(); + } + /* skip if nothing to display */ + if (count($letter->content) == 0) + continue; + $detail_card = HtmlInput::card_detail($row->strAttribut(ATTR_DEF_QUICKCODE), $row->strAttribut(ATTR_DEF_NAME)); + + echo '<h2 style="font-size:14px;text-align:left;margin-left:10;padding-left:50;border:solid 1px blue;width:25%;text-decoration:underline">' . $detail_card . '</h2>'; + + echo '<table style="width:80%;padding-left:10%;padding-right:10%">'; + echo '<tr>'; + echo th(_('Date')); + echo th(_('ref')); + echo th(_('Interne')); + echo th(_('Comm')); + echo th(_('Montant'), 'style="width:auto" colspan="2"'); + echo th(_('Prog.')); + echo th(_('Let.')); + echo '</tr>'; + $amount_deb = 0; + $amount_cred = 0; + $prog = 0; + bcscale(2); + for ($i = 0; $i < count($letter->content); $i++) + { + if ($i % 2 == 0) + echo '<tr class="even">'; + else + echo '<tr class="odd">'; + $row = $letter->content[$i]; + echo td($row['j_date_fmt']); + echo td(h($row['jr_pj_number'])); + echo td(HtmlInput::detail_op($row['jr_id'], $row['jr_internal'])); + echo td(h($row['jr_comment'])); + if ($row['j_debit'] == 't') + { + echo td(nbm($row['j_montant']), ' style="text-align:right"'); + $amount_deb+=$row['j_montant']; + $prog = bcadd($prog, $row['j_montant']); + echo td(""); + } + else + { + echo td(""); + echo td(nbm($row['j_montant']), ' style="text-align:right"'); + $amount_cred+=$row['j_montant']; + $prog = bcsub($prog, $row['j_montant']); + } + $side=" ".$fiche->get_amount_side($prog); + echo td(nbm($prog).$side, 'style="text-align:right"'); + if ($row['letter'] != -1) + { + $span_error=""; + if ( $row['letter_diff'] != 0 ) $span_error=$g_failed; + echo td($row['letter'].$span_error); + } + else + echo td(''); + echo '</tr>'; + } + echo '</table>'; + echo '<table>'; + echo '<tr>'; + echo td(_('Debit')); + echo td(nbm($amount_deb), ' style="font-weight:bold;text-align:right"'); + echo '</tr>'; + echo '<tr>'; + echo td(_('Credit')); + echo td(nbm($amount_cred), ' style="font-weight:bold;text-align:right"'); + echo '</tr>'; + echo '<tr>'; + if ($amount_deb > $amount_cred) + $s = 'solde débiteur'; + else + $s = 'solde crediteur'; + echo td($s); + echo td(nbm(abs(round($amount_cred - $amount_deb, 2))), ' style="font-weight:bold;text-align:right"'); + echo '</tr>'; + echo '</table>'; + } +} +echo $export_csv; +echo $export_pdf; +echo $export_print; + + +?> + Deleted: phpcompta/trunk/include/impress_fiche.inc.php =================================================================== --- phpcompta/trunk/include/impress_fiche.inc.php 2012-06-22 17:09:29 UTC (rev 4979) +++ phpcompta/trunk/include/impress_fiche.inc.php 2012-06-22 17:10:06 UTC (rev 4980) @@ -1,368 +0,0 @@ -<?php -/* - * This file is part of PhpCompta. - * - * PhpCompta is free software; you can redistribute it and/or modify - * it under the terms of the GNU General Public License as published by - * the Free Software Foundation; either version 2 of the License, or - * (at your option) any later version. - * - * PhpCompta is distributed in the hope that it will be useful, - * but WITHOUT ANY WARRANTY; without even the implied warranty of - * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the - * GNU General Public License for more details. - * - * You should have received a copy of the GNU General Public License - * along with PhpCompta; if not, write to the Free Software - * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA -*/ -/* $Revision$ */ -// Copyright Author Dany De Bontridder [email protected] -/*!\file - * \brief printing of category of card : balance, historic - */ -include_once('class_database.php'); -include_once('class_fiche.php'); -require_once('class_lettering.php'); - -$gDossier=dossier::id(); -$cn=new Database($gDossier); -global $g_user,$g_failed;; - -/** - * Show first the form - */ -/* category */ -$categorie=new ISelect('cat'); -$categorie->value=$cn->make_array('select fd_id,fd_label from fiche_def order by fd_label'); -$categorie->selected=(isset($_GET['cat']))?$_GET['cat']:0; -$str_categorie=$categorie->input(); - -$icall=new ICheckBox("allcard",1); -$icall->selected=(isset($_GET['allcard']))?1:0; -$str_icall=$icall->input(); -/* periode */ -$exercice=$g_user->get_exercice(); -$iperiode=new Periode($cn); -list ($first,$last)=$iperiode->get_limit($exercice); - -$periode_start=new IDate('start'); -$periode_end=new IDate('end'); - -$periode_start->value=(isset($_GET['start']))?$_GET['start']:$first->first_day(); -$periode_end->value=(isset($_GET['end']))?$_GET['end']:$last->last_day(); - -$str_start=$periode_start->input(); -$str_end=$periode_end->input(); - -/* histo ou summary */ -$histo=new ISelect('histo'); -$histo->value=array( - array('value'=>0,'label'=>_('Historique')), - array('value'=>1,'label'=>_('Historique Lettré')), - array('value'=>6,'label'=>_('Historique Lettré et montants différents')), - array('value'=>2,'label'=>_('Historique non Lettré')), - array('value'=>3,'label'=>_('Résumé')), - array('value'=>4,'label'=>_('Balance')), - array('value'=>5,'label'=>_('Balance non soldée' )) - ); -$histo->javascript='onchange="if (this.value==3) { - g("trstart").style.display="none";g("trend").style.display="none";g("allcard").style.display="none";} - else {g("trstart").style.display="";g("trend").style.display="";g("allcard").style.display="";}"'; - -$histo->selected=(isset($_GET['histo']))?$_GET['histo']:3; -$str_histo=$histo->input(); -echo '<div class="content">'; -echo '<FORM method="GET">'; -echo dossier::hidden(); -echo HtmlInput::hidden('ac',$_GET['ac']); -require_once('template/impress_cat_card.php'); -echo HtmlInput::submit('cat_display',_('Recherche')); -echo '</FORM>'; -$str="if (g('histo').value==3) { - g('trstart').style.display='none';g('trend').style.display='none';g('allcard').style.display='none';} - else {g('trstart').style.display='';g('trend').style.display='';g('allcard').style.display='';}"; -echo create_script($str); -echo '<hr>'; -//----------------------------------------------------- -if ( ! isset($_GET['cat_display'])) - exit(); - -$array=Fiche::get_fiche_def($cn,$_GET['cat'],'name_asc'); - -/* - * You show now the result - */ -if ($array == null ) -{ - echo '<h2 class="info2"> Aucune fiche trouvée</h2>'; - exit(); -} - -$allcard=(isset($_GET['allcard']))?1:0; -// summary -if ( $_GET['histo'] == 3 ) -{ - $cat_card=new Fiche_Def($cn); - $cat_card->id=$_GET['cat']; - $aHeading=$cat_card->getAttribut(); - require_once('template/result_cat_card_summary.php'); - - $hid=new IHidden(); - echo '<form method="GET" ACTION="export.php">'.dossier::hidden(). - HtmlInput::submit('bt_csv',"Export CSV"). - HtmlInput::hidden('act',"CSV:fiche"). - $hid->input("type","fiche"). - $hid->input("ac",$_REQUEST['ac']). - $hid->input("fd_id",$_REQUEST['cat']); - echo "</form>"; - - exit(); -} -$export_pdf='<FORM METHOD="get" ACTION="export.php" style="display:inline">'; -$export_pdf.=HtmlInput::hidden('cat',$_GET['cat']); -$export_pdf.=HtmlInput::hidden('act',"PDF:fiche_balance"). -$export_pdf.=HtmlInput::hidden('start',$_GET['start']); -$export_pdf.=HtmlInput::hidden('end',$_GET['end']); -$export_pdf.=HtmlInput::hidden('histo',$_GET['histo']); -$export_pdf.=HtmlInput::request_to_hidden(array('allcard')); -$export_pdf.=dossier::hidden(); -$export_pdf.=HtmlInput::submit('pdf','Export en PDF'); -$export_pdf.='</FORM>'; - -$export_print=HtmlInput::print_window(); - -$export_csv='<FORM METHOD="get" ACTION="export.php" style="display:inline">'; -$export_csv.=HtmlInput::hidden('cat',$_GET['cat']); -$export_csv.=HtmlInput::hidden('act','CSV:fiche_balance'); -$export_csv.=HtmlInput::hidden('start',$_GET['start']); -$export_csv.=HtmlInput::hidden('end',$_GET['end']); -$export_csv.=HtmlInput::hidden('histo',$_GET['histo']); -$export_csv.=HtmlInput::request_to_hidden(array('allcard')); -$export_csv.=dossier::hidden(); -$export_csv.=HtmlInput::submit('CSV','Export en CSV'); -$export_csv.='</FORM>'; - -// Balance -if ( $_GET['histo'] == 4 || $_GET['histo']==5 ) -{ - if ( isDate($_REQUEST['start']) == null || isDate ($_REQUEST['end']) == null ) - { - echo h2('Date invalide !','class="error"'); - alert('Date invalide !'); - exit; - } - echo $export_pdf; - echo $export_csv; - echo $export_print; - - $fd=new Fiche_Def($cn,$_REQUEST['cat']); - if ( $allcard==0 && $fd->hasAttribute(ATTR_DEF_ACCOUNT) == false ) - { - echo alert("Cette catégorie n'ayant pas de poste comptable n'a pas de balance"); - exit; - } - // all card - if ($allcard==1) - { - $afiche=$cn->get_array("select fd_id from vw_fiche_def where ad_id=".ATTR_DEF_ACCOUNT." order by fd_label asc"); - } - else - { - $afiche[0]=array('fd_id'=>$_REQUEST['cat']); - } - - for ($e=0;$e<count($afiche);$e++) - { - $ret=$cn->exec_sql("select f_id,ad_value from fiche join fiche_detail using(f_id) where fd_id=$1 and ad_id=1 order by 2 ",array($afiche[$e]['fd_id'])); - if ( $cn->count()==0 ) - { - if ( $allcard==0) { - echo "Aucune fiche trouvée"; - exit; - } else - continue; - } - echo '<h2>'.$cn->get_value("select fd_label from fiche_def where fd_id=$1",array($afiche[$e]['fd_id'])).'</h2>'; - echo '<table class="result" style="width:80%;margin-left:10%">'; - echo tr( - th('Quick Code'). - th('Libellé'). - th('Débit','style="text-align:right"'). - th('Crédit','style="text-align:right"'). - th('Solde','style="text-align:right"'). - th('D/C','style="text-align:right"') - ); - $idx=0; - for ($i=0;$i < Database::num_row($ret);$i++) - { - $filter= " (j_date >= to_date('".$_REQUEST['start']."','DD.MM.YYYY') ". - " and j_date <= to_date('".$_REQUEST['end']."','DD.MM.YYYY')) "; - $aCard=Database::fetch_array($ret,$i); - $oCard=new Fiche($cn,$aCard['f_id']); - $solde=$oCard->get_solde_detail($filter); - if ( $solde['debit'] == 0 && $solde['credit']==0) continue; - /* only not purged card */ - if ($_GET['histo'] == 5 && $solde['debit'] == $solde['credit']) continue; - $class=''; - if ( $idx%2 == 0) $class='class="odd"'; - $idx++; - echo tr( - td(HtmlInput::history_card($oCard->id,$oCard->strAttribut(ATTR_DEF_QUICKCODE))). - td($oCard->strAttribut(ATTR_DEF_NAME)). - td(nbm($solde['debit']),'style="text-align:right"'). - td(nbm($solde['credit']),'style="text-align:right"'). - td(nbm(abs($solde['solde'])),'style="text-align:right"'). - td((($solde['debit']<$solde['credit'])?'CRED':'DEB'),'style="text-align:right"'), - $class - ); - - } - echo '</table>'; - } - echo $export_pdf; - echo $export_csv; - echo $export_print; - - exit(); -} -if ( isDate($_REQUEST['start']) == null || isDate ($_REQUEST['end']) == null ) -{ - echo h2('Date invalide !','class="error"'); - alert('Date invalide !'); - exit; -} -//---------------------------------------------------------------------------- -// for the lettering / history -//---------------------------------------------------------------------------- - -// all card -if ($allcard==1) -{ - $afiche=$cn->get_array("select fd_id from vw_fiche_def where ad_id=".ATTR_DEF_ACCOUNT." order by fd_label asc"); -} -else -{ - $afiche[0]=array('fd_id'=>$_REQUEST['cat']); -} -echo $export_csv; -echo $export_pdf; -echo $export_print; -$fiche=new Fiche($cn); -for ($e = 0; $e < count($afiche); $e++) -{ - $array = Fiche::get_fiche_def($cn, $afiche[$e]['fd_id'], 'name_asc'); - - foreach ($array as $card) - { - $row = new Fiche($cn, $card['f_id']); - $letter = new Lettering_Card($cn); - $letter->set_parameter('quick_code', $row->strAttribut(ATTR_DEF_QUICKCODE)); - $letter->set_parameter('start', $_GET['start']); - $letter->set_parameter('end', $_GET['end']); - // all - if ($_GET['histo'] == 0) - { - $letter->get_all(); - } - - // lettered - if ($_GET['histo'] == 1) - { - $letter->get_letter(); - } - // unlettered - if ($_GET['histo'] == 2) - { - $letter->get_unletter(); - } - if ( $_GET['histo'] == 6 ) - { - $letter->get_letter_diff(); - } - /* skip if nothing to display */ - if (count($letter->content) == 0) - continue; - $detail_card = HtmlInput::card_detail($row->strAttribut(ATTR_DEF_QUICKCODE), $row->strAttribut(ATTR_DEF_NAME)); - - echo '<h2 style="font-size:14px;text-align:left;margin-left:10;padding-left:50;border:solid 1px blue;width:25%;text-decoration:underline">' . $detail_card . '</h2>'; - - echo '<table style="width:80%;padding-left:10%;padding-right:10%">'; - echo '<tr>'; - echo th(_('Date')); - echo th(_('ref')); - echo th(_('Interne')); - echo th(_('Comm')); - echo th(_('Montant'), 'style="width:auto" colspan="2"'); - echo th(_('Prog.')); - echo th(_('Let.')); - echo '</tr>'; - $amount_deb = 0; - $amount_cred = 0; - $prog = 0; - bcscale(2); - for ($i = 0; $i < count($letter->content); $i++) - { - if ($i % 2 == 0) - echo '<tr class="even">'; - else - echo '<tr class="odd">'; - $row = $letter->content[$i]; - echo td($row['j_date_fmt']); - echo td(h($row['jr_pj_number'])); - echo td(HtmlInput::detail_op($row['jr_id'], $row['jr_internal'])); - echo td(h($row['jr_comment'])); - if ($row['j_debit'] == 't') - { - echo td(nbm($row['j_montant']), ' style="text-align:right"'); - $amount_deb+=$row['j_montant']; - $prog = bcadd($prog, $row['j_montant']); - echo td(""); - } - else - { - echo td(""); - echo td(nbm($row['j_montant']), ' style="text-align:right"'); - $amount_cred+=$row['j_montant']; - $prog = bcsub($prog, $row['j_montant']); - } - $side=" ".$fiche->get_amount_side($prog); - echo td(nbm($prog).$side, 'style="text-align:right"'); - if ($row['letter'] != -1) - { - $span_error=""; - if ( $row['letter_diff'] != 0 ) $span_error=$g_failed; - echo td($row['letter'].$span_error); - } - else - echo td(''); - echo '</tr>'; - } - echo '</table>'; - echo '<table>'; - echo '<tr>'; - echo td(_('Debit')); - echo td(nbm($amount_deb), ' style="font-weight:bold;text-align:right"'); - echo '</tr>'; - echo '<tr>'; - echo td(_('Credit')); - echo td(nbm($amount_cred), ' style="font-weight:bold;text-align:right"'); - echo '</tr>'; - echo '<tr>'; - if ($amount_deb > $amount_cred) - $s = 'solde débiteur'; - else - $s = 'solde crediteur'; - echo td($s); - echo td(nbm(abs(round($amount_cred - $amount_deb, 2))), ' style="font-weight:bold;text-align:right"'); - echo '</tr>'; - echo '</table>'; - } -} -echo $export_csv; -echo $export_pdf; -echo $export_print; - - -?> - --- PhpCompta est un logiciel de comptabilité libre en ligne (full web) Projet opensource http://www.phpcompta.eu _______________________________________________ Phpcompta est un logiciel libre de comptabilité en ligne (http://www.phpcompta.eu) Phpcompta-dev mailing list [email protected] https://lists.nongnu.org/mailman/listinfo/phpcompta-dev
