StatController.php 1.2 KB

12345678910111213141516171819202122232425262728293031323334353637
  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. ->where('status', '3')
  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. ->count(),
  31. ]
  32. ]);
  33. }
  34. }