sports_admin/app/Http/Controllers/Admin/ZqChampionsLeagueController.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 ZqChampionsLeagueController
 * @package App\Http\Controllers\Admin
 * 足球冠军联赛 管理
 */
class ZqChampionsLeagueController 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')->where(['identity'=>''])->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/ZqChampionsLeague/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));
        $dt->addColsFields('isresults', array('templet' => '#isresults', 'sort' => false, 'width' => 160));
        // if (checkRriv('/admin/ZqChampionsLeague/edit')) {
        //     $arr[] = 'edit';
        // }
        // $dt->setToolBar($arr, array('width' => 140));
        $dt->enableCheckBox();
        return view('sports/soccer_league', $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') : '';
        $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_zq_league.identity', '=', '');
        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 ($name_chinese != -1) {
//            $where[] = array('st_zq_league.name_chinese', '=', $name_chinese);
//        }
        if(!empty($area_id)){
            $where[] = array('st_zq_league.area_id', '=', $area_id);
        }
        if(!empty($country_id)){
            $where[] = array('st_zq_league.country_id', '=', $country_id);
        }
        if($status != 0){
            $where[] = array('st_zq_league.status', '=', $status);
        }

        $newapp = new \App\Models\SoccerLeague();
        $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\SoccerLeague::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\SoccerOdds::where('lg_id',$id)->where('type',1)->where('odds_code','!=','')->select('odds_code')->distinct()->get()->toArray();//赔率表

        $allteam = \App\Models\SoccerLeague::where('lg_id',$id)->select('name_chinese')->get()->toArray();
        
        $data = $data->toArray();

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

            $data['allteam'] = $allteam;
            $data['odds_code'] = $odds_code;

            return view('sports.soccer_champions_league_form', $data);
        } else {
            // var_dump(count($allteam));die;
            for($i=0;$i<count($odds_code);$i++){
                // $tname = 'teammz'.$i;
                for ($ic=0; $ic < count($allteam); $ic++) { 
                    $team = 'teammz'.$i .$ic;
                    $isteam = $req->$team .',';

                    $res = \App\Models\ZqLeagueResult::where('lg_id',$id)->where('game_name',$odds_code[$i]['odds_code'])->first()->toArray();
                    $addresult = [
                        'lg_id' => $id,
                        'game_name' => $name,
                        'result' => $isteam,
                        'ctime' => date('Y-m-d H:i:s',time()),
                        'utime' => date('Y-m-d H:i:s',time()),
                        'status' => 1,
                    ];

                    $updateresult = [
                        'result' => $isteam,
                        'utime' => date('Y-m-d H:i:s',time()),
                    ];

                    if(!empty($res)){
                        \App\Models\ZqLeagueResult::where('game_name',$res['game_name'])->update($updateresult);
                    }else{
                        \App\Models\ZqLeagueResult::insert($addresult);
                    }

                    // \App\Models\ZqLeagueResult::where('game_name',$res['game_name'])->update($update_info);
                }
                // var_dump($isteam);
                // $ss = count($teammz);
                // for ($ie=0; $ie < count($teammz); $ie++) { 
                //     $jieguo[] = $teammz[$ie];
                // }
                // $teammz[] = $req->$tname;
                // $res = \App\Models\ZqLeagueResult::where('lg_id',$id)->where('game_name',$odds_code[$i]['odds_code'])->first()->toArray();
                
                // $name = $odds_code[$i]->odds_code;
                // $update = [
                //     'lg_id' => $id,
                //     'game_name' => $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\ZqLeagueResult::where('game_name',$res['game_name'])->update($update_info);
                // }else{
                //     \App\Models\ZqLeagueResult::insert($update);
                // }
            }
            return responseToJson(1);
        }
    }




}