sports_admin/app/Http/Controllers/Admin/SportswqController.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 SportswqController extends Controller {
	public $code = "wq";

	//网球结果列表
	public 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['name_chinese'] = isset($req->name_chinese) ? $req->name_chinese : null;
		$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

        $dt = \App\Lib\DataTable\DataTable::init();
        $dt->setDataSource('/admin/Sportswq/outcomeinfo');
        $dt->setLang('sportswq');
        $dt->addColsFields('newtime', array('templet' => '#newtime', 'sort' => false, 'width' => 200));
        $dt->addColsFields('start_time', array('templet' => '#home_team', 'sort' => false, 'width' => 155));
        $dt->addColsFields('home_player_name', array('templet' => '#home_team', 'sort' => false, 'width' => 130));
        $dt->addColsFields('guest_player_name', array('templet' => '#guest_team', 'sort' => false, 'width' => 130));
        $dt->addColsFields('dsnum', array('templet' => '#dsnum', 'sort' => false, 'width' => 80));
        $dt->addColsFields('csnum', array('templet' => '#home_rate', 'sort' => false, 'width' => 80));
        $dt->addColsFields('match_score', array('templet' => '#matchscore', 'sort' => false, 'width' => 130));
        $dt->addColsFields('statusmatch', array('templet' => '#statusmatch', 'sort' => false, 'width' => 80));
        $dt->addColsFields('operation', array('templet' => '#operation', 'sort' => false, 'width' => 300));
        return view('admin.Sportswq/outcome', $dt->render($request));
	}

	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' : '';
        $name_chinese = Request::has('name_chinese') ? Request::get('name_chinese') : '';

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

	//作废
	function revoke(Req $req){
		$match_id = $req->match_id;//赛事id
		$model = \App\Models\Stwqresult::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,'wq');//修改单式状态

        //单式撤单返现
        $newapp = new \App\Models\MoneyBuyMatch();
		$all = $newapp->allsimplexorder($match_id,'wq');
        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', 'wq', $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 Settlement(Req $req){
	// 	$allhalf = $req->allhalf?$req->allhalf:'';
	// 	if(intval($allhalf)){
	// 		//赛事id
	// 		$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 ($i=0; $i < count($ids); $i++) { 
	// 			$model = \App\Models\Stwqresult::where('id', $ids[$i])->select("match_id","status")->first();
	// 			//查询赛事下所有订单
	// 			$ssid = $model['match_id'];//赛事id
	// 			if($model['status']==2){
	// 				$type = 1;;//是否再结算1,首次结算2,再次结算
	// 			}else{
	// 				$type = 2;//
	// 			}

	// 			$newapp = new \App\Models\MoneyBuyMatch();
	// 			$simplex_ids = array_column($newapp->allsimplexorder($ssid,'wq'),'order_id');
	// 			$str_ids = array_column($newapp->allstrorder($ssid),'order_id');

	// 			$data = \App\Models\Comendnotice::where(['match_id'=>$ssid,'game_code'=>'wq'])->first();
	// 			if($data){
	// 				$tapp = new \App\Lib\Settlement\SettlementWinFail();
	// 	            \App\Models\Comendnotice::where(['match_id'=>$ssid,'game_code'=>'wq'])->update(['status'=>0]);
	// 				$ret = $tapp->doRun($data->toArray()['id']);
	// 				$ret2 =$data->toArray()['id'];
	// 	            if ($ret2['status']==1){
	// 	                \App\Models\Comendnotice::where(['match_id'=>$ssid,'game_code'=>'wq'])->update(['status'=>4]);
	// 	            }
	// 	        }
				
	// 			$SettlementOrder = new SettlementOrder();
	// 		    $SettlementOrder->reSettlement($str_ids, 2,$type,'wq',$ssid,$allhalf);//串式
	// 		    $data = $SettlementOrder->reSettlement($simplex_ids, 1,$type,'wq',$ssid,$allhalf);//单式注单
	// 		}
	// 		return responseToJson(1);
	// 	}else{
	// 		//查询赛事下所有订单
	// 		$ssid = $req->match_id;//赛事id
	// 		$type = $req->type;//是否再结算1,首次结算2,再次结算
				
	// 		$newapp = new \App\Models\MoneyBuyMatch();
	// 		$simplex_ids = array_column($newapp->allsimplexorder($ssid,'wq'),'order_id');
	// 		$str_ids = array_column($newapp->allstrorder($ssid),'order_id');

	// 		$data = \App\Models\Comendnotice::where(['match_id'=>$ssid,'game_code'=>'wq'])->first();
	// 		if($data){
	// 			$tapp = new \App\Lib\Settlement\SettlementWinFail();
	// 	        \App\Models\Comendnotice::where(['match_id'=>$ssid,'game_code'=>'wq'])->update(['status'=>0]);
	// 			$ret = $tapp->doRun($data->toArray()['id']);
	// 			$ret2 =$data->toArray()['id'];
	// 	        if ($ret2['status']==1){
	// 	            \App\Models\Comendnotice::where(['match_id'=>$ssid,'game_code'=>'wq'])->update(['status'=>4]);
	// 	        }
	// 	    }
				
	// 		if($ret['status']==1){
	// 			$SettlementOrder = new SettlementOrder();
	// 		    $SettlementOrder->reSettlement($str_ids, 2,$type,'wq',$ssid);//串式
	// 		    $data = $SettlementOrder->reSettlement($simplex_ids, 1,$type,'wq',$ssid);//单式注单
	// 		    return responseToJson($data);
	// 		}else{
	// 		    return responseToJson($ret);
	// 		}
	// 	}
	// }

	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,'wq'),'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($simplex_ids){
					$simplex = array(
			            'token'=>$token,  
			            'order_ids'=>'', //订单id字符串，用半角都好分隔
			            'bettype'=>1, //结算类型  1单式  2串式 
			            'settype'=>2, //结算次数  1首次  2非首冷饮
			            'game_code'=>'wq', //赛事类型  zq lq wq bq
			            'match_id'=>$match_id, // 赛事ID
			            'change_status'=>1   //是否改状态
			        );
			        $url=$jsurl.'/Settelement';
			        $simplex_res = $napp->post_curls($url,$simplex);//返回json
					$huawei_res = json_decode($simplex_res,true);
				}

				//串式结算
				if($str_ids){
					$tandem = array(
			            'token'=>$token,  
			            'order_ids'=>'', //订单id字符串，用半角都好分隔
			            'bettype'=>2, //结算类型  1单式  2串式 
			            'settype'=>2, //结算次数  1首次  2非首冷饮
			            'game_code'=>'wq', //赛事类型  zq lq wq bq
			            'match_id'=>$match_id,  // 赛事ID
			            'change_status'=>1  //是否改状态
			        );
			        $url=$jsurl.'/Settelement';
			        $tandem_res = $napp->post_curls($url,$tandem);//返回json
					$tandem_res = json_decode($tandem_res,true);
				}
				if($huawei_res['status']==1 || $tandem_res['status']==1){
					return json_encode(['status'=>1,'msg'=>'结算成功']);
				}else{
					return json_encode(['status'=>3,'msg'=>'结算有误,请联系管理员!!!']);//结算错误
				}
			}else{
				return json_encode(['status'=>2,'msg'=>'结算有错,请联系管理员!!!']);;//输赢错误
			}
		}else{
			$res = \App\Models\Stwqresult::where ('match_id', $match_id)->update(['status' =>3]);
			$res = \App\Models\SportsTennis::where ('match_id', $match_id)->update(['status' =>3]);
            return json_encode(['status'=>4,'msg'=>'该赛事没有任何订单,将会结束该赛事!!!']);
		}
	}

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

		$array =array(
			'wqresult' => $newapp,
		);
		return $array;
	}

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

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

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

	//修改添加赛事比分
	function updatascore(Req $req){
		$only = $req->only;//节数唯一标识
		$match_id = $req->match_id;//节数唯一标识
		$home_player_score = intval($req->home_player_score);//主队比分
		$guest_player_score = intval($req->guest_player_score);//客队比分

		$model = \App\Models\Stwqresult::where('match_id', $match_id)->first();
		$model->update_time = date('Y-m-d H:i:s');
			
		if($home_player_score){
			$model->home_player_score = $home_player_score;
		}
		if($guest_player_score){
			$model->guest_player_score = $guest_player_score;
		}
		$model->save();

		$addnew = new \App\Models\Comendnotice();
		$addnew->addcomendnotice($match_id,'wq');

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

		return responseToJson(1); 
	}



}