source: trunk/admin/cat_list.php @ 9917

Last change on this file since 9917 was 8728, checked in by plg, 14 years ago

Happy new year 2011

Change "Piwigo - a PHP based picture gallery" into "Piwigo - a PHP based photo gallery"

  • Property svn:eol-style set to LF
File size: 9.6 KB
Line 
1<?php
2// +-----------------------------------------------------------------------+
3// | Piwigo - a PHP based photo gallery                                    |
4// +-----------------------------------------------------------------------+
5// | Copyright(C) 2008-2011 Piwigo Team                  http://piwigo.org |
6// | Copyright(C) 2003-2008 PhpWebGallery Team    http://phpwebgallery.net |
7// | Copyright(C) 2002-2003 Pierrick LE GALL   http://le-gall.net/pierrick |
8// +-----------------------------------------------------------------------+
9// | This program is free software; you can redistribute it and/or modify  |
10// | it under the terms of the GNU General Public License as published by  |
11// | the Free Software Foundation                                          |
12// |                                                                       |
13// | This program is distributed in the hope that it will be useful, but   |
14// | WITHOUT ANY WARRANTY; without even the implied warranty of            |
15// | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU      |
16// | General Public License for more details.                              |
17// |                                                                       |
18// | You should have received a copy of the GNU General Public License     |
19// | along with this program; if not, write to the Free Software           |
20// | Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, |
21// | USA.                                                                  |
22// +-----------------------------------------------------------------------+
23
24if (!defined('PHPWG_ROOT_PATH'))
25{
26  die('Hacking attempt!');
27}
28
29include_once(PHPWG_ROOT_PATH.'admin/include/functions.php');
30
31// +-----------------------------------------------------------------------+
32// | Check Access and exit when user status is not ok                      |
33// +-----------------------------------------------------------------------+
34check_status(ACCESS_ADMINISTRATOR);
35
36trigger_action('loc_begin_cat_list');
37
38if (!empty($_POST) or isset($_GET['delete']))
39{
40  check_pwg_token();
41}
42
43// +-----------------------------------------------------------------------+
44// |                               functions                               |
45// +-----------------------------------------------------------------------+
46
47/**
48 * save the rank depending on given categories order
49 *
50 * The list of ordered categories id is supposed to be in the same parent
51 * category
52 *
53 * @param array categories
54 * @return void
55 */
56function save_categories_order($categories)
57{
58  $current_rank_for_id_uppercat = array();
59  $current_rank = 0;
60 
61  $datas = array();
62  foreach ($categories as $category)
63  {
64    if (is_array($category))
65    {
66      $id = $category['id'];
67      $id_uppercat = $category['id_uppercat'];
68
69      if (!isset($current_rank_for_id_uppercat[$id_uppercat]))
70      {
71        $current_rank_for_id_uppercat[$id_uppercat] = 0;
72      }
73      $current_rank = ++$current_rank_for_id_uppercat[$id_uppercat];
74    }
75    else
76    {
77      $id = $category;
78      $current_rank++;
79    }
80   
81    array_push($datas, array('id' => $id, 'rank' => $current_rank));
82  }
83  $fields = array('primary' => array('id'), 'update' => array('rank'));
84  mass_updates(CATEGORIES_TABLE, $fields, $datas);
85
86  update_global_rank();
87}
88
89// +-----------------------------------------------------------------------+
90// |                            initialization                             |
91// +-----------------------------------------------------------------------+
92
93check_input_parameter('parent_id', $_GET, false, PATTERN_ID);
94
95$categories = array();
96
97$base_url = get_root_url().'admin.php?page=cat_list';
98$navigation = '<a href="'.$base_url.'">';
99$navigation.= l10n('Home');
100$navigation.= '</a>';
101
102// +-----------------------------------------------------------------------+
103// |                    virtual categories management                      |
104// +-----------------------------------------------------------------------+
105// request to delete a virtual category
106if (isset($_GET['delete']) and is_numeric($_GET['delete']))
107{
108  delete_categories(array($_GET['delete']));
109  $_SESSION['page_infos'] = array(l10n('Virtual album deleted'));
110  update_global_rank();
111
112  $redirect_url = get_root_url().'admin.php?page=cat_list';
113  if (isset($_GET['parent_id']))
114  {
115    $redirect_url.= '&parent_id='.$_GET['parent_id'];
116  } 
117  redirect($redirect_url);
118}
119// request to add a virtual category
120else if (isset($_POST['submitAdd']))
121{
122  $output_create = create_virtual_category(
123    $_POST['virtual_name'],
124    @$_GET['parent_id']
125    );
126
127  if (isset($output_create['error']))
128  {
129    array_push($page['errors'], $output_create['error']);
130  }
131  else
132  {
133    array_push($page['infos'], $output_create['info']);
134  }
135}
136// save manual category ordering
137else if (isset($_POST['submitOrder']))
138{
139  if ('manual' == $_POST['order_type'])
140  {
141    asort($_POST['catOrd'], SORT_NUMERIC);
142    save_categories_order(array_keys($_POST['catOrd']));
143
144    array_push(
145      $page['infos'],
146      l10n('Album manual order was saved')
147      );
148  }
149  else
150  {
151    $query = '
152SELECT id
153  FROM '.CATEGORIES_TABLE.'
154  WHERE id_uppercat '.
155    (!isset($_GET['parent_id']) ? 'IS NULL' : '= '.$_GET['parent_id']).'
156;';
157    $category_ids = array_from_query($query, 'id');
158
159    if (isset($_POST['recursive']))
160    {
161      $category_ids = get_subcat_ids($category_ids);
162    }
163
164    $categories = array();
165    $names = array();
166    $id_uppercats = array();
167 
168    $query = '
169SELECT id, name, id_uppercat
170  FROM '.CATEGORIES_TABLE.'
171  WHERE id IN ('.implode(',', $category_ids).')
172;';
173    $result = pwg_query($query);
174    while ($row = pwg_db_fetch_assoc($result))
175    {
176      array_push(
177        $categories,
178        array(
179          'id' => $row['id'],
180          'id_uppercat' => $row['id_uppercat'],
181          )
182        );
183      array_push(
184        $names,
185        $row['name']
186        );
187    }
188
189    array_multisort(
190      $names,
191      SORT_REGULAR,
192      'asc' == $_POST['ascdesc'] ? SORT_ASC : SORT_DESC,
193      $categories
194      );
195    save_categories_order($categories);
196
197    array_push(
198      $page['infos'],
199      l10n('Albums automatically sorted')
200      );
201  }
202}
203
204// +-----------------------------------------------------------------------+
205// |                            Navigation path                            |
206// +-----------------------------------------------------------------------+
207
208if (isset($_GET['parent_id']))
209{
210  $navigation.= $conf['level_separator'];
211
212  $navigation.= get_cat_display_name_from_id(
213    $_GET['parent_id'],
214    $base_url.'&amp;parent_id=',
215    false
216    );
217}
218// +-----------------------------------------------------------------------+
219// |                       template initialization                         |
220// +-----------------------------------------------------------------------+
221$template->set_filename('categories', 'cat_list.tpl');
222
223$form_action = PHPWG_ROOT_PATH.'admin.php?page=cat_list';
224if (isset($_GET['parent_id']))
225{
226  $form_action.= '&amp;parent_id='.$_GET['parent_id'];
227}
228
229$template->assign(array(
230  'CATEGORIES_NAV'=>$navigation,
231  'F_ACTION'=>$form_action,
232  'PWG_TOKEN' => get_pwg_token(),
233 ));
234
235// +-----------------------------------------------------------------------+
236// |                          Categories display                           |
237// +-----------------------------------------------------------------------+
238
239$categories = array();
240
241$query = '
242SELECT id, name, permalink, dir, rank, status
243  FROM '.CATEGORIES_TABLE;
244if (!isset($_GET['parent_id']))
245{
246  $query.= '
247  WHERE id_uppercat IS NULL';
248}
249else
250{
251  $query.= '
252  WHERE id_uppercat = '.$_GET['parent_id'];
253}
254$query.= '
255  ORDER BY rank ASC
256;';
257$categories = hash_from_query($query, 'id');
258
259// get the categories containing images directly
260$categories_with_images = array();
261if ( count($categories) )
262{
263  $query = '
264SELECT DISTINCT category_id
265  FROM '.IMAGE_CATEGORY_TABLE.'
266  WHERE category_id IN ('.implode(',', array_keys($categories)).')';
267  $categories_with_images = array_flip( array_from_query($query, 'category_id') );
268}
269
270$template->assign('categories', array());
271$base_url = get_root_url().'admin.php?page=';
272foreach ($categories as $category)
273{
274  $cat_list_url = $base_url.'cat_list';
275
276  $self_url = $cat_list_url;
277  if (isset($_GET['parent_id']))
278  {
279    $self_url.= '&amp;parent_id='.$_GET['parent_id'];
280  }
281
282  $tpl_cat =
283    array(
284      'NAME'       => 
285        trigger_event(
286          'render_category_name',
287          $category['name'],
288          'admin_cat_list'
289          ),
290      'ID'         => $category['id'],
291      'RANK'       => $category['rank']*10,
292
293      'U_JUMPTO'   => make_index_url(
294        array(
295          'category' => $category
296          )
297        ),
298
299      'U_CHILDREN' => $cat_list_url.'&amp;parent_id='.$category['id'],
300      'U_EDIT'     => $base_url.'cat_modify&amp;cat_id='.$category['id'],
301
302      'IS_VIRTUAL' => empty($category['dir'])
303    );
304
305  if (empty($category['dir']))
306  {
307    $tpl_cat['U_DELETE'] = $self_url.'&amp;delete='.$category['id'];
308    $tpl_cat['U_DELETE'].= '&amp;pwg_token='.get_pwg_token();
309  }
310
311  if ( array_key_exists($category['id'], $categories_with_images) )
312  {
313    $tpl_cat['U_MANAGE_ELEMENTS']=
314      $base_url.'batch_manager&amp;cat='.$category['id'];
315  }
316
317  if ('private' == $category['status'])
318  {
319    $tpl_cat['U_MANAGE_PERMISSIONS']=
320      $base_url.'cat_perm&amp;cat='.$category['id'];
321  }
322  $template->append('categories', $tpl_cat);
323}
324
325trigger_action('loc_end_cat_list');
326
327// +-----------------------------------------------------------------------+
328// |                          sending html code                            |
329// +-----------------------------------------------------------------------+
330$template->assign_var_from_handle('ADMIN_CONTENT', 'categories');
331?>
Note: See TracBrowser for help on using the repository browser.