<?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 SportsbkController extends Controller {

	public function outcome(Req $req) {
		$request['home_team'] = isset($req->home_team) ? trim($req->home_team) : null;
		$request['status'] = isset($req->status) ? trim($req->status) : '-1';
		$request['source'] = isset($req->source) ? $req->source : null;
		$request['sureblurs'] = isset($req->sureblurs) ? $req->sureblurs : 'on';
		$dt = \App\Lib\DataTable\DataTable::init();
		$dt->setDataSource('/admin/Sportsbk/info');
		$dt->setLang('sportsbk');
		$dt->addColsFields('id', array('templet' => '#userdetail', 'sort' => true, 'width' => 80));
		$dt->addColsFields('name_chinese', array('templet' => '#userdetail', 'sort' => true, 'width' => 80));
		$dt->addColsFields('home_guest_team', array('templet' => '#userdetail', 'sort' => false, 'width' => 120));
		$dt->addColsFields('u_home_guest_score', array('templet' => '#userdetail', 'sort' => false, 'width' => 130));
		$dt->addColsFields('match_score', array('templet' => '#userdetail', 'sort' => true, 'width' => 80));
		$dt->addColsFields('match_winer', array('templet' => '#userdetail', 'sort' => true, 'width' => 80));
		$dt->addColsFields('match_time', array('templet' => '#userdetail', 'sort' => true, 'width' => 100));
		$dt->addColsFields('match_process', array('templet' => '#userdetail', 'sort' => false, 'width' => 150));
		$dt->addColsFields('status', array('templet' => '#userdetail', 'sort' => false, 'width' => 150));
		if (checkRriv('/admin/Sportsbk/edit')) {
			$arr[] = 'edit';
		}
		
		$dt->setToolBar($arr, array('width' => 200));
		$dt->enableCheckBox();
		return view('admin/sportsbk/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') : '';
		$sureblurs = Request::has('sureblurs') ? Request::get('sureblurs') : 'off';
		$status = Request::has('status') ? Request::get('status') : '';
		$source = Request::has('source') ? Request::get('source') : 'hg3535';
		$where = array();
		$orwhere = array();
		if (!empty($home_team)) {
			if (empty($sureblurs) || $sureblurs == 'off') {
				$where[] = array('st_lq_result.home_team', 'like', '%' . $home_team . '%');
				$orwhere[] = array('st_lq_result.guest_team', 'like', '%' . $home_team . '%');
			} else {
				$where[] = array('st_lq_result.home_team', '=', $home_team);
				$orwhere[] = array('st_lq_result.guest_team', '=', $home_team);
			}
		}
		if ($status != -1) {
			$where[] = array('st_lq_result.status', '=', $status);
		}
		if (!empty($source)) {
			$where[] = array('st_lq_result.source', '=', $source);
		}
		$newapp = new \App\Models\Stlqresult();
		$data = $newapp->resultbklist($list, $page, $where, $orwhere);
		return \App\Lib\DataTable\DataTable::init()->toJson($data['data'], $data['total']);
	}

	function addoutcome(Req $req) {
		if (!$req->isMethod('post')) {
            $lange = trans('menu');
			$newapp = new \App\Models\SoccerLeague();
			$league_data = $newapp->allleague();//联赛id
			return view('admin.sportsbk/addoutcome',['data'=>$league_data]);
		}else{
			$model = new \App\Models\Stlqresult();
			$model->lg_id = trim($req->input('lg_id'));//联赛id
			$model->home_team = trim($req->input('home_team'));
			$model->guest_team = trim($req->input('guest_team'));
			$model->home_rate = trim($req->input('home_rate'));
			$model->guest_rate = trim($req->input('guest_rate'));
			$model->home_score = trim($req->input('home_score'));
			$model->guest_score = trim($req->input('guest_score'));
			$model->all_goal = trim($req->input('all_goal'));
			$model->match_score = trim($req->input('match_score'));
			$model->u_home_score = trim($req->input('u_home_score'));
			$model->u_guest_score = trim($req->input('u_guest_score'));
			$model->update_time = date('Y-m-d h:i:s', time());//更新时间
			$model->match_time = "11:22";//trim($req->input('match_time'));
			$model->tag = trim($req->input('tag'));
			$model->status = trim($req->input('status'));
			$model->match_process = trim($req->input('match_process'));
			$model->match_id = trim($req->input('match_id'));//赛事id

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

		}
	}

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

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

			return view('admin.sportsbk/edit', $data);
		} else {
			$model = \App\Models\Stlqresult::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 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]);
				}
			}
		}
		// echo '敬请期待';die;
		$rows = \App\Models\Stlqresult::whereIn('id', $ids)->delete();
		if (!$rows) {
			return responseToJson(-2003); 
		}
		return responseToJson(1); 
	}


}