Changeset 1687

Timestamp:

02/07/07 08:49:00 (20 months ago)

Author:

mbonetti

Message:

display feed count for each folder

Files:

• trunk/gregarius/admin/folders.php (modified) (5 diffs)

trunk/gregarius/admin/folders.php

@@ -44 +44 @@
     echo "<table id=\"foldertable\">\n"
     ."<tr>\n"
-    ."\t<th class=\"cntr\">". __('Title') ."</th>\n";
-
+    ."\t<th>". __('Title') ."</th>\n"
+    ."\t<th class=\"cntr\">". __('Feeds') ."</th>\n";
     if (getConfig('rss.config.absoluteordering')) {
         echo "\t<th>".__('Move')."</th>\n";
@@ -53 +53 @@
     ."</tr>\n";
 
-    $sql = "select id,name from " .getTable("folders");
+
+    $sql =
+        sprintf("select f.id, f.name, count(*) from %s f, %s c where c.parent=f.id group by id",
+                getTable('folders'), getTable('channels')
+               );
 
     if (getConfig('rss.config.absoluteordering')) {
-        $sql .=" order by position asc";
+        $sql .=" order by f.position asc";
     } else {
-        $sql .=" order by name asc";
-    }
+        $sql .=" order by f.name asc";
+    }
+
+
 
     $res = rss_query($sql);
     $cntr = 0;
-    while (list($id, $name) = rss_fetch_row($res)) {
+    while (list($id, $name, $cnt) = rss_fetch_row($res)) {
 
         $name = $name == ''? __('Root'):$name;
@@ -70 +76 @@
 
         echo "<tr class=\"$class_\">\n"
-        ."\t<td>$name</td>\n";
-
+        ."\t<td>$name</td>\n"
+        ."\t<td class=\"cntr\">$cnt</td>\n";
         if (getConfig('rss.config.absoluteordering')) {
             echo "\t<td>";
@@ -211 +217 @@
 
     case __('Add'):
-    case 'ACT_ADMIN_ADD':
-        $label=sanitize($_REQUEST['new_folder'],RSS_SANITIZER_URL);
+                case 'ACT_ADMIN_ADD':
+                        $label=sanitize($_REQUEST['new_folder'],RSS_SANITIZER_URL);
         $new_label = rss_real_escape_string($new_label);
         assert(strlen($label) > 0);
@@ -221 +227 @@
     case CST_ADMIN_MOVE_DOWN_ACTION:
 
-        if ($fid == 0) {
+if ($fid == 0) {
             return;
         }