123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519 |
- <!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">
- <script>
- $(function(){
-
- });
- </script>
-
- </head>
- <style>
- .input-cond-delete {
- background: #E43030;
- border: 1px solid #CFCFCF;
- box-sizing: border-box;
- border-radius: 5px;
- margin-left: 5px;
- width: 65px;
- height: 33px;
- font-size: 16px;
- text-align: center;
- line-height: 16px;
- color: #FFFFFF;
- }
- .input-cond-add {
- background: #008CBA;
- border: 1px solid #CFCFCF;
- box-sizing: border-box;
- border-radius: 5px;
- margin-left: 5px;
- width: 65px;
- height: 33px;
- font-size: 16px;
- text-align: center;
- line-height: 16px;
- color: #FFFFFF;
- }
- </style>
- <body>
- <!-- 建立 BOM 表名稱用 --------------------------------------------------------------------------------------- -->
- 請輸入此 BOM 表名稱:<br>
- 會計科目:
- <select id="BOM_accountingsubjects" onChange="">
- <option value="00"></option>
- {% for data in AccountingSubjects_data %}
- <option value="{{data[0]}}">{{data[0]}}-{{data[1]}}</option>
- {% endfor %}
- </select>
- 類別:
- <select id="BOM_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="BOM_serialnumber" placeholder="0001" style="height: 25px; width: 45px;">
- 供應商:
- <select id="BOM_supplier" onChange="">
- <option value="00"></option>
- {% for data in Supplier_data %}
- <option value="{{data[0]}}">{{data[0]}}-{{data[1]}}</option>
- {% endfor %}
- </select>
- 名稱:
- <input list="BOM_module" id="BOM_module_name_select">
- <datalist id="BOM_module">
- <option value=""></option>
- {% for data in Component_data %}
- <option value="{{data[0]}}">{{data[0]}}</option>
- {% endfor %}
- </datalist>
- <br>
- <input type="button" id="view_component" value="查看現有加入零件" onclick="view_component();">
- <input type="button" id="create_module" value="新增模組/系統/成品" onclick="create_module();">
- <div id="view_component_data"></div>
- <script>
- // 查看現有零件
- function view_component() {
- var data = '';
- data += 'module_amount_list: ' + module_amount_list + ''
- var sectorSelect = document.getElementById("view_component_data");
- sectorSelect.innerHTML = data;
-
- }
- // 新增模組/系統/成品
- function create_module() {
- // 會計科目
- var accountingsubjects_select = $("#BOM_accountingsubjects").val();
- // 類別
- var category_select = $("#BOM_category").val();
- // 流水號 → 從資料庫找到最大的流水號, 然後 +1
- var serialnumber_select = $("#BOM_serialnumber").val();
- // 放到 renewSN 方法內執行
- // 供應商
- var supplier_select = $("#BOM_supplier").val();
- // 零件名稱
- var component_name_select = $("#BOM_module_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) {
- alert(" " + company_id + " 新增成功!")
- // data = '-- 新增成功! --'
- // var sectorSelect = document.getElementById("result");
- // sectorSelect.innerHTML = data;
- },
- error: function (thrownError) {
- if (thrownError.statusText == "INTERNAL SERVER ERROR") {
- alert("內部料號 " + company_id + " 已存在, 請重新輸入")
- } else {
- console.log("新建模組零件 thrownError" + thrownError)
- }
- }
- })
- // !!! 建立模組 Table
- var sql = '';
- sql += 'CREATE TABLE `' + company_id + '` ( ' +
- '內部料號 varchar(11) NOT NULL DEFAULT "00", ' +
- '數量 varchar(4) NOT NULL DEFAULT "1",' +
- '位置 varchar(100) NULL,' +
- '備註 varchar(200) NULL,' +
- '設計原因 varchar(200) NULL' +
- ');';
- console.log("sql: " + sql)
- var sql_data = { "sql":sql };
- $.ajax({
- type:"GET",
- url:"/sql_get",
- dataType:"JSON",
- data:sql_data,
- success:function (res) {
- alert(" " + company_id + " Table 建立成功!")
- // data = '-- 新增成功! --'
- // var sectorSelect = document.getElementById("result");
- // sectorSelect.innerHTML = data;
- },
- error: function (thrownError) {
- if (thrownError.statusText == "INTERNAL SERVER ERROR") {
- alert("內部料號 " + company_id + " 已存在, 請重新輸入")
- } else {
- console.log("新建模組 Table thrownError" + thrownError)
- }
- }
- })
- // !!! 將所選零件加入模組 Table
- var sql = '';
- sql += 'INSERT INTO `' + company_id + '` (`內部料號`, `數量`) ' +
- 'VALUES ' + module_amount_list.join(', ') + ';';
- console.log("sql: " + sql)
- var sql_data = { "sql":sql };
- $.ajax({
- type:"GET",
- url:"/sql_get",
- dataType:"JSON",
- data:sql_data,
- success:function (res) {
- alert(" " + company_id + " Table 建立成功!")
- },
- error: function (thrownError) {
- if (thrownError.statusText == "INTERNAL SERVER ERROR") {
- alert("內部料號 " + company_id + " 已存在, 請重新輸入")
- } else {
- console.log("零件加入模組 thrownError" + thrownError)
- }
- }
- })
-
-
- }
- </script>
- <hr>
- <!-- 索取現有零件用 --------------------------------------------------------------------------------------- -->
- 會計科目:
- <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="">
- <option value="00"></option>
- {% for data in Category_data %}
- <option value="{{data[0]}}">{{data[0]}}-{{data[1]}}</option>
- {% endfor %}
- </select>
- 流水號:
- <input id="serialnumber" placeholder="0001" style="height: 25px; width: 45px;">
- 供應商:
- <select id="supplier" onChange="">
- <option value="00"></option>
- {% for data in Supplier_data %}
- <option value="{{data[0]}}">{{data[0]}}-{{data[1]}}</option>
- {% endfor %}
- </select><br>
-
- 零件名稱:
- <select id="component_name_select" onChange="">
- <option value="00"></option>
- {% for data in Component_data %}
- <option value="{{data[0]}}">{{data[0]}}</option>
- {% endfor %}
- </select>
- <input id="component_name_input" placeholder="零件關鍵字輸入" style="height: 25px; width: 120px;">
- <input type="button" id="search_component_table" value="零件表查詢" onclick="search_component_table();">
- <input type="button" id="search_BOM_table" value="BOM 表查詢" onclick="search_BOM_table();">
- <br>
- <script>
- // BOM 表查詢
- function search_BOM_table() {
- var accountingsubjects_select = $("#accountingsubjects").val();
- var category_select = $("#category").val();
- var serialnumber_select = $("#serialnumber").val();
- var supplier_select = $("#supplier").val();
- // 內部料號組合
- var company_id = accountingsubjects_select + category_select + serialnumber_select + supplier_select;
- sql = 'SELECT * FROM `' + company_id + '`';
- var sql_data = { "sql":sql };
- console.log("sql_data: ", sql_data)
- $.get('/sql_get', sql_data, function (res) {
- var data = " ";
- if (res.labels == '') {
- data += '-- 無符合關鍵字之資料 --'
- } else {
- data += '<table class="table table-bordered" style="margin-top: 10px;">';
- data += '<tr>';
- for (let fields = 0; fields < res.sql_field.length; fields++) {
- data += '<th>' + res.sql_field[fields][0] + '</th>';
- }
- data += '</tr>';
- for (let items = 0; items < res.labels.length; items++) {
- data += '<tr>';
- for (let item = 0; item < res.labels[items].length; item++) {
- data += '<td id="' + res.labels[items][0] + '_' + item + '">' + res.labels[items][item] + '</td>';
- };
- data += '</tr>';
- };
- data += '</table>';
- }
- var sectorSelect = document.getElementById("result");
- sectorSelect.innerHTML = data;
- }, 'json');
-
- }
- // 儲存欲加入的零件 數量
- var module_amount_list = [];
- // 加入 BOM 表
- function insert_moduel(company_id) {
- var select_amount = $("#BOM_amount" + company_id).val();
- module_amount_list.push('("' + company_id + '", "' + select_amount + '")')
- console.log("module_amount_list: " + module_amount_list)
- }
- // 輸入完類別後, 流水號自動帶入
- function renewSN() {
- var BOM_accountingsubjects_select = $("#BOM_accountingsubjects").val();
- var BOM_category_select = $("#BOM_category").val();
- $.get('/sn_get/' + BOM_accountingsubjects_select + '/' + BOM_category_select, '', function (res) {
- // console.log(res.new_sn)
- $('#BOM_serialnumber').val(res.new_sn)
- }, 'json');
- }
- // 各資料表←關聯→零件表, 程式
- function search_relation_insertdata(sql) {
- var accountingsubjects_select = $("#accountingsubjects").val();
- var category_select = $("#category").val();
- var serialnumber_select = $("#serialnumber").val();
- var supplier_select = $("#supplier").val();
- var component_name_select = $("#component_name_select").val();
- var component_name_input = $("#component_name_input").val();
- var AND_list = [];
- console.log(accountingsubjects_select, category_select, serialnumber_select, supplier_select)
- var sql = sql;
- // 篩選 會計科目/類別/供應商 關鍵字
- if (accountingsubjects_select != '00') {
- AND_list.push('會計科目 = "' + accountingsubjects_select + '"')
- }
- if (category_select != '00') {
- AND_list.push('類別 = "' + category_select + '"')
- }
- if (serialnumber_select != '') {
- AND_list.push('流水號 = "' + serialnumber_select + '"')
- }
- if (supplier_select != '00') {
- AND_list.push('供應商 = "' + supplier_select + '"')
- }
- if (component_name_select != '00') {
- AND_list.push('零件表.名稱 = "' + component_name_select + '"')
- } else if (component_name_input != '') {
- AND_list.push('零件表.名稱 LIKE "%' + component_name_input + '%"')
- }
- console.log("AND_list: ", AND_list)
- if (AND_list != '') {
- sql += ' WHERE ' + AND_list.join(' AND ');
- }
- if (sql.match('INNER JOIN 庫存表')) {
- sql += ' ORDER BY 時間 DESC LIMIT 1'
- }
-
- var sql_data = {
- "sql":sql
- };
- console.log("sql_data: ", sql_data)
- $.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])
- var data = " ";
- if (res.labels == '') {
- data += '-- 無符合關鍵字之資料 --'
- } else {
- data += '<table class="table table-bordered" style="margin-top: 10px;">';
- data += '<tr>';
- for (let fields = 0; fields < res.sql_field.length; fields++) {
- data += '<th>' + res.sql_field[fields][0] + '</th>';
- }
- data += '</tr>';
- for (let items = 0; items < res.labels.length; items++) {
- data += '<tr>';
- for (let item = 0; item < res.labels[items].length; item++) {
- console.log("res.labels[items][item]: ", res.labels[items][item], typeof(res.labels[items][item]))
- data += '<td>' + res.labels[items][item] + '</td>';
- };
- data += '</tr>';
- };
- data += '</table>';
- }
- var sectorSelect = document.getElementById("result");
- sectorSelect.innerHTML = data;
- }, 'json');
- }
- // 零件表查詢
- function search_component_table(){
- var accountingsubjects_select = $("#accountingsubjects").val();
- var category_select = $("#category").val();
- var serialnumber_select = $("#serialnumber").val();
- var supplier_select = $("#supplier").val();
- var component_name_select = $("#component_name_select").val();
- var component_name_input = $("#component_name_input").val();
- var AND_list = [];
- console.log(accountingsubjects_select, category_select, serialnumber_select, supplier_select)
- // sql = 'SELECT * FROM 零件表';
- sql = 'SELECT 內部料號, 會計科目表.會計科目_名稱, 類別表.類別_名稱, 流水號, 供應商.公司, 名稱' +
- ' FROM (' +
- '(零件表 ' +
- 'INNER JOIN 供應商' +
- ' ON 供應商.供應商 = 零件表.供應商' +
- ')' +
- ' INNER JOIN 類別表' +
- ' ON 類別表.類別_編號 = 零件表.類別' +
- ') ' +
- 'INNER JOIN 會計科目表 ' +
- 'ON 會計科目表.會計科目_編號 = 零件表.會計科目' +
- '' ;
- // 篩選 會計科目/類別/供應商 關鍵字
- if (accountingsubjects_select != '00') {
- AND_list.push('會計科目 = "' + accountingsubjects_select + '"')
- }
- if (category_select != '00') {
- AND_list.push('類別 = "' + category_select + '"')
- }
- if (serialnumber_select != '') {
- AND_list.push('流水號 = "' + serialnumber_select + '"')
- }
- if (supplier_select != '00') {
- AND_list.push('零件表.供應商 = "' + supplier_select + '"')
- }
- if (component_name_select != '00') {
- AND_list.push('名稱 = "' + component_name_select + '"')
- } else if (component_name_input != '') {
- AND_list.push('名稱 LIKE "%' + component_name_input + '%"')
- }
- console.log("AND_list: ", AND_list)
- if (AND_list != '') {
- sql += ' WHERE ' + AND_list.join(' AND ');
- }
-
- var sql_data = {
- "sql":sql
- };
- console.log("sql_data: ", sql_data)
- $.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])
- var data = " ";
- if (res.labels == '') {
- data += '-- 無符合關鍵字之資料 --'
- } else {
- data += '<table class="table table-bordered" style="margin-top: 10px;">';
- data += '<tr>';
- for (let fields = 0; fields < res.sql_field.length; fields++) {
- data += '<th>' + res.sql_field[fields][0] + '</th>';
- }
- data += '<th>' + '輸入零件數量' + '</th>';
- data += '<th>' + '加入此 BOM 表' + '</th>';
- data += '</tr>';
- for (let items = 0; items < res.labels.length; items++) {
- data += '<tr>';
- for (let item = 0; item < res.labels[items].length; item++) {
- data += '<td id="' + res.labels[items][0] + '_' + item + '">' + res.labels[items][item] + '</td>';
- };
- data += '<td><input id="BOM_amount' + res.labels[items][0] + '" style="height: 25px; width: 45px;"></td>';
- data += '<td><input type="button" class="input-cond-add" value="加入" onclick="insert_moduel(\'' + res.labels[items][0] + '\')"></td>';
- data += '</tr>';
- };
- data += '</table>';
- }
- var sectorSelect = document.getElementById("result");
- sectorSelect.innerHTML = data;
- }, 'json');
- }
- </script>
- <div id="result">
- <!-- <table>
- </table> -->
- </div>
-
-
-
-
-
-
- <!-- <table class="table table-bordered" style="margin-top: 20px;">
- <tr>
- {% for i1 in labels %}
- <th>{{i1}}</th>
- {% endfor %}
- </tr>
- {% for i in content %}
- <tr>
- <td>{{ i[0] }}</td>
- <td>{{ i[1] }}</td>
- <td>{{ i[2] }}</td>
- <td>{{ i[3] }}</td>
- <td>{{ i[4] }}</td>
- <td>{{ i[5] }}</td>
- <td>{{ i[6] }}</td>
- <td>{{ i[7] }}</td>
- </tr>
- {% endfor %}
- </table> -->
- </body>
- </html>
|