Changeset 16824 for branches/feature-module-update/data/class

Timestamp:

2007/11/28 14:11:55 (19 years ago)

Author:

satou

Message:

#190
修正しました。

File:

• branches/feature-module-update/data/class/pages/admin/products/LC_Page_Admin_Products_ProductSelect.php (modified) (1 diff)

branches/feature-module-update/data/class/pages/admin/products/LC_Page_Admin_Products_ProductSelect.php

@@ -85 +85 @@
                 switch ($key) {
                 case 'search_name':
-                    $where .= " AND name ILIKE ?";
+                    $where .= " AND name LIKE ?";
                     $arrval[] = "%$val%";
                     break;
                 case 'search_category_id':
-                    // 子カテゴリIDの取得
-                    $arrRet = $objDb->sfGetChildsID("dtb_category", "parent_category_id", "category_id", $val);
-                    $tmp_where = "";
-                    foreach ($arrRet as $val) {
-                        if($tmp_where == "") {
-                            $tmp_where.= " AND ( category_id = ?";
-                        } else {
-                            $tmp_where.= " OR category_id = ?";
-                        }
-                        $arrval[] = $val;
+                    list($tmp_where, $tmp_arrval) = $objDb->sfGetCatWhere($val);
+                    if($tmp_where != "") {
+                        $where.= " AND product_id IN (SELECT product_id FROM dtb_product_categories WHERE " . $tmp_where . ")";
+                        $arrval = array_merge((array)$arrval, (array)$tmp_arrval);
                     }
-                    $where.= $tmp_where . " )";
                     break;
                 case 'search_product_code':
-                    $where .= " AND product_id IN (SELECT product_id FROM dtb_products_class WHERE product_code ILIKE ? GROUP BY product_id)";
+                    $where .= " AND product_id IN (SELECT product_id FROM dtb_products_class WHERE product_code LIKE ? GROUP BY product_id)";
                     $arrval[] = "$val%";
                     break;