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]]>