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

/**
 *棒球结果结算
 */
class SportsbqController extends Controller {

	//棒球结果列表
	function outcome(Req $req) {
		$request=array();
		$request['status'] = isset($req->status) ? trim($req->status) : '-1';
		$request['sureblurs'] = isset($req->sureblurs) ? $req->sureblurs : 'on';
		$request['home_team'] = isset($req->home_team) ? trim($req->home_team) : 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');
		$dt = \App\Lib\DataTable\DataTable::init();
        $dt->setDataSource('/admin/Sportsbq/info');
        $dt->setLang('Sportsbq');
        $dt->addColsFields('newtime', array('templet' => '#newtime', 'sort' => false, 'width' => 200));
        $dt->addColsFields('totime', array('templet' => '#totime', 'sort' => false, 'width' => 200));
        $dt->addColsFields('home_team', array('templet' => '#home_team', 'sort' => false, 'width' => 80));
        $dt->addColsFields('guest_team', array('templet' => '#guest_team', 'sort' => false, 'width' => 80));
        $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' => '#match_score', 'sort' => false, 'width' => 200));
        $dt->addColsFields('statusmatch', array('templet' => '#statusmatch', 'sort' => false, 'width' => 80));
        $dt->addColsFields('operation', array('templet' => '#operation', 'sort' => false, 'width' => 300));
		return view('admin.Sportsbq/outcome', $dt->render($request));
	}

	function info(){
		$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_bq_result.home_team', 'like', '%' . $home_team . '%');
				$orwhere[] = array('st_bq_result.guest_team', 'like', '%' . $home_team . '%');
			} else {
				$where[] = array('st_bq_result.home_team', '=', $home_team);
				$orwhere[] = array('st_bq_result.guest_team', '=', $home_team);
			}
		}
        if ($status != -1) {
			$where[] = array('st_bq_result.status', '=', $status);
			$orwhere[] = array('st_bq_result.status', '=', $status);
		}
		if (!empty($star_time)) {
	            $star_time = date('Y-m-d H:i:s', strtotime($star_time));
	            $where[] = array('st_bq_result.start_time', '>', $star_time);
	            $orwhere[] = array('st_bq_result.start_time', '>', $star_time);
	        }
	    if (!empty($end_time)) {
	        $end_time = date('Y-m-d H:i:s', strtotime($end_time));
	        $where[] = array('st_bq_result.start_time', '<', $end_time);
	        $orwhere[] = array('st_bq_result.start_time', '<', $end_time);
	    }
		$newapp = new \App\Models\Stbqresult();
        $data = $newapp->getinfo($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\Stbqresult::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,'bq');//修改单式状态

        //单式撤单返现
        $newapp = new \App\Models\MoneyBuyMatch();
		$all = $newapp->allsimplexorder($match_id,'bq');
        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', 'bq', $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){
		//查询赛事下所有订单
		$ssid = $req->match_id;//赛事id
		$type = $req->type;//是否再结算1,首次结算2,再次结算
		$newapp = new \App\Models\MoneyBuyMatch();
		$simplex_ids = array_column($newapp->allsimplexorder($ssid,'bq'),'order_id');
		$str_ids = array_column($newapp->allstrorder($ssid),'order_id');

		$update = $this->addcomendnotice($ssid);
		if($update['status']==1){
			$SettlementOrder = new SettlementOrder();
	        $SettlementOrder->reSettlement($str_ids, 2,$type,'bq',$ssid);//串式
	        $data = $SettlementOrder->reSettlement($simplex_ids, 1,$type,'bq',$ssid);//单式注单
	        return responseToJson($data);
	    }else{
	    	return responseToJson($update);
	    }
	}

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

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

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

	//结果添加
	function addend(Req $req){
		$match_id = $req->matchid;
		$model = \App\Models\Stbqresult::where('match_id', $match_id)->first();
		$model->first_score = $req->firstscoreplayer?$req->firstscoreplayer:0;
		$model->last_score = $req->lastscoreplayer?$req->lastscoreplayer:0;
		$model->match_winer = $req->matchwinerplayer?$req->matchwinerplayer:0;
        $model->save();
        return responseToJson(1);
	}

	//更新赛事比分
	function updatascore(Req $req){
		$only = $req->only;
		$num = $req->num;
		$match_id = $req->match_id;
		$newapp = new \App\Models\Stbqresult();

		// $data = array();
		// $data['update_time'] = data('Y-m-d H:i:s');//更新时间
		if($only==1){
			$data['u_home_score'] = $num;
			$res = $newapp->updateInfo($data,$match_id);//联赛id
		}else if($only==2){
			$data['u_guest_score'] = $num;
			$res = $newapp->updateInfo($data,$match_id);//联赛id
		}else if($only==3){
			$data['home_score'] = $num;
			$res = $newapp->updateInfo($data,$match_id);//联赛id
		}else{
			$data['guest_score'] = $num;
			$res = $newapp->updateInfo($data,$match_id);//联赛id
		}
		$addnew = new \App\Models\Comendnotice();
		$addnew->addcomendnotice($match_id,'bq');

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

		return responseToJson(1);
	}




}