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]]>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]]>rdpSupplementCrmKriQuery4全面风险管理KRI月度监测报告主界面功能nulllatestpublic_PUBLIC_PUBLICjdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster0410.1.80.882883rmcdbadminadmin2024-11-09 11:02:50:7102024-11-09 11:02:50:7101_publicbusinesstypeid流程类型编号1流程类型编号logsExcelTmpQueryList2SupplementCrmKriQuery4nullqueryExcelTmpQueryList1>0logs]]>logSupplementTaskQueryList_13数据补录任务管理主页面查询latestpubliclogsSupplementTaskQueryList10.1.80.882883rmcdb10.1.80.882883rmcdbadminadmin2024-11-10 17:23:42:3622024-11-10 17:23:42:3621_publicSupplementTaskQueryList_13001]]>logSupplementPlanQuery32数据补录任务进度查询latestpublic_PUBLIC_PUBLIC10.1.80.882883rmcdb10.1.80.882883rdcdbadminadmin2024-12-28 11:28:45:0262024-12-28 11:28:45:0261_publicSupplementPlanQuery32001]]>logsSupplementPlanQuery1数据补录任务进度查询主页面latestpublicrdpSupplementPlanQuery10.1.80.882883rmcdb10.1.80.882883rmcdbadminadmin2024-09-27 08:47:25:4782024-09-27 08:47:25:4781_publiclogSupplementPlanQuery32SupplementPlanQuery190SupplementPlanQuery1SupplementPlanQuery01RstSetSupplementPlanQuery]]>logSupplementTaskInfo19数据补录任务进度流程查看latestpublic_PUBLIC_PUBLIC10.1.80.882883rmcdb10.1.80.882883rmcdbadminadmin2024-12-07 15:50:32:8182024-12-07 15:50:32:8181_publicSupplementTaskInfo19001]]>logsSupplementTaskInfo1数据补录任务进度流程查看latestpublic_PUBLIC_PUBLIC10.1.80.882883rmcdb10.1.80.882883rmcdbadminadmin2024-09-27 18:55:49:6792024-09-27 18:55:49:6792_publiclogSupplementTaskInfo19SupplementTaskInfo190SupplementTaskInfo1SupplementTaskInfo01RstSetSupplementTaskInfo]]>rdpSupplementTaskInfo3数据补录任务进度流程查看nulllatestpublicrdpeab_enter_personalInfojdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster0410.1.80.882883rmcdbadminadmin2024-11-16 09:46:57:5332024-11-16 09:46:57:53329anamode解析模式1新增(add)、查询(query)、修改(modify)模式taskbussinessid流程编号1流程编号logsSupplementTaskInfo1SupplementTaskInfo3nullmaintainSupplementTaskInfo1>0logs]]>rdpSupplementPlanQuery21数据补录任务进度查询nulllatestpublic_PUBLIC_PUBLICjdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster0410.1.80.882883rdcdbadminadmin2024-12-28 11:28:13:4612024-12-28 11:28:13:4611_publicbusinesstypeid流程类型编号1流程类型编号logSupplementTaskQueryList_13logsSupplementPlanQuery1rdpSupplementTaskInfo3SupplementPlanQuery21nullquerySupplementPlanQuery1>0logs]]>logSupplementResultQuery32补录数据查询latestpubliclogsSupplementResultQueryTEAMjdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster0410.1.80.882883rmcdbadminadmin2024-12-02 17:01:27:8462024-12-02 17:01:27:8461_publicSupplementResultQuery32001]]>logsSupplementResultQueryTEAM1补录数据查询功能逻辑组latestpublic_PUBLIC_PUBLICjdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster04jdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster04adminadmin2024-10-13 11:07:54:9312024-10-13 11:07:54:931补录数据查询逻辑组_publiclogSupplementResultQuery32SupplementResultQueryTEAM190SupplementResultQueryTEAM1SupplementResultQuery01RstSetSupplementResultQuery]]>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]]>rdpTaskInfoViewShowIndex1页面指标补录查看功能latestpublic_PUBLIC_PUBLIC10.1.80.882883rmcdb10.1.80.882883rmcdbli_gpuli_gpu2024-11-01 15:39:55:5792024-11-01 15:39:55:579增加页面指标查看功能_publicflowbussinessid流程实例1nulltaskbussinessid补录任务编号1nullTaskInfoViewShowIndex1coding>0]]>rdpSupplementResultQuery29补录数据查询latestpublic_PUBLIC_PUBLICjdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster0410.1.80.882883rmcdbadminadmin2024-12-02 16:50:30:3032024-12-02 16:50:30:3031_publiclogsSupplementResultQueryTEAM1rdpTaskInfoViewShowExcel2rdpTaskInfoViewShowIndex1SupplementResultQuery29querySupplementResultQueryTEAM0>0logs]]>rdpSupplementTaskBatchImport1批量补录数据文件导入页面latestpublic_PUBLIC_PUBLICjdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster04jdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster04adminadmin2024-10-04 21:05:23:0302024-10-04 21:05:23:0301_publicSupplementTaskBatchImport1query1>0]]>logPageTmpQueryListDel1页面补录模板删除latestpublic_PUBLIC_PUBLIC10.1.80.882883rmcdb10.1.80.882883rmcdbadminadmin2024-10-11 20:00:46:4802024-10-11 20:00:46:4801_publicPageTmpQueryListDel1001 DELETE FROM rmc_input_tmpconf_baseinfo u1 WHERE u1.deptcode =#{deptcode} ]]>logPageTmpQueryListSave1页面补录模板保存latestpublic_PUBLIC_PUBLIC10.1.80.882883rmcdb10.1.80.882883rmcdbadminadmin2024-10-11 20:01:46:8652024-10-11 20:01:46:8651_publicPageTmpQueryListSave1001 INSERT INTO rmc_input_tmpconf_baseinfo (indexcode, indexname, cpvalue, baorfichanges, oeorlevel,raftnextstage,deptcode) select #{item.indexcode},#{item.indexname},#{item.cpvalue},#{item.baorfichanges} ,#{item.oeorlevel} ,#{item.raftnextstage},#{item.deptcode} from dual ]]>logsPageTmpQueryListEdit1页面补录模板维护latestpublic_PUBLIC_PUBLIC10.1.80.882883rmcdb10.1.80.882883rmcdbadminadmin2024-10-11 20:03:41:9682024-10-11 20:03:41:9681_publiclogPageTmpQueryListDel1logPageTmpQueryListSave1PageTmpQueryListEdit190PageTmpQueryListEdit1PageTmpQueryListDel01RstSetPageTmpQueryListDelPageTmpQueryListEdit1PageTmpQueryListSave11RstSetPageTmpQueryListSave]]>rdpPageTmpQueryList12页面补录模板latestpublicrdpSupplementTaskHandleListjdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster0410.1.80.882883rmcdbadminadmin2024-10-11 20:06:02:1412024-10-11 20:06:02:1411_publicdeptcodedeptcode1补录机构logsPageTmpQueryListEdit1PageTmpQueryList12maintainPageTmpQueryList1>0logs]]>rdpSupplementTaskHandleList2SupplementTaskHandleListlatestpublicrdpSupplementTaskStartjdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster04jdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster04adminadmin2024-10-04 21:02:40:6992024-10-04 21:02:40:6992024-10-11_publicrdpPageTmpQueryList12SupplementTaskHandleList2tabFrame1>0]]>logSupplementTaskList3获取数据补录任务字典latestpublic_PUBLIC_PUBLICjdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster0410.1.80.882883rmcdbadminadmin2024-11-01 09:07:23:6722024-11-01 09:07:23:6722024-11-1_publicSupplementTaskList3001]]>rdpSupplementTaskMadeStart25补录任务人工发起页面latestpublic_PUBLIC_PUBLICjdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster0410.1.80.882883rmcdbadminadmin2024-11-15 21:16:40:5182024-11-15 21:16:40:5181_publiclogSupplementTaskList3SupplementTaskMadeStart25maintain0{&n; utilJs.closeWin(true);&n;}&n;&n;customJs.current.statrtMadeFlow = (data, ref) =>{&n; const str = data.detailTable0.startDate+','+data.detailTable0.task+','+data.detailTable0.account+','+data.detailTable0.startdepart;&n;console.log(str);&n; // utilJs.showModel( &n;// 'flowStartFlow', &n;// 'coding', &n;// {businessdataStr: str , businesstypeid:"0001",flowremark: data.detailTable0.task+'补录流程', isSubmitNext:"0", startdepart:data.detailTable0.startdepart, startperson:data.detailTable0.account},&n; // '补录流程',true&n; // );&n;const task = data.detailTable0.task;&n;if(task==null || task==''){&n;baseFun.info('未选择期次或补录任务,不允许发起!');&n;return ;&n;}&n;baseFun.confirm('是否确认手工发起数据补录任务?',()=>{&n;utilJs.post('/tempfile/task/startWorkFlow.do',{"taskCode":data.detailTable0.task,"startDate":data.detailTable0.startDate,"term":data.detailTable0.term}).then(()=>{&n;baseFun.info('发起成功!');&n;utilJs.closeWin(true);&n;});&n; utilJs.closeWin(true);&n;},()=>{&n;});&n;}&n;&n;customJs.current.term = (yearMonthStr) => {&n; const date = new Date(yearMonthStr.term.substring(0, 4), yearMonthStr.term.substring(4, 6) - 1, 1);&n; const newYearMonth = date.getFullYear().toString().padStart(4, '0') + (date.getMonth()).toString().padStart(2, '0');&n; return newYearMonth;&n;}&n;@]@]@>>0]]>logExcelTmpQueryNoun7模板配置字典latestpublic_PUBLIC_PUBLICjdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster0410.1.80.882883rmcdbli_gpuli_gpu2024-10-30 19:40:32:2542024-10-30 19:40:32:2542024-10-30_publicExcelTmpQueryNoun7001]]>logSupplementTaskOneEdit26数据补录任务管理维护模板信息查询latestpublic_PUBLIC_PUBLIC10.1.80.882883rmcdb10.1.80.882883rmcdbadminadmin2024-10-10 11:53:20:4332024-10-10 11:53:20:4331_publicSupplementTaskOneEdit26001]]>logSupplementTaskOneEdit35数据补录任务管理维护限制信息查询latestpublic_PUBLIC_PUBLIC10.1.80.882883rmcdb10.1.80.882883rmcdbadminadmin2024-10-10 11:44:42:0892024-10-10 11:44:42:0891_publicSupplementTaskOneEdit35001]]>logsSupplementTaskOneEdit2数据补录任务管理维护页面查询latestpublicrdpSupplementTaskOneEdit10.1.80.882883rmcdb10.1.80.882883rmcdbadminadmin2024-10-09 18:18:34:6482024-10-09 18:18:34:6481_publiclogSupplementTaskOneEdit26logSupplementTaskOneEdit35SupplementTaskOneEdit290SupplementTaskOneEdit2SupplementTaskOneEdit101RstSetSupplementTaskOneEdit1SupplementTaskOneEdit2SupplementTaskOneEdit211RstSetSupplementTaskOneEdit2SupplementTaskOneEdit2SupplementTaskOneEdit321RstSetSupplementTaskOneEdit3]]>logSupplementTaskOneEditCheck8数据补录任务管理维护基本信息任务编号校验latestpubliclogsSupplementTaskOneEditSave10.1.80.882883rmcdb10.1.80.882883rmcdbadminadmin2024-10-24 10:28:10:0192024-10-24 10:28:10:0191_publicSupplementTaskOneEditCheck8002]]>logSupplementTaskOneEditSave131数据补录任务管理维护基本信息保存latestpubliclogsSupplementTaskOneEditSave10.1.80.882883rmcdb10.1.80.882883rmcdbadminadmin2024-10-30 10:52:55:8202024-10-30 10:52:55:8201_publicSupplementTaskOneEditSave131001 insert into rmc_imput_suptaskconf_baseinfo(taskcode,tmpname,orgcode,account,frequency,adjustment,ischeck, yesorno ) values (#{detailTable0.taskcode},#{detailTable0.tmpname},#{detailTable0.orgcode},#{detailTable0.account},#{detailTable0.frequency},#{detailTable0.adjustment},#{detailTable0.ischeck} , '1') update rmc_imput_suptaskconf_baseinfo set tmpname=#{detailTable0.tmpname},orgcode=#{detailTable0.orgcode}, account=#{detailTable0.account}, frequency=#{detailTable0.frequency},adjustment=#{detailTable0.adjustment},ischeck=#{detailTable0.ischeck} , yesorno = '1' where taskcode=#{detailTable0.taskcode} ]]>logSupplementTaskOneEditSave26数据补录任务管理维护模板信息删除latestpublic_PUBLIC_PUBLIC10.1.80.882883rmcdb10.1.80.882883rmcdbadminadmin2024-10-09 20:13:27:3842024-10-09 20:13:27:3841_publicSupplementTaskOneEditSave26001 delete from rmc_imput_suptaskconf_relatedinfo where taskcode = #{detailTable0.taskcode} ]]>logSupplementTaskOneEditSave324数据补录任务管理维护模板信息保存latestpublic_PUBLIC_PUBLIC10.1.80.882883rmcdb10.1.80.882883rmcdbyang_zhaoyang_zhao2024-10-19 14:51:43:8722024-10-19 14:51:43:8721_publicSupplementTaskOneEditSave324001 INSERT INTO rmc_imput_suptaskconf_relatedinfo (taskcode,tmpcode,sqlcode,remark) select #{detailTable0.taskcode},#{item.tmpcode},#{item.sqlcode},#{item.remark} from dual select '1' from dual ]]>logSupplementTaskOneEditSave412数据补录任务管理维护限制信息删除latestpublic_PUBLIC_PUBLIC10.1.80.882883rmcdb10.1.80.882883rmcdbadminadmin2024-10-10 15:45:16:8452024-10-10 15:45:16:8451_publicSupplementTaskOneEditSave412001 delete from rmc_imput_tmpconf_verificationrules where taskcode = #{detailTable0.taskcode} ]]>logSupplementTaskOneEditSave514数据补录任务管理维护限制信息保存latestpublic_PUBLIC_PUBLIC10.1.80.882883rmcdb10.1.80.882883rmcdbadminadmin2024-10-18 10:39:55:6812024-10-18 10:39:55:6811_publicSupplementTaskOneEditSave514001 INSERT INTO rmc_imput_tmpconf_verificationrules (taskcode,tmpcode,tmpverificationcode,tmpverificationname,tmpverrowcoltype,vertimmer,tmpverrowrange,tmpvercolumnrange,checktype,datatype,excelformula,sqlcode,exceedtype,errormsgtmplate) select #{detailTable0.taskcode},#{item.tmpcode},#{item.tmpverificationcode},#{item.tmpverificationname},#{item.tmpverrowcoltype},#{item.vertimmer},#{item.tmpverrowrange},#{item.tmpvercolumnrange},#{item.checktype},#{item.datatype},#{item.excelformula},#{item.sqlcode},#{item.exceedtype},#{item.errormsgtmplate} from dual select '1' from dual ]]>logsSupplementTaskOneEditSave8数据补录任务管理维护保存latestpublicrdpSupplementTaskOneEdit10.1.80.882883rmcdb10.1.80.882883rmcdbadminadmin2024-10-20 16:54:39:4302024-10-20 16:54:39:4301_publiclogSupplementTaskOneEditCheck8logSupplementTaskOneEditSave131logSupplementTaskOneEditSave26logSupplementTaskOneEditSave324logSupplementTaskOneEditSave412logSupplementTaskOneEditSave514SupplementTaskOneEditSave890SupplementTaskOneEditSave8SupplementTaskOneEditCheck01RstSetSupplementTaskOneEditCheckSupplementTaskOneEditSave8SupplementTaskOneEditSave111RstSetSupplementTaskOneEditSave1SupplementTaskOneEditSave8SupplementTaskOneEditSave221RstSetSupplementTaskOneEditSave2SupplementTaskOneEditSave8SupplementTaskOneEditSave331RstSetSupplementTaskOneEditSave3SupplementTaskOneEditSave8SupplementTaskOneEditSave441RstSetSupplementTaskOneEditSave4SupplementTaskOneEditSave8SupplementTaskOneEditSave551RstSetSupplementTaskOneEditSave5]]>logSupplementTaskUserQuery8首选责任人页面latestpublic_PUBLIC_PUBLIC10.1.80.882883rmcdb10.1.80.1572883rdcdbadminadmin2024-12-26 14:47:53:7182024-12-26 14:47:53:7181_publicSupplementTaskUserQuery8001]]>logsSupplementTaskUserQuery1首选责任人页面latestpublic_PUBLIC_PUBLIC10.1.80.882883rmcdb10.1.80.882883rmcdbadminadmin2024-09-27 16:11:11:0742024-09-27 16:11:11:0742_publiclogSupplementTaskUserQuery8SupplementTaskUserQuery190SupplementTaskUserQuery1SupplementTaskUserQuery01RstSetSupplementTaskUserQuery]]>rdpSupplementTaskUserQuery11首选责任人选择页面nulllatestpublic_PUBLIC_PUBLIC10.1.80.882883rmcdb10.1.80.1572883rdcdbadminadmin2024-12-26 14:35:55:0592024-12-26 14:35:55:0591_publicbusinesstypeid流程类型编号1流程类型编号orgcode部门编码ID1nulllogsSupplementTaskUserQuery1SupplementTaskUserQuery11nullquerySupplementTaskUserQuery1>0logs]]>rdpSupplementTaskOneEdit54数据补录任务管理维护功能latestpublicrdpSupplementTaskQueryListjdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster0410.1.80.1572883rdcdbadminadmin2025-01-06 19:58:20:9582025-01-06 19:58:20:9581_publicanamodeanamode1操作标识taskcodetaskcode1任务编号logExcelTmpQueryNoun7logsSupplementTaskOneEdit2logsSupplementTaskOneEditSave8rdpSupplementTaskUserQuery11SupplementTaskOneEdit54maintainSupplementTaskOneEdit1{&n; utilJs.closeWin(true);&n;}&n;&n;customJs.current.saveBeforeFun=(datas)=>{&n;&n;var flag = true;&n;//判断列表中的行范围、列范围是否符合规范&n; //遍历集合获取预算类型&n; var msg='';&n; var midrow='';&n; var midcol='';&n; var seq=1;&n; let vals=(datas.multiTable0).values(); &n;const reg = /^\d+-\d+$/;&n; for(let val of vals){&n;/**&n; if(!(val.tmpverrowrange == '' || val.tmpverrowrange == undefined) && !reg.test(val.tmpverrowrange)){&n; midrow='第【'+seq+'】行的行范围内容不符合规范!';&n; msg=msg+midrow+'\n';&n; flag=false;&n; midrow='';&n; } &n; if(!(val.tmpvercolumnrange == '' || val.tmpvercolumnrange == undefined) && !reg.test(val.tmpvercolumnrange)){&n; midcol+='第【'+seq+'】行的列范围内容不符合规范!';&n; msg=msg+midcol+'\n';&n; flag=false;&n; midcol='';&n; }&n;**/&n;var checktype = val.checktype;&n;var datatype = val.datatype;&n; if(val.checktype == '1' && (val.datatype== '' || val.datatype== undefined)){&n; midcol+='第【'+seq+'】行的约束方式录入为数据类型时,数据类型字段不能为空!';&n; msg=msg+midcol+'\n';&n; flag=false;&n; midcol='';&n;}&n; console.log('msg:',msg); &n; seq++; &n; }&n;&n; if(!flag){&n; baseFun.warning(msg);&n; }&n;&n; return flag;&n;}&n;&n;&n;&n;&n;&n;@]@]@>>0logs]]>rdpSupplementTaskOneEdit18数据补录任务管理维护功能latestpublic_PUBLIC_PUBLIC10.1.80.882883rmcdb10.1.80.1572883rdcdbadminadmin2024-12-11 13:57:09:7912024-12-11 13:57:09:7911_publicanamodeanamode1操作标识taskcodetaskcode1任务编号logsSupplementTaskOneEditSave8SupplementTaskOneEdit18maintainSupplementTaskOneEdit1{&n; utilJs.closeWin(true);&n;}@]@]@>>0logs]]>rdpSupplementTaskOneEdit26数据补录任务管理维护功能latestpublicrdpSupplementTaskQueryList10.1.80.882883rmcdb10.1.80.1572883rdcdbadminadmin2024-12-11 13:57:42:5202024-12-11 13:57:42:5201_publicanamodeanamode1操作标识taskcodetaskcode1任务编号logExcelTmpQueryNoun7logsSupplementTaskOneEdit2rdpSupplementTaskUserQuery11SupplementTaskOneEdit26maintainSupplementTaskOneEdit1{&n; utilJs.closeWin(true);&n;}@]@]@>>0logs]]>