Advertisement
Guest User

Untitled

a guest
Jun 26th, 2019
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.28 KB | None | 0 0
  1. $revenueMonth = Callback::where('created_at', '>=', Carbon::today()->startOfMonth()->subMonth())->sum('payment');
  2.  
  3. $revenueMonth = Callback::whereMonth(
  4. 'created_at', '=', Carbon::now()->subMonth()->month
  5. );
  6.  
  7. $revenueMonth = Callback::where(
  8. 'created_at', '>=', Carbon::now()->subDays(30)->toDateTimeString()
  9. );
  10.  
  11. $revenueMonth = Callback::where(
  12. 'created_at', '>=', Carbon::now()->firstOfMonth()->toDateTimeString()
  13. );
  14.  
  15. $revenueMonth = Callback::where(
  16. 'created_at', '>=', Carbon::now()->startOfMonth()->subMonth()->toDateString()
  17. );
  18.  
  19. $revenueMonth = Callback::where(
  20. 'created_at', '>=', Carbon::now()->subMonth()->toDateTimeString()
  21. );
  22.  
  23. $fromDate = Carbon::now()->subMonth()->startOfMonth()->toDateString();
  24. $tillDate = Carbon::now()->subMonth()->endOfMonth()->toDateString();
  25.  
  26. $revenueLastMonth = Callback::whereBetween(DB::raw('date(created_at)'), [$fromDate, $tillDate])->get();
  27.  
  28. 2017-09-07 09:46:43
  29. 2017-09-07 09:46:43
  30. 2017-09-07 09:46:43
  31. 2017-09-02 09:46:43
  32. 2017-08-07 09:46:43
  33.  
  34. $fromDate = Carbon::now()->subMonth()->startOfMonth()->toDateString();
  35. $tillDate = Carbon::now()->subMonth()->endOfMonth()->toDateString();
  36.  
  37. $revenueLastMonth = Callback::whereBetween('created_at',[$fromDate,$tillDate])->get();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement