Print_Ledger_Detail Class Reference

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

Inheritance diagram for Print_Ledger_Detail:

Collaboration diagram for Print_Ledger_Detail:

Public Member Functions
	__construct (Database $p_cn, Acc_Ledger $ledger, $p_from, $p_to)
	export ()
	Footer ()
	Header ()
	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 35 of file print_ledger_detail.class.php.

Constructor & Destructor Documentation

__construct()

Print_Ledger_Detail::__construct	(	Database	$p_cn,
		Acc_Ledger	$ledger,
			$p_from,
			$p_to
	)

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

    {
 
        parent::__construct($p_cn,'L', 'mm', 'A4',$ledger,$p_from,$p_to,'all');
        
    }

References Print_Ledger\$ledger.

Member Function Documentation

export()

Print_Ledger_Detail::export

(

)

Definition at line 72 of file print_ledger_detail.class.php.

    {
        
        // detailled printing
        $rap_deb=0;
        $rap_cred=0;
        // take all operations from jrn
        $array=$this->get_ledger()->get_operation($this->get_from(),$this->get_to());
 
        $this->SetFont('DejaVu','BI',7);
        $this->write_cell(215,7,'report Débit',0,0,'R');
        $this->write_cell(30,7,nbm($rap_deb),0,0,'R');
        $this->line_new(4);
        $this->write_cell(215,7,'report Crédit',0,0,'R');
        $this->write_cell(30,7,nbm($rap_cred),0,0,'R');
        $this->line_new(4);
 
        // print all operation
        for ($i=0;$i< count($array);$i++)
        {
            $this->SetFont('DejaVuCond','B',7);
            $row=$array[$i];
 
            $this->LongLine(20,7,$row['pj']);
            $this->write_cell(15,7,$row['date_fmt']);
            $this->write_cell(20,7,$row['internal']);
            $this->LongLine(170,7,$row['comment']);
            $this->write_cell(20,7,nbm($row['montant']),0,0,'R');
 
            $this->line_new();
            // get the entries
            $aEntry=$this->cn->get_array("select j_id,j_poste,j_qcode,j_montant,j_debit, j_text,".
                                                                                 " case when j_text='' or j_text is null then pcm_lib else j_text end as desc,".
                                         " pcm_lib ".
                                         " from jrnx join tmp_pcmn on (j_poste=pcm_val) where j_grpt = $1".
                                         " order by j_debit desc,j_id",
                                         array($row['jr_grpt_id']));
            for ($j=0;$j<count($aEntry);$j++)
            {
                $this->SetFont('DejaVuCond','',7);
                $entry=$aEntry[$j];
                // $this->write_cell(15,6,$entry['j_id'],0,0,'R');
                $this->write_cell(32,6,$entry['j_qcode'],0,0,'R');
                $this->write_cell(23,6,$entry['j_poste'],0,0,'R');
 
                // if j_qcode is not empty retrieve name
                if ( $entry['j_text'] =='' && $entry['j_qcode'] != '')
                {
                    $f_id=$this->cn->get_value('select f_id from vw_poste_qcode where j_qcode=$1',array($entry['j_qcode']));
                    if ($f_id != '')
                        $name=$this->cn->get_value('select ad_value from fiche_detail where f_id=$1 and ad_id=1',
                                                   array($f_id));
                    else
                        $name=$entry['pcm_lib'];
                }
                else
                    $name=$entry['desc'];
                $this->write_cell(150,6,$name,0,0,'L');
 
                // print amount
                $str_amount=nbm($entry['j_montant']);
                if ( $entry['j_debit']=='t')
                {
                    $this->write_cell(20,6,$str_amount,0,0,'R');
                    $this->write_cell(20,6,'',0,0,'R');
                }
                else
                {
                    $this->write_cell(20,6,'',0,0,'R');
                    $this->write_cell(20,6,$str_amount,0,0,'R');
                }
                $this->line_new(4);
            }
        }
    }

References $array, $f_id, $i, $name, $row, cn, Print_Ledger\get_from(), Print_Ledger\get_ledger(), Print_Ledger\get_to(), PDF_Core\line_new(), PDF_Core\LongLine(), nbm(), and PDF_Core\write_cell().

Here is the call graph for this function:

Footer()

Print_Ledger_Detail::Footer

(

)

Reimplemented from PDF.

Definition at line 58 of file print_ledger_detail.class.php.

    {
        //Position at 2 cm from bottom
        $this->SetY(-20);
        //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');
 
    }

Header()

Print_Ledger_Detail::Header

(

)

Reimplemented from PDF.

Definition at line 49 of file print_ledger_detail.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);
    }

setDossierInfo()

Print_Ledger_Detail::setDossierInfo

(

$dossier = "n/a"

)

Reimplemented from PDF.

Definition at line 44 of file print_ledger_detail.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_detail.class.php