增加相机俯仰差值参照点业务

‘liusuyi’

2024-03-30 ad29370708776906f971ca863481c31d59ccf8f0

增加相机俯仰差值参照点业务

 ard-work/src/main/java/com/ruoyi/device/camera/controller/ArdCameraPitchPointController.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,113 @@
package com.ruoyi.device.camera.controller;

import java.util.List;
import javax.servlet.http.HttpServletResponse;

import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.PutMapping;
import org.springframework.web.bind.annotation.DeleteMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import com.ruoyi.common.annotation.Log;
import com.ruoyi.common.core.controller.BaseController;
import com.ruoyi.common.core.domain.AjaxResult;
import com.ruoyi.common.enums.BusinessType;
import com.ruoyi.device.camera.domain.ArdCameraPitchPoint;
import com.ruoyi.device.camera.service.IArdCameraPitchPointService;
import com.ruoyi.common.utils.poi.ExcelUtil;
import com.ruoyi.common.core.page.TableDataInfo;

/**
 * ç›¸æœºä¿¯ä»°å·®å€¼å‚照点Controller
 *
 * @author ard
 * @date 2024-03-30
 */
@RestController
@RequestMapping("/camera/point")
@Api(tags = "相机俯仰差值参照点管理")
public class ArdCameraPitchPointController extends BaseController
{
    @Autowired
    private IArdCameraPitchPointService ardCameraPitchPointService;

    /**
     * æŸ¥è¯¢ç›¸æœºä¿¯ä»°å·®å€¼å‚照点列表
     */
    @ApiOperation("查询相机俯仰差值参照点列表")
    @PreAuthorize("@ss.hasPermi('camera:point:list')")
    @GetMapping("/list")
    public TableDataInfo list(ArdCameraPitchPoint ardCameraPitchPoint)
    {
        startPage();
        List<ArdCameraPitchPoint> list = ardCameraPitchPointService.selectArdCameraPitchPointList(ardCameraPitchPoint);
        return getDataTable(list);
    }

    /**
     * å¯¼å‡ºç›¸æœºä¿¯ä»°å·®å€¼å‚照点列表
     */
    @PreAuthorize("@ss.hasPermi('camera:point:export')")
    @Log(title = "相机俯仰差值参照点", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, ArdCameraPitchPoint ardCameraPitchPoint)
    {
        List<ArdCameraPitchPoint> list = ardCameraPitchPointService.selectArdCameraPitchPointList(ardCameraPitchPoint);
        ExcelUtil<ArdCameraPitchPoint> util = new ExcelUtil<ArdCameraPitchPoint>(ArdCameraPitchPoint.class);
        util.exportExcel(response, list, "相机俯仰差值参照点数据");
    }

    /**
     * èŽ·å–相机俯仰差值参照点详细信息
     */
    @ApiOperation("获取相机俯仰差值参照点详细信息")
    @PreAuthorize("@ss.hasPermi('camera:point:query')")
    @GetMapping(value = "/{updateBy}")
    public AjaxResult getInfo(@PathVariable("updateBy") String updateBy)
    {
        return success(ardCameraPitchPointService.selectArdCameraPitchPointByUpdateBy(updateBy));
    }

    /**
     * æ–°å¢žç›¸æœºä¿¯ä»°å·®å€¼å‚照点
     */
    @ApiOperation("新增相机俯仰差值参照点")
    @PreAuthorize("@ss.hasPermi('camera:point:add')")
    @Log(title = "相机俯仰差值参照点", businessType = BusinessType.INSERT)
    @PostMapping
    public AjaxResult add(@RequestBody ArdCameraPitchPoint ardCameraPitchPoint)
    {
        return toAjax(ardCameraPitchPointService.insertArdCameraPitchPoint(ardCameraPitchPoint));
    }

    /**
     * ä¿®æ”¹ç›¸æœºä¿¯ä»°å·®å€¼å‚照点
     */
    @ApiOperation("修改相机俯仰差值参照点")
    @PreAuthorize("@ss.hasPermi('camera:point:edit')")
    @Log(title = "相机俯仰差值参照点", businessType = BusinessType.UPDATE)
    @PutMapping
    public AjaxResult edit(@RequestBody ArdCameraPitchPoint ardCameraPitchPoint)
    {
        return toAjax(ardCameraPitchPointService.updateArdCameraPitchPoint(ardCameraPitchPoint));
    }

    /**
     * åˆ é™¤ç›¸æœºä¿¯ä»°å·®å€¼å‚照点
     */
    @ApiOperation("删除相机俯仰差值参照点")
    @PreAuthorize("@ss.hasPermi('camera:point:remove')")
    @Log(title = "相机俯仰差值参照点", businessType = BusinessType.DELETE)
    @DeleteMapping("/{updateBys}")
    public AjaxResult remove(@PathVariable String[] updateBys)
    {
        return toAjax(ardCameraPitchPointService.deleteArdCameraPitchPointByUpdateBys(updateBys));
    }
}

 ard-work/src/main/java/com/ruoyi/device/camera/domain/ArdCameraPitchPoint.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,111 @@
package com.ruoyi.device.camera.domain;

import org.apache.commons.lang3.builder.ToStringBuilder;
import org.apache.commons.lang3.builder.ToStringStyle;
import com.ruoyi.common.annotation.Excel;
import com.ruoyi.common.core.domain.BaseEntity;

/**
 * ç›¸æœºä¿¯ä»°å·®å€¼å‚照点对象 ard_camera_pitch_point
 * 
 * @author ard
 * @date 2024-03-30
 */
public class ArdCameraPitchPoint extends BaseEntity
{
    private static final long serialVersionUID = 1L;

    /** id */
    private String id;

    /** ç»åº¦ */
    @Excel(name = "经度")
    private String longitude;

    /** çº¬åº¦ */
    @Excel(name = "纬度")
    private String latitude;

    /** é«˜å±‚ */
    @Excel(name = "高层")
    private String altitude;

    /** å·®å€¼ */
    @Excel(name = "差值")
    private String difference;

    /** ç›¸æœºid */
    @Excel(name = "相机id")
    private String cameraId;

    public void setId(String id) 
    {
        this.id = id;
    }

    public String getId() 
    {
        return id;
    }
    public void setLongitude(String longitude) 
    {
        this.longitude = longitude;
    }

    public String getLongitude() 
    {
        return longitude;
    }
    public void setLatitude(String latitude) 
    {
        this.latitude = latitude;
    }

    public String getLatitude() 
    {
        return latitude;
    }
    public void setAltitude(String altitude) 
    {
        this.altitude = altitude;
    }

    public String getAltitude() 
    {
        return altitude;
    }
    public void setDifference(String difference) 
    {
        this.difference = difference;
    }

    public String getDifference() 
    {
        return difference;
    }
    public void setCameraId(String cameraId) 
    {
        this.cameraId = cameraId;
    }

    public String getCameraId() 
    {
        return cameraId;
    }

    @Override
    public String toString() {
        return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)
            .append("updateBy", getUpdateBy())
            .append("updateTime", getUpdateTime())
            .append("id", getId())
            .append("longitude", getLongitude())
            .append("latitude", getLatitude())
            .append("altitude", getAltitude())
            .append("difference", getDifference())
            .append("cameraId", getCameraId())
            .append("createBy", getCreateBy())
            .append("createTime", getCreateTime())
            .toString();
    }
}

 ard-work/src/main/java/com/ruoyi/device/camera/mapper/ArdCameraPitchPointMapper.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,61 @@
package com.ruoyi.device.camera.mapper;

import java.util.List;
import com.ruoyi.device.camera.domain.ArdCameraPitchPoint;

/**
 * ç›¸æœºä¿¯ä»°å·®å€¼å‚照点Mapper接口
 * 
 * @author ard
 * @date 2024-03-30
 */
public interface ArdCameraPitchPointMapper 
{
    /**
     * æŸ¥è¯¢ç›¸æœºä¿¯ä»°å·®å€¼å‚照点
     * 
     * @param updateBy ç›¸æœºä¿¯ä»°å·®å€¼å‚照点主键
     * @return ç›¸æœºä¿¯ä»°å·®å€¼å‚照点
     */
    public ArdCameraPitchPoint selectArdCameraPitchPointByUpdateBy(String updateBy);

    /**
     * æŸ¥è¯¢ç›¸æœºä¿¯ä»°å·®å€¼å‚照点列表
     * 
     * @param ardCameraPitchPoint ç›¸æœºä¿¯ä»°å·®å€¼å‚照点
     * @return ç›¸æœºä¿¯ä»°å·®å€¼å‚照点集合
     */
    public List<ArdCameraPitchPoint> selectArdCameraPitchPointList(ArdCameraPitchPoint ardCameraPitchPoint);

    /**
     * æ–°å¢žç›¸æœºä¿¯ä»°å·®å€¼å‚照点
     * 
     * @param ardCameraPitchPoint ç›¸æœºä¿¯ä»°å·®å€¼å‚照点
     * @return ç»“æžœ
     */
    public int insertArdCameraPitchPoint(ArdCameraPitchPoint ardCameraPitchPoint);

    /**
     * ä¿®æ”¹ç›¸æœºä¿¯ä»°å·®å€¼å‚照点
     * 
     * @param ardCameraPitchPoint ç›¸æœºä¿¯ä»°å·®å€¼å‚照点
     * @return ç»“æžœ
     */
    public int updateArdCameraPitchPoint(ArdCameraPitchPoint ardCameraPitchPoint);

    /**
     * åˆ é™¤ç›¸æœºä¿¯ä»°å·®å€¼å‚照点
     * 
     * @param updateBy ç›¸æœºä¿¯ä»°å·®å€¼å‚照点主键
     * @return ç»“æžœ
     */
    public int deleteArdCameraPitchPointByUpdateBy(String updateBy);

    /**
     * æ‰¹é‡åˆ é™¤ç›¸æœºä¿¯ä»°å·®å€¼å‚照点
     * 
     * @param updateBys éœ€è¦åˆ é™¤çš„数据主键集合
     * @return ç»“æžœ
     */
    public int deleteArdCameraPitchPointByUpdateBys(String[] updateBys);
}

 ard-work/src/main/java/com/ruoyi/device/camera/service/IArdCameraPitchPointService.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,61 @@
package com.ruoyi.device.camera.service;

import java.util.List;
import com.ruoyi.device.camera.domain.ArdCameraPitchPoint;

/**
 * ç›¸æœºä¿¯ä»°å·®å€¼å‚照点Service接口
 * 
 * @author ard
 * @date 2024-03-30
 */
public interface IArdCameraPitchPointService 
{
    /**
     * æŸ¥è¯¢ç›¸æœºä¿¯ä»°å·®å€¼å‚照点
     * 
     * @param updateBy ç›¸æœºä¿¯ä»°å·®å€¼å‚照点主键
     * @return ç›¸æœºä¿¯ä»°å·®å€¼å‚照点
     */
    public ArdCameraPitchPoint selectArdCameraPitchPointByUpdateBy(String updateBy);

    /**
     * æŸ¥è¯¢ç›¸æœºä¿¯ä»°å·®å€¼å‚照点列表
     * 
     * @param ardCameraPitchPoint ç›¸æœºä¿¯ä»°å·®å€¼å‚照点
     * @return ç›¸æœºä¿¯ä»°å·®å€¼å‚照点集合
     */
    public List<ArdCameraPitchPoint> selectArdCameraPitchPointList(ArdCameraPitchPoint ardCameraPitchPoint);

    /**
     * æ–°å¢žç›¸æœºä¿¯ä»°å·®å€¼å‚照点
     * 
     * @param ardCameraPitchPoint ç›¸æœºä¿¯ä»°å·®å€¼å‚照点
     * @return ç»“æžœ
     */
    public int insertArdCameraPitchPoint(ArdCameraPitchPoint ardCameraPitchPoint);

    /**
     * ä¿®æ”¹ç›¸æœºä¿¯ä»°å·®å€¼å‚照点
     * 
     * @param ardCameraPitchPoint ç›¸æœºä¿¯ä»°å·®å€¼å‚照点
     * @return ç»“æžœ
     */
    public int updateArdCameraPitchPoint(ArdCameraPitchPoint ardCameraPitchPoint);

    /**
     * æ‰¹é‡åˆ é™¤ç›¸æœºä¿¯ä»°å·®å€¼å‚照点
     * 
     * @param updateBys éœ€è¦åˆ é™¤çš„相机俯仰差值参照点主键集合
     * @return ç»“æžœ
     */
    public int deleteArdCameraPitchPointByUpdateBys(String[] updateBys);

    /**
     * åˆ é™¤ç›¸æœºä¿¯ä»°å·®å€¼å‚照点信息
     * 
     * @param updateBy ç›¸æœºä¿¯ä»°å·®å€¼å‚照点主键
     * @return ç»“æžœ
     */
    public int deleteArdCameraPitchPointByUpdateBy(String updateBy);
}

 ard-work/src/main/java/com/ruoyi/device/camera/service/impl/ArdCameraPitchPointServiceImpl.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,97 @@
package com.ruoyi.device.camera.service.impl;

import java.util.List;
        import com.ruoyi.common.utils.DateUtils;

import com.ruoyi.common.utils.uuid.IdUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.ArrayList;
import com.ruoyi.common.utils.StringUtils;
import com.ruoyi.common.utils.SecurityUtils;
import com.ruoyi.device.camera.mapper.ArdCameraPitchPointMapper;
import com.ruoyi.device.camera.domain.ArdCameraPitchPoint;
import com.ruoyi.device.camera.service.IArdCameraPitchPointService;

/**
 * ç›¸æœºä¿¯ä»°å·®å€¼å‚照点Service业务层处理
 *
 * @author ard
 * @date 2024-03-30
 */
@Service
public class ArdCameraPitchPointServiceImpl implements IArdCameraPitchPointService {
    @Autowired
    private ArdCameraPitchPointMapper ardCameraPitchPointMapper;

    /**
     * æŸ¥è¯¢ç›¸æœºä¿¯ä»°å·®å€¼å‚照点
     *
     * @param updateBy ç›¸æœºä¿¯ä»°å·®å€¼å‚照点主键
     * @return ç›¸æœºä¿¯ä»°å·®å€¼å‚照点
     */
    @Override
    public ArdCameraPitchPoint selectArdCameraPitchPointByUpdateBy(String updateBy) {
        return ardCameraPitchPointMapper.selectArdCameraPitchPointByUpdateBy(updateBy);
    }

    /**
     * æŸ¥è¯¢ç›¸æœºä¿¯ä»°å·®å€¼å‚照点列表
     *
     * @param ardCameraPitchPoint ç›¸æœºä¿¯ä»°å·®å€¼å‚照点
     * @return ç›¸æœºä¿¯ä»°å·®å€¼å‚照点
     */
    @Override
    public List<ArdCameraPitchPoint> selectArdCameraPitchPointList(ArdCameraPitchPoint ardCameraPitchPoint) {
        return ardCameraPitchPointMapper.selectArdCameraPitchPointList(ardCameraPitchPoint);
    }

    /**
     * æ–°å¢žç›¸æœºä¿¯ä»°å·®å€¼å‚照点
     *
     * @param ardCameraPitchPoint ç›¸æœºä¿¯ä»°å·®å€¼å‚照点
     * @return ç»“æžœ
     */
    @Override
    public int insertArdCameraPitchPoint(ArdCameraPitchPoint ardCameraPitchPoint) {
                ardCameraPitchPoint.setId(IdUtils.simpleUUID());
                ardCameraPitchPoint.setCreateBy(SecurityUtils.getUsername());
                ardCameraPitchPoint.setCreateTime(DateUtils.getNowDate());
            return ardCameraPitchPointMapper.insertArdCameraPitchPoint(ardCameraPitchPoint);
    }

    /**
     * ä¿®æ”¹ç›¸æœºä¿¯ä»°å·®å€¼å‚照点
     *
     * @param ardCameraPitchPoint ç›¸æœºä¿¯ä»°å·®å€¼å‚照点
     * @return ç»“æžœ
     */
    @Override
    public int updateArdCameraPitchPoint(ArdCameraPitchPoint ardCameraPitchPoint) {
                ardCameraPitchPoint.setUpdateBy(SecurityUtils.getUsername());
                ardCameraPitchPoint.setUpdateTime(DateUtils.getNowDate());
        return ardCameraPitchPointMapper.updateArdCameraPitchPoint(ardCameraPitchPoint);
    }

    /**
     * æ‰¹é‡åˆ é™¤ç›¸æœºä¿¯ä»°å·®å€¼å‚照点
     *
     * @param updateBys éœ€è¦åˆ é™¤çš„相机俯仰差值参照点主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteArdCameraPitchPointByUpdateBys(String[] updateBys) {
        return ardCameraPitchPointMapper.deleteArdCameraPitchPointByUpdateBys(updateBys);
    }

    /**
     * åˆ é™¤ç›¸æœºä¿¯ä»°å·®å€¼å‚照点信息
     *
     * @param updateBy ç›¸æœºä¿¯ä»°å·®å€¼å‚照点主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteArdCameraPitchPointByUpdateBy(String updateBy) {
        return ardCameraPitchPointMapper.deleteArdCameraPitchPointByUpdateBy(updateBy);
    }
}

 ard-work/src/main/resources/mapper/device/ArdCameraPitchPointMapper.xml

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,90 @@
<?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.ruoyi.device.camera.mapper.ArdCameraPitchPointMapper">
    
    <resultMap type="ArdCameraPitchPoint" id="ArdCameraPitchPointResult">
        <result property="updateBy"    column="update_by"    />
        <result property="updateTime"    column="update_time"    />
        <result property="id"    column="id"    />
        <result property="longitude"    column="longitude"    />
        <result property="latitude"    column="latitude"    />
        <result property="altitude"    column="altitude"    />
        <result property="difference"    column="difference"    />
        <result property="cameraId"    column="camera_id"    />
        <result property="createBy"    column="create_by"    />
        <result property="createTime"    column="create_time"    />
    </resultMap>

    <sql id="selectArdCameraPitchPointVo">
        select update_by, update_time, id, longitude, latitude, altitude, difference, camera_id, create_by, create_time from ard_camera_pitch_point
    </sql>

    <select id="selectArdCameraPitchPointList" parameterType="ArdCameraPitchPoint" resultMap="ArdCameraPitchPointResult">
        <include refid="selectArdCameraPitchPointVo"/>
        <where>  
            <if test="cameraId != null  and cameraId != ''"> and camera_id = #{cameraId}</if>
        </where>
    </select>
    
    <select id="selectArdCameraPitchPointByUpdateBy" parameterType="String" resultMap="ArdCameraPitchPointResult">
        <include refid="selectArdCameraPitchPointVo"/>
        where update_by = #{updateBy}
    </select>
        
    <insert id="insertArdCameraPitchPoint" parameterType="ArdCameraPitchPoint">
        insert into ard_camera_pitch_point
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="updateBy != null">update_by,</if>
            <if test="updateTime != null">update_time,</if>
            <if test="id != null">id,</if>
            <if test="longitude != null">longitude,</if>
            <if test="latitude != null">latitude,</if>
            <if test="altitude != null">altitude,</if>
            <if test="difference != null">difference,</if>
            <if test="cameraId != null">camera_id,</if>
            <if test="createBy != null">create_by,</if>
            <if test="createTime != null">create_time,</if>
         </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="updateBy != null">#{updateBy},</if>
            <if test="updateTime != null">#{updateTime},</if>
            <if test="id != null">#{id},</if>
            <if test="longitude != null">#{longitude},</if>
            <if test="latitude != null">#{latitude},</if>
            <if test="altitude != null">#{altitude},</if>
            <if test="difference != null">#{difference},</if>
            <if test="cameraId != null">#{cameraId},</if>
            <if test="createBy != null">#{createBy},</if>
            <if test="createTime != null">#{createTime},</if>
         </trim>
    </insert>

    <update id="updateArdCameraPitchPoint" parameterType="ArdCameraPitchPoint">
        update ard_camera_pitch_point
        <trim prefix="SET" suffixOverrides=",">
            <if test="updateTime != null">update_time = #{updateTime},</if>
            <if test="id != null">id = #{id},</if>
            <if test="longitude != null">longitude = #{longitude},</if>
            <if test="latitude != null">latitude = #{latitude},</if>
            <if test="altitude != null">altitude = #{altitude},</if>
            <if test="difference != null">difference = #{difference},</if>
            <if test="cameraId != null">camera_id = #{cameraId},</if>
            <if test="createBy != null">create_by = #{createBy},</if>
            <if test="createTime != null">create_time = #{createTime},</if>
        </trim>
        where update_by = #{updateBy}
    </update>

    <delete id="deleteArdCameraPitchPointByUpdateBy" parameterType="String">
        delete from ard_camera_pitch_point where update_by = #{updateBy}
    </delete>

    <delete id="deleteArdCameraPitchPointByUpdateBys" parameterType="String">
        delete from ard_camera_pitch_point where update_by in 
        <foreach item="updateBy" collection="array" open="(" separator="," close=")">
            #{updateBy}
        </foreach>
    </delete>
</mapper>