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 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75
|
<?php
session_start();
$serverName = ".";
$uid = "SA";
$pwd = "m0615315009";
$dbname = "wsinn";
$connectionInfo = array("UID" => $uid, "PWD" => $pwd, "Database"=>$dbname);
$conn = sqlsrv_connect( $serverName, $connectionInfo);
$num_EAchat=$_SESSION["num_EAchat"];
define('FPDF_FONTPATH','font/');
require('fpdf.php');
$dimension = array(60,60);
$pdf=new FPDF('P','cm',$dimension);
$pdf->Image('C:\xampp\htdocs\WSINN\medias\onp.jpg',50,50,50,50);
//$pdf->Image('C:\xampp\htdocs\WSINN\medias\onp.jpg',50,50); //pour ajouter une image
//$pdf->SetTitle(DUPLICATA [boolean isUTF8]);// pour ajouter un titre au haut de la page
//Titres des colonnes
$header=array('Mat Barque/VSB ' , 'Nom Barque/VSB' , 'N° Visa DPM du DC' , 'Poids acheté par ce mareyeur(kg)' , 'poids vendi par Barque/VSB(kg)' );
$pdf->SetFont('Arial','B',12);
$pdf->AddPage();
$pdf->SetFillColor(96,96,96);
$pdf->SetTextColor(255,255,255);
set_time_limit(0);
$sql = "Select * from V_ETA where N_ETA='".$num_EAchat."'";
$params = array();
$options = array( "Scrollable" => SQLSRV_CURSOR_KEYSET );
$stmt = sqlsrv_query( $conn, $sql, $params, $options);
$num = sqlsrv_num_rows($stmt);
$pdf->SetXY(3,3);
for($i=0;$i<sizeof($header);$i++)
$pdf->cell(8,1,$header[$i],1,0,'C',1);
$pdf->SetFillColor(0xdd,0xdd,0xdd);
$pdf->SetTextColor(0,0,0);
$pdf->SetFont('Arial','',11);
$pdf->SetXY(3,$pdf->GetY()+1);
$fond=0;
while ($row = sqlsrv_fetch_array($stmt,SQLSRV_FETCH_ASSOC)){
$pdf->cell(8,0.7,$row['Code_Vendeur'],1,0,'C',$fond);
$pdf->cell(8,0.7,$row['Vendeur'],1,0,'C',$fond);
$pdf->cell(8,0.7,$row['N_DC'],1,0,'C',$fond);
$pdf->cell(8,0.7,$row['PoidsAchate'],1,0,'C',$fond);
$pdf->cell(8,0.7,$row['PoidsVendu'],1,0,'C',$fond);
$pdf->SetXY(3,$pdf->GetY()+0.7);
$fond=!$fond;
-//print($pdf);
ob_end_clean();
$pdf->output();
}
?> |
Partager