<?php
namespace app\admin\controller;
use think\App;
use think\Db;
class DailyForm extends Auth {
public function __construct(App $app = null) {
parent::__construct($app);
$this->model = new \app\common\model\DailyForm();
}
public function index() {
if (request()->isAjax()) {
//分页参数
$length = input('rows', 10, 'intval'); //每页条数
$page = input('page', 1, 'intval'); //第几页
$start = ($page - 1) * $length; //分页开始位置
//排序
$sortRow = input('sidx', 'sort', 'trim'); //排序列
$sort = input('sord', 'asc', 'trim'); //排序方式
$order = $sortRow . ' ' . $sort . ' ,id desc';
$title = input('content', '', 'trim');
if ($title) {
$map[] = ['content', 'like', '%' . $title . '%'];
}
$enable = input('enable', '', 'trim');
if ($enable != '') {
$map[] = ['enable', '=', $enable];
}
$map[] = ['org_id', '=', $this->orgId];
$map[] = ['del', '=', 0];
$map = empty($map) ? true : $map;
//数据查询
$lists = Db::name('daily_form')
->where($map)->limit($start, $length)->order($order)->select();
//数据返回
$totalCount = Db::name('daily_form')->where($map)->count();
$totalPage = ceil($totalCount / $length);
$result['page'] = $page;
$result['total'] = $totalPage;
$result['records'] = $totalCount;
$result['rows'] = $lists;
return json($result);
}
else {
$this->assign('meta_title', '工作项列表');
$this->assign('m_name', '工作项');
return $this->fetch();
}
}
/**
* 新增/编辑
*/
public function add($id = 0) {
if (request()->isPost()) {
$model = $this->model;
$res = $model->updates();
if ($res) {
$this->success('操作成功', url('index'));
}
else {
$this->error($model->getError());
}
}
else {
$meta_title = '新增工作项';
if ($id) {
$info = Db::name('daily_form')->where('id', $id)->find();
$this->assign('info', $info);
$meta_title = '编辑工作项';
}
$this->assign('meta_title', $meta_title);
return $this->fetch();
}
}
/**
* 删除记录
* @param int $id
*/
public function del($id = 0) {
if (!$id) {
$this->error('参数错误');
}
$res = Db::name('daily_form')->where('id', $id)->update(['del' => 1]);
if ($res) {
$this->success('删除成功');
}
else {
$this->error('删除失败');
}
}
/**
* 改变字段值
* @param int $fv
* @param string $fn
* @param int $fv
*/
public function changeField($id = 0, $fn = '', $fv = 0) {
if (!$fn || !$id) {
$this->error('参数错误');
}
$res = Db::name('daily_form')->where('id', $id)->update([$fn => $fv]);
if ($res) {
$this->success('操作成功');
}
else {
$this->error('操作失败');
}
}
}