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 76 77 78 79 80 81 82 83 84 85 86 87 88
| <?php
include("phpToPDF.php");
function dateUS2FR($date)
{
$date = explode('/', $date);
$date = array_reverse($date);
$date = implode('-', $date);
return $date;
}
function dateFR2US($date)
{
$date = explode('-', $date);
$date = array_reverse($date);
$date = implode('/', $date);
return $date;
}
mysql_connect("localhost", "root", "");
mysql_select_db("alcatel");
$dateStartDebut= $_POST['DateDebut'];
$dateEndFin= $_POST['DateFin'];
$dateStartReverse=dateUS2FR($dateStartDebut);
$dateEndReverse=dateUS2FR($dateEndFin);
$reponse = mysql_query("SELECT distinct ClassNumber, ClassStartDate, ClassEndDate, CourseNumber2 ,max(TechnicalNumber) AS TechnicalNumber, max(LastName) AS LastName, max(FirstName) AS FirstName, max(CourseNumber) AS CourseNumber,max(Room) AS Room FROM planning WHERE classStartDate between '$dateStartReverse' and '$dateEndReverse' GROUP BY ClassNumber ORDER BY `Room` ASC
");
$PDF = new phpToPDF();
$oldroom=null;
$PDF->SetMargins(20,0,20);
$PDF->ln(60);
while ($donnees = mysql_fetch_array($reponse))
{
$Room=$donnees['Room'];
$CourseNumber=$donnees['CourseNumber2'];
$Trainer = $donnees['LastName']." ".$donnees['FirstName'];
$StartDate=dateFR2US($donnees['ClassStartDate']);
$EndDate=dateFR2US($donnees['ClassEndDate']);
if ($Room==$oldroom)
{
$PDF->Image('./images/logo_ALU_sm.JPG',60,30,80,18);
$PDF->SetFont("Arial","B",12);
if ($Room!=$oldroom)
{
$PDF->MultiCell(0,10,"Salle $Room",1,"C",0);
$PDF->ln(10);
}
else {
$PDF->ln(10);
$PDF->MultiCell(0,10,"$CourseNumber",1,"C",0);
$PDF->MultiCell(0,10,"du $dateStartFR au $dateEndFR",1,"C",0);
$PDF->MultiCell(0,10,"FORMATEUR :$Trainer",1,"C",0);
$oldroom = $Room;
}
}
else {
$PDF->AddPage();
$PDF->ln(60);
$PDF->SetFont("Arial","B",12);
$PDF->Image('./images/logo_ALU_sm.JPG',60,30,80,18);
$PDF->MultiCell(0,10,"Salle $Room",1,"C",0);
$PDF->ln(10);
$PDF->MultiCell(0,10,"$CourseNumber",1,"C",0);
$PDF->MultiCell(0,10,"du $dateStartFR au $dateEndFR",1,"C",0);
$PDF->MultiCell(0,10,"FORMATEUR :$Trainer",1,"C",0);
$oldroom = $Room;
}
}
$PDF->Output();
?> |
Partager