Advertisement
Guest User

Untitled

a guest
Nov 5th, 2017
120
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.  protected function checkEvent($param)
  2.     {
  3.         $dateStart = $param['dateTimeStart']/1000;
  4.         $dateEnd = $param['dateTimeEnd']/1000;
  5.         $day = date("Y-m-d", $param['dateTimeStart']/1000);
  6.         $day = $this->pdo->quote($day.'%');
  7.         $idRoom = $this->pdo->quote($param['id_room']);
  8.         $sql = 'SELECT '
  9.             .' time_start,'
  10.             .' time_end'
  11.             .' FROM events'
  12.             .' WHERE'
  13.             .' time_start'
  14.             .' LIKE'
  15.             .' '.$day
  16.             .' AND id_room ='.$idRoom;
  17.         $data = $this->selectQuery($sql);
  18.  
  19.         if (!is_array($data))
  20.         {
  21.             return true;
  22.         }
  23.         foreach ($data as $val)
  24.         {
  25.             $arrStart = strtotime($val['time_start']);
  26.             $arrEnd = strtotime($val['time_end']);
  27.             if (($arrStart < $dateStart && $arrEnd <= $dateStart) || ($dateEnd <= $arrStart && $dateEnd < $arrEnd))
  28.             {
  29.                 return true;
  30.             }
  31.             else{
  32.                 return false;
  33.             }
  34.         }
  35.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement