Tiny File Manager

Back Back Up Advanced Editor

<?php

session_start ();
	if (!isset($_SESSION['nom']) && !isset($_SESSION['password']))
	{  
			header("Location: login.php");   
	}

error_reporting(0);
	
	include('database.php');
	include('fonctions.php');
	//include('outlook03.php');
	
	include('test_calendar06.php');
	//include('outlook_calendar.php');
	
	DB_connexion(); 
	header( 'content-type: text/html; charset=utf-8' );

$seance_choix = "";
	$message = "";
	$table = $_SESSION['table_reservation'];

$annee = date('Y');
	
	if(isset($_GET['mois']) && isset($_GET['jour']))
	{
		$formule = $_GET['formule'];
		$mois = $_GET['mois'];
		$jour = $_GET['jour'];
	}	
	
	if(isset($_POST['submit']))
	{
	
		if(isset($_POST['annule']) && $_POST['annule'] == "annuler")
		{
				header("Location:  affiche_planning02.php?mois=$mois");   
		}
	
		if(isset($_POST['verrou']) && $_POST['verrou'] == "ok")
		{	
		
				//$annee = date('Y');
				//$table = "reservation_dev" .$annee;
				
				if( $_SESSION['nom'] == "admin")
				{	$client = $_POST['client'];	
					$sql = "SELECT * FROM client WHERE nom ='admin' ";	
					$result = mysqli_query($connexion, $sql );	
					$data = mysqli_fetch_assoc($result);
					$msg = "";
				}
		
				if( $_SESSION['nom'] != "admin")
				{	$nom = $_SESSION['nom'];	
					$prenom = $_SESSION['prenom'];	
					$client = $nom .' ' .$prenom; 				
					$sql = "SELECT * FROM client WHERE nom ='$nom' and prenom ='$prenom' ";	
					mysqli_query($connexion, "SET NAMES 'utf8'");	
					$result = mysqli_query($connexion, $sql );	
					$data = mysqli_fetch_assoc($result);
					$msg = "";
				}
				
				//echo '<pre>';
				//echo print_r($data);
				
				$sql = "SELECT * FROM " .$table  ." WHERE rendezvous ='$jour'";	
				$result = mysqli_query($connexion, $sql );
				$data = mysqli_fetch_assoc($result);
				
				//echo '<pre>';
				//echo print_r($data);
				
				//print_r($_POST['options']);
				//echo '<br>';		
				
				$options_text = implode(', ',$_POST['options']);
								
				$tab_horaire = array();
				$tab_position = array();
				$tab_position = tableau_seance($mois,$jour);
				
				//echo '<pre>';
				//echo print_r($tab_position);
				//echo '<br>';		
				
				$reponse = strpos($options_text,"seance1");
				if(strlen($reponse) != 0)
				{	//echo "seance1";
					//echo "<br>";
					$check_dispo = disponible("seance1", $jour);
					if($check_dispo == "libre")
					{
						mysqli_query($connexion, "SET NAMES 'utf8'");	
						$sql = "UPDATE " .$table ." SET seance1 = '$client' WHERE rendezvous ='$jour' ";
						//echo $sql;
						$result = mysqli_query($connexion, $sql );	
						$msg .= "12H00 ";
						$tab_horaire[] = "12H00";
						$val = 1;
						if($tab_position[$val] == "normale")
						{
							mode_normal($jour);
						}	
						if($tab_position[$val] == "etendu")
						{
							mode_etendu($jour);
						}	
						$seance_choix = "1";
						sauvegarde_table_gestion($annee,$mois,$jour,$client,$seance_choix,$formule);
					}
					else
					{ 
						echo "Database mise à jour: Le créneau de 12H00 n'est plus disponible !.";
						echo '<br>';		
					}		
				}
				
				
				$reponse = strpos($options_text,"seance2");
				if(strlen($reponse) != 0)
				{	//echo "seance2";
					//echo "<br>";
					$check_dispo = disponible("seance2", $jour);
					if($check_dispo == "libre")
					{
						mysqli_query($connexion, "SET NAMES 'utf8'");	
						$sql = "UPDATE " .$table ." SET seance2 = '$client' WHERE rendezvous ='$jour' ";
						//echo $sql;
						$result = mysqli_query($connexion, $sql );	
						$msg .= "12H30 ";
						$tab_horaire[] = "12H30";
						$val = 2;
						if($tab_position[$val] == "normale")
						{
							mode_normal($jour);
						}	
						if($tab_position[$val] == "etendu")
						{
							mode_etendu($jour);
						}	
						$seance_choix = "2";
						sauvegarde_table_gestion($annee,$mois,$jour,$client,$seance_choix,$formule);
					}
					else
					{ 
						echo "Database mise à jour: Le créneau de 12H30 n'est plus disponible !.";
						echo '<br>';		
					}		
	
				}
					
				
				$reponse = strpos($options_text,"seance3");
				if(strlen($reponse) != 0)
				{	//echo "seance3";
					//echo "<br>";
					$check_dispo = disponible("seance3", $jour);
					if($check_dispo == "libre")
					{
						mysqli_query($connexion, "SET NAMES 'utf8'");	
						$sql = "UPDATE " .$table ." SET seance3 = '$client' WHERE rendezvous ='$jour' ";
						//echo $sql;
						$result = mysqli_query($connexion, $sql );	
						$msg .= "13H ";
						$tab_horaire[] = "13H";
						$val = 3;
						if($tab_position[$val] == "normale")
						{
							mode_normal($jour);
						}	
						if($tab_position[$val] == "etendu")
						{
							mode_etendu($jour);
						}	
						$seance_choix = "3";
						sauvegarde_table_gestion($annee,$mois,$jour,$client,$seance_choix,$formule);
					}
					else
					{ 
						echo "Database mise à jour: Le créneau de 13H00 n'est plus disponible !.";
						echo '<br>';		
					}		
				}
				
				
				$reponse = strpos($options_text,"seance4");
				if(strlen($reponse) != 0)
				{	//echo "seance4";
					//echo "<br>";
					$check_dispo = disponible("seance4", $jour);
					if($check_dispo == "libre")
					{
						mysqli_query($connexion, "SET NAMES 'utf8'");	
						$sql = "UPDATE " .$table ." SET seance4 = '$client' WHERE rendezvous ='$jour' ";
						//echo $sql;
						$result = mysqli_query($connexion, $sql );	
						$msg .= "13H30 ";
						$tab_horaire[] = "13H30";
						$val = 4;
						if($tab_position[$val] == "normale")
						{
							mode_normal($jour);
						}	
						if($tab_position[$val] == "etendu")
						{
							mode_etendu($jour);
						}	
						$seance_choix = "4";
						sauvegarde_table_gestion($annee,$mois,$jour,$client,$seance_choix,$formule);
					}
					else
					{ 
						echo "Database mise à jour: Le créneau de 13H30 n'est plus disponible !.";
						echo '<br>';		
					}							
				}
				
				
				$reponse = strpos($options_text,"seance5");
				if(strlen($reponse) != 0)
				{	//echo "seance5";
					//echo "<br>";
					$check_dispo = disponible("seance5", $jour);
					if($check_dispo == "libre")
					{
						mysqli_query($connexion, "SET NAMES 'utf8'");	
						$sql = "UPDATE " .$table ." SET seance5 = '$client' WHERE rendezvous ='$jour' ";
						//echo $sql;
						$result = mysqli_query($connexion, $sql );	
						$msg .= "14H00 ";
						$tab_horaire[] = "14H00";
						$val = 5;
						if($tab_position[$val] == "normale")
						{
							mode_normal($jour);
						}	
						if($tab_position[$val] == "etendu")
						{
							mode_etendu($jour);
						}	
						$seance_choix = "5";
						sauvegarde_table_gestion($annee,$mois,$jour,$client,$seance_choix,$formule);
					}
					else
					{ 
						echo "Database mise à jour: Le créneau de 14H00 n'est plus disponible !.";
						echo '<br>';		
					}							
				}
				
				
				$reponse = strpos($options_text,"seance6");
				if(strlen($reponse) != 0)
				{	//echo "seance6";
					//echo "<br>";
					$check_dispo = disponible("seance6", $jour);
					if($check_dispo == "libre")
					{
						mysqli_query($connexion, "SET NAMES 'utf8'");	
						$sql = "UPDATE " .$table ." SET seance6 = '$client' WHERE rendezvous ='$jour' ";
						//echo $sql;
						$result = mysqli_query($connexion, $sql );	
						$msg .= "14H30 ";
						$tab_horaire[] = "14H30";
						$val = 6;
						if($tab_position[$val] == "normale")
						{
							mode_normal($jour);
						}	
						if($tab_position[$val] == "etendu")
						{
							mode_etendu($jour);
						}	
						$seance_choix = "6";
						sauvegarde_table_gestion($annee,$mois,$jour,$client,$seance_choix,$formule);
					}
					else
					{ 
						echo "Database mise à jour: Le créneau de 14H30 n'est plus disponible !.";
						echo '<br>';		
					}							
				}
				
				
				$reponse = strpos($options_text,"seance7");
				if(strlen($reponse) != 0)
				{	//echo "seance7";
					//echo "<br>";
					$check_dispo = disponible("seance7", $jour);
					if($check_dispo == "libre")
					{
						$sql = "UPDATE ".$table ." SET	seance7 = '$client' WHERE rendezvous ='$jour' ";
						//echo $sql;
						mysqli_query($connexion, "SET NAMES 'utf8'");	
						$result = mysqli_query($connexion, $sql );	
						$msg .= "15H00 ";
						$tab_horaire[] = "15H00";
						$val = 7;
						if($tab_position[$val] == "normale")
						{
							mode_normal($jour);
						}	
						if($tab_position[$val] == "etendu")
						{
							mode_etendu($jour);
						}	
						$seance_choix = "7";
						sauvegarde_table_gestion($annee,$mois,$jour,$client,$seance_choix,$formule);
					}
					else
					{ 
						echo "Database mise à jour: Le créneau de 15H00 n'est plus disponible !.";
						echo '<br>';		
					}							
				}
			
				
				$reponse = strpos($options_text,"seance8");
				if(strlen($reponse) != 0)
				{	//echo "seance8";
					//echo "<br>";
					$check_dispo = disponible("seance8", $jour);
					if($check_dispo == "libre")
					{
						$sql = "UPDATE ".$table ." SET	seance8 = '$client' WHERE rendezvous ='$jour' ";
						//echo $sql;
						mysqli_query($connexion, "SET NAMES 'utf8'");	
						$result = mysqli_query($connexion, $sql );	
						$msg .= "15H30 ";
						$tab_horaire[] = "15H30";
						$val = 8;
						if($tab_position[$val] == "normale")
						{
							mode_normal($jour);
						}	
						if($tab_position[$val] == "etendu")
						{
							mode_etendu($jour);
						}	
						$seance_choix = "8";
						sauvegarde_table_gestion($annee,$mois,$jour,$client,$seance_choix,$formule);
					}
					else
					{ 
						echo "Database mise à jour: Le créneau de 15H30 n'est plus disponible !.";
						echo '<br>';		
					}							
				}
				
			
				if($check_dispo == "libre")
				{
					// recherche l'adresse email du client
					$decompose = explode(" ", $client);
					$nom = $decompose[0]; 
					$prenom = $decompose[1]; 
				
					$sql = "SELECT * FROM client WHERE nom ='$nom' AND prenom ='$prenom' ";	
					//echo $sql;
					$result = mysqli_query($connexion, $sql );	
					$data = mysqli_fetch_assoc($result);
				
					nouvelle_allocation($mois);
					//allocation($mois);
				
					$str = implode(",", $tab_horaire);
					
//					Patrice  					prenom
//					Patrice.Delpy@onsemi.com	$data['email']; 
//					07-11-2017					$jour	
//					14H30						$str
								
					//echo "Confirmation: "  .$client ." vient de réserver " .count($_POST['options']) . " créneau(x)" .' - ' .$str . " pour le " .$jour;
				
					$site = $_SERVER["SERVER_NAME"];
					if( $site != "localhost" ) //|| ($site != "127.0.0.1") ) 
					{
						//$mode_debug = $_SESSION['mode_debug'];
						//if($mode_debug == "no")
						//{
							outlook($prenom, $data['email'] , $jour, $str, "longue");
														
							echo "Email en cours d'envoie ...";

}
					else
					{
						echo "Mode localhost";
					}
				}
				
				$message = "ok";
				
				//if($mode_debug == "no")
				//{
					header ("Refresh: 5;URL=affiche_planning02.php?mois=$mois"); 
				//}
				///////////////////////////////////////header("Location: affiche_planning.php?mois=$mois");
				
				
		}
	}
?>

<style>

.css_message {	width: 900px;
				border-style: solid;
				border-width: 1px;
				border-color: #1c75c8;
				padding: 3px; 
				background-color: #c5ddf6; 
			}

.ui-widget-overlay {
  background: #000;
}
</style>

function test()
{
var nbreMillisec = 5000;
setTimeout("test();", nbreMillisec);
window.location.reload()

}
//test();

function auto_refresh(interval) {
	setTimeout("location.reload(true);",interval);
}

function annuler()
{
	//window.history.go(-1);
	//window.location = "http://www.yoururl.com";
	
	document.getElementById('annule').value="annuler";
	
}
</script>

</head>

<body>

<div id='cssmenu'>
	<ul>
		<li><a href='home.php'><span>Home</span></a></li>
		<li class="active"><a href='selection_planning_mois.php'><span>Planning</span></a></li>
		<li><a href='selection_gestion_mois.php'><span>Gestion</span></a></li>
		<li><a href='selection_statistique_mois.php'><span>Statistiques</span></a></li>
<?php
		if($_SESSION['nom'] == "admin")
		{ 	
			echo '<li><a href="deplacer_un_rendezvous_admin.php"><span>Déplacer</span></a></li>';
			echo '<li><a href="configuration.php"><span>Configuration</span></a></li>';
		}
		else
		{
			echo '<li><a href="deplacer_un_rendezvous_user.php"><span>Déplacer</span></a></li>';
		}
?>
		<li><a href='change_password.php'><span>Changer password</span></a></li>
		<li><a href='logout.php'><span>Déconnexion</span></a></li>
		<li><a href='#'><span><?php echo $_SESSION['nom'] .' ' .$_SESSION['prenom'] .' connecté' ?></span></a></li>
		<li><a href='#'><span><?php echo $_SESSION['year']; ?></span></a></li>
	</ul>
	</div>
	<br>
	<br>

<form action="#" name ="form_inscription" method="post">
	<input type="hidden" name="verrou" id="verrou" value="">
	<input type="hidden" name="annule" id="annule" value="">
<?php
////////////////  affichage de la liste de selection des utilisateurs seulement pour le mode administrateur
	if($_SESSION['nom'] == "admin")
	{	
		echo '<select size = "10" STYLE="width:300" id = "champ_client" name="client">';

$sql = 'SELECT * FROM client';
		mysqli_query($connexion, "SET NAMES 'utf8'");
		$result = mysqli_query($connexion, $sql );
		$tab_nom = array();
		$tab_prenom = array();
	
		$ptr = 0;
			
		while ($data = mysqli_fetch_assoc ($result))
		{
			if(strlen($data['prenom']) != 0)
			{
				$tab_nom[$ptr] = $data['nom'];
				$tab_prenom[$ptr] = $data['prenom'];
				$ptr = $ptr + 1;
			}	
		}

for( $i=0; $i < count($tab_nom) ; $i++)
		{
			$tmp = $tab_nom[$i] . " " .$tab_prenom[$i];
			echo '<option value="' .$tmp. '">' .$tmp. '</option>';
		}

echo '</select>
			  <br><br>';
			  
	}
///////////////////////////////////////	
	
	echo 'Réservation pour le : ' .$jour .'<br>';
	
	$annee = date('Y');
	//$table = "reservation_dev" .$annee;
	$sql = "SELECT * FROM " .$table  ." WHERE rendezvous ='$jour' ";	
	//echo $sql;
	$result = mysqli_query($connexion, $sql );
	$n = mysqli_num_rows($result);	
	$data = mysqli_fetch_assoc($result);
	
	$item1 = "";
	$item2 = "";
	$item3 = "";
	$item4 = "";
	$item5 = "";
	$item6 = "";
	$item7 = "";
	$item8 = "";
	
	echo '<br>';
	
	//if(strlen($data['seance1']) == 0)
	if($data['seance1'] =='' || $data['seance1'] == 'creneau ouvert' )
	{	$item1 = "libre";
		echo '<input type="checkbox" id ="id1" name="options[]" value="seance1">12H00';
	}	
	else
	{  $item1 = "pris";
	}
	
	//if(strlen($data['seance2']) == 0)
	if($data['seance2'] =='' || $data['seance2'] == 'creneau ouvert' )
	{	$item2 = "libre";
		echo '<input type="checkbox" id ="id2" name="options[]" value="seance2">12H30';
	}	
	else
	{  $item2 = "pris";
	}
	
	//if(strlen($data['seance3']) == 0)
	if($data['seance3'] =='' || $data['seance3'] == 'creneau ouvert' )
	{	$item3 = "libre";
		echo '<input type="checkbox" id ="id3" name="options[]" value="seance3">13H';
	}	
	else
	{  $item3 = "pris";
	}

//if(strlen($data['seance4']) == 0)
	if($data['seance4'] =='' || $data['seance4'] == 'creneau ouvert' )
	{	$item4 = "libre";
		echo '<input type="checkbox" id ="id4" name="options[]" value="seance4">13H30';
	}	
	else
	{  $item4 = "pris";
	}	
	
	//if(strlen($data['seance5']) == 0)
	if($data['seance5'] =='' || $data['seance5'] == 'creneau ouvert' )
	{	$item5 = "libre";
		echo '<input type="checkbox" id ="id5" name="options[]" value="seance5">14H00';
	}	
	else
	{  $item5 = "pris";
	}
	
	//if(strlen($data['seance6']) == 0)
	if($data['seance6'] =='' || $data['seance6'] == 'creneau ouvert' )
	{	$item6 = "libre";
		echo '<input type="checkbox" id ="id6" name="options[]" value="seance6">14H30';
	}	
	else
	{  $item6 = "pris";
	}
	
	//if(strlen($data['seance7']) == 0)
	if($data['seance7'] =='' || $data['seance7'] == 'creneau ouvert' )
	{	$item7 = "libre";
		echo '<input type="checkbox" id ="id7" name="options[]" value="seance7">15H00';
	}	
	else
	{  $item7 = "pris";
	}

//if(strlen($data['seance8']) == 0)
	if($data['seance8'] =='' || $data['seance8'] == 'creneau ouvert' )
	{	$item8 = "libre";
		echo '<input type="checkbox" id ="id8" name="options[]" value="seance8">15H30';
	}	
	else
	{  $item8 = "pris";
	}	
	
	
	if($item1 == "pris" && $item2 == "pris" && $item3 == "pris" && $item4 == "pris" && $item5 == "pris" && $item6 == "pris" && $item7 == "pris" && $item8 == "pris")
	{ 	echo "Plus de créneaux disponible à cette date !.";
		echo '<br>';
	}
	
	
?>

<?php
	if($_SESSION['nom'] == "admin")
	{	
		echo '<input type="submit" name="submit" value="Validation" onclick="valider_admin()"/>';
	}
	else
	{	
		echo '<input type="submit" name="submit" value="Validation" onclick="valider_utilisateur()"/>';
	}
	
	echo "<input type='submit' name='submit' value='Annuler' onclick='annuler()'/>" ;
		//echo '<input type="submit" name="submit" value="Annuler" onclick="annuler()"/>';
?>

</form>

<br>
<?php
	//echo "<input name='action' type='submit' value='Cancel' onclick='window.history.go(-1);'/>" ;
	
	if( $message == "ok")
	{	
		echo '
				<div id="id_message" class="css_message">
				<p>
				<strong>Information</strong>: ';
		echo    $client ." vient de réserver " .count($_POST['options']) . " créneau(x)" .' - ' .$str . " pour le " .$jour;
		echo 	'<br><br>';
		echo 	"Email envoyé + invitation Calendar";
		echo '	</p>
				<div>';
				
		$message = "";
	}

//	echo '<a href="selection_mois.php?mois='.$mois .' ">Retour au planning </a>';
						
 ?>

</body>
</html>