RWAServer/ShortCode/001-初始化/李庚谱/补录功能/Supplement-group-2.cfg

<?xml version="1.0" encoding="UTF-8"?><root><product><type>log</type><code>SupplementPlanQuery</code><version>32</version><name>数据补录任务进度查询</name><desc></desc><state>latest</state><visiblerange>public</visiblerange><suptype>_PUBLIC</suptype><supcode>_PUBLIC</supcode><createenv>10.1.80.882883rmcdb</createenv><updateenv>10.1.80.882883rdcdb</updateenv><recmodifyid>admin</recmodifyid><auditorid>admin</auditorid><recmodifydate>2024-12-28 11:28:45:026</recmodifydate><importmodifydate>2024-12-28 11:28:45:026</importmodifydate><changedesc>1</changedesc><module>_public</module><parameter></parameter><relation></relation><detail><![CDATA[<RDP_LOGICINFO><lid>SupplementPlanQuery</lid><lverno>32</lverno><ltype>0</ltype><usetime>0</usetime><errormsg></errormsg><sqlexecutetype>1</sqlexecutetype><lbody><select>
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 
<if test="taskstartdate1 != null and taskstartdate1 !='' ">
	and a.term = #{taskstartdate1} 
</if>
<if test="taskcode != null and taskcode !='' ">
	and d.taskcode in ('${taskcode}') 
</if>
order by a.taskstatus ASC,a.term ASC,a.taskstartdate ASC,d.tmpname ASC
</select></lbody><lbodyDbt></lbodyDbt><lbodyOra></lbodyOra><lbodyMysql></lbodyMysql></RDP_LOGICINFO>]]></detail></product><product><type>logs</type><code>SupplementPlanQuery</code><version>1</version><name>数据补录任务进度查询主页面</name><desc></desc><state>latest</state><visiblerange>public</visiblerange><suptype>rdp</suptype><supcode>SupplementPlanQuery</supcode><createenv>10.1.80.882883rmcdb</createenv><updateenv>10.1.80.882883rmcdb</updateenv><recmodifyid>admin</recmodifyid><auditorid>admin</auditorid><recmodifydate>2024-09-27 08:47:25:478</recmodifydate><importmodifydate>2024-09-27 08:47:25:478</importmodifydate><changedesc>1</changedesc><module>_public</module><parameter></parameter><relation><product><type>log</type><code>SupplementPlanQuery</code><version>32</version></product></relation><detail><![CDATA[<RDP_LOGICSINFO><lid>SupplementPlanQuery</lid><lverno>1</lverno><ltype>9</ltype><usetime>0</usetime><lbody></lbody><RDP_LOGICSRELATIONS><RDP_LOGICSRELATION><lsid>SupplementPlanQuery</lsid><lsverno>1</lsverno><lid>SupplementPlanQuery</lid><ono>0</ono><isrstset>1</isrstset><rstsetcode>RstSetSupplementPlanQuery</rstsetcode></RDP_LOGICSRELATION></RDP_LOGICSRELATIONS></RDP_LOGICSINFO>]]></detail></product><product><type>log</type><code>SupplementResultQuery</code><version>32</version><name>补录数据查询</name><desc></desc><state>latest</state><visiblerange>public</visiblerange><suptype>logs</suptype><supcode>SupplementResultQueryTEAM</supcode><createenv>jdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster04</createenv><updateenv>10.1.80.882883rmcdb</updateenv><recmodifyid>admin</recmodifyid><auditorid>admin</auditorid><recmodifydate>2024-12-02 17:01:27:846</recmodifydate><importmodifydate>2024-12-02 17:01:27:846</importmodifydate><changedesc>1</changedesc><module>_public</module><parameter></parameter><relation></relation><detail><![CDATA[<RDP_LOGICINFO><lid>SupplementResultQuery</lid><lverno>32</lverno><ltype>0</ltype><usetime>0</usetime><errormsg></errormsg><sqlexecutetype>1</sqlexecutetype><lbody><select>
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' 
<if test="termParam !='' and termParam !=null">
	and sbi.term = #{termParam}
</if>
<if test="tmpCodesParam !='' and tmpCodesParam !=null">
	and rist.tmpCode in  ( ${tmpCodesParam} )
</if>
<if test="_datascopeorg != null and _datascopeorg !='' ">
	AND risb.taskOrgcode in (${_datascopeorg) 
</if>
<if test="_datascopeaccount != null and _datascopeaccount != '' ">
	AND sbi.taskReviewedPerson = #{_datascopeaccount}
</if>
<if test="_datascopeorg != null and _datascopeorg !='' ">
	AND suf.orgcode in (${_datascopeorg) 
</if>
order by sbi.taskbussinessid desc,  sbi.term desc  , sbi.taskStartDate desc 
</select></lbody><lbodyDbt></lbodyDbt><lbodyOra></lbodyOra><lbodyMysql></lbodyMysql></RDP_LOGICINFO>]]></detail></product><product><type>logs</type><code>SupplementResultQueryTEAM</code><version>1</version><name>补录数据查询功能逻辑组</name><desc></desc><state>latest</state><visiblerange>public</visiblerange><suptype>_PUBLIC</suptype><supcode>_PUBLIC</supcode><createenv>jdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster04</createenv><updateenv>jdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster04</updateenv><recmodifyid>admin</recmodifyid><auditorid>admin</auditorid><recmodifydate>2024-10-13 11:07:54:931</recmodifydate><importmodifydate>2024-10-13 11:07:54:931</importmodifydate><changedesc>补录数据查询逻辑组</changedesc><module>_public</module><parameter></parameter><relation><product><type>log</type><code>SupplementResultQuery</code><version>32</version></product></relation><detail><![CDATA[<RDP_LOGICSINFO><lid>SupplementResultQueryTEAM</lid><lverno>1</lverno><ltype>9</ltype><usetime>0</usetime><lbody></lbody><RDP_LOGICSRELATIONS><RDP_LOGICSRELATION><lsid>SupplementResultQueryTEAM</lsid><lsverno>1</lsverno><lid>SupplementResultQuery</lid><ono>0</ono><isrstset>1</isrstset><rstsetcode>RstSetSupplementResultQuery</rstsetcode></RDP_LOGICSRELATION></RDP_LOGICSRELATIONS></RDP_LOGICSINFO>]]></detail></product><product><type>log</type><code>SupplementTaskInfo</code><version>19</version><name>数据补录任务进度流程查看</name><desc></desc><state>latest</state><visiblerange>public</visiblerange><suptype>_PUBLIC</suptype><supcode>_PUBLIC</supcode><createenv>10.1.80.882883rmcdb</createenv><updateenv>10.1.80.882883rmcdb</updateenv><recmodifyid>admin</recmodifyid><auditorid>admin</auditorid><recmodifydate>2024-12-07 15:50:32:818</recmodifydate><importmodifydate>2024-12-07 15:50:32:818</importmodifydate><changedesc>1</changedesc><module>_public</module><parameter></parameter><relation></relation><detail><![CDATA[<RDP_LOGICINFO><lid>SupplementTaskInfo</lid><lverno>19</lverno><ltype>0</ltype><usetime>0</usetime><errormsg></errormsg><sqlexecutetype>1</sqlexecutetype><lbody><select>
 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 
<if test="taskbussinessid != null and taskbussinessid !='' ">
	and taskbussinessid = #{taskbussinessid}
</if>
order by d.plaitdate 
</select></lbody><lbodyDbt></lbodyDbt><lbodyOra></lbodyOra><lbodyMysql></lbodyMysql></RDP_LOGICINFO>]]></detail></product><product><type>logs</type><code>SupplementTaskInfo</code><version>1</version><name>数据补录任务进度流程查看</name><desc></desc><state>latest</state><visiblerange>public</visiblerange><suptype>_PUBLIC</suptype><supcode>_PUBLIC</supcode><createenv>10.1.80.882883rmcdb</createenv><updateenv>10.1.80.882883rmcdb</updateenv><recmodifyid>admin</recmodifyid><auditorid>admin</auditorid><recmodifydate>2024-09-27 18:55:49:679</recmodifydate><importmodifydate>2024-09-27 18:55:49:679</importmodifydate><changedesc>2</changedesc><module>_public</module><parameter></parameter><relation><product><type>log</type><code>SupplementTaskInfo</code><version>19</version></product></relation><detail><![CDATA[<RDP_LOGICSINFO><lid>SupplementTaskInfo</lid><lverno>1</lverno><ltype>9</ltype><usetime>0</usetime><lbody></lbody><RDP_LOGICSRELATIONS><RDP_LOGICSRELATION><lsid>SupplementTaskInfo</lsid><lsverno>1</lsverno><lid>SupplementTaskInfo</lid><ono>0</ono><isrstset>1</isrstset><rstsetcode>RstSetSupplementTaskInfo</rstsetcode></RDP_LOGICSRELATION></RDP_LOGICSRELATIONS></RDP_LOGICSINFO>]]></detail></product><product><type>log</type><code>SupplementTaskOneEdit2</code><version>6</version><name>数据补录任务管理维护模板信息查询</name><desc></desc><state>latest</state><visiblerange>public</visiblerange><suptype>_PUBLIC</suptype><supcode>_PUBLIC</supcode><createenv>10.1.80.882883rmcdb</createenv><updateenv>10.1.80.882883rmcdb</updateenv><recmodifyid>admin</recmodifyid><auditorid>admin</auditorid><recmodifydate>2024-10-10 11:53:20:433</recmodifydate><importmodifydate>2024-10-10 11:53:20:433</importmodifydate><changedesc>1</changedesc><module>_public</module><parameter></parameter><relation></relation><detail><![CDATA[<RDP_LOGICINFO><lid>SupplementTaskOneEdit2</lid><lverno>6</lverno><ltype>0</ltype><usetime>0</usetime><errormsg></errormsg><sqlexecutetype>1</sqlexecutetype><lbody><select>
   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} 
</select></lbody><lbodyDbt></lbodyDbt><lbodyOra></lbodyOra><lbodyMysql></lbodyMysql></RDP_LOGICINFO>]]></detail></product><product><type>log</type><code>SupplementTaskOneEdit3</code><version>5</version><name>数据补录任务管理维护限制信息查询</name><desc></desc><state>latest</state><visiblerange>public</visiblerange><suptype>_PUBLIC</suptype><supcode>_PUBLIC</supcode><createenv>10.1.80.882883rmcdb</createenv><updateenv>10.1.80.882883rmcdb</updateenv><recmodifyid>admin</recmodifyid><auditorid>admin</auditorid><recmodifydate>2024-10-10 11:44:42:089</recmodifydate><importmodifydate>2024-10-10 11:44:42:089</importmodifydate><changedesc>1</changedesc><module>_public</module><parameter></parameter><relation></relation><detail><![CDATA[<RDP_LOGICINFO><lid>SupplementTaskOneEdit3</lid><lverno>5</lverno><ltype>0</ltype><usetime>0</usetime><errormsg></errormsg><sqlexecutetype>1</sqlexecutetype><lbody><select>
  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} 
</select></lbody><lbodyDbt></lbodyDbt><lbodyOra></lbodyOra><lbodyMysql></lbodyMysql></RDP_LOGICINFO>]]></detail></product><product><type>logs</type><code>SupplementTaskOneEdit</code><version>2</version><name>数据补录任务管理维护页面查询</name><desc></desc><state>latest</state><visiblerange>public</visiblerange><suptype>rdp</suptype><supcode>SupplementTaskOneEdit</supcode><createenv>10.1.80.882883rmcdb</createenv><updateenv>10.1.80.882883rmcdb</updateenv><recmodifyid>admin</recmodifyid><auditorid>admin</auditorid><recmodifydate>2024-10-09 18:18:34:648</recmodifydate><importmodifydate>2024-10-09 18:18:34:648</importmodifydate><changedesc>1</changedesc><module>_public</module><parameter></parameter><relation><product><type>log</type><code>SupplementTaskOneEdit2</code><version>6</version></product><product><type>log</type><code>SupplementTaskOneEdit3</code><version>5</version></product></relation><detail><![CDATA[<RDP_LOGICSINFO><lid>SupplementTaskOneEdit</lid><lverno>2</lverno><ltype>9</ltype><usetime>0</usetime><lbody></lbody><RDP_LOGICSRELATIONS><RDP_LOGICSRELATION><lsid>SupplementTaskOneEdit</lsid><lsverno>2</lsverno><lid>SupplementTaskOneEdit1</lid><ono>0</ono><isrstset>1</isrstset><rstsetcode>RstSetSupplementTaskOneEdit1</rstsetcode></RDP_LOGICSRELATION><RDP_LOGICSRELATION><lsid>SupplementTaskOneEdit</lsid><lsverno>2</lsverno><lid>SupplementTaskOneEdit2</lid><ono>1</ono><isrstset>1</isrstset><rstsetcode>RstSetSupplementTaskOneEdit2</rstsetcode></RDP_LOGICSRELATION><RDP_LOGICSRELATION><lsid>SupplementTaskOneEdit</lsid><lsverno>2</lsverno><lid>SupplementTaskOneEdit3</lid><ono>2</ono><isrstset>1</isrstset><rstsetcode>RstSetSupplementTaskOneEdit3</rstsetcode></RDP_LOGICSRELATION></RDP_LOGICSRELATIONS></RDP_LOGICSINFO>]]></detail></product><product><type>log</type><code>SupplementTaskOneEditCheck</code><version>8</version><name>数据补录任务管理维护基本信息任务编号校验</name><desc></desc><state>latest</state><visiblerange>public</visiblerange><suptype>logs</suptype><supcode>SupplementTaskOneEditSave</supcode><createenv>10.1.80.882883rmcdb</createenv><updateenv>10.1.80.882883rmcdb</updateenv><recmodifyid>admin</recmodifyid><auditorid>admin</auditorid><recmodifydate>2024-10-24 10:28:10:019</recmodifydate><importmodifydate>2024-10-24 10:28:10:019</importmodifydate><changedesc>1</changedesc><module>_public</module><parameter></parameter><relation></relation><detail><![CDATA[<RDP_LOGICINFO><lid>SupplementTaskOneEditCheck</lid><lverno>8</lverno><ltype>0</ltype><usetime>0</usetime><errormsg></errormsg><sqlexecutetype>2</sqlexecutetype><lbody><select id="SupplementTaskOneEditCheck">
<if test="detailTable0.anamode=='add'">
<![CDATA[
select case when a.num>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
@]@]@>
</if>
<if test="detailTable0.anamode=='modify'">
  select '0' as flag,'' as checkmsg from dual
</if>
</select></lbody><lbodyDbt></lbodyDbt><lbodyOra></lbodyOra><lbodyMysql></lbodyMysql></RDP_LOGICINFO>]]></detail></product><product><type>log</type><code>SupplementTaskOneEditSave1</code><version>31</version><name>数据补录任务管理维护基本信息保存</name><desc></desc><state>latest</state><visiblerange>public</visiblerange><suptype>logs</suptype><supcode>SupplementTaskOneEditSave</supcode><createenv>10.1.80.882883rmcdb</createenv><updateenv>10.1.80.882883rmcdb</updateenv><recmodifyid>admin</recmodifyid><auditorid>admin</auditorid><recmodifydate>2024-10-30 10:52:55:820</recmodifydate><importmodifydate>2024-10-30 10:52:55:820</importmodifydate><changedesc>1</changedesc><module>_public</module><parameter></parameter><relation></relation><detail><![CDATA[<RDP_LOGICINFO><lid>SupplementTaskOneEditSave1</lid><lverno>31</lverno><ltype>0</ltype><usetime>0</usetime><errormsg></errormsg><sqlexecutetype>1</sqlexecutetype><lbody><update>
<if test="detailTable0.anamode=='add'">
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')
</if>
<if test="detailTable0.anamode=='modify'">
  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} 
</if>
</update></lbody><lbodyDbt></lbodyDbt><lbodyOra></lbodyOra><lbodyMysql></lbodyMysql></RDP_LOGICINFO>]]></detail></product><product><type>log</type><code>SupplementTaskOneEditSave2</code><version>6</version><name>数据补录任务管理维护模板信息删除</name><desc></desc><state>latest</state><visiblerange>public</visiblerange><suptype>_PUBLIC</suptype><supcode>_PUBLIC</supcode><createenv>10.1.80.882883rmcdb</createenv><updateenv>10.1.80.882883rmcdb</updateenv><recmodifyid>admin</recmodifyid><auditorid>admin</auditorid><recmodifydate>2024-10-09 20:13:27:384</recmodifydate><importmodifydate>2024-10-09 20:13:27:384</importmodifydate><changedesc>1</changedesc><module>_public</module><parameter></parameter><relation></relation><detail><![CDATA[<RDP_LOGICINFO><lid>SupplementTaskOneEditSave2</lid><lverno>6</lverno><ltype>0</ltype><usetime>0</usetime><errormsg></errormsg><sqlexecutetype>1</sqlexecutetype><lbody><delete>
 delete from rmc_imput_suptaskconf_relatedinfo where taskcode = #{detailTable0.taskcode} 
</delete></lbody><lbodyDbt></lbodyDbt><lbodyOra></lbodyOra><lbodyMysql></lbodyMysql></RDP_LOGICINFO>]]></detail></product><product><type>log</type><code>SupplementTaskOneEditSave3</code><version>24</version><name>数据补录任务管理维护模板信息保存</name><desc></desc><state>latest</state><visiblerange>public</visiblerange><suptype>_PUBLIC</suptype><supcode>_PUBLIC</supcode><createenv>10.1.80.882883rmcdb</createenv><updateenv>10.1.80.882883rmcdb</updateenv><recmodifyid>yang_zhao</recmodifyid><auditorid>yang_zhao</auditorid><recmodifydate>2024-10-19 14:51:43:872</recmodifydate><importmodifydate>2024-10-19 14:51:43:872</importmodifydate><changedesc>1</changedesc><module>_public</module><parameter></parameter><relation></relation><detail><![CDATA[<RDP_LOGICINFO><lid>SupplementTaskOneEditSave3</lid><lverno>24</lverno><ltype>0</ltype><usetime>0</usetime><errormsg></errormsg><sqlexecutetype>1</sqlexecutetype><lbody><insert id="SupplementTaskOneEditSave3">
<if test="multiTable1 != null and  multiTable1.size() !=0 ">
		INSERT INTO rmc_imput_suptaskconf_relatedinfo
		(taskcode,tmpcode,sqlcode,remark)
		<foreach collection="multiTable1" item="item" index="idx" open="(" close=")" separator=" union all ">
				select #{detailTable0.taskcode},#{item.tmpcode},#{item.sqlcode},#{item.remark} from dual
		</foreach>
</if>
<if test="multiTable1 == null or  multiTable1.size() == 0 ">
 select '1' from dual
</if>
</insert></lbody><lbodyDbt></lbodyDbt><lbodyOra></lbodyOra><lbodyMysql></lbodyMysql></RDP_LOGICINFO>]]></detail></product><product><type>log</type><code>SupplementTaskOneEditSave4</code><version>12</version><name>数据补录任务管理维护限制信息删除</name><desc></desc><state>latest</state><visiblerange>public</visiblerange><suptype>_PUBLIC</suptype><supcode>_PUBLIC</supcode><createenv>10.1.80.882883rmcdb</createenv><updateenv>10.1.80.882883rmcdb</updateenv><recmodifyid>admin</recmodifyid><auditorid>admin</auditorid><recmodifydate>2024-10-10 15:45:16:845</recmodifydate><importmodifydate>2024-10-10 15:45:16:845</importmodifydate><changedesc>1</changedesc><module>_public</module><parameter></parameter><relation></relation><detail><![CDATA[<RDP_LOGICINFO><lid>SupplementTaskOneEditSave4</lid><lverno>12</lverno><ltype>0</ltype><usetime>0</usetime><errormsg></errormsg><sqlexecutetype>1</sqlexecutetype><lbody><delete>
  delete from rmc_imput_tmpconf_verificationrules where taskcode = #{detailTable0.taskcode} 
</delete></lbody><lbodyDbt></lbodyDbt><lbodyOra></lbodyOra><lbodyMysql></lbodyMysql></RDP_LOGICINFO>]]></detail></product><product><type>log</type><code>SupplementTaskOneEditSave5</code><version>14</version><name>数据补录任务管理维护限制信息保存</name><desc></desc><state>latest</state><visiblerange>public</visiblerange><suptype>_PUBLIC</suptype><supcode>_PUBLIC</supcode><createenv>10.1.80.882883rmcdb</createenv><updateenv>10.1.80.882883rmcdb</updateenv><recmodifyid>admin</recmodifyid><auditorid>admin</auditorid><recmodifydate>2024-10-18 10:39:55:681</recmodifydate><importmodifydate>2024-10-18 10:39:55:681</importmodifydate><changedesc>1</changedesc><module>_public</module><parameter></parameter><relation></relation><detail><![CDATA[<RDP_LOGICINFO><lid>SupplementTaskOneEditSave5</lid><lverno>14</lverno><ltype>0</ltype><usetime>0</usetime><errormsg></errormsg><sqlexecutetype>1</sqlexecutetype><lbody><insert id="SupplementTaskOneEditSave5">
<if test="multiTable0 != null  and multiTable0.size() !=0 ">
		INSERT INTO rmc_imput_tmpconf_verificationrules
(taskcode,tmpcode,tmpverificationcode,tmpverificationname,tmpverrowcoltype,vertimmer,tmpverrowrange,tmpvercolumnrange,checktype,datatype,excelformula,sqlcode,exceedtype,errormsgtmplate)
		<foreach collection="multiTable0" item="item" index="idx" open="(" close=")" separator=" union all ">
				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
		</foreach>
</if>
<if test="multiTable0 == null or  multiTable0.size() == 0 ">
 select '1' from dual
</if>
</insert></lbody><lbodyDbt></lbodyDbt><lbodyOra></lbodyOra><lbodyMysql></lbodyMysql></RDP_LOGICINFO>]]></detail></product><product><type>logs</type><code>SupplementTaskOneEditSave</code><version>8</version><name>数据补录任务管理维护保存</name><desc></desc><state>latest</state><visiblerange>public</visiblerange><suptype>rdp</suptype><supcode>SupplementTaskOneEdit</supcode><createenv>10.1.80.882883rmcdb</createenv><updateenv>10.1.80.882883rmcdb</updateenv><recmodifyid>admin</recmodifyid><auditorid>admin</auditorid><recmodifydate>2024-10-20 16:54:39:430</recmodifydate><importmodifydate>2024-10-20 16:54:39:430</importmodifydate><changedesc>1</changedesc><module>_public</module><parameter></parameter><relation><product><type>log</type><code>SupplementTaskOneEditCheck</code><version>8</version></product><product><type>log</type><code>SupplementTaskOneEditSave1</code><version>31</version></product><product><type>log</type><code>SupplementTaskOneEditSave2</code><version>6</version></product><product><type>log</type><code>SupplementTaskOneEditSave3</code><version>24</version></product><product><type>log</type><code>SupplementTaskOneEditSave4</code><version>12</version></product><product><type>log</type><code>SupplementTaskOneEditSave5</code><version>14</version></product></relation><detail><![CDATA[<RDP_LOGICSINFO><lid>SupplementTaskOneEditSave</lid><lverno>8</lverno><ltype>9</ltype><usetime>0</usetime><lbody></lbody><RDP_LOGICSRELATIONS><RDP_LOGICSRELATION><lsid>SupplementTaskOneEditSave</lsid><lsverno>8</lsverno><lid>SupplementTaskOneEditCheck</lid><ono>0</ono><isrstset>1</isrstset><rstsetcode>RstSetSupplementTaskOneEditCheck</rstsetcode></RDP_LOGICSRELATION><RDP_LOGICSRELATION><lsid>SupplementTaskOneEditSave</lsid><lsverno>8</lsverno><lid>SupplementTaskOneEditSave1</lid><ono>1</ono><isrstset>1</isrstset><rstsetcode>RstSetSupplementTaskOneEditSave1</rstsetcode></RDP_LOGICSRELATION><RDP_LOGICSRELATION><lsid>SupplementTaskOneEditSave</lsid><lsverno>8</lsverno><lid>SupplementTaskOneEditSave2</lid><ono>2</ono><isrstset>1</isrstset><rstsetcode>RstSetSupplementTaskOneEditSave2</rstsetcode></RDP_LOGICSRELATION><RDP_LOGICSRELATION><lsid>SupplementTaskOneEditSave</lsid><lsverno>8</lsverno><lid>SupplementTaskOneEditSave3</lid><ono>3</ono><isrstset>1</isrstset><rstsetcode>RstSetSupplementTaskOneEditSave3</rstsetcode></RDP_LOGICSRELATION><RDP_LOGICSRELATION><lsid>SupplementTaskOneEditSave</lsid><lsverno>8</lsverno><lid>SupplementTaskOneEditSave4</lid><ono>4</ono><isrstset>1</isrstset><rstsetcode>RstSetSupplementTaskOneEditSave4</rstsetcode></RDP_LOGICSRELATION><RDP_LOGICSRELATION><lsid>SupplementTaskOneEditSave</lsid><lsverno>8</lsverno><lid>SupplementTaskOneEditSave5</lid><ono>5</ono><isrstset>1</isrstset><rstsetcode>RstSetSupplementTaskOneEditSave5</rstsetcode></RDP_LOGICSRELATION></RDP_LOGICSRELATIONS></RDP_LOGICSINFO>]]></detail></product><product><type>log</type><code>SupplementTaskQuery</code><version>30</version><name>指标数据查询主页面</name><desc></desc><state>latest</state><visiblerange>public</visiblerange><suptype>logs</suptype><supcode>SupplementTaskQuery</supcode><createenv>10.1.80.882883rmcdb</createenv><updateenv>10.1.80.882883rmcdb</updateenv><recmodifyid>admin</recmodifyid><auditorid>admin</auditorid><recmodifydate>2024-11-04 21:25:22:908</recmodifydate><importmodifydate>2024-11-04 21:25:22:908</importmodifydate><changedesc>1</changedesc><module>_public</module><parameter></parameter><relation></relation><detail><![CDATA[<RDP_LOGICINFO><lid>SupplementTaskQuery</lid><lverno>30</lverno><ltype>0</ltype><usetime>0</usetime><errormsg></errormsg><sqlexecutetype>1</sqlexecutetype><lbody><select>
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 
<if test="idx_date != null and idx_date !='' ">
	and a.idx_date = #{idx_date}
</if>
<if test="org_code != null and org_code !='' ">
	and a.org_code in ( ${org_code} )
</if>
<if test=" dime_name != null and dime_name !='' ">
	and c.dime_name like concat('%', #{dime_name}, '%')
</if>

<if test="_datascopeorg != null and _datascopeorg !='' ">
	AND ORG_CODE in (${_datascopeorg}) 
</if>

ORDER by a.idx_value1 DESC
</select></lbody><lbodyDbt></lbodyDbt><lbodyOra></lbodyOra><lbodyMysql></lbodyMysql></RDP_LOGICINFO>]]></detail></product><product><type>logs</type><code>SupplementTaskQuery</code><version>1</version><name>指标数据查询</name><desc></desc><state>latest</state><visiblerange>public</visiblerange><suptype>_PUBLIC</suptype><supcode>_PUBLIC</supcode><createenv>10.1.80.882883rmcdb</createenv><updateenv>10.1.80.882883rmcdb</updateenv><recmodifyid>admin</recmodifyid><auditorid>admin</auditorid><recmodifydate>2024-09-27 10:14:26:740</recmodifydate><importmodifydate>2024-09-27 10:14:26:740</importmodifydate><changedesc>1</changedesc><module>_public</module><parameter></parameter><relation><product><type>log</type><code>SupplementTaskQuery</code><version>30</version></product></relation><detail><![CDATA[<RDP_LOGICSINFO><lid>SupplementTaskQuery</lid><lverno>1</lverno><ltype>9</ltype><usetime>0</usetime><lbody></lbody><RDP_LOGICSRELATIONS><RDP_LOGICSRELATION><lsid>SupplementTaskQuery</lsid><lsverno>1</lsverno><lid>SupplementTaskQuery</lid><ono>0</ono><isrstset>1</isrstset><rstsetcode>RstSetSupplementTaskQuery</rstsetcode></RDP_LOGICSRELATION></RDP_LOGICSRELATIONS></RDP_LOGICSINFO>]]></detail></product><product><type>log</type><code>SupplementTaskQueryList</code><version>36</version><name>数据补录任务管理主页面查询</name><desc></desc><state>latest</state><visiblerange>public</visiblerange><suptype>logs</suptype><supcode>SupplementTaskQueryList</supcode><createenv>10.1.80.882883rmcdb</createenv><updateenv>localhost3306rwa_dev</updateenv><recmodifyid>admin</recmodifyid><auditorid>admin</auditorid><recmodifydate>2025-03-25 20:12:15:596</recmodifydate><importmodifydate>2024-12-26 14:39:19:355</importmodifydate><changedesc>null</changedesc><module>_public</module><parameter></parameter><relation></relation><detail><![CDATA[<RDP_LOGICINFO><lid>SupplementTaskQueryList</lid><lverno>36</lverno><ltype>0</ltype><usetime>0</usetime><errormsg></errormsg><sqlexecutetype>1</sqlexecutetype><lbody><select>
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 
<if test="orgcode != null and orgcode !='' ">
	and a.orgcode in( ${orgcode} )
</if>
<if test="account != null and account !='' ">
	and a.account = #{account}
</if>
<if test="frequency != null and frequency !='' ">
	and a.frequency in (${frequency})
</if>
<if test="tmpcode !=null and tmpcode !=''">
 and m.tmpcode like  concat('%',#{tmpcode},'%')
</if>
<if test="tmpname !=null and tmpname !=''">
 and a.tmpname like  concat('%',#{tmpname},'%')
</if>
<if test="taskcode !=null and taskcode !=''">
 and a.taskcode like  concat('%',#{taskcode},'%')
</if>
<if test="tmpname1 !=null and tmpname1 !=''">
 and m.tmpname2 like  concat('%',#{tmpname1},'%')
</if>
<if test="yesorno1 !=null and yesorno1 !=''">
 and a.yesorno = #{yesorno1}
</if>
ORDER BY a.taskcode desc 
</select></lbody><lbodyDbt></lbodyDbt><lbodyOra></lbodyOra><lbodyMysql></lbodyMysql></RDP_LOGICINFO>]]></detail></product><product><type>logs</type><code>SupplementTaskQueryList</code><version>1</version><name>数据补录任务管理主页面查询</name><desc></desc><state>latest</state><visiblerange>public</visiblerange><suptype>_PUBLIC</suptype><supcode>_PUBLIC</supcode><createenv>10.1.80.882883rmcdb</createenv><updateenv>10.1.80.882883rmcdb</updateenv><recmodifyid>admin</recmodifyid><auditorid>admin</auditorid><recmodifydate>2024-09-29 16:39:12:846</recmodifydate><importmodifydate>2024-09-29 16:39:12:846</importmodifydate><changedesc>1</changedesc><module>_public</module><parameter></parameter><relation><product><type>log</type><code>SupplementTaskQueryList</code><version>36</version></product></relation><detail><![CDATA[<RDP_LOGICSINFO><lid>SupplementTaskQueryList</lid><lverno>1</lverno><ltype>9</ltype><usetime>0</usetime><lbody></lbody><RDP_LOGICSRELATIONS><RDP_LOGICSRELATION><lsid>SupplementTaskQueryList</lsid><lsverno>1</lsverno><lid>SupplementTaskQueryList</lid><ono>0</ono><isrstset>1</isrstset><rstsetcode>RstSetSupplementTaskQueryList</rstsetcode></RDP_LOGICSRELATION></RDP_LOGICSRELATIONS></RDP_LOGICSINFO>]]></detail></product><product><type>log</type><code>SupplementTaskQueryList_no</code><version>1</version><name>数据补录任务管理主页面查询_是否有效-否</name><desc></desc><state>latest</state><visiblerange>public</visiblerange><suptype>_PUBLIC</suptype><supcode>_PUBLIC</supcode><createenv>10.1.80.882883rmcdb</createenv><updateenv>10.1.80.882883rmcdb</updateenv><recmodifyid>admin</recmodifyid><auditorid>admin</auditorid><recmodifydate>2024-10-30 10:34:53:216</recmodifydate><importmodifydate>2024-10-30 10:34:53:216</importmodifydate><changedesc>1</changedesc><module>_public</module><parameter></parameter><relation></relation><detail><![CDATA[<RDP_LOGICINFO><lid>SupplementTaskQueryList_no</lid><lverno>1</lverno><ltype>0</ltype><usetime>0</usetime><errormsg></errormsg><sqlexecutetype>1</sqlexecutetype><lbody><update>
    update rmc_imput_suptaskconf_baseinfo set yesorno = '0' where taskcode = #{taskcode}
</update></lbody><lbodyDbt></lbodyDbt><lbodyOra></lbodyOra><lbodyMysql></lbodyMysql></RDP_LOGICINFO>]]></detail></product><product><type>logs</type><code>SupplementTaskQueryList_no</code><version>1</version><name>SupplementTaskQueryList_no</name><desc></desc><state>latest</state><visiblerange>private</visiblerange><suptype>rdp</suptype><supcode>SupplementTaskQueryList</supcode><createenv>10.1.80.882883rmcdb</createenv><updateenv>10.1.80.882883rmcdb</updateenv><recmodifyid>admin</recmodifyid><auditorid>admin</auditorid><recmodifydate>2024-10-30 10:41:25:134</recmodifydate><importmodifydate>2024-10-30 10:41:25:134</importmodifydate><changedesc>1</changedesc><module>_public</module><parameter></parameter><relation><product><type>log</type><code>SupplementTaskQueryList_no</code><version>1</version></product></relation><detail><![CDATA[<RDP_LOGICSINFO><lid>SupplementTaskQueryList_no</lid><lverno>1</lverno><ltype>9</ltype><usetime>0</usetime><lbody></lbody><RDP_LOGICSRELATIONS><RDP_LOGICSRELATION><lsid>SupplementTaskQueryList_no</lsid><lsverno>1</lsverno><lid>SupplementTaskQueryList_no</lid><ono>0</ono><isrstset>1</isrstset><rstsetcode>RstSetSupplementTaskQueryList_no</rstsetcode></RDP_LOGICSRELATION></RDP_LOGICSRELATIONS></RDP_LOGICSINFO>]]></detail></product><product><type>log</type><code>SupplementTaskQueryList_yes</code><version>1</version><name>数据补录任务管理主页面查询_是否有效-是</name><desc></desc><state>latest</state><visiblerange>public</visiblerange><suptype>_PUBLIC</suptype><supcode>_PUBLIC</supcode><createenv>10.1.80.882883rmcdb</createenv><updateenv>10.1.80.882883rmcdb</updateenv><recmodifyid>admin</recmodifyid><auditorid>admin</auditorid><recmodifydate>2024-10-30 10:33:48:911</recmodifydate><importmodifydate>2024-10-30 10:33:48:911</importmodifydate><changedesc>1</changedesc><module>_public</module><parameter></parameter><relation></relation><detail><![CDATA[<RDP_LOGICINFO><lid>SupplementTaskQueryList_yes</lid><lverno>1</lverno><ltype>0</ltype><usetime>0</usetime><errormsg></errormsg><sqlexecutetype>1</sqlexecutetype><lbody><update>
update rmc_imput_suptaskconf_baseinfo set yesorno = '1' where taskcode = #{taskcode}
</update></lbody><lbodyDbt></lbodyDbt><lbodyOra></lbodyOra><lbodyMysql></lbodyMysql></RDP_LOGICINFO>]]></detail></product><product><type>logs</type><code>SupplementTaskQueryList_yes</code><version>1</version><name>SupplementTaskQueryList_yes</name><desc></desc><state>latest</state><visiblerange>private</visiblerange><suptype>rdp</suptype><supcode>SupplementTaskQueryList</supcode><createenv>10.1.80.882883rmcdb</createenv><updateenv>10.1.80.882883rmcdb</updateenv><recmodifyid>admin</recmodifyid><auditorid>admin</auditorid><recmodifydate>2024-10-30 10:43:20:592</recmodifydate><importmodifydate>2024-10-30 10:43:20:592</importmodifydate><changedesc>1</changedesc><module>_public</module><parameter></parameter><relation><product><type>log</type><code>SupplementTaskQueryList_yes</code><version>1</version></product></relation><detail><![CDATA[<RDP_LOGICSINFO><lid>SupplementTaskQueryList_yes</lid><lverno>1</lverno><ltype>9</ltype><usetime>0</usetime><lbody></lbody><RDP_LOGICSRELATIONS><RDP_LOGICSRELATION><lsid>SupplementTaskQueryList_yes</lsid><lsverno>1</lsverno><lid>SupplementTaskQueryList_yes</lid><ono>0</ono><isrstset>1</isrstset><rstsetcode>RstSetSupplementTaskQueryList_yes</rstsetcode></RDP_LOGICSRELATION></RDP_LOGICSRELATIONS></RDP_LOGICSINFO>]]></detail></product><product><type>log</type><code>SupplementTaskReviewList</code><version>23</version><name>数据补录及审核页面总查询列表页面</name><desc></desc><state>latest</state><visiblerange>public</visiblerange><suptype>logs</suptype><supcode>SupplementTaskReviewList</supcode><createenv>jdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster04</createenv><updateenv>10.1.80.882883rmcdb</updateenv><recmodifyid>admin</recmodifyid><auditorid>admin</auditorid><recmodifydate>2024-11-07 16:44:21:973</recmodifydate><importmodifydate>2024-11-07 16:44:21:973</importmodifydate><changedesc>1</changedesc><module>_public</module><parameter></parameter><relation></relation><detail><![CDATA[<RDP_LOGICINFO><lid>SupplementTaskReviewList</lid><lverno>23</lverno><ltype>0</ltype><usetime>0</usetime><errormsg></errormsg><sqlexecutetype>1</sqlexecutetype><lbody><select id="SupplementTaskReviewList">
	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
<if test="taskStartDate1 != null and taskStartDate1 !='' ">
	and risb.term= #{taskStartDate1}
</if>
<if test="taskCode1 != null and taskCode1 != ''">
	and risb.taskCode = #{taskCode1}
</if>
<if test="_datascopeorg != null and _datascopeorg !='' ">
	AND risb.taskOrgcode in (${_datascopeorg}) 
</if>
<if test="_datascopeaccount != null and _datascopeaccount != '' ">
	AND risb.taskCreatePerson = #{_datascopeaccount}
</if>
	ORDER BY taskStartDate desc ,risb.taskbussinessid desc
</select></lbody><lbodyDbt></lbodyDbt><lbodyOra></lbodyOra><lbodyMysql></lbodyMysql></RDP_LOGICINFO>]]></detail></product><product><type>logs</type><code>SupplementTaskReviewList</code><version>1</version><name>数据补录及审核页面总查询列表页面</name><desc></desc><state>latest</state><visiblerange>public</visiblerange><suptype>_PUBLIC</suptype><supcode>_PUBLIC</supcode><createenv>jdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster04</createenv><updateenv>jdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster04</updateenv><recmodifyid>admin</recmodifyid><auditorid>admin</auditorid><recmodifydate>2024-09-24 15:46:27:712</recmodifydate><importmodifydate>2024-09-24 15:46:27:712</importmodifydate><changedesc>1</changedesc><module>_public</module><parameter></parameter><relation><product><type>log</type><code>SupplementTaskReviewList</code><version>23</version></product></relation><detail><![CDATA[<RDP_LOGICSINFO><lid>SupplementTaskReviewList</lid><lverno>1</lverno><ltype>9</ltype><usetime>0</usetime><lbody></lbody><RDP_LOGICSRELATIONS><RDP_LOGICSRELATION><lsid>SupplementTaskReviewList</lsid><lsverno>1</lsverno><lid>SupplementTaskReviewList</lid><ono>0</ono><isrstset>1</isrstset><rstsetcode>RstSetSupplementTaskReviewList</rstsetcode></RDP_LOGICSRELATION></RDP_LOGICSRELATIONS></RDP_LOGICSINFO>]]></detail></product></root>