Changeset 2563

Timestamp:

Sep 21, 2008, 10:42:17 PM (16 years ago)

Author:

plg

Message:

new: webservice method pwg.categories.getAdminList was added so that pLoader
can see the list of categories as you can see in the administration
interface : not filtered by individual permissions.

Location:

trunk

Files:

• include/ws_functions.inc.php (modified) (1 diff)
• ws.php (modified) (1 diff)

trunk/include/ws_functions.inc.php

@@ -437 +437 @@
 }
 
+/**
+ * returns the list of categories as you can see them in administration (web
+ * service method).
+ *
+ * Only admin can run this method and permissions are not taken into
+ * account.
+ */
+function ws_categories_getAdminList($params, &$service)
+{
+  if (!is_admin())
+  {
+    return new PwgError(401, 'Access denied');
+  }
+
+  $query = '
+SELECT
+    category_id,
+    COUNT(*) AS counter
+  FROM '.IMAGE_CATEGORY_TABLE.'
+  GROUP BY category_id
+;';
+  $nb_images_of = simple_hash_from_query($query, 'category_id', 'counter');
+
+  $query = '
+SELECT
+    id,
+    name,
+    uppercats,
+    global_rank
+  FROM '.CATEGORIES_TABLE.'
+;';
+  $result = pwg_query($query);
+  $cats = array();
+
+  while ($row = mysql_fetch_assoc($result))
+  {
+    $id = $row['id'];
+    $row['nb_images'] = isset($nb_images_of[$id]) ? $nb_images_of[$id] : 0;
+    array_push($cats, $row);
+  }   
+  
+  usort($cats, 'global_rank_compare');
+  return array(
+    'categories' => new PwgNamedArray(
+      $cats,
+      'category',
+      array(
+        'id',
+        'nb_images',
+        'name',
+        'uppercats',
+        'global_rank',
+        )
+      )
+    );
+}
 
 /**

trunk/ws.php

@@ -187 +187 @@
     'POST method only'
     );
+
+  $service->addMethod(
+    'pwg.categories.getAdminList',
+    'ws_categories_getAdminList',
+    array(),
+    'administration method only'
+    );
 }