南西面と北西面2つの道路の角地に立つ３LDK住戸は３部屋すべてにバルコニーが設置された開放的プランです。 日当たりを計算された1階リビングに、キッチンから続くサニタリールーム、主婦目線で生活動線が整えられ、家族団らんと個々の部屋がしっかりと分けられた暮らしや すさは、お子様が成長し一人一部屋を必要とするときにも活かされることでしょう。西武新宿線と池袋線の2線利用の通勤通学も暮らしやすさに一役です。
3LDK+ロフト+カースペース1台
敷地面積：85.01m2 建物延床面積：84.05m2
7,190万円
モデルハウス見学受付中
| 価格 | 7,190万円 |
|---|---|
| 種類 | 新築戸建 |
| 所在地 | 練馬区南田中1丁目 |
| 土地権利 | 所有権 |
| 敷地面積 | 85.01㎡ |
| 設備 | 公営水道・本下水・東京ガス・東京電力 |
| 接道状況 | 北西側約4.0m公道･南西側約4.0m公道 |
| 都市計画 | 市街化区域 |
| 用途地域 | 第一種低層住居専用地域 |
| 高度地区 | 第一種高度地区 |
| 防火指定 | 準防火地域 |
| 建ぺい率/ 容積率 |
50％／100％ |
| 総区画数 | 1 |
| 建築確認番号 | 第HPA-25-00304-1号 |
| 建物面積 | 84.05㎡ |
| 建物構造 | 木造2階建 |
| 間取り | 3LDK+ロフト+カースペース1台 |
| 完成時期 | 2025年4月中旬予定 |
| 引渡時期 | 2025年4月下旬予定 |
| 取引態様 | 媒介 |
| 建物仕様 | ◆カウンターシステムキッチン ◆キッチン収納 ◆食洗機 ◆床暖房 ◆シャワー付洗面化粧台 ◆シャワートイレ ◆複層ガラス ◆ロフト ◆各居室専用バルコニー ◆床下収納庫 ◆階段･トイレに手摺設置 ◆高効率給湯器 ◆玄関断熱ドア ◆TVモニター付インターホン |
|---|---|
| ポイント | ●住宅性能評価取得 ●断熱等性能等級5 ●フラット35S |
| 指定学校区 | 練馬区立南が丘小学校 練馬区立南が丘中学校 |
| 備考 | ●ZEH水準 |
モデルハウス見学受付中
モデルハウス見学受付中
エリア検索
路線検索
会員限定物件
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' => '40', 'CtM' => '16' ], (int) 1 => [ 'area_id' => '2', 'name' => '練馬区', 'Ct' => '18', 'CtM' => '1' ], (int) 2 => [ 'area_id' => '3', 'name' => '中野区', 'Ct' => '8', 'CtM' => '0' ], (int) 3 => [ 'area_id' => '5', 'name' => '世田谷区', 'Ct' => '3', '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' => '2', 'CtM' => '0' ], (int) 8 => [ 'area_id' => '25', 'name' => '三鷹市', 'Ct' => '0', 'CtM' => '1' ], (int) 9 => [ 'area_id' => '28', 'name' => '西東京市', 'Ct' => '4', 'CtM' => '0' ], (int) 10 => [ 'area_id' => '33', 'name' => '狛江市', 'Ct' => '1', 'CtM' => '0' ], (int) 11 => [ 'area_id' => '35', 'name' => '東久留米市', 'Ct' => '1', 'CtM' => '0' ] ], 'railway_results' => [ (int) 0 => [ 'rway' => '11302', 'name' => 'JR山手線', 'ct' => '3' ], (int) 1 => [ 'rway' => '11312', 'name' => 'JR中央線(快速)', 'ct' => '60' ], (int) 2 => [ 'rway' => '11313', 'name' => 'JR中央・総武線', 'ct' => '5' ], (int) 3 => [ 'rway' => '21001', 'name' => '東武東上線', 'ct' => '2' ], (int) 4 => [ 'rway' => '22001', 'name' => '西武池袋線', 'ct' => '31' ], (int) 5 => [ 'rway' => '22007', 'name' => '西武新宿線', 'ct' => '53' ], (int) 6 => [ 'rway' => '24001', 'name' => '京王線', 'ct' => '13' ], (int) 7 => [ 'rway' => '24006', 'name' => '京王井の頭線', 'ct' => '29' ], (int) 8 => [ 'rway' => '24007', 'name' => '京王新線', 'ct' => '1' ], (int) 9 => [ 'rway' => '25001', 'name' => '小田急線', 'ct' => '5' ], (int) 10 => [ 'rway' => '28002', 'name' => '東京メトロ丸ノ内線', 'ct' => '23' ], (int) 11 => [ 'rway' => '28004', 'name' => '東京メトロ東西線', 'ct' => '1' ], (int) 12 => [ 'rway' => '28006', 'name' => '東京メトロ有楽町線', 'ct' => '2' ], (int) 13 => [ 'rway' => '28010', 'name' => '東京メトロ副都心線', 'ct' => '5' ], (int) 14 => [ 'rway' => '99301', 'name' => '都営大江戸線', 'ct' => '10' ] ], 'OptionCT' => [ 'railway' => (int) 21, 'pet' => (int) 9, 'life' => (int) 58, 'space' => (int) 19 ], 'user' => null, 'NoList' => true, 'members_total' => '18' ] $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' => '40', 'CtM' => '16' ], (int) 1 => [ 'area_id' => '2', 'name' => '練馬区', 'Ct' => '18', 'CtM' => '1' ], (int) 2 => [ 'area_id' => '3', 'name' => '中野区', 'Ct' => '8', 'CtM' => '0' ], (int) 3 => [ 'area_id' => '5', 'name' => '世田谷区', 'Ct' => '3', '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' => '2', 'CtM' => '0' ], (int) 8 => [ 'area_id' => '25', 'name' => '三鷹市', 'Ct' => '0', 'CtM' => '1' ], (int) 9 => [ 'area_id' => '28', 'name' => '西東京市', 'Ct' => '4', 'CtM' => '0' ], (int) 10 => [ 'area_id' => '33', 'name' => '狛江市', 'Ct' => '1', 'CtM' => '0' ], (int) 11 => [ 'area_id' => '35', 'name' => '東久留米市', 'Ct' => '1', 'CtM' => '0' ] ] $railway_results = [ (int) 0 => [ 'rway' => '11302', 'name' => 'JR山手線', 'ct' => '3' ], (int) 1 => [ 'rway' => '11312', 'name' => 'JR中央線(快速)', 'ct' => '60' ], (int) 2 => [ 'rway' => '11313', 'name' => 'JR中央・総武線', 'ct' => '5' ], (int) 3 => [ 'rway' => '21001', 'name' => '東武東上線', 'ct' => '2' ], (int) 4 => [ 'rway' => '22001', 'name' => '西武池袋線', 'ct' => '31' ], (int) 5 => [ 'rway' => '22007', 'name' => '西武新宿線', 'ct' => '53' ], (int) 6 => [ 'rway' => '24001', 'name' => '京王線', 'ct' => '13' ], (int) 7 => [ 'rway' => '24006', 'name' => '京王井の頭線', 'ct' => '29' ], (int) 8 => [ 'rway' => '24007', 'name' => '京王新線', 'ct' => '1' ], (int) 9 => [ 'rway' => '25001', 'name' => '小田急線', 'ct' => '5' ], (int) 10 => [ 'rway' => '28002', 'name' => '東京メトロ丸ノ内線', 'ct' => '23' ], (int) 11 => [ 'rway' => '28004', 'name' => '東京メトロ東西線', 'ct' => '1' ], (int) 12 => [ 'rway' => '28006', 'name' => '東京メトロ有楽町線', 'ct' => '2' ], (int) 13 => [ 'rway' => '28010', 'name' => '東京メトロ副都心線', 'ct' => '5' ], (int) 14 => [ 'rway' => '99301', 'name' => '都営大江戸線', 'ct' => '10' ] ] $OptionCT = [ 'railway' => (int) 21, 'pet' => (int) 9, 'life' => (int) 58, 'space' => (int) 19 ] $user = null $NoList = true $members_total = '18' $dat = [ 'rway' => '99301', 'name' => '都営大江戸線', 'ct' => '10' ] $key = (int) 14 $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' => '40', 'CtM' => '16' ], (int) 1 => [ 'area_id' => '2', 'name' => '練馬区', 'Ct' => '18', 'CtM' => '1' ], (int) 2 => [ 'area_id' => '3', 'name' => '中野区', 'Ct' => '8', 'CtM' => '0' ], (int) 3 => [ 'area_id' => '5', 'name' => '世田谷区', 'Ct' => '3', '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' => '2', 'CtM' => '0' ], (int) 8 => [ 'area_id' => '25', 'name' => '三鷹市', 'Ct' => '0', 'CtM' => '1' ], (int) 9 => [ 'area_id' => '28', 'name' => '西東京市', 'Ct' => '4', 'CtM' => '0' ], (int) 10 => [ 'area_id' => '33', 'name' => '狛江市', 'Ct' => '1', 'CtM' => '0' ], (int) 11 => [ 'area_id' => '35', 'name' => '東久留米市', 'Ct' => '1', 'CtM' => '0' ] ], 'railway_results' => [ (int) 0 => [ 'rway' => '11302', 'name' => 'JR山手線', 'ct' => '3' ], (int) 1 => [ 'rway' => '11312', 'name' => 'JR中央線(快速)', 'ct' => '60' ], (int) 2 => [ 'rway' => '11313', 'name' => 'JR中央・総武線', 'ct' => '5' ], (int) 3 => [ 'rway' => '21001', 'name' => '東武東上線', 'ct' => '2' ], (int) 4 => [ 'rway' => '22001', 'name' => '西武池袋線', 'ct' => '31' ], (int) 5 => [ 'rway' => '22007', 'name' => '西武新宿線', 'ct' => '53' ], (int) 6 => [ 'rway' => '24001', 'name' => '京王線', 'ct' => '13' ], (int) 7 => [ 'rway' => '24006', 'name' => '京王井の頭線', 'ct' => '29' ], (int) 8 => [ 'rway' => '24007', 'name' => '京王新線', 'ct' => '1' ], (int) 9 => [ 'rway' => '25001', 'name' => '小田急線', 'ct' => '5' ], (int) 10 => [ 'rway' => '28002', 'name' => '東京メトロ丸ノ内線', 'ct' => '23' ], (int) 11 => [ 'rway' => '28004', 'name' => '東京メトロ東西線', 'ct' => '1' ], (int) 12 => [ 'rway' => '28006', 'name' => '東京メトロ有楽町線', 'ct' => '2' ], (int) 13 => [ 'rway' => '28010', 'name' => '東京メトロ副都心線', 'ct' => '5' ], (int) 14 => [ 'rway' => '99301', 'name' => '都営大江戸線', 'ct' => '10' ] ], 'OptionCT' => [ 'railway' => (int) 21, 'pet' => (int) 9, 'life' => (int) 58, 'space' => (int) 19 ], 'user' => null, 'NoList' => true, 'members_total' => '18' ] $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' => '40', 'CtM' => '16' ], (int) 1 => [ 'area_id' => '2', 'name' => '練馬区', 'Ct' => '18', 'CtM' => '1' ], (int) 2 => [ 'area_id' => '3', 'name' => '中野区', 'Ct' => '8', 'CtM' => '0' ], (int) 3 => [ 'area_id' => '5', 'name' => '世田谷区', 'Ct' => '3', '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' => '2', 'CtM' => '0' ], (int) 8 => [ 'area_id' => '25', 'name' => '三鷹市', 'Ct' => '0', 'CtM' => '1' ], (int) 9 => [ 'area_id' => '28', 'name' => '西東京市', 'Ct' => '4', 'CtM' => '0' ], (int) 10 => [ 'area_id' => '33', 'name' => '狛江市', 'Ct' => '1', 'CtM' => '0' ], (int) 11 => [ 'area_id' => '35', 'name' => '東久留米市', 'Ct' => '1', 'CtM' => '0' ] ] $railway_results = [ (int) 0 => [ 'rway' => '11302', 'name' => 'JR山手線', 'ct' => '3' ], (int) 1 => [ 'rway' => '11312', 'name' => 'JR中央線(快速)', 'ct' => '60' ], (int) 2 => [ 'rway' => '11313', 'name' => 'JR中央・総武線', 'ct' => '5' ], (int) 3 => [ 'rway' => '21001', 'name' => '東武東上線', 'ct' => '2' ], (int) 4 => [ 'rway' => '22001', 'name' => '西武池袋線', 'ct' => '31' ], (int) 5 => [ 'rway' => '22007', 'name' => '西武新宿線', 'ct' => '53' ], (int) 6 => [ 'rway' => '24001', 'name' => '京王線', 'ct' => '13' ], (int) 7 => [ 'rway' => '24006', 'name' => '京王井の頭線', 'ct' => '29' ], (int) 8 => [ 'rway' => '24007', 'name' => '京王新線', 'ct' => '1' ], (int) 9 => [ 'rway' => '25001', 'name' => '小田急線', 'ct' => '5' ], (int) 10 => [ 'rway' => '28002', 'name' => '東京メトロ丸ノ内線', 'ct' => '23' ], (int) 11 => [ 'rway' => '28004', 'name' => '東京メトロ東西線', 'ct' => '1' ], (int) 12 => [ 'rway' => '28006', 'name' => '東京メトロ有楽町線', 'ct' => '2' ], (int) 13 => [ 'rway' => '28010', 'name' => '東京メトロ副都心線', 'ct' => '5' ], (int) 14 => [ 'rway' => '99301', 'name' => '都営大江戸線', 'ct' => '10' ] ] $OptionCT = [ 'railway' => (int) 21, 'pet' => (int) 9, 'life' => (int) 58, 'space' => (int) 19 ] $user = null $NoList = true $members_total = '18' $dat = [ 'rway' => '99301', 'name' => '都営大江戸線', 'ct' => '10' ] $key = (int) 14 $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.
