<?
/******************************************************
' System :Eco-footprint 会員ページ
' Content:郵便番号検索
'******************************************************/

$top = '.';
$inc = "$top/../inc";
include("$inc/common.php");
include("$inc/database.php");

//===  <option>タグ出力 ===
function option($val, $sel) {
	if ($val == $sel)
		$selected = ' selected';

	return "<option$selected>$val</option>\n";
}

//=== 市区町村選択肢出力 ===
function write_shikuchouson($todoufuken, $shikuchouson) {
	echo '<option ', value_selected('', $shikuchouson), ">　─お選びください─　</option>\n";
	if ($todoufuken != '') {
		$sql = "SELECT zc_shikuchouson,MIN(zc_seq_no) AS seq_no FROM m_zip WHERE zc_todoufuken='$todoufuken' GROUP BY zc_shikuchouson ORDER BY seq_no";
		$result = db_exec($sql);
		$nrow = pg_numrows($result);
		for ($i = 0; $i < $nrow; $i++) {
			$fetch = pg_fetch_object($result, $i);
			echo option($fetch->zc_shikuchouson, $shikuchouson);
		}
	}
}

//=== 町名表示 ===
function write_choumei($todoufuken, $shikuchouson) {
	$sql = "SELECT zc_zip_cd,zc_chouiki FROM m_zip WHERE zc_todoufuken='$todoufuken' AND zc_shikuchouson='$shikuchouson' ORDER BY zc_seq_no";
	$result = db_exec($sql);
	$nrow = pg_numrows($result);
	for ($i = 0; $i < $nrow; $i++) {
		$fetch = pg_fetch_object($result, $i);
	  $zip_cd = $fetch->zc_zip_cd;
	  echo "<option value='$zip_cd'>",substr($zip_cd, 0, 3), '-', substr($zip_cd, 3, 4), "&nbsp;$fetch->zc_chouiki</option>\n";
	}
}
?>
<html lang="ja">
	<head>
		<meta http-equiv="content-type" content="text/html;charset=EUC-JP">
		<meta http-equiv="Pragma" content="no-cache">
		<title>郵便番号かんたんサーチ</title>
<SCRIPT LANGUAGE=javascript>
<!--
function OnChange_todoufuken() {
  document.form1.sel_mode.value = "1";
  document.form1.submit();
}
function OnChange_shikuchouson() {
  document.form1.sel_mode.value = "2";
  document.form1.submit();
}
function OnChange_choumei() {
	var index, zip;
	if (opener && !opener.closed) {
		index = document.form1.choumei.selectedIndex;
		if (index >= 0) {
			zip = document.form1.choumei.options[index].value;
			opener.document.form1.zip1.value = zip.substr(0, 3);
			opener.document.form1.zip2.value = zip.substr(3, 4);
			window.close();
		}
	}
}
//-->
</SCRIPT>
	</head>

	<body bgcolor="white" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
		<form method="post" name="form1">
		<br>
		<table border="0" cellspacing="0" mm_noconvert="TRUE" cellpadding="0">
			<tr height="36">
				<td width="50" height="36" align="right" valign="top"></td>
				<td width="550" height="36" valign="top">
					<div align="left">
						<font color="#2f2180"><b>■郵便番号検索</b></font></div>
				</td>
			</tr>
			<tr height="36">
				<td width="50" height="36" align="right" valign="top"></td>
				<td width="550" height="36"><font size="2"><font color="#ff3300"><b>
					１．都道府県を選んだ後に、市区町村を選んで下さい。</b></font><br>
					&nbsp;&nbsp;&nbsp;&nbsp;（検索結果に調べた郵便番号が表示されます。）</font></td>
			</tr>
			<tr>
				<td width="50" align="right" valign="top">　</td>
				<td width="550" align="left" valign="top"><br>
					<table border="0" cellpadding="0" cellspacing="2" width="376">
						<tr>
							<td width="40"></td>
							<td><font size="2" color="#b2cce4">■</font><font size="2">都道府県</font></td>
							<td><select name="todoufuken" size="1" onChange="OnChange_todoufuken()">
									<option <?=value_selected('', $todoufuken)?>>　─お選びください─　</option>
									<?=option("北海道", $todoufuken)?>
									<?=option("青森県", $todoufuken)?>
									<?=option("岩手県", $todoufuken)?>
									<?=option("宮城県", $todoufuken)?>
									<?=option("秋田県", $todoufuken)?>
									<?=option("山形県", $todoufuken)?>
									<?=option("福島県", $todoufuken)?>
									<?=option("茨城県", $todoufuken)?>
									<?=option("栃木県", $todoufuken)?>
									<?=option("群馬県", $todoufuken)?>
									<?=option("埼玉県", $todoufuken)?>
									<?=option("千葉県", $todoufuken)?>
									<?=option("東京都", $todoufuken)?>
									<?=option("神奈川県", $todoufuken)?>
									<?=option("新潟県", $todoufuken)?>
									<?=option("富山県", $todoufuken)?>
									<?=option("石川県", $todoufuken)?>
									<?=option("福井県", $todoufuken)?>
									<?=option("山梨県", $todoufuken)?>
									<?=option("長野県", $todoufuken)?>
									<?=option("岐阜県", $todoufuken)?>
									<?=option("静岡県", $todoufuken)?>
									<?=option("愛知県", $todoufuken)?>
									<?=option("三重県", $todoufuken)?>
									<?=option("滋賀県", $todoufuken)?>
									<?=option("京都府", $todoufuken)?>
									<?=option("大阪府", $todoufuken)?>
									<?=option("兵庫県", $todoufuken)?>
									<?=option("奈良県", $todoufuken)?>
									<?=option("和歌山県", $todoufuken)?>
									<?=option("鳥取県", $todoufuken)?>
									<?=option("島根県", $todoufuken)?>
									<?=option("岡山県", $todoufuken)?>
									<?=option("広島県", $todoufuken)?>
									<?=option("山口県", $todoufuken)?>
									<?=option("徳島県", $todoufuken)?>
									<?=option("香川県", $todoufuken)?>
									<?=option("愛媛県", $todoufuken)?>
									<?=option("高知県", $todoufuken)?>
									<?=option("福岡県", $todoufuken)?>
									<?=option("佐賀県", $todoufuken)?>
									<?=option("長崎県", $todoufuken)?>
									<?=option("熊本県", $todoufuken)?>
									<?=option("大分県", $todoufuken)?>
									<?=option("宮崎県", $todoufuken)?>
									<?=option("鹿児島県", $todoufuken)?>
									<?=option("沖縄県", $todoufuken)?>
								</select></td>
						</tr>
						<tr>
							<td width="40"></td>
							<td><font size="2" color="#b2cce4">■</font><font size="2">市区町村</font></td>
							<td><select name="shikuchouson" size="1" onChange="OnChange_shikuchouson()">
<?write_shikuchouson($todoufuken, $shikuchouson)?>
								</select></td>
						</tr>
					</table><br>
				</td>
			</tr>
			<tr height="36">
				<td width="50" height="36">　 </td>
				<td width="550" height="36">
					<hr>
<?if ($sel_mode == '2') {?>
					<table border="0" cellpadding="0" cellspacing="0">
						<tr>
							<td align="left" valign="top" width="40"></td>
							<td width="441" align="left" valign="top"><b>検索結果<br>
								</b><br>
								<select name="choumei" size=8 onChange="OnChange_choumei()">
<?write_choumei($todoufuken, $shikuchouson)?>
								</select>
								<br><br>
								</a><font size="2"><font color="#ff3300"><b>２．郵便番号をクリックしてください。</b></font><br>
								（郵便番号をクリックすると、登録画面に自動的に表示されます。）</font>
							</td>
							<td><img src="img/nyuukai/zou_img/zip.gif" border="0"></td>
						</tr>
					</table>
<?}?>
				</td>
			</tr>
		</table>
		<input type="hidden" name="sel_mode">
		</form>
	</body>

</html>
