sports_admin/app/Http/Controllers/Admin/SportsSoccerController.php

<?php

namespace App\Http\Controllers\Admin;

use App\Http\Controllers\Controller;
use Illuminate\Http\Request as Req;
use Illuminate\Support\Facades\DB;
Use App\Lib\Settlement\SettlementWinFail;
use App\Models;
use Request;

/**
 *1
 */
class SportsSoccerController extends Controller
{

    public function score(Req $req)
    {
        $request['name_chinese'] = isset($req->name_chinese) ? trim($req->name_chinese) : '';
        $request['home_team'] = isset($req->home_team) ? trim($req->home_team) : null;
        $request['match_date'] = isset($req->match_date) ? trim($req->match_date) : null;
        $request['recommend'] = isset($req->recommend) ? trim($req->recommend) : '';
        $request['status'] = isset($req->status) ? trim($req->status) : '-1';
        $request['sureblurs'] = isset($req->sureblurs) ? $req->sureblurs : 'on';
        $request['star_time'] = isset($req->star_time) ? trim($req->star_time) : null;
        $request['end_time'] = isset($req->end_time) ? trim($req->end_time) : null;

        $request['is_rollball'] = isset($req->is_rollball) ? trim($req->is_rollball) : '0';
        $request['is_today'] = isset($req->is_today) ? trim($req->is_today) : '0';
        $request['is_morningplate'] = isset($req->is_morningplate) ? trim($req->is_morningplate) : '0';
        $request['is_stringscene'] = isset($req->is_stringscene) ? trim($req->is_stringscene) : '0';

        $source = \App\Models\Setinfo::where('id', '1000')->first();
        if ($source->infocontent != '混合数据') {
            $data = \App\Models\SoccerLeague::join('st_zq_local_league', 'st_zq_league.id', '=', 'st_zq_local_league.lg_id')->select('st_zq_league.id', 'st_zq_league.name_chinese')->where('st_zq_local_league.source', $source->infocontent)->get();
        } else {
            $data = \App\Models\SoccerLeague::select('id', 'name_chinese')->get();
        }

        $request['league'] = $data;
        $dt = \App\Lib\DataTable\DataTable::init();
        $dt->setDataSource('/admin/SportsSoccer/info');
        $dt->setLang('sportsbase');
        $dt->addColsFields('id', array('templet' => '#userdetail', 'sort' => true, 'width' => 100));
        $dt->addColsFields('lg_id', array('templet' => '#userdetail', 'sort' => true, 'width' => 100));
        $dt->addColsFields('name_chinese', array('templet' => '#userdetail', 'sort' => false, 'width' => 200));
        $dt->addColsFields('home_guest', array('templet' => '#userdetail', 'sort' => false, 'width' => 260));
        $dt->addColsFields('match_date', array('templet' => '#userdetail', 'sort' => true, 'width' => 120));
        $dt->addColsFields('match_time', array('templet' => '#userdetail', 'sort' => true, 'width' => 100));
        $dt->addColsFields('recommend', array('templet' => '#recommend', 'sort' => false, 'width' => 120, 'align' => 'center'));
        $dt->addColsFields('status', array('templet' => '#userdetail', 'sort' => false, 'width' => 100));
        if (checkRriv('/admin/SportsSoccer/edit')) {
            $arr[] = 'edit';
        }
        if (checkRriv('/admin/SportsSoccer/odds')) {
            $arr[] = 'odds';
        }
        $dt->setToolBar($arr, array('width' => 200));
        $dt->enableCheckBox();
        return view('sports/soccer_match', $dt->render($request));
    }

    function info(Req $req)
    {
        $page = Request::has('page') ? Request::get('page') : '';
        $list = Request::has('limit') ? Request::get('limit') : 10;
        $name_chinese = Request::has('name_chinese') ? Request::get('name_chinese') : '';
        $home_team = Request::has('home_team') ? Request::get('home_team') : '';
        $match_date = Request::has('match_date') ? Request::get('match_date') : '';
        $star_time = Request::get('star_time') ? Request::get('star_time') : '';
        $end_time = Request::get('end_time') ? Request::get('end_time') : '';
        $status = Request::has('status') ? Request::get('status') : '';
        $sureblur = Request::has('sureblurs') ? Request::get('sureblurs') : 'off';
        $where = array();
        $orwhere = array();
        if (!empty($name_chinese)) {
            if (empty($sureblur) || $sureblur == 'off') {
                $where[] = array('st_zq_league.name_chinese', 'like', '%' . $name_chinese . '%');
            } else {
                $where[] = array('st_zq_league.name_chinese', '=', $name_chinese);
            }
        }
        if (!empty($home_team)) {
            if (empty($sureblur) || $sureblur == 'off') {
                $where[] = array('st_zq_competition.home_team', 'like', '%' . $home_team . '%');
                $orwhere[] = array('st_zq_competition.guest_team', 'like', '%' . $home_team . '%');
            } else {
                $where[] = array('st_zq_competition.home_team', '=', $home_team);
                $orwhere[] = array('st_zq_competition.guest_team', '=', $home_team);
            }
        }

        if (!empty($star_time)) {
            if (!empty($end_time)) {
                $where[] = array('st_zq_competition.match_date', '>=', $star_time);
                $where[] = array('st_zq_competition.match_date', '<=', $end_time);
            } else {
                $where[] = array('st_zq_competition.match_date', '>=', $star_time);
            }
        } else if (empty($star_time)) {
            if (!empty($end_time)) {

                $where[] = array('st_zq_competition.match_date', '<=', $end_time);
            }
        }

        if ($status != -1) {
            $where[] = array('st_zq_competition.status', '=', $status);
        }

        $newapp = new \App\Models\SportsSoccer();
        $data = $newapp->getinfo($list, $page, $where, $orwhere);
        return \App\Lib\DataTable\DataTable::init()->toJson($data['data'], $data['total']);
    }

    /**
     *设置是否为推荐赛事
     */
    function recommendmatch(Req $req)
    {
        $id = $req->id;
        $recommend = is_numeric($req->recommend) ? intval($req->recommend) : '';
        if (empty($id) || !is_numeric($recommend)) {
            return responseToJson(-2020100102);
        }
        $u_db = new \App\Models\SportsSoccer;
        $data = array(
            'recommend' => $recommend,
        );
        $res = $u_db->updateInfos($data, $id);
        return responseToJson($res);
    }

    /**
     *获取所有足球联赛信息
     */
    function getParent()
    {
        $source = \App\Models\Setinfo::where('id', '1000')->first();
        if ($source->infocontent != '混合数据') {
            $data = \App\Models\SoccerLeague::join('st_zq_local_league', 'st_zq_league.id', '=', 'st_zq_local_league.lg_id')->select('st_zq_league.id', 'st_zq_league.name_chinese')->where('st_zq_local_league.source', $source->infocontent)->get();
        } else {
            $data = \App\Models\SoccerLeague::select('id', 'name_chinese')->get();
        }

        if (!$data) {
            return;
        }
        return $data->toArray();
    }

    /**
     *获取所有国家信息
     */
    function getCountry()
    {
        $data = \App\Models\Country::select('country_id', 'name_chinese')->get();
        if (!$data) {
            return;
        }
        for ($i = 0; $i < count($data); $i++) {
            $data[$i]->home_country_name = $data[$i]->name_chinese;
            $data[$i]->home_country_id = $data[$i]->country_id;
            $data[$i]->guest_country_name = $data[$i]->name_chinese;
            $data[$i]->guest_country_id = $data[$i]->country_id;
        }
        return $data->toArray();
    }

    /**
     *获取国家的球队信息
     */
    function getteam()
    {
        $countryid = $_GET["countryid"];
        $gametype = \App\Models\StGameType::where('game_code', 'zq')->first();
        $res = \App\Models\Team::where('country_id', $countryid)->where('game_type_id', $gametype->id)->get();
        return json_encode($res);
    }

    /**
     *添加赛事
     */
    function add(Req $req)
    {
        if (!$req->isMethod('post')) {
            $parents = $this->getParent();
            $lange = trans('menu');
            foreach ($parents as $k => $v) {
                $arr = trim($parents[$k]['name_chinese']);
                if (isset($lange[$arr])) {
                    $parents[$k]['name'] = $lange[$arr];
                }
            }
            $data['parents'] = $parents;
            $data['match_date'] = date('Y-m-d');
            $data['match_time'] = date('H:i:s');

            return view('sports.soccer_form', $data);
        } else {
            $model = new \App\Models\SportsSoccer();
            $model->home_team = $req->input('home_team');
            $model->guest_team = $req->input('guest_team');
            $model->lg_id = $req->input('parent_id');
            $model->match_date = $req->input('match_date');
            $model->match_time = $req->input('match_time');
            $model->status = $req->input('status');
            if ($req->input('is_rollball') == true) {
                $model->is_rollball = 1;
            } else {
                $model->is_rollball = 0;
            }
            if ($req->input('is_today') == true) {
                $model->is_today = 1;
            } else {
                $model->is_today = 0;
            }
            if ($req->input('is_morningplate') == true) {
                $model->is_morningplate = 1;
            } else {
                $model->is_morningplate = 0;
            }
            if ($req->input('is_stringscene') == true) {
                $model->is_stringscene = 1;
            } else {
                $model->is_stringscene = 0;
            }
            $model->match_id = time();
            $model->ctime = date('Y-m-d H:i:s', time());
            $model->utime = date('Y-m-d H:i:s', time());
            $model->tag = mt_rand(0, 100);
            $model->source = 'user-defined';

            $db = new \App\Models\Stzqlocalmatch();
            $db->source = 'user-defined';
            $db->match_id = $model->match_id;

            $model->save();
            $db->save();
            return responseToJson(1);

        }
    }

    function view(Req $req)
    {
        return $this->edit($req);
    }

    /**
     *修改赛事1
     */
    function edit(Req $req)
    {
        $id = $req->id;
        if (intval($id) < 1) {
            return -1;
        }
        if (!$req->isMethod('post')) {
            // $country = $this->getCountry();
            // $countrys = $this->getCountry();
            $data = \App\Models\SportsSoccer::where('id', $id)->first();
            if (!$data) {
                return -2;
            }

            //查看赛事是否有下注细信息
            $res = \App\Models\MoneyBuyMatch::where('match_id', $id)->get()->toArray();
            if (!empty($res)) {
                if ($data->status == 0) {//有注单的未开始赛事
                    $match_status = array(['status' => 0, 'name' => '未开始'], ['status' => 1, 'name' => '正在进行'], ['status' => 4, 'name' => '作废']);
                }
                if ($data->status == 1) {//有注单的已开始赛事
                    $match_status = array(['status' => 1, 'name' => '正在进行'], ['status' => 2, 'name' => '已结束'], ['status' => 4, 'name' => '作废']);
                }
            } else {
                if ($data->status == 0) {//无注单的未开始赛事
                    $match_status = array(['status' => 0, 'name' => '未开始'], ['status' => 1, 'name' => '正在进行'], ['status' => 6, 'name' => '取消']);
                }
                if ($data->status == 1) {//无注单的已开始赛事
                    $match_status = array(['status' => 1, 'name' => '正在进行'], ['status' => 2, 'name' => '已结束'], ['status' => 4, 'name' => '作废'], ['status' => 6, 'name' => '取消']);
                }
            }
            if ($data->status == 2) {//已结束
                $match_status = array(['status' => 2, 'name' => '已结束'], ['status' => 4, 'name' => '作废']);
            }
            if ($data->status == 3) {//已结算
                $match_status = array(['status' => 3, 'name' => '已结算'], ['status' => 5, 'name' => '待结算']);
            }
            if ($data->status == 4) {//已作废
                $match_status = array(['status' => 4, 'name' => '作废'], ['status' => 6, 'name' => '取消']);
            }
            if ($data->status == 5) {//待结算
                $match_status = array(['status' => 0, 'name' => '未开始'], ['status' => 1, 'name' => '正在进行'],['status' => 5, 'name' => '待结算'], ['status' => 4, 'name' => '作废']);
            }
            if ($data->status == 6) {//已取消
                $match_status = array(['status' => 0, 'name' => '未开始'], ['status' => 1, 'name' => '正在进行'], ['status' => 2, 'name' => '已结束'],['status' => 6, 'name' => '取消']);
            }

            $name_chinese = \App\Models\SoccerLeague::where('id', $data->lg_id)->first();
            $data->name_chinese = $name_chinese->name_chinese;
            $data = $data->toArray();
            $data['parents'] = $this->getParent();
            // $data['country'] = $country;
            // $data['countrys'] = $countrys;

            $data['match_status'] = $match_status;

            foreach ($data['parents'] as $k => $v) {
                $arr = trim($data['parents'][$k]['name_chinese']);
                if (isset($lange[$arr])) {
                    $data['parents'][$k]['name_chinese'] = $lange[$arr];
                }
            }

            return view('sports.soccer_form', $data);
        } else {
            $model = new \App\Models\SportsSoccer();
            $model->id = $req->input('id');
            $model = $model::find($model->id);
            $model->home_team = $req->input('home_team');
            $model->guest_team = $req->input('guest_team');
//            if(gettype($req->input('parent_id'))=='integer'){
//                $model->lg_id = $req->input('parent_id');
//            }else{
//                $model->name_chinese = $req->input('parent_id');
//                $res = \App\Model\SportsLeague::where('name_chinese',$model->name_chinese)->first();
//                $model->lg_id = $res->lg_id;
//            }
            $model->lg_id = $req->input('parent_id');
            $model->match_date = $req->input('match_date');
            $model->match_time = $req->input('match_time');
            $model->status = $req->input('status');
            if ($req->input('is_rollball') == true) {
                $model->is_rollball = 1;
            } else {
                $model->is_rollball = 0;
            }
            if ($req->input('is_today') == true) {
                $model->is_today = 1;
            } else {
                $model->is_today = 0;
            }
            if ($req->input('is_morningplate') == true) {
                $model->is_morningplate = 1;
            } else {
                $model->is_morningplate = 0;
            }
            if ($req->input('is_stringscene') == true) {
                $model->is_stringscene = 1;
            } else {
                $model->is_stringscene = 0;
            }
            $model->ctime = date('Y-m-d H:i:s', time());
            $model->utime = date('Y-m-d H:i:s', time());
            $model->save();
            return responseToJson(1);
        }
    }

    /**
     *删除赛事
     */
    public function delete(Req $req)
    {
        $id = $req->input('id');
        if (empty($id)) {
            return responseToJson(-2001);
        }
        $ids = explode(',', $id);
        if (!is_array($ids) && intval($ids) < 0) {
            return responseToJson(-2002);
        }
        $id = array();
        $localmatch = \App\Models\Stzqlocalmatch::get();
        if (is_array($ids) && count($ids) > 0) {
            foreach ($ids as $k => $v) {
                if (intval($v) < 1) {
                    unset($ids[$k]);
                }
                $match = \App\Models\SportsSoccer::where('id', $v)->first();
                for ($i = 0; $i < count($localmatch); $i++) {
                    if ($localmatch[$i]->match_id == $match->match_id) {
                        $id[] = $localmatch[$i]->id;
                    }
                }
            }
        }

        $rows = \App\Models\SportsSoccer::whereIn('id', $ids)->delete();
        if (!$rows) {
            return responseToJson(-2003);
        }
        if (count($id) > 0) {
            $row = \App\Models\Stzqlocalmatch::whereIn('id', $id)->delete();
            if (!$row) {
                return responseToJson(-2003);
            }
        }
        return responseToJson(1, trans('menu.delete_success'));

    }

    /**
     *赛事结果处理1
     */
    public function dealwith(Req $req)
    {
        $id = $req->id;
        if (intval($id) < 1) {
            return -1;
        }

        $SettlementWinFail = new SettlementWinFail();
        $data = $SettlementWinFail->doRun($id);
        return $data;
    }

    function odds(Req $req)
    {
        $cp_id = $req->id;
        $request['status'] = isset($req->status) ? trim($req->status) : '-1';
        $request['p_code'] = isset($req->p_code) ? trim($req->p_code) : '-1';
        $request['id'] = isset($req->id) ? trim($req->id) : null;
        $request['odds_id'] = isset($req->odds_id) ? trim($req->odds_id) : '';
        $newapp = \App\Models\SportsSoccer::where('id', $request['id'])->first();

        if (empty($newapp)) {
            $match_id = $req->input('id');
        } else {
            $match_id = $newapp->id;
        }
        $request['match_id'] = isset($match_id) ? trim($match_id) : null;
        $data = \App\Models\Matchcode::where('p_id', '0')->where('game_code', 'zq')->get();

        $request['pcode'] = $data;
        $dt = \App\Lib\DataTable\DataTable::init();
        $dt->setDataSource('/admin/SportsSoccer/oddsinfo?match_id=' . $match_id . '');
        $dt->setLang('sportssoccer');
        $dt->addColsFields('id', array('templet' => '#userdetail', 'sort' => true, 'width' => 80));
        $dt->addColsFields('match_id', array('templet' => '#userdetail', 'sort' => true, 'width' => 100));
        $dt->addColsFields('odds_code_cn', array('templet' => '#userdetail', 'sort' => false, 'width' => 200));
        $dt->addColsFields('condition', array('templet' => '#userdetail', 'sort' => false, 'width' => 80));
        $dt->addColsFields('odds', array('templet' => '#userdetail', 'sort' => false, 'width' => 80));
        $dt->addColsFields('p_code_cn', array('templet' => '#userdetail', 'sort' => false, 'width' => 120));
        $dt->addColsFields('max', array('templet' => '#userdetail', 'sort' => false, 'width' => 100));
        $dt->addColsFields('min', array('templet' => '#userdetail', 'sort' => false, 'width' => 100));
        $dt->addColsFields('status', array('templet' => '#userdetail', 'sort' => false, 'width' => 80));
        $dt->addColsFields('expire_time', array('templet' => '#userdetail', 'sort' => false, 'width' => 100));
        $dt->addColsFields('source', array('templet' => '#userdetail', 'sort' => false, 'width' => 100));
        if (checkRriv('/admin/SportsSoccer/oddsedit?id=' . $cp_id . '')) {
            $arr[] = 'oddsedit';
        }
        $dt->setToolBar($arr, array('width' => 150));
        $dt->enableCheckBox();

        return view('sports/soccer_odds', $dt->render($request));
    }

    /**
     * 1
     */
    function oddsinfo(Req $req)
    {
        $lange = trans('sportsoddscode');
        $match_id = $req->match_id;
        $odds_id = Request::has('odds_id') ? Request::get('odds_id') : '';
        $p_code = Request::has('p_code') ? Request::get('p_code') : '';
        $status = Request::has('status') ? Request::get('status') : '';//状态 默认0启用 1停用 -1禁用
        $where = array();
        if (!empty($p_code) && $p_code != -1) {
            $where[] = array('st_zq_odds.p_code', '=', $p_code);
        }
        if ($status != '-1') {
            if($status == 2){
                $status = -1;
            } 
            $where[] = array('st_zq_odds.status', '=', $status);
        }
        if(!empty($odds_id)){
            $where[] = array('st_zq_odds.id', '=', $odds_id);
        }

        if (intval($match_id) < 1) {
            return -1;
        }
        $new = new \App\Models\SoccerOdds();
        $data = $new->getodds($match_id, $where);

        foreach ($data as $k => $v) {
            $odds_code = trim($data[$k]['odds_code']);
            $p_code = trim($data[$k]['p_code']);
            if (isset($lange[$odds_code])) {
                $data[$k]['odds_code'] = $lange[$odds_code];
            }
            if (isset($lange[$p_code])) {
                $data[$k]['p_code'] = $lange[$p_code];
            }
        };

        return \App\Lib\DataTable\DataTable::init()->toJson($data);
    }

    /**
     *根据选择的父级赔率代码获取对应的子级赔率代码
     */
    function getoddscode()
    {
        $p_code = $_GET["pcode"];

        $res = \App\Models\Matchcode::where(['odds_code'=>$p_code,'game_code'=>'zq'])->first();
        $codedata = \App\Models\Matchcode::where('p_id', $res->id)->get();
        return json_encode($codedata);
    }

    /**
     *添加赔率
     */
    function addodds(Req $req)
    {
        $pcodedata = \App\Models\Matchcode::where('p_id', '0')->where('game_code', 'zq')->get();
        for ($i = 0; $i < count($pcodedata); $i++) {
            $pcodedata[$i]->p_code = $pcodedata[$i]->odds_code;
        }

        if (!$req->isMethod('post')) {
            $cp_id = $_SERVER['QUERY_STRING'];  //获取url中的参数--赛事id
            $data = ["match_id" => $cp_id];
            $data['pcode'] = $pcodedata;
            return view('sports.soccer_odds_form', $data);
        } else {
            $model = new \App\Models\SoccerOdds();
            $date = new \App\Models\SoccerOddsRecord();
            $model->match_id = $req->input('match_id');
            $model->odds_code = $req->input('code');
            $model->status = $req->input('status');
            $model->p_code = $req->input('pcode');
            $res = \App\Models\Matchcode::where(['odds_code'=>$model->p_code,'game_code'=>'zq'])->first();
            $model->p_id = $res->id;
            $result = \App\Models\SoccerOdds::where('odds_code', $model->odds_code)->where('p_id', $model->p_id)->orderby('utime', 'desc')->first();
            if (!empty($result)) {
                $sort = $result->sort;
                $model->sort = $sort + 1;
            } else {
                $model->sort = 0;
            }
            $model->odds = $req->input('odds');
            $model->condition = $req->input('condition');
            $model->max = $req->input('max');
            $model->min = $req->input('min');
            $model->ctime = date('Y-m-d H:i:s', time());
            $model->utime = date('Y-m-d H:i:s', time());
            $model->sole = md5($model->match_id . $model->odds_code . $model->sort . $model->p_id . $model->ctime);
            $model->source = 'user-defined';
            $lg_id = \App\Models\SportsSoccer::where('id', $model->match_id)->first();
            if (!empty($lg_id)) {
                $model->lg_id = $lg_id->lg_id;
            }
            $model->expire_time = $req->input('expire_time');
            $model->odds_only = md5($model->match_id . $model->odds_code . $model->ctime);

            $date->match_id = $model->match_id;
            $date->odds_code = $model->odds_code;
            $date->status = $model->status;
            $date->p_code = $model->p_code;
            $date->p_id = $model->p_id;
            $record = \App\Models\SoccerOddsRecord::where('odds_code', $date->odds_code)->where('p_id', $date->p_id)->orderby('utime', 'desc')->first();
            if (!empty($record)) {
                $sort = $record->sort;
                $date->sort = $sort + 1;
            } else {
                $date->sort = 0;
            }
            $date->odds = $model->odds;
            $date->condition = $model->condition;
            $date->max = $model->max;
            $date->min = $model->min;
            $date->ctime = $model->ctime;
            $date->utime = $model->utime;
            $date->source = $model->source;
            $date->lg_id = $model->lg_id;
            $date->odds_only = $model->odds_only;

            $model->save();
            $date->save();
            return responseToJson(1);
        }
    }

    /**
     *修改赔率
     */
    function oddsedit(Req $req)
    {
        $lange = trans('sportsoddscode');
        $pcodedata = \App\Models\Matchcode::where('p_id', '0')->where('game_code', 'zq')->get();
        for ($i = 0; $i < count($pcodedata); $i++) {
            $pcodedata[$i]->p_code = $pcodedata[$i]->odds_code;
        }
        $id = $req->id;
        if (intval($id) < 1) {
            return -1;
        }
        if (!$req->isMethod('post')) {
            $data = \App\Models\SoccerOdds::where('id', $id)->first();
            if (!$data) {
                return -2;
            }
            //$res = \App\Model\Matchcode::where('odds_code', $data->odds_code)->where('game_type','zq')->first();
            $res = \App\Models\Matchcode::where('odds_code', $data->odds_code)->first();
            if (!empty($res)) {
                $data->odds_name = $res->odds_name;
            }
//            $res = \App\Model\Matchcode::where('odds_code', $data->odds_code)->first();
//            if(!empty($res)){
//                $data->odds_code = $res->odds_name;
//            }
//            $res1 = \App\Model\Matchcode::where('odds_code', $data->p_code)->first();
//            if(!empty($res)){
//                $data->p_code = $res1->odds_name;
//            }


            $expire_time = $data->expire_time; //2019-04-15 21:10:00
            $str1 = str_replace(" ", "T", $expire_time);
            $data->expire_time = $str1;

//            $odds_code = trim($data->odds_code);
//            $p_code = trim($data->p_code);
//            if (isset($lange[$odds_code])) {
//                $data->odds_code_cn=$lange[$odds_code];
//            }
//            if (isset($lange[$p_code])) {
//                $data->p_code_cn=$lange[$p_code];
//            }
//            if (isset($lange[$odds_code])) {
//                $data->odds_code=$lange[$odds_code];
//            }
//            if (isset($lange[$p_code])) {
//                $data->p_code=$lange[$p_code];
//            }
            $data = $data->toArray();

            $data['pcode'] = $pcodedata;

            return view('sports.soccer_odds_form', $data);
        } else {
            $model = new \App\Models\SoccerOdds();
            $data = new \App\Models\SoccerOddsRecord();
            $model->id = $req->input('id');
            $model = $model::find($model->id);
            $model->status = $req->input('status');
            $model->odds = $req->input('odds');
            $model->condition = $req->input('condition');
            $model->max = $req->input('max');
            $model->min = $req->input('min');
            $model->ctime = date('Y-m-d H:i:s', time());
            $model->utime = date('Y-m-d H:i:s', time());
            $model->expire_time = $req->input('expire_time');
            $model->odds_only = md5($model->match_id . $model->odds_code . $model->ctime);

            $result = \App\Models\SoccerOdds::where('id', $model->id)->first();
            $data->match_id = $result->match_id;
            $data->status = $model->status;
            $data->p_id = $result->p_id;
            $record = \App\Models\SoccerOddsRecord::where('match_id', $data->match_id)->where('odds_code', $result->odds_code)->where('p_id', $result->p_id)->orderby('utime', 'desc')->first();
            if (!empty($record)) {
                $sort = $record->sort;
                $data->sort = $sort + 1;
            } else {
                $data->sort = 0;
            }
            $data->odds = $model->odds;
            $data->condition = $model->condition;
            $data->max = $model->max;
            $data->min = $model->min;
            $data->ctime = $model->ctime;
            $data->utime = $model->utime;
            $data->source = $result->source;
            $data->lg_id = $result->lg_id;
            $data->odds_only = $result->odds_only;

            $model->save();
            $data->save();
            return responseToJson(1);
        }

    }

    /**
     *删除赔率
     */
    public function oddsdelete(Req $req)
    {
        $id = $req->input('id');
        if (empty($id)) {
            return responseToJson(-2001);
        }
        $ids = explode(',', $id);
        if (!is_array($ids) && intval($ids) < 0) {
            return responseToJson(-2002);
        }
        if (is_array($ids) && count($ids) > 0) {
            foreach ($ids as $k => $v) {
                if (intval($v) < 1) {
                    unset($ids[$k]);
                }
            }
        }

        $rows = \App\Models\SoccerOdds::whereIn('id', $ids)->delete();
        if (!$rows) {
            return responseToJson(-2003);
        }
        return responseToJson(1, trans('menu.delete_success'));

    }





}