db={"visits":[{_id:ObjectId("6250b59b4f687b0da5edde13"),client:ObjectId("61fac023ad0db377b396e1b9"),user:ObjectId("62194175bcd77d7f4bfa97ea"),location:"Mordor",visitStart:ISODate("2022-04-08T22:30:04.000Z"),visitEnd:ISODate("2022-04-08T23:30:12.000Z"),createdAt:ISODate("2022-04-08T22:22:19.272Z"),updatedAt:ISODate("2022-04-08T22:22:19.272Z"),__v:0},{_id:ObjectId("62571513ec41c091181dd828"),client:ObjectId("6205a8313fe12d6b4ec354c4"),user:ObjectId("62194175bcd77d7f4bfa97ea"),location:"Los Angeles Court",visitStart:ISODate("2022-04-13T18:00:53.000Z"),visitEnd:ISODate("2022-04-13T19:00:00.000Z"),createdAt:ISODate("2022-04-13T18:23:15.712Z"),updatedAt:ISODate("2022-04-13T18:23:15.712Z"),__v:0},{_id:ObjectId("6257158d157e807e51c7e009"),client:ObjectId("6205a8313fe12d6b4ec354c4"),user:ObjectId("62194175bcd77d7f4bfa97ea"),location:"Los Angeles Court",visitStart:ISODate("2022-04-13T18:00:53.000Z"),visitEnd:ISODate("2022-04-13T19:00:00.000Z"),createdAt:ISODate("2022-04-13T18:25:17.180Z"),updatedAt:ISODate("2022-04-13T18:25:17.180Z"),__v:0},{_id:ObjectId("62571644157e807e51c7e019"),client:ObjectId("61fac023ad0db377b396e1b9"),user:ObjectId("62194175bcd77d7f4bfa97ea"),location:"Mordor",visitStart:ISODate("2022-04-13T18:00:53.000Z"),visitEnd:ISODate("2022-04-13T19:00:00.000Z"),createdAt:ISODate("2022-04-13T18:28:20.533Z"),updatedAt:ISODate("2022-04-13T18:28:20.533Z"),__v:0},{_id:ObjectId("625f3c0fe32427cfd0f2e204"),createdAt:ISODate("2022-04-19T22:47:43.508Z"),updatedAt:ISODate("2022-04-19T22:47:43.508Z"),__v:0},{_id:ObjectId("62608cefaf535faed7a8cff5"),client:ObjectId("625f373ca8b96f577b809e52"),user:ObjectId("62194175bcd77d7f4bfa97ea"),location:"A place",visitStart:ISODate("2022-04-20T23:45:48.000Z"),visitEnd:ISODate("2022-04-21T00:59:56.000Z"),createdAt:ISODate("2022-04-20T22:45:03.640Z"),updatedAt:ISODate("2022-04-20T22:45:03.640Z"),__v:0},{_id:ObjectId("628fdfd98d5b88e32bb0d110"),client:ObjectId("62854a9253e338fd260ed2fd"),user:ObjectId("62410a1dcaac9a3d0528de7a"),location:"Moscow",visitStart:ISODate("2022-05-26T20:00:49.000Z"),visitEnd:ISODate("2022-05-26T22:00:55.000Z"),totalHours:2,createdAt:ISODate("2022-05-26T20:15:21.912Z"),updatedAt:ISODate("2022-05-26T20:15:21.912Z"),__v:0},{_id:ObjectId("629bc5c5c065bd9402fe011c"),client:ObjectId("627fe0cc87fb0fdbd26045d3"),user:ObjectId("62410a1dcaac9a3d0528de7a"),location:"A place",visitStart:ISODate("2022-04-08T17:00:00.000Z"),visitEnd:ISODate("2022-04-08T19:00:00.000Z"),totalHours:2,goals:[],createdAt:ISODate("2022-06-04T20:51:17.244Z"),updatedAt:ISODate("2022-06-04T20:51:17.244Z"),__v:0},{_id:ObjectId("629bc5e5c065bd9402fe0129"),client:ObjectId("625f18459e17c25936a46a74"),user:ObjectId("62410a1dcaac9a3d0528de7a"),location:"Somewheres",visitStart:ISODate("2022-04-10T17:00:00.000Z"),visitEnd:ISODate("2022-04-10T19:00:00.000Z"),totalHours:2,goals:[],createdAt:ISODate("2022-06-04T20:51:50.042Z"),updatedAt:ISODate("2022-06-04T20:51:50.042Z"),__v:0},{_id:ObjectId("62a2a16588b5e5a3c78c72da"),client:ObjectId("625f18459e17c25936a46a74"),user:ObjectId("62410a1dcaac9a3d0528de7a"),location:"New York",visitStart:ISODate("2022-04-20T21:00:00.000Z"),visitEnd:ISODate("2022-04-20T22:00:00.000Z"),totalHours:1,goals:[],createdAt:ISODate("2022-06-10T01:41:58.027Z"),updatedAt:ISODate("2022-06-10T01:41:58.027Z"),__v:0},{_id:ObjectId("62a2a19688b5e5a3c78c72e7"),client:ObjectId("6205a8313fe12d6b4ec354c4"),user:ObjectId("62410a1dcaac9a3d0528de7a"),location:"Los Angeles",visitStart:ISODate("2022-04-10T21:00:00.000Z"),visitEnd:ISODate("2022-04-10T22:00:00.000Z"),totalHours:1,goals:[],createdAt:ISODate("2022-06-10T01:42:47.039Z"),updatedAt:ISODate("2022-06-10T01:42:47.039Z"),__v:0}],"users":[{_id:ObjectId("62194175bcd77d7f4bfa97ea"),firstName:"Danny",lastName:"Trejo",phone:"6192234435",email:"d.trejo@octochart.com",username:"dtrejo",password:"asdfasdf",userId:1,__v:3,clients:[],updatedAt:ISODate("2022-04-20T22:45:03.930Z"),visits:[ObjectId("6257158d157e807e51c7e009"),ObjectId("62571644157e807e51c7e019"),ObjectId("62608cefaf535faed7a8cff5")],fullName:"Danny Trejo"},{_id:ObjectId("6219729ea92348779207df67"),firstName:"Illia",lastName:"Trecenko",phone:"6194336599",email:"i.trecenk@octochart.com",username:"ITrecenko",password:"roughstuff",userId:2,__v:0,fullName:"Illia Trecenko"},{_id:ObjectId("62198433a92348779207df6c"),firstName:"Johnny",lastName:"Johnson",phone:"8586723345",email:"j.johnson@octochart.com",username:"JJohnson",password:"fhhgiish",userId:3,__v:0,fullName:"Johnny Johnson"},{_id:ObjectId("62410a1dcaac9a3d0528de7a"),firstName:"Joe",lastName:"Nach",phone:"6193065615",email:"j.nach@actadvocacy.org",username:"jnach",password:"$2a$10$yaEK3iF6W43asN3uabywpe.5DJVTpZ0l57Yx/uRCxOD5dhLqEokYK",createdAt:ISODate("2022-03-28T01:06:37.519Z"),updatedAt:ISODate("2022-06-10T01:42:47.039Z"),userId:4,__v:29,clients:[],visits:[ObjectId("625734c426df2b5be26d036c"),ObjectId("625f38a2f1cc4ee81e0e46d2"),ObjectId("625f3fa6a410369325409195"),ObjectId("625f400ea4103693254091aa"),ObjectId("628e953273d848820ba3f780"),ObjectId("628e971073d848820ba3f794"),ObjectId("628fb1a718935914203ef699"),ObjectId("628fb2c240df3f211a6b9328"),ObjectId("628fbbce2803476164ce8e6a"),ObjectId("628fbc7afe10742a24b57d83"),ObjectId("628fc96576650eba278e866a"),ObjectId("628fdf538d5b88e32bb0d0c0"),ObjectId("628fdfc58d5b88e32bb0d102"),ObjectId("628fdfd98d5b88e32bb0d110"),ObjectId("629455adcfd62d1b414f1adf"),ObjectId("629bc5c5c065bd9402fe011c"),ObjectId("629bc5e5c065bd9402fe0129"),ObjectId("62a2a16588b5e5a3c78c72da"),ObjectId("62a2a19688b5e5a3c78c72e7")],fullName:"Joe Nach",timeEntries:[{_id:ObjectId("629125a97e67d985e298db7d")},{_id:ObjectId("629126dc550382c665dcb616")},{_id:ObjectId("62912824414d853358e7d496")},{_id:ObjectId("62915dbd16e50dbee7ea20f4")},{_id:ObjectId("62915e236d095f01d34647af")},{_id:ObjectId("629160a7fd628ff264f5a6f1")},{_id:ObjectId("6291694bb176da0aa45f5395")},{_id:ObjectId("62916ab12282ee91eac3c4fd")}],timeBrackets:[ObjectId("629515ce02b8063e6b544767"),ObjectId("629692d05e3daaed48f566ba")]},{_id:ObjectId("6247934c4b4fe8e5eba43cfa"),firstName:"Danny",lastName:"Rojas",phone:"6194423567",email:"d.rojas@octochart.com",username:"drojas",password:"$2a$10$w1LTEm4YEGtf2BmkcLPMUeairjQ15C1ZWAMlj8fOwjtGga8MleAg6",createdAt:ISODate("2022-04-02T00:05:32.267Z"),updatedAt:ISODate("2022-04-02T00:05:32.267Z"),userId:5,__v:0,fullName:"Danny Rojas"},{_id:ObjectId("628ff2bdfd58e596b0d90161"),fullName:"Igor Illich",firstName:"Igor",lastName:"Illich",phone:"6199983399",email:"i.illich@octochart.com",username:"IIllich",password:"$2a$10$McNccKNl9y2LNywnmvdx5OQLwAdmviP/ob2pNCjPhcHDKBCw53B1i",visits:[],clients:[],createdAt:ISODate("2022-05-26T21:35:57.129Z"),updatedAt:ISODate("2022-05-26T21:35:57.129Z"),__v:0},{_id:ObjectId("628ff30bfd58e596b0d90165"),fullName:"Sasha Gomez",firstName:"Sasha",lastName:"Gomez",phone:"8582304556",email:"s.gomez@octochart.com",username:"SGomez",password:"$2a$10$1hGnruN8hjaQazDYFvRzIuZngJi3s9TIFOaLNMIF8P78aPnyq.aZO",visits:[],clients:[],createdAt:ISODate("2022-05-26T21:37:15.918Z"),updatedAt:ISODate("2022-05-26T21:37:15.918Z"),__v:0}],"timebrackets":[{_id:ObjectId("629515ce02b8063e6b544767"),date:ISODate("2022-04-08T22:30:04.000Z"),user:[ObjectId("62410a1dcaac9a3d0528de7a")],timeEntries:[{timeIn:ISODate("2022-04-08T18:00:00.000Z"),timeOut:ISODate("2022-04-08T19:30:04.000Z"),type:"client",hours:1.5,_id:ObjectId("629516ebb1cec66fc5bb179a"),createdAt:ISODate("2022-05-30T19:11:39.344Z"),updatedAt:ISODate("2022-06-01T23:29:15.144Z")},{timeIn:ISODate("2022-06-01T16:30:00.000Z"),timeOut:ISODate("2022-06-01T18:00:00.000Z"),type:"Client",hours:1.5,_id:ObjectId("62980514d6444d27a689a441"),createdAt:ISODate("2022-06-02T00:32:20.120Z"),updatedAt:ISODate("2022-06-02T00:32:20.120Z")},{timeIn:ISODate("2022-06-02T19:30:00.000Z"),timeOut:ISODate("2022-06-02T20:45:00.000Z"),type:"Office",hours:1.25,_id:ObjectId("629927a9d6444d27a689a48e"),createdAt:ISODate("2022-06-02T21:12:09.320Z"),updatedAt:ISODate("2022-06-02T21:12:09.320Z")}],miles:[{source:"Home",destination:"Client",distance:4,_id:ObjectId("6298045ad6444d27a689a40b"),createdAt:ISODate("2022-06-02T00:29:14.982Z"),updatedAt:ISODate("2022-06-02T00:29:14.982Z")},{source:"Client",destination:"Store",distance:4,_id:ObjectId("62992714d6444d27a689a454"),createdAt:ISODate("2022-06-02T21:09:40.356Z"),updatedAt:ISODate("2022-06-02T21:09:40.356Z")},{source:"Store",destination:"Client's home",distance:4,_id:ObjectId("62992789d6444d27a689a47b"),createdAt:ISODate("2022-06-02T21:11:37.996Z"),updatedAt:ISODate("2022-06-02T21:11:37.996Z")}],createdAt:ISODate("2022-05-30T19:06:54.142Z"),updatedAt:ISODate("2022-06-02T21:12:09.321Z"),__v:22},{_id:ObjectId("629692d05e3daaed48f566ba"),date:ISODate("2022-04-10T07:00:00.000Z"),user:[ObjectId("62410a1dcaac9a3d0528de7a")],timeEntries:[{timeIn:ISODate("2022-06-01T16:00:00.000Z"),timeOut:ISODate("2022-06-01T19:30:00.000Z"),type:"Sick",hours:3,_id:ObjectId("6297e3635e3daaed48f568c6"),createdAt:ISODate("2022-06-01T22:08:35.960Z"),updatedAt:ISODate("2022-06-01T22:08:35.960Z")},{timeIn:ISODate("2022-06-01T19:00:00.000Z"),timeOut:ISODate("2022-06-01T21:00:00.000Z"),type:"client",hours:2,_id:ObjectId("6297ecf0bdc9d955157042ad"),createdAt:ISODate("2022-06-01T22:49:20.180Z"),updatedAt:ISODate("2022-06-01T22:49:20.180Z")},{timeIn:ISODate("2022-06-01T21:00:00.000Z"),timeOut:ISODate("2022-06-01T22:30:00.000Z"),type:"office",hours:1.5,_id:ObjectId("6297ed14bdc9d955157042be"),createdAt:ISODate("2022-06-01T22:49:56.195Z"),updatedAt:ISODate("2022-06-01T22:49:56.195Z")}],miles:[{source:"Home",destination:"Client",distance:3,_id:ObjectId("6297e3965e3daaed48f568d3"),createdAt:ISODate("2022-06-01T22:09:26.038Z"),updatedAt:ISODate("2022-06-01T22:09:26.038Z")}],createdAt:ISODate("2022-05-31T22:12:32.589Z"),updatedAt:ISODate("2022-06-01T22:49:56.195Z"),__v:4}]}

/** const isStart = ISODate("2022-04-08T00:00:00.000Z")* const isEnd = ISODate("2022-06-10T23:59:59.000Z")* const userId = ObjectId("62410a1dcaac9a3d0528de7a")*/db.visits.aggregate([{$match:{user:ObjectId("62410a1dcaac9a3d0528de7a")}},{$lookup:{from:"visits",as:"visits",let:[{visitStart:"$visits.visitStart"},{visitEnd:"$visits.visitEnd"},],pipeline:[{$match:{$and:[{user:ObjectId("62410a1dcaac9a3d0528de7a")},{visitStart:{$gte:ISODate("2022-04-08T00:00:00.000Z")}},{visitEnd:{$lte:ISODate("2022-06-10T23:59:59.000Z")}}]},$unwind:{path:"$visits",preserveNullAndEmptyArrays:true},$group:{_id:{$dateToString:{date:"$visitEnd",format:"%m-%d-%Y"}},visitHours:{$sum:"$totalHours"}}}]}},{/**.unwind({ path: "visits", preserveNullAndEmptyArrays: true})*/$lookup:{from:"timebrackets",as:"brackets",let:{hours:"$timeEntries.hours"},pipeline:[{$match:{$and:[{user:ObjectId("62410a1dcaac9a3d0528de7a")},{date:{$gte:ISODate("2022-04-08T00:00:00.000Z")}},{date:{$lte:ISODate("2022-06-10T23:59:59.000Z")}}]},$unwind:{path:"$timeEntries",preserveNullAndEmptyArrays:true},$group:{_id:{$dateToString:{date:"$date",format:"%m-%d-%Y"}},entryHours:{$sum:"$hours"}}}]}},{$group:{_id:{$dateToString:{date:"$visitEnd",format:"%m-%d-%Y"}},hours:{$sum:"$totalHours"}}},{$project:{_id:0,date:"$_id",visitEnd:1,hours:1}},{$sort:{date:1}}])