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