<?php
include_once 'code/init.php';
print_header ( );

 // echo "test <br/>" ;
// exit() ;  
// echo '<pre>';
// print_r($_SESSION);
// echo '</pre>';
// echo "tsto <br/>" ; 


	// $prest_q = dbi_query("SELECT * FROM ".TABLE_PREST." p
// WHERE p.agence_id=$agence
// AND (
	// p.presta_date_fin is null
	// OR p.presta_date_fin >= $today
// )
// AND (
	// OR EXISTS(
		// SELECT * FROM ".TABLE_PRESTA_MODIF." pm
		// WHERE  p.presta_id = pm.presta_id
	// ) ") ; 
// ) AND p.presta_id NOT IN (
	// SELECT DISTINCT new_presta_id FROM ".TABLE_EXCEPT." e, ".TABLE_PREST." p
	// WHERE e.new_presta_id is not null
	// AND e.presta_id=p.presta_id
	// AND (
		// inter_id = $interv
		// OR EXISTS(
			// SELECT * FROM ".TABLE_PRESTA_MODIF." pm
			// WHERE pm.inter_id is not null
			// AND p.presta_id = pm.presta_id
			// AND inter_id = $interv
		// )
	// )
// )") ;

$sem = array ('Dimanche', 'Lundi', 'Mardi', 'Mercredi', 'Jeudi', 'Vendredi', 'Samedi') ;

?>

	<div id="tab"  >
<TABLE width="95%" border="1px">
<thead>
<TR>
  <th >Nom Client</th>
  <th>jour  prestation </th>
  <th> l'heure de début </th>  
  <th>l'heure de fin </th>  
  


 
  

</TR>
</thead>
    <tbody>
<?php 
//  reqet des avoire 
 $today = date("Ymd");

// SELECT *  FROM  prestation WHERE  presta_date_fin IS NULL 

// SELECT * FROM prestation p WHERE p.agence_id=47 AND ( p.presta_date_fin is null OR p.presta_date_fin >= 20160419 ) OR EXISTS( SELECT * FROM presta_modif pm WHERE p.presta_id = pm.presta_id )
$q =  dbi_query("SELECT * FROM prestation p , client c 
WHERE p.agence_id= 47  AND p.`client_id` = c.`client_id` 
AND ( (
	p.presta_date_fin is null
	OR p.presta_date_fin >=  $today
)

AND $today  > p.presta_date_debut

AND `presta_forfait` = 0 

 )ORDER BY c.client_nom") ; 
	
// $q=dbi_query("SELECT *  FROM prestation p, client c WHERE ( presta_date_fin IS NULL  OR presta_date_fin >20160418 ) AND ( p.agence_id =47 AND p.`client_id` = c.`client_id` )ORDER BY c.client_nom  ") ; 


// $avoirJanvier = 0  ;  $avoirFevrier = 0 ; $avoirMars = 0 ; $avoirAvril = 0 ; $avoirMai = 0 ; $avoirJuin = 0 ; $avoirjuillet = 0 ; $avoirAout = 0 ; $avoirSeptember = 0 ; $avoirOctober = 0 ; $avoirNovember = 0 ; $avoirDecember= 0 ;
// $i=0 ; 

	$jour = date('w') ;
	$time = time() ;
	while($jour != 0)
	{
		$jour = ++$jour %7 ;
		$time += 24*3600 ;
	}
	$date = time2int($time) ;

while($aa=dbi_fetch_row($q))
{
	// $i = $i + 1 ; 
	
	// echo "$i" ; 
	 // list($ID )= dbi_fetch_row(dbi_query("SELECT ID  FROM `fact_chantier` WHERE `Chantier_ID` =  ".$aa['chantier_id'])) ; 
    list($chant,$ID) =dbi_fetch_row(dbi_query("SELECT Chantier_forfaitmensuel , ID FROM chantier c, fact_chantier fc WHERE agence_id=".$agence." AND client_id=".$aa['client_id']." AND c.Chantier_ID=fc.Chantier_ID AND (Chantier_fin = 0 OR Chantier_fin >=$today )ORDER BY fc.Chantier_designation   "));  
	$client_id = $aa['client_id'] ; 
	$chantt=dbi_fetch_row(dbi_query("SELECT * FROM chantier c, fact_chantier fc WHERE agence_id=".$agence." AND client_id=".$client_id." AND c.Chantier_ID=fc.Chantier_ID AND (Chantier_fin = 0 OR Chantier_fin >=$today )ORDER BY fc.Chantier_designation  "));
	
	// list($nom,$prenom)= dbi_fetch_row(dbi_query(" SELECT client_nom, client_nom  FROM client WHERE client_id = ".$aa['client_id'])) ; 
    // echo "$ID --$chant <br/> " ; 
	list($nomS,$prenomS)= dbi_fetch_row(dbi_query(" SELECT inter_nom, inter_pnom  FROM intervenant WHERE inter_id = ".$aa['inter_id'])) ; 
	
	// $marge2=dbi_query("SELECT * FROM marge WHERE client_id=".$aa['client_id']." and chantier_id= ".$chantt['ID']);
	
	// echo "--- $fctM  <br/> " ;
		$SMA=0;
		$SDA=0;
		$taux =0; 
     
		while ($M2 = dbi_fetch_row($marge2)) {
				
		$SMA += $M2['mont_ann'];
		$SDA += $M2['duree_ann'];
		// echo "--- $SMA  <br/> " ;
		}
		// echo " <br/>".$c['Chantier_forfaitmensuel'].' ? '." $SMA / $SDA ";
		if($SDA>0)
		$taux = (($chantt['Chantier_forfaitmensuel']*12)-($SMA)) / $SDA;
	// echo "--".$chant; 
	
			$data = array('jour' => $prest['presta_jour'], 'deb' => $prest['presta_Hdeb'], 'duree' => $prest['presta_Hduree'], 'inter' => $prest['inter_id'], 'taux' => $prest['presta_forfait']) ;
		$q1 = dbi_query("SELECT * FROM ".TABLE_PRESTA_MODIF." WHERE presta_id = ".$aa['presta_id']." order by `start`, `date`") ;
		while (($m = dbi_fetch_row($q1)) && $date >= $m['start'])
		{
			$data['jour'] = $m['jour'] === NULL ? $data['jour'] : $m['jour'] ;
			$data['deb'] = $m['Hdeb'] === NULL ? $data['deb'] : $m['Hdeb'] ;
			$data['duree'] = $m['Hduree'] === NULL ? $data['duree'] : $m['Hduree'] ;
			$data['inter'] = $m['inter_id'] === NULL ? $data['inter'] : $m['inter_id'] ;
			$data['taux'] = $m['taux'] === NULL ? $data['taux'] : $m['taux'] ;
		}
		$inter = dbi_fetch_row(dbi_query("SELECT * FROM ".TABLE_INTERV." WHERE inter_id = '".$data['inter']."' AND agence_id = $agence")) ;
		
		
		if(!empty($inter))
		{
			
			$nomS=  $inter['inter_nom'] ; 
			 $prenomS = $inter['inter_pnom'] ; 
		}
		
		list($too)=dbi_fetch_row(dbi_query("select taux from OOO where client_id = ".$aa['client_id'])) ; 
	?>	
<TR>

  
  <TD><A href="top.php?link=client&amp;page=aac2&amp;id=<?=$aa['client_id']?>" target="ident"><?=strtoupper($aa['client_nom']).' '.ucwords(strtolower($aa['client_pnom']))?></A></TD>
  
  
  <td> <?= $sem[strpos($aa['presta_jour'], 'y')]?> </td>
  <td > <?=int2heure($aa['presta_Hdeb'])?> </td>
  <td><?=int2heure(addDuree($aa['presta_Hdeb'], $aa['presta_Hduree'])) ?>  </td>  



   
  </TR>
<?
}




	?>

	<div id="tab"  >


</div>
</div>

</body></html>