Changeset 17834 for branches/version-2/data/class/pages/admin/products/LC_Page_Admin_Products.php

Timestamp:

2009/02/25 22:20:49 (14 years ago)

Author:

kajiwara

Message:

#425 adminモードにて商品の一括削除ができない不具合を解消

File:

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

branches/version-2/data/class/pages/admin/products/LC_Page_Admin_Products.php

@@ -268 +268 @@
                     break;
                 case 'delete_all':
+                    // 検索結果の取得
+                    $col = "product_id";
+                    $from = "vw_products_nonclass AS noncls ";
+                    $arrProducts = $objQuery->select($col, $from, $where, $arrval);
                     // 検索結果をすべて削除
-                    $where = "product_id IN (SELECT product_id FROM vw_products_nonclass AS noncls  WHERE $where)";
                     $sqlval['del_flg'] = 1;
-                    $objQuery->update("dtb_products", $sqlval, $where, $arrval);
+                    $where = "product_id = ?";
+                    if (count($arrProducts) > 0) {
+                        foreach ($arrProducts as $key => $val) {
+                            $objQuery->update("dtb_products", $sqlval, $where, array($arrProducts[$key]["product_id"]));
+                        }
+                    }
                     break;
                 default: