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<InspectionItemMapper, InspectionItem> implements IInspectionItemService {
|
|
@Override
|
public IPage<Map<String, Object>> queryList(Integer pageNo, Integer pageSize, Map<String, String> query) {
|
if (pageNo == null || pageNo < 1 || pageSize == null || pageSize < 1) {
|
ExceptionCast.cast("参数错误");
|
}
|
IPage<Map> pageData = new Page<Map>(pageNo, pageSize);
|
QueryWrapper<Map> 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<OrderItem> orderItems = new ArrayList<>();
|
orderItems.add(OrderItem.desc("t1.create_time"));
|
((Page<Map>) pageData).setOrders(orderItems);
|
}
|
return super.getBaseMapper().queryList(pageData,queryWrapper);
|
}
|
}
|
