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'];
