[Svn-src-all:3647] [version-2_12-dev 22559] #2143 「おすすめ商品の検索画面にて非公開の商品もリストアップされる」を修正

Qwert admin @ mail.ec-cube.net
2013年 2月 18日 (月) 12:18:22 JST


Subversion committed to /home/svn/open 22559
http://svn.ec-cube.net/open_trac/changeset/22559
┌────────────────────────────┐
│更新者 :  Qwert                                        │
│更新日時:  2013-02-18 12:18:22 +0900 (月, 18  2月 2013)│
└────────────────────────────┘

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

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

Changed:                      [U:修正,A:追加,D:削除]
--------------------------------------------------------
U   branches/version-2_12-dev/data/Smarty/templates/admin/contents/recommend.tpl
U   branches/version-2_12-dev/data/Smarty/templates/admin/contents/recommend_search.tpl
U   branches/version-2_12-dev/data/class/pages/admin/contents/LC_Page_Admin_Contents_Recommend.php
U   branches/version-2_12-dev/data/class/pages/admin/contents/LC_Page_Admin_Contents_RecommendSearch.php
U   branches/version-2_12-dev/html/user_data/packages/admin/css/admin_contents.css

変更: branches/version-2_12-dev/data/Smarty/templates/admin/contents/recommend.tpl
===================================================================
--- branches/version-2_12-dev/data/Smarty/templates/admin/contents/recommend.tpl	2013-02-18 03:06:08 UTC (rev 22558)
+++ branches/version-2_12-dev/data/Smarty/templates/admin/contents/recommend.tpl	2013-02-18 03:18:22 UTC (rev 22559)
@@ -84,7 +84,7 @@
 
 <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%" />
             <col width="73%" />

変更: branches/version-2_12-dev/data/Smarty/templates/admin/contents/recommend_search.tpl
===================================================================
--- branches/version-2_12-dev/data/Smarty/templates/admin/contents/recommend_search.tpl	2013-02-18 03:06:08 UTC (rev 22558)
+++ branches/version-2_12-dev/data/Smarty/templates/admin/contents/recommend_search.tpl	2013-02-18 03:18:22 UTC (rev 22559)
@@ -65,6 +65,16 @@
             <th>商品名</th>
             <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">
         <ul>
@@ -76,7 +86,7 @@
     <p><!--{$tpl_linemax}-->件が該当しました。</p>
     <!--{$tpl_strnavi}-->
 
-    <table class="list">
+    <table id="recommend-search-results" class="list">
         <col width="15%" />
         <col width="12.5%" />
         <col width="60%" />
@@ -90,7 +100,7 @@
 
         <!--{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="" />
             </td>

変更: branches/version-2_12-dev/data/class/pages/admin/contents/LC_Page_Admin_Contents_Recommend.php
===================================================================
--- branches/version-2_12-dev/data/class/pages/admin/contents/LC_Page_Admin_Contents_Recommend.php	2013-02-18 03:06:08 UTC (rev 22558)
+++ branches/version-2_12-dev/data/class/pages/admin/contents/LC_Page_Admin_Contents_Recommend.php	2013-02-18 03:18:22 UTC (rev 22559)
@@ -174,7 +174,7 @@
      */
     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';
         $order = 'rank';

変更: branches/version-2_12-dev/data/class/pages/admin/contents/LC_Page_Admin_Contents_RecommendSearch.php
===================================================================
--- branches/version-2_12-dev/data/class/pages/admin/contents/LC_Page_Admin_Contents_RecommendSearch.php	2013-02-18 03:06:08 UTC (rev 22558)
+++ branches/version-2_12-dev/data/class/pages/admin/contents/LC_Page_Admin_Contents_RecommendSearch.php	2013-02-18 03:18:22 UTC (rev 22559)
@@ -124,6 +124,7 @@
         $objFormParam->addParam('商品ID', 'search_name', LTEXT_LEN, 'KVa', array('MAX_LENGTH_CHECK'));
         $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,6 +170,10 @@
                     $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:
                     break;
             }

変更: branches/version-2_12-dev/html/user_data/packages/admin/css/admin_contents.css
===================================================================
--- branches/version-2_12-dev/html/user_data/packages/admin/css/admin_contents.css	2013-02-18 03:06:08 UTC (rev 22558)
+++ branches/version-2_12-dev/html/user_data/packages/admin/css/admin_contents.css	2013-02-18 03:18:22 UTC (rev 22559)
@@ -183,6 +183,10 @@
     width: 100%;
 }
 
+.recommend-product.hidden td{
+    background: #C9C9C9;
+}
+
 div.table-wrap {
     margin-top: 6px;
 }
@@ -207,6 +211,13 @@
     padding-left: 11px;
 }
 
+/*おすすめ商品検索画面*/
+
+#recommend-search-results .hidden td,
+#recommend-search-results .hidden th{
+    background: #C9C9C9;
+}
+
 /*通常ボタン*/
 .btn-normal,
 a.btn-normal:link,




Svn-src-all メーリングリストの案内