static public isAWorkingHour ( $calendars_id, $day, $hour ) : boolean | ||
$calendars_id | id of the calendar | |
$day | day number | |
$hour | hour (Format HH:MM::SS) | |
return | boolean |
static function isAWorkingHour($calendars_id, $day, $hour)
{
global $DB;
$sum = 0;
// Do not check hour if day before the end day of after the begin day
$query = "SELECT *\n FROM `glpi_calendarsegments`\n WHERE `calendars_id` = '{$calendars_id}'\n AND `day` = '{$day}'\n AND `begin` <= '{$hour}'\n AND `end` >= '{$hour}'";
if ($result = $DB->query($query)) {
if ($DB->numrows($result)) {
return true;
}
}
return false;
}
/** * Is the time passed is in a working hour * * @since version 0.85 * * @param $time time time to check * * @return boolean **/ function isAWorkingHour($time) { if ($this->isAWorkingDay($time)) { $dayofweek = self::getDayNumberInWeek($time); return CalendarSegment::isAWorkingHour($this->fields['id'], $dayofweek, date('H:i:s', $time)); } return false; }