コード例 #1
0
 /**
  * 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;
 }
コード例 #2
0
    /**
     * _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;
    }
コード例 #3
0
 /**
  * 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;
 }