db={"employee":[{"_id":ObjectId("5f120ba1578d051b20fb53e3"),"emp_code":82140,"emp_firstname":"rahul","emp_secondname":"narayanan unni","emp_gender":"Male","dept_name":"office","emp_designation":"system administrator","avatar":"src/assets/images/IMG-20180302-WA0025.jpg","createdAt":ISODate("2020-07-17T20:35:45.546Z"),"updatedAt":ISODate("2020-07-19T20:09:43.164Z"),"__v":0},{"_id":ObjectId("5f120c90578d051b20fb53e4"),"emp_code":82141,"emp_firstname":"sanu","emp_secondname":"prakashan","emp_gender":"Female","dept_name":"administraton","emp_designation":"driver","avatar":"src/assets/images/IMG-20180302-WA0014.jpg","createdAt":ISODate("2020-07-17T20:39:44.933Z"),"updatedAt":ISODate("2020-07-19T20:33:02.610Z"),"__v":0}],"attendancelogs":[{"_id":ObjectId("5f6a18a2f16b782bfdd8c427"),"punch_status":true,"owner":ObjectId("5f120ba1578d051b20fb53e3"),"chekedInTime":ISODate("2020-09-22T15:29:42.547Z"),"createdAt":ISODate("2020-09-22T15:30:42.565Z"),"updatedAt":ISODate("2020-09-22T15:30:42.565Z"),"__v":0},{"_id":ObjectId("5f6a190ef16b782bfdd8c429"),"punch_status":false,"owner":ObjectId("5f120ba1578d051b20fb53e3"),"chekedOutTime":ISODate("2020-09-22T15:32:30.277Z"),"createdAt":ISODate("2020-09-22T15:32:30.290Z"),"updatedAt":ISODate("2020-09-22T15:32:30.290Z"),"__v":0},{"_id":ObjectId("5f6a18a2f16b782bfdd8c430"),"punch_status":true,"owner":ObjectId("5f120ba1578d051b20fb53e3"),"chekedInTime":ISODate("2020-09-22T16:30:42.547Z"),"createdAt":ISODate("2020-09-22T16:30:42.565Z"),"updatedAt":ISODate("2020-09-22T16:30:42.565Z"),"__v":0},{"_id":ObjectId("5f6a190ef16b782bfdd8c431"),"punch_status":false,"owner":ObjectId("5f120ba1578d051b20fb53e3"),"chekedOutTime":ISODate("2020-09-22T16:32:30.277Z"),"createdAt":ISODate("2020-09-22T16:32:30.290Z"),"updatedAt":ISODate("2020-09-22T16:32:30.290Z"),"__v":0},{"_id":ObjectId("5f6b5cb2a76ecf0f77729082"),"punch_status":true,"owner":ObjectId("5f120c90578d051b20fb53e4"),"chekedInTime":ISODate("2020-09-23T14:33:22.728Z"),"createdAt":ISODate("2020-09-23T14:33:22.741Z"),"updatedAt":ISODate("2020-09-23T14:33:22.741Z"),"__v":0},{"_id":ObjectId("5f6b5cd8a76ecf0f77729086"),"punch_status":false,"owner":ObjectId("5f120c90578d051b20fb53e4"),"chekedOutTime":ISODate("2020-09-23T14:34:00.123Z"),"createdAt":ISODate("2020-09-23T14:34:00.132Z"),"updatedAt":ISODate("2020-09-23T14:34:00.132Z"),"__v":0}]}

db.attendancelogs.aggregate([{$match:{createdAt:{$lte:ISODate("2020-09-22T23:59:59.999Z"),$gte:ISODate("2020-09-22T00:00:00.000Z")}}},{$sort:{createdAt:1}},{$group:{_id:"$owner",pin:{$push:{$cond:[{$eq:["$punch_status",true]},"$$ROOT","$$REMOVE"]}},pout:{$push:{$cond:[{$eq:["$punch_status",false]},"$$ROOT","$$REMOVE"]}}}},{$project:{logs:{$map:{input:{$range:[0,{$size:"$pin"}]},in:{$mergeObjects:[{$arrayElemAt:["$pin","$$this"]},{$arrayElemAt:["$pout","$$this"]}]}}}}},{$lookup:{from:"employee",localField:"_id",foreignField:"_id",as:"user"}},{$unwind:"$user"},{$project:{emp_firstname:"$user.emp_firstname",logs:{$map:{input:"$logs",in:{chekedInTime:"$$this.chekedInTime",chekedOutTime:"$$this.chekedOutTime",duration:{$divide:[{$subtract:["$$this.chekedOutTime","$$this.chekedInTime"]},60000]}}}}}}])