Tiny File Manager

Back Back Up Advanced Editor

<?php

session_start ();
	
	error_reporting(0);
	
	include('database.php');
	include('fonctions.php');
	include('generation_timing.php');
	
	//$array_horaire_court = generation_timing("12H30", 20, 5);
	//$array_horaire_long = generation_timing("12H30", 30, 5);
	
    $array_horaire_court = generation_timing($_SESSION['debut_horaire_courte'], $_SESSION['temps_sceance_courte'], $_SESSION['temps_sanitaire']);
    $array_horaire_long = generation_timing($_SESSION['debut_horaire_longue'], $_SESSION['temps_sceance_longue'], $_SESSION['temps_sanitaire']);

DB_connexion();
 	header( 'content-type: text/html; charset=utf-8' );
	
	$message = "";
	$browser = $_SERVER['HTTP_USER_AGENT'];
	//echo $browser;
	
	if (!isset($_SESSION['nom']) && !isset($_SESSION['password']))
	{  
			header("Location: login.php");   
	}
	
	
	
	$table = $_SESSION['table_reservation'];
	//echo $table;
	
	if(isset($_POST['valide']) && $_POST['valide'] == "ok")
	{ 
				$mois = $_POST['mois'];
				$jour = $_POST['jour'];
				$horaire = $_POST['horaire'];
				$client = $_POST['client'];
				
				$annee = date('Y');
								
				$sql = "SELECT * FROM " .$table ." WHERE rendezvous = '$jour' ";	
				//echo $sql;
				mysqli_query($connexion, "SET NAMES 'utf8'");
				$result = mysqli_query($connexion, $sql );
	
				if(!$result)
				{
					die('Impossible d\'exécuter la requête :' . mysql_error());
				}

$n = mysqli_num_rows($result);

//echo "Resultat:  " .$n;
				
				$data = mysqli_fetch_assoc($result);
				
				//echo '<pre>';
				//print_r($data);	
					
				$tab_seance = array();
				$tab_seance[] = "decalage";

for( $k=1; $k <9 ; $k++)
				{
					$tab_seance[] = "unselect";	
				}	
					
				$indice_debut =  preg_replace('/[^0-9]+/', '', $data['horairedebut']);
				$indice_fin =  preg_replace('/[^0-9]+/', '', $data['horairefin']);
				$val3 = $data['avant'];
				$val4 = $data['apres'];
				
				$tab_tmp = array();
				
		     	$tab_tmp[] = $data['seance1'];
				$tab_tmp[] = $data['seance2'];
				$tab_tmp[] = $data['seance3'];
				$tab_tmp[] = $data['seance4'];
				$tab_tmp[] = $data['seance5'];
				$tab_tmp[] = $data['seance6'];
				$tab_tmp[] = $data['seance7'];
				$tab_tmp[] = $data['seance8'];
				
				//echo '<pre>';
				//print_r($tab_tmp);

//echo $indice_debut ."  " .$indice_fin  ."  " .$val3 ."  " .$val4;
				//echo '<br>';			
				
				$supplement_avant_debut = $indice_debut - $val3;
				$supplement_avant_fin = $indice_debut - 1;
				$supplement_apres_debut = $indice_fin + 1;
				$supplement_apres_fin = $indice_fin + $val4;
				
				//echo $supplement_avant_debut ."  " .$supplement_avant_fin ."  " .$supplement_apres_debut ."  " .$supplement_apres_fin;

for( $l=1; $l <9 ; $l++)
				{
							if( $l >= $indice_debut && $l <= $indice_fin)
							{
									$tab_seance[$l] = "";
							}	
							if( $l >= $supplement_apres_debut && $l <= $supplement_apres_fin)
							{
									$tab_seance[$l] = "creneau fermer";
							}	
							if( $l >= $supplement_avant_debut && $l <= $supplement_avant_fin)
							{
									$tab_seance[$l] = "creneau fermer";
							}	
				}			
			
				//echo '<pre>';
				//print_r($tab_seance);
				
				$indice_horaire =  preg_replace('/[^0-9]+/', '', $horaire);
				
				//echo $indice_horaire;
				//echo '<br>';
				//echo $tab_seance[$indice_horaire];
				
				if( strlen($tab_seance[$indice_horaire]) != 0)
				{ 
					$str = "creneau ouvert";
					$type_creneau = "etendu";
				}
				else
				{ 
					$str = "";
					$type_creneau = "normal";
				}
				
				// mise à jour 
				
				mysqli_query($connexion, "SET NAMES 'utf8'");
				$s1 = "UPDATE " .$table ." SET ";		
				$s2 = $horaire ." = '$str'";		
				$s3 = " WHERE rendezvous ='$jour' ";	
				$sql = $s1 . $s2 .$s3;		
				//echo $sql;		
				//echo '<br>';

$result = mysqli_query($connexion, $sql );	
				if(!$result)
				{
					die('Impossible d\'exécuter la requête :' . mysql_error());
				}		
				
				// mise à jour  gestion 
				$val = substr($horaire, 6);
				
				//$sql = "SELECT id FROM " .$_SESSION['table_gestion'] ." WHERE rendezvous = '$jour' ";	
				
				// $_SESSION['table_gestion']
				$sql = "SELECT id FROM gestion_v3 WHERE jour ='$jour' and seance ='$val' and client ='$client' ";	
				
				//echo $sql;
				$result = mysqli_query($connexion, $sql );	
				if(!$result)
				{
					die('Impossible d\'exécuter la requête :' . mysql_error());
				}
				//$n = mysqli_num_rows($result);
				//echo "+++++ " .$n; 
				$data = mysqli_fetch_assoc($result);
				$indice = $data['id'];
				$sql = "DELETE FROM gestion_v3 WHERE id = $indice";
				//echo $sql;
				$result = mysqli_query($connexion, $sql );

//// mise à jour du compteur de crénaux 
				//if($horaire == "seance3" || $horaire == "seance4" || $horaire == "seance5" || $horaire == "seance6")
				if($type_creneau == "normal")
				{
					$sql = "select normal from " .$table ." WHERE rendezvous ='$jour' ";
					$result = mysqli_query($connexion, $sql );	
					$data = mysqli_fetch_assoc($result);
					if($data['normal'] != 0)
					{	$val = $data['normal'] - 1 ;
						$sql = "UPDATE " .$table ." SET normal = '$val' WHERE rendezvous ='$jour' ";
						$result = mysqli_query($connexion, $sql );
					}
				}	
				
				//if($horaire == "seance1" || $horaire == "seance2" || $horaire == "seance7" || $horaire == "seance8")
				if($type_creneau == "etendu")
				{				
					$sql = "select etendu from " .$table ." WHERE rendezvous ='$jour' ";
					$result = mysqli_query($connexion, $sql );	
					$data = mysqli_fetch_assoc($result);
					if($data['etendu'] != 0)
					{	$val = $data['etendu'] - 1 ;
						$sql = "UPDATE " .$table ." SET etendu = '$val' WHERE rendezvous ='$jour' ";
						$result = mysqli_query($connexion, $sql );
					}
				}
				
/////// ouverture automatique des créneaux supplémentaires

nouvelle_allocation($mois);
				
				$site = $_SERVER["SERVER_NAME"];
				if( ($site == "localhost") || ($site == "127.0.0.1") ) 
				{
					$no_active = true;
				}
				else
				{	
					if($formule == "courte")
					{
						switch ($horaire)
						{
							case 	"seance1":
									$heure = $array_horaire_court[0] . " ";
									break;
							case	"seance2":
									$heure = $array_horaire_court[1] . " ";
									break;
							case	"seance3":
									$heure = $array_horaire_court[2] . " ";
									break;
							case	"seance4":
									$heure = $array_horaire_court[3] . " ";
									break;	
							case	"seance5":
									$heure = $array_horaire_court[4] . " ";
									break;
							case	"seance6":
									$heure = $array_horaire_court[5] . " ";
									break;
							case	"seance7":
									$heure = $array_horaire_court[6] . " ";
									break;
							case	"seance8":
									$heure = $array_horaire_court[7] . " ";
									break;		
						} 
					}		
					
					if($formule == "longue")
					{
						switch ($horaire)
						{
							case 	"seance1":
									$heure = $array_horaire_long[0] . " ";
									break;
							case	"seance2":
									$heure = $array_horaire_long[1] . " ";
									break;
							case	"seance3":
									$heure = $array_horaire_long[2] . " ";
									break;
							case	"seance4":
									$heure = $array_horaire_long[3] . " ";
									break;	
							case	"seance5":
									$heure = $array_horaire_long[4] . " ";
									break;
							case	"seance6":
									$heure = $array_horaire_long[5] . " ";
									break;
							case	"seance7":
									$heure = $array_horaire_long[6] . " ";
									break;
							case	"seance8":
									$heure = $array_horaire_long[7] . " ";
									break;		
						} 
					}		
	
					$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);
					
					//$debug_mode = $_SESSION['debug_mode'];
					//if($debug_mode == "no")
					//{
						email_html("supprimer", $nom , $prenom, $data['email'] , $jour, $heure);
					//}

}
				
				//if($debug_mode == "no")
				//{
					header("Location: affiche_planning03.php?mois=$mois");
				//}
	 }

if(isset($_POST['valide']) && $_POST['valide'] == "annule")
	 { 		
			$mois = $_POST['mois'];
			header("Location: affiche_planning03.php?mois=$mois");
	 }

//////////////////////////  traitement lors du chargement de la page ///////////////////////////////////////////
	 
	 $mois = $_GET['mois'];	
	 $jour = $_GET['jour'];	
	 $horaire = $_GET['horaire'];	
	 $client = $_GET['client'];	
	 $formule = $_GET['formule'];	
	 
	 if($formule == "courte")
	 {
		switch ($horaire)
		{
			case "seance1":
				$val = $array_horaire_court[0] . " ";
				break;
			case "seance2":
				$val = $array_horaire_court[1] . " ";
				break;
			case "seance3":
				$val = $array_horaire_court[2] . " ";
				break;
			case "seance4":
				$val = $array_horaire_court[3] . " ";
				break;	
			case "seance5":
				$val = $array_horaire_court[4] . " ";
				break;
			case "seance6":
				$val = $array_horaire_court[5] . " ";
				break;
			case "seance7":
				$val = $array_horaire_court[6] . " ";
				break;
			case "seance8":
				$val = $array_horaire_court[7] . " ";
				break;		
		} 
	 }
	 
	 if($formule == "longue")
	 {
		switch ($horaire)
		{
			case "seance1":
				$val = $array_horaire_long[0] . " ";
				break;
			case "seance2":
				$val = $array_horaire_long[1] . " ";
				break;
			case "seance3":
				$val = $array_horaire_long[2] . " ";
				break;
			case "seance4":
				$val = $array_horaire_long[3] . " ";
				break;	
			case "seance5":
				$val = $array_horaire_long[4] . " ";
				break;
			case "seance6":
				$val = $array_horaire_long[5] . " ";
				break;
			case "seance7":
				$val = $array_horaire_long[6] . " ";
				break;
			case "seance8":
				$val = $array_horaire_long[7] . " ";
				break;		
		} 
	 }
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" href="https://code.jquery.com/ui/1.10.4/themes/smoothness/jquery-ui.css">
<script src="https://code.jquery.com/jquery.js"></script>
<script src="https://code.jquery.com/ui/1.10.4/jquery-ui.js"></script>
<title>Espace réservation</title>
</head>

<style>

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

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

<div id='cssmenu'>
	<ul>
		<li><a href='home.php'><span>Home</span></a></li>
		<li><a href='selection_planning_mois.php'><span>Planning</span></a></li>
		<li class='active'><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>

/***************************************************/

$(document).ready(function()
{
		$('#bouton_submit').click(effacer); 
		//$('#bouton_annuler').click(annuler); 
});
/***************************************************/

/***************************************************/

function annuler()
{
	  //window.history.back();
	  alert("Retour");
	  //history.back();
}

/***************************************************/

function fct_effacer()
{	
	verif = confirm("Voulez vous vraiment supprimer ce rendez-vous ?");

if(verif == true) 
	{ document.getElementById('valide').value="ok"; 	  }

if(verif == false) 
	{ document.getElementById('valide').value="stop"; 	  }	
}

function fct_annuler()
{	
	alert("Retour");
	window.history.back();
	//document.getElementById('valide').value="annule";
} 
</script>

</head>
	<body>
	
	
	<form action="#" name ="form_supprimer" method="post">
	<table align="left" cellspacing="1" cellpadding="5" border="0" bgcolor="#D5D5D5" width="400"> 
		
	<tr bgcolor="#F1F3F5">
	<td><?php echo $client; ?> souhaite annuler un rendez-vous:</td>		
	</tr>
	</tr>	
	</td>
	</tr>

<tr bgcolor="#FFFFFF">	
		
	
	</tr>	
	
	<tr bgcolor='#F1F3F5'>
	<td colspan='2' align='center'>

</td>	
	</tr>
	</td>
	</tr>
	</table>

</div>
	</div>
	</form>
	
	<div id="dialog-confirm"></div>
	
<?php

if( $message == "ok")
				{	
					echo '
							<div id="id_message" class="css_message">
							<p>
							<strong>Information</strong>: Modification du mot de passe effectuée avec succés.
							</p>
							<div>';
					$message = "none";
				}
?>	
	
	</body>
	</html>