function bonDeCommande($bdd, $idco) { /* Récupération des données personnelles du membre */ list($memberID, $nom, $prenom, $titre, $status, $district, $club, $num, $adressesup, $rue, $ville, $cp, $tel, $mobile, $mail, $positionclub, $positiondistrict, $train, $traindate) = getInfos($bdd, $idco); /* Récupération du follower */ list($fnom, $fprenom) = getFollower($bdd, $memberID); $accompagnant = ""; $n = 1; /* nombre de personnes */ if (!(empty($fnom) && empty($fprenom))) { $accompagnant = $fprenom . " " . $fnom; $n = $n + 1; } else { $accompagnant = "Aucun"; } /* On récupère les activités commandées */ /* Récupération du basketID */ $basketID = getBasketID($bdd, $memberID); /* Récupération des activités */ /* On récupère la date du dernier panier */ $belongdate = getDatePanier($bdd, $basketID); /* On récupère toutes les activités */ $sql = 'SELECT Activity.Activity_ID, Activity_Name, YEAR(Activity_Date), MONTH(Activity_Date), DAY(Activity_Date), Activity_Hour, Belong_Price FROM Activity ' . ' INNER JOIN Activity_Type ON (Activity_Type.Activity_Type_ID = Activity.Activity_Type_ID) ' . ' INNER JOIN Belong ON (Belong.Activity_ID = Activity.Activity_ID) ' . ' WHERE (Basket_ID = :id AND Belong_Payement_Way ="CH" AND Congress_ID = ' . congressID . ' AND Belong_Date = :date ) ORDER BY ( Activity_Date)'; $stmt = $bdd->prepare($sql, array(PDO::ATTR_CURSOR, PDO::CURSOR_SCROLL)); $stmt->execute(array(':id' => "{$basketID}", ':date' => "{$belongdate}")); $numCommande = ""; $activite = ' <div> <TABLE id="tableau" border cols="3" style="border:1px solid black;width : 100%; margin-left : 0;border-collapse: collapse;"> <TR class="row" > <Td class ="col" width=120 style="border:1px solid black; background-color : #C9D2D7;text-align : center;"><FONT size="5" > <b> Date </b></FONT></Td> <td class ="col" width=260 style="border:1px solid black; background-color : #C9D2D7; text-align : center;"> <FONT size="5" > <b> Intitulé </b></FONT></td> <td class ="col" width=100 style="border:1px solid black ; background-color : #C9D2D7; text-align : center;"><FONT size="5" > <b> Tarif </b> </FONT></td> <td class ="col" width=160 style="border:1px solid black ; background-color : #C9D2D7; text-align : center;"><FONT size="5" > <b> Nombre de personnes </b> </FONT></td> </TR> '; $total = 0; while ($row = $stmt->fetch(PDO::FETCH_ASSOC, PDO::FETCH_ORI_NEXT)) { $numCommande = $numCommande . "." . $row["Activity_ID"]; $act = $row["Activity_Name"]; $annee = $row["YEAR(Activity_Date)"]; $mois = $row["MONTH(Activity_Date)"]; $jour = $row["DAY(Activity_Date)"]; $heure = $row["Activity_Hour"]; $prix = $row["Belong_Price"]; $total = $total + $prix; if ($mois < 10) { $mois = "0" . $mois; } if ($jour < 10) { $jour = "0" . $jour; } $date = $jour . "-" . $mois . "-" . $annee . " à " . $heure; $activite = $activite . '<TR class="row" > <Td class ="col" width=120 style="border:1px solid black; text-align : center;"> <FONT size="3.5" style="color : #252E43">' . $date . '</FONT> </Td> <td class ="col" width=260 style="border:1px solid black; text-align : center;"> <FONT size="3.5" style="color : #252E43">' . $act . '</FONT> </td> <td class ="col" width=100 style="border:1px solid black; text-align : center;"><FONT size="3.5" style="color : #252E43">' . $prix . ' €</FONT> </td> <td class ="col" width=160 style="border:1px solid black; text-align : center;"><FONT size="3.5" style="color : #252E43">' . $n . ' </FONT> </td> </TR> '; } $total = $total * $n; $activite = $activite . ' </TABLE> </div>'; list($a, $mo, $j, $h, $m, $s) = dateAuj($bdd); $dateauj = "{$j}" . "-" . "{$mo}" . "-" . "{$a}"; $numCommande = $memberID . "-" . $numCommande; ob_start(); ?> <page backtop="15mm" backbottom="15mm" backleft="10mm" backright="10mm"> <div class="logo"> <a href="" style="top : 4px"><img alt="" src="images/logo.png" style="height: 50px; width: 55px; top: 4px"></a> </div> <div class="col full"> <h2 style="margin : 65px ; color : #252E43; text-align : center"> <FONT size="6"> Bon de commande n° <?php echo "{$numCommande}"; ?> - <?php echo "{$dateauj}"; ?> </FONT></h2> </div> <div class="row section-head"> <h2 style="color : #11ABB0;" > <FONT size="5">INFORMATIONS PERSONNELLES </FONT></h2> </div> <div> <div style="" > <FONT size="3.5" style="font-weight:normal;color : #252E43;" > <u>Civilité</u> : <?php echo "{$titre}"; ?> </FONT> </div> <div style="" > <FONT size="3.5" style="font-weight:normal;color : #252E43;" > <u>Nom</u> : <?php echo "{$nom}"; ?> </FONT></div> <div style="" > <FONT size="3.5" style="font-weight:normal;color : #252E43;" > <u>Prenom</u> : <?php echo "{$prenom}"; ?> </FONT></div> </div> <div> <div style="" > <FONT size="3.5" style="font-weight:normal;color : #252E43;" > <u>Adresse</u> : <?php echo "{$num} {$rue} ({$adressesup}) {$cp} {$ville}"; ?> </FONT> </div> <div style="" > <FONT size="3.5" style="font-weight:normal;color : #252E43;" > <u>Téléphone</u> : <?php echo "{$tel}"; ?> </FONT> </div> <div style="" > <FONT size="3.5" style="font-weight:normal;color : #252E43;" > <u>Mobile</u> : <?php echo "{$mobile}"; ?> </FONT></div> <div style="" > <FONT size="3.5" style="font-weight:normal;color : #252E43;" > <u>Mail</u> : <?php echo "{$mail}"; ?> </FONT></div> <div style="" > <FONT size="3.5" style="font-weight:normal;color : #252E43;" > <u>Accompagnant</u> : <?php echo "{$accompagnant}"; ?> </FONT></div> </div> <div class="row section-head"> <h2 style="color : #11ABB0;" > <FONT size="5">ACTIVITES RESERVEES</FONT></h2> </div> <?php echo "{$activite}"; ?> <div class="row section-head"> <h2 style="color : #11ABB0;" > <FONT size="5">TOTAL</FONT></h2> </div> <div> <TABLE id="tableau" border width=50% cols="2" style="border:1px solid black;width : 40%; margin-left : 0; border-collapse: collapse;" > <TR class="row" > <Td class ="col" width=300 height = 35 style="border:1px solid black;text-align : center;background-color : #C9D2D7;"><FONT size="4" > <b> Total </b> </FONT></Td> <Td class ="col" width=101 style="border:1px solid black; text-align : center;"><FONT size="3.5" style="color:#BA052C"><?php echo "{$total}"; ?> € </FONT></Td> </TR> </TABLE> </div> <page_footer backtop="5mm" backbottom="10mm" backleft="10mm" backright="10mm"> <div style="text-align:center"> <FONT size="3.5" style="font-weight:normal;color : #252E43; text-align:center" ><i>Page 1/1</i> </FONT></div> </page_footer> </page> <?php $content = ob_get_clean(); require 'html2pdf/html2pdf.class.php'; try { $pdf = new HTML2PDF('P', 'A4', 'fr'); $pdf->writeHTML($content); $pdf->Output('recapitulatif.pdf'); } catch (HTML2PDF_exception $ex) { die($ex); } }
function gereConnexion($bdd) { /* On récupère la date courante */ list($a, $mo, $j, $h, $m, $s) = dateAuj($bdd); /* On récupère toutes les connexions */ $sql = 'SELECT Connexion_ID, Last_Connexion, HOUR(Last_Connexion), MINUTE(Last_Connexion), SECOND(Last_Connexion) FROM Connexion '; $stmt = $bdd->prepare($sql, array(PDO::ATTR_CURSOR, PDO::CURSOR_SCROLL)); $stmt->execute(array()); while ($row = $stmt->fetch(PDO::FETCH_ASSOC, PDO::FETCH_ORI_NEXT)) { $idco = $row['Connexion_ID']; $h2 = $row['HOUR(Last_Connexion)']; $m2 = $row['MINUTE(Last_Connexion)']; $s2 = $row['SECOND(Last_Connexion)']; $diff = $h - $h2 + ($m - $m2) / 60 + ($s - $s2) / 3600; if ($diff > 0.5) { //On supprime la connexion /* Récupération du membre id */ $memberID = getMemberID($bdd, $idco); /* Récupération du basket id */ $basketID = getBasketID($bdd, $memberID); /* Incrémentation des capacités de toutes les activités supprimées */ setCapacity($bdd, $memberID, $basketID); /* Suppression des activités non payées */ videBasket($bdd, $basketID); /* Suppression de la connexion */ suppConnexion($bdd, $idco); } } }