Print_Ledger_Detail_Item Class Reference

Print detail of operation PURCHASE or SOLD plus the items There is no report of the different amounts. More...

Inheritance diagram for Print_Ledger_Detail_Item:

Collaboration diagram for Print_Ledger_Detail_Item:

Public Member Functions
	__construct (Database $p_cn, Acc_Ledger $p_jrn, $p_from, $p_to, $p_filter_operation)
	export ()
	export the ledger in PDF
	Footer ()
	write the Footer
	Header ()
	write the header of each page
	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;
	get_filter_operation ()
	get_from ()
	get_ledger ()
	get_to ()
	set_filter_operation ($filter_operation)
	Filter the operations ,.
	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')
	get_tiers ($p_jr_id, $p_jrn_type)
	retrieve the client name and quick_code
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.
	line_new ($p_step=null)
	Print all the cell stored and call Ln (new line)
	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
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)
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.
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
Protected Attributes inherited from Print_Ledger
	$filter_operation

Detailed Description

Print detail of operation PURCHASE or SOLD plus the items There is no report of the different amounts.

Author

danydb

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

Constructor & Destructor Documentation

__construct()

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

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

    {
 
        parent::__construct($p_cn,'L', 'mm', 'A4',$p_jrn,$p_from,$p_to,$p_filter_operation);
        $this->show_col=true;
    }

References $p_jrn.

Member Function Documentation

export()

Print_Ledger_Detail_Item::export

(

)

export the ledger in PDF

Definition at line 85 of file print_ledger_detail_item.class.php.

    {
      bcscale(2);
      $jrn_type=$this->get_ledger()->get_type();
 
      switch ($jrn_type)
      {
          case 'VEN':
              $ledger=new Acc_Ledger_Sale($this->cn, $this->get_ledger()->jrn_def_id);
              $ret_detail=$ledger->get_detail_sale($this->get_from(),$this->get_to(), $this->filter_operation);
              break;
          case 'ACH':
                $ledger=new Acc_Ledger_Purchase($this->cn, $this->get_ledger()->jrn_def_id);
                $ret_detail=$ledger->get_detail_purchase($this->get_from(),$this->get_to(),$this->filter_operation);
              break;
          default:
              die (__FILE__.":".__LINE__.'Journal invalide');
              break;
      }
        if ( $ret_detail == null ) return;
        
        $prepared_query=new Prepared_Query($this->cn);
        $prepared_query->prepare_reconcile_date();
 
        $nb=Database::num_row($ret_detail);
        $this->SetFont('DejaVu', '', 6);
        $internal="";
        $this->SetFillColor(220,221,255);
        $high=4;
        for ( $i=0;$i< $nb ;$i++)
        {
            
            $row=Database::fetch_array($ret_detail, $i);
            if ($internal != $row['jr_internal'])
            {
 
                // Print the general info line width=270mm
                $this->LongLine(20, $high, $row['jr_date'],1,  'L', true);
                $this->write_cell(20, $high,$row['jr_pj_number'].".". $row['jr_internal'], 1, 0, 'L', true);
                $this->LongLine(50, $high, $row['quick_code']." ".$row['tiers_name'],1,'L',true);
                $this->LongLine(80, $high, $row['jr_comment'],1,'L',true);
                $this->write_cell(20, $high, nbm($row['htva']), 1, 0, 'R', true);
                $this->write_cell(20, $high, nbm($row['tot_tva_np']), 1, 0, 'R', true);
                $this->write_cell(20, $high, nbm($row['other_tax_amount']), 1, 0, 'R', true);
                $this->write_cell(20, $high, nbm($row['tot_vat']), 1, 0, 'R', true);
                $sum=noalyss_bcadd($row['htva'],$row['tot_vat']);
                $sum=noalyss_bcadd($row['other_tax_amount'],$sum);
                $sum=noalyss_bcsub($sum,$row['tot_tva_np']);
                $this->write_cell(20, $high, nbm($sum), 1, 0, 'R', true);
                $internal=$row['jr_internal'];
                $this->line_new(6);
                // Payment info
                // Prepare the query for reconcile date
                $ret_reconcile=$this->cn->execute('reconcile_date', array($row['jr_id']));
                $max=Database::num_row($ret_reconcile);
                for ($e=0; $e<$max; $e++)
                {
                    $ret_row=Database::fetch_array($ret_reconcile, $e);
                    $msg=( $ret_row['qcode_bank']!="")?"[".$ret_row['qcode_bank']."]":$ret_row['jr_internal'];
                    $this->write_cell(200, $high,
                            sprintf(_("Paiement montant %s date %s methoded %s "), $ret_row['jr_montant'],
                                    $ret_row['jr_date'], $msg
                    ));
                    $this->line_new(6);
                }
                // on the first line, the code for each column is displaid
                if ( $this->show_col == true ) {
 
                    
                    // Header detail
                    $this->LongLine(30,$high,_('QuickCode'));
                    $this->write_cell(30,$high,_('Poste'));
                    $this->LongLine(70,$high,_('Libellé'));
                    $this->write_cell(20,$high,_('Prix/Unit'),0,0,'R');
                    $this->write_cell(20,$high,_('Quant.'),0,0,'R');
                    $this->write_cell(20,$high,_('HTVA'),0,0,'R');
                    $this->write_cell(20,$high,_('TVA NP'),0,0,'R');
                    $this->write_cell(20,$high,_('Code TVA'));
                    $this->write_cell(20,$high,_('TVA'),0,0,'R');
                    $this->write_cell(20,$high,_('TVAC'),0,0,'R');
                    $this->line_new(6);
                    $this->show_col=false;
                 } 
            }
            // Print detail sale / purchase
            $this->LongLine(30,$high,$row['j_qcode']);
            $this->write_cell(30,$high,$row['j_poste']);
            $comment=($row['j_text']=="")?$row['item_name']:$row['j_text'];
            $this->LongLine(70,$high,$comment);
            $this->write_cell(20,$high,nbm($row['price_per_unit']),0,0,'R');
            $this->write_cell(20,$high,nbm($row['quantity']),0,0,'R');
            $this->write_cell(20,$high,nbm($row['price']),0,0,'R');
            $this->write_cell(20,$high,nbm($row['vat_sided']),0,0,'R');
            $this->write_cell(20,$high,$row['tva_label']);
            $this->write_cell(20,$high,nbm($row['vat']),0,0,'R');
            $sum=bcadd($row['price'],$row['vat']);
            $this->write_cell(20,$high,nbm($sum),0,0,'R');
            $this->line_new(6);
            
        }
    }

References $e, $i, $jrn_type, Print_Ledger\$ledger, $max, $msg, $nb, $ret_reconcile, $row, _, cn, DatabaseCore\fetch_array(), Print_Ledger\get_from(), Print_Ledger\get_ledger(), Print_Ledger\get_to(), jrn_def_id, PDF_Core\line_new(), PDF_Core\LongLine(), nbm(), noalyss_bcadd(), noalyss_bcsub(), DatabaseCore\num_row(), and PDF_Core\write_cell().

Here is the call graph for this function:

Footer()

Print_Ledger_Detail_Item::Footer

(

)

write the Footer

Reimplemented from PDF.

Definition at line 69 of file print_ledger_detail_item.class.php.

    {
        $this->Ln(2);
        $this->SetFont('Arial', 'I', 8);
        $this->Cell(50,8,' Journal '.$this->get_ledger()->get_name(),0,0,'C');
        //Arial italic 8
        //Page number
        $this->Cell(30,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 Print_Ledger\get_ledger().

Here is the call graph for this function:

Header()

Print_Ledger_Detail_Item::Header

(

)

write the header of each page

Reimplemented from PDF.

Definition at line 43 of file print_ledger_detail_item.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);
        $high=6;
        $this->SetFont('DejaVu', '', 6);
        $this->write_cell(20, $high, _('Date'),0,0,  'L', false);
        $this->write_cell(20, $high, _('Numéro interne'), 0,0,  'L', false);
        $this->write_cell(50, $high, _('Code'),0,0,'L',false);
        $this->write_cell(80, $high, _('Libellé'),0,0,'L',false);
        $this->write_cell(20, $high, _('Tot HTVA'), 0, 0,'R', false,'R', false);
        $this->write_cell(20, $high, _('Tot TVA NP'), 0, 0,'R', false, false);
        $this->write_cell(20, $high, _("Autre Tx"), 0, 0, 'R', false);
        $this->write_cell(20, $high, _('Tot TVA'), 0, 0, 'R', false);
        $this->write_cell(20, $high, _('TVAC'), 0, 0, 'R', false);
        $this->line_new(6);
        $this->show_col=true;
        
    }

References _, PDF_Core\line_new(), and PDF_Core\write_cell().

Here is the call graph for this function:

setDossierInfo()

Print_Ledger_Detail_Item::setDossierInfo

(

$dossier = "n/a"

)

Reimplemented from PDF.

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

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

References PDF\$dossier.

---

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

• include/class/print_ledger_detail_item.class.php