function ajax_verif_date()
{
global $msg, $p1;
$mysql_date = extraitdate($p1);
$rqt = "SELECT DATE_ADD('" . $mysql_date . "', INTERVAL 0 DAY)";
if ($result = mysql_query($rqt)) {
if ($row = mysql_fetch_row($result)) {
if ($row[0]) {
ajax_http_send_response($row[0]);
return;
}
}
}
ajax_http_send_error('400', $msg['error_message_invalid_date']);
}
function verif_date($date)
{
global $msg;
$mysql_date = extraitdate($date);
$rqt = "SELECT DATE_ADD('" . $mysql_date . "', INTERVAL 0 DAY)";
if ($result = mysql_query($rqt)) {
if ($row = mysql_fetch_row($result)) {
if ($row[0]) {
return $row[0];
}
}
}
return false;
}
function strip_slashes()
{
global $search, $explicit_search;
for ($i = 0; $i < count($search); $i++) {
$s = explode("_", $search[$i]);
$field_ = "field_" . $i . "_" . $search[$i];
global ${$field_};
$field = ${$field_};
for ($j = 0; $j < count($field); $j++) {
$field[$j] = stripslashes($field[$j]);
}
if ($explicit_search) {
if ($s[0] == "f") {
$ff = $this->fixedfields[$s[1]];
switch ($ff["INPUT_TYPE"]) {
case "date":
if (!preg_match("/^\\d{4}-\\d{2}-\\d{2}\$/", $field[0])) {
$field_temp = extraitdate($field[0]);
$field[0] = $field_temp;
}
break;
default:
//Rien a faire
break;
}
}
}
${$field_} = $field;
}
}
<?php
// +-------------------------------------------------+
// © 2002-2004 PMB Services / www.sigb.net pmb@sigb.net et contributeurs (voir www.sigb.net)
// +-------------------------------------------------+
// $Id: main.inc.php,v 1.11 2011-11-03 13:49:13 dgoron Exp $
if (stristr($_SERVER['REQUEST_URI'], ".inc.php")) {
die("no access");
}
include "./admin/calendrier/calendrier_func.inc.php";
require_once $class_path . "/docs_location.class.php";
if (($faire == "ouvrir" || $faire == "fermer") && $loc != "") {
$date_deb = extraitdate($date_deb);
$date_fin = extraitdate($date_fin);
if ($faire == "ouvrir") {
$ouverture = 1;
} else {
$ouverture = 0;
}
$rqt_date = "select if(TO_DAYS('" . $date_fin . "')>=TO_DAYS('" . $date_deb . "'),1,0) as OK";
$resultatdate = mysql_query($rqt_date);
$res = mysql_fetch_object($resultatdate);
$date_courante = $date_deb;
while ($res->OK) {
$rqt_date = "select dayofweek('" . $date_courante . "') as jour";
$resultatdate = mysql_query($rqt_date);
$res = mysql_fetch_object($resultatdate);
$jour = "j" . $res->jour;
// OK : traitement
if (${$jour}) {
$rqt_date = "update ouvertures set ouvert={$ouverture}, commentaire='{$commentaire}' where date_ouverture='{$date_courante}' and num_location={$loc} ";
}
break;
case 'val_resa':
//Validation réservation depuis liste
for ($i = 0; $i < count($resa_check); $i++) {
$key = $resa_check[$i];
//On vérifie les dates
$tresa_date_debut = explode('-', extraitdate($resa_date_debut[$key]));
if (strlen($tresa_date_debut[2]) == 1) {
$tresa_date_debut[2] = '0' . $tresa_date_debut[2];
}
if (strlen($tresa_date_debut[1]) == 1) {
$tresa_date_debut[1] = '0' . $tresa_date_debut[1];
}
$r_date_debut = implode('', $tresa_date_debut);
$tresa_date_fin = explode('-', extraitdate($resa_date_fin[$key]));
if (strlen($tresa_date_fin[2]) == 1) {
$tresa_date_fin[2] = '0' . $tresa_date_fin[2];
}
if (strlen($tresa_date_fin[1]) == 1) {
$tresa_date_fin[1] = '0' . $tresa_date_fin[1];
}
$r_date_fin = implode('', $tresa_date_fin);
if (checkdate($tresa_date_debut[1], $tresa_date_debut[2], $tresa_date_debut[0]) && checkdate($tresa_date_fin[1], $tresa_date_fin[2], $tresa_date_fin[0]) && strlen($r_date_debut) == 8 && strlen($r_date_fin) == 8 && $r_date_debut < $r_date_fin) {
$r = new resa_planning($key);
$r->resa_date_debut = implode('-', $tresa_date_debut);
$r->resa_date_fin = implode('-', $tresa_date_fin);
$r->resa_validee = '1';
$r->save();
}
}
$date_caller = str_replace('-', '', $date_caller);
if ($date_caller == "" || $date_caller == "00000000" || $date_caller == "00000000 00:00:00") {
$date_caller = date("Ymd", time());
}
if ($date == "") {
$date = $date_caller;
}
echo "\n<script type='text/javascript'>\n<!--\nfunction set_parent(f_caller, id_value, libelle_value)\n{\n\twindow.opener.document.forms[f_caller].elements['{$param1}'].value = id_value;\n\twindow.opener.document.forms[f_caller].elements['{$param2}'].value = libelle_value;\n\t\n\tvar after = new String('{$after}');\n\tif (after.length != 0 ) window.opener.eval('{$after}');\n\t";
if ($auto_submit == "YES") {
echo "\twindow.opener.document.forms[f_caller].submit();";
}
echo "\n\twindow.close();\n}\n-->\n</script>\n";
// issu de la saisie directe de la date.
if ($act == "calc_date") {
// Mettre le parent appelant à jour, et sortir.
$mysql_date = extraitdate($date);
if ($format_return == "IN") {
$date_aff_formatee = formatdate_input($mysql_date);
} else {
$date_aff_formatee = formatdate($mysql_date);
}
print "<script type='text/javascript'>set_parent('{$caller}','{$mysql_date}','" . $date_aff_formatee . "')</script>";
} else {
$params['calendar_id'] = 1;
$params['calendar_columns'] = 7;
$params['show_day'] = 1;
$params['show_month'] = 1;
$params['nav_link'] = 1;
$params['link_after_date'] = 1;
if ($date_anterieure == "YES") {
$params['link_before_date'] = 1;
function update_fac($statut = 0)
{
global $id_bibli, $id_cde, $id_fac, $comment, $ref;
global $max_lig, $max_lig_fac, $id_lig, $id_prod, $code, $lib, $prix, $typ, $tva, $rem, $rub, $fac;
global $date_pay, $num_pay, $devise;
$tab_fac = array();
//Tableau des lignes facturées
//Les lignes restant à facturer sont reprises dans le tableau si la qté facturée est >0
for ($i = 1; $i <= $max_lig; $i++) {
if ($fac[$i]) {
$tab_fac[$i]['id_lig'] = $id_lig[$i];
$tab_fac[$i]['id_prod'] = $id_prod[$i];
$tab_fac[$i]['code'] = $code[$i];
$tab_fac[$i]['lib'] = $lib[$i];
$tab_fac[$i]['prix'] = round($prix[$i], 2);
$tab_fac[$i]['typ'] = $typ[$i];
$tab_fac[$i]['tva'] = $tva[$i];
$tab_fac[$i]['rem'] = round($rem[$i], 2);
$tab_fac[$i]['rub'] = $rub[$i];
$tab_fac[$i]['fac'] = $fac[$i];
}
}
//Les quantités facturées des lignes déjà facturées sont reportées dans le tableau si l'identifiant de ligne existe
//et que les prix, types de produits, remises et budgets sont égaux
//Sinon une nouvelle ligne est créée
for ($i; $i <= $max_lig + $max_lig_fac; $i++) {
$deja = false;
for ($j = 1; $j <= $max_lig; $j++) {
//Y a-t'il une ligne deja créée
if ($tab_fac[$j]['id_lig'] == $id_lig[$i] && $tab_fac[$j]['prix'] == $prix[$i] && $tab_fac[$j]['typ'] == $typ[$i] && $tab_fac[$j]['rem'] == $rem[$i] && $tab_fac[$j]['rub'] == $rub[$i]) {
//Si oui, on rajoute la quantité reçue dans le tableau
$tab_fac[$j]['fac'] = $tab_fac[$j]['fac'] + $fac[$i];
$deja = true;
break;
}
}
if (!$deja) {
//Sinon, on crée la ligne dans le tableau
$tab_fac[$i]['id_lig'] = $id_lig[$i];
$tab_fac[$i]['id_prod'] = $id_prod[$i];
$tab_fac[$i]['code'] = $code[$i];
$tab_fac[$i]['lib'] = $lib[$i];
$tab_fac[$i]['prix'] = round($prix[$i], 2);
$tab_fac[$i]['typ'] = $typ[$i];
$tab_fac[$i]['tva'] = $tva[$i];
$tab_fac[$i]['rem'] = round($rem[$i], 2);
$tab_fac[$i]['rub'] = $rub[$i];
$tab_fac[$i]['fac'] = $fac[$i];
}
}
//Récupération de la commande
$cde = new actes($id_cde);
if (!$id_fac) {
//Création de la facture
$factu = new actes();
$factu->date_acte = today();
$factu->type_acte = TYP_ACT_FAC;
if ($statut) {
$factu->statut = $statut;
} else {
$factu->statut = STA_ACT_REC;
}
$factu->num_entite = $cde->num_entite;
$factu->num_fournisseur = $cde->num_fournisseur;
$factu->num_contact_livr = $cde->num_contact_livr;
$factu->num_contact_fact = $cde->num_contact_fact;
$factu->num_exercice = $cde->num_exercice;
$factu->commentaires = $comment;
$factu->reference = $ref;
$factu->devise = $devise;
if ($date_pay != '') {
$factu->date_paiement = extraitdate($date_pay);
}
$factu->num_paiement = $num_pay;
$factu->calc();
$factu->save();
$id_fac = $factu->id_acte;
//création des liens entre actes
$la = new liens_actes($id_cde, $id_fac);
} else {
//Modification de la facture
$factu = new actes($id_fac);
$factu->numero = addslashes($factu->numero);
$factu->commentaires = trim($comment);
$factu->reference = trim($ref);
if ($date_pay != '') {
$factu->date_paiement = extraitdate($date_pay);
}
$factu->num_paiement = trim($num_pay);
if ($statut) {
$factu->statut = $statut;
}
$factu->devise = trim($devise);
$factu->save();
}
//Suppression des lignes de facture précédemment enregistrées
actes::deleteLignes($id_fac);
//Création des lignes de facture
foreach ($tab_fac as $key => $value) {
$lig_cde = new lignes_actes($tab_fac[$key]['id_lig']);
$lig_fac = new lignes_actes();
$lig_fac->num_acte = $factu->id_acte;
$lig_fac->lig_ref = $lig_cde->id_ligne;
$lig_fac->num_produit = $lig_cde->num_produit;
$lig_fac->code = addslashes($lig_cde->code);
$lig_fac->libelle = addslashes($lig_cde->libelle);
$lig_fac->num_acquisition = $lig_cde->num_acquisition;
$lig_fac->num_type = $lig_cde->num_type;
$lig_fac->prix = $tab_fac[$key]['prix'];
$lig_fac->tva = $tab_fac[$key]['tva'];
$lig_fac->remise = $tab_fac[$key]['rem'];
$lig_fac->num_rubrique = $tab_fac[$key]['rub'];
$lig_fac->nb = $tab_fac[$key]['fac'];
$lig_fac->date_cre = today();
$lig_fac->save();
}
//La commande est-elle entièrement facturée
$tab_cde = actes::getLignes($id_cde);
$facture = true;
while ($row_cde = mysql_fetch_object($tab_cde)) {
$tab_fac = lignes_actes::getFactures($row_cde->id_ligne);
$nb_fac = 0;
while ($row_fac = mysql_fetch_object($tab_fac)) {
$nb_fac = $nb_fac + $row_fac->nb;
}
if ($row_cde->nb > $nb_fac) {
$facture = false;
break;
}
}
if ($facture) {
//Pas de reste à facturer >>Statut commande=facturée
$cde->statut = $cde->statut | STA_ACT_FAC;
//Si de plus toutes les factures sont payées, Statut commande=payé
$tab_pay = liens_actes::getChilds($id_cde, TYP_ACT_FAC);
$paye = true;
while ($row_pay = mysql_fetch_object($tab_pay)) {
if (($row_pay->statut & STA_ACT_PAY) != STA_ACT_PAY) {
$paye = false;
break;
}
}
if ($paye) {
$cde->statut = $cde->statut | STA_ACT_PAY;
}
} else {
//Sinon, la commande repasse en statut en cours
$cde->statut = $cde->statut & ~(STA_ACT_FAC | STA_ACT_PAY);
}
$cde->update_statut();
}
function detectFormatDate($date_a_convertir, $compl = "01")
{
global $msg;
if (preg_match("#\\d{4}-\\d{2}-\\d{2}#", $date_a_convertir)) {
$date = $date_a_convertir;
} else {
if (preg_match(getDatePattern(), $date_a_convertir)) {
$date = extraitdate($date_a_convertir);
} elseif (preg_match(getDatePattern("short"), $date_a_convertir)) {
$format = str_replace("%", "", $msg["format_date_short"]);
$format = str_replace("-", "", $format);
$format = str_replace("/", "", $format);
$format = str_replace("\\", "", $format);
$format = str_replace(".", "", $format);
$format = str_replace(" ", "", $format);
$format = str_replace($msg["format_date_input_separator"], "", $format);
list($date[substr($format, 0, 1)], $date[substr($format, 1, 1)], $date[substr($format, 2, 1)]) = sscanf($date_a_convertir, $msg["format_date_short_input"]);
if ($date['Y'] && $date['m']) {
if ($compl == "min") {
$date = sprintf("%04d-%02d-%02s", $date['Y'], $date['m'], "01");
} elseif ($compl == "max") {
$date = sprintf("%04d-%02d-%02s", $date['Y'], $date['m'], date("t", mktime(0, 0, 0, $date['m'], 1, $date['Y'])));
} else {
$date = sprintf("%04d-%02d-%02s", $date['Y'], $date['m'], $compl);
}
} else {
$date = "0000-00-00";
}
} elseif (preg_match(getDatePattern("year"), $date_a_convertir, $matches)) {
if ($compl == "min") {
$date = $matches[0] . "-01-01";
} elseif ($compl == "max") {
$date = $matches[0] . "-12-31";
} else {
$date = $matches[0] . "-" . $compl . "-" . $compl;
}
} else {
$format = str_replace("%", ".", $msg["format_date"]);
$format = str_replace("-", "", $format);
$format = str_replace("/", "", $format);
$format = str_replace("\\", "", $format);
$format = str_replace(".", "", $format);
$format = str_replace(" ", "", $format);
$pattern = array();
for ($i = 0; $i < strlen($format); $i++) {
switch ($format[$i]) {
case "m":
case "d":
$pattern[$i] = '\\d{1,2}';
break;
case "Y":
$pattern[$i] = '(\\d{2})';
break;
}
}
if (preg_match("#" . implode($pattern, ".") . "#", $date_a_convertir, $matches)) {
if (substr(date("Y"), 2, 2) < $matches['1']) {
$correct_year = substr(date("Y"), 0, 2) * 1 - 1 . $matches[1];
} else {
$correct_year = substr(date("Y"), 0, 2) . $matches[1];
}
if (substr($format, -1) == "Y") {
$date = detectFormatDate(substr($date_a_convertir, 0, -2) . $correct_year, $compl);
}
} else {
$date = "0000-00-00";
}
}
}
return $date;
}
}
if ($acces_m == 0) {
if (!$bul_id) {
error_message('', htmlentities($dom_1->getComment('mod_seri_error'), ENT_QUOTES, $charset), 1, '');
} else {
error_message('', htmlentities($dom_1->getComment('mod_bull_error'), ENT_QUOTES, $charset), 1, '');
}
} else {
// script d'update d'un bulletinage
// nettoyage des valeurs du form
// les valeurs passees sont mises en tableau pour etre passees
// a la methode de mise a jour
$table = array();
$table['bul_no'] = clean_string($bul_no);
$table['bul_date'] = clean_string($bul_date);
$table['date_date'] = extraitdate($date_date_lib);
$table['bul_cb'] = clean_string($bul_cb);
$table['bul_titre'] = $bul_titre;
// mise a jour de l'entete de page
echo str_replace('!!page_title!!', $msg[4000] . $msg[1003] . $msg['catalog_serie_modif_bull'], $serial_header);
// nettoyage des valeurs du form
$f_tit1 = clean_string($f_tit1);
$f_tit3 = clean_string($f_tit3);
$f_tit4 = clean_string($f_tit4);
//$f_n_gen = clean_string($f_n_gen);
//$f_n_resume = clean_string($f_n_resume);
//$f_indexation = clean_string($f_indexation);
$f_lien = clean_string($f_lien);
$f_eformat = clean_string($f_eformat);
// les valeurs passees sont mises en tableau pour etre passees
// a la methode de mise à jour
<?php
// +-------------------------------------------------+
// © 2002-2004 PMB Services / www.sigb.net pmb@sigb.net et contributeurs (voir www.sigb.net)
// +-------------------------------------------------+
// $Id: ajax_scan_requests.inc.php,v 1.1 2016-01-13 15:41:42 apetithomme Exp $
if (stristr($_SERVER['REQUEST_URI'], ".inc.php")) {
die("no access");
}
require_once $base_path . "/classes/scan_request/scan_request.class.php";
switch ($sub) {
case 'form':
switch ($action) {
case 'create':
$scan_request = new scan_request();
$scan_request_date = extraitdate($scan_request_date);
$scan_request_deadline_date = extraitdate($scan_request_deadline_date);
$scan_request_wish_date = extraitdate($scan_request_wish_date);
$scan_request->get_values_from_form();
$saved = $scan_request->save();
if ($saved) {
print $msg['scan_request_saved'];
print " " . str_replace('!!link!!', './empr.php?tab=scan_requests&lvl=scan_request&sub=display&id=' . $scan_request->get_id(), $msg['scan_request_saved_see_link']);
} else {
print $msg['scan_request_cant_save'];
}
break;
}
break;
}
$myEtagere->validite_date_deb = extraitdate($form_visible_deb);
$myEtagere->validite_date_fin = extraitdate($form_visible_fin);
$myEtagere->visible_accueil = $form_visible_accueil;
$myEtagere->tri = $tri;
$myEtagere->save_etagere();
aff_etagere("edit_etagere", 1);
break;
case 'valid_new_etagere':
$myEtagere = new etagere(0);
$myEtagere->create_etagere();
if (is_array($etagere_autorisations)) {
$autorisations = implode(" ", $etagere_autorisations);
} else {
$autorisations = "1";
}
$myEtagere->autorisations = $autorisations;
$myEtagere->name = $form_etagere_name;
$myEtagere->comment = $form_etagere_comment;
$myEtagere->validite = $form_visible_all;
$myEtagere->validite_date_deb_f = $form_visible_deb;
$myEtagere->validite_date_fin_f = $form_visible_fin;
$myEtagere->validite_date_deb = extraitdate($form_visible_deb);
$myEtagere->validite_date_fin = extraitdate($form_visible_fin);
$myEtagere->visible_accueil = $form_visible_accueil;
$myEtagere->tri = $tri;
$myEtagere->save_etagere();
aff_etagere("edit_etagere", 1);
break;
default:
aff_etagere("edit_etagere", 1);
}
$base_path = "..";
//$base_noheader=1;
$current_alert = "circ";
require_once "../includes/init.inc.php";
require_once "{$base_path}/classes/comptes.class.php";
$cpte = new comptes($id_compte);
if ($cpte->error) {
print $cpte->error_message;
exit;
}
switch ($show_transactions) {
case "2":
$t = $cpte->get_transactions("", "", 0, 0);
break;
case "3":
$date_debut_ = extraitdate($date_debut);
$t = $cpte->get_transactions($date_debut_, "", 0, -1, 0, "asc");
break;
case "1":
default:
$t = $cpte->get_transactions("", "", 0, -1, 10);
break;
}
print "<form name='form_transactions' action='encaissement.php' method='post' onSubmit='return false'>\n<input type='hidden' name='act' value=''/>\n<input type='hidden' name='id_compte' value='" . $id_compte . "'/>\n<input type='hidden' name='show_transactions' value='" . $show_transactions . "'/>\n<input type='hidden' name='date_debut' value='" . htmlentities($date_debut, ENT_QUOTES, $charset) . "'/>\n";
if (!count($t)) {
print $msg["finance_list_tr_no_tr"];
} else {
print "<table width=100%>";
print "<tr>";
print "<th>" . $msg["finance_list_tr_date_enrgt"] . "</th>";
print "<th> </th>";
function detectFormatDate($date_a_convertir, $compl = "01")
{
global $msg;
if (preg_match("#\\d{4}-\\d{2}-\\d{2}#", $date_a_convertir)) {
$date = $date_a_convertir;
} else {
if (preg_match(getDatePattern(), $date_a_convertir)) {
$date = extraitdate($date_a_convertir);
} elseif (preg_match(getDatePattern("short"), $date_a_convertir)) {
$format = str_replace("%", "", $msg["format_date_short"]);
$format = str_replace("-", "", $format);
$format = str_replace("/", "", $format);
$format = str_replace("\\", "", $format);
$format = str_replace(".", "", $format);
$format = str_replace(" ", "", $format);
$format = str_replace($msg["format_date_input_separator"], "", $format);
list($date[substr($format, 0, 1)], $date[substr($format, 1, 1)], $date[substr($format, 2, 1)]) = sscanf($date_a_convertir, $msg["format_date_short_input"]);
if ($date['Y'] && $date['m']) {
$date = sprintf("%04d-%02d-%02s", $date['Y'], $date['m'], $compl);
} else {
$date = "0000-00-00";
}
} elseif (preg_match(getDatePattern("year"), $date_a_convertir, $matches)) {
$date = $matches[0] . "-" . $compl . "-" . $compl;
} else {
$date = "0000-00-00";
}
}
return $date;
}
<?php
// +-------------------------------------------------+
// © 2002-2004 PMB Services / www.sigb.net pmb@sigb.net et contributeurs (voir www.sigb.net)
// +-------------------------------------------------+
// $Id: resa_planning_ajax.inc.php,v 1.1 2011-12-23 11:30:43 dgoron Exp $
if (stristr($_SERVER['REQUEST_URI'], ".inc.php")) {
die("no access");
}
require_once "{$class_path}/resa_planning.class.php";
switch ($sub) {
// Mise à jour de la prévision
case 'update_resa_planning':
if ($id && $date) {
//On vérifie la date
$tresa_date = explode('-', extraitdate($date));
if (strlen($tresa_date[2]) == 1) {
$tresa_date[2] = '0' . $tresa_date[2];
}
if (strlen($tresa_date[1]) == 1) {
$tresa_date[1] = '0' . $tresa_date[1];
}
$date_imp = implode('', $tresa_date);
if (@checkdate($tresa_date[1], $tresa_date[2], $tresa_date[0]) && strlen($date_imp) == 8) {
$r = new resa_planning($id);
$d_resa = implode('-', $tresa_date);
if ($param1 == "1" && $d_resa < $r->resa_date_fin) {
$r->resa_date_debut = $d_resa;
$r->save();
$date_resa = formatdate($r->resa_date_debut);
} else {
