<?php
include 'includes/config_tmcpro.php' ;
include 'includes/stable_functions_tmcpro.php' ;
//load.php

// $connect = new PDO('mysql:host=localhost;dbname=tmcpro', 'root', '');

$data = array();
 // $client_id=$_SESSION["cleint_id"] ; 

// $q = dbi_query("SELECT * FROM `disponibilite` where salarie_id =".$salarie_id) ; 
// $salarie_id= $_SESSION["salarie_id"]; 
$salarie_id = 2543;

if(isset($_GET['salarie_id']))
	$salarie_id = $_GET['salarie_id'];
if(isset($_POST['salarie_id']))
	$salarie_id = $_POST['salarie_id'];
$q = dbi_query("SELECT * FROM `indisponibilite`  where salarie_id = $salarie_id ") ; 
// exit() ; 
// echo " SELEC * FROM prestation_jour pj , prestation p  where p.prestation_id =  pj.prestation_id and  p.client_id = $client_id  "  ;
$i=0 ; 
while($row=dbi_fetch_row($q))
	{
		
	// list($salarie_nom)=	dbi_fetch_row(dbi_query(" SELECT salarie_nom FROM `salarie` WHERE salarie_id = ".$row["salarie_id"])) ; 
    $data[$i]['id']   = $row["indisponibilite_id"];
    $data[$i]['title']   = " Indisponible " ;
  
   $data[$i]['start']  = $row["disponibilite_heurs_debu"];
   $data[$i]['end' ]   = $row["disponibilite_heurs_fin"]	;	
   
    // $data[$i]['salarie_id' ]   = $row["salarie_id"]	;	
$i++; 
	}
	
	// echo "<pre>" ; 
// print_r($data) ;
// echo "</pre>" ; 
// exit();


// echo "<pre>" ; 
// print_r($data) ;
// echo "</pre>" ; 
// exit();


// $query = "SELECT * FROM events ORDER BY id";

// $statement = $connect->prepare($query);

// $statement->execute();

// $result = $statement->fetchAll();

// foreach($result as $row)
// {
 // $data[] = array(
  // 'id'   => $row["id"],
  // 'title'   => "prestation",
  // 'start'   => "2020-01-08 10:00:00",
  // 'end'   => "2020-01-08 14:00:00",
 // );

 
echo json_encode($data);


?>