server/visits/dmvisit_admin/src/main/java/com/doumee/cloud/openapi/HkOpenApiController.java
@@ -195,4 +195,12 @@ public ApiResponse<List<PlatformWarnEventListResponse>> warningEventList(@RequestBody PlatformWarnEventListRequest param) { return ApiResponse.success(new ArrayList<>()); } @LoginNoRequired @PreventRepeat @ApiOperation("ãæå°ãæå°ç¶æ") @PostMapping("/platform/getStatusList") public ApiResponse<List<PlatformStatusListResponse>> getStatusList() { return ApiResponse.success(platformService.getPlatformStatusList()); } } server/visits/dmvisit_service/src/main/java/com/doumee/dao/business/model/Platform.java
@@ -46,7 +46,6 @@ @ApiModelProperty(value = "æ´æ°æ¶é´") @ExcelColumn(name="æ´æ°æ¶é´") private Date editDate; @ApiModelProperty(value = "æ¯å¦å é¤0å¦ 1æ¯", example = "1") @@ -184,6 +183,10 @@ @TableField(exist = false) private Integer workStatus; @ApiModelProperty(value = "ä½ä¸è½¦è¾è½¦çç §") @TableField(exist = false) private String workCarCode; @ApiModelProperty(value = "æå°ä½ä¸æ°æ®") server/visits/dmvisit_service/src/main/java/com/doumee/dao/openapi/response/PlatformStatusListResponse.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,28 @@ package com.doumee.dao.openapi.response; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; import lombok.Data; import java.util.List; /** * Created by IntelliJ IDEA. * * @Author : Rk * @create 2023/12/7 11:19 */ @Data @ApiModel("ãæå°ãæå°ç¶æ") public class PlatformStatusListResponse { @ApiModelProperty(value = "æå°ID" ) private String platformHkId; @ApiModelProperty(value = "æå°åç§°" ) private String platformName; @ApiModelProperty(value = "车çå·" ) private String carCode; @ApiModelProperty(value = "æå°ç¶æ 0-æ 车 1-æè½¦ 2-è¶ æ¶åé 3-é误åé " ) private Integer status; } server/visits/dmvisit_service/src/main/java/com/doumee/service/business/PlatformService.java
@@ -4,6 +4,7 @@ import com.doumee.core.model.PageWrap; import com.doumee.dao.business.model.Platform; import com.doumee.dao.openapi.response.PlatformNumByStatusResponse; import com.doumee.dao.openapi.response.PlatformStatusListResponse; import java.util.List; @@ -101,4 +102,6 @@ PlatformNumByStatusResponse getPlatformNumByStatusResponse(); List<PlatformStatusListResponse> getPlatformStatusList(); } server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/PlatformServiceImpl.java
@@ -14,6 +14,7 @@ import com.doumee.dao.business.join.PlatformJoinMapper; import com.doumee.dao.business.model.*; import com.doumee.dao.openapi.response.PlatformNumByStatusResponse; import com.doumee.dao.openapi.response.PlatformStatusListResponse; import com.doumee.service.business.PlatformDeviceService; import com.doumee.service.business.PlatformService; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; @@ -333,6 +334,35 @@ @Override public List<PlatformStatusListResponse> getPlatformStatusList(){ 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 ") .select(" ( select pj.CAR_CODE_FRONT from platform_job pj where t.id = pj.PLATFORM_ID and pj.STATUS = "+Constants.PlatformJobStatus.WORKING.getKey()+" limit 1 ) as workCarCode ") .eq(Platform::getIsdeleted,Constants.ZERO) ); List<PlatformStatusListResponse> platformStatusListResponses = new ArrayList<>(); if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(platformList)){ for (Platform platform:platformList) { PlatformStatusListResponse response = new PlatformStatusListResponse(); response.setPlatformHkId(platform.getHkId()); response.setPlatformName(platform.getName()); response.setStatus(platform.getPlatformStatus()); if(Constants.equalsInteger(platform.getPlatformStatus(),Constants.ONE)){ response.setCarCode(platform.getWorkCarCode()); } } } return platformStatusListResponses; } }