price.php 3.0 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980
  1. <?php
  2. require_once 'conn.php';
  3. checkLogin();
  4. ?>
  5. <!DOCTYPE html>
  6. <html xmlns="http://www.w3.org/1999/xhtml">
  7. <head>
  8. <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  9. <title>管理区域</title>
  10. <link rel="stylesheet" href="css/common.css" type="text/css" />
  11. <link rel="stylesheet" href="css/alert.css" type="text/css" />
  12. <script src="system/js/jquery-1.7.2.min.js"></script>
  13. <script src="js/js.js"></script>
  14. <style>
  15. body {
  16. margin: 0;
  17. padding: 20px;
  18. background: #fff;
  19. }
  20. #man_zone {
  21. margin-left: 0;
  22. }
  23. </style>
  24. </head>
  25. <body class="clear">
  26. <?php // require_once 'panel.php'; ?>
  27. <div id="man_zone">
  28. <form id="form1" method="post" action="?act=postchk&Keys=<?= $keys ?? '' ?>&Page=<?= $page ?? '' ?>" onSubmit="return false">
  29. <div class="fastSelect clear">
  30. <H1>报价查询</H1>
  31. <div class="selectItem">
  32. <label>区域</label>
  33. <select name="fliterCountry" id="fliterCountry">
  34. <option value="">请选择国家地区</option>
  35. <?php
  36. $result = $conn->query("SELECT id, countryName FROM country WHERE id IN
  37. (SELECT DISTINCT cs_country FROM customer WHERE cs_belong=" . $_SESSION['employee_id'] . ")
  38. ORDER BY CONVERT(countryName USING gbk) COLLATE gbk_chinese_ci ASC");
  39. while ($row = $result->fetch_assoc()) {
  40. echo "<option value=\"{$row['id']}\">{$row['countryName']}</option>";
  41. }
  42. ?>
  43. </select>
  44. </div>
  45. <div class="selectItem selectProduct">
  46. <label>产品</label>
  47. <select name="fliterproduct" id="fliterproduct">
  48. <option value="">请选择产品</option>
  49. <?php
  50. $result = $conn->query("SELECT id, ProductName FROM products");
  51. while ($row = $result->fetch_assoc()) {
  52. echo "<option value=\"{$row['id']}\">{$row['ProductName']}</option>";
  53. }
  54. ?>
  55. </select>
  56. </div>
  57. <div class="selectItem selectnum">
  58. <label>数量</label>
  59. <select name="fliternum" id="fliternum">
  60. <option value="">请选择产品</option>
  61. </select>
  62. </div>
  63. </div>
  64. <table width="100%" class="table2">
  65. <tr class="theader">
  66. <th width="15%">产品名称</th>
  67. <th width="15%">图片</th>
  68. <th width="10%">起订数量</th>
  69. <th width="30%">报价管理</th>
  70. <th width="20%">备注</th>
  71. </tr>
  72. <tr id="pricecontrol" class="pricecontrol">
  73. </tr>
  74. </table>
  75. </form>
  76. </div>
  77. </body>
  78. </html>