Changeset 2548

Timestamp:

Sep 17, 2008, 11:42:50 PM (16 years ago)

Author:

plg

Message:

improvement: webservice methode pwg.categories.getList returns the
images_max_rank for each category, based on #image_category.rank content. So
that a remote client can correctly add photos with webservice method
pwg.images.add.

File:

• trunk/include/ws_functions.inc.php (modified) (2 diffs)

trunk/include/ws_functions.inc.php

@@ -365 +365 @@
   global $user,$conf;
 
+  $query = '
+SELECT
+    category_id,
+    MAX(rank) AS max_rank
+  FROM '.IMAGE_CATEGORY_TABLE.'
+  WHERE rank IS NOT NULL
+  GROUP BY category_id
+;';
+  $max_image_rank_of = simple_hash_from_query(
+    $query,
+    'category_id',
+    'max_rank'
+    );
+
   $where = array();
 
@@ -416 +430 @@
       $row[$key] = (int)$row[$key];
     }
+
+    if (isset($max_image_rank_of[ $row['id'] ]))
+    {
+      $row['images_max_rank'] = $max_image_rank_of[ $row['id'] ];
+    }
+    
     array_push($cats, $row);
   }
   usort($cats, 'global_rank_compare');
   return array(
-      'categories' =>
-          new PwgNamedArray($cats,'category',
-            array('id','url','nb_images','total_nb_images','nb_categories','date_last','max_date_last')
-          )
+    'categories' => new PwgNamedArray(
+      $cats,
+      'category',
+      array(
+        'id',
+        'url',
+        'nb_images',
+        'total_nb_images',
+        'nb_categories',
+        'date_last',
+        'max_date_last',
+        'images_max_rank',
+        )
+      )
     );
 }