package com.doumee.service.business.impl; import com.doumee.biz.system.SystemDictDataBiz; import com.doumee.core.constants.ResponseStatus; import com.doumee.core.exception.BusinessException; import com.doumee.core.model.LoginUserInfo; import com.doumee.core.model.PageData; import com.doumee.core.model.PageWrap; import com.doumee.core.utils.Constants; import com.doumee.core.utils.Utils; import com.doumee.dao.business.InsuranceMapper; import com.doumee.dao.business.MultifileMapper; import com.doumee.dao.business.WorktypeMapper; import com.doumee.dao.business.join.DuWorkTypeJoinMapper; import com.doumee.dao.business.join.WorktypeJoinMapper; import com.doumee.dao.business.model.Insurance; import com.doumee.dao.business.model.Multifile; import com.doumee.dao.business.model.Solutions; import com.doumee.dao.business.model.Worktype; import com.doumee.dao.system.model.SystemUser; import com.doumee.service.business.InsuranceService; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.sun.corba.se.spi.orbutil.threadpool.Work; import io.swagger.annotations.ApiModelProperty; import org.apache.commons.lang3.StringUtils; import org.apache.shiro.SecurityUtils; import org.checkerframework.checker.units.qual.A; import org.springframework.beans.BeanUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import org.springframework.util.CollectionUtils; import java.util.*; import java.util.stream.Collectors; /** * 保险公司信息表Service实现 * @author 江蹄蹄 * @date 2024/01/16 10:03 */ @Service public class InsuranceServiceImpl implements InsuranceService { @Autowired private InsuranceMapper insuranceMapper; @Autowired private WorktypeMapper worktypeMapper; @Autowired private WorktypeJoinMapper worktypeJoinMapper; @Autowired private SystemDictDataBiz systemDictDataBiz; @Autowired private MultifileMapper multifileMapper; @Override @Transactional public Integer create(Insurance insurance) { LoginUserInfo user= (LoginUserInfo)SecurityUtils.getSubject().getPrincipal(); initCreateParam(insurance);//工种数据有效性检验,去除空白行数据 if(insuranceMapper.selectCount(new QueryWrapper().lambda().eq(Insurance::getName,insurance.getName()) .eq(Insurance::getIsdeleted,Constants.ZERO) .eq(Insurance::getDataType,Constants.ZERO) )>Constants.ZERO){ throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"保险公司名称已存在"); } insurance.setIsdeleted(Constants.ZERO); insurance.setCreator(user.getId()); insurance.setCreateDate(new Date()); insurance.setVersion(UUID.randomUUID().toString());//版本号 insurance.setDataType(Constants.ZERO); insurance.setStatus(Constants.ZERO); insuranceMapper.insert(insurance);//基础版本 //如果有工种,则产生一个新的有效历史版本 ~ Insurance newModel = new Insurance(); BeanUtils.copyProperties(insurance,newModel); newModel.setId(null); newModel.setBaseId(insurance.getId()); newModel.setDataType(Constants.TWO); insuranceMapper.insert(newModel); dealWorkTypeData(insurance,newModel,insurance.getWorktypeList(),true); return insurance.getId(); } private void dealWorkTypeData(Insurance insurance, Insurance newModel, List worktypeList,boolean isNew) { int num=0; List workTypeName = worktypeList.stream().map(m->m.getName()).collect(Collectors.toList()); Set set = new HashSet<>(workTypeName); if(workTypeName.size() != set.size()){ throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(),"对不起,工种录入数据存在相同数据!"); } List saveList = new ArrayList<>(); for(Worktype w : worktypeList) { if(!isNew){ //查询保险公司下是否已存在该工种 if(worktypeMapper.selectCount(new QueryWrapper().lambda().eq(Worktype::getInsuranceId,insurance.getId()) .eq(Worktype::getIsdeleted,Constants.ZERO) .eq(Worktype::getDataType,Constants.ZERO) .eq(Worktype::getName,w.getName()) )>Constants.ZERO){ throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"当前保险公司下存在【"+w.getName()+"】该工种信息"); } } //基础版本 w.setInsuranceId(insurance.getId()); w.setIsdeleted(Constants.ZERO); w.setCreator(newModel.getCreator()); w.setCreateDate(new Date()); w.setDataType(insurance.getDataType()); w.setStatus(Constants.ZERO); w.setVersion(insurance.getVersion()); w.setSortnum(num++); saveList.add(w); // worktypeMapper.insert(w); //历史版本的工种信息 Worktype newType = new Worktype(); BeanUtils.copyProperties(w, newType); newType.setInsuranceId(newModel.getId()); newType.setBaseId(w.getId()); newType.setDataType(Constants.TWO); newType.setVersion(newModel.getVersion()); w.setSortnum(num++); saveList.add(newType); // worktypeMapper.insert(newType); } if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(saveList)){ worktypeJoinMapper.insertBatchSomeColumn(saveList); } } private void initCreateParam(Insurance insurance) { if(StringUtils.isBlank(insurance.getName())){ throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"对不起,请输入保险公司名称!"); } List worktypeList = new ArrayList<>(); if(insurance.getWorktypeList()!=null && insurance.getWorktypeList().size()>0){ for(Worktype w : insurance.getWorktypeList()){ if(StringUtils.isNotBlank(w.getName())){ worktypeList.add(w); } } } if(worktypeList.size()==0){ throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"对不起,工种不能为空!"); } if(StringUtils.isNotBlank(insurance.getEnglishName()) && insurance.getEnglishName().length()>100){ throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"对不起,英文名超长!"); } if(StringUtils.isNotBlank(insurance.getLinkName()) && insurance.getLinkName().length()>10){ throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"对不起,联系人名称超长!"); } if(StringUtils.isNotBlank(insurance.getLinkPhone()) && insurance.getLinkPhone().length()!=11){ throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"对不起,请输入正确的手机号!"); } insurance.setWorktypeList(worktypeList); } @Override public void deleteById(Integer id) { LoginUserInfo user= (LoginUserInfo)SecurityUtils.getSubject().getPrincipal(); Insurance model = findById(id); if(model == null || !Constants.equalsInteger(model.getDataType(),Constants.ZERO)){ throw new BusinessException(ResponseStatus.DATA_EMPTY ); } Insurance update = new Insurance(); update.setIsdeleted(Constants.ZERO); update.setEditDate(new Date()); update.setEditor(user.getId()); update.setId(id); insuranceMapper.updateById(update); //逻辑删除所有工种数据 worktypeMapper.update(null,new UpdateWrapper() .lambda() .eq(Worktype::getInsuranceId,id) .eq(Worktype::getIsdeleted,Constants.ZERO) .set(Worktype::getIsdeleted,Constants.ONE) ); } @Override public void delete(Insurance insurance) { LoginUserInfo user= (LoginUserInfo)SecurityUtils.getSubject().getPrincipal(); Insurance model = findById(insurance.getId()); if(model == null || !Constants.equalsInteger(model.getDataType(),Constants.ZERO)){ throw new BusinessException(ResponseStatus.DATA_EMPTY ); } Insurance update = new Insurance(); update.setIsdeleted(Constants.ZERO); update.setEditDate(new Date()); update.setId(insurance.getId()); update.setEditor(user.getId()); insuranceMapper.updateById(update); } @Override public void deleteByIdInBatch(List ids) { if (CollectionUtils.isEmpty(ids)) { return; } insuranceMapper.deleteBatchIds(ids); } /*@Override public void updateById(Insurance insurance) { Insurance model = findById(insurance.getId()); if(model == null || !Constants.equalsInteger(model.getIsdeleted(),Constants.ZERO) || !Constants.equalsInteger(model.getDataType(),Constants.ZERO)){ throw new BusinessException(ResponseStatus.DATA_EMPTY ); } //数据有效性校验 initCreateParam(insurance); if(insuranceMapper.selectCount(new QueryWrapper().lambda().eq(Insurance::getName,insurance.getName()) .eq(Insurance::getIsdeleted,Constants.ZERO) .eq(Insurance::getDataType,Constants.ZERO) .ne(Insurance::getId,insurance.getId()) )>Constants.ZERO){ throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"保险公司名称已存在"); } LoginUserInfo user= (LoginUserInfo)SecurityUtils.getSubject().getPrincipal(); Insurance updateModel = new Insurance(); updateModel.setEditor(user.getId()); updateModel.setName(insurance.getName()); updateModel.setId(model.getId()); updateModel.setVersion(UUID.randomUUID().toString()); updateModel.setEditDate(new Date()); updateModel.setRemark(insurance.getRemark()); updateModel.setSortnum(insurance.getSortnum()); updateModel.setLogo(insurance.getLogo()); updateModel.setEnglishName(insurance.getEnglishName()); updateModel.setLinkName(insurance.getLinkName()); updateModel.setLinkPhone(insurance.getLinkPhone()); updateModel.setPolicy(insurance.getPolicy()); updateModel.setAgreement(insurance.getAgreement()); updateModel.setClaimsInformation(insurance.getClaimsInformation()); insuranceMapper.updateById(updateModel); //如果修改,则产生一个新的历史版本 ~ // Insurance newModel = new Insurance(); // BeanUtils.copyProperties(model,newModel); // newModel.setId(null); // newModel.setVersion(updateModel.getVersion()); // newModel.setCreateDate(new Date()); // newModel.setName(updateModel.getName()); // newModel.setBaseId(insurance.getId()); // newModel.setDataType(Constants.TWO); // newModel.setLogo(insurance.getLogo()); // newModel.setEnglishName(insurance.getEnglishName()); // newModel.setLinkName(insurance.getLinkName()); // newModel.setLinkPhone(insurance.getLinkPhone()); // newModel.setPolicy(insurance.getPolicy()); // newModel.setAgreement(insurance.getAgreement()); // newModel.setClaimsInformation(insurance.getClaimsInformation()); // insuranceMapper.insert(newModel); Insurance useVersion = insuranceMapper.selectOne(new QueryWrapper().lambda() .eq(Insurance::getBaseId,insurance.getId()) .eq(Insurance::getDataType,Constants.TWO) .last(" limit 1") ); Insurance updateUsrModel = new Insurance(); updateUsrModel.setEditor(user.getId()); updateUsrModel.setName(insurance.getName()); updateUsrModel.setId(useVersion.getId()); updateUsrModel.setVersion(UUID.randomUUID().toString()); updateUsrModel.setEditDate(new Date()); updateUsrModel.setRemark(insurance.getRemark()); updateUsrModel.setSortnum(insurance.getSortnum()); updateUsrModel.setLogo(insurance.getLogo()); updateUsrModel.setEnglishName(insurance.getEnglishName()); updateUsrModel.setLinkName(insurance.getLinkName()); updateUsrModel.setLinkPhone(insurance.getLinkPhone()); updateUsrModel.setPolicy(insurance.getPolicy()); updateUsrModel.setAgreement(insurance.getAgreement()); updateUsrModel.setClaimsInformation(insurance.getClaimsInformation()); //删除所有工种数据 worktypeMapper.delete(new UpdateWrapper() .lambda() .in(Worktype::getInsuranceId,insurance.getId()) ); // insuranceMapper.update(null,new UpdateWrapper() // .lambda() // .eq(Insurance::getBaseId,insurance.getId()) // .eq(Insurance::getDataType,Constants.TWO) // .ne(Insurance::getId,newModel.getId()) // .set(Insurance::getDataType,Constants.ONE) // ); worktypeMapper.update(null,new UpdateWrapper() .lambda() .eq(Worktype::getInsuranceId,useVersion.getId()) .eq(Worktype::getDataType,Constants.TWO) .set(Worktype::getDataType,Constants.ONE) ); //处理工作信息,新增最新的,同时产生历史版本 dealWorkTypeData(updateModel,useVersion,insurance.getWorktypeList(),false); }*/ @Override public void updateById(Insurance insurance) { Insurance model = findById(insurance.getId()); if(model == null || !Constants.equalsInteger(model.getIsdeleted(),Constants.ZERO) || !Constants.equalsInteger(model.getDataType(),Constants.ZERO)){ throw new BusinessException(ResponseStatus.DATA_EMPTY ); } //数据有效性校验 initCreateParam(insurance); if(insuranceMapper.selectCount(new QueryWrapper().lambda().eq(Insurance::getName,insurance.getName()) .eq(Insurance::getIsdeleted,Constants.ZERO) .eq(Insurance::getDataType,Constants.ZERO) .ne(Insurance::getId,insurance.getId()) )>Constants.ZERO){ throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"保险公司名称已存在"); } LoginUserInfo user= (LoginUserInfo)SecurityUtils.getSubject().getPrincipal(); Insurance updateModel = new Insurance(); updateModel.setEditor(user.getId()); updateModel.setName(insurance.getName()); updateModel.setId(model.getId()); updateModel.setVersion(UUID.randomUUID().toString()); updateModel.setEditDate(new Date()); updateModel.setRemark(insurance.getRemark()); updateModel.setSortnum(insurance.getSortnum()); updateModel.setLogo(insurance.getLogo()); updateModel.setEnglishName(insurance.getEnglishName()); updateModel.setLinkName(insurance.getLinkName()); updateModel.setLinkPhone(insurance.getLinkPhone()); updateModel.setPolicy(insurance.getPolicy()); updateModel.setAgreement(insurance.getAgreement()); updateModel.setClaimsInformation(insurance.getClaimsInformation()); insuranceMapper.updateById(updateModel); //如果修改,则产生一个新的历史版本 ~ Insurance newModel = new Insurance(); BeanUtils.copyProperties(model,newModel); newModel.setId(null); newModel.setVersion(updateModel.getVersion()); newModel.setCreateDate(new Date()); newModel.setName(updateModel.getName()); newModel.setBaseId(insurance.getId()); newModel.setDataType(Constants.TWO); newModel.setLogo(insurance.getLogo()); newModel.setEnglishName(insurance.getEnglishName()); newModel.setLinkName(insurance.getLinkName()); newModel.setLinkPhone(insurance.getLinkPhone()); newModel.setPolicy(insurance.getPolicy()); newModel.setAgreement(insurance.getAgreement()); newModel.setClaimsInformation(insurance.getClaimsInformation()); insuranceMapper.insert(newModel); //删除所有工种数据 worktypeMapper.delete(new UpdateWrapper() .lambda() .eq(Worktype::getInsuranceId,insurance.getId()) ); insuranceMapper.update(null,new UpdateWrapper() .lambda() .eq(Insurance::getBaseId,insurance.getId()) .eq(Insurance::getDataType,Constants.TWO) .ne(Insurance::getId,newModel.getId()) .set(Insurance::getDataType,Constants.ONE) ); worktypeMapper.update(null,new UpdateWrapper() .lambda() .eq(Worktype::getBaseId,insurance.getId()) .eq(Worktype::getDataType,Constants.TWO) .set(Worktype::getDataType,Constants.ONE) ); //处理工作信息,新增最新的,同时产生历史版本 dealWorkTypeData(updateModel,newModel,insurance.getWorktypeList(),false); } @Override public void updateStatus(Insurance insurance){ if(insurance.getId() == null || insurance.getStatus()==null || insurance.getStatus()<0||insurance.getStatus()>1){ throw new BusinessException(ResponseStatus.BAD_REQUEST ); } Insurance model = findById(insurance.getId()); if(model == null || !Constants.equalsInteger(model.getIsdeleted(),Constants.ZERO) || !Constants.equalsInteger(model.getDataType(),Constants.ZERO)){ throw new BusinessException(ResponseStatus.DATA_EMPTY ); } if(Constants.equalsInteger(model.getStatus(),insurance.getStatus())){ //如果状态不发生改变,直接返回 return; } LoginUserInfo user= (LoginUserInfo)SecurityUtils.getSubject().getPrincipal(); //同时更新基表和历史版本所有数据状态 insuranceMapper.update(null,new UpdateWrapper() .lambda() .and(m -> m.eq(Insurance::getId,model.getId()).or().eq(Insurance::getBaseId,model.getId())) .eq(Insurance::getIsdeleted,Constants.ZERO) .set(Insurance::getEditDate,new Date()) .set(Insurance::getEditor,user.getId()) .set(Insurance::getStatus,insurance.getStatus()) ); } @Override public void updateByIdInBatch(List insurances) { if (CollectionUtils.isEmpty(insurances)) { return; } for (Insurance insurance: insurances) { this.updateById(insurance); } } @Override public Insurance findById(Integer id) { Insurance model = insuranceMapper.selectById(id); if(model == null || !Constants.equalsInteger(model.getIsdeleted(),Constants.ZERO)){ throw new BusinessException(ResponseStatus.DATA_EMPTY ); } List worktypeList = worktypeMapper.selectList(new QueryWrapper().lambda() .eq(Worktype::getInsuranceId,id) .eq(Worktype::getIsdeleted,Constants.ZERO) .orderByAsc(Worktype::getSortnum)); model.setWorktypeList(worktypeList); String path = systemDictDataBiz.queryByCode(Constants.OSS,Constants.RESOURCE_PATH).getCode()+ systemDictDataBiz.queryByCode(Constants.OSS,Constants.INSURANCE).getCode(); //附件信息 Multifile lpStampTempFile = multifileMapper.selectOne(new QueryWrapper().lambda().eq(Multifile::getIsdeleted,Constants.ZERO).eq(Multifile::getObjId,id).eq(Multifile::getObjId,10).last("limit 1")); lpStampTempFile.setFileurlFull(path + lpStampTempFile.getFileurl()); model.setLpStampTempFile(lpStampTempFile); Multifile lpFile = multifileMapper.selectOne(new QueryWrapper().lambda().eq(Multifile::getIsdeleted,Constants.ZERO).eq(Multifile::getObjId,id).eq(Multifile::getObjId,11).last("limit 1")); lpStampTempFile.setFileurlFull(path + lpFile.getFileurl()); model.setLpFile(lpFile); return model; } @Override public Insurance findOne(Insurance insurance) { QueryWrapper wrapper = new QueryWrapper<>(insurance); return insuranceMapper.selectOne(wrapper); } @Override public List findList(Insurance insurance) { insurance.setIsdeleted(Constants.ZERO); QueryWrapper wrapper = new QueryWrapper<>(insurance); return insuranceMapper.selectList(wrapper); } @Override public PageData findPage(PageWrap pageWrap) { IPage page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); QueryWrapper queryWrapper = new QueryWrapper<>(); Utils.MP.blankToNull(pageWrap.getModel()); pageWrap.getModel().setDataType(Constants.ZERO);//只选择基表数据 pageWrap.getModel().setIsdeleted(Constants.ZERO); if (pageWrap.getModel().getId() != null) { queryWrapper.lambda().eq(Insurance::getId, pageWrap.getModel().getId()); } if (pageWrap.getModel().getCreator() != null) { queryWrapper.lambda().eq(Insurance::getCreator, pageWrap.getModel().getCreator()); } if (pageWrap.getModel().getCreateDate() != null) { queryWrapper.lambda().ge(Insurance::getCreateDate, Utils.Date.getStart(pageWrap.getModel().getCreateDate())); queryWrapper.lambda().le(Insurance::getCreateDate, Utils.Date.getEnd(pageWrap.getModel().getCreateDate())); } if (pageWrap.getModel().getEditor() != null) { queryWrapper.lambda().eq(Insurance::getEditor, pageWrap.getModel().getEditor()); } if (pageWrap.getModel().getEditDate() != null) { queryWrapper.lambda().ge(Insurance::getEditDate, Utils.Date.getStart(pageWrap.getModel().getEditDate())); queryWrapper.lambda().le(Insurance::getEditDate, Utils.Date.getEnd(pageWrap.getModel().getEditDate())); } if (pageWrap.getModel().getIsdeleted() != null) { queryWrapper.lambda().eq(Insurance::getIsdeleted, pageWrap.getModel().getIsdeleted()); } if (pageWrap.getModel().getName() != null) { queryWrapper.lambda().like(Insurance::getName, pageWrap.getModel().getName()); } if (pageWrap.getModel().getRemark() != null) { queryWrapper.lambda().eq(Insurance::getRemark, pageWrap.getModel().getRemark()); } if (pageWrap.getModel().getStatus() != null) { queryWrapper.lambda().eq(Insurance::getStatus, pageWrap.getModel().getStatus()); } if (pageWrap.getModel().getSortnum() != null) { queryWrapper.lambda().eq(Insurance::getSortnum, pageWrap.getModel().getSortnum()); } if (pageWrap.getModel().getVersion() != null) { queryWrapper.lambda().eq(Insurance::getVersion, pageWrap.getModel().getVersion()); } if (pageWrap.getModel().getDataType() != null) { queryWrapper.lambda().eq(Insurance::getDataType, pageWrap.getModel().getDataType()); } if (pageWrap.getModel().getBaseId() != null) { queryWrapper.lambda().eq(Insurance::getBaseId, pageWrap.getModel().getBaseId()); } queryWrapper.lambda().orderByAsc(Insurance::getSortnum); PageData pageData = PageData.from(insuranceMapper.selectPage(page, queryWrapper)); if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(pageData.getRecords())){ String path = systemDictDataBiz.queryByCode(Constants.OSS,Constants.RESOURCE_PATH).getCode() +systemDictDataBiz.queryByCode(Constants.OSS,Constants.INSURANCE).getCode(); for (Insurance insurance:pageData.getRecords()) { if (StringUtils.isNotBlank(insurance.getLogo())) { insurance.setLogoFullUrl(path + insurance.getLogo() ); } } } return pageData; } @Override public long count(Insurance insurance) { QueryWrapper wrapper = new QueryWrapper<>(insurance); return insuranceMapper.selectCount(wrapper); } @Override public void saveLpInfo(Insurance insurance){ LoginUserInfo user= (LoginUserInfo)SecurityUtils.getSubject().getPrincipal(); if(Objects.isNull(insurance) || Objects.isNull(insurance.getId()) ){ throw new BusinessException(ResponseStatus.BAD_REQUEST); } multifileMapper.delete(new QueryWrapper().lambda() .eq(Multifile::getObjId,insurance.getId()) .in(Multifile::getObjType,Constants.MultiFile.LP_STAMP_FILE.getKey(),Constants.MultiFile.LP_FILE.getKey()) ); Insurance model = new Insurance(); model.setEditDate(new Date()); model.setEditor(user.getId()); if(Objects.nonNull(insurance.getLpStampTempFile())){ Multifile multifile = insurance.getLpStampTempFile(); multifile.setCreateDate(model.getEditDate()); multifile.setCreator(model.getEditor()); multifile.setIsdeleted(Constants.ZERO); multifile.setObjType(Constants.MultiFile.LP_STAMP_FILE.getKey()); multifile.setObjId(insurance.getId()); multifileMapper.insert(multifile); } if(Objects.nonNull(insurance.getLpFile())){ Multifile multifile = insurance.getLpFile(); multifile.setCreateDate(model.getEditDate()); multifile.setCreator(model.getEditor()); multifile.setIsdeleted(Constants.ZERO); multifile.setObjType(Constants.MultiFile.LP_FILE.getKey()); multifile.setObjId(insurance.getId()); multifileMapper.insert(multifile); } model.setId(insurance.getId()); model.setLpYggxFileInfo(insurance.getLpYggxFileInfo()); model.setLpMzFileInfo(insurance.getLpMzFileInfo()); model.setLpZyFileInfo(insurance.getLpZyFileInfo()); model.setLpScFileInfo(insurance.getLpScFileInfo()); model.setLpOtherFileInfo(insurance.getLpOtherFileInfo()); model.setLpFileStatus(Constants.ONE); insuranceMapper.updateById(model); } }