class Customer are a specific kind of card More...

Inheritance diagram for Customer:

Collaboration diagram for Customer:

Public Member Functions
	__construct ($p_cn, $p_id=0)
	Constructor /* only a db connection is needed. More...

	get_by_account ($p_poste=0)
	Get all info contains in the view thanks to the poste elt (account) More...

	VatListing ($p_year)
	Get all the info for making a vat listing for the vat administration. More...

Public Member Functions inherited from Fiche
	__construct ($p_cn, $p_id=0)

	__toString ()

	belong_ledger ($p_jrn, $p_type="")
	Check if a fiche is used by a jrn return 1 if the fiche is in the range otherwise 0, the quick_code or the id must be set. More...

	blank ($p_fiche_def)
	insert a new record show a blank card to be filled More...

	build_sql ($array)
	create the sql statement for retrieving all the card More...

	button_csv ($p_from, $p_to)
	Return a string with the HTML code to display a button to export the history in CSV. More...

	button_pdf ($p_from, $p_to)
	Return a string with the HTML code to display a button to export the history in PDF. More...

	count_by_modele ($p_frd_id, $p_search="", $p_sql="")
	Count the nb of card with the reference card id frd_id. More...

	delete ()

	Display ($p_readonly, $p_in="")
	Display object instance, getAttribute sort the attribute and add missing ones. More...

	display_row ()
	display card as a table row , the tag TR must be added More...

	empty_attribute ($p_attr)
	check if an attribute is empty More...

	filter_history ($p_table_id)
	Filter in javascript the table with the history. More...

	Get ()
	Synonum of fiche::getAttribut. More...

	get_all_account ()

	get_amount_side ($p_amount)
	return the letter C if amount is > 0, D if < 0 or = More...

	get_bank_ledger ()
	Returns the Acc_Ledger_Fin ledger for which the card is the default bank account or null if no ledger is found. More...

	get_bk_account ()
	get the available bank_account filtered by the security More...

	get_bk_balance ($p_cond="")
	get the bank balance with receipt or not in Euro More...

	get_bk_balance_currency ($p_cond="")
	Get the sum in Currency. More...

	get_by_category ($p_offset=-1, $p_search="", $p_order='')
	get all the card thanks the fiche_def_ref More...

	get_by_qcode ($p_qcode=null, $p_all=true)
	Retrieve a card thx his quick_code complete the object,, set the id member of the object or set it to 0 if no card is found. More...

	get_categorie ()
	get the fd_id of the card : fd_id, it set the attribute fd_id More...

	get_f_enable ()

	get_fiche_def_ref ()

	get_fiche_def_ref_id ()
	retrieve the frd_id of the fiche it is the type of the card (bank, purchase...) (fiche_def_ref primary key) More...

	get_gestion_title ()

	get_id ()

	get_quick_code ()
	return the quick_code of a card More...

	get_row ($p_from, $p_to)
	Get data for poste. More...

	get_row_date ($p_from, $p_to, $op_let=0)
	Get data for poste. More...

	get_solde_detail ($p_cond="")
	give the balance of an card More...

	getAttribut ()
	get all the attribute of a card, add missing ones and sort the array ($this->attribut) by ad_id More...

	GetByDef ($p_frd_id, $p_offset=-1, $p_search="", $p_order='')
	Return array of card from the frd family deprecated , use insert get_by_category_id. More...

	getDisplayMode ()

	getLabelCategory ()

	getName ()
	return the name of a card More...

	HtmlTable ($p_array=null, $op_let=0, $from_div=1)
	HtmlTable, display a HTML of a card for the asked period. More...

	HtmlTableDetail ($p_array=null, $op_let=0)
	HtmlTable, display a HTML of a card for the asked period. More...

	HtmlTableHeader ($p_array=null)
	Display HTML Table Header (button) More...

	insert ($p_fiche_def, $p_array=null, $transaction=true)
	insert a new record thanks an array , either as parameter or $_POST More...

	is_used ()
	check if a card is used More...

	load ()
	Synonum of fiche::getAttribut. More...

	move_to ($p_fdid)
	move a card to another cat. More...

	remove ($silent=false)
	remove a card, check if not used first, must be synchro with is_used More...

	save ($p_fiche_def=0)
	Save a card, call insert or update. More...

	seek ($p_attribut, $p_value)
	find the card with the p_attribut equal to p_value, it is not case sensitive More...

	set_f_enable ($f_enable)

	set_fiche_def ($p_fiche_def)

	set_fiche_def_ref ($fiche_def_ref)

	set_id ($id)

	setAttribut ($p_ad_id, $p_value)
	set an attribute by a value, if the attribut array is empty a call to getAttribut is performed More...

	setDisplayMode ($p_mode)
	how the card is display : either in a window or a greated container More...

	ShowTable ()

	strAttribut ($p_ad_id, $p_return=1)

	Summary ($p_search="", $p_action="", $p_sql="", $p_amount=false)
	show the default screen More...

	to_array ()
	turn a card into an array , then it can be saved thanks update or insert More...

	update ($p_array=null)
	update a card with an array More...

Data Fields
	$country

	$cp

	$name

	$poste

	$street

	$vat_number

Data Fields inherited from Fiche
	$attribut

	$cn

	$fiche_def

	$fiche_def_ref

	$id

	$quick_code

	$row

	$tot_cred

	$tot_deb

Additional Inherited Members
Static Public Member Functions inherited from Fiche
static	cmp_name (Fiche $o1, Fiche $o2)
	used with a usort function, to sort an array of Fiche on the name More...

static	from_qcode ($p_qcode)
	create a card from a qcode and returns a card More...

static	get_fiche_def ($p_cn, $pFd_id, $p_order='')
	get all the card from a categorie More...

static	test_me ()

Detailed Description

class Customer are a specific kind of card

Definition at line 31 of file customer.class.php.

Constructor & Destructor Documentation

◆ __construct()

Customer::__construct	(	$p_cn,
		$p_id = `0`
	)

Constructor /* only a db connection is needed.

Reimplemented from Fiche.

Definition at line 43 of file customer.class.php.

    {
        $this->fiche_def_ref=FICHE_TYPE_CLIENT;
        parent::__construct($p_cn,$p_id) ;
 
    }

References $p_id, and FICHE_TYPE_CLIENT.

Member Function Documentation

◆ get_by_account()

Customer::get_by_account ( $p_poste = 0 )

Get all info contains in the view thanks to the poste elt (account)

Definition at line 52 of file customer.class.php.

    {
        $this->poste=($p_poste==0)?$this->poste:$p_poste;
        $sql="select * from vw_client where poste_comptable=$1";
        $Res=$this->cn->exec_sql($sql,array($this->poste));
        if ( Database::num_row($Res) == 0) return null;
        if ( Database::num_row($Res) > 1 ) throw new Exception ('Plusieurs fiches avec le même poste',1);
        // There is only _one_ row by customer
        $row=Database::fetch_array($Res,0);
        $this->name=$row['name'];
        $this->id=$row['f_id'];
        $this->street=$row['rue'];
        $this->cp=$row['code_postal'];
        $this->country=$row['pays'];
        $this->vat_number=$row['tva_num'];
 
    }

References $Res, Fiche\$row, $sql, cn, DatabaseCore\fetch_array(), name, and DatabaseCore\num_row().

Here is the call graph for this function:

◆ VatListing()

Customer::VatListing ( $p_year )

Get all the info for making a vat listing for the vat administration.

Parameters

$p_year

Returns: double array structure is ( j_poste,name,vat_number,amount,tva,customer(object)

Definition at line 79 of file customer.class.php.

    {
        $cond_sql=" and   A.j_date = B.j_date and extract(year from A.j_date) ='$p_year'";
        /* List of customer  */
        $aCustomer=$this->cn->get_array('select f_id,name,quick_code,tva_num,poste_comptable from vw_client '.
                                        " where tva_num !='' ");
 
        /* Use the code */
 
        // BASE ACCOUNT
        // for belgium
        $s=new Acc_Parm_Code($this->cn,'VENTE');
        $s->load();
        $SOLD=$s->p_value;
 
        $c=new Acc_Parm_Code($this->cn,'CUSTOMER');
        $c->load();
        $CUSTOMER=$c->p_value;
 
        $t=new Acc_Parm_Code($this->cn,'COMPTE_TVA');
        $t->load();
        $TVA=$t->p_value;
 
        $a_Res=array();
        /* for each customer compute VAT, Amount...*/
        foreach ($aCustomer as $l )
        {
            // Seek the customer
            //---
            $customer=$l['quick_code'];
            $a_Res[$customer]['name']=$l['name'];
            $a_Res[$customer]['vat_number']=$l['tva_num'];
            $a_Res[$customer]['amount']=0;
            $a_Res[$customer]['tva']=0;
            $a_Res[$customer]['poste_comptable']=$l['poste_comptable'];
            /* retrieve only operation of sold and vat */
            // Get all the sell operation
            //----
            $sql="select distinct j_grpt
                 from
                 jrnx as A
                 join jrnx as B using (j_grpt)
                 where
                 A.j_qcode = '".$l['quick_code']."' and
                 B.j_poste::text like '".$SOLD."%'
                 $cond_sql
                 ";
 
            $Res=$this->cn->exec_sql($sql);
            // Foreach operation
            // where 7% or tva account are involved
            // and store the result in an array (a_Res)
            //---
 
            for ($i=0; $i < Database::num_row($Res);$i++)
            {
                // Get each row
                //---
                $row1=Database::fetch_array($Res,$i);
 
 
                // select the operation
                //----
                $Res2=$this->cn->exec_sql("select j_poste,j_montant,j_debit from jrnx where j_grpt=$1",[$row1['j_grpt']]);
                $a_row=Database::fetch_all($Res2);
                if ($a_row==FALSE) $a_row=[];
                
                // Store the amount in the array
                //---
                foreach ($a_row as $e)
                {
                    $amount=0;
                    $tva=0;
                    if ( substr($e['j_poste'],0, strlen($SOLD))===$SOLD)
                    {
                        $amount=($e['j_debit']=='f')?$e['j_montant']:$e['j_montant']*-1;
                    }
                    if ( substr($e['j_poste'],0, strlen($TVA))===$TVA)
                    {
                        $tva=($e['j_debit']=='f')?$e['j_montant']:$e['j_montant']*-1;
                    }
                    // store sold
                    //---
                    $a_Res[$customer]['amount']=(isset($a_Res[$customer]['amount']))?$a_Res[$customer]['amount']:0;
                    $a_Res[$customer]['amount']+=$amount;
 
                    // store vat
                    //---
                    $a_Res[$customer]['tva']=(isset($a_Res[$customer]['tva']))?$a_Res[$customer]['tva']:0;
                    $a_Res[$customer]['tva']+=$tva;
 
                    // store customef info
                    //---
                    $a_Res[$customer]['customer']=$customer;
                }
            }// foreach $a
        } // foreach ( customer)
 
        return $a_Res;
    }

References $a_row, $amount, $e, $i, $l, $Res, $s, $sql, cn, DatabaseCore\fetch_all(), DatabaseCore\fetch_array(), and DatabaseCore\num_row().

Here is the call graph for this function:

Field Documentation

◆ $country

Customer::$country

$country Country

Definition at line 37 of file customer.class.php.

◆ $cp

Customer::$cp

$cp Zip code

Definition at line 38 of file customer.class.php.

◆ $name

Customer::$name

$name name of the company

Definition at line 35 of file customer.class.php.

◆ $poste

Customer::$poste

$poste poste comptable

Definition at line 34 of file customer.class.php.

◆ $street

Customer::$street

$street Street

Definition at line 36 of file customer.class.php.

◆ $vat_number

Customer::$vat_number

$vat_number vat number

Definition at line 39 of file customer.class.php.

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

include/class/customer.class.php

Public Member Functions

Data Fields

Additional Inherited Members