customTable.js 8.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263
  1. // 字母列标
  2. export function getColumnHeaderCode(len) {
  3. let tag_arr = [];
  4. for(let i=0;i<len;i++) tag_arr.push(String.fromCharCode(65+i));
  5. return tag_arr;
  6. }
  7. // 行标
  8. export function getRowHeaderCode(len) {
  9. let tag_arr = [];
  10. for(let i=0;i<len;i++) tag_arr.push(String(1+i));
  11. return tag_arr;
  12. }
  13. //过滤输入空格
  14. export function filterInput(input) {
  15. return input.replace(/\s+/g, '');
  16. }
  17. //从公式中提取因数
  18. export function extractFactorsFromFormula(str) {
  19. let pattern = /[A-Za-z]+\d+/g;
  20. let factors = str.match(pattern);
  21. // 提取括号内的内容作为因数
  22. let parenthesesPattern = /\([^()]+\)/g; // 匹配括号内的内容
  23. let parenthesesMatches = str.match(parenthesesPattern);
  24. if (parenthesesMatches) {
  25. for (let i = 0; i < parenthesesMatches.length; i++) {
  26. let parenthesesContent = parenthesesMatches[i].slice(1, -1); // 去除括号
  27. let subFactors = extractFactorsFromFormula(parenthesesContent);
  28. factors = factors.concat(subFactors);
  29. }
  30. }
  31. return factors.filter ((value, index, self) => self.indexOf(value) === index);
  32. }
  33. //根据因数找元素值
  34. export function findCellByFactor (str) {
  35. let newStr = splitString(toUpperCase(str));
  36. let table = document.querySelector('.table');
  37. let el = table.querySelector("td span[data-rindex='" + newStr[1] + "'][data-cindex='" + newStr[0] + "']") || table.querySelector("td input[data-rindex='" + newStr[1] + "'][data-cindex='" + newStr[0] + "']");
  38. return el ? (el.innerText||el.value||'') : null;
  39. }
  40. //转大写
  41. export function toUpperCase(str) {
  42. let uppercaseStr = str.toUpperCase();
  43. return uppercaseStr;
  44. }
  45. //拆分A1为['A','1']
  46. export function splitString(str) {
  47. let letter = str.match(/[A-Z]+/)[0];
  48. let number = str.match(/\d+/)[0];
  49. return [letter, number];
  50. }
  51. //选中整行整列样式
  52. export function selectMoreCellStyle(e,type=null) {
  53. let table = document.querySelector('.table');
  54. resetStyle();
  55. if($(e.target).hasClass('th-col')) { //点击列
  56. // 指标列 日期列显示显示有所区分
  57. const columnIndex = Array.from(e.target.parentNode.children).indexOf(e.target);
  58. table.rows.forEach((cell,index)=> {
  59. if(index !==0) {
  60. if(type === 1) index === 2 ? $(cell.children[columnIndex-1]).addClass('td-col-select') : $(cell.children[columnIndex]).addClass('td-col-select');
  61. if(type === 2) index === 1 ? $(cell.children[columnIndex-1]).addClass('td-col-select') : $(cell.children[columnIndex]).addClass('td-col-select');
  62. if(!type) $(cell.children[columnIndex]).addClass('td-col-select');
  63. }
  64. })
  65. }else if($(e.target).hasClass('th-row')) { //点击行
  66. e.target.parentNode.children.forEach((cell,index)=> {
  67. if(index !==0) {
  68. index === 2 ? $(cell).addClass('td-row-select') : $(cell).addClass('td-row-select');
  69. }
  70. })
  71. }
  72. }
  73. // 选中格子样式
  74. export function selectCellStyle(e) {
  75. let table = document.querySelector('.table');
  76. resetStyle();
  77. if (table.querySelectorAll(".td-chose").length == 0) {
  78. e.target.nodeName==='TD' && $(e.target).addClass("td-chose")
  79. e.target.parentNode.nodeName==='TD' && $(e.target.parentNode).addClass("td-chose")
  80. e.target.parentNode.parentNode.nodeName==='TD' && $(e.target.parentNode.parentNode).addClass("td-chose")
  81. e.target.parentNode.parentNode.parentNode.nodeName==='TD' && $(e.target.parentNode.parentNode.parentNode).addClass("td-chose")
  82. }
  83. }
  84. export function resetStyle() {
  85. let table = document.querySelector('.table');
  86. table.querySelectorAll(".td-chose").forEach(el => {
  87. el.classList.remove('td-chose')
  88. })
  89. table.querySelectorAll(".td-col-select").forEach(el => {
  90. el.classList.remove('td-col-select')
  91. })
  92. table.querySelectorAll(".td-row-select").forEach(el => {
  93. el.classList.remove('td-row-select')
  94. })
  95. table.querySelectorAll(".td-relation").forEach(el => {
  96. el.classList.remove('td-relation')
  97. })
  98. }
  99. //单击聚焦
  100. export function setFocus(e) {
  101. if(e.target.nodeName==='TD') {
  102. let input = e.target.querySelector('input');
  103. input && input.focus();
  104. }
  105. }
  106. // 插入值或公式有插值后设置背景色
  107. export function setCellBg(e) {
  108. e.target.parentNode.nodeName==='TD' && $(e.target.parentNode).addClass("insert")
  109. e.target.parentNode.parentNode.nodeName==='TD' && $(e.target.parentNode.parentNode).addClass("insert")
  110. }
  111. //右键菜单
  112. export function getRightClickMenu(pos,canEdit=false) {
  113. let cellMenu = [
  114. { label: "根据表格中日期选择指标值", key: "choose-target" },
  115. // { label: "插入指标值", key: "insert-value" },
  116. { label: "导入系统日期", key: "insert-sys-date" },
  117. { label: "导入指标日期", key: "insert-edb-date" },
  118. { label: "指标计算",
  119. key: "insert-edb-calculate",
  120. children: [
  121. { label: '累计值转月/季值',source: 1,fromEdbKey:5 },
  122. { label: '同比值',source: 3,fromEdbKey:6 },
  123. { label: '同差值',source: 4,fromEdbKey:7 },
  124. { label: 'N数值移动平均计算',source: 5,fromEdbKey:8 },
  125. { label: 'N数值环比值',source: 6,fromEdbKey:12 },
  126. { label: 'N数值环差值',source: 7,fromEdbKey:13 },
  127. { label: '升频',source: 8,fromEdbKey:14 },
  128. { label: '时间移位',source: 10,fromEdbKey:22 },
  129. { label: '超季节性',source: 11,fromEdbKey:35 },
  130. { label: '年化',source: 12,fromEdbKey:52 },
  131. { label: '降频',source: 9,fromEdbKey:51 },
  132. { label: '累计值',source: 13,fromEdbKey:62 },
  133. { label: '指数修匀',source: 15,fromEdbKey:'alpha' },
  134. { label: '日均值',source: 16,fromEdbKey:75 },
  135. ]
  136. },
  137. { label: "清空", key: "reset" },
  138. ]
  139. const menuMap = {
  140. 'col': [
  141. { label: "向左插入列", key: "insert-col-left" },
  142. { label: "向右插入列", key: "insert-col-right" },
  143. { label: "删除", key: "del" },
  144. ],
  145. 'row': [
  146. { label: "向上插入行", key: "insert-row-up" },
  147. { label: "向下插入行", key: "insert-row-down" },
  148. { label: "删除", key: "del" },
  149. ],
  150. 'cell': canEdit
  151. ? [{ label: '编辑',key: 'cell-edit' },...cellMenu]
  152. : cellMenu
  153. }
  154. return menuMap[pos];
  155. }
  156. //日期格式识别转换
  157. export function checkDateFormat(str) {
  158. const dateRegex = /^(?:(?:19|20)\d\d)([-/.])(0?[1-9]|1[0-2])\1(0?[1-9]|[12][0-9]|3[01])$/;
  159. //也支持年-月
  160. const dateMonthRegex = /^(?:(?:19|20)\d\d)([-])(0[1-9]|1[0-2])$/;
  161. if(dateRegex.test(str)) {
  162. const date = new Date(str);
  163. if (!isNaN(date.getTime())) {
  164. const year = date.getFullYear();
  165. const month = String(date.getMonth() + 1).padStart(2, '0');
  166. const day = String(date.getDate()).padStart(2, '0');
  167. return `${year}-${month}-${day}`;
  168. } else {
  169. return false;
  170. }
  171. } else if(dateMonthRegex.test(str)){
  172. return str
  173. } else {
  174. return false
  175. }
  176. }
  177. /* 根据key找到格子 设置格子样式 */
  178. export function setRelationStyle(query,classname="td-relation") {
  179. const { key } = query;
  180. let table = document.querySelector('.table');
  181. let el = table.querySelector("td[data-key='" + key + "']");
  182. el.nodeName==='TD' && $(el).addClass(classname)
  183. }
  184. //根据cell key找到cell数据
  185. export function findCellByKey(arr,key) {
  186. let cell = null;
  187. for (let i = arr.length - 1; i >= 0; i--) {
  188. if(!cell) {
  189. for(let j = arr[i].length-1;j>=0;j--) {
  190. if(arr[i][j].Uid===key) {
  191. cell = arr[i][j];
  192. break
  193. }
  194. }
  195. }
  196. }
  197. // console.log(cell)
  198. return cell
  199. }
  200. /* 清空插入单元格重置关联样式 */
  201. export function resetRelationStyle() {
  202. let table = document.querySelector('.table');
  203. table.querySelectorAll(".td-relation").forEach(el => {
  204. el.classList.remove('td-relation')
  205. })
  206. }
  207. /* 重置右键选择指标时的单元格标识样式 弹窗消失样式就消失 */
  208. export function resetDialogCellStyle() {
  209. let table = document.querySelector('.table');
  210. table.querySelectorAll(".td-choose-insert-target").forEach(el => {
  211. el.classList.remove('td-choose-insert-target')
  212. })
  213. }
  214. // 根据行头列头位置找key
  215. export function findCellKeyByFactor(str) {
  216. let newStr = splitString(toUpperCase(str));
  217. let table = document.querySelector('.table');
  218. let el = table.querySelector("td [data-rindex='" + newStr[1] + "'][data-cindex='" + newStr[0] + "']");
  219. return el ? (el.dataset.key||'') : null;
  220. }