Changeset 18829 for branches/version-2_5-dev/data/class/SC_Product.php

Timestamp:

2010/09/27 19:30:37 (14 years ago)

Author:

nanasess

bzr:base-revision:

svn-v4:1e3b908f-19a9-db11-a64c-001125224ba8:branches/version-2_5-dev:18828

bzr:committer:

Kentaro Ohkouchi <ohkouchi@loop-az.jp>

bzr:file-ids:

data/Smarty/templates/default/detail.tpl 15747@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2FSmarty%2Ftemplates%2Fdefault%2Fdetail.tpl
data/Smarty/templates/default/list.tpl 15747@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2FSmarty%2Ftemplates%2Fdefault%2Flist.tpl
data/class/SC_Product.php 18277@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Fcomu-ver2%2Fdata%2Fclass%2FSC_Product.php
data/class/helper/SC_Helper_DB.php 15176@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fhelper%2FSC_Helper_DB.php
data/class/pages/cart/LC_Page_Cart.php 15179@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fcart%2FLC_Page_Cart.php
data/class/pages/products/LC_Page_Products_Detail.php 15154@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fproducts%2FLC_Page_Products_Detail.php
data/class/pages/products/LC_Page_Products_List.php 15154@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fproducts%2FLC_Page_Products_List.php
data/class/pages/shopping/LC_Page_Shopping_Complete.php 15223@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fshopping%2FLC_Page_Shopping_Complete.php
data/install.php 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Finstall.php

bzr:mapping-version:

v4

bzr:merge:

ohkouchi@loop-az.jp-20100927102325-k7kq5liftg1lhyoq

bzr:repository-uuid:

1e3b908f-19a9-db11-a64c-001125224ba8

bzr:revision-id:

ohkouchi@loop-az.jp-20100927103023-gxi8k3mun5ajq1th

bzr:revno:

2312

bzr:revprop:branch-nick:

branches/version-2_5-dev

bzr:root:

branches/version-2_5-dev

bzr:text-revisions:

data/Smarty/templates/default/list.tpl ohkouchi@loop-az.jp-20100927102325-k7kq5liftg1lhyoq
data/class/helper/SC_Helper_DB.php ohkouchi@loop-az.jp-20100927102325-k7kq5liftg1lhyoq
data/class/pages/cart/LC_Page_Cart.php ohkouchi@loop-az.jp-20100927102325-k7kq5liftg1lhyoq
data/class/pages/shopping/LC_Page_Shopping_Complete.php ohkouchi@loop-az.jp-20100927102325-k7kq5liftg1lhyoq

bzr:timestamp:

2010-09-27 19:30:23.668999910 +0900

bzr:user-agent:

bzr2.2.0+bzr-svn1.0.3

svn:original-date:

2010-09-27T10:30:23.669000Z

Message:

#781(規格のデータベースを木構造に)

• カートの中身を product_class_id で特定するように修正

File:

• branches/version-2_5-dev/data/class/SC_Product.php (modified) (7 diffs)

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

@@ -124 +124 @@
 
     /**
+     * 商品詳細情報と商品規格を取得する.
+     *
+     * @param integer $productClassId 商品規格ID
+     * @return array 商品詳細情報と商品規格の配列
+     */
+    function getDetailAndProductsClass($productClassId) {
+        $result = $this->getProductsClass($productClassId);
+        $result = array_merge($result, $this->getDetail($result['product_id']));
+        return $result;
+    }
+
+    /**
      * 商品IDに紐づく商品規格を自分自身に設定する.
      *
@@ -163 +175 @@
             $classCategories = array();
             $classCategories['']['']['name'] = '選択してください';
+            $classCategories['']['']['product_class_id'] = $arrProductClass[0]['product_class_id'];
+            $this->product_class_id[$productId] = $arrProductClass[0]['product_class_id'];
             foreach ($arrProductClass as $productsClass) {
                 $productsClass1 = $productsClass['classcategory_id1'];
@@ -201 +215 @@
                 // 商品コード
                 $classCategories[$productsClass1][$productsClass2]['product_code'] = $productsClass['product_code'];
+                // 商品規格ID
+                $classCategories[$productsClass1][$productsClass2]['product_class_id'] = $productsClass['product_class_id'];
             }
 
@@ -211 +227 @@
 
     /**
-     * 複数の商品IDに紐づいた, 商品規格を取得する.
-     *
-     * @param array $productIds 商品IDの配列
+     * SC_Query インスタンスに設定された検索条件を使用して商品規格を取得する.
+     *
+     * @param SC_Query $objQuery SC_Queryインスタンス
+     * @param array $params 検索パラメータの配列
      * @return array 商品規格の配列
      */
-    function getProductsClassByProductIds($productIds = array()) {
-        if (empty($productIds)) {
-            return array();
-        }
-        $objQuery =& SC_Query::getSingletonInstance();
-        $objQuery->setWhere('product_id IN (' . implode(', ', array_pad(array(), count($productIds), '?')) . ')');
-        $objQuery->setOrder("T2.level DESC");
+    function getProductsClassByQuery(&$objQuery, $params) {
         // 末端の規格を取得
         $col = <<< __EOS__
@@ -254 +265 @@
                    ON T3.class_id = T4.class_id
 __EOS__;
-        $arrRet = $objQuery->select($col, $table, "", $productIds);
+        $arrRet = $objQuery->select($col, $table, "", $params);
         $levels = array();
         $parents = array();
@@ -317 +328 @@
 
     /**
+     * 商品規格IDから商品規格を取得する.
+     */
+    function getProductsClass($productClassId) {
+        $objQuery =& SC_Query::getSingletonInstance();
+        $objQuery->setWhere('product_class_id = ?');
+        $objQuery->setOrder("T2.level DESC");
+        $results = $this->getProductsClassByQuery($objQuery, $productClassId);
+        $productsClass = $this->getProductsClassFull($results);
+        return $productsClass[0];
+    }
+
+    /**
+     * 複数の商品IDに紐づいた, 商品規格を取得する.
+     *
+     * @param array $productIds 商品IDの配列
+     * @return array 商品規格の配列
+     */
+    function getProductsClassByProductIds($productIds = array()) {
+        if (empty($productIds)) {
+            return array();
+        }
+        $objQuery =& SC_Query::getSingletonInstance();
+        $objQuery->setWhere('product_id IN (' . implode(', ', array_pad(array(), count($productIds), '?')) . ')');
+        $objQuery->setOrder("T2.level DESC");
+        return $this->getProductsClassByQuery($objQuery, $productIds);
+    }
+
+    /**
      * 商品IDに紐づいた, 商品規格を階層ごとに取得する.
      *
-     * @param array $productId 商品IDの配列
+     * @param array $productId 商品ID
      * @return array 階層ごとの商品規格の配列
      */
     function getProductsClassLevelByProductId($productId) {
         $results = $this->getProductsClassByProductIds(array($productId));
-        foreach ($results as $row) {
+        return $this->getProductsClassLevel($results);
+    }
+
+    /**
+     * 商品IDに紐づいた, 商品規格をすべての組み合わせごとに取得する.
+     *
+     * @param array $productId 商品ID
+     * @return array すべての組み合わせの商品規格の配列
+     */
+    function getProductsClassFullByProductId($productId) {
+        $results = $this->getProductsClassByProductIds(array($productId));
+        return $this->getProductsClassFull($results);
+    }
+
+    /**
+     * 商品規格の配列から, 商品規格を階層ごとに取得する.
+     *
+     * @access private
+     * @param array $productsClassResults 商品規格の結果の配列
+     * @return array 階層ごとの商品規格の配列
+     */
+    function getProductsClassLevel($productsClassResults) {
+        foreach ($productsClassResults as $row) {
             $productsClassLevel["level" . $row['level']][] = $row;
         }
@@ -331 +392 @@
 
     /**
-     * 商品IDに紐づいた, 商品規格をすべての組み合わせごとに取得する.
-     *
-     * @param array $productId 商品IDの配列
-     * @return array すべての組み合わせの商品規格の配列
-     */
-    function getProductsClassFullByProductId($productId) {
-        $results = $this->getProductsClassLevelByProductId($productId);
+     * 商品規格の配列から, 商品規格のすべての組み合わせを取得する.
+     *
+     * @access private
+     * @param array $productsClassResults 商品規格の結果の配列
+     * @ array 階層ごとの商品規格の配列
+     */
+    function getProductsClassFull($productsClassResults) {
+        $results = $this->getProductsClassLevel($productsClassResults);
         $productsClass = array();
-        if (SC_Utils_Ex::isBlank($results["level1"]) && SC_Utils_Ex::isBlank($results["level2"])) {
+        if (SC_Utils_Ex::isBlank($results["level1"])
+            && SC_Utils_Ex::isBlank($results["level2"])) {
             return $results["level"];
         }