<?php
// echo "yassin" ; 

// exit() ;
include 'code/init.php' ;


//load.php

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

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

$q = dbi_query(" SELECT * FROM prestation_jour pj , prestation p  where p.prestation_id =  pj.prestation_id and  p.client_id = $client_id  ") ; 

// 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["prestation_jour_id"];
   $data[$i]['title']   = "salarie : ".$salarie_nom;
   $data[$i]['start']  = $row["prestation_jour_heurd"];
   $data[$i]['end' ]   = $row["prestation_jour_heurf"]	;	
   
    $data[$i]['salarie_id' ]   = $row["salarie_id"]	;	
$i++; 
	}
	
	


// 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);

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