Changeset 17537 for branches/comu-ver2/data

Timestamp:

2008/08/17 07:14:54 (14 years ago)

Author:

Seasoft

Message:

管理画面 - 商品管理 - 商品マスタ
複数の規格を有する商品の表示を改善。
(注意) view の再作成を要します。

Location:

branches/comu-ver2/data

Files:

• Smarty/templates/default/admin/products/index.tpl (modified) (1 diff)
• class/db/dbfactory/SC_DB_DBFactory_MYSQL.php (modified) (2 diffs)
• class/pages/admin/products/LC_Page_Admin_Products.php (modified) (3 diffs)

branches/comu-ver2/data/Smarty/templates/default/admin/products/index.tpl

@@ -220 +220 @@
       <img src="<!--{$smarty.const.SITE_URL}-->resize_image.php?image=<!--{$image_path|sfRmDupSlash}-->&amp;width=65&amp;height=65">
       </td>
-      <td rowspan="2"><!--{$arrProducts[cnt].product_code|escape|default:"-"}--></td>
+      <td rowspan="2"><!--{$arrProducts[cnt].product_code_min|escape}-->
+        <!--{if $arrProducts[cnt].product_code_min != $arrProducts[cnt].product_code_max}-->
+          <br />～ <!--{$arrProducts[cnt].product_code_max|escape}-->
+        <!--{/if}-->
+      </td>
+      <!--{* 価格 *}-->
       <td rowspan="2" class="right">
-        <!--{* 価格 *}-->
-        <!--{if $arrProducts[cnt].price02 != ""}-->
-        <!--{$arrProducts[cnt].price02|number_format}-->
-        <!--{else}-->
-        -
+        <!--{$arrProducts[cnt].price02_min|number_format}-->
+        <!--{if $arrProducts[cnt].price02_min != $arrProducts[cnt].price02_max}-->
+          <br />～ <!--{$arrProducts[cnt].price02_max|number_format}-->
         <!--{/if}-->
       </td>
       <td><!--{$arrProducts[cnt].name|escape}--></td>
+      <!--{* 在庫 *}-->
+      <!--{* XXX 複数規格でかつ、全ての在庫数量が等しい場合は先頭に「各」と入れたれたら良いと思う。 *}-->
       <td rowspan="2">
-        <!--{* 在庫 *}-->
-        <!--{if $arrProducts[cnt].stock_unlimited == '1'}-->
-        無制限
-        <!--{else}-->
-        <!--{$arrProducts[cnt].stock|escape|default:"-"}-->
+        <!--{if $arrProducts[cnt].stock_unlimited_min}-->無制限<!--{else}--><!--{$arrProducts[cnt].stock_min|number_format}--><!--{/if}-->
+        <!--{if $arrProducts[cnt].stock_unlimited_min != $arrProducts[cnt].stock_unlimited_max || $arrProducts[cnt].stock_min != $arrProducts[cnt].stock_max}-->
+          <br />～ <!--{if $arrProducts[cnt].stock_unlimited_max}-->無制限<!--{else}--><!--{$arrProducts[cnt].stock_max|number_format}--><!--{/if}-->
         <!--{/if}-->
       </td>

branches/comu-ver2/data/class/db/dbfactory/SC_DB_DBFactory_MYSQL.php

@@ -378 +378 @@
            create_date,
            deliv_fee,
+           update_date,
            rank
            ,(SELECT rank AS category_rank
@@ -403 +404 @@
                    T0.deliv_fee,
                    T00.category_id,
-                   T00.rank
+                   T0.rank,
+                   T0.update_date
               FROM dtb_products AS T0
          LEFT JOIN dtb_product_categories AS T00

branches/comu-ver2/data/class/pages/admin/products/LC_Page_Admin_Products.php

@@ -273 +273 @@
                 case 'delete_all':
                     // 検索結果をすべて削除
-                    $where = "product_id IN (SELECT product_id FROM vw_products_nonclass AS noncls  WHERE $where)";
+                    $where = "product_id IN (SELECT product_id FROM vw_products_allclass AS allcls  WHERE $where)";
                     $sqlval['del_flg'] = 1;
                     $objQuery->update("dtb_products", $sqlval, $where, $arrval);
@@ -280 +280 @@
                 default:
                     // 読み込む列とテーブルの指定
-                    $col = "product_id, name, category_id, main_list_image, status, product_code, price01, price02, stock, stock_unlimited";
-                    $from = "vw_products_nonclass AS noncls ";
+                    $col = "product_id, name, category_id, main_list_image, status, product_code_min, product_code_max, price02_min, price02_max, stock_min, stock_max, stock_unlimited_min, stock_unlimited_max";
+                    $from = "vw_products_allclass AS allcls ";
 
                     // 行数の取得
@@ -317 +317 @@
                     // 検索結果の取得
                     $this->arrProducts = $objQuery->select($col, $from, $where, $arrval);
-
+                    
                     // 各商品ごとのカテゴリIDを取得
                     if (count($this->arrProducts) > 0) {