File odules/menus/class/menu.php

 1: <?php
 2: /*
 3:  You may not change or alter any portion of this comment or credits
 4:  of supporting developers from this source code or any supporting source code
 5:  which is considered copyrighted (c) material of the original comment or credit authors.
 6: 
 7:  This program is distributed in the hope that it will be useful,
 8:  but WITHOUT ANY WARRANTY; without even the implied warranty of
 9:  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
10:  */
11: 
12: use Xoops\Core\Database\Connection;
13: use Xoops\Core\FixedGroups;
14: use Xoops\Core\Kernel\XoopsObject;
15: use Xoops\Core\Kernel\XoopsPersistableObjectHandler;
16: 
17: /**
18:  * @copyright       XOOPS Project (http://xoops.org)
19:  * @license         GNU GPL 2 or later (http://www.gnu.org/licenses/gpl-2.0.html)
20:  * @package         Menus
21:  * @since           1.0
22:  * @author          trabis <lusopoemas@gmail.com>
23:  * @version         $Id$
24:  */
25: 
26: class MenusMenu extends XoopsObject
27: {
28:     /**
29:      * constructor
30:      */
31:     public function __construct()
32:     {
33:         $this->initVar('id', XOBJ_DTYPE_INT);
34:         $this->initVar('pid', XOBJ_DTYPE_INT);
35:         $this->initVar('mid', XOBJ_DTYPE_INT);
36:         $this->initVar('title', XOBJ_DTYPE_TXTBOX, '');
37:         $this->initVar('alt_title', XOBJ_DTYPE_TXTBOX, '');
38:         $this->initVar('visible', XOBJ_DTYPE_INT, 1);
39:         $this->initVar('link', XOBJ_DTYPE_TXTBOX);
40:         $this->initVar('weight', XOBJ_DTYPE_INT, 255);
41:         $this->initVar('target', XOBJ_DTYPE_TXTBOX, '_self');
42:         $this->initVar('groups', XOBJ_DTYPE_ARRAY, serialize(array(FixedGroups::ANONYMOUS, FixedGroups::USERS)));
43:         $this->initVar('hooks', XOBJ_DTYPE_ARRAY, serialize(array()));
44:         $this->initVar('image', XOBJ_DTYPE_TXTBOX);
45:         $this->initVar('css', XOBJ_DTYPE_TXTBOX);
46:     }
47: }
48: 
49: class MenusMenuHandler extends XoopsPersistableObjectHandler
50: {
51:     /**
52:      * @param Connection $db
53:      */
54:     public function __construct(Connection $db = null)
55:     {
56:         parent::__construct($db, 'menus_menu', 'MenusMenu', 'id', 'title');
57:     }
58: 
59:     /**
60:      * @param MenusMenu $obj
61:      */
62:     public function update_weights(MenusMenu $obj)
63:     {
64:         $sql = "UPDATE " . $this->table
65:         . " SET weight = weight+1"
66:         . " WHERE weight >= " . $obj->getVar('weight')
67:         . " AND id <> " . $obj->getVar('id')
68:         /*. " AND pid = " . $obj->getVar('pid')*/
69:         . " AND mid = " . $obj->getVar('mid')
70:         ;
71:         $this->db->queryF($sql);
72: 
73:         $sql = "SELECT id FROM " . $this->table
74:         . " WHERE mid = " . $obj->getVar('mid')
75:         /*. " AND pid = " . $obj->getVar('pid')*/
76:         . " ORDER BY weight ASC"
77:         ;
78:         $result = $this->db->query($sql);
79:         $i = 1;  //lets start at 1 please!
80:         while (list($id) = $this->db->fetchRow($result)) {
81:             $sql = "UPDATE " . $this->table
82:             . " SET weight = {$i}"
83:             . " WHERE id = {$id}"
84:             ;
85:             $this->db->queryF($sql);
86:             ++$i;
87:         }
88:     }
89: }
90:
Namespaces

Classes

Interfaces

Exceptions

Functions
