Rapav_dd_Account Class Reference

handle the param_detail type Account The type_sum_account gives the type of total More...

Inheritance diagram for Rapav_dd_Account:

Collaboration diagram for Rapav_dd_Account:

Public Member Functions
	compute ($p_start, $p_end)
	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

handle the param_detail type Account The type_sum_account gives the type of total

• 0 D-C
• 1 C-D
• 2 D
• 4 C it uses tmp_val, with_tmp_val and type_sum_account

  See Also

  RAPAV_Account

Definition at line 1142 of file class_rapav_declaration.php.

Member Function Documentation

Rapav_dd_Account::compute	(		$p_start,
			$p_end
	)

Definition at line 1145 of file class_rapav_declaration.php.

References $amount, $cn, $sql, and RAPAV\get_sql_date().

    {
        global $cn;
        $filter_ledger = "";
        if ($this->form->jrn_def_id != "")
        {
            $filter_ledger = " and jrn1.j_jrn_def = " . sql_string($this->form->jrn_def_id);
        }
        
        $amount=0;

        bcscale(2);
        switch ($this->form->type_sum_account)
        {
            // Saldo
            case 1:
            case 2:
                $sql_date=RAPAV::get_sql_date($this->form->date_paid,'jrn1' );
                // Compute D-C
                $sql = "
                        select sum(jrnx_amount)
                        from (
                                select distinct jrn1.j_id,case when jrn1.j_debit = 't' then jrn1.j_montant else jrn1.j_montant*(-1) end as jrnx_amount
                                from jrnx as jrn1
                                join jrnx as jrn2 on (jrn1.j_grpt=jrn2.j_grpt)
                                where
                                jrn1.j_poste like $1
                                $sql_date
                                and
                                jrn2.j_poste like $4
                                $filter_ledger
                                ) as tv_amount
                             ";
                $amount = $cn->get_value($sql, array(
                    $this->form->tmp_val,
                    $p_start,
                    $p_end,
                    $this->form->with_tmp_val
                ));
                // if C-D is asked then reverse the result
                if ($this->form->type_sum_account == 2)
                    $amount = bcmul($amount, -1);
                break;
            // Only DEBIT
            case 3:
                $sql_date=RAPAV::get_sql_date($this->form->date_paid,'jrn1' );
                $sql = "
                        select sum(jrnx_amount)
                        from (
                                select distinct jrn1.j_id,jrn1.j_montant as jrnx_amount
                                from jrnx as jrn1
                                join jrnx as jrn2 on (jrn1.j_grpt=jrn2.j_grpt)
                                where
                                jrn1.j_poste like $1
                                $sql_date
                                and
                                jrn2.j_poste like $4
                                and
                                jrn1.j_debit='t'
                                $filter_ledger
                                ) as tv_amount
                             ";
                $amount = $cn->get_value($sql, array(
                    $this->form->tmp_val,
                    $p_start,
                    $p_end,
                    $this->form->with_tmp_val
                ));
                break;
            // Only CREDIT
            case 4:
                $sql_date=RAPAV::get_sql_date($this->form->date_paid,'jrn1' );
                $sql = "
                        select sum(jrnx_amount)
                        from (
                                select distinct jrn1.j_id,jrn1.j_montant as jrnx_amount
                                from jrnx as jrn1
                                join jrnx as jrn2 on (jrn1.j_grpt=jrn2.j_grpt)
                                where
                                jrn1.j_poste like $1
                                $sql_date
                                and
                                jrn2.j_poste like $4
                                and
                                jrn1.j_debit='f'
                                $filter_ledger
                                ) as tv_amount
                             ";
                $amount = $cn->get_value($sql, array(
                    $this->form->tmp_val,
                    $p_start,
                    $p_end,
                    $this->form->with_tmp_val,
                ));
                break;

            default:
                if (DEBUG)
                    var_dump($this);
                die(__FILE__ . ":" . __LINE__ . " UNKNOW SUM TYPE");
                break;
        }
        /*
         * 4 possibilities with type_sum_account
         */
        return $amount;
    }

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