Changeset 7504 for branches/2.1/admin/element_set_unit.php

Timestamp:

Oct 30, 2010, 10:03:05 PM (14 years ago)

Author:

plg

Message:

bug 1906 fixed: during batch management, for a given category, use the category
defined sort order for photos, not the generic order_by.

File:

• branches/2.1/admin/element_set_unit.php (modified) (1 diff)

branches/2.1/admin/element_set_unit.php

@@ -195 +195 @@
   $query = '
 SELECT id,path,tn_ext,name,date_creation,comment,author,level,file
-  FROM '.IMAGES_TABLE.'
+  FROM '.IMAGES_TABLE;
+
+  if (is_numeric($_GET['cat']))
+  {
+    $category_info = get_cat_info($_GET['cat']);
+    
+    $conf['order_by'] = $conf['order_by_inside_category'];
+    if (!empty($category_info['image_order']))
+    {
+      $conf['order_by'] = ' ORDER BY '.$category_info['image_order'];
+    }
+
+    $query.= '
+    JOIN '.IMAGE_CATEGORY_TABLE.' ON id = image_id';
+  }
+
+  $query.= '
   WHERE id IN ('.implode(',', $page['cat_elements_id']).')
   '.$conf['order_by'].'