File "select-chain.php"

Full Path: /home/asmplong/www/asm/Classes/PHPExcel/Writer/Excel5/select-chain.php
File size: 12.98 KB
MIME-type: text/x-php
Charset: utf-8

<?php
include('inc.conec.php');
include('inc.fonctions.php');
include('inc.config.php');

if ($_GET['id'] == "1") {

	$date_event = changedatefrus($_GET['date']);
	$jour = date("w",strtotime($date_event));
	
	$req_type = mysql_query("SELECT * FROM ".$db_prefixe."types_events WHERE type_id = '$_GET[id]'");
	$data_type = mysql_fetch_array($req_type);
	
	$tb_heures = explode(',',$data_type['type_horaire']);
	
	if($jour == '2')
	{
		
  echo <<<HERE_DOC
    [ {"optionValue": 0, "optionDisplay": ""}, {"optionValue":"18:30", "optionDisplay": "18:30"}, {"optionValue":"19:00", "optionDisplay": "19:00"}, {"optionValue":"19:30", "optionDisplay": "19:30"}, {"optionValue":"20:00", "optionDisplay": "20:00"}, {"optionValue":"20:30", "optionDisplay": "20:30"}, {"optionValue":"21:00", "optionDisplay": "21:00"}, {"optionValue":"21:30", "optionDisplay": "21:30"}, {"optionValue":"22:00", "optionDisplay": "22:00"}]
HERE_DOC;
		
	}
	
}else if ($_GET['id'] == "2") {

	$date_event = changedatefrus($_GET['date']);
	$jour = date("w",strtotime($date_event));
	
	$req_type = mysql_query("SELECT * FROM ".$db_prefixe."types_events WHERE type_id = '$_GET[id]'");
	$data_type = mysql_fetch_array($req_type);
	
	$tb_heures = explode(',',$data_type['type_horaire']);
	
	if($jour == '4')
	{
		
  echo <<<HERE_DOC
    [ {"optionValue": 0, "optionDisplay": ""}, {"optionValue":"18:30", "optionDisplay": "18:30"}, {"optionValue":"19:00", "optionDisplay": "19:00"}, {"optionValue":"19:30", "optionDisplay": "19:30"}, {"optionValue":"20:00", "optionDisplay": "20:00"}, {"optionValue":"20:30", "optionDisplay": "20:30"}, {"optionValue":"21:00", "optionDisplay": "21:00"}, {"optionValue":"21:30", "optionDisplay": "21:30"}, {"optionValue":"22:00", "optionDisplay": "22:00"}]
HERE_DOC;
		
	}
}else if ($_GET['id'] == "3") {

	$date_event = changedatefrus($_GET['date']);
	$jour = date("w",strtotime($date_event));
	
	$req_type = mysql_query("SELECT * FROM ".$db_prefixe."types_events WHERE type_id = '$_GET[id]'");
	$data_type = mysql_fetch_array($req_type);
	
	$tb_heures = explode(',',$data_type['type_horaire']);
	
	if(($jour == '6') || ($jour == '0'))
	{
		
  echo <<<HERE_DOC
        [ {"optionValue": 0, "optionDisplay": ""}, {"optionValue":"07:30", "optionDisplay": "07:30"}, {"optionValue":"08:00", "optionDisplay": "08:00"}, {"optionValue":"08:30", "optionDisplay": "08:30"}, {"optionValue":"09:00", "optionDisplay": "09:00"}, {"optionValue":"09:30", "optionDisplay": "09:30"}, {"optionValue":"10:00", "optionDisplay": "10:00"}, {"optionValue":"10:30", "optionDisplay": "10:30"}, {"optionValue":"11:00", "optionDisplay": "11:00"}, {"optionValue":"11:30", "optionDisplay": "11:30"},{"optionValue":"12:00", "optionDisplay": "12:00"}, {"optionValue":"12:30", "optionDisplay": "12:30"}, {"optionValue":"13:00", "optionDisplay": "13:00"}, {"optionValue":"13:30", "optionDisplay": "13:30"}, {"optionValue":"14:00", "optionDisplay": "14:00"}, {"optionValue":"14:30", "optionDisplay": "14:30"}, {"optionValue":"15:00", "optionDisplay": "15:00"}, {"optionValue":"15:30", "optionDisplay": "15:30"}, {"optionValue":"16:00", "optionDisplay": "16:00"},  {"optionValue":"16:30", "optionDisplay": "16:30"},{"optionValue":"17:00", "optionDisplay": "17:00"}, {"optionValue":"17:30", "optionDisplay": "17:30"}, {"optionValue":"18:00", "optionDisplay": "18:00"}, {"optionValue":"18:30", "optionDisplay": "18:30"}, {"optionValue":"19:00", "optionDisplay": "19:00"}, {"optionValue":"19:30", "optionDisplay": "19:30"}, {"optionValue":"20:00", "optionDisplay": "20:00"}, {"optionValue":"20:30", "optionDisplay": "20:30"}, {"optionValue":"21:00", "optionDisplay": "21:00"}, {"optionValue":"21:30", "optionDisplay": "21:30"}, {"optionValue":"22:00", "optionDisplay": "22:00"}]
HERE_DOC;
		
	}
}else if ($_GET['id'] == "9") {

	$date_event = changedatefrus($_GET['date']);
	$jour = date("w",strtotime($date_event));
	
	$req_type = mysql_query("SELECT * FROM ".$db_prefixe."types_events WHERE type_id = '$_GET[id]'");
	$data_type = mysql_fetch_array($req_type);
	
	$tb_heures = explode(',',$data_type['type_horaire']);
	
	if(($jour == '6') || ($jour == '0'))
	{
		
  echo <<<HERE_DOC
        [ {"optionValue": 0, "optionDisplay": ""}, {"optionValue":"07:30", "optionDisplay": "07:30"}, {"optionValue":"08:00", "optionDisplay": "08:00"}, {"optionValue":"08:30", "optionDisplay": "08:30"}, {"optionValue":"09:00", "optionDisplay": "09:00"}, {"optionValue":"09:30", "optionDisplay": "09:30"}, {"optionValue":"10:00", "optionDisplay": "10:00"}, {"optionValue":"10:30", "optionDisplay": "10:30"}, {"optionValue":"11:00", "optionDisplay": "11:00"}, {"optionValue":"11:30", "optionDisplay": "11:30"},{"optionValue":"12:00", "optionDisplay": "12:00"}, {"optionValue":"12:30", "optionDisplay": "12:30"}, {"optionValue":"13:00", "optionDisplay": "13:00"}, {"optionValue":"13:30", "optionDisplay": "13:30"}, {"optionValue":"14:00", "optionDisplay": "14:00"}, {"optionValue":"14:30", "optionDisplay": "14:30"}, {"optionValue":"15:00", "optionDisplay": "15:00"}, {"optionValue":"15:30", "optionDisplay": "15:30"}, {"optionValue":"16:00", "optionDisplay": "16:00"},  {"optionValue":"16:30", "optionDisplay": "16:30"},{"optionValue":"17:00", "optionDisplay": "17:00"}, {"optionValue":"17:30", "optionDisplay": "17:30"}, {"optionValue":"18:00", "optionDisplay": "18:00"}, {"optionValue":"18:30", "optionDisplay": "18:30"}, {"optionValue":"19:00", "optionDisplay": "19:00"}, {"optionValue":"19:30", "optionDisplay": "19:30"}, {"optionValue":"20:00", "optionDisplay": "20:00"}, {"optionValue":"20:30", "optionDisplay": "20:30"}, {"optionValue":"21:00", "optionDisplay": "21:00"}, {"optionValue":"21:30", "optionDisplay": "21:30"}, {"optionValue":"22:00", "optionDisplay": "22:00"}]
HERE_DOC;
		
	}
}else if ($_GET['id'] == "4") {

	$date_event = changedatefrus($_GET['date']);
	$jour = date("w",strtotime($date_event));
	
	$req_type = mysql_query("SELECT * FROM ".$db_prefixe."types_events WHERE type_id = '$_GET[id]'");
	$data_type = mysql_fetch_array($req_type);
	
	$tb_heures = explode(',',$data_type['type_horaire']);
	
	if(($jour == '6') || ($jour == '0'))
	{
		
  echo <<<HERE_DOC
        [ {"optionValue": 0, "optionDisplay": ""}, {"optionValue":"07:30", "optionDisplay": "07:30"}, {"optionValue":"08:00", "optionDisplay": "08:00"}, {"optionValue":"08:30", "optionDisplay": "08:30"}, {"optionValue":"09:00", "optionDisplay": "09:00"}, {"optionValue":"09:30", "optionDisplay": "09:30"}, {"optionValue":"10:00", "optionDisplay": "10:00"}, {"optionValue":"10:30", "optionDisplay": "10:30"}, {"optionValue":"11:00", "optionDisplay": "11:00"}, {"optionValue":"11:30", "optionDisplay": "11:30"},{"optionValue":"12:00", "optionDisplay": "12:00"}, {"optionValue":"12:30", "optionDisplay": "12:30"}, {"optionValue":"13:00", "optionDisplay": "13:00"}, {"optionValue":"13:30", "optionDisplay": "13:30"}, {"optionValue":"14:00", "optionDisplay": "14:00"}, {"optionValue":"14:30", "optionDisplay": "14:30"}, {"optionValue":"15:00", "optionDisplay": "15:00"}, {"optionValue":"15:30", "optionDisplay": "15:30"}, {"optionValue":"16:00", "optionDisplay": "16:00"},  {"optionValue":"16:30", "optionDisplay": "16:30"},{"optionValue":"17:00", "optionDisplay": "17:00"}, {"optionValue":"17:30", "optionDisplay": "17:30"}, {"optionValue":"18:00", "optionDisplay": "18:00"}, {"optionValue":"18:30", "optionDisplay": "18:30"}, {"optionValue":"19:00", "optionDisplay": "19:00"}, {"optionValue":"19:30", "optionDisplay": "19:30"}, {"optionValue":"20:00", "optionDisplay": "20:00"}, {"optionValue":"20:30", "optionDisplay": "20:30"}, {"optionValue":"21:00", "optionDisplay": "21:00"}, {"optionValue":"21:30", "optionDisplay": "21:30"}, {"optionValue":"22:00", "optionDisplay": "22:00"}]
HERE_DOC;
		
	}
}else if ($_GET['id'] == "5") {

	$date_event = changedatefrus($_GET['date']);
	$jour = date("w",strtotime($date_event));
	
	$req_type = mysql_query("SELECT * FROM ".$db_prefixe."types_events WHERE type_id = '$_GET[id]'");
	$data_type = mysql_fetch_array($req_type);
	
	$tb_heures = explode(',',$data_type['type_horaire']);
	
	if(($jour == '6') || ($jour == '0'))
	{
		
  echo <<<HERE_DOC
    [ {"optionValue": 0, "optionDisplay": ""}, {"optionValue":"07:30", "optionDisplay": "07:30"}, {"optionValue":"08:00", "optionDisplay": "08:00"}]
HERE_DOC;
		
	}

}else if ($_GET['id'] == "6") {

	$date_event = changedatefrus($_GET['date']);
	$jour = date("w",strtotime($date_event));
	
	$req_type = mysql_query("SELECT * FROM ".$db_prefixe."types_events WHERE type_id = '$_GET[id]'");
	$data_type = mysql_fetch_array($req_type);
	
	$tb_heures = explode(',',$data_type['type_horaire']);
	
	if($jour == '0')
	{
		
  echo <<<HERE_DOC
    [ {"optionValue": 0, "optionDisplay": ""}, {"optionValue":"07:30", "optionDisplay": "07:30"}, {"optionValue":"08:00", "optionDisplay": "08:00"}]
HERE_DOC;
		
	}


}else if ($_GET['id'] == "7") {

	$date_event = changedatefrus($_GET['date']);
	$jour = date("w",strtotime($date_event));
	
	$req_type = mysql_query("SELECT * FROM ".$db_prefixe."types_events WHERE type_id = '$_GET[id]'");
	$data_type = mysql_fetch_array($req_type);
	
	$tb_heures = explode(',',$data_type['type_horaire']);
	
	if(($jour == '6') || ($jour == '0'))
	{
		
  echo <<<HERE_DOC
    [ {"optionValue": 0, "optionDisplay": ""}, {"optionValue":"14:00", "optionDisplay": "14:00"}]
HERE_DOC;
		
	}
	else if(($jour == '1') || ($jour == '3') || ($jour == '5'))
	{
		
  echo <<<HERE_DOC
    [ {"optionValue": 0, "optionDisplay": ""}, {"optionValue":"07:30", "optionDisplay": "07:30"}, {"optionValue":"08:00", "optionDisplay": "08:00"}, {"optionValue":"08:30", "optionDisplay": "08:30"}, {"optionValue":"09:00", "optionDisplay": "09:00"}, {"optionValue":"09:30", "optionDisplay": "09:30"}, {"optionValue":"10:00", "optionDisplay": "10:00"}, {"optionValue":"10:30", "optionDisplay": "10:30"}, {"optionValue":"11:00", "optionDisplay": "11:00"}, {"optionValue":"11:30", "optionDisplay": "11:30"},{"optionValue":"12:00", "optionDisplay": "12:00"}, {"optionValue":"12:30", "optionDisplay": "12:30"}, {"optionValue":"13:00", "optionDisplay": "13:00"}, {"optionValue":"13:30", "optionDisplay": "13:30"}, {"optionValue":"14:00", "optionDisplay": "14:00"}, {"optionValue":"14:30", "optionDisplay": "14:30"}, {"optionValue":"15:00", "optionDisplay": "15:00"}, {"optionValue":"15:30", "optionDisplay": "15:30"}, {"optionValue":"16:00", "optionDisplay": "16:00"},  {"optionValue":"16:30", "optionDisplay": "16:30"},{"optionValue":"17:00", "optionDisplay": "17:00"}, {"optionValue":"17:30", "optionDisplay": "17:30"}, {"optionValue":"18:00", "optionDisplay": "18:00"}, {"optionValue":"18:30", "optionDisplay": "18:30"}, {"optionValue":"19:00", "optionDisplay": "19:00"}, {"optionValue":"19:30", "optionDisplay": "19:30"}, {"optionValue":"20:00", "optionDisplay": "20:00"}, {"optionValue":"20:30", "optionDisplay": "20:30"}, {"optionValue":"21:00", "optionDisplay": "21:00"}, {"optionValue":"21:30", "optionDisplay": "21:30"}, {"optionValue":"22:00", "optionDisplay": "22:00"}]
HERE_DOC;
		
	}
	else if(($jour == '2') || ($jour == '4'))
	{
		
  echo <<<HERE_DOC
    [ {"optionValue": 0, "optionDisplay": ""}, {"optionValue":"07:30", "optionDisplay": "07:30"}, {"optionValue":"08:00", "optionDisplay": "08:00"}, {"optionValue":"08:30", "optionDisplay": "08:30"}, {"optionValue":"09:00", "optionDisplay": "09:00"}, {"optionValue":"09:30", "optionDisplay": "09:30"}, {"optionValue":"10:00", "optionDisplay": "10:00"}, {"optionValue":"10:30", "optionDisplay": "10:30"}, {"optionValue":"11:00", "optionDisplay": "11:00"}, {"optionValue":"11:30", "optionDisplay": "11:30"}, {"optionValue":"12:00", "optionDisplay": "12:00"}]
HERE_DOC;
		
	}	

}else if ($_GET['id'] == "8") {


		
  echo <<<HERE_DOC
    [ {"optionValue": 0, "optionDisplay": ""}, {"optionValue":"07:30", "optionDisplay": "07:30"}, {"optionValue":"08:00", "optionDisplay": "08:00"}, {"optionValue":"08:30", "optionDisplay": "08:30"}, {"optionValue":"09:00", "optionDisplay": "09:00"}, {"optionValue":"09:30", "optionDisplay": "09:30"}, {"optionValue":"10:00", "optionDisplay": "10:00"}, {"optionValue":"10:30", "optionDisplay": "10:30"}, {"optionValue":"11:00", "optionDisplay": "11:00"}, {"optionValue":"11:30", "optionDisplay": "11:30"},{"optionValue":"12:00", "optionDisplay": "12:00"}, {"optionValue":"12:30", "optionDisplay": "12:30"}, {"optionValue":"13:00", "optionDisplay": "13:00"}, {"optionValue":"13:30", "optionDisplay": "13:30"}, {"optionValue":"14:00", "optionDisplay": "14:00"}, {"optionValue":"14:30", "optionDisplay": "14:30"}, {"optionValue":"15:00", "optionDisplay": "15:00"}, {"optionValue":"15:30", "optionDisplay": "15:30"}, {"optionValue":"16:00", "optionDisplay": "16:00"},  {"optionValue":"16:30", "optionDisplay": "16:30"},{"optionValue":"17:00", "optionDisplay": "17:00"}, {"optionValue":"17:30", "optionDisplay": "17:30"}, {"optionValue":"18:00", "optionDisplay": "18:00"}, {"optionValue":"18:30", "optionDisplay": "18:30"}, {"optionValue":"19:00", "optionDisplay": "19:00"}, {"optionValue":"19:30", "optionDisplay": "19:30"}, {"optionValue":"20:00", "optionDisplay": "20:00"}, {"optionValue":"20:30", "optionDisplay": "20:30"}, {"optionValue":"21:00", "optionDisplay": "21:00"}, {"optionValue":"21:30", "optionDisplay": "21:30"}, {"optionValue":"22:00", "optionDisplay": "22:00"}]
HERE_DOC;
		

}


?>