BS通用版本1.1.9

zhitong.yu

7 天以前 7fc9c42987a13c1d8d2159591a5803e70518827f

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
package com.hxzk.gps.service.impl.Cabinet;
 
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.hxzk.gps.controller.Cabinet.deo.TableSearchResultFakalog;
import com.hxzk.gps.entity.Cabinet.TbFakalog;
import com.hxzk.gps.mapper.Cabinet.TbFakalogMapper;
import com.hxzk.gps.result.ListDataResult;
import com.hxzk.gps.result.ResultTable;
import com.hxzk.gps.result.table;
import com.hxzk.gps.service.Cabinet.TbFakalogService;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.hxzk.gps.util.MessageUtils.MessageUtils;
import org.springframework.stereotype.Service;
 
/**
 * <p>
 *  发卡日志服务实现类
 * </p>
 *
 * @author YuZhiTong
 * @since 2025-01-XX
 */
@Service
public class TbFakalogServiceImpl extends ServiceImpl<TbFakalogMapper, TbFakalog> implements TbFakalogService {
 
    @Override
    public ResultTable FindFaKaLogInfo(TableSearchResultFakalog tableSearchResultFakalog) {
        QueryWrapper<TbFakalog> queryWrapper = new QueryWrapper<>();
 
        // 根据柜子名称查询（通过关联查询）
        if (tableSearchResultFakalog.getGuiziname() != null && !tableSearchResultFakalog.getGuiziname().isEmpty()) {
            queryWrapper.like("guiziname", tableSearchResultFakalog.getGuiziname());
        }
 
        // 根据柜子编号查询
        if (tableSearchResultFakalog.getGuiziid() != null && !tableSearchResultFakalog.getGuiziid().isEmpty()) {
            queryWrapper.like("guiziid", tableSearchResultFakalog.getGuiziid());
        }
 
        // 根据取卡卡槽查询
        if (tableSearchResultFakalog.getTakekacao() != null && !tableSearchResultFakalog.getTakekacao().isEmpty()) {
            queryWrapper.like("takekacao", tableSearchResultFakalog.getTakekacao());
        }
 
        // 根据取卡人名称查询
        if (tableSearchResultFakalog.getTakename() != null && !tableSearchResultFakalog.getTakename().isEmpty()) {
            queryWrapper.like("takename", tableSearchResultFakalog.getTakename());
        }
 
        // 根据取卡编号查询
        if (tableSearchResultFakalog.getTaketagid() != null && !tableSearchResultFakalog.getTaketagid().isEmpty()) {
            queryWrapper.like("taketagid", tableSearchResultFakalog.getTaketagid());
        }
 
        // 根据取卡用户ID查询
        if (tableSearchResultFakalog.getTakeuserid() != null && !tableSearchResultFakalog.getTakeuserid().isEmpty()) {
            queryWrapper.like("takeuserid", tableSearchResultFakalog.getTakeuserid());
        }
 
        // 根据还卡卡槽查询
        if (tableSearchResultFakalog.getSavekacao() != null && !tableSearchResultFakalog.getSavekacao().isEmpty()) {
            queryWrapper.like("savekacao", tableSearchResultFakalog.getSavekacao());
        }
 
        // 根据还卡人名称查询
        if (tableSearchResultFakalog.getSavename() != null && !tableSearchResultFakalog.getSavename().isEmpty()) {
            queryWrapper.like("savename", tableSearchResultFakalog.getSavename());
        }
 
        // 根据还卡编号查询
        if (tableSearchResultFakalog.getSavetagid() != null && !tableSearchResultFakalog.getSavetagid().isEmpty()) {
            queryWrapper.like("savetagid", tableSearchResultFakalog.getSavetagid());
        }
 
        // 根据取卡时间范围查询
        if (tableSearchResultFakalog.getStartTime() != null && !tableSearchResultFakalog.getStartTime().isEmpty()) {
            queryWrapper.ge("taketime", tableSearchResultFakalog.getStartTime());
        }
        if (tableSearchResultFakalog.getEndTime() != null && !tableSearchResultFakalog.getEndTime().isEmpty()) {
            queryWrapper.le("taketime", tableSearchResultFakalog.getEndTime());
        }
 
        // 根据还卡时间范围查询
        if (tableSearchResultFakalog.getStartSaveTime() != null && !tableSearchResultFakalog.getStartSaveTime().isEmpty()) {
            queryWrapper.ge("savetime", tableSearchResultFakalog.getStartSaveTime());
        }
        if (tableSearchResultFakalog.getEndSaveTime() != null && !tableSearchResultFakalog.getEndSaveTime().isEmpty()) {
            queryWrapper.le("savetime", tableSearchResultFakalog.getEndSaveTime());
        }
 
        // 按ID降序排列（最新的在前面）
        queryWrapper.orderByDesc("id");
 
        PageHelper.startPage(tableSearchResultFakalog.getTableList().getPageNum(), tableSearchResultFakalog.getTableList().getPageSize());
        PageInfo<TbFakalog> info = new PageInfo<>(baseMapper.selectList(queryWrapper));
        table<TbFakalog> achortable = new table<>(info.getList(), tableSearchResultFakalog.getTableList().getPageNum(), tableSearchResultFakalog.getTableList().getPageSize(), info.getTotal());
        return ListDataResult.resultTableSuccess(achortable, MessageUtils.getMessage("Success"));
    }
}