Changeset 17931 for trunk/admin/batch_manager.php

Timestamp:

Sep 15, 2012, 5:47:52 PM (12 years ago)

Author:

mistic100

Message:

feature 2718: Add batch manager filters for photo dimensions

File:

• trunk/admin/batch_manager.php (modified) (2 diffs)

trunk/admin/batch_manager.php

@@ -91 +91 @@
     }
   }
+  
+  if (isset($_POST['filter_dimension_use']))
+  {
+    if ( $_POST['filter_dimension'] != 'format' and !preg_match('#^[0-9]+$#', $_POST['filter_dimension_'. $_POST['filter_dimension'] ]) )
+    {
+      array_push($page['errors'], l10n('Invalid dimension'));
+    }
+    else
+    {
+      $_SESSION['bulk_manager_filter']['dimension'] = $_POST['filter_dimension'];
+      $_SESSION['bulk_manager_filter']['dimension_'. $_POST['filter_dimension'] ] = $_POST['filter_dimension_'. $_POST['filter_dimension'] ];
+    }
+  }
 }
 
@@ -328 +341 @@
 }
 
+if (isset($_SESSION['bulk_manager_filter']['dimension']))
+{
+  switch ($_SESSION['bulk_manager_filter']['dimension'])
+  {
+    case 'min_width':
+      $where_clause = 'width >= '.$_SESSION['bulk_manager_filter']['dimension_min_width']; break;
+    case 'max_width':
+      $where_clause = 'width <= '.$_SESSION['bulk_manager_filter']['dimension_max_width']; break;
+    case 'min_height':
+      $where_clause = 'height >= '.$_SESSION['bulk_manager_filter']['dimension_min_height']; break;
+    case 'max_height':
+      $where_clause = 'height <= '.$_SESSION['bulk_manager_filter']['dimension_max_height']; break;
+    case 'format':
+    {
+      switch ($_SESSION['bulk_manager_filter']['dimension_format'])
+      {
+        case 'portrait':
+          $where_clause = 'width/height < 0.95'; break;
+        case 'square':
+          $where_clause = 'width/height >= 0.95 AND width/height <= 1.05'; break;
+        case 'landscape':
+          $where_clause = 'width/height > 1.05 AND width/height < 2.5'; break;
+        case 'panorama':
+          $where_clause = 'width/height >= 2.5'; break;
+      }
+      break;
+    }
+  }
+  
+  $query = '
+SELECT id
+  FROM '.IMAGES_TABLE.'
+  WHERE '.$where_clause.'
+  '.$conf['order_by'];
+
+  $filter_sets[] = array_from_query($query, 'id');
+}
+
 $current_set = array_shift($filter_sets);
 foreach ($filter_sets as $set)