function getUsedRecipientBetween($date1 = '', $date2 = '')
{
global $DB;
$query = "SELECT DISTINCT `glpi_users`.`id` AS user_id,\n `glpi_users`.`name` AS name,\n `glpi_users`.`realname` AS realname,\n `glpi_users`.`firstname` AS firstname\n FROM `" . $this->getTable() . "`\n LEFT JOIN `glpi_users`\n ON (`glpi_users`.`id` = `" . $this->getTable() . "`.`users_id_recipient`)\n WHERE NOT `" . $this->getTable() . "`.`is_deleted` " . getEntitiesRestrictRequest("AND", $this->getTable());
if (!empty($date1) || !empty($date2)) {
$query .= " AND (" . getDateRequest("`" . $this->getTable() . "`.`date`", $date1, $date2) . "\n OR " . getDateRequest("`" . $this->getTable() . "`.`closedate`", $date1, $date2) . ") ";
}
$query .= " ORDER BY realname, firstname, name";
$result = $DB->query($query);
$tab = array();
if ($DB->numrows($result) >= 1) {
while ($line = $DB->fetch_assoc($result)) {
$tmp['id'] = $line["user_id"];
$tmp['link'] = formatUserName($line["user_id"], $line["name"], $line["realname"], $line["firstname"], 1);
$tab[] = $tmp;
}
}
return $tab;
}