网站被黑了,成都哪里做网站,无锡知名网站制作,友情链接推广一、背景 接到一个数据需求#xff0c;是从我们的Mongo中导出的#xff0c;但要取的值得到很深的层级#xff0c;尝试写了半天Mongo的查询查不出来#xff0c;问了半天大模型给的也不对#xff0c;于是考虑写代码的方式
二、数据格式
// 1
{_id: ObjectId(是从我们的Mongo中导出的但要取的值得到很深的层级尝试写了半天Mongo的查询查不出来问了半天大模型给的也不对于是考虑写代码的方式
二、数据格式
// 1
{_id: ObjectId(65d367751de88e5f7305338e),districtName: 朝阳区,year: 2024,cityCode: 110000,bizcircleId: 161,bizcircleName: CBD商圈,isShowOut: 102300000001,modules: [{id: 0,code: 0,displayName: 封面,_class: com.test.job.marketreport.document.ReportModule},{id: a,code: a,displayName: 商圈楼盘分布图,englishName: Distribution Of Business District Real Estate,submodules: [{list: [{resblockId: NumberInt(600103),resblockName: 通用时代国际公寓,belongType: 2,dealAmount: 0,avgDealprice: 8.39,_class: com.test.job.marketreport.document.ResblockRankItem2},{resblockId: NumberInt(600067),resblockName: 乐成公馆,belongType: 2,dealAmount: 0,avgDealprice: 9.55,_class: com.test.job.marketreport.document.ResblockRankItem2},{resblockId: NumberInt(600040),resblockName: 温莎大道,belongType: 2,map_x: 116.459871,map_y: 39.918146,dealAmount: 0,avgDealprice: 9.09,_class: com.test.job.marketreport.document.ResblockRankItem2},{resblockId: NumberInt(597683),resblockName: 世贸国际公寓,belongType: 2,map_x: 116.460154,map_y: 39.920838,dealAmount: 0,avgDealprice: 9.38,_class: com.test.job.marketreport.document.ResblockRankItem2},{resblockId: NumberInt(597505),resblockName: 蓝堡国际公寓,belongType: 2,dealAmount: 0,avgDealprice: 9.6,_class: com.test.job.marketreport.document.ResblockRankItem2},{resblockId: NumberInt(597373),resblockName: 富力十号,belongType: 2,map_x: 116.461138,map_y: 39.903885,dealAmount: 2,avgDealprice: 10.06,_class: com.test.job.marketreport.document.ResblockRankItem2},{resblockId: NumberInt(597253),resblockName: 梵悦108,belongType: 1,2,map_x: 116.471373,map_y: 39.912671,dealAmount: 1,avgDealprice: 11.77,_class: com.test.job.marketreport.document.ResblockRankItem2},{resblockId: NumberInt(597246),resblockName: 万科大都会,belongType: 2,map_x: 116.468655,map_y: 39.911689,dealAmount: 0,avgDealprice: 5.59,_class: com.test.job.marketreport.document.ResblockRankItem2},{resblockId: NumberInt(597245),resblockName: 中骏.世界城,belongType: 2,map_x: 116.458727,map_y: 39.923352,dealAmount: 0,avgDealprice: 5.51,_class: com.test.job.marketreport.document.ResblockRankItem2},{resblockId: NumberInt(11897),resblockName: 金桐拾贰,belongType: 1,map_x: 116.460864,map_y: 39.920687,dealAmount: 0,avgDealprice: 0,_class: com.test.job.marketreport.document.ResblockRankItem2},{resblockId: NumberInt(9935),resblockName: 禧瑞都,belongType: 2,map_x: 116.471910,map_y: 39.924525,dealAmount: 1,avgDealprice: 10.51,_class: com.test.job.marketreport.document.ResblockRankItem2},{resblockId: NumberInt(8118),resblockName: 首创天禧,belongType: 1,2,map_x: 116.471402,map_y: 39.923987,dealAmount: 0,avgDealprice: 21.3,_class: com.test.job.marketreport.document.ResblockRankItem2},{resblockId: NumberInt(6901),resblockName: 尊悦光华,belongType: 1,map_x: 116.463016,map_y: 39.918581,dealAmount: 0,avgDealprice: 9.1,_class: com.test.job.marketreport.document.ResblockRankItem2},{resblockId: NumberInt(6098),resblockName: 银泰中心,belongType: 2,map_x: 116.465854,map_y: 39.913217,dealAmount: 0,avgDealprice: 8.87,_class: com.test.job.marketreport.document.ResblockRankItem2},{resblockId: NumberInt(2378),resblockName: 新城国际,belongType: 2,1,map_x: 116.462153,map_y: 39.923909,dealAmount: 12,avgDealprice: 5.82,_class: com.test.job.marketreport.document.ResblockRankItem2},{resblockId: NumberInt(1394),resblockName: 御金台,belongType: 2,map_x: 116.464913,map_y: 39.923461,dealAmount: 0,avgDealprice: 11.44,_class: com.test.job.marketreport.document.ResblockRankItem2},{resblockId: NumberInt(47),resblockName: 金地国际花园,belongType: 2,map_x: 116.481327,map_y: 39.915586,dealAmount: 1,avgDealprice: 9.83,_class: com.test.job.marketreport.document.ResblockRankItem2}],id: rl_a,type: resblock_location,_class: com.test.job.marketreport.document.ReportSubmoduleHouseList}],_class: com.test.job.marketreport.document.ReportModule},{id: b,code: b,displayName: 整体价值介绍,englishName: Overall Value Introduction,submodules: [{submodules: [{metrics: [{displayName: 二手楼盘均价(万/㎡),value: 10.02,subvalue: 29,upOrDown: 0,gain: -2.24%},{displayName: 一手楼盘均价(万/㎡),value: 8.93,subvalue: 20,upOrDown: 0,gain: 0%}],name: 成交均价,type: metric,_class: com.test.job.marketreport.document.ReportSubmoduleMetric},{metrics: [{displayName: 二手成交量(套),value: 17,subvalue: 2},{displayName: 一手成交量(套),value: 0},{displayName: 换手率,value: 3%,subvalue: 20}],name: 成交量,type: metric,_class: com.test.job.marketreport.document.ReportSubmoduleMetric},{metrics: [{displayName: 单位租金(元/㎡/月),value: 252,subvalue: 8,upOrDown: 1,gain: 2.02%},{displayName: 租金回报率,value: 3.02%,subvalue: 8,upOrDown: 1,gain: 0%}],name: 租金,type: metric,_class: com.test.job.marketreport.document.ReportSubmoduleMetric}],type: vbox,_class: com.test.job.marketreport.document.ReportSubmoduleList}],_class: com.test.job.marketreport.document.ReportModule},{id: c,code: c,displayName: 好不好卖,englishName: Sell Well,submodules: [{value: 商圈房屋存量,type: title1,_class: com.test.job.marketreport.document.ReportSubmoduleAdvice},{subid: c_1,subtype: pie,title: 一手、二手存量占比,displayMode: percentage,data: [{name: 二手·7318户,value: NumberInt(95)},{name: 一手·339户,value: NumberInt(4)}],id: 65d367751de88e5f7305338e_c_1,type: chart,_class: com.test.job.marketreport.document.ReportSubmoduleChart},{submodules: [{editable: true,type: title2},{editable: true,type: title3},{editable: true,type: content},{editable: true,type: title3},{editable: true,type: content}],submodulesReference: [ ],id: c_2,type: conclusion,_class: com.test.job.marketreport.document.ReportSubmoduleConclusion},{value: 商圈成交量,type: title1,_class: com.test.job.marketreport.document.ReportSubmoduleAdvice},{subid: c_3,subtype: bar,title: 一手二手成交量趋势,unit: 套,unit2: 套,x: [2月,3月,4月,5月,6月,7月,8月,9月,10月,11月,12月,1月],y: [{name: 二手,type: bar,unit: 套,data: [16,19,16,19,21,4,16,17,12,12,18,17]},{name: 一手,type: bar,unit: 套,data: [0,5,0,8,6,1,2,3,8,2,0,0]}],id: 65d367751de88e5f7305338e_c_3,type: chart,_class: com.test.job.marketreport.document.ReportSubmoduleChart},{submodules: [{editable: true,type: title2},{editable: true,type: title3},{value: 1月一手无成交。二手成交量为17套环比减少1套同比减少1套。,editable: true,type: content},{editable: true,type: title3},{editable: true,type: content}],submodulesReference: [ ],id: c_4,type: conclusion,_class: com.test.job.marketreport.document.ReportSubmoduleConclusion},{value: 换手率,type: title1,_class: com.test.job.marketreport.document.ReportSubmoduleAdvice},{subid: c_5,subtype: line,title: 换手率趋势,unit: %,x: [2019年,2020年,2021年,2022年,2023年],y: [{type: line,data: [3,2.41,4,2,3]}],id: 65d367751de88e5f7305338e_c_5,type: chart,_class: com.test.job.marketreport.document.ReportSubmoduleChart},{submodules: [{editable: true,type: title2},{editable: true,type: title3},{value: 2023年换手率为3%同比上涨1个百分点。,editable: true,type: content},{editable: true,type: title3},{editable: true,type: content}],submodulesReference: [ ],id: c_6,type: conclusion,_class: com.test.job.marketreport.document.ReportSubmoduleConclusion}],_class: com.test.job.marketreport.document.ReportModule},{id: d,code: d,displayName: 投资回报率,englishName: Return On Investment,submodules: [{value: 土地价值,type: title1,_class: com.test.job.marketreport.document.ReportSubmoduleAdvice},{submodules: [{value: 土地价值,editable: false,type: landTitle},{value: 暂无成交,editable: false,type: landValue},{editable: true,type: title2},{editable: true,type: title3},{editable: true,type: content}],submodulesReference: [ ],id: d_1,type: conclusion,_class: com.test.job.marketreport.document.ReportSubmoduleConclusion},{value: 成交价趋势,type: title1,_class: com.test.job.marketreport.document.ReportSubmoduleAdvice},{subid: d_2,subtype: line,title: 成交价趋势,unit: 万/㎡,x: [2月,3月,4月,5月,6月,7月,8月,9月,10月,11月,12月,1月],y: [{name: 一手,type: line,data: [12.83,7.19,7.19,7.34,7.38,8.39,6.64,6.18,8.09,8.93,8.93,8.93]},{name: 二手,type: line,data: [10.16,10.35,10.86,10.86,10.9,10.38,10.68,10.59,10.6,10.47,10.25,10.02]}],id: 65d367751de88e5f7305338e_d_2,type: chart,_class: com.test.job.marketreport.document.ReportSubmoduleChart},{submodules: [{editable: true,type: title2},{editable: true,type: title3},{value: 1月一手成交均价为8.93万/㎡环比持平同比下降30.4%。二手成交均价为10.02万/㎡环比下降2.24%同比下降3.19%。,editable: true,type: content},{editable: true,type: title3},{editable: true,type: content}],submodulesReference: [ ],id: d_3,type: conclusion,_class: com.test.job.marketreport.document.ReportSubmoduleConclusion},{value: 房价涨幅,type: title1,_class: com.test.job.marketreport.document.ReportSubmoduleAdvice},{subid: d_4,subtype: line,title: 房价涨幅趋势,unit: %,x: [2019年,2020年,2021年,2022年,2023年],y: [{type: line,data: [-9.0600,-5.700,6.6100,-2.8300,-1.2200]}],id: 65d367751de88e5f7305338e_d_4,type: chart,_class: com.test.job.marketreport.document.ReportSubmoduleChart},{submodules: [{editable: true,type: title2},{editable: true,type: title3},{value: 2023年成交均价相比去年上涨1.61%。,editable: true,type: content},{editable: true,type: title3},{editable: true,type: content}],submodulesReference: [ ],id: d_5,type: conclusion,_class: com.test.job.marketreport.document.ReportSubmoduleConclusion},{value: 租金回报率,type: title1,_class: com.test.job.marketreport.document.ReportSubmoduleAdvice},{subid: d_6,subtype: line,title: 租金回报率趋势,unit: %,x: [2月,3月,4月,5月,6月,7月,8月,9月,10月,11月,12月,1月],y: [{type: line,data: [2.9400,3.00,2.8500,2.7500,2.7900,2.9500,2.8600,2.7300,2.7800,2.700,2.8500,3.0200]}],id: 65d367751de88e5f7305338e_d_6,type: chart,_class: com.test.job.marketreport.document.ReportSubmoduleChart},{submodules: [{editable: true,type: title2},{editable: true,type: title3},{value: 1月租金回报率为3.02%环比增加0.17个百分点同比增加0.11个百分点。,editable: true,type: content},{editable: true,type: title3},{editable: true,type: content}],submodulesReference: [ ],id: d_7,type: conclusion,_class: com.test.job.marketreport.document.ReportSubmoduleConclusion}],_class: com.test.job.marketreport.document.ReportModule},{id: e,code: e,displayName: 未来升值潜力,englishName: Future Appreciation Potential,submodules: [ ],_class: com.test.job.marketreport.document.ReportModule},{id: f,code: f,displayName: 该买哪个盘,englishName: Which Plate Should I Buy,submodules: [{value: 豪盘榜,type: title1,_class: com.test.job.marketreport.document.ReportSubmoduleAdvice},{value: 套均总价排名,type: dataTable,_class: com.test.job.marketreport.document.ReportSubmoduleAdvice},{names: [楼盘名称,套均总价(万)],list: [{resblockId: NumberInt(8118),resblockName: 首创天禧,value: 8500,belongType: 1},{resblockId: NumberInt(597373),resblockName: 富力十号,value: 4800,belongType: 2},{resblockId: NumberInt(8118),resblockName: 首创天禧,value: 4650,belongType: 2},{resblockId: NumberInt(1394),resblockName: 御金台,value: 2777,belongType: 2},{resblockId: NumberInt(597253),resblockName: 梵悦108,value: 2734,belongType: 2},{resblockId: NumberInt(47),resblockName: 金地国际花园,value: 2180,belongType: 2},{resblockId: NumberInt(600103),resblockName: 通用时代国际公寓,value: 2174,belongType: 2},{resblockId: NumberInt(597683),resblockName: 世贸国际公寓,value: 2163,belongType: 2},{resblockId: NumberInt(597245),resblockName: 中骏.世界城,value: 2031,belongType: 2},{resblockId: NumberInt(600040),resblockName: 温莎大道,value: 1976,belongType: 2},{resblockId: NumberInt(600067),resblockName: 乐成公馆,value: 1897,belongType: 2},{resblockId: NumberInt(597253),resblockName: 梵悦108,value: 1825,belongType: 1},{resblockId: NumberInt(2378),resblockName: 新城国际,value: 1743,belongType: 2},{resblockId: NumberInt(9935),resblockName: 禧瑞都,value: 1663,belongType: 2},{resblockId: NumberInt(2378),resblockName: 新城国际,value: 1531,belongType: 1},{resblockId: NumberInt(6901),resblockName: 尊悦光华,value: 1473,belongType: 1},{resblockId: NumberInt(597505),resblockName: 蓝堡国际公寓,value: 1207,belongType: 2},{resblockId: NumberInt(6098),resblockName: 银泰中心,value: 1180,belongType: 2},{resblockId: NumberInt(597246),resblockName: 万科大都会,value: 901,belongType: 2},{resblockId: NumberInt(11897),resblockName: 金桐拾贰,belongType: 1}],rankTitle: 套均总价排名,id: f_1,type: rank,_class: com.test.job.marketreport.document.ReportSubmoduleRank2},{value: 成交均价排名,type: dataTable,_class: com.test.job.marketreport.document.ReportSubmoduleAdvice},{names: [楼盘名称,成交均价(万/㎡)],list: [{resblockId: NumberInt(8118),resblockName: 首创天禧,value: 21.3,belongType: 1},{resblockId: NumberInt(597253),resblockName: 梵悦108,value: 12.37,belongType: 2},{resblockId: NumberInt(597253),resblockName: 梵悦108,value: 11.77,belongType: 1},{resblockId: NumberInt(8118),resblockName: 首创天禧,value: 11.65,belongType: 2},{resblockId: NumberInt(1394),resblockName: 御金台,value: 11.44,belongType: 2},{resblockId: NumberInt(9935),resblockName: 禧瑞都,value: 10.51,belongType: 2},{resblockId: NumberInt(597373),resblockName: 富力十号,value: 10.06,belongType: 2},{resblockId: NumberInt(2378),resblockName: 新城国际,value: 9.94,belongType: 2},{resblockId: NumberInt(47),resblockName: 金地国际花园,value: 9.83,belongType: 2},{resblockId: NumberInt(597505),resblockName: 蓝堡国际公寓,value: 9.6,belongType: 2},{resblockId: NumberInt(600067),resblockName: 乐成公馆,value: 9.55,belongType: 2},{resblockId: NumberInt(597683),resblockName: 世贸国际公寓,value: 9.38,belongType: 2},{resblockId: NumberInt(6901),resblockName: 尊悦光华,value: 9.1,belongType: 1},{resblockId: NumberInt(600040),resblockName: 温莎大道,value: 9.09,belongType: 2},{resblockId: NumberInt(6098),resblockName: 银泰中心,value: 8.87,belongType: 2},{resblockId: NumberInt(600103),resblockName: 通用时代国际公寓,value: 8.39,belongType: 2},{resblockId: NumberInt(2378),resblockName: 新城国际,value: 5.82,belongType: 1},{resblockId: NumberInt(597246),resblockName: 万科大都会,value: 5.59,belongType: 2},{resblockId: NumberInt(597245),resblockName: 中骏.世界城,value: 5.51,belongType: 2},{resblockId: NumberInt(11897),resblockName: 金桐拾贰,belongType: 1}],rankTitle: 成交均价排名,id: f_2,type: rank,_class: com.test.job.marketreport.document.ReportSubmoduleRank2},{value: 单位租金排名,type: dataTable,_class: com.test.job.marketreport.document.ReportSubmoduleAdvice},{names: [楼盘名称,单位租金(元/㎡/月)],list: [{resblockId: NumberInt(8118),resblockName: 首创天禧,value: 385.26,belongType: 2},{resblockId: NumberInt(6098),resblockName: 银泰中心,value: 357.5,belongType: 2},{resblockId: NumberInt(597373),resblockName: 富力十号,value: 248.18,belongType: 2},{resblockId: NumberInt(2378),resblockName: 新城国际,value: 220.95,belongType: 2},{resblockId: NumberInt(1394),resblockName: 御金台,value: 213.22,belongType: 2},{resblockId: NumberInt(9935),resblockName: 禧瑞都,value: 206.96,belongType: 2},{resblockId: NumberInt(47),resblockName: 金地国际花园,value: 152.58,belongType: 2}],rankTitle: 单位租金排名,id: f_3,type: rank,_class: com.test.job.marketreport.document.ReportSubmoduleRank2},{value: 好卖盘,type: title1,_class: com.test.job.marketreport.document.ReportSubmoduleAdvice},{value: 商圈内新房成交量排名,type: dataTable,_class: com.test.job.marketreport.document.ReportSubmoduleAdvice},{names: [楼盘名称,成交量(套)],list: [{resblockId: NumberInt(597253),resblockName: 梵悦108,value: 0,belongType: 1},{resblockId: NumberInt(8118),resblockName: 首创天禧,value: 0,belongType: 1},{resblockId: NumberInt(2378),resblockName: 新城国际,value: 0,belongType: 1},{resblockId: NumberInt(6901),resblockName: 尊悦光华,value: 0,belongType: 1},{resblockId: NumberInt(11897),resblockName: 金桐拾贰,belongType: 1}],rankTitle: 商圈内新房成交量排名,id: f_4,type: rank,_class: com.test.job.marketreport.document.ReportSubmoduleRank2},{value: 商圈内二手楼盘成交量排名,type: dataTable,_class: com.test.job.marketreport.document.ReportSubmoduleAdvice},{names: [楼盘名称,成交量(套)],list: [{resblockId: NumberInt(2378),resblockName: 新城国际,value: 12,belongType: 2},{resblockId: NumberInt(597373),resblockName: 富力十号,value: 2,belongType: 2},{resblockId: NumberInt(597253),resblockName: 梵悦108,value: 1,belongType: 2},{resblockId: NumberInt(9935),resblockName: 禧瑞都,value: 1,belongType: 2},{resblockId: NumberInt(47),resblockName: 金地国际花园,value: 1,belongType: 2},{resblockId: NumberInt(597505),resblockName: 蓝堡国际公寓,value: 0,belongType: 2},{resblockId: NumberInt(1394),resblockName: 御金台,value: 0,belongType: 2},{resblockId: NumberInt(597245),resblockName: 中骏.世界城,value: 0,belongType: 2},{resblockId: NumberInt(600040),resblockName: 温莎大道,value: 0,belongType: 2},{resblockId: NumberInt(8118),resblockName: 首创天禧,value: 0,belongType: 2},{resblockId: NumberInt(597683),resblockName: 世贸国际公寓,value: 0,belongType: 2},{resblockId: NumberInt(600103),resblockName: 通用时代国际公寓,value: 0,belongType: 2},{resblockId: NumberInt(597246),resblockName: 万科大都会,value: 0,belongType: 2},{resblockId: NumberInt(6098),resblockName: 银泰中心,value: 0,belongType: 2},{resblockId: NumberInt(600067),resblockName: 乐成公馆,value: 0,belongType: 2}],rankTitle: 商圈内二手楼盘成交量排名,id: f_5,type: rank,_class: com.test.job.marketreport.document.ReportSubmoduleRank2},{value: 商圈内二手楼盘换手率排名,type: dataTable,_class: com.test.job.marketreport.document.ReportSubmoduleAdvice},{names: [楼盘名称,换手率],list: [{resblockId: NumberInt(2378),resblockName: 新城国际,value: 4.29%,belongType: 2},{resblockId: NumberInt(47),resblockName: 金地国际花园,value: 3.37%,belongType: 2},{resblockId: NumberInt(9935),resblockName: 禧瑞都,value: 3.05%,belongType: 2},{resblockId: NumberInt(597683),resblockName: 世贸国际公寓,value: 2.88%,belongType: 2},{resblockId: NumberInt(600040),resblockName: 温莎大道,value: 2.85%,belongType: 2},{resblockId: NumberInt(1394),resblockName: 御金台,value: 2.78%,belongType: 2},{resblockId: NumberInt(597373),resblockName: 富力十号,value: 2.42%,belongType: 2},{resblockId: NumberInt(6098),resblockName: 银泰中心,value: 2.31%,belongType: 2},{resblockId: NumberInt(597246),resblockName: 万科大都会,value: 1.45%,belongType: 2},{resblockId: NumberInt(597253),resblockName: 梵悦108,value: 1.39%,belongType: 2},{resblockId: NumberInt(600103),resblockName: 通用时代国际公寓,value: 0.67%,belongType: 2},{resblockId: NumberInt(597505),resblockName: 蓝堡国际公寓,value: 0.12%,belongType: 2},{resblockId: NumberInt(597245),resblockName: 中骏.世界城,value: 0%,belongType: 2},{resblockId: NumberInt(8118),resblockName: 首创天禧,value: 0%,belongType: 2},{resblockId: NumberInt(600067),resblockName: 乐成公馆,value: 0%,belongType: 2}],rankTitle: 商圈内二手楼盘换手率排名,id: f_6,type: rank,_class: com.test.job.marketreport.document.ReportSubmoduleRank2},{value: 高投资回报率,type: title1,_class: com.test.job.marketreport.document.ReportSubmoduleAdvice},{value: 二手租金回报率排名,type: dataTable,_class: com.test.job.marketreport.document.ReportSubmoduleAdvice},{names: [楼盘名称,租金回报率],list: [{resblockId: NumberInt(597246),resblockName: 万科大都会,value: 5.78%,belongType: 2},{resblockId: NumberInt(6098),resblockName: 银泰中心,value: 4.84%,belongType: 2},{resblockId: NumberInt(8118),resblockName: 首创天禧,value: 3.97%,belongType: 2},{resblockId: NumberInt(597245),resblockName: 中骏.世界城,value: 3.81%,belongType: 2},{resblockId: NumberInt(597373),resblockName: 富力十号,value: 2.96%,belongType: 2},{resblockId: NumberInt(597253),resblockName: 梵悦108,value: 2.86%,belongType: 2},{resblockId: NumberInt(2378),resblockName: 新城国际,value: 2.67%,belongType: 2},{resblockId: NumberInt(597683),resblockName: 世贸国际公寓,value: 2.65%,belongType: 2},{resblockId: NumberInt(9935),resblockName: 禧瑞都,value: 2.36%,belongType: 2},{resblockId: NumberInt(597505),resblockName: 蓝堡国际公寓,value: 2.33%,belongType: 2},{resblockId: NumberInt(1394),resblockName: 御金台,value: 2.24%,belongType: 2},{resblockId: NumberInt(600067),resblockName: 乐成公馆,value: 2.18%,belongType: 2},{resblockId: NumberInt(600040),resblockName: 温莎大道,value: 2%,belongType: 2},{resblockId: NumberInt(47),resblockName: 金地国际花园,value: 1.86%,belongType: 2},{resblockId: NumberInt(600103),resblockName: 通用时代国际公寓,value: 1.27%,belongType: 2}],rankTitle: 二手租金回报率排名,id: f_8,type: rank,_class: com.test.job.marketreport.document.ReportSubmoduleRank2}],_class: com.test.job.marketreport.document.ReportModule},{id: g,code: g,displayName: 商圈排行榜Top10,englishName: Business District Ranking,submodules: [{tabs: [{title: 二手楼盘均价,submodules: [{_id: g_1,names: [商圈名称,成交均价(万/㎡)],type: rank,list: [{bizcircleId: NumberInt(175),bizcircleName: 金融街,value: 19.38},{bizcircleId: NumberInt(768),bizcircleName: 德胜门,value: 18.12},{bizcircleId: NumberInt(721),bizcircleName: 宣武门,value: 16.99},{bizcircleId: NumberInt(204),bizcircleName: 万柳,value: 16.72},{bizcircleId: NumberInt(174),bizcircleName: 陶然亭,value: 16.35},{bizcircleId: NumberInt(205),bizcircleName: 世纪城,value: 15.37},{bizcircleId: NumberInt(207),bizcircleName: 玉渊潭,value: 14.68},{bizcircleId: NumberInt(199),bizcircleName: 丽泽商务区,value: 14.03},{bizcircleId: NumberInt(203),bizcircleName: 中关村,value: 13.82},{bizcircleId: NumberInt(173),bizcircleName: 崇文门,value: 13.82},{bizcircleId: NumberInt(209),bizcircleName: 紫竹院,value: 13.28},{bizcircleId: NumberInt(525),bizcircleName: 北海景山,value: 12.64},{bizcircleId: NumberInt(206),bizcircleName: 西钓鱼台,value: 12.64},{bizcircleId: NumberInt(177),bizcircleName: 燕莎,value: 11.95},{bizcircleId: NumberInt(170),bizcircleName: 王府井,value: 11.88},{bizcircleId: NumberInt(187),bizcircleName: 奥林匹克公园,value: 11.79},{bizcircleId: NumberInt(163),bizcircleName: 东直门,value: 11.79},{bizcircleId: NumberInt(212),bizcircleName: 西北旺,value: 11.76},{bizcircleId: NumberInt(186),bizcircleName: 太阳宫,value: 11.7},{bizcircleId: NumberInt(211),bizcircleName: 清河上地,value: 11.39},{bizcircleId: NumberInt(782),bizcircleName: 西直门,value: 11.37},{bizcircleId: NumberInt(168),bizcircleName: 安定门,value: 11.33},{bizcircleId: NumberInt(166),bizcircleName: 望京,value: 11.27},{bizcircleId: NumberInt(189),bizcircleName: 亚运村小营,value: 10.98},{bizcircleId: NumberInt(164),bizcircleName: 工体,value: 10.93},{bizcircleId: NumberInt(208),bizcircleName: 西山别墅区,value: 10.75},{bizcircleId: NumberInt(162),bizcircleName: 朝阳公园,value: 10.75},{bizcircleId: NumberInt(178),bizcircleName: 建国门,value: 10.69},{bizcircleId: NumberInt(161),bizcircleName: CBD,value: 10.02},{bizcircleId: NumberInt(216),bizcircleName: 石景山,value: 9.11},{bizcircleId: NumberInt(942),bizcircleName: 大湖中央别墅区,value: 9.1},{bizcircleId: NumberInt(765),bizcircleName: 北苑,value: 9.07},{bizcircleId: NumberInt(167),bizcircleName: 朝青,value: 9},{bizcircleId: NumberInt(179),bizcircleName: 西大望路,value: 8.87},{bizcircleId: NumberInt(532),bizcircleName: 金宝街,value: 8.78},{bizcircleId: NumberInt(165),bizcircleName: 丽都,value: 8.29},{bizcircleId: NumberInt(197),bizcircleName: 亦庄开发区,value: 8.23},{bizcircleId: NumberInt(200),bizcircleName: 世界公园,value: 8.22},{bizcircleId: NumberInt(183),bizcircleName: 高碑店,value: 8.13},{bizcircleId: NumberInt(201),bizcircleName: 大红门,value: 7.97},{bizcircleId: NumberInt(196),bizcircleName: 通州新城,value: 7.54},{bizcircleId: NumberInt(943),bizcircleName: 孙河中央别墅区,value: 7.08},{bizcircleId: NumberInt(215),bizcircleName: 昌平别墅区,value: 7.06},{bizcircleId: NumberInt(184),bizcircleName: 五方桥,value: 7.01},{bizcircleId: NumberInt(944),bizcircleName: 后沙峪中央别墅区,value: 6.95},{bizcircleId: NumberInt(191),bizcircleName: 东坝,value: 6.47},{bizcircleId: NumberInt(945),bizcircleName: 天竺中央别墅区,value: 6.39},{bizcircleId: NumberInt(198),bizcircleName: 大兴城南别墅区,value: 6.1},{bizcircleId: NumberInt(214),bizcircleName: 奥北别墅区,value: 5.48},{bizcircleId: NumberInt(195),bizcircleName: 通州别墅区,value: 5.44},{bizcircleId: NumberInt(202),bizcircleName: 燕西别墅区,value: 3.98},{bizcircleId: NumberInt(218),bizcircleName: 房山},{bizcircleId: NumberInt(219),bizcircleName: 密云},{bizcircleId: NumberInt(220),bizcircleName: 怀柔},{bizcircleId: NumberInt(221),bizcircleName: 延庆},{bizcircleId: NumberInt(222),bizcircleName: 平谷},{bizcircleId: NumberInt(521),bizcircleName: 中南海},{bizcircleId: NumberInt(522),bizcircleName: 新街口},{bizcircleId: NumberInt(523),bizcircleName: 白塔寺},{bizcircleId: NumberInt(524),bizcircleName: 西四},{bizcircleId: NumberInt(526),bizcircleName: 前门},{bizcircleId: NumberInt(527),bizcircleName: 鼓楼},{bizcircleId: NumberInt(528),bizcircleName: 雍和宫北新桥},{bizcircleId: NumberInt(529),bizcircleName: 南锣鼓巷},{bizcircleId: NumberInt(530),bizcircleName: 东四},{bizcircleId: NumberInt(531),bizcircleName: 故宫南北池子},{bizcircleId: NumberInt(767),bizcircleName: 泛CBD东别墅区},{bizcircleId: NumberInt(769),bizcircleName: 故宫},{bizcircleId: NumberInt(772),bizcircleName: 雍和宫},{bizcircleId: NumberInt(778),bizcircleName: 潮白河别墅区},{bizcircleId: NumberInt(785),bizcircleName: 朝阳门},{bizcircleId: NumberInt(217),bizcircleName: 门头沟},{bizcircleId: NumberInt(213),bizcircleName: 海淀北部新区},{bizcircleId: NumberInt(210),bizcircleName: 马甸},{bizcircleId: NumberInt(192),bizcircleName: 姚家园},{bizcircleId: NumberInt(188),bizcircleName: 奥体},{bizcircleId: NumberInt(185),bizcircleName: 管庄},{bizcircleId: NumberInt(182),bizcircleName: 小红门},{bizcircleId: NumberInt(181),bizcircleName: 十八里店},{bizcircleId: NumberInt(180),bizcircleName: 双井},{bizcircleId: NumberInt(176),bizcircleName: 西直门外},{bizcircleId: NumberInt(172),bizcircleName: 永定门},{bizcircleId: NumberInt(1343),bizcircleName: 分钟寺},{bizcircleId: NumberInt(169),bizcircleName: 后海},{bizcircleId: NumberInt(171),bizcircleName: 东单}],rankTitle: 二手楼盘均价}]},{title: 一手楼盘均价,submodules: [{_id: g_2,names: [商圈名称,成交均价(万/㎡)],type: rank,list: [{bizcircleId: NumberInt(209),bizcircleName: 紫竹院,value: 18.38},{bizcircleId: NumberInt(721),bizcircleName: 宣武门,value: 18},{bizcircleId: NumberInt(525),bizcircleName: 北海景山,value: 17.59},{bizcircleId: NumberInt(526),bizcircleName: 前门,value: 13.47},{bizcircleId: NumberInt(172),bizcircleName: 永定门,value: 12.87},{bizcircleId: NumberInt(163),bizcircleName: 东直门,value: 12.66},{bizcircleId: NumberInt(162),bizcircleName: 朝阳公园,value: 12.29},{bizcircleId: NumberInt(170),bizcircleName: 王府井,value: 12.15},{bizcircleId: NumberInt(186),bizcircleName: 太阳宫,value: 11.8},{bizcircleId: NumberInt(208),bizcircleName: 西山别墅区,value: 11.4},{bizcircleId: NumberInt(1343),bizcircleName: 分钟寺,value: 10.68},{bizcircleId: NumberInt(212),bizcircleName: 西北旺,value: 10.49},{bizcircleId: NumberInt(177),bizcircleName: 燕莎,value: 9.7},{bizcircleId: NumberInt(199),bizcircleName: 丽泽商务区,value: 9.68},{bizcircleId: NumberInt(206),bizcircleName: 西钓鱼台,value: 9.19},{bizcircleId: NumberInt(165),bizcircleName: 丽都,value: 8.99},{bizcircleId: NumberInt(166),bizcircleName: 望京,value: 8.98},{bizcircleId: NumberInt(185),bizcircleName: 管庄,value: 8.97},{bizcircleId: NumberInt(189),bizcircleName: 亚运村小营,value: 8.94},{bizcircleId: NumberInt(161),bizcircleName: CBD,value: 8.93},{bizcircleId: NumberInt(191),bizcircleName: 东坝,value: 8.9},{bizcircleId: NumberInt(201),bizcircleName: 大红门,value: 8.81},{bizcircleId: NumberInt(213),bizcircleName: 海淀北部新区,value: 8.73},{bizcircleId: NumberInt(765),bizcircleName: 北苑,value: 8.67},{bizcircleId: NumberInt(168),bizcircleName: 安定门,value: 8.57},{bizcircleId: NumberInt(943),bizcircleName: 孙河中央别墅区,value: 8.18},{bizcircleId: NumberInt(211),bizcircleName: 清河上地,value: 8.11},{bizcircleId: NumberInt(200),bizcircleName: 世界公园,value: 7.88},{bizcircleId: NumberInt(198),bizcircleName: 大兴城南别墅区,value: 6.87},{bizcircleId: NumberInt(942),bizcircleName: 大湖中央别墅区,value: 6.86},{bizcircleId: NumberInt(945),bizcircleName: 天竺中央别墅区,value: 6.8},{bizcircleId: NumberInt(216),bizcircleName: 石景山,value: 6.79},{bizcircleId: NumberInt(178),bizcircleName: 建国门,value: 6.49},{bizcircleId: NumberInt(197),bizcircleName: 亦庄开发区,value: 6.35},{bizcircleId: NumberInt(179),bizcircleName: 西大望路,value: 6.27},{bizcircleId: NumberInt(944),bizcircleName: 后沙峪中央别墅区,value: 6.2},{bizcircleId: NumberInt(164),bizcircleName: 工体,value: 6},{bizcircleId: NumberInt(196),bizcircleName: 通州新城,value: 5.79},{bizcircleId: NumberInt(195),bizcircleName: 通州别墅区,value: 5.54},{bizcircleId: NumberInt(215),bizcircleName: 昌平别墅区,value: 5.46},{bizcircleId: NumberInt(187),bizcircleName: 奥林匹克公园,value: 5.08},{bizcircleId: NumberInt(217),bizcircleName: 门头沟,value: 4.92},{bizcircleId: NumberInt(214),bizcircleName: 奥北别墅区,value: 3.88},{bizcircleId: NumberInt(202),bizcircleName: 燕西别墅区,value: 3.72},{bizcircleId: NumberInt(778),bizcircleName: 潮白河别墅区,value: 2.99},{bizcircleId: NumberInt(167),bizcircleName: 朝青},{bizcircleId: NumberInt(785),bizcircleName: 朝阳门},{bizcircleId: NumberInt(171),bizcircleName: 东单},{bizcircleId: NumberInt(173),bizcircleName: 崇文门},{bizcircleId: NumberInt(174),bizcircleName: 陶然亭},{bizcircleId: NumberInt(175),bizcircleName: 金融街},{bizcircleId: NumberInt(176),bizcircleName: 西直门外},{bizcircleId: NumberInt(180),bizcircleName: 双井},{bizcircleId: NumberInt(181),bizcircleName: 十八里店},{bizcircleId: NumberInt(182),bizcircleName: 小红门},{bizcircleId: NumberInt(183),bizcircleName: 高碑店},{bizcircleId: NumberInt(184),bizcircleName: 五方桥},{bizcircleId: NumberInt(188),bizcircleName: 奥体},{bizcircleId: NumberInt(192),bizcircleName: 姚家园},{bizcircleId: NumberInt(203),bizcircleName: 中关村},{bizcircleId: NumberInt(204),bizcircleName: 万柳},{bizcircleId: NumberInt(205),bizcircleName: 世纪城},{bizcircleId: NumberInt(207),bizcircleName: 玉渊潭},{bizcircleId: NumberInt(210),bizcircleName: 马甸},{bizcircleId: NumberInt(218),bizcircleName: 房山},{bizcircleId: NumberInt(219),bizcircleName: 密云},{bizcircleId: NumberInt(220),bizcircleName: 怀柔},{bizcircleId: NumberInt(221),bizcircleName: 延庆},{bizcircleId: NumberInt(222),bizcircleName: 平谷},{bizcircleId: NumberInt(521),bizcircleName: 中南海},{bizcircleId: NumberInt(522),bizcircleName: 新街口},{bizcircleId: NumberInt(523),bizcircleName: 白塔寺},{bizcircleId: NumberInt(524),bizcircleName: 西四},{bizcircleId: NumberInt(527),bizcircleName: 鼓楼},{bizcircleId: NumberInt(528),bizcircleName: 雍和宫北新桥},{bizcircleId: NumberInt(529),bizcircleName: 南锣鼓巷},{bizcircleId: NumberInt(530),bizcircleName: 东四},{bizcircleId: NumberInt(531),bizcircleName: 故宫南北池子},{bizcircleId: NumberInt(532),bizcircleName: 金宝街},{bizcircleId: NumberInt(767),bizcircleName: 泛CBD东别墅区},{bizcircleId: NumberInt(768),bizcircleName: 德胜门},{bizcircleId: NumberInt(769),bizcircleName: 故宫},{bizcircleId: NumberInt(772),bizcircleName: 雍和宫},{bizcircleId: NumberInt(782),bizcircleName: 西直门},{bizcircleId: NumberInt(169),bizcircleName: 后海}],rankTitle: 一手楼盘均价}]},{title: 二手房价涨幅,submodules: [{_id: g_3,names: [商圈名称,价格涨幅],type: rank,list: [{bizcircleId: NumberInt(942),bizcircleName: 大湖中央别墅区,value: 9.64%},{bizcircleId: NumberInt(205),bizcircleName: 世纪城,value: 9.55%},{bizcircleId: NumberInt(201),bizcircleName: 大红门,value: 6.84%},{bizcircleId: NumberInt(199),bizcircleName: 丽泽商务区,value: 6.53%},{bizcircleId: NumberInt(203),bizcircleName: 中关村,value: 4.54%},{bizcircleId: NumberInt(212),bizcircleName: 西北旺,value: 4.44%},{bizcircleId: NumberInt(206),bizcircleName: 西钓鱼台,value: 3.95%},{bizcircleId: NumberInt(214),bizcircleName: 奥北别墅区,value: 3.2%},{bizcircleId: NumberInt(944),bizcircleName: 后沙峪中央别墅区,value: 3.12%},{bizcircleId: NumberInt(165),bizcircleName: 丽都,value: 2.22%},{bizcircleId: NumberInt(197),bizcircleName: 亦庄开发区,value: 1.98%},{bizcircleId: NumberInt(945),bizcircleName: 天竺中央别墅区,value: 1.75%},{bizcircleId: NumberInt(207),bizcircleName: 玉渊潭,value: 1.73%},{bizcircleId: NumberInt(195),bizcircleName: 通州别墅区,value: 0.93%},{bizcircleId: NumberInt(943),bizcircleName: 孙河中央别墅区,value: 0.85%},{bizcircleId: NumberInt(187),bizcircleName: 奥林匹克公园,value: 0.08%},{bizcircleId: NumberInt(200),bizcircleName: 世界公园,value: 0},{bizcircleId: NumberInt(164),bizcircleName: 工体,value: 0},{bizcircleId: NumberInt(168),bizcircleName: 安定门,value: 0},{bizcircleId: NumberInt(170),bizcircleName: 王府井,value: 0},{bizcircleId: NumberInt(173),bizcircleName: 崇文门,value: 0},{bizcircleId: NumberInt(178),bizcircleName: 建国门,value: 0},{bizcircleId: NumberInt(183),bizcircleName: 高碑店,value: 0},{bizcircleId: NumberInt(184),bizcircleName: 五方桥,value: 0},{bizcircleId: NumberInt(196),bizcircleName: 通州新城,value: 0},{bizcircleId: NumberInt(198),bizcircleName: 大兴城南别墅区,value: 0},{bizcircleId: NumberInt(202),bizcircleName: 燕西别墅区,value: 0},{bizcircleId: NumberInt(532),bizcircleName: 金宝街,value: 0},{bizcircleId: NumberInt(721),bizcircleName: 宣武门,value: 0},{bizcircleId: NumberInt(765),bizcircleName: 北苑,value: 0},{bizcircleId: NumberInt(768),bizcircleName: 德胜门,value: 0},{bizcircleId: NumberInt(782),bizcircleName: 西直门,value: 0},{bizcircleId: NumberInt(216),bizcircleName: 石景山,value: -0.33%},{bizcircleId: NumberInt(166),bizcircleName: 望京,value: -0.44%},{bizcircleId: NumberInt(189),bizcircleName: 亚运村小营,value: -0.81%},{bizcircleId: NumberInt(186),bizcircleName: 太阳宫,value: -0.85%},{bizcircleId: NumberInt(167),bizcircleName: 朝青,value: -0.88%},{bizcircleId: NumberInt(177),bizcircleName: 燕莎,value: -1.16%},{bizcircleId: NumberInt(174),bizcircleName: 陶然亭,value: -1.57%},{bizcircleId: NumberInt(163),bizcircleName: 东直门,value: -1.75%},{bizcircleId: NumberInt(161),bizcircleName: CBD,value: -2.24%},{bizcircleId: NumberInt(179),bizcircleName: 西大望路,value: -2.31%},{bizcircleId: NumberInt(175),bizcircleName: 金融街,value: -2.32%},{bizcircleId: NumberInt(215),bizcircleName: 昌平别墅区,value: -2.75%},{bizcircleId: NumberInt(162),bizcircleName: 朝阳公园,value: -4.36%},{bizcircleId: NumberInt(211),bizcircleName: 清河上地,value: -4.37%},{bizcircleId: NumberInt(209),bizcircleName: 紫竹院,value: -4.94%},{bizcircleId: NumberInt(204),bizcircleName: 万柳,value: -6.9%},{bizcircleId: NumberInt(208),bizcircleName: 西山别墅区,value: -7.41%},{bizcircleId: NumberInt(191),bizcircleName: 东坝,value: -17.79%},{bizcircleId: NumberInt(525),bizcircleName: 北海景山,value: -17.92%},{bizcircleId: NumberInt(172),bizcircleName: 永定门,value: },{bizcircleId: NumberInt(192),bizcircleName: 姚家园,value: },{bizcircleId: NumberInt(210),bizcircleName: 马甸,value: },{bizcircleId: NumberInt(1343),bizcircleName: 分钟寺,value: },{bizcircleId: NumberInt(213),bizcircleName: 海淀北部新区,value: },{bizcircleId: NumberInt(171),bizcircleName: 东单,value: },{bizcircleId: NumberInt(169),bizcircleName: 后海,value: },{bizcircleId: NumberInt(217),bizcircleName: 门头沟,value: },{bizcircleId: NumberInt(218),bizcircleName: 房山,value: },{bizcircleId: NumberInt(219),bizcircleName: 密云,value: },{bizcircleId: NumberInt(220),bizcircleName: 怀柔,value: },{bizcircleId: NumberInt(221),bizcircleName: 延庆,value: },{bizcircleId: NumberInt(222),bizcircleName: 平谷,value: },{bizcircleId: NumberInt(521),bizcircleName: 中南海,value: },{bizcircleId: NumberInt(522),bizcircleName: 新街口,value: },{bizcircleId: NumberInt(523),bizcircleName: 白塔寺,value: },{bizcircleId: NumberInt(524),bizcircleName: 西四,value: },{bizcircleId: NumberInt(526),bizcircleName: 前门,value: },{bizcircleId: NumberInt(527),bizcircleName: 鼓楼,value: },{bizcircleId: NumberInt(528),bizcircleName: 雍和宫北新桥,value: },{bizcircleId: NumberInt(529),bizcircleName: 南锣鼓巷,value: },{bizcircleId: NumberInt(530),bizcircleName: 东四,value: },{bizcircleId: NumberInt(531),bizcircleName: 故宫南北池子,value: },{bizcircleId: NumberInt(767),bizcircleName: 泛CBD东别墅区,value: },{bizcircleId: NumberInt(769),bizcircleName: 故宫,value: },{bizcircleId: NumberInt(772),bizcircleName: 雍和宫,value: },{bizcircleId: NumberInt(778),bizcircleName: 潮白河别墅区,value: },{bizcircleId: NumberInt(785),bizcircleName: 朝阳门,value: },{bizcircleId: NumberInt(188),bizcircleName: 奥体,value: },{bizcircleId: NumberInt(176),bizcircleName: 西直门外,value: },{bizcircleId: NumberInt(185),bizcircleName: 管庄,value: },{bizcircleId: NumberInt(180),bizcircleName: 双井,value: },{bizcircleId: NumberInt(181),bizcircleName: 十八里店,value: },{bizcircleId: NumberInt(182),bizcircleName: 小红门,value: }],rankTitle: 二手房价涨幅}]},{title: 二手成交量,submodules: [{_id: g_4,names: [商圈名称,成交量(套)],type: rank,list: [{bizcircleId: NumberInt(179),bizcircleName: 西大望路,value: 23},{bizcircleId: NumberInt(161),bizcircleName: CBD,value: 17},{bizcircleId: NumberInt(162),bizcircleName: 朝阳公园,value: 14},{bizcircleId: NumberInt(186),bizcircleName: 太阳宫,value: 13},{bizcircleId: NumberInt(208),bizcircleName: 西山别墅区,value: 11},{bizcircleId: NumberInt(206),bizcircleName: 西钓鱼台,value: 10},{bizcircleId: NumberInt(165),bizcircleName: 丽都,value: 10},{bizcircleId: NumberInt(212),bizcircleName: 西北旺,value: 10},{bizcircleId: NumberInt(166),bizcircleName: 望京,value: 10},{bizcircleId: NumberInt(201),bizcircleName: 大红门,value: 9},{bizcircleId: NumberInt(944),bizcircleName: 后沙峪中央别墅区,value: 9},{bizcircleId: NumberInt(945),bizcircleName: 天竺中央别墅区,value: 9},{bizcircleId: NumberInt(163),bizcircleName: 东直门,value: 8},{bizcircleId: NumberInt(167),bizcircleName: 朝青,value: 7},{bizcircleId: NumberInt(204),bizcircleName: 万柳,value: 6},{bizcircleId: NumberInt(189),bizcircleName: 亚运村小营,value: 5},{bizcircleId: NumberInt(215),bizcircleName: 昌平别墅区,value: 5},{bizcircleId: NumberInt(177),bizcircleName: 燕莎,value: 4},{bizcircleId: NumberInt(203),bizcircleName: 中关村,value: 4},{bizcircleId: NumberInt(211),bizcircleName: 清河上地,value: 4},{bizcircleId: NumberInt(942),bizcircleName: 大湖中央别墅区,value: 4},{bizcircleId: NumberInt(174),bizcircleName: 陶然亭,value: 3},{bizcircleId: NumberInt(943),bizcircleName: 孙河中央别墅区,value: 3},{bizcircleId: NumberInt(195),bizcircleName: 通州别墅区,value: 3},{bizcircleId: NumberInt(175),bizcircleName: 金融街,value: 3},{bizcircleId: NumberInt(187),bizcircleName: 奥林匹克公园,value: 3},{bizcircleId: NumberInt(214),bizcircleName: 奥北别墅区,value: 3},{bizcircleId: NumberInt(191),bizcircleName: 东坝,value: 2},{bizcircleId: NumberInt(197),bizcircleName: 亦庄开发区,value: 2},{bizcircleId: NumberInt(205),bizcircleName: 世纪城,value: 2},{bizcircleId: NumberInt(199),bizcircleName: 丽泽商务区,value: 1},{bizcircleId: NumberInt(216),bizcircleName: 石景山,value: 1},{bizcircleId: NumberInt(525),bizcircleName: 北海景山,value: 1},{bizcircleId: NumberInt(207),bizcircleName: 玉渊潭,value: 1},{bizcircleId: NumberInt(209),bizcircleName: 紫竹院,value: 1},{bizcircleId: NumberInt(200),bizcircleName: 世界公园,value: 0},{bizcircleId: NumberInt(164),bizcircleName: 工体,value: 0},{bizcircleId: NumberInt(168),bizcircleName: 安定门,value: 0},{bizcircleId: NumberInt(170),bizcircleName: 王府井,value: 0},{bizcircleId: NumberInt(172),bizcircleName: 永定门,value: 0},{bizcircleId: NumberInt(173),bizcircleName: 崇文门,value: 0},{bizcircleId: NumberInt(178),bizcircleName: 建国门,value: 0},{bizcircleId: NumberInt(182),bizcircleName: 小红门,value: 0},{bizcircleId: NumberInt(183),bizcircleName: 高碑店,value: 0},{bizcircleId: NumberInt(184),bizcircleName: 五方桥,value: 0},{bizcircleId: NumberInt(185),bizcircleName: 管庄,value: 0},{bizcircleId: NumberInt(196),bizcircleName: 通州新城,value: 0},{bizcircleId: NumberInt(198),bizcircleName: 大兴城南别墅区,value: 0},{bizcircleId: NumberInt(202),bizcircleName: 燕西别墅区,value: 0},{bizcircleId: NumberInt(210),bizcircleName: 马甸,value: 0},{bizcircleId: NumberInt(213),bizcircleName: 海淀北部新区,value: 0},{bizcircleId: NumberInt(217),bizcircleName: 门头沟,value: 0},{bizcircleId: NumberInt(220),bizcircleName: 怀柔,value: 0},{bizcircleId: NumberInt(221),bizcircleName: 延庆,value: 0},{bizcircleId: NumberInt(522),bizcircleName: 新街口,value: 0},{bizcircleId: NumberInt(526),bizcircleName: 前门,value: 0},{bizcircleId: NumberInt(532),bizcircleName: 金宝街,value: 0},{bizcircleId: NumberInt(721),bizcircleName: 宣武门,value: 0},{bizcircleId: NumberInt(765),bizcircleName: 北苑,value: 0},{bizcircleId: NumberInt(768),bizcircleName: 德胜门,value: 0},{bizcircleId: NumberInt(778),bizcircleName: 潮白河别墅区,value: 0},{bizcircleId: NumberInt(782),bizcircleName: 西直门,value: 0},{bizcircleId: NumberInt(1343),bizcircleName: 分钟寺,value: 0},{bizcircleId: NumberInt(169),bizcircleName: 后海},{bizcircleId: NumberInt(785),bizcircleName: 朝阳门},{bizcircleId: NumberInt(176),bizcircleName: 西直门外},{bizcircleId: NumberInt(180),bizcircleName: 双井},{bizcircleId: NumberInt(181),bizcircleName: 十八里店},{bizcircleId: NumberInt(188),bizcircleName: 奥体},{bizcircleId: NumberInt(192),bizcircleName: 姚家园},{bizcircleId: NumberInt(218),bizcircleName: 房山},{bizcircleId: NumberInt(219),bizcircleName: 密云},{bizcircleId: NumberInt(222),bizcircleName: 平谷},{bizcircleId: NumberInt(521),bizcircleName: 中南海},{bizcircleId: NumberInt(523),bizcircleName: 白塔寺},{bizcircleId: NumberInt(524),bizcircleName: 西四},{bizcircleId: NumberInt(527),bizcircleName: 鼓楼},{bizcircleId: NumberInt(528),bizcircleName: 雍和宫北新桥},{bizcircleId: NumberInt(529),bizcircleName: 南锣鼓巷},{bizcircleId: NumberInt(530),bizcircleName: 东四},{bizcircleId: NumberInt(531),bizcircleName: 故宫南北池子},{bizcircleId: NumberInt(767),bizcircleName: 泛CBD东别墅区},{bizcircleId: NumberInt(769),bizcircleName: 故宫},{bizcircleId: NumberInt(772),bizcircleName: 雍和宫},{bizcircleId: NumberInt(171),bizcircleName: 东单}],rankTitle: 二手成交量}]},{title: 一手成交量,submodules: [{_id: g_5,names: [商圈名称,成交量(套)],type: rank,list: [{bizcircleId: NumberInt(214),bizcircleName: 奥北别墅区,value: 49},{bizcircleId: NumberInt(177),bizcircleName: 燕莎,value: 41},{bizcircleId: NumberInt(172),bizcircleName: 永定门,value: 40},{bizcircleId: NumberInt(199),bizcircleName: 丽泽商务区,value: 34},{bizcircleId: NumberInt(216),bizcircleName: 石景山,value: 18},{bizcircleId: NumberInt(162),bizcircleName: 朝阳公园,value: 13},{bizcircleId: NumberInt(944),bizcircleName: 后沙峪中央别墅区,value: 10},{bizcircleId: NumberInt(1343),bizcircleName: 分钟寺,value: 8},{bizcircleId: NumberInt(943),bizcircleName: 孙河中央别墅区,value: 8},{bizcircleId: NumberInt(765),bizcircleName: 北苑,value: 4},{bizcircleId: NumberInt(201),bizcircleName: 大红门,value: 4},{bizcircleId: NumberInt(166),bizcircleName: 望京,value: 3},{bizcircleId: NumberInt(195),bizcircleName: 通州别墅区,value: 3},{bizcircleId: NumberInt(206),bizcircleName: 西钓鱼台,value: 2},{bizcircleId: NumberInt(211),bizcircleName: 清河上地,value: 2},{bizcircleId: NumberInt(197),bizcircleName: 亦庄开发区,value: 1},{bizcircleId: NumberInt(198),bizcircleName: 大兴城南别墅区,value: 1},{bizcircleId: NumberInt(202),bizcircleName: 燕西别墅区,value: 1},{bizcircleId: NumberInt(945),bizcircleName: 天竺中央别墅区,value: 1},{bizcircleId: NumberInt(212),bizcircleName: 西北旺,value: 1},{bizcircleId: NumberInt(721),bizcircleName: 宣武门,value: 1},{bizcircleId: NumberInt(208),bizcircleName: 西山别墅区,value: 1},{bizcircleId: NumberInt(200),bizcircleName: 世界公园,value: 0},{bizcircleId: NumberInt(942),bizcircleName: 大湖中央别墅区,value: 0},{bizcircleId: NumberInt(163),bizcircleName: 东直门,value: 0},{bizcircleId: NumberInt(164),bizcircleName: 工体,value: 0},{bizcircleId: NumberInt(165),bizcircleName: 丽都,value: 0},{bizcircleId: NumberInt(167),bizcircleName: 朝青,value: 0},{bizcircleId: NumberInt(168),bizcircleName: 安定门,value: 0},{bizcircleId: NumberInt(170),bizcircleName: 王府井,value: 0},{bizcircleId: NumberInt(173),bizcircleName: 崇文门,value: 0},{bizcircleId: NumberInt(174),bizcircleName: 陶然亭,value: 0},{bizcircleId: NumberInt(175),bizcircleName: 金融街,value: 0},{bizcircleId: NumberInt(178),bizcircleName: 建国门,value: 0},{bizcircleId: NumberInt(179),bizcircleName: 西大望路,value: 0},{bizcircleId: NumberInt(182),bizcircleName: 小红门,value: 0},{bizcircleId: NumberInt(183),bizcircleName: 高碑店,value: 0},{bizcircleId: NumberInt(184),bizcircleName: 五方桥,value: 0},{bizcircleId: NumberInt(185),bizcircleName: 管庄,value: 0},{bizcircleId: NumberInt(186),bizcircleName: 太阳宫,value: 0},{bizcircleId: NumberInt(187),bizcircleName: 奥林匹克公园,value: 0},{bizcircleId: NumberInt(189),bizcircleName: 亚运村小营,value: 0},{bizcircleId: NumberInt(191),bizcircleName: 东坝,value: 0},{bizcircleId: NumberInt(196),bizcircleName: 通州新城,value: 0},{bizcircleId: NumberInt(203),bizcircleName: 中关村,value: 0},{bizcircleId: NumberInt(204),bizcircleName: 万柳,value: 0},{bizcircleId: NumberInt(205),bizcircleName: 世纪城,value: 0},{bizcircleId: NumberInt(207),bizcircleName: 玉渊潭,value: 0},{bizcircleId: NumberInt(209),bizcircleName: 紫竹院,value: 0},{bizcircleId: NumberInt(210),bizcircleName: 马甸,value: 0},{bizcircleId: NumberInt(213),bizcircleName: 海淀北部新区,value: 0},{bizcircleId: NumberInt(215),bizcircleName: 昌平别墅区,value: 0},{bizcircleId: NumberInt(217),bizcircleName: 门头沟,value: 0},{bizcircleId: NumberInt(220),bizcircleName: 怀柔,value: 0},{bizcircleId: NumberInt(221),bizcircleName: 延庆,value: 0},{bizcircleId: NumberInt(522),bizcircleName: 新街口,value: 0},{bizcircleId: NumberInt(525),bizcircleName: 北海景山,value: 0},{bizcircleId: NumberInt(526),bizcircleName: 前门,value: 0},{bizcircleId: NumberInt(532),bizcircleName: 金宝街,value: 0},{bizcircleId: NumberInt(768),bizcircleName: 德胜门,value: 0},{bizcircleId: NumberInt(778),bizcircleName: 潮白河别墅区,value: 0},{bizcircleId: NumberInt(782),bizcircleName: 西直门,value: 0},{bizcircleId: NumberInt(161),bizcircleName: CBD,value: 0},{bizcircleId: NumberInt(169),bizcircleName: 后海},{bizcircleId: NumberInt(785),bizcircleName: 朝阳门},{bizcircleId: NumberInt(176),bizcircleName: 西直门外},{bizcircleId: NumberInt(180),bizcircleName: 双井},{bizcircleId: NumberInt(181),bizcircleName: 十八里店},{bizcircleId: NumberInt(188),bizcircleName: 奥体},{bizcircleId: NumberInt(192),bizcircleName: 姚家园},{bizcircleId: NumberInt(218),bizcircleName: 房山},{bizcircleId: NumberInt(219),bizcircleName: 密云},{bizcircleId: NumberInt(222),bizcircleName: 平谷},{bizcircleId: NumberInt(521),bizcircleName: 中南海},{bizcircleId: NumberInt(523),bizcircleName: 白塔寺},{bizcircleId: NumberInt(524),bizcircleName: 西四},{bizcircleId: NumberInt(527),bizcircleName: 鼓楼},{bizcircleId: NumberInt(528),bizcircleName: 雍和宫北新桥},{bizcircleId: NumberInt(529),bizcircleName: 南锣鼓巷},{bizcircleId: NumberInt(530),bizcircleName: 东四},{bizcircleId: NumberInt(531),bizcircleName: 故宫南北池子},{bizcircleId: NumberInt(767),bizcircleName: 泛CBD东别墅区},{bizcircleId: NumberInt(769),bizcircleName: 故宫},{bizcircleId: NumberInt(772),bizcircleName: 雍和宫},{bizcircleId: NumberInt(171),bizcircleName: 东单}],rankTitle: 一手成交量}]},{title: 换手率,submodules: [{_id: g_6,names: [商圈名称,换手率],type: rank,list: [{bizcircleId: NumberInt(184),bizcircleName: 五方桥,value: 11%},{bizcircleId: NumberInt(211),bizcircleName: 清河上地,value: 9%},{bizcircleId: NumberInt(525),bizcircleName: 北海景山,value: 8%},{bizcircleId: NumberInt(168),bizcircleName: 安定门,value: 7%},{bizcircleId: NumberInt(216),bizcircleName: 石景山,value: 4%},{bizcircleId: NumberInt(944),bizcircleName: 后沙峪中央别墅区,value: 4%},{bizcircleId: NumberInt(532),bizcircleName: 金宝街,value: 4%},{bizcircleId: NumberInt(179),bizcircleName: 西大望路,value: 4%},{bizcircleId: NumberInt(942),bizcircleName: 大湖中央别墅区,value: 4%},{bizcircleId: NumberInt(191),bizcircleName: 东坝,value: 4%},{bizcircleId: NumberInt(195),bizcircleName: 通州别墅区,value: 4%},{bizcircleId: NumberInt(167),bizcircleName: 朝青,value: 4%},{bizcircleId: NumberInt(165),bizcircleName: 丽都,value: 4%},{bizcircleId: NumberInt(198),bizcircleName: 大兴城南别墅区,value: 3%},{bizcircleId: NumberInt(189),bizcircleName: 亚运村小营,value: 3%},{bizcircleId: NumberInt(186),bizcircleName: 太阳宫,value: 3%},{bizcircleId: NumberInt(170),bizcircleName: 王府井,value: 3%},{bizcircleId: NumberInt(163),bizcircleName: 东直门,value: 3%},{bizcircleId: NumberInt(945),bizcircleName: 天竺中央别墅区,value: 3%},{bizcircleId: NumberInt(161),bizcircleName: CBD,value: 3%},{bizcircleId: NumberInt(162),bizcircleName: 朝阳公园,value: 3%},{bizcircleId: NumberInt(943),bizcircleName: 孙河中央别墅区,value: 3%},{bizcircleId: NumberInt(782),bizcircleName: 西直门,value: 3%},{bizcircleId: NumberInt(765),bizcircleName: 北苑,value: 3%},{bizcircleId: NumberInt(215),bizcircleName: 昌平别墅区,value: 3%},{bizcircleId: NumberInt(208),bizcircleName: 西山别墅区,value: 3%},{bizcircleId: NumberInt(206),bizcircleName: 西钓鱼台,value: 3%},{bizcircleId: NumberInt(209),bizcircleName: 紫竹院,value: 2%},{bizcircleId: NumberInt(199),bizcircleName: 丽泽商务区,value: 2%},{bizcircleId: NumberInt(212),bizcircleName: 西北旺,value: 2%},{bizcircleId: NumberInt(214),bizcircleName: 奥北别墅区,value: 2%},{bizcircleId: NumberInt(164),bizcircleName: 工体,value: 2%},{bizcircleId: NumberInt(187),bizcircleName: 奥林匹克公园,value: 2%},{bizcircleId: NumberInt(178),bizcircleName: 建国门,value: 2%},{bizcircleId: NumberInt(177),bizcircleName: 燕莎,value: 2%},{bizcircleId: NumberInt(768),bizcircleName: 德胜门,value: 2%},{bizcircleId: NumberInt(166),bizcircleName: 望京,value: 2%},{bizcircleId: NumberInt(205),bizcircleName: 世纪城,value: 2%},{bizcircleId: NumberInt(204),bizcircleName: 万柳,value: 2%},{bizcircleId: NumberInt(203),bizcircleName: 中关村,value: 2%},{bizcircleId: NumberInt(201),bizcircleName: 大红门,value: 2%},{bizcircleId: NumberInt(197),bizcircleName: 亦庄开发区,value: 2%},{bizcircleId: NumberInt(200),bizcircleName: 世界公园,value: 1%},{bizcircleId: NumberInt(173),bizcircleName: 崇文门,value: 1%},{bizcircleId: NumberInt(174),bizcircleName: 陶然亭,value: 1%},{bizcircleId: NumberInt(175),bizcircleName: 金融街,value: 1%},{bizcircleId: NumberInt(196),bizcircleName: 通州新城,value: 1%},{bizcircleId: NumberInt(207),bizcircleName: 玉渊潭,value: 1%},{bizcircleId: NumberInt(721),bizcircleName: 宣武门,value: 1%},{bizcircleId: NumberInt(169),bizcircleName: 后海,value: --},{bizcircleId: NumberInt(1343),bizcircleName: 分钟寺,value: --},{bizcircleId: NumberInt(172),bizcircleName: 永定门,value: --},{bizcircleId: NumberInt(176),bizcircleName: 西直门外,value: --},{bizcircleId: NumberInt(180),bizcircleName: 双井,value: --},{bizcircleId: NumberInt(181),bizcircleName: 十八里店,value: --},{bizcircleId: NumberInt(182),bizcircleName: 小红门,value: --},{bizcircleId: NumberInt(183),bizcircleName: 高碑店,value: --},{bizcircleId: NumberInt(185),bizcircleName: 管庄,value: --},{bizcircleId: NumberInt(188),bizcircleName: 奥体,value: --},{bizcircleId: NumberInt(192),bizcircleName: 姚家园,value: --},{bizcircleId: NumberInt(202),bizcircleName: 燕西别墅区,value: --},{bizcircleId: NumberInt(210),bizcircleName: 马甸,value: --},{bizcircleId: NumberInt(213),bizcircleName: 海淀北部新区,value: --},{bizcircleId: NumberInt(217),bizcircleName: 门头沟,value: --},{bizcircleId: NumberInt(218),bizcircleName: 房山,value: --},{bizcircleId: NumberInt(219),bizcircleName: 密云,value: --},{bizcircleId: NumberInt(220),bizcircleName: 怀柔,value: --},{bizcircleId: NumberInt(221),bizcircleName: 延庆,value: --},{bizcircleId: NumberInt(222),bizcircleName: 平谷,value: --},{bizcircleId: NumberInt(521),bizcircleName: 中南海,value: --},{bizcircleId: NumberInt(522),bizcircleName: 新街口,value: --},{bizcircleId: NumberInt(523),bizcircleName: 白塔寺,value: --},{bizcircleId: NumberInt(524),bizcircleName: 西四,value: --},{bizcircleId: NumberInt(526),bizcircleName: 前门,value: --},{bizcircleId: NumberInt(527),bizcircleName: 鼓楼,value: --},{bizcircleId: NumberInt(528),bizcircleName: 雍和宫北新桥,value: --},{bizcircleId: NumberInt(529),bizcircleName: 南锣鼓巷,value: --},{bizcircleId: NumberInt(530),bizcircleName: 东四,value: --},{bizcircleId: NumberInt(531),bizcircleName: 故宫南北池子,value: --},{bizcircleId: NumberInt(767),bizcircleName: 泛CBD东别墅区,value: --},{bizcircleId: NumberInt(769),bizcircleName: 故宫,value: --},{bizcircleId: NumberInt(772),bizcircleName: 雍和宫,value: --},{bizcircleId: NumberInt(778),bizcircleName: 潮白河别墅区,value: --},{bizcircleId: NumberInt(785),bizcircleName: 朝阳门,value: --},{bizcircleId: NumberInt(171),bizcircleName: 东单,value: --}],rankTitle: 换手率}]},{title: 单位租金,submodules: [{_id: g_7,names: [商圈名称,单位租金(元/㎡/月)],type: rank,list: [{bizcircleId: NumberInt(175),bizcircleName: 金融街,value: 357},{bizcircleId: NumberInt(721),bizcircleName: 宣武门,value: 339},{bizcircleId: NumberInt(206),bizcircleName: 西钓鱼台,value: 329},{bizcircleId: NumberInt(204),bizcircleName: 万柳,value: 322},{bizcircleId: NumberInt(177),bizcircleName: 燕莎,value: 292},{bizcircleId: NumberInt(768),bizcircleName: 德胜门,value: 277},{bizcircleId: NumberInt(170),bizcircleName: 王府井,value: 271},{bizcircleId: NumberInt(161),bizcircleName: CBD,value: 252},{bizcircleId: NumberInt(199),bizcircleName: 丽泽商务区,value: 244},{bizcircleId: NumberInt(189),bizcircleName: 亚运村小营,value: 243},{bizcircleId: NumberInt(942),bizcircleName: 大湖中央别墅区,value: 230},{bizcircleId: NumberInt(215),bizcircleName: 昌平别墅区,value: 228},{bizcircleId: NumberInt(163),bizcircleName: 东直门,value: 226},{bizcircleId: NumberInt(203),bizcircleName: 中关村,value: 226},{bizcircleId: NumberInt(179),bizcircleName: 西大望路,value: 214},{bizcircleId: NumberInt(945),bizcircleName: 天竺中央别墅区,value: 206},{bizcircleId: NumberInt(943),bizcircleName: 孙河中央别墅区,value: 204},{bizcircleId: NumberInt(208),bizcircleName: 西山别墅区,value: 202},{bizcircleId: NumberInt(162),bizcircleName: 朝阳公园,value: 199},{bizcircleId: NumberInt(191),bizcircleName: 东坝,value: 191},{bizcircleId: NumberInt(165),bizcircleName: 丽都,value: 190},{bizcircleId: NumberInt(209),bizcircleName: 紫竹院,value: 189},{bizcircleId: NumberInt(166),bizcircleName: 望京,value: 187},{bizcircleId: NumberInt(201),bizcircleName: 大红门,value: 179},{bizcircleId: NumberInt(186),bizcircleName: 太阳宫,value: 177},{bizcircleId: NumberInt(187),bizcircleName: 奥林匹克公园,value: 172},{bizcircleId: NumberInt(195),bizcircleName: 通州别墅区,value: 159},{bizcircleId: NumberInt(167),bizcircleName: 朝青,value: 154},{bizcircleId: NumberInt(944),bizcircleName: 后沙峪中央别墅区,value: 145},{bizcircleId: NumberInt(212),bizcircleName: 西北旺,value: 134},{bizcircleId: NumberInt(198),bizcircleName: 大兴城南别墅区,value: 123},{bizcircleId: NumberInt(765),bizcircleName: 北苑,value: 121},{bizcircleId: NumberInt(214),bizcircleName: 奥北别墅区,value: 110},{bizcircleId: NumberInt(200),bizcircleName: 世界公园},{bizcircleId: NumberInt(164),bizcircleName: 工体},{bizcircleId: NumberInt(168),bizcircleName: 安定门},{bizcircleId: NumberInt(169),bizcircleName: 后海},{bizcircleId: NumberInt(171),bizcircleName: 东单},{bizcircleId: NumberInt(172),bizcircleName: 永定门},{bizcircleId: NumberInt(173),bizcircleName: 崇文门},{bizcircleId: NumberInt(174),bizcircleName: 陶然亭},{bizcircleId: NumberInt(176),bizcircleName: 西直门外},{bizcircleId: NumberInt(178),bizcircleName: 建国门},{bizcircleId: NumberInt(180),bizcircleName: 双井},{bizcircleId: NumberInt(181),bizcircleName: 十八里店},{bizcircleId: NumberInt(182),bizcircleName: 小红门},{bizcircleId: NumberInt(183),bizcircleName: 高碑店},{bizcircleId: NumberInt(184),bizcircleName: 五方桥},{bizcircleId: NumberInt(185),bizcircleName: 管庄},{bizcircleId: NumberInt(188),bizcircleName: 奥体},{bizcircleId: NumberInt(192),bizcircleName: 姚家园},{bizcircleId: NumberInt(196),bizcircleName: 通州新城},{bizcircleId: NumberInt(197),bizcircleName: 亦庄开发区},{bizcircleId: NumberInt(202),bizcircleName: 燕西别墅区},{bizcircleId: NumberInt(205),bizcircleName: 世纪城},{bizcircleId: NumberInt(207),bizcircleName: 玉渊潭},{bizcircleId: NumberInt(210),bizcircleName: 马甸},{bizcircleId: NumberInt(211),bizcircleName: 清河上地},{bizcircleId: NumberInt(213),bizcircleName: 海淀北部新区},{bizcircleId: NumberInt(216),bizcircleName: 石景山},{bizcircleId: NumberInt(217),bizcircleName: 门头沟},{bizcircleId: NumberInt(218),bizcircleName: 房山},{bizcircleId: NumberInt(219),bizcircleName: 密云},{bizcircleId: NumberInt(220),bizcircleName: 怀柔},{bizcircleId: NumberInt(221),bizcircleName: 延庆},{bizcircleId: NumberInt(222),bizcircleName: 平谷},{bizcircleId: NumberInt(521),bizcircleName: 中南海},{bizcircleId: NumberInt(522),bizcircleName: 新街口},{bizcircleId: NumberInt(523),bizcircleName: 白塔寺},{bizcircleId: NumberInt(524),bizcircleName: 西四},{bizcircleId: NumberInt(525),bizcircleName: 北海景山},{bizcircleId: NumberInt(526),bizcircleName: 前门},{bizcircleId: NumberInt(527),bizcircleName: 鼓楼},{bizcircleId: NumberInt(528),bizcircleName: 雍和宫北新桥},{bizcircleId: NumberInt(529),bizcircleName: 南锣鼓巷},{bizcircleId: NumberInt(530),bizcircleName: 东四},{bizcircleId: NumberInt(531),bizcircleName: 故宫南北池子},{bizcircleId: NumberInt(532),bizcircleName: 金宝街},{bizcircleId: NumberInt(767),bizcircleName: 泛CBD东别墅区},{bizcircleId: NumberInt(769),bizcircleName: 故宫},{bizcircleId: NumberInt(772),bizcircleName: 雍和宫},{bizcircleId: NumberInt(778),bizcircleName: 潮白河别墅区},{bizcircleId: NumberInt(782),bizcircleName: 西直门},{bizcircleId: NumberInt(785),bizcircleName: 朝阳门},{bizcircleId: NumberInt(1343),bizcircleName: 分钟寺}],rankTitle: 单位租金}]},{title: 租金回报率,submodules: [{_id: g_8,names: [商圈名称,租金回报率],type: rank,list: [{bizcircleId: NumberInt(215),bizcircleName: 昌平别墅区,value: 3.93%},{bizcircleId: NumberInt(206),bizcircleName: 西钓鱼台,value: 3.57%},{bizcircleId: NumberInt(191),bizcircleName: 东坝,value: 3.54%},{bizcircleId: NumberInt(943),bizcircleName: 孙河中央别墅区,value: 3.46%},{bizcircleId: NumberInt(945),bizcircleName: 天竺中央别墅区,value: 3.3%},{bizcircleId: NumberInt(179),bizcircleName: 西大望路,value: 3.17%},{bizcircleId: NumberInt(942),bizcircleName: 大湖中央别墅区,value: 3.04%},{bizcircleId: NumberInt(161),bizcircleName: CBD,value: 3.02%},{bizcircleId: NumberInt(195),bizcircleName: 通州别墅区,value: 2.99%},{bizcircleId: NumberInt(177),bizcircleName: 燕莎,value: 2.89%},{bizcircleId: NumberInt(165),bizcircleName: 丽都,value: 2.75%},{bizcircleId: NumberInt(170),bizcircleName: 王府井,value: 2.74%},{bizcircleId: NumberInt(189),bizcircleName: 亚运村小营,value: 2.66%},{bizcircleId: NumberInt(944),bizcircleName: 后沙峪中央别墅区,value: 2.48%},{bizcircleId: NumberInt(198),bizcircleName: 大兴城南别墅区,value: 2.42%},{bizcircleId: NumberInt(721),bizcircleName: 宣武门,value: 2.35%},{bizcircleId: NumberInt(163),bizcircleName: 东直门,value: 2.31%},{bizcircleId: NumberInt(201),bizcircleName: 大红门,value: 2.29%},{bizcircleId: NumberInt(162),bizcircleName: 朝阳公园,value: 2.21%},{bizcircleId: NumberInt(208),bizcircleName: 西山别墅区,value: 2.18%},{bizcircleId: NumberInt(199),bizcircleName: 丽泽商务区,value: 2.09%},{bizcircleId: NumberInt(214),bizcircleName: 奥北别墅区,value: 2.08%},{bizcircleId: NumberInt(167),bizcircleName: 朝青,value: 2.05%},{bizcircleId: NumberInt(166),bizcircleName: 望京,value: 1.98%},{bizcircleId: NumberInt(175),bizcircleName: 金融街,value: 1.97%},{bizcircleId: NumberInt(203),bizcircleName: 中关村,value: 1.91%},{bizcircleId: NumberInt(768),bizcircleName: 德胜门,value: 1.83%},{bizcircleId: NumberInt(186),bizcircleName: 太阳宫,value: 1.82%},{bizcircleId: NumberInt(187),bizcircleName: 奥林匹克公园,value: 1.74%},{bizcircleId: NumberInt(209),bizcircleName: 紫竹院,value: 1.71%},{bizcircleId: NumberInt(204),bizcircleName: 万柳,value: 1.55%},{bizcircleId: NumberInt(765),bizcircleName: 北苑,value: 1.54%},{bizcircleId: NumberInt(212),bizcircleName: 西北旺,value: 1.29%},{bizcircleId: NumberInt(200),bizcircleName: 世界公园},{bizcircleId: NumberInt(164),bizcircleName: 工体},{bizcircleId: NumberInt(168),bizcircleName: 安定门},{bizcircleId: NumberInt(169),bizcircleName: 后海},{bizcircleId: NumberInt(171),bizcircleName: 东单},{bizcircleId: NumberInt(172),bizcircleName: 永定门},{bizcircleId: NumberInt(173),bizcircleName: 崇文门},{bizcircleId: NumberInt(174),bizcircleName: 陶然亭},{bizcircleId: NumberInt(176),bizcircleName: 西直门外},{bizcircleId: NumberInt(178),bizcircleName: 建国门},{bizcircleId: NumberInt(180),bizcircleName: 双井},{bizcircleId: NumberInt(181),bizcircleName: 十八里店},{bizcircleId: NumberInt(182),bizcircleName: 小红门},{bizcircleId: NumberInt(183),bizcircleName: 高碑店},{bizcircleId: NumberInt(184),bizcircleName: 五方桥},{bizcircleId: NumberInt(185),bizcircleName: 管庄},{bizcircleId: NumberInt(188),bizcircleName: 奥体},{bizcircleId: NumberInt(192),bizcircleName: 姚家园},{bizcircleId: NumberInt(196),bizcircleName: 通州新城},{bizcircleId: NumberInt(197),bizcircleName: 亦庄开发区},{bizcircleId: NumberInt(202),bizcircleName: 燕西别墅区},{bizcircleId: NumberInt(205),bizcircleName: 世纪城},{bizcircleId: NumberInt(207),bizcircleName: 玉渊潭},{bizcircleId: NumberInt(210),bizcircleName: 马甸},{bizcircleId: NumberInt(211),bizcircleName: 清河上地},{bizcircleId: NumberInt(213),bizcircleName: 海淀北部新区},{bizcircleId: NumberInt(216),bizcircleName: 石景山},{bizcircleId: NumberInt(217),bizcircleName: 门头沟},{bizcircleId: NumberInt(218),bizcircleName: 房山},{bizcircleId: NumberInt(219),bizcircleName: 密云},{bizcircleId: NumberInt(220),bizcircleName: 怀柔},{bizcircleId: NumberInt(221),bizcircleName: 延庆},{bizcircleId: NumberInt(222),bizcircleName: 平谷},{bizcircleId: NumberInt(521),bizcircleName: 中南海},{bizcircleId: NumberInt(522),bizcircleName: 新街口},{bizcircleId: NumberInt(523),bizcircleName: 白塔寺},{bizcircleId: NumberInt(524),bizcircleName: 西四},{bizcircleId: NumberInt(525),bizcircleName: 北海景山},{bizcircleId: NumberInt(526),bizcircleName: 前门},{bizcircleId: NumberInt(527),bizcircleName: 鼓楼},{bizcircleId: NumberInt(528),bizcircleName: 雍和宫北新桥},{bizcircleId: NumberInt(529),bizcircleName: 南锣鼓巷},{bizcircleId: NumberInt(530),bizcircleName: 东四},{bizcircleId: NumberInt(531),bizcircleName: 故宫南北池子},{bizcircleId: NumberInt(532),bizcircleName: 金宝街},{bizcircleId: NumberInt(767),bizcircleName: 泛CBD东别墅区},{bizcircleId: NumberInt(769),bizcircleName: 故宫},{bizcircleId: NumberInt(772),bizcircleName: 雍和宫},{bizcircleId: NumberInt(778),bizcircleName: 潮白河别墅区},{bizcircleId: NumberInt(782),bizcircleName: 西直门},{bizcircleId: NumberInt(785),bizcircleName: 朝阳门},{bizcircleId: NumberInt(1343),bizcircleName: 分钟寺}],rankTitle: 租金回报率}]}],id: tabs_g,type: tabs,_class: com.test.job.marketreport.document.ReportSubmoduleTabs}],_class: com.test.job.marketreport.document.ReportModule},{id: h,code: h,displayName: 封底,_class: com.test.job.marketreport.document.ReportModule}],reportType: 208700000001,reportAttr: bizcircle,reportOrder: NumberInt(20243),reportTimeName2: 1月豪宅市场兹讯,districtId: 110105,month: 01,letter: ,share: ,_class: com.alibaba.fastjson.JSONObject
}三、Mongo导出SQL(失败)
我要取modules数组中第三部分整体价值介绍中submodules数组的第一个数组下submodules数组下metrics下的value值试着SQL写了很多次感觉就是一直点下去的事但尝试着总不行。以下是我的几个尝试
第一个这种写法各种改都不行
db.getCollection(bizcircleReport).find({ reportOrder: { $gt: 202103 } }, { modules.2.submodules.0.submodules.0.metrics.value: 1, _id: 0 });db.getCollection(bizcircleReport).find({ reportOrder: { $gt: 20213 }, reportType: 208700000001 },{ cityCode: 1,year: 1, month: 1, districtName: 1,bizcircleId: 1,bizcircleName: 1,reportOrder:1,_id: 0,modules: { $slice: 3},modules.2: 1 }
); 四、代码导出
先用modules: { $slice: 3}筛检一部分数据导出为json格式的然后代码读取把每个值用英文逗号分割保存为csv就是一个格一个值了 String fileName C:\\Users\\11562\\Desktop\\report.csv;FileWriter fileWriter new FileWriter(fileName);BufferedWriter bufferedWriter new BufferedWriter(fileWriter);bufferedWriter.write(城市,年,月,区域,商圈,二手楼盘均价(万/㎡),一手楼盘均价(万/㎡),二手成交量(套),一手成交量(套),换手率,单位租金(元/㎡/月),租金回报率);bufferedWriter.newLine();String path C:\\Users\\11562\\Documents\\WXWork\\1688852348837010\\Cache\\File\\2024-04\\Result_1.json;BufferedReader reader new BufferedReader(new InputStreamReader(new FileInputStream(path)));String json reader.lines().collect(Collectors.joining());JSONArray jsonArray JSONObject.parseArray(json);for (Object o : jsonArray) {JSONObject itemJson (JSONObject) o;Integer year itemJson.getInteger(year);Integer month itemJson.getInteger(month);Integer cityCode itemJson.getInteger(cityCode);String districtName itemJson.getString(districtName);String bizcircleName itemJson.getString(bizcircleName);if (year 2021 || (year 2021 month3)){continue;}JSONArray modules itemJson.getJSONArray(modules);//整体价值介绍JSONObject modules3 (JSONObject)modules.get(2);JSONArray submodules1 modules3.getJSONArray(submodules);JSONObject submodules2 (JSONObject)submodules1.get(0);//成交均价JSONObject metrics1 (JSONObject)submodules2.getJSONArray(submodules).get(0);JSONObject metrics11 (JSONObject)metrics1.getJSONArray(metrics).get(0);JSONObject metrics12 (JSONObject)metrics1.getJSONArray(metrics).get(1);//成交量JSONObject metrics2 (JSONObject)submodules2.getJSONArray(submodules).get(1);JSONObject metrics21 (JSONObject)metrics2.getJSONArray(metrics).get(0);JSONObject metrics22 (JSONObject)metrics2.getJSONArray(metrics).get(1);JSONObject metrics23 (JSONObject)metrics2.getJSONArray(metrics).get(2);//租金JSONObject metrics3 (JSONObject)submodules2.getJSONArray(submodules).get(2);JSONObject metrics31 (JSONObject)metrics3.getJSONArray(metrics).get(0);JSONObject metrics32 (JSONObject)metrics3.getJSONArray(metrics).get(1);// 写入数据bufferedWriter.write(cityCode,year,month,districtName.replaceAll(,,),bizcircleName,(metrics11.getBigDecimal(value)null ? :metrics11.getBigDecimal(value)),(metrics12.getBigDecimal(value)null ? :metrics12.getBigDecimal(value)),(metrics21.getBigDecimal(value)null ? :metrics21.getBigDecimal(value)),(metrics22.getBigDecimal(value)null ? :metrics22.getBigDecimal(value)),(StringUtils.isEmpty(metrics23.getString(value))? :metrics23.getString(value)),(metrics31.getBigDecimal(value)null ? :metrics31.getBigDecimal(value)),(StringUtils.isEmpty(metrics32.getString(value))? :metrics32.getString(value)));bufferedWriter.newLine();}bufferedWriter.close();
结果 四、感悟
作为一个技术人很容易陷入细节刚开始总觉得一级级往下的事没有很复杂结果尝试了很久总导着有问题最后跳出思维想着既然Mongo查询的语句没有那么擅长就用代码吧很快就写完了。所以不要纠结怎么SQL查询写不出来这些无论是什么形式结果出来了就好。
最近太忙了以后有空知道咋用SQL查询了再更新博客
伙伴们你们要是有兴趣或者知道咋写也可以告诉我怎么直接SQL出来
