ilMailCronOrphanedMailsNotificationCollector Class Reference

ilMailCronOrphanedMailsNotificationCollector More...

Collaboration diagram for ilMailCronOrphanedMailsNotificationCollector:

Public Member Functions
	__construct (ilMailCronOrphanedMails $job)
	collect ()
	addCollectionObject (ilMailCronOrphanedMailsNotificationCollectionObj $collection_obj)
	getCollection ()

Protected Attributes
	$collection = array()
	$db
	$setting

Private Member Functions
	existsCollectionObjForUserId ($user_id)

Private Attributes
const	PING_THRESHOLD = 500
	$job

Detailed Description

ilMailCronOrphanedMailsNotificationCollector

Author

Nadia Matuschek nmatu.nosp@m.sche.nosp@m.k@dat.nosp@m.abay.nosp@m..de

Definition at line 11 of file class.ilMailCronOrphanedMailsNotificationCollector.php.

Constructor & Destructor Documentation

__construct()

ilMailCronOrphanedMailsNotificationCollector::__construct

(

ilMailCronOrphanedMails

$job

)

Definition at line 30 of file class.ilMailCronOrphanedMailsNotificationCollector.php.

    {
        global $DIC;
 
        $this->db = $DIC->database();
        $this->setting = $DIC->settings();
 
        $this->job = $job;
 
        $this->collect();
    }

References $DIC, $job, and collect().

Here is the call graph for this function:

Member Function Documentation

addCollectionObject()

ilMailCronOrphanedMailsNotificationCollector::addCollectionObject

(

ilMailCronOrphanedMailsNotificationCollectionObj

$collection_obj

)

Parameters

ilMailCronOrphanedMailsNotificationCollectionObj

$collection_obj

Definition at line 114 of file class.ilMailCronOrphanedMailsNotificationCollector.php.

    {
        $this->collection[$collection_obj->getUserId()] = $collection_obj;
    }

References ilMailCronOrphanedMailsNotificationCollectionObj\getUserId().

Referenced by collect().

Here is the call graph for this function:

Here is the caller graph for this function:

collect()

ilMailCronOrphanedMailsNotificationCollector::collect

(

)

Definition at line 45 of file class.ilMailCronOrphanedMailsNotificationCollector.php.

    {
        $mail_notify_orphaned = (int) $this->setting->get('mail_notify_orphaned');
        $mail_threshold = (int) $this->setting->get('mail_threshold');
        
        if ($mail_threshold > $mail_notify_orphaned) {
            $notify_days_before = $mail_threshold - $mail_notify_orphaned;
        } else {
            $notify_days_before = 1;
        }
 
        $ts_notify = strtotime("- " . $notify_days_before . " days");
        $ts_for_notification = date('Y-m-d', $ts_notify) . ' 23:59:59';
 
        $types = array('timestamp');
        $data = array($ts_for_notification);
 
        $notification_query = "
            SELECT              m.mail_id, m.user_id, m.folder_id, m.send_time, m.m_subject, mdata.title
            FROM                mail m
            LEFT JOIN   mail_obj_data mdata ON mdata.obj_id = m.folder_id
            LEFT JOIN   mail_cron_orphaned mco ON mco.mail_id = m.mail_id
            WHERE               mco.mail_id IS NULL AND m.send_time <= %s
        ";
 
        if ((int) $this->setting->get('mail_only_inbox_trash') > 0) {
            $notification_query .= " AND ((mdata.m_type = %s OR mdata.m_type = %s) OR mdata.obj_id IS NULL)";
            $types = array('timestamp', 'text', 'text');
            $data = array($ts_for_notification, 'inbox', 'trash');
        }
 
        $notification_query .= " ORDER BY m.user_id, m.folder_id, m.mail_id";
 
        $collection_obj = null;
 
        $res = $this->db->queryF($notification_query, $types, $data);
        $i = 0;
        while ($row = $this->db->fetchAssoc($res)) {
            if ($i > 0 && $i % self::PING_THRESHOLD === 0) {
                $this->job->ping();
            }
 
            if ($collection_obj !== null && !$this->existsCollectionObjForUserId($row['user_id'])) {
                // The user changed, so we'll have to set the collection to NULL after adding it to the queue
                $collection_obj = null;
            }
 
            if ($collection_obj === null) {
                // For the first user or if the user changed, we'll create a new collection object
                $collection_obj = new ilMailCronOrphanedMailsNotificationCollectionObj($row['user_id']);
                $this->addCollectionObject($collection_obj);
            }
 
            $folder_obj = $collection_obj->getFolderObjectById($row['folder_id']);
            if (!$folder_obj) {
                $folder_obj = new ilMailCronOrphanedMailsFolderObject($row['folder_id']);
                $folder_obj->setFolderTitle($row['title']);
                $collection_obj->addFolderObject($folder_obj);
            }
 
            $orphaned_mail_obj = new ilMailCronOrphanedMailsFolderMailObject($row['mail_id'], $row['m_subject']);
            $folder_obj->addMailObject($orphaned_mail_obj);
            ++$i;
        }
    }

References $data, $i, $res, addCollectionObject(), and existsCollectionObjForUserId().

Referenced by __construct().

Here is the call graph for this function:

Here is the caller graph for this function:

existsCollectionObjForUserId()

ilMailCronOrphanedMailsNotificationCollector::existsCollectionObjForUserId (   $user_id )

private

Parameters

$user_id

Returns

bool

Definition at line 123 of file class.ilMailCronOrphanedMailsNotificationCollector.php.

    {
        if (isset($this->collection[$user_id])) {
            return true;
        }
 
        return false;
    }

Referenced by collect().

Here is the caller graph for this function:

getCollection()

ilMailCronOrphanedMailsNotificationCollector::getCollection

(

)

Returns

ilMailCronOrphanedMailsNotificationCollectionObj[]

Definition at line 135 of file class.ilMailCronOrphanedMailsNotificationCollector.php.

    {
        return $this->collection;
    }

References $collection.

Field Documentation

$collection

ilMailCronOrphanedMailsNotificationCollector::$collection = array()

protected

Definition at line 17 of file class.ilMailCronOrphanedMailsNotificationCollector.php.

Referenced by getCollection().

$db

ilMailCronOrphanedMailsNotificationCollector::$db

protected

Definition at line 22 of file class.ilMailCronOrphanedMailsNotificationCollector.php.

$job

ilMailCronOrphanedMailsNotificationCollector::$job

private

Definition at line 28 of file class.ilMailCronOrphanedMailsNotificationCollector.php.

Referenced by __construct().

$setting

ilMailCronOrphanedMailsNotificationCollector::$setting

protected

Definition at line 27 of file class.ilMailCronOrphanedMailsNotificationCollector.php.

PING_THRESHOLD

const ilMailCronOrphanedMailsNotificationCollector::PING_THRESHOLD = 500

private

Definition at line 13 of file class.ilMailCronOrphanedMailsNotificationCollector.php.

---

The documentation for this class was generated from the following file:

• Services/Mail/classes/class.ilMailCronOrphanedMailsNotificationCollector.php