From aa0161bf05195ccb00bc1d8da4b1b8218f93f4d3 Mon Sep 17 00:00:00 2001
From: LSH
Date: 星期六, 04 十一月 2023 16:14:18 +0800
Subject: [PATCH] #
---
src/main/webapp/views/priOnline2/priOnline_check.html | 473 ++++++++++++++++++++++++++++++-----------------------------
1 files changed, 241 insertions(+), 232 deletions(-)
diff --git a/src/main/webapp/views/priOnline2/priOnline_check.html b/src/main/webapp/views/priOnline2/priOnline_check.html
index 0eb0b3b..6f88f29 100644
--- a/src/main/webapp/views/priOnline2/priOnline_check.html
+++ b/src/main/webapp/views/priOnline2/priOnline_check.html
@@ -1,271 +1,280 @@
<!DOCTYPE html>
<html>
<head>
- <meta charset="utf-8">
- <title>excel</title>
- <link rel="stylesheet" href="../../static/layui/css/layui.css" media="all">
- <link rel='stylesheet' href='../../static/plugins/css/pluginsCss.css' />
- <link rel='stylesheet' href='../../static/plugins/plugins.css' />
- <link rel='stylesheet' href='../../static/css/luckysheet.css' />
- <link rel='stylesheet' href='../../static/assets/iconfont/iconfont.css' />
- <script src="../../static/js/luckysheet_js/plugin.js"></script>
- <script src="../../static/js/luckysheet_js/luckysheet.umd.js"></script>
- <script src="../../static/js/luckysheet_js/luckyexcel.umd.js"></script>
- <script src="../../static/js/luckysheet_js/exceljs.min.js"></script>
- <script type="text/javascript" src="../../static/js/luckysheet_js/export.js" charset="utf-8"></script>
- <script type="text/javascript" src="../../static/js/luckysheet_js/pako.es5.js" charset="utf-8"></script>
- <script type="text/javascript" src="../../static/js/luckysheet_js/base64.min.js" charset="utf-8"></script>
- <script type="text/javascript" src="../../static/layui/layui.js" charset="utf-8"></script>
- <script type="text/javascript" src="../../static/js/common.js" charset="utf-8"></script>
- <script type="text/javascript" src="../../static/js/luckysheet_js/print.min.js" charset="utf-8"></script>
+ <meta charset="utf-8">
+ <title>excel</title>
+ <link rel="stylesheet" href="../../static/layui/css/layui.css" media="all">
+ <link rel='stylesheet' href='../../static/plugins/css/pluginsCss.css'/>
+ <link rel='stylesheet' href='../../static/plugins/plugins.css'/>
+ <link rel='stylesheet' href='../../static/css/luckysheet.css'/>
+ <link rel='stylesheet' href='../../static/assets/iconfont/iconfont.css'/>
+ <script src="../../static/js/luckysheet_js/plugin.js"></script>
+ <script src="../../static/js/luckysheet_js/luckysheet.umd.js"></script>
+ <script src="../../static/js/luckysheet_js/luckyexcel.umd.js"></script>
+ <script src="../../static/js/luckysheet_js/exceljs.min.js"></script>
+ <script type="text/javascript" src="../../static/js/luckysheet_js/export.js" charset="utf-8"></script>
+ <script type="text/javascript" src="../../static/js/luckysheet_js/pako.es5.js" charset="utf-8"></script>
+ <script type="text/javascript" src="../../static/js/luckysheet_js/base64.min.js" charset="utf-8"></script>
+ <script type="text/javascript" src="../../static/layui/layui.js" charset="utf-8"></script>
+ <script type="text/javascript" src="../../static/js/common.js" charset="utf-8"></script>
+ <script type="text/javascript" src="../../static/js/luckysheet_js/print.min.js" charset="utf-8"></script>
</head>
<body>
<div style="display: flex;position: absolute;top: 20px;left:30px;z-index: 9999;">
- <!-- <div><button type="button" id="export">瀵煎嚭Execel</button></div>-->
-<!-- <div><button type="button" id="save">淇濆瓨鍒版湇鍔″櫒</button></div>-->
-<!-- <div><button type="button" id="otherSave">鍙︿繚瀛樺埌鏈嶅姟鍣�</button></div>-->
- <div><button type="button" class="layui-btn layui-btn-primary layui-btn-xs btn-edit" id="allprint">鍏ㄩ儴鎵撳嵃</button></div>
- <div><button type="button" class="layui-btn layui-btn-primary layui-btn-xs btn-edit" id="print">閫夊尯鎵撳嵃</button></div>
- <div><button type="button" class="layui-btn layui-btn-primary layui-btn-xs btn-edit" id="download">涓嬭浇</button></div>
+ <!-- <div><button type="button" id="export">瀵煎嚭Execel</button></div>-->
+ <!-- <div><button type="button" id="save">淇濆瓨鍒版湇鍔″櫒</button></div>-->
+ <!-- <div><button type="button" id="otherSave">鍙︿繚瀛樺埌鏈嶅姟鍣�</button></div>-->
+ <div>
+ <button type="button" class="layui-btn layui-btn-primary layui-btn-xs btn-edit" id="allprint">鍏ㄩ儴鎵撳嵃</button>
+ </div>
+ <div>
+ <button type="button" class="layui-btn layui-btn-primary layui-btn-xs btn-edit" id="print">閫夊尯鎵撳嵃</button>
+ </div>
+ <div>
+ <button type="button" class="layui-btn layui-btn-primary layui-btn-xs btn-edit" id="download">涓嬭浇</button>
+ </div>
</div>
-<div id="luckysheet" style="margin:0px;padding:0px;position:absolute;width:100%;height: 100vh;left: 0px;top: 0px;"></div>
+<div id="luckysheet"
+ style="margin:0px;padding:0px;position:absolute;width:100%;height: 100vh;left: 0px;top: 0px;"></div>
<script>
- $(function () {
- var layer = layui.layer;
+ $(function () {
+ var layer = layui.layer;
- //閰嶇疆椤�
- var options = {
- container: 'luckysheet' ,//luckysheet涓哄鍣╥d
- title: '鏌ョ湅璇环', //宸ヤ綔绨垮悕绉�
- lang: 'zh', //璁惧畾琛ㄦ牸璇█ 鍥介檯鍖栬缃紝鍏佽璁剧疆琛ㄦ牸鐨勮瑷�锛屾敮鎸佷腑鏂�("zh")鍜岃嫳鏂�("en")
- allowEdit: true, //鏄惁鍏佽鍓嶅彴缂栬緫
- sheetFormulaBar: true, //鏄惁鏄剧ず鍏紡鏍�
- forceCalculation: true,//寮哄埗璁＄畻鍏紡
- myFolderUrl: '' //宸︿笂瑙�<杩斿洖鎸夐挳鐨勯摼鎺�
- }
+ //閰嶇疆椤�
+ var options = {
+ container: 'luckysheet',//luckysheet涓哄鍣╥d
+ title: '鏌ョ湅璇环', //宸ヤ綔绨垮悕绉�
+ lang: 'zh', //璁惧畾琛ㄦ牸璇█ 鍥介檯鍖栬缃紝鍏佽璁剧疆琛ㄦ牸鐨勮瑷�锛屾敮鎸佷腑鏂�("zh")鍜岃嫳鏂�("en")
+ allowEdit: true, //鏄惁鍏佽鍓嶅彴缂栬緫
+ sheetFormulaBar: true, //鏄惁鏄剧ず鍏紡鏍�
+ forceCalculation: true,//寮哄埗璁＄畻鍏紡
+ myFolderUrl: '' //宸︿笂瑙�<杩斿洖鎸夐挳鐨勯摼鎺�
+ }
- let checkDataFile = "";
+ let checkDataFile = "";
- if(getUrlParams('id') == false || getUrlParams('id') == undefined){
- //鏂板
- luckysheet.create(options)
- $("#luckysheet_info_detail_update").hide()
- $("#luckysheet_info_detail_save").hide()
- $("#luckysheet_info_detail_title").hide()
- }else{
- //淇敼
- $.ajax({
- type:"get",
- url: baseUrl + "/priOnline2/viewCheck/" + getUrlParams('id') + "/auth",
- dataType:"json",
- headers: {'token': localStorage.getItem('token')},
- success:function(res) {
- if (res.code == 200) {
- checkDataFile = res.data.checkDataFile
- options.data = unzip(res.data.checkData)
+ if (getUrlParams('id') == false || getUrlParams('id') == undefined) {
+ //鏂板
luckysheet.create(options)
$("#luckysheet_info_detail_update").hide()
$("#luckysheet_info_detail_save").hide()
$("#luckysheet_info_detail_title").hide()
- }else {
- layer.msg(res.msg,{time:1000})
- }
+ } else {
+ //淇敼
+ $.ajax({
+ type: "get",
+ url: baseUrl + "/priOnline2/viewCheck/" + getUrlParams('id') + "/auth",
+ dataType: "json",
+ headers: {'token': localStorage.getItem('token')},
+ success: function (res) {
+ if (res.code == 200) {
+ checkDataFile = res.data.checkDataFile
+ options.data = unzip(res.data.checkData)
+ luckysheet.create(options)
+ $("#luckysheet_info_detail_update").hide()
+ $("#luckysheet_info_detail_save").hide()
+ $("#luckysheet_info_detail_title").hide()
+ } else {
+ layer.msg(res.msg, {time: 1000})
+ }
+ }
+ });
+
}
- });
- }
-
- $("#export").on("click",() => {
- console.log('export')
- exportExcel(luckysheet.getluckysheetfile()).then((e) => {
- saveFile(e,'file');
- })
- })
-
- //淇濆瓨鍒版湇鍔″櫒
- $("#save").on("click",() => {
- if(getUrlParams('id') == false || getUrlParams('id') == undefined){
- //鏂板
- $.ajax({
- url: baseUrl + "/priOnline2/add/auth",
- headers: {'token': localStorage.getItem('token')},
- data: JSON.stringify({
- title: luckysheet.toJson().title,
- sheetData: zip(luckysheet.getAllSheets()),
- itemId: getUrlParams('item_id'),
- priId: getUrlParams('pri_id')
- }),
- method: 'POST',
- dataType: "json",
- contentType:'application/json;charset=UTF-8',
- success: function (res) {
- if (res.code == 200) {
- layer.msg('淇濆瓨鎴愬姛',{time:1000},() => {
- parent.location.reload()
- })
- }else{
- layer.msg(res.msg,{time:1000})
- }
- }
+ $("#export").on("click", () => {
+ console.log('export')
+ exportExcel(luckysheet.getluckysheetfile()).then((e) => {
+ saveFile(e, 'file');
+ })
})
- }else {
- //淇敼
- $.ajax({
- url: baseUrl + "/priOnline2/update/auth",
- headers: {'token': localStorage.getItem('token')},
- data: JSON.stringify({
- id: getUrlParams('id'),
- title: luckysheet.toJson().title,
- sheetData: zip(luckysheet.getAllSheets())
- }),
- method: 'POST',
- dataType: "json",
- contentType:'application/json;charset=UTF-8',
- success: function (res) {
- if (res.code == 200) {
- layer.msg('淇濆瓨鎴愬姛',{time:1000},() => {
- parent.location.reload()
- })
- }else{
- layer.msg(res.msg,{time:1000})
+
+ //淇濆瓨鍒版湇鍔″櫒
+ $("#save").on("click", () => {
+ if (getUrlParams('id') == false || getUrlParams('id') == undefined) {
+ //鏂板
+ $.ajax({
+ url: baseUrl + "/priOnline2/add/auth",
+ headers: {'token': localStorage.getItem('token')},
+ data: JSON.stringify({
+ title: luckysheet.toJson().title,
+ sheetData: zip(luckysheet.getAllSheets()),
+ itemId: getUrlParams('item_id'),
+ priId: getUrlParams('pri_id')
+ }),
+ method: 'POST',
+ dataType: "json",
+ contentType: 'application/json;charset=UTF-8',
+ success: function (res) {
+ if (res.code == 200) {
+ layer.msg('淇濆瓨鎴愬姛', {time: 1000}, () => {
+ parent.location.reload()
+ })
+ } else {
+ layer.msg(res.msg, {time: 1000})
+ }
+ }
+ })
+ } else {
+ //淇敼
+ $.ajax({
+ url: baseUrl + "/priOnline2/update/auth",
+ headers: {'token': localStorage.getItem('token')},
+ data: JSON.stringify({
+ id: getUrlParams('id'),
+ title: luckysheet.toJson().title,
+ sheetData: zip(luckysheet.getAllSheets())
+ }),
+ method: 'POST',
+ dataType: "json",
+ contentType: 'application/json;charset=UTF-8',
+ success: function (res) {
+ if (res.code == 200) {
+ layer.msg('淇濆瓨鎴愬姛', {time: 1000}, () => {
+ parent.location.reload()
+ })
+ } else {
+ layer.msg(res.msg, {time: 1000})
+ }
+ }
+ })
}
- }
})
- }
+
+ $("#download").on("click", () => {
+ window.open(baseUrl + "/priOnline2/checkDataDownload/" + checkDataFile)
+ })
+
})
- $("#download").on("click",() => {
- window.open(baseUrl + "/priOnline2/checkDataDownload/" +checkDataFile)
+ $("#allprint").on("click", () => {
+ printExcel()
})
- })
+ $("#print").on("click", () => {
+ let src = luckysheet.getScreenshot(); // 鐢熸垚base64鍥剧墖
+ const style = '@page {margin:0 10mm};'
+ printJS({
+ printable: src,
+ type: 'image',
+ style: style
+ }) // Print.js鎻掍欢
+ })
- $("#allprint").on("click",() => {
- printExcel()
- })
+ // 鑾峰彇琛ㄦ牸涓寘鍚唴瀹圭殑row锛宑olumn
+ function getExcelRowColumn() {
+ const sheetData = luckysheet.getSheetData();
+ let objRowColumn = {
+ row: [null, null], //琛�
+ column: [null, null], //鍒�
+ };
+ sheetData.forEach((item, index) => {
+ //琛屾暟
+ item.forEach((it, itemIndex) => {
+ if (it !== null) {
+ if (objRowColumn.row[0] == null) objRowColumn.row[0] = index; // row绗竴浣�
+ objRowColumn.row[1] = index; //row绗簩浣�
+ if (objRowColumn.column[0] == null)
+ objRowColumn.column[0] = itemIndex; //column绗竴浣�
+ objRowColumn.column[1] = itemIndex; //column绗簩浣�
+ }
+ });
+ });
+ return objRowColumn;
+ }
- $("#print").on("click",() => {
- let src = luckysheet.getScreenshot(); // 鐢熸垚base64鍥剧墖
- const style = '@page {margin:0 10mm};'
- printJS({
- printable: src,
- type: 'image',
- style: style
- }) // Print.js鎻掍欢
- })
+ function printExcel() {
+ let RowColumn = this.getExcelRowColumn() // 鑾峰彇鏈夊�肩殑琛屽拰鍒�
+ RowColumn.column[0] = 0 //鍥犻渶瑕佹墦鍗板乏杈圭殑杈规锛岄渶閲嶆柊璁剧疆
+ luckysheet.setRangeShow(RowColumn) // 杩涜閫夊尯鎿嶄綔
+ let src = luckysheet.getScreenshot(); // 鐢熸垚base64鍥剧墖
+ const style = '@page {margin:0 10mm};'
+ printJS({
+ printable: src,
+ type: 'image',
+ style: style
+ }) // Print.js鎻掍欢
+ }
- // 鑾峰彇琛ㄦ牸涓寘鍚唴瀹圭殑row锛宑olumn
- function getExcelRowColumn() {
- const sheetData = luckysheet.getSheetData();
- let objRowColumn = {
- row: [null, null], //琛�
- column: [null, null], //鍒�
- };
- sheetData.forEach((item, index) => {
- //琛屾暟
- item.forEach((it, itemIndex) => {
- if (it !== null) {
- if (objRowColumn.row[0] == null) objRowColumn.row[0] = index; // row绗竴浣�
- objRowColumn.row[1] = index; //row绗簩浣�
- if (objRowColumn.column[0] == null)
- objRowColumn.column[0] = itemIndex; //column绗竴浣�
- objRowColumn.column[1] = itemIndex; //column绗簩浣�
+ function getUrlParams(name) {
+ var url = window.location.search;
+ if (url.indexOf('?') == -1) {
+ return false;
}
- });
- });
- return objRowColumn;
- }
-
- function printExcel() {
- let RowColumn = this.getExcelRowColumn() // 鑾峰彇鏈夊�肩殑琛屽拰鍒�
- RowColumn.column[0] = 0 //鍥犻渶瑕佹墦鍗板乏杈圭殑杈规锛岄渶閲嶆柊璁剧疆
- luckysheet.setRangeShow(RowColumn) // 杩涜閫夊尯鎿嶄綔
- let src = luckysheet.getScreenshot(); // 鐢熸垚base64鍥剧墖
- const style = '@page {margin:0 10mm};'
- printJS({
- printable: src,
- type: 'image',
- style: style
- }) // Print.js鎻掍欢
- }
-
- function getUrlParams(name) {
- var url = window.location.search;
- if (url.indexOf('?') == -1) { return false; }
- url = url.substr(1);
- url = url.split('&');
- var name = name || '';
- var nameres;
- for (var i = 0; i < url.length; i++) {
- var info = url[i].split('=');
- var obj = {};
- obj[info[0]] = decodeURI(info[1]);
- url[i] = obj;
- }
- if (name) {
- for (var i = 0; i < url.length; i++) {
- for (var key in url[i]) {
- if (key == name) {
- nameres = url[i][key];
- }
+ url = url.substr(1);
+ url = url.split('&');
+ var name = name || '';
+ var nameres;
+ for (var i = 0; i < url.length; i++) {
+ var info = url[i].split('=');
+ var obj = {};
+ obj[info[0]] = decodeURI(info[1]);
+ url[i] = obj;
}
- }
- } else {
- nameres = url;
+ if (name) {
+ for (var i = 0; i < url.length; i++) {
+ for (var key in url[i]) {
+ if (key == name) {
+ nameres = url[i][key];
+ }
+ }
+ }
+ } else {
+ nameres = url;
+ }
+ return nameres;
}
- return nameres;
- }
- // 鍘嬬缉
- function zip(data) {
- if (!data) return data
- // 鍒ゆ柇鏁版嵁鏄惁闇�瑕佽浆涓篔SON
- const dataJson = typeof data !== 'string' && typeof data !== 'number' ? JSON.stringify(data) : data
+ // 鍘嬬缉
+ function zip(data) {
+ if (!data) return data
+ // 鍒ゆ柇鏁版嵁鏄惁闇�瑕佽浆涓篔SON
+ const dataJson = typeof data !== 'string' && typeof data !== 'number' ? JSON.stringify(data) : data
- // 浣跨敤Base64.encode澶勭悊瀛楃缂栫爜锛屽吋瀹逛腑鏂�
- const str = Base64.encode(dataJson)
- let binaryString = pako.gzip(str);
- let arr = Array.from(binaryString);
- let s = "";
- arr.forEach((item, index) => {
- s += String.fromCharCode(item)
- })
- return btoa(s)
- }
-
- // 瑙ｅ帇
- function unzip(b64Data) {
- let strData = atob(b64Data);
- let charData = strData.split('').map(function (x) {
- return x.charCodeAt(0);
- });
- let binData = new Uint8Array(charData);
- let data = pako.ungzip(binData);
-
- // 鈫撳垏鐗囧鐞嗘暟鎹紝闃叉鍐呭瓨婧㈠嚭鎶ラ敊鈫�
- let str = '';
- const chunk = 8 * 1024
- let i;
- for (i = 0; i < data.length / chunk; i++) {
- str += String.fromCharCode.apply(null, data.slice(i * chunk, (i + 1) * chunk));
+ // 浣跨敤Base64.encode澶勭悊瀛楃缂栫爜锛屽吋瀹逛腑鏂�
+ const str = Base64.encode(dataJson)
+ let binaryString = pako.gzip(str);
+ let arr = Array.from(binaryString);
+ let s = "";
+ arr.forEach((item, index) => {
+ s += String.fromCharCode(item)
+ })
+ return btoa(s)
}
- str += String.fromCharCode.apply(null, data.slice(i * chunk));
- // 鈫戝垏鐗囧鐞嗘暟鎹紝闃叉鍐呭瓨婧㈠嚭鎶ラ敊鈫�
- const unzipStr = Base64.decode(str);
- let result = ''
+ // 瑙ｅ帇
+ function unzip(b64Data) {
+ let strData = atob(b64Data);
+ let charData = strData.split('').map(function (x) {
+ return x.charCodeAt(0);
+ });
+ let binData = new Uint8Array(charData);
+ let data = pako.ungzip(binData);
- // 瀵硅薄鎴栨暟缁勮繘琛孞SON杞崲
- try {
- result = JSON.parse(unzipStr)
- } catch (error) {
- if (/Unexpected token o in JSON at position 0/.test(error)) {
- // 濡傛灉娌℃湁杞崲鎴愬姛锛屼唬琛ㄥ�间负鍩烘湰鏁版嵁锛岀洿鎺ヨ祴鍊�
- result = unzipStr
- }
+ // 鈫撳垏鐗囧鐞嗘暟鎹紝闃叉鍐呭瓨婧㈠嚭鎶ラ敊鈫�
+ let str = '';
+ const chunk = 8 * 1024
+ let i;
+ for (i = 0; i < data.length / chunk; i++) {
+ str += String.fromCharCode.apply(null, data.slice(i * chunk, (i + 1) * chunk));
+ }
+ str += String.fromCharCode.apply(null, data.slice(i * chunk));
+ // 鈫戝垏鐗囧鐞嗘暟鎹紝闃叉鍐呭瓨婧㈠嚭鎶ラ敊鈫�
+
+ const unzipStr = Base64.decode(str);
+ let result = ''
+
+ // 瀵硅薄鎴栨暟缁勮繘琛孞SON杞崲
+ try {
+ result = JSON.parse(unzipStr)
+ } catch (error) {
+ if (/Unexpected token o in JSON at position 0/.test(error)) {
+ // 濡傛灉娌℃湁杞崲鎴愬姛锛屼唬琛ㄥ�间负鍩烘湰鏁版嵁锛岀洿鎺ヨ祴鍊�
+ result = unzipStr
+ }
+ }
+ return result
}
- return result
- }
</script>
</body>
</html>
\ No newline at end of file
--
Gitblit v1.9.1