<?php // +-----------------------------------------------------------------------+ // | Piwigo - a PHP based photo gallery | // +-----------------------------------------------------------------------+ // | Copyright(C) 2008-2013 Piwigo Team http://piwigo.org | // | Copyright(C) 2003-2008 PhpWebGallery Team http://phpwebgallery.net | // | Copyright(C) 2002-2003 Pierrick LE GALL http://le-gall.net/pierrick | // +-----------------------------------------------------------------------+ // | This program is free software; you can redistribute it and/or modify | // | it under the terms of the GNU General Public License as published by | // | the Free Software Foundation | // | | // | This program is distributed in the hope that it will be useful, but | // | WITHOUT ANY WARRANTY; without even the implied warranty of | // | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU | // | General Public License for more details. | // | | // | You should have received a copy of the GNU General Public License | // | along with this program; if not, write to the Free Software | // | Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, | // | USA. | // +-----------------------------------------------------------------------+ if (!defined('PHPWG_ROOT_PATH')) { die('Hacking attempt!'); } include_once(PHPWG_ROOT_PATH.'admin/include/functions.php'); // +-----------------------------------------------------------------------+ // | Check Access and exit when user status is not ok | // +-----------------------------------------------------------------------+ check_status(ACCESS_ADMINISTRATOR); trigger_action('loc_begin_cat_list'); if (!empty($_POST) or isset($_GET['delete'])) { check_pwg_token(); } // +-----------------------------------------------------------------------+ // | functions | // +-----------------------------------------------------------------------+ /** * save the rank depending on given categories order * * The list of ordered categories id is supposed to be in the same parent * category * * @param array categories * @return void */ function save_categories_order($categories) { $current_rank_for_id_uppercat = array(); $current_rank = 0; $datas = array(); foreach ($categories as $category) { if (is_array($category)) { $id = $category['id']; $id_uppercat = $category['id_uppercat']; if (!isset($current_rank_for_id_uppercat[$id_uppercat])) { $current_rank_for_id_uppercat[$id_uppercat] = 0; } $current_rank = ++$current_rank_for_id_uppercat[$id_uppercat]; } else { $id = $category; $current_rank++; } array_push($datas, array('id' => $id, 'rank' => $current_rank)); } $fields = array('primary' => array('id'), 'update' => array('rank')); mass_updates(CATEGORIES_TABLE, $fields, $datas); update_global_rank(); } // +-----------------------------------------------------------------------+ // | initialization | // +-----------------------------------------------------------------------+ check_input_parameter('parent_id', $_GET, false, PATTERN_ID); $categories = array(); $base_url = get_root_url().'admin.php?page=cat_list'; $navigation = '<a href="'.$base_url.'">'; $navigation.= l10n('Home'); $navigation.= '</a>'; // +-----------------------------------------------------------------------+ // | tabs | // +-----------------------------------------------------------------------+ $page['tab'] = 'list'; include(PHPWG_ROOT_PATH.'admin/include/albums_tab.inc.php'); // +-----------------------------------------------------------------------+ // | virtual categories management | // +-----------------------------------------------------------------------+ // request to delete a virtual category if (isset($_GET['delete']) and is_numeric($_GET['delete'])) { delete_categories(array($_GET['delete'])); $_SESSION['page_infos'] = array(l10n('Virtual album deleted')); update_global_rank(); $redirect_url = get_root_url().'admin.php?page=cat_list'; if (isset($_GET['parent_id'])) { $redirect_url.= '&parent_id='.$_GET['parent_id']; } redirect($redirect_url); } // request to add a virtual category else if (isset($_POST['submitAdd'])) { $output_create = create_virtual_category( $_POST['virtual_name'], @$_GET['parent_id'] ); if (isset($output_create['error'])) { array_push($page['errors'], $output_create['error']); } else { array_push($page['infos'], $output_create['info']); } } // save manual category ordering else if (isset($_POST['submitManualOrder'])) { asort($_POST['catOrd'], SORT_NUMERIC); save_categories_order(array_keys($_POST['catOrd'])); array_push( $page['infos'], l10n('Album manual order was saved') ); } else if (isset($_POST['submitAutoOrder'])) { $query = ' SELECT id FROM '.CATEGORIES_TABLE.' WHERE id_uppercat '. (!isset($_GET['parent_id']) ? 'IS NULL' : '= '.$_GET['parent_id']).' ;'; $category_ids = array_from_query($query, 'id'); if (isset($_POST['recursive'])) { $category_ids = get_subcat_ids($category_ids); } $categories = array(); $names = array(); $id_uppercats = array(); $query = ' SELECT id, name, id_uppercat FROM '.CATEGORIES_TABLE.' WHERE id IN ('.implode(',', $category_ids).') ;'; $result = pwg_query($query); while ($row = pwg_db_fetch_assoc($result)) { array_push( $categories, array( 'id' => $row['id'], 'id_uppercat' => $row['id_uppercat'], ) ); array_push( $names, $row['name'] ); } array_multisort( $names, SORT_REGULAR, 'asc' == $_POST['ascdesc'] ? SORT_ASC : SORT_DESC, $categories ); save_categories_order($categories); array_push( $page['infos'], l10n('Albums automatically sorted') ); } // +-----------------------------------------------------------------------+ // | Navigation path | // +-----------------------------------------------------------------------+ if (isset($_GET['parent_id'])) { $navigation.= $conf['level_separator']; $navigation.= get_cat_display_name_from_id( $_GET['parent_id'], $base_url.'&parent_id=', false ); } // +-----------------------------------------------------------------------+ // | template initialization | // +-----------------------------------------------------------------------+ $template->set_filename('categories', 'cat_list.tpl'); $form_action = PHPWG_ROOT_PATH.'admin.php?page=cat_list'; if (isset($_GET['parent_id'])) { $form_action.= '&parent_id='.$_GET['parent_id']; } $template->assign(array( 'CATEGORIES_NAV'=>$navigation, 'F_ACTION'=>$form_action, 'PWG_TOKEN' => get_pwg_token(), )); // +-----------------------------------------------------------------------+ // | Categories display | // +-----------------------------------------------------------------------+ $categories = array(); $query = ' SELECT id, name, permalink, dir, rank, status FROM '.CATEGORIES_TABLE; if (!isset($_GET['parent_id'])) { $query.= ' WHERE id_uppercat IS NULL'; } else { $query.= ' WHERE id_uppercat = '.$_GET['parent_id']; } $query.= ' ORDER BY rank ASC ;'; $categories = hash_from_query($query, 'id'); // get the categories containing images directly $categories_with_images = array(); if ( count($categories) ) { $query = ' SELECT DISTINCT category_id FROM '.IMAGE_CATEGORY_TABLE.' WHERE category_id IN ('.implode(',', array_keys($categories)).')'; $categories_with_images = array_flip( array_from_query($query, 'category_id') ); } $template->assign('categories', array()); $base_url = get_root_url().'admin.php?page='; foreach ($categories as $category) { $cat_list_url = $base_url.'cat_list'; $self_url = $cat_list_url; if (isset($_GET['parent_id'])) { $self_url.= '&parent_id='.$_GET['parent_id']; } $tpl_cat = array( 'NAME' => trigger_event( 'render_category_name', $category['name'], 'admin_cat_list' ), 'ID' => $category['id'], 'RANK' => $category['rank']*10, 'U_JUMPTO' => make_index_url( array( 'category' => $category ) ), 'U_CHILDREN' => $cat_list_url.'&parent_id='.$category['id'], 'U_EDIT' => $base_url.'album-'.$category['id'], 'IS_VIRTUAL' => empty($category['dir']) ); if (empty($category['dir'])) { $tpl_cat['U_DELETE'] = $self_url.'&delete='.$category['id']; $tpl_cat['U_DELETE'].= '&pwg_token='.get_pwg_token(); } else { if ($conf['enable_synchronization']) { $tpl_cat['U_SYNC'] = $base_url.'site_update&site=1&cat_id='.$category['id']; } } if ( array_key_exists($category['id'], $categories_with_images) ) { $tpl_cat['U_MANAGE_ELEMENTS']= $base_url.'batch_manager&cat='.$category['id']; } $template->append('categories', $tpl_cat); } trigger_action('loc_end_cat_list'); // +-----------------------------------------------------------------------+ // | sending html code | // +-----------------------------------------------------------------------+ $template->assign_var_from_handle('ADMIN_CONTENT', 'categories'); ?>