upload.php 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248
  1. <?php
  2. include($_SERVER['DOCUMENT_ROOT'] . "/Authorization/script/php/permission/check_right.php");
  3. ?>
  4. <!doctype html>
  5. <html class="fixed">
  6. <head>
  7. <!-- Basic -->
  8. <meta charset="UTF-8">
  9. <title>首頁 | BIM資訊系統</title>
  10. <meta name="keywords" content="HTML5 Admin Template" />
  11. <meta name="description" content="JSOFT Admin - Responsive HTML5 Template">
  12. <meta name="author" content="JSOFT.net">
  13. <script src="./script/php/clearData.php"></script>
  14. <!-- Mobile Metas -->
  15. <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=no" />
  16. <!-- Web Fonts -->
  17. <link href="http://fonts.googleapis.com/css?family=Open+Sans:300,400,600,700,800|Shadows+Into+Light" rel="stylesheet" type="text/css">
  18. <!-- Vendor CSS -->
  19. <link rel="stylesheet" href="/Common/assets/vendor/bootstrap/css/bootstrap.css" />
  20. <link rel="stylesheet" href="/Common/assets/vendor/font-awesome/css/font-awesome.css" />
  21. <link rel="stylesheet" href="/Common/assets/vendor/magnific-popup/magnific-popup.css" />
  22. <link rel="stylesheet" href="/Common/assets/vendor/bootstrap-datepicker/css/datepicker3.css" />
  23. <link rel="stylesheet" href="/Common/assets/vendor/pnotify/pnotify.custom.css" />
  24. <!-- Specific Page Vendor CSS -->
  25. <link rel="stylesheet" href="/Common/assets/vendor/jquery-ui/css/ui-lightness/jquery-ui-1.10.4.custom.css" />
  26. <link rel="stylesheet" href="/Common/assets/vendor/bootstrap-multiselect/bootstrap-multiselect.css" />
  27. <link rel="stylesheet" href="/Common/assets/vendor/morris/morris.css" />
  28. <link rel="stylesheet" href="/Common/assets/vendor/bootstrap-fileupload/bootstrap-fileupload.min.css" />
  29. <!-- Theme CSS -->
  30. <link rel="stylesheet" href="/Common/assets/stylesheets/theme.css" />
  31. <!-- Skin CSS -->
  32. <link rel="stylesheet" href="/Common/assets/stylesheets/skins/default.css" />
  33. <!-- Theme Custom CSS -->
  34. <link rel="stylesheet" href="/Common/assets/stylesheets/theme-custom.css">
  35. <!-- Head Libs -->
  36. <script src="/Common/assets/vendor/modernizr/modernizr.js"></script>
  37. <!-- chart.js -->
  38. <script src="https://cdn.jsdelivr.net/npm/chart.js"></script>
  39. <!-- DataTable -->
  40. <script src="/Common/assets/vendor/jquery/jquery.js"></script>
  41. <link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.10.25/css/jquery.dataTables.css">
  42. <script type="text/javascript" charset="utf8" src="https://cdn.datatables.net/1.10.25/js/jquery.dataTables.js"></script>
  43. <!-- Icon -->
  44. <link rel="shortcut icon" href="/Common/assets/images/favicon.ico" />
  45. <!-- vue3 -->
  46. <script src="https://unpkg.com/vue@next"></script>
  47. <script src="./script/js/global.js"></script>
  48. <script src="/Common/script/js/user-image.js"></script>
  49. <script type="application/javascript">
  50. var userName = "<?php echo $_SESSION['name'] ?>";
  51. var role = "<?php echo ($groupName); ?>";
  52. var right = <?php echo ($right); ?>;
  53. var pageHeader = '監測資料上傳工具';
  54. </script>
  55. </head>
  56. <body>
  57. <section class="body">
  58. <!-- start: header -->
  59. <header-menu></header-menu>
  60. <!-- end: header -->
  61. <div class="inner-wrapper">
  62. <!-- start: sidebar -->
  63. <side-bar></side-bar>
  64. <!-- end: sidebar -->
  65. <section role="main" class="content-body">
  66. <header class="page-header">
  67. <h2>{{pageHeader}}</h2>
  68. <ul class="pull-right notifications" style="margin-top: 10px;">
  69. <li>
  70. <a href="./delete.php" class="notification-icon" data-toggle="tooltip" title="刪除頁面" data-placement="bottom">
  71. <i class="fa fa-trash-o"></i>
  72. </a>
  73. </li>
  74. </ul>
  75. </header>
  76. <div class="row">
  77. <div class="col-md-6 col-md-offset-3">
  78. <section class="panel panel-featured-left panel-featured-primary">
  79. <div class="panel-body">
  80. <div id="upload" class="tab-pane active">
  81. <form method="post" enctype="multipart/form-data" action="./script/php/read_excel.php">
  82. <div class="form-group">
  83. <label class="col-md-3 control-label" for="projectName">計畫名稱 </label>
  84. <div class="col-md-6">
  85. <select class="form-control mb-md" name="projectName" id="projectName" required="required">
  86. <option class="c3" value="c3">南港台壽C3專案管理</option>
  87. <option class="r03" value="r03">信義線東延段</option>
  88. </select>
  89. </div>
  90. </div>
  91. <div class="form-group">
  92. <label class="col-md-3 control-label" for="constructionName">工地模型 </label>
  93. <div class="col-md-6">
  94. <select class="form-control mb-md" name="constructionName" id="constructionName" required="required">
  95. <option class="c3" value="c3">C3</option>
  96. <option class="r03" value="r03" style="display: none;">R03</option>
  97. </select>
  98. </div>
  99. </div>
  100. <div class="form-group" style="border-bottom: 0px;">
  101. <label class="col-md-3 control-label" for="excel">Excel文件</label>
  102. <div class="col-md-6">
  103. <div class="fileupload fileupload-new" data-provides="fileupload">
  104. <div class="input-append">
  105. <div class="uneditable-input">
  106. <i class="fa fa-file fileupload-exists"></i>
  107. <span class="fileupload-preview"></span>
  108. </div>
  109. <span class="btn btn-default btn-file">
  110. <span class="fileupload-exists">更換檔案</span>
  111. <span class="fileupload-new">選擇檔案</span>
  112. <input type="file" name="excel" id="excel" required="required" accept=".csv, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet, application/vnd.ms-excel">
  113. </span>
  114. <a href="#" class="btn btn-default fileupload-exists" data-dismiss="fileupload">移除檔案</a>
  115. <span class="help-block"></span>
  116. </div>
  117. </div>
  118. </div>
  119. </div>
  120. <footer class="panel-footer">
  121. <button id="submit" class="btn btn-primary">上傳檔案</button>
  122. <button id="reset" type="reset" class="btn btn-default">清除表單</button>
  123. </footer>
  124. </form>
  125. </div>
  126. </div>
  127. </section>
  128. </div>
  129. </div>
  130. </div>
  131. </section>
  132. <!-- Main-->
  133. <script src="script/js/home.js"></script>
  134. <script>
  135. var sites;
  136. vm.mount('.body');
  137. addUserImage(userName.charAt(0), role);
  138. GetCheckAllAJAXValue()
  139. $(document).ready(function() {
  140. var url_href = window.location.href;
  141. var url = new URL(url_href);
  142. var status = url.searchParams.get("status");
  143. if (status == 'success') {
  144. alert("匯入成功!");
  145. window.location.href = "./Upload.php"
  146. } else if (status == 'failed') {
  147. alert("匯入失敗!");
  148. window.location.href = "./Upload.php"
  149. }
  150. getSites();
  151. $("#projectName").on("change", function() {
  152. let id = $(this).val();
  153. $("#constructionName").empty();
  154. for (i = 0; i < sites[id]["ModelID"].length; i++) {
  155. $("#constructionName").append(`<option value="2">${sites[id]["ModelID"][i]}</option>`);
  156. }
  157. })
  158. });
  159. function getSites() {
  160. $.ajax({
  161. url: '/BIM-Monitor/script/php/get_sites.php',
  162. type: "GET",
  163. dataType: "JSON"
  164. }).success(function(result) {
  165. sites = result;
  166. let defaultID;
  167. let isDefault = true;
  168. $("#projectName").empty();
  169. $("#constructionName").empty();
  170. Object.keys(sites).forEach(element => {
  171. $("#projectName").append(`<option value="${element}">${sites[element]["SiteName"]}</option>`);
  172. if (isDefault) {
  173. defaultID = element;
  174. isDefault = false;
  175. }
  176. });
  177. for (i = 0; i < sites[defaultID]["ModelID"].length; i++) {
  178. $("#constructionName").append(`<option value="2">${sites[defaultID]["ModelID"][i]}</option>`);
  179. }
  180. }).error(function(error) {
  181. console.log(error);
  182. }).complete(function(e) {
  183. });
  184. }
  185. </script>
  186. <!-- Vendor -->
  187. <script src="/Common/assets/vendor/jquery-browser-mobile/jquery.browser.mobile.js"></script>
  188. <script src="/Common/assets/vendor/bootstrap/js/bootstrap.js"></script>
  189. <script src="/Common/assets/vendor/nanoscroller/nanoscroller.js"></script>
  190. <script src="/Common/assets/vendor/bootstrap-datepicker/js/bootstrap-datepicker.js"></script>
  191. <script src="/Common/assets/vendor/magnific-popup/magnific-popup.js"></script>
  192. <script src="/Common/assets/vendor/jquery-placeholder/jquery.placeholder.js"></script>
  193. <!-- Specific Page Vendor -->
  194. <script src="/Common/assets/vendor/jquery-ui/js/jquery-ui-1.10.4.custom.js"></script>
  195. <script src="/Common/assets/vendor/jquery-ui-touch-punch/jquery.ui.touch-punch.js"></script>
  196. <script src="/Common/assets/vendor/jquery-appear/jquery.appear.js"></script>
  197. <script src="/Common/assets/vendor/bootstrap-multiselect/bootstrap-multiselect.js"></script>
  198. <script src="/Common/assets/vendor/jquery-easypiechart/jquery.easypiechart.js"></script>
  199. <script src="/Common/assets/vendor/flot/jquery.flot.js"></script>
  200. <script src="/Common/assets/vendor/flot-tooltip/jquery.flot.tooltip.js"></script>
  201. <script src="/Common/assets/vendor/flot/jquery.flot.pie.js"></script>
  202. <script src="/Common/assets/vendor/flot/jquery.flot.categories.js"></script>
  203. <script src="/Common/assets/vendor/flot/jquery.flot.resize.js"></script>
  204. <script src="/Common/assets/vendor/jquery-sparkline/jquery.sparkline.js"></script>
  205. <script src="/Common/assets/vendor/raphael/raphael.js"></script>
  206. <script src="/Common/assets/vendor/morris/morris.js"></script>
  207. <script src="/Common/assets/vendor/gauge/gauge.js"></script>
  208. <script src="/Common/assets/vendor/snap-svg/snap.svg.js"></script>
  209. <script src="/Common/assets/vendor/liquid-meter/liquid.meter.js"></script>
  210. <script src="/Common/assets/vendor/jqvmap/jquery.vmap.js"></script>
  211. <script src="/Common/assets/vendor/jqvmap/data/jquery.vmap.sampledata.js"></script>
  212. <script src="/Common/assets/vendor/bootstrap-fileupload/bootstrap-fileupload.min.js"></script>
  213. <script src="/Common/assets/vendor/jquery-autosize/jquery.autosize.js"></script>
  214. <script src="/Common/assets/vendor/pnotify/pnotify.custom.js"></script>
  215. <!-- Theme Base, Components and Settings -->
  216. <script src="assets/javascripts/theme.js"></script>
  217. <!-- Theme Custom -->
  218. <script src="assets/javascripts/theme.custom.js"></script>
  219. <!-- Theme Initialization Files -->
  220. <script src="assets/javascripts/theme.init.js"></script>
  221. <!-- Examples -->
  222. <script src="assets/javascripts/ui-elements/examples.modals.js"></script>
  223. <script src="script/js/notifications.js"></script>
  224. <!-- <script src='script/js/warning.js'></script> -->
  225. </section>
  226. </body>
  227. </html>