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

Timestamp:

2008/08/21 00:02:54 (16 years ago)

Author:

Seasoft

Message:

・VIEWを改訂。簡素化と高速化を目論む。(従来互換を考慮していますが、影響範囲が大きいので不具合もあるかと思います。また、MySQL v4系は、環境が無いため未テストです。バグレポートをお願いします。)
・r17509 の不具合対応。
・r17548 の応急処置を正式に対応。
・[検索結果をすべて削除]でエラーが発生する不具合を修正。

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

@@ -273 +273 @@
                 case 'delete_all':
                     // 検索結果をすべて削除
-                    $where = "product_id IN (SELECT product_id FROM vw_products_allclass AS allcls  WHERE $where)";
+                    $where = "product_id IN (SELECT product_id FROM vw_products_allclass_detail AS alldtl WHERE $where)";
                     $sqlval['del_flg'] = 1;
                     $objQuery->update("dtb_products", $sqlval, $where, $arrval);
-                    $objQuery->delete("dtb_customer_favorite_products", $where);
+                    $objQuery->delete("dtb_customer_favorite_products", $where, $arrval);
                     break;
                 default:
                     // 読み込む列とテーブルの指定
-                    // 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 ";
+                    $col = "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_detail AS alldtl ";
 
                     // 行数の取得