ilMailCronOrphanedMailsDeletionCollector Class Reference

ilMailCronOrphanedMailsDeletionCollector More...

Collaboration diagram for ilMailCronOrphanedMailsDeletionCollector:

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

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

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

(

)

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

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

    {
        global $DIC;

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

        $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 109 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 41 of file class.ilMailCronOrphanedMailsDeletionCollector.php.

References $data, $res, $row, addMailIdToDelete(), array, date, settings(), and time.

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 * FROM mail_cron_orphaned 
                                                INNER JOIN      mail_obj_data mdata ON obj_id = folder_id
                                                WHERE ts_do_delete <= %s
                                                AND (mdata.m_type = %s OR mdata.m_type = %s)",
                        array('integer', 'text', 'text'),
                        array($now, 'inbox', 'trash')
                    );
                } else {
                    // selektiere alle zu löschenden mails unabhängig vom ordner..
                    $res = $this->db->queryF(
                        "
                                        SELECT * 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, m.user_id, folder_id, send_time, m_subject, mdata.title
                                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');
            }

            $res = $this->db->queryF($mails_query, $types, $data);
            while ($row = $this->db->fetchAssoc($res)) {
                $this->addMailIdToDelete($row['mail_id']);
            }
        }
    }

Here is the call graph for this function:

Here is the caller graph for this function:

getMailIdsToDelete()

ilMailCronOrphanedMailsDeletionCollector::getMailIdsToDelete

(

)

Returns

array

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

References $mail_ids.

    {
        return $this->mail_ids;
    }

Field Documentation

$db

ilMailCronOrphanedMailsDeletionCollector::$db

protected

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

$mail_ids

ilMailCronOrphanedMailsDeletionCollector::$mail_ids = array()

protected

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

Referenced by getMailIdsToDelete().

$settings

ilMailCronOrphanedMailsDeletionCollector::$settings

protected

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

---

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

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