package com.fzzy.igds.service; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.fzzy.igds.data.GrainParam; import com.fzzy.igds.data.InoutParam; import com.fzzy.igds.domain.Grain; import com.fzzy.igds.domain.InoutRecord; import com.fzzy.igds.mapper.GrainMapper; import com.fzzy.igds.utils.ContextUtil; import com.fzzy.igds.utils.DateUtil; import com.ruoyi.common.utils.StringUtils; import lombok.extern.slf4j.Slf4j; import org.springframework.stereotype.Service; import javax.annotation.Resource; import java.util.Date; import java.util.HashMap; import java.util.List; import java.util.Map; /** * @Description * @Author CZT * @Date 2025/12/9 10:00 */ @Slf4j @Service public class GrainService { @Resource private GrainMapper grainMapper; /** * 查询数据 * @param param */ public List listData(GrainParam param) { if(StringUtils.isBlank(param.getCompanyId())){ param.setCompanyId(ContextUtil.getCompanyId()); } if(StringUtils.isBlank(param.getDeptId())){ param.setDeptId(ContextUtil.subDeptId(null)); } QueryWrapper queryWrapper = new QueryWrapper<>(); if (StringUtils.isNotBlank(param.getCompanyId())) { queryWrapper.eq("company_id", param.getCompanyId()); } if (StringUtils.isNotBlank(param.getDeptId())) { queryWrapper.eq("dept_id", param.getDeptId()); } if (StringUtils.isNotBlank(param.getDepotId())) { queryWrapper.eq("depot_id", param.getDepotId()); } if (StringUtils.isNotBlank(param.getBatchId())) { queryWrapper.eq("batch_id", param.getBatchId()); } if (null != param.getStart()) { queryWrapper.ge("receive_date", DateUtil.getCurZero(param.getStart())); } if (null != param.getEnd()) { queryWrapper.le("receive_date", DateUtil.getNextZero(param.getEnd())); } queryWrapper.orderByDesc("batch_id"); return grainMapper.selectList(queryWrapper); } /** * 分页查询数据 * @param page * @param param */ public void pageData(Page page, Map param) { QueryWrapper queryWrapper = new QueryWrapper<>(); queryWrapper.eq("company_id", ContextUtil.getCompanyId()); queryWrapper.eq("dept_id", ContextUtil.subDeptId(null)); String ids = (String) param.get("ids"); if (StringUtils.isNotBlank(ids)) { queryWrapper.in("depot_id", ids); } Date date = (Date) param.get(("start")); if (null != date) { queryWrapper.ge("receive_date", DateUtil.getCurZero(date)); } date = (Date) param.get(("end")); if (null != date) { queryWrapper.le("receive_date", DateUtil.getNextZero(date)); } queryWrapper.orderByDesc("batch_id"); grainMapper.selectPage(page, queryWrapper); } }