assign('breadcrumb1','余额管理'); $this->assign('breadcrumb2','余额记录'); } /** * 列表页 * * */ public function index(Model $Model,Custom $Custom){ // 接受参数 $code = request('custom_code',''); $phone = request('phone',''); $username = request('username',''); $status = request('status'); $startTime = request('start_time',''); $endTime = request('end_time',''); // 编码转ID $uid = $Custom->codeToId($code); // 查询条件 $map = []; // 编码ID if( $uid ) $map[] = ['custom.uid','=',$uid]; if( $phone ) $map[] = ['custom.phone','=',$phone]; if( $username ) $map[] = ['custom.username','=',$username]; if( $startTime ) $map[] = ['amount_record.insert_time','>=',Carbon::createFromFormat('Y-m-d',$startTime)->startOfDay()->getTimestamp()]; if( $endTime ) $map[] = ['amount_record.insert_time','<=',Carbon::createFromFormat('Y-m-d',$endTime)->endOfDay()->getTimestamp()]; if( !is_null($status) ) $map[] = ['amount_record.status','=',$status]; // 查询数据 $list = $Model->query() ->leftJoin('custom','custom.uid','=','amount_record.custom_uid') ->where($map) ->select(['amount_record.*','custom.username']) ->orderByDesc('amount_record.id') ->paginate(config('page_num',10)) ->appends(request()->all()); // 循环处理数据 foreach ($list as $key => $value) { // id转编号 $value['custom_code'] = $Custom->idToCode($value['custom_uid']); $value['buy_type'] = $Model->getBuyType($value['buy_type'],'name'); // 重组 $list[$key] = $value; } // 分配数据 $this->assign('empty', '~~暂无数据'); $this->assign('list',$list); // 加载模板 return $this->fetch(); } /** * 导出表格 * * */ public function down_excel(Model $Model,Custom $Custom){ } }