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

$salarie_id  = 2543 ;
$_SESSION['page_name']= basename($_SERVER['PHP_SELF']);


	$q = dbi_query("
							
							SELECT * FROM PRESTATIONS p where   salarie_id = $salarie_id  and `presta_date_fin` IS NULL" );
							
							
							
							// echo "
							// SELECT * FROM PRESTATIONS p where   salarie_id = $salarie_id " ; 
							
							
							
							
							// exit() ; 
							
							
							
								while($prest = dbi_fetch_row($q))
							{		
									$date_presta_sem = $prest['presta_date_debut'] ;
									$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'])
									while (($m = dbi_fetch_row($q1)))
									{
										if( $m['presta_sem'] != NULL ) $date_presta_sem = $m['start'];
										$prest['salarie_id'] = $m['salarie_id'] === NULL ? $prest['salarie_id'] : $m['salarie_id'] ; 
										$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_Hduree'] = $m['presta_Hduree'] === NULL ? $prest['presta_Hduree'] : $m['presta_Hduree'] ;
									}
									if( $prest['salarie_id'] == $salarie_id ) {
										
										// echo "<pre>" ; 
										// print_r($prest) ; 
										// echo "</pre>" ; 
										
										
										$a[] = $prest ; 
									
								}
							}
							
						echo " test " ; 

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