|  |  | 
 |  |  | package com.doumee.service.business.impl; | 
 |  |  |  | 
 |  |  | 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.WorktypeMapper; | 
 |  |  | import com.doumee.dao.business.model.Insurance; | 
 |  |  | 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 org.apache.commons.lang3.StringUtils; | 
 |  |  | import org.apache.shiro.SecurityUtils; | 
 |  |  | 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.List; | 
 |  |  | import java.util.*; | 
 |  |  | import java.util.stream.Collectors; | 
 |  |  |  | 
 |  |  | /** | 
 |  |  |  * 保险公司信息表Service实现 | 
 |  |  | 
 |  |  |  | 
 |  |  |     @Autowired | 
 |  |  |     private InsuranceMapper insuranceMapper; | 
 |  |  |     @Autowired | 
 |  |  |     private WorktypeMapper worktypeMapper; | 
 |  |  |  | 
 |  |  |     @Override | 
 |  |  |     @Transactional | 
 |  |  |     public Integer create(Insurance insurance) { | 
 |  |  |         insuranceMapper.insert(insurance); | 
 |  |  |  | 
 |  |  |         LoginUserInfo user= (LoginUserInfo)SecurityUtils.getSubject().getPrincipal(); | 
 |  |  |         initCreateParam(insurance);//工种数据有效性检验,去除空白行数据 | 
 |  |  |  | 
 |  |  |         if(insuranceMapper.selectCount(new QueryWrapper<Insurance>().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<Worktype> worktypeList,boolean isNew) { | 
 |  |  |        int num=0; | 
 |  |  |         List<String> workTypeName = worktypeList.stream().map(m->m.getName()).collect(Collectors.toList()); | 
 |  |  |         Set<String> set = new HashSet<>(workTypeName); | 
 |  |  |         if(workTypeName.size() != set.size()){ | 
 |  |  |             throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(),"对不起,工种录入数据存在相同数据!"); | 
 |  |  |         } | 
 |  |  |         for(Worktype w : worktypeList) { | 
 |  |  |             if(!isNew){ | 
 |  |  |                 //查询保险公司下是否已存在该工种 | 
 |  |  |                 if(worktypeMapper.selectCount(new QueryWrapper<Worktype>().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(insurance.getCreateDate()); | 
 |  |  |             w.setDataType(insurance.getDataType()); | 
 |  |  |             w.setStatus(Constants.ZERO); | 
 |  |  |             w.setVersion(insurance.getVersion()); | 
 |  |  |             w.setSortnum(num++); | 
 |  |  |             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++); | 
 |  |  |             worktypeMapper.insert(newType); | 
 |  |  |         } | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     private void initCreateParam(Insurance insurance) { | 
 |  |  |         if(StringUtils.isBlank(insurance.getName())){ | 
 |  |  |             throw  new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"对不起,请输入保险公司名称!"); | 
 |  |  |         } | 
 |  |  |         List<Worktype> 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(),"对不起,工种不能为空!"); | 
 |  |  |         } | 
 |  |  |         insurance.setWorktypeList(worktypeList); | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     @Override | 
 |  |  |     public void deleteById(Integer id) { | 
 |  |  |         insuranceMapper.deleteById(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<Worktype>() | 
 |  |  |                 .lambda() | 
 |  |  |                 .eq(Worktype::getInsuranceId,id) | 
 |  |  |                 .eq(Worktype::getIsdeleted,Constants.ZERO) | 
 |  |  |                 .set(Worktype::getIsdeleted,Constants.ONE) | 
 |  |  |          ); | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     @Override | 
 |  |  |     public void delete(Insurance insurance) { | 
 |  |  |         UpdateWrapper<Insurance> deleteWrapper = new UpdateWrapper<>(insurance); | 
 |  |  |         insuranceMapper.delete(deleteWrapper); | 
 |  |  |         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 | 
 |  |  | 
 |  |  |  | 
 |  |  |     @Override | 
 |  |  |     public void updateById(Insurance insurance) { | 
 |  |  |         insuranceMapper.updateById(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<Insurance>().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()); | 
 |  |  |         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); | 
 |  |  |         insuranceMapper.insert(newModel); | 
 |  |  |  | 
 |  |  |         //删除所有工种数据 | 
 |  |  |         worktypeMapper.delete(new UpdateWrapper<Worktype>() | 
 |  |  |                 .lambda() | 
 |  |  |                 .eq(Worktype::getInsuranceId,insurance.getId()) | 
 |  |  |         ); | 
 |  |  |         insuranceMapper.update(null,new UpdateWrapper<Insurance>() | 
 |  |  |                 .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<Worktype>() | 
 |  |  |                 .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<Insurance>() | 
 |  |  |                 .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 | 
 |  |  | 
 |  |  |  | 
 |  |  |     @Override | 
 |  |  |     public Insurance findById(Integer id) { | 
 |  |  |         return insuranceMapper.selectById(id); | 
 |  |  |         Insurance model = insuranceMapper.selectById(id); | 
 |  |  |         if(model == null  || !Constants.equalsInteger(model.getIsdeleted(),Constants.ZERO)){ | 
 |  |  |             throw  new BusinessException(ResponseStatus.DATA_EMPTY ); | 
 |  |  |         } | 
 |  |  |         List<Worktype> worktypeList = worktypeMapper.selectList(new QueryWrapper<Worktype>().lambda() | 
 |  |  |                 .eq(Worktype::getInsuranceId,id) | 
 |  |  |                 .eq(Worktype::getIsdeleted,Constants.ZERO) | 
 |  |  |                 .orderByAsc(Worktype::getSortnum)); | 
 |  |  |         model.setWorktypeList(worktypeList); | 
 |  |  |         return model; | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     @Override | 
 |  |  | 
 |  |  |  | 
 |  |  |     @Override | 
 |  |  |     public List<Insurance> findList(Insurance insurance) { | 
 |  |  |         insurance.setIsdeleted(Constants.ZERO); | 
 |  |  |         QueryWrapper<Insurance> wrapper = new QueryWrapper<>(insurance); | 
 |  |  |         return insuranceMapper.selectList(wrapper); | 
 |  |  |     } | 
 |  |  | 
 |  |  |         IPage<Insurance> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); | 
 |  |  |         QueryWrapper<Insurance> 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()); | 
 |  |  |         } | 
 |  |  | 
 |  |  |             queryWrapper.lambda().eq(Insurance::getIsdeleted, pageWrap.getModel().getIsdeleted()); | 
 |  |  |         } | 
 |  |  |         if (pageWrap.getModel().getName() != null) { | 
 |  |  |             queryWrapper.lambda().eq(Insurance::getName, pageWrap.getModel().getName()); | 
 |  |  |             queryWrapper.lambda().like(Insurance::getName, pageWrap.getModel().getName()); | 
 |  |  |         } | 
 |  |  |         if (pageWrap.getModel().getRemark() != null) { | 
 |  |  |             queryWrapper.lambda().eq(Insurance::getRemark, pageWrap.getModel().getRemark()); | 
 |  |  | 
 |  |  |         if (pageWrap.getModel().getBaseId() != null) { | 
 |  |  |             queryWrapper.lambda().eq(Insurance::getBaseId, pageWrap.getModel().getBaseId()); | 
 |  |  |         } | 
 |  |  |         for(PageWrap.SortData sortData: pageWrap.getSorts()) { | 
 |  |  |  /*       for(PageWrap.SortData sortData: pageWrap.getSorts()) { | 
 |  |  |             if (sortData.getDirection().equalsIgnoreCase(PageWrap.DESC)) { | 
 |  |  |                 queryWrapper.orderByDesc(sortData.getProperty()); | 
 |  |  |             } else { | 
 |  |  |                 queryWrapper.orderByAsc(sortData.getProperty()); | 
 |  |  |             } | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |         }*/ | 
 |  |  |         queryWrapper.lambda().orderByAsc(Insurance::getSortnum); | 
 |  |  |         return PageData.from(insuranceMapper.selectPage(page, queryWrapper)); | 
 |  |  |     } | 
 |  |  |  |