514 行
19 KiB
PHP
可执行文件
514 行
19 KiB
PHP
可执行文件
<?php
|
||
|
||
namespace Common\Business;
|
||
|
||
use Common\Model\ImageGalleryModel;
|
||
use Common\Model\RetailPlusVipModel;
|
||
use Common\Model\RetailSmallProgramUserModel;
|
||
use Common\Model\RetailVipIntegralModel;
|
||
use Common\Model\RetailVipModel;
|
||
use Common\Model\StoreConfigModel;
|
||
|
||
//[1.8.71]
|
||
|
||
/**
|
||
* 小程序会员信息类
|
||
* Class VipInfo
|
||
* [
|
||
* 根据积分的获取对应的会员等级信息 singleVipGrade
|
||
* 获取单个会员的信息 singleVipInfo
|
||
* 获取所有会员等级 getGradeList
|
||
* 根据门店或会员等级获取会员信息 basisStoreGetVip
|
||
* 依据会员id查询会员信息 basisIdGetVipInfo
|
||
* 根据会员手机号查询会员信息 basisPhoneGetVip
|
||
* 小程序获取会员信息 getVipInfo
|
||
* 获取会员信息--vip表 getVipGroup
|
||
* 获取对应的会员等级名称 getVipGradeName
|
||
* ]
|
||
* @package Common\Business
|
||
*/
|
||
class VipInfo
|
||
{
|
||
/**
|
||
* 获取plus会员享受的折扣值
|
||
* @param $param
|
||
* $param['merchant_id'] 商户ID
|
||
* @return int|mixed
|
||
*/
|
||
public function getPlusDiscount($param)
|
||
{
|
||
$IntegralModel = new RetailVipIntegralModel();
|
||
$map = [
|
||
'merchantid' => $param['merchant_id'],
|
||
];
|
||
$discount = $IntegralModel->getOrderFindField($map, 'discount', 'discount asc');
|
||
return $discount ? floatval($discount) : 1;
|
||
}
|
||
|
||
/**
|
||
* 根据积分的获取对应的会员等级信息
|
||
* @param $param
|
||
* [
|
||
* merchant_id 商户ID
|
||
* grade_integral 等级积分
|
||
* grade_id 等级ID
|
||
* ]
|
||
* @return mixed
|
||
*/
|
||
public function singleVipGrade($param)
|
||
{
|
||
try {
|
||
$map = [
|
||
'merchantid' => $param['merchant_id'],
|
||
];
|
||
if ($param['grade_id']) {
|
||
$map['id'] = $param['grade_id'];
|
||
} else {
|
||
$map['min_integral'] = ['elt', $param['grade_integral']];
|
||
}
|
||
$IntegralModel = new RetailVipIntegralModel();
|
||
$grade = $IntegralModel->getOrderFind($map, 'id,cardname as grade_name,discount,min_integral,gradeimgurl as grade_img', 'min_integral desc');
|
||
if (!$param['get_default']) {
|
||
return $grade;
|
||
} else {
|
||
return $grade ? $grade : ['id' => '', 'grade_name' => '默认会员', 'discount' => '-', 'min_integral' => 0, 'grade_img' => ''];
|
||
}
|
||
} catch (\Exception $e) {
|
||
if (!$param['get_default']) {
|
||
return [];
|
||
} else {
|
||
return ['id' => '', 'grade_name' => '默认会员', 'discount' => '-', 'min_integral' => 0, 'grade_img' => ''];
|
||
}
|
||
}
|
||
}
|
||
|
||
|
||
/**
|
||
* 获取某会员的信息
|
||
* @param $param
|
||
* [
|
||
* where 查询条件
|
||
* fields 查询字段
|
||
* ]
|
||
* @return mixed
|
||
*/
|
||
public function singleVipInfo($param)
|
||
{
|
||
$param['fields'] = $param['fields'] ? $param['fields'] : '*';
|
||
try {
|
||
$VipModel = new RetailVipModel();
|
||
$info = $VipModel->getFind($param['where'], $param['fields']);
|
||
return $info;
|
||
} catch (\Exception $e) {
|
||
return [];
|
||
}
|
||
}
|
||
|
||
|
||
/**
|
||
* 获取所有会员等级
|
||
* @param $param
|
||
* [
|
||
* merchant_id
|
||
* fields
|
||
* ]
|
||
* @return mixed
|
||
*/
|
||
public function getGradeList($param)
|
||
{
|
||
$fields = $param['fields'] ? $param['fields'] : '*';
|
||
try {
|
||
$VipIntegralModel = new RetailVipIntegralModel();
|
||
$list = $VipIntegralModel->getSelect([
|
||
'merchantid' => $param['merchant_id']
|
||
], $fields, 'discount asc');
|
||
return $list;
|
||
} catch (\Exception $e) {
|
||
return [];
|
||
}
|
||
}
|
||
|
||
/**
|
||
* 获取会员等级列表
|
||
* @param $param
|
||
* $param['merchant_id'] 商户ID
|
||
* $param['integralRange'] 是否需要等级积分范围
|
||
* $param['icon'] 是否需要等级图片
|
||
* @return array
|
||
*/
|
||
public function getVipGradeList($param)
|
||
{
|
||
if (empty($param)) {
|
||
return [];
|
||
}
|
||
$VipIntegralModel = new RetailVipIntegralModel();
|
||
|
||
$fields = 'id,cardname as grade_name,discount,min_integral' . ($param['icon'] ? 'gradeimgurl_id' : '');
|
||
|
||
$list = $VipIntegralModel->getSelect(['merchantid' => $param['merchant_id']], $fields, 'min_integral asc');
|
||
|
||
if ($param['integralRange'] === true || $param['icon'] === true) {
|
||
$ImageGalleryModel = new ImageGalleryModel();
|
||
foreach ($list as $key => &$value) {
|
||
if ($param['integralRange'] === true) $value['max_integral'] = $list[$key + 1] ? bcsub($list[$key + 1]['min_integral'], 1, 0) : '';
|
||
if ($param['icon'] === true) {
|
||
$value['image'] = $ImageGalleryModel->getImagePath($value['gradeimgurl_id']);
|
||
unset($value['gradeimgurl_id']);
|
||
}
|
||
}
|
||
}
|
||
return $list ? $list : [];
|
||
}
|
||
|
||
|
||
/**
|
||
* 根据优惠券信息获取发放的会员集合
|
||
* @param $param
|
||
* [
|
||
* user_type 3商户 4门店
|
||
* merchant_id
|
||
* need_count 0不需要总数 1需要
|
||
* store_id_str 门店集合string
|
||
* grade_id_str 会员等级集合 string -1 字段v前缀
|
||
* search_info 搜索内容
|
||
* fields 查询的字段
|
||
* page
|
||
* limit
|
||
* ]
|
||
* @return mixed
|
||
*/
|
||
public function basisStoreGetVip($param)
|
||
{
|
||
$time = $_SERVER['REQUEST_TIME'];
|
||
$fields = $param['fields'];
|
||
$need_count = $param['need_count'] ? $param['need_count'] : 0;
|
||
$vip_id_arr = [];
|
||
$VipModel = new RetailVipModel();
|
||
if ($param['grade_id_str'] == '-1') {
|
||
//Plus
|
||
$where = [
|
||
'v.merchantid' => $param['merchant_id'],
|
||
'v.plus_type' => 2,
|
||
'v.status' => 1,
|
||
'p.start_time' => ['elt', $time],
|
||
'p.end_time' => ['gt', $time],
|
||
'p.state' => 1
|
||
];
|
||
if ($param['user_type'] == 4 || ($param['user_type'] == 3 && $param['store_id_str'] != '0')) {
|
||
//指定门店
|
||
$where['v.storeid'] = ['in', $param['store_id_str']];
|
||
}
|
||
if (!empty($param['search_info'])) {
|
||
$where['v.mobile_phone|v.card_key'] = ['like', '%' . $param['search_info'] . '%'];
|
||
}
|
||
try {
|
||
$vip_id_arr = $VipModel->getPlusInfo($where, $fields, $order = 'v.grade_integral desc,id desc', $param['page'], $param['limit']);
|
||
if ($need_count == 1) {
|
||
$count = $VipModel->getPlusCount($where);
|
||
}
|
||
} catch (\Exception $e) {
|
||
return callBack(statusCode()['error'], "会员查询失败", [
|
||
'vip_id_arr' => [],
|
||
'count' => 0
|
||
]);
|
||
}
|
||
} else if ($param['grade_id_str'] == '0') {
|
||
//所有
|
||
$where = [
|
||
'merchantid' => $param['merchant_id'],
|
||
'status' => 1,
|
||
];
|
||
if ($param['user_type'] == 4 || ($param['user_type'] == 3 && $param['store_id_str'] != '0')) {
|
||
//指定门店
|
||
$where['storeid'] = ['in', $param['store_id_str']];
|
||
}
|
||
if (!empty($param['search_info'])) {
|
||
$where['mobile_phone|card_key'] = ['like', '%' . $param['search_info'] . '%'];
|
||
}
|
||
try {
|
||
$vip_id_arr = $VipModel->getSelect($where, $fields, 'grade_integral desc,id desc', $param['page'] . ',' . $param['limit']);
|
||
if ($need_count == 1) {
|
||
$count = $VipModel->getCount($where);
|
||
}
|
||
} catch (\Exception $e) {
|
||
return callBack(statusCode()['error'], "会员查询失败", [
|
||
'vip_id_arr' => [],
|
||
'count' => 0
|
||
]);
|
||
}
|
||
} else {
|
||
//指定等级
|
||
$where = [
|
||
'merchantid' => $param['merchant_id'],
|
||
'status' => 1,
|
||
'plus_type' => 3
|
||
];
|
||
if ($param['user_type'] == 4 || ($param['user_type'] == 3 && $param['store_id_str'] != '0')) {
|
||
//指定门店
|
||
$where['storeid'] = ['in', $param['store_id_str']];
|
||
}
|
||
if (!empty($param['search_info'])) {
|
||
$where['mobile_phone|card_key'] = ['like', '%' . $param['search_info'] . '%'];
|
||
}
|
||
try {
|
||
$RetailVipIntegralModel = new RetailVipIntegralModel();
|
||
$grade_integral_arr = $RetailVipIntegralModel->getFindField([
|
||
'id' => ['in', $param['grade_id_str']],
|
||
'merchantid' => $param['merchant_id']
|
||
], 'min_integral', true);
|
||
// 会员
|
||
$integral_map = [];
|
||
$map = [
|
||
'merchantid' => $param['merchant_id'],
|
||
];
|
||
foreach ($grade_integral_arr as $val) { // 积分获取
|
||
$map['min_integral'] = ['gt', $val];
|
||
$min_integral = $RetailVipIntegralModel->getOrderFind($map, 'min_integral', 'min_integral asc');
|
||
if (!empty($min_integral)) {
|
||
$integral_map[] = ['between', [$val, $min_integral['min_integral'] - 1]];// 之上有积分
|
||
} else { // 之上无积分
|
||
$integral_map[] = ['egt', $val];
|
||
}
|
||
}
|
||
if (!empty($integral_map)) {
|
||
$integral_map[] = 'OR';
|
||
$where['grade_integral'] = $integral_map;
|
||
}
|
||
$vip_id_arr = $VipModel->getSelect($where, $fields, 'grade_integral desc,id desc', $param['page'] . ',' . $param['limit']);
|
||
if ($need_count == 1) {
|
||
$count = $VipModel->getCount($where);
|
||
}
|
||
} catch (\Exception $e) {
|
||
return callBack(statusCode()['error'], "会员查询失败", [
|
||
'vip_id_arr' => [],
|
||
'count' => 0
|
||
]);
|
||
}
|
||
}
|
||
return callBack(statusCode()['success'], "获取成功", [
|
||
'vip_id_arr' => $vip_id_arr,
|
||
'count' => $count ? $count : 0
|
||
]);
|
||
}
|
||
|
||
|
||
/**
|
||
* 依据会员id查询会员信息
|
||
* @param $param
|
||
* [
|
||
* merchant_id
|
||
* vip_id
|
||
* status 会员状态；默认1为正常；1：正常会员，2：删除会员 3冻结 4挂失
|
||
* ]
|
||
* @return mixed
|
||
*/
|
||
public function basisIdGetVipInfo($param)
|
||
{
|
||
try {
|
||
$VipModel = new RetailVipModel();
|
||
$info = $VipModel->getFind([
|
||
'merchantid' => $param['merchant_id'],
|
||
'id' => $param['vip_id'],
|
||
'status' => $param['status']
|
||
]);
|
||
if (!empty($info)) {
|
||
return callBack(statusCode()['success'], "会员查询成功", $info);
|
||
} else {
|
||
return callBack(statusCode()['error'], "会员查询失败");
|
||
}
|
||
} catch (\Exception $e) {
|
||
return callBack(statusCode()['error'], "会员查询失败");
|
||
}
|
||
}
|
||
|
||
|
||
/**
|
||
* 根据会员手机号查询会员信息
|
||
* @param $param
|
||
* [
|
||
* merchant_id
|
||
* mobile_phone 手机号
|
||
* ]
|
||
* @return mixed
|
||
*/
|
||
public function basisPhoneGetVip($param)
|
||
{
|
||
if (empty($param['merchant_id']) || empty($param['mobile_phone'])) {
|
||
return callBack(statusCode()['error'], "缺少参数");
|
||
}
|
||
try {
|
||
$VipModel = new RetailVipModel();
|
||
$vipInfo = $VipModel->getFind([
|
||
'merchantid' => $param['merchant_id'],
|
||
'mobile_phone' => $param['mobile_phone'],
|
||
'status' => ['neq', 2]
|
||
]);
|
||
if (empty($vipInfo)) {
|
||
return callBack(statusCode()['error'], '未找到该会员');
|
||
} else {
|
||
return callBack(statusCode()['success'], '查询成功', $vipInfo);
|
||
}
|
||
} catch (\Exception $e) {
|
||
return callBack(statusCode()['error'], '未找到该会员');
|
||
}
|
||
}
|
||
|
||
|
||
/**
|
||
* 小程序获取会员信息
|
||
* @param $param
|
||
* [
|
||
* merchant_id
|
||
* user 小程序用户信息
|
||
* ]
|
||
* @return bool
|
||
*/
|
||
public function getVipInfo($param)
|
||
{
|
||
$VipModel = new RetailVipModel();
|
||
$VipIntegralModel = new RetailVipIntegralModel();
|
||
$SmallProgramUserModel = new RetailSmallProgramUserModel();
|
||
$PlusVipModel = new RetailPlusVipModel();
|
||
$user = $param['user'];
|
||
if ($user['user_type'] == 2 || $user['user_type'] == 3) {
|
||
$map = array(
|
||
$VipIntegralModel::MERCHANT_ID => $param['merchant_id'],
|
||
$VipIntegralModel::DISCOUNT => array('gt', 0)
|
||
);
|
||
$vMap = array(
|
||
$VipModel::ID => $user[$SmallProgramUserModel::VID],
|
||
$VipModel::STATUS => 1
|
||
);
|
||
try {
|
||
$vip = $VipModel->getFind($vMap);
|
||
//PLUS共计优惠金额
|
||
$plus_data = $PlusVipModel->getOrderFind(array('vip_id' => $vip['id']), 'total_less_money,state,end_time');
|
||
if (!empty($vip)) {
|
||
if ($user['user_type'] == 2) {
|
||
//plus会员
|
||
$grade = $VipIntegralModel->getOrderFind($map, '*', $VipIntegralModel::DISCOUNT . ' asc');
|
||
$vipInfo['grade_name'] = 'PLUS会员';
|
||
} else {
|
||
//常规会员
|
||
$map[$VipIntegralModel::MIN_INTEGRAL] = array('ELT', $vip[$VipModel::GRADE_INTEGRAL]);
|
||
$grade = $VipIntegralModel->getOrderFind($map, '*', $VipIntegralModel::MIN_INTEGRAL . ' desc');
|
||
$vipInfo['grade_name'] = $grade[$VipIntegralModel::CARD_NAME];
|
||
}
|
||
$next_grade = $VipIntegralModel->getVipNextGradeInfo($param['merchant_id'], $vip['grade_integral']);
|
||
} else {
|
||
$user['user_type'] = 1;
|
||
$grade = array();
|
||
}
|
||
} catch (\Exception $e) {
|
||
$user['user_type'] = 1;
|
||
$grade = array();
|
||
}
|
||
} else {
|
||
$grade = array();
|
||
}
|
||
$vipInfo = false;
|
||
if ($user['user_type'] != 1) {
|
||
$vipInfo['user_type'] = $user['user_type'];
|
||
$vipInfo['integral'] = $vip[$VipModel::INTEGRAL] ? $vip[$VipModel::INTEGRAL] : 0;
|
||
$vipInfo['discount'] = ($grade[$VipIntegralModel::DISCOUNT] > 0 && $grade[$VipIntegralModel::DISCOUNT] < 1) ? $grade[$VipIntegralModel::DISCOUNT] : 1;
|
||
$vipInfo['vid'] = $vip[$VipModel::ID] ? $vip[$VipModel::ID] : 0;
|
||
$vipInfo['balance'] = $vip[$VipModel::BALANCE] ? $vip[$VipModel::BALANCE] : 0;
|
||
$vipInfo['card_num'] = $vip[$VipModel::MOBILE_PHONE] ? $vip[$VipModel::MOBILE_PHONE] : $vip[$VipModel::CARD_KEY];
|
||
$vipInfo['nickname'] = $vip[$VipModel::NICK_NAME] ? $vip[$VipModel::NICK_NAME] : $user[$SmallProgramUserModel::NICKNAME];
|
||
$vipInfo['avatar'] = $vip[$VipModel::AVATAR] ? $vip[$VipModel::AVATAR] : $user[$SmallProgramUserModel::AVATAR];
|
||
$vipInfo['password'] = $vip[$VipModel::PASSWORD];
|
||
$vipInfo['add_time'] = $vip[$VipModel::ADD_TIME];
|
||
$vipInfo['plus_id'] = $vip[$VipModel::PLUS_ID];
|
||
$vipInfo['grade_integral'] = $vip[$VipModel::GRADE_INTEGRAL];
|
||
$vipInfo['next_grade_integral'] = empty($next_grade['min_integral']) ? $grade['min_integral'] : $next_grade['min_integral'];
|
||
$vipInfo['total_less_money'] = empty($plus_data['total_less_money']) ? 0 : $plus_data['total_less_money'];
|
||
$vipInfo['plus_end_time'] = date('Y-m-d', $plus_data['end_time']);
|
||
$vipInfo['plus_state'] = $plus_data['state'];
|
||
}
|
||
return $vipInfo;
|
||
}
|
||
|
||
|
||
/**
|
||
* 获取会员信息--vip表
|
||
* @param $param
|
||
* [
|
||
* merchant_id
|
||
* store_id
|
||
* search
|
||
* field
|
||
* page
|
||
* limit
|
||
* desc
|
||
* ]
|
||
* @return array
|
||
*/
|
||
public function getVipGroup($param)
|
||
{
|
||
if (!$param['merchant_id'] || !$param['store_id']) {
|
||
return ['status' => 0, 'msg' => '必要参数缺失!'];
|
||
}
|
||
|
||
$where = [
|
||
'merchantid' => $param['merchant_id'],
|
||
// 'storeid' => $param['store_id'],
|
||
'status' => 1,
|
||
'id' => ['exp', "NOT IN (select ifnull (vid,0) from `ls_retail_creditor` where store_id = " . $param['store_id'] . " and status = 1)"],
|
||
];
|
||
|
||
if ($param['search']) {
|
||
$where['nickname|name|mobile_phone'] = ['like', "%{$param['search']}%"];
|
||
}
|
||
|
||
$field = $param['field'] ? $param['field'] : 'id, mobile_phone, nickname, name, headimgurl as avatar';
|
||
$page = $param['page'] ? $param['page'] : 1;
|
||
$limit = $param['limit'] ? $param['limit'] : 10;
|
||
$desc = $param['desc'] ? $param['desc'] : 'id desc';
|
||
|
||
$RetailVipModel = new RetailVipModel();
|
||
$StoreConfigModel = new StoreConfigModel();
|
||
|
||
$list = $RetailVipModel->getVipXcxUserLink($where, $field, $desc, $page, $limit);
|
||
|
||
$storeSetQuota = $StoreConfigModel->getFindField(['store_id' => $param['store_id']], 'credit_quota');
|
||
if ($list['list']) {
|
||
foreach ($list['list'] as &$val) {
|
||
$val['quota'] = $storeSetQuota ? $storeSetQuota : '0';
|
||
if (empty($val['nickname'])) {
|
||
$val['nickname'] = '-';
|
||
}
|
||
if (empty($val['avatar'])) {
|
||
$val['avatar'] = '-';
|
||
}
|
||
if (empty($val['name'])) {
|
||
$val['name'] = '-';
|
||
}
|
||
$val['displayName'] = $val['nickname'] . '|' . $val['name'];
|
||
if (empty($val['mobile_phone'])) {
|
||
$val['mobile_phone'] = '-';
|
||
}
|
||
}
|
||
return ['status' => 1, 'msg' => '查询成功!', 'data' => ['list' => $list['list'], 'total' => $list['count']]];
|
||
}
|
||
return ['status' => 0, 'msg' => '暂无数据!'];
|
||
}
|
||
|
||
/**
|
||
* 获取对应的会员等级名称
|
||
* @param $param
|
||
* $param['merchant_id'] 商户ID
|
||
* $param['grade_integral'] 等级积分
|
||
* @return mixed|string
|
||
*/
|
||
public function getVipGradeName($param)
|
||
{
|
||
$IntegralModel = new RetailVipIntegralModel();
|
||
$map = [
|
||
'min_integral' => ['elt', $param['grade_integral']],
|
||
'merchantid' => $param['merchant_id'],
|
||
];
|
||
$grade_name = $IntegralModel->getOrderFindField($map, 'cardname', 'min_integral desc');
|
||
return $grade_name ? $grade_name : '默认会员';
|
||
}
|
||
}
|