MemberController.php 2.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990
  1. <?php
  2. namespace app\admin\controller\member;
  3. use app\admin\service\member\MemberService;
  4. use app\admin\validate\member\MemberValidate;
  5. use support\Db;
  6. use support\Request;
  7. class MemberController
  8. {
  9. public function selectList(Request $request)
  10. {
  11. $keywords = $request->get('keywords');
  12. if (!$keywords) {
  13. return json_fail("查询错误");
  14. }
  15. $res = Db::table('member')
  16. ->join('member_cert', 'member.member_id', '=', 'member_cert.join_cert_member_id')
  17. ->select('member.member_id', 'member.member_mobile', 'member_cert.member_cert_name')
  18. ->where('member.member_is_owner', 'N')
  19. ->where(function ($query) use ($keywords) {
  20. $query->where('member.member_mobile', 'like', '%' . $keywords . '%')
  21. ->orWhere("member.member_id", 'like', '%' . $keywords . '%')
  22. ->orWhere("member_cert.member_cert_name", 'like', '%' . $keywords . '%');
  23. })->get();
  24. $data = [];
  25. foreach ($res as $item) {
  26. $data[] = [
  27. 'key' => $item->member_id,
  28. 'value' => !empty($item->member_cert_name) ? $item->member_cert_name : $item->member_mobile,
  29. ];
  30. }
  31. return json_success('', $data);
  32. }
  33. public function list(Request $request)
  34. {
  35. return MemberService::list($request);
  36. }
  37. /**
  38. * @Desc 添加会员
  39. * @Author Gorden
  40. * @Date 2024/3/25 13:40
  41. *
  42. * @param Request $request
  43. * @return \support\Response
  44. */
  45. public function add(Request $request)
  46. {
  47. $validate = new MemberValidate();
  48. if (!$validate->scene('add')->check($request->post())) {
  49. return json_fail($validate->getError());
  50. }
  51. return MemberService::add($request->post());
  52. }
  53. /**
  54. * @Desc 绑定的设备
  55. * @Author Gorden
  56. * @Date 2024/4/7 10:20
  57. *
  58. * @param $id
  59. * @return \support\Response
  60. */
  61. public function device($id)
  62. {
  63. return MemberService::deviceList($id);
  64. }
  65. public function addDevice(Request $request)
  66. {
  67. return MemberService::addDevice($request);
  68. }
  69. public function updateDevice(Request $request)
  70. {
  71. return MemberService::updateDevice($request);
  72. }
  73. public function deleteDevice(Request $request)
  74. {
  75. return MemberService::deleteDevice($request);
  76. }
  77. }