Changeset 22559 for branches/version-2_12-dev/data/class

Timestamp:

2013/02/18 12:18:22 (11 years ago)

Author:

Qwert

Message:

#2143 「おすすめ商品の検索画面にて非公開の商品もリストアップされる」を修正

おすすめ商品管理・おすすめ商品検索画面で非公開の商品のセルは色付きに。またおすすめ商品検索画面で検索条件に商品ステータスを追加。

Location:

branches/version-2_12-dev/data/class/pages/admin/contents

Files:

• LC_Page_Admin_Contents_Recommend.php (modified) (1 diff)
• LC_Page_Admin_Contents_RecommendSearch.php (modified) (2 diffs)

branches/version-2_12-dev/data/class/pages/admin/contents/LC_Page_Admin_Contents_Recommend.php

@@ -175 +175 @@
     function getRecommendProducts() {
         $objQuery = $objQuery =& SC_Query_Ex::getSingletonInstance();
-        $col = 'dtb_products.name,dtb_products.main_list_image,dtb_best_products.*';
+        $col = 'dtb_products.name,dtb_products.main_list_image,dtb_best_products.*,dtb_products.status';
         $table = 'dtb_best_products INNER JOIN dtb_products ON dtb_best_products.product_id = dtb_products.product_id';
         $where = 'dtb_best_products.del_flg = 0';

branches/version-2_12-dev/data/class/pages/admin/contents/LC_Page_Admin_Contents_RecommendSearch.php

@@ -125 +125 @@
         $objFormParam->addParam('商品ID', 'search_category_id', INT_LEN, 'n', array('MAX_LENGTH_CHECK','NUM_CHECK'));
         $objFormParam->addParam('商品コード', 'search_product_code', LTEXT_LEN, 'KVa', array('MAX_LENGTH_CHECK'));
+        $objFormParam->addParam('商品ステータス', 'search_status', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'));
         $objFormParam->addParam('ページ番号', 'search_pageno', INT_LEN, 'n', array('MAX_LENGTH_CHECK','NUM_CHECK'));
     }
@@ -169 +170 @@
                     $where .=    ' AND alldtl.product_id IN (SELECT product_id FROM dtb_products_class WHERE product_code LIKE ? GROUP BY product_id)';
                     $bind[] = '%'.$val.'%';
+                    break;
+                case 'search_status':
+                    $where .= ' AND alldtl.status = ?';
+                    $bind[] = $val;
                     break;
                 default: