class.ilExtPublicProfilePage.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");

class ilExtPublicProfilePage extends ilPageObject
{
        function __construct($a_id = 0, $a_old_nr = 0)
        {
                parent::__construct("user", $a_id, $a_old_nr);
        }

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

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

        function setUserId($a_val)
        {
                $this->setParentId($a_val);
        }

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

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

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

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

                $set = $ilDB->query("SELECT MAX(order_nr) m FROM usr_ext_profile_page WHERE ".
                        " user_id = ".$ilDB->quote($a_user_id, "integer"));
                $rec = $ilDB->fetchAssoc($set);

                return (int) $rec["m"];
        }

        function create()
        {
                global $ilDB;

                $this->setOrderNr(ilExtPublicProfilePage::lookupMaxOrderNr($this->getUserId()) + 10);

                $id = $ilDB->nextId("usr_ext_profile_page");
                $this->setId($id);
                $query = "INSERT INTO usr_ext_profile_page (".
                        "id".
                        ", title".
                        ", user_id".
                        ", order_nr".
                        " ) VALUES (".
                        $ilDB->quote($this->getId(), "integer")
                        .",".$ilDB->quote($this->getTitle(), "text")
                        .",".$ilDB->quote($this->getUserId(), "integer")
                        .",".$ilDB->quote($this->getOrderNr(), "integer")
                        .")";
                $ilDB->manipulate($query);

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

        function update($a_validate = true, $a_no_history = false)
        {
                global $ilDB;
                
                // update wiki page data
                $query = "UPDATE usr_ext_profile_page SET ".
                        " title = ".$ilDB->quote($this->getTitle(), "text").
                        ",user_id = ".$ilDB->quote($this->getUserId(), "integer").
                        ",order_nr = ".$ilDB->quote($this->getOrderNr(), "integer").
                        " WHERE id = ".$ilDB->quote($this->getId(), "integer");
                $ilDB->manipulate($query);
                parent::update($a_validate, $a_no_history);

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

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


        function delete()
        {
                global $ilDB;
                
                // 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_ext_profile_page
                $query = "DELETE FROM usr_ext_profile_page".
                        " WHERE id = ".$ilDB->quote($this->getId(), "integer");
                $ilDB->manipulate($query);
                
                // delete co page
                parent::delete();

                return true;
        }


        static function lookupUserId($a_page_id)
        {
                global $ilDB;

                return ilExtPublicProfilePage::lookupProperty($a_page_id, "user_id");
        }

        static function lookupTitle($a_page_id)
        {
                global $ilDB;

                return ilExtPublicProfilePage::lookupProperty($a_page_id, "title");
        }

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

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

        static function getPagesOfUser($a_user_id)
        {
                global $ilDB;

                $set = $ilDB->query("SELECT * FROM usr_ext_profile_page WHERE ".
                        " user_id = ".$ilDB->quote($a_user_id, "integer").
                        " ORDER BY order_nr");
                $tabs = array();
                while ($rec = $ilDB->fetchAssoc($set))
                {
                        $tabs[] = $rec;
                }
                return $tabs;
        }

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

                $pages = self::getPagesOfUser($a_user_id);
                $cnt = 10;
                foreach ($pages as $p)
                {
                        $ilDB->manipulate("UPDATE usr_ext_profile_page SET ".
                                " order_nr = ".$ilDB->quote($cnt, "integer").
                                " WHERE id = ".$ilDB->quote($p["id"], "integer")
                        );
                        $cnt+= 10;
                }
        }
}
?>