package org.jeecg.modules.qms.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.qms.entity.InspectionItem; import org.jeecg.modules.qms.mapper.InspectionItemMapper; import org.jeecg.modules.qms.service.IInspectionItemService; 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: 检验项目 * @Author: jeecg-boot * @Date: 2025-07-01 * @Version: V1.0 */ @Service public class InspectionItemServiceImpl extends ServiceImpl implements IInspectionItemService { @Override public IPage> queryList(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 itemCode = query.get("itemCode"); if (StringUtils.isNotBlank(itemCode)) { queryWrapper.like("t1.item_code", itemCode); } String itemName = query.get("itemName"); if (StringUtils.isNotBlank(itemName)) { queryWrapper.like("t2.item_name", itemName); } // 排序写法 List orderItems = new ArrayList<>(); orderItems.add(OrderItem.desc("t1.create_time")); ((Page) pageData).setOrders(orderItems); } return super.getBaseMapper().queryList(pageData,queryWrapper); } }