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

Timestamp:

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

Author:

Qwert

Message:

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

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

Location:

branches/version-2_12-dev/data

Files:

• Smarty/templates/admin/contents/recommend.tpl (modified) (1 diff)
• Smarty/templates/admin/contents/recommend_search.tpl (modified) (3 diffs)
• class/pages/admin/contents/LC_Page_Admin_Contents_Recommend.php (modified) (1 diff)
• class/pages/admin/contents/LC_Page_Admin_Contents_RecommendSearch.php (modified) (2 diffs)

branches/version-2_12-dev/data/Smarty/templates/admin/contents/recommend.tpl

@@ -85 +85 @@
 <div id="admin-contents" class="contents-main">
     <!--{section name=cnt loop=$tpl_disp_max}-->
-    <div class="recommend-product">
+    <div class="recommend-product <!--{if $arrItems[$smarty.section.cnt.iteration].status == "2"}-->hidden<!--{/if}-->">
         <table class="list center recommend-table">
             <col width="13%" />

branches/version-2_12-dev/data/Smarty/templates/admin/contents/recommend_search.tpl

@@ -66 +66 @@
             <td><input type="text" name="search_name" value="<!--{$arrForm.search_name}-->" size="35" class="box35" /></td>
         </tr>
+        <tr>
+            <th>商品ステータス</th>
+            <td>
+                <input type="hidden" name="search_status" value="1" />
+                <label>
+                    <input type="checkbox" name="search_status" value="" <!--{if $arrForm.search_status === ""}-->checked<!--{/if}--> />
+                    非公開の商品を含む
+                </label>
+            </td>
+        </tr>
     </table>
     <div class="btn-area">
@@ -77 +87 @@
     <!--{$tpl_strnavi}-->
 
-    <table class="list">
+    <table id="recommend-search-results" class="list">
         <col width="15%" />
         <col width="12.5%" />
@@ -91 +101 @@
         <!--{foreach name=loop from=$arrProducts item=arr}-->
         <!--▼商品<!--{$smarty.foreach.loop.iteration}-->-->
-        <tr>
+        <tr class="<!--{if $arr.status == "2"}-->hidden<!--{/if}-->">
             <td class="center">
                 <img src="<!--{$smarty.const.ROOT_URLPATH}-->resize_image.php?image=<!--{$arr.main_list_image|sfNoImageMainList|h}-->&width=65&height=65" alt="" />

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: