[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Noalyss-commit] [noalyss] 53/173: Mantis #0001682: CA - ajouter possibi
From: |
Dany De Bontridder |
Subject: |
[Noalyss-commit] [noalyss] 53/173: Mantis #0001682: CA - ajouter possibilité d'exporter le plan analytique, missing file |
Date: |
Mon, 22 Mar 2021 12:58:39 -0400 (EDT) |
sparkyx pushed a commit to branch master
in repository noalyss.
commit 3d9693029d9f7cd2ec0d8a8ecb711ff27f801f00
Author: Dany De Bontridder <dany@alchimerys.be>
AuthorDate: Fri Jan 25 21:41:44 2019 +0100
Mantis #0001682: CA - ajouter possibilité d'exporter le plan analytique,
missing file
(cherry picked from commit a7ab86adc327ade448e984717f41f97bed75f152)
---
include/export/export_anc_axis_csv.php | 60 ++++++++++++++++++++++++++++++++++
1 file changed, 60 insertions(+)
diff --git a/include/export/export_anc_axis_csv.php
b/include/export/export_anc_axis_csv.php
new file mode 100644
index 0000000..81dfd8b
--- /dev/null
+++ b/include/export/export_anc_axis_csv.php
@@ -0,0 +1,60 @@
+<?php
+/*
+ * This file is part of NOALYSS.
+ *
+ * NOALYSS 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.
+ *
+ * NOALYSS 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 NOALYSS; if not, write to the Free Software
+ * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
+*/
+
+// Copyright Author Dany De Bontridder danydb@aevalys.eu
+/**
+ * @file
+ * Export ANALYTIC Axis in CSV
+ */
+if ( ! defined ('ALLOWED') ) die('Appel direct ne sont pas permis');
+
+require_once NOALYSS_INCLUDE.'/lib/noalyss_csv.class.php';
+$http=new HttpInput();
+$pa_id=$http->get("pa_id","number");
+$name=$cn->get_value("select pa_name from plan_analytique where pa_id=$1",
+ [$pa_id]);
+$array=$cn->get_array(" select
+ po_name,
+ po_amount,
+ po_description,
+ ga_description
+ from
+ poste_analytique
+ left join groupe_analytique using (ga_id)
+ where poste_analytique.pa_id=$1 order by po_name asc ",[$pa_id]);
+$output=new Noalyss_Csv($name);
+$output->send_header();
+$output->write_header([
+ _("Nom"),
+ _("Description"),
+ _("Montant"),
+ _("Groupe"),
+]);
+if ($array != FALSE )
+{
+ $nb_array=count($array);
+ for ($i=0;$i<$nb_array;$i++) {
+ $output->add($array[$i]['po_name']);
+ $output->add($array[$i]['po_description']);
+ $output->add($array[$i]['po_amount'],"number");
+ $output->add($array[$i]['ga_description']);
+ $output->write();
+ }
+
+}
\ No newline at end of file
- [Noalyss-commit] [noalyss] 22/173: Currency : Precision 6, (continued)
- [Noalyss-commit] [noalyss] 22/173: Currency : Precision 6, Dany De Bontridder, 2021/03/22
- [Noalyss-commit] [noalyss] 25/173: Currency : the meaning is : 1 euro is worth xxx Currency , so we divide the amount with the currency rate to compute the EUR value, Dany De Bontridder, 2021/03/22
- [Noalyss-commit] [noalyss] 29/173: Currency : purchase, save all detail also in currency, fix problem with the advance payment, Dany De Bontridder, 2021/03/22
- [Noalyss-commit] [noalyss] 33/173: Fix problem with total in balance export, Dany De Bontridder, 2021/03/22
- [Noalyss-commit] [noalyss] 31/173: Task #1660 : place the button for the inventory on the top, Dany De Bontridder, 2021/03/22
- [Noalyss-commit] [noalyss] 32/173: New function findSide return D if number is <0, Dany De Bontridder, 2021/03/22
- [Noalyss-commit] [noalyss] 35/173: Task #0001309: Association d'une opération avec elle-même., Dany De Bontridder, 2021/03/22
- [Noalyss-commit] [noalyss] 36/173: Merge branch 'r700-currency' of gitlab.noalyss.eu:noalyss/noalyss into r700-currency, Dany De Bontridder, 2021/03/22
- [Noalyss-commit] [noalyss] 41/173: PHP 7.2 incomptability : sizeof of not array, Dany De Bontridder, 2021/03/22
- [Noalyss-commit] [noalyss] 45/173: Database upgrade, Dany De Bontridder, 2021/03/22
- [Noalyss-commit] [noalyss] 53/173: Mantis #0001682: CA - ajouter possibilité d'exporter le plan analytique, missing file,
Dany De Bontridder <=
- [Noalyss-commit] [noalyss] 56/173: Mantis #1626: AFFICHAGE BALANCE FICHE - soldes nuls au débit, Dany De Bontridder, 2021/03/22
- [Noalyss-commit] [noalyss] 58/173: Mantis #1665: Pouvoir modifier l'ordre dans les listing de compta analytique, Dany De Bontridder, 2021/03/22
- [Noalyss-commit] [noalyss] 59/173: Mantis #1596: Dans le plan comptable, fiches non cliquables Les fiches sont cliquable dans Plan Comptable , PCMNCFG et dans la liste des postes, en plus on peut obtenir toutes les fiches d'un poste, Dany De Bontridder, 2021/03/22
- [Noalyss-commit] [noalyss] 42/173: Currency - fix view, Dany De Bontridder, 2021/03/22
- [Noalyss-commit] [noalyss] 52/173: Mantis #0001682: CA - ajouter possibilité d'exporter le plan analytique, add action CSV:Analytic_Axis, Dany De Bontridder, 2021/03/22
- [Noalyss-commit] [noalyss] 67/173: Wrong merge broke fiche.class.php, Dany De Bontridder, 2021/03/22
- [Noalyss-commit] [noalyss] 64/173: CSS : cosmetic, Dany De Bontridder, 2021/03/22
- [Noalyss-commit] [noalyss] 68/173: Fix broken merge, Dany De Bontridder, 2021/03/22
- [Noalyss-commit] [noalyss] 71/173: Cosmetic adapt color, Dany De Bontridder, 2021/03/22
- [Noalyss-commit] [noalyss] 74/173: TEST : fix some little bugs, Dany De Bontridder, 2021/03/22