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]]>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 select a.taskcode id ,a.taskcode id ,a.tmpname as text,a.tmpname,a.orgcode,b.orgname,a.account,c.cnname,d.nounname frequency,adjustment, case when a.ischeck = '0' then '否' else '是' end ischeck,f.tmpname1 from rmc_imput_suptaskconf_baseinfo a left join (select taskcode,group_concat(tmpname ORDER BY tmpcode desc separator ',') tmpname1 from (select taskcode,tmpcode,case when f.tmpcode = 'G0102' then 'G0102资产负债项目统计表附注' when f.tmpcode = 'G0107' then 'G0107贷款分行业情况表' when f.tmpcode = 'G0300' then 'G0300各项资产减值损失准备情况表' when f.tmpcode = 'G1200' then 'G1200贷款质量迁徙情况表' when f.tmpcode = 'G1401' then 'G1401大额风险暴露统计表' when f.tmpcode = 'S6700' then 'S6700房地产融资风险监测表' when f.tmpcode = 'B0001' then '不良资产处置清单' when f.tmpcode = 'FX0001' then '风险管理部-手工补录指标' when f.tmpcode = 'JC0001' then '计划财务部-手工补录指标' when f.tmpcode = 'FL0001' then '法律合规部-手工补录指标' when f.tmpcode = 'XX0001' then '信息技术部-手工补录指标' when f.tmpcode = 'BG0001' then '办公室-手工补录指标' when f.tmpcode = 'ZL0001' then '战略部-手工补录指标' when f.tmpcode = 'SJ0001' then '数据管理部-手工补录指标' when f.tmpcode = 'QY0001' then '青银金租-手工补录指标' when f.tmpcode = 'QL0001' then '青银理财-手工补录指标' end tmpname from rmc_imput_suptaskconf_relatedinfo f) group by taskcode) f on a.taskcode = f.taskcode left join sys_organization b on a.orgcode = b.orgcode left join sys_user c on a.account = c.account left join sys_noun d on a.frequency = d.nounvalue and d.nounitem = 'frequency' where 1=1 and a.yesorno = '1' ]]>logSupplementPlanQuery32数据补录任务进度查询latestpublic_PUBLIC_PUBLIC10.1.80.882883rmcdb10.1.80.882883rdcdbadminadmin2024-12-28 11:28:45:0262024-12-28 11:28:45:0261_publicSupplementPlanQuery32001 select distinct a.term,a.taskstartdate,d.tmpname taskcode, CASE WHEN b.cnname IS NULL THEN ' ' else b.cnname END as taskfirstperson, c.nounname taskstatus,a.taskbussinessid , a.taskstatus as status from rmc_imput_suptaskrun_bussinessinfo a left join sys_user b on a.taskfirstperson = b.account left join sys_noun c on a.taskstatus = c.nounvalue and c.nounitem = 'taskStatus' left join rmc_imput_suptaskconf_baseinfo d on a.taskcode = d.taskcode left join rmc_input_suptaskrun_baseinfo rinsb on rinsb.taskbussinessid = a.taskbussinessid where 1=1 and a.term = #{taskstartdate1} and d.taskcode in ('${taskcode}') order by a.taskstatus ASC,a.term ASC,a.taskstartdate ASC,d.tmpname ASC ]]>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 select distinct a.taskbussinessid,a.flowbussinessid,a.flowid,a.Account,d.plaitperson, su.cnname,a.orgcode,c.orgname,e.rolename,d.plaitdate, d.POSTID, case when d.POSTID = 'A01' then null else sn.NOUNNAME end as verifymark , case when d.POSTID = 'A01' then null else t.approvalRemark end as remark , f.nounname as naouname1 , case when d.POSTID = 'A01' then '提交' else '审核' end as naouname , d.curdeptcode , c2.orgname as curdeptcodename , d.NODEDEPTCODE , so.orgname as orgname2 from rmc_imput_suptaskrun_bussinessflowinfo a left join sys_user b on a.Account = b.account left join sys_organization c on a.orgcode = c.orgcode left join wfs_flowinfomanage d on a.flowbussinessid = d.businessinsid left join sys_user su on su.account = d.plaitperson left join sys_organization c2 on d.curdeptcode = c2.orgcode left join sys_noun f on d.status = f.nounvalue and f.nounitem = 'TASKLISTSTATE' left join sys_role e on d.pointid= e.roleid left join sys_imput_suptaskconf_flowapproval_his t on t.bussinessid = a.flowbussinessid and t.SOLEORDERID = d.SOLEORDERID left join sys_noun sn on t.approvalType = sn.NOUNVALUE and sn.NOUNITEM = 'APPROVALTYPE' left join sys_organization so on d.NODEDEPTCODE = so.orgcode where 1=1 and taskbussinessid = #{taskbussinessid} order by d.plaitdate ]]>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 select sbi.taskbussinessid as taskbussinessid, sbi.term as term, sbi.taskCode as taskCode, isb.tmpname as taskCodeName, rist.tmpCode , case when tb.tmpName is null then sn.nounname else tb.tmpName end as tmpCodeName, sbd.tmpRemark , sbi.taskStartDate , sbi.taskOrgcode , so.orgName as taskOrgcodeName, sbi.taskFirstPerson , suf.cnname as taskFirstPersonName , sbi.taskReviewedPerson , sur.cnname as taskReviewedPersonName , risbf.flowbussinessid ,case when tb.tmpName is null then 1 else 0 end as isIndex from rmc_imput_suptaskrun_bussinessinfo sbi left join rmc_imput_suptaskrun_tmprelas rist on sbi.taskbussinessid = rist.taskbussinessid left join rmc_imput_suptaskrun_bussinessdetail sbd on sbi.taskbussinessid = sbd.taskbussinessid and sbi.taskCode = sbd.taskCode and rist.tmpCode = sbd.tmpCode left join rmc_imput_tmpconf_baseinfo tb on rist.tmpCode = tb.tmpcode left join sys_noun sn on sn.nounitem = 'TMP-INDEX-NOUN' and sn.nounvalue = rist.tmpcode left join rmc_imput_suptaskconf_baseinfo isb on isb.taskCode = sbi.taskCode left join sys_user suf on sbi.taskFirstPerson = suf.ACCOUNT left join sys_user sur on sbi.taskReviewedPerson = sur.ACCOUNT left join sys_organization so on sbi.taskOrgcode = so.ORGCODE left join rmc_imput_suptaskrun_bussinessflowinfo risbf on sbi.taskbussinessid = risbf.taskbussinessid where 1=1 and sbi.taskStatus = '04' and sbi.term = #{termParam} and rist.tmpCode in ( ${tmpCodesParam} ) AND risb.taskOrgcode in (${_datascopeorg) AND sbi.taskReviewedPerson = #{_datascopeaccount} AND suf.orgcode in (${_datascopeorg) order by sbi.taskbussinessid desc, sbi.term desc , sbi.taskStartDate desc ]]>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 select a.taskcode,a.tmpcode,b.tmpname,a.remark,a.sqlcode from rmc_imput_suptaskconf_relatedinfo a left join rmc_imput_tmpconf_baseinfo b on a.tmpcode =b.tmpcode where 1=1 and a.taskcode = #{taskcode} ]]>logSupplementTaskOneEdit35数据补录任务管理维护限制信息查询latestpublic_PUBLIC_PUBLIC10.1.80.882883rmcdb10.1.80.882883rmcdbadminadmin2024-10-10 11:44:42:0892024-10-10 11:44:42:0891_publicSupplementTaskOneEdit35001 select a.taskcode, a.tmpcode,b.tmpname,a.tmpverrowcoltype,a.vertimmer,a.tmpverrowrange, a.tmpvercolumnrange,a.checktype,a.datatype,a.excelformula,a.sqlcode,a.exceedtype,a.errormsgtmplate,a.tmpverificationcode,a.tmpverificationname from rmc_imput_tmpconf_verificationrules a left join rmc_imput_tmpconf_baseinfo b on a.tmpcode =b.tmpcode left join sys_noun c on a.tmpverrowcoltype = c.nounvalue and c.nounitem = 'tmpverrowcoltype' left join sys_noun d on a.vertimmer = d.nounvalue and d.nounitem = 'vertimmer' left join sys_noun e on a.checktype = e.nounvalue and e.nounitem = 'checktype' left join sys_noun f on a.exceedtype = f.nounvalue and f.nounitem = 'exceedtype' where 1=1 and a.taskcode = #{taskcode} ]]>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 0 then '2' else '0' end as flag,case when a.num>0 then '任务编号已存在，请重新输入' else '' end as checkmsg from (select count(1) as num from rmc_imput_suptaskconf_baseinfo where taskcode =#{detailTable0.taskcode}) a @]@]@> select '0' as flag,'' as checkmsg from dual ]]>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 select a.account,a.cnname,d.ORGNAME orgcode,c.ORGNAME deptcode from sys_user a left join sys_user_role b on a.account = b.account left join sys_organization c on a.orgcode = c.orgcode left join sys_organization d on c.SUPERORGCODE = d.orgcode where b.ROLEID ='zhsjbly' and (a.orgcode = #{orgcode} or c.SUPERORGCODE = #{orgcode}) and a.account like concat('%',#{account},'%') and a.cnname like concat('%',#{cnname},'%') ]]>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]]>