|
Server IP : 10.128.40.6 / Your IP : 216.73.217.36 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/MC/../www/mcg/plugins/jszip/../../.github/../sms/../pages/python/../ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
// error_reporting(E_ALL);
// ini_set("display_errors", 1);
// $from = '2020-04-01';
// $to = '2020-04-01';
// 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;
// }
function dateDifference($date1, $date2)
{
$first = DateTime::createFromFormat('m/d/Y', $date1);
$second = DateTime::createFromFormat('m/d/Y', $date2);
if($date1 > $date2) return week_between_two_dates($date2, $date1);
return floor($first->diff($second)->days/7);
}
function convertToHoursMins($time, $format = '%02d:%02d') {
if ($time < 1) {
return;
}
$hours = floor($time / 60);
$minutes = ($time % 60);
return sprintf($format, $hours, $minutes);
}
// echo ' OK '.dateDifference($from,$to).'<br>';
// echo ' OK '.$totalnoOfWeek .'<br>';uuuu
// 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();
$client_id=$_SESSION["client_id"] ;
$now = new DateTime();
$start = dateformaint($_GET['date']);
$end = date("Ymt", strtotime($_GET['date']));
// $end = $now -> format('Ymt');
$date = $start ;
$i=0 ;
while ($date <= $end )
{
// echo "SELECT * FROM PRESTATIONS p where p.client_id = ".$client_id." AND presta_date_debut < $date AND (p.presta_date_fin >= $date OR p.presta_date_fin IS NULL) ".'<br> ' ;
// echo "SELECT * FROM PRESTATIONS p where p.client_id = ".$client_id." AND presta_date_debut <= $date AND (p.presta_date_fin >= $date OR p.presta_date_fin IS NULL) ".'<br>';
// echo "SELECT * FROM PRESTATIONS p where p.client_id = ".$client_id." AND presta_date_debut <= $date AND (p.presta_date_fin >= $date OR p.presta_date_fin IS NULL) <br>";
$q = dbi_query("SELECT * FROM PRESTATIONS p where p.client_id = ".$client_id." AND presta_date_debut <= $date AND (p.presta_date_fin >= $date OR p.presta_date_fin IS NULL) ");
while($prest = dbi_fetch_row($q))
{
$date_presta_sem = $prest['presta_date_debut'] ;
$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'])
{
if( $m['presta_sem'] != NULL ) $date_presta_sem = $m['start'];
$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'] ;
}
// if($prest['presta_id'] == 135727 )
// echo $prest['presta_jour'];
$day = date("w", strtotime( int2date_autre_format($date)));
if( $day == $prest['presta_jour'] OR ( $date == $prest['presta_date_debut'] && $prest['presta_date_debut'] == $prest['presta_date_fin'] ) ){
// $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 )
{
$SAL = dbi_fetch_row(dbi_query("SELECT * FROM salarie WHERE salarie_id = ".$prest['salarie_id'] ." " )) ; ;
$data[$i]['id'] = $prest["presta_id"];
$data[$i]['title'] = '('. convertToHoursMins($prest['presta_Hduree'], '%01dh%02d').") ".$SAL["salarie_nom"];
$data[$i]['start'] = $istart;
$data[$i]['end'] = $iend;
$data[$i]['date'] = $date;
if( $prest['presta_date_debut'] == $prest['presta_date_fin'] )
{
if( $prest['prestation_type'] == 1 ){
$data[$i]['backgroundColor'] = '#ffffff';
$data[$i]['borderColor'] = '#007bf';
$data[$i]['textColor'] = '#007bf';
}
else if( $prest['prestation_type'] == 2 )
{
$data[$i]['backgroundColor'] = '#ffffff';
$data[$i]['borderColor'] = '#28a745';
$data[$i]['textColor'] = '#28a745';
}
else if( $prest['prestation_type'] == 3 )
{
$data[$i]['backgroundColor'] = '#ffffff';
$data[$i]['borderColor'] = '#ffc107';
$data[$i]['textColor'] = '#ffc107';
}
else
{
$data[$i]['backgroundColor'] = '#ffffff';
$data[$i]['borderColor'] = '#e83e8c';
$data[$i]['textColor'] = '#e83e8c';
}
}
else
{
if( $prest['prestation_type'] == 1 ){
$data[$i]['backgroundColor'] = '#007bf';
$data[$i]['borderColor'] = '#007bf';
}
else if( $prest['prestation_type'] == 2 )
{
$data[$i]['backgroundColor'] = '#28a745';
$data[$i]['borderColor'] = '#28a745';
}
else if( $prest['prestation_type'] == 3 )
{
$data[$i]['backgroundColor'] = '#ffc107';
$data[$i]['borderColor'] = '#ffc107';
}
else
{
$data[$i]['backgroundColor'] = '#e83e8c';
$data[$i]['borderColor'] = '#e83e8c';
}
}
// $data[$i]['url'] = $date;
++$i;
}
else
{
$nbre = dateDifference(int2date_autre_format($date_presta_sem,'m/d/Y'),int2date_autre_format($date,'m/d/Y')) - 1;
// echo $date.' ** '.$nbre .' ** </br>';
if( $nbre % $prest['presta_sem'] != 0) {
$SAL = dbi_fetch_row(dbi_query("SELECT * FROM salarie WHERE salarie_id = ".$prest['salarie_id'] ." " )) ; ;
$data[$i]['id'] = $prest["presta_id"];
$data[$i]['title'] = '('. convertToHoursMins($prest['presta_Hduree'], '%01dh%02d').") ".$SAL["salarie_nom"];
$data[$i]['start'] = $istart;
$data[$i]['end'] = $iend;
$data[$i]['date'] = $date;
if( $prest['presta_date_debut'] == $prest['presta_date_fin'] )
{
if( $prest['prestation_type'] == 1 ){
$data[$i]['backgroundColor'] = '#ffffff';
$data[$i]['borderColor'] = '#007bf';
$data[$i]['textColor'] = '#007bf';
}
else if( $prest['prestation_type'] == 2 )
{
$data[$i]['backgroundColor'] = '#ffffff';
$data[$i]['borderColor'] = '#28a745';
$data[$i]['textColor'] = '#28a745';
}
else if( $prest['prestation_type'] == 3 )
{
$data[$i]['backgroundColor'] = '#ffffff';
$data[$i]['borderColor'] = '#ffc107';
$data[$i]['textColor'] = '#ffc107';
}
else
{
$data[$i]['backgroundColor'] = '#ffffff';
$data[$i]['borderColor'] = '#e83e8c';
$data[$i]['textColor'] = '#e83e8c';
}
}
else
{
if( $prest['prestation_type'] == 1 ){
$data[$i]['backgroundColor'] = '#007bf';
$data[$i]['borderColor'] = '#007bf';
}
else if( $prest['prestation_type'] == 2 )
{
$data[$i]['backgroundColor'] = '#28a745';
$data[$i]['borderColor'] = '#28a745';
}
else if( $prest['prestation_type'] == 3 )
{
$data[$i]['backgroundColor'] = '#ffc107';
$data[$i]['borderColor'] = '#ffc107';
}
else
{
$data[$i]['backgroundColor'] = '#e83e8c';
$data[$i]['borderColor'] = '#e83e8c';
}
}
// $data[$i]['url'] = $date;
++$i;
}
if( $prest['presta_date_debut'] == $prest['presta_date_fin'] )
$data[$i]['borderColor'] = '#000000';
}
}
}
// 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);
}
?>