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'] . "&euro;)</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";