Home Explore Help
Register Sign In
RWA
/
RWAServer
3
2
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Tree: ab313dc840
Branches Tags
RWAServer
/
ShortCode
/
001-初始化
/
李庚谱
/
补录功能
/
Excel-group.cfg

Excel-group.cfg 21 KB
History Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102 
  1. <?xml version="1.0" encoding="UTF-8"?><root><product><type>log</type><code>ExcelTmpOneEdit</code><version>23</version><name>Excel补录模板配置维护基本信息查询</name><desc>null</desc><state>latest</state><visiblerange>public</visiblerange><suptype>logs</suptype><supcode>eab_enterPI_insert_select</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-10-08 19:47:51:443</recmodifydate><importmodifydate>2024-10-08 19:47:51:443</importmodifydate><changedesc>1</changedesc><module>_public</module><parameter></parameter><relation></relation><detail><![CDATA[<RDP_LOGICINFO><lid>ExcelTmpOneEdit</lid><lverno>23</lverno><ltype>0</ltype><usetime>0</usetime><errormsg></errormsg><sqlexecutetype>1</sqlexecutetype><lbody><select>
    2. 

  2.    select   u1.tmpcode,u1.tmpname ,u3.nounname, u1.tmptype,u1.rowrange,u1.columnrange,tmpfilename,tmpfilecode 
    3. 

  3. from  rmc_imput_tmpconf_baseinfo u1  
    4. 

  4. inner  JOIN sys_noun u3 on u3.nounitem ='tmptype' AND u3.nounvalue =u1.tmptype
    5. 

  5. where 1=1 AND u1.tmpcode= #{tmpcode}
    6. 

  6. </select></lbody><lbodyDbt></lbodyDbt><lbodyOra></lbodyOra><lbodyMysql></lbodyMysql></RDP_LOGICINFO>]]></detail></product><product><type>log</type><code>ExcelTmpOneEdit1</code><version>7</version><name>Excel补录模板配置维护明细信息</name><desc>null</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-10-10 18:00:54:748</recmodifydate><importmodifydate>2024-10-10 18:00:54:748</importmodifydate><changedesc>1</changedesc><module>_public</module><parameter></parameter><relation></relation><detail><![CDATA[<RDP_LOGICINFO><lid>ExcelTmpOneEdit1</lid><lverno>7</lverno><ltype>0</ltype><usetime>0</usetime><errormsg></errormsg><sqlexecutetype>1</sqlexecutetype><lbody><select>
    7. 

  7. select   u1.tmpcode,u1.tmpfieldcode,u1.rowcoltype,u1.filedrowrange,u1.filedcolumnrange,u1.filedcoltype,u1.remark  
    8. 

  8. from  rmc_imput_tmpconf_fielddetails u1  
    9. 

  9. inner  JOIN sys_noun u3 on u3.nounitem ='rowcoltype' AND u3.nounvalue =u1.rowcoltype
    10. 

  10. where 1=1 AND u1.tmpcode = #{tmpcode}
    11. 

  11. </select></lbody><lbodyDbt></lbodyDbt><lbodyOra></lbodyOra><lbodyMysql></lbodyMysql></RDP_LOGICINFO>]]></detail></product><product><type>logs</type><code>ExcelTmpOneEdit</code><version>2</version><name>Excel补录模板配置维护页面逻辑</name><desc></desc><state>latest</state><visiblerange>public</visiblerange><suptype>rdp</suptype><supcode>ExcelTmpOneEdit</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-19 09:22:27:739</recmodifydate><importmodifydate>2024-09-19 09:22:27:739</importmodifydate><changedesc>111</changedesc><module>_public</module><parameter></parameter><relation><product><type>log</type><code>ExcelTmpOneEdit</code><version>23</version></product><product><type>log</type><code>ExcelTmpOneEdit1</code><version>7</version></product></relation><detail><![CDATA[<RDP_LOGICSINFO><lid>ExcelTmpOneEdit</lid><lverno>2</lverno><ltype>9</ltype><usetime>0</usetime><lbody></lbody><RDP_LOGICSRELATIONS><RDP_LOGICSRELATION><lsid>ExcelTmpOneEdit</lsid><lsverno>2</lsverno><lid>ExcelTmpOneEdit</lid><ono>0</ono><isrstset>1</isrstset><rstsetcode>RstSetExcelTmpOneEdit</rstsetcode></RDP_LOGICSRELATION><RDP_LOGICSRELATION><lsid>ExcelTmpOneEdit</lsid><lsverno>2</lsverno><lid>ExcelTmpOneEdit1</lid><ono>1</ono><isrstset>1</isrstset><rstsetcode>RstSetExcelTmpOneEdit1</rstsetcode></RDP_LOGICSRELATION></RDP_LOGICSRELATIONS></RDP_LOGICSINFO>]]></detail></product><product><type>logs</type><code>ExcelTmpOneEditSaveUpdata</code><version>1</version><name>Excel补录模板配置补录新增修改逻辑组</name><desc></desc><state>latest</state><visiblerange>public</visiblerange><suptype>rdp</suptype><supcode>ExcelTmpOneEditUpdate</supcode><createenv>10.1.80.882883rmcdb</createenv><updateenv>10.1.80.882883rmcdb</updateenv><recmodifyid>qian_jwei</recmodifyid><auditorid>qian_jwei</auditorid><recmodifydate>2024-10-20 11:43:23:718</recmodifydate><importmodifydate>2024-10-20 11:43:23:718</importmodifydate><changedesc>1</changedesc><module>_public</module><parameter></parameter><relation></relation><detail><![CDATA[<RDP_LOGICSINFO><lid>ExcelTmpOneEditSaveUpdata</lid><lverno>1</lverno><ltype>9</ltype><usetime>0</usetime><lbody></lbody><RDP_LOGICSRELATIONS><RDP_LOGICSRELATION><lsid>ExcelTmpOneEditSaveUpdata</lsid><lsverno>1</lsverno><lid>ExcelTmpOneEditSave</lid><ono>0</ono><isrstset>1</isrstset><rstsetcode>RstSetExcelTmpOneEditSave</rstsetcode></RDP_LOGICSRELATION><RDP_LOGICSRELATION><lsid>ExcelTmpOneEditSaveUpdata</lsid><lsverno>1</lsverno><lid>ExcelTmpOneEditSave1</lid><ono>1</ono><isrstset>1</isrstset><rstsetcode>RstSetExcelTmpOneEditSave1</rstsetcode></RDP_LOGICSRELATION><RDP_LOGICSRELATION><lsid>ExcelTmpOneEditSaveUpdata</lsid><lsverno>1</lsverno><lid>ExcelTmpOneEditSave2</lid><ono>2</ono><isrstset>1</isrstset><rstsetcode>RstSetExcelTmpOneEditSave2</rstsetcode></RDP_LOGICSRELATION></RDP_LOGICSRELATIONS></RDP_LOGICSINFO>]]></detail></product><product><type>log</type><code>ExcelTmpQueryList</code><version>14</version><name>Excel模板配置主页面查询</name><desc>null</desc><state>latest</state><visiblerange>public</visiblerange><suptype>logs</suptype><supcode>ExcelTmpQueryList</supcode><createenv>jdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster04</createenv><updateenv>10.1.80.882883rmcdb</updateenv><recmodifyid>qian_jwei</recmodifyid><auditorid>qian_jwei</auditorid><recmodifydate>2024-10-22 22:08:27:809</recmodifydate><importmodifydate>2024-10-22 22:08:27:809</importmodifydate><changedesc>1</changedesc><module>_public</module><parameter></parameter><relation></relation><detail><![CDATA[<RDP_LOGICINFO><lid>ExcelTmpQueryList</lid><lverno>14</lverno><ltype>0</ltype><usetime>0</usetime><errormsg></errormsg><sqlexecutetype>1</sqlexecutetype><lbody><select>
    12. 

  12. select   u1.tmpcode,u1.tmpname ,u3.nounname typname,u1.tmptype,u1.rowrange,u1.columnrange
    13. 

  13. from  rmc_imput_tmpconf_baseinfo u1  
    14. 

  14. inner  JOIN sys_noun u3 on u3.nounitem ='tmptype' AND u3.nounvalue =u1.tmptype
    15. 

  15. where 1=1
    16. 

  16. <if test="tmpcode != null and tmpcode !=''">
    17. 

  17. AND u1.tmpcode like  concat('%',#{tmpcode},'%')
    18. 

  18. </if>	
    19. 

  19. <if test="tmpname != null and tmpname !=''">
    20. 

  20. AND u1.tmpname like  concat('%',#{tmpname},'%')
    21. 

  21. </if>	
    22. 

  22. <if test="tmptype != null and tmptype !=''">
    23. 

  23. AND u1.tmptype in ( ${tmptype} )
    24. 

  24. </if>
    25. 

  25. </select></lbody><lbodyDbt></lbodyDbt><lbodyOra></lbodyOra><lbodyMysql></lbodyMysql></RDP_LOGICINFO>]]></detail></product><product><type>logs</type><code>ExcelTmpQueryList</code><version>2</version><name>Excel补录模板配置主页面查询</name><desc></desc><state>latest</state><visiblerange>public</visiblerange><suptype>rdp</suptype><supcode>ExcelTmpQueryList</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-08 10:07:06:998</recmodifydate><importmodifydate>2024-10-08 10:07:06:998</importmodifydate><changedesc>1</changedesc><module>_public</module><parameter></parameter><relation><product><type>log</type><code>ExcelTmpQueryList</code><version>14</version></product></relation><detail><![CDATA[<RDP_LOGICSINFO><lid>ExcelTmpQueryList</lid><lverno>2</lverno><ltype>9</ltype><usetime>0</usetime><lbody></lbody><RDP_LOGICSRELATIONS><RDP_LOGICSRELATION><lsid>ExcelTmpQueryList</lsid><lsverno>2</lsverno><lid>ExcelTmpQueryList</lid><ono>0</ono><isrstset>1</isrstset><rstsetcode>RstSetExcelTmpQueryList</rstsetcode></RDP_LOGICSRELATION></RDP_LOGICSRELATIONS></RDP_LOGICSINFO>]]></detail></product><product><type>log</type><code>ExcelTmpOneAddEditCheck</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.882883rmcdb</updateenv><recmodifyid>admin</recmodifyid><auditorid>admin</auditorid><recmodifydate>2024-10-23 14:22:52:147</recmodifydate><importmodifydate>2024-10-23 14:22:52:147</importmodifydate><changedesc>1</changedesc><module>_public</module><parameter></parameter><relation></relation><detail><![CDATA[<RDP_LOGICINFO><lid>ExcelTmpOneAddEditCheck</lid><lverno>8</lverno><ltype>0</ltype><usetime>0</usetime><errormsg></errormsg><sqlexecutetype>2</sqlexecutetype><lbody><select id="ExcelTmpOneAddEditCheck">
    26. 

  26. <if test="detailTable0.anamode=='add'">
    27. 

  27. <if test="multiTable0 != null and multiTable0.size()  &gt; 0">
    28. 

  28. <foreach collection="multiTable0" item="item" separator=" union all ">
    29. 

  29. <![CDATA[
    30. 

  30. select case when a.num > 0 then '2' else '0' end as flag,case when a.num > 0 then concat('模板编号',#{detailTable0.tmpcode},'的字段编号',#{item.tmpfieldcode},'已存在，请重新输入') else '' end as checkmsg from 
    31. 

  31. (select count(1) as num from rmc_imput_tmpconf_fielddetails where tmpcode=#{detailTable0.tmpcode} and tmpfieldcode = #{item.tmpfieldcode}) a
    32. 

  32. @]@]@>
    33. 

  33. 		</foreach>
    34. 

  34. </if>
    35. 

  35. </if>
    36. 

  36. <if test="multiTable0 == null or multiTable0.size()  == 0 or detailTable0.anamode=='modify'">
    37. 

  37.   select '0' as flag,'' as checkmsg from dual
    38. 

  38. </if>
    39. 

  39. </select></lbody><lbodyDbt></lbodyDbt><lbodyOra></lbodyOra><lbodyMysql></lbodyMysql></RDP_LOGICINFO>]]></detail></product><product><type>log</type><code>ExcelTmpOneEditCheck</code><version>10</version><name>新增或修改模板基本信息模板编号校验</name><desc></desc><state>latest</state><visiblerange>public</visiblerange><suptype>logs</suptype><supcode>ExcelTmpOneEditSave</supcode><createenv>10.1.80.882883rmcdb</createenv><updateenv>10.1.80.882883rmcdb</updateenv><recmodifyid>admin</recmodifyid><auditorid>admin</auditorid><recmodifydate>2024-12-11 09:40:40:705</recmodifydate><importmodifydate>2024-12-11 09:40:40:705</importmodifydate><changedesc>1</changedesc><module>_public</module><parameter></parameter><relation></relation><detail><![CDATA[<RDP_LOGICINFO><lid>ExcelTmpOneEditCheck</lid><lverno>10</lverno><ltype>0</ltype><usetime>0</usetime><errormsg></errormsg><sqlexecutetype>2</sqlexecutetype><lbody><select id="ExcelTmpOneEditCheck">
    40. 

  40. <if test="detailTable0.anamode == 'add'">
    41. 

  41. <![CDATA[
    42. 

  42. select case when a.num>0 then '2' else '0' end as flag,case when a.num>0 then '模板编号已存在，请重新输入' else '' end as checkmsg from 
    43. 

  43. (select count(1) as num from rmc_imput_tmpconf_baseinfo where tmpcode=#{detailTable0.tmpcode}) a
    44. 

  44. @]@]@>
    45. 

  45. </if>
    46. 

  46. <if test="detailTable0.anamode != 'add'">
    47. 

  47.   select '0' as flag,'' as checkmsg from dual
    48. 

  48. </if>
    49. 

  49. </select></lbody><lbodyDbt></lbodyDbt><lbodyOra></lbodyOra><lbodyMysql></lbodyMysql></RDP_LOGICINFO>]]></detail></product><product><type>log</type><code>ExcelTmpOneEditIsFile</code><version>5</version><name>校验文件名称是否已存在</name><desc></desc><state>latest</state><visiblerange>public</visiblerange><suptype>_PUBLIC</suptype><supcode>_PUBLIC</supcode><createenv>10.1.80.1572883rdcdb</createenv><updateenv>10.1.80.882883rmcdb</updateenv><recmodifyid>admin</recmodifyid><auditorid>admin</auditorid><recmodifydate>2024-12-11 09:55:33:856</recmodifydate><importmodifydate>2024-12-11 09:55:33:856</importmodifydate><changedesc>1</changedesc><module>_public</module><parameter></parameter><relation></relation><detail><![CDATA[<RDP_LOGICINFO><lid>ExcelTmpOneEditIsFile</lid><lverno>5</lverno><ltype>0</ltype><usetime>0</usetime><errormsg></errormsg><sqlexecutetype>2</sqlexecutetype><lbody><select id="ExcelTmpOneEditIsFile">
    50. 

  50. <![CDATA[
    51. 

  51. select case when a.num>0 then '2' else '0' end as flag,case when a.num>0 then '文件名称已存在，请重新输入' else '' end as checkmsg from 
    52. 

  52. (select count(1) as num from rmc_imput_tmpconf_baseinfo where tmpfilename=#{detailTable0.tmpfilename} 
    53. 

  53. @]@]@>
    54. 

  54. <if test="detailTable0.anamode != 'add'">
    55. 

  55. <![CDATA[
    56. 

  56. and tmpcode != #{detailTable0.tmpcode}
    57. 

  57. @]@]@>
    58. 

  58. </if>
    59. 

  59. ) a
    60. 

  60. </select></lbody><lbodyDbt></lbodyDbt><lbodyOra></lbodyOra><lbodyMysql></lbodyMysql></RDP_LOGICINFO>]]></detail></product><product><type>log</type><code>ExcelTmpOneEditSave</code><version>9</version><name>删除模板字段详情定义表</name><desc></desc><state>latest</state><visiblerange>public</visiblerange><suptype>logs</suptype><supcode>ExcelTmpOneEditSave</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-10-08 15:13:08:701</recmodifydate><importmodifydate>2024-10-08 15:13:08:701</importmodifydate><changedesc>2</changedesc><module>_public</module><parameter></parameter><relation></relation><detail><![CDATA[<RDP_LOGICINFO><lid>ExcelTmpOneEditSave</lid><lverno>9</lverno><ltype>0</ltype><usetime>0</usetime><errormsg></errormsg><sqlexecutetype>1</sqlexecutetype><lbody><delete>
    61. 

  61. DELETE  FROM  rmc_imput_tmpconf_fielddetails u1 WHERE u1.tmpcode = #{detailTable0.tmpcode}
    62. 

  62. </delete></lbody><lbodyDbt></lbodyDbt><lbodyOra></lbodyOra><lbodyMysql></lbodyMysql></RDP_LOGICINFO>]]></detail></product><product><type>log</type><code>ExcelTmpOneEditSave1</code><version>24</version><name>新增或修改模板基本信息定义表</name><desc></desc><state>latest</state><visiblerange>public</visiblerange><suptype>logs</suptype><supcode>ExcelTmpOneEditSave</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-10-19 18:27:05:481</recmodifydate><importmodifydate>2024-10-19 18:27:05:481</importmodifydate><changedesc>1</changedesc><module>_public</module><parameter></parameter><relation></relation><detail><![CDATA[<RDP_LOGICINFO><lid>ExcelTmpOneEditSave1</lid><lverno>24</lverno><ltype>0</ltype><usetime>0</usetime><errormsg></errormsg><sqlexecutetype>1</sqlexecutetype><lbody><update>
    63. 

  63. 	<if test="detailTable0.anamode== 'add' ">
    64. 

  64. 		INSERT INTO rmc_imput_tmpconf_baseinfo
    65. 

  65. 		(tmpcode, tmpname, tmptype, rowrange, columnrange, tmpfilecode,tmpfilename) 
    66. 

  66. 		VALUES (#{detailTable0.tmpcode}, #{detailTable0.tmpname},#{detailTable0.tmptype},#{detailTable0.rowrange},#{detailTable0.columnrange},#{detailTable0.tmpfilecode},#{detailTable0.tmpfilename} )
    67. 

  67. 	</if>
    68. 

  68. 	<if test="detailTable0.anamode== 'modify' ">
    69. 

  69. 		update rmc_imput_tmpconf_baseinfo set tmpname=#{detailTable0.tmpname},tmptype=#{detailTable0.tmptype}, rowrange=#{detailTable0.rowrange},columnrange=#{detailTable0.columnrange},tmpfilecode=#{detailTable0.tmpfilecode},tmpfilename=#{detailTable0.tmpfilename} 
    70. 

  70. 		where tmpcode = #{detailTable0.tmpcode} 
    71. 

  71. 	</if>
    72. 

  72. </update></lbody><lbodyDbt></lbodyDbt><lbodyOra></lbodyOra><lbodyMysql></lbodyMysql></RDP_LOGICINFO>]]></detail></product><product><type>log</type><code>ExcelTmpOneEditSave2</code><version>14</version><name>插入模板字段详情定义表</name><desc></desc><state>latest</state><visiblerange>public</visiblerange><suptype>logs</suptype><supcode>ExcelTmpOneEditSave</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-10-23 16:45:55:720</recmodifydate><importmodifydate>2024-10-23 16:45:55:720</importmodifydate><changedesc>1</changedesc><module>_public</module><parameter></parameter><relation></relation><detail><![CDATA[<RDP_LOGICINFO><lid>ExcelTmpOneEditSave2</lid><lverno>14</lverno><ltype>0</ltype><usetime>0</usetime><errormsg></errormsg><sqlexecutetype>1</sqlexecutetype><lbody><insert id="ExcelTmpOneEditSave2">
    73. 

  73. <if test="multiTable0 != null and multiTable0.size()  &gt; 0">
    74. 

  74. 		INSERT INTO rmc_imput_tmpconf_fielddetails
    75. 

  75. (tmpcode, tmpfieldcode, rowcoltype, filedrowrange, filedcolumnrange,filedcoltype,remark)
    76. 

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

  77. 				<![CDATA[
    78. 

  78. 				select #{detailTable0.tmpcode},#{item.tmpfieldcode},#{item.rowcoltype},#{item.filedrowrange},
    79. 

  79. 				#{item.filedcolumnrange} ,#{item.filedcoltype},#{item.remark}
    80. 

  80. 				from dual
    81. 

  81. 				@]@]@>
    82. 

  82. 		</foreach>
    83. 

  83. </if>
    84. 

  84. <if test="multiTable0 == null or multiTable0.size() == 0">
    85. 

  85. select  '1'  from dual
    86. 

  86. </if>
    87. 

  87. </insert></lbody><lbodyDbt></lbodyDbt><lbodyOra></lbodyOra><lbodyMysql></lbodyMysql></RDP_LOGICINFO>]]></detail></product><product><type>log</type><code>ExcelTmpOneUpdateEditCheck</code><version>8</version><name>字段列表字段编号重复校验</name><desc></desc><state>latest</state><visiblerange>public</visiblerange><suptype>logs</suptype><supcode>ExcelTmpOneEditSave</supcode><createenv>10.1.80.882883rmcdb</createenv><updateenv>10.1.80.882883rmcdb</updateenv><recmodifyid>admin</recmodifyid><auditorid>admin</auditorid><recmodifydate>2024-12-09 16:07:35:813</recmodifydate><importmodifydate>2024-12-09 16:07:35:813</importmodifydate><changedesc>1</changedesc><module>_public</module><parameter></parameter><relation></relation><detail><![CDATA[<RDP_LOGICINFO><lid>ExcelTmpOneUpdateEditCheck</lid><lverno>8</lverno><ltype>0</ltype><usetime>0</usetime><errormsg></errormsg><sqlexecutetype>2</sqlexecutetype><lbody><select id="ExcelTmpOneUpdateEditCheck">
    88. 

  88. <if test="multiTable0 != null and multiTable0.size()  &gt; 0">
    89. 

  89. <![CDATA[
    90. 

  90. select case when a.num>1 then '2' else '0' end as flag,case when a.num>0 then 
    91. 

  91. concat('同一模板编号',#{detailTable0.tmpcode},'下有重复的字段编号存在，请重新输入') else '' end as checkmsg from 
    92. 

  92. (select  tmpcode,tmpfieldcode,count(1) num from 
    93. 

  93. @]@]@>
    94. 

  94. <foreach collection="multiTable0" item="item" open="(" close=") a" separator=" union all ">
    95. 

  95. select #{detailTable0.tmpcode} tmpcode,#{item.tmpfieldcode} tmpfieldcode from dual
    96. 

  96. </foreach> 
    97. 

  97. group by tmpcode,tmpfieldcode) a
    98. 

  98. </if>		
    99. 

  99. <if test="multiTable0 == null or multiTable0.size()  == 0">
    100. 

  100.   select '0' as flag,'' as checkmsg from dual
    101. 

  101. </if>
    102. 

  102. </select></lbody><lbodyDbt></lbodyDbt><lbodyOra></lbodyOra><lbodyMysql></lbodyMysql></RDP_LOGICINFO>]]></detail></product><product><type>logs</type><code>ExcelTmpOneEditSave</code><version>13</version><name>Excel补录模板配置补录新增修改逻辑组</name><desc></desc><state>latest</state><visiblerange>public</visiblerange><suptype>rdp</suptype><supcode>ExcelTmpOneEdit</supcode><createenv>jdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster04</createenv><updateenv>10.1.80.1572883rdcdb</updateenv><recmodifyid>admin</recmodifyid><auditorid>admin</auditorid><recmodifydate>2024-12-11 10:49:04:546</recmodifydate><importmodifydate>2024-12-11 10:49:04:546</importmodifydate><changedesc>1</changedesc><module>_public</module><parameter></parameter><relation><product><type>log</type><code>ExcelTmpOneAddEditCheck</code><version>8</version></product><product><type>log</type><code>ExcelTmpOneEditCheck</code><version>10</version></product><product><type>log</type><code>ExcelTmpOneEditIsFile</code><version>5</version></product><product><type>log</type><code>ExcelTmpOneEditSave</code><version>9</version></product><product><type>log</type><code>ExcelTmpOneEditSave1</code><version>24</version></product><product><type>log</type><code>ExcelTmpOneEditSave2</code><version>14</version></product><product><type>log</type><code>ExcelTmpOneUpdateEditCheck</code><version>8</version></product></relation><detail><![CDATA[<RDP_LOGICSINFO><lid>ExcelTmpOneEditSave</lid><lverno>13</lverno><ltype>9</ltype><usetime>0</usetime><lbody></lbody><RDP_LOGICSRELATIONS><RDP_LOGICSRELATION><lsid>ExcelTmpOneEditSave</lsid><lsverno>13</lsverno><lid>ExcelTmpOneAddEditCheck</lid><ono>2</ono><isrstset>1</isrstset><rstsetcode>RstSetExcelTmpOneAddEditCheck</rstsetcode></RDP_LOGICSRELATION><RDP_LOGICSRELATION><lsid>ExcelTmpOneEditSave</lsid><lsverno>13</lsverno><lid>ExcelTmpOneEditCheck</lid><ono>0</ono><isrstset>1</isrstset><rstsetcode>RstSetExcelTmpOneEditCheck</rstsetcode></RDP_LOGICSRELATION><RDP_LOGICSRELATION><lsid>ExcelTmpOneEditSave</lsid><lsverno>13</lsverno><lid>ExcelTmpOneEditIsFile</lid><ono>1</ono><isrstset>1</isrstset><rstsetcode>RstSetExcelTmpOneEditIsFile</rstsetcode></RDP_LOGICSRELATION><RDP_LOGICSRELATION><lsid>ExcelTmpOneEditSave</lsid><lsverno>13</lsverno><lid>ExcelTmpOneEditSave</lid><ono>4</ono><isrstset>1</isrstset><rstsetcode>RstSetExcelTmpOneEditSave</rstsetcode></RDP_LOGICSRELATION><RDP_LOGICSRELATION><lsid>ExcelTmpOneEditSave</lsid><lsverno>13</lsverno><lid>ExcelTmpOneEditSave1</lid><ono>5</ono><isrstset>1</isrstset><rstsetcode>RstSetExcelTmpOneEditSave1</rstsetcode></RDP_LOGICSRELATION><RDP_LOGICSRELATION><lsid>ExcelTmpOneEditSave</lsid><lsverno>13</lsverno><lid>ExcelTmpOneEditSave2</lid><ono>6</ono><isrstset>1</isrstset><rstsetcode>RstSetExcelTmpOneEditSave2</rstsetcode></RDP_LOGICSRELATION><RDP_LOGICSRELATION><lsid>ExcelTmpOneEditSave</lsid><lsverno>13</lsverno><lid>ExcelTmpOneUpdateEditCheck</lid><ono>3</ono><isrstset>1</isrstset><rstsetcode>RstSetExcelTmpOneUpdateEditCheck</rstsetcode></RDP_LOGICSRELATION></RDP_LOGICSRELATIONS></RDP_LOGICSINFO>]]></detail></product></root>
    103.