Changeset 23458 for branches/version-2_13-dev/data/class/SC_Product.php

Timestamp:

2014/05/29 13:59:35 (10 years ago)

Author:

pineray

Message:

#2515 無駄な処理を改善する for 2.13.3

LC_Page_Products_Detail での関連カテゴリーの取得を、SC_Helper_Category を使った形に変更.

File:

• branches/version-2_13-dev/data/class/SC_Product.php (modified) (1 diff)

branches/version-2_13-dev/data/class/SC_Product.php

@@ -687 +687 @@
         return $tablename . 'del_flg = 0 AND ' . $tablename . 'status = 1 ';
     }
+
+    /**
+     * 商品が属しているカテゴリーIDを取得する.
+     *
+     * @param int $product_id
+     * @param bool $include_hidden
+     * @return array
+     */
+    public function getCategoryIds($product_id, $include_hidden = false) {
+        if ($include_hidden) {
+            $where = '';
+        } else {
+            $where = 'status = 1';
+        }
+
+        if (SC_Utils_Ex::sfIsInt($product_id) && $product_id != 0 && SC_Helper_DB_Ex::sfIsRecord('dtb_products','product_id', array($product_id), $where)) {
+            $objQuery =& SC_Query_Ex::getSingletonInstance();
+            $category_id = $objQuery->getCol('category_id', 'dtb_product_categories', 'product_id = ?', array($product_id));
+        } else {
+            // 不正な場合は、空の配列を返す。
+            $category_id = array();
+        }
+
+        return $category_id;
+    }
 }