StatController.php 1.7 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546
  1. <?php
  2. namespace App\Http\Controllers\Admin;
  3. use Illuminate\Http\Request;
  4. use App\Http\Controllers\Controller;
  5. use App\Models\ServerGroup;
  6. use App\Models\Server;
  7. use App\Models\Plan;
  8. use App\Models\User;
  9. use App\Models\Ticket;
  10. use App\Models\Order;
  11. use Illuminate\Support\Facades\Cache;
  12. class StatController extends Controller
  13. {
  14. public function getOverride(Request $request)
  15. {
  16. return response([
  17. 'data' => [
  18. 'month_income' => Order::where('created_at', '>=', strtotime(date('Y-m-1')))
  19. ->where('created_at', '<', time())
  20. ->whereIn('status', [3, 4])
  21. ->sum('total_amount'),
  22. 'month_register_total' => User::where('created_at', '>=', strtotime(date('Y-m-1')))
  23. ->where('created_at', '<', time())
  24. ->count(),
  25. 'ticket_pendding_total' => Ticket::where('status', 0)
  26. ->count(),
  27. 'commission_pendding_total' => Order::where('commission_status', 0)
  28. ->where('invite_user_id', '!=', NULL)
  29. ->where('status', 3)
  30. ->where('commission_balance', '>', 0)
  31. ->count(),
  32. 'day_income' => Order::where('created_at', '>=', strtotime(date('Y-m-d')))
  33. ->where('created_at', '<', time())
  34. ->where('status', 3)
  35. ->sum('total_amount'),
  36. 'last_month_income' => Order::where('created_at', '>=', strtotime('-1 month', strtotime(date('Y-m-1'))))
  37. ->where('created_at', '<', strtotime(date('Y-m-1')))
  38. ->where('status', 3)
  39. ->sum('total_amount')
  40. ]
  41. ]);
  42. }
  43. }