<?php

include 'includes/config_tmcpro.php' ;
include 'includes/stable_functions_tmcpro.php' ;
$pagemenu = basename($_SERVER["PHP_SELF"]) ;

 $_SESSION["pager"]=  "" ;
 $page_reg =   "" ;


// if(!empty($_POST)){
	
	// echo "<pre>" ; 
	// print_r($_POST) ; 
	// echo "</pre>"  ; 
	
	// exit() ; 
// }




 // if($_POST)

 // header('Location:fccontact.php?msg=contact bien supprimé&color=success');


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;
kk*/


    $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);
} */
}







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



// echo "-----------------------------<br/>" ;


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



if($_GET['preos']== "client")
{
	dbi_query("UPDATE `client` SET `prospect` = '0' WHERE client_id = ".$_GET['client_id']) ;
}

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



// echo "--------------------rrrr---------<br/>" ;


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




						 if(!empty($_POST) and $_POST['modification_coordonnees'] == 'modification_coordonnees' )
			 {
				 // 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']) ;
						$user_id = $_POST['user_id'] ;
						$code_1 = $_POST['code_1'] ;
						$code_2 = $_POST['code_2'] ;
						$code_3 = $_POST['code_3'] ;

						// echo "==>".$user_id."<br/>" ;

						// exit() ;

         $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',
  user_id     ='$user_id',
  code_1 = '$code_1',
  code_2 = '$code_2',
  code_3 = '$code_3'
WHERE client_id = $cleint_id ") ;

 header('Location:profilclient.php?msg=Les modifications sont bien fait&color=success');
			 }

	$q= dbi_fetch_row(dbi_query("SELECT * FROM client where client_id = ".$cleint_id)) ;
	
	
	 include('file_tache.php');

	?>





<!DOCTYPE html>
<html>

<head>

			<?php include('header.php'); ?>
			
			<!--
	  <script type="text/javascript" src="plugins/selectize/selectize.js"></script>
	<link rel="stylesheet" type="text/css" href="plugins/selectize/selectize.css" />
	<script type="text/javascript" src="plugins/selectize/selectize.min.js"></script>
	<link rel="stylesheet" type="text/css" href="plugins/selectize/selectize.default.css" />
	<link rel="stylesheet" href="../../plugins/summernote/summernote-bs4.css">








<script src="plugins/jQuery/jquery-2.2.3.min.js"></script>

<script src="bootstrap/js/bootstrap.min.js"></script>

<script src="plugins/datatables/jquery.dataTables.min.js"></script>
<script src="plugins/datatables/dataTables.bootstrap.min.js"></script>

<script src="plugins/slimScroll/jquery.slimscroll.min.js"></script>
-->
  <style type="text/css">
  .modal-backdrop {
    /* bug fix - no overlay */
    display: none;
}
</style>


<!-- SlimScroll -->



			</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>

					  	&nbsp
	   <li>
		  <h3><a href="#myModal_tache_all"  id="custId" data-toggle="modal" >   <button type="button"  class="btn btn-primary"><i class="fas fa-plus"></i> TACHE</button> </a></h3>
		</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>

				  </nav>


          <aside class="main-sidebar sidebar-dark-primary elevation-4">

          	<!-- Brand Logo -->
          	<a href="index3.html" class="brand-link">
          		<img src="dist/img/logomcpro.png" alt="AdminLTE Logo" class="brand-image img-circle elevation-3"
          				 style="opacity: .8">
          		<span class="brand-text font-weight-light">MC PRO</span>
          	</a>

          	<!-- Sidebar -->
          	<div class="sidebar">
          		<!-- Sidebar user panel (optional) -->
          		<div class="user-panel mt-3 pb-3 mb-3 d-flex">
          			<div class="image">
          				<img src="dist/img/user2-160x160.jpg" class="img-circle elevation-2" alt="User Image">
          			</div>
          			<div class="info">
          				<a href="#" class="d-block">Steeven ROBLOT</a>
          			</div>
          		</div>

          	<?php include('menu.php') ?>

          		<!-- Sidebar Menu -->

          	</div>
          	<!-- /.sidebar -->
          </aside>


<div  class="modal fade" id="myModal_tache_all" 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_tache_all" ></div>


        </div>
    </div>
</div>

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

 <!-- DEMARRAGE DE LA PAGE PRINCIPALE -->
  <div class="content-wrapper">

    <section class="content-header">
      <div class="container-fluid">
        <div class="row mb-2">
          <div class="col-sm-6">
            <h1><?php echo $q['client_nom'] ; ?> &nbsp - &nbsp <?php echo $q['client_cp'] ; ?> &nbsp <?php echo $q['client_ville'] ; ?> </h1>
          </div>
          <div class="col-sm-6">
            <ol class="breadcrumb float-sm-right">
              <li class="breadcrumb-item"><a href="index.php">Accueil</a></li>
              <li class="breadcrumb-item"><a href="clients2.php">Clients</a></li>
              <li class="breadcrumb-item active"> Coordonnées </li>
            </ol>
          </div>
        </div>
      </div><!-- /.container-fluid -->
    </section>
    <!-- Content Header (Page header) -->

    <!-- /.content-header -->

    <!-- PAGE PRINCIPALE -->
    <div class="content">


    </div>

          <!-- PASSAGE A LA COLONNE DE DROITE-->
          <div class="col-lg-12">
		  <!-- CARD DE DROITE-->
             <div class="card card-secondary">

               <?php include('menu_client_haut.php'); ?>



			  	  		  <?php

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






			      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
		// exit();
        }

       ?>
              <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-2"><!-- Liste déroulante statut -->
                 <label>
   Statut</label>
                 <select class="form-control" name="cleint_satatu">
                           <option value="1" <?php if($satut=='ca') echo 'SELECTED'; ?> >Client Actif </OPTION>
                          <option value="0" <?php if($satut=='ci') echo 'SELECTED'; ?> >Client Inactif </OPTION>
                 </select>
     </div>

   <div class="form-group col-md-2"><!-- 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>




 <!-- ///////Ligne hsociété & Catégorie -->


    <div class="form-group col-md-3"><!-- Liste déroulante établissement -->
                <label>Responsable du suivi</label>
                <select class="form-control" name="user_id">
				<?php
				   $us =dbi_query("SELECT * FROM `users`") ;
				while($user = dbi_fetch_row($us))
				{

				?>
					<option value="<?=$user['user_id'] ?>" <?php if($user['user_id']==$q['user_id']) echo 'SELECTED'; ?> ><?=$user['user_nom']." ".$user['user_prenom'] ?></option>
					<?
				}

				?>

                </select>
        </div>

   <div class="form-group col-md-2"><!-- Liste déroulante statut -->
                <label>Type de suivi</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 class="form-group col-md-3"><!-- Liste déroulante statut -->
                  <label>Fréquence</label>
                  <select class="form-control" name="cleint_sat">
                            <option value="1" >Hebdomadaire </OPTION>
                           <option value="0"  >Mensuelle </OPTION>
                  </select>
      </div>


  </div> <!-- ///////Permet de passer à la ligne suivante -->


<!-- ///////Ligne Adresse 1 -->
<div class="form-row">

<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">
    <label for="inputAddresse">Addresse 1</label>
    <input type="text" class="form-control" id="inputAddresse"  name="adr1" value="<?=$q['client_adr1'] ; ?>" >
  </div>

</div>

  <!-- ///////Ligne Adresse 2 -->
<div class="form-row">
  <div class="form-group col-md-6">
    <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 col-md-6">
    <label for="inputAddresse3">Addresse 3</label>
    <input type="text" class="form-control" id="inputAddresse3" name="adr3" value="<?=$q['client_adr3'] ; ?>">
  </div>

</div>


<!-- ///////Ligne Code Postal & Ville -->

  <div class="form-row">
    <div class="form-group col-md-3">
      <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-6">
      <label for="inputville">Ville</label>
      <input type="text" class="form-control" name="ville" id="inputville" value="<?=$q['client_ville'] ; ?>" >
    </div>
    <div class="form-group col-md-3"><!-- 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>


<div class="form-row">
    <div class="form-group col-md-4">
      <label for="inputcp">Code 1</label>
      <input type="text" class="form-control" name="code_1" id="inputcp" value="<?=$q['code_1'] ; ?>">
    </div>
    <div class="form-group col-md-4">
      <label for="inputcp">Code 2</label>
      <input type="text" class="form-control" name="code_2" id="inputcp" value="<?=$q['code_2'] ; ?>">
    </div>
    <div class="form-group col-md-4">
      <label for="inputcp">Code 3</label>
      <input type="text" class="form-control" name="code_3" id="inputcp" value="<?=$q['code_3'] ; ?>">
    </div>
</div>

<!-- ///////Ligne téléphone & Fax-->

   <input type="hidden" name="modification_coordonnees" value="modification_coordonnees">
  <button type="submit" class="btn btn-primary"><i class="fas fa-save"></i> ENREGISTRER</button>




</form>






              </div>
            </div>


              </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 -->
<?php include('footerr.php'); ?>





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


</script>



</body>
</html>