class.ilBlogPosting.php

Go to the documentation of this file.

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

include_once("./Services/COPage/classes/class.ilPageObject.php");

class ilBlogPosting extends ilPageObject
{       
        protected $title; // [string]
        protected $created; // [ilDateTime]
        protected $blog_node_id; // [int]
        protected $blog_node_is_wsp; // [bool]
        protected $author; // [int]
        protected $approved; // [bool]

        function __construct($a_id = 0, $a_old_nr = 0, $a_halt = true)
        {
                parent::__construct("blp", $a_id, $a_old_nr, $a_halt);
        }

        function setTitle($a_title)
        {
                $this->title = $a_title;
        }

        function getTitle()
        {
                return $this->title;
        }

        function setBlogId($a_id)
        {
                $this->setParentId($a_id);
        }

        function getBlogId()
        {
                return $this->getParentId();
        }

        function setCreated(ilDateTime $a_date)
        {
                $this->created = $a_date;
        }

        function getCreated()
        {
                return $this->created;
        }
        
        function setAuthor($a_id)
        {
                $this->author = (int)$a_id;
        }

        function getAuthor()
        {
                return $this->author;
        }
        
        function setApproved($a_status)
        {
                $this->approved = (bool)$a_status;
        }

        function isApproved()
        {
                return (bool)$this->approved;
        }

        function create($a_import = false)
        {
                global $ilDB;

                $id = $ilDB->nextId("il_blog_posting");
                $this->setId($id);
                
                if(!$a_import)
                {
                        $created = ilUtil::now();
                }
                else
                {
                        $created = $this->getCreated()->get(IL_CAL_DATETIME);
                }

                // we are using a separate creation date to enable sorting without JOINs
                
                $query = "INSERT INTO il_blog_posting (id, title, blog_id, created, author, approved)".
                        " VALUES (".
                        $ilDB->quote($this->getId(), "integer").",".
                        $ilDB->quote($this->getTitle(), "text").",".
                        $ilDB->quote($this->getBlogId(), "integer").",".
                        $ilDB->quote($created, "timestamp").",".
                        $ilDB->quote($this->getAuthor(), "integer").",".
                        $ilDB->quote(false, "integer").")";
                $ilDB->manipulate($query);

                if(!$a_import)
                {
                        parent::create();               
                        // $this->saveInternalLinks($this->getXMLContent());
                }
        }

        function update($a_validate = true, $a_no_history = false, $a_notify = true)
        {
                global $ilDB;

                // blog_id, author and created cannot be changed
                
                $query = "UPDATE il_blog_posting SET".
                        " title = ".$ilDB->quote($this->getTitle(), "text").
                        ",created = ".$ilDB->quote($this->getCreated()->get(IL_CAL_DATETIME), "text").
                        ",approved =".$ilDB->quote($this->isApproved(), "integer").
                        " WHERE id = ".$ilDB->quote($this->getId(), "integer");
                $ilDB->manipulate($query);
                
                parent::update($a_validate, $a_no_history);
                
                if($a_notify && $this->getActive())
                {                               
                        include_once "Modules/Blog/classes/class.ilObjBlog.php";
                        ilObjBlog::sendNotification("update", $this->blog_node_is_wsp, $this->blog_node_id, $this->getId());
                }

                return true;
        }
        
        function read()
        {
                global $ilDB;
                
                $query = "SELECT * FROM il_blog_posting".
                        " WHERE id = ".$ilDB->quote($this->getId(), "integer");
                $set = $ilDB->query($query);
                $rec = $ilDB->fetchAssoc($set);

                $this->setTitle($rec["title"]);
                $this->setBlogId($rec["blog_id"]);
                $this->setCreated(new ilDateTime($rec["created"], IL_CAL_DATETIME));
                $this->setAuthor($rec["author"]);
                if((bool)$rec["approved"])
                {
                        $this->setApproved(true);
                }
                
                // when posting is deactivated it should loose the approval
                $this->addUpdateListener($this, "checkApproval");
        
                parent::read();
        }
                
        function checkApproval()
        {
                if(!$this->getActive() && $this->isApproved())
                {
                        $this->approved = false;
                        $this->update();
                }               
        }

        function delete()
        {
                global $ilDB;

                $query = "DELETE FROM il_blog_posting".
                        " WHERE id = ".$ilDB->quote($this->getId(), "integer");
                $ilDB->manipulate($query);
                
                parent::delete();

                return true;
        }

        static function deleteAllBlogPostings($a_blog_id)
        {
                global $ilDB;
                
                include_once 'Services/MetaData/classes/class.ilMD.php';
                
                $query = "SELECT * FROM il_blog_posting".
                        " WHERE blog_id = ".$ilDB->quote($a_blog_id, "integer");
                $set = $ilDB->query($query);
                while($rec = $ilDB->fetchAssoc($set))
                {                       
                        // delete all md keywords 
                        $md_obj = new ilMD($a_blog_id, $rec["id"], "blp");
                        if(is_object($md_section = $md_obj->getGeneral()))
                        {
                                foreach($md_section->getKeywordIds() as $id)
                                {
                                        $md_key = $md_section->getKeyword($id);                         
                                        $md_key->delete();                              
                                }
                        }
                        
                        $post = new ilBlogPosting($rec["id"]);
                        $post->delete();
                }
        }
        
        static function lookupBlogId($a_posting_id)
        {
                global $ilDB;

                $query = "SELECT blog_id FROM il_blog_posting".
                        " WHERE id = ".$ilDB->quote($a_posting_id, "integer");
                $set = $ilDB->query($query);
                if ($rec = $ilDB->fetchAssoc($set))
                {
                        return $rec["blog_id"];
                }
                return false;
        }

        static function getAllPostings($a_blog_id, $a_limit = 1000, $a_offset = 0)
        {
                global $ilDB;
                
                $pages = parent::getAllPages("blp", $a_blog_id);

                if($a_limit)
                {
                        $ilDB->setLimit($a_limit, $a_offset);
                }
                
                $query = "SELECT * FROM il_blog_posting".
                        " WHERE blog_id = ".$ilDB->quote($a_blog_id, "integer").
                        " ORDER BY created DESC";
                $set = $ilDB->query($query);
                $post = array();
                while($rec = $ilDB->fetchAssoc($set))
                {
                        if (isset($pages[$rec["id"]]))
                        {
                                $post[$rec["id"]] = $pages[$rec["id"]];
                                $post[$rec["id"]]["title"] = $rec["title"];
                                $post[$rec["id"]]["created"] = new ilDateTime($rec["created"], IL_CAL_DATETIME);
                                $post[$rec["id"]]["author"] = $rec["author"];
                                $post[$rec["id"]]["approved"] = (bool)$rec["approved"];
                        }
                }

                return $post;
        }

        static function exists($a_blog_id, $a_posting_id)
        {
                global $ilDB;

                $query = "SELECT id FROM il_blog_posting".
                        " WHERE blog_id = ".$ilDB->quote($a_blog_id, "integer").
                        " AND id = ".$ilDB->quote($a_posting_id, "integer");
                $set = $ilDB->query($query);
                if($rec = $ilDB->fetchAssoc($set))
                {
                        return true;
                }
                return false;
        }

        static function getLastPost($a_blog_id)
        {
                $data = self::getAllPostings($a_blog_id, 1);
                if($data)
                {
                        return array_pop(array_keys($data));
                }
        }
        
        public function setBlogNodeId($a_id, $a_is_in_workspace = false)
        {
                $this->blog_node_id = (int)$a_id;
                $this->blog_node_is_wsp = (bool)$a_is_in_workspace;
        }
        
        public static function searchBlogsByAuthor($a_user_id)
        {
                global $ilDB;
                
                $ids = array();
                
                $sql = "SELECT DISTINCT(blog_id)".
                        " FROM il_blog_posting".
                        " WHERE author = ".$ilDB->quote($a_user_id);
                $set = $ilDB->query($sql);
                while($row = $ilDB->fetchAssoc($set))
                {
                        $ids[] = $row["blog_id"];
                }
                return $ids;
        }
}

?>