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.

public

Returns: integer The reference id of the mail object

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

References $DIC, and $res.

Referenced by ilBuddySystemRelationsTableGUI\__construct(), ilMailUserActionProvider\checkUserMailAccess(), ilPersonalSettingsGUI\executeCommand(), ilMailAddressTypeHelperImpl\getGlobalMailSystemId(), ILIAS\Mail\Provider\MailNotificationProvider\getNotifications(), ILIAS\Mail\Provider\MailMainBarProvider\getStaticSubItems(), 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',
                 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];
     }

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.

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.

References $DIC, $query, and $res.

Referenced by ILIAS\Mail\Provider\MailNotificationProvider\getNotifications(), and ilSoapUserAdministration\hasNewMail().

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