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

Collaboration diagram for ilMailGlobalServices:

Static Public Member Functions
static	getMailObjectRefId ()
	Determines the reference id of the mail object and stores this information in a local cache variable. More...

static	getNewMailsData (int $usr_id, int $leftInterval=0)
	Determines the number of new mails for the passed user id and stores this information in a local cache variable. More...

Data Fields
const	CACHE_TYPE_REF_ID = 0

const	CACHE_TYPE_NEW_MAILS = 1

Static Protected Attributes
static	$global_mail_services_cache = array()

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

Member Function Documentation

◆ getMailObjectRefId()

static ilMailGlobalServices::getMailObjectRefId ( )

static

Determines the reference id of the mail object and stores this information in a local cache variable.

@access public

Returns: integer The reference id of the mail object

Definition at line 52 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',
                array('integer', 'text'),
                array(SYSTEM_FOLDER_ID, 'mail')
            );
 
            while ($row = $DIC->database()->fetchAssoc($res)) {
                self::$global_mail_services_cache[self::CACHE_TYPE_REF_ID] = $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, MAIL_SETTINGS_ID, and SYSTEM_FOLDER_ID.

Referenced by ilBuddySystemRelationsTableGUI\__construct(), ilMailUserActionProvider\checkUserMailAccess(), ilPersonalSettingsGUI\executeCommand(), ilPublicUserProfileGUI\getEmbeddable(), ilAccessibilitySupportContactsGUI\getFooterLink(), ilMailAddressTypeHelperImpl\getGlobalMailSystemId(), ILIAS\Mail\Provider\MailNotificationProvider\getNotifications(), ILIAS\Mail\Provider\MailMainBarProvider\getStaticSubItems(), ilMailSearchCoursesGUI\mailCourses(), ilMailSearchGroupsGUI\mailGroups(), ilContactGUI\mailToUsers(), and ilMail\readMailObjectReferenceId().

Here is the caller graph for this function:

◆ getNewMailsData()

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

static

Determines the number of new mails for the passed user id and stores this information in a local cache variable.

@access public

Parameters

	$usr_id
int	$leftInterval

Returns: integer The number on unread mails (system messages + inbox mails) for the passed user id

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

                                                                               : array
    {
        global $DIC;
 
        if (!$usr_id) {
            return 0;
        }
 
        $cacheKey = implode('_', [self::CACHE_TYPE_NEW_MAILS, $usr_id, $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, $usr_id, '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', $usr_id, 'unread']
        );
        $row2 = $DIC->database()->fetchAssoc($res);
 
        self::$global_mail_services_cache[$cacheKey] = [
            'count' => (int) ($row['cnt'] + $row2['cnt']),
            'max_time' => max(
                (string) $row['send_time'],
                (string) $row2['send_time']
            ),
        ];
 
        return self::$global_mail_services_cache[$cacheKey];
    }