緑道が続く白子川沿いから緩い坂道を登った高台のフラットな地形、ここに建つ新居が２組のファミリーを迎える。風が通る南向きの道で周囲を明るく照らす日差し、駅へ続く平坦な道、川沿いに続く公園、新しい家が建ち並ぶ住宅街に4LDKのボリュームで子育て世帯の暮らしを支えます。
3LDK+ロフト+カースペース1台
敷地面積：95.84m2 建物延床面積：95.63m2
6,780万円
4LDK+WIC+小屋裏収納+カースペース1台
敷地面積：101.26m2 建物延床面積：95.01m2
6,280万円
モデルハウス見学受付中
| 価格 | 6,280万円～6,780万円 |
|---|---|
| 種類 | 新築戸建 |
| 所在地 | 練馬区南大泉4丁目 |
| 土地権利 | 所有権 |
| 敷地面積 | 95.84㎡～101.26㎡ |
| 設備 | 公営水道・本下水・東京ガス・東京電力 |
| 接道状況 | 南西側 約4m区道 |
| 都市計画 | 市街化区域 |
| 用途地域 | 第一種低層住居専用地域 |
| 高度地区 | 第一種高度地区 |
| 防火指定 | 準防火地域 |
| 建ぺい率/ 容積率 |
50％／100％ |
| 総区画数 | 2 |
| 建築確認番号 | 第24UDI1T建04646号他 |
| 建物面積 | 95.01㎡～95.63㎡ |
| 建物構造 | 木造2階建 |
| 間取り | 3LDK+ロフト+カースペース1台～4LDK+WIC+小屋裏 |
| 完成時期 | 2025年7月下旬以降予定 |
| 引渡時期 | 相談 |
| 取引態様 | 媒介 |
| 建物仕様 | ◆LD床暖房 ◆浴室暖房乾燥機 ◆居室ペアガラス ◆一部LED照明 ◆網戸 |
|---|---|
| ポイント | ●耐震等級2 ●制震ダンパー |
| 指定学校区 | 練馬区立大泉第六小学校 練馬区立大泉第二中学校 |
| 備考 | ●準耐火構造 ●A号棟は地盤改良工事実施 |
更地／2025.3.17撮影
更地／2025.3.17撮影
更地／2025.3.17撮影
前面道路／2025.3.17撮影
前面道路／2025.3.17撮影
防水シート／2025.3.31撮影
モデルハウス見学受付中
モデルハウス見学受付中
路線検索
会員限定物件
Notice (8): Undefined variable: area_results_member [APP/Template/Element/search_Area_Railway.ctp, line 89]Code Context<?phpforeach($area_results_member as $key => $dat){?>$viewFile = '/data/WWW/rainbow/test.life-hf.co.jp/htdocs/src/Template/Element/search_Area_Railway.ctp' $dataForView = [ 'Onsites' => object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SELECT Onsites.id AS `Onsites__id`, Onsites.name AS `Onsites__name`, Onsites.mbAddress AS `Onsites__mbAddress`, Onsites.displayFlg AS `Onsites__displayFlg`, Onsites.statusFlg AS `Onsites__statusFlg`, Onsites.area_id AS `Onsites__area_id`, Onsites.sectionNo AS `Onsites__sectionNo`, Onsites.kind_id AS `Onsites__kind_id`, Onsites.landFlg AS `Onsites__landFlg`, Onsites.lifetownFlg AS `Onsites__lifetownFlg`, Onsites.newoldFlg AS `Onsites__newoldFlg`, Onsites.tour_id AS `Onsites__tour_id`, Onsites.topDispFlg AS `Onsites__topDispFlg`, Onsites.recommFlg AS `Onsites__recommFlg`, Onsites.railway_id1 AS `Onsites__railway_id1`, Onsites.railway_id2 AS `Onsites__railway_id2`, Onsites.railway_id3 AS `Onsites__railway_id3`, Onsites.station_id1 AS `Onsites__station_id1`, Onsites.station_id2 AS `Onsites__station_id2`, Onsites.station_id3 AS `Onsites__station_id3`, Onsites.stwalk1 AS `Onsites__stwalk1`, Onsites.stwalk2 AS `Onsites__stwalk2`, Onsites.stwalk3 AS `Onsites__stwalk3`, Onsites.bswalk1 AS `Onsites__bswalk1`, Onsites.bswalk2 AS `Onsites__bswalk2`, Onsites.bswalk3 AS `Onsites__bswalk3`, Onsites.catchCopy AS `Onsites__catchCopy`, Onsites.stationStart AS `Onsites__stationStart`, Onsites.stationTo1 AS `Onsites__stationTo1`, Onsites.stationTo2 AS `Onsites__stationTo2`, Onsites.stationTo3 AS `Onsites__stationTo3`, Onsites.stationTo4 AS `Onsites__stationTo4`, Onsites.trainTime1 AS `Onsites__trainTime1`, Onsites.trainTime2 AS `Onsites__trainTime2`, Onsites.trainTime3 AS `Onsites__trainTime3`, Onsites.trainTime4 AS `Onsites__trainTime4`, Onsites.trainDirect1 AS `Onsites__trainDirect1`, Onsites.trainDirect2 AS `Onsites__trainDirect2`, Onsites.trainDirect3 AS `Onsites__trainDirect3`, Onsites.trainDirect4 AS `Onsites__trainDirect4`, Onsites.trainVia1 AS `Onsites__trainVia1`, Onsites.trainVia2 AS `Onsites__trainVia2`, Onsites.trainVia3 AS `Onsites__trainVia3`, Onsites.trainVia4 AS `Onsites__trainVia4`, Onsites.locationFlg AS `Onsites__locationFlg`, Onsites.locationTitle1 AS `Onsites__locationTitle1`, Onsites.locationTitle2 AS `Onsites__locationTitle2`, Onsites.locationTxt1 AS `Onsites__locationTxt1`, Onsites.locationTxt2 AS `Onsites__locationTxt2`, Onsites.locationTxt3 AS `Onsites__locationTxt3`, Onsites.locationTxt4 AS `Onsites__locationTxt4`, Onsites.locationTxt5 AS `Onsites__locationTxt5`, Onsites.locationTxt6 AS `Onsites__locationTxt6`, Onsites.locationTxt7 AS `Onsites__locationTxt7`, Onsites.locationTxt8 AS `Onsites__locationTxt8`, Onsites.locationTxt9 AS `Onsites__locationTxt9`, Onsites.locationTxt10 AS `Onsites__locationTxt10`, Onsites.locationTxt11 AS `Onsites__locationTxt11`, Onsites.locationTxt12 AS `Onsites__locationTxt12`, Onsites.locationTxt13 AS `Onsites__locationTxt13`, Onsites.locationTxt14 AS `Onsites__locationTxt14`, Onsites.locationTxt15 AS `Onsites__locationTxt15`, Onsites.locationTxt16 AS `Onsites__locationTxt16`, Onsites.locationTxt17 AS `Onsites__locationTxt17`, Onsites.locationTxt18 AS `Onsites__locationTxt18`, Onsites.galleryTxt1 AS `Onsites__galleryTxt1`, Onsites.galleryTxt2 AS `Onsites__galleryTxt2`, Onsites.galleryTxt3 AS `Onsites__galleryTxt3`, Onsites.galleryTxt4 AS `Onsites__galleryTxt4`, Onsites.galleryTxt5 AS `Onsites__galleryTxt5`, Onsites.galleryTxt6 AS `Onsites__galleryTxt6`, Onsites.galleryTxt7 AS `Onsites__galleryTxt7`, Onsites.galleryTxt8 AS `Onsites__galleryTxt8`, Onsites.galleryTxt9 AS `Onsites__galleryTxt9`, Onsites.galleryTxt10 AS `Onsites__galleryTxt10`, Onsites.galleryTxt11 AS `Onsites__galleryTxt11`, Onsites.galleryTxt12 AS `Onsites__galleryTxt12`, Onsites.galleryTxt13 AS `Onsites__galleryTxt13`, Onsites.galleryTxt14 AS `Onsites__galleryTxt14`, Onsites.galleryTxt15 AS `Onsites__galleryTxt15`, Onsites.galleryTxt16 AS `Onsites__galleryTxt16`, Onsites.galleryTxt17 AS `Onsites__galleryTxt17`, Onsites.galleryTxt18 AS `Onsites__galleryTxt18`, Onsites.locationTraffic AS `Onsites__locationTraffic`, Onsites.locationSchool AS `Onsites__locationSchool`, Onsites.locationLife AS `Onsites__locationLife`, Onsites.locationOther AS `Onsites__locationOther`, Onsites.parthFlg AS `Onsites__parthFlg`, Onsites.parthImgFlg1 AS `Onsites__parthImgFlg1`, Onsites.parthImgFlg2 AS `Onsites__parthImgFlg2`, Onsites.parthImgFlg3 AS `Onsites__parthImgFlg3`, Onsites.parthImgFlg4 AS `Onsites__parthImgFlg4`, Onsites.kuwariFlg AS `Onsites__kuwariFlg`, Onsites.planFlg AS `Onsites__planFlg`, Onsites.outlinePrice AS `Onsites__outlinePrice`, Onsites.outlinePriceNum AS `Onsites__outlinePriceNum`, Onsites.outlineType AS `Onsites__outlineType`, Onsites.outlinePlace AS `Onsites__outlinePlace`, Onsites.outlineTraffic AS `Onsites__outlineTraffic`, Onsites.outlineRight AS `Onsites__outlineRight`, Onsites.outlineSite AS `Onsites__outlineSite`, Onsites.outlineFacility AS `Onsites__outlineFacility`, Onsites.outlineApproach AS `Onsites__outlineApproach`, Onsites.outlineCityplan AS `Onsites__outlineCityplan`, Onsites.outlineUse1 AS `Onsites__outlineUse1`, Onsites.outlineUse2 AS `Onsites__outlineUse2`, Onsites.outlineAltitude1 AS `Onsites__outlineAltitude1`, Onsites.outlineAltitude2 AS `Onsites__outlineAltitude2`, Onsites.outlineFire1 AS `Onsites__outlineFire1`, Onsites.outlineFire2 AS `Onsites__outlineFire2`, Onsites.outlineVolume1 AS `Onsites__outlineVolume1`, Onsites.outlineVolume2 AS `Onsites__outlineVolume2`, Onsites.outlinePlots AS `Onsites__outlinePlots`, Onsites.outlineBuldingNo AS `Onsites__outlineBuldingNo`, Onsites.outlineBuildingArea AS `Onsites__outlineBuildingArea`, Onsites.outlineConstruction AS `Onsites__outlineConstruction`, Onsites.outlineFloorPlan AS `Onsites__outlineFloorPlan`, Onsites.outlineCompTime AS `Onsites__outlineCompTime`, Onsites.outlineDelivTime AS `Onsites__outlineDelivTime`, Onsites.outlineTransForm AS `Onsites__outlineTransForm`, Onsites.outlineEquipment AS `Onsites__outlineEquipment`, Onsites.outlineComment AS `Onsites__outlineComment`, Onsites.outlineSchool AS `Onsites__outlineSchool`, Onsites.googleMap AS `Onsites__googleMap`, Onsites.memo AS `Onsites__memo`, Onsites.priceFlg AS `Onsites__priceFlg`, Onsites.newFlg AS `Onsites__newFlg`, Onsites.lastFlg AS `Onsites__lastFlg`, Onsites.topImgFlg AS `Onsites__topImgFlg`, Onsites.memberFlg AS `Onsites__memberFlg`, Onsites.deleteFlg AS `Onsites__deleteFlg`, Onsites.created AS `Onsites__created`, Onsites.modified AS `Onsites__modified`, Areas.id AS `Areas__id`, Areas.areaClass_cd AS `Areas__areaClass_cd`, Areas.name AS `Areas__name`, Areas.sortPt AS `Areas__sortPt`, Areas.editDate AS `Areas__editDate`, Kinds.id AS `Kinds__id`, Kinds.name AS `Kinds__name`, Kinds.sortPt AS `Kinds__sortPt`, Kinds.editDate AS `Kinds__editDate`, Tours.id AS `Tours__id`, Tours.name AS `Tours__name`, Tours.sortPt AS `Tours__sortPt`, Tours.category AS `Tours__category`, Tours.editDate AS `Tours__editDate`, Railways1.id AS `Railways1__id`, Railways1.name AS `Railways1__name`, Railways1.sortPt AS `Railways1__sortPt`, Railways1.editDate AS `Railways1__editDate`, Railways2.id AS `Railways2__id`, Railways2.name AS `Railways2__name`, Railways2.sortPt AS `Railways2__sortPt`, Railways2.editDate AS `Railways2__editDate`, Railways3.id AS `Railways3__id`, Railways3.name AS `Railways3__name`, Railways3.sortPt AS `Railways3__sortPt`, Railways3.editDate AS `Railways3__editDate`, Stations1.id AS `Stations1__id`, Stations1.name AS `Stations1__name`, Stations1.railway_id AS `Stations1__railway_id`, Stations1.pref_cd AS `Stations1__pref_cd`, Stations1.sortPt AS `Stations1__sortPt`, Stations1.editDate AS `Stations1__editDate`, Stations2.id AS `Stations2__id`, Stations2.name AS `Stations2__name`, Stations2.railway_id AS `Stations2__railway_id`, Stations2.pref_cd AS `Stations2__pref_cd`, Stations2.sortPt AS `Stations2__sortPt`, Stations2.editDate AS `Stations2__editDate`, Stations3.id AS `Stations3__id`, Stations3.name AS `Stations3__name`, Stations3.railway_id AS `Stations3__railway_id`, Stations3.pref_cd AS `Stations3__pref_cd`, Stations3.sortPt AS `Stations3__sortPt`, Stations3.editDate AS `Stations3__editDate` FROM onsites Onsites LEFT JOIN areas Areas ON Areas.id = (Onsites.area_id) LEFT JOIN kinds Kinds ON Kinds.id = (Onsites.kind_id) LEFT JOIN tours Tours ON Tours.id = (Onsites.tour_id) LEFT JOIN railways Railways1 ON Railways1.id = (Onsites.railway_id1) LEFT JOIN railways Railways2 ON Railways2.id = (Onsites.railway_id2) LEFT JOIN railways Railways3 ON Railways3.id = (Onsites.railway_id3) LEFT JOIN stations Stations1 ON Stations1.id = (Onsites.station_id1) LEFT JOIN stations Stations2 ON Stations2.id = (Onsites.station_id2) LEFT JOIN stations Stations3 ON Stations3.id = (Onsites.station_id3) WHERE Onsites.id = :c0', 'params' => [ [maximum depth reached] ], 'defaultTypes' => [ [maximum depth reached] ], 'decorators' => (int) 0, 'executed' => true, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [ [maximum depth reached] ], 'matching' => [[maximum depth reached]], 'extraOptions' => [[maximum depth reached]], 'repository' => object(App\Model\Table\OnsitesTable) {} }, 'area_results' => [ (int) 0 => [ 'area_id' => '1', 'name' => '杉並区', 'Ct' => '44', 'CtM' => '17' ], (int) 1 => [ 'area_id' => '2', 'name' => '練馬区', 'Ct' => '24', 'CtM' => '1' ], (int) 2 => [ 'area_id' => '3', 'name' => '中野区', 'Ct' => '7', 'CtM' => '0' ], (int) 3 => [ 'area_id' => '5', 'name' => '世田谷区', 'Ct' => '2', 'CtM' => '0' ], (int) 4 => [ 'area_id' => '8', 'name' => '新宿区', 'Ct' => '2', 'CtM' => '0' ], (int) 5 => [ 'area_id' => '9', 'name' => '豊島区', 'Ct' => '1', 'CtM' => '0' ], (int) 6 => [ 'area_id' => '10', 'name' => '渋谷区', 'Ct' => '1', 'CtM' => '0' ], (int) 7 => [ 'area_id' => '24', 'name' => '武蔵野市', 'Ct' => '3', 'CtM' => '0' ], (int) 8 => [ 'area_id' => '25', 'name' => '三鷹市', 'Ct' => '0', 'CtM' => '1' ], (int) 9 => [ 'area_id' => '28', 'name' => '西東京市', 'Ct' => '3', 'CtM' => '0' ] ], 'railway_results' => [ (int) 0 => [ 'rway' => '11302', 'name' => 'JR山手線', 'ct' => '3' ], (int) 1 => [ 'rway' => '11312', 'name' => 'JR中央線(快速)', 'ct' => '58' ], (int) 2 => [ 'rway' => '11313', 'name' => 'JR中央・総武線', 'ct' => '9' ], (int) 3 => [ 'rway' => '21001', 'name' => '東武東上線', 'ct' => '2' ], (int) 4 => [ 'rway' => '22001', 'name' => '西武池袋線', 'ct' => '37' ], (int) 5 => [ 'rway' => '22007', 'name' => '西武新宿線', 'ct' => '64' ], (int) 6 => [ 'rway' => '24001', 'name' => '京王線', 'ct' => '10' ], (int) 7 => [ 'rway' => '24006', 'name' => '京王井の頭線', 'ct' => '30' ], (int) 8 => [ 'rway' => '24007', 'name' => '京王新線', 'ct' => '1' ], (int) 9 => [ 'rway' => '25001', 'name' => '小田急線', 'ct' => '2' ], (int) 10 => [ 'rway' => '26003', 'name' => '東急田園都市線', 'ct' => '1' ], (int) 11 => [ 'rway' => '26007', 'name' => '東急世田谷線', 'ct' => '2' ], (int) 12 => [ 'rway' => '28002', 'name' => '東京メトロ丸ノ内線', 'ct' => '24' ], (int) 13 => [ 'rway' => '28004', 'name' => '東京メトロ東西線', 'ct' => '1' ], (int) 14 => [ 'rway' => '28006', 'name' => '東京メトロ有楽町線', 'ct' => '2' ], (int) 15 => [ 'rway' => '28010', 'name' => '東京メトロ副都心線', 'ct' => '5' ], (int) 16 => [ 'rway' => '99301', 'name' => '都営大江戸線', 'ct' => '10' ] ], 'OptionCT' => [ 'railway' => (int) 19, 'pet' => (int) 9, 'life' => (int) 61, 'space' => (int) 18 ], 'user' => null, 'NoList' => true, 'members_total' => '19' ] $Onsites = object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SELECT Onsites.id AS `Onsites__id`, Onsites.name AS `Onsites__name`, Onsites.mbAddress AS `Onsites__mbAddress`, Onsites.displayFlg AS `Onsites__displayFlg`, Onsites.statusFlg AS `Onsites__statusFlg`, Onsites.area_id AS `Onsites__area_id`, Onsites.sectionNo AS `Onsites__sectionNo`, Onsites.kind_id AS `Onsites__kind_id`, Onsites.landFlg AS `Onsites__landFlg`, Onsites.lifetownFlg AS `Onsites__lifetownFlg`, Onsites.newoldFlg AS `Onsites__newoldFlg`, Onsites.tour_id AS `Onsites__tour_id`, Onsites.topDispFlg AS `Onsites__topDispFlg`, Onsites.recommFlg AS `Onsites__recommFlg`, Onsites.railway_id1 AS `Onsites__railway_id1`, Onsites.railway_id2 AS `Onsites__railway_id2`, Onsites.railway_id3 AS `Onsites__railway_id3`, Onsites.station_id1 AS `Onsites__station_id1`, Onsites.station_id2 AS `Onsites__station_id2`, Onsites.station_id3 AS `Onsites__station_id3`, Onsites.stwalk1 AS `Onsites__stwalk1`, Onsites.stwalk2 AS `Onsites__stwalk2`, Onsites.stwalk3 AS `Onsites__stwalk3`, Onsites.bswalk1 AS `Onsites__bswalk1`, Onsites.bswalk2 AS `Onsites__bswalk2`, Onsites.bswalk3 AS `Onsites__bswalk3`, Onsites.catchCopy AS `Onsites__catchCopy`, Onsites.stationStart AS `Onsites__stationStart`, Onsites.stationTo1 AS `Onsites__stationTo1`, Onsites.stationTo2 AS `Onsites__stationTo2`, Onsites.stationTo3 AS `Onsites__stationTo3`, Onsites.stationTo4 AS `Onsites__stationTo4`, Onsites.trainTime1 AS `Onsites__trainTime1`, Onsites.trainTime2 AS `Onsites__trainTime2`, Onsites.trainTime3 AS `Onsites__trainTime3`, Onsites.trainTime4 AS `Onsites__trainTime4`, Onsites.trainDirect1 AS `Onsites__trainDirect1`, Onsites.trainDirect2 AS `Onsites__trainDirect2`, Onsites.trainDirect3 AS `Onsites__trainDirect3`, Onsites.trainDirect4 AS `Onsites__trainDirect4`, Onsites.trainVia1 AS `Onsites__trainVia1`, Onsites.trainVia2 AS `Onsites__trainVia2`, Onsites.trainVia3 AS `Onsites__trainVia3`, Onsites.trainVia4 AS `Onsites__trainVia4`, Onsites.locationFlg AS `Onsites__locationFlg`, Onsites.locationTitle1 AS `Onsites__locationTitle1`, Onsites.locationTitle2 AS `Onsites__locationTitle2`, Onsites.locationTxt1 AS `Onsites__locationTxt1`, Onsites.locationTxt2 AS `Onsites__locationTxt2`, Onsites.locationTxt3 AS `Onsites__locationTxt3`, Onsites.locationTxt4 AS `Onsites__locationTxt4`, Onsites.locationTxt5 AS `Onsites__locationTxt5`, Onsites.locationTxt6 AS `Onsites__locationTxt6`, Onsites.locationTxt7 AS `Onsites__locationTxt7`, Onsites.locationTxt8 AS `Onsites__locationTxt8`, Onsites.locationTxt9 AS `Onsites__locationTxt9`, Onsites.locationTxt10 AS `Onsites__locationTxt10`, Onsites.locationTxt11 AS `Onsites__locationTxt11`, Onsites.locationTxt12 AS `Onsites__locationTxt12`, Onsites.locationTxt13 AS `Onsites__locationTxt13`, Onsites.locationTxt14 AS `Onsites__locationTxt14`, Onsites.locationTxt15 AS `Onsites__locationTxt15`, Onsites.locationTxt16 AS `Onsites__locationTxt16`, Onsites.locationTxt17 AS `Onsites__locationTxt17`, Onsites.locationTxt18 AS `Onsites__locationTxt18`, Onsites.galleryTxt1 AS `Onsites__galleryTxt1`, Onsites.galleryTxt2 AS `Onsites__galleryTxt2`, Onsites.galleryTxt3 AS `Onsites__galleryTxt3`, Onsites.galleryTxt4 AS `Onsites__galleryTxt4`, Onsites.galleryTxt5 AS `Onsites__galleryTxt5`, Onsites.galleryTxt6 AS `Onsites__galleryTxt6`, Onsites.galleryTxt7 AS `Onsites__galleryTxt7`, Onsites.galleryTxt8 AS `Onsites__galleryTxt8`, Onsites.galleryTxt9 AS `Onsites__galleryTxt9`, Onsites.galleryTxt10 AS `Onsites__galleryTxt10`, Onsites.galleryTxt11 AS `Onsites__galleryTxt11`, Onsites.galleryTxt12 AS `Onsites__galleryTxt12`, Onsites.galleryTxt13 AS `Onsites__galleryTxt13`, Onsites.galleryTxt14 AS `Onsites__galleryTxt14`, Onsites.galleryTxt15 AS `Onsites__galleryTxt15`, Onsites.galleryTxt16 AS `Onsites__galleryTxt16`, Onsites.galleryTxt17 AS `Onsites__galleryTxt17`, Onsites.galleryTxt18 AS `Onsites__galleryTxt18`, Onsites.locationTraffic AS `Onsites__locationTraffic`, Onsites.locationSchool AS `Onsites__locationSchool`, Onsites.locationLife AS `Onsites__locationLife`, Onsites.locationOther AS `Onsites__locationOther`, Onsites.parthFlg AS `Onsites__parthFlg`, Onsites.parthImgFlg1 AS `Onsites__parthImgFlg1`, Onsites.parthImgFlg2 AS `Onsites__parthImgFlg2`, Onsites.parthImgFlg3 AS `Onsites__parthImgFlg3`, Onsites.parthImgFlg4 AS `Onsites__parthImgFlg4`, Onsites.kuwariFlg AS `Onsites__kuwariFlg`, Onsites.planFlg AS `Onsites__planFlg`, Onsites.outlinePrice AS `Onsites__outlinePrice`, Onsites.outlinePriceNum AS `Onsites__outlinePriceNum`, Onsites.outlineType AS `Onsites__outlineType`, Onsites.outlinePlace AS `Onsites__outlinePlace`, Onsites.outlineTraffic AS `Onsites__outlineTraffic`, Onsites.outlineRight AS `Onsites__outlineRight`, Onsites.outlineSite AS `Onsites__outlineSite`, Onsites.outlineFacility AS `Onsites__outlineFacility`, Onsites.outlineApproach AS `Onsites__outlineApproach`, Onsites.outlineCityplan AS `Onsites__outlineCityplan`, Onsites.outlineUse1 AS `Onsites__outlineUse1`, Onsites.outlineUse2 AS `Onsites__outlineUse2`, Onsites.outlineAltitude1 AS `Onsites__outlineAltitude1`, Onsites.outlineAltitude2 AS `Onsites__outlineAltitude2`, Onsites.outlineFire1 AS `Onsites__outlineFire1`, Onsites.outlineFire2 AS `Onsites__outlineFire2`, Onsites.outlineVolume1 AS `Onsites__outlineVolume1`, Onsites.outlineVolume2 AS `Onsites__outlineVolume2`, Onsites.outlinePlots AS `Onsites__outlinePlots`, Onsites.outlineBuldingNo AS `Onsites__outlineBuldingNo`, Onsites.outlineBuildingArea AS `Onsites__outlineBuildingArea`, Onsites.outlineConstruction AS `Onsites__outlineConstruction`, Onsites.outlineFloorPlan AS `Onsites__outlineFloorPlan`, Onsites.outlineCompTime AS `Onsites__outlineCompTime`, Onsites.outlineDelivTime AS `Onsites__outlineDelivTime`, Onsites.outlineTransForm AS `Onsites__outlineTransForm`, Onsites.outlineEquipment AS `Onsites__outlineEquipment`, Onsites.outlineComment AS `Onsites__outlineComment`, Onsites.outlineSchool AS `Onsites__outlineSchool`, Onsites.googleMap AS `Onsites__googleMap`, Onsites.memo AS `Onsites__memo`, Onsites.priceFlg AS `Onsites__priceFlg`, Onsites.newFlg AS `Onsites__newFlg`, Onsites.lastFlg AS `Onsites__lastFlg`, Onsites.topImgFlg AS `Onsites__topImgFlg`, Onsites.memberFlg AS `Onsites__memberFlg`, Onsites.deleteFlg AS `Onsites__deleteFlg`, Onsites.created AS `Onsites__created`, Onsites.modified AS `Onsites__modified`, Areas.id AS `Areas__id`, Areas.areaClass_cd AS `Areas__areaClass_cd`, Areas.name AS `Areas__name`, Areas.sortPt AS `Areas__sortPt`, Areas.editDate AS `Areas__editDate`, Kinds.id AS `Kinds__id`, Kinds.name AS `Kinds__name`, Kinds.sortPt AS `Kinds__sortPt`, Kinds.editDate AS `Kinds__editDate`, Tours.id AS `Tours__id`, Tours.name AS `Tours__name`, Tours.sortPt AS `Tours__sortPt`, Tours.category AS `Tours__category`, Tours.editDate AS `Tours__editDate`, Railways1.id AS `Railways1__id`, Railways1.name AS `Railways1__name`, Railways1.sortPt AS `Railways1__sortPt`, Railways1.editDate AS `Railways1__editDate`, Railways2.id AS `Railways2__id`, Railways2.name AS `Railways2__name`, Railways2.sortPt AS `Railways2__sortPt`, Railways2.editDate AS `Railways2__editDate`, Railways3.id AS `Railways3__id`, Railways3.name AS `Railways3__name`, Railways3.sortPt AS `Railways3__sortPt`, Railways3.editDate AS `Railways3__editDate`, Stations1.id AS `Stations1__id`, Stations1.name AS `Stations1__name`, Stations1.railway_id AS `Stations1__railway_id`, Stations1.pref_cd AS `Stations1__pref_cd`, Stations1.sortPt AS `Stations1__sortPt`, Stations1.editDate AS `Stations1__editDate`, Stations2.id AS `Stations2__id`, Stations2.name AS `Stations2__name`, Stations2.railway_id AS `Stations2__railway_id`, Stations2.pref_cd AS `Stations2__pref_cd`, Stations2.sortPt AS `Stations2__sortPt`, Stations2.editDate AS `Stations2__editDate`, Stations3.id AS `Stations3__id`, Stations3.name AS `Stations3__name`, Stations3.railway_id AS `Stations3__railway_id`, Stations3.pref_cd AS `Stations3__pref_cd`, Stations3.sortPt AS `Stations3__sortPt`, Stations3.editDate AS `Stations3__editDate` FROM onsites Onsites LEFT JOIN areas Areas ON Areas.id = (Onsites.area_id) LEFT JOIN kinds Kinds ON Kinds.id = (Onsites.kind_id) LEFT JOIN tours Tours ON Tours.id = (Onsites.tour_id) LEFT JOIN railways Railways1 ON Railways1.id = (Onsites.railway_id1) LEFT JOIN railways Railways2 ON Railways2.id = (Onsites.railway_id2) LEFT JOIN railways Railways3 ON Railways3.id = (Onsites.railway_id3) LEFT JOIN stations Stations1 ON Stations1.id = (Onsites.station_id1) LEFT JOIN stations Stations2 ON Stations2.id = (Onsites.station_id2) LEFT JOIN stations Stations3 ON Stations3.id = (Onsites.station_id3) WHERE Onsites.id = :c0', 'params' => [ ':c0' => [ [maximum depth reached] ] ], 'defaultTypes' => [ 'Onsites__id' => 'integer', 'Onsites.id' => 'integer', 'id' => 'integer', 'Onsites__name' => 'string', 'Onsites.name' => 'string', 'name' => 'string', 'Onsites__mbAddress' => 'string', 'Onsites.mbAddress' => 'string', 'mbAddress' => 'string', 'Onsites__displayFlg' => 'tinyinteger', 'Onsites.displayFlg' => 'tinyinteger', 'displayFlg' => 'tinyinteger', 'Onsites__statusFlg' => 'tinyinteger', 'Onsites.statusFlg' => 'tinyinteger', 'statusFlg' => 'tinyinteger', 'Onsites__area_id' => 'integer', 'Onsites.area_id' => 'integer', 'area_id' => 'integer', 'Onsites__sectionNo' => 'tinyinteger', 'Onsites.sectionNo' => 'tinyinteger', 'sectionNo' => 'tinyinteger', 'Onsites__kind_id' => 'integer', 'Onsites.kind_id' => 'integer', 'kind_id' => 'integer', 'Onsites__landFlg' => 'tinyinteger', 'Onsites.landFlg' => 'tinyinteger', 'landFlg' => 'tinyinteger', 'Onsites__lifetownFlg' => 'tinyinteger', 'Onsites.lifetownFlg' => 'tinyinteger', 'lifetownFlg' => 'tinyinteger', 'Onsites__newoldFlg' => 'tinyinteger', 'Onsites.newoldFlg' => 'tinyinteger', 'newoldFlg' => 'tinyinteger', 'Onsites__tour_id' => 'integer', 'Onsites.tour_id' => 'integer', 'tour_id' => 'integer', 'Onsites__topDispFlg' => 'tinyinteger', 'Onsites.topDispFlg' => 'tinyinteger', 'topDispFlg' => 'tinyinteger', 'Onsites__recommFlg' => 'tinyinteger', 'Onsites.recommFlg' => 'tinyinteger', 'recommFlg' => 'tinyinteger', 'Onsites__railway_id1' => 'integer', 'Onsites.railway_id1' => 'integer', 'railway_id1' => 'integer', 'Onsites__railway_id2' => 'integer', 'Onsites.railway_id2' => 'integer', 'railway_id2' => 'integer', 'Onsites__railway_id3' => 'integer', 'Onsites.railway_id3' => 'integer', 'railway_id3' => 'integer', 'Onsites__station_id1' => 'integer', 'Onsites.station_id1' => 'integer', 'station_id1' => 'integer', 'Onsites__station_id2' => 'integer', 'Onsites.station_id2' => 'integer', 'station_id2' => 'integer', 'Onsites__station_id3' => 'integer', 'Onsites.station_id3' => 'integer', 'station_id3' => 'integer', 'Onsites__stwalk1' => 'string', 'Onsites.stwalk1' => 'string', 'stwalk1' => 'string', 'Onsites__stwalk2' => 'string', 'Onsites.stwalk2' => 'string', 'stwalk2' => 'string', 'Onsites__stwalk3' => 'string', 'Onsites.stwalk3' => 'string', 'stwalk3' => 'string', 'Onsites__bswalk1' => 'string', 'Onsites.bswalk1' => 'string', 'bswalk1' => 'string', 'Onsites__bswalk2' => 'string', 'Onsites.bswalk2' => 'string', 'bswalk2' => 'string', 'Onsites__bswalk3' => 'string', 'Onsites.bswalk3' => 'string', 'bswalk3' => 'string', 'Onsites__catchCopy' => 'string', 'Onsites.catchCopy' => 'string', 'catchCopy' => 'string', 'Onsites__stationStart' => 'string', 'Onsites.stationStart' => 'string', 'stationStart' => 'string', 'Onsites__stationTo1' => 'string', 'Onsites.stationTo1' => 'string', 'stationTo1' => 'string', 'Onsites__stationTo2' => 'string', 'Onsites.stationTo2' => 'string', 'stationTo2' => 'string', 'Onsites__stationTo3' => 'string', 'Onsites.stationTo3' => 'string', 'stationTo3' => 'string', 'Onsites__stationTo4' => 'string', 'Onsites.stationTo4' => 'string', 'stationTo4' => 'string', 'Onsites__trainTime1' => 'tinyinteger', 'Onsites.trainTime1' => 'tinyinteger', 'trainTime1' => 'tinyinteger', 'Onsites__trainTime2' => 'tinyinteger', 'Onsites.trainTime2' => 'tinyinteger', 'trainTime2' => 'tinyinteger', 'Onsites__trainTime3' => 'tinyinteger', 'Onsites.trainTime3' => 'tinyinteger', 'trainTime3' => 'tinyinteger', 'Onsites__trainTime4' => 'tinyinteger', 'Onsites.trainTime4' => 'tinyinteger', 'trainTime4' => 'tinyinteger', 'Onsites__trainDirect1' => 'tinyinteger', 'Onsites.trainDirect1' => 'tinyinteger', 'trainDirect1' => 'tinyinteger', 'Onsites__trainDirect2' => 'tinyinteger', 'Onsites.trainDirect2' => 'tinyinteger', 'trainDirect2' => 'tinyinteger', 'Onsites__trainDirect3' => 'tinyinteger', 'Onsites.trainDirect3' => 'tinyinteger', 'trainDirect3' => 'tinyinteger', 'Onsites__trainDirect4' => 'tinyinteger', 'Onsites.trainDirect4' => 'tinyinteger', 'trainDirect4' => 'tinyinteger', 'Onsites__trainVia1' => 'string', 'Onsites.trainVia1' => 'string', 'trainVia1' => 'string', 'Onsites__trainVia2' => 'string', 'Onsites.trainVia2' => 'string', 'trainVia2' => 'string', 'Onsites__trainVia3' => 'string', 'Onsites.trainVia3' => 'string', 'trainVia3' => 'string', 'Onsites__trainVia4' => 'string', 'Onsites.trainVia4' => 'string', 'trainVia4' => 'string', 'Onsites__locationFlg' => 'tinyinteger', 'Onsites.locationFlg' => 'tinyinteger', 'locationFlg' => 'tinyinteger', 'Onsites__locationTitle1' => 'string', 'Onsites.locationTitle1' => 'string', 'locationTitle1' => 'string', 'Onsites__locationTitle2' => 'string', 'Onsites.locationTitle2' => 'string', 'locationTitle2' => 'string', 'Onsites__locationTxt1' => 'string', 'Onsites.locationTxt1' => 'string', 'locationTxt1' => 'string', 'Onsites__locationTxt2' => 'string', 'Onsites.locationTxt2' => 'string', 'locationTxt2' => 'string', 'Onsites__locationTxt3' => 'string', 'Onsites.locationTxt3' => 'string', 'locationTxt3' => 'string', 'Onsites__locationTxt4' => 'string', 'Onsites.locationTxt4' => 'string', 'locationTxt4' => 'string', 'Onsites__locationTxt5' => 'string', 'Onsites.locationTxt5' => 'string', 'locationTxt5' => 'string', 'Onsites__locationTxt6' => 'string', 'Onsites.locationTxt6' => 'string', 'locationTxt6' => 'string', 'Onsites__locationTxt7' => 'string', 'Onsites.locationTxt7' => 'string', 'locationTxt7' => 'string', 'Onsites__locationTxt8' => 'string', 'Onsites.locationTxt8' => 'string', 'locationTxt8' => 'string', 'Onsites__locationTxt9' => 'string', 'Onsites.locationTxt9' => 'string', 'locationTxt9' => 'string', 'Onsites__locationTxt10' => 'string', 'Onsites.locationTxt10' => 'string', 'locationTxt10' => 'string', 'Onsites__locationTxt11' => 'string', 'Onsites.locationTxt11' => 'string', 'locationTxt11' => 'string', 'Onsites__locationTxt12' => 'string', 'Onsites.locationTxt12' => 'string', 'locationTxt12' => 'string', 'Onsites__locationTxt13' => 'string', 'Onsites.locationTxt13' => 'string', 'locationTxt13' => 'string', 'Onsites__locationTxt14' => 'string', 'Onsites.locationTxt14' => 'string', 'locationTxt14' => 'string', 'Onsites__locationTxt15' => 'string', 'Onsites.locationTxt15' => 'string', 'locationTxt15' => 'string', 'Onsites__locationTxt16' => 'string', 'Onsites.locationTxt16' => 'string', 'locationTxt16' => 'string', 'Onsites__locationTxt17' => 'string', 'Onsites.locationTxt17' => 'string', 'locationTxt17' => 'string', 'Onsites__locationTxt18' => 'string', 'Onsites.locationTxt18' => 'string', 'locationTxt18' => 'string', 'Onsites__galleryTxt1' => 'string', 'Onsites.galleryTxt1' => 'string', 'galleryTxt1' => 'string', 'Onsites__galleryTxt2' => 'string', 'Onsites.galleryTxt2' => 'string', 'galleryTxt2' => 'string', 'Onsites__galleryTxt3' => 'string', 'Onsites.galleryTxt3' => 'string', 'galleryTxt3' => 'string', 'Onsites__galleryTxt4' => 'string', 'Onsites.galleryTxt4' => 'string', 'galleryTxt4' => 'string', 'Onsites__galleryTxt5' => 'string', 'Onsites.galleryTxt5' => 'string', 'galleryTxt5' => 'string', 'Onsites__galleryTxt6' => 'string', 'Onsites.galleryTxt6' => 'string', 'galleryTxt6' => 'string', 'Onsites__galleryTxt7' => 'string', 'Onsites.galleryTxt7' => 'string', 'galleryTxt7' => 'string', 'Onsites__galleryTxt8' => 'string', 'Onsites.galleryTxt8' => 'string', 'galleryTxt8' => 'string', 'Onsites__galleryTxt9' => 'string', 'Onsites.galleryTxt9' => 'string', 'galleryTxt9' => 'string', 'Onsites__galleryTxt10' => 'string', 'Onsites.galleryTxt10' => 'string', 'galleryTxt10' => 'string', 'Onsites__galleryTxt11' => 'string', 'Onsites.galleryTxt11' => 'string', 'galleryTxt11' => 'string', 'Onsites__galleryTxt12' => 'string', 'Onsites.galleryTxt12' => 'string', 'galleryTxt12' => 'string', 'Onsites__galleryTxt13' => 'string', 'Onsites.galleryTxt13' => 'string', 'galleryTxt13' => 'string', 'Onsites__galleryTxt14' => 'string', 'Onsites.galleryTxt14' => 'string', 'galleryTxt14' => 'string', 'Onsites__galleryTxt15' => 'string', 'Onsites.galleryTxt15' => 'string', 'galleryTxt15' => 'string', 'Onsites__galleryTxt16' => 'string', 'Onsites.galleryTxt16' => 'string', 'galleryTxt16' => 'string', 'Onsites__galleryTxt17' => 'string', 'Onsites.galleryTxt17' => 'string', 'galleryTxt17' => 'string', 'Onsites__galleryTxt18' => 'string', 'Onsites.galleryTxt18' => 'string', 'galleryTxt18' => 'string', 'Onsites__locationTraffic' => 'string', 'Onsites.locationTraffic' => 'string', 'locationTraffic' => 'string', 'Onsites__locationSchool' => 'string', 'Onsites.locationSchool' => 'string', 'locationSchool' => 'string', 'Onsites__locationLife' => 'string', 'Onsites.locationLife' => 'string', 'locationLife' => 'string', 'Onsites__locationOther' => 'string', 'Onsites.locationOther' => 'string', 'locationOther' => 'string', 'Onsites__parthFlg' => 'tinyinteger', 'Onsites.parthFlg' => 'tinyinteger', 'parthFlg' => 'tinyinteger', 'Onsites__parthImgFlg1' => 'tinyinteger', 'Onsites.parthImgFlg1' => 'tinyinteger', 'parthImgFlg1' => 'tinyinteger', 'Onsites__parthImgFlg2' => 'tinyinteger', 'Onsites.parthImgFlg2' => 'tinyinteger', 'parthImgFlg2' => 'tinyinteger', 'Onsites__parthImgFlg3' => 'tinyinteger', 'Onsites.parthImgFlg3' => 'tinyinteger', 'parthImgFlg3' => 'tinyinteger', 'Onsites__parthImgFlg4' => 'tinyinteger', 'Onsites.parthImgFlg4' => 'tinyinteger', 'parthImgFlg4' => 'tinyinteger', 'Onsites__kuwariFlg' => 'tinyinteger', 'Onsites.kuwariFlg' => 'tinyinteger', 'kuwariFlg' => 'tinyinteger', 'Onsites__planFlg' => 'tinyinteger', 'Onsites.planFlg' => 'tinyinteger', 'planFlg' => 'tinyinteger', 'Onsites__outlinePrice' => 'string', 'Onsites.outlinePrice' => 'string', 'outlinePrice' => 'string', 'Onsites__outlinePriceNum' => 'integer', 'Onsites.outlinePriceNum' => 'integer', 'outlinePriceNum' => 'integer', 'Onsites__outlineType' => 'string', 'Onsites.outlineType' => 'string', 'outlineType' => 'string', 'Onsites__outlinePlace' => 'string', 'Onsites.outlinePlace' => 'string', 'outlinePlace' => 'string', 'Onsites__outlineTraffic' => 'string', 'Onsites.outlineTraffic' => 'string', 'outlineTraffic' => 'string', 'Onsites__outlineRight' => 'string', 'Onsites.outlineRight' => 'string', 'outlineRight' => 'string', 'Onsites__outlineSite' => 'string', 'Onsites.outlineSite' => 'string', 'outlineSite' => 'string', 'Onsites__outlineFacility' => 'string', 'Onsites.outlineFacility' => 'string', 'outlineFacility' => 'string', 'Onsites__outlineApproach' => 'string', 'Onsites.outlineApproach' => 'string', 'outlineApproach' => 'string', 'Onsites__outlineCityplan' => 'string', 'Onsites.outlineCityplan' => 'string', 'outlineCityplan' => 'string', 'Onsites__outlineUse1' => 'string', 'Onsites.outlineUse1' => 'string', 'outlineUse1' => 'string', 'Onsites__outlineUse2' => 'string', 'Onsites.outlineUse2' => 'string', 'outlineUse2' => 'string', 'Onsites__outlineAltitude1' => 'string', 'Onsites.outlineAltitude1' => 'string', 'outlineAltitude1' => 'string', 'Onsites__outlineAltitude2' => 'string', 'Onsites.outlineAltitude2' => 'string', 'outlineAltitude2' => 'string', 'Onsites__outlineFire1' => 'string', 'Onsites.outlineFire1' => 'string', 'outlineFire1' => 'string', 'Onsites__outlineFire2' => 'string', 'Onsites.outlineFire2' => 'string', 'outlineFire2' => 'string', 'Onsites__outlineVolume1' => 'string', 'Onsites.outlineVolume1' => 'string', 'outlineVolume1' => 'string', 'Onsites__outlineVolume2' => 'string', 'Onsites.outlineVolume2' => 'string', 'outlineVolume2' => 'string', 'Onsites__outlinePlots' => 'string', 'Onsites.outlinePlots' => 'string', 'outlinePlots' => 'string', 'Onsites__outlineBuldingNo' => 'string', 'Onsites.outlineBuldingNo' => 'string', 'outlineBuldingNo' => 'string', 'Onsites__outlineBuildingArea' => 'string', 'Onsites.outlineBuildingArea' => 'string', 'outlineBuildingArea' => 'string', 'Onsites__outlineConstruction' => 'string', 'Onsites.outlineConstruction' => 'string', 'outlineConstruction' => 'string', 'Onsites__outlineFloorPlan' => 'string', 'Onsites.outlineFloorPlan' => 'string', 'outlineFloorPlan' => 'string', 'Onsites__outlineCompTime' => 'string', 'Onsites.outlineCompTime' => 'string', 'outlineCompTime' => 'string', 'Onsites__outlineDelivTime' => 'string', 'Onsites.outlineDelivTime' => 'string', 'outlineDelivTime' => 'string', 'Onsites__outlineTransForm' => 'string', 'Onsites.outlineTransForm' => 'string', 'outlineTransForm' => 'string', 'Onsites__outlineEquipment' => 'string', 'Onsites.outlineEquipment' => 'string', 'outlineEquipment' => 'string', 'Onsites__outlineComment' => 'string', 'Onsites.outlineComment' => 'string', 'outlineComment' => 'string', 'Onsites__outlineSchool' => 'string', 'Onsites.outlineSchool' => 'string', 'outlineSchool' => 'string', 'Onsites__googleMap' => 'string', 'Onsites.googleMap' => 'string', 'googleMap' => 'string', 'Onsites__memo' => 'string', 'Onsites.memo' => 'string', 'memo' => 'string', 'Onsites__priceFlg' => 'tinyinteger', 'Onsites.priceFlg' => 'tinyinteger', 'priceFlg' => 'tinyinteger', 'Onsites__newFlg' => 'tinyinteger', 'Onsites.newFlg' => 'tinyinteger', 'newFlg' => 'tinyinteger', 'Onsites__lastFlg' => 'tinyinteger', 'Onsites.lastFlg' => 'tinyinteger', 'lastFlg' => 'tinyinteger', 'Onsites__topImgFlg' => 'tinyinteger', 'Onsites.topImgFlg' => 'tinyinteger', 'topImgFlg' => 'tinyinteger', 'Onsites__memberFlg' => 'tinyinteger', 'Onsites.memberFlg' => 'tinyinteger', 'memberFlg' => 'tinyinteger', 'Onsites__deleteFlg' => 'tinyinteger', 'Onsites.deleteFlg' => 'tinyinteger', 'deleteFlg' => 'tinyinteger', 'Onsites__created' => 'datetime', 'Onsites.created' => 'datetime', 'created' => 'datetime', 'Onsites__modified' => 'datetime', 'Onsites.modified' => 'datetime', 'modified' => 'datetime', 'Sites__id' => 'integer', 'Sites.id' => 'integer', 'Sites__onsite_id' => 'integer', 'Sites.onsite_id' => 'integer', 'onsite_id' => 'integer', 'Sites__displayFlg' => 'tinyinteger', 'Sites.displayFlg' => 'tinyinteger', 'Sites__statusFlg' => 'tinyinteger', 'Sites.statusFlg' => 'tinyinteger', 'Sites__name' => 'string', 'Sites.name' => 'string', 'Sites__floor' => 'string', 'Sites.floor' => 'string', 'floor' => 'string', 'Sites__landRights' => 'string', 'Sites.landRights' => 'string', 'landRights' => 'string', 'Sites__landArea' => 'decimal', 'Sites.landArea' => 'decimal', 'landArea' => 'decimal', 'Sites__buildArea' => 'decimal', 'Sites.buildArea' => 'decimal', 'buildArea' => 'decimal', 'Sites__price' => 'decimal', 'Sites.price' => 'decimal', 'price' => 'decimal', 'Sites__PlanImgFlg' => 'tinyinteger', 'Sites.PlanImgFlg' => 'tinyinteger', 'PlanImgFlg' => 'tinyinteger', 'Sites__PlanPdfFlg' => 'tinyinteger', 'Sites.PlanPdfFlg' => 'tinyinteger', 'PlanPdfFlg' => 'tinyinteger', 'Sites__comment' => 'string', 'Sites.comment' => 'string', 'comment' => 'string', 'Sites__memo' => 'string', 'Sites.memo' => 'string', 'Sites__areaCD' => 'integer', 'Sites.areaCD' => 'integer', 'areaCD' => 'integer', 'Sites__lifetownFlg' => 'tinyinteger', 'Sites.lifetownFlg' => 'tinyinteger', 'Sites__created' => 'datetime', 'Sites.created' => 'datetime', 'Sites__modified' => 'datetime', 'Sites.modified' => 'datetime', 'Areas__id' => 'integer', 'Areas.id' => 'integer', 'Areas__areaClass_cd' => 'tinyinteger', 'Areas.areaClass_cd' => 'tinyinteger', 'areaClass_cd' => 'tinyinteger', 'Areas__name' => 'string', 'Areas.name' => 'string', 'Areas__sortPt' => 'smallinteger', 'Areas.sortPt' => 'smallinteger', 'sortPt' => 'smallinteger', 'Areas__editDate' => 'timestamp', 'Areas.editDate' => 'timestamp', 'editDate' => 'timestamp', 'Kinds__id' => 'integer', 'Kinds.id' => 'integer', 'Kinds__name' => 'string', 'Kinds.name' => 'string', 'Kinds__sortPt' => 'smallinteger', 'Kinds.sortPt' => 'smallinteger', 'Kinds__editDate' => 'timestamp', 'Kinds.editDate' => 'timestamp', 'Tours__id' => 'integer', 'Tours.id' => 'integer', 'Tours__name' => 'string', 'Tours.name' => 'string', 'Tours__sortPt' => 'smallinteger', 'Tours.sortPt' => 'smallinteger', 'Tours__category' => 'tinyinteger', 'Tours.category' => 'tinyinteger', 'category' => 'tinyinteger', 'Tours__editDate' => 'timestamp', 'Tours.editDate' => 'timestamp', 'Railways1__id' => 'integer', 'Railways1.id' => 'integer', 'Railways1__name' => 'string', 'Railways1.name' => 'string', 'Railways1__sortPt' => 'integer', 'Railways1.sortPt' => 'integer', 'Railways1__editDate' => 'timestamp', 'Railways1.editDate' => 'timestamp', 'Railways2__id' => 'integer', 'Railways2.id' => 'integer', 'Railways2__name' => 'string', 'Railways2.name' => 'string', 'Railways2__sortPt' => 'integer', 'Railways2.sortPt' => 'integer', 'Railways2__editDate' => 'timestamp', 'Railways2.editDate' => 'timestamp', 'Railways3__id' => 'integer', 'Railways3.id' => 'integer', 'Railways3__name' => 'string', 'Railways3.name' => 'string', 'Railways3__sortPt' => 'integer', 'Railways3.sortPt' => 'integer', 'Railways3__editDate' => 'timestamp', 'Railways3.editDate' => 'timestamp', 'Stations1__id' => 'integer', 'Stations1.id' => 'integer', 'Stations1__name' => 'string', 'Stations1.name' => 'string', 'Stations1__railway_id' => 'integer', 'Stations1.railway_id' => 'integer', 'railway_id' => 'integer', 'Stations1__pref_cd' => 'tinyinteger', 'Stations1.pref_cd' => 'tinyinteger', 'pref_cd' => 'tinyinteger', 'Stations1__sortPt' => 'smallinteger', 'Stations1.sortPt' => 'smallinteger', 'Stations1__editDate' => 'timestamp', 'Stations1.editDate' => 'timestamp', 'Stations2__id' => 'integer', 'Stations2.id' => 'integer', 'Stations2__name' => 'string', 'Stations2.name' => 'string', 'Stations2__railway_id' => 'integer', 'Stations2.railway_id' => 'integer', 'Stations2__pref_cd' => 'tinyinteger', 'Stations2.pref_cd' => 'tinyinteger', 'Stations2__sortPt' => 'smallinteger', 'Stations2.sortPt' => 'smallinteger', 'Stations2__editDate' => 'timestamp', 'Stations2.editDate' => 'timestamp', 'Stations3__id' => 'integer', 'Stations3.id' => 'integer', 'Stations3__name' => 'string', 'Stations3.name' => 'string', 'Stations3__railway_id' => 'integer', 'Stations3.railway_id' => 'integer', 'Stations3__pref_cd' => 'tinyinteger', 'Stations3.pref_cd' => 'tinyinteger', 'Stations3__sortPt' => 'smallinteger', 'Stations3.sortPt' => 'smallinteger', 'Stations3__editDate' => 'timestamp', 'Stations3.editDate' => 'timestamp' ], 'decorators' => (int) 0, 'executed' => true, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [ 'sites' => [[maximum depth reached]], 'Areas' => [[maximum depth reached]], 'Kinds' => [[maximum depth reached]], 'Tours' => [[maximum depth reached]], 'Railways1' => [[maximum depth reached]], 'Railways2' => [[maximum depth reached]], 'Railways3' => [[maximum depth reached]], 'Stations1' => [[maximum depth reached]], 'Stations2' => [[maximum depth reached]], 'Stations3' => [[maximum depth reached]] ], 'matching' => [], 'extraOptions' => [], 'repository' => object(App\Model\Table\OnsitesTable) {} } $area_results = [ (int) 0 => [ 'area_id' => '1', 'name' => '杉並区', 'Ct' => '44', 'CtM' => '17' ], (int) 1 => [ 'area_id' => '2', 'name' => '練馬区', 'Ct' => '24', 'CtM' => '1' ], (int) 2 => [ 'area_id' => '3', 'name' => '中野区', 'Ct' => '7', 'CtM' => '0' ], (int) 3 => [ 'area_id' => '5', 'name' => '世田谷区', 'Ct' => '2', 'CtM' => '0' ], (int) 4 => [ 'area_id' => '8', 'name' => '新宿区', 'Ct' => '2', 'CtM' => '0' ], (int) 5 => [ 'area_id' => '9', 'name' => '豊島区', 'Ct' => '1', 'CtM' => '0' ], (int) 6 => [ 'area_id' => '10', 'name' => '渋谷区', 'Ct' => '1', 'CtM' => '0' ], (int) 7 => [ 'area_id' => '24', 'name' => '武蔵野市', 'Ct' => '3', 'CtM' => '0' ], (int) 8 => [ 'area_id' => '25', 'name' => '三鷹市', 'Ct' => '0', 'CtM' => '1' ], (int) 9 => [ 'area_id' => '28', 'name' => '西東京市', 'Ct' => '3', 'CtM' => '0' ] ] $railway_results = [ (int) 0 => [ 'rway' => '11302', 'name' => 'JR山手線', 'ct' => '3' ], (int) 1 => [ 'rway' => '11312', 'name' => 'JR中央線(快速)', 'ct' => '58' ], (int) 2 => [ 'rway' => '11313', 'name' => 'JR中央・総武線', 'ct' => '9' ], (int) 3 => [ 'rway' => '21001', 'name' => '東武東上線', 'ct' => '2' ], (int) 4 => [ 'rway' => '22001', 'name' => '西武池袋線', 'ct' => '37' ], (int) 5 => [ 'rway' => '22007', 'name' => '西武新宿線', 'ct' => '64' ], (int) 6 => [ 'rway' => '24001', 'name' => '京王線', 'ct' => '10' ], (int) 7 => [ 'rway' => '24006', 'name' => '京王井の頭線', 'ct' => '30' ], (int) 8 => [ 'rway' => '24007', 'name' => '京王新線', 'ct' => '1' ], (int) 9 => [ 'rway' => '25001', 'name' => '小田急線', 'ct' => '2' ], (int) 10 => [ 'rway' => '26003', 'name' => '東急田園都市線', 'ct' => '1' ], (int) 11 => [ 'rway' => '26007', 'name' => '東急世田谷線', 'ct' => '2' ], (int) 12 => [ 'rway' => '28002', 'name' => '東京メトロ丸ノ内線', 'ct' => '24' ], (int) 13 => [ 'rway' => '28004', 'name' => '東京メトロ東西線', 'ct' => '1' ], (int) 14 => [ 'rway' => '28006', 'name' => '東京メトロ有楽町線', 'ct' => '2' ], (int) 15 => [ 'rway' => '28010', 'name' => '東京メトロ副都心線', 'ct' => '5' ], (int) 16 => [ 'rway' => '99301', 'name' => '都営大江戸線', 'ct' => '10' ] ] $OptionCT = [ 'railway' => (int) 19, 'pet' => (int) 9, 'life' => (int) 61, 'space' => (int) 18 ] $user = null $NoList = true $members_total = '19' $dat = [ 'rway' => '99301', 'name' => '都営大江戸線', 'ct' => '10' ] $key = (int) 16 $CtMember = ''include - APP/Template/Element/search_Area_Railway.ctp, line 89 Cake\View\View::_evaluate() - CORE/src/View/View.php, line 1420 Cake\View\View::_render() - CORE/src/View/View.php, line 1381 Cake\View\View::_renderElement() - CORE/src/View/View.php, line 1857 Cake\View\View::element() - CORE/src/View/View.php, line 782 include - APP/Template/Onsites/view.ctp, line 933 Cake\View\View::_evaluate() - CORE/src/View/View.php, line 1420 Cake\View\View::_render() - CORE/src/View/View.php, line 1381 Cake\View\View::render() - CORE/src/View/View.php, line 879 Cake\Controller\Controller::render() - CORE/src/Controller/Controller.php, line 795 Cake\Http\ActionDispatcher::_invoke() - CORE/src/Http/ActionDispatcher.php, line 126 Cake\Http\ActionDispatcher::dispatch() - CORE/src/Http/ActionDispatcher.php, line 94 Cake\Http\BaseApplication::__invoke() - CORE/src/Http/BaseApplication.php, line 234 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Http\Middleware\CsrfProtectionMiddleware::__invoke() - CORE/src/Http/Middleware/CsrfProtectionMiddleware.php, line 120
Warning (2): Invalid argument supplied for foreach() [APP/Template/Element/search_Area_Railway.ctp, line 89]Code Context<?phpforeach($area_results_member as $key => $dat){?>$viewFile = '/data/WWW/rainbow/test.life-hf.co.jp/htdocs/src/Template/Element/search_Area_Railway.ctp' $dataForView = [ 'Onsites' => object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SELECT Onsites.id AS `Onsites__id`, Onsites.name AS `Onsites__name`, Onsites.mbAddress AS `Onsites__mbAddress`, Onsites.displayFlg AS `Onsites__displayFlg`, Onsites.statusFlg AS `Onsites__statusFlg`, Onsites.area_id AS `Onsites__area_id`, Onsites.sectionNo AS `Onsites__sectionNo`, Onsites.kind_id AS `Onsites__kind_id`, Onsites.landFlg AS `Onsites__landFlg`, Onsites.lifetownFlg AS `Onsites__lifetownFlg`, Onsites.newoldFlg AS `Onsites__newoldFlg`, Onsites.tour_id AS `Onsites__tour_id`, Onsites.topDispFlg AS `Onsites__topDispFlg`, Onsites.recommFlg AS `Onsites__recommFlg`, Onsites.railway_id1 AS `Onsites__railway_id1`, Onsites.railway_id2 AS `Onsites__railway_id2`, Onsites.railway_id3 AS `Onsites__railway_id3`, Onsites.station_id1 AS `Onsites__station_id1`, Onsites.station_id2 AS `Onsites__station_id2`, Onsites.station_id3 AS `Onsites__station_id3`, Onsites.stwalk1 AS `Onsites__stwalk1`, Onsites.stwalk2 AS `Onsites__stwalk2`, Onsites.stwalk3 AS `Onsites__stwalk3`, Onsites.bswalk1 AS `Onsites__bswalk1`, Onsites.bswalk2 AS `Onsites__bswalk2`, Onsites.bswalk3 AS `Onsites__bswalk3`, Onsites.catchCopy AS `Onsites__catchCopy`, Onsites.stationStart AS `Onsites__stationStart`, Onsites.stationTo1 AS `Onsites__stationTo1`, Onsites.stationTo2 AS `Onsites__stationTo2`, Onsites.stationTo3 AS `Onsites__stationTo3`, Onsites.stationTo4 AS `Onsites__stationTo4`, Onsites.trainTime1 AS `Onsites__trainTime1`, Onsites.trainTime2 AS `Onsites__trainTime2`, Onsites.trainTime3 AS `Onsites__trainTime3`, Onsites.trainTime4 AS `Onsites__trainTime4`, Onsites.trainDirect1 AS `Onsites__trainDirect1`, Onsites.trainDirect2 AS `Onsites__trainDirect2`, Onsites.trainDirect3 AS `Onsites__trainDirect3`, Onsites.trainDirect4 AS `Onsites__trainDirect4`, Onsites.trainVia1 AS `Onsites__trainVia1`, Onsites.trainVia2 AS `Onsites__trainVia2`, Onsites.trainVia3 AS `Onsites__trainVia3`, Onsites.trainVia4 AS `Onsites__trainVia4`, Onsites.locationFlg AS `Onsites__locationFlg`, Onsites.locationTitle1 AS `Onsites__locationTitle1`, Onsites.locationTitle2 AS `Onsites__locationTitle2`, Onsites.locationTxt1 AS `Onsites__locationTxt1`, Onsites.locationTxt2 AS `Onsites__locationTxt2`, Onsites.locationTxt3 AS `Onsites__locationTxt3`, Onsites.locationTxt4 AS `Onsites__locationTxt4`, Onsites.locationTxt5 AS `Onsites__locationTxt5`, Onsites.locationTxt6 AS `Onsites__locationTxt6`, Onsites.locationTxt7 AS `Onsites__locationTxt7`, Onsites.locationTxt8 AS `Onsites__locationTxt8`, Onsites.locationTxt9 AS `Onsites__locationTxt9`, Onsites.locationTxt10 AS `Onsites__locationTxt10`, Onsites.locationTxt11 AS `Onsites__locationTxt11`, Onsites.locationTxt12 AS `Onsites__locationTxt12`, Onsites.locationTxt13 AS `Onsites__locationTxt13`, Onsites.locationTxt14 AS `Onsites__locationTxt14`, Onsites.locationTxt15 AS `Onsites__locationTxt15`, Onsites.locationTxt16 AS `Onsites__locationTxt16`, Onsites.locationTxt17 AS `Onsites__locationTxt17`, Onsites.locationTxt18 AS `Onsites__locationTxt18`, Onsites.galleryTxt1 AS `Onsites__galleryTxt1`, Onsites.galleryTxt2 AS `Onsites__galleryTxt2`, Onsites.galleryTxt3 AS `Onsites__galleryTxt3`, Onsites.galleryTxt4 AS `Onsites__galleryTxt4`, Onsites.galleryTxt5 AS `Onsites__galleryTxt5`, Onsites.galleryTxt6 AS `Onsites__galleryTxt6`, Onsites.galleryTxt7 AS `Onsites__galleryTxt7`, Onsites.galleryTxt8 AS `Onsites__galleryTxt8`, Onsites.galleryTxt9 AS `Onsites__galleryTxt9`, Onsites.galleryTxt10 AS `Onsites__galleryTxt10`, Onsites.galleryTxt11 AS `Onsites__galleryTxt11`, Onsites.galleryTxt12 AS `Onsites__galleryTxt12`, Onsites.galleryTxt13 AS `Onsites__galleryTxt13`, Onsites.galleryTxt14 AS `Onsites__galleryTxt14`, Onsites.galleryTxt15 AS `Onsites__galleryTxt15`, Onsites.galleryTxt16 AS `Onsites__galleryTxt16`, Onsites.galleryTxt17 AS `Onsites__galleryTxt17`, Onsites.galleryTxt18 AS `Onsites__galleryTxt18`, Onsites.locationTraffic AS `Onsites__locationTraffic`, Onsites.locationSchool AS `Onsites__locationSchool`, Onsites.locationLife AS `Onsites__locationLife`, Onsites.locationOther AS `Onsites__locationOther`, Onsites.parthFlg AS `Onsites__parthFlg`, Onsites.parthImgFlg1 AS `Onsites__parthImgFlg1`, Onsites.parthImgFlg2 AS `Onsites__parthImgFlg2`, Onsites.parthImgFlg3 AS `Onsites__parthImgFlg3`, Onsites.parthImgFlg4 AS `Onsites__parthImgFlg4`, Onsites.kuwariFlg AS `Onsites__kuwariFlg`, Onsites.planFlg AS `Onsites__planFlg`, Onsites.outlinePrice AS `Onsites__outlinePrice`, Onsites.outlinePriceNum AS `Onsites__outlinePriceNum`, Onsites.outlineType AS `Onsites__outlineType`, Onsites.outlinePlace AS `Onsites__outlinePlace`, Onsites.outlineTraffic AS `Onsites__outlineTraffic`, Onsites.outlineRight AS `Onsites__outlineRight`, Onsites.outlineSite AS `Onsites__outlineSite`, Onsites.outlineFacility AS `Onsites__outlineFacility`, Onsites.outlineApproach AS `Onsites__outlineApproach`, Onsites.outlineCityplan AS `Onsites__outlineCityplan`, Onsites.outlineUse1 AS `Onsites__outlineUse1`, Onsites.outlineUse2 AS `Onsites__outlineUse2`, Onsites.outlineAltitude1 AS `Onsites__outlineAltitude1`, Onsites.outlineAltitude2 AS `Onsites__outlineAltitude2`, Onsites.outlineFire1 AS `Onsites__outlineFire1`, Onsites.outlineFire2 AS `Onsites__outlineFire2`, Onsites.outlineVolume1 AS `Onsites__outlineVolume1`, Onsites.outlineVolume2 AS `Onsites__outlineVolume2`, Onsites.outlinePlots AS `Onsites__outlinePlots`, Onsites.outlineBuldingNo AS `Onsites__outlineBuldingNo`, Onsites.outlineBuildingArea AS `Onsites__outlineBuildingArea`, Onsites.outlineConstruction AS `Onsites__outlineConstruction`, Onsites.outlineFloorPlan AS `Onsites__outlineFloorPlan`, Onsites.outlineCompTime AS `Onsites__outlineCompTime`, Onsites.outlineDelivTime AS `Onsites__outlineDelivTime`, Onsites.outlineTransForm AS `Onsites__outlineTransForm`, Onsites.outlineEquipment AS `Onsites__outlineEquipment`, Onsites.outlineComment AS `Onsites__outlineComment`, Onsites.outlineSchool AS `Onsites__outlineSchool`, Onsites.googleMap AS `Onsites__googleMap`, Onsites.memo AS `Onsites__memo`, Onsites.priceFlg AS `Onsites__priceFlg`, Onsites.newFlg AS `Onsites__newFlg`, Onsites.lastFlg AS `Onsites__lastFlg`, Onsites.topImgFlg AS `Onsites__topImgFlg`, Onsites.memberFlg AS `Onsites__memberFlg`, Onsites.deleteFlg AS `Onsites__deleteFlg`, Onsites.created AS `Onsites__created`, Onsites.modified AS `Onsites__modified`, Areas.id AS `Areas__id`, Areas.areaClass_cd AS `Areas__areaClass_cd`, Areas.name AS `Areas__name`, Areas.sortPt AS `Areas__sortPt`, Areas.editDate AS `Areas__editDate`, Kinds.id AS `Kinds__id`, Kinds.name AS `Kinds__name`, Kinds.sortPt AS `Kinds__sortPt`, Kinds.editDate AS `Kinds__editDate`, Tours.id AS `Tours__id`, Tours.name AS `Tours__name`, Tours.sortPt AS `Tours__sortPt`, Tours.category AS `Tours__category`, Tours.editDate AS `Tours__editDate`, Railways1.id AS `Railways1__id`, Railways1.name AS `Railways1__name`, Railways1.sortPt AS `Railways1__sortPt`, Railways1.editDate AS `Railways1__editDate`, Railways2.id AS `Railways2__id`, Railways2.name AS `Railways2__name`, Railways2.sortPt AS `Railways2__sortPt`, Railways2.editDate AS `Railways2__editDate`, Railways3.id AS `Railways3__id`, Railways3.name AS `Railways3__name`, Railways3.sortPt AS `Railways3__sortPt`, Railways3.editDate AS `Railways3__editDate`, Stations1.id AS `Stations1__id`, Stations1.name AS `Stations1__name`, Stations1.railway_id AS `Stations1__railway_id`, Stations1.pref_cd AS `Stations1__pref_cd`, Stations1.sortPt AS `Stations1__sortPt`, Stations1.editDate AS `Stations1__editDate`, Stations2.id AS `Stations2__id`, Stations2.name AS `Stations2__name`, Stations2.railway_id AS `Stations2__railway_id`, Stations2.pref_cd AS `Stations2__pref_cd`, Stations2.sortPt AS `Stations2__sortPt`, Stations2.editDate AS `Stations2__editDate`, Stations3.id AS `Stations3__id`, Stations3.name AS `Stations3__name`, Stations3.railway_id AS `Stations3__railway_id`, Stations3.pref_cd AS `Stations3__pref_cd`, Stations3.sortPt AS `Stations3__sortPt`, Stations3.editDate AS `Stations3__editDate` FROM onsites Onsites LEFT JOIN areas Areas ON Areas.id = (Onsites.area_id) LEFT JOIN kinds Kinds ON Kinds.id = (Onsites.kind_id) LEFT JOIN tours Tours ON Tours.id = (Onsites.tour_id) LEFT JOIN railways Railways1 ON Railways1.id = (Onsites.railway_id1) LEFT JOIN railways Railways2 ON Railways2.id = (Onsites.railway_id2) LEFT JOIN railways Railways3 ON Railways3.id = (Onsites.railway_id3) LEFT JOIN stations Stations1 ON Stations1.id = (Onsites.station_id1) LEFT JOIN stations Stations2 ON Stations2.id = (Onsites.station_id2) LEFT JOIN stations Stations3 ON Stations3.id = (Onsites.station_id3) WHERE Onsites.id = :c0', 'params' => [ [maximum depth reached] ], 'defaultTypes' => [ [maximum depth reached] ], 'decorators' => (int) 0, 'executed' => true, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [ [maximum depth reached] ], 'matching' => [[maximum depth reached]], 'extraOptions' => [[maximum depth reached]], 'repository' => object(App\Model\Table\OnsitesTable) {} }, 'area_results' => [ (int) 0 => [ 'area_id' => '1', 'name' => '杉並区', 'Ct' => '44', 'CtM' => '17' ], (int) 1 => [ 'area_id' => '2', 'name' => '練馬区', 'Ct' => '24', 'CtM' => '1' ], (int) 2 => [ 'area_id' => '3', 'name' => '中野区', 'Ct' => '7', 'CtM' => '0' ], (int) 3 => [ 'area_id' => '5', 'name' => '世田谷区', 'Ct' => '2', 'CtM' => '0' ], (int) 4 => [ 'area_id' => '8', 'name' => '新宿区', 'Ct' => '2', 'CtM' => '0' ], (int) 5 => [ 'area_id' => '9', 'name' => '豊島区', 'Ct' => '1', 'CtM' => '0' ], (int) 6 => [ 'area_id' => '10', 'name' => '渋谷区', 'Ct' => '1', 'CtM' => '0' ], (int) 7 => [ 'area_id' => '24', 'name' => '武蔵野市', 'Ct' => '3', 'CtM' => '0' ], (int) 8 => [ 'area_id' => '25', 'name' => '三鷹市', 'Ct' => '0', 'CtM' => '1' ], (int) 9 => [ 'area_id' => '28', 'name' => '西東京市', 'Ct' => '3', 'CtM' => '0' ] ], 'railway_results' => [ (int) 0 => [ 'rway' => '11302', 'name' => 'JR山手線', 'ct' => '3' ], (int) 1 => [ 'rway' => '11312', 'name' => 'JR中央線(快速)', 'ct' => '58' ], (int) 2 => [ 'rway' => '11313', 'name' => 'JR中央・総武線', 'ct' => '9' ], (int) 3 => [ 'rway' => '21001', 'name' => '東武東上線', 'ct' => '2' ], (int) 4 => [ 'rway' => '22001', 'name' => '西武池袋線', 'ct' => '37' ], (int) 5 => [ 'rway' => '22007', 'name' => '西武新宿線', 'ct' => '64' ], (int) 6 => [ 'rway' => '24001', 'name' => '京王線', 'ct' => '10' ], (int) 7 => [ 'rway' => '24006', 'name' => '京王井の頭線', 'ct' => '30' ], (int) 8 => [ 'rway' => '24007', 'name' => '京王新線', 'ct' => '1' ], (int) 9 => [ 'rway' => '25001', 'name' => '小田急線', 'ct' => '2' ], (int) 10 => [ 'rway' => '26003', 'name' => '東急田園都市線', 'ct' => '1' ], (int) 11 => [ 'rway' => '26007', 'name' => '東急世田谷線', 'ct' => '2' ], (int) 12 => [ 'rway' => '28002', 'name' => '東京メトロ丸ノ内線', 'ct' => '24' ], (int) 13 => [ 'rway' => '28004', 'name' => '東京メトロ東西線', 'ct' => '1' ], (int) 14 => [ 'rway' => '28006', 'name' => '東京メトロ有楽町線', 'ct' => '2' ], (int) 15 => [ 'rway' => '28010', 'name' => '東京メトロ副都心線', 'ct' => '5' ], (int) 16 => [ 'rway' => '99301', 'name' => '都営大江戸線', 'ct' => '10' ] ], 'OptionCT' => [ 'railway' => (int) 19, 'pet' => (int) 9, 'life' => (int) 61, 'space' => (int) 18 ], 'user' => null, 'NoList' => true, 'members_total' => '19' ] $Onsites = object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SELECT Onsites.id AS `Onsites__id`, Onsites.name AS `Onsites__name`, Onsites.mbAddress AS `Onsites__mbAddress`, Onsites.displayFlg AS `Onsites__displayFlg`, Onsites.statusFlg AS `Onsites__statusFlg`, Onsites.area_id AS `Onsites__area_id`, Onsites.sectionNo AS `Onsites__sectionNo`, Onsites.kind_id AS `Onsites__kind_id`, Onsites.landFlg AS `Onsites__landFlg`, Onsites.lifetownFlg AS `Onsites__lifetownFlg`, Onsites.newoldFlg AS `Onsites__newoldFlg`, Onsites.tour_id AS `Onsites__tour_id`, Onsites.topDispFlg AS `Onsites__topDispFlg`, Onsites.recommFlg AS `Onsites__recommFlg`, Onsites.railway_id1 AS `Onsites__railway_id1`, Onsites.railway_id2 AS `Onsites__railway_id2`, Onsites.railway_id3 AS `Onsites__railway_id3`, Onsites.station_id1 AS `Onsites__station_id1`, Onsites.station_id2 AS `Onsites__station_id2`, Onsites.station_id3 AS `Onsites__station_id3`, Onsites.stwalk1 AS `Onsites__stwalk1`, Onsites.stwalk2 AS `Onsites__stwalk2`, Onsites.stwalk3 AS `Onsites__stwalk3`, Onsites.bswalk1 AS `Onsites__bswalk1`, Onsites.bswalk2 AS `Onsites__bswalk2`, Onsites.bswalk3 AS `Onsites__bswalk3`, Onsites.catchCopy AS `Onsites__catchCopy`, Onsites.stationStart AS `Onsites__stationStart`, Onsites.stationTo1 AS `Onsites__stationTo1`, Onsites.stationTo2 AS `Onsites__stationTo2`, Onsites.stationTo3 AS `Onsites__stationTo3`, Onsites.stationTo4 AS `Onsites__stationTo4`, Onsites.trainTime1 AS `Onsites__trainTime1`, Onsites.trainTime2 AS `Onsites__trainTime2`, Onsites.trainTime3 AS `Onsites__trainTime3`, Onsites.trainTime4 AS `Onsites__trainTime4`, Onsites.trainDirect1 AS `Onsites__trainDirect1`, Onsites.trainDirect2 AS `Onsites__trainDirect2`, Onsites.trainDirect3 AS `Onsites__trainDirect3`, Onsites.trainDirect4 AS `Onsites__trainDirect4`, Onsites.trainVia1 AS `Onsites__trainVia1`, Onsites.trainVia2 AS `Onsites__trainVia2`, Onsites.trainVia3 AS `Onsites__trainVia3`, Onsites.trainVia4 AS `Onsites__trainVia4`, Onsites.locationFlg AS `Onsites__locationFlg`, Onsites.locationTitle1 AS `Onsites__locationTitle1`, Onsites.locationTitle2 AS `Onsites__locationTitle2`, Onsites.locationTxt1 AS `Onsites__locationTxt1`, Onsites.locationTxt2 AS `Onsites__locationTxt2`, Onsites.locationTxt3 AS `Onsites__locationTxt3`, Onsites.locationTxt4 AS `Onsites__locationTxt4`, Onsites.locationTxt5 AS `Onsites__locationTxt5`, Onsites.locationTxt6 AS `Onsites__locationTxt6`, Onsites.locationTxt7 AS `Onsites__locationTxt7`, Onsites.locationTxt8 AS `Onsites__locationTxt8`, Onsites.locationTxt9 AS `Onsites__locationTxt9`, Onsites.locationTxt10 AS `Onsites__locationTxt10`, Onsites.locationTxt11 AS `Onsites__locationTxt11`, Onsites.locationTxt12 AS `Onsites__locationTxt12`, Onsites.locationTxt13 AS `Onsites__locationTxt13`, Onsites.locationTxt14 AS `Onsites__locationTxt14`, Onsites.locationTxt15 AS `Onsites__locationTxt15`, Onsites.locationTxt16 AS `Onsites__locationTxt16`, Onsites.locationTxt17 AS `Onsites__locationTxt17`, Onsites.locationTxt18 AS `Onsites__locationTxt18`, Onsites.galleryTxt1 AS `Onsites__galleryTxt1`, Onsites.galleryTxt2 AS `Onsites__galleryTxt2`, Onsites.galleryTxt3 AS `Onsites__galleryTxt3`, Onsites.galleryTxt4 AS `Onsites__galleryTxt4`, Onsites.galleryTxt5 AS `Onsites__galleryTxt5`, Onsites.galleryTxt6 AS `Onsites__galleryTxt6`, Onsites.galleryTxt7 AS `Onsites__galleryTxt7`, Onsites.galleryTxt8 AS `Onsites__galleryTxt8`, Onsites.galleryTxt9 AS `Onsites__galleryTxt9`, Onsites.galleryTxt10 AS `Onsites__galleryTxt10`, Onsites.galleryTxt11 AS `Onsites__galleryTxt11`, Onsites.galleryTxt12 AS `Onsites__galleryTxt12`, Onsites.galleryTxt13 AS `Onsites__galleryTxt13`, Onsites.galleryTxt14 AS `Onsites__galleryTxt14`, Onsites.galleryTxt15 AS `Onsites__galleryTxt15`, Onsites.galleryTxt16 AS `Onsites__galleryTxt16`, Onsites.galleryTxt17 AS `Onsites__galleryTxt17`, Onsites.galleryTxt18 AS `Onsites__galleryTxt18`, Onsites.locationTraffic AS `Onsites__locationTraffic`, Onsites.locationSchool AS `Onsites__locationSchool`, Onsites.locationLife AS `Onsites__locationLife`, Onsites.locationOther AS `Onsites__locationOther`, Onsites.parthFlg AS `Onsites__parthFlg`, Onsites.parthImgFlg1 AS `Onsites__parthImgFlg1`, Onsites.parthImgFlg2 AS `Onsites__parthImgFlg2`, Onsites.parthImgFlg3 AS `Onsites__parthImgFlg3`, Onsites.parthImgFlg4 AS `Onsites__parthImgFlg4`, Onsites.kuwariFlg AS `Onsites__kuwariFlg`, Onsites.planFlg AS `Onsites__planFlg`, Onsites.outlinePrice AS `Onsites__outlinePrice`, Onsites.outlinePriceNum AS `Onsites__outlinePriceNum`, Onsites.outlineType AS `Onsites__outlineType`, Onsites.outlinePlace AS `Onsites__outlinePlace`, Onsites.outlineTraffic AS `Onsites__outlineTraffic`, Onsites.outlineRight AS `Onsites__outlineRight`, Onsites.outlineSite AS `Onsites__outlineSite`, Onsites.outlineFacility AS `Onsites__outlineFacility`, Onsites.outlineApproach AS `Onsites__outlineApproach`, Onsites.outlineCityplan AS `Onsites__outlineCityplan`, Onsites.outlineUse1 AS `Onsites__outlineUse1`, Onsites.outlineUse2 AS `Onsites__outlineUse2`, Onsites.outlineAltitude1 AS `Onsites__outlineAltitude1`, Onsites.outlineAltitude2 AS `Onsites__outlineAltitude2`, Onsites.outlineFire1 AS `Onsites__outlineFire1`, Onsites.outlineFire2 AS `Onsites__outlineFire2`, Onsites.outlineVolume1 AS `Onsites__outlineVolume1`, Onsites.outlineVolume2 AS `Onsites__outlineVolume2`, Onsites.outlinePlots AS `Onsites__outlinePlots`, Onsites.outlineBuldingNo AS `Onsites__outlineBuldingNo`, Onsites.outlineBuildingArea AS `Onsites__outlineBuildingArea`, Onsites.outlineConstruction AS `Onsites__outlineConstruction`, Onsites.outlineFloorPlan AS `Onsites__outlineFloorPlan`, Onsites.outlineCompTime AS `Onsites__outlineCompTime`, Onsites.outlineDelivTime AS `Onsites__outlineDelivTime`, Onsites.outlineTransForm AS `Onsites__outlineTransForm`, Onsites.outlineEquipment AS `Onsites__outlineEquipment`, Onsites.outlineComment AS `Onsites__outlineComment`, Onsites.outlineSchool AS `Onsites__outlineSchool`, Onsites.googleMap AS `Onsites__googleMap`, Onsites.memo AS `Onsites__memo`, Onsites.priceFlg AS `Onsites__priceFlg`, Onsites.newFlg AS `Onsites__newFlg`, Onsites.lastFlg AS `Onsites__lastFlg`, Onsites.topImgFlg AS `Onsites__topImgFlg`, Onsites.memberFlg AS `Onsites__memberFlg`, Onsites.deleteFlg AS `Onsites__deleteFlg`, Onsites.created AS `Onsites__created`, Onsites.modified AS `Onsites__modified`, Areas.id AS `Areas__id`, Areas.areaClass_cd AS `Areas__areaClass_cd`, Areas.name AS `Areas__name`, Areas.sortPt AS `Areas__sortPt`, Areas.editDate AS `Areas__editDate`, Kinds.id AS `Kinds__id`, Kinds.name AS `Kinds__name`, Kinds.sortPt AS `Kinds__sortPt`, Kinds.editDate AS `Kinds__editDate`, Tours.id AS `Tours__id`, Tours.name AS `Tours__name`, Tours.sortPt AS `Tours__sortPt`, Tours.category AS `Tours__category`, Tours.editDate AS `Tours__editDate`, Railways1.id AS `Railways1__id`, Railways1.name AS `Railways1__name`, Railways1.sortPt AS `Railways1__sortPt`, Railways1.editDate AS `Railways1__editDate`, Railways2.id AS `Railways2__id`, Railways2.name AS `Railways2__name`, Railways2.sortPt AS `Railways2__sortPt`, Railways2.editDate AS `Railways2__editDate`, Railways3.id AS `Railways3__id`, Railways3.name AS `Railways3__name`, Railways3.sortPt AS `Railways3__sortPt`, Railways3.editDate AS `Railways3__editDate`, Stations1.id AS `Stations1__id`, Stations1.name AS `Stations1__name`, Stations1.railway_id AS `Stations1__railway_id`, Stations1.pref_cd AS `Stations1__pref_cd`, Stations1.sortPt AS `Stations1__sortPt`, Stations1.editDate AS `Stations1__editDate`, Stations2.id AS `Stations2__id`, Stations2.name AS `Stations2__name`, Stations2.railway_id AS `Stations2__railway_id`, Stations2.pref_cd AS `Stations2__pref_cd`, Stations2.sortPt AS `Stations2__sortPt`, Stations2.editDate AS `Stations2__editDate`, Stations3.id AS `Stations3__id`, Stations3.name AS `Stations3__name`, Stations3.railway_id AS `Stations3__railway_id`, Stations3.pref_cd AS `Stations3__pref_cd`, Stations3.sortPt AS `Stations3__sortPt`, Stations3.editDate AS `Stations3__editDate` FROM onsites Onsites LEFT JOIN areas Areas ON Areas.id = (Onsites.area_id) LEFT JOIN kinds Kinds ON Kinds.id = (Onsites.kind_id) LEFT JOIN tours Tours ON Tours.id = (Onsites.tour_id) LEFT JOIN railways Railways1 ON Railways1.id = (Onsites.railway_id1) LEFT JOIN railways Railways2 ON Railways2.id = (Onsites.railway_id2) LEFT JOIN railways Railways3 ON Railways3.id = (Onsites.railway_id3) LEFT JOIN stations Stations1 ON Stations1.id = (Onsites.station_id1) LEFT JOIN stations Stations2 ON Stations2.id = (Onsites.station_id2) LEFT JOIN stations Stations3 ON Stations3.id = (Onsites.station_id3) WHERE Onsites.id = :c0', 'params' => [ ':c0' => [ [maximum depth reached] ] ], 'defaultTypes' => [ 'Onsites__id' => 'integer', 'Onsites.id' => 'integer', 'id' => 'integer', 'Onsites__name' => 'string', 'Onsites.name' => 'string', 'name' => 'string', 'Onsites__mbAddress' => 'string', 'Onsites.mbAddress' => 'string', 'mbAddress' => 'string', 'Onsites__displayFlg' => 'tinyinteger', 'Onsites.displayFlg' => 'tinyinteger', 'displayFlg' => 'tinyinteger', 'Onsites__statusFlg' => 'tinyinteger', 'Onsites.statusFlg' => 'tinyinteger', 'statusFlg' => 'tinyinteger', 'Onsites__area_id' => 'integer', 'Onsites.area_id' => 'integer', 'area_id' => 'integer', 'Onsites__sectionNo' => 'tinyinteger', 'Onsites.sectionNo' => 'tinyinteger', 'sectionNo' => 'tinyinteger', 'Onsites__kind_id' => 'integer', 'Onsites.kind_id' => 'integer', 'kind_id' => 'integer', 'Onsites__landFlg' => 'tinyinteger', 'Onsites.landFlg' => 'tinyinteger', 'landFlg' => 'tinyinteger', 'Onsites__lifetownFlg' => 'tinyinteger', 'Onsites.lifetownFlg' => 'tinyinteger', 'lifetownFlg' => 'tinyinteger', 'Onsites__newoldFlg' => 'tinyinteger', 'Onsites.newoldFlg' => 'tinyinteger', 'newoldFlg' => 'tinyinteger', 'Onsites__tour_id' => 'integer', 'Onsites.tour_id' => 'integer', 'tour_id' => 'integer', 'Onsites__topDispFlg' => 'tinyinteger', 'Onsites.topDispFlg' => 'tinyinteger', 'topDispFlg' => 'tinyinteger', 'Onsites__recommFlg' => 'tinyinteger', 'Onsites.recommFlg' => 'tinyinteger', 'recommFlg' => 'tinyinteger', 'Onsites__railway_id1' => 'integer', 'Onsites.railway_id1' => 'integer', 'railway_id1' => 'integer', 'Onsites__railway_id2' => 'integer', 'Onsites.railway_id2' => 'integer', 'railway_id2' => 'integer', 'Onsites__railway_id3' => 'integer', 'Onsites.railway_id3' => 'integer', 'railway_id3' => 'integer', 'Onsites__station_id1' => 'integer', 'Onsites.station_id1' => 'integer', 'station_id1' => 'integer', 'Onsites__station_id2' => 'integer', 'Onsites.station_id2' => 'integer', 'station_id2' => 'integer', 'Onsites__station_id3' => 'integer', 'Onsites.station_id3' => 'integer', 'station_id3' => 'integer', 'Onsites__stwalk1' => 'string', 'Onsites.stwalk1' => 'string', 'stwalk1' => 'string', 'Onsites__stwalk2' => 'string', 'Onsites.stwalk2' => 'string', 'stwalk2' => 'string', 'Onsites__stwalk3' => 'string', 'Onsites.stwalk3' => 'string', 'stwalk3' => 'string', 'Onsites__bswalk1' => 'string', 'Onsites.bswalk1' => 'string', 'bswalk1' => 'string', 'Onsites__bswalk2' => 'string', 'Onsites.bswalk2' => 'string', 'bswalk2' => 'string', 'Onsites__bswalk3' => 'string', 'Onsites.bswalk3' => 'string', 'bswalk3' => 'string', 'Onsites__catchCopy' => 'string', 'Onsites.catchCopy' => 'string', 'catchCopy' => 'string', 'Onsites__stationStart' => 'string', 'Onsites.stationStart' => 'string', 'stationStart' => 'string', 'Onsites__stationTo1' => 'string', 'Onsites.stationTo1' => 'string', 'stationTo1' => 'string', 'Onsites__stationTo2' => 'string', 'Onsites.stationTo2' => 'string', 'stationTo2' => 'string', 'Onsites__stationTo3' => 'string', 'Onsites.stationTo3' => 'string', 'stationTo3' => 'string', 'Onsites__stationTo4' => 'string', 'Onsites.stationTo4' => 'string', 'stationTo4' => 'string', 'Onsites__trainTime1' => 'tinyinteger', 'Onsites.trainTime1' => 'tinyinteger', 'trainTime1' => 'tinyinteger', 'Onsites__trainTime2' => 'tinyinteger', 'Onsites.trainTime2' => 'tinyinteger', 'trainTime2' => 'tinyinteger', 'Onsites__trainTime3' => 'tinyinteger', 'Onsites.trainTime3' => 'tinyinteger', 'trainTime3' => 'tinyinteger', 'Onsites__trainTime4' => 'tinyinteger', 'Onsites.trainTime4' => 'tinyinteger', 'trainTime4' => 'tinyinteger', 'Onsites__trainDirect1' => 'tinyinteger', 'Onsites.trainDirect1' => 'tinyinteger', 'trainDirect1' => 'tinyinteger', 'Onsites__trainDirect2' => 'tinyinteger', 'Onsites.trainDirect2' => 'tinyinteger', 'trainDirect2' => 'tinyinteger', 'Onsites__trainDirect3' => 'tinyinteger', 'Onsites.trainDirect3' => 'tinyinteger', 'trainDirect3' => 'tinyinteger', 'Onsites__trainDirect4' => 'tinyinteger', 'Onsites.trainDirect4' => 'tinyinteger', 'trainDirect4' => 'tinyinteger', 'Onsites__trainVia1' => 'string', 'Onsites.trainVia1' => 'string', 'trainVia1' => 'string', 'Onsites__trainVia2' => 'string', 'Onsites.trainVia2' => 'string', 'trainVia2' => 'string', 'Onsites__trainVia3' => 'string', 'Onsites.trainVia3' => 'string', 'trainVia3' => 'string', 'Onsites__trainVia4' => 'string', 'Onsites.trainVia4' => 'string', 'trainVia4' => 'string', 'Onsites__locationFlg' => 'tinyinteger', 'Onsites.locationFlg' => 'tinyinteger', 'locationFlg' => 'tinyinteger', 'Onsites__locationTitle1' => 'string', 'Onsites.locationTitle1' => 'string', 'locationTitle1' => 'string', 'Onsites__locationTitle2' => 'string', 'Onsites.locationTitle2' => 'string', 'locationTitle2' => 'string', 'Onsites__locationTxt1' => 'string', 'Onsites.locationTxt1' => 'string', 'locationTxt1' => 'string', 'Onsites__locationTxt2' => 'string', 'Onsites.locationTxt2' => 'string', 'locationTxt2' => 'string', 'Onsites__locationTxt3' => 'string', 'Onsites.locationTxt3' => 'string', 'locationTxt3' => 'string', 'Onsites__locationTxt4' => 'string', 'Onsites.locationTxt4' => 'string', 'locationTxt4' => 'string', 'Onsites__locationTxt5' => 'string', 'Onsites.locationTxt5' => 'string', 'locationTxt5' => 'string', 'Onsites__locationTxt6' => 'string', 'Onsites.locationTxt6' => 'string', 'locationTxt6' => 'string', 'Onsites__locationTxt7' => 'string', 'Onsites.locationTxt7' => 'string', 'locationTxt7' => 'string', 'Onsites__locationTxt8' => 'string', 'Onsites.locationTxt8' => 'string', 'locationTxt8' => 'string', 'Onsites__locationTxt9' => 'string', 'Onsites.locationTxt9' => 'string', 'locationTxt9' => 'string', 'Onsites__locationTxt10' => 'string', 'Onsites.locationTxt10' => 'string', 'locationTxt10' => 'string', 'Onsites__locationTxt11' => 'string', 'Onsites.locationTxt11' => 'string', 'locationTxt11' => 'string', 'Onsites__locationTxt12' => 'string', 'Onsites.locationTxt12' => 'string', 'locationTxt12' => 'string', 'Onsites__locationTxt13' => 'string', 'Onsites.locationTxt13' => 'string', 'locationTxt13' => 'string', 'Onsites__locationTxt14' => 'string', 'Onsites.locationTxt14' => 'string', 'locationTxt14' => 'string', 'Onsites__locationTxt15' => 'string', 'Onsites.locationTxt15' => 'string', 'locationTxt15' => 'string', 'Onsites__locationTxt16' => 'string', 'Onsites.locationTxt16' => 'string', 'locationTxt16' => 'string', 'Onsites__locationTxt17' => 'string', 'Onsites.locationTxt17' => 'string', 'locationTxt17' => 'string', 'Onsites__locationTxt18' => 'string', 'Onsites.locationTxt18' => 'string', 'locationTxt18' => 'string', 'Onsites__galleryTxt1' => 'string', 'Onsites.galleryTxt1' => 'string', 'galleryTxt1' => 'string', 'Onsites__galleryTxt2' => 'string', 'Onsites.galleryTxt2' => 'string', 'galleryTxt2' => 'string', 'Onsites__galleryTxt3' => 'string', 'Onsites.galleryTxt3' => 'string', 'galleryTxt3' => 'string', 'Onsites__galleryTxt4' => 'string', 'Onsites.galleryTxt4' => 'string', 'galleryTxt4' => 'string', 'Onsites__galleryTxt5' => 'string', 'Onsites.galleryTxt5' => 'string', 'galleryTxt5' => 'string', 'Onsites__galleryTxt6' => 'string', 'Onsites.galleryTxt6' => 'string', 'galleryTxt6' => 'string', 'Onsites__galleryTxt7' => 'string', 'Onsites.galleryTxt7' => 'string', 'galleryTxt7' => 'string', 'Onsites__galleryTxt8' => 'string', 'Onsites.galleryTxt8' => 'string', 'galleryTxt8' => 'string', 'Onsites__galleryTxt9' => 'string', 'Onsites.galleryTxt9' => 'string', 'galleryTxt9' => 'string', 'Onsites__galleryTxt10' => 'string', 'Onsites.galleryTxt10' => 'string', 'galleryTxt10' => 'string', 'Onsites__galleryTxt11' => 'string', 'Onsites.galleryTxt11' => 'string', 'galleryTxt11' => 'string', 'Onsites__galleryTxt12' => 'string', 'Onsites.galleryTxt12' => 'string', 'galleryTxt12' => 'string', 'Onsites__galleryTxt13' => 'string', 'Onsites.galleryTxt13' => 'string', 'galleryTxt13' => 'string', 'Onsites__galleryTxt14' => 'string', 'Onsites.galleryTxt14' => 'string', 'galleryTxt14' => 'string', 'Onsites__galleryTxt15' => 'string', 'Onsites.galleryTxt15' => 'string', 'galleryTxt15' => 'string', 'Onsites__galleryTxt16' => 'string', 'Onsites.galleryTxt16' => 'string', 'galleryTxt16' => 'string', 'Onsites__galleryTxt17' => 'string', 'Onsites.galleryTxt17' => 'string', 'galleryTxt17' => 'string', 'Onsites__galleryTxt18' => 'string', 'Onsites.galleryTxt18' => 'string', 'galleryTxt18' => 'string', 'Onsites__locationTraffic' => 'string', 'Onsites.locationTraffic' => 'string', 'locationTraffic' => 'string', 'Onsites__locationSchool' => 'string', 'Onsites.locationSchool' => 'string', 'locationSchool' => 'string', 'Onsites__locationLife' => 'string', 'Onsites.locationLife' => 'string', 'locationLife' => 'string', 'Onsites__locationOther' => 'string', 'Onsites.locationOther' => 'string', 'locationOther' => 'string', 'Onsites__parthFlg' => 'tinyinteger', 'Onsites.parthFlg' => 'tinyinteger', 'parthFlg' => 'tinyinteger', 'Onsites__parthImgFlg1' => 'tinyinteger', 'Onsites.parthImgFlg1' => 'tinyinteger', 'parthImgFlg1' => 'tinyinteger', 'Onsites__parthImgFlg2' => 'tinyinteger', 'Onsites.parthImgFlg2' => 'tinyinteger', 'parthImgFlg2' => 'tinyinteger', 'Onsites__parthImgFlg3' => 'tinyinteger', 'Onsites.parthImgFlg3' => 'tinyinteger', 'parthImgFlg3' => 'tinyinteger', 'Onsites__parthImgFlg4' => 'tinyinteger', 'Onsites.parthImgFlg4' => 'tinyinteger', 'parthImgFlg4' => 'tinyinteger', 'Onsites__kuwariFlg' => 'tinyinteger', 'Onsites.kuwariFlg' => 'tinyinteger', 'kuwariFlg' => 'tinyinteger', 'Onsites__planFlg' => 'tinyinteger', 'Onsites.planFlg' => 'tinyinteger', 'planFlg' => 'tinyinteger', 'Onsites__outlinePrice' => 'string', 'Onsites.outlinePrice' => 'string', 'outlinePrice' => 'string', 'Onsites__outlinePriceNum' => 'integer', 'Onsites.outlinePriceNum' => 'integer', 'outlinePriceNum' => 'integer', 'Onsites__outlineType' => 'string', 'Onsites.outlineType' => 'string', 'outlineType' => 'string', 'Onsites__outlinePlace' => 'string', 'Onsites.outlinePlace' => 'string', 'outlinePlace' => 'string', 'Onsites__outlineTraffic' => 'string', 'Onsites.outlineTraffic' => 'string', 'outlineTraffic' => 'string', 'Onsites__outlineRight' => 'string', 'Onsites.outlineRight' => 'string', 'outlineRight' => 'string', 'Onsites__outlineSite' => 'string', 'Onsites.outlineSite' => 'string', 'outlineSite' => 'string', 'Onsites__outlineFacility' => 'string', 'Onsites.outlineFacility' => 'string', 'outlineFacility' => 'string', 'Onsites__outlineApproach' => 'string', 'Onsites.outlineApproach' => 'string', 'outlineApproach' => 'string', 'Onsites__outlineCityplan' => 'string', 'Onsites.outlineCityplan' => 'string', 'outlineCityplan' => 'string', 'Onsites__outlineUse1' => 'string', 'Onsites.outlineUse1' => 'string', 'outlineUse1' => 'string', 'Onsites__outlineUse2' => 'string', 'Onsites.outlineUse2' => 'string', 'outlineUse2' => 'string', 'Onsites__outlineAltitude1' => 'string', 'Onsites.outlineAltitude1' => 'string', 'outlineAltitude1' => 'string', 'Onsites__outlineAltitude2' => 'string', 'Onsites.outlineAltitude2' => 'string', 'outlineAltitude2' => 'string', 'Onsites__outlineFire1' => 'string', 'Onsites.outlineFire1' => 'string', 'outlineFire1' => 'string', 'Onsites__outlineFire2' => 'string', 'Onsites.outlineFire2' => 'string', 'outlineFire2' => 'string', 'Onsites__outlineVolume1' => 'string', 'Onsites.outlineVolume1' => 'string', 'outlineVolume1' => 'string', 'Onsites__outlineVolume2' => 'string', 'Onsites.outlineVolume2' => 'string', 'outlineVolume2' => 'string', 'Onsites__outlinePlots' => 'string', 'Onsites.outlinePlots' => 'string', 'outlinePlots' => 'string', 'Onsites__outlineBuldingNo' => 'string', 'Onsites.outlineBuldingNo' => 'string', 'outlineBuldingNo' => 'string', 'Onsites__outlineBuildingArea' => 'string', 'Onsites.outlineBuildingArea' => 'string', 'outlineBuildingArea' => 'string', 'Onsites__outlineConstruction' => 'string', 'Onsites.outlineConstruction' => 'string', 'outlineConstruction' => 'string', 'Onsites__outlineFloorPlan' => 'string', 'Onsites.outlineFloorPlan' => 'string', 'outlineFloorPlan' => 'string', 'Onsites__outlineCompTime' => 'string', 'Onsites.outlineCompTime' => 'string', 'outlineCompTime' => 'string', 'Onsites__outlineDelivTime' => 'string', 'Onsites.outlineDelivTime' => 'string', 'outlineDelivTime' => 'string', 'Onsites__outlineTransForm' => 'string', 'Onsites.outlineTransForm' => 'string', 'outlineTransForm' => 'string', 'Onsites__outlineEquipment' => 'string', 'Onsites.outlineEquipment' => 'string', 'outlineEquipment' => 'string', 'Onsites__outlineComment' => 'string', 'Onsites.outlineComment' => 'string', 'outlineComment' => 'string', 'Onsites__outlineSchool' => 'string', 'Onsites.outlineSchool' => 'string', 'outlineSchool' => 'string', 'Onsites__googleMap' => 'string', 'Onsites.googleMap' => 'string', 'googleMap' => 'string', 'Onsites__memo' => 'string', 'Onsites.memo' => 'string', 'memo' => 'string', 'Onsites__priceFlg' => 'tinyinteger', 'Onsites.priceFlg' => 'tinyinteger', 'priceFlg' => 'tinyinteger', 'Onsites__newFlg' => 'tinyinteger', 'Onsites.newFlg' => 'tinyinteger', 'newFlg' => 'tinyinteger', 'Onsites__lastFlg' => 'tinyinteger', 'Onsites.lastFlg' => 'tinyinteger', 'lastFlg' => 'tinyinteger', 'Onsites__topImgFlg' => 'tinyinteger', 'Onsites.topImgFlg' => 'tinyinteger', 'topImgFlg' => 'tinyinteger', 'Onsites__memberFlg' => 'tinyinteger', 'Onsites.memberFlg' => 'tinyinteger', 'memberFlg' => 'tinyinteger', 'Onsites__deleteFlg' => 'tinyinteger', 'Onsites.deleteFlg' => 'tinyinteger', 'deleteFlg' => 'tinyinteger', 'Onsites__created' => 'datetime', 'Onsites.created' => 'datetime', 'created' => 'datetime', 'Onsites__modified' => 'datetime', 'Onsites.modified' => 'datetime', 'modified' => 'datetime', 'Sites__id' => 'integer', 'Sites.id' => 'integer', 'Sites__onsite_id' => 'integer', 'Sites.onsite_id' => 'integer', 'onsite_id' => 'integer', 'Sites__displayFlg' => 'tinyinteger', 'Sites.displayFlg' => 'tinyinteger', 'Sites__statusFlg' => 'tinyinteger', 'Sites.statusFlg' => 'tinyinteger', 'Sites__name' => 'string', 'Sites.name' => 'string', 'Sites__floor' => 'string', 'Sites.floor' => 'string', 'floor' => 'string', 'Sites__landRights' => 'string', 'Sites.landRights' => 'string', 'landRights' => 'string', 'Sites__landArea' => 'decimal', 'Sites.landArea' => 'decimal', 'landArea' => 'decimal', 'Sites__buildArea' => 'decimal', 'Sites.buildArea' => 'decimal', 'buildArea' => 'decimal', 'Sites__price' => 'decimal', 'Sites.price' => 'decimal', 'price' => 'decimal', 'Sites__PlanImgFlg' => 'tinyinteger', 'Sites.PlanImgFlg' => 'tinyinteger', 'PlanImgFlg' => 'tinyinteger', 'Sites__PlanPdfFlg' => 'tinyinteger', 'Sites.PlanPdfFlg' => 'tinyinteger', 'PlanPdfFlg' => 'tinyinteger', 'Sites__comment' => 'string', 'Sites.comment' => 'string', 'comment' => 'string', 'Sites__memo' => 'string', 'Sites.memo' => 'string', 'Sites__areaCD' => 'integer', 'Sites.areaCD' => 'integer', 'areaCD' => 'integer', 'Sites__lifetownFlg' => 'tinyinteger', 'Sites.lifetownFlg' => 'tinyinteger', 'Sites__created' => 'datetime', 'Sites.created' => 'datetime', 'Sites__modified' => 'datetime', 'Sites.modified' => 'datetime', 'Areas__id' => 'integer', 'Areas.id' => 'integer', 'Areas__areaClass_cd' => 'tinyinteger', 'Areas.areaClass_cd' => 'tinyinteger', 'areaClass_cd' => 'tinyinteger', 'Areas__name' => 'string', 'Areas.name' => 'string', 'Areas__sortPt' => 'smallinteger', 'Areas.sortPt' => 'smallinteger', 'sortPt' => 'smallinteger', 'Areas__editDate' => 'timestamp', 'Areas.editDate' => 'timestamp', 'editDate' => 'timestamp', 'Kinds__id' => 'integer', 'Kinds.id' => 'integer', 'Kinds__name' => 'string', 'Kinds.name' => 'string', 'Kinds__sortPt' => 'smallinteger', 'Kinds.sortPt' => 'smallinteger', 'Kinds__editDate' => 'timestamp', 'Kinds.editDate' => 'timestamp', 'Tours__id' => 'integer', 'Tours.id' => 'integer', 'Tours__name' => 'string', 'Tours.name' => 'string', 'Tours__sortPt' => 'smallinteger', 'Tours.sortPt' => 'smallinteger', 'Tours__category' => 'tinyinteger', 'Tours.category' => 'tinyinteger', 'category' => 'tinyinteger', 'Tours__editDate' => 'timestamp', 'Tours.editDate' => 'timestamp', 'Railways1__id' => 'integer', 'Railways1.id' => 'integer', 'Railways1__name' => 'string', 'Railways1.name' => 'string', 'Railways1__sortPt' => 'integer', 'Railways1.sortPt' => 'integer', 'Railways1__editDate' => 'timestamp', 'Railways1.editDate' => 'timestamp', 'Railways2__id' => 'integer', 'Railways2.id' => 'integer', 'Railways2__name' => 'string', 'Railways2.name' => 'string', 'Railways2__sortPt' => 'integer', 'Railways2.sortPt' => 'integer', 'Railways2__editDate' => 'timestamp', 'Railways2.editDate' => 'timestamp', 'Railways3__id' => 'integer', 'Railways3.id' => 'integer', 'Railways3__name' => 'string', 'Railways3.name' => 'string', 'Railways3__sortPt' => 'integer', 'Railways3.sortPt' => 'integer', 'Railways3__editDate' => 'timestamp', 'Railways3.editDate' => 'timestamp', 'Stations1__id' => 'integer', 'Stations1.id' => 'integer', 'Stations1__name' => 'string', 'Stations1.name' => 'string', 'Stations1__railway_id' => 'integer', 'Stations1.railway_id' => 'integer', 'railway_id' => 'integer', 'Stations1__pref_cd' => 'tinyinteger', 'Stations1.pref_cd' => 'tinyinteger', 'pref_cd' => 'tinyinteger', 'Stations1__sortPt' => 'smallinteger', 'Stations1.sortPt' => 'smallinteger', 'Stations1__editDate' => 'timestamp', 'Stations1.editDate' => 'timestamp', 'Stations2__id' => 'integer', 'Stations2.id' => 'integer', 'Stations2__name' => 'string', 'Stations2.name' => 'string', 'Stations2__railway_id' => 'integer', 'Stations2.railway_id' => 'integer', 'Stations2__pref_cd' => 'tinyinteger', 'Stations2.pref_cd' => 'tinyinteger', 'Stations2__sortPt' => 'smallinteger', 'Stations2.sortPt' => 'smallinteger', 'Stations2__editDate' => 'timestamp', 'Stations2.editDate' => 'timestamp', 'Stations3__id' => 'integer', 'Stations3.id' => 'integer', 'Stations3__name' => 'string', 'Stations3.name' => 'string', 'Stations3__railway_id' => 'integer', 'Stations3.railway_id' => 'integer', 'Stations3__pref_cd' => 'tinyinteger', 'Stations3.pref_cd' => 'tinyinteger', 'Stations3__sortPt' => 'smallinteger', 'Stations3.sortPt' => 'smallinteger', 'Stations3__editDate' => 'timestamp', 'Stations3.editDate' => 'timestamp' ], 'decorators' => (int) 0, 'executed' => true, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [ 'sites' => [[maximum depth reached]], 'Areas' => [[maximum depth reached]], 'Kinds' => [[maximum depth reached]], 'Tours' => [[maximum depth reached]], 'Railways1' => [[maximum depth reached]], 'Railways2' => [[maximum depth reached]], 'Railways3' => [[maximum depth reached]], 'Stations1' => [[maximum depth reached]], 'Stations2' => [[maximum depth reached]], 'Stations3' => [[maximum depth reached]] ], 'matching' => [], 'extraOptions' => [], 'repository' => object(App\Model\Table\OnsitesTable) {} } $area_results = [ (int) 0 => [ 'area_id' => '1', 'name' => '杉並区', 'Ct' => '44', 'CtM' => '17' ], (int) 1 => [ 'area_id' => '2', 'name' => '練馬区', 'Ct' => '24', 'CtM' => '1' ], (int) 2 => [ 'area_id' => '3', 'name' => '中野区', 'Ct' => '7', 'CtM' => '0' ], (int) 3 => [ 'area_id' => '5', 'name' => '世田谷区', 'Ct' => '2', 'CtM' => '0' ], (int) 4 => [ 'area_id' => '8', 'name' => '新宿区', 'Ct' => '2', 'CtM' => '0' ], (int) 5 => [ 'area_id' => '9', 'name' => '豊島区', 'Ct' => '1', 'CtM' => '0' ], (int) 6 => [ 'area_id' => '10', 'name' => '渋谷区', 'Ct' => '1', 'CtM' => '0' ], (int) 7 => [ 'area_id' => '24', 'name' => '武蔵野市', 'Ct' => '3', 'CtM' => '0' ], (int) 8 => [ 'area_id' => '25', 'name' => '三鷹市', 'Ct' => '0', 'CtM' => '1' ], (int) 9 => [ 'area_id' => '28', 'name' => '西東京市', 'Ct' => '3', 'CtM' => '0' ] ] $railway_results = [ (int) 0 => [ 'rway' => '11302', 'name' => 'JR山手線', 'ct' => '3' ], (int) 1 => [ 'rway' => '11312', 'name' => 'JR中央線(快速)', 'ct' => '58' ], (int) 2 => [ 'rway' => '11313', 'name' => 'JR中央・総武線', 'ct' => '9' ], (int) 3 => [ 'rway' => '21001', 'name' => '東武東上線', 'ct' => '2' ], (int) 4 => [ 'rway' => '22001', 'name' => '西武池袋線', 'ct' => '37' ], (int) 5 => [ 'rway' => '22007', 'name' => '西武新宿線', 'ct' => '64' ], (int) 6 => [ 'rway' => '24001', 'name' => '京王線', 'ct' => '10' ], (int) 7 => [ 'rway' => '24006', 'name' => '京王井の頭線', 'ct' => '30' ], (int) 8 => [ 'rway' => '24007', 'name' => '京王新線', 'ct' => '1' ], (int) 9 => [ 'rway' => '25001', 'name' => '小田急線', 'ct' => '2' ], (int) 10 => [ 'rway' => '26003', 'name' => '東急田園都市線', 'ct' => '1' ], (int) 11 => [ 'rway' => '26007', 'name' => '東急世田谷線', 'ct' => '2' ], (int) 12 => [ 'rway' => '28002', 'name' => '東京メトロ丸ノ内線', 'ct' => '24' ], (int) 13 => [ 'rway' => '28004', 'name' => '東京メトロ東西線', 'ct' => '1' ], (int) 14 => [ 'rway' => '28006', 'name' => '東京メトロ有楽町線', 'ct' => '2' ], (int) 15 => [ 'rway' => '28010', 'name' => '東京メトロ副都心線', 'ct' => '5' ], (int) 16 => [ 'rway' => '99301', 'name' => '都営大江戸線', 'ct' => '10' ] ] $OptionCT = [ 'railway' => (int) 19, 'pet' => (int) 9, 'life' => (int) 61, 'space' => (int) 18 ] $user = null $NoList = true $members_total = '19' $dat = [ 'rway' => '99301', 'name' => '都営大江戸線', 'ct' => '10' ] $key = (int) 16 $CtMember = ''include - APP/Template/Element/search_Area_Railway.ctp, line 89 Cake\View\View::_evaluate() - CORE/src/View/View.php, line 1420 Cake\View\View::_render() - CORE/src/View/View.php, line 1381 Cake\View\View::_renderElement() - CORE/src/View/View.php, line 1857 Cake\View\View::element() - CORE/src/View/View.php, line 782 include - APP/Template/Onsites/view.ctp, line 933 Cake\View\View::_evaluate() - CORE/src/View/View.php, line 1420 Cake\View\View::_render() - CORE/src/View/View.php, line 1381 Cake\View\View::render() - CORE/src/View/View.php, line 879 Cake\Controller\Controller::render() - CORE/src/Controller/Controller.php, line 795 Cake\Http\ActionDispatcher::_invoke() - CORE/src/Http/ActionDispatcher.php, line 126 Cake\Http\ActionDispatcher::dispatch() - CORE/src/Http/ActionDispatcher.php, line 94 Cake\Http\BaseApplication::__invoke() - CORE/src/Http/BaseApplication.php, line 234 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Http\Middleware\CsrfProtectionMiddleware::__invoke() - CORE/src/Http/Middleware/CsrfProtectionMiddleware.php, line 120
Copyright©2021-2025 LHF co.,ltd.
エリア検索