| | |
| | | package com.consum.base.service.impl; |
| | | |
| | | import java.util.HashMap; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | import java.util.Optional; |
| | | import java.util.Set; |
| | | import java.util.stream.Collectors; |
| | | |
| | | import org.springframework.beans.BeanUtils; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | import com.consum.base.Constants; |
| | | import com.consum.base.core.CodeGeneratorService; |
| | | import com.consum.base.core.utils.IdUtil; |
| | |
| | | import com.consum.model.po.BaseWarehouse; |
| | | import com.consum.model.po.FinSysTenant; |
| | | import com.consum.model.po.FinSysTenantDepartment; |
| | | import com.consum.model.po.FinSysTenantUser; |
| | | import com.consum.model.po.SDictData; |
| | | import com.walker.db.page.GenericPager; |
| | | import com.walker.infrastructure.utils.CollectionUtils; |
| | | import com.walker.infrastructure.utils.StringUtils; |
| | | import com.walker.jdbc.service.BaseServiceImpl; |
| | | import java.util.HashMap; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | import java.util.Optional; |
| | | import java.util.Set; |
| | | import java.util.stream.Collectors; |
| | | import org.springframework.beans.BeanUtils; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | /** |
| | | * @Description 仓库管理 |
| | |
| | | * @Date 2023/10/26 |
| | | */ |
| | | @Override |
| | | public GenericPager<BaseWarehouse> queryList(BaseWarehouseParam param) { |
| | | public GenericPager<BaseWarehouse> queryList(BaseWarehouseParam param, FinSysTenantUser currentUser) { |
| | | StringBuilder sql = new StringBuilder("SELECT * FROM base_warehouse WHERE 1 = 1 "); |
| | | HashMap<String, Object> paramts = new HashMap<>(); |
| | | |
| | | //仓库名称 |
| | | if (!StringUtils.isEmpty(param.getWarehouseName())) { |
| | | sql.append(" and WAREHOUSE_NAME like:WAREHOUSE_NAME "); |
| | | paramts.put("WAREHOUSE_NAME", StringUtils.CHAR_PERCENT + param.getWarehouseName() + StringUtils.CHAR_PERCENT); |
| | | paramts.put("WAREHOUSE_NAME", |
| | | StringUtils.CHAR_PERCENT + param.getWarehouseName() + StringUtils.CHAR_PERCENT); |
| | | } |
| | | //类型 |
| | | if (!StringUtils.isEmpty(param.getClassificationCode())) { |
| | |
| | | paramts.put("CLASSIFICATION_CODE", param.getClassificationCode()); |
| | | } |
| | | //机构id |
| | | // 因为仓库是省公司统一维护的,省可以看到全部,地市和县区看自己的 |
| | | if (param.getAgencyId() != null) { |
| | | Integer lv = currentUser.getLv(); |
| | | if (lv != 1) { |
| | | sql.append(" and AGENCY_ID =:AGENCY_ID "); |
| | | paramts.put("AGENCY_ID", param.getAgencyId()); |
| | | } else { |
| | | sql.append(" and AGENCY_ID like :AGENCY_ID "); |
| | | paramts.put("AGENCY_ID", param.getAgencyId() + StringUtils.CHAR_PERCENT); |
| | | } |
| | | } |
| | | //状态 |
| | | if (param.getStates() != null) { |
| | |
| | | */ |
| | | @Override |
| | | public int updateBaseWarehouse(BaseWarehouse baseWarehouse) { |
| | | SDictData SDictData = this.sDictDataService.get(new SDictData(Long.valueOf(baseWarehouse.getClassificationCode()))); |
| | | SDictData SDictData = |
| | | this.sDictDataService.get(new SDictData(Long.valueOf(baseWarehouse.getClassificationCode()))); |
| | | if (SDictData != null) { |
| | | baseWarehouse.setClassificationName(SDictData.getDict_label()); |
| | | } |
| | |
| | | |
| | | } |
| | | |
| | | |
| | | } |
| | | |
| | | /** |
| | |
| | | return select(sql.toString(), paramts, new BaseWarehouse()); |
| | | } |
| | | |
| | | |
| | | /** |
| | | * 根据机构id查询默认仓库 |
| | | * |
| | |
| | | */ |
| | | @Override |
| | | public BaseWarehouse getDefaultWarehouseByAgencyId(Long agencyId) { |
| | | StringBuilder sql = new StringBuilder("SELECT * FROM base_warehouse WHERE IS_DEFAULT = 1 and AGENCY_ID =: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()); |