Guest User

Untitled

a guest
Jan 21st, 2019
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.39 KB | None | 0 0
  1. $report = Transaction::select(DB::raw('sum(amount) as amount, entityId'))
  2. ->join('channels', 'transactionsV2.entityId', 'channels.uuid')
  3. ->join('merchants', 'merchants.uuid', 'channels.sender')
  4. ->where('paymentType', '=', 'DB')
  5. ->where('status', 1)
  6. ->where('processing_time', '>=', '2019-01-01 00:00:00')
  7. ->where('processing_time', '<=', '2019-01-21 23:59:59')
  8. ->get();
Add Comment
Please, Sign In to add comment