三一车辆查询有历史轨迹日期提交

zhangnaisong

2023-08-07 76876a632f2dd61acefde9c4e75cb8242c658ca2

三一车辆查询有历史轨迹日期提交

 ard-work/src/main/java/com/ruoyi/sy/controller/ArdSyCarController.java

@@ -3,7 +3,6 @@
import java.util.*;
import javax.annotation.PostConstruct;
import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.ruoyi.common.core.domain.entity.SysUser;
@@ -34,8 +33,6 @@
import com.ruoyi.sy.service.IArdSyCarService;
import com.ruoyi.common.utils.poi.ExcelUtil;
import com.ruoyi.common.core.page.TableDataInfo;
import org.springframework.web.context.request.RequestContextHolder;
import org.springframework.web.context.request.ServletRequestAttributes;
import org.springframework.web.multipart.MultipartFile;

/**

 ard-work/src/main/java/com/ruoyi/sy/domain/ArdSyCarDay.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,93 @@
package com.ruoyi.sy.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_sy_car_day
 * 
 * @author ard
 * @date 2023-08-07
 */
public class ArdSyCarDay extends BaseEntity
{
    private static final long serialVersionUID = 1L;

    /** ä¸»é”® */
    private String id;

    /** è½¦è¾†ä¸»é”® */
    @Excel(name = "车辆主键")
    private String carId;

    /** ä¸ŠæŠ¥æ—¥ï¼ˆå¹´æœˆæ—¥ï¼‰ */
    @Excel(name = "上报日", readConverterExp = "å¹´=月日")
    private String day;

    /** é¦–次上报时间 */
    @Excel(name = "首次上报时间")
    private String firstTime;

    /** æœ€åŽä¸ŠæŠ¥æ—¶é—´ */
    @Excel(name = "最后上报时间")
    private String endTime;

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

    public String getId() 
    {
        return id;
    }
    public void setCarId(String carId) 
    {
        this.carId = carId;
    }

    public String getCarId() 
    {
        return carId;
    }
    public void setDay(String day) 
    {
        this.day = day;
    }

    public String getDay() 
    {
        return day;
    }
    public void setFirstTime(String firstTime) 
    {
        this.firstTime = firstTime;
    }

    public String getFirstTime() 
    {
        return firstTime;
    }
    public void setEndTime(String endTime) 
    {
        this.endTime = endTime;
    }

    public String getEndTime() 
    {
        return endTime;
    }

    @Override
    public String toString() {
        return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)
            .append("id", getId())
            .append("carId", getCarId())
            .append("day", getDay())
            .append("firstTime", getFirstTime())
            .append("endTime", getEndTime())
            .toString();
    }
}

 ard-work/src/main/java/com/ruoyi/sy/gps31/PushClientImplPosition.java

@@ -13,6 +13,7 @@
import com.gps31.push.netty.client.TcpClient;
import com.gps31.push.util.MapUtil;
import com.ruoyi.common.utils.spring.SpringUtils;
import com.ruoyi.sy.service.impl.ArdSyCarDayServiceImpl;
import com.ruoyi.sy.service.impl.ArdSyCarServiceImpl;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
@@ -74,6 +75,7 @@
            System.out.println(sdf.format(new Date()));
            log.error(String.format("   ---->收到定位数据:%s",JSON.toJSONString(gpsMap)));*/
            String carId = (String)gpsMap.get("carId");
            ((ArdSyCarDayServiceImpl)SpringUtils.getBean("ardSyCarDayServiceImpl")).insertArdSyCarDay(carId);//新增车辆上报时间
            Map<String,Object> result = ((ArdSyCarServiceImpl)SpringUtils.getBean("ardSyCarServiceImpl")).getArdSyCarAndDeptByCarId(carId);//查询车辆及部门
            if(result != null){
                gpsMap.putAll(result);

 ard-work/src/main/java/com/ruoyi/sy/mapper/ArdSyCarDayMapper.java

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

import java.util.List;
import com.ruoyi.sy.domain.ArdSyCarDay;
import org.apache.ibatis.annotations.Param;

/**
 * ä¸‰ä¸€è½¦è¾†ä¸ŠæŠ¥æ—¶é—´Mapper接口
 * 
 * @author ard
 * @date 2023-08-07
 */
public interface ArdSyCarDayMapper 
{
    /**
     * æŸ¥è¯¢ä¸‰ä¸€è½¦è¾†ä¸ŠæŠ¥æ—¶é—´
     * 
     * @param id ä¸‰ä¸€è½¦è¾†ä¸ŠæŠ¥æ—¶é—´ä¸»é”®
     * @return ä¸‰ä¸€è½¦è¾†ä¸ŠæŠ¥æ—¶é—´
     */
    public ArdSyCarDay selectArdSyCarDayById(String id);

    /**
     * æŸ¥è¯¢ä¸‰ä¸€è½¦è¾†ä¸ŠæŠ¥æ—¶é—´åˆ—表
     * 
     * @param ardSyCarDay ä¸‰ä¸€è½¦è¾†ä¸ŠæŠ¥æ—¶é—´
     * @return ä¸‰ä¸€è½¦è¾†ä¸ŠæŠ¥æ—¶é—´é›†åˆ
     */
    public List<ArdSyCarDay> selectArdSyCarDayList(ArdSyCarDay ardSyCarDay);

    /**
     * æ–°å¢žä¸‰ä¸€è½¦è¾†ä¸ŠæŠ¥æ—¶é—´
     * 
     * @param ardSyCarDay ä¸‰ä¸€è½¦è¾†ä¸ŠæŠ¥æ—¶é—´
     * @return ç»“æžœ
     */
    public int insertArdSyCarDay(ArdSyCarDay ardSyCarDay);

    /**
     * ä¿®æ”¹ä¸‰ä¸€è½¦è¾†ä¸ŠæŠ¥æ—¶é—´
     * 
     * @param ardSyCarDay ä¸‰ä¸€è½¦è¾†ä¸ŠæŠ¥æ—¶é—´
     * @return ç»“æžœ
     */
    public int updateArdSyCarDay(ArdSyCarDay ardSyCarDay);

    /**
     * åˆ é™¤ä¸‰ä¸€è½¦è¾†ä¸ŠæŠ¥æ—¶é—´
     * 
     * @param id ä¸‰ä¸€è½¦è¾†ä¸ŠæŠ¥æ—¶é—´ä¸»é”®
     * @return ç»“æžœ
     */
    public int deleteArdSyCarDayById(String id);

    /**
     * æ‰¹é‡åˆ é™¤ä¸‰ä¸€è½¦è¾†ä¸ŠæŠ¥æ—¶é—´
     * 
     * @param ids éœ€è¦åˆ é™¤çš„数据主键集合
     * @return ç»“æžœ
     */
    public int deleteArdSyCarDayByIds(String[] ids);

    /**
     * æ›´æ”¹ä¸‰ä¸€è½¦è¾†ä¸ŠæŠ¥æ—¶é—´ä¿¡æ¯
     *
     */
    public int updateArdSyCarDayByCarIdAndDay(@Param("carId")String carId, @Param("day")String day, @Param("endTime")String endTime);

    /**
     * æ ¹æ®è½¦è¾†ä¸»é”®åŠä¸Šä¼ æ—¥æœŸæŸ¥è¯¢ä¸‰ä¸€è½¦è¾†ä¸ŠæŠ¥æ—¶é—´ä¿¡æ¯
     *
     */
    public List<ArdSyCarDay> selectArdSyCarDayByCarIdAndDay(@Param("carId")String carId,@Param("day")String day);
}

 ard-work/src/main/java/com/ruoyi/sy/service/IArdSyCarDayService.java

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

import java.util.List;
import com.ruoyi.sy.domain.ArdSyCarDay;

/**
 * ä¸‰ä¸€è½¦è¾†ä¸ŠæŠ¥æ—¶é—´Service接口
 * 
 * @author ard
 * @date 2023-08-07
 */
public interface IArdSyCarDayService 
{
    /**
     * æŸ¥è¯¢ä¸‰ä¸€è½¦è¾†ä¸ŠæŠ¥æ—¶é—´
     * 
     * @param id ä¸‰ä¸€è½¦è¾†ä¸ŠæŠ¥æ—¶é—´ä¸»é”®
     * @return ä¸‰ä¸€è½¦è¾†ä¸ŠæŠ¥æ—¶é—´
     */
    public ArdSyCarDay selectArdSyCarDayById(String id);

    /**
     * æŸ¥è¯¢ä¸‰ä¸€è½¦è¾†ä¸ŠæŠ¥æ—¶é—´åˆ—表
     * 
     * @param ardSyCarDay ä¸‰ä¸€è½¦è¾†ä¸ŠæŠ¥æ—¶é—´
     * @return ä¸‰ä¸€è½¦è¾†ä¸ŠæŠ¥æ—¶é—´é›†åˆ
     */
    public List<ArdSyCarDay> selectArdSyCarDayList(ArdSyCarDay ardSyCarDay);

    /**
     * æ–°å¢žä¸‰ä¸€è½¦è¾†ä¸ŠæŠ¥æ—¶é—´
     * 
     * @param ardSyCarDay ä¸‰ä¸€è½¦è¾†ä¸ŠæŠ¥æ—¶é—´
     * @return ç»“æžœ
     */
    public int insertArdSyCarDay(ArdSyCarDay ardSyCarDay);

    /**
     * ä¿®æ”¹ä¸‰ä¸€è½¦è¾†ä¸ŠæŠ¥æ—¶é—´
     * 
     * @param ardSyCarDay ä¸‰ä¸€è½¦è¾†ä¸ŠæŠ¥æ—¶é—´
     * @return ç»“æžœ
     */
    public int updateArdSyCarDay(ArdSyCarDay ardSyCarDay);

    /**
     * æ‰¹é‡åˆ é™¤ä¸‰ä¸€è½¦è¾†ä¸ŠæŠ¥æ—¶é—´
     * 
     * @param ids éœ€è¦åˆ é™¤çš„三一车辆上报时间主键集合
     * @return ç»“æžœ
     */
    public int deleteArdSyCarDayByIds(String[] ids);

    /**
     * åˆ é™¤ä¸‰ä¸€è½¦è¾†ä¸ŠæŠ¥æ—¶é—´ä¿¡æ¯
     * 
     * @param id ä¸‰ä¸€è½¦è¾†ä¸ŠæŠ¥æ—¶é—´ä¸»é”®
     * @return ç»“æžœ
     */
    public int deleteArdSyCarDayById(String id);

    /**
     * æ–°å¢žä¸‰ä¸€è½¦è¾†ä¸ŠæŠ¥æ—¶é—´ä¿¡æ¯
     *
     */
    public int insertArdSyCarDay(String carId);
}

 ard-work/src/main/java/com/ruoyi/sy/service/impl/ArdSyCarDayServiceImpl.java

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

import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;

import com.ruoyi.common.utils.uuid.IdUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.ruoyi.sy.mapper.ArdSyCarDayMapper;
import com.ruoyi.sy.domain.ArdSyCarDay;
import com.ruoyi.sy.service.IArdSyCarDayService;

import javax.annotation.Resource;

/**
 * ä¸‰ä¸€è½¦è¾†ä¸ŠæŠ¥æ—¶é—´Service业务层处理
 *
 * @author ard
 * @date 2023-08-07
 */
@Service
public class ArdSyCarDayServiceImpl implements IArdSyCarDayService {
    @Resource
    private ArdSyCarDayMapper ardSyCarDayMapper;

    /**
     * æŸ¥è¯¢ä¸‰ä¸€è½¦è¾†ä¸ŠæŠ¥æ—¶é—´
     *
     * @param id ä¸‰ä¸€è½¦è¾†ä¸ŠæŠ¥æ—¶é—´ä¸»é”®
     * @return ä¸‰ä¸€è½¦è¾†ä¸ŠæŠ¥æ—¶é—´
     */
    @Override
    public ArdSyCarDay selectArdSyCarDayById(String id) {
        return ardSyCarDayMapper.selectArdSyCarDayById(id);
    }

    /**
     * æŸ¥è¯¢ä¸‰ä¸€è½¦è¾†ä¸ŠæŠ¥æ—¶é—´åˆ—表
     *
     * @param ardSyCarDay ä¸‰ä¸€è½¦è¾†ä¸ŠæŠ¥æ—¶é—´
     * @return ä¸‰ä¸€è½¦è¾†ä¸ŠæŠ¥æ—¶é—´
     */
    @Override
    public List<ArdSyCarDay> selectArdSyCarDayList(ArdSyCarDay ardSyCarDay) {
        return ardSyCarDayMapper.selectArdSyCarDayList(ardSyCarDay);
    }

    /**
     * æ–°å¢žä¸‰ä¸€è½¦è¾†ä¸ŠæŠ¥æ—¶é—´
     *
     * @param ardSyCarDay ä¸‰ä¸€è½¦è¾†ä¸ŠæŠ¥æ—¶é—´
     * @return ç»“æžœ
     */
    @Override
    public int insertArdSyCarDay(ArdSyCarDay ardSyCarDay) {
            return ardSyCarDayMapper.insertArdSyCarDay(ardSyCarDay);
    }

    /**
     * ä¿®æ”¹ä¸‰ä¸€è½¦è¾†ä¸ŠæŠ¥æ—¶é—´
     *
     * @param ardSyCarDay ä¸‰ä¸€è½¦è¾†ä¸ŠæŠ¥æ—¶é—´
     * @return ç»“æžœ
     */
    @Override
    public int updateArdSyCarDay(ArdSyCarDay ardSyCarDay) {
        return ardSyCarDayMapper.updateArdSyCarDay(ardSyCarDay);
    }

    /**
     * æ‰¹é‡åˆ é™¤ä¸‰ä¸€è½¦è¾†ä¸ŠæŠ¥æ—¶é—´
     *
     * @param ids éœ€è¦åˆ é™¤çš„三一车辆上报时间主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteArdSyCarDayByIds(String[] ids) {
        return ardSyCarDayMapper.deleteArdSyCarDayByIds(ids);
    }

    /**
     * åˆ é™¤ä¸‰ä¸€è½¦è¾†ä¸ŠæŠ¥æ—¶é—´ä¿¡æ¯
     *
     * @param id ä¸‰ä¸€è½¦è¾†ä¸ŠæŠ¥æ—¶é—´ä¸»é”®
     * @return ç»“æžœ
     */
    @Override
    public int deleteArdSyCarDayById(String id) {
        return ardSyCarDayMapper.deleteArdSyCarDayById(id);
    }

    /**
     * æ–°å¢žä¸‰ä¸€è½¦è¾†ä¸ŠæŠ¥æ—¶é—´ä¿¡æ¯
     *
     */
    @Override
    public int insertArdSyCarDay(String carId) {
        String id = IdUtils.simpleUUID();
        SimpleDateFormat ymd = new SimpleDateFormat("yyyy-MM-dd");
        String day = ymd.format(new Date());
        ArdSyCarDay ardSyCarDay = new ArdSyCarDay();
        ardSyCarDay.setCarId(carId);
        ardSyCarDay.setDay(day);
        List<ArdSyCarDay> ardSyCarDayList = ardSyCarDayMapper.selectArdSyCarDayList(ardSyCarDay);
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
        int result = 0;
        if(ardSyCarDayList.size() == 0){
            String time = sdf.format(new Date());
            ardSyCarDay.setFirstTime(time);
            ardSyCarDay.setEndTime(time);
            ardSyCarDay.setId(id);
            result = ardSyCarDayMapper.insertArdSyCarDay(ardSyCarDay);
        }else{
            String endTime = sdf.format(new Date());
            result = ardSyCarDayMapper.updateArdSyCarDayByCarIdAndDay(carId,ardSyCarDayList.get(0).getDay(),endTime);
        }
        return result;
    }
}

 ard-work/src/main/java/com/ruoyi/sy/service/impl/ArdSyCarServiceImpl.java

@@ -14,6 +14,8 @@
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.ruoyi.common.core.domain.entity.SysUser;
import com.ruoyi.common.utils.uuid.IdUtils;
import com.ruoyi.sy.domain.ArdSyCarDay;
import com.ruoyi.sy.mapper.ArdSyCarDayMapper;
import com.ruoyi.utils.websocket.util.WebSocketUtils;
import com.ruoyi.device.hiksdk.config.MinioClientSingleton;
import com.ruoyi.storage.minio.utils.MinioUtils;
@@ -68,6 +70,9 @@

    @Resource
    private SYClient sYClient;

    @Resource
    private ArdSyCarDayMapper ardSyCarDayMapper;

    private Map<Integer,Map<String,String>> logInMap = new HashMap();

@@ -798,7 +803,7 @@
        }
    }

    @Override
    /*@Override
    public Results getExistTraceByCarIdAndMonth(String userId, String carId, String time) {
        SysConfig config = new SysConfig();
        config.setConfigKey("syCarPT");
@@ -820,6 +825,16 @@
                return Results.succeed(existTraceMap);
            }
        }
    }*/

    @Override
    public Results getExistTraceByCarIdAndMonth(String userId, String carId, String time) {
        List<ArdSyCarDay> result = ardSyCarDayMapper.selectArdSyCarDayByCarIdAndDay(carId,time + "%");
        List<String> list = new ArrayList();
        for(ArdSyCarDay ardSyCarDay : result){
            list.add(ardSyCarDay.getDay().split("-")[2]);
        }
        return Results.succeed(list);
    }

    public Map<String,Integer> getExistTraceByCarIdAndMonth(String url,String usersId,String password,String carId,String time){

 ard-work/src/main/resources/mapper/sy/ArdSyCarDayMapper.xml

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,83 @@
<?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.sy.mapper.ArdSyCarDayMapper">
    
    <resultMap type="ArdSyCarDay" id="ArdSyCarDayResult">
        <result property="id"    column="id"    />
        <result property="carId"    column="car_id"    />
        <result property="day"    column="day"    />
        <result property="firstTime"    column="first_time"    />
        <result property="endTime"    column="end_time"    />
    </resultMap>

    <sql id="selectArdSyCarDayVo">
        select id, car_id, day, first_time, end_time from ard_sy_car_day
    </sql>

    <select id="selectArdSyCarDayList" parameterType="ArdSyCarDay" resultMap="ArdSyCarDayResult">
        <include refid="selectArdSyCarDayVo"/>
        <where>  
            <if test="carId != null  and carId != ''"> and car_id = #{carId}</if>
            <if test="day != null  and day != ''"> and day = #{day}</if>
            <if test="firstTime != null  and firstTime != ''"> and first_time = #{firstTime}</if>
            <if test="endTime != null  and endTime != ''"> and end_time = #{endTime}</if>
        </where>
    </select>
    
    <select id="selectArdSyCarDayById" parameterType="String" resultMap="ArdSyCarDayResult">
        <include refid="selectArdSyCarDayVo"/>
        where id = #{id}
    </select>
        
    <insert id="insertArdSyCarDay" parameterType="ArdSyCarDay">
        insert into ard_sy_car_day
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="id != null">id,</if>
            <if test="carId != null">car_id,</if>
            <if test="day != null">day,</if>
            <if test="firstTime != null">first_time,</if>
            <if test="endTime != null">end_time,</if>
         </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="id != null">#{id},</if>
            <if test="carId != null">#{carId},</if>
            <if test="day != null">#{day},</if>
            <if test="firstTime != null">#{firstTime},</if>
            <if test="endTime != null">#{endTime},</if>
         </trim>
    </insert>

    <update id="updateArdSyCarDay" parameterType="ArdSyCarDay">
        update ard_sy_car_day
        <trim prefix="SET" suffixOverrides=",">
            <if test="carId != null">car_id = #{carId},</if>
            <if test="day != null">day = #{day},</if>
            <if test="firstTime != null">first_time = #{firstTime},</if>
            <if test="endTime != null">end_time = #{endTime},</if>
        </trim>
        where id = #{id}
    </update>

    <delete id="deleteArdSyCarDayById" parameterType="String">
        delete from ard_sy_car_day where id = #{id}
    </delete>

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

    <update id="updateArdSyCarDayByCarIdAndDay" parameterType="java.lang.String">
        update ard_sy_car_day set end_time = #{endTime} where car_id = #{carId} and day = #{day}
    </update>

    <select id="selectArdSyCarDayByCarIdAndDay" parameterType="java.lang.String" resultMap="ArdSyCarDayResult">
        select * from ard_sy_car_day ascd
        where ascd.car_id = #{carId} and ascd.day like #{day}
        order by ascd.day desc
    </select>
</mapper>