array('lun' => 28,'nam'=>$acc[1]), array('lun' => 28,'nam'=>$acc[2]), array('lun' => 28,'nam'=>$acc[3]), array('lun' => 28,'nam'=>$acc[4]), array('lun' => 28,'nam'=>$acc[5]), array('lun' => 18,'nam'=>$acc[6]) ) ); $aRiportare = array('top'=>array(array('lun' => 166,'nam'=>'da riporto : '), array('lun' => 20,'nam'=>'') ), '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->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);
array('lun' => 18,'nam'=>'Scorta') ) ); $title = array('title'=>"BILANCIO IV direttiva CEE dal ".date("d-m-Y",$utsini)." al ".date("d-m-Y",$utsfin), 'hile'=>array() ); $aRiportare = array('top'=>array(array('lun' => 168,'nam'=>'da riporto : '), array('lun' => 19,'nam'=>'') ), 'bot'=>array(array('lun' => 168,'nam'=>'a riportare : '), array('lun' => 19,'nam'=>'') ) ); $pdf = new Report_template(); $pdf->setVars($admin_aziend,$title); $pdf->AddPage(); $pdf->Cell(186,6,'STATO PATRIMONIALE AL '.date("d-m-Y",$utsfin),'LTR',1,'C'); $pdf->SetFont('helvetica','B',12); $pdf->SetTextColor(0,0,255); $pdf->Cell(186,6,'ATTIVO','LTR',1,'C'); $pdf->SetTextColor(0,0,0); $pdf->SetFont('helvetica','',8); foreach ($attivo as $keylet => $vallet) { if (! key_exists($keylet,$attdesc)) $keylet = "non class."; $pdf->SetFont('helvetica','B',8); $pdf->Cell(186,4,$keylet.$attdesc[$keylet]['Titolo'],'LR',1); $pdf->SetFont('helvetica','',8); foreach ($vallet as $keyrom => $valrom) { $pdf->Cell(15,4,'','LR');
array('lun' => 100,'nam'=>'Cliente / Indirizzo,P.IVA / Fattura'), array('lun' => 30,'nam'=>'Appoggio'), array('lun' => 24,'nam'=>'Importo') ) ); $aRiportare = array('top'=>array(array('lun' => 166,'nam'=>'da riporto : '), array('lun' => 24,'nam'=>'') ), 'bot'=>array(array('lun' => 166,'nam'=>'a riportare : '), 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;
'hile'=>array(array('lun' => 25,'nam'=>'Codice'), array('lun' => 74,'nam'=>'Descrizione'), array('lun' => 5,'nam'=>'Um'), array('lun' => 14,'nam'=>'Quant.'), array('lun' => 14,'nam'=>'Prezzo'), array('lun' => 8,'nam'=>'%Sc.'), array('lun' => 20,'nam'=>'Importo'), array('lun' => 11,'nam'=>'%Prov.'), array('lun' => 16,'nam'=>'Provv.') ) ); $item_head['top']= array(array('lun' => 50,'nam'=>'Indirizzo'), array('lun' => 60,'nam'=>'Città/Telefono'), array('lun' => 37,'nam'=>'Periodo') ); $pdf = new Report_template(); $pdf->setVars($admin_aziend,$title); $pdf->SetTopMargin(47); $pdf->SetFooterMargin(18); $config = new Config; $pdf->SetFont('helvetica','',7); $ctrlAgente = 0; $ctrlDoc = 0; $tot_prov = 0.00; while ($row = gaz_dbi_fetch_array($result)) { $pdf -> setRiporti($aRiportare); if ($ctrlAgente != $row['id_agente']) { if ($ctrlAgente > 0) { $pdf->SetFont('helvetica','B',8); $pdf->Cell($aRiportare['top'][0]['lun'],4,'Totale provvigioni: ',1,0,'R');
'title'=>$script_transl['title'].$d['partner']['ragso1'].' '.$d['partner']['ragso2'], 'hile'=>array( array('lun' => 30,'nam'=>$script_transl['id_tesdoc_ref']), array('lun' => 70,'nam'=>$script_transl['descri']), array('lun' => 25,'nam'=>$script_transl['numfat']), array('lun' => 25,'nam'=>$script_transl['datfat']), array('lun' => 36,'nam'=>$script_transl['amount']) ) ); $aRiportare = array('top'=>array(array('lun' => 166,'nam'=>'da riporto : '), array('lun' => 20,'nam'=>'') ), '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"]){ }
$conto = $anagrafica->getPartner(intval($_GET['codice'])); //recupero tutti i movimenti contabili del conto insieme alle relative testate... $result = mergeTable($gTables['rigmoc'],"*",$gTables['tesmov'],"*","id_tes","codcon = ".intval($_GET['codice'])." AND datreg BETWEEN '".intval($_GET["annini"])."0101' AND '".intval($_GET["annfin"])."1231' AND caucon <> 'CHI' AND caucon <> 'APE' OR (caucon = 'APE' AND codcon ='".intval($_GET['codice'])."%' AND datreg LIKE '".intval($_GET["annini"])."%') ORDER BY datreg ASC"); $emissione = 'Estratto conto: '.$conto['ragso1'].' '.$conto['ragso2']; $title = array('title'=>$emissione, 'hile'=>array(array('lun' => 20,'nam'=>'Data'), array('lun' => 75,'nam'=>'Descrizione'), array('lun' => 18,'nam'=>'N.Doc.'), array('lun' => 18,'nam'=>'Data.Doc.'), array('lun' => 18,'nam'=>'Dare'), array('lun' => 18,'nam'=>'Avere'), 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);
'title'=>"PARTITARIO dal ".$descrDataini." al ".$descrDatafin, 'hile'=>array( array('lun' => 18,'nam'=>'Data Reg.'), array('lun' =>108,'nam'=>'Descrizione (Dati del documento'), array('lun' => 20,'nam'=>'Dare'), array('lun' => 20,'nam'=>'Avere'), array('lun' => 20,'nam'=>'SALDO') ) ); $aRiportare = array('top'=>array(array('lun' => 166,'nam'=>'da riporto : '), array('lun' => 20,'nam'=>'') ), 'bot'=>array(array('lun' => 166,'nam'=>'a riportare : '), array('lun' => 20,'nam'=>'') ) ); $pdf = new Report_template(); $pdf->setVars($admin_aziend,$title); $pdf->SetTopMargin(51); $pdf->SetFooterMargin(22); $config = new Config; $ctrlConto = ''; $movSaldo = 0.00; while ($row = gaz_dbi_fetch_array($result)) { $datadoc = substr($row['datdoc'],8,2).'-'.substr($row['datdoc'],5,2).'-'.substr($row['datdoc'],0,4); $datareg = substr($row['datreg'],8,2).'-'.substr($row['datreg'],5,2).'-'.substr($row['datreg'],0,4); $pdf->setRiporti($aRiportare); if ($ctrlConto != $row['codcon']) { $movSaldo = 0.00; if (!empty($ctrlConto)) { $pdf->SetFont('helvetica','B',7); $pdf->Cell($aRiportare['top'][0]['lun'],4,'SALDO al '.$descrDatafin.' : ',1,0,'R');
array('lun' => 17,'nam'=>$script_transl['header'][6]), array('lun' => 17,'nam'=>$script_transl['header'][7]), array('lun' => 20,'nam'=>$script_transl['header'][8]), array('lun' => 20,'nam'=>$script_transl['header'][9]) ) ); $aRiportare = array('top'=>array(array('lun' => 222,'nam'=>$script_transl['top']), array('lun' => 20,'nam'=>''), array('lun' => 20,'nam'=>'') ), 'bot'=>array(array('lun' => 222,'nam'=>$script_transl['bot']), array('lun' => 20,'nam'=>''), array('lun' => 20,'nam'=>'') ) ); $pdf = new Report_template(); $pdf->setVars($admin_aziend,$title); $pdf->SetTopMargin(51); $config = new Config; $gForm = new magazzForm(); $pdf->SetFont('helvetica','',7); $ctrlArtico = ""; $ctrl_id=0; $mval['q_g']=0; $mval['q_g']=0; $mval['v_g']=0; $mval['v_g']=0; while ($mv = gaz_dbi_fetch_array($result)) { $pdf->setRiporti($aRiportare); if ($ctrlArtico != $mv['artico']) { gaz_set_time_limit (30);
//fine creazione array conti diversi da zero $emissione = 'Crediti verso i Clienti periodo '.intval($_GET['annini']).'-'.intval($_GET['annfin']); $title = array('title'=>$emissione, 'hile'=>array(array('lun' => 20,'nam'=>'Data'), array('lun' => 75,'nam'=>'Descrizione'), array('lun' => 18,'nam'=>'N.Doc.'), array('lun' => 18,'nam'=>'Data.Doc.'), array('lun' => 18,'nam'=>'Dare'), array('lun' => 18,'nam'=>'Avere'), 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')); $pdf->SetFillColor(hexdec(substr($admin_aziend['colore'],0,2)),hexdec(substr($admin_aziend['colore'],2,2)),hexdec(substr($admin_aziend['colore'],4,2))); $ctrlcli=0; $nummov = 0; $totmovpre =0.00; $totmovsuc =0.00; $ctrlmopre = 0; foreach ($conti as $value) { //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",
require("../../config/templates/report_template.php"); $title = array('luogo_data'=>$luogo_data, 'title'=>"GIORNALE DI MAGAZZINO dal ".strftime("%d %B %Y",$utsri)." al ".strftime("%d %B %Y",$utsrf), 'hile'=>array(array('lun' => 20,'nam'=>'Data Reg.'), array('lun' => 40,'nam'=>'Causale'), array('lun' => 70,'nam'=>'Articolo'), array('lun' => 70,'nam'=>'Rif.Documento'), array('lun' => 17,'nam'=>'Prezzo'), array('lun' => 18,'nam'=>'Importo'), array('lun' => 10,'nam'=>'U.M.'), array('lun' => 20,'nam'=>'Mov.Quant.') ) ); $pdf = new Report_template(); $pdf->setVars($admin_aziend,$title); $pdf->SetTopMargin(39); $pdf->SetFooterMargin(20); $config = new Config; $pdf->AddPage('L',$config->getValue('page_format')); $pdf->SetFont('helvetica','',7); if (sizeof($result) > 0) { while (list($key, $row) = each($result)) { $datadoc = substr($row['datdoc'],8,2).'-'.substr($row['datdoc'],5,2).'-'.substr($row['datdoc'],0,4); $datareg = substr($row['datreg'],8,2).'-'.substr($row['datreg'],5,2).'-'.substr($row['datreg'],0,4); $movQuanti = $row['quanti']*$row['operat']; $pdf->Cell(20,3,$datareg,1,0,'C'); $pdf->Cell(40,3,$row['caumag'].'-'.substr($row['descri'],0,22),1); $pdf->Cell(70,3,$row['artico'].' - '.$row['desart'],1); $pdf->Cell(70,3,$row['desdoc'].' del '.$datadoc,1);
array('lun' => 11,'nam'=>'N.Doc.'), array('lun' => 15,'nam'=>'Data Doc.'), array('lun' => 15,'nam'=>'Data Reg.'), array('lun' => 12,'nam'=>'Dare'), array('lun' => 12,'nam'=>'Avere'), array('lun' => 15,'nam'=>'Scadenza') ) ); $aRiportare = array('top'=>array(array('lun' => 166,'nam'=>'da riporto : '), array('lun' => 20,'nam'=>'') ), '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; $scdl = new Schedule; $m = $scdl->getScheduleEntries(intval($_GET['orderby']),$admin_aziend['mascli']); if (sizeof($scdl->Entries) > 0) { $ctrl_partner=0; $ctrl_id_tes=0; $ctrl_paymov=0; while (list($key, $mv) = each($scdl->Entries)) { $pdf->SetFont('helvetica','',6);
$what = $gTables['clfoco'].".*, CONCAT(".$gTables['anagra'].".ragso1, ' ',".$gTables['anagra'].".ragso2) AS ragsoc "; $table = $gTables['clfoco']." LEFT JOIN ".$gTables['anagra']." ON (".$gTables['clfoco'].".id_anagra = ".$gTables['anagra'].".id)"; $result = gaz_dbi_dyn_query ($what, $table,$where,"codice ASC"); $item_head = array('top'=>array(array('lun' => 80,'nam'=>'Descrizione'), array('lun' => 25,'nam'=>'Numero Conto') ) ); $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
break; } $title=array('luogo_data'=>$luogo_data, 'title'=>"Listino ".$descrlis, 'hile'=>array(array('lun' => 35,'nam'=>'Codice'), array('lun' => 85,'nam'=>'Descrizione'), array('lun' => 15,'nam'=>'U.M.'), array('lun' => 25,'nam'=>'Prezzo'), array('lun' => 25,'nam'=>'Esistenza'), array('lun' => 15,'nam'=>'% I.V.A.'), array('lun' => 70,'nam'=>'Annotazioni') ) ); $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; } // fine addiziona valori imponibile,imposta,esente,non imponibile } $ctrl_partner = $row['clfoco']; } } else { $error_partners[0] = $script_transl[21]; } // fine creazione array righi ed errori return array($castel_partners,$error_partners,$total_column); } require("../../config/templates/report_template.php"); $pdf = new Report_template(); $item_head = array('top'=>array(array('lun' => 21,'nam'=>'Codice'), array('lun' => 18,'nam'=>'Cat.Merc'), array('lun' => 60,'nam'=>'Descrizione'), array('lun' => 10,'nam'=>'U.M.'), array('lun' => 18,'nam'=>'Scorta') ) ); $title = array('title'=>$script_transl[4].' '.$script_transl[2].' - '.$script_transl[5].' '.$_GET['anno'], 'hile'=>array(array('lun' => 8,'nam'=>'N.'), array('lun' => 80,'nam'=>'Rag.Soc,Cognome,Nome/Pers,CF,Partita IVA,N.Fat'), array('lun' => 54,'nam'=>'Indirizzo/Imponib.,Imposta,Esente'), array('lun' => 39,'nam'=>'Comune/Non Impon,Totale'), array('lun' => 6,'nam'=>'Pr.') )
LEFT JOIN ".$gTables['anagra']." ON ".$gTables['anagra'].".id = ".$gTables['clfoco'].".id_anagra ";*/ $result = gaz_dbi_dyn_query($gTables['assist'].".*, ".$gTables['anagra'].".ragso1, ".$gTables['anagra'].".telefo, ".$gTables['anagra'].".cell, ".$gTables['anagra'].".fax, ".$gTables['clfoco'].".codice ", $gTables['assist']. " LEFT JOIN ".$gTables['clfoco']." ON ".$gTables['assist'].".clfoco = ".$gTables['clfoco'].".codice". " LEFT JOIN ".$gTables['anagra'].' ON '.$gTables['clfoco'].'.id_anagra = '.$gTables['anagra'].'.id', $where, "id", $limit, $passo); //$result = gaz_dbi_dyn_query ($what, $table,$where,"clfoco"); //echo " what: ".$what. " table: ".$table. " where: ".$where." <br>"; /*while ($a_row = gaz_dbi_fetch_array($result)) { echo $a_row["descri"]."<br>"; }*/ $pdf = new Report_template(); $pdf->setVars($admin_aziend,$title); $pdf->SetTopMargin(32); $pdf->SetFooterMargin(20); $config = new Config; $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))); $row = gaz_dbi_fetch_array($result); $html = "<span style=\"font-family: arial,helvetica,sans-serif; font-size:28px;\">"; $html .= "Cliente : <b>". $row["codice"] ." - ". $row["ragso1"]."</b><br>"; if ( $row["telefo"] ) $html .= "Telefono : <b>".$row["telefo"]."</b><br>"; if ( $row["telefo"] ) $html .= "Cellulare : <b>".$row["cell"]."</b><br>"; if ( $row["telefo"] ) $html .= "Fax : <b>".$row["fax"]."</b><br>"; $html .= "</span>";
require("../../config/templates/report_template.php"); $luogo_data=$admin_aziend['citspe'].", lì ".ucwords(strftime("%d %B %Y", mktime (0,0,0,date("m"),date("d"),date("Y")))); $item_head = array('top'=>array(array('lun' => 80,'nam'=>'Descrizione'), array('lun' => 25,'nam'=>'Numero Conto') ) ); $acc=array(); /*foreach($script_transl['header'] as $k=>$v){ $acc[]=$k; }*/ $title = array('luogo_data'=>$luogo_data, 'title'=>'RESOCONTO INTERVENTI DI ASSISTENZA TECNICA', 'hile' => array() ); $pdf = new Report_template(); $pdf->setVars($admin_aziend,$title); $pdf->setFooterMargin(22); $pdf->setTopMargin(34); $pdf->setRiporti(''); $pdf->AddPage(); $result = gaz_dbi_dyn_query($gTables['assist'].".*, ".$gTables['anagra'].".ragso1, ".$gTables['anagra'].".ragso2, ".$gTables['anagra'].".telefo, ".$gTables['anagra'].".fax, ".$gTables['anagra'].".cell, ".$gTables['anagra'].".e_mail ", $gTables['assist']. " LEFT JOIN ".$gTables['clfoco']." ON ".$gTables['assist'].".clfoco = ".$gTables['clfoco'].".codice". " LEFT JOIN ".$gTables['anagra'].' ON '.$gTables['clfoco'].'.id_anagra = '.$gTables['anagra'].'.id', $where, "clfoco, DATA ASC", $limit, $passo);