Changeset 17289

Timestamp:

2008/04/25 17:39:16 (15 years ago)

Author:

pineray

Message:

キャンペーン管理の商品設定でカテゴリを指定すると検索できない不具合を修正

File:

• branches/comu-ver2/data/class/pages/admin/contents/LC_Page_Admin_Contents_CampaignCreateTag.php (modified) (1 diff)

branches/comu-ver2/data/class/pages/admin/contents/LC_Page_Admin_Contents_CampaignCreateTag.php

@@ -87 +87 @@
                     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_id':
-                    if($val != "") {
-                        $where .= " AND product_id = ?";
-                        if(!SC_Utils_Ex::sfIsInt($val)) $val = 0;
-                        $arrval[] = $val;
-                    }
+                    $where .= " AND product_id IN (SELECT product_id FROM dtb_products_class WHERE product_code LIKE ? GROUP BY product_id)";
+                    $arrval[] = "$val%";
                     break;
                 default: