查询模板默认字段查询去掉checkin等四个字段,修改查询模板查询接口中的属性查询改为一次性加载到本地。
| | |
| | | @ExcelColumn(value="From端对åºå
³ç³»") |
| | | private String relationFrom; |
| | | |
| | | // /** |
| | | // * 对åºå
³ç³»ï¼from端å¨åï¼to端å¨å |
| | | // */ |
| | | // @ExcelColumn(value="对åºå
³ç³»ï¼from端å¨åï¼to端å¨å") |
| | | // private String relation; |
| | | // /** |
| | | // * 对åºå
³ç³»ï¼from端å¨åï¼to端å¨å |
| | | // */ |
| | | // @ExcelColumn(value="对åºå
³ç³»ï¼from端å¨åï¼to端å¨å") |
| | | // private String relation; |
| | | |
| | | /** |
| | | * To端主类å |
| | |
| | | import com.vci.web.service.OsQuereyTemplateServiceI; |
| | | import com.vci.web.util.PlatformClientUtil; |
| | | import com.vci.web.util.WebUtil; |
| | | import com.vci.web.utility.AttributeDataFetcher; |
| | | import org.apache.commons.lang3.StringUtils; |
| | | import org.apache.commons.lang3.time.DateFormatUtils; |
| | | import org.dom4j.DocumentException; |
| | |
| | | }else { |
| | | qtdArray = platformClientUtil.getQTDService().getBizTypeQTDs(btmName); |
| | | } |
| | | //è·å屿§çæ°æ®å 载类 |
| | | AttributeDataFetcher attrDataFetcher = new AttributeDataFetcher(); |
| | | for (QTD qtd : qtdArray) { |
| | | QTDDTO qtddto = new QTDDTO(); |
| | | qtddto.setName(qtd.name); |
| | |
| | | qtddto.setBtmName(qtd.btmName); |
| | | qtddto.setCreator(qtd.creator); |
| | | for (String abName : qtd.abNames) { |
| | | AttributeDef att = platformClientUtil.getAttributeService().getAttributeDefByName(abName); |
| | | //AttributeDef att = platformClientUtil.getAttributeService().getAttributeDefByName(abName); |
| | | AttributeDef att = attrDataFetcher.getAttributeDef(abName); |
| | | //妿å¨å±æ§æ¥å£ä¸æ²¡ææ¥å°ç¸å
³å段åºè¯¥å°±å¨é»è®¤åæ®µä¸ |
| | | if(att == null || "".equals(att.oid)){ |
| | | att = allSysAttr.get(abName.toLowerCase()); |
| | |
| | | //ç³»ç»å±æ§ID,NAME,DESCRIPTION |
| | | for (int i = 0; i < SystemAttribute.bosysAttList().size(); i++) { |
| | | AttributeDef attributeDef = allSysAttr.get(SystemAttribute.bosysAttList().get(i).toLowerCase()); |
| | | if(Func.isEmpty(attributeDef)){ |
| | | break; |
| | | } |
| | | AttributeDefDTO attrDto = new AttributeDefDTO(); |
| | | attrDto.setDescription(attributeDef.description); |
| | | attrDto.setLabel(attributeDef.label); |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.vci.web.utility; |
| | | |
| | | import com.vci.corba.common.PLException; |
| | | import com.vci.corba.omd.atm.AttributeDef; |
| | | import com.vci.corba.portal.data.PLUILayout; |
| | | import com.vci.web.util.PlatformClientUtil; |
| | | |
| | | import java.util.*; |
| | | import java.util.stream.Collectors; |
| | | |
| | | /** |
| | | * å è½½UIä¸ä¸æ |
| | | * @author ludc |
| | | * @date 2024/10/15 10:32 |
| | | */ |
| | | public class AttributeDataFetcher { |
| | | |
| | | //屿§map |
| | | private Map<String, AttributeDef> AttributeDefMap = new HashMap<String, AttributeDef>(); |
| | | |
| | | public AttributeDataFetcher() { |
| | | initAttrDataibute(); |
| | | } |
| | | |
| | | public static void main(String[] args) { |
| | | new AttributeDataFetcher(); |
| | | } |
| | | |
| | | /** |
| | | * åå§åææå±æ§ä¿¡æ¯ |
| | | */ |
| | | private void initAttrDataibute() { |
| | | try { |
| | | PlatformClientUtil platformClientUtil = new PlatformClientUtil(); |
| | | AttributeDef[] attributeDefs = platformClientUtil.getAttributeService().getAttributeDefs("", 0, 0); |
| | | AttributeDefMap = Arrays.stream(attributeDefs).collect(Collectors.toMap(item -> item.name, item -> item)); |
| | | } catch (PLException e) { |
| | | e.printStackTrace(); |
| | | } |
| | | } |
| | | |
| | | /** |
| | | * è·å屿§ |
| | | * @param abName |
| | | * @return |
| | | */ |
| | | public AttributeDef getAttributeDef(String abName) { |
| | | return AttributeDefMap.get(abName); |
| | | } |
| | | |
| | | } |
| | |
| | | {"OID":"90e70653-fada-44d6-8e8e-a2875f5fdef7", "ID":"islastr", "NAME":"ææ°çæ¬", "DESCRIPTION":null, "ATTRIBUTEDATATYPE":"VTString", "ATTRIBUTEDATATYPETEXT":"å符串", "NULLABLEFLAG":"true", "DEFAULTVALUE":null, "ENUMID":null, "ENUMNAME":null, "BTMTYPEID":null, "BTMTYPENAME":null, "ATTRLENGTH":1, "PRECISIONLENGTH":0, "SCALELENGTH":2, "RANGE":null, "BTMNAME":"attribute", "OWNER":"developer", "CREATOR":"developer", "CREATETIME":"2020-06-29 10:33:47", "LASTMODIFIER":"sysAdmin", "LASTMODIFYTIME":"2022-03-30 19:04:08", "TS":"2022-03-30 19:04:08"}, |
| | | {"OID":"1741118b-f31b-4733-9942-9770c0d6eb14", "ID":"versionvalue", "NAME":"çæ¬¡", "DESCRIPTION":null, "ATTRIBUTEDATATYPE":"VTString", "ATTRIBUTEDATATYPETEXT":"å符串", "NULLABLEFLAG":"true", "DEFAULTVALUE":null, "ENUMID":null, "ENUMNAME":null, "BTMTYPEID":null, "BTMTYPENAME":null, "ATTRLENGTH":50, "PRECISIONLENGTH":0, "SCALELENGTH":2, "RANGE":null, "BTMNAME":"attribute", "OWNER":"developer", "CREATOR":"developer", "CREATETIME":"2020-06-29 10:33:47", "LASTMODIFIER":"sysAdmin", "LASTMODIFYTIME":"2022-03-30 19:04:08", "TS":"2022-03-30 19:04:08"}, |
| | | {"OID":"32a6a4f9-f826-47ad-b649-aa2aed0cb54a", "ID":"versionseq", "NAME":"çæ¬¡æåºå·", "DESCRIPTION":null, "ATTRIBUTEDATATYPE":"VTInteger", "ATTRIBUTEDATATYPETEXT":"æ°å", "NULLABLEFLAG":"true", "DEFAULTVALUE":null, "ENUMID":null, "ENUMNAME":null, "BTMTYPEID":null, "BTMTYPENAME":null, "ATTRLENGTH":0, "PRECISIONLENGTH":null, "SCALELENGTH":null, "RANGE":null, "BTMNAME":"attribute", "OWNER":"developer", "CREATOR":"developer", "CREATETIME":"2020-06-29 10:33:47", "LASTMODIFIER":"sysAdmin", "LASTMODIFYTIME":"2022-03-30 19:04:08", "TS":"2022-03-30 19:04:08"}, |
| | | /* |
| | | {"OID":"49e7b640-aac9-451c-93ea-ff7c7d23773e", "ID":"checkinby", "NAME":"ç¾å
¥äºº", "DESCRIPTION":null, "ATTRIBUTEDATATYPE":"VTString", "ATTRIBUTEDATATYPETEXT":"å符串", "NULLABLEFLAG":"true", "DEFAULTVALUE":null, "ENUMID":null, "ENUMNAME":null, "BTMTYPEID":null, "BTMTYPENAME":null, "ATTRLENGTH":50, "PRECISIONLENGTH":0, "SCALELENGTH":2, "RANGE":null, "BTMNAME":"attribute", "OWNER":"developer", "CREATOR":"developer", "CREATETIME":"2020-06-29 10:33:47", "LASTMODIFIER":"sysAdmin", "LASTMODIFYTIME":"2022-03-30 19:04:08", "TS":"2022-03-30 19:04:08"}, |
| | | */ |
| | | {"OID":"37b6f67f-8a0b-4a0c-85e8-c356984a376b", "ID":"revisionoid", "NAME":"çæ¬å¯¹è±¡ä¸»é®", "DESCRIPTION":null, "ATTRIBUTEDATATYPE":"VTString", "ATTRIBUTEDATATYPETEXT":"å符串", "NULLABLEFLAG":"true", "DEFAULTVALUE":null, "ENUMID":null, "ENUMNAME":null, "BTMTYPEID":null, "BTMTYPENAME":null, "ATTRLENGTH":50, "PRECISIONLENGTH":0, "SCALELENGTH":2, "RANGE":null, "BTMNAME":"attribute", "OWNER":"developer", "CREATOR":"developer", "CREATETIME":"2020-06-29 10:33:47", "LASTMODIFIER":"sysAdmin", "LASTMODIFYTIME":"2022-03-30 19:04:08", "TS":"2022-03-30 19:04:08"}, |
| | | {"OID":"500f5d60-1da9-4187-b061-1e21d6174934", "ID":"name", "NAME":"åç§°", "DESCRIPTION":null, "ATTRIBUTEDATATYPE":"VTString", "ATTRIBUTEDATATYPETEXT":"å符串", "NULLABLEFLAG":"true", "DEFAULTVALUE":null, "ENUMID":null, "ENUMNAME":null, "BTMTYPEID":null, "BTMTYPENAME":null, "ATTRLENGTH":4000, "PRECISIONLENGTH":0, "SCALELENGTH":2, "RANGE":null, "BTMNAME":"attribute", "OWNER":"developer", "CREATOR":"developer", "CREATETIME":"2020-06-29 10:33:47", "LASTMODIFIER":"sysAdmin", "LASTMODIFYTIME":"2022-03-30 19:04:08", "TS":"2022-03-30 19:04:08"}, |
| | | /* |
| | | {"OID":"0dc3247c-d632-41f2-9e2f-2318200ca30e", "ID":"checkintime", "NAME":"ç¾å
¥æ¶é´", "DESCRIPTION":null, "ATTRIBUTEDATATYPE":"VTDateTime", "ATTRIBUTEDATATYPETEXT":"æ¥ææ¶é´", "NULLABLEFLAG":"true", "DEFAULTVALUE":null, "ENUMID":null, "ENUMNAME":null, "BTMTYPEID":null, "BTMTYPENAME":null, "ATTRLENGTH":0, "PRECISIONLENGTH":null, "SCALELENGTH":null, "RANGE":null, "BTMNAME":"attribute", "OWNER":"developer", "CREATOR":"developer", "CREATETIME":"2020-06-29 10:33:47", "LASTMODIFIER":"sysAdmin", "LASTMODIFYTIME":"2022-03-30 19:04:08", "TS":"2022-03-30 19:04:08"}, |
| | | */ |
| | | {"OID":"46a6fdee-0cf3-4cb0-bcd3-3a6099155508", "ID":"lastmodifier", "NAME":"æåä¿®æ¹äºº", "DESCRIPTION":null, "ATTRIBUTEDATATYPE":"VTString", "ATTRIBUTEDATATYPETEXT":"å符串", "NULLABLEFLAG":"false", "DEFAULTVALUE":null, "ENUMID":null, "ENUMNAME":null, "BTMTYPEID":null, "BTMTYPENAME":null, "ATTRLENGTH":50, "PRECISIONLENGTH":0, "SCALELENGTH":2, "RANGE":null, "BTMNAME":"attribute", "OWNER":"developer", "CREATOR":"developer", "CREATETIME":"2020-06-29 10:33:47", "LASTMODIFIER":"sysAdmin", "LASTMODIFYTIME":"2022-03-30 19:04:08", "TS":"2022-03-30 19:04:08"}, |
| | | {"OID":"b93da256-f190-47eb-9281-ec014d7eae12", "ID":"islastv", "NAME":"ææ°çæ¬¡", "DESCRIPTION":null, "ATTRIBUTEDATATYPE":"VTString", "ATTRIBUTEDATATYPETEXT":"å符串", "NULLABLEFLAG":"true", "DEFAULTVALUE":null, "ENUMID":null, "ENUMNAME":null, "BTMTYPEID":null, "BTMTYPENAME":null, "ATTRLENGTH":1, "PRECISIONLENGTH":0, "SCALELENGTH":2, "RANGE":null, "BTMNAME":"attribute", "OWNER":"developer", "CREATOR":"developer", "CREATETIME":"2020-06-29 10:33:47", "LASTMODIFIER":"sysAdmin", "LASTMODIFYTIME":"2022-03-30 19:04:08", "TS":"2022-03-30 19:04:08"}, |
| | | {"OID":"666df0a2-25e5-4266-83d9-b12455dcdd73", "ID":"description", "NAME":"æè¿°", "DESCRIPTION":null, "ATTRIBUTEDATATYPE":"VTString", "ATTRIBUTEDATATYPETEXT":"å符串", "NULLABLEFLAG":"true", "DEFAULTVALUE":null, "ENUMID":null, "ENUMNAME":null, "BTMTYPEID":null, "BTMTYPENAME":null, "ATTRLENGTH":4000, "PRECISIONLENGTH":0, "SCALELENGTH":2, "RANGE":null, "BTMNAME":"attribute", "OWNER":"developer", "CREATOR":"developer", "CREATETIME":"2020-06-29 10:33:47", "LASTMODIFIER":"sysAdmin", "LASTMODIFYTIME":"2022-03-30 19:04:08", "TS":"2022-03-30 19:04:08"}, |
| | |
| | | {"OID":"01d364fc-1c32-4921-a79a-54952b63cc50", "ID":"revisionvalue", "NAME":"çæ¬", "DESCRIPTION":null, "ATTRIBUTEDATATYPE":"VTString", "ATTRIBUTEDATATYPETEXT":"å符串", "NULLABLEFLAG":"true", "DEFAULTVALUE":null, "ENUMID":null, "ENUMNAME":null, "BTMTYPEID":null, "BTMTYPENAME":null, "ATTRLENGTH":50, "PRECISIONLENGTH":0, "SCALELENGTH":null, "RANGE":null, "BTMNAME":"attribute", "OWNER":"developer", "CREATOR":"developer", "CREATETIME":"2020-06-29 10:33:47", "LASTMODIFIER":"sysAdmin", "LASTMODIFYTIME":"2022-03-30 19:04:08", "TS":"2022-03-30 19:04:08"}, |
| | | {"OID":"5f4e6bfe-58ed-44dd-87f7-2db3bde1084d", "ID":"creator", "NAME":"å建人", "DESCRIPTION":null, "ATTRIBUTEDATATYPE":"VTString", "ATTRIBUTEDATATYPETEXT":"å符串", "NULLABLEFLAG":"false", "DEFAULTVALUE":null, "ENUMID":null, "ENUMNAME":null, "BTMTYPEID":null, "BTMTYPENAME":null, "ATTRLENGTH":50, "PRECISIONLENGTH":0, "SCALELENGTH":2, "RANGE":null, "BTMNAME":"attribute", "OWNER":"developer", "CREATOR":"developer", "CREATETIME":"2020-06-29 10:33:47", "LASTMODIFIER":"sysAdmin", "LASTMODIFYTIME":"2022-03-30 19:04:08", "TS":"2022-03-30 19:04:08"}, |
| | | {"OID":"b019d1ed-eb6c-4778-9688-d0bdefc424c4", "ID":"revisionseq", "NAME":"çæ¬ç顺åº", "DESCRIPTION":null, "ATTRIBUTEDATATYPE":"VTInteger", "ATTRIBUTEDATATYPETEXT":"æ°å", "NULLABLEFLAG":"true", "DEFAULTVALUE":null, "ENUMID":null, "ENUMNAME":null, "BTMTYPEID":null, "BTMTYPENAME":null, "ATTRLENGTH":0, "PRECISIONLENGTH":null, "SCALELENGTH":null, "RANGE":null, "BTMNAME":"attribute", "OWNER":"developer", "CREATOR":"developer", "CREATETIME":"2020-06-29 10:33:47", "LASTMODIFIER":"sysAdmin", "LASTMODIFYTIME":"2022-03-30 19:04:08", "TS":"2022-03-30 19:04:08"}, |
| | | /* |
| | | {"OID":"6f875594-7bc0-4619-ac41-03e05b62ee76", "ID":"checkouttime", "NAME":"ç¾åºæ¶é´", "DESCRIPTION":null, "ATTRIBUTEDATATYPE":"VTDateTime", "ATTRIBUTEDATATYPETEXT":"æ¥ææ¶é´", "NULLABLEFLAG":"true", "DEFAULTVALUE":null, "ENUMID":null, "ENUMNAME":null, "BTMTYPEID":null, "BTMTYPENAME":null, "ATTRLENGTH":0, "PRECISIONLENGTH":null, "SCALELENGTH":null, "RANGE":null, "BTMNAME":"attribute", "OWNER":"developer", "CREATOR":"developer", "CREATETIME":"2020-06-29 10:33:47", "LASTMODIFIER":"sysAdmin", "LASTMODIFYTIME":"2022-03-30 19:04:08", "TS":"2022-03-30 19:04:08"}, |
| | | */ |
| | | /*{"OID":"4c3cb386-2b2e-44dc-8abe-f7cea714dae1", "ID":"secretgrade", "NAME":"å¯çº§", "DESCRIPTION":null, "ATTRIBUTEDATATYPE":"VTInteger", "ATTRIBUTEDATATYPETEXT":"æ°å", "NULLABLEFLAG":"true", "DEFAULTVALUE":null, "ENUMID":"Enumsecretgrade", "ENUMNAME":null, "BTMTYPEID":null, "BTMTYPENAME":null, "ATTRLENGTH":0, "PRECISIONLENGTH":null, "SCALELENGTH":null, "RANGE":null, "BTMNAME":"attribute", "OWNER":"developer", "CREATOR":"developer", "CREATETIME":"2020-06-29 10:33:47", "LASTMODIFIER":"sysAdmin", "LASTMODIFYTIME":"2022-03-30 19:04:08", "TS":"2022-03-30 19:04:08"},*/ |
| | | {"OID":"fc77bab5-8d18-47ff-8f60-6b13124b0b2e", "ID":"oid", "NAME":"主é®", "DESCRIPTION":null, "ATTRIBUTEDATATYPE":"VTString", "ATTRIBUTEDATATYPETEXT":"å符串", "NULLABLEFLAG":"false", "DEFAULTVALUE":null, "ENUMID":null, "ENUMNAME":null, "BTMTYPEID":null, "BTMTYPENAME":null, "ATTRLENGTH":150, "PRECISIONLENGTH":0, "SCALELENGTH":2, "RANGE":null, "BTMNAME":"attribute", "OWNER":"developer", "CREATOR":"developer", "CREATETIME":"2020-06-29 10:33:47", "LASTMODIFIER":"sysAdmin", "LASTMODIFYTIME":"2022-03-30 19:04:08", "TS":"2022-03-30 19:04:08"}, |
| | | /* |
| | | {"OID":"4f0dcea2-c10f-4979-b1c2-ce8db3bfa478", "ID":"checkoutby", "NAME":"ç¾åºäºº", "DESCRIPTION":null, "ATTRIBUTEDATATYPE":"VTString", "ATTRIBUTEDATATYPETEXT":"å符串", "NULLABLEFLAG":"true", "DEFAULTVALUE":null, "ENUMID":null, "ENUMNAME":null, "BTMTYPEID":null, "BTMTYPENAME":null, "ATTRLENGTH":50, "PRECISIONLENGTH":0, "SCALELENGTH":2, "RANGE":null, "BTMNAME":"attribute", "OWNER":"developer", "CREATOR":"developer", "CREATETIME":"2020-06-29 10:33:47", "LASTMODIFIER":"sysAdmin", "LASTMODIFYTIME":"2022-03-30 19:04:08", "TS":"2022-03-30 19:04:08"}, |
| | | */ |
| | | {"OID":"fb1242e7-aebc-49f1-8ef7-a40f87cbc5be", "ID":"nameoid", "NAME":"对象主é®", "DESCRIPTION":null, "ATTRIBUTEDATATYPE":"VTString", "ATTRIBUTEDATATYPETEXT":"å符串", "NULLABLEFLAG":"true", "DEFAULTVALUE":null, "ENUMID":null, "ENUMNAME":null, "BTMTYPEID":null, "BTMTYPENAME":null, "ATTRLENGTH":50, "PRECISIONLENGTH":0, "SCALELENGTH":2, "RANGE":null, "BTMNAME":"attribute", "OWNER":"developer", "CREATOR":"developer", "CREATETIME":"2020-06-29 10:33:47", "LASTMODIFIER":"sysAdmin", "LASTMODIFYTIME":"2022-03-30 19:04:08", "TS":"2022-03-30 19:04:08"}, |
| | | {"OID":"dd949ab2-f13c-4eb6-a394-8c953e5c7ba1", "ID":"isfirstr", "NAME":"ææ©çæ¬", "DESCRIPTION":null, "ATTRIBUTEDATATYPE":"VTString", "ATTRIBUTEDATATYPETEXT":"å符串", "NULLABLEFLAG":"true", "DEFAULTVALUE":null, "ENUMID":null, "ENUMNAME":null, "BTMTYPEID":null, "BTMTYPENAME":null, "ATTRLENGTH":1, "PRECISIONLENGTH":0, "SCALELENGTH":2, "RANGE":null, "BTMNAME":"attribute", "OWNER":"developer", "CREATOR":"developer", "CREATETIME":"2020-06-29 10:33:47", "LASTMODIFIER":"sysAdmin", "LASTMODIFYTIME":"2022-03-30 19:04:08", "TS":"2022-03-30 19:04:08"}, |
| | | {"OID":"58c50c62-9733-4d73-a3dc-6796eeddeb87", "ID":"isfirstv", "NAME":"ææ©çæ¬¡", "DESCRIPTION":null, "ATTRIBUTEDATATYPE":"VTString", "ATTRIBUTEDATATYPETEXT":"å符串", "NULLABLEFLAG":"true", "DEFAULTVALUE":null, "ENUMID":null, "ENUMNAME":null, "BTMTYPEID":null, "BTMTYPENAME":null, "ATTRLENGTH":1, "PRECISIONLENGTH":0, "SCALELENGTH":2, "RANGE":null, "BTMNAME":"attribute", "OWNER":"developer", "CREATOR":"developer", "CREATETIME":"2020-06-29 10:33:47", "LASTMODIFIER":"sysAdmin", "LASTMODIFYTIME":"2022-03-30 19:04:08", "TS":"2022-03-30 19:04:08"}, |