class.ilMailGlobalServices.php

Go to the documentation of this file.

<?php
/* Copyright (c) 1998-2011 ILIAS open source, Extended GPL, see docs/LICENSE */
 
class ilMailGlobalServices
{
        const CACHE_TYPE_REF_ID = 0;
        
        const CACHE_TYPE_NEW_MAILS = 1;
        
        protected static $global_mail_services_cache = array();
        
        public static function getMailObjectRefId()
        {
                global $ilDB;
                
                if(isset(self::$global_mail_services_cache[self::CACHE_TYPE_REF_ID]) &&
                   null !== self::$global_mail_services_cache[self::CACHE_TYPE_REF_ID])
                {
                        return 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 = $ilDB->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 = $ilDB->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 self::$global_mail_services_cache[self::CACHE_TYPE_REF_ID];
        }
 
        public static function getNumberOfNewMailsByUserId($usr_id)
        {
                global $ilDB;
 
                if(!$usr_id)
                {
                        return 0;
                }
                
                if(isset(self::$global_mail_services_cache[self::CACHE_TYPE_NEW_MAILS][$usr_id]) &&
                   null !== self::$global_mail_services_cache[self::CACHE_TYPE_NEW_MAILS][$usr_id])
                {
                        return self::$global_mail_services_cache[self::CACHE_TYPE_NEW_MAILS][$usr_id];
                }
 
                // Read system mails
                $res = $ilDB->queryf('
                        SELECT COUNT(mail_id) cnt FROM mail 
                        WHERE folder_id = %s 
                        AND user_id = %s
                        AND m_status = %s',
                        array('integer', 'integer', 'text'),
                        array('0', $usr_id, 'unread'));
                
                $row = $ilDB->fetchAssoc($res);
                                        
                $res = $ilDB->queryf('
                        SELECT COUNT(mail_id) cnt FROM mail m,mail_obj_data mo 
                        WHERE m.user_id = mo.user_id 
                        AND m.folder_id = mo.obj_id 
                        AND mo.m_type = %s
                        AND m.user_id = %s
                        AND m.m_status = %s',
                        array('text', 'integer', 'text'),
                        array('inbox', $usr_id, 'unread'));
                        
                
                $row2 = $ilDB->fetchAssoc($res);
                
                self::$global_mail_services_cache[self::CACHE_TYPE_NEW_MAILS][$usr_id] = $row['cnt'] + $row2['cnt'];
                
                return self::$global_mail_services_cache[self::CACHE_TYPE_NEW_MAILS][$usr_id];
        }
}