[Noalyss-commit] [noalyss] 173/218: Mantis #0001682: CA - ajouter possibilité d'exporter le plan analytique, missing file

[Dany De Bontridder]

sparkyx pushed a commit to branch entreprise
in repository noalyss.

commit 3d9693029d9f7cd2ec0d8a8ecb711ff27f801f00
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,
    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 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