source: branches/comu/html/admin/develop/csv.php @ 11729

<?php
/*
 * Copyright(c) 2000-2007 LOCKON CO.,LTD. All Rights Reserved.
 *
 * http://www.lockon.co.jp/
 */
require_once("../require.php");

$conn = new SC_DBConn();
$objView = new SC_AdminView();
$objSess = new SC_Session();

// パラメータ管理クラス
$objFormParam = new SC_FormParam();
// パラメータ情報の初期化
lfInitParam();
$colmax = $objFormParam->getCount();

// 一時ファイル名の取得
$filepath = $argv[1]; 

if(!file_exists($filepath)) {
    fwrite(STDOUT, "no file exists.\n");
    exit;
}

// エンコード
$enc_filepath = sfEncodeFile($filepath, CHAR_CODE, CSV_TEMP_DIR);

$total = 0;

for($i = 0; $i < 1500; $i++) {
    $ret = lfRegistCSV($enc_filepath, $colmax, $total);
    $total+= $ret;
}

fwrite(STDOUT, "■" . $total . "件のレコードを登録しました。\n");

//--------------------------------------------------------------------------------------------------------------------------

/* ファイル情報の初期化 */
function lfInitFile() {
    global $objUpFile;
    $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"));
    
    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"));
}

/* 特殊項目の変換 */
function lfConvFormat($array) {
    global $arrDISP;
    foreach($array as $key => $val) {
        switch($key) {
        case 'status':
            $arrRet[$key] = sfSearchKey($arrDISP, $val, 1);
            break;
        default:
            $arrRet[$key] = $val;
            break;
        }
    }
    return $arrRet;
}

/* 商品の新規追加 */
function lfInsertProduct($objQuery) {
    global $objFormParam;
    $arrRet = $objFormParam->getHashArray();
    
    // 規格に登録される値を除外する。
    foreach($arrRet as $key => $val) {
        switch($key) {
        case 'product_code':
        case 'price01':
        case 'price02':
        case 'stock':
        case 'stock_unlimited':
            break;
        default:
            $sqlval[$key] = $val;
            break;
        }
    }
    
    if (DB_TYPE == "pgsql") {
        $product_id = $objQuery->nextval("dtb_products", "product_id");
        $sqlval['product_id'] = $product_id;
    }
    $sqlval['status'] = 1;  // 表示に設定する。
    $sqlval['update_date'] = "Now()";
    $sqlval['create_date'] = "Now()";
    $sqlval['creator_id'] = $_SESSION['member_id'];
    
    if($_SESSION['member_id'] == "") {
        $sqlval['creator_id'] = '0';
    }
        
    $sqlval['rank'] = $objQuery->max("dtb_products", "rank", "del_flg = 0 AND category_id = ?", array($sqlval['category_id'])) + 1;
    
    // 規格登録
    sfInsertProductClass($objQuery, $arrRet, $product_id);
    // INSERTの実行
    $objQuery->fast_insert("dtb_products", $sqlval);
    if (DB_TYPE == "mysql") {
        $product_id = $objQuery->nextval("dtb_products", "product_id");
    }
}

/* 入力内容のチェック */
function lfCheckError() {
    global $objFormParam;
    // 入力データを渡す。
    $arrRet =  $objFormParam->getHashArray();
    $objErr = new SC_CheckError($arrRet);
    $objErr->arrErr = $objFormParam->checkError(false);
    
    if(!isset($objErr->arrErr['category_id'])) {
        $objQuery = new SC_Query();
        $col = "level";
        $table = "dtb_category";
        $where = "category_id = ?";
        $level = $objQuery->get($table, $col, $where, array($arrRet['category_id']));
        if($level != LEVEL_MAX) {
            $objErr->arrErr['category_id'] = "※ このカテゴリIDには商品を登録できません。";
        }
    }
    return $objErr->arrErr;
}

function lfRegistCSV($filepath, $colmax, $total) {
    global $objFormParam;
            
    $fp = fopen($filepath, "r");
    $line = 0;      // 行数
    $regist = 0;    // 登録数
    
    $objQuery = new SC_Query();
    
    $err = false;
    
    while(!feof($fp)) {
        $arrCSV = fgetcsv($fp, 10000);
        // 行カウント
        $line++;
                        
        // 項目数カウント
        $max = count($arrCSV);
        
        // 項目数が1以下の場合は無視する
        if($max <= 1) {
            continue;           
        }
            
        // 項目数チェック
        if($max != $colmax) {
            fwrite(STDOUT, "※ 項目数が" . $max . "個検出されました。項目数は" . $colmax . "個になります。\n");
            
            ob_start();
            print_r($arrCSV);
            $objPage->tpl_debug = ob_get_contents();
            ob_end_clean(); 
            
            $err = true;
        } else {
            // シーケンス配列を格納する。
            $objFormParam->setParam($arrCSV, true);
            $arrRet = $objFormParam->getHashArray();
            // 値をフォーマット変換して格納する。
            $arrRet = lfConvFormat($arrRet);
            $objFormParam->setParam($arrRet);
            // 入力値の変換
            $objFormParam->convParam();
            // <br>なしでエラー取得する。
            $objPage->arrCSVErr = lfCheckError();
        }
            
        // 入力エラーチェック
        if(count($objPage->arrCSVErr) > 0) {
            fwrite(STDOUT, "■" . $line . "行目でエラーが発生しました。\n");
            $objPage->arrParam = $objFormParam->getHashArray();
            $err = true;
        }
            
        if(!$err) {
            $all = $total + $line;
            fwrite(STDOUT, "writing $all\n");
            $objQuery->begin();
            lfInsertProduct($objQuery);
            $objQuery->commit();
            $regist++;
        }
    }
    fclose($fp);
    
    return $regist;
}
?>