StatController.php 784 B

1234567891011121314151617181920212223242526272829
  1. <?php
  2. namespace App\Http\Controllers\User;
  3. use App\Http\Controllers\Controller;
  4. use App\Models\StatUser;
  5. use Illuminate\Http\Request;
  6. use Illuminate\Support\Facades\DB;
  7. class StatController extends Controller
  8. {
  9. public function getTrafficLog(Request $request)
  10. {
  11. $builder = StatUser::select([
  12. DB::raw('sum(u) as u'),
  13. DB::raw('sum(d) as d'),
  14. 'record_at',
  15. 'user_id',
  16. 'server_rate'
  17. ])
  18. ->where('user_id', $request->session()->get('id'))
  19. ->where('record_at', '>=', strtotime(date('Y-m-1')))
  20. ->groupBy('record_at', 'user_id', 'server_rate')
  21. ->orderBy('record_at', 'DESC');
  22. return response([
  23. 'data' => $builder->get()
  24. ]);
  25. }
  26. }