From f2a97a13efaf924d152b0f1c727005c1e0eef810 Mon Sep 17 00:00:00 2001 From: fujunling <2984387807@qq.com> Date: 星期日, 25 六月 2023 18:04:41 +0800 Subject: [PATCH] 历史导入 --- Source/UBCS/ubcs-service/ubcs-code/src/main/java/com/vci/ubcs/code/service/impl/MdmEngineServiceImpl.java | 82 +++++++++++++++++++++-------------------- 1 files changed, 42 insertions(+), 40 deletions(-) diff --git a/Source/UBCS/ubcs-service/ubcs-code/src/main/java/com/vci/ubcs/code/service/impl/MdmEngineServiceImpl.java b/Source/UBCS/ubcs-service/ubcs-code/src/main/java/com/vci/ubcs/code/service/impl/MdmEngineServiceImpl.java index 7367fb7..b34af4d 100644 --- a/Source/UBCS/ubcs-service/ubcs-code/src/main/java/com/vci/ubcs/code/service/impl/MdmEngineServiceImpl.java +++ b/Source/UBCS/ubcs-service/ubcs-code/src/main/java/com/vci/ubcs/code/service/impl/MdmEngineServiceImpl.java @@ -3,6 +3,7 @@ import com.alibaba.fastjson.JSONObject; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; +import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.baomidou.mybatisplus.extension.toolkit.SqlHelper; import com.vci.ubcs.code.bo.CodeClassifyFullInfoBO; @@ -55,6 +56,7 @@ import org.slf4j.LoggerFactory; import org.springblade.core.cache.utils.CacheUtil; import org.springblade.core.launch.constant.AppConstant; +import org.springblade.core.log.exception.ServiceException; import org.springblade.core.secure.utils.AuthUtil; import org.springblade.core.tool.api.R; import org.springblade.core.tool.utils.DateUtil; @@ -77,7 +79,6 @@ import java.time.ZonedDateTime; import java.util.*; import java.util.concurrent.ConcurrentHashMap; -import java.util.function.Supplier; import java.util.stream.Collectors; import static com.vci.ubcs.code.constant.FrameWorkLangCodeConstant.DATA_OID_NOT_EXIST; @@ -138,6 +139,15 @@ */ @Autowired private FormulaServiceImpl formulaService; + + + /** + * 瀵筼md涓彁渚涚殑feign鎺ュ彛杩涜璋冪敤锛屼互鍙婂鐞嗙浉鍏抽�昏緫 + */ + @Autowired + ICodeReferBtmTypeService codeReferBtmTypeService; + + /** * 鐩镐技椤规煡璇㈣鍒� @@ -1729,9 +1739,9 @@ String field = UBCSSqlKeyword.getColumn(key, "_like"); if (referFieldMap.containsKey(field)) { //璇存槑杩樻槸鍙傜収閲岄潰鐨勶紝鎴戜滑榛樿杩欑鎯呭喌涓嬮兘鏄瓧绗︿覆鍚э紝鍥犱负鍙傜収鐨勫睘鎬т笉涓�瀹氱敤鐨勫钩鍙扮殑灞炴�ф睜閲岀殑锛屾墍浠ュぇ閮ㄥ垎鎯呭喌涓嬶紝鏄剧ず鐨勫睘鎬ч兘鏄瓧绗︿覆鍚� - return referFieldMap.get(field) + SPACE + "LIKE" + SPACE + "%" + value + "%)" + SPACE; + return referFieldMap.get(field) + SPACE + "LIKE" + SPACE + "'%" + value + "%'" + SPACE; } else { - return (field.contains(".") ? "" : "t.") + field + SPACE + "LIKE " + "%" + getStringValueInWhere(field, value, attrVOMap) + "%)" + SPACE; + return (field.contains(".") ? "" : "t.") + field + SPACE + "LIKE " + "'%" + getStringValueInWhere(field, value, attrVOMap) + "%'" + SPACE; } } else if (key.endsWith("_notequal")) { String field = UBCSSqlKeyword.getColumn(key, "_notequal"); @@ -1849,9 +1859,9 @@ }else if(key.endsWith("_equal")) { String field = UBCSSqlKeyword.getColumn(key, "_equal"); if (referFieldMap.containsKey(field)) { - return referFieldMap.get(field) + SPACE + "= " + value + SPACE; + return referFieldMap.get(field) + SPACE + "= '" + value + "'" + SPACE; } else { - return (field.contains(".") ? "" : "t.") + field + SPACE + "= " + getStringValueInWhere(field, value, attrVOMap) + SPACE; + return (field.contains(".") ? "" : "t.") + field + SPACE + "= '" + getStringValueInWhere(field, value, attrVOMap) + "'" + SPACE; } }else { if (referFieldMap.containsKey(key)) { @@ -1914,7 +1924,7 @@ } if (field.contains(".") && attrVOMap != null && attrVOMap.containsKey(field.split("\\.")[0].toLowerCase(Locale.ROOT))) { //鏄弬鐓� - return "'" + value + "'"; + return value; } else { return value; } @@ -1938,13 +1948,13 @@ || VciFieldTypeEnum.VTInteger.equals(fieldTypeEnum)) { return value; } else { - return "'" + value + "'"; + return value; } } else { if ((value.startsWith("(") && value.endsWith(")")) || (value.startsWith("'") && value.endsWith("'"))) { return value; } - return "'" + value + "'"; + return value; } } @@ -3349,52 +3359,33 @@ * 鑾峰彇鍙傜収鐨勪俊鎭� * * @param referConfigVO 鍙傜収鐨勯厤缃� - * @param pageHelper 鍒嗛〉鐨勫伐鍏� * @return 鍒楄〃鏁版嵁 */ @Override - public DataGrid referDataGrid(UIFormReferVO referConfigVO, PageHelper pageHelper) { + public Page<BtmTypeVO> referDataGrid(UIFormReferVO referConfigVO, BaseQueryObject baseQueryObject) { // checkReferConfig(referConfigVO); //浣跨敤涓氬姟绫诲瀷鏌ヨ R<BtmTypeVO> allAttributeByBtmId = btmTypeClient.getAllAttributeByBtmId(referConfigVO.getReferType()); BtmTypeVO btmTypeVO = allAttributeByBtmId.getData(); - if (referConfigVO.getWhere() == null) { - referConfigVO.setWhere(new HashMap<>()); - } /** * 鍔犱笂鏌ヨ鏈�鏂扮増娆� */ - Map<String, String> conditionMap = new HashMap<>(); - conditionMap.put("lastr", "1"); - conditionMap.put("lastv", "1"); - referConfigVO.getWhere().putAll(conditionMap); - if (VciBaseUtil.containsKeyUnCaseForMap(referConfigVO.getWhere(), VciQueryWrapperForDO.LC_STATUS_FIELD) && + baseQueryObject.getConditionMap().put("lastr", "1"); + baseQueryObject.getConditionMap().put("lastv", "1"); + if (VciBaseUtil.containsKeyUnCaseForMap(baseQueryObject.getConditionMap(), VciQueryWrapperForDO.LC_STATUS_FIELD) && BtmTypeLcStatusConstant.FRAME_WORK_LIFE_CYCLE_NAME.equalsIgnoreCase(btmTypeVO.getLifeCycleId())) { - referConfigVO.getWhere().put(VciQueryWrapperForDO.LC_STATUS_FIELD, FrameworkDataLCStatus.ENABLED.getValue()); + baseQueryObject.getConditionMap().put(VciQueryWrapperForDO.LC_STATUS_FIELD, FrameworkDataLCStatus.ENABLED.getValue()); } - if (VciBaseUtil.containsKeyUnCaseForMap(referConfigVO.getWhere(), VciQueryWrapperForDO.LC_STATUS_FIELD) && + if (VciBaseUtil.containsKeyUnCaseForMap(baseQueryObject.getConditionMap(), VciQueryWrapperForDO.LC_STATUS_FIELD) && BtmTypeLcStatusConstant.RELEASE_LIFE_CYCLE.equalsIgnoreCase(btmTypeVO.getLifeCycleId())) { - referConfigVO.getWhere().put(VciQueryWrapperForDO.LC_STATUS_FIELD, CodeDefaultLC.RELEASED.getValue()); + baseQueryObject.getConditionMap().put(VciQueryWrapperForDO.LC_STATUS_FIELD, CodeDefaultLC.RELEASED.getValue()); } - BaseQueryObject baseQueryObject = new BaseQueryObject(); - Map<String, String> where = referConfigVO.getWhere(); - where.put("domain", AppConstant.APPLICATION_NAME_CODE); - baseQueryObject.setConditionMap(where); - baseQueryObject.setPage(pageHelper.getPage()); - baseQueryObject.setSort(pageHelper.getSort()); - baseQueryObject.setLimit(pageHelper.getLimit()); - baseQueryObject.setOrder(pageHelper.getOrder()); - R<List<BtmTypeVO>> ref = btmTypeClient.getRef(baseQueryObject); - DataGrid<BtmTypeVO> btmTypeVODataGrid = new DataGrid<>(); - List<BtmTypeVO> data = ref.getData(); - btmTypeVODataGrid.setData(data); - btmTypeVODataGrid.setCode(ref.getCode()); - btmTypeVODataGrid.setLimit(pageHelper.getLimit()); - btmTypeVODataGrid.setMsg(ref.getMsg()); - btmTypeVODataGrid.setSort(pageHelper.getSort()); - btmTypeVODataGrid.setOrder(pageHelper.getOrder()); - btmTypeVODataGrid.setPage(pageHelper.getPage()); - return btmTypeVODataGrid; + baseQueryObject.getConditionMap().put("domain", AppConstant.APPLICATION_NAME_CODE); + R<Page<BtmTypeVO>> refPage = btmTypeClient.getRefPage(baseQueryObject); + if(refPage.getCode() != 200){ + throw new ServiceException("涓氬姟绫诲瀷feign鎺ュ彛璋冪敤閿欒"); + } + return refPage.getData(); } /** @@ -3477,6 +3468,17 @@ } + @Override + public boolean checkUnAttrUnEdit(String attrName) { + return (VciQueryWrapperForDO.OID_FIELD.equalsIgnoreCase(attrName) + ||"ts".equalsIgnoreCase(attrName) + || "lastmodifier".equalsIgnoreCase(attrName) + || "lastmodifytime".equalsIgnoreCase(attrName) + || "createtime".equalsIgnoreCase(attrName) + || "checkintime".equalsIgnoreCase(attrName) + ||"checkouttime".equalsIgnoreCase(attrName)); + } + private String getTableName(String refertype){ if ("codeclassify".equals(refertype)){ return "pl_code_classify"; -- Gitblit v1.9.3