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]]>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]]>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]]>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]]>logSupplementTaskQuery30指标数据查询主页面latestpubliclogsSupplementTaskQuery10.1.80.882883rmcdb10.1.80.882883rmcdbadminadmin2024-11-04 21:25:22:9082024-11-04 21:25:22:9081_publicSupplementTaskQuery30001 select a.idx_date,a.org_code,a.org_name,a.idx_code,b.idx_name,c.dime_name,a.last_year_val, case when ROUND(a.idx_value1, 2) is null then '0' else ROUND(a.idx_value1, 2) end as idx_value1, case when ROUND(a.idx_value1-a.last_day_val, 2) is null then '0' else ROUND(a.idx_value1-a.last_day_val, 2) end as idx_value2, case when ROUND((a.idx_value1-a.last_day_val)/ a.last_day_val, 2) is null then '0' else ROUND((a.idx_value1-a.last_day_val)/ a.last_day_val, 2) end as idx_value3, case when ROUND(a.idx_value1-a.last_mohth_val, 2) is null then '0' else ROUND(a.idx_value1-a.last_mohth_val, 2) end as idx_value4, case when ROUND((a.idx_value1-a.last_mohth_val)/ a.last_mohth_val, 2) is null then '0' else ROUND((a.idx_value1-a.last_mohth_val)/ a.last_mohth_val, 2) end as idx_value5, case when ROUND(a.idx_value1-a.last_year_val, 2) is null then '0' else ROUND(a.idx_value1-a.last_year_val, 2) end as idx_value6, case when ROUND((a.idx_value1-a.last_year_val)/ a.last_year_val, 2) is null then '0' else ROUND((a.idx_value1-a.last_year_val)/ a.last_year_val, 2) end as idx_value7, case when ROUND(a.idx_value1-a.last_12mohth_val, 2) is null then '0' else ROUND(a.idx_value1-a.last_12mohth_val, 2) end as idx_value8, case when ROUND((a.idx_value1-a.last_12mohth_val)/ a.last_12mohth_val, 2) is null then '0' else ROUND((a.idx_value1-a.last_12mohth_val)/ a.last_12mohth_val, 2) end as idx_value9 from rdc_idx_org_index a left join RMC_IDX_BASEINFO b on a.IDX_CODE = b.IDX_CODE left join rmc_idx_dimension c on b.IDX_CODE = c.IDX_CODE where 1=1 and a.idx_date = #{idx_date} and a.org_code in ( ${org_code} ) and c.dime_name like concat('%', #{dime_name}, '%') AND ORG_CODE in (${_datascopeorg}) ORDER by a.idx_value1 DESC ]]>logsSupplementTaskQuery1指标数据查询latestpublic_PUBLIC_PUBLIC10.1.80.882883rmcdb10.1.80.882883rmcdbadminadmin2024-09-27 10:14:26:7402024-09-27 10:14:26:7401_publiclogSupplementTaskQuery30SupplementTaskQuery190SupplementTaskQuery1SupplementTaskQuery01RstSetSupplementTaskQuery]]>logSupplementTaskQueryList36数据补录任务管理主页面查询latestpubliclogsSupplementTaskQueryList10.1.80.882883rmcdblocalhost3306rwa_devadminadmin2025-03-25 20:12:15:5962024-12-26 14:39:19:355null_publicSupplementTaskQueryList36001 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' ) xitb ) 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_publiclogSupplementTaskQueryList36SupplementTaskQueryList190SupplementTaskQueryList1SupplementTaskQueryList01RstSetSupplementTaskQueryList]]>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]]>logSupplementTaskReviewList23数据补录及审核页面总查询列表页面latestpubliclogsSupplementTaskReviewListjdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster0410.1.80.882883rmcdbadminadmin2024-11-07 16:44:21:9732024-11-07 16:44:21:9731_publicSupplementTaskReviewList23001 select distinct risb.taskbussinessid, risb.term, risb.taskCode, isb.tmpname as taskCodeName, risb.taskVersion, risb.taskStatus, risb.taskStartDate, risb.taskUpdateDate, risb.taskOrgcode, risb.taskCreatePerson, risb.taskUpdatePerson, risb.taskFirstPerson, risb.taskReviewedPerson, su1.cnname as taskCreatePersonName, su2.cnname as taskUpdatePersonName, su3.cnname as taskFirstPersonName, su4.cnname as taskReviewedPersonName, risb.remark, sn.nounname as taskStatusName , risbf.flowbussinessid , todotask.status as flowStatus, todotask.account as flowAccount, case when todotask.status is not null then todotask.soleorderid else 0 end as soleorderid from rmc_imput_suptaskrun_bussinessinfo risb left join rmc_imput_suptaskconf_baseinfo isb on isb.taskCode = risb.taskCode left join rmc_imput_suptaskrun_bussinessflowinfo risbf on risb.taskbussinessid = risbf.taskbussinessid left join sys_user su1 on risb.taskCreatePerson = su1.account left join sys_user su2 on risb.taskUpdatePerson = su2.account left join sys_user su3 on risb.taskFirstPerson = su3.account left join sys_user su4 on risb.taskReviewedPerson = su4.account left join sys_noun sn on sn.NOUNITEM = 'taskStatus' and sn.NOUNVALUE = risb.taskStatus left join v_wfs_todotask todotask on todotask.account=#{currentAccount} and todotask.businesstypeid = '0001' and risbf.flowbussinessid = todotask.businessinsid where 1=1 and risb.term= #{taskStartDate1} and risb.taskCode = #{taskCode1} AND risb.taskOrgcode in (${_datascopeorg}) AND risb.taskCreatePerson = #{_datascopeaccount} ORDER BY taskStartDate desc ,risb.taskbussinessid desc ]]>logsSupplementTaskReviewList1数据补录及审核页面总查询列表页面latestpublic_PUBLIC_PUBLICjdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster04jdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster04adminadmin2024-09-24 15:46:27:7122024-09-24 15:46:27:7121_publiclogSupplementTaskReviewList23SupplementTaskReviewList190SupplementTaskReviewList1SupplementTaskReviewList01RstSetSupplementTaskReviewList]]>