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

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

// exit() ;

$taille = sizeof ($_POST) ;


// echo "=========> $taille <br/>" ; 




// foreach ($_POST as $v) {
    // echo "Valeur courante de \$_POST: $v.\n";
// }

// if()
foreach ($_POST as $key => $value) {
    // $arr[3] sera mis à jour avec chaque valeur de $arr...
	
	// $idpresta = $key  ;  
	// $tauxpresta  = $value  ; 
	
	// echo " $idpresta ========> $tauxpresta <br/> " ; 
    // echo "{$key} => {$value} ";
    // print_r($_POST);
	
	dbi_query("UPDATE prestation SET presta_forfait = '$value' WHERE presta_id = $key") ; 
}



// 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">
<form method="POST" action="">
<thead>
<TR>
  <th >Nom Client</th>
  <th>jour  prestation </th>
  <th> l'heure de début </th>  
  <th>l'heure de fin </th>  
  <th > nom du salarié </th>  
  <th > taux horaire </th>  
  <th > taux horaire 1 </th>  
    <th >  presta_id  </th>  
	<th >  Action  </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

 )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'])) ; 
	
	
	
	
	
	
	$chantt=dbi_fetch_row(dbi_query("SELECT *, fc.ID FROM chantier c, fact_chantier fc , prestation p  WHERE c.agence_id=".$agence." AND c.client_id=".$client_id." AND c.Chantier_ID=fc.Chantier_ID AND fc.ID = p.chantier_id    AND presta_id = ".$aa['presta_id']." AND Chantier_forfaitmensuel !=0 AND (Chantier_fin = 0 OR Chantier_fin >=$today )ORDER BY fc.Chantier_designation  "));
	
	// echo "SELECT *, fc.ID FROM chantier c, fact_chantier fc , prestation p  WHERE c.agence_id=".$agence." AND c.client_id=".$client_id." AND c.Chantier_ID=fc.Chantier_ID AND fc.ID = p.chantier_id    AND presta_id = ".$aa['presta_id']." AND Chantier_forfaitmensuel !=0 AND (Chantier_fin = 0 OR Chantier_fin >=$today )ORDER BY fc.Chantier_designation <br/> " ; 
	// echo "SELECT * FROM chantier c, fact_chantier fc , prestation p  WHERE c.agence_id=".$agence." AND c.client_id=".$client_id." AND c.Chantier_ID=fc.Chantier_ID AND fc.ID = p.chantier_id    AND presta_id = ".$aa['presta_id']." AND (Chantier_fin = 0 OR Chantier_fin >=$today )ORDER BY fc.Chantier_designation  <br/> " ; 
	
	// echo "==> ".$chantt['ID']." ==>  ".$chantt['Chantier_forfaitmensuel']." ===> ".$aa['presta_id']."<br/>" ; 
	
	if(!empty($chantt['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'])) ; 
	if($aa['presta_forfait'] != number_format($taux, 2, ".", " ")  or $aa['presta_forfait'] == 0 )
{
	?>	
<TR>
  <td ><?=$aa['client_nom']." ".$aa['client_pnom']?></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>  
   <td ><?=$nomS." ".$prenomS?></td>
  <td > <?=$aa['presta_forfait']?> </td>  
  <td > <?=number_format($taux, 2, ",", " ")?> </td>  
<td > <?=$aa['presta_id']?> </td> 

<?
if($aa['presta_forfait'] == number_format($taux, 2, ".", " "))
{
	?>
<td > V </td> 
<?
}
else
{
?>
<td > <input type="checkbox" name="<?=$aa['presta_id']?>" value="<?=$taux?>" >  </td> 
<?
}
?>
  </TR>

<?
}
}




	?>
	</table>
<br/>
    <input align="center" type="submit" value="Submit"  style="width:230px" >
	  </form>

</div>

</body></html>