Changeset 17500

Timestamp:

2008/08/06 11:33:47 (16 years ago)

Author:

nakanishi

Message:

#263 カテゴリ検索が機能していない問題を修正

File:

• branches/version-2/data/class/pages/admin/contents/LC_Page_Admin_Contents_CampaignCreateTag.php (modified) (3 diffs)

branches/version-2/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':
@@ -169 +162 @@
     }
 
-    /* 取得文字列の変換 */
+
+    /**
+     * 取得する文字数の変換を行うメソッド
+     *
+     * @return void
+     */
     function lfConvertParam() {
         /*
@@ -190 +188 @@
     }
 
-    /* タグを生成 */
+    /**
+     * キャンペーンページのための商品用タグを生成するメソッド
+     *
+     * @param string $product_id 商品ID
+     * @return void
+     */
+    
     function lfGetCreateTag($product_id) {
         // 書き込みタグ