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

Timestamp:

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

Author:

satou

Message:

#190
修正しました。

Location:

branches/feature-module-update/data

Files:

• Smarty/templates/default/admin/products/product_select.tpl (modified) (2 diffs)
• class/pages/admin/products/LC_Page_Admin_Products_ProductSelect.php (modified) (1 diff)

branches/feature-module-update/data/Smarty/templates/default/admin/products/product_select.tpl

@@ -30 +30 @@
 <meta http-equiv="content-script-type" content="text/javascript" />
 <meta http-equiv="content-style-type" content="text/css" />
+<link rel="stylesheet" href="<!--{$smarty.const.URL_ADMIN_CSS}-->common.css" type="text/css" media="all" />
 <script type="text/javascript" src="<!--{$TPL_DIR}-->js/css.js"></script>
 <script type="text/javascript" src="<!--{$TPL_DIR}-->js/navi.js"></script>
@@ -132 +133 @@
         <!--{/section}-->
     </table>
+    <br />
+    <br />
     <!--{/if}-->
     <!--▲検索結果表示-->

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;