卡口过车数据一致性

龚焕茏

2024-03-19 adf588cd4322f705cfa06d87e18a4075709df16f

卡口过车数据一致性

 ycl-pojo/src/main/java/com/ycl/platform/domain/entity/VehicleDataMonitor.java

New file
@@ -0,0 +1,143 @@
package com.ycl.platform.domain.entity;

import annotation.Excel;
import com.baomidou.mybatisplus.annotation.TableLogic;
import com.ycl.system.entity.BaseEntity;
import org.apache.commons.lang3.builder.ToStringBuilder;
import org.apache.commons.lang3.builder.ToStringStyle;

/**
 * 卡口过车数据一致性对象 t_vehicle_data_monitor
 *
 * @author gonghl
 * @date 2024-03-19
 */
public class VehicleDataMonitor extends BaseEntity {
    private static final long serialVersionUID = 1L;

    /**
     * $column.columnComment
     */
    private Integer id;

    /**
     * 地区编码
     */
    private String regionCode;

    /**
     * 卡口名称
     */
    @Excel(name = "卡口名称")
    private String bayonetName;

    /**
     * 卡口编号
     */
    @Excel(name = "卡口编号")
    private String bayonetNumber;

    /**
     * 过车数据量
     */
    @Excel(name = "过车数据量")
    private Integer vehicleDataNumber;

    /**
     * 不唯一数据
     */
    @Excel(name = "不唯一数据 ")
    private Integer notUniqueData;

    /**
     * 不唯一数据量
     */
    @Excel(name = "不唯一数据量")
    private Integer notUniqueDataNumber;

    /**
     * 逻辑删除
     */
    @TableLogic
    private String deleted;

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

    public Integer getId() {
        return id;
    }

    public void setRegionCode(String regionCode) {
        this.regionCode = regionCode;
    }

    public String getRegionCode() {
        return regionCode;
    }

    public void setBayonetName(String bayonetName) {
        this.bayonetName = bayonetName;
    }

    public String getBayonetName() {
        return bayonetName;
    }

    public void setBayonetNumber(String bayonetNumber) {
        this.bayonetNumber = bayonetNumber;
    }

    public String getBayonetNumber() {
        return bayonetNumber;
    }

    public void setVehicleDataNumber(Integer vehicleDataNumber) {
        this.vehicleDataNumber = vehicleDataNumber;
    }

    public Integer getVehicleDataNumber() {
        return vehicleDataNumber;
    }

    public void setNotUniqueData(Integer notUniqueData) {
        this.notUniqueData = notUniqueData;
    }

    public Integer getNotUniqueData() {
        return notUniqueData;
    }

    public void setNotUniqueDataNumber(Integer notUniqueDataNumber) {
        this.notUniqueDataNumber = notUniqueDataNumber;
    }

    public Integer getNotUniqueDataNumber() {
        return notUniqueDataNumber;
    }

    public void setDeleted(String deleted) {
        this.deleted = deleted;
    }

    public String getDeleted() {
        return deleted;
    }

    @Override
    public String toString() {
        return new ToStringBuilder(this, ToStringStyle.MULTI_LINE_STYLE)
                .append("id", getId())
                .append("regionCode", getRegionCode())
                .append("bayonetName", getBayonetName())
                .append("bayonetNumber", getBayonetNumber())
                .append("vehicleDataNumber", getVehicleDataNumber())
                .append("notUniqueData", getNotUniqueData())
                .append("notUniqueDataNumber", getNotUniqueDataNumber())
                .append("createTime", getCreateTime())
                .append("updateTime", getUpdateTime())
                .append("deleted", getDeleted())
                .toString();
    }
}

 ycl-server/src/main/java/com/ycl/platform/controller/VehicleDataMonitorController.java

New file
@@ -0,0 +1,91 @@
package com.ycl.platform.controller;

import annotation.Log;
import com.ycl.platform.domain.entity.VehicleDataMonitor;
import com.ycl.platform.service.IVehicleDataMonitorService;
import com.ycl.system.AjaxResult;
import com.ycl.system.controller.BaseController;
import com.ycl.system.page.TableDataInfo;
import com.ycl.utils.poi.ExcelUtil;
import enumeration.BusinessType;
import jakarta.servlet.http.HttpServletResponse;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.web.bind.annotation.*;

import java.util.List;

/**
 * 卡口过车数据一致性Controller
 *
 * @author gonghl
 * @date 2024-03-19
 */
@RestController
@RequestMapping("/platform/platform")
public class VehicleDataMonitorController extends BaseController {
    @Autowired
    private IVehicleDataMonitorService vehicleDataMonitorService;

    /**
     * 查询卡口过车数据一致性列表
     */
    @PreAuthorize("@ss.hasPermi('platform:platform:list')")
    @GetMapping("/list")
    public TableDataInfo list(VehicleDataMonitor vehicleDataMonitor) {
        startPage();
        List<VehicleDataMonitor> list = vehicleDataMonitorService.selectVehicleDataMonitorList(vehicleDataMonitor);
        return getDataTable(list);
    }

    /**
     * 导出卡口过车数据一致性列表
     */
    @PreAuthorize("@ss.hasPermi('platform:platform:export')")
    @Log(title = "卡口过车数据一致性", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, VehicleDataMonitor vehicleDataMonitor) {
        List<VehicleDataMonitor> list = vehicleDataMonitorService.selectVehicleDataMonitorList(vehicleDataMonitor);
        ExcelUtil<VehicleDataMonitor> util = new ExcelUtil<VehicleDataMonitor>(VehicleDataMonitor.class);
        util.exportExcel(response, list, "卡口过车数据一致性数据");
    }

    /**
     * 获取卡口过车数据一致性详细信息
     */
    @PreAuthorize("@ss.hasPermi('platform:platform:query')")
    @GetMapping(value = "/{id}")
    public AjaxResult getInfo(@PathVariable("id") Integer id) {
        return success(vehicleDataMonitorService.selectVehicleDataMonitorById(id));
    }

    /**
     * 新增卡口过车数据一致性
     */
    @PreAuthorize("@ss.hasPermi('platform:platform:add')")
    @Log(title = "卡口过车数据一致性", businessType = BusinessType.INSERT)
    @PostMapping
    public AjaxResult add(@RequestBody VehicleDataMonitor vehicleDataMonitor) {
        return toAjax(vehicleDataMonitorService.insertVehicleDataMonitor(vehicleDataMonitor));
    }

    /**
     * 修改卡口过车数据一致性
     */
    @PreAuthorize("@ss.hasPermi('platform:platform:edit')")
    @Log(title = "卡口过车数据一致性", businessType = BusinessType.UPDATE)
    @PutMapping
    public AjaxResult edit(@RequestBody VehicleDataMonitor vehicleDataMonitor) {
        return toAjax(vehicleDataMonitorService.updateVehicleDataMonitor(vehicleDataMonitor));
    }

    /**
     * 删除卡口过车数据一致性
     */
    @PreAuthorize("@ss.hasPermi('platform:platform:remove')")
    @Log(title = "卡口过车数据一致性", businessType = BusinessType.DELETE)
    @DeleteMapping("/{ids}")
    public AjaxResult remove(@PathVariable Integer[] ids) {
        return toAjax(vehicleDataMonitorService.deleteVehicleDataMonitorByIds(ids));
    }
}

 ycl-server/src/main/java/com/ycl/platform/mapper/VehicleDataMonitorMapper.java

New file
@@ -0,0 +1,62 @@
package com.ycl.platform.mapper;


import com.ycl.platform.domain.entity.VehicleDataMonitor;

import java.util.List;

/**
 * 卡口过车数据一致性Mapper接口
 *
 * @author gonghl
 * @date 2024-03-19
 */
public interface VehicleDataMonitorMapper {
    /**
     * 查询卡口过车数据一致性
     *
     * @param id 卡口过车数据一致性主键
     * @return 卡口过车数据一致性
     */
    public VehicleDataMonitor selectVehicleDataMonitorById(Integer id);

    /**
     * 查询卡口过车数据一致性列表
     *
     * @param vehicleDataMonitor 卡口过车数据一致性
     * @return 卡口过车数据一致性集合
     */
    public List<VehicleDataMonitor> selectVehicleDataMonitorList(VehicleDataMonitor vehicleDataMonitor);

    /**
     * 新增卡口过车数据一致性
     *
     * @param vehicleDataMonitor 卡口过车数据一致性
     * @return 结果
     */
    public int insertVehicleDataMonitor(VehicleDataMonitor vehicleDataMonitor);

    /**
     * 修改卡口过车数据一致性
     *
     * @param vehicleDataMonitor 卡口过车数据一致性
     * @return 结果
     */
    public int updateVehicleDataMonitor(VehicleDataMonitor vehicleDataMonitor);

    /**
     * 删除卡口过车数据一致性
     *
     * @param id 卡口过车数据一致性主键
     * @return 结果
     */
    public int deleteVehicleDataMonitorById(Integer id);

    /**
     * 批量删除卡口过车数据一致性
     *
     * @param ids 需要删除的数据主键集合
     * @return 结果
     */
    public int deleteVehicleDataMonitorByIds(Integer[] ids);
}

 ycl-server/src/main/java/com/ycl/platform/service/IVehicleDataMonitorService.java

New file
@@ -0,0 +1,62 @@
package com.ycl.platform.service;


import com.ycl.platform.domain.entity.VehicleDataMonitor;

import java.util.List;

/**
 * 卡口过车数据一致性Service接口
 *
 * @author gonghl
 * @date 2024-03-19
 */
public interface IVehicleDataMonitorService {
    /**
     * 查询卡口过车数据一致性
     *
     * @param id 卡口过车数据一致性主键
     * @return 卡口过车数据一致性
     */
    public VehicleDataMonitor selectVehicleDataMonitorById(Integer id);

    /**
     * 查询卡口过车数据一致性列表
     *
     * @param vehicleDataMonitor 卡口过车数据一致性
     * @return 卡口过车数据一致性集合
     */
    public List<VehicleDataMonitor> selectVehicleDataMonitorList(VehicleDataMonitor vehicleDataMonitor);

    /**
     * 新增卡口过车数据一致性
     *
     * @param vehicleDataMonitor 卡口过车数据一致性
     * @return 结果
     */
    public int insertVehicleDataMonitor(VehicleDataMonitor vehicleDataMonitor);

    /**
     * 修改卡口过车数据一致性
     *
     * @param vehicleDataMonitor 卡口过车数据一致性
     * @return 结果
     */
    public int updateVehicleDataMonitor(VehicleDataMonitor vehicleDataMonitor);

    /**
     * 批量删除卡口过车数据一致性
     *
     * @param ids 需要删除的卡口过车数据一致性主键集合
     * @return 结果
     */
    public int deleteVehicleDataMonitorByIds(Integer[] ids);

    /**
     * 删除卡口过车数据一致性信息
     *
     * @param id 卡口过车数据一致性主键
     * @return 结果
     */
    public int deleteVehicleDataMonitorById(Integer id);
}

 ycl-server/src/main/java/com/ycl/platform/service/impl/VehicleDataMonitorServiceImpl.java

New file
@@ -0,0 +1,91 @@
package com.ycl.platform.service.impl;

import com.ycl.platform.domain.entity.VehicleDataMonitor;
import com.ycl.platform.mapper.VehicleDataMonitorMapper;
import com.ycl.platform.service.IVehicleDataMonitorService;
import com.ycl.utils.DateUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

/**
 * 卡口过车数据一致性Service业务层处理
 *
 * @author gonghl
 * @date 2024-03-19
 */
@Service
public class VehicleDataMonitorServiceImpl implements IVehicleDataMonitorService {
    @Autowired
    private VehicleDataMonitorMapper vehicleDataMonitorMapper;

    /**
     * 查询卡口过车数据一致性
     *
     * @param id 卡口过车数据一致性主键
     * @return 卡口过车数据一致性
     */
    @Override
    public VehicleDataMonitor selectVehicleDataMonitorById(Integer id) {
        return vehicleDataMonitorMapper.selectVehicleDataMonitorById(id);
    }

    /**
     * 查询卡口过车数据一致性列表
     *
     * @param vehicleDataMonitor 卡口过车数据一致性
     * @return 卡口过车数据一致性
     */
    @Override
    public List<VehicleDataMonitor> selectVehicleDataMonitorList(VehicleDataMonitor vehicleDataMonitor) {
        return vehicleDataMonitorMapper.selectVehicleDataMonitorList(vehicleDataMonitor);
    }

    /**
     * 新增卡口过车数据一致性
     *
     * @param vehicleDataMonitor 卡口过车数据一致性
     * @return 结果
     */
    @Override
    public int insertVehicleDataMonitor(VehicleDataMonitor vehicleDataMonitor) {
        vehicleDataMonitor.setCreateTime(DateUtils.getNowDate());
        vehicleDataMonitor.setDeleted("0");
        return vehicleDataMonitorMapper.insertVehicleDataMonitor(vehicleDataMonitor);
    }

    /**
     * 修改卡口过车数据一致性
     *
     * @param vehicleDataMonitor 卡口过车数据一致性
     * @return 结果
     */
    @Override
    public int updateVehicleDataMonitor(VehicleDataMonitor vehicleDataMonitor) {
        vehicleDataMonitor.setUpdateTime(DateUtils.getNowDate());
        return vehicleDataMonitorMapper.updateVehicleDataMonitor(vehicleDataMonitor);
    }

    /**
     * 批量删除卡口过车数据一致性
     *
     * @param ids 需要删除的卡口过车数据一致性主键
     * @return 结果
     */
    @Override
    public int deleteVehicleDataMonitorByIds(Integer[] ids) {
        return vehicleDataMonitorMapper.deleteVehicleDataMonitorByIds(ids);
    }

    /**
     * 删除卡口过车数据一致性信息
     *
     * @param id 卡口过车数据一致性主键
     * @return 结果
     */
    @Override
    public int deleteVehicleDataMonitorById(Integer id) {
        return vehicleDataMonitorMapper.deleteVehicleDataMonitorById(id);
    }
}

 ycl-server/src/main/resources/mapper/zgyw/VehicleDataMonitorMapper.xml

New file
@@ -0,0 +1,103 @@
<?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.ycl.platform.mapper.VehicleDataMonitorMapper">

    <resultMap type="com.ycl.platform.domain.entity.VehicleDataMonitor" id="VehicleDataMonitorResult">
        <result property="id" column="id"/>
        <result property="regionCode" column="region_code"/>
        <result property="bayonetName" column="bayonet_name"/>
        <result property="bayonetNumber" column="bayonet_number"/>
        <result property="vehicleDataNumber" column="vehicle_data_number"/>
        <result property="notUniqueData" column="not_unique_data"/>
        <result property="notUniqueDataNumber" column="not_unique_data_number"/>
        <result property="createTime" column="create_time"/>
        <result property="updateTime" column="update_time"/>
        <result property="deleted" column="deleted"/>
    </resultMap>

    <sql id="selectVehicleDataMonitorVo">
        select id,
               region_code,
               bayonet_name,
               bayonet_number,
               vehicle_data_number,
               not_unique_data,
               not_unique_data_number,
               create_time,
               update_time,
               deleted
        from t_vehicle_data_monitor
    </sql>

    <select id="selectVehicleDataMonitorList" parameterType="com.ycl.platform.domain.entity.VehicleDataMonitor" resultMap="VehicleDataMonitorResult">
        <include refid="selectVehicleDataMonitorVo"/>
        <where>
            deleted != 1
            <if test="regionCode != null  and regionCode != ''">and region_code = #{regionCode}</if>
            <if test="bayonetName != null  and bayonetName != ''">and bayonet_name like concat('%', #{bayonetName}, '%')</if>
            <if test="bayonetNumber != null  and bayonetNumber != ''">and bayonet_number like concat('%', #{bayonetNumber}, '%')</if>
        </where>
    </select>

    <select id="selectVehicleDataMonitorById" parameterType="Integer" resultMap="VehicleDataMonitorResult">
        <include refid="selectVehicleDataMonitorVo"/>
        where id = #{id}
    </select>

    <insert id="insertVehicleDataMonitor" parameterType="com.ycl.platform.domain.entity.VehicleDataMonitor" useGeneratedKeys="true" keyProperty="id">
        insert into t_vehicle_data_monitor
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="regionCode != null">region_code,</if>
            <if test="bayonetName != null and bayonetName != ''">bayonet_name,</if>
            <if test="bayonetNumber != null and bayonetNumber != ''">bayonet_number,</if>
            <if test="vehicleDataNumber != null">vehicle_data_number,</if>
            <if test="notUniqueData != null">not_unique_data,</if>
            <if test="notUniqueDataNumber != null">not_unique_data_number,</if>
            <if test="createTime != null">create_time,</if>
            <if test="updateTime != null">update_time,</if>
            <if test="deleted != null">deleted,</if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="regionCode != null">#{regionCode},</if>
            <if test="bayonetName != null and bayonetName != ''">#{bayonetName},</if>
            <if test="bayonetNumber != null and bayonetNumber != ''">#{bayonetNumber},</if>
            <if test="vehicleDataNumber != null">#{vehicleDataNumber},</if>
            <if test="notUniqueData != null">#{notUniqueData},</if>
            <if test="notUniqueDataNumber != null">#{notUniqueDataNumber},</if>
            <if test="createTime != null">#{createTime},</if>
            <if test="updateTime != null">#{updateTime},</if>
            <if test="deleted != null">#{deleted},</if>
        </trim>
    </insert>

    <update id="updateVehicleDataMonitor" parameterType="com.ycl.platform.domain.entity.VehicleDataMonitor">
        update t_vehicle_data_monitor
        <trim prefix="SET" suffixOverrides=",">
            <if test="regionCode != null">region_code = #{regionCode},</if>
            <if test="bayonetName != null and bayonetName != ''">bayonet_name = #{bayonetName},</if>
            <if test="bayonetNumber != null and bayonetNumber != ''">bayonet_number = #{bayonetNumber},</if>
            <if test="vehicleDataNumber != null">vehicle_data_number = #{vehicleDataNumber},</if>
            <if test="notUniqueData != null">not_unique_data = #{notUniqueData},</if>
            <if test="notUniqueDataNumber != null">not_unique_data_number = #{notUniqueDataNumber},</if>
            <if test="createTime != null">create_time = #{createTime},</if>
            <if test="updateTime != null">update_time = #{updateTime},</if>
            <if test="deleted != null">deleted = #{deleted},</if>
        </trim>
        where id = #{id}
    </update>

    <delete id="deleteVehicleDataMonitorById" parameterType="Integer">
        delete
        from t_vehicle_data_monitor
        where id = #{id}
    </delete>

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