| | |
|---|
| | | } |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | public List<GoodsInfoDTO> queryGoodsInfo(Set<Long> baseModelIds) { |
|---|
| | | public List<GoodsInfoDTO> queryGoodsInfo(Set<Long> baseModelIds, Set<Long> wareHouseIds) { |
|---|
| | | |
|---|
| | | List<GoodsInfoDTO> goodsInfoDTOS = Lists.newArrayList(); |
|---|
| | | StringBuilder sql = new StringBuilder( |
|---|
| | | "SELECT distinct WAREHOUSE_ID,WAREHOUSE_NAME from L_WH_GOODS where base_goods_models_id in (:baseGoodsModelsIds) " |
|---|
| | | + "and WAREHOUSE_TYPE =0 and BUY_TYPE =1 and states =1"); |
|---|
| | | + "and WAREHOUSE_TYPE =0 and BUY_TYPE =1 and states =1 and WAREHOUSE_ID in (:wareHouseIds)"); |
|---|
| | | Map<String, Object> param = new HashMap<>(); |
|---|
| | | param.put("baseGoodsModelsIds", baseModelIds); |
|---|
| | | param.put("wareHouseIds", wareHouseIds); |
|---|
| | | List<Map<String, Object>> result = this.select(sql.toString(), param, new MapperUtil()); |
|---|
| | | result.forEach(item -> { |
|---|
| | | GoodsInfoDTO goodsInfoDTO = MapUtils.convertMapToObj(item, GoodsInfoDTO.class); |
|---|
