request->isPost()) { $params = input('searchParams/a'); $page = input('page/d', 1); $size = input('size/d', 20); $where = []; $worksiteId = input('worksite_id/d'); $worksiteId = $worksiteId ?: 0; if ($worksiteId) { $where[] = ['worksite_id', '=', $worksiteId]; } if (!empty($params)) { foreach ($params as $key => $param) { $param = trim($param); if ($key == 'keyword') { $where[] = ['name', 'like', '%'.$param.'%']; continue; } if ($param == '0' || !empty($param)) { $where[] = [$key, 'like', '%'.$param.'%']; } } } $query = \app\model\ProjectProgress::where($where); $total = $query->count(); $res = [ 'total' => $total, 'current' => $page ?: 1, 'size' => $size ?: 20, 'list' => new Collection(), ]; if ($total > 0) { $res['list'] = $query->page($page, $size)->order('sort', 'desc')->order('id', 'desc')->select(); } return $this->json(0, 'success', $res); } $this->data['worksiteId'] = $worksiteId; return $this->view(); } /** * 添加 * * @return Json|View */ public function add() { $worksiteId = input('worksite_id/d'); if ($this->request->isPost()) { try { $input = input('post.'); if (!isset($input['name'])) { return $this->json(4000, '参数错误'); } \app\model\ProjectProgress::create([ 'worksite_id' => $input['worksite_id'] ?? 0, 'name' => $input['name'] ?? '', 'content' => $input['content'] ?? '', 'created_at' => date('Y-m-d H:i:s'), ]); return $this->json(); } catch (Exception $e) { return $this->json(4001, '添加失败'.$e->getMessage()); } } $this->data['worksiteId'] = $worksiteId; return $this->view(); } /** * 编辑 * * @return \think\response\Json|\think\response\View */ public function edit() { $id = input('id'); //通过ID查询 $item = \app\model\ProjectProgress::where('id', (int) $id)->find(); if (empty($item)) { return $this->json(4000, '没有相关记录!'); } if ($this->request->isPost()) { try { $input = input('post.'); if (!isset($input['name'])) { return $this->json(4000, '参数错误'); } $item->save([ 'name' => $input['name'] ?? '', 'content' => $input['content'] ?? '', ]); return $this->json(); } catch (Exception $e) { return $this->json(5000, $e->getMessage()); } } $this->data['item'] = $item; $this->data['id'] = $id; return $this->view(); } /** * 更新属性 * * @throws ModelNotFoundException * @throws DbException * @throws DataNotFoundException * @throws Exception */ public function modify() { if (!$this->request->isPost()) { return $this->json(4000, '非法请求'); } $item = input('post.'); $validate = $this->validateByApi($item, [ 'field' => 'require', 'value' => 'require', ]); if ($validate !== true) { return $validate; } // 通过ID查询 if (!$info = \app\model\ProjectProgress::where('id', (int) $item['id'])->find()) { return $this->json(4001, '记录不存在'); } $update = [$item['field'] => $item['value']]; try { $info->save($update); return $this->json(); } catch (ValidateException $e) { return $this->json(4001, $e->getError()); } catch (Exception $e) { return $this->json(5000, '修改失败'); } } /** * 删除 * * @return \think\response\Json */ public function del(): Json { if (!$this->request->isPost()) { return $this->json(4000, '非法请求'); } $ids = $this->request->param('ids/a', []); if (empty($ids)) { $ids[] = $this->request->param('id/d', 0); $ids = array_filter($ids); } try { if (count($ids)) { //删除逻辑 \app\model\ProjectProgress::whereIn('id', $ids)->delete(); Log::write(get_class(), 'del', '删除操作,涉及到的ID为:'.implode(',', $ids)); } } catch (Exception $e) { return $this->json(5000, $e->getMessage()); } return $this->json(); } }