array('lun' => 24,'nam'=>'') ) ); require('../../config/templates/report_template.php'); $pdf = new Report_template(); $pdf->setVars($admin_aziend,$title,1); $pdf->setFooterMargin(22); $pdf->setTopMargin(43); $pdf->setRiporti(''); $pdf->AddPage(); $ctrltipo=""; $totaleff=0.00; $totnumeff=0; $pdf->SetFont('helvetica','',8); while ($a_row = gaz_dbi_fetch_array($result)) { if ($a_row["tipeff"] <> $ctrltipo){ if (isset($totaletipo)) $pdf->Cell(190,4,$totnumtipo.' '.$descreff.' per un totale di '.gaz_format_number($totaletipo),1,1,'R',1); $totaletipo = 0.00; $totnumtipo = 0; switch($a_row['tipeff']) { case "B": $descreff = 'RICEVUTE BANCARIE '; break; case "T": $descreff = 'CAMBIALI TRATTE '; break; case "V":
) ); $pdf = new Report_template(); $pdf->setVars($admin_aziend,$title); $pdf->setFooterMargin(22); $pdf->setTopMargin(43); $pdf->setRiporti(''); $pdf->AddPage(); $paymov = new Schedule; $paymov->setScheduledPartner($admin_aziend['mascli']); if (sizeof($paymov->Partners) > 0) { $anagrafica = new Anagrafica(); foreach ($paymov->Partners as $p){ $anagrafica = new Anagrafica(); $prt = $anagrafica->getPartner($p); $pdf->SetFont('helvetica','B',10); $pdf->SetFillColor(200,255,200); $pdf->Ln(2); $pdf->Cell(186,5,$prt['ragso1']." ".$prt['ragso2']." tel:".$prt['telefo']." fax:".$prt['fax']." mob:".$prt['cell']." ",1,1,'',1,'',1); $pdf->SetFont('helvetica','',9); $paymov->getPartnerStatus($p,substr($_GET['date'],0,10)); foreach ($paymov->PartnerStatus as $k=>$v){ $pdf->SetTextColor(255,0,0); $pdf->SetFillColor(230,255,230); $pdf->Cell(56,5,"REF: ".$k,1,0,'',1,'',1); $pdf->SetTextColor(0); $pdf->Cell(130,5, $paymov->docData[$k]['descri'].' n.'. $paymov->docData[$k]['numdoc'].'/'. $paymov->docData[$k]['seziva'].' '. $paymov->docData[$k]['datdoc']
), 'bot'=>array(array('lun' => 166,'nam'=>'a riportare : '), array('lun' => 20,'nam'=>'') ) ); $pdf = new Report_template(); $pdf->setVars($admin_aziend,$title); $pdf->setFooterMargin(22); $pdf->setTopMargin(43); $pdf->SetFillColor(160, 255,220 ); $pdf->setRiporti(''); $pdf->AddPage(); $config = new Config; $paymov = new Schedule; $ctrl_pm=0; $pdf->SetFont('helvetica','',10); $pdf->Cell(100,6,$d['d'][1]['descri'],1,1,'L',1,'',1); while (list($k, $mv) = each($d['d'])) { if ($ctrl_pm <> $mv["id_tesdoc_ref"]){ } $pdf->Cell(30,6,$mv['id_tesdoc_ref'],'LTB',0,'L',0,'',1); $pdf->Cell(70,6,$mv['t']['descri'],1,0,'L',0,'',1); $pdf->Cell(25,6,$mv['t']["numdoc"].'/'.$mv['t']['seziva'],1,0,'C',0); $pdf->Cell(25,6,gaz_format_date($mv['t']["datdoc"]),1,0,'C',0); $pdf->Cell(36,6,gaz_format_number($mv['amount']),1,1,'R',0); $ctrl_pm=$mv["id_tesdoc_ref"]; } $pdf->Ln(10); $pdf->SetFont('helvetica','B',10); $pdf->Cell(150,6,$script_transl['tot'].': ','LTB',0,'R');
array('lun' => 20,'nam'=>'Saldo') ) ); $pdf = new Report_template(); $pdf->setVars($admin_aziend,$title); $pdf->SetTopMargin(39); $pdf->SetFooterMargin(20); $config = new Config; $pdf->AddPage('P',$config->getValue('page_format')); $totmovpre =0.00; $totmovsuc =0.00; $ctrlmopre = 0; $saldo = 0.00; $pdf->SetFont('helvetica','',8); while ($movimenti = gaz_dbi_fetch_array($result)){ $giomov = substr($movimenti['datreg'],8,2); $mesmov = substr($movimenti['datreg'],5,2); $annmov = substr($movimenti['datreg'],0,4); $giodoc = substr($movimenti['datdoc'],8,2); $mesdoc = substr($movimenti['datdoc'],5,2); $anndoc = substr($movimenti['datdoc'],0,4); $utsmov= mktime(0,0,0,$mesmov,$giomov,$annmov); $utsdoc= mktime(0,0,0,$mesdoc,$giodoc,$anndoc); $datamov = date("d-m-Y",$utsmov); if ($anndoc > 0){ $datadoc = date("d-m-Y",$utsdoc); } else { $datadoc = '';
//recupero tutti i movimenti contabili dei clienti tranne quelli di chiusura e apertura di fine/inizio anno del periodo selezionato... $result=gaz_dbi_dyn_query($gTables['tesmov'].".*,".$gTables['rigmoc'].".*,ragso1,telefo,cell", $gTables['rigmoc'].' LEFT JOIN '.$gTables['tesmov'].' ON '.$gTables['rigmoc'].'.id_tes='.$gTables['tesmov'].'.id_tes LEFT JOIN '.$gTables['clfoco'].' ON '.$gTables['rigmoc'].'.codcon='.$gTables['clfoco'].'.codice LEFT JOIN '.$gTables['anagra'].' ON '.$gTables['anagra'].'.id='.$gTables['clfoco'].'.id_anagra', "datreg BETWEEN '".intval($_GET["annini"])."0101' AND '". intval($_GET["annfin"])."1231' AND codcon=".$value. " AND caucon <> 'CHI' AND caucon <> 'APE' OR (caucon = 'APE' AND codcon=".$value." AND YEAR(datreg)=".intval($_GET["annini"]).")", "datreg"); while ($movimenti = gaz_dbi_fetch_array($result)) { if($ctrlcli != $movimenti["codcon"]){ $pdf->SetFont('times','B',11); $pdf->Cell(187,6,$movimenti['ragso1'].' Tel. '.$movimenti['telefo'].' cell. '.$movimenti['cell'],1,1,'L',1); $pdf->SetFont('helvetica','',9); $saldo = 0.00; } $giomov = substr($movimenti['datreg'],8,2); $mesmov = substr($movimenti['datreg'],5,2); $annmov = substr($movimenti['datreg'],0,4); $giodoc = substr($movimenti['datdoc'],8,2); $mesdoc = substr($movimenti['datdoc'],5,2); $anndoc = substr($movimenti['datdoc'],0,4); $utsmov= mktime(0,0,0,$mesmov,$giomov,$annmov); $utsdoc= mktime(0,0,0,$mesdoc,$giodoc,$anndoc); $datamov = date("d-m-Y",$utsmov); if ($anndoc > 0){ $datadoc = date("d-m-Y",$utsdoc);
) ); $title = array('luogo_data'=>$luogo_data, 'title'=>"PIANO DEI CONTI", 'hile'=>array( array('lun' => 15,'nam'=>'Codice'), array('lun' => 55,'nam'=>'Denominazione'), array('lun' => 65,'nam'=>'Voci del bilancio d\'esercizio'), array('lun' => 51,'nam'=>'Note') ) ); $pdf = new Report_template(); $pdf->setVars($admin_aziend,$title); $pdf->SetTopMargin(39); $pdf->SetFooterMargin(22); $config = new Config; $pdf->SetFont('helvetica','',7); $pdf->AddPage('P',$config->getValue('page_format')); $pdf->SetFillColor(hexdec(substr($admin_aziend['colore'],0,2)),hexdec(substr($admin_aziend['colore'],2,2)),hexdec(substr($admin_aziend['colore'],4,2))); $ctrl_mas = 0; $max_y = 0; while ($row = gaz_dbi_fetch_array($result)) { $mas=intval(substr($row['codice'],0,3)); $y=$pdf->GetY(); if ($y<250){ $max_str=intval(13*(254-$y)); if ($ctrl_mas<$mas ){ // mastri if (intval(substr($row['codice'],3,6))==0) { $cm_d=trim($row['ceedar']); $cm_a=trim($row['ceeave']); } if (isset($note[1])){ // ma se ho una nota del mastro precedente la devo stampare
) ); $gForm = new magazzForm(); $pdf = new Report_template(); $pdf->setVars($admin_aziend,$title,'L'); $pdf->setAuthor($admin_aziend['ragso1'].' '.$_SESSION['Login']); $pdf->setTitle($title['title']); $pdf->SetTopMargin(39); $pdf->setFooterMargin(10); $pdf->AddPage('L'); $pdf->SetFillColor(hexdec(substr($admin_aziend['colore'],0,2)),hexdec(substr($admin_aziend['colore'],2,2)),hexdec(substr($admin_aziend['colore'],4,2))); $ctrlcatmer=0; while ($row = gaz_dbi_fetch_array($result)) { $mv=$gForm->getStockValue(false,$row['codice']); $magval=array_pop($mv); $pdf->SetFont('helvetica','',10); switch($_GET['li']) { case '0': $price = $row['preacq']; break; case '1': $price = $row['preve1']; break; case '2': $price = $row['preve2']; break; case '3': $price = $row['preve3']; break; case 'web': $price = $row['web_price']*$row['web_multiplier'];