Rapav_Declaration_Param Class Reference

Match each row of a form, this row can have several details. More...

Collaboration diagram for Rapav_Declaration_Param:

Public Member Functions
	insert ()
	insert into rapport_advanced.formulaire_param More...
	from_array ($p_array)
	set the attribute param with the content of the array. More...
	compute_date ($p_start, $p_end)
	compute the date following the attribute t_id (match rapport_advanced.periode_type and store the result into $this->start and $this-> end More...
	compute_child ($p_pcm_val, $p_start, $p_end)
	compute ($p_start, $p_end)
	get_depending ()
	find depending accounting More...

Detailed Description

Match each row of a form, this row can have several details.

Definition at line 647 of file class_rapav_declaration.php.

Member Function Documentation

Rapav_Declaration_Param::compute	(		$p_start,
			$p_end
	)

Definition at line 793 of file class_rapav_declaration.php.

References $array, $cn, compute_date(), and Rapav_Declaration_Detail\factory().

    {
        global $cn;
        bcscale(2);
        $this->amount = "0";

        $array = $cn->get_array("select fp_id,p_id,tmp_val,tva_id,fp_formula,fp_signed,jrn_def_type,tt_id,type_detail,
            with_tmp_val,type_sum_account,operation_pcm_val,jrn_def_id,date_paid
            from rapport_advanced.formulaire_param_detail where p_id=$1", array($this->param->p_id));
        $this->compute_date($p_start, $p_end);
        for ($e = 0; $e < count($array); $e++)
        {
            $row_detail = Rapav_Declaration_Detail::factory($array[$e]);
            $row_detail->dr_id = $this->dr_id;
            $row_detail->d_id = $this->d_id;
            $tmp_amount = $row_detail->compute($this->start, $this->end);
            $this->amount = bcadd("$tmp_amount", "$this->amount");
            $row_detail->insert();
        }
    }

Rapav_Declaration_Param::compute_child	(		$p_pcm_val,
			$p_start,
			$p_end
	)

Definition at line 764 of file class_rapav_declaration.php.

References $array, $cn, compute_date(), and Rapav_Declaration_Detail\factory().

Referenced by Rapav_Declaration\add_child_account().

    {
        global $cn;
        bcscale(2);
        $this->amount = "0";

        $array = $cn->get_array("select fp_id,p_id,tmp_val,tva_id,fp_formula,fp_signed,jrn_def_type,tt_id,type_detail,
            with_tmp_val,type_sum_account,operation_pcm_val,jrn_def_id,date_paid
            from rapport_advanced.formulaire_param_detail where p_id=$1", array($this->param->p_id));
        $this->compute_date($p_start, $p_end);
        for ($e = 0; $e < count($array); $e++)
        {
            $row_detail = Rapav_Declaration_Detail::factory($array[$e]);
            $row_detail->form->tmp_val=$p_pcm_val;
            $row_detail->dr_id = $this->dr_id;
            $row_detail->d_id = $this->d_id;
            $tmp_amount = $row_detail->compute($this->start, $this->end);
            $this->amount = bcadd("$tmp_amount", "$this->amount");
            $row_detail->insert();
        }
    }

Rapav_Declaration_Param::compute_date	(		$p_start,
			$p_end
	)

compute the date following the attribute t_id (match rapport_advanced.periode_type and store the result into $this->start and $this-> end

• 1 date from the FORM
• 2 N
• 3 N-1
• 4 N-2
• 5 N-3

  Parameters

  $p_start	requested date
  $p_end	requested date

Definition at line 703 of file class_rapav_declaration.php.

References $cn, $exercice, and $periode.

Referenced by compute(), and compute_child().

    {
        global $g_user;
        switch ($this->param->t_id)
        {
            case 1:
                $this->start = $p_start;
                $this->end = $p_end;
                return;
                break;
            case 2:
                list($this->start, $this->end) = $g_user->get_limit_current_exercice();
                return;
                break;
            case 3:
                $exercice = $g_user->get_exercice();
                $exercice--;
                break;
            case 4:
                $exercice = $g_user->get_exercice();
                $exercice-=2;
                break;
            case 5:
                $exercice = $g_user->get_exercice();
                $exercice-=3;
                break;
            case 6:
                list($this->start, $this->end) = $g_user->get_limit_current_exercice();
                $this->end = $p_end;
                return;
                break;
            default:
                throw new Exception('compute_date : t_id est incorrect');
        }
        global $cn;

        // If exercice does not exist then
        // set the date end and start to 01.01.1900

        $exist_exercice = $cn->get_value('select count(p_id) from parm_periode where p_exercice=$1', array($exercice));
        if ($exist_exercice == 0)
        {
            $this->start = '01.01.1900';
            $this->end = '01.01.1900';
            return;
        }
        // Retrieve start & end date
        $periode = new Periode($cn);
        list($per_start, $per_end) = $periode->get_limit($exercice);
        $this->start = $per_start->first_day();
        $this->end = $per_end->last_day();
    }

Rapav_Declaration_Param::from_array

(

$p_array

)

set the attribute param with the content of the array.

keys :

• 'p_id',
• 'p_code',
• 'p_libelle',
• 'p_type',
• 'p_order',
• 'f_id',
• 't_id'

  Parameters

  type

  $p_array

Definition at line 681 of file class_rapav_declaration.php.

Referenced by Rapav_Declaration\add_child_account().

    {
        $this->param = new Formulaire_Param();
        foreach (array('p_id', 'p_code', 'p_libelle', 'p_type', 'p_order', 'f_id', 't_id') as $e)
        {
            $this->param->$e = $p_array[$e];
        }
        $this->param->load();
        
    }

Rapav_Declaration_Param::get_depending

(

)

find depending accounting

Definition at line 816 of file class_rapav_declaration.php.

References $array, and $cn.

Referenced by Rapav_Declaration\add_child_account().

    {
        global $cn;
        $accounting = $cn->get_value(" select tmp_val 
                from rapport_advanced.formulaire_param_detail 
                where p_id=$1", array($this->param->p_id));
        
        $array=$cn->get_array("select pcm_val,pcm_lib from  tmp_pcmn  where 
                 pcm_val like $1||'%' order by pcm_val::text",array($accounting));
        
        return $array;
    }

Rapav_Declaration_Param::insert

(

)

insert into rapport_advanced.formulaire_param

Definition at line 653 of file class_rapav_declaration.php.

References $amount, and $data.

Referenced by Rapav_Declaration\add_child_account().

    {
        $data = new RAPAV_Declaration_Row_SQL();
        $data->dr_code = $this->param->p_code;
        $data->dr_libelle = $this->param->p_libelle;
        $data->dr_order = $this->param->p_order;
        $data->dr_amount = $this->amount;
        $data->d_id = $this->d_id;
        $data->dr_id = $this->dr_id;
        $data->dr_type = $this->param->p_type;
        $data->dr_start = $this->dr_start;
        $data->dr_end = $this->dr_end;
        $data->dr_account=$this->dr_account;
        $data->insert();
    }

---

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

• rapport_avance/include/class_rapav_declaration.php