rita
/
ERP


			
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688
							<!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)
                    }
                }
            })

            // !!! 將模組加入規格表中 (留下內部料號, 其他 NULL)
            var sql = '';
            sql += 'INSERT INTO 規格表 (`內部料號`, `名稱`)' +
                   'VALUES ("' + company_id + '", "' + 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 + " 建立成功!")
                    // 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 + ": 零件增加成功!")
                },
                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>
        var BOM_company_id;
        // 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();
            console.log("accountingsubjects_select: " + accountingsubjects_select)
            console.log("category_select: " + category_select)
            console.log("serialnumber_select: " + serialnumber_select)
            console.log("supplier_select: " + supplier_select)
            
            // 若要查詢 BOM 表內容要以內部料號查詢, 所以輸入欄位不可空
            if (accountingsubjects_select == '00' || category_select == '00' || serialnumber_select == '' || supplier_select == '00' ) {
                alert("若要查詢 BOM 表\n請先找到內部料號對應的會計科目、類別、流水號、供應商\n輸入完成再按下 [BOM 表查詢]");
            } else {
                // 內部料號組合
                BOM_company_id = accountingsubjects_select + category_select + serialnumber_select + supplier_select;
                console.log("BOM_company_id: " + BOM_company_id)

                sql = 'SELECT * FROM `' + BOM_company_id + '`';
                var sql_data = { "sql":sql };
                console.log("sql_data: ", sql_data)

                $.ajax({
                    type:"GET",
                    url:"/sql_get",
                    dataType:"JSON",
                    data:sql_data,
                    success: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 += '<th>' + '修改' + '</th>';
                            data += '<th>' + '刪除' + '</th>';
                            data += '</tr>';
                            for (let items = 0; items < res.labels.length; items++) {
                                data += '<tr>';
                                for (let item = 0; item < res.labels[items].length; item++) {
                                    if (res.labels[items][item] == null) {
                                        data += '<td id="' + res.labels[items][0] + '_' + item + '">' + '' + '</td>';
                                    } else {
                                        data += '<td id="' + res.labels[items][0] + '_' + item + '">' + res.labels[items][item] + '</td>';
                                    }
                                };
                                data += '<td><input type="button" class="input-cond-add" value="修改" onclick="update_BOM_item(\'' + res.labels[items][0] + '\')"></td>';
                                data += '<td><input type="button" class="input-cond-delete" value="刪除" onclick="delete_BOM_item(\'' + res.labels[items][0] + '\')"></td>';
                                data += '</tr>';
                            };
                            data += '<tr>';
                            data += '<td><input type="button" style="width: auto;" class="input-cond-add" value="匯出表單" onclick="export_BOM_table(\'' + BOM_company_id + '\')"></td>';
                            data += '<td></td>';
                            data += '<td></td>';
                            data += '<td></td>';
                            data += '<td></td>';
                            data += '<td></td>';
                            data += '<td><input type="button" style="width: auto;" class="input-cond-delete" value="刪除此 BOM 表" onclick="delete_BOM_table(\'' + BOM_company_id + '\')"></td>';
                            data += '</tr>';
                            data += '</table>';
                        }
                        var sectorSelect = document.getElementById("result");
                        sectorSelect.innerHTML = data;
                    },
                    error: function (thrownError) {
                        if (thrownError.statusText == "INTERNAL SERVER ERROR") {
                            alert("BOM 表: 無此內部料號 " + BOM_company_id + " 之資料表")
                        } else {
                            console.log("BOM 表查詢 thrownError" + thrownError)
                        }
                        var data = "";
                        var sectorSelect = document.getElementById("result");
                        sectorSelect.innerHTML = data;
                    }
                })

            }
        }

        // 匯出 BOM 表
        function export_BOM_table(BOM_company_id) {
            console.log("匯出 BOM 表: " + BOM_company_id)
            // sql = 'SELECT * FROM `' + BOM_company_id + '`';      // 原始 BOM 表資料, 未來可加上 零件名稱
            var sql = 'SELECT ' + BOM_company_id + '.內部料號, ';
            sql += '零件表.名稱, ';
            sql += BOM_company_id + '.數量, ';
            sql += BOM_company_id + '.位置, ';
            sql += BOM_company_id + '.備註, ';
            sql += BOM_company_id + '.設計原因 ';
            sql += 'FROM `' + BOM_company_id + '` ';
            sql += ' INNER JOIN 零件表';
            sql += ' ON 零件表.內部料號 = ' + BOM_company_id + '.內部料號';
            
            var sql_data = { "sql":sql };
            console.log("sql_data: ", sql_data)

            $.ajax({
                type:"GET",
                url:"/export_excel/" + BOM_company_id,
                dataType:"JSON",
                data:sql_data,
                success:function (res) {
                    alert(BOM_company_id + " 匯出 Excel 成功\n檔案路徑: \n" + res.file_location)
                },
                error: function (thrownError) {
                    if (thrownError.statusText == "INTERNAL SERVER ERROR") {
                        alert("BOM 表: 無此內部料號 " + BOM_company_id + " 之資料表")
                    } else {
                        console.log("BOM 表查詢 thrownError" + thrownError)
                    }
                }
            })

            
        }

        // 刪除此 BOM 表
        function delete_BOM_table(BOM_company_id) {
            console.log("刪除 BOM 表: " + BOM_company_id)
        }

        // 修改 BOM 表內項目
        function update_BOM_item(company_id) {
            console.log("修改 " + company_id)
            for (let i = 1; i < 5; i++) {
                var target_id = document.getElementById(company_id + '_' + i);
                var old_name = target_id.innerText;
                console.log('old_name: ', old_name)
                target_id.innerHTML = "";
                textarea = '';
                textarea += '<input id="'+ company_id + '_' + i + '_ta' + '" value="' + old_name + '" style="height: 25px; width: auto">';
                if (i == 4) {
                    textarea += '<input type="button" value="OK" onclick="ComfirmUpdate_BOM_item(\'' + company_id + '\')">';
                }
                target_id.insertAdjacentHTML('beforeend', textarea);
            }
        }

        // 修改確認 BOM 表內項目
        function ComfirmUpdate_BOM_item(company_id) {
            console.log("修改確認 " + company_id )
            var new_amount_value = $('#' + company_id + '_1_ta').val();
            var new_position_value = $('#' + company_id + '_2_ta').val();
            var new_remark_value = $('#' + company_id + '_3_ta').val();
            var new_reason_value = $('#' + company_id + '_4_ta').val();

            sql = '';
            sql += 'UPDATE ' + BOM_company_id + ' SET `數量` = "' + new_amount_value + '"';
            sql += ', `位置` = "' + new_position_value + '"';
            sql += ', `備註` = "' + new_remark_value + '"';
            sql += ', `設計原因` = "' + new_reason_value + '"';
            sql += ' WHERE `內部料號` = "' + company_id + '";'
            console.log('sql: ' + sql)
            var sql_data = { "sql":sql };

            $.ajax({
                type:"GET",
                url:"/sql_get",
                dataType:"JSON",
                data:sql_data,
                success:function (res) {
                    alert("規格表: 修改成功 !")
                    search_BOM_table();
                },
                error: function (thrownError) {
                    if (thrownError.statusText == "INTERNAL SERVER ERROR") {
                        alert("規格表: 內部料號 " + company_id + " 修改未成功")
                    } else {
                        console.log("修改規格表內容 thrownError" + thrownError)
                    }
                }
            }) 
        }

        // 刪除 BOM 表內項目
        function delete_BOM_item(company_id) {
            console.log("刪除 " + company_id)
            var delete_data = confirm("確定要刪除 " + BOM_company_id + " BOM 表內的 " + company_id + "？")
            if (delete_data) {
                // 刪除 BOM 表內的指定零件
                var sql = 'DELETE FROM ' + BOM_company_id + ' WHERE 內部料號 = "' + company_id + '";'
                var sql_data = { "sql":sql };

                $.ajax({
                    type:"GET",
                    url:"/sql_get",
                    dataType:"JSON",
                    data:sql_data,
                    success:function (res) {
                        alert("BOM 表: 項目刪除成功!")
                        search_BOM_table();
                    },
                    error: function (thrownError) {
                        if (thrownError.statusText == "INTERNAL SERVER ERROR") {
                            alert("BOM 表: 無內部料號 " + company_id + " 之項目資料")
                        } else {
                            alert("BOM 表項目刪除錯誤: " + thrownError)
                        }
                    }
                })
                
            }
            
        }

        // 儲存欲加入的零件 數量
        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])
                // console.log("res.Component_id[0]:" + res.Component_id[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.Component_id[items] + '_' + item + '">' + res.labels[items][item] + '</td>';
                            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"></div>
    
</body>

</html>