93 行
3.2 KiB
PHP
可执行文件
93 行
3.2 KiB
PHP
可执行文件
<?php
|
|
|
|
namespace Common\Business;
|
|
|
|
use Common\Model\PayInfoModel;
|
|
use Common\Model\RetailVipModel;
|
|
|
|
//[1.5.22]
|
|
|
|
/**
|
|
* 支付用户信息类
|
|
* Class payUser
|
|
* [
|
|
* 支付用户列表 payUserList
|
|
* ]
|
|
* @package Common\VipInfo
|
|
*/
|
|
class PayUser
|
|
{
|
|
|
|
/**
|
|
* 支付用户列表
|
|
* @param $param
|
|
* [
|
|
* merchant_id
|
|
* vipSearchText 名称手机号
|
|
* create_coupon_type 1普通模式 2服务商模式
|
|
* create_source_type 1小程序 2线下与公众号
|
|
* page
|
|
* limit
|
|
* ]
|
|
* @return mixed
|
|
*/
|
|
public function payUserList($param)
|
|
{
|
|
if (empty($param['merchant_id']) && empty($param['create_coupon_type'])) {
|
|
return callBack(statusCode()['error'], "缺少参数");
|
|
}
|
|
$page = $param['page'] ? $param['page'] : 1;
|
|
$limit = $param['limit'] ? $param['limit'] : 10;
|
|
$where = [
|
|
'p.merchant_id' => $param['merchant_id'],
|
|
'p.m_pay_type' => $param['create_coupon_type'],
|
|
];
|
|
if (!empty($param['vipSearchText'])) {
|
|
$param['vipSearchText'] = trim($param['vipSearchText']);
|
|
$where['v.name|v.nickname|v.mobile_phone'] = ['like', "%{$param['vipSearchText']}%"];
|
|
}
|
|
if ($param['create_coupon_type'] == 1) {
|
|
switch ($param['create_source_type']){
|
|
case 1:
|
|
$where['p.type'] = 1;
|
|
break;
|
|
case 2:
|
|
$where['p.type'] = ['in',[2,3]];
|
|
break;
|
|
}
|
|
}
|
|
$fields = 'p.vip_id,p.openid,p.sub_openid,v.nickname,v.name,v.mobile_phone';
|
|
$payOrderModel = new PayInfoModel();
|
|
$list = $payOrderModel->getCouponUserList($fields, $where, $page, $limit);
|
|
if (!empty($list)) {
|
|
$count = $payOrderModel->getCouponUserCount($where);
|
|
$vipModel = new RetailVipModel();
|
|
$map['merchantid'] = $param['merchant_id'];
|
|
foreach ($list as &$val) {
|
|
if (empty($val['vip_id'])) {
|
|
switch ($param['create_coupon_type']) {
|
|
case 1:
|
|
//普通模式
|
|
$map['openid'] = $val['openid'];
|
|
break;
|
|
case 2:
|
|
//服务商
|
|
$map['openid'] = $val['sub_openid'];
|
|
break;
|
|
}
|
|
$vip = $vipModel->getFind($map, "id,mobile_phone,name,nickname");
|
|
if (!empty($vip)) {
|
|
$val['name'] = $vip['name'] ? $vip['name'] : $vip['nickname'];
|
|
$val['mobile_phone'] = $vip['mobile_phone'];
|
|
$val['vip_id'] = $vip['id'];
|
|
} else {
|
|
$val['name'] = '非会员';
|
|
}
|
|
} else {
|
|
$val['name'] = $val['name'] ? $val['name'] : $val['nickname'];
|
|
}
|
|
}
|
|
}
|
|
return callBack(statusCode()['success'], "查询成功", ['list' => $list, 'count' => $count]);
|
|
}
|
|
} |