Changeset 18988 for trunk/admin/batch_manager.php

Timestamp:

Nov 10, 2012, 9:10:01 PM (12 years ago)

Author:

mistic100

Message:

feature:2718 Add batch manager filters for photo dimensions, redesign with sliders

File:

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

trunk/admin/batch_manager.php

@@ -101 +101 @@
       }
     }
-  }
-  
-  if (isset($_POST['filter_ratio_use']))
-  {
-    foreach (array('min','max') as $type)
-    {
-      if ( preg_match('#^[0-9\.,]+$#', $_POST['filter_ratio_'. $type ]) )
+    foreach (array('min_ratio','max_ratio') as $type)
+    {
+      if ( preg_match('#^[0-9\.]+$#', $_POST['filter_dimension_'. $type ]) )
       {
-        $_SESSION['bulk_manager_filter']['ratio'][$type] = str_replace(',','.',$_POST['filter_ratio_'. $type ]);
+        $_SESSION['bulk_manager_filter']['dimension'][$type] = $_POST['filter_dimension_'. $type ];
       }
     }
@@ -350 +346 @@
 }
 
-if (isset($_SESSION['bulk_manager_filter']['dimension']) or isset($_SESSION['bulk_manager_filter']['ratio']))
+if (isset($_SESSION['bulk_manager_filter']['dimension']))
 {
   $where_clauses = array();
@@ -369 +365 @@
     $where_clause[] = 'height <= '.$_SESSION['bulk_manager_filter']['dimension']['max_height'];
   }
-  if (isset($_SESSION['bulk_manager_filter']['ratio']['min']))
-  {
-    $where_clause[] = 'width/height >= '.$_SESSION['bulk_manager_filter']['ratio']['min'];
-  }
-  if (isset($_SESSION['bulk_manager_filter']['ratio']['max']))
-  {
-    $where_clause[] = 'width/height <= '.$_SESSION['bulk_manager_filter']['ratio']['max'];
+  if (isset($_SESSION['bulk_manager_filter']['dimension']['min_ratio']))
+  {
+    $where_clause[] = 'width/height >= '.$_SESSION['bulk_manager_filter']['dimension']['min_ratio'];
+  }
+  if (isset($_SESSION['bulk_manager_filter']['dimension']['max_ratio']))
+  {
+    $where_clause[] = 'width/height <= '.$_SESSION['bulk_manager_filter']['dimension']['max_ratio'];
   }
   
@@ -444 +440 @@
 
 // +-----------------------------------------------------------------------+
+// |                              dimensions                               |
+// +-----------------------------------------------------------------------+
+$query = '
+SELECT
+    MIN(width) as min_width,
+    MAX(width) as max_width,
+    MIN(height) as min_height,
+    MAX(height) as max_height,
+    MIN(width/height) as min_ratio,
+    MAX(width/height) as max_ratio
+  FROM '.IMAGES_TABLE.'
+;';
+$dimensions['bounds'] = pwg_db_fetch_assoc(pwg_query($query));
+$dimensions['bounds']['min_ratio'] = floor($dimensions['bounds']['min_ratio']*100)/100;
+$dimensions['bounds']['max_ratio'] = ceil($dimensions['bounds']['max_ratio']*100)/100;
+
+foreach (array_keys($dimensions['bounds']) as $type)
+{
+  $dimensions['selected'][$type] = isset($_SESSION['bulk_manager_filter']['dimension'][$type]) ? $_SESSION['bulk_manager_filter']['dimension'][$type] : $dimensions['bounds'][$type];
+}
+$template->assign('dimensions', $dimensions);
+
+
+// +-----------------------------------------------------------------------+
 // |                         open specific mode                            |
 // +-----------------------------------------------------------------------+