ecClubWork.html 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286
  1. <!DOCTYPE html>
  2. <html>
  3. <head lang='zh'>
  4. <meta charset='utf-8'>
  5. <meta http-equiv="X-UA-Compatible" content="IE=edge" />
  6. <meta name="renderer" content="webkit" />
  7. <meta name="viewport" content="width=device-width, initial-scale=1,user-scalable=0" />
  8. <title>Luckysheet</title>
  9. <link rel='stylesheet' href='/static/js/luckysheet/plugins/css/pluginsCss.css' />
  10. <link rel='stylesheet' href='/static/js/luckysheet/plugins/plugins.css' />
  11. <link rel='stylesheet' href='/static/js/luckysheet/css/luckysheet.css' />
  12. <link rel='stylesheet' href='/static/js/luckysheet/assets/iconfont/iconfont.css' />
  13. <link charset="utf-8" rel="stylesheet" href="/static/css/layui.css?v=1.0.0">
  14. <script>
  15. var _PageHeight = document.documentElement.clientHeight,
  16. _PageWidth = document.documentElement.clientWidth;
  17. var _LoadingTop = _PageHeight > 61 ? (_PageHeight - 61) / 2 : 0,
  18. _LoadingLeft = _PageWidth > 215 ? (_PageWidth - 215) / 2 : 0;
  19. var _LoadingHtml = '<div id="loadingDiv" style="position:absolute;left:0;width:100%;height:' + _PageHeight + 'px;top:0;background:#f3f8ff;opacity:1;filter:alpha(opacity=80);z-index:10000;"><div style="position: absolute; cursor1: wait; left: ' + _LoadingLeft + 'px; top:' + _LoadingTop + 'px; width: auto; height: 57px; line-height: 57px; padding-left: 50px; padding-right: 5px; color: #696969; font-family:\'Microsoft YaHei\';"><img style="width:200px;height:200px" src="../images/loading.gif"></div></div>';
  20. document.write(_LoadingHtml);
  21. document.onreadystatechange = completeLoading;
  22. function completeLoading() {
  23. if (document.readyState == "complete") {
  24. var loadingMask = document.getElementById('loadingDiv');
  25. loadingMask.parentNode.removeChild(loadingMask);
  26. }
  27. }
  28. </script>
  29. <script src="/static/js/layui.js?v=1.0.0"></script>
  30. <script src="/static/js/exceljs.js"></script>
  31. <script src="/static/js/fileSave.js"></script>
  32. <script src="/static/js/luckysheet/luckSheetExcel.js"></script>
  33. <script src="/static/js/luckysheet/plugins/js/plugin.js"></script>
  34. <script src="/static/js/luckysheet/luckysheet.umd.js"></script>
  35. <script src="/static/js/api.config.js"></script>
  36. <script src="/static/js/util.js?v=1.0.0"></script>
  37. <script src="/static/js/url.js?v=1.0.0"></script>
  38. <script src="/static/js/exportExcel.js"></script>
  39. <script src="/static/js/fullScreen.js"></script>
  40. </head>
  41. <style>
  42. * {
  43. padding: 0;
  44. margin: 0;
  45. }
  46. html,
  47. body {
  48. height: 100%;
  49. }
  50. #monthSelect {
  51. padding: 10px 0px;
  52. }
  53. </style>
  54. <body>
  55. <!-- <div class="layui-inline" id="monthSelect">
  56. <label class="layui-form-label">控制权限</label>
  57. <div class="layui-input-inline">
  58. <form class="layui-form mc-work-form">
  59. <select name="city" lay-filter="powerFlag" id="powerFlag">
  60. <option value="0">开启</option>
  61. <option value="1">关闭</option>
  62. </select>
  63. </form>
  64. </div>
  65. </div> -->
  66. <div style="height:90%;width: 100%;">
  67. <div id="luckysheet" style="width:100%;height:100%">
  68. </div>
  69. </div>
  70. <script>
  71. //监听window是否全屏,并进行相应的操作,支持esc键退出
  72. window.onresize = function () {
  73. var isFull = !!(document.webkitIsFullScreen || document.mozFullScreen ||
  74. document.msFullscreenElement || document.fullscreenElement
  75. );//!document.webkitIsFullScreen都为true。因此用!!
  76. if (isFull == false) {
  77. $("#exitFullScreen").css("display", "none");
  78. $("#fullScreen").css("display", "");
  79. } else {
  80. $("#exitFullScreen").css("display", "");
  81. $("#fullScreen").css("display", "none");
  82. }
  83. }
  84. </script>
  85. <script>
  86. var id = '' // 模板id 查看/修改load时候用
  87. var powerFlag = '0'; // 权限控制 0 开启 1关闭
  88. var excelId = '';
  89. var tempType = '0'; // 模板类型 0-年度预算 1-季度预算 2-月度预算 3-部门预算采购项目管理
  90. var flag = false; // 控制excel是否可以编辑
  91. var userId; // 用户ID
  92. $(function () {
  93. userId = JSON.parse(window.top.sessionStorage.userInfo).loginNo
  94. })
  95. layui.use(['laydate', 'form'], function () {
  96. var laydate = layui.laydate;
  97. var form = layui.form;
  98. form.on('select(powerFlag)', function (data) {
  99. powerFlag = data.value
  100. })
  101. // 获取数据
  102. function getData() {
  103. // 先销毁excel重新加载
  104. if (window.luckysheet) {
  105. window.luckysheet.destroy();
  106. }
  107. var reg = new RegExp("(^|&)" + name + "=([^&]*)(&|$)", "i");
  108. var r = window.top.location.href.split('id=')[1];
  109. var url = '/market/cbusiDeploy/load';
  110. util.ajaxJson("数据加载中", ctx + url, {
  111. "id": r ? r : '',
  112. }, function (res) {
  113. if (res.result == 0) {
  114. // 查看和修改时 下拉框赋值
  115. if(res.body[0]){
  116. if(res.body[0].config.authority){
  117. getData()
  118. }
  119. powerFlag = res.body[0].powerFlag
  120. $('#powerFlag').val(res.body[0].powerFlag)
  121. tempType = res.body[0].tempType
  122. $('#excelPosition').val(res.body[0].colHeaderNum)
  123. $('#tempType').val(res.body[0].tempType)
  124. form.render();
  125. excelId = res.body[0].id;
  126. // res.body[0].calcChain = [];
  127. initExcel(res.body)
  128. }else{
  129. // getData()
  130. }
  131. }
  132. });
  133. initExcel()
  134. }
  135. // 表格初始化
  136. function initExcel(data) {
  137. if(powerFlag == '1'){
  138. flag = false
  139. }else{
  140. flag = true
  141. }
  142. try {
  143. luckysheet.create({
  144. container: 'luckysheet',
  145. data: data,
  146. showsheetbar: false, // 底部sheet显示/隐藏
  147. showstatisticBar: false, // 底部计数
  148. showtoolbar:false,
  149. showinfobar: true, // 顶部信息 文件名称 按钮
  150. allowUpdate: false, // 是否允许操作表格后的后台更新 在线文档websocket时为true
  151. allowEdit: flag, // 是否允许前台编辑
  152. column: 12,
  153. title: '经分会部署工作', // 文件名称
  154. row: 10,
  155. lang: 'zh',
  156. showstatisticBar: false, // 底部计数
  157. showstatisticBarConfig: {
  158. count: false, // 计数栏
  159. view: false, // 打印视图
  160. zoom: false, // 缩放
  161. },
  162. functionButton: '<input id="imports" type="file" class="btn btn-primary" style="padding:3px 6px;font-size: 12px;margin-right: 10px;"></input><button id="saves" class="btn btn-primary btn-danger" style=" padding:3px 6px; font-size: 12px; margin-right: 10px;">保存</button><button id="exports" class="btn btn-primary" style="padding:3px 6px;font-size: 12px;margin-right: 10px;">导出</button><button id="fullScreen" class="btn btn-primary" style="padding:3px 6px;font-size: 12px;margin-right: 10px;">全屏显示</button><button id="exitFullScreen" class="btn btn-primary" style="padding:3px 6px;font-size: 12px;margin-right: 10px;display:none">退出全屏</button>',
  163. cellRightClickConfig: {
  164. copy: false, // 复制
  165. copyAs: false, // 复制为
  166. paste: false, // 粘贴
  167. insertRow: true, // 插入行
  168. insertColumn: true, // 插入列
  169. deleteRow: true, // 删除选中行
  170. deleteColumn: true, // 删除选中列
  171. deleteCell: false, // 删除单元格
  172. hideRow: false, // 隐藏选中行和显示选中行
  173. hideColumn: false, // 隐藏选中列和显示选中列
  174. rowHeight: true, // 行高
  175. columnWidth: true, // 列宽
  176. clear: false, // 清除内容
  177. matrix: false, // 矩阵操作选区
  178. sort: false, // 排序选区
  179. filter: false, // 筛选选区
  180. chart: false, // 图表生成
  181. image: false, // 插入图片
  182. link: false, // 插入链接
  183. data: false, // 数据验证
  184. cellFormat: false, // 设置单元格格式
  185. mComplete: false,
  186. mCetup: false,
  187. mRevoke: false
  188. },
  189. })
  190. } catch (err) {
  191. console.log(err)
  192. }
  193. initHandel()
  194. }
  195. // 绑定按钮事件
  196. function initHandel() {
  197. $("#fullScreen").on("click", function () {
  198. fullScreen();
  199. })
  200. //退出全屏
  201. $("#exitFullScreen").on("click", function () {
  202. exitFullscreen();
  203. })
  204. // 返回
  205. $('#goBack').off('click').click(function () {
  206. window.top.$vm.$router.push('/budgetList')
  207. })
  208. // 保存
  209. $('#saves').off("click").click(function () {
  210. // 当前工作表名
  211. var reg = new RegExp("(^|&)" + name + "=([^&]*)(&|$)", "i");
  212. var r = window.top.location.href.split('id=')[1];
  213. var sheetName = luckysheet.getSheet().name
  214. var data = luckysheet.getSheet(sheetName)
  215. data.id = r ? r : excelId
  216. data.fileName = luckysheet.getWorkbookName()
  217. data.powerFlag = powerFlag
  218. data.powerFlagDev = powerFlag == '0' ? '开' : '关'
  219. data.tempType = tempType
  220. data.colHeaderNum = 1
  221. data.tempTypeDesc = ''
  222. data.title = luckysheet.getWorkbookName()
  223. var urlsave = ''
  224. r?urlsave = '/market/cbusiDeploy/save':urlsave = '/market/cbusiDeploy/add'
  225. util.ajaxJson("正在加载中", ctx + urlsave, {
  226. data: data
  227. }, function (data) {
  228. getData()
  229. });
  230. })
  231. // 导出
  232. $('#exports').click(function () {
  233. exportExcel(luckysheet.getluckysheetfile(), 'excel')
  234. })
  235. // 导入
  236. $("#imports").change(function (evt) {
  237. var files = evt.target.files;
  238. if (files == null || files.length == 0) {
  239. window.top.$vm.$message({
  240. message: '没有文件导入',
  241. type: 'info'
  242. })
  243. return;
  244. }
  245. var name = files[0].name;
  246. var suffixArr = name.split("."),
  247. suffix = suffixArr[suffixArr.length - 1];
  248. if (suffix != "xlsx") {
  249. window.top.$vm.$message({
  250. message: '目前只支持xlsx文件的导入',
  251. type: 'info'
  252. })
  253. return;
  254. }
  255. // 解析文件
  256. LuckyExcel.transformExcelToLucky(
  257. files[0],
  258. function (exportJson, luckysheetfile) {
  259. if (exportJson.sheets == null || exportJson.sheets.length == 0) {
  260. window.top.$vm.$message({
  261. message: '无法读取excel文件的内容,当前不支持xls文件',
  262. type: 'info'
  263. })
  264. return;
  265. }
  266. // 销毁原来的excel
  267. window.luckysheet.destroy();
  268. // 重新加载
  269. initExcel([exportJson.sheets[0]])
  270. // 绑定按钮事件
  271. initHandel()
  272. }
  273. );
  274. });
  275. }
  276. getData()
  277. })
  278. </script>
  279. </body>
  280. </html>