灯杆倾侧

zhanzhiqin

2021-12-10 14d1e461cb8db01ba924df254d241fa1c309653e

灯杆倾侧

 dao/src/main/java/com/sandu/ximon/dao/domain/ForHelp.java

@@ -14,7 +14,7 @@
    //所属人
    private Long userId;
    //灯杆ID
    private int lightPoleId;
    private String lightPoleId;
    //灯杆名称
    private String lightPoleName;
    //状态

 dao/src/main/java/com/sandu/ximon/dao/domain/LightPoleHeeling.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,39 @@
package com.sandu.ximon.dao.domain;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import lombok.Data;

import java.io.Serializable;
import java.time.LocalDateTime;

@Data
/**
 * ç¯æ†å€¾ä¾§
 */
public class LightPoleHeeling implements Serializable {
    @TableId(type = IdType.AUTO)
    private Long id;
    //所属人
    private Long userId;
    //告警号
    private String warningNumber;
    //灯杆ID
    private String lightPoleId;
    //灯杆名称
    private String lightPoleName;
    //告警等级
    private String warningLevel;
    //Xè½´
    private int theXAxis;
    //Yè½´
    private int theYAxis;
    //Zè½´
    private int theZAxis;
    //处理状态
    // 1:已处理；0：未处理
    private int processingState;
    //告警时间
    private LocalDateTime createTime;

}

 dao/src/main/java/com/sandu/ximon/dao/mapper/LightPoleHeelingMapper.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,9 @@
package com.sandu.ximon.dao.mapper;

import com.sandu.common.domain.BaseMapper;
import com.sandu.ximon.dao.domain.LightPoleHeeling;
import org.apache.ibatis.annotations.Mapper;

@Mapper
public interface LightPoleHeelingMapper extends BaseMapper<LightPoleHeeling> {
}

 dao/src/main/resources/mapper/ForHelpMapper.xml

@@ -7,7 +7,7 @@
    <resultMap id="BaseResultMap" type="com.sandu.ximon.dao.domain.ForHelp">
        <id property="id" column="id" jdbcType="BIGINT"/>
        <result property="userId" column="user_id" jdbcType="BIGINT"/>
        <result property="lightPoleId" column="light_pole_id" jdbcType="INTEGER"/>
        <result property="lightPoleId" column="light_pole_id" jdbcType="VARCHAR"/>
        <result property="lightPoleName" column="light_pole_name" jdbcType="VARCHAR"/>
        <result property="state" column="state" jdbcType="INTEGER"/>
        <result property="createTime" column="create_time" jdbcType="TIMESTAMP"/>

 dao/src/main/resources/mapper/LightPoleHeelingMapper.xml

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,19 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.sandu.ximon.dao.mapper.LightPoleHeelingMapper">
    <resultMap id="BaseResultMap" type="com.sandu.ximon.dao.domain.LightPoleHeeling">
        <id property="id" column="id" jdbcType="BIGINT"/>
        <result property="userId" column="user_id" jdbcType="BIGINT"/>
        <result property="warningNumber" column="warning_number" jdbcType="VARCHAR"/>
        <result property="lightPoleId" column="light_pole_id" jdbcType="VARCHAR"/>
        <result property="lightPoleName" column="light_pole_name" jdbcType="VARCHAR"/>
        <result property="warningLevel" column="warning_level" jdbcType="VARCHAR"/>
        <result property="theXAxis" column="the_x_axis" jdbcType="INTEGER"/>
        <result property="theYAxis" column="the_y_axis" jdbcType="INTEGER"/>
        <result property="theZAxis" column="the_z_axis" jdbcType="INTEGER"/>
        <result property="processingState" column="processing_state" jdbcType="INTEGER"/>
        <result property="createTime" column="create_time" jdbcType="TIMESTAMP"/>
    </resultMap>
</mapper>

 ximon-admin/src/main/java/com/sandu/ximon/admin/controller/LightPoleHeelingController.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,38 @@
package com.sandu.ximon.admin.controller;

import com.sandu.common.domain.ResponseVO;
import com.sandu.common.util.ResponseUtil;
import com.sandu.ximon.admin.service.LightPoleHeelingService;
import com.sandu.ximon.dao.domain.ForHelp;
import com.sandu.ximon.dao.domain.LightPoleHeeling;
import lombok.AllArgsConstructor;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;

@RestController
@AllArgsConstructor
@RequestMapping("/v1/admin/LightPoleHeeling")
public class LightPoleHeelingController {
    private final LightPoleHeelingService lightPoleHeelingService;

    @GetMapping
    public ResponseVO<Object> listLightPoleHeeling() {
        List<LightPoleHeeling> list = lightPoleHeelingService.listLightPoleHeeling();
        return ResponseUtil.successPage(list);
    }

    /**
     * æ¨¡ç³ŠæŸ¥è¯¢
     *
     * @return
     */
    @GetMapping("/listLightPoleHeelingByKeyword/{keyword}")
    public ResponseVO<Object> listLightPoleHeelingByKeyword(@PathVariable String keyword) {
        List<LightPoleHeeling> list = lightPoleHeelingService.listLightPoleHeelingByKeyword(keyword);
        return ResponseUtil.successPage(list);
    }
}

 ximon-admin/src/main/java/com/sandu/ximon/admin/service/LightPoleHeelingService.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,48 @@
package com.sandu.ximon.admin.service;

import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.sandu.common.service.impl.BaseServiceImpl;
import com.sandu.ximon.dao.domain.AirData;
import com.sandu.ximon.dao.domain.ForHelp;
import com.sandu.ximon.dao.domain.LightPoleHeeling;
import com.sandu.ximon.dao.mapper.LightPoleHeelingMapper;
import lombok.AllArgsConstructor;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
@AllArgsConstructor
public class LightPoleHeelingService extends BaseServiceImpl<LightPoleHeelingMapper, LightPoleHeeling> {
    /**
     * æŸ¥è¯¢å…¨éƒ¨ç¯æ†å€¾ä¾§å‘Šè­¦
     */
    public List<LightPoleHeeling> listLightPoleHeeling() {
        LambdaQueryWrapper<LightPoleHeeling> wrapper = Wrappers.lambdaQuery(LightPoleHeeling.class);
        List<LightPoleHeeling> list = list(wrapper);

        return list;
    }

    /**
     * æ¨¡ç³ŠæŸ¥è¯¢
     */
    public List<LightPoleHeeling> listLightPoleHeelingByKeyword(String keyword) {

        LambdaQueryWrapper<LightPoleHeeling> wrapper = Wrappers.lambdaQuery(LightPoleHeeling.class);
        if (keyword != null) {
            wrapper.like(LightPoleHeeling::getLightPoleName, keyword).or(
                    lambdaQueryWrapper -> {
                        lambdaQueryWrapper.like(LightPoleHeeling::getLightPoleId, keyword);
                    }
            ).or(
                    lambdaQueryWrapper -> {
                        lambdaQueryWrapper.like(LightPoleHeeling::getWarningNumber, keyword);
                    }
            );
        }
        List<LightPoleHeeling> forHelpList = list(wrapper);
        return forHelpList;
    }
}