}
if (!isset($_REQUEST['sort'])) {
$_REQUEST['sort'] = "entity";
$_REQUEST['order'] = "ASC";
}
$limit = $_SESSION['glpilist_limit'];
if (isset($_POST["display_type"])) {
$output_type = $_POST["display_type"];
if ($output_type < 0) {
$output_type = -$output_type;
$limit = 0;
}
} else {
$output_type = Search::HTML_OUTPUT;
}
$title = $report->getFullTitle();
//to verify if resources exist
// SQL statement
$condition = getEntitiesRestrictRequest('WHERE', 'glpi_plugin_resources_resources');
$date = date("Y-m-d");
$dataAll = array();
//case resource
$query = "SELECT `glpi_plugin_resources_resources`.`entities_id` AS entity,\n 'Resource' AS typeName,\n `glpi_plugin_resources_resources`.`name` AS name,\n `glpi_plugin_resources_resources`.`id` AS ID,\n `glpi_plugin_resources_resources`.`firstname` AS firstname,\n `glpi_users`.`registration_number` AS registration_number,\n `glpi_plugin_resources_professions`.`id` AS profID,\n `glpi_plugin_resources_professions`.`name` AS profession,\n `glpi_plugin_resources_resources`.`date_begin`,\n `glpi_plugin_resources_resources`.`date_end`,\n `glpi_plugin_resources_professions`.`begin_date`,\n `glpi_plugin_resources_professions`.`end_date`\n FROM `glpi_users`\n LEFT JOIN `glpi_plugin_resources_resources_items`\n ON (`glpi_users`.`id` = `glpi_plugin_resources_resources_items`.`items_id`\n AND `glpi_plugin_resources_resources_items`.`itemtype`= 'User')\n LEFT JOIN `glpi_plugin_resources_resources`\n ON (`glpi_plugin_resources_resources`.`id` = `glpi_plugin_resources_resources_items`.`plugin_resources_resources_id`)\n LEFT JOIN `glpi_plugin_resources_ranks`\n ON (`glpi_plugin_resources_resources`.`plugin_resources_ranks_id` = `glpi_plugin_resources_ranks`.`id`)\n LEFT JOIN `glpi_plugin_resources_professions`\n ON (`glpi_plugin_resources_professions`.`id` = `glpi_plugin_resources_ranks`.`plugin_resources_professions_id`)\n WHERE ((`glpi_plugin_resources_resources`.`date_begin` < '" . $date . "'\n AND (`glpi_plugin_resources_resources`.`date_end` IS NULL\n OR `glpi_plugin_resources_resources`.`date_end` > '" . $date . "'))\n AND `glpi_plugin_resources_professions`.`id` IS NOT NULL\n AND `glpi_plugin_resources_resources`.`is_leaving` = '0'\n AND `glpi_plugin_resources_resources`.`is_deleted` = '0'\n AND `glpi_plugin_resources_resources`.`is_template` = '0')\n AND ((`glpi_plugin_resources_resources`.`date_begin` > `glpi_plugin_resources_professions`.`end_date`\n OR `glpi_plugin_resources_resources`.`date_end` < `glpi_plugin_resources_professions`.`begin_date`)\n OR (`glpi_plugin_resources_professions`.`end_date` < '" . $date . "'\n OR `glpi_plugin_resources_professions`.`begin_date` > '" . $date . "'))";
// WHERE ((`glpi_plugin_resources_resources`.`date_begin` > `glpi_plugin_resources_ranks`.`end_date`
// OR `glpi_plugin_resources_resources`.`date_end` < `glpi_plugin_resources_professions`.`begin_date`
// OR `glpi_plugin_resources_resources`.`date_begin` < '".$date."'
// AND `glpi_plugin_resources_resources`.`date_end` IS NULL
// AND (`glpi_plugin_resources_professions`.`end_date` < '".$date."'
// OR `glpi_plugin_resources_professions`.`begin_date` > '".$date."'))
// AND `glpi_plugin_resources_professions`.`id` IS NOT NULL
// AND `glpi_plugin_resources_resources`.`is_leaving` = '0'
