1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41
| $query = "select * from Check_item_".$_SESSION['jalon'];
$resultat=mysql_query($query);
//$pdf=new PDF('P','mm','A4');
//$pdf->AliasNbPages();
//$pdf->AddPage();
//Titres des colonnes
$PDF->SetFont("Arial","B",8);
$PDF->SetFillColor(96,96,96);
$PDF->SetTextColor(255,255,255);
//$header=array('Item','supplier','Status','Available','Date');
$PDF->SetXY(10,$y);
//for($i=0; $i<sizeof($header); $i++)
//$PDF->cell(50,10,$header[$i],1,0,'C',1);
$PDF->cell(50,10,'Item',1,0,'C',1);
$PDF->cell(40,10,'Supplier',1,0,'C',1);
$PDF->cell(20,10,'Statut',1,0,'C',1);
$PDF->cell(14,10,'Available',1,0,'C',1);
$PDF->cell(15,10,'Date',1,0,'C',1);
$PDF->cell(50,10,'Link',1,0,'C',1);
// Affichage des données
$PDF->SetFillColor(0xdd,0xdd,0xdd);
$PDF->SetTextColor(0,0,0);
$PDF->SetFont('Arial','',8);
$PDF->SetXY(10,$PDF->GetY()+10);
$fond=0;
while($row=mysql_fetch_array($resultat))
{
$query = "select item_name from Item_list where id_item = '".$row['id_item']."'";
$resu=mysql_query($query);
while($row1=mysql_fetch_array($resu))
{
//$x = strlen($row1['item_name']);
//$PDF->cell(50,7,$row1['item_name'],1,0,'L',$fond);
$PDF->MultiCell(50,6,trim($row1['item_name']),1,'J',0);
$PDF->cell(40,7,$row['supplier'],1,0,'C',$fond);
$PDF->cell(20,7,$row['status'],1,0,'C',$fond);
$PDF->cell(14,7,$row['availability'],1,0,'C',$fond);
$PDF->cell(15,7,$row['date'],1,0,'C',$fond);
$PDF->cell(50,7,$row['link'],1,0,'C',$fond);
$PDF->SetXY(10,$PDF->GetY()+7);
$fond=!$fond; |
Partager