[Phpcompta-dev] r608 - trunk/rapport_avance/include

[phpcompta-dev]

Author: danydb
Date: 2013-12-11 14:26:51 +0100 (Wed, 11 Dec 2013)
New Revision: 608

Added:
   trunk/rapport_avance/include/class_rapav_listing_compute_fiche.php
Log:
Task #939 : generation de document
Nouvelle classe pour g?\195?\169n?\195?\169ration
Task #939 - Listing : G?\195?\169n?\195?\169ration de document

Added: trunk/rapport_avance/include/class_rapav_listing_compute_fiche.php
===================================================================
--- trunk/rapport_avance/include/class_rapav_listing_compute_fiche.php          
                (rev 0)
+++ trunk/rapport_avance/include/class_rapav_listing_compute_fiche.php  
2013-12-11 13:26:51 UTC (rev 608)
@@ -0,0 +1,271 @@
+<?php
+
+/*
+ * To change this license header, choose License Headers in Project Properties.
+ * To change this template file, choose Tools | Templates
+ * and open the template in the editor.
+ */
+
+/**
+ * Description of class_rapav_listing_compute_fiche
+ *
+ * @author dany
+ */
+class RAPAV_Listing_Compute_Fiche extends RAPAV_Listing_Compute_Fiche_SQL
+{
+
+    private function get_file_to_parse(RAPAV_Listing_Compute &$listing_compute)
+    {
+        global $cn;
+        // create a temp directory in /tmp to unpack file and to parse it
+        $dirname = tempnam($_ENV['TMP'], 'rapav_listing');
+
+
+        unlink($dirname);
+        mkdir($dirname);
+        chdir($dirname);
+        // Retrieve the lob and save it into $dirname
+        $cn->start();
+
+
+        $filename = $listing->Data->l_filename;
+        $exp = $cn->lo_export($listing_compute->listing->Data->l_lob, $dirname 
. DIRECTORY_SEPARATOR . $filename);
+
+        if ($exp === false)
+            echo_warning(__FILE__ . ":" . __LINE__ . "Export NOK $filename");
+
+        $type = "n";
+        // if the doc is a OOo, we need to unzip it first
+        // and the name of the file to change is always content.xml
+        if (strpos($listing_compute->listing->Data->l_mimetype, 'vnd.oasis') 
!= 0)
+        {
+            ob_start();
+            $zip = new Zip_Extended;
+            if ($zip->open($filename) === TRUE)
+            {
+                $zip->extractTo($dirname . DIRECTORY_SEPARATOR);
+                $zip->close();
+            } else
+            {
+                echo __FILE__ . ":" . __LINE__ . "cannot unzip model " . 
$filename;
+            }
+
+            // Remove the file we do  not need anymore
+            unlink($filename);
+            ob_end_clean();
+            $file_to_parse = "content.xml";
+            $type = "OOo";
+        } else
+            $file_to_parse = $filename;
+
+        $cn->commit();
+        return array($file_to_parse, $dirname, $type);
+    }
+
+    private function generate_document(RAPAV_Listing_Compute &$listing_compute)
+    {
+        global $cn;
+
+        if ($listing_compute->listing->Data->l_filename == "")
+            return;
+
+        list($file_to_parse, $dirname, $type) = 
$this->get_file_to_parse($listing_compute);
+
+        // parse the document
+        $this->parse_document($dirname, $file_to_parse, $type);
+
+        // Add special tag
+        $this->special_tag($dirname, $file_to_parse, $type);
+
+        // if the doc is a OOo, we need to re-zip it
+        if ($type == 'OOo')
+        {
+            ob_start();
+            $zip = new Zip_Extended;
+            $res = $zip->open($listing_compute->listing->Data->l_filename, 
ZipArchive::CREATE);
+            if ($res !== TRUE)
+            {
+                echo __FILE__ . ":" . __LINE__ . "cannot recreate zip";
+                exit;
+            }
+            $zip->add_recurse_folder($dirname . DIRECTORY_SEPARATOR);
+            $zip->close();
+
+            ob_end_clean();
+
+            $file_to_save = $listing_compute->listing->Data->l_filename;
+        } else
+        {
+            $file_to_save = $file_to_parse;
+        }
+
+        $this->load_document($dirname . DIRECTORY_SEPARATOR . $file_to_save);
+    }
+
+    private function parse_document($p_dir, $p_filename, $p_type)
+    {
+        global $cn;
+        // Retrieve all the code + amount
+        if ($p_type == "OOo")
+        {
+            $array = $cn->get_array("select '&lt;&lt;'||lc_code||'&gt;&gt;' as 
code,
+                    coalesce(ld_value_numeric,ld_value_text,ld_value_date) as 
value,
+                    case 
+                        when ld_value_numeric is not null then 1 
+                        when ld_value_text is not null then 2
+                        when ld_value_date is not null then 3
+                    end
+                        as type
+                    from rapport_advanced.listing_compute_detail where 
lf_id=$1 "
+                    , array($this->lf_id));
+        } else
+        {
+            $array = $cn->get_array("select '<<'||lc_code||'>>' as code,
+                    coalesce(ld_value_numeric,ld_value_text,ld_value_date) as 
value  
+                    case 
+                        when ld_value_numeric is not null then 1 
+                        when ld_value_text is not null then 2
+                        when ld_value_date is not null then 3
+                    end
+                        as type
+                    from rapport_advanced.listing_compute_detail where 
lf_id=$1 "
+                    , array($this->lf_id));
+        }
+
+        // open the files
+        $ifile = fopen($p_dir . '/' . $p_filename, 'r');
+
+        // check if tmpdir exist otherwise create it
+        $temp_dir = $_SERVER["DOCUMENT_ROOT"] . DIRECTORY_SEPARATOR . 'tmp';
+        if (is_dir($temp_dir) == false)
+        {
+            if (mkdir($temp_dir) == false)
+            {
+                echo "Ne peut pas créer le répertoire " . $temp_dir;
+                exit();
+            }
+        }
+        // Compute output_name
+        $oname = tempnam($temp_dir, "listing_");
+        $ofile = fopen($oname, "w+");
+
+        // read ifile
+        while (!feof($ifile))
+        {
+            $buffer = fgets($ifile);
+            // for each code replace in p_filename the code surrounded by << 
>> by the amount (value) or &lt; or &gt;
+            foreach ($array as $key => $value)
+            {
+                if ($value['type']==1)
+                {
+                    $searched = 'office:value-type="string"><text:p>' . 
$value['code'];
+                    $replaced = 'office:value-type="float" office:value="' . 
$value['value'] . '"><text:p>' . $value['code'];
+                    $buffer = str_replace($searched, $replaced, $buffer);
+                }
+                $buffer = str_replace($value['code'], $value['value'], 
$buffer);
+            }
+            // write to output
+            fwrite($ofile, $buffer);
+        }
+
+        // copy the output to input
+        fclose($ifile);
+        fclose($ofile);
+
+        if (($ret = copy($oname, $p_dir . '/' . $p_filename)) == FALSE)
+        {
+            echo _('Ne peut pas sauver ' . $oname . ' vers ' . $p_dir . '/' . 
$p_filename . ' code d\'erreur =' . $ret);
+        }
+        unlink($oname);
+    }
+
+    private function special_tag($p_dir, $p_filename, 
$p_type,RAPAV_Listing_Compute &$listing_compute)
+    {
+        global $cn, $g_parameter;
+        // Retrieve all the code + libelle
+        $array[] = array('code' => 'PERIODE_DECLARATION', 'value' => 
format_date($listing_compute->Data->l_start) . " - " . 
format_date($listing_compute->Data->l_end));
+        $array[] = array('code' => 'TITRE', 'value' => 
$listing_compute->listing->Data->l_name);
+        $array[] = array('code' => 'DOSSIER', 'value' => 
$cn->format_name($_REQUEST['gDossier'], 'dos'));
+        $array[] = array('code' => 'NAME', 'value' => $g_parameter->MY_NAME);
+        $array[] = array('code' => 'STREET', 'value' => 
$g_parameter->MY_STREET);
+        $array[] = array('code' => 'NUMBER', 'value' => 
$g_parameter->MY_NUMBER);
+        $array[] = array('code' => 'LOCALITE', 'value' => 
$g_parameter->MY_COMMUNE);
+        $array[] = array('code' => 'COUNTRY', 'value' => 
$g_parameter->MY_PAYS);
+        $array[] = array('code' => 'PHONE', 'value' => $g_parameter->MY_TEL);
+        $array[] = array('code' => 'CEDEX', 'value' => $g_parameter->MY_CP);
+        $array[] = array('code' => 'FAX', 'value' => $g_parameter->MY_FAX);
+        $array[] = array('code' => 'NOTE', 'value' => 
$listing_compute->$Data->l_description);
+
+        // open the files
+        $ifile = fopen($p_dir . '/' . $p_filename, 'r');
+
+        // check if tmpdir exist otherwise create it
+        $temp_dir = $_SERVER["DOCUMENT_ROOT"] . DIRECTORY_SEPARATOR . 'tmp';
+        if (is_dir($temp_dir) == false)
+        {
+            if (mkdir($temp_dir) == false)
+            {
+                echo "Ne peut pas créer le répertoire " . $temp_dir;
+                exit();
+            }
+        }
+        // Compute output_name
+        $oname = tempnam($temp_dir, "listing_");
+        $ofile = fopen($oname, "w+");
+
+        // read ifile
+        while (!feof($ifile))
+        {
+            $buffer = fgets($ifile);
+            // for each code replace in p_filename the code surrounded by << 
>> by the amount (value) or &lt; or &gt;
+            foreach ($array as $key => $value)
+            {
+                if ($p_type == 'OOo')
+                {
+                    $replace = '&lt;&lt;' . $value['code'] . '&gt;&gt;';
+                    $fmt_value = $value['value'];
+                    $fmt_value = str_replace('&', '&amp;', $fmt_value);
+                    $fmt_value = str_replace('<', '&lt;', $fmt_value);
+                    $fmt_value = str_replace('>', '&gt;', $fmt_value);
+                    $fmt_value = str_replace('"', '&quot;', $fmt_value);
+                    $fmt_value = str_replace("'", '&apos;', $fmt_value);
+                } else
+                {
+                    $replace = '<<' . $value['code'] . '>>';
+                    $fmt_value = $value['value'];
+                }
+                $buffer = str_replace($replace, $fmt_value, $buffer);
+            }
+            // write to output
+            fwrite($ofile, $buffer);
+        }
+
+        // copy the output to input
+        fclose($ifile);
+        fclose($ofile);
+
+        if (($ret = copy($oname, $p_dir . '/' . $p_filename)) == FALSE)
+        {
+            echo _('Ne peut pas sauver ' . $oname . ' vers ' . $p_dir . '/' . 
$p_filename . ' code d\'erreur =' . $ret);
+        }
+        unlink($oname);
+    }
+
+    private function load_document_card($p_file)
+    {
+        global $cn;
+        $cn->start();
+        $this->lf_lob = $cn->lo_import($p_file);
+        if ($this->lf_lob == false)
+        {
+            echo "ne peut pas importer [$p_file]";
+            return 1;
+        }
+        $this->lf_size = filesize($p_file);
+        $date = date('ymd-Hi');
+        $this->lf_filename = $date . '-' . $this->d_filename;
+        $this->update();
+        $cn->commit();
+    }
+
+}



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