From 18fcb8ad28f583e3e1b99b23e4f7d9e1833dcd83 Mon Sep 17 00:00:00 2001
From: pengwei <2071057782@qq.com>
Date: 星期三, 12 三月 2025 14:16:30 +0800
Subject: [PATCH] 最新提交
---
项目代码/client/src/utils/index.js | 110 +++++++++++++++++++++---------------------------------
1 files changed, 43 insertions(+), 67 deletions(-)
diff --git "a/\351\241\271\347\233\256\344\273\243\347\240\201/client/src/utils/index.js" "b/\351\241\271\347\233\256\344\273\243\347\240\201/client/src/utils/index.js"
index 13e38d9..579358f 100644
--- "a/\351\241\271\347\233\256\344\273\243\347\240\201/client/src/utils/index.js"
+++ "b/\351\241\271\347\233\256\344\273\243\347\240\201/client/src/utils/index.js"
@@ -1,74 +1,9 @@
import { dayjs } from "element-plus";
+// import XLSX from "xlsx"; //瀵煎叆xlsx
export const baseUrl = "http://192.168.0.80:5000/"
-// export const baseUrl = "http://192.168.0.12:5000/"//娴嬭瘯鍦板潃
+// http://115.159.85.185:9091/
-// export const baseUrl = "http://szmz.gdkuanhai.com:9001"
-// export const baseUrl = "http://43.139.109.189:9001/";
-// export const baseUrl = "http://192.168.137.1:5000/"
-// export const baseUrl = "http://115.159.85.185:9091/"
-// export const baseUrl = "http://192.168.157.97:5000/"
-// export const baseUrl = 'http://127.0.0.1:5000/'
-
-export const goodsTypeList = [
- // { label: '鐗╂枡绫诲瀷', value: null },
- { label: "鐗╂枡", value: 1 },
- { label: "宸ュ叿", value: 2 },
- { label: "杈呮枡", value: 3 },
- { label: "鑰楁潗", value: 4 },
-];
-
-export const goodsSourceList = [
- // { label: '鐗╂枡鏉ユ簮', value: null },
- { label: "澶栬喘", value: 1 },
- { label: "澶栧崗", value: 2 },
- { label: "鑷埗", value: 3 },
- { label: "缁勪欢", value: 4 },
-];
-export const assembleStatusList = [
- { label: "寰呰閰�", value: 1 },
- { label: "瑁呴厤涓�", value: 2 },
- { label: "宸茶閰�", value: 3 },
- { label: "宸蹭綔搴�", value: 4 },
-];
-
-export const goodsQrCodeStatusList = [
- { label: "姝ｅ父鐮�", value: 1 },
- { label: "浣滃簾鐮�", value: 2 },
-];
-
-export const DeliverStatus = [
- { label: "寰呭彂璐�", value: 1 },
- { label: "宸插彂璐�", value: 2 },
-];
-
-export const ReceiveStatus = [
- { label: "寰呮敹璐�", value: 1 },
- { label: "宸叉敹璐�", value: 2 },
-];
-export const InstallStatus = [
- { label: "寰呭畨瑁�", value: 1 },
- { label: "瀹夎涓�", value: 2 },
- { label: "宸插畨瑁�", value: 3 },
-];
-export const DebugStatus = [
- { label: "寰呰皟璇�", value: 1 },
- { label: "璋冭瘯涓�", value: 2 },
- { label: "宸茶皟璇�", value: 3 },
-];
-export const AcceptanceStatus = [
- { label: "寰呴獙鏀�", value: 1 },
- { label: "楠屾敹涓�", value: 2 },
- { label: "宸查獙鏀�", value: 3 }
-
-];
-export const AuditStatus = [
- { label: "寰呭鏍�", value: 0 },
- { label: "璇曠敤", value: 1 },
- { label: "姝ｅ紡", value: 2 },
- { label: "瀹℃牳涓嶉�氳繃", value: 3 },
- // 寰呭鏍搞�佽瘯鐢ㄣ�佹寮忋�佸鏍镐笉閫氳繃
-];
//瀵硅薄杞現ormData鐢熸垚鏂规硶
export function objToFormData(obj) {
@@ -87,3 +22,44 @@
return "";
}
}
+
+export function exportExcel(json, name, titleArr, sheetName) {
+ /* convert state to workbook */
+ var data = new Array();
+ var keyArray = new Array();
+ const getLength = function (obj) {
+ var count = 0;
+ for (var i in obj) {
+ if (obj.hasOwnProperty(i)) {
+ count++;
+ }
+ }
+ return count;
+ };
+ for (const key1 in json) {
+ if (json.hasOwnProperty(key1)) {
+ const element = json[key1];
+ var rowDataArray = new Array();
+ for (const key2 in element) {
+ if (element.hasOwnProperty(key2)) {
+ const element2 = element[key2];
+ rowDataArray.push(element2);
+ if (keyArray.length < getLength(element)) {
+ keyArray.push(key2);
+ }
+ }
+ }
+ data.push(rowDataArray);
+ }
+ }
+ // keyArray涓鸿嫳鏂囧瓧娈佃〃澶�
+ data.splice(0, 0, keyArray, titleArr);
+ const ws = XLSX.utils.aoa_to_sheet(data);
+ const wb = XLSX.utils.book_new();
+ // 姝ゅ闅愯棌鑻辨枃瀛楁琛ㄥご
+ var wsrows = [{ hidden: true }];
+ ws['!rows'] = wsrows; // ws - worksheet
+ XLSX.utils.book_append_sheet(wb, ws, sheetName);
+ /* generate file and send to client */
+ XLSX.writeFile(wb, name + '.xlsx');
+}
\ No newline at end of file
--
Gitblit v1.9.3