File "eval01.php"
Full Path: /home/analogde/www/MassageProd/eval01.php
File size: 9.57 KB
MIME-type: text/x-php
Charset: utf-8
<?php
session_start ();
include('database.php');
include('fonctions.php');
include('generation_timing.php');
//error_reporting(0);
DB_connexion();
$annee = 2023;
$mois = "janvier";
$jour = "03-01-2023";
$crenaux = array("seance4");
$client = "DELPY Patrice";
$_SESSION['year'] = $annee;
$_SESSION['table_reservation'] = "reservation2023_v3";
$table = $_SESSION['table_reservation'];
$all_client_month_no_doublons = getClient($annee, $mois , "courte");
// aucunes réservation ???
if (empty($all_client_month_no_doublons))
{
echo('The array is empty.......');
// soit une sceance
// soit deux consécutives
// soit deux espacées
$check_dispo = validationReservation($crenaux[0], $jour);
if($check_dispo == "libre")
{
mysqli_query($connexion, "SET NAMES 'utf8'");
//$sql = "UPDATE " .$table ." SET seance2 = '$client' WHERE rendezvous ='$jour' ";
$sql = "UPDATE " .$_SESSION['table_reservation'] ." SET $crenaux[0] = '$client' WHERE rendezvous ='$jour' ";
echo $sql;
echo "<BR>";
$result = mysqli_query($connexion, $sql );
}
else
{
$val = $tabselectionIndice[$i];
echo "Database mise à jour: Le créneau de " .$array_horaire_court[$val] ." n'est plus disponible !.";
echo '<br>';
}
}
else
{
echo('The array is not empty.');
}
/*echo "<BR>";
echo "<pre>";
print_r($record);
echo "<BR>";
echo "<pre>";*/
function getClient($annee,$mois,$formule)
{
$connexion = DB();
$table = $_SESSION['table_reservation'];
$sql = "SELECT * FROM " .$table ." WHERE annee ='$annee' and mode = 'actif' and formule = '$formule' and mois = '$mois' ";
echo $sql;
echo "<br>";
//$sql="SELECT * FROM " .$mois_actif;
mysqli_query($connexion, "SET NAMES 'utf8'");
$query = mysqli_query($connexion, $sql );
if(!$query)
{ die('Impossible d\'exécuter la requête :' . mysql_error());
}
$nbre_enregistrements = mysqli_num_rows($query);
//echo "Total " .$nbre_enregistrements;
//echo "<br>";
$cpt = 0;
$record = array();
while ($datas = mysqli_fetch_assoc ($query))
{
$tab_client_record = array();
$annee = $datas['annee'];
$mois = $datas['mois'];
$rendezvous = $datas['rendezvous'];
$jour = $datas['jour'];
$seance1 = $datas['seance1'];
$seance2 = $datas['seance2'];
$seance3 = $datas['seance3'];
$seance4 = $datas['seance4'];
$seance5 = $datas['seance5'];
$seance6 = $datas['seance6'];
$seance7 = $datas['seance7'];
$seance8 = $datas['seance8'];
if(strlen($seance1) != 0 && $seance1 != "unselect")
{ //$tab_client[] = $seance1;
$tab_client_record [] = $seance1;
}
if(strlen($seance2) != 0 && $seance2 != "unselect")
{ //$tab_client[] = $seance2;
$tab_client_record [] = $seance2;
}
if(strlen($seance3) != 0 && $seance3 != "unselect")
{ //$tab_client[] = $seance3;
$tab_client_record [] = $seance3;
}
if(strlen($seance4) != 0 && $seance4 != "unselect")
{ //$tab_client[] = $seance4;
$tab_client_record [] = $seance4;
}
if(strlen($seance5) != 0 && $seance5 != "unselect")
{ //$tab_client[] = $seance5;
$tab_client_record [] = $seance5;
}
if(strlen($seance6) != 0&& $seance6 != "unselect")
{ //$tab_client[] = $seance6;
$tab_client_record [] = $seance6;
}
if(strlen($seance7) != 0 && $seance7 != "unselect")
{ //$tab_client[] = $seance7;
$tab_client_record [] = $seance7;
}
if(strlen($seance8) != 0 && $seance8 != "unselect")
{ //$tab_client[] = $seance8;
$tab_client_record [] = $seance8;
}
$record[$cpt] = $tab_client_record ;
$cpt++;
}
echo "Extraction des dates ouvertes sur le mois";
echo "<BR>";
echo "<pre>";
print_r($record);
echo "<BR>";
echo "<pre>";
echo "<BR>";
/*for( $i=0; $i < count($record) ; $i++)
{
$all_client_day = array();
$all_client_day = $record[$i];
for( $j=0; $j < count($all_client_day) ; $j++)
{
$all_client_month[] = $all_client_day[$j];
}
}*/
for( $i=0; $i < count($record) ; $i++)
{
$all_client_day = array();
$all_client_day = $record[$i];
for( $j=0; $j < count($record[$i]) ; $j++)
{
$all_client_month[] = $record[$i][$j];
}
}
echo "Concatenation des clients";
echo "<BR>";
echo "<pre>";
print_r($all_client_month);
echo "<BR>";
echo "<pre>";
echo "<BR>";
$all_client_month_clean = array();
for( $i=0; $i < count($all_client_month) ; $i++)
{
if (strcmp($all_client_month[$i], "creneau fermer") !== 0)
{
$all_client_month_clean[] = $all_client_month[$i];
}
}
echo "Nettoyage creneau fermer";
echo "<BR>";
echo "<pre>";
print_r($all_client_month_clean);
echo "<BR>";
echo "<pre>";
echo "<BR>";
/* supprimer les doublons */
$all_client_month_no_doublons = array_unique($all_client_month_clean);
echo "Pas de doublons";
echo "<BR>";
echo "<pre>";
print_r($all_client_month_no_doublons);
echo "<BR>";
echo "<pre>";
echo "<BR>";
return $all_client_month_clean;
}
/* function getClient($annee, $mois , $formule)
{
$connexion = DB();
$table = "reservation2022_v3"; //$_SESSION['table_reservation'];
echo " ---> " .$annee ." " .$mois ." " .$formule;
echo "<br>";
$sql = "SELECT * FROM " .$table ." WHERE annee ='$annee' and mode = 'actif' and formule = '$formule' and mois = '$mois' ";
echo $sql;
echo "<br>";
mysqli_query($connexion, "SET NAMES 'utf8'");
$query = mysqli_query($connexion, $sql );
if(!$query)
{
die('Impossible d\'exécuter la requête :' . mysql_error());
}
$nbre_dates = mysqli_num_rows($query);
echo "Dates disponibles dans le mois " .$nbre_dates;
echo "<br>";
$clientMois[] = array();
$flag_empty = true;
while ($datas = mysqli_fetch_assoc ($query))
{
$client_seance1 = $datas['seance1'];
$client_seance2 = $datas['seance2'];
$client_seance3 = $datas['seance3'];
$client_seance4 = $datas['seance4'];
$client_seance5 = $datas['seance5'];
$client_seance6 = $datas['seance6'];
$client_seance7 = $datas['seance7'];
$client_seance8 = $datas['seance8'];
echo $client_seance1 ." ".$client_seance2 ." ".$client_seance3 ." ".$client_seance4 ." ".
$client_seance5 ." ".$client_seance6 ." ".$client_seance7 ." ".$client_seance8;
echo "<br>";
// pour supprimer les multiples enregistrements
if(strlen($client_seance1) != 0 && $client_seance1 != "unselect")
{
if( !in_array($client_seance1, $clientMois))
{
$clientMois[] = $client_seance1;
$flag_empty = false;
}
}
if(strlen($client_seance2) != 0 && $client_seance2 != "unselect")
{
if( !in_array($client_seance2, $clientMois))
{
$clientMois[] = $client_seance2;
$flag_empty = false;
}
}
if(strlen($client_seance3) != 0 && $client_seance3 != "unselect")
{
if( !in_array($client_seance3, $clientMois))
{
$clientMois[] = $client_seance3;
$flag_empty = false;
}
}
if(strlen($client_seance4) != 0 && $client_seance4 != "unselect")
{
if( !in_array($client_seance4, $clientMois))
{
$clientMois[] = $client_seance4;
$flag_empty = false;
}
}
if(strlen($client_seance5) != 0 && $client_seance5 != "unselect")
{
if( !in_array($client_seance5, $clientMois))
{
$clientMois[] = $client_seance5;
$flag_empty = false;
}
}
if(strlen($client_seance6) != 0 && $client_seance6 != "unselect")
{
if( !in_array($client_seance6, $clientMois))
{
$clientMois[] = $client_seance6;
}
}
if(strlen($client_seance7) != 0 && $client_seance7 != "unselect")
{
if( !in_array($client_seance7, $clientMois))
{
$clientMois[] = $client_seance7;
}
}
if(strlen($client_seance8) != 0 && $client_seance8 != "unselect")
{
if( !in_array($client_seance8, $clientMois))
{
$clientMois[] = $client_seance8;
}
}
}
echo "<BR>";
echo "<pre>";
print_r($clientMois);
echo "<BR>";
echo "<pre>";
} */
function validationReservation($seance, $jour)
{
$connexion = DB();
$table = $_SESSION['table_reservation'];
$sql = "SELECT * FROM " .$table ." WHERE rendezvous ='$jour' ";
echo "Query confirmation disponible : " .$sql;
echo "<br>";
$result = mysqli_query($connexion, $sql );
$data = mysqli_fetch_assoc($result);
if( $data[$seance] == "" || $data[$seance] == "creneau ouvert" )
{
$action = "libre";
//echo "Libre";
}
else
{
$action = "reserver";
//echo $data[$seance];
}
//echo '<br>';
return($action);
}
?>