Changeset 22586 for branches/version-2_12-dev/data/class

Timestamp:

2013/02/28 09:30:36 (13 years ago)

Author:

pineray

Message:

#2166 カテゴリーツリーのデータをツリー状に取得

Location:

branches/version-2_12-dev/data/class

Files:

• pages/frontparts/bloc/LC_Page_FrontParts_Bloc_Category.php (modified) (3 diffs)
• util/SC_Utils.php (modified) (1 diff)

branches/version-2_12-dev/data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_Category.php

@@ -132 +132 @@
         $objQuery =& SC_Query_Ex::getSingletonInstance();
         $objDb = new SC_Helper_DB_Ex();
+
         $col = '*';
         $from = 'dtb_category left join dtb_category_total_count ON dtb_category.category_id = dtb_category_total_count.category_id';
@@ -142 +143 @@
         $objQuery->setOption('ORDER BY rank DESC');
         $arrRet = $objQuery->select($col, $from, $where);
+
+        $arrTree = SC_Utils_Ex::buildTree('category_id', 'parent_category_id', 10, $arrRet);
+
         foreach ($arrParentCategoryId as $category_id) {
             $arrParentID = $objDb->sfGetParents(
@@ -162 +166 @@
             );
             $this->root_parent_id[] = $arrParentID[0];
-            $arrDispID = array_merge($arrBrothersID, $arrChildrenID);
-            foreach ($arrRet as &$arrCategory) {
-                if (in_array($arrCategory['category_id'], $arrDispID)) {
-                    $arrCategory['display'] = 1;
-                }
-            }
-        }
-        return $arrRet;
+            $this->arrDispID = array_merge($arrBrothersID, $arrChildrenID);
+        }
+
+        return $arrTree;
     }
 

branches/version-2_12-dev/data/class/util/SC_Utils.php

@@ -1922 +1922 @@
         return $return;
     }
+
+    /**
+     * 
+     * @param string $primary_key
+     * @param string $glue_key
+     * @param integer $max_depth
+     * @param array $correction
+     * @param integer $base_id
+     * @return array ツリーの配列
+     */
+    public static function buildTree($primary_key, $glue_key, $max_depth, $correction = array(), $base_id = 0)
+    {
+        $children = array();
+        foreach ($correction as $child) {
+            $children[$child[$glue_key]][] = $child;
+        }
+        $arrTree = $children[$base_id];
+        foreach ($arrTree as &$child) {
+            SC_Utils_Ex::addChild($child, $primary_key, 1, $max_depth, $children);
+        }
+        return $arrTree;
+    }
+
+    /**
+     * ツリーの親子をつなげるルーチン.
+     * 
+     * @param array $target 親
+     * @param string $primary_key 主キーの識別子
+     * @param integer $level 親の階層
+     * @param integer $max_depth 階層の深さの最大値
+     * @param array $children 子の配列（キーが親ID）
+     * @return void
+     */
+    public static function addChild(&$target, $primary_key, $level, $max_depth, &$children = array())
+    {
+        if (isset($children[$target[$primary_key]])) {
+            $target['children'] = $children[$target[$primary_key]];
+            if ($level + 1 < $max_depth) {
+                foreach ($target['children'] as &$child) {
+                    SC_Utils_Ex::addChild($child, $primary_key, $level++, $max_depth, $children);
+                }
+            }
+        }
+    }
 }