338 lines
12 KiB
PHP
338 lines
12 KiB
PHP
<?php
|
||
namespace app\cms\admin;
|
||
|
||
use app\admin\controller\Admin;
|
||
use app\common\builder\ZBuilder;
|
||
use app\cms\model\Column as ColumnModel;
|
||
use app\cms\model\Document as DocumentModel;
|
||
use app\cms\model\Field as FieldModel;
|
||
use think\Db;
|
||
use util\Tree;
|
||
|
||
/**
|
||
* 文档控制器
|
||
* @package app\cms\admin
|
||
*/
|
||
class Document extends Admin
|
||
{
|
||
/**
|
||
* 文档列表
|
||
* @author 蔡伟明 <314013107@qq.com>
|
||
*/
|
||
public function index()
|
||
{
|
||
cookie('__forward__', $_SERVER['REQUEST_URI']);
|
||
// 查询
|
||
$map = $this->getMap();
|
||
$map[] = ['cms_document.trash', '=', 0];
|
||
// 排序
|
||
$order = $this->getOrder('update_time desc');
|
||
// 数据列表
|
||
$data_list = DocumentModel::getList($map, $order);
|
||
|
||
// 使用ZBuilder快速创建数据表格
|
||
return ZBuilder::make('table')
|
||
->setSearch(['title' => '标题', 'cms_column.name' => '栏目名称']) // 设置搜索框
|
||
->addColumns([ // 批量添加数据列
|
||
['id', 'ID'],
|
||
['title', '标题'],
|
||
['column_name', '栏目名称'],
|
||
['view', '点击量'],
|
||
['username', '发布人'],
|
||
['update_time', '更新时间', 'datetime'],
|
||
['sort', '排序', 'text.edit'],
|
||
['status', '状态', 'switch'],
|
||
['right_button', '操作', 'btn']
|
||
])
|
||
->addTopButtons('add,enable,disable,delete') // 批量添加顶部按钮
|
||
->addRightButtons(['edit', 'delete']) // 批量添加右侧按钮
|
||
->addOrder(['column_name' => 'cms_document.cid'])
|
||
->addOrder('id,title,view,username,update_time')
|
||
->addFilter(['column_name' => 'cms_column.name', 'username' => 'admin_user'])
|
||
->setRowList($data_list) // 设置表格数据
|
||
->fetch(); // 渲染模板
|
||
}
|
||
|
||
/**
|
||
* 添加文档
|
||
* @param int $cid 栏目id
|
||
* @param string $model 模型id
|
||
* @author 蔡伟明 <314013107@qq.com>
|
||
* @return mixed
|
||
* @throws \think\Exception
|
||
*/
|
||
public function add($cid = 0, $model = '')
|
||
{
|
||
// 保存文档数据
|
||
if ($this->request->isAjax()) {
|
||
$DocumentModel = new DocumentModel();
|
||
if (false === $DocumentModel->saveData()) {
|
||
$this->error($DocumentModel->getError());
|
||
}
|
||
$this->success('新增成功', cookie('__forward__'));
|
||
}
|
||
|
||
// 第二步，填写文档信息
|
||
if ($cid > 0) {
|
||
cookie('__forward__', url('add', ['cid' => $cid]));
|
||
// 获取栏目数据
|
||
$column = ColumnModel::getInfo($cid);
|
||
|
||
// 独立模型只取该模型的字段，不包含系统字段
|
||
$where = [];
|
||
if (get_model_type($column['model']) == 2) {
|
||
$where[] = ['model', '=', $column['model']];
|
||
} else {
|
||
$where[] = ['model', 'in', [0, $column['model']]];
|
||
}
|
||
|
||
// 获取文档模型字段
|
||
$where[] = ['status', '=', 1];
|
||
$where[] = ['show', '=', 1];
|
||
$fields = FieldModel::where($where)->order('sort asc,id asc')->column(true);
|
||
|
||
foreach ($fields as &$value) {
|
||
// 解析options
|
||
if ($value['options'] != '') {
|
||
$value['options'] = parse_attr($value['options']);
|
||
}
|
||
|
||
switch ($value['type']) {
|
||
case 'linkage':// 解析联动下拉框异步请求地址
|
||
if (!empty($value['ajax_url']) && substr($value['ajax_url'], 0, 4) != 'http') {
|
||
$value['ajax_url'] = url($value['ajax_url']);
|
||
}
|
||
break;
|
||
case 'date':
|
||
case 'time':
|
||
case 'datetime':
|
||
$value['value'] = '';
|
||
break;
|
||
case 'bmap':
|
||
$value['level'] = $value['level'] == 0 ? 12 : $value['level'];
|
||
break;
|
||
case 'colorpicker':
|
||
$value['mode'] = 'rgba';
|
||
break;
|
||
}
|
||
}
|
||
|
||
// 添加额外表单项信息
|
||
$extra_field = [
|
||
['name' => 'cid', 'title' => '所属栏目', 'type' => 'static', 'value' => $column['name']],
|
||
['name' => 'cid', 'type' => 'hidden', 'value' => $cid],
|
||
['name' => 'model', 'type' => 'hidden', 'value' => $column['model']]
|
||
];
|
||
$fields = array_merge($extra_field, $fields);
|
||
|
||
// 使用ZBuilder快速创建表单
|
||
return ZBuilder::make('form')
|
||
->setFormItems($fields)
|
||
->hideBtn('back')
|
||
->fetch();
|
||
}
|
||
|
||
// 第一步，选择栏目
|
||
if ($model == '') {
|
||
$columns = ColumnModel::getTreeList(0, false);
|
||
} else {
|
||
// 获取相同内容模型的栏目
|
||
$columns = Db::name('cms_column')->where('model', $model)->order('pid,id')->column('id,name,pid');
|
||
$columns = Tree::config(['title' => 'name'])->toList($columns, current($columns)['pid']);
|
||
$result = [];
|
||
foreach ($columns as $column) {
|
||
$result[$column['id']] = $column['title_display'];
|
||
}
|
||
$columns = $result;
|
||
}
|
||
return ZBuilder::make('form')
|
||
->addFormItem('select', 'cid', '选择栏目', '请选择栏目', $columns)
|
||
->setBtnTitle('submit', '下一步')
|
||
->hideBtn('back')
|
||
->isAjax(false)
|
||
->fetch();
|
||
}
|
||
|
||
/**
|
||
* 编辑文档
|
||
* @param null $id 文档id
|
||
* @param string $model 模型id
|
||
* @author 蔡伟明 <314013107@qq.com>
|
||
* @return mixed
|
||
* @throws \think\Exception
|
||
*/
|
||
public function edit($id = null, $model = '')
|
||
{
|
||
if ($id === null) $this->error('参数错误');
|
||
|
||
// 保存文档数据
|
||
if ($this->request->isPost()) {
|
||
$DocumentModel = new DocumentModel();
|
||
$result = $DocumentModel->saveData();
|
||
if (false === $result) {
|
||
$this->error($DocumentModel->getError());
|
||
}
|
||
$this->success('编辑成功', cookie('__forward__'));
|
||
}
|
||
|
||
// 获取数据
|
||
$info = DocumentModel::getOne($id, $model);
|
||
|
||
// 独立模型只取该模型的字段，不包含系统字段
|
||
$where = [];
|
||
if ($model != '') {
|
||
$where[] = ['model', '=', $model];
|
||
} else {
|
||
$where[] = ['model', 'in', [0, $info['model']]];
|
||
}
|
||
|
||
// 用于查询内容模型栏目
|
||
$map = $where;
|
||
|
||
// 获取文档模型字段
|
||
$where[] = ['status', '=', 1];
|
||
$where[] = ['show', '=', 1];
|
||
$fields = FieldModel::where($where)->order('sort asc,id asc')->column(true);
|
||
|
||
foreach ($fields as $id => &$value) {
|
||
// 解析options
|
||
if ($value['options'] != '') {
|
||
$value['options'] = parse_attr($value['options']);
|
||
}
|
||
// 日期时间
|
||
switch ($value['type']) {
|
||
case 'date':
|
||
$info[$value['name']] = format_time($info[$value['name']], 'Y-m-d');
|
||
break;
|
||
case 'time':
|
||
$info[$value['name']] = format_time($info[$value['name']], 'H:i:s');
|
||
break;
|
||
case 'datetime':
|
||
$info[$value['name']] = empty($info[$value['name']]) ? '' : format_time($info[$value['name']]);
|
||
break;
|
||
case 'bmap':
|
||
$value['level'] = $value['level'] == 0 ? 12 : $value['level'];
|
||
break;
|
||
case 'colorpicker':
|
||
$value['mode'] = 'rgba';
|
||
break;
|
||
}
|
||
}
|
||
|
||
// 获取相同内容模型的栏目
|
||
$columns = Db::name('cms_column')->where($map)->whereOr('model', $info['model'])->order('pid,id')->column('id,name,pid');
|
||
$columns = Tree::config(['title' => 'name'])->toList($columns, current($columns)['pid']);
|
||
$result = [];
|
||
foreach ($columns as $column) {
|
||
$result[$column['id']] = $column['title_display'];
|
||
}
|
||
$columns = $result;
|
||
|
||
|
||
// 添加额外表单项信息
|
||
$extra_field = [
|
||
['name' => 'id', 'type' => 'hidden'],
|
||
['name' => 'cid', 'title' => '所属栏目', 'type' => 'select', 'options' => $columns],
|
||
['name' => 'model', 'type' => 'hidden']
|
||
];
|
||
$fields = array_merge($extra_field, $fields);
|
||
|
||
// 使用ZBuilder快速创建表单
|
||
return ZBuilder::make('form')
|
||
->setFormItems($fields)
|
||
->setFormData($info)
|
||
->fetch();
|
||
}
|
||
|
||
/**
|
||
* 删除文档(不是彻底删除，而是移动到回收站)
|
||
* @param null $ids 文档id
|
||
* @param string $table 数据表
|
||
* @author 蔡伟明 <314013107@qq.com>
|
||
*/
|
||
public function delete($ids = null, $table = '')
|
||
{
|
||
if ($ids === null) $this->error('参数错误');
|
||
|
||
$document_id = is_array($ids) ? '' : $ids;
|
||
$document_title = Db::name($table)->where('id', 'in', $ids)->column('title');
|
||
|
||
// 移动文档到回收站
|
||
if (false === Db::name($table)->where('id', 'in', $ids)->setField('trash', 1)) {
|
||
$this->error('删除失败');
|
||
}
|
||
|
||
// 删除并记录日志
|
||
action_log('document_trash', $table, $document_id, UID, implode('、', $document_title));
|
||
$this->success('删除成功');
|
||
}
|
||
|
||
/**
|
||
* 启用文档
|
||
* @param array $record 行为日志
|
||
* @author 蔡伟明 <314013107@qq.com>
|
||
* @throws \think\Exception
|
||
* @throws \think\exception\PDOException
|
||
*/
|
||
public function enable($record = [])
|
||
{
|
||
return $this->setStatus('enable');
|
||
}
|
||
|
||
/**
|
||
* 禁用文档
|
||
* @param array $record 行为日志
|
||
* @author 蔡伟明 <314013107@qq.com>
|
||
* @throws \think\Exception
|
||
* @throws \think\exception\PDOException
|
||
*/
|
||
public function disable($record = [])
|
||
{
|
||
return $this->setStatus('disable');
|
||
}
|
||
|
||
/**
|
||
* 设置文档状态：删除、禁用、启用
|
||
* @param string $type 类型：enable/disable
|
||
* @param array $record
|
||
* @author 蔡伟明 <314013107@qq.com>
|
||
* @throws \think\Exception
|
||
* @throws \think\exception\PDOException
|
||
*/
|
||
public function setStatus($type = '', $record = [])
|
||
{
|
||
$table_token = input('param._t', '');
|
||
$table_token == '' && $this->error('缺少参数');
|
||
!session('?'.$table_token) && $this->error('参数错误');
|
||
|
||
$table_data = session($table_token);
|
||
$table_name = $table_data['table'];
|
||
$ids = $this->request->isPost() ? input('post.ids/a') : input('param.ids');
|
||
$document_id = is_array($ids) ? '' : $ids;
|
||
$document_title = Db::name($table_name)->where('id', 'in', $ids)->column('title');
|
||
return parent::setStatus($type, ['document_'.$type, 'cms_document', $document_id, UID, implode('、', $document_title)]);
|
||
}
|
||
|
||
/**
|
||
* 快速编辑
|
||
* @param array $record 行为日志
|
||
* @author 蔡伟明 <314013107@qq.com>
|
||
* @return mixed
|
||
*/
|
||
public function quickEdit($record = [])
|
||
{
|
||
$table_token = input('param._t', '');
|
||
$table_token == '' && $this->error('缺少参数');
|
||
!session('?'.$table_token) && $this->error('参数错误');
|
||
|
||
$table_data = session($table_token);
|
||
$table = $table_data['table'];
|
||
$id = input('post.pk', '');
|
||
$field = input('post.name', '');
|
||
$value = input('post.value', '');
|
||
$document = Db::name($table)->where('id', $id)->value($field);
|
||
$details = '表名(' . $table . ')，字段(' . $field . ')，原值(' . $document . ')，新值：(' . $value . ')';
|
||
return parent::quickEdit(['document_edit', 'cms_document', $id, UID, $details]);
|
||
}
|
||
}
|