I have two table transaction and employee.
Lookup on emplyee table
Group By on :- user_id
Filter on : coupon_users_details.created_at (format ‘Y-m-d’)
[
{
“user_id”: 9,
“name”:”abc”,
“coupon_amount”:[
{
“is_cancelled”:1,
“coupon_amount”:20
},
{
“is_cancelled”:1,
“coupon_amount”:20
}
]
},
{
“user_id”: 9,
“name”:”abc”,
“coupon_amount”:[
{
“is_cancelled”:1,
“coupon_amount”:20
},
{
“is_cancelled”:1,
“coupon_amount”:20
}
]
}
]