/**
* get the tickets read by a user
*
* @param integer $IDUser
*
* @return array
* @author Dimitri Lameri <*****@*****.**>
*/
private function _getUserReadTickets($IDUser)
{
$StSQL = "\nSELECT\n\tT.IDTicket\nFROM\n\t" . DBPREFIX . "Ticket T\n\tLEFT JOIN " . DBPREFIX . "isRead R ON (T.IDTicket = R.IDTicket)\n\tLEFT JOIN " . DBPREFIX . "User U ON (U.IDUser = R.IDUser)\nWHERE\n U.IDUser = {$IDUser}\nAND\n T.StSituation != 'CLOSED'";
$this->execSQL($StSQL);
$ArRead = $this->getResult("string");
$ArRead = F1DeskUtils::sortByID($ArRead, 'IDTicket');
return $ArRead;
}
