[Phpcompta-dev] r350 - in trunk/coprop: . include include/template

[phpcompta-dev]

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 address@hidden
+
+/**
+ * @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 address@hidden
+
+/**
+ * @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