From 41696e7554139fd8946c1c537703d45679b29136 Mon Sep 17 00:00:00 2001 From: plegall Date: Thu, 30 Dec 2010 14:36:02 +0000 Subject: feature 2089: implement the "Bulk Manager" plugin as the new "Batch Manager". The new "Batch Manager" offers as many features as the old "Bulk Manager" and more to come. The old Batch Manager (Caddie/Recent Pictures) is not removed yet and changes that occured since last summer are not reported yet in the Batch Manager: category/album, photo order for a given album, deletion of synchronized photos. git-svn-id: http://piwigo.org/svn/trunk@8394 68402e56-0260-453c-a942-63ccdbb3a9ee --- admin/batch_manager.php | 335 ++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 335 insertions(+) create mode 100644 admin/batch_manager.php (limited to 'admin/batch_manager.php') 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 @@ +'; print_r($_POST); echo ''; + + $_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 '
'; print_r($_SESSION['bulk_manager_filter']); echo '
'; + +// 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; + } +} +?> -- cgit v1.2.3