class.ilForumPost.php

Go to the documentation of this file.

<?php
/* Copyright (c) 1998-2012 ILIAS open source, Extended GPL, see docs/LICENSE */

require_once './Modules/Forum/classes/class.ilForumTopic.php';

class ilForumPost
{
        private $id = 0;
        
        private $forum_id = 0;
        
        private $thread_id = 0;
        
        private $display_user_id = 0;
        
        private $user_alias = '';
        
        private $subject = '';
        
        private $message = '';
        
        private $createdate = '0000-00-00 00:00:00';
        
        private $changedate = '0000-00-00 00:00:00';
        
        private $user_id_update = 0;
        
        private $censored = 0;
        
        private $censorship_comment = '';
        
        private $censored_date = '0000-00-00 00:00:00';
        
        private $notification = 0;
        
        private $import_name = '';
        
        private $status = 1;    
        
        private $tree_id = 0;
        
        private $parent_id = 0;
        
        private $lft = 0;
        
        private $rgt = 0;
        
        private $depth = 0;
        
        private $fullname = '';
        
        private $loginname = '';
        
        private $objThread = null;
        
        private $db = null;

        private $is_moderator = false;
        
        private $is_author_moderator = null;
        
        private $post_read = false;
        
        private $pos_author_id = 0;
        
        private $post_activation_date = '0000-00-00 00:00:00';
        
        public function __construct($a_id = 0, $a_is_moderator = false, $preventImplicitRead = false)
        {
                global $ilDB;

                $this->db = $ilDB;
                $this->id = $a_id;

                if( !$preventImplicitRead )
                {
                        $this->read();
                }
        }
        
        public function __destruct()
        {
                unset($this->db);
                unset($this->objThread);
        }
        
        public function insert()
        {
                global $ilDB;
                
                if ($this->forum_id && $this->thread_id)
                {
                        $this->id = $this->db->nextId('frm_posts');     
                        
                        $ilDB->insert('frm_posts', array(
                                'pos_pk'                => array('integer', $this->id),
                                'pos_top_fk'    => array('integer', $this->forum_id),
                                'pos_thr_fk'    => array('integer', $this->thread_id),
                                'pos_display_user_id'   => array('integer', $this->display_user_id),
                                'pos_usr_alias' => array('text', $this->user_alias),
                                'pos_subject'   => array('text', $this->subject),
                                'pos_message'   => array('clob', $this->message),
                                'pos_date'              => array('timestamp', $this->createdate),
                                'pos_update'    => array('timestamp', $this->createdate),
                                'update_user'   => array('integer', $this->user_id_update),
                                'pos_cens'              => array('integer', $this->censored),
                                'notify'                => array('integer', (int)$this->notification),
                                'import_name'   => array('text', (string)$this->import_name),
                                'pos_status'    => array('integer', (int)$this->status),
                                'pos_author_id' => array('integer', (int)$this->pos_author_id),
                                'is_author_moderator' => array('integer', $this->is_author_moderator),
                                'pos_activation_date' => array('timestamp', $this->createdate) 
                        ));
                        
                        return true;
                }
                
                return false;
        }
        
        public function update()
        {
                global $ilDB;

                if($this->id)
                {
                        $ilDB->update('frm_posts',
                                array(
                                        'pos_top_fk'    => array('integer', $this->forum_id),
                                        'pos_thr_fk'    => array('integer', $this->thread_id),
                                        'pos_subject'   => array('text', $this->subject),
                                        'pos_message'   => array('clob', $this->message),
                                        'pos_update'    => array('timestamp', $this->changedate),
                                        'update_user'   => array('integer', $this->user_id_update),
                                        'pos_cens'              => array('integer', $this->censored),
                                        'pos_cens_date' => array('timestamp', $this->censored_date),
                                        'pos_cens_com'  => array('text', $this->censorship_comment),
                                        'notify'                => array('integer', (int)$this->notification),
                                        'pos_status'    => array('integer', (int)$this->status)
                                ),
                                array(
                                        'pos_pk'                => array('integer', (int)$this->id)
                                )
                        );
                        
                        if($this->objThread->getFirstPostId() == $this->id)
                        {
                                $this->objThread->setSubject($this->subject);
                                $this->objThread->update();
                                $this->objThread->reload();
                        }
                        
                        return true;
                }
                
                return false;
        }
        
        private function read()
        {       
                if ($this->id)
                {
                        $res = $this->db->queryF('
                                SELECT * FROM frm_posts
                                INNER JOIN frm_posts_tree ON pos_fk = pos_pk
                                WHERE pos_pk = %s',
                                array('integer'), array($this->id));
                        $row = $this->db->fetchObject($res);
                        
                        if (is_object($row))
                        {
                                $this->id                 = $row->pos_pk;
                                $this->forum_id           = $row->pos_top_fk;
                                $this->thread_id          = $row->pos_thr_fk;
                                $this->display_user_id    = $row->pos_display_user_id;
                                $this->user_alias         = $row->pos_usr_alias;
                                $this->subject            = $row->pos_subject;
                                $this->message            = $row->pos_message;
                                $this->createdate         = $row->pos_date;
                                $this->changedate         = $row->pos_update;
                                $this->user_id_update     = $row->update_user;
                                $this->censored           = $row->pos_cens;
                                $this->censored_date      = $row->pos_cens_date;
                                $this->censorship_comment = $row->pos_cens_com;
                                $this->notification       = $row->notify;
                                $this->import_name        = $row->import_name;
                                $this->status             = $row->pos_status;
                                $this->tree_id            = $row->fpt_pk;
                                $this->parent_id          = $row->parent_pos;
                                $this->lft                = $row->lft;
                                $this->rgt                = $row->rgt;
                                $this->depth              = $row->depth;
                                $this->pos_author_id      = $row->pos_author_id;
                                $this->is_author_moderator = $row->is_author_moderator;
                                $this->post_activation_date = $row->pos_activation_date;
                                $this->getUserData();
                                
                                $this->objThread = new ilForumTopic($this->thread_id, $this->is_moderator);
                                
                                return true;
                        }
                        
                        return false;
                }
                
                return false;
        }
        
        public function isAnyParentDeactivated()
        {
                if ($this->id)
                {
                        $res = $this->db->queryF('
                                SELECT * FROM frm_posts_tree
                                INNER JOIN frm_posts ON pos_pk = pos_fk
                                WHERE pos_status = %s
                                AND lft < %s AND rgt > %s
                                AND thr_fk = %s',
                                array('integer', 'integer', 'integer', 'integer'), 
                                array('0', $this->lft, $this->rgt, $this->thread_id));
                        
                        return $res->numRows();
                }
                
                return false;
        }
        
        protected function buildUserRelatedData($row)
        {
                global $lng;
                
                if ($row['pos_display_user_id'] && $row['pos_pk'])
                {
                        require_once 'Services/User/classes/class.ilObjUser.php';
                        $tmp_user = new ilObjUser();
                        $tmp_user->setFirstname($row['firstname']);
                        $tmp_user->setLastname($row['lastname']);
                        $tmp_user->setUTitle($row['title']);
                        $tmp_user->setLogin($row['login']);
                        
                        $this->fullname = $tmp_user->getFullname();
                        $this->loginname = $tmp_user->getLogin();
                
                        $this->fullname = $this->fullname ? $this->fullname : ($this->import_name ? $this->import_name : $lng->txt('unknown'));
                }
        }
        
        private function getUserData()
        {
                global $lng;
                
                if ($this->id && $this->display_user_id)
                {
                        require_once("Modules/Forum/classes/class.ilObjForumAccess.php");
                        if(($tmp_user = ilObjForumAccess::getCachedUserInstance($this->display_user_id)))
                        {
                                $this->fullname = $tmp_user->getFullname();
                                $this->loginname = $tmp_user->getLogin();
                                unset($tmp_user);
                        }
                
                        $this->fullname = $this->fullname ? $this->fullname : ($this->import_name ? $this->import_name : $lng->txt('unknown'));
                        
                        return true;
                }
                
                return false;
        }
        
        public function reload()
        {
                return $this->read();
        }
        
        public function setFullname($a_fullname)
        {
                $this->fullname = $a_fullname;
        }
        public function getFullname()
        {
                return $this->fullname; 
        }
        public function setLoginName($a_loginname)
        {
                $this->loginname = $a_loginname;
        }
        public function getLoginName()
        {
                return $this->loginname;        
        }

        public function activatePost()
        {               
                if ($this->id)
                {
                        $this->db->update('frm_posts',
                                array('pos_status'      =>      array('integer', 1),
                                      'pos_activation_date' => array('timestamp', date("Y-m-d H:i:s"))),
                                array('pos_pk'          =>      array('integer', $this->id))
                        );

                        $this->activateParentPosts();
                        
                        return true;
                }
                
                return false;
        }
        
        public function activatePostAndChildPosts()
        {
                if ($this->id)
                {                       
                        $query = "SELECT pos_pk FROM frm_posts_tree treea "
                               . "INNER JOIN frm_posts_tree treeb ON treeb.thr_fk = treea.thr_fk "
                                   . "AND treeb.lft BETWEEN treea.lft AND treea.rgt "
                                   . "INNER JOIN frm_posts ON pos_pk = treeb.pos_fk "
                                   . "WHERE treea.pos_fk = %s";
                        $result = $this->db->queryF(
                                $query,
                                array('integer'),
                                array($this->id)
                        );

                        $now = date("Y-m-d H:i:s");
                        while($row = $this->db->fetchAssoc($result))
                        {
                                $this->db->update('frm_posts',
                                        array('pos_status'      =>      array('integer', 1),
                                              'pos_activation_date' => array('timestamp', $now)),
                                        array('pos_pk'          =>      array('integer', $row['pos_pk']))
                                );
                        }
                        
                        $this->activateParentPosts();
                                
                        return true;
                }
                
                return false;
        }
        
        public function activateParentPosts()
        {
                if ($this->id)
                {
                        $query = "SELECT pos_pk FROM frm_posts "
                               . "INNER JOIN frm_posts_tree ON pos_fk = pos_pk "
                                   . "WHERE lft < %s AND rgt > %s AND thr_fk = %s";
                        $result = $this->db->queryF(
                                $query,
                                array('integer', 'integer', 'integer'),
                                array($this->lft, $this->rgt, $this->thread_id)
                        );
                        
                        $now = date("Y-m-d H:i:s");
                        while($row = $this->db->fetchAssoc($result))
                        {
                                $this->db->update('frm_posts',
                                        array('pos_status'      =>      array('integer', 1),
                                              'pos_activation_date' => array('timestamp', $now)),
                                        array('pos_pk'          =>      array('integer', $row['pos_pk']))
                                );
                        }
                        
                        return true;
                }
                
                return false;
        }
        
        public function isPostRead()
        {
                return $this->getIsRead();
        }
        
        public function isRead($a_user_id = 0)
        {
                if ($a_user_id && $this->id)
                {

                        $res = $this->db->queryF('
                                SELECT * FROM frm_user_read 
                                WHERE usr_id = %s
                                AND post_id = %s',
                                array('integer', 'integer'),
                                array($a_user_id, $this->id));
                        
                        return $res->numRows() ? true : false;
                }
                
                return false;
        }
        
        public function hasReplies()
        {
                if ($this->id && $this->rgt && $this->lft)
                {
                        $res = $this->db->queryF('
                                SELECT * FROM frm_posts_tree                                     
                                WHERE lft > %s AND rgt < %s
                                AND thr_fk = %s',
                                array('integer', 'integer', 'integer'),
                                array($this->lft, $this->rgt, $this->thread_id));

                        return $res->numRows() ? true : false;
                }
                
                return false;
        }
        
        public function isOwner($a_user_id = 0)
        {
                if ($this->pos_author_id && $a_user_id)
                {
                        if ((int) $this->pos_author_id == (int) $a_user_id)
                        {
                                return true;
                        }
                        return false;
                }
                return false;
        }
        
        public function setId($a_id)
        {
                $this->id = $a_id;
        }
        public function getId()
        {
                return $this->id;
        }
        public function setForumId($a_forum_id)
        {
                $this->forum_id = $a_forum_id;
        }
        public function getForumId()
        {
                return $this->forum_id;
        }
        public function setThreadId($a_thread_id)
        {
                $this->thread_id = $a_thread_id;
        }
        public function getThreadId()
        {
                return $this->thread_id;
        }
        public function setDisplayUserId($a_user_id)
        {
                $this->display_user_id = $a_user_id;            
        }
        public function getDisplayUserId()
        {
                return $this->display_user_id;
        }
        public function setUserAlias($a_user_alias)
        {
                $this->user_alias = $a_user_alias;
        }
        public function getUserAlias()
        {
                return $this->user_alias;
        }
        public function setSubject($a_subject)
        {
                $this->subject = $a_subject;
        }
        public function getSubject()
        {
                return $this->subject;
        }
        public function setMessage($a_message)
        {
                $this->message = $a_message;
        }
        public function getMessage()
        {
                return $this->message;
        }
        public function setCreateDate($a_createdate)
        {
                $this->createdate = $a_createdate;
        }
        public function getCreateDate()
        {
                return $this->createdate;
        }
        public function setChangeDate($a_changedate)
        {
                $this->changedate = $a_changedate;
        }
        public function getChangeDate()
        {
                return $this->changedate;
        }       
        public function setUpdateUserId($a_user_id_update)
        {
                $this->user_id_update = $a_user_id_update;
        }
        public function getUpdateUserId()
        {
                return $this->user_id_update;
        }
        public function setCensorship($a_censorship)
        {
                $this->censored = $a_censorship;
        }
        public function isCensored()
        {
                return $this->censored == 1 ? true : false;
        }
        public function setCensorshipComment($a_comment)
        {
                $this->censorship_comment = $a_comment;
        }
        public function getCensorshipComment()
        {               
                return $this->censorship_comment;
        }
        public function setNotification($a_notification)
        {
                $this->notification = $a_notification;
        }
        public function isNotificationEnabled()
        {
                return $this->notification == 1 ? true : false;
        }
        public function setImportName($a_import_name)
        {
                $this->import_name = $a_import_name;
        }
        public function getImportName()
        {
                return $this->import_name;
        }
        public function setStatus($a_status)
        {
                $this->status = $a_status;
        }
        public function isActivated()
        {
                return $this->status == 1 ? true : false;
        }
        public function setTreeId($a_tree_id)
        {
                $this->tree_id = $a_tree_id;
        }
        public function getTreeId()
        {
                return $this->tree_id;
        }
        public function setParentId($a_parent_id)
        {
                $this->parent_id = $a_parent_id;
        }
        
        public function setIsRead($a_is_read)
        {
                $this->post_read = $a_is_read;
        }
        
        public function getIsRead()
        {
                return $this->post_read;
        }
        
        public function getParentId()
        {
                return $this->parent_id;
        }
        public function setLft($a_lft)
        {
                $this->lft = $a_lft;
        }
        public function getLft()
        {
                return $this->lft;
        }
        public function setRgt($a_rgt)
        {
                $this->rgt = $a_rgt;
        }
        public function getRgt()
        {
                return $this->rgt;
        }
        public function setDepth($a_depth)
        {
                $this->depth = $a_depth;
        }
        public function getDepth()
        {
                return $this->depth;
        }
        public function setThread(ilForumTopic $thread)
        {
                $this->objThread = $thread;
        }
        public function getThread()
        {
                return $this->objThread;
        }

        public function setPosAuthorId($pos_author_id)
        {
                $this->pos_author_id = $pos_author_id;
        }

        public function getPosAuthorId()
        {
                return $this->pos_author_id;
        }
        public function getIsAuthorModerator()
        {
                return $this->is_author_moderator;
        }

        public function setIsAuthorModerator($is_author_moderator)
        {
                $this->is_author_moderator = $is_author_moderator;
        }

        public function getCensoredDate()
        {
                return $this->censored_date;
        }
        
        public function getPostActivationDate()
        {
                return $this->post_activation_date;
        }
        
        public function setPostActivationDate($post_activation_date)
        {
                $this->post_activation_date = $post_activation_date;
        }

        public function setCensoredDate($censored_date)
        {
                $this->censored_date = $censored_date;
        }
        
        public function assignData($row)
        {
                $this->setUserAlias($row['pos_usr_alias']);
                $this->setSubject($row['pos_subject']);
                $this->setCreateDate($row['pos_date']);
                $this->setMessage($row['pos_message']);
                $this->setForumId($row['pos_top_fk']);
                $this->setThreadId($row['pos_thr_fk']);
                $this->setChangeDate($row['pos_update']);
                $this->setUpdateUserId($row['update_user']);
                $this->setCensorship($row['pos_cens']);
                $this->setCensoredDate($row['pos_cens_date']);
                $this->setCensorshipComment($row['pos_cens_com']);
                $this->setNotification($row['notify']);
                $this->setImportName($row['import_name']);
                $this->setStatus($row['pos_status']);
                $this->setTreeId($row['fpt_pk']);
                $this->setParentId($row['parent_pos']);
                $this->setLft($row['lft']);
                $this->setRgt($row['rgt']);
                $this->setDepth($row['depth']);
                $this->setIsRead($row['post_read']);
                $this->setDisplayUserId($row['pos_display_user_id']);
                $this->setPosAuthorId($row['pos_author_id']);
                $this->setIsAuthorModerator($row['is_author_moderator']);
                $this->buildUserRelatedData($row);
        }
        
        public static function mergePosts($source_thread_id, $target_thread_id)
        {
                global $ilDB;
                
                $ilDB->update('frm_posts',
                array('pos_thr_fk' => array('integer', $target_thread_id)),
                array('pos_thr_fk' => array('integer', $source_thread_id)));
        }
}