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} ]]>logsExcelTmpOneEdit2Excel补录模板配置维护页面逻辑latestpublicrdpExcelTmpOneEditjdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster04jdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster04adminadmin2024-09-19 09:22:27:7392024-09-19 09:22:27:739111_publiclogExcelTmpOneEdit23logExcelTmpOneEdit17ExcelTmpOneEdit290ExcelTmpOneEdit2ExcelTmpOneEdit01RstSetExcelTmpOneEditExcelTmpOneEdit2ExcelTmpOneEdit111RstSetExcelTmpOneEdit1]]>logsExcelTmpOneEditSaveUpdata1Excel补录模板配置补录新增修改逻辑组latestpublicrdpExcelTmpOneEditUpdate10.1.80.882883rmcdb10.1.80.882883rmcdbqian_jweiqian_jwei2024-10-20 11:43:23:7182024-10-20 11:43:23:7181_publicExcelTmpOneEditSaveUpdata190ExcelTmpOneEditSaveUpdata1ExcelTmpOneEditSave01RstSetExcelTmpOneEditSaveExcelTmpOneEditSaveUpdata1ExcelTmpOneEditSave111RstSetExcelTmpOneEditSave1ExcelTmpOneEditSaveUpdata1ExcelTmpOneEditSave221RstSetExcelTmpOneEditSave2]]>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} ) ]]>logsExcelTmpQueryList2Excel补录模板配置主页面查询latestpublicrdpExcelTmpQueryListjdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster04jdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster04adminadmin2024-10-08 10:07:06:9982024-10-08 10:07:06:9981_publiclogExcelTmpQueryList14ExcelTmpQueryList290ExcelTmpQueryList2ExcelTmpQueryList01RstSetExcelTmpQueryList]]>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 ]]>logExcelTmpOneUpdateEditCheck8字段列表字段编号重复校验latestpubliclogsExcelTmpOneEditSave10.1.80.882883rmcdb10.1.80.882883rmcdbadminadmin2024-12-09 16:07:35:8132024-12-09 16:07:35:8131_publicExcelTmpOneUpdateEditCheck8002 1 then '2' else '0' end as flag,case when a.num>0 then concat('同一模板编号',#{detailTable0.tmpcode},'下有重复的字段编号存在，请重新输入') else '' end as checkmsg from (select tmpcode,tmpfieldcode,count(1) num from @]@]@> select #{detailTable0.tmpcode} tmpcode,#{item.tmpfieldcode} tmpfieldcode from dual group by tmpcode,tmpfieldcode) a select '0' as flag,'' as checkmsg from dual ]]>logsExcelTmpOneEditSave13Excel补录模板配置补录新增修改逻辑组latestpublicrdpExcelTmpOneEditjdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster0410.1.80.1572883rdcdbadminadmin2024-12-11 10:49:04:5462024-12-11 10:49:04:5461_publiclogExcelTmpOneAddEditCheck8logExcelTmpOneEditCheck10logExcelTmpOneEditIsFile5logExcelTmpOneEditSave9logExcelTmpOneEditSave124logExcelTmpOneEditSave214logExcelTmpOneUpdateEditCheck8ExcelTmpOneEditSave1390ExcelTmpOneEditSave13ExcelTmpOneAddEditCheck21RstSetExcelTmpOneAddEditCheckExcelTmpOneEditSave13ExcelTmpOneEditCheck01RstSetExcelTmpOneEditCheckExcelTmpOneEditSave13ExcelTmpOneEditIsFile11RstSetExcelTmpOneEditIsFileExcelTmpOneEditSave13ExcelTmpOneEditSave41RstSetExcelTmpOneEditSaveExcelTmpOneEditSave13ExcelTmpOneEditSave151RstSetExcelTmpOneEditSave1ExcelTmpOneEditSave13ExcelTmpOneEditSave261RstSetExcelTmpOneEditSave2ExcelTmpOneEditSave13ExcelTmpOneUpdateEditCheck31RstSetExcelTmpOneUpdateEditCheck]]>