<?php
if (!empty($_POST))
define('FERMER',true);
include_once 'code/init.php';

print_header ();
// print_r($_GET);

// echo" ===> ".$_GET['client_id'] ; 
if(isset($_GET['client_id']))
$client_id = @getGetValue('client_id');
$contact = $contact_id ? dbi_fetch_row(dbi_query("SELECT * FROM ".contacts." WHERE contact_id = $contact_id")) : array() ;
if(isset($_GET['id']))
{
$contact_id = @getGetValue('id');
$contact = $contact_id ? dbi_fetch_row(dbi_query("SELECT * FROM ".contacts." WHERE contact_id = $contact_id")) : array() ;

// print_r($contact);
}

	if(!empty($_POST['aad']))
	{
	// echo " $agence ? $client_id";
	$client_id = @getPostValue('client_id');
	// echo "====================> $client_id <br/>" ; 
	$contact_id = @getPostValue('contact_id');
	$nom = strtoupper(getPostValue('nom'));
	$prenom = strtoupper(getPostValue('prenom'));
	$fonction = strtoupper(getPostValue('fonction'));
	$tel1 = getPostValue('tel1');
	$mail = getPostValue('mail');
	$mail = getPostValue('mail');
	
	
	dbi_query ("UPDATE prospect SET 
prospe_email="."'$mail'"." 
, prospe_tel="."'$tel1'"." 

 where prospe_id=$client_id");
 
 
 // UPDATE prospect SET prospe_nom='' , prospe_email='' , prospe_tel='kkkk' where prospe_id=
 // exit() ; 

	// if(empty($contact_id))
// dbi_query ( "INSERT INTO ".contacts." ( contact_id ,	client_id ,	agence_id ,	nom ,	prenom ,	fonction ,	tel1 ,	tel2 ,	mail ) 
	// VALUES ('', '$client_id', '$agence', '$nom', '$prenom', '$fonction', '$tel1', '$tel2', '$mail')");
	// else
	// dbi_query ( "update ".contacts." SET nom="."'$nom'"." ,	prenom="."'$prenom'"." ,	fonction="."'$fonction'"." ,tel1="."'$tel1'"." ,tel2="."'$tel2'"." ,mail="."'$mail'"." WHERE  contact_id = $contact_id ");
	
	}
?>
<table>
<tr>
<td class="tdl">
<div id="frm" style="float:left;" >
<div id="sb" >
<form  method="post" action="" > 
<?php 
if(isset($_GET['action']) && $_GET['action'] == 'new')
   echo "<h3>Ajouter un Contact</h3>";
   else
   echo "<h3>Modifier un Contact</h3>";
?>
    

   <table>
   <tr>
   <input type="hidden" name="client_id" value="<?=$client_id?>">
   <input type="hidden" name="contact_id" value="<?=$contact_id?>">
<td class="tdl"><label for="nom" >Nom : </label></td>
<td colspan="3" class="tdl"><input type="text" name="nom" id="nom" value="<?=$contact['nom']?>" class="field required"   /></td>
   </tr>

    <tr>
<td class="tdl"><label for="login_username" >Tel1 :</label></td>
<td class="tdl"><input type="text" name="tel1" id="tel1" value="<?=$contact['tel1']?>" class="field required"  /></td>
  </tr>
   <tr>
<td class="tdl"><label for="login_username" >Mail :</label></td>
<td colspan="3" class="tdl"><input type="text" name="mail" id="mail" value="<?=$contact['mail']?>" class="field required" size="80" maxlength="200" /></td>
   </tr>     
   <tr>
	   <td class="tdl"></td>
	   <td class="tdl"></td>
	   <td class="tdl" colspan="2"><input name="aad" type="submit" value="Valider" style="float:right;padding-top:0;" class="blubutton"  /></td>
	   
   </tr>
</table>  
</form>
</div>
</div>
</td>
</tr>
</table>



</body>
</html>