Changeset 17677 for extensions/SmartAlbums/include

Timestamp:

Aug 31, 2012, 12:58:56 PM (12 years ago)

Author:

mistic100

Message:

add album filter

Location:

extensions/SmartAlbums/include

Files:

• count_images.php (modified) (1 diff)
• functions.inc.php (modified) (2 diffs)

extensions/SmartAlbums/include/count_images.php

@@ -11 +11 @@
 if (!is_admin()) die('Hacking attempt!');
 
-include_once(PHPWG_ROOT_PATH.'admin/include/functions.php');
-include_once(SMART_PATH.'include/functions.inc.php');
-
-load_language('plugin.lang', SMART_PATH);
-$conf['SmartAlbums'] = unserialize($conf['SmartAlbums']);
 
 if (isset($_POST['filters']))

extensions/SmartAlbums/include/functions.inc.php

@@ -254 +254 @@
       }
       
+      // album
+      case 'album':
+      {
+        switch ($filter['cond'])
+        {
+          // search images existing in all albums
+          case 'all':
+          {
+            $albums_arr = explode(',', $filter['value']);
+            foreach($albums_arr as $value)
+            {
+              $sub_query = '
+      SELECT image_id 
+        FROM '.IMAGE_CATEGORY_TABLE.'
+        WHERE category_id = '.$value.'
+      ';
+              $where[] = 'i.id IN ('.$sub_query.')';
+            }
+            
+            break;
+          }
+          // search images existing in one of these albums
+          case 'one':
+          {
+            $sub_query = '
+      SELECT image_id
+        FROM '.IMAGE_CATEGORY_TABLE.'
+        WHERE category_id IN('.$filter['value'].')
+      ';
+            $where[] = 'i.id IN ('.$sub_query.')';
+            
+            break;
+          }
+          // exclude images existing in one of these albums
+          case 'none':
+          {
+            $sub_query = '
+      SELECT image_id
+        FROM '.IMAGE_CATEGORY_TABLE.'
+        WHERE category_id IN('.$filter['value'].')
+      ';
+            $where[] = 'i.id NOT IN ('.$sub_query.')';
+            
+            break;
+          }
+          // exclude images existing on other albums, and search images existing in all albums
+          case 'only':
+          {
+            $sub_query = '
+      SELECT image_id
+        FROM '.IMAGE_CATEGORY_TABLE.'
+        WHERE category_id NOT IN('.$filter['value'].')
+      ';
+            $where[] = 'i.id NOT IN ('.$sub_query.')';
+            
+            $albums_arr = explode(',', $filter['value']);
+            foreach($albums_arr as $value)
+            {
+              $sub_query = '
+      SELECT image_id 
+        FROM '.IMAGE_CATEGORY_TABLE.'
+        WHERE category_id = '.$value.'
+      ';
+              $where[] = 'i.id IN ('.$sub_query.')';
+            }
+            
+            break;
+          }
+        }
+        
+        break;
+      }
+      
       // author
       case 'author':
@@ -398 +471 @@
       $error = true;
       array_push($page['errors'], l10n('Name is empty'));
+    }
+  }
+  # album
+  else if ($filter['type'] == 'album')
+  {
+    if (@$filter['value'] == null)
+    {
+      $error = true;
+      array_push($page['errors'], l10n('No album selected'));
+    }
+    else
+    {
+      $filter['value'] = implode(',', $filter['value']);
     }
   }