DataObjects/Cms_page_category.php
authoredward <edward@roojs.com>
Thu, 8 Mar 2018 08:07:06 +0000 (16:07 +0800)
committeredward <edward@roojs.com>
Thu, 8 Mar 2018 08:07:06 +0000 (16:07 +0800)
DataObjects/Cms_page_category.php

index 2caf1d0..d232e72 100644 (file)
@@ -54,10 +54,13 @@ class Pman_Cms_DataObjects_Cms_page_category  extends DB_DataObject
                 join_page_id_id.page_type_id as page_id_page_type_id 
                                       
         ");
-        $cms_page_category->groupBy("cms_page_category.category_id,
-                                    join_category_id_id.title ,
-                                    join_page_id_id.page_type_id 
-                                    ");
+        $cms_page_category->groupBy("
+            cms_page_category.category_id,
+            join_category_id_id.is_draft
+            join_category_id_id.title ,
+            join_page_id_id.page_type_id 
+        ");
+        
         $cms_page_category->orderBy("cms_page_fullpath(cms_page_category.category_id, ' - ') ASC");
         
         foreach ($cms_page_category->fetchAll() as $s){