rita
/
ERP


			
							12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181
							<!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">
    <script src="https://cdn.bootcss.com/jquery/3.2.1/jquery.min.js"></script>

    <script>

        var USERNAME = '{{USERNAME}}';

        console.log("USERNAME: " + USERNAME);

        $(function(){

            // var manual_createBOM = confirm("請先在上方, 輸入新 BOM 表內部料號及名稱 \

            //                                 \n再到下方, 搜尋零件並輸入數量, 再按下[加入] \

            //                                 \n可以透過上方的 [查看現有加入零件] 檢查所選零件 \

            //                                 \n最後, 按下 [新增模組/系統成品] 即可建立 BOM !")

            // if (manual_createBOM) {

            //     var manual_searchBOM = confirm("若要查詢 BOM 表 \

            //                                     \n可以先從 [零件表查詢] 中找到內部料號 \

            //                                     \n輸入完成再按下 [BOM 表查詢]")

            // } 

        });

    </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>
    <div id="ERP_header">
        <!-- 匯入共同使用的 header.html 內容 -->
        {% include 'ERP_header.html' %}
    </div>
    <!-- 建立 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" 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>
    <hr>
    可搜尋欲加入的零件或是查詢 BOM 表內容:<br>
    <!-- 索取現有零件用 --------------------------------------------------------------------------------------- -->
    會計科目:
    <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" 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();">
    <div id="result"></div>
    

    <script>

        var BOM_company_id;

        // 儲存欲加入的零件 數量_顯示用有加名稱

        var module_amount_list = [];

        // 儲存欲加入的零件 數量_sql 用無名稱注意格式

        var module_amount_sqllist = [];  


        // BOM 表查詢

        function search_BOM_table() {

            var accountingsubjects_select = $("#accountingsubjects").val();

            var category_select = $("#category").val();

            var serialnumber_select = $("#serialnumber").val();

            serialnumber_select = serialnumber_select.padStart(4, '0')

            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 == '0000' || 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 + '` ORDER BY 內部料號';

                sql = 'SELECT 零件表.內部料號, 零件表.名稱, 規格表.原廠料號, 規格表.圖片, 數量, 位置, ' + BOM_company_id + '.備註, 設計原因, 填寫人' + 

                      ' FROM (`' + BOM_company_id + '`' + 

                            ' INNER JOIN 零件表' + 

                            ' ON 零件表.內部料號 = ' + BOM_company_id + '.內部料號' + 

                            ' )'  + 

                      ' INNER JOIN 規格表' + 

                      ' ON 規格表.內部料號 = ' + BOM_company_id + '.內部料號' + 

                      ' ORDER BY 內部料號'

                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 = "";

                        data += '查詢結果: 共 ' + res.labels.length + ' 筆<br>'

                        data += '<table id="table_BOM" 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 += '<th>原廠料號</th>';

                        data += '<th>圖片</th>';

                        data += '<th>數量</th>';

                        data += '<th>位置</th>';

                        data += '<th>備註</th>';

                        data += '<th>設計原因</th>';

                        data += '<th>填寫人</th>';

                        data += '<th>修改</th>';

                        data += '<th>刪除</th>';

                        data += '</tr>';

                        if (res.labels != '') {

                            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 {

                                        if ((item == 3) && (res.labels[items][item].indexOf(".pdf") != -1)) {

                                            data += '<td><a href="' + res.labels[items][item] + '" target="_blank">圖片連結</a></td>'

                                        } else if ((item == 3) && (res.labels[items][item].indexOf(".png") != -1)) {

                                            data += '<td><a href="' + res.labels[items][item] + '" target="_blank"><img src="' + 'http://60.250.156.230:3000/rita/ERP/raw/master/SHT11.png' + '" width="50px"></a></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 class="noExl">';

                            
                        data += '<td>';

                        // data += '<select id="newcom_id" onChange="">';

                        // data += '<option value="00"></option>';

                        // data += '{% for data in Company_ID_data %}';

                        // data += '<option value="{{data[0]}}">{{data[0]}}</option>';

                        // data += '{% endfor %}';

                        // data += '</select>';

                        data += '<input list="insert_BOM_module" id="newcom_id" style="height: 25px;" onChange="get_company_id()">';

                        data += '<datalist id="insert_BOM_module">';

                        data += '<option value="">可輸入名稱查找內部料號</option>';

                        // data += '{% for data in Component_id_name %}';

                        // data += '<option value="{{data[0]}}">{{data[1]}}</option>';

                        // data += '{% endfor %}';

                        data += '{% for data in Component_id_name_salesnum %}';

                        data += '{% if data[2] == "" or data[2] == None %}';

                        data += '<option value="{{data[0]}}">{{data[1]}}, (無原廠料號)</option>';

                        data += '{% else %}';

                        data += '<option value="{{data[0]}}">{{data[1]}}, {{data[2]}}</option>';

                        data += '{% endif %}';

                        data += '{% endfor %}';

                        data += '</datalist>';

                        data += '</td>';


                        data += '<td>';

                        data += '(自動代入)'

                        // data += '<select id="newcom_id" onChange="">';

                        // data += '<option value="00"></option>';

                        // data += '{% for data in Component_name_data %}';

                        // data += '<option value="{{data[0]}}">{{data[0]}}</option>';

                        // data += '{% endfor %}';

                        // data += '</select>';

                        data += '</td>';


                        data += '<td></td>';

                        data += '<td></td>';


                        data += '<td><input id="newcom_1_ta" value="" style="height: 25px; width: auto" size="5"></td>';

                        data += '<td><input id="newcom_2_ta" value="" style="height: 25px; width: auto" size="15"></td>';

                        data += '<td><input id="newcom_3_ta" value="" style="height: 25px; width: auto" size="10"></td>';

                        data += '<td><input id="newcom_4_ta" value="" style="height: 25px; width: auto" size="10"></td>';

                        data += '<td>';

                        // data += '<input list="insert_BOM_person_module" id="newcom_name" style="height: 25px;" onChange="">';

                        // data += '<datalist id="insert_BOM_person_module">';

                        // data += '<option value="Andrey"></option>';

                        // data += '<option value="Amy"></option>';

                        // data += '<option value="Allen"></option>';

                        // data += '<option value="Gina"></option>';

                        // data += '<option value="FatWolf"></option>';

                        // data += '<option value="Rita"></option>';

                        // data += '</datalist>';

                        data += '(自動代入)';

                        data += '</td>';


                        data += '<td>';

                        data += '<input type="button" style="width: auto;" class="input-cond-add" value="新增零件至 BOM" onclick="BOM_insert_component(\'' + BOM_company_id + '\')">';

                        data += '</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>';

                        data += '<input type="button" style="width: auto;" class="input-cond-add" value="匯出表單" onclick="export_BOM_table(\'' + BOM_company_id + '\')">';

                        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 get_company_id() {

            var new_component_name = $("#newcom_id").val();

            console.log("new_component_name: " + new_component_name)        // 03040001T01

        }


        // 新增零件至 BOM

        function BOM_insert_component(BOM_company_id) {

            var new_com_0 = $("#newcom_id").val();

            var new_com_1 = $("#newcom_1_ta").val()

            var new_com_2 = $("#newcom_2_ta").val()

            var new_com_3 = $("#newcom_3_ta").val()

            var new_com_4 = $("#newcom_4_ta").val()

            // var new_com_5 = $("#newcom_name").val()

            console.log("new_com_0: " + new_com_0)

            console.log("new_com_1: " + new_com_1)

            console.log("new_com_2: " + new_com_2)

            console.log("new_com_3: " + new_com_3)

            console.log("new_com_4: " + new_com_4)

            // console.log("new_com_5: " + new_com_5)

            var sql = 'INSERT INTO `' + BOM_company_id + '`';

            sql += ' VALUES ("' + new_com_0 + '", "' + new_com_1 + '", "' + new_com_2 + '", "' + new_com_3 + '", "' + new_com_4 + '", "' + USERNAME + '");';

            console.log("sql: ", sql)

            var sql_data = { "sql":sql };


            $.ajax({

                type:"GET",

                url:"/sql_get",

                dataType:"JSON",

                data:sql_data,

                success:function (res) {

                    search_BOM_table()

                },

                error: function (thrownError) {

                    if (thrownError.statusText == "INTERNAL SERVER ERROR") {

                        alert("BOM 表: " + BOM_company_id + " 新增零件未成功")

                    } else {

                        console.log("BOM 表新增零件 thrownError" + thrownError)

                    }

                }

            })

            
        }


        // 匯出 BOM 表

        function export_BOM_table(BOM_company_id) {

            // alert("匯出功能測試中")

            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 += 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) {

                    document.location.href = '/download/BOM_' + BOM_company_id + '.xlsx'

                    alert(BOM_company_id + " 匯出 Excel 成功\n檔案路徑: \n" + res.file_location)

                    // var html = '<meta http-equiv="content-type" content="application/vnd.ms-excel; charset=UTF-8" /><title>Excel</title>';

                    // html += '';

                    // html += document.getElementById('table_BOM').innerHTML + '';

                    // window.open('data:application/vnd.ms-excel,' + encodeURIComponent(html));

                    // console.log("res.sql_data_new: " + res.sql_data_new + typeof(res.sql_data_new))

                    // TableToExcel.convert(table[0],{

                    //     name:BOM_company_id + '.xlsx',

                    //     sheet:{ name:BOM_company_id }

                    // });


                    // $("#table_BOM").table2excel({

                    //     exclude:".noExl",

                    //     name:BOM_company_id + "_0106",

                    //     filename:BOM_company_id,

                    //     fileext:".xls"

                    // });

                    // window.open('data:application/vnd.ms-excel,' + encodeURIComponent(res.sql_data_new));


                    console.log("Excel create")

                },

                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)

            var drop_table = confirm("確定要刪除 " + BOM_company_id + " 資料表？\n此動作不可回復")

            if (drop_table) {

                sql = 'DROP TABLE ' + BOM_company_id + ';';

                console.log("sql: " + sql)

                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) {

                        alert("BOM 表: " + BOM_company_id + "刪除成功 !")

                    },

                    error: function (thrownError) {

                        if (thrownError.statusText == "INTERNAL SERVER ERROR") {

                            alert("BOM 表: " + BOM_company_id + " 刪除未成功")

                        } else {

                            console.log("BOM Table 刪除 thrownError" + thrownError)

                        }

                    }

                })


                var sql = 'DELETE FROM 規格表 WHERE 內部料號 = "' + BOM_company_id + '";'

                var sql_data = { "sql":sql };

                $.ajax({

                    type:"GET",

                    url:"/sql_get",

                    dataType:"JSON",

                    data:sql_data,

                    success:function (res) {

                        alert("規格表: " + BOM_company_id + "刪除成功 !")

                    },

                    error: function (thrownError) {

                        if (thrownError.statusText == "INTERNAL SERVER ERROR") {

                            alert("規格表: " + BOM_company_id + " 刪除未成功")

                        } else {

                            console.log("規格表: 刪除 thrownError" + thrownError)

                        }

                    }

                }) 


                var sql = 'DELETE FROM 零件表 WHERE 內部料號 = "' + BOM_company_id + '";'

                var sql_data = { "sql":sql };

                $.ajax({

                    type:"GET",

                    url:"/sql_get",

                    dataType:"JSON",

                    data:sql_data,

                    success:function (res) {

                        alert("零件表: " + BOM_company_id + "刪除成功 !")

                    },

                    error: function (thrownError) {

                        if (thrownError.statusText == "INTERNAL SERVER ERROR") {

                            alert("零件表: " + BOM_company_id + " 刪除未成功")

                        } else {

                            console.log("零件表: 刪除 thrownError" + thrownError)

                        }

                    }

                }) 

                
                location.reload()

            }

        }


        // 修改 BOM 表內項目

        function update_BOM_item(company_id) {

            console.log("修改 " + company_id)

            for (let i = 4; i < 8; 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 = '<input id="'+ company_id + '_' + i + '_ta' + '" value="' + old_name + '" style="height: 25px; width: 100px">';

                if (i == 7) {

                    textarea += '<input type="button" value="OK" onclick="ComfirmUpdate_BOM_item(\'' + company_id + '\')">';

                }

                target_id.insertAdjacentHTML('beforeend', textarea);

            }

            // var target_id = document.getElementById(company_id + '_8');

            // var old_name = target_id.innerText;

            // console.log("old_name-NAME: " + old_name)

            // target_id.innerHTML = "";

            // textarea = '<input list="insert_BOM_person_module" id="newcom_name" style="height: 25px; width: 100px" onChange="">';

            // textarea += '<datalist id="insert_BOM_person_module">' +

            //             '<option value="Andrey"></option>' +

            //             '<option value="Amy"></option>' +

            //             '<option value="Allen"></option>' +

            //             '<option value="Gina"></option>' +

            //             '<option value="FatWolf"></option>' +

            //             '<option value="Rita"></option>' +

            //             '</datalist>';

            
            // target_id.insertAdjacentHTML('beforeend', textarea);

            // $(".insert_BOM_person_module").find("option:contains(" + old_name + ")").attr("selected",true);

            // // $("#insert_BOM_person_module select").val(old_name).change();

        }


        // 修改確認 BOM 表內項目

        function ComfirmUpdate_BOM_item(company_id) {

            console.log("修改確認 " + company_id )

            var new_amount_value = $('#' + company_id + '_4_ta').val();

            var new_position_value = $('#' + company_id + '_5_ta').val();

            var new_remark_value = $('#' + company_id + '_6_ta').val();

            var new_reason_value = $('#' + company_id + '_7_ta').val();

            // var new_person_value = $('#newcom_name').val();

            // console.log("new_person_value: " + new_person_value)


            sql = 'UPDATE ' + BOM_company_id + ' SET `數量` = "' + new_amount_value + '"' +

                  ', `位置` = "' + new_position_value + '"' +

                  ', `備註` = "' + new_remark_value + '"' +

                  ', `設計原因` = "' + new_reason_value + '"' +

                  ', `填寫人` = "' + USERNAME + '"' +

                  ' 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) {

                    search_BOM_table();

                    alert("BOM 表: 修改成功 !")

                },

                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)

                        }

                    }

                })

                
            }

            
        }


        // 加入 BOM 表

        function insert_module(company_id) {

            var select_amount = $("#BOM_amount" + company_id).val();

            select_amount = parseInt(select_amount)

            console.log("select_amount: " + select_amount)

            // console.log("typeof(select_amount): " + typeof(select_amount))      // string

            var select_name = $("#" + company_id + "_5").text();

            console.log("select_name: " + select_name)


            var repeat_word = module_amount_list.indexOf(company_id)

            console.log("repeat_word: " + repeat_word)

            if (select_amount != '') {

                if (repeat_word != -1) {

                    module_amount_list.splice(repeat_word, 3)

                }

                module_amount_list.push(company_id)

                module_amount_list.push(select_name)

                module_amount_list.push(select_amount)

                // console.log("現有零件: " + module_amount_list)

                alert("零件加入成功 !\n\"" + select_name + "\"×" + select_amount)

                view_component();

            } else if (select_amount == 0) {

                if (repeat_word != -1) {

                    module_amount_list.splice(repeat_word, 3)

                }

                view_component();

            } else {

                alert("請輸入零件數量, 且數量為正整數")

            }

        }


        // 輸入完類別後, 流水號自動帶入

        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();

        //     serialnumber_select = serialnumber_select.padStart(4, '0')

        //     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 != '0000') {

        //         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();

            serialnumber_select = serialnumber_select.padStart(4, '0')

            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 供應商.供應商 = 零件表.供應商 ' +

                        ') ' +

                    'INNER JOIN 規格表 ' +

                    'ON 規格表.內部料號 = 零件表.內部料號 ';

            // 篩選 會計科目/類別/供應商 關鍵字

            if (accountingsubjects_select != '00') {

                AND_list.push('會計科目 = "' + accountingsubjects_select + '"')

            }

            if (category_select != '00') {

                AND_list.push('類別 = "' + category_select + '"')

            }

            if (serialnumber_select != '0000') {

                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>會計科目</th>';

                    data += '<th>類別</th>';

                    data += '<th>流水號</th>';

                    data += '<th>供應商</th>';

                    data += '<th>名稱</th>';

                    data += '<th>原廠料號</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++) {

                            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>';

                            }

                        };

                        // <input onkeyup="if(this.value.length==1){this.value=this.value.replace(/[^0-9]/g,'')}else{this.value=this.value.replace(/\D/g,'')}" onafterpaste="if(this.value.length==1){this.value=this.value.replace(/[^0-9]/g,'')}else{this.value=this.value.replace(/\D/g,'')}">

                        data += '<td><input onkeyup="if(this.value.length==1){this.value=this.value.replace(/[^0-9]/g,\'\').replace(\'.\',\'\')}else{this.value=this.value.replace(/\\D/g,\'\').replace(\'.\',\'\')}" onafterpaste="if(this.value.length==1){this.value=this.value.replace(/[^0-9]/g,\'\').replace(\'.\',\'\')}else{this.value=this.value.replace(/\\D/g,\'\').replace(\'.\',\'\')}"'

                        data += 'id="BOM_amount' + res.labels[items][0] + '" style="height: 25px; width: 90px;"></td>';

                        data += '<td><input type="button" class="input-cond-add" value="加入" onclick="insert_module(\'' + res.labels[items][0] + '\')"></td>';

                        data += '</tr>';

                    };

                    data += '</table>';

                }

                var sectorSelect = document.getElementById("result");

                sectorSelect.innerHTML = data;

            }, 'json');

        }


        // 查看現有零件

        function view_component() {

            var data = '現有零件: <br>';

            // 網頁顯示用 "內部料號"_"名稱"_"數量"<br>

            for (let i = 0; i < module_amount_list.length; i++) {

                if (i%3 == 0) {

                    data += '"' + module_amount_list[i] + '"_'

                } else if (i%3 == 1) {

                    data += '"' + module_amount_list[i] + '"_'

                } else if (i%3 == 2) {

                    data += '"' + module_amount_list[i] + '"<br>'

                }

            }

            
            // data += 'SQL: <br>' + 

            //         'INSERT INTO `' + 'company_id' + '` (`內部料號`, `數量`) ' +

            //         'VALUES ' + module_amount_sqllist.join(', ') + ';';

            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)


            if (accountingsubjects_select == '00' || accountingsubjects_select == '00' || supplier_select == '00' || component_name_select == '') {

                alert("請先輸入 BOM 表會計科目、類別、供應商及名稱\n再新建模組")

            } else {

                // !!! 將模組加入零件表中

                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,

                    async:false,

                    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 + '");';

                console.log("sql: " + sql)

                var sql_data = { "sql":sql };


                $.ajax({

                    type:"GET",

                    url:"/sql_get",

                    dataType:"JSON",

                    data:sql_data,

                    async:false,

                    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,' +

                    '位置 varchar(100) NULL,' +

                    '備註 varchar(200) NULL,' +

                    '設計原因 varchar(200) NULL,' +

                    '填寫人 varchar(20) NULL,' + 

                    'PRIMARY KEY (內部料號)' +

                    ');';

                console.log("sql: " + sql)

                var sql_data = { "sql":sql };


                $.ajax({

                    type:"GET",

                    url:"/sql_get",

                    dataType:"JSON",

                    data:sql_data,

                    async:false,

                    success:function (res) {

                        alert("資料表 " + company_id + " 建立成功!")

                    },

                    error: function (thrownError) {

                        if (thrownError.statusText == "INTERNAL SERVER ERROR") {

                            alert("資料表: 內部料號 " + company_id + " 已存在, 請重新輸入")

                        } else {

                            console.log("新建模組 Table thrownError" + thrownError)

                        }

                    }

                })


                // 儲存欲加入的零件 數量_sql 用無名稱注意格式

                var module_amount_sqllist = [];  

                // SQL 語法

                var sql_data_list = '';

                for (let i = 0; i < module_amount_list.length; i++) {

                    if (i%3 == 0) {

                        // 內部料號

                        sql_data_list = '("' + module_amount_list[i] + '", '

                    } 

                    if (i%3 == 2) {

                        // 數量 + 填寫人

                        sql_data_list += '"' + module_amount_list[i] + '", "' + USERNAME + '")'

                        module_amount_sqllist.push(sql_data_list)

                    }

                }


                console.log("module_amount_sqllist: " + module_amount_sqllist)


                // !!! 將所選零件加入模組 Table

                var sql = '';

                sql += 'INSERT INTO `' + company_id + '` (`內部料號`, `數量`, `填寫人`) ' +

                        'VALUES ' + module_amount_sqllist.join(', ') + ';';

                console.log("sql: " + sql)

                var sql_data = { "sql":sql };

                
                if (module_amount_sqllist.length == 0) {

                    alert("資料表 " + company_id + ": 加入零件為空, 故此 BOM 表無零件")

                    location.reload()

                } else {

                    $.ajax({

                        type:"GET",

                        url:"/sql_get",

                        dataType:"JSON",

                        data:sql_data,

                        async:false,

                        success:function (res) {

                            alert("資料表 " + company_id + ": 零件增加成功!")

                            location.reload()

                        },

                        error: function (thrownError) {

                            if (thrownError.statusText == "INTERNAL SERVER ERROR") {

                                alert("內部料號 " + company_id + " 已存在, 請重新輸入")

                            } else {

                                console.log("零件加入模組 thrownError" + thrownError)

                            }

                        }

                    })

                }

            }

        }

    
    </script>

    <br>
    <hr>
    <!-- <input type="button" id="view_component" value="查看現有加入零件" onclick="view_component();"> -->
    <div id="view_component_data">現有零件 :</div>
    <br>
    零件加入完成後, 請按下
    <input type="button" id="create_module" value="新增模組/系統/成品" onclick="create_module();">
    

    <!-- <script>

        
        // 查看現有零件

        function view_component() {

            var data = '現有零件: <br>';

            // 網頁顯示用 "內部料號"_"名稱"_"數量"<br>

            for (let i = 0; i < module_amount_list.length; i++) {

                if (i%3 == 0) {

                    data += '"' + module_amount_list[i] + '"_'

                } else if (i%3 == 1) {

                    data += '"' + module_amount_list[i] + '"_'

                } else if (i%3 == 2) {

                    data += '"' + module_amount_list[i] + '"<br>'

                }

            }

            
            // data += 'SQL: <br>' + 

            //         'INSERT INTO `' + 'company_id' + '` (`內部料號`, `數量`) ' +

            //         'VALUES ' + module_amount_sqllist.join(', ') + ';';

            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 + '");';

            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,' +

                   '位置 varchar(100) NULL,' +

                   '備註 varchar(200) NULL,' +

                   '設計原因 varchar(200) NULL,' +

                   '填寫人 varchar(20) NULL,' + 

                   'PRIMARY KEY (內部料號)' +

                   ');';

            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 + " 建立成功!")

                    module_amount_sqllist = [];  

                    // SQL 語法

                    var sql_data_list = '';

                    for (let i = 0; i < module_amount_list.length; i++) {

                        if (i%3 == 0) {

                            sql_data_list = '("' + module_amount_list[i] + '", '

                        } 

                        if (i%3 == 2) {

                            sql_data_list += '"' + module_amount_list[i] + '")'

                            module_amount_sqllist.push(sql_data_list)

                        }

                    }


                    // !!! 將所選零件加入模組 Table

                    var sql = '';

                    sql += 'INSERT INTO `' + company_id + '` (`內部料號`, `數量`) ' +

                        'VALUES ' + module_amount_sqllist.join(', ') + ';';

                    console.log("sql: " + sql)

                    var sql_data = { "sql":sql };

                    
                    if (module_amount_sqllist.length == 0) {

                        alert("資料表 " + company_id + ": 加入零件為空, 故此 BOM 表無零件")

                        location.reload()

                    } else {

                        $.ajax({

                            type:"GET",

                            url:"/sql_get",

                            dataType:"JSON",

                            data:sql_data,

                            success:function (res) {

                                alert("資料表 " + company_id + ": 零件增加成功!")

                                location.reload()

                            },

                            error: function (thrownError) {

                                if (thrownError.statusText == "INTERNAL SERVER ERROR") {

                                    alert("內部料號 " + company_id + " 已存在, 請重新輸入")

                                } else {

                                    console.log("零件加入模組 thrownError" + thrownError)

                                }

                            }

                        })

                    }


                },

                error: function (thrownError) {

                    if (thrownError.statusText == "INTERNAL SERVER ERROR") {

                        alert("資料表: 內部料號 " + company_id + " 已存在, 請重新輸入")

                    } else {

                        console.log("新建模組 Table thrownError" + thrownError)

                    }

                }

            })


        }

    </script> -->
    
    <br>
    <br>
    <!-- <input type="button" style="width: auto;" class="input-cond-add" value="匯出表單" onclick="export_BOM_table('03030001T01')"> -->

    <!-- <iframe width="100px" src="/plugins/pdfjs-1.4.20/web/viewer.html?file=http://60.250.156.230:3000/rita/ERP/src/1ac36a99cc9721451b4baafd67d98b54bb315bcd/pH_probe.pdf"></iframe> -->
</body>

</html>