<?php

include 'includes/config_tmcpro.php' ;
include 'includes/stable_functions_tmcpro.php' ;
$pagemenu = basename($_SERVER["PHP_SELF"]) ;
// echo "<pre>" ; 
// prinhht_r($_GET) ; 
// echo "</pre>" ; 
// exit() ;



function get_lat_long($address){

    $address = str_replace(" ", "+", $address);

    /*$json = file_get_contents("https://maps.google.com/maps/api/geocode/json?address=$address&sensor=false&key=AIzaSyC4HqZf-zANxtQqW0riYOrRKdrXvzMqCqM");
    $json = json_decode($json);

    $lat = $json->{'results'}[0]->{'geometry'}->{'location'}->{'lat'};
    $long = $json->{'results'}[0]->{'geometry'}->{'location'}->{'lng'};
    return $lat.','.$long;
*/


    $url = "https://maps.google.com/maps/api/geocode/json?key=AIzaSyC4HqZf-zANxtQqW0riYOrRKdrXvzMqCqM&address=".urlencode($address);

$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);    
$responseJson = curl_exec($ch);
curl_close($ch);

$response = json_decode($responseJson);

if ($response->status == 'OK') {
    $latitude = $response->results[0]->geometry->location->lat;
    $longitude = $response->results[0]->geometry->location->lng;

   /* echo 'Latitude: ' . $latitude;
    echo '<br />';
    echo 'Longitude: ' . $longitude;
   */ return $latitude.','.$longitude;

} /*else {
    echo $response->status;
    var_dump($response);
} */
}



if(!empty($_GET['client_id']))
{
$_SESSION["client_id"]=$_GET['client_id'];

}
 $cleint_id=$_SESSION["client_id"] ; 
$client_id = $_SESSION["client_id"] ;
$_SESSION["cleint_id"]= NULL ; 

			 // if(!empty($_POST))
			 // {

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

			 // }
			 
			 
			 // ****************************************************** la partie contact ****************************************************************
			 
			                   	if($_GET['action']=='sup')
	    {
			$contact_id=$_GET['id']; 
			
	$sreussie=dbi_query("DELETE FROM ".contact." WHERE contact_id = $contact_id") ;
	
	 header('Location:profilprosepct.php?msg=contact bien supprimé&color=success');

	 
		}
		
		if($_POST['modifier']== "modifier" )
		{
	   

				 
		$contact_nom=addslashes($_POST['contact_nom']);
		$contact_pnom=addslashes($_POST['contact_pnom']);
		$contact_fonction=addslashes($_POST['contact_fonction']);
		$contact_tele1=addslashes($_POST['contact_tele1']);
		$contact_tele2=addslashes($_POST['contact_tele2']);
		$contact_email=addslashes($_POST['contact_email']);
				 
				dbi_query(" UPDATE contact SET contact_nom = '$contact_nom', contact_pnom = '$contact_pnom',  contact_fonction = '$contact_fonction', `contact_tele1` = '$contact_tele1', contact_tele2 = '$contact_tele2', contact_email = '$contact_email' WHERE contact_id = ".$_POST['contact_id']);
		
		header('Location:profilprosepct.php?msg=contact bien Modifié&color=success');
		} 
	
	
	
	
	             
			 $qq =dbi_query("SELECT * FROM `categorie`") ; 
			 
			 
			 if($_POST['ajouter_contact']== "ajouter_contact")
			 {

		 // echo "$cleint_id <br/>" ; 
                       $contact_nom=$_POST['contact_nom'] ; 
					    $contact_pnom=$_POST['contact_pnom'] ; 
						$contact_fonction=$_POST['contact_fonction'] ; 
						$contact_tele1=$_POST['contact_tele1'] ; 
						$contact_tele2=$_POST['contact_tele2'] ; 
						$contact_email=$_POST['contact_email'] ;  
					
					
					dbi_query(" INSERT INTO  contact (
					contact_nom, 
					contact_pnom,
					contact_fonction, 
					contact_tele1,	
					contact_tele2,	 
					contact_email,
					client_id					
 )
 VALUES 
 (
 
 '$contact_nom',
 '$contact_pnom',
 '$contact_fonction',
 '$contact_tele1',
 '$contact_tele2',
 '$contact_email',
 '$client_id'
)") ;
		
	header('Location:profilprosepct.php?msg=contact bien ajouté&color=success');
		}
			 
			
			 
			 //***************************************************  ENd end partie contact end *************************************************************************
			 
			 
			 
			 
			 
			 
			 
			 

	                  //*****************************************************************modifier prosepecte **************************************************************************

	
																					 if($_POST['modifier_prospect']== "modifier_prospect")
																		 {
																			 // echo "bbb <br/>" ;
																			 // exit() ;
																					   $client_statut=$_POST['cleint_satatu'] ; 
																					$id_Etablissement=$_POST['etab'] ; 
																					$societe=addslashes($_POST['societe']) ; 
																					$id_Categorie=addslashes($_POST['cleint_categorie']) ; 
																					$client_adr1=addslashes($_POST['adr1']) ; 
																					$client_adr2=addslashes($_POST['adr2']) ; 
																					$client_adr3=addslashes($_POST['adr3']) ; 
																					$client_cp=$_POST['cp'] ; 
																					$client_ville=addslashes($_POST['ville']) ; 
																					$client_tele=$_POST['tele'] ; 
																					$client_fax=$_POST['fax'] ; 
																					$client_adrfact=addslashes($_POST['client_adrfact']) ; 
																					
																					
																	 $latlong    =   get_lat_long($_POST['adr1']); 
																	 $map        =   explode(',' ,$latlong);
																	 $mapLat         =   $map[0];
																	 $mapLong    =   $map[1]; 
																					
																				
																					
																					
																					dbi_query( " UPDATE client
															SET client_nom = '$societe', client_adr1 = '$client_adr1',
															  client_adr1 = '$client_adr1',
															  client_adr2 = '$client_adr2',
															  client_adr3 = '$client_adr3',
															  client_cp =   '$client_cp',
															  client_ville = '$client_ville',
															  client_statut = '$client_statut',
															  etablissement_id = '$id_Etablissement',
															  categorie_id  = '$id_Categorie',
															  client_tele  = '$client_tele',
															  client_fax  = '$client_fax',
																latitude    ='$mapLat',
															  longitude	  ='$mapLong'
															WHERE client_id = $cleint_id ") ; 

																$q= dbi_fetch_row(dbi_query("SELECT * FROM client where client_id = ".$cleint_id)) ; 
																header('Location:profilprosepct.php?msg=Prospect bien modifié&color=success');
																		 }
																
                         //*****************************************************************end **************************************************************************

  //***************************************************************************************  modifier document  **************************************************************************


if($_POST["Modifier_document"]== "Modifier_document"){
	 // echo "aa <br/>" ; 
  if (!file_exists($_FILES['file']['tmp_name']) || !is_uploaded_file($_FILES['file']['tmp_name'])) 
  {
	  
	  
	  	// echo "<pre>" ; 
	// print_r($_POST) ; 
	// echo "<pre>" ; 
	
	// exit() ; 
	
	
	  
  $document_id=$_POST['document_id'] ;
						$document_nom=$_POST['document_nom'] ;

					
					    	


	// dbi_query("INSERT INTO document_client (
						
						// document_nom,
						// client_id,
						// document_visibilite,
						// date_document,
						// document_emplacement )
						
						// VALUES (
						
						// '$document_nom', 
						// '$client_id', 
						// '$document_visibilite',
						// '$date_document',
						// '$target_file'
						
					    // )") ; 

						
									
					
						dbi_query("
						
						UPDATE document_client SET 
						document_nom = '$document_nom',
						
					
                        client_id = '$client_id'
						WHERE document_id = '$document_id'
						
					    ") ; 
						header('Location:profilprosepct.php?msg=Document bien Modifié&color=success');
  }
  else
  {
	  
	  				  				  $target_dir = "documents/clients/";
									  $document_id=$_POST['document_id'] ;

  $target_file = $target_dir."".$document_id."". basename(addslashes($_FILES["file"]["name"]));
  $uploadOk = 1;
  $imageFileType = strtolower(pathinfo($target_file,PATHINFO_EXTENSION));
				 
				 
				 move_uploaded_file($_FILES["file"]["tmp_name"], $target_file) ;
				 
				 // header("location: salarie_document.php?msg=Course added&color=success");
				
				        
						$document_nom= addslashes($_POST['document_nom']) ;
						$document_visibilite=$_POST['document_visibilite'] ;
					
					    					
						
                         

						
					
						dbi_query("
						
						UPDATE document_client SET 
						document_nom = '$document_nom',
						document_emplacement = '$target_file' , 
					
                          client_id = '$client_id'
						WHERE document_id = '$document_id'
						
					    ") ; 
						header('Location:profilprosepct.php?msg=Document bien Modifié&color=success');
						// header("location: course.php");
	  
  
  
  
  }
}









  //***************************************************************************************  l'ajout de document  **************************************************************************


function string2url($chaine) { 
 $chaine = trim($chaine); 
 $chaine = strtr($chaine, "A?A???а?в?????O?????ф???EEEEийклCз??II??опU?UUщ?ыь???","aaaaaaaaaaaaooooooooooooeeeeeeeecciiiiiiiiuuuuuuuuynn"); 
 $chaine = strtr($chaine,"ABCDEFGHIJKLMNOPQRSTUVWXYZ","abcdefghijklmnopqrstuvwxyz"); 
 $chaine = preg_replace('#([^.a-z0-9]+)#i', '-', $chaine); 
        $chaine = preg_replace('#-{2,}#','',$chaine); 
        $chaine = preg_replace('#-$#','',$chaine); 
        $chaine = preg_replace('#^-#','',$chaine); 
 return $chaine; 
}


	if (!is_dir("documents"))
	{
		mkdir("documents", 0755) ;
		chmod("documents", 0755) ;
	}
		if (!is_dir("documents/clients"))
	{
		mkdir("documents/clients", 0755) ;
		chmod("documents/clients", 0755) ;
	}
		if (!is_dir("documents/intervenants"))
	{
		mkdir("documents/intervenants", 0755) ;
		chmod("documents/intervenants", 0755) ;
	}

        $nomrep="documents/clients";
if($_POST["ajouter_document"]== "ajouter_document"){
	
	
	
	
	// echo "<pre>" ; 
	// print_r($_FILES) ; 
	// echo "<pre>" ; 
	
	
	// echo "<pre>" ; 
	// print_r($_POST) ; 
	// echo "<pre>" ; 
	
	
	// exit() ;
	
	       list($document_id)=  dbi_fetch_row(dbi_query( "SELECT max(document_id) FROM `document_client`")) ; 
		  $document_id= $document_id + 1 ; 
				  $target_dir = "documents/clients/";
				  $date_document = date('Ymd');
  $target_file = $target_dir."".$document_id."". basename(addslashes($_FILES["file"]["name"]));
  $uploadOk = 1;
  $imageFileType = strtolower(pathinfo($target_file,PATHINFO_EXTENSION));
				 
				 
				 move_uploaded_file($_FILES["file"]["tmp_name"], $target_file) ;
				 
				 // header("location: salarie_document.php?msg=Course added&color=success");
				
						$document_nom=addslashes($_POST['document_nom']) ;
						$document_visibilite=$_POST['document_visibilite'] ;
					
					    					
									
						
						dbi_query("INSERT INTO document_client (
						
						document_nom,
						client_id,
						document_visibilite,
						date_document,
						document_emplacement )
						
						VALUES (
						
						'$document_nom', 
						'$client_id', 
						'$document_visibilite',
						'$date_document',
						'$target_file'
						
					    )") ; 
						header('Location:profilprosepct.php?msg=Document bien ajouté&color=success');
						
						
						
// $qa1 = dbi_query("SELECT client_nom,client_data FROM ".TABLE_CLIENT." WHERE  client_id=$client ") ;
// $a1=dbi_fetch_row($qa1);
// $data = unserialize($a1['client_data']);

// $nbre_data=count($data);
// $nb_min = 1;
// $nb_max = 10000;
// $nombre = mt_rand($nb_min,$nb_max);
// $client_nom=$a1['client_nom'];
// $desc="";
// if(!empty($_POST['desc']))
// $desc=$_POST['desc'];



// $date_doc = date('Ymd');
// $extension = strrchr($_FILES['doc']['name'], '.');

// $nom_doc=addslashes('client-'.$agence.'-'.$client_nom.''.$nombre.''.$extension.'');

// $nom_doc=string2url($nom_doc);

// if(empty($a1['client_data']))
// $client_data=array(array($nom_doc,$date_doc,$desc));
// else {
// $client_data=$data;
// array_push( $client_data,array($nom_doc,$date_doc,$desc));
// }

// if(move_uploaded_file($_FILES['doc']['tmp_name'] , "$nomrep/".$nom_doc.''))
// dbi_query("UPDATE ".TABLE_CLIENT." SET client_data='".addslashes(serialize($client_data))."' WHERE  client_id=$client ") ;
// else $erreur=true	;
	
	}	



// echo "vvv <br/>" ;
if(isset($_GET['action']) && isset($_GET['id'])&& $_GET['action']=='sup_doc')
{
	// echo "vvvKKKK <br/>" ; 
	// exit(); 
$id=$_GET['id'];
$qa1 = dbi_query("DELETE FROM document_client WHERE document_id = ".$id) ;

$a1=dbi_fetch_row($qa1);
	header('Location:profilprosepct.php?msg=Document bien supprimé&color=success');

}
		
	?>





<!DOCTYPE html>
<html>

<head>

  <meta http-equiv="X-UA-Compatible" content="IE=edge">
 <!-- Enregistrer le titre de la page --><title> LogMCPRO | Client</title>
												<!-- Tell the browser to be responsive to screen width -->
  <meta name="viewport" content="width=device-width, initial-scale=1">

												<!-- Font Awesome -->
  <link rel="stylesheet" href="../../plugins/fontawesome-free/css/all.min.css">
												<!-- Ionicons -->
  <link rel="stylesheet" href="https://code.ionicframework.com/ionicons/2.0.1/css/ionicons.min.css">
												<!-- overlayScrollbars -->
  <link rel="stylesheet" href="../../dist/css/adminlte.min.css">
												<!-- Google Font: Source Sans Pro -->
  <link href="https://fonts.googleapis.com/css?family=Source+Sans+Pro:300,400,400i,700" rel="stylesheet">
    <style>
.myCollapse {
    display: none;
}
.myCollapse.in {
    display: block;
}
  .modal-header {
    padding: 15px;
    border-bottom: 1px solid #e5e5e5;
}
  .modal-header {
    background: #226faa;
    background: -webkit-gradient(linear,left top,right top,from(#226faa),color-stop(37%,#2989d8),to(#72c0d3));
    background: linear-gradient(to right,#226faa 0,#2989d8 37%,#72c0d3 100%);
    border-radius: 6px;
    color: #fff;
    padding: 18px;
    border-bottom-left-radius: 0;
    border-bottom-right-radius: 0;
    border-color: transparent;
}

.modal-header .close {
    margin-top: -3px;
    font-size: 24px;
    font-weight: 400;
    color: #fff;
    opacity: .9;
    width: 28px;
    height: 28px;
    padding-bottom: 0;
    padding-left: 1px;
}
button.close {
    padding: 0;
    cursor: pointer;
    background: 0 0;
    border: 0;
    -webkit-appearance: none;
    -moz-appearance: none;
    appearance: none;
}



  </style>
</head>

<body class="hold-transition sidebar-mini">
												<!-- Site wrapper -->
<div class="wrapper">

<!-- TOP MENU -->
<!-- TOP MENU -->
				  <nav class="main-header navbar navbar-expand navbar-white navbar-light">
				 <!-- Menu extensible -->
					<ul class="navbar-nav">
					  <li class="nav-item">
						<a class="nav-link" data-widget="pushmenu" href="#"><i class="fas fa-bars"></i></a>
						                             <li>
													    <a href="profilclient.php?preos=client&amp;client_id= <?php echo $client_id ; ?>" ><button type="button" class="btn btn-info"></i> TRANSFORMER EN CLIENT</button> </a>
													</li>

													  
													  <td>
													 &nbsp <button type="button" class="btn btn-info" data-toggle="modal" data-target="#modal-nouveaucontact"> Nouveau Contact</button>
													 </td>
													
			                                           <td>
													 &nbsp <button href="#myModal_doc"  id="custId" data-toggle="modal" type="button" class="btn btn-info"   >Nouveau Document</button>
													</td>
																
													
													
					  </li>
					  
				<!-- liens TOP MENU GAUCHE-->
					 
					  <li>
					 
					  </li>
					  
					  
					  
					</ul>

				 <!-- liens TOP MENU DROITE -->
					<ul class="navbar-nav ml-auto">
					 <!-- Placer ici l'élément à positionner à droite du TOP MENU -->
					</ul>
					
					<ul class="navbar-nav ml-auto">
								  <li class="nav-item">
            <a href="login.php?dec=1" class="nav-link">
			
              <i class="nav-icon fas fa-power-off"></i>
                        
            
            </a>
          </li><!-- Placer ici l'élément à positionner à droite du TOP MENU -->
								</ul>
				  
				  </nav> 
  
  
<!-- BARRE DE NAVIGATION -->

 <!-- Couleur et caracteristiques de la barre de navigation-->

 
 
 <?php include('menu.php'); ?>
 
   <div  class="modal fade" id="myModal_modif_contact" role="dialog" class="modal fade task-modal-single in" tabindex="-1"  aria-labelledby="myLargeModalLabel" >
  <div class="modal-dialog modal-lg">
    <div class="modal-content data">
		<div id="fetch" ></div>
		
           
        </div>
    </div>
</div>

  <div  class="modal fade" id="document_ajaxModifier" role="dialog" class="modal fade task-modal-single in" tabindex="-1"  aria-labelledby="myLargeModalLabel" >
  <div class="modal-dialog modal-lg">
    <div class="modal-content data">
		<div id="fetch_document" ></div>
		
           
        </div>
    </div>
</div>

   <div  class="modal fade" id="myModal_doc" role="dialog" class="modal fade task-modal-single in" tabindex="-1"  aria-labelledby="myLargeModalLabel" >
  <div class="modal-dialog modal-lg">
    <div class="modal-content data">
		<div id="fetch_doc" ></div>
		
           
        </div>
    </div>
</div>



 <!-- Ne pas toucher au dessus / fin de la BARRE DE NAVIGATION-->	

 <!-- DEMARRAGE DE LA PAGE PRINCIPALE -->
  <div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <div class="content-header">
      <div class="container-fluid">
        <div class="row mb-2">
		
		    <!-- ------------------------mo dal nouveau contact *****************- -->
		 <div class="modal fade" id="modal-nouveaucontact">
        <div class="modal-dialog modal-lg">
          <div class="modal-content">
            <div class="modal-header">
              <h4 class="modal-title">Nouveau Contact</h4>
              <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                <span aria-hidden="true">&times;</span>
              </button>
            </div>
            <div class="modal-body">
			
  <!-- ///////Ligne Nom -->   
  <form method="POST" action="">
  
  <div class="form-group">
    <label for="inputcontact_nom">Nom</label>
    <input type="text" class="form-control" id="inputcontact_nom"  name="contact_nom" placeholder="Nom">
  </div>
  
  <!-- ///////Ligne Prénom -->   
  
  <div class="form-group">
    <label for="inputcontact_prenom">Prénom</label>
    <input type="text" class="form-control" id="inputcontact_prenom"  name="contact_pnom" placeholder="Prénom">
  </div>
  
  <!-- ///////Ligne Fonction -->   
  
  <div class="form-group">
    <label for="inputcontact_fonction">Fonction</label>
    <input type="text" class="form-control" id="inputcontact_fonction"  name="contact_fonction" placeholder="Fonction">
  </div>
  
  <!-- ///////Ligne tele1 -->   
  
  <div class="form-group">
    <label for="inputcontact_tele1">Telephone</label>
    <input type="text" class="form-control" id="inputcontact_tele1"  name="contact_tele1" placeholder="Télephone">
  </div>
  
  <!-- ///////Ligne tele2 -->   
  
  <div class="form-group">
    <label for="inputcontact_tele2">Telephone</label>
    <input type="text" class="form-control" id="inputcontact_tele2"  name="contact_tele2" placeholder="Télephone">
  </div>
  
  <!-- ///////Ligne email -->   
  
  <div class="form-group">
    <label for="inputcontact_email">Email</label>
    <input type="text" class="form-control" id="inputcontact_email"  name="contact_email" placeholder="Email">
  </div>
  
  
            </div>
            <div class="modal-footer justify-content-between">
			  <input  name="ajouter_contact" type="hidden" value="ajouter_contact">
			  <input type="submit"  class="btn btn-primary" value="Enregistrer">
              <button type="button" class="btn btn-danger" data-dismiss="modal">Fermer</button>
			  
             
            </div>
			  </form>
          </div>
          <!-- /.modal-content -->
        </div>
        <!-- /.modal-dialog -->
      </div>
          <div class="col-sm-6">
            <h1 class="m-0 text-dark"></h1>
          </div><!-- /.col -->
          <div class="col-sm-6">
            
          </div><!-- /.col -->
        </div><!-- /.row -->
      </div><!-- /.container-fluid -->
    </div>
    <!-- /.content-header -->

    <!-- PAGE PRINCIPALE -->
    <div class="content">
      <div class="container-fluid">
        <div class="row">
	  <!-- DEFINITION DES COLONNES -->	
          <div class="col-lg-3">
		  
	 <!-- WIDGET AVEC LE NOM DU CLIENT -->		  
		   
			

			  
			<?php include('widget_client.php'); ?>
		
	
			  
		 <!-- BARRE DE NAVIGATION DU CLIENT -->		  
            
			<?php include('menu_prospect.php'); ?>
			</div>
          
          <!-- PASSAGE A LA COLONNE DE DROITE-->
          <div class="col-lg-9">
		  <!-- CARD DE DROITE-->
             <div class="card">
          
			  
			  
			  	  		  <?php
			      if(isset($_GET["msg"])){
        ?>
        <div class="alert alert-<?php echo $_GET["color"]; ?>  alert-dismissible col-12" role="alert">
          <strong><?php echo $_GET["color"].': '; ?></strong><?php echo $_GET["msg"]; ?>.
          <button type="button" class="close" data-dismiss="alert" aria-label="Close">
            <span aria-hidden="true">&times;</span>
          </button>
        </div>
        <?php
        }
       ?>
 <!-- ----------------------------------*************************************************  la fiche prospect  ********************************************************** -------------- -->
								<span class="border border-info">															
							<div class="card-body">
									     <form action="" method="POST">   
											   
											   <?php
											   
											   if($q['client_statut']==1)
											$satut='ca';
											else
											$satut='ci';
											   ?>
											 <div class="form-row">
												
												<div class="form-group col-md-6"><!-- Liste déroulante statut -->  
															<label>
											Statut</label>
															<select class="form-control" name="cleint_satatu">
																	  <option value="1" <?php if($satut=='ca') echo 'SELECTED'; ?> >Prospect Actif </OPTION>
																	 <option value="0" <?php if($satut=='ci') echo 'SELECTED'; ?> >Prospect Inactif </OPTION>
															</select>
												</div>
												<div class="form-group col-md-6"><!-- Liste déroulante établissement -->  
															<label>Etablissement</label>
															<select class="form-control" name="etab">
															<?php
															   $qr =dbi_query("SELECT * FROM `etablissement`") ; 
															while($etabs = dbi_fetch_row($qr))
															{
																
															?>
																<option value="<?=$etabs['etablissement_id'] ?>" <?php if($etabs['etablissement_id']==$q['etablissement_id']) echo 'SELECTED'; ?> ><?=$etabs['etablissement_nom'] ?></option>
																<?
															}
															
															?>
																   
															</select>
												</div>  			  
												
											 
												
											  </div> <!-- ///////Permet de passer à la ligne suivante -->   
											  
											 <!-- ///////Ligne hsociété & Catégorie -->   
											  
											  <div class="form-row"> <!-- champs Société --> 
												<div class="form-group col-md-6">
												  <label for="inputsociete">Soci&eacute;t&eacute;</label>
												  <input type="text" class="form-control" id="inputsociete"  name="societe" placeholder="Société" value="<?=$q['client_nom'] ; ?>">
											   </div>
											   
											   <div class="form-group col-md-6"><!-- Liste déroulante statut -->  
															<label>Cat&eacute;gorie</label>
															<select class="form-control" name="cleint_categorie">
																	<?php
																	 $qq =dbi_query("SELECT * FROM `categorie`") ; 
															while($cat = dbi_fetch_row($qq))
															{
																
															?>
																<option value="<?=$cat['categorie_id'] ?>"  <?php if($q['categorie_id']==$cat['categorie_id']) echo 'SELECTED'; ?> ><?=$cat['categorie_nom'] ?></option>
																<?
															}
															
															?>
															   
															</select>
												</div>
											   
												
												
												
											  </div> <!-- ///////Permet de passer à la ligne suivante -->   

											  
											<!-- ///////Ligne Adresse 1 -->   
											  
											  <div class="form-group">
												<label for="inputAddresse">Addresse</label>
												<input type="text" class="form-control" id="inputAddresse"  name="adr1" value="<?=$q['client_adr1'] ; ?>" >
											  </div>
											  
											  <!-- ///////Ligne Adresse 2 -->   
											  
											  <div class="form-group">
												<label for="inputAddresse2">Addresse 2</label>
												<input type="text" class="form-control" id="inputAddresse2" name="adr2" value="<?=$q['client_adr2'] ; ?>" >
											  </div>
											  
											  <!-- ///////Ligne Adresse 3 -->   
											  
											  <div class="form-group">
												<label for="inputAddresse3">Addresse 3</label>
												<input type="text" class="form-control" id="inputAddresse3" name="adr3" value="<?=$q['client_adr3'] ; ?>">
											  </div>


											  
											<!-- ///////Ligne Code Postal & Ville -->     
											  
											  <div class="form-row">
												<div class="form-group col-md-4">
												  <label for="inputcp">Code Postal</label>
												  <input type="text" class="form-control" name="cp" id="inputcp" value="<?=$q['client_cp'] ; ?>">
												</div>
												<div class="form-group col-md-8">
												  <label for="inputville">Ville</label>
												  <input type="text" class="form-control" name="ville" id="inputville" value="<?=$q['client_ville'] ; ?>" >
												</div>
												
											</div>	
												
											<!-- ///////Ligne téléphone & Fax-->   
											  <div class="form-row">
												
												<div class="form-group col-md-6"><!-- Télephone -->  
														   <div class="form-group">
												<label for="inputtel">T&eacute;l&eacute;phone</label>
												<input type="text" class="form-control" id="inputtel" name="tele" value="<?=$q['client_tele'] ; ?>"  >
											  </div>
												</div>
																
												<div class="form-group col-md-6"><!-- Fax -->  
														   <div class="form-group">
												<label for="inputfax">Fax</label>
												<input type="text" class="form-control" id="inputfax"  name="fax" value="<?=$q['client_fax'] ; ?>"  >
											  </div>
												</div>
											 
												  
											  </div> <!-- ///////Permet de passer à la ligne suivante -->   
											  
											  <input  name="modifier_prospect" type="hidden" value="modifier_prospect">
											  <button type="submit" class="btn btn-primary">Enregistrer</button>
									</form>						   
								</div>
								
								
								
					</span>
				 
				 
				 <br/>			

  <!-- ----------------------------------*************************************************  la partie contact  ********************************************************** -------------- -->
																								
																<?php
																 $qm = dbi_query("SELECT * FROM contact where  client_id = '$client_id'") ; 
																 
																?>

            <span class="border border-warning">
						<div class="card-body">
							<table id="example1" class="table table-hover">
									<thead>
									   <tr>
											<th>Nom</th>     		<!-- /.Table Contact - Champs contact_nom -->
											<th>Fonction</th> 	<!-- /.Table Contact - Champs contact_fonction -->
											<th>Tél 1</th>	<!-- /.Table Contact - Champs contact_tel1 -->
											<th>Tél 2</th>	<!-- /.Table Contact - Champs contact_tel2-->
											<th>E-mail</th>		<!-- /.Table Contact - Champs contact_email-->
											<th></th>	  
									   </tr>
									</thead>
											<tbody>
											
											
											<?php while($q=dbi_fetch_row($qm)){ ?>
											<?php
											 $chaine =  $q['contact_nom']." ". $q['contact_pnom'] ; 
											 ?>
											<tr>
										<td><?php echo $chaine ?></td>
									
										<td><?php echo $q['contact_fonction'] ; ?></td>
										<td><?php echo $q['contact_tele1'] ; ?></td>
										<td><?php echo $q['contact_tele2'] ; ?></td>
										<td><?php echo $q['contact_email'] ; ?></td>
										
										
										  <TD align="center" nowrap>
							  <?php echo '<a class="btn btn-info btn-sm" href="#myModal_modif_contact"  id="custId" data-toggle="modal" data-id="'.$q['contact_id'].'">   <i class="fas fa-pencil-alt"></i> </a>';?>   
											

							  
							 </a>
							  
							  
							  
							  

							  
							  
							   <a class="btn btn-danger btn-sm" href="?action=sup&id=<?=$q['contact_id']?>"  onclick="return confirm('Voulez-vous vraiment supprimer ce contact ?');">
										  
											   <i class="fas fa-trash"></i>
														 
											   </a>

							  </TD>
										
										
											</tr>
													   
											<?php }?>
										   
											</tbody>
											
										  </table>
									   
				 </div>
				 
				 
				 
				 
				</span>
				 
				 
				 <br/>
				 <span class="border border-danger">
				 						  <!-- /.card-header -->
						<div class="card-body">
						<section class="content">
						
												   					  		  <?php
			      if(isset($_GET["msg"])){
        ?>
        <div class="alert alert-<?php echo $_GET["color"]; ?>  alert-dismissible col-12" role="alert">
          <strong><?php echo $_GET["color"].': '; ?></strong><?php echo $_GET["msg"]; ?>.
          <button type="button" class="close" data-dismiss="alert" aria-label="Close">
            <span aria-hidden="true">&times;</span>
          </button>
        </div>
        <?php
        }
       ?>
	   
								
<?php






$qa = dbi_query("SELECT * FROM document_client WHERE   client_id=$client_id  ") ;



?><br clear="all" />
 <!-- ----------------------------------*************************************************  la partie Document  ********************************************************** -------------- -->
		
 <table id="example1" class="table table-hover">
    <thead>
        <tr>
			<th style="text-align:center;">Document</th>
			<th style="text-align:center;">Description</th>
			<th style="text-align:center;">Date Document</th>
			<th style="text-align:center;">Supprimer</th> 
		</tr>
    </thead>
    <tbody>
		<?php
		
			while($docc = dbi_fetch_row($qa)){
				
				$nomrepp=$docc['document_emplacement'];
				
				// echo "==> $nomrep <br/>" ; 
				
		?>
	<tr>
		<td style="text-align:center;">  <a class="btn btn-primary btn-sm"  href="<?=$nomrepp?>" target="_blank"><i class="fas fa-file"></i> </a></td>
		<td style="text-align:center;"><?=$docc['document_nom']?></td>
		<td style="text-align:center;"><?=int2date($docc['date_document'])?></td>
		
		<td align="center" nowrap> 
		
		
		
		<?php echo '<a class="btn btn-info btn-sm" href="#document_ajaxModifier"  id="custId" data-toggle="modal" data-id="'.$docc['document_id'].'">   <i class="fas fa-pencil-alt"></i> </a>';?>   
											

							  
							 </a>
		
		
		<a href="profilprosepct.php?doc=cl&action=sup_doc&id=<?=$docc['document_id']?>" onclick="return confirm('Voulez-vous vraiment supprimer ce document ?');" class="btn btn-danger btn-sm"> <i class="fas fa-trash"></i>         </a>  </td>
	</tr>
		<?php } 
		echo '</tbody>' ; 
		echo '</table>';


		?>
								
								
								
						</div>
			
				 
				 </span>
				 
				 
				<br/> 
				             <!-- /.card-header -->
							 <span class="border border-success">
							 
            <div class="card-body">
			
			    <?php
				
				$suivi = dbi_query(" SELECT * FROM  tache t,users u   where t.user_id = u.user_id and  client_id=$client_id   ") ; 
				?>
			
			
			
			
													<div class="box-body">
														<table id="example1" class="table table-bordered table-striped">
															<thead>
																<TR>
																  <th align="center" colspan="4"> Sujet </th>
																  <th align="center">Nom du salarié </th>	
																
																 
																  

																  <th align="center">Statu </th>
																	<th align="center">Priorité </th>																  
																  <th align="center"> Administratif </th>	
																
																  
																</TR>
															</thead>
                                                            <tbody>
															
															
						
																<?php while($a = dbi_fetch_row($suivi)){
																	
																	if($a['tache_status']==0)
																	{
																	
																	$tache_status="Pas complété";

																	}else{ $tache_status="Complété";}
																	
																	if($a['tache_Priorite']== 1)
																		{
																			$tache_Priorite= "Moyen" ; 
																		}
																		elseif($a['tache_Priorite']== 2)
																		{
																			 $tache_Priorite= "Haute" ; 
																		}
																		elseif($a['tache_Priorite']== 3)
																		{
																		$tache_Priorite= "Urgente" ; 
																		}
																	
																 
																
																
																list($Admin_nom) = dbi_fetch_row( dbi_query("SELECT user_nom,user_prenom FROM `users` WHERE `user_id`  = ".$a['user_id'])) ; 
																
																// list($salarie_nom ,$salarie_prenom ) = dbi_fetch_row( dbi_query("SELECT salarie_nom , salarie_prenom FROM `salarie` WHERE `salarie_id` = ".$a['inter_id'])) ; 
																
																// $salarie_nomm = $salarie_nom." ".$salarie_prenom ; 
																// exit() : 
																 if($a['client_id']!= 0)
																	  {
																	  list($client_nom)= dbi_fetch_row(dbi_query("SELECT client_nom   FROM `client` WHERE `client_id` = ".$a['client_id'])) ; 
																	  // echo "<br/>SELECT client_nom   FROM `client` WHERE `client_id` = ".$a['client_id'] ;
																	  }
																	  else
																	  { $client_nom = " <strong style='color:red;'> Pas de client concerné </strong>"; }
																  list($salarie_nom , $salarie_prenom)= dbi_fetch_row(dbi_query("SELECT salarie_nom , salarie_prenom FROM `salarie` WHERE `salarie_id` = ".$a['salarie_id'])) ; 
																	if(empty($salarie_nom) AND empty($salarie_prenom))
																		{
																			$salarie_nom = " <strong style='color:red;'>Pas de " ; 
																			$salarie_prenom = "salarié </strong> " ; 
																		}
																		
																		
																		
																		
																		
																		
																		
																		
																		
																											$page = "TacheClient.php" ; 
				
					?>
					
				
																<tr>
															
																<td colspan="4"> <a href="fetch_record.php?rowid=<?=$a['tache_id']?>&page=<?=$page?>"> <?php echo $a['tache_sujet'] ; ?></a></td>
																<td> <?php echo $salarie_nom." ".$salarie_prenom ; ?></td>
															
														
																
															
																
																<td> <?php echo $tache_status ; ?></td>
																<td> <?php echo $tache_Priorite; ?></td>
																<td> <?php echo $a['user_nom']." ".$a['user_prenom'] ; ?></td>
															
																
																
															    <?php }?>
 
															</tbody>
														</table><!-- /.table -->
													</div><!-- /.box-body -->
			
		

            
            <!-- /.card-body -->
          </div>
          <!-- /.card -->
	 
				 
				 
				 
				 
														
			<!-- /.coldddddddddddddddddddddddddddddddddddmd-6 -->
			
			</div>

            </span>
              </div>
           








		   </div>
          </div>
          <!-- /.col-md-6 -->
        </div>
		
		
        <!-- /.row -->
      </div><!-- /.container-fluid -->
    </div>
    <!-- /.content -->
  </div>
  <!-- /.content-wrapper -->

  <!-- Control Sidebar -->
  <aside class="control-sidebar control-sidebar-dark">
    <!-- Control sidebar content goes here -->
    <div class="p-3">
      <h5>Title</h5>
      <p>Sidebar content</p>
    </div>
  </aside>
  <!-- /.control-sidebar -->
  <footer class="main-footer">
    <div class="float-right d-none d-sm-block">
      <b>Version</b> 3.0.1
    </div>
    <strong>Copyright &copy; 2014-2019 <a href="http://adminlte.io">AdminLTE.io</a>.</strong> All rights
    reserved.
  </footer>

  <!-- Control Sidebar -->
  <aside class="control-sidebar control-sidebar-dark">
    <!-- Control sidebar content goes here -->
  </aside>
  <!-- /.control-sidebar -->
</div>
<!-- ./wrapper -->

<!-- jQuery -->
<script src="../../plugins/jquery/jquery.min.js"></script>
<!-- Bootstrap 4 -->
<script src="../../plugins/bootstrap/js/bootstrap.bundle.min.js"></script>
<!-- AdminLTE App -->
<script src="../../dist/js/adminlte.min.js"></script>
<!-- AdminLTE for demo purposes -->
<script src="../../dist/js/demo.js"></script>

<script>
  $(function () {
    // Summernote
    $('.textarea').summernote()
  }) ; 
  
  
  
  $(document).ready(function(){
    $('#myModal_doc').on('show.bs.modal', function (e) {
        var rowid = $(e.relatedTarget).data('id');
        $.ajax({
            type : 'post',
            url : 'ajaxAjoutDocument.php', //Here you will fetch records 
            data :  'rowid='+ rowid, //Pass $id
            success : function(data){
            $('#fetch_doc').html(data);//Show fetched data from database
            }
        });
     });
});

</script>
</body>


<script type="text/javascript">
$(document).ready(function(){
    $('#myModal_modif_contact').on('show.bs.modal', function (e) {
        var rowid = $(e.relatedTarget).data('id');
        $.ajax({
            type : 'post',
            url : 'ajaxModifierContact.php', //Here you will fetch records 
            data :  'rowid='+ rowid, //Pass $id
            success : function(data){
            $('#fetch').html(data);//Show fetched data from database
            }
        });
     });
});

    
</script>


<script type="text/javascript">
$(document).ready(function(){
    $('#document_ajaxModifier').on('show.bs.modal', function (e) {
        var rowid = $(e.relatedTarget).data('id');
        $.ajax({
            type : 'post',
            url : 'document_ajaxModifier.php', //Here you will fetch records 
            data :  'rowid='+ rowid, //Pass $id
            success : function(data){
            $('#fetch_document').html(data);//Show fetched data from database
            }
        });
     });
});

    
</script>

</body>
</html>