| | |
| | | * @Date 2023/10/27 |
| | | */ |
| | | @Override |
| | | public List<BaseWarehouse> getBaseWareHouseList(Long agencyId, Short states) { |
| | | public List<BaseWarehouse> getBaseWareHouseList(Long agencyId, Integer states) { |
| | | StringBuilder sql = new StringBuilder("SELECT * FROM base_warehouse WHERE 1 = 1 "); |
| | | HashMap<String, Object> paramts = new HashMap<>(); |
| | | |
| | |
| | | paramts.put("states", states); |
| | | } |
| | | return select(sql.toString(), paramts, new BaseWarehouse()); |
| | | } |
| | | |
| | | /** |
| | | * 根据机构id查询默认仓库 |
| | | * |
| | | * @param agencyId |
| | | * @return |
| | | */ |
| | | @Override |
| | | public BaseWarehouse getDefaultWarehouseByAgencyId(Long agencyId) { |
| | | StringBuilder sql = |
| | | new StringBuilder("SELECT * FROM base_warehouse WHERE IS_DEFAULT = 1 and AGENCY_ID =:agencyId "); |
| | | Map<String, Object> param = new HashMap<>(); |
| | | param.put("agencyId", agencyId); |
| | | List<BaseWarehouse> select = select(sql.toString(), param, new BaseWarehouse()); |
| | | BaseWarehouse baseWarehouse = select.stream().findFirst().orElse(null); |
| | | return baseWarehouse; |
| | | } |
| | | |
| | | @Override |