source: branches/dev/html/admin/develop/csv.php @ 8

<?php
/*
 * Copyright(c) 2000-2006 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;
}
?>