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

<?php
/**
 * Created by PhpStorm.
 * User: Jun.peng
 * Date: 2019/6/22
 * Time: 10:35
 */

namespace App\Http\Controllers\Admin;

use App\Http\Controllers\Controller;
use Illuminate\Http\Request as Req;
use Request;

/**
 * Class WqChampionsLeagueController
 * @package App\Http\Controllers\Admin
 * 网球 冠军联赛 管理
 */
class WqChampionsLeagueController extends Controller
{
    public function index(Req $req) {
        //$request['name_chinese'] = isset($req->name_chinese) ? trim($req->name_chinese) : '-1';
        $request['name_chinese'] = isset($req->name_chinese) ? trim($req->name_chinese) : '';
        $request['area_id'] = isset($req->area_id) ? trim($req->area_id) : '';
        $request['country_id'] = isset($req->country_id) ? trim($req->country_id) : '';
        $request['id'] = isset($req->id) ? trim($req->id) : '';
        $request['status'] = isset($req->status) ? trim($req->status) : '0';
        $request['sureblurs'] = isset($req->sureblurs) ? $req->sureblurs : 'on';
        $data = \App\Models\SoccerLeague::select('id','lg_id','name_chinese')->get();
        $area = \App\Models\StAreaCountry::where('pid',0)->get();
        $country = \App\Models\StAreaCountry::where('pid','!=',0)->get();
        $request['league'] = $data;
        $request['area'] = $area;
        $request['country'] = $country;
        $dt = \App\Lib\DataTable\DataTable::init();
        $dt->setDataSource('/admin/WqChampionsLeague/info');
        $dt->setLang('sportsbase');
        $dt->addColsFields('id', array('templet' => '#userdetail', 'sort' => true, 'width' => 120));
        $dt->addColsFields('name_chinese', array('templet' => '#userdetail', 'sort' => false, 'width' => 200));
        $dt->addColsFields('area', array('sort' => false, 'width' => 180));
        $dt->addColsFields('country', array('sort' => true, 'width' => 180));
        $dt->addColsFields('league_status', array('templet' => '#userdetail', 'sort' => false, 'width' => 90));
        $dt->addColsFields('utime', array('templet' => '#userdetail', 'sort' => false, 'width' => 160));
        if (checkRriv('/admin/WqChampionsLeague/edit')) {
            $arr[] = 'edit';
        }
        $dt->setToolBar($arr, array('width' => 140));
        $dt->enableCheckBox();
        return view('sports/tennis_league', $dt->render($request));
    }

    function info(Req $req) {
        $page = Request::has('page') ? Request::get('page') : '';
        $list = Request::has('limit') ? Request::get('limit') : 10;
        $id = Request::has('id') ? Request::get('id') : '';
        $name_chinese = Request::has('name_chinese') ? Request::get('name_chinese') : '';
        $area_id = Request::has('area_id') ? Request::get('area_id') : '';
        $country_id = Request::has('country_id') ? Request::get('country_id') : '';
        $status = Request::has('status') ? Request::get('status') : '';
        $sureblur = Request::has('sureblurs') ? Request::get('sureblurs') : 'off';

        $where = array();
        //$where[] = array('st_wq_league.identity', '=', '');
        if (!empty($name_chinese)) {
            if (empty($sureblur) || $sureblur == 'off') {
                $where[] = array('st_wq_league.name_chinese', 'like', '%' . $name_chinese . '%');
            }else{
                $where[] = array('st_wq_league.name_chinese', '=', $name_chinese);
            }
        }
//        if ($name_chinese != -1) {
//            $where[] = array('st_wq_league.name_chinese', '=', $name_chinese);
//        }
        if(!empty($area_id)){
            $where[] = array('st_wq_league.area_id', '=', $area_id);
        }
        if(!empty($country_id)){
            $where[] = array('st_wq_league.country_id', '=', $country_id);
        }
        if($status != 0){
            $where[] = array('st_wq_league.status', '=', $status);
        }

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

    /**
     *获取地区
     */
    function getarea() {
        $area = \App\Models\StAreaCountry::where('pid',0)->get();
        return $area;
    }

    /**
     *修改冠军联赛信息
     */
    function edit(Req $req) {
        $id = $req->id;
        if (intval($id) < 1) {
            return -1;
        }

        $areas = $this->getarea();
        if (!$areas) {
            return -2;
        }
        $data = \App\Models\TennisLeague::where('id',$id)->first();
        $areaname = \App\Models\StAreaCountry::where('id',$data->area_id)->first();
        $countryname = \App\Models\StAreaCountry::where('id',$data->country_id)->first();
        if(!empty($areaname)){
            $data->area = $areaname->name;
        }
        if(!empty($countryname)){
            $data->country = $countryname->name;
        }

        $odds_code = \App\Models\TennisOdds::where('lg_id',$id)->where('type',1)->where('odds_code','!=','')->select('odds_code')->distinct()->get();

        $data = $data->toArray();

        if (!$req->isMethod('post')) {

            $data['area'] = $areas;
            $data['odds_code'] = $odds_code;

            return view('sports.tennis_champions_league_form', $data);
        } else {
            for($i=0;$i<count($odds_code);$i++){
                $res = \App\Models\WqLeagueResult::where('lg_id',$id)->where('game_name',$odds_code[$i]->odds_code)->first();
                //$model = new \App\Models\ZqLeagueResult();
                $name = $odds_code[$i]->odds_code;
                $update = [
                    'lg_id' => $id,
                    'F' => $name,
                    'result' => $req->input($name),
                    'ctime' => date('Y-m-d H:i:s',time()),
                    'utime' => date('Y-m-d H:i:s',time()),
                    'status' => 1,
                ];
                $update_info = [
                    'result' => $req->input($name),
                    'utime' => date('Y-m-d H:i:s',time()),
                ];
                if(!empty($res)){
                    \App\Models\WqLeagueResult::where('game_name',$res->game_name)->update($update_info);
                }else{
                    \App\Models\WqLeagueResult::insert($update);
                }
            }
            return responseToJson(1);
        }
    }
}