<?php
/*
 * ポータルCMSシステム・GoogleMap対応
 * Copyright (c) 2010-2024 by Crytus All rights reserved.
 *
 * 【注意】このファイルを誤って修正すると出力ができなくなります。
 * 修正する前に必ずファイルのコピーを保存しておいてください。
 *
 * 2013/07/18 get_newinfo処理修正
 * 2016/08/04 新CMS対応
 * 2016/09/02 登録・更新日時出力対応
 * 2016/09/03 問い合わせ機能修正
 * 2016/09/07 詳細画面HTMLファイル指定
 * 2017/04/10 同日のお知らせを表示可能に
 * 2017/09/04 複数項目の検索処理の問題を修正
 * 2019/02/24 登録者へ問い合わせメール送信、一覧にこだわり条件
 * 2019/09/05 管理画面の入力機能追加対応
 * 2022/04/15 検索機能強化、MIMEタイプ追加
 * 2022/12/15 閲覧履歴機能追加
 * 2023/10/30 ファイルタイトル、mimetypeの設定
 * 2024/01/12 任意のhtmlを出力する
 * 2024/04/01 記事・カレンダー対応
 */
ini_set("short_open_tag", "0");
ini_set("magic_quotes_gpc", "0");
ini_set("mbstring.encoding_translation", "0");

define("INFO_PROPATY", 4);		// プロパティ
define("HISTORY_MAX", 10);		// 閲覧記録最大数

// エラー出力の指定
error_reporting (E_ALL & ~E_NOTICE & ~E_WARNING & ~E_STRICT & ~E_DEPRECATED);

// データベースの漢字コード
define("DB_ENCODING", "UTF-8");

// メールの漢字コード(UTF-8かJIS)
define("MAIL_ENCODING", "JIS");
//define("MAIL_ENCODING", "UTF8");

// セッションの開始
session_start();

include_once("setup.php");

if (defined("SCRIPT_ENCODING")) {
	$script_encoding = SCRIPT_ENCODING;
} else {
	$script_encoding = "UTF-8";
}
mb_regex_encoding($script_encoding);

// 1ページの件数
if (!defined("PAGE_LIMIT")) {
	define("PAGE_LIMIT", 10);	// 10件
}

// 動作環境チェック
if (!function_exists("mb_convert_encoding")) {
	error_exit("日本語変換処理が使えません。ご確認をお願い致します。");
}
if (!class_exists("PDO")) {
	error_exit("簡易データベース(PDO)が使えません。ご確認をお願い致します。");
} else {
	$ary = PDO::getAvailableDrivers();
	if (!in_array("sqlite", $ary)) {
		error_exit("簡易データベース(SQLite)が使えません。ご確認をお願い致します。");
	}
}
if (!function_exists("ImageCreateFromString")) {
	error_exit("画像処理が組み込まれていません。ご確認をお願い致します。");
}
if (substr(phpversion(), 0, 1) == "4") {
	error_exit("このシステムはPHP5 が必要です。ご確認をお願い致します。");
}
// 異常終了
function error_exit($msg)
{
	echo '<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body>';
	echo $msg;
	echo "</body></html>";
	exit;
}
//-------------------------------------------------------------
// XSS対策
if (is_array($_REQUEST) && (!$_SESSION["LOGIN"])) {
	foreach ($_REQUEST as $k => $v) {
		if (is_array($v)) {
			foreach ($v as $k2 => $v2) {
				$_REQUEST[$k][$k2] = mb_ereg_replace("<.*>", "", $v2);
			}
		} else {
			$_REQUEST[$k] = mb_ereg_replace("<.*>", "", $_REQUEST[$k]);
		}
	}
}
// magic_quotes_gpc対策(PHP5)
if (function_exists("get_magic_quotes_gpc")) {
	if (get_magic_quotes_gpc()) {
		$_REQUEST = safeStripSlashes($_REQUEST);
	}
}
//
include("demo.php");
//
$dbh = new PDO($DB_URI["db"], $DB_URI["user"], $DB_URI["password"]);

function exec_file($file)
{
	global $setup;
	global $DB_URI;
	global $script_encoding;

	if (file_exists("_files/" . $file)) {
		include_once("_files/" . $file);
	} else {
		$php = load_blob($file);
		if ($php) {
			eval("?>" . $php);
		}
	}
}
// 大きなデータを取り出す
function load_blob($key)
{
	global $dbh;

	$sql = "select seq from file_list where name='{$key}'";
	$ret = $dbh->query($sql);
	$val = $ret->fetchAll();

	if ($val) {
		$val = $val[0];
		$id = $val["seq"];
		$file = load_db_file($id);
		return $file;
	}
	return false;
}
function load_db_file($id)
{
	global $dbh;

	$data = "";
	$sql = "select contents from file_contents where file_num={$id} order by seq";
	//$result = sqlite_query($dbh, $sql);
	$stmt = $dbh->query($sql);
	while ($ret = $stmt->fetch(PDO::FETCH_ASSOC)) {
		$data .= $ret["contents"];
	}
	return $data;
}
function safeStripSlashes($var) {
	if (is_array($var)) {
		return array_map('safeStripSlashes', $var);
	} else {
		if (function_exists("get_magic_quotes_gpc")) {
			if (get_magic_quotes_gpc()) {
				$var = stripslashes($var);
			}
		}
		return $var;
	}
}

$act = $_REQUEST["act"];
if (!$act) {
	$act = "index";
}
/*
// 管理画面のログインを無効にする
if (($act == "setup")||($act == "login")) {
	if ($_SERVER["SERVER_NAME"] != "") {
		header("location: ./");
		exit;
	}
}
*/
// バイナリー処理のファイル
$binary = array(
	"png",
	"jpg",
	"gif",
);
if ($act == "file") {
	$file = $_REQUEST["f"];
	if ($file) {
		if (file_exists($file)) {
			$contents = file_get_contents($file);
		} else if (file_exists("_files/" . $file)) {
			$contents = file_get_contents("_files/" . $file);
		} else {
			$contents = load_blob($file);
			$ary = explode(".", $file);
			if (count($ary) > 1) {	// 拡張子あり？
				if (in_array($ary[count($ary)-1], $binary)) {
					$contents = base64_decode($contents);
				}
			}
		}
	}
	header('Content-Type: ' . get_mime_types($file));
	echo $contents;
	exit;
}
// --------------------------------
exec_file("pdo_db.inc");
exec_file("dbaccess.inc");
exec_file("cms.inc");
exec_file("info.inc");
exec_file("info_item.inc");
exec_file("image.inc");
exec_file("item.inc");
exec_file("user.inc");
exec_file("access.inc");
exec_file("htmltemplate.inc");
exec_file("cms_core.php");

$ap = new htmltemplate();
// --------------------------------
$siteinfo = get_setup();
$data["siteinfo"] = $siteinfo;
// ----------------------------------------------
// 地図検索ここから
if ($act == "map_search") {
	if ($_REQUEST["ul"]) {
		$ll_ul = explode(",", $_REQUEST["ul"]);
	}
	if ($_REQUEST["lr"]) {
		$ll_lr = explode(",", $_REQUEST["lr"]);
	}
	if ($_REQUEST["ce"]) {
		$ce = explode(",", $_REQUEST["ce"]);
	}
	if ($_REQUEST["zoom"]) {
		$zoom = $_REQUEST["zoom"];
	}
	if ($ce && $zoom) {
		$_SESSION["MAP"]["lat"] = $ce[0];
		$_SESSION["MAP"]["lng"] = $ce[1];
		$_SESSION["MAP"]["zoom"] = $zoom;
	}
	$ord = "lat,lon";
	$user_id = $_REQUEST["user_id"];
	$kind = $_REQUEST["kind"];
	$propaty = get_item_propaty(false, $kind);
	list($search, $special, $special_item) = search_cond($_REQUEST);
	//
	$list = item_list($kind, $ord, 0, 1000, 0, $search, $special, "", $user_id, $ll_ul, $ll_lr);		// MAX 1000件
	//
	if (!$setup["cluster_num"]) {
		$setup["cluster_num"] = 200;
	}
	if (!$setup["cluster_div"]) {
		$setup["cluster_div"] = 5;
	}
	if (count($list) > $setup["cluster_num"]) {
		// クラスター化
		$list2 = array();
		$x1 = ($ll_ul[0] < $ll_lr[0])? $ll_ul[0]: $ll_lr[0];
		$x2 = ($ll_ul[0] > $ll_lr[0])? $ll_ul[0]: $ll_lr[0];
		$y1 = ($ll_ul[1] < $ll_lr[1])? $ll_ul[1]: $ll_lr[1];
		$y2 = ($ll_ul[1] > $ll_lr[1])? $ll_ul[1]: $ll_lr[1];
		$sx = ($x2 - $x1) / $setup["cluster_div"];
		$sy = ($y2 - $y1) / $setup["cluster_div"];
		$n = 0;
		for ($x = 0; $x < $setup["cluster_div"]; $x++) {
			$px1 = $x1 + $sx * $x;
			$px2 = $x1 + $sx * ($x + 1);
			for ($y = 0; $y < $setup["cluster_div"]; $y++) {
				$py1 = $y1 + $sy * $y;
				$py2 = $y1 + $sy * ($y + 1);
				$items = array();
				foreach ($list as $key => $val) {
					if (($val["lat"] >= $px1)&&($val["lat"] < $px2)&&
						($val["lon"] >= $py1)&&($val["lon"] < $py2)) {
						unset($item);
						$item["info_id"] = $val["info_id"];
						$item["title"] = $val["title"];
						$item["lat"] = $val["lat"];
						$item["lon"] = $val["lon"];
						$items[] = $item;
						//$items[] = $val;
					}
				}
				$list2[$n] = array("list" => $items);
				$list2[$n]["count"] = count($items);
				$n++;
			}
		}
		// 中心位置を求める
		//for ($n = 0; $n < count($list2); $n++) {
		foreach ($list2 as $n => $val) {
			$x = 0.0;
			$y = 0.0;
			if ($list2[$n]["count"] > 0) {
				$count = 0;
				foreach ($list2[$n]["list"] as $val2) {
					if ($val2["lat"] && $val2["lon"]) {
						$x += $val2["lat"];
						$y += $val2["lon"];
						$count++;
					}
				}
				$x = $x / $count;
				$y = $y / $count;
			}
			$list2[$n]["cx"] = $x;
			$list2[$n]["cy"] = $y;
			// アイコンを設定
			foreach ($setup["cluster_icon"] as $num => $v) {
				$list2[$n]["icon"] = $v;
				if ($num >= $list2[$n]["count"]) {
					break;
				}
			}
		}
		$result["list"] = $list2;
		$result["type"] = "2";	// 情報一覧 2->クラスター一覧
		echo mb_convert_encoding(json_encode($result, JSON_PRETTY_PRINT), 'utf8', SCRIPT_ENCODING);
		exit;
	} else {
		// 通常データ
		$list2 = array();
		$items = array();
		$lat = 0;
		$lon = 0;
		$map_id = 0;
		// 同一位置データをまとめる
		foreach ($list as $key => $val) {
			if (($lat && $lon)&&(($lat != $val["lat"])||($lon != $val["lon"]))) {
				$list2[] = $items;
				$items = array();
				$map_id = 0;
			}
			if ($map_id == 0) {
				$map_id = $val["info_id"];
			}
			$val["map_id"] = $map_id;
			$val["image1"] = get_imagefilename($val["image1"]);
			$list[$key]["html"] = $ap->t_buffer("map_files/map.tpl", $val);
			unset($v);
			$v["info_id"] = $val["info_id"];
			$v["kind"] = $val["kind"];
			$v["lat"] = $val["lat"];
			$v["lon"] = $val["lon"];
			$v["html"] = $ap->t_buffer("map_files/map.tpl", $val);		// 吹き出し用・通常
			$v["html_s"] = $ap->t_buffer("map_files/map_s.tpl", $val);	// 吹き出し用・複数対応
			$v["item"] = $ap->t_buffer("map_files/map_item.tpl", $val);	// 一覧用
			$items[] = $v;
			$lat = $val["lat"];
			$lon = $val["lon"];
		}
		if ($items) {
			$list2[] = $items;
		}
		$data["list"] = $list2;
		$data["type"] = "1";	// 情報一覧 2->クラスター一覧
		echo mb_convert_encoding(json_encode($data, JSON_PRETTY_PRINT), 'utf8', SCRIPT_ENCODING);
		exit;
	}
	exit;
}
// 地図検索ここまで
// ----------------------------------------------
// アクセスカウント
if ((!$_SESSION["LOGIN"])&&(!$_SESSION["USER"])) {
	$cond["yy"] = date('Y');
	$cond["mm"] = date('m');
	$cond["dd"] = date('d');
	$ret = Access::findData($cond);
	if ($ret) {
		$cond["user_count"] = $ret[0]["user_count"] + 1;
		Access::updateData($ret[0]["seq"], $cond);
	} else {
		$cond["user_count"] = "1";
		Access::addData($cond);
	}
	$_SESSION["USER"] = time();
	$_SESSION["INFO"] = array();
}
// --------------------------------
if (!$_SESSION["TOTAL"]) {
	$sql = "select count(*) as count,kind from item where open=1 group by kind";
	$inst = DBConnection::getConnection($DB_URI);
	$ret = $inst->search_sql($sql);
	$count = array();
	$total = 0;
	if ($ret["data"]) {
		foreach ($ret["data"] as $val) {
			if ($val["kind"] < 1000) {	// 種類が1000未満が対象
				$count[$val["kind"] - 100] = $val["count"];
				$total += $val["count"];
			}
		}
		$count["total"] = $total;
	}
	$_SESSION["TOTAL"] = $count;
}
$data["total"] = $_SESSION["TOTAL"];
// --------------------------------
if ($act == "list") {	// 一覧
	$page = $_REQUEST["page"];
	if (!$page) {
		$page = 1;
	}
	$ord = $_REQUEST["ord"];
	if (!$ord) {
		$ord = "";
	}
	$kind = $_REQUEST["kind"];
	if (!$kind) {
	//	$kind = "1";
	}
	$top = $_REQUEST["top"];
	if (!$top) {
		$top = "0";
	}
	$limit = $_REQUEST["limit"];
	if (!$limit) {
		$limit = PAGE_LIMIT;
	}
	$user_id = $_REQUEST["user_id"];
	//
	//$html = $_REQUEST["html"];
	//
	$form["ord"] = $ord;
	$form["kind"] = $kind;
	//
	$propaty = get_item_propaty(false, $kind);
	//
	if (!$html) {
		$html = $propaty["list_html"];
	}
	if (substr($html, 0, 4) == "map_") {	// 地図用のhtmlはmap_を先頭に付けてください。
		// 地図検索
		if ($_REQUEST["ul"]) {
			$ll_ul = explode(",", $_REQUEST["ul"]);
		}
		if ($_REQUEST["lr"]) {
			$ll_lr = explode(",", $_REQUEST["lr"]);
		}
		$map_list = "1";	// 地図用一覧
		//
		$data["map"] = $_SESSION["MAP"];
		if ($setup["map_icon"]) {
			$data["map"]["icon"] = json_encode($setup["map_icon"]);
		} else {
			$data["map"]["icon"] = "{}";
		}
		if (defined("GOOGLEMAPKEY")) {
			$data["googlemapkey"] = GOOGLEMAPKEY;
		}
	}
	//
	list($search, $special, $special_item, $ym) = search_cond($_REQUEST, $html);
	$form["special"] = $special_item;
	//
	$data["form"] = $form;
	//
	$data["title"] = $setup["bukken"][$kind];
	$data["map_list"] = "[]";
	list($list, $pager, $counter) = item_list($kind, $ord, $page, $limit, $top, $search, $special, 'and', $user_id, $ll_ul, $ll_lr);		// こだわりAND検索
//	list($list, $pager, $counter) = item_list($kind, $ord, $page, $limit, $top, $search, $special, 'or', $user_id, $ll_ul, $ll_lr);		// こだわりOR検索
	$data["list"] = $list;
	$data["pager"] = $pager;
	$data["counter"] = $counter;
	//
	if ($map_list) {
		$lat_min = 999.9;
		$lat_max = 0.0;
		$lon_min = 999.9;
		$lon_max = 0.0;
		$list2 = array();
		foreach ($list as $key => $val) {
			if ($val["lat"] && $val["lon"]) {	// 位置の設定されているもののみ対象
				$val["image1"] = get_imagefilename($val["image1"]);
				$list[$key]["html"] = $ap->t_buffer("map_files/map.tpl", $val);
				unset($v);
				$v["info_id"] = $val["info_id"];
				$v["kind"] = $val["kind"];
				$v["lat"] = $val["lat"];
				$v["lon"] = $val["lon"];
				$v["html"] = $ap->t_buffer("map_files/map.tpl", $val);
				//$v["item"] = $ap->t_buffer("map_files/map_item.tpl", $val);
				$list2[] = $v;
				// 表示範囲用
				$lat = floatval($val["lat"]);
				$lon = floatval($val["lon"]);
				if ($lat_min > $lat) $lat_min = $lat;
				if ($lat_max < $lat) $lat_max = $lat;
				if ($lon_min > $lon) $lon_min = $lon;
				if ($lon_max < $lon) $lon_max = $lon;
			}
		}
		$data["map_list"] = mb_convert_encoding(json_encode($list2), 'utf8', SCRIPT_ENCODING);
		//
		if ($lat_max != 0.0) {	// 表示物件あり
			// 表示中心
			$lat = ($lat_max - $lat_min) / 2 + $lat_min;
			$lon = ($lon_max - $lon_min) / 2 + $lon_min;
			$data["map"]["lat"] = $lat;
			$data["map"]["lng"] = $lon;
			// 対象物件がすべて表示されるようにズーム倍率を求める
			$dist = $lat_max - $lat_min;
			if ($dist < ($lon_max - $lon_min)) {
				$dist = $lon_max - $lon_min;
			}
			$data["map"]["zoom"] = 12;
/*
			if ($dist < 1.0) {
				$data["map"]["zoom"] = 9;
			}
			if ($dist < 0.5) {
				$data["map"]["zoom"] = 11;
			}
*/
			if ($dist < 0.2) {
				$data["map"]["zoom"] = 12;
			}
			if ($dist < 0.1) {
				$data["map"]["zoom"] = 13;
			}
			if ($dist < 0.05) {
				$data["map"]["zoom"] = 14;
			}
			if ($dist < 0.02) {
				$data["map"]["zoom"] = 15;
			}
			//putlog("dist:" . $dist);
			//putlog("zoom:" . $data["map"]["zoom"]);
		}
	}
	$data["order"] = $ord;
	$data["ord" . $ord] = "1";
	$data["kind"] = $kind;
	$data["limit"] = $limit;
	$data["html"] = $html;
	$data["top"] = $top;
	// 登録者一覧
	$data["user"] = user_list(array(), $user_id);
	// 特定登録者指定
	if ($user_id) {
		$data["user_info"] = User::getData($user_id);
	}
	//
	if (!$html) {
		$html = $propaty["list_html"];
	}
	//
	//$data["option11"] = item_list($kind, 0, 0, 10, 2);  ●●●お知らせ（option11）
	$data["option11"] = item_list(0, 0, 0, 10, 2);		// option11を全項目対象に出力させる追加設定
	//$data["option12"] = item_list($kind, 0, 0, 5, 3);  ●●●管理者おすすめサイト（option12）
	$data["option12"] = item_list(0, 0, 0, 5, 3); // ●●●option12を全項目対象に出力させる追加設定
	// 売買物件一覧のページに賃貸の一覧も出す例
	//if ($kind == 1) {	// 売買の一覧
	//	$data["list2"] = item_list(2, 0, 0, 10, 1);	// 種類2（不動産情報(賃貸物件)）新着10件
	//}
	// --- カレンダー作成 ---
	if ($html == "calender.html") {
		// 月間カレンダー
		$data["y"] = $y;
		$data["m"] = $m;
		// 前月、次月のリンク
		$prev_t = mktime(0, 0, 0, $m - 1, 1, $y);	// 前月
		$next_t = mktime(0, 0, 0, $m + 1, 1, $y);	// 次月
		$data["prev_ym"] = "./?act=list&kind={$kind}&y=" . date("Y", $prev_t) . "&m=" . date("m", $prev_t);
		$data["next_ym"] = "./?act=list&kind={$kind}&y=" . date("Y", $next_t) . "&m=" . date("m", $next_t);
		// カレンダーに予定を書き込む
		foreach ($ym["week"] as $wk => $week) {
			foreach ($week["day"] as $dk => $day) {
				foreach ($list as $val) {
					unset($v);
					if ($val["info1"]["value"] == $day["ymd"]) {	// info1が年月日の場合
						$v["text"] = $val["title"] . "\n";	// 見出し
						$v["link"] = "./?act=detail&id=" . $val["info_id"];	// 詳細へのリンク
					}
					if ($v) {
						$ym["week"][$wk]["day"][$dk]["info"][] = $v;
					}
				}
			}
		}
		$data["month"] = $ym;
	}
	$html = filecheck($html);
	$ap->t_include($html, $data);
	exit;
}
// 詳細
if (($act == "detail")||($act == "bukken")) {
	//$html = $_REQUEST["html"];
	$id = $_REQUEST["id"];
	if ($id) {
		// 詳細
		$item = get_item($id);
		if ($item["open"] != 1) {		// 非公開
			if (!$_SESSION["LOGIN"]) {	// 管理者は閲覧可
				header("location: ./");
				exit;
			}
		}
		if ($item["pdf"]) {		// PDF ファイル
			$item["pdf_file"] = Image::getData($item["pdf"]);
		}
		for ($i = 1; $i <= 10; $i++) {
			if ($item["file" . $i]) {		// ファイル1
				unset($v);
				$item["file" . $i . "_file"] = Image::getData($item["file" . $i]);
				$filetype = get_filetype($item["file" . $i . "_file"]);
				$item["file" . $i][$filetype] = $filetype;
				// 種類別
				$v["no"] = $i;
				$v["file"] = $item["file" . $i];
				$v["file_file"] = $item["file" . $i . "_file"];
				$v["file"][$filetype] = $filetype;
				$data[$filetype][] = $v;
			}
		}
		if ($data["image"]) {
			$data["image_default"] = $data["image"][0];
		}
		if ($data["audio"]) {
			$data["audio_default"] = $data["audio"][0];
		}
		if ($data["video"]) {
			$data["video_default"] = $data["video"][0];
		}
		if ($data["panorama"]) {
			$data["panorama_default"] = $data["panorama"][0];
		}
		if ($data["other"]) {
			$data["other_default"] = $data["other"][0];
		}
		$data["item"] = $item;
		// アクセス数
		if ((!$_SESSION["LOGIN"])&&(!$_SESSION["INFO"][$id])) {
			$_SESSION["INFO"][$id] = $id;
			if (!$_SESSION["INFO_HISTORY"]) {
				$_SESSION["INFO_HISTORY"] = array();
			}
			while (count($_SESSION["INFO_HISTORY"]) > HISTORY_MAX) {
				array_pop($_SESSION["INFO_HISTORY"]);
			}
			array_unshift($_SESSION["INFO_HISTORY"], $id);
			//
			unset($rec);
			if ($item["view_count"]) {
				$rec["view_count"] = $item["view_count"] + 1;
			} else {
				$rec["view_count"] = "1";
			}
			Item::updateData($id, $rec);
		}
		//
		//$data["option11"] = item_list($item["kind"], 0, 0, 10, 2);	 ●●●お知らせ（option11）
		$data["option11"] = item_list(0, 0, 0, 10, 2);	// option11を全項目対象に出力させる追加設定
		//$data["option12"] = item_list($item["kind"], 0, 0, 5, 3);	 ●●●管理者おすすめサイト（option12）
		$data["option12"] = item_list(0, 0, 0, 5, 3);	// option12を全項目対象に出力させる追加設定
		if (!$html) {
			$html = $item["propaty"]["item_html"];
		}
		if ($html == "kiji.html") {
			// 記事作成
			$kiji[] = kiji($item, "info2", "image2", "info3", "info4", "info5");
			$kiji[] = kiji($item, "info6", "image3", "info7", "info8", "info9");
			$kiji[] = kiji($item, "info10", "image4", "info11", "info12", "info13");
			$kiji[] = kiji($item, "info14", "image5", "info15", "info16", "info17");
			$kiji[] = kiji($item, "info18", "image6", "info19", "info20", "info21");
			$kiji[] = kiji($item, "info22", "image7", "info23", "info24", "info25");
			$kiji[] = kiji($item, "info26", "image8", "info27", "info28", "info29");
			$kiji[] = kiji($item, "info30", "image9", "info31", "info32", "info33");
			$kiji[] = kiji($item, "info34", "image10", "info35", "info36", "info37");
			$data["kiji"] = $kiji;
		}
		$data["kind" . $kind] = $kind;
		$html = filecheck($html);
		$ap->t_include($html, $data);
		exit;
	}
}
if (($act == "toiawase")||($act == "toiawase_reinput")) {
	$id = $_REQUEST["id"];
	$item = get_item($id);
	if ($id && $item) {
		$data["item"] = $item;
		$mailitem = explode(",", $mail_item);
	} else {
		$mailitem = explode(",", $mail_item2);
	}
	if (!$mailitem) {
		echo "設定ファイルを確認してください";
		exit;
	}
	$data["mailitem"] = array();
	foreach ($mailitem as $val) {
		$data["mailitem"][$val] = "1";
	}
	//
	$mode = $_REQUEST["mode"];
	if ($mode == "form") {
		foreach ($mailitem as $val) {
			$form[$val] = $_REQUEST[$val];
		}
		$data["form"] = $form;
		$msg = array();
		foreach ($mailitem as $val) {
			if ($error[$val] &&(!$form[$val])) {
				$msg[] = $error[$val];
			}
		}
		if (!$msg) {
			$data["mode"] = "confirm";
			$data["confirm"] = "1";
			$_SESSION["form"] = $form;
		} else {
			$data["message"] = join("<br/>", $msg);
			$data["mode"] = "form";
		}
	} else if ($mode == "confirm") {
		$form = $_SESSION["form"];
		if ($item["info_id"]) {
			$body = $mail_body;
			$body = str_replace("{info_id}", $item["info_id"], $body);
			$body = str_replace("{title}", $item["title"], $body);
			$info = get_item($item["info_id"]);
		} else {
			$body = $mail_body2;
		}
		foreach ($mailitem as $val) {
			$body = str_replace("{" . $val . "}", $form[$val], $body);
		}
		if (!defined("TEMP_DB")) {	// DEMO版
			// メール送信
			if ($admin_mail) {
				$tmp = $pre_admin . "\n" . $body . "\n\n" . $post_admin;
				sendmail2($from_mail, $admin_mail, $subject_admin, $tmp, null, $from_name);
			}
			// 登録者に送信
			if ($info["user_id"]) {
				$tmp = $pre_admin . "\n" . $body . "\n\n" . $post_admin;
				$user = User::getData($info["user_id"]);
				sendmail2($from_mail, $user["email"], $subject, $tmp, null, $from_name);
			}
			// 本人へ送信
			if ($form["email"]) {
				$tmp = $form["name"] . "{$mail_sama}\n\n{$pre_user}\n{$body}\n\n{$post_user}";
				sendmail2($from_mail, $form["email"], $subject, $tmp, null, $from_name);
			}
		}
		header("location: ./?act=toiawase&mode=finish");
		exit;
	} else if ($mode == "finish") {
		//
	} else {
		$data["mode"] = "form";
	}
	if ($act == "toiawase_reinput") {
		$data["form"] = $_SESSION["form"];
		$data["mode"] = "form";
	}
	//$data["option11"] = item_list($item["kind"], 0, 0, 10, 2);	 ●●●お知らせ（option11）
	$data["option11"] = item_list(0, 0, 0, 10, 2);	// option11を全項目対象に出力させる追加設定
	//$data["option12"] = item_list($item["kind"], 0, 0, 5, 3);	 ●●●管理者おすすめサイト（option12）
	$data["option12"] = item_list(0, 0, 0, 5, 3);	// option12を全項目対象に出力させる追加設定
	//
	$ap->t_include("toiawase.html", $data);
	exit;
}
// --------------------------------
// トップページ
$data["option11"] = item_list(0, 0, 0, 10, 2);	// お知らせ（option11）
$data["option12"] = item_list(0, 0, 0, 5, 3);	// 管理者おすすめサイト（option12）
//
$data["list0"] = item_list(0, 0, 0, 12, 1);	// 全種類
$data["list1"] = item_list(1, 0, 0, 12, 1);	// 種類1（不動産情報(売買物件)）
$data["list2"] = item_list(2, 0, 0, 12, 1);	// 種類2（不動産情報(賃貸物件)）
$data["list101"] = item_list(101, 0, 0, 12, 1);	// 種類101（飲食店情報）
$data["list201"] = item_list(201, 0, 0, 12, 1);	// 種類201（医療情報）
$data["list301"] = item_list(301, 0, 0, 12, 1);	// 種類201（求人情報）
$data["list401"] = item_list(401, 0, 0, 12, 1);	// 種類401（お稽古事）
//
$data["history"] = item_list(1000, 0, 0, 12, 1);	// 閲覧履歴
//
$data["newinfo"] = get_newinfo(($setup["info_max"] == "")?10:$setup["info_max"]);
//
$html = "index_.html";
//
if ($act != "index") {
	$html = filecheck($act . ".html");
}
$html = filecheck($html);
$ap->t_include($html, $data);
exit;
// --------------------------------
// お知らせ
function get_newinfo($max=10)
{
	global $DB_URI;

	$sql = "select * from info where open=1 and kind=" . INFO_RSS;
	$inst = DBConnection::getConnection($DB_URI);
	$ret = $inst->search_sql($sql);
	$list = array();
	if ($ret["count"]) {
		foreach ($ret["data"] as $val) {
			$item = get_setup(INFO_RSS, $val["info_id"]);
			if ($item["open"]) {
				$item["reg_date"] = $val["reg_date"];
				if (newflag(-1, $item["rss_date"])) {
					$item["new_flag"] = "1";
				}
				if (!$item["rss_date"]) {
					$item["rss_date"] = $item["reg_date"];
				}
				$t = strtotime($item["rss_date"]);
				while (1) {
					if ($list[$t]) {
						$t++;
					} else {
						$list[$t] = $item;
						break;
					}
				}
			}
		}
	}
	// 並べ替え
	$rss = array();
	if ($list) {
		$count = 0;
		krsort($list);
		foreach ($list as $val) {
			$val["rss_date"] = substr($val["rss_date"], 0, 4) . "/" . substr($val["rss_date"], 5, 2) . "/" . substr($val["rss_date"], 8, 2);
			$rss[] = $val;
			$count++;
			if ($count >= $max) {
				break;
			}
		}
	}
	return $rss;
}
// --------------------------------
// プロパティ
function get_item_propaty($inst, $kind)
{
	global $DB_URI;

	if ($_SESSION["PROPATY" . $kind]) {
//		return $_SESSION["PROPATY" . $kind];
	}
	$propaty = array();
	if (!$inst) {
		$inst = DBConnection::getConnection($DB_URI);
	}
	$sql = "select kind,value from info_item where info_id in (select info.info_id from info left join info_item on info.info_id=info_item.info_id where info.kind=" . INFO_PROPATY . " and info_item.kind='kind' and info_item.value='{$kind}')";
	$ret = $inst->search_sql($sql);
	if ($ret["count"]) {
		foreach ($ret["data"] as $val) {
			$propaty[$val["kind"]] = $val["value"];
		}
	}
	if (!$propaty["list_html"]) {
		$propaty["list_html"] = "list.html";
	}
	if (!$propaty["item_html"]) {
		$propaty["item_html"] = "item.html";
	}
	$_SESSION["PROPATY" . $kind] = $propaty;
	return $propaty;
}
// --------------------------------
function item_list($kind=0, $ord=0, $page=0, $limit=0, $top=0, $search=array(), $special=array(), $andor='and', $user_id='', $ul=array(), $lr=array())
{
	global $DB_URI;
	global $setup;

	$inst = DBConnection::getConnection($DB_URI);
	if ((!is_array($kind))&&($kind == 1000)) {	// 閲覧履歴
		$list = array();
		if (is_array($_SESSION["INFO_HISTORY"])) {
			foreach ($_SESSION["INFO_HISTORY"] as $id) {
				$item = Item::getData($id);
				$list[] = $item;
			}
		}
		$kind = 0;
	} else {
		$join = "";
		$where = "";
		if (is_array($kind)) {
			$cond = array();
			foreach ($kind as $v) {
				$k = INFO_ITEM + intval($v);
				$cond[] = "kind = $k";
			}
			$where = " and (" . implode(" or ", $cond) . ")";
			// プロパティ
			//$propaty = get_item_propaty($inst, $kind);
			$kind = 0;
		} else if ($kind) {
			$k = INFO_ITEM + intval($kind);
			$where = " and kind={$k}";
			// プロパティ
			$propaty = get_item_propaty($inst, $kind);
		}
		// トップページ用一覧
		if ($top) {
			if ($top == 1) {	// new
				$where .= " and new=1";
			}
			if ($top == 2) {	// お知らせ（option1）
				$where .= " and recommend=11";
			}
			if ($top == 3) {	// 管理者おすすめサイト（option2）
				$where .= " and recommend=12";
			}
			if (intval($top) > 10) {	// 
				$where .= " and recommend={$v}";
			}
		}
		// 条件検索
		if ($search) {
			foreach ($search as $key => $val) {
				$ary = explode("_", $key);
				if ($ary[1] == "S") {
					$val = mb_convert_encoding($val, DB_ENCODING, SCRIPT_ENCODING);
					$where .= " and {$ary[0]} = '{$val}'";
				} else if ($ary[1] == "C") {
					unset($cond);
					unset($c);
					foreach ($val as $v) {
						if ($v) {
							$c[] = "{$ary[0]} = '{$v}'";
						}
					}
					$cond = implode(" or ", $c);
					$where .= " and ({$cond})";
				} else if (($ary[1] == "H")||($ary[1] == "L")) {
					$val = mb_convert_encoding($val, DB_ENCODING, SCRIPT_ENCODING);
					if ($ary[1] == "H") {
						$where .= " and {$ary[0]}+0 <= {$val}";
					} else {
						$where .= " and {$ary[0]}+0 >= {$val}";
					}
				} else if (($ary[1] == "HS")||($ary[1] == "LS")) {
					$val = mb_convert_encoding($val, DB_ENCODING, SCRIPT_ENCODING);
					if ($ary[1] == "HS") {
						$where .= " and {$ary[0]} <= '{$val}'";
					} else {
						$where .= " and {$ary[0]} >= '{$val}'";
					}
				} else if ($ary[1] == "X") {
					unset($cond);
					unset($c);
					foreach ($val as $v) {
						if ($v) {
							$c[] = "{$ary[0]} like '%{$v}%'";
						}
					}
					$cond = implode(" or ", $c);
					$where .= " and ({$cond})";
				} else {
					$val = mb_convert_encoding($val, DB_ENCODING, SCRIPT_ENCODING);
					$vals = explode(" ", mb_ereg_replace("　", " ", $val));
					if (count($vals) > 1) {
						unset($cond);
						unset($c);
						foreach ($vals as $v) {
							if ($v) {
								$c[] = "{$key} like '%{$v}%'";
							}
						}
						$cond = implode(" or ", $c);
						$where .= " and ($cond)";
					} else {
						$where .= " and {$key} like '%{$val}%'";
					}
				}
			}
		}
		// こだわり条件検索
		if ($special) {
			$v = 0;
			foreach ($special as $key => $val) {
				$v += 1 << $val;
			}
			if ($andor != 'or') {
				$where .= " and ((special & $v)=$v)";
			} else {
				$where .= " and (special & $v)";
			}
		}
		// 登録者ID
		if ($user_id) {
			$where .= " and user_id=$user_id";
		}
		// 地図検索
		if ($ul && $lr) {
			$where .= " and lat >= $lr[0]";
			$where .= " and lon >= $ul[1]";
			$where .= " and lat <= $ul[0]";
			$where .= " and lon <= $lr[1]";
		}
		//
		$sql = " from item where open=1 {$where}";
		if ($page && $limit) {
			$ret = $inst->search_sql("select count(info_id) as num" . $sql);
			$count = $ret["data"][0]["num"];
			$pages = intval(($count + $limit - 1) / $limit);
			$pager = array();
			if ($pages > 1) {
				$pager = page_index3($page, $pages);
			}
		}
		if ($ord == 0) {
			$sql .= " order by reg_date desc";	// 新着
		} else if ($ord == 1) {
			$sql .= " order by price desc";	// 高い順
		} else if ($ord == 2) {
			$sql .= " order by price";	// 安い順
		} else if ($ord == 3) {
			$sql .= " order by up_date desc";	// 更新
		} else if (($ord != "")&&($ord != 0)) {
			$sql .= " order by {$ord}";	// 項目指定
		} else {
			$sql .= " order by reg_date desc";	// 新着
		}
		if ($page && $limit) {
			$p["offset"] = ($page - 1) * $limit;
			$p["limit"] = $limit;
		} else {
			$p["offset"] = 0;
			$p["limit"] = $limit;
		}
		$ret = $inst->search_sql("select * " . $sql, false, $p);
		if ($ret["count"] && $ret["data"]) {
			$list = $ret["data"];
		} else {
			$list = array();
		}
	}
	$list2 = array();
	if ($list) {
		foreach ($list as $val) {
			$list_item = array();
			$info = array();
			$special = array();
			if (!$kind) {
				if ($_SESSION["PROPATY" . ($val["kind"] - 100)]) {
					$propaty = $_SESSION["PROPATY" . ($val["kind"] - 100)];
				} else {
					$propaty = get_item_propaty($inst, ($val["kind"] - 100));
				}
			}
			unset($list);
			foreach ($val as $key => $val2) {
				if (($key == "special")&&($val2 != 0)) {
					for ($i = 1; $i <= 20; $i++) {
						$key2 = "special" . $i;
						if (intval($val2) & (1 << $i)) {
							unset($item);
							$item["title"] = $propaty[$key2];
							$item["value"] = $i;
							if ($setup["icons"][$kind][$i]) {
								$item["icon"] = $setup["icons"][$kind][$i];
							}
							$list[$key2] = $item;
							$special[] = $item;
						}
					}
				} else if ($propaty[$key]) {
					unset($item);
					if ($val2) {
						$item["title"] = $propaty[$key];
						if (is_array($val2)) {
							$item["value"] = implode("・", $val2);
							$item["value_list"] = $val2;
						} else {
							$item["value"] = $val2;
						}
						$list[$key] = $item;
						if (substr($key, 0, 4) == "info") {
							$n = intval(substr($key, 4));
							if ($n <= 10) {		// 一覧項目
								$list_item[] = $item;
							}
							$info[] = $item;
						}
					}
				} else if ($key == "new") {
					if (newflag($val2, $val["reg_date"])) {
						$list["new_flag"] = "1";
					} else if (newflag(-1, $val["up_date"])) {
						$list["update_flag"] = "1";
					}
				} else if ($val2) {
					if (($key == "recommend") && $val2) {
						$list["recommend" . $val2] = "1";
					}
					$list[$key] = $val2;
				}
				if (substr($key, 0, 5) == "image") {
					if ($val2) {
						$img = Image::getData($val2);
						if ($img) {
							$list[$key . "_file"] = $img["save_name"];
							$list[$key . "_title"] = $img["title"];
						}
					}
				}
			}
			$ary = explode(" ", $val["reg_date"]);
			$list["regdate"] = explode("-", $ary[0]);
			$list["regtime"] = explode(":", $ary[1]);
			$ary = explode(" ", $val["up_date"]);
			$list["update"] = explode("-", $ary[0]);
			$list["uptime"] = explode(":", $ary[1]);
			//
			$list["list_item"] = set_row($list_item, 2);	// 一覧用情報
			$list["info"] = $info;	// 詳細用情報
			$list["kind"] = $val["kind"] - 100;
			$list["special"] = $special;	// こだわり
			// 登録者
			if ($val["user_id"]) {
				$user = User::getData($val["user_id"]);
				$list["user"] = $user["name"];
				$list["user_item1"] = $user["item1"];
				$list["user_item2"] = $user["item2"];
				$list["user_item3"] = $user["item3"];
				$list["user_item4"] = $user["item4"];
				$list["user_item5"] = $user["item5"];
				if ($user["item1"]) $list["item1_" . $user["item1"]] = $user["item1"];
				if ($user["item2"]) $list["item2_" . $user["item2"]] = $user["item2"];
				if ($user["item3"]) $list["item3_" . $user["item3"]] = $user["item3"];
				if ($user["item4"]) $list["item4_" . $user["item4"]] = $user["item4"];
				if ($user["item5"]) $list["item5_" . $user["item5"]] = $user["item5"];
			}
			$list2[] = $list;
		}
	}
	if ($page && $limit) {
		if ($count) {
			$counter = array("total" => $count, "start" => ($page - 1) * $limit + 1, "end" => ($page - 1) * $limit + count($list2));
		}
		return array($list2, $pager, $counter);
	}
	return $list2;
}
function search_cond($req, $html="")
{
	global $form;
	global $propaty;
	global $setup;
	global $kind;
	global $html;
	global $y, $m;

	$search = array();
	// --- カレンダー作成 ---
	if ($html == "calender.html") {
		include("calender.php");
		list($ym, $ds, $de) = cal_month($y, $m);	// 1ヶ月分カレンダー
		// カレンダー検索条件
		$search["info1_LS"] = $ds;
		$search["info1_HS"] = $de;
	}
	// 複合検索 ここから ==============
	if ($_REQUEST["multi"] && $_REQUEST["multi_value"]) {
		$search["multi"]["item"] = $_REQUEST["multi"];
		$search["multi"]["value"] = $_REQUEST["multi_value"];
		$form["multi_value"] = $_REQUEST["multi_value"];
	}
	// 複合検索 ここまで ==============
	// 項目検索
	for ($i = 1; $i <= 20; $i++) {
		// テキスト入力・プルダウン
		if (isset($req["info" . $i])) {
			$v = trim($req["info" . $i]);
			if ($v) {
				$search["info" . $i] = $v;
				$form["info" . $i] = $v;
				$form["info" . $i . "_" . $v] = "selected";
			}
		}
		// 範囲指定のプルダウン
		if ($req["info" . $i . "HL"]) {
			$v = trim($req["info" . $i . "HL"]);
			$ary = explode(" ", $v);
			if (count($ary > 1)) {
				$search["info" . $i . "_L"] = $ary[0];
				$search["info" . $i . "_H"] = $ary[1];
			} else {
				$search["info" . $i . "_L"] = $ary[0];
				$search["info" . $i . "_H"] = $ary[0];
			}
			$form["info" . $i . "HL_" . $v] = "selected";
		}
		// 値での範囲検索
		if (isset($req["info" . $i . "L"]) || isset($req["info" . $i . "H"])) {
			$v = trim($req["info" . $i . "L"]);
			if ($v) {
				$search["info" . $i . "_L"] = $v;
				$form["info" . $i . "L"] = $v;
			}
			$v = trim($req["info" . $i . "H"]);
			if ($v) {
				$search["info" . $i . "_H"] = $v;
				$form["info" . $i . "H"] = $v;
			}
		}
		// ラジオボタン（択一）
		if (isset($req["info" . $i . "R"])) {
			$v = trim($req["info" . $i . "R"]);
			if ($v) {
				$search["info" . $i . "_S"] = $v;
				$form["info" . $i . "R" . $v] = "checked";
			}
		}
		// プルダウン（択一）
		if (isset($req["info" . $i . "S"])) {
			$v = trim($req["info" . $i . "S"]);
			if ($v) {
				$search["info" . $i . "_S"] = $v;
				$form["info" . $i . "S" . $v] = "selected";
			}
		}
		// チェックボックス（複数選択）
		if (isset($req["info" . $i . "C"])) {
			foreach ($req["info" . $i . "C"] as $v) {
				if ($v) {
					$search["info" . $i . "_C"][] = $v;
					$form["info" . $i . "C" . $v] = "checked";
				}
			}
		}
		// あいまい検索
		if (isset($req["info" . $i . "X"])) {
			foreach ($req["info" . $i . "X"] as $v) {
				if ($v) {
					$search["info" . $i . "_X"][] = $v;
					$form["info" . $i . "X" . $v] = "checked";
				}
			}
		}
		// プルダウンによる範囲検索、下限
		if (isset($req["info" . $i . "SL"])) {
			$v = trim($req["info" . $i . "SL"]);
			if ($v) {
				$search["info" . $i . "_L"] = $v;
				$form["info" . $i . "SL" . $v] = "selected";
			}
		}
		// プルダウンによる範囲検索、上限
		if (isset($req["info" . $i . "SH"])) {
			$v = trim($req["info" . $i . "SH"]);
			if ($v) {
				$search["info" . $i . "_H"] = $v;
				$form["info" . $i . "SH" . $v] = "selected";
			}
		}
		// 築年検索
		if (isset($req["info" . $i . "Y"])) {
			$y = trim($req["info" . $i . "Y"]);
			if ($y) {
				$form["info" . $i . "Y_" . $y] = "selected";
				$ym = date('Ym', time() - $y * 86400 * 365);
				$search["info" . $i . "_L"] = $ym;	// ym以上
			}
		}
	}
	// 価格検索
	if (isset($_REQUEST["price"])) {
		$v = trim($_REQUEST["price"]);
		if ($v) {
			$search["price"] = $v;
			$form["price"] = $v;
			$form["price" . "_" . $v] = "selected";
		}
	}
	if ($_REQUEST["priceHL"]) {
		$v = trim($_REQUEST["priceHL"]);
		$ary = explode(" ", $v);
		if (count($ary > 1)) {
			$search["price_L"] = $ary[0];
			$search["price_H"] = $ary[1];
		} else {
			$search["price_L"] = $ary[0];
			$search["price_H"] = $ary[0];
		}
		$form["priceHL_" . $v] = "selected";
	}
	if (isset($_REQUEST["priceL"]) || isset($_REQUEST["priceH"])) {
		$v = trim($_REQUEST["priceL"]);
		if ($v) {
			$search["price_L"] = $v;
			$form["priceL"] = $v;
			$form["priceL_" . $v] = "selected";
		}
		$v = trim($_REQUEST["priceH"]);
		if ($v) {
			$search["price_H"] = $v;
			$form["priceH"] = $v;
			$form["priceH_" . $v] = "selected";
		}
	}
	// こだわり検索
	$special = array();
	$special_item = array();
	for ($i = 1; $i <= 20; $i++) {
		$v = 0;
		if (isset($req["special" . $i])) {
			$v = trim($req["special" . $i]);
		}
		if ($propaty["special" . $i]) {
			$form["special" . $i] = $v;
			unset($item);
			$item["no"] = $i;
			$item["title"] = $propaty["special" . $i];
			$item["icon"] = $setup["icons"][$kind][$i];
			if ($v) {
				$special["special" . $i] = $v;
				$item["value"] = $v;
			}
			$special_item[] = $item;
		}
	}
	return array($search, $special, $special_item, $ym);
}
function get_item($info_id, $propaty=null)
{
	global $DB_URI;
	global $setup;

	$item = Item::getData($info_id);
	$kind = $item["kind"] - 100;
	if (!$propaty) {
		// プロパティ
		$propaty = get_item_propaty($inst, $kind);
	}
	//
	$list = array("info_id" => $item["info_id"], "kind" => $kind, "propaty" => $propaty);
	$list_item = array();
	$info = array();
	$special = array();
	if ($item) foreach ($item as $key => $val) {
		if ($key == "kind") continue;
		if (($key == "special") && $val) {
			for ($i = 1; $i <= 20; $i++) {
				$key2 = "special" . $i;
				if (intval($val) & (1 << $i)) {
					unset($item);
					$item["title"] = $propaty[$key2];
					$item["value"] = $i;
					if ($setup["icons"][$kind][$i]) {
						$item["icon"] = $setup["icons"][$kind][$i];
					}
					$list[$key2] = $item;
					$special[] = $item;
				}
			}
		} else if ($propaty[$key]) {
			unset($item2);
			if ($val) {
				$item2["title"] = $propaty[$key];
				if (is_array($val)) {
					$item2["value"] = implode("・", $val);
					$item2["value_list"] = $val;
				} else {
					$item2["value"] = $val;
				}
				$list[$key] = $item2;
				if (substr($key, 0, 4) == "info") {
					$n = intval(substr($key, 4));
					if ($n <= 10) {		// 一覧項目
						$list_item[] = $item2;
					}
					$info[] = $item2;
				}
			}
		} else if ($key == "new") {
			if (newflag($val, $item["reg_date"])) {
				$list["new_flag"] = "1";
			} else if (newflag(-1, $item["up_date"])) {
				$list["update_flag"] = "1";
			}
		} else if ($val) {
			if (($key == "recommend") && $val) {
				$list["recommend" . $val] = "1";
			}
			$list[$key] = $val;
		}
		if (substr($key, 0, 5) == "image") {
			if ($val) {
				$img = Image::getData($val);
				if ($img) {
					$list[$key . "_file"] = $img["save_name"];
					$list[$key . "_title"] = $img["title"];
				}
			}
		}
	}
	$ary = explode(" ", $list["reg_date"]);
	$list["regdate"] = explode("-", $ary[0]);
	$list["regtime"] = explode(":", $ary[1]);
	$ary = explode(" ", $list["up_date"]);
	$list["update"] = explode("-", $ary[0]);
	$list["uptime"] = explode(":", $ary[1]);
	//
	$list["list_item"] = set_row($list_item, 2);	// 一覧用情報
	$list["info"] = $info;	// 詳細用情報
	$list["special"] = $special;	// こだわり
	// 登録者
	if ($list["user_id"]) {
		$user = User::getData($list["user_id"]);
		$list["user"] = $user["name"];
		$list["user_item1"] = $user["item1"];
		$list["user_item2"] = $user["item2"];
		$list["user_item3"] = $user["item3"];
		$list["user_item4"] = $user["item4"];
		$list["user_item5"] = $user["item5"];
		if ($user["item1"]) $list["item1_" . $user["item1"]] = $user["item1"];
		if ($user["item2"]) $list["item2_" . $user["item2"]] = $user["item2"];
		if ($user["item3"]) $list["item3_" . $user["item3"]] = $user["item3"];
		if ($user["item4"]) $list["item4_" . $user["item4"]] = $user["item4"];
		if ($user["item5"]) $list["item5_" . $user["item5"]] = $user["item5"];
	}
	return $list;
}
function user_list($search=array(), $user_id='')
{
	global $DB_URI;

	$inst = DBConnection::getConnection($DB_URI);
	$join = "";
	$where = "";
	foreach ($search as $key => $val) {
		if ($where) {
			$where .= " and ";
		}
		if (strpos($val, '%') >= 0) {
			$where .= $key . "like '" . $val . "'";
		} else {
			$where .= $key . "='" . $val . "'";
		}
	}
	$ret = $inst->search_sql("select * from user " . $where);
	foreach ($ret["data"] as $key => $val) {
		if ($val["user_id"] == $user_id) {
			$ret["data"][$key]["selected"] = "selected";
		}
	}
	return $ret["data"];
}
function set_row($ary, $cnt)
{
	$num = 0;
	$col = 0;
	$data = array();
	$row = array();
	foreach ($ary as $val) {
		$row[] = $val;
		if (++$col == $cnt) {
			$data[$num]["num"] = $num + 1;
			$data[$num++]["row"] = $row;
			$row = array();
			$col = 0;
		}
	}
	if ($row) {
		$data[$num]["num"] = $num + 1;
		$data[$num++]["row"] = $row;
	}
	return $data;
}
// ファイルの拡張子からMIMEタイプを得る
function get_mime_types($file)
{
	$mime_types = array(
		'txt' => 'text/plain',
		'htm' => 'text/html',
		'html' => 'text/html',
		'php' => 'text/html',
		'css' => 'text/css',
		'js' => 'application/javascript',
		'json' => 'application/json',
		'xml' => 'application/xml',
		'swf' => 'application/x-shockwave-flash',
		'flv' => 'video/x-flv',
		'csv' => 'text/csv',

		// images
		'png' => 'image/png',
		'jpe' => 'image/jpeg',
		'jpeg' => 'image/jpeg',
		'jpg' => 'image/jpeg',
		'gif' => 'image/gif',
		'bmp' => 'image/bmp',
		'ico' => 'image/vnd.microsoft.icon',
		'tiff' => 'image/tiff',
		'tif' => 'image/tiff',
		'svg' => 'image/svg+xml',
		'svgz' => 'image/svg+xml',

		// archives
		'zip' => 'application/zip',
		'rar' => 'application/x-rar-compressed',
		'exe' => 'application/x-msdownload',
		'msi' => 'application/x-msdownload',
		'cab' => 'application/vnd.ms-cab-compressed',

		// audio/video
		'mp3' => 'audio/mpeg',
		'm4a' => 'audio/aac',
		'oga' => 'audio/ogg',
		'wav' => 'audio/wav',
		'midi' => 'audio/midi',
		'mzo' => 'audio/mzo',
		'qt' => 'video/quicktime',
		'mov' => 'video/quicktime',
		'mp4' => 'video/mpeg',
		'mpg' => 'video/mpeg',
		'mpeg' => 'video/mpeg',
		'ogv' => 'video/ogg',

		// adobe
		'pdf' => 'application/pdf',
		'psd' => 'image/vnd.adobe.photoshop',
		'ai' => 'application/postscript',
		'eps' => 'application/postscript',
		'ps' => 'application/postscript',

		// ms office
		'doc' => 'application/msword',
		'rtf' => 'application/rtf',
		'xls' => 'application/vnd.ms-excel',
		'ppt' => 'application/vnd.ms-powerpoint',

		// open office
		'odt' => 'application/vnd.oasis.opendocument.text',
		'ods' => 'application/vnd.oasis.opendocument.spreadsheet',
	);

	$ary = explode(".", $file);
	if (count($ary) > 1) {	// 拡張子あり？
		if ($mime_types[$ary[count($ary)-1]]) {
			return $mime_types[$ary[count($ary)-1]];
		}
	}
	return "application/octet-stream";	// 不明なファイル
}
function newflag($new, $date)
{
	if (defined("NEW_DAYS") && NEW_DAYS) {
		$t = intval((time() - strtotime($date)) / 86400);
		if ($new < 0) {
			if ($t < NEW_DAYS) return 1;
		} else if (defined("NEW_OR")) {
			// OR(新着または設定日数以内の場合)
			if ($new || ($t < NEW_DAYS)) return 1;
		} else if (defined("NEW_AND")) {
			// AND(新着かつ設定日数以内の場合)
			if ($new && ($t < NEW_DAYS)) return 1;
		} else {
			// 自動判定のみ
			if ($t < NEW_DAYS) return 1;
		}
	} else {
		// 新着設定のみ
		if ($new > 0) return 1;
	}
	return 0;
}
function page_index3($cur, $pages, $maxpage=10)
{
	$cur--;
	//
	$page = array();
	$no = 0;
	if ($cur > 0) {
		$page['prev'] = array('no' => $cur, 'name' => '前へ', 'link' => 1);
	}
	$start = 0;
	$end = $pages;
	if ($pages > $maxpage) {
		if ($cur > intval($maxpage / 2)) {
			$start = $cur - intval($maxpage / 2);
		}
		$end = $start + $maxpage;
		if ($end > $pages) {
			$end = $pages;
			$start = $end - $maxpage;
		}
		if ($start > 0) {
			$page['prev_skip'] = "1";
			$page['top'] = array('no' => 1, 'name' => '1', 'link' => 1);
		}
		if ($end < $pages) {
			$page['next_skip'] = "1";
			$page['last'] = array('no' => $pages, 'name' => $pages, 'link' => 1);
		}
	}
	for ($i = $start; $i < $end; $i++) {
		if ($i == $cur) {
			$page['list'][$no] = array('no' => $i + 1, 'name' => $i + 1);
		} else {
			$page['list'][$no] = array('no' => $i + 1, 'name' => $i + 1, 'link' => 1);
		}
		$no++;
	}
	if ($cur < ($pages - 1)) {
		$page['next'] = array('no' => $cur + 2, 'name' => '次へ', 'link' => 1);
	}
	return $page;
}
function get_filetype($file)
{
	if (!$file["filetype"]) {
		$imageInfo = getimagesize("./user_data/" . $file["save_name"]);
		if ($imageInfo['mime']) {
			$file["filetype"] = $imageInfo['mime'];
		} else {
			$file["filetype"] = get_mime_types("./user_data/" . $file["save_name"]);
		}
	}
	if (substr($file["filetype"], 0, 5) == "audio") {
		return "audio";
	}
	if (substr($file["filetype"], 0, 5) == "video") {
		return "video";
	}
	if (substr($file["filetype"], 0, 5) == "image") {
		return "image";
	}
	$ary = explode(".", $file["name"]);
	if (count($ary) > 1) {
		if (($ary[count($ary) - 1] == "vr") || ($ary[count($ary) - 1] == "VR")) {
			return "panorama";
		}
	}
	return "other";
}
// 表示文字数制限処理
function xtrancate($item, $param=array())
{
	$len = 30;		// 最大文字数
	$add = "<b>…</b>";	// 付加文字
	if ($param[0]) {
		$len = $param[0];
	}
	if ($param[1]) {
		$add = $param[1];
	}
	if (mb_strlen($item, "UTF-8") > $len) {
	    $item = mb_substr($item, 0, $len, "UTF-8") . $add;
	}
	return $item;
}
function kiji($item, $info1, $image, $info2, $info3, $info4)
{
	$kiji = array();
	if ($info1) {
		$kiji["func" . substr($item[$info1]["value"], 0, 1)] = "func" . substr($item[$info1]["value"], 0, 1);
		$kiji["title"] = $item[$info2]["value"];
		$kiji["subtitle"] = $item[$info3]["value"];
		$kiji["image"] = $item[$image . "_file"];
		if ($kiji["func5"]) {
			$kiji["contents"] = explode("\n", $item[$info4]["value"]);
		} else if ($kiji["func7"]) {
			$ary = explode("\n", $item[$info4]["value"]);
			foreach ($ary as $v) {
				$kiji["contents"][] = explode("|", $v);
			}
		} else if ($kiji["func8"]) {
			$ary = explode("\n", $item[$info4]["value"]);
			foreach ($ary as $v) {
				$kiji["contents"][] = explode("|", $v);
			}
		} else {
			$kiji["contents"] = explode("\n", $item[$info4]["value"]);
		}
	}
	return $kiji;
}
function get_imagefilename($id)
{
	$img = Image::getData($id);
	if ($img) {
		if (file_exists("user_data/" . $img["save_name"])) {
			return ($img["save_name"]);
		}
	}
	return "";
}
function get_infotext($item)
{
	if (is_array($item)) {
		return implode("・", $item);
	}
	return $item;
}
// デバッグ用(不要なら空に)
function putlog($msg, $val = array())
{
	if (is_array($msg)) {
		foreach ($msg as $key => $val) {
			putlog($key . ":");
			putlog($val);
			putlog("\n");
		}
	} else {
		if (($fp = fopen("log.txt", "a"))) {
			fputs($fp, $msg);
		}
	}
	if ($val) {
		putlog($val);
		putlog("\n");
	}
}
// 築年表示処理
function tmp_chiku($val)
{
	$ret = $val;
	if (strlen($val) == 6) {
		$y = substr($val, 0, 4);
		$m = substr($val, 4);
		$t = (time() - strtotime("{$y}-{$m}-01")) / 86400;
		$year = intval(($t + 364) / 365);
		//$ret = "築{$year}年";	// 築年のみで良ければこちらを使用
		$ret = "築{$year}年（{$y}年{$m}月）";
	}
	return $ret;
}
function filecheck($html, $default = "index_.html")
{
	if (file_exists($html)) {
		return $html;
	}
	if (file_exists("./templates/" . $html)) {
		return $html;
	}
	return $default;
}
