通用版本V1.9 3DTITLE 上一个版本 百度版本

zhitong.yu

2024-10-11 4f58a93c95ff123d51adcb8fa2e521333e8ab022

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
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
package com.hxzk.service.impl;
 
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.hxzk.deo.FaKa;
import com.hxzk.mapper.FaKaDao;
import com.hxzk.pojo.TbAchor;
import com.hxzk.pojo.TbFakaji;
import com.hxzk.service.FaKaService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
 
import java.util.List;
 
@Service
public class FaKaServiceImpl extends ServiceImpl<FaKaDao, TbFakaji> implements FaKaService {
    @Autowired
    FaKaDao faKaDao;
 
    @Override
    public PageInfo<TbFakaji> findAll(Integer page, Integer limit) {
        QueryWrapper queryWrapper = new QueryWrapper<>();
        PageHelper.startPage(page,limit);
        List<TbFakaji> cardList = baseMapper.selectList(queryWrapper);
        PageInfo<TbFakaji> info = new PageInfo<>(cardList);
        return info;
    }
 
    @Override
    public TbFakaji findFaka(FaKa fakaji) {
        QueryWrapper queryWrapper = new QueryWrapper<>();
        PageHelper.startPage(1,1);
        queryWrapper.eq("guiziid",fakaji.getDeviceId());
        queryWrapper.eq("state","0");
        queryWrapper.eq("statics","0");
        queryWrapper.orderByAsc("time");
        return baseMapper.selectOne(queryWrapper);
    }
 
    @Override
    public TbFakaji findFakaUserId(FaKa fakaji) {
        QueryWrapper queryWrapper = new QueryWrapper<>();
        PageHelper.startPage(1,1);
        queryWrapper.eq("userid",fakaji.getUserId()+"取卡");
        return baseMapper.selectOne(queryWrapper);
    }
 
    @Override
    public Integer InsertFaKa(TbFakaji fakaji) {
        return baseMapper.insert(fakaji);
    }
 
    @Override
    public Integer updateFaKa(TbFakaji fakaji) {
        QueryWrapper queryWrapper = new QueryWrapper<>();
        queryWrapper.eq("kacaoid",fakaji.getKacaoid());
        queryWrapper.eq("guiziid",fakaji.getGuiziid());
        queryWrapper.eq("tagid",fakaji.getTagid());
        return baseMapper.update(fakaji,queryWrapper);
    }
 
    @Override
    public Integer updateFaKaCardStatus(TbFakaji fakaji) {
        QueryWrapper queryWrapper = new QueryWrapper<>();
        queryWrapper.eq("kacaoid",fakaji.getKacaoid());
        queryWrapper.eq("guiziid",fakaji.getGuiziid());
        return baseMapper.update(fakaji,queryWrapper);
    }
 
    @Override
    public Integer deleteFakaji(TbFakaji fakaji) {
        QueryWrapper queryWrapper = new QueryWrapper<>();
        queryWrapper.eq("guiziid",fakaji.getGuiziid());
        queryWrapper.eq("kacaoid",fakaji.getKacaoid());
        return baseMapper.update(fakaji,queryWrapper);
    }
 
    @Override
    public Integer updateStateFaKa(TbFakaji fakaji) {
        QueryWrapper queryWrapper = new QueryWrapper<>();
        queryWrapper.eq("guiziid",fakaji.getGuiziid());
        queryWrapper.eq("kacaoid",fakaji.getKacaoid());
        return baseMapper.update(fakaji,queryWrapper);
    }
 
    @Override
    public TbFakaji findtakeFaka(FaKa fakaji) {
        QueryWrapper queryWrapper = new QueryWrapper<>();
//        queryWrapper.eq("deviceId",fakaji.getDeviceId());
        queryWrapper.eq("guiziid",fakaji.getDeviceId());
        queryWrapper.eq("state",1);
        queryWrapper.eq("status",0);
//        queryWrapper.eq("tagid",fakaji.getCardId());
        queryWrapper.orderByAsc("time");
        queryWrapper.last("LIMIT 1");
 
        return baseMapper.selectOne(queryWrapper);
    }
 
    @Override
    public TbFakaji cardStatus(FaKa fakaji) {
        QueryWrapper queryWrapper = new QueryWrapper<>();
        queryWrapper.eq("deviceId",fakaji.getDeviceId());
        queryWrapper.eq("cardId",fakaji.getCardId());
        queryWrapper.eq("doorNo",fakaji.getDoorNo());
        return baseMapper.selectOne(queryWrapper);
    }
 
    @Override
    public Integer updateStaticFaKa(TbFakaji fakaji) {
        return faKaDao.updateStaticFaKa(fakaji);
    }
 
    @Override
    public Integer updateStaticFaKaChaoShi(TbFakaji fakaji) {
        return faKaDao.updateStaticFaKaChaoShi(fakaji);
    }
 
    @Override
    public Integer updateFaKaQuKaState(String userid,String kacaoid) {
        return faKaDao.updateFaKaQuKaState(userid,kacaoid);
    }
 
    @Override
    public List<TbFakaji> findFakaNum(String num) {
        QueryWrapper queryWrapper = new QueryWrapper<>();
        queryWrapper.eq("guiziid",num);
        return baseMapper.selectList(queryWrapper);
    }
}