logSupplementTaskQueryList35数据补录任务管理主页面查询latestpubliclogsSupplementTaskQueryList10.1.80.882883rmcdb10.1.80.882883rmcdbadminadmin2024-12-26 14:39:19:3552024-12-26 14:39:19:3551_publicSupplementTaskQueryList35001 select a.taskcode,a.tmpname,a.orgcode,b.orgname,a.account,c.cnname,d.nounname frequency,adjustment, a.yesorno, e.nounname as yesornoname , case when a.ischeck = '0' then '否' else '是' end ischeck,m. tmpname2 from rmc_imput_suptaskconf_baseinfo a left join ( select distinct risr.taskcode,risr.tmpcode,risr.sqlcode,risr.remark,itbsys.taskcode222,itbsys.remark222 ,GROUP_CONCAT(itbsys.remark222 SEPARATOR ',') as tmpname2 from rmc_imput_suptaskconf_relatedinfo risr left join ( select id as taskcode222, text as remark222 from ( select itb.tmpcode as ID, itb.tmpname as TEXT from rmc_imput_tmpconf_baseinfo itb union all select x.NOUNVALUE as ID , x.NOUNNAME as TEXT from sys_noun x where x.NOUNITEM = 'TMP-INDEX-NOUN' and x.NOUNSUPER = 'TMP-INDEX-NOUN' and x.NOUNVALIDITY = '1' )) itbsys on itbsys.taskcode222 = risr.tmpcode group by risr.taskcode ) m on a.taskcode = m.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' left join sys_noun e on a.yesorno = e.nounvalue and e.nounitem = 'YESORNO' where 1=1 and a.orgcode in( ${orgcode} ) and a.account = #{account} and a.frequency in (${frequency}) and m.tmpcode like concat('%',#{tmpcode},'%') and a.tmpname like concat('%',#{tmpname},'%') and a.taskcode like concat('%',#{taskcode},'%') and m.tmpname2 like concat('%',#{tmpname1},'%') and a.yesorno = #{yesorno1} ORDER BY a.taskcode desc ]]>logsSupplementTaskQueryList1数据补录任务管理主页面查询latestpublic_PUBLIC_PUBLIC10.1.80.882883rmcdb10.1.80.882883rmcdbadminadmin2024-09-29 16:39:12:8462024-09-29 16:39:12:8461_publiclogSupplementTaskQueryList35SupplementTaskQueryList190SupplementTaskQueryList1SupplementTaskQueryList01RstSetSupplementTaskQueryList]]>logSupplementTaskQueryList_no1数据补录任务管理主页面查询_是否有效-否latestpublic_PUBLIC_PUBLIC10.1.80.882883rmcdb10.1.80.882883rmcdbadminadmin2024-10-30 10:34:53:2162024-10-30 10:34:53:2161_publicSupplementTaskQueryList_no1001 update rmc_imput_suptaskconf_baseinfo set yesorno = '0' where taskcode = #{taskcode} ]]>logsSupplementTaskQueryList_no1SupplementTaskQueryList_nolatestprivaterdpSupplementTaskQueryList10.1.80.882883rmcdb10.1.80.882883rmcdbadminadmin2024-10-30 10:41:25:1342024-10-30 10:41:25:1341_publiclogSupplementTaskQueryList_no1SupplementTaskQueryList_no190SupplementTaskQueryList_no1SupplementTaskQueryList_no01RstSetSupplementTaskQueryList_no]]>logSupplementTaskQueryList_yes1数据补录任务管理主页面查询_是否有效-是latestpublic_PUBLIC_PUBLIC10.1.80.882883rmcdb10.1.80.882883rmcdbadminadmin2024-10-30 10:33:48:9112024-10-30 10:33:48:9111_publicSupplementTaskQueryList_yes1001 update rmc_imput_suptaskconf_baseinfo set yesorno = '1' where taskcode = #{taskcode} ]]>logsSupplementTaskQueryList_yes1SupplementTaskQueryList_yeslatestprivaterdpSupplementTaskQueryList10.1.80.882883rmcdb10.1.80.882883rmcdbadminadmin2024-10-30 10:43:20:5922024-10-30 10:43:20:5921_publiclogSupplementTaskQueryList_yes1SupplementTaskQueryList_yes190SupplementTaskQueryList_yes1SupplementTaskQueryList_yes01RstSetSupplementTaskQueryList_yes]]>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]]>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]]>rdpSupplementTaskQueryList41数据补录任务管理latestpublic_PUBLIC_PUBLICjdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster0410.1.80.882883rmcdbadminadmin2024-12-12 14:30:59:5642024-12-12 14:30:59:5641_publiclogsSupplementTaskQueryList1logsSupplementTaskQueryList_no1logsSupplementTaskQueryList_yes1rdpSupplementTaskOneEdit54rdpSupplementTaskOneEdit26rdpSupplementTaskUserQuery11SupplementTaskQueryList41querySupplementTaskQueryList1>0logs]]>