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
const	CACHE_TYPE_REF_ID = 0

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 35 of file class.ilMailGlobalServices.php.

                                               : 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];
    }

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

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

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

Parameters

ilObjUser	$user
int	$leftInterval

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

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

                                                                                  : 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];
    }