sports_admin/app/Http/Controllers/Admin/RechargeDetailController.php

<?php

namespace App\Http\Controllers\Admin;
use App\Http\Controllers\Controller;
use Illuminate\Http\Request as Req;
use Request;

class RechargeDetailController extends Controller {

	function index() {
		# code...
	}

	function recharge(Req $req) {

        $request=array();
        $request['betnum_small']=isset($req->betnum_small)?trim($req->betnum_small):null;
        $request['betnum_big']=isset($req->betnum_big)?trim($req->betnum_big):null;
        $request['betmoney_small']=isset($req->betmoney_small)?trim($req->betmoney_small):null;
        $request['betmoney_big']=isset($req->betmoney_big)?trim($req->betmoney_big):null;
        $request['name']=isset($req->name)?trim($req->name):null;
        $request['status']=isset($req->status)?trim($req->status):null;
        $request['account_name']=isset($req->account_name)?trim($req->account_name):null;
        $request['star_time']=isset($req->star_time)?trim($req->star_time):null;
        $request['end_time']=isset($req->end_time)?trim($req->end_time):null;



		$dt = \App\Lib\DataTable\DataTable::init();
		$dt->setDataSource('/admin/RechargeDetail/recharges');
		$dt->setLang('state');
		$dt->addColsFields('account_name', array('sort' => false, 'toolbar' => '#userrecharge', 'width' => 120));
		$dt->addColsFields('name', array('sort' => false));
		$dt->addColsFields('betnum', array('width' => 110));
		$dt->addColsFields('betmoney');
		$dt->addColsFields('recharge_type', array('sort' => false));
		$dt->addColsFields('star_time');
		$dt->addColsFields('end_time');
		$dt->addColsFields('status', array('sort' => false, 'toolbar' => '#rechargeStatus'));
		$dt->setToolBar(array('view'), array('toolbar' => '#query_status','align' => 'left'));
		$dt->setPriKey('account_identity');
		// $dt->setPriKey('statuss');
		return view('admin.rechargedetail/recharge', $dt->render($request));
	}

	//报表查看
	function View(Req $req) {
		$id = $req->identity;
		$status = $req->status;
		if (empty($id)) {
			abort(404);
		}
		$dt = \App\Lib\DataTable\DataTable::init();
		$url = '/admin/RechargeDetail/withDetail?id=' . $id . '&status=' . $status;
		// $url = '/admin/RechargeDetail/withDetail?id=' . $id;
		$dt->setDataSource($url);
		$dt->setLang('rechargeDetail');
		$dt->addColsFields('account_name', array('sort' => false,'width' => '140'));
		$dt->addColsFields('id', array('width' => 110));
		$dt->addColsFields('order_id', array('width' => 360));
        $dt->addColsFields('old_money', array('width' => 150));//充值前
		$dt->addColsFields('money', array('width' => 150));
        $dt->addColsFields('money_cash', array('width' => 150)); //充值后
		$dt->addColsFields('recharge_type', array('sort' => false, 'width' => 140));
		$dt->addColsFields('apply_time', array('width' => 180));
		$dt->addColsFields('complete_time', array('width' => 180));
		$dt->setPriKey('identity');
		return view('admin.rechargedetail/view', $dt->render());
	}

	/**
	 * 充值明细
	 * 'with description'
	 * @return 'type' 'description'
	 */
	function withDetail(Req $req) {
		$id = $req->id;
		$tem = 'status';
		$status = $req->$tem;
		if (empty($id)) {
			abort(404);
		}
		$db = new \App\Models\Money_recharge();
		$data = $db::where('account_identity', $id)->where('status', $status)->orderBy('apply_time','desc')->get();
		if (!$data) {
			abort(404);
		}
		$data = $data->toArray();
		foreach ($data as $k => $v) {
			$data[$k]['old_money'] = sprintf("%.2f", $v['money_cash'] - $v['money']);
            $data[$k]['money_cash'] = sprintf("%.2f", $v['money_cash']);
		}
		return \App\Lib\DataTable\DataTable::init()->toJson($data, count($data));
	}

	/**
	 *充值账单
	 * [state description]
	 * @return [type] [description]
	 */
	function recharges() {
		$page = Request::has('page') ? Request::get('page') : 1;
		$list = Request::has('limit') ? Request::get('limit') : 10;
		$field = Request::has('field') ? Request::get('field') : 'star_time';
		$order = Request::has('order') ? Request::get('order') : 'desc';

		$account_name = Request::has('account_name') ? Request::get('account_name') : '';
		$name = Request::has('name') ? Request::get('name') : '';
		$status = Request::has('status') ? Request::get('status') : '';
		$betnum_small = Request::has('betnum_small') ? Request::get('betnum_small') : '';
		$betnum_big = Request::has('betnum_big') ? Request::get('betnum_big') : '';
		$betmoney_small = Request::has('betmoney_small') ? Request::get('betmoney_small') : '';
		$betmoney_big = Request::has('betmoney_big') ? Request::get('betmoney_big') : '';
		$sureblur = Request::has('sureblur') ? Request::get('sureblur') : '';
		$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();
		$having = array();

		if (!empty($account_name)) {
			if (empty($sureblur) || $sureblur == '模糊') {
				$where[] = array('account_name', 'like', '%' . $account_name . '%');
			} else {
				$where[] = array('account_name', '=', $account_name);
			}
		}
		if (!empty($name)) {
			$where[] = array('name', 'like', '%' . $name . '%');
		}
		/*if (!empty($status)) {
			if ($status == 4) {
				$where[] = array('status', '=', '0');
			} else {
				$where[] = array('status', '=', $status);
			}
		}*/
		if (!empty($star_time)) {
			$where[] = array('apply_time', '>=', $star_time);
		}
		if (!empty($end_time)) {
			$where[] = array('apply_time', '<=', $end_time);
		}
		if (!empty($betnum_small)) {
			$having[] = 'count("order_id")>=' . $betnum_small;
		}
		if (!empty($betnum_big)) {
			$having[] = 'count("order_id")<=' . $betnum_big;
		}
		if (!empty($betmoney_small)) {
			$having[] = 'sum("money")>=' . $betmoney_small;
		}
		if (!empty($betmoney_big)) {
			$having[] = 'sum("money")<=' . $betmoney_big;
		}

		$db = new \App\Models\Money_recharge;
		$data = $db->getTotal($where, 1, $list, 6, 'desc', 1, $having,$status);
		return \App\Lib\DataTable\DataTable::init()->toJson($data['data'], $data['total']);
	}
}