class.ilMailCronOrphanedMailsDeletionCollector.php

Go to the documentation of this file.

<?php
/* Copyright (c) 1998-2015 ILIAS open source, Extended GPL, see docs/LICENSE */
 
class ilMailCronOrphanedMailsDeletionCollector
{
        protected $mail_ids = array();
 
        public function __construct()
        {
                $this->collect();
        }
 
        public function collect()
        {
                global $ilDB, $ilSetting;
 
                $mail_only_inbox_trash = (int)$ilSetting->get('mail_only_inbox_trash');
                $last_cron_start_ts = (int)$ilSetting->get('last_cronjob_start_ts');
                
                $mail_notify_orphaned = (int)$ilSetting->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 = $ilDB->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 = $ilDB->queryF("
                                        SELECT * FROM mail_cron_orphaned 
                                        WHERE ts_do_delete <= %s",
                                                        array('integer'),
                                                        array($now));
                                }
                                
                                while($row = $ilDB->fetchAssoc($res))
                                {
                                        $this->addMailIdToDelete($row['mail_id']);
                                }
                        }
                }
                else
                {
                        // mails sollen direkt ohne vorheriger notification gelöscht werden.
                        $mail_threshold = (int)$ilSetting->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)$ilSetting->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 = $ilDB->queryF($mails_query, $types, $data);
                        
                        while($row = $ilDB->fetchAssoc($res))
                        {
                                $this->addMailIdToDelete($row['mail_id']);
                        }
                }
        }
 
        public function addMailIdToDelete($mail_id)
        {
                $this->mail_ids[] = (int)$mail_id;
        }
 
        public function getMailIdsToDelete()
        {
                return $this->mail_ids;
        }        
}