source: closed/dev/html/admin/products/upload_rakuten.php @ 17

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

// 1¹Ô¤¢¤¿¤ê¤ÎºÇÂçʸ»ú¿ô
define("CSV_LINE_MAX", 10000);

class LC_Page {
    var $arrSession;
    var $arrCSVErr;
    function LC_Page() {
        $this->tpl_mainpage = 'products/upload_csv.tpl';
        $this->tpl_subnavi = 'products/subnavi.tpl';
        $this->tpl_mainno = 'products';
        $this->tpl_subno = 'upload_rakuten';
    }
}

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

// ǧ¾Ú²ÄÈݤÎȽÄê
sfIsSuccess($objSess);

// ¥Õ¥¡¥¤¥ë´ÉÍý¥¯¥é¥¹
$objUpFile = new SC_UploadFile(IMAGE_TEMP_DIR, IMAGE_SAVE_DIR);
// ¥Õ¥¡¥¤¥ë¾ðÊó¤Î½é´ü²½
lfInitFile();
// ¥Ñ¥é¥á¡¼¥¿´ÉÍý¥¯¥é¥¹
$objFormParam = new SC_FormParam();
// ¥Ñ¥é¥á¡¼¥¿¾ðÊó¤Î½é´ü²½
lfInitParam();
$colmax = $objFormParam->getCount();
$objFormParam->setHtmlDispNameArray();
$objPage->arrTitle = $objFormParam->getHtmlDispNameArray();

switch($_POST['mode']) {
case 'csv_upload':
    $err = false;
    // ¥¨¥é¡¼¥Á¥§¥Ã¥¯
    $objPage->arrErr['csv_file'] = $objUpFile->makeTempFile('csv_file');
    
    if($objPage->arrErr['css_file'] == "") {
        $objPage->arrErr = $objUpFile->checkEXISTS();
    }
    
    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;    // ÅÐÏ¿¿ô
        
        $objQuery = new SC_Query();
        $objQuery->begin();
        
        while(!feof($fp) && !$err) {
            $arrCSV = fgetcsv($fp, CSV_LINE_MAX);
                        
            // ¹Ô¥«¥¦¥ó¥È
            $line++;
            
            if($line <= 1) {
                continue;
            }           
                            
            // ¹àÌÜ¿ô¥«¥¦¥ó¥È
            $max = count($arrCSV);
            
            // ¹àÌÜ¿ô¤¬1°Ê²¼¤Î¾ì¹ç¤Ï̵»ë¤¹¤ë
            if($max <= 1) {
                continue;           
            }
            
            // ¹àÌÜ¿ô¥Á¥§¥Ã¥¯
            if($max != $colmax) {
                $objPage->arrCSVErr['blank'] = "¢¨ ¹àÌÜ¿ô¤¬" . $max . "¸Ä¸¡½Ð¤µ¤ì¤Þ¤·¤¿¡£¹àÌÜ¿ô¤Ï" . $colmax . "¸Ä¤Ë¤Ê¤ê¤Þ¤¹¡£";
                $err = true;
            } else {
                // ¥·¡¼¥±¥ó¥¹ÇÛÎó¤ò³ÊǼ¤¹¤ë¡£
                $objFormParam->setParam($arrCSV, true);
                $arrRet = $objFormParam->getHashArray();
                $objFormParam->setParam($arrRet);
                // ÆþÎÏÃͤÎÊÑ´¹
                $objFormParam->convParam();
                // <br>¤Ê¤·¤Ç¥¨¥é¡¼¼èÆÀ¤¹¤ë¡£
                $objPage->arrCSVErr = lfCheckError();
            }
            
            // ÆþÎÏ¥¨¥é¡¼¥Á¥§¥Ã¥¯
            if(count($objPage->arrCSVErr) > 0) {
                $objPage->tpl_errtitle = "¢£" . $line . "¹ÔÌܤǥ¨¥é¡¼¤¬È¯À¸¤·¤Þ¤·¤¿¡£";
                $objPage->arrParam = $objFormParam->getHashArray();
                $err = true;
            }
            
            if(!$err) {
                lfRegistProduct($objQuery);
                $regist++;
            }
        }
        fclose($fp);
        
        if(!$err) {
            $objQuery->commit();
            $objPage->tpl_oktitle = "¢£" . $regist . "·ï¤Î¥ì¥³¡¼¥É¤òÅÐÏ¿¤·¤Þ¤·¤¿¡£";
            // ¾¦ÉÊ·ï¿ô¥«¥¦¥ó¥È´Ø¿ô¤Î¼Â¹Ô
            sfCategory_Count($objQuery);
        } else {
            $objQuery->rollback();
        }
    }
    break;
default:
    break;
}

$objView->assignobj($objPage);
$objView->display(MAIN_FRAME);

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

/* ¥Õ¥¡¥¤¥ë¾ðÊó¤Î½é´ü²½ */
function lfInitFile() {
    global $objUpFile;
    $objUpFile->addFile("CSV¥Õ¥¡¥¤¥ë", 'csv_file', array('csv'), CSV_SIZE, true, 0, 0, false);
}

/* ¥Ñ¥é¥á¡¼¥¿¾ðÊó¤Î½é´ü²½ */
function lfInitParam() {
    global $objFormParam;
    
    $objFormParam->addParam("¥Õ¥é¥°(Âбþ¤Ê¤·)", "dummy1");
    $objFormParam->addParam("¾¦ÉÊ̾", "name", STEXT_LEN, "KVa", array("EXIST_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK"));
    $objFormParam->addParam("¥â¥Ð¥¤¥ëÍѾ¦ÉÊ̾(Âбþ¤Ê¤·)", "dummy2");
    $objFormParam->addParam("¾¦ÉÊ¥³¡¼¥É", "product_code", STEXT_LEN, "KVa", array("SPTAB_CHECK","MAX_LENGTH_CHECK"));
    $objFormParam->addParam("¾¦ÉÊID(Âбþ¤Ê¤·)", "dummy3");
    $objFormParam->addParam("¾¦ÉÊ¥Ú¡¼¥¸ID(Âбþ¤Ê¤·)", "dummy1");
    $objFormParam->addParam("¼ÂÇä²Á³Ê", "price01", PRICE_LEN, "n", array("MAX_LENGTH_CHECK","NUM_CHECK"));
    $objFormParam->addParam("ɽ¼¨²Á³Ê", "price02", PRICE_LEN, "n", array("EXIST_CHECK","MAX_LENGTH_CHECK","NUM_CHECK"));
    $objFormParam->addParam("¾ÃÈñÀǥե饰(Âбþ¤Ê¤·)", "dummy4");
    $objFormParam->addParam("Á÷ÎÁ(Âбþ¤Ê¤·)", "dummy5");
    $objFormParam->addParam("¸ÄÊÌÁ÷ÎÁ(Âбþ¤Ê¤·)", "dummy6");
    $objFormParam->addParam("Ãíʸ¥Ü¥¿¥ó(Âбþ¤Ê¤·)", "dummy7");
    $objFormParam->addParam("»ñÎÁÀÁµá¥Ü¥¿¥ó(Âбþ¤Ê¤·)", "dummy8");
    $objFormParam->addParam("Ì䤤¹ç¤ï¤»¥Ü¥¿¥ó(Âбþ¤Ê¤·)", "dummy9");
    $objFormParam->addParam("¤ª´«¤á¥Ü¥¿¥ó(Âбþ¤Ê¤·)", "dummy10");
    $objFormParam->addParam("¤Î¤·Âбþ¥Õ¥é¥°(Âбþ¤Ê¤·)", "dummy11");
    $objFormParam->addParam("ºß¸Ë¿ô", "stock", INT_LEN, "n", array("MAX_LENGTH_CHECK","NUM_CHECK"));
    $objFormParam->addParam("¹àÌÜÁªÂò»è(Âбþ¤Ê¤·)", "dummy12");
    $objFormParam->addParam("´ü´Ö¸ÂÄêÈÎÇä(Âбþ¤Ê¤·)", "dummy13");
    $objFormParam->addParam("ÀâÌÀʸ", "main_comment", LTEXT_LEN, "KVa", array("EXIST_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK"));
    $objFormParam->addParam("¥â¥Ð¥¤¥ëÀâÌÀʸ(Âбþ¤Ê¤·)", "dummy14");
    $objFormParam->addParam("²èÁü(Âбþ¤Ê¤·)", "dummy15");
    $objFormParam->addParam("³ÚÅ·¥Ç¥£¥ì¥¯¥È¥êID(Âбþ¤Ê¤·)", "dummy16");
    $objFormParam->addParam("¥â¥Ð¥¤¥ë(Âбþ¤Ê¤·)", "dummy17");
}
?>