$val ){
$$key = trim($val);
if($$key == "" or $$key =="0" or $$key =="-1"){
$$key = "";
}
$strkey=substr($key,0,7);
switch ($strkey) {
case "setsubi":
$arysetsubi[]= $$key;
break;
case "tokki1":
$arytokki[]= $$key;
break;
case "tokki2":
$arytokki[]= $$key;
break;
case "tokki3":
$arytokki[]= $$key;
break;
case "tokki4":
$arytokki[]= $$key;
break;
case "tokki5":
$arytokki[]= $$key;
break;
case "zipcod":
// 郵便番号
$tpl->assign("zipcod1",substr($$key,0,3));
$tpl->assign("zipcod2",substr($$key,3,4));
break;
case "shozai1":
// 県マスタより県名セット
$strValue1 = substr($$key,0,2);
$strSQL = "SELECT mprefecturename FROM mprefecture WHERE mprefecturecd = '$strValue1' AND mprdelflg = ''";
$strMsg="";
$aryResult2=actSQL($strSQL,$strMsg);
$strshozai1_cd = $aryResult2[mprefecturename];
// 市町村マスタより市町村名セット
$strValue1 = substr($$key,0,2);
$strValue2 = substr($$key,2,3);
$strSQL = "SELECT mcityname FROM mcity WHERE mciprefecturecd = '$strValue1' AND mcitycd = '$strValue2' AND mcidelflg = ''";
$strMsg="";
$aryResult2=actSQL($strSQL,$strMsg);
$strshozai1_cd .= $aryResult2[mcityname].$strdmy.$$key;
$tpl->assign($key,$strshozai1_cd);
break;
case "ensen":
// 沿線マスタより沿線名セット
$strValue1 = $$key;
$strSQL = "SELECT mlinename FROM mline WHERE mlinecd = '$strValue1' AND mlidelflg = ''";
$strMsg="";
$aryResult2=actSQL($strSQL,$strMsg);
$strensen = $aryResult2[mlinename].$strdmy.$$key;
$tpl->assign($key,$strensen);
break;
case "eki":
// 駅マスタより駅名セット
$strValue1 = $$key;
$strSQL = "SELECT mstationname FROM mstation WHERE mstlinecd = '$ensen' AND mstationcd='$strValue1' AND mstdelflg = ''";
$strMsg="";
$aryResult2=actSQL($strSQL,$strMsg);
$streki = $aryResult2[mstationname].$strdmy.$$key;
$tpl->assign($key,$streki);
break;
case "heyasuu";
break;
default:
$tpl->assign($key,$$key);
break;
}
$tpl->assign(setsubi,$arysetsubi);
$tpl->assign(tokki,$arytokki);
// 登録者情報編集
if($crtday != ""){
$flg='day';
$strdate = substr($crtday,0,4)."/".substr($crtday,4,2)."/".substr($crtday,6,4);
$tpl->assign(a_crtday,$strdate);
}
if($crttime != ""){
$strdate = substr($crttime,0,2).":".substr($crttime,2,2).":".substr($crttime,4,2);
$tpl->assign(a_crttime,$strdate);
}
if($updday != ""){
$strdate = substr($updday,0,4)."/".substr($updday,4,2)."/".substr($updday,6,4);
$tpl->assign(a_updday,$strdate);
}
if($updtime != ""){
$strdate = substr($updtime,0,2).":".substr($updtime,2,2).":".substr($updtime,4,2);
$tpl->assign(a_updtime,$strdate);
}
if($crtpurchage != ""){
$strSQL = "SELECT mstaffname FROM mstaff WHERE mstaffcd = '$crtpurchage' AND mstdelflg = ''";
$strdate = actSQL($strSQL,$strMsg);
$tpl->assign(a_crtpurchage,$strdate[mstaffname]);
}
if($updpurchage != ""){
$strSQL = "SELECT mstaffname FROM mstaff WHERE mstaffcd = '$updpurchage' AND mstdelflg = ''";
$strdate = actSQL($strSQL,$strMsg);
$tpl->assign(a_updpurchage,$strdate[mstaffname]);
}
}
// 間取りセット
$strkeycd1="heyasuu".$shubetu_cod;
$strSQL = "SELECT cocontents FROM mcommon WHERE cokey1 = '$strkeycd1' AND cokey2 = '$heyasuu'";
$strMsg="";
$aryResult = actSQL($strSQL,$strMsg);
$tpl->assign(heyasuu,$aryResult[cocontents]);
}
// 照会・削除時画面編集処理
if($mode == "REF" or $mode=="DEL" or $mode=="LST"){
foreach( $aryResult as $key=>$val ){
$$key = trim($val);
if($$key == "" or $$key == "0" or $$key =="-1"){
$$key = "-";
}
switch ($key) {
// 物件属性
case "tatemono_flg":
$strkeycd1="tatemono_flg";
$arySQL[$key] ="SELECT cocontents FROM mcommon WHERE cokey1='$strkeycd1' AND cokey2='$val'";
break;
// 物件種目
case "shumoku_cod":
$strkeycd1="shumoku_cod".$shubetu_cod;
$arySQL[$key] ="SELECT cocontents FROM mcommon WHERE cokey1='$strkeycd1' AND cokey2='$val'";
// 建物(専有)面積タイトルセット
$strkey='title1'.$shubetu_cod;
$strsql = "SELECT cocontents FROM mcommon WHERE cokey1='$strkey' AND cokey2='$val'";
$aryResult = actSQL($strsql,$strMsg);
$aryValue[title1] = $aryResult[cocontents];
break;
// 新築中古区分
case "shinko_kbn":
$strkeycd1="shinko_kbn".$shubetu_cod;
$arySQL[$key] ="SELECT cocontents FROM mcommon WHERE cokey1='$strkeycd1' AND cokey2='$val'";
break;
// 郵便番号
case "zipcod":
// 郵便番号
$aryValue[$key] = substr($$key,0,3);
$aryValue[$key] = substr($$key,3,4);
// 地域リンク
if($$key != "-"){
$strurl ="\" http://cominfo.nipponsoft.co.jp/wintop.cgi?cp=038&zip=" . $val . "&no=&range=5000\"";
$aryValue[arealink] = "地域情報";
}
break;
// 所在地コード
case "shozai1_cod":
$strkeycd1 = substr($val,0,2);
$strkeycd2 = substr($val,2,3);
$arySQL[$key] ="SELECT mcityname FROM mcity WHERE mciprefecturecd='$strkeycd1' AND mcitycd= '$strkeycd2' AND mcidelflg =''";
break;
// 所在地名2
case "shozai2":
if($$key == "-"){
$$key = " ";
}
$aryValue[$key] = $$key;
// 学区域リンクの作成
$stradr1 =substr($shozai1_cod,2,3);
$strurl ="\"http://navi.8111.com/snavi/school_list.php?kubun=1&mcityname=$stradr1&adr1=$shozai2&btnAction=検索開始\"";
$strurl2 ="\"http://navi.8111.com/snavi/school_list.php?kubun=2&mcityname=$stradr1&adr1=$shozai2&btnAction=検索開始\"";
$aryValue[schoollink] ="小学校 中学校";
break;
// 所在地コード
case "choume":
if($$key == "-"){
$$key = " ";
} else {
$$key .= "丁目";
}
$aryValue[$key] = $$key;
break;
// 番地
case "banchi":
if($$key == "-"){
$$key = " ";
}
$aryValue[$key] = $$key;
break;
// 最寄沿線コード
case "ensen":
$arySQL[$key] ="SELECT mlinename FROM mline WHERE mlinecd='$val' AND mlidelflg=''";
break;
// 最寄駅コード
case "eki":
$arySQL[$key] ="SELECT mstationname FROM mstation WHERE mstlinecd='$ensen' AND mstationcd='$val' AND mstdelflg=''";
break;
// 価格・賃料
case "kakaku":
if($shubetu_cod == "1" or $shubetu_cod == "2" or $shubetu_cod == "3"){
$aryValue[$key] = number_format($$key);
}else{
$aryValue[$key] = number_format($$key,1);
}
break;
// 礼金(ヶ月)
case "rei_tsuki":
$aryValue[$key] = number_format($$key,1);
break;
// 敷金(ヶ月)
case "shi_tsuki":
$aryValue[$key] = number_format($$key,1);
break;
// 敷引(ヶ月)
case "shikibiki_kin":
$aryValue[$key] = number_format($$key,1);
break;
// 保証金(ヶ月)
case "hos_tsuki":
$aryValue[$key] = number_format($$key,1);
break;
// 権利金(万円)
case "zousa":
$aryValue[$key] = number_format($$key,1);
break;
// 造作譲渡(万円)
case "kenri_kin":
$aryValue[$key] = number_format($$key,1);
break;
// その他一時金/雑費
case "lst_sonota_ichiji":
$aryValue[$key] = number_format($$key,1);
break;
// 管理費(円/月)
case "kanrihi":
$aryValue[$key] = number_format($$key);
break;
// 積立金
case "tsumitate":
$aryValue[$key] = number_format($$key);
break;
// 共益費
case "kyouekihi":
$aryValue[$key] = number_format($$key);
break;
// 借地料
case "shakuchliyou":
$aryValue[$key] = number_format($$key);
break;
// 土地面積
case "tochi_men":
$aryValue[$key] = number_format($$key,2);
break;
// 私道面積
case "shido_men":
$aryValue[$key] = number_format($$key,2);
break;
// 私道面積
case "senyu_men":
$aryValue[$key] = number_format($$key,2);
break;
// バルコニー面積
case "barukoni":
$aryValue[$key] = number_format($$key,2);
break;
// 駐車場料金(円)
case "parking":
$aryValue[$key] = number_format($$key);
break;
// 保険金額(円)
case "hoken_kin":
$aryValue[$key] = number_format($$key);
break;
// 手数料(万円)
case "tes_kin":
$aryValue[$key] = number_format($$key);
break;
// 更新料(ヶ月)
case "lst_koshin_tuki":
$aryValue[$key] = number_format($$key,2);
break;
// 価格帯From
case "lst_kakakutai_from":
$aryValue[$key] = number_format($$key);
break;
// 価格帯To
case "lst_kakakutai_to":
$aryValue[$key] = number_format($$key);
break;
// 土地面積帯From
case "lst_tochi_men_from":
$aryValue[$key] = number_format($$key,2);
break;
// 土地面積帯To
case "lst_tochi_men_to":
$aryValue[$key] = number_format($$key,2);
break;
// 建物面積帯From
case "lst_tatemono_men_from":
$aryValue[$key] = number_format($$key,2);
break;
// 建物面積帯To
case "lst_tatemono_men_to":
$aryValue[$key] = number_format($$key,2);
break;
// 敷引区分
case "shiki_flg":
$strkeycd1="shiki_flg".$shubetu_cod;
$arySQL[$key] ="SELECT cocontents FROM mcommon WHERE cokey1='$strkeycd1' AND cokey2='$val'";
break;
// 保証金償却
case "repay_cod":
$strkeycd1="repay_cod".$shubetu_cod;
$arySQL[$key] ="SELECT cocontents FROM mcommon WHERE cokey1='$strkeycd1' AND cokey2='$val'";
break;
// 土地権利
case "tochi_kenri":
$strkeycd1="tochi_kenri".$shubetu_cod;
$arySQL[$key] ="SELECT cocontents FROM mcommon WHERE cokey1='$strkeycd1' AND cokey2='$val'";
break;
// バルコニー方向
case "baru":
$strkeycd1="direction";
$arySQL[$key] ="SELECT cocontents FROM mcommon WHERE cokey1='$strkeycd1' AND cokey2='$val'";
break;
// 建物構造
case "kouzou":
$strkeycd1="kouzou".$shubetu_cod;
$arySQL[$key] ="SELECT cocontents FROM mcommon WHERE cokey1='$strkeycd1' AND cokey2='$val'";
break;
// 地下階
case "chika":
$aryValue[$key] = $$key;
break;
// 間取り
case "heyasuu":
$strkeycd1="heyasuu".$shubetu_cod;
$arySQL[$key] ="SELECT cocontents FROM mcommon WHERE cokey1='$strkeycd1' AND cokey2='$val'";
$aryResult = actSQL($arySQL[$key],$strMsg);
if($aryResult[cocontents] == "-"){
$aryResult[cocontents] = "";
}
$aryValue[madorisuu] .= $aryResult[cocontents];
break;
// 間取りタイプ
case "madori":
$strkeycd1="madori".$shubetu_cod;
$arySQL[$key] ="SELECT cocontents FROM mcommon WHERE cokey1='$strkeycd1' AND cokey2='$val'";
$aryResult = actSQL($arySQL[$key],$strMsg);
if($aryResult[cocontents] == "-"){
$aryResult[cocontents] = "";
}
$aryValue[madorisuu] .= $aryResult[cocontents];
break;
// 間取り内訳詳細
case "lst_type_jyou":
$aryValue[lst_type_jyoutype] = $val;
break;
// 間取り内訳タイプ
case "lst_type":
$strkeycd1="lst_type".$shubetu_cod;
$arySQL[$key] ="SELECT cocontents FROM mcommon WHERE cokey1='$strkeycd1' AND cokey2='$val'";
$aryResult = actSQL($arySQL[$key],$strMsg);
if($aryResult[cocontents] == "-"){
$aryResult[cocontents] = "";
}
$aryValue[lst_type_jyoutype] .= $aryResult[cocontents];
break;
// 間取り内訳(和1)
case "lst_wajyou1":
if($$key == "-"){
$$key = "";
}
if($aryValue[jyou] == ""){
if($$key != ""){
$aryValue[jyou] = $aryValue[madorisuu]."和". $$key;
}else{
$aryValue[jyou] = $aryValue[madorisuu] . $$key;
}
}else{
if($$key != ""){
$aryValue[jyou] .= "/".$$key;
}
}
break;
// 間取り内訳(和2)
case "lst_wajyou2":
if($$key == "-"){
$$key = "";
}
if($aryValue[jyou] == ""){
if($$key != ""){
$aryValue[jyou] = $aryValue[madorisuu]."和". $$key;
}else{
$aryValue[jyou] = $aryValue[madorisuu] . $$key;
}
}else{
if($$key != ""){
$aryValue[jyou] .= "/".$$key;
}
}
break;
// 間取り内訳(和3)
case "lst_wajyou3":
if($$key == "-"){
$$key = "";
}
if($aryValue[jyou] == ""){
if($$key != ""){
$aryValue[jyou] = $aryValue[madorisuu]."和". $$key;
}else{
$aryValue[jyou] = $aryValue[madorisuu] . $$key;
}
}else{
if($$key != ""){
$aryValue[jyou] .= "/".$$key;
}
}
break;
// 間取り内訳(和4)
case "lst_wajyou4":
if($$key == "-"){
$$key = "";
}
if($aryValue[jyou] == ""){
if($$key != ""){
$aryValue[jyou] = $aryValue[madorisuu]."和". $$key;
}else{
$aryValue[jyou] = $aryValue[madorisuu] . $$key;
}
}else{
if($$key != ""){
$aryValue[jyou] .= "/".$$key;
}
}
break;
// 間取り内訳(和5)
case "lst_wajyou5":
if($$key == "-"){
$$key = "";
}
if($aryValue[jyou] == ""){
if($$key != ""){
$aryValue[jyou] = $aryValue[madorisuu]."和". $$key;
}else{
$aryValue[jyou] = $aryValue[madorisuu] . $$key;
}
}else{
if($$key != ""){
$aryValue[jyou] .= "/".$$key;
}
}
break;
// 間取り内訳(和6)
case "lst_wajyou6":
if($$key == "-"){
$$key = "";
}
if($aryValue[jyou] == ""){
if($$key != ""){
$aryValue[jyou] = $aryValue[madorisuu]."和". $$key;
}else{
$aryValue[jyou] = $aryValue[madorisuu] . $$key;
}
}else{
if($$key != ""){
$aryValue[jyou] .= "/".$$key;
}
}
break;
// 間取り内訳(和7)
case "lst_wajyou7":
if($$key == "-"){
$$key = "";
}
if($aryValue[jyou] == ""){
if($$key != ""){
$aryValue[jyou] = $aryValue[madorisuu]."和". $$key;
}else{
$aryValue[jyou] = $aryValue[madorisuu] . $$key;
}
}else{
if($$key != ""){
$aryValue[jyou] .= "/".$$key;
}
}
break;
// 間取り内訳(和8)
case "lst_wajyou8":
if($$key == "-"){
$$key = "";
}
if($aryValue[jyou] == ""){
if($$key != ""){
$aryValue[jyou] = $aryValue[madorisuu]."和". $$key;
}else{
$aryValue[jyou] = $aryValue[madorisuu] . $$key;
}
}else{
if($$key != ""){
$aryValue[jyou] .= "/".$$key;
}
}
break;
// 間取り内訳(洋1)
case "lst_youjyou1":
if($$key == "-"){
$$key = "";
}
if($aryValue[jyou] == ""){
if($$key != ""){
$aryValue[jyou] = $aryValue[madorisuu]."洋". $$key;
}else{
$aryValue[jyou] = $aryValue[madorisuu] . $$key;
}
}else{
if($$key != ""){
if($stryoujyou ==""){
$stryoujyou = "洋". $$key;
$aryValue[jyou] .= $stryoujyou;
}else{
$aryValue[jyou] .= "/".$$key;
}
}
}
break;
// 間取り内訳(洋2)
case "lst_youjyou2":
if($$key == "-"){
$$key = "";
}
if($aryValue[jyou] == ""){
if($$key != ""){
$aryValue[jyou] = $aryValue[madorisuu]."洋". $$key;
}else{
$aryValue[jyou] = $aryValue[madorisuu] . $$key;
}
}else{
if($$key != ""){
if($stryoujyou ==""){
$stryoujyou = "洋". $$key;
$aryValue[jyou] .= $stryoujyou;
}else{
$aryValue[jyou] .= "/".$$key;
}
}
}
break;
// 間取り内訳(洋3)
case "lst_youjyou3":
if($$key == "-"){
$$key = "";
}
if($aryValue[jyou] == ""){
if($$key != ""){
$aryValue[jyou] = $aryValue[madorisuu]."洋". $$key;
}else{
$aryValue[jyou] = $aryValue[madorisuu] . $$key;
}
}else{
if($$key != ""){
if($stryoujyou ==""){
$stryoujyou = "洋". $$key;
$aryValue[jyou] .= $stryoujyou;
}else{
$aryValue[jyou] .= "/".$$key;
}
}
}
break;
// 間取り内訳(洋4)
case "lst_youjyou4":
if($$key == "-"){
$$key = "";
}
if($aryValue[jyou] == ""){
if($$key != ""){
$aryValue[jyou] = $aryValue[madorisuu]."洋". $$key;
}else{
$aryValue[jyou] = $aryValue[madorisuu] . $$key;
}
}else{
if($$key != ""){
if($stryoujyou ==""){
$stryoujyou = "洋". $$key;
$aryValue[jyou] .= $stryoujyou;
}else{
$aryValue[jyou] .= "/".$$key;
}
}
}
break;
// 間取り内訳(洋5)
case "lst_youjyou5":
if($$key == "-"){
$$key = "";
}
if($aryValue[jyou] == ""){
if($$key != ""){
$aryValue[jyou] = $aryValue[madorisuu]."洋". $$key;
}else{
$aryValue[jyou] = $aryValue[madorisuu] . $$key;
}
}else{
if($$key != ""){
if($stryoujyou ==""){
$stryoujyou = "洋". $$key;
$aryValue[jyou] .= $stryoujyou;
}else{
$aryValue[jyou] .= "/".$$key;
}
}
}
break;
// 間取り内訳(洋6)
case "lst_youjyou6":
if($$key == "-"){
$$key = "";
}
if($aryValue[jyou] == ""){
if($$key != ""){
$aryValue[jyou] = $aryValue[madorisuu]."洋". $$key;
}else{
$aryValue[jyou] = $aryValue[madorisuu] . $$key;
}
}else{
if($$key != ""){
if($stryoujyou ==""){
$stryoujyou = "洋". $$key;
$aryValue[jyou] .= $stryoujyou;
}else{
$aryValue[jyou] .= "/".$$key;
}
}
}
break;
// 間取り内訳(洋7)
case "lst_youjyou7":
if($$key == "-"){
$$key = "";
}
if($aryValue[jyou] == ""){
if($$key != ""){
$aryValue[jyou] = $aryValue[madorisuu]."洋". $$key;
}else{
$aryValue[jyou] = $aryValue[madorisuu] . $$key;
}
}else{
if($$key != ""){
if($stryoujyou ==""){
$stryoujyou = "洋". $$key;
$aryValue[jyou] .= $stryoujyou;
}else{
$aryValue[jyou] .= "/".$$key;
}
}
}
break;
// 間取り内訳(洋8)
case "lst_youjyou8":
if($$key == "-"){
$$key = "";
}
if($aryValue[jyou] == ""){
if($$key != ""){
$aryValue[jyou] = $aryValue[madorisuu]."洋". $$key;
}else{
$aryValue[jyou] = $aryValue[madorisuu] . $$key;
}
}else{
if($$key != ""){
if($stryoujyou ==""){
$stryoujyou = "洋". $$key;
$aryValue[jyou] .= $stryoujyou;
}else{
$aryValue[jyou] .= "/".$$key;
}
}
}
break;
// 地目
case "chimoku":
$strkeycd1="chimoku".$shubetu_cod;
$arySQL[$key] ="SELECT cocontents FROM mcommon WHERE cokey1='$strkeycd1' AND cokey2='$val'";
break;
// 都市計画
case "toshi":
$strkeycd1="toshi".$shubetu_cod;
$arySQL[$key] ="SELECT cocontents FROM mcommon WHERE cokey1='$strkeycd1' AND cokey2='$val'";
break;
// 用途地域
case "youto":
$strkeycd1="youto".$shubetu_cod;
$arySQL[$key] ="SELECT cocontents FROM mcommon WHERE cokey1='$strkeycd1' AND cokey2='$val'";
break;
// 現況
case "genkyo":
$strkeycd1="genkyo".$shubetu_cod;
$arySQL[$key] ="SELECT cocontents FROM mcommon WHERE cokey1='$strkeycd1' AND cokey2='$val'";
break;
// 引渡し
case "hiki_nam":
$strkeycd1="hiki_nam".$shubetu_cod;
$strSQL ="SELECT cocontents FROM mcommon WHERE cokey1='$strkeycd1' AND cokey2='$val'";
$aryResult = actSQL($strSQL,$strMsg);
if($aryResult[cocontents] == "-"){
$aryResult[cocontents] = "";
}
$aryValue[hiki] .= $aryResult[cocontents];
break;
// 引渡し(年)
case "hiki_nen":
if($$key == "-"){
$$key = "";
}
if($$key != ""){
$aryValue[hiki] .= $$key."年";
}else{
$aryValue[hiki] .= $$key;
}
break;
// 引渡し(月)
case "hiki_tsuki":
if($$key == "-"){
$$key = "";
}
if($$key != ""){
$aryValue[hiki] .= $$key."月";
}else{
$aryValue[hiki] .= $$key;
}
break;
// 引渡し(旬)
case "hiki_shun":
$strkeycd1="hiki_shun".$shubetu_cod;
$strSQL ="SELECT cocontents FROM mcommon WHERE cokey1='$strkeycd1' AND cokey2='$val'";
$aryResult = actSQL($strSQL,$strMsg);
if($aryResult[cocontents] == "-"){
$aryResult[cocontents] = "";
}
$aryValue[hiki] .= $aryResult[cocontents];
break;
// 設備1
case "setsubi1":
$strkeycd1="setsubi".$shubetu_cod;
$strSQL ="SELECT cocontents FROM mcommon WHERE cokey1='$strkeycd1' AND cokey2='$val'";
$aryResult = actSQL($strSQL,$strMsg);
if($aryResult[cocontents] == "-"){
$aryResult[cocontents] = "";
}
if($aryValue[setsubi] == ""){
$aryValue[setsubi] = $aryResult[cocontents];
}else{
if($aryResult[cocontents] != ""){
$aryValue[setsubi] .= "/". $aryResult[cocontents];
}
}
break;
// 設備2
case "setsubi2":
$strkeycd1="setsubi".$shubetu_cod;
$strSQL ="SELECT cocontents FROM mcommon WHERE cokey1='$strkeycd1' AND cokey2='$val'";
$aryResult = actSQL($strSQL,$strMsg);
if($aryResult[cocontents] == "-"){
$aryResult[cocontents] = "";
}
if($aryValue[setsubi] == ""){
$aryValue[setsubi] = $aryResult[cocontents];
}else{
if($aryResult[cocontents] != ""){
$aryValue[setsubi] .= "/". $aryResult[cocontents];
}
}
break;
// 設備3
case "setsubi3":
$strkeycd1="setsubi".$shubetu_cod;
$arySQL[$key] ="SELECT cocontents FROM mcommon WHERE cokey1='$strkeycd1' AND cokey2='$val'";
$aryResult = actSQL($arySQL[$key],$strMsg);
if($aryResult[cocontents] == "-"){
$aryResult[cocontents] = "";
}
if($aryValue[setsubi] == ""){
$aryValue[setsubi] = $aryResult[cocontents];
}else{
if($aryResult[cocontents] != ""){
$aryValue[setsubi] .= "/". $aryResult[cocontents];
}
}
break;
// 設備4
case "setsubi4":
$strkeycd1="setsubi".$shubetu_cod;
$arySQL[$key] ="SELECT cocontents FROM mcommon WHERE cokey1='$strkeycd1' AND cokey2='$val'";
$aryResult = actSQL($arySQL[$key],$strMsg);
if($aryResult[cocontents] == "-"){
$aryResult[cocontents] = "";
}
if($aryValue[setsubi] == ""){
$aryValue[setsubi] = $aryResult[cocontents];
}else{
if($aryResult[cocontents] != ""){
$aryValue[setsubi] .= "/". $aryResult[cocontents];
}
}
break;
// 設備5
case "setsubi5":
$strkeycd1="setsubi".$shubetu_cod;
$arySQL[$key] ="SELECT cocontents FROM mcommon WHERE cokey1='$strkeycd1' AND cokey2='$val'";
$aryResult = actSQL($arySQL[$key],$strMsg);
if($aryResult[cocontents] == "-"){
$aryResult[cocontents] = "";
}
if($aryValue[setsubi] == ""){
$aryValue[setsubi] = $aryResult[cocontents];
}else{
if($aryResult[cocontents] != ""){
$aryValue[setsubi] .= "/". $aryResult[cocontents];
}
}
break;
// 設備6
case "setsubi6":
$strkeycd1="setsubi".$shubetu_cod;
$arySQL[$key] ="SELECT cocontents FROM mcommon WHERE cokey1='$strkeycd1' AND cokey2='$val'";
$aryResult = actSQL($arySQL[$key],$strMsg);
if($aryResult[cocontents] == "-"){
$aryResult[cocontents] = "";
}
if($aryValue[setsubi] == ""){
$aryValue[setsubi] = $aryResult[cocontents];
}else{
if($aryResult[cocontents] != ""){
$aryValue[setsubi] .= "/". $aryResult[cocontents];
}
}
break;
// 設備7
case "setsubi7":
$strkeycd1="setsubi".$shubetu_cod;
$arySQL[$key] ="SELECT cocontents FROM mcommon WHERE cokey1='$strkeycd1' AND cokey2='$val'";
$aryResult = actSQL($arySQL[$key],$strMsg);
if($aryResult[cocontents] == "-"){
$aryResult[cocontents] = "";
}
if($aryValue[setsubi] == ""){
$aryValue[setsubi] = $aryResult[cocontents];
}else{
if($aryResult[cocontents] != ""){
$aryValue[setsubi] .= "/". $aryResult[cocontents];
}
}
break;
// 設備8
case "setsubi8":
$strkeycd1="setsubi".$shubetu_cod;
$arySQL[$key] ="SELECT cocontents FROM mcommon WHERE cokey1='$strkeycd1' AND cokey2='$val'";
$aryResult = actSQL($arySQL[$key],$strMsg);
if($aryResult[cocontents] == "-"){
$aryResult[cocontents] = "";
}
if($aryValue[setsubi] == ""){
$aryValue[setsubi] = $aryResult[cocontents];
}else{
if($aryResult[cocontents] != ""){
$aryValue[setsubi] .= "/". $aryResult[cocontents];
}
}
break;
// 設備9
case "setsubi9":
$strkeycd1="setsubi".$shubetu_cod;
$arySQL[$key] ="SELECT cocontents FROM mcommon WHERE cokey1='$strkeycd1' AND cokey2='$val'";
$aryResult = actSQL($arySQL[$key],$strMsg);
if($aryResult[cocontents] == "-"){
$aryResult[cocontents] = "";
}
if($aryValue[setsubi] == ""){
$aryValue[setsubi] = $aryResult[cocontents];
}else{
if($aryResult[cocontents] != ""){
$aryValue[setsubi] .= "/". $aryResult[cocontents];
}
}
break;
// 設備10
case "setsubi10":
$strkeycd1="setsubi".$shubetu_cod;
$arySQL[$key] ="SELECT cocontents FROM mcommon WHERE cokey1='$strkeycd1' AND cokey2='$val'";
$aryResult = actSQL($arySQL[$key],$strMsg);
if($aryResult[cocontents] == "-"){
$aryResult[cocontents] = "";
}
if($aryValue[setsubi] == ""){
$aryValue[setsubi] = $aryResult[cocontents];
}else{
if($aryResult[cocontents] != ""){
$aryValue[setsubi] .= "/". $aryResult[cocontents];
}
}
break;
// 接道方位1
case "houi_nam1":
$strkeycd1="direction";
$arySQL[$key] ="SELECT cocontents FROM mcommon WHERE cokey1='$strkeycd1' AND cokey2='$val'";
$aryResult = actSQL($arySQL[$key],$strMsg);
if($aryResult[cocontents] == "-"){
$aryResult[cocontents] = "";
}
if($aryValue[setsu] == "" ){
$aryValue[setsu] = $aryResult[cocontents];
}else{
if($aryResult[cocontents] != ""){
$aryValue[setsu] .= $aryResult[cocontents];
}
}
break;
// 接道幅1
case "setsu_haba1":
if($$key == "-" or $$key == "0"){
$$key = "";
}else{
$$key .= "m";
}
if($aryValue[setsu] == "" ){
$aryValue[setsu] = $$key;
}else{
if($aryResult[cocontents] != ""){
$aryValue[setsu] .= $$key;
}
}
break;
// 接道区分1
case "setsu_kbn1":
$strkeycd1="setsu_kbn1".$shubetu_cod;
$arySQL[$key] ="SELECT cocontents FROM mcommon WHERE cokey1='$strkeycd1' AND cokey2='$val'";
$aryResult = actSQL($arySQL[$key],$strMsg);
if($aryResult[cocontents] == "-"){
$aryResult[cocontents] = "";
}
if($aryValue[setsu] == "" ){
$aryValue[setsu] = $aryResult[cocontents];
}else{
if($aryResult[cocontents] != ""){
$aryValue[setsu] .= $aryResult[cocontents];
}
}
break;
// 接道面1
case "setsu_men1":
if($$key == "-" or $$key == "0"){
$$key = "";
}else{
$$key .= "m2";
}
if($aryValue[setsu] == "" ){
$aryValue[setsu] = $$key;
}else{
if($aryResult[cocontents] != ""){
$aryValue[setsu] .= $$key;
}
}
break;
// 接道位置1
case "setsu_ichi1":
$strkeycd1="setsu_ichi1".$shubetu_cod;
$arySQL[$key] ="SELECT cocontents FROM mcommon WHERE cokey1='$strkeycd1' AND cokey2='$val'";
$aryResult = actSQL($arySQL[$key],$strMsg);
if($aryResult[cocontents] == "-"){
$aryResult[cocontents] = "";
}
if($aryValue[setsu] == "" ){
$aryValue[setsu] = $aryResult[cocontents];
}else{
if($aryResult[cocontents] != ""){
$aryValue[setsu] .= $aryResult[cocontents];
}
}
break;
// 接道方位2
case "houi_nam2":
$strkeycd1="direction";
$arySQL[$key] ="SELECT cocontents FROM mcommon WHERE cokey1='$strkeycd1' AND cokey2='$val'";
$aryResult = actSQL($arySQL[$key],$strMsg);
if($aryResult[cocontents] == "-"){
$aryResult[cocontents] = "";
}
if($aryValue[setsu] == "" ){
$aryValue[setsu] = $aryResult[cocontents];
}else{
if($aryResult[cocontents] != ""){
if($strsetsu2 == ""){
$strsetsu2 = "/".$aryResult[cocontents];
$aryValue[setsu] .= $strsetsu2;
}else{
$aryValue[setsu] .= $aryResult[cocontents];
}
}
}
break;
// 接道幅2
case "setsu_haba2":
if($$key == "-" or $$key == "0"){
$$key = "";
}else{
$$key .= "m";
}
if($aryValue[setsu] == "" ){
$aryValue[setsu] = $$key;
}else{
if($aryResult[cocontents] != ""){
if($strsetsu2 == ""){
$strsetsu2 = "/".$$key;
$aryValue[setsu] .= $strsetsu2;
}else{
$aryValue[setsu] .= $$key;
}
}
}
break;
// 接道区分2
case "setsu_kbn2":
$strkeycd1="setsu_kbn2".$shubetu_cod;
$arySQL[$key] ="SELECT cocontents FROM mcommon WHERE cokey1='$strkeycd1' AND cokey2='$val'";
$aryResult = actSQL($arySQL[$key],$strMsg);
if($aryResult[cocontents] == "-"){
$aryResult[cocontents] = "";
}
if($aryValue[setsu] == "" ){
$aryValue[setsu] = $aryResult[cocontents];
}else{
if($aryResult[cocontents] != ""){
if($strsetsu2 == ""){
$strsetsu2 = "/".$aryResult[cocontents];
$aryValue[setsu] .= $strsetsu2;
}else{
$aryValue[setsu] .= $aryResult[cocontents];
}
}
}
break;
// 接道面2
case "setsu_men2":
if($$key == "-" or $$key == "0"){
$$key = "";
}else{
$$key .= "m2";
}
if($aryValue[setsu] == "" ){
$aryValue[setsu] = $$key;
}else{
if($aryResult[cocontents] != ""){
if($strsetsu2 == ""){
$strsetsu2 = "/".$$key;
$aryValue[setsu] .= $strsetsu2;
}else{
$aryValue[setsu] .= $$key;
}
}
}
break;
// 接道位置2
case "setsu_ichi2":
$strkeycd1="setsu_ichi2".$shubetu_cod;
$arySQL[$key] ="SELECT cocontents FROM mcommon WHERE cokey1='$strkeycd1' AND cokey2='$val'";
$aryResult = actSQL($arySQL[$key],$strMsg);
if($aryResult[cocontents] == "-"){
$aryResult[cocontents] = "";
}
if($aryValue[setsu] == "" ){
$aryValue[setsu] = $aryResult[cocontents];
}else{
if($aryResult[cocontents] != ""){
if($strsetsu2 == ""){
$strsetsu2 = "/".$aryResult[cocontents];
$aryValue[setsu] .= $strsetsu2;
}else{
$aryValue[setsu] .= $aryResult[cocontents];
}
}
}
break;
// 接道方位3
case "houi_nam3":
$strkeycd1="direction";
$arySQL[$key] ="SELECT cocontents FROM mcommon WHERE cokey1='$strkeycd1' AND cokey2='$val'";
$aryResult = actSQL($arySQL[$key],$strMsg);
if($aryResult[cocontents] == "-"){
$aryResult[cocontents] = "";
}
if($aryValue[setsu] == "" ){
$aryValue[setsu] = $aryResult[cocontents];
}else{
if($aryResult[cocontents] != ""){
if($strsetsu3 ==""){
$strsetsu3 = "/".$aryResult[cocontents];
$aryValue[setsu] .= $strsetsu3;
}else{
$aryValue[setsu] .= $aryResult[cocontents];
}
}
}
break;
// 接道幅3
case "setsu_haba3":
if($$key == "-" or $$key == "0"){
$$key = "";
}else{
$$key .= "m";
}
if($aryValue[setsu] == "" ){
$aryValue[setsu] = $$key;
}else{
if($aryResult[cocontents] != ""){
if($strsetsu3 ==""){
$strsetsu3 = "/".$$key;
$aryValue[setsu] .= $strsetsu3;
}else{
$aryValue[setsu] .= $$key;
}
}
}
break;
// 接道区分3
case "setsu_kbn3":
$strkeycd1="setsu_kbn3".$shubetu_cod;
$arySQL[$key] ="SELECT cocontents FROM mcommon WHERE cokey1='$strkeycd1' AND cokey2='$val'";
$aryResult = actSQL($arySQL[$key],$strMsg);
if($aryResult[cocontents] == "-"){
$aryResult[cocontents] = "";
}
if($aryValue[setsu] == "" ){
$aryValue[setsu] = $aryResult[cocontents];
}else{
if($aryResult[cocontents] != ""){
if($strsetsu3 ==""){
$strsetsu3 = "/".$aryResult[cocontents];
$aryValue[setsu] .= $strsetsu3;
}else{
$aryValue[setsu] .= $aryResult[cocontents];
}
}
}
break;
// 接道面3
case "setsu_men3":
if($$key == "-" or $$key == "0"){
$$key = "";
}else{
$$key .= "m2";
}
if($aryValue[setsu] == "" ){
$aryValue[setsu] = $$key;
}else{
if($aryResult[cocontents] != ""){
if($strsetsu3 ==""){
$strsetsu3 = "/".$aryResult[cocontents];
$aryValue[setsu] .= $$key;
}else{
$aryValue[setsu] .= $$key;
}
}
}
break;
// 接道位置3
case "setsu_ichi3":
$strkeycd1="setsu_ichi3".$shubetu_cod;
$arySQL[$key] ="SELECT cocontents FROM mcommon WHERE cokey1='$strkeycd1' AND cokey2='$val'";
$aryResult = actSQL($arySQL[$key],$strMsg);
if($aryResult[cocontents] == "-"){
$aryResult[cocontents] = "";
}
if($aryValue[setsu] == "" ){
$aryValue[setsu] = $aryResult[cocontents];
}else{
if($aryResult[cocontents] != ""){
if($strsetsu3 == ""){
$strsetsu3 = "/".$aryResult[cocontents];
$aryValue[setsu] .= $strsetsu3;
}else{
$aryValue[setsu] .= $aryResult[cocontents];
}
}
}
break;
// 角地
case "kadochi":
$strkeycd1="kadochi".$shubetu_cod;
$arySQL[$key] ="SELECT cocontents FROM mcommon WHERE cokey1='$strkeycd1' AND cokey2='$val'";
break;
// 駐車場有無
case "parking_nam":
$strkeycd1="parking_nam".$shubetu_cod;
$arySQL[$key] ="SELECT cocontents FROM mcommon WHERE cokey1='$strkeycd1' AND cokey2='$val'";
break;
// 条件等
case "cond":
$strkeycd1="cond".$shubetu_cod;
$arySQL[$key] ="SELECT cocontents FROM mcommon WHERE cokey1='$strkeycd1' AND cokey2='$val'";
break;
// 特記事項1
case "tokki1":
$strkeycd1="tokki".$shubetu_cod;
$arySQL[$key] ="SELECT cocontents FROM mcommon WHERE cokey1='$strkeycd1' AND cokey2='$val'";
$aryResult = actSQL($arySQL[$key],$strMsg);
if($aryResult[cocontents] == "-"){
$aryResult[cocontents] = "";
}
if($aryValue[tokki] == ""){
$aryValue[tokki] = $aryResult[cocontents];
}else{
if($aryResult[cocontents] != ""){
$aryValue[tokki] .= "/".$aryResult[cocontents];
}
}
break;
// 特記事項2
case "tokki2":
$strkeycd1="tokki".$shubetu_cod;
$arySQL[$key] ="SELECT cocontents FROM mcommon WHERE cokey1='$strkeycd1' AND cokey2='$val'";
$aryResult = actSQL($arySQL[$key],$strMsg);
if($aryResult[cocontents] == "-"){
$aryResult[cocontents] = "";
}
if($aryValue[tokki] == ""){
$aryValue[tokki] = $aryResult[cocontents];
}else{
if($aryResult[cocontents] != ""){
$aryValue[tokki] .= "/".$aryResult[cocontents];
}
}
break;
// 特記事項3
case "tokki3":
$strkeycd1="tokki".$shubetu_cod;
$arySQL[$key] ="SELECT cocontents FROM mcommon WHERE cokey1='$strkeycd1' AND cokey2='$val'";
$aryResult = actSQL($arySQL[$key],$strMsg);
if($aryResult[cocontents] == "-"){
$aryResult[cocontents] = "";
}
if($aryValue[tokki] == ""){
$aryValue[tokki] = $aryResult[cocontents];
}else{
if($aryResult[cocontents] != ""){
$aryValue[tokki] .= "/".$aryResult[cocontents];
}
}
break;
// 特記事項4
case "tokki4":
$strkeycd1="tokki".$shubetu_cod;
$arySQL[$key] ="SELECT cocontents FROM mcommon WHERE cokey1='$strkeycd1' AND cokey2='$val'";
$aryResult = actSQL($arySQL[$key],$strMsg);
if($aryResult[cocontents] == "-"){
$aryResult[cocontents] = "";
}
if($aryValue[tokki] == ""){
$aryValue[tokki] = $aryResult[cocontents];
}else{
if($aryResult[cocontents] != ""){
$aryValue[tokki] .= "/".$aryResult[cocontents];
}
}
break;
// 特記事項5
case "tokki5":
$strkeycd1="tokki".$shubetu_cod;
$arySQL[$key] ="SELECT cocontents FROM mcommon WHERE cokey1='$strkeycd1' AND cokey2='$val'";
$aryResult = actSQL($arySQL[$key],$strMsg);
if($aryResult[cocontents] == "-"){
$aryResult[cocontents] = "";
}
if($aryValue[tokki] == ""){
$aryValue[tokki] = $aryResult[cocontents];
}else{
if($aryResult[cocontents] != ""){
$aryValue[tokki] .= "/".$aryResult[cocontents];
}
}
break;
// 保険加入義務
case "hoken_flg":
$strkeycd1="hoken_flg".$shubetu_cod;
$arySQL[$key] ="SELECT cocontents FROM mcommon WHERE cokey1='$strkeycd1' AND cokey2='$val'";
break;
// 取引態様
case "torihiki":
$strkeycd1="torihiki".$shubetu_cod;
$arySQL[$key] ="SELECT cocontents FROM mcommon WHERE cokey1='$strkeycd1' AND cokey2='$val'";
break;
// 手数料
case "tes_nam":
$strkeycd1="tes_nam".$shubetu_cod;
$arySQL[$key] ="SELECT cocontents FROM mcommon WHERE cokey1='$strkeycd1' AND cokey2='$val'";
break;
// 契約期間
case "keiyakukikan":
if($$key == "-"){
$aryValue[keiyaku] = "";
}else{
$aryValue[keiyaku] = $$key . "年";
}
break;
// 契約期間
case "keiyaku_tsuki":
if($$key == "-"){
$aryValue[keiyaku] .= "";
}else{
$aryValue[keiyaku] .= $$key . "月";
}
break;
// 更新区分
case "lst_koshin_kbn":
$strkeycd1="lst_koshin_kbn".$shubetu_cod;
$arySQL[$key] ="SELECT cocontents FROM mcommon WHERE cokey1='$strkeycd1' AND cokey2='$val'";
break;
// 間取り
case "madoriurl1":
if($mode == "LST"){
if($$key == "-"){
$aryValue[$key] = "../../items/wait_s.gif";
}else{
$aryValue[$key] = "../../items"."/".substr($bukken_no,0,2)."/".substr($bukken_no,2,2)."/".substr($bukken_no,4,4)."/b_"."$val";
}
$aryImage = @GetImageSize($aryValue[$key]);
$tpl->append(strsize1,$aryImage[3]);
}else{
if($$key == "-"){
$aryValue[$key] = "../../items/wait.gif";
}else{
$aryValue[$key] = "../../items"."/".substr($bukken_no,0,2)."/".substr($bukken_no,2,2)."/".substr($bukken_no,4,4)."/a_"."$val";
}
$aryImage = @GetImageSize($aryValue[$key]);
$tpl->assign(strsize1,$aryImage[3]);
}
break;
// 外観
case "madoriurl2":
if($mode == "LST"){
if($$key == "-"){
$aryValue[$key] = "../../items/wait_s.gif";
}else{
$aryValue[$key] = "../../items"."/".substr($bukken_no,0,2)."/".substr($bukken_no,2,2)."/".substr($bukken_no,4,4)."/b_"."$val";
}
$aryImage = @GetImageSize($aryValue[$key]);
$tpl->append(strsize1,$aryImage[3]);
}else{
if($$key == "-"){
$aryValue[$key] = "../../items/wait.gif";
}else{
$aryValue[$key] = "../../items"."/".substr($bukken_no,0,2)."/".substr($bukken_no,2,2)."/".substr($bukken_no,4,4)."/a_"."$val";
}
$aryImage = @GetImageSize($aryValue[$key]);
$tpl->assign(strsize2,$aryImage[3]);
}
break;
// 築年年
case "chikunen":
if($$key == "-"){
$aryValue[$key] = "";
}else{
$aryValue[$key] = $$key . "年";
}
break;
// 築年月
case "chikutsuki":
if($$key == "-"){
$aryValue[$key] = "";
}else{
$aryValue[$key] = $$key . "月";
}
break;
// 登録日
case "crtday":
if($val != ""){
$strkeycd1 = substr($val,0,4);
$strkeycd2 = substr($val,4,2);
$strkeycd3 = substr($val,6,2);
$aryValue[$key] = "$strkeycd1"."/"."$strkeycd2"."/"."$strkeycd3";
}
break;
// 登録時刻
case "crttime":
if($val != ""){
$strkeycd1 = substr($val,0,2);
$strkeycd2 = substr($val,2,2);
$strkeycd3 = substr($val,4,2);
$aryValue[$key] = "$strkeycd1".":"."$strkeycd2".":"."$strkeycd3";
}
break;
// 登録者
case "crtpurchage":
$arySQL[$key] ="SELECT mstaffname FROM mstaff WHERE mstaffcd = '$val' AND mstdelflg = ''";
break;
// 変更日
case "updday":
if($val != ""){
$strkeycd1 = substr($val,0,4);
$strkeycd2 = substr($val,4,2);
$strkeycd3 = substr($val,6,2);
$aryValue[$key] = "$strkeycd1"."/"."$strkeycd2"."/"."$strkeycd3";
// 最新物件判断
$nowymd = date("Y-m-d"); // 日付
$addymd = "0000-00-7"; // 減算日付(7日前)
list( $ny, $nm, $nd ) = split( '-', $nowymd );
list( $ay, $am, $ad ) = split( '-', $addymd );
$timestamp = mktime( 0, 0, 0, $nm + $am, $nd - $ad, $ny - $ay );
$ymd = date( 'Ymd', $timestamp );
if($ymd < $val){
$aryValue[newdate] = 最新;
}else{
$aryValue[newdate] = " ";
}
}
break;
// 変更時刻
case "updtime":
if($val != ""){
$strkeycd1 = substr($val,0,2);
$strkeycd2 = substr($val,2,2);
$strkeycd3 = substr($val,4,2);
$aryValue[$key] = "$strkeycd1".":"."$strkeycd2".":"."$strkeycd3";
}
break;
// 変更者
case "updpurchage":
$arySQL[$key] ="SELECT mstaffname FROM mstaff WHERE mstaffcd = '$val' AND mstdelflg = ''";
break;
default:
$aryValue[$key] = $$key;
break;
}
}
// 一般項目セット
if($aryValue != ""){
foreach( $aryValue as $key=>$val ){
$$key = trim($val);
if($$key == "" or $$key =="0" or $$key =="-1"){
$$key = "-";
}
if($mode == 'LST'){
$tpl->append($key,$$key);
}else{
$tpl->assign($key,$$key);
}
}
}
// 特別編集項目セット
if($arySQL != ""){
foreach( $arySQL as $key=>$val ){
$aryResult=actSQL($val,$strMsg);
$$key = trim($aryResult[0]);
if($$key == "" or $$key =="0" or $$key =="-1"){
$$key = "-";
if($key == "madori"){
$$key = " ";
}
}
if($mode == 'LST'){
$tpl->append($key,$$key);
}else{
$tpl->assign($key,$$key);
}
}
}
}
}
?>