diff options
Diffstat (limited to 'admin/batch_manager.php')
| -rw-r--r-- | admin/batch_manager.php | 335 |
1 files changed, 335 insertions, 0 deletions
diff --git a/admin/batch_manager.php b/admin/batch_manager.php new file mode 100644 index 000000000..3fe4c3ce4 --- /dev/null +++ b/admin/batch_manager.php @@ -0,0 +1,335 @@ +<?php +// +-----------------------------------------------------------------------+ +// | Piwigo - a PHP based picture gallery | +// +-----------------------------------------------------------------------+ +// | Copyright(C) 2008-2010 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. | +// +-----------------------------------------------------------------------+ + +/** + * Management of elements set. Elements can belong to a category or to the + * user caddie. + * + */ + +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); + +check_input_parameter('selection', $_POST, true, PATTERN_ID); + +// +-----------------------------------------------------------------------+ +// | initialize current set | +// +-----------------------------------------------------------------------+ + +if (isset($_POST['submitFilter'])) +{ + // echo '<pre>'; print_r($_POST); echo '</pre>'; + + $_SESSION['bulk_manager_filter'] = array(); + + if (isset($_POST['filter_prefilter_use'])) + { + $prefilters = array('caddie', 'last import', 'with no album', 'with no tag'); + if (in_array($_POST['filter_prefilter'], $prefilters)) + { + $_SESSION['bulk_manager_filter']['prefilter'] = $_POST['filter_prefilter']; + } + } + + if (isset($_POST['filter_category_use'])) + { + $_SESSION['bulk_manager_filter']['category'] = $_POST['filter_category']; + + if (isset($_POST['filter_category_recursive'])) + { + $_SESSION['bulk_manager_filter']['category_recursive'] = true; + } + } + + if (isset($_POST['filter_level_use'])) + { + if (in_array($_POST['filter_level'], $conf['available_permission_levels'])) + { + $_SESSION['bulk_manager_filter']['level'] = $_POST['filter_level']; + } + } +} + +if (isset($_GET['cat'])) +{ + if ('caddie' == $_GET['cat']) + { + $_SESSION['bulk_manager_filter'] = array( + 'prefilter' => 'caddie' + ); + } + + if (is_numeric($_GET['cat'])) + { + $_SESSION['bulk_manager_filter'] = array( + 'category' => $_GET['cat'] + ); + } +} + +if (!isset($_SESSION['bulk_manager_filter'])) +{ + $_SESSION['bulk_manager_filter'] = array( + 'prefilter' => 'caddie' + ); +} + +// echo '<pre>'; print_r($_SESSION['bulk_manager_filter']); echo '</pre>'; + +// depending on the current filter (in session), we find the appropriate +// photos +$filter_sets = array(); +if (isset($_SESSION['bulk_manager_filter']['prefilter'])) +{ + if ('caddie' == $_SESSION['bulk_manager_filter']['prefilter']) + { + $query = ' +SELECT element_id + FROM '.CADDIE_TABLE.' + WHERE user_id = '.$user['id'].' +;'; + array_push( + $filter_sets, + array_from_query($query, 'element_id') + ); + } + + if ('last import'== $_SESSION['bulk_manager_filter']['prefilter']) + { + $query = ' +SELECT MAX(date_available) AS date + FROM '.IMAGES_TABLE.' +;'; + $row = pwg_db_fetch_assoc(pwg_query($query)); + if (!empty($row['date'])) + { + $query = ' +SELECT id + FROM '.IMAGES_TABLE.' + WHERE date_available BETWEEN '.pwg_db_get_recent_period_expression(1, $row['date']).' AND \''.$row['date'].'\' +;'; + array_push( + $filter_sets, + array_from_query($query, 'id') + ); + } + } +} + +if (isset($_SESSION['bulk_manager_filter']['category'])) +{ + $categories = array(); + + if (isset($_SESSION['bulk_manager_filter']['category_recursive'])) + { + $categories = get_subcat_ids(array($_SESSION['bulk_manager_filter']['category'])); + } + else + { + $categories = array($_SESSION['bulk_manager_filter']['category']); + } + + $query = ' + SELECT DISTINCT(image_id) + FROM '.IMAGE_CATEGORY_TABLE.' + WHERE category_id IN ('.implode(',', $categories).') + ;'; + array_push( + $filter_sets, + array_from_query($query, 'image_id') + ); +} + +if (isset($_SESSION['bulk_manager_filter']['level'])) +{ + $query = ' +SELECT id + FROM '.IMAGES_TABLE.' + WHERE level >= '.$_SESSION['bulk_manager_filter']['level'].' +;'; + array_push( + $filter_sets, + array_from_query($query, 'id') + ); +} + +$current_set = array_shift($filter_sets); +foreach ($filter_sets as $set) +{ + $current_set = array_intersect($current_set, $set); +} +$page['cat_elements_id'] = $current_set; + +// // To element_set_(global|unit).php, we must provide the elements id of the +// // managed category in $page['cat_elements_id'] array. +// $page['cat_elements_id'] = array(); +// if (is_numeric($_GET['cat'])) +// { +// $page['title'] = +// get_cat_display_name_from_id( +// $_GET['cat'], +// PHPWG_ROOT_PATH.'admin.php?page=cat_modify&cat_id=', +// false +// ); +// +// $query = ' +// SELECT image_id +// FROM '.IMAGE_CATEGORY_TABLE.' +// WHERE category_id = '.$_GET['cat'].' +// ;'; +// $page['cat_elements_id'] = array_from_query($query, 'image_id'); +// } +// else if ('caddie' == $_GET['cat']) +// { +// $page['title'] = l10n('caddie'); +// +// $query = ' +// SELECT element_id +// FROM '.CADDIE_TABLE.' +// WHERE user_id = '.$user['id'].' +// ;'; +// $page['cat_elements_id'] = array_from_query($query, 'element_id'); +// } +// else if ('not_linked' == $_GET['cat']) +// { +// $page['title'] = l10n('Not linked elements'); +// $template->assign(array('U_ACTIVE_MENU' => 5 )); +// +// // we are searching elements not linked to any virtual category +// $query = ' +// SELECT id +// FROM '.IMAGES_TABLE.' +// ;'; +// $all_elements = array_from_query($query, 'id'); +// +// $linked_to_virtual = array(); +// +// $query = ' +// SELECT id +// FROM '.CATEGORIES_TABLE.' +// WHERE dir IS NULL +// ;'; +// $virtual_categories = array_from_query($query, 'id'); +// if (!empty($virtual_categories)) +// { +// $query = ' +// SELECT DISTINCT(image_id) +// FROM '.IMAGE_CATEGORY_TABLE.' +// WHERE category_id IN ('.implode(',', $virtual_categories).') +// ;'; +// $linked_to_virtual = array_from_query($query, 'image_id'); +// } +// +// $page['cat_elements_id'] = array_diff($all_elements, $linked_to_virtual); +// } +// else if ('duplicates' == $_GET['cat']) +// { +// $page['title'] = l10n('Files with same name in more than one physical category'); +// $template->assign(array('U_ACTIVE_MENU' => 5 )); +// +// // we are searching related elements twice or more to physical categories +// // 1 - Retrieve Files +// $query = ' +// SELECT DISTINCT(file) +// FROM '.IMAGES_TABLE.' +// GROUP BY file +// HAVING COUNT(DISTINCT storage_category_id) > 1 +// ;'; +// +// $duplicate_files = array_from_query($query, 'file'); +// $duplicate_files[]='Nofiles'; +// // 2 - Retrives related picture ids +// $query = ' +// SELECT id, file +// FROM '.IMAGES_TABLE.' +// WHERE file IN (\''.implode("','", $duplicate_files).'\') +// ORDER BY file, id +// ;'; +// +// $page['cat_elements_id'] = array_from_query($query, 'id'); +// } +// elseif ('recent'== $_GET['cat']) +// { +// $page['title'] = l10n('Recent pictures'); +// $query = 'SELECT MAX(date_available) AS date +// FROM '.IMAGES_TABLE; +// $row = pwg_db_fetch_assoc(pwg_query($query)); +// if (!empty($row['date'])) +// { +// $query = 'SELECT id +// FROM '.IMAGES_TABLE.' +// WHERE date_available BETWEEN '.pwg_db_get_recent_period_expression(1, $row['date']).' AND \''.$row['date'].'\''; +// $page['cat_elements_id'] = array_from_query($query, 'id'); +// } +// } + +// +-----------------------------------------------------------------------+ +// | first element to display | +// +-----------------------------------------------------------------------+ + +// $page['start'] contains the number of the first element in its +// category. For exampe, $page['start'] = 12 means we must show elements #12 +// and $page['nb_images'] next elements + +if (!isset($_GET['start']) + or !is_numeric($_GET['start']) + or $_GET['start'] < 0 + or (isset($_GET['display']) and 'all' == $_GET['display'])) +{ + $page['start'] = 0; +} +else +{ + $page['start'] = $_GET['start']; +} + +// +-----------------------------------------------------------------------+ +// | open specific mode | +// +-----------------------------------------------------------------------+ + +$_GET['mode'] = !empty($_GET['mode']) ? $_GET['mode'] : 'global'; + +switch ($_GET['mode']) +{ + case 'global' : + { + include(dirname(__FILE__).'/batch_manager_global.php'); + break; + } + case 'unit' : + { + include(PHPWG_ROOT_PATH.'admin/element_set_unit.php'); + break; + } +} +?> |