function update_data($f)
{
reset_status_cantine();
$new_f = str_replace(".csv", "_FAAA.csv", $f);
//echo ($new_f)."<br>";
$fr = fopen($f, 'r');
$fw = fopen($new_f, 'w');
$total = 0;
$touteslettres = "";
while (!feof($fr)) {
$l = fgets($fr);
$ar_l = explode(";", $l);
if (is_numeric($ar_l[0])) {
//echo "processing line ".$l."<br />";
$cf = $ar_l[5] / 100;
$debut = mysqldateformat($ar_l[6]);
$fin = mysqldateformat($ar_l[7]);
$days = (strtotime($fin) - strtotime($debut)) / 86400;
$months = round($days / 30);
$ar_l[8] = "DP";
$ar_l[9] = $months;
$ar_l[10] = 1600 * $cf;
$ar_l[11] = $months * 1600 * $cf;
$ar_l[12] = 0;
$ar_l[13] = $ar_l[11];
$ar_l[14] = 0;
$ar_l[15] = 0;
$ar_l[16] = $ar_l[11];
$total += $ar_l[16];
$touteslettres = chiffre_en_lettre($total);
$l = join(";", $ar_l);
fwrite($fw, $l);
$cps = $ar_l[1];
if ($ar_l[5] == "100") {
$status = 15;
} else {
$status = 16;
}
update_enfant($cps, $status, $fin);
} else {
if (substr($l, 0, 3) == ";;;") {
//end
$l = str_replace("Total;;", "Total;{$total};", $l);
$l = str_replace("(en toutes lettres) :", "(en toutes lettres) : {$touteslettres}", $l);
fwrite($fw, $l);
} else {
//echo "ignoring line ".$l."<br />";
fwrite($fw, $l);
}
}
unset($ar_l);
}
fclose($fr);
fclose($fw);
output_file($new_f, substr($new_f, 4), "csv");
}
function enterdata($id, $date_paiement, $payeur, $type, $numero_cheque, $organisme, $date_virement, $date_tresor, $info_tresor, $tpe, $montantcfp, $montanteuro, $mode, $echelonnage, $obs, $restearegler, $reglement, $table)
{
$mysqli = new mysqli(DBSERVER, DBUSER, DBPWD, DB);
$mysqli->set_charset("utf8");
//if($table=="repas")$table="cantine";
switch ($mode) {
case "num":
$query = "INSERT INTO `paiements` (`idpaiement`,`idfacture`,`date_paiement`,`payeur`,`type`,`mode`,`montantcfp`,`montanteuro`,`obs`)" . " VALUES (NULL, '" . $id . "', '" . $date_paiement . "', '" . $payeur . "', '" . $type . "', '" . $mode . "', '" . $montantcfp . "', '" . $montanteuro . "', '" . $obs . "')";
$mysqli->query($query);
$lastid = $mysqli->insert_id;
////next update facture
$query = "UPDATE `factures_" . $table . "` SET `reglement`='{$reglement}', `datereglement`='{$date_paiement}', `restearegler`='{$restearegler}',`comment`=CONCAT(`comment`,' ; " . date("d/m/y") . " Réglée ({$mode} par {$payeur})') WHERE `factures_" . $table . "`.`idfacture` = {$id}";
$mysqli->query($query);
break;
case "chq":
$query = "INSERT INTO `paiements` (`idpaiement`,`idfacture`,`date_paiement`,`payeur`,`type`,`mode`,`montantcfp`,`montanteuro`,`numero_cheque`,`organisme`,`obs`)" . " VALUES (NULL, '" . $id . "', '" . $date_paiement . "', '" . $payeur . "', '" . $type . "', '" . $mode . "', '" . $montantcfp . "', '" . $montanteuro . "', '" . $numero_cheque . "', '" . $organisme . "', '" . $obs . "')";
$mysqli->query($query);
$lastid = $mysqli->insert_id;
////next update facture
$query = "UPDATE `factures_" . $table . "` SET `reglement`='{$reglement}', `datereglement`='" . $date_paiement . "', `restearegler`='{$restearegler}',`comment`=CONCAT(`comment`,' ; " . date("d/m/y") . " Réglée ({$mode} par {$payeur})') WHERE `factures_" . $table . "`.`idfacture` = {$id}";
$mysqli->query($query);
break;
case "tsr":
$date_tresor = mysqldateformat($date_tresor);
$query = "INSERT INTO `paiements` (`idpaiement`,`idfacture`,`date_paiement`,`payeur`,`type`,`mode`,`montantcfp`,`montanteuro`,`date_transaction`,`info_tresor`,`obs`)" . " VALUES (NULL, '" . $id . "', '" . $date_paiement . "', '" . $payeur . "', '" . $type . "', '" . $mode . "', '" . $montantcfp . "', '" . $montanteuro . "', '" . $date_tresor . "', '" . $info_tresor . "', '" . $obs . "')";
$mysqli->query($query);
$lastid = $mysqli->insert_id;
////next update facture
$query = "UPDATE `factures_" . $table . "` SET `reglement`='{$reglement}', `datereglement`='" . $date_paiement . "', `restearegler`='{$restearegler}',`comment`=CONCAT(`comment`,' ; " . date("d/m/y") . " Réglée ({$mode} par {$payeur})') WHERE `factures_" . $table . "`.`idfacture` = {$id}";
$mysqli->query($query);
break;
case "12cf":
case "22cf":
case "vir":
$mode = "vir";
$date_virement = mysqldateformat($date_virement);
$query = "INSERT INTO `paiements` (`idpaiement`,`idfacture`,`date_paiement`,`payeur`,`type`,`mode`,`montantcfp`,`montanteuro`,`date_transaction`,`obs`)" . " VALUES (NULL, '" . $id . "', '" . $date_paiement . "', '" . $payeur . "', '" . $type . "', '" . $mode . "', '" . $montantcfp . "', '" . $montanteuro . "', '" . $date_virement . "', '" . $obs . "')";
$mysqli->query($query);
$lastid = $mysqli->insert_id;
////next update facture
$query = "UPDATE `factures_" . $table . "` SET `reglement`='{$reglement}', `datereglement`='" . $date_paiement . "', `restearegler`='{$restearegler}',`comment`=CONCAT(`comment`,' ; " . date("d/m/y") . " Réglée ({$mode} par {$payeur})') WHERE `factures_" . $table . "`.`idfacture` = {$id}";
$mysqli->query($query);
break;
case "mnd":
$query = "INSERT INTO `paiements` (`idpaiement`,`idfacture`,`date_paiement`,`payeur`,`type`,`mode`,`montantcfp`,`montanteuro`,`obs`)" . " VALUES (NULL, '" . $id . "', '" . $date_paiement . "', '" . $payeur . "', '" . $type . "', '" . $mode . "', '" . $montantcfp . "', '" . $montanteuro . "', '" . $obs . "')";
$mysqli->query($query);
$lastid = $mysqli->insert_id;
////next update facture
$query = "UPDATE `factures_" . $table . "` SET `reglement`='{$reglement}', `datereglement`='" . $date_paiement . "', `restearegler`='{$restearegler}',`comment`=CONCAT(`comment`,' ; " . date("d/m/y") . " Réglée ({$mode} par {$payeur})') WHERE `factures_" . $table . "`.`idfacture` = {$id}";
$mysqli->query($query);
break;
case "tpe":
$query = "INSERT INTO `paiements` (`idpaiement`,`idfacture`,`date_paiement`,`payeur`,`type`,`mode`,`tpe`,`montantcfp`,`montanteuro`,`obs`)" . " VALUES (NULL, '" . $id . "', '" . $date_paiement . "', '" . $payeur . "', '" . $type . "', '" . $mode . "', '" . $tpe . "', '" . $montantcfp . "', '" . $montanteuro . "', '" . $obs . "')";
$mysqli->query($query);
$lastid = $mysqli->insert_id;
////next update facture
$query = "UPDATE `factures_" . $table . "` SET `reglement`='{$reglement}', `datereglement`='" . $date_paiement . "', `restearegler`='{$restearegler}',`comment`=CONCAT(`comment`,' ; " . date("d/m/y") . " Réglée ({$mode} par {$payeur})') WHERE `factures_" . $table . "`.`idfacture` = {$id}";
$mysqli->query($query);
break;
case "22bc":
${$reglement} = 1;
$restearegler = 0;
$query = "UPDATE `factures_" . $table . "` SET `reglement`='{$reglement}', `datereglement`='" . $date_paiement . "', `restearegler`='{$restearegler}',`comment`=CONCAT(`comment`,' ; " . date("d/m/y") . " Application 2/2 Bourse Commune') WHERE `factures_" . $table . "`.`idfacture` = {$id}";
$mysqli->query($query);
enterbourse($id, $mode, $montantcfp);
$lastid = 0;
break;
case "12bc":
$query = "UPDATE `factures_" . $table . "` SET `reglement`='{$reglement}', `datereglement`='{$date_paiement}', `restearegler`='{$restearegler}',`comment`=CONCAT(`comment`,' ; " . date("d/m/y") . " Application 1/2 Bourse Commune') WHERE `factures_" . $table . "`.`idfacture` = {$id}";
$mysqli->query($query);
enterbourse($id, $mode, $montantcfp);
$lastid = 0;
break;
default:
$lastid = 0;
break;
}
$mysqli->close();
return $lastid;
}
