sports_admin/app/Http/Controllers/Admin/SportsfootController.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\SettlementOrder;
use App\Models;
use Request;

/**
 *足球结算
 */
class SportsfootController extends Controller {

	function Settlement(Req $req){
		$jsurl = config('sconstant.url');//结算请求域名地址
		$match_id = $req->match_id;
		$type = $req->type;
		$token = session('adminInfo.token');
		$notice = \App\Models\Comendnotice::where('match_id', $match_id)->first();
		$noticeid = $notice['id'];
		//查询赛事单式是否有订单(足球)
		$newapp = new \App\Models\MoneyBuyMatch();
		$simplex_ids = array_column($newapp->allsimplexorder($match_id,'zq'),'order_id');
		$str_ids = array_column($newapp->allstrorder($match_id),'order_id');

		if(count($simplex_ids)>0 || count($str_ids)>0){
			$requet = file_get_contents($jsurl."/WinFail?noticeid=".$noticeid."&token=".$token);
			
			if(json_decode($requet,true)['status']==1){
				$napp = new \App\Models\Stzqresult();
				//单式结算
				if(count($simplex_ids)>0 && count($str_ids)==0){
					$huawei_res = $napp->simplexs($token,$match_id,$jsurl,'zq');
					
					if($huawei_res['status']==1){
						return json_encode(['status'=>1,'msg'=>'单式结算成功,没有串式订单']);
					}else{
						return json_encode(['status'=>3,'msg'=>'单式结算有误,请联系管理员!!!('.$huawei_res['msg'].')']);//结算错误
					}
				}elseif(count($str_ids)>0 && count($simplex_ids)==0){
					//串式结算
					$tandem_res = $napp->tandems($token,$match_id,$jsurl,'zq');

					if($tandem_res['status']==1){
						return json_encode(['status'=>1,'msg'=>'串式结算成功,没有单式订单']);
					}else{
						return json_encode(['status'=>3,'msg'=>'串式结算有误,请联系管理员!!!('.$tandem_res['msg'].')']);//结算错误
					}
				}elseif(count($str_ids)>0 && count($simplex_ids)>0){
					//既有单式又有串式
					$huawei_res = $napp->simplexs($token,$match_id,$jsurl,'zq');

					//串式结算
					$tandem_res = $napp->tandems($token,$match_id,$jsurl,'zq');
					if($tandem_res['status']==1 && $huawei_res['status']==1){
						return json_encode(['status'=>1,'msg'=>'结算成功']); 
					}elseif($tandem_res['status']!=1 || $huawei_res['status']!=1){
						return json_encode(['status'=>3,'msg'=>'结算有误,请联系管理员!!!('.$tandem_res['msg'].$huawei_res['msg'].')']);
					}else{
						return json_encode(['status'=>3,'msg'=>'返回参数不对']); 
					}
				}
			}else{
				return json_encode(['status'=>2,'msg'=>'判断输赢错误,请联系管理员!!!']);;//输赢错误
			}
		}else{
			$res = \App\Models\Stzqresult::where ('match_id', $match_id)->update(['status' =>3]);
			$res = \App\Models\SportsSoccer::where ('match_id', $match_id)->update(['status' =>3]);
            return json_encode(['status'=>4,'msg'=>'该赛事没有任何订单,将会结束该赛事!!!']);
		}
	}

	//添加危险球列表
	function addwarn(Req $req){
		$match_id = $req->match_id;
		$warn = \App\Models\Stzqresult::where('match_id', $match_id)->select("warn_more")->first();
		$request['warnmore'] = json_decode($warn['warn_more'],true);
		// $sousuo = $req->sousuo;
		// if($sousuo){
		// 	for ($i=0; $i < count($request['warnmore']); $i++) { 
		// 	    if($request['warnmore'][$i]['rtype']==$sousuo){
		// 	        $array[$i]['timei'] = $request['warnmore'][$i]['timei'];
		// 	        $array[$i]['rtype'] = $request['warnmore'][$i]['rtype'];
		// 	    }
		// 	    // unset($array2D[2]);//删除
		// 	}
		// 	$request['warnmore'] = $array;
		// }
		$request['match_id'] = $match_id;

		return view('admin.sportsfoot/addwarn', $request);
	}

	//危险球查询
	function warnresult(Req $req){
		$match_id = $req->match_id;
		$wid = $req->wid;
		$warnonlys = \App\Models\Stzqresult::where('match_id', $match_id)->select("warn_more","start_time")->first();

		$warno = array(
			'warn_more' => json_decode($warnonlys['warn_more'],true),
			'starttime' => $warnonlys['start_time'],
		);

		return $warno;
	}

	//添加编辑危险球
	function addwarnonly(Req $req){
		$matchid = $req->matchid;
		$wid = $req->wid;//编辑对象值
		$timei = $req->timei?$req->timei:"1970-11-1 0:0:1";
		$rtype = $req->warntype?$req->warntype:0;
		$typenum = $req->typenum;
		$model = \App\Models\Stzqresult::where('match_id', $matchid)->select("warn_more","start_time")->first()->toArray();
		$sel = json_decode($model['warn_more'],true);
		$addru = array(
			array(
	        	'timei'=>$timei,
	        	'rtype'=>$rtype,
	        ),
        );
		$only =$model['start_time'];
		$t = strtotime($only);
		$tt = date('Y-m-d H:i:s', $t+1*3*60*60);
		
		if($only<$timei && $timei<$tt){
			if($typenum==10000){
				if($sel[0]['rtype']==0){
					//首次添加
					$res = \App\Models\Stzqresult::where ('match_id', $matchid)->update(['warn_more' => json_encode($addru)]);
				}else{
					//再次添加
					$upnum = array_merge_recursive($sel,$addru);
					$res = \App\Models\Stzqresult::where ('match_id', $matchid)->update(['warn_more' => json_encode($upnum)]);
				}
			}else{
				//编辑
				for ($i=0; $i < count($sel); $i++) { 
					$sel[$wid]['timei'] = $timei;
					$sel[$wid]['rtype'] = $rtype;
				}
				$res = \App\Models\Stzqresult::where ('match_id', $matchid)->update(['warn_more' => json_encode($sel)]);
			}
		}else{
			return json_encode(['status'=>2,'msg'=>'请设置正确时间']);
		}
		
		return responseToJson(1);
	}

	//足球结果列表
	function outcome(Req $req) {
		$request=array();
		$request['home_team'] = isset($req->home_team) ? trim($req->home_team) : null;
		$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) :trans('status.default_time.seven_day') ;
        $request['end_time'] = isset($req->end_time) ? trim($req->end_time) : trans('status.default_time.etime');
        $newapp = new \App\Models\SoccerLeague();
		$data = $newapp->allleague();
        $request['league'] = $data;//联赛id
        $request['token'] = session('adminInfo.token');//token 变量

        $dt = \App\Lib\DataTable\DataTable::init();
        $dt->setDataSource('/admin/sportsfoot/outcomeinfo');
        $dt->setLang('sportsfoot');
        $dt->addColsFields('newtime', array('templet' => '#newtime', 'sort' => false, 'width' => 200));
        $dt->addColsFields('totime', array('templet' => '#totime', 'sort' => false, 'width' => 80));
        $dt->addColsFields('home_team', array('templet' => '#userdetail', 'sort' => false, 'width' => 80));
		$dt->addColsFields('guest_team', array('templet' => '#userdetail', 'sort' => false, 'width' => 70));
		$dt->addColsFields('dsnum', array('templet' => '#dsnum', 'sort' => false, 'width' => 70));
		$dt->addColsFields('csnum', array('templet' => '#csnum', 'sort' => false, 'width' => 110));
		$dt->addColsFields('sxalfcourt', array('templet' => '#sxalfcourt', 'sort' => false, 'width' => 300));
        $dt->addColsFields('statusmatch', array('templet' => '#statusmatch', 'sort' => false, 'width' => 150,'align' => 'left'));
		$dt->addColsFields('operation', array('templet' => '#status', 'sort' => false, 'width' => 300));
        // $arr[] = 'view';
		// if (checkRriv('/admin/sportsfoot/edit')) {
		// 	$arr[] = 'edit';
		// }
		// $dt->setToolBar($arr, array('width' => 200));
        $dt->enableCheckBox();

		
		return view('admin.sportsfoot/outcome', $dt->render($request));
	}

	//结果添加
	function addend(Req $req){
		$match_id = $req->matchid;
		$model = \App\Models\Stzqresult::where('match_id', $match_id)->first();

		$penaltycard = array(
        	'home'=>intval($req->homeallcard)?intval($req->homeallcard):0,
        	'guest'=>intval($req->guestallcard)?intval($req->guestallcard):0,
        	'home_half'=>intval($req->homehalfcard)?intval($req->homehalfcard):0,
        	'guest_half'=>intval($req->guesthalfcard)?intval($req->guesthalfcard):0,
        );
        $cornerball = array(
        	'home'=>intval($req->homeallcorner)?intval($req->homeallcorner):0,
        	'guest'=>intval($req->guestallcorner)?intval($req->guestallcorner):0,
        	'home_half'=>intval($req->homehalfcorner)?intval($req->homehalfcorner):0,
        	'guest_half'=>intval($req->guesthalfcorner)?intval($req->guesthalfcorner):0,
        );
        $firstone = array(
        	'teamscore'=>$req->firstscore ? $req->firstscore:0,
        	'scoretime'=>intval($req->onescoretime)?intval($req->onescoretime):0,
        	'scoretype'=>$req->firststye ? $req->firststye:0,
        );

		$model->last_score = $req->lastscore?$req->lastscore:'';
		$model->match_winer = $req->matchwiner?$req->matchwiner:'';
		$model->penalty_card = json_encode($penaltycard,JSON_UNESCAPED_UNICODE);
		$model->corner_ball = json_encode($cornerball,JSON_UNESCAPED_UNICODE);
		$model->first_score = json_encode($firstone,JSON_UNESCAPED_UNICODE ); 

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

	//查询赛事结果
	function Matchresult(Req $req){
		$match_id = $req->match_id;
		$newapp = \App\Models\Stzqresult::where('match_id', $match_id)->first();

		$array =array(
			'corner_ball' => json_decode($newapp['corner_ball'],true),
			'penalty_card' => json_decode($newapp['penalty_card'],true),
			'first_score' => json_decode($newapp['first_score'],true),
			'newapp' => $newapp,
		);
		return $array;
	}

	function onlyresult(Req $req){
		$match_id = $req->matchid;
		$newapp = \App\Models\Stzqresult::where('match_id', $match_id)->first();
		return $newapp;
	}

	//作废
	function revokeft(Req $req){
		$iszf = $req->iszf?$req->iszf:'';//赛事id
		if(intval($iszf)){
			$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]);
					}
				}
			}
			for ($ii=0; $ii < count($ids); $ii++) { 
				$model = \App\Models\Stzqresult::where('id', $ids[$ii])->first();
				$model->status = 4;
				$model->save();
				$ssid = $model['match_id'];//赛事id

				$smodel = \App\Models\SportsSoccer::where('match_id', $ssid)->first();
				if($smodel){
					$smodel->status = 4;
					$smodel->save();
				}

				$upapp = new \App\Models\SportsNoteList();
		        $data = $upapp->updatesimplex($ssid,'zq');//修改单式状态

		        //单式撤单返现
		        $newapp = new \App\Models\MoneyBuyMatch();
				$all = $newapp->allsimplexorder($ssid,'zq');
		        for ($i=0; $i < count($all); $i++) { 
			        $appgx = new \App\Lib\Settlement\SettlementOrder();
			        $appgx->insertData($all[$i]['order_id'], $all[$i]['money'], $all[$i]['account_identity'], '1', 'zq', $all[$i]['info_identity'], $all[$i]['money'],$all[$i]['match_id']);
		        }

		        //串式撤单只改状态
		        $str_ids = array_column($newapp->allstrorder($ssid),'order_id');
		        $csapp = new \App\Models\MoneyBuyStr();
		        $csapp->updatestatus($str_ids);//var_dump($ss);die;
		        //修改money_buy_match 投注结果result=2为平
		        $newapp->updatast($ssid);
			}
			return responseToJson(1);
		}else{
			$match_id = $req->match_id;//赛事id
			$model = \App\Models\Stzqresult::where('match_id', $match_id)->first();
			$model->status = 4;
			$model->save();

			$smodel = \App\Models\SportsSoccer::where('match_id', $match_id)->first();
			if($smodel){
				$smodel->status = 4;
				$smodel->save();
			}

			$upapp = new \App\Models\SportsNoteList();
	        $data = $upapp->updatesimplex($match_id,'zq');//修改单式状态

	        //单式撤单返现
	        $newapp = new \App\Models\MoneyBuyMatch();
			$all = $newapp->allsimplexorder($match_id,'zq');
	        for ($i=0; $i < count($all); $i++) { 
		        $appgx = new \App\Lib\Settlement\SettlementOrder();
		        $appgx->insertData($all[$i]['order_id'], $all[$i]['money'], $all[$i]['account_identity'], '1', 'zq', $all[$i]['info_identity'], $all[$i]['money'],$all[$i]['match_id']);
	        }

	        //串式撤单只改状态
	        $str_ids = array_column($newapp->allstrorder($match_id),'order_id');
	        $csapp = new \App\Models\MoneyBuyStr();
	        $csapp->updatestatus($str_ids);//var_dump($ss);die;
	        //修改money_buy_match 投注结果result=2为平
	        $newapp->updatast($match_id);
	        
			return responseToJson(1);
		}
		
	}

	//赛事结果修改
	function edit(Req $req) {
		$id = $req->id;
		if (intval($id) < 1) {
			return -1;
		}
		if (!$req->isMethod('post')) {

			$data = \App\Models\Stzqresult::where('id', $id)->first();
			if (!$data) {
				return -2;
			}
			$data = $data->toArray();

			return view('admin.sportsfoot/edit', $data);
		} else {
			$model = \App\Models\Stzqresult::where('id', $id)->first();
			$model->home_team = $req->input('home_team');
			$model->guest_team = $req->input('guest_team');
			$model->home_rate = $req->input('home_rate');
			$model->guest_rate = $req->input('guest_rate');
			$model->status = $req->input('status');
			//$model->update_time = time();
			$model->save();
			return responseToJson(1);
		}
	}

	function outcomeinfo() {
		$page = Request::has('page') ? Request::get('page') : '';
		$list = Request::has('limit') ? Request::get('limit') : 10;
		$home_team = Request::has('home_team') ? Request::get('home_team') : '';
		$sureblur = Request::has('sureblurs') ? Request::get('sureblurs') : 'off';
		$status = Request::has('status') ? Request::get('status') : '';
        $star_time = Request::get('star_time') ? Request::get('star_time').' 00:00:00' : '';
        $end_time = Request::get('end_time') ? Request::get('end_time').' 23:59:59' : '';

		$where = array();
		$orwhere = array();
		if (!empty($home_team)) {
			if (empty($sureblur) || $sureblur == 'off') {
				$where[] = array('st_zq_result.home_team', 'like', '%' . $home_team . '%');
				$orwhere[] = array('st_zq_result.guest_team', 'like', '%' . $home_team . '%');
			} else {
				if(is_numeric($home_team)){
					$where[] = array('st_zq_result.match_id', '=', $home_team);
				}else{
					$where[] = array('st_zq_result.home_team', '=', $home_team);
					$orwhere[] = array('st_zq_result.guest_team', '=', $home_team);
				}
			}
		}
		if ($status != -1) {
			$where[] = array('st_zq_result.status', '=', $status);
			$orwhere[] = array('st_zq_result.status', '=', $status);
		}
		if(!is_numeric($home_team)){
			if (!empty($star_time)) {
	            $star_time = date('Y-m-d H:i:s', strtotime($star_time));
	            $where[] = array('st_zq_result.start_time', '>', $star_time);
	            $orwhere[] = array('st_zq_result.start_time', '>', $star_time);
	        }
	        if (!empty($end_time)) {
	            $end_time = date('Y-m-d H:i:s', strtotime($end_time));
	            $where[] = array('st_zq_result.start_time', '<', $end_time);
	            $orwhere[] = array('st_zq_result.start_time', '<', $end_time);
	        }
	    }
        $newapp = new \App\Models\Stzqresult();
        $data = $newapp->resultlist($list, $page, $where, $orwhere);
        
        return \App\Lib\DataTable\DataTable::init()->toJson($data['data'], $data['total']);
    }

    function saislist(Req $req){
    	$lgid = $req->lgid;//赛事id
		$newstzqcompetition = new \App\Models\Stzqcompetition();
		$league_data = $newstzqcompetition->allcompetition($lgid);//赛事id

		return $league_data;
    }
    
	//赛事结果添加  guest_score 客队进球  all_goal总进球数
    function addoutcome(Req $req) {
		if (!$req->isMethod('post')) {
            $lange = trans('menu');
			$newapp = new \App\Models\SoccerLeague();
			$league_data = $newapp->allleague();//联赛id

            return view('admin.sportsfoot/addoutcome',['data'=>$league_data]);
        } else {
        	$match_id = trim($req->input('match_id'));//赛事id
        	//添加足球比赛结果表
        	$alldata = $req->input();
        	unset($alldata['_token']);
        	$all_goal = intval($alldata['home_score'])+intval($alldata['guest_score']);//总进球数
        	$penaltycard = array(
        		'home'=>intval($alldata['homeallcard'])?intval($alldata['homeallcard']):0,
        		'guest'=>intval($alldata['guestallcard'])?intval($alldata['guestallcard']):0,
        		'home_half'=>intval($alldata['homehalfcard'])?intval($alldata['homehalfcard']):0,
        		'guest_half'=>intval($alldata['guesthalfcard'])?intval($alldata['guesthalfcard']):0,
        	);
        	$cornerball = array(
        		'home'=>intval($alldata['homeallcorner'])?intval($alldata['homeallcorner']):0,
        		'guest'=>intval($alldata['guestallcorner'])?intval($alldata['guestallcorner']):0,
        		'home_half'=>intval($alldata['homehalfcorner'])?intval($alldata['homehalfcorner']):0,
        		'guest_half'=>intval($alldata['guesthalfcorner'])?intval($alldata['guesthalfcorner']):0,
        	);
        	
        	$ret = \App\Models\Stzqresult::updateOrCreate(['match_id'=>$match_id],array_merge($alldata,['match_time'=>'00:01','update_time'=>date('Y-m-d H:i:s'),'all_goal'=>$all_goal,'penalty_card'=>json_encode($penaltycard),'corner_ball'=>json_encode($cornerball)]));
        	//添加足球比赛结果记录表
        	\App\Models\Stzqresultrecord::updateOrCreate(['match_id'=>$match_id,'update_time'=>date('Y-m-d H:i:s')],array_merge($alldata,['match_time'=>'00:01','update_time'=>date('Y-m-d H:i:s')]));
        }
        return responseToJson(1); 
    }

    //删除赛事结果
	function deleteoutcome(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\Stzqresult::whereIn('id', $ids)->delete();
		if (!$rows) {
			return responseToJson(-2003); 
		}
		return responseToJson(1); 
	}

	//更新赛事比分
	function updatenum(Req $req){
		$type = $req->type;
		$id = $req->id;
		$num = $req->num;
		$match_id = $req->match_id;
		$newapp = new \App\Models\Stzqresult();
		
		if($type==1){
			$data['u_home_score'] = $num;
			$res = $newapp->updateInfo($data,$id);//联赛id
		}else if($type==2){
			$data['u_guest_score'] = $num;
			$res = $newapp->updateInfo($data,$id);//联赛id
		}else if($type==3){
			$data['home_score'] = $num;
			$res = $newapp->updateInfo($data,$id);//联赛id
		}else{
			$data['guest_score'] = $num;
			$res = $newapp->updateInfo($data,$id);//联赛id
		}
		$newapp->totalgoal($match_id);
		$update = $this->addcomendnotice($match_id);

		$twoapp = new \App\Models\SportsSoccer();
		$twoapp->updatestatus('match_id',$match_id,['status'=>2]);//修改赛事状态
		$newapp->updatestatus('match_id',$match_id,['status'=>2]);//修改结果状态

		return responseToJson(1);
	}
 		
	//添加赛事结束纪录
	function addcomendnotice($match_id){
		$data = \App\Models\Comendnotice::where(['match_id'=>$match_id,'game_code'=>'zq'])->first();
		if(!$data){
			$model = new \App\Models\Comendnotice();
			$model->status = 0;//联赛id
			$model->game_code = 'zq';
			$model->match_id = $match_id;//赛事id
			$model->ctime = date('Y-m-d H:i:s');
			$model->save();
		}
		return responseToJson(1);
	}
	
}