Changeset 1064 for trunk/admin/rating.php

Timestamp:

Mar 5, 2006, 12:31:46 AM (18 years ago)

Author:

plg

Message:

new feature: source/destination links between categories. Will we keep this
feature? Code is complicated and very few people will understand how it
works...

modification: #images.storage_category_id replaced by
#image_category.is_storage

improvement: many code refactoring to improve readibility

improvement: virtual category creation code was moved to a dedicated
function in order to be called from admin/cat_list.php and
admin/cat_modify.php (create a new destination category)

File:

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

trunk/admin/rating.php

@@ -169 +169 @@
 }
 
-$query = 'SELECT i.id, i.path, i.file, i.tn_ext, i.average_rate, i.storage_category_id,
-          MAX(r.date) as recently_rated, COUNT(r.rate) as nb_rates,
-          SUM(r.rate) as sum_rates, ROUND(STD(r.rate),2) as std_rates
-FROM '.RATE_TABLE.' AS r LEFT JOIN '.IMAGES_TABLE.' AS i
-ON r.element_id=i.id
-WHERE 1=1 ' . $display_filter . '
-GROUP BY r.element_id
-ORDER BY ' . $available_order_by[$order_by_index][1] .'
-LIMIT '.$start.','.$elements_per_page .
-';';
+$query = '
+SELECT i.id,
+       i.path,
+       i.file,
+       i.tn_ext,
+       i.average_rate,
+       MAX(r.date)          AS recently_rated,
+       COUNT(r.rate)        AS nb_rates,
+       SUM(r.rate)          AS sum_rates,
+       ROUND(STD(r.rate),2) AS std_rates,
+       ic.category_id       AS storage_category_id
+  FROM '.RATE_TABLE.' AS r
+    LEFT JOIN '.IMAGES_TABLE.' AS i ON r.element_id = i.id
+    INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON ic.image_id = i.id
+  WHERE 1 = 1 ' . $display_filter . '
+    AND ic.is_storage = \'true\'
+  GROUP BY r.element_id
+  ORDER BY ' . $available_order_by[$order_by_index][1] .'
+  LIMIT '.$start.','.$elements_per_page.'
+;';
 
 $images = array();
@@ -189 +199 @@
 foreach ($images as $image)
 {
-  $thumbnail_src = get_thumbnail_src(
-    $image['path'], $image['tn_ext']
-    );
-
-  $image_url = PHPWG_ROOT_PATH.'picture.php?'.
-                'cat=' . $image['storage_category_id'].
-                '&image_id=' . $image['id'];
+  $thumbnail_src = get_thumbnail_src($image['path'], $image['tn_ext']);
+
+  $image_url =
+    PHPWG_ROOT_PATH.'picture.php?'.
+    'cat=' . $image['storage_category_id'].
+    '&image_id=' . $image['id']
+    ;
 
   $query = 'SELECT *