Tva_Amount Class Reference

Collaboration diagram for Tva_Amount:

Public Member Functions
	__construct ($p_init, $p_dir, $p_start_periode, $p_end_periode)
	get_parameter ($p_string)
	set_parameter ($p_string, $p_value)
	get_info ()
	verify ()
	load_parameter ()
	load parameters and set param to a array of value from parameter_chld More...
	amount_operation ()
	get the amount of vat thanks its code More...
	amount_vat ()
	record_ledger ()
	record into the ledger the operation for purging the the vat accouting More...

Static Public Member Functions
static	test_me ()

Private Member Functions
	get_amount_filter ($p_code, $p_account)
	get the amount of operation from the table quant_sold or quant_purchase More...
	get_vat_filter ($p_code, $p_account)
	get the amount of VAT from the table quant_sold or quant_purchase More...

Static Private Attributes
static	$variable

Detailed Description

Definition at line 32 of file class_tva_amount.php.

Constructor & Destructor Documentation

Tva_Amount::__construct	(		$p_init,
			$p_dir,
			$p_start_periode,
			$p_end_periode
	)

Definition at line 43 of file class_tva_amount.php.

                                                                        {
    $this->db=$p_init;
    $this->start_periode=$p_start_periode;
    $this->end_periode=$p_end_periode;
    $this->dir=$p_dir;
  }

Member Function Documentation

Tva_Amount::amount_operation

(

)

get the amount of vat thanks its code

Parameters

$p_gril	is the gril code
$p_dir	is out or in in for the table quant_purchase and out for the table quant_sold

Returns

a number

Definition at line 89 of file class_tva_amount.php.

References get_amount_filter(), and load_parameter().

                              {
    // get the VAT code
    $this->load_parameter();
    $result=0;
    bcscale(4);
    for ($i=0;$i<count($this->param);$i++)
    {
        $tmp_calc=$this->get_amount_filter($this->param[$i]['tva_id'],$this->param[$i]['pcm_val']);
        $result=bcadd($result,$tmp_calc);

    }
    return round($result,2);


  }

Tva_Amount::amount_vat

(

)

Definition at line 104 of file class_tva_amount.php.

References get_vat_filter(), and load_parameter().

                        {
    // get the VAT code
   $this->load_parameter();
    $result=0;
    bcscale(4);
    for ($i=0;$i<count($this->param);$i++)
    {
        $tmp_calc=$this->get_vat_filter($this->param[$i]['tva_id'],$this->param[$i]['pcm_val']);
        $result=bcadd($result,$tmp_calc);

    }
    return round($result,2);


  }

Tva_Amount::get_amount_filter (   $p_code,   $p_account  )

private

get the amount of operation from the table quant_sold or quant_purchase

Returns

amount

Definition at line 124 of file class_tva_amount.php.

References $res, and $sql.

Referenced by amount_operation().

                                                         {
    if ( $this->dir == 'out' && trim($p_account) !='' && trim($p_code) !='' ) {
      $sql="select coalesce(sum(qs_price),0) as amount from quant_sold
          join jrnx using (j_id)
           where qs_vat_code=$1 and  (j_date >= to_date($2,'DD.MM.YYYY') and j_date <= to_date($3,'DD.MM.YYYY'))
           and j_poste::text like ($4)";
      $res=$this->db->get_array($sql,array($p_code,
                       $this->start_periode,
                       $this->end_periode,
                       $p_account));
      return $res[0]['amount'];
    }

    if ( $this->dir == 'in' && trim($p_account) !='' && trim($p_code) !='' ) {
      $sql="select coalesce(sum(qp_price),0) as amount from quant_purchase join jrnx using (j_id)
           where qp_vat_code=$1 and  (j_date >= to_date($2,'DD.MM.YYYY') and j_date <= to_date($3,'DD.MM.YYYY'))
           and j_poste::text like ($4)";
      $res=$this->db->get_array($sql,array($p_code,
                       $this->start_periode,
                       $this->end_periode,
                       $p_account));
      return $res[0]['amount'];
    }


    return 0;
  }

Tva_Amount::get_info

(

)

Definition at line 67 of file class_tva_amount.php.

{    return var_export(self::$variable,true);  }

Tva_Amount::get_parameter

(

$p_string

)

Definition at line 49 of file class_tva_amount.php.

                                           {
    if ( array_key_exists($p_string,self::$variable) ) {
      $idx=self::$variable[$p_string];
      return $this->$idx;
    }
    else
      throw new Exception("Attribut inexistant $p_string");
  }

Tva_Amount::get_vat_filter (   $p_code,   $p_account  )

private

get the amount of VAT from the table quant_sold or quant_purchase

Returns

amount

Definition at line 156 of file class_tva_amount.php.

References $res, and $sql.

Referenced by amount_vat().

                                                      {
    if ( $this->dir == 'out' && trim($p_account) !='' && trim($p_code) !='' ) {
      $sql="select coalesce(sum(qs_vat),0) as amount from quant_sold join jrnx using (j_id)
           where qs_vat_code=$1 and  (j_date >= to_date($2,'DD.MM.YYYY') and j_date <= to_date($3,'DD.MM.YYYY'))
           and j_poste::text like ($4)";
      $res=$this->db->get_array($sql,array($p_code,
                       $this->start_periode,
                       $this->end_periode,
                       $p_account));
      return $res[0]['amount'];
    }

    if ( $this->dir == 'in' && trim($p_account) !='' && trim($p_code) !='' ) {
      $sql="select coalesce(sum(qp_vat),0) as amount from quant_purchase join jrnx using (j_id)
           where qp_vat_code=$1 and  (j_date >= to_date($2,'DD.MM.YYYY') and j_date <= to_date($3,'DD.MM.YYYY'))
           and j_poste::text like ($4)";
      $res=$this->db->get_array($sql,array($p_code,
                       $this->start_periode,
                       $this->end_periode,
                       $p_account));
      return $res[0]['amount'];
    }


    return 0;
  }

Tva_Amount::load_parameter

(

)

load parameters and set param to a array of value from parameter_chld

Definition at line 74 of file class_tva_amount.php.

Referenced by amount_operation(), and amount_vat().

                                   {
    //  get the vat code
     $ctva=$this->db->get_array("select tva_id,pcm_val from tva_belge.parameter_chld where pcode=$1",array($this->grid));
     if ( count($ctva)== 0 ) {
       $this->param=null;
     }
     $this->param=$ctva;
  }

Tva_Amount::record_ledger

(

)

record into the ledger the operation for purging the the vat accouting

Definition at line 188 of file class_tva_amount.php.

                         {

}

Tva_Amount::set_parameter	(		$p_string,
			$p_value
	)

Definition at line 57 of file class_tva_amount.php.

                                                    {
    if ( array_key_exists($p_string,self::$variable) ) {
      $idx=self::$variable[$p_string];
      $this->$idx=$p_value;
    }
    else
      throw new Exception("Attribut inexistant $p_string");


  }

static Tva_Amount::test_me ( )

static

Parameters

\return

Note

See Also

Todo:

Definition at line 199 of file class_tva_amount.php.

                            {
  }

Tva_Amount::verify

(

)

Definition at line 68 of file class_tva_amount.php.

                           {
    // Verify that the elt we want to add is correct
  }

Field Documentation

Tva_Amount::$variable

staticprivate

Initial value:

=array('amount'=>'amount',
                 'amount_tva'=>'amount_tva',
                 'param'=>'param',
                 'dir'=>'dir',
                 'start_periode'=>'start_periode',
                 'end_periode'=>'end_periode',
                 'grid'=>'grid'
                 )

Definition at line 35 of file class_tva_amount.php.

---

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

• tva/class_tva_amount.php