123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135 |
- <!DOCTYPE html>
- <html lang="en">
- <head>
- <meta charset="UTF-8">
- <title>{{ title }}</title>
- <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
- <!-- 新 Bootstrap4 核心 CSS 文件 -->
- <link rel="stylesheet" href="https://cdn.bootcss.com/bootstrap/4.1.0/css/bootstrap.min.css">
- <!-- jQuery文件。务必在bootstrap.min.js 之前引入 -->
- <script src="https://cdn.bootcss.com/jquery/3.2.1/jquery.min.js"></script>
- <!-- popper.min.js 用于弹窗、提示、下拉菜单 -->
- <script src="https://cdn.bootcss.com/popper.js/1.12.5/umd/popper.min.js"></script>
- <!-- 最新的 Bootstrap4 核心 JavaScript 文件 -->
- <script src="https://cdn.bootcss.com/bootstrap/4.1.0/js/bootstrap.min.js"></script>
- <!--可用來建立使用者小圖示-->
- <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
- </head>
- <body>
- 會計科目:
- <select id="accountingsubjects" onChange="">
- <option value="00"></option>
- {% for data in AccountingSubjects_data %}
- <option value="{{data[0]}}">{{data[0]}}-{{data[1]}}</option>
- {% endfor %}
- </select>
- 類別:
- <select id="category" onChange="renewSN();">
- <option value="00"></option>
- {% for data in Category_data %}
- <option value="{{data[0]}}">{{data[0]}}-{{data[1]}}</option>
- {% endfor %}
- </select>
- 流水號:
- <input id="serialnumber" value="—" style="height: 25px; width: 45px;" readonly>
- 供應商:
- <select id="supplier" onChange="">
- <option value="00"></option>
- {% for data in Supplier_data %}
- <option value="{{data[0]}}">{{data[0]}}-{{data[1]}}</option>
- {% endfor %}
- </select>
- 零件名稱:
- <input list="conponents" id="component_name_select">
- <datalist id="conponents">
- <option value=""></option>
- {% for data in Component_data %}
- <option value="{{data[0]}}">{{data[0]}}</option>
- {% endfor %}
- </datalist>
- </select>
- <br>
-
- <input type="button" id="create_component" value="新增零件" onclick="create_component();">
- <div id="result">
- <!-- <table>
- </table> -->
- </div>
- <script>
- // 輸入完類別後, 流水號自動帶入
- function renewSN() {
- var accountingsubjects_select = $("#accountingsubjects").val();
- var category_select = $("#category").val();
- $.get('/sn_get/' + accountingsubjects_select + '/' + category_select, '', function (res) {
- // console.log(res.new_sn)
- $('#serialnumber').val(res.new_sn)
- }, 'json');
- }
- // 零件表 新增零件
- function create_component() {
- // 會計科目
- var accountingsubjects_select = $("#accountingsubjects").val();
- // 類別
- var category_select = $("#category").val();
- // 流水號 → 從資料庫找到最大的流水號, 然後 +1
- var serialnumber_select = $("#serialnumber").val();
- // 放到 renewSN 方法內執行
- // 供應商
- var supplier_select = $("#supplier").val();
- // 零件名稱
- var component_name_select = $("#component_name_select").val();
- // 內部料號組合
- var company_id = accountingsubjects_select + category_select + serialnumber_select + supplier_select;
- var AND_list = [];
- // console.log(accountingsubjects_select, category_select, serialnumber_select, supplier_select, component_name_select)
- var sql = '';
- sql += 'INSERT INTO 零件表 ' +
- 'VALUES ("' + company_id + '", "' + accountingsubjects_select + '", "' + category_select + '", "' + serialnumber_select + '", "';
- sql += supplier_select + '", "' + component_name_select + '");';
- console.log("sql: " + sql)
- var sql_data = {
- "sql":sql
- };
- $.ajax({
- type:"GET",
- url:"/sql_get",
- dataType:"JSON",
- data:sql_data,
- success:function (res) {
- data = '-- 新增成功! --'
- var sectorSelect = document.getElementById("result");
- sectorSelect.innerHTML = data;
- },
- error: function (thrownError) {
- if (thrownError.statusText == "INTERNAL SERVER ERROR") {
- alert("內部料號 " + company_id + " 已存在, 請重新輸入")
- }
- }
- })
- // $.get('/sql_get', sql_data, function (res) {
- // // console.log("res: " + res)
- // // console.log("res.labels:" + res.labels)
- // // console.log("res.labels[0]:" + res.labels[0])
- // // console.log("res.labels[0][0]:" + res.labels[0][0])
- // // console.log("res.sql_field:" + res.sql_field)
- // // console.log("res.sql_field[0]:" + res.sql_field[0])
-
- // }, 'json');
-
- }
-
- </script>
- </body>
- </html>
|