Codice PHP:
<?php
/*session_start() ;*/
include("../lib/class_db.php") ;
include("../lib/class_giornalieri.php") ;
include("../lib/class_campi.php") ;
include("../Fpdf/fpdf.php") ;
include("../uno/config.php") ;
/*da classe campi prendo data e trasformo in dataenglish per query con data inglese*/
if($_POST['txtlogopedista_data1'] <> ""){
$d1val = new cl_gestcampi() ;
$$d2val = new cl_gestcampi() ;
$d1 = $_POST['txtlogopedista_data1'] ;
$d2 = $_POST['txtlogopedista_data2'] ;
$d1val = $d1val->dataenglish($d1) ;
$d2val = $$d2val->dataenglish($d2) ;
}
$data1 = $_REQUEST['txtlogopedista_data1'] ;
$data2 = $_REQUEST['txtlogopedista_data2'] ;
/*rich9iamo classi*/
$db = new db_con ;
$clgiornalieri = new cl_gestgiornalieri($db) ;
//$cllogopediste = new cl_gestlogopediste($db) ;
$db->connetti() ;
$db->setstatoatt("true") ;
$db->nomedb() ;
//Create new pdf file
$pdf=new FPDF();
//Disable automatic page break
$pdf->SetAutoPageBreak(false);
//Add first page
$pdf->AddPage();
//set initial y axis position per page
$y_axis_initial = 25;
//print column titles for the actual page
$pdf->SetFillColor(232,232,232);
$pdf->SetFont('Arial','B',12);
$pdf->SetY($y_axis_initial);
$pdf->SetX(25);
$pdf->Cell(30,6,'CODE',1,0,'L',1);
$pdf->Cell(100,6,'NAME',1,0,'L',1);
$pdf->Cell(30,6,'PRICE',1,0,'R',1);
$y_axis = $y_axis + $row_height;
//Select the Products you want to show in your PDF file
$result=$clgiornalieri->selgiornalieri("select IDlogopedista_giornalieri,
cognome_logopediste,
nome_logopediste,
cognome_clienti,
nome_clienti,
luogo_giornalieri,
nome_luoghi,
IDtipointervento_giornalieri,
nome_tipointerventi,
count(*) as f
from ((((tb_giornalieri inner join tb_logopediste
on IDlogopedista_giornalieri = idlogopedista_logopediste)
inner join tb_clienti
on IDcliente_giornalieri = idcliente_clienti)
inner join tb_luoghi
on luogo_giornalieri = idluogo_luoghi)
inner join tb_tipointerventi
on IDtipointervento_giornalieri = idtipo_tipointerventi)
where data_giornalieri
>= '$d1val' and
data_giornalieri
<= '$d2val'
group by IDlogopedista_giornalieri,IDcliente_giornalieri,luogo_giornalieri,IDtipointervento_giornalieri
order by cognome_logopediste asc,cognome_clienti asc
") ;
//initialize counter
$i = 0;
//Set maximum rows per page
$max = 25;
//Set Row Height
$row_height = 6;
while($row = mysql_fetch_array($result))
{
//If the current row is the last one, create new page and print column title
if ($i == $max)
{
$pdf->AddPage();
//print column titles for the current page
$pdf->SetY($y_axis_initial);
$pdf->SetX(25);
$pdf->Cell(30,6,'logo',1,0,'L',1);
$pdf->Cell(30,6,'cliente',1,0,'L',1);
$pdf->Cell(100,6,'luogo',1,0,'R',1);
//Go to next row
//$y_axis = $y_axis + $row_height;
//Set $i variable to 0 (first row)
$i = 0;
}
$code = $row['cognome_logopediste'];
$price = $row['cognome_clienti'];
$name = $row['nome_luoghi'];
$pdf->SetY($y_axis);
$pdf->SetX(25);
$pdf->Cell(30,6,$code,1,0,'L',1);
$pdf->Cell(30,6,$price,1,0,'L',1);
$pdf->Cell(100,6,$name,1,0,'R',1);
//Go to next row
$y_axis = $y_axis + $row_height;
$i = $i + 1;
}
$db->disconnetti() ;
//Create file
$pdf->Output();
?>