|
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">
</head>
<body class="hold-transition skin-blue sidebar-mini">
<?php
// exit() ;
include 'code/init.php' ;
// print_header() ;
// echo "---> rtest<br/>" ;
$ooo=0 ;
// echo " test <br/>" ;
// exit() ;
?>
<script language="Javascript">
function GetIdBureau()
{
var idbursel="";
idbureausel = document.bureau_form.client_bureau.value ;
if( idbureausel > 0 || idbureausel=="INDEFINI" )
window.location = "t_prest.php?idbureausel="+idbureausel;
else
window.location = "t_prest.php";
}
</script>
<?php
$_SESSION['tt'] = "" ;
if($_GET['idbureausel'] && !empty($_GET['idbureausel']) )
{
if($_GET['idbureausel']>0)
{
$idbureausel=$_GET['idbureausel'];
$tabbursel=dbi_fetch_row((dbi_query('select * from bureau where id_bureau='.$_GET['idbureausel'].' and agence_id='.$agence.''))) ;
$id_bureau=$tabbursel['id_bureau'];
$nom_bureau=$tabbursel['nom_agence'];
$where1=" AND ID_Bureau != $id_bureau ";
$where2=" AND inter_bureau = $id_bureau ";
$_SESSION['tt']= " AND inter_bureau = $id_bureau ";
}
elseif($_GET['idbureausel']=="INDEFINI")
{
$id_bureau=$_GET['idbureausel'];
$where2=" AND client_bureau='0' ";
$selected='selected="selected"';
}
}
define ('BAD', '#FD0005');
define ('GOOD', '#2DCD0C');
$mois=array('01' =>'janvier','02' =>'fevrier','03' =>'mars','04' =>'avril','05' =>'mai','06' =>'juin','07' =>'juillet','08' =>'aout','09' => 'septembre','10' => 'octobre','11' => 'novembre','12' => 'decembre');
if(!empty($_POST['interv']))
{
// echo "<pre>" ;
// print_r($_POST['interv']) ;
// echo "<pre>" ;
// exit() ;
$from = getPostDate('from') ;
$to = getPostDate('to') ;
// echo "$from <br/>" ;
// echo "$to <br/>" ;
$liste = array() ;
// printf('<h2 align="center">Heures travail du %s au %s</h2>', int2date($from), int2date($to)) ;
$hb_gtot = 0;
$hcomp_gtot = 0;
$hsup_gtot = 0;
$delta_gtot = 0;
?>
<br/><br/><br/>
<div class="box-body">
<table id="example1" class="table table-bordered table-striped">
<thead>
<tr>
<th >Nom du salariés</th>
<th >date</th>
<th>Nom du client</th>
<th >Heure de debut</th>
<th > Heure de fin</th>
<th > Heure de Pointage</th>
</tr>
</thead>
<tbody>
<?
foreach($_POST['interv'] as $interv)
{
$intervenant = dbi_fetch_row(dbi_query("select CONCAT( inter_genre, ' ' ,inter_nom, ' ' ,inter_pnom ) as nom from ".TABLE_INTERV." where inter_id = $interv LIMIT 1")) ;
$inter = dbi_fetch_row(dbi_query("SELECT * FROM " . TABLE_INTERV . " WHERE inter_id = $interv AND agence_id=$agence")) ;
$eche= dbi_fetch_row(dbi_query("SELECT Echelon FROM echelon where echelon_ID = ".$inter['echelon_ID']));
$inti= dbi_fetch_row(dbi_query("SELECT intitule FROM poste_intitule where poste_intitule_ID = ".$inter['poste_intitule_ID']));
$po= dbi_fetch_row(dbi_query("SELECT Position FROM position where position_ID = ".$inter['position_ID']));
if($inter['inter_paiement']==0)
{
$inter_paiement= "mensuel" ;
}
else
{
$inter_paiement= "hebdomadaire" ;
}
// echo '<b>'.$intervenant['nom'].'</b>'." Niveau : ".$inti['intitule']." - Position : ".$po['Position']." - Echelon : ".$eche['Echelon']." - paiement : $inter_paiement" ;
$debut = $from ;
$hm = 0;
$ht_tot = 0;
$hb_tot = 0;
$hcomp_tot = 0;
$hsup_tot = 0;
$habs_tot=0;
$deltap_tot = 0;
$deltan_tot = 0;
for ($i = 0 ; $debut <= $to ; $i++)
{
$part = heuresSemaine_telepointage($interv, $debut, $to, $sem) ;
// echo"<pre>" ;
// print_r($part) ;
// echo"</pre>" ;
$tailletab= sizeof($part) ;
// echo "==>$tailletab <br/>" ;
for($k=0 ; $k<$tailletab;$k++)
{
$chntid = $part[$k]['chantier_id'] ;
list($chant_id)= dbi_fetch_row(dbi_query("SELECT Chantier_ID FROM fact_chantier WHERE ID = ".$part[$k]['chantier_id'])) ;
list($x ,$y ,$client_id )= dbi_fetch_row(dbi_query("SELECT client_nom,client_pnom ,cl.client_id FROM chantier ch , client cl WHERE ch.Client_ID = cl.client_id and Chantier_ID = ".$chant_id)) ;
$inter_id = $part[$k]['inter'] ;
$datp = int2date($part[$k]['date']) ;
list($heurr)= dbi_fetch_row(dbi_query("SELECT Heure FROM telepointage WHERE inter_id = $inter_id and client_id = $client_id and Date=$datp ")) ;
dbi_query("INSERT INTO telepointage_prestation (id,client_id,inter_id,datepresta,heur_d,duree)
VALUES('','".$client_id."','".$inter_id."','".$part[$k]['date']."','".$part[$k]['deb']."','".$part[$k]['duree']."')");
}
$debut = int2time($debut) ;
// debut de la semaine suivante
$debut = time2int($debut + (8-(date("w", $debut) ? date("w", $debut) : 7))*24*3600+3600) ;
}
}
$q= dbi_query("SELECT * FROM `telepointage_prestation` ORDER BY `telepointage_prestation`.`datepresta` ASC") ;
while($ftch= dbi_fetch_row($q))
{
$inter_id =$ftch['inter_id'] ;
$client_id = $ftch['client_id'] ;
$datp = int2date($ftch['datepresta']) ;
list($heurr)= dbi_fetch_row(dbi_query("SELECT Heure FROM telepointage WHERE inter_id = $inter_id and client_id = $client_id and Date=$datp ")) ;
list($nom ,$pnom )= dbi_fetch_row(dbi_query("SELECT inter_nom,inter_pnom FROM `intervenant` WHERE `inter_id` = ".$ftch['inter_id'])) ;
list($nomc ,$pnomc ,$client_id )= dbi_fetch_row(dbi_query("SELECT client_nom,client_pnom FROM client cl WHERE cl.client_id = ".$ftch['client_id'])) ;
?>
<tr>
<td><?=$nom." ".$pnom?> </td>
<td><?=int2date($ftch['datepresta'])?> </td>
<td><?=$nomc." ".$pnomc?> </td>
<td><?=int2heure($ftch['heur_d'])?> </td>
<td><?=int2heure(addDuree($ftch['heur_d'], $ftch['duree']))?></td>
<td><?=$heurr?> </td>
</tr>
<?
}
dbi_query('TRUNCATE TABLE telepointage_prestation ')
?>
</tbody>
</table>
</div>
<?
}
?>
<form action="" method="post" name="paye">
<input type="hidden" value="<?=$interv?>">
<table>
<tr>
<td>Du</td>
<td><?=print_date_selection('from', $fact_du, -5, 10, 'paye')?></td>
</tr>
<tr>
<td>Au</td>
<td><?=print_date_selection('to', $fact_au, -5, 10, 'paye')?></td>
</tr>
<tr valign="middle">
<td>Intervenant(s)
</td>
<td>
<?=get_intervenants_drop_down('interv[]', 'multiple title="Utiliser Ctrl + clic pour sélectionner ou désélectionner un intervenant" style="width:260px"', $_POST['interv'], false)?>
(<span title="Utiliser Ctrl + clic pour sélectionner ou désélectionner un intervenant" style="text-decoration:underline; color:#0000FF; cursor:help;">Aide</span>)<br />
<a href="" onClick="var sel = document.forms[0].elements[9].options ; for (var i = 0 ; i < sel.length ; i++) sel[i].selected=true; return false;">Sélectionner tout</a> | <a href="" onClick="var sel = document.forms[0].elements[9].options ; for (var i = 0 ; i < sel.length ; i++) sel[i].selected=false; return false;">Désélectionner tout</a>
</td>
</tr>
</table>
<input type="submit" class="bigbutton" value="Créer" onClick="this.disabled=true;this.form.submit();">
</form>
<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>