Changeset 18821 for branches/version-2_5-dev/data

Timestamp:

2010/09/22 15:36:18 (16 years ago)

Author:

nanasess

bzr:base-revision:

[email protected]

bzr:committer:

Kentaro Ohkouchi <[email protected]>

bzr:file-ids:

data/class/SC_Product.php 18277@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Fcomu-ver2%2Fdata%2Fclass%2FSC_Product.php
data/install.php 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Finstall.php
html/install/sql/insert_data.sql 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Fsql%2Finsert_data.sql

bzr:mapping-version:

v4

bzr:merge:

[email protected]

bzr:repository-uuid:

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

bzr:revision-id:

[email protected]

bzr:revno:

2304

bzr:revprop:branch-nick:

branches/version-2_5-dev

bzr:root:

branches/version-2_5-dev

bzr:timestamp:

2010-09-22 15:36:15.023999929 +0900

bzr:user-agent:

bzr2.2.0+bzr-svn1.0.3

svn:original-date:

2010-09-22T06:36:15.024000Z

Message:

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

• ポイントの表示が不正だったのを修正

File:

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

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

@@ -371 +371 @@
             $whereCause = " WHERE " . $where;
         }
-
+        /*
+         * point_rate は商品規格(dtb_products_class)ごとに保持しているが,
+         * 商品(dtb_products)ごとの設定なので MAX のみを取得する.
+         */
         $sql = <<< __EOS__
             (
@@ -436 +439 @@
                     T4.stock_unlimited_min,
                     T4.stock_unlimited_max,
+                    T4.point_rate,
                     T4.class_count
                FROM dtb_products
@@ -450 +454 @@
                               MIN(stock_unlimited) AS stock_unlimited_min,
                               MAX(stock_unlimited) AS stock_unlimited_max,
+                              MAX(point_rate) AS point_rate,
                               COUNT(*) as class_count
                          FROM dtb_products_class