Class for global mail information (e.g. More...

Collaboration diagram for ilMailGlobalServices:

Static Public Member Functions
static	getMailObjectRefId ()

static	getNewMailsData (ilObjUser $user, int $leftInterval=0)

Data Fields
final const	CACHE_TYPE_REF_ID = 0

final const	CACHE_TYPE_NEW_MAILS = 1

Static Protected Attributes
static array	$global_mail_services_cache = []

Detailed Description

Class for global mail information (e.g.

in main menu). This class should only contain methods for fetching data which is necessary in global parts of ILIAS, e.g. the main menu. We should keep this class as small as possible. Maybe we duplicate some code which already exists in class ilMail, but we need an efficient class.

Author: Michael Jansen mjans.nosp@m.en@d.nosp@m.ataba.nosp@m.y.de

Definition at line 29 of file class.ilMailGlobalServices.php.

Member Function Documentation

◆ getMailObjectRefId()

static ilMailGlobalServices::getMailObjectRefId ( )

static

Definition at line 36 of file class.ilMailGlobalServices.php.

References $DIC, $res, ILIAS\Repository\int(), MAIL_SETTINGS_ID, and SYSTEM_FOLDER_ID.

Referenced by ilBuddySystemRelationsTableGUI\__construct(), ilMailSearchObjectGUI\cancel(), ilMailUserActionProvider\checkUserMailAccess(), ilPersonalSettingsGUI\executeCommand(), ilPublicUserProfileGUI\getEmbeddable(), ilAccessibilitySupportContactsGUI\getFooterLink(), ilMailAddressTypeHelperImpl\getGlobalMailSystemId(), ILIAS\Mail\Provider\MailMainBarProvider\getStaticSubItems(), ilObjCourseGUI\infoScreen(), ilPersonalSettingsGUI\initSubTabs(), ilMailSearchObjectGUI\mailObjects(), ilContactGUI\mailToUsers(), and ilMail\readMailObjectReferenceId().

                                                : int
     {
         global $DIC;
 
         if (isset(self::$global_mail_services_cache[self::CACHE_TYPE_REF_ID]) &&
             null !== self::$global_mail_services_cache[self::CACHE_TYPE_REF_ID]) {
             return (int) self::$global_mail_services_cache[self::CACHE_TYPE_REF_ID];
         }
 
         // mail settings id is set by a constant in ilias.ini.
         // Keep the select for some time until everyone has updated his ilias.ini
         if (!MAIL_SETTINGS_ID) {
             $res = $DIC->database()->queryF(
                 '
                                 SELECT object_reference.ref_id FROM object_reference, tree, object_data
                                 WHERE tree.parent = %s
                                 AND object_data.type = %s
                                 AND object_reference.ref_id = tree.child
                                 AND object_reference.obj_id = object_data.obj_id',
                 ['integer', 'text'],
                 [SYSTEM_FOLDER_ID, 'mail']
             );
 
             while ($row = $DIC->database()->fetchAssoc($res)) {
                 self::$global_mail_services_cache[self::CACHE_TYPE_REF_ID] = (int) $row['ref_id'];
             }
         } else {
             self::$global_mail_services_cache[self::CACHE_TYPE_REF_ID] = MAIL_SETTINGS_ID;
         }
 
         return (int) self::$global_mail_services_cache[self::CACHE_TYPE_REF_ID];
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getNewMailsData()

static ilMailGlobalServices::getNewMailsData	(	ilObjUser	$user,
		int	$leftInterval = `0`
	)

static

Returns: array{count: int, max_time: string}

Definition at line 72 of file class.ilMailGlobalServices.php.

References $DIC, $res, ilObject\getId(), ILIAS\Repository\int(), and ilObjUser\isAnonymous().

Referenced by ilSoapUserAdministration\hasNewMail().

                                                                                   : array
     {
         global $DIC;
 
         if ($user->isAnonymous() || 0 === $user->getId()) {
             return [
                 'count' => 0,
                 'max_time' => (new DateTimeImmutable('@' . time()))->format('Y-m-d H:i:s')
             ];
         }
 
         $cacheKey = implode('_', [self::CACHE_TYPE_NEW_MAILS, $user->getId(), $leftInterval]);
 
         if (
             isset(self::$global_mail_services_cache[$cacheKey]) &&
             null !== self::$global_mail_services_cache[$cacheKey]) {
             return self::$global_mail_services_cache[$cacheKey];
         }
 
         $query = '
             SELECT COUNT(mail_id) cnt, MAX(send_time) send_time
             FROM mail
             WHERE folder_id = %s AND user_id = %s AND m_status = %s
         ';
         if ($leftInterval > 0) {
             $query .= ' AND send_time > '
                 . $DIC->database()->quote(date('Y-m-d H:i:s', $leftInterval), 'timestamp');
         }
 
         $res = $DIC->database()->queryF(
             $query,
             ['integer', 'integer', 'text'],
             [0, $user->getId(), 'unread']
         );
         $row = $DIC->database()->fetchAssoc($res);
 
         $query = '
             SELECT COUNT(mail_id) cnt, MAX(m.send_time) send_time
             FROM mail m
             INNER JOIN mail_obj_data mo
                 ON mo.user_id = m.user_id
                 AND mo.obj_id = m.folder_id
                 AND mo.m_type = %s
             WHERE m.user_id = %s
                         AND m.m_status = %s';
         if ($leftInterval > 0) {
             $query .= ' AND m.send_time > '
                 . $DIC->database()->quote(date('Y-m-d H:i:s', $leftInterval), 'timestamp');
         }
 
         $res = $DIC->database()->queryF(
             $query,
             ['text', 'integer', 'text'],
             ['inbox', $user->getId(), 'unread']
         );
         $row2 = $DIC->database()->fetchAssoc($res);
 
         self::$global_mail_services_cache[$cacheKey] = [
             'count' => ((int) $row['cnt'] + (int) $row2['cnt']),
             'max_time' => max(
                 (string) $row['send_time'],
                 (string) $row2['send_time']
             ),
         ];
 
         return self::$global_mail_services_cache[$cacheKey];
     }