| 12345678910111213141516171819202122232425 |
- <?xml version="1.0" encoding="UTF-8"?><root><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>
- 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
- <if test="tmpcode != null and tmpcode !=''">
- AND u1.tmpcode like concat('%',#{tmpcode},'%')
- </if>
- <if test="tmpname != null and tmpname !=''">
- AND u1.tmpname like concat('%',#{tmpname},'%')
- </if>
- <if test="tmptype != null and tmptype !=''">
- AND u1.tmptype in ( ${tmptype} )
- </if>
- </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>logs</type><code>eab_enterPI_del</code><version>2</version><name>Excel补录模板配置主页面删除逻辑</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>jdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster04</updateenv><recmodifyid>admin</recmodifyid><auditorid>admin</auditorid><recmodifydate>2024-09-22 18:35:39:064</recmodifydate><importmodifydate>2024-09-22 18:35:39:064</importmodifydate><changedesc>1</changedesc><module>_public</module><parameter></parameter><relation></relation><detail><![CDATA[<RDP_LOGICSINFO><lid>eab_enterPI_del</lid><lverno>2</lverno><ltype>9</ltype><usetime>0</usetime><lbody></lbody><RDP_LOGICSRELATIONS><RDP_LOGICSRELATION><lsid>eab_enterPI_del</lsid><lsverno>2</lsverno><lid>eab_enterPI_del</lid><ono>0</ono><isrstset>1</isrstset><rstsetcode>RstSeteab_enterPI_del</rstsetcode></RDP_LOGICSRELATION><RDP_LOGICSRELATION><lsid>eab_enterPI_del</lsid><lsverno>2</lsverno><lid>eab_enterPI_del2</lid><ono>1</ono><isrstset>1</isrstset><rstsetcode>RstSeteab_enterPI_del2</rstsetcode></RDP_LOGICSRELATION></RDP_LOGICSRELATIONS></RDP_LOGICSINFO>]]></detail></product><product><type>rdp</type><code>ExcelTmpOneEditSelect</code><version>2</version><name>Excel模板配置新增页面与修改页面</name><desc>null</desc><state>latest</state><visiblerange>public</visiblerange><suptype>rdp</suptype><supcode>eab_enter_personalInfo</supcode><createenv>10.1.80.882883rmcdb</createenv><updateenv>10.1.80.882883rmcdb</updateenv><recmodifyid>admin</recmodifyid><auditorid>admin</auditorid><recmodifydate>2024-11-01 17:42:56:552</recmodifydate><importmodifydate>2024-11-01 17:42:56:552</importmodifydate><changedesc>1</changedesc><module>9</module><parameter><param><paramcode>anamode</paramcode><paramname>解析模式</paramname><paramtype>1</paramtype><datatype></datatype><paramdesc>新增（add）、查询（query）、修改（modify）模式</paramdesc></param><param><paramcode>tmpcode</paramcode><paramname>模板编号</paramname><paramtype>1</paramtype><datatype></datatype><paramdesc>模板编号</paramdesc></param></parameter><relation></relation><detail><![CDATA[<RDP_FUNCTIONINFO RDP="new"><fcode>ExcelTmpOneEditSelect</fcode><fverno>2</fverno><ftype>null</ftype><tcode>maintain</tcode><dftlid>ExcelTmpOneEdit</dftlid><isinit>1</isinit><xmldata><infoMaintainTemplate XML_CLASSNAME="com.sundata.product.rdp.model.template.InfoMaintainTemplateDomain" defaultLogic="ExcelTmpOneEdit" isNeedInit="1" layout="grid"><pageTitle titletype="table_header" type="table" id="5616998985" 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" titletype="table_header" type="detail" id="detailTable0" resultkey="RstSetExcelTmpOneEdit" left="0.00%" top="0.00%" width="100.00%" height="40.00%" gridRow="ROOT" gridRowSpan="24" gridRowOrder="0" gridSpan="24" gridOrder="0"><ctrlConditions XML_TAGTYPE="list"/><dataItems XML_TAGTYPE="list"><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="tmpcode" 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="tmpfilename" 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="tmptype" type="display" label="模板类型" colspan="1" defaultformat="yyyy-MM-dd" dictype="dict" dicval="frequencm" datatype="string" singleLine="on" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="columnrange" 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="rowrange" 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="file" type="attachFile" label="模板文件上传" colspan="1" defaultformat="yyyy-MM-dd" datatype="string" attachType="EXCEL" attachSubType="${tmpfilecode}" maxFileNum="1" fileIsReadOnly="on" acceptFileType="xlsx,xls,txt,docx" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="tmpfilecode" type="hide" label="tmpfilecode" colspan="1" defaulttype="5" defaultval="tmpfilecode" defaultformat="yyyy-MM-dd" datatype="string" precision="2" btnName="计算"><OTHER initDefaultval="on"/><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></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="模板范围设置" titletype="table_header" type="multi" id="multiTable0" resultkey="RstSetExcelTmpOneEdit1" left="0.00%" top="0.00%" width="100.00%" height="40.00%" 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="tmpfieldcode" type="text" label="字段编号" colspan="1" notnull="on" 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="rowcoltype" type="select" label="行列类型" colspan="1" notnull="on" defaultformat="yyyy-MM-dd" dictype="dict" dicval="frequencr" datatype="string" onlyLeafCheck="on" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="filedrowrange" type="text" 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="filedcolumnrange" type="text" 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="filedcoltype" type="text" label="字段类型与长度" colspan="1" notnull="on" 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="remark" type="text" label="数据项说明" colspan="1" defaultformat="yyyy-MM-dd" maxlength="400" 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"/><funcs ischeck="on"><![CDATA[customJs.current.closeWindow=(a,b)=>{&n; utilJs.closeWin(true);&n;}&n;&n;&n;customJs.current.saveBeforeFun=(datas)=>{&n; var tmpcode=datas.detailTable0.tmpcode;&n; var rowfw=datas.detailTable0.rowrange;&n; var colfw=datas.detailTable0.columnrange;&n; var tmptype=datas.detailTable0.tmptype;&n;&n; const regex = /[\u4e00-\u9fff]+/g;&n;var flag=true;&n;if(regex.test(tmpcode)){&n; baseFun.warning('模板编号不能含有中文');&n; flag=false;&n;}&n;if(!flag){&n; return false;&n;}&n;const reg = /^\d+-\d+$/;&n;if(tmptype == 'FixedAll' || tmptype == 'FixedRow') {&n;if(!reg.test(rowfw)){&n; baseFun.warning('行范围内容不符合规范');&n; flag=false;&n;}&n;if(!flag){&n; return false;&n;}&n;}&n;if(tmptype == 'FixedAll' || tmptype == 'FixedCol') {&n;if(!reg.test(colfw)){&n; baseFun.warning('列范围内容不符合规范');&n; flag=false;&n;}&n;if(!flag){&n; return false;&n;}&n;}&n;&n; //判断列表中的行范围、列范围是否符合规范&n; //遍历集合获取预算类型&n; var msg='';&n; var midrow='';&n; var midcol='';&n; var seq=1;&n; let vals=(datas.multiTable0).values(); &n; for(let val of vals){&n;console.log('val.filedrowrange'+val.filedrowrange);&n;console.log('val.filedrowrange'+val.filedrowrange == '' || val.filedrowrange == undefined);&n;console.log('val.filedrowrange'+val.filedrowrange == undefined);&n;console.log('val.filedrowrange'+val.filedrowrange == '' );&n; if(!(val.filedrowrange == '' || val.filedrowrange == undefined) && !reg.test(val.filedrowrange)){&n; midrow='第【'+seq+'】行的行范围内容不符合规范！';&n; msg=msg+midrow+'\n';&n; flag=false;&n; midrow='';&n; } &n; if(!(val.filedcolumnrange == '' || val.filedcolumnrange == undefined) && !reg.test(val.filedcolumnrange)){&n; midcol+='第【'+seq+'】行的列范围内容不符合规范！';&n; msg=msg+midcol+'\n';&n; flag=false;&n; midcol='';&n; }&n; console.log('msg:',msg); &n; seq++; &n; }&n; if(!flag){&n; baseFun.warning(msg);&n; }&n;&n; return flag;&n;}@]@]@></funcs></infoMaintainTemplate></xmldata><furl><![CDATA[null]]]]>><![CDATA[</furl><usetime>0</usetime><dftltype>logs</dftltype></RDP_FUNCTIONINFO>]]></detail></product><product><type>rdp</type><code>ExcelTmpQueryList</code><version>25</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-12-09 15:50:58:858</recmodifydate><importmodifydate>2024-12-09 15:50:58:858</importmodifydate><changedesc>1111</changedesc><module>_public</module><parameter><param><paramcode>businesstypeid</paramcode><paramname>流程类型编号</paramname><paramtype>1</paramtype><datatype></datatype><paramdesc>流程类型编号</paramdesc></param></parameter><relation><product><type>logs</type><code>ExcelTmpQueryList</code><version>2</version></product><product><type>logs</type><code>eab_enterPI_del</code><version>2</version></product><product><type>rdp</type><code>ExcelTmpOneEditSelect</code><version>2</version></product></relation><detail><![CDATA[<RDP_FUNCTIONINFO RDP="new"><fcode>ExcelTmpQueryList</fcode><fverno>25</fverno><ftype>null</ftype><tcode>query</tcode><dftlid>ExcelTmpQueryList</dftlid><isinit>1</isinit><xmldata><template XML_CLASSNAME="com.sundata.product.rdp.model.template.QueryListTemplateDomain" defaultLogic="ExcelTmpQueryList" isNeedInit="1" layout="grid"><conarea colnum="6"><conditions XML_TAGTYPE="list"><con XML_CLASSNAME="com.sundata.product.rdp.model.template.ConditionDomain" id="tmpcode" 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="tmpname" 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="tmptype" type="select" label="模板类型" colspan="1" defaultformat="yyyy-MM-dd" dictype="dict" dicval="frequencm" datatype="string" selectmultiple="on" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></con></conditions></conarea><queryButtons XML_TAGTYPE="list"/><extButtons XML_TAGTYPE="list"><btn XML_CLASSNAME="com.sundata.product.rdp.model.template.ButtonDomain" id="insertId" type="normal" label="新增" events="function" onclick="callFuntion('undefined','prod_code=ExcelTmpOneEdit&anamode=add&tmpcode=','0','0')" btnauthid="insertId" opWinH="0" opWinW="0" isOperButton="false" isInLineButton="false" funcTitle="数据补录模板的新增页面"><OTHER functionSel="{"prod_code":"ExcelTmpOneEdit","anamode":"add","tmpcode":""}"/><dataStrList XML_TAGTYPE="list"/></btn></extButtons><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="RstSetExcelTmpQueryList" left="0.00%" top="0.00%" width="100.00%" height="79.79%" 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="tmpcode" 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="tmpname" 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="typname" 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="rowrange" 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="columnrange" 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="cz" label="操作" type="operate" datatype="text" 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=ExcelTmpOneEdit1&anamode=modify&tmpcode=${tmpcode}','0','0')" btnauthid="moditify" opWinH="0" opWinW="0" isOperButton="false" isInLineButton="false" funcTitle="数据补录模板的修改页面"><OTHER functionSel="{"prod_code":"ExcelTmpOneEdit1","anamode":"modify","tmpcode":"${tmpcode}"}" btnHideSpan="(approvestate01 属于 1) 或者 (approvestate01 属于 3)" btnHideInp="[[{"hideId":1703729433970,"index":0,"label":"approvestate01","SYMBOL":"06","val":"1"}],[{"hideId":1716288704461,"index":0,"label":"approvestate01","SYMBOL":"06","val":"3"}]]" hideId="HIDEID_z4ibe79wrsg00"/><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=ExcelTmpOneEditSelect&anamode=query&tmpcode=${tmpcode}','0','0')" btnauthid="query" opWinH="0" opWinW="0" isOperButton="false" isInLineButton="false" funcTitle="数据补录模板的信息查看"><OTHER hideId="HIDEID_do8hnzcznts00" functionSel="{"prod_code":"ExcelTmpOneEditSelect","anamode":"query","tmpcode":"${tmpcode}"}"/><dataStrList XML_TAGTYPE="list"/></btn><btn XML_CLASSNAME="com.sundata.product.rdp.model.template.ButtonDomain" type="normal" label="删除" events="choose" logic="eab_enterPI_del" logicType="logs" btnauthid="delete" opWinH="0" opWinW="0" isOperButton="false" isInLineButton="false"><OTHER btnHideSpan="" btnHideInp="[]" hideId="HIDEID_2lbxw5g9o0u000" confirmmess="请确认是否继续操作" isconfirm="on"/><dataStrList XML_TAGTYPE="list"/></btn></buttons></res><res XML_CLASSNAME="com.sundata.product.rdp.model.template.ResultDomain" id="tmptype" label="tmptype" 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"/><funcs ischeck="on"><![CDATA[customJs.current.submitFlow=(a,b)=>{&n; console.log(a);&n; let account=a.account;&n; let url='/zdyflowable/ZdyFlowableAction/beforeStartFlow.do';&n; &n; let processDefinitionKey='eab_grxxlrshlc';&n; let departcode=a.orgcode;&n; let businame='eab_grxxlrshlc'+'_'+departcode+'_'+a.account;&n; &n; utilJs.post(&n; url,&n; {data:{processDefinitionKey:processDefinitionKey,departcode:departcode,businame:businame}}&n; ).then((message)=>{&n; console.log(message);&n; let businessinsid=message;&n; let url02='/eab/EabPersonnalInfoInputAction/updateBusinessinsid.do';&n; utilJs.post(&n; url02,&n; {data:{businessinsid:businessinsid,account:account}}&n; );&n; utilJs.doSearch();&n; });&n; utilJs.doSearch();&n; baseFun.info("流程提交成功");&n;}&n;@]@]@></funcs></template></xmldata><furl><![CDATA[null]]]]>><![CDATA[</furl><usetime>0</usetime><dftltype>logs</dftltype></RDP_FUNCTIONINFO>]]></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>rdp</type><code>ExcelTmpOneEditUpdate</code><version>16</version><name>Excel模板配置新增页面与修改页面</name><desc>null</desc><state>latest</state><visiblerange>public</visiblerange><suptype>rdp</suptype><supcode>eab_enter_personalInfo</supcode><createenv>10.1.80.882883rmcdb</createenv><updateenv>10.1.80.882883rmcdb</updateenv><recmodifyid>admin</recmodifyid><auditorid>admin</auditorid><recmodifydate>2024-11-04 16:54:00:747</recmodifydate><importmodifydate>2024-11-04 16:54:00:747</importmodifydate><changedesc>1</changedesc><module>9</module><parameter><param><paramcode>anamode</paramcode><paramname>解析模式</paramname><paramtype>1</paramtype><datatype></datatype><paramdesc>新增（add）、查询（query）、修改（modify）模式</paramdesc></param><param><paramcode>tmpcode</paramcode><paramname>模板编号</paramname><paramtype>1</paramtype><datatype></datatype><paramdesc>模板编号</paramdesc></param></parameter><relation><product><type>logs</type><code>ExcelTmpOneEditSaveUpdata</code><version>1</version></product></relation><detail><![CDATA[<RDP_FUNCTIONINFO RDP="new"><fcode>ExcelTmpOneEditUpdate</fcode><fverno>16</fverno><ftype>null</ftype><tcode>maintain</tcode><dftlid>ExcelTmpOneEdit</dftlid><isinit>1</isinit><xmldata><infoMaintainTemplate XML_CLASSNAME="com.sundata.product.rdp.model.template.InfoMaintainTemplateDomain" defaultLogic="ExcelTmpOneEdit" isNeedInit="1" layout="grid"><pageTitle titletype="table_header" type="table" id="5616998985" 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="Excel补录模板配置维护页面" titletype="table_header" type="detail" id="detailTable0" resultkey="RstSetExcelTmpOneEdit" left="0.00%" top="0.00%" width="100.00%" height="39.90%" 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="1729236576833" ctrlName="Excel补录模板配置维护页面.模板类型 属于 'FixedCol'" contName="Excel补录模板配置维护页面.行范围 不显示 非必输 不可操作 并且 Excel补录模板配置维护页面.列范围 显示 必输 可操作" condition="{"hideId":1729236649193,"index":0,"label":"detailTable0.tmptype","symbol":"06","val":"'FixedCol'","type":"select"}" definition="{"hideId":1729236747613,"index":0,"id":"detailTable0.rowrange","display":"0","notnull":"0","notoperate":"1"},{"hideId":1729236916305,"index":1,"id":"detailTable0.columnrange","display":"1","notnull":"1","notoperate":"0"}"/><ctrlCondition XML_CLASSNAME="com.sundata.product.rdp.model.template.CtrlConditionDomain" hideId="1729236945049" ctrlName="Excel补录模板配置维护页面.模板类型 属于 'FixedRow'" contName="Excel补录模板配置维护页面.行范围 显示 必输 可操作 并且 Excel补录模板配置维护页面.列范围 不显示 非必输 不可操作" condition="{"hideId":1729236947353,"index":0,"label":"detailTable0.tmptype","symbol":"06","val":"'FixedRow'","type":"select"}" definition="{"hideId":1729236969703,"index":0,"id":"detailTable0.rowrange","display":"1","notnull":"1","notoperate":"0"},{"hideId":1729236993671,"index":1,"id":"detailTable0.columnrange","display":"0","notnull":"0","notoperate":"1"}"/><ctrlCondition XML_CLASSNAME="com.sundata.product.rdp.model.template.CtrlConditionDomain" hideId="1729237025573" ctrlName="Excel补录模板配置维护页面.模板名称 属于 'FixedAll'" contName="Excel补录模板配置维护页面.行范围 显示 必输 可操作 并且 Excel补录模板配置维护页面.列范围 显示 必输 可操作" condition="{"hideId":1729237029208,"index":0,"label":"detailTable0.tmpname","symbol":"06","val":"'FixedAll'","type":"text"}" definition="{"hideId":1729237090757,"index":0,"id":"detailTable0.rowrange","display":"1","notnull":"1"},{"hideId":1729237107036,"index":1,"id":"detailTable0.columnrange","display":"1","notnull":"1"}"/><ctrlCondition XML_CLASSNAME="com.sundata.product.rdp.model.template.CtrlConditionDomain" hideId="1729253970807" ctrlName="Excel补录模板配置维护页面.模板类型 不属于 'FixedCol','FixedRow'" contName="Excel补录模板配置维护页面.行范围 显示 必输 可操作 并且 Excel补录模板配置维护页面.列范围 显示 必输 可操作" condition="{"hideId":1729253972812,"index":0,"label":"detailTable0.tmptype","symbol":"07","val":"'FixedCol','FixedRow'","type":"select"}" definition="{"hideId":1729253985842,"index":0,"id":"detailTable0.rowrange","display":"1","notnull":"1","notoperate":"0"},{"hideId":1729254004804,"index":1,"id":"detailTable0.columnrange","display":"1","notnull":"1","notoperate":"0"}"/></ctrlConditions><dataItems XML_TAGTYPE="list"><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="tmpcode" type="text" label="模板编号" colspan="1" notnull="on" defaultformat="yyyy-MM-dd" maxlength="60" datatype="string" precision="2" isKey="on" 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="tmpfilename" 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="tmptype" type="select" label="模板类型" colspan="1" notnull="on" defaulttype="0" defaultval="FixedCol" defaultformat="yyyy-MM-dd" dictype="dict" dicval="frequencm" datatype="string" onlyLeafCheck="on" singleLine="on" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="rowrange" type="text" label="行范围" colspan="1" notnull="on" 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="columnrange" type="text" label="列范围" colspan="1" notnull="on" 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="file" type="attachFile" label="模板文件上传" colspan="1" notnull="on" defaultformat="yyyy-MM-dd" datatype="string" attachType="EXCEL" attachSubType="${tmpfilecode}" maxFileNum="1" acceptFileType="xlsx,xls,txt,docx" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="tmpfilecode" type="hide" label="tmpfilecode" colspan="1" defaulttype="5" defaultval="tmpfilecode" defaultformat="yyyy-MM-dd" datatype="string" precision="2" btnName="计算"><OTHER initDefaultval="on"/><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></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="multiTable0" resultkey="RstSetExcelTmpOneEdit1" left="0.00%" top="0.00%" width="100.00%" height="39.90%" 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="tmpfieldcode" type="text" label="字段编号" colspan="1" notnull="on" 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="rowcoltype" type="select" label="行列类型" colspan="1" notnull="on" defaultformat="yyyy-MM-dd" dictype="dict" dicval="frequencr" datatype="string" onlyLeafCheck="on" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="filedrowrange" type="text" 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="filedcolumnrange" type="text" 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="filedcoltype" type="text" label="字段类型与长度" colspan="1" notnull="on" 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="remark" 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" 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="saveId" type="save" label="保存" logic="ExcelTmpOneEditSaveUpdata" logicType="logs" onclick="callFuntion('modal','prod_code=eab_enterPI_list&anode=${anode}&account=${account}&gangw=${gangw}&inputId=${inputId}&inputDate=${inputDate}&updateDate=${updateDate}','0','0')" logicparamcfg="{"RstSetExcelTmpOneEditSave":"","RstSetExcelTmpOneEditSave1":"","RstSetExcelTmpOneEditSave2":""}" btnauthid="saveId" opWinH="0" opWinW="0" isOperButton="false" isInLineButton="false"><OTHER btnHideSpan="" btnHideInp="[]" logiclist="[{"NOUNNAME":"删除模板字段详情定义表","NOUNVALUE":"RstSetExcelTmpOneEditSave"},{"NOUNNAME":"新增或修改模板基本信息定义表","NOUNVALUE":"RstSetExcelTmpOneEditSave1"},{"NOUNNAME":"插入模板字段详情定义表","NOUNVALUE":"RstSetExcelTmpOneEditSave2"}]" isquerynshow="on"/><dataStrList XML_TAGTYPE="list"/></btn><btn XML_CLASSNAME="com.sundata.product.rdp.model.template.ButtonDomain" id="close" type="normal" label="关闭" events="hand" funcname="customJs.current.closeWindow" onclick="customJs.current.closeWindow()" btnauthid="close" opWinH="0" opWinW="0" isOperButton="false" isInLineButton="false"><OTHER btnHideSpan="" btnHideInp="[]"/><dataStrList XML_TAGTYPE="list"/></btn></bottomButtons><funcs ischeck="on"><![CDATA[customJs.current.closeWindow=(a,b)=>{&n; utilJs.closeWin(true);&n;}&n;&n;&n;customJs.current.saveBeforeFun=(datas)=>{&n; var rowfw=datas.detailTable0.rowrange;&n; var colfw =datas.detailTable0.columnrange;&n;var tmptype=datas.detailTable0.tmptype;&n; const regex = /^\d+-\d+$/;&n;var flag=true;&n;if(tmptype == 'FixedAll' || tmptype == 'FixedRow') {&n;if(!regex.test(rowfw)){&n; baseFun.warning('行范围内容不符合规范');&n; flag=false;&n;}&n;if(!flag){&n; return false;&n;}&n;}&n;&n;if(tmptype == 'FixedAll' || tmptype == 'FixedCol') {&n;if(!regex.test(colfw)){&n; baseFun.warning('列范围内容不符合规范');&n; flag=false;&n;}&n;if(!flag){&n; return false;&n;}&n;}&n;&n; //判断列表中的行范围、列范围是否符合规范&n; //遍历集合获取预算类型&n; var msg='';&n; var midrow='';&n; var midcol='';&n; var seq=1;&n; let vals=(datas.multiTable0).values(); &n; for(let val of vals){&n; if(!(val.filedrowrange == '' || val.filedrowrange == undefined) && !regex.test(val.filedrowrange)){&n; midrow='第【'+seq+'】行的行范围内容不符合规范！';&n; msg=msg+midrow+'\n';&n; flag=false;&n; midrow='';&n; } &n; if(!(val.filedcolumnrange == '' || val.filedcolumnrange == undefined) && !regex.test(val.filedcolumnrange)){&n; midcol+='第【'+seq+'】行的列范围内容不符合规范！';&n; msg=msg+midcol+'\n';&n; flag=false;&n; midcol='';&n; } &n; seq++; &n; }&n; if(!flag){&n; baseFun.warning(msg);&n; }&n; return flag;&n;}@]@]@></funcs></infoMaintainTemplate></xmldata><furl><![CDATA[null]]]]>><![CDATA[</furl><usetime>0</usetime><dftltype>logs</dftltype></RDP_FUNCTIONINFO>]]></detail></product><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>
- 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}
- </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>
- 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}
- </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>rdp</type><code>ExcelTmpOneEdit1</code><version>13</version><name>Excel模板配置新增页面与修改页面</name><desc>null</desc><state>latest</state><visiblerange>public</visiblerange><suptype>rdp</suptype><supcode>eab_enter_personalInfo</supcode><createenv>10.1.80.882883rmcdb</createenv><updateenv>10.1.80.1572883rdcdb</updateenv><recmodifyid>admin</recmodifyid><auditorid>admin</auditorid><recmodifydate>2024-12-11 13:54:42:014</recmodifydate><importmodifydate>2024-12-11 13:54:42:014</importmodifydate><changedesc>1</changedesc><module>_public</module><parameter><param><paramcode>anamode</paramcode><paramname>解析模式</paramname><paramtype>1</paramtype><datatype></datatype><paramdesc>新增（add）、查询（query）、修改（modify）模式</paramdesc></param><param><paramcode>tmpcode</paramcode><paramname>模板编号</paramname><paramtype>1</paramtype><datatype></datatype><paramdesc>模板编号</paramdesc></param></parameter><relation><product><type>logs</type><code>ExcelTmpOneEdit</code><version>2</version></product></relation><detail><![CDATA[<RDP_FUNCTIONINFO RDP="new"><fcode>ExcelTmpOneEdit1</fcode><fverno>13</fverno><ftype>null</ftype><tcode>maintain</tcode><dftlid>ExcelTmpOneEdit</dftlid><isinit>1</isinit><xmldata><infoMaintainTemplate XML_CLASSNAME="com.sundata.product.rdp.model.template.InfoMaintainTemplateDomain" defaultLogic="ExcelTmpOneEdit" isNeedInit="1" layout="grid"><pageTitle titletype="table_header" type="table" id="5616998985" 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="Excel补录模板配置维护页面" titletype="table_header" type="detail" id="detailTable0" resultkey="RstSetExcelTmpOneEdit" left="0.00%" top="0.00%" width="100.00%" height="39.94%" 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="1729236576833" ctrlName="Excel补录模板配置维护页面.模板类型 属于 ’FixedCol‘" contName="Excel补录模板配置维护页面.行范围 不显示 非必输 不可操作 并且 Excel补录模板配置维护页面.列范围 显示 必输 可操作" condition="{"hideId":1729236649193,"index":0,"label":"detailTable0.tmptype","symbol":"06","val":"’FixedCol‘","type":"select"}" definition="{"hideId":1729236747613,"index":0,"id":"detailTable0.rowrange","display":"0","notnull":"0","notoperate":"1"},{"hideId":1729236916305,"index":1,"id":"detailTable0.columnrange","display":"1","notnull":"1","notoperate":"0"}"/><ctrlCondition XML_CLASSNAME="com.sundata.product.rdp.model.template.CtrlConditionDomain" hideId="1729236945049" ctrlName="Excel补录模板配置维护页面.模板类型 属于 ‘FixedRow’" contName="Excel补录模板配置维护页面.行范围 显示 必输 可操作 并且 Excel补录模板配置维护页面.列范围 不显示 非必输 不可操作" condition="{"hideId":1729236947353,"index":0,"label":"detailTable0.tmptype","symbol":"06","val":"‘FixedRow’","type":"select"}" definition="{"hideId":1729236969703,"index":0,"id":"detailTable0.rowrange","display":"1","notnull":"1","notoperate":"0"},{"hideId":1729236993671,"index":1,"id":"detailTable0.columnrange","display":"0","notnull":"0","notoperate":"1"}"/><ctrlCondition XML_CLASSNAME="com.sundata.product.rdp.model.template.CtrlConditionDomain" hideId="1729237025573" ctrlName="Excel补录模板配置维护页面.模板名称 属于 'FixedAll'" contName="Excel补录模板配置维护页面.行范围 显示 必输 可操作 并且 Excel补录模板配置维护页面.列范围 显示 必输 可操作" condition="{"hideId":1729237029208,"index":0,"label":"detailTable0.tmpname","symbol":"06","val":"'FixedAll'","type":"text"}" definition="{"hideId":1729237090757,"index":0,"id":"detailTable0.rowrange","display":"1","notnull":"1"},{"hideId":1729237107036,"index":1,"id":"detailTable0.columnrange","display":"1","notnull":"1"}"/><ctrlCondition XML_CLASSNAME="com.sundata.product.rdp.model.template.CtrlConditionDomain" hideId="1729253970807" ctrlName="Excel补录模板配置维护页面.模板类型 不属于 'FixedCol','FixedRow'" contName="Excel补录模板配置维护页面.行范围 显示 必输 可操作 并且 Excel补录模板配置维护页面.列范围 显示 必输 可操作" condition="{"hideId":1729253972812,"index":0,"label":"detailTable0.tmptype","symbol":"07","val":"'FixedCol','FixedRow'","type":"select"}" definition="{"hideId":1729253985842,"index":0,"id":"detailTable0.rowrange","display":"1","notnull":"1","notoperate":"0"},{"hideId":1729254004804,"index":1,"id":"detailTable0.columnrange","display":"1","notnull":"1","notoperate":"0"}"/></ctrlConditions><dataItems XML_TAGTYPE="list"><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="tmpcode" type="display" label="模板编号" colspan="1" notnull="on" defaultformat="yyyy-MM-dd" dictype="dict" 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="tmpfilename" 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="tmptype" type="select" label="模板类型" colspan="1" notnull="on" defaultformat="yyyy-MM-dd" dictype="dict" dicval="frequencm" datatype="string" onlyLeafCheck="on" singleLine="on" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="columnrange" type="text" label="列范围" colspan="1" notnull="on" 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="rowrange" type="text" label="行范围" colspan="1" notnull="on" 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="file" type="attachFile" label="模板文件上传" colspan="1" notnull="on" defaultformat="yyyy-MM-dd" datatype="string" attachType="EXCEL" attachSubType="${tmpfilecode}" maxFileNum="1" acceptFileType="xlsx,xls,txt,docx" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="tmpfilecode" type="hide" label="tmpfilecode" colspan="1" defaulttype="5" defaultval="tmpfilecode" defaultformat="yyyy-MM-dd" datatype="string" precision="2" btnName="计算"><OTHER initDefaultval="on"/><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></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="multiTable0" resultkey="RstSetExcelTmpOneEdit1" left="0.00%" top="0.00%" width="100.00%" height="39.94%" 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="tmpfieldcode" type="text" label="字段编号" colspan="1" notnull="on" 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="rowcoltype" type="select" label="行列类型" colspan="1" notnull="on" defaultformat="yyyy-MM-dd" dictype="dict" dicval="frequencr" datatype="string" onlyLeafCheck="on" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="filedrowrange" type="text" 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="filedcolumnrange" type="text" 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="filedcoltype" type="text" label="字段类型与长度" colspan="1" notnull="on" 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="remark" type="text" label="数据项说明" colspan="1" defaultformat="yyyy-MM-dd" maxlength="400" 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="saveId" type="save" label="保存" logic="ExcelTmpOneEditSave" logicType="logs" onclick="callFuntion('modal','prod_code=eab_enterPI_list&anode=${anode}&account=${account}&gangw=${gangw}&inputId=${inputId}&inputDate=${inputDate}&updateDate=${updateDate}','0','0')" logicparamcfg="{"RstSetExcelTmpOneEditCheck":"","RstSetExcelTmpOneEditCheck1":"","RstSetExcelTmpOneAddEditCheck":"","RstSetExcelTmpOneUpdateEditCheck":"","RstSetExcelTmpOneEditSave":"","RstSetExcelTmpOneEditSave1":"","RstSetExcelTmpOneEditSave2":""}" btnauthid="saveId" opWinH="0" opWinW="0" isOperButton="false" isInLineButton="false"><OTHER btnHideSpan="" btnHideInp="[]" logiclist="[{"NOUNNAME":"新增或修改模板基本信息模板编号校验","NOUNVALUE":"RstSetExcelTmpOneEditCheck"},{"NOUNNAME":"新增或修改模板基本信息模板编号校验","NOUNVALUE":"RstSetExcelTmpOneEditCheck1"},{"NOUNNAME":"验证字段列表字段编号是否重复","NOUNVALUE":"RstSetExcelTmpOneAddEditCheck"},{"NOUNNAME":"字段列表字段编号重复校验","NOUNVALUE":"RstSetExcelTmpOneUpdateEditCheck"},{"NOUNNAME":"删除模板字段详情定义表","NOUNVALUE":"RstSetExcelTmpOneEditSave"},{"NOUNNAME":"新增或修改模板基本信息定义表","NOUNVALUE":"RstSetExcelTmpOneEditSave1"},{"NOUNNAME":"插入模板字段详情定义表","NOUNVALUE":"RstSetExcelTmpOneEditSave2"}]" isquerynshow="on"/><dataStrList XML_TAGTYPE="list"/></btn><btn XML_CLASSNAME="com.sundata.product.rdp.model.template.ButtonDomain" id="close" type="normal" label="关闭" events="hand" funcname="customJs.current.closeWindow" onclick="customJs.current.closeWindow()" btnauthid="close" opWinH="0" opWinW="0" isOperButton="false" isInLineButton="false"><OTHER btnHideSpan="" btnHideInp="[]"/><dataStrList XML_TAGTYPE="list"/></btn></bottomButtons><funcs ischeck="on"><![CDATA[customJs.current.closeWindow=(a,b)=>{&n; utilJs.closeWin(true);&n;}&n;&n;&n;customJs.current.saveBeforeFun=(datas)=>{&n; var tmpcode=datas.detailTable0.tmpcode;&n; var rowfw=datas.detailTable0.rowrange;&n; var colfw=datas.detailTable0.columnrange;&n; var tmptype=datas.detailTable0.tmptype;&n; var tmptype=datas.detailTable0.tmptype;&n; const regex = /[\u4e00-\u9fff]+/g;&n;var flag=true;&n;if(regex.test(tmpcode)){&n; baseFun.warning('模板编号不能含有中文');&n; flag=false;&n;}&n;if(!flag){&n; return false;&n;}&n;let rowcon = 0;&n;const reg = /^\d+-\d+$/;&n;if(tmptype == 'FixedAll' || tmptype == 'FixedRow') {&n;if(!reg.test(rowfw)){&n; baseFun.warning('行范围内容不符合规范');&n; flag=false;&n;} else {&n;rowcon = rowfw.indexOf("-"); &n;}&n;if(!flag){&n; return false;&n;}&n;}&n;console.log('行中:'+rowcon);&n;let colcon = 0;&n;if(tmptype == 'FixedAll' || tmptype == 'FixedCol') {&n;if(!reg.test(colfw)){&n; baseFun.warning('列范围内容不符合规范');&n; flag=false;&n;} else {&n;colcon = colfw.indexOf("-"); &n;}&n;if(!flag){&n; return false;&n;}&n;}&n; let rowstart = 0;&n;let rowend = 0;&n;if (rowcon != 0) {&n;rowstart = rowfw.substring(0, rowcon);&n;rowend = rowfw.substring(rowcon + 1); &n;}&n; let colstart = 0;&n;let colend = 0;&n;if (colcon != 0) {&n;colstart = colfw.substring(0, colcon );&n;colend = colfw.substring(colcon + 1); &n;}&n;&n;console.log('行前:'+rowstart);&n;console.log('行后:'+rowend);&n; //判断列表中的行范围、列范围是否符合规范&n; //遍历集合获取预算类型&n; var msg='';&n; var midrow='';&n; var midcol='';&n; var seq=1;&n; let vals=(datas.multiTable0).values(); &n; for(let val of vals){&n; console.log("行范围"+'val.tmpfieldcode'+val.tmpfieldcode);//行范围&n; console.log("列范围"+'val.filedcolumnrange'+val.filedcolumnrange);//列范围&n;console.log(1+'val.filedrowrange'+val.filedrowrange);&n;console.log(2+'val.filedrowrange'+val.filedrowrange == '' || val.filedrowrange == undefined);&n;console.log(3+'val.filedrowrange'+val.filedrowrange == undefined);&n;console.log(4+'val.filedrowrange'+val.filedrowrange == '' );&n;if(!(val.filedrowrange == '' || val.filedrowrange == undefined)) { &n;if(!reg.test(val.filedrowrange)){&n; midrow='第【'+seq+'】行的行范围内容不符合规范！';&n; msg=msg+midrow+'\n';&n; flag=false;&n; midrow='';&n; } else {&n; let rowfwcon = val.filedrowrange.indexOf("-"); //行范围&n; let rowfwstart = val.filedrowrange.substring(0, rowfwcon);&n; let rowfwend = val.filedrowrange.substring(rowfwcon + 1); &n;console.log('rowfwstart:'+rowfwstart);&n;console.log('rowfwend:'+rowfwend);&n;console.log('行前大小:'+rowfwstart < rowstart);&n;console.log('行后大小:'+parseInt(rowfwend) > parseInt(rowend));&n; if(parseInt(rowcon) != 0 && (parseInt(rowfwstart) < parseInt(rowstart) || parseInt(rowfwend) > parseInt(rowend))) {&n; // midrow= '第【'+seq+'】行的行范围内容需要小于等于上方行范围内容！';&n; midrow= '第【'+seq+'】行的行范围录入错误！';&n; msg=msg+midrow+'\n';&n; flag=false;&n; midrow='';&n; }&n; } &n;} &n;if(!(val.filedcolumnrange == '' || val.filedcolumnrange == undefined)) {&n; if(!reg.test(val.filedcolumnrange)){&n; midcol+='第【'+seq+'】行的列范围内容不符合规范！';&n; msg=msg+midcol+'\n';&n; flag=false;&n; midcol='';&n; } else {&n; let colfwcon = val.filedcolumnrange.indexOf("-"); //列范围&n; let colfwstart = val.filedcolumnrange.substring(0, colfwcon);&n; let colfwend = val.filedcolumnrange.substring(colfwcon + 1); &n;console.log('colfwstart:'+colfwstart);&n;console.log('colfwend:'+colfwend);&n; if(parseInt(colcon) != 0 && (parseInt(colfwstart) < parseInt(colstart) || parseInt(colfwend) > parseInt(colend))) {&n; // midcol+= '第【'+seq+'】行的列范围内容需要小于等于上方列范围内容！';&n; midcol+= '第【'+seq+'】行的列范围录入错误！';&n; msg=msg+midcol+'\n';&n; flag=false;&n; midcol='';&n; }&n; }&n;}&n; console.log('msg:',msg); &n; seq++; &n; }&n; if(!flag){&n; baseFun.warning(msg);&n; }&n;&n; var tmpfieldcode=datas.multiTable0.tmpfieldcode;&n; console.log('tmpfieldcode:',tmpfieldcode);&n; return flag;&n;}@]@]@></funcs></infoMaintainTemplate></xmldata><furl><![CDATA[null]]]]>><![CDATA[</furl><usetime>0</usetime><dftltype>logs</dftltype></RDP_FUNCTIONINFO>]]></detail></product><product><type>rdp</type><code>ExcelTmpOneEdit</code><version>83</version><name>Excel模板配置新增页面与修改页面</name><desc>null</desc><state>latest</state><visiblerange>public</visiblerange><suptype>rdp</suptype><supcode>eab_enter_personalInfo</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 13:37:35:556</recmodifydate><importmodifydate>2024-12-11 13:37:35:556</importmodifydate><changedesc>1</changedesc><module>9</module><parameter><param><paramcode>anamode</paramcode><paramname>解析模式</paramname><paramtype>1</paramtype><datatype></datatype><paramdesc>新增（add）、查询（query）、修改（modify）模式</paramdesc></param><param><paramcode>tmpcode</paramcode><paramname>模板编号</paramname><paramtype>1</paramtype><datatype></datatype><paramdesc>模板编号</paramdesc></param></parameter><relation></relation><detail><![CDATA[<RDP_FUNCTIONINFO RDP="new"><fcode>ExcelTmpOneEdit</fcode><fverno>83</fverno><ftype>null</ftype><tcode>maintain</tcode><dftlid>ExcelTmpOneEdit</dftlid><isinit>1</isinit><xmldata><infoMaintainTemplate XML_CLASSNAME="com.sundata.product.rdp.model.template.InfoMaintainTemplateDomain" defaultLogic="ExcelTmpOneEdit" isNeedInit="1" layout="grid"><pageTitle titletype="table_header" type="table" id="5616998985" 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="Excel补录模板配置维护页面" titletype="table_header" type="detail" id="detailTable0" resultkey="RstSetExcelTmpOneEdit" left="0.00%" top="0.00%" width="100.00%" height="39.94%" 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="1729236576833" ctrlName="Excel补录模板配置维护页面.模板类型 属于 ’FixedCol‘" contName="Excel补录模板配置维护页面.行范围 不显示 非必输 不可操作 并且 Excel补录模板配置维护页面.列范围 显示 必输 可操作" condition="{"hideId":1729236649193,"index":0,"label":"detailTable0.tmptype","symbol":"06","val":"’FixedCol‘","type":"select"}" definition="{"hideId":1729236747613,"index":0,"id":"detailTable0.rowrange","display":"0","notnull":"0","notoperate":"1"},{"hideId":1729236916305,"index":1,"id":"detailTable0.columnrange","display":"1","notnull":"1","notoperate":"0"}"/><ctrlCondition XML_CLASSNAME="com.sundata.product.rdp.model.template.CtrlConditionDomain" hideId="1729236945049" ctrlName="Excel补录模板配置维护页面.模板类型 属于 ‘FixedRow’" contName="Excel补录模板配置维护页面.行范围 显示 必输 可操作 并且 Excel补录模板配置维护页面.列范围 不显示 非必输 不可操作" condition="{"hideId":1729236947353,"index":0,"label":"detailTable0.tmptype","symbol":"06","val":"‘FixedRow’","type":"select"}" definition="{"hideId":1729236969703,"index":0,"id":"detailTable0.rowrange","display":"1","notnull":"1","notoperate":"0"},{"hideId":1729236993671,"index":1,"id":"detailTable0.columnrange","display":"0","notnull":"0","notoperate":"1"}"/><ctrlCondition XML_CLASSNAME="com.sundata.product.rdp.model.template.CtrlConditionDomain" hideId="1729237025573" ctrlName="Excel补录模板配置维护页面.模板名称 属于 'FixedAll'" contName="Excel补录模板配置维护页面.行范围 显示 必输 可操作 并且 Excel补录模板配置维护页面.列范围 显示 必输 可操作" condition="{"hideId":1729237029208,"index":0,"label":"detailTable0.tmpname","symbol":"06","val":"'FixedAll'","type":"text"}" definition="{"hideId":1729237090757,"index":0,"id":"detailTable0.rowrange","display":"1","notnull":"1"},{"hideId":1729237107036,"index":1,"id":"detailTable0.columnrange","display":"1","notnull":"1"}"/><ctrlCondition XML_CLASSNAME="com.sundata.product.rdp.model.template.CtrlConditionDomain" hideId="1729253970807" ctrlName="Excel补录模板配置维护页面.模板类型 不属于 'FixedCol','FixedRow'" contName="Excel补录模板配置维护页面.行范围 显示 必输 可操作 并且 Excel补录模板配置维护页面.列范围 显示 必输 可操作" condition="{"hideId":1729253972812,"index":0,"label":"detailTable0.tmptype","symbol":"07","val":"'FixedCol','FixedRow'","type":"select"}" definition="{"hideId":1729253985842,"index":0,"id":"detailTable0.rowrange","display":"1","notnull":"1","notoperate":"0"},{"hideId":1729254004804,"index":1,"id":"detailTable0.columnrange","display":"1","notnull":"1","notoperate":"0"}"/></ctrlConditions><dataItems XML_TAGTYPE="list"><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="tmpcode" type="text" label="模板编号" colspan="1" notnull="on" defaultformat="yyyy-MM-dd" ctype="account" maxlength="30" 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="tmpfilename" 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="tmptype" type="select" label="模板类型" colspan="1" notnull="on" defaultformat="yyyy-MM-dd" dictype="dict" dicval="frequencm" datatype="string" onlyLeafCheck="on" singleLine="on" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="columnrange" type="text" label="列范围" colspan="1" notnull="on" 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="rowrange" type="text" label="行范围" colspan="1" notnull="on" 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="file" type="attachFile" label="模板文件上传" colspan="1" notnull="on" defaultformat="yyyy-MM-dd" datatype="string" attachType="EXCEL" attachSubType="${tmpfilecode}" maxFileNum="1" acceptFileType="xlsx,xls,txt,docx" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="tmpfilecode" type="hide" label="tmpfilecode" colspan="1" defaulttype="5" defaultval="tmpfilecode" defaultformat="yyyy-MM-dd" datatype="string" precision="2" btnName="计算"><OTHER initDefaultval="on"/><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></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="multiTable0" resultkey="RstSetExcelTmpOneEdit1" left="0.00%" top="0.00%" width="100.00%" height="39.94%" 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="tmpfieldcode" type="text" label="字段编号" colspan="1" notnull="on" 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="rowcoltype" type="select" label="行列类型" colspan="1" notnull="on" defaultformat="yyyy-MM-dd" dictype="dict" dicval="frequencr" datatype="string" onlyLeafCheck="on" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></dataItem><dataItem XML_CLASSNAME="com.sundata.product.rdp.model.template.DataItemDomain" id="filedrowrange" type="text" 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="filedcolumnrange" type="text" 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="filedcoltype" type="text" label="字段类型与长度" colspan="1" notnull="on" 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="remark" type="text" label="数据项说明" colspan="1" defaultformat="yyyy-MM-dd" maxlength="400" 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="saveId" type="save" label="保存" logic="ExcelTmpOneEditSave" logicType="logs" onclick="callFuntion('modal','prod_code=eab_enterPI_list&anode=${anode}&account=${account}&gangw=${gangw}&inputId=${inputId}&inputDate=${inputDate}&updateDate=${updateDate}','0','0')" logicparamcfg="{"RstSetExcelTmpOneEditCheck":"","RstSetExcelTmpOneAddEditCheck":"","RstSetExcelTmpOneUpdateEditCheck":"","RstSetExcelTmpOneEditSave":"","RstSetExcelTmpOneEditSave1":"","RstSetExcelTmpOneEditSave2":""}" btnauthid="saveId" opWinH="0" opWinW="0" isOperButton="false" isInLineButton="false"><OTHER btnHideSpan="" btnHideInp="[]" logiclist="[{"NOUNNAME":"新增或修改模板基本信息模板编号校验","NOUNVALUE":"RstSetExcelTmpOneEditCheck"},{"NOUNNAME":"验证字段列表字段编号是否重复","NOUNVALUE":"RstSetExcelTmpOneAddEditCheck"},{"NOUNNAME":"字段列表字段编号重复校验","NOUNVALUE":"RstSetExcelTmpOneUpdateEditCheck"},{"NOUNNAME":"删除模板字段详情定义表","NOUNVALUE":"RstSetExcelTmpOneEditSave"},{"NOUNNAME":"新增或修改模板基本信息定义表","NOUNVALUE":"RstSetExcelTmpOneEditSave1"},{"NOUNNAME":"插入模板字段详情定义表","NOUNVALUE":"RstSetExcelTmpOneEditSave2"}]" isquerynshow="on"/><dataStrList XML_TAGTYPE="list"/></btn><btn XML_CLASSNAME="com.sundata.product.rdp.model.template.ButtonDomain" id="close" type="normal" label="关闭" events="hand" funcname="customJs.current.closeWindow" onclick="customJs.current.closeWindow()" btnauthid="close" opWinH="0" opWinW="0" isOperButton="false" isInLineButton="false"><OTHER btnHideSpan="" btnHideInp="[]"/><dataStrList XML_TAGTYPE="list"/></btn></bottomButtons><funcs ischeck="on"><![CDATA[customJs.current.closeWindow=(a,b)=>{&n; utilJs.closeWin(true);&n;}&n;&n;&n;customJs.current.saveBeforeFun=(datas)=>{&n; var tmpcode=datas.detailTable0.tmpcode;&n; var rowfw=datas.detailTable0.rowrange;&n; var colfw=datas.detailTable0.columnrange;&n; var tmptype=datas.detailTable0.tmptype;&n; var tmptype=datas.detailTable0.tmptype;&n; const regex = /[\u4e00-\u9fff]+/g;&n;var flag=true;&n;if(regex.test(tmpcode)){&n; baseFun.warning('模板编号不能含有中文');&n; flag=false;&n;}&n;if(!flag){&n; return false;&n;}&n;let rowcon = 0;&n;const reg = /^\d+-\d+$/;&n;if(tmptype == 'FixedAll' || tmptype == 'FixedRow') {&n;if(!reg.test(rowfw)){&n; baseFun.warning('行范围内容不符合规范');&n; flag=false;&n;} else {&n;rowcon = rowfw.indexOf("-"); &n;}&n;if(!flag){&n; return false;&n;}&n;}&n;console.log('行中:'+rowcon);&n;&n;let colcon = 0;&n;if(tmptype == 'FixedAll' || tmptype == 'FixedCol') {&n;if(!reg.test(colfw)){&n; baseFun.warning('列范围内容不符合规范');&n; flag=false;&n;} else {&n;colcon = colfw.indexOf("-"); &n;}&n;if(!flag){&n; return false;&n;}&n;}&n; let rowstart = 0;&n;let rowend = 0;&n;if (rowcon != 0) {&n;rowstart = rowfw.substring(0, rowcon);&n;rowend = rowfw.substring(rowcon + 1); &n;}&n; let colstart = 0;&n;let colend = 0;&n;if (colcon != 0) {&n;colstart = colfw.substring(0, colcon );&n;colend = colfw.substring(colcon + 1); &n;}&n;&n;console.log('行前:'+rowstart);&n;console.log('行后:'+rowend);&n;&n; //判断列表中的行范围、列范围是否符合规范&n; //遍历集合获取预算类型&n; var msg='';&n; var midrow='';&n; var midcol='';&n; var seq=1;&n; let vals=(datas.multiTable0).values(); &n; for(let val of vals){&n; console.log("行范围"+'val.tmpfieldcode'+val.tmpfieldcode);//行范围&n; console.log("列范围"+'val.filedcolumnrange'+val.filedcolumnrange);//列范围&n;console.log(1+'val.filedrowrange'+val.filedrowrange);&n;console.log(2+'val.filedrowrange'+val.filedrowrange == '' || val.filedrowrange == undefined);&n;console.log(3+'val.filedrowrange'+val.filedrowrange == undefined);&n;console.log(4+'val.filedrowrange'+val.filedrowrange == '' );&n;if(!(val.filedrowrange == '' || val.filedrowrange == undefined)) { &n;if(!reg.test(val.filedrowrange)){&n; midrow='第【'+seq+'】行的行范围内容不符合规范！';&n; msg=msg+midrow+'\n';&n; flag=false;&n; midrow='';&n; } else {&n; let rowfwcon = val.filedrowrange.indexOf("-"); //行范围&n; let rowfwstart = val.filedrowrange.substring(0, rowfwcon);&n; let rowfwend = val.filedrowrange.substring(rowfwcon + 1); &n;console.log('rowfwstart:'+rowfwstart);&n;console.log('rowfwend:'+rowfwend);&n; if(parseInt(rowcon) != 0 && (parseInt(rowfwstart) < parseInt(rowstart) || parseInt(rowfwend) > parseInt(rowend))) {&n; // midrow= '第【'+seq+'】行的行范围内容需要小于等于上方行范围内容！';&n; midrow= '第【'+seq+'】行的行范围录入错误！';&n; msg=msg+midrow+'\n';&n; flag=false;&n; midrow='';&n; }&n; } &n;}&n; if(!(val.filedcolumnrange == '' || val.filedcolumnrange == undefined)) { &n; if(!reg.test(val.filedcolumnrange)){&n; midcol+='第【'+seq+'】行的列范围内容不符合规范！';&n; msg=msg+midcol+'\n';&n; flag=false;&n; midcol='';&n; } else {&n; let colfwcon = val.filedcolumnrange.indexOf("-"); //列范围&n; let colfwstart = val.filedcolumnrange.substring(0, colfwcon);&n; let colfwend = val.filedcolumnrange.substring(colfwcon + 1); &n;console.log('colfwstart:'+colfwstart);&n;console.log('colfwend:'+colfwend);&n; if(parseInt(colcon) != 0 && (parseInt(colfwstart) < parseInt(colstart) || parseInt(colfwend) > parseInt(colend))) {&n; // midcol+= '第【'+seq+'】行的列范围内容需要小于等于上方列范围内容！';&n; midcol+= '第【'+seq+'】行的列范围录入错误！';&n; msg=msg+midcol+'\n';&n; flag=false;&n; midcol='';&n; }&n; }&n; }&n;&n; console.log('msg:',msg); &n; seq++; &n; }&n; if(!flag){&n; baseFun.warning(msg);&n; }&n;&n; var tmpfieldcode=datas.multiTable0.tmpfieldcode;&n; console.log('tmpfieldcode:',tmpfieldcode);&n; return flag;&n;}@]@]@></funcs></infoMaintainTemplate></xmldata><furl><![CDATA[null]]]]>><![CDATA[</furl><usetime>0</usetime><dftltype>logs</dftltype></RDP_FUNCTIONINFO>]]></detail></product><product><type>rdp</type><code>ShowExcel</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>qian_jwei</recmodifyid><auditorid>qian_jwei</auditorid><recmodifydate>2024-10-22 10:45:36:240</recmodifydate><importmodifydate>2024-10-22 10:45:36:240</importmodifydate><changedesc>0121 提交，向zsc导出提交</changedesc><module>_public</module><parameter><param><paramcode>anamode</paramcode><paramname>查看模式</paramname><paramtype>1</paramtype><datatype></datatype><paramdesc></paramdesc></param><param><paramcode>flowbussinessid</paramcode><paramname>补录流程实例</paramname><paramtype>1</paramtype><datatype></datatype><paramdesc>null</paramdesc></param><param><paramcode>taskbussinessid</paramcode><paramname>补录任务实例</paramname><paramtype>1</paramtype><datatype></datatype><paramdesc>null</paramdesc></param></parameter><relation></relation><detail><![CDATA[<RDP_FUNCTIONINFO RDP="new"><fcode>ShowExcel</fcode><fverno>1</fverno><ftype></ftype><tcode>coding</tcode><dftlid></dftlid><isinit></isinit><xmldata></xmldata><furl><![CDATA[]]]]>><![CDATA[</furl><usetime>0</usetime><dftltype></dftltype></RDP_FUNCTIONINFO>]]></detail></product><product><type>rdp</type><code>TaskInfoViewShowExcel</code><version>2</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>qian_jwei</recmodifyid><auditorid>qian_jwei</auditorid><recmodifydate>2024-10-22 12:50:04:363</recmodifydate><importmodifydate>2024-10-22 12:50:04:363</importmodifydate><changedesc>1</changedesc><module>_public</module><parameter><param><paramcode>anamode</paramcode><paramname>查看模式</paramname><paramtype>1</paramtype><datatype></datatype><paramdesc></paramdesc></param><param><paramcode>flowbussinessid</paramcode><paramname>补录流程实例</paramname><paramtype>1</paramtype><datatype></datatype><paramdesc>null</paramdesc></param><param><paramcode>taskCode</paramcode><paramname>补录任务编号</paramname><paramtype>1</paramtype><datatype></datatype><paramdesc>null</paramdesc></param><param><paramcode>taskCodeName</paramcode><paramname>taskCodeName</paramname><paramtype>1</paramtype><datatype></datatype><paramdesc>null</paramdesc></param><param><paramcode>taskFirstPerson</paramcode><paramname>补录人ID</paramname><paramtype>1</paramtype><datatype></datatype><paramdesc>null</paramdesc></param><param><paramcode>taskFirstPersonName</paramcode><paramname>补录人名称</paramname><paramtype>1</paramtype><datatype></datatype><paramdesc>null</paramdesc></param><param><paramcode>taskOrgcode</paramcode><paramname>补录机构编号ID</paramname><paramtype>1</paramtype><datatype></datatype><paramdesc>null</paramdesc></param><param><paramcode>taskOrgcodeName</paramcode><paramname>补录机构</paramname><paramtype>1</paramtype><datatype></datatype><paramdesc>null</paramdesc></param><param><paramcode>taskbussinessid</paramcode><paramname>补录任务实例，业务流程实例号</paramname><paramtype>1</paramtype><datatype></datatype><paramdesc>null</paramdesc></param><param><paramcode>term</paramcode><paramname>数据期次</paramname><paramtype>1</paramtype><datatype></datatype><paramdesc>null</paramdesc></param><param><paramcode>tmpCode</paramcode><paramname>补录模板编号</paramname><paramtype>1</paramtype><datatype></datatype><paramdesc>null</paramdesc></param><param><paramcode>tmpCodeName</paramcode><paramname>补录模板名称</paramname><paramtype>1</paramtype><datatype></datatype><paramdesc>null</paramdesc></param></parameter><relation></relation><detail><![CDATA[<RDP_FUNCTIONINFO RDP="new"><fcode>TaskInfoViewShowExcel</fcode><fverno>2</fverno><ftype></ftype><tcode>coding</tcode><dftlid></dftlid><isinit></isinit><xmldata></xmldata><furl><![CDATA[]]]]>><![CDATA[</furl><usetime>0</usetime><dftltype></dftltype></RDP_FUNCTIONINFO>]]></detail></product></root>
|
