1st day of " & iMonth & "/" & iYear & " is a: " & dTemp & "
"
}
/***********************************************************************************/
/***********************************************************************************/
function DateFirstWeekdayFallsOn($iMonth, $iYear, $iWeekdayNumber) {
$dTemp = $iWeekdayNumber - date("w",mktime($iMonth,01,$iYear)); //verifier ces fonctions numero du jour dans la semaine c'est w+
if ($dTemp < 0) $dTemp = 0;
$dTemp = DateAdd("d",$dTemp,$iMonth."/01/".$iYear); // cette fonction est dans i_utils.php
$DateFirstWeekdayFallsOn = $dTemp;
//'response.write "
The 1st " & WeekdayName(iWeekdayNumber) & " of " & iMonth & "/" & iYear & " is on: " & dTemp & "
"
}
/************************************************************************************/
/*****************************upd_events functions*****************************************/
/* Fonctions de upd_events.php */
/******************************************************************************************/
function db_select_edit_Events() {
global $dTmp,$dt_start, $recurring_end, $recurring, $CodeAdmin, $description, $dt_end, $event_id,$tm_start, $tm_end, $event_name, $location, $Organisme, $NomC, $PrenomC, $TelC, $EmailC, $Cout, $Tax, $b_register, $b_personal, $time_start, $recurring_update, $id, $rs,$dt_occur;
$sql = "SELECT ";
$sql.="Events.event_id,";
$sql.="tm_end, ";
$sql.="id, ";
$sql.="recurring_end, ";
$sql.="CodeAdmin, ";
$sql.="event_name, ";
$sql.="location, ";
$sql.="Organisme, ";
$sql.="NomC, ";
$sql.="PrenomC, ";
$sql.="TelC, ";
$sql.="EmailC, ";
$sql.="Cout, ";
$sql.="Tax, ";
$sql.="description,";
$sql.="dt_start, ";
$sql.="tm_start, ";
$sql.="b_personal, ";
$sql.="b_register, ";
$sql.="recurring, ";
$sql.="dt_end, ";
$sql.="dt_occur FROM (Events RIGHT JOIN EventsOccur ON Events.event_id = EventsOccur.event_id) WHERE ";
$sql.="EventsOccur.id = ".to_sql($id,"number")."";
$rs = mysql_query($sql);
if (!$rs) {
echo "Could not successfully run query ($sql) from DB: " .mysql_error();
$b_error = true;
$error_list["select_data_edit_Events"]="The data selection failed. ".mysql_error();
exit;
}elseif (mysql_num_fields($rs)==0) {
$b_results = false;
$msg_list["select_data_edit_Events"]= "Supprimer.";
} elseif ($row = mysql_fetch_assoc($rs)) {
/* if err.number <> 0 then
b_error = true
error_list.add "select_data_edit_Events", "The data selection failed. " & err.description
elseif rs.EOF then
b_results = false
msg_list.add "select_data_edit_Events", "Supprimer."
else */
$tm_end = $row["tm_end"];
$id = $row["id"];
$recurring_end = $row["recurring_end"];
$event_id = $row["event_id"];
$CodeAdmin = $row["CodeAdmin"];
$event_name = $row["event_name"];
$location = $row["location"];
$Organisme = $row["Organisme"];
$NomC = $row["NomC"];
$PrenomC = $row["PrenomC"];
$TelC = $row["TelC"];
$EmailC = $row["EmailC"];
$Cout = $row["Cout"];
$Tax = $row["Tax"];
$b_register = $row["b_register"];
$description = $row["description"];
$dt_start = $row["dt_start"];
$tm_start = $row["tm_start"];
$b_personal = $row["b_personal"];
$recurring = $row["recurring"];
$dt_occur = $row["dt_occur"];
$dt_end= $row["dt_end"];
//$recurring_update = $row["recurring_update"]; //c'est moi qui l'ai enlevé car il n'existe pas comme index dans la requete (a voir)
}
mysql_free_result($rs);
// on error goto 0
}
/******************************************************************************/
function validate_time() {
global $dTmp,$dt_start, $recurring_end, $recurring, $CodeAdmin, $description, $dt_end, $event_id,$tm_start, $tm_end, $event_name, $location, $Organisme, $NomC, $PrenomC, $TelC, $EmailC, $Cout, $Tax, $b_register, $b_personal, $b_error;
// '*******validation des entree**************
if ($b_error==true)
If ((is_nan((float)$Cout)) AND (Cout <> "")){
$error_list["startendtime"]="Entrer un numero dans le Coût";
$b_error = true;
}
//'********valide heures**********************
if ((empty($tm_start)) || (empty($tm_end))) {
$error_list["startendtime"]= "Les heures de location et la date sont obligatoires";
$b_error = true;
}
if ((empty($_REQUEST["moisd"])) || (empty($_REQUEST["jourd"])) || (empty($_REQUEST["anneed"]))) {
$error_list["starttime"]="Entrer la date de location .";
$b_error = true;
}
//':: requests and validates event start and end time
if (strlen($tm_start) > 0) $tm_start = $tm_start.":".$_REQUEST["minute_start"];
if (strlen($tm_end) > 0) $tm_end = $tm_end.":".$_REQUEST["minute_end"];
if (strlen($tm_end) > 0) {
$debut = "07:00"; // 07 AM
if ((TimeValue($tm_start) < TimeValue($debut)) or (TimeValue($tm_end) < TimeValue($debut)) or (TimeValue($tm_start) > TimeValue($tm_end))) {
$error_list["startendtime"]= "l'heure de réservation doit être entre 7h et 23h.";
$b_error = true;
}
if ((isset($dt_end))AND (strtotime($dt_start)==strtotime($dt_end)) AND (TimeValue($tm_start) > TimeValue($tm_end))) {
$error_list["startendtime"]= "Heure de fin (".$tm_end.") n'est pas aprés l'heure de début (".$tm_start.")";
$b_error = true;
}
}
$tm_start="1899-12-30 ".$tm_start.":00"; //tm_start et tm_end doivent etre tjs au
$tm_end="1899-12-30 ".$tm_end.":00"; //format "1899-12-30 yyyy-mm-jj"
}
/**************************************************************************************/
function validate_reservation() {
global $dt_start, $dt_end, $recurring_end, $recurring,$location,$tm_start,$tm_end,$event_id,$dTmp, $b_error, $msg_list;
$blnReservation = false;
$dTmp=$dt_start; echo "ligne 354********** dTmp=".$dTmp;
$exit=false;
for ($j = 1; $j < 300; $j++) {
if (strtotime($dTmp) <= strtotime($recurring_end)) {
$blnReservation=verification($location,$tm_start,$tm_end,$dTmp); // avoir
if ($blnReservation) {
$msg_list["startendtime"]="Le local n'est pas disponible de ".substr(TimePart($tm_start),0, 5)." à ".substr(TimePart($tm_end),0,5).".";
$b_error = true;
}
}else {
$exit=true;
}
if($exit) break;
if ($recurring == 0) $dTmp = dateadd("d",1,$dTmp);
elseif ($recurring < 30) $dTmp = dateadd("d",$recurring,$dTmp);
elseif ($recurring == 30) $dTmp = dateadd("m",1,$dTmp);
else $dTmp = dateadd("yyyy",$recurring,$dTmp);
}
}
/***************************************************************************************/
function validate_Update() {
global $dTmp,$dt_start, $recurring_end, $recurring, $CodeAdmin, $description, $dt_end, $event_id,$tm_start, $tm_end, $event_name, $location, $Organisme, $NomC, $PrenomC, $TelC, $EmailC, $Cout, $Tax, $b_register, $b_personal, $b_error;
//'********************************
$blnReservation = false;
$exit=false;
$dTmp = datevalue($dt_start);
for ($j = 1; $j<300; $j++) {
if ((strtotime($dTmp) - strtotime($recurring_end))<=0) { //comparer deux dates
/*********************************Autre probleme ici*******************************/
$blnReservation=verificationUpdate($location,$tm_start,$tm_end,$dTmp,$event_id);
/**************************************************************************************/
if ($blnReservation == true) {
$error_list["startendtime"]="Le local n'est pas disponible. (".$tm_start."),(".$tm_end.")";
$b_error = true;
}
}else{
$exit=true;
}
if($exit) break;
if ($recurring == 0)
$dTmp = dateadd("d",1,$dTmp);
elseif ($recurring < 30) $dTmp = dateadd("d",$recurring,$dTmp);
elseif ($recurring == 30) $dTmp = dateadd("m",1,$dTmp);
else $dTmp = dateadd("Y",1,$dTmp);
}
}
/**************************************************************************************/
function add_eventoccurs() {
global $dTmp,$dt_start, $recurring_end, $recurring, $CodeAdmin, $description, $dt_end, $event_id,$tm_start, $tm_end, $event_name, $location, $Organisme, $NomC, $PrenomC, $TelC, $EmailC, $Cout, $Tax, $b_register, $b_personal;
// '*******************************
$exit=false;
$dTmp = $dt_start; //supposé etre datevalue($dt_start)
$dTmpU=tomktime($dTmp);
$recurring_endU=tomktime($recurring_end);
for ($i = 1; $i<300; $i++) {
if ($dTmpU <= $recurring_endU){
$b_register=0;
$alert=0;
$dTmp=date("Y-n-j",$dTmpU);
$dTmp=$dTmp." 00:00:00";
$sql="INSERT INTO eventsoccur ";
$sql.="VALUES (";
$sql.="NULL,"; //pour generer un ID autoincrement
$sql.="$event_id,";
$sql.="'".$dTmp."', ";
$sql.="'".$tm_start."', ";
$sql.="'".$tm_end."', ";
$sql.="'".$event_name."', ";
$sql.="'".$description."', ";
$sql.="".$location.", ";
$sql.="".$Organisme.", ";
$sql.="'".$NomC."', ";
$sql.="'".$PrenomC."', ";
$sql.="'".$TelC."', ";
$sql.="'".$EmailC."', ";
$sql.="'".$Cout."', ";
$sql.="$Tax, ";
$sql.="$b_register,";
$sql.="$alert)";
mysql_query($sql)
or DIE ("Could not perform Insert to table ".mysql_errno().": ".mysql_error());
}else
$exit=true;
if ($exit) break;
if ($recurring == 0) // A voir ici le dateadd
$dTmpU = dateadd("d",1,$dTmpU);
elseif ($recurring < 30)
$dTmpU = dateadd("d",$recurring,$dTmpU);
elseif ($recurring == 30)
$dTmpU = dateadd("m",1,$dTmpU);
else $dTmpU = dateadd("Y",1,$dTmpU);
}
}
/**************************************************************************************/
function request_edit_events() {
global $dTmp,$dt_start, $recurring_end, $recurring, $CodeAdmin, $description, $dt_end, $event_id,$tm_start, $tm_end, $event_name, $location, $Organisme, $NomC, $PrenomC, $TelC, $EmailC, $Cout, $Tax, $b_register, $b_personal, $b_error;
//''' request form inputs from this form
if (isset($_REQUEST["tm_end"])) $tm_end = $_REQUEST["tm_end"];
// else $tm_end= "";
if (isset($_REQUEST["id"])) $id = $_REQUEST["id"];
//else $id= "";
//'recurring_end = request("recurring_end")
if (($_POST["moisend"]<> "") && ($_POST["jourend"] <> "") && ($_POST["anneeend"]<> ""))
$recurring_end = $_REQUEST["moisend"]."/".$_REQUEST["jourend"]."/".$_REQUEST["anneeend"];
$event_id = $_REQUEST["event_id"];
$CodeAdmin = $_REQUEST["CodeAdmin"];
$event_name = $_REQUEST["event_name"];
$location = $_REQUEST["location"];
$Organisme = $_REQUEST["Organisme"];
$NomC = $_REQUEST["NomC"];
$PrenomC = $_REQUEST["PrenomC"];
$TelC = $_REQUEST["TelC"];
$EmailC = $_REQUEST["EmailC"];
$Cout = $_REQUEST["Cout"];
$Tax = $_REQUEST["Tax"];
$b_register = NULL;
$description = $_REQUEST["description"];
//'dt_start = $_REQUEST["dt_start")
if (($_POST["moisd"] <> "") && ($_POST["jourd"] <> "") && ($_POST["anneed"]<> ""))
$dt_start = $_REQUEST["anneed"]."-".$_REQUEST["moisd"]."-".$_REQUEST["jourd"];
$tm_start = $_REQUEST["tm_start"];
$b_personal = $_REQUEST["b_personal"];
$recurring = $_REQUEST["recurring"];
$dt_occur = $_REQUEST["dt_occur"];
// $recurring_update = $_REQUEST["recurring_update"];
}
/****************************************************************************************/
function validate_edit_events() {
global $dTmp,$dt_start, $recurring_end, $recurring, $CodeAdmin, $description, $dt_end,
$event_id,$tm_start, $tm_end, $event_name, $location, $Organisme, $NomC, $PrenomC, $TelC,
$EmailC, $Cout, $Tax, $b_register, $b_personal, $b_error;
//''' request and validate data entered from this form
$b_error=false;
$id= trim($_REQUEST["id"]);
if (($_POST["moisend"]<> "") && ($_POST["jourend"] <> "") && ($_POST["anneeend"]<> ""))
$recurring_end = trim($_REQUEST["anneeend"]."-".$_REQUEST["moisend"]."-".$_REQUEST["jourend"]);
$event_id= trim($_REQUEST["event_id"]);
if (isset($_REQUEST["CodeAdmin"]))
$CodeAdmin= trim($_REQUEST["CodeAdmin"]);
if ($CodeAdmin == "") {
$error_list["661037"]="Le code est obligatoire.";
$b_error = true;
}
$event_name= trim($_REQUEST["event_name"]);
if ($event_name == "") {
$error_list["661038"]="Le titre est obligatoire.";
$b_error = true;
}
if (isset($_REQUEST["location"]))
$location = trim($_REQUEST["location"]);
if (isset($_REQUEST["event_name"]))
$event_name = trim($_REQUEST["event_name"]);
if (isset($_REQUEST["Organisme"]))
$Organisme = trim($_REQUEST["Organisme"]);
else $Organisme="";
if (isset($_REQUEST["NomC"]))
$NomC = trim($_REQUEST["NomC"]);
else $NomC="";
if (isset($_REQUEST["PrenomC"]))
$PrenomC = trim($_REQUEST["PrenomC"]);
else $PrenomC="";
if (isset($_REQUEST["EmailC"]))
$EmailC = trim($_REQUEST["EmailC"]);
else $EmailC="";
if (isset($_REQUEST["TelC"]))
$TelC = trim($_REQUEST["TelC"]);
else $TelC="";
if (isset($_REQUEST["Tax"]))
$Tax = trim($_REQUEST["Tax"]);
else $Tax="";
if (isset($_REQUEST["Cout"]))
$Cout = trim($_REQUEST["Cout"]);
else $Cout="";
if (isset($_REQUEST["description"]))
$description = trim($_REQUEST["description"]);
else $description="";
if (isset($_REQUEST["b_register"])) /*********stop********/
$b_register = trim($_REQUEST["b_register"]);
else $b_register="";
if (($_POST["moisd"]<> "") && ($_POST["jourd"] <> "") && ($_POST["anneed"]<> ""))
$dt_start = trim($_REQUEST["anneed"]."-".$_REQUEST["moisd"]."-".$_REQUEST["jourd"]);
if ($dt_start == "") {
$error_list["661040"]="La date de début est obligatoire..";
$b_error = true;
}
$b_personal = trim($_REQUEST["b_personal"]);
$recurring = trim($_REQUEST["recurring"]);
$dt_occur = trim($_REQUEST["dt_occur"]);
if (isset($_REQUEST["recurring_update"]))
$recurring_update = trim($_REQUEST["recurring_update"]);
else $recurring_update="";
}
/********************************************************************************************/
function get_defaults_edit_events() {
//''' set default values for this form
if (isset($_REQUEST["incDate"]))
$dt_start = "".$_REQUEST["incDate"]."";
else $dt_start = "";
$b_personal = 0;
$recurring_update = "0";
}
/*******************************************************************************************/
/***********************************************************************************/
function db_insert_edit_Events() {
global $dt_start, $dt_end,$event_id, $recurring_end, $recurring,$CodeAdmin,$b_personal,$location, $msg_list;
if (!isset($dt_end)) {
$sql = "INSERT INTO Events (";
$sql.="CodeAdmin,";
$sql.="dt_start,";
$sql.="recurring,";
$sql.="recurring_end,";
$sql.="b_personal";
$sql.=") VALUES (".$CodeAdmin.",";
$sql.="'".$dt_start."',";
$sql.="'".$recurring."',";
$sql.="'".$recurring_end."',";
$sql.="'".$b_personal."')";
}
else {
$sql = "INSERT INTO Events (";
$sql.="CodeAdmin,";
$sql.="dt_start,";
$sql.="dt_end,";
$sql.="recurring,";
$sql.="recurring_end,";
$sql.="b_personal";
$sql.=") VALUES (".$CodeAdmin.",";
$sql.="'".$dt_start."',";
$sql.="'".$dt_end."',";
$sql.="'".$recurring."',";
$sql.="'".$recurring_end."',";
$sql.="'".$b_personal."')";
}
//'response.write sql
//on error resume next
mysql_query($sql)
or DIE ("Could not perform INSERT to table ".mysql_errno().": ".mysql_error());
if (mysql_errno()) {
echo "Could not successfully run query ($sql) from DB: " . mysql_error();
exit;
}
else {
$rs = mysql_query("SELECT @@IDENTITY");
if ($row = mysql_fetch_row($rs)){
$event_id = $row[0];
}
mysql_free_result($rs);
$msg_list["db_insert_edit_Events"]="Réservation ajoutée.";
}
}
/*******************************************************************************/
function db_update_edit_Events() {
global $dTmp,$dt_start, $recurring_end, $recurring, $CodeAdmin, $description, $dt_end, $event_id,$tm_start, $tm_end, $event_name, $location, $Organisme, $NomC, $PrenomC, $TelC, $EmailC, $Cout, $Tax, $b_register, $b_personal, $b_error;
$b_personal=0;
$dt_start=datevalue($dt_start)." 00:00:00";
//request_edit_events();
$sql ="UPDATE Events SET ";
$sql.="CodeAdmin = ".$CodeAdmin.", ";
$sql.="dt_start ='".$dt_start."', ";
$sql.="dt_end = '".$dt_end."', ";
$sql.="recurring = '".$recurring."', ";
$sql.="recurring_end = '".$recurring_end."', ";
$sql.="b_personal = ".$b_personal." WHERE ";
$sql.="event_id = ".$event_id."";
mysql_query($sql) or DIE ("Could not perform UPDATE to table ".mysql_errno().": ".mysql_error());
}
/*******************************************************************************/
function db_delete_edit_Events() {
global $dTmp,$dt_start, $recurring_end, $recurring, $CodeAdmin, $description, $dt_end, $event_id,$tm_start, $tm_end, $event_name, $location, $Organisme, $NomC, $PrenomC, $TelC, $EmailC, $Cout, $Tax, $b_register, $b_personal, $b_error, $id, $msg_list;
$sql = "DELETE FROM EventsOccur";
$sql.=" WHERE ";
$sql.="id = ".$id."";
//'response.write sql
//on error resume next
mysql_query($sql)
or DIE ("Could not perform DELETE to table ".mysql_errno().": ".mysql_error());
if (mysql_errno()) {
echo "Could not successfully run query ($sql) from DB: " . mysql_error();
exit;
}
else
$msg_list["db_delete_edit_Events"]="Le champ a été supprimé.";
}
/****************************fonctions verification.php**********************************/
function verification($salleid,$hhdebut,$hhfin,$dTmp) {
$blnReserve=false;
$blnLoop=false;
if ($hhdebut <> "") {
$H_debut = strtotime(TimePart($hhdebut));
}
if ($hhfin <> "")
$H_fin = strtotime(TimePart($hhfin));
echo "ligne 738 dTmp=".$dTmp;
$partie_dTmp = explode("-", $dTmp);
$dTmp=$dTmp." 00:00:00";
$jour= $partie_dTmp[2];
$mois= $partie_dTmp[1]; // mon ajout
$annee= $partie_dTmp[0];
$strSQL = "SELECT * FROM eventsoccur WHERE ((UNIX_TIMESTAMP(dt_occur)=".strtotime($dTmp).") AND (location = ".(int)$salleid."))";
$rs = mysql_query($strSQL);
if (!$rs) {
echo "Could not successfully run query ($strSQL) from DB: ".mysql_error();
exit;
}
$blnLoop=false;
while ($row = mysql_fetch_assoc($rs)) {
If ((($H_debut >= strtotime(TimePart($row["tm_start"]))) AND ($H_fin <= strtotime(TimePart($row["tm_end"])))) OR (( $H_debut >= strtotime(TimePart($row["tm_start"]))) AND ($H_debut < strtotime(TimePart($row["tm_end"])))) OR (( $H_debut < strtotime(TimePart($row["tm_start"]))) AND ($H_fin >strtotime(TimePart($row["tm_start"]))))) {
$blnReserve=true;
$blnLoop=true;
}
if ($blnLoop) break;
}
mysql_free_result($rs);
$verification=$blnReserve;
return($verification);
}
//********************************************************************************/
function verificationUpdate($salleid,$hhdebut,$hhfin,$dTmp,$event_id) {
$blnReserve=false;
$blnLoop=false;
$hhdebut=$hhdebut.":00";
$hhfin=$hhfin.":00";
$H_debut = strtotime($hhdebut);
$H_fin = strtotime($hhfin);
$strSQL = "SELECT * FROM eventsoccur WHERE ((LEFT(dt_occur,10) = '".$dTmp."') AND (event_id <> ".$event_id.") AND (location=".(int)$salleid."))";
$rs = mysql_query($strSQL);
if (!$rs) {
echo "Could not successfully run query ($strSQL) from DB: " .mysql_error();
exit;
}
$blnLoop=false;
while ($row = mysql_fetch_assoc($rs)) {
If (($H_debut >= strtotime(TimePart($row["tm_start"]))) AND ($H_fin <= strtotime(TimePart($row["tm_end"]))) OR ( $H_debut >= strtotime(TimePart($row["tm_start"]))) AND ($H_debut < strtotime(TimePart($row["tm_end"]))) OR ( $H_debut < strtotime(TimePart($row["tm_start"]))) AND ($H_fin > strtotime(TimePart($row["tm_start"])))) {
$blnReserve=true;
$blnLoop=true;
}
if ($blnLoop) exit;
}
mysql_free_result($rs);
$verificationUpdate=$blnReserve;
return($verificationUpdate);
}
/**************************************************************************************/
?>