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('操作失败'); } } }