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