igamebox
/
mtb_crm_asp


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290
							<?php
require_once('conn.php');
require_once('functions.php');

// Check login status
checkLogin("信息管理");

// Initialize variables
$id = isset($_GET['id']) ? (int)$_GET['id'] : 0;
$keys = isset($_GET['Keys']) ? urlencode($_GET['Keys']) : '';
$page = isset($_GET['Page']) ? $_GET['Page'] : 1;
$category_id = isset($_GET['category_id']) ? intval($_GET['category_id']) : 0;

// Get the return URL
$href_str = "products.php?keys=" . $keys . "&Page=" . $page;
if ($category_id) {
    $href_str .= "&category_id=" . $category_id;
}

// Check if the product exists
if ($id <= 0) {
    header("Location: " . $href_str);
    exit();
}

// Fetch product data
$sql = "SELECT * FROM products WHERE id = " . (int)$id;
$result = mysqli_query($conn, $sql);

if (mysqli_num_rows($result) <= 0) {
    // Product not found, redirect
    header("Location: " . $href_str);
    exit();
}

$row = mysqli_fetch_assoc($result);
$product_name = htmlspecialcharsFix($row['ProductName']);
$product_img = htmlspecialcharsFix($row['ProductImg']);
$unit = htmlspecialcharsFix($row['unit']);
$moq = htmlspecialcharsFix($row['moq']);
$nosale = $row['nosale'];
$note = htmlspecialcharsFix($row['note']);
$tips = htmlspecialcharsFix($row['tips']);
$category_id = $row['category_id'] ? intval($row['category_id']) : 0;
?>
<!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" />
<script language="javascript" src="js/jquery-1.7.2.min.js"></script>
<script type="text/javascript" src="js/js.js"></script>
<script type="text/javascript" src="js/SearchArea.js"></script>
<script type="text/javascript" src="xheditor-1.1.9/xheditor-1.1.9-zh-cn.min.js"></script>
<style>
    /* Styles for specification section */
    .specifications {
        margin-bottom: 10px;
        width: 100%;
    }
    .specitem {
        margin-bottom: 8px;
        padding: 8px 10px;
        /*background-color: #f9f9f9;*/
        border: 1px solid #e0e0e0;
        border-radius: 4px;
        clear: both;
        overflow: hidden;
    }
    .addspecitem, .delspecitem {
        display: inline-block;
        width: 20px;
        height: 20px;
        text-align: center;
        line-height: 18px;
        border-radius: 50%;
        font-weight: bold;
        cursor: pointer;
        margin-left: 10px;
    }
    .addspecitem {
        background-color: #5cb85c;
        color: white;
    }
    .delspecitem {
        background-color: #d9534f;
        color: white;
    }
    .spec-input {
        width: 160px;
        padding: 4px;
        margin-right: 10px;
        border: 1px solid #ccc;
        border-radius: 3px;
    }
    .spec-small-input {
        width: 80px;
        padding: 4px;
        margin-right: 10px;
        border: 1px solid #ccc;
        border-radius: 3px;
    }
    .spec-label {
        display: inline-block;
        margin-right: 5px;
        font-weight: normal;
    }
    .required {
        color: red;
        margin-left: 2px;
    }
</style>
</head>

<body>
<div id="man_zone">
    <form name="form1" method="post" action="save_product.php">
        <table width="100%" border="0" cellpadding="3" cellspacing="1" class="table1">
            <tbody>
                <tr>
                    <th width="8%">产品名称</th>
                    <td><input type="text" id="ProductName" name="ProductName" value="<?php echo $product_name; ?>" class="txt1" />
                    <input type="hidden" name="id" value="<?php echo $id; ?>" />
                    <input type="hidden" name="keys" value="<?php echo $keys; ?>" />
                    <input type="hidden" name="page" value="<?php echo $page; ?>" />
                    <input type="hidden" name="category_id" value="<?php echo $category_id; ?>" />
                    </td>
                </tr>
                <tr>
                    <th width="8%">产品分类</th>
                    <td>
                        <select name="category_id" id="category_id" class="select1">
                            <option value="0">-- 请选择分类 --</option>
                            <?php
                            // Build category tree
                            $category_data = buildCategoryTree($conn);
                            $cat_tree = $category_data['tree'];
                            
                            // Output options
                            outputCategoryOptions($cat_tree, $category_id);
                            ?>
                        </select>
                    </td>
                </tr>
                <tr>
                    <th width="8%">产品图片</th>
                    <td><input type="text" id="ProductImg" name="ProductImg" placeholder="186x*186px" value="<?php echo $product_img; ?>" class="txt1" style="width:390px;float:left;" />
                    <iframe src="uploadfile.php" frameborder="0" scrolling="no" style="width:400px;height:22px;float:left;margin-left:10px;"></iframe></td>
                </tr>
                <tr>
                    <th width="8%">计价单位</th>
                    <td><input type="text" id="unit" name="unit" value="<?php echo $unit; ?>" class="txt1"/></td>
                </tr>
<!--                <tr>-->
<!--                    <th width="8%">起订数量</th>-->
<!--                    <td><input type="text" id="moq" name="moq" value="--><?php //echo $moq; ?><!--" class="txt1"/></td>-->
<!--                </tr>-->
                <tr>
                    <th width="8%">产品规格</th>
                    <td>
                        <div class="specifications">
                        <?php
                        // Fetch specifications for this product
                        $spec_sql = "SELECT * FROM product_specifications WHERE product_id = " . (int)$id . " ORDER BY sort_order ASC";
                        $spec_result = mysqli_query($conn, $spec_sql);
                        
                        if (mysqli_num_rows($spec_result) > 0) {
                            while ($spec_row = mysqli_fetch_assoc($spec_result)) {
                                ?>
                                <div class="specitem">
                                    <span class="spec-label">规格名称<span class="required">*</span>:</span>
                                    <input type="text" class="spec-input" name="spec_name[]" placeholder="如: 红色、XL" value="<?php echo htmlspecialcharsFix($spec_row['spec_name']); ?>" required>
                                    
                                    <span class="spec-label">起订数量<span class="required">*</span>:</span>
                                    <input type="number" class="spec-small-input" name="spec_moq[]" value="<?php echo $spec_row['min_order_quantity']; ?>" required>
                                    
                                    <span class="spec-label">规格价格<span class="required">*</span>:</span>
                                    <input type="text" class="spec-small-input" name="spec_price[]" placeholder="价格" value="<?php echo $spec_row['price']; ?>" required>
                                    
                                    <span class="addspecitem">+</span>
                                    <span class="delspecitem">-</span>
                                    
                                    <!-- 隐藏字段，保留原始数据 -->
                                    <input type="hidden" name="spec_value[]" value="<?php echo htmlspecialcharsFix($spec_row['spec_value']); ?>">
                                    <input type="hidden" name="spec_code[]" value="<?php echo htmlspecialcharsFix($spec_row['spec_code']); ?>">
                                    <input type="hidden" name="spec_sort[]" value="<?php echo $spec_row['sort_order']; ?>">
                                </div>
                                <?php
                            }
                        } else {
                            // No specifications found, show one empty form
                            ?>
                            <div class="specitem">
                                <span class="spec-label">规格名称<span class="required">*</span>:</span>
                                <input type="text" class="spec-input" name="spec_name[]" placeholder="如: 红色、XL" required>
                                
                                <span class="spec-label">起订数量<span class="required">*</span>:</span>
                                <input type="number" class="spec-small-input" name="spec_moq[]" value="1" required>
                                
                                <span class="spec-label">规格价格<span class="required">*</span>:</span>
                                <input type="text" class="spec-small-input" name="spec_price[]" placeholder="价格" required>
                                
                                <span class="addspecitem">+</span>
                                <span class="delspecitem">-</span>
                                
                                <!-- 隐藏字段，仍然提交但不显示 -->
                                <input type="hidden" name="spec_value[]" value="">
                                <input type="hidden" name="spec_code[]" value="">
                                <input type="hidden" name="spec_sort[]" value="0">
                            </div>
                            <?php
                        }
                        ?>
                        </div>
                    </td>
                </tr>
                <tr>
                    <th width="8%">不报价地区</th>
                    <td>
                        <ul class="areadd">
                        <?php
                        if (!empty($nosale)) {
                            // 确保nosale是逗号分隔的字符串格式
                            $nosale_str = is_array($nosale) ? implode(',', $nosale) : $nosale;
                            $area_sql = "SELECT id, countryName FROM country WHERE id IN(" . $nosale_str . ")";
                            $area_result = mysqli_query($conn, $area_sql);
                            while ($area_row = mysqli_fetch_assoc($area_result)) {
                                ?>
                                <li><input type="hidden" name="nosale[]" value="<?php echo $area_row['id']; ?>"><span class="cname"><?php echo htmlspecialcharsFix($area_row['countryName']); ?></span><span class="close"></span></li>
                                <?php
                            }
                        }
                        ?>
                        </ul>
                        <input type="text" id="AreaSearch" class="fastsearch">
                        <div id="arealist" class="productlist"><ul></ul></div>
                    </td>
                </tr>
                <tr>
                    <th width="8%">不报价处理方式</th>
                    <td><input type="text" id="note" name="note" value="<?php echo $note; ?>" class="txt1"/></td>
                </tr>
                <tr>
                    <th width="8%">备注</th>
                    <td><input type="text" id="tips" name="tips" value="<?php echo $tips; ?>" class="txt1"/></td>
                </tr>
                <tr>
                    <th></th>
                    <td colspan="2">
                        <input type="submit" name="save" value="确定" class="btn1" />
                        <input type="reset" name="reset" value="重置" class="btn1" />
                        <input type="button" value="返回" class="btn1" onClick="location.href='<?php echo $href_str; ?>'" />
                    </td>
                </tr>
            </tbody>
        </table>
    </form>
</div>

<script>
    $(document).ready(function(){
        // Add specification item
        $(document).on('click', '.addspecitem', function(){
            var newSpecItem = $(this).closest('.specitem').clone(true);
            newSpecItem.find('input[type="text"], input[type="hidden"]').val(''); // Clear values
            newSpecItem.find('input[name="spec_moq[]"]').val('1'); // Reset MOQ to 1
            newSpecItem.find('input[name="spec_sort[]"]').val('0'); // Reset sort to 0
            $(this).closest('.specifications').append(newSpecItem);
        });
        
        // Remove specification item
        $(document).on('click', '.delspecitem', function(){
            if($('.specitem').length > 1){
                $(this).closest('.specitem').remove();
            } else {
                alert('至少需要保留一个规格项');
            }
        });
        
        // Update unit display when unit field changes
        $('#unit').on('change keyup', function(){
            $('.unit').text($(this).val());
        });
    });
</script>

</body>
</html>
<?php mysqli_close($conn); ?>