create_component_table_item.html 5.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135
  1. <!DOCTYPE html>
  2. <html lang="en">
  3. <head>
  4. <meta charset="UTF-8">
  5. <title>{{ title }}</title>
  6. <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
  7. <!-- 新 Bootstrap4 核心 CSS 文件 -->
  8. <link rel="stylesheet" href="https://cdn.bootcss.com/bootstrap/4.1.0/css/bootstrap.min.css">
  9. <!-- jQuery文件。务必在bootstrap.min.js 之前引入 -->
  10. <script src="https://cdn.bootcss.com/jquery/3.2.1/jquery.min.js"></script>
  11. <!-- popper.min.js 用于弹窗、提示、下拉菜单 -->
  12. <script src="https://cdn.bootcss.com/popper.js/1.12.5/umd/popper.min.js"></script>
  13. <!-- 最新的 Bootstrap4 核心 JavaScript 文件 -->
  14. <script src="https://cdn.bootcss.com/bootstrap/4.1.0/js/bootstrap.min.js"></script>
  15. <!--可用來建立使用者小圖示-->
  16. <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
  17. </head>
  18. <body>
  19. 會計科目:
  20. <select id="accountingsubjects" onChange="">
  21. <option value="00"></option>
  22. {% for data in AccountingSubjects_data %}
  23. <option value="{{data[0]}}">{{data[0]}}-{{data[1]}}</option>
  24. {% endfor %}
  25. </select>
  26. 類別:
  27. <select id="category" onChange="renewSN();">
  28. <option value="00"></option>
  29. {% for data in Category_data %}
  30. <option value="{{data[0]}}">{{data[0]}}-{{data[1]}}</option>
  31. {% endfor %}
  32. </select>
  33. 流水號:
  34. <input id="serialnumber" value="—" style="height: 25px; width: 45px;" readonly>
  35. 供應商:
  36. <select id="supplier" onChange="">
  37. <option value="00"></option>
  38. {% for data in Supplier_data %}
  39. <option value="{{data[0]}}">{{data[0]}}-{{data[1]}}</option>
  40. {% endfor %}
  41. </select>
  42. 零件名稱:
  43. <input list="conponents" id="component_name_select">
  44. <datalist id="conponents">
  45. <option value=""></option>
  46. {% for data in Component_data %}
  47. <option value="{{data[0]}}">{{data[0]}}</option>
  48. {% endfor %}
  49. </datalist>
  50. </select>
  51. <br>
  52. <input type="button" id="create_component" value="新增零件" onclick="create_component();">
  53. <div id="result">
  54. <!-- <table>
  55. </table> -->
  56. </div>
  57. <script>
  58. // 輸入完類別後, 流水號自動帶入
  59. function renewSN() {
  60. var accountingsubjects_select = $("#accountingsubjects").val();
  61. var category_select = $("#category").val();
  62. $.get('/sn_get/' + accountingsubjects_select + '/' + category_select, '', function (res) {
  63. // console.log(res.new_sn)
  64. $('#serialnumber').val(res.new_sn)
  65. }, 'json');
  66. }
  67. // 零件表 新增零件
  68. function create_component() {
  69. // 會計科目
  70. var accountingsubjects_select = $("#accountingsubjects").val();
  71. // 類別
  72. var category_select = $("#category").val();
  73. // 流水號 → 從資料庫找到最大的流水號, 然後 +1
  74. var serialnumber_select = $("#serialnumber").val();
  75. // 放到 renewSN 方法內執行
  76. // 供應商
  77. var supplier_select = $("#supplier").val();
  78. // 零件名稱
  79. var component_name_select = $("#component_name_select").val();
  80. // 內部料號組合
  81. var company_id = accountingsubjects_select + category_select + serialnumber_select + supplier_select;
  82. var AND_list = [];
  83. // console.log(accountingsubjects_select, category_select, serialnumber_select, supplier_select, component_name_select)
  84. var sql = '';
  85. sql += 'INSERT INTO 零件表 ' +
  86. 'VALUES ("' + company_id + '", "' + accountingsubjects_select + '", "' + category_select + '", "' + serialnumber_select + '", "';
  87. sql += supplier_select + '", "' + component_name_select + '");';
  88. console.log("sql: " + sql)
  89. var sql_data = {
  90. "sql":sql
  91. };
  92. $.ajax({
  93. type:"GET",
  94. url:"/sql_get",
  95. dataType:"JSON",
  96. data:sql_data,
  97. success:function (res) {
  98. data = '-- 新增成功! --'
  99. var sectorSelect = document.getElementById("result");
  100. sectorSelect.innerHTML = data;
  101. },
  102. error: function (thrownError) {
  103. if (thrownError.statusText == "INTERNAL SERVER ERROR") {
  104. alert("內部料號 " + company_id + " 已存在, 請重新輸入")
  105. }
  106. }
  107. })
  108. // $.get('/sql_get', sql_data, function (res) {
  109. // // console.log("res: " + res)
  110. // // console.log("res.labels:" + res.labels)
  111. // // console.log("res.labels[0]:" + res.labels[0])
  112. // // console.log("res.labels[0][0]:" + res.labels[0][0])
  113. // // console.log("res.sql_field:" + res.sql_field)
  114. // // console.log("res.sql_field[0]:" + res.sql_field[0])
  115. // }, 'json');
  116. }
  117. </script>
  118. </body>
  119. </html>