rita
/
ERP


			
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248
							<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <title>{{ title }}</title>
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">

    <!-- 新 Bootstrap4 核心 CSS 文件 -->
    <link rel="stylesheet" href="https://cdn.bootcss.com/bootstrap/4.1.0/css/bootstrap.min.css">
    <!-- jQuery文件。务必在bootstrap.min.js 之前引入 -->
    <script src="https://cdn.bootcss.com/jquery/3.2.1/jquery.min.js"></script>
    <!-- popper.min.js 用于弹窗、提示、下拉菜单 -->
    <script src="https://cdn.bootcss.com/popper.js/1.12.5/umd/popper.min.js"></script>
    <!-- 最新的 Bootstrap4 核心 JavaScript 文件 -->
    <script src="https://cdn.bootcss.com/bootstrap/4.1.0/js/bootstrap.min.js"></script>
    <!--可用來建立使用者小圖示-->
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
</head>

<body>
    <!-- 這裡新增零件表中的零件 -->
    請依序輸入以下欄位, 再按下 "新增零件" 按鈕:<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="renewSN();">
        <option value="00"></option>
        {% for data in Category_data %}
            <option value="{{data[0]}}">{{data[0]}}-{{data[1]}}</option>
        {% endfor %}
    </select>
    流水號:
    <input id="serialnumber" value="—" style="height: 25px; width: 45px;" readonly>
    供應商:
    <select id="supplier" onChange="">
        <option value="00"></option>
        {% for data in Supplier_data %}
            <option value="{{data[0]}}">{{data[0]}}-{{data[1]}}</option>
        {% endfor %}
    </select>
    零件名稱:
    <input list="conponents" id="component_name_select">
    <datalist id="conponents">
        <option value=""></option>
        {% for data in Component_data %}
            <option value="{{data[0]}}">{{data[0]}}</option>
        {% endfor %}
    </datalist>
    <br>
    
    <input type="button" id="create_component" value="新增零件" onclick="create_component();">

    <div id="result">
        <!-- <table>
        </table> -->
    </div>

    <script>
        // 輸入完類別後, 流水號自動帶入
        function renewSN() {
            var accountingsubjects_select = $("#accountingsubjects").val();
            var category_select = $("#category").val();
            $.get('/sn_get/' + accountingsubjects_select + '/' + category_select, '', function (res) {
                // console.log(res.new_sn)
                $('#serialnumber').val(res.new_sn)
            }, 'json');
        }

        // 零件表 新增零件
        function create_component() {
            // 會計科目
            var accountingsubjects_select = $("#accountingsubjects").val();
            // 類別
            var category_select = $("#category").val();
            // 流水號 → 從資料庫找到最大的流水號, 然後 +1
            var serialnumber_select = $("#serialnumber").val();
            // 放到 renewSN 方法內執行
            // 供應商
            var supplier_select = $("#supplier").val();
            // 零件名稱
            var component_name_select = $("#component_name_select").val();
            // 內部料號組合
            var company_id = accountingsubjects_select + category_select + serialnumber_select + supplier_select;
            var AND_list = [];
            // console.log(accountingsubjects_select, category_select, serialnumber_select, supplier_select, component_name_select)

            var sql = '';
            sql += 'INSERT INTO 零件表 ' +
                   'VALUES ("' + company_id + '", "' + accountingsubjects_select + '", "' + category_select + '", "' + serialnumber_select + '", "';
            sql += supplier_select + '", "' + component_name_select + '");';
            console.log("sql: " + sql)

            var sql_data = {
                "sql":sql
            };

            $.ajax({
                type:"GET",
                url:"/sql_get",
                dataType:"JSON",
                data:sql_data,
                success:function (res) {
                    data = '-- 新增成功！ --'
                    var sectorSelect = document.getElementById("result");
                    sectorSelect.innerHTML = data;
                },
                error: function (thrownError) {
                    if (thrownError.statusText == "INTERNAL SERVER ERROR") {
                        alert("內部料號 " + company_id + " 已存在, 請重新輸入")
                    }
                }

            })

            // $.get('/sql_get', sql_data, function (res) {
            //     // console.log("res: " + res)
            //     // console.log("res.labels:" + res.labels)
            //     // console.log("res.labels[0]:" + res.labels[0])
            //     // console.log("res.labels[0][0]:" + res.labels[0][0])
            //     // console.log("res.sql_field:" + res.sql_field)
            //     // console.log("res.sql_field[0]:" + res.sql_field[0])
                
            // }, 'json');
            
        }
        
    </script>


    <hr>
    <!-- 這裡新增零件表中的 會計科目 -->
    請輸入欲新增的會計科目名稱, 再按下 "新增會計科目項目" 按鈕:<br>
    <input id="create_accountingsubject_id" value="{{new_as_sn}}" style="height: 25px; width: 45px;" readonly>
    <input id="create_accountingsubject_name" value="" style="height: 25px;">
    <input type="button" id="create_accountingsubject" value="新增會計科目項目" onclick="create_accountingsubject();">
    <script>
        function create_accountingsubject() {
            var as_id = $("#create_accountingsubject_id").val();
            var as_name = $("#create_accountingsubject_name").val();
            var sql = '';
            sql += 'INSERT INTO 會計科目表 ' +
                   'VALUES ("' + as_id + '", "' + as_name + '");';
            // console.log("sql: " + sql)

            var sql_data = { "sql":sql };

            $.ajax({
                type:"GET",
                url:"/sql_get",
                dataType:"JSON",
                data:sql_data,
                success:function (res) {
                    alert('新增 會計科目 成功')
                },
                error: function (thrownError) {
                    if (thrownError.statusText == "INTERNAL SERVER ERROR") {
                        alert("會計科目 " + as_id + " 已存在, 請重新輸入")
                    }
                }

            })
        }
    </script>


    <hr>
    <!-- 這裡新增零件表中的 類別 -->
    請輸入欲新增的類別名稱, 再按下 "新增類別項目" 按鈕:<br>
    <input id="create_category_id" value="{{new_ca_sn}}" style="height: 25px; width: 45px;" readonly>
    <input id="create_category_name" value="" style="height: 25px;">
    <input type="button" id="create_category" value="新增類別項目" onclick="create_category();">
    <script>
        function create_category() {
            var ca_id = $("#create_category_id").val();
            var ca_name = $("#create_category_name").val();
            var sql = '';
            sql += 'INSERT INTO 類別表 ' +
                   'VALUES ("' + ca_id + '", "' + ca_name + '");';
            var sql_data = { "sql":sql };

            $.ajax({
                type:"GET",
                url:"/sql_get",
                dataType:"JSON",
                data:sql_data,
                success:function (res) {
                    alert('新增 類別 成功')
                },
                error: function (thrownError) {
                    if (thrownError.statusText == "INTERNAL SERVER ERROR") {
                        alert("類別 " + ca_id + " 已存在, 請重新輸入")
                    }
                }

            })
        }
    </script>


    <hr>
    <!-- 這裡新增零件表中的 供應商 -->
    請輸入欲新增的供應商名稱, 再按下 "新增供應商" 按鈕: (其他資料先以 NULL 存入)<br>
    <input id="create_supplier_id" value="{{new_su_sn}}" style="height: 25px; width: 45px;" readonly>
    <input id="create_supplier_name" value="" style="height: 25px;">
    <input type="button" id="create_supplier" value="新增供應商項目" onclick="create_supplier();">
    <script>
        function create_supplier() {
            var su_id = $("#create_supplier_id").val();
            var su_name = $("#create_supplier_name").val();
            var sql = '';
            sql += 'INSERT INTO 供應商 (`供應商`, `公司`) ' +
                   'VALUES ("' + su_id + '", "' + su_name + '");';
            console.log("sql:", sql)
            var sql_data = { "sql":sql };

            $.ajax({
                type:"GET",
                url:"/sql_get",
                dataType:"JSON",
                data:sql_data,
                success:function (res) {
                    alert('新增 供應商 成功')
                },
                error: function (thrownError) {
                    if (thrownError.statusText == "INTERNAL SERVER ERROR") {
                        alert("供應商 " + su_id + " 已存在, 請重新輸入")
                    }
                }

            })
        }
    </script>
</body>

</html>