function isHoliday($date)
{
global $DB;
$query = "SELECT COUNT(*) AS cpt\n FROM `glpi_calendars_holidays`\n INNER JOIN `glpi_holidays`\n ON (`glpi_calendars_holidays`.`holidays_id` = `glpi_holidays`.`id`)\n WHERE `glpi_calendars_holidays`.`calendars_id` = '" . $this->fields['id'] . "'\n AND (('{$date}' <= `glpi_holidays`.`end_date`\n AND '{$date}' >= `glpi_holidays`.`begin_date`)\n OR (`glpi_holidays`.`is_perpetual` = 1\n AND MONTH(`end_date`)*100 + DAY(`end_date`)\n >= " . date('nd', strtotime($date)) . "\n AND MONTH(`begin_date`)*100 + DAY(`begin_date`)\n <= " . date('nd', strtotime($date)) . "\n )\n )";
if ($result = $DB->query($query)) {
return $DB->result($result, 0, 'cpt');
}
return false;
}