<?php
include_once 'code/init.php';
print_header ('', '', $BodyX );
// echo " + ".$_SESSION['admin']."+";
$agence=$_SESSION['agence'];
// for ($l = 'A' ; strlen($l) == 1 ; $l++)
	// echo "<a href=\"a.php?col=-2&val=$l\">$l</a> " ;
	// echo "<a href=\"a.php\">Voir la liste complète</a> " ;	
	
	
	// echo "<pre>" ; 
	// print_r($_GET) ; 
	// echo "<pre>" ; 
	
	// exit() ; 
	
	
?>





<form action="" method="get" style="margin-top:10px">

<?php

if($_GET['client_actif']=='on' || $_GET['client_actif']=='off' ) $_SESSION['client_actif']=$_GET['client_actif'];
	$where1="";
	$where2="";
	$selected="";
if($_GET['idbureausel'] && !empty($_GET['idbureausel']) )
{
   if($_GET['idbureausel']>0)
	{
		$idbureausel=$_GET['idbureausel'];
		$tabbursel=dbi_fetch_row((dbi_query('select * from bureau where id_bureau='.$_GET['idbureausel'].' and agence_id='.$agence.''))) ;
		$id_bureau=$tabbursel['id_bureau'];
		$nom_bureau=$tabbursel['nom_agence'];
		$where1=" AND ID_Bureau != $id_bureau ";
		$where2=" AND client_bureau = $id_bureau ";
    }
	elseif($_GET['idbureausel']=="INDEFINI")
	{
	$id_bureau=$_GET['idbureausel'];
	$where2=" AND client_bureau='0' ";
	$selected='selected="selected"';
	}
}
?>

</form>


<script language="Javascript">
   function GetIdBureau()
   {
		var idbursel="";
  	  idbureausel = document.bureau_form.client_bureau.value ;
	if( idbureausel > 0 || idbureausel=="INDEFINI" )
	  window.location = "prospPP.php?idbureausel="+idbureausel;
	  	else
	window.location = "prospPP.php";
   }
</script>

<form action="" method="get" style="margin-top:10px">

<?php
// Zones :
// for ($i = 1 ; $i <= 12 ; $i++)
	// printf('<input type="checkbox" name="zone[]" value="%1$X"%2$s> %1$d ', $i, !empty($_GET['zone']) && in_array(strtoupper(dechex($i)), $_GET['zone']) ? ' checked' : '') ;

// Lister les intervenants actifs ou non actifs.	
if($_GET['client_actif']=='on' || $_GET['client_actif']=='off' ) $_SESSION['client_actif']=$_GET['client_actif'];
	$where1="";
	$where2="";
	$selected="";
if($_GET['idbureausel'] && !empty($_GET['idbureausel']) )
{
   if($_GET['idbureausel']>0)
	{
		$idbureausel=$_GET['idbureausel'];
		$tabbursel=dbi_fetch_row((dbi_query('select * from bureau where id_bureau='.$_GET['idbureausel'].' and agence_id='.$agence.''))) ;
		$id_bureau=$tabbursel['id_bureau'];
		$nom_bureau=$tabbursel['nom_agence'];
		$where1=" AND ID_Bureau != $id_bureau ";
		$where2=" AND client_bureau = $id_bureau ";
    }
	elseif($_GET['idbureausel']=="INDEFINI")
	{
	$id_bureau=$_GET['idbureausel'];
	$where2=" AND client_bureau='0' ";
	$selected='selected="selected"';
	}
}
?>

	<!--<br><input type="radio" Onclick="submit()" value="on" name="client_actif" <?//=($_SESSION['client_actif'] == 'on' || !isset($_SESSION['client_actif']))  ? 'checked' : ''?> >Clients actifs
	<input type="radio" Onclick="submit()" value="off" name="client_actif" <?//=$_SEION['client_actif'] == 'off' ? 'checked' : ''  ?>>Tous -->

	
	
	<br/><br/><br/><br/><br/>
	
	</form>

	
<?
if (empty($_GET['val']) || !isset($_GET['col']))
{
	$_GET['col'] = -1 ;
	$_GET['val'] = '' ;
}
error_reporting(E_ALL|E_STRICT) ;
$cols = array('client_nom', 'client_cp', 'client_ville', -1 => '', -2 => 'client_nom') ;
$soundex = array (1, 0, 1, -1 => 2, -2 => 3) ;
$tel = array('client_teldom', 'client_teldom', 'client_telport1', 'client_telpro') ;
$s = '$s' ;
$queries = array("(SELECT *, 1 AS exact, IF(client_genre='SERENA',1,0) as serena, IF(client_genre='FORMATION',1,0) as formation FROM ".TABLE_CLIENT." WHERE %s = '%s' AND client_genre NOT LIKE 'FORMATION' $where2 AND agence_id=$agence%3\$s ".( isset($_SESSION['client_actif'])&&$_SESSION['client_actif']=='off' ? "AND client_actif='1" : " AND client_actif='0' AND   client_prospect ='1' ").") UNION (SELECT *, 0 AS exact, IF(client_genre='SERENA',1,0) as serena, IF(client_genre='FORMATION',1,0) as formation FROM ".TABLE_CLIENT." WHERE %1\$s LIKE '%%%2$\s%%' AND %1\$s != '%2\$s' AND client_genre NOT LIKE 'FORMATION' $where2 AND agence_id=$agence%3\$s ".( isset($_SESSION['client_actif'])&&$_SESSION['client_actif']=='off' ? "AND client_actif='1'" : " AND client_actif='0' AND   client_prospect ='1' ").")", "(SELECT *, 1 AS exact, IF(client_genre='SERENA',1,0) as serena, IF(client_genre='FORMATION',1,0) as formation FROM ".TABLE_CLIENT." WHERE %s = '%s' AND client_genre NOT LIKE 'FORMATION' $where2 AND agence_id=$agence%3\$s ".( isset($_SESSION['client_actif'])&&$_SESSION['client_actif']=='off' ? "AND client_actif='1'" : " AND client_actif='0' AND   client_prospect ='1'").") UNION (SELECT *, 0 AS exact, IF(client_genre='SERENA',1,0) as serena, IF(client_genre='FORMATION',1,0) as formation FROM ".TABLE_CLIENT." WHERE (%1\$s LIKE '%%%2\$s%%' OR soundex(%1\$s) = soundex('%2\$s')) AND %1\$s  != '%2\$s' AND client_genre NOT LIKE 'FORMATION' AND agence_id=$agence%3\$s ".( isset($_SESSION['client_actif'])&&$_SESSION['client_actif']=='off' ? "AND client_actif='1'" : " AND client_actif='0' AND   client_prospect ='1' ")." )", "SELECT *, 1 AS exact, IF(client_genre='SERENA',1,0) as serena, IF(client_genre='FORMATION',1,0) as formation FROM ".TABLE_CLIENT." WHERE client_prospect ='1' AND agence_id=$agence%3\$s AND client_genre NOT LIKE 'FORMATION' $where2 ".( isset($_SESSION['client_actif'])&&$_SESSION['client_actif']=='off' ? "AND client_actif='1'" : " AND client_actif='0' AND   client_prospect ='1' "), "SELECT *, 1 AS exact, IF(client_genre='SERENA',1,0) as serena, IF(client_genre='FORMATION',1,0) as formation FROM ".TABLE_CLIENT." WHERE %1\$s LIKE '%2\$s%%' AND client_genre NOT LIKE 'FORMATION' AND agence_id=$agence%3\$s $where2".( isset($_SESSION['client_actif'])&&$_SESSION['client_actif']=='off' ? "AND client_actif='1'" : " AND client_actif='0' AND   
µ§ ='1' ")." ") ;
$tri="client_id, client_nom, client_adr1, exact";
$ordre='desc';
if(!empty($_GET['tri']) && !empty($_GET['ordre']))
{
$tri='client_'.$_GET['tri'].' '.$_GET['ordre'];
	if($_GET['ordre']=='asc')
		$ordre='desc';
	else
		$ordre='asc';
}
else
{
$tri=" client_nom asc ";
}


// echo "<pre>" ; 

// print_r($_GET) ; 
// echo "</pre>" ; 



$q = dbi_query("SELECT * FROM client where client_id not in (SELECT client_id FROM contacts_2) and client_actif = '0' and agence_id = $agence ORDER BY client_bureau ,client_nom  ") ;
 
 
 
 
 // $q = dbi_query(" select * from client where client_actif =  '0'
// AND client_prospect =  '1'
// ORDER BY client_prospect ASC  ") ;
 
  $nombre=0;
 ?>
 <div id="tab">
<TABLE width=100%>
<thead>
<TR>
  <th ><A href="a.php?tri=nom&ordre=<?php echo $ordre?>"style="cursor:pointer; font-weight:bold;color: white; text-decoration:none;text-transform : uppercase;font-size: 14px;" >Nom</A><SPAN class="sort">&uarr;</SPAN></th>
  <th ><A href="#" style="cursor:pointer; font-weight:bold;color: white; text-decoration:none;text-transform : uppercase;font-size: 14px;" >Adresse</A></th>
</TR>
</thead>
    <tbody>
<?
	$compteur=0;
	$previous=1;
	$serena=0;
	$prospect=0;
	while($c = dbi_fetch_row($q)) {
		list($nom_agence) = dbi_fetch_row( dbi_query("SELECT nom_agence FROM  bureau where  id_bureau  = ".$c['client_bureau'])) ; 
	// if($c['client_prospect']== '1'){
		$next=$c['exact'];
		if (!($compteur % 2)) $style='td_listing0';
		else $style='td_listing1';
		

		
		?>

<TR>
  <TD><A href="top.php?link=client&amp;page=aaa&amp;id=<?=$c['client_id']?>" target="ident"><?=strtoupper($c['client_nom']).' '.ucwords(strtolower($c['client_pnom']))?></A></TD>
  <TD><?=$nom_agence?></TD>
</TR>
<?


} ?>



    </tbody>
</table>


</div>
<br/>
<?php
// $nombre=mysql_num_rows($q);

?>



</body>
</html>