class.ilLMMenuEditor.php

Go to the documentation of this file.

<?php
/*
        +-----------------------------------------------------------------------------+
        | ILIAS open source                                                           |
        +-----------------------------------------------------------------------------+
        | Copyright (c) 1998-2009 ILIAS open source, University of Cologne            |
        |                                                                             |
        | This program is free software; you can redistribute it and/or               |
        | modify it under the terms of the GNU General Public License                 |
        | as published by the Free Software Foundation; either version 2              |
        | of the License, or (at your option) any later version.                      |
        |                                                                             |
        | This program is distributed in the hope that it will be useful,             |
        | but WITHOUT ANY WARRANTY; without even the implied warranty of              |
        | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the               |
        | GNU General Public License for more details.                                |
        |                                                                             |
        | You should have received a copy of the GNU General Public License           |
        | along with this program; if not, write to the Free Software                 |
        | Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA. |
        +-----------------------------------------------------------------------------+
*/

class ilLMMenuEditor
{
        function __construct()
        {
                global $ilDB;

                $this->db = $ilDB;
                $this->link_type = "extern";
                $this->link_ref_id = null;
        }

        function setObjId($a_obj_id)
        {
                $this->lm_id = $a_obj_id;
        }

        function getObjId()
        {
                return $this->lm_id;
        }

        function setEntryId($a_id)
        {
                $this->entry_id = $a_id;
        }

        function getEntryId()
        {
                return $this->entry_id;
        }

        function setLinkType($a_link_type)
        {
                $this->link_type = $a_link_type;        
        }
        
        function getLinkType()
        {
                return $this->link_type;
        }
        
        function setTitle($a_title)
        {
                $this->title = $a_title;        
        }

        function getTitle()
        {
                return $this->title;
        }
        
        function setTarget($a_target)
        {
                $this->target = $a_target;      
        }
        
        function getTarget()
        {
                return $this->target;
        }
        
        function setLinkRefId($a_link_ref_id)
        {
                $this->link_ref_id = $a_link_ref_id;
        }

        function getLinkRefId()
        {
                return $this->link_ref_id;
        }

        function create()
        {
                global $ilDB;
                
                $id = $ilDB->nextId("lm_menu");
                $q = "INSERT INTO lm_menu (id, lm_id,link_type,title,target,link_ref_id) ".
                         "VALUES ".
                         "(".
                         $ilDB->quote($id, "integer").",".
                         $ilDB->quote((int) $this->getObjId(), "integer").",".
                         $ilDB->quote($this->getLinkType(), "text").",".
                         $ilDB->quote($this->getTitle(), "text").",".
                         $ilDB->quote($this->getTarget(), "text").",".
                         $ilDB->quote((int) $this->getLinkRefId(), "integer").")";
                $r = $ilDB->manipulate($q);

                $this->entry_id = $id;

                return true;
        }
        
        function getMenuEntries($a_only_active = false)
        {
                global $ilDB;
                
                $entries = array();
                
                if ($a_only_active === true)
                {
                        $and = " AND active = ".$ilDB->quote("y", "text");
                }
                
                $q = "SELECT * FROM lm_menu ".
                         "WHERE lm_id = ".$ilDB->quote($this->lm_id, "integer").
                         $and;
                         
                $r = $ilDB->query($q);

                while($row = $ilDB->fetchObject($r))
                {
                        $entries[] = array('id'         => $row->id,
                                                           'title'      => $row->title,
                                                           'link'       => $row->target,
                                                           'type'       => $row->link_type,
                                                           'ref_id'     => $row->link_ref_id,
                                                           'active'     => $row->active
                                                           );
                }

                return $entries;
        }
        
        function delete($a_id)
        {
                global $ilDB;
                
                if (!$a_id)
                {
                        return false;
                }
                
                $q = "DELETE FROM lm_menu WHERE id = ".
                        $ilDB->quote($a_id, "integer");
                $ilDB->manipulate($q);
                
                return true;
        }
        
        function update()
        {
                global $ilDB;
                
                $q = "UPDATE lm_menu SET ".
                        " link_type = ".$ilDB->quote($this->getLinkType(), "text").",".
                        " title = ".$ilDB->quote($this->getTitle(), "text").",".
                        " target = ".$ilDB->quote($this->getTarget(), "text").",".
                        " link_ref_id = ".$ilDB->quote((int) $this->getLinkRefId(), "integer").
                        " WHERE id = ".$ilDB->quote($this->getEntryId(), "integer");
                $r = $ilDB->manipulate($q);
                
                return true;
        }
        
        function readEntry($a_id)
        {
                global $ilDB;
                
                if (!$a_id)
                {
                        return false;
                }
                
                $q = "SELECT * FROM lm_menu WHERE id = ".
                        $ilDB->quote($a_id, "integer");
                $r = $ilDB->query($q);

                $row = $ilDB->fetchObject($r);
                
                $this->setTitle($row->title);
                $this->setTarget($row->target);
                $this->setLinkType($row->link_type);
                $this->setLinkRefId($row->link_ref_id);
                $this->setEntryid($a_id);
        }
        
        function updateActiveStatus($a_entries)
        {
                global $ilDB;
                
                if (!is_array($a_entries))
                {
                        $q = "UPDATE lm_menu SET active = ".$ilDB->quote("n", "text").
                                " WHERE lm_id = ".$ilDB->quote($this->lm_id, "integer");
                }
                
                // update active status
                $q = "UPDATE lm_menu SET " .
                         "active = CASE " .
                         "WHEN ".$ilDB->in("id", $a_entries, false, "integer")." ".
                         "THEN ".$ilDB->quote("y", "text")." ".
                         "ELSE ".$ilDB->quote("n", "text")." ".
                         "END " .
                         "WHERE lm_id = ".$ilDB->quote($this->lm_id, "integer");

                $ilDB->manipulate($q);
        }

        static public function writeActive($entry_id, $active)
        {
                global $DIC;

                $db = $DIC->database();

                $db->update("lm_menu", array(
                                "active" => array("text", ($active ? "y" : "n"))
                        ), array(       // where
                                "id" => array("", $entry_id)
                        ));


        }
        
}
?>