where($where)->count(); $list = Db::name('online_message')->where($where)->order('id desc')->page($page, $limit)->select()->toArray(); $result = [ 'code' => 200, 'message' => '获取成功', 'data' => [ 'list' => $list, 'total' => $total, ], ]; } catch (Exception $exc) { $result = [ 'code' => $exc->getCode(), 'message' => $exc->getMessage(), ]; } return json($result); } /** * 修改留言状态 * @return Json */ public function change_message_status(): Json { try { if (!Request::isPost()) { throw new Exception('请求方式错误'); } $id = input('id', 0); if (!$id || !is_numeric($id)) { throw new Exception('参数错误'); } $info = Db::name('online_message')->where('id', $id)->find(); if (!$info) { throw new Exception('留言不存在'); } $status = $info['status'] ? 0 : 1; $update_result = Db::name('online_message')->where('id', $id)->save(['status' => $status]); if (!$update_result) { throw new Exception('操作失败'); } $result = [ 'code' => 200, 'message' => '操作成功', ]; } catch (Exception $exc) { $result = [ 'code' => $exc->getCode(), 'message' => $exc->getMessage(), ]; } return json($result); } }