查询锁的蓝牙开启时间段记录添加area_path

whyclxw

2025-03-25 a7fef2846505b08e0711345b17902e7381612d23

 src/main/java/com/whyc/service/LockCtlLogService.java

@@ -3,8 +3,11 @@
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.whyc.dto.HomeCtlGroupDto;
import com.whyc.dto.Response;
import com.whyc.mapper.LockCtlLogMapper;
import com.whyc.mapper.LockInfMapper;
import com.whyc.pojo.db_area.AreaUser;
import com.whyc.pojo.db_area.LockInf;
import com.whyc.pojo.db_lock_ram.LockCtlLog;
import com.whyc.pojo.db_user.UserInf;
@@ -12,31 +15,36 @@
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.stream.Collectors;

@Service
public class LockCtlLogService {
    @Autowired(required = false)
    private LockCtlLogMapper mapper;

    //查询开锁日志
    public Response getLockLog(Integer lockId,Integer logResult,int pageNum, int pageSize) {
        PageHelper.startPage(pageNum,pageSize);
        QueryWrapper wrapper=new QueryWrapper();
        if(lockId!=null){
            wrapper.eq("lock_id",lockId);
        }
        if(logResult!=null){
            wrapper.eq("ctl_result",logResult);
        }
        wrapper.orderByDesc("ctl_time");
        List<LockInf> list=mapper.selectList(wrapper);
        PageInfo pageInfo=new PageInfo(list);
        return new Response().setII(1,list!=null,pageInfo,"查询最近的开锁日志");
    }
    //获取开锁错误的日志
    public List getAllErrorLog(List lockIds) {
        List<LockCtlLog> list=mapper.getAllErrorLog(lockIds);
        return list;
    }

    //获取开锁日志
    public List getAllLog(List lockIds) {
        List<LockCtlLog> list=mapper.getAllLog(lockIds);
        return list;
    }
    //添加操作记录
    public void setLogByUid(Integer lockId, int result, String uname) {
        LockCtlLog log=new LockCtlLog();
        log.setLockId(lockId);
        log.setCtlType(7);//蓝牙开锁
        log.setCtlResult(result);
        log.setCtlTime(new Date());
        log.setCtlIdCard(0);
        log.setCtlUname(uname);
        mapper.insert(log);
    }
}