| | |
| | | |
| | | use think\Exception; |
| | | use think\facade\Db; |
| | | use think\facade\Request; |
| | | use think\facade\View; |
| | | use think\response\Json; |
| | | |
| | |
| | | return View::fetch(); |
| | | } |
| | | |
| | | /** |
| | | * 获取在线留言列表 |
| | | * @return Json |
| | | */ |
| | | public function get_online_message_list(): Json { |
| | | try { |
| | | if (!Request::isPost()) { |
| | | throw new Exception('请求方式错误'); |
| | | } |
| | | $page = input('page', 1); |
| | | $limit = input('limit', 10); |
| | | $kw = input('kw', ''); |
| | | $status = input('status', ''); |
| | | $where = []; |
| | | if ($kw) { |
| | | $where[] = ['name|phone|email|subject|message', 'like', "%{$kw}%"]; |
| | | } |
| | | |
| | | if (in_array($status, [0, 1])) { |
| | | $where[] = ['status', '=', $status]; |
| | | } |
| | | $total = Db::name('online_message')->where($where)->count(); |
| | | $list = Db::name('online_message')->where($where)->order('id desc')->page($page, $limit)->select()->toArray(); |
| | | $result = [ |
| | |
| | | } |
| | | 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); |
| | | } |
| | | } |