[Phpcompta-dev] r449 - in trunk/rapport_avance: . include

[phpcompta-dev]

Author: danydb
Date: 2012-12-26 19:44:42 +0100 (Wed, 26 Dec 2012)
New Revision: 449

Modified:
   trunk/rapport_avance/ajax_declaration_display.php
   trunk/rapport_avance/include/class_rapav_declaration.php
   trunk/rapport_avance/include/declaration.inc.php
   trunk/rapport_avance/raw.php
Log:
Ajout export CSV des d?\195?\169clarations sauv?\195?\169es

Modified: trunk/rapport_avance/ajax_declaration_display.php
===================================================================
--- trunk/rapport_avance/ajax_declaration_display.php   2012-12-14 23:25:17 UTC 
(rev 448)
+++ trunk/rapport_avance/ajax_declaration_display.php   2012-12-26 18:44:42 UTC 
(rev 449)
@@ -32,5 +32,8 @@
 $decl->d_id = $_GET['d_id'];
 $decl->load();
 $decl->display();
+$ref=HtmlInput::array_to_string(array('gDossier','plugin_code','d_id'),$_GET,'extension.raw.php?');
+$ref.="&act=export_decla_csv";
+echo HtmlInput::button_anchor("Export CSV",$ref,'export_id');
 echo HtmlInput::button_action("Retour","$('declaration_list_div').show(); 
$('declaration_display_div').hide();");
 ?>

Modified: trunk/rapport_avance/include/class_rapav_declaration.php
===================================================================
--- trunk/rapport_avance/include/class_rapav_declaration.php    2012-12-14 
23:25:17 UTC (rev 448)
+++ trunk/rapport_avance/include/class_rapav_declaration.php    2012-12-26 
18:44:42 UTC (rev 449)
@@ -42,7 +42,38 @@
                $this->form = new RAPAV_Formulaire();
                parent::__construct();
        }
+       static function to_csv($p_id)
+       {
+               global $cn;
+               $a_row=$cn->get_array('select 
dr_code,dr_libelle,dr_amount,dr_info from rapport_advanced.declaration_row
+                       where d_id=$1 order by dr_order',array($p_id));
 
+               $a_title=$cn->get_array("select d_title
+                       ,to_char(d_start,'DD.MM.YYYY') as start
+                       ,to_char(d_end,'DD.MM.YYYY') as end
+                       from
+                       rapport_advanced.declaration
+                       where
+                       d_id=$1",array($p_id));
+               
$title=$a_title[0]['d_title']."-".$a_title[0]['start']."-".$a_title[0]['end'];
+               $title = mb_strtolower($title, 'UTF-8');
+               $title = str_replace(array('/', '*', '<', '>', '*', '.', '+', 
':', '?', '!', " ", ";"), "_", $title);
+               $out = fopen("php://output", "w");
+
+               header('Pragma: public');
+               header('Content-type: application/csv');
+               header('Content-Disposition: attachment;filename="' . $title . 
'.csv"', FALSE);
+               fputcsv($out, $a_title[0], ";");
+
+               for ($i = 0; $i < count($a_row); $i++)
+               {
+                       printf ('"%s";"%s";%s;"%s"'."\r\n",
+                                       $a_row[$i]['dr_code'],
+                                       $a_row[$i]['dr_libelle'],
+                                       nb($a_row[$i]['dr_amount']),
+                                       $a_row[$i]['dr_info']);
+               }
+       }
        function compute($p_id, $p_start, $p_end)
        {
                global $cn;

Modified: trunk/rapport_avance/include/declaration.inc.php
===================================================================
--- trunk/rapport_avance/include/declaration.inc.php    2012-12-14 23:25:17 UTC 
(rev 448)
+++ trunk/rapport_avance/include/declaration.inc.php    2012-12-26 18:44:42 UTC 
(rev 449)
@@ -36,11 +36,15 @@
        $decl = new Rapav_Declaration();
        $decl->d_id = $_POST['d_id'];
        $decl->load();
-       $decl->to_keep='Y';
-       $decl->f_id=$_POST['p_form'];
+       $decl->to_keep = 'Y';
+       $decl->f_id = $_POST['p_form'];
        $decl->save();
        $decl->display();
        echo '<h2 class="notice"> Sauvé</h2>';
+
+       $ref = HtmlInput::array_to_string(array('gDossier', 'plugin_code', 
'd_id'), $_REQUEST, 'extension.raw.php?');
+       $ref.="&amp;act=export_decla_csv";
+       echo HtmlInput::button_anchor("Export CSV", $ref, 'export_id');
        exit();
 }
 /*
@@ -57,7 +61,7 @@
        {
                $decl->compute($_GET['p_form'], $_GET['p_start'], 
$_GET['p_end']);
                echo '<form class="print" method="POST">';
-               echo HtmlInput::hidden('p_form',$_GET['p_form']);
+               echo HtmlInput::hidden('p_form', $_GET['p_form']);
                $decl->display();
                echo HtmlInput::submit('save', 'Sauver');
                echo '</form>';
@@ -101,7 +105,7 @@
 </form>
 <script charset="UTF8" lang="javascript">
        function validate() {
-               if ( check_date_id('<?=$date_start->id?>') == false ) 
{alert('Date de début incorrecte');return false;}
-               if ( check_date_id('<?=$date_end->id?>') == false ) 
{alert('Date de fin incorrecte');return false;}
+               if ( check_date_id('<?= $date_start->id?>') == false ) 
{alert('Date de début incorrecte');return false;}
+               if ( check_date_id('<?= $date_end->id?>') == false ) 
{alert('Date de fin incorrecte');return false;}
        }
 </script>
\ No newline at end of file

Modified: trunk/rapport_avance/raw.php
===================================================================
--- trunk/rapport_avance/raw.php        2012-12-14 23:25:17 UTC (rev 448)
+++ trunk/rapport_avance/raw.php        2012-12-26 18:44:42 UTC (rev 449)
@@ -24,8 +24,14 @@
  * \brief raw file for PDF ewa
  */
 require_once 'include/class_formulaire_param.php';
+require_once 'include/class_rapav_declaration.php';
 extract ($_REQUEST);
 if ( $act=='rapav_form_export') {
        Formulaire_Param::to_csv($d_id);
+       exit();
 }
+if ($act=='export_decla_csv') {
+        Rapav_Declaration::to_csv($d_id);
+       exit();
+}
 ?>



---
PhpCompta est un logiciel de comptabilité libre en ligne (full web)
Projet opensource http://www.phpcompta.eu