Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $report = Transaction::select(DB::raw('sum(amount) as amount, entityId'))
- ->join('channels', 'transactionsV2.entityId', 'channels.uuid')
- ->join('merchants', 'merchants.uuid', 'channels.sender')
- ->where('paymentType', '=', 'DB')
- ->where('status', 1)
- ->where('processing_time', '>=', '2019-01-01 00:00:00')
- ->where('processing_time', '<=', '2019-01-21 23:59:59')
- ->get();
Add Comment
Please, Sign In to add comment