Changeset 17226 for branches/version-2/data/class/pages/admin

Timestamp:

2008/04/07 13:29:15 (18 years ago)

Author:

satou

Message:

fixed by pineray (merge r17190:r17191)

Location:

branches/version-2/data/class/pages/admin/products

Files:

• LC_Page_Admin_Products.php (modified) (1 diff)
• LC_Page_Admin_Products_Category.php (modified) (1 diff)

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

@@ -312 +312 @@
                     // 検索結果の取得
                     $this->arrProducts = $objQuery->select($col, $from, $where, $arrval);
+
+                    // 各商品ごとのカテゴリIDを取得
+                    if (count($this->arrProducts) > 0) {
+                        foreach ($this->arrProducts as $key => $val) {
+                            $this->arrProducts[$key]["categories"] = $objDb->sfGetCategoryId($val["product_id"]);
+                            $objDb->g_category_on = false;
+                        }
+                    }
                 }
             }

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

@@ -126 +126 @@
             }
             // 登録商品のチェック
-            $where = "category_id = ? AND del_flg = 0";
-            $count = $objQuery->count("dtb_products", $where, array($_POST['category_id']));
+            $table = "dtb_product_categories AS T1 LEFT JOIN dtb_products AS T2 ON T1.product_id = T2.product_id";
+            $where = "T1.category_id = ? AND T2.del_flg = 0";
+            $count = $objQuery->count($table, $where, array($_POST['category_id']));
             if($count != 0) {
                 $this->arrErr['category_name'] = "※ カテゴリ内に商品が存在するため削除できません。<br>";