bot-28/app/Models/Sport.php

<?php

namespace App\Models;
use App\Models\SportLeague;
use App\Models\SportTeam;


class Sport extends BaseModel
{
    protected $table = 'sport';
    protected $fillable = ['data_id', 'home_team_id', 'home_team_en', 'home_team', 'home_team_logo', 'guest_team_id', 'guest_team_en', 'guest_team', 'guest_team_logo', 'half_score', 'rbt', 
    'is_roll', 'score', 'league_en','league','odds','state','game_time','status','handicap_limit','over_under_limit','duying_limit','correct_core_limit','odd_even_limit','total_goal_limit',
    'is_handicap', 'is_over_under','is_duying','is_correct_core','is_odd_even','is_total_goal','is_locked','fixture_status','is_send','odd_ids_locked','refund_status'];
    
    public static function getLongStatus($status){
        $long_status = [
            'Time To Be Defined' => '时间待定',
            'Not Started' => '未开赛',
            'First Half' => '上半场',
            'First Half, Kick Off' => '上半场，开球',
            'Halftime' => '中场休息',
            'Second Half' => '下半场',
            'Second Half, 2nd Half Started' => '下半场，已开球',
            'Extra Time' => '加时赛',
            'Break Time' => '休息时间（常规赛与加时赛之间）',
            'Penalty In Progress' => '点球大战进行中',
            'Match Suspended' => '比赛暂停',
            'Match Interrupted' => '比赛中断',
            'Match Finished' => '比赛结束',
            'Match Postponed' => '比赛延期',
            'Match Cancelled' => '比赛取消',
            'Match Abandoned' => '比赛腰斩（废弃）',
            'Technical Loss' => '技术性判负',
            'WalkOver' => '弃权/退赛（对手直接晋级）',
            'In Progress' => '进行中',
        ];
        return $long_status[$status] ?? $status;
    }

    public static function addSportTeam($sport_data){
        if (!empty($sport_data['home_team_id'])) {
            $team = SportTeam::where('team_id', $sport_data['home_team_id'])->first();
            if (!$team) { 
                SportTeam::create([
                    'team_id' => $sport_data['home_team_id'],
                    'team_name_en' => $sport_data['home_team'],
                    'logo' => $sport_data['home_team_logo'],
                ]);
            }
        } 
        if (!empty($sport_data['guest_team_id'])) {
            $team = SportTeam::where('team_id', $sport_data['guest_team_id'])->first();
            if (!$team) { 
                SportTeam::create([
                    'team_id' => $sport_data['guest_team_id'],
                    'team_name_en' => $sport_data['guest_team'],
                    'logo' => $sport_data['guest_team_logo'],
                ]);
            }
        }
        return true;
    }

    public static function addSportLeague($league){
        if (!empty($league['name'])) {
            $league = SportLeague::where('league_name_en', $league['name'])->first();
            if (!$league) { 
                SportLeague::create([
                    'league_name_en' => $league['name'],
                    'logo' => $league['logo'] ?? '',
                ]);
            }
        } 
        return true;
    }
}