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();
$verif=$_SESSION['verif'];
if ($verif == 1)
{
include("phpToPDF.php");
function LoadData($file)
{
$lines=file($file);
$data=array();
foreach($lines as $line)
$data[]=explode(';',chop($line));
return $data;}
$PDF=new phpToPDF();
$PDF->AddPage();
define('FPDF_FONTPATH','font/');
require('mysql_table.php');
class PDF extends PDF_MySQL_Table
{
function Header()
{
$date = $_POST['date'];
//Titre
$this->Image('img/logo.jpg',10,8,33);
$this->SetFont('Arial','',18);
$this->MultiCell(0, 10, "\nBordereau d'envoi\n\ndu $date ", 0, "C", 0);
$this->Ln(10);
//Imprime l'en-tête du tableau si nécessaire
parent::Header();
}
}
//Connexion à la base
mysql_connect('localhost','spipia19','spipia19');
mysql_select_db('spipia19');
$annee = $_POST['anneesco'];
$semaine = $_POST['semaine'];
$rep= 'PDF/'.$annee.'/'.$semaine.'/';
$pdf=new PDF();
$pdf->Open();
$pdf->AddPage();
//$pdf->AddPage();
//Second tableau : définit 3 colonnes
$pdf->AddCol('NOMDOC',50,'Nom de la pièce jointe','C');
$pdf->AddCol('OBJDOC',100,'Objet');
$pdf->AddCol('DESDOC',55,'Destinataire');
$prop=array('HeaderColor'=>array(255,255,255),
'color1'=>array(255,255,255),
'color2'=>array(255,255,255),
'padding'=>2);
$pdf->Table("select NOMDOC,OBJDOC,DESDOC from document WHERE REPDOC='$rep'",$prop);
$pdf->MultiCell(0, 10, "Emargement :\n\n ", 0, "L", 0);
$pdf->Output("$rep".'/bordereau-ecole.pdf');
$pdf->Output();
$pdf=Table("INSERT INTO document (IDDOC,NOMDOC,OBJDOC,REPDOC) VALUES ('','bordereau-ecole.pdf','Bordereau d'emargement','$rep'");
mysql_query($sql) or die('Erreur SQL !'.$sql.'<br>'.mysql_error());
}
else
{
header("location: index.php?err=1");
}
?> |
Partager