steve07s
/
DataBase


			
				
					
						
						
							1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283
							<!DOCTYPE html>
<html>

<head>
    <title>設計群匯入工具</title>
    <meta charset="utf-8">
    <link rel="shortcut icon" href="/Database/assets/images/favicon.ico" />
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <link rel="stylesheet" href="form.css" />
    <link href='https://fonts.googleapis.com/css?family=Lato:100,200,300,400,500,600,700' rel='stylesheet'
        type='text/css'>
    <script src="/DataBase/assets/vendor/jquery/jquery.js"></script>
</head>
<form method="post" enctype="multipart/form-data" action="./index.php">

    <h1><strong>MAA</strong> 設計群匯入工具</h1>

    <div class="form-group">
        <label for="projectId">計畫編號 </label>
        <input type="text" name="projectId" id="projectId" class="form-controll" required="required" />
    </div>
    <div class="form-group">
        <label for="category">工程類別</label>
        <select name="category" id="category" class="form-controll" required="required">
        </select>
    </div>

    <div class="form-group file-area">
        <label for="excel">Excel文件</label>
        <input type="file" name="excel" id="excel" required="required"
            accept=".csv, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet, application/vnd.ms-excel">
        <div class="file-dummy">
            <div class="success">你已經選擇<span id="filename"></span>。 請繼續下一步。</div>
            <div class="default">選擇Excel文件</div>
        </div>
    </div>

    <div class="form-group">
        <p><strong>注意事項:</strong>Excel檔名請用計畫編號命名。 (例:15032.xlsx)</p>
        <button type="submit">上傳檔案</button>
    </div>

</form>
<a href="../../../index.php" class="back-to-article" target="_blank">返回至查詢工具</a>

<script type="text/javascript">
    $(document).ready(function () {
        getCategory();
    });
    var inputElement = document.getElementById("excel");
    inputElement.addEventListener("change", handleFiles, false);

    function handleFiles() {
        var fileList = this.files;
        $("#filename").text(fileList[0].name);
        console.log(fileList[0].name);
    }

    function getCategory() {
        
        $.ajax({
                url: "./getConstructionCategory.php",               
                async: false,
                contentType: "application/json",
                dataType: "json",
                type: "GET",
            })
            .success(function (response) {     
                for (i=0;i<response.length;i++) {
                    console.log(category);     
                    $('#category').append(`<option value='${response[i][0]}'>${response[i][1]}</option>`);
                }
            })
            .error(function (error) {
                console.log(error);
            })
            .complete(function () {
                $('#page0').addClass('in active')
            });
    }
</script>

</html>