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
mysql_connect('localhost','root','') or die("ERROR DATABASE CONNECTION");
mysql_select_db('REGISTRE') or die("DATA SELECTION ERRROR");
require('fpdf.php');
function render($row) {
$output = "<tr>\n";
$row->date_arrivee = changedateusfr($row->date_arrivee);
$output .= "<td> {$row->date_arrivee}</td>\n";
$output .= "<td>{$row->heure_arrivee}</td>\n";
$output .= "<td>{$row->fonctionnaire}</td>\n";
$output .= "<td>{$row->identite}</td>\n";
$output .= "</tr>\n";
return $output;
}
function changedateusfr($dateus)
{
$datefr=$dateus{8}.$dateus{9}."-".$dateus{5}.$dateus{6}."-".$dateus{0}.$dateus{1}.$dateus{2}.$dateus{3};
return $datefr;
}
function changedatefrus($datefr)
{
$dateus=$datefr{6}.$datefr{7}.$datefr{8}.$datefr{9}."-".$datefr{3}.$datefr{4}."-".$datefr{0}.$datefr{1};
return $dateus;
}
//Titres des colonnes
$header=array('Date','Heure');
setlocale (LC_ALL, "fr_fr","fra");
$result = mysql_query("SELECT id,date_arrivee, heure_arrivee, fonctionnaire,identite,motif,objet,destinataire FROM fiche order BY date_arrivee DESC");
$set = array();
while ($row = mysql_fetch_object($result)) {
$set[$row->date_arrivee][] = $row;
}
mysql_free_result($result);
$pdf=new FPDF('L','cm','A4');
$pdf->setleftmargin(2.5);
$pdf->AddPage();
$pdf->SetFont('Arial','',10);
$pdf->setfillcolor(235);
foreach ($set as $date_arrivee => $records) {
$date_arrivee=changedateusfr($date_arrivee) ;
$date_arrivee=strftime("%A %d %B %Y",strtotime($date_arrivee));
$pdf->ln(0.5);
$pdf->cell(25,0.7, "Journée du {$date_arrivee}",1,1,'C',true);
//en tête des colonnes
for($i=0;$i<sizeof($header);$i++)
$pdf->cell(2,0.5,$header[$i],1,0,'C',1);
$pdf->ln(0.5);
foreach ($records as $row) {
$pdf->cell(2,0.7,changedateusfr($row->date_arrivee),1,0,'C');
$pdf->cell(2,0.7,"$row->heure_arrivee\n",1,0,'C');
$pdf->cell(5,0.7,"$row->fonctionnaire",1,0,'C');
$pdf->cell(4,0.7,"$row->identite",1,0,'C');
$pdf->cell(4,0.7,"$row->motif",1,0,'C');
$pdf->cell(4,0.7,"$row->objet",1,0,'C');
$pdf->cell(4,0.7,"$row->destinataire",1,1,'C');
}
}
$pdf->Output();
?> |