|
Server IP : 10.128.40.6 / Your IP : 216.73.217.20 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 (0755) : /home/logmcpe/www/TMCPRO/pages/python/../ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
// $from = '2020-04-01';
// $to = '2020-04-01';
if(isset($_GET['salarie_id']))
$salarie_id = $_GET['salarie_id'];
else
$salarie_id = 2722;
function dateDifference($strtDate , $endDate )
{
$startDateWeekCnt = round(floor( date('d',strtotime($strtDate)) / 7)) ;
$endDateWeekCnt = round(ceil( date('d',strtotime($endDate)) / 7)) ;
$datediff = strtotime(date('Y-m',strtotime($endDate))."-01") - strtotime(date('Y-m',strtotime($strtDate))."-01");
$totalnoOfWeek = round(floor($datediff/(60*60*24)) / 7) + $endDateWeekCnt - $startDateWeekCnt ;
return $totalnoOfWeek;
}
// echo ' OK '.dateDifference($from,$to).'<br>';
// echo ' OK '.$totalnoOfWeek .'<br>';
// function dateDifference($date_1 , $date_2 , $differenceFormat = '%a' )
// {
// $datetime1 = date_create($date_1);
// $datetime2 = date_create($date_2);
// $interval = date_diff($datetime1, $datetime2);
// return $interval->format($differenceFormat);
// }
// echo ' OK '.dateDifference($strtDate,$endDate).'<br>';
// if(isset($_GET['date'])){
// [
// {"id":"100","title":"salarie : 3","start":"2020-03-01 06:00:00","end":"2020-03-01 07:00:00","date":"20200301"},
// {"id":"101","title":"salarie : 3","start":"2020-03-02 06:00:00","end":"2020-03-02 07:00:00","date":"20200302"}
// ]
// }
if(isset($_GET['date'])){
include 'includes/config_tmcpro.php' ;
include 'includes/stable_functions_tmcpro.php' ;
$data = array();
$now = new DateTime();
$start = dateformaint($_GET['date']);
$end = date("Ymt", strtotime($_GET['date']));
// $end = $now -> format('Ymt');
$date = $start ;
$i=0 ;
while ($date <= $end )
{
// $q = dbi_query("
// SELECT * FROM PRESTATIONS p where presta_date_debut <= $date AND (p.presta_date_fin >= $date OR p.presta_date_fin IS NULL)
// AND p.presta_id IN ( select presta_id FROM PRESTATIONS_MODIF WHERE salarie_id = $salarie_id )
// ");
$q = dbi_query("
SELECT * FROM PRESTATIONS p where presta_date_debut <= $date AND (p.presta_date_fin >= $date OR p.presta_date_fin IS NULL)
AND ( p.presta_id IN (select presta_id FROM PRESTATIONS WHERE salarie_id = $salarie_id ) OR p.presta_id IN ( select presta_id FROM PRESTATIONS_MODIF WHERE salarie_id = $salarie_id ) )
");
// echo "
// SELECT * FROM PRESTATIONS p where presta_date_debut <= $date AND (p.presta_date_fin >= $date OR p.presta_date_fin IS NULL)
// AND (p.presta_id IN (select presta_id FROM PRESTATIONS WHERE salarie_id = $salarie_id ) OR p.presta_id IN ( select presta_id FROM PRESTATIONS_MODIF WHERE salarie_id = $salarie_id ) )
// ".'<br>';
while($prest = dbi_fetch_row($q))
{
$q1 = dbi_query("SELECT * FROM PRESTATIONS_MODIF WHERE presta_id = ".$prest['presta_id']." order by start, modif_id ") ;
while (($m = dbi_fetch_row($q1)) && $date >= $m['start'])
{
$prest['salarie_id'] = $m['salarie_id'] === NULL ? $prest['salarie_id'] : $m['salarie_id'] ;
$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['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'] ;
}
if( $prest['salarie_id'] == $salarie_id ) {
$day = date("w", strtotime( int2date_autre_format($date)));
if( $day == $prest['presta_jour']){
// $istart = str_pad($prest['presta_Hdeb'] / 10000 , 2, '0', STR_PAD_LEFT) ;
$hstart = str_pad(round($prest['presta_Hdeb'] / 10000, 0) , 2, '0', STR_PAD_LEFT) ;
$mstart = str_pad(($prest['presta_Hdeb'] % 10000)/100 , 2, '0', STR_PAD_LEFT);
$hend = str_pad(round(addDuree($prest['presta_Hdeb'], $prest['presta_Hduree']) / 10000, 0) , 2, '0', STR_PAD_LEFT) ;
$mend = str_pad((addDuree($prest['presta_Hdeb'], $prest['presta_Hduree']) % 10000)/100 , 2, '0', STR_PAD_LEFT);
// $iend = str_pad(addDuree($prest['presta_Hdeb'], $prest['presta_Hduree'])/ 10000 , 2, '0', STR_PAD_LEFT) ;
$istart = int2date_autre_format($date).' '.$hstart.':'.$mstart.':00';
$iend = int2date_autre_format($date).' '.$hend.':'.$mend.':00';
// int2date_autre_format($prest['presta_date_debut'])
// echo "<pre>";
// print_r($prest);
// echo "</pre>";
// $iend = $prest['presta_Hduree'] ;
// $istart = $prest[' presta_Hdeb'] ;
// $prestation_jour_heurd = date('Y-m-d', $i)." ".$_POST['prestation_jour_heurd'].":00" ;
// echo $istart .' !! !! '.$iend .'<br>';
// $astart = int2date_autre_format($date).' '.'11:00:00';
// if ($prest['presta_id'] == 32)
// echo dateDifference(int2date_autre_format($prest['presta_date_debut']),int2date_autre_format($date)).' !! '. $prest['presta_sem'].' $$ '.dateDifference(int2date_autre_format($prest['presta_date_debut']),int2date_autre_format($date))% $prest['presta_sem'] .'<br>';
$EXP = dbi_fetch_row(dbi_query("SELECT date_presta FROM EXCEPTIONS WHERE presta_id = ".$prest['presta_id']." AND date_presta = ".$date." " )) ; ;
if($EXP ){} else {
if( $prest['presta_sem'] == 1 )
{
$Clt = dbi_fetch_row(dbi_query("SELECT * FROM client WHERE client_id = ".$prest['client_id'] ." " )) ; ;
$data[$i]['id'] = $prest["presta_id"];
$data[$i]['title'] = $prest['client_id']." ".$Clt["client_nom"];
$data[$i]['start'] = $istart;
$data[$i]['end'] = $iend;
$data[$i]['date'] = $date;
// $data[$i]['backgroundColor'] = '#00a65a';
// $data[$i]['backgroundColor'] = '#00a65a';
// backgroundColor: '#00a65a', //Success (green)
// borderColor : '#00a65a' //Success (green)
++$i;
}
else
{
$nbre = dateDifference(int2date_autre_format($prest['presta_date_debut']),int2date_autre_format($date)) - 1;
if( $nbre % $prest['presta_sem'] == 0) {
$Clt = dbi_fetch_row(dbi_query("SELECT * FROM client WHERE client_id = ".$prest['client_id'] ." " )) ; ;
$data[$i]['id'] = $prest["presta_id"];
$data[$i]['title'] = $prest['client_id']." ".$Clt["client_nom"];
$data[$i]['start'] = $istart;
$data[$i]['end'] = $iend;
$data[$i]['date'] = $date;
// $data[$i]['backgroundColor'] = '#00a65a';
// $data[$i]['backgroundColor'] = '#00a65a';
++$i;
}
}
}
}
}
// echo date("Ymd", strtotime( int2date_autre_format($date))).' !! '.$prest['presta_id'].' $$ '.$prest['presta_jour'].'<br>';
}
// $date = time2int($time) ;
$date = date("Ymd", strtotime("+1 day", strtotime($date)));
}
// 2020-05-01 11:00:00
// $q = dbi_query(" SELECT * FROM prestation_jour pj , prestation p where p.prestation_id = pj.prestation_id and p.client_id = $client_id ") ;
// $i=0 ;
// while($row=dbi_fetch_row($q))
// {
// list($salarie_nom)= dbi_fetch_row(dbi_query(" SELECT salarie_nom FROM `salarie` WHERE salarie_id = ".$row["salarie_id"])) ;
// $data[$i]['id'] = $row["prestation_jour_id"];
// $data[$i]['title'] = "salarie : ".$salarie_nom;
// $data[$i]['start'] = $row["prestation_jour_heurd"];
// $data[$i]['end' ] = $row["prestation_jour_heurf"] ;
// $data[$i]['salarie_id' ] = $row["salarie_id"] ;
// $i++;
// }
echo json_encode($data);
}
?>