source: branches/dev/html/admin/basis/zip_install.php @ 17

Revision 17, 2.4 KB checked in by uehara, 17 years ago (diff)
Line 
1<?php
2/*
3 * Copyright(c) 2000-2007 LOCKON CO.,LTD. All Rights Reserved.
4 *
5 * http://www.lockon.co.jp/
6 */
7require_once("../require.php");
8
9ini_set("max_execution_time", 600);
10
11define("ZIP_CSV_LINE_MAX", 8192);
12define("IMAGE_MAX", 680);   // ²èÁü¤Îɽ¼¨¸Ä¿ô
13
14$path = HTML_PATH . "admin/basis/KEN_ALL.CSV";
15
16$objQuery = new SC_Query();
17$objSess = new SC_Session();
18
19// ǧ¾Ú²ÄÈݤÎȽÄê
20sfIsSuccess($objSess);
21
22$fp = fopen($path, "r");
23
24// °ìÉô¤ÎIE¤Ï256¥Ð¥¤¥È°Ê¾å¼õ¤±¼è¤Ã¤Æ¤«¤éɽ¼¨¤ò³«»Ï¤¹¤ë¡£
25for($i = 0; $i < 256; $i++) {
26    print(" ");
27}
28print("\n");
29MyFlush();
30
31if(!$fp) {
32    sfErrorHeader(">> " . $path . "¤Î¼èÆÀ¤Ë¼ºÇÔ¤·¤Þ¤·¤¿¡£");
33} else {
34    print("<img src='".URL_DIR."img/install/main_w.jpg'><br>");
35    MyFlush();
36   
37    // CSV¤Î·ï¿ô¤ò¿ô¤¨¤ë
38    $line = 0;
39    while(!feof($fp)) {
40        fgets($fp, ZIP_CSV_LINE_MAX);
41        $line++;
42    }
43   
44    print("<img src='".URL_DIR."img/install/space_w.gif'>");
45    MyFlush();
46       
47    // ¥Õ¥¡¥¤¥ë¥Ý¥¤¥ó¥¿¤òÌ᤹
48    fseek($fp, 0);
49   
50    // ²èÁü¤ò°ì¸Äɽ¼¨¤¹¤ë·ï¿ô¤òµá¤á¤ë¡£
51    $disp_line = intval($line / IMAGE_MAX);
52   
53    // ´û¤Ë½ñ¤­¹þ¤Þ¤ì¤¿¥Ç¡¼¥¿¤ò¿ô¤¨¤ë
54    $end_cnt = $objQuery->count("mtb_zip");
55    $cnt = 1;
56    $img_cnt = 0;
57    while (!feof($fp)) {
58        $arrCSV = fgetcsv($fp, ZIP_CSV_LINE_MAX);
59       
60        // ¤¹¤Ç¤Ë½ñ¤­¹þ¤Þ¤ì¤¿¥Ç¡¼¥¿¤òÈô¤Ð¤¹¡£
61        if($cnt > $end_cnt) {
62            $sqlval['code'] = $arrCSV[0];
63            $sqlval['old_zipcode'] = $arrCSV[1];
64            $sqlval['zipcode'] = $arrCSV[2];
65            $sqlval['state_kana'] = $arrCSV[3];
66            $sqlval['city_kana'] = $arrCSV[4];
67            $sqlval['town_kana'] = $arrCSV[5];
68            $sqlval['state'] = $arrCSV[6];
69            $sqlval['city'] = $arrCSV[7];
70            $sqlval['town'] = $arrCSV[8];
71            $sqlval['flg1'] = $arrCSV[9];
72            $sqlval['flg2'] = $arrCSV[10];
73            $sqlval['flg3'] = $arrCSV[11];
74            $sqlval['flg4'] = $arrCSV[12];
75            $sqlval['flg5'] = $arrCSV[13];
76            $sqlval['flg6'] = $arrCSV[14]; 
77            $objQuery->insert("mtb_zip", $sqlval);
78        }
79       
80        $cnt++;
81        // $disp_line·ï¤´¤È¤Ë¿ÊĽɽ¼¨¤¹¤ë
82        if($cnt % $disp_line == 0 && $img_cnt < IMAGE_MAX) {
83            print("<img src='".URL_DIR."img/install/graph_1_w.gif'>");
84            MyFlush();
85            $img_cnt++;
86        }
87    }
88    fclose($fp);
89   
90    print("<img src='".URL_DIR."img/install/space_w.gif'><br>\n");
91    print("<table width='700' height='50' border='0' cellpadding='0' cellspacing='0' bgcolor='#494E5F'>\n");
92    print("<tr>\n");
93    print("<td align='center'><a href='javascript:window.close()'><img src='".URL_DIR."img/install/close.gif' alt='CLOSE' width='85' height='22' border='0' /></a></td>\n");
94    print("</tr>\n");
95    print("</table>\n");
96}
97
98function MyFlush() {
99    flush();
100    ob_end_flush();
101    ob_start();
102}
103
104?>
Note: See TracBrowser for help on using the repository browser.