/* * Copyright (c) 2018-2025, ztt All rights reserved. * * Redistribution and use in source and binary forms, with or without * modification, are permitted provided that the following conditions are met: * * Redistributions of source code must retain the above copyright notice, * this list of conditions and the following disclaimer. * Redistributions in binary form must reproduce the above copyright * notice, this list of conditions and the following disclaimer in the * documentation and/or other materials provided with the distribution. * Neither the name of the pig4cloud.com developer nor the names of its * contributors may be used to endorse or promote products derived from * this software without specific prior written permission. * Author: ztt */ package com.chinaztt.mes.warehouse.mapper; import com.alibaba.fastjson.JSONObject; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.chinaztt.mes.warehouse.dto.*; import com.chinaztt.mes.warehouse.entity.InventoryDetail; import com.chinaztt.mes.warehouse.entity.Stock; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; import java.math.BigDecimal; import java.util.List; /** * 库存表 * * @author cxf * @date 2020-10-22 16:37:46 */ @Mapper public interface StockMapper extends BaseMapper { /** * 分页查询 * * @param page * @param gen * @return */ IPage getStockPage(Page page, @Param("ew") QueryWrapper gen); /** * 统计实时库存数量 * * @param gen * @return */ BigDecimal getSumStockQuantity(@Param("ew") QueryWrapper gen); /** * 根据sn号获取库存明细 * * @param partBatchNo * @return */ List getStockBySn(@Param("partBatchNo") String partBatchNo); /** * 部分页查询 * * @param gen * @return */ List getFeedingStock(@Param("workstationId") Long workstationId, @Param("ew") QueryWrapper gen); /** * 部分页查询 * * @param gen * @return */ List pdaList(@Param("ew") QueryWrapper gen); /** * 分页查询 * * @param page * @param gen * @param partId * @return */ IPage> getStockByPartIdPage(Page page, @Param("ew") QueryWrapper gen, @Param("partId") Long partId); /** * 根据工作站id查询线边仓 * * @param gen * @return */ IPage> getStockByWorkstationId(Page page, @Param("ew") QueryWrapper gen); /** * 根据工作站id查询线边仓待处理物料 * * @param gen * @return */ IPage> getToDealStockByWorkstationId(Page page, @Param("ew") QueryWrapper gen); /** * 根据库位查询零件 * * @param ids * @return */ List getStockByLocation(@Param("ids") List ids); /** * 根据零件、库位和批次号筛选实时库存 * * @param id * @param id1 * @param partBatchNo * @return */ List getStock(@Param("id") Long id, @Param("id1") Long id1, @Param("ew") String partBatchNo,@Param("condition") String condition); /** * 根据零件、库位和批次号筛选实时库存数量 * * @param id * @param id1 * @param partBatchNo * @return */ Integer countStock(@Param("id") Long id, @Param("id1") Long id1, @Param("ew") String partBatchNo,@Param("condition") String condition); /** * 分页查询 * * @param page * @param gen * @param operationTaskId * @return */ IPage> getStockPageByOperation(Page page, @Param("ew") QueryWrapper gen, @Param("operationTaskId") Long operationTaskId); /** * 不分页查询 * * @param gen * @param operationTaskId * @return */ List getStockPageByOperation(@Param("ew") QueryWrapper gen, @Param("operationTaskId") Long operationTaskId); /** * 不分页查询 * * @param gen * @param operationTaskId * @return */ List getStockListByOperation(@Param("ew") QueryWrapper gen, @Param("operationTaskId") Long operationTaskId); /** * 根据产出物料系统编号查询序列号 * @param systemNo * @return */ String getSerialNoBySystemNo(@Param("systemNo") String systemNo); /** * 根据SN号获取可用实时库存对象list * @return */ List getEnableStockObjList(@Param("sn") String sn); /** * 获取可用库位对象list * @return */ List getEnableLocationObjList(); /** * 根据库存id获取MoveLibraryBoxDTO集合 * @param stockId * @return */ List getMoveLibraryBoxDTOListByStockId(@Param("stockId") Long stockId); /** * 根据库存id查找对应的车间订单 * @param id * @return */ String getStockMoNo(@Param("id") Long id); /** * 根据仓库，库位号，零件查找实时库存 * @param locationIds * @param warehouseIds * @param partId * @return */ List getStockByInventory(@Param("locationIds") List locationIds,@Param("warehouseIds") List warehouseIds,@Param("partId") Long partId); /* * 根据零件批次号，零件id查询是否工序库存 * @param outBatchNo * @param partId * @return */ List getStockOperationStatus(@Param("outBatchNo") String outBatchNo, @Param("partId") Long partId, @Param("systemNo") String systemNo); /** * 查找检测合格库位库存 * @param sn * @param partNo * @return */ List getFinishProductStock(@Param("sn") String sn,@Param("partNo") String partNo); /* * 根据locationId，sn查询库存表 * @param locationId * @param sn * @return */ List getStockByLocIdAndSn(@Param("locationId") Long locationId, @Param("sn") String sn); /** * 分页查询出库位尾号为001的 * * @param page * @param gen * @return */ IPage> getStockPageByLocNo(Page page, @Param("ew") QueryWrapper gen); /** * 获取成品库库存 * @param partBatchNo * @param partId * @return */ int getFinishLocationProduct(@Param("partBatchNo") String partBatchNo,@Param("partId") Long partId); /** * 根据sn号获取馈线合格证信息 * @param sn * @param locationIdList * @return */ FeederCertificateDTO getFeederCertificate(@Param("sn")String sn,@Param("locationIdList")List locationIdList); /** * 根据sn号获取车间订单信息 * @param snList * @return */ List getFeederManufacturingOrder(@Param("snList") List snList); /** * 根据仓库，库位号，零件查找报工产出 * @param locationIds * @param warehouseIds * @param partId * @return */ List getProductionByInventory(@Param("locationIds") List locationIds,@Param("warehouseIds") List warehouseIds,@Param("partId") Long partId); /** * 根据sn号获取库存信息 * @param snList * @return */ List getStockBySnList(@Param("snList")List snList); }