Changeset 23664 for branches

Timestamp:

2014/10/27 11:22:40 (9 years ago)

Author:

Seasoft

Message:

#2644 (SC_DB_DBFactory::alldtlSQL から class_count を削除)

Location:

branches/version-2_13-dev

Files:

• data/class/db/SC_DB_DBFactory.php (modified) (1 diff)
• data/class/db/dbfactory/SC_DB_DBFactory_PGSQL.php (modified) (1 diff)
• tests/class/SC_CartSession/SC_CartSession_getCartListTest.php (modified) (1 diff)
• tests/class/SC_Product/SC_Product_getDetailAndProductsClassTest.php (modified) (1 diff)
• tests/class/SC_Product/SC_Product_getDetailTest.php (modified) (1 diff)

branches/version-2_13-dev/data/class/db/SC_DB_DBFactory.php

@@ -268 +268 @@
                     ,T4.point_rate
                     ,T4.deliv_fee
-                    ,T4.class_count
                     ,dtb_maker.name AS maker_name
                 FROM dtb_products
                     INNER JOIN (
-                        SELECT product_id,
-                            MIN(product_code) AS product_code_min,
-                            MAX(product_code) AS product_code_max,
-                            MIN(price01) AS price01_min,
-                            MAX(price01) AS price01_max,
-                            MIN(price02) AS price02_min,
-                            MAX(price02) AS price02_max,
-                            MIN(stock) AS stock_min,
-                            MAX(stock) AS stock_max,
-                            MIN(stock_unlimited) AS stock_unlimited_min,
-                            MAX(stock_unlimited) AS stock_unlimited_max,
-                            MAX(point_rate) AS point_rate,
-                            MAX(deliv_fee) AS deliv_fee,
-                            COUNT(*) as class_count
+                        SELECT product_id
+                            ,MIN(product_code) AS product_code_min
+                            ,MAX(product_code) AS product_code_max
+                            ,MIN(price01) AS price01_min
+                            ,MAX(price01) AS price01_max
+                            ,MIN(price02) AS price02_min
+                            ,MAX(price02) AS price02_max
+                            ,MIN(stock) AS stock_min
+                            ,MAX(stock) AS stock_max
+                            ,MIN(stock_unlimited) AS stock_unlimited_min
+                            ,MAX(stock_unlimited) AS stock_unlimited_max
+                            ,MAX(point_rate) AS point_rate
+                            ,MAX(deliv_fee) AS deliv_fee
                         FROM dtb_products_class
                         WHERE del_flg = 0 $where_products_class

branches/version-2_13-dev/data/class/db/dbfactory/SC_DB_DBFactory_PGSQL.php

@@ -318 +318 @@
                     ,(SELECT MAX(point_rate) $sub_base) AS point_rate
                     ,(SELECT MAX(deliv_fee) $sub_base) AS deliv_fee
-                    ,(SELECT COUNT(*) $sub_base) AS class_count
                 FROM dtb_products
                     LEFT JOIN dtb_maker

branches/version-2_13-dev/tests/class/SC_CartSession/SC_CartSession_getCartListTest.php

@@ -142 +142 @@
             ,'point_rate' => '0'
             ,'deliv_fee' => null
-            ,'class_count' => '1'
             ,'maker_name' => null
             ,'stock' => '99'

branches/version-2_13-dev/tests/class/SC_Product/SC_Product_getDetailAndProductsClassTest.php

@@ -90 +90 @@
                 ,'point_rate' => '0'
                 ,'deliv_fee' => null
-                ,'class_count' => '1'
                 ,'maker_name' => null
                 ,'stock' => '99'

branches/version-2_13-dev/tests/class/SC_Product/SC_Product_getDetailTest.php

@@ -90 +90 @@
                 ,'point_rate' => '0'
                 ,'deliv_fee' => null
-                ,'class_count' => '1'
                 ,'maker_name' => null
         );