电磁锁主动操控记录查询提交

zhangnaisong

2024-08-06 4dbd2e0a473ef33ecf8a7200f62b61d4dbd87f25

电磁锁主动操控记录查询提交

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

@@ -425,4 +425,18 @@
    public AjaxResult updateLockEnableByCarId(@RequestBody Map<String,Object> para) {
        return toAjax(ardTankLockService.updateLockEnableByCarId(para));
    }

    @ApiOperation("根据车牌号查询电磁锁手动操控记录")
    @PreAuthorize("@ss.hasPermi('sy:lock:getArdTankLockProcessLogByCarPlate')")
    @PostMapping("/getArdTankLockProcessLogByCarPlate")
    public TableDataInfo getArdTankLockProcessLogByCarPlate(@RequestBody Map<String,Object> para) {
        Map<String,Object> result = ardTankLockProcessLogService.getArdTankLockProcessLogByCarPlate(para);

        TableDataInfo dataTable = new TableDataInfo();
        dataTable.setRows((List<Map<String,Object>>) result.get("list"));
        dataTable.setTotal((Long) result.get("total"));
        dataTable.setCode(200);
        dataTable.setMsg("查询成功");
        return dataTable;
    }
}

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

@@ -2,6 +2,7 @@

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

/**
 * 罐车锁操控日志Mapper接口
@@ -58,4 +59,12 @@
     * @return 结果
     */
    public int deleteArdTankLockProcessLogByIds(String[] ids);

    public List<ArdTankLockProcessLog> getArdTankLockProcessLogByCarPlate(String carPlate);

    public Long getArdTankLockProcessLogTotalByCarPlate(String carPlate);

    public List<ArdTankLockProcessLog> getArdTankLockProcessLogAll();

    public Long getArdTankLockProcessLogTotal();
}

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

@@ -65,4 +65,6 @@
    public AjaxResult processArdTankLockByLockId(String userId, String username, Map<String,String> para);

    public void autoProcessArdTankLockByLockId(Map<String,Object> gpsMap);

    public Map<String,Object> getArdTankLockProcessLogByCarPlate(Map<String,Object> para);
}

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

@@ -6,6 +6,7 @@
import java.util.*;

import com.alibaba.fastjson2.JSON;
import com.github.pagehelper.PageHelper;
import com.ruoyi.common.core.domain.AjaxResult;
import com.ruoyi.common.core.domain.entity.SysConfig;
import com.ruoyi.common.utils.uuid.IdUtils;
@@ -588,6 +589,30 @@
        }
    }

    @Override
    public Map<String, Object> getArdTankLockProcessLogByCarPlate(Map<String, Object> para) {
        //分页属性
        Integer pageNum = (Integer) para.get("pageNum");
        Integer pageSize = (Integer) para.get("pageSize");

        PageHelper.startPage(pageNum, pageSize);//分页
        Map<String,Object> resultMap = new HashMap();
        if(((String) para.get("carPlate")).equals("")){
            List<ArdTankLockProcessLog> resultList = ardTankLockProcessLogMapper.getArdTankLockProcessLogAll();
            Long total =  ardTankLockProcessLogMapper.getArdTankLockProcessLogTotal();
            resultMap.put("list",resultList);
            resultMap.put("total",total);
            return resultMap;
        }else{
            List<ArdTankLockProcessLog> resultList = ardTankLockProcessLogMapper.getArdTankLockProcessLogByCarPlate("%" + (String) para.get("carPlate") + "%");
            Long total =  ardTankLockProcessLogMapper.getArdTankLockProcessLogTotalByCarPlate("%" + (String) para.get("carPlate") + "%");
            resultMap.put("list",resultList);
            resultMap.put("total",total);
            return resultMap;
        }

    }

    public Map<String,Object> sendCmd(String syURL,String userId,String carId,Integer cmdId,String cmd,String paramsStr,String sessionId){
        OkHttpClient okHttpClient = new OkHttpClient();


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

@@ -105,4 +105,21 @@
            #{id}
        </foreach>
    </delete>

    <select id="getArdTankLockProcessLogByCarPlate" parameterType="java.lang.String" resultMap="ArdTankLockProcessLogResult">
        select * from ard_tank_lock_process_log where car_plate like #{carPlate}
        order by process_time desc
    </select>

    <select id="getArdTankLockProcessLogTotalByCarPlate" parameterType="java.lang.String" resultType="java.lang.Long">
        select count(*) from ard_tank_lock_process_log where car_plate like #{carPlate}
    </select>

    <select id="getArdTankLockProcessLogAll" parameterType="java.lang.String" resultMap="ArdTankLockProcessLogResult">
        select * from ard_tank_lock_process_log order by process_time desc
    </select>

    <select id="getArdTankLockProcessLogTotal" parameterType="java.lang.String" resultType="java.lang.Long">
        select count(*) from ard_tank_lock_process_log
    </select>
</mapper>