fix:历史订单可以查询

wzp

2025-05-13 a2704917e53918213ce91390d14a98960fdd5bab

fix:历史订单可以查询

 ruoyi-admin/src/main/java/com/ruoyi/web/controller/system/VehicleGpsController.java

@@ -1,10 +1,12 @@
package com.ruoyi.web.controller.system;

import java.util.ArrayList;
import java.util.List;
import java.util.Objects;
import java.util.*;

import com.ruoyi.system.domain.DispatchOrd;
import com.ruoyi.system.domain.TbOrders;
import com.ruoyi.system.domain.TbVehicleOrder;
import com.ruoyi.system.service.IDispatchOrdService;
import com.ruoyi.system.service.ITbOrdersService;
import com.ruoyi.system.service.ITbVehicleOrderService;
import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.beans.factory.annotation.Autowired;
@@ -39,6 +41,12 @@
    @Autowired
    private ITbVehicleOrderService tbVehicleOrderService;

    @Autowired
    private IDispatchOrdService dispatchOrdService;

    @Autowired
    private ITbOrdersService tbOrdersService;

   /**
     * 查询车辆GPS坐标列表
     */  
@@ -72,9 +80,33 @@
        if(!Objects.equals(tbVehicleOrder.getStatus(), "0"))
        {
            //非0表示订单完成了。

            TbOrders tbOrders = tbOrdersService.selectTbOrdersByOrderID(vehicleGps.getOrderId());
            if(tbOrders==null)
            {
            return  getDataTable(new ArrayList<>());
        }


            DispatchOrd dispatchOrd = dispatchOrdService.selectDispatchOrdByServiceOrdIDDt(tbOrders.getServiceOrdID());
            if(dispatchOrd==null)
            {
                return getDataTable(new ArrayList<>());
            }

            Map<String, Object> params = new HashMap<>();
            params.put("beginTime",dispatchOrd.getDispatchOrdStartDate());
            params.put("endTime",dispatchOrd.getDispatchOrdUpdateTime());

            vehicleGps.setVehicleNo(tbVehicleOrder.getVehicle());
            startPage();
            // 设置按时间倒序排序
            vehicleGps.setOrderByColumn("collect_time");
            vehicleGps.setIsAsc("desc");
            List<VehicleGps> list = vehicleGpsService.selectVehicleGpsList(vehicleGps);
            return getDataTable(list);
        }

        vehicleGps.setVehicleNo(tbVehicleOrder.getVehicle());
        startPage();
        // 设置按时间倒序排序

 ruoyi-system/src/main/resources/mapper/system/DispatchOrdMapper.xml

@@ -22,6 +22,7 @@
        <result property="dispatchOrd_OAName" column="DispatchOrd_OAName"/>
        <result property="dispatchOrd_OAEntourage" column="DispatchOrd_OAEntourage"/>
        <result property="dispatchOrdCarID" column="DispatchOrdCarID"/>
        <result property="dispatchOrdUpdateTime"  column="DispatchOrdUpdateTime"/>
        
        <!-- ... 其他字段映射 ... -->
    </resultMap>