Rapav_dd_Account_Tva Class Reference

handle the param_detail type Account_Tva The t_id gives the type of total More...

Inheritance diagram for Rapav_dd_Account_Tva:

Collaboration diagram for Rapav_dd_Account_Tva:

Public Member Functions
	compute ($p_start, $p_end)
	Compute the amount of TVA or Account, call internally private functions. 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...

Private Member Functions
	compute_tva ($p_start, $p_end)
	compute the amount of tva using the given account in either the ledger ACH or VEN following the $this->form->jrn_def_type. More...
	compute_amount ($p_start, $p_end)
	compute the amount of account using the given tva_id in either the ledger ACH or VEN following the $this->form->jrn_def_type. More...

Detailed Description

handle the param_detail type Account_Tva The t_id gives the type of total

• 0 TVA + Account
• 1 TVA
• 2 Account the jrn_def_type is either ACH or VEN

See Also

RAPAV_Account_Tva

Definition at line 989 of file class_rapav_declaration.php.

Member Function Documentation

Rapav_dd_Account_Tva::compute	(		$p_start,
			$p_end
	)

Compute the amount of TVA or Account, call internally private functions.

See Also

Rapav_dd_Account_Tva::computa_amount Rapav_dd_Account_Tva::compute_tva

Parameters

$p_start	start date
$p_end	end date

Returns

amount computed

Exceptions

Exception

Definition at line 1097 of file class_rapav_declaration.php.

References $amount, compute_amount(), and compute_tva().

    {
        bcscale(2);
        // Retrieve the account for the tva_id, we need the DEB for VEN and CRED for ACH
        //
        // tt_id gives the type of total
        //  - 0 TVA + Account
        //  - 1 TVA
        //  - 2 Account
        switch ($this->form->tt_id)
        {
            case 0:
                $t1_amount = $this->compute_amount($p_start, $p_end);
                $t2_amount = $this->compute_tva($p_start, $p_end);
                $amount = bcadd($t1_amount, $t2_amount);
                break;
            case 1:
                $amount = $this->compute_tva($p_start, $p_end);
                $amount = bcadd($amount, 0);
                break;

            case 2:
                $amount = $this->compute_amount($p_start, $p_end);
                $amount = bcadd($amount, 0);
                break;

            default:
                throw new Exception('Type de total invalide');
                break;
        }
        return $amount;
    }

Rapav_dd_Account_Tva::compute_amount (   $p_start,   $p_end  )

private

compute the amount of account using the given tva_id in either the ledger ACH or VEN following the $this->form->jrn_def_type.

Set the $this->errcode if something wrong has happened

Parameters

$p_start	start date
$p_end	end date

Returns

amount

Parameters

type	$p_start
type	$p_end

Returns

|int

Definition at line 1052 of file class_rapav_declaration.php.

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

Referenced by compute().

    {
        $filter_ledger = "";
        if ($this->form->jrn_def_id != "")
        {
            $filter_ledger = " and j_jrn_def = " . sql_string($this->form->jrn_def_id);
        }
        $sql_date=RAPAV::get_sql_date($this->form->date_paid );

        if ($this->form->jrn_def_type == 'ACH')
        {
            $sql = "select coalesce(sum(qp_price),0) as amount from quant_purchase join jrnx as jrn1  using (j_id)
                    where qp_vat_code=$1 $sql_date
                    and j_poste::text like ($4) $filter_ledger";

            $amount = $this->cn->get_value($sql, array($this->form->tva_id,
                $p_start,
                $p_end,
                $this->form->tmp_val));
            return $amount;
        }
        if ($this->form->jrn_def_type == 'VEN')
        {
            $sql = "select coalesce(sum(qs_price),0) as amount from quant_sold
                    join jrnx as jrn1  using (j_id)
                    where qs_vat_code=$1 $sql_date
                    and j_poste::text like ($4) $filter_ledger";
            $amount = $this->cn->get_value($sql, array($this->form->tva_id,
                $p_start,
                $p_end,
                $this->form->tmp_val));
            return $amount;
        }
        $this->errcode = 'Erreur dans le journal';
        return 0;
    }

Rapav_dd_Account_Tva::compute_tva (   $p_start,   $p_end  )

private

compute the amount of tva using the given account in either the ledger ACH or VEN following the $this->form->jrn_def_type.

set the $this->errcode if something wrong has happened

Parameters

$p_start	start date
$p_end	end date

Returns

amount

Definition at line 1000 of file class_rapav_declaration.php.

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

Referenced by compute().

    {
        $filter_ledger = "";
        if ($this->form->jrn_def_id != "")
        {
            $filter_ledger = " and j_jrn_def = " . sql_string($this->form->jrn_def_id);
        }
        $sql_date=RAPAV::get_sql_date($this->form->date_paid );

        if ($this->form->jrn_def_type == 'ACH')
        {

            $sql = "select coalesce(sum(qp_vat),0) as amount
                        from quant_purchase join jrnx as jrn1 using (j_id)
                        where qp_vat_code=$1
                        $sql_date
                        and j_poste::text like ($4) $filter_ledger";
            $amount = $this->cn->get_value($sql, array($this->form->tva_id,
                $p_start,
                $p_end,
                $this->form->tmp_val));
            return $amount;
        }
        if ($this->form->jrn_def_type == 'VEN')
        {
            $sql = "select coalesce(sum(qs_vat),0) as amount
                        from quant_sold join jrnx as jrn1  using (j_id)
                        where qs_vat_code=$1 
                        $sql_date
                        and j_poste::text like ($4)  $filter_ledger";

            $amount = $this->cn->get_value($sql, array($this->form->tva_id,
                $p_start,
                $p_end,
                $this->form->tmp_val));
            return $amount;
        }
        $this->errcode = 'Erreur dans le journal';
        return 0;
    }

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