Changes between Initial Version and Version 1 of Ticket #236


Ignore:
Timestamp:
2008/02/02 08:36:54 (15 years ago)
Author:
miningbrownie
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #236 – Description

    initial v1  
    55「商品管理」に「カテゴリーCSV」のメニューが出来ます。 
    66 
     7== 仕様 == 
    78CSVの項目は 
     9 
    8101項目：カテゴリID 
     11 
    9122項目：カテゴリ名(※ 必須) 
     13 
    10143項目：親カテゴリID 
     15 
    11164項目：階層 
     17 
    12185項目：表示順 
     19 
    1320となっております。 
    1421 
    … …  
    2431未入力の場合、同じ親カテゴリIDの中で一番大きな値がつきます。 
    2532 
     33 
     34== パッチ == 
    2635{{{ 
    2736diff -urN eccube-2.0.1.org/data/Smarty/templates/default/admin/products/subnavi.tpl eccube-2.0.1/data/Smarty/templates/default/admin/products/subnavi.tpl 
    2837--- eccube-2.0.1.org/data/Smarty/templates/default/admin/products/subnavi.tpl   2007-10-29 12:06:29.000000000 +0900 
    29 +++ eccube-2.0.1/data/Smarty/templates/default/admin/products/subnavi.tpl       2008-02-02 08:01:32.000000000 +0900 
     38+++ eccube-2.0.1/data/Smarty/templates/default/admin/products/subnavi.tpl       2008-02-02 08:31:58.000000000 +0900 
    3039@@ -33,7 +33,9 @@ 
    3140        <tr><td><img src="<!--{$TPL_DIR}-->img/contents/navi_line.gif" width="140" height="2" alt=""></td></tr> 
    … …  
    4150diff -urN eccube-2.0.1.org/data/Smarty/templates/default/admin/products/upload_csv_category.tpl eccube-2.0.1/data/Smarty/templates/default/admin/products/upload_csv_category.tpl 
    4251--- eccube-2.0.1.org/data/Smarty/templates/default/admin/products/upload_csv_category.tpl       1970-01-01 09:00:00.000000000 +0900 
    43 +++ eccube-2.0.1/data/Smarty/templates/default/admin/products/upload_csv_category.tpl   2008-02-02 08:01:32.000000000 +0900 
     52+++ eccube-2.0.1/data/Smarty/templates/default/admin/products/upload_csv_category.tpl   2008-02-02 08:31:58.000000000 +0900 
    4453@@ -0,0 +1,135 @@ 
    4554+<!--{* 
    … …  
    181190diff -urN eccube-2.0.1.org/data/class_extends/page_extends/admin/products/LC_Page_Admin_Products_UploadCSVCategory_Ex.php eccube-2.0.1/data/class_extends/page_extends/admin/products/LC_Page_Admin_Products_UploadCSVCategory_Ex.php 
    182191--- eccube-2.0.1.org/data/class_extends/page_extends/admin/products/LC_Page_Admin_Products_UploadCSVCategory_Ex.php     1970-01-01 09:00:00.000000000 +0900 
    183 +++ eccube-2.0.1/data/class_extends/page_extends/admin/products/LC_Page_Admin_Products_UploadCSVCategory_Ex.php 2008-02-02 08:01:29.000000000 +0900 
    184 @@ -0,0 +1,352 @@ 
     192+++ eccube-2.0.1/data/class_extends/page_extends/admin/products/LC_Page_Admin_Products_UploadCSVCategory_Ex.php 2008-02-02 08:31:58.000000000 +0900 
     193@@ -0,0 +1,363 @@ 
    185194+<?php 
    186195+/* 
    … …  
    427436+            switch($key) { 
    428437+                case 'parent_category_id': 
    429 +                 
     438+ 
    430439+                    break; 
    431440+                default: 
    … …  
    445454+        $sqlval['update_date'] = $time; 
    446455+        $sqlval['creator_id'] = $_SESSION['member_id']; 
     456+        //カテゴリIDの設定。 
     457+        $update = false; 
    447458+        if($arrRet['category_id'] != ""){ 
     459+            $sqlval['category_id'] = $arrRet['category_id']; 
     460+            $update = true; 
     461+        }else{ 
     462+            $category_id = $objQuery->max("dtb_category","category_id")+1; 
     463+            $sqlval['category_id'] = $category_id; 
    448464+            $count = $objQuery->count("dtb_category", "category_id = ?", array($arrRet['category_id'])); 
    449 +        }else{ 
    450 +            $count = 0; 
    451 +        } 
     465+            if($count == 0){ 
     466+                $update = false; 
     467+            }else{ 
     468+                $update = true; 
     469+            } 
     470+        } 
     471+ 
     472+        //親カテゴリIDの設定 
    452473+        if($arrRet['parent_category_id'] == ""){ 
    453474+            $sqlval['parent_category_id'] = 0; 
     475+            $sqlval['level'] = 1; 
    454476+        }else{ 
    455477+            $sqlval['parent_category_id'] = $arrRet['parent_category_id']; 
    456 +        } 
    457 + 
    458 +        if($count != 0) { 
     478+            $parent_level = $objQuery->get('dtb_category','level',"category_id = ?",array($sqlval['parent_category_id'])); 
     479+            $sqlval['level'] = $parent_level+1; 
     480+        } 
     481+         
     482+ 
     483+        if($update) { 
    459484+            // UPDATEの実行 
    460485+            echo "UPDATEの実行"; 
    … …  
    463488+        } else { 
    464489+            // 新規登録 
    465 +            if($arrRet['category_id'] != ""){ 
    466 +                $sqlval['category_id'] = $arrRet['category_id']; 
    467 +            }else{ 
    468 +                $category_id = $objQuery->max("dtb_category","category_id")+1; 
    469 +                $sqlval['category_id'] = $category_id; 
    470 +            } 
     490+ 
    471491+            $sqlval['create_date'] = $time; 
    472492+            if($arrRet['rank'] == ""){ 
    … …  
    537557diff -urN eccube-2.0.1.org/html/admin/products/upload_csv_category.php eccube-2.0.1/html/admin/products/upload_csv_category.php 
    538558--- eccube-2.0.1.org/html/admin/products/upload_csv_category.php        1970-01-01 09:00:00.000000000 +0900 
    539 +++ eccube-2.0.1/html/admin/products/upload_csv_category.php    2008-02-02 08:01:56.000000000 +0900 
     559+++ eccube-2.0.1/html/admin/products/upload_csv_category.php    2008-02-01 11:54:42.000000000 +0900 
    540560@@ -0,0 +1,35 @@ 
    541561+<?php 
    … …  
    577597}}} 
    578598 
    579 パッチは少し長くなってしまったので添付します。 
     599パッチは少し長くなってしまったので添付もします。