[{"_id":ObjectId("66a1b8068c4972600a773bf7"),"categoryId":{"name":{"en":"Eat Well","vi":"Ăn Khoẻ"},"_id":ObjectId("5e5c7b6e974e1415078271a6"),"image":"https://livwell.s3.ap-southeast-1.amazonaws.com/web/Liv%20To%20Eat%20Well%20%281%29.png","status":"UN_BLOCKED","accessType":"LW"},"PaymentId":{"txnRef":"","amount":null,"status":"","PaymentTime":null},"QRType":"QR_CODE","sponsorImage":"https://livwell.s3.ap-southeast-1.amazonaws.com/web/Boost%20Juice%20VN%20logo.jpg","hasLocationCheck":false,"isFeatured":false,"isDealsOfTheDay":false,"isLinkAvailable":false,"isCashPlusCoin":false,"amount":0,"isBNPL":false,"isWrapUp":false,"totalRedemption":20,"totalUsers":0,"totalChallenges":0,"usedCoupons":[],"discountPercent":20,"totalPoints":10,"hasScanner":false,"hasExternalLink":false,"hasExternalLinkWithCode":false,"status":"UN_BLOCKED","privacy":"PUBLIC","name":{"en":"Reward Test 2","vi":"Reward Test 2"},"description":{"en":"Reward Description","vi":"Reward Description"},"instruction":{"en":"How to use thiis reward","vi":"How to use thiis reward"},"validity":1727715599000.0,"validityColorCode":"#FDFDFD","validityBackgroundColorCode":"#65B753","notes":{"en":"Boost Juice Reward","vi":"Boost Juice Reward"},"image":"https://livwell.s3.ap-southeast-1.amazonaws.com/web/Boost%20juice.jpg","points":8,"colorCode":"#FFFFFF","backgroundColorCode":"#65B753","couponCodeType":"AUTO_GENERATE","type":"COUPON","sponsorLink":"https://reward.web.com","sponsorName":"Boost Juice","sponsorDescription":"B","sponsorNameColor":"#000000","couponCodes":[{"code":"EBOO9473","link":""}],"lastReminderTime":1721873969950.0,"created":1721874439003.0},{"_id":ObjectId("66a1b6328c4972600a773bf4"),"categoryId":{"name":{"en":"Special Rewards","vi":"SpecialRewards"},"_id":ObjectId("64dcc57148dc42400b74643a"),"image":"https://livwell.s3.ap-southeast-1.amazonaws.com/web/LW_banner%209%20copy.jpg","status":"UN_BLOCKED","accessType":"LW"},"PaymentId":{"txnRef":"","amount":null,"status":"","PaymentTime":null},"QRType":"QR_CODE","sponsorImage":"https://livwell.s3.ap-southeast-1.amazonaws.com/web/DHC%20logo-2.png","hasLocationCheck":false,"isFeatured":false,"isDealsOfTheDay":false,"isLinkAvailable":false,"isCashPlusCoin":false,"amount":0,"isBNPL":false,"isWrapUp":false,"totalRedemption":20,"totalUsers":0,"totalChallenges":0,"usedCoupons":[],"discountPercent":10,"totalPoints":10,"hasScanner":false,"hasExternalLink":false,"hasExternalLinkWithCode":false,"status":"UN_BLOCKED","privacy":"PUBLIC","name":{"en":"Reward Test","vi":"Reward Test"},"description":{"en":"Test","vi":"Test"},"instruction":{"en":"Test","vi":"Test"},"validity":1725123599000.0,"validityColorCode":"#FFFFFF","validityBackgroundColorCode":"#023A94","notes":{"en":"New Reward","vi":"New Reward"},"image":"https://livwell.s3.ap-southeast-1.amazonaws.com/web/e-voucher.jpeg","points":9,"colorCode":"#FFFFFF","backgroundColorCode":"#023A94","couponCodeType":"AUTO_GENERATE","type":"COUPON","sponsorLink":"https://reward.web.com","sponsorName":"DHC","sponsorDescription":"DHC","sponsorNameColor":"#FFFFFF","couponCodes":[{"code":"SDHC4059","link":""}],"lastReminderTime":1721873969950.0,"created":1721873970018.0},{"_id":ObjectId("66a1be678c4972600a773c05"),"categoryId":{"_id":ObjectId("64dcb2bd48dc42400b74642c"),"name":{"en":"exlusiveRewards","vi":"exlusiveRewards"},"image":"https://livwell.s3.ap-southeast-1.amazonaws.com/web/LW_banner6%20copy.jpg","status":"UN_BLOCKED","accessType":"LW"},"PaymentId":{"txnRef":"","amount":null,"status":"","PaymentTime":null},"QRType":"QR_CODE","sponsorImage":"https://livwell.s3.ap-southeast-1.amazonaws.com/web/Gold%20Mask%20logo.png","hasLocationCheck":false,"isFeatured":false,"isDealsOfTheDay":false,"isLinkAvailable":false,"isCashPlusCoin":false,"amount":0,"isBNPL":false,"isWrapUp":false,"totalRedemption":20,"totalUsers":0,"totalChallenges":0,"usedCoupons":[],"discountPercent":10,"totalPoints":10,"hasScanner":false,"hasExternalLink":false,"hasExternalLinkWithCode":false,"status":"UN_BLOCKED","privacy":"PUBLIC","name":{"en":"Reward Test 4","vi":"Reward test 4"},"description":{"en":"- Applicable period at stores and E-vouchers: July 1, 2024 - August 31, 2024.\n- Applicable to all products, including discounted products.\n- Code applies to 1 payment. Do not apply concurrently with other codes.\n- Scope of application: Jockey store system and online.\n- Not applicable at shopping centers, and payment at Center counters: Aeon Ha Dong, Takashimaya, Robins, Diamond, The Garden.","vi":"Sáng da - Se khít lỗ chân lông - Săn chắc da - Tái tạo collagen - Dưỡng ẩm\nCông dụng:\n- VÀNG chống oxy hóa, làm lành \n- COLLAGEN TƯƠI hiệu quả x600 so với collagen thông thường\n- CHIẾT XUẤT THỰC VẬT kháng viêm, hỗ trợ nâng cơ\n- CÔNG NGHỆ LIPOSOME: tối ưu khả năng thẩm thấu, hạn chế kích ứng."},"instruction":{"en":"Step 1: Select \"Redeem now\" with LivWell coins to receive the code.\nStep 2: Go to \"My Cart\" in the \"Rewards\" section to access the voucher.\nStep 3: Give the discount code to the staff before paying at the store. Or enter the discount code in the checkout section when purchasing online.","vi":"Bước 1: Chọn \"Đổi ngay\" bằng xu LivWell để nhận code.\nBước 2: Vào mục \"Giỏ hàng của tôi\" trong mục \"Phần thưởng\" để truy cập voucher.\nBước 3: Đưa mã giảm giá cho Nhân viên trước khi thanh toán tại cửa hàng. Hoặc nhập mã giảm giá trong phần thanh toán khi mua hàng Trực tuyến."},"validity":1727715599000.0,"validityColorCode":"#FDFDFD","validityBackgroundColorCode":"#F1EB9C","notes":{"en":"Additional discount of 100,000 for bills from 800,000.\n- Applicable in conjunction with other promotions at the store.\n- Not applicable with other promotional codes.\n- Does not apply to underwear products and products with discounts over 70%.","vi":"- Mỗi mã nhận quà chỉ được sử dụng 01 lần duy nhất.\n- Đơn hàng chỉ hợp lệ khi thông tin đặt hàng là thông tin thành viên của California Fitness & Yoga (thông tin người nhận có thể là người khác).\n- Thời hạn đổi quà đến hết ngày 30/4/2024."},"image":"https://livwell.s3.ap-southeast-1.amazonaws.com/web/Gold%20mask.jpg","points":9,"colorCode":"#FFFFFF","backgroundColorCode":"#F1EB9C","couponCodeType":"AUTO_GENERATE","type":"COUPON","sponsorLink":"https://florasvanity.com/san-pham/lena-dale-bo-mat-na-tre-hoa-toan-dien-phan-tu-vang-lena-dale-time-reversing-nano-golden/","sponsorName":"Công Ty Tnhh Smavt International","sponsorDescription":"LENA DALE - Phòng nghiên thí nghiệm nghiên cứu chuyên nghiệp (Professional Research Laboratory)","sponsorNameColor":"#000000","couponCodes":[{"code":"ECÔN2821","link":""}],"lastReminderTime":1721873969950.0,"created":1721876071317.0,"createdAt":ISODate("2024-07-25T02:54:31.323Z"),"updatedAt":ISODate("2024-07-25T02:54:46.431Z")},{"_id":ObjectId("66a1bd028c4972600a773bfc"),"categoryId":{"name":{"en":"Shop","vi":"Đời Sống"},"_id":ObjectId("5e58ec889062f071c377b59c"),"image":"https://livwell.s3.ap-southeast-1.amazonaws.com/web/Liv%20To%20Shop%281%29.png","status":"UN_BLOCKED","accessType":"LW"},"PaymentId":{"txnRef":"","amount":null,"status":"","PaymentTime":null},"QRType":"QR_CODE","sponsorImage":"https://livwell.s3.ap-southeast-1.amazonaws.com/web/Gold%20Mask%20logo.png","hasLocationCheck":false,"isFeatured":false,"isDealsOfTheDay":false,"isLinkAvailable":false,"isCashPlusCoin":false,"amount":0,"isBNPL":false,"isWrapUp":false,"totalRedemption":20,"totalUsers":1,"totalChallenges":0,"usedCoupons":[{"code":"SMYW1401","link":""}],"discountPercent":30,"totalPoints":10,"hasScanner":false,"hasExternalLink":false,"hasExternalLinkWithCode":false,"status":"UN_BLOCKED","privacy":"PUBLIC","name":{"en":"Reward test 3","vi":"Reward test 3"},"description":{"en":"new reward new reward","vi":"new reward new reward"},"instruction":{"en":"Step 1: Select \"Redeem now\" with LivWell coins to receive the code.\nStep 2: Go to \"My Cart\" in the \"Rewards\" section to access the voucher.\nStep 3: Enter the voucher code into the event registration form to receive the offer (Exclude 3 last digits before entering)","vi":"Bước 1: Chọn \"Đổi ngay\" bằng xu LivWell để nhận code. \nBuớc 2: Vào mục \"Giỏ hàng của tôi\" trong mục \"Phần thưởng\" để truy cập voucher.\nBước 3: Nhập mã voucher vào form đăng ký sự kiện để nhận ưu đãi (LƯU Ý: Mã voucher KHÔNG bao gồm 3 ký tự cuối)."},"validity":1727715599000.0,"validityColorCode":"#FDFDFD","validityBackgroundColorCode":"#216113","notes":{"en":"reward test","vi":"reward test"},"image":"https://livwell.s3.ap-southeast-1.amazonaws.com/web/Media%20Post.jpg","points":7,"colorCode":"#FFFFFF","backgroundColorCode":"#216113","couponCodeType":"AUTO_GENERATE","type":"COUPON","sponsorLink":"https://reward.web.com","sponsorName":"My Wear","sponsorDescription":"My Wear","sponsorNameColor":"#FFFFFF","couponCodes":[{"code":"SMYW1401","link":""}],"lastReminderTime":1721873969950.0,"created":1721875714581.0,"createdAt":ISODate("2024-07-25T02:48:34.611Z"),"updatedAt":ISODate("2024-07-25T11:53:14.763Z")},{"_id":ObjectId("66976d113aaba21b70c1eb6e"),"categoryId":{"_id":ObjectId("6543378ff67159575a37bc03"),"name":{"en":"Beauty","vi":"Làm Đẹp"},"image":"https://livwell.s3.ap-southeast-1.amazonaws.com/web/livwell-vietnam.png","status":"UN_BLOCKED","accessType":"LW"},"PaymentId":{"txnRef":"","amount":null,"status":"","PaymentTime":null},"QRType":"QR_CODE","sponsorImage":"https://livwell.s3.ap-southeast-1.amazonaws.com/web/download.jpeg","hasLocationCheck":false,"isFeatured":false,"isDealsOfTheDay":false,"isLinkAvailable":false,"isCashPlusCoin":false,"amount":0,"isBNPL":false,"isWrapUp":false,"totalRedemption":100,"totalUsers":1,"totalChallenges":0,"usedCoupons":[{"code":"AESBDRVO","link":""}],"discountPercent":1,"totalPoints":89,"hasScanner":false,"hasExternalLink":false,"hasExternalLinkWithCode":false,"status":"UN_BLOCKED","privacy":"PUBLIC","name":{"en":"Reward livwell","vi":"Reward livwell"},"description":{"en":"test","vi":"test"},"instruction":{"en":"test","vi":"test"},"validity":1722450599000.0,"validityColorCode":"#000000","validityBackgroundColorCode":"#000000","notes":{"en":"test","vi":"test"},"image":"https://livwell.s3.ap-southeast-1.amazonaws.com/web/Screenshot%202024-07-01%20at%203.27.52%20PM.png","points":89,"colorCode":"#000000","backgroundColorCode":"#000000","couponCodeType":"MANUAL","type":"COUPON","sponsorLink":"https://admindev.livwell.asia/rewards/add","sponsorName":"test","sponsorDescription":"Reward livwell","sponsorNameColor":"#000000","couponCodes":[{"code":"AESBDRVO","link":""}],"lastReminderTime":1721147229229.0,"created":1721199889898.0,"createdAt":ISODate("2024-07-17T07:04:49.920Z"),"updatedAt":ISODate("2024-07-18T08:01:56.455Z")},{"_id":ObjectId("66969f5dee450841968b73a0"),"categoryId":{"name":{"en":"Beauty","vi":"Làm Đẹp"},"_id":ObjectId("6543378ff67159575a37bc03"),"image":"https://livwell.s3.ap-southeast-1.amazonaws.com/web/livwell-vietnam.png","status":"UN_BLOCKED","accessType":"LW"},"PaymentId":{"txnRef":"","amount":null,"status":"","PaymentTime":null},"QRType":"QR_CODE","sponsorImage":"https://livwell.s3.ap-southeast-1.amazonaws.com/web/download.jpeg","hasLocationCheck":false,"isFeatured":false,"isDealsOfTheDay":false,"isLinkAvailable":false,"isCashPlusCoin":false,"amount":0,"isBNPL":false,"isWrapUp":false,"totalRedemption":1,"totalUsers":1,"totalChallenges":0,"usedCoupons":[{"code":"KAYALW74","link":""}],"discountPercent":10,"totalPoints":10,"hasScanner":false,"hasExternalLink":false,"hasExternalLinkWithCode":false,"status":"UN_BLOCKED","privacy":"PUBLIC","name":{"en":"reward coupom","vi":"reward coupom"},"description":{"en":"KAYALW74","vi":"KAYALW74"},"instruction":{"en":"KAYALW74","vi":"KAYALW74"},"validity":1722450599000.0,"validityColorCode":"#EEEEEE","validityBackgroundColorCode":"#FEFEFE","notes":{"en":"KAYALW74","vi":"KAYALW74"},"image":"https://livwell.s3.ap-southeast-1.amazonaws.com/web/_LW1.jpg","points":9,"colorCode":"#FFFFFF","backgroundColorCode":"#FDFDFD","couponCodeType":"MANUAL","type":"COUPON","sponsorLink":"https://reward.com","sponsorName":"reward coupom","sponsorDescription":"reward coupom","sponsorNameColor":"#000000","couponCodes":[{"code":"KAYALW74","link":""}],"lastReminderTime":1721147229229.0,"created":1721147229265.0,"createdAt":ISODate("2024-07-16T16:27:09.282Z"),"updatedAt":ISODate("2024-07-23T07:45:37.943Z")},{"_id":ObjectId("668b6f66c430d17aebb156b6"),"categoryId":{"name":{"en":"Travel","vi":"Travel"},"_id":ObjectId("5e58ec549062f071c377b143"),"image":"https://livwell.s3.ap-southeast-1.amazonaws.com/web/Liv%20To%20Travel%20%281%29.png","status":"UN_BLOCKED","accessType":"LW"},"PaymentId":{"txnRef":"","amount":null,"status":"","PaymentTime":null},"QRType":"QR_CODE","sponsorImage":"https://livwell.s3.ap-southeast-1.amazonaws.com/web/download.jpeg","hasLocationCheck":false,"isFeatured":false,"isDealsOfTheDay":false,"isLinkAvailable":false,"isCashPlusCoin":false,"amount":0,"isBNPL":false,"isWrapUp":false,"totalRedemption":100,"totalUsers":9,"totalChallenges":0,"usedCoupons":[{"code":"TLIV6183","link":""},{"code":"TLIV6184","link":""},{"code":"TLIV6185","link":""},{"code":"TLIV6186","link":""},{"code":"TLIV6187","link":""},{"code":"TLIV6188","link":""},{"code":"TLIV6189","link":""},{"code":"TLIV6190","link":""},{"code":"TLIV6191","link":""}],"discountPercent":10,"totalPoints":10,"hasScanner":false,"hasExternalLink":false,"hasExternalLinkWithCode":false,"status":"UN_BLOCKED","privacy":"PUBLIC","name":{"en":"reward testing 001","vi":"reward testing 001"},"description":{"en":"test","vi":"test"},"instruction":{"en":"test","vi":"test"},"validity":1723141799000.0,"validityColorCode":"#EDEDED","validityBackgroundColorCode":"#EEEEEE","notes":{"en":"test","vi":"test"},"image":"https://livwell.s3.ap-southeast-1.amazonaws.com/web/_LW1.jpg","points":9,"colorCode":"#FFEEFF","backgroundColorCode":"#FDFDFD","couponCodeType":"AUTO_GENERATE","type":"COUPON","sponsorLink":"https://rewards.com","sponsorName":"Livwell","sponsorDescription":"livwell","sponsorNameColor":"#000000","couponCodes":[{"code":"TLIV6183","link":""}],"lastReminderTime":1720414054333.0,"created":1720414054508.0,"createdAt":ISODate("2024-07-08T04:47:34.528Z"),"updatedAt":ISODate("2024-07-24T03:31:14.797Z")},{"_id":ObjectId("666019914be99e302d766424"),"categoryId":{"_id":ObjectId("5e5c7b6e974e1415078271a6"),"name":{"en":"Eat Well","vi":"Ăn Khoẻ"},"image":"https://livwell.s3.ap-southeast-1.amazonaws.com/web/Liv%20To%20Eat%20Well%20%281%29.png","status":"UN_BLOCKED","accessType":"LW"},"PaymentId":{"txnRef":"","amount":null,"status":"","PaymentTime":null},"QRType":"QR_CODE","sponsorImage":"https://livwell.s3.ap-southeast-1.amazonaws.com/web/download.jpeg","hasLocationCheck":false,"isFeatured":false,"isDealsOfTheDay":false,"isLinkAvailable":false,"isCashPlusCoin":false,"amount":0,"isBNPL":false,"isWrapUp":false,"totalRedemption":100,"totalUsers":6,"totalChallenges":0,"usedCoupons":[{"code":"ELIV3519","link":""},{"code":"ELIV3520","link":""},{"code":"ELIV3521","link":""},{"code":"ELIV3522","link":""},{"code":"ELIV3523","link":""},{"code":"ELIV3524","link":""}],"discountPercent":40,"totalPoints":100,"hasScanner":false,"hasExternalLink":false,"hasExternalLinkWithCode":false,"status":"UN_BLOCKED","privacy":"PUBLIC","name":{"en":"reward test 1221","vi":"reward test 1221"},"description":{"en":"test","vi":"test"},"instruction":{"en":"test","vi":"test"},"validity":1730393999000.0,"validityColorCode":"#FDFDFD","validityBackgroundColorCode":"#FDFDFD","notes":{"en":"test","vi":"test"},"image":"https://livwell.s3.ap-southeast-1.amazonaws.com/web/_LW1.jpg","points":60,"colorCode":"#FFFFFF","backgroundColorCode":"#FEFEFD","couponCodeType":"AUTO_GENERATE","type":"COUPON","sponsorLink":"https://rewards.com","sponsorName":"Livwell","sponsorDescription":"livwell","sponsorNameColor":"#FFFFFF","couponCodes":[{"code":"ELIV3519","link":""}],"lastReminderTime":1717574033393.0,"created":1717574033548.0,"createdAt":ISODate("2024-06-05T07:53:53.563Z"),"updatedAt":ISODate("2024-07-24T03:14:44.150Z")}]

db.collection.aggregate([{"$project":{validity:"$validity",name:"$name.en",points:"$points",_id:"$_id",description:"$description.en",image:"$image",colorCode:"$colorCode",backgroundColorCode:{$ifNull:["$backgroundColorCode","#FF0000"]},categoryId:{_id:"$categoryId._id",name:"$categoryId.name"},created:"$created",totalPoints:"$totalPoints",rewardType:"CUSTOM_REWARD",sponsorName:"$sponsorName",sponsorNameColor:{$ifNull:["$sponsorNameColor","#808080"]},sponsorImage:{$ifNull:["$sponsorImage","https://livwell.s3.ap-southeast-1.amazonaws.com/web/download.jpeg"]},isLinkAvailable:"$isLinkAvailable",discountPercent:"$discountPercent",hasExternalLink:"$hasExternalLink",buyerCount:"$totalUsers",buyerTextColor:"#FFFFFF",buyerBackgroundColorCode:"#00FF00",validityColorCode:{$ifNull:["$validityColorCode","#FDFDFD"]},validityBackgroundColorCode:{$ifNull:["$validityBackgroundColorCode","#FF0000"]},/** isDealsOfTheDay: "$isDealsOfTheDay",* isFeatured: "$isFeatured",*/hasExternalLinkWithCode:"$hasExternalLinkWithCode",hasScanner:"$hasScanner",corporateId:"$corporateId"}},{$group:{_id:"$_id",doc:{$first:"$$ROOT"}}},{$replaceRoot:{newRoot:"$doc"}},{$facet:{mostPurchased:[{$sort:{buyerCount:-1}},{$limit:15}],latestRewards:[{$sort:{created:-1}},{$limit:15}],suggestedRewards:[{$match:{points:{$lt:300}}},{$limit:15}]}},{$project:{mostPurchased:1,latestRewards:1,suggestedRewards:1}}])