<?php
require 'fpdf/fpdf.php';
require_once 'config.php';
require_once 'global_functions.php';
$idfacture = $_GET['idfacture'];
$typefacture = $_GET['type'];
$table = $_GET['table'];
$montant = trispace($_GET['montant']);
$nofacture = $_GET['communeid'];
$lastrelancedate = $_GET['relancedate'];
$force = $_GET['force'];
$datefacture = reverse_date_to_normal($_GET['date']);
if ($lastrelancedate == '' || $force == '1') {
$chrono = updatechrono($table, $idfacture);
$today = date("d/m/Y");
} else {
$chrono = getlastchrono($idfacture);
$today = reverse_date_to_normal($lastrelancedate);
}
$mysqli = new mysqli(DBSERVER, DBUSER, DBPWD, DB);
switch ($typefacture) {
case "cantine":
$query = "SELECT `clients`.`clientcivilite`,`clients`.`clientnom`,`clients`.`clientprenom`,`clients`.`clientbp`,`clients`.`clientcp`,`clients`.`clientville` FROM `clients` INNER JOIN `factures_cantine` ON `factures_cantine`.`idclient` = `clients`.`clientid` WHERE `factures_cantine`.`idfacture` = '{$idfacture}'";
$result = $mysqli->query($query);
$row = $result->fetch_array(MYSQLI_ASSOC);
$client = $row["clientnom"] . " " . $row["clientprenom"];
$contact = "BP " . $row['clientbp'] . " - " . $row['clientcp'] . " " . $row['clientville'];
switch ($row["clientcivilite"]) {
case "Mr":
$civilite = "Monsieur";
function getchrono()
{
$mysqli = new mysqli(DBSERVER, DBUSER, DBPWD, DB);
$result = $mysqli->query("SELECT MAX(`chrono`) FROM `" . DB . "`.`chrono`");
$row = $result->fetch_row();
$chrono = $row[0];
$mysqli->close();
$newchrono = updatechrono($chrono);
return $newchrono;
}
