From 9d0357e889d603e769e9755fb07fb34334396b6e Mon Sep 17 00:00:00 2001
From: mistic100 <mistic@piwigo.org>
Date: Tue, 23 Sep 2014 09:28:26 +0000
Subject: filter "dissociate" action + display bug of Selectize widget

git-svn-id: http://piwigo.org/svn/trunk@29760 68402e56-0260-453c-a942-63ccdbb3a9ee
---
 admin/batch_manager_global.php | 19 +++++++++++++++++++
 1 file changed, 19 insertions(+)

(limited to 'admin/batch_manager_global.php')

diff --git a/admin/batch_manager_global.php b/admin/batch_manager_global.php
index d8e9e94f0..4179ed284 100644
--- a/admin/batch_manager_global.php
+++ b/admin/batch_manager_global.php
@@ -529,6 +529,25 @@ SELECT category_id
 
 $template->assign('filter_category_selected', $selected_category);
 
+// Dissociate from a category : categories listed for dissociation can only
+// represent virtual links. We can't create orphans. Links to physical
+// categories can't be broken.
+if (count($page['cat_elements_id']) > 0)
+{
+  $query = '
+SELECT
+    DISTINCT(category_id) AS id
+  FROM '.IMAGE_CATEGORY_TABLE.' AS ic
+    JOIN '.IMAGES_TABLE.' AS i ON i.id = ic.image_id
+  WHERE ic.image_id IN ('.implode(',', $page['cat_elements_id']).')
+    AND (
+      ic.category_id != i.storage_category_id
+      OR i.storage_category_id IS NULL
+    )
+;';
+
+  $template->assign('associated_categories', query2array($query, 'id', 'id'));
+}
 
 if (count($page['cat_elements_id']) > 0)
 {
-- 
cgit v1.2.3