mtb_crm_asp/customer_detail.php

<?php
require_once 'conn.php';
checkLogin();

$id = $_GET['id'] ?? '';
$from_warning = isset($_GET['from_warning']) ? true : false;

// Validate and fetch customer data
if (!empty($id) && is_numeric($id)) {
    // Fetch customer basic information
    $sql = "SELECT c.*, e.em_user as employee_name FROM customer c 
            JOIN employee e ON c.cs_belong = e.id
            WHERE c.id = ?";
    
    $stmt = $conn->prepare($sql);
    $stmt->bind_param("i", $id);
    $stmt->execute();
    $result = $stmt->get_result();
    
    if ($row = $result->fetch_assoc()) {
        $customer = [
            'id' => $row['id'],
            'cs_code' => textUncode($row['cs_code']),
            'cs_company' => textUncode($row['cs_company']),
            'cs_address' => textUncode($row['cs_address']),
            'cs_deal' => textUncode($row['cs_deal']),
            'cs_addtime' => $row['cs_addtime'],
            'cs_belongclient' => $row['cs_belongclient'],
            'cs_updatetime' => $row['cs_updatetime'],
            'cs_from' => $row['cs_from'],
            'cs_country' => $row['cs_country'],
            'cs_type' => $row['cs_type'],
            'cs_note' => htmlUnCode($row['cs_note']),
            'cs_claimFrom' => $row['cs_claimFrom'],
            'cs_belong' => $row['cs_belong'],
            'employee_name' => $row['employee_name']
        ];
        
        // Fetch all contact records for this customer
        $contactSql = "SELECT cc.* FROM customer_contact cc WHERE cc.customer_id = ?";
        $contactStmt = $conn->prepare($contactSql);
        $contactStmt->bind_param("i", $id);
        $contactStmt->execute();
        $contactResult = $contactStmt->get_result();
        
        $contacts = [];
        while ($contactRow = $contactResult->fetch_assoc()) {
            $contact = [
                'id' => $contactRow['id'],
                'contact_name' => textUncode($contactRow['contact_name']),
                'created_at' => $contactRow['created_at'],
                'updated_at' => $contactRow['updated_at']
            ];
            
            // Process each contact method type (up to 3 entries each)
            $methodTypes = ['tel', 'email', 'whatsapp', 'wechat', 'linkedin', 'facebook', 'alibaba'];
            foreach ($methodTypes as $type) {
                for ($i = 1; $i <= 3; $i++) {
                    $fieldBase = $type . '_' . $i;
                    $contact[$fieldBase] = textUncode($contactRow[$fieldBase]);
                    if ($type == 'tel' || $type == 'whatsapp') {
                        $contact[$fieldBase . '_format'] = textUncode($contactRow[$fieldBase . '_format']);
                    }
                }
            }
            
            $contacts[] = $contact;
        }
        
        // Get channel information
        $channelSql = "SELECT ch_name FROM qudao WHERE id = ?";
        $channelStmt = $conn->prepare($channelSql);
        $channelStmt->bind_param("i", $customer['cs_from']);
        $channelStmt->execute();
        $channelResult = $channelStmt->get_result();
        if ($channelRow = $channelResult->fetch_assoc()) {
            $customer['cs_from_name'] = $channelRow['ch_name'];
        } else {
            $customer['cs_from_name'] = '未知';
        }
        
        // Get country information
        $countrySql = "SELECT countryName FROM country WHERE id = ?";
        $countryStmt = $conn->prepare($countrySql);
        $countryStmt->bind_param("i", $customer['cs_country']);
        $countryStmt->execute();
        $countryResult = $countryStmt->get_result();
        if ($countryRow = $countryResult->fetch_assoc()) {
            $customer['country_name'] = $countryRow['countryName'];
        } else {
            $customer['country_name'] = '未知';
        }
        
        // Get client type information
        $typeSql = "SELECT businessType FROM clienttype WHERE id = ?";
        $typeStmt = $conn->prepare($typeSql);
        $typeStmt->bind_param("i", $customer['cs_type']);
        $typeStmt->execute();
        $typeResult = $typeStmt->get_result();
        if ($typeRow = $typeResult->fetch_assoc()) {
            $customer['cs_type_name'] = $typeRow['businessType'];
        } else {
            $customer['cs_type_name'] = '未知';
        }
        
        // Get customer tags
        $tagSql = "SELECT tagName FROM tagtable WHERE customerId = ?";
        $tagStmt = $conn->prepare($tagSql);
        $tagStmt->bind_param("i", $id);
        $tagStmt->execute();
        $tagResult = $tagStmt->get_result();
        $tags = [];
        while ($tagRow = $tagResult->fetch_assoc()) {
            $tags[] = textUncode($tagRow['tagName']);
        }
        
        // Get order history
        $orderSql = "SELECT o.*, e.em_user as sales_rep 
                   FROM orders o 
                   JOIN employee e ON o.employee_id = e.id 
                   WHERE o.customer_id = ? 
                   ORDER BY o.order_date DESC";
        $orderStmt = $conn->prepare($orderSql);
        $orderStmt->bind_param("i", $id);
        $orderStmt->execute();
        $orderResult = $orderStmt->get_result();
        $orders = [];
        while ($orderRow = $orderResult->fetch_assoc()) {
            $orders[] = $orderRow;
        }
    } else {
        echo "<script>alert('客户不存在！');history.back();</script>";
        exit;
    }
} else {
    echo "<script>alert('客户不存在!');history.back();</script>";
    exit;
}

// Helper functions
function getDealStageText($stage) {
    $stages = [
        '0' => '无响应',
        '1' => '背景调查',
        '2' => '明确需求',
        '3' => '已成交'
    ];
    return $stages[$stage] ?? '未知';
}

function getOrderStatusText($status) {
    $statuses = [
        '0' => '已取消',
        '1' => '待确认',
        '2' => '已确认',
        '3' => '生产中',
        '4' => '已发货',
        '5' => '已完成'
    ];
    return $statuses[$status] ?? '未知';
}

function getPaymentStatusText($status) {
    $statuses = [
        '0' => '未付款',
        '1' => '部分付款',
        '2' => '已付清'
    ];
    return $statuses[$status] ?? '未知';
}
?>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title>客户详情</title>
    <link rel="stylesheet" href="css/common.css" type="text/css" />
    <script src="system/js/jquery-1.7.2.min.js"></script>
    <script src="js/js.js"></script>
    <style>
        body {
            margin: 0;
            padding: 20px;
            background: #fff;
        }
        #man_zone {
            margin-left: 0;
        }
        .detail-container {
            margin-bottom: 20px;
            width: 100%;
        }
        .section-title {
            font-size: 18px;
            font-weight: bold;
            margin: 15px 0 10px 0;
            padding-bottom: 5px;
            border-bottom: 1px solid #eee;
        }
        .data-table {
            width: 100%;
            border-collapse: collapse;
            margin-bottom: 20px;
        }
        .data-table th {
            background-color: #f5f5f5;
            padding: 8px;
            text-align: left;
            font-weight: bold;
            width: 150px;
        }
        .data-table td {
            padding: 8px;
            vertical-align: top;
            border-bottom: 1px solid #eee;
        }
        .contact-card {
            border: 1px solid #eee;
            padding: 15px;
            margin-bottom: 15px;
            border-radius: 5px;
            background-color: #fafafa;
        }
        .contact-card h3 {
            margin-top: 0;
            margin-bottom: 10px;
            font-size: 16px;
        }
        .contact-method {
            margin-bottom: 8px;
        }
        .contact-type {
            font-weight: bold;
            margin-right: 10px;
            display: inline-block;
            min-width: 80px;
        }
        .tag-container {
            display: flex;
            flex-wrap: wrap;
            gap: 8px;
        }
        .tag {
            background-color: #f1f1f1;
            padding: 4px 8px;
            border-radius: 4px;
            font-size: 12px;
        }
        .orders-table {
            width: 100%;
            border-collapse: collapse;
        }
        .orders-table th, .orders-table td {
            padding: 8px;
            text-align: left;
            border: 1px solid #ddd;
        }
        .orders-table th {
            background-color: #f5f5f5;
        }
        .orders-table tr:nth-child(even) {
            background-color: #fafafa;
        }
        .btn-container {
            margin-top: 20px;
            display: flex;
            gap: 10px;
        }
        .btn {
            padding: 8px 16px;
            border-radius: 4px;
            cursor: pointer;
            text-decoration: none;
            display: inline-block;
            text-align: center;
        }
        .btn-primary {
            background-color: #2196f3;
            color: white;
            border: none;
        }
        .btn-secondary {
            background-color: #f5f5f5;
            color: #333;
            border: 1px solid #ddd;
        }
        .status-badge {
            display: inline-block;
            padding: 3px 8px;
            border-radius: 12px;
            font-size: 12px;
            background-color: #e0e0e0;
        }
        .status-badge.success {
            background-color: #4caf50;
            color: white;
        }
        .status-badge.warning {
            background-color: #ff9800;
            color: white;
        }
        .status-badge.danger {
            background-color: #f44336;
            color: white;
        }
        .status-badge.info {
            background-color: #2196f3;
            color: white;
        }
    </style>
</head>
<body class="clear">
<?php // require_once 'panel.php'; ?>
<div id="man_zone">
    <div class="detail-container">
        <h1>客户详情</h1>
        
        <!-- 基本信息 -->
        <div class="section-title">基本信息</div>
        <table class="data-table">
            <tr>
                <th>客户编号</th>
                <td><?php echo htmlspecialchars($customer['cs_code']); ?></td>
            </tr>
            <tr>
                <th>公司名称</th>
                <td><?php echo htmlspecialchars($customer['cs_company']); ?></td>
            </tr>
            <tr>
                <th>地区</th>
                <td><?php echo htmlspecialchars($customer['country_name']); ?></td>
            </tr>
            <tr>
                <th>地址</th>
                <td><?php echo htmlspecialchars($customer['cs_address']); ?></td>
            </tr>
            <tr>
                <th>业务员</th>
                <td><?php echo htmlspecialchars($customer['employee_name']); ?></td>
            </tr>
            <tr>
                <th>客户来源</th>
                <td><?php echo htmlspecialchars($customer['cs_from_name']); ?></td>
            </tr>
            <tr>
                <th>业务类型</th>
                <td><?php echo htmlspecialchars($customer['cs_type_name']); ?></td>
            </tr>
            <tr>
                <th>跟进阶段</th>
                <td>
                    <?php 
                    $dealStage = getDealStageText($customer['cs_deal']);
                    $dealClass = $customer['cs_deal'] == 3 ? 'success' : ($customer['cs_deal'] == 0 ? 'danger' : 'info');
                    echo '<span class="status-badge ' . $dealClass . '">' . htmlspecialchars($dealStage) . '</span>';
                    ?>
                </td>
            </tr>
            <tr>
                <th>其他</th>
                <td>
                    <?php if ($customer['cs_belongclient'] == 1): ?>
                    <span class="status-badge">客户的客户</span>
                    <?php endif; ?>
                </td>
            </tr>
            <tr>
                <th>添加时间</th>
                <td><?php echo $customer['cs_addtime']; ?></td>
            </tr>
            <tr>
                <th>最后更新</th>
                <td><?php echo $customer['cs_updatetime']; ?></td>
            </tr>
        </table>
        
        <!-- 联系人信息 -->
        <div class="section-title">联系人信息</div>
        <?php if (empty($contacts)): ?>
            <p>没有联系人信息</p>
        <?php else: ?>
            <?php foreach ($contacts as $contact): ?>
            <div class="contact-card">
                <h3><?php echo htmlspecialchars($contact['contact_name']); ?></h3>
                
                <?php
                $methodTypes = [
                    'tel' => '电话',
                    'wechat' => '微信',
                    'whatsapp' => 'WhatsApp',
                    'email' => '邮箱',
                    'linkedin' => '领英',
                    'facebook' => 'Facebook',
                    'alibaba' => '阿里巴巴'
                ];
                
                foreach ($methodTypes as $type => $label) {
                    for ($i = 1; $i <= 3; $i++) {
                        $fieldName = $type . '_' . $i;
                        if (!empty($contact[$fieldName])) {
                            echo '<div class="contact-method">';
                            echo '<span class="contact-type">' . $label . ':</span>';
                            echo '<span>' . htmlspecialchars($contact[$fieldName]) . '</span>';
                            echo '</div>';
                        }
                    }
                }
                ?>
            </div>
            <?php endforeach; ?>
        <?php endif; ?>
        
        <!-- 自定义标签 -->
        <div class="section-title">自定义标签</div>
        <div class="tag-container">
            <?php if (empty($tags)): ?>
                <p>没有自定义标签</p>
            <?php else: ?>
                <?php foreach ($tags as $tag): ?>
                <span class="tag"><?php echo htmlspecialchars($tag); ?></span>
                <?php endforeach; ?>
            <?php endif; ?>
        </div>
        
        <!-- 备注信息 -->
        <div class="section-title">备注信息</div>
        <div><?php echo empty($customer['cs_note']) ? '无备注' : $customer['cs_note']; ?></div>
        
        <!-- 订单历史 -->
        <div class="section-title">订单历史</div>
        <?php if (empty($orders)): ?>
            <p>没有订单记录</p>
        <?php else: ?>
            <table class="orders-table">
                <thead>
                    <tr>
                        <th>销售订单号</th>
                        <th>下单日期</th>
                        <th>订单金额</th>
                        <th>订单状态</th>
                        <th>付款状态</th>
                        <th>业务员</th>
                    </tr>
                </thead>
                <tbody>
                    <?php foreach ($orders as $order): ?>
                    <tr>
                        <td><?php echo htmlspecialchars($order['order_code']); ?></td>
                        <td><?php echo date('Y-m-d', strtotime($order['order_date'])); ?></td>
                        <td><?php echo htmlspecialchars($order['currency']) . ' ' . number_format($order['total_amount'], 2); ?></td>
                        <td>
                            <?php 
                            $statusText = getOrderStatusText($order['order_status']);
                            $statusClass = '';
                            if ($order['order_status'] == 5) $statusClass = 'success';
                            else if ($order['order_status'] == 0) $statusClass = 'danger';
                            else if ($order['order_status'] >= 2) $statusClass = 'info';
                            else $statusClass = 'warning';
                            echo '<span class="status-badge ' . $statusClass . '">' . htmlspecialchars($statusText) . '</span>';
                            ?>
                        </td>
                        <td>
                            <?php 
                            $paymentText = getPaymentStatusText($order['payment_status']);
                            $paymentClass = '';
                            if ($order['payment_status'] == 2) $paymentClass = 'success';
                            else if ($order['payment_status'] == 1) $paymentClass = 'warning';
                            else $paymentClass = 'danger';
                            echo '<span class="status-badge ' . $paymentClass . '">' . htmlspecialchars($paymentText) . '</span>';
                            ?>
                        </td>
                        <td><?php echo htmlspecialchars($order['sales_rep']); ?></td>
                    </tr>
                    <?php endforeach; ?>
                </tbody>
            </table>
        <?php endif; ?>
        
        <!-- 按钮 -->
        <div class="btn-container">
            <?php if ($from_warning): ?>
                <a href="statistics_order_warnings.php" class="btn btn-secondary">返回预警列表</a>
            <?php else: ?>
                <a href="javascript:history.back();" class="btn btn-secondary">返回</a>
            <?php endif; ?>
            
            <?php if ($_SESSION['employee_id'] == $customer['cs_belong']): ?>
                <a href="customerEdit.php?id=<?php echo $id; ?>" class="btn btn-primary">编辑客户</a>
            <?php endif; ?>
        </div>
    </div>
</div>
</body>
</html>