db={"admin":[{"_id":ObjectId("5e27fd3da42d441fe8a89580"),"mappedcustomers":[ObjectId("5e2555783405363bc4bf86c5"),ObjectId("5e2555783405363bc4bf86c0"),ObjectId("5e2555783405363bc4bf86c4")],"phoneNo":9897654358,"name":"acdbcs"},{"_id":ObjectId("5e2555783405363bc4bf86c5"),"mappedcustomers":[],"phoneNo":-1,"name":"ffff"},{"_id":ObjectId("5e2555783405363bc4bf86c0"),"mappedcustomers":[],"phoneNo":-1,"name":"eeee"},{"_id":ObjectId("5e2555783405363bc4bf86c4"),"mappedcustomers":[],"phoneNo":-1,"name":"gggg"}],"orders":[{"_id":ObjectId("5e27f998a42d441fe8a8957f"),"authorized":false,"orderCreatedBy":ObjectId("5e2555783405363bc4bf86c4"),"productOrderedForDate":ISODate("2020-02-04T18:30:00Z"),"order":[{"_id":ObjectId("5e26be2cc13b7149d0a95110"),"productName":"Cups","productCode":"CICE1","size R":21,"size L":16},{"_id":ObjectId("5e26be2cc13b7149d0a9510f"),"productName":"Bottles","productCode":"BTCE1","size R":12,"size L":3}]},{"_id":ObjectId("5e26be2cc13b7149d0b90752"),"authorized":false,"orderCreatedBy":ObjectId("5e2555783405363bc4bf86c0"),"productOrderedForDate":ISODate("2020-02-04T18:30:00Z"),"order":[{"_id":ObjectId("5e26be2cc13b7149d0a87230"),"productName":"Cups","productCode":"CICE1","size R":9,"size L":7},{"_id":ObjectId("5e26be2cc13b7149d0a8560e"),"productName":"Bottles","productCode":"BTCE1","size R":3,"size L":11}]},{"_id":ObjectId("5e26be2cc13b7149d0b9876f"),"authorized":true,"orderCreatedBy":ObjectId("5e2555783405363bc4bf86c4"),"productOrderedForDate":ISODate("2020-01-28T18:30:00Z"),"order":[{"_id":ObjectId("5e26be2cc13b7149d0a54220"),"productName":"Cups","productCode":"CICE1","size R":2,"size L":6},{"_id":ObjectId("5e26be2cc13b7149d0a6520e"),"productName":"Bottles","productCode":"BTCE1","size R":8,"size L":16}]},{"_id":ObjectId("5e78f998a42d441fe898765d"),"authorized":true,"orderCreatedBy":ObjectId("5e2555783405363bc4bf86c0"),"productOrderedForDate":ISODate("2020-01-28T18:30:00Z"),"order":[{"_id":ObjectId("5e26be2cc13b7149d0a87230"),"productName":"Cups","productCode":"CICE1","size R":26,"size L":19},{"_id":ObjectId("5e26be2cc13b7149d0a8560f"),"productName":"Bottles","productCode":"BTCE1","size R":4,"size L":5}]}]}

db.admin.aggregate([{$match:{_id:ObjectId("5e27fd3da42d441fe8a89580")}},{$lookup:{from:"admin",localField:"mappedcustomers",foreignField:"_id",as:"mappedcustomers"}},{$unwind:"$mappedcustomers"},{$replaceRoot:{newRoot:"$mappedcustomers"}},{$lookup:{from:"orders",let:{mappedCustomersId:"$_id"},pipeline:[{$match:{$expr:{$eq:["$orderCreatedBy","$$mappedCustomersId"]},"$or":[{"productOrderedForDate":ISODate("2020-02-04T18:30:00Z")},{"productOrderedForDate":ISODate("2020-01-28T18:30:00Z")}]}}],as:"orders"}},{$unwind:"$orders"},{$unwind:"$orders.order"},{$group:{_id:"$orders.order.productCode",orders:{$push:{productOrderedForDate:"$orders.productOrderedForDate",productName:"$orders.order.productName",productCode:"$orders.order.productCode","size R":"$orders.order.size R","size L":"$orders.order.size L"}}}},{$project:{thisweek:{$reduce:{input:{$filter:{input:"$orders",cond:{$eq:["$$this.productOrderedForDate",ISODate("2020-02-04T18:30:00Z")]}}},initialValue:{"size R":0,"size L":0},in:{productOrderedForDate:"$$this.productOrderedForDate","productName":"$$this.productName","productCode":"$$this.productCode","size R":{$add:["$$value.size R","$$this.size R"]},"size L":{$add:["$$value.size L","$$this.size L"]}}}},lastWeek:{$reduce:{input:{$filter:{input:"$orders",cond:{$eq:["$$this.productOrderedForDate",ISODate("2020-01-28T18:30:00Z")]}}},initialValue:{"size R":0,"size L":0},in:{productOrderedForDate:"$$this.productOrderedForDate","size R":{$add:["$$value.size R","$$this.size R"]},"size L":{$add:["$$value.size L","$$this.size L"]}}}}}},{$group:{_id:null,orders:{$push:{$mergeObjects:["$thisweek",{"lastWeek":["$lastWeek"]}]}}}},{$unset:"_id"}])