当前位置：首页 > PHP

php实现分佣金

2026-02-15 17:30:01PHP

PHP 实现分佣金的逻辑

分佣金系统通常涉及多层分销、比例计算和数据存储。以下是实现分佣金的核心逻辑和代码示例：

数据库设计

需要至少两张表存储用户关系和佣金记录：

CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) DEFAULT NULL COMMENT '上级ID',
  `level` tinyint(4) DEFAULT 1 COMMENT '层级',
  PRIMARY KEY (`id`)
);

CREATE TABLE `commission` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` varchar(50) NOT NULL COMMENT '订单ID',
  `user_id` int(11) NOT NULL COMMENT '受益人ID',
  `amount` decimal(10,2) NOT NULL COMMENT '佣金金额',
  `level` tinyint(4) NOT NULL COMMENT '分销层级',
  `create_time` datetime NOT NULL,
  PRIMARY KEY (`id`)
);

佣金计算逻辑

递归查找上级并计算各层级佣金：

function distributeCommission($userId, $orderId, $totalAmount) {
    $commissionRates = [0.5, 0.3, 0.2]; // 各层级佣金比例

    $currentUser = getUserById($userId);
    $parentIds = getParentChain($currentUser['id'], 3); // 获取3层上级

    foreach ($parentIds as $level => $parentId) {
        $commission = $totalAmount * $commissionRates[$level];
        if ($commission > 0) {
            addCommissionRecord([
                'order_id' => $orderId,
                'user_id' => $parentId,
                'amount' => $commission,
                'level' => $level + 1
            ]);
        }
    }
}

function getParentChain($userId, $maxLevel, $currentLevel = 0, $parents = []) {
    if ($currentLevel >= $maxLevel) return $parents;

    $user = getUserById($userId);
    if ($user && $user['parent_id']) {
        $parents[$currentLevel] = $user['parent_id'];
        return getParentChain($user['parent_id'], $maxLevel, $currentLevel + 1, $parents);
    }

    return $parents;
}

佣金发放处理

定时任务处理待发放佣金：

function processPendingCommissions() {
    $pending = getPendingCommissions();

    foreach ($pending as $record) {
        try {
            $success = transferToUserWallet($record['user_id'], $record['amount']);
            if ($success) {
                updateCommissionStatus($record['id'], 'completed');
            }
        } catch (Exception $e) {
            logError($e->getMessage());
        }
    }
}

安全注意事项

使用事务确保佣金记录和资金变动同步
金额计算使用精确小数处理
添加防并发处理机制
记录完整操作日志

扩展功能实现

多级分销配置

可通过配置表实现灵活层级设置：

$config = [
    'max_level' => 5,
    'commission_rates' => [
        1 => 0.4,
        2 => 0.3,
        3 => 0.2,
        4 => 0.1
    ],
    'settlement_days' => 7
];

佣金提现功能

function handleWithdrawRequest($userId, $amount) {
    $balance = getUserBalance($userId);
    if ($balance < $amount) {
        throw new Exception('余额不足');
    }

    startTransaction();
    try {
        freezeUserBalance($userId, $amount);
        createWithdrawRecord($userId, $amount);
        commitTransaction();
    } catch (Exception $e) {
        rollbackTransaction();
        throw $e;
    }
}