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"));
}
}