feature 2092 added: Batch Manager can filter all photos with no tag

feature 1866 added: Batch Manager can synchronize metadata


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

1 files changed, 16 insertions, 0 deletions

diff --git a/admin/batch_manager.php b/admin/batch_manager.php
index e11c8213e..2288acfb2 100644
--- a/admin/batch_manager.php
+++ b/admin/batch_manager.php
@@ -192,6 +192,22 @@ SELECT
       );
   }
 
+  if ('with no tag' == $_SESSION['bulk_manager_filter']['prefilter'])
+  {
+    $query = '
+SELECT
+    id
+  FROM '.IMAGES_TABLE.'
+    LEFT JOIN '.IMAGE_TAG_TABLE.' ON id = image_id
+  WHERE tag_id is null
+;';
+    array_push(
+      $filter_sets,
+      array_from_query($query, 'id')
+      );
+  }
+
+
   if ('duplicates' == $_SESSION['bulk_manager_filter']['prefilter'])
   {
     // we could use the group_concat MySQL function to retrieve the list of