igamebox
/
mtb_crm_asp


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560
							<?php
ob_start();
require_once 'conn.php';
checklogin("信息管理");
?>
<!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/jquery.galpop.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="xheditor-1.1.9/xheditor-1.1.9-zh-cn.min.js"></script>
<script type="text/javascript" src="js/NewSearchproduct.js"></script>
<style>
    /* Styles for specification section */
    .specifications {
        margin-bottom: 10px;
        width: 100%;
    }
    .specitem {
        margin-bottom: 8px;
        padding: 8px 10px;
        border: 1px solid #e0e0e0;
        border-radius: 4px;
        clear: both;
        overflow: hidden;
    }
    .spec-label {
        display: inline-block;
        margin-right: 5px;
        font-weight: normal;
    }
    .spec-input {
        width: 120px;
        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;
    }
    .required {
        color: red;
        margin-left: 2px;
    }
    .specdelete {
        float: right;
        cursor: pointer;
        color: red;
        font-weight: bold;
        margin-right: 5px;
    }
    #specificationlist {
        max-height: 300px;
        overflow-y: auto;
        border: 1px solid #ddd;
        margin-top: 5px;
        display: none;
        background-color: white;
        z-index: 999;
        position: absolute;
        width: 100%;
        left: 0;
        right: 0;
        box-shadow: 0 3px 8px rgba(0,0,0,0.25);
        box-sizing: border-box;
    }
    #specificationlist ul {
        list-style: none;
        padding: 0;
        margin: 0;
    }
    #specificationlist li {
        padding: 8px 10px;
        cursor: pointer;
        border-bottom: 1px solid #eee;
    }
    #specificationlist li:hover {
        background-color: #f0f0f0;
    }
    .product-header {
        margin-top: 10px;
        padding: 8px;
        background: #f5f5f5;
        font-weight: bold;
        border-radius: 4px;
        border: 1px solid #ddd;
    }
    /* 增加搜索相关样式 */
    .productinput {
        position: relative;
        width: 100%;
        max-width: 90%;
    }
    .fastsearch {
        width: 100%;
        padding: 8px;
        border: 1px solid #ddd;
        border-radius: 4px;
        box-sizing: border-box;
    }
    .category-tag {
        color: #777;
        font-size: 12px;
        font-style: italic;
        margin-left: 5px;
    }
</style>
</head>
<body>
<div id="man_zone">
<?php
$act = $_GET['act'] ?? '';

if ($act == "save") {
    $isedit = false;
    $id = $_POST['id'] ?? '';
    if ($id != "" && is_numeric($id)) {
        $isedit = true;
    }

    $countryName = $_POST['countryName'] ?? '';
    $countryCode = $_POST['countryCode'] ?? '';
    
    // 验证国家和区号不能为空
    if (trim($countryName) === '') {
        echo "<script>alert('错误：国家名称不能为空！');history.back();</script>";
        exit;
    }
    
    if (trim($countryCode) === '') {
        echo "<script>alert('错误：区号不能为空！');history.back();</script>";
        exit;
    }
    
    // 规格相关数据
    $specProductIds = $_POST['spec_product_id'] ?? [];
    $specIds = $_POST['spec_id'] ?? [];
    $specPrices = $_POST['spec_price'] ?? [];
    $specMoqs = $_POST['spec_moq'] ?? [];

    // 验证售价不能为0
    $hasZeroPrice = false;
    $zeroProductName = '';
    $zeroSpecName = '';

    if (!empty($specProductIds) && !empty($specIds) && is_array($specProductIds) && is_array($specIds)) {
        for ($i = 0; $i < count($specProductIds); $i++) {
            if (isset($specPrices[$i])) {
                $price = trim($specPrices[$i]);
                if ($price === '' || $price === '0' || floatval($price) <= 0) {
                    // 查询产品和规格名称
                    $productId = intval($specProductIds[$i]);
                    $specId = intval($specIds[$i]);
                    $nameQuery = "SELECT p.ProductName, ps.spec_name 
                                 FROM products p 
                                 JOIN product_specifications ps ON p.id = ps.product_id 
                                 WHERE p.id = $productId AND ps.id = $specId";
                    $nameResult = $conn->query($nameQuery);
                    if ($nameResult && $nameRow = $nameResult->fetch_assoc()) {
                        $zeroProductName = $nameRow['ProductName'];
                        $zeroSpecName = $nameRow['spec_name'];
                    }
                    $hasZeroPrice = true;
                    break;
                }
            }
        }
    }

    if ($hasZeroPrice) {
        echo "<script>alert('错误：产品 [".$zeroProductName."] 的规格 [".$zeroSpecName."] 售价不能为0或空白！');history.back();</script>";
        exit;
    }

    if ($isedit) {
        $sql = "UPDATE country SET 
            countryName = '" . $conn->real_escape_string($countryName) . "', 
            countryCode = '" . $conn->real_escape_string($countryCode) . "', 
            addtime = NOW() 
            WHERE id = $id";
        $conn->query($sql);
        
        // 删除该国家的所有产品规格价格
        $conn->query("DELETE FROM product_country_price WHERE country_id=$id");
        
        // 处理规格价格数据
        if (!empty($specProductIds) && !empty($specIds) && is_array($specProductIds) && is_array($specIds)) {
            for ($i = 0; $i < count($specProductIds); $i++) {
                if (isset($specPrices[$i]) && isset($specMoqs[$i]) && isset($specIds[$i])) {
                    $productId = intval($specProductIds[$i]);
                    $specId = intval($specIds[$i]);
                    $specPrice = $conn->real_escape_string($specPrices[$i]);
                    $specMoq = empty($specMoqs[$i]) ? 1 : intval($specMoqs[$i]);
                    
                    if ($productId > 0 && $specId > 0) {
                        $sql = "INSERT INTO product_country_price (country_id, product_id, specification_id, price, min_order_quantity, addtime) 
                                VALUES ($id, $productId, $specId, '$specPrice', $specMoq, NOW())";
                        $conn->query($sql);
                    }
                }
            }
        }

        $page = $_GET['Page'] ?? '';
        $keys = urlencode($_GET['Keys'] ?? '');
        $ord = urlencode($_GET['Ord'] ?? '');
        header("Location: ?keys=$keys&Ord=$ord&Page=$page");
        exit;
    } else {
        // For new country, include countryName and countryCode
        $sql = "INSERT INTO country (countryName, countryCode, addtime) VALUES (
            '" . $conn->real_escape_string($countryName) . "',
            '" . $conn->real_escape_string($countryCode) . "',
            NOW()
        )";
        $conn->query($sql);
        $id = $conn->insert_id;
        
        // 处理规格价格数据
        if (!empty($specProductIds) && !empty($specIds) && is_array($specProductIds) && is_array($specIds)) {
            for ($i = 0; $i < count($specProductIds); $i++) {
                if (isset($specPrices[$i]) && isset($specMoqs[$i]) && isset($specIds[$i])) {
                    $productId = intval($specProductIds[$i]);
                    $specId = intval($specIds[$i]);
                    $specPrice = $conn->real_escape_string($specPrices[$i]);
                    $specMoq = empty($specMoqs[$i]) ? 1 : intval($specMoqs[$i]);
                    
                    if ($productId > 0 && $specId > 0) {
                        $sql = "INSERT INTO product_country_price (country_id, product_id, specification_id, price, min_order_quantity, addtime) 
                                VALUES ($id, $productId, $specId, '$specPrice', $specMoq, NOW())";
                        $conn->query($sql);
                    }
                }
            }
        }

        header("Location: ?");
        exit;
    }
}

if ($act == "add" || $act == "edit") {
    $id = $_GET['id'] ?? '';
    $isedit = false;
    $countryCode = '';
    $countryName = '';
    $addtime = '';

    if ($id != "" && is_numeric($id)) {
        $isedit = true;
        $sql = "SELECT * FROM country WHERE id = $id";
        $result = $conn->query($sql);
        $row = $result->fetch_assoc();
        
        if ($row) {
            $countryCode = $row['countryCode'];
            $countryName = $row['countryName'];
            $addtime = $row['addtime'];
        } else {
            $isedit = false;
        }
    }

    $page = $_GET['Page'] ?? '';
    $keys = urlencode($_GET['Keys'] ?? '');
    $ord = urlencode($_GET['Ord'] ?? '');
    $hrefstr = "?keys=$keys&Ord=$ord&Page=$page";
?>
    <form name="form1" method="post" action="<?= $hrefstr ?>&act=save">
    <table width="100%" border="0" cellpadding="3" cellspacing="1" class="table1">
        <tbody>
            <tr>
                <th width="8%">国家</th>
                <td><input type="text" id="countryName" name="countryName" value="<?= htmlspecialcharsFix($countryName) ?>" class="txt1" required /><input type="hidden" name="id" value="<?= $id ?>" /></td>
            </tr>
            <tr>
                <th width="8%">区号</th>
                <td><input type="text" id="countryCode" name="countryCode" value="<?= htmlspecialcharsFix($countryCode) ?>" class="txt1" required /></td>
            </tr>
            <tr>
                <th width="8%">更新日期</th>
                <td><?= $addtime ?></td>
            </tr>           
            <!-- 新增: 产品规格价格管理 -->
            <tr>
                <th width="8%">规格价格管理</th>
                <td>
                <div class="specifications">
                    <?php
                    if (!empty($id) && $id > 0) {
                        // 只获取已经添加过的规格价格，而不是所有规格
                        $sql = "SELECT p.id, p.ProductName, p.unit, ps.id as specification_id, 
                                ps.spec_name, pcp.price, pcp.min_order_quantity, pc.name as categoryName
                                FROM product_country_price pcp
                                JOIN products p ON pcp.product_id = p.id
                                JOIN product_specifications ps ON pcp.specification_id = ps.id
                                LEFT JOIN product_categories pc ON p.category_id = pc.id
                                WHERE pcp.country_id = $id
                                ORDER BY p.ProductName, ps.sort_order";
                        $result = $conn->query($sql);
                        if ($result && $result->num_rows > 0) {
                            $current_product = 0;
                            while ($row = $result->fetch_assoc()) {
                                // 显示产品名称，每个产品只显示一次
                                if ($current_product != $row['id']) {
                                    $current_product = $row['id'];
                                    $categoryDisplay = !empty($row['categoryName']) ? ' <span style="color:#888;font-size:12px;">['.$row['categoryName'].']</span>' : '';
                                    echo '<div class="product-header" style="margin-top:10px;padding:5px;background:#f5f5f5;font-weight:bold;">
                                        '.htmlspecialcharsFix($row['ProductName']).$categoryDisplay.'
                                    </div>';
                                }
                                
                                // 设置默认值
                                $price = isset($row['price']) ? $row['price'] : '';
                                $moq = isset($row['min_order_quantity']) ? $row['min_order_quantity'] : '1';
                            ?>
                                <div class="specitem">
                                    <div class="specdelete" style="float:right;cursor:pointer;color:red;">✕</div>
                                    <input type="hidden" name="spec_product_id[]" value="<?= $row['id'] ?>">
                                    <input type="hidden" name="spec_id[]" value="<?= $row['specification_id'] ?>">
                                    
                                    <span class="spec-label">规格:</span>
                                    <span class="spec-name"><?= htmlspecialcharsFix($row['spec_name']) ?></span>
                                    
                                    <span class="spec-label" style="margin-left:15px;">起订数量:</span>
                                    <input type="number" class="spec-small-input" name="spec_moq[]" value="<?= $moq ?>">
                                    <span class="unit"><?= htmlspecialcharsFix($row['unit']) ?></span>
                                    
                                    <span class="spec-label" style="margin-left:15px;">售价:</span>
                                    <input type="text" class="spec-small-input" name="spec_price[]" value="<?= $price ?>" required min="0.01">
                                    <span>RMB</span>
                                </div>
                            <?php
                            }
                        } else {
                            echo "<p>该地区暂无产品规格价格设置，请使用下方的搜索功能添加</p>";
                        }
                    } else {
                        echo "<p>添加产品后可管理产品规格价格</p>";
                    }
                    ?>
                </div>
                </td>
            </tr>
            <tr>
                <th width="8%">添加规格价格</th>
                <td>
                    <div class="productinput">
                        <input type="text" id="specificationSearch" class="fastsearch" placeholder="搜索产品">
                        <div id="specificationlist" class="productlist"><ul></ul></div>
                    </div>
                </td>
            </tr>
            <tr>
                <th></th>
                <td>
                    <input type="submit" name="save" id="save" value="确定" class="btn1" />
                    <input type="reset" name="save" id="save" value="重置" class="btn1" />
                    <input type="button" value="返回" class="btn1" onClick="location.href='<?= $hrefstr ?>'" />
                </td>
            </tr>
        </tbody>
    </table>
    </form>
</div>
</body>
</html>
<?php
    exit;
}

if ($act == "postchk") {
    $keys = urlencode($_GET['Keys'] ?? '');
    $ord = urlencode($_GET['Ord'] ?? '');
    $page = $_GET['Page'] ?? '';
    $chkact = $_POST['chkact'] ?? '';
    
    if (isset($_POST['chkbox']) && is_array($_POST['chkbox'])) {
        $ids = implode(',', array_map('intval', $_POST['chkbox']));
        $sql = "DELETE FROM country WHERE id IN ($ids)";
        $conn->query($sql);
        
        // 删除相关的产品规格价格
        $sql = "DELETE FROM product_country_price WHERE country_id IN ($ids)";
        $conn->query($sql);
    }
    
    header("Location: ?Keys=$keys&Ord=$ord&Page=$page");
    exit;
}

// Main list view
$keys = $_GET['Keys'] ?? '';
$keyscode = $keys;
$ord = $_GET['Ord'] ?? '';
$page = $_GET['Page'] ?? '';

$sql = "SELECT * FROM country WHERE countryName LIKE '%$keyscode%' OR countryCode LIKE '%$keyscode%' ORDER BY id DESC";
$result = $conn->query($sql);
$results = [];
while($row = $result->fetch_assoc()) {
    $results[] = $row;
}

$totalRecords = count($results);
$pageSize = 20;
$totalPages = ceil($totalRecords / $pageSize);

if ($page == "") $page = 1;
if ($page == "end") $page = $totalPages;
if (!is_numeric($page) || $page < 1) $page = 1;
$page = (int)$page;
if ($page > $totalPages) $page = $totalPages;

$start = ($page - 1) * $pageSize;
$currentPageRecords = array_slice($results, $start, $pageSize);

$keys = urlencode($keys);
$ord = urlencode($ord);
$hrefstr = "?keys=$keys";
?>  
    <form id="form1" method="post" action="?act=postchk&Keys=<?= $keys ?>&Ord=<?= $ord ?>&Page=<?= $page ?>" onSubmit="return false">
    <table width="100%" border="0" cellpadding="3" cellspacing="1" class="table1">
        <thead>
            <tr>
                <th width="4%"><input type="checkbox" name="chkall" id="chkall" onClick="chkboxall(this,'chkbox')" /></th>
                <th width="6%">序号</th>
                <th width="30%">国家</th>
                <th width="30%">区号</th>
                <th width="30%">操作</th>
            </tr>
        </thead>
        <tbody>
        <?php
        if (!empty($currentPageRecords)) {
            $tempNum = $start;
            foreach ($currentPageRecords as $row) {
                $tempNum++;
        ?>
            <tr onMouseOver="this.style.background='#F7FCFF'" onMouseOut="this.style.background='#FFFFFF'">
                <td align="center"><input type="checkbox" name="chkbox[]" value="<?= $row['id'] ?>" /></td>
                <td align="center"><?= $tempNum ?></td>
                <td align="center"><?= htmlspecialcharsFix($row['countryName']) ?></td>
                <td align="center"><?= htmlspecialcharsFix($row['countryCode']) ?></td>
                <td align="center">
                    <a href="?Keys=<?= $keys ?>&Ord=<?= $ord ?>&Page=<?= $page ?>&act=edit&id=<?= $row['id'] ?>" class="ico_edit ico">修改</a>
                </td>
            </tr>
        <?php
            }
        } else {
            if ($keys == "") {
        ?>
            <tr>
                <td align="center" colspan="5">Sorry，当前暂无信息</td>
            </tr>
        <?php
            } else {
        ?>
            <tr>
                <td align="center" colspan="5"><a href="?">Sorry，没有找到"<?= htmlspecialcharsFix($keyscode) ?>"相关的信息，点击返回</a></td>
            </tr>
        <?php
            }
        }
        ?>
        </tbody>
        <tfoot>
            <tr>
                <td colspan="5">
                    <div class="showpagebox">
                    <?php
                    if ($totalPages > 1) {
                        $pageName = "?Keys=$keys&Ord=$ord&";
                        $pagelen = 3;

                        if ($page > 1) {
                            echo "<a href=\"{$pageName}Page=1\">首页</a>";
                            echo "<a href=\"{$pageName}Page=" . ($page-1) . "\">上一页</a>";
                        }

                        if ($pagelen * 2 + 1 >= $totalPages) {
                            $startPage = 1;
                            $endPage = $totalPages;
                        } else {
                            if ($page <= $pagelen + 1) {
                                $startPage = 1;
                                $endPage = $pagelen * 2 + 1;
                            } else {
                                $startPage = $page - $pagelen;
                                $endPage = $page + $pagelen;
                            }
                            if ($page + $pagelen > $totalPages) {
                                $startPage = $totalPages - $pagelen * 2;
                                $endPage = $totalPages;
                            }
                        }

                        for ($i = $startPage; $i <= $endPage; $i++) {
                            if ($i == $page) {
                                echo "<a class=\"current\">$i</a>";
                            } else {
                                echo "<a href=\"{$pageName}Page=$i\">$i</a>";
                            }
                        }

                        if ($page < $totalPages) {
                            if ($totalPages - $page > $pagelen) {
                                echo "<a href=\"{$pageName}Page=$totalPages\">...$totalPages</a>";
                            }
                            echo "<a href=\"{$pageName}Page=" . ($page+1) . "\">下一页</a>";
                            echo "<a href=\"{$pageName}Page=$totalPages\">尾页</a>";
                        }

                        echo "<input type=\"text\" id=\"Pagego\" value=\"$page\" onFocus=\"if(this.value == '$page'){this.value='';}\""
                            . " onBlur=\"if(this.value == ''){this.value='$page';}\""
                            . " onKeyUp=\"this.value=this.value.replace(/\\D/g,'')\""
                            . " onKeyDown=\"if(event.keyCode==13){location.href='{$pageName}Page='+document.getElementById('Pagego').value}\" />";
                    }
                    ?>
                    </div>
                    <div class="searchbox">
                        <input type="text" id="keys" value="<?= $keyscode == "" ? "请输入搜索关键词" : htmlspecialcharsFix($keyscode) ?>"
                            onFocus="if(this.value == '<?= $keyscode == "" ? "请输入搜索关键词" : htmlspecialcharsFix($keyscode) ?>'){this.value='';}"
                            onBlur="if(this.value == ''){this.value='<?= $keyscode == "" ? "请输入搜索关键词" : htmlspecialcharsFix($keyscode) ?>';}"
                            onKeyDown="if(event.keyCode==13){location.href='?Keys='+encodeURIComponent(document.getElementById('keys').value)}" />
                        <input type="button" id="searchgo" value="go" onClick="location.href='?Keys='+encodeURIComponent(document.getElementById('keys').value)" />
                    </div>
                    <div class="postchkbox">
                        <select id="chkact" name="chkact">
                            <option value="1">请选择</option>
                            <option value="-1">删除</option>
                        </select>
                        <input type="button" value="执行" onClick="postchk_new(1)" class="btn1" />
                        <input type="button" value="新增" onClick="location.href='?act=add'" class="btn1" />
                    </div>
                </td>
            </tr>
        </tfoot>
    </table>
    </form>
</div>
<script>
$('.click-open-iframe').galpop({
    contentType: 'iframe',
});

// 规格搜索和添加功能已移至 js/NewSearchproduct.js
</script>
</body>
</html>