Message.php 1.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263
  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. //print_r($message);
  22. $this->assign([
  23. 'message' => $message,
  24. ]);
  25. return $this->fetch();
  26. }
  27. // 处理留言
  28. public function dealmessage()
  29. {
  30. if(request()->isPost()){
  31. //客服id
  32. //$user_id = 2;
  33. $user_id = input("param.user_id/s");
  34. //留言id
  35. //$message_id = 14;
  36. $message_id = input("param.message_id/s");
  37. $user = db('users')->where('id', $user_id)->find();
  38. if(empty($user)){
  39. return json(['code' => -1, 'data' => '', 'msg' => '客服不存在']);
  40. }
  41. $message = db('accountsmessage')->where('message_id', $message_id)->find();
  42. if(empty($message)){
  43. return json(['code' => -1, 'data' => '', 'msg' => '留言不存在']);
  44. }
  45. // 更新留言状态
  46. $param = [
  47. 'user_id' => $user_id,
  48. 'message_status' => 1,
  49. 'dealWith_time' => time()
  50. ];
  51. db('accountsmessage')->where('message_id', $message_id)->update($param);
  52. return json(['code' => 1, 'data' => url('message/index'), 'msg' => '处理成功']);
  53. }
  54. }
  55. }