<?php
// $from = '2020-04-01';
// $to   = '2020-04-24';
// function dateDifference($strtDate , $endDate )
// {
// $startDateWeekCnt = round(floor( date('d',strtotime($strtDate)) / 7)) ;
// $endDateWeekCnt = round(ceil( date('d',strtotime($endDate)) / 7)) ;
// $datediff = strtotime(date('Y-m',strtotime($endDate))."-01") - strtotime(date('Y-m',strtotime($strtDate))."-01");
// $totalnoOfWeek = round(floor($datediff/(60*60*24)) / 7) + $endDateWeekCnt - $startDateWeekCnt ;
    // return $totalnoOfWeek;
// }
// echo ' OK '.dateDifference($from,$to).'<br>';	
// echo ' OK '.$totalnoOfWeek .'<br>';
// function dateDifference($date_1 , $date_2 , $differenceFormat = '%a' )
// {
    // $datetime1 = date_create($date_1);
    // $datetime2 = date_create($date_2);
   
    // $interval = date_diff($datetime1, $datetime2);
   
    // return $interval->format($differenceFormat);
   
// }
// echo ' OK '.dateDifference($strtDate,$endDate).'<br>';	

include 'includes/config_tmcpro.php' ;
include 'includes/stable_functions_tmcpro.php' ;
$data = array();
$client_id=$_SESSION["client_id"] ; 
$now = new DateTime();
$start = '20200501';
$end = '20200531';
$date =  $start ;
$i=0 ; 
	while ($date <= $end )
	{
		// echo "SELECT * FROM PRESTATIONS p where p.client_id = ".$client_id." AND presta_date_debut < $date AND (p.presta_date_fin >= $date OR p.presta_date_fin IS NULL) ".'<br> ' ;
		$q = dbi_query("SELECT * FROM PRESTATIONS p where p.client_id = ".$client_id." AND presta_date_debut <= $date AND (p.presta_date_fin >= $date OR p.presta_date_fin IS NULL) ");
			while($prest = dbi_fetch_row($q))
		{		
				$q1 = dbi_query("SELECT * FROM PRESTATIONS_MODIF WHERE presta_id = ".$prest['presta_id']." order by start, modif_id ") ;
				while (($m = dbi_fetch_row($q1)) && $date >= $m['start'])
				{
					$prest['presta_sem'] = $m['presta_sem'] === NULL ? $prest['presta_sem'] : $m['presta_sem'] ;
					$prest['presta_jour'] = $m['presta_jour'] === NULL ? $prest['presta_jour'] : $m['presta_jour'] ;
					$prest['presta_Hdeb'] = $m['presta_Hdeb'] === NULL ? $prest['presta_Hdeb'] : $m['presta_Hdeb'] ;
					$prest['presta_Hduree'] = $m['presta_Hduree'] === NULL ? $prest['presta_Hduree'] : $m['presta_Hduree'] ;
					$prest['salarie_id'] = $m['salarie_id'] === NULL ? $prest['salarie_id'] : $m['salarie_id'] ;
					$prest['chantier_id'] = $m['chantier_id'] === NULL ? $prest['chantier_id'] : $m['chantier_id'] ;
					$prest['presta_forfait'] = $m['presta_forfait'] === NULL ? $prest['presta_forfait'] : $m['presta_forfait'] ;	
				}
				$day = date("w", strtotime( int2date_autre_format($date)));
				if( $day == $prest['presta_jour']){
					$istart = str_pad($prest['presta_Hdeb'] / 10000 , 2, '0', STR_PAD_LEFT) ;
					$iend = str_pad(addDuree($prest['presta_Hdeb'], $prest['presta_Hduree'])/ 10000 , 2, '0', STR_PAD_LEFT) ;  
					$istart = int2date_autre_format($date).' '.$istart.':00:00';
					$iend = int2date_autre_format($date).' '.$iend.':00:00';						
						// echo "<pre>";
						// print_r($prest);
						// echo "</pre>";
						// $iend = $prest['presta_Hduree'] ;
						// $istart =  $prest['	presta_Hdeb'] ;
						// $prestation_jour_heurd = date('Y-m-d', $i)." ".$_POST['prestation_jour_heurd'].":00" ; 						
					// echo $istart .' !! !! '.$iend .'<br>';	
					// $astart = int2date_autre_format($date).' '.'11:00:00';	
				   $EXP = dbi_fetch_row(dbi_query("SELECT date_presta FROM EXCEPTIONS WHERE presta_id = ".$prest['presta_id'] )) ;
				   if($EXP['date_presta'] ==  $date){}   else {
					   
				   $data[$i]['id']   = $prest["presta_id"];
				   $data[$i]['title']   = "salarie : ".$prest["presta_id"];
				   $data[$i]['start']  = $istart;
				   $data[$i]['end']   = $iend;
				   $data[$i]['date']   = $date;					   
				   ++$i;
				   }
				}
			// echo  date("Ymd", strtotime( int2date_autre_format($date))).' !! '.$prest['presta_id'].' $$ '.$prest['presta_jour'].'<br>';	
		}	
// $date = time2int($time) ;
		
		
		
		
		$date =  date("Ymd", strtotime("+1 day", strtotime($date)));
	}
 // 2020-05-01 11:00:00	
// $q = dbi_query(" SELECT * 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 json_encode($data);

?>