<?php
include 'includes/config_tmcpro.php' ;
include 'includes/stable_functions_tmcpro.php' ;
$data = array();
$date = date("Ymd");
$i = 1;
// SELECT * FROM PRESTATIONS WHERE  client_id=".$client_id."  AND ((presta_date_debut != presta_date_fin &&  presta_date_fin >= '".$date."')  OR presta_date_fin IS NULL ) ORDER BY presta_date_debut"

// echo "SELECT * FROM PRESTATIONS p where  ((presta_date_debut != presta_date_fin &&  presta_date_fin >= '".$date."')  OR presta_date_fin IS NULL )";
$q = dbi_query("SELECT * FROM PRESTATIONS WHERE  ((presta_date_debut != presta_date_fin &&  presta_date_fin >= '".$date."')  OR presta_date_fin IS NULL )");
			while($prest = dbi_fetch_row($q))
		{
				$q1 = dbi_query("SELECT * FROM PRESTATIONS_MODIF WHERE presta_id = ".$prest['presta_id']." AND start <= '".$date."' order by start, modif_id ") ;
				while ($m = dbi_fetch_row($q1))
				{
					
					$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'] ;	
				}
			
				echo $i.' $$ '.$prest['presta_id'].' ** '.$prest['client_id'].' ** '.$prest['presta_jour'].' ** '.$prest['salarie_id'].'<br>';
			
			++$i;
			
		}	

?>