<?php
include_once 'code/init.php';
print_header ('','<base target="ident">','style="margin-top:10px; margin-bottom:0px;background:#E6F4FF"');
$q4 = dbi_query("SELECT * FROM ".TABLE_CLIENT." where agence_id=$agence  AND client_actif='0'  ");
?>
  <table width="100%">
<h3>
	<tr>
      <td width="10%" class="td_listing1b" valign="top">client</td>
      <td width="15%" class="td_listing1b" valign="top">Intervenant</td>
      <td width="15%" class="td_listing1b" valign="top">Presta jour</td>
	  <td width="15%" class="td_listing1b" valign="top">Dure</td>
	  <td width="10%" class="td_listing1b" valign="top">Taux Horaire</td>
    </tr>
<?php
	while($clien = dbi_fetch_row($q4))
{

//	echo "B".$clien['client_nom'];
//$q = dbi_query("SELECT *, IF((p.presta_date_fin is NULL),0,1) as finie FROM ".TABLE_PREST." p,  ".TABLE_CLIENT." c where p.agence_id=$agence  AND p.client_id=".$clien['client_id']." AND p.presta_id NOT IN (select new_presta_id from ".TABLE_EXCEPT." WHERE new_presta_id IS not null) AND (p.presta_date_fin is NULL  ) AND presta_recur = '1' ORDER BY finie, presta_recur DESC, presta_jour DESC, presta_date_debut, presta_date_fin");

$q = dbi_query("SELECT * FROM ".TABLE_PREST." p where p.client_id=".$clien['client_id']." AND p.agence_id=$agence AND p.presta_date_fin is NULL  ");
	$date = time2int($time) ;

	while($prest = dbi_fetch_row($q))
	{

		$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 = ".$prest['presta_id']." order by `start`, `date`") ;
		while (($m = dbi_fetch_row($q1)) )
		{
			$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")) ;
		$jour = '' ;

	 echo '<tr>';
?>

      <td valign="top" class="<? echo $style; ?>"><A ><?=ucwords($clien['client_nom'].' '.$clien['client_pnom'])?></A></td>
      <td nowrap="nowrap" valign="top" class="<? echo $style; ?>">
      <A ><?=ucwords($inter['inter_nom'].' '.$inter['inter_pnom'])?></A></td>
      <td nowrap="nowrap" valign="top" class="<? echo $style; ?>"><b>
      <?=presta_jour2jour($data['jour'])?></td>
      <td nowrap="nowrap" valign="top" class="<? echo $style; ?>"><b>
        <?=$data['duree']/60?> h</td>
		<td nowrap="nowrap" valign="top" class="<? echo $style; ?>" ><b>
        <?=number_format($data['taux'], 2, ',', ' ')?> &euro; / h</td>
</tr>
				
<?php

    }
 }
?>
</table>