Changeset 17226 for branches/version-2/data/class/pages/admin/products/LC_Page_Admin_Products_Category.php
- Timestamp:
- 2008/04/07 13:29:15 (16 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2/data/class/pages/admin/products/LC_Page_Admin_Products_Category.php
r17207 r17226 126 126 } 127 127 // 登録商品のチェック 128 $where = "category_id = ? AND del_flg = 0"; 129 $count = $objQuery->count("dtb_products", $where, array($_POST['category_id'])); 128 $table = "dtb_product_categories AS T1 LEFT JOIN dtb_products AS T2 ON T1.product_id = T2.product_id"; 129 $where = "T1.category_id = ? AND T2.del_flg = 0"; 130 $count = $objQuery->count($table, $where, array($_POST['category_id'])); 130 131 if($count != 0) { 131 132 $this->arrErr['category_name'] = "※ カテゴリ内に商品が存在するため削除できません。<br>";
Note: See TracChangeset
for help on using the changeset viewer.