Bonsoir !

<?php
 session_start();
 require('api/fpdf.php');
 //connexion à la base
 include_once('../include/include_data.php');
 include_once('../include/include_num_page_portrait.php');
 //Disable automatic page break
 $pdf->SetAutoPageBreak(true);
 $result0 = mysqli_query($db, "SELECT acompte_details.ID_VENTE, acompte_details.NOM_CLIENT, acompte_details.TEL_CLIENT, acompte_details.STATUT_VENTE, acompte_details.DATE_STATUT, acompte_details.PRIXTTC_VENTE, acompte_details.DEJA_PAYER, acompte_details.RESTE_PAYER, acompte_details.DATE_VENTE FROM acompte_details WHERE acompte_details.TEL_CLIENT = '".$_GET['TEL_CLIENT']."'");
 $nb = mysqli_fetch_array($result0);
 //Add first page
 // $pdf->AddPage('','A4',0);
 $pdf->Image('api\tutorial/logosara.png',10,3,190);
 //set initial y axis position per page
 $y_axis_initial = 20;
 $y_axis =44;
 //print column titles
 
 $pdf->SetFillColor(248, 248, 248);
 $pdf->SetFont('Times', 'BU', 12);
 
 $pdf->SetTextColor(0);
 $pdf->SetY($y_axis_initial);
 $pdf->SetX(10);
 $pdf->Ln(12);
 $pdf->SetFont('Times', 'BU', 14);
 $pdf->Cell(190,0,'LES ACOMPTES DE MR. '.$nb['NOM_CLIENT'],0,0,'C',1);
 $pdf->SetFont('Times', '', 12);
 $pdf->SetY($y_axis_initial);
 $pdf->SetX(10);
 $pdf->Ln(18);
 $pdf->SetFont('Times', 'B', 10);
 $pdf->Cell(10, 6, utf8_decode('N°'), 1, 0, 'C', 1);
 $pdf->Cell(40, 6, utf8_decode('N° DE FACTURE'), 1, 0, 'C', 1);
 $pdf->Cell(25, 6, 'D.ACOMPTE', 1, 0, 'C', 1);
 $pdf->Cell(25, 6, 'D.VENTE', 1, 0, 'C', 1);
 $pdf->Cell(30, 6, 'P.V', 1, 0, 'C', 1);
 $pdf->Cell(30, 6, 'ACOMPTE', 1, 0, 'C', 1);
 $pdf->Cell(30, 6, 'RESTE', 1, 0, 'C', 1);
 $pdf->SetFont('Times', '', 9);
 $pdf->Ln(24);
 
 //Select the Products you want to show in your PDF file
 //$ID_AGTS=$_SESSION['ID_AGTS_PRINT'];
 $result = mysqli_query($db, "SELECT acompte_details.ID_VENTE, acompte_details.NOM_CLIENT, acompte_details.TEL_CLIENT, acompte_details.STATUT_VENTE, acompte_details.DATE_STATUT, acompte_details.PRIXTTC_VENTE, acompte_details.DEJA_PAYER, acompte_details.RESTE_PAYER, acompte_details.DATE_VENTE FROM acompte_details WHERE acompte_details.TEL_CLIENT = '".$_GET['TEL_CLIENT']."'");

 //initialize counter
 $i = 0;

 //Set maximum rows per page
 $max = 24;

 //Set Row Height
 $row_height = 6;
 $somprittc=0;
 $somacompte_details=0;
 $somreste=0;
 $somreste=0;
 $numordre = 0; 
 while($row = mysqli_fetch_array($result))
 {
  //If the current row is the last one, create new page and print column title
  if ($i == $max)
  {
   $pdf->AddPage('L','A4',0);
   
   
   //Go to next row
   $y_axis = 30;
   //Set $i variable to 0 (first row)
   $i = 0;
  }
  $numordre = $numordre+1;
  $numerovente = $row['ID_VENTE'];
  $acptedate = utf8_decode($row['DATE_STATUT']);
  $ventedate = utf8_decode($row['DATE_VENTE']);
  $prittc = utf8_decode($row['PRIXTTC_VENTE']);
  $acompte_details = utf8_decode($row['DEJA_PAYER']);
  $reste = utf8_decode ($row['RESTE_PAYER']);
  $champ_date = date_create(""); 
  $annee = date_format($champ_date, 'Y');
                $num_fact = $annee .' HBL.T-G ' .$numerovente;
  $pdf->SetY($y_axis_initial);
  $pdf->SetX(10);

  
  $pdf->SetY($y_axis);
  $pdf->SetX(10);
  $pdf->Cell(10, 6, $numordre, 1, 0, 'C',0);
  $pdf->Cell(40, 6, $num_fact, 1, 0, 'C', 0);
  $pdf->Cell(25, 6, $acptedate, 1, 0, 'C', 0);
  $pdf->Cell(25, 6, $ventedate, 1, 0, 'C', 0);
  $pdf->Cell(30, 6, number_format($prittc, 0, '.', ' '), 1, 0, 'C', 0);
  $pdf->Cell(30, 6, number_format($acompte_details, 0, '.', ' '), 1, 0, 'C', 0);
  $pdf->Cell(30, 6, number_format($reste, 0, '.', ' '), 1, 0, 'C', 0);
  

  //Go to next row
  $y_axis = $y_axis + $row_height;
  $i++;
  // $somprittc+=$prittc;
  // $somacompte_details+=$acompte_details;
  // $somreste+=$reste;
}
 // $pdf->SetFont('Times', 'B', 10);
 // $pdf->Ln(6)+$y_axis;
 // $pdf->SetX(10);
 // $pdf->Cell(100, 6, 'Totaux', 1, 0, 'C',0);
 // $pdf->Cell(30, 6, number_format($somprittc, 0, '.', ' '), 1, 0, 'C', 0);
 // $pdf->Cell(30, 6, number_format($somacompte_details, 0, '.', ' '), 1, 0, 'C', 0);
 // $pdf->Cell(30, 6, number_format($somreste, 0, '.', ' '), 1, 0, 'C', 0);
$pdf->Ln(15)+$y_axis;
$printer = $_SESSION['NOMPRENOM'];
if(isset($_SESSION['LOGIN_USER']))
{
 $pdf->SetFont('Times', '', 8);
 //$pdf->SetX(10);
 $pdf->Cell(190, 8, 'IMPRIME PAR :  '.$printer, 0, 0, 'C', 0);
} 
//Create new pdf file
// $pdf=new FPDF();

//Send file
$pdf->Output();



?>