请问像下面这样的文档，我需要统计每个文档中所有goods在指定日期，如2019-04-11到2019-04-13的平均价，该怎么写？
PUT /test/hotel/1
{
"hotelId": 3305766,
"goods": [
{
"goodsId": 3063598,
"priceModels": [
{
"date": "2019-04-11",
"salePrice": 9600
},
{
"date": "2019-04-12",
"salePrice": 11500
},
{
"date": "2019-04-13",
"salePrice": 11500
},
{
"date": "2019-04-14",
"salePrice": 9600
},
{
"date": "2019-04-15",
"salePrice": 9600
},
{
"date": "2019-04-16",
"salePrice": 9600
}
]
},
{
"goodsId": 1344206,
"priceModels": [
{
"date": "2019-04-11",
"salePrice": 12200
},
{
"date": "2019-04-12",
"salePrice": 12200
},
{
"date": "2019-04-13",
"salePrice": 12200
},
{
"date": "2019-04-14",
"salePrice": 12200
},
{
"date": "2019-04-15",
"salePrice": 12200
},
{
"date": "2019-04-16",
"salePrice": 12200
}
]
},
{
"goodsId": 3063597,
"priceModels": [
{
"date": "2019-04-11",
"salePrice": 8400
},
{
"date": "2019-04-12",
"salePrice": 8400
},
{
"date": "2019-04-13",
"salePrice": 8400
},
{
"date": "2019-04-14",
"salePrice": 8400
},
{
"date": "2019-04-15",
"salePrice": 8400
},
{
"date": "2019-04-16",
"salePrice": 8400
}
]
},
{
"goodsId": 1344207,
"priceModels": [
{
"date": "2019-04-11",
"salePrice": 12200
},
{
"date": "2019-04-12",
"salePrice": 12200
},
{
"date": "2019-04-13",
"salePrice": 12200
},
{
"date": "2019-04-14",
"salePrice": 12200
},
{
"date": "2019-04-15",
"salePrice": 12200
},
{
"date": "2019-04-16",
"salePrice": 12200
}
]
}
]
}
0 个回复