<?php
require_once 'conn.php';
checkLogin();
?>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title>管理区域</title>
    <link rel="stylesheet" href="css/common.css" type="text/css" />
    <link rel="stylesheet" href="css/alert.css" type="text/css" />
    <script src="system/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;
        }
    </style>
</head>
<body class="clear">
<?php // require_once 'panel.php'; ?>
<div id="man_zone">
    <form id="form1" method="post" action="?act=postchk&Keys=<?= $keys ?? '' ?>&Page=<?= $page ?? '' ?>" onSubmit="return false">
        <div class="fastSelect clear">
            <H1>报价查询</H1>
            <div class="selectItem">
                <label>区域</label>
                <select name="fliterCountry" id="fliterCountry">
                    <option value="">请选择国家地区</option>
                    <?php
                    $result = $conn->query("SELECT id, countryName FROM country WHERE id IN 
                                          (SELECT DISTINCT cs_country FROM customer WHERE cs_belong=" . $_SESSION['employee_id'] . ")");
                    while ($row = $result->fetch_assoc()) {
                        echo "<option value=\"{$row['id']}\">{$row['countryName']}</option>";
                    }
                    ?>
                </select>
            </div>
            <div class="selectItem selectProduct">
                <label>产品</label>
                <select name="fliterproduct" id="fliterproduct">
                    <option value="">请选择产品</option>
                    <?php
                    $result = $conn->query("SELECT id, ProductName FROM products");
                    while ($row = $result->fetch_assoc()) {
                        echo "<option value=\"{$row['id']}\">{$row['ProductName']}</option>";
                    }
                    ?>
                </select>
            </div>

            <div class="selectItem selectnum">
                <label>数量</label>
                <select name="fliternum" id="fliternum">
                    <option value="">请选择产品</option>
                </select>
            </div>
        </div>

        <table width="100%" class="table2">
            <tr class="theader">
                <th width="15%">产品名称</th>
                <th width="15%">图片</th>
                <th width="10%">起订数量</th>
                <th width="30%">报价管理</th>
                <th width="20%">备注</th>
            </tr>
            <tr id="pricecontrol" class="pricecontrol">
            </tr>
        </table>
    </form>
</div>
</body>
</html>