index.ts 43 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411
  1. import { isArray, isNullOrUnDef, isNumber, isString, isDate, isObject } from "@/utils/is";
  2. import { FieldNamesProps } from "@/components/LjVxeTable/interface";
  3. import XEUtils from "xe-utils";
  4. import { cloneDeep, pick, get } from "lodash-es";
  5. import dayjs from "dayjs";
  6. import { useAuthButtons } from "@/hooks/useAuthButtons";
  7. import { useUserStore } from "@/stores/modules/user";
  8. import { GetFormulaCompute } from "@/api/modules/common";
  9. import { ElMessage } from "element-plus";
  10. import type { Menu } from "@/typings/global";
  11. /**
  12. * @description 获取localStorage
  13. * @param {String} key Storage名称
  14. * @returns {String}
  15. */
  16. export function localGet(key: string) {
  17. const value = window.localStorage.getItem(key);
  18. try {
  19. return JSON.parse(window.localStorage.getItem(key) as string);
  20. } catch (error) {
  21. return value;
  22. }
  23. }
  24. /**
  25. * @description 存储localStorage
  26. * @param {String} key Storage名称
  27. * @param {*} value Storage值
  28. * @returns {void}
  29. */
  30. export function localSet(key: string, value: any) {
  31. window.localStorage.setItem(key, JSON.stringify(value));
  32. }
  33. /**
  34. * @description 清除localStorage
  35. * @param {String} key Storage名称
  36. * @returns {void}
  37. */
  38. export function localRemove(key: string) {
  39. window.localStorage.removeItem(key);
  40. }
  41. /**
  42. * @description 清除所有localStorage
  43. * @returns {void}
  44. */
  45. export function localClear() {
  46. window.localStorage.clear();
  47. }
  48. /**
  49. * @description 判断数据类型
  50. * @param {*} val 需要判断类型的数据
  51. * @returns {String}
  52. */
  53. export function isType(val: any) {
  54. if (val === null) return "null";
  55. if (typeof val !== "object") return typeof val;
  56. else return Object.prototype.toString.call(val).slice(8, -1).toLocaleLowerCase();
  57. }
  58. /**
  59. * @description 生成唯一 uuid
  60. * @returns {String}
  61. */
  62. export function generateUUID() {
  63. let uuid = "";
  64. for (let i = 0; i < 32; i++) {
  65. let random = (Math.random() * 16) | 0;
  66. if (i === 8 || i === 12 || i === 16 || i === 20) uuid += "-";
  67. uuid += (i === 12 ? 4 : i === 16 ? (random & 3) | 8 : random).toString(16);
  68. }
  69. return uuid;
  70. }
  71. /**
  72. * 判断两个对象是否相同
  73. * @param {Object} a 要比较的对象一
  74. * @param {Object} b 要比较的对象二
  75. * @returns {Boolean} 相同返回 true,反之 false
  76. */
  77. export function isObjectValueEqual(a: { [key: string]: any }, b: { [key: string]: any }) {
  78. if (!a || !b) return false;
  79. let aProps = Object.getOwnPropertyNames(a);
  80. let bProps = Object.getOwnPropertyNames(b);
  81. if (aProps.length != bProps.length) return false;
  82. for (let i = 0; i < aProps.length; i++) {
  83. let propName = aProps[i];
  84. let propA = a[propName];
  85. let propB = b[propName];
  86. if (!b.hasOwnProperty(propName)) return false;
  87. if (propA instanceof Object) {
  88. if (!isObjectValueEqual(propA, propB)) return false;
  89. } else if (propA !== propB) {
  90. return false;
  91. }
  92. }
  93. return true;
  94. }
  95. /**
  96. * @description 生成随机数
  97. * @param {Number} min 最小值
  98. * @param {Number} max 最大值
  99. * @returns {Number}
  100. */
  101. export function randomNum(min: number, max: number): number {
  102. let num = Math.floor(Math.random() * (min - max) + max);
  103. return num;
  104. }
  105. /**
  106. * @description 获取当前时间对应的提示语
  107. * @returns {String}
  108. */
  109. export function getTimeState(t: any) {
  110. // @ts-ignore
  111. let timeNow = new Date();
  112. let hours = timeNow.getHours();
  113. if (hours >= 6 && hours <= 10) return t("sys.greetings.morning") + ` ⛅`;
  114. if (hours >= 10 && hours <= 13) return t("sys.greetings.noon") + ` 🌞`;
  115. if (hours >= 13 && hours <= 18) return t("sys.greetings.afternoon") + ` 🌞`;
  116. if (hours >= 18 && hours <= 24) return t("sys.greetings.evening") + ` 🌛`;
  117. if (hours >= 0 && hours <= 6) return t("sys.greetings.deadOfNight") + ` 🌑`;
  118. }
  119. /**
  120. * @description 获取浏览器默认语言
  121. * @returns {String}
  122. */
  123. export function getBrowserLang() {
  124. let browserLang = navigator.language ? navigator.language : navigator.browserLanguage;
  125. console.log("getBrowserLang browserLang :>> ", browserLang);
  126. let defaultBrowserLang = "";
  127. if (["cn", "zh", "zh-cn"].includes(browserLang.toLowerCase())) {
  128. defaultBrowserLang = "zh-cn";
  129. } else {
  130. defaultBrowserLang = "en";
  131. }
  132. return defaultBrowserLang;
  133. }
  134. /**
  135. * @description 使用递归扁平化菜单,方便添加动态路由
  136. * @param {Array} menuList 菜单列表
  137. * @returns {Array}
  138. */
  139. export function getFlatMenuList(menuList: Menu.MenuOptions[]): Menu.MenuOptions[] {
  140. let newMenuList: Menu.MenuOptions[] = JSON.parse(JSON.stringify(menuList));
  141. // let newMenuList: Menu.MenuOptions[] = menuList;
  142. return newMenuList.flatMap(item => [item, ...(item.children ? getFlatMenuList(item.children) : [])]);
  143. }
  144. /**
  145. * @description 使用递归过滤出需要渲染在左侧菜单的列表 (需剔除 isHide == true 的菜单)
  146. * @param {Array} menuList 菜单列表
  147. * @returns {Array}
  148. * */
  149. export function getShowMenuList(menuList: Menu.MenuOptions[]) {
  150. const { CheckPower } = useAuthButtons(undefined);
  151. let newMenuList: Menu.MenuOptions[] = cloneDeep(menuList);
  152. return newMenuList.filter(item => {
  153. if (item.meta.funid && !CheckPower(item.meta.funid)) {
  154. return false;
  155. }
  156. // 父级节点隐藏,跳过,不需要再递归子级节点
  157. !item.meta?.isHide && item.children?.length && (item.children = getShowMenuList(item.children));
  158. // 过滤隐藏节点
  159. return !item.meta?.isHide;
  160. });
  161. }
  162. /**
  163. * @description 使用递归找出所有面包屑存储到 pinia/vuex 中
  164. * @param {Array} menuList 菜单列表
  165. * @param {Array} parent 父级菜单
  166. * @param {Object} result 处理后的结果
  167. * @returns {Object}
  168. */
  169. export const getAllBreadcrumbList = (menuList: Menu.MenuOptions[], parent = [], result: { [key: string]: any } = {}) => {
  170. for (const item of menuList) {
  171. result[item.path] = [...parent, item];
  172. if (item.children) getAllBreadcrumbList(item.children, result[item.path], result);
  173. }
  174. return result;
  175. };
  176. /**
  177. * @description 使用递归过滤出需要渲染在首页常用功能树 (需剔除 isHide == true 的菜单)
  178. * @param {Array} menuList 菜单列表
  179. * @returns {Array}
  180. * */
  181. export function getQuickEnterFuncTree(menuList: Menu.MenuOptions[]): any[] {
  182. class TreeNode {
  183. key: string;
  184. label: string;
  185. children: TreeNode[] | null;
  186. icon?: string;
  187. path?: string;
  188. disabled: boolean;
  189. constructor(key: string, label: string, hasChild?: boolean) {
  190. this.key = key;
  191. this.label = label;
  192. this.children = hasChild ? [] : null;
  193. }
  194. public get getIcon(): string | undefined {
  195. return this.icon;
  196. }
  197. public set setIcon(v: string) {
  198. this.icon = v;
  199. }
  200. public get getPath(): string | undefined {
  201. return this.path;
  202. }
  203. public set setPath(v: string) {
  204. this.path = v;
  205. }
  206. }
  207. const { userInfo } = useUserStore();
  208. const recursiveFunTree = (children: Menu.MenuOptions[]): TreeNode[] => {
  209. let treeArray: TreeNode[] = [];
  210. for (const menu of children) {
  211. if (menu.meta?.isHide) continue;
  212. let treeNode = new TreeNode(menu.name, menu.meta?.title, isNullOrUnDef(menu.children));
  213. if (isNullOrUnDef(menu.component)) treeNode.path = menu.path;
  214. if (isNullOrUnDef(menu.meta?.icon)) treeNode.icon = menu.meta?.icon;
  215. if (!isNullOrUnDef(menu.meta?.funid))
  216. treeNode.disabled = userInfo?.rsltFunids && !userInfo?.rsltFunids.includes(menu.meta?.funid);
  217. if (isNullOrUnDef(menu.children)) continue;
  218. treeArray.push(treeNode);
  219. // 递归子集
  220. treeNode.children = recursiveFunTree(menu.children);
  221. }
  222. return treeArray;
  223. };
  224. console.log("getQuickEnterFuncTree menuList :>> ", menuList);
  225. let functionTree = recursiveFunTree(menuList);
  226. return functionTree;
  227. }
  228. /**
  229. * @description 使用递归过滤出需要渲染在首页常用功能树路由 (需剔除 isHide == true 的菜单)
  230. * @param {Array} menuList 菜单列表
  231. * @returns {Array}
  232. * */
  233. export function getQuickEnterFuncTreeRouter(menuList: Menu.MenuOptions[]): Map<string, { [key: string]: any }> {
  234. console.log("getQuickEnterFuncTreeRouter menuList :>> ", menuList);
  235. class TreeNode {
  236. key: string;
  237. name: string;
  238. icon?: string;
  239. path: string;
  240. funid: number | string;
  241. constructor(key: string, label: string, path: string, icon?: string, funid?: number) {
  242. this.key = key;
  243. this.name = label;
  244. this.path = path;
  245. this.icon = icon || "";
  246. this.funid = funid ?? 0;
  247. }
  248. }
  249. const recursiveFunTree = (children: Menu.MenuOptions[]): Map<string, TreeNode> => {
  250. let routerMap: Map<string, TreeNode> = new Map();
  251. for (const menu of children) {
  252. // 跳过已隐藏的菜单 | 跳过不存在component的
  253. if (!(menu.meta?.isHide || isNullOrUnDef(menu.component))) {
  254. //
  255. let treeNode = new TreeNode(menu.name, menu.meta?.title, menu.path, menu.meta?.icon, menu.meta?.funid);
  256. routerMap.set(menu.name, treeNode);
  257. }
  258. if (isNullOrUnDef(menu.children)) continue;
  259. // 递归子集
  260. routerMap = new Map([...routerMap, ...recursiveFunTree(menu.children)]);
  261. }
  262. return routerMap;
  263. };
  264. let routerMap = recursiveFunTree(menuList);
  265. return routerMap;
  266. }
  267. /**
  268. * @description 使用递归处理路由菜单 path,生成一维数组 (第一版本地路由鉴权会用到,该函数暂未使用)
  269. * @param {Array} menuList 所有菜单列表
  270. * @param {Array} menuPathArr 菜单地址的一维数组 ['**','**']
  271. * @returns {Array}
  272. */
  273. export function getMenuListPath(menuList: Menu.MenuOptions[], menuPathArr: string[] = []): string[] {
  274. for (const item of menuList) {
  275. if (typeof item === "object" && item.path) menuPathArr.push(item.path);
  276. if (item.children?.length) getMenuListPath(item.children, menuPathArr);
  277. }
  278. return menuPathArr;
  279. }
  280. /**
  281. * @description 递归查询当前 path 所对应的菜单对象 (该函数暂未使用)
  282. * @param {Array} menuList 菜单列表
  283. * @param {String} path 当前访问地址
  284. * @returns {Object | null}
  285. */
  286. export function findMenuByPath(menuList: Menu.MenuOptions[], path: string): Menu.MenuOptions | null {
  287. for (const item of menuList) {
  288. if (item.path === path) return item;
  289. if (item.children) {
  290. const res = findMenuByPath(item.children, path);
  291. if (res) return res;
  292. }
  293. }
  294. return null;
  295. }
  296. /**
  297. * @description 使用递归过滤需要缓存的菜单 name (该函数暂未使用)
  298. * @param {Array} menuList 所有菜单列表
  299. * @param {Array} keepAliveNameArr 缓存的菜单 name ['**','**']
  300. * @returns {Array}
  301. * */
  302. export function getKeepAliveRouterName(menuList: Menu.MenuOptions[], keepAliveNameArr: string[] = []) {
  303. menuList.forEach(item => {
  304. item.meta.isKeepAlive && item.name && keepAliveNameArr.push(item.name);
  305. item.children?.length && getKeepAliveRouterName(item.children, keepAliveNameArr);
  306. });
  307. return keepAliveNameArr;
  308. }
  309. /**
  310. * @description 格式化表格单元格默认值 (el-table-column)
  311. * @param {Number} row 行
  312. * @param {Number} col 列
  313. * @param {*} callValue 当前单元格值
  314. * @returns {String}
  315. * */
  316. export function formatTableColumn(row: number, col: number, callValue: any) {
  317. // 如果当前值为数组,使用 / 拼接(根据需求自定义)
  318. if (isArray(callValue)) return callValue.length ? callValue.join(" / ") : "";
  319. return callValue ?? "";
  320. }
  321. /**
  322. * @description 处理值无数据情况
  323. * @param {*} callValue 需要处理的值
  324. * @returns {String}
  325. * */
  326. export function formatValue(callValue: any) {
  327. // 如果当前值为数组,使用 / 拼接(根据需求自定义)
  328. if (isArray(callValue)) return callValue.length ? callValue.join(" / ") : "";
  329. return callValue ?? "";
  330. }
  331. /**
  332. * @description 处理 prop 为多级嵌套的情况,返回的数据 (列如: prop: user.name)
  333. * @param {Object} row 当前行数据
  334. * @param {String} prop 当前 prop
  335. * @returns {*}
  336. * */
  337. export function handleRowAccordingToProp(row: { [key: string]: any }, prop: string, ...args: any) {
  338. if (args[0]) {
  339. return row[prop] && formatFn[args[0]] ? formatFn[args[0]]({ val: row[prop], format: args[0] }) : "";
  340. }
  341. if (!prop.includes(".")) return row[prop] ?? "";
  342. prop.split(".").forEach(item => (row = row[item] ?? ""));
  343. return row;
  344. }
  345. // 工具函数:解析 formatType
  346. export function parseFormatType(formatType: string) {
  347. const match = formatType.match(/^([a-zA-Z]+)(\d*)$/);
  348. return {
  349. fnName: match?.[1] || formatType,
  350. digits: match?.[2] ? parseInt(match[2], 10) : 2
  351. };
  352. }
  353. /**
  354. * @description 处理 prop,当 prop 为多级嵌套时 ==> 返回最后一级 prop
  355. * @param {String} prop 当前 prop
  356. * @returns {String}
  357. * */
  358. export function handleProp(prop: string) {
  359. const propArr = prop.split(".");
  360. if (propArr.length == 1) return prop;
  361. return propArr[propArr.length - 1];
  362. }
  363. /**
  364. * @description 根据枚举列表查询当需要的数据(如果指定了 label 和 value 的 key值,会自动识别格式化)
  365. * @param {String} callValue 当前单元格值
  366. * @param {Array} enumData 字典列表
  367. * @param {Array} fieldNames label && value && children 的 key 值
  368. * @param {String} type 过滤类型(目前只有 tag)
  369. * @returns {String}
  370. * */
  371. export function filterEnum(callValue: any, enumData?: any, fieldNames?: FieldNamesProps, type?: "tag") {
  372. const value = fieldNames?.value ?? "value";
  373. const label = fieldNames?.label ?? "label";
  374. const children = fieldNames?.children ?? "children";
  375. let filterData: { [key: string]: any } = {};
  376. // 判断 enumData 是否为数组
  377. if (Array.isArray(enumData)) filterData = findItemNested(enumData, callValue, value, children);
  378. // 判断是否输出的结果为 tag 类型
  379. if (type == "tag") {
  380. return filterData?.tagType ? filterData.tagType : "";
  381. } else {
  382. return filterData ? filterData[label] : "";
  383. }
  384. }
  385. /**
  386. * @description 递归查找 callValue 对应的 enum 值
  387. * */
  388. export function findItemNested(enumData: any, callValue: any, value: string, children: string) {
  389. return enumData.reduce((accumulator: any, current: any) => {
  390. if (accumulator) return accumulator;
  391. if (current[value] === callValue) return current;
  392. if (current[children]) return findItemNested(current[children], callValue, value, children);
  393. }, null);
  394. }
  395. // 日期格式化
  396. function formatDate({ val, format }: any) {
  397. return XEUtils.toDateString(val, format || "yyyy-MM-dd HH:mm:ss");
  398. }
  399. // 四舍五入金额,每隔3位逗号分隔,默认0位小数
  400. export function formatIntNumber({ val }: any, digits = 0) {
  401. if (isNaN(Number(val))) return val;
  402. return XEUtils.commafy(XEUtils.toNumber(val), { digits });
  403. }
  404. // 四舍五入金额,每隔3位逗号分隔,默认2位数
  405. export function formatAmount3({ val }: any, digits = 2) {
  406. if (isNaN(Number(val))) return val;
  407. return XEUtils.commafy(XEUtils.toNumber(val), { digits });
  408. }
  409. // 向下舍入,默认两位数
  410. export function formatCutNumber({ val }: any, digits = 2) {
  411. if (isNaN(Number(val))) return val;
  412. if (Number(val) == 0) return 0;
  413. return XEUtils.toFixed(XEUtils.floor(val, digits), digits);
  414. }
  415. // 向下舍入,默认两位数
  416. function formatCutNumber3({ val }: any, digits = 3) {
  417. if (isNaN(Number(val))) return val;
  418. return XEUtils.toFixed(XEUtils.floor(val, digits), digits);
  419. }
  420. // 四舍五入,默认两位数
  421. export function formatFixedNumber({ val }: any, digits = 2) {
  422. if (isNaN(Number(val))) return val;
  423. return XEUtils.toFixed(XEUtils.round(val, digits), digits);
  424. }
  425. // 百分比:四舍五入金额,每隔3位逗号分隔,默认2位
  426. function formatPercent({ val }: any, digits = 2) {
  427. if (isNaN(Number(val))) return val;
  428. return XEUtils.commafy(XEUtils.toNumber(val) * 100, { digits }) + "%";
  429. }
  430. /**
  431. * @description 格式化调用函数对照
  432. */
  433. const formatFn: any = {
  434. "yyyy-MM-dd": formatDate,
  435. "yyyy-MM-dd HH:mm:ss": formatDate,
  436. "yyyy-MM-dd HH:mm": formatDate,
  437. "MM/dd/yyyy": formatDate,
  438. "MM/dd": formatDate,
  439. "dd/MM/yyyy": formatDate,
  440. "yyyy/MM/dd": formatDate,
  441. intNumber: formatIntNumber,
  442. cutNumber: formatCutNumber,
  443. amountNumber: formatAmount3,
  444. fixedNumber: formatFixedNumber,
  445. cutNumber3: formatCutNumber3,
  446. percent: formatPercent
  447. };
  448. /**
  449. * 一维,精简对象储存属性;支持数组型默认数据(关键字:field)
  450. * 逻辑:精简出与默认数据不同的属性,保留layoutAttr包含的字段
  451. * @param {Object} column 列数据
  452. * @param {String[]} layoutAttr 需要保留的数据名称
  453. * @param {Object | Array} layoutDefine 数据默认值 {...} Or [{field: xxx, ...}, ...]
  454. * @returns {Array} 返回精简后的对象
  455. */
  456. export function streamlineFunc(column: any, layoutAttr: string[], layoutDefine: any) {
  457. let streamlinedColumns = [];
  458. if (Array.isArray(layoutDefine)) {
  459. for (let item of column) {
  460. const matchingDefinition = layoutDefine.find(itm => itm.field === item.field);
  461. const relevantAttrs = layoutAttr.filter(attr => {
  462. const itemValue = get(item, attr);
  463. const defineValue = get(matchingDefinition, attr);
  464. // 排除某些属性,并检查值是否不同
  465. return !["field", "table", "datatype"].includes(attr) && defineValue !== itemValue;
  466. });
  467. // 将 "field" 包含在过滤后的属性中
  468. const attrsToPick = [...relevantAttrs, "field"];
  469. streamlinedColumns.push(pick(item, attrsToPick));
  470. }
  471. } else {
  472. for (let item of column) {
  473. const relevantAttrs = layoutAttr.filter(attr => {
  474. // 检查值是否与布局定义不同
  475. return item[attr] !== layoutDefine[attr];
  476. });
  477. streamlinedColumns.push(pick(item, relevantAttrs));
  478. }
  479. }
  480. return streamlinedColumns;
  481. }
  482. /**
  483. * 一维,精简对象储存属性
  484. * @param {Object} column 列数据
  485. * @param {String[]} layoutAttr 需要保留的数据名称
  486. * @param {Object} layoutDefine 数据默认值
  487. * @param {String} attr 列数据的二级属性
  488. * @returns {Object} 返回精简后的对象
  489. */
  490. export function streamlineAttrFunc(column: any, layoutAttr: string[], layoutDefine: any, attr: string) {
  491. let _map = new Map();
  492. for (let item of column) {
  493. let saveProp = cloneDeep(layoutAttr);
  494. if (item.basicinfo) {
  495. for (let key in layoutDefine) {
  496. if (item[attr].hasOwnProperty(key) && layoutDefine[key] === item[attr][key]) {
  497. saveProp.splice(saveProp.indexOf(key), 1);
  498. }
  499. }
  500. _map.set(item.field, pick(item[attr], saveProp));
  501. }
  502. }
  503. return _map;
  504. }
  505. /**
  506. * 提取目标数据差异属性
  507. * @param {Object} oriLayout 原始对象,带默认值
  508. * @param {Object} targetLayout 目标对象,需要提取差异的数据
  509. * @param {String[]} attrs 需要保留字符串名称,规则:仅需提供最底层属性名称
  510. * @param {String} arrayAttr 数组数据,关键字段,用于排序
  511. * @returns {Object}
  512. */
  513. export function getDifference(oriLayout: any, targetLayout: any, attrs: string[] = [], arrayAttr = "id") {
  514. const diff: any = {};
  515. // 检查oriLayout中的属性
  516. for (const key in oriLayout) {
  517. if (oriLayout.hasOwnProperty(key)) {
  518. // 如果targetLayout中没有这个属性,则将它添加到差异中
  519. if (!targetLayout.hasOwnProperty(key)) {
  520. diff[key] = oriLayout[key];
  521. } else {
  522. // 如果targetLayout中也有这个属性,则比较它们的值
  523. if (Array.isArray(oriLayout[key])) {
  524. // 比较数组
  525. // 调整顺序,根据目标对象,调整原始对象数组顺序
  526. let _oriLayout = oriLayout[key];
  527. if (arrayAttr) {
  528. _oriLayout = oriLayout[key].slice().sort((a: any, b: any) => {
  529. let indexA = targetLayout[key].findIndex((item: any) => item[arrayAttr] === a[arrayAttr]);
  530. let indexB = targetLayout[key].findIndex((item: any) => item[arrayAttr] === b[arrayAttr]);
  531. return indexA - indexB;
  532. });
  533. }
  534. let arrAttr = [];
  535. for (const idx in _oriLayout) {
  536. console.log("oriLayout[key][idx] :>> ", _oriLayout[idx]);
  537. if (targetLayout[key][idx]) {
  538. const nestedDiff = getDifference(_oriLayout[idx], targetLayout[key][idx], attrs, arrayAttr);
  539. console.log(nestedDiff);
  540. if (Object.keys(nestedDiff).length > 0) {
  541. arrAttr.push(nestedDiff);
  542. }
  543. }
  544. }
  545. arrAttr.length && (diff[key] = arrAttr);
  546. } else if (typeof oriLayout[key] === "object" && typeof targetLayout[key] === "object") {
  547. // 递归比较对象
  548. console.log("key :>> ", key, oriLayout[key], targetLayout[key]);
  549. const nestedDiff = getDifference(oriLayout[key], targetLayout[key], attrs, arrayAttr);
  550. console.log("nestedDiff :>> ", key, nestedDiff);
  551. if (Object.keys(nestedDiff).length > 0) {
  552. console.log("nestedDiff :>> ", nestedDiff);
  553. diff[key] = nestedDiff;
  554. }
  555. } else if ((oriLayout[key] !== targetLayout[key] || key == arrayAttr) && attrs.includes(key)) {
  556. console.log("key :>> ", key);
  557. diff[key] = targetLayout[key];
  558. }
  559. }
  560. }
  561. }
  562. // 补充:检查targetLayout中的属性
  563. for (const key in targetLayout) {
  564. if (targetLayout.hasOwnProperty(key)) {
  565. // 如果oriLayout中没有这个属性,则将它添加到差异中
  566. if (
  567. !oriLayout.hasOwnProperty(key) ||
  568. (oriLayout.hasOwnProperty(key) && isObject(oriLayout[key]) && Object.keys(oriLayout[key]).length == 0)
  569. ) {
  570. diff[key] = targetLayout[key];
  571. }
  572. }
  573. }
  574. return diff;
  575. }
  576. /**
  577. * 读取数据到原始对象
  578. * @param {Object} oriLayout 原始对象,带默认值
  579. * @param {Object} targetLayout 差异的数据
  580. * @param {String} arrayAttr 数组数据,关键字段,用于排序
  581. * @returns {Object}
  582. */
  583. export function setDifference(oriLayout: any, loadLayout: any, arrayAttr: string = "id") {
  584. let _oriLayout = cloneDeep(oriLayout);
  585. for (const key in loadLayout) {
  586. if (loadLayout.hasOwnProperty(key)) {
  587. if (Array.isArray(loadLayout[key])) {
  588. // console.log("setDifference _oriLayout :>> ", _oriLayout);
  589. let _sortedObj1 = _oriLayout[key].slice().sort((a: any, b: any) => {
  590. let indexA = loadLayout[key].findIndex((item: any) => item[arrayAttr] === a[arrayAttr]);
  591. let indexB = loadLayout[key].findIndex((item: any) => item[arrayAttr] === b[arrayAttr]);
  592. if (indexA == -1 || indexB == -1) {
  593. return 0;
  594. } else {
  595. return indexA - indexB;
  596. }
  597. });
  598. // console.log("setDifference _sortedObj1 :>> ", _sortedObj1);
  599. // console.log("setDifference loadLayout[key] :>> ", loadLayout[key]);
  600. let arr = [];
  601. for (const idx in _sortedObj1) {
  602. // console.log("idx :>> ", idx);
  603. // console.log("loadLayout[key][idx] :>> ", loadLayout[key][idx]);
  604. // console.log("_sortedObj1[idx] :>> ", _sortedObj1[idx]);
  605. // if (loadLayout[key][idx] && _sortedObj1[idx] && loadLayout[key][idx][arrayAttr] == _sortedObj1[idx][arrayAttr]) {
  606. // arr.push(setDifference(_sortedObj1[idx], loadLayout[key][idx], arrayAttr));
  607. // }
  608. let itemIdx = loadLayout[key].findIndex((item: any) => item[arrayAttr] === _sortedObj1[idx][arrayAttr]);
  609. // console.log(itemIdx);
  610. let _loadLayout = itemIdx > -1 ? loadLayout[key][itemIdx] : {};
  611. arr.push(setDifference(_sortedObj1[idx], _loadLayout, arrayAttr));
  612. }
  613. // console.log("arr :>> ", arr);
  614. arr.length && (_oriLayout[key] = arr);
  615. } else if (typeof loadLayout[key] === "object") {
  616. if (!_oriLayout.hasOwnProperty(key)) {
  617. _oriLayout[key] = {};
  618. }
  619. _oriLayout[key] = setDifference(_oriLayout[key], loadLayout[key], arrayAttr);
  620. } else {
  621. _oriLayout[key] = loadLayout[key];
  622. }
  623. }
  624. }
  625. return _oriLayout;
  626. }
  627. /**
  628. * 金额缩略显示
  629. * @param s 数值
  630. * @param n 小数保留位数
  631. * @returns {string}
  632. */
  633. export function numberFormat(s: number, n: number) {
  634. n = n !== undefined && n >= 0 && n <= 20 ? n : 2;
  635. let sum = Math.abs(Number(s));
  636. let sumStr = parseFloat((sum + "").replace(/[^\d\.-]/g, "")).toFixed(n) + "";
  637. let r = n ? "." + sumStr.split(".")[1] : "";
  638. let l = sumStr.split(".")[0].split("").reverse();
  639. let t = "";
  640. for (let i = 0; i < l.length; i++) {
  641. t += l[i] + ((i + 1) % 3 == 0 && i + 1 != l.length ? "," : "");
  642. }
  643. if (s < 0) return "-" + t.split("").reverse().join("") + r;
  644. return t.split("").reverse().join("") + r;
  645. }
  646. export const noop = () => {};
  647. /**
  648. * 获取目标属性,转换字符串对象
  649. * @param obj 目标值
  650. * @param str 目标字符串属性
  651. */
  652. export function convertStrToObj(obj: any, str?: string): any {
  653. console.log("convertStrToObj obj :>> ", obj);
  654. console.log("convertStrToObj str :>> ", str);
  655. if (!obj || JSON.stringify(obj) == "{}" || !str) return undefined;
  656. const keys = str.split(".");
  657. for (let i = 0; i < keys.length; i++) {
  658. const key = keys[i];
  659. obj[key] = obj[key] || undefined;
  660. obj = obj[key];
  661. }
  662. return obj;
  663. }
  664. /**
  665. * 时间格式转义, detaTime to Diff
  666. * @param data {value:Object}
  667. * @returns {Object}
  668. */
  669. export const getDiffToDate = (data: any) => {
  670. const today = dayjs(dayjs().format("YYYY-MM-DD"));
  671. for (const key in data) {
  672. if (key.indexOf("date") > -1 && key.indexOf("datetype") == -1) {
  673. if (isNumber(data[key])) {
  674. // number => string
  675. data[key] = today.add(data[key], "day").format("YYYY-MM-DD HH:mm:ss");
  676. } else if (isArray(data[key])) {
  677. // [number, number] => [string, string]
  678. data[key] = data[key].map((item: any) => {
  679. if (isNumber(item)) {
  680. return today.add(item, "day").format("YYYY-MM-DD HH:mm:ss");
  681. } else {
  682. return item;
  683. }
  684. });
  685. }
  686. }
  687. }
  688. console.log("getDiffToDate data :>> ", data);
  689. return data;
  690. };
  691. /**
  692. * 时间格式转义, Diff to DetaTime
  693. * @param data {value:Object}
  694. * @returns
  695. */
  696. export const setDateToDiff = (data: any) => {
  697. const today = dayjs(dayjs().format("YYYY-MM-DD"));
  698. for (const key in data) {
  699. if (key.indexOf("date") > -1 && key.indexOf("datetype") == -1) {
  700. if (isString(data[key]) || isDate(data[key])) {
  701. // string => number
  702. let newDate = dayjs(dayjs(data[key]).format("YYYY-MM-DD"));
  703. data[key] = newDate.diff(today, "day");
  704. } else if (isArray(data[key])) {
  705. // [string, string] => [number, number]
  706. data[key] = data[key].map((item: any) => {
  707. let newDate = dayjs(dayjs(item).format("YYYY-MM-DD"));
  708. return newDate.diff(today, "day");
  709. });
  710. }
  711. }
  712. }
  713. console.log("_habit setDateToDiff data :>> ", data);
  714. return data;
  715. };
  716. /**
  717. * 捕捉报错提示
  718. * @param err 报错含有,关键字:会话、已与服务器失联、找不到网络路径
  719. * @returns {Boolean}
  720. */
  721. export const ifErrorToLogin = (err: any) => {
  722. // 移除"已与服务器失联"关键字,只有L1失联会出现,会导致核价需要重新登陆
  723. // return err.indexOf("会话") >= 0 || err.indexOf("已与服务器失联") >= 0 || err.indexOf("找不到网络路径") >= 0;
  724. return err.indexOf("会话") >= 0 || err.indexOf("找不到网络路径") >= 0;
  725. };
  726. /**
  727. * 遍历树形结构的数据
  728. * @param tree 遍历的树形结构数据
  729. * @param callback 回调函数,用于处理遍历到的每个节点
  730. */
  731. export const traverseNode = (root: any, action: (node: any) => void) => {
  732. const queue = [root];
  733. while (queue.length > 0) {
  734. const node = queue.shift();
  735. action(node);
  736. if (node.children && node.children.length > 0) {
  737. for (const child of node.children) {
  738. queue.push(child);
  739. }
  740. }
  741. }
  742. };
  743. /*用正则表达式实现html转码*/
  744. export const htmlEncodeByRegExp = (str: string) => {
  745. let s = "";
  746. if (str.length == 0) return "";
  747. s = str.replace(/&/g, "&amp;");
  748. s = s.replace(/</g, "&lt;");
  749. s = s.replace(/>/g, "&gt;");
  750. s = s.replace(/ /g, "&nbsp;");
  751. s = s.replace(/\'/g, "&#39;");
  752. s = s.replace(/\"/g, "&quot;");
  753. return s;
  754. };
  755. /*用正则表达式实现html解码*/
  756. export const htmlDecodeByRegExp = (str: string) => {
  757. let s = "";
  758. if (str.length == 0) return "";
  759. s = str.replace(/&amp;/g, "&");
  760. s = s.replace(/&lt;/g, "<");
  761. s = s.replace(/&gt;/g, ">");
  762. s = s.replace(/&nbsp;/g, " ");
  763. s = s.replace(/&#39;/g, "'");
  764. s = s.replace(/&quot;/g, '"');
  765. return s;
  766. };
  767. /**
  768. * @description 加法
  769. * @param {Number} arg1 数1
  770. * @param {Number} arg2 数2
  771. * @returns
  772. */
  773. export const floatAdd = (arg1: any, arg2: any) => {
  774. let r1, r2, m;
  775. try {
  776. r1 = arg1.toString().split(".")[1].length;
  777. } catch (e) {
  778. r1 = 0;
  779. }
  780. try {
  781. r2 = arg2.toString().split(".")[1].length;
  782. } catch (e) {
  783. r2 = 0;
  784. }
  785. m = Math.pow(10, Math.max(r1, r2));
  786. return (Math.round(arg1 * m) + Math.round(arg2 * m)) / m;
  787. };
  788. export const floatAddMore = (arr: any) => {
  789. let r1,
  790. r2,
  791. m,
  792. sum = 0;
  793. for (const item of arr) {
  794. if (item == undefined || item == null) continue;
  795. r1 = sum.toString().split(".")[1]?.length ?? 0;
  796. r2 = item.toString().split(".")[1]?.length ?? 0;
  797. m = Math.pow(10, Math.max(r1, r2));
  798. sum = (Math.round(sum * m) + Math.round(item * m)) / m;
  799. }
  800. return sum;
  801. };
  802. /**
  803. * @description 减法
  804. * @param arg1
  805. * @param arg2
  806. * @returns
  807. */
  808. export const floatSub = (arg1: any, arg2: any) => {
  809. let r1, r2, m, n;
  810. try {
  811. r1 = arg1.toString().split(".")[1].length;
  812. } catch (e) {
  813. r1 = 0;
  814. }
  815. try {
  816. r2 = arg2.toString().split(".")[1].length;
  817. } catch (e) {
  818. r2 = 0;
  819. }
  820. m = Math.pow(10, Math.max(r1, r2));
  821. //动态控制精度长度
  822. n = r1 >= r2 ? r1 : r2;
  823. return ((Math.round(arg1 * m) - Math.round(arg2 * m)) / m).toFixed(n);
  824. };
  825. /**
  826. * @description 乘法
  827. * @param arg1
  828. * @param arg2
  829. * @returns
  830. */
  831. export const floatMul = (arg1: any, arg2: any) => {
  832. let m = 0,
  833. s1 = (arg1 ?? 0).toString(),
  834. s2 = (arg2 ?? 0).toString();
  835. try {
  836. m += s1.split(".")[1].length;
  837. } catch (e) {}
  838. try {
  839. m += s2.split(".")[1].length;
  840. } catch (e) {}
  841. return (Number(s1.replace(".", "")) * Number(s2.replace(".", ""))) / Math.pow(10, m);
  842. };
  843. export const floatMulMore = (arr: any) => {
  844. let m = 0,
  845. sum = 1;
  846. for (const item of arr) {
  847. if (item) {
  848. let s1 = item.toString();
  849. try {
  850. m += s1.split(".")[1].length;
  851. } catch (e) {}
  852. sum = sum * Number(s1.replace(".", ""));
  853. }
  854. }
  855. return Number(sum) / Math.pow(10, m);
  856. };
  857. /**
  858. * @description 除法
  859. * @param arg1
  860. * @param arg2
  861. * @returns
  862. */
  863. export const floatDiv = (arg1: any, arg2: any) => {
  864. let t1 = 0,
  865. t2 = 0,
  866. r1,
  867. r2;
  868. try {
  869. t1 = arg1.toString().split(".")[1].length;
  870. } catch (e) {}
  871. try {
  872. t2 = arg2.toString().split(".")[1].length;
  873. } catch (e) {}
  874. r1 = Number(arg1.toString().replace(".", ""));
  875. r2 = Number(arg2.toString().replace(".", ""));
  876. return (r1 / r2) * Math.pow(10, t2 - t1);
  877. };
  878. /**
  879. * @description 文件类型转化base64类型
  880. * @param type 文件类型
  881. * @returns base64类型
  882. */
  883. export const getBase64Type = (type: string) => {
  884. switch (type.toLowerCase()) {
  885. case "txt":
  886. return "data:text/plain;base64,";
  887. case "doc":
  888. return "data:application/msword;base64,";
  889. case "docx":
  890. return "data:application/vnd.openxmlformats-officedocument.wordprocessingml.document;base64,";
  891. case "xls":
  892. return "data:application/vnd.ms-excel;base64,";
  893. case "xlsx":
  894. return "data:application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;base64,";
  895. case "pdf":
  896. return "data:application/pdf;base64,";
  897. case "pptx":
  898. return "data:application/vnd.openxmlformats-officedocument.presentationml.presentation;base64,";
  899. case "ppt":
  900. return "data:application/vnd.ms-powerpoint;base64,";
  901. case "png":
  902. return "data:image/png;base64,";
  903. case "jpg":
  904. return "data:image/jpeg;base64,";
  905. case "gif":
  906. return "data:image/gif;base64,";
  907. case "svg":
  908. return "data:image/svg+xml;base64,";
  909. case "ico":
  910. return "data:image/x-icon;base64,";
  911. case "bmp":
  912. return "data:image/bmp;base64,";
  913. default:
  914. return "";
  915. }
  916. };
  917. /**
  918. * @description 自定义函数检查className中是否包含需要的类名
  919. */
  920. export const classNameIncludes = (element: any, target: string[]) => {
  921. if (!element) return false;
  922. let _className: string[] = [];
  923. let parent = element.parentElement;
  924. // 获取当前元素的类名
  925. if (typeof element.className === "string") {
  926. _className = element.className.split(/\s+/g);
  927. }
  928. // 如果父元素存在,则获取父元素的类名
  929. while (parent) {
  930. if (parent.classList) {
  931. // 获取当前父元素的所有类名并添加到数组中
  932. Array.from(parent.classList).forEach((className: any) => {
  933. if (!_className.includes(className)) {
  934. _className.push(className);
  935. }
  936. });
  937. }
  938. // 移动到下一个父元素
  939. parent = parent.parentElement;
  940. }
  941. return target.some(item => _className.indexOf(item) > -1);
  942. };
  943. /**
  944. * @description 倒计时
  945. * @param {number} value 剩余秒数
  946. * @returns {string} 倒计时 00:00:30,
  947. */
  948. export const countDownTime = (value: number) => {
  949. // 处理数字类型的秒数
  950. if (value <= 0) {
  951. return "";
  952. }
  953. const days = Math.floor(value / 86400);
  954. const hours = Math.floor((value % 86400) / 3600)
  955. .toString()
  956. .padStart(2, "0");
  957. const minutes = Math.floor((value % 3600) / 60)
  958. .toString()
  959. .padStart(2, "0");
  960. const seconds = (value % 60).toString().padStart(2, "0");
  961. let text = "";
  962. if (days > 365) {
  963. text = `${Math.floor(days / 365)}年`;
  964. } else if (days > 31) {
  965. text = `${Math.floor(days / 31)}月`;
  966. } else if (days > 0) {
  967. text = `${days}天`;
  968. } else {
  969. text = `${hours}:${minutes}:${seconds}`;
  970. }
  971. return text;
  972. };
  973. const parseTime = (time: any, cFormat?: string) => {
  974. let format = cFormat ?? `{y}-{m}-{d} {h}:{i}:{s}`;
  975. let date;
  976. if (typeof time === "object") {
  977. date = time;
  978. } else {
  979. if (typeof time === "string") {
  980. if (/^[0-9]+$/.test(time)) {
  981. time = parseInt(time);
  982. } else {
  983. time = time.replace(new RegExp(/-/gm), "/");
  984. }
  985. }
  986. if (typeof time === "number" && time.toString().length === 10) {
  987. time = time * 1000;
  988. }
  989. date = new Date(time);
  990. }
  991. const formatObj: any = {
  992. y: date.getFullYear(),
  993. m: date.getMonth() + 1,
  994. d: date.getDate(),
  995. h: date.getHours(),
  996. i: date.getMinutes(),
  997. s: date.getSeconds(),
  998. a: date.getDay()
  999. };
  1000. const time_str = format.replace(/{([ymdhisa])+}/g, (result, key) => {
  1001. const value = formatObj[key];
  1002. // Note: getDay() returns 0 on Sunday
  1003. if (key === "a") {
  1004. return ["日", "一", "二", "三", "四", "五", "六"][value];
  1005. }
  1006. return value.toString().padStart(2, "0");
  1007. });
  1008. return time_str;
  1009. };
  1010. /**
  1011. * 最近时间-时差
  1012. * @param {number} time
  1013. * @param {string} option
  1014. * @returns {Number} (秒)
  1015. */
  1016. export const formatTime = function (time: string | number, option: string, ifshort: boolean, nowtime?: string) {
  1017. const _time = new Date(time);
  1018. const d = new Date(time);
  1019. const now = nowtime ? new Date(nowtime) : new Date();
  1020. const diff = (now.getTime() - d.getTime()) / 1000;
  1021. if (ifshort) {
  1022. if (diff < 0) {
  1023. // flutter
  1024. } else if (diff < 30) {
  1025. return "刚刚";
  1026. } else if (diff < 3600) {
  1027. // less 1 hour
  1028. return Math.ceil(diff / 60) + "分钟前";
  1029. } else if (diff < 3600 * 6) {
  1030. // 1~6小时
  1031. return Math.ceil(diff / 3600) + "小时前";
  1032. }
  1033. let hourMins = parseTime(_time, "{h}:{i}:{s}");
  1034. let isSameDay = now.setHours(0, 0, 0, 0) - d.setHours(0, 0, 0, 0);
  1035. switch (isSameDay) {
  1036. case 0:
  1037. return `今天 ${hourMins}`;
  1038. case 86400000:
  1039. return `昨天 ${hourMins}`;
  1040. // case 172800000:
  1041. // return `前天 ${hourMins}`
  1042. }
  1043. if (now.getFullYear() == d.getFullYear()) {
  1044. return parseTime(_time, "{m}-{d} {h}:{i}:{s}");
  1045. } else {
  1046. return parseTime(_time, "{y}-{m}-{d} {h}:{i}:{s}");
  1047. }
  1048. }
  1049. if (option) {
  1050. return parseTime(_time, option);
  1051. }
  1052. };
  1053. const funcGetFormulaValue = (item, tgList, fieldList, valueList) => {
  1054. let _paras = item?.formula
  1055. .replace(/【/g, "[")
  1056. .replace(/】/g, "]")
  1057. .match(/\[([^\]]*)\]/g);
  1058. let resultFormula = item?.formula.replace(/【/g, "[").replace(/】/g, "]");
  1059. _paras.forEach(part => {
  1060. // console.log(part);
  1061. let fieldName = part.slice(1, -1); // 去掉方括号
  1062. // console.log(fieldName);
  1063. let sumVal = tgList.find(f => {
  1064. if (f.field === fieldName) {
  1065. return f;
  1066. } else if (f.label === fieldName) {
  1067. fieldName = f.field;
  1068. return f;
  1069. }
  1070. });
  1071. !sumVal &&
  1072. (sumVal = fieldList.find(f => {
  1073. if (f.field === fieldName) {
  1074. return f;
  1075. } else if (f.label === fieldName) {
  1076. fieldName = f.field;
  1077. return f;
  1078. }
  1079. }));
  1080. if (sumVal) {
  1081. let res = valueList[fieldName];
  1082. let _formula;
  1083. if (sumVal?.formula) {
  1084. _formula = sumVal.formula.replace(part, `${valueList[fieldName]}`);
  1085. }
  1086. // console.log(fieldName, _formula, sumVal);
  1087. if (_formula && _formula.indexOf("[") > -1) {
  1088. let _res = formulaPartsFormula([{ formula: _formula }], fieldList, valueList, tgList);
  1089. res = `(${_res[0]})`;
  1090. }
  1091. if (typeof res === "undefined") {
  1092. ElMessage.warning("接口未提供数据,请检查:" + fieldName);
  1093. console.error("接口未提供数据,请检查:" + fieldName);
  1094. return;
  1095. }
  1096. resultFormula = resultFormula.replace(part, res);
  1097. } else {
  1098. valueList[fieldName] && (resultFormula = resultFormula.replace(part, `${valueList[fieldName]}`));
  1099. }
  1100. });
  1101. return resultFormula;
  1102. };
  1103. export const formulaPartsFormula = (formulaList, fieldList, valueList, tgList = formulaList) => {
  1104. let result = [];
  1105. formulaList.map((item, index) => {
  1106. if (item?.formula) {
  1107. let res = funcGetFormulaValue(item, tgList, fieldList, valueList);
  1108. result.push(res);
  1109. }
  1110. });
  1111. return result;
  1112. };
  1113. /**
  1114. * @description 公式计算
  1115. * @param formulaList 公式列表 [{field: 'a', formula: '[b] + [c]'}]
  1116. * @param fieldList 字段列表 [{field: 'a', label: '字段A'}, {field: 'a', formula: '[b] + [c]'}]
  1117. * @param valueList 值列表 {a: 1, b: 2, c: 3}
  1118. * @returns {number[]} 计算结果 [1]
  1119. */
  1120. export const calculateFormula = async (formulaList, fieldList, valueList) => {
  1121. let resultFormula: any[] = formulaPartsFormula(formulaList, fieldList, valueList);
  1122. console.log("resultFormula: ", resultFormula);
  1123. try {
  1124. let res = await GetFormulaCompute({
  1125. formulas: resultFormula
  1126. });
  1127. if (res.values.length == 0) return [];
  1128. let result = formulaList.map((item, index) => {
  1129. let _res = res.values[index] ?? 0;
  1130. return {
  1131. ...item,
  1132. value: _res
  1133. };
  1134. });
  1135. return result;
  1136. } catch (error) {
  1137. console.error("Formula evaluation error:", error);
  1138. return [];
  1139. }
  1140. };
  1141. /**
  1142. * @description LjVxeTable获取当前表格选中数据;默认第一条记录
  1143. * @param targetRef 表格ref
  1144. * @returns {$table, curRecords} 当前表格对象,当前选中数据
  1145. */
  1146. export const getCurrentRecords = (targetRef: any) => {
  1147. const $table = targetRef.element;
  1148. const _records = $table.getCheckboxRecords() ?? [];
  1149. const _cRecords = $table.getCurrentRecord() ?? null;
  1150. let curRecords = [];
  1151. if ($table) {
  1152. if (_records.length) {
  1153. // 获取勾选列表
  1154. curRecords = _records;
  1155. } else if (_cRecords) {
  1156. // 获取当前选中数据
  1157. curRecords = [_cRecords];
  1158. } else {
  1159. // 默认获取第一条记录
  1160. let fullData = $table.getTableData().fullData;
  1161. if (fullData.length) {
  1162. curRecords = [fullData[0]];
  1163. $table.setCurrentRow(fullData[0]);
  1164. }
  1165. }
  1166. }
  1167. return { $table, curRecords };
  1168. };
  1169. export const transformTreeData = (data: any) => {
  1170. return data?.map(node => ({
  1171. ...node.data,
  1172. children: node.children ? transformTreeData(node.children) : []
  1173. }));
  1174. };
  1175. /**
  1176. * @description 过滤掉末尾的0
  1177. * @param data
  1178. * @returns
  1179. */
  1180. export const isFilterPrice = (data, digits?: number) => {
  1181. if (data == null || data == undefined) {
  1182. return "0";
  1183. }
  1184. let _digits = digits ?? 2;
  1185. let val = formatAmount3({ val: data }, _digits);
  1186. // 过滤掉末尾的0
  1187. let arr = val.split("");
  1188. while (arr[arr.length - 1] === "0") {
  1189. arr.pop();
  1190. }
  1191. return arr.join("");
  1192. };
  1193. /**
  1194. * @description 计算vxetable的合并单元格
  1195. * @param $table 表对象
  1196. * @param fields 计算合并的字段明
  1197. * @returns 需要合并的单元格数组
  1198. */
  1199. export const autoMergeCells = ($table: any, fields: string[]) => {
  1200. let result: any = [];
  1201. let columns = $table.getColumns();
  1202. let { visibleData: data } = $table.getTableData();
  1203. // console.log("mergeCells data :>> ", columns, data);
  1204. data.map((item: any, rowIndex: number) => {
  1205. for (const key in item) {
  1206. if (fields.includes(key)) {
  1207. let rowspan = 1;
  1208. let currentVal = "";
  1209. let lastVal = "";
  1210. let colIndex = 0;
  1211. colIndex = columns.findIndex((item: any) => item.field == key);
  1212. currentVal = item[key];
  1213. if (rowIndex - 1 >= 0) {
  1214. lastVal = data[rowIndex - 1][key];
  1215. }
  1216. // console.log("lastVal currentVal:>> ", colIndex, key, lastVal, currentVal);
  1217. // if (rowIndex > 0) {
  1218. // if (!lastVal) {
  1219. if (lastVal != currentVal) {
  1220. // 计算合并行数
  1221. let _span = 0;
  1222. for (let i = rowIndex + 1; i < data.length; i++) {
  1223. if (data[i][key] && currentVal && data[i][key] == currentVal) {
  1224. _span++;
  1225. } else {
  1226. break;
  1227. }
  1228. }
  1229. rowspan += _span;
  1230. } else {
  1231. rowspan = 0;
  1232. }
  1233. // console.log("rowspan :>> ", key, lastVal, currentVal, rowspan);
  1234. // }
  1235. // }
  1236. if (rowspan > 0) {
  1237. result.push({
  1238. row: rowIndex,
  1239. col: colIndex,
  1240. rowspan: rowspan,
  1241. colspan: 1
  1242. });
  1243. }
  1244. }
  1245. }
  1246. });
  1247. return result;
  1248. };
  1249. export const text2Formula = (str: any) => {
  1250. let rt = [];
  1251. if (str.includes("以上") || str.includes("以下")) {
  1252. // 匹配 "上下拼接X及以上Y以下"
  1253. let rangeMatch = str.match(/(\d+)及以下/);
  1254. if (rangeMatch) {
  1255. const value = parseInt(rangeMatch[1], 10);
  1256. rt.push(`value <= ${value}`);
  1257. } else {
  1258. rangeMatch = str.match(/(\d+)以下/);
  1259. if (rangeMatch) {
  1260. const value = parseInt(rangeMatch[1], 10);
  1261. rt.push(`value < ${value}`);
  1262. }
  1263. }
  1264. rangeMatch = str.match(/(\d+)及以上/);
  1265. if (rangeMatch) {
  1266. const value = parseInt(rangeMatch[1], 10);
  1267. rt.push(`value >= ${value}`);
  1268. } else {
  1269. rangeMatch = str.match(/(\d+)以上/);
  1270. if (rangeMatch) {
  1271. const value = parseInt(rangeMatch[1], 10);
  1272. rt.push(`value > ${value}`);
  1273. }
  1274. }
  1275. } else {
  1276. // 匹配 "上下拼接X"
  1277. const exactMatch = str.match(/(\d+)/);
  1278. if (exactMatch) {
  1279. const value = parseInt(exactMatch[1], 10);
  1280. rt.push(`value == ${value}`);
  1281. }
  1282. }
  1283. if (rt.length > 0) {
  1284. return rt.join(" && ");
  1285. }
  1286. throw new Error(`无法解析规则: ${str}`);
  1287. };
  1288. /**
  1289. * @description 事件: 一键复制
  1290. */
  1291. export const copyFunc = (data: any) => {
  1292. const input = document.createElement("textarea");
  1293. input.value = data;
  1294. document.body.appendChild(input);
  1295. input.select();
  1296. document.execCommand("Copy");
  1297. document.body.removeChild(input);
  1298. ElMessage({
  1299. type: "success",
  1300. message: "复制成功"
  1301. });
  1302. };