From ffa2aeb2e9f4024600e82f1dfe872db2ee39487a Mon Sep 17 00:00:00 2001 From: k94314517 <8417338+k94314517@user.noreply.gitee.com> Date: 星期四, 12 九月 2024 15:09:12 +0800 Subject: [PATCH] 代码初始化 --- server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/PlatformServiceImpl.java | 79 ++++++++++++++++++++++++++++++++++++--- 1 files changed, 72 insertions(+), 7 deletions(-) diff --git a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/PlatformServiceImpl.java b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/PlatformServiceImpl.java index 486115c..4acdb01 100644 --- a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/PlatformServiceImpl.java +++ b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/PlatformServiceImpl.java @@ -1,20 +1,32 @@ 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.PlatformMapper; +import com.doumee.dao.business.join.PlatformJoinMapper; +import com.doumee.dao.business.model.Member; import com.doumee.dao.business.model.Platform; +import com.doumee.dao.business.model.PlatformGroup; +import com.doumee.dao.openapi.response.PlatformNumByStatusResponse; import com.doumee.service.business.PlatformService; 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.shiro.SecurityUtils; 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.stream.Collectors; /** * 鏈堝彴淇℃伅琛⊿ervice瀹炵幇 @@ -26,6 +38,8 @@ @Autowired private PlatformMapper platformMapper; + @Autowired + private PlatformJoinMapper platformJoinMapper; @Override public Integer create(Platform platform) { @@ -58,6 +72,24 @@ } @Override + public void updateStatusById(Platform platform) { + Platform model =platformMapper.selectById(platform.getId()); + if(model ==null) { + throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"瀵逛笉璧凤紝璇ヨ褰曚俊鎭笉瀛樺湪锛�"); + } + LoginUserInfo loginUserInfo = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal(); + if(loginUserInfo == null){ + loginUserInfo = platform.getLoginUserInfo(); + } + Platform update = new Platform(); + update.setId(model.getId()); + update.setEditDate(new Date()); + update.setEditor(loginUserInfo.getId()); + update.setStatus(platform.getStatus()); + platformMapper.updateById(update); + } + + @Override public void updateByIdInBatch(List<Platform> platforms) { if (CollectionUtils.isEmpty(platforms)) { return; @@ -87,9 +119,13 @@ @Override public PageData<Platform> findPage(PageWrap<Platform> pageWrap) { IPage<Platform> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); - QueryWrapper<Platform> queryWrapper = new QueryWrapper<>(); + MPJLambdaWrapper<Platform> queryWrapper = new MPJLambdaWrapper<>(); + queryWrapper.selectAll(Platform.class) + .selectAs(PlatformGroup::getName,Platform::getGroupName) + .leftJoin(PlatformGroup.class,PlatformGroup::getId,Platform::getGroupId); Utils.MP.blankToNull(pageWrap.getModel()); - queryWrapper.lambda() + pageWrap.getModel().setIsdeleted(Constants.ZERO); + queryWrapper .eq(pageWrap.getModel().getId() != null, Platform::getId, pageWrap.getModel().getId()) .eq(pageWrap.getModel().getCreator() != null, Platform::getCreator, pageWrap.getModel().getCreator()) .ge(pageWrap.getModel().getCreateDate() != null, Platform::getCreateDate, Utils.Date.getStart(pageWrap.getModel().getCreateDate())) @@ -98,7 +134,7 @@ .ge(pageWrap.getModel().getEditDate() != null, Platform::getEditDate, Utils.Date.getStart(pageWrap.getModel().getEditDate())) .le(pageWrap.getModel().getEditDate() != null, Platform::getEditDate, Utils.Date.getEnd(pageWrap.getModel().getEditDate())) .eq(pageWrap.getModel().getIsdeleted() != null, Platform::getIsdeleted, pageWrap.getModel().getIsdeleted()) - .eq(pageWrap.getModel().getName() != null, Platform::getName, pageWrap.getModel().getName()) + .like(pageWrap.getModel().getName() != null, Platform::getName, pageWrap.getModel().getName()) .eq(pageWrap.getModel().getRemark() != null, Platform::getRemark, pageWrap.getModel().getRemark()) .eq(pageWrap.getModel().getStatus() != null, Platform::getStatus, pageWrap.getModel().getStatus()) .eq(pageWrap.getModel().getSortnum() != null, Platform::getSortnum, pageWrap.getModel().getSortnum()) @@ -106,7 +142,6 @@ .eq(pageWrap.getModel().getStartTime() != null, Platform::getStartTime, pageWrap.getModel().getStartTime()) .eq(pageWrap.getModel().getEndTime() != null, Platform::getEndTime, pageWrap.getModel().getEndTime()) .eq(pageWrap.getModel().getWorkingNum() != null, Platform::getWorkingNum, pageWrap.getModel().getWorkingNum()) - .eq(pageWrap.getModel().getAlermTime() != null, Platform::getAlermTime, pageWrap.getModel().getAlermTime()) .ge(pageWrap.getModel().getLastEventTime() != null, Platform::getLastEventTime, Utils.Date.getStart(pageWrap.getModel().getLastEventTime())) .le(pageWrap.getModel().getLastEventTime() != null, Platform::getLastEventTime, Utils.Date.getEnd(pageWrap.getModel().getLastEventTime())) .eq(pageWrap.getModel().getDeviceNames() != null, Platform::getDeviceNames, pageWrap.getModel().getDeviceNames()) @@ -117,8 +152,7 @@ .eq(pageWrap.getModel().getYpos() != null, Platform::getYpos, pageWrap.getModel().getYpos()) .eq(pageWrap.getModel().getWidth() != null, Platform::getWidth, pageWrap.getModel().getWidth()) .eq(pageWrap.getModel().getHeight() != null, Platform::getHeight, pageWrap.getModel().getHeight()) - .eq(pageWrap.getModel().getAngle() != null, Platform::getAngle, pageWrap.getModel().getAngle()) - ; + .eq(pageWrap.getModel().getAngle() != null, Platform::getAngle, pageWrap.getModel().getAngle()); for(PageWrap.SortData sortData: pageWrap.getSorts()) { if (sortData.getDirection().equalsIgnoreCase(PageWrap.DESC)) { queryWrapper.orderByDesc(sortData.getProperty()); @@ -126,7 +160,7 @@ queryWrapper.orderByAsc(sortData.getProperty()); } } - return PageData.from(platformMapper.selectPage(page, queryWrapper)); + return PageData.from(platformMapper.selectJoinPage(page,Platform.class, queryWrapper)); } @Override @@ -134,4 +168,35 @@ QueryWrapper<Platform> wrapper = new QueryWrapper<>(platform); return platformMapper.selectCount(wrapper); } + + + @Override + public PlatformNumByStatusResponse getPlatformNumByStatusResponse(){ + PlatformNumByStatusResponse platformNumByStatusResponse = new PlatformNumByStatusResponse(); + List<Platform> platformList = platformJoinMapper.selectJoinList(Platform.class,new MPJLambdaWrapper<Platform>() + .selectAll(Platform.class) + .select(" ( select count(1) from platform_job pj where t.id = pj.PLATFORM_ID and pj.STATUS = "+Constants.PlatformJobStatus.WORKING.getKey()+" ) as workStatus ") + .eq(Platform::getIsdeleted,Constants.ZERO) + ); + if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(platformList)){ + //鍋滅敤鏁伴噺 + platformNumByStatusResponse.setForbiddenNum( + platformList.stream().filter(i->Constants.equalsInteger(i.getStatus(),Constants.ONE)).collect(Collectors.toList()).size() + ); + //宸ヤ綔鏁伴噺 + platformNumByStatusResponse.setUsingNum( + platformList.stream().filter(i->i.getWorkStatus()>Constants.ZERO).collect(Collectors.toList()).size() + ); + //绌洪棽鏁伴噺 + platformNumByStatusResponse.setIdleNum( + platformList.stream().filter(i->i.getWorkStatus()<=Constants.ZERO).collect(Collectors.toList()).size() + ); + } + return platformNumByStatusResponse; + } + + + + + } -- Gitblit v1.9.3