igamebox
/
mtb_crm_asp


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

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

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

// 验证并获取订单数据
if (!empty($id) && is_numeric($id)) {
    // 获取订单基本信息
    $employee_id = $_SESSION['employee_id'];
    $sql = "SELECT o.*, c.cs_company, c.cs_code, cc.contact_name 
            FROM orders o 
            LEFT JOIN customer c ON o.customer_id = c.id 
            LEFT JOIN customer_contact cc ON o.contact_id = cc.id 
            WHERE o.id = $id AND o.employee_id = $employee_id";

    $result = mysqli_query($conn, $sql);

    if ($row = mysqli_fetch_assoc($result)) {
        $order = $row;
    } else {
        echo "<script>alert('订单不存在或您没有权限查看');history.back();</script>";
        exit;
    }

    // 获取订单项信息
    $sql = "SELECT oi.*, p.ProductName, pc.name as category_name, 
                   ps.id as product_spec_id, ps.spec_name, ps.spec_value,
                   oi.specification_id  /* 显式获取数据库中的specification_id */
            FROM order_items oi 
            LEFT JOIN products p ON oi.product_id = p.id 
            LEFT JOIN product_categories pc ON p.category_id = pc.id
            LEFT JOIN product_specifications ps ON oi.specification_id = ps.id
            WHERE oi.order_id = $id";

    $itemsResult = mysqli_query($conn, $sql);

    $orderItems = [];
    while ($itemRow = mysqli_fetch_assoc($itemsResult)) {
        // 调试输出
        error_log("订单项数据: " . print_r($itemRow, true));
        $orderItems[] = $itemRow;
    }
} else {
    echo "<script>alert('订单不存在!');history.back();</script>";
    exit;
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<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" />
    <link rel="stylesheet" href="css/alert.css" type="text/css" />
    <script src="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;
        }
        .product-row {
            position: relative;
            padding: 12px 15px;
            padding-right: 40px; /* Add right padding to make room for delete button */
            margin-bottom: 8px;
            border-radius: 4px;
            display: flex;
            align-items: center;
            flex-wrap: wrap;
            gap: 8px;
            background-color: #f9f9f9;
            box-shadow: 0 1px 3px rgba(0,0,0,0.1);
        }
        .delete-product {
            position: absolute;
            right: 10px;
            top: 50%;
            transform: translateY(-50%);
            color: #e74c3c;
            font-weight: bold;
            font-size: 18px;
            cursor: pointer;
            width: 24px;
            height: 24px;
            line-height: 24px;
            text-align: center;
            border-radius: 50%;
            z-index: 5;
        }
        .delete-product:hover {
            background-color: #e74c3c;
            color: white;
        }
        .product-info {
            flex: 2;
            min-width: 200px;
        }
        .product-spec {
            flex: 2;
            min-width: 200px;
        }
        .product-quantity {
            flex: 1;
            min-width: 80px;
        }
        .product-unit {
            flex: 0.5;
            min-width: 60px;
        }
        .product-price {
            flex: 1;
            min-width: 100px;
        }
        .product-total {
            flex: 1;
            min-width: 100px;
            font-weight: bold;
        }
        .product-row input[type="number"] {
            width: 80px;
            padding: 5px;
            border: 1px solid #ddd;
            border-radius: 4px;
        }
        .product-row select {
            width: 100%;
            padding: 5px;
        }
        .selected-product-info {
            font-weight: bold;
            margin-bottom: 3px;
        }
        .row-section {
            display: flex;
            flex-direction: column;
        }
        .row-section-label {
            font-size: 12px;
            color: #666;
            margin-bottom: 3px;
        }
        .row-section-label span {
            display: none; /* 在大屏幕上隐藏标签文本 */
        }
        .spec-info {
            margin-top: 2px;
            font-size: 12px;
            color: #666;
        }
        
        /* 在小屏幕上的响应式布局 */
        @media (max-width: 768px) {
            .product-row {
                flex-direction: column;
                align-items: flex-start;
            }
            .product-info, .product-spec, .product-quantity, 
            .product-unit, .product-price, .product-total {
                width: 100%;
                min-width: 100%;
                margin-bottom: 8px;
            }
            .row-section-label span {
                display: inline; /* 在小屏幕上显示标签文本 */
            }
            .product-list-header {
                display: none !important; /* 在小屏幕上隐藏表头 */
            }
        }
        .add-product-btn {
            background-color: #4CAF50;
            color: white;
            padding: 10px 15px;
            border: none;
            border-radius: 4px;
            cursor: pointer;
            margin-bottom: 15px;
            font-size: 14px;
            display: flex;
            align-items: center;
            justify-content: center;
            gap: 8px;
            transition: background-color 0.2s;
            box-shadow: 0 2px 5px rgba(0,0,0,0.1);
        }
        .add-product-btn:hover {
            background-color: #45a049;
        }
        .total-section {
            margin-top: 20px;
            padding: 10px;
            background-color: #eee;
            font-weight: bold;
        }
        #product-container {
            margin-bottom: 20px;
        }
        .productlist {
            display: none;
            position: absolute;
            background: white;
            border: 1px solid #ccc;
            max-height: 200px;
            overflow-y: auto;
            width: 100%;
            z-index: 1000;
            box-shadow: 0 3px 8px rgba(0,0,0,0.25);
            border-radius: 0 0 4px 4px;
            top: 100%;
            left: 0;
        }
        .productlist ul {
            list-style: none;
            padding: 0;
            margin: 0;
        }
        .productlist li {
            padding: 10px 12px;
            cursor: pointer;
            border-bottom: 1px solid #eee;
            transition: background-color 0.2s;
        }
        .productlist li:hover {
            background-color: #f0f0f0;
        }
        .productlist li:last-child {
            border-bottom: none;
        }
        .productinput {
            position: relative;
        }
        .productlist li .category-tag {
            color: #777;
            font-size: 12px;
            font-style: italic;
            margin-left: 5px;
        }
        /* Specification select styling */
        .spec-select {
            width: 100%;
            padding: 6px;
            margin-top: 5px;
            border: 1px solid #ccc;
            border-radius: 4px;
        }
        .spec-select:disabled {
            background-color: #f9f9f9;
        }
        .spec-price {
            font-weight: bold;
            color: #d9534f;
        }
        
        /* 客户选择样式 */
        .customer-search-container {
            display: flex;
            align-items: center;
            margin-bottom: 10px;
            position: relative;
            width: 60%;
        }
        .customer-dropdown {
            display: none;
            position: absolute;
            background: white;
            border: 1px solid #ccc;
            max-height: 200px;
            overflow-y: auto;
            width: 100%;
            z-index: 1000;
            box-shadow: 0 3px 8px rgba(0,0,0,0.25);
            border-radius: 0 0 4px 4px;
            top: 100%;
            left: 0;
        }
        .customer-item {
            padding: 10px 12px;
            cursor: pointer;
            border-bottom: 1px solid #eee;
            transition: background-color 0.2s;
        }
        .customer-item:hover {
            background-color: #f0f0f0;
        }
        .customer-item:last-child {
            border-bottom: none;
        }
        .selected-customer-info {
            font-weight: bold;
            padding: 8px 10px;
            border: 1px solid #ddd;
            background-color: #f9f9f9;
            display: none;
            width: 100%;
            box-sizing: border-box;
            word-break: break-all;
            overflow: hidden;
            text-overflow: ellipsis;
            white-space: normal;
            min-height: 38px;
            cursor: pointer;
        }
        .selected-customer-info:hover {
            background-color: #f0f0f0;
        }
        .customer-clear-btn {
            margin-left: 5px;
            color: #e74c3c;
            font-weight: bold;
            cursor: pointer;
            float: right;
        }
        .customer-clear-btn:hover {
            color: #c0392b;
        }
    </style>
</head>
<body>
<div id="man_zone">
    <form name="form1" id="form1" method="post" action="order_save.php?<?= $hrefstr ?>" onsubmit="return validateOrderForm()">
        <table width="100%" border="0" cellpadding="3" cellspacing="1" class="table1">
            <tbody>
            <tr>
                <th width="8%">销售订单号</th>
                <td>
                    <input type="text" id="order_code" name="order_code" value="<?= htmlspecialcharsFix($order['order_code']) ?>" class="txt1" />
                    <input type="hidden" name="id" value="<?= $id ?>" />
                </td>
            </tr>
            <tr>
                <th width="8%">客户选择</th>
                <td>
                    <div class="customer-search-container">
                        <input type="text" id="customer_search" class="customer-search txt1" data-type="customer" placeholder="输入客户编码或名称搜索..." style="width: 100%;" value="<?= htmlspecialcharsFix(isset($order['cs_code']) && $order['cs_code'] ? $order['cs_code'] . ' - ' . $order['cs_company'] : $order['cs_company']) ?>">
                        <div id="customer_dropdown" class="customer-dropdown"></div>
                        <div id="customer_selected" class="selected-customer-info" style="display: block;" title="<?= htmlspecialcharsFix(isset($order['cs_code']) && $order['cs_code'] ? $order['cs_code'] . ' - ' . $order['cs_company'] : $order['cs_company']) ?>">
                            <?= htmlspecialcharsFix(isset($order['cs_code']) && $order['cs_code'] ? $order['cs_code'] . ' - ' . $order['cs_company'] : $order['cs_company']) ?>
                            <span class="customer-clear-btn" data-type="customer">X</span>
                        </div>
                        <input type="hidden" name="customer_id" id="customer_id" value="<?= $order['customer_id'] ?>">
                    </div>
                </td>
            </tr>
            <tr>
                <th width="8%">出货日期</th>
                <td>
                    <input type="date" id="order_date" name="order_date" value="<?= substr($order['order_date'], 0, 10) ?>" class="txt1" />
                </td>
            </tr>
            <tr>
                <th width="8%" valign="top">产品列表</th>
                <td>
                    <button type="button" id="add-product-btn" class="add-product-btn">添加产品</button>
                    
                    <div class="product-list-header" style="display: flex; background-color: #eee; padding: 8px 15px; margin-bottom: 10px; border-radius: 4px; font-weight: bold; color: #555; font-size: 13px; gap: 8px;">
                        <div style="flex: 2; min-width: 200px;">产品</div>
                        <div style="flex: 2; min-width: 200px;">规格</div>
                        <div style="flex: 1; min-width: 80px;">数量</div>
                        <div style="flex: 0.5; min-width: 60px;">单位</div>
                        <div style="flex: 1; min-width: 100px;">单价</div>
                        <div style="flex: 1; min-width: 100px;">总价</div>
                    </div>
                    
                    <div id="product-container">
                        <?php foreach ($orderItems as $index => $item): ?>
                            <div class="product-row" data-index="<?= $index ?>">
                                <span class="delete-product">×</span>
                                
                                <div class="row-section product-info">
                                    <div class="row-section-label"><span>产品</span></div>
                                        <input type="hidden" name="items[<?= $index ?>][product_id]" class="product-id-input" value="<?= $item['product_id'] ?>">
                                    <input type="text" class="product-search" placeholder="输入产品名称搜索..." style="width: 100%; padding: 5px; border: 1px solid #ddd; border-radius: 4px; display: none;">
                                    <div class="productlist" style="width: 100%; max-height: 200px;"><ul></ul></div>
                                    <div class="selected-product-info" style="cursor: pointer;" title="点击重新选择产品">
                                            <?= htmlspecialcharsFix($item['ProductName'] ?? '') ?>
                                            <?php if (!empty($item['category_name'])): ?>
                                            <span class="category-tag">(<?= htmlspecialcharsFix($item['category_name']) ?>)</span>
                                            <?php endif; ?>
                                        </div>
                                    </div>
                                
                                <div class="row-section product-spec">
                                    <div class="row-section-label"><span>规格</span></div>
                                    <input type="hidden" name="items[<?= $index ?>][spec_id]" class="spec-id-input" value="<?= $item['specification_id'] ?? 0 ?>">
                                    <!-- 规格选择框将在加载产品时填充 -->
                                    <select class="spec-select" name="items[<?= $index ?>][spec_select]" style="display: none;">
                                        <option value="">请选择规格</option>
                                    </select>
                                    <div class="spec-info" style="cursor: pointer;" title="点击修改规格">
                                        <?php if (!empty($item['spec_name'])): ?>
                                            <?= htmlspecialcharsFix($item['spec_name']) ?>: <?= htmlspecialcharsFix($item['spec_value'] ?? '') ?>
                                        <?php endif; ?>
                                    </div>
                                </div>
                                
                                <div class="row-section product-quantity">
                                    <div class="row-section-label"><span>数量</span></div>
                                    <input type="number" name="items[<?= $index ?>][quantity]" value="<?= $item['quantity'] ?>" min="1" class="quantity-input" onchange="calculateItemTotal(this)">
                                </div>

                                <div class="row-section product-unit">
                                    <div class="row-section-label"><span>单位</span></div>
                                    <span class="unit-label"><?= htmlspecialcharsFix($item['unit']) ?></span>
                                    <input type="hidden" name="items[<?= $index ?>][unit]" value="<?= htmlspecialcharsFix($item['unit']) ?>" class="unit-input">
                                </div>
                                
                                <div class="row-section product-price">
                                    <div class="row-section-label"><span>单价</span></div>
                                    <input type="number" step="0.01" name="items[<?= $index ?>][unit_price]" value="<?= $item['unit_price'] ?>" class="price-input" onchange="calculateItemTotal(this)">
                    </div>
                    
                                <div class="row-section product-total">
                                    <div class="row-section-label"><span>总价</span></div>
                                    <span class="total-price-display" style="display: inline-block; background-color: #f0f0f0; border: 1px solid #ddd; padding: 2px 8px; min-width: 60px; text-align: right;"><?= number_format($item['total_price'], 2) ?></span>
                                    <input type="hidden" name="items[<?= $index ?>][total_price]" value="<?= $item['total_price'] ?>" class="total-price-input">
                                </div>
                                
                                <!-- 保留隐藏的折扣字段以便后端兼容 -->
                                <input type="hidden" name="items[<?= $index ?>][discount_amount]" value="0" class="discount-amount-input">
                                <input type="hidden" name="items[<?= $index ?>][discount_percent]" value="0" class="discount-percent-input">
                                <input type="hidden" name="items[<?= $index ?>][notes]" value="<?= htmlspecialcharsFix($item['notes'] ?? '') ?>">
                            </div>
                        <?php endforeach; ?>
                        <!-- 产品行将通过搜索添加 -->
                        <?php if (count($orderItems) == 0): ?>
                        <div id="no-products-message" style="padding: 15px; text-align: center; color: #777; background-color: #f5f5f5; border: 1px dashed #ddd; border-radius: 4px; margin-bottom: 15px; display: block;">
                            <i class="fa fa-info-circle"></i> 请点击"添加产品"按钮添加产品
                        </div>
                        <?php endif; ?>
                    </div>
                    <div class="total-section" style="margin-top: 20px; padding: 15px; background-color: #f5f5f5; border-radius: 4px; box-shadow: 0 1px 3px rgba(0,0,0,0.1);">
                        <div style="display: flex; justify-content: flex-end; align-items: center;">
                            <label style="font-size: 16px; margin-right: 10px;">订单总额：</label>
                            <span id="total-amount" style="font-size: 18px; font-weight: bold; color: #e74c3c;"><?= number_format($order['total_amount'], 2) ?></span>
                            <input type="hidden" name="total_amount" id="total-amount-input" value="<?= $order['total_amount'] ?>">
                            <input type="hidden" name="subtotal" id="subtotal-input" value="<?= $order['subtotal'] ?>">
                            <input type="hidden" name="discount_amount" id="order-discount" value="0">
                        </div>
                    </div>
                </td>
            </tr>
            <tr>
                <th width="8%">订单备注</th>
                <td>
                    <textarea name="notes" rows="3" style="width: 90%;"><?= htmlspecialcharsFix($order['notes']) ?></textarea>
                </td>
            </tr>
            <tr>
                <th></th>
                <td>
                    <input type="submit" name="save" value="保存订单" class="btn1">
                    <input type="button" value="返回" class="btn1" onClick="location.href='order.php?<?= $hrefstr ?>'" />
                </td>
            </tr>
            </tbody>
        </table>
    </form>

    <script>
        var productIndex = <?= count($orderItems) ?>;

        $(document).ready(function() {
            // 初始化计算
            calculateOrderTotal();
            
            // 初始化无产品消息
            updateNoProductsMessage();
            
            // 初始化现有产品的规格选择
            $('.product-row').each(function() {
                var row = $(this);
                var productId = row.find('.product-id-input').val();
                var specId = row.find('.spec-id-input').val();
                console.log("初始化行 - 行索引:", row.data('index'), "产品ID:", productId, "规格ID:", specId);
                
                if (productId) {
                    // 加载产品规格
                    getProductSpecifications(productId, row);
                }
            });
            
            // 隐藏搜索框，因为已经选择了客户
            $('#customer_search').hide();
            
            // 客户搜索功能
            var customerSearchTimeout = null;
            var customerIsComposing = false;
            
            // 监听输入法组合事件
            $(document).on('compositionstart', '.customer-search', function() {
                customerIsComposing = true;
            });

            $(document).on('compositionend', '.customer-search', function() {
                customerIsComposing = false;
                $(this).trigger('input'); // 手动触发一次input事件
            });
            
            // 客户搜索输入处理
            $(document).on('input', '#customer_search', function() {
                // 如果是输入法正在组合中文，不处理
                if (customerIsComposing) return;
                
                var $this = $(this);
                var searchTerm = $this.val().trim();
                var customerDropdown = $('#customer_dropdown');
                
                // 清除之前的超时
                clearTimeout(customerSearchTimeout);
                
                // 隐藏之前的结果
                customerDropdown.hide().empty();
                
                // 清除之前的选择
                $('#customer_id').val('0');
                $('#customer_selected').hide();
                
                // 如果搜索词少于1个字符，不执行搜索
                if (searchTerm.length < 1) {
                    return;
                }
                
                // 设置一个300毫秒的超时，以减少请求数量
                customerSearchTimeout = setTimeout(function() {
                    $.ajax({
                        url: 'get_customer_search.php',
                        type: 'GET',
                        data: {search: searchTerm},
                        dataType: 'json',
                        success: function(data) {
                            customerDropdown.empty();
                            
                            if (data && data.customers && data.customers.length > 0) {
                                $.each(data.customers, function(i, customer) {
                                    var displayText = customer.cs_company;
                                    if (customer.cs_code) {
                                        displayText = customer.cs_code + ' - ' + displayText;
                                    }
                                    
                                    var item = $('<div class="customer-item"></div>')
                                        .attr('data-id', customer.id)
                                        .attr('data-company', customer.cs_company)
                                        .attr('data-display', displayText)
                                        .text(displayText);
                                    
                                    customerDropdown.append(item);
                                });
                                customerDropdown.show();
                            }
                        },
                        error: function() {
                            console.log('搜索客户失败，请重试');
                        }
                    });
                }, 300);
            });
            
            // 点击选择客户
            $(document).on('click', '.customer-item', function() {
                var $this = $(this);
                var customerId = $this.data('id');
                var customerName = $this.data('company');
                var displayText = $this.data('display');
                
                // 设置选中的客户ID和名称
                $('#customer_id').val(customerId);
                $('#customer_search').hide();
                $('#customer_selected').text(displayText).append('<span class="customer-clear-btn" data-type="customer">X</span>').show();
                
                // 添加标题属性，便于查看完整信息
                $('#customer_selected').attr('title', displayText);
                
                // 隐藏下拉菜单
                $('#customer_dropdown').hide();
            });
            
            // 点击X按钮清除选择的客户
            $(document).on('click', '.customer-clear-btn', function(e) {
                e.stopPropagation();
                
                // 显示搜索框，隐藏已选信息
                $('#customer_search').val('').show();
                $('#customer_selected').hide();
                
                // 清空客户ID
                $('#customer_id').val('0');
            });
            
            // 点击其他地方隐藏下拉列表
            $(document).on('click', function(e) {
                if (!$(e.target).closest('.customer-search-container').length) {
                    $('#customer_dropdown').hide();
                }
            });
            
            // 添加产品行按钮点击事件
            $('#add-product-btn').on('click', function() {
                addEmptyProductRow();
                updateNoProductsMessage();
            });
            
            // 删除产品行
            $(document).on('click', '.delete-product', function() {
                if ($('.product-row').length > 1) {
                    $(this).closest('.product-row').remove();
                    reindexProductRows();
                    calculateOrderTotal();
                    updateNoProductsMessage();
                } else {
                    // 如果只剩最后一个产品行，则清空它而不是删除
                    $(this).closest('.product-row').remove();
                    updateNoProductsMessage();
                    calculateOrderTotal(); // 确保在删除最后一个产品时也更新总额
                }
            });

            // 产品搜索框聚焦时显示搜索提示
            $(document).on('focus', '.product-search', function() {
                // 隐藏所有已打开的产品搜索列表
                $('.productlist').hide();
                
                // 当前搜索框的值
                var searchTerm = $(this).val().trim();
                if (searchTerm.length >= 2) {
                    // 找到当前行的产品列表并显示
                    $(this).siblings('.productlist').show();
                }
            });
            
            // 产品搜索功能 - 行内搜索
            var productSearchTimeouts = {};
            $(document).on('keyup', '.product-search', function() {
                var $this = $(this);
                var rowIndex = $this.closest('.product-row').data('index');
                var searchTerm = $this.val().trim();
                var productList = $this.siblings('.productlist');
                
                // 清除之前的超时
                clearTimeout(productSearchTimeouts[rowIndex]);
                
                // 隐藏之前的结果
                productList.hide();
                
                // 如果搜索词少于2个字符，不执行搜索
                if (searchTerm.length < 2) {
                    return;
                }
                
                // 设置一个300毫秒的超时，以减少请求数量
                productSearchTimeouts[rowIndex] = setTimeout(function() {
                    $.ajax({
                        url: 'get_product_info.php',
                        type: 'GET',
                        data: {search: searchTerm},
                        dataType: 'json',
                        success: function(data) {
                            var ul = productList.find('ul');
                            ul.empty();
                            
                            if (data && data.products && data.products.length > 0) {
                                $.each(data.products, function(i, product) {
                                    ul.append('<li data-id="' + product.id + '">' + 
                                              product.ProductName + 
                                              (product.category_name ? ' <span class="category-tag">(' + product.category_name + ')</span>' : '') + 
                                              '</li>');
                                });
                                productList.show();
                            }
                        },
                        error: function() {
                            console.log('搜索产品失败，请重试');
                        }
                    });
                }, 300);
            });
            
            // 点击选择产品 - 行内搜索结果
            $(document).on('click', '.productlist li', function() {
                var $this = $(this);
                var productId = $this.data('id');
                var productName = $this.text(); // 这会包含分类名，需要清理
                var categoryTag = $this.find('.category-tag').text();
                var row = $this.closest('.product-row');
                
                // 清理产品名称，移除分类信息
                if (categoryTag) {
                    productName = productName.replace(categoryTag, '').trim();
                }
                
                // 设置产品ID和名称
                row.find('.product-id-input').val(productId);
                row.find('.product-search').hide();
                
                // 显示包含分类的完整产品信息
                var displayName = productName;
                if (categoryTag) {
                    displayName += ' <span class="category-tag">' + categoryTag + '</span>';
                }
                row.find('.selected-product-info').html(displayName).show();
                
                // 隐藏产品搜索结果
                row.find('.productlist').hide();
                
                // 获取产品规格信息
                getProductSpecifications(productId, row);
            });
            
            // 规格选择改变事件
            $(document).on('change', '.spec-select', function() {
                var $this = $(this);
                var row = $this.closest('.product-row');
                var specId = $this.val();
                var specData = $this.find('option:selected').data();
                
                if (specId) {
                    // 检查是否已存在相同的产品规格组合
                    var isDuplicate = false;
                    $('.spec-select').not($this).each(function() {
                        if ($(this).val() == specId) {
                            isDuplicate = true;
                            return false; // 跳出循环
                        }
                    });
                    
                    if (isDuplicate) {
                        alert('该产品规格已添加，不能重复添加');
                        $this.val(''); // 重置选择
                        return;
                    }
                    
                    // 设置规格ID到隐藏字段
                    row.find('.spec-id-input').val(specId);
                    
                    // 获取选中项的文本内容作为显示信息
                    var displayText = $this.find('option:selected').text();
                    row.find('.spec-info').html(displayText).show();
                    
                    // 隐藏下拉框
                    $this.hide();
                    
                    // 存储规格价格作为最低价格限制
                    var minPrice = specData.price || 0;
                    var priceInput = row.find('.price-input');
                    priceInput.attr('data-min-price', minPrice);
                    if (minPrice > 0) {
                        priceInput.attr('placeholder', '输入单价');
                    } else {
                        priceInput.attr('placeholder', '输入单价');
                    }
                    
                    // 设置最小订购数量
                    var minQty = specData.minQty || 1;
                    var qtyInput = row.find('.quantity-input');
                    if (parseInt(qtyInput.val()) < minQty) {
                        qtyInput.val(minQty);
                    }
                    qtyInput.attr('min', minQty);
                    
                    // 重新计算总价
                    calculateItemTotal(row.find('.price-input')[0]);
                } else {
                    // 清除规格相关信息
                    row.find('.spec-id-input').val('');
                    row.find('.price-input').attr('data-min-price', '0').attr('placeholder', '输入单价');
                    row.find('.spec-info').html('').hide();
                    calculateItemTotal(row.find('.price-input')[0]);
                }
            });
            
            // 点击其他地方隐藏下拉列表
            $(document).on('click', function(e) {
                if (!$(e.target).closest('.product-search').length && !$(e.target).closest('.productlist').length) {
                    $('.productlist').hide();
                }
                if (!$(e.target).closest('.customer-search-container').length) {
                    $('#customer_dropdown').hide();
                }
            });
            
            // 点击已选产品名显示的标签时，切换回搜索模式
            $(document).on('click dblclick', '.selected-product-info', function() {
                var row = $(this).closest('.product-row');
                var productId = row.find('.product-id-input').val();
                
                // 只有当已经选择了产品时才允许重新选择
                if (productId) {
                    if (confirm('确定要重新选择产品吗？这将清除当前选择的产品及其规格信息。')) {
                        // 清空产品ID和选择的规格
                        row.find('.product-id-input').val('');
                        row.find('.spec-id-input').val('');
                        
                        // 隐藏产品信息，显示搜索框
                        $(this).hide();
                        row.find('.product-search').val('').show();
                        
                        // 隐藏并清空规格选择
                        row.find('.spec-select').hide().empty();
                        row.find('.spec-info').html('');
                        
                        // 清除单位信息
                        row.find('.unit-input').val('');
                        row.find('.unit-label').text('');
                        
                        // 清除价格信息并重新计算总额
                        row.find('.price-input').val('');
                        calculateItemTotal(row.find('.price-input')[0]);
                    }
                }
            });
            
            // 点击规格信息时显示规格选择下拉框
            $(document).on('click', '.spec-info', function() {
                var row = $(this).closest('.product-row');
                var specSelect = row.find('.spec-select');
                
                if (specSelect.find('option').length > 1) {
                    // 隐藏规格信息，显示规格选择下拉框
                    $(this).hide();
                    specSelect.show().focus();
                }
            });
        });

        function addEmptyProductRow() {
            var html = `
            <div class="product-row" data-index="${productIndex}">
                <span class="delete-product">×</span>
                
                <div class="row-section product-info">
                    <div class="row-section-label"><span>产品</span></div>
                    <input type="hidden" name="items[${productIndex}][product_id]" class="product-id-input" value="">
                    <input type="text" class="product-search" placeholder="输入产品名称搜索..." style="width: 100%; padding: 5px; border: 1px solid #ddd; border-radius: 4px;">
                    <div class="productlist" style="width: 100%; max-height: 200px;"><ul></ul></div>
                    <div class="selected-product-info" style="cursor: pointer; display: none;" title="点击重新选择产品"></div>
                </div>
                
                <div class="row-section product-spec">
                    <div class="row-section-label"><span>规格</span></div>
                    <input type="hidden" name="items[${productIndex}][spec_id]" class="spec-id-input" value="">
                    <select class="spec-select" name="items[${productIndex}][spec_select]" style="display: none;">
                        <option value="">请选择规格</option>
                    </select>
                    <div class="spec-info" style="cursor: pointer;" title="点击修改规格"></div>
                </div>
                
                <div class="row-section product-quantity">
                    <div class="row-section-label"><span>数量</span></div>
                    <input type="number" name="items[${productIndex}][quantity]" value="1" min="1" class="quantity-input" onchange="calculateItemTotal(this)">
                </div>
                
                <div class="row-section product-unit">
                    <div class="row-section-label"><span>单位</span></div>
                    <span class="unit-label" style="display: inline-block; padding: 2px 5px; min-width: 30px;"></span>
                    <input type="hidden" name="items[${productIndex}][unit]" class="unit-input" value="">
                </div>
                
                <div class="row-section product-price">
                    <div class="row-section-label"><span>单价</span></div>
                    <input type="number" step="0.01" name="items[${productIndex}][unit_price]" value="" class="price-input" placeholder="输入单价" onchange="calculateItemTotal(this)">
                </div>
                
                <div class="row-section product-total">
                    <div class="row-section-label"><span>总价</span></div>
                    <span class="total-price-display" style="display: inline-block; background-color: #f0f0f0; border: 1px solid #ddd; padding: 2px 8px; min-width: 60px; text-align: right;">0.00</span>
                    <input type="hidden" name="items[${productIndex}][total_price]" value="0.00" class="total-price-input">
                </div>
                
                <!-- 保留隐藏的字段以便后端兼容 -->
                <input type="hidden" name="items[${productIndex}][discount_amount]" value="0" class="discount-amount-input">
                <input type="hidden" name="items[${productIndex}][discount_percent]" value="0" class="discount-percent-input">
                <input type="hidden" name="items[${productIndex}][notes]" value="">
            </div>
            `;

            $('#product-container').append(html);
            productIndex++;
            return productIndex - 1; // 返回新添加行的索引
        }
        
        function addProductRowWithProduct(productId, productName, categoryTag) {
            // 添加空行
            var rowIndex = addEmptyProductRow();
            var row = $('.product-row[data-index="' + rowIndex + '"]');
            
            // 设置产品ID和名称
            row.find('.product-id-input').val(productId);
            
            // 显示包含分类的完整产品信息
            var displayName = productName;
            if (categoryTag) {
                displayName += ' <span class="category-tag">' + categoryTag + '</span>';
            }
            row.find('.selected-product-info').html(displayName).show();
            row.find('.product-search').hide();
            
            // 获取产品规格信息
            getProductSpecifications(productId, row);
            
            // 更新无产品消息显示
            updateNoProductsMessage();
        }

        function reindexProductRows() {
            $('.product-row').each(function(index) {
                $(this).attr('data-index', index);
                $(this).find('select, input').each(function() {
                    var name = $(this).attr('name');
                    if (name) {
                        name = name.replace(/items\[\d+\]/, 'items[' + index + ']');
                        $(this).attr('name', name);
                    }
                });
            });
            productIndex = $('.product-row').length;
        }

        function getProductSpecifications(productId, row) {
            if (!productId) return;
            
            // 获取当前选中的规格ID（如果有的话）
            var currentSpecId = row.find('.spec-id-input').val();
            console.log("加载规格 - 产品ID:", productId, "当前规格ID:", currentSpecId);
            
            $.ajax({
                url: 'get_product_info.php',
                type: 'GET',
                data: {product_id: productId},
                dataType: 'json',
                success: function(data) {
                    if (data && data.product && data.specifications) {
                        console.log("获取到规格数据:", data.specifications);
                        // 设置单位信息
                        if (data.product.unit) {
                            row.find('.unit-input').val(data.product.unit);
                            row.find('.unit-label').text(data.product.unit);
                        }
                        
                        // 处理规格信息
                        var specifications = data.specifications;
                        console.log("获取到的规格列表详情:", JSON.stringify(specifications)); // 打印完整的规格对象
                        if (specifications.length === 0) {
                            // 如果是编辑现有产品，不显示警告
                            if (!currentSpecId) {
                                alert('此产品没有规格信息，请添加规格后再选择');
                                // 重置产品选择
                                row.find('.product-id-input').val('');
                                row.find('.selected-product-info').hide();
                                row.find('.product-search').val('').show();
                            }
                            return;
                        }
                        
                        // 填充规格选择下拉框
                        var specSelect = row.find('.spec-select');
                        specSelect.empty();
                        specSelect.append('<option value="">请选择规格</option>');
                        
                        var foundSelectedSpec = false;
                        
                        $.each(specifications, function(i, spec) {
                            var displayText = spec.spec_name + ': ' + spec.spec_value;
                            if (spec.price) {
                                displayText += ' (¥' + spec.price + ')';
                            }
                            
                            var option = $('<option></option>')
                                .attr('value', spec.id)
                                .text(displayText)
                                .data('price', spec.price)
                                .data('minQty', spec.min_order_quantity)
                                .data('code', spec.spec_code);
                            
                            // 如果是当前选中的规格，设置selected属性
                            if (currentSpecId && parseInt(spec.id) === parseInt(currentSpecId)) {
                                console.log("找到匹配的规格 - 规格ID:", spec.id, "当前规格ID:", currentSpecId, 
                                           "规格名称:", spec.spec_name, "规格值:", spec.spec_value);
                                option.prop('selected', true);
                                foundSelectedSpec = true;
                                
                                // 更新规格信息显示
                                row.find('.spec-info').html(displayText);
                                
                                // 设置参考价格
                                var priceInput = row.find('.price-input');
                                priceInput.attr('data-min-price', spec.price || 0);
                            } else {
                                console.log("规格不匹配 - 规格ID:", spec.id, "当前规格ID:", currentSpecId, 
                                           "类型:", typeof spec.id, typeof currentSpecId);
                            }
                            
                            specSelect.append(option);
                        });
                        
                        // 显示规格选择下拉框并隐藏spec-info
                        if (!currentSpecId || !foundSelectedSpec) {
                            // 如果没有选中规格，显示下拉框
                            specSelect.show();
                            row.find('.spec-info').hide();
                        } else {
                            // 如果已选中规格，显示规格信息
                            specSelect.hide();
                            row.find('.spec-info').show();
                        }
                        
                        // 如果在规格列表中找不到已选择的规格
                        if (currentSpecId && !foundSelectedSpec) {
                            console.log("在规格列表中找不到已选择的规格ID:", currentSpecId);
                            // 不清除规格ID，保留数据库中的值
                            // row.find('.spec-id-input').val('');
                            
                            // 隐藏规格选择下拉框，保留现有规格信息
                            specSelect.hide();
                            row.find('.spec-info').show();
                        }
                    } else {
                        // 如果是编辑现有产品，不显示警告
                        if (!currentSpecId) {
                            alert('获取产品规格失败');
                            // 重置产品选择
                            row.find('.product-id-input').val('');
                            row.find('.selected-product-info').hide();
                            row.find('.product-search').val('').show();
                        }
                    }
                },
                error: function() {
                    // 如果是编辑现有产品，不显示警告
                    if (!currentSpecId) {
                        alert('获取产品规格失败，请重试');
                        // 重置产品选择
                        row.find('.product-id-input').val('');
                        row.find('.selected-product-info').hide();
                        row.find('.product-search').val('').show();
                    }
                }
            });
        }

        function getProductInfo(productId, row) {
            if (!productId) return;
            
            $.ajax({
                url: 'get_product_info.php',
                type: 'GET',
                data: {id: productId},
                dataType: 'json',
                success: function(data) {
                    if (data) {
                        row.find('.unit-input').val(data.unit);
                        row.find('.unit-label').text(data.unit);
                        // 只有当数据库中有价格信息时才设置价格
                        if (data.price && data.price !== '0' && data.price !== '0.00') {
                            //默认不设置单价
                            //row.find('.price-input').val(data.price);
                        }
                        calculateItemTotal(row.find('.price-input')[0]);
                    }
                }
            });
        }

        function calculateItemTotal(element) {
            var row = $(element).closest('.product-row');
            var quantity = parseInt(row.find('.quantity-input').val()) || 0;
            var priceInput = row.find('.price-input');
            var priceValue = priceInput.val().trim();
            var price = (priceValue === '') ? 0 : (parseFloat(priceValue) || 0);

            var total = quantity * price;
            if (total < 0) total = 0;

            // 更新显示元素和隐藏输入框
            row.find('.total-price-display').text(total.toFixed(2));
            row.find('.total-price-input').val(total.toFixed(2));

            calculateOrderTotal();
        }

        function calculateOrderTotal() {
            var total = 0;
            $('.total-price-input').each(function() {
                total += parseFloat($(this).val()) || 0;
            });

            // 更新总额和隐藏的小计字段
            $('#total-amount').text(total.toFixed(2));
            $('#total-amount-input').val(total.toFixed(2));
            $('#subtotal-input').val(total.toFixed(2)); // 为兼容性保留
        }

        function validateOrderForm() {
            var orderCode = $('#order_code').val();
            var customerId = $('#customer_id').val();
            var customerName = $('#customer_search').val() || $('#customer_selected').text().trim();
            var hasProducts = false;
            var allSpecsSelected = true;
            var allPricesValid = true;
            var allPricesHighEnough = true;
            var firstInvalidField = null;

            // 检查是否有产品行
            if ($('.product-row').length === 0) {
                alert('请至少添加一个产品');
                $('#add-product-btn').focus();
                return false;
            }

            $('.product-row').each(function() {
                var productId = $(this).find('.product-id-input').val();
                var specId = $(this).find('.spec-id-input').val();
                var priceInput = $(this).find('.price-input');
                var priceValue = priceInput.val().trim();
                var price = parseFloat(priceValue) || 0;
                var minPrice = parseFloat(priceInput.attr('data-min-price')) || 0;
                var specSelect = $(this).find('.spec-select');
                var productSearch = $(this).find('.product-search');
                
                // 检查产品是否已选择
                if (!productId) {
                    if (!firstInvalidField) {
                        firstInvalidField = productSearch;
                    }
                    return true; // continue
                }
                
                hasProducts = true;
                
                // 检查规格是否已选择
                if (!specId && specSelect.is(':visible')) {
                    allSpecsSelected = false;
                    if (!firstInvalidField) {
                        firstInvalidField = specSelect;
                    }
                }
                
                // 检查单价是否有效
                if (priceValue === '' || isNaN(parseFloat(priceValue))) {
                    allPricesValid = false;
                    if (!firstInvalidField) {
                        firstInvalidField = priceInput;
                    }
                }
                
                // 检查单价是否大于等于规格价格
                if (minPrice > 0 && price < minPrice) {
                    allPricesHighEnough = false;
                    if (!firstInvalidField) {
                        firstInvalidField = priceInput;
                    }
                }
            });

            if (!orderCode) {
                alert('销售订单号不能为空');
                $('#order_code').focus();
                return false;
            }

            if (!customerId || customerId == '0') {
                alert('请选择客户');
                $('#customer_search').focus();
                return false;
            }

            if (!customerName) {
                alert('客户名称不能为空');
                $('#customer_search').focus();
                return false;
            }
            
            if (!hasProducts) {
                alert('请至少添加一个有效的产品');
                if (firstInvalidField) {
                    firstInvalidField.focus();
                } else {
                    $('#add-product-btn').focus();
                }
                return false;
            }
            
            if (!allSpecsSelected) {
                alert('请为所有产品选择规格');
                if (firstInvalidField) {
                    firstInvalidField.focus();
                }
                return false;
            }
            
            if (!allPricesValid) {
                alert('请为所有产品输入有效的单价');
                if (firstInvalidField) {
                    firstInvalidField.focus();
                }
                return false;
            }
            
            if (!allPricesHighEnough) {
                alert('单价不能低于规格设定的参考价格');
                if (firstInvalidField) {
                    firstInvalidField.focus();
                }
                return false;
            }

            return true;
        }
        
        function updateNoProductsMessage() {
            if ($('.product-row').length > 0) {
                $('#no-products-message').hide();
            } else {
                $('#no-products-message').show();
            }
        }
    </script>
</div>
</body>
</html>