Rapav_dd_Formula Class Reference

compute a formula More...

Inheritance diagram for Rapav_dd_Formula:

Collaboration diagram for Rapav_dd_Formula:

Public Member Functions
	compute ($p_start, $p_end)
	compute the amount for one detail of type formula rapport_advanced.formulaire_param_detail type $cn database connexion More...
	from_array ($p_array)
	the p_array contains a row from formulaire_param_detail it will be copied into this->form. More...

Static Public Member Functions
static	factory ($p_array)
	create an object RAPAV_dd_Formula, RAPAV_dd_Account_Tva or Rapav_dd_compute following the idx type_detail More...

Detailed Description

compute a formula

See Also

Impress::parse_formula RAPAV_Formula

Definition at line 896 of file class_rapav_declaration.php.

Member Function Documentation

Rapav_dd_Formula::compute	(		$p_start,
			$p_end
	)

compute the amount for one detail of type formula rapport_advanced.formulaire_param_detail type $cn database connexion

Parameters

$p_start	(date) : computed start date
$p_end	(date) computed start date

Returns

numeric amount computed

Definition at line 907 of file class_rapav_declaration.php.

References $amount, $cn, and $sql.

    {
        global $cn;
        $sql = "";
        if ($this->form->jrn_def_id != null)
        {
            $sql = ' and j_jrn_def =' . $this->form->jrn_def_id;
        }
        if ($this->form->date_paid == 1)
        {
            $sql.=sprintf(" and j_id in ( select j_id from jrnx join jrn on (j_grpt=jr_grpt_id) where jr_date_paid >= to_date('%s','DD.MM.YYYY') and jr_date_paid <= to_date ('%s','DD.MM.YYYY'))", $p_start, $p_end);
            $p_start = '01.01.1900';
            $p_end = '01.01.2100';
        }
        if ($this->form->date_paid == 2)
        {
            $sql.=sprintf(" and j_id in ( select j_id from jrnx join jrn on (j_grpt=jr_grpt_id) where jr_ech >= to_date('%s','DD.MM.YYYY') and jr_ech <= to_date ('%s','DD.MM.YYYY'))", $p_start, $p_end);
            $p_start = '01.01.1900';
            $p_end = '01.01.2100';
        }
        $amount = Impress::parse_formula($cn, "", $this->form->fp_formula, $p_start, $p_end, true, 1, $sql);
        return $amount['montant'];
    }

static Rapav_Declaration_Detail::factory (   $p_array )

staticinherited

create an object RAPAV_dd_Formula, RAPAV_dd_Account_Tva or Rapav_dd_compute following the idx type_detail

Parameters

type

$p_array

Returns

object RAPAV_dd_Formula, RAPAV_dd_Account_Tva or Rapav_dd_compute

Exceptions

if	the type is not known

Definition at line 843 of file class_rapav_declaration.php.

References $ret.

Referenced by Rapav_Declaration_Param\compute(), and Rapav_Declaration_Param\compute_child().

    {
        switch ($p_array['type_detail'])
        {
            case '1':
                $ret = new Rapav_dd_Formula();
                break;
            case '2':
                $ret = new Rapav_dd_Account_Tva();
                break;
            case '3':
                $ret = new Rapav_dd_Compute();
                break;
            case '4':
                $ret = new Rapav_dd_Account();
                break;
            case '5':
                $ret = new Rapav_dd_Reconcile();
                break;
            case '6' :
                // For each child we have a Rapav_dd_Account
                $ret = new Rapav_dd_Account();
                break;
            default:
                throw new Exception("Type inconnu");
        }

        $ret->from_array($p_array);
        $ret->ddr_amount = 0; // cannot be null
        return $ret;
    }

Rapav_Declaration_Detail::from_array (   $p_array )

inherited

the p_array contains a row from formulaire_param_detail it will be copied into this->form.

Parameters

type

$p_array

match formulaire_param_detail table structure

Definition at line 880 of file class_rapav_declaration.php.

    {
        $this->form = new Formulaire_Param_Detail();
        $attribute = explode(',', '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');
        foreach ($attribute as $e)
        {
            $this->form->$e = $p_array[$e];
        }
    }

---

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

• rapport_avance/include/class_rapav_declaration.php