InfoController.php 1.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354
  1. <?php
  2. /**
  3. * Created by PhpStorm.
  4. * Name: 芸众商城系统
  5. * Author: 广州市芸众信息科技有限公司
  6. * Profile: 广州市芸众信息科技有限公司位于国际商贸中心的广州,专注于移动电子商务生态系统打造,拥有芸众社交电商系统、区块链数字资产管理系统、供应链管理系统、电子合同等产品/服务。官网 :www.yunzmall.com www.yunzshop.com
  7. * Date: 2022/1/7
  8. * Time: 18:28
  9. */
  10. namespace app\outside\modules\member\controllers;
  11. use app\common\models\Member;
  12. use app\outside\controllers\OutsideController;
  13. class InfoController extends OutsideController
  14. {
  15. /**
  16. * @return \Illuminate\Http\JsonResponse
  17. */
  18. public function query()
  19. {
  20. $mobile = request()->input('phone');
  21. if (empty($mobile)) {
  22. return $this->errorJson('搜索条件为空');
  23. }
  24. // $member = Member::select('uid', 'nickname', 'realname', 'mobile', 'avatar')
  25. // ->where('realname', 'like', '%' . $search['member'] . '%')
  26. // ->orWhere('mobile', 'like', '%' . $search['member'] . '%')
  27. // ->orWhere('nickname', 'like', '%' . $search['member'] . '%');
  28. $member_list = Member::uniacid()->select(['uid', 'avatar', 'nickname', 'realname', 'mobile', 'createtime',
  29. 'credit1', 'credit2',])
  30. ->leftJoin('yz_member_del_log', 'mc_members.uid', '=', 'yz_member_del_log.member_id')
  31. ->join('yz_member', 'mc_members.uid', '=', 'yz_member.member_id')
  32. ->where('mc_members.mobile', 'like', '%' . $mobile . '%')
  33. ->get();
  34. if ($member_list->isNotEmpty()) {
  35. $member_list->map(function ($member) {
  36. $member->createtime = date('Y-m-d H:i:s', $member->createtime);
  37. return $member;
  38. });
  39. }
  40. return $this->successJson('list', $member_list);
  41. }
  42. }