rita
/
ERP


			
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555
							<!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">
    
</head>
<script>

    var PR_Form_number = '{{PR_Form_number}}';

    var table_row_num = 0;


</script>

<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>
    <center><h6 style="margin: 20px;">建立請購單</h6></center>
    <table class="table table-bordered" id="PR_table" style="margin-top: 10px;">
        <tr>
            <td colspan="5">
                日期 :
                <span id="PR_datetime">(系統代入)</span>
            </td>
        </tr>
        <tr>
            <td colspan="5">
                請購單號 :
                <span id="PR_document_companyid">{{PR_Form_number}}</span>
            </td>
        </tr>
        <!-- 請購單標題 -->
        <tr>
            <th>內部料號</th>
            <th>數量</th>
            <th>單位</th>
            <th>連結</th>
            <!-- <th>單價</th>

            <th>關稅</th>

            <th>運費</th>

            <th>總金額</th>

            <th>付款狀況</th> -->
            <th>備註</th>
        </tr>
        <!-- </div> -->
        <!-- 請購單內容：新增資料 -->
        <tr>
            <td>
                <!-- 內部料號 -->
                <input list="insert_PR_id_item" id="PR_id_0" style="height: 25px;" onChange="">
                <datalist id="insert_PR_id_item">
                    {% for data in Component_id_name_salesnum %}
                        {% if data[2] == '' or data[2] == None %}
                            <option value="{{data[0]}}">{{data[1]}}, (無原廠料號)</option>
                        {% else %}
                            <option value="{{data[0]}}">{{data[1]}}, {{data[2]}}</option>
                        {% endif %}
                    {% endfor %}
                </datalist>
            </td>
            <td>
                <!-- 數量 -->
                <input type="text" id="PR_amount_0" value="1" style="height: 25px; width: 50px">
            </td>
            <td>
                <!-- 單位 -->
                <input type="text" id="PR_unit_0" value="件" style="height: 25px; width: 50px">
            </td>
            <td>
                <input type="text" id="PR_hyperlink_0" value="www" style="height: 25px; width: 200px">
            </td>
            <!-- <td> -->
                <!-- 單價 -->
                <!-- <input type="text" id="PR_unitprice_0" value="11" style="height: 25px; width: 70px">

            </td>

            <td> -->
                <!-- 關稅 -->
                <!-- <input type="text" id="PR_tariff_0" value="12" style="height: 25px; width: 70px">

            </td>

            <td> -->
                <!-- 運費 -->
                <!-- <input type="text" id="PR_shippingfee_0" value="13" style="height: 25px; width: 70px">

            </td>

            <td> -->
                <!-- 總金額 -->
                <!-- <input type="text" id="PR_totalprice_0" value="135" style="height: 25px; width: 90px">

            </td>

            <td> -->
                <!-- 付款狀況 -->
                <!-- <input id="PR_payment" value="代墊" style="height: 25px; width: 70px"> -->
                <!-- <select id="PR_payment_0">

                    <option value="未付款">未付款</option>

                    <option value="已付款">已付款</option>

                </select>

            </td> -->
            <td>
                <!-- 備註 -->
                <input type="text" id="PR_remark_0" value="備註" style="height: 25px; width: 90px; margin-right: 20px;">
                <input type="button" value="新增下一筆" onclick="table_add_rows()">
            </td>
        </tr>
        <script>

            // // 修改請購單內項目

            // function update_PR_item(id) {

            //     console.log("修改: " + id)

            //     var PR_title_list = ['id', 'amount', 'unit', 'supplier', 'unitprice', 'tariff', 'shippingfee', 'totalprice', 'payment']

            //     for (let i = 1; i < 9; i++) {

            //         var target_id = document.getElementById(id + '_' + PR_title_list[i]);

            //         var old_name = target_id.innerText;

            //         console.log('old_name: ', old_name)

            //         target_id.innerHTML = "";

            //         textarea = '<input id="'+ id + '_' + PR_title_list[i] + '_ta' + '" value="' + old_name + '" style="height: 25px; width: 60px">';

            //         if (i == 8) {

            //             textarea += '<input type="button" value="OK" onclick="update_comfirm_PR_item(\'' + id + '\')">';

            //         }

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

            //     }

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

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

            // }


            // // 修改請購單內項目 確認

            // function update_comfirm_PR_item(id) {

            //     console.log("修改: " + id)

            //     var new_amount_value = $('#' + id + '_amount_ta').val();

            //     var new_unit_value = $('#' + id + '_unit_ta').val();

            //     // var new_supplier_value = $('#' + id + '_supplier_ta').val();

            //     var new_unitprice_value = $('#' + id + '_unitprice_ta').val();

            //     var new_tariff_value = $('#' + id + '_tariff_ta').val();

            //     var new_shippingfee_value = $('#' + id + '_shippingfee_ta').val();

            //     var new_totalprice_value = $('#' + id + '_totalprice_ta').val();

            //     var new_payment_value = $('#' + id + '_payment_ta').val();


            //     sql = 'UPDATE ' + PR_Form_number + ' SET `數量` = "' + new_amount_value + '"' +

            //       ', `單位` = "' + new_unit_value + '"' +

            //     //   ', `供應商` = "' + new_supplier_value + '"' +

            //     //   ', `專案` = "' + new_reason_value + '"' +

            //     //   ', `用途` = "' + new_person_value + '"' +

            //       ', `單價` = "' + new_unitprice_value + '"' +

            //       ', `關稅` = "' + new_tariff_value + '"' +

            //       ', `運費` = "' + new_shippingfee_value + '"' +

            //       ', `總金額` = "' + new_totalprice_value + '"' +

            //       ', `付款狀況` = "' + new_payment_value + '"' +

            //     //   ', `備註` = "' + new_person_value + '"' +

            //     //   ', `請購人` = "' + new_person_value + '"' +

            //       ' WHERE `內部料號` = "' + 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("請購單 " + PR_Form_number + ":" + id + " 項目修改成功 !")

            //             location.reload()

            //         },

            //         error: function (thrownError) {

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

            //                 alert("請購單 " + PR_document_companyid + ":" + PR_id + " 項目未修改")

            //             } else {

            //                 alert("修改請購單項目內容 thrownError" + thrownError)

            //             }

            //         }

            //     })

            // }


            // // 刪除請購單內項目

            // function delete_PR_item(id) {

            //     console.log("刪除: " + id)

            //     var comfirm_delete_PR_item = confirm("確定要刪除 " + id + " 零件嗎？")

            //     if (comfirm_delete_PR_item) {

            //         sql = 'DELETE FROM ' + PR_Form_number + ' WHERE 內部料號 = "' + id + '";'

            //         sql_data = { "sql":sql };

            //         console.log("delete_PR_item[sql]:" + sql)


            //         $.ajax({

            //             type:"GET",

            //             url:"/sql_get",

            //             dataType:"JSON",

            //             data:sql_data,

            //             success:function (res) {

            //                 alert("請購單 " + PR_Form_number + ":" + id + " 刪除成功 !")

            //                 location.reload()

            //             },

            //             error: function (thrownError) {

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

            //                     alert("請購單 " + PR_document_companyid + ":" + PR_id + " 未刪除")

            //                 } else {

            //                     alert("刪除請購單內容 thrownError" + thrownError)

            //                 }

            //             }

            //         })

            //     }

            // }

            
            // 

            function PR_change() {

                // get_Value();

                var PR_document_companyid_select = $("#PR_document_companyid_select").val()

                console.log("PR_document_companyid_select: " + PR_document_companyid_select)

                var sql = 'SELECT 內部料號 FROM `' + PR_document_companyid_select + '`' ;

                var sql_data = { "sql":sql };


                $.ajax({

                    type:"GET",

                    url:"/sql_get",

                    dataType:"JSON",

                    data:sql_data,

                    success:function (res) {

                        if (res.labels.length != 0) {

                            for (let items = 0; items < res.labels.length; items++) {

                                var 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]))

                                    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_standard(\'' + res.labels[items][0] + '\')"></td>';

                                data += '</tr>';

                            };

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

                            sectorSelect.innerHTML = data;

                        }

                    },

                    error: function (thrownError) {

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

                            alert("請購單 " + PR_document_companyid + ":" + PR_id + " 未新增")

                        } else {

                            alert("新增請購單內容 thrownError" + thrownError)

                        }

                    }

                })

                
            }

        </script>
        <tr>
            <td>
                請購 :
                <!-- <span id="PR_requisition_person"></span> -->
                <!-- <input list="insert_PR_person" id="PR_person" style="height: 25px;" onChange="">

                <datalist id="insert_PR_person">

                </datalist> -->
                <select id="PR_person">
                    <option value=""></option>
                    <option value="Andrey">Andrey</option>
                    <option value="Amy">Amy</option>
                    <option value="Allen">Allen</option>
                    <option value="Gina">Gina</option>
                    <option value="FatWolf">FatWolf</option>
                    <option value="Rita">Rita</option>
                </select>
            </td>
            <td>
                倉管 :
                <span id="PR_warehouse_person"></span>
            </td>
            <td>
                管理 :
                <span id="PR_management_person"></span>
            </td>
        </tr>
    </table>
    <br>
    <input type="button" value="取值測試" onclick="get_Value();">
    <input type="button" class="input-cond-add" value="儲存" onclick="create_PR_table(PR_Form_number);">
    <div id="result"></div>

    <br>

    <script>

        var sql = '';

        var sql_data = { "sql":sql };

        // 建立請購單 Table + 建立項目

        function create_PR_table(PR_conpany_id) {

            console.log("create_PR_table PR_conpany_id: " + PR_conpany_id)

            
            PR_insert_items = [];

            // 取值組合成 SQL 語法

            // 亦當作未輸入之空格


            for (let row = 0; row <= table_row_num; row++) {

                data = '(';

                for (let item = 0; item < PR_title_list.length; item++) {


                    var PR_value = document.getElementById("PR_" + PR_title_list[item] + "_" + row).value;

                    console.log("PR_" + PR_title_list[item] + "_" + row + ": " + PR_value)

                    // (內部料號, 數量, 單位, 單價, 關稅, 運費, 總金額, 付款狀況, 備註, 

                    data += '"' + PR_value + '", ';

                }

                // 請購人)

                var PR_person_value = document.getElementById("PR_person").value;

                console.log("PR_person: " + PR_person_value)

                data += '"' + PR_person_value + '")';

                PR_insert_items.push(data);

            }

            console.log("PR_insert_items: " + PR_insert_items)


            // 建立請購單 Table

            sql = 'CREATE TABLE `' + PR_conpany_id + '` (' +

                      '`內部料號` varchar(11) NOT NULL, ' +

                      '`建立日期` TIMESTAMP NOT NULL DEFAULT current_timestamp(), ' +

                      '`數量` varchar(4) NOT NULL, ' +

                      '`單位` varchar(10) NULL, ' +

                      '`連結` varchar(500) NULL, ' +

                    //   '`單價` varchar(10) NULL, ' +

                    //   '`關稅` varchar(10) NULL, ' +

                    //   '`運費` varchar(10) NULL, ' +

                    //   '`總金額` varchar(10) NULL, ' +

                    //   '`付款狀況` varchar(10) NULL, ' +

                      '`備註` varchar(100) NULL, ' +

                      '`請購人` varchar(10) NULL, ' +

                      'PRIMARY KEY (內部料號)' +

                      ');';

            console.log("sql: " + sql)

            sql_data = { "sql":sql }

            $.ajax({

                type:"GET",

                url:"/sql_get",

                dataType:"JSON",

                data:sql_data,

                async:false,

                success:function (res) {

                    alert("請購單 " + PR_conpany_id + ": 建立成功!")

                },

                error: function (thrownError) {

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

                        alert("請購單 " + PR_conpany_id + " 未成功")

                    } else {

                        alert("請購單建立錯誤: " + thrownError)

                    }

                }

            })


            // 建立請購單項目

            // sql = 'INSERT INTO `' + PR_conpany_id + '` (內部料號, 數量, 單位, 單價, 關稅, 運費, 總金額, 付款狀況, 備註, 請購人) ' + 

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

            sql = 'INSERT INTO `' + PR_conpany_id + '` (內部料號, 數量, 單位, 連結, 備註, 請購人) ' + 

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

            console.log("sql: " + sql)

            sql_data = { "sql":sql }

            $.ajax({

                type:"GET",

                url:"/sql_get",

                dataType:"JSON",

                data:sql_data,

                async:false,

                success:function (res) {

                    alert("請購單 " + PR_conpany_id + ": 項目建立成功!")

                    window.location.assign("/PR_user_" + PR_conpany_id)

                },

                error: function (thrownError) {

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

                        alert("請購單 " + PR_conpany_id + " 項目建立未成功")

                    } else {

                        alert("請購單項目建立錯誤: " + thrownError)

                    }

                }

            })

        }


        // var PR_title_list = ['id', 'amount', 'unit', 'unitprice', 'tariff', 'shippingfee', 'totalprice', 'payment', 'remark']

        var PR_title_list = ['id', 'amount', 'unit', 'hyperlink', 'remark']

        var data = '';


        // 取得欄位值

        function get_Value() {

            console.log("get_Value")

            var PR_insert_items = [];

            for (let row = 0; row <= table_row_num; row++) {

                data = '(';

                for (let item = 0; item < PR_title_list.length; item++) {

                    var PR_value = document.getElementById("PR_" + PR_title_list[item] + "_" + row).value;

                    console.log("PR_" + PR_title_list[item] + "_" + row + ": " + PR_value)

                    // (內部料號, 數量, 單位, 單價, 關稅, 運費, 總金額, 付款狀況, 備註, 請購人)

                    data += '"' + PR_value + '", ';

                }

                var PR_person_value = document.getElementById("PR_person").value;

                console.log("PR_person: " + PR_person_value)

                data += '"' + PR_person_value + '")';


                PR_insert_items.push(data);

            }

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

            selector.innerHTML = PR_insert_items.join(', ');

        }


        function table_add_rows() {

            table_row_num++;

            var table_name = document.getElementById("PR_table");

            var table_add_row = table_name.insertRow(table_name.rows.length-1);

            // var table_add_row = table_name.insertRow(table_name.rows.length);  // 最後一行


            // var PR_title_add_list = ['id', 'amount', 'unit', 'unitprice', 'tariff', 'shippingfee', 'totalprice', 'payment', 'remark']

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

                var cell = table_add_row.insertCell();

                if (i == 0) {

                    // 內部料號

                    data = '<input list="insert_PR_id_item" id="PR_id_' + table_row_num + '" style="height: 25px;" onChange="">' +

                           '<datalist id="insert_PR_id_item">' +

                            '{% for data in Component_id_name_salesnum %}' +

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

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

                            '{% else %}' +

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

                            '{% endif %}' +

                            '{% endfor %}' +

                            '</datalist>' ;

                    cell.innerHTML = data;

                // } else if (i == 1 || i == 2 || i == 5) {

                //     // 名稱 型號/規格 供應商

                //     // data = '—' ;

                //     // cell.innerHTML = data;

                } else if (i == 1) {

                    // 數量

                    data = '<input type="text" id="PR_' + PR_title_list[i] + '_' + table_row_num + '" value="" style="height: 25px; width: 50px">' ;

                    cell.innerHTML = data;

                } else if (i == 2) {

                    // 單位

                    data = '<input type="text" id="PR_' + PR_title_list[i] + '_' + table_row_num + '" value="" style="height: 25px; width: 50px">' ;

                    cell.innerHTML = data;

                // } else if (i == 3) {

                //     // 單價

                //     data = '<input type="text" id="PR_' + PR_title_list[i] + '_' + table_row_num + '" value="" style="height: 25px; width: 70px">' ;

                //     cell.innerHTML = data;

                // } else if (i == 4) {

                //     // 關稅

                //     data = '<input type="text" id="PR_' + PR_title_list[i] + '_' + table_row_num + '" value="" style="height: 25px; width: 70px">' ;

                //     cell.innerHTML = data;

                // } else if (i == 5) {

                //     // 運費

                //     data = '<input type="text" id="PR_' + PR_title_list[i] + '_' + table_row_num + '" value="" style="height: 25px; width: 70px">' ;

                //     cell.innerHTML = data;

                // } else if (i == 6) {

                //     // 總金額

                //     data = '<input type="text" id="PR_' + PR_title_list[i] + '_' + table_row_num + '" value="" style="height: 25px; width: 90px">' ;

                //     cell.innerHTML = data;

                // } else if (i == 7) {

                //     // 付款狀況

                //     data = '<select id="PR_' + PR_title_list[i] + '_' + table_row_num + '">' +

                //             '<option value="未付款">未付款</option>' +

                //             '<option value="已付款">已付款</option>' +

                //             '</select>';

                //     cell.innerHTML = data;

                } else if (i == 3) {

                    // 連結

                    data = '<input type="text" id="PR_' + PR_title_list[i] + '_' + table_row_num + '" value="" style="height: 25px; width: 200px;">';

                    cell.innerHTML = data;

                } else if (i == 4) {

                    // 備註

                    data = '<input type="text" id="PR_' + PR_title_list[i] + '_' + table_row_num + '" value="" style="height: 25px; width: 90px;">';

                    cell.innerHTML = data;

                } else {

                    cell.innerHTML = i;

                }

            }

        }


        function insert_PR_item() {

            var PR_document_companyid = $("#PR_document_companyid").text()

            var PR_document_companyid_select = $("#PR_document_companyid_select").val()

            var PR_id = $("#PR_id").val()

            var PR_amount = $("#PR_amount").val()

            var PR_unit = $("#PR_unit").val()

            var PR_supplier = $("#PR_supplier").val()

            var PR_unitprice = $("#PR_unitprice").val()

            var PR_tariff = $("#PR_tariff").val()

            var PR_shippingfee = $("#PR_shippingfee").val()

            var PR_totalprice = $("#PR_totalprice").val()

            var PR_payment = $("#PR_payment").val()

            var PR_remark_project= $("#PR_remark_project").val()

            var PR_requisition_person = $("#PR_requisition_person").text()

            console.log("PR_document_companyid: " + PR_document_companyid)

            console.log("PR_document_companyid_select: " + PR_document_companyid_select)

            console.log("PR_id: " + PR_id)

            console.log("PR_amount: " + PR_amount)

            console.log("PR_unit: " + PR_unit)

            console.log("PR_supplier: " + PR_supplier)

            console.log("PR_unitprice: " + PR_unitprice)

            console.log("PR_tariff: " + PR_tariff)

            console.log("PR_shippingfee: " + PR_shippingfee)

            console.log("PR_totalprice: " + PR_totalprice)

            console.log("PR_payment: " + PR_payment)

            console.log("PR_remark_project: " + PR_remark_project)

            console.log("PR_requisition_person: " + PR_requisition_person)


            // TODO !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

            var sql = 'INSERT INTO `' + PR_Form_number + '`' + 

                      ' VALUES ("' + PR_id + '", current_timestamp(), "' + PR_amount + '", "' + PR_unit + '", "' +

                      PR_supplier + '", "' + 

                      PR_unitprice + '", "' + PR_tariff + '", "' + PR_shippingfee + '", "' + 

                      PR_totalprice + '", "' + PR_payment + '", "' + PR_remark_project + '", "' + PR_requisition_person + '");';

            var sql_data = { "sql":sql };

            console.log("insert_PR_item[sql]:" + sql)


            $.ajax({

                type:"GET",

                url:"/sql_get",

                dataType:"JSON",

                data:sql_data,

                success:function (res) {

                    alert("請購單 " + PR_document_companyid + ":" + PR_id + " 新增成功 !")

                    location.reload()

                },

                error: function (thrownError) {

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

                        alert("請購單 " + PR_document_companyid + ":" + PR_id + " 未新增")

                    } else {

                        alert("新增請購單內容 thrownError" + thrownError)

                    }

                }

            })


        }

    </script>
</body>

</html>