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; /** *

* 发卡日志服务实现类 *

* * @author YuZhiTong * @since 2025-01-XX */ @Service public class TbFakalogServiceImpl extends ServiceImpl implements TbFakalogService { @Override public ResultTable FindFaKaLogInfo(TableSearchResultFakalog tableSearchResultFakalog) { QueryWrapper 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 info = new PageInfo<>(baseMapper.selectList(queryWrapper)); table achortable = new table<>(info.getList(), tableSearchResultFakalog.getTableList().getPageNum(), tableSearchResultFakalog.getTableList().getPageSize(), info.getTotal()); return ListDataResult.resultTableSuccess(achortable, MessageUtils.getMessage("Success")); } }