source: temp/trunk/html/admin/basis/zip_install.php @ 2207

<?php
require_once("../require.php");

define("ZIP_CSV_LINE_MAX", 8192);
define("IMAGE_MAX", 680);   // ²èÁü¤Îɽ¼¨¸Ä¿ô

$path = ROOT_DIR . "html/install/KEN_ALL.CSV";

$objQuery = new SC_Query();
$objSess = new SC_Session();

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

$fp = fopen($path, "r");

// °ìÉô¤ÎIE¤Ï256¥Ð¥¤¥È°Ê¾å¼õ¤±¼è¤Ã¤Æ¤«¤éɽ¼¨¤ò³«»Ï¤¹¤ë¡£
for($i = 0; $i < 256; $i++) {
    print(" ");
}
print("\n");
MyFlush();

if(!$fp) {
    sfErrorHeader(">> " . $path . "¤Î¼èÆÀ¤Ë¼ºÇÔ¤·¤Þ¤·¤¿¡£");
} else {
    print("<img src='/img/install/main_w.jpg'><br>");
    MyFlush();
    
    // CSV¤Î·ï¿ô¤ò¿ô¤¨¤ë
    $line = 0;
    while(!feof($fp)) {
        fgets($fp, ZIP_CSV_LINE_MAX);
        $line++;
    }
    
    print("<img src='/img/install/space_w.gif'>");
    MyFlush();
        
    // ¥Õ¥¡¥¤¥ë¥Ý¥¤¥ó¥¿¤òÌ᤹
    fseek($fp, 0);
    
    // ²èÁü¤ò°ì¸Äɽ¼¨¤¹¤ë·ï¿ô¤òµá¤á¤ë¡£
    $disp_line = intval($line / IMAGE_MAX);
    
    // ´û¤Ë½ñ¤­¹þ¤Þ¤ì¤¿¥Ç¡¼¥¿¤ò¿ô¤¨¤ë
    $end_cnt = $objQuery->count("mtb_zip");
    $cnt = 1;
    $img_cnt = 0;
    while (!feof($fp)) {
        $arrCSV = fgetcsv($fp, ZIP_CSV_LINE_MAX);
        
        // ¤¹¤Ç¤Ë½ñ¤­¹þ¤Þ¤ì¤¿¥Ç¡¼¥¿¤òÈô¤Ð¤¹¡£
        if($cnt > $end_cnt) {
            $sqlval['code'] = $arrCSV[0];
            $sqlval['old_zipcode'] = $arrCSV[1];
            $sqlval['zipcode'] = $arrCSV[2];
            $sqlval['state_kana'] = $arrCSV[3];
            $sqlval['city_kana'] = $arrCSV[4];
            $sqlval['town_kana'] = $arrCSV[5];
            $sqlval['state'] = $arrCSV[6];
            $sqlval['city'] = $arrCSV[7];
            $sqlval['town'] = $arrCSV[8];
            $sqlval['flg1'] = $arrCSV[9];
            $sqlval['flg2'] = $arrCSV[10];
            $sqlval['flg3'] = $arrCSV[11];
            $sqlval['flg4'] = $arrCSV[12];
            $sqlval['flg5'] = $arrCSV[13];
            $sqlval['flg6'] = $arrCSV[14];  
            $objQuery->insert("mtb_zip", $sqlval);
        }
        
        $cnt++;
        // $disp_line·ï¤´¤È¤Ë¿ÊĽɽ¼¨¤¹¤ë
        if($cnt % $disp_line == 0 && $img_cnt < IMAGE_MAX) {
            print("<img src='/img/install/graph_1_w.gif'>");
            MyFlush();
            $img_cnt++;
        }
    }
    fclose($fp);
    print("<img src='/img/install/space_w.gif'><br>");
}

function MyFlush() {
    flush();
    ob_end_flush();
    ob_start();
}

?>