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 42 43
| $header=array('Achat','Marque','Etat','RAM','Disque','Marque Pro','Fréquence Pro.','Utilisateur');
$pdf->SetFont('Arial','B',12);
$pdf->AddPage();
$req = "SELECT code_reg,libe_reg FROM tb_region WHERE code_reg ='" .$_GET['region']. "'";
$result_select = mysql_query($req) or die("Erreur dexécution de la requête: " . $req);
$row = mysql_fetch_array($result_select);
$titre = "Liste des Ordinateurs de la Région :" ." ". $row[1];
$pdf->Cell(20,1,$titre, 0, 0, "C", 0);
$xsce = -10; $ysce = 3; $xresp = 40; $yresp = -3;
$sql_sce = "SELECT code_sce,libe_sce,nom_resp FROM Tb_service WHERE code_reg ='" .$_GET['region']. "'";
$result_sce = mysql_query($sql_sce) or die("Erreur dexécution de la requête: " . $sql_sce);
while ($row = mysql_fetch_array($result_sce))
{
$pdf->Cell($xsce,$ysce,"Service :". " " . $row['libe_sce'], 0, 1, "R", 0);
$pdf->Cell($xresp,$yresp,"Chef service :". " " . $row['nom_resp'], 0, 1, "C", 0);
$pdf->SetFillColor(96,96,96);
$pdf->SetTextColor(255,255,255);
$query="SELECT Dte_acha,mrque_or,etat_ord,Ram_ord,DisDur_or,mque_pro,freq_pro,actif_ord,nom_user FROM Tb_region,Tb_service,Tb_ordinateur WHERE (Tb_region.code_reg = Tb_service.code_reg) AND (Tb_service.code_sce = Tb_ordinateur.code_sce) AND (Tb_region.code_reg ='".$_GET['region']."') AND (Tb_service.code_sce ='".$row['code_sce']."')";
$resultat = mysql_query($query) or die("Erreur dexécution de la requête: " . $sql_sce);
$pdf->SetXY(1,3);
for($i=0;$i<sizeof($header);$i++){
if(($i==0) || ($i==4)){ $pdf->cell(2,1,$header[$i],1,0,'C',1);} else { $pdf->cell(4,1,$header[$i],1,0,'C',1);}}
$pdf->SetFillColor(0xdd,0xdd,0xdd);
$pdf->SetTextColor(0,0,0);
$pdf->SetFont('Arial','',10);
$pdf->SetXY(1,$pdf->GetY()+1);
$fond=0; $ligne = 0.7;
while($row=mysql_fetch_array($resultat))
{
$pdf->cell(2,0.7,$row['Dte_acha'],1,0,'C',$fond);
$pdf->cell(4,0.7,$row['mrque_or'],1,0,'C',$fond);
$pdf->cell(4,0.7,$row['etat_ord'],1,0,'C',$fond);
$pdf->cell(4,0.7,$row['Ram_ord'],1,0,'C',$fond);
$pdf->cell(2,0.7,$row['DisDur_or'],1,0,'C',$fond);
$pdf->cell(4,0.7,$row['mque_pro'],1,0,'C',$fond);
$pdf->cell(4,0.7,$row['freq_pro'],1,0,'C',$fond);
$pdf->cell(4,0.7,$row['nom_user'],1,0,'C',$fond);
$pdf->SetXY(1,$pdf->GetY()+0.7);
$xsce = $xsce - 50; $ysce = $ysce + 50;
$xresp = $xresp +1; $yresp = $yresp +1;
$fond=!$fond;
}
} |
Partager