<?php
include_once 'code/init.php';
// echo "cc <br/>" ;

if(!empty($_POST))
{
	$from = getPostDate('from') ;
	$to = getPostDate('to') ;
	$q = dbi_query("SELECT * FROM ".TABLE_PAIEMENT." p LEFT JOIN ".TABLE_CLIENT." c USING(client_id) where  p.agence_id='$agence'  and date between $from and $to order by date DESC ") ;

}
	// echo "$from <br/>" ;
	// echo "$to <br/>" ; 
print_header ();

?>
<form action="" method="post" name="paye">
<table>
	<tr>
		<td>Du</td>
		<td><?=print_date_selection('from', $fact_du, -5, 10, 'paye')?></td>
	</tr>
	<tr>
		<td>Au</td>
		<td><?=print_date_selection('to', $fact_au, -5, 10, 'paye')?></td>
	</tr>
	</table>
	<input type="submit" class="bigbutton" value="Cr&eacute;er" onClick="this.disabled=true;this.form.submit();">
</form>
	<?
	
	
?>
	<div id="tab"  >
	<table align="left" width="100%">
        <tr>
			 <th width="20%" align="center">BQ</th>
			 
			 
			 <th width="20%" align="center">Date</th>
			 
			 <th width="60%" align="center">Client</th>
			 <th width="20%" align="center">Montant</th>
			 <th width="20%" align="center">N Compte Client</th>
<th width="20%" align="center">Type de reglement </th>			 
		 </tr>
<?php
  while($f = dbi_fetch_row($q))
	{
	// echo "==>".$f['reglement_id']."<br/>" ; 
	if(!empty($f['reglement_id']))
{
	list($typ_r) = dbi_fetch_row(dbi_query(" SELECT reglement_desc FROM reglement where reglement_id =".$f['reglement_id']));
}
	?>
        <tr>
			
			 <td align="center"><h3>BQ</h3></td>
			  
			 
			 <td align="center"><h3><?=int2date($f['date'])?></h3></td>
			 <td align="left"  rowspan="<?=$nb?>" style="padding:8px;vertical-align:top;"><h3><a href="top.php?link=client&amp;page=aaa&amp;id=<?=$f['client_id']?>" target="ident">
            <?=strtoupper($f['client_nom']).' '.ucwords(strtolower($f['client_pnom']))?></h3></td>
			 <td align="center"><h3><?=number_format($f['montant'], 2, ', ', ' ').' &euro;'?></h3></td>	
			 <td align="center"><h3><?=$f['client_numexport']?></h3></td>
			 <td align="center"><h3><?=$typ_r?></h3></td>
		 </tr> 
<?php } ?>
	</table>
</div>