/** * 分类列表 * @author jry <*****@*****.**> */ public function index($tab = 1) { //搜索 $keyword = (string) I('keyword'); $condition = array('like', '%' . $keyword . '%'); $map['id|title'] = array($condition, $condition, '_multi' => true); //获取所有分类 $map['status'] = array('egt', '0'); //禁用和正常状态 if (I('get.pid')) { $map['pid'] = array('eq', I('get.pid')); //父分类ID } $map['group'] = array('eq', $tab); $data_list = D('Category')->field('id,pid,group,doc_type,title,url,icon,ctime,sort,status')->where($map)->order('sort asc,id asc')->select(); foreach ($data_list as &$item) { if ($item['doc_type'] >= 3) { $item['title'] = '<a href="' . U('Document/index', array('cid' => $item['id'])) . '">' . $item['title'] . '</a>'; } } //转换成树状列表 $tree = new \Common\Util\Tree(); $data_list = $tree->toFormatTree($data_list); $attr['title'] = '编辑'; $attr['href'] = 'Admin/Category/edit/tab/' . $tab . '/id/'; //使用Builder快速建立列表页面。 $builder = new \Common\Builder\ListBuilder(); $builder->title('分类列表')->AddNewButton('Admin/Category/add/tab/' . $tab)->addResumeButton()->addForbidButton()->setSearch('请输入ID/分类名称', U('Admin/Category/index/tab/' . $tab))->SetTablist(C('CATEGORY_GROUP_LIST'))->SetCurrentTab($tab)->addField('id', 'ID', 'text')->addField('title_show', '分类', 'text')->addField('url', '链接', 'text')->addField('icon', '图标', 'icon')->addField('sort', '排序', 'text')->addField('status', '状态', 'status')->addField('right_button', '操作', 'btn')->dataList($data_list)->addRightButton('self', $attr)->addRightButton('forbid')->addRightButton('delete')->display(); }
/** * 数据字典 * @author jry <*****@*****.**> */ public function index($tab = 'ct_addon') { $database = C('DB_NAME'); //数据库名 //取得所有表 $tables = M()->query('show tables'); foreach ($tables as $key => $val) { $tables_result[$val['tables_in_' . $database]]['name'] = $val['tables_in_' . $database]; } //获取表信息 foreach ($tables_result as $key => $val) { //获取所有表的备注 $sql = 'SELECT * FROM '; $sql .= 'INFORMATION_SCHEMA.TABLES '; $sql .= 'WHERE '; $sql .= "table_name = '{$val['name']}' AND table_schema = '{$database}'"; $table_result = M()->query($sql); $tables_result[$key]['title'] = $table_result[0]['table_comment']; $tabs[$key] = $table_result[0]['table_comment'] . '(' . $key . ')'; //获取所有表的字段信息 $sql = 'SELECT * FROM '; $sql .= 'INFORMATION_SCHEMA.COLUMNS '; $sql .= 'WHERE '; $sql .= "table_name = '{$val['name']}' AND table_schema = '{$database}'"; $field_result = M()->query($sql); $tables_result[$key]['fields'] = $field_result; } //使用Builder快速建立列表页面。 $builder = new \Common\Builder\ListBuilder(); $builder->title('数据字典')->SetTablist($tabs)->SetCurrentTab($tab)->addField('column_name', '字段名', 'text')->addField('column_type', '数据类型', 'text')->addField('column_default', '默认值', 'text')->addField('is_nullable', '允许非空', 'text')->addField('extra', '自动递增', 'text')->addField('column_comment', '备注', 'text')->dataList($tables_result[$tab]['fields'])->display(); }
/** * 导航列表 * @author jry <*****@*****.**> */ public function index($group = 'main') { //搜索 $keyword = I('keyword', '', 'string'); $condition = array('like', '%' . $keyword . '%'); $map['id|title'] = array($condition, $condition, '_multi' => true); // 获取所有导航 $map['status'] = array('egt', '0'); $map['group'] = $group; $data_list = D('Admin/Nav')->where($map)->order('sort asc, id asc')->select(); // 给文章列表类型加上链接 foreach ($data_list as &$val) { if ($val['type'] == 'post') { $val['title'] = '<a href="' . U('Admin/Post/index', array('cid' => $val['id'])) . '">' . $val['title'] . '</a>'; } } // 转换成树状列表 $tree = new Tree(); $data_list = $tree->toFormatTree($data_list); // 设置Tab导航数据列表 $nav_group_list = C('NAV_GROUP_LIST'); // 获取分类分组 foreach ($nav_group_list as $key => $val) { $tab_list[$key]['title'] = $val; $tab_list[$key]['href'] = U('index', array('group' => $key)); } // 使用Builder快速建立列表页面。 $builder = new \Common\Builder\ListBuilder(); $builder->setMetaTitle('导航列表')->addTopButton('addnew', array('href' => U('add', array('group' => $group))))->addTopButton('resume')->addTopButton('forbid')->addTopButton('delete')->setSearch('请输入ID/导航名称', U('index', array('group' => $group)))->setTabNav($tab_list, $group)->addTableColumn('id', 'ID')->addTableColumn('icon', '图标', 'icon')->addTableColumn('title_show', '标题')->addTableColumn('sort', '排序')->addTableColumn('status', '状态', 'status')->addTableColumn('right_button', '操作', 'btn')->setTableDataList($data_list)->addRightButton('edit', array('href' => U('edit', array('group' => $group, 'id' => '__data_id__'))))->addRightButton('forbid')->addRightButton('delete')->display(); }
/** * 配置列表 * @param $tab 配置分组ID * @author jry <*****@*****.**> */ public function index($group = 1) { // 搜索 $keyword = I('keyword', '', 'string'); $condition = array('like', '%' . $keyword . '%'); $map['id|name|title'] = array($condition, $condition, $condition, '_multi' => true); // 获取所有配置 $map['status'] = array('egt', '0'); // 禁用和正常状态 $map['group'] = array('eq', $group); $p = !empty($_GET["p"]) ? $_GET['p'] : 1; $config_object = D('Config'); $data_list = $config_object->page($p, C('ADMIN_PAGE_ROWS'))->where($map)->order('sort asc,id asc')->select(); $page = new Page($config_object->where($map)->count(), C('ADMIN_PAGE_ROWS')); // 设置Tab导航数据列表 $config_group_list = C('CONFIG_GROUP_LIST'); // 获取配置分组 foreach ($config_group_list as $key => $val) { $tab_list[$key]['title'] = $val; $tab_list[$key]['href'] = U('index', array('group' => $key)); } // 使用Builder快速建立列表页面。 $builder = new \Common\Builder\ListBuilder(); $builder->setMetaTitle('配置列表')->addTopButton('addnew')->addTopButton('resume')->addTopButton('forbid')->addTopButton('delete')->setSearch('请输入ID/配置名称/配置标题', U('index', array('group' => $group)))->setTabNav($tab_list, $group)->addTableColumn('id', 'ID')->addTableColumn('name', '名称')->addTableColumn('title', '标题')->addTableColumn('sort', '排序')->addTableColumn('status', '状态', 'status')->addTableColumn('right_button', '操作', 'btn')->setTableDataList($data_list)->setTableDataPage($page->show())->addRightButton('edit')->addRightButton('forbid')->addRightButton('delete')->display(); }
/** * 默认方法 * @author jry <*****@*****.**> */ public function index() { $module_object = D('Module'); $data_list = $module_object->getAll(); // 使用Builder快速建立列表页面。 $builder = new \Common\Builder\ListBuilder(); $builder->setMetaTitle('模块列表')->addTopButton('resume')->addTopButton('forbid')->setSearch('请输入ID/标题', U('index'))->addTableColumn('name', '名称')->addTableColumn('title', '标题')->addTableColumn('description', '描述')->addTableColumn('developer', '开发者')->addTableColumn('version', '版本')->addTableColumn('create_time', '创建时间', 'time')->addTableColumn('status_icon', '状态', 'text')->addTableColumn('right_button', '操作', 'btn')->setTableDataList($data_list)->display(); }
/** * 默认方法 * @author jry <*****@*****.**> */ public function index() { $data_list = D('SystemModule')->page(!empty($_GET["p"]) ? $_GET["p"] : 1, C('ADMIN_PAGE_ROWS'))->getAll(); $page = new \Common\Util\Page(D('SystemModule')->count(), C('ADMIN_PAGE_ROWS')); //使用Builder快速建立列表页面。 $builder = new \Common\Builder\ListBuilder(); $builder->setMetaTitle('模块列表')->addTopButton('resume')->addTopButton('forbid')->setSearch('请输入ID/标题', U('index'))->addTableColumn('name', '名称')->addTableColumn('title', '标题')->addTableColumn('description', '描述')->addTableColumn('developer', '开发者')->addTableColumn('version', '版本')->addTableColumn('ctime', '创建时间', 'date')->addTableColumn('status', '状态', 'text')->addTableColumn('right_button', '操作', 'btn')->setTableDataList($data_list)->setTableDataPage($page->show())->display(); }
/** * 默认方法 * @author jry <*****@*****.**> */ public function index() { $data_list = D('StoreModule')->page(!empty($_GET["p"]) ? $_GET["p"] : 1, C('ADMIN_PAGE_ROWS'))->getAllModule(); $page = new \Common\Util\Page(D('StoreModule')->count(), C('ADMIN_PAGE_ROWS')); //使用Builder快速建立列表页面。 $builder = new \Common\Builder\ListBuilder(); $builder->title('模块列表')->AddNewButton()->addResumeButton()->addForbidButton()->setSearch('请输入ID/标题', U('index'))->addField('name', '名称', 'text')->addField('title', '标题', 'text')->addField('description', '描述', 'text')->addField('developer', '开发者', 'text')->addField('version', '版本', 'text')->addField('ctime', '创建时间', 'date')->addField('status', '状态', 'text')->addField('right_button', '操作', 'btn')->dataList($data_list)->setPage($page->show())->display(); }
/** * 默认方法 * @author jry <*****@*****.**> */ public function index() { $theme_object = D('Theme'); $p = !empty($_GET["p"]) ? $_GET['p'] : 1; $data_list = $theme_object->getAll(); // 使用Builder快速建立列表页面。 $builder = new \Common\Builder\ListBuilder(); $builder->setMetaTitle('主题列表')->addTableColumn('name', '名称')->addTableColumn('title', '标题')->addTableColumn('description', '描述')->addTableColumn('developer', '开发者')->addTableColumn('version', '版本')->addTableColumn('create_time', '创建时间', 'time')->addTableColumn('status', '状态')->addTableColumn('right_button', '操作', 'btn')->setTableDataList($data_list)->display(); }
/** * 默认方法 * @author jry <*****@*****.**> */ public function index() { $theme_object = D('Theme'); $p = !empty($_GET["p"]) ? $_GET['p'] : 1; $data_list = $theme_object->getAll(); $attr['title'] = '取消多主题支持'; $attr['class'] = 'btn btn-primary ajax-get'; $attr['href'] = U('Admin/Theme/cencel'); // 使用Builder快速建立列表页面。 $builder = new \Common\Builder\ListBuilder(); $builder->setMetaTitle('主题列表')->addTopButton('self', $attr)->addTableColumn('name', '名称')->addTableColumn('title', '标题')->addTableColumn('description', '描述')->addTableColumn('developer', '开发者')->addTableColumn('version', '版本')->addTableColumn('create_time', '创建时间', 'time')->addTableColumn('status', '状态')->addTableColumn('right_button', '操作', 'btn')->setTableDataList($data_list)->display(); }
/** * 上传列表 * @author jry <*****@*****.**> */ public function index() { //搜索 $keyword = (string) I('keyword'); $condition = array('like', '%' . $keyword . '%'); $map['id|path'] = array($condition, $condition, '_multi' => true); //获取所有上传 $map['status'] = array('egt', '0'); //禁用和正常状态 $data_list = D('Upload')->page(!empty($_GET["p"]) ? $_GET["p"] : 1, C('ADMIN_PAGE_ROWS'))->where($map)->order('sort desc,id desc')->select(); $page = new \Common\Util\Page(D('Upload')->where($map)->count(), C('ADMIN_PAGE_ROWS')); //使用Builder快速建立列表页面。 $builder = new \Common\Builder\ListBuilder(); $builder->title('上传列表')->addResumeButton()->addForbidButton()->addDeleteButton()->setSearch('请输入ID/上传关键字', U('index'))->addField('id', 'ID', 'text')->addField('path', '路径', 'text')->addField('size', '大小', 'text')->addField('ctime', '创建时间', 'time')->addField('sort', '排序', 'text')->addField('status', '状态', 'status')->addField('right_button', '操作', 'btn')->dataList($data_list)->addRightButton('forbid')->addRightButton('delete')->setPage($page->show())->display(); }
/** * 用户列表 * @author jry <*****@*****.**> */ public function index() { //搜索 $keyword = I('keyword', '', 'string'); $condition = array('like', '%' . $keyword . '%'); $map['id|username|email|mobile'] = array($condition, $condition, $condition, $condition, '_multi' => true); //获取所有用户 $map['status'] = array('egt', '0'); //禁用和正常状态 $data_list = D('User')->page(!empty($_GET["p"]) ? $_GET["p"] : 1, C('ADMIN_PAGE_ROWS'))->where($map)->order('sort desc,id desc')->select(); $page = new \Common\Util\Page(D('User')->where($map)->count(), C('ADMIN_PAGE_ROWS')); //使用Builder快速建立列表页面。 $builder = new \Common\Builder\ListBuilder(); $builder->setMetaTitle('用户列表')->addTopButton('addnew')->addTopButton('resume')->addTopButton('forbid')->addTopButton('delete')->setSearch('请输入ID/用户名/邮箱/手机号', U('index'))->addTableColumn('id', 'UID')->addTableColumn('usertype', '类型')->addTableColumn('username', '用户名')->addTableColumn('email', '邮箱')->addTableColumn('mobile', '手机号')->addTableColumn('vip', 'VIP')->addTableColumn('score', '积分')->addTableColumn('money', '余额')->addTableColumn('last_login_time', '最后登录时间时间', 'time')->addTableColumn('reg_type', '注册方式')->addTableColumn('sort', '排序', 'text')->addTableColumn('status', '状态', 'status')->addTableColumn('right_button', '操作', 'btn')->setTableDataList($data_list)->setTableDataPage($page->show())->addRightButton('edit')->addRightButton('forbid')->addRightButton('delete')->display(); }
/** * 配置列表 * @param $tab 配置分组ID */ public function index($tab = 1) { //搜索 $keyword = (string) I('keyword'); $condition = array('like', '%' . $keyword . '%'); $map['id|name|title'] = array($condition, $condition, $condition, '_multi' => true); //获取所有配置 $map['status'] = array('egt', 0); //禁用和正常状态 $map['group'] = array('eq', $tab); $data = $this->os_lists('system_config', $map, 'sort asc,id asc'); //使用Builder快速建立列表页面。 $builder = new \Common\Builder\ListBuilder(); $builder->title('配置列表')->addNewButton()->addResumeButton()->addForbidButton()->addDeleteButton()->setSearch('请输入ID/配置名称/配置标题', U('index', array('tab' => $tab)))->setTablist(C('CONFIG_GROUP_LIST'))->setCurrentTab($tab)->addField('id', 'ID', 'text')->addField('name', '名称', 'text')->addField('title', '标题', 'text')->addField('sort', '排序', 'text')->addField('status', '状态', 'status')->addField('right_button', '操作', 'btn')->dataList($data['list'])->addRightButton('edit')->addRightButton('forbid')->addRightButton('delete')->setPage($data['page']->show())->display(); }
/** * 用户类型列表 * @author jry <*****@*****.**> */ public function index() { // 获取所有用户类型 $map['status'] = array('egt', '0'); // 禁用和正常状态 $type_object = D('Type'); $data_list = $type_object->where($map)->order('id asc')->select(); // 字段管理按钮 $attr['title'] = '字段管理'; $attr['class'] = 'label label-success'; $attr['href'] = U('User/Attribute/index', array('user_type' => __data_id__)); // 使用Builder快速建立列表页面。 $builder = new \Common\Builder\ListBuilder(); $builder->setMetaTitle('类型列表')->addTopButton('addnew')->addTopButton('resume', array('model' => 'user_type'))->addTopButton('forbid', array('model' => 'user_type'))->addTopButton('delete', array('model' => 'user_type'))->setSearch('请输入ID/用户名', U('index'))->addTableColumn('id', 'UID')->addTableColumn('name', '名称')->addTableColumn('title', '标题')->addTableColumn('create_time', '注册时间', 'time')->addTableColumn('status', '状态', 'status')->addTableColumn('right_button', '操作', 'btn')->setTableDataList($data_list)->addRightButton('self', $attr)->addRightButton('edit')->addRightButton('forbid')->addRightButton('delete')->display(); }
/** * 评论列表 * @author jry <*****@*****.**> */ public function index() { //搜索 $keyword = (string) I('keyword'); $condition = array('like', '%' . $keyword . '%'); $map['id|content'] = array($condition, $condition, '_multi' => true); //获取所有评论 $map['status'] = array('egt', '0'); //禁用和正常状态 $data_list = D('UserComment')->page(!empty($_GET["p"]) ? $_GET["p"] : 1, C('ADMIN_PAGE_ROWS'))->where($map)->order('sort desc,id desc')->select(); $page = new \Common\Util\Page(D('UserComment')->where($map)->count(), C('ADMIN_PAGE_ROWS')); //使用Builder快速建立列表页面。 $builder = new \Common\Builder\ListBuilder(); $builder->setMetaTitle('评论列表')->addTopButton('addnew')->addTopButton('resume')->addTopButton('forbid')->addTopButton('delete')->setSearch('请输入ID/评论关键字', U('index'))->addTableColumn('id', 'ID')->addTableColumn('content', '评论')->addTableColumn('ctime', '创建时间', 'time')->addTableColumn('sort', '排序')->addTableColumn('status', '状态', 'status')->addTableColumn('right_button', '操作', 'btn')->setTableDataList($data_list)->setTableDataPage($page->show())->addRightButton('edit')->addRightButton('forbid')->addRightButton('delete')->display(); }
/** * 配置列表 * @param $tab 配置分组ID * @author jry <*****@*****.**> */ public function index($tab = 1) { //搜索 $keyword = (string) I('keyword'); $condition = array('like', '%' . $keyword . '%'); $map['id|name|title'] = array($condition, $condition, $condition, '_multi' => true); //获取所有配置 $map['status'] = array('egt', '0'); //禁用和正常状态 $map['group'] = array('eq', $tab); $data_list = D('SystemConfig')->page(!empty($_GET["p"]) ? $_GET["p"] : 1, C('ADMIN_PAGE_ROWS'))->where($map)->order('sort asc,id asc')->select(); $page = new \Common\Util\Page(D('SystemConfig')->where($map)->count(), C('ADMIN_PAGE_ROWS')); //使用Builder快速建立列表页面。 $builder = new \Common\Builder\ListBuilder(); $builder->title('配置列表')->AddNewButton()->addResumeButton()->addForbidButton()->addDeleteButton()->setSearch('请输入ID/配置名称/配置标题', U('index', array('tab' => $tab)))->SetTablist(C('CONFIG_GROUP_LIST'))->SetCurrentTab($tab)->addField('id', 'ID', 'text')->addField('name', '名称', 'text')->addField('title', '标题', 'text')->addField('sort', '排序', 'text')->addField('status', '状态', 'status')->addField('right_button', '操作', 'btn')->dataList($data_list)->addRightButton('edit')->addRightButton('forbid')->addRightButton('delete')->setPage($page->show())->display(); }
/** * 默认方法 * @author jry <*****@*****.**> */ public function index() { // 搜索 $keyword = I('keyword', '', 'string'); $condition = array('like', '%' . $keyword . '%'); $map['id|title'] = array($condition, $condition, '_multi' => true); // 获取所有链接 $p = !empty($_GET["p"]) ? $_GET["p"] : 1; $map['status'] = array('egt', '0'); // 禁用和正常状态 $friendly_link_object = D('FriendlyLink'); $data_list = $friendly_link_object->page($p, C('ADMIN_PAGE_ROWS'))->where($map)->order('sort desc,id desc')->select(); $page = new Page($friendly_link_object->where($map)->count(), C('ADMIN_PAGE_ROWS')); // 使用Builder快速建立列表页面。 $builder = new \Common\Builder\ListBuilder(); $builder->setMetaTitle('友情链接列表')->addTopButton('addnew')->addTopButton('resume', array('model' => $this->model))->addTopButton('forbid', array('model' => $this->model))->setSearch('请输入ID/链接标题', U('index'))->addTableColumn('id', 'ID')->addTableColumn('title', '标题')->addTableColumn('type', '类型', 'callback', array(D('FriendlyLink'), 'link_type'))->addTableColumn('logo', 'Logo', 'picture')->addTableColumn('create_time', '创建时间', 'time')->addTableColumn('sort', '排序')->addTableColumn('status', '状态', 'status')->addTableColumn('right_button', '操作', 'btn')->setTableDataList($data_list)->setTableDataPage($page->show())->addRightButton('edit')->addRightButton('forbid', array('model' => $this->model))->addRightButton('delete', array('model' => $this->model))->display(); }
/** * 用户列表 * @author jry <*****@*****.**> */ public function index() { // 搜索 $keyword = I('keyword', '', 'string'); $condition = array('like', '%' . $keyword . '%'); $map['id|username|nickname|email|mobile'] = array($condition, $condition, $condition, $condition, $condition, '_multi' => true); // 获取所有用户 $map['status'] = array('egt', '0'); // 禁用和正常状态 $p = !empty($_GET["p"]) ? $_GET['p'] : 1; $user_object = D('User'); $data_list = $user_object->page($p, C('ADMIN_PAGE_ROWS'))->where($map)->order('id desc')->select(); $page = new Page($user_object->where($map)->count(), C('ADMIN_PAGE_ROWS')); // 使用Builder快速建立列表页面。 $builder = new \Common\Builder\ListBuilder(); $builder->setMetaTitle('用户列表')->addTopButton('addnew')->addTopButton('resume')->addTopButton('forbid')->addTopButton('delete')->setSearch('请输入ID/用户名/邮箱/手机号', U('index'))->addTableColumn('id', 'UID')->addTableColumn('avatar', '头像', 'picture')->addTableColumn('nickname', '昵称')->addTableColumn('username', '用户名')->addTableColumn('email', '邮箱')->addTableColumn('mobile', '手机号')->addTableColumn('create_time', '注册时间', 'time')->addTableColumn('status', '状态', 'status')->addTableColumn('right_button', '操作', 'btn')->setTableDataList($data_list)->setTableDataPage($page->show())->addRightButton('edit')->addRightButton('forbid')->addRightButton('recycle')->display(); }
/** * 部门列表 * @author jry <*****@*****.**> */ public function index() { // 搜索 $keyword = I('keyword', '', 'string'); $condition = array('like', '%' . $keyword . '%'); $map['id|title'] = array($condition, $condition, '_multi' => true); // 获取所有部门 $map['status'] = array('egt', '0'); //禁用和正常状态 $data_list = D('Group')->where($map)->order('sort asc, id asc')->select(); // 转换成树状列表 $tree = new Tree(); $data_list = $tree->toFormatTree($data_list); // 使用Builder快速建立列表页面。 $builder = new \Common\Builder\ListBuilder(); $builder->setMetaTitle('部门列表')->addTopButton('addnew')->addTopButton('resume')->addTopButton('forbid')->addTopButton('delete')->setSearch('请输入ID/部门名称', U('index'))->addTableColumn('id', 'ID')->addTableColumn('title_show', '标题')->addTableColumn('icon', '图标', 'icon')->addTableColumn('sort', '排序')->addTableColumn('status', '状态', 'status')->addTableColumn('right_button', '操作', 'btn')->setTableDataList($data_list)->addRightButton('edit')->addRightButton('forbid')->addRightButton('delete')->alterTableData(array('key' => 'id', 'value' => '1'), array('right_button' => '<a class="label label-warning">超级管理员无需操作</a>'))->display(); }
/** * 菜单列表 */ public function index() { //搜索 $keyword = (string) I('keyword'); $condition = array('like', '%' . $keyword . '%'); $map['id|title'] = array($condition, $condition, '_multi' => true); //搜索条件 //获取所有菜单 $map['status'] = array('egt', 0); //禁用和正常状态 $data_list = D('SystemMenu')->where($map)->order('sort asc, id asc')->select(); //转换成树状列表 $tree = new \Common\Util\Tree(); $data_list = $tree->toFormatTree($data_list); //使用Builder快速建立列表页面。 $builder = new \Common\Builder\ListBuilder(); $builder->title('菜单列表')->AddNewButton()->addResumeButton()->addForbidButton()->addDeleteButton()->setSearch('请输入ID/菜单名称', U('index'))->addField('id', 'ID', 'text')->addField('title_show', '标题', 'text')->addField('url', '链接', 'text')->addField('icon', '图标', 'icon')->addField('sort', '排序', 'text')->addField('status', '状态', 'status')->addField('right_button', '操作', 'btn')->dataList($data_list)->addRightButton('edit')->addRightButton('forbid')->addRightButton('delete')->display(); }
/** * 上传列表 * @author jry <*****@*****.**> */ public function index() { //搜索 $keyword = I('keyword', '', 'string'); $condition = array('like', '%' . $keyword . '%'); $map['id|path'] = array($condition, $condition, '_multi' => true); //获取所有上传 $map['status'] = array('egt', '0'); //禁用和正常状态 $data_list = D('PublicUpload')->page(!empty($_GET["p"]) ? $_GET["p"] : 1, C('ADMIN_PAGE_ROWS'))->where($map)->order('sort desc,id desc')->select(); $page = new \Common\Util\Page(D('PublicUpload')->where($map)->count(), C('ADMIN_PAGE_ROWS')); foreach ($data_list as &$data) { $data['name'] = get_str($data['name'], 0, 30) . '<input class="form-control input-sm" value="' . $data['path'] . '">'; } //使用Builder快速建立列表页面。 $builder = new \Common\Builder\ListBuilder(); $builder->setMetaTitle('上传列表')->addTopButton('resume')->addTopButton('forbid')->addTopButton('delete')->setSearch('请输入ID/上传关键字', U('index'))->addTableColumn('id', 'ID')->addTableColumn('show', '文件')->addTableColumn('name', '文件名及路径')->addTableColumn('size', '大小')->addTableColumn('ctime', '创建时间', 'time')->addTableColumn('sort', '排序')->addTableColumn('status', '状态', 'status')->addTableColumn('right_button', '操作', 'btn')->setTableDataList($data_list)->setTableDataPage($page->show())->addRightButton('forbid')->addRightButton('delete')->display(); }
/** * 默认方法 * @author jry <*****@*****.**> */ public function index($doc_type) { //搜索 $keyword = (string) I('keyword'); $condition = array('like', '%' . $keyword . '%'); $map['id|name|title'] = array($condition, $condition, $condition, '_multi' => true); if ($doc_type) { $map['doc_type'] = $doc_type; } $map['status'] = array('egt', 0); $document_attribute_list = D('DocumentAttribute')->page(!empty($_GET["p"]) ? $_GET["p"] : 1, C('ADMIN_PAGE_ROWS'))->order('id desc')->where($map)->select(); $page = new \Common\Util\Page(D('DocumentAttribute')->where($map)->count(), C('ADMIN_PAGE_ROWS')); $attr['href'] = U('add', array('doc_type' => $doc_type)); $attr['class'] = 'btn btn-primary'; //使用Builder快速建立列表页面。 $builder = new \Common\Builder\ListBuilder(); $builder->title(字段管理)->AddButton('新 增', $attr)->addResumeButton()->addForbidButton()->setSearch('请输入ID/名称/标题', U('index'))->addField('id', 'ID', 'text')->addField('name', '名称', 'text')->addField('title', '标题', 'text')->addField('type', '类型', 'type')->addField('ctime', '发布时间', 'time')->addField('status', '状态', 'status')->addField('right_button', '操作', 'btn')->dataList($document_attribute_list)->addRightButton('edit')->addRightButton('forbid')->addRightButton('delete')->setPage($page->show())->display(); }
/** * 模型列表 * @author jry <*****@*****.**> */ public function index() { //搜索 $keyword = I('keyword', '', 'string'); $condition = array('like', '%' . $keyword . '%'); $map['id|title|name'] = array($condition, $condition, $condition, '_multi' => true); //获取所有模型 $map['status'] = array('egt', '0'); //禁用和正常状态 $data_list = D('DocumentType')->page(!empty($_GET["p"]) ? $_GET["p"] : 1, C('ADMIN_PAGE_ROWS'))->where($map)->order('sort asc,id asc')->select(); $page = new \Common\Util\Page(D('DocumentType')->where($map)->count(), C('ADMIN_PAGE_ROWS')); $attr['title'] = '字段管理'; $attr['class'] = 'label label-success'; $attr['href'] = U('Admin/DocumentAttribute/index', array('doc_type' => '__data_id__')); //使用Builder快速建立列表页面。 $builder = new \Common\Builder\ListBuilder(); $builder->setMetaTitle('模型列表')->addTopButton('addnew')->addTopButton('resume')->addTopButton('forbid')->setSearch('请输入ID/模型标题', U('index'))->addTableColumn('id', 'ID')->addTableColumn('icon', '图标', 'icon')->addTableColumn('name', '名称')->addTableColumn('title', '标题')->addTableColumn('ctime', '创建时间', 'time')->addTableColumn('sort', '排序')->addTableColumn('status', '状态', 'status')->addTableColumn('right_button', '操作', 'btn')->setTableDataList($data_list)->setTableDataPage($page->show())->addRightButton('self', $attr)->addRightButton('edit')->addRightButton('forbid')->addRightButton('delete')->alterTableData(array('key' => 'system', 'value' => '1'), array('right_button' => '<a class="label label-warning">系统模型无需操作</a>'))->display(); }
/** * 数据字典 * @author jry <*****@*****.**> */ public function index($table_id = 0) { //取得所有表 $database = C('DB_NAME'); //数据库名 $table_list = M()->query('show tables'); //获取所有数据表名称 //构造Tab列表 $tab_list = array(); foreach ($table_list as $key => $val) { //获取数据表名称 $tab_name = $table_title . $val['Tables_in_' . $database]; //获取当前表的详细信息 $sql = 'SELECT * FROM '; $sql .= 'INFORMATION_SCHEMA.TABLES '; $sql .= 'WHERE '; $sql .= "table_name = '{$tab_name}' AND table_schema = '{$database}'"; $table_info = M()->query($sql); //获取数据表标题与链接 $tab_list[$key]['title'] = $table_info[0]['TABLE_COMMENT'] . '(' . $tab_name . ')'; $tab_list[$key]['href'] = U('index', array('table_id' => $key)); } //获取当前数据表名称 $current_table['table_name'] = $table_list[$table_id]['Tables_in_' . $database]; //获取当前表的详细信息 $sql = 'SELECT * FROM '; $sql .= 'INFORMATION_SCHEMA.TABLES '; $sql .= 'WHERE '; $sql .= "table_name = '{$current_table['table_name']}' AND table_schema = '{$database}'"; $current_table_info = M()->query($sql); //获取当前表的备注 $current_table['table_comment'] = $current_table_info[0]['TABLE_COMMENT']; //获取当前表的字段详细信息 $sql = 'SELECT * FROM '; $sql .= 'INFORMATION_SCHEMA.COLUMNS '; $sql .= 'WHERE '; $sql .= "table_name = '{$current_table['table_name']}' AND table_schema = '{$database}'"; $current_table_columns_info = M()->query($sql); //获取当前表的字段信息 $current_table['fields'] = $current_table_columns_info; //使用Builder快速建立列表页面。 $builder = new \Common\Builder\ListBuilder(); $builder->setMetaTitle($current_table['table_name'] . '|数据字典')->SetTabNav($tab_list, $table_id)->addTableColumn('COLUMN_NAME', '字段名', 'text')->addTableColumn('COLUMN_TYPE', '数据类型', 'text')->addTableColumn('COLUMN_DEFAULT', '默认值', 'text')->addTableColumn('IS_NULLABLE', '允许非空', 'text')->addTableColumn('EXTRA', '自动递增', 'text')->addTableColumn('COLUMN_COMMENT', '备注', 'text')->setTableDataList($current_table['fields'])->display(); }
/** * 默认方法 * @author jry <*****@*****.**> */ public function index($doc_type) { // 搜索 $keyword = I('keyword', '', 'string'); $condition = array('like', '%' . $keyword . '%'); $map['id|name|title'] = array($condition, $condition, $condition, '_multi' => true); if ($doc_type) { $map['doc_type'] = $doc_type; } $map['status'] = array('egt', 0); $attribute_list = D('Attribute')->page(!empty($_GET["p"]) ? $_GET["p"] : 1, C('ADMIN_PAGE_ROWS'))->order('id desc')->where($map)->select(); $page = new Page(D('Attribute')->where($map)->count(), C('ADMIN_PAGE_ROWS')); $attr['title'] = '新 增'; $attr['class'] = 'btn btn-primary'; $attr['href'] = U('add', array('doc_type' => $doc_type)); // 使用Builder快速建立列表页面。 $builder = new \Common\Builder\ListBuilder(); $builder->setMetaTitle('字段管理')->addTopButton('self', array('title' => '<i class="fa fa-reply"></i> 返回模型列表', 'class' => 'btn btn-warning', 'onclick' => 'javascript:history.back(-1);return false;'))->addTopButton('self', $attr)->addTopButton('resume')->addTopButton('forbid')->setSearch('请输入ID/名称/标题', U('index'))->addTableColumn('id', 'ID')->addTableColumn('name', '名称')->addTableColumn('title', '标题')->addTableColumn('type', '类型', 'type')->addTableColumn('ctime', '发布时间', 'time')->addTableColumn('status', '状态', 'status')->addTableColumn('right_button', '操作', 'btn')->setTableDataList($attribute_list)->setTableDataPage($page->show())->addRightButton('edit')->addRightButton('forbid')->addRightButton('delete')->display(); }
/** * 类型列表 * @author jry <*****@*****.**> */ public function index() { //搜索 $keyword = (string) I('keyword'); $condition = array('like', '%' . $keyword . '%'); $map['id|title|name'] = array($condition, $condition, $condition, '_multi' => true); //获取所有类型 $map['system'] = array('eq', '0'); //非系统类型 $map['status'] = array('egt', '0'); //禁用和正常状态 $data_list = D('DocumentType')->page(!empty($_GET["p"]) ? $_GET["p"] : 1, C('ADMIN_PAGE_ROWS'))->where($map)->order('sort asc,id asc')->select(); $page = new \Common\Util\Page(D('DocumentType')->where($map)->count(), C('ADMIN_PAGE_ROWS')); $attr['title'] = '字段管理'; $attr['href'] = 'DocumentAttribute/index?doc_type='; //使用Builder快速建立列表页面。 $builder = new \Common\Builder\ListBuilder(); $builder->title('类型列表')->AddNewButton()->addResumeButton()->addForbidButton()->setSearch('请输入ID/类型标题', U('index'))->addField('id', 'ID', 'text')->addField('icon', '图标', 'icon')->addField('name', '名称', 'text')->addField('title', '标题', 'text')->addField('ctime', '创建时间', 'time')->addField('sort', '排序', 'text')->addField('status', '状态', 'status')->addField('right_button', '操作', 'btn')->dataList($data_list)->addRightButton('self', $attr)->addRightButton('edit')->addRightButton('forbid')->addRightButton('delete')->setPage($page->show())->display(); }
/** * 默认方法 * @author jry <*****@*****.**> */ public function index() { // 搜索 $keyword = I('keyword', '', 'string'); $condition = array('like', '%' . $keyword . '%'); $map['id|title'] = array($condition, $condition, '_multi' => true); // 获取所有分类 $p = $_GET["p"] ?: 1; if (I('cid')) { $cid = $map['cid'] = I('cid'); } $map['status'] = array('egt', '0'); // 禁用和正常状态 $post_object = D('Admin/Post'); $data_list = $post_object->page($p, C('ADMIN_PAGE_ROWS'))->where($map)->order('sort desc,id desc')->select(); $page = new Page($post_object->where($map)->count(), C('ADMIN_PAGE_ROWS')); // 使用Builder快速建立列表页面。 $builder = new \Common\Builder\ListBuilder(); $builder->setMetaTitle('文章列表')->addTopButton('self', array('title' => '<i class="fa fa-reply"></i> 返回导航列表', 'class' => 'btn btn-warning', 'onclick' => 'javascript:history.back(-1);return false;'))->addTopButton('addnew', array('href' => U('add', array('cid' => $cid))))->addTopButton('resume')->addTopButton('forbid')->setSearch('请输入ID/标题', U('index'))->addTableColumn('id', 'ID')->addTableColumn('cover', '封面', 'picture')->addTableColumn('title', '标题')->addTableColumn('create_time', '创建时间', 'time')->addTableColumn('sort', '排序')->addTableColumn('status', '状态', 'status')->addTableColumn('right_button', '操作', 'btn')->setTableDataList($data_list)->setTableDataPage($page->show())->addRightButton('edit')->addRightButton('forbid')->addRightButton('delete')->display(); }
/** * 分类列表 * @author jry <*****@*****.**> */ public function index($group = 1) { //搜索 $keyword = (string) I('keyword'); $condition = array('like', '%' . $keyword . '%'); $map['id|title'] = array($condition, $condition, '_multi' => true); //获取所有分类 $map['status'] = array('egt', '0'); //禁用和正常状态 if (I('get.pid')) { $map['pid'] = array('eq', I('get.pid')); //父分类ID } $map['group'] = array('eq', $group); $data_list = D('Category')->field('id,pid,group,doc_type,title,url,icon,ctime,sort,status')->where($map)->order('sort asc,id asc')->select(); foreach ($data_list as &$item) { if ($item['doc_type'] >= 3) { $item['title'] = '<a href="' . U('Document/index', array('cid' => $item['id'])) . '">' . $item['title'] . '</a>'; } } //转换成树状列表 $tree = new \Common\Util\Tree(); $data_list = $tree->toFormatTree($data_list); //设置Tab导航数据列表 $category_group_list = C('CATEGORY_GROUP_LIST'); //获取分类分组 foreach ($category_group_list as $key => $val) { $tab_list[$key]['title'] = $val; $tab_list[$key]['href'] = U('index', array('group' => $key)); } $attr['title'] = '编辑'; $attr['class'] = 'label label-info'; $attr['href'] = U('Admin/Category/edit', array('group' => $group, 'id' => '__data_id__')); //使用Builder快速建立列表页面。 $builder = new \Common\Builder\ListBuilder(); $builder->setMetaTitle('分类列表')->addTopButton('addnew', array('href' => U('Admin/Category/add/group/' . $group)))->addTopButton('resume')->addTopButton('forbid')->setSearch('请输入ID/分类名称', U('Admin/Category/index/group/' . $group))->setTabNav($tab_list, $group)->addTableColumn('id', 'ID')->addTableColumn('title_show', '分类')->addTableColumn('url', '链接')->addTableColumn('icon', '图标', 'icon')->addTableColumn('sort', '排序')->addTableColumn('status', '状态', 'status')->addTableColumn('right_button', '操作', 'btn')->setTableDataList($data_list)->addRightButton('self', $attr)->addRightButton('forbid')->addRightButton('delete')->display(); }
/** * 管理员列表 * @param $tab 配置分组ID * @author jry <*****@*****.**> */ public function index() { // 搜索 $keyword = I('keyword', '', 'string'); $condition = array('like', '%' . $keyword . '%'); $map['id|uid'] = array($condition, $condition, '_multi' => true); // 获取所有配置 $map['status'] = array('egt', '0'); // 禁用和正常状态 $p = !empty($_GET["p"]) ? $_GET['p'] : 1; $access_object = D('Access'); $data_list = $access_object->page($p, C('ADMIN_PAGE_ROWS'))->where($map)->order('sort asc,id asc')->select(); $page = new Page($access_object->where($map)->count(), C('ADMIN_PAGE_ROWS')); // 设置Tab导航数据列表 $group_object = D('Group'); $user_object = D('User'); foreach ($data_list as $key => &$val) { $val['username'] = $user_object->getFieldById($val['uid'], 'username'); $val['group_title'] = $group_object->getFieldById($val['group'], 'title'); } // 使用Builder快速建立列表页面。 $builder = new \Common\Builder\ListBuilder(); $builder->setMetaTitle('管理员列表')->addTopButton('addnew')->addTopButton('resume')->addTopButton('forbid')->addTopButton('delete')->setSearch('请输入ID/UID', U('index'))->addTableColumn('id', 'ID')->addTableColumn('uid', 'UID')->addTableColumn('username', '用户名')->addTableColumn('group_title', '用户组')->addTableColumn('status', '状态', 'status')->addTableColumn('right_button', '操作', 'btn')->setTableDataList($data_list)->setTableDataPage($page->show())->addRightButton('edit')->addRightButton('forbid')->addRightButton('delete')->display(); }
/** * 我的文档列表 * @author jry <*****@*****.**> */ public function mydoc() { $uid = $this->is_login(); //获取文档基础信息 $map['uid'] = $uid; $map['status'] = array('egt', 0); $document_list = D('Document')->page(!empty($_GET["p"]) ? $_GET["p"] : 1, C('ADMIN_PAGE_ROWS'))->order('sort desc,id desc')->where($map)->select(); $page = new \Common\Util\Page(D('Document')->where($map)->count(), C('ADMIN_PAGE_ROWS')); //获取扩展表的信息 //前台与后台查询文档列表不一样 //因为前台没有指定分类ID所以只能通过先找到文档的分类ID再根据分类绑定的模型获取主要字段 foreach ($document_list as &$document) { //合并基础信息与扩展信息 $doc_type_info = D('DocumentType')->find($document['doc_type']); $document = array_merge($document, D('Document' . ucfirst($doc_type_info['name']))->find($document['id'])); //给主要字段赋值 $main_field_name = D('DocumentAttribute')->getFieldById($doc_type_info['main_field'], 'name'); $document['main_field'] = $document[$main_field_name]; } //使用Builder快速建立列表页面。 $builder = new \Common\Builder\ListBuilder(); $builder->setMetaTitle('我的文档')->addTopButton('resume')->addTopButton('forbid')->addTopButton('recycle')->addTableColumn('id', 'ID')->addTableColumn('main_field', '标题')->addTableColumn('ctime', '发布时间', 'time')->addTableColumn('sort', '排序')->addTableColumn('status', '状态', 'status')->addTableColumn('right_button', '操作', 'btn')->setTableDataList($document_list)->setTableDataPage($page->show())->addRightButton('edit')->addRightButton('forbid')->addRightButton('recycle')->setTemplate('_Builder/listbuilder_user')->display(); }
/** * 回收站 * @author jry <*****@*****.**> */ public function recycle() { $map['status'] = array('eq', '-1'); $document_list = D('Document')->page(!empty($_GET["p"]) ? $_GET["p"] : 1, C('ADMIN_PAGE_ROWS'))->where($map)->select(); $page = new \Common\Util\Page(D('Document')->where($map)->count(), C('ADMIN_PAGE_ROWS')); //使用Builder快速建立列表页面。 $builder = new \Common\Builder\ListBuilder(); $builder->setMetaTitle('回收站')->addTopButton('delete')->addTopButton('restore')->setSearch('请输入ID/文档名称', U('recycle'))->addTableColumn('id', 'ID')->addTableColumn('title', '标题')->addTableColumn('ctime', '发布时间', 'time')->addTableColumn('sort', '排序')->addTableColumn('status', '状态', 'status')->addTableColumn('right_button', '操作', 'btn')->setTableDataList($document_list)->setTableDataPage($page->show())->addRightButton('restore')->addRightButton('delete')->display(); }