Changeset 17548

Timestamp:

2008/08/20 07:01:31 (16 years ago)

Author:

Seasoft

Message:

管理画面 - 商品管理 - 商品マスタ
複数の規格を有する商品が複数行表示される不具合の応急処置。

File:

• branches/comu-ver2/data/class/pages/admin/products/LC_Page_Admin_Products.php (modified) (1 diff)

branches/comu-ver2/data/class/pages/admin/products/LC_Page_Admin_Products.php

@@ -280 +280 @@
                 default:
                     // 読み込む列とテーブルの指定
-                    $col = "product_id, name, category_id, main_list_image, status, product_code_min, product_code_max, price02_min, price02_max, stock_min, stock_max, stock_unlimited_min, stock_unlimited_max";
+                    // XXX DISTINCT は応急処置。update_date は DISTINCT のため。
+                    $col = "DISTINCT product_id, name, main_list_image, status, product_code_min, product_code_max, price02_min, price02_max, stock_min, stock_max, stock_unlimited_min, stock_unlimited_max, update_date";
                     $from = "vw_products_allclass AS allcls ";