feature 2089: add the "not_linked" feature as "with no virtual album" in the

new Batch Manager.


git-svn-id: http://piwigo.org/svn/trunk@8403 68402e56-0260-453c-a942-63ccdbb3a9ee

1 files changed, 32 insertions, 33 deletions

diff --git a/admin/batch_manager.php b/admin/batch_manager.php
index 123304a8c..e9a82966e 100644
--- a/admin/batch_manager.php
+++ b/admin/batch_manager.php
@@ -54,7 +54,7 @@ if (isset($_POST['submitFilter']))
 
   if (isset($_POST['filter_prefilter_use']))
   {
-    $prefilters = array('caddie', 'last import', 'with no album', 'with no tag');
+    $prefilters = array('caddie', 'last import', 'with no album', 'with no tag', 'with no virtual album');
     if (in_array($_POST['filter_prefilter'], $prefilters))
     {
       $_SESSION['bulk_manager_filter']['prefilter'] = $_POST['filter_prefilter'];
@@ -144,6 +144,37 @@ SELECT id
         );
     }
   }
+
+  if ('with no virtual album' == $_SESSION['bulk_manager_filter']['prefilter'])
+  {
+    // we are searching elements not linked to any virtual category
+    $query = '
+ SELECT id
+   FROM '.IMAGES_TABLE.'
+ ;';
+    $all_elements = array_from_query($query, 'id');
+ 
+    $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');
+    }
+
+    array_push(
+      $filter_sets,
+      array_diff($all_elements, $linked_to_virtual)
+      );
+  }
 }
 
 if (isset($_SESSION['bulk_manager_filter']['category']))
@@ -194,38 +225,6 @@ $page['cat_elements_id'] = $current_set;
 //  // managed category in $page['cat_elements_id'] array.
 //  $page['cat_elements_id'] = array();
 
-//  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');