| | |
| | | package com.consum.base.service; |
| | | |
| | | import com.walker.jdbc.service.BaseServiceImpl; |
| | | import org.springframework.stereotype.Service; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | |
| | | import com.consum.base.pojo.dto.GoodsModelCountDTO; |
| | | import com.walker.jdbc.service.BaseService; |
| | | |
| | | /** |
| | | * @ClassName LWhGoodsService |
| | | * @Author cy |
| | | * @Date 2023/10/24 |
| | | * @Description |
| | | * @Version 1.0 |
| | | * LWhGoodsService |
| | | * |
| | | * @author asus |
| | | * @version 2023/12/05 13:52 |
| | | **/ |
| | | @Service |
| | | public class LWhGoodsService extends BaseServiceImpl { |
| | | public interface LWhGoodsService extends BaseService { |
| | | int queryGoodsModelNum(Integer warehouseType, Long warehouseId, Long baseGoodsModelsId, Integer states, |
| | | Integer buyType); |
| | | |
| | | List<Map<String, Object>> queryOutGoods(Integer warehouseType, Long warehouseId, Long baseGoodsModelsId, |
| | | Integer states, Integer buyType, Integer goodsModelNum); |
| | | |
| | | List<Long> queryOutGoodsId(Integer warehouseType, Long warehouseId, Long baseGoodsModelsId, Integer states, |
| | | Integer buyType, Integer goodsModelNum); |
| | | |
| | | long queryGoodsPriceById(List<Long> goodsIds); |
| | | |
| | | List<Map<String, Object>> queryScrappedGoods(Integer warehouseType, Long warehouseId, Long transBusinessId, |
| | | String nowUserName, Long baseGoodsModelsId, Short states, Integer goodsModelNum); |
| | | |
| | | List<Long> queryScrappedGoodsIds(Integer warehouseType, Long warehouseId, Long transBusinessId, String nowUserName, |
| | | Long baseGoodsModelsId, Short states, Integer goodsModelNum); |
| | | |
| | | int modGoodsTransfering(List<Long> whGoods, Integer warehouseType, Long toWarehouseId, String toWarehouseName, |
| | | Integer states); |
| | | |
| | | // 按机构统计物品价值、数量/金额等 |
| | | List<Map<String, Object>> getGoodsNumPrice(Long agencyId); |
| | | |
| | | // 按机构统计物品价值、数量/金额等 |
| | | List<Map<String, Object>> getGoodsNumByMonth(Long agencyId); |
| | | |
| | | /** |
| | | * @param warehouseId 所属仓库仓库编号 |
| | | * @param baseGoodsModelsId 规格型号编号 |
| | | * @param states (0=在途调拨;1=入库未分发;2=已下发;3=报废) |
| | | * @return 查询某个型号在仓库中的数量 |
| | | * 根据型号查询商品总价 |
| | | * |
| | | * @param baseGoodsModelsId |
| | | * @param type <br> |
| | | * 状态(0=在途调拨;1=入库未分发;2=已下发;3=报废 4 零星出库 |
| | | * @return |
| | | */ |
| | | private static String query_Goods_Model_Num = ""; |
| | | |
| | | public int queryGoodsModelNum(long warehouseId, long baseGoodsModelsId, Short states) { |
| | | |
| | | |
| | | return 0; |
| | | } |
| | | GoodsModelCountDTO queryGoodsAmount(Long baseGoodsModelsId, Integer type); |
| | | } |