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)

	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')

	fill_row ($enable)
	set color for row ,

	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)
	add a cell with automatic return to the line if the text is too long, deprecated , it calls only PDFCore::write_cell_

	write_cell ($width, $height=0, $txt='', $border=0, $interline=0, $align='', $fill=false, $link='')
	add a cell the text is not cut and don't return to this line if too large

	write_multi ($width, $interline, $txt, $border=0, $align='', $fill=false)
	add a cell with automatic return to the line if the text is too long

Protected Attributes
	$show_col
	$show_col (bool) show columns

Protected Attributes inherited from Print_Ledger
	$a_Tva
	$other_tax_previous (array)

	$filter_operation
	See Acc_Ledger_History::filter_operation.

	$flag_other_tax
	$flag_other_tax(bool) true if other tax exists

	$from

	$jrn_type

	$ledger
	concerned Ledger

	$other_tax_previous

	$previous
	internal variables for computing sum on PDF Listing

	$rap_htva
	$previous (array) see Acc_Ledger->previous_amount

	$rap_nd
	$rap_nd (float) $no-deductible tax

	$rap_other
	VAT when page starts.

	$rap_other_tax
	$rap_other_tav, amount to report for other tax than VAT

	$rap_priv
	$rap_priv (float) personal expense

	$rap_tva
	$rap_tva array(tva_id,amount)

	$rap_tva_np
	$rap_tva_np VAT not deductible

	$rap_tvac
	$rap_tvac (float) previous amount

	$show_col

	$to

	$tp_htva
	$tp_htva (float) total page price w/o VAT

	$tp_nd
	$tp_nd (float) total page price w/o VAT

	$tp_priv
	$tp_priv (float) total page personal expense

	$tp_tva
	$tp_tva (float) total page VAT

	$tp_tva_np
	$tp_tva_np (float) total page not deductible

	$tp_tvac
	$tp_tvac (float) total page full price All Tax Incl.

Protected Attributes inherited from PDF_Core
	$bigger

	$cells =array()

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)

Static Public Member Functions inherited from PDF
static	test_me ()
	test the class

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
	add_cell (Cellule $Ce)

	check_page_add ()
	Check if a page must be added due a MultiCell.

	count_nb_row ($p_text, $p_colSize)
	Count the number of rows a p_text will take for a multicell.

	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

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 32 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 88 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->fill_row(0);
        $high=8;
        $high_lg=8;
        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->write_multi(20, $high_lg, $row['jr_date'],1,  'L', true);
                $this->write_cell(20, $high,$row['jr_pj_number'].".". $row['jr_internal'], 1, 0, 'L', true);
                $this->write_multi(50, $high_lg, $row['quick_code']." ".$row['tiers_name'],1,'L',true);
                $this->write_multi(80, $high_lg, $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->write_multi(30,$high_lg,_('QuickCode'));
                    $this->write_cell(30,$high,_('Poste'));
                    $this->write_multi(70,$high_lg,_('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->write_multi(30,$high_lg,$row['j_qcode']);
            $this->write_cell(30,$high,$row['j_poste']);
            $comment=($row['j_text']=="")?$row['item_name']:$row['j_text'];
            $this->write_multi(70,$high_lg,$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, Print_Ledger\$jrn_type, Print_Ledger\$ledger, $max, $msg, $nb, $ret_reconcile, $row, _, cn, DatabaseCore\fetch_array(), PDF_Core\fill_row(), Print_Ledger\get_from(), Print_Ledger\get_ledger(), Print_Ledger\get_to(), jrn_def_id, PDF_Core\line_new(), nbm(), noalyss_bcadd(), noalyss_bcsub(), DatabaseCore\num_row(), PDF_Core\write_cell(), and PDF_Core\write_multi().

Here is the call graph for this function:

◆ Footer()

Print_Ledger_Detail_Item::Footer ( )

write the Footer

Reimplemented from PDF.

Definition at line 72 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 46 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 39 of file print_ledger_detail_item.class.php.

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

References PDF\$dossier.

Field Documentation

◆ $show_col

Print_Ledger_Detail_Item::$show_col

protected

$show_col (bool) show columns

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

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

include/class/print_ledger_detail_item.class.php

Public Member Functions

Protected Attributes

Additional Inherited Members

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ export()

◆ Footer()

◆ Header()

◆ setDossierInfo()

Field Documentation

◆ $show_col