From a28e0d402702e69e0e75b0c902835239d21bfb6f Mon Sep 17 00:00:00 2001 From: k94314517 <8417338+k94314517@user.noreply.gitee.com> Date: 星期四, 21 十一月 2024 14:19:01 +0800 Subject: [PATCH] 设备、巡检任务业务 --- server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwPatrolPointServiceImpl.java | 165 +++++++++++++++++++++++++++++++++++++----------------- 1 files changed, 113 insertions(+), 52 deletions(-) diff --git a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwPatrolPointServiceImpl.java b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwPatrolPointServiceImpl.java index 0af2a22..948ccf5 100644 --- a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwPatrolPointServiceImpl.java +++ b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwPatrolPointServiceImpl.java @@ -1,21 +1,34 @@ 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.YwPatrolPointMapper; +import com.doumee.dao.business.model.Category; +import com.doumee.dao.business.model.YwDevice; import com.doumee.dao.business.model.YwPatrolPoint; +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.YwPatrolPointService; 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.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.util.CollectionUtils; +import java.util.Date; import java.util.List; +import java.util.Objects; /** * 杩愮淮宸℃鐐逛俊鎭〃Service瀹炵幇 @@ -27,16 +40,50 @@ @Autowired private YwPatrolPointMapper ywPatrolPointMapper; + @Autowired + private SystemDictDataBiz systemDictDataBiz; + @Autowired + private MultifileMapper multifileMapper; @Override public Integer create(YwPatrolPoint ywPatrolPoint) { + if(Objects.isNull(ywPatrolPoint) + || Objects.isNull(ywPatrolPoint.getCode()) + || Objects.isNull(ywPatrolPoint.getName()) + ){ + throw new BusinessException(ResponseStatus.BAD_REQUEST); + } + if(ywPatrolPointMapper.selectCount(new QueryWrapper<YwPatrolPoint>().lambda().eq(YwPatrolPoint::getIsdeleted,Constants.ZERO) + .eq(YwPatrolPoint::getCode,ywPatrolPoint.getCode()))>Constants.ZERO){ + throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"宸℃鐐圭紪鐮侀噸澶�!"); + } + LoginUserInfo loginUserInfo = ywPatrolPoint.getLoginUserInfo(); + ywPatrolPoint.setCreateDate(new Date()); + ywPatrolPoint.setCreator(loginUserInfo.getId()); + ywPatrolPoint.setIsdeleted(Constants.ZERO); + ywPatrolPoint.setStatus(Constants.ZERO); ywPatrolPointMapper.insert(ywPatrolPoint); + + + if(Objects.nonNull(ywPatrolPoint.getMultifile())){ + ywPatrolPoint.getMultifile().setCreator(loginUserInfo.getId()); + ywPatrolPoint.getMultifile().setCreateDate(new Date()); + ywPatrolPoint.getMultifile().setIsdeleted(Constants.ZERO); + ywPatrolPoint.getMultifile().setObjType(Constants.MultiFile.FN_PATROL_POINT_FILE.getKey()); + ywPatrolPoint.getMultifile().setObjId(ywPatrolPoint.getId()); + multifileMapper.insert(ywPatrolPoint.getMultifile()); + } + return ywPatrolPoint.getId(); } @Override public void deleteById(Integer id, LoginUserInfo user) { - ywPatrolPointMapper.deleteById(id); + ywPatrolPointMapper.update(new UpdateWrapper<YwPatrolPoint>().lambda().set(YwPatrolPoint::getIsdeleted,Constants.ONE) + .set(YwPatrolPoint::getEditDate," now() ") + .set(YwPatrolPoint::getEditor,user.getId()) + .eq(YwPatrolPoint::getId,user.getId()) + ); } @Override @@ -55,7 +102,36 @@ @Override public void updateById(YwPatrolPoint ywPatrolPoint) { + if(Objects.isNull(ywPatrolPoint) + || Objects.isNull(ywPatrolPoint.getId()) + || Objects.isNull(ywPatrolPoint.getCode()) + || Objects.isNull(ywPatrolPoint.getName()) + ){ + throw new BusinessException(ResponseStatus.BAD_REQUEST); + } + if(ywPatrolPointMapper.selectCount(new QueryWrapper<YwPatrolPoint>().lambda().eq(YwPatrolPoint::getIsdeleted,Constants.ZERO) + .eq(YwPatrolPoint::getCode,ywPatrolPoint.getCode()).ne(YwPatrolPoint::getId,ywPatrolPoint.getId()))>Constants.ZERO){ + throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"宸℃鐐圭紪鐮侀噸澶�!"); + } + LoginUserInfo loginUserInfo = ywPatrolPoint.getLoginUserInfo(); + ywPatrolPoint.setEditDate(new Date()); + ywPatrolPoint.setEditor(loginUserInfo.getId()); ywPatrolPointMapper.updateById(ywPatrolPoint); + + multifileMapper.delete(new QueryWrapper<Multifile>().lambda() + .eq(Multifile::getObjId,ywPatrolPoint.getId()) + .eq(Multifile::getObjType,Constants.MultiFile.FN_PATROL_POINT_FILE.getKey()) + ); + + if(Objects.nonNull(ywPatrolPoint.getMultifile())){ + ywPatrolPoint.getMultifile().setCreator(loginUserInfo.getId()); + ywPatrolPoint.getMultifile().setCreateDate(new Date()); + ywPatrolPoint.getMultifile().setIsdeleted(Constants.ZERO); + ywPatrolPoint.getMultifile().setObjType(Constants.MultiFile.FN_PATROL_POINT_FILE.getKey()); + ywPatrolPoint.getMultifile().setObjId(ywPatrolPoint.getId()); + multifileMapper.insert(ywPatrolPoint.getMultifile()); + } + } @Override @@ -74,6 +150,22 @@ } @Override + public YwPatrolPoint getDetail(Integer id) { + YwPatrolPoint ywPatrolPoint = ywPatrolPointMapper.selectById(id); + Multifile multifile = multifileMapper.selectOne(new QueryWrapper<Multifile>().lambda().eq(Multifile::getObjId,id) + .eq(Multifile::getObjType,Constants.MultiFile.FN_PATROL_POINT_FILE).last(" limit 1")); + if(Objects.nonNull(multifile)){ + String path = systemDictDataBiz.queryByCode(Constants.FTP,Constants.FTP_RESOURCE_PATH).getCode() + +systemDictDataBiz.queryByCode(Constants.FTP,Constants.YW_PATROL).getCode(); + multifile.setFileurlFull(path + multifile.getFileurl()); + ywPatrolPoint.setMultifile(multifile); + } + return ywPatrolPoint; + } + + + + @Override public YwPatrolPoint findOne(YwPatrolPoint ywPatrolPoint) { QueryWrapper<YwPatrolPoint> wrapper = new QueryWrapper<>(ywPatrolPoint); return ywPatrolPointMapper.selectOne(wrapper); @@ -81,64 +173,33 @@ @Override public List<YwPatrolPoint> findList(YwPatrolPoint ywPatrolPoint) { - QueryWrapper<YwPatrolPoint> wrapper = new QueryWrapper<>(ywPatrolPoint); + QueryWrapper<YwPatrolPoint> wrapper = new QueryWrapper<>(); + wrapper.lambda().eq(YwPatrolPoint::getIsdeleted,Constants.ZERO); + if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(ywPatrolPoint.getIdLists())){ + wrapper.lambda().notIn(YwPatrolPoint::getId,ywPatrolPoint.getIdLists()); + } return ywPatrolPointMapper.selectList(wrapper); } @Override public PageData<YwPatrolPoint> findPage(PageWrap<YwPatrolPoint> pageWrap) { IPage<YwPatrolPoint> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); - QueryWrapper<YwPatrolPoint> queryWrapper = new QueryWrapper<>(); + MPJLambdaWrapper<YwPatrolPoint> queryWrapper = new MPJLambdaWrapper<YwPatrolPoint>(); Utils.MP.blankToNull(pageWrap.getModel()); - if (pageWrap.getModel().getId() != null) { - queryWrapper.lambda().eq(YwPatrolPoint::getId, pageWrap.getModel().getId()); - } - if (pageWrap.getModel().getCreator() != null) { - queryWrapper.lambda().eq(YwPatrolPoint::getCreator, pageWrap.getModel().getCreator()); - } - if (pageWrap.getModel().getCreateDate() != null) { - queryWrapper.lambda().ge(YwPatrolPoint::getCreateDate, Utils.Date.getStart(pageWrap.getModel().getCreateDate())); - queryWrapper.lambda().le(YwPatrolPoint::getCreateDate, Utils.Date.getEnd(pageWrap.getModel().getCreateDate())); - } - if (pageWrap.getModel().getEditor() != null) { - queryWrapper.lambda().eq(YwPatrolPoint::getEditor, pageWrap.getModel().getEditor()); - } - if (pageWrap.getModel().getEditDate() != null) { - queryWrapper.lambda().ge(YwPatrolPoint::getEditDate, Utils.Date.getStart(pageWrap.getModel().getEditDate())); - queryWrapper.lambda().le(YwPatrolPoint::getEditDate, Utils.Date.getEnd(pageWrap.getModel().getEditDate())); - } - if (pageWrap.getModel().getIsdeleted() != null) { - queryWrapper.lambda().eq(YwPatrolPoint::getIsdeleted, pageWrap.getModel().getIsdeleted()); - } - if (pageWrap.getModel().getName() != null) { - queryWrapper.lambda().eq(YwPatrolPoint::getName, pageWrap.getModel().getName()); - } - if (pageWrap.getModel().getRemark() != null) { - queryWrapper.lambda().eq(YwPatrolPoint::getRemark, pageWrap.getModel().getRemark()); - } - if (pageWrap.getModel().getStatus() != null) { - queryWrapper.lambda().eq(YwPatrolPoint::getStatus, pageWrap.getModel().getStatus()); - } - if (pageWrap.getModel().getSortnum() != null) { - queryWrapper.lambda().eq(YwPatrolPoint::getSortnum, pageWrap.getModel().getSortnum()); - } - if (pageWrap.getModel().getImgurl() != null) { - queryWrapper.lambda().eq(YwPatrolPoint::getImgurl, pageWrap.getModel().getImgurl()); - } - if (pageWrap.getModel().getAreaId() != null) { - queryWrapper.lambda().eq(YwPatrolPoint::getAreaId, pageWrap.getModel().getAreaId()); - } - if (pageWrap.getModel().getAddr() != null) { - queryWrapper.lambda().eq(YwPatrolPoint::getAddr, pageWrap.getModel().getAddr()); - } - for(PageWrap.SortData sortData: pageWrap.getSorts()) { - if (sortData.getDirection().equalsIgnoreCase(PageWrap.DESC)) { - queryWrapper.orderByDesc(sortData.getProperty()); - } else { - queryWrapper.orderByAsc(sortData.getProperty()); - } - } - return PageData.from(ywPatrolPointMapper.selectPage(page, queryWrapper)); + YwPatrolPoint model = pageWrap.getModel(); + queryWrapper.selectAll(YwPatrolPoint.class) + .selectAs(Category::getName,YwPatrolPoint::getAreaName) + .selectAs(YwDevice::getName,YwPatrolPoint::getDeviceName) + .leftJoin(Category.class,Category::getId,YwPatrolPoint::getAreaId) + .leftJoin(YwDevice.class,YwDevice::getId,YwPatrolPoint::getDeviceId) + .and(Objects.nonNull(model)&&StringUtils.isNotBlank(model.getName()), + i->i.like(YwPatrolPoint::getName,model.getName()).or().like(YwPatrolPoint::getCode,model.getName())) + .eq(Objects.nonNull(model.getAreaId()),YwPatrolPoint::getAreaId,model.getAreaId()) + .eq(YwPatrolPoint::getIsdeleted,Constants.ZERO) + .orderByDesc(YwPatrolPoint::getCreateDate) + ; + IPage iPage = ywPatrolPointMapper.selectJoinPage(page,YwPatrolPoint.class,queryWrapper); + return PageData.from(iPage); } @Override -- Gitblit v1.9.3