class.ilPortfolioPage.php

Go to the documentation of this file.

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

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

class ilPortfolioPage extends ilPageObject
{
        protected $portfolio_id;
        protected $type;
        protected $title;
        protected $order_nr;
        
        const TYPE_PAGE = 1;
        const TYPE_BLOG = 2;
        
        function __construct($a_portfolio_id, $a_id = 0, $a_old_nr = 0)
        {
                $this->portfolio_id = (int)$a_portfolio_id;
                $this->type = self::TYPE_PAGE;
                
                parent::__construct("prtf", $a_id, $a_old_nr);
        }
        
        function setType($a_val)
        {
                $this->type = $a_val;
        }

        function getType()
        {
                return $this->type;
        }

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

        function getTitle()
        {
                global $lng;
                
                // because of migration of extended user profiles
                if($this->title == "###-")
                {
                        return $lng->txt("profile");
                }
                
                return $this->title;
        }

        function setOrderNr($a_val)
        {
                $this->order_nr = (int)$a_val;
        }

        function getOrderNr()
        {
                return $this->order_nr;
        }

        static function lookupMaxOrderNr($a_portfolio_id)
        {
                global $ilDB;

                $set = $ilDB->query("SELECT MAX(order_nr) m FROM usr_portfolio_page".
                        " WHERE portfolio_id = ".$ilDB->quote($a_portfolio_id, "integer"));
                $rec = $ilDB->fetchAssoc($set);
                return (int) $rec["m"];
        }

        protected function getPropertiesForDB()
        {
                $fields = array("portfolio_id" => array("integer", $this->portfolio_id),
                        "type" => array("integer", $this->getType()),
                        "title" => array("text", $this->getTitle()),
                        "order_nr" => array("integer", $this->getOrderNr()));

                return $fields;
        }

        function create()
        {
                global $ilDB;

                $this->setOrderNr(self::lookupMaxOrderNr($this->portfolio_id) + 10);

                $id = $ilDB->nextId("usr_portfolio_page");
                $this->setId($id);

                $fields = $this->getPropertiesForDB();
                $fields["id"] = array("integer", $id);

                $ilDB->insert("usr_portfolio_page", $fields);

                parent::create();
                $this->saveInternalLinks($this->getXMLContent());
        }

        function update($a_validate = true, $a_no_history = false)
        {
                global $ilDB;
                
                $id = $this->getId();
                if($id)
                {
                        $fields = $this->getPropertiesForDB();
                        $ilDB->update("usr_portfolio_page", $fields,
                                array("id"=>array("integer", $id)));

                        parent::update($a_validate, $a_no_history);
                        return true;
                }
                return false;
        }
        
        function read()
        {
                global $ilDB;
                
                $query = "SELECT * FROM usr_portfolio_page".
                        " WHERE id = ".$ilDB->quote($this->getId(), "integer");
                $set = $ilDB->query($query);
                $rec = $ilDB->fetchAssoc($set);

                $this->setType($rec["type"]);
                $this->setTitle($rec["title"]);
                $this->setOrderNr($rec["order_nr"]);
                
                // get co page
                parent::read();
        }

        function delete()
        {
                global $ilDB;

                $id = $this->getId();
                if($id)
                {
                        // delete internal links information to this page
                        include_once("./Services/COPage/classes/class.ilInternalLink.php");
                        ilInternalLink::_deleteAllLinksToTarget("user", $this->getId());

                        // delete record of table usr_portfolio_page
                        $query = "DELETE FROM usr_portfolio_page".
                                " WHERE id = ".$ilDB->quote($this->getId(), "integer");
                        $ilDB->manipulate($query);
                
                        // delete co page
                        parent::delete();
                }
        }

        protected static function lookupProperty($a_id, $a_prop)
        {
                global $ilDB;

                $set = $ilDB->query("SELECT ".$a_prop.
                        " FROM usr_portfolio_page".
                        " WHERE id = ".$ilDB->quote($a_id, "integer"));
                $rec = $ilDB->fetchAssoc($set);
                return $rec[$a_prop];
        }

        static function lookupTitle($a_page_id)
        {
                return self::lookupProperty($a_page_id, "title");
        }

        static function getAllPages($a_portfolio_id)
        {
                global $ilDB, $lng;

                $set = $ilDB->query("SELECT * FROM usr_portfolio_page".
                        " WHERE portfolio_id = ".$ilDB->quote($a_portfolio_id, "integer").
                        " ORDER BY order_nr");
                $pages = array();
                while ($rec = $ilDB->fetchAssoc($set))
                {
                        // because of migration of extended user profiles
                        if($rec["title"] == "###-")
                        {
                                $rec["title"] = $lng->txt("profile");
                        }
                        
                        $pages[] = $rec;
                }
                return $pages;
        }

        public static function fixOrdering($a_portfolio_id)
        {
                global $ilDB;

                $pages = self::getAllPages($a_portfolio_id);
                $cnt = 10;
                foreach ($pages as $p)
                {
                        $ilDB->manipulate("UPDATE usr_portfolio_page SET ".
                                " order_nr = ".$ilDB->quote($cnt, "integer").
                                " WHERE id = ".$ilDB->quote($p["id"], "integer")
                        );
                        $cnt+= 10;
                }
        }
        
        public static function findPortfolioForPage($a_page_id)
        {
                return self::lookupProperty($a_page_id, "portfolio_id");
        }
}
?>