Message.php 2.1 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970
  1. <?php
  2. namespace app\service\controller;
  3. class Message extends Base
  4. {
  5. public function index()
  6. {
  7. // 留言信息(默认查询前七天的留言)
  8. $start = time()-604800;
  9. $end = time();
  10. if(request()->isPost()){
  11. $start_time = input("param.start_time/s");
  12. $end_time = input("param.end_time/s");
  13. if(!empty($start_time)){
  14. $start = strtotime($start_time);
  15. }
  16. if(!empty($end_time)){
  17. $end = strtotime($end_time . ' 23:59:59');
  18. }
  19. }
  20. $message = db('accountsmessage')->whereBetween('add_time', [$start, $end])->select();
  21. $data = [
  22. 'status'=>1,
  23. 'msg'=>'成功',
  24. 'data'=>$message
  25. ];
  26. return json_encode($data,JSON_UNESCAPED_UNICODE);
  27. }
  28. // 处理留言
  29. public function dealmessage()
  30. {
  31. if(request()->isPost()){
  32. //客服id
  33. //$user_id = 2;
  34. $user_id = input("param.user_id/s");
  35. //留言id
  36. //$message_id = 14;
  37. $message_id = input("param.message_id/s");
  38. $user = db('users')->where('id', $user_id)->find();
  39. if(empty($user)){
  40. return json(['code' => -1, 'data' => '', 'msg' => '客服不存在']);
  41. }
  42. $message = db('accountsmessage')->where('message_id', $message_id)->find();
  43. if(empty($message)){
  44. return json(['code' => -1, 'data' => '', 'msg' => '留言不存在']);
  45. }
  46. // 更新留言状态
  47. $param = [
  48. 'user_id' => $user_id,
  49. 'message_status' => 1,
  50. 'dealWith_time' => time()
  51. ];
  52. try{
  53. db('accountsmessage')->where('message_id', $message_id)->update($param);
  54. }catch(\Exception $e){
  55. return json(['code' => -1, 'data' => '', 'msg' => $e->getMessage()]);
  56. }
  57. return json(['code' => 1, 'data' => url('message/index'), 'msg' => '留言处理成功']);
  58. }
  59. }
  60. }