<?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['source'] = isset($req->source) ? $req->source : null;
		$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' => '#home_team', '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' => '#home_rate', 'sort' => false, 'width' => 80));
        $dt->addColsFields('csnum', array('templet' => '#home_rate', 'sort' => false, 'width' => 80));
        $dt->addColsFields('match_score', array('templet' => '#home_rate', 'sort' => false, 'width' => 80));
        $dt->addColsFields('statusmatch', array('templet' => '#home_rate', 'sort' => false, 'width' => 80));
        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') : '';
		$source = Request::has('source') ? Request::get('source') : 'hg3535';
        $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_team', 'like', '%' . $home_team . '%');
				$orwhere[] = array('st_wq_result.guest_team', 'like', '%' . $home_team . '%');
			} else {
				$where[] = array('st_wq_result.home_team', '=', $home_team);
				$orwhere[] = array('st_wq_result.guest_team', '=', $home_team);
			}
		}
		if ($status != -1) {
			$where[] = array('st_wq_result.status', '=', $status);
		}
		if (!empty($source)) {
			$where[] = array('st_wq_result.source', '=', $source);
		}
		if (!empty($name_chinese)) {
			$where[] = 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);
        }
        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);
        }
        $newapp = new \App\Models\Stwqresult();
        $data = $newapp->resultlist($list, $page, $where, $orwhere);
        
        return \App\Lib\DataTable\DataTable::init()->toJson($data['data'], $data['total']);
	}


}