list1.html 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235
  1. <!DOCTYPE html>
  2. <html xmlns="http://www.w3.org/1999/xhtml" ng-app="app">
  3. <head>
  4. <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  5. <meta name="viewport" content="width=device-width,initial-scale=1,minimum-scale=1,maximum-scale=1,user-scalable=no" />
  6. <title>工资1</title>
  7. <link href="../../AFrontEnd/css/animate.css" rel="stylesheet" />
  8. <link href="../../AFrontEnd/css/fontawesome/css/font-awesome.css" rel="stylesheet" />
  9. <link href="../../AFrontEnd/css/bootstrap.css" rel="stylesheet" />
  10. <link href="../../AFrontEnd/css/style.css" rel="stylesheet" />
  11. <script>document.write("<link href='../../AFrontEnd/css/special.css?time=" + new Date().getTime() + "' rel='stylesheet'>");</script>
  12. <link href="js/mintui.css" rel="stylesheet" />
  13. <link href="js/table.css" rel="stylesheet" />
  14. <style>
  15. .table-body-left::-webkit-scrollbar {
  16. width: 0;
  17. height: 0;
  18. }
  19. .Btn {
  20. float: left;
  21. min-width: 80px;
  22. height: 34px;
  23. overflow: hidden;
  24. white-space: nowrap;
  25. text-overflow: ellipsis;
  26. line-height: 18px;
  27. padding: 7px 0;
  28. margin: 0 10px;
  29. text-align: center;
  30. border: 1px solid blue;
  31. }
  32. .activeBtn {
  33. color:white;
  34. background:blue;
  35. }
  36. .activeBtn:hover {
  37. color: white;
  38. }
  39. </style>
  40. </head>
  41. <body>
  42. <div ng-controller="listCtrl as ctl" ng-cloak>
  43. <div class="loading" ng-if="ctl.loading">
  44. <div class="loading-msg">
  45. <h3>数据加载中,请等待</h3>
  46. <div class="spinner">
  47. <div class="bounce1"></div>
  48. <div class="bounce2"></div>
  49. <div class="bounce3"></div>
  50. </div>
  51. </div>
  52. </div>
  53. <div class="wrapper wrapper-content">
  54. <div class="row">
  55. <div class="col-md-12">
  56. <div class="ibox float-e-margins">
  57. <div class="ibox-content">
  58. <div class="row">
  59. <div class="sp-page">
  60. <a class="Btn activeBtn">工资1</a>
  61. <a class="Btn" href="list2.html">工资2</a>
  62. </div>
  63. <div class="col-md-12">
  64. <div class="sp-page-tab sp-pl-30">
  65. <span ng-class="{'pageTabActive':ctl.tablename=='SX_TFNZZGZB'}">在职</span>
  66. <a class="sp-pull-right sp-btn-gray sp-btn-radius" ng-click="ctl.getData()">
  67. <i class="fa fa-search sp-mr-5"></i>查 询
  68. </a>
  69. <a class="sp-pull-right sp-btn-gray sp-btn-radius" ng-click="ctl.btnDelete()">
  70. <i class="fa fa-trash sp-mr-5"></i>删 除
  71. </a>
  72. <a class="sp-pull-right sp-btn-gray sp-btn-radius" ng-click="ctl.printIn()">
  73. <i class="fa fa-sign-in sp-mr-5"></i>导 入
  74. </a>
  75. <a class="sp-pull-right sp-btn-gray sp-btn-radius" onclick="$(' #xlfile').trigger('click');">
  76. <i class="fa fa-book sp-mr-5"></i>浏 览
  77. </a>
  78. <a class="sp-pull-right sp-ml-5 sp-mr-5 sp-color-blue" style="line-height: 32px" download="导入模板-统发内在职.xlsx" href="moban1.xlsx"> 模板下载</a>
  79. <div class="sp-page-col sp-pull-right sp-ml-5" style="width:200px;height:32px;overflow:hidden">
  80. <input type="text" class="sp-input" readonly ng-model="ctl.uploadFile" placeholder="未选择任何文件" />
  81. <input type="file" name="xlfile" id="xlfile" />
  82. <input type="checkbox" style="display:none" name="useworker" checked>
  83. <input type="checkbox" style="display:none" name="userabs" checked>
  84. <p id="out" style="display:none;"></p>
  85. </div>
  86. <input type="text" class="sp-input sp-pull-right laydate-logo" style="width:200px" sp-laydate laytype="month" ng-model="ctl.date" ng-change="ctl.changeDate()" />
  87. </div>
  88. </div>
  89. <div class="sp-page table-head-left" style="width: 501px; overflow: hidden; position: relative; z-index: 1; ">
  90. <table class="sp-table">
  91. <thead>
  92. <tr>
  93. <th><div style="width:35px"><input type="checkbox" ng-model="ctl.checkedAll" ng-click="ctl.checkAll()" /></div></th>
  94. <th><div style="width:36px">序号</div></th>
  95. <th ng-repeat="item in ctl.thead_left"><div style="width: 88px" ng-bind="item.cname"></div></th>
  96. </tr>
  97. </thead>
  98. </table>
  99. </div>
  100. <div class="sp-page table-head-right" style="width: calc(100% - 516px); height: 34px; overflow: hidden; position: relative; z-index: 1; ">
  101. <table class="sp-table">
  102. <thead>
  103. <tr>
  104. <th ng-repeat="item in ctl.thead_right"><div style="min-width: 188px;height:22px" ng-bind="item.cname"></div></th>
  105. </tr>
  106. </thead>
  107. <tbody>
  108. <tr ng-repeat="item in ctl.list">
  109. <td ng-repeat="item1 in ctl.thead">
  110. <div>
  111. <div style="overflow:hidden;white-space:nowrap;text-overflow:ellipsis" ng-repeat="item2 in item[item1.PKID]" title="{{item2}}" ng-bind="item2"></div>
  112. </div>
  113. </td>
  114. </tr>
  115. </tbody>
  116. </table>
  117. </div>
  118. <div class="sp-page table-body-left sp-pb-5" style="width: 501px; margin-top: -34px; overflow: auto; " onscroll="scrollTableL()">
  119. <table class="sp-table">
  120. <thead>
  121. <tr>
  122. <th><div style="width:35px"></div></th>
  123. <th><div style="width:36px">序号</div></th>
  124. <th ng-repeat="item in ctl.thead_left"><div style="min-width: 88px" ng-bind="item.cname"></div></th>
  125. </tr>
  126. </thead>
  127. <tbody>
  128. <tr ng-repeat="item in ctl.list">
  129. <td><div style="width:29px"><input type="checkbox" ng-model="item.checked" ng-click="ctl.checkItem(item)" /></div></td>
  130. <td><div style="width:30px" ng-bind="$index+1"></div></td>
  131. <td ng-repeat="item1 in ctl.thead_left"><div style="width: 82px; height: 22px; overflow: hidden; white-space: nowrap; text-overflow: ellipsis" title="{{item[item1.code]}}" ng-bind="item[item1.code]"></div></td>
  132. </tr>
  133. </tbody>
  134. </table>
  135. </div>
  136. <div class="sp-page table-body-right sp-pb-5" style="width: calc(100% - 501px); margin-top: -34px; overflow: auto; " onscroll="scrollTableR()">
  137. <table class="sp-table">
  138. <thead>
  139. <tr>
  140. <th ng-repeat="item in ctl.thead_right"><div style="min-width: 188px" ng-bind="item.cname"></div></th>
  141. </tr>
  142. </thead>
  143. <tbody>
  144. <tr ng-repeat="item in ctl.list">
  145. <td ng-repeat="item1 in ctl.thead_right"><div style="height: 22px;" title="{{item[item1.code]}}" ng-bind="item[item1.code]"></div></td>
  146. </tr>
  147. </tbody>
  148. </table>
  149. </div>
  150. <div class="sp-table-tip ng-hide sp-pull-left" ng-show="ctl.noDataTip == 0">
  151. <i class="fa fa-exclamation-circle sp-mr-10"></i>您好,暂未查询到相关信息!
  152. </div>
  153. <!--<div class="sp-page sp-mt-10">
  154. <div style="position: relative; overflow: auto;">
  155. <table class="sp-table" id="printOut">
  156. <thead>
  157. <tr>
  158. <th width="50">序号</th>
  159. <th style="min-width:100px" ng-repeat="item in ctl.thead" ng-bind="item.cname"></th>
  160. </tr>
  161. </thead>
  162. <tbody>
  163. <tr ng-repeat="item in ctl.list">
  164. <td ng-bind="$index+1"></td>
  165. <td ng-repeat="item1 in ctl.thead"><span title="{{item[item1.code]}}" ng-bind="item[item1.code]"></span></td>
  166. </tr>
  167. </tbody>
  168. </table>
  169. </div>
  170. <div class="sp-table-tip ng-hide" ng-show="ctl.noDataTip == 0">
  171. <i class="fa fa-exclamation-circle sp-mr-10"></i>您好,暂未查询到相关信息!
  172. </div>
  173. </div>-->
  174. </div>
  175. </div>
  176. </div>
  177. </div>
  178. </div>
  179. </div>
  180. <div class="sp-layer" id="importDivPart" style="width:1000px">
  181. <div class="sp-center-900">
  182. <div class="sp-page sp-mt-5">
  183. <div class="sp-lh-32 sp-page-col sp-span2">表名:</div>
  184. <div class="sp-lh-32 sp-page-col sp-span3" ng-bind="ctl.tablename"></div>
  185. </div>
  186. <div class="sp-page" id="table_excelHead" style="overflow-y: auto; max-height: 500px">
  187. <table class="sp-table">
  188. <thead>
  189. <tr>
  190. <th style="width:50%">数据库字段</th>
  191. <th style="width:50%">数据源字段</th>
  192. </tr>
  193. </thead>
  194. <tbody>
  195. <tr ng-repeat="item in ctl.thead">
  196. <td ng-bind="item.cname" data-code="{{item.code1}}" data-ckind="{{item.ckind}}"></td>
  197. <td>
  198. <select class="sp-select" ng-model="item.cname1">
  199. <option ng-repeat="item2 in ctl.excelHeadData" value="{{item2}}" ng-selected="item2==item.cname">{{item2}}</option>
  200. </select>
  201. </td>
  202. </tr>
  203. </tbody>
  204. </table>
  205. </div>
  206. <div class="sp-page sp-mt-30 sp-text-center">
  207. <button class="sp-btn-blue" id="btnTrueImportData" ng-click="ctl.btnTrueImportData()"><i class="fa fa-check"></i>&nbsp;&nbsp;<span>导入数据</span></button>
  208. </div>
  209. </div>
  210. </div>
  211. </div>
  212. <script src="../../AFrontEnd/js/jquery/jquery-2.1.4.min.js"></script>
  213. <script src="../../AFrontEnd/js/laydate/laydate.js"></script>
  214. <script src="../../AFrontEnd/js/angularjs/angular.js"></script>
  215. <script src="../../AFrontEnd/js/angularjs/dirPagination.js"></script>
  216. <script src="../../apiurljs.js"></script>
  217. <script src="../../js/sm4.js"></script>
  218. <!-- 导入excel -->
  219. <script src="js/jszip.js"></script>
  220. <script src="js/xlsx.js"></script>
  221. <!-- 导出excel -->
  222. <script src="js/vendor/jquery.jqprint-0.3.js"></script>
  223. <script src="js/vendor/shim.min.js"></script>
  224. <script src="js/vendor/jszip.js"></script>
  225. <script src="js/vendor/xlsx.full.js"></script>
  226. <script src="js/vendor/Blob.js"></script>
  227. <script src="js/vendor/FileSaver.js"></script>
  228. <script>document.write('<scri' + 'pt src="../../AFrontEnd/js/special/special.js?time=' + new Date().getTime() + '"></s' + 'cript>')</script>
  229. <script>document.write('<scri' + 'pt src="js/list1.js?time=' + new Date().getTime() + '"></s' + 'cript>')</script>
  230. <script src="../../AFrontEnd/js/special/spng.js"></script>
  231. <script src="../../AFrontEnd/js/special/spngvld.js"></script>
  232. </body>
  233. </html>