lxw
2023-09-05 91cd497adf36da749a1537cd589bde41a9dfc67e
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
package com.whyc.service;
 
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.whyc.mapper.CarCameraHisMapper;
import com.whyc.pojo.CarCamera;
import com.whyc.pojo.CarCameraHis;
import com.whyc.pojo.Response;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
 
import java.util.List;
 
@Service
public class CarCameraHisService {
    @Autowired(required = false)
    private CarCameraHisMapper hisMapper;
 
    //获取门禁历史数据
    public Response getCarCameraHis(int carCameraId,int pageCurr,int pageSize) {
        PageHelper.startPage(pageCurr,pageSize);
        QueryWrapper wrapper=new QueryWrapper();
        wrapper.eq("carcamera_id",carCameraId);
        wrapper.orderByDesc("record_time");
        List<CarCameraHis> list=hisMapper.selectList(wrapper);
        PageInfo pageInfo=new PageInfo(list);
        return new Response().setII(1,list.size()>0,pageInfo,"获取门禁历史数据");
    }
}