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]]>logsExcelTmpOneEditSaveUpdata1Excel补录模板配置补录新增修改逻辑组latestpublicrdpExcelTmpOneEditUpdate10.1.80.882883rmcdb10.1.80.882883rmcdbqian_jweiqian_jwei2024-10-20 11:43:23:7182024-10-20 11:43:23:7181_publicExcelTmpOneEditSaveUpdata190ExcelTmpOneEditSaveUpdata1ExcelTmpOneEditSave01RstSetExcelTmpOneEditSaveExcelTmpOneEditSaveUpdata1ExcelTmpOneEditSave111RstSetExcelTmpOneEditSave1ExcelTmpOneEditSaveUpdata1ExcelTmpOneEditSave221RstSetExcelTmpOneEditSave2]]>rdpExcelTmpOneEditUpdate16Excel模板配置新增页面与修改页面nulllatestpublicrdpeab_enter_personalInfo10.1.80.882883rmcdb10.1.80.882883rmcdbadminadmin2024-11-04 16:54:00:7472024-11-04 16:54:00:74719anamode解析模式1新增（add）、查询（query）、修改（modify）模式tmpcode模板编号1模板编号logsExcelTmpOneEditSaveUpdata1ExcelTmpOneEditUpdate16nullmaintainExcelTmpOneEdit1{&n; utilJs.closeWin(true);&n;}&n;&n;&n;customJs.current.saveBeforeFun=(datas)=>{&n; var rowfw=datas.detailTable0.rowrange;&n; var colfw =datas.detailTable0.columnrange;&n;var tmptype=datas.detailTable0.tmptype;&n; const regex = /^\d+-\d+$/;&n;var flag=true;&n;if(tmptype == 'FixedAll' || tmptype == 'FixedRow') {&n;if(!regex.test(rowfw)){&n; baseFun.warning('行范围内容不符合规范');&n; flag=false;&n;}&n;if(!flag){&n; return false;&n;}&n;}&n;&n;if(tmptype == 'FixedAll' || tmptype == 'FixedCol') {&n;if(!regex.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; if(!(val.filedrowrange == '' || val.filedrowrange == undefined) && !regex.test(val.filedrowrange)){&n; midrow='第【'+seq+'】行的行范围内容不符合规范！';&n; msg=msg+midrow+'\n';&n; flag=false;&n; midrow='';&n; } &n; if(!(val.filedcolumnrange == '' || val.filedcolumnrange == undefined) && !regex.test(val.filedcolumnrange)){&n; midcol+='第【'+seq+'】行的列范围内容不符合规范！';&n; msg=msg+midcol+'\n';&n; flag=false;&n; midcol='';&n; } &n; seq++; &n; }&n; if(!flag){&n; baseFun.warning(msg);&n; }&n; return flag;&n;}@]@]@>>0logs]]>logExcelTmpOneEdit23Excel补录模板配置维护基本信息查询nulllatestpubliclogseab_enterPI_insert_selectjdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster0410.1.80.882883rmcdbadminadmin2024-10-08 19:47:51:4432024-10-08 19:47:51:4431_publicExcelTmpOneEdit23001 select u1.tmpcode,u1.tmpname ,u3.nounname, u1.tmptype,u1.rowrange,u1.columnrange,tmpfilename,tmpfilecode 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= #{tmpcode} ]]>logExcelTmpOneEdit17Excel补录模板配置维护明细信息nulllatestpublic_PUBLIC_PUBLICjdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster0410.1.80.882883rmcdbadminadmin2024-10-10 18:00:54:7482024-10-10 18:00:54:7481_publicExcelTmpOneEdit17001 select u1.tmpcode,u1.tmpfieldcode,u1.rowcoltype,u1.filedrowrange,u1.filedcolumnrange,u1.filedcoltype,u1.remark from rmc_imput_tmpconf_fielddetails u1 inner JOIN sys_noun u3 on u3.nounitem ='rowcoltype' AND u3.nounvalue =u1.rowcoltype where 1=1 AND u1.tmpcode = #{tmpcode} ]]>logsExcelTmpOneEdit2Excel补录模板配置维护页面逻辑latestpublicrdpExcelTmpOneEditjdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster04jdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster04adminadmin2024-09-19 09:22:27:7392024-09-19 09:22:27:739111_publiclogExcelTmpOneEdit23logExcelTmpOneEdit17ExcelTmpOneEdit290ExcelTmpOneEdit2ExcelTmpOneEdit01RstSetExcelTmpOneEditExcelTmpOneEdit2ExcelTmpOneEdit111RstSetExcelTmpOneEdit1]]>rdpExcelTmpOneEdit113Excel模板配置新增页面与修改页面nulllatestpublicrdpeab_enter_personalInfo10.1.80.882883rmcdb10.1.80.1572883rdcdbadminadmin2024-12-11 13:54:42:0142024-12-11 13:54:42:0141_publicanamode解析模式1新增（add）、查询（query）、修改（modify）模式tmpcode模板编号1模板编号logsExcelTmpOneEdit2ExcelTmpOneEdit113nullmaintainExcelTmpOneEdit1{&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; var tmptype=datas.detailTable0.tmptype;&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;let rowcon = 0;&n;const reg = /^\d+-\d+$/;&n;if(tmptype == 'FixedAll' || tmptype == 'FixedRow') {&n;if(!reg.test(rowfw)){&n; baseFun.warning('行范围内容不符合规范');&n; flag=false;&n;} else {&n;rowcon = rowfw.indexOf("-"); &n;}&n;if(!flag){&n; return false;&n;}&n;}&n;console.log('行中:'+rowcon);&n;let colcon = 0;&n;if(tmptype == 'FixedAll' || tmptype == 'FixedCol') {&n;if(!reg.test(colfw)){&n; baseFun.warning('列范围内容不符合规范');&n; flag=false;&n;} else {&n;colcon = colfw.indexOf("-"); &n;}&n;if(!flag){&n; return false;&n;}&n;}&n; let rowstart = 0;&n;let rowend = 0;&n;if (rowcon != 0) {&n;rowstart = rowfw.substring(0, rowcon);&n;rowend = rowfw.substring(rowcon + 1); &n;}&n; let colstart = 0;&n;let colend = 0;&n;if (colcon != 0) {&n;colstart = colfw.substring(0, colcon );&n;colend = colfw.substring(colcon + 1); &n;}&n;&n;console.log('行前:'+rowstart);&n;console.log('行后:'+rowend);&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.tmpfieldcode'+val.tmpfieldcode);//行范围&n; console.log("列范围"+'val.filedcolumnrange'+val.filedcolumnrange);//列范围&n;console.log(1+'val.filedrowrange'+val.filedrowrange);&n;console.log(2+'val.filedrowrange'+val.filedrowrange == '' || val.filedrowrange == undefined);&n;console.log(3+'val.filedrowrange'+val.filedrowrange == undefined);&n;console.log(4+'val.filedrowrange'+val.filedrowrange == '' );&n;if(!(val.filedrowrange == '' || val.filedrowrange == undefined)) { &n;if(!reg.test(val.filedrowrange)){&n; midrow='第【'+seq+'】行的行范围内容不符合规范！';&n; msg=msg+midrow+'\n';&n; flag=false;&n; midrow='';&n; } else {&n; let rowfwcon = val.filedrowrange.indexOf("-"); //行范围&n; let rowfwstart = val.filedrowrange.substring(0, rowfwcon);&n; let rowfwend = val.filedrowrange.substring(rowfwcon + 1); &n;console.log('rowfwstart:'+rowfwstart);&n;console.log('rowfwend:'+rowfwend);&n;console.log('行前大小:'+rowfwstart < rowstart);&n;console.log('行后大小:'+parseInt(rowfwend) > parseInt(rowend));&n; if(parseInt(rowcon) != 0 && (parseInt(rowfwstart) < parseInt(rowstart) || parseInt(rowfwend) > parseInt(rowend))) {&n; // midrow= '第【'+seq+'】行的行范围内容需要小于等于上方行范围内容！';&n; midrow= '第【'+seq+'】行的行范围录入错误！';&n; msg=msg+midrow+'\n';&n; flag=false;&n; midrow='';&n; }&n; } &n;} &n;if(!(val.filedcolumnrange == '' || val.filedcolumnrange == undefined)) {&n; if(!reg.test(val.filedcolumnrange)){&n; midcol+='第【'+seq+'】行的列范围内容不符合规范！';&n; msg=msg+midcol+'\n';&n; flag=false;&n; midcol='';&n; } else {&n; let colfwcon = val.filedcolumnrange.indexOf("-"); //列范围&n; let colfwstart = val.filedcolumnrange.substring(0, colfwcon);&n; let colfwend = val.filedcolumnrange.substring(colfwcon + 1); &n;console.log('colfwstart:'+colfwstart);&n;console.log('colfwend:'+colfwend);&n; if(parseInt(colcon) != 0 && (parseInt(colfwstart) < parseInt(colstart) || parseInt(colfwend) > parseInt(colend))) {&n; // midcol+= '第【'+seq+'】行的列范围内容需要小于等于上方列范围内容！';&n; midcol+= '第【'+seq+'】行的列范围录入错误！';&n; msg=msg+midcol+'\n';&n; flag=false;&n; midcol='';&n; }&n; }&n;}&n; console.log('msg:',msg); &n; seq++; &n; }&n; if(!flag){&n; baseFun.warning(msg);&n; }&n;&n; var tmpfieldcode=datas.multiTable0.tmpfieldcode;&n; console.log('tmpfieldcode:',tmpfieldcode);&n; return flag;&n;}@]@]@>>0logs]]>rdpExcelTmpOneEdit83Excel模板配置新增页面与修改页面nulllatestpublicrdpeab_enter_personalInfojdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster0410.1.80.1572883rdcdbadminadmin2024-12-11 13:37:35:5562024-12-11 13:37:35:55619anamode解析模式1新增（add）、查询（query）、修改（modify）模式tmpcode模板编号1模板编号ExcelTmpOneEdit83nullmaintainExcelTmpOneEdit1{&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; var tmptype=datas.detailTable0.tmptype;&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;let rowcon = 0;&n;const reg = /^\d+-\d+$/;&n;if(tmptype == 'FixedAll' || tmptype == 'FixedRow') {&n;if(!reg.test(rowfw)){&n; baseFun.warning('行范围内容不符合规范');&n; flag=false;&n;} else {&n;rowcon = rowfw.indexOf("-"); &n;}&n;if(!flag){&n; return false;&n;}&n;}&n;console.log('行中:'+rowcon);&n;&n;let colcon = 0;&n;if(tmptype == 'FixedAll' || tmptype == 'FixedCol') {&n;if(!reg.test(colfw)){&n; baseFun.warning('列范围内容不符合规范');&n; flag=false;&n;} else {&n;colcon = colfw.indexOf("-"); &n;}&n;if(!flag){&n; return false;&n;}&n;}&n; let rowstart = 0;&n;let rowend = 0;&n;if (rowcon != 0) {&n;rowstart = rowfw.substring(0, rowcon);&n;rowend = rowfw.substring(rowcon + 1); &n;}&n; let colstart = 0;&n;let colend = 0;&n;if (colcon != 0) {&n;colstart = colfw.substring(0, colcon );&n;colend = colfw.substring(colcon + 1); &n;}&n;&n;console.log('行前:'+rowstart);&n;console.log('行后:'+rowend);&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.tmpfieldcode'+val.tmpfieldcode);//行范围&n; console.log("列范围"+'val.filedcolumnrange'+val.filedcolumnrange);//列范围&n;console.log(1+'val.filedrowrange'+val.filedrowrange);&n;console.log(2+'val.filedrowrange'+val.filedrowrange == '' || val.filedrowrange == undefined);&n;console.log(3+'val.filedrowrange'+val.filedrowrange == undefined);&n;console.log(4+'val.filedrowrange'+val.filedrowrange == '' );&n;if(!(val.filedrowrange == '' || val.filedrowrange == undefined)) { &n;if(!reg.test(val.filedrowrange)){&n; midrow='第【'+seq+'】行的行范围内容不符合规范！';&n; msg=msg+midrow+'\n';&n; flag=false;&n; midrow='';&n; } else {&n; let rowfwcon = val.filedrowrange.indexOf("-"); //行范围&n; let rowfwstart = val.filedrowrange.substring(0, rowfwcon);&n; let rowfwend = val.filedrowrange.substring(rowfwcon + 1); &n;console.log('rowfwstart:'+rowfwstart);&n;console.log('rowfwend:'+rowfwend);&n; if(parseInt(rowcon) != 0 && (parseInt(rowfwstart) < parseInt(rowstart) || parseInt(rowfwend) > parseInt(rowend))) {&n; // midrow= '第【'+seq+'】行的行范围内容需要小于等于上方行范围内容！';&n; midrow= '第【'+seq+'】行的行范围录入错误！';&n; msg=msg+midrow+'\n';&n; flag=false;&n; midrow='';&n; }&n; } &n;}&n; if(!(val.filedcolumnrange == '' || val.filedcolumnrange == undefined)) { &n; if(!reg.test(val.filedcolumnrange)){&n; midcol+='第【'+seq+'】行的列范围内容不符合规范！';&n; msg=msg+midcol+'\n';&n; flag=false;&n; midcol='';&n; } else {&n; let colfwcon = val.filedcolumnrange.indexOf("-"); //列范围&n; let colfwstart = val.filedcolumnrange.substring(0, colfwcon);&n; let colfwend = val.filedcolumnrange.substring(colfwcon + 1); &n;console.log('colfwstart:'+colfwstart);&n;console.log('colfwend:'+colfwend);&n; if(parseInt(colcon) != 0 && (parseInt(colfwstart) < parseInt(colstart) || parseInt(colfwend) > parseInt(colend))) {&n; // midcol+= '第【'+seq+'】行的列范围内容需要小于等于上方列范围内容！';&n; midcol+= '第【'+seq+'】行的列范围录入错误！';&n; msg=msg+midcol+'\n';&n; flag=false;&n; midcol='';&n; }&n; }&n; }&n;&n; console.log('msg:',msg); &n; seq++; &n; }&n; if(!flag){&n; baseFun.warning(msg);&n; }&n;&n; var tmpfieldcode=datas.multiTable0.tmpfieldcode;&n; console.log('tmpfieldcode:',tmpfieldcode);&n; return flag;&n;}@]@]@>>0logs]]>rdpShowExcel1补录信息查看latestpublic_PUBLIC_PUBLIC10.1.80.882883rmcdb10.1.80.882883rmcdbqian_jweiqian_jwei2024-10-22 10:45:36:2402024-10-22 10:45:36:2400121 提交，向zsc导出提交_publicanamode查看模式1flowbussinessid补录流程实例1nulltaskbussinessid补录任务实例1nullShowExcel1coding>0]]>rdpTaskInfoViewShowExcel2补录信息查看latestpublic_PUBLIC_PUBLIC10.1.80.882883rmcdb10.1.80.882883rmcdbqian_jweiqian_jwei2024-10-22 12:50:04:3632024-10-22 12:50:04:3631_publicanamode查看模式1flowbussinessid补录流程实例1nulltaskCode补录任务编号1nulltaskCodeNametaskCodeName1nulltaskFirstPerson补录人ID1nulltaskFirstPersonName补录人名称1nulltaskOrgcode补录机构编号ID1nulltaskOrgcodeName补录机构1nulltaskbussinessid补录任务实例，业务流程实例号1nullterm数据期次1nulltmpCode补录模板编号1nulltmpCodeName补录模板名称1nullTaskInfoViewShowExcel2coding>0]]>