/** * fetchTableData * @access protected * @return ilMailFolderTableGUI * */ protected function fetchTableData() { /** * @var $ilUser ilObjUser */ global $ilUser; // table title if ($this->_folderNode['m_type'] == 'user_folder') { $txt_folder = $this->_folderNode['title']; $img_folder = 'icon_user_folder.png'; } else { $txt_folder = $this->lng->txt('mail_' . $this->_folderNode['title']); $img_folder = 'icon' . substr($this->_folderNode['title'], 1) . '.png'; } try { if ($this->isLuceneSearchEnabled()) { include_once 'Services/Mail/classes/class.ilMailLuceneQueryParser.php'; $query_parser = new ilMailLuceneQueryParser($this->filter['mail_filter']); $query_parser->setFields(array('title' => (bool) $this->filter['mail_filter_subject'], 'content' => (bool) $this->filter['mail_filter_body'], 'mattachment' => (bool) $this->filter['mail_filter_attach'], 'msender' => (bool) $this->filter['mail_filter_sender'], 'mrcp' => (bool) $this->filter['mail_filter_recipients'])); $query_parser->parse(); require_once 'Services/Mail/classes/class.ilMailLuceneSearcher.php'; require_once 'Services/Mail/classes/class.ilMailSearchResult.php'; $result = new ilMailSearchResult(); $searcher = new ilMailLuceneSearcher($query_parser, $result); $searcher->search($ilUser->getId(), $this->_currentFolderId); if (!$result->getIds()) { throw new ilException('mail_search_empty_result'); } ilMailBoxQuery::$filtered_ids = $result->getIds(); ilMailBoxQuery::$filter = array(); } else { ilMailBoxQuery::$filter = (array) $this->filter; } $this->determineOffsetAndOrder(); ilMailBoxQuery::$folderId = $this->_currentFolderId; ilMailBoxQuery::$userId = $ilUser->getId(); ilMailBoxQuery::$limit = $this->getLimit(); ilMailBoxQuery::$offset = $this->getOffset(); ilMailBoxQuery::$orderDirection = $this->getOrderDirection(); ilMailBoxQuery::$orderColumn = $this->getOrderField(); $data = ilMailBoxQuery::_getMailBoxListData(); if (!count($data['set']) && $this->getOffset() > 0) { $this->resetOffset(); ilMailBoxQuery::$limit = $this->getLimit(); ilMailBoxQuery::$offset = $this->getOffset(); $data = ilMailBoxQuery::_getMailBoxListData(); } } catch (Exception $e) { $this->setTitleData($txt_folder, 0, 0, $img_folder); if ('mail_search_empty_result' == $e->getMessage()) { $data['set'] = array(); $data['cnt'] = 0; } else { throw $e; } } if (!$this->isDraftFolder() && !$this->isSentFolder()) { $user_ids = array(); foreach ($data['set'] as $mail) { if ($mail['sender_id'] && $mail['sender_id'] != ANONYMOUS_USER_ID) { $user_ids[$mail['sender_id']] = $mail['sender_id']; } } ilMailUserCache::preloadUserObjects($user_ids); } $counter = 0; foreach ($data['set'] as $key => $mail) { ++$counter; if (is_array($this->getSelectedItems()) && in_array($mail['mail_id'], $this->getSelectedItems())) { $mail['checked'] = ' checked="checked" '; } if ($this->isDraftFolder() || $this->isSentFolder()) { $mail['rcp_to'] = $mail['mail_login'] = $this->_parentObject->umail->formatNamesForOutput($mail['rcp_to']); } else { if ($mail['sender_id'] == ANONYMOUS_USER_ID) { $mail['img_sender'] = ilUtil::getImagePath('HeaderIconAvatar.svg'); $mail['from'] = $mail['mail_login'] = $mail['alt_sender'] = ilMail::_getIliasMailerName(); } else { $user = ilMailUserCache::getUserObjectById($mail['sender_id']); if ($user) { $mail['img_sender'] = $user->getPersonalPicturePath('xxsmall'); $mail['from'] = $mail['mail_login'] = $mail['alt_sender'] = $user->getPublicName(); } else { $mail['from'] = $mail['mail_login'] = $mail['import_name'] . ' (' . $this->lng->txt('user_deleted') . ')'; } } } if ($this->isDraftFolder()) { $this->ctrl->setParameterByClass('ilmailformgui', 'mail_id', $mail['mail_id']); $this->ctrl->setParameterByClass('ilmailformgui', 'type', 'draft'); $link_mark_as_read = $this->ctrl->getLinkTargetByClass('ilmailformgui'); $this->ctrl->clearParametersByClass('ilmailformgui'); } else { $this->ctrl->setParameter($this->_parentObject, 'mail_id', $mail['mail_id']); $link_mark_as_read = $this->ctrl->getLinkTarget($this->_parentObject, 'showMail'); $this->ctrl->clearParameters($this->_parentObject); } $css_class = $mail['m_status'] == 'read' ? 'mailread' : 'mailunread'; if ($this->isLuceneSearchEnabled()) { $search_result = array(); foreach ($result->getFields($mail['mail_id']) as $content) { if ('title' == $content[0]) { $mail['msr_subject_link_read'] = $link_mark_as_read; $mail['msr_subject_mailclass'] = $css_class; $mail['msr_subject'] = $content[1]; } else { $search_result[] = $content[1]; } } $mail['msr_data'] = implode('', array_map(function ($value) { return '<p>' . $value . '</p>'; }, $search_result)); if (!$mail['msr_subject']) { $mail['msr_subject_link_read'] = $link_mark_as_read; $mail['msr_subject_mailclass'] = $css_class; $mail['msr_subject'] = htmlspecialchars($mail['m_subject']); } } else { $mail['mail_link_read'] = $link_mark_as_read; $mail['mailclass'] = $css_class; $mail['mail_subject'] = htmlspecialchars($mail['m_subject']); } $mail['mail_date'] = ilDatePresentation::formatDate(new ilDateTime($mail['send_time'], IL_CAL_DATETIME)); $data['set'][$key] = $mail; } $this->setData($data['set']); $this->setMaxCount($data['cnt']); $this->setNumerOfMails($data['cnt']); $this->setTitleData($txt_folder, $data['cnt'], $data['cnt_unread'], $img_folder); return $this; }
/** * _getMailBoxListData * * @access public * @static * @return array Array of mails * */ public static function _getMailBoxListData() { global $ilDB; // initialize array $mails = array('cnt' => 0, 'cnt_unread' => 0, 'set' => array()); // count query $queryCount = 'SELECT COUNT(mail_id) cnt FROM mail ' . 'LEFT JOIN usr_data ON usr_id = sender_id ' . 'WHERE user_id = %s ' . 'AND ((sender_id > 0 AND sender_id IS NOT NULL AND usr_id IS NOT NULL) OR (sender_id = 0 OR sender_id IS NULL)) ' . 'AND folder_id = %s ' . 'UNION ALL ' . 'SELECT COUNT(mail_id) cnt FROM mail ' . 'LEFT JOIN usr_data ON usr_id = sender_id ' . 'WHERE user_id = %s ' . 'AND ((sender_id > 0 AND sender_id IS NOT NULL AND usr_id IS NOT NULL) OR (sender_id = 0 OR sender_id IS NULL)) ' . 'AND folder_id = %s ' . 'AND m_status = %s'; $res = $ilDB->queryf($queryCount, array('integer', 'integer', 'integer', 'integer', 'text'), array(self::$userId, self::$folderId, self::$userId, self::$folderId, 'unread')); $counter = 0; while ($cnt_row = $ilDB->fetchAssoc($res)) { if ($counter == 0) { $mails['cnt'] = $cnt_row['cnt']; } else { if ($counter == 1) { $mails['cnt_unread'] = $cnt_row['cnt']; } else { break; } } ++$counter; } $sortColumn = ''; if (self::$orderColumn == 'rcp_to' && $ilDB->getDBType() == 'oracle') { $sortColumn = ", CAST(rcp_to AS VARCHAR2(4000)) SORTCOL"; } if (self::$orderColumn == 'from') { // Because of the user id of automatically generated mails and ordering issues we have to do some magic $firstname = ' ,(CASE WHEN (usr_id = ' . ANONYMOUS_USER_ID . ') THEN firstname ELSE ' . $ilDB->quote(ilMail::_getIliasMailerName(), 'text') . ' END) fname '; } // item query $query = 'SELECT mail.*' . $sortColumn . ' ' . $firstname . ' FROM mail ' . 'LEFT JOIN usr_data ON usr_id = sender_id ' . 'AND ((sender_id > 0 AND sender_id IS NOT NULL AND usr_id IS NOT NULL) OR (sender_id = 0 OR sender_id IS NULL)) ' . 'WHERE user_id = %s ' . 'AND folder_id = %s'; // order direction $orderDirection = ''; if (in_array(strtolower(self::$orderDirection), array('desc', 'asc'))) { $orderDirection = self::$orderDirection; } else { $orderDirection = 'ASC'; } // order column if (self::$orderColumn == 'rcp_to' && $ilDB->getDBType() == 'oracle') { $query .= ' ORDER BY SORTCOL ' . $orderDirection; } else { if (self::$orderColumn == 'from') { $query .= ' ORDER BY ' . ' fname ' . $orderDirection . ', ' . ' lastname ' . $orderDirection . ', ' . ' login ' . $orderDirection . ', ' . ' import_name ' . $orderDirection; } else { if (strlen(self::$orderColumn)) { if (!in_array(strtolower(self::$orderColumn), array('m_subject', 'send_time', 'rcp_to')) && !$ilDB->tableColumnExists('mail', strtolower(self::$orderColumn))) { // @todo: Performance problem... self::$orderColumn = 'send_time'; } $query .= ' ORDER BY ' . strtolower(self::$orderColumn) . ' ' . $orderDirection; } else { $query .= ' ORDER BY send_time DESC'; } } } $ilDB->setLimit(self::$limit, self::$offset); $res = $ilDB->queryF($query, array('integer', 'integer'), array(self::$userId, self::$folderId)); while ($row = $ilDB->fetchAssoc($res)) { $row['attachments'] = unserialize(stripslashes($row['attachments'])); $row['m_type'] = unserialize(stripslashes($row['m_type'])); $mails['set'][] = $row; } return $mails; }
/** * fetchTableData * @access protected * @return ilMailFolderTableGUI * */ protected function fetchTableData() { global $ilUser; $this->determineOffsetAndOrder(); require_once 'Services/Mail/classes/class.ilMailBoxQuery.php'; ilMailBoxQuery::$folderId = $this->_currentFolderId; ilMailBoxQuery::$userId = $ilUser->getId(); ilMailBoxQuery::$limit = $this->getLimit(); ilMailBoxQuery::$offset = $this->getOffset(); ilMailBoxQuery::$orderDirection = $this->getOrderDirection(); ilMailBoxQuery::$orderColumn = $this->getOrderField(); $data = ilMailBoxQuery::_getMailBoxListData(); if (!count($data['set']) && $this->getOffset() > 0) { $this->resetOffset(); ilMailBoxQuery::$limit = $this->getLimit(); ilMailBoxQuery::$offset = $this->getOffset(); $data = ilMailBoxQuery::_getMailBoxListData(); } if (!$this->isDraftFolder() && !$this->isSentFolder()) { $user_ids = array(); foreach ($data['set'] as $mail) { if ($mail['sender_id'] && $mail['sender_id'] != ANONYMOUS_USER_ID) { $user_ids[$mail['sender_id']] = $mail['sender_id']; } } ilMailUserCache::preloadUserObjects($user_ids); } $counter = 0; foreach ($data['set'] as $key => $mail) { ++$counter; if (is_array($this->getSelectedItems()) && in_array($mail['mail_id'], $this->getSelectedItems())) { $mail['checked'] = ' checked="checked" '; } if ($this->isDraftFolder() || $this->isSentFolder()) { $mail['rcp_to'] = $mail['mail_login'] = $this->_parentObject->umail->formatNamesForOutput($mail['rcp_to']); } else { if ($mail['sender_id'] == ANONYMOUS_USER_ID) { $mail['img_sender'] = ilUtil::getImagePath('HeaderIcon.png'); $mail['from'] = $mail['mail_login'] = $mail['alt_sender'] = ilMail::_getIliasMailerName(); } else { $user = ilMailUserCache::getUserObjectById($mail['sender_id']); if ($user) { $mail['img_sender'] = $user->getPersonalPicturePath('xxsmall'); $mail['from'] = $mail['mail_login'] = $mail['alt_sender'] = $user->getPublicName(); } else { $mail['from'] = $mail['mail_login'] = $mail['import_name'] . ' (' . $this->lng->txt('user_deleted') . ')'; } } } $mail['mailclass'] = $mail['m_status'] == 'read' ? 'mailread' : 'mailunread'; if ($this->isDraftFolder()) { $this->ctrl->setParameterByClass('ilmailformgui', 'mail_id', $mail['mail_id']); $this->ctrl->setParameterByClass('ilmailformgui', 'type', 'draft'); $mail['mail_link_read'] = $this->ctrl->getLinkTargetByClass('ilmailformgui'); $this->ctrl->clearParametersByClass('ilmailformgui'); } else { $this->ctrl->setParameter($this->_parentObject, 'mail_id', $mail['mail_id']); $mail['mail_link_read'] = $this->ctrl->getLinkTarget($this->_parentObject, 'showMail'); $this->ctrl->clearParameters($this->_parentObject); } $mail['mail_subject'] = htmlspecialchars($mail['m_subject']); $mail['mail_date'] = ilDatePresentation::formatDate(new ilDateTime($mail['send_time'], IL_CAL_DATETIME)); $data['set'][$key] = $mail; } $this->setData($data['set']); $this->setMaxCount($data['cnt']); $this->setNumerOfMails($data['cnt']); // table title $txt_folder = ''; $img_folder = ''; if ($this->_folderNode['m_type'] == 'user_folder') { $txt_folder = $this->_folderNode['title']; $img_folder = 'icon_user_folder.png'; } else { $txt_folder = $this->lng->txt('mail_' . $this->_folderNode['title']); $img_folder = 'icon' . substr($this->_folderNode['title'], 1) . '.png'; } $this->setTitleData($txt_folder, $data['cnt'], $data['cnt_unread'], $img_folder); return $this; }