|
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 (0755) : /home/logmcpe/www/TEST/../TMCPRO/pages/feuillesroute/../ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
include 'includes/config_tmcpro.php' ;
include 'includes/stable_functions_tmcpro.php' ;
$pagemenu = basename($_SERVER["PHP_SELF"]) ;
include('file_tache.php');
if(!empty($_GET['salarie_id']))
{
$_SESSION["salarie_id"]=$_GET['salarie_id'];
}
$salarie_id=$_SESSION["salarie_id"] ;
$salarie_idd=$_SESSION["salarie_id"] ;
$req =dbi_query("SELECT * FROM `absence_type`") ;
// $salarie_id = 87 ;
// $salarie_idd = 87 ;
if($_GET['sup']== 1)
{
list($statut_absence) = dbi_fetch_row(dbi_query("SELECT statut_absence FROM `salarie_absence` WHERE `salarie_absence_id` = ".$_GET['salarie_absence_id'])) ;
if ($statut_absence == 2){
dbi_query("UPDATE `salarie_absence` SET `statut_absence` = '0' WHERE `salarie_absence`.`salarie_absence_id` = ".$_GET['salarie_absence_id']) ;
}else{
dbi_query("DELETE FROM `salarie_absence`
WHERE salarie_absence_id =".$_GET['salarie_absence_id']) ;
}
// echo "<pre>" ;
// print_r($_GET) ;
// echo "</pre>" ;
// echo "bbb <br/>" ;
// exit() ;
}
// if(!empty($_POST) and empty($_POST['tache_Priorite']) )
if(!empty($_POST) and $_POST['modification_coordonnees'] == 'modification_coordonnees' )
{
// echo "<pre>" ;
// print_r($_POST) ;
// echo "</pre>" ;
// echo "bbb <br/>" ;
// exit() ;
// echo "==> ".$_POST['salarie_absence_date_debut']."<br/>" ;
// $salarie_absence_date_debuta= dateMCPROint($_POST['salarie_absence_date_debut']) ;
$salarie_absence_date_debuta= date2int_DSI($_POST['salarie_absence_date_debut']) ;
// echo "=llk=> $salarie_absence_date_debuta <br/> " ;
// exit() ;
if($_POST['salarie_absence_date_fin']=="")
{
$salarie_absence_date_fin= NULL;
// exit() ;
}
else
{
$salarie_absence_date_fina= date2int_DSI($_POST['salarie_absence_date_fin']) ;
}
$salarie_absence_date_debut= $salarie_absence_date_debuta ;
$salarie_absence_heure_debut=$_POST['salarie_absence_heure_debut'] ;
$salarie_absence_date_fin= $salarie_absence_date_fina ;
$salarie_absence_heure_fin=$_POST['salarie_absence_heure_fin'] ;
$absence_type_id=$_POST['absence_type'] ;
// echo "==>".$_POST['salarie_absence_date_fin']."<br/>" ;
$start_absence = $_POST['salarie_absence_date_debut']." ".$_POST['salarie_absence_heure_debut'].":00" ;
$end_absence = $_POST['salarie_absence_date_fin']." ".$_POST['salarie_absence_heure_fin'].":00" ;
// echo "==>".$start_absence." === ".$end_absence."<br/>" ;
// exit() ;
// echo "<pre>" ;
// print_r($_POST) ;
// echo "</pre>" ;
// exit();
// if($salarie_absence_date_fin=="")
// {
// echo "test" ;
// exit() ;
// }
$salarie_planning = 0 ;
if($absence_type_id == 1 or $absence_type_id == 10 or $absence_type_id == 14 or $absence_type_id == 28 ){
$salarie_planning = 1;
}
dbi_query(" INSERT INTO salarie_absence (
salarie_absence_date_debut,
salarie_absence_heure_debut,
salarie_absence_date_fin,
salarie_absence_heure_fin,
salarie_id,
absence_type_id,
salarie_planning,
start_absence,
end_absence
)
VALUES (
'$salarie_absence_date_debut',
'$salarie_absence_heure_debut',
'$salarie_absence_date_fin',
'$salarie_absence_heure_fin',
$salarie_idd,
'$absence_type_id',
'$salarie_planning',
'$start_absence',
'$end_absence'
)") ;
}
if(!empty($_GET['salarie_absence_id']) and isset($_POST['Modifier']))
{
$salarie_absence_id= $_POST['salarie_absence_id'] ;
// list($statut_absence) = dbi_fetch_row(dbi_query("SELECT statut_absence FROM `salarie_absence` WHERE `salarie_absence_id` = ".$salarie_absence_id)) ; // pour voir est ce que c'est une demande de congé depuis
// if ($statut_absence == 2){
// }
$statut_absence = 1;
$salarie_absence_date_debuta= date2int_DSI($_POST['salarie_absence_date_debut']) ;
// $salarie_absence_date_fina= dateMCPROint($_POST['salarie_absence_date_fin']) ;
if($_POST['salarie_absence_date_fin']=="")
{
$salarie_absence_date_fina= NULL;
// exit() ;
}
else
{
$salarie_absence_date_fina= date2int_DSI($_POST['salarie_absence_date_fin']) ;
}
$salarie_absence_date_debut= $salarie_absence_date_debuta ;
$salarie_absence_heure_debut=$_POST['salarie_absence_heure_debut'] ;
$salarie_absence_date_fin= $salarie_absence_date_fina ;
$salarie_absence_heure_fin=$_POST['salarie_absence_heure_fin'] ;
$absence_type_id=$_POST['absence_type'] ;
$salarie_planning = 0 ;
if($absence_type_id == 1 or $absence_type_id == 10 or $absence_type_id == 14 or $absence_type_id == 28 ){
$salarie_planning = 1;
}
// UPDATE table
// SET colonne_1 = 'valeur 1', colonne_2 = 'valeur 2', colonne_3 = 'valeur 3'
// WHERE condition
$start_absence = $_POST['salarie_absence_date_debut']." ".$_POST['salarie_absence_heure_debut'].":00" ;
$end_absence = $_POST['salarie_absence_date_fin']." ".$_POST['salarie_absence_heure_fin'].":00" ;
dbi_query(" UPDATE salarie_absence SET
salarie_absence_date_debut = '$salarie_absence_date_debut',
salarie_absence_heure_debut = '$salarie_absence_heure_debut',
salarie_absence_date_fin = '$salarie_absence_date_fin',
salarie_absence_heure_fin = '$salarie_absence_heure_fin',
start_absence = '$start_absence' ,
end_absence = '$end_absence',
absence_type_id = '$absence_type_id',
salarie_planning = '$salarie_planning',
statut_absence = '$statut_absence'
where salarie_absence_id = $salarie_absence_id
") ;
}
$q= dbi_fetch_row(dbi_query("SELECT * FROM salarie where salarie_id = ".$salarie_id)) ;
// header('Content-type: text/html; charset=UTF-8');
?>
<!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">
<link href="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css" rel="stylesheet">
-->
<style>
body {
background-color: #f8f9fa;
}
.message-container {
max-width: 500px;
margin: 100px auto;
padding: 20px;
background-color: #fff;
border-radius: 10px;
box-shadow: 0 0 10px rgba(0, 0, 0, 0.1);
text-align: center;
}
.message-icon {
font-size: 48px;
color: #6c757d;
}
.message-text {
margin-top: 20px;
font-size: 20px;
color: #6c757d;
}
</style>
<!-- jQuery 2.2.3 -->
<script src="plugins/jQuery/jquery-2.2.3.min.js"></script>
<!-- Bootstrap 3.3.6 -->
<script src="bootstrap/js/bootstrap.min.js"></script>
<!-- DataTables -->
<script src="plugins/datatables/jquery.dataTables.min.js"></script>
<script src="plugins/datatables/dataTables.bootstrap.min.js"></script>
<!-- SlimScroll -->
<script src="plugins/slimScroll/jquery.slimscroll.min.js"></script>
<style type="text/css">
.modal-backdrop {
/* bug fix - no overlay */
display: 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>
  <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-->
</ul>
<!-- liens TOP MENU DROITE -->
<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>
</ul>
</nav> <!-- fin du TOP MENU -->
<!-- BARRE DE NAVIGATION -->
<?php include('menu.php'); ?>
<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>
<!-- 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['salarie_nom']." ".$q['salarie_prenom'] ;?></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="salaries2.php">Salariés</a></li>
<li class="breadcrumb-item active">Absences </li>
</ol>
</div>
</div>
</div><!-- /.container-fluid -->
</section>
<?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">×</span>
</button>
</div>
<?php
}
?>
<!-- PAGE PRINCIPALE -->
<div class="content">
<div class="container-fluid">
<!-- PASSAGE A LA COLONNE DE DROITE-->
<div class="col-lg-12">
<!-- CARD DE DROITE-->
<div class="card card-info">
<?php include('menu_salarie_haut.php'); ?>
<div class="card-body">
<form action="" method="POST">
<?php
$q= dbi_query("SELECT * FROM salarie_absence where salarie_id = ".$salarie_idd." and statut_absence = 1 ORDER BY `salarie_absence`.`salarie_absence_date_debut` DESC") ;
if(!empty($_GET['salarie_absence_id']))
{
$red= dbi_fetch_row(dbi_query("SELECT * FROM salarie_absence where salarie_absence_id = ".$_GET['salarie_absence_id'])) ;
// echo "===>".$red['salarie_absence_date_debut']."<br/>" ;
// echo "===>".$red['salarie_absence_heure_debut']."<br/>" ;
$heurdeb = $red['salarie_absence_heure_debut'] ;
$heurfin = $red['salarie_absence_heure_fin'] ;
}
?>
<div class="form-row">
</div> <!-- ///////Permet de passer à la ligne suivante -->
<!-- ///////Ligne société & Catégorie -->
<!-- ///////Ligne -->
<div class="form-row">
<div class="form-group col-md-2">
<label>Du</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" data-inputmask-alias="datetime" data-inputmask-inputformat="dd/mm/yyyy" data-mask name="salarie_absence_date_debut" <?php if(!empty($red['salarie_absence_date_debut']) ) echo "value=".int2date_autre_format($red['salarie_absence_date_debut']) ;?> placeholder="jj/mm/aaaa" maxlength="10" >
</div>
</div>
<div class="form-group col-md-2">
<label for="inputAddresse">Heure</label>
<input type="time" id="appt" class="form-control" name="salarie_absence_heure_debut" value="<?=$heurdeb?>" required>
</div>
<?php// $chantier_fin = int2date_autre_format($red['chantier_fin']) ; ?>
<div class="form-group col-md-2">
<label>Au</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" data-inputmask-alias="datetime" data-inputmask-inputformat="dd/mm/yyyy" data-mask name="salarie_absence_date_fin" <?php if(($red['salarie_absence_date_fin'])!= 00000000) echo "value=".int2date_autre_format($red['salarie_absence_date_fin']) ;?> placeholder="jj/mm/aaaa" maxlength="10" >
</div>
</div>
<div class="form-group col-md-2">
<label for="inputsociete">Heure</label>
<input type="time" id="appt" class="form-control" name="salarie_absence_heure_fin" value="<?=$heurfin?>" >
</div>
<div <div class="form-group col-md-4"><!-- Liste déroulante statut -->
<label>Motif</label>
<select class="form-control" name="absence_type">
<?php
while($etabs = dbi_fetch_row($req))
{
?>
<option value="<?=$etabs['absence_type_id'] ?>" <?php if($red['absence_type_id'] == $etabs['absence_type_id'] )echo 'selected' ; ?> ><?=$etabs['absence_type_description'] ?></option>
<?php
}
?>
</select>
</div>
<!-- ///////Ligne -->
<!-- ///////Ligne Code Postal & Ville -->
<?php
if(!empty($red['salarie_absence_id']))
{
if($red['statut_absence']== 2){ $action = "Accpter" ; }else{$action = "Modifier" ;}
?>
<input type="hidden" name="salarie_absence_id" value="<?=$red['salarie_absence_id'] ?>">
<button type="submit" name="Modifier" class="btn btn-primary"><?=$action ?></button>
<?php
}
else
{
?>
<input type="hidden" name="modification_coordonnees" value="modification_coordonnees">
<button type="submit" name="Enregistrer" class="btn btn-primary">Enregistrer</button>
<?php
}
?>
</form>
</div>
<section class="content">
<div class="row">
<div class="col-12">
</div>
<!-- /.card-header -->
<div class="card-body">
<!-- <table id="example1" class="table table-hover"> *********** j'ai enlevé id pour que le trie fonctionne -->
<table id="" class="table table-bordered table-hover">
<thead>
<tr>
<th>Date de début</th> <!-- /.Table Client - Champs client_nom -->
<th align="center">Heure</th> <!-- /.Table Client - Champs client_adr1 -->
<th>Date de fin</th> <!-- /.Table Client - Champs client_cp -->
<th align="center">Heure</th> <!-- /.Table Client - Champs client_ville -->
<th>Motif</th>
<th></th>
</tr>
</thead>
<tbody>
<?php
while($cl=dbi_fetch_row($q))
{
if($cl['salarie_absence_date_fin'] ==00000000)
$dateFin = "Pas date de Fin" ;
else
$dateFin = int2date($cl['salarie_absence_date_fin']) ;
// echo "==> $dateFin " ;
list($motif)= dbi_fetch_row(dbi_query("SELECT absence_type_description FROM `absence_type` where absence_type_id =".$cl['absence_type_id'])) ;
?>
<tr>
<td><?=int2date($cl['salarie_absence_date_debut'])?></td>
<td align="center"><?=$cl['salarie_absence_heure_debut'] ?></td>
<td><?=$dateFin?></td>
<td align="center"><?=$cl['salarie_absence_heure_fin'] ?></td>
<td><?=$motif ?></td>
<td>
<a class="btn btn-info btn-sm" href="salarie_absence.php?salarie_absence_id=<?=$cl['salarie_absence_id']?>&">
<i class="fas fa-pencil-alt"> Editer</i>
</a>
<a class="btn btn-danger btn-sm" href="salarie_absence.php?salarie_absence_id=<?=$cl['salarie_absence_id']?>&sup=1" onclick="return confirm('Voulez-vous vraiment supprimer cette absence?');">
<i class="fas fa-trash"> Supprimer
</i>
</a>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
<div>
<br/>
<div class="card-header bg-primary text-white d-flex justify-content-center align-items-center"> <!-- Ajout de la classe d-flex et des classes justify-content-center et align-items-center pour centrer le contenu -->
<h5 class="card-title mb-0">Demandes des congés</h5>
</div>
<br/>
<? $q= dbi_query("SELECT * FROM salarie_absence where salarie_id = ".$salarie_idd." and statut_absence = 2 ORDER BY `salarie_absence`.`salarie_absence_date_debut` DESC") ;
?>
</div>
<? if (mysqli_num_rows($q) <= 0) { ?>
<div class="message-container">
<div class="message-icon">
<i class="fas fa-info-circle"></i> <!-- Utilisation d'une icône Bootstrap -->
</div>
<div class="message-text">
Aucune demande de congés pour le moment.
</div>
</div>
<? }else{ ?>
<table id="" class="table table-bordered table-hover">
<thead>
<tr>
<th>Date de début</th> <!-- /.Table Client - Champs client_nom -->
<th align="center">Heure</th> <!-- /.Table Client - Champs client_adr1 -->
<th>Date de fin</th> <!-- /.Table Client - Champs client_cp -->
<th align="center">Heure</th> <!-- /.Table Client - Champs client_ville -->
<th>Motif</th>
<th></th>
</tr>
</thead>
<tbody>
<?php
while($cl=dbi_fetch_row($q))
{
if($cl['salarie_absence_date_fin'] ==00000000)
$dateFin = "Pas date de Fin" ;
else
$dateFin = int2date($cl['salarie_absence_date_fin']) ;
// echo "==> $dateFin " ;
list($motif)= dbi_fetch_row(dbi_query("SELECT absence_type_description FROM `absence_type` where absence_type_id =".$cl['absence_type_id'])) ;
?>
<tr>
<td><?=int2date($cl['salarie_absence_date_debut'])?></td>
<td align="center"><?=$cl['salarie_absence_heure_debut'] ?></td>
<td><?=$dateFin?></td>
<td align="center"><?=$cl['salarie_absence_heure_fin'] ?></td>
<td><?=$motif ?></td>
<td>
<a class="btn btn-info btn-sm" href="salarie_absence.php?salarie_absence_id=<?=$cl['salarie_absence_id']?>&">
Accepter
</a>
<a class="btn btn-danger btn-sm" href="salarie_absence.php?salarie_absence_id=<?=$cl['salarie_absence_id']?>&sup=1" onclick="return confirm('Voulez-vous vraiment refuser cette absence?');">
Refuser
</a>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
<? } ?>
</div>
<!-- /.card-body -->
</div>
<!-- /.card -->
</div>
<!-- /.col -->
</div>
<!-- /.row -->
</section>
</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'); ?>
<!-- Control Sidebar -->
<aside class="control-sidebar control-sidebar-dark">
<!-- Control sidebar content goes here -->
</aside>
<!-- /.control-sidebar -->
</div>
<!-- ./wrapper -->
<!-- jQuery -->
<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_sal.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>
<script src="https://kit.fontawesome.com/a076d05399.js" crossorigin="anonymous"></script> <!-- Chargement de Font Awesome pour les icônes -->
</body>
</html>