|
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 (0755) : /home/logmcpe/www/TMCPRO/pages/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
include 'includes/config_tmcpro.php' ;
include 'includes/stable_functions_tmcpro.php' ;
session_start();
if($_SESSION["id_etab"]== 111){
$where_etablissement_id="" ;
}
else{
$where_etablissement_id = " AND etablissement_id = ".$_SESSION["id_etab"] ;
}
// echo "bbbe <br/>" ;
// if(!empty($_POST['idprodm'])){
// echo "<pre>" ;
// print_r($_POST) ;
// echo "<pre>" ;
// $_SESSION["loadjd"] = "yes";
// exit() ;
// }
// session_start();
if(!empty($_GET))
{
$idprod=$_GET['id'];
// echo "==> $idprod cv<br/>" ;
dbi_query("delete from telepointage where id_p = $idprod ") ;
// header('Location:anomalies_salarie_2.php');
}
if($_POST['modifier']== "modifier"){
$idprodm=$_POST['idprodm'] ;
$salarie_id=$_POST['salarie_id'] ;
// echo "==> $idprodm <br/>" ;
// exit() ;
dbi_query("UPDATE telepointage SET matricule = $salarie_id WHERE id_p = $idprodm ") ;
// header('Location:anomalies_salarie.php');
}
?><html>
<head>
<?php include('header.php'); ?>
<!-- fullCalendar -->
<link rel="stylesheet" href="../plugins/fullcalendar/main.min.css">
<link rel="stylesheet" href="../plugins/fullcalendar-daygrid/main.min.css">
<link rel="stylesheet" href="../plugins/fullcalendar-timegrid/main.min.css">
<link rel="stylesheet" href="../plugins/fullcalendar-bootstrap/main.min.css">
</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">
<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>
<aside class="main-sidebar sidebar-dark-primary elevation-4">
<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>
<div class="sidebar">
<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="index.php" class="d-block">Steeven ROBLOT</a>
</div>
</div>
<?php
include('menu.php');
list($nrr_ligne_dans_latble)=dbi_fetch_row(dbi_query("SELECT count(*) FROM `automate_salarie`"));
// echo "============>$nrr_ligne_dans_latble <br/>" ;
if($nrr_ligne_dans_latble==0)
{
include('planning_prestation.php');
}
?>
</div>
</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>Anomalies Salariés</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="fourinc.php">Pointages</a></li>
<li class="breadcrumb-item active">Anomalies Salariés </li>
</ol>
</div>
</div>
</div><!-- /.container-fluid -->
</section>
<!-- Content Header (Page header) -->
<div class="content-header">
<div class="container-fluid">
<div class="row mb-2">
<div class="modal fade" id="myModal" role="dialog" class="modal fade task-modal-single in" 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="myModal1" 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="fetch1" >
</div>
</div>
</div>
</div>
</div><!-- /.row -->
</div>
</div>
<!-- /.content-header -->
<!-- PAGE PRINCIPALE -->
<section class="content">
<div class="row">
<div class="col-12">
<div class="modal fade" id="myModal2" 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 class="modal-header">
<h4 class="modal-title">planning client</h4>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
<div id="fetch2" ></div>
<div id="calendar"></div>
</div>
</div>
</div>
<div class="card">
<div class="card-body">
<?php
$ismai = $_SESSION['ans']."".$_SESSION['mois'] ;
if(!empty($_POST['mois']))
{
$_SESSION['mois'] = $_POST['mois'] ;
$_SESSION['ans'] = $_POST['ans'] ;
$ismai = $_POST['ans']."".$_POST['mois'] ;
}
if(empty($_POST['mois']) AND empty($_SESSION['mois']) )
{
$ismai = date("Ym") ;
// echo "ppp=> $ismai <br/>" ;
}
// $_SESSION['favcolor'] = 'green';
// if(!empty($_GET['idans']))
// {
// $_SESSION['idans'] = $_GET['idans'];
// }
// elseif(empty($_GET['id']))
// {
// $_SESSION['idans'] = date("Ym");
// }
// $ismai = date("m");
// $an = $_SESSION['idans'] ;
// if(!empty($_GET['id']))
// {
// $ismai=$an."".$_GET['id'] ;
// }
// if(empty($_GET['id']))
// {
// $ismai = $an."".$ismai ;
// }
// $qa = dbi_query(" SELECT * FROM `telepointage` where `jour` LIKE '$ismai%' ORDER BY `telepointage`.`jour` ASC ") ;
$qa = dbi_query(" SELECT * FROM `telepointage` t , client c where t.client_id = c.client_id AND `jour` LIKE '$ismai%' $where_etablissement_id ORDER BY t.jour ASC ")
// echo " SELECT * FROM `telepointage` where `jour` LIKE '$ismai%' and (matricule='0' OR client_id = '0' OR client_id IS NULL) ORDER BY `telepointage`.`jour` ASC " ;
// echo "===>$an <br/>" ;
// echo "===>$ismai <br/>" ;
// echo "<pre>" ;
// print_r($_GET) ;
// echo "<pre>" ;
?>
<form id="bureau_mois" name="mois_form" method="POST" action="">
<div class="form-row">
<div class="form-group col-md-2">
<div class="input-group">
<?php $qm = dbi_query("SELECT * FROM `client` WHERE `client_statut` = '1'") ; ?>
<select class="form-control select" style="width: 100%;" name="mois" onchange="GetIdmois()";>
<option selected="selected">sélectionner un mois </option>
<option value='01' <?php if($_SESSION['mois']== '01'){echo 'SELECTED ' ; }?> > Janvier </option>
<option value='02' <?php if($_SESSION['mois']== '02'){echo 'SELECTED ' ; }?> > Février </option>
<option value='03' <?php if($_SESSION['mois']== '03'){echo 'SELECTED ' ; }?> > Mars </option>
<option value='04' <?php if($_SESSION['mois']== '04'){echo 'SELECTED ' ; }?> > Avril </option>
<option value='05' <?php if($_SESSION['mois']== '05'){echo 'SELECTED ' ; }?> > Mai </option>
<option value='06' <?php if($_SESSION['mois']== '06'){echo 'SELECTED ' ; }?> > Juin </option>
<option value='07'<?php if($_SESSION['mois']== '07'){echo 'SELECTED ' ; }?> > Juillet </option>
<option value='08' <?php if($_SESSION['mois']== '08'){echo 'SELECTED ' ; }?> > Aout </option>
<option value='09' <?php if($_SESSION['mois']== '09'){echo 'SELECTED ' ; }?> > Septembre </option>
<option value='10' <?php if($_SESSION['mois']== '10'){echo 'SELECTED ' ; }?> > Octobre </option>
<option value='11' <?php if($_SESSION['mois']== '11'){echo 'SELECTED ' ; }?> > Novembre </option>
<option value='12' <?php if($_SESSION['mois']== '12'){echo 'SELECTED ' ; }?> > Décembre </option>
</select>
</div>
</div>
<div class="form-group col-md-2">
<div class="input-group">
<select class="form-control select" style="width: 100%;" name="ans" onchange="GetIdans()";>
<option selected="selected">sélectionner un année </option>
<option value='2020' <?php if($_SESSION['ans']== '2020'){echo 'SELECTED ' ; }?> > 2020 </option>
<option value='2021' <?php if($_SESSION['ans']== '2021'){echo 'SELECTED ' ; }?> > 2021 </option>
<option value='2022' <?php if($_SESSION['ans']== '2022'){echo 'SELECTED ' ; }?> > 2022 </option>
<option value='2023' <?php if($_SESSION['ans']== '2023'){echo 'SELECTED ' ; }?> > 2023 </option>
<option value='2024' <?php if($_SESSION['ans']== '2024'){echo 'SELECTED ' ; }?> > 2024 </option>
<option value='2025' <?php if($_SESSION['ans']== '2025'){echo 'SELECTED ' ; }?> > 2025 </option>
<option value='2026' <?php if($_SESSION['ans']== '2026'){echo 'SELECTED ' ; }?> > 2026 </option>
</select>
</div>
</div>
<div class="form-group col-md-4">
<div class="input-group">
<button type="submit" name="Afficher" class="btn btn-primary">Afficher </button>
</div>
</div>
</div>
</form>
<div class="onglet_dotted">
<div style="width:100%; float:left; vertical-align:top" class="header_ray">
<div id="tab">
<div class="box-body">
<table id="exam1" class="table table-bordered">
<thead>
<TR>
<th align="center">Date</th>
<th align="center">Salarié</th>
<th align="center">Client</th>
<th align="center">Heure</th>
<th align="center">Téléphone</th>
<th align="center">Deb/Fin</th>
<th align="center"></th>
</TR>
</thead>
<tbody>
<?php while($tel = dbi_fetch_row($qa)) {
// exit();
$classe="btn btn-info btn-sm";
?>
<?php list($inter_nom , $inter_pnom) = dbi_fetch_row(dbi_query(" SELECT salarie_nom , salarie_prenom FROM `salarie` WHERE `salarie_id` = ".$tel['matricule'])) ; ?>
<?php $tele =$tel['telephone'] ;
list($client_nom,$client_id ) = dbi_fetch_row(dbi_query("SELECT client_nom,client_id FROM `client` WHERE `tele1` LIKE '$tele' OR `tele2` LIKE '$tele' OR `tele3` LIKE '$tele' OR `tele4` LIKE '$tele' OR `tele5` LIKE '$tele' ")) ;
// echo "$inter_nom==$inter_pnom <br/>" ;
// $array = array("foo", "bar", "hello", "world");
if($inter_nom == "" AND $inter_pnom=="" )
{
if(isset($client_id) && $client_id > 0 ){
list($nbr_salarie_id)=dbi_fetch_row(dbi_query("SELECT count(salarie_id) FROM `automate_salarie` WHERE `presta_date` = ".$tel['jour']." AND `client_id` = ".$client_id)) ;
// list($salarie_id)=dbi_fetch_row(dbi_query("SELECT salarie_id FROM `automate_salarie` WHERE `presta_date` = ".$tel['jour']." AND `client_id` = ".$client_id)) ;
}
?>
<tr>
<TD align="center" nowrap> <?php echo int2date($tel['jour']) ; ?> </td>
<?php
$salarie_nom="" ; $salarie_prenom = "" ;
// echo "$nbr_salarie_id <br/>" ;
if(($nbr_salarie_id == 1) AND (isset($client_id) && $client_id > 0 ) ){
list($salarie_nom,$salarie_prenom,$salarie_id)=dbi_fetch_row(dbi_query(" SELECT salarie_nom , salarie_prenom , s.salarie_id FROM automate_salarie at_s, salarie s WHERE s.salarie_id = at_s.salarie_id AND `presta_date` = ".$tel['jour']." AND `client_id` = ".$client_id)) ;
// echo "SELECT salarie_nom , salarie_prenom , s.salarie_id FROM automate_salarie at_s, salarie s WHERE s.salarie_id = at_s.salarie_id AND `presta_date` = ".$tel['jour']." AND `client_id` = ".$client_id."<br/>" ;
?>
<td> <?php echo $inter_nom." ".$salarie_nom." ".$salarie_prenom; ?> </td>
<?php
}else{
?>
<td> <?php echo $inter_nom." ".$salarie_nom." ".$salarie_prenom; ?> </td>
<?php
}
?>
<td> <?php echo $client_nom ; ?> </td>
<TD align="center" nowrap> <?php echo $tel['heure'] ; ?> </td>
<TD align="center" nowrap> <?php echo $tel['telephone'] ; ?> </td>
<TD align="center" nowrap> <?php echo $tel['action'] ; ?> </td>
<TD align="center" nowrap>
<?php if(isset($client_id) && $client_id > 0 ) echo '<a class="btn btn-primary btn-sm" data-userid="'.int2date($tel['jour'],'Y-m-d').'" href="#myModal2" id="custId" data-toggle="modal" data-id="'.$client_id.'"><i class="fas fa-pencil-alt"></i> Planning</a>'; else echo "problème client";?>
<?php if($salarie_id>0){?>
<?php echo '<a class="btn btn-info btn-sm" href="#myModal" id="custId" data-toggle="modal" data-id="'.$tel['id_p'].'" data-sal_id="'.$salarie_id.'" ><i class="fas fa-pencil-alt"></i> Affecter</a>';?>
<?php }else{?>
<?php echo '<a class="btn btn-info btn-sm" href="#myModal" id="custId" data-toggle="modal" data-id="'.$tel['id_p'].'" ><i class="fas fa-pencil-alt"></i> Affecter Salarié</a>';?>
<?php }?>
</a>
<a class="btn btn-danger btn-sm" href="?action=sup&id=<?=$tel['id_p']?>" onclick="return confirm('Voulez-vous vraiment supprimer ce pointage ?');">
<i class="fas fa-trash">
</i> Supprimer
</a>
</TD>
</tr>
<?php }}?>
</tbody>
</table><!-- /.table -->
</div><!-- /.box-body -->
</div><!-- /.tab -->
</div><!-- /.header_ray -->
</div><!-- /.onglet_dotted -->
</div><!-- /.card-body -->
</div><!-- /.card card-primary card-outline -->
</div> <!-- /.col-12 -->
</div> <!-- /.row -->
</section> <!-- /.section -->
<section class="content">
<div class="row">
<div class="col-12">
<div class="card">
<div class="card-header">
<h3 class="card-title"></h3>
</div>
<div class="card-body">
<?php
if(!empty($_POST['mois']))
{
$ismai = $_POST['ans']."".$_POST['mois'] ;
}
else
{
$ismai = date("Ym") ;
// echo "ppp=> $ismai <br/>" ;
}
// $_SESSION['favcolor'] = 'green';
// if(!empty($_GET['idans']))
// {
// $_SESSION['idans'] = $_GET['idans'];
// }
// elseif(empty($_GET['id']))
// {
// $_SESSION['idans'] = date("Ym");
// }
// $ismai = date("m");
// $an = $_SESSION['idans'] ;
// if(!empty($_GET['id']))
// {
// $ismai=$an."".$_GET['id'] ;
// }
// if(empty($_GET['id']))
// {
// $ismai = $an."".$ismai ;
// }
$qa = dbi_query(" SELECT * FROM `telepointage` where `jour` LIKE '$ismai%' ORDER BY `telepointage`.`jour` ASC ") ;
// echo "===>$an <br/>" ;
// echo "===>$ismai <br/>" ;
// echo "<pre>" ;
// print_r($_GET) ;
// echo "<pre>" ;
?>
<form id="bureau_mois" name="mois_form" method="POST" action="">
<div class="form-row">
<div class="form-group col-md-2">
<div class="input-group">
<?php $qm = dbi_query("SELECT * FROM `client` WHERE `client_statut` = '1'") ; ?>
<select class="form-control select" style="width: 100%;" name="mois" onchange="GetIdmois()";>
<option selected="selected">sélectionner un mois </option>
<option value='01'> Janvier </option>
<option value='02'> Février </option>
<option value='03'> Mars </option>
<option value='04'> Avril </option>
<option value='05'> Mai </option>
<option value='06'> Juin </option>
<option value='07'> Juillet </option>
<option value='08'> Aout </option>
<option value='09'> Septembre </option>
<option value='10'> Octobre </option>
<option value='11'> Novembre </option>
<option value='12'> Décembre </option>
</select>
</div>
</div>
<div class="form-group col-md-2">
<div class="input-group">
<select class="form-control select" style="width: 100%;" name="ans" onchange="GetIdans()";>
<option selected="selected">sélectionner un année </option>
<option value='2020'> 2020 </option>
<option value='2021'> 2021 </option>
<option value='2022'> 2022 </option>
<option value='2023'> 2023 </option>
<option value='2024'> 2024 </option>
<option value='2025'> 2025 </option>
<option value='2026'> 2026 </option>
</select>
</div>
</div>
<div class="form-group col-md-4">
<div class="input-group">
<button type="submit" name="Afficher" class="btn btn-primary">Afficher </button>
</div>
</div>
</div>
</form>
<div class="onglet_dotted">
<div style="width:100%; float:left; vertical-align:top" class="header_ray">
<div id="tab">
<div class="box-body">
<table id="example1" class="table table-bordered table-striped">
<thead>
<TR>
<th align="center">Date</th>
<th align="center">Salarié</th>
<th align="center">Client</th>
<th align="center">Heure</th>
<th align="center">Téléphone</th>
<th align="center">Matricule</th>
<th align="center">Deb/Fin</th>
<th align="center"></th>
</TR>
</thead>
<tbody>
<?php while($tel = dbi_fetch_row($qa)) { ?>
<?php list($inter_nom , $inter_pnom) = dbi_fetch_row(dbi_query(" SELECT salarie_nom , salarie_prenom FROM `salarie` WHERE `salarie_id` = ".$tel['matricule'])) ; ?>
<?php $tele =$tel['telephone'] ;
if($tel['client_id']>0){
list($client_nom ) = dbi_fetch_row(dbi_query("SELECT client_nom FROM `client` WHERE client_id = ".$tel['client_id'])) ;
}else{
list($client_nom ) = dbi_fetch_row(dbi_query("SELECT client_nom FROM `client` WHERE `tele1` LIKE '$tele' OR `tele2` LIKE '$tele' OR `tele3` LIKE '$tele' OR `tele4` LIKE '$tele' OR `tele5` LIKE '$tele' ")) ;
}
?>
<tr>
<TD align="center" nowrap> <?php echo int2date($tel['jour']) ; ?> </td>
<td> <?php echo $inter_nom." ".$inter_pnom; ?> </td>
<td> <?php echo $client_nom ; ?> </td>
<TD align="center" nowrap> <?php echo $tel['heure'] ; ?> </td>
<TD align="center" nowrap> <?php echo $tel['telephone'] ; ?> </td>
<TD align="center" nowrap> <?php echo $tel['matricule'] ; ?> </td>
<TD align="center" nowrap> <?php echo $tel['action'] ; ?> </td>
<TD align="center" nowrap>
<a class="btn btn-danger btn-sm" href="?action=sup&id=<?=$tel['id_p']?>" onclick="return confirm('Voulez-vous vraiment supprimer ce pointage ?');">
<i class="fas fa-trash">
</i> Supprimer
</a>
</TD>
</tr>
<?php }?>
</tbody>
</table><!-- /.table -->
</div><!-- /.box-body -->
</div><!-- /.tab -->
</div><!-- /.header_ray -->
</div><!-- /.onglet_dotted -->
</div><!-- /.card-body -->
</div><!-- /.card card-primary card-outline -->
</div> <!-- /.col-12 -->
</div> <!-- /.row -->
</section> <!-- /.section -->
</div>
<?php include('footerr.php'); ?>
<!-- fullCalendar 2.2.5 -->
<script src="../plugins/moment/moment.min.js"></script>
<script src="../plugins/fullcalendar/main.min.js"></script>
<script src="../plugins/fullcalendar-daygrid/main.min.js"></script>
<script src="../plugins/fullcalendar-timegrid/main.min.js"></script>
<script src="../plugins/fullcalendar-interaction/main.min.js"></script>
<script src="../plugins/fullcalendar-bootstrap/main.min.js"></script>
<script src='../plugins/fullcalendar/locales/fr.js'></script>
<script type="text/javascript">
$(document).ready(function(){
$('#myModal').on('show.bs.modal', function (e) {
var rowid = $(e.relatedTarget).data('id');
var rowid_sal_id = $(e.relatedTarget).data('sal_id');
$.ajax({
type : 'post',
url : 'ajaxAjoutMatR.php', //Here you will fetch records
data : 'rowid='+ rowid +'&rowid_sal_id='+ rowid_sal_id, //Pass $id
success : function(data){
$('#fetch').html(data);//Show fetched data from database
}
});
});
$('#myModal2').on('show.bs.modal', function (e) {
var client_id = $(e.relatedTarget).data('id');
var date_client = $(e.relatedTarget).data('userid');
// alert(date_client);
$('#calendar').html(null);
$('#fetch2').html(null);
let calendarEl = document.getElementById('calendar');
let calendar = new FullCalendar.Calendar(calendarEl, {
locale: 'fr',
plugins: [ 'bootstrap', 'interaction', 'dayGrid', 'timeGrid' ],
firstDay: 1,
defaultDate: date_client,
showNonCurrentDates: false,
fixedWeekCount: false,
header : {
left : 'prev,next today',
center: 'title',
right : 'dayGridMonth,timeGridWeek,timeGridDay'
},
businessHours: {
daysOfWeek: [ 0,1, 2, 3, 4,5,6 ], // Monday - Thursday
startTime: '06:00', // a start time (10am in this example)
endTime: '19:00', // an end time (6pm in this example)
},
events: 'planning.php?date='+date_client+'&client_id='+client_id,
selectable:true,
selectHelper:true,
editable:false
});
calendar.setOption('locale', 'fr');
calendar.render();
// alert(rowid);
});
});
</script>
</body>
</html>