12345678910111213141516171819202122232425262728293031323334353637383940414243444546 |
- <?xml version="1.0" encoding="UTF-8"?><root><product><type>log</type><code>SupplementResultQuery</code><version>32</version><name>补录数据查询</name><desc></desc><state>latest</state><visiblerange>public</visiblerange><suptype>logs</suptype><supcode>SupplementResultQueryTEAM</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-02 17:01:27:846</recmodifydate><importmodifydate>2024-12-02 17:01:27:846</importmodifydate><changedesc>1</changedesc><module>_public</module><parameter></parameter><relation></relation><detail><![CDATA[<RDP_LOGICINFO><lid>SupplementResultQuery</lid><lverno>32</lverno><ltype>0</ltype><usetime>0</usetime><errormsg></errormsg><sqlexecutetype>1</sqlexecutetype><lbody><select>
- select
- sbi.taskbussinessid as taskbussinessid,
- sbi.term as term,
- sbi.taskCode as taskCode,
- isb.tmpname as taskCodeName,
- rist.tmpCode ,
- case when tb.tmpName is null then sn.nounname else tb.tmpName end as tmpCodeName,
- sbd.tmpRemark ,
- sbi.taskStartDate ,
- sbi.taskOrgcode ,
- so.orgName as taskOrgcodeName,
- sbi.taskFirstPerson ,
- suf.cnname as taskFirstPersonName ,
- sbi.taskReviewedPerson ,
- sur.cnname as taskReviewedPersonName ,
- risbf.flowbussinessid ,case when tb.tmpName is null then 1 else 0 end as isIndex
- from rmc_imput_suptaskrun_bussinessinfo sbi
- left join rmc_imput_suptaskrun_tmprelas rist on sbi.taskbussinessid = rist.taskbussinessid
- left join rmc_imput_suptaskrun_bussinessdetail sbd on sbi.taskbussinessid = sbd.taskbussinessid and sbi.taskCode = sbd.taskCode and rist.tmpCode = sbd.tmpCode
- left join rmc_imput_tmpconf_baseinfo tb on rist.tmpCode = tb.tmpcode
- left join sys_noun sn on sn.nounitem = 'TMP-INDEX-NOUN' and sn.nounvalue = rist.tmpcode
- left join rmc_imput_suptaskconf_baseinfo isb on isb.taskCode = sbi.taskCode
- left join sys_user suf on sbi.taskFirstPerson = suf.ACCOUNT
- left join sys_user sur on sbi.taskReviewedPerson = sur.ACCOUNT
- left join sys_organization so on sbi.taskOrgcode = so.ORGCODE
- left join rmc_imput_suptaskrun_bussinessflowinfo risbf on sbi.taskbussinessid = risbf.taskbussinessid
- where 1=1
- and sbi.taskStatus = '04'
- <if test="termParam !='' and termParam !=null">
- and sbi.term = #{termParam}
- </if>
- <if test="tmpCodesParam !='' and tmpCodesParam !=null">
- and rist.tmpCode in ( ${tmpCodesParam} )
- </if>
- <if test="_datascopeorg != null and _datascopeorg !='' ">
- AND risb.taskOrgcode in (${_datascopeorg)
- </if>
- <if test="_datascopeaccount != null and _datascopeaccount != '' ">
- AND sbi.taskReviewedPerson = #{_datascopeaccount}
- </if>
- <if test="_datascopeorg != null and _datascopeorg !='' ">
- AND suf.orgcode in (${_datascopeorg)
- </if>
- order by sbi.taskbussinessid desc, sbi.term desc , sbi.taskStartDate desc
- </select></lbody><lbodyDbt></lbodyDbt><lbodyOra></lbodyOra><lbodyMysql></lbodyMysql></RDP_LOGICINFO>]]></detail></product><product><type>logs</type><code>SupplementResultQueryTEAM</code><version>1</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>jdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster04</updateenv><recmodifyid>admin</recmodifyid><auditorid>admin</auditorid><recmodifydate>2024-10-13 11:07:54:931</recmodifydate><importmodifydate>2024-10-13 11:07:54:931</importmodifydate><changedesc>补录数据查询逻辑组</changedesc><module>_public</module><parameter></parameter><relation><product><type>log</type><code>SupplementResultQuery</code><version>32</version></product></relation><detail><![CDATA[<RDP_LOGICSINFO><lid>SupplementResultQueryTEAM</lid><lverno>1</lverno><ltype>9</ltype><usetime>0</usetime><lbody></lbody><RDP_LOGICSRELATIONS><RDP_LOGICSRELATION><lsid>SupplementResultQueryTEAM</lsid><lsverno>1</lsverno><lid>SupplementResultQuery</lid><ono>0</ono><isrstset>1</isrstset><rstsetcode>RstSetSupplementResultQuery</rstsetcode></RDP_LOGICSRELATION></RDP_LOGICSRELATIONS></RDP_LOGICSINFO>]]></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><product><type>rdp</type><code>TaskInfoViewShowIndex</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>li_gpu</recmodifyid><auditorid>li_gpu</auditorid><recmodifydate>2024-11-01 15:39:55:579</recmodifydate><importmodifydate>2024-11-01 15:39:55:579</importmodifydate><changedesc>增加页面指标查看功能</changedesc><module>_public</module><parameter><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>TaskInfoViewShowIndex</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>SupplementResultQuery</code><version>29</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>admin</recmodifyid><auditorid>admin</auditorid><recmodifydate>2024-12-02 16:50:30:303</recmodifydate><importmodifydate>2024-12-02 16:50:30:303</importmodifydate><changedesc>1</changedesc><module>_public</module><parameter></parameter><relation><product><type>logs</type><code>SupplementResultQueryTEAM</code><version>1</version></product><product><type>rdp</type><code>TaskInfoViewShowExcel</code><version>2</version></product><product><type>rdp</type><code>TaskInfoViewShowIndex</code><version>1</version></product></relation><detail><![CDATA[<RDP_FUNCTIONINFO RDP="new"><fcode>SupplementResultQuery</fcode><fverno>29</fverno><ftype></ftype><tcode>query</tcode><dftlid>SupplementResultQueryTEAM</dftlid><isinit>0</isinit><xmldata><template XML_CLASSNAME="com.sundata.product.rdp.model.template.QueryListTemplateDomain" defaultLogic="SupplementResultQueryTEAM" isNeedInit="0" layout="default"><conarea colnum="6"><conditions XML_TAGTYPE="list"><con XML_CLASSNAME="com.sundata.product.rdp.model.template.ConditionDomain" id="termParam" type="time" label="数据期次" colspan="1" defaulttype="1" defaultformat="yyyy-MM-dd" contentHandle="customJs.current.taskStart" datatype="string" timeType="data" dateFmt="yyyyMM" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></con><con XML_CLASSNAME="com.sundata.product.rdp.model.template.ConditionDomain" id="tmpCodesParam" type="select" label="数据补录模板" colspan="1" defaultformat="yyyy-MM-dd" dictype="logic" dicval="ExcelTmpQueryNoun" datatype="string" selectmultiple="on" precision="2" btnName="计算"><events XML_TAGTYPE="list"/></con><con XML_CLASSNAME="com.sundata.product.rdp.model.template.ConditionDomain" id="taskReviewedPersonParam" type="hide" label="当前登录人-审批人" colspan="1" defaulttype="2" defaultval="account" defaultformat="yyyy-MM-dd" datatype="string" 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="impot" type="rexcel" label="导出Excel" btnauthid="impot" opWinH="0" opWinW="0" isOperButton="false" isInLineButton="false"><dataStrList XML_TAGTYPE="list"/></btn></extButtons><tableReareas XML_TAGTYPE="list"><tabrearea XML_CLASSNAME="com.sundata.product.rdp.model.template.TableReareaDomain" paging="on" pagesumlab="小计" chooseCol="not" rowKey="TABLE_COLUMN_PK" title="补录数据清单" titletype="table_header" type="table" id="tabResultArea0" resultkey="RstSetSupplementResultQuery" left="0.00%" top="0.00%" width="100.00%" height="72.85%" 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="term" 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="tmpCode" label="模板编号" 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><res XML_CLASSNAME="com.sundata.product.rdp.model.template.ResultDomain" id="tmpCodeName" 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="taskbussinessid" label="taskbussinessid" 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><res XML_CLASSNAME="com.sundata.product.rdp.model.template.ResultDomain" id="tmpRemark" 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="taskStartDate" 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="taskOrgcodeName" 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="taskOrgcode" label="补录机构编号" 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><res XML_CLASSNAME="com.sundata.product.rdp.model.template.ResultDomain" id="taskFirstPersonName" 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="taskFirstPerson" label="补录人编号" 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><res XML_CLASSNAME="com.sundata.product.rdp.model.template.ResultDomain" id="taskReviewedPerson" label="审核人编号" 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><res XML_CLASSNAME="com.sundata.product.rdp.model.template.ResultDomain" id="taskReviewedPersonName" 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="commons" 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=TaskInfoViewShowExcel&anamode=display&flowbussinessid=${flowbussinessid}&taskCode=${taskCode}&taskCodeName=${taskCodeName}&taskFirstPerson=${taskFirstPersonName}&taskFirstPersonName=${taskFirstPersonName}&taskOrgcode=${taskOrgcode}&taskOrgcodeName=${taskOrgcodeName}&taskbussinessid=${taskbussinessid}&term=${term}&tmpCode=${tmpCode}&tmpCodeName=${tmpCodeName}','0','0')" btnauthid="showInfo" opWinH="0" opWinW="0" isOperButton="false" isInLineButton="false" funcTitle="数据明细"><OTHER btnHideSpan="(isIndex 属于 1)" btnHideInp="[[{"hideId":1730449849087,"index":0,"label":"isIndex","SYMBOL":"06","val":"1"}]]" hideId="HIDEID_3wez7tsifzi000" functionSel="{"prod_code":"TaskInfoViewShowExcel","anamode":"display","flowbussinessid":"${flowbussinessid}","taskCode":"${taskCode}","taskCodeName":"${taskCodeName}","taskFirstPerson":"${taskFirstPersonName}","taskFirstPersonName":"${taskFirstPersonName}","taskOrgcode":"${taskOrgcode}","taskOrgcodeName":"${taskOrgcodeName}","taskbussinessid":"${taskbussinessid}","term":"${term}","tmpCode":"${tmpCode}","tmpCodeName":"${tmpCodeName}"}" sortnum="1"/><dataStrList XML_TAGTYPE="list"/></btn><btn XML_CLASSNAME="com.sundata.product.rdp.model.template.ButtonDomain" type="normal" label="数据明细" events="function" onclick="callFuntion('modal','prod_code=TaskInfoViewShowIndex&flowbussinessid=${flowbussinessid}&taskbussinessid=${taskbussinessid}','0','0')" btnauthid="showIndex" opWinH="0" opWinW="0" isOperButton="false" isInLineButton="false" funcTitle="数据明细"><OTHER btnHideSpan="(isIndex 不属于 1)" btnHideInp="[[{"hideId":1730449874280,"index":0,"label":"isIndex","SYMBOL":"07","val":"1"}]]" hideId="HIDEID_158vxzqshc7400" functionSel="{"prod_code":"TaskInfoViewShowIndex","flowbussinessid":"${flowbussinessid}","taskbussinessid":"${taskbussinessid}"}" sortnum="2"/><dataStrList XML_TAGTYPE="list"/></btn></buttons></res><res XML_CLASSNAME="com.sundata.product.rdp.model.template.ResultDomain" id="taskCode" label="taskCode" 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><res XML_CLASSNAME="com.sundata.product.rdp.model.template.ResultDomain" id="flowbussinessid" label="flowbussinessid" 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><res XML_CLASSNAME="com.sundata.product.rdp.model.template.ResultDomain" id="taskCodeName" label="taskCodeName" 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><res XML_CLASSNAME="com.sundata.product.rdp.model.template.ResultDomain" id="isIndex" label="isIndex" 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.taskStart = (yearMonthStr) =>{&n;let year = yearMonthStr.substring(0, 4);&n;let month = yearMonthStr.substring(4, 6);&n; const date = new Date(year, month - 1, 1);&n;date.setMonth(date.getMonth() - 1);&n;const previousYear = date.getFullYear();&n;const previousMonth = date.getMonth() + 1;&n;return previousYear +previousMonth.toString().padStart(2, '0');&n;}&n;@]@]@></funcs></template></xmldata><furl><![CDATA[]]]]>><![CDATA[</furl><usetime>0</usetime><dftltype>logs</dftltype></RDP_FUNCTIONINFO>]]></detail></product></root>
|