package org.jeecg.modules.tms.service.impl; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.core.metadata.OrderItem; import com.baomidou.mybatisplus.core.toolkit.Wrappers; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import org.apache.commons.lang.StringUtils; import org.jeecg.common.exception.ExceptionCast; import org.jeecg.modules.tms.entity.ToolSharpening; import org.jeecg.modules.tms.entity.ToolsLossBoundDetail; import org.jeecg.modules.tms.entity.vo.ToolSharpeningVo; import org.jeecg.modules.tms.mapper.ToolsSharpeningMapper; import org.jeecg.modules.tms.service.IToolsSharpeningService; import org.springframework.stereotype.Service; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import java.util.ArrayList; import java.util.List; import java.util.Map; /** * @Description: 刀具刃磨记录 Service 实现类 * @Author: yourName * @Date: 2025-05-10 */ @Service public class ToolsSharpeningServiceImpl extends ServiceImpl implements IToolsSharpeningService { @Override public IPage queryPageList(Page page, Map parameterMap) { QueryWrapper queryWrapper = Wrappers.query(); String[] ids = parameterMap.get("id"); if (ids != null && ids.length > 0) { queryWrapper.like("t.id", ids[0]); } String[] toolIds = parameterMap.get("toolId"); if (toolIds != null && toolIds.length > 0) { queryWrapper.like("t.tool_id", toolIds[0]); } String[] sharpeningResults = parameterMap.get("sharpeningResult"); if (sharpeningResults != null && sharpeningResults.length > 0) { queryWrapper.like("t.sharpening_result", sharpeningResults[0]); } String[] startTimes = parameterMap.get("sharpeningTimeBegin "); if (startTimes != null && startTimes.length > 0) { queryWrapper.ge("t.sharpening_time", startTimes[0]); } String[] endTimes = parameterMap.get("sharpeningTimeEnd"); if (endTimes != null && endTimes.length > 0) { queryWrapper.le("t.sharpening_time", endTimes[0]); } queryWrapper.orderByDesc("t.create_time"); return this.baseMapper.queryPageList(page, queryWrapper); } @Override public IPage> toolSharpeningList(Integer pageNo, Integer pageSize, Map query) { if (pageNo == null || pageNo < 1 || pageSize == null || pageSize < 1) { ExceptionCast.cast("参数错误"); } IPage pageData = new Page(pageNo, pageSize); QueryWrapper queryWrapper = Wrappers.query(); if (null != query) { String classifyId = query.get("classifyId"); if (StringUtils.isNotBlank(classifyId)) { queryWrapper.eq("t2.classify_id", classifyId); } String toolCode = query.get("toolCode"); if (StringUtils.isNotBlank(toolCode)) { queryWrapper.like("t2.tool_code", toolCode); } String toolModel = query.get("toolModel"); if (StringUtils.isNotBlank(toolModel)) { queryWrapper.like("t2.tool_mode", toolModel); } // 排序写法 List orderItems = new ArrayList<>(); orderItems.add(OrderItem.desc("t1.create_time")); ((Page) pageData).setOrders(orderItems); } return super.getBaseMapper().toolSharpeningList(pageData,queryWrapper); } }