[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpcompta-dev] r350 - in trunk/coprop: . include include/template
From: |
phpcompta-dev |
Subject: |
[Phpcompta-dev] r350 - in trunk/coprop: . include include/template |
Date: |
Thu, 12 Apr 2012 02:19:48 +0200 (CEST) |
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
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpcompta-dev] r350 - in trunk/coprop: . include include/template,
phpcompta-dev <=