assign('breadcrumb1','用户管理'); $this->assign('breadcrumb2','微伴客户'); } /** * 列表页 * * */ public function index(Model $Model,Custom $Custom,WeiBanTags $WeiBanTags ){ // 接受参数 $id = request('id',''); $status = request('status'); $name = request('name'); $phone = request('phone'); $remark = request('remark'); $startTime = request('start_time',''); // 查询条件 $map = []; // 编码ID if( $id ) $map[] = ['weiban_external.id','=',$id]; if( $name ) $map[] = ['weiban_external.name','=',$name]; if( $phone ) $map[] = ['weiban_follow.phone_number','=',$phone]; if( $remark ) $map[] = ['weiban_follow.remark','=',$remark]; if( $startTime ) $map[] = ['weiban_external.insert_time','>=',Carbon::createFromFormat('Y-m-d',$startTime)->startOfDay()->getTimestamp()]; if( $startTime ) $map[] = ['weiban_external.insert_time','<=',Carbon::createFromFormat('Y-m-d',$startTime)->endOfDay()->getTimestamp()]; if( !is_null($status) ) $map[] = ['weiban_external.status','=',$status]; // 查询数据 $list = $Model->query()->join('weiban_follow','weiban_follow.weiban_extid','=','weiban_external.id')->where($map)->orderByDesc('insert_time')->paginate(config('page_num',10),['weiban_external.*','weiban_follow.staff_id','weiban_follow.staff_name','weiban_follow.remark','weiban_follow.phone_number'])->appends(request()->all()); // 循环处理数据 foreach ($list as $key => $value) { // id转编号 $value['custom_code'] = $value['custom_uid'] ? $Custom->idToCode($value['custom_uid']) : ''; // 获取标签 $value['tags_list'] = $WeiBanTags->getListByWeibanExtid($value['id']); // 重组 $list[$key] = $value; } // 分配数据 $this->assign('empty', '~~暂无数据'); $this->assign('list',$list); // 加载模板 return $this->fetch(); } }