function buildFacturesEnCoursTable($id) { $mysqli = new mysqli(DBSERVER, DBUSER, DBPWD, DB); $query = "SELECT * FROM `factures_cantine` WHERE `acceptation` = '1' AND `reglement` = '0' AND `avoir` = '0' AND `idclient` = {$id} ORDER BY `idfacture` DESC LIMIT 10"; //echo $query; $result = $mysqli->query($query); $list = "<select id='slt_facture' name='slt_facture'>"; while ($row = $result->fetch_array(MYSQLI_ASSOC)) { $list .= "<option value='CANT" . $row['idfacture'] . "'>Facture cantine " . $row['communeid'] . " du " . reverse_date_to_normal($row['datefacture']) . ", montant de " . $row['montantfcp'] . " FCP (" . $row['montanteuro'] . "€)</option>"; } $list .= "</select>"; $mysqli->close(); return $list; }
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"; break; case "Mme": $civilite = "Madame";