function getInfo() { $id = $_GET['id']; $type = $_GET['type']; $mysqli = new mysqli(DBSERVER, DBUSER, DBPWD, DB); switch ($type) { case "repas": $output[0] = "<b>Encaissement au comptant (Ticket Repas)</b><br/>"; $output[1] = strtoupper($type); break; case "cantine": $query = "SELECT `datefacture`,`communeid`,`montantfcp`,`montanteuro`,`restearegler` FROM `" . DB . "`.`factures_cantine` WHERE `idfacture` = {$id}"; $result = $mysqli->query($query); $row = $result->fetch_array(MYSQLI_ASSOC); $output[0] = "<b>Facture {$type} " . $row['communeid'] . " du " . standarddateformat($row['datefacture']) . " montant " . trispace($row['montantfcp']) . "FCP (" . $row['montanteuro'] . "€)</b><br/>" . "Reste à régler " . trispace($row['restearegler']) . " FCP<input type='hidden' id='montantmax' value='" . $row['restearegler'] . "'/><input type='hidden' id='montanttotal' value='" . $row['montantfcp'] . "'/>"; $output[1] = strtoupper($type); break; case "etal": $query = "SELECT `datefacture`,`communeid`,`montantfcp`,`montanteuro`,`restearegler` FROM `" . DB . "`.`factures_etal` WHERE `idfacture` = {$id}"; $result = $mysqli->query($query); $row = $result->fetch_array(MYSQLI_ASSOC); $output[0] = "<b>Facture Place et Etal " . $row['communeid'] . " du " . standarddateformat($row['datefacture']) . " montant " . trispace($row['montantfcp']) . "FCP (" . $row['montanteuro'] . "€)</b><br/>" . "Reste à régler " . trispace($row['restearegler']) . " FCP<input type='hidden' id='montantmax' value='" . $row['restearegler'] . "'/><input type='hidden' id='montanttotal' value='" . $row['montantfcp'] . "'/>"; $output[1] = "PLACE ET ETAL"; break; case "amarrage": $query = "SELECT `datefacture`,`communeid`,`montantfcp`,`montanteuro`,`restearegler` FROM `" . DB . "`.`factures_amarrage` WHERE `idfacture` = {$id}"; $result = $mysqli->query($query); $row = $result->fetch_array(MYSQLI_ASSOC); $output[0] = "<b>Facture Amarrage " . $row['communeid'] . " du " . standarddateformat($row['datefacture']) . " montant " . trispace($row['montantfcp']) . "FCP (" . $row['montanteuro'] . "€)</b><br/>" . "Reste à régler " . trispace($row['restearegler']) . " FCP<input type='hidden' id='montantmax' value='" . $row['restearegler'] . "'/><input type='hidden' id='montanttotal' value='" . $row['montantfcp'] . "'/>"; $output[1] = "AMARRAGE"; break; } $mysqli->close(); return $output; }
function genpdf($idfacture, $idpaiement, $date, $payeur, $type, $mode, $montant, $initiales, $no_cheque, $organisme, $obs) { $xreg = 1.5; $yreg = 3.5; $pdf = new FPDF('P', 'mm', 'A4'); $pdf->AddPage(); //logo $pdf->Image('img/logo.jpg', 10 + $xreg, 14 + $yreg, 12, 10, 'jpg'); $pdf->SetLineWidth(0.4); $pdf->Rect(4 + $xreg, 7 + $yreg, 196, 30); //rectangle global $pdf->Line(4 + $xreg, 13 + $yreg, 200 + $xreg, 13 + $yreg); //1ere barre horizontale $pdf->Line(27 + $xreg, 7 + $yreg, 27 + $xreg, 37 + $yreg); //1ere barre verticale $pdf->Line(77 + $xreg, 7 + $yreg, 77 + $xreg, 37 + $yreg); //2nd barre verticale $pdf->Line(127 + $xreg, 7 + $yreg, 127 + $xreg, 37 + $yreg); //3eme barre verticale $pdf->Line(152 + $xreg, 7 + $yreg, 152 + $xreg, 37 + $yreg); //4eme barre verticale $pdf->Line(177 + $xreg, 7 + $yreg, 177 + $xreg, 37 + $yreg); //5eme barre verticale $pdf->SetLineWidth(0.2); $pdf->Line(27 + $xreg, 21 + $yreg, 200 + $xreg, 21 + $yreg); //1ere barre fine horizontale $pdf->Line(4 + $xreg, 31 + $yreg, 200 + $xreg, 31 + $yreg); //2nd barre fine horizontale $pdf->SetFont('Arial', '', 8); $pdf->SetXY(4 + $xreg, 7 + $yreg); $pdf->Cell(23, 7, utf8_decode('DATE'), 0, 1, 'C'); $pdf->SetXY(27 + $xreg, 7 + $yreg); $pdf->Cell(50, 7, utf8_decode('NOM de la partie versante'), 0, 1, 'C'); $pdf->SetXY(27 + $xreg, 13 + $yreg); $pdf->Cell(50, 7, utf8_decode('Reçu de M.'), 0, 1, ''); $pdf->SetXY(77 + $xreg, 7 + $yreg); $pdf->Cell(50, 7, utf8_decode('DESIGNATION DES PRODUITS'), 0, 1, 'C'); $pdf->SetXY(127 + $xreg, 7 + $yreg); $pdf->Cell(25, 3.5, utf8_decode('VERSEMENT'), 0, 1, 'C'); $pdf->SetXY(127 + $xreg, 9.5 + $yreg); $pdf->Cell(25, 3.5, utf8_decode('en numéraire'), 0, 1, 'C'); $pdf->SetXY(152 + $xreg, 7 + $yreg); $pdf->Cell(25, 7, utf8_decode('CHEQUES'), 0, 1, 'C'); $pdf->SetXY(177 + $xreg, 7 + $yreg); $pdf->Cell(25, 7, utf8_decode('DIVERS'), 0, 1, 'C'); //data $pdf->SetXY(4 + $xreg, 25 + $yreg); $pdf->Cell(23, 7, "No. " . $idpaiement, 0, 1, 'C'); $pdf->SetXY(4 + $xreg, 31 + $yreg); $pdf->Cell(23, 7, standarddateformat($date), 0, 1, 'C'); $pdf->SetXY(27 + $xreg, 31 + $yreg); $pdf->Cell(50, 7, utf8_decode($obs), 0, 1, ''); $pdf->SetXY(27 + $xreg, 21 + $yreg); $pdf->Cell(50, 10, strtoupper(utf8_decode($payeur)), 0, 1, 'C'); switch ($mode) { case 'num': $pdf->SetXY(125 + $xreg + $xreg, 21 + $yreg); break; case 'chq': $pdf->SetXY(150 + $xreg + $xreg, 19 + $yreg); break; default: $pdf->SetXY(175 + $xreg + $xreg, 21 + $yreg); break; } $pdf->Cell(25, 10, utf8_decode(trispace($montant) . ' FCP'), 0, 1, 'C'); $pdf->SetXY(150 + $xreg + $xreg, 23 + $yreg); $pdf->Cell(25, 10, utf8_decode($organisme . ' ' . $no_cheque), 0, 1, 'C'); $pdf->SetXY(77 + $xreg + $xreg, 13 + $yreg); $pdf->Cell(50, 10, utf8_decode('Facture n° ' . $idfacture), 0, 1, 'C'); $pdf->SetXY(77 + $xreg + $xreg, 21 + $yreg); $pdf->Cell(50, 10, utf8_decode($type), 0, 1, 'C'); $pdf->SetXY(77 + $xreg + $xreg, 29 + $yreg); $pdf->Cell(50, 10, utf8_decode('Receveur ' . $initiales), 0, 1, 'C'); $pdf->Output(); }