|
Server IP : 10.128.40.6 / Your IP : 216.73.216.233 Web Server : Apache System : Linux webd006.cluster128.gra.hosting.ovh.net 5.15.206-ovh-vps-grsec-zfs-classid #1 SMP Fri May 15 02:41:25 UTC 2026 x86_64 User : logmcpe ( 111175) PHP Version : 7.3.33 Disable Function : _dyuweyrj4,_dyuweyrj4r,dl MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0705) : /home/logmcpe/www/mcg/pages/feuillesroute/../ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
// exit() ;
include 'includes/config_tmcpro.php' ;
include 'includes/stable_functions_tmcpro.php' ;
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);
} */
}
$q =dbi_query("SELECT * FROM `etablissement`") ;
$qq =dbi_query("SELECT * FROM `categorie`") ;
if(!empty($_POST))
{
$latlong = get_lat_long($_POST['adr1']);
$map = explode(',' ,$latlong);
$mapLat = $map[0];
$mapLong = $map[1];
$prospect = 1 ;
// echo "<pre>" ;
// print_r($_POST);
// echo "</pre>" ;
// exit();
$client_statut=$_POST['cleint_satatu'] ;
$etablissement_id=$_POST['etablissement_id'] ;
$societe=addslashes($_POST['societe']) ;
$categorie_id=$_POST['cat'] ;
$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'] ;
dbi_query(" INSERT INTO client (
client_statut,
etablissement_id,
client_nom,
categorie_id,
client_adr1,
client_adr2,
client_adr3,
client_cp,
client_ville,
client_tele,
client_fax,
client_adrfact_1,
client_adrfact_2,
client_adrfact_3,
client_facture_ville,
client_facture_cp,
client_nom_facture,
latitude,
longitude,
prospect
)
VALUES
(
'1',
'$etablissement_id',
'$societe',
'$categorie_id',
'$client_adr1',
'$client_adr2',
'$client_adr3',
'$client_cp',
'$client_ville',
'$client_tele',
'$client_fax',
'$client_adr1',
'$client_adr2',
'$client_adr3',
'$client_ville',
'$client_cp',
'$societe',
'$mapLat',
'$mapLong',
'$prospect'
)") ;
list($client_id)= dbi_fetch_row( dbi_query( " SELECT max(`client_id`) FROM `client`")) ;
header('Location:profilprosepct9.php?client_id='.$client_id.'&msg=Client bien ajouté&color=success');
}
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<!-- Enregistrer le titre de la pmage --><title> LogMCPRO | NOUVEAU PROSPECTS</title>
<!-- Tell the browser to be responsive to screen :ll 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">
</head>
<body class="hold-transition sidebar-mini">
<!-- Site wrapper -->
<div class="wrapper">
<!-- 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>
</ul>
</nav> <!-- fin du TOP MENU -->
<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('menu9.php'); ?>
<!-- Sidebar Menu -->
</div>
<!-- /.sidebar -->
</aside>
<!-- 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>Nouveau Prospect</h1>
</div>
<div class="col-sm-6">
<ol class="breadcrumb float-sm-right">
<li class="breadcrumb-item"><a href="index9.php">Accueil</a></li>
<li class="breadcrumb-item"><a href="prospect9.php">Prospects</a></li>
<li class="breadcrumb-item active">Nouveau Prospect</li>
</ol>
</div>
</div>
</div><!-- /.container-fluid -->
</section>
<!-- TITRE DE LA PAGE PRINCIPALE A PLACE ENTRE LES BALISES H1 & ARBORESCENCE SUR LA DROITE-->
<!-- FIN DU TITRE DE LA PAGE PRINCIPALE A PLACE ENTRE LES BALISES H1 & ARBORESCENCE SUR LA DROITE-->
<!-- CONTENU DE LA PAGE PRINCIPALE -->
<section class="content"> <!-- Ne pas toucher cette ligne -->
<!-- Card Principale -->
<div class="card">
<!-- Titre de la Card Principale -->
<!-- Contenu de la Card Principale -->
<div class="card-body">
<!-- Début du Formulaire -->
<form method="POST" action="" >
<!-- ///////Ligne statut & Etablissement-->
<div class="form-row">
<div class="form-group col-md-4"><!-- Liste déroulante établissement -->
<label>Etablissement</label>
<select class="form-control" name="etablissement_id">
<?php
while($etabs = dbi_fetch_row($q))
{
?>
<option value="<?php echo $etabs['etablissement_id'] ; ?>" ><?php echo $etabs['etablissement_nom'] ; ?></option>
<?php
}
?>
</select>
</div>
<div class="form-group col-md-4">
<label for="inputsociete">Société</label>
<input type="text" class="form-control" id="inputsociete" name="societe" placeholder="Société" required="required">
</div>
<div class="form-group col-md-4"><!-- Liste déroulante Catégorie -->
<label>Catégorie</label>
<select class="form-control" name="cat">
<?php
while($cat = dbi_fetch_row($qq))
{
?>
<option value="<?php echo $cat['categorie_id'] ; ?>" ><?php echo $cat['categorie_nom'] ; ?></option>
<?php
}
?>
</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" placeholder="Adresse">
</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" placeholder="Adresse 2">
</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" placeholder="Adresse 3">
</div>
</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" placeholder="Code Postal">
</div>
<div class="form-group col-md-4">
<label for="inputville">Ville</label>
<input type="text" class="form-control" name="ville" id="inputville" placeholder="Ville">
</div>
<div class="form-group col-md-4"><!-- Télephone -->
<div class="form-group">
<label for="inputtel">Téléphone</label>
<input type="text" class="form-control" id="inputtel" name="tele" placeholder="Téléphone">
</div>
</div>
</div> <!-- ///////Permet de passer à la ligne suivante -->
<button type="submit" class="btn btn-primary"><i class="far fa-save"></i> Enregistrer</button>
</form>
<!-- Fin du Formulaire -->
<!-- Fin du Contenu de la Card Principale Ne pas toucher au Div en dessous-->
</div>
<!-- Footer de la Card Principale -->
<div class="card-footer">
<!-- Inserer ici si besoin texte Footer-->
</div>
<!-- fin du Footer de la Card Principale -->
<!-- NE PAS TOUCHER EN DESSOUS -->
</div>
</section>
</div>
<!-- NE PAS TOUCHER AU DESSUS DESSOUS -->
<!-- DEBUT DU PIED DE PAGE -->
<footer class="main-footer">
<div class="float-right d-none d-sm-block">
<b>Version</b> 3.0.1
</div>
<strong>Copyright © 2019 </strong>
</footer>
<!-- FIN DU PIED DE PAGE -->
<!-- NE PAS TOUCHER CI-DESSOUS -->
<!-- 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>
</body>
</html>