[{"_id":{"$oid":"635043a0ab27dad2a8d3d4d5"},"createdDate":{"$date":{"$numberLong":"1666204557000"}},"usedParts":[{"pName":[{"stock_title":"OPAR - 4434792","_id":{"$oid":"635043a0ab27dad2a8d3d4d7"}}],"pPrice":"456","pUnit":"2","_id":{"$oid":"635043a0ab27dad2a8d3d4d6"}}],"images":[],"car":{"$oid":"6349c1f47b9b3fd73308199c"},"carKM":"1234","totalPrice":456,"periodicTime":{"$date":{"$numberLong":"1681929357000"}},"__v":0,"repairPayment":[{"createdDate":{"$date":{"$numberLong":"1666885844000"}},"method":"Banka Havale/EFT","price":56,"_id":{"$oid":"635aa8de2c9faafde2525a67"}},{"createdDate":{"$date":{"$numberLong":"1666886155000"}},"method":"Çek & Senet","price":100,"_id":{"$oid":"635aaa112c9faafde2525ad0"}}]},{"_id":{"$oid":"6350536c89e4f3bc72d831c5"},"createdDate":{"$date":{"$numberLong":"1666208603000"}},"usedParts":[{"pName":[{"stock_title":"OPAR - 4434792","_id":{"$oid":"6350536c89e4f3bc72d831c7"}}],"pPrice":"456","pUnit":"20","_id":{"$oid":"6350536c89e4f3bc72d831c6"}}],"images":[],"car":{"$oid":"6349bf78015c59aa0db150c6"},"carKM":"4567","totalPrice":456,"__v":0,"repairPayment":[{"createdDate":{"$date":{"$numberLong":"1666689099000"}},"method":"Banka Havale/EFT","price":156,"_id":{"$oid":"6357a8559d2932578d3d660e"}}]},{"_id":{"$oid":"6350555089e4f3bc72d83326"},"createdDate":{"$date":{"$numberLong":"1666209091000"}},"usedParts":[{"pName":[{"stock_title":"MAHLE - OX188D","_id":{"$oid":"6350555089e4f3bc72d83328"}}],"pPrice":"563","pUnit":"4","_id":{"$oid":"6350555089e4f3bc72d83327"}}],"images":[],"car":{"$oid":"6349c0fdb6878a90f1c22519"},"carKM":"6787","totalPrice":563,"periodicTime":{"$date":{"$numberLong":"1697745091000"}},"__v":0,"repairPayment":[{"createdDate":{"$date":{"$numberLong":"1666688858000"}},"method":"Nakit","price":163,"_id":{"$oid":"6357a7659d2932578d3d647c"}}]},{"_id":{"$oid":"635058804abe256d8cf71daf"},"createdDate":{"$date":{"$numberLong":"1666209909000"}},"images":[],"car":{"$oid":"635058734abe256d8cf71daa"},"carKM":"3254365","totalPrice":565,"periodicTime":{"$date":{"$numberLong":"1681934709000"}},"__v":0,"usedParts":[{"pName":[{"stock_title":"OPAR - 4434792","_id":{"$oid":"635058804abe256d8cf71db1"}}],"pPrice":"565","pUnit":"3","_id":{"$oid":"635058804abe256d8cf71db0"}}],"repairPayment":[{"createdDate":{"$date":{"$numberLong":"1666893293000"}},"method":"Nakit","price":565,"_id":{"$oid":"6356d1788f4b72e10ac30d9d"}}]},{"_id":{"$oid":"63527d3c2a5d2241f962e686"},"createdDate":{"$date":{"$numberLong":"1667041525000"}},"usedParts":[{"pName":[{"stock_title":"MAHLE - OX188D","_id":{"$oid":"63527d3c2a5d2241f962e688"}}],"pPrice":"500","pUnit":"2","_id":{"$oid":"63527d3c2a5d2241f962e687"}},{"pName":[{"stock_title":"SARDES - SA309","_id":{"$oid":"63527d3c2a5d2241f962e68c"}}],"pPrice":"8998","pUnit":"2","_id":{"$oid":"63527d3c2a5d2241f962e68b"}},{"pName":[{"stock_title":"AYD - 9100878","_id":{"$oid":"63527d3c2a5d2241f962e690"}}],"pPrice":"960","pUnit":"3","_id":{"$oid":"63527d3c2a5d2241f962e68f"}}],"images":[{"path":"images\\repairs\\repair-sks5ih.png","_id":{"$oid":"63527d3c2a5d2241f962e693"}},{"path":"images\\repairs\\repair-uzgqj.png","_id":{"$oid":"63527d3c2a5d2241f962e694"}},{"path":"images\\repairs\\repair-obofp.jpeg","_id":{"$oid":"63527d3c2a5d2241f962e695"}},{"path":"images\\repairs\\repair-asi6ti.jpeg","_id":{"$oid":"63527d3c2a5d2241f962e696"}},{"path":"images\\repairs\\repair-8wf20h.jpeg","_id":{"$oid":"63527d3c2a5d2241f962e697"}}],"car":{"$oid":"6349c0441d80ad46b5f99887"},"carKM":"5675687","totalPrice":10458,"periodicTime":{"$date":{"$numberLong":"1698577525000"}},"__v":0},{"_id":{"$oid":"63529fc3b09345831b959a53"},"createdDate":{"$date":{"$numberLong":"1666359180000"}},"usedParts":[{"pName":[{"stock_title":"OPAR - 4434792","_id":{"$oid":"63529fc3b09345831b959a55"}}],"pPrice":"800","pUnit":"2","_id":{"$oid":"63529fc3b09345831b959a54"}},{"pName":[{"stock_title":"HYUNDAİ - 2630035504","_id":{"$oid":"63529fc3b09345831b959a59"}}],"pPrice":"896","pUnit":"2","_id":{"$oid":"63529fc3b09345831b959a58"}}],"images":[{"path":"images\\repairs\\repair-lx1xpj.jpeg","_id":{"$oid":"63529fc3b09345831b959a5c"}},{"path":"images\\repairs\\repair-porqj.jpeg","_id":{"$oid":"63529fc3b09345831b959a5d"}}],"car":{"$oid":"6349c0441d80ad46b5f99887"},"carKM":"12423432","repairDesc":"DENEME ","totalPrice":1696,"__v":0},{"_id":{"$oid":"6352f2d7cb707fe6d51b362a"},"createdDate":{"$date":{"$numberLong":"1666380491000"}},"usedParts":[{"pName":[{"stock_title":"OPAR - 4434792","_id":{"$oid":"6352f2d7cb707fe6d51b362c"}}],"pPrice":"5000","pUnit":"2","_id":{"$oid":"6352f2d7cb707fe6d51b362b"}}],"images":[],"car":{"$oid":"6349c0441d80ad46b5f99887"},"carKM":"34543434","totalPrice":5000,"__v":0,"repairPayment":[{"createdDate":{"$date":{"$numberLong":"1666688707000"}},"method":"Nakit","price":2500,"_id":{"$oid":"6357a6db9d2932578d3d62d2"}},{"createdDate":{"$date":{"$numberLong":"1666884368000"}},"method":"Banka Havale/EFT","price":2500,"_id":{"$oid":"635aa31a2c9faafde25259b4"}}]},{"_id":{"$oid":"6352f301cb707fe6d51b368d"},"createdDate":{"$date":{"$numberLong":"1654111722000"}},"usedParts":[{"pName":[{"stock_title":"OPAR - 4434792","_id":{"$oid":"6352f301cb707fe6d51b368f"}}],"pPrice":"852","pUnit":"2","_id":{"$oid":"6352f301cb707fe6d51b368e"}}],"images":[],"car":{"$oid":"6349c0441d80ad46b5f99887"},"carKM":"324564","totalPrice":852,"periodicTime":{"$date":{"$numberLong":"1669922922000"}},"__v":0},{"_id":{"$oid":"63530fb33670f7fcd05a50e8"},"createdDate":{"$date":{"$numberLong":"1667087132000"}},"usedParts":[{"pName":[{"stock_title":"MASTER - MAF674RK","_id":{"$oid":"63530fb33670f7fcd05a50ea"}}],"pPrice":"562","pUnit":"2","_id":{"$oid":"63530fb33670f7fcd05a50e9"}},{"pName":[{"stock_title":"MAIS - 7700102539","_id":{"$oid":"63530fb33670f7fcd05a50ee"}}],"pPrice":"256","pUnit":"3","_id":{"$oid":"63530fb33670f7fcd05a50ed"}}],"images":[{"path":"images\\repairs\\repair-nynkf.jpeg","_id":{"$oid":"63530fb43670f7fcd05a50f1"}}],"car":{"$oid":"63530f613670f7fcd05a50e2"},"carKM":"5989798","totalPrice":818,"periodicTime":{"$date":{"$numberLong":"1698623132000"}},"__v":0,"repairPayment":[{"createdDate":{"$date":{"$numberLong":"1666634056000"}},"method":"Banka Havale/EFT","price":200,"_id":{"$oid":"6356d1508f4b72e10ac30d3f"}},{"createdDate":{"$date":{"$numberLong":"1666638170000"}},"method":"Nakit","price":18,"_id":{"$oid":"6356e1608f4b72e10ac314a5"}}]},{"_id":{"$oid":"6354fc6283c6b806c44773e3"},"createdDate":{"$date":{"$numberLong":"1669192368000"}},"usedParts":[{"pName":[{"stock_title":"VALEO - 588006","_id":{"$oid":"6354fc6283c6b806c44773e6"}}],"pPrice":"862","pUnit":"2","_id":{"$oid":"6354fc6283c6b806c44773e5"}},{"pName":[{"stock_title":"ÜNÜVAR - 90042","_id":{"$oid":"6354fc6283c6b806c44773ea"}}],"pPrice":"5000","pUnit":"6","_id":{"$oid":"6354fc6283c6b806c44773e9"}}],"images":[],"repairPayment":[{"createdDate":{"$date":{"$numberLong":"1666513968000"}},"method":"Nakit","price":1862,"_id":{"$oid":"6354fc6283c6b806c44773e4"}},{"createdDate":{"$date":{"$numberLong":"1666615223000"}},"method":"Nakit","price":1850,"_id":{"$oid":"635687c52fc6cfa45694f18a"}},{"createdDate":{"$date":{"$numberLong":"1666631323000"}},"method":"Kredi Kartı","price":100,"_id":{"$oid":"6356c6a52fc6cfa45694f273"}},{"createdDate":{"$date":{"$numberLong":"1666638065000"}},"method":"Nakit","price":50,"_id":{"$oid":"6356e0f68f4b72e10ac3135b"}}],"car":{"$oid":"633589fd366cfb4179d039a6"},"carKM":"56576545","totalPrice":5862,"periodicTime":{"$date":{"$numberLong":"1682238768000"}},"__v":0},{"_id":{"$oid":"6356cf5b8f4b72e10ac30bdd"},"createdDate":{"$date":{"$numberLong":"1666633518000"}},"usedParts":[{"pName":[{"stock_title":"MAHLE - OX188D","_id":{"$oid":"6356cf5b8f4b72e10ac30be0"}}],"pPrice":"550","pUnit":"1","_id":{"$oid":"6356cf5b8f4b72e10ac30bdf"}},{"pName":[{"stock_title":"MAIS - 7700102539","_id":{"$oid":"6356cf5b8f4b72e10ac30be4"}}],"pPrice":"650","pUnit":"2","_id":{"$oid":"6356cf5b8f4b72e10ac30be3"}}],"images":[],"repairPayment":[{"createdDate":{"$date":{"$numberLong":"1666633518000"}},"method":"Kredi Kartı","price":750,"_id":{"$oid":"6356cf5b8f4b72e10ac30bde"}},{"createdDate":{"$date":{"$numberLong":"1666806376000"}},"method":"Çek & Senet","price":100,"_id":{"$oid":"6356cf738f4b72e10ac30c41"}},{"createdDate":{"$date":{"$numberLong":"1666633610000"}},"method":"Çek & Senet","price":350,"_id":{"$oid":"6356cf928f4b72e10ac30ca7"}}],"car":{"$oid":"633589fd366cfb4179d039a6"},"carKM":"7887654","totalPrice":1200,"__v":0},{"_id":{"$oid":"6356d34f8f4b72e10ac30e0a"},"createdDate":{"$date":{"$numberLong":"1666634495000"}},"usedParts":[{"pName":[{"stock_title":"FİL - ZP506","_id":{"$oid":"6356d34f8f4b72e10ac30e0d"}}],"pPrice":"500","pUnit":"2","_id":{"$oid":"6356d34f8f4b72e10ac30e0c"}}],"images":[],"repairPayment":[{"createdDate":{"$date":{"$numberLong":"1666634495000"}},"method":"Kredi Kartı","price":200,"_id":{"$oid":"6356d34f8f4b72e10ac30e0b"}},{"createdDate":{"$date":{"$numberLong":"1666634611000"}},"method":"Nakit","price":200,"_id":{"$oid":"6356d3788f4b72e10ac30ed9"}}],"car":{"$oid":"633589fd366cfb4179d039a6"},"carKM":"123","totalPrice":500,"periodicTime":{"$date":{"$numberLong":"1682359295000"}},"__v":0},{"_id":{"$oid":"635ba1c1fe218379fb24868e"},"createdDate":{"$date":{"$numberLong":"1666949546000"}},"usedParts":[{"pName":[{"stock_title":"REAL - AD2745","_id":{"$oid":"635ba1c1fe218379fb248691"}}],"pPrice":"500","pUnit":"2","_id":{"$oid":"635ba1c1fe218379fb248690"}}],"images":[],"repairPayment":[{"createdDate":{"$date":{"$numberLong":"1666949546000"}},"method":"Banka Havale/EFT","price":200,"_id":{"$oid":"635ba1c1fe218379fb24868f"}}],"car":{"$oid":"6349c0fdb6878a90f1c22519"},"carKM":"4567","totalPrice":500,"__v":0}]

db.collection.aggregate([{$match:{createdDate:{$gt:new Date("2022-10-23T00:00:00.000Z"),$lt:new Date("2022-10-30T00:00:00.000Z")}}},{$facet:{repairs:[{$group:{_id:{$dateTrunc:{date:"$createdDate",unit:"day"}},count:{$count:{}}}},{$project:{date:"$_id",count:"$count",_id:0}}]}},{$set:{allDays:{$range:[0,{$add:[{$dateDiff:{startDate:{$min:"$repairs.date"},endDate:{$max:"$repairs.date"},unit:"day",}},1]}]}}},{$set:{allDays:{$map:{input:"$allDays",in:{$dateAdd:{startDate:{$min:"$repairs.date"},unit:"day",amount:"$$this"}}}}}},{$project:{repairs:{$map:{input:"$allDays",as:"day",in:{$mergeObjects:[{date:"$$day",count:0},{$first:{$filter:{input:"$repairs",cond:{$eq:["$$day","$$repairs.date"]},as:"repairs"}}}]}}}}},{$project:{repairs:{$map:{input:"$repairs",in:"$$this.count"}}}}])