From 01107e8aadfaf1e84a971d8eeb9ab37e1c5569f3 Mon Sep 17 00:00:00 2001
From: cy <1664593601@qq.com>
Date: 星期五, 01 十二月 2023 09:38:56 +0800
Subject: [PATCH] feat: 部门退回/报废公用接口
---
consum-base/src/main/java/com/consum/base/service/LWhFormScrappedServiceImpl.java | 361 ++++++++++++++++++++++++++++++++-------------------
1 files changed, 224 insertions(+), 137 deletions(-)
diff --git a/consum-base/src/main/java/com/consum/base/service/LWhFormScrappedServiceImpl.java b/consum-base/src/main/java/com/consum/base/service/LWhFormScrappedServiceImpl.java
index 59f876e..5fb144f 100644
--- a/consum-base/src/main/java/com/consum/base/service/LWhFormScrappedServiceImpl.java
+++ b/consum-base/src/main/java/com/consum/base/service/LWhFormScrappedServiceImpl.java
@@ -2,25 +2,32 @@
import com.consum.base.core.CodeGeneratorEnum;
import com.consum.base.core.CodeGeneratorService;
-import com.consum.base.core.tools.MapRowMapper;
-import com.consum.base.pojo.*;
-import com.consum.base.util.IdUtil;
+import com.consum.base.core.utils.IdUtil;
+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.LWhFormScrappedGoodsInfoParam;
+import com.consum.base.pojo.LWhFormScrappedGoodsModelParams;
+import com.consum.base.pojo.LWhFormScrappedParam;
+import com.consum.base.pojo.excel.ScrappedInfoExcelTemplate;
+import com.consum.base.pojo.query.LWhFormScrappedQry;
+import com.consum.base.pojo.response.FormScrappedGoodsDetailVO;
+import com.consum.base.pojo.response.FormScrappedGoodsVO;
+import com.consum.base.pojo.response.GoodsModelVO;
+import com.consum.base.pojo.response.LWhFormScrappedExtendVO;
import com.consum.model.po.*;
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;
import com.walker.jdbc.service.BaseServiceImpl;
+import org.apache.commons.compress.utils.Lists;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.interceptor.TransactionAspectSupport;
import org.springframework.util.CollectionUtils;
-import java.util.ArrayList;
-import java.util.HashMap;
-import java.util.List;
-import java.util.Map;
+import java.util.*;
import java.util.stream.Collectors;
/**
@@ -30,6 +37,7 @@
*/
@Service
public class LWhFormScrappedServiceImpl extends BaseServiceImpl {
+
@Autowired
private CodeGeneratorService codeGeneratorService;
@Autowired
@@ -49,29 +57,22 @@
@Autowired
private LWhFormScrappedCoreService lWhFormScrappedCoreService;
- private static String QUERY_LIST = "SELECT * FROM l_wh_form_scrapped WHERE 1 = 1";
+ private static String QUERY_LIST = "SELECT DISTINCT fs.* FROM l_wh_form_scrapped fs left join l_wh_form_scrapped_goods fsg on fs.id = fsg.FORM_SCRAPPED_ID WHERE 1 = 1 ";
- private static final String QUERY_BF_DETAIL_LIST = "select lwfs.BUSINESS_FORM_CODE,\n" +
- " lwfsg.GOODS_TEMPLATE_NAME,\n" +
- " lwfsg.BASE_GOODS_MODELS_NAME,\n" +
- " lwfsg.COUNTS,\n" +
- " lwfs.AGENCY_NAME,\n" +
- " lwfs,OPERATOR_NAME,\n" +
- " lwfs,DEAL_TIME\n" +
- "from l_wh_form_scrapped lwfs\n" +
- " inner join l_wh_form_scrapped_goods lwfsg on lwfs.ID = lwfsg.FORM_SCRAPPED_ID ";
+ private static final String QUERY_BF_DETAIL_LIST = "select fs.id,fs.BUSINESS_FORM_CODE,fsg.GOODS_TEMPLATE_NAME,fsg.BASE_GOODS_MODELS_NAME,fsg.COUNTS,"
+ + "fs.AGENCY_NAME,OPERATOR_NAME,DEAL_TIME from l_wh_form_scrapped fs "
+ + "inner join l_wh_form_scrapped_goods fsg on fs.ID = fsg.FORM_SCRAPPED_ID where 1=1 ";
/**
* 鏂板
*
* @param param
- * @param currentUser 褰撳墠鐧诲綍鐢ㄦ埛
- * @param sysInfo 褰撳墠鐧诲綍鐢ㄦ埛
- * @return
+ * @param currentUser 褰撳墠鐧诲綍鐢ㄦ埛
+ * @param sysInfo 褰撳墠鐧诲綍鐢ㄦ埛
+ * @return 1.鏂板鎶ュ簾鍗� 2.鏂板鎶ュ簾鍗曠墿鍝�
*/
- //1.鏂板鎶ュ簾鍗�
- //2.鏂板鎶ュ簾鍗曠墿鍝�
- public int add(LWhFormScrappedParam param, S_user_core currentUser, FinSysTenantUser sysInfo) {
+
+ public int add(LWhFormScrappedParam param, S_user_core currentUser, FinSysTenantUser sysInfo) {
//1.鏂板鎶ュ簾鍗曡褰�
LWhFormScrapped lWhFormScrapped = new LWhFormScrapped();
//鎶ュ簾鍗昳d
@@ -79,21 +80,47 @@
lWhFormScrapped.setId(lWhFormScrappedId);
lWhFormScrapped.setBusinessFormCode(codeGeneratorService.createBusinessFormCode(CodeGeneratorEnum.Scrapped));
lWhFormScrapped.setWarehouseType(0);
- Long warehouseId = param.getWarehouseId();
- lWhFormScrapped.setWarehouseId(warehouseId);
+
+ // 鍏敤
+ Long warehouseId = null;
+ //浠撳簱鍚嶇О
+ String wareHouseName = null;
+ warehouseId = param.getWarehouseId();
//鏍规嵁浠撳簱id鏌ヨ浠撳簱
BaseWarehouse warehouse = this.baseWarehouseService.getById(warehouseId);
if (warehouse == null) {
log.error("浠撳簱涓嶅瓨鍦�");
return 0;
}
- lWhFormScrapped.setWarehouseName(warehouse.getWarehouseName());
+ wareHouseName = warehouse.getWarehouseName();
+// if (0 == 0) {
+// warehouseId = param.getWarehouseId();
+// //鏍规嵁浠撳簱id鏌ヨ浠撳簱
+// BaseWarehouse warehouse = this.baseWarehouseService.getById(warehouseId);
+// if (warehouse == null) {
+// log.error("浠撳簱涓嶅瓨鍦�");
+// return 0;
+// }
+// wareHouseName = warehouse.getWarehouseName();
+// } else {
+// // 鏌ヨ閮ㄩ棬鍚嶇О
+// warehouseId = param.getDepartmentId();
+// FinSysTenantDepartment sysTenantDepartment = departmentService.getById(warehouseId);
+// if (sysTenantDepartment == null) {
+// log.error("閮ㄩ棬涓嶅瓨鍦�");
+// return 0;
+// }
+// wareHouseName = sysTenantDepartment.getName();
+// }
+ lWhFormScrapped.setWarehouseId(warehouseId);
+ lWhFormScrapped.setWarehouseName(wareHouseName);
lWhFormScrapped.setAgencyId(Long.valueOf(sysInfo.getTenantId()));
lWhFormScrapped.setAgencyName(sysInfo.getTenantName());
lWhFormScrapped.setOperatorId(sysInfo.getSysUserId());
lWhFormScrapped.setOperatorName(sysInfo.getUserName());
lWhFormScrapped.setDealTime(param.getDealTime());
lWhFormScrapped.setStates(0);
+ lWhFormScrapped.setUploadFiles(param.getUploadFiles());
//鏍规嵁閮ㄩ棬id鏌ヨ閮ㄩ棬
FinSysTenantDepartment department = this.departmentService.getById(sysInfo.getSysDeptId());
if (department != null) {
@@ -107,61 +134,67 @@
}
//2.鏂板鎶ュ簾鍗曠墿鍝佽褰�
//鏍规嵁鐗╁搧id鏌ヨ鐗╁搧
- BaseGoodsTemplate goodsTemplate = this.baseGoodsTemplateService.get(new BaseGoodsTemplate(param.getBaseGoodsTemplateId()));
- if (goodsTemplate == null) {
- log.error("鏍规嵁鐗╁搧id鏌ヨ鐗╁搧");
- return 0;
- }
- List<LWhFormScrappedGoodsParams> scrappedGoodsParamList = param.getScrappedGoodsList();
- if (CollectionUtils.isEmpty(scrappedGoodsParamList)) {
- log.error("鏂板鎶ュ簾鍗曠墿鍝佽褰� 澶辫触");
- return 0;
- }
- //鑾峰彇瑙勬牸鍨嬪彿id
- List<Long> baseGoodsModelsIdList = scrappedGoodsParamList.stream().map(params -> params.getBaseGoodsModelsId()).collect(Collectors.toList());
- //鏍规嵁瑙勬牸鍨嬪彿id鏌ヨ瑙勬牸鍨嬪彿
- List<BaseGoodsModels> models = this.baseGoodsModelsService.selectByModelsIdList(baseGoodsModelsIdList);
- Map<Long, BaseGoodsModels> modelMap = models.stream().collect(Collectors.toMap(model -> model.getId(), model -> model));
- //鑾峰彇鎶ュ簾鍘熷洜code
- List<String> scrappedCodeList = scrappedGoodsParamList.stream().map(params -> params.getScrappedCode()).collect(Collectors.toList());
- //鏍规嵁鎶ュ簾鍘熷洜code鏌ヨ鏁版嵁瀛楀吀
- List<S_dict_data> s_dict_dataList = this.sDictDataService.selectByScrappedCodeList(scrappedCodeList);
- Map<Long, String> scrappedNameMap = s_dict_dataList.stream().collect(Collectors.toMap(s -> s.getDict_code(), s -> s.getDict_label()));
-
- List<LWhFormScrappedGoods> scrappedGoodsList = new ArrayList<>();
- for (LWhFormScrappedGoodsParams params : scrappedGoodsParamList) {
- LWhFormScrappedGoods scrappedGoods = new LWhFormScrappedGoods();
- scrappedGoods.setId(IdUtil.generateId());
- //鏍规嵁鐗╁搧鍨嬪彿鏌ヨ鐗╁搧搴撳瓨
- int goodsNum = this.lWhGoodsService.queryGoodsModelNum(0, warehouseId, scrappedGoods.getBaseGoodsModelsId(), (short) 1, null);
- if (params.getCounts() > goodsNum) {
- log.error("鎶ュ簾鏁伴噺澶т簬搴撳瓨鏁伴噺");
+ for (LWhFormScrappedGoodsInfoParam goodsInfo : param.getScrappedGoodsInfo()) {
+ BaseGoodsTemplate goodsTemplate = this.baseGoodsTemplateService.get(new BaseGoodsTemplate(goodsInfo.getBaseGoodsTemplateId()));
+ if (goodsTemplate == null) {
+ log.error("璇ョ墿鍝佹ā鏉夸笉瀛樺湪");
return 0;
}
- scrappedGoods.setCounts(params.getCounts());
- //鎶ュ簾鍘熷洜
- scrappedGoods.setScrappedCode(params.getScrappedCode());
- scrappedGoods.setScrappedName(scrappedNameMap.get(Long.valueOf(params.getScrappedCode())));
- scrappedGoods.setFormScrappedId(lWhFormScrappedId);
- //鐗╁搧妯℃澘
- scrappedGoods.setBaseGoodsTemplateId(goodsTemplate.getId());
- scrappedGoods.setGoodsTemplateName(goodsTemplate.getGoodsName());
- //瑙勬牸鍨嬪彿
- Long baseGoodsModelsId = params.getBaseGoodsModelsId();
- BaseGoodsModels baseGoodsModels = modelMap.get(baseGoodsModelsId);
- if (baseGoodsModels != null) {
- scrappedGoods.setBaseGoodsModelsId(baseGoodsModelsId);
- scrappedGoods.setBaseGoodsModelsName(baseGoodsModels.getModelName());
- scrappedGoods.setUnit(baseGoodsModels.getUnit());
+ List<LWhFormScrappedGoodsModelParams> scrappedGoodsParamList = goodsInfo.getScrappedGoodsList();
+ if (CollectionUtils.isEmpty(scrappedGoodsParamList)) {
+ log.error("鏂板鎶ュ簾鍗曠墿鍝佽褰曞け璐�");
+ return 0;
}
+ //鑾峰彇瑙勬牸鍨嬪彿id
+ List<Long> baseGoodsModelsIdList = scrappedGoodsParamList.stream().map(params -> params.getBaseGoodsModelsId()).collect(Collectors.toList());
+ //鏍规嵁瑙勬牸鍨嬪彿id鏌ヨ瑙勬牸鍨嬪彿
+ List<BaseGoodsModels> models = this.baseGoodsModelsService.selectByModelsIdList(baseGoodsModelsIdList);
+ if (CollectionUtils.isEmpty(models)) {
+ log.error("璇ュ瀷鍙峰晢鍝佷笉瀛樺湪");
+ return 0;
+ }
+ Map<Long, BaseGoodsModels> modelMap = models.stream().collect(Collectors.toMap(model -> model.getId(), model -> model));
+ //鑾峰彇鎶ュ簾鍘熷洜code
+ List<String> scrappedCodeList = scrappedGoodsParamList.stream().map(params -> params.getScrappedCode()).collect(Collectors.toList());
+ //鏍规嵁鎶ュ簾鍘熷洜code鏌ヨ鏁版嵁瀛楀吀
+ List<SDictData> SDictDataList = this.sDictDataService.selectByScrappedCodeList(scrappedCodeList);
+ Map<Long, String> scrappedNameMap = SDictDataList.stream().collect(Collectors.toMap(s -> s.getDict_code(), s -> s.getDict_label()));
- scrappedGoodsList.add(scrappedGoods);
- }
- int flag2 = this.scrappedGoodsService.insert(scrappedGoodsList);
- if (flag2 != scrappedGoodsList.size()) {
- log.error("鏂板鎶ュ簾鍗曠墿鍝佽褰� 澶辫触");
- TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
- return 0;
+ List<LWhFormScrappedGoods> scrappedGoodsList = new ArrayList<>();
+ for (LWhFormScrappedGoodsModelParams params : scrappedGoodsParamList) {
+ LWhFormScrappedGoods scrappedGoods = new LWhFormScrappedGoods();
+ scrappedGoods.setId(IdUtil.generateId());
+ //鏍规嵁鐗╁搧鍨嬪彿鏌ヨ鐗╁搧搴撳瓨
+ int goodsNum = this.lWhGoodsService.queryGoodsModelNum(0, warehouseId, scrappedGoods.getBaseGoodsModelsId(), 1, null);
+ if (params.getCounts() > goodsNum) {
+ log.error("鎶ュ簾鏁伴噺澶т簬搴撳瓨鏁伴噺");
+ return 0;
+ }
+ scrappedGoods.setCounts(params.getCounts());
+ //鎶ュ簾鍘熷洜
+ scrappedGoods.setScrappedCode(params.getScrappedCode());
+ scrappedGoods.setScrappedName(scrappedNameMap.get(Long.valueOf(params.getScrappedCode())));
+ scrappedGoods.setFormScrappedId(lWhFormScrappedId);
+ //鐗╁搧妯℃澘
+ scrappedGoods.setBaseGoodsTemplateId(goodsTemplate.getId());
+ scrappedGoods.setGoodsTemplateName(goodsTemplate.getGoodsName());
+ //瑙勬牸鍨嬪彿
+ Long baseGoodsModelsId = params.getBaseGoodsModelsId();
+ BaseGoodsModels baseGoodsModels = modelMap.get(baseGoodsModelsId);
+ if (baseGoodsModels != null) {
+ scrappedGoods.setBaseGoodsModelsId(baseGoodsModelsId);
+ scrappedGoods.setBaseGoodsModelsName(baseGoodsModels.getModelName());
+ scrappedGoods.setUnit(baseGoodsModels.getUnit());
+ }
+
+ scrappedGoodsList.add(scrappedGoods);
+ }
+ int flag2 = this.scrappedGoodsService.insertBatch(scrappedGoodsList);
+ if (flag2 != scrappedGoodsList.size()) {
+ log.error("鏂板鎶ュ簾鍗曠墿鍝佽褰� 澶辫触");
+ TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
+ return 0;
+ }
}
//3.鏍规嵁鎶ュ簾鍗曟姤搴熺墿鍝�
Long lWarehouseFlowId = this.lWhFormScrappedCoreService.outFormByTransId(lWhFormScrappedId, currentUser, param.getDealTime());
@@ -175,91 +208,127 @@
}
/**
- * @Description 鍒楄〃鏌ヨ
+ * @Description 鍒楄〃鏌ヨ
* @Author 鍗㈠簡闃�
* @Date 2023/11/2
*/
- public GenericPager queryList(LWhFormScrappedParam param, FinSysTenantUser sysInfo) {
+ public PageUtil queryList(LWhFormScrappedQry param, FinSysTenantUser sysInfo) {
HashMap<String, Object> paramts = new HashMap<>();
StringBuilder sql = new StringBuilder(QUERY_LIST);
//鎶ュ簾鍗曞彿
if (!StringUtils.isEmpty(param.getBusinessFormCode())) {
- sql.append(" and BUSINESS_FORM_CODE like :businessFormCode ");
- paramts.put("businessFormCode", StringUtils.CHAR_PERCENT + param.getBusinessFormCode() + StringUtils.CHAR_PERCENT);
+ sql.append("and BUSINESS_FORM_CODE = :businessFormCode ");
+ paramts.put("businessFormCode", param.getBusinessFormCode());
}
//鐗╁搧鍚嶇О
if (!StringUtils.isEmpty(param.getGoodsTemplateName())) {
- sql.append(" AND id IN (SELECT BUSINESS_ID FROM L_WH_PROCURE_MODEL procureModel LEFT JOIN BASE_GOODS_MODELS baseModel ON procureModel.BASE_GOODS_MODELS_ID=baseModel.ID LEFT JOIN BASE_GOODS_TEMPLATE baseTemp ON baseModel.GOODS_TEMPLATES_ID=baseTemp.id WHERE procureModel.BUSINESS_TYPE=1 AND baseTemp.GOODS_NAME LIKE :goodsTemplateName)");
+ sql.append("and fsg.GOODS_TEMPLATE_NAME LIKE :goodsTemplateName ");
paramts.put("goodsTemplateName", StringUtils.CHAR_PERCENT + param.getGoodsTemplateName() + StringUtils.CHAR_PERCENT);
}
//鏈烘瀯
- sql.append(" and AGENCY_ID like :agencyId ");
- if (param.getAgencyId() != null){
- paramts.put("agencyId", param.getAgencyId() + StringUtils.CHAR_PERCENT);
+ sql.append("and AGENCY_ID like :agencyId ");
+ if (param.getAgencyId() != null) {
+ paramts.put("agencyId", param.getAgencyId() + StringUtils.CHAR_PERCENT);
} else {
- paramts.put("agencyId", sysInfo.getTenantId() + StringUtils.CHAR_PERCENT);
+ paramts.put("agencyId", sysInfo.getTenantId() + StringUtils.CHAR_PERCENT);
}
//鎶ュ簾鏃堕棿
- if (param.getDealTimeStart() != null) {
- sql.append(" and DEAL_TIME >=:dealTimeStart ");
- paramts.put("dealTimeStart", param.getDealTimeStart() * 1000000);
+ if (param.getStartTime() != null) {
+ sql.append("and DEAL_TIME >=:dealTimeStart ");
+ paramts.put("dealTimeStart", param.getStartTime() * 1000000);
}
- if (param.getDealTimeEnd() != null) {
- sql.append(" and DEAL_TIME <:dealTimeEnd ");
- paramts.put("dealTimeEnd", param.getDealTimeEnd() * 1000000 + 240000);
+ if (param.getEndTime() != null) {
+ sql.append("and DEAL_TIME <:dealTimeEnd ");
+ paramts.put("dealTimeEnd", param.getEndTime() * 1000000 + 240000);
}
- sql.append(" ORDER BY DEAL_TIME DESC");
+ sql.append("ORDER BY DEAL_TIME DESC");
GenericPager genericPager = selectSplit(sql.toString(), paramts, new LWhFormScrapped());
- return genericPager;
+ return new PageUtil(genericPager);
}
/**
- * @Description 鏍规嵁id鏌ヨ璇︽儏
+ * @Description 鏍规嵁id鏌ヨ璇︽儏
* @Author 鍗㈠簡闃�
* @Date 2023/11/2
*/
- public LWhFormScrappedExtend getById(Long id) {
- LWhFormScrappedExtend scrappedExtend = new LWhFormScrappedExtend();
+ public LWhFormScrappedExtendVO getById(Long id) {
+ LWhFormScrappedExtendVO scrappedExtend = new LWhFormScrappedExtendVO();
//1.鏌ヨ鎶ュ簾鍗�
LWhFormScrapped lWhFormScrapped = this.get(new LWhFormScrapped(id));
if (lWhFormScrapped != null) {
- BeanUtils.copyProperties(lWhFormScrapped,scrappedExtend);
+ BeanUtils.copyProperties(lWhFormScrapped, scrappedExtend);
}
//2.鏌ヨ鎶ュ簾鍗�
List<LWhFormScrappedGoods> scrappedGoodsList = this.scrappedGoodsService.getByFormScrappedId(id);
- if (!CollectionUtils.isEmpty(scrappedGoodsList)) {
- scrappedExtend.setScrappedGoodsList(scrappedGoodsList);
+ //閫氳繃baseGoodsTemplateId 杩涜鍒嗙粍
+ Map<Long, List<LWhFormScrappedGoods>> map = scrappedGoodsList.stream().collect(Collectors.groupingBy(LWhFormScrappedGoods::getBaseGoodsTemplateId));
+ //寰幆map鐨刱ey鍜寁alue
+ List<FormScrappedGoodsVO> scrappedGoodsVO = Lists.newArrayList();
+ for (Map.Entry<Long, List<LWhFormScrappedGoods>> entry : map.entrySet()) {
+ Long baseGoodsTemplateId = entry.getKey();
+ List<LWhFormScrappedGoods> goodsList = entry.getValue();
+ LWhFormScrappedGoods lWhFormScrappedGoods = goodsList.stream().findFirst().get();
+ FormScrappedGoodsVO formScrappedGoodsVO = new FormScrappedGoodsVO();
+ formScrappedGoodsVO.setBaseGoodsTemplateId(baseGoodsTemplateId);
+ formScrappedGoodsVO.setGoodsName(lWhFormScrappedGoods.getGoodsTemplateName());
+
+ String sql = "select CATEGORY_NAME from base_goods_template where id = :id";
+ Map<String, Object> param = new HashMap<>();
+ param.put("id", baseGoodsTemplateId);
+ List<Map<String, Object>> goodTemplate = this.select(sql, param, new MapperUtil());
+ if (!CollectionUtils.isEmpty(goodTemplate)) {
+ Optional<Map<String, Object>> first = goodTemplate.stream().findFirst();
+ Map<String, Object> objectMap = first.get();
+ formScrappedGoodsVO.setCategoryName(objectMap.get("categoryName").toString());
+ }
+
+ List<GoodsModelVO> goodsModelList = Lists.newArrayList();
+ goodsList.forEach(item -> {
+ GoodsModelVO goodsModelVO = new GoodsModelVO();
+ goodsModelVO.setId(item.getId());
+ goodsModelVO.setBaseGoodsModelsName(item.getBaseGoodsModelsName());
+ goodsModelVO.setUnit(item.getUnit());
+ goodsModelVO.setCounts(item.getCounts());
+ goodsModelVO.setBaseGoodsModelsId(item.getBaseGoodsModelsId());
+ goodsModelVO.setScrappedName(item.getScrappedName());
+ goodsModelList.add(goodsModelVO);
+ });
+ formScrappedGoodsVO.setModels(goodsModelList);
+ scrappedGoodsVO.add(formScrappedGoodsVO);
+
}
+ scrappedExtend.setScrappedGoods(scrappedGoodsVO);
return scrappedExtend;
}
/**
* 鎶ュ簾鏄庣粏
+ *
* @param param
* @return
*/
- public GenericPager<Map<String, Object>> queryDetailList(LWhFormScrappedParam param, FinSysTenantUser sysInfo) {
+ public PageUtil queryDetailList(LWhFormScrappedQry param, FinSysTenantUser sysInfo) {
StringBuilder sql = new StringBuilder(QUERY_BF_DETAIL_LIST);
HashMap<String, Object> paramts = new HashMap<>();
//鎶ュ簾鍗曞彿
if (!StringUtils.isEmpty(param.getBusinessFormCode())) {
- sql.append(" and BUSINESS_FORM_CODE =:BUSINESS_FORM_CODE ");
- paramts.put("BUSINESS_FORM_CODE", StringUtils.CHAR_PERCENT + param.getBusinessFormCode() + StringUtils.CHAR_PERCENT);
+ sql.append("and BUSINESS_FORM_CODE =:BUSINESS_FORM_CODE ");
+ paramts.put("BUSINESS_FORM_CODE", param.getBusinessFormCode());
}
//鐗╁搧鍚嶇О
if (!StringUtils.isEmpty(param.getGoodsTemplateName())) {
- sql.append(" and GOODS_TEMPLATE_NAME =:GOODS_TEMPLATE_NAME ");
+ sql.append("and GOODS_TEMPLATE_NAME like: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());
}
//鏈烘瀯
- sql.append(" and AGENCY_ID like:AGENCY_ID ");
+ sql.append("and AGENCY_ID like:AGENCY_ID ");
if (param.getAgencyId() != null) {
paramts.put("AGENCY_ID", param.getAgencyId() + StringUtils.CHAR_PERCENT);
} else {
@@ -267,45 +336,63 @@
}
//鍒涘缓浜�
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.getDealTimeStart() != null) {
- sql.append(" and DEAL_TIME >=:dealTimeStart ");
- paramts.put("dealTimeStart", param.getDealTimeStart() * 1000000);
+ if (param.getStartTime() != null) {
+ sql.append("and DEAL_TIME >=:dealTimeStart ");
+ paramts.put("dealTimeStart", param.getStartTime() * 1000000);
}
- if (param.getDealTimeEnd() != null) {
- sql.append(" and DEAL_TIME <:dealTimeEnd ");
- paramts.put("dealTimeEnd", param.getDealTimeEnd() * 1000000 + 240000);
+ if (param.getEndTime() != null) {
+ sql.append("and DEAL_TIME <:dealTimeEnd ");
+ paramts.put("dealTimeEnd", param.getEndTime() * 1000000 + 240000);
}
- sql.append(" ORDER BY DEAL_TIME DESC ");
+ sql.append("ORDER BY DEAL_TIME DESC ");
+ GenericPager<Map<String, Object>> mapGenericPager = selectSplit(sql.toString(), paramts, param.getPageNum(), param.getPageSize(), new MapperUtil());
+ PageUtil pageUtil = new PageUtil<>(mapGenericPager);
+ List<FormScrappedGoodsDetailVO> result = Lists.newArrayList();
+ mapGenericPager.getDatas().forEach(item -> {
+ FormScrappedGoodsDetailVO formScrappedGoodsDetailVO = MapUtils.convertMapToObj(item, FormScrappedGoodsDetailVO.class);
+ result.add(formScrappedGoodsDetailVO);
+ });
+ pageUtil.setDatas(result);
+ return pageUtil;
+ }
- return selectSplit(sql.toString(), paramts, param.getPageNum(), param.getPageSize(), new MapRowMapper());
+ public List<ScrappedInfoExcelTemplate> export(Long id) {
+ String sql =
+ "SELECT\n"
+ + "\tBUSINESS_FORM_CODE,\n"
+ + "\tfs.DEAL_TIME,\n"
+ + "\tOPERATOR_NAME,\n"
+ + "\tAGENCY_NAME tenantName,\n"
+ + "\tGOODS_TEMPLATE_NAME templateName,\n"
+ + "\tBASE_GOODS_MODELS_NAME baseModelName,\n"
+ + "\tCOUNTS num,\n"
+ + "\tSCRAPPED_NAME deception,\n"
+ + "\tBEIZ remark\n"
+ + "FROM\n"
+ + "\tl_wh_form_scrapped_goods fsg\n"
+ + "\tLEFT JOIN l_wh_form_scrapped fs ON fs.id = fsg.FORM_SCRAPPED_ID\n"
+ + "WHERE\n"
+ + "\tfs.ID = :id\n"
+ + "\tAND STATES = 1";
+ Map<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<ScrappedInfoExcelTemplate> list = Lists.newArrayList();
+ select.forEach(item -> {
+ ScrappedInfoExcelTemplate inventoryExcelTemplate = MapUtils.convertMapToObj(item, ScrappedInfoExcelTemplate.class);
+ list.add(inventoryExcelTemplate);
+ });
+ return list;
}
- /**
- * @Description 瀵煎嚭鎶ュ簾鐧昏鍗�
- * @Author 鍗㈠簡闃�
- * @Date 2023/11/2
- */
- public LWhFormScrappedExtend export(Long id, FinSysTenantUser sysInfo) {
- LWhFormScrappedExtend scrappedExtend = new LWhFormScrappedExtend();
- //1.鏌ヨ鎶ュ簾鍗�
- LWhFormScrapped lWhFormScrapped = this.get(new LWhFormScrapped(id));
- if (lWhFormScrapped != null) {
- lWhFormScrapped.setDealTime(DateUtils.getDateTimeNumber(System.currentTimeMillis()));
- lWhFormScrapped.setOperatorName(sysInfo.getUserName());
- BeanUtils.copyProperties(lWhFormScrapped,scrappedExtend);
- }
- //2.鏌ヨ鎶ュ簾鍗曠墿鍝�
- List<LWhFormScrappedGoods> scrappedGoodsList = this.scrappedGoodsService.getByFormScrappedId(id);
- if (!CollectionUtils.isEmpty(scrappedGoodsList)) {
- scrappedExtend.setScrappedGoodsList(scrappedGoodsList);
- }
- return scrappedExtend;
- }
}
--
Gitblit v1.9.1