ilMailCronOrphanedMailsDeletionCollector Class Reference

ilMailCronOrphanedMailsDeletionCollector More...

Collaboration diagram for ilMailCronOrphanedMailsDeletionCollector:

Public Member Functions
	__construct (ilMailCronOrphanedMails $job)
	collect ()
	addMailIdToDelete ($mail_id)
	getMailIdsToDelete ()

Protected Attributes
	$db
	$settings
	$mail_ids = array()

Private Attributes
const	PING_THRESHOLD = 500
	$job

Detailed Description

ilMailCronOrphanedMailsDeletionCollector

Author

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

Definition at line 8 of file class.ilMailCronOrphanedMailsDeletionCollector.php.

Constructor & Destructor Documentation

__construct()

ilMailCronOrphanedMailsDeletionCollector::__construct

(

ilMailCronOrphanedMails

$job

)

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

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

    {
        global $DIC;

        $this->settings = $DIC->settings();
        $this->db = $DIC->database();

        $this->job = $job;

        $this->collect();
    }

Here is the call graph for this function:

Member Function Documentation

addMailIdToDelete()

ilMailCronOrphanedMailsDeletionCollector::addMailIdToDelete

(

$mail_id

)

Parameters

int

$mail_id

Definition at line 118 of file class.ilMailCronOrphanedMailsDeletionCollector.php.

Referenced by collect().

    {
        $this->mail_ids[] = (int) $mail_id;
    }

Here is the caller graph for this function:

collect()

ilMailCronOrphanedMailsDeletionCollector::collect

(

)

Definition at line 43 of file class.ilMailCronOrphanedMailsDeletionCollector.php.

References $data, $i, $res, addMailIdToDelete(), and settings().

Referenced by __construct().

    {
        $mail_only_inbox_trash = (int) $this->settings->get('mail_only_inbox_trash');
        $last_cron_start_ts = (int) $this->settings->get('last_cronjob_start_ts', time());
        $mail_notify_orphaned = (int) $this->settings->get('mail_notify_orphaned');

        $now = time();

        if ($mail_notify_orphaned > 0) {
            if ($last_cron_start_ts != null) {
                if ($mail_only_inbox_trash) {
                    // überprüfen ob die mail in einen anderen Ordner verschoben wurde
                    // selektiere die, die tatsächlich gelöscht werden sollen
                    $res = $this->db->queryF(
                        "
                                                SELECT mail_id FROM mail_cron_orphaned 
                        LEFT JOIN mail_obj_data mdata ON mdata.obj_id = folder_id
                                                WHERE ts_do_delete <= %s
                                                AND ((mdata.m_type = %s OR mdata.m_type = %s) OR mdata.obj_id IS NULL)",
                        array('integer', 'text', 'text'),
                        array($now, 'inbox', 'trash')
                    );
                } else {
                    // selektiere alle zu löschenden mails unabhängig vom ordner..
                    $res = $this->db->queryF(
                        "
                                        SELECT mail_id FROM mail_cron_orphaned 
                                        WHERE ts_do_delete <= %s",
                        array('integer'),
                        array($now)
                    );
                }
                
                while ($row = $this->db->fetchAssoc($res)) {
                    $this->addMailIdToDelete($row['mail_id']);
                }
            }
        } else {
            // mails sollen direkt ohne vorheriger notification gelöscht werden.
            $mail_threshold = (int) $this->settings->get('mail_threshold');
            $ts_notify = strtotime("- " . $mail_threshold . " days");
            $ts_for_deletion = date('Y-m-d', $ts_notify) . ' 23:59:59';

            $types = array('timestamp');
            $data = array($ts_for_deletion);

            $mails_query = "
                                SELECT          mail_id
                                FROM            mail m
                                INNER JOIN      mail_obj_data mdata ON obj_id = folder_id
                                WHERE           send_time <= %s";

            if ((int) $this->settings->get('mail_only_inbox_trash') > 0) {
                $mails_query .= " AND (mdata.m_type = %s OR mdata.m_type = %s)";
                $types = array('timestamp', 'text', 'text');
                $data = array($ts_for_deletion, 'inbox', 'trash');
            }

            $i = 0;
            $res = $this->db->queryF($mails_query, $types, $data);
            while ($row = $this->db->fetchAssoc($res)) {
                if ($i > 0 && $i % self::PING_THRESHOLD) {
                    $this->job->ping();
                }

                $this->addMailIdToDelete($row['mail_id']);

                ++$i;
            }
        }
    }

Here is the call graph for this function:

Here is the caller graph for this function:

getMailIdsToDelete()

ilMailCronOrphanedMailsDeletionCollector::getMailIdsToDelete

(

)

Returns

array

Definition at line 126 of file class.ilMailCronOrphanedMailsDeletionCollector.php.

References $mail_ids.

    {
        return $this->mail_ids;
    }

Field Documentation

$db

ilMailCronOrphanedMailsDeletionCollector::$db

protected

Definition at line 16 of file class.ilMailCronOrphanedMailsDeletionCollector.php.

$job

ilMailCronOrphanedMailsDeletionCollector::$job

private

Definition at line 12 of file class.ilMailCronOrphanedMailsDeletionCollector.php.

Referenced by __construct().

$mail_ids

ilMailCronOrphanedMailsDeletionCollector::$mail_ids = array()

protected

Definition at line 26 of file class.ilMailCronOrphanedMailsDeletionCollector.php.

Referenced by getMailIdsToDelete().

$settings

ilMailCronOrphanedMailsDeletionCollector::$settings

protected

Definition at line 21 of file class.ilMailCronOrphanedMailsDeletionCollector.php.

PING_THRESHOLD

const ilMailCronOrphanedMailsDeletionCollector::PING_THRESHOLD = 500

private

Definition at line 10 of file class.ilMailCronOrphanedMailsDeletionCollector.php.

---

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

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