index.ts 43 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409
  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. return err.indexOf("会话") >= 0 || err.indexOf("已与服务器失联") >= 0 || err.indexOf("找不到网络路径") >= 0;
  723. };
  724. /**
  725. * 遍历树形结构的数据
  726. * @param tree 遍历的树形结构数据
  727. * @param callback 回调函数,用于处理遍历到的每个节点
  728. */
  729. export const traverseNode = (root: any, action: (node: any) => void) => {
  730. const queue = [root];
  731. while (queue.length > 0) {
  732. const node = queue.shift();
  733. action(node);
  734. if (node.children && node.children.length > 0) {
  735. for (const child of node.children) {
  736. queue.push(child);
  737. }
  738. }
  739. }
  740. };
  741. /*用正则表达式实现html转码*/
  742. export const htmlEncodeByRegExp = (str: string) => {
  743. let s = "";
  744. if (str.length == 0) return "";
  745. s = str.replace(/&/g, "&amp;");
  746. s = s.replace(/</g, "&lt;");
  747. s = s.replace(/>/g, "&gt;");
  748. s = s.replace(/ /g, "&nbsp;");
  749. s = s.replace(/\'/g, "&#39;");
  750. s = s.replace(/\"/g, "&quot;");
  751. return s;
  752. };
  753. /*用正则表达式实现html解码*/
  754. export const htmlDecodeByRegExp = (str: string) => {
  755. let s = "";
  756. if (str.length == 0) return "";
  757. s = str.replace(/&amp;/g, "&");
  758. s = s.replace(/&lt;/g, "<");
  759. s = s.replace(/&gt;/g, ">");
  760. s = s.replace(/&nbsp;/g, " ");
  761. s = s.replace(/&#39;/g, "'");
  762. s = s.replace(/&quot;/g, '"');
  763. return s;
  764. };
  765. /**
  766. * @description 加法
  767. * @param {Number} arg1 数1
  768. * @param {Number} arg2 数2
  769. * @returns
  770. */
  771. export const floatAdd = (arg1: any, arg2: any) => {
  772. let r1, r2, m;
  773. try {
  774. r1 = arg1.toString().split(".")[1].length;
  775. } catch (e) {
  776. r1 = 0;
  777. }
  778. try {
  779. r2 = arg2.toString().split(".")[1].length;
  780. } catch (e) {
  781. r2 = 0;
  782. }
  783. m = Math.pow(10, Math.max(r1, r2));
  784. return (Math.round(arg1 * m) + Math.round(arg2 * m)) / m;
  785. };
  786. export const floatAddMore = (arr: any) => {
  787. let r1,
  788. r2,
  789. m,
  790. sum = 0;
  791. for (const item of arr) {
  792. if (item == undefined || item == null) continue;
  793. r1 = sum.toString().split(".")[1]?.length ?? 0;
  794. r2 = item.toString().split(".")[1]?.length ?? 0;
  795. m = Math.pow(10, Math.max(r1, r2));
  796. sum = (Math.round(sum * m) + Math.round(item * m)) / m;
  797. }
  798. return sum;
  799. };
  800. /**
  801. * @description 减法
  802. * @param arg1
  803. * @param arg2
  804. * @returns
  805. */
  806. export const floatSub = (arg1: any, arg2: any) => {
  807. let r1, r2, m, n;
  808. try {
  809. r1 = arg1.toString().split(".")[1].length;
  810. } catch (e) {
  811. r1 = 0;
  812. }
  813. try {
  814. r2 = arg2.toString().split(".")[1].length;
  815. } catch (e) {
  816. r2 = 0;
  817. }
  818. m = Math.pow(10, Math.max(r1, r2));
  819. //动态控制精度长度
  820. n = r1 >= r2 ? r1 : r2;
  821. return ((Math.round(arg1 * m) - Math.round(arg2 * m)) / m).toFixed(n);
  822. };
  823. /**
  824. * @description 乘法
  825. * @param arg1
  826. * @param arg2
  827. * @returns
  828. */
  829. export const floatMul = (arg1: any, arg2: any) => {
  830. let m = 0,
  831. s1 = (arg1 ?? 0).toString(),
  832. s2 = (arg2 ?? 0).toString();
  833. try {
  834. m += s1.split(".")[1].length;
  835. } catch (e) {}
  836. try {
  837. m += s2.split(".")[1].length;
  838. } catch (e) {}
  839. return (Number(s1.replace(".", "")) * Number(s2.replace(".", ""))) / Math.pow(10, m);
  840. };
  841. export const floatMulMore = (arr: any) => {
  842. let m = 0,
  843. sum = 1;
  844. for (const item of arr) {
  845. if (item) {
  846. let s1 = item.toString();
  847. try {
  848. m += s1.split(".")[1].length;
  849. } catch (e) {}
  850. sum = sum * Number(s1.replace(".", ""));
  851. }
  852. }
  853. return Number(sum) / Math.pow(10, m);
  854. };
  855. /**
  856. * @description 除法
  857. * @param arg1
  858. * @param arg2
  859. * @returns
  860. */
  861. export const floatDiv = (arg1: any, arg2: any) => {
  862. let t1 = 0,
  863. t2 = 0,
  864. r1,
  865. r2;
  866. try {
  867. t1 = arg1.toString().split(".")[1].length;
  868. } catch (e) {}
  869. try {
  870. t2 = arg2.toString().split(".")[1].length;
  871. } catch (e) {}
  872. r1 = Number(arg1.toString().replace(".", ""));
  873. r2 = Number(arg2.toString().replace(".", ""));
  874. return (r1 / r2) * Math.pow(10, t2 - t1);
  875. };
  876. /**
  877. * @description 文件类型转化base64类型
  878. * @param type 文件类型
  879. * @returns base64类型
  880. */
  881. export const getBase64Type = (type: string) => {
  882. switch (type.toLowerCase()) {
  883. case "txt":
  884. return "data:text/plain;base64,";
  885. case "doc":
  886. return "data:application/msword;base64,";
  887. case "docx":
  888. return "data:application/vnd.openxmlformats-officedocument.wordprocessingml.document;base64,";
  889. case "xls":
  890. return "data:application/vnd.ms-excel;base64,";
  891. case "xlsx":
  892. return "data:application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;base64,";
  893. case "pdf":
  894. return "data:application/pdf;base64,";
  895. case "pptx":
  896. return "data:application/vnd.openxmlformats-officedocument.presentationml.presentation;base64,";
  897. case "ppt":
  898. return "data:application/vnd.ms-powerpoint;base64,";
  899. case "png":
  900. return "data:image/png;base64,";
  901. case "jpg":
  902. return "data:image/jpeg;base64,";
  903. case "gif":
  904. return "data:image/gif;base64,";
  905. case "svg":
  906. return "data:image/svg+xml;base64,";
  907. case "ico":
  908. return "data:image/x-icon;base64,";
  909. case "bmp":
  910. return "data:image/bmp;base64,";
  911. default:
  912. return "";
  913. }
  914. };
  915. /**
  916. * @description 自定义函数检查className中是否包含需要的类名
  917. */
  918. export const classNameIncludes = (element: any, target: string[]) => {
  919. if (!element) return false;
  920. let _className: string[] = [];
  921. let parent = element.parentElement;
  922. // 获取当前元素的类名
  923. if (typeof element.className === "string") {
  924. _className = element.className.split(/\s+/g);
  925. }
  926. // 如果父元素存在,则获取父元素的类名
  927. while (parent) {
  928. if (parent.classList) {
  929. // 获取当前父元素的所有类名并添加到数组中
  930. Array.from(parent.classList).forEach((className: any) => {
  931. if (!_className.includes(className)) {
  932. _className.push(className);
  933. }
  934. });
  935. }
  936. // 移动到下一个父元素
  937. parent = parent.parentElement;
  938. }
  939. return target.some(item => _className.indexOf(item) > -1);
  940. };
  941. /**
  942. * @description 倒计时
  943. * @param {number} value 剩余秒数
  944. * @returns {string} 倒计时 00:00:30,
  945. */
  946. export const countDownTime = (value: number) => {
  947. // 处理数字类型的秒数
  948. if (value <= 0) {
  949. return "";
  950. }
  951. const days = Math.floor(value / 86400);
  952. const hours = Math.floor((value % 86400) / 3600)
  953. .toString()
  954. .padStart(2, "0");
  955. const minutes = Math.floor((value % 3600) / 60)
  956. .toString()
  957. .padStart(2, "0");
  958. const seconds = (value % 60).toString().padStart(2, "0");
  959. let text = "";
  960. if (days > 365) {
  961. text = `${Math.floor(days / 365)}年`;
  962. } else if (days > 31) {
  963. text = `${Math.floor(days / 31)}月`;
  964. } else if (days > 0) {
  965. text = `${days}天`;
  966. } else {
  967. text = `${hours}:${minutes}:${seconds}`;
  968. }
  969. return text;
  970. };
  971. const parseTime = (time: any, cFormat?: string) => {
  972. let format = cFormat ?? `{y}-{m}-{d} {h}:{i}:{s}`;
  973. let date;
  974. if (typeof time === "object") {
  975. date = time;
  976. } else {
  977. if (typeof time === "string") {
  978. if (/^[0-9]+$/.test(time)) {
  979. time = parseInt(time);
  980. } else {
  981. time = time.replace(new RegExp(/-/gm), "/");
  982. }
  983. }
  984. if (typeof time === "number" && time.toString().length === 10) {
  985. time = time * 1000;
  986. }
  987. date = new Date(time);
  988. }
  989. const formatObj: any = {
  990. y: date.getFullYear(),
  991. m: date.getMonth() + 1,
  992. d: date.getDate(),
  993. h: date.getHours(),
  994. i: date.getMinutes(),
  995. s: date.getSeconds(),
  996. a: date.getDay()
  997. };
  998. const time_str = format.replace(/{([ymdhisa])+}/g, (result, key) => {
  999. const value = formatObj[key];
  1000. // Note: getDay() returns 0 on Sunday
  1001. if (key === "a") {
  1002. return ["日", "一", "二", "三", "四", "五", "六"][value];
  1003. }
  1004. return value.toString().padStart(2, "0");
  1005. });
  1006. return time_str;
  1007. };
  1008. /**
  1009. * 最近时间-时差
  1010. * @param {number} time
  1011. * @param {string} option
  1012. * @returns {Number} (秒)
  1013. */
  1014. export const formatTime = function (time: string | number, option: string, ifshort: boolean, nowtime?: string) {
  1015. const _time = new Date(time);
  1016. const d = new Date(time);
  1017. const now = nowtime ? new Date(nowtime) : new Date();
  1018. const diff = (now.getTime() - d.getTime()) / 1000;
  1019. if (ifshort) {
  1020. if (diff < 0) {
  1021. // flutter
  1022. } else if (diff < 30) {
  1023. return "刚刚";
  1024. } else if (diff < 3600) {
  1025. // less 1 hour
  1026. return Math.ceil(diff / 60) + "分钟前";
  1027. } else if (diff < 3600 * 6) {
  1028. // 1~6小时
  1029. return Math.ceil(diff / 3600) + "小时前";
  1030. }
  1031. let hourMins = parseTime(_time, "{h}:{i}:{s}");
  1032. let isSameDay = now.setHours(0, 0, 0, 0) - d.setHours(0, 0, 0, 0);
  1033. switch (isSameDay) {
  1034. case 0:
  1035. return `今天 ${hourMins}`;
  1036. case 86400000:
  1037. return `昨天 ${hourMins}`;
  1038. // case 172800000:
  1039. // return `前天 ${hourMins}`
  1040. }
  1041. if (now.getFullYear() == d.getFullYear()) {
  1042. return parseTime(_time, "{m}-{d} {h}:{i}:{s}");
  1043. } else {
  1044. return parseTime(_time, "{y}-{m}-{d} {h}:{i}:{s}");
  1045. }
  1046. }
  1047. if (option) {
  1048. return parseTime(_time, option);
  1049. }
  1050. };
  1051. const funcGetFormulaValue = (item, tgList, fieldList, valueList) => {
  1052. let _paras = item?.formula
  1053. .replace(/【/g, "[")
  1054. .replace(/】/g, "]")
  1055. .match(/\[([^\]]*)\]/g);
  1056. let resultFormula = item?.formula.replace(/【/g, "[").replace(/】/g, "]");
  1057. _paras.forEach(part => {
  1058. // console.log(part);
  1059. let fieldName = part.slice(1, -1); // 去掉方括号
  1060. // console.log(fieldName);
  1061. let sumVal = tgList.find(f => {
  1062. if (f.field === fieldName) {
  1063. return f;
  1064. } else if (f.label === fieldName) {
  1065. fieldName = f.field;
  1066. return f;
  1067. }
  1068. });
  1069. !sumVal &&
  1070. (sumVal = fieldList.find(f => {
  1071. if (f.field === fieldName) {
  1072. return f;
  1073. } else if (f.label === fieldName) {
  1074. fieldName = f.field;
  1075. return f;
  1076. }
  1077. }));
  1078. if (sumVal) {
  1079. let res = valueList[fieldName];
  1080. let _formula;
  1081. if (sumVal?.formula) {
  1082. _formula = sumVal.formula.replace(part, `${valueList[fieldName]}`);
  1083. }
  1084. // console.log(fieldName, _formula, sumVal);
  1085. if (_formula && _formula.indexOf("[") > -1) {
  1086. let _res = formulaPartsFormula([{ formula: _formula }], fieldList, valueList, tgList);
  1087. res = `(${_res[0]})`;
  1088. }
  1089. if (typeof res === "undefined") {
  1090. ElMessage.warning("接口未提供数据,请检查:" + fieldName);
  1091. console.error("接口未提供数据,请检查:" + fieldName);
  1092. return;
  1093. }
  1094. resultFormula = resultFormula.replace(part, res);
  1095. } else {
  1096. valueList[fieldName] && (resultFormula = resultFormula.replace(part, `${valueList[fieldName]}`));
  1097. }
  1098. });
  1099. return resultFormula;
  1100. };
  1101. export const formulaPartsFormula = (formulaList, fieldList, valueList, tgList = formulaList) => {
  1102. let result = [];
  1103. formulaList.map((item, index) => {
  1104. if (item?.formula) {
  1105. let res = funcGetFormulaValue(item, tgList, fieldList, valueList);
  1106. result.push(res);
  1107. }
  1108. });
  1109. return result;
  1110. };
  1111. /**
  1112. * @description 公式计算
  1113. * @param formulaList 公式列表 [{field: 'a', formula: '[b] + [c]'}]
  1114. * @param fieldList 字段列表 [{field: 'a', label: '字段A'}, {field: 'a', formula: '[b] + [c]'}]
  1115. * @param valueList 值列表 {a: 1, b: 2, c: 3}
  1116. * @returns {number[]} 计算结果 [1]
  1117. */
  1118. export const calculateFormula = async (formulaList, fieldList, valueList) => {
  1119. let resultFormula: any[] = formulaPartsFormula(formulaList, fieldList, valueList);
  1120. console.log("resultFormula: ", resultFormula);
  1121. try {
  1122. let res = await GetFormulaCompute({
  1123. formulas: resultFormula
  1124. });
  1125. if (res.values.length == 0) return [];
  1126. let result = formulaList.map((item, index) => {
  1127. let _res = res.values[index] ?? 0;
  1128. return {
  1129. ...item,
  1130. value: _res
  1131. };
  1132. });
  1133. return result;
  1134. } catch (error) {
  1135. console.error("Formula evaluation error:", error);
  1136. return [];
  1137. }
  1138. };
  1139. /**
  1140. * @description LjVxeTable获取当前表格选中数据;默认第一条记录
  1141. * @param targetRef 表格ref
  1142. * @returns {$table, curRecords} 当前表格对象,当前选中数据
  1143. */
  1144. export const getCurrentRecords = (targetRef: any) => {
  1145. const $table = targetRef.element;
  1146. const _records = $table.getCheckboxRecords() ?? [];
  1147. const _cRecords = $table.getCurrentRecord() ?? null;
  1148. let curRecords = [];
  1149. if ($table) {
  1150. if (_records.length) {
  1151. // 获取勾选列表
  1152. curRecords = _records;
  1153. } else if (_cRecords) {
  1154. // 获取当前选中数据
  1155. curRecords = [_cRecords];
  1156. } else {
  1157. // 默认获取第一条记录
  1158. let fullData = $table.getTableData().fullData;
  1159. if (fullData.length) {
  1160. curRecords = [fullData[0]];
  1161. $table.setCurrentRow(fullData[0]);
  1162. }
  1163. }
  1164. }
  1165. return { $table, curRecords };
  1166. };
  1167. export const transformTreeData = (data: any) => {
  1168. return data?.map(node => ({
  1169. ...node.data,
  1170. children: node.children ? transformTreeData(node.children) : []
  1171. }));
  1172. };
  1173. /**
  1174. * @description 过滤掉末尾的0
  1175. * @param data
  1176. * @returns
  1177. */
  1178. export const isFilterPrice = (data, digits?: number) => {
  1179. if (data == null || data == undefined) {
  1180. return "0";
  1181. }
  1182. let _digits = digits ?? 2;
  1183. let val = formatAmount3({ val: data }, _digits);
  1184. // 过滤掉末尾的0
  1185. let arr = val.split("");
  1186. while (arr[arr.length - 1] === "0") {
  1187. arr.pop();
  1188. }
  1189. return arr.join("");
  1190. };
  1191. /**
  1192. * @description 计算vxetable的合并单元格
  1193. * @param $table 表对象
  1194. * @param fields 计算合并的字段明
  1195. * @returns 需要合并的单元格数组
  1196. */
  1197. export const autoMergeCells = ($table: any, fields: string[]) => {
  1198. let result: any = [];
  1199. let columns = $table.getColumns();
  1200. let { visibleData: data } = $table.getTableData();
  1201. // console.log("mergeCells data :>> ", columns, data);
  1202. data.map((item: any, rowIndex: number) => {
  1203. for (const key in item) {
  1204. if (fields.includes(key)) {
  1205. let rowspan = 1;
  1206. let currentVal = "";
  1207. let lastVal = "";
  1208. let colIndex = 0;
  1209. colIndex = columns.findIndex((item: any) => item.field == key);
  1210. currentVal = item[key];
  1211. if (rowIndex - 1 >= 0) {
  1212. lastVal = data[rowIndex - 1][key];
  1213. }
  1214. // console.log("lastVal currentVal:>> ", colIndex, key, lastVal, currentVal);
  1215. // if (rowIndex > 0) {
  1216. // if (!lastVal) {
  1217. if (lastVal != currentVal) {
  1218. // 计算合并行数
  1219. let _span = 0;
  1220. for (let i = rowIndex + 1; i < data.length; i++) {
  1221. if (data[i][key] && currentVal && data[i][key] == currentVal) {
  1222. _span++;
  1223. } else {
  1224. break;
  1225. }
  1226. }
  1227. rowspan += _span;
  1228. } else {
  1229. rowspan = 0;
  1230. }
  1231. // console.log("rowspan :>> ", key, lastVal, currentVal, rowspan);
  1232. // }
  1233. // }
  1234. if (rowspan > 0) {
  1235. result.push({
  1236. row: rowIndex,
  1237. col: colIndex,
  1238. rowspan: rowspan,
  1239. colspan: 1
  1240. });
  1241. }
  1242. }
  1243. }
  1244. });
  1245. return result;
  1246. };
  1247. export const text2Formula = (str: any) => {
  1248. let rt = [];
  1249. if (str.includes("以上") || str.includes("以下")) {
  1250. // 匹配 "上下拼接X及以上Y以下"
  1251. let rangeMatch = str.match(/(\d+)及以下/);
  1252. if (rangeMatch) {
  1253. const value = parseInt(rangeMatch[1], 10);
  1254. rt.push(`value <= ${value}`);
  1255. } else {
  1256. rangeMatch = str.match(/(\d+)以下/);
  1257. if (rangeMatch) {
  1258. const value = parseInt(rangeMatch[1], 10);
  1259. rt.push(`value < ${value}`);
  1260. }
  1261. }
  1262. rangeMatch = str.match(/(\d+)及以上/);
  1263. if (rangeMatch) {
  1264. const value = parseInt(rangeMatch[1], 10);
  1265. rt.push(`value >= ${value}`);
  1266. } else {
  1267. rangeMatch = str.match(/(\d+)以上/);
  1268. if (rangeMatch) {
  1269. const value = parseInt(rangeMatch[1], 10);
  1270. rt.push(`value > ${value}`);
  1271. }
  1272. }
  1273. } else {
  1274. // 匹配 "上下拼接X"
  1275. const exactMatch = str.match(/(\d+)/);
  1276. if (exactMatch) {
  1277. const value = parseInt(exactMatch[1], 10);
  1278. rt.push(`value == ${value}`);
  1279. }
  1280. }
  1281. if (rt.length > 0) {
  1282. return rt.join(" && ");
  1283. }
  1284. throw new Error(`无法解析规则: ${str}`);
  1285. };
  1286. /**
  1287. * @description 事件: 一键复制
  1288. */
  1289. export const copyFunc = (data: any) => {
  1290. const input = document.createElement("textarea");
  1291. input.value = data;
  1292. document.body.appendChild(input);
  1293. input.select();
  1294. document.execCommand("Copy");
  1295. document.body.removeChild(input);
  1296. ElMessage({
  1297. type: "success",
  1298. message: "复制成功"
  1299. });
  1300. };