Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- protected function checkEvent($param)
- {
- $dateStart = $param['dateTimeStart']/1000;
- $dateEnd = $param['dateTimeEnd']/1000;
- $day = date("Y-m-d", $param['dateTimeStart']/1000);
- $day = $this->pdo->quote($day.'%');
- $idRoom = $this->pdo->quote($param['id_room']);
- $sql = 'SELECT '
- .' time_start,'
- .' time_end'
- .' FROM events'
- .' WHERE'
- .' time_start'
- .' LIKE'
- .' '.$day
- .' AND id_room ='.$idRoom;
- $data = $this->selectQuery($sql);
- if (!is_array($data))
- {
- return true;
- }
- foreach ($data as $val)
- {
- $arrStart = strtotime($val['time_start']);
- $arrEnd = strtotime($val['time_end']);
- if (($arrStart < $dateStart && $arrEnd <= $dateStart) || ($dateEnd <= $arrStart && $dateEnd < $arrEnd))
- {
- return true;
- }
- else{
- return false;
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement