-
pom
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.5.5</version>
</dependency>
<dependency>
<groupId>com.github.xiaoymin</groupId>
<artifactId>knife4j-openapi3-spring-boot-starter</artifactId>
<version>4.1.0</version>
</dependency>
<dependency>
<groupId>org.springdoc</groupId>
<artifactId>springdoc-openapi-ui</artifactId>
<version>1.6.15</version>
</dependency>
<dependency>
<groupId>com.github.yulichang</groupId>
<artifactId>mybatis-plus-join-boot-starter</artifactId>
<version>1.4.11</version>
</dependency>
-
controller
/**
* @Description 卡口管理
* @Author wpz
* @Date 2024/06/21 14:04
*/
@Slf4j
@Validated
@RestController
@RequestMapping("/control/checkpoint")
@Tag(name = "卡口管理")
public class ControlCheckpointController {
@Resource
private CheckpointService checkpointService;
@Resource
private SyncService syncService;
@GetMapping("/page")
@Operation(summary = "分页获取卡口管理")
public CommonResult<PageResult<ControlCheckpoint>> page(@ParameterObject @Valid ControlCheckpointPageReqVO reqVO) {
return checkpointService.pageCheckpoint(reqVO);
}
}
-
service
package com.zygh.investigation.control.service.control;
import cn.hutool.core.bean.BeanUtil;
import cn.hutool.core.collection.CollUtil;
import cn.hutool.core.util.StrUtil;
import com.alibaba.excel.EasyExcel;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.github.yulichang.toolkit.JoinWrappers;
import com.github.yulichang.wrapper.MPJLambdaWrapper;
import com.zygh.investigation.control.common.constant.IcsConstants;
import com.zygh.investigation.control.common.pojo.CommonResult;
import com.zygh.investigation.control.common.pojo.PageResult;
import com.zygh.investigation.control.config.mybatis.handler.CheckpointExcelListener;
import com.zygh.investigation.control.dao.control.CheckpointMapper;
import com.zygh.investigation.control.dao.control.ControlGroupEquipmentMapper;
import com.zygh.investigation.control.dao.control.ControlLawEnforceStationMapper;
import com.zygh.investigation.control.dao.control.EmsEquipmentCheckpointMapper;
import com.zygh.investigation.control.dao.control.SsoProjectInfoMapper;
import com.zygh.investigation.control.dto.vehicle.control.CheckpointExcelDTO;
import com.zygh.investigation.control.entity.control.ControlCheckpoint;
import com.zygh.investigation.control.entity.control.ControlGroupEquipment;
import com.zygh.investigation.control.entity.control.ControlStationEquipment;
import com.zygh.investigation.control.entity.control.EmsEquipmentCheckpoint;
import com.zygh.investigation.control.entity.sso.User;
import com.zygh.investigation.control.service.sso.PermissionService;
import com.zygh.investigation.control.vo.control.ControlCheckpointAllVO;
import com.zygh.investigation.control.vo.control.ControlCheckpointPageReqVO;
import com.zygh.investigation.control.vo.control.ControlCheckpointVO;
import lombok.extern.slf4j.Slf4j;
import org.springframework.stereotype.Service;
import org.springframework.web.multipart.MultipartFile;
import javax.annotation.Resource;
import java.io.IOException;
import java.util.Comparator;
import java.util.List;
import java.util.Objects;
import java.util.stream.Collectors;
/**
* @Description 卡口管理
* @Author wpz
* @Date 2024/06/21 14:06
*/
@Slf4j
@Service
public class CheckpointService extends ServiceImpl<CheckpointMapper, ControlCheckpoint> {
@Resource
private PermissionService permissionService;
@Resource
private CheckpointMapper checkpointMapper;
@Resource
private SsoProjectInfoMapper ssoProjectInfoMapper;
@Resource
private EmsEquipmentCheckpointMapper emsEquipmentCheckpointMapper;
@Resource
private StationEquipmentService stationEquipmentService;
@Resource
private ControlLawEnforceStationMapper controlLawEnforceStationMapper;
@Resource
private CheckpointGroupEquipmentService checkpointGroupEquipmentService;
@Resource
private ControlGroupEquipmentMapper controlGroupEquipmentMapper;
@Resource
private SyncService syncService;
/**
* 分页获取卡口管理
*
* @param reqVO 分页请求
* @return 分页结果
*/
public CommonResult<PageResult<ControlCheckpoint>> pageCheckpoint(ControlCheckpointPageReqVO reqVO) {
List<Integer> projectIdList = CollUtil.newArrayList();
if (Objects.nonNull(reqVO.getProjectId())) {
projectIdList = ssoProjectInfoMapper.getSonIds(reqVO.getProjectId());
}
PageResult<ControlCheckpoint> pageResult = new PageResult<>();
MPJLambdaWrapper<ControlCheckpoint> wrapper = JoinWrappers.lambda(ControlCheckpoint.class)
.selectAll()
.selectAs(EmsEquipmentCheckpoint::getAssetParentName, ControlCheckpoint::getAssetParentName)
.selectAs(EmsEquipmentCheckpoint::getAssetChildName, ControlCheckpoint::getAssetChildName)
.selectAs(EmsEquipmentCheckpoint::getProjectName, ControlCheckpoint::getProjectName)
.selectAs(EmsEquipmentCheckpoint::getName, ControlCheckpoint::getName)
.innerJoin(EmsEquipmentCheckpoint.class, EmsEquipmentCheckpoint::getCode, ControlCheckpoint::getCode)
.orderByDesc(ControlCheckpoint::getId);
if (Objects.nonNull(reqVO.getProjectId())) {
wrapper.in(EmsEquipmentCheckpoint::getProjectId, projectIdList);
}
if (Objects.nonNull(reqVO.getAssetParent())) {
wrapper.eq(EmsEquipmentCheckpoint::getAssetParent, reqVO.getAssetParent());
}
if (Objects.nonNull(reqVO.getAssetChild())) {
wrapper.eq(EmsEquipmentCheckpoint::getAssetChild, reqVO.getAssetChild());
}
if (Objects.nonNull(reqVO.getStatus())) {
wrapper.eq(ControlCheckpoint::getStatus, reqVO.getStatus());
}
if (StrUtil.isNotBlank(reqVO.getKeyword())) {
wrapper.and(e -> e.like(ControlCheckpoint::getCode, reqVO.getKeyword())
.or().like(EmsEquipmentCheckpoint::getName, reqVO.getKeyword()));
}
Page<ControlCheckpoint> page = this.page(new Page<>(reqVO.getPageNo(), reqVO.getPageSize()), wrapper);
pageResult.setList(page.getRecords());
pageResult.setTotal(page.getTotal());
return CommonResult.success(pageResult);
}
}
ControlCheckpointPageReqVO--- 请求参数
package com.zygh.investigation.control.vo.control;
import com.zygh.investigation.control.common.pojo.PageParam;
import io.swagger.v3.oas.annotations.media.Schema;
import lombok.Data;
import lombok.EqualsAndHashCode;
/**
* @Description 卡口管理分页请求VO
* @Author wpz
* @Date 2024/06/22 11:51
*/
@EqualsAndHashCode(callSuper = true)
@Data
@Schema(description = "卡口管理分页请求VO")
public class ControlCheckpointPageReqVO extends PageParam {
/**
* 名称,编号模糊搜索
*/
@Schema(description = "名称,编号模糊搜索")
private String keyword;
/**
* 项目ID
*/
@Schema(description = "项目ID")
private Integer projectId;
/**
* 资产大类Id
*/
@Schema(description = "资产大类Id")
private Integer assetParent;
/**
* 资产小类Id
*/
@Schema(description = "资产小类Id")
private Integer assetChild;
/**
* 状态:0-启用;1-禁用
*/
@Schema(description = "状态:0-启用;1-禁用")
private Integer status;
}
PageParam
package com.zygh.investigation.control.common.pojo;
import io.swagger.v3.oas.annotations.media.Schema;
import lombok.Data;
import javax.validation.constraints.Max;
import javax.validation.constraints.Min;
import javax.validation.constraints.NotNull;
import java.io.Serializable;
@Schema(description="分页参数")
@Data
public class PageParam implements Serializable {
private static final Integer PAGE_NO = 1;
private static final Integer PAGE_SIZE = 10;
@Schema(description = "页码,从 1 开始", requiredMode = Schema.RequiredMode.REQUIRED)
@NotNull(message = "页码不能为空")
@Min(value = 1, message = "页码最小值为 1")
private Integer pageNo = PAGE_NO;
@Schema(description = "每页条数,最大值为 100", requiredMode = Schema.RequiredMode.REQUIRED)
@NotNull(message = "每页条数不能为空")
@Min(value = 1, message = "每页条数最小值为 1")
@Max(value = 100, message = "每页条数最大值为 100")
private Integer pageSize = PAGE_SIZE;
}
-
PageResult---响应信息
package com.zygh.investigation.control.common.pojo;
import io.swagger.v3.oas.annotations.media.Schema;
import lombok.Data;
import java.io.Serializable;
import java.util.ArrayList;
import java.util.List;
/**
* @author liubh
*/
@Schema(description = "分页结果")
@Data
public final class PageResult<T> implements Serializable {
@Schema(description = "数据", requiredMode = Schema.RequiredMode.REQUIRED)
private List<T> list;
@Schema(description = "总量", requiredMode = Schema.RequiredMode.REQUIRED)
private Long total;
public PageResult() {
}
public PageResult(List<T> list, Long total) {
this.list = list;
this.total = total;
}
public PageResult(Long total) {
this.list = new ArrayList<>();
this.total = total;
}
public static <T> PageResult<T> empty() {
return new PageResult<>(0L);
}
public static <T> PageResult<T> empty(Long total) {
return new PageResult<>(total);
}
}
-
ControlCheckpoint
package com.zygh.investigation.control.entity.control;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import com.zygh.investigation.control.config.mybatis.dataobject.BaseDO;
import io.swagger.v3.oas.annotations.media.Schema;
import lombok.Data;
import lombok.EqualsAndHashCode;
import lombok.experimental.Accessors;
/**
* 卡口管理表
*
* @author admin
* @TableName control_checkpoint
*/
@EqualsAndHashCode(callSuper = true)
@TableName(value = "control_checkpoint")
@Data
@Accessors(chain = true)
public class ControlCheckpoint extends BaseDO {
/**
* id
*/
@Schema(description = "id")
@TableId(type = IdType.AUTO)
private Long id;
/**
* 设备编号
*/
@Schema(description = "设备编号")
private String code;
/**
* 状态:0-启用;1-禁用
*/
@Schema(description = "状态:0-启用;1-禁用")
private Integer status;
/**
* 部门id
*/
@Schema(description = "部门id", hidden = true)
private String deptId;
/**
* 添加人id
*/
@Schema(description = "添加人id", hidden = true)
private Long createUser;
/**
* 添加人名称
*/
@Schema(description = "添加人名称")
private String createUserName;
/**
* 类型:0-新增;1-导入
*/
@Schema(description = "类型:0-新增;1-导入", hidden = true)
private Integer type;
@Schema(description = "项目名称")
@TableField(exist = false)
private String projectName;
@Schema(description = "资产大类名称")
@TableField(exist = false)
private String assetParentName;
@Schema(description = "资产小类名称")
@TableField(exist = false)
private String assetChildName;
@Schema(description = "设备名称")
@TableField(exist = false)
private String name;
/**
* 站id
*/
@Schema(description = "站id")
@TableField(exist = false)
private Long stationId;
/**
* 组id
*/
@Schema(description = "组id")
@TableField(exist = false)
private Long groupId;
}
-
BaseDO
package com.zygh.investigation.control.config.mybatis.dataobject;
import com.baomidou.mybatisplus.annotation.FieldFill;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.extension.activerecord.Model;
import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.v3.oas.annotations.media.Schema;
import lombok.Data;
import java.time.LocalDateTime;
/**
* 基础实体对象
*
* @author zygh
*/
@Data
public abstract class BaseDO extends Model<BaseDO> {
/**
* 创建时间
*/
@TableField(fill = FieldFill.INSERT)
@Schema(description = "创建时间")
@JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
private LocalDateTime gmtCreate;
/**
* 最后更新时间
*/
@TableField(fill = FieldFill.INSERT_UPDATE)
@Schema(description = "更新时间", hidden = true)
@JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
private LocalDateTime gmtUpdate;
}