¶Ô±ÈÐÂÎļþ |
| | |
| | | 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 com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
| | | import org.apache.commons.lang.StringUtils; |
| | | import org.jeecg.common.exception.ExceptionCast; |
| | | import org.jeecg.modules.tms.entity.ToolsStocktakingBoundDetail; |
| | | import org.jeecg.modules.tms.mapper.ToolsStocktakingBoundDetailMapper; |
| | | import org.jeecg.modules.tms.service.IToolsStocktakingBoundDetailService; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | import java.util.ArrayList; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | |
| | | /** |
| | | * @Description: çç¹åæç» |
| | | * @Author: houjie |
| | | * @Date: 2025-05-16 |
| | | * @Version: V1.0 |
| | | */ |
| | | @Service |
| | | public class ToolsStocktakingBoundDetailServiceImpl extends ServiceImpl<ToolsStocktakingBoundDetailMapper, ToolsStocktakingBoundDetail> implements IToolsStocktakingBoundDetailService { |
| | | |
| | | @Autowired |
| | | private ToolsStocktakingBoundDetailMapper toolsStocktakingBoundDetailMapper; |
| | | |
| | | public IPage<ToolsStocktakingBoundDetail> selectByMainId(Page<ToolsStocktakingBoundDetail> page, Map<String, String[]> parameterMap) { |
| | | QueryWrapper<ToolsStocktakingBoundDetail> queryWrapper = Wrappers.query(); |
| | | |
| | | String[] stocktakingBoundIds = parameterMap.get("stocktakingBoundId"); |
| | | if (stocktakingBoundIds != null && stocktakingBoundIds.length > 0) { |
| | | queryWrapper.eq("t.stocktaking_bound_id", stocktakingBoundIds[0]); |
| | | } |
| | | return toolsStocktakingBoundDetailMapper.selectByMainId(page, queryWrapper); |
| | | } |
| | | |
| | | @Override |
| | | public IPage<Map<String, Object>> toolsStocktakingList(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 classifyId = query.get("classifyId"); |
| | | if (StringUtils.isNotBlank(classifyId)) { |
| | | queryWrapper.eq("t3.classify_id", classifyId); |
| | | } |
| | | String toolCode = query.get("toolCode"); |
| | | if (StringUtils.isNotBlank(toolCode)) { |
| | | queryWrapper.like("t3.tool_code", toolCode); |
| | | } |
| | | String toolModel = query.get("toolModel"); |
| | | if (StringUtils.isNotBlank(toolModel)) { |
| | | queryWrapper.like("t3.tool_mode", toolModel); |
| | | } |
| | | // æåºåæ³ |
| | | List<OrderItem> orderItems = new ArrayList<>(); |
| | | orderItems.add(OrderItem.desc("t1.create_time")); |
| | | ((Page<Map>) pageData).setOrders(orderItems); |
| | | } |
| | | return super.getBaseMapper().toolsStocktakingList(pageData,queryWrapper); |
| | | } |
| | | |
| | | } |