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.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.YwBuildingMapper; import com.doumee.dao.business.YwProjectMapper; import com.doumee.dao.business.YwRoomMapper; import com.doumee.dao.business.YwWorkorderMapper; import com.doumee.dao.business.model.*; import com.doumee.dao.system.MultifileMapper; import com.doumee.dao.system.model.Multifile; import com.doumee.dao.system.model.SystemUser; import com.doumee.service.business.YwWorkorderService; 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.github.yulichang.wrapper.MPJLambdaWrapper; import org.apache.commons.lang3.StringUtils; import org.checkerframework.checker.units.qual.C; 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.ArrayList; import java.util.Arrays; import java.util.Date; import java.util.List; /** * 运维工单信息表Service实现 * @author 江蹄蹄 * @date 2024/11/19 16:07 */ @Service public class YwWorkorderServiceImpl implements YwWorkorderService { @Autowired private YwWorkorderMapper ywWorkorderMapper; @Autowired private SystemDictDataBiz systemDictDataBiz; @Autowired private MultifileMapper multifileMapper; @Autowired private YwProjectMapper ywProjectMapper; @Autowired private YwRoomMapper ywRoomMapper; @Autowired private YwBuildingMapper ywBuildingMapper; @Override @Transactional(rollbackFor = {BusinessException.class,Exception.class}) public Integer create(YwWorkorder model) { dealParamValid(model); model.setCreator(model.getLoginUserInfo().getId()); model.setIsdeleted(Constants.ZERO); model.setCreateDate(new Date()); model.setStatus(Constants.ZERO); model.setEditDate(model.getCreateDate()); model.setEditor(model.getCreator()); ywWorkorderMapper.insert(model); List fileList = new ArrayList<>(); if(model.getFileList()!=null && model.getFileList().size()>0){ boolean isTrue = false; for (int i = 0; i < model.getFileList().size(); i++) { Multifile multifile = model.getFileList().get(i); if(StringUtils.isBlank(multifile.getFileurl())){ continue; } multifile.setCreateDate(new Date()); multifile.setCreator(model.getEditor()); multifile.setIsdeleted(Constants.ZERO); multifile.setObjId(model.getId()); multifile.setCreator(model.getCreator()); multifile.setObjType(Constants.MultiFile.YW_WORKORDER_PROBLEM.getKey()); multifile.setSortnum(i+1); fileList.add(multifile); } } if(fileList.size()>0){ multifileMapper.insert(fileList); } return model.getId(); } private void dealParamValid(YwWorkorder model) { if(Constants.equalsInteger(model.getAreaType(),Constants.ZERO)) { //如果是市内装修,必须选择房源信息 if(model.getRoomId()==null){ throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"对不起,请选择正确的房源信息!"); } YwRoom room = ywRoomMapper.selectById(model.getRoomId()); if(room ==null || Constants.equalsInteger(room.getIsdeleted(),Constants.ONE)){ throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"对不起,请选择正确的房源信息!"); } model.setBuildingId(room.getBuildingId()); model.setProjectId(room.getProjectId()); }else{ //如果是公共区域装修,必须选择楼宇信息 if(model.getBuildingId()==null){ throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"对不起,请选择正确的楼宇信息!"); } YwBuilding room = ywBuildingMapper.selectById(model.getRoomId()); if(room ==null || Constants.equalsInteger(room.getIsdeleted(),Constants.ONE)){ throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"对不起,请选择正确的楼宇信息!"); } model.setProjectId(room.getProjectId()); } } @Override public void deleteById(Integer id, LoginUserInfo user) { YwWorkorder model = new YwWorkorder(); model.setId(id); model.setEditDate(new Date()); model.setEditor(user.getId()); model.setIsdeleted(Constants.ONE); ywWorkorderMapper.updateById(model); } @Override public void delete(YwWorkorder ywWorkorder) { UpdateWrapper deleteWrapper = new UpdateWrapper<>(ywWorkorder); ywWorkorderMapper.delete(deleteWrapper); } @Override public void deleteByIdInBatch(List ids, LoginUserInfo user) { if (CollectionUtils.isEmpty(ids)) { return; } for(Integer id : ids){ this.deleteById(id,user); } } @Override @Transactional(rollbackFor = {BusinessException.class,Exception.class}) public void updateById(YwWorkorder model) { dealParamValid(model); model.setEditDate(new Date()); model.setEditor(model.getLoginUserInfo().getId()); ywWorkorderMapper.updateById(model); List fileList = new ArrayList<>(); if(model.getFileList()!=null && model.getFileList().size()>0){ for (int i = 0; i < model.getFileList().size(); i++) { Multifile multifile = model.getFileList().get(i); if(StringUtils.isBlank(multifile.getFileurl())){ continue; } multifile.setCreateDate(new Date()); multifile.setCreator(model.getEditor()); multifile.setIsdeleted(Constants.ZERO); multifile.setObjId(model.getId()); multifile.setCreator(model.getCreator()); multifile.setObjType(Constants.MultiFile.YW_WORKORDER_PROBLEM.getKey()); multifile.setSortnum(i+1); fileList.add(multifile); } } multifileMapper.update(null,new UpdateWrapper().lambda() .set(Multifile::getIsdeleted,Constants.ONE) .set(Multifile::getEditDate,model.getEditDate()) .set(Multifile::getEditor,model.getEditor()) .eq(Multifile::getIsdeleted, Constants.ZERO) .eq(Multifile::getObjType,Constants.MultiFile.YW_WORKORDER_PROBLEM.getKey()) ); if(fileList.size()>0){ multifileMapper.insert(fileList); } } private void initFiles(YwWorkorder model) { List multifiles = multifileMapper.selectList(new QueryWrapper().lambda() .eq(Multifile::getObjId, model.getId() ) .in(Multifile::getObjType, Arrays.asList(new Integer[]{Constants.MultiFile.YW_WORKORDER_PROBLEM.getKey() ,Constants.MultiFile.YW_WORKORDER_DEAL.getKey() })) .eq(Multifile::getIsdeleted,Constants.ZERO)); if(multifiles!=null){ String path = systemDictDataBiz.queryByCode(Constants.FTP,Constants.FTP_RESOURCE_PATH).getCode() +systemDictDataBiz.queryByCode(Constants.FTP,Constants.YW_WORKORDER_FILE).getCode(); for(Multifile f : multifiles){ if(StringUtils.isBlank(f.getFileurl())){ continue; } f.setFileurlFull(path+f.getFileurl()); if(Constants.equalsInteger(f.getObjType(),Constants.MultiFile.YW_WORKORDER_PROBLEM.getKey())){ //现场情况 if(model.getFileList() == null){ model.setFileList(new ArrayList<>()); } model.getFileList().add(f); } if(Constants.equalsInteger(f.getObjType(),Constants.MultiFile.YW_WORKORDER_DEAL.getKey())){ //处理附件 if(model.getDealFileList() == null){ model.setDealFileList(new ArrayList<>()); } model.getDealFileList().add(f); } } } } @Override public void updateByIdInBatch(List ywWorkorders) { if (CollectionUtils.isEmpty(ywWorkorders)) { return; } for (YwWorkorder ywWorkorder: ywWorkorders) { this.updateById(ywWorkorder); } } @Override public YwWorkorder findById(Integer id) { MPJLambdaWrapper wrapper = new MPJLambdaWrapper<>(); wrapper.selectAll(YwWorkorder.class ) .selectAs(SystemUser::getRealname,YwWorkorder::getCreatorName) .selectAs(SystemUser::getMobile,YwWorkorder::getCreatorPhone) .selectAs(Company::getCompanyNamePath,YwWorkorder::getCreatorCompany) .leftJoin(SystemUser.class,SystemUser::getId,YwWorkorder::getCreator) .leftJoin(Company.class,Company::getId,SystemUser::getCompanyId) .eq(YwWorkorder::getId,id); YwWorkorder model = ywWorkorderMapper.selectJoinOne(YwWorkorder.class,wrapper); initFiles(model);//读取附件信息 return model; } @Override public YwWorkorder findOne(YwWorkorder ywWorkorder) { QueryWrapper wrapper = new QueryWrapper<>(ywWorkorder); return ywWorkorderMapper.selectOne(wrapper); } @Override public List findList(YwWorkorder ywWorkorder) { ywWorkorder.setIsdeleted(Constants.ZERO); QueryWrapper wrapper = new QueryWrapper<>(ywWorkorder); return ywWorkorderMapper.selectList(wrapper); } @Override public PageData findPage(PageWrap pageWrap) { IPage page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); QueryWrapper queryWrapper = new QueryWrapper<>(); pageWrap.getModel().setIsdeleted(Constants.ZERO); Utils.MP.blankToNull(pageWrap.getModel()); if (pageWrap.getModel().getId() != null) { queryWrapper.lambda().eq(YwWorkorder::getId, pageWrap.getModel().getId()); } if (pageWrap.getModel().getCreator() != null) { queryWrapper.lambda().eq(YwWorkorder::getCreator, pageWrap.getModel().getCreator()); } if (pageWrap.getModel().getCreateDate() != null) { queryWrapper.lambda().ge(YwWorkorder::getCreateDate, Utils.Date.getStart(pageWrap.getModel().getCreateDate())); queryWrapper.lambda().le(YwWorkorder::getCreateDate, Utils.Date.getEnd(pageWrap.getModel().getCreateDate())); } if (pageWrap.getModel().getEditor() != null) { queryWrapper.lambda().eq(YwWorkorder::getEditor, pageWrap.getModel().getEditor()); } if (pageWrap.getModel().getEditDate() != null) { queryWrapper.lambda().ge(YwWorkorder::getEditDate, Utils.Date.getStart(pageWrap.getModel().getEditDate())); queryWrapper.lambda().le(YwWorkorder::getEditDate, Utils.Date.getEnd(pageWrap.getModel().getEditDate())); } if (pageWrap.getModel().getIsdeleted() != null) { queryWrapper.lambda().eq(YwWorkorder::getIsdeleted, pageWrap.getModel().getIsdeleted()); } if (pageWrap.getModel().getTitle() != null) { queryWrapper.lambda().eq(YwWorkorder::getTitle, pageWrap.getModel().getTitle()); } if (pageWrap.getModel().getRemark() != null) { queryWrapper.lambda().eq(YwWorkorder::getRemark, pageWrap.getModel().getRemark()); } if (pageWrap.getModel().getStatus() != null) { queryWrapper.lambda().eq(YwWorkorder::getStatus, pageWrap.getModel().getStatus()); } if (pageWrap.getModel().getSortnum() != null) { queryWrapper.lambda().eq(YwWorkorder::getSortnum, pageWrap.getModel().getSortnum()); } if (pageWrap.getModel().getContent() != null) { queryWrapper.lambda().eq(YwWorkorder::getContent, pageWrap.getModel().getContent()); } if (pageWrap.getModel().getGetDate() != null) { queryWrapper.lambda().ge(YwWorkorder::getGetDate, Utils.Date.getStart(pageWrap.getModel().getGetDate())); queryWrapper.lambda().le(YwWorkorder::getGetDate, Utils.Date.getEnd(pageWrap.getModel().getGetDate())); } if (pageWrap.getModel().getProjectId() != null) { queryWrapper.lambda().eq(YwWorkorder::getProjectId, pageWrap.getModel().getProjectId()); } if (pageWrap.getModel().getBuildingId() != null) { queryWrapper.lambda().eq(YwWorkorder::getBuildingId, pageWrap.getModel().getBuildingId()); } if (pageWrap.getModel().getRoomId() != null) { queryWrapper.lambda().eq(YwWorkorder::getRoomId, pageWrap.getModel().getRoomId()); } if (pageWrap.getModel().getUserId() != null) { queryWrapper.lambda().eq(YwWorkorder::getUserId, pageWrap.getModel().getUserId()); } if (pageWrap.getModel().getPhone() != null) { queryWrapper.lambda().eq(YwWorkorder::getPhone, pageWrap.getModel().getPhone()); } if (pageWrap.getModel().getSubmitDate() != null) { queryWrapper.lambda().ge(YwWorkorder::getSubmitDate, Utils.Date.getStart(pageWrap.getModel().getSubmitDate())); queryWrapper.lambda().le(YwWorkorder::getSubmitDate, Utils.Date.getEnd(pageWrap.getModel().getSubmitDate())); } if (pageWrap.getModel().getCateId() != null) { queryWrapper.lambda().eq(YwWorkorder::getCateId, pageWrap.getModel().getCateId()); } if (pageWrap.getModel().getAreaType() != null) { queryWrapper.lambda().eq(YwWorkorder::getAreaType, pageWrap.getModel().getAreaType()); } if (pageWrap.getModel().getCode() != null) { queryWrapper.lambda().eq(YwWorkorder::getCode, pageWrap.getModel().getCode()); } if (pageWrap.getModel().getDealStatus() != null) { queryWrapper.lambda().eq(YwWorkorder::getDealStatus, pageWrap.getModel().getDealStatus()); } if (pageWrap.getModel().getDispatchUserId() != null) { queryWrapper.lambda().eq(YwWorkorder::getDispatchUserId, pageWrap.getModel().getDispatchUserId()); } if (pageWrap.getModel().getDispatchDate() != null) { queryWrapper.lambda().ge(YwWorkorder::getDispatchDate, Utils.Date.getStart(pageWrap.getModel().getDispatchDate())); queryWrapper.lambda().le(YwWorkorder::getDispatchDate, Utils.Date.getEnd(pageWrap.getModel().getDispatchDate())); } if (pageWrap.getModel().getDispatchInfo() != null) { queryWrapper.lambda().eq(YwWorkorder::getDispatchInfo, pageWrap.getModel().getDispatchInfo()); } if (pageWrap.getModel().getDealUserId() != null) { queryWrapper.lambda().eq(YwWorkorder::getDealUserId, pageWrap.getModel().getDealUserId()); } if (pageWrap.getModel().getDealDate() != null) { queryWrapper.lambda().ge(YwWorkorder::getDealDate, Utils.Date.getStart(pageWrap.getModel().getDealDate())); queryWrapper.lambda().le(YwWorkorder::getDealDate, Utils.Date.getEnd(pageWrap.getModel().getDealDate())); } if (pageWrap.getModel().getDealInfo() != null) { queryWrapper.lambda().eq(YwWorkorder::getDealInfo, pageWrap.getModel().getDealInfo()); } if (pageWrap.getModel().getDealType() != null) { queryWrapper.lambda().eq(YwWorkorder::getDealType, pageWrap.getModel().getDealType()); } for(PageWrap.SortData sortData: pageWrap.getSorts()) { if (sortData.getDirection().equalsIgnoreCase(PageWrap.DESC)) { queryWrapper.orderByDesc(sortData.getProperty()); } else { queryWrapper.orderByAsc(sortData.getProperty()); } } return PageData.from(ywWorkorderMapper.selectPage(page, queryWrapper)); } @Override public long count(YwWorkorder ywWorkorder) { QueryWrapper wrapper = new QueryWrapper<>(ywWorkorder); return ywWorkorderMapper.selectCount(wrapper); } }