Rapav_Declaration Class Reference

compute, save and display a declaration More...

Inheritance diagram for Rapav_Declaration:

Collaboration diagram for Rapav_Declaration:

Public Member Functions
	__construct ()
	load_formulaire ()
	get_file_to_parse ()
	generate_document ()
	parse_document ($p_dir, $p_filename, $p_type)
	special_tag ($p_dir, $p_filename, $p_type)
	load_document ($p_file)
	compute ($p_id, $p_start, $p_end, $p_step)
	$cn $cn More...
	add_child_account (Rapav_Declaration_Param $row, $p_array, $p_start, $p_end)
	compute_interval ($p_start, $p_end, $p_step)
	get_interval ($p_step)
	anchor_document ()
	display ()
	save ()

Static Public Member Functions
static	to_csv ($p_id, $p_orient="list")
	export a declaration to CSV $cn database conx More...

Detailed Description

compute, save and display a declaration

Definition at line 37 of file class_rapav_declaration.php.

Constructor & Destructor Documentation

Rapav_Declaration::__construct

(

)

Definition at line 40 of file class_rapav_declaration.php.

    {
        $this->form = new RAPAV_Formulaire();
        parent::__construct();
    }

Member Function Documentation

Rapav_Declaration::add_child_account	(	Rapav_Declaration_Param	$row,
			$p_array,
			$p_start,
			$p_end
	)

Definition at line 533 of file class_rapav_declaration.php.

References $cn, $j, Rapav_Declaration_Param\compute_child(), Rapav_Declaration_Param\from_array(), Rapav_Declaration_Param\get_depending(), and Rapav_Declaration_Param\insert().

Referenced by compute().

    {
        global $cn;
        $a_depending=$row->get_depending();
        if ($a_depending==false)
        {
            $row->amount=0;
            $row->dr_start=$p_start;
            $row->dr_end=$p_end;
            $row->insert();
        }
        else
        {
            $nb_depending=count($a_depending);
            for ($j=0; $j<$nb_depending; $j++)
            {
                $row=new Rapav_Declaration_Param();
                $row->d_id=$this->d_id;
                $row->dr_id=$cn->get_next_seq('rapport_advanced.declaration_param_seq');
                $row->from_array($p_array);
                $row->dr_start=$p_start;
                $row->dr_end=$p_end;
                $row->compute_child($a_depending[$j]['pcm_val'], $p_start,$p_end);
                $row->dr_account=$a_depending[$j]['pcm_val'];
                $row->param->p_libelle=$a_depending[$j]['pcm_lib'];
                $row->param->p_order=$row->param->p_order+$j/1000;
                // insert into DECLARATION_ROW
                $row->insert();
            }
        }
    }

Rapav_Declaration::anchor_document

(

)

Definition at line 606 of file class_rapav_declaration.php.

References $url.

    {
        $url = HtmlInput::request_to_string(array('gDossier', 'ac', 'plugin_code'));
        $url = 'extension.raw.php' . $url . '&act=export_decla_document&id=' . $this->d_id;
        return HtmlInput::anchor($this->d_filename, $url);
    }

Rapav_Declaration::compute	(		$p_id,
			$p_start,
			$p_end,
			$p_step
	)

$cn $cn

Parameters

type	$p_id
type	$p_start
type	$p_end
type	$p_step

if step != 0, recompute the date

children must be inserted into DECLARATION_ROW and DECLARARION_ROW_DETAIL for each depending accounting impact also order(use of decimal)

children must be inserted into DECLARATION_ROW and DECLARARION_ROW_DETAIL for each depending accounting impact also order(use of decimal)

Definition at line 431 of file class_rapav_declaration.php.

References $array, $cn, $row, add_child_account(), and compute_interval().

    {
        global $cn;
        $cn->start();
        // Load the parameter from formulaire_param_detail
        // create object_rapav_declaration
        //   compute
        // save the parameter
        $this->form->f_id = $p_id;
        $this->form->load();
        $this->d_title = $this->form->f_title;
        $this->d_start = $p_start;
        $this->d_end = $p_end;
        $this->to_keep = 'N';
        $this->d_lob = $this->form->f_lob;
        $this->d_filename = $this->form->f_filename;
        $this->d_mimetype = $this->form->f_mimetype;
        $this->d_size = $this->form->f_size;
        $this->d_step = $p_step;
        $this->insert();
        /*
         * First we compute the formula and tva_code for each detail
         */
        $array = $cn->get_array("select p_id,p_code,p_libelle,p_type,p_order,f_id,t_id
            from rapport_advanced.formulaire_param
            where
            f_id=$1
            order by p_order", array($p_id));
        /**
         * if step != 0, recompute the date
         */
        if ($p_step == 0)
        {
            // compute each row
            for ($i = 0; $i < count($array); $i++)
            {
                $row = new Rapav_Declaration_Param();
                $row->d_id = $this->d_id;
                $row->dr_id = $cn->get_next_seq('rapport_advanced.declaration_param_seq');
                $row->from_array($array[$i]);
                $row->dr_start = $p_start;
                $row->dr_end = $p_end;
                $row->dr_account=null;
                if ($array[$i]['p_type'] == 3 )
                {
                    $row->compute($p_start, $p_end);
                    // insert into DECLARATION_ROW
                    $row->insert(); 
                } elseif ($array[$i]['p_type'] == 9)
                {
                    /**
                     * children must be inserted into DECLARATION_ROW and
                     * DECLARARION_ROW_DETAIL for each depending accounting
                     * impact also order(use of decimal)
                     */
                   
                    $this->add_child_account($row,$array[$i], $p_start, $p_end);
                    
                }else
                {
                    $row->amount = 0;
                    $row->dr_start = $p_start;
                    $row->dr_end = $p_end;
                    $row->insert();
                }
               
            }
        } else
        {
            // compute new date, stored in $this->start and $this->end
            while ($this->compute_interval($p_start, $p_end, $p_step) == 1)
            {
                for ($i = 0; $i < count($array); $i++)
                {
                    $row = new Rapav_Declaration_Param();
                    $row->d_id = $this->d_id;
                    $row->dr_id = $cn->get_next_seq('rapport_advanced.declaration_param_seq');
                    $row->from_array($array[$i]);
                    $row->dr_account=null;
                    if ($array[$i]['p_type'] == 3)
                    {
                        $row->compute($this->start, $this->end);
                        $row->dr_start = $this->start;
                        $row->dr_end = $this->end;
                        $row->insert();
                    }
                     elseif ($array[$i]['p_type'] == 9)
                    {
                    /**
                     * children must be inserted into DECLARATION_ROW and
                     * DECLARARION_ROW_DETAIL for each depending accounting
                     * impact also order(use of decimal)
                     */
                   
                        $this->add_child_account($row,$array[$i], $this->start, $this->end);
                    
                    }
                }
            }
        }
        $cn->commit();
    }

Rapav_Declaration::compute_interval	(		$p_start,
			$p_end,
			$p_step
	)

Definition at line 565 of file class_rapav_declaration.php.

References $date_end, $date_start, and get_interval().

Referenced by compute().

    {
        static $s_start = "";
        static $s_count = 0;

        if ($s_start == "")
        {
            $s_start = $p_start;
        }
        $s_count++;
        // initialize datetime object
        $date_start = DateTime::createFromFormat('d.m.Y', $s_start);
        $date_end = DateTime::createFromFormat('d.m.Y', $s_start);
        $date_finish = DateTime::createFromFormat('d.m.Y', $p_end);

        $add = $this->get_interval($p_step);


        if ($s_count > 1)
        {
            $date_start->add($add);
            $date_end->add($add);
        }
        // compute date_end
        $date_end->add($add);
        $date_end->sub(new DateInterval('P1D'));
        // if date_end > date_finish then stop
        if ($date_end > $date_finish)
            return 0;
        $this->start = $date_start->format("d.m.Y");
        $this->end = $date_end->format("d.m.Y");
        $s_start = $this->start;
        return 1;
    }

Rapav_Declaration::display

(

)

Definition at line 613 of file class_rapav_declaration.php.

References $array, $cn, and d_id.

    {
        global $cn;
        $array = $cn->get_array('select * from rapport_advanced.declaration_row where d_id=$1 order by dr_order,dr_start', array($this->d_id));
        require_once 'template/declaration_display.php';
    }

Rapav_Declaration::generate_document

(

)

Definition at line 174 of file class_rapav_declaration.php.

References $cn, $res, $type, get_file_to_parse(), load_document(), parse_document(), and special_tag().

    {
        global $cn;
        if ($this->d_filename == "")
            return;

        list($file_to_parse, $dirname, $type) = $this->get_file_to_parse();

        // 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($this->d_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 = $this->d_filename;
        } else
        {
            $file_to_save = $file_to_parse;
        }

        $this->load_document($dirname . DIRECTORY_SEPARATOR . $file_to_save);
    }

Rapav_Declaration::get_file_to_parse

(

)

Definition at line 126 of file class_rapav_declaration.php.

References $cn, and $type.

Referenced by generate_document().

    {
        global $cn;
        // create a temp directory in /tmp to unpack file and to parse it
        $dirname = tempnam($_ENV['TMP'], 'rapav_');


        unlink($dirname);
        mkdir($dirname);
        chdir($dirname);
        // Retrieve the lob and save it into $dirname
        $cn->start();


        $filename = $this->d_filename;
        $exp = $cn->lo_export($this->d_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($this->d_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);
    }

Rapav_Declaration::get_interval

(

$p_step

)

Definition at line 600 of file class_rapav_declaration.php.

Referenced by compute_interval().

    {
        $array_interval = array("", "P7D", "P14D", "P1M", "P2M", "P3M",'P6M','P1Y');
        return new DateInterval($array_interval[$p_step]);
    }

Rapav_Declaration::load_document

(

$p_file

)

Definition at line 406 of file class_rapav_declaration.php.

References $cn, and $date.

Referenced by generate_document().

    {
        global $cn;
        $cn->start();
        $this->d_lob = $cn->lo_import($p_file);
        if ($this->d_lob == false)
        {
            echo "ne peut pas importer [$p_file]";
            return 1;
        }
        $this->d_size = filesize($p_file);
        $date = date('ymd-Hi');
        $this->d_filename = $date . '-' . $this->d_filename;
        $this->update();
        $cn->commit();
    }

Rapav_Declaration::load_formulaire

(

)

Definition at line 45 of file class_rapav_declaration.php.

                               {
        $this->form->load();
    }

Rapav_Declaration::parse_document	(		$p_dir,
			$p_filename,
			$p_type
	)

Definition at line 213 of file class_rapav_declaration.php.

References $array, $cn, $ifile, $key, $p_type, $ret, and d_id.

Referenced by generate_document().

    {
        global $cn;
        // Retrieve all the code + amount
        if ($p_type == "OOo")
        {
            $array = $cn->get_array("select '<<'||dr_code||'>>' as code,dr_amount from rapport_advanced.declaration_row where d_id=$1 and dr_type=3", array($this->d_id));
            $array_mult = $cn->get_array("select '<<'||dr_code||'>>' as code,
                    '<<'||dr_code||'_LIB>>' as code_lib,
                    '<<'||dr_code||'_ACC>>' as code_acc,
                    dr_account,
                    dr_amount,dr_libelle from rapport_advanced.declaration_row where d_id=$1 and dr_type=9 and dr_amount <> 0", array($this->d_id));
        } else
        {
            $array = $cn->get_array("select '<<'||dr_code||'>>' as code,dr_amount from rapport_advanced.declaration_row where d_id=$1 and dr_type=3", array($this->d_id));
            $array_mult = $cn->get_array("select '<<'||dr_code||'>>' as code,
                '<<'||dr_code||'_LIB>>' as code_lib, 
                '<<'||dr_code||'_ACC>>' as code_acc, 
                dr_account,
                dr_amount,dr_libelle from rapport_advanced.declaration_row where d_id=$1 and dr_type=9 and dr_amount <> 0 order by dr_order", array($this->d_id));
        }

        // open the files
        $ifilename=$p_dir . '/' . $p_filename;
        $ifile = fopen($ifilename, 'r');

        // check if tmpdir exist otherwise create it
        $temp_dir = $_ENV['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, "rapport_avance_");
        $ofile = fopen($oname, "w+");

        // read ifile
        $buffer = fread($ifile,  filesize($ifilename));
        // 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 (is_numeric($value['dr_amount']))
            {
                /* -- works only with OOo Calc -- */
                $searched = 'office:value-type="string"><text:p>' . $value['code'];
                $replaced = 'office:value-type="float" office:value="' . $value['dr_amount'] . '"><text:p>' . $value['code'];
                $buffer = str_replace($searched, $replaced, $buffer);
            }
            $buffer = str_replace($value['code'], $value['dr_amount'], $buffer);
        }
        // Do the same but for multiple account
        if ($array_mult==false)
        {

        }
        else
        {
            $a_code_clean=array();
            $a_code_lib_clean=array();
            $a_code_acc_clean=array();
            $idx=0;
            foreach ($array_mult as $key=> $value)
            {
                // Get all the code to replace without duplicate
                
                if ( $idx == 0 ) {
                    $a_code_clean[$idx]=$value['code'];
                    $a_code_lib_clean[$idx]=$value['code_lib'];
                    $a_code_acc_clean[$idx]=$value['code_acc'];
                    $idx++;
                } else {
                    if ( ! in_array($value['code'], $a_code_clean)){
                        $a_code_clean[$idx]=$value['code'];
                        $a_code_lib_clean[$idx]=$value['code_lib'];
                        $a_code_acc_clean[$idx]=$value['code_acc'];
                        $idx++;
                    }
                }
                if (is_numeric($value['dr_amount']))
                {
                    /* -- works only with OOo Calc -- */
                    $searched='office:value-type="string"><text:p>'.$value['code'];
                    $replaced='office:value-type="float" office:value="'.$value['dr_amount'].'"><text:p>'.$value['code'];
                    $buffer=preg_replace("/".$searched."/", $replaced, $buffer,1);
                }
                $buffer=preg_replace("/".$value['code']."/", $value['dr_amount'],$buffer,1);
                $buffer=preg_replace("/".$value['code_lib']."/", $value['dr_libelle'],$buffer,1);
                $buffer=preg_replace("/".$value['code_acc']."/", $value['dr_account'],$buffer,1);
            }
            // clean all unused 
            for ($k=0;$k<$idx;$k++){
                $code=$a_code_clean[$k];
                $code_lib=$a_code_lib_clean[$k];
                $code_acc=$a_code_acc_clean[$k];
                $buffer=preg_replace("/".$code."/","",$buffer);
                $buffer=preg_replace("/".$code_lib."/", "",$buffer);
                $buffer=preg_replace("/".$code_acc."/", "",$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);
    }

Rapav_Declaration::save

(

)

Definition at line 620 of file class_rapav_declaration.php.

References $amount, and $cn.

    {
        global $cn;
        try
        {
            $cn->start();
            $this->to_keep = 'Y';
            $this->update();
            $code = $_POST['code'];
            $amount = $_POST['amount'];
            for ($i = 0; $i < count($code); $i++)
            {
                $cn->exec_sql('update rapport_advanced.declaration_row set dr_amount=$2 where dr_id=$1', array($code[$i], $amount[$i]));
            }
            $cn->commit();
        } catch (Exception $e)
        {
            alert($e->getTraceAsString());
        }
    }

Rapav_Declaration::special_tag	(		$p_dir,
			$p_filename,
			$p_type
	)

Definition at line 333 of file class_rapav_declaration.php.

References $_REQUEST, $array, $cn, $g_parameter, $ifile, $key, $p_type, $ret, and d_description.

Referenced by generate_document().

    {
        global $cn, $g_parameter;
        // Retrieve all the code + libelle
        $array[] = array('code' => 'PERIODE_DECLARATION', 'value' => format_date($this->d_start) . " - " . format_date($this->d_end));
        $array[] = array('code' => 'TITRE', 'value' => $this->d_title);
        $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' => $this->d_description);
        $array[] = array('code' => 'TODAY', 'value' => date('d.m.Y'));
        
        // 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, "rapport_avance_");
        $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);
    }

static Rapav_Declaration::to_csv (   $p_id,   $p_orient = "list"  )

static

export a declaration to CSV $cn database conx

Parameters

$p_id	pk of rapav_declaration
$p_orient	value : list : for a list table : to have a table (if using step)

Definition at line 57 of file class_rapav_declaration.php.

References $cn, and $title.

    {
        global $cn;
        
        $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);
        if ($p_orient == "list")
        {
            fputcsv($out, $a_title[0], ";");
            
            $a_row = $cn->get_array('select dr_code,dr_libelle,dr_amount,dr_start,dr_end,dr_account
            from rapport_advanced.declaration_row
            where d_id=$1 order by dr_order,dr_start', array($p_id));

            for ($i = 0; $i < count($a_row); $i++)
            {
                printf('"%s";"%s";"%s";%s;"%s";"%s"' . "\r\n", $a_row[$i]['dr_code'],$a_row[$i]['dr_account'],$a_row[$i]['dr_libelle'], nb($a_row[$i]['dr_amount']), format_date($a_row[$i]['dr_start']), format_date($a_row[$i]['dr_end'])
                );
            }
        }
        elseif ($p_orient=="table")
        {
             fputcsv($out, $a_title[0], ";");
             // Only the period
             $a_periode = $cn->get_array('select distinct dr_start,dr_end
            from rapport_advanced.declaration_row
            where d_id=$1 order by dr_start', array($p_id));

             // 3 blank columns
             printf(';;');
            for ($i = 0; $i < count($a_periode); $i++)
            {
                printf(';"%s-%s"', format_date($a_periode[$i]['dr_start']), format_date($a_periode[$i]['dr_end']));
            }
            printf("\r\n");
            
            // print each code on one line
             $a_row = $cn->get_array('select dr_code,dr_libelle,dr_amount,dr_start,dr_end,dr_account
            from rapport_advanced.declaration_row
            where d_id=$1 order by dr_order,dr_start', array($p_id));
            $last_code=""; $last_lib="";
            for ($i = 0; $i < count($a_row); $i++)
            {
                if ( $last_code != $a_row[$i]['dr_code'] || $last_lib != $a_row[$i]['dr_libelle'])
                {
                    if ($last_code!=""){ printf("\r\n"); }
                    printf('"%s";"%s";"%s"', $a_row[$i]['dr_account'],$a_row[$i]['dr_code'],$a_row[$i]['dr_libelle']);
                    $last_code=$a_row[$i]['dr_code'];
                    $last_lib=$a_row[$i]['dr_libelle'];
                }
                printf(';%s',nb($a_row[$i]['dr_amount']));
            }
             printf("\r\n");
        }
    }

---

The documentation for this class was generated from the following file:

• rapport_avance/include/class_rapav_declaration.php