Calendar::isHoliday PHP Method

    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;
    }

 /**
  * @return bool
  */
 public function isHoliday()
 {
     return Calendar::isHoliday($this);
 }