1 <?php
  2 /**
  3  * @package     Joomla.Platform
  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
  8  */
  9 
 10 defined('JPATH_PLATFORM') or die;
 11 
 12 /**
 13  * Usergroup table class.
 14  *
 15  * @since  11.1
 16  */
 17 class JTableUsergroup extends JTable
 18 {
 19     /**
 20      * Constructor
 21      *
 22      * @param   JDatabaseDriver  $db  Database driver object.
 23      *
 24      * @since   11.1
 25      */
 26     public function __construct($db)
 27     {
 28         parent::__construct('#__usergroups', 'id', $db);
 29     }
 30 
 31     /**
 32      * Method to check the current record to save
 33      *
 34      * @return  boolean  True on success
 35      *
 36      * @since   11.1
 37      */
 38     public function check()
 39     {
 40         // Validate the title.
 41         if ((trim($this->title)) == '')
 42         {
 43             $this->setError(JText::_('JLIB_DATABASE_ERROR_USERGROUP_TITLE'));
 44 
 45             return false;
 46         }
 47 
 48         // Check for a duplicate parent_id, title.
 49         // There is a unique index on the (parent_id, title) field in the table.
 50         $db = $this->_db;
 51         $query = $db->getQuery(true)
 52             ->select('COUNT(title)')
 53             ->from($this->_tbl)
 54             ->where('title = ' . $db->quote(trim($this->title)))
 55             ->where('parent_id = ' . (int) $this->parent_id)
 56             ->where('id <> ' . (int) $this->id);
 57         $db->setQuery($query);
 58 
 59         if ($db->loadResult() > 0)
 60         {
 61             $this->setError(JText::_('JLIB_DATABASE_ERROR_USERGROUP_TITLE_EXISTS'));
 62 
 63             return false;
 64         }
 65 
 66         return true;
 67     }
 68 
 69     /**
 70      * Method to recursively rebuild the nested set tree.
 71      *
 72      * @param   integer  $parent_id  The root of the tree to rebuild.
 73      * @param   integer  $left       The left id to start with in building the tree.
 74      *
 75      * @return  boolean  True on success
 76      *
 77      * @since   11.1
 78      */
 79     public function rebuild($parent_id = 0, $left = 0)
 80     {
 81         // Get the database object
 82         $db = $this->_db;
 83 
 84         // Get all children of this node
 85         $db->setQuery('SELECT id FROM ' . $this->_tbl . ' WHERE parent_id=' . (int) $parent_id . ' ORDER BY parent_id, title');
 86         $children = $db->loadColumn();
 87 
 88         // The right value of this node is the left value + 1
 89         $right = $left + 1;
 90 
 91         // Execute this function recursively over all children
 92         for ($i = 0, $n = count($children); $i < $n; $i++)
 93         {
 94             // $right is the current right value, which is incremented on recursion return
 95             $right = $this->rebuild($children[$i], $right);
 96 
 97             // If there is an update failure, return false to break out of the recursion
 98             if ($right === false)
 99             {
100                 return false;
101             }
102         }
103 
104         // We've got the left value, and now that we've processed
105         // the children of this node we also know the right value
106         $db->setQuery('UPDATE ' . $this->_tbl . ' SET lft=' . (int) $left . ', rgt=' . (int) $right . ' WHERE id=' . (int) $parent_id);
107 
108         // If there is an update failure, return false to break out of the recursion
109         try
110         {
111             $db->execute();
112         }
113         catch (JDatabaseExceptionExecuting $e)
114         {
115             return false;
116         }
117 
118         // Return the right value of this node + 1
119         return $right + 1;
120     }
121 
122     /**
123      * Inserts a new row if id is zero or updates an existing row in the database table
124      *
125      * @param   boolean  $updateNulls  If false, null object variables are not updated
126      *
127      * @return  boolean  True if successful, false otherwise and an internal error message is set
128      *
129      * @since   11.1
130      */
131     public function store($updateNulls = false)
132     {
133         if ($result = parent::store($updateNulls))
134         {
135             // Rebuild the nested set tree.
136             $this->rebuild();
137         }
138 
139         return $result;
140     }
141 
142     /**
143      * Delete this object and its dependencies
144      *
145      * @param   integer  $oid  The primary key of the user group to delete.
146      *
147      * @return  mixed  Boolean or Exception.
148      *
149      * @since   11.1
150      * @throws  RuntimeException on database error.
151      * @throws  UnexpectedValueException on data error.
152      */
153     public function delete($oid = null)
154     {
155         if ($oid)
156         {
157             $this->load($oid);
158         }
159 
160         if ($this->id == 0)
161         {
162             throw new UnexpectedValueException('Global Category not found');
163         }
164 
165         if ($this->parent_id == 0)
166         {
167             throw new UnexpectedValueException('Root categories cannot be deleted.');
168         }
169 
170         if ($this->lft == 0 || $this->rgt == 0)
171         {
172             throw new UnexpectedValueException('Left-Right data inconsistency. Cannot delete usergroup.');
173         }
174 
175         $db = $this->_db;
176 
177         // Select the usergroup ID and its children
178         $query = $db->getQuery(true)
179             ->select($db->quoteName('c.id'))
180             ->from($db->quoteName($this->_tbl) . 'AS c')
181             ->where($db->quoteName('c.lft') . ' >= ' . (int) $this->lft)
182             ->where($db->quoteName('c.rgt') . ' <= ' . (int) $this->rgt);
183         $db->setQuery($query);
184         $ids = $db->loadColumn();
185 
186         if (empty($ids))
187         {
188             throw new UnexpectedValueException('Left-Right data inconsistency. Cannot delete usergroup.');
189         }
190 
191         // Delete the category dependencies
192         // @todo Remove all related threads, posts and subscriptions
193 
194         // Delete the usergroup and its children
195         $query->clear()
196             ->delete($db->quoteName($this->_tbl))
197             ->where($db->quoteName('id') . ' IN (' . implode(',', $ids) . ')');
198         $db->setQuery($query);
199         $db->execute();
200 
201         // Delete the usergroup in view levels
202         $replace = array();
203 
204         foreach ($ids as $id)
205         {
206             $replace[] = ',' . $db->quote("[$id,") . ',' . $db->quote('[') . ')';
207             $replace[] = ',' . $db->quote(",$id,") . ',' . $db->quote(',') . ')';
208             $replace[] = ',' . $db->quote(",$id]") . ',' . $db->quote(']') . ')';
209             $replace[] = ',' . $db->quote("[$id]") . ',' . $db->quote('[]') . ')';
210         }
211 
212         $query->clear()
213             ->select('id, rules')
214             ->from('#__viewlevels');
215         $db->setQuery($query);
216         $rules = $db->loadObjectList();
217 
218         $match_ids = array();
219 
220         foreach ($rules as $rule)
221         {
222             foreach ($ids as $id)
223             {
224                 if (strstr($rule->rules, '[' . $id) || strstr($rule->rules, ',' . $id) || strstr($rule->rules, $id . ']'))
225                 {
226                     $match_ids[] = $rule->id;
227                 }
228             }
229         }
230 
231         if (!empty($match_ids))
232         {
233             $query->clear()
234                 ->set('rules=' . str_repeat('replace(', 4 * count($ids)) . 'rules' . implode('', $replace))
235                 ->update('#__viewlevels')
236                 ->where('id IN (' . implode(',', $match_ids) . ')');
237             $db->setQuery($query);
238             $db->execute();
239         }
240 
241         // Delete the user to usergroup mappings for the group(s) from the database.
242         $query->clear()
243             ->delete($db->quoteName('#__user_usergroup_map'))
244             ->where($db->quoteName('group_id') . ' IN (' . implode(',', $ids) . ')');
245         $db->setQuery($query);
246         $db->execute();
247 
248         return true;
249     }
250 }
251 

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.