server/system_service/src/main/java/com/doumee/dao/system/MultifileMapper.java
@@ -2,6 +2,7 @@ import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.doumee.dao.system.model.Multifile; import com.github.yulichang.base.MPJBaseMapper; import java.util.List; @@ -9,6 +10,6 @@ * @author æ±è¹è¹ * @date 2023/05/04 18:18 */ public interface MultifileMapper extends BaseMapper<Multifile> { public interface MultifileMapper extends MPJBaseMapper<Multifile> { } server/system_service/src/main/java/com/doumee/dao/system/model/Multifile.java
@@ -79,6 +79,9 @@ @TableField(exist = false) private String fileurlFull; @ApiModelProperty(value = "å建人åç§°") @TableField(exist = false) private String userName; @ApiModelProperty(value = "å ç½æä»¶å°å") @TableField(exist = false) server/visits/dmvisit_admin/src/main/java/com/doumee/cloud/admin/YwContractCloudController.java
@@ -87,6 +87,15 @@ return ApiResponse.success(ywContractService.findPage(pageWrap)); } @ApiOperation("å表") @PostMapping("/list") @CloudRequiredPermission("business:ywcontract:query") public ApiResponse<List<YwContract>> list (@RequestBody YwContract model,@RequestHeader(Constants.HEADER_USER_TOKEN) String token) { return ApiResponse.success(ywContractService.findList(model)); } @ApiOperation("导åºExcel") @PostMapping("/exportExcel") @CloudRequiredPermission("business:ywcontract:exportExcel") server/visits/dmvisit_admin/src/main/java/com/doumee/cloud/admin/YwContractRoomCloudController.java
@@ -93,6 +93,17 @@ pageWrap.setLoginUserInfo(this.getLoginUser(token)); return ApiResponse.success(ywContractRoomService.findList(pageWrap)); } @ApiOperation("æ¥è¯¢ååæè´¦åæ¿é´ä¿¡æ¯") @PostMapping("/getContractRoom") @CloudRequiredPermission("business:ywcontractroom:query") public ApiResponse<List<YwContractRoom>> getContractRoom (@RequestBody YwContractRoom pageWrap, @RequestHeader(Constants.HEADER_USER_TOKEN) String token) { pageWrap.setLoginUserInfo(this.getLoginUser(token)); return ApiResponse.success(ywContractRoomService.getContractRoom(pageWrap)); } @ApiOperation("æ ¹æ®IDæ¥è¯¢") @GetMapping("/{id}") @CloudRequiredPermission("business:ywcontractroom:query") server/visits/dmvisit_admin/src/main/java/com/doumee/cloud/admin/YwProjectCloudController.java
@@ -9,6 +9,7 @@ import com.doumee.core.utils.Constants; import com.doumee.dao.business.model.YwProject; import com.doumee.dao.business.model.YwRoom; import com.doumee.dao.business.vo.ProjectDataVO; import com.doumee.service.business.YwProjectService; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; @@ -85,6 +86,16 @@ return ApiResponse.success(ywProjectService.findPage(pageWrap)); } @ApiOperation("é¡¹ç®æ ") @PostMapping("/tree") @CloudRequiredPermission("business:ywproject:query") public ApiResponse<List<ProjectDataVO>> tree (@RequestHeader(Constants.HEADER_USER_TOKEN) String token) { return ApiResponse.success(ywProjectService.projectTree()); } @ApiOperation("导åºExcel") @PostMapping("/exportExcel") @CloudRequiredPermission("business:ywproject:exportExcel") server/visits/dmvisit_service/src/main/java/com/doumee/dao/business/model/YwDevice.java
@@ -68,7 +68,7 @@ @ApiModelProperty(value = "设å¤åå·", example = "1") @ExcelColumn(name="设å¤åå·") private Integer modelNo; private String modelNo; @ApiModelProperty(value = "æå±åç±»ç¼ç ï¼ç®¡çcategoryï¼", example = "1") @ExcelColumn(name="æå±åç±»ç¼ç ï¼ç®¡çcategoryï¼") @@ -80,8 +80,7 @@ @ApiModelProperty(value = "ä¾åºå") @ExcelColumn(name="ä¾åºå") @JsonFormat(pattern = "yyyy-MM-dd") private Date company; private String supplier; @ApiModelProperty(value = "è¿ç»´å 容") @ExcelColumn(name="è¿ç»´å 容") @@ -103,7 +102,16 @@ @TableField(exist = false) private String realName; @ApiModelProperty(value = "éä»¶ä¿¡æ¯") @ApiModelProperty(value = "å¾çå°å") @TableField(exist = false) private Multifile multifile; private String fileUrl; @ApiModelProperty(value = "å¾çå°åå ¨è·¯å¾") @TableField(exist = false) private String fileFullUrl; // @ApiModelProperty(value = "éä»¶ä¿¡æ¯") // @TableField(exist = false) // private Multifile multifile; } server/visits/dmvisit_service/src/main/java/com/doumee/dao/business/model/YwDeviceRecord.java
@@ -33,14 +33,14 @@ @ApiModelProperty(value = "å建æ¶é´") @ExcelColumn(name="å建æ¶é´",index = 5, dateFormat = "yyyy-MM-dd HH:mm:ss") @JsonFormat(pattern = "yyyy-MM-dd") @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") private Date createDate; @ApiModelProperty(value = "æ´æ°äººç¼ç ", example = "1") private Integer editor; @ApiModelProperty(value = "æ´æ°æ¶é´") @JsonFormat(pattern = "yyyy-MM-dd") @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") private Date editDate; @ApiModelProperty(value = "æ¯å¦å é¤0å¦ 1æ¯", example = "1") server/visits/dmvisit_service/src/main/java/com/doumee/dao/business/model/YwLinePoint.java
@@ -73,5 +73,7 @@ @TableField(exist = false) private String pointName; @ApiModelProperty(value = "å·¡æ£ç¹ç¼ç ") @TableField(exist = false) private String code; } server/visits/dmvisit_service/src/main/java/com/doumee/dao/business/model/YwPatrolPoint.java
@@ -107,9 +107,13 @@ @TableField(exist = false) private String deviceName; @ApiModelProperty(value = "éä»¶ä¿¡æ¯") @ApiModelProperty(value = "éä»¶å°å") @TableField(exist = false) private Multifile multifile; private String fileUrl; @ApiModelProperty(value = "éä»¶å ¨è·¯å¾å°å") @TableField(exist = false) private String fileFullUrl; @ApiModelProperty(value = "è¿æ»¤æ°æ®") @TableField(exist = false) server/visits/dmvisit_service/src/main/java/com/doumee/dao/business/vo/ProjectDataVO.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,33 @@ package com.doumee.dao.business.vo; import com.doumee.dao.business.model.Approve; import io.swagger.annotations.ApiModelProperty; import lombok.Data; import java.util.List; /** * Created by IntelliJ IDEA. * * @Author : Rk * @create 2024/5/23 14:56 */ @Data public class ProjectDataVO { @ApiModelProperty(value = "ä¸å¡ä¸»é®") private Integer id; @ApiModelProperty(value = "ä¸å¡åç§°") private String name; @ApiModelProperty(value = "ç¶çº§ä¸»é®") private Integer pId; @ApiModelProperty(value = "级å«") private Integer lv; @ApiModelProperty(value = "åéæ°æ®") private List<ProjectDataVO> projectDataVOList; } server/visits/dmvisit_service/src/main/java/com/doumee/dao/business/vo/ProjectTree.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,93 @@ package com.doumee.dao.business.vo; import com.doumee.config.DataSyncConfig; import com.doumee.core.utils.Constants; import org.apache.commons.lang3.StringUtils; import java.util.ArrayList; import java.util.List; import java.util.Objects; /** * Created by IntelliJ IDEA. * * @Author : Rk * @create 2023/7/13 10:40 */ public class ProjectTree { // ä¿ååä¸æå»ºæ å½¢çæææ°æ®ï¼éå¸¸æ°æ®åºæ¥è¯¢ç»æï¼ public List<ProjectDataVO> nodeList = new ArrayList<>(); /** * æé æ¹æ³ * @param nodeList å°æ°æ®éåèµå¼ç»nodeListï¼å³æææ°æ®ä½ä¸ºææèç¹ã */ public ProjectTree(List<ProjectDataVO> nodeList){ this.nodeList = nodeList; } /** * è·åéæå»ºçæææ ¹èç¹ï¼é¡¶çº§èç¹ï¼ "0" * @return æææ ¹èç¹Listéå */ public List<ProjectDataVO> getRootNode(){ // ä¿åæææ ¹èç¹ï¼æææ ¹èç¹çæ°æ®ï¼ List<ProjectDataVO> rootNodeList = new ArrayList<>(); // treeNodeï¼æ¥è¯¢åºçæ¯ä¸æ¡æ°æ®ï¼èç¹ï¼ for (ProjectDataVO treeNode : nodeList){ if (Objects.isNull(treeNode.getPId()) && Constants.equalsInteger(treeNode.getLv(),Constants.ZERO)) { // æ¯ï¼æ·»å rootNodeList.add(treeNode); } } return rootNodeList; } /** * æ ¹æ®æ¯ä¸ä¸ªé¡¶çº§èç¹ï¼æ ¹èç¹ï¼è¿è¡æå»ºæ å½¢ç»æ * @return æå»ºæ´æ£µæ */ public List<ProjectDataVO> buildTree(){ // treeNodesï¼ä¿åä¸ä¸ªé¡¶çº§èç¹ææå»ºåºæ¥ç宿´æ å½¢ List<ProjectDataVO> treeNodes = new ArrayList<ProjectDataVO>(); // getRootNode()ï¼è·åææçæ ¹èç¹ for (ProjectDataVO treeRootNode : getRootNode()) { // å°é¡¶çº§èç¹è¿è¡æå»ºåæ treeRootNode = buildChildTree(treeRootNode); // 宿ä¸ä¸ªé¡¶çº§èç¹ææå»ºçæ å½¢ï¼å¢å è¿æ¥ treeNodes.add(treeRootNode); } return treeNodes; } /** * éå½-----æå»ºåæ å½¢ç»æ * @param pNode æ ¹èç¹ï¼é¡¶çº§èç¹ï¼ * @return æ´æ£µæ */ public ProjectDataVO buildChildTree(ProjectDataVO pNode){ List<ProjectDataVO> childTree = new ArrayList<ProjectDataVO>(); // nodeListï¼ææèç¹éåï¼æææ°æ®ï¼ for (ProjectDataVO treeNode : nodeList) { // 夿å½åèç¹çç¶èç¹IDæ¯å¦çäºæ ¹èç¹çIDï¼å³å½åèç¹ä¸ºå ¶ä¸çåèç¹ if (!Objects.isNull(treeNode.getPId()) && Constants.equalsInteger(treeNode.getPId(),pNode.getId()) && Constants.equalsInteger((treeNode.getLv() - 1 ),pNode.getLv()) ) { // åéå½è¿è¡å¤æå½åèç¹çæ åµï¼è°ç¨èªèº«æ¹æ³ childTree.add(buildChildTree(treeNode)); } } // for循ç¯ç»æï¼å³èç¹ä¸æ²¡æä»»ä½èç¹ï¼æ å½¢æå»ºç»æï¼è®¾ç½®æ ç»æ pNode.setProjectDataVOList(childTree); return pNode; } } server/visits/dmvisit_service/src/main/java/com/doumee/service/business/YwContractRoomService.java
@@ -79,6 +79,9 @@ * @return List<YwContractRoom> */ List<YwContractRoom> findList(YwContractRoom ywContractRoom); List<YwContractRoom> getContractRoom(YwContractRoom ywContractRoom); /** * å页æ¥è¯¢ server/visits/dmvisit_service/src/main/java/com/doumee/service/business/YwProjectService.java
@@ -4,6 +4,8 @@ import com.doumee.core.model.PageData; import com.doumee.core.model.PageWrap; import com.doumee.dao.business.model.YwProject; import com.doumee.dao.business.vo.ProjectDataVO; import java.util.List; /** @@ -95,4 +97,7 @@ * @return long */ long count(YwProject ywProject); List<ProjectDataVO> projectTree(); } server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwContractBillServiceImpl.java
@@ -12,6 +12,7 @@ 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.YwContractBillService; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper; @@ -194,7 +195,10 @@ )); //éä»¶æ°æ® List<Multifile> multifileList = multifileMapper.selectList(new QueryWrapper<Multifile>().lambda() List<Multifile> multifileList = multifileMapper.selectJoinList(Multifile.class,new MPJLambdaWrapper<Multifile>() .selectAll(Multifile.class) .selectAs(SystemUser::getRealname,Multifile::getUserName) .leftJoin(SystemUser.class,SystemUser::getId,Multifile::getCreator) .eq(Multifile::getObjId,id) .eq(Multifile::getObjType,Constants.MultiFile.FN_CONTRACT_BILL_FILE.getKey())); if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(multifileList)){ server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwContractRoomServiceImpl.java
@@ -5,17 +5,19 @@ import com.doumee.core.model.PageWrap; import com.doumee.core.utils.Utils; import com.doumee.dao.business.YwContractRoomMapper; import com.doumee.dao.business.model.YwContractRoom; import com.doumee.dao.business.model.*; import com.doumee.service.business.YwContractRoomService; 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.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.util.CollectionUtils; import java.util.List; import java.util.Objects; /** * è¿ç»´ååæ¿æºå ³èä¿¡æ¯è¡¨Serviceå®ç° @@ -84,7 +86,31 @@ QueryWrapper<YwContractRoom> wrapper = new QueryWrapper<>(ywContractRoom); return ywContractRoomMapper.selectList(wrapper); } @Override public List<YwContractRoom> getContractRoom(YwContractRoom ywContractRoom){ List<YwContractRoom> ywContractRoomList = ywContractRoomMapper.selectJoinList(YwContractRoom.class,new MPJLambdaWrapper<YwContractRoom>() .selectAll(YwContractRoom.class) .selectAs(YwProject::getName, YwRoom::getProjectName) .selectAs(YwFloor::getName,YwRoom::getFloorName) .selectAs(YwBuilding::getName,YwRoom::getBuildingName) .selectAs(YwRoom::getName,YwContractRoom::getRoomName) .leftJoin(YwRoom.class,YwRoom::getId,YwContractRoom::getRoomId) .leftJoin(YwFloor.class,YwFloor::getId,YwRoom::getFloor) .leftJoin(YwProject.class,YwProject::getId,YwRoom::getProjectId) .leftJoin(YwBuilding.class,YwBuilding::getId,YwRoom::getBuildingId) .eq(Objects.nonNull(ywContractRoom.getType()),YwContractRoom::getType,ywContractRoom.getType()) .eq(Objects.nonNull(ywContractRoom.getContractId()),YwContractRoom::getContractId,ywContractRoom.getContractId())) ; return ywContractRoomList; } @Override public PageData<YwContractRoom> findPage(PageWrap<YwContractRoom> pageWrap) { IPage<YwContractRoom> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwContractServiceImpl.java
@@ -1026,7 +1026,9 @@ @Override public List<YwContract> findList(YwContract ywContract) { QueryWrapper<YwContract> wrapper = new QueryWrapper<>(ywContract); QueryWrapper<YwContract> wrapper = new QueryWrapper<>(); wrapper.lambda().eq(YwContract::getIsdeleted,Constants.ZERO); wrapper.lambda().in(YwContract::getStatus,Constants.ZERO,Constants.ONE,Constants.TWO); return ywContractMapper.selectList(wrapper); } server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwDeviceServiceImpl.java
@@ -64,27 +64,20 @@ if(ywDeviceMapper.selectCount(new QueryWrapper<YwDevice>().lambda().eq(YwDevice::getIsdeleted,Constants.ZERO).eq(YwDevice::getCode,ywDevice.getCode()))>Constants.ZERO){ throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"设å¤ç¼å·éå¤!"); } // if(StringUtils.isBlank(ywDevice.getCode())){ // String code = this.getMaxAutoMaticDeviceCode(); // while (ywDeviceMapper.selectCount(new QueryWrapper<YwDevice>().lambda().eq(YwDevice::getIsdeleted,Constants.ZERO).eq(YwDevice::getCode,code))>Constants.ZERO){ // code = this.getMaxAutoMaticDeviceCode(); // } // ywDevice.setCode(code); // }else{ // // } ywDevice.setCreateDate(new Date()); ywDevice.setCreator(loginUserInfo.getId()); ywDevice.setIsdeleted(Constants.ZERO); ywDeviceMapper.insert(ywDevice); if(Objects.nonNull(ywDevice.getMultifile())){ ywDevice.getMultifile().setCreator(loginUserInfo.getId()); ywDevice.getMultifile().setCreateDate(new Date()); ywDevice.getMultifile().setIsdeleted(Constants.ZERO); ywDevice.getMultifile().setObjType(Constants.MultiFile.FN_DEVICE_FILE.getKey()); ywDevice.getMultifile().setObjId(ywDevice.getId()); multifileMapper.insert(ywDevice.getMultifile()); if(Objects.nonNull(ywDevice.getFileUrl())){ Multifile multifile = new Multifile(); multifile.setCreator(loginUserInfo.getId()); multifile.setCreateDate(new Date()); multifile.setIsdeleted(Constants.ZERO); multifile.setObjType(Constants.MultiFile.FN_DEVICE_FILE.getKey()); multifile.setObjId(ywDevice.getId()); multifile.setFileurl(ywDevice.getFileUrl()); multifileMapper.insert(multifile); } return ywDevice.getId(); @@ -135,13 +128,15 @@ .eq(Multifile::getObjId,ywDevice.getId()) .eq(Multifile::getObjType,Constants.MultiFile.FN_DEVICE_FILE.getKey()) ); if(Objects.nonNull(ywDevice.getMultifile())){ ywDevice.getMultifile().setCreator(loginUserInfo.getId()); ywDevice.getMultifile().setCreateDate(new Date()); ywDevice.getMultifile().setIsdeleted(Constants.ZERO); ywDevice.getMultifile().setObjType(Constants.MultiFile.FN_DEVICE_FILE.getKey()); ywDevice.getMultifile().setObjId(ywDevice.getId()); multifileMapper.insert(ywDevice.getMultifile()); if(Objects.nonNull(ywDevice.getFileUrl())){ Multifile multifile = new Multifile(); multifile.setCreator(loginUserInfo.getId()); multifile.setCreateDate(new Date()); multifile.setIsdeleted(Constants.ZERO); multifile.setObjType(Constants.MultiFile.FN_DEVICE_FILE.getKey()); multifile.setObjId(ywDevice.getId()); multifile.setFileurl(ywDevice.getFileUrl()); multifileMapper.insert(multifile); } @@ -169,8 +164,7 @@ if(Objects.nonNull(multifile)){ String path = systemDictDataBiz.queryByCode(Constants.FTP,Constants.FTP_RESOURCE_PATH).getCode() +systemDictDataBiz.queryByCode(Constants.FTP,Constants.YW_DEVICE).getCode(); multifile.setFileurlFull(path + multifile.getFileurl()); ywDevice.setMultifile(multifile); ywDevice.setFileFullUrl(path + multifile.getFileurl()); } return ywDevice; } server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwPatrolLineServiceImpl.java
@@ -68,7 +68,7 @@ ywLinePoint.setCreateDate(new Date()); ywLinePoint.setCreator(loginUserInfo.getId()); ywLinePoint.setIsdeleted(Constants.ZERO); ywLinePoint.setLineId(ywLinePoint.getId()); ywLinePoint.setLineId(ywPatrolLine.getId()); } ywLinePointMapper.insert(ywLinePointList); return ywPatrolLine.getId(); @@ -117,7 +117,7 @@ ){ throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"å·¡æ£ç¹é ç½®é误"); } ywLinePoint.setLineId(ywLinePoint.getId()); ywLinePoint.setLineId(ywPatrolLine.getId()); ywLinePoint.setCreateDate(new Date()); ywLinePoint.setCreator(loginUserInfo.getId()); ywLinePoint.setIsdeleted(Constants.ZERO); @@ -148,7 +148,8 @@ List<YwLinePoint> ywLinePointList = ywLinePointMapper.selectJoinList(YwLinePoint.class,new MPJLambdaWrapper<YwLinePoint>() .selectAll(YwLinePoint.class) .selectAs(YwPatrolPoint::getName,YwLinePoint::getPointName) .leftJoin(YwPatrolLine.class,YwPatrolLine::getId,YwLinePoint::getPointId) .selectAs(YwPatrolPoint::getCode,YwLinePoint::getCode) .leftJoin(YwPatrolPoint.class,YwPatrolPoint::getId,YwLinePoint::getPointId) .eq(YwLinePoint::getLineId,id) .orderByAsc(YwLinePoint::getSortnum) ); server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwPatrolPointServiceImpl.java
@@ -65,13 +65,15 @@ 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()); if(Objects.nonNull(ywPatrolPoint.getFileUrl())){ Multifile multifile = new Multifile(); multifile.setCreator(loginUserInfo.getId()); multifile.setCreateDate(new Date()); multifile.setIsdeleted(Constants.ZERO); multifile.setObjType(Constants.MultiFile.FN_PATROL_POINT_FILE.getKey()); multifile.setObjId(ywPatrolPoint.getId()); multifile.setFileurl(ywPatrolPoint.getFileUrl()); multifileMapper.insert(multifile); } return ywPatrolPoint.getId(); @@ -123,13 +125,15 @@ .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()); if(Objects.nonNull(ywPatrolPoint.getFileUrl())){ Multifile multifile = new Multifile(); multifile.setCreator(loginUserInfo.getId()); multifile.setCreateDate(new Date()); multifile.setIsdeleted(Constants.ZERO); multifile.setObjType(Constants.MultiFile.FN_PATROL_POINT_FILE.getKey()); multifile.setObjId(ywPatrolPoint.getId()); multifile.setFileurl(ywPatrolPoint.getFileUrl()); multifileMapper.insert(multifile); } } @@ -157,8 +161,7 @@ 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); ywPatrolPoint.setFileFullUrl(path + multifile.getFileurl()); } return ywPatrolPoint; } server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwPatrolSchemeServiceImpl.java
@@ -26,6 +26,7 @@ import org.springframework.beans.factory.annotation.Autowired; import org.springframework.data.redis.core.RedisTemplate; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import org.springframework.util.CollectionUtils; import java.util.*; @@ -51,6 +52,7 @@ private RedisTemplate<String, Object> redisTemplate; @Override @Transactional(rollbackFor = {Exception.class,BusinessException.class}) public Integer create(YwPatrolScheme ywPatrolScheme) { if(Objects.isNull(ywPatrolScheme) || StringUtils.isBlank(ywPatrolScheme.getTitle()) @@ -122,9 +124,10 @@ //æ¯ææ ¹æ®æ¥æçæ æ ¹æ®æ¥æè·åæ¯åªå¤© List<String> days = Arrays.asList(ywPatrolScheme.getCircleDays().split(",")); String dayStr = DateUtil.getFomartDate(schemeDate,"dd"); if(Objects.isNull(days.stream().filter(i->StringUtils.equals(i,dayStr)).findFirst().get())){ Optional<String> optional = days.stream().filter(i->StringUtils.equals(i,dayStr)).findAny(); if(Objects.isNull(optional)){ return; }; } } String schemeDateStr = DateUtil.getDate(schemeDate,"yyyy-MM-dd"); //æ¥è¯¢å½å¤©æ¯å¦çæè¿æ°æ® server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwPatrolTaskServiceImpl.java
@@ -121,6 +121,7 @@ YwPatrolTask model = pageWrap.getModel(); queryWrapper.selectAll(YwPatrolTask.class) .selectAs(YwPatrolScheme::getCode,YwPatrolTask::getPlanCode) .selectAs(YwPatrolScheme::getTitle,YwPatrolTask::getPlanTitle) .selectAs(SystemUser::getRealname,YwPatrolTask::getUserName) .leftJoin(SystemUser.class,SystemUser::getId,YwPatrolTask::getDealUserId) .leftJoin(YwPatrolScheme.class,YwPatrolScheme::getId,YwPatrolTask::getSchemeId) server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwProjectServiceImpl.java
@@ -5,18 +5,26 @@ 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.YwFloorMapper; import com.doumee.dao.business.YwProjectMapper; import com.doumee.dao.business.model.Company; import com.doumee.dao.business.model.YwProject; import com.doumee.dao.business.YwRoomMapper; import com.doumee.dao.business.model.*; import com.doumee.dao.business.vo.CompanyTree; import com.doumee.dao.business.vo.ProjectDataVO; import com.doumee.dao.business.vo.ProjectTree; import com.doumee.service.business.YwProjectService; 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.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.util.CollectionUtils; import java.util.ArrayList; import java.util.Date; import java.util.List; @@ -30,6 +38,15 @@ @Autowired private YwProjectMapper ywProjectMapper; @Autowired private YwFloorMapper ywFloorMapper; @Autowired private YwRoomMapper ywRoomMapper; @Autowired private YwBuildingMapper ywBuildingMapper; @Override public Integer create(YwProject model) { @@ -162,4 +179,78 @@ QueryWrapper<YwProject> wrapper = new QueryWrapper<>(ywProject); return ywProjectMapper.selectCount(wrapper); } @Override public List<ProjectDataVO> projectTree(){ List<ProjectDataVO> projectDataVOList = new ArrayList<>(); List<YwProject> ywProjectList = ywProjectMapper.selectList(new QueryWrapper<YwProject>().lambda() .eq(YwProject::getIsdeleted,Constants.ZERO) .eq(YwProject::getStatus,Constants.ZERO) .orderByAsc(YwProject::getSortnum) ); for (YwProject ywProject:ywProjectList) { ProjectDataVO projectDataVO = new ProjectDataVO(); BeanUtils.copyProperties(ywProject,projectDataVO); projectDataVO.setLv(Constants.ZERO); projectDataVOList.add(projectDataVO); } List<YwBuilding> ywBuildingList = ywBuildingMapper.selectList(new QueryWrapper<YwBuilding>().lambda() .eq(YwBuilding::getIsdeleted,Constants.ZERO) .eq(YwBuilding::getStatus,Constants.ZERO) .orderByAsc(YwBuilding::getSortnum) ); for (YwBuilding data:ywBuildingList) { ProjectDataVO projectDataVO = new ProjectDataVO(); BeanUtils.copyProperties(data,projectDataVO); projectDataVO.setPId(data.getProjectId()); projectDataVO.setLv(Constants.ONE); projectDataVOList.add(projectDataVO); } List<YwFloor> ywFloorList = ywFloorMapper.selectList(new QueryWrapper<YwFloor>().lambda() .eq(YwFloor::getIsdeleted,Constants.ZERO) .eq(YwFloor::getStatus,Constants.ZERO) .orderByAsc(YwFloor::getSortnum) ); for (YwFloor data:ywFloorList) { ProjectDataVO projectDataVO = new ProjectDataVO(); BeanUtils.copyProperties(data,projectDataVO); projectDataVO.setPId(data.getBuildingId()); projectDataVO.setLv(Constants.TWO); projectDataVOList.add(projectDataVO); } List<YwRoom> ywRoomList = ywRoomMapper.selectList(new QueryWrapper<YwRoom>().lambda() .eq(YwRoom::getIsdeleted,Constants.ZERO) .eq(YwRoom::getStatus,Constants.ZERO) .orderByAsc(YwRoom::getSortnum) ); for (YwRoom data:ywRoomList) { ProjectDataVO projectDataVO = new ProjectDataVO(); BeanUtils.copyProperties(data,projectDataVO); projectDataVO.setName(data.getCode()); projectDataVO.setPId(data.getFloor()); projectDataVO.setLv(Constants.THREE); projectDataVOList.add(projectDataVO); } ProjectTree treeBuild = new ProjectTree(projectDataVOList); projectDataVOList = treeBuild.buildTree(); return projectDataVOList; } }