Startsida Utforska Hjälp
Registrera dig Logga in
RWA
/
RWAServer
3
2
Fork 0
Filer Ärenden 0 Pull-förfrågningar 0 Wiki
Träd: c9dea2c04d
Grenar Taggar
RWAServer
/
ShortCode
/
001-初始化
/
李庚谱
/
补录功能
/
SupplementTaskQueryList.cfg

SupplementTaskQueryList.cfg 74 KB
Historik Rå

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144 
  1. <?xml version="1.0" encoding="UTF-8"?><root><product><type>log</type><code>SupplementTaskQueryList</code><version>35</version><name>数据补录任务管理主页面查询</name><desc></desc><state>latest</state><visiblerange>public</visiblerange><suptype>logs</suptype><supcode>SupplementTaskQueryList</supcode><createenv>10.1.80.882883rmcdb</createenv><updateenv>10.1.80.882883rmcdb</updateenv><recmodifyid>admin</recmodifyid><auditorid>admin</auditorid><recmodifydate>2024-12-26 14:39:19:355</recmodifydate><importmodifydate>2024-12-26 14:39:19:355</importmodifydate><changedesc>1</changedesc><module>_public</module><parameter></parameter><relation></relation><detail><![CDATA[<RDP_LOGICINFO><lid>SupplementTaskQueryList</lid><lverno>35</lverno><ltype>0</ltype><usetime>0</usetime><errormsg></errormsg><sqlexecutetype>1</sqlexecutetype><lbody><select>
    2. 

  2. select a.taskcode,a.tmpname,a.orgcode,b.orgname,a.account,c.cnname,d.nounname frequency,adjustment, a.yesorno, e.nounname as yesornoname ,
    3. 

  3. case when a.ischeck = '0' then '否' else '是' end ischeck,m. tmpname2 
    4. 

  4. from rmc_imput_suptaskconf_baseinfo a 
    5. 

  5. left join ( 
    6. 

  6. select distinct risr.taskcode,risr.tmpcode,risr.sqlcode,risr.remark,itbsys.taskcode222,itbsys.remark222
    7. 

  7. ,GROUP_CONCAT(itbsys.remark222  SEPARATOR  ',') as  tmpname2 
    8. 

  8. from rmc_imput_suptaskconf_relatedinfo risr
    9. 

  9. left join ( select
    10. 

  10. 	id as taskcode222,
    11. 

  11. 	text as remark222
    12. 

  12. from ( select itb.tmpcode as ID, itb.tmpname as TEXT
    13. 

  13. 	from rmc_imput_tmpconf_baseinfo itb
    14. 

  14. union all
    15. 

  15. 	select x.NOUNVALUE as ID , x.NOUNNAME as TEXT
    16. 

  16. 	from sys_noun x
    17. 

  17. 	where
    18. 

  18. 		x.NOUNITEM = 'TMP-INDEX-NOUN'
    19. 

  19. 		and x.NOUNSUPER = 'TMP-INDEX-NOUN'
    20. 

  20. 		and x.NOUNVALIDITY = '1' 
    21. 

  21. )) itbsys on itbsys.taskcode222 = risr.tmpcode 
    22. 

  22. group by risr.taskcode
    23. 

  23. ) m on a.taskcode = m.taskcode 
    24. 

  24. left join sys_organization b on a.orgcode = b.orgcode 
    25. 

  25. left join sys_user c on a.account = c.account 
    26. 

  26. left join sys_noun d on a.frequency = d.nounvalue and d.nounitem = 'frequency'  
    27. 

  27. left join sys_noun e on a.yesorno = e.nounvalue and e.nounitem = 'YESORNO'   
    28. 

  28. where 1=1 
    29. 

  29. <if test="orgcode != null and orgcode !='' ">
    30. 

  30. 	and a.orgcode in( ${orgcode} )
    31. 

  31. </if>
    32. 

  32. <if test="account != null and account !='' ">
    33. 

  33. 	and a.account = #{account}
    34. 

  34. </if>
    35. 

  35. <if test="frequency != null and frequency !='' ">
    36. 

  36. 	and a.frequency in (${frequency})
    37. 

  37. </if>
    38. 

  38. <if test="tmpcode !=null and tmpcode !=''">
    39. 

  39.  and m.tmpcode like  concat('%',#{tmpcode},'%')
    40. 

  40. </if>
    41. 

  41. <if test="tmpname !=null and tmpname !=''">
    42. 

  42.  and a.tmpname like  concat('%',#{tmpname},'%')
    43. 

  43. </if>
    44. 

  44. <if test="taskcode !=null and taskcode !=''">
    45. 

  45.  and a.taskcode like  concat('%',#{taskcode},'%')
    46. 

  46. </if>
    47. 

  47. <if test="tmpname1 !=null and tmpname1 !=''">
    48. 

  48.  and m.tmpname2 like  concat('%',#{tmpname1},'%')
    49. 

  49. </if>
    50. 

  50. <if test="yesorno1 !=null and yesorno1 !=''">
    51. 

  51.  and a.yesorno = #{yesorno1}
    52. 

  52. </if>
    53. 

  53. ORDER BY a.taskcode desc 
    54. 

  54. </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>35</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>
    55. 

  55.     update rmc_imput_suptaskconf_baseinfo set yesorno = '0' where taskcode = #{taskcode}
    56. 

  56. </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>
    57. 

  57. update rmc_imput_suptaskconf_baseinfo set yesorno = '1' where taskcode = #{taskcode}
    58. 

  58. </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>ExcelTmpQueryNoun</code><version>7</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>10.1.80.882883rmcdb</updateenv><recmodifyid>li_gpu</recmodifyid><auditorid>li_gpu</auditorid><recmodifydate>2024-10-30 19:40:32:254</recmodifydate><importmodifydate>2024-10-30 19:40:32:254</importmodifydate><changedesc>2024-10-30</changedesc><module>_public</module><parameter></parameter><relation></relation><detail><![CDATA[<RDP_LOGICINFO><lid>ExcelTmpQueryNoun</lid><lverno>7</lverno><ltype>0</ltype><usetime>0</usetime><errormsg></errormsg><sqlexecutetype>1</sqlexecutetype><lbody><select>
    59. 

  59.    <![CDATA[
    60. 

  60. select id,text from (
    61. 

  61. select itb.tmpcode as ID, itb.tmpname  as TEXT from rmc_imput_tmpconf_baseinfo itb
    62. 

  62. union all 
    63. 

  63. 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' 
    64. 

  64. ) order by id
    65. 

  65.    @]@]@> 
    66. 

  66. </select></lbody><lbodyDbt></lbodyDbt><lbodyOra></lbodyOra><lbodyMysql></lbodyMysql></RDP_LOGICINFO>]]></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>
    67. 

  67.    select a.taskcode,a.tmpcode,b.tmpname,a.remark,a.sqlcode    
    68. 

  68. from rmc_imput_suptaskconf_relatedinfo a 
    69. 

  69. left join rmc_imput_tmpconf_baseinfo b on a.tmpcode =b.tmpcode 
    70. 

  70. where 1=1  and a.taskcode = #{taskcode} 
    71. 

  71. </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>
    72. 

  72.   select a.taskcode, a.tmpcode,b.tmpname,a.tmpverrowcoltype,a.vertimmer,a.tmpverrowrange,
    73. 

  73. a.tmpvercolumnrange,a.checktype,a.datatype,a.excelformula,a.sqlcode,a.exceedtype,a.errormsgtmplate,a.tmpverificationcode,a.tmpverificationname 
    74. 

  74. from rmc_imput_tmpconf_verificationrules a 
    75. 

  75. left join rmc_imput_tmpconf_baseinfo b on a.tmpcode =b.tmpcode 
    76. 

  76. left join sys_noun c on a.tmpverrowcoltype = c.nounvalue and c.nounitem = 'tmpverrowcoltype'
    77. 

  77. left join sys_noun d on a.vertimmer = d.nounvalue and d.nounitem = 'vertimmer'
    78. 

  78. left join sys_noun e on a.checktype = e.nounvalue and e.nounitem = 'checktype'
    79. 

  79. left join sys_noun f on a.exceedtype = f.nounvalue and f.nounitem = 'exceedtype'
    80. 

  80. where 1=1  and a.taskcode = #{taskcode} 
    81. 

  81. </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">
    82. 

  82. <if test="detailTable0.anamode=='add'">
    83. 

  83. <![CDATA[
    84. 

  84. select case when a.num>0 then '2' else '0' end as flag,case when a.num>0 then '任务编号已存在，请重新输入' else '' end as checkmsg from 
    85. 

  85. (select count(1) as num from rmc_imput_suptaskconf_baseinfo where taskcode =#{detailTable0.taskcode}) a
    86. 

  86. @]@]@>
    87. 

  87. </if>
    88. 

  88. <if test="detailTable0.anamode=='modify'">
    89. 

  89.   select '0' as flag,'' as checkmsg from dual
    90. 

  90. </if>
    91. 

  91. </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>
    92. 

  92. <if test="detailTable0.anamode=='add'">
    93. 

  93. insert into  rmc_imput_suptaskconf_baseinfo(taskcode,tmpname,orgcode,account,frequency,adjustment,ischeck, yesorno )
    94. 

  94. values (#{detailTable0.taskcode},#{detailTable0.tmpname},#{detailTable0.orgcode},#{detailTable0.account},#{detailTable0.frequency},#{detailTable0.adjustment},#{detailTable0.ischeck} , '1')
    95. 

  95. </if>
    96. 

  96. <if test="detailTable0.anamode=='modify'">
    97. 

  97.   update rmc_imput_suptaskconf_baseinfo set 
    98. 

  98.    tmpname=#{detailTable0.tmpname},orgcode=#{detailTable0.orgcode}, account=#{detailTable0.account},
    99. 

  99.    frequency=#{detailTable0.frequency},adjustment=#{detailTable0.adjustment},ischeck=#{detailTable0.ischeck} , yesorno = '1'
    100. 

  100.    where taskcode=#{detailTable0.taskcode} 
    101. 

  101. </if>
    102. 

  102. </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>
    103. 

  103.  delete from rmc_imput_suptaskconf_relatedinfo where taskcode = #{detailTable0.taskcode} 
    104. 

  104. </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">
    105. 

  105. <if test="multiTable1 != null and  multiTable1.size() !=0 ">
    106. 

  106. 		INSERT INTO rmc_imput_suptaskconf_relatedinfo
    107. 

  107. 		(taskcode,tmpcode,sqlcode,remark)
    108. 

  108. 		<foreach collection="multiTable1" item="item" index="idx" open="(" close=")" separator=" union all ">
    109. 

  109. 				select #{detailTable0.taskcode},#{item.tmpcode},#{item.sqlcode},#{item.remark} from dual
    110. 

  110. 		</foreach>
    111. 

  111. </if>
    112. 

  112. <if test="multiTable1 == null or  multiTable1.size() == 0 ">
    113. 

  113.  select '1' from dual
    114. 

  114. </if>
    115. 

  115. </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>
    116. 

  116.   delete from rmc_imput_tmpconf_verificationrules where taskcode = #{detailTable0.taskcode} 
    117. 

  117. </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">
    118. 

  118. <if test="multiTable0 != null  and multiTable0.size() !=0 ">
    119. 

  119. 		INSERT INTO rmc_imput_tmpconf_verificationrules
    120. 

  120. (taskcode,tmpcode,tmpverificationcode,tmpverificationname,tmpverrowcoltype,vertimmer,tmpverrowrange,tmpvercolumnrange,checktype,datatype,excelformula,sqlcode,exceedtype,errormsgtmplate)
    121. 

  121. 		<foreach collection="multiTable0" item="item" index="idx" open="(" close=")" separator=" union all ">
    122. 

  122. 				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
    123. 

  123. 		</foreach>
    124. 

  124. </if>
    125. 

  125. <if test="multiTable0 == null or  multiTable0.size() == 0 ">
    126. 

  126.  select '1' from dual
    127. 

  127. </if>
    128. 

  128. </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>SupplementTaskUserQuery</code><version>8</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.1572883rdcdb</updateenv><recmodifyid>admin</recmodifyid><auditorid>admin</auditorid><recmodifydate>2024-12-26 14:47:53:718</recmodifydate><importmodifydate>2024-12-26 14:47:53:718</importmodifydate><changedesc>1</changedesc><module>_public</module><parameter></parameter><relation></relation><detail><![CDATA[<RDP_LOGICINFO><lid>SupplementTaskUserQuery</lid><lverno>8</lverno><ltype>0</ltype><usetime>0</usetime><errormsg></errormsg><sqlexecutetype>1</sqlexecutetype><lbody><select>
    129. 

  129. select a.account,a.cnname,d.ORGNAME orgcode,c.ORGNAME  deptcode  
    130. 

  130. from sys_user a 
    131. 

  131. left join sys_user_role b on a.account = b.account 
    132. 

  132. left join sys_organization c on a.orgcode = c.orgcode 
    133. 

  133. left join sys_organization d on c.SUPERORGCODE = d.orgcode
    134. 

  134. where b.ROLEID ='zhsjbly'  
    135. 

  135. <if test="orgcode != null and orgcode !='' ">
    136. 

  136. 	and (a.orgcode = #{orgcode} or c.SUPERORGCODE = #{orgcode})
    137. 

  137. </if>
    138. 

  138. <if test="account != null and account !='' ">
    139. 

  139. 	and a.account  like  concat('%',#{account},'%')
    140. 

  140. </if>
    141. 

  141. <if test="cnname != null and cnname !='' ">
    142. 

  142. 	and a.cnname like  concat('%',#{cnname},'%')
    143. 

  143. </if>
    144. 

  144. </select></lbody><lbodyDbt></lbodyDbt><lbodyOra></lbodyOra><lbodyMysql></lbodyMysql></RDP_LOGICINFO>]]></detail></product><product><type>logs</type><code>SupplementTaskUserQuery</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 16:11:11:074</recmodifydate><importmodifydate>2024-09-27 16:11:11:074</importmodifydate><changedesc>2</changedesc><module>_public</module><parameter></parameter><relation><product><type>log</type><code>SupplementTaskUserQuery</code><version>8</version></product></relation><detail><![CDATA[<RDP_LOGICSINFO><lid>SupplementTaskUserQuery</lid><lverno>1</lverno><ltype>9</ltype><usetime>0</usetime><lbody></lbody><RDP_LOGICSRELATIONS><RDP_LOGICSRELATION><lsid>SupplementTaskUserQuery</lsid><lsverno>1</lsverno><lid>SupplementTaskUserQuery</lid><ono>0</ono><isrstset>1</isrstset><rstsetcode>RstSetSupplementTaskUserQuery</rstsetcode></RDP_LOGICSRELATION></RDP_LOGICSRELATIONS></RDP_LOGICSINFO>]]></detail></product><product><type>rdp</type><code>SupplementTaskUserQuery</code><version>11</version><name>首选责任人选择页面</name><desc>null</desc><state>latest</state><visiblerange>public</visiblerange><suptype>_PUBLIC</suptype><supcode>_PUBLIC</supcode><createenv>10.1.80.882883rmcdb</createenv><updateenv>10.1.80.1572883rdcdb</updateenv><recmodifyid>admin</recmodifyid><auditorid>admin</auditorid><recmodifydate>2024-12-26 14:35:55:059</recmodifydate><importmodifydate>2024-12-26 14:35:55:059</importmodifydate><changedesc>1</changedesc><module>_public</module><parameter><param><paramcode>businesstypeid</paramcode><paramname>流程类型编号</paramname><paramtype>1</paramtype><datatype></datatype><paramdesc>流程类型编号</paramdesc></param><param><paramcode>orgcode</paramcode><paramname>部门编码ID</paramname><paramtype>1</paramtype><datatype></datatype><paramdesc>null</paramdesc></param></parameter><relation><product><type>logs</type><code>SupplementTaskUserQuery</code><version>1</version></product></relation><detail><![CDATA[<RDP_FUNCTIONINFO RDP="new"><fcode>SupplementTaskUserQuery</fcode><fverno>11</fverno><ftype>null</ftype><tcode>query</tcode><dftlid>SupplementTaskUserQuery</dftlid><isinit>1</isinit><xmldata><template XML_CLASSNAME="com.sundata.product.rdp.model.template.QueryListTemplateDomain" defaultLogic="SupplementTaskUserQuery" isNeedInit="1" layout="grid"><conarea colnum="6"><conditions XML_TAGTYPE="list"><con XML_CLASSNAME="com.sundata.product.rdp.model.template.ConditionDomain" id="account" type="text" label="用户编号" colspan="1" defaultformat="yyyy-MM-dd" datatype="string" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></con><con XML_CLASSNAME="com.sundata.product.rdp.model.template.ConditionDomain" id="cnname" type="text" label="用户姓名" colspan="1" defaultformat="yyyy-MM-dd" datatype="string" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></con><con XML_CLASSNAME="com.sundata.product.rdp.model.template.ConditionDomain" id="orgcode" type="select" label="所属机构" colspan="1" defaulttype="3" defaultval="orgcode" defaultformat="yyyy-MM-dd" dictype="dict" dicval="org" datatype="string" selectTree="on" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></con></conditions></conarea><queryButtons XML_TAGTYPE="list"/><extButtons XML_TAGTYPE="list"/><tableReareas XML_TAGTYPE="list"><tabrearea XML_CLASSNAME="com.sundata.product.rdp.model.template.TableReareaDomain" paging="on" autoWidth="on" pagesumlab="小计" chooseCol="not" rowKey="TABLE_COLUMN_PK" titletype="table_header" type="table" id="tabResultArea0" resultkey="RstSetSupplementTaskUserQuery" left="0.00%" top="0.00%" width="100.00%" height="79.86%" gridRow="ROOT" gridRowSpan="24" gridRowOrder="0" gridSpan="24" gridOrder="0"><OTHER noCol="on"/><comment/><results XML_TAGTYPE="list"><res XML_CLASSNAME="com.sundata.product.rdp.model.template.ResultDomain" id="account" label="用户编号" type="common" datatype="text" opWinH="0" opWinW="0" moneyprecision="2" rateprecision="2"><hyperlink events="default" opWinH="0" opWinW="0" isOperButton="false" isInLineButton="false"><dataStrList XML_TAGTYPE="list"/></hyperlink><buttons XML_TAGTYPE="list"/></res><res XML_CLASSNAME="com.sundata.product.rdp.model.template.ResultDomain" id="cnname" label="用户名称" type="common" datatype="text" opWinH="0" opWinW="0" moneyprecision="2" rateprecision="2"><hyperlink events="default" opWinH="0" opWinW="0" isOperButton="false" isInLineButton="false"><dataStrList XML_TAGTYPE="list"/></hyperlink><buttons XML_TAGTYPE="list"/></res><res XML_CLASSNAME="com.sundata.product.rdp.model.template.ResultDomain" id="orgcode" label="所属机构" type="common" datatype="text" opWinH="0" opWinW="0" moneyprecision="2" rateprecision="2"><hyperlink events="default" opWinH="0" opWinW="0" isOperButton="false" isInLineButton="false"><dataStrList XML_TAGTYPE="list"/></hyperlink><buttons XML_TAGTYPE="list"/></res><res XML_CLASSNAME="com.sundata.product.rdp.model.template.ResultDomain" id="deptcode" label="所属部门" type="common" datatype="text" opWinH="0" opWinW="0" moneyprecision="2" rateprecision="2"><hyperlink events="default" opWinH="0" opWinW="0" isOperButton="false" isInLineButton="false"><dataStrList XML_TAGTYPE="list"/></hyperlink><buttons XML_TAGTYPE="list"/></res></results><expandButtons XML_TAGTYPE="list"/></tabrearea></tableReareas><chartReareas XML_TAGTYPE="list"/><bottomButtons XML_TAGTYPE="list"/><funcs ischeck="on"><![CDATA[&n;@]@]@></funcs></template></xmldata><furl><![CDATA[null]]]]>><![CDATA[</furl><usetime>0</usetime><dftltype>logs</dftltype></RDP_FUNCTIONINFO>]]></detail></product><product><type>rdp</type><code>SupplementTaskOneEdit</code><version>54</version><name>数据补录任务管理维护功能</name><desc></desc><state>latest</state><visiblerange>public</visiblerange><suptype>rdp</suptype><supcode>SupplementTaskQueryList</supcode><createenv>jdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster04</createenv><updateenv>10.1.80.1572883rdcdb</updateenv><recmodifyid>admin</recmodifyid><auditorid>admin</auditorid><recmodifydate>2025-01-06 19:58:20:958</recmodifydate><importmodifydate>2025-01-06 19:58:20:958</importmodifydate><changedesc>1</changedesc><module>_public</module><parameter><param><paramcode>anamode</paramcode><paramname>anamode</paramname><paramtype>1</paramtype><datatype></datatype><paramdesc>操作标识</paramdesc></param><param><paramcode>taskcode</paramcode><paramname>taskcode</paramname><paramtype>1</paramtype><datatype></datatype><paramdesc>任务编号</paramdesc></param></parameter><relation><product><type>log</type><code>ExcelTmpQueryNoun</code><version>7</version></product><product><type>logs</type><code>SupplementTaskOneEdit</code><version>2</version></product><product><type>logs</type><code>SupplementTaskOneEditSave</code><version>8</version></product><product><type>rdp</type><code>SupplementTaskUserQuery</code><version>11</version></product></relation><detail><![CDATA[<RDP_FUNCTIONINFO RDP="new"><fcode>SupplementTaskOneEdit</fcode><fverno>54</fverno><ftype></ftype><tcode>maintain</tcode><dftlid>SupplementTaskOneEdit</dftlid><isinit>1</isinit><xmldata><infoMaintainTemplate XML_CLASSNAME="com.sundata.product.rdp.model.template.InfoMaintainTemplateDomain" defaultLogic="SupplementTaskOneEdit" isNeedInit="1" layout="grid"><pageTitle titletype="table_header" type="table" id="1352745025" left="0%" top="0%" width="100%" height="100%" gridRow="ROOT" gridRowSpan="24" gridRowOrder="0" gridSpan="24" gridOrder="0"/><titleReareas XML_TAGTYPE="list"/><detailTableAreas XML_TAGTYPE="list"><DetailTableAreaDomain XML_CLASSNAME="com.sundata.product.rdp.model.template.DetailTableAreaDomain" title="基本信息" titletype="table_header" type="detail" id="detailTable0" resultkey="RstSetSupplementTaskOneEdit1" left="0.00%" top="0.00%" width="100.00%" height="26.57%" gridRow="ROOT" gridRowSpan="24" gridRowOrder="0" gridSpan="24" gridOrder="0"><ctrlConditions XML_TAGTYPE="list"><ctrlCondition XML_CLASSNAME="com.sundata.product.rdp.model.template.CtrlConditionDomain" hideId="1727601082634" ctrlName="基本信息.anamode 属于 modify" contName="基本信息.任务编号 显示 非必输 不可操作" condition="{&quot;hideId&quot;:1727601086530,&quot;index&quot;:0,&quot;label&quot;:&quot;detailTable0.anamode&quot;,&quot;symbol&quot;:&quot;06&quot;,&quot;val&quot;:&quot;modify&quot;,&quot;type&quot;:&quot;hide&quot;}" definition="{&quot;hideId&quot;:1727601100244,&quot;index&quot;:0,&quot;id&quot;:&quot;detailTable0.taskcode&quot;,&quot;display&quot;:&quot;1&quot;,&quot;notoperate&quot;:&quot;1&quot;}"/></ctrlConditions><dataItems XML_TAGTYPE="list"><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="taskcode" type="text" label="任务编号" colspan="1" notnull="on" defaultformat="yyyy-MM-dd" ctype="account" maxlength="60" datatype="string" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="tmpname" type="text" label="任务名称" colspan="1" notnull="on" defaultformat="yyyy-MM-dd" maxlength="100" datatype="string" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="orgcode" type="select" label="责任机构" colspan="1" notnull="on" defaultformat="yyyy-MM-dd" dictype="dict" dicval="org" datatype="string" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="cnname" type="window" label="首选责任人" comment="请先进行选择责任部门后选择首选负责人" colspan="1" notnull="on" defaultformat="yyyy-MM-dd" datatype="string" funcode="callFuntion('modal','prod_code=SupplementTaskUserQuery&amp;businesstypeid=&amp;orgcode=${orgcode}','0','0')" targetString="account,cnname" sourceString="account,cnname" funcTitle="首选责任人选择页面" precision="2" btnName="计算"><OTHER functionSel="{&quot;prod_code&quot;:&quot;SupplementTaskUserQuery&quot;,&quot;businesstypeid&quot;:&quot;&quot;,&quot;orgcode&quot;:&quot;${orgcode}&quot;}"/><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="frequency" type="select" label="补录频率" colspan="1" notnull="on" defaultformat="yyyy-MM-dd" dictype="dict" dicval="frequency" datatype="string" onlyLeafCheck="on" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="adjustment" type="text" label="天数调整" colspan="1" notnull="on" defaultformat="yyyy-MM-dd" ctype="integer" minval="-15" maxval="15" datatype="number" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="ischeck" type="select" label="是否需要复核" comment="请选择" colspan="1" notnull="on" defaultformat="yyyy-MM-dd" dictype="dict" dicval="YESORNO" datatype="string" onlyLeafCheck="on" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="anamode" type="hide" label="anamode" colspan="1" defaulttype="3" defaultval="anamode" defaultformat="yyyy-MM-dd" datatype="string" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="account" type="hide" label="account" colspan="1" defaultformat="yyyy-MM-dd" datatype="string" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem></dataItems></DetailTableAreaDomain></detailTableAreas><tableReareas XML_TAGTYPE="list"/><multiTableAreas XML_TAGTYPE="list"><MultiTableAreaDomain XML_CLASSNAME="com.sundata.product.rdp.model.template.MultiTableAreaDomain" chooseCol="not" canAdd="on" title="补录模板列表" titletype="table_header" type="multi" id="multiTable1" resultkey="RstSetSupplementTaskOneEdit2" left="0.00%" top="0.00%" width="100.00%" height="26.57%" gridRow="ROOT" gridRowSpan="24" gridRowOrder="0" gridSpan="24" gridOrder="0"><OTHER noCol="on"/><ctrlConditions XML_TAGTYPE="list"/><dataItems XML_TAGTYPE="list"><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="taskcode" type="hide" label="任务编号" colspan="1" defaulttype="3" defaultval="taskcode" defaultformat="yyyy-MM-dd" datatype="string" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="tmpcode" type="select" label="补录模板" colspan="1" notnull="on" defaultformat="yyyy-MM-dd" dictype="logic" dicval="ExcelTmpQueryNoun" datatype="string" onlyLeafCheck="on" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="remark" type="textarea" label="补录模板说明" colspan="1" notnull="on" defaultformat="yyyy-MM-dd" maxlength="200" datatype="string" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="sqlcode" type="textarea" label="数据初始化逻辑" colspan="1" notnull="on" defaultformat="yyyy-MM-dd" maxlength="16383" datatype="string" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem></dataItems><expandButtons XML_TAGTYPE="list"/></MultiTableAreaDomain><MultiTableAreaDomain XML_CLASSNAME="com.sundata.product.rdp.model.template.MultiTableAreaDomain" chooseCol="not" canAdd="on" title="Excel补录模板校验规则" titletype="table_header" type="multi" id="multiTable0" resultkey="RstSetSupplementTaskOneEdit3" left="0.00%" top="0.00%" width="100.00%" height="26.57%" gridRow="ROOT" gridRowSpan="24" gridRowOrder="0" gridSpan="24" gridOrder="0"><OTHER noCol="on"/><ctrlConditions XML_TAGTYPE="list"/><dataItems XML_TAGTYPE="list"><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="taskcode" type="hide" label="任务编号" colspan="1" defaultformat="yyyy-MM-dd" datatype="string" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="tmpverificationname" type="text" label="规则名称" colspan="1" defaultformat="yyyy-MM-dd" maxlength="100" datatype="string" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="tmpcode" type="select" label="补录模板" colspan="1" notnull="on" defaultformat="yyyy-MM-dd" dictype="logic" dicval="ExcelTmpQueryNoun" datatype="string" onlyLeafCheck="on" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="tmpverrowcoltype" type="select" label="行列类型" colspan="1" notnull="on" defaultformat="yyyy-MM-dd" dictype="dict" dicval="frequenct" datatype="string" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="vertimmer" type="select" label="模板验证时点" colspan="1" notnull="on" defaultformat="yyyy-MM-dd" dictype="dict" dicval="frequencv" datatype="string" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="tmpverrowrange" type="text" label="行范围" colspan="1" defaultformat="yyyy-MM-dd" maxlength="60" datatype="string" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="tmpvercolumnrange" type="text" label="列范围" colspan="1" defaultformat="yyyy-MM-dd" maxlength="60" datatype="string" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="checktype" type="select" label="约束方式" colspan="1" notnull="on" defaultformat="yyyy-MM-dd" dictype="dict" dicval="checktype" datatype="string" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="datatype" type="text" label="数据类型" colspan="1" defaultformat="yyyy-MM-dd" maxlength="60" datatype="string" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="excelformula" type="hide" label="约束公式" colspan="1" defaultformat="yyyy-MM-dd" datatype="string" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="sqlcode" type="hide" label="约束规则SQL" colspan="1" defaultformat="yyyy-MM-dd" datatype="string" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="exceedtype" type="select" label="越界处理方式" colspan="1" notnull="on" defaultformat="yyyy-MM-dd" dictype="dict" dicval="exceedtype" datatype="string" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="errormsgtmplate" type="text" label="提示信息模板" colspan="1" defaultformat="yyyy-MM-dd" maxlength="300" datatype="string" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" type="none" colspan="1" defaultformat="yyyy-MM-dd" datatype="string" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem></dataItems><expandButtons XML_TAGTYPE="list"/></MultiTableAreaDomain></multiTableAreas><chartReareas XML_TAGTYPE="list"/><expandAreas XML_TAGTYPE="list"/><childFunAreas XML_TAGTYPE="list"/><bottomButtons XML_TAGTYPE="list"><btn XML_CLASSNAME="com.sundata.product.rdp.model.template.ButtonDomain" id="savebtn" type="save" label="保存" logic="SupplementTaskOneEditSave" logicType="logs" logicparamcfg="{&quot;RstSetSupplementTaskOneEditCheck&quot;:&quot;&quot;,&quot;RstSetSupplementTaskOneEditSave1&quot;:&quot;&quot;,&quot;RstSetSupplementTaskOneEditSave2&quot;:&quot;&quot;,&quot;RstSetSupplementTaskOneEditSave3&quot;:&quot;&quot;,&quot;RstSetSupplementTaskOneEditSave4&quot;:&quot;&quot;,&quot;RstSetSupplementTaskOneEditSave5&quot;:&quot;&quot;}" btnauthid="savebtn" opWinH="0" opWinW="0" isOperButton="false" isInLineButton="false"><OTHER logiclist="[{&quot;NOUNNAME&quot;:&quot;数据补录任务管理维护基本信息任务编号校验&quot;,&quot;NOUNVALUE&quot;:&quot;RstSetSupplementTaskOneEditCheck&quot;},{&quot;NOUNNAME&quot;:&quot;数据补录任务管理维护基本信息保存&quot;,&quot;NOUNVALUE&quot;:&quot;RstSetSupplementTaskOneEditSave1&quot;},{&quot;NOUNNAME&quot;:&quot;数据补录任务管理维护模板信息删除&quot;,&quot;NOUNVALUE&quot;:&quot;RstSetSupplementTaskOneEditSave2&quot;},{&quot;NOUNNAME&quot;:&quot;数据补录任务管理维护模板信息保存&quot;,&quot;NOUNVALUE&quot;:&quot;RstSetSupplementTaskOneEditSave3&quot;},{&quot;NOUNNAME&quot;:&quot;数据补录任务管理维护限制信息删除&quot;,&quot;NOUNVALUE&quot;:&quot;RstSetSupplementTaskOneEditSave4&quot;},{&quot;NOUNNAME&quot;:&quot;数据补录任务管理维护限制信息保存&quot;,&quot;NOUNVALUE&quot;:&quot;RstSetSupplementTaskOneEditSave5&quot;}]" isquerynshow="on"/><dataStrList XML_TAGTYPE="list"/></btn><btn XML_CLASSNAME="com.sundata.product.rdp.model.template.ButtonDomain" id="closebtn" type="normal" label="关闭" events="hand" funcname="customJs.current.closeWindow" onclick="customJs.current.closeWindow()" btnauthid="closebtn" opWinH="0" opWinW="0" isOperButton="false" isInLineButton="false"><dataStrList XML_TAGTYPE="list"/></btn><btn XML_CLASSNAME="com.sundata.product.rdp.model.template.ButtonDomain" type="none" btnauthid="Btn_2038823083" opWinH="0" opWinW="0" isOperButton="false" isInLineButton="false"><dataStrList XML_TAGTYPE="list"/></btn></bottomButtons><funcs ischeck="on"><![CDATA[customJs.current.closeWindow=(a,b)=>{&n;	 utilJs.closeWin(true);&n;}&n;&n;customJs.current.saveBeforeFun=(datas)=>{&n;&n;var flag = true;&n;//判断列表中的行范围、列范围是否符合规范&n;	//遍历集合获取预算类型&n;	var msg='';&n;    var midrow='';&n;    var midcol='';&n;	var seq=1;&n;	let vals=(datas.multiTable0).values();        &n;const reg = /^\d+-\d+$/;&n;     for(let val of vals){&n;/**&n;		if(!(val.tmpverrowrange == '' ||  val.tmpverrowrange == undefined) && !reg.test(val.tmpverrowrange)){&n;			 midrow='第【'+seq+'】行的行范围内容不符合规范！';&n;                         msg=msg+midrow+'\n';&n;			 flag=false;&n;                        midrow='';&n;		}              &n;		if(!(val.tmpvercolumnrange == '' ||  val.tmpvercolumnrange == undefined) && !reg.test(val.tmpvercolumnrange)){&n;			 midcol+='第【'+seq+'】行的列范围内容不符合规范！';&n;                         msg=msg+midcol+'\n';&n;			 flag=false;&n;                        midcol='';&n;		}&n;**/&n;var checktype = val.checktype;&n;var datatype = val.datatype;&n;		if(val.checktype == '1' && (val.datatype== '' ||  val.datatype== undefined)){&n;			 midcol+='第【'+seq+'】行的约束方式录入为数据类型时,数据类型字段不能为空！';&n;                         msg=msg+midcol+'\n';&n;			 flag=false;&n;                        midcol='';&n;}&n;        console.log('msg:',msg);			&n;        seq++;		&n;     }&n;&n;	 if(!flag){&n;	    baseFun.warning(msg);&n;	 }&n;&n;   return flag;&n;}&n;&n;&n;&n;&n;&n;@]@]@></funcs></infoMaintainTemplate></xmldata><furl><![CDATA[]]]]>><![CDATA[</furl><usetime>0</usetime><dftltype>logs</dftltype></RDP_FUNCTIONINFO>]]></detail></product><product><type>rdp</type><code>SupplementTaskOneEdit2</code><version>6</version><name>数据补录任务管理维护功能</name><desc></desc><state>latest</state><visiblerange>public</visiblerange><suptype>rdp</suptype><supcode>SupplementTaskQueryList</supcode><createenv>10.1.80.882883rmcdb</createenv><updateenv>10.1.80.1572883rdcdb</updateenv><recmodifyid>admin</recmodifyid><auditorid>admin</auditorid><recmodifydate>2024-12-11 13:57:42:520</recmodifydate><importmodifydate>2024-12-11 13:57:42:520</importmodifydate><changedesc>1</changedesc><module>_public</module><parameter><param><paramcode>anamode</paramcode><paramname>anamode</paramname><paramtype>1</paramtype><datatype></datatype><paramdesc>操作标识</paramdesc></param><param><paramcode>taskcode</paramcode><paramname>taskcode</paramname><paramtype>1</paramtype><datatype></datatype><paramdesc>任务编号</paramdesc></param></parameter><relation><product><type>log</type><code>ExcelTmpQueryNoun</code><version>7</version></product><product><type>logs</type><code>SupplementTaskOneEdit</code><version>2</version></product><product><type>rdp</type><code>SupplementTaskUserQuery</code><version>11</version></product></relation><detail><![CDATA[<RDP_FUNCTIONINFO RDP="new"><fcode>SupplementTaskOneEdit2</fcode><fverno>6</fverno><ftype></ftype><tcode>maintain</tcode><dftlid>SupplementTaskOneEdit</dftlid><isinit>1</isinit><xmldata><infoMaintainTemplate XML_CLASSNAME="com.sundata.product.rdp.model.template.InfoMaintainTemplateDomain" defaultLogic="SupplementTaskOneEdit" isNeedInit="1" layout="grid"><pageTitle titletype="table_header" type="table" id="1352745025" left="0%" top="0%" width="100%" height="100%" gridRow="ROOT" gridRowSpan="24" gridRowOrder="0" gridSpan="24" gridOrder="0"/><titleReareas XML_TAGTYPE="list"/><detailTableAreas XML_TAGTYPE="list"><DetailTableAreaDomain XML_CLASSNAME="com.sundata.product.rdp.model.template.DetailTableAreaDomain" title="基本信息" titletype="table_header" type="detail" id="detailTable0" resultkey="RstSetSupplementTaskOneEdit1" left="0.00%" top="0.00%" width="100.00%" height="26.57%" gridRow="ROOT" gridRowSpan="24" gridRowOrder="0" gridSpan="24" gridOrder="0"><ctrlConditions XML_TAGTYPE="list"><ctrlCondition XML_CLASSNAME="com.sundata.product.rdp.model.template.CtrlConditionDomain" hideId="1727601082634" ctrlName="基本信息.anamode 属于 modify" contName="基本信息.任务编号 显示 非必输 不可操作" condition="{&quot;hideId&quot;:1727601086530,&quot;index&quot;:0,&quot;label&quot;:&quot;detailTable0.anamode&quot;,&quot;symbol&quot;:&quot;06&quot;,&quot;val&quot;:&quot;modify&quot;,&quot;type&quot;:&quot;hide&quot;}" definition="{&quot;hideId&quot;:1727601100244,&quot;index&quot;:0,&quot;id&quot;:&quot;detailTable0.taskcode&quot;,&quot;display&quot;:&quot;1&quot;,&quot;notoperate&quot;:&quot;1&quot;}"/></ctrlConditions><dataItems XML_TAGTYPE="list"><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="taskcode" type="display" label="任务编号" colspan="1" defaultformat="yyyy-MM-dd" datatype="string" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="tmpname" type="display" label="任务名称" colspan="1" defaultformat="yyyy-MM-dd" datatype="string" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="orgcode" type="display" label="责任机构" colspan="1" defaultformat="yyyy-MM-dd" dictype="dict" dicval="org" datatype="string" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="cnname" type="window" label="首选责任人" colspan="1" defaultformat="yyyy-MM-dd" datatype="string" funcode="callFuntion('modal','prod_code=SupplementTaskUserQuery&amp;businesstypeid=','0','0')" targetString="account,cnname" sourceString="account,cnname" precision="2" btnName="计算"><OTHER functionSel="{&quot;prod_code&quot;:&quot;SupplementTaskUserQuery&quot;,&quot;businesstypeid&quot;:&quot;&quot;}"/><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="frequency" type="select" label="补录频率" colspan="1" defaultformat="yyyy-MM-dd" dictype="dict" dicval="frequency" datatype="string" onlyLeafCheck="on" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="adjustment" type="text" label="天数调整" colspan="1" defaultformat="yyyy-MM-dd" ctype="integer" minval="-15" maxval="15" datatype="number" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="ischeck" type="select" label="是否需要复核" colspan="1" defaultformat="yyyy-MM-dd" dictype="dict" dicval="YESORNO" datatype="string" onlyLeafCheck="on" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="anamode" type="hide" label="anamode" colspan="1" defaulttype="3" defaultval="anamode" defaultformat="yyyy-MM-dd" datatype="string" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="account" type="hide" label="account" colspan="1" defaultformat="yyyy-MM-dd" datatype="string" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem></dataItems></DetailTableAreaDomain></detailTableAreas><tableReareas XML_TAGTYPE="list"/><multiTableAreas XML_TAGTYPE="list"><MultiTableAreaDomain XML_CLASSNAME="com.sundata.product.rdp.model.template.MultiTableAreaDomain" chooseCol="not" canEditNo="on" canDelNo="on" title="Excel补录模板列表" titletype="table_header" type="multi" id="multiTable1" resultkey="RstSetSupplementTaskOneEdit2" left="0.00%" top="0.00%" width="100.00%" height="26.57%" gridRow="ROOT" gridRowSpan="24" gridRowOrder="0" gridSpan="24" gridOrder="0"><OTHER noCol="on"/><ctrlConditions XML_TAGTYPE="list"/><dataItems XML_TAGTYPE="list"><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="taskcode" type="hide" label="任务编号" colspan="1" defaultformat="yyyy-MM-dd" datatype="string" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="tmpcode" type="select" label="补录模板" colspan="1" notnull="on" defaultformat="yyyy-MM-dd" dictype="logic" dicval="ExcelTmpQueryNoun" datatype="string" onlyLeafCheck="on" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="remark" type="textarea" label="补录模板说明" colspan="1" notnull="on" defaultformat="yyyy-MM-dd" maxlength="300" datatype="string" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="sqlcode" type="textarea" label="数据初始化逻辑" colspan="1" notnull="on" defaultformat="yyyy-MM-dd" maxlength="16383" datatype="string" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem></dataItems><expandButtons XML_TAGTYPE="list"/></MultiTableAreaDomain><MultiTableAreaDomain XML_CLASSNAME="com.sundata.product.rdp.model.template.MultiTableAreaDomain" chooseCol="not" canEditNo="on" canDelNo="on" title="Excel补录模板校验规则" titletype="table_header" type="multi" id="multiTable0" resultkey="RstSetSupplementTaskOneEdit3" left="0.00%" top="0.00%" width="100.00%" height="26.57%" gridRow="ROOT" gridRowSpan="24" gridRowOrder="0" gridSpan="24" gridOrder="0"><OTHER noCol="on"/><ctrlConditions XML_TAGTYPE="list"/><dataItems XML_TAGTYPE="list"><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="taskcode" type="hide" label="任务编号" colspan="1" defaultformat="yyyy-MM-dd" datatype="string" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="tmpverificationname" type="text" label="规则名称" colspan="1" defaultformat="yyyy-MM-dd" maxlength="200" datatype="string" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="tmpcode" type="select" label="补录模板" colspan="1" notnull="on" defaultformat="yyyy-MM-dd" dictype="logic" dicval="ExcelTmpQueryNoun" datatype="string" onlyLeafCheck="on" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="tmpverrowcoltype" type="select" label="行列类型" colspan="1" notnull="on" defaultformat="yyyy-MM-dd" dictype="dict" dicval="frequenct" datatype="string" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="vertimmer" type="select" label="模板验证时点" colspan="1" notnull="on" defaultformat="yyyy-MM-dd" dictype="dict" dicval="frequencv" datatype="string" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="tmpverrowrange" type="text" label="行范围" colspan="1" defaultformat="yyyy-MM-dd" maxlength="60" datatype="string" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="tmpvercolumnrange" type="text" label="列范围" colspan="1" defaultformat="yyyy-MM-dd" maxlength="60" datatype="string" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="checktype" type="select" label="约束方式" colspan="1" notnull="on" defaultformat="yyyy-MM-dd" dictype="dict" dicval="checktype" datatype="string" onlyLeafCheck="on" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="datatype" type="text" label="数据类型" colspan="1" defaultformat="yyyy-MM-dd" maxlength="60" datatype="string" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="excelformula" type="text" label="约束公式" colspan="1" defaultformat="yyyy-MM-dd" maxlength="1000" datatype="string" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="sqlcode" type="text" label="约束规则SQL" colspan="1" defaultformat="yyyy-MM-dd" maxlength="16383" datatype="string" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="exceedtype" type="select" label="越界处理方式" colspan="1" notnull="on" defaultformat="yyyy-MM-dd" dictype="dict" dicval="exceedtype" datatype="string" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="errormsgtmplate" type="text" label="提示信息模板" colspan="1" defaultformat="yyyy-MM-dd" maxlength="300" datatype="string" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" type="none" colspan="1" defaultformat="yyyy-MM-dd" datatype="string" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem></dataItems><expandButtons XML_TAGTYPE="list"/></MultiTableAreaDomain></multiTableAreas><chartReareas XML_TAGTYPE="list"/><expandAreas XML_TAGTYPE="list"/><childFunAreas XML_TAGTYPE="list"/><bottomButtons XML_TAGTYPE="list"><btn XML_CLASSNAME="com.sundata.product.rdp.model.template.ButtonDomain" id="closebtn" type="normal" label="关闭" events="hand" funcname="customJs.current.closeWindow" onclick="customJs.current.closeWindow()" btnauthid="closebtn" opWinH="0" opWinW="0" isOperButton="false" isInLineButton="false"><dataStrList XML_TAGTYPE="list"/></btn><btn XML_CLASSNAME="com.sundata.product.rdp.model.template.ButtonDomain" type="none" btnauthid="Btn_2038823083" opWinH="0" opWinW="0" isOperButton="false" isInLineButton="false"><dataStrList XML_TAGTYPE="list"/></btn></bottomButtons><funcs ischeck="on"><![CDATA[customJs.current.closeWindow=(a,b)=>{&n;	 utilJs.closeWin(true);&n;}@]@]@></funcs></infoMaintainTemplate></xmldata><furl><![CDATA[]]]]>><![CDATA[</furl><usetime>0</usetime><dftltype>logs</dftltype></RDP_FUNCTIONINFO>]]></detail></product><product><type>rdp</type><code>SupplementTaskQueryList</code><version>41</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>10.1.80.882883rmcdb</updateenv><recmodifyid>admin</recmodifyid><auditorid>admin</auditorid><recmodifydate>2024-12-12 14:30:59:564</recmodifydate><importmodifydate>2024-12-12 14:30:59:564</importmodifydate><changedesc>1</changedesc><module>_public</module><parameter></parameter><relation><product><type>logs</type><code>SupplementTaskQueryList</code><version>1</version></product><product><type>logs</type><code>SupplementTaskQueryList_no</code><version>1</version></product><product><type>logs</type><code>SupplementTaskQueryList_yes</code><version>1</version></product><product><type>rdp</type><code>SupplementTaskOneEdit</code><version>54</version></product><product><type>rdp</type><code>SupplementTaskOneEdit2</code><version>6</version></product><product><type>rdp</type><code>SupplementTaskUserQuery</code><version>11</version></product></relation><detail><![CDATA[<RDP_FUNCTIONINFO RDP="new"><fcode>SupplementTaskQueryList</fcode><fverno>41</fverno><ftype></ftype><tcode>query</tcode><dftlid>SupplementTaskQueryList</dftlid><isinit>1</isinit><xmldata><template XML_CLASSNAME="com.sundata.product.rdp.model.template.QueryListTemplateDomain" defaultLogic="SupplementTaskQueryList" isNeedInit="1" layout="grid"><OTHER reareaHeight="" reareaWidth=""/><conarea colnum="6" rows="2"><conditions XML_TAGTYPE="list"><con XML_CLASSNAME="com.sundata.product.rdp.model.template.ConditionDomain" id="taskcode" type="text" label="任务编号" colspan="1" defaultformat="yyyy-MM-dd" ctype="_" datatype="string" XLineIndex="0" YLineIndex="0" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></con><con XML_CLASSNAME="com.sundata.product.rdp.model.template.ConditionDomain" id="tmpname" type="text" label="任务名称" colspan="1" defaultformat="yyyy-MM-dd" datatype="string" XLineIndex="0" YLineIndex="2" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></con><con XML_CLASSNAME="com.sundata.product.rdp.model.template.ConditionDomain" id="orgcode" type="select" label="责任机构" colspan="1" defaultformat="yyyy-MM-dd" dictype="dict" dicval="org" datatype="string" selectmultiple="on" XLineIndex="0" YLineIndex="4" selectTree="on" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></con><con XML_CLASSNAME="com.sundata.product.rdp.model.template.ConditionDomain" id="cnname" type="window" label="首选责任人" colspan="1" defaultformat="yyyy-MM-dd" datatype="string" funcode="callFuntion('modal','prod_code=SupplementTaskUserQuery&amp;businesstypeid=&amp;orgcode=','0','0')" targetString="account,cnname" sourceString="account,cnname" XLineIndex="1" YLineIndex="0" precision="2" btnName="计算"><OTHER functionSel="{&quot;prod_code&quot;:&quot;SupplementTaskUserQuery&quot;,&quot;businesstypeid&quot;:&quot;&quot;,&quot;orgcode&quot;:&quot;&quot;}"/><events XML_TAGTYPE="list"/></con><con XML_CLASSNAME="com.sundata.product.rdp.model.template.ConditionDomain" id="frequency" type="select" label="补录频率" colspan="1" defaultformat="yyyy-MM-dd" dictype="dict" dicval="frequency" datatype="string" selectmultiple="on" onlyLeafCheck="on" XLineIndex="1" YLineIndex="2" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></con><con XML_CLASSNAME="com.sundata.product.rdp.model.template.ConditionDomain" id="tmpcode" type="text" label="模板编号" colspan="1" defaultformat="yyyy-MM-dd" datatype="string" XLineIndex="0" YLineIndex="0" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></con><con XML_CLASSNAME="com.sundata.product.rdp.model.template.ConditionDomain" id="tmpname1" type="text" label="模板名称" colspan="1" defaultformat="yyyy-MM-dd" datatype="string" XLineIndex="1" YLineIndex="0" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></con><con XML_CLASSNAME="com.sundata.product.rdp.model.template.ConditionDomain" id="account" type="hide" label="account" colspan="1" defaultformat="yyyy-MM-dd" datatype="string" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></con><con XML_CLASSNAME="com.sundata.product.rdp.model.template.ConditionDomain" id="yesorno1" type="select" label="是否有效" colspan="1" defaultformat="yyyy-MM-dd" dictype="dict" dicval="YESORNO" datatype="string" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></con><con XML_CLASSNAME="com.sundata.product.rdp.model.template.ConditionDomain" type="W_E_X" colspan="1" defaultformat="yyyy-MM-dd" datatype="string" XLineIndex="1" YLineIndex="4" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></con><con XML_CLASSNAME="com.sundata.product.rdp.model.template.ConditionDomain" type="W_E_X" colspan="1" defaultformat="yyyy-MM-dd" datatype="string" XLineIndex="1" YLineIndex="5" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></con></conditions></conarea><queryButtons XML_TAGTYPE="list"><btn XML_CLASSNAME="com.sundata.product.rdp.model.template.ButtonDomain" type="submit" XLineIndex="0" YLineIndex="0" opWinH="0" opWinW="0" isOperButton="false" isInLineButton="false"><dataStrList XML_TAGTYPE="list"/></btn><btn XML_CLASSNAME="com.sundata.product.rdp.model.template.ButtonDomain" type="reset" XLineIndex="0" YLineIndex="1" opWinH="0" opWinW="0" isOperButton="false" isInLineButton="false"><dataStrList XML_TAGTYPE="list"/></btn></queryButtons><extButtons XML_TAGTYPE="list"><btn XML_CLASSNAME="com.sundata.product.rdp.model.template.ButtonDomain" id="add" type="normal" label="新增" events="function" onclick="callFuntion('undefined','prod_code=SupplementTaskOneEdit&amp;anamode=add&amp;taskcode=${taskcode}','0','0')" btnauthid="add" opWinH="0" opWinW="0" isOperButton="false" isInLineButton="false" funcTitle="数据补录任务新增页面"><OTHER styletype="" functionSel="{&quot;prod_code&quot;:&quot;SupplementTaskOneEdit&quot;,&quot;anamode&quot;:&quot;add&quot;,&quot;taskcode&quot;:&quot;${taskcode}&quot;}"/><dataStrList XML_TAGTYPE="list"/></btn></extButtons><tableReareas XML_TAGTYPE="list"><tabrearea XML_CLASSNAME="com.sundata.product.rdp.model.template.TableReareaDomain" paging="on" pagesumlab="小计" chooseCol="not" rowKey="TABLE_COLUMN_PK" titletype="table_header" type="table" id="tabResultArea0" resultkey="RstSetSupplementTaskQueryList" left="0.00%" top="0.00%" width="100.00%" height="79.62%" gridRow="ROOT" gridRowSpan="24" gridRowOrder="0" gridSpan="24" gridOrder="0"><OTHER noCol="on"/><comment/><results XML_TAGTYPE="list"><res XML_CLASSNAME="com.sundata.product.rdp.model.template.ResultDomain" id="taskcode" label="任务编号" type="common" datatype="text" issort="front" XLineIndex="0" YLineIndex="0" opWinH="0" opWinW="0" moneyprecision="2" rateprecision="2"><hyperlink opWinH="0" opWinW="0" isOperButton="false" isInLineButton="false"><dataStrList XML_TAGTYPE="list"/></hyperlink><buttons XML_TAGTYPE="list"/></res><res XML_CLASSNAME="com.sundata.product.rdp.model.template.ResultDomain" id="tmpname" label="任务名称" type="common" datatype="text" XLineIndex="0" YLineIndex="1" opWinH="0" opWinW="0" moneyprecision="2" rateprecision="2"><hyperlink opWinH="0" opWinW="0" isOperButton="false" isInLineButton="false"><dataStrList XML_TAGTYPE="list"/></hyperlink><buttons XML_TAGTYPE="list"/></res><res XML_CLASSNAME="com.sundata.product.rdp.model.template.ResultDomain" id="orgcode" label="负责机构" type="common" datatype="text" XLineIndex="0" YLineIndex="2" opWinH="0" opWinW="0" moneyprecision="2" rateprecision="2"><hyperlink opWinH="0" opWinW="0" isOperButton="false" isInLineButton="false"><dataStrList XML_TAGTYPE="list"/></hyperlink><buttons XML_TAGTYPE="list"/></res><res XML_CLASSNAME="com.sundata.product.rdp.model.template.ResultDomain" id="cnname" label="首选负责人" type="common" datatype="text" XLineIndex="0" YLineIndex="3" opWinH="0" opWinW="0" moneyprecision="2" rateprecision="2"><hyperlink opWinH="0" opWinW="0" isOperButton="false" isInLineButton="false"><dataStrList XML_TAGTYPE="list"/></hyperlink><buttons XML_TAGTYPE="list"/></res><res XML_CLASSNAME="com.sundata.product.rdp.model.template.ResultDomain" id="frequency" label="补录频率" type="common" datatype="text" XLineIndex="0" YLineIndex="4" opWinH="0" opWinW="0" moneyprecision="2" rateprecision="2"><hyperlink opWinH="0" opWinW="0" isOperButton="false" isInLineButton="false"><dataStrList XML_TAGTYPE="list"/></hyperlink><buttons XML_TAGTYPE="list"/></res><res XML_CLASSNAME="com.sundata.product.rdp.model.template.ResultDomain" id="adjustment" label="天数调整" type="common" datatype="text" XLineIndex="0" YLineIndex="5" opWinH="0" opWinW="0" moneyprecision="2" rateprecision="2"><hyperlink opWinH="0" opWinW="0" isOperButton="false" isInLineButton="false"><dataStrList XML_TAGTYPE="list"/></hyperlink><buttons XML_TAGTYPE="list"/></res><res XML_CLASSNAME="com.sundata.product.rdp.model.template.ResultDomain" id="tmpname2" label="包含模板" type="common" datatype="text" XLineIndex="0" YLineIndex="6" opWinH="0" opWinW="0" moneyprecision="2" rateprecision="2"><hyperlink opWinH="0" opWinW="0" isOperButton="false" isInLineButton="false"><dataStrList XML_TAGTYPE="list"/></hyperlink><buttons XML_TAGTYPE="list"/></res><res XML_CLASSNAME="com.sundata.product.rdp.model.template.ResultDomain" id="yesornoname" label="是否有效" type="common" datatype="text" opWinH="0" opWinW="0" moneyprecision="2" rateprecision="2"><hyperlink events="default" opWinH="0" opWinW="0" isOperButton="false" isInLineButton="false"><dataStrList XML_TAGTYPE="list"/></hyperlink><buttons XML_TAGTYPE="list"/></res><res XML_CLASSNAME="com.sundata.product.rdp.model.template.ResultDomain" id="oper" label="操作列" type="operate" datatype="text" XLineIndex="0" YLineIndex="12" opWinH="0" opWinW="0" moneyprecision="2" rateprecision="2"><hyperlink opWinH="0" opWinW="0" isOperButton="false" isInLineButton="false"><dataStrList XML_TAGTYPE="list"/></hyperlink><buttons XML_TAGTYPE="list"><btn XML_CLASSNAME="com.sundata.product.rdp.model.template.ButtonDomain" type="normal" label="查看" events="function" onclick="callFuntion('undefined','prod_code=SupplementTaskOneEdit2&amp;anamode=query&amp;taskcode=${taskcode}','0','0')" btnauthid="view" opWinH="0" opWinW="0" isOperButton="false" isInLineButton="false" funcTitle="数据补录任务查看页面"><OTHER styletype="" hideId="HIDEID_4c2apvj9vbe000" functionSel="{&quot;prod_code&quot;:&quot;SupplementTaskOneEdit2&quot;,&quot;anamode&quot;:&quot;query&quot;,&quot;taskcode&quot;:&quot;${taskcode}&quot;}"/><dataStrList XML_TAGTYPE="list"/></btn><btn XML_CLASSNAME="com.sundata.product.rdp.model.template.ButtonDomain" type="normal" label="修改" events="function" onclick="callFuntion('undefined','prod_code=SupplementTaskOneEdit&amp;anamode=modify&amp;taskcode=${taskcode}','0','0')" btnauthid="edit" opWinH="0" opWinW="0" isOperButton="false" isInLineButton="false" funcTitle="数据补录任务修改页面"><OTHER styletype="" functionSel="{&quot;prod_code&quot;:&quot;SupplementTaskOneEdit&quot;,&quot;anamode&quot;:&quot;modify&quot;,&quot;taskcode&quot;:&quot;${taskcode}&quot;}" btnHideSpan="(yesorno 属于 '0')" btnHideInp="[[{&quot;hideId&quot;:1733984779211,&quot;index&quot;:0,&quot;label&quot;:&quot;yesorno&quot;,&quot;SYMBOL&quot;:&quot;06&quot;,&quot;val&quot;:&quot;'0'&quot;}]]" hideId="HIDEID_4x1ind5i5j400"/><dataStrList XML_TAGTYPE="list"/></btn><btn XML_CLASSNAME="com.sundata.product.rdp.model.template.ButtonDomain" type="normal" label="作废" events="choose" logic="SupplementTaskQueryList_no" logicType="logs" uselogictype="refresh" onclick="doLogicSucc(null, 'dosearch')" btnauthid="no" opWinH="0" opWinW="0" isOperButton="false" isInLineButton="false"><OTHER btnHideSpan="(yesorno 属于 '0')" styletype="" btnHideInp="[[{&quot;hideId&quot;:1730256101546,&quot;index&quot;:0,&quot;label&quot;:&quot;yesorno&quot;,&quot;SYMBOL&quot;:&quot;06&quot;,&quot;val&quot;:&quot;'0'&quot;}]]" hideId="HIDEID_586rin8gynw000" confirmmess="请是否继续操作？" isconfirm="on"/><dataStrList XML_TAGTYPE="list"/></btn><btn XML_CLASSNAME="com.sundata.product.rdp.model.template.ButtonDomain" type="normal" label="启用" events="choose" logic="SupplementTaskQueryList_yes" logicType="logs" btnauthid="yes" opWinH="0" opWinW="0" isOperButton="false" isInLineButton="false"><OTHER btnHideSpan="(yesorno 属于 '1')" btnHideInp="[[{&quot;hideId&quot;:1730256229984,&quot;index&quot;:0,&quot;label&quot;:&quot;yesorno&quot;,&quot;SYMBOL&quot;:&quot;06&quot;,&quot;val&quot;:&quot;'1'&quot;}]]" hideId="HIDEID_1b3mt4lup92800" isconfirm=""/><dataStrList XML_TAGTYPE="list"/></btn></buttons></res><res XML_CLASSNAME="com.sundata.product.rdp.model.template.ResultDomain" id="yesorno" label="yesorno" type="hidden" datatype="text" opWinH="0" opWinW="0" moneyprecision="2" rateprecision="2"><hyperlink events="default" opWinH="0" opWinW="0" isOperButton="false" isInLineButton="false"><dataStrList XML_TAGTYPE="list"/></hyperlink><buttons XML_TAGTYPE="list"/></res></results><expandButtons XML_TAGTYPE="list"/></tabrearea></tableReareas><chartReareas XML_TAGTYPE="list"/><bottomButtons XML_TAGTYPE="list"/></template></xmldata><furl><![CDATA[]]]]>><![CDATA[</furl><usetime>0</usetime><dftltype>logs</dftltype></RDP_FUNCTIONINFO>]]></detail></product></root>
    145.