PHP项目退款与纠纷处理

wen PHP项目 2026-08-11 91

PHP项目退款与纠纷处理指南

退款处理流程

退款流程图

用户申请退款 → 审核申请 → 确认退款条件 → 执行退款 → 通知用户 → 记录存档

退款状态管理

<?php
// 退款状态常量定义
class RefundStatus {
    const PENDING = 0;      // 待审核
    const APPROVED = 1;     // 已通过
    const REJECTED = 2;     // 已拒绝
    const PROCESSING = 3;   // 处理中
    const COMPLETED = 4;    // 已完成
    const FAILED = 5;       // 失败
}
// 退款请求类
class RefundRequest {
    private $db;
    public function __construct($db) {
        $this->db = $db;
    }
    /**
     * 创建退款申请
     */
    public function createRefund($orderId, $userId, $reason, $amount) {
        $stmt = $this->db->prepare("
            INSERT INTO refunds (order_id, user_id, reason, amount, status, created_at) 
            VALUES (?, ?, ?, ?, ?, NOW())
        ");
        $stmt->execute([
            $orderId, 
            $userId, 
            $reason, 
            $amount, 
            RefundStatus::PENDING
        ]);
        return $this->db->lastInsertId();
    }
    /**
     * 审核退款申请
     */
    public function processRefund($refundId, $action, $adminId, $note = '') {
        // 获取退款信息
        $refund = $this->getRefundById($refundId);
        if (!$refund) {
            throw new Exception("退款申请不存在");
        }
        if ($action === 'approve') {
            $status = RefundStatus::APPROVED;
            $this->executeRefund($refund);
        } else {
            $status = RefundStatus::REJECTED;
        }
        // 更新状态
        $stmt = $this->db->prepare("
            UPDATE refunds 
            SET status = ?, processed_by = ?, processed_at = NOW(), admin_note = ?
            WHERE id = ?
        ");
        $stmt->execute([$status, $adminId, $note, $refundId]);
        return true;
    }
}
?>

实际退款执行

<?php
/**
 * 执行实际退款操作
 */
class PaymentGateway {
    /**
     * 支付宝退款
     */
    public function alipayRefund($orderNo, $refundAmount, $reason) {
        require_once 'alipay-sdk/alipay-sdk.php';
        $alipay = new AlipayClient();
        $request = new AlipayTradeRefundRequest();
        $request->setBizContent(json_encode([
            'out_trade_no' => $orderNo,
            'refund_amount' => $refundAmount,
            'refund_reason' => $reason,
            'out_request_no' => uniqid('refund_', true)
        ]));
        $result = $alipay->execute($request);
        return $this->handleAlipayResponse($result);
    }
    /**
     * 微信退款
     */
    public function wechatRefund($orderNo, $refundAmount, $totalAmount) {
        require_once 'wechat-sdk/wechat-sdk.php';
        $wechat = new WechatPayClient();
        $params = [
            'out_trade_no' => $orderNo,
            'out_refund_no' => 'R' . date('YmdHis') . rand(100000, 999999),
            'total_fee' => $totalAmount,
            'refund_fee' => $refundAmount,
            'refund_desc' => '用户退款'
        ];
        $result = $wechat->refund($params);
        return $this->handleWechatResponse($result);
    }
    /**
     * PayPal退款
     */
    public function paypalRefund($transactionId, $amount) {
        require_once 'paypal-sdk/autoload.php';
        $apiContext = new \PayPal\Rest\ApiContext(
            new \PayPal\Auth\OAuthTokenCredential(
                $clientId,
                $clientSecret
            )
        );
        $refund = new \PayPal\Api\Refund();
        $refund->setAmount(new \PayPal\Api\Amount([
            'total' => $amount,
            'currency' => 'USD'
        ]));
        $sale = new \PayPal\Api\Sale();
        $sale->setId($transactionId);
        $refunded = $sale->refund($refund, $apiContext);
        return $refunded;
    }
}
?>

纠纷处理机制

纠纷升级流程

用户投诉 → 客服介入 → 协商解决 →
  ├─ 成功 → 关闭纠纷
  └─ 失败 → 升级处理 →
       ├─ 管理员仲裁
       ├─ 第三方调解
       └─ 法律途径

纠纷处理类

<?php
/**
 * 纠纷处理类
 */
class DisputeHandler {
    private $db;
    private $response;
    public function __construct($db) {
        $this->db = $db;
        $this->response = new ResponseHandler();
    }
    /**
     * 创建纠纷
     */
    public function createDispute($orderId, $userId, $type, $description, $evidence = []) {
        // 创建纠纷记录
        $stmt = $this->db->prepare("
            INSERT INTO disputes (
                order_id, user_id, type, description, evidence, 
                status, priority, created_at
            ) VALUES (?, ?, ?, ?, ?, ?, ?, NOW())
        ");
        $priority = $this->calculatePriority($type, $orderId);
        $stmt->execute([
            $orderId, $userId, $type, $description, 
            json_encode($evidence), DisputeStatus::OPEN, $priority
        ]);
        $disputeId = $this->db->lastInsertId();
        // 通知管理员
        $this->notifyAdmins($disputeId);
        return $disputeId;
    }
    /**
     * 获取纠纷详情
     */
    public function getDisputeDetails($disputeId) {
        $stmt = $this->db->prepare("
            SELECT d.*, u.username, o.order_no, o.total_amount
            FROM disputes d
            JOIN users u ON d.user_id = u.id
            JOIN orders o ON d.order_id = o.id
            WHERE d.id = ?
        ");
        $stmt->execute([$disputeId]);
        return $stmt->fetch(PDO::FETCH_ASSOC);
    }
    /**
     * 协商解决
     */
    public function resolveByNegotiation($disputeId, $solution) {
        return $this->updateDisputeStatus(
            $disputeId, 
            DisputeStatus::NEGOTIATING,
            ['solution' => $solution]
        );
    }
    /**
     * 升级纠纷
     */
    public function escalateDispute($disputeId, $reason) {
        // 更新状态
        $this->updateDisputeStatus(
            $disputeId,
            DisputeStatus::ESCALATED
        );
        // 分配高级管理员
        $adminId = $this->assignSeniorAdmin($disputeId);
        // 增加优先级
        $this->increasePriority($disputeId);
        return [
            'admin_id' => $adminId,
            'escalate_time' => date('Y-m-d H:i:s')
        ];
    }
}
?>

投诉管理模块

<?php
/**
 * 用户投诉管理
 */
class ComplaintManager {
    private $db;
    /**
     * 提交投诉
     */
    public function submitComplaint($userId, $orderId, $type, $content) {
        $stmt = $this->db->prepare("
            INSERT INTO complaints (
                user_id, order_id, type, content, 
                status, created_at
            ) VALUES (?, ?, ?, ?, 'pending', NOW())
        ");
        $stmt->execute([$userId, $orderId, $type, $content]);
        // 在同一订单下合并投诉
        $this->mergeRelatedComplaints($orderId);
        return $this->db->lastInsertId();
    }
    /**
     * 处理投诉
     */
    public function processComplaint($complaintId, $action, $response) {
        $status = $action === 'accept' ? 'accepted' : 'rejected';
        $stmt = $this->db->prepare("
            UPDATE complaints 
            SET status = ?, response = ?, processed_at = NOW()
            WHERE id = ?
        ");
        $stmt->execute([$status, $response, $complaintId]);
        return true;
    }
}
?>

超时自动退款机制

<?php
/**
 * 超时未处理自动退款
 */
class AutoRefundScheduler {
    private $db;
    /**
     * 定时任务：每天检查过期未处理的退款
     */
    public function processTimeouts() {
        $date = date('Y-m-d', strtotime('-7 days'));
        $stmt = $this->db->prepare("
            SELECT * FROM refunds 
            WHERE status = 0 
            AND created_at < ?
        ");
        $stmt->execute([$date]);
        $timeouts = $stmt->fetchAll();
        foreach ($timeouts as $timeout) {
            try {
                // 自动批准退款
                $this->autoApprove($timeout);
                // 记录日志
                error_log(
                    "Auto refund approved: Refund ID {$timeout['id']}",
                    3, 
                    '/var/log/refund_auto.log'
                );
            } catch (Exception $e) {
                error_log(
                    "Auto refund failed: {$e->getMessage()}",
                    3,
                    '/var/log/refund_error.log'
                );
            }
        }
    }
    /**
     * 自动批准退款
     */
    private function autoApprove($refund) {
        $stmt = $this->db->prepare("
            UPDATE refunds 
            SET status = 3, processed_by = 'system', 
                processed_at = NOW(), 
                admin_note = '系统自动处理'
            WHERE id = ?
        ");
        $stmt->execute([$refund['id']]);
        // 执行实际退款
        $gateway = new PaymentGateway();
        // ... 执行退款操作
    }
}
?>

数据表设计

-- 退款表
CREATE TABLE refunds (
    id INT PRIMARY KEY AUTO_INCREMENT,
    order_id INT NOT NULL,
    user_id INT NOT NULL,
    reason VARCHAR(255) NOT NULL,
    amount DECIMAL(10,2) NOT NULL,
    status TINYINT DEFAULT 0 COMMENT '0:待审核 1:已通过 2:已拒绝 3:处理中 4:已完成 5:失败',
    admin_note TEXT,
    processed_by INT,
    created_at DATETIME,
    processed_at DATETIME,
    INDEX idx_order (order_id),
    INDEX idx_user (user_id),
    INDEX idx_status (status)
);
-- 纠纷表
CREATE TABLE disputes (
    id INT PRIMARY KEY AUTO_INCREMENT,
    order_id INT NOT NULL,
    user_id INT NOT NULL,
    type VARCHAR(50) NOT NULL,
    description TEXT,
    evidence TEXT,
    status TINYINT DEFAULT 0 COMMENT '0:开放 1:处理中 2:协商 3:升级 4:解决 5:关闭',
    priority TINYINT DEFAULT 1,
    created_at DATETIME,
    updated_at DATETIME
);
-- 投诉表
CREATE TABLE complaints (
    id INT PRIMARY KEY AUTO_INCREMENT,
    user_id INT NOT NULL,
    order_id INT,
    type VARCHAR(50),
    content TEXT,
    status VARCHAR(20) DEFAULT 'pending',
    response TEXT,
    processed_at DATETIME,
    created_at DATETIME
);
-- 退款日志表
CREATE TABLE refund_logs (
    id INT PRIMARY KEY AUTO_INCREMENT,
    refund_id INT NOT NULL,
    action VARCHAR(50) NOT NULL,
    operator INT,
    detail TEXT,
    created_at DATETIME
);

安全与合规

安全措施

身份验证：确保退款人身份真实
金额校验：退款金额不超过支付金额
重复检查：防止重复退款
日志记录：所有操作留痕

合规要求

<?php
/**
 * 合规检查类
 */
class ComplianceChecker {
    /**
     * 检查是否满足退款条件
     */
    public function validateRefundEligibility($orderId, $userId) {
        // 检查订单是否存在
        // 检查是否已过退款期限
        // 检查是否有欺诈记录
        $rules = [
            'order_exists' => $this->checkOrderExists($orderId),
            'within_lime' => $this->checkRefundPeriod($orderId),
            'no_fraud' => !$this->checkFraudRecord($userId)
        ];
        return !in_array(false, $rules);
    }
    /**
     * 风险检测
     */
    public function riskAssessment($orderId, $userId) {
        $score = 0;
        // 检查历史退款率
        if ($this->getUserRefundRate($userId) > 0.5) {
            $score += 30;
        }
        // 检查异常行为
        if ($this->checkAbnormalBehavior($userId)) {
            $score += 40;
        }
        // 检查关联账户
        if ($this->checkRelatedAccounts($userId)) {
            $score += 30;
        }
        return $score;
    }
}
?>

邮件/短信通知模板

<?php
/**
 * 通知系统
 */
class NotificationService {
    /**
     * 发送退款通知
     */
    public function sendRefundNotification($email, $refundInfo) {
        $subject = '退款通知';
        $body = "
            <h2>退款通知</h2>
            <p>您的订单退款已处理：</p>
            <ul>
                <li>订单号：{$refundInfo['order_no']}</li>
                <li>退款金额：¥{$refundInfo['amount']}</li>
                <li>退款时间：{$refundInfo['time']}</li>
            </ul>
        ";
        // 发送邮件
        Mail::send($email, $subject, $body);
    }
    /**
     * 发送纠纷升级通知
     */
    public function sendEscalationNotification($adminEmail, $disputeInfo) {
        // ... 发送邮件通知管理员
    }
}
?>