db.getCollection('transactionCompensation').find(
{
"$and":[
{
"status":{
"$eq":0
}
},
{
"count":{
"$lt":5
}
}
]
}
); {
"aggregate":"order",
"pipeline":[
{
"$lookup":{
"from":"order",
"localField":"_id",
"foreignField":"_id",
"as":"order"
}
},
{
"$lookup":{
"from":"businessOrderHandling",
"localField":"_id",
"foreignField":"orderId",
"as":"businessOrderHandling"
}
},
{
"$lookup":{
"from":"buyerInformationPreparation",
"localField":"_id",
"foreignField":"orderId",
"as":"buyerInformationPreparation"
}
},
{
"$lookup":{
"from":"mortgageAndWarrantOrder",
"localField":"_id",
"foreignField":"orderId",
"as":"mortgageAndWarrantOrder"
}
},
{
"$lookup":{
"from":"slOrder",
"localField":"_id",
"foreignField":"orderId",
"as":"slOrder"
}
},
{
"$lookup":{
"from":"activateTask",
"localField":"_id",
"foreignField":"orderId",
"as":"activateTask"
}
},
{
"$match":{
"activateTask.statementHandling":Object{...},
"$and":[
{
"$or":[
{
"businessManCityId":523353
},
{
"creatorCityId":523353
}
]
}
]
}
}
]
}
db.businessOrderHandling.find({
"redemptionHouseHandlingPol.rhHandlingNode": {
"$elemMatch": {
"processNode": 'rFloorFinanceAudit',
"isInAliyun": 0
}
}
}); db.businessOrderHandling.find({
"redemptionHouseHandlingPol.rhHandlingNode": {
"$elemMatch": {
"processNode": {
"$in": ['rFloorFinanceAudit', 'rFloorLoan']
},
"isInAliyun": 0
}
}
});
{
"aggregate":"order",
"pipeline":[
{
"$lookup":{
"from":"order",
"localField":"_id",
"foreignField":"_id",
"as":"order"
}
},
{
"$lookup":{
"from":"mortgageAndWarrantOrder",
"localField":"_id",
"foreignField":"orderId",
"as":"mortgageAndWarrantOrder"
}
},
{
"$lookup":{
"from":"buyerInformationPreparation",
"localField":"_id",
"foreignField":"orderId",
"as":"buyerInformationPreparation"
}
},
{
"$lookup":{
"from":"slOrder",
"localField":"_id",
"foreignField":"orderId",
"as":"slOrder"
}
},
{
"$lookup":{
"from":"businessOrderHandling",
"localField":"_id",
"foreignField":"orderId",
"as":"businessOrderHandling"
}
},
{
"$lookup":{
"from":"businessOrderAuditing",
"localField":"_id",
"foreignField":"orderId",
"as":"businessOrderAuditing"
}
},
{
"$lookup":{
"from":"activateTask",
"localField":"_id",
"foreignField":"orderId",
"as":"activateTask"
}
},
{
"$match":{
"activateTask.slHandling":{
"$exists":true
},
"slOrder.handlerName":{
"$exists":true
},
"$and":[
{ },
{ }
]
}
},
{
"$project":{
"_id":"$order._id"
}
}
]
}
[
{
"$lookup":{
"from":"order",
"localField":"orderId",
"foreignField":"_id",
"as":"order"
}
},
{
"$match":{
"order.businessSource.organizationStoreId":"01005201706290948060003000000"
}
},
{
"$group":{
"_id":"$feeUseDetail",
"count":{
"$sum":1
},
"totalLoanCount":{
"$sum":"$rpFee"
}
}
},
{
"$project":{
"groupById":"$_id",
"count":1,
"totalLoanCount":1
}
},
{
"$sort":{
"count":-1
}
}
]
{
"aggregate":"order",
"pipeline":[
{
"$lookup":{
"from":"order",
"localField":"_id",
"foreignField":"_id",
"as":"order"
}
},
{
"$lookup":{
"from":"mortgageAndWarrantOrder",
"localField":"_id",
"foreignField":"orderId",
"as":"mortgageAndWarrantOrder"
}
},
{
"$lookup":{
"from":"buyerInformationPreparation",
"localField":"_id",
"foreignField":"orderId",
"as":"buyerInformationPreparation"
}
},
{
"$lookup":{
"from":"slOrder",
"localField":"_id",
"foreignField":"orderId",
"as":"slOrder"
}
},
{
"$lookup":{
"from":"businessOrderHandling",
"localField":"_id",
"foreignField":"orderId",
"as":"businessOrderHandling"
}
},
{
"$lookup":{
"from":"businessOrderAuditing",
"localField":"_id",
"foreignField":"orderId",
"as":"businessOrderAuditing"
}
},
{
"$lookup":{
"from":"activateTask",
"localField":"_id",
"foreignField":"orderId",
"as":"activateTask"
}
},
{
"$match":{
"applyForDate":{
"$gte":{
"$date":"2017-11-08T16:00:00.000Z"
},
"$lt":{
"$date":"2017-12-01T16:00:00.000Z"
}
},
"_id":{
"$regex":"3ABC-201711220002"
},
"businessManId":192493,
"businessManDeptId":23968115,
"businessCityId":618012,
"buyers.name":{
"$regex":"阿斯蒂芬"
},
"buyers.cellphone":"18878788585",
"salers.name":{
"$regex":"范德萨"
},
"salers.cellphone":"18878788585",
"slOrder._id":"X_ABC-201711220002",
"slOrder.slCategory":1,
"activateTask.slHandling":"controlCard",
"slOrder.handlerName":{
"$exists":true
},
"$and":[
{
"$or":[
{
"buyers.certificateNumber":"234243199202021515"
},
{
"salers.certificateNumber":"234243199202021515"
}
]
},
{
"$or":[
{
"buyers.certificateType":1
},
{
"salers.certificateType":1
}
]
}
]
}
},
{
"$sort":{
"applyForDate":-1
}
},
{
"$skip":0
},
{
"$limit":10
}
]
}
^_^