$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); } } } } } ?>