aboutsummaryrefslogtreecommitdiffstats
path: root/admin/batch_manager.php
diff options
context:
space:
mode:
authorplegall <plg@piwigo.org>2010-12-30 14:36:02 +0000
committerplegall <plg@piwigo.org>2010-12-30 14:36:02 +0000
commit41696e7554139fd8946c1c537703d45679b29136 (patch)
tree2f09f1f97d39592a5e9c15a027d158f28465f965 /admin/batch_manager.php
parent15159f98bbb5434100ea3719fd84b30a3c66dbf5 (diff)
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
Diffstat (limited to '')
-rw-r--r--admin/batch_manager.php335
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&amp;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;
+ }
+}
+?>