From ceecebe477faf5a45b19f3b258f7add8f93b4583 Mon Sep 17 00:00:00 2001 From: futian.liu <liufutianyoo@163.com> Date: 星期二, 05 十二月 2023 10:00:24 +0800 Subject: [PATCH] 代码优化 结构调整 --- consum-base/src/main/java/com/consum/base/service/LWhFormInventoryServiceImpl.java | 261 ++++++++++++++++++++++++++++----------------------- 1 files changed, 142 insertions(+), 119 deletions(-) diff --git a/consum-base/src/main/java/com/consum/base/service/LWhFormInventoryServiceImpl.java b/consum-base/src/main/java/com/consum/base/service/LWhFormInventoryServiceImpl.java index df1ea64..e0c1238 100644 --- a/consum-base/src/main/java/com/consum/base/service/LWhFormInventoryServiceImpl.java +++ b/consum-base/src/main/java/com/consum/base/service/LWhFormInventoryServiceImpl.java @@ -3,16 +3,21 @@ import com.consum.base.core.CodeGeneratorEnum; import com.consum.base.core.CodeGeneratorService; import com.consum.base.core.utils.IdUtil; -import com.consum.base.core.utils.MapRowMapper; import com.consum.base.core.utils.MapUtils; import com.consum.base.core.utils.MapperUtil; +import com.consum.base.core.utils.PageUtil; +import com.consum.base.pojo.excel.InventoryExcelTemplate; +import com.consum.base.pojo.query.LWhFormInventoryQry; import com.consum.base.pojo.request.FormInventoryParam; import com.consum.base.pojo.request.LWhFormInventoryParam; +import com.consum.base.pojo.response.FormInventoryDetailVO; import com.consum.base.pojo.response.FormInventoryGoodsVO; import com.consum.base.pojo.response.FormInventoryVO; import com.consum.model.po.BaseWarehouse; +import com.consum.model.po.FinSysTenant; import com.consum.model.po.FinSysTenantUser; import com.consum.model.po.LWhFormInventory; +import com.iplatform.model.po.S_user_core; import com.walker.db.page.GenericPager; import com.walker.infrastructure.utils.DateUtils; import com.walker.infrastructure.utils.StringUtils; @@ -24,7 +29,9 @@ import org.apache.commons.compress.utils.Lists; import org.springframework.beans.BeanUtils; import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.context.annotation.Lazy; import org.springframework.stereotype.Service; +import org.springframework.transaction.annotation.Transactional; import org.springframework.util.CollectionUtils; /** @@ -34,20 +41,21 @@ */ @Slf4j @Service -public class LWhFormInventoryServiceImpl extends BaseServiceImpl { +public class LWhFormInventoryServiceImpl extends BaseServiceImpl implements LWhFormInventoryService { @Autowired private CodeGeneratorService codeGeneratorService; @Autowired - private BaseWarehouseServiceImpl baseWarehouseService; - @Autowired - private FinSysTenantUserServiceImpl finSysTenantUserService; + private BaseWarehouseService baseWarehouseService; @Autowired private LWhFormInventoryGoodsServiceImpl inventoryGoodsService; @Autowired - private BaseGoodsTemplateServiceImpl baseGoodsTemplateService; - @Autowired private LWhGoodsService lWhGoodsService; + @Autowired + private FinSysTenantServiceImpl finSysTenantService; + @Autowired + @Lazy + private LWhFormInventoryCoreService lWhFormInventoryCoreService; private static final String QUERY_LIST = "select * from l_wh_form_inventory where 1=1 "; @@ -60,10 +68,10 @@ + "left join base_goods_template bgt on bgt.ID = model.GOODS_TEMPLATES_ID; "; private static final String QUERY_PD_DETAIL_LIST = - "select lwfi.WAREHOUSE_NAME,lwfig.GOODS_TEMPLATE_NAME,\n" + " lwfig.BASE_GOODS_MODELS_NAME,\n" + " lwfig.INVENTORY_RESULT,\n" - + " lwfig.INIT_COUNTS,\n" + " lwfig.INVENTORY_COUNTS,\n" + " lwfig.ERROR_COUNTS,\n" + " lwfi.AGENCY_NAME,\n" - + " lwfi.OPERATOR_NAME,\n" + " lwfi.STOP_TIME\n" + "from l_wh_form_inventory lwfi\n" - + " inner join l_wh_form_inventory_goods lwfig on lwfi.ID = lwfig.WH_FORM_INVENTORY_ID "; + "SELECT fig.id,fi.WAREHOUSE_NAME,fig.GOODS_TEMPLATE_NAME,fig.BASE_GOODS_MODELS_NAME,fig.INVENTORY_RESULT,fig.INIT_COUNTS,fig.INVENTORY_COUNTS," + + "fig.ERROR_COUNTS,fi.AGENCY_NAME,fi.OPERATOR_NAME,fi.STOP_TIME operatorTime," + + "CASE WHEN fig.INVENTORY_RESULT = 2 THEN fi.IN_BUSINESS_FORM_CODE WHEN fig.INVENTORY_RESULT = 3 THEN fi.OUT_BUSINESS_FORM_CODE END warehouseFormCode " + + "FROM l_wh_form_inventory fi INNER JOIN l_wh_form_inventory_goods fig ON fi.ID = fig.WH_FORM_INVENTORY_ID where 1=1 "; /** * @param param @@ -75,6 +83,7 @@ * @Author 鍗㈠簡闃� * @Date 2023/10/31 */ + @Override public int add(FormInventoryParam param, FinSysTenantUser currentUser, FinSysTenantUser operatorUser, FinSysTenantUser monitorUser) { //鏂板鐩樼偣鍗� LWhFormInventory lWhFormInventory = new LWhFormInventory(); @@ -99,7 +108,8 @@ lWhFormInventory.setStates(0); lWhFormInventory.setAgencyId(Long.valueOf(currentUser.getTenantId())); - lWhFormInventory.setAgencyName(currentUser.getTenantName()); + FinSysTenant finSysTenant = finSysTenantService.selectById(Long.valueOf(currentUser.getTenantId())); + lWhFormInventory.setAgencyName(finSysTenant.getName()); lWhFormInventory.setCreatorId(currentUser.getSysUserId()); lWhFormInventory.setCreatorName(currentUser.getUserName()); lWhFormInventory.setCreateTime(DateUtils.getDateTimeNumber(System.currentTimeMillis())); @@ -112,7 +122,8 @@ * @Author 鍗㈠簡闃� * @Date 2023/10/31 */ - public GenericPager<LWhFormInventory> queryList(com.consum.base.pojo.LWhFormInventoryParam param, FinSysTenantUser sysInfo) { + @Override + public GenericPager<LWhFormInventory> queryList(LWhFormInventoryQry param, FinSysTenantUser sysInfo) { StringBuilder sql = new StringBuilder(QUERY_LIST); HashMap<String, Object> paramts = new HashMap<>(); @@ -148,48 +159,66 @@ return selectSplit(sql.toString(), paramts, new LWhFormInventory()); } - /** - * @param id 鐩樼偣鍗昳d - * @Description 鐩樼偣 - * @Author 鍗㈠簡闃� - * @Date 2023/10/31 - */ - public List queryPdList(Long id) { + + @Override + public FormInventoryVO saveInventory(FormInventoryVO dto, Long id) { //1.鏍规嵁鐩樼偣鍗昳d鏌ヨ鐩樼偣鍗� LWhFormInventory lWhFormInventory = this.get(new LWhFormInventory(id)); if (lWhFormInventory == null) { - log.error("鐩樼偣澶辫触"); + log.error("鏍规嵁鐩樼偣鍗昳d鏌ヨ鐩樼偣鍗曞け璐�"); } - //2.鏌ヨ鐩樼偣鍗曟暟鎹� - List<Map<String, Object>> list = this.select(QUERY_PD_List, new Object[]{lWhFormInventory.getWarehouseId()}); - if (CollectionUtils.isEmpty(list)) { - log.error("鐩樼偣澶辫触"); - return null; + //2.淇敼鐩樼偣鍗� + lWhFormInventory.setStates(1); + lWhFormInventory.setInventoryDate(DateUtils.getDateTimeNumber(System.currentTimeMillis())); + int flag1 = this.update(lWhFormInventory); + if (flag1 == 0) { + log.error("淇敼鐩樼偣鍗曞け璐�"); } - //3.鏂板鐩樼偣鍗曠墿鍝佽褰� -// int flag = inventoryGoodsService.add(list, lWhFormInventory.getWarehouseId()); -// if (flag != list.size()) { -// log.error("鏂板鐩樼偣鍗曡褰�"); -// return null; -// } - //4.鏍规嵁鐩樼偣鍗昳d鏌ヨ鐩樼偣鍗曠墿鍝� - return inventoryGoodsService.getByInventoryId(id); + //3.娣诲姞鐩樼偣鍗曠墿鍝� + List<FormInventoryGoodsVO> formInventoryGoodsList = dto.getFormInventoryGoodsList(); + if (CollectionUtils.isEmpty(formInventoryGoodsList)) { + log.error("鐩樼偣鍗曠墿鍝佷负绌�"); + } + List<FormInventoryGoodsVO> result = inventoryGoodsService.add(formInventoryGoodsList, id); + dto.setFormInventoryGoodsList(result); + return dto; } + /** - * 鏆傚瓨 + * 淇濆瓨鐩樼偣淇℃伅 * * @author 鍗㈠簡闃� * @date 2023/10/31 */ - public int temporaryStorage(LWhFormInventoryParam dto, Integer state) { + @Transactional(rollbackFor = Exception.class) + @Override + public int updateInventoryInfo(LWhFormInventoryParam dto, Integer state, S_user_core currentUser, FinSysTenantUser sysInfo) { //1.鏍规嵁鐩樼偣鍗昳d鏌ヨ鐩樼偣鍗� LWhFormInventory lWhFormInventory = this.get(new LWhFormInventory(dto.getId())); if (lWhFormInventory == null) { log.error("鏍规嵁鐩樼偣鍗昳d鏌ヨ鐩樼偣鍗曞け璐�"); return 0; } - //2.淇敼鐩樼偣鍗� + //娣诲姞鐩樼偣鍗曠墿鍝� + List<FormInventoryGoodsVO> inventoryGoodsList = dto.getInventoryGoodsList(); + if (CollectionUtils.isEmpty(inventoryGoodsList)) { + log.error("鐩樼偣鍗曠墿鍝佷负绌�"); + return 0; + } + this.inventoryGoodsService.updateInventoryGoods(inventoryGoodsList); + //淇敼鐩樼偣鍗� + if (state == 2) { + //瀹屾垚鐩樼偣鏃惰缃畬鎴愮洏鐐规椂闂� + lWhFormInventory.setStopTime(DateUtils.getDateTimeNumber(System.currentTimeMillis())); + + //瀹屾垚鐩樼偣鏃惰缃畬鎴愮洏鐐规椂闂� + String inOutFormByInventoryId = lWhFormInventoryCoreService.createInOutFormByInventoryId(dto.getId(), currentUser, sysInfo); + if (!StringUtils.isEmpty(inOutFormByInventoryId)) { + log.error(inOutFormByInventoryId); + return 0; + } + } lWhFormInventory.setStates(state); lWhFormInventory.setInventoryDate(DateUtils.getDateTimeNumber(System.currentTimeMillis())); int flag1 = this.update(lWhFormInventory); @@ -197,65 +226,10 @@ log.error("淇敼鐩樼偣鍗曞け璐�"); return 0; } - //3.娣诲姞鐩樼偣鍗曠墿鍝� - List<FormInventoryGoodsVO> inventoryGoodsList = dto.getInventoryGoodsList(); - if (CollectionUtils.isEmpty(inventoryGoodsList)) { - log.error("鐩樼偣鍗曠墿鍝佷负绌�"); - return 0; - } - int flag2 = inventoryGoodsService.add(inventoryGoodsList, lWhFormInventory.getWarehouseId()); - if (flag2 != inventoryGoodsList.size()) { - log.error("鏇存柊鐩樼偣鍗曠墿鍝佸け璐�"); - return 0; - } + return 1; } - /** - * 瀹屾垚鐩樼偣 - * - * @author 鍗㈠簡闃� - * @date 2023/10/31 - */ -// public int finishPd(LWhFormInventoryParam dto) { -// //1.鏍规嵁鐩樼偣鍗昳d鏌ヨ鐩樼偣鍗� -// LWhFormInventory lWhFormInventory = this.get(new LWhFormInventory(dto.getId())); -// if (lWhFormInventory == null) { -// log.error("鏍规嵁鐩樼偣鍗昳d鏌ヨ鐩樼偣鍗� 澶辫触"); -// return 0; -// } -// //2.淇敼鐩樼偣鍗� -// lWhFormInventory.setStates(2); -// lWhFormInventory.setStopTime(DateUtils.getDateTimeNumber(System.currentTimeMillis())); -// int flag1 = this.update(lWhFormInventory); -// if (flag1 == 0) { -// log.error("淇敼鐩樼偣鍗� 澶辫触"); -// return 0; -// } -// //3.鏇存柊鐩樼偣鍗曠墿鍝� -// List<LWhFormInventoryGoods> inventoryGoodsList = dto.getInventoryGoodsList(); -// if (CollectionUtils.isEmpty(inventoryGoodsList)) { -// log.error("鐩樼偣鍗曠墿鍝� 涓虹┖"); -// return 0; -// } -// for (LWhFormInventoryGoods inventoryGoods : inventoryGoodsList) { -// int errorCounts = inventoryGoods.getInitCounts() - inventoryGoods.getInventoryCounts(); -// if (errorCounts > 0) { -// inventoryGoods.setInventoryResult(3); -// } else if (errorCounts < 0) { -// inventoryGoods.setInventoryResult(2); -// } else { -// inventoryGoods.setInventoryResult(1); -// } -// inventoryGoods.setErrorCounts(Math.abs(errorCounts)); -// } -// int flag2 = inventoryGoodsService.update(inventoryGoodsList); -// if (flag2 != inventoryGoodsList.size()) { -// log.error("鏇存柊鐩樼偣鍗曠墿鍝� 澶辫触"); -// return 0; -// } -// return 1; -// } /** * @return @@ -263,7 +237,8 @@ * @Author 鍗㈠簡闃� * @Date 2023/11/1 */ - public GenericPager<Map<String, Object>> queryPdDetailList(com.consum.base.pojo.LWhFormInventoryParam param, FinSysTenantUser sysInfo) { + @Override + public PageUtil<FormInventoryDetailVO> queryPdDetailList(LWhFormInventoryQry param, FinSysTenantUser sysInfo) { StringBuilder sql = new StringBuilder(QUERY_PD_DETAIL_LIST); HashMap<String, Object> paramts = new HashMap<>(); @@ -276,60 +251,69 @@ } //浠撳簱缂栧彿 if (param.getWarehouseId() != null) { - sql.append(" and WAREHOUSE_ID =:WAREHOUSE_ID "); + sql.append("and WAREHOUSE_ID =:WAREHOUSE_ID "); paramts.put("WAREHOUSE_ID", param.getWarehouseId()); } //鐗╁搧鍚嶇О if (!StringUtils.isEmpty(param.getGoodsTemplateName())) { - sql.append(" and GOODS_TEMPLATE_NAME =:GOODS_TEMPLATE_NAME "); + sql.append("and GOODS_TEMPLATE_NAME =:GOODS_TEMPLATE_NAME "); paramts.put("GOODS_TEMPLATE_NAME", StringUtils.CHAR_PERCENT + param.getGoodsTemplateName() + StringUtils.CHAR_PERCENT); } //瑙勬牸鍨嬪彿 if (param.getBaseGoodsModelsId() != null) { - sql.append(" and BASE_GOODS_MODELS_ID =:BASE_GOODS_MODELS_ID "); + sql.append("and BASE_GOODS_MODELS_ID =:BASE_GOODS_MODELS_ID "); paramts.put("BASE_GOODS_MODELS_ID", param.getBaseGoodsModelsId()); } //绫诲瀷(鍑哄叆搴撶被鍨�) Integer inventoryResult = param.getInventoryResult(); if (inventoryResult != null) { - sql.append(" and INVENTORY_RESULT =:INVENTORY_RESULT "); + sql.append("and INVENTORY_RESULT =:INVENTORY_RESULT "); paramts.put("INVENTORY_RESULT", inventoryResult); } //鍑哄叆搴撳崟鍙� if (param.getWarehouseFormCode() != null) { - if (inventoryResult == 2) { //鐩樼泩鍏ュ簱 - sql.append(" and IN_BUSINESS_FORM_CODE =:IN_BUSINESS_FORM_CODE "); - paramts.put("IN_BUSINESS_FORM_CODE", StringUtils.CHAR_PERCENT + param.getWarehouseFormCode() + StringUtils.CHAR_PERCENT); - } else { //鐩樹簭鍑哄簱 - sql.append(" and OUT_BUSINESS_FORM_CODE =:OUT_BUSINESS_FORM_CODE "); - paramts.put("OUT_BUSINESS_FORM_CODE", StringUtils.CHAR_PERCENT + param.getWarehouseFormCode() + StringUtils.CHAR_PERCENT); - } + sql.append( + " and CASE WHEN fig.INVENTORY_RESULT = 2 THEN fi.IN_BUSINESS_FORM_CODE =:warehouseFormCode WHEN fig.INVENTORY_RESULT = 3 THEN fi.OUT_BUSINESS_FORM_CODE =:warehouseFormCode END "); + paramts.put("warehouseFormCode", param.getWarehouseFormCode()); } //鎿嶄綔浜� if (!StringUtils.isEmpty(param.getOperatorName())) { - sql.append(" and OPERATOR_NAME =:OPERATOR_NAME "); + sql.append("and OPERATOR_NAME =:OPERATOR_NAME "); paramts.put("OPERATOR_NAME", StringUtils.CHAR_PERCENT + param.getOperatorName() + StringUtils.CHAR_PERCENT); } //缁撴潫鏃堕棿 - if (param.getStopTimeStart() != null) { - sql.append(" and STOP_TIME >=:stopTimeStart "); - paramts.put("stopTimeStart", param.getStopTimeStart() * 1000000); + if (param.getStartTime() != null) { + sql.append("and STOP_TIME >=:stopTimeStart "); + paramts.put("stopTimeStart", param.getStartTime() * 1000000); } - if (param.getStopTimeEnd() != null) { - sql.append(" and STOP_TIME <:stopTimeEnd "); - paramts.put("stopTimeEnd", param.getStopTimeEnd() * 1000000 + 240000); + if (param.getEndTime() != null) { + sql.append("and STOP_TIME <:stopTimeEnd "); + paramts.put("stopTimeEnd", param.getEndTime() * 1000000 + 240000); } - - sql.append(" ORDER BY CREATE_TIME DESC "); - - return selectSplit(sql.toString(), paramts, param.getPageNum(), param.getPageSize(), new MapRowMapper()); + sql.append("AND fig.INVENTORY_RESULT in(2,3) "); + sql.append("ORDER BY CREATE_TIME DESC "); + GenericPager<Map<String, Object>> mapGenericPager = selectSplit(sql.toString(), paramts, param.getPageNum(), param.getPageSize(), new MapperUtil()); + PageUtil<FormInventoryDetailVO> pageUtil = new PageUtil<>(mapGenericPager); + List<FormInventoryDetailVO> result = Lists.newArrayList(); + mapGenericPager.getDatas().forEach(item -> { + FormInventoryDetailVO formInventoryDetailVO = MapUtils.convertMapToObj(item, FormInventoryDetailVO.class); + formInventoryDetailVO.setInventoryResultType( + formInventoryDetailVO.getInventoryResult() == null ? null : (formInventoryDetailVO.getInventoryResult() == 2 ? "鐩樼泩" : "鐩樹簭")); + formInventoryDetailVO.setInventoryType( + formInventoryDetailVO.getInventoryResult() == null ? null : (formInventoryDetailVO.getInventoryResult() == 2 ? "鐩樼泩鍏ュ簱" : "鐩樹簭鍑哄簱")); + formInventoryDetailVO.setWarehouseFormCode(formInventoryDetailVO.getWarehouseFormCode()); + result.add(formInventoryDetailVO); + }); + pageUtil.setDatas(result); + return pageUtil; } + @Override public List<FormInventoryGoodsVO> selectDetailById(Long id) { String sql = "select fig.id, fig.BASE_GOODS_TEMPLATE_ID,fig.GOODS_TEMPLATE_NAME,fig.BASE_GOODS_MODELS_NAME," - + "fig.INIT_COUNTS total,fig.INVENTORY_COUNTS,fig.INVENTORY_RESULT status from " - + "l_wh_form_inventory_goods fig where fig.WH_FORM_INVENTORY_ID = :id"; + + "fig.INIT_COUNTS inventoryCount,fig.INVENTORY_COUNTS realNum,fig.INVENTORY_RESULT status,fig.unit,bgt.CLASSIFICATION type from " + + "l_wh_form_inventory_goods fig left join base_goods_template bgt on bgt.id =fig.BASE_GOODS_TEMPLATE_ID where fig.WH_FORM_INVENTORY_ID = :id"; HashMap<String, Object> param = new HashMap<>(); param.put("id", id); List<Map<String, Object>> select = select(sql, param, new MapperUtil()); @@ -341,6 +325,7 @@ return result; } + @Override public FormInventoryVO queryInventBaseGoodTemplate(Long id) { FormInventoryVO formInventoryVO = new FormInventoryVO(); @@ -359,7 +344,8 @@ formInventoryVO.setWarehouseName(inventory.getWarehouseName()); String sql = - "select bgm.id,bgt.id baseGoodsTemplateId,bgt.GOODS_NAME goodsTemplateName,bgm.MODEL_NAME baseGoodsModelsName,bgt.CLASSIFICATION type,bgm.UNIT from base_goods_models bgm left join base_goods_template bgt on bgm.GOODS_TEMPLATES_ID = bgt.id " + "select bgt.id baseGoodsTemplateId,bgt.GOODS_NAME goodsTemplateName,bgm.MODEL_NAME baseGoodsModelsName,bgt.CLASSIFICATION type,bgm.UNIT " + + "from base_goods_models bgm left join base_goods_template bgt on bgm.GOODS_TEMPLATES_ID = bgt.id " + "where bgt.AGENCY_ID = :agencyId"; HashMap<String, Object> param = new HashMap<>(); param.put("agencyId", inventory.getAgencyId()); @@ -374,4 +360,41 @@ formInventoryVO.setFormInventoryGoodsList(goodsVOList); return formInventoryVO; } + + @Override + public List<InventoryExcelTemplate> getExportList(Long id) { + String sql = "SELECT\n" + + "\tfi.INVENTORY_DATE createTime,\n" + + "\tfi.STOP_TIME endTime,\n" + + "\tfi.OPERATOR_NAME,\n" + + "\tfi.OPERATOR_NAME2 monitorName,\n" + + "\tfi.AGENCY_NAME tenantName,\n" + + "\tfig.GOODS_TEMPLATE_NAME templateName,\n" + + "\tfig.BASE_GOODS_MODELS_NAME baseModelName,\n" + + "\tfig.INVENTORY_COUNTS num,\n" + + "\tfig.INIT_COUNTS stockNum,\n" + + "\tfig.INVENTORY_RESULT,\n" + + "\tBEIZ1 remark\n" + + "FROM\n" + + "\tl_wh_form_inventory fi\n" + + "\tLEFT JOIN l_wh_form_inventory_goods fig ON fi.ID = fig.WH_FORM_INVENTORY_ID\n" + + "WHERE\n" + + "\tfi.ID = :id"; + HashMap<String, Object> param = new HashMap<>(); + param.put("id", id); + List<Map<String, Object>> select = this.select(sql, param, new MapperUtil()); + if (CollectionUtils.isEmpty(select)) { + return null; + } + List<InventoryExcelTemplate> list = Lists.newArrayList(); + select.forEach(item -> { + InventoryExcelTemplate inventoryExcelTemplate = MapUtils.convertMapToObj(item, InventoryExcelTemplate.class); + inventoryExcelTemplate.setInventoryDeception(inventoryExcelTemplate.getInventoryResult() == 1 ? "鏄�" : "鍚�"); + inventoryExcelTemplate.setDeception( + inventoryExcelTemplate.getInventoryResult() == 1 ? "姝e父" : (inventoryExcelTemplate.getInventoryResult() == 2 ? "鐩樼泩" : "鐩樹簭")); + list.add(inventoryExcelTemplate); + }); + return list; + + } } -- Gitblit v1.9.1