$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 = ''; $navigation.= l10n('Home'); $navigation.= ''; // +-----------------------------------------------------------------------+ // | 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(); invalidate_user_cache(); $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 elseif (isset($_POST['submitAdd'])) { $output_create = create_virtual_category( $_POST['virtual_name'], @$_GET['parent_id'] ); invalidate_user_cache(); if (isset($output_create['error'])) { $page['errors'][] = $output_create['error']; } else { $page['infos'][] = $output_create['info']; } } // save manual category ordering elseif (isset($_POST['submitManualOrder'])) { asort($_POST['catOrd'], SORT_NUMERIC); save_categories_order(array_keys($_POST['catOrd'])); $page['infos'][] = l10n('Album manual order was saved'); } elseif (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)) { $categories[] = array( 'id' => $row['id'], 'id_uppercat' => $row['id_uppercat'], ); $names[] = $row['name']; } array_multisort( $names, SORT_REGULAR, 'asc' == $_POST['ascdesc'] ? SORT_ASC : SORT_DESC, $categories ); save_categories_order($categories); $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=' ); } // +-----------------------------------------------------------------------+ // | 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 category_id, COUNT(*) AS nb_photos FROM '.IMAGE_CATEGORY_TABLE.' GROUP BY category_id ;'; // WHERE category_id IN ('.implode(',', array_keys($categories)).') $nb_photos_in = query2array($query, 'category_id', 'nb_photos'); $query = ' SELECT id, uppercats FROM '.CATEGORIES_TABLE.' ;'; $all_categories = query2array($query, 'id', 'uppercats'); $subcats_of = array(); foreach (array_keys($categories) as $cat_id) { foreach ($all_categories as $id => $uppercats) { if (preg_match('/(^|,)'.$cat_id.',/', $uppercats)) { @$subcats_of[$cat_id][] = $id; } } } $nb_sub_photos = array(); foreach ($subcats_of as $cat_id => $subcat_ids) { $nb_photos = 0; foreach ($subcat_ids as $id) { if (isset($nb_photos_in[$id])) { $nb_photos+= $nb_photos_in[$id]; } } $nb_sub_photos[$cat_id] = $nb_photos; } } $template->assign('categories', array()); $base_url = get_root_url().'admin.php?page='; if (isset($_GET['parent_id'])) { $template->assign( 'PARENT_EDIT', $base_url.'album-'.$_GET['parent_id'] ); } 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' ), 'NB_PHOTOS' => isset($nb_photos_in[$category['id']]) ? $nb_photos_in[$category['id']] : 0, 'NB_SUB_PHOTOS' => isset($nb_sub_photos[$category['id']]) ? $nb_sub_photos[$category['id']] : 0, 'NB_SUB_ALBUMS' => isset($subcats_of[$category['id']]) ? count($subcats_of[$category['id']]) : 0, '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']; } } $template->append('categories', $tpl_cat); } trigger_action('loc_end_cat_list'); // +-----------------------------------------------------------------------+ // | sending html code | // +-----------------------------------------------------------------------+ $template->assign_var_from_handle('ADMIN_CONTENT', 'categories'); ?>