Changeset 21836 for branches/version-2_12-dev/data/class

Timestamp:

2012/05/16 13:56:27 (12 years ago)

Author:

shutta

Message:

#1806 (管理画面ホームの「品切れ商品」が商品の削除を考慮していない)
削除済みの商品は対象から外すように修正。

File:

• branches/version-2_12-dev/data/class/pages/admin/LC_Page_Admin_Home.php (modified) (1 diff)

branches/version-2_12-dev/data/class/pages/admin/LC_Page_Admin_Home.php

@@ -232 +232 @@
         $where = 'product_id IN ('
                . 'SELECT product_id FROM dtb_products_class '
-               . 'WHERE stock_unlimited = ? AND stock <= 0)';
+               . 'WHERE stock_unlimited = ? AND stock <= 0)'
+               . ' AND del_flg = 0';
         return $objQuery->select($cols, $table, $where, array(UNLIMITED_FLG_LIMITED));
     }