igamebox
/
mtb_crm_asp


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

$id = $_GET['id'] ?? '';
$page = $_GET['Page'] ?? '';
$keys = urlencode($_GET['Keys'] ?? '');

$hrefstr = "?keys=$keys&Page=$page";

// Validate and fetch customer data
if (!empty($id) && is_numeric($id)) {
    // Fetch customer basic information
    $sql = "SELECT c.* FROM customer c WHERE c.cs_belong = ? AND c.id = ?";
    
    $stmt = $conn->prepare($sql);
    $stmt->bind_param("ii", $_SESSION['employee_id'], $id);
    $stmt->execute();
    $result = $stmt->get_result();
    
    if ($row = $result->fetch_assoc()) {
        $customer = [
            'cs_company' => textUncode($row['cs_company']),
            'cs_address' => textUncode($row['cs_address']),
            'cs_code' => textUncode($row['cs_code']),
            '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'],
            'allowedit' => $row['allowedit']
        ];
        
        // 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']);
                    }
                    $contact[$fieldBase . '_bu'] = textUncode($contactRow[$fieldBase . '_bu']);
                }
            }
            
            $contacts[] = $contact;
        }
    } else {
        echo "<script>alert('客户不存在或你没权限查看！');history.back();</script>";
        exit;
    }
} else {
    echo "<script>alert('客户不存在!');history.back();</script>";
    header("Location: $hrefstr");
    exit;
}
?>
<!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>
    <script src="js/xheditor-1.1.9/xheditor-1.1.9-zh-cn.min.js"></script>
    <script src="js/Hz2Py-szm-min.js"></script>
    <script src="js/ySearchSelect.js"></script>
    <script>
    $(document).ready(function(){
        $('.txt2').xheditor({
            tools:'full',
            hoverExecDelay:-1,
            urlBase:'system',
            upLinkUrl:"upload.php",
            upLinkExt:"zip,rar,txt,pdf",
            upImgUrl:"upload.php",
            upImgExt:"jpg,jpeg,gif,png",
            upFlashUrl:"upload.php",
            upFlashExt:"swf",
            upMediaUrl:"upload.php",
            upMediaExt:"wmv,avi,wma,mp3,mid"
        });
        
        // Remove contact
        $(document).on('click', '.remove-contact-btn', function() {
            var contactForm = $(this).closest('.contact-form');
            contactForm.remove();
            
            // Renumber remaining contacts
            $('#contacts-container .contact-form').each(function(index) {
                $(this).find('h3').text('联系人 #' + (index + 1));
            });
        });
        
        // Add contact form
        $('.add-contact-btn').click(function() {
            var contactsContainer = $('#contacts-container');
            var contactIndex = contactsContainer.children('.contact-form').length;
            var contactForm = `
                <div class="contact-form" id="contact-form-${contactIndex}">
                    <div class="contact-header">
                        <button type="button" class="remove-contact-btn" data-index="${contactIndex}">删除</button>
                        <h3>联系人 #${contactIndex + 1}</h3>
                    </div>
                    <input type="hidden" name="contact[${contactIndex}][id]" value="">
                    <table width="100%" border="0" cellpadding="3" cellspacing="1" class="contact-table">
                        <tr>
                            <th width="8%">联系人</th>
                            <td><input type="text" name="contact[${contactIndex}][contact_name]" class="txt1" placeholder="联系人姓名"/></td>
                        </tr>
                    </table>
                    <div class="contact-methods-container" id="contact-methods-${contactIndex}">
                        <!-- Contact methods will be added here -->
                    </div>
                    <button type="button" class="add-method-btn" data-contact-index="${contactIndex}">添加联系方式</button>
                </div>
            `;
            contactsContainer.append(contactForm);
        });
        
        // Add contact method
        $(document).on('click', '.add-method-btn', function() {
            var contactIndex = $(this).data('contact-index');
            var methodsContainer = $('#contact-methods-' + contactIndex);
            
            // Count existing methods by type
            var methodCounts = {};
            methodsContainer.find('select.method-select').each(function() {
                var type = $(this).val();
                if (type) {
                    methodCounts[type] = (methodCounts[type] || 0) + 1;
                }
            });
            
            var methodRow = `
                <div class="contact-method-row">
                    <select class="method-select" onchange="updateMethodSelectAndPlaceholder(this)">
                        <option value="">请选择联系方式</option>
                        <option value="tel" ${(methodCounts.tel || 0) >= 3 ? 'disabled' : ''}>电话</option>
                        <option value="wechat" ${(methodCounts.wechat || 0) >= 3 ? 'disabled' : ''}>微信</option>
                        <option value="whatsapp" ${(methodCounts.whatsapp || 0) >= 3 ? 'disabled' : ''}>WhatsApp</option>
                        <option value="email" ${(methodCounts.email || 0) >= 3 ? 'disabled' : ''}>邮箱</option>
                        <option value="linkedin" ${(methodCounts.linkedin || 0) >= 3 ? 'disabled' : ''}>领英</option>
                        <option value="facebook" ${(methodCounts.facebook || 0) >= 3 ? 'disabled' : ''}>Facebook</option>
                        <option value="alibaba" ${(methodCounts.alibaba || 0) >= 3 ? 'disabled' : ''}>阿里巴巴</option>
                    </select>
                    <input type="text" class="txt1 method-input" style="width:60%;" placeholder="请选择联系方式类型">
                    <button type="button" class="remove-method-btn">删除</button>
                </div>
            `;
            
            methodsContainer.append(methodRow);
            updateMethodFields(methodsContainer.find('.contact-method-row:last-child'));
        });
        
        // Remove contact method
        $(document).on('click', '.remove-method-btn', function() {
            var methodRow = $(this).closest('.contact-method-row');
            var contactIndex = methodRow.closest('.contact-form').attr('id').split('-')[2];
            var type = methodRow.find('select.method-select').val();
            methodRow.remove();
            
            // Update available options in other selects
            updateAvailableMethodTypes(contactIndex);
        });
    });

    // Update method fields based on selection
    function updateMethodFields(methodRow) {
        var select = methodRow.find('select.method-select');
        var input = methodRow.find('input.method-input');
        var contactForm = methodRow.closest('.contact-form');
        var contactIndex = contactForm.attr('id').split('-')[2];
        var type = select.val();
        
        if (!type) return;
        
        // Count existing methods of this type
        var count = 1;
        contactForm.find('select.method-select').each(function() {
            if ($(this).val() === type && $(this)[0] !== select[0]) {
                count++;
            }
        });
        
        // Update field names
        select.attr('name', `contact[${contactIndex}][${type}_${count}]`);
        input.attr('name', `contact[${contactIndex}][${type}_${count}]`);
        
        // Add format field for tel and whatsapp
        if (type === 'tel' || type === 'whatsapp') {
            if (!methodRow.find('.format-input').length) {
                input.after(`<input type="hidden" class="format-input" name="contact[${contactIndex}][${type}_${count}_format]">`);
            }
        }
        
        // Add backup field
        if (!methodRow.find('.backup-input').length) {
            methodRow.append(`<input type="hidden" class="backup-input" name="contact[${contactIndex}][${type}_${count}_bu]">`);
        }
    }

    // Update available method types for a contact
    function updateAvailableMethodTypes(contactIndex) {
        var methodsContainer = $('#contact-methods-' + contactIndex);
        
        // Count methods by type
        var methodCounts = {};
        methodsContainer.find('select.method-select').each(function() {
            var type = $(this).val();
            if (type) {
                methodCounts[type] = (methodCounts[type] || 0) + 1;
            }
        });
        
        // Update all selects in this contact
        methodsContainer.find('select.method-select').each(function() {
            var currentValue = $(this).val();
            
            $(this).find('option').each(function() {
                var optionValue = $(this).val();
                if (optionValue && optionValue !== currentValue) {
                    $(this).prop('disabled', (methodCounts[optionValue] || 0) >= 3);
                }
            });
        });
    }

    // Update placeholder and handle method fields
    function updateMethodSelectAndPlaceholder(selectElement) {
        var methodRow = $(selectElement).closest('.contact-method-row');
        updateMethodPlaceholder(selectElement);
        updateMethodFields(methodRow);
        
        var contactIndex = methodRow.closest('.contact-form').attr('id').split('-')[2];
        updateAvailableMethodTypes(contactIndex);
    }

    // Look for the updateMethodPlaceholder function and replace it with this modified version
    function updateMethodPlaceholder(selectElement) {
        var placeholder = "";
        var value = $(selectElement).val();
        
        switch(value) {
            case "tel":
                placeholder = "电话格式:区号+号码 如:+86 15012345678";
                break;
            case "wechat":
                placeholder = "微信";
                break;
            case "whatsapp":
                placeholder = "Whatsapp 格式:区号+号码 如:+86 15012345678";
                break;
            case "email":
                placeholder = "邮件";
                break;
            case "linkedin":
                placeholder = "领英链接";
                break;
            case "facebook":
                placeholder = "Facebook";
                break;
            case "alibaba":
                placeholder = "阿里巴巴";
                break;
            default:
                placeholder = "请选择联系方式类型";
        }
        
        $(selectElement).next('.method-input').attr('placeholder', placeholder);
    }

    // Custom validation function for multiple contacts form with contact methods
    function validateMultipleContactsForm() {
        var clientCode = $("#cs_code").val();
        var clientCompany = $("#cs_company").val();
        var clientFrom = $("#cs_from").val();
        var clientCountry = $("#cs_country").val();
        
        // Validate basic customer info
        if (clientCode == "" || clientCode == null) {
            alert("客户代码不能为空!");
            $("#cs_code").focus();
            return false;
        }
        
        if (clientCountry == 0) {
            alert("这是哪个国家的客户？");
            return false;
        }
        
        if (clientFrom == "0") {
            alert("请填写客户来源!");
            return false;
        }
        
        // Validate that at least one contact has at least one contact method
        var hasContactMethod = false;
        var allContactsValid = true;
        
        $('.contact-form').each(function(contactIndex) {
            var $form = $(this);
            var contactName = $form.find('input[name*="[contact_name]"]').val();
            var hasMethodInThisContact = false;
            
            // Check if this contact has methods
            $form.find('.contact-method-row').each(function() {
                var methodType = $(this).find('select.method-select').val();
                var methodValue = $(this).find('input.method-input').val();
                
                if (methodValue) {
                    hasMethodInThisContact = true;
                    hasContactMethod = true;
                }
                
                // Check if method type is selected but value is empty
                if (methodType && !methodValue) {
                    alert("联系方式类型已选择但值为空");
                    allContactsValid = false;
                    return false;
                }
            });
            
            // If contact has a name but no methods, or has methods but no name
            if ((contactName && !hasMethodInThisContact) || (!contactName && hasMethodInThisContact)) {
                alert("联系人 #" + (contactIndex + 1) + " 缺少联系人姓名或联系方式");
                allContactsValid = false;
                return false;
            }
            
            // If contact has neither name nor methods, it's an empty contact
            if (!contactName && !hasMethodInThisContact) {
                alert("联系人 #" + (contactIndex + 1) + " 是空的，请填写信息或删除此联系人");
                allContactsValid = false;
                return false;
            }
        });
        
        if (!allContactsValid) {
            return false;
        }
        
        if (!hasContactMethod) {
            alert("至少需要添加一个联系人，且联系人至少需要一种联系方式!");
            return false;
        }
        
        // Set tag values
        $("input#mytag").val($(".taglist").html());
        
        // Convert the dynamic contact methods to the standard format expected by the server
        $('.contact-form').each(function(contactIndex) {
            var methodsData = {};
            
            $(this).find('.contact-method-row').each(function() {
                var type = $(this).find('select.method-select').val();
                var value = $(this).find('input.method-input').val();
                
                if (type && value) {
                    methodsData[type] = value;
                }
            });
            
            // Create hidden inputs for each method
            for (var type in methodsData) {
                $('<input>').attr({
                    type: 'hidden',
                    name: 'contact[' + contactIndex + '][' + type + ']',
                    value: methodsData[type]
                }).appendTo(this);
            }
        });
        
        return true;
    }

    // Modified submission function
    function submitCustomerForm() {
        if (validateMultipleContactsForm()) {
            $("#form1").submit();
        }
    }
    </script>
    <style>
        body {
            margin: 0;
            padding: 20px;
            background: #fff;
        }
        #man_zone {
            margin-left: 0;
        }
        .contact-form {
            margin-bottom: 10px;
            /*border: 1px solid #ddd;*/
            padding: 8px;
            background-color: #FFFFFF;
        }
        .contact-header {
            display: flex;
            align-items: center;
            margin-bottom: 8px;
            gap: 10px;
        }
        .contact-header h3 {
            margin: 0;
            order: 2;
            flex-grow: 1;
        }
        .remove-contact-btn {
            background-color: #f44336;
            color: white;
            border: none;
            padding: 4px 8px;
            cursor: pointer;
            order: 1;
        }
        .add-contact-btn {
            background-color: #4CAF50;
            color: white;
            border: none;
            padding: 6px 12px;
            margin-bottom: 10px;
            cursor: pointer;
        }
        .contact-methods-container {
            margin-top: 8px;
        }
        .contact-method-row {
            margin-bottom: 6px;
            padding: 6px;
            border: 1px solid #eee;
           /*background-color: #f5f5f5;*/
            display: flex;
            align-items: center;
            gap: 8px;
        }
        .add-method-btn {
            background-color: #2196F3;
            color: white;
            border: none;
            padding: 4px 8px;
            margin-top: 4px;
            cursor: pointer;
        }
        .remove-method-btn {
            background-color: #f44336;
            color: white;
            border: none;
            padding: 2px 4px;
            cursor: pointer;
        }
        .method-select {
            margin-right: 8px;
            padding: 3px;
        }
        .contact-table {
            margin-bottom: 6px;
        }
        .contact-table td, .contact-table th {
            padding: 4px 6px;
        }
    </style>
</head>
<body class="clear">
<?php // require_once 'panel.php'; ?>
<div id="man_zone">
    <form name="form1" id="form1" method="post" action="customerSave.php<?= $hrefstr ?>">
        <table width="100%" border="0" cellpadding="3" cellspacing="1" class="table1">
            <tbody>
                <tr>
                    <th width="8%">客户编号</th>
                    <td>
                        <input type="text" id="cs_code" name="cs_code" value="<?= htmlspecialcharsFix($customer['cs_code']) ?>" 
                            <?= !empty($customer['cs_claimFrom']) ? 'readonly' : '' ?> class="txt1" />
                        <input type="hidden" name="id" value="<?= $id ?>" />
                        <input type="hidden" name="cs_addtime" value="<?= $customer['cs_addtime'] ?>" />
                        <input type="hidden" name="Permissions" value="<?= $customer['allowedit'] ?>" />
                    </td>
                </tr>
                <tr>
                    <th width="8%">公司名称</th>
                    <td><input type="text" id="cs_company" name="cs_company" value="<?= htmlspecialcharsFix($customer['cs_company']) ?>" class="txt1" /></td>
                </tr>
                <tr>
                    <th width="8%">地区</th>
                    <td>
                        <div class="layui-input-inline">
                            <div class="layui-form-select ySearchSelect y1">
                                <div class="layui-input">
                                    <?php
                                    $stmt = $conn->prepare("SELECT id, countryCode, countryName FROM country WHERE id = ?");
                                    $stmt->bind_param("i", $customer['cs_country']);
                                    $stmt->execute();
                                    $countryResult = $stmt->get_result();
                                    if ($countryRow = $countryResult->fetch_assoc()) {
                                        $countryId = $countryRow['id'];
                                        echo htmlspecialcharsFix($countryRow['countryName']);
                                    } else {
                                        echo "请选择";
                                    }
                                    ?>
                                </div>
                                <ul>
                                    <?php
                                    $result = $conn->query("SELECT id, countryCode, countryName FROM country");
                                    while ($row = $result->fetch_assoc()) {
                                        echo "<li class=\"on\" data-c=\"{$row['id']}\">(+{$row['countryCode']}){$row['countryName']}</li>";
                                    }
                                    ?>
                                    <p>无匹配项</p>
                                </ul>
                                <input name="cs_country" id="cs_country" value="<?= $countryId ?? '' ?>" type="hidden">
                            </div>
                        </div>
                        <script>
                            $(function () {
                                $(".y1").ySearchSelect();  
                            })
                        </script>
                    </td>
                </tr>
                <tr>
                    <th width="8%">客户来源</th>
                    <td>
                        <select id="cs_from" name="cs_from">
                            <option value="0">请选择来源</option>
                            <?php
                            $result = $conn->query("SELECT id, ch_name FROM qudao");
                            while ($row = $result->fetch_assoc()) {
                                $selected = ($customer['cs_from'] == $row['id']) ? ' selected="selected"' : '';
                                echo "<option value=\"{$row['id']}\"$selected>{$row['ch_name']}</option>";
                            }
                            ?>
                        </select>
                    </td>
                </tr>
                <tr>
                    <th width="8%" valign="top">联系人信息</th>
                    <td>
                        <button type="button" class="add-contact-btn">添加联系人</button>
                        
                        <div id="contacts-container">
                            <?php if (!empty($contacts)): ?>
                                <?php foreach ($contacts as $index => $contact): ?>
                                <div class="contact-form" id="contact-form-<?= $index ?>">
                                    <div class="contact-header">
                                        <button type="button" class="remove-contact-btn" data-index="<?= $index ?>">删除</button>
                                        <h3>联系人 #<?= $index + 1 ?></h3>
                                    </div>
                                    <input type="hidden" name="contact[<?= $index ?>][id]" value="<?= $contact['id'] ?>">
                                    <table width="100%" border="0" cellpadding="3" cellspacing="1" class="contact-table">
                                        <tr>
                                            <th width="8%">联系人</th>
                                            <td><input type="text" name="contact[<?= $index ?>][contact_name]" value="<?= htmlspecialcharsFix($contact['contact_name']) ?>" class="txt1" placeholder="联系人姓名"/></td>
                                        </tr>
                                    </table>
                                    <div class="contact-methods-container" id="contact-methods-<?= $index ?>">
                                        <?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-row">';
                                                    echo '<select class="method-select" name="contact[' . $index . '][' . $fieldName . ']" onchange="updateMethodSelectAndPlaceholder(this)">';
                                                    echo '<option value="">请选择联系方式</option>';
                                                    
                                                    foreach ($methodTypes as $optionType => $optionLabel) {
                                                        $selected = ($optionType === $type) ? 'selected' : '';
                                                        echo '<option value="' . $optionType . '" ' . $selected . '>' . $optionLabel . '</option>';
                                                    }
                                                    
                                                    echo '</select>';
                                                    echo '<input type="text" class="txt1 method-input" style="width:60%;" name="contact[' . $index . '][' . $fieldName . ']" value="' . htmlspecialcharsFix($contact[$fieldName]) . '">';
                                                    
                                                    if ($type === 'tel' || $type === 'whatsapp') {
                                                        echo '<input type="hidden" class="format-input" name="contact[' . $index . '][' . $fieldName . '_format]" value="' . htmlspecialcharsFix($contact[$fieldName . '_format']) . '">';
                                                    }
                                                    
                                                    echo '<input type="hidden" class="backup-input" name="contact[' . $index . '][' . $fieldName . '_bu]" value="' . htmlspecialcharsFix($contact[$fieldName . '_bu']) . '">';
                                                    echo '<button type="button" class="remove-method-btn">删除</button>';
                                                    echo '</div>';
                                                }
                                            }
                                        }
                                        ?>
                                    </div>
                                    <button type="button" class="add-method-btn" data-contact-index="<?= $index ?>">添加联系方式</button>
                                </div>
                                <?php endforeach; ?>
                            <?php else: ?>
                                <div class="contact-form" id="contact-form-0">
                                    <div class="contact-header">
                                        <button type="button" class="remove-contact-btn" data-index="0">删除</button>
                                        <h3>联系人 #1</h3>
                                    </div>
                                    <input type="hidden" name="contact[0][id]" value="">
                                    <table width="100%" border="0" cellpadding="3" cellspacing="1" class="contact-table">
                                        <tr>
                                            <th width="8%">联系人</th>
                                            <td><input type="text" name="contact[0][contact_name]" class="txt1" placeholder="联系人姓名"/></td>
                                        </tr>
                                    </table>
                                    <div class="contact-methods-container" id="contact-methods-0">
                                        <!-- Contact methods will be added here -->
                                    </div>
                                    <button type="button" class="add-method-btn" data-contact-index="0">添加联系方式</button>
                                </div>
                            <?php endif; ?>
                        </div>
                    </td>
                </tr>
                <tr>
                    <th width="8%">地址</th>
                    <td><input type="text" id="cs_address" name="cs_address" value="<?= htmlspecialcharsFix($customer['cs_address']) ?>" class="txt1" /></td>
                </tr>
                <tr>
                    <th>业务类型</th>
                    <td>
                        <?php
                        $result = $conn->query("SELECT id, businessType FROM clienttype");
                        while ($row = $result->fetch_assoc()) {
                            $checked = ($row['id'] == $customer['cs_type']) ? ' checked="checked"' : '';
                            echo "<input type=\"radio\" name=\"cs_type\" value=\"{$row['id']}\" id=\"fortype{$row['id']}\"$checked>
                                  <label for=\"fortype{$row['id']}\">{$row['businessType']}</label>";
                        }
                        ?>
                    </td>
                </tr>
                <tr>
                    <th>跟进阶段</th>
                    <td>
                        <?php
                        $dealOptions = [
                            ['id' => '0', 'label' => '无响应'],
                            ['id' => '1', 'label' => '背景调查'],
                            ['id' => '2', 'label' => '明确需求'],
                            ['id' => '3', 'label' => '已成交']
                        ];
                        
                        foreach ($dealOptions as $option) {
                            $checked = ($customer['cs_deal'] == $option['id']) ? ' checked="checked"' : '';
                            $disabled = ($customer['cs_deal'] == '3' && $option['id'] != '3') ? ' disabled="disabled"' : '';
                            echo "<input type=\"radio\" id=\"fordeal{$option['id']}\" class=\"cs_deal\" name=\"cs_deal\" 
                                  value=\"{$option['id']}\"$checked$disabled><label for=\"fordeal{$option['id']}\">{$option['label']}</label>";
                        }
                        ?>
                    </td>
                </tr>
                <tr>
                    <th>其他</th>
                    <td>
                        <input type="checkbox" id="belongClient" class="cs_belongClient" name="cs_belongClient" 
                            value="1"<?= $customer['cs_belongclient'] == 1 ? ' checked="checked"' : '' ?>>
                        <label for="belongClient">客户的客户</label>
                    </td>
                </tr>
                <tr>
                    <th>自定义标签</th>
                    <td>
                        <div class="taglist">
                            <?php
                            $stmt = $conn->prepare("SELECT id, tagName FROM tagtable WHERE customerId = ?");
                            $stmt->bind_param("i", $id);
                            $stmt->execute();
                            $result = $stmt->get_result();
                            while ($row = $result->fetch_assoc()) {
                                echo "<span>" . htmlspecialcharsFix($row['tagName']) . "</span>";
                            }
                            ?>
                        </div>
                        <div class="commontag">
                            <i class="tag">美特柏品牌客户</i>,
                            <i class="tag">OEM定制客户</i>,
                            <i class="tag">小型B端客户</i>,
                            <i class="tag">C端客户</i>,
                            <i class="tag">贸易公司</i>，
                            <i class="tag">档口客户</i>
                            <?php
                            $stmt = $conn->prepare("SELECT DISTINCT tagName FROM tagtable WHERE employeeId = ?");
                            $stmt->bind_param("i", $_SESSION['employee_id']);
                            $stmt->execute();
                            $result = $stmt->get_result();
                            while ($row = $result->fetch_assoc()) {
                                echo "<i class=\"tag\">" . htmlspecialcharsFix(textUncode($row['tagName'])) . "</i>,";
                            }
                            ?>
                        </div>
                        <input type="text" id="tapinput" class="txt-short" placeholder="自定义标签，按Enter添加">
                        <input type="hidden" id="mytag" name="mytag" value="">
                    </td>
                </tr>
                <tr>
                    <th width="8%">备注</th>
                    <td><textarea name="cs_note" class="txt2"><?= htmlspecialcharsFix($customer['cs_note']) ?></textarea></td>
                </tr>
            </tbody>
        </table>
        
        <div class="form-actions">
            <input type="button" name="save" id="save" value="确定" class="btn1" onclick="submitCustomerForm();">
            <input type="button" value="返回" class="btn1" onClick="location.href='customers.php<?= $hrefstr ?>'" />
        </div>
    </form>
</div>
</body>
</html>