aboutsummaryrefslogtreecommitdiffstats
path: root/admin
diff options
context:
space:
mode:
authorplegall <plg@piwigo.org>2010-12-31 16:43:59 +0000
committerplegall <plg@piwigo.org>2010-12-31 16:43:59 +0000
commit4effe045ee0b924cdcf17c7499d12ab4467433a3 (patch)
treed618bc4851d25d1f0e203e07f0afb6cf5017cc1a /admin
parentc716ed88b8b8a101bf35589a465ce3b45c6942aa (diff)
feature 2091: Batch Manager, find all orphan photos
git-svn-id: http://piwigo.org/svn/trunk@8419 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to '')
-rw-r--r--admin/batch_manager.php15
-rw-r--r--admin/themes/default/template/batch_manager_global.tpl2
2 files changed, 16 insertions, 1 deletions
diff --git a/admin/batch_manager.php b/admin/batch_manager.php
index 89a1b8bc1..e11c8213e 100644
--- a/admin/batch_manager.php
+++ b/admin/batch_manager.php
@@ -177,6 +177,21 @@ SELECT id
);
}
+ if ('with no album' == $_SESSION['bulk_manager_filter']['prefilter'])
+ {
+ $query = '
+SELECT
+ id
+ FROM '.IMAGES_TABLE.'
+ LEFT JOIN '.IMAGE_CATEGORY_TABLE.' ON id = image_id
+ WHERE category_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
diff --git a/admin/themes/default/template/batch_manager_global.tpl b/admin/themes/default/template/batch_manager_global.tpl
index 1fb57289a..039caf78a 100644
--- a/admin/themes/default/template/batch_manager_global.tpl
+++ b/admin/themes/default/template/batch_manager_global.tpl
@@ -344,11 +344,11 @@ a.removeFilter:hover {background: url(admin/themes/default/icon/remove_filter_ho
<select name="filter_prefilter">
<option value="caddie" {if $filter.prefilter eq 'caddie'}selected="selected"{/if}>{'caddie'|@translate}</option>
<option value="last import" {if $filter.prefilter eq 'last import'}selected="selected"{/if}>{'last import'|@translate}</option>
+ <option value="with no album" {if $filter.prefilter eq 'with no album'}selected="selected"{/if}>{'with no album'|@translate}</option> -->
{if $ENABLE_SYNCHRONIZATION}
<option value="with no virtual album" {if $filter.prefilter eq 'with no virtual album'}selected="selected"{/if}>{'with no virtual album'|@translate}</option>
{/if}
<option value="duplicates" {if $filter.prefilter eq 'duplicates'}selected="selected"{/if}>{'duplicates'|@translate}</option>
-<!-- <option value="with no album">with no album</option> -->
<!-- <option value="with no tag">with no tag</option> -->
</select>
</li>