connect_db($_SESSION['maBD']);
$query = 'SELECT idPaiement, idEtablissementPoint, lettre, autreDetail, idUser, idPointService, idTypeFrais, nomDeposant, nomEtudiant, promotion, sectionoption, montantPaye, devise, datePaiement, dateHeurePaiement, annee FROM tabpaiement WHERE codePaiement="'.$_GET['codePaiement'].'" AND validite="OUI"';
$q=$dc->prepare($query);
$q->execute();
$option=""; $lettre="";
while ($a = $q->fetch()) {
$option=" ".$a['autreDetail']; $lettre=" ".$a['lettre'];
if(strtoupper($a['autreDetail'])=="AUCUN" || trim($a['autreDetail'])==""){ $option=""; }
if(strtoupper($a['lettre'])=="AUCUN" || trim($a['lettre'])==""){ $lettre=""; }
$idUser = $a['idUser']; $datePaiement = $a['datePaiement']; $dateHeurePaiement = $a['dateHeurePaiement']; $idPointService = $a['idPointService'];
$nomEtudiant = mb_strtoupper($a['nomEtudiant']); $idTypeFrais = $a['idTypeFrais']; $montantPaye = $a['montantPaye']; $devise = " ".$a['devise'];
$niveauEtude = $a['promotion']." ".mb_strtoupper($a['sectionoption'].$option.$lettre); $idEtablissementPoint = $a['idEtablissementPoint'];
}
$dt1 = DateTime::createFromFormat('Y-m-d', $datePaiement); $datePaiementOk = $dt1->format('d/m/Y');
$dt2 = DateTime::createFromFormat('Y-m-d H:i:s', $dateHeurePaiement); $heureOk = $dt2->format('H')-2; $heure = $dt2->format('H')-2; if($heure<9){$heureOk="0".$heure;} //$dateHeurePaiementOk = $dt2->format('d/m/Y H:i:s');
$dt3 = DateTime::createFromFormat('Y-m-d H:i:s', $dateHeurePaiement); $min = $dt2->format('i');
$dt4 = DateTime::createFromFormat('Y-m-d H:i:s', $dateHeurePaiement); $sec = $dt2->format('s');
$dateHeurePaiementOk = $datePaiementOk." ".$heureOk.":".$min.":".$sec;
$query = 'SELECT nom, prenom FROM user WHERE idUser="'.$idUser.'" AND validite="OUI"';
$q=$dc->prepare($query);
$q->execute();
while ($a = $q->fetch()) {
$utilisateur = mb_strtoupper($a['nom'])." ".ucfirst($a['prenom']);
}
$query = 'SELECT intitule, telephone FROM tabpointservice WHERE idPointService="'.$idPointService.'" AND validite="OUI"';
$q=$dc->prepare($query);
$q->execute();
while ($a = $q->fetch()) {
$nomPointService = $a['intitule']; $telephone = $a['telephone'];
}
$query = 'SELECT intitule FROM tabtypefrais WHERE idTypeFrais="'.$idTypeFrais.'" AND validite="OUI"';
$q=$dc->prepare($query);
$q->execute();
while ($a = $q->fetch()) {
$nomTypeFrais = $a['intitule'];
}
$query = 'SELECT nomEtablissement, acronyme, typeEtablissement FROM tabetablissement WHERE idEtablissement IN (SELECT idEtablissement FROM tabetablissementpoint WHERE idEtablissementPoint="'.$idEtablissementPoint.'" AND validite="OUI") AND validite="OUI"';
$q=$dc->prepare($query);
$q->execute();
while ($a = $q->fetch()) {
$nomEtablissement = mb_strtoupper($a['nomEtablissement']);
$acronyme = mb_strtoupper($a['acronyme']);
$typeEtablissement = mb_strtoupper($a['typeEtablissement']);
}
$query = 'SELECT nomPoint FROM tabetablissementpoint, tabpointexploitation WHERE tabetablissementpoint.idPoint=tabpointexploitation.idPoint AND idEtablissementPoint="'.$idEtablissementPoint.'" AND tabetablissementpoint.validite="OUI" AND tabpointexploitation.validite="OUI"';
$q=$dc->prepare($query);
$q->execute();
while ($a = $q->fetch()) {
$nomPoint = mb_strtoupper($a['nomPoint']);
}
if($typeEtablissement=="ECOLE") { $nomEtablissement=$acronyme." / ".$nomPoint; }
?>
*****************************
SMF IFOD SA
Tel :
Imprime le
Imprime par
BORDEREAU DE DEPOT NUMERO
Etablissement :
Noms etudiant :
Niveau d'etude :
Motif :
Montant paye :
Date operation :
Mode de paiement : Especes
Operateur :
*********** MERCI ***********
setDefaultFont("Arial");
$html2pdf->writeHTML($content);
$html2pdf->Output("votre_pdf.pdf");
}
catch(HTML2PDF_exception $e) {
echo $e;
exit;
}
*/
?>