wtrmln/modules/models/model_menuedit.php

   1 <?php
   2 /********************************************************************
   3
   4   Watermelon CMS
   5
   6 Copyright 2009 Radosław Pietruszewski
   7
   8 This program is free software; you can redistribute it and/or
   9 modify it under the terms of the GNU General Public License
  10 version 2 as published by the Free Software Foundation.
  11
  12 This program is distributed in the hope that it will be useful,
  13 but WITHOUT ANY WARRANTY; without even the implied warranty of
  14 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
  15 GNU General Public License for more details.
  16
  17 You should have received a copy of the GNU General Public License
  18 along with this program; if not, write to the Free Software
  19 Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
  20
  21 ********************************************************************/
  22
  23 class Model_MenuEdit extends Model
  24 {
  25    /*
  26     * public DBresult GetMenus()
  27     *
  28     * pobiera listę menu
  29     */
  30
  31    public function GetMenus()
  32    {
  33       return $this->db->query("SELECT * FROM `__menu` ORDER BY `position`, `id`");
  34    }
  35
  36    /*
  37     * public DBresult GetMenuData(uint $id)
  38     *
  39     * pobiera dane menu o id = $id
  40     */
  41
  42    public function GetMenuData($id)
  43    {
  44       $id = intval($id);
  45
  46       return $this->db->query("SELECT * FROM `__menu` WHERE `id` = '%1'", $id);
  47    }
  48
  49    /*
  50     * public void addMenu(string $name, string $condition, string $text)
  51     *
  52     * dodaje na koniec (ostatnia pozycja) menu o nazwie $name, z treścią
  53     * $text pod warunkiem $condition
  54     */
  55
  56    public function addMenu($name, $condition, $text)
  57    {
  58       $name = mysql_real_escape_string($name);
  59       $condition = mysql_real_escape_string($condition);
  60       $text = mysql_real_escape_string($text);
  61
  62       $position = Config::getConf('max_menu') + 5;
  63       Config::setConf('max_menu', $position);
  64
  65       $this->db->query("INSERT INTO `__menu` (`position`, `capt`, `content`, `condition`) VALUES ('%1', '%2', '%3', '%4')", $position, $name, $text, $condition);
  66    }
  67
  68    /*
  69     * public void Edit(string $name, string $condition, string $text, uint $menuID)
  70     *
  71     * Zmienia w menu o ID = $menuID nazwę na $name,
  72     * treść na $text i warunek $condition
  73     */
  74
  75    public function Edit($name, $condition, $text, $menuID)
  76    {
  77       $name = mysql_real_escape_string($name);
  78       $condition = mysql_real_escape_string($condition);
  79       $text = mysql_real_escape_string($text);
  80       $menuID = intval($menuID);
  81
  82       $this->db->query("UPDATE `__menu` SET `capt` = '%1', `content` = '%3', `condition` = '%2' WHERE `id` = '%4'", $name, $condition, $text, $menuID);
  83    }
  84
  85    /*
  86     * public void DeleteMenu(uint $id)
  87     *
  88     * usuwa menu o id = $id
  89     */
  90
  91    public function DeleteMenu($id)
  92    {
  93       $id = intval($id);
  94
  95       $this->db->query("DELETE FROM `__menu` WHERE `id` = '%1'", $id);
  96
  97       // uaktualniamy najwyższą pozycję w bazie danych
  98
  99       $lastPos = $this->db->query("SELECT `position` FROM `__menu` ORDER BY `position` DESC LIMIT 1", $id);
 100       $lastPos = $lastPos->to_obj()->position;
 101
 102       Config::setConf('max_menu', $lastPos);
 103    }
 104
 105    /*
 106     * public void SetMenuPosition(uint $id, uint $position)
 107     *
 108     * zmienia pozycję menu o id = $id na $position
 109     */
 110
 111    public function SetMenuPosition($id, $pos)
 112    {
 113       $id  = intval($id);
 114       $pos = intval($pos);
 115
 116       $this->db->query("UPDATE `__menu` SET `position` = '%2' WHERE `id` = '%1'", $id, $pos);
 117
 118       // uaktualniamy najwyższą pozycję w bazie danych
 119
 120       $lastPos = $this->db->query("SELECT `position` FROM `__menu` ORDER BY `position` DESC LIMIT 1", $id);
 121       $lastPos = $lastPos->to_obj()->position;
 122
 123       Config::setConf('max_menu', $lastPos);
 124    }
 125
 126    /*
 127     * public string[] GetPAMenus()
 128     *
 129     * Pobiera listę (w postaci tablicy) menu w PA.
 130     */
 131
 132    public function GetPAMenus()
 133    {
 134       $menus = Config::getConf('PA_menu');
 135
 136       return unserialize($menus);
 137    }
 138
 139    /*
 140     * public void UpdatePAMenus(string[] $menus)
 141     *
 142     * uaktualnia listę (tablicę) menu w PA.
 143     *
 144     * string[] $menus - lista menu panelu admina do uaktualnienia
 145     */
 146
 147    public function UpdatePAMenus(array $menus)
 148    {
 149       Config::setConf('PA_menu', serialize($menus));
 150    }
 151 }
 152 ?>