Etusivu Tutki Apua
Rekisteröidy Kirjaudu sisään
RWA
/
RWAServer
3
2
Fork 0
Tiedostot Ongelmat 0 Pull-pyynnöt 0 Wiki
Puu: fcb926d05b
Haarat Tagit
RWAServer
/
ShortCode
/
001-初始化
/
李庚谱
/
补录功能
/
Excel-one-2.cfg

Excel-one-2.cfg 14 KB
Historia Raaka

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495 
  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>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>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>
    26. 

  26.    <![CDATA[
    27. 

  27. select id,text from (
    28. 

  28. select itb.tmpcode as ID, itb.tmpname  as TEXT from rmc_imput_tmpconf_baseinfo itb
    29. 

  29. union all 
    30. 

  30. 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' 
    31. 

  31. ) order by id
    32. 

  32.    @]@]@> 
    33. 

  33. </select></lbody><lbodyDbt></lbodyDbt><lbodyOra></lbodyOra><lbodyMysql></lbodyMysql></RDP_LOGICINFO>]]></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">
    34. 

  34. <if test="detailTable0.anamode=='add'">
    35. 

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

  36. <foreach collection="multiTable0" item="item" separator=" union all ">
    37. 

  37. <![CDATA[
    38. 

  38. 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 
    39. 

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

  40. @]@]@>
    41. 

  41. 		</foreach>
    42. 

  42. </if>
    43. 

  43. </if>
    44. 

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

  45.   select '0' as flag,'' as checkmsg from dual
    46. 

  46. </if>
    47. 

  47. </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">
    48. 

  48. <if test="detailTable0.anamode == 'add'">
    49. 

  49. <![CDATA[
    50. 

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

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

  52. @]@]@>
    53. 

  53. </if>
    54. 

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

  55.   select '0' as flag,'' as checkmsg from dual
    56. 

  56. </if>
    57. 

  57. </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">
    58. 

  58. <![CDATA[
    59. 

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

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

  61. @]@]@>
    62. 

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

  63. <![CDATA[
    64. 

  64. and tmpcode != #{detailTable0.tmpcode}
    65. 

  65. @]@]@>
    66. 

  66. </if>
    67. 

  67. ) a
    68. 

  68. </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>
    69. 

  69. DELETE  FROM  rmc_imput_tmpconf_fielddetails u1 WHERE u1.tmpcode = #{detailTable0.tmpcode}
    70. 

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

  71. 	<if test="detailTable0.anamode== 'add' ">
    72. 

  72. 		INSERT INTO rmc_imput_tmpconf_baseinfo
    73. 

  73. 		(tmpcode, tmpname, tmptype, rowrange, columnrange, tmpfilecode,tmpfilename) 
    74. 

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

  75. 	</if>
    76. 

  76. 	<if test="detailTable0.anamode== 'modify' ">
    77. 

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

  78. 		where tmpcode = #{detailTable0.tmpcode} 
    79. 

  79. 	</if>
    80. 

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

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

  82. 		INSERT INTO rmc_imput_tmpconf_fielddetails
    83. 

  83. (tmpcode, tmpfieldcode, rowcoltype, filedrowrange, filedcolumnrange,filedcoltype,remark)
    84. 

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

  85. 				<![CDATA[
    86. 

  86. 				select #{detailTable0.tmpcode},#{item.tmpfieldcode},#{item.rowcoltype},#{item.filedrowrange},
    87. 

  87. 				#{item.filedcolumnrange} ,#{item.filedcoltype},#{item.remark}
    88. 

  88. 				from dual
    89. 

  89. 				@]@]@>
    90. 

  90. 		</foreach>
    91. 

  91. </if>
    92. 

  92. <if test="multiTable0 == null or multiTable0.size() == 0">
    93. 

  93. select  '1'  from dual
    94. 

  94. </if>
    95. 

  95. </insert></lbody><lbodyDbt></lbodyDbt><lbodyOra></lbodyOra><lbodyMysql></lbodyMysql></RDP_LOGICINFO>]]></detail></product></root>
    96.