Supplement-group-1.cfg 42 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307
  1. <?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>
  2. select distinct a.term,a.taskstartdate,d.tmpname taskcode,
  3. CASE WHEN b.cnname IS NULL THEN ' ' else b.cnname END as taskfirstperson,
  4. c.nounname taskstatus,a.taskbussinessid , a.taskstatus as status
  5. from rmc_imput_suptaskrun_bussinessinfo a
  6. left join sys_user b on a.taskfirstperson = b.account
  7. left join sys_noun c on a.taskstatus = c.nounvalue and c.nounitem = 'taskStatus'
  8. left join rmc_imput_suptaskconf_baseinfo d on a.taskcode = d.taskcode
  9. left join rmc_input_suptaskrun_baseinfo rinsb on rinsb.taskbussinessid = a.taskbussinessid
  10. where 1=1
  11. <if test="taskstartdate1 != null and taskstartdate1 !='' ">
  12. and a.term = #{taskstartdate1}
  13. </if>
  14. <if test="taskcode != null and taskcode !='' ">
  15. and d.taskcode in ('${taskcode}')
  16. </if>
  17. order by a.taskstatus ASC,a.term ASC,a.taskstartdate ASC,d.tmpname ASC
  18. </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>
  19. select
  20. sbi.taskbussinessid as taskbussinessid,
  21. sbi.term as term,
  22. sbi.taskCode as taskCode,
  23. isb.tmpname as taskCodeName,
  24. rist.tmpCode ,
  25. case when tb.tmpName is null then sn.nounname else tb.tmpName end as tmpCodeName,
  26. sbd.tmpRemark ,
  27. sbi.taskStartDate ,
  28. sbi.taskOrgcode ,
  29. so.orgName as taskOrgcodeName,
  30. sbi.taskFirstPerson ,
  31. suf.cnname as taskFirstPersonName ,
  32. sbi.taskReviewedPerson ,
  33. sur.cnname as taskReviewedPersonName ,
  34. risbf.flowbussinessid ,case when tb.tmpName is null then 1 else 0 end as isIndex
  35. from rmc_imput_suptaskrun_bussinessinfo sbi
  36. left join rmc_imput_suptaskrun_tmprelas rist on sbi.taskbussinessid = rist.taskbussinessid
  37. left join rmc_imput_suptaskrun_bussinessdetail sbd on sbi.taskbussinessid = sbd.taskbussinessid and sbi.taskCode = sbd.taskCode and rist.tmpCode = sbd.tmpCode
  38. left join rmc_imput_tmpconf_baseinfo tb on rist.tmpCode = tb.tmpcode
  39. left join sys_noun sn on sn.nounitem = 'TMP-INDEX-NOUN' and sn.nounvalue = rist.tmpcode
  40. left join rmc_imput_suptaskconf_baseinfo isb on isb.taskCode = sbi.taskCode
  41. left join sys_user suf on sbi.taskFirstPerson = suf.ACCOUNT
  42. left join sys_user sur on sbi.taskReviewedPerson = sur.ACCOUNT
  43. left join sys_organization so on sbi.taskOrgcode = so.ORGCODE
  44. left join rmc_imput_suptaskrun_bussinessflowinfo risbf on sbi.taskbussinessid = risbf.taskbussinessid
  45. where 1=1
  46. and sbi.taskStatus = '04'
  47. <if test="termParam !='' and termParam !=null">
  48. and sbi.term = #{termParam}
  49. </if>
  50. <if test="tmpCodesParam !='' and tmpCodesParam !=null">
  51. and rist.tmpCode in ( ${tmpCodesParam} )
  52. </if>
  53. <if test="_datascopeorg != null and _datascopeorg !='' ">
  54. AND risb.taskOrgcode in (${_datascopeorg)
  55. </if>
  56. <if test="_datascopeaccount != null and _datascopeaccount != '' ">
  57. AND sbi.taskReviewedPerson = #{_datascopeaccount}
  58. </if>
  59. <if test="_datascopeorg != null and _datascopeorg !='' ">
  60. AND suf.orgcode in (${_datascopeorg)
  61. </if>
  62. order by sbi.taskbussinessid desc, sbi.term desc , sbi.taskStartDate desc
  63. </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>
  64. select distinct a.taskbussinessid,a.flowbussinessid,a.flowid,a.Account,d.plaitperson,
  65. su.cnname,a.orgcode,c.orgname,e.rolename,d.plaitdate,
  66. d.POSTID,
  67. case when d.POSTID = 'A01' then null else sn.NOUNNAME end as verifymark ,
  68. case when d.POSTID = 'A01' then null else t.approvalRemark end as remark ,
  69. f.nounname as naouname1 ,
  70. case when d.POSTID = 'A01' then '提交' else '审核' end as naouname ,
  71. d.curdeptcode , c2.orgname as curdeptcodename ,
  72. d.NODEDEPTCODE , so.orgname as orgname2
  73. from rmc_imput_suptaskrun_bussinessflowinfo a
  74. left join sys_user b on a.Account = b.account
  75. left join sys_organization c on a.orgcode = c.orgcode
  76. left join wfs_flowinfomanage d on a.flowbussinessid = d.businessinsid
  77. left join sys_user su on su.account = d.plaitperson
  78. left join sys_organization c2 on d.curdeptcode = c2.orgcode
  79. left join sys_noun f on d.status = f.nounvalue and f.nounitem = 'TASKLISTSTATE'
  80. left join sys_role e on d.pointid= e.roleid
  81. left join sys_imput_suptaskconf_flowapproval_his t on t.bussinessid = a.flowbussinessid and t.SOLEORDERID = d.SOLEORDERID
  82. left join sys_noun sn on t.approvalType = sn.NOUNVALUE and sn.NOUNITEM = 'APPROVALTYPE'
  83. left join sys_organization so on d.NODEDEPTCODE = so.orgcode
  84. where 1=1
  85. <if test="taskbussinessid != null and taskbussinessid !='' ">
  86. and taskbussinessid = #{taskbussinessid}
  87. </if>
  88. order by d.plaitdate
  89. </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>
  90. select a.taskcode,a.tmpcode,b.tmpname,a.remark,a.sqlcode
  91. from rmc_imput_suptaskconf_relatedinfo a
  92. left join rmc_imput_tmpconf_baseinfo b on a.tmpcode =b.tmpcode
  93. where 1=1 and a.taskcode = #{taskcode}
  94. </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>
  95. select a.taskcode, a.tmpcode,b.tmpname,a.tmpverrowcoltype,a.vertimmer,a.tmpverrowrange,
  96. a.tmpvercolumnrange,a.checktype,a.datatype,a.excelformula,a.sqlcode,a.exceedtype,a.errormsgtmplate,a.tmpverificationcode,a.tmpverificationname
  97. from rmc_imput_tmpconf_verificationrules a
  98. left join rmc_imput_tmpconf_baseinfo b on a.tmpcode =b.tmpcode
  99. left join sys_noun c on a.tmpverrowcoltype = c.nounvalue and c.nounitem = 'tmpverrowcoltype'
  100. left join sys_noun d on a.vertimmer = d.nounvalue and d.nounitem = 'vertimmer'
  101. left join sys_noun e on a.checktype = e.nounvalue and e.nounitem = 'checktype'
  102. left join sys_noun f on a.exceedtype = f.nounvalue and f.nounitem = 'exceedtype'
  103. where 1=1 and a.taskcode = #{taskcode}
  104. </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">
  105. <if test="detailTable0.anamode=='add'">
  106. <![CDATA[
  107. select case when a.num>0 then '2' else '0' end as flag,case when a.num>0 then '任务编号已存在,请重新输入' else '' end as checkmsg from
  108. (select count(1) as num from rmc_imput_suptaskconf_baseinfo where taskcode =#{detailTable0.taskcode}) a
  109. @]@]@>
  110. </if>
  111. <if test="detailTable0.anamode=='modify'">
  112. select '0' as flag,'' as checkmsg from dual
  113. </if>
  114. </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>
  115. <if test="detailTable0.anamode=='add'">
  116. insert into rmc_imput_suptaskconf_baseinfo(taskcode,tmpname,orgcode,account,frequency,adjustment,ischeck, yesorno )
  117. values (#{detailTable0.taskcode},#{detailTable0.tmpname},#{detailTable0.orgcode},#{detailTable0.account},#{detailTable0.frequency},#{detailTable0.adjustment},#{detailTable0.ischeck} , '1')
  118. </if>
  119. <if test="detailTable0.anamode=='modify'">
  120. update rmc_imput_suptaskconf_baseinfo set
  121. tmpname=#{detailTable0.tmpname},orgcode=#{detailTable0.orgcode}, account=#{detailTable0.account},
  122. frequency=#{detailTable0.frequency},adjustment=#{detailTable0.adjustment},ischeck=#{detailTable0.ischeck} , yesorno = '1'
  123. where taskcode=#{detailTable0.taskcode}
  124. </if>
  125. </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>
  126. delete from rmc_imput_suptaskconf_relatedinfo where taskcode = #{detailTable0.taskcode}
  127. </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">
  128. <if test="multiTable1 != null and multiTable1.size() !=0 ">
  129. INSERT INTO rmc_imput_suptaskconf_relatedinfo
  130. (taskcode,tmpcode,sqlcode,remark)
  131. <foreach collection="multiTable1" item="item" index="idx" open="(" close=")" separator=" union all ">
  132. select #{detailTable0.taskcode},#{item.tmpcode},#{item.sqlcode},#{item.remark} from dual
  133. </foreach>
  134. </if>
  135. <if test="multiTable1 == null or multiTable1.size() == 0 ">
  136. select '1' from dual
  137. </if>
  138. </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>
  139. delete from rmc_imput_tmpconf_verificationrules where taskcode = #{detailTable0.taskcode}
  140. </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">
  141. <if test="multiTable0 != null and multiTable0.size() !=0 ">
  142. INSERT INTO rmc_imput_tmpconf_verificationrules
  143. (taskcode,tmpcode,tmpverificationcode,tmpverificationname,tmpverrowcoltype,vertimmer,tmpverrowrange,tmpvercolumnrange,checktype,datatype,excelformula,sqlcode,exceedtype,errormsgtmplate)
  144. <foreach collection="multiTable0" item="item" index="idx" open="(" close=")" separator=" union all ">
  145. 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
  146. </foreach>
  147. </if>
  148. <if test="multiTable0 == null or multiTable0.size() == 0 ">
  149. select '1' from dual
  150. </if>
  151. </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>
  152. select a.idx_date,a.org_code,a.org_name,a.idx_code,b.idx_name,c.dime_name,a.last_year_val,
  153. case when ROUND(a.idx_value1, 2) is null then '0'
  154. else ROUND(a.idx_value1, 2)
  155. end as idx_value1,
  156. case when ROUND(a.idx_value1-a.last_day_val, 2) is null then '0'
  157. else ROUND(a.idx_value1-a.last_day_val, 2)
  158. end as idx_value2,
  159. case when ROUND((a.idx_value1-a.last_day_val)/ a.last_day_val, 2) is null then '0'
  160. else ROUND((a.idx_value1-a.last_day_val)/ a.last_day_val, 2)
  161. end as idx_value3,
  162. case when ROUND(a.idx_value1-a.last_mohth_val, 2) is null then '0'
  163. else ROUND(a.idx_value1-a.last_mohth_val, 2)
  164. end as idx_value4,
  165. case when ROUND((a.idx_value1-a.last_mohth_val)/ a.last_mohth_val, 2) is null then '0'
  166. else ROUND((a.idx_value1-a.last_mohth_val)/ a.last_mohth_val, 2)
  167. end as idx_value5,
  168. case when ROUND(a.idx_value1-a.last_year_val, 2) is null then '0'
  169. else ROUND(a.idx_value1-a.last_year_val, 2)
  170. end as idx_value6,
  171. case when ROUND((a.idx_value1-a.last_year_val)/ a.last_year_val, 2) is null then '0'
  172. else ROUND((a.idx_value1-a.last_year_val)/ a.last_year_val, 2)
  173. end as idx_value7,
  174. case when ROUND(a.idx_value1-a.last_12mohth_val, 2) is null then '0'
  175. else ROUND(a.idx_value1-a.last_12mohth_val, 2)
  176. end as idx_value8,
  177. case when ROUND((a.idx_value1-a.last_12mohth_val)/ a.last_12mohth_val, 2) is null then '0'
  178. else ROUND((a.idx_value1-a.last_12mohth_val)/ a.last_12mohth_val, 2)
  179. end as idx_value9
  180. from rdc_idx_org_index a
  181. left join RMC_IDX_BASEINFO b on a.IDX_CODE = b.IDX_CODE
  182. left join rmc_idx_dimension c on b.IDX_CODE = c.IDX_CODE
  183. where 1=1
  184. <if test="idx_date != null and idx_date !='' ">
  185. and a.idx_date = #{idx_date}
  186. </if>
  187. <if test="org_code != null and org_code !='' ">
  188. and a.org_code in ( ${org_code} )
  189. </if>
  190. <if test=" dime_name != null and dime_name !='' ">
  191. and c.dime_name like concat('%', #{dime_name}, '%')
  192. </if>
  193. <if test="_datascopeorg != null and _datascopeorg !='' ">
  194. AND ORG_CODE in (${_datascopeorg})
  195. </if>
  196. ORDER by a.idx_value1 DESC
  197. </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>
  198. select a.taskcode,a.tmpname,a.orgcode,b.orgname,a.account,c.cnname,d.nounname frequency,adjustment, a.yesorno, e.nounname as yesornoname ,
  199. case when a.ischeck = '0' then '否' else '是' end ischeck,m. tmpname2
  200. from rmc_imput_suptaskconf_baseinfo a
  201. left join (
  202. select distinct risr.taskcode,risr.tmpcode,risr.sqlcode,risr.remark,itbsys.taskcode222,itbsys.remark222
  203. ,GROUP_CONCAT(itbsys.remark222 SEPARATOR ',') as tmpname2
  204. from rmc_imput_suptaskconf_relatedinfo risr
  205. left join ( select
  206. id as taskcode222,
  207. text as remark222
  208. from ( select itb.tmpcode as ID, itb.tmpname as TEXT
  209. from rmc_imput_tmpconf_baseinfo itb
  210. union all
  211. select x.NOUNVALUE as ID , x.NOUNNAME as TEXT
  212. from sys_noun x
  213. where
  214. x.NOUNITEM = 'TMP-INDEX-NOUN'
  215. and x.NOUNSUPER = 'TMP-INDEX-NOUN'
  216. and x.NOUNVALIDITY = '1'
  217. ) xitb ) itbsys on itbsys.taskcode222 = risr.tmpcode
  218. group by risr.taskcode
  219. ) m on a.taskcode = m.taskcode
  220. left join sys_organization b on a.orgcode = b.orgcode
  221. left join sys_user c on a.account = c.account
  222. left join sys_noun d on a.frequency = d.nounvalue and d.nounitem = 'frequency'
  223. left join sys_noun e on a.yesorno = e.nounvalue and e.nounitem = 'YESORNO'
  224. where 1=1
  225. <if test="orgcode != null and orgcode !='' ">
  226. and a.orgcode in( ${orgcode} )
  227. </if>
  228. <if test="account != null and account !='' ">
  229. and a.account = #{account}
  230. </if>
  231. <if test="frequency != null and frequency !='' ">
  232. and a.frequency in (${frequency})
  233. </if>
  234. <if test="tmpcode !=null and tmpcode !=''">
  235. and m.tmpcode like concat('%',#{tmpcode},'%')
  236. </if>
  237. <if test="tmpname !=null and tmpname !=''">
  238. and a.tmpname like concat('%',#{tmpname},'%')
  239. </if>
  240. <if test="taskcode !=null and taskcode !=''">
  241. and a.taskcode like concat('%',#{taskcode},'%')
  242. </if>
  243. <if test="tmpname1 !=null and tmpname1 !=''">
  244. and m.tmpname2 like concat('%',#{tmpname1},'%')
  245. </if>
  246. <if test="yesorno1 !=null and yesorno1 !=''">
  247. and a.yesorno = #{yesorno1}
  248. </if>
  249. ORDER BY a.taskcode desc
  250. </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>
  251. update rmc_imput_suptaskconf_baseinfo set yesorno = '0' where taskcode = #{taskcode}
  252. </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>
  253. update rmc_imput_suptaskconf_baseinfo set yesorno = '1' where taskcode = #{taskcode}
  254. </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">
  255. select
  256. distinct risb.taskbussinessid,
  257. risb.term,
  258. risb.taskCode,
  259. isb.tmpname as taskCodeName,
  260. risb.taskVersion,
  261. risb.taskStatus,
  262. risb.taskStartDate,
  263. risb.taskUpdateDate,
  264. risb.taskOrgcode,
  265. risb.taskCreatePerson,
  266. risb.taskUpdatePerson,
  267. risb.taskFirstPerson,
  268. risb.taskReviewedPerson,
  269. su1.cnname as taskCreatePersonName,
  270. su2.cnname as taskUpdatePersonName,
  271. su3.cnname as taskFirstPersonName,
  272. su4.cnname as taskReviewedPersonName,
  273. risb.remark,
  274. sn.nounname as taskStatusName ,
  275. risbf.flowbussinessid ,
  276. todotask.status as flowStatus,
  277. todotask.account as flowAccount,
  278. case
  279. when todotask.status is not null then todotask.soleorderid
  280. else 0
  281. end as soleorderid
  282. from rmc_imput_suptaskrun_bussinessinfo risb
  283. left join rmc_imput_suptaskconf_baseinfo isb on isb.taskCode = risb.taskCode
  284. left join rmc_imput_suptaskrun_bussinessflowinfo risbf on risb.taskbussinessid = risbf.taskbussinessid
  285. left join sys_user su1 on risb.taskCreatePerson = su1.account
  286. left join sys_user su2 on risb.taskUpdatePerson = su2.account
  287. left join sys_user su3 on risb.taskFirstPerson = su3.account
  288. left join sys_user su4 on risb.taskReviewedPerson = su4.account
  289. left join sys_noun sn on sn.NOUNITEM = 'taskStatus' and sn.NOUNVALUE = risb.taskStatus
  290. left join v_wfs_todotask todotask on todotask.account=#{currentAccount} and todotask.businesstypeid = '0001' and risbf.flowbussinessid = todotask.businessinsid
  291. where 1=1
  292. <if test="taskStartDate1 != null and taskStartDate1 !='' ">
  293. and risb.term= #{taskStartDate1}
  294. </if>
  295. <if test="taskCode1 != null and taskCode1 != ''">
  296. and risb.taskCode = #{taskCode1}
  297. </if>
  298. <if test="_datascopeorg != null and _datascopeorg !='' ">
  299. AND risb.taskOrgcode in (${_datascopeorg})
  300. </if>
  301. <if test="_datascopeaccount != null and _datascopeaccount != '' ">
  302. AND risb.taskCreatePerson = #{_datascopeaccount}
  303. </if>
  304. ORDER BY taskStartDate desc ,risb.taskbussinessid desc
  305. </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>