logExcelTmpOneEdit23Excel补录模板配置维护基本信息查询nulllatestpubliclogseab_enterPI_insert_selectjdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster0410.1.80.882883rmcdbadminadmin2024-10-08 19:47:51:4432024-10-08 19:47:51:4431_publicExcelTmpOneEdit23001 select u1.tmpcode,u1.tmpname ,u3.nounname, u1.tmptype,u1.rowrange,u1.columnrange,tmpfilename,tmpfilecode from rmc_imput_tmpconf_baseinfo u1 inner JOIN sys_noun u3 on u3.nounitem ='tmptype' AND u3.nounvalue =u1.tmptype where 1=1 AND u1.tmpcode= #{tmpcode} ]]>logExcelTmpOneEdit17Excel补录模板配置维护明细信息nulllatestpublic_PUBLIC_PUBLICjdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster0410.1.80.882883rmcdbadminadmin2024-10-10 18:00:54:7482024-10-10 18:00:54:7481_publicExcelTmpOneEdit17001 select u1.tmpcode,u1.tmpfieldcode,u1.rowcoltype,u1.filedrowrange,u1.filedcolumnrange,u1.filedcoltype,u1.remark from rmc_imput_tmpconf_fielddetails u1 inner JOIN sys_noun u3 on u3.nounitem ='rowcoltype' AND u3.nounvalue =u1.rowcoltype where 1=1 AND u1.tmpcode = #{tmpcode} ]]>logExcelTmpQueryList14Excel模板配置主页面查询nulllatestpubliclogsExcelTmpQueryListjdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster0410.1.80.882883rmcdbqian_jweiqian_jwei2024-10-22 22:08:27:8092024-10-22 22:08:27:8091_publicExcelTmpQueryList14001 select u1.tmpcode,u1.tmpname ,u3.nounname typname,u1.tmptype,u1.rowrange,u1.columnrange from rmc_imput_tmpconf_baseinfo u1 inner JOIN sys_noun u3 on u3.nounitem ='tmptype' AND u3.nounvalue =u1.tmptype where 1=1 AND u1.tmpcode like concat('%',#{tmpcode},'%') AND u1.tmpname like concat('%',#{tmpname},'%') AND u1.tmptype in ( ${tmptype} ) ]]>logExcelTmpQueryNoun7模板配置字典latestpublic_PUBLIC_PUBLICjdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster0410.1.80.882883rmcdbli_gpuli_gpu2024-10-30 19:40:32:2542024-10-30 19:40:32:2542024-10-30_publicExcelTmpQueryNoun7001 ]]>logExcelTmpOneAddEditCheck8验证字段列表字段编号是否重复latestpublic_PUBLIC_PUBLIC10.1.80.882883rmcdb10.1.80.882883rmcdbadminadmin2024-10-23 14:22:52:1472024-10-23 14:22:52:1471_publicExcelTmpOneAddEditCheck8002 0 then '2' else '0' end as flag,case when a.num > 0 then concat('模板编号',#{detailTable0.tmpcode},'的字段编号',#{item.tmpfieldcode},'已存在，请重新输入') else '' end as checkmsg from (select count(1) as num from rmc_imput_tmpconf_fielddetails where tmpcode=#{detailTable0.tmpcode} and tmpfieldcode = #{item.tmpfieldcode}) a @]@]@> select '0' as flag,'' as checkmsg from dual ]]>logExcelTmpOneEditCheck10新增或修改模板基本信息模板编号校验latestpubliclogsExcelTmpOneEditSave10.1.80.882883rmcdb10.1.80.882883rmcdbadminadmin2024-12-11 09:40:40:7052024-12-11 09:40:40:7051_publicExcelTmpOneEditCheck10002 0 then '2' else '0' end as flag,case when a.num>0 then '模板编号已存在，请重新输入' else '' end as checkmsg from (select count(1) as num from rmc_imput_tmpconf_baseinfo where tmpcode=#{detailTable0.tmpcode}) a @]@]@> select '0' as flag,'' as checkmsg from dual ]]>logExcelTmpOneEditIsFile5校验文件名称是否已存在latestpublic_PUBLIC_PUBLIC10.1.80.1572883rdcdb10.1.80.882883rmcdbadminadmin2024-12-11 09:55:33:8562024-12-11 09:55:33:8561_publicExcelTmpOneEditIsFile5002 0 then '2' else '0' end as flag,case when a.num>0 then '文件名称已存在，请重新输入' else '' end as checkmsg from (select count(1) as num from rmc_imput_tmpconf_baseinfo where tmpfilename=#{detailTable0.tmpfilename} @]@]@> ) a ]]>logExcelTmpOneEditSave9删除模板字段详情定义表latestpubliclogsExcelTmpOneEditSavejdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster0410.1.80.882883rmcdbadminadmin2024-10-08 15:13:08:7012024-10-08 15:13:08:7012_publicExcelTmpOneEditSave9001 DELETE FROM rmc_imput_tmpconf_fielddetails u1 WHERE u1.tmpcode = #{detailTable0.tmpcode} ]]>logExcelTmpOneEditSave124新增或修改模板基本信息定义表latestpubliclogsExcelTmpOneEditSavejdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster0410.1.80.882883rmcdbadminadmin2024-10-19 18:27:05:4812024-10-19 18:27:05:4811_publicExcelTmpOneEditSave124001 INSERT INTO rmc_imput_tmpconf_baseinfo (tmpcode, tmpname, tmptype, rowrange, columnrange, tmpfilecode,tmpfilename) VALUES (#{detailTable0.tmpcode}, #{detailTable0.tmpname},#{detailTable0.tmptype},#{detailTable0.rowrange},#{detailTable0.columnrange},#{detailTable0.tmpfilecode},#{detailTable0.tmpfilename} ) update rmc_imput_tmpconf_baseinfo set tmpname=#{detailTable0.tmpname},tmptype=#{detailTable0.tmptype}, rowrange=#{detailTable0.rowrange},columnrange=#{detailTable0.columnrange},tmpfilecode=#{detailTable0.tmpfilecode},tmpfilename=#{detailTable0.tmpfilename} where tmpcode = #{detailTable0.tmpcode} ]]>logExcelTmpOneEditSave214插入模板字段详情定义表latestpubliclogsExcelTmpOneEditSavejdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster0410.1.80.882883rmcdbadminadmin2024-10-23 16:45:55:7202024-10-23 16:45:55:7201_publicExcelTmpOneEditSave214001 INSERT INTO rmc_imput_tmpconf_fielddetails (tmpcode, tmpfieldcode, rowcoltype, filedrowrange, filedcolumnrange,filedcoltype,remark) select '1' from dual ]]>