class.ilBlogPosting.php

Go to the documentation of this file.

<?php

/* Copyright (c) 1998-2019 ILIAS open source, Extended GPL, see docs/LICENSE */

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]
    protected $withdrawn; // [ilDateTime]

    public function getParentType()
    {
        return "blp";
    }


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

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

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

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

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

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

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

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

    public function setWithdrawn(ilDateTime $a_date)
    {
        $this->withdrawn = $a_date;
    }

    public function getWithdrawn()
    {
        return $this->withdrawn;
    }

    public function create($a_import = false)
    {
        $ilDB = $this->db;

        $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, last_withdrawn)" .
            " 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($this->isApproved(), "integer") . "," . // #16526 - import
            $ilDB->quote($this->getWithdrawn(), "timestamp") . ")";
        $ilDB->manipulate($query);

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

    public function update($a_validate = true, $a_no_history = false, $a_notify = true, $a_notify_action = "update")
    {
        $ilDB = $this->db;

        // 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), "timestamp") .
            ",approved =" . $ilDB->quote($this->isApproved(), "integer") .
            ",last_withdrawn =" . $ilDB->quote($this->getWithdrawn()->get(IL_CAL_DATETIME), "timestamp") .
            " WHERE id = " . $ilDB->quote($this->getId(), "integer");
        $ilDB->manipulate($query);
        
        parent::update($a_validate, $a_no_history);
        
        if ($a_notify && $this->getActive()) {
            ilObjBlog::sendNotification($a_notify_action, $this->blog_node_is_wsp, $this->blog_node_id, $this->getId());
        }

        return true;
    }
    
    public function read()
    {
        $ilDB = $this->db;
        
        $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);
        }
        $this->setWithdrawn(new ilDateTime($rec["last_withdrawn"], IL_CAL_DATETIME));
        
        // when posting is deactivated it should loose the approval
        $this->addUpdateListener($this, "checkApproval");
    
        parent::read();
    }
        
    public function checkApproval()
    {
        if (!$this->getActive() && $this->isApproved()) {
            $this->approved = false;
            $this->update();
        }
    }

    public function delete()
    {
        $ilDB = $this->db;

        ilNewsItem::deleteNewsOfContext(
            $this->getBlogId(),
            "blog",
            $this->getId(),
            $this->getParentType()
        );

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

        return true;
    }

    public function unpublish()
    {
        $this->setApproved(false);
        $this->setActive(false);
        $this->setWithdrawn(new ilDateTime(ilUtil::now(), IL_CAL_DATETIME));
        $this->update(true, false, false);

        ilNewsItem::deleteNewsOfContext(
            $this->getBlogId(),
            "blog",
            $this->getId(),
            $this->getParentType()
        );
    }


    public static function deleteAllBlogPostings($a_blog_id)
    {
        global $DIC;

        $ilDB = $DIC->database();
        
        $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();
        }
    }
    
    public static function lookupBlogId($a_posting_id)
    {
        global $DIC;

        $ilDB = $DIC->database();

        $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;
    }

    public static function getAllPostings($a_blog_id, $a_limit = 1000, $a_offset = 0)
    {
        global $DIC;

        $ilDB = $DIC->database();
        
        $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"];
                $post[$rec["id"]]["last_withdrawn"] = new ilDateTime($rec["last_withdrawn"], IL_CAL_DATETIME);
                                
                foreach (self::getPageContributors("blp", $rec["id"]) as $editor) {
                    if ($editor["user_id"] != $rec["author"]) {
                        $post[$rec["id"]]["editors"][] = $editor["user_id"];
                    }
                }
            }
        }

        return $post;
    }

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

        $ilDB = $DIC->database();

        $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;
    }

    public 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 $DIC;

        $ilDB = $DIC->database();
        
        $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;
    }
    
    public function getNotificationAbstract()
    {
        $snippet = ilBlogPostingGUI::getSnippet($this->getId(), true);
        
        // making things more readable
        $snippet = str_replace('<br/>', "\n", $snippet);
        $snippet = str_replace('<br />', "\n", $snippet);
        $snippet = str_replace('</p>', "\n", $snippet);
        $snippet = str_replace('</div>', "\n", $snippet);
    
        return trim(strip_tags($snippet));
    }
    
    
    // keywords
    
    public function getMDSection()
    {
        // general section available?
        $md_obj = new ilMD($this->getBlogId(), $this->getId(), "blp");
        if (!is_object($md_section = $md_obj->getGeneral())) {
            $md_section = $md_obj->addGeneral();
            $md_section->save();
        }
        
        return $md_section;
    }
        
    public function updateKeywords(array $keywords)
    {
        $ilUser = $this->user;
                
        // language is not "used" anywhere
        $ulang = $ilUser->getLanguage();
        $keywords = array($ulang => $keywords);

        ilMDKeyword::updateKeywords($this->getMDSection(), $keywords);
    }
        
    public static function getKeywords($a_obj_id, $a_posting_id)
    {
        return ilMDKeyword::lookupKeywords($a_obj_id, $a_posting_id);
    }
        
    public function handleNews($a_update = false)
    {
        $lng = $this->lng;
        $ilUser = $this->user;
        
        // see ilWikiPage::updateNews()

        if (!$this->getActive()) {
            return;
        }

        $news_item = null;
        
        // try to re-use existing news item
        if ((bool) $a_update) {
            // get last news item of the day (if existing)
            $news_id = ilNewsItem::getLastNewsIdForContext(
                $this->getBlogId(),
                "blog",
                $this->getId(),
                $this->getParentType(),
                true
            );
            if ($news_id > 0) {
                $news_item = new ilNewsItem($news_id);
            }
        }
        
        // create new news item
        if (!$news_item) {
            $news_set = new ilSetting("news");
            $default_visibility = $news_set->get("default_visibility", "users");
            
            $news_item = new ilNewsItem();
            $news_item->setContext(
                $this->getBlogId(),
                "blog",
                $this->getId(),
                $this->getParentType()
            );
            $news_item->setPriority(NEWS_NOTICE);
            $news_item->setVisibility($default_visibility);
        }
        
        // news author
        $news_item->setUserId($ilUser->getId());
        
        
        // news title/content
        
        $news_item->setTitle($this->getTitle());
                
        $content = $a_update
            ? "blog_news_posting_updated"
            : "blog_news_posting_published";
        
        // news "author"
        $content = sprintf($lng->txt($content), ilUserUtil::getNamePresentation($ilUser->getId()));
        
        // posting author[s]
        $contributors = array();
        foreach (self::getPageContributors($this->getParentType(), $this->getId()) as $user) {
            $contributors[] = $user["user_id"];
        }
        if (sizeof($contributors) > 1 || !in_array($this->getAuthor(), $contributors)) {
            // original author should come first?
            $authors = array(ilUserUtil::getNamePresentation($this->getAuthor()));
            foreach ($contributors as $user_id) {
                if ($user_id != $this->getAuthor()) {
                    $authors[] = ilUserUtil::getNamePresentation($user_id);
                }
            }
            $content .= "\n" . sprintf($lng->txt("blog_news_posting_authors"), implode(", ", $authors));
        }
        
        $news_item->setContentTextIsLangVar(false);
        $news_item->setContent($content);
        
        $snippet = ilBlogPostingGUI::getSnippet($this->getId());
        $news_item->setContentLong($snippet);
            
        if (!$news_item->getId()) {
            $news_item->create();
        } else {
            $news_item->update(true);
        }
    }

    protected static function lookup($a_field, $a_posting_id)
    {
        global $DIC;

        $db = $DIC->database();

        $set = $db->query("SELECT $a_field FROM il_blog_posting " .
            " WHERE id = " . $db->quote($a_posting_id, "integer"));
        $rec = $db->fetchAssoc($set);

        return $rec[$a_field];
    }

    public static function lookupTitle($a_posting_id)
    {
        $t = self::lookup("title", $a_posting_id);
        return $t;
    }
}