| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485 | <?phpnamespace app\admin\controller\member;use app\admin\service\member\MemberService;use app\admin\validate\member\MemberValidate;use support\Db;use support\Request;class MemberController{    public function selectList(Request $request)    {        $keywords = $request->get('keywords');        if (!$keywords) {            return json_fail("查询错误");        }        $res = Db::table('member')            ->join('member_cert', 'member.member_id', '=', 'member_cert.join_cert_member_id')            ->select('member.member_id', 'member.member_mobile', 'member_cert.member_cert_name')            ->where('member.member_is_owner', 'N')            ->where(function ($query) use ($keywords) {                $query->where('member.member_mobile', 'like', '%' . $keywords . '%')                    ->orWhere("member.member_id", 'like', '%' . $keywords . '%')                    ->orWhere("member_cert.member_cert_name", 'like', '%' . $keywords . '%');            })->get();        $data = [];        foreach ($res as $item) {            $data[] = [                'key' => $item->member_id,                'value' => !empty($item->member_cert_name) ? $item->member_cert_name : $item->member_mobile,            ];        }        return json_success('', $data);    }    public function list(Request $request)    {        return MemberService::list($request);    }    /**     * @Desc 添加会员     * @Author Gorden     * @Date 2024/3/25 13:40     *     * @param Request $request     * @return \support\Response     */    public function add(Request $request)    {        $validate = new MemberValidate();        if (!$validate->scene('add')->check($request->post())) {            return json_fail($validate->getError());        }        return MemberService::add($request->post());    }    /**     * @Desc 绑定的设备     * @Author Gorden     * @Date 2024/4/7 10:20     *     * @param $id     * @return \support\Response     */    public function device($id)    {        return MemberService::deviceList($id);    }    public function addDevice(Request $request)    {        return MemberService::addDevice($request);    }    public function updateDevice(Request $request)    {        return MemberService::updateDevice($request);    }}
 |