<?
	include_once("dbconnect.php");//設定
	if($_REQUEST["action"] == "exec"){
		if(!$_REQUEST["name"]){
			$error = "お名前を入力してください。";
		}
		if(!$_REQUEST["email"]){
			$error = "メールを入力してください。";
		}
		if(!$_REQUEST["tel"]){
			$error = "TELを入力してください。";
		}
		if(!$error){
			$filename = "./conf/mail_contact_pc.txt";
			$filename_conf = "./conf/mail_contact_pc.php";

			if(file_exists($filename)){
				$handle = fopen($filename, "r");
				$contents1 = "";
				while (!feof($handle)) {
					$contents1 .= fread($handle, 8192);
				}
				fclose($handle);
			}
			if(file_exists($filename_conf)){
				include($filename_conf);
			}
			reset($_REQUEST["id"]);
			$cnt = 1;
			$bukken2 = "";
			while(list ($key, $val) = each ($_REQUEST["id"])) {
				$contents = $contents1;
				$result = mysql_query("select bdata.bdata_id as bdataid,bdata.bukkendata_id as old_bukkendata_id,bdata.*,rdata.*,tbl_vender.* from  bdata left join rdata on bdata.bdata_id = rdata.bdata_id, tbl_vender,tbl_jiscode where bdata.jiscode=tbl_jiscode.jiscode and tbl_vender.vender_id = bdata.vender_id and bdata.sid = '".$val."'");
				if($rows = mysql_num_rows($result)){
					$arr = mysql_fetch_array($result);
					if($arr["address2"]){
						$arr["address2"] .= "丁目";
					}
					if($arr["address23_non_flg"] != "1"){
						$disp["address"] = $arr["city_name1"]."".$arr["city_name2"]."".$arr["address1"]."".$arr["address2"]."".$arr["address3"];
					}else{
						$disp["address"] = $arr["city_name1"]."".$arr["city_name2"]."".$arr["address1"]."".$arr["address2"];
					}
					$disp["address_gyo"] = $arr["city_name1"]."".$arr["city_name2"]."".$arr["address1"]."".$arr["address2"]."".$arr["address3"];

					if($arr["bukken_name_non_flg"] != "1"){
						$disp["bukken_name"] = $arr["bukken_name"]."".$arr["room_number"];
						$disp["bukken"] = $arr["bukken_name"]."".$arr["room_number"];
					}
					$disp["bukken_name_gyo"] = $arr["bukken_name"]."".$arr["room_number"];
					$disp["address_bukken"] = $disp["address"].$disp["bukken_name"];

					if($arr["kakaku_memo"]){
						$disp["kakaku"] = $arr["kakaku_memo"];
					}else{
						$disp["kakaku"] = $arr["kakaku_amt"]."万円";
					}
					if($arr["kubun1"] == "a"){
						$disp["kubun"] = $arr["kubun1_desc"]." ".$arr["kubun3_desc"];
					}else{
						$disp["kubun"] = $arr["kubun1_desc"]." ".$arr["kubun2_desc"];
					}

$bukken = "種別 = ".$disp["kubun"]."
所在地 = ".$disp["address_gyo"].$disp["bukken_name_gyo"]."
価格/賃料 = ".$disp["kakaku"]."
物件ID = ".$arr["bukken_no"]."(".$val.")
内容 = ".$_REQUEST["msg1"][$key]."
name = ".$_REQUEST["name"]."
email = ".$_REQUEST["email"]."
TEL = ".$_REQUEST["tel"]."
通信欄 = ".$_REQUEST["msg2"][$key]."
FAX = ".$_REQUEST["fax"]."
資料送付先 = ".$_REQUEST["address"]."
取り扱い業者 = ".$arr["vender_name"];

$bukken2 .= "
種別 = ".$disp["kubun"]."
所在地 = ".$disp["address_bukken"]."
価格/賃料 = ".$disp["kakaku"]."
物件ID = ".$arr["bukken_no"]."(".$val.")
内容 = ".$_REQUEST["msg1"][$key]."
通信欄 = ".$_REQUEST["msg2"][$key]."
─────────────────────────";

$info = "送信日時 : ".date("Y-m-d H:i:s",date("U"))."
ブラウザ : ".$_SERVER["HTTP_USER_AGENT"]."
ホスト名 : ".gethostbyaddr($_SERVER["REMOTE_ADDR"]);

					$smsg = str_replace("##bukken##",$bukken,$contents);
					$smsg = str_replace("##info##",$info,$smsg);

					$to = $arr["email"];
					if(!$to){
						$to = $MAIL_FROM;
					}
					$to = "miyamoto@industry.co.jp";
					$subject = $MAIL_SUBJECT;
					
					if($_REQUEST["email"]){
						$from_name = $_REQUEST["name"];
						$from = $_REQUEST["email"];
						$replyto = $_REQUEST["email"];
						$returnpath = $_REQUEST["email"];
					}else{
						$from_name = $MAIL_FROM_NAME;
						$from = $MAIL_FROM;
						$replyto = $MAIL_REPLYTO;
						$returnpath = $replyto;
					}
					SendMail2($to,$subject,$smsg,$cc,"",$from_name,$from,$replyto,$returnpath);

					$sql = "";
					$sql = sql_insert($sql,"system_id",$system_id);
					if($_SESSION["MY_user_id"]){
						$sql = sql_insert($sql,"user_id",$_SESSION["MY_user_id"]);
					}
					$sql = sql_insert($sql,"bukken_id",$val);
					$sql = sql_insert($sql,"vender_id",$arr["vender_id"]);
					$sql = sql_insert($sql,"sendemail",$to);
					$sql = sql_insert($sql,"sendmail",$smsg);
					$sql = sql_insert($sql,"name",$_REQUEST["name"]);
					$sql = sql_insert($sql,"email",$_REQUEST["email"]);
					$sql = sql_insert($sql,"tel",$_REQUEST["tel"]);
					$sql = sql_insert($sql,"fax",$_REQUEST["fax"]);
					$sql = sql_insert($sql,"zipcode",$_REQUEST["zipcode"]);
					$sql = sql_insert($sql,"address",$_REQUEST["address"]);
					$sql = sql_insert($sql,"note1",$_REQUEST["msg1"][$key]);
					$sql = sql_insert($sql,"note2",$_REQUEST["msg2"][$key]);
					$sql = sql_insert($sql,"note3","");
					$sql = sql_insert($sql,"createtime",date("Y-m-d H:i:s"));
					mysql_query("insert into contact ".$sql);
				}
			}
			$msg = "このメールは自動送信でお送りしています。
以下のとおり「ココスマ」物件お問い合わせを承りました。

────────────────────────────
▼送信内容
────────────────────────────

".$bukken2;
			//メール送信
			SendMail2($_REQUEST["email"],"物件お問い合わせありがとうございました",$msg,$cc,"",$MAIL_FROM_NAME,$MAIL_FROM,$MAIL_REPLYTO,$MAIL_REPLYTO);

			//送信完了画面へ
			header("Location: thanks.html");
			exit;
		}
	}
	//セッションがある場合自動入力
	if($_SESSION["MY_user_id"]){
		$result = mysql_query("select * from user where system_id = '".$system_id."' and id = '".$_SESSION["MY_user_id"]."'");
		if(mysql_num_rows($result) == 1){
			$arr = mysql_fetch_array($result);
			$_POST["name"] = $arr["name1"]." ".$arr["name2"];
			$_POST["email"] = $arr["email"];
			$_POST["tel"] = $arr["tel"];
			$_POST["fax"] = $arr["fax"];
			$_POST["zipcode"] = $arr["zipcode1"]."-".$arr["zipcode2"];
			$_POST["address"] = $arr["pref"]."".$arr["city"]."".$arr["address1"]."".$arr["address2"];
		}
	}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>お問い合わせ</title>
<script type="text/javascript" src="/web/js/check.js"></script>
</head>
<body>
<form id="form1" name="form1" method="post" action="<? echo $_SERVER[" PHP_SELF"]; ?>">
<input name="action" type="hidden" id="action" value="exec" />
<table cellpadding="5" cellspacing="1" bgcolor="#333333">
<tr>
<td bgcolor="#ffffac" class="main"><b>物件お問い合わせ</b></td>
</tr>
<tr>
<td align="center" bgcolor="#ffffff"><table border="0">
<tr>
<td align="left"><span>お問い合わせ以外の物件もお探しいたします。<br/>
お気軽にお問い合わせください。</span></td>
</tr>
<tr>
<td align="left"><font color="#ff0000">*印は、入力必須です。</font></td>
</tr>

<tr>
<td align="left"><br><br><font color="#ff0000"></font><br><br></td>
</tr>

<tr>
<td><table border="0">
<tr>
<td align="right" valign="top"><span><font color="#ff0000">*</font>お名前</span></td>
<td align="left"><input type="text" name="name" size="35" style="ime-mode:active;" value="<? echo $_POST[" name"]; ?>" /></td>
</tr>
<tr>
<td align="right" valign="top"><span><font color="#ff0000">*</font>メール</span></td>
<td align="left"><input type="text" name="email" size="35" style="ime-mode:disabled;" value="<? echo $_POST[" email"]; ?>" /></td>
</tr>
<tr>
<td align="right" valign="top"><span><font color="#ff0000">*</font>TEL</span></td>
<td align="left"><input type="text" name="tel" size="35" style="ime-mode:inactive;" value="<? echo $_POST[" tel"]; ?>" /></td>
</tr>
<tr>
<td align="right" valign="top"><span>FAX</span></td>
<td align="left"><input type="text" name="fax" size="35" style="ime-mode:inactive;" value="<? echo $_POST[" fax"]; ?>" />
<br/>
<font color="#ff0000">※FAXで資料送付をご希望の方は、必ず入力してください。</font></td>
</tr>
<tr>
<td align="right" valign="top"><span>資料送付先</span></td>
<td align="left">〒<input name="zipcode" type="text" id="zipcode" style="ime-mode:active;" size="10" value="<? echo $_POST[" zipcode"]; ?>" />
<br/>
<input type="text" name="address" size="35" style="ime-mode:active;" value="<? echo $_POST[" address"]; ?>" />
<br/>
<font color="#ff0000">※郵送で資料送付をご希望の方は、必ず入力してください。</font></td></tr>
</table>
<br/></td>
</tr>
<tr>
<td><table border="1" cellpadding="5" cellspacing="0">
<tr>
<td nowrap="nowrap" bgcolor="#CCCCCC">　</td>
<td nowrap="nowrap" bgcolor="#CCCCCC"><strong>物件</strong></td>
<td nowrap="nowrap" bgcolor="#CCCCCC"><strong>お問い合わせ内容</strong></td>
<td valign="bottom" nowrap="nowrap" bgcolor="#CCCCCC"><strong>その他質問事項があればご記入ください</strong></td>
</tr>

<tr>
<td></td>
<td nowrap="nowrap" align="left"><b><br/>
&nbsp;<br/>
<br/>
</b>の物件について<input type="hidden" name="id[<? echo $val; ?>]" value="<? echo $val; ?>"></td>
<td nowrap="nowrap"><select name="msg1[<? echo $val; ?>]">
<option value="物件について質問したい">物件について質問したい</option>
<option value="物件の詳細な資料がほしい">物件の詳細な資料がほしい</option>
<option value="物件を見てみたい">物件を見てみたい</option>
<option value="条件が近い他の物件を紹介してほしい">条件が近い他の物件を紹介してほしい</option>
<option value="直接話しを聞きたいい">直接話しを聞きたい</option>
</select></td>
<td valign="bottom" nowrap="nowrap"><textarea name="msg2[<? echo $val; ?>]" cols="30" rows="5" style="ime-mode:active;"></textarea>
</td>
</tr>

<tr>
<td nowrap="nowrap" colspan="4">物件が見つかりませんでした。</td>
</tr>

</table>
<br/></td>
</tr>
<tr>
<td align="center"><input type="submit" name="Submit" value="送信する" onclick="return check()" />
<input name="reset" type="reset" id="reset" value="リセット" /></td>
</tr>
</table></td>
</tr>
</table>
</form>
</body>
</html>