Tiny File Manager

Back Back Up Advanced Editor

<?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 " ";
			$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 ' ';	
		}
		
	} 
	else 
	{
		echo('The array is not empty.');
	}
	
	/*echo " ";
	echo "<pre>";
	print_r($record);
	echo " ";
	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 " ";	
	 
			//$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 " ";	
			
			$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 " ";
			echo "<pre>";
			print_r($record);
			echo " ";
			echo "<pre>";
			echo " ";
			
			/*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 " ";
			echo "<pre>";
			print_r($all_client_month);
			echo " ";
			echo "<pre>";
			echo " ";

$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 " ";
			echo "<pre>";
			print_r($all_client_month_clean);
			echo " ";
			echo "<pre>";
			echo " ";
			
			
			
			/* supprimer les doublons */
			$all_client_month_no_doublons = array_unique($all_client_month_clean);
			echo "Pas de doublons";
			echo " ";
			echo "<pre>";
			print_r($all_client_month_no_doublons);
			echo " ";
			echo "<pre>";
			echo " ";
			
			
			
			return $all_client_month_clean;
			
			
			
}

/* function getClient($annee, $mois , $formule)
{
					
					$connexion = DB(); 
					
					$table = "reservation2022_v3"; //$_SESSION['table_reservation'];
					
					echo " ---> " .$annee ." " .$mois ." " .$formule;
					
					echo " ";

$sql = "SELECT * FROM " .$table ." WHERE annee ='$annee' and mode = 'actif' and formule = '$formule' and mois = '$mois' ";
					echo $sql;
					echo " ";	
	 
					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 " ";	
							
					$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 " ";
				
								// 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 " ";
							echo "<pre>";
							print_r($clientMois);
							echo " ";
							echo "<pre>";
} */