[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Noalyss-commit] [noalyss] 05/16: Mantis #0001682: CA - ajouter possibi
From: |
Dany De Bontridder |
Subject: |
[Noalyss-commit] [noalyss] 05/16: Mantis #0001682: CA - ajouter possibilité d'exporter le plan analytique, add action CSV:Analytic_Axis |
Date: |
Sun, 3 Feb 2019 14:38:40 -0500 (EST) |
sparkyx pushed a commit to branch master
in repository noalyss.
commit a7ab86adc327ade448e984717f41f97bed75f152
Author: Dany De Bontridder <address@hidden>
Date: Fri Jan 25 21:41:44 2019 +0100
Mantis #0001682: CA - ajouter possibilité d'exporter le plan analytique,
add action CSV:Analytic_Axis
---
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 address@hidden
+/**
+ * @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] branch master updated (6956783 -> f39d9ca), Dany De Bontridder, 2019/02/03
- [Noalyss-commit] [noalyss] 01/16: translation, Dany De Bontridder, 2019/02/03
- [Noalyss-commit] [noalyss] 03/16: Mantis #0001666: Export CSV depuis histo ne filtre pas par journal, Dany De Bontridder, 2019/02/03
- [Noalyss-commit] [noalyss] 02/16: Mantis #0001688: Affichage centime dans l'écran de confirmation, Dany De Bontridder, 2019/02/03
- [Noalyss-commit] [noalyss] 10/16: Merge branch 'master' of gitlab.noalyss.eu:noalyss/noalyss, Dany De Bontridder, 2019/02/03
- [Noalyss-commit] [noalyss] 14/16: CSS : cosmetic, Dany De Bontridder, 2019/02/03
- [Noalyss-commit] [noalyss] 08/16: Mantis #1643: Déplacement du "bouton" «retour en-haut/calculatrice», Dany De Bontridder, 2019/02/03
- [Noalyss-commit] [noalyss] 04/16: Mantis #0001682: CA - ajouter possibilité d'exporter le plan analytique, add action CSV:Analytic_Axis, Dany De Bontridder, 2019/02/03
- [Noalyss-commit] [noalyss] 05/16: Mantis #0001682: CA - ajouter possibilité d'exporter le plan analytique, add action CSV:Analytic_Axis,
Dany De Bontridder <=
- [Noalyss-commit] [noalyss] 09/16: Mantis #1665: Pouvoir modifier l'ordre dans les listing de compta analytique, Dany De Bontridder, 2019/02/03
- [Noalyss-commit] [noalyss] 15/16: Merge issue : inappropriate rollback, Dany De Bontridder, 2019/02/03
- [Noalyss-commit] [noalyss] 11/16: 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, 2019/02/03
- [Noalyss-commit] [noalyss] 06/16: mantis #1690: Bug : impossible d'utiliser < dans Inplace_Edit Use base64_decode to protect the string in serialize, Dany De Bontridder, 2019/02/03
- [Noalyss-commit] [noalyss] 16/16: Bug merge, Dany De Bontridder, 2019/02/03
- [Noalyss-commit] [noalyss] 13/16: Mantis #1611: Problème Plan comptable - mise en évidence poste utilisés, Dany De Bontridder, 2019/02/03
- [Noalyss-commit] [noalyss] 07/16: Mantis #1626: AFFICHAGE BALANCE FICHE - soldes nuls au débit, Dany De Bontridder, 2019/02/03
- [Noalyss-commit] [noalyss] 12/16: Mantis #0001614: Problème bilans , changement pour bilan ASBL, Dany De Bontridder, 2019/02/03