Acc_Sold Class Reference

this class manage data from the QUANT_SOLD table More...

Inheritance diagram for Acc_Sold:

Collaboration diagram for Acc_Sold:

Public Member Functions
	__construct ($p_cn, $p_jrid=0)
	compute_array ()
	get ()
	retrieve some common data from jrn as the datum, the comment,payment limit...
Public Member Functions inherited from Acc_Operation
	__construct ($p_cn)
	constructor set automatically the attributes user and periode
	__toString ()
	display_jrnx_detail ($p_table)
	display_jrnx_detail : get the data from get_jrnx_data and return a string with HTML code
	find_tiers ($pn_jrn_id, $pn_jrnx_id, $p_code)
	Find the tiers of an operation , thanks the SQL prepared query prep_tiers and prep_counterpart.
	form_clone_operation ($p_id)
	create a form to recreate the operation and returns it, it works the same as when you want to correct an operation instead of confirming
	get_amount ()
	return amount of the jr_id
	get_currency_amount ()
	retrieve amount in currency for the operation
	get_data ($p_grpt)
	Get data from jrnx where p_grpt=jrnx(j_grpt)
	get_info ()
	retrieve info from the jrn_info, create 2 new arrays obj->info->command and obj->info->other the columns are the idx
	get_internal ()
	Return the internal value, the property jr_id must be set before.
	get_jrnx_detail ()
	retrieve data from jrnx
	get_ledger ()
	return the jrn_def_id from jrn
	get_quant ()
	retrieve data from the table QUANT_*
	get_sum_other_tax ()
	get the sum of other tax linked to this operation
	insert_jrn ()
	Insert into the table Jrn, the amount is computed from jrnx thanks the group id ($p_grpt)
	insert_jrnx ()
	Insert into the table Jrn The needed data are :
	insert_related_action ($p_string)
	operation_update_comment ($p_text)
	add a comment to the operation (jrn.jr_text)
	operation_update_date_limit ($p_text)
	add a limit of payment to the operation (jrn.jr_ech)
	save_info ($p_info, $p_type)
	Save into jrn_info.
	seek_group ()
	retrieve the grpt_id from jrn for a jr_id
	seek_internal ($p_internal)
	search an operation thankx it internal code
	set_id ($p_id)
	set the operation id (jrn.jr_id)
	set_paid ()
	flag the operation as paid
	update_comment ($p_text)
	add a comment to the line (jrnx.j_text)
	update_receipt ()
	set the pj of a operation in jrn. the jr_id must be set

Additional Inherited Members
Static Public Member Functions inherited from Acc_Operation
static	select_operation_type ($p_status)
	Return a select object to choose the type of operation.
static	test_me ()
Data Fields inherited from Acc_Detail
	$det
	$info
	$jr_id
Data Fields inherited from Acc_Operation
	$amount
	$currency_id
	$currency_rate
	$currency_rate_ref
	$date
	$date_paid
	$db
	$debit
	$desc
	$echeance
	$f_id
	$grpt
	$jr_id
	$jr_internal
	$jr_optype
	$jrn
	$jrn_id
	$jrnx_id
	$mt
	$periode
	$pj
	$poste
	$qcode
	< Qcode of item
	$signature
	$type
	$user

Detailed Description

this class manage data from the QUANT_SOLD table

Note

Data member are the column of the table

Definition at line 1152 of file acc_operation.class.php.

Constructor & Destructor Documentation

__construct()

Acc_Sold::__construct	(		$p_cn,
			$p_jrid = 0 )

Reimplemented from Acc_Detail.

Definition at line 1154 of file acc_operation.class.php.

    {
        parent::__construct($p_cn,$p_jrid);
        $this->signature='VEN';
        $this->det=new stdClass();
    }

Member Function Documentation

compute_array()

Acc_Sold::compute_array

(

)

Reimplemented from Acc_Detail.

Definition at line 1192 of file acc_operation.class.php.

    {
        $this->get();
        $array=parent::compute_array();
        $nb_array=count($this->det->array);
        $array['nb_item']=$nb_array;
        
        
        $array["e_client"]=$this->db->get_value("select ad_value from fiche_detail where f_id=$1 and ad_id=23",
                    array($this->det->array[0]['qs_client']));
            
        for ($i=0;$i<$nb_array;$i++) {
            $array["e_march".$i]=$this->db->get_value("select ad_value from fiche_detail where f_id=$1 and ad_id=23",
                    array($this->det->array[$i]['qs_fiche']));
            
            $array["e_march".$i."_price"]=$this->det->array[$i]['qs_unit'];
            $array["e_march".$i."_label"]=$this->det->array[$i]['j_text'];
            $array["e_march".$i."_tva_id"]=$this->det->array[$i]['qs_vat_code'];
            $array["e_march".$i."_tva_amount"]=$this->det->array[$i]['qs_vat'];
            $array["e_quant".$i]=$this->det->array[$i]['qs_quantite'];
         }
         $array['correct']=1;
        return $array;
        
    }

References $array, $i, $nb_array, and db.

get()

Acc_Sold::get

(

)

retrieve some common data from jrn as the datum, the comment,payment limit...

Reimplemented from Acc_Detail.

Definition at line 1160 of file acc_operation.class.php.

    {
        parent::get();
        $sql="
        select qs_id, qs_internal
, jx1.j_id
, qs1.qs_fiche
, qs1.qs_quantite
, qs1.qs_price
, qs1.qs_vat
, qs1.qs_vat_code
, qs1.qs_client
, qs1.qs_valid
, jx1.j_text
, qs_vat_sided
, qs_unit 
, jx1.j_debit
,oc1.oc_amount
,oc1.oc_vat_amount 
,oc1.oc_price_unit 
from quant_sold qs1
join jrnx jx1   using(j_id)
left join operation_currency oc1 using(j_id)
where jx1.j_grpt = $1
order by jx1.j_id;
        ";
        $this->det->array=$this->db->get_array($sql,array($this->det->jr_grpt_id));
    }

References $sql, and db.

---

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

• include/class/acc_operation.class.php