Changeset 15078 for branches/feature-module-update/html/admin/develop/upload_csv.php

Timestamp:

2007/07/20 15:58:59 (17 years ago)

Author:

nanasess

Message:

r15064 から svn cp
とりあえず暫定コミット.

• UTF-8 に変更
• slib.php, glib.php のクラス化
• LC_Page の抽象化（一部）

Location:

branches/feature-module-update

Files:

• . (copied) (copied from branches/rel) (1 prop)
• html (copied) (copied from branches/rel/html)
• html/admin/develop/upload_csv.php (modified) (12 diffs)

branches/feature-module-update/html/admin/develop/upload_csv.php

@@ -23 +23 @@
 $objSess = new SC_Session();
 
-// ǧ¾Ú²ÄÈݤÎȽÄê
+// 認証可否の判定
 sfIsSuccess($objSess);
 
 if(ADMIN_MODE != 1) {
-    print("¤³¤Î¥Ú¡¼¥¸¤Ë¤Ï¡¢¥¢¥¯¥»¥¹¤Ç¤­¤Þ¤»¤ó¡£");
+    print("このページには、アクセスできません。");
     exit;
 }
 
-// ¥Õ¥¡¥¤¥ë´ÉÍý¥¯¥é¥¹
+// ファイル管理クラス
 $objUpFile = new SC_UploadFile(IMAGE_TEMP_DIR, IMAGE_SAVE_DIR);
-// ¥Õ¥¡¥¤¥ë¾ðÊó¤Î½é´ü²½
+// ファイル情報の初期化
 lfInitFile();
-// ¥Ñ¥é¥á¡¼¥¿´ÉÍý¥¯¥é¥¹
+// パラメータ管理クラス
 $objFormParam = new SC_FormParam();
-// ¥Ñ¥é¥á¡¼¥¿¾ðÊó¤Î½é´ü²½
+// パラメータ情報の初期化
 lfInitParam();
 $colmax = $objFormParam->getCount();
@@ -45 +45 @@
 case 'csv_upload':
     $err = false;
-    // ¥¨¥é¡¼¥Á¥§¥Ã¥¯
+    // エラーチェック
     $objPage->arrErr['csv_file'] = $objUpFile->makeTempFile('csv_file');
     
@@ -53 +53 @@
     
     if($objPage->arrErr['csv_file'] == "") {
-        // °ì»þ¥Õ¥¡¥¤¥ë̾¤Î¼èÆÀ
+        // 一時ファイル名の取得
         $filepath = $objUpFile->getTempFilePath('csv_file');
-        // ¥¨¥ó¥³¡¼¥É
+        // エンコード
         $enc_filepath = sfEncodeFile($filepath, CHAR_CODE, CSV_TEMP_DIR);
         $fp = fopen($enc_filepath, "r");
         
-        $line = 0;      // ¹Ô¿ô
-        $regist = 0;    // ÅÐÏ¿¿ô
+        $line = 0;      // 行数
+        $regist = 0;    // 登録数
         
         $objQuery = new SC_Query();
@@ -67 +67 @@
         while(!feof($fp) && !$err) {
             $arrCSV = fgetcsv($fp, 10000);
-            // ¹Ô¥«¥¦¥ó¥È
+            // 行カウント
             $line++;
     
-            // ¹àÌÜ¿ô¥«¥¦¥ó¥È
+            // 項目数カウント
             $max = count($arrCSV);
             
-            // ¹àÌÜ¿ô¤¬1°Ê²¼¤Î¾ì¹ç¤Ï̵»ë¤¹¤ë
+            // 項目数が1以下の場合は無視する
             if($max <= 1) {
                 continue;           
             }
             
-            // ¹àÌÜ¿ô¥Á¥§¥Ã¥¯
+            // 項目数チェック
             if($max != $colmax) {
-                $objPage->arrCSVErr['blank'] = "¢¨ ¹àÌÜ¿ô¤¬" . $max . "¸Ä¸¡½Ð¤µ¤ì¤Þ¤·¤¿¡£¹àÌÜ¿ô¤Ï" . $colmax . "¸Ä¤Ë¤Ê¤ê¤Þ¤¹¡£";
+                $objPage->arrCSVErr['blank'] = "※ 項目数が" . $max . "個検出されました。項目数は" . $colmax . "個になります。";
                 
                 ob_start();
@@ -89 +89 @@
                 $err = true;
             } else {
-                // ¥·¡¼¥±¥ó¥¹ÇÛÎó¤ò³ÊǼ¤¹¤ë¡£
+                // シーケンス配列を格納する。
                 $objFormParam->setParam($arrCSV, true);
                 $arrRet = $objFormParam->getHashArray();
-                // Ãͤò¥Õ¥©¡¼¥Þ¥Ã¥ÈÊÑ´¹¤·¤Æ³ÊǼ¤¹¤ë¡£
+                // 値をフォーマット変換して格納する。
                 $arrRet = lfConvFormat($arrRet);
                 $objFormParam->setParam($arrRet);
-                // ÆþÎÏÃͤÎÊÑ´¹
+                // 入力値の変換
                 $objFormParam->convParam();
-                // <br>¤Ê¤·¤Ç¥¨¥é¡¼¼èÆÀ¤¹¤ë¡£
+                // <br>なしでエラー取得する。
                 $objPage->arrCSVErr = lfCheckError();
             }
             
-            // ÆþÎÏ¥¨¥é¡¼¥Á¥§¥Ã¥¯
+            // 入力エラーチェック
             if(count($objPage->arrCSVErr) > 0) {
-                $objPage->tpl_errtitle = "¢£" . $line . "¹ÔÌܤǥ¨¥é¡¼¤¬È¯À¸¤·¤Þ¤·¤¿¡£";
+                $objPage->tpl_errtitle = "■" . $line . "行目でエラーが発生しました。";
                 $objPage->arrParam = $objFormParam->getHashArray();
                 $err = true;
@@ -121 +121 @@
             gfPrintLog("commit csv:$regist");
                         
-            $objPage->tpl_oktitle = "¢£" . $regist . "·ï¤Î¥ì¥³¡¼¥É¤òÅÐÏ¿¤·¤Þ¤·¤¿¡£";
+            $objPage->tpl_oktitle = "■" . $regist . "件のレコードを登録しました。";
         } else {
             $objQuery->rollback();
@@ -136 +136 @@
 //--------------------------------------------------------------------------------------------------------------------------
 
-/* ¥Õ¥¡¥¤¥ë¾ðÊó¤Î½é´ü²½ */
+/* ファイル情報の初期化 */
 function lfInitFile() {
     global $objUpFile;
-    $objUpFile->addFile("CSV¥Õ¥¡¥¤¥ë", 'csv_file', array('csv'), CSV_SIZE, true, 0, 0, false);
-}
-
-/* ¥Ñ¥é¥á¡¼¥¿¾ðÊó¤Î½é´ü²½ */
+    $objUpFile->addFile("CSVファイル", 'csv_file', array('csv'), CSV_SIZE, true, 0, 0, false);
+}
+
+/* パラメータ情報の初期化 */
 function lfInitParam() {
     global $objFormParam;
     
-    $objFormParam->addParam("¾¦ÉÊ̾", "name", MTEXT_LEN, "KVa", array("EXIST_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK"));
-    $objFormParam->addParam("¥«¥Æ¥´¥êID", "category_id", INT_LEN, "n", array("EXIST_CHECK","MAX_LENGTH_CHECK","NUM_CHECK"));
-    $objFormParam->addParam("¾¦ÉÊ¥³¡¼¥É", "product_code", STEXT_LEN, "KVa", array("SPTAB_CHECK","MAX_LENGTH_CHECK"));
-    $objFormParam->addParam("¾¦ÉʲÁ³Ê", "price02", PRICE_LEN, "n", array("EXIST_CHECK","MAX_LENGTH_CHECK","NUM_CHECK"));
-    $objFormParam->addParam("¾¦ÉʲÁ³Ê", "price01", PRICE_LEN, "n", array("MAX_LENGTH_CHECK","NUM_CHECK"));
-    $objFormParam->addParam("ºß¸Ë¿ô", "stock", INT_LEN, "n", array("MAX_LENGTH_CHECK","NUM_CHECK"));
-    $objFormParam->addParam("¹ØÆþÀ©¸Â", "sale_limit", INT_LEN, "n", array("MAX_LENGTH_CHECK","NUM_CHECK"));
-    $objFormParam->addParam("¥á¡¼¥«¡¼URL", "comment1", LTEXT_LEN, "KVa", array("URL_CHECK", "SPTAB_CHECK","MAX_LENGTH_CHECK"));
-    $objFormParam->addParam("¾¦ÉÊ¥¹¥Æ¡¼¥¿¥¹", "product_flag", INT_LEN, "n", array("MAX_LENGTH_CHECK","NUM_CHECK"));
-    $objFormParam->addParam("¥Ý¥¤¥ó¥ÈÉÕͿΨ", "point_rate", PERCENTAGE_LEN, "n", array("EXIST_CHECK","MAX_LENGTH_CHECK","NUM_CHECK"));
-    $objFormParam->addParam("¥á¥¤¥ó°ìÍ÷¥³¥á¥ó¥È", "main_list_comment", LTEXT_LEN, "KVa", array("EXIST_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK"));
-    $objFormParam->addParam("¥á¥¤¥ó¥³¥á¥ó¥È", "main_comment", LTEXT_LEN, "KVa", array("EXIST_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK"));
+    $objFormParam->addParam("商品名", "name", MTEXT_LEN, "KVa", array("EXIST_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK"));
+    $objFormParam->addParam("カテゴリID", "category_id", INT_LEN, "n", array("EXIST_CHECK","MAX_LENGTH_CHECK","NUM_CHECK"));
+    $objFormParam->addParam("商品コード", "product_code", STEXT_LEN, "KVa", array("SPTAB_CHECK","MAX_LENGTH_CHECK"));
+    $objFormParam->addParam("商品価格", "price02", PRICE_LEN, "n", array("EXIST_CHECK","MAX_LENGTH_CHECK","NUM_CHECK"));
+    $objFormParam->addParam("商品価格", "price01", PRICE_LEN, "n", array("MAX_LENGTH_CHECK","NUM_CHECK"));
+    $objFormParam->addParam("在庫数", "stock", INT_LEN, "n", array("MAX_LENGTH_CHECK","NUM_CHECK"));
+    $objFormParam->addParam("購入制限", "sale_limit", INT_LEN, "n", array("MAX_LENGTH_CHECK","NUM_CHECK"));
+    $objFormParam->addParam("メーカーURL", "comment1", LTEXT_LEN, "KVa", array("URL_CHECK", "SPTAB_CHECK","MAX_LENGTH_CHECK"));
+    $objFormParam->addParam("商品ステータス", "product_flag", INT_LEN, "n", array("MAX_LENGTH_CHECK","NUM_CHECK"));
+    $objFormParam->addParam("ポイント付与率", "point_rate", PERCENTAGE_LEN, "n", array("EXIST_CHECK","MAX_LENGTH_CHECK","NUM_CHECK"));
+    $objFormParam->addParam("メイン一覧コメント", "main_list_comment", LTEXT_LEN, "KVa", array("EXIST_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK"));
+    $objFormParam->addParam("メインコメント", "main_comment", LTEXT_LEN, "KVa", array("EXIST_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK"));
     
     for($i = 1; $i <= PRODUCTSUB_MAX; $i++) {
-        $objFormParam->addParam("¾ÜºÙ-¥µ¥Ö¥¿¥¤¥È¥ë($i)", "sub_title$i", LTEXT_LEN, "KVa", array("SPTAB_CHECK","MAX_LENGTH_CHECK"));
-        $objFormParam->addParam("¾ÜºÙ-¥µ¥Ö¥³¥á¥ó¥È($i)", "sub_comment$i", LTEXT_LEN, "KVa", array("SPTAB_CHECK","MAX_LENGTH_CHECK"));
-        $objFormParam->addParam("¾ÜºÙ-¥µ¥Ö²èÁü($i)", "sub_image$i", LTEXT_LEN, "KVa", array("SPTAB_CHECK","MAX_LENGTH_CHECK","FIND_FILE"));
-        $objFormParam->addParam("¾ÜºÙ-¥µ¥Ö²èÁü³ÈÂç($i)", "sub_large_image$i", LTEXT_LEN, "KVa", array("SPTAB_CHECK","MAX_LENGTH_CHECK","FIND_FILE"));
-    }
-        
-    $objFormParam->addParam("¥á¥¤¥ó°ìÍ÷²èÁü", "main_list_image", LTEXT_LEN, "KVa", array("EXIST_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK","FIND_FILE"));
-    $objFormParam->addParam("¥á¥¤¥ó¾ÜºÙ²èÁü", "main_image", LTEXT_LEN, "KVa", array("EXIST_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK","FIND_FILE"));
-    $objFormParam->addParam("¥á¥¤¥ó¾ÜºÙ³ÈÂç²èÁü", "main_large_image", LTEXT_LEN, "KVa", array("SPTAB_CHECK","MAX_LENGTH_CHECK","FIND_FILE"));
-    $objFormParam->addParam("Èæ³Ó²èÁü", "file1", LTEXT_LEN, "KVa", array("SPTAB_CHECK","MAX_LENGTH_CHECK","FIND_FILE"));
-    $objFormParam->addParam("¾¦Éʾܺ٥ե¡¥¤¥ë", "file2", LTEXT_LEN, "KVa", array("SPTAB_CHECK","MAX_LENGTH_CHECK"));
-    $objFormParam->addParam("Á÷ÎÁ", "deliv_fee", PRICE_LEN, "n", array("MAX_LENGTH_CHECK","NUM_CHECK"));
-    $objFormParam->addParam("ºß¸Ë̵À©¸Â", "stock_unlimited", INT_LEN, "n", array("MAX_LENGTH_CHECK","NUM_CHECK"));
-    $objFormParam->addParam("ÈÎÇä̵À©¸Â", "sale_unlimited", INT_LEN, "n", array("MAX_LENGTH_CHECK","NUM_CHECK"));
-}
-
-/* Æüì¹àÌܤÎÊÑ´¹ */
+        $objFormParam->addParam("詳細-サブタイトル($i)", "sub_title$i", LTEXT_LEN, "KVa", array("SPTAB_CHECK","MAX_LENGTH_CHECK"));
+        $objFormParam->addParam("詳細-サブコメント($i)", "sub_comment$i", LTEXT_LEN, "KVa", array("SPTAB_CHECK","MAX_LENGTH_CHECK"));
+        $objFormParam->addParam("詳細-サブ画像($i)", "sub_image$i", LTEXT_LEN, "KVa", array("SPTAB_CHECK","MAX_LENGTH_CHECK","FIND_FILE"));
+        $objFormParam->addParam("詳細-サブ画像拡大($i)", "sub_large_image$i", LTEXT_LEN, "KVa", array("SPTAB_CHECK","MAX_LENGTH_CHECK","FIND_FILE"));
+    }
+        
+    $objFormParam->addParam("メイン一覧画像", "main_list_image", LTEXT_LEN, "KVa", array("EXIST_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK","FIND_FILE"));
+    $objFormParam->addParam("メイン詳細画像", "main_image", LTEXT_LEN, "KVa", array("EXIST_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK","FIND_FILE"));
+    $objFormParam->addParam("メイン詳細拡大画像", "main_large_image", LTEXT_LEN, "KVa", array("SPTAB_CHECK","MAX_LENGTH_CHECK","FIND_FILE"));
+    $objFormParam->addParam("比較画像", "file1", LTEXT_LEN, "KVa", array("SPTAB_CHECK","MAX_LENGTH_CHECK","FIND_FILE"));
+    $objFormParam->addParam("商品詳細ファイル", "file2", LTEXT_LEN, "KVa", array("SPTAB_CHECK","MAX_LENGTH_CHECK"));
+    $objFormParam->addParam("送料", "deliv_fee", PRICE_LEN, "n", array("MAX_LENGTH_CHECK","NUM_CHECK"));
+    $objFormParam->addParam("在庫無制限", "stock_unlimited", INT_LEN, "n", array("MAX_LENGTH_CHECK","NUM_CHECK"));
+    $objFormParam->addParam("販売無制限", "sale_unlimited", INT_LEN, "n", array("MAX_LENGTH_CHECK","NUM_CHECK"));
+}
+
+/* 特殊項目の変換 */
 function lfConvFormat($array) {
     global $arrDISP;
@@ -192 +192 @@
 }
 
-/* ¾¦Éʤο·µ¬Äɲà */
+/* 商品の新規追加 */
 function lfInsertProduct($objQuery) {
     global $objFormParam;
     $arrRet = $objFormParam->getHashArray();
     
-    // µ¬³Ê¤ËÅÐÏ¿¤µ¤ì¤ëÃͤò½ü³°¤¹¤ë¡£
+    // 規格に登録される値を除外する。
     foreach($arrRet as $key => $val) {
         switch($key) {
@@ -217 +217 @@
     }
 
-    $sqlval['status'] = 1;  // ɽ¼¨¤ËÀßÄꤹ¤ë¡£
+    $sqlval['status'] = 1;  // 表示に設定する。
     $sqlval['update_date'] = "Now()";
     $sqlval['create_date'] = "Now()";
@@ -223 +223 @@
     $sqlval['rank'] = $objQuery->max("dtb_products", "rank", "del_flg = 0 AND category_id = ?", array($sqlval['category_id'])) + 1;
     
-    // µ¬³ÊÅÐÏ¿
+    // 規格登録
     sfInsertProductClass($objQuery, $arrRet, $product_id);
     
     gfPrintLog("insert productclass end");
     
-    // INSERT¤Î¼Â¹Ô
+    // INSERTの実行
     $objQuery->insert("dtb_products", $sqlval);
     
@@ -238 +238 @@
 }
 
-/* ÆþÎÏÆâÍƤΥÁ¥§¥Ã¥¯ */
+/* 入力内容のチェック */
 function lfCheckError() {
     global $objFormParam;
-    // ÆþÎϥǡ¼¥¿¤òÅϤ¹¡£
+    // 入力データを渡す。
     $arrRet =  $objFormParam->getHashArray();
     $objErr = new SC_CheckError($arrRet);
@@ -253 +253 @@
         $level = $objQuery->get($table, $col, $where, array($arrRet['category_id']));
         if($level != LEVEL_MAX) {
-            $objErr->arrErr['category_id'] = "¢¨ ¤³¤Î¥«¥Æ¥´¥êID¤Ë¤Ï¾¦ÉʤòÅÐÏ¿¤Ç¤­¤Þ¤»¤ó¡£";
+            $objErr->arrErr['category_id'] = "※ このカテゴリIDには商品を登録できません。";
         }
     }