mirror of
https://github.com/crmeb/CRMEB.git
synced 2026-10-28 21:40:50 +00:00
d50837b663
移除佣金/提现控制器与前端页面，订单与用户链路去掉分销佣金逻辑，安装 SQL 与文档同步。 Co-authored-by: Cursor <cursoragent@cursor.com>
957 lines
34 KiB
PHP
957 lines
34 KiB
PHP
<?php
|
||
// +----------------------------------------------------------------------
|
||
// | CRMEB [ CRMEB赋能开发者，助力企业发展 ]
|
||
// +----------------------------------------------------------------------
|
||
// | Copyright (c) 2016~2026 https://www.crmeb.com All rights reserved.
|
||
// +----------------------------------------------------------------------
|
||
// | Licensed CRMEB并不是自由软件，未经许可不能去掉CRMEB相关版权
|
||
// +----------------------------------------------------------------------
|
||
// | Author: CRMEB Team <admin@crmeb.com>
|
||
// +----------------------------------------------------------------------
|
||
declare (strict_types=1);
|
||
|
||
namespace app\services\user;
|
||
|
||
use crmeb\basic\BaseService;
|
||
use app\dao\user\UserBillDao;
|
||
use crmeb\exceptions\AdminException;
|
||
use crmeb\exceptions\ApiException;
|
||
use crmeb\services\CacheService;
|
||
use think\facade\Log;
|
||
|
||
/**
|
||
* 用户积分记录服务
|
||
* Class UserBillServices
|
||
* @package app\services\user
|
||
* @method takeUpdate(int $uid, int $id) 修改收货状态
|
||
* @method sum(array $where, string $field) 求和
|
||
* @method count(array $where) 求条数
|
||
* @method getTotalSum(array $where) 计算某个条件下订单内商品总数
|
||
* @method getBillSum(array $where) 获取某个条件总数
|
||
* @method getList(array $where, string $field, int $page, int $limit, $typeWhere = [], $order = 'id desc') 获取某个条件总数
|
||
* @method getUserRefundPriceList(array $time, string $timeType, string $str, string $field = 'add_time', array $with = []) 获取退款金额按照时间分组
|
||
*/
|
||
class UserBillServices extends BaseService
|
||
{
|
||
/**
|
||
* @var UserBillDao
|
||
*/
|
||
protected $dao;
|
||
const TYPE_INTEGRAL = 'integral';//积分
|
||
const TYPE_EXP = 'exp';//经验
|
||
const TYPE_MONEY = 'now_money';//余额 单独表停用
|
||
const TYPE_BROAGE = 'brokerage';//推广佣金 单独表停用
|
||
|
||
/**
|
||
* 积分流水配置
|
||
* @var array[]
|
||
*/
|
||
protected $integralIncomeData = [
|
||
'sign' => [
|
||
'title' => '签到奖励积分',
|
||
'category' => self::TYPE_INTEGRAL,
|
||
'type' => 'sign',
|
||
'mark' => '签到奖励{%num%}积分',
|
||
'status' => 1,
|
||
'pm' => 1
|
||
],
|
||
'register_system_add' => [
|
||
'title' => '注册送积分',
|
||
'category' => self::TYPE_INTEGRAL,
|
||
'type' => 'register_system_add',
|
||
'mark' => '注册送{%num%}积分',
|
||
'status' => 1,
|
||
'pm' => 1
|
||
],
|
||
'pay_give_integral' => [
|
||
'title' => '购买商品赠送积分',
|
||
'category' => self::TYPE_INTEGRAL,
|
||
'type' => 'product_gain',
|
||
'mark' => '购买商品赠送{%num%}积分',
|
||
'status' => 1,
|
||
'pm' => 1
|
||
],
|
||
'order_give_integral' => [
|
||
'title' => '下单赠送积分',
|
||
'category' => self::TYPE_INTEGRAL,
|
||
'type' => 'gain',
|
||
'mark' => '下单赠送{%num%}积分',
|
||
'status' => 1,
|
||
'pm' => 1
|
||
],
|
||
'integral_refund' => [
|
||
'title' => '扣除订单下单赠送积分',
|
||
'category' => self::TYPE_INTEGRAL,
|
||
'type' => 'order_deduction',
|
||
'mark' => '购买商品失败,回退赠送积分{%num%}',
|
||
'status' => 1,
|
||
'pm' => 0
|
||
],
|
||
'order_integral_refund' => [
|
||
'title' => '返还下单使用积分',
|
||
'category' => self::TYPE_INTEGRAL,
|
||
'type' => 'integral_refund',
|
||
'mark' => '购买商品失败,回退积分{%num%}',
|
||
'status' => 1,
|
||
'pm' => 1
|
||
],
|
||
'order_gain_refund' => [
|
||
'title' => '退款返还下单赠送积分',
|
||
'category' => self::TYPE_INTEGRAL,
|
||
'type' => 'order_gain_refund',
|
||
'mark' => '订单退款,返还下单赠送积分{%num%}',
|
||
'status' => 1,
|
||
'pm' => 0
|
||
],
|
||
'product_gain_refund' => [
|
||
'title' => '退款返还购买商品赠送积分',
|
||
'category' => self::TYPE_INTEGRAL,
|
||
'type' => 'product_gain_refund',
|
||
'mark' => '订单退款,返还购买商品赠送积分{%num%}',
|
||
'status' => 1,
|
||
'pm' => 0
|
||
],
|
||
'pay_product_integral_back' => [
|
||
'title' => '商品退积分',
|
||
'category' => self::TYPE_INTEGRAL,
|
||
'type' => 'pay_product_integral_back',
|
||
'mark' => '订单退积分{%num%}积分到用户积分',
|
||
'status' => 1,
|
||
'pm' => 1
|
||
],
|
||
'deduction' => [
|
||
'title' => '积分抵扣',
|
||
'category' => self::TYPE_INTEGRAL,
|
||
'type' => 'deduction',
|
||
'mark' => '购买商品使用{%number%}积分抵扣{%deductionPrice%}元',
|
||
'status' => 1,
|
||
'pm' => 0
|
||
],
|
||
'lottery_use_integral' => [
|
||
'title' => '参与抽奖使用积分',
|
||
'category' => self::TYPE_INTEGRAL,
|
||
'type' => 'lottery_use',
|
||
'mark' => '参与抽奖使用{%num%}积分',
|
||
'status' => 1,
|
||
'pm' => 0
|
||
],
|
||
'lottery_give_integral' => [
|
||
'title' => '抽奖中奖赠送积分',
|
||
'category' => self::TYPE_INTEGRAL,
|
||
'type' => 'lottery_add',
|
||
'mark' => '抽奖中奖赠送{%num%}积分',
|
||
'status' => 1,
|
||
'pm' => 1
|
||
],
|
||
'storeIntegral_use_integral' => [
|
||
'title' => '积分兑换商品',
|
||
'category' => self::TYPE_INTEGRAL,
|
||
'type' => 'storeIntegral_use',
|
||
'mark' => '积分商城兑换商品使用{%num%}积分',
|
||
'status' => 1,
|
||
'pm' => 0
|
||
],
|
||
'system_add' => [
|
||
'title' => '系统增加积分',
|
||
'category' => self::TYPE_INTEGRAL,
|
||
'type' => 'system_add',
|
||
'mark' => '系统增加{%num%}积分',
|
||
'status' => 1,
|
||
'pm' => 1
|
||
],
|
||
'system_sub' => [
|
||
'title' => '系统减少积分',
|
||
'category' => self::TYPE_INTEGRAL,
|
||
'type' => 'system_sub',
|
||
'mark' => '系统扣除{%num%}积分',
|
||
'status' => 1,
|
||
'pm' => 0
|
||
],
|
||
];
|
||
|
||
/**
|
||
* 经验流水配置
|
||
* @var array[]
|
||
*/
|
||
protected $expIncomeData = [
|
||
'sign_exp' => [
|
||
'title' => '签到奖励经验',
|
||
'category' => self::TYPE_EXP,
|
||
'type' => 'sign_exp',
|
||
'mark' => '签到奖励{%num%}经验',
|
||
'status' => 1,
|
||
'pm' => 1
|
||
],
|
||
'order_give_exp' => [
|
||
'title' => '下单赠送经验',
|
||
'category' => self::TYPE_EXP,
|
||
'type' => 'gain',
|
||
'mark' => '下单赠送{%num%}经验',
|
||
'status' => 1,
|
||
'pm' => 1
|
||
],
|
||
'invite_user_exp' => [
|
||
'title' => '邀新奖励经验',
|
||
'category' => self::TYPE_EXP,
|
||
'type' => 'invite_user',
|
||
'mark' => '邀请好友奖励{%num%}经验',
|
||
'status' => 1,
|
||
'pm' => 1
|
||
],
|
||
'system_add_exp' => [
|
||
'title' => '系统增加经验',
|
||
'category' => self::TYPE_EXP,
|
||
'type' => 'system_add_exp',
|
||
'mark' => '系统增加{%num%}经验',
|
||
'status' => 1,
|
||
'pm' => 1
|
||
],
|
||
'system_sub_exp' => [
|
||
'title' => '系统减少经验',
|
||
'category' => self::TYPE_EXP,
|
||
'type' => 'system_sub_exp',
|
||
'mark' => '系统减少{%num%}经验',
|
||
'status' => 1,
|
||
'pm' => 0
|
||
],
|
||
];
|
||
|
||
/**
|
||
* UserBillServices constructor.
|
||
* @param UserBillDao $dao
|
||
*/
|
||
public function __construct(UserBillDao $dao)
|
||
{
|
||
$this->dao = $dao;
|
||
}
|
||
|
||
/**
|
||
* 事务性修改用户积分并记录流水
|
||
*
|
||
* @param string $billType 流水类型（参考 integralIncomeData 配置）
|
||
* @param int $uid 用户ID
|
||
* @param int|string|array $integral 变动数量（支持数组用于多参数替换）
|
||
* @param int $link_id 关联ID（如订单ID）
|
||
* @param string $mark 自定义备注
|
||
* @return bool|mixed
|
||
*/
|
||
public function billIntegralIncome(string $billType, int $uid, $integral, $link_id, string $mark = '')
|
||
{
|
||
$data = $this->integralIncomeData[$billType] ?? null;
|
||
|
||
if (!$data) {
|
||
return true;
|
||
}
|
||
|
||
/** @var UserServices $userServices */
|
||
$userServices = app()->make(UserServices::class);
|
||
|
||
return $this->transaction(function () use (
|
||
$uid, $billType, $integral, $link_id, $mark, $data, $userServices
|
||
) {
|
||
$userInfo = $userServices->get($uid, ['integral']);
|
||
if (!$userInfo) {
|
||
throw new ApiException('用户不存在');
|
||
}
|
||
|
||
$data['type'] = $billType;
|
||
$data['category'] = self::TYPE_INTEGRAL;
|
||
$data['status'] = 1;
|
||
$data['take'] = 0;
|
||
$data['uid'] = $uid;
|
||
$data['link_id'] = $link_id;
|
||
|
||
if (is_array($integral)) {
|
||
$key = array_keys($integral);
|
||
$key = array_map(function ($item) {
|
||
return '{%' . $item . '%}';
|
||
}, $key);
|
||
$value = array_map('strval', array_values($integral));
|
||
$data['number'] = $integral['number'] ?? 0;
|
||
$data['mark'] = $mark === '' ? str_replace($key, $value, $data['mark']) : $mark;
|
||
} else {
|
||
$data['number'] = $integral;
|
||
$data['mark'] = $mark === '' ? str_replace(['{%num%}'], (string)$integral, $data['mark']) : $mark;
|
||
}
|
||
|
||
$data['add_time'] = time();
|
||
|
||
if ($billType == 'pay_give_integral' || $billType == 'order_give_integral') {
|
||
$integral_frozen = sys_config('integral_frozen');
|
||
if ($integral_frozen) {
|
||
$data['frozen_time'] = $data['add_time'] + ($integral_frozen * 86400);
|
||
}
|
||
}
|
||
|
||
if ($data['pm'] == 0) {
|
||
if (!$userServices->decrIntegral($uid, $data['number'])) {
|
||
throw new ApiException('积分不足');
|
||
}
|
||
$data['balance'] = bcsub((string)$userInfo['integral'], (string)$data['number'], 2);
|
||
} else {
|
||
$userServices->bcInc($uid, 'integral', (string)$data['number']);
|
||
$data['balance'] = bcadd((string)$userInfo['integral'], (string)$data['number'], 2);
|
||
}
|
||
|
||
if (!$this->dao->save($data)) {
|
||
throw new ApiException('记录写入失败');
|
||
}
|
||
// 积分变动事件
|
||
event('UserIntegralChange', [
|
||
$uid,
|
||
$data['pm'] == 1,
|
||
$data['number'],
|
||
$data['balance']
|
||
]);
|
||
|
||
return true;
|
||
});
|
||
}
|
||
/**
|
||
* 写入用户记录
|
||
* @param string $type 写入类型
|
||
* @param int $uid
|
||
* @param int|string|array $number
|
||
* @param int|string $balance
|
||
* @param int $link_id
|
||
* @return bool|mixed
|
||
*/
|
||
public function income(string $type, int $uid, $number, $balance, $link_id)
|
||
{
|
||
$incomeData = array_merge($this->integralIncomeData, $this->expIncomeData);
|
||
$data = $incomeData[$type] ?? null;
|
||
if (!$data) {
|
||
return true;
|
||
}
|
||
$data['uid'] = $uid;
|
||
$data['balance'] = $balance ?? 0;
|
||
$data['link_id'] = $link_id;
|
||
if (is_array($number)) {
|
||
$key = array_keys($number);
|
||
$key = array_map(function ($item) {
|
||
return '{%' . $item . '%}';
|
||
}, $key);
|
||
$value = array_values($number);
|
||
$data['number'] = $number['number'] ?? 0;
|
||
$data['mark'] = str_replace($key, $value, $data['mark']);
|
||
} else {
|
||
$data['number'] = $number;
|
||
$data['mark'] = str_replace(['{%num%}'], $number, $data['mark']);
|
||
}
|
||
$data['add_time'] = time();
|
||
//积分冻结时间
|
||
if ($type == 'pay_give_integral' || $type == 'order_give_integral') {
|
||
//积分冻结时间
|
||
$integral_frozen = sys_config('integral_frozen');
|
||
if ($integral_frozen) {
|
||
$data['frozen_time'] = $data['add_time'] + ($integral_frozen * 86400);
|
||
}
|
||
}
|
||
|
||
return $this->dao->save($data);
|
||
}
|
||
|
||
/**
|
||
* 事务性修改用户经验并记录流水（经验增加时自动检查等级升级）
|
||
*
|
||
* @param string $billType 流水类型（参考 expIncomeData 配置）
|
||
* @param int $uid 用户ID
|
||
* @param int|string|array $exp 变动数量（支持数组用于多参数替换）
|
||
* @param int $link_id 关联ID（如订单ID）
|
||
* @param string $mark 自定义备注
|
||
* @return bool|mixed
|
||
*/
|
||
public function billExpIncome(string $billType, int $uid, $exp, $link_id, string $mark = '')
|
||
{
|
||
$data = $this->expIncomeData[$billType] ?? null;
|
||
if (!$data) {
|
||
return true;
|
||
}
|
||
|
||
/** @var UserServices $userServices */
|
||
$userServices = app()->make(UserServices::class);
|
||
|
||
return $this->transaction(function () use (
|
||
$uid, $billType, $exp, $link_id, $mark, $data, $userServices
|
||
) {
|
||
$userInfo = $userServices->get($uid, ['exp', 'level']);
|
||
if (!$userInfo) {
|
||
throw new AdminException('用户不存在');
|
||
}
|
||
$data['type'] = $billType;
|
||
$data['category'] = self::TYPE_EXP;
|
||
$data['uid'] = $uid;
|
||
|
||
$data['link_id'] = $link_id;
|
||
|
||
if (is_array($exp)) {
|
||
$key = array_keys($exp);
|
||
$key = array_map(function ($item) {
|
||
return '{%' . $item . '%}';
|
||
}, $key);
|
||
$value = array_values($exp);
|
||
$data['number'] = $exp['number'] ?? 0;
|
||
$data['mark'] = $mark === '' ? str_replace($key, $value, $data['mark']) : $mark;
|
||
} else {
|
||
$data['number'] = $exp;
|
||
$data['mark'] = $mark === '' ? str_replace(['{%num%}'], $exp, $data['mark']) : $mark;
|
||
}
|
||
|
||
$data['add_time'] = time();
|
||
|
||
// 扣除经验或增加经验
|
||
if ($data['pm'] == 1) {
|
||
$data['balance'] = bcadd((string)$userInfo['exp'], (string)$data['number'], 2);
|
||
$userServices->bcInc($uid, 'exp', (string)$data['number']);
|
||
} else {
|
||
// 使用乐观锁扣减经验，避免并发超扣
|
||
if (!$userServices->decrExp($uid, $data['number'])) {
|
||
throw new AdminException('经验不足');
|
||
} else {
|
||
$data['balance'] = bcsub((string)$userInfo['exp'], (string)$data['number'], 2);
|
||
}
|
||
}
|
||
if (!$this->dao->save($data)) {
|
||
throw new AdminException('记录写入失败');
|
||
}
|
||
// 触发经验变动事件
|
||
try {
|
||
event('UserExpChange', [
|
||
$uid,
|
||
$data['number']
|
||
]);
|
||
} catch (\Throwable $e) {
|
||
Log::error('经验变动事件触发失败:' . $e->getMessage());
|
||
}
|
||
|
||
return true;
|
||
});
|
||
}
|
||
|
||
/**
|
||
* TODO 获取用户记录总和
|
||
* @param $uid
|
||
* @param string $category
|
||
* @param array $type
|
||
* @return mixed
|
||
*/
|
||
public function getRecordCount(int $uid, $category = 'now_money', $type = [], $time = '', $pm = false)
|
||
{
|
||
|
||
$where = [];
|
||
$where['uid'] = $uid;
|
||
$where['category'] = $category;
|
||
$where['status'] = 1;
|
||
|
||
if (is_string($type) && strlen(trim($type))) {
|
||
$where['type'] = explode(',', $type);
|
||
}
|
||
if ($time) {
|
||
$where['time'] = $time;
|
||
}
|
||
if ($pm) {
|
||
$where['pm'] = 0;
|
||
}
|
||
return $this->dao->getBillSumColumn($where);
|
||
}
|
||
|
||
/**
|
||
* 按收支方向统计用户积分合计
|
||
* 用 pm 方向聚合替代 type 白名单，避免新增积分类型漏统计
|
||
* @param int $uid 用户ID
|
||
* @param int $pm 1=收入 0=支出
|
||
* @param string $time 时间筛选（today/week/month 等），空则不限
|
||
* @param bool $frozen 是否只统计冻结期内（frozen_time > 当前时间）的流水
|
||
* @return float
|
||
*/
|
||
public function getIntegralSumByPm(int $uid, int $pm, string $time = '', bool $frozen = false): float
|
||
{
|
||
$where = [
|
||
'uid' => $uid,
|
||
'category' => 'integral',
|
||
'status' => 1,
|
||
'pm' => $pm,
|
||
];
|
||
if ($time !== '') {
|
||
$where['time'] = $time;
|
||
}
|
||
if ($frozen) {
|
||
$where['is_frozen'] = 1;
|
||
}
|
||
return (float)$this->dao->getBillSumColumn($where);
|
||
}
|
||
|
||
|
||
/**
|
||
* 获取用户|所有佣金总数
|
||
* @param int $uid
|
||
* @param array $where_time
|
||
* @return float
|
||
*/
|
||
public function getBrokerageCount(int $uid = 0, $where_time = [])
|
||
{
|
||
$where = ['category' => 'now_money', 'type' => ['system_add', 'pay_product', 'extract', 'pay_product_refund', 'system_sub'], 'pm' => 1, 'status' => 1];
|
||
if ($uid) $where['uid'] = $uid;
|
||
if ($where_time) $where['add_time'] = $where_time;
|
||
return $this->dao->getBillCount($where);
|
||
}
|
||
|
||
/**
|
||
* 用户|所有资金变动列表
|
||
* @param int $uid
|
||
* @param string $field
|
||
* @return array
|
||
*/
|
||
public function getBrokerageList(int $uid = 0, $where_time = [], string $field = '*')
|
||
{
|
||
[$page, $limit] = $this->getPageValue();
|
||
$where = ['category' => 'now_money', 'type' => ['pay_money', 'system_add', 'pay_product_refund', 'pay_member', 'offline_scan', 'lottery_add', 'system_sub']];
|
||
if ($uid) $where['uid'] = $uid;
|
||
if ($where_time) $where['add_time'] = $where_time;
|
||
$list = $this->dao->getList($where, $field, $page, $limit);
|
||
$count = $this->dao->count($where);
|
||
foreach ($list as &$item) {
|
||
$incomeData = array_merge($this->integralIncomeData, $this->expIncomeData);
|
||
$value = array_filter($incomeData, function ($value) use ($item) {
|
||
if ($item['type'] == $value['type']) {
|
||
return $item['title'];
|
||
}
|
||
});
|
||
$item['type_title'] = $value[$item['type']]['title'] ?? '未知类型';
|
||
}
|
||
return compact('list', 'count');
|
||
}
|
||
|
||
/**
|
||
* 获取用户的充值总数
|
||
* @param int $uid
|
||
* @return float
|
||
*/
|
||
public function getRechargeSum(int $uid = 0, $where_time = [])
|
||
{
|
||
$where = ['category' => 'now_money', 'type' => 'recharge', 'pm' => 1, 'status' => 1];//用户充值余额
|
||
$where_system = ['category' => 'now_money', 'type' => 'system_add', 'pm' => 1, 'status' => 1];//系统赠送余额
|
||
if ($uid) $where['uid'] = $where_system['uid'] = $uid;
|
||
if ($where_time) $where['add_time'] = $where_system['add_time'] = $where_time;
|
||
$sum1 = $this->dao->getBillSum($where);
|
||
$sum2 = $this->dao->getBillSum($where_system);
|
||
return bcadd((string)$sum1, (string)$sum2, 2);
|
||
}
|
||
|
||
/**
|
||
* 用户|所有充值列表
|
||
* @param int $uid
|
||
* @param string $field
|
||
* @return array
|
||
*/
|
||
public function getRechargeList(int $uid = 0, $where_time = [], string $field = '*')
|
||
{
|
||
[$page, $limit] = $this->getPageValue();
|
||
$where = ['category' => 'now_money', 'type' => 'recharge'];
|
||
if ($uid) $where['uid'] = $uid;
|
||
if ($where_time) $where['add_time'] = $where_time;
|
||
$list = $this->dao->getList($where, $field, $page, $limit);
|
||
$count = $this->dao->count($where);
|
||
return compact('list', 'count');
|
||
}
|
||
|
||
/**
|
||
* 获取用户的积分总数
|
||
* @param int $uid
|
||
* @return float
|
||
*/
|
||
public function getIntegralSum(int $uid = 0, $where_time = [])
|
||
{
|
||
$where = ['category' => 'integral', 'type' => ['sign', 'system_add'], 'pm' => 1, 'status' => 1];
|
||
if ($uid) $where['uid'] = $uid;
|
||
if ($where_time) $where['add_time'] = $where_time;
|
||
return $this->dao->getBillSum($where);
|
||
}
|
||
|
||
/**
|
||
* 获取用户的获取积分总次数
|
||
* @param int $uid
|
||
* @return float
|
||
*/
|
||
public function getIntegralCount(int $uid = 0, $where_time = [])
|
||
{
|
||
$where = ['category' => 'integral', 'type' => ['sign', 'system_add'], 'pm' => 1, 'status' => 1];
|
||
if ($uid) $where['uid'] = $uid;
|
||
if ($where_time) $where['add_time'] = $where_time;
|
||
return $this->dao->getBillCount($where);
|
||
}
|
||
|
||
/**
|
||
* 获取积分列表
|
||
* @param int $uid
|
||
* @param array $where_time
|
||
* @param string $field
|
||
* @return array
|
||
* @throws \think\db\exception\DataNotFoundException
|
||
* @throws \think\db\exception\DbException
|
||
* @throws \think\db\exception\ModelNotFoundException
|
||
*/
|
||
public function getIntegralList(int $uid = 0, array $where_time = [], string $field = '*')
|
||
{
|
||
[$page, $limit] = $this->getPageValue();
|
||
$where = ['category' => 'integral'];
|
||
if ($uid) $where['uid'] = $uid;
|
||
if ($where_time) $where['add_time'] = $where_time;
|
||
$list = $this->dao->getList($where, $field, $page, $limit);
|
||
foreach ($list as &$item) {
|
||
$item['number'] = intval($item['number']);
|
||
$item['is_frozen'] = $item['frozen_time'] > time() ? 1 : 0;
|
||
}
|
||
$count = $this->dao->count($where);
|
||
return compact('list', 'count');
|
||
}
|
||
|
||
/**
|
||
* 获取用户签到总数
|
||
* @param int $uid
|
||
* @return float
|
||
*/
|
||
public function getSignlSum(int $uid = 0, $where_time = [])
|
||
{
|
||
$where = ['category' => 'integral', 'type' => 'sign', 'pm' => 1, 'status' => 1];
|
||
if ($uid) $where['uid'] = $uid;
|
||
if ($where_time) $where['add_time'] = $where_time;
|
||
return $this->dao->getBillSum($where);
|
||
}
|
||
|
||
/**
|
||
* 获取用户的签到总次数
|
||
* @param int $uid
|
||
* @return float
|
||
*/
|
||
public function getSignCount(int $uid = 0, $where_time = [])
|
||
{
|
||
$where = ['category' => 'integral', 'type' => 'sign', 'pm' => 1, 'status' => 1];
|
||
if ($uid) $where['uid'] = $uid;
|
||
if ($where_time) $where['add_time'] = $where_time;
|
||
return $this->dao->getBillCount($where);
|
||
}
|
||
|
||
/**
|
||
* 获取签到列表
|
||
* @param int $uid
|
||
* @param array $where_time
|
||
* @param string $field
|
||
* @return array
|
||
*/
|
||
public function getSignList(int $uid = 0, $where_time = [], string $field = '*')
|
||
{
|
||
[$page, $limit] = $this->getPageValue();
|
||
$where = ['category' => 'integral', 'type' => 'sign'];
|
||
if ($uid) $where['uid'] = $uid;
|
||
if ($where_time) $where['add_time'] = $where_time;
|
||
$list = $this->dao->getList($where, $field, $page, $limit);
|
||
$count = $this->dao->count($where);
|
||
return compact('list', 'count');
|
||
}
|
||
|
||
/**
|
||
* 经验总数
|
||
* @param int $uid
|
||
* @param array $where_time
|
||
* @return float
|
||
*/
|
||
public function getExpSum(int $uid = 0, $where_time = [])
|
||
{
|
||
$where = ['category' => ['exp'], 'pm' => 1, 'status' => 1];
|
||
if ($uid) $where['uid'] = $uid;
|
||
if ($where_time) $where['time'] = $where_time;
|
||
return $this->dao->getBillSum($where);
|
||
}
|
||
|
||
/**
|
||
* 获取所有经验列表
|
||
* @param int $uid
|
||
* @param array $where_time
|
||
* @param string $field
|
||
* @return array
|
||
*/
|
||
public function getExpList(int $uid = 0, $where_time = [], string $field = '*')
|
||
{
|
||
[$page, $limit] = $this->getPageValue();
|
||
$where = ['category' => ['exp']];
|
||
$where['status'] = 1;
|
||
if ($uid) $where['uid'] = $uid;
|
||
if ($where_time) $where['time'] = $where_time;
|
||
$list = $this->dao->getList($where, $field, $page, $limit);
|
||
$count = $this->dao->count($where);
|
||
return compact('list', 'count');
|
||
}
|
||
|
||
/**
|
||
* 邀请新用户增加经验
|
||
* @param int $spreadUid
|
||
*/
|
||
public function inviteUserIncExp(int $spreadUid)
|
||
{
|
||
if (!$spreadUid) {
|
||
return false;
|
||
}
|
||
//用户等级是否开启
|
||
if (!sys_config('member_func_status', 1)) {
|
||
return false;
|
||
}
|
||
/** @var UserServices $userService */
|
||
$userService = app()->make(UserServices::class);
|
||
$spread_user = $userService->getUserInfo($spreadUid);
|
||
if (!$spread_user) {
|
||
return false;
|
||
}
|
||
$exp_num = sys_config('invite_user_exp', 0);
|
||
if ($exp_num) {
|
||
$this->billExpIncome('invite_user_exp', $spreadUid, $exp_num, 0);
|
||
}
|
||
return true;
|
||
}
|
||
|
||
/**
|
||
* 获取type
|
||
* @param array $where
|
||
* @param string $filed
|
||
*/
|
||
public function getBillType(array $where)
|
||
{
|
||
return $this->dao->getType($where);
|
||
}
|
||
|
||
/**
|
||
* 资金类型
|
||
*/
|
||
public function bill_type()
|
||
{
|
||
$where = [];
|
||
$where['not_type'] = ['gain', 'system_sub', 'deduction', 'sign'];
|
||
$where['not_category'] = ['exp', 'integral'];
|
||
return CacheService::remember('user_type_list', function () use ($where) {
|
||
return ['list' => $this->getBillType($where)];
|
||
}, 600);
|
||
}
|
||
|
||
/**
|
||
* 获取资金列表
|
||
* @param array $where
|
||
* @param string $field
|
||
* @return array
|
||
*/
|
||
public function getBillList(array $where, string $field = '*', $is_page = true)
|
||
{
|
||
$where_data = [];
|
||
if (!empty($where['uid'])) {
|
||
$where_data['uid'] = $where['uid'];
|
||
}
|
||
if ($where['start_time'] !== '' && $where['end_time'] !== '') {
|
||
$where_data['time'] = str_replace('-', '/', $where['start_time']) . ' - ' . str_replace('-', '/', $where['end_time']);
|
||
}
|
||
if (isset($where['category']) && $where['category'] !== '') {
|
||
$where_data['category'] = $where['category'];
|
||
}
|
||
if (isset($where['type']) && $where['type'] !== '' && $where['type'] !== null) {
|
||
$where_data['type'] = $where['type'];
|
||
if ($where['type'] == 'brokerage') $where_data['pm'] = 1;
|
||
}
|
||
$where_data['not_category'] = ['integral', 'exp', 'share'];
|
||
$where_data['not_type'] = $where['type'] == 'pay_product' ? ['gain', 'system_sub', 'deduction', 'sign'] : ['gain', 'system_sub', 'deduction', 'sign', 'pay_product'];
|
||
if (isset($where['nickname']) && $where['nickname'] !== '') {
|
||
$where_data['like'] = $where['nickname'];
|
||
}
|
||
if (isset($where['excel']) && $where['excel'] !== '' && $where['excel'] !== null) {
|
||
$where_data['excel'] = $where['excel'];
|
||
} else {
|
||
$where_data['excel'] = 0;
|
||
}
|
||
[$page, $limit] = $this->getPageValue($is_page);
|
||
$data = $this->dao->getBillList($where_data, $field, $page, $limit);
|
||
foreach ($data as &$item) {
|
||
$item['nickname'] = $item['user']['nickname'] ?? '';
|
||
unset($item['user']);
|
||
}
|
||
$count = $this->dao->count($where_data);
|
||
return compact('data', 'count');
|
||
}
|
||
|
||
/**
|
||
* 记录分享次数
|
||
* @param int $uid 用户uid
|
||
* @param int $cd 冷却时间
|
||
* @return Boolean
|
||
* */
|
||
public function setUserShare(int $uid, $cd = 300)
|
||
{
|
||
/** @var UserServices $userServices */
|
||
$userServices = app()->make(UserServices::class);
|
||
$user = $userServices->getUserInfo($uid);
|
||
if (!$user) {
|
||
throw new AdminException('用户信息不存在');
|
||
}
|
||
$cachename = 'Share_' . $uid;
|
||
if (CacheService::get($cachename)) {
|
||
return false;
|
||
}
|
||
$data = ['title' => '用户分享记录', 'uid' => $uid, 'category' => 'share', 'type' => 'share', 'number' => 0, 'link_id' => 0, 'balance' => 0, 'mark' => date('Y-m-d H:i:s', time()) . ':用户分享'];
|
||
if (!$this->dao->save($data)) {
|
||
throw new AdminException('记录分享记录失败');
|
||
}
|
||
CacheService::set($cachename, 1, $cd);
|
||
return true;
|
||
}
|
||
|
||
/**
|
||
* 获取积分列表
|
||
* @param array $where
|
||
* @param string $field
|
||
* @return array
|
||
*/
|
||
public function getPointList(array $where, string $field = '*', $is_page = true)
|
||
{
|
||
$where_data = [];
|
||
$where_data['category'] = 'integral';
|
||
if (!empty($where['uid'])) {
|
||
$where_data['uid'] = $where['uid'];
|
||
}
|
||
if ($where['start_time'] !== '' && $where['end_time'] !== '') {
|
||
$where_data['time'] = $where['start_time'] . ' - ' . $where['end_time'];
|
||
}
|
||
if (isset($where['type']) && $where['type'] !== '' && $where['type'] !== null) {
|
||
$where_data['type'] = $where['type'];
|
||
}
|
||
if (isset($where['nickname']) && $where['nickname'] !== '') {
|
||
$where_data['like'] = $where['nickname'];
|
||
}
|
||
if (isset($where['excel']) && $where['excel'] !== '' && $where['excel'] !== null) {
|
||
$where_data['excel'] = $where['excel'];
|
||
} else {
|
||
$where_data['excel'] = 0;
|
||
}
|
||
[$page, $limit] = $this->getPageValue($is_page);
|
||
$list = $this->dao->getBillList($where_data, $field, $page, $limit);
|
||
foreach ($list as &$item) {
|
||
$item['nickname'] = $item['user']['nickname'] ?? '';
|
||
$item['number'] = intval($item['number']);
|
||
$item['balance'] = intval($item['balance']);
|
||
unset($item['user']);
|
||
}
|
||
$count = $this->dao->count($where_data);
|
||
return compact('list', 'count');
|
||
}
|
||
|
||
/**
|
||
* 积分头部信息
|
||
* @param array $where
|
||
* @return array[]
|
||
*/
|
||
public function getUserPointBadgelist(array $where)
|
||
{
|
||
$data = [];
|
||
$where_data = [];
|
||
$where_data['category'] = 'integral';
|
||
if ($where['start_time'] !== '' && $where['end_time'] !== '') {
|
||
$where_data['time'] = $where['start_time'] . ' - ' . $where['end_time'];
|
||
}
|
||
if (isset($where['nickname']) && $where['nickname'] !== '') {
|
||
$where_data['like'] = $where['nickname'];
|
||
}
|
||
$data['SumIntegral'] = intval($this->dao->getBillSumColumn($where_data + ['pm' => 1, 'integral_type' => 'get']));
|
||
$where_data['type'] = 'sign';
|
||
$data['CountSign'] = $this->dao->getUserSignPoint($where_data);
|
||
$data['SumSign'] = intval($this->dao->getBillSumColumn($where_data));
|
||
$where_data['type'] = ['deduction', 'system_sub'];
|
||
$data['SumDeductionIntegral'] = intval($this->dao->getBillSumColumn($where_data));
|
||
return [
|
||
[
|
||
'col' => 6,
|
||
'count' => $data['SumIntegral'],
|
||
'name' => '总积分(个)',
|
||
],
|
||
[
|
||
'col' => 6,
|
||
'count' => $data['CountSign'],
|
||
'name' => '客户签到次数(次)',
|
||
],
|
||
[
|
||
'col' => 6,
|
||
'count' => $data['SumSign'],
|
||
'name' => '签到送出积分(个)',
|
||
],
|
||
[
|
||
'col' => 6,
|
||
'count' => $data['SumDeductionIntegral'],
|
||
'name' => '使用积分(个)',
|
||
],
|
||
];
|
||
}
|
||
|
||
/**
|
||
* 推广订单
|
||
* @param int $uid
|
||
* @param array $data
|
||
* @return array
|
||
*/
|
||
public function spread_order(int $uid, array $data)
|
||
{
|
||
/** @var UserServices $userService */
|
||
$userService = app()->make(UserServices::class);
|
||
if (!$userService->getUserInfo($uid, 'uid')) {
|
||
throw new ApiException('数据不存在');
|
||
}
|
||
[$page, $limit] = $this->getPageValue();
|
||
$proxy = event('DistributionServiceProxy', [
|
||
'service' => 'DistributionOrderServices',
|
||
'action' => 'promoterOrderPage',
|
||
'args' => [$uid, $data, $page, $limit],
|
||
]);
|
||
$snapshotPage = is_array($proxy) && is_array($proxy[0] ?? null) ? $proxy[0] : [];
|
||
$list = $snapshotPage['list'] ?? [];
|
||
if ($list) {
|
||
$uids = array_unique(array_column($list, 'uid'));
|
||
$userInfos = $userService->getColumn([['uid', 'in', $uids]], 'uid,avatar,nickname', 'uid');
|
||
foreach ($list as &$item) {
|
||
$item['avatar'] = $userInfos[$item['uid']]['avatar'] ?? '';
|
||
$item['nickname'] = $userInfos[$item['uid']]['nickname'] ?? '';
|
||
if ($item['division_id'] == $uid) {
|
||
$item['number'] = $item['division_brokerage'];
|
||
} elseif ($item['agent_id'] == $uid) {
|
||
$item['number'] = $item['agent_brokerage'];
|
||
} elseif ($item['staff_id'] == $uid) {
|
||
$item['number'] = $item['staff_brokerage'];
|
||
} else {
|
||
$item['number'] = $item['spread_uid'] == $uid ? $item['one_brokerage'] : $item['two_brokerage'];
|
||
}
|
||
$item['order_id'] = $item['order_no'] ?: $item['order_id'];
|
||
$item['time'] = $item['add_time'] ? date('Y-m-d H:i', $item['add_time']) : '';
|
||
$item['time_key'] = $item['add_time'] ? date('Y-m', $item['add_time']) : '';
|
||
$item['type'] = in_array($item['status_code'], ['pending_review', 'completed'], true) ? 'brokerage' : 'number';
|
||
$item['children'] = [];
|
||
}
|
||
}
|
||
$timeData = array_map(static fn(array $month): array => [
|
||
'time' => (string)($month['month'] ?? ''),
|
||
'count' => (int)($month['count'] ?? 0),
|
||
], $snapshotPage['months'] ?? []);
|
||
return [
|
||
'list' => $list,
|
||
'time' => $timeData,
|
||
'count' => (int)($snapshotPage['count'] ?? 0),
|
||
];
|
||
}
|
||
|
||
|
||
/**根据查询用户充值金额
|
||
* @param array $where
|
||
* @return float|int
|
||
*/
|
||
public function getRechargeMoneyByWhere(array $where, string $rechargeSumField, string $selectType, string $group = "")
|
||
{
|
||
switch ($selectType) {
|
||
case "sum" :
|
||
return $this->dao->getWhereSumField($where, $rechargeSumField);
|
||
case "group" :
|
||
return $this->dao->getGroupField($where, $rechargeSumField, $group);
|
||
}
|
||
}
|
||
}
|