1 <?php
  2 /**
  3  * @package     Joomla.Legacy
  4  * @subpackage  Table
  5  *
  6  * @copyright   Copyright (C) 2005 - 2017 Open Source Matters, Inc. All rights reserved.
  7  * @license     GNU General Public License version 2 or later; see LICENSE.txt
  8  */
  9 
 10 defined('JPATH_PLATFORM') or die;
 11 
 12 /**
 13  * Menu Types table
 14  *
 15  * @since  1.6
 16  */
 17 class JTableMenuType extends JTable
 18 {
 19     /**
 20      * Constructor
 21      *
 22      * @param   JDatabaseDriver  $db  Database driver object.
 23      *
 24      * @since   1.6
 25      */
 26     public function __construct(JDatabaseDriver $db)
 27     {
 28         parent::__construct('#__menu_types', 'id', $db);
 29     }
 30 
 31     /**
 32      * Overloaded check function
 33      *
 34      * @return  boolean  True on success, false on failure
 35      *
 36      * @see     JTable::check()
 37      * @since   1.6
 38      */
 39     public function check()
 40     {
 41         $this->menutype = JApplicationHelper::stringURLSafe($this->menutype);
 42 
 43         if (empty($this->menutype))
 44         {
 45             $this->setError(JText::_('JLIB_DATABASE_ERROR_MENUTYPE_EMPTY'));
 46 
 47             return false;
 48         }
 49 
 50         // Sanitise data.
 51         if (trim($this->title) == '')
 52         {
 53             $this->title = $this->menutype;
 54         }
 55 
 56         // Check for unique menutype.
 57         $query = $this->_db->getQuery(true)
 58             ->select('COUNT(id)')
 59             ->from($this->_db->quoteName('#__menu_types'))
 60             ->where($this->_db->quoteName('menutype') . ' = ' . $this->_db->quote($this->menutype))
 61             ->where($this->_db->quoteName('id') . ' <> ' . (int) $this->id);
 62         $this->_db->setQuery($query);
 63 
 64         if ($this->_db->loadResult())
 65         {
 66             $this->setError(JText::sprintf('JLIB_DATABASE_ERROR_MENUTYPE_EXISTS', $this->menutype));
 67 
 68             return false;
 69         }
 70 
 71         return true;
 72     }
 73 
 74     /**
 75      * Method to store a row in the database from the JTable instance properties.
 76      *
 77      * If a primary key value is set the row with that primary key value will be updated with the instance property values.
 78      * If no primary key value is set a new row will be inserted into the database with the properties from the JTable instance.
 79      *
 80      * @param   boolean  $updateNulls  True to update fields even if they are null.
 81      *
 82      * @return  boolean  True on success.
 83      *
 84      * @since   1.6
 85      */
 86     public function store($updateNulls = false)
 87     {
 88         if ($this->id)
 89         {
 90             // Get the user id
 91             $userId = JFactory::getUser()->id;
 92 
 93             // Get the old value of the table
 94             $table = JTable::getInstance('Menutype', 'JTable', array('dbo' => $this->getDbo()));
 95             $table->load($this->id);
 96 
 97             // Verify that no items are checked out
 98             $query = $this->_db->getQuery(true)
 99                 ->select('id')
100                 ->from('#__menu')
101                 ->where('menutype=' . $this->_db->quote($table->menutype))
102                 ->where('checked_out !=' . (int) $userId)
103                 ->where('checked_out !=0');
104             $this->_db->setQuery($query);
105 
106             if ($this->_db->loadRowList())
107             {
108                 $this->setError(
109                     JText::sprintf('JLIB_DATABASE_ERROR_STORE_FAILED', get_class($this), JText::_('JLIB_DATABASE_ERROR_MENUTYPE_CHECKOUT'))
110                 );
111 
112                 return false;
113             }
114 
115             // Verify that no module for this menu are checked out
116             $query->clear()
117                 ->select('id')
118                 ->from('#__modules')
119                 ->where('module=' . $this->_db->quote('mod_menu'))
120                 ->where('params LIKE ' . $this->_db->quote('%"menutype":' . json_encode($table->menutype) . '%'))
121                 ->where('checked_out !=' . (int) $userId)
122                 ->where('checked_out !=0');
123             $this->_db->setQuery($query);
124 
125             if ($this->_db->loadRowList())
126             {
127                 $this->setError(
128                     JText::sprintf('JLIB_DATABASE_ERROR_STORE_FAILED', get_class($this), JText::_('JLIB_DATABASE_ERROR_MENUTYPE_CHECKOUT'))
129                 );
130 
131                 return false;
132             }
133 
134             // Update the menu items
135             $query->clear()
136                 ->update('#__menu')
137                 ->set('menutype=' . $this->_db->quote($this->menutype))
138                 ->where('menutype=' . $this->_db->quote($table->menutype));
139             $this->_db->setQuery($query);
140             $this->_db->execute();
141 
142             // Update the module items
143             $query->clear()
144                 ->update('#__modules')
145                 ->set(
146                 'params=REPLACE(params,' . $this->_db->quote('"menutype":' . json_encode($table->menutype)) . ',' .
147                 $this->_db->quote('"menutype":' . json_encode($this->menutype)) . ')'
148             );
149             $query->where('module=' . $this->_db->quote('mod_menu'))
150                 ->where('params LIKE ' . $this->_db->quote('%"menutype":' . json_encode($table->menutype) . '%'));
151             $this->_db->setQuery($query);
152             $this->_db->execute();
153         }
154 
155         return parent::store($updateNulls);
156     }
157 
158     /**
159      * Method to delete a row from the database table by primary key value.
160      *
161      * @param   mixed  $pk  An optional primary key value to delete.  If not set the instance property value is used.
162      *
163      * @return  boolean  True on success.
164      *
165      * @since   1.6
166      */
167     public function delete($pk = null)
168     {
169         $k = $this->_tbl_key;
170         $pk = is_null($pk) ? $this->$k : $pk;
171 
172         // If no primary key is given, return false.
173         if ($pk !== null)
174         {
175             // Get the user id
176             $userId = JFactory::getUser()->id;
177 
178             // Get the old value of the table
179             $table = JTable::getInstance('Menutype', 'JTable', array('dbo' => $this->getDbo()));
180             $table->load($pk);
181 
182             // Verify that no items are checked out
183             $query = $this->_db->getQuery(true)
184                 ->select('id')
185                 ->from('#__menu')
186                 ->where('menutype=' . $this->_db->quote($table->menutype))
187                 ->where('(checked_out NOT IN (0,' . (int) $userId . ') OR home=1 AND language=' . $this->_db->quote('*') . ')');
188             $this->_db->setQuery($query);
189 
190             if ($this->_db->loadRowList())
191             {
192                 $this->setError(JText::sprintf('JLIB_DATABASE_ERROR_DELETE_FAILED', get_class($this), JText::_('JLIB_DATABASE_ERROR_MENUTYPE')));
193 
194                 return false;
195             }
196 
197             // Verify that no module for this menu are checked out
198             $query->clear()
199                 ->select('id')
200                 ->from('#__modules')
201                 ->where('module=' . $this->_db->quote('mod_menu'))
202                 ->where('params LIKE ' . $this->_db->quote('%"menutype":' . json_encode($table->menutype) . '%'))
203                 ->where('checked_out !=' . (int) $userId)
204                 ->where('checked_out !=0');
205             $this->_db->setQuery($query);
206 
207             if ($this->_db->loadRowList())
208             {
209                 $this->setError(JText::sprintf('JLIB_DATABASE_ERROR_DELETE_FAILED', get_class($this), JText::_('JLIB_DATABASE_ERROR_MENUTYPE')));
210 
211                 return false;
212             }
213 
214             // Delete the menu items
215             $query->clear()
216                 ->delete('#__menu')
217                 ->where('menutype=' . $this->_db->quote($table->menutype));
218             $this->_db->setQuery($query);
219             $this->_db->execute();
220 
221             // Update the module items
222             $query->clear()
223                 ->delete('#__modules')
224                 ->where('module=' . $this->_db->quote('mod_menu'))
225                 ->where('params LIKE ' . $this->_db->quote('%"menutype":' . json_encode($table->menutype) . '%'));
226             $this->_db->setQuery($query);
227             $this->_db->execute();
228         }
229 
230         return parent::delete($pk);
231     }
232 
233     /**
234      * Method to compute the default name of the asset.
235      * The default name is in the form table_name.id
236      * where id is the value of the primary key of the table.
237      *
238      * @return  string
239      *
240      * @since   3.6
241      */
242     protected function _getAssetName()
243     {
244         return 'com_menus.menu.' . $this->id;
245     }
246 
247     /**
248      * Method to return the title to use for the asset table.
249      *
250      * @return  string
251      *
252      * @since   3.6
253      */
254     protected function _getAssetTitle()
255     {
256         return $this->title;
257     }
258 
259     /**
260      * Method to get the parent asset under which to register this one.
261      * By default, all assets are registered to the ROOT node with ID,
262      * which will default to 1 if none exists.
263      * The extended class can define a table and id to lookup.  If the
264      * asset does not exist it will be created.
265      *
266      * @param   JTable   $table  A JTable object for the asset parent.
267      * @param   integer  $id     Id to look up
268      *
269      * @return  integer
270      *
271      * @since   3.6
272      */
273     protected function _getAssetParentId(JTable $table = null, $id = null)
274     {
275         $assetId = null;
276         $asset = JTable::getInstance('asset');
277 
278         if ($asset->loadByName('com_menus'))
279         {
280             $assetId = $asset->id;
281         }
282 
283         return is_null($assetId) ? parent::_getAssetParentId($table, $id) : $assetId;
284     }
285 }
286 

Joomla! Framework TM API documentation generated by ApiGen 2.8.0
Joomla!® and Joomla! Framework™ are trademarks of Open Source Matters, Inc. in the United States and other countries.