|
Server IP : 10.128.40.6 / Your IP : 216.73.217.36 Web Server : Apache System : Linux webd006.cluster128.gra.hosting.ovh.net 6.18.39-ovh-vps-grsec-zfs+ #1 SMP PREEMPT_DYNAMIC Tue Jul 21 12:03:15 CEST 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/MC/../www/mcg/plugins/jszip/../../.github/../test/../pages/python/../ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
include 'includes/config_tmcpro.php' ;
include 'includes/stable_functions_tmcpro.php' ;
$data = array();
$date = date("Ymd");
$i = 1;
// SELECT * FROM PRESTATIONS WHERE client_id=".$client_id." AND ((presta_date_debut != presta_date_fin && presta_date_fin >= '".$date."') OR presta_date_fin IS NULL ) ORDER BY presta_date_debut"
// echo "SELECT * FROM PRESTATIONS p where ((presta_date_debut != presta_date_fin && presta_date_fin >= '".$date."') OR presta_date_fin IS NULL )";
$q = dbi_query("SELECT * FROM PRESTATIONS WHERE ((presta_date_debut != presta_date_fin && presta_date_fin >= '".$date."') OR presta_date_fin IS NULL )");
while($prest = dbi_fetch_row($q))
{
$q1 = dbi_query("SELECT * FROM PRESTATIONS_MODIF WHERE presta_id = ".$prest['presta_id']." AND start <= '".$date."' order by start, modif_id ") ;
while ($m = dbi_fetch_row($q1))
{
$prest['presta_sem'] = $m['presta_sem'] === NULL ? $prest['presta_sem'] : $m['presta_sem'] ;
$prest['presta_jour'] = $m['presta_jour'] === NULL ? $prest['presta_jour'] : $m['presta_jour'] ;
$prest['presta_Hdeb'] = $m['presta_Hdeb'] === NULL ? $prest['presta_Hdeb'] : $m['presta_Hdeb'] ;
$prest['presta_Hduree'] = $m['presta_Hduree'] === NULL ? $prest['presta_Hduree'] : $m['presta_Hduree'] ;
$prest['salarie_id'] = $m['salarie_id'] === NULL ? $prest['salarie_id'] : $m['salarie_id'] ;
$prest['chantier_id'] = $m['chantier_id'] === NULL ? $prest['chantier_id'] : $m['chantier_id'] ;
$prest['presta_forfait'] = $m['presta_forfait'] === NULL ? $prest['presta_forfait'] : $m['presta_forfait'] ;
}
echo $i.' $$ '.$prest['presta_id'].' ** '.$prest['client_id'].' ** '.$prest['presta_jour'].' ** '.$prest['salarie_id'].'<br>';
++$i;
}
?>