Exemplo n.º 1
0
 /**
  * @static
  * @param array $usr_ids
  */
 public static function preloadUserObjects(array $usr_ids)
 {
     /**
      * @var $ilDB ilDB
      */
     global $ilDB;
     $usr_ids_to_request = array_diff($usr_ids, self::$requested_usr_ids);
     self::$requested_usr_ids = array_merge(self::$requested_usr_ids, $usr_ids_to_request);
     self::$requested_usr_ids_key_map = array_flip(self::$requested_usr_ids);
     if ($usr_ids_to_request) {
         $in = $ilDB->in('ud.usr_id', $usr_ids_to_request, false, 'integer');
         $query = "\n\t\t\t\tSELECT ud.usr_id, login, firstname, lastname, title, gender, pprof.value public_profile,pup.value public_upload, pupgen.value public_gender\n\t\t\t\tFROM usr_data ud\n\t\t\t\tLEFT JOIN usr_pref pprof ON pprof.usr_id = ud.usr_id AND pprof.keyword = %s\n\t\t\t\tLEFT JOIN usr_pref pupgen ON pupgen.usr_id = ud.usr_id AND pupgen.keyword = %s\n\t\t\t\tLEFT JOIN usr_pref pup ON pup.usr_id = ud.usr_id AND pup.keyword = %s\n\t\t\t\tWHERE {$in}\n\t\t\t";
         $res = $ilDB->queryF($query, array('text', 'text', 'text'), array('public_profile', 'public_gender', 'public_upload'));
         while ($row = $ilDB->fetchAssoc($res)) {
             $user = new ilObjUser();
             $user->setId($row['usr_id']);
             $user->setLogin($row['login']);
             $user->setGender($row['gender']);
             $user->setTitle($row['title']);
             $user->setFirstname($row['firstname']);
             $user->setLastname($row['lastname']);
             $user->setPref('public_profile', $row['public_profile']);
             $user->setPref('public_upload', $row['public_upload']);
             $user->setPref('public_gender', $row['public_gender']);
             self::$user_instances[$row['usr_id']] = $user;
         }
     }
 }
 /**
  * @param array $data
  */
 protected function preloadData(array $data)
 {
     $usr_ids = array();
     foreach ($data as $mail) {
         if ($mail['sender_id'] && $mail['sender_id'] != ANONYMOUS_USER_ID) {
             $usr_ids[$mail['sender_id']] = $mail['sender_id'];
         }
     }
     ilMailUserCache::preloadUserObjects($usr_ids);
 }
 /**
  * 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;
 }
 /**
  * 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;
 }