igamebox
/
mtb_crm_asp


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394
							<?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/Searchproduct.js"></script>
</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;
    }

    $productIds = $_POST['productId'] ?? [];
    $nums = $_POST['num'] ?? [];
    $prices = $_POST['price'] ?? [];
    $countryName = $_POST['countryName'] ?? '';
    $countryCode = $_POST['countryCode'] ?? '';

    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);
        
        // Delete all existing prices for this area
        $conn->query("DELETE FROM price WHERE AreaId=$id");
        
        // Only process if we have product IDs
        if (!empty($productIds) && is_array($productIds)) {
            for ($i = 0; $i < count($productIds); $i++) {
                if (isset($nums[$i]) && isset($prices[$i])) {
                    $numVal = empty($nums[$i]) ? 0 : floatval($nums[$i]);
                    $priceVal = empty($prices[$i]) ? 0 : $conn->real_escape_string($prices[$i]);
                    $productId = intval($productIds[$i]);
                    
                    if ($productId > 0) {
                        $sql = "INSERT INTO price (productId, AreaId, num, price) VALUES ($productId, $id, $numVal, '$priceVal')";
                        $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;
        
        // Only process if we have product IDs
        if (!empty($productIds) && is_array($productIds)) {
            for ($i = 0; $i < count($productIds); $i++) {
                if (isset($nums[$i]) && isset($prices[$i])) {
                    $numVal = empty($nums[$i]) ? 0 : floatval($nums[$i]);
                    $priceVal = empty($prices[$i]) ? 0 : $conn->real_escape_string($prices[$i]);
                    $productId = intval($productIds[$i]);
                    
                    if ($productId > 0) {
                        $sql = "INSERT INTO price (productId, AreaId, num, price) VALUES ($productId, $id, $numVal, '$priceVal')";
                        $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" /><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" /></td>
            </tr>
            <tr>
                <th width="8%">更新日期</th>
                <td><?= $addtime ?></td>
            </tr>           
            <tr>
                <th width="8%">售价管理</th>
                <td>
                <div class="prowapper">             
                    <?php
                    if (!empty($id) && $id > 0) {
                        $sql = "SELECT p.id, p.ProductName, p.ProductImg, p.unit, p.category_id, pc.name as categoryName 
                                FROM products p 
                                LEFT JOIN product_categories pc ON p.category_id = pc.id 
                                WHERE p.id IN (SELECT productId FROM price WHERE AreaId = $id)";
                        $result = $conn->query($sql);
                        if ($result && $result->num_rows > 0) {
                            while ($row = $result->fetch_assoc()) {
                                // 准备分类显示
                                $categoryDisplay = !empty($row['categoryName']) ? ' <span style="color:#888;font-size:12px;">['.$row['categoryName'].']</span>' : '';
                            ?>
                                <div class="proitem">
                                    <div class="prodelet"></div>
                                    <div class="proname"><?= htmlspecialcharsFix($row['ProductName']) ?><?= $categoryDisplay ?></div>
                                    <div class="propic"><img src="<?= htmlspecialcharsFix($row['ProductImg']) ?>"></div>      
                                    <div class="proprice">
                                        <?php
                                        $sql2 = "SELECT num, price FROM price WHERE productId = {$row['id']} AND AreaId = $id ORDER BY num ASC";
                                        $result2 = $conn->query($sql2);
                                        while ($row2 = $result2->fetch_assoc()) {
                                        ?>
                                            <div class="priceitem">
                                                <input type="hidden" name="productId[]" value="<?= $row['id'] ?>">
                                                <label>≥</label>
                                                <input type="number" autocomplete="off" class="txt3 num" name="num[]" value="<?= $row2['num'] ?>">
                                                <label class='unit'><?= htmlspecialcharsFix($row['unit']) ?></label>
                                                <label>售价</label>
                                                <input type="text" class="txt3 price" autocomplete="off" name="price[]" value="<?= $row2['price'] ?>">
                                                <label>RMB</label>
                                                <span class="additem"></span>
                                                <span class="delitem"></span>
                                                <span class="note"></span>
                                            </div>
                                        <?php
                                        }
                                        ?>
                                    </div>      
                                </div>
                            <?php
                            }
                        } else {
                            echo "<p>该地区暂无产品价格设置</p>";
                        }
                    } else {
                        echo "<p>添加产品后可管理产品价格</p>";
                    }
                    ?>
                </div>                  
                </td>
            </tr>
            <tr>
                <th width="8%">产品添加</th>
                <td class="productinput">
                    <input type="text" id="productSearch" class="fastsearch">
                    <div id="productlist" class="productlist"><ul></ul></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);
    }
    
    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(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',
});
</script>
</body>
</html>