params[ 'page' ] ?? 1; $page_size = $this->params[ 'page_size' ] ?? PAGE_LIST_ROWS; $search_text = $this->params[ 'search_text' ] ?? ''; $store_id = $this->params['store_id'] ?? ''; $condition = [ [ 'site_id', '=', $this->site_id ], [ 'is_delete', '=', 0 ], [ 'store_id', 'in', [$store_id,0]] ]; if (!empty($search_text)) $condition[] = [ 'mobile|nickname', 'like', "%" . $search_text . "%" ]; $member = new MemberModel(); $field = 'member_id,mobile,nickname,headimg,email,status,headimg,member_level,member_level_name,member_label,member_label_name,login_ip,login_type,last_login_ip,last_visit_time,last_login_time,sex,point,balance,growth,balance_money,is_member,order_money,order_complete_money,order_num,order_complete_num'; $list = $member->getMemberPageList($condition, $page_index, $page_size, 'member_id desc', $field); return $this->response($list); } /* * 会员信息 */ public function info() { $member_id = $this->params[ 'member_id' ] ?? 0; if (empty($member_id)) return $this->response($this->error()); $condition = [ [ 'member_id', '=', $member_id ] ]; $member = new \app\model\member\Member(); $data = $member->getMemberInfo($condition); $coupon_model = new MemberCoupon(); $coupon_num = $coupon_model->getMemberCouponNum($member_id, 1, $this->site_id)[ 'data' ]; $data[ 'data' ][ 'coupon_num' ] = $coupon_num; $data[ 'data' ][ 'card_num' ] = ( new MemberCard() )->getCardCount([ [ 'mgc.member_id', '=', $member_id ], [ 'mgc.status', '=', 1 ], [ 'g.is_delete', '=', 0 ] ], 'card_id', 'mgc', [ [ 'goods g', 'g.goods_id = mgc.goods_id', 'inner' ] ])[ 'data' ]; return $this->response($data); } public function searchMember() { $search_text = isset($this->params[ 'search_text' ]) ? $this->params[ 'search_text' ] : ''; $search_type = isset($this->params[ 'search_type' ]) ? $this->params[ 'search_type' ] : ''; if ($search_type == 'mobile' || $search_type == 'nickname' || $search_type == 'member_code') { } else { $search_type = 'username|nickname|mobile|member_code'; } $condition = [ [ $search_type, '=', $search_text ], [ 'is_delete', '=', 0 ] ]; $member = new \app\model\member\Member(); $data = $member->getMemberInfo($condition); return $this->response($data); } public function addMember() { $data = [ 'site_id' => $this->site_id, 'username' => '', 'mobile' => $this->params[ 'mobile' ] ?? '', 'email' => '', 'status' => 1, 'headimg' => '', 'member_level' => $this->params[ 'member_level' ] ?? 0, 'member_level_name' => $this->params[ 'member_level_name' ] ?? '', 'nickname' => $this->params[ 'nickname' ], 'sex' => $this->params[ 'sex' ] ?? 0, 'birthday' => $this->params[ 'sex' ] ? strtotime($this->params[ 'sex' ]) : 0, 'realname' => $this->params[ 'realname' ] ?? '', 'reg_time' => time(), ]; if (empty($data[ 'mobile' ])) return $this->response($this->error('', '手机号不能为空')); if (empty($data[ 'nickname' ])) return $this->response($this->error('', '会员名称不能为空')); //$data[ 'nickname' ] = $data[ 'mobile' ]; $member_model = new MemberModel(); $add_res = $member_model->addMember($data); if ($add_res[ 'code' ] != 0) return $this->response($add_res); $res = ( new StoreMember() )->addStoreMember($this->store_id, $add_res[ 'data' ]); $this->addLog("添加会员" . $data[ 'username' ] . $data[ 'mobile' ]); return $this->response($add_res); } /** * 会员优惠券 * @return false|string */ public function coupon() { $member_id = $this->params[ 'member_id' ] ?? 0; $page = $this->params[ 'page' ] ?? 1; $page_size = $this->params[ 'page_size' ] ?? PAGE_LIST_ROWS; $state = $this->params[ 'state' ] ?? 1; $condition = [ [ 'npc.member_id', '=', $member_id ], [ 'npc.state', '=', $state ] ]; $coupon_model = new CouponModel(); $list = $coupon_model->getMemberCouponPageList($condition, $page, $page_size); return $this->response($list); } /** * 会员编辑 */ public function editMember() { $data = []; if (isset($this->params[ 'headimg' ])) $data[ 'headimg' ] = $this->params[ 'headimg' ]; if (isset($this->params[ 'nickname' ])) $data[ 'nickname' ] = $this->params[ 'nickname' ]; if (isset($this->params[ 'mobile' ])) $data[ 'mobile' ] = $this->params[ 'mobile' ]; if (isset($this->params[ 'level_id' ]) && !empty($this->params[ 'level_id' ])) $data[ 'member_level' ] = $this->params[ 'level_id' ]; if (isset($this->params[ 'level_id' ]) && !empty($this->params[ 'level_id' ])) { $member_level_model = new MemberLevelModel(); $condition = [ [ 'site_id', '=', $this->site_id ], [ 'level_id', '=', $this->params[ 'level_id' ] ], [ 'status', '=', 1 ] ]; $member_level = $member_level_model->getFirstMemberLevel($condition); $data[ 'member_level_name' ] = $member_level[ 'data' ][ 'level_name' ]; } if (isset($this->params[ 'label_id' ]) && !empty($this->params[ 'label_id' ])) $data[ 'member_label' ] = $this->params[ 'label_id' ]; if (isset($this->params[ 'label_id' ]) && !empty($this->params[ 'label_id' ])) { $member_label_model = new MemberLabelModel(); $member_label = $member_label_model->getMemberLabelInfo([ [ 'label_id', '=', $this->params[ 'label_id' ] ] ]); $data[ 'member_label_name' ] = $member_label[ 'data' ][ 'label_name' ]; } if (isset($this->params[ 'sex' ])) $data[ 'sex' ] = $this->params[ 'sex' ]; if (isset($this->params[ 'birthday' ])) $data[ 'birthday' ] = $this->params[ 'birthday' ] ? strtotime($this->params[ 'birthday' ]) : 0; $member_id = $this->params[ 'member_id' ]; $member_model = new MemberModel(); $this->addLog("编辑会员:id" . $member_id, $data); $info = $member_model->editMember($data, [ [ 'member_id', '=', $member_id ], [ 'site_id', '=', $this->site_id ] ]); return $this->response($info); } /** * 账户流水 * @return false|string */ public function memberAccountList() { $member_id = isset($this->params[ 'member_id' ]) ? $this->params[ 'member_id' ] : 0; $page_index = isset($this->params[ 'page' ]) && !empty($this->params[ 'page_size' ]) ? $this->params[ 'page' ] : 1; $page_size = isset($this->params[ 'page_size' ]) && !empty($this->params[ 'page_size' ]) ? $this->params[ 'page_size' ] : PAGE_LIST_ROWS; $account_type = isset($this->params[ 'account_type' ]) ? $this->params[ 'account_type' ] : ''; if (!empty($account_type)) { if (!in_array($account_type, [ 'point', 'growth', 'balance', 'balance_money' ])) { return $this->response($this->error('', 'INVALID_PARAMETER')); } } $memberAcc = new MemberAccountModel(); $condition = [ [ 'member_id', '=', $member_id ], [ 'site_id', '=', $this->site_id ] ]; if (!empty($account_type)) { $condition[] = [ 'account_type', '=', $account_type ]; } $field = 'id,member_id,account_type,account_data,from_type,type_name,type_tag,remark,create_time,username,mobile,email'; $data = $memberAcc->getMemberAccountPageList($condition, $page_index, $page_size, 'create_time desc', $field); if (!empty($data[ 'data' ][ 'list' ])) { $account_type = $memberAcc->getAccountType(); $data[ 'data' ][ 'list' ] = array_map(function($item) use ($account_type) { $item[ 'account_type_name' ] = $account_type[ $item[ 'account_type' ] ]; return $item; }, $data[ 'data' ][ 'list' ]); } return $this->response($data); } /** * 加入移除黑名单 * @return false|string */ public function joinBlacklist() { $member_id = input('member_id', 0); $status = input('status', 0); $condition = [ [ 'member_id', '=', $member_id ], [ 'site_id', '=', $this->site_id ] ]; $member_model = new MemberModel(); $info = $member_model->modifyMemberStatus($status, $condition); return $this->response($info); } /** * 获取会员订单列表 */ public function orderList() { $search_text = isset($this->params[ 'search_text' ]) ? $this->params[ 'search_text' ] : ''; $member_id = isset($this->params[ 'member_id' ]) ? $this->params[ 'member_id' ] : 0; $page_index = isset($this->params[ 'page' ]) ? $this->params[ 'page' ] : 1; $page_size = isset($this->params[ 'page_size' ]) ? $this->params[ 'page_size' ] : PAGE_LIST_ROWS; if (!empty($search_text)) { $condition[] = [ 'order_no', 'like', '%' . $search_text . '%' ]; } $condition[] = [ 'member_id', '=', $member_id ]; $condition[] = [ 'site_id', '=', $this->site_id ]; $field = 'order_id,order_no,order_name,order_type,order_money,pay_money,balance_money,order_type_name,order_status_name,delivery_status_name,create_time'; $order = new OrderCommon(); $list = $order->getMemberOrderPageList($condition, $page_index, $page_size, 'order_id desc', $field); return $this->response($list); } /** * 重置密码 */ public function modifyMemberPassword() { $password = isset($this->params[ 'password' ]) ? $this->params[ 'password' ] : '123456'; $member_id = isset($this->params[ 'member_id' ]) ? $this->params[ 'member_id' ] : 0; $member_model = new MemberModel(); $info = $member_model->resetMemberPassword($password, [ [ 'member_id', '=', $member_id ], [ 'site_id', '=', $this->site_id ] ]); return $this->response($info); } /** * 调整余额 */ public function modifyBalance() { $member_id = isset($this->params[ 'member_id' ]) ? $this->params[ 'member_id' ] : 0; $adjust_num = isset($this->params[ 'adjust_num' ]) ? $this->params[ 'adjust_num' ] : 0; $remark = isset($this->params[ 'remark' ]) ? $this->params[ 'remark' ] : '商家调整'; $this->addLog("会员余额调整id:" . $member_id . "金额" . $adjust_num); $member_account_model = new MemberAccountModel(); $info = $member_account_model->addMemberAccount($this->site_id, $member_id, 'balance', $adjust_num, 'adjust', 0, $remark); return $this->response($info); } /** * 余额调整(可提现) */ public function modifyBalanceMoney() { return $this->response($this->error()); $member_id = isset($this->params[ 'member_id' ]) ? $this->params[ 'member_id' ] : 0; $adjust_num = isset($this->params[ 'adjust_num' ]) ? $this->params[ 'adjust_num' ] : 0; $remark = isset($this->params[ 'remark' ]) ? $this->params[ 'remark' ] : '商家调整'; $this->addLog("会员余额调整id:" . $member_id . "金额" . $adjust_num); $member_account_model = new MemberAccountModel(); $info = $member_account_model->addMemberAccount($this->site_id, $member_id, 'balance_money', $adjust_num, 'adjust', 0, $remark); return $this->response($info); } /** * 积分调整 */ public function modifyPoint() { $member_id = isset($this->params[ 'member_id' ]) ? $this->params[ 'member_id' ] : 0; $adjust_num = isset($this->params[ 'adjust_num' ]) ? $this->params[ 'adjust_num' ] : 0; $remark = isset($this->params[ 'remark' ]) ? $this->params[ 'remark' ] : '商家调整'; $this->addLog("会员积分调整id:" . $member_id . "数量" . $adjust_num); $member_account_model = new MemberAccountModel(); $info = $member_account_model->addMemberAccount($this->site_id, $member_id, 'point', $adjust_num, 'adjust', 0, $remark); return $this->response($info); } /** * 成长值调整 */ public function modifyGrowth() { $member_id = isset($this->params[ 'member_id' ]) ? $this->params[ 'member_id' ] : 0; $adjust_num = isset($this->params[ 'adjust_num' ]) ? $this->params[ 'adjust_num' ] : 0; $remark = isset($this->params[ 'remark' ]) ? $this->params[ 'remark' ] : '商家调整'; $this->addLog("会员成长值调整id:" . $member_id . "数量" . $adjust_num); $member_account_model = new MemberAccountModel(); $info = $member_account_model->addMemberAccount($this->site_id, $member_id, 'growth', $adjust_num, 'adjust', 0, $remark); return $this->response($info); } /** * 发放优惠券 * @return false|string */ public function sendCoupon() { $member_id = $this->params[ 'member_id' ] ?? 0; $coupon_data = json_decode(input('coupon_data', '[]'), true); // [{coupon_type_id: **, num: **}] if (empty($coupon_data)) { return $this->response($this->error('', '要发放的优惠券不能为空')); } $res = ( new CouponModel() )->giveCoupon($coupon_data, $this->site_id, $member_id, 4); return $this->response($res); } /** * 办理会员 * @return false|string */ public function handleMember() { $member_id = $this->params[ 'member_id' ] ?? 0; $level_id = $this->params[ 'level_id' ] ?? 0; $member_code = $this->params[ 'member_code' ] ?? ''; $member_model = new MemberModel(); $res = $member_model->handleMember([ 'member_id' => $member_id, 'level_id' => $level_id, 'member_code' => $member_code, 'site_id' => $this->site_id ]); return $this->response($res); } /** * 会员验证 验证码 * @return false|string * @throws \Exception */ public function memberVerifyCode() { $member_id = $this->params[ 'member_id' ] ?? 0; $member_model = new MemberModel(); $member_info = $member_model->getMemberInfo([ ['site_id', '=', $this->site_id], ['member_id', '=', $member_id] ], 'mobile')['data']; if (empty($member_info)) return $this->response($this->error('', '未获取到会员信息')); if (empty($member_info['mobile'])) return $this->response($this->error('', '会员未绑定手机号')); $code = str_pad(random_int(1, 9999), 4, 0, STR_PAD_LEFT);// 生成4位随机数,左侧补0 $message_model = new Message(); $res = $message_model->sendMessage([ 'type' => 'code', 'mobile' => $member_info['mobile'], "site_id" => $this->site_id, "code" => $code, "support_type" => [ "sms" ], "keywords" => "CASHIER_MEMBER_VERIFY_CODE" ]); if ($res[ "code" ] >= 0) { //将验证码存入缓存 $key = 'cashier_member_verify' . md5(uniqid(null, true)); Cache::tag("bind_mobile_code")->set($key, [ 'code' => $code ], 600); return $this->response($this->success([ "key" => $key ])); } else { return $this->response($res); } } /** * 验证短信验证码 * @return false|string */ public function checkSmsCode(){ $key = $this->params[ 'key' ] ?? ''; $code = $this->params[ 'code' ] ?? ''; $verify_data = Cache::get($key); if ($verify_data[ "code" ] == $this->params[ "code" ]) { return $this->response($this->success()); } else { return $this->response($this->error("", "验证码不正确")); } } /** * 验证付款码 */ public function checkPaymentCode(){ $code = $this->params[ 'code' ] ?? ''; $member_id = $this->params[ 'member_id' ] ?? 0; $res = (new PayBalance())->checkPaymentCode($code, $member_id); return $this->response($res); } }