logExcelTmpQueryList14Excel模板配置主页面查询nulllatestpubliclogsExcelTmpQueryListjdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster0410.1.80.882883rmcdbqian_jweiqian_jwei2024-10-22 22:08:27:8092024-10-22 22:08:27:8091_publicExcelTmpQueryList14001 select u1.tmpcode,u1.tmpname ,u3.nounname typname,u1.tmptype,u1.rowrange,u1.columnrange from rmc_imput_tmpconf_baseinfo u1 inner JOIN sys_noun u3 on u3.nounitem ='tmptype' AND u3.nounvalue =u1.tmptype where 1=1 AND u1.tmpcode like concat('%',#{tmpcode},'%') AND u1.tmpname like concat('%',#{tmpname},'%') AND u1.tmptype in ( ${tmptype} ) ]]>logsExcelTmpQueryList2Excel补录模板配置主页面查询latestpublicrdpExcelTmpQueryListjdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster04jdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster04adminadmin2024-10-08 10:07:06:9982024-10-08 10:07:06:9981_publiclogExcelTmpQueryList14ExcelTmpQueryList290ExcelTmpQueryList2ExcelTmpQueryList01RstSetExcelTmpQueryList]]>logseab_enterPI_del2Excel补录模板配置主页面删除逻辑latestpublic_PUBLIC_PUBLICjdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster04jdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster04adminadmin2024-09-22 18:35:39:0642024-09-22 18:35:39:0641_publiceab_enterPI_del290eab_enterPI_del2eab_enterPI_del01RstSeteab_enterPI_deleab_enterPI_del2eab_enterPI_del211RstSeteab_enterPI_del2]]>rdpExcelTmpOneEditSelect2Excel模板配置新增页面与修改页面nulllatestpublicrdpeab_enter_personalInfo10.1.80.882883rmcdb10.1.80.882883rmcdbadminadmin2024-11-01 17:42:56:5522024-11-01 17:42:56:55219anamode解析模式1新增（add）、查询（query）、修改（modify）模式tmpcode模板编号1模板编号ExcelTmpOneEditSelect2nullmaintainExcelTmpOneEdit1{&n; utilJs.closeWin(true);&n;}&n;&n;&n;customJs.current.saveBeforeFun=(datas)=>{&n; var tmpcode=datas.detailTable0.tmpcode;&n; var rowfw=datas.detailTable0.rowrange;&n; var colfw=datas.detailTable0.columnrange;&n; var tmptype=datas.detailTable0.tmptype;&n;&n; const regex = /[\u4e00-\u9fff]+/g;&n;var flag=true;&n;if(regex.test(tmpcode)){&n; baseFun.warning('模板编号不能含有中文');&n; flag=false;&n;}&n;if(!flag){&n; return false;&n;}&n;const reg = /^\d+-\d+$/;&n;if(tmptype == 'FixedAll' || tmptype == 'FixedRow') {&n;if(!reg.test(rowfw)){&n; baseFun.warning('行范围内容不符合规范');&n; flag=false;&n;}&n;if(!flag){&n; return false;&n;}&n;}&n;if(tmptype == 'FixedAll' || tmptype == 'FixedCol') {&n;if(!reg.test(colfw)){&n; baseFun.warning('列范围内容不符合规范');&n; flag=false;&n;}&n;if(!flag){&n; return false;&n;}&n;}&n;&n; //判断列表中的行范围、列范围是否符合规范&n; //遍历集合获取预算类型&n; var msg='';&n; var midrow='';&n; var midcol='';&n; var seq=1;&n; let vals=(datas.multiTable0).values(); &n; for(let val of vals){&n;console.log('val.filedrowrange'+val.filedrowrange);&n;console.log('val.filedrowrange'+val.filedrowrange == '' || val.filedrowrange == undefined);&n;console.log('val.filedrowrange'+val.filedrowrange == undefined);&n;console.log('val.filedrowrange'+val.filedrowrange == '' );&n; if(!(val.filedrowrange == '' || val.filedrowrange == undefined) && !reg.test(val.filedrowrange)){&n; midrow='第【'+seq+'】行的行范围内容不符合规范！';&n; msg=msg+midrow+'\n';&n; flag=false;&n; midrow='';&n; } &n; if(!(val.filedcolumnrange == '' || val.filedcolumnrange == undefined) && !reg.test(val.filedcolumnrange)){&n; midcol+='第【'+seq+'】行的列范围内容不符合规范！';&n; msg=msg+midcol+'\n';&n; flag=false;&n; midcol='';&n; }&n; console.log('msg:',msg); &n; seq++; &n; }&n; if(!flag){&n; baseFun.warning(msg);&n; }&n;&n; return flag;&n;}@]@]@>>0logs]]>rdpExcelTmpQueryList25Excel补录模板配置主界面功能nulllatestpublic_PUBLIC_PUBLICjdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster0410.1.80.882883rmcdbadminadmin2024-12-09 15:50:58:8582024-12-09 15:50:58:8581111_publicbusinesstypeid流程类型编号1流程类型编号logsExcelTmpQueryList2logseab_enterPI_del2rdpExcelTmpOneEditSelect2ExcelTmpQueryList25nullqueryExcelTmpQueryList1>0logs]]>