Changeset 976

Timestamp:

01/14/12 19:32:18 (4 months ago)

Author:

fuze

Message:

количество объявлений при просмотре списка категорий: учитываются подкатегории

Location:

branches/fuze

Files:

• .htaccess (modified) (1 diff)
• components/board/model.php (modified) (3 diffs)

branches/fuze/.htaccess

@@ -6 +6 @@
 RewriteRule ^.htaccess$ - [F]
 
-RewriteCond %{REQUEST_URI} !\.(jpg|jpeg|ico|gif|png|css|xml|js|pl|txt)$ [NC]
 RewriteCond %{REQUEST_FILENAME} !^/admin
 RewriteCond %{REQUEST_FILENAME} !^/migrate

branches/fuze/components/board/model.php

@@ -231 +231 @@
 /* ==================================================================================================== */
 /* ==================================================================================================== */
-
+    /**
+     * Возвращает категории
+     * @param int $category_id - id категории
+     * @return array
+     */
     public function getSubCats($category_id) {
         $cats = array();
 
-        $sql = "SELECT c.*, IFNULL(COUNT(i.id), 0) as content_count
+        $sql = "SELECT c.*
                 FROM cms_board_cats c
                 LEFT JOIN cms_board_items i ON i.category_id = c.id AND i.published = 1
                 WHERE c.published = 1 AND c.parent_id = '$category_id'
-                GROUP BY c.id
                 ORDER BY title ASC";
         $result = $this->inDB->query($sql);
@@ -249 +252 @@
                 $cat['obtypes'] = $this->inDB->get_field('cms_board_cats', "NSLeft <= {$cat['NSLeft']} AND NSRight >= {$cat['NSRight']} AND obtypes <> ''", 'obtypes');
             }
+                        $cat['content_count'] = $this->getAdvertsCountFromCat($cat['NSLeft'], $cat['NSRight']);
                         $cat['ob_links'] = $this->getTypesLinks($cat['id'], $cat['obtypes']);
                         $cat['icon'] = $cat['icon'] ? $cat['icon'] : 'folder_grey.png';
@@ -257 +261 @@
             
         return $cats;
+    }
+
+    /**
+     * Возвращает количество объвлений в категории и подкатегориях
+     * @return int
+     */
+    public function getAdvertsCountFromCat($left_key, $right_key) {
+
+                $sql = "SELECT i.id
+                                FROM cms_board_items i
+                                INNER JOIN cms_board_cats cat ON cat.id = i.category_id AND cat.NSLeft >= '$left_key' AND cat.NSRight <= '$right_key'
+                                WHERE i.published = 1";
+
+        $result = $this->inDB->query($sql);
+
+        return $this->inDB->num_rows($result);
+
     }