Changeset 22595 for branches/version-2_12-dev/data/class/helper/SC_Helper_Category.php

Timestamp:

2013/03/01 22:21:08 (11 years ago)

Author:

pineray

Message:

#2166 カテゴリー情報の取得処理をヘルパークラスへ移動

File:

• branches/version-2_12-dev/data/class/helper/SC_Helper_Category.php (modified) (2 diffs)

branches/version-2_12-dev/data/class/helper/SC_Helper_Category.php

@@ -41 +41 @@
     {
         $this->count_check = $count_check;
+    }
+
+    /**
+     * カテゴリーの情報を取得.
+     * 
+     * @param integer $category_id カテゴリーID
+     * @return array
+     */
+    public function get($category_id)
+    {
+        $objQuery =& SC_Query_Ex::getSingletonInstance();
+        $col = '*';
+        $from = 'dtb_category left join dtb_category_total_count ON dtb_category.category_id = dtb_category_total_count.category_id';
+        $where = 'dtb_category.category_id = ? AND del_flg = 0';
+        // 登録商品数のチェック
+        if ($this->count_check) {
+            $where .= ' AND product_count > 0';
+        }
+        $arrRet = $objQuery->getRow($col, $from, $where, array($category_id));
+        return $arrRet;
     }
 
@@ -88 +108 @@
         return $arrTree;
     }
+
+    /**
+     * 親カテゴリーIDの配列を取得.
+     * 
+     * @param integer $category_id 起点のカテゴリーID
+     * @return array
+     */
+    public function getTreeTrail($category_id)
+    {
+        $arrCategory = $this->getList();
+        $arrTrailID = SC_Utils_Ex::getTreeTrail($category_id, 'category_id', 'parent_category_id', $arrCategory);
+        return $arrTrailID;
+    }
 }