1 | <?php |
---|
2 | /* |
---|
3 | * Copyright(c) 2000-2007 LOCKON CO.,LTD. All Rights Reserved. |
---|
4 | * |
---|
5 | * http://www.lockon.co.jp/ |
---|
6 | */ |
---|
7 | require_once("../require.php"); |
---|
8 | |
---|
9 | ini_set("max_execution_time", 600); |
---|
10 | |
---|
11 | define("ZIP_CSV_LINE_MAX", 8192); |
---|
12 | define("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 | // ǧ¾Ú²ÄÈݤÎȽÄê |
---|
20 | sfIsSuccess($objSess); |
---|
21 | |
---|
22 | $fp = fopen($path, "r"); |
---|
23 | |
---|
24 | // °ìÉô¤ÎIE¤Ï256¥Ð¥¤¥È°Ê¾å¼õ¤±¼è¤Ã¤Æ¤«¤éɽ¼¨¤ò³«»Ï¤¹¤ë¡£ |
---|
25 | for($i = 0; $i < 256; $i++) { |
---|
26 | print(" "); |
---|
27 | } |
---|
28 | print("\n"); |
---|
29 | MyFlush(); |
---|
30 | |
---|
31 | if(!$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 | |
---|
98 | function MyFlush() { |
---|
99 | flush(); |
---|
100 | ob_end_flush(); |
---|
101 | ob_start(); |
---|
102 | } |
---|
103 | |
---|
104 | ?> |
---|