Print_Ledger_Simple Class Reference

this class extends PDF and let you export the detailled printing of any ledgers More...

Inheritance diagram for Print_Ledger_Simple:

Collaboration diagram for Print_Ledger_Simple:

Public Member Functions
	__construct ($p_cn, Acc_Ledger $p_jrn, $p_from, $p_to, $p_filter_operation)
	export ()
	export the ledger in PDF More...
	Footer ()
	write the Footer More...
	Header ()
	write the header of each page More...
	setDossierInfo ($dossier="n/a")
Public Member Functions inherited from Print_Ledger
	__construct (\Database $p_cn, $orientation, $unit, $format, Acc_Ledger $p_ledger, $p_from, $p_to, $p_filter_operation)
	integer parm_periode.p_id , end periode; More...
	get_filter_operation ()
	get_from ()
	get_ledger ()
	get_to ()
	set_filter_operation ($filter_operation)
	Filter the operations ,. More...
	set_from ($from)
	set_ledger ($ledger)
	set_to ($to)
Public Member Functions inherited from PDF
	__construct (Database $p_cn, $orientation='P', $unit='mm', $format='A4')
	Footer ()
	get_tiers ($p_jr_id, $p_jrn_type)
	retrieve the client name and quick_code More...
	Header ()
	set_filter_operation ($filter_operation)
	setDossierInfo ($dossier="n/a")
Public Member Functions inherited from PDF_Core
	__construct ( $orientation='P', $unit='mm', $format='A4')
	get_margin_bottom ()
	get_margin_left ()
	get_margin_right ()
	get_margin_top ()
	get_orientation ()
	get_page_size ()
	get_unit ()
	is_fill ($p_step)
	If the step is even then return 1 and set the backgroup color to blue , otherwise returns 0, and set the background color to white It is use to compute alternated colored row , it the parameter fill in write_cell and cell. More...
	line_new ($p_step=null)
	Print all the cell stored and call Ln (new line) More...
	LongLine ($w, $h, $txt, $border=0, $align='', $fill=false)
	write_cell ($w, $h=0, $txt='', $border=0, $ln=0, $align='', $fill=false, $link='')

Additional Inherited Members
Static Public Member Functions inherited from Print_Ledger
static	available_ledger ($get_from_periode)
	find all the active ledger for the exerice of the periode and readable by the current user @global type $g_user More...
static	factory (Database $cn, $p_type_export, Acc_Ledger $p_ledger, $p_from, $p_to, $p_filter_operation)
	Create an object Print_Ledger* depending on $p_type_export ( 0 => accounting 1-> one row per operation 2-> detail of item) More...
Data Fields inherited from PDF
	$cn = null
	$date = ""
	$dossier = "n/a"
	$own = null
	$soc = ""
Protected Member Functions inherited from Print_Ledger
	build_filter_operation ()
	Build a SQL clause to filter operation depending if they are paid, unpaid or no filter. More...
Protected Member Functions inherited from PDF_Core
	print_row ()
	print the current array of cell and reset it , if different colors are set on the same row you have to print it before changing More...
Protected Attributes inherited from Print_Ledger
	$filter_operation

Detailed Description

this class extends PDF and let you export the detailled printing of any ledgers

Definition at line 33 of file print_ledger_simple.class.php.

Constructor & Destructor Documentation

__construct()

Print_Ledger_Simple::__construct	(		$p_cn,
		Acc_Ledger	$p_jrn,
			$p_from,
			$p_to,
			$p_filter_operation
	)

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

    {
 
        parent::__construct($p_cn,'L', 'mm', 'A4',$p_jrn,$p_from,$p_to,$p_filter_operation);
        
        $this->a_Tva=$this->get_ledger()->existing_vat();
        foreach($this->a_Tva as $line_tva)
        {
            //initialize Amount TVA
            $tmp1=$line_tva['tva_id'];
            $this->rap_tva[$tmp1]=0;
        }
        $this->rap_other_tax=0;
        $this->jrn_type=$p_jrn->get_type();
        //----------------------------------------------------------------------
        /* report
         *
         * get rappel to initialize amount rap_xx
         *the easiest way is to compute sum from quant_
         */
        $from_periode=$this->get_from();
        $this->previous=$this->get_ledger()->previous_amount($from_periode);
        $this->other_tax_previous=$this->get_ledger()->previous_other_tax($from_periode);
 
        /* initialize the amount to report */
        foreach($this->previous['tva'] as $line_tva)
        {
            //initialize Amount TVA
            $tmp1=$line_tva['tva_id'];
            $this->rap_tva[$tmp1]=$line_tva['sum_vat'];
        }
 
        $this->rap_htva=$this->previous['price'];
        $this->rap_tvac=bcadd($this->previous['price'],$this->previous['vat']);
        $this->rap_tvac=bcadd($this->rap_tvac,$this->previous['tva_nd']);
        $this->rap_tvac=bcsub($this->rap_tvac,$this->previous['tva_np']);
        $this->rap_tvac=bcsub($this->rap_tvac,$this->previous['reversed']);
        $this->rap_priv=$this->previous['priv'];
        $this->rap_nd=$this->previous['tva_nd'];
        $this->rap_tva_np=$this->previous['tva_np'];
        $this->flag_other_tax=false;
 
        if ($this->jrn_type == 'ACH' || $this->jrn_type=='VEN') {
            $periode=new Periode($p_cn,$p_from);
            $first_date=$periode->first_day();
            $periode=new Periode($p_cn,$p_to);
            $last_date=$periode->last_day();
 
            $count=$this->cn->get_value("
                select          count(*) 
                from jrn_tax join jrnx using (j_id) 
                join jrn on (j_grpt=jr_grpt_id) where
                    j_date >= to_date($1,'DD.MM.YYYY')
                    and j_date <= to_date($2,'DD.MM.YYYY')
                    and j_jrn_def=$3",
                array($first_date,$last_date,$p_jrn->id));
            if ($count>0) { $this->flag_other_tax=true;}
        }
    }

References $count, $from_periode, $p_jrn, $periode, cn, Print_Ledger\get_from(), and Print_Ledger\get_ledger().

Here is the call graph for this function:

Member Function Documentation

export()

Print_Ledger_Simple::export

(

)

export the ledger in PDF

Definition at line 253 of file print_ledger_simple.class.php.

    {
        bcscale(4);
        $ledger=$this->get_ledger();
        $ledger_history=Acc_Ledger_History::factory($this->cn, 
                                        array($ledger->id), 
                                        $this->get_from(), 
                                        $this->get_to(), 
                                        'D', 
                                        $this->get_filter_operation());
        $ledger_history->get_row();
        $a_jrn=$ledger_history->get_data();
 
        if ( $a_jrn == null ) return;
        
        // Count the number of VAT cols
        $flag_tva=(count($this->a_Tva) > 4)?true:false;
        
        // Prepare the query for reconcile date
        $prepared_query=new Prepared_Query($ledger->db);
        $prepared_query->prepare_reconcile_date();
        
        for ( $i=0;$i<count($a_jrn);$i++)
        {
            /* initialize tva */
            for ($f=0;$f<count($this->a_Tva);$f++)
            {
                $l=$this->a_Tva[$f]['tva_id'];
                $atva_amount[$l]=0;
            }
 
            // retrieve info from ledger
            $aAmountVat=$ledger->vat_operation($a_jrn[$i]['jr_grpt_id']);
 
            // put vat into array
            for ($f=0;$f<count($aAmountVat);$f++)
            {
                $l=$aAmountVat[$f]['tva_id'];
                $atva_amount[$l]=bcadd($atva_amount[$l],$aAmountVat[$f]['sum_vat']);
                $this->tp_tva[$l]=bcadd($this->tp_tva[$l],$aAmountVat[$f]['sum_vat']);
                $this->rap_tva[$l]=bcadd($this->rap_tva[$l],$aAmountVat[$f]['sum_vat']);
                
            }
            $row=$a_jrn[$i];
            $ret_reconcile=$ledger->db->execute('reconcile_date',array($row['jr_id']));
            $this->LongLine(15,5,($row['jr_pj_number']),0);
            $this->write_cell(10,5,$row['str_date_short'],0,0);
            $this->write_cell(13,5,$row['jr_internal'],0,0);
            list($qc,$name)=$this->get_tiers($row['jr_id'],$this->jrn_type);
            $this->LongLine(40,5,"[".$qc."]".$name,0,'L');
 
            if ( !$flag_tva )    {        
            $this->LongLine(65,5,mb_substr($row['jr_comment'],0,150),0,'L');
            }
 
            /* get other amount (without vat, total vat included, private, ND */
            $other=$ledger->get_other_amount($a_jrn[$i]['jr_grpt_id']);
            
            $this->write_cell(15,5,nbm($other['price']),0,0,'R');
            
            if ( $ledger_history->get_ledger_type() !='VEN')
            {
              $this->write_cell(15,5,nbm($other['priv']),0,0,'R');
              $this->write_cell(15,5,nbm($other['tva_nd']),0,0,'R');
            }
            
            $this->write_cell(15,5,nbm($other['tva_np']),0,0,'R');
            
            foreach ($atva_amount as $row_atva_amount)
            {
                    $this->write_cell(15, 5, nbm($row_atva_amount), 0, 0, 'R');
            }
 
            $l_tvac=bcadd($other['price'], bcsub($other['vat'],$other['tva_np']));
            $l_tvac=bcadd($l_tvac,$other['tva_nd']);
                $l_tvac=bcadd($l_tvac,$a_jrn[$i]['other_tax_amount']);
            if ($this->flag_other_tax) {
                $this->write_cell(15, 5, nbm($a_jrn[$i]['other_tax_amount']), 0, 0, 'R');
            }
            $this->write_cell(15,5,nbm($l_tvac),0,0,'R');
            $this->line_new(2);
            // Add the payment information on another row
            $max=Database::num_row($ret_reconcile);
            $str_payment="";
            if ($max > 0) {
                $this->write_cell(15,5, _("Payé par"));
                $sep="";
                for ($e=0;$e<$max;$e++) {
                    $row=Database::fetch_array($ret_reconcile, $e);
                    $msg=( $row['qcode_bank'] != "")?"[".$row['qcode_bank']."]".$row['qcode_name']:$row['jr_internal'];
                    $str_payment=$row['jr_date'].$msg.$sep;
                    $sep=' , ';
                }
                $this->write_cell (120,5,$str_payment);
            }
            
            
            $this->line_new(3);
            // Total page
            $this->tp_htva=bcadd($this->tp_htva,$other['price']);
            $this->tp_tvac=bcadd($this->tp_tvac,$other['price']);
            $this->tp_tvac=bcadd($this->tp_tvac,$other['vat']);
            $this->tp_tvac=bcadd($this->tp_tvac,$other['tva_nd']);
            $this->tp_tvac=bcsub($this->tp_tvac,$other['tva_np']);
            $this->tp_tva_np=bcadd($this->tp_tva_np,$other['tva_np']);
            $this->tp_priv=bcadd($this->tp_priv,$other['priv']);
            $this->tp_nd=bcadd($this->tp_nd,$other['tva_nd']);
 
 
            // Total report
            $this->rap_htva=bcadd($this->rap_htva,$other['price']);
            $this->rap_tvac=bcadd($this->rap_tvac,$other['price']);
            $this->rap_tvac=bcadd($this->rap_tvac,$other['vat']);
            $this->rap_tvac=bcsub($this->rap_tvac,$other['tva_np']);
            $this->rap_tvac=bcadd($this->rap_tvac,$other['tva_nd']);
            $this->rap_priv=bcadd($this->rap_priv,$other['priv']);
            $this->rap_nd=bcadd($this->rap_nd,$other['tva_nd']);
            $this->rap_tva_np=bcadd($this->rap_tva_np,$other['tva_np']);
 
            if ($this->flag_other_tax) {
                $this->tp_other_tax = bcadd($this->tp_other_tax, $a_jrn[$i]['other_tax_amount']);
                $this->rap_other_tax = bcadd($this->rap_other_tax, $a_jrn[$i]['other_tax_amount']);
            }
 
        }
    }

References $e, $f, $i, $l, Print_Ledger\$ledger, $max, $msg, $name, $other, $ret_reconcile, $row, $sep, cn, Acc_Ledger_History\factory(), DatabaseCore\fetch_array(), Print_Ledger\get_ledger(), PDF\get_tiers(), PDF_Core\line_new(), PDF_Core\LongLine(), nbm(), DatabaseCore\num_row(), and PDF_Core\write_cell().

Here is the call graph for this function:

Footer()

Print_Ledger_Simple::Footer

(

)

write the Footer

Reimplemented from PDF.

Definition at line 187 of file print_ledger_simple.class.php.

    {
        //Position at 3 cm from bottom
        $this->SetY(-20);
        /* write reporting  */
        $flag_tva=(count($this->a_Tva) > 4)?true:false;
        if ( ! $flag_tva)
            $this->Cell(143,6,'Total page ','T',0,'R'); /* HTVA */
        else
            $this->Cell(78,6,'Total page ','T',0,'R'); /* HTVA */
        
        $this->Cell(15,6,nbm($this->tp_htva),'T',0,'R'); /* HTVA */
        if ( $this->jrn_type !='VEN')
        {
            $this->Cell(15,6,nbm($this->tp_priv),'T',0,'R');  /* prive */
            $this->Cell(15,6,nbm($this->tp_nd),'T',0,'R');  /* Tva ND */
        }
        $this->Cell(15,6,nbm($this->tp_tva_np),'T',0,'R');  /* Tva Unpaid */
        foreach($this->a_Tva as $line_tva)
        {
            $l=$line_tva['tva_id'];
            $this->Cell(15,6,nbm($this->tp_tva[$l]),'T',0,'R');
        }
        if ($this->flag_other_tax) {
            $this->Cell(15, 6, nbm($this->tp_other_tax), 'T', 0, 'R'); /* Tvac */
        }
        $this->Cell(15,6,nbm($this->tp_tvac),'T',0,'R'); /* Tvac */
        $this->Ln(2);
        $flag_tva=(count($this->a_Tva) > 4)?true:false;
        
        if ( ! $flag_tva)
            $this->Cell(143,6,'report',0,0,'R');
        else 
            $this->Cell(78,6,'report',0,0,'R');
        
        $this->Cell(15,6,nbm($this->rap_htva),0,0,'R'); /* HTVA */
        if ( $this->jrn_type !='VEN')
        {
            $this->Cell(15,6,nbm($this->rap_priv),0,0,'R');  /* prive */
            $this->Cell(15,6,nbm($this->rap_nd),0,0,'R');  /* Tva ND */
        }
        $this->Cell(15,6,nbm($this->rap_tva_np),0,0,'R');  /* Tva ND */
        
        foreach($this->a_Tva as $line_tva)
        {
            $l=$line_tva['tva_id'];
            $this->Cell(15,6,nbm($this->rap_tva[$l]),0,0,'R');
        }
        if ($this->flag_other_tax) {
            $this->Cell(15, 6, nbm($this->rap_other_tax), 0, 0, 'R'); /* Other tax */
        }
        $this->Cell(15,6,nbm($this->rap_tvac),0,0,'R'); /* Tvac */
        $this->Ln(2);
 
        //Arial italic 8
        $this->SetFont('Arial', 'I', 8);
        //Page number
        $this->Cell(0,8,'Date '.$this->date." - Page ".$this->PageNo().'/{nb}',0,0,'L');
        // Created by NOALYSS
        $this->Cell(0,8,'Created by NOALYSS, online on https://www.noalyss.eu',0,0,'R',false,'https://www.noalyss.eu');
    }

References $l, and nbm().

Here is the call graph for this function:

Header()

Print_Ledger_Simple::Header

(

)

write the header of each page

Reimplemented from PDF.

Definition at line 102 of file print_ledger_simple.class.php.

    {
        //Arial bold 12
        $this->SetFont('DejaVu', 'B', 12);
        //Title
        $this->Cell(0,10,$this->dossier, 'B', 0, 'C');
        //Line break
        $this->Ln(20);
        $this->SetFont('DejaVu', 'B', 8);
        /* column header */
        //----------------------------------------------------------------------
        // Show column header, if $flag_tva is false then display vat as column
        foreach($this->a_Tva as $line_tva)
        {
            //initialize Amount TVA
            $tmp1=$line_tva['tva_id'];
            $this->rap_tva[$tmp1]=(isset($this->rap_tva[$tmp1]))?$this->rap_tva[$tmp1]:0;
        }
        $this->Cell(15,6,_('Pièce'));
        $this->Cell(10,6,_('Date'));
        $this->Cell(13,6,_('ref'));
        if ( $this->jrn_type=='ACH')
            $this->Cell(40,6,_('Client'));
        else
            $this->Cell(40,6,_('Fournisseur'));
 
        $flag_tva=(count($this->a_Tva) > 4)?true:false;
        if ( !$flag_tva )      $this->Cell(65,6,_('Description'));
 
        $this->Cell(15,6,_('HTVA'),0,0,'R');
        if ( $this->jrn_type=='ACH')
        {
            $this->Cell(15,6,_('Priv/DNA'),0,0,'R');
            $this->Cell(15,6,_('TVA ND'),0,0,'R');
        }
        $this->Cell(15,6,_('TVA NP'),0,0,'R'); // Unpaid TVA --> autoliquidation, NPR
        foreach($this->a_Tva as $line_tva)
        {
            $this->Cell(15,6,$line_tva['tva_label'],0,0,'R');
        }
        if ($this->flag_other_tax) {
            $this->Cell(15,6,'Autre Tx',0,0,'R');
 
        }
        $this->Cell(15,6,'TVAC',0,0,'R');
        $this->Ln(5);
 
        $this->SetFont('DejaVu','',6);
        // page Header
        if ( ! $flag_tva)
            $this->Cell(143,6,'report',0,0,'R');
        else 
            $this->Cell(78,6,'report',0,0,'R');
        $this->Cell(15,6,nbm($this->rap_htva),0,0,'R'); /* HTVA */
        if ( $this->jrn_type != 'VEN')
        {
            $this->Cell(15,6,nbm($this->rap_priv),0,0,'R');  /* prive */
            $this->Cell(15,6,nbm($this->rap_nd),0,0,'R');  /* Tva ND */
        }
        $this->Cell(15,6,nbm($this->rap_tva_np),0,0,'R');  /* Tva ND */
        foreach($this->rap_tva as $line_tva)
            $this->Cell(15,6,nbm($line_tva),0,0,'R');
        if ($this->flag_other_tax) {
            $this->Cell(15, 6, nbm($this->rap_other_tax), 0, 0, 'R'); /* Other tax */
        }
        $this->Cell(15,6,nbm($this->rap_tvac),0,0,'R'); /* Tvac */
 
        $this->Ln(6);
        //total page
        $this->tp_htva=0.0;
        $this->tp_tvac=0.0;
        $this->tp_priv=0;
        $this->tp_nd=0;
        $this->tp_tva_np=0;
        $this->tp_other_tax=0;
        foreach($this->a_Tva as $line_tva)
        {
            //initialize Amount TVA
            $tmp1=$line_tva['tva_id'];
            $this->tp_tva[$tmp1]=0.0;
        }
    }

References nbm().

Here is the call graph for this function:

setDossierInfo()

Print_Ledger_Simple::setDossierInfo

(

$dossier = "n/a"

)

Reimplemented from PDF.

Definition at line 95 of file print_ledger_simple.class.php.

    {
        $this->dossier = dossier::name()." ".$dossier;
    }

References PDF\$dossier, and name.

---

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

• include/class/print_ledger_simple.class.php