Author: danydb Date: 2012-04-12 02:19:47 +0200 (Thu, 12 Apr 2012) New Revision: 350
Added: trunk/coprop/include/historic.inc.php trunk/coprop/include/template/historic.php Modified: trunk/coprop/index.php Log: Ajout historique des appels de fond par budget et par montant Added: trunk/coprop/include/historic.inc.php =================================================================== --- trunk/coprop/include/historic.inc.php (rev 0) +++ trunk/coprop/include/historic.inc.php 2012-04-12 00:19:47 UTC (rev 350) @@ -0,0 +1,46 @@ +<?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 show history of call + * + */ +global $cn; + +$sql="select af_id,af_date,to_char(af_date,'DD.MM.YY') as str_date,af_percent,af_amount,af_card,af_ledger,af.jr_internal, +bd.b_id,bd.b_name,bd.b_exercice,bd.b_type,jrn.jr_id, +cr.cr_id,cr_name, +jrn_def_name +from +coprop.appel_fond as af +left join coprop.budget as bd on (af.b_id=bd.b_id) +left join coprop.clef_repartition as cr on (af.cr_id=cr.cr_id) +join jrn_def on (jrn_def_id=af_ledger) +join jrn on (jrn.jr_internal=af.jr_internal) +where af_confirmed='Y' +order by 2 +"; +$array=$cn->get_array($sql); +require_once 'template/historic.php'; +?> Added: trunk/coprop/include/template/historic.php =================================================================== --- trunk/coprop/include/template/historic.php (rev 0) +++ trunk/coprop/include/template/historic.php 2012-04-12 00:19:47 UTC (rev 350) @@ -0,0 +1,82 @@ +<?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 display history + * + */ +?> +<table class="result"> + <tr> + <th> + Date + </th> + <th> + Budget + </th> + <th> + Clef de répartition (appel par montant) + </th> + + <th> + Montant + </th> + <th> + Opération + </th> + <th> + Pourcentage + </th> + <th> + Exercice + </th> + + </tr> +<? for ($i=0;$i<count($array);$i++): ?> + <tr> + <td> + <?=$array[$i]['str_date']?> + </td> + <td> + <?=$array[$i]['b_name']?> + </td> + <td> + <?=$array[$i]['cr_name']?> + </td> + <td> + <?=nb($array[$i]['af_amount'])?> + </td> + <td> + <?=HtmlInput::detail_op($array[$i]['jr_id'], $array[$i]['jr_internal'])?> + </td> + <td> + <?=$array[$i]['af_percent']?> + </td> + <td> + <?=$array[$i]['b_exercice']?> + </td> + </tr> +<? endfor; ?> + +</table> \ No newline at end of file Modified: trunk/coprop/index.php =================================================================== --- trunk/coprop/index.php 2012-04-11 23:55:42 UTC (rev 349) +++ trunk/coprop/index.php 2012-04-12 00:19:47 UTC (rev 350) @@ -42,6 +42,7 @@ array($url.'&sa=cle',_('Clef de répartition'),_('Clef de répartition'),2), array($url.'&sa=af',_('Appel de fond'),_('Création décompte pour appel de fond'),3), array($url.'&sa=bu',_('Budget'),_('budgets'),5), + array($url.'&sa=hs',_('Historique'),_('Historique des appels'),6), array($url.'&sa=pa',_('Paramètre'),_('Configuration et paramètre'),4) ); @@ -64,6 +65,9 @@ case 'bu': $def=5; break; + case 'hs': + $def=6; + break; } $cn=new Database(dossier::id()); @@ -126,4 +130,10 @@ require_once('include/budget.inc.php'); exit(); } +if ($def==6) + { + require_once('include/historic.inc.php'); + exit(); + } + ?> --- 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
