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 {