class.ilMailbox.php

Go to the documentation of this file.

<?php
/* Copyright (c) 1998-2012 ILIAS open source, Extended GPL, see docs/LICENSE */
 
require_once("Services/Mail/classes/class.ilMail.php");
 
class ilMailbox
{
        var $ilias;
 
        var $lng;
 
        var $mtree;
 
        var $user_id;
 
        var $actions;
 
        var $default_folder;
 
        var $table_mail_obj_data;
 
        var $table_tree;
 
        public function __construct($a_user_id = 0)
        {
                global $ilias,$lng;
 
                $this->ilias = $ilias;
                $this->lng = $lng;
                $this->user_id = $a_user_id;
 
                $this->table_mail_obj_data = 'mail_obj_data';
                $this->table_tree = 'mail_tree';
 
                if ($a_user_id)
                {
                        $this->mtree = new ilTree($this->user_id);
                        $this->mtree->setTableNames($this->table_tree,$this->table_mail_obj_data);
                }
 
                // i added this, becaus if i create a new user automatically during
                // CAS authentication, we have no $lng variable (alex, 16.6.2006)
                // (alternative: make createDefaultFolder call static in ilObjUser->saveAsNew())
                if (is_object($this->lng))
                {
                        $this->lng->loadLanguageModule("mail");
 
                        $this->actions = array(
                                "moveMails"        => $this->lng->txt("mail_move_to"),
                                "markMailsRead"   => $this->lng->txt("mail_mark_read"),
                                "markMailsUnread" => $this->lng->txt("mail_mark_unread"),
                                "deleteMails"      => $this->lng->txt("delete"));
                }
                
                // array contains basic folders and there lng translation for every new user
                $this->default_folder = array(
                        "b_inbox"     => "inbox",
                        "c_trash"     => "trash",
                        "d_drafts"    => "drafts",
                        "e_sent"      => "sent",
                        "z_local"     => "local");
 
        }
        public function getInboxFolder()
        {
                global $ilDB;
 
                $res = $ilDB->queryF('
                        SELECT obj_id FROM '.$this->table_mail_obj_data.'
                        WHERE user_id = %s
                        AND m_type = %s',
                        array('integer', 'text'),
                        array($this->user_id, 'inbox')
                );
 
                $row = $ilDB->fetchAssoc($res);
 
                return $row['obj_id'];
        }
 
        public function getDraftsFolder()
        {
                global $ilDB;
 
                $res = $ilDB->queryF('
                        SELECT obj_id FROM '.$this->table_mail_obj_data.'
                        WHERE user_id = %s
                        AND m_type = %s',
                        array('integer', 'text'),
                        array($this->user_id, 'drafts')
                );
 
                $row = $ilDB->fetchAssoc($res);
 
                return $row['obj_id'];
        }
 
        public function getTrashFolder()
        {
                global $ilDB;
 
                $res = $ilDB->queryf('
                        SELECT obj_id FROM '.$this->table_mail_obj_data.'
                        WHERE user_id = %s
                        AND m_type = %s',
                        array('integer', 'text'),
                        array($this->user_id, 'trash')
                );
 
                $row = $ilDB->fetchAssoc($res);
 
                return $row['obj_id'];
        }
 
        public function getSentFolder()
        {
                global $ilDB;
 
                $res = $ilDB->queryf('
                        SELECT obj_id FROM '.$this->table_mail_obj_data.'
                        WHERE user_id = %s
                        AND m_type = %s',
                        array('integer', 'text'),
                        array($this->user_id, 'sent')
                );
 
                $row = $ilDB->fetchAssoc($res);
 
                return $row['obj_id'];
        }
 
        function getRootFolderId()
        {
                return $this->mtree->getRootID($this->user_id);
        }
 
        public function getActions($a_mobj_id)
        {
                if ($a_mobj_id)
                {
                        $folder_data = $this->getFolderData($a_mobj_id);
 
                        if ($folder_data["type"] == "user_folder" or $folder_data["type"] == "local")
                        {
                                #return array_merge($this->actions,array("add" => $this->lng->txt("mail_add_subfolder")));
                                return $this->actions;
                        }
                }
 
                return $this->actions;
        }
 
        public function createDefaultFolder()
        {
                global $ilDB;
 
                $root_id = $ilDB->nextId($this->table_mail_obj_data);
                $ilDB->manipulateF('
                        INSERT INTO '. $this->table_mail_obj_data .' 
                        (       obj_id,
                                user_id,
                                title,
                                m_type
                        )
                        VALUES(%s, %s, %s, %s)',
                        array('integer','integer', 'text', 'text'),
                        array($root_id, $this->user_id, 'a_root', 'root')
                );
                $this->mtree->addTree($this->user_id, $root_id);
 
                foreach($this->default_folder as $key => $folder)
                {
                        $last_id = $ilDB->nextId($this->table_mail_obj_data);
                        $ilDB->manipulateF('
                                INSERT INTO '. $this->table_mail_obj_data .' 
                                (       obj_id,
                                        user_id,
                                        title,
                                        m_type
                                )
                                VALUES(%s, %s, %s, %s)',
                                array('integer','integer', 'text', 'text'),
                                array($last_id, $this->user_id, $key, $folder)
                        );
                        $this->mtree->insertNode($last_id, $root_id);
                }
        }
 
        public function addFolder($a_parent_id, $a_folder_name)
        {
                global $ilDB;
 
                if($this->folderNameExists($a_folder_name))
                {
                        return 0;
                }
 
                $next_id = $ilDB->nextId($this->table_mail_obj_data);
                $ilDB->manipulateF('
                        INSERT INTO '. $this->table_mail_obj_data .'
                        (       obj_id,
                                user_id,
                                title,
                                m_type 
                         )
                         VALUES(%s,%s,%s,%s)',
                        array('integer','integer', 'text', 'text'),
                        array($next_id, $this->user_id, $a_folder_name, 'user_folder')
                );
                $this->mtree->insertNode($next_id, $a_parent_id);
 
                return $next_id;
        }
 
        public function renameFolder($a_obj_id, $a_new_folder_name)
        {
                global $ilDB;
 
                if($this->folderNameExists($a_new_folder_name))
                {
                        return false;
                }
 
                $ilDB->manipulateF('
                        UPDATE '. $this->table_mail_obj_data .'
                        SET title = %s
                        WHERE obj_id = %s AND user_id = %s',
                        array('text', 'integer', 'integer'),
                        array($a_new_folder_name, $a_obj_id, $this->user_id)
                );
 
                return true;
        }
 
        protected function folderNameExists($a_folder_name)
        {
                global $ilDB;
 
                $res = $ilDB->queryF('
                        SELECT obj_id FROM '. $this->table_mail_obj_data .'
                        WHERE user_id = %s
                        AND title = %s',
                        array('integer', 'text'),
                        array($this->user_id, $a_folder_name)
                );
                $row = $ilDB->fetchAssoc($res);
 
                return is_array($row) && $row['obj_id'] > 0 ? true : false;
        }
 
        public function deleteFolder($a_folder_id)
        {
                global $ilDB;
 
                $query = $ilDB->queryf('
                        SELECT obj_id, title FROM mail_obj_data
                        WHERE obj_id = %s AND user_id = %s',
                        array('integer', 'integer'),
                        array($a_folder_id, $this->user_id)
                );
                $row = $ilDB->fetchAssoc($query);
 
                if(!is_array($row) || array_key_exists($row['title'], $this->default_folder))
                {
                        return false;
                }
 
                require_once 'Services/Mail/classes/class.ilMail.php';
                $umail = new ilMail($this->user_id);
 
                $subtree = $this->mtree->getSubtree($this->mtree->getNodeData($a_folder_id));
                $this->mtree->deleteTree($this->mtree->getNodeData($a_folder_id));
 
                foreach($subtree as $node)
                {
                        $mails    = $umail->getMailsOfFolder($node["obj_id"]);
                        $mail_ids = array();
                        foreach($mails as $mail)
                        {
                                $mail_ids[] = $mail["mail_id"];
                        }
 
                        $umail->deleteMails($mail_ids);
 
                        $ilDB->manipulateF('
                                DELETE FROM '. $this->table_mail_obj_data .' 
                                WHERE obj_id = %s AND user_id = %s',
                                array('integer', 'integer'),
                                array($node['obj_id'], $this->user_id)
                        );
                }
 
                return true;
        }
 
        public function getFolderData($a_obj_id)
        {
                global $ilDB;
 
                $res = $ilDB->queryF('
                        SELECT * FROM ' . $this->table_mail_obj_data . ' 
                        WHERE user_id = %s
                        AND obj_id = %s',
                        array('integer', 'integer'),
                        array($this->user_id, $a_obj_id)
                );
                $row = $ilDB->fetchAssoc($res);
 
                return array(
                        'obj_id' => $row['obj_id'],
                        'title'  => $row['title'],
                        'type'   => $row['m_type']
                );
        }
 
        public function getParentFolderId($a_obj_id)
        {
                global $ilDB;
 
                $res = $ilDB->queryF('
                        SELECT * FROM  '. $this->table_tree .' 
                        WHERE child = %s AND tree = %s',
                        array('integer', 'integer'),
                        array($a_obj_id, $this->user_id)
                );
                $row = $ilDB->fetchAssoc($res);
 
                return is_array($row) ? $row['parent'] : 0;
        }
 
        public function getSubFolders($a_folder = 0, $a_folder_parent = 0)
        {
                global $ilDB;
 
                if(!$a_folder)
                {
                        $a_folder = $this->getRootFolderId();
                }
 
                $user_folder = array();
 
                foreach($this->default_folder as $key => $value)
                {
                        $res = $ilDB->queryF('
                                SELECT obj_id, m_type
                                FROM ' . $this->table_mail_obj_data . ' 
                                WHERE user_id = %s
                                AND title = %s',
                                array('integer', 'text'),
                                array($this->user_id, $key)
                        );
                        $row = $ilDB->fetchAssoc($res);
 
                        $user_folder[] = array(
                                'title'  => $key,
                                'type'   => $row['m_type'],
                                'obj_id' => $row['obj_id']
                        );
                }
 
                $res = $ilDB->queryF('
                        SELECT * FROM ' . $this->table_tree . ', ' . $this->table_mail_obj_data . '
                        WHERE ' . $this->table_mail_obj_data . '.obj_id = ' . $this->table_tree . '.child 
                        AND ' . $this->table_tree . '.depth  > %s
                        AND ' . $this->table_tree . '.tree  = %s
                        ORDER BY ' . $this->table_tree . '.lft, ' . $this->table_mail_obj_data . '.title  ',
                        array('integer', 'integer'),
                        array(2, $this->user_id)
                );
                while($row = $ilDB->fetchAssoc($res))
                {
                        $user_folder[] = array(
                                'title'  => $row['title'],
                                'type'   => $row['m_type'],
                                'obj_id' => $row['child']
                        );
                }
 
                return $user_folder;
        }
 
        public function setUserId($a_user_id)
        {
                $this->user_id = $a_user_id;
        }
        
        public function delete()
        {
                global $ilDB;
                
                $ilDB->manipulateF('
                        DELETE FROM mail_obj_data WHERE user_id = %s',
                        array('integer'), array($this->user_id)
                );
 
                $ilDB->manipulateF('
                        DELETE FROM mail_options WHERE user_id = %s',
                        array('integer'), array($this->user_id)
                );
 
                $ilDB->manipulateF('
                        DELETE FROM mail_saved WHERE user_id = %s',
                        array('integer'), array($this->user_id)
                );
                
                $ilDB->manipulateF('
                        DELETE FROM mail_tree WHERE tree = %s',
                        array('integer'), array($this->user_id)
                );
 
                // Delete the user's files from filesystem: This has to be done before deleting the database entries in table 'mail'
                require_once 'Services/Mail/classes/class.ilFileDataMail.php';
                $fdm = new ilFileDataMail($this->user_id);
                $fdm->onUserDelete();
                
                // Delete mails of deleted user
                $ilDB->manipulateF(
                        'DELETE FROM mail WHERE user_id = %s',
                        array('integer'),
                        array($this->user_id)
                );
 
                return true;
        }
 
        public function updateMailsOfDeletedUser($nameToShow)
        {
                global $ilDB;
 
                $ilDB->manipulateF('
                        UPDATE mail 
                        SET sender_id = %s, import_name = %s
                        WHERE sender_id = %s',
                        array('integer', 'text', 'integer'),
                        array(0, $nameToShow, $this->user_id)
                );
        }
}