<?php
// $from = '2020-04-01';
// $to   = '2020-04-01';
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;
}
 if(isset($_GET['date'])){
include 'includes/config_tmcpro.php' ;
include 'includes/stable_functions_tmcpro.php' ;
$data = array();
$client_id=538 ; 
$salarie_id=257 ; 
$now = new DateTime();
$start = dateformaint($_GET['date']);
$end = date("Ymt", strtotime($_GET['date']));
// $end = $now -> format('Ymt');
$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> ' ;
		// 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 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'] ;	
				}
				if( $prest['salarie_id'] == $salarie_id)
				  {
						$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) ;
							$hstart = str_pad(round($prest['presta_Hdeb'] /  10000, 0) , 2, '0', STR_PAD_LEFT) ;
							$mstart = str_pad(($prest['presta_Hdeb'] %  10000)/100  , 2, '0', STR_PAD_LEFT);
							$hend = str_pad(round(addDuree($prest['presta_Hdeb'], $prest['presta_Hduree']) /  10000, 0) , 2, '0', STR_PAD_LEFT) ;
							$mend = str_pad((addDuree($prest['presta_Hdeb'], $prest['presta_Hduree']) %  10000)/100  , 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).' '.$hstart.':'.$mstart.':00';
							$iend = int2date_autre_format($date).' '.$hend.':'.$mend.':00';	

						   $EXP = dbi_fetch_row(dbi_query("SELECT date_presta FROM EXCEPTIONS WHERE presta_id = ".$prest['presta_id']." AND date_presta = ".$date." " )) ;	   ;
						   if($EXP ){}   else {
							   // if( $prest['salarie_id'] == $salarie_id)
								   // {
										if( $prest['presta_sem'] == 1 )
										{
											   $SAL = dbi_fetch_row(dbi_query("SELECT * FROM salarie WHERE salarie_id = ".$prest['salarie_id'] ." " )) ;	   ;   
											   $data[$i]['id']   = $prest["presta_id"];
											   $data[$i]['title']   = " ".$SAL["salarie_nom"];
											   $data[$i]['start']  = $istart;
											   $data[$i]['end']   = $iend;
											   $data[$i]['date']   = $date;					   
											   ++$i;	
										}
										else
										{
											$nbre = dateDifference(int2date_autre_format($prest['presta_date_debut']),int2date_autre_format($date)) - 1;
											if( $nbre % $prest['presta_sem'] == 0) {
											   $SAL = dbi_fetch_row(dbi_query("SELECT * FROM salarie WHERE salarie_id = ".$prest['salarie_id'] ." " )) ;	   ;   
											   $data[$i]['id']   = $prest["presta_id"];
											   $data[$i]['title']   = " ".$SAL["salarie_nom"];
											   $data[$i]['start']  = $istart;
											   $data[$i]['end']   = $iend;
											   $data[$i]['date']   = $date;					   
											   ++$i;
											}
											
										}
									// }	

						   }
						}
					}
		}	

		
		
		
		
		$date =  date("Ymd", strtotime("+1 day", strtotime($date)));
	}

echo json_encode($data);
 }
?>