site['money']; //提现的钱 $money = (new Tx)->where('sassid', $request->site['sassid'])->where('type', 2)->where('is_type', 0)->sum('money'); $post['tx_money'] = empty($money) ? 0 : $money; //已提现的钱 $money = (new Tx)->where('sassid', $request->site['sassid'])->where('type', 2)->where('is_type', 1)->sum('money'); $post['tx_ok_money'] =empty($money) ? 0 : $money; $post['total'] = $post['money'] + $post['tx_money'] + $post['tx_ok_money']; return app('json')->success($post); } /** * * @param Request $request */ public function order(Request $request) { $pageCount = 10; $post = UtilService::getMore([ ['page',1], ['order_id',''], ['start_time',''], ['end_time',''], ['code',''], ['type',''] ],$request); $where = []; $where['s.sassid'] = $request->site['sassid']; if(!empty($post['order_id'])) { $where['s.order_id'] = ['%'.$post['order_id'].'%','whereLike']; } if(!empty($post['start_time'])) { $where['s.time'] = [[strtotime($post['start_time']),strtotime($post['end_time'])],'whereBetween']; } if(!empty($post['code'])) { $where['s.code'] = $post['code']; } if(!empty($post['type'])) { $where['s.type'] = $post['type']; } [$total,$data] =(new SiteDetail)->getList($post['page'],$where,$pageCount,'*','s.id desc'); $post = []; $data = UtilService::getParam([ ['code','code'], ['time','time','date("Y-m-d H:i:s",$1)'], ['title','title'], ['content','content'], ['money','money'], ['v','v'], ['type','type'], ['order_id','order_id'], ['all_price','all_price'] ],$data); $post['pageSize'] = $pageCount; $post['pageCount'] = $total; $post['data'] = (array)$data; return app('json')->success($post); } /** * 提现列表 * @param Request $request */ public function txList(Request $request) { $pageSize = 10; $post = UtilService::getMore( [ ['page',1] ],$request ); $where['sassid'] =$request->site['sassid']; $where['type'] = 2; $tx = new Tx(); list($pageCount,$data) = $tx->getList($post['page'],$where,$pageSize,"*","time desc"); $result = UtilService::getParam([ "id", "money", "bank", 'name', 'code', "is_type", ["time","time","date('Y-m-d H:i:s',$1)"] ],$data); return app('json')->success([ 'list' => $result, 'pageCount' => $pageCount, 'pageSize' => $pageSize, 'page' => $post['page'] ]); } }