FixtureService.php 2.0 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243
  1. <?php
  2. namespace App\Services;
  3. use App\Models\Sport;
  4. use App\Services\ApiFootball\Client;
  5. use Carbon\Carbon;
  6. class FixtureService extends BaseService
  7. {
  8. static function index()
  9. {
  10. $date = Carbon::tomorrow()->toDateString();
  11. $data = Client::fixtures(['date' => $date]);
  12. $data = $data['response'];
  13. $tableData = [];
  14. $status = ['NS' => 0, '1H' => 1, 'HT' => 1, '2H' => 1, 'ET' => 1, 'BT' => 1, 'P' => 1, 'SUSP' => 1, 'INT' => 1, 'LIVE' => 1, 'FT' => 2, 'AET' => 2, 'PEN' => 2, 'PST' => 3, 'CANC' => 4, 'ABD' => 4,];
  15. foreach ($data as $item) {
  16. if (!Sport::where('data_id', $item['fixture']['id'])->exists()) {
  17. $tableData[] = [
  18. 'data_id' => $item['fixture']['id'],
  19. 'home_team_id' => $item['teams']['home']['id'],
  20. 'home_team_en' => $item['teams']['home']['name'],
  21. 'home_team' => lang($item['teams']['home']['name']),
  22. 'home_team_logo' => $item['teams']['home']['logo'],
  23. 'guest_team_id' => $item['teams']['away']['id'],
  24. 'guest_team_en' => $item['teams']['away']['name'],
  25. 'guest_team' => lang($item['teams']['away']['name']),
  26. 'guest_team_logo' => $item['teams']['away']['logo'],
  27. 'half_score' => "{$item['score']['halftime']['home']}-{$item['score']['halftime']['away']}",
  28. 'rbt' => $item['fixture']['timestamp'],
  29. 'score' => "{$item['goals']['home']}-{$item['goals']['away']}",
  30. 'league' => lang($item['league']['name']),
  31. 'league_en' => $item['league']['name'],
  32. 'state' => $status[$item['fixture']['status']['short']],//比赛状态:0未开始1进行中2已完场3延期4取消
  33. 'game_time' => $item['fixture']['timestamp'],
  34. ];
  35. }
  36. }
  37. Sport::insert($tableData);
  38. return $tableData;
  39. }
  40. }