assign('breadcrumb1','操作记录'); $this->assign('breadcrumb2','操作列表'); } /** * 首页列表 * * */ public function index(Model $Model,AdminUser $AdminUser){ // 接收参数 $table = request('table',''); $primaryId = request('primary_id',0); $notesType = request('notes_type',0); $AdminUid = request('admin_uid',''); // 查询条件 $map = []; // 组合条件 if( $table ) $map[] = ['table_name','=',$table]; if( $primaryId ) $map[] = ['primary_id','=',$primaryId]; if( $notesType ) $map[] = ['notes_type','=',$notesType]; if( $AdminUid ) $map[] = ['admin_uid','=',$AdminUid]; // 查询数据 $list = $Model->query()->where($map)->orderByDesc('id')->paginate(config('page_num',10))->appends(request()->all()); // 循环处理 foreach ($list as $key => $value) { // 获取类型 $value['notes_type'] = $value['notes_type'] == 1 ? '添加' : ($value['notes_type'] == 2 ? '修改' : '删除'); // 获取字段名称 $value['column_name'] = $Model->getTableColumn($value['table_name'],$value['column_name']); // 获取表名称 $value['table_name'] = $Model->getTableName($value['table_name']); // 获取操作人 $value['admin_name'] = $AdminUser->getOne($value['admin_uid'],'username'); // 重组 $list[$key] = $value; } // 获取结果 $adminUsers = $AdminUser->getList(); // 分配数据 $this->assign('list', $list); $this->assign('adminUsers', $adminUsers); $this->assign('empty', '~~暂无数据'); // 加载模板 return $this->fetch(); } }