| | |
| | | |
| | | import com.alibaba.cloud.commons.lang.StringUtils; |
| | | import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; |
| | | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import com.baomidou.mybatisplus.core.toolkit.Wrappers; |
| | | |
| | | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; |
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
| | | import com.github.yulichang.wrapper.MPJLambdaWrapper; |
| | | import com.vci.ubcs.code.service.ICodeTempphaseService; |
| | | import com.vci.ubcs.code.constant.MdmBtmTypeConstant; |
| | | import com.vci.ubcs.code.dto.CodeTemplatePhaseDTO; |
| | | import com.vci.ubcs.code.entity.*; |
| | | import com.vci.ubcs.code.mapper.CodePhaseAttrMapper; |
| | | import com.vci.ubcs.code.mapper.CodeTemplatePhaseMapper; |
| | | import com.vci.ubcs.code.mapper.CommonsMapper; |
| | | import com.vci.ubcs.code.service.ICodeClassifyTemplateAttrService; |
| | | import com.vci.ubcs.code.service.ICodePhaseattrService; |
| | | import com.vci.ubcs.code.service.ICodeTempphaseService; |
| | | import com.vci.ubcs.code.service.ICodePhaseAttrService; |
| | | import com.vci.ubcs.code.vo.pagemodel.CodeClassifyTemplateAttrVO; |
| | | import com.vci.ubcs.code.vo.pagemodel.CodeTemplatePhaseVO; |
| | | import com.vci.ubcs.code.wrapper.CodeTemplatePhaseWapper; |
| | | import com.vci.ubcs.starter.exception.VciBaseException; |
| | | import com.vci.ubcs.starter.revision.service.RevisionModelUtil; |
| | | import com.vci.ubcs.starter.util.MybatisParameterUtils; |
| | | import com.vci.ubcs.starter.web.constant.QueryOptionConstant; |
| | | import com.vci.ubcs.starter.web.pagemodel.DataGrid; |
| | | import com.vci.ubcs.starter.util.DefaultAttrAssimtUtil; |
| | | import com.vci.ubcs.starter.util.MdmBtmTypeConstant; |
| | | import com.vci.ubcs.starter.util.MybatisParameterUtil; |
| | | import com.vci.ubcs.starter.web.pagemodel.PageHelper; |
| | | import com.vci.ubcs.starter.web.util.BeanUtil; |
| | | import com.vci.ubcs.starter.web.util.BeanUtilForVCI; |
| | | import com.vci.ubcs.starter.web.util.VciBaseUtil; |
| | | import com.vci.ubcs.starter.web.util.WebUtil; |
| | | import org.springblade.core.mp.support.Condition; |
| | | import org.springblade.core.mp.support.Query; |
| | | import org.springblade.core.tool.api.R; |
| | |
| | | private CommonsMapper commonsMapper; |
| | | |
| | | @Autowired(required = false) |
| | | private ICodePhaseattrService codePhaseattrService; |
| | | private ICodePhaseAttrService codePhaseattrService; |
| | | |
| | | /** |
| | | * 对象的操作 |
| | |
| | | @Autowired |
| | | private ICodeClassifyTemplateAttrService tempAttrService; |
| | | |
| | | |
| | | /** |
| | | * 查询所有的模板阶段 |
| | | * @param codeTemplatePhaseVO 查询条件 |
| | | * @param query 分页和排序 |
| | | * @param conditionMap 查询条件 |
| | | * @param pageHelper 分页和排序 |
| | | * @return 执行结果 |
| | | * @throws VciBaseException 查询条件和分页出错的时候会抛出异常 |
| | | */ |
| | | @Override |
| | | public DataGrid<CodeTemplatePhaseVO> gridCodeTemplatePhase(CodeTemplatePhaseVO codeTemplatePhaseVO, Query query) throws VciBaseException { |
| | | query.setDescs("createTime"); |
| | | query.setSize(-1); |
| | | |
| | | IPage<CodeTemplatePhase> doList = codeTemplatePhaseMapper.selectPage(Condition.getPage(query), Condition.getQueryWrapper(codeTemplatePhaseVO)); |
| | | DataGrid<CodeTemplatePhaseVO> dataGrid=new DataGrid<CodeTemplatePhaseVO>(); |
| | | if (!CollectionUtils.isEmpty(doList.getRecords())) { |
| | | dataGrid.setData(codeTemplatePhaseDO2VOs(doList.getRecords())); |
| | | dataGrid.setTotal(VciBaseUtil.getInt(String.valueOf(codeTemplatePhaseMapper.selectCount(Condition.getQueryWrapper(codeTemplatePhaseVO))))); |
| | | public IPage<CodeTemplatePhaseVO> gridCodeTemplatePhase(Map<String, String> conditionMap, PageHelper pageHelper) throws VciBaseException { |
| | | Query query = new Query(); |
| | | if (pageHelper == null) { |
| | | query.setSize(-1); |
| | | }else { |
| | | query.setSize(pageHelper.getLimit()); |
| | | query.setCurrent(pageHelper.getPage()); |
| | | } |
| | | return dataGrid; |
| | | query.setDescs("CREATETIME"); |
| | | CodeTemplatePhase codeTemplatePhase = new CodeTemplatePhase(); |
| | | BeanMap beanMap = BeanMap.create(codeTemplatePhase); |
| | | beanMap.putAll(conditionMap); |
| | | IPage<CodeTemplatePhase> doList = codeTemplatePhaseMapper.selectPage(Condition.getPage(query), Condition.getQueryWrapper(codeTemplatePhase)); |
| | | IPage<CodeTemplatePhaseVO> voList = new Page<>(); |
| | | if (!CollectionUtils.isEmpty(doList.getRecords())) { |
| | | CodeTemplatePhaseWapper.build().pageVO(doList); |
| | | } |
| | | return voList; |
| | | } |
| | | |
| | | /** |
| | | * 批量数据对象转换为显示对象 |
| | | * @param codeTemplatePhaseDOs 数据对象列表 |
| | | * @param codeTemplatePhaseEntityDOS 数据对象列表 |
| | | * @return 显示对象 |
| | | * @throws VciBaseException 参数为空或者不存在的时候会抛出异常 |
| | | */ |
| | | @Override |
| | | public List<CodeTemplatePhaseVO> codeTemplatePhaseDO2VOs(Collection<CodeTemplatePhase> codeTemplatePhaseDOs) throws VciBaseException{ |
| | | public List<CodeTemplatePhaseVO> codeTemplatePhaseDO2VOs(Collection<CodeTemplatePhase> codeTemplatePhaseEntityDOS) throws VciBaseException{ |
| | | List<CodeTemplatePhaseVO> voList = new ArrayList<CodeTemplatePhaseVO>(); |
| | | if(!CollectionUtils.isEmpty(codeTemplatePhaseDOs)){ |
| | | for(CodeTemplatePhase s: codeTemplatePhaseDOs){ |
| | | if(!CollectionUtils.isEmpty(codeTemplatePhaseEntityDOS)){ |
| | | for(CodeTemplatePhase s: codeTemplatePhaseEntityDOS){ |
| | | CodeTemplatePhaseVO vo = codeTemplatePhaseDO2VO(s); |
| | | if(vo != null){ |
| | | voList.add(vo); |
| | |
| | | |
| | | /** |
| | | * 数据对象转换为显示对象 |
| | | * @param codeTemplatePhaseDO 数据对象 |
| | | * @param codeTemplatePhaseEntityDO 数据对象 |
| | | * @return 显示对象 |
| | | * @throws VciBaseException 拷贝属性出错的时候会抛出异常 |
| | | */ |
| | | @Override |
| | | public CodeTemplatePhaseVO codeTemplatePhaseDO2VO(CodeTemplatePhase codeTemplatePhaseDO) throws VciBaseException{ |
| | | public CodeTemplatePhaseVO codeTemplatePhaseDO2VO(CodeTemplatePhase codeTemplatePhaseEntityDO) throws VciBaseException{ |
| | | CodeTemplatePhaseVO vo = new CodeTemplatePhaseVO(); |
| | | if(codeTemplatePhaseDO != null){ |
| | | BeanUtilForVCI.copyPropertiesIgnoreCase(codeTemplatePhaseDO,vo); |
| | | if(codeTemplatePhaseEntityDO != null){ |
| | | BeanUtilForVCI.copyPropertiesIgnoreCase(codeTemplatePhaseEntityDO,vo); |
| | | //如果有lcstatus的类的话 |
| | | } |
| | | return vo; |
| | |
| | | List<CodeTemplatePhase> codeTempphaseEntities = baseMapper.selectByMap(condition); |
| | | if(!CollectionUtils.isEmpty(codeTempphaseEntities)) { |
| | | updateCount += baseMapper.deleteBatchIds(codeTempphaseEntities.stream().map(CodeTemplatePhase::getOid).collect(Collectors.toList())); |
| | | // batchCBO.copyFromOther(codeTemplatePhaseMapper.batchDeleteByOids(templatePhaseDOS.stream().map(CodeTemplatePhaseDO::getOid).collect(Collectors.toList()))); |
| | | // conditionMap.put("codePhaseOid", QueryOptionConstant.IN + "(select oid from " + getPhaseTable() + " where codeClassifyTemplateOid='" + classifyTemplateOid + "')"); |
| | | //batchCBO.copyFromOther(codeTemplatePhaseMapper.batchDeleteByOids(templatePhaseDOS.stream().map(CodeTemplatePhaseDO::getOid).collect(Collectors.toList()))); |
| | | //conditionMap.put("codePhaseOid", QueryOptionConstant.IN + "(select oid from " + getPhaseTable() + " where codeClassifyTemplateOid='" + classifyTemplateOid + "')"); |
| | | List<CodePhaseAttr> phaseAttrDOS = codePhaseAttrMapper.selectByPhasea(templateOid); |
| | | if(!CollectionUtils.isEmpty(phaseAttrDOS)){ |
| | | updateCount += codePhaseAttrMapper.deleteBatchIds(phaseAttrDOS.stream().map(CodePhaseAttr::getOid).collect(Collectors.toList())); |
| | |
| | | */ |
| | | @Override |
| | | @Transactional(rollbackFor = Exception.class) |
| | | public List<CodeClstempattrEntity> codeTemplateAttrModifyTrigger(List<CodeClstempattrEntity> attrDOList){ |
| | | public List<CodeClassifyTemplateAttr> codeTemplateAttrModifyTrigger(List<CodeClassifyTemplateAttr> attrDOList){ |
| | | //属性修改的时候,需要同步修改对应属性的名称 |
| | | // BatchCBO batchCBO = new BatchCBO(); |
| | | //BatchCBO batchCBO = new BatchCBO(); |
| | | List<CodePhaseAttr> phaseAttrDOS =codePhaseAttrMapper.listLinkAttrDOByTemplateAttrDOS(VciBaseUtil.toInSql(attrDOList.stream() |
| | | .map(CodeClstempattrEntity::getId).collect(Collectors.toList()).toArray(new String[0])),attrDOList.get(0).getClassifytemplateoid()); |
| | | .map(CodeClassifyTemplateAttr::getId).collect(Collectors.toList()).toArray(new String[0])),attrDOList.get(0).getClassifyTemplateOid()); |
| | | boolean resSavePhaseAttr = false; |
| | | if(!CollectionUtils.isEmpty(phaseAttrDOS)){ |
| | | //说明有属性,我们去替换一下 |
| | | Map<String, CodeClstempattrEntity> attrDOMap = attrDOList.stream().collect(Collectors.toMap(s -> s.getId(), t -> t)); |
| | | Map<String, CodeClassifyTemplateAttr> attrDOMap = attrDOList.stream().collect(Collectors.toMap(s -> s.getId(), t -> t)); |
| | | phaseAttrDOS.stream().forEach(phaseAttrDO->{ |
| | | if(attrDOMap.containsKey(phaseAttrDO.getId())){ |
| | | CodeClstempattrEntity attrDO = attrDOMap.get(phaseAttrDO.getId()); |
| | | CodeClassifyTemplateAttr attrDO = attrDOMap.get(phaseAttrDO.getId()); |
| | | phaseAttrDO.setId(attrDO.getId()); |
| | | phaseAttrDO.setName(attrDO.getName()); |
| | | phaseAttrDO.setAttributegroup(attrDO.getAttributegroup()); |
| | | phaseAttrDO.setAttributeGroup(attrDO.getAttributeGroup()); |
| | | } |
| | | }); |
| | | // codePhaseattrMapper. |
| | | codePhaseattrService.saveBatch(phaseAttrDOS); |
| | | // BatchCBO updateCBO = |
| | | // codePhaseAttrMapper.batchUpdate(phaseAttrDOS); |
| | | // batchCBO.copyFromOther(updateCBO); |
| | | resSavePhaseAttr = codePhaseattrService.saveBatch(phaseAttrDOS); |
| | | //BatchCBO updateCBO = |
| | | //codePhaseAttrMapper.batchUpdate(phaseAttrDOS); |
| | | //batchCBO.copyFromOther(updateCBO); |
| | | } |
| | | return attrDOList; |
| | | return resSavePhaseAttr ? attrDOList:null; |
| | | } |
| | | |
| | | /** |
| | |
| | | VciBaseUtil.alertNotNull(codeTemplatePhaseDTO,"需要添加的数据对象",codeTemplatePhaseDTO.getAttributes(),"包含的属性"); |
| | | //将DTO转换为DO |
| | | CodeTemplatePhase codeTemplatePhaseDO = new CodeTemplatePhase(); |
| | | codeTemplatePhaseDO.setOid(VciBaseUtil.getPk()); |
| | | BeanUtilForVCI.copyPropertiesIgnoreCase(codeTemplatePhaseDTO,codeTemplatePhaseDO); |
| | | BeanUtilForVCI.copyPropertiesIgnoreCase(codeTemplatePhaseDTO, codeTemplatePhaseDO); |
| | | DefaultAttrAssimtUtil.addDefaultAttrAssimt(codeTemplatePhaseDO, MdmBtmTypeConstant.CODE_TEMPLATE_PHASE); |
| | | //WebUtil.setPersistence(false); |
| | | boolean resBoolean = codeTemplatePhaseMapper.insert(codeTemplatePhaseDO) > 0; |
| | | boolean resInsertTempPhase = codeTemplatePhaseMapper.insert(codeTemplatePhaseDO) > 0; |
| | | List<CodePhaseAttr> attrDOList = new ArrayList<>(); |
| | | CodeTemplatePhase finalCodeTemplatePhaseDO = codeTemplatePhaseDO; |
| | | codeTemplatePhaseDTO.getAttributes().stream().forEach(attrDTO->{ |
| | | CodePhaseAttr attrDO = new CodePhaseAttr(); |
| | | BeanUtilForVCI.copyPropertiesIgnoreCase(attrDTO,attrDO); |
| | | attrDO.setOid(VciBaseUtil.getPk()); |
| | | attrDO.setCodePhaseOid(codeTemplatePhaseDO.getOid()); |
| | | attrDO.setCodePhaseOid(finalCodeTemplatePhaseDO.getOid()); |
| | | attrDOList.add(attrDO); |
| | | }); |
| | | codePhaseattrService.saveBatch(attrDOList); |
| | | boolean resPhaseAttr = codePhaseattrService.saveOrUpdateBatch(attrDOList); |
| | | //WebUtil.setPersistence(true); |
| | | return codeTemplatePhaseDO2VO(codeTemplatePhaseDO); |
| | | return resInsertTempPhase && resPhaseAttr ? codeTemplatePhaseDO2VO(codeTemplatePhaseDO):null; |
| | | } |
| | | |
| | | /** |
| | |
| | | public CodeTemplatePhaseVO editSave(CodeTemplatePhaseDTO codeTemplatePhaseDTO) throws VciBaseException{ |
| | | VciBaseUtil.alertNotNull(codeTemplatePhaseDTO,"数据对象",codeTemplatePhaseDTO.getOid(),"模板阶段主键",codeTemplatePhaseDTO.getAttributes(),"包含的属性"); |
| | | //将DTO转换为DO |
| | | CodeTemplatePhase codeTemplatePhaseDO = selectByOid(codeTemplatePhaseDTO.getOid()); |
| | | revisionModelUtil.copyFromDTOIgnore(codeTemplatePhaseDTO,codeTemplatePhaseDO); |
| | | CodeTemplatePhase codeTemplatePhaseEntityDO = selectByOid(codeTemplatePhaseDTO.getOid()); |
| | | revisionModelUtil.copyFromDTOIgnore(codeTemplatePhaseDTO, codeTemplatePhaseEntityDO); |
| | | DefaultAttrAssimtUtil.updateDefaultAttrAssimt(codeTemplatePhaseEntityDO); |
| | | //WebUtil.setPersistence(false); |
| | | codeTemplatePhaseMapper.updateById(codeTemplatePhaseDO); |
| | | codeTemplatePhaseMapper.updateById(codeTemplatePhaseEntityDO); |
| | | //把以前的删除 |
| | | List<CodePhaseAttr> phaseAttrDOS = listPhaseAttrDOByPhaseOid(codeTemplatePhaseDO.getOid()); |
| | | List<CodePhaseAttr> phaseAttrDOS = listPhaseAttrDOByPhaseOid(codeTemplatePhaseEntityDO.getOid()); |
| | | if(!CollectionUtils.isEmpty(phaseAttrDOS)){ |
| | | codePhaseAttrMapper.deleteBatchIds(phaseAttrDOS.stream().map(CodePhaseAttr::getOid).collect(Collectors.toList())); |
| | | } |
| | | List<CodePhaseAttr> attrDOList = new ArrayList<>(); |
| | | |
| | | codeTemplatePhaseDTO.getAttributes().stream().forEach(attrDTO->{ |
| | | CodePhaseAttr attrDO = new CodePhaseAttr(); |
| | | BeanUtilForVCI.copyPropertiesIgnoreCase(attrDTO,attrDO); |
| | | attrDO.setOid(VciBaseUtil.getPk()); |
| | | attrDO.setCodePhaseOid(codeTemplatePhaseDO.getOid()); |
| | | attrDO.setCodePhaseOid(codeTemplatePhaseEntityDO.getOid()); |
| | | attrDOList.add(attrDO); |
| | | }); |
| | | codePhaseattrService.saveBatch(attrDOList); |
| | | //WebUtil.setPersistence(true); |
| | | return codeTemplatePhaseDO2VO(codeTemplatePhaseDO); |
| | | return codeTemplatePhaseDO2VO(codeTemplatePhaseEntityDO); |
| | | } |
| | | |
| | | /** |
| | | * 模板属性删除的时候触发 |
| | | * @param attrDOList 属性的数据对象 |
| | | * @return 受影响的数据 |
| | | */ |
| | | @Override |
| | | public R codeTemplateAttrDeleteTrigger(List<CodeClassifyTemplateAttr> attrDOList){ |
| | | List<CodePhaseAttr> phaseAttrDOS =listLinkAttrDOByTemplateAttrDOS(attrDOList); |
| | | boolean resDeletePhaseAttr = false; |
| | | if(!CollectionUtils.isEmpty(phaseAttrDOS)){ |
| | | //属性被删除的时候,阶段里面也一样要被删除 |
| | | resDeletePhaseAttr = codePhaseAttrMapper.deleteBatchIds(phaseAttrDOS.stream().map(CodePhaseAttr::getOid).collect(Collectors.toList())) > 0; |
| | | } |
| | | return R.status(resDeletePhaseAttr); |
| | | } |
| | | |
| | | /** |
| | |
| | | @Transactional(rollbackFor = Exception.class) |
| | | public R deleteCodeTemplatePhase(CodeTemplatePhaseDTO codeTemplatePhaseDTO) throws VciBaseException{ |
| | | VciBaseUtil.alertNotNull(codeTemplatePhaseDTO,"模板阶段数据对象",codeTemplatePhaseDTO.getOid(),"模板阶段的主键"); |
| | | CodeTemplatePhase codeTemplatePhaseDO = selectByOid(codeTemplatePhaseDTO.getOid()); |
| | | R baseResult = checkIsCanDeleteForDO(codeTemplatePhaseDTO,codeTemplatePhaseDO); |
| | | if(!baseResult.isSuccess()) { |
| | | CodeTemplatePhase codeTemplatePhaseEntityDO = selectByOid(codeTemplatePhaseDTO.getOid()); |
| | | R baseResult = checkIsCanDeleteForDO(codeTemplatePhaseDTO, codeTemplatePhaseEntityDO); |
| | | if(baseResult.isSuccess()) { |
| | | }else{ |
| | | return baseResult; |
| | | } |
| | | //执行删除操作 |
| | | //WebUtil.setPersistence(false); |
| | | boolean batchCBO = codeTemplatePhaseMapper.deleteById(codeTemplatePhaseDO.getOid())>0; |
| | | boolean batchCBO = codeTemplatePhaseMapper.deleteById(codeTemplatePhaseEntityDO.getOid())>0; |
| | | //需要删除属性 |
| | | List<CodePhaseAttr> phaseAttrDOS = listPhaseAttrDOByPhaseOid(codeTemplatePhaseDO.getOid()); |
| | | List<CodePhaseAttr> phaseAttrDOS = listPhaseAttrDOByPhaseOid(codeTemplatePhaseEntityDO.getOid()); |
| | | boolean deleteCBO = false; |
| | | if(!CollectionUtils.isEmpty(phaseAttrDOS)) { |
| | | deleteCBO = codePhaseAttrMapper.deleteBatchIds(phaseAttrDOS.stream().map(CodePhaseAttr::getOid).collect(Collectors.toList()))>0; |
| | |
| | | * @throws VciBaseException 参数为空,数据不存在时会抛出异常 |
| | | */ |
| | | @Override |
| | | public CodeTemplatePhaseVO getObjectByOid(String oid) throws VciBaseException{ |
| | | public CodeTemplatePhaseVO getObjectByOid(String oid) throws VciBaseException{ |
| | | return codeTemplatePhaseDO2VO(selectByOid(oid)); |
| | | } |
| | | |
| | |
| | | @Override |
| | | public Collection<CodeTemplatePhaseVO> listCodeTemplatePhaseByOids(Collection<String> oidCollections) throws VciBaseException{ |
| | | VciBaseUtil.alertNotNull(oidCollections,"数据对象主键集合"); |
| | | List<CodeTemplatePhase> codeTemplatePhaseDOList = listCodeTemplatePhaseDOByOidCollections(oidCollections); |
| | | return codeTemplatePhaseDO2VOs(codeTemplatePhaseDOList); |
| | | List<CodeTemplatePhase> codeTemplatePhaseEntityDOList = listCodeTemplatePhaseDOByOidCollections(oidCollections); |
| | | return CodeTemplatePhaseWapper.build().listVO(codeTemplatePhaseEntityDOList); |
| | | } |
| | | |
| | | /** |
| | |
| | | * @throws VciBaseException 查询条件和分页出错的时候会抛出异常 |
| | | */ |
| | | @Override |
| | | public DataGrid<CodeTemplatePhaseVO> refDataGridCodeTemplatePhase(Map<String, String> conditionMap, PageHelper pageHelper) throws VciBaseException{ |
| | | public IPage<CodeTemplatePhaseVO> refDataGridCodeTemplatePhase(Map<String, String> conditionMap, PageHelper pageHelper) throws VciBaseException{ |
| | | if(conditionMap == null){ |
| | | conditionMap = new HashMap<String, String>(); |
| | | conditionMap = new HashMap<>(); |
| | | } |
| | | CodeTemplatePhaseVO codeTemplatePhaseVO = new CodeTemplatePhaseVO(); |
| | | BeanMap beanMap = BeanMap.create(codeTemplatePhaseVO); |
| | | beanMap.putAll(conditionMap); |
| | | Query query = new Query(); |
| | | query.setSize(pageHelper.getLimit()); |
| | | query.setCurrent(pageHelper.getPage()); |
| | | |
| | | return gridCodeTemplatePhase(codeTemplatePhaseVO,query); |
| | | return gridCodeTemplatePhase(conditionMap,pageHelper); |
| | | } |
| | | |
| | | /** |
| | |
| | | * @return 属性的信息 |
| | | */ |
| | | @Override |
| | | public DataGrid<CodeClassifyTemplateAttrVO> gridUnUsedAttribute(Map<String, String> conditionMap, PageHelper pageHelper) throws VciBaseException { |
| | | public IPage<CodeClassifyTemplateAttrVO> gridUnUsedAttribute(Map<String, String> conditionMap, PageHelper pageHelper) throws VciBaseException { |
| | | if(conditionMap == null){ |
| | | conditionMap = new HashMap<String, String>(); |
| | | } |
| | | if(!conditionMap.containsKey("classifyTemplateOid")){ |
| | | return new DataGrid<>("没有模板的主键"); |
| | | throw new VciBaseException("没有模板的主键"); |
| | | } |
| | | //需要判断阶段的主键是否存在 |
| | | String codePhaseOid = conditionMap.getOrDefault("codePhaseOid", null); |
| | | LambdaQueryWrapper<CodeClassifyTemplateAttr> queryWrapper = null; |
| | | MPJLambdaWrapper<CodeClassifyTemplateAttr> queryWrapper = new MPJLambdaWrapper<>(); |
| | | queryWrapper.selectAll(CodeClassifyTemplateAttr.class) |
| | | .selectAs(CodeClassifyTemplate::getName,CodeClassifyTemplateAttr::getClassifyTemplateOidName) |
| | | .leftJoin(CodeClassifyTemplate.class, CodeClassifyTemplate::getOid, CodeClassifyTemplateAttr::getClassifyTemplateOid) |
| | | .eq(CodeClassifyTemplateAttr::getClassifyTemplateOid,conditionMap.getOrDefault("classifyTemplateOid",null)); |
| | | if(StringUtils.isNotBlank(codePhaseOid)){ |
| | | //排除阶段上使用的 |
| | | conditionMap.remove("codePhaseOid"); |
| | | List<String> ids = commonsMapper.selectById("(select id from " + getPhaseAttrTable() + " where codePhaseOid ='" + codePhaseOid + "')"); |
| | | if(ids.size()<=1000){ |
| | | queryWrapper = Wrappers.<CodeClassifyTemplateAttr>query().lambda().notIn(CodeClassifyTemplateAttr::getId, ids); |
| | | if(ids.size()<1000){ |
| | | queryWrapper = queryWrapper.notIn(CodeClassifyTemplateAttr::getId, ids); |
| | | }else { |
| | | queryWrapper = MybatisParameterUtils.cutNotInParameter(queryWrapper,CodeClassifyTemplateAttr::getId,ids); |
| | | queryWrapper = MybatisParameterUtil.cutNotInParameter(queryWrapper,CodeClassifyTemplateAttr::getId,ids); |
| | | } |
| | | //conditionMap.put("id", QueryOptionConstant.NOTIN + ids); |
| | | } |
| | |
| | | * @return 属性的信息 |
| | | */ |
| | | @Override |
| | | public DataGrid<CodeClassifyTemplateAttrVO> gridUsedAttribute(Map<String, String> conditionMap, PageHelper pageHelper) throws VciBaseException { |
| | | public IPage<CodeClassifyTemplateAttrVO> gridUsedAttribute(Map<String, String> conditionMap, PageHelper pageHelper) throws VciBaseException { |
| | | if(conditionMap == null){ |
| | | conditionMap = new HashMap<String, String>(); |
| | | } |
| | | String codePhaseOid = conditionMap.getOrDefault("codePhaseOid", null); |
| | | if(StringUtils.isBlank(codePhaseOid)){ |
| | | return new DataGrid<>(); |
| | | return new Page<>(); |
| | | } |
| | | conditionMap.remove("codePhaseOid"); |
| | | CodeTemplatePhase phaseDO = selectByOid(codePhaseOid); |
| | | List<String> ids = commonsMapper.selectById("(select id from " + getPhaseAttrTable() + " where codePhaseOid ='" +codePhaseOid + "')"); |
| | | LambdaQueryWrapper<CodeClassifyTemplateAttr> queryWrapper = null; |
| | | // Wrappers.<CodeClassifyTemplateAttrVO>query() |
| | | // .in("id", ids) |
| | | if(ids.size()<=1000){ |
| | | queryWrapper = Wrappers.<CodeClassifyTemplateAttr>query().lambda().in(CodeClassifyTemplateAttr::getId, ids); |
| | | //这儿是个连表查询语句 |
| | | MPJLambdaWrapper<CodeClassifyTemplateAttr> mpjLambdaWrapper = new MPJLambdaWrapper<>(); |
| | | mpjLambdaWrapper.selectAll(CodeClassifyTemplateAttr.class) |
| | | .selectAs(CodeClassifyTemplate::getName,CodeClassifyTemplateAttr::getClassifyTemplateOidName) |
| | | .leftJoin(CodeClassifyTemplate.class, CodeClassifyTemplate::getOid, CodeClassifyTemplateAttr::getClassifyTemplateOid) |
| | | .eq(CodeClassifyTemplateAttr::getClassifyTemplateOid,phaseDO.getCodeClassifyTemplateOid()); |
| | | if(ids.size()<1000){ |
| | | mpjLambdaWrapper = mpjLambdaWrapper.in(CodeClassifyTemplateAttr::getId, ids); |
| | | }else { |
| | | queryWrapper = MybatisParameterUtils.cutInParameter(queryWrapper,CodeClassifyTemplateAttr::getId,ids); |
| | | mpjLambdaWrapper = MybatisParameterUtil.cutInParameter(mpjLambdaWrapper,CodeClassifyTemplateAttr::getId,ids); |
| | | } |
| | | queryWrapper.eq(CodeClassifyTemplateAttr::getClassifyTemplateOid,phaseDO.getCodeClassifyTemplateOid()); |
| | | return tempAttrService.gridCodeClassifyTemplateAttr(queryWrapper,pageHelper); |
| | | return tempAttrService.gridCodeClassifyTemplateAttr(mpjLambdaWrapper,pageHelper); |
| | | } |
| | | |
| | | /** |
| | |
| | | * @return 表名 |
| | | */ |
| | | private String getPhaseAttrTable(){ |
| | | return VciBaseUtil.getTableName(MdmBtmTypeConstant.CODE_PHASE_ATTR_TABLENAME); |
| | | /**以前VciQueryWrapperForDO.USER_TABLE_COMPATIBILITY在启动时初始化值为true所以拼接出来的表名是正确的, |
| | | 现在因为搬过来没有被赋值为true所以表名拿到的是错误的这儿暂时写死 |
| | | **/ |
| | | //return VciBaseUtil.getTableName(MdmBtmTypeConstant.CODE_PHASE_ATTR_TABLENAME); |
| | | return "pl_"+MdmBtmTypeConstant.CODE_PHASE_ATTR_TABLENAME; |
| | | } |
| | | |
| | | /** |
| | | * 阶段的表名 |
| | | * @return 表名 |
| | | */ |
| | | private String getPhaseTable(){ |
| | | //return VciBaseUtil.getTableName(MdmBtmTypeConstant.CODE_TEMPLATE_PHASE); |
| | | return "pl_"+MdmBtmTypeConstant.CODE_TEMPLATE_PHASE; |
| | | } |
| | | |
| | | /** |
| | |
| | | * @return 数据对象列表 |
| | | */ |
| | | private List<CodeTemplatePhase> listCodeTemplatePhaseDOByOidCollections(Collection<String> oidCollections){ |
| | | List<CodeTemplatePhase> codeTemplatePhaseDOList = new ArrayList<CodeTemplatePhase>(); |
| | | List<CodeTemplatePhase> codeTemplatePhaseEntityDOList = new ArrayList<>(); |
| | | if(!CollectionUtils.isEmpty(oidCollections)){ |
| | | Collection<Collection<String>> oidCollectionsList = VciBaseUtil.switchCollectionForOracleIn(oidCollections); |
| | | for(Collection<String> oids: oidCollectionsList){ |
| | | List<CodeTemplatePhase> tempDOList = codeTemplatePhaseMapper.selectBatchIds(oids); |
| | | if(!CollectionUtils.isEmpty(tempDOList)){ |
| | | codeTemplatePhaseDOList.addAll(tempDOList); |
| | | codeTemplatePhaseEntityDOList.addAll(tempDOList); |
| | | } |
| | | } |
| | | } |
| | | return codeTemplatePhaseDOList; |
| | | return codeTemplatePhaseEntityDOList; |
| | | } |
| | | |
| | | /** |
| | | * 校验是否可以删除,如果存在下级,并且下级有数据引用则不能删除 |
| | | * @param codeTemplatePhaseDTO 数据传输对象 |
| | | * @param codeTemplatePhaseDO 数据库中的数据对象 |
| | | * @param codeTemplatePhaseEntityDO 数据库中的数据对象 |
| | | * @return success为true为可以删除,false表示有数据引用,obj为true表示有下级 |
| | | */ |
| | | private R checkIsCanDeleteForDO(CodeTemplatePhaseDTO codeTemplatePhaseDTO, CodeTemplatePhase codeTemplatePhaseDO) { |
| | | private R checkIsCanDeleteForDO(CodeTemplatePhaseDTO codeTemplatePhaseDTO, CodeTemplatePhase codeTemplatePhaseEntityDO) { |
| | | CodeTemplatePhase tsDO = new CodeTemplatePhase(); |
| | | BeanUtil.convert(codeTemplatePhaseDTO,tsDO); |
| | | if (checkTs(tsDO)) { |
| | | if (!checkTs(tsDO,codeTemplatePhaseEntityDO)) { |
| | | return R.fail(TS_NOT_PROCESS); |
| | | } |
| | | if(!checkIsLinked(codeTemplatePhaseDO.getOid())) { |
| | | if(!checkIsLinked(codeTemplatePhaseEntityDO.getOid())) { |
| | | return R.success("succcess"); |
| | | }else{ |
| | | return R.fail(DATA_LINKED_NOT_DELETE); |
| | |
| | | |
| | | /** |
| | | * 检查ts |
| | | * @param tempDO |
| | | * @param codeTempphaseDO |
| | | * @return |
| | | */ |
| | | private boolean checkTs(CodeTemplatePhase tempDO){ |
| | | LambdaQueryWrapper<CodeTemplatePhase> wrapper = Wrappers.<CodeTemplatePhase>query() |
| | | .lambda().eq(CodeTemplatePhase::getOid,tempDO.getOid()).select(CodeTemplatePhase::getTs); |
| | | long dbTs = codePhaseAttrMapper.selectById(wrapper).getTs().getTime(); |
| | | long currentTs = tempDO.getTs().getTime(); |
| | | if(dbTs == currentTs){ |
| | | private boolean checkTs(CodeTemplatePhase tempDO, CodeTemplatePhase codeTempphaseDO){ |
| | | Date dbTs = codeTempphaseDO.getTs(); |
| | | Date currentTs = tempDO.getTs(); |
| | | if(currentTs == null ? dbTs == null:currentTs.compareTo(dbTs)==0){ |
| | | return true; |
| | | } |
| | | return false; |
| | |
| | | } |
| | | |
| | | /** |
| | | * 使用模板的属性获取阶段中包含的属性内容 |
| | | * @param attrDOList 属性的数据对象 |
| | | * @return 阶段里的属性数据对象 |
| | | */ |
| | | private List<CodePhaseAttr> listLinkAttrDOByTemplateAttrDOS(List<CodeClassifyTemplateAttr> attrDOList){ |
| | | if(!CollectionUtils.isEmpty(attrDOList)) { |
| | | //查询这个模板里包含的所有阶段的这些属性 |
| | | //因为oracle里表的字段不能超过1000个,所以我们这里默认属性个数是小于1000的; |
| | | List<String> oids = commonsMapper.selectById("select oid from " + getPhaseTable() + " where codeClassifyTemplateOid='" + attrDOList.get(0).getClassifyTemplateOid() + "'"); |
| | | LambdaQueryWrapper<CodePhaseAttr> queryWrapper = new LambdaQueryWrapper<>(); |
| | | if(oids.size()<1000){ |
| | | queryWrapper.in(CodePhaseAttr::getCodePhaseOid,oids); |
| | | }else { |
| | | MybatisParameterUtil.cutInParameter(queryWrapper,CodePhaseAttr::getCodePhaseOid,oids); |
| | | } |
| | | if(attrDOList.size()<1000){ |
| | | queryWrapper.in(CodePhaseAttr::getId,VciBaseUtil.toInSql(attrDOList.stream().map(CodeClassifyTemplateAttr::getId).collect(Collectors.toList()).toArray(new String[0]))); |
| | | }else { |
| | | MybatisParameterUtil.cutInParameter(queryWrapper,CodePhaseAttr::getId,attrDOList.stream().map(CodeClassifyTemplateAttr::getId).collect(Collectors.toList())); |
| | | } |
| | | //conditionMap.put("codePhaseOid", QueryOptionConstant.IN + "(select oid from " + getPhaseTable() + " where codeClassifyTemplateOid='" + attrDOList.get(0).getClassifyTemplateOid() + "')"); |
| | | //conditionMap.put("id", QueryOptionConstant.IN + "(" + VciBaseUtil.toInSql(attrDOList.stream().map(CodeClassifyTemplateAttr::getId).collect(Collectors.toList()).toArray(new String[0])) + ")"); |
| | | return codePhaseAttrMapper.selectList(queryWrapper); |
| | | }else{ |
| | | return new ArrayList<>(); |
| | | } |
| | | } |
| | | |
| | | /** |
| | | * 主键查询数据对象 |
| | | * @param oid 主键 |
| | | * @return 数据对象 |
| | |
| | | */ |
| | | private CodeTemplatePhase selectByOid(String oid) throws VciBaseException{ |
| | | VciBaseUtil.alertNotNull(oid,"主键"); |
| | | CodeTemplatePhase codeTemplatePhaseDO = codeTemplatePhaseMapper.selectById(oid.trim()); |
| | | if(codeTemplatePhaseDO == null || StringUtils.isBlank(codeTemplatePhaseDO.getOid())){ |
| | | CodeTemplatePhase codeTemplatePhaseEntityDO = codeTemplatePhaseMapper.selectById(oid.trim()); |
| | | if(codeTemplatePhaseEntityDO == null || StringUtils.isBlank(codeTemplatePhaseEntityDO.getOid())){ |
| | | throw new VciBaseException(DATA_OID_NOT_EXIST); |
| | | } |
| | | return codeTemplatePhaseDO; |
| | | return codeTemplatePhaseEntityDO; |
| | | } |
| | | |
| | | } |