| | |
| | | import io.swagger.annotations.ApiModelProperty; |
| | | import lombok.Data; |
| | | |
| | | import java.util.List; |
| | | |
| | | @Data |
| | | @ApiModel(value = "运维APP-车辆地图查询参数") |
| | | public class VehicleMapQuery extends BasePage { |
| | |
| | | @ApiModelProperty(value = "运营状态 1运营中 2维修中 3已收车 4车辆异常") |
| | | private String status; |
| | | @ApiModelProperty(value = "围栏id") |
| | | private Long electronicId; |
| | | private String electronicId; |
| | | |
| | | @ApiModelProperty(value = "前端忽略") |
| | | private List<String> statusList; |
| | | @ApiModelProperty(value = "前端忽略") |
| | | private List<String> electronicIdList; |
| | | } |
| | |
| | | @Override |
| | | public PageInfo<XpVehicle> pageList(VehicleMapQuery query) { |
| | | PageInfo<XpVehicle> pageInfo = new PageInfo<>(query.getPageNum(), query.getPageSize()); |
| | | |
| | | if(StringUtils.isNotBlank(query.getStatus())){ |
| | | query.setStatusList(Arrays.asList(query.getStatus().split(","))); |
| | | } |
| | | if(StringUtils.isNotBlank(query.getElectronicId())){ |
| | | query.setElectronicIdList(Arrays.asList(query.getElectronicId().split(","))); |
| | | } |
| | | List<XpVehicle> list = this.baseMapper.pageList(pageInfo, query); |
| | | pageInfo.setRecords(list); |
| | | return pageInfo; |
| | |
| | | <if test="query.plateNumber != null and query.plateNumber != ''"> |
| | | AND plate_number LIKE CONCAT('%', #{query.plateNumber}, '%') |
| | | </if> |
| | | <if test="query.status != null"> |
| | | AND status = #{query.status} |
| | | <if test="query.statusList != null and query.statusList.size()>0"> |
| | | AND status in |
| | | <foreach item="item" collection="query.statusList" separator="," open="(" close=")"> |
| | | #{item} |
| | | </foreach> |
| | | </if> |
| | | <if test="query.electronicId != null"> |
| | | AND electronic_id = #{query.electronicId} |
| | | AND electronic_id in |
| | | <foreach item="item" collection="query.electronicIdList" separator="," open="(" close=")"> |
| | | #{item} |
| | | </foreach> |
| | | </if> |
| | | AND is_deleted = 0 |
| | | </where> |