<?
	require_once('inc/com.php');


	if($_GET['cid']<>'' and $_GET['iid']<>'')
	{
		$SQL = '';
		$SQL .= ' SELECT *, a.datetime_add as a_datetime_add ';
		$SQL .= ' FROM i_item as a ';
		$SQL .= ' INNER JOIN i_corp as b on b.c_id = a.c_id ';
		$SQL .= ' WHERE a.active = 1 ';
		$SQL .= ' AND b.active = 1 ';
		$SQL .= ' AND a.i_status = 1 ';
		$SQL .= ' AND '.date('Ymd').' <= a.i_open ';
		$SQL .= ' AND a.c_id = "'.SQL_ESC($_GET['cid']).'" ';
		$SQL .= ' AND a.i_id = "'.SQL_ESC($_GET['iid']).'" ';
		$objRecord5 = mysql_query($SQL);
		while ($item5 = mysql_fetch_array($objRecord5))
		{
			$c_id			= "${item5['c_id']}";
			$i_id			= "${item5['i_id']}";
			$i_mode			= "${item5['i_mode']}";
			$i_status		= "${item5['i_status']}";
			$i_mode2		= "${item5['i_mode2']}";
			$i_open			= "${item5['i_open']}";
			$i_area			= "${item5['i_area']}";
			$i_zip			= urldecode("${item5['i_zip']}");
			$i_add			= urldecode("${item5['i_add']}");
			$i_access		= urldecode("${item5['i_access']}");
			$i_map_x		= urldecode("${item5['i_map_x']}");
			$i_map_y		= urldecode("${item5['i_map_y']}");
			$i_data			= urldecode("${item5['i_data']}");
			$order_menseki1_1 = urldecode("${item5['order_menseki1_1']}");
			$order_menseki1_2 = urldecode("${item5['order_menseki1_2']}");
			$order_menseki2_1 = urldecode("${item5['order_menseki2_1']}");
			$order_menseki2_2 = urldecode("${item5['order_menseki2_2']}");
			$i_contact_sum	= "${item5['i_contact_sum']}";
			$datetime_add	= "${item5['a_datetime_add']}";
	//		$datetime_edit	= "${item5['datetime_add']}";
	//		$active
	//		$c_id
			$c_code			= urldecode("${item5['c_code']}");
			$c_name			= urldecode("${item5['c_name']}");
			$c_gyousyu		= urldecode("${item5['c_gyousyu']}");
			$c_daihyou		= urldecode("${item5['c_daihyou']}");
			$c_tantou		= urldecode("${item5['c_tantou']}");
			$c_zip			= urldecode("${item5['c_zip']}");
			$c_add			= urldecode("${item5['c_add']}");
			$c_tel			= urldecode("${item5['c_tel']}");
			$c_fax			= urldecode("${item5['c_fax']}");
			$c_mail			= urldecode("${item5['c_mail']}");
	//		$c_pw			= urldecode("${item5['c_pw']}");
	//		$login_key		= urldecode("${item5['login_key']}");
			$kyoka1			= urldecode("${item5['kyoka1']}");
			$kyoka2			= urldecode("${item5['kyoka2']}");
			$kyoka3			= urldecode("${item5['kyoka3']}");
			$mode_b			= urldecode("${item5['mode_b']}");
			$mode_c			= urldecode("${item5['mode_c']}");
	//		$datetime_add	= "${item5['datetime_add']}";
	//		$datetime_edit	= "${item5['datetime_add']}";

			if($order_menseki1_1==0 or $order_menseki1_1==9999)	$order_menseki1_1 = '';
			if($order_menseki1_2==0 or $order_menseki1_2==9999)	$order_menseki1_2 = '';
			if($order_menseki2_1==0 or $order_menseki2_1==9999)	$order_menseki2_1 = '';
			if($order_menseki2_2==0 or $order_menseki2_2==9999)	$order_menseki2_2 = '';


			if($i_mode=='b') $mode_name = $mode_b;
			if($i_mode=='c') $mode_name = $mode_c;

			//-----見たリストに追加
			$SQL = '';
			$SQL .= ' INSERT INTO log_item_watch ';
			$SQL .= ' (active, u_session_id, c_id, i_id) VALUES ';
			$SQL .= ' (\'1\', \''.SQL_ESC(session_id()).'\', \''.SQL_ESC($c_id).'\', \''.SQL_ESC($i_id).'\');';
			$objRecord4 = mysql_query($SQL);


		}
	}

	if($i_id=='')
		header('Location: index.php');


	//-----キニナルフラグの確認
	$i_kininaru = 0;
	$SQL = '';
	$SQL .= ' SELECT * ';
	$SQL .= ' FROM log_item_watch ';
	$SQL .= ' WHERE active = 1 ';
	$SQL .= ' AND u_session_id = "'.SQL_ESC(session_id()).'" ';
	$SQL .= ' AND c_id = "'.SQL_ESC($c_id).'" ';
	$SQL .= ' AND i_id = "'.SQL_ESC($i_id).'" ';
	$objRecord5 = mysql_query($SQL);
	while ($item5 = mysql_fetch_array($objRecord5))
	{
		$i_kininaru = "${item5['i_kininaru']}";
	}


	if($_GET['mode']=='add')
	{
		$SQL = '';
		$SQL .= ' UPDATE log_item_watch SET ';
		$SQL .= ' i_kininaru = \'1\' ';
		$SQL .= ' WHERE u_session_id = "'.SQL_ESC(session_id()).'" ';
		$SQL .= ' AND c_id = "'.SQL_ESC($c_id).'" ';
		$SQL .= ' AND i_id = "'.SQL_ESC($i_id).'";';
		$objRecord5 = mysql_query($SQL);
	}
	if($_GET['mode']=='del')
	{
		$SQL = '';
		$SQL .= ' UPDATE log_item_watch SET ';
		$SQL .= ' i_kininaru = \'0\' ';
		$SQL .= ' WHERE u_session_id = "'.SQL_ESC(session_id()).'" ';
		$SQL .= ' AND c_id = "'.SQL_ESC($c_id).'" ';
		$SQL .= ' AND i_id = "'.SQL_ESC($i_id).'";';
		$objRecord5 = mysql_query($SQL);
	}
	if($_GET['mode'])
		header('Location: item.php?cid='.$c_id.'&iid='.$i_id);


	$SQL = '';
	$SQL .= ' UPDATE log_item_watch SET ';
	$SQL .= ' datetime_edit = "'.date('Ymd_His').'" ';
	$SQL .= ' WHERE u_session_id = "'.SQL_ESC(session_id()).'" ';
	$SQL .= ' AND c_id = "'.SQL_ESC($c_id).'" ';
	$SQL .= ' AND i_id = "'.SQL_ESC($i_id).'";';
	$objRecord5 = mysql_query($SQL);


	if($_POST['submit'])
	{
		$e_msg = '';

		$user_corp = $_POST['user_corp'];
		if($user_corp=='') $e_msg .= '「会社名」をご記入下さい<br>';

		$user_name = $_POST['user_name'];
		if($user_name=='') $e_msg .= '「担当者名」をご記入下さい<br>';

		$user_tel = $_POST['user_tel'];
		$user_mail = $_POST['user_mail'];

		if($user_tel=='' and $user_mail=='')
		{
			$e_msg .= '「電話番号 もしくは メールアドレス」をご記入下さい<br>';
		}

		$user_body = $_POST['user_body'];
		if($user_body=='') $e_msg .= '「お問い合わせ内容」をご記入下さい<br>';


		if($e_msg=='')
		{


			$mSUBJECT	= '射水市事業用不動産ナビ：'.$user_name.'様より';

			$mBODY		= '';
			$mBODY		.= FILE_LOAD('./doc/mail/request_corp.txt');
			$mBODY		.= ''."\n";
			$mBODY		.= ''."\n";
			$mBODY		.= '■物件'."\n";
			$mBODY		.= $i_add."\n";
			$mBODY		.= ''."\n";
			$mBODY		.= '■URL'."\n";
			$mBODY		.= 'http://www.shokoren-toyama.or.jp/~imizu/est-navi/item.php?cid='.$c_id.'&iid='.$i_id."\n";
			$mBODY		.= ''."\n";
			$mBODY		.= ''."\n";
			$mBODY		.= '■会社名'."\n";
			$mBODY		.= $user_corp."\n";
			$mBODY		.= ''."\n";
			$mBODY		.= '■お名前'."\n";
			$mBODY		.= $user_name."\n";
			$mBODY		.= ''."\n";
			$mBODY		.= '■電話番号 '."\n";
			$mBODY		.= $user_tel."\n";
			$mBODY		.= ''."\n";
			$mBODY		.= '■メールアドレス '."\n";
			$mBODY		.= $user_mail."\n";
			$mBODY		.= ''."\n";
			$mBODY		.= '■お問い合わせ内容 '."\n";
			$mBODY		.= $user_body."\n";
			$mBODY		.= ''."\n";

			ini_set('mbstring.internal_encoding','UTF-8'); 
			mb_language('japanese');
			$from = mb_encode_mimeheader(mb_convert_encoding('射水市商工会','JIS','UTF-8')).'<daimon@shokoren-toyama.or.jp>';
			mb_send_mail($c_mail,'射水市事業用不動産ナビ：'.FILE_LOAD('./doc/mail/request_corp_s.txt'),$mBODY,'From: '.$from);


			//-----商工会へメール（件名にコピーの文字を入れる）
			ini_set('mbstring.internal_encoding','UTF-8'); 
			mb_language('japanese');
			$from = mb_encode_mimeheader(mb_convert_encoding('射水市商工会','JIS','UTF-8')).'<daimon@shokoren-toyama.or.jp>';

			$mTO = 'daimon@shokoren-toyama.or.jp';
			mb_send_mail($mTO,'射水市事業用不動産ナビ：'.FILE_LOAD('./doc/mail/request_corp_s.txt').'[コピー]',$mBODY,'From: '.$from);


			$SQL = '';
			$SQL .= ' UPDATE i_item SET ';
			$SQL .= ' i_contact_sum = \''.($i_contact_sum+1).'\' ';
			$SQL .= ' WHERE c_id = "'.SQL_ESC($c_id).'" ';
			$SQL .= ' AND i_id = "'.SQL_ESC($i_id).'";';
			$objRecord5 = mysql_query($SQL);


			$SQL = '';
			$SQL .= ' INSERT INTO log_contact ';
			$SQL .= ' (active, c_id, i_id, datetime_add, m_body) VALUES ';
			$SQL .= ' (\'1\', \''.SQL_ESC($c_id).'\', \''.SQL_ESC($i_id).'\', \''.date('Y-m-d H:i:s').'\', \''.urlencode($mBODY).'\');';
			$objRecord5 = mysql_query($SQL);

//			header('Location: item.php?cid='.$c_id.'&iid='.$i_id.'&mode=ok#contact');
			header('Location: contact_ok.php');

		}
	}


	$keywords		= $c_name.','.$mode_name.','.$i_add;
	$description	= $c_name.'の'.$mode_name.'物件です '.$i_add;

?><!doctype html>
<html><!-- InstanceBegin template="/Templates/main.dwt.php" codeOutsideHTMLIsLocked="false" -->
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, maximum-scale=1.0, minimum-scale=0.5,user-scalable=yes,initial-scale=1.0">
<meta name="format-detection" content="telephone=no">
<!-- InstanceBeginEditable name="doctitle" -->
<title> ( ) 射水空き物件ナビ</title>
<!-- InstanceEndEditable -->
<meta name="description" content="">
<meta name="keywords" content="">
<script src="//ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
<link href="css/main.css" rel="stylesheet" type="text/css">
<!-- InstanceBeginEditable name="head" -->
<link href="css/item.css" rel="stylesheet" type="text/css">

<link rel="stylesheet" href="js/lightbox2-master/css/lightbox.css">
<script src="js/lightbox2-master/js/lightbox.js" type="text/javascript"></script>


<!-- InstanceEndEditable -->

<script>
  (function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
  (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
  m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
  })(window,document,'script','https://www.google-analytics.com/analytics.js','ga');

  ga('create', 'UA-92822712-1', 'auto');
  ga('send', 'pageview');

</script>
</head>

<body>

<div id="hd">
<div class="waku">
<div class="waku_in">
<div class="box1"><h1><a href="index.php"><img src="img/logo.png" alt="射水空き物件ナビ" width="300" height="75"></a></h1></div>
<div class="box2">

<div class="txt1">富山県射水市内の空き工場、倉庫、事務所、事業用地などの物件情報をご紹介します。<br>お持ちの物件の登録受け付けております。<br>現在の公開数 <strong>0 件</strong>　これまでの成約数 <strong>0 件</strong></div>

</div>
<br class="cb">
</div>
</div>
</div>

<div id="mn">
<div class="waku">
<div class="waku_in">
<ul>
<li ><a href="index.php">TOP</a></li>
<li ><a href="search.php">物件検索</a></li>
<li ><a href="info1.php">物件をお探しの方</a></li>
<li ><a href="info2.php">物件をお持ちの方</a></li>
<li ><a href="project.php">当事業について</a></li>
<li ><a href="contact.php">お問い合わせ</a></li>
<li ><a href="link.php">リンクページ</a></li>
<!--<li ><a href="../smap.php">サイトマップ</a></li>-->
</ul>
<br>
</div>
</div>
</div>


<div class="waku">
<div class="waku_in">
<!-- InstanceBeginEditable name="fm" -->

<div id="nav"><a href="index.php">TOP</a> > <a href="search.php">物件検索</a> > <a href="search.php?area=">エリア（）</a>> </div>
<!-- InstanceEndEditable -->
<div id="fm">
<div id="fm1"><!-- InstanceBeginEditable name="main" -->


<h2>　</h2>

<div id="item">

<div style="text-align:right; font-size:12px; margin:0 0 10px 0;">
　登録日：