Tax_Detail Class Reference

Collaboration diagram for Tax_Detail:

Public Member Functions
	__construct ($tva_code, $from, $to, $ledger_id)
	button_export_csv ()
	csv ()
	export the result in a CSV file
	get_data ()
	get data
	html ()
	display the result in HTML

Static Public Member Functions
static	display_form ()
	display a form for giving tva_code and dates

Protected Attributes
	$from
	Start date.
	$ledger_id
	ledger_id (jrn_def.jrn_def_id) -1, means all ledger Sale + Purchase
	$to
	end date
	$tva_code
	tva_code

Detailed Description

Definition at line 25 of file tax_detail.class.php.

Constructor & Destructor Documentation

__construct()

Tax_Detail::__construct	(		$tva_code,
			$from,
			$to,
			$ledger_id )

Definition at line 32 of file tax_detail.class.php.

                                                         {
 
        $this->tva_code=$tva_code;
        $this->from=$from;
        $this->to=$to;
        $this->ledger_id=$ledger_id;
 
    }

References $from, $ledger_id, $to, $tva_code, from, and to.

Member Function Documentation

button_export_csv()

Tax_Detail::button_export_csv

(

)

Definition at line 152 of file tax_detail.class.php.

    {
        require NOALYSS_TEMPLATE."/tax_detail-button_export_csv.php";
    }

csv()

Tax_Detail::csv

(

)

export the result in a CSV file

Definition at line 160 of file tax_detail.class.php.

                   {
        $noalyss_csv=new Noalyss_Csv(sprintf("tax_detail-{$this->tva_code}-{$this->from}-{$this->to}"));
        $data=$this->get_data();
 
        $header=[_("date"),_('piece'),_("n° interne"),_("fiche"),_("poste"),_("base"),_("privé"),_("code tva"),_("taux"),_("montant tva"),_("non deductible"),_("recup")];
        $noalyss_csv->send_header();
        $noalyss_csv->write_header($header  );
        foreach ($data as $item) {
 
            $noalyss_csv->add($item['str_date']);
            $noalyss_csv->add($item['jr_pj_number']);
            $noalyss_csv->add($item['jr_internal']);
            $noalyss_csv->add($item['j_qcode']);
            $noalyss_csv->add($item['j_poste']);
            $noalyss_csv->add(nb($item['j_montant'],2),"number");
            $noalyss_csv->add(nb($item['qp_dep_priv'],2),"number");
            $noalyss_csv->add($item['tva_code']);
            $noalyss_csv->add(nb($item['tva_rate'],2),"number");
            $noalyss_csv->add(nb($item['vat_amount'],2),"number");
            $noalyss_csv->add(nb($item['qp_nd_tva'],2),"number");
            $noalyss_csv->add(nb($item['qp_nd_tva_recup'],2),"number");
            $noalyss_csv->write();
 
        }
    }

References $data, $header, _, get_data(), and nb().

Here is the call graph for this function:

display_form()

static Tax_Detail::display_form ( )

static

display a form for giving tva_code and dates

Returns

void

Definition at line 45 of file tax_detail.class.php.

    {
        require_once NOALYSS_TEMPLATE."/tax_detail-display_form.php";
    }

get_data()

Tax_Detail::get_data

(

)

get data

Definition at line 53 of file tax_detail.class.php.

    {
        global $g_user,$cn;
        $filter_ledger=" where ";
 
 
        // Security
        if ($g_user->get_status_security_ledger()==1 && $g_user->isAdmin()==0)  {
            $sSecurity=$g_user->get_ledger_sql('ALL')."   and ";
            $sSecurity=str_replace('jrn_def_id','v1.jr_def_id',$sSecurity);
            $filter_ledger.=$sSecurity;
        }
 
        // filter on the date
        $filter_ledger.="  jr_date >= to_date ($1,'DD.MM.YYYY') and jr_date <= to_date($2,'DD.MM.YYYY')";
 
        // SQL index of array for  array used in DatabaseCore::get_array
        $param_idx=3;
        $aParameter=array($this->from,$this->to);
 
        // filter on vat_code
        if ( !empty($this->tva_code ) )
        {
            $acc_tva=Acc_Tva::build($cn, $this->tva_code);
            $filter_ledger.=" and tva_opid = \$$param_idx ";
            $aParameter[]=$acc_tva->tva_id;
            $param_idx++;
        }
        // filter on the ledger
        if ( $this->ledger_id <> -1 ) {
            $filter_ledger.= " and jr_def_id = \$$param_idx";
            $param_idx++;
            $aParameter[]=$this->ledger_id;
 
        }
        $sql="
with v_amount_tva as (select 
                        f_id
                        ,j_qcode
                        ,case when j_debit is true then 0-j_montant else j_montant end j_montant
                     , qp_vat_code tva_opid
                     ,  0-qp_nd_tva  qp_nd_tva
                     ,  0-qp_nd_tva_recup  qp_nd_tva_recup
                     ,  0-qp_dep_priv  qp_dep_priv
                     , qp_vat_sided
                     , j_poste
                     , j_debit
                     , j_text
                     , jr2.jr_id
                     , jr2.jr_pj_number
                     , jr2.jr_internal
                    ,jr2.jr_date
                    ,to_char(jr2.jr_date,'DD.MM.YY') str_date
                    ,jr_def_id
                    ,0-qp_vat vat_amount
                from jrnx jr1
                join jrn jr2 on (jr1.j_grpt = jr2.jr_grpt_id) 
                 join  quant_purchase q1        using (j_id)
                union all 
                select f_id
                        ,j_qcode
                        ,case when j_debit is true then 0-j_montant else j_montant end
                     , qs_vat_code
                     , 0
                     , 0
                     , 0
                     , 0
                     , j_poste
                     , j_debit
                     , j_text
                     , jr4.jr_id
                     , jr4.jr_pj_number
                     , jr4.jr_internal
                    ,jr4.jr_date
                    ,to_char(jr4.jr_date,'DD.MM.YY')
                    ,jr_def_id
                    ,qs_vat
                from  jrnx jr3 
                join jrn jr4 on (jr3.j_grpt = jr4.jr_grpt_id)
                 join quant_sold qs using (j_id)
                )
select *, tva_label,format ('%s (%s)',t1.tva_code ,t1.tva_label) tva_code,tva_rate
from v_amount_tva v1
join tva_rate t1 on (v1.tva_opid=t1.tva_id)
$filter_ledger      
order by jr_date,j_debit
        ";
        $data=$cn->get_array($sql,$aParameter);
        return $data;
    }

References $cn, $data, $filter_ledger, $g_user, $ledger_id, $sql, Acc_Tva\build(), from, and to.

Referenced by csv(), and html().

Here is the call graph for this function:

html()

Tax_Detail::html

(

)

display the result in HTML

Returns

void

Definition at line 147 of file tax_detail.class.php.

                    {
        global $data;
        $data=$this->get_data();
        require NOALYSS_TEMPLATE."/tax_detail-html.php";
    }

References $data, and get_data().

Here is the call graph for this function:

Field Documentation

$from

Tax_Detail::$from

protected

Start date.

Definition at line 27 of file tax_detail.class.php.

Referenced by __construct().

$ledger_id

Tax_Detail::$ledger_id

protected

ledger_id (jrn_def.jrn_def_id) -1, means all ledger Sale + Purchase

Definition at line 30 of file tax_detail.class.php.

Referenced by __construct(), and get_data().

$to

Tax_Detail::$to

protected

end date

Definition at line 28 of file tax_detail.class.php.

Referenced by __construct().

$tva_code

Tax_Detail::$tva_code

protected

tva_code

Definition at line 29 of file tax_detail.class.php.

Referenced by __construct().

---

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

• include/class/tax_detail.class.php