From edc87e2fc3760cd7d1230bc058acf5620ea2c465 Mon Sep 17 00:00:00 2001
From: futian.liu <liufutianyoo@163.com>
Date: 星期六, 02 十二月 2023 15:03:15 +0800
Subject: [PATCH] 部门分发添加,分发单型号查询

---
 consum-base/src/main/java/com/consum/base/controller/FinSysTenantUserController.java          |   32 +++-
 consum-base/src/main/java/com/consum/base/service/impl/FinSysTenantDepartmentServiceImpl.java |   32 +++-
 consum-base/src/main/java/com/consum/base/service/LWhFormScrappedServiceImpl.java             |   41 ++---
 consum-base/src/main/java/com/consum/base/service/LWhFormTransferCoreService.java             |   31 ++--
 consum-base/src/main/java/com/consum/base/service/LWhFormTransferService.java                 |   57 ++++++++
 consum-base/src/main/java/com/consum/base/service/impl/LWhFormTransferServiceImpl.java        |   55 +++++--
 consum-base/src/main/java/com/consum/base/service/impl/UsingFormBackServiceImpl.java          |   47 ++++-
 consum-base/src/main/java/com/consum/base/controller/FinSysTenantDepartmentController.java    |    4 
 consum-base/src/main/java/com/consum/base/controller/LWhFormTransferController.java           |    4 
 consum-base/src/main/java/com/consum/base/service/BaseWarehouseServiceImpl.java               |   13 +
 consum-base/src/main/java/com/consum/base/service/DepFormScrappedServiceImpl.java             |   34 ++--
 consum-base/src/main/java/com/consum/base/service/FinSysTenantDepartmentService.java          |   63 +++++++++
 consum-base/src/main/java/com/consum/base/pojo/response/BaseGoodsTemplateInfo.java            |    1 
 13 files changed, 303 insertions(+), 111 deletions(-)

diff --git a/consum-base/src/main/java/com/consum/base/controller/FinSysTenantDepartmentController.java b/consum-base/src/main/java/com/consum/base/controller/FinSysTenantDepartmentController.java
index a3e1880..fa64b01 100644
--- a/consum-base/src/main/java/com/consum/base/controller/FinSysTenantDepartmentController.java
+++ b/consum-base/src/main/java/com/consum/base/controller/FinSysTenantDepartmentController.java
@@ -3,7 +3,7 @@
 import com.consum.base.BaseController;
 import com.consum.base.core.utils.CommonUtil;
 import com.consum.base.pojo.FinSysTenantDepartmentParam;
-import com.consum.base.service.FinSysTenantDepartmentServiceImpl;
+import com.consum.base.service.FinSysTenantDepartmentService;
 import com.consum.model.po.FinSysTenantDepartment;
 import com.consum.model.po.FinSysTenantUser;
 import com.walker.db.page.GenericPager;
@@ -32,7 +32,7 @@
 public class FinSysTenantDepartmentController extends BaseController {
 
     @Autowired
-    private FinSysTenantDepartmentServiceImpl departmentService;
+    private FinSysTenantDepartmentService departmentService;
 
     /**
      * @Description 鏂板
diff --git a/consum-base/src/main/java/com/consum/base/controller/FinSysTenantUserController.java b/consum-base/src/main/java/com/consum/base/controller/FinSysTenantUserController.java
index f03df71..946f689 100644
--- a/consum-base/src/main/java/com/consum/base/controller/FinSysTenantUserController.java
+++ b/consum-base/src/main/java/com/consum/base/controller/FinSysTenantUserController.java
@@ -14,7 +14,7 @@
 import com.consum.base.pojo.response.FinSysTenantUserVO;
 import com.consum.base.pojo.response.FinSysTenantVO;
 import com.consum.base.pojo.response.UserVO;
-import com.consum.base.service.FinSysTenantDepartmentServiceImpl;
+import com.consum.base.service.FinSysTenantDepartmentService;
 import com.consum.base.service.FinSysTenantServiceImpl;
 import com.consum.base.service.FinSysTenantUserServiceImpl;
 import com.consum.model.po.FinSysTenant;
@@ -31,22 +31,38 @@
 import com.iplatform.model.po.S_role;
 import com.iplatform.model.po.S_user_core;
 import com.walker.db.page.GenericPager;
-import com.walker.infrastructure.utils.*;
+import com.walker.infrastructure.utils.CollectionUtils;
+import com.walker.infrastructure.utils.DateUtils;
+import com.walker.infrastructure.utils.NumberGenerator;
+import com.walker.infrastructure.utils.PhoneNumberUtils;
+import com.walker.infrastructure.utils.StringUtils;
 import com.walker.web.ResponseValue;
 import io.swagger.annotations.Api;
 import io.swagger.annotations.ApiImplicitParam;
 import io.swagger.annotations.ApiImplicitParams;
 import io.swagger.annotations.ApiOperation;
+import java.io.IOException;
+import java.lang.reflect.Field;
+import java.util.ArrayList;
+import java.util.Arrays;
+import java.util.HashMap;
+import java.util.HashSet;
+import java.util.List;
+import java.util.Map;
+import java.util.Objects;
+import java.util.Optional;
+import java.util.Set;
 import org.apache.commons.compress.utils.Lists;
 import org.springframework.beans.BeanUtils;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.transaction.annotation.Transactional;
-import org.springframework.web.bind.annotation.*;
+import org.springframework.web.bind.annotation.GetMapping;
+import org.springframework.web.bind.annotation.PostMapping;
+import org.springframework.web.bind.annotation.RequestBody;
+import org.springframework.web.bind.annotation.RequestMapping;
+import org.springframework.web.bind.annotation.RequestParam;
+import org.springframework.web.bind.annotation.RestController;
 import org.springframework.web.multipart.MultipartFile;
-
-import java.io.IOException;
-import java.lang.reflect.Field;
-import java.util.*;
 
 /**
  * @Description 绯荤粺鐢ㄦ埛
@@ -71,7 +87,7 @@
     private RoleServiceImpl roleService;
 
     @Autowired
-    private FinSysTenantDepartmentServiceImpl finSysTenantDepartmentService;
+    private FinSysTenantDepartmentService finSysTenantDepartmentService;
 
 
     @Autowired
diff --git a/consum-base/src/main/java/com/consum/base/controller/LWhFormTransferController.java b/consum-base/src/main/java/com/consum/base/controller/LWhFormTransferController.java
index 7769dae..fc14402 100644
--- a/consum-base/src/main/java/com/consum/base/controller/LWhFormTransferController.java
+++ b/consum-base/src/main/java/com/consum/base/controller/LWhFormTransferController.java
@@ -24,7 +24,7 @@
 import com.consum.base.pojo.response.TransferInfoVO;
 import com.consum.base.service.BaseWarehouseServiceImpl;
 import com.consum.base.service.LWhFormTransferCoreService;
-import com.consum.base.service.LWhFormTransferServiceImpl;
+import com.consum.base.service.LWhFormTransferService;
 import com.consum.base.service.LWhProcureModelService;
 import com.consum.base.service.LWhProcureModelUserRecordServiceImpl;
 import com.consum.base.service.LWhProcureModelUserServiceImpl;
@@ -71,7 +71,7 @@
 public class LWhFormTransferController extends BaseController {
 
     @Autowired
-    private LWhFormTransferServiceImpl lWhFormTransferService;
+    private LWhFormTransferService lWhFormTransferService;
     @Autowired
     private LWhProcureModelService lWhProcureModelService;
     @Autowired
diff --git a/consum-base/src/main/java/com/consum/base/pojo/response/BaseGoodsTemplateInfo.java b/consum-base/src/main/java/com/consum/base/pojo/response/BaseGoodsTemplateInfo.java
index 0c3d446..104da19 100644
--- a/consum-base/src/main/java/com/consum/base/pojo/response/BaseGoodsTemplateInfo.java
+++ b/consum-base/src/main/java/com/consum/base/pojo/response/BaseGoodsTemplateInfo.java
@@ -13,4 +13,5 @@
 
     private String baseGoodsTemplateName;
     private Integer count;
+    private String unit;
 }
diff --git a/consum-base/src/main/java/com/consum/base/service/BaseWarehouseServiceImpl.java b/consum-base/src/main/java/com/consum/base/service/BaseWarehouseServiceImpl.java
index dea1689..f2d56cd 100644
--- a/consum-base/src/main/java/com/consum/base/service/BaseWarehouseServiceImpl.java
+++ b/consum-base/src/main/java/com/consum/base/service/BaseWarehouseServiceImpl.java
@@ -12,12 +12,15 @@
 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;
-
-import java.util.*;
-import java.util.stream.Collectors;
 
 /**
  * @Description 浠撳簱绠$悊
@@ -32,9 +35,7 @@
     @Autowired
     private FinSysTenantServiceImpl finSysTenantService;
     @Autowired
-    private FinSysTenantDepartmentServiceImpl departmentService;
-    @Autowired
-    private FinSysTenantUserServiceImpl userService;
+    private FinSysTenantDepartmentService departmentService;
     @Autowired
     private SDictDataServiceImpl sDictDataService;
 
diff --git a/consum-base/src/main/java/com/consum/base/service/DepFormScrappedServiceImpl.java b/consum-base/src/main/java/com/consum/base/service/DepFormScrappedServiceImpl.java
index 5fdda99..0c36214 100644
--- a/consum-base/src/main/java/com/consum/base/service/DepFormScrappedServiceImpl.java
+++ b/consum-base/src/main/java/com/consum/base/service/DepFormScrappedServiceImpl.java
@@ -10,7 +10,14 @@
 import com.consum.base.pojo.LDeptFormScrappedParam;
 import com.consum.base.pojo.query.LDeptFormScrappedQry;
 import com.consum.base.pojo.response.DepFormScrappedExtendVo;
-import com.consum.model.po.*;
+import com.consum.model.po.BaseCategory;
+import com.consum.model.po.DepFormScrapped;
+import com.consum.model.po.DepFormScrappedGoods;
+import com.consum.model.po.DepFormScrappedModel;
+import com.consum.model.po.FinSysTenantDepartment;
+import com.consum.model.po.FinSysTenantUser;
+import com.consum.model.po.LWhFormTransfer;
+import com.consum.model.po.SDictData;
 import com.fasterxml.jackson.databind.ObjectMapper;
 import com.iplatform.model.po.S_user_core;
 import com.walker.db.page.GenericPager;
@@ -19,16 +26,15 @@
 import com.walker.infrastructure.utils.StringUtils;
 import com.walker.jdbc.service.BaseServiceImpl;
 import com.walker.web.ResponseValue;
-import org.springframework.beans.BeanUtils;
-import org.springframework.stereotype.Service;
-import org.springframework.transaction.annotation.Transactional;
-
-import javax.annotation.Resource;
 import java.util.ArrayList;
 import java.util.HashMap;
 import java.util.List;
 import java.util.Map;
 import java.util.stream.Collectors;
+import javax.annotation.Resource;
+import org.springframework.beans.BeanUtils;
+import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Transactional;
 
 /**
  * @ClassName DepFormScrappedServiceImpl
@@ -43,9 +49,9 @@
     @Resource
     private CodeGeneratorService codeGeneratorService;
     @Resource
-    private FinSysTenantDepartmentServiceImpl departmentService;
+    private FinSysTenantDepartmentService departmentService;
     @Resource
-    private LWhFormTransferServiceImpl lWhFormTransferService;
+    private LWhFormTransferService lWhFormTransferService;
     @Resource
     private BaseCategoryServiceImpl baseCategoryService;
     @Resource
@@ -85,7 +91,6 @@
             lDeptFormScrapped.setDepartmentId(sysInfo.getSysDeptId());
             lDeptFormScrapped.setDepartmentName(department.getName());
         }
-
 
         lDeptFormScrapped.setCreateTime(dealTime);
         lDeptFormScrapped.setStates(1);
@@ -255,10 +260,10 @@
             depFormScrappedModel.setDepFormScrappedGoodsId(scrappedGoodsId);
             List<DepFormScrappedModel> scrappedModelList = select(depFormScrappedModel);
             List<List<DepFormScrappedModel>> modelList = scrappedModelList.stream()
-                    .collect(Collectors.groupingBy(DepFormScrappedModel::getBaseGoodsModelsId))
-                    .values().stream()
-                    .map(list -> list.stream().collect(Collectors.toList()))
-                    .collect(Collectors.toList());
+                .collect(Collectors.groupingBy(DepFormScrappedModel::getBaseGoodsModelsId))
+                .values().stream()
+                .map(list -> list.stream().collect(Collectors.toList()))
+                .collect(Collectors.toList());
 
             scrappedGoodsMap.put("models", modelList);
             goodsList.add(scrappedGoodsMap);
@@ -285,6 +290,7 @@
         }
         return select(sql.append(EXPORT_SQL_END).toString(), paramts, new MapperUtil());
     }
+
     public List<Map<String, Object>> listByModel(LDeptFormScrappedQry param) {
         HashMap<String, Object> paramts = new HashMap<>();
         StringBuilder sql = new StringBuilder(EXPORT_SQL);
@@ -299,7 +305,7 @@
             paramts.put("businessFormCode", param.getBusinessFormCode());
         }
         //鐗╁搧鍚嶇О
-        if (StringUtils.isNotEmpty(param.getGoodsTemplateName())){
+        if (StringUtils.isNotEmpty(param.getGoodsTemplateName())) {
             sql.append(" and model.BASE_GOODS_TEMPLATE_NAME LIKE :goodsTemplateName ");
             paramts.put("goodsTemplateName", StringUtils.CHAR_PERCENT + param.getGoodsTemplateName() + StringUtils.CHAR_PERCENT);
         }
diff --git a/consum-base/src/main/java/com/consum/base/service/FinSysTenantDepartmentService.java b/consum-base/src/main/java/com/consum/base/service/FinSysTenantDepartmentService.java
new file mode 100644
index 0000000..99c4151
--- /dev/null
+++ b/consum-base/src/main/java/com/consum/base/service/FinSysTenantDepartmentService.java
@@ -0,0 +1,63 @@
+package com.consum.base.service;
+
+import com.consum.base.pojo.FinSysTenantDepartmentParam;
+import com.consum.model.po.FinSysTenantDepartment;
+import com.consum.model.po.FinSysTenantUser;
+import com.walker.db.page.GenericPager;
+import com.walker.jdbc.service.BaseService;
+import java.util.List;
+
+public interface FinSysTenantDepartmentService extends BaseService {
+
+
+    FinSysTenantDepartment getByNameAndTenantId(String name, Long tenantId);
+
+    /**
+     * @Description 鏂板
+     * @Author 鍗㈠簡闃�
+     * @Date 2023/10/26
+     */
+    int add(FinSysTenantDepartmentParam param, FinSysTenantUser sysInfo);
+
+    /**
+     * @Description 閮ㄩ棬鍒楄〃鏌ヨ
+     * @Author 鍗㈠簡闃�
+     * @Date 2023/10/26
+     */
+    GenericPager<FinSysTenantDepartment> queryList(FinSysTenantDepartmentParam param);
+
+    FinSysTenantDepartment selectByCode(String code);
+
+    /**
+     * @Description 缂栬緫
+     * @Author 鍗㈠簡闃�
+     * @Date 2023/10/26
+     */
+    int updateFinSysTenantDepartment(FinSysTenantDepartment department, FinSysTenantUser sysInfo);
+
+    /**
+     * 鏍规嵁閮ㄩ棬id鏌ヨ閮ㄩ棬璇︽儏
+     *
+     * @author 鍗㈠簡闃�
+     * @Date 2023/10/26
+     */
+    FinSysTenantDepartment getById(Long id);
+
+    /**
+     * @param department
+     * @param currentUser
+     * @Description 鏍规嵁id鍒犻櫎閮ㄩ棬
+     * @Author 鍗㈠簡闃�
+     * @Date 2023/10/26
+     */
+    int updateById(FinSysTenantDepartment department, FinSysTenantUser currentUser);
+
+    /**
+     * 鏍规嵁鏈烘瀯id鏌ヨ閮ㄩ棬
+     *
+     * @param agencyId
+     * @return
+     */
+    List<FinSysTenantDepartment> getByTenantId(Long agencyId);
+
+}
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 5fb144f..daf8093 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
@@ -15,20 +15,30 @@
 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.consum.model.po.BaseGoodsModels;
+import com.consum.model.po.BaseGoodsTemplate;
+import com.consum.model.po.BaseWarehouse;
+import com.consum.model.po.FinSysTenantDepartment;
+import com.consum.model.po.FinSysTenantUser;
+import com.consum.model.po.LWhFormScrapped;
+import com.consum.model.po.LWhFormScrappedGoods;
+import com.consum.model.po.SDictData;
 import com.iplatform.model.po.S_user_core;
 import com.walker.db.page.GenericPager;
 import com.walker.infrastructure.utils.StringUtils;
 import com.walker.jdbc.service.BaseServiceImpl;
+import java.util.ArrayList;
+import java.util.HashMap;
+import java.util.List;
+import java.util.Map;
+import java.util.Optional;
+import java.util.stream.Collectors;
 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.*;
-import java.util.stream.Collectors;
 
 /**
  * @Description 鎶ュ簾鍗�
@@ -43,7 +53,7 @@
     @Autowired
     private BaseWarehouseServiceImpl baseWarehouseService;
     @Autowired
-    private FinSysTenantDepartmentServiceImpl departmentService;
+    private FinSysTenantDepartmentService departmentService;
     @Autowired
     private LWhGoodsService lWhGoodsService;
     @Autowired
@@ -72,7 +82,7 @@
      * @return 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
@@ -93,25 +103,6 @@
             return 0;
         }
         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()));
diff --git a/consum-base/src/main/java/com/consum/base/service/LWhFormTransferCoreService.java b/consum-base/src/main/java/com/consum/base/service/LWhFormTransferCoreService.java
index 81cd08f..e890509 100644
--- a/consum-base/src/main/java/com/consum/base/service/LWhFormTransferCoreService.java
+++ b/consum-base/src/main/java/com/consum/base/service/LWhFormTransferCoreService.java
@@ -5,23 +5,27 @@
 import com.consum.base.core.service.LWhWarningCoreServiceImpl;
 import com.consum.base.core.utils.IdUtil;
 import com.consum.base.core.utils.LockManage;
-import com.consum.model.po.*;
+import com.consum.model.po.LGoodsUserRecord;
+import com.consum.model.po.LWarehouseFlow;
+import com.consum.model.po.LWhFormTransfer;
+import com.consum.model.po.LWhGoodsRecord;
+import com.consum.model.po.LWhGoodsRecordDetails;
+import com.consum.model.po.LWhProcureModelUser;
 import com.iplatform.model.po.S_user_core;
 import com.walker.infrastructure.utils.CollectionUtils;
 import com.walker.infrastructure.utils.DateUtils;
 import com.walker.infrastructure.utils.NumberGenerator;
-import lombok.extern.slf4j.Slf4j;
-import org.springframework.stereotype.Service;
-import org.springframework.transaction.annotation.Propagation;
-import org.springframework.transaction.annotation.Transactional;
-import org.springframework.transaction.interceptor.TransactionAspectSupport;
-
-import javax.annotation.Resource;
 import java.util.ArrayList;
 import java.util.HashMap;
 import java.util.List;
 import java.util.Map;
 import java.util.stream.Collectors;
+import javax.annotation.Resource;
+import lombok.extern.slf4j.Slf4j;
+import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Propagation;
+import org.springframework.transaction.annotation.Transactional;
+import org.springframework.transaction.interceptor.TransactionAspectSupport;
 
 /**
  * @ClassName LWhFormTransferCoreService
@@ -35,7 +39,7 @@
 public class LWhFormTransferCoreService {
 
     @Resource
-    private LWhFormTransferServiceImpl lWhFormTransferService;
+    private LWhFormTransferService lWhFormTransferService;
     @Resource
     private LWhFormOutputCoreService lWhFormOutputCoreService;
     @Resource
@@ -128,7 +132,7 @@
         String nickName = currentUser.getNick_name();
         // 鍑哄簱鍗曟祦姘磇d
         Long outWarehouseFlowId = lWhFormTransfer.getOutWarehouseFlowId();
-        if (outWarehouseFlowId == null){
+        if (outWarehouseFlowId == null) {
             log.error("璋冩嫧澶辫触锛佹湭鎵惧埌鍑哄簱鍗�");
             return;
         }
@@ -188,7 +192,7 @@
             synchronized (warehouseModelLockObj) {
                 // 鏍规嵁鍑哄簱娴佹按ID 鏌ヨ 鍑哄簱鐨勭墿鍝両D
                 outGoodsIds = getGoodsidByFlowId(outWarehouseFlowId, oldRecordId);
-                if (CollectionUtils.isEmpty(outGoodsIds)){
+                if (CollectionUtils.isEmpty(outGoodsIds)) {
                     TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
                     throw new RuntimeException("鍏ュ簱鍗曞け璐ワ紝鏈煡璇㈠埌鐗╁搧锛�");
                 }
@@ -211,7 +215,7 @@
                 lWhProcureModelUser.setTransBusinessId(whFormTransferId);
                 lWhProcureModelUser.setBaseGoodsModelsId(baseGoodsModelsId);
                 List<LWhProcureModelUser> goodsUserInfo = goodsBaseService.select(lWhProcureModelUser);
-                if (CollectionUtils.isEmpty(goodsUserInfo)){
+                if (CollectionUtils.isEmpty(goodsUserInfo)) {
                     continue;
                 }
                 int totalGoodsNum = goodsUserInfo.stream().filter(item -> item.getGoodsNum() != null).mapToInt(LWhProcureModelUser::getGoodsNum).sum();
@@ -258,7 +262,6 @@
             //灏嗕繚绠′粨搴撲俊鎭洿鏂板埌 鐗╁搧浠撳簱淇濈璁板綍銆怢_GOODS_WH_RECORD銆�
             lGoodsWhRecordService.insertNewRecord(outGoodsIds, inWarehouseFlowId, dealTime);
 
-
             LWhGoodsRecordDetails lWhGoodsRecordDetails = new LWhGoodsRecordDetails();
             lWhGoodsRecordDetails.setWhGoodsRecordId(oldRecordId);
             List<LWhGoodsRecordDetails> goodsRecordDetailsList = lWhGoodsRecordDetailsService.select(lWhGoodsRecordDetails);
@@ -282,7 +285,7 @@
         lWhFormTransferService.update(lWhFormTransfer);
 
         //褰撳簱瀛樺彉鍔ㄦ椂璋冪敤璇ユ柟娉�
-        if (inWarehouseType == 0){
+        if (inWarehouseType == 0) {
             lWhWarningCoreService.updateKuCun(Convert.toShort(inWarehouseType, (short) 0), inWarehouseId, allChangModelList, null, dealTime);
         }
         log.info("璋冩嫧鍗曪細{} 鍏ュ簱瀹屾垚", whFormTransferId);
diff --git a/consum-base/src/main/java/com/consum/base/service/LWhFormTransferService.java b/consum-base/src/main/java/com/consum/base/service/LWhFormTransferService.java
new file mode 100644
index 0000000..1c067fb
--- /dev/null
+++ b/consum-base/src/main/java/com/consum/base/service/LWhFormTransferService.java
@@ -0,0 +1,57 @@
+package com.consum.base.service;
+
+import com.consum.base.pojo.excel.TransferExcelTemplate;
+import com.consum.base.pojo.query.TransferQry;
+import com.consum.base.pojo.request.LWhFormTransferParam;
+import com.consum.base.pojo.response.LWHFromTransferExtendVO;
+import com.consum.model.po.FinSysTenantUser;
+import com.consum.model.po.LWhFormTransfer;
+import com.walker.db.page.GenericPager;
+import com.walker.jdbc.service.BaseService;
+import java.util.List;
+import java.util.Map;
+
+public interface LWhFormTransferService extends BaseService {
+
+    long add(LWhFormTransferParam param, FinSysTenantUser sysInfo) throws Exception;
+
+
+    /**
+     * @Description 鍒楄〃鏌ヨ
+     * @Author 鍗㈠簡闃�
+     * @Date 2023/10/30
+     */
+    GenericPager<LWhFormTransfer> queryFormTransferList(TransferQry param);
+
+    /**
+     * @Description 鏍规嵁id鏌ヨ璇︽儏
+     * @Author 鍗㈠簡闃�
+     * @Date 2023/10/30
+     */
+    LWHFromTransferExtendVO getById(Long id);
+
+
+    /**
+     * @Description 瀵煎嚭璋冩嫧鍑哄簱鍗�
+     * @Author 鍗㈠簡闃�
+     * @Date 2023/10/31
+     */
+    List<TransferExcelTemplate> export(Long id, Integer type);
+
+    /**
+     * 鎾ら攢
+     *
+     * @author 鍗㈠簡闃�
+     * @date 2023/10/31
+     */
+    int updateStatus(Long id);
+
+    GenericPager<Map<String, Object>> queryTransferInfo(TransferQry transferQry);
+
+
+    GenericPager<Map<String, Object>> queryFormTransferDetailList(TransferQry param);
+
+    List<Map<String, Object>> queryDepartmentTransferOrder();
+
+    LWhFormTransfer selectById(Long id);
+}
diff --git a/consum-base/src/main/java/com/consum/base/service/FinSysTenantDepartmentServiceImpl.java b/consum-base/src/main/java/com/consum/base/service/impl/FinSysTenantDepartmentServiceImpl.java
similarity index 93%
rename from consum-base/src/main/java/com/consum/base/service/FinSysTenantDepartmentServiceImpl.java
rename to consum-base/src/main/java/com/consum/base/service/impl/FinSysTenantDepartmentServiceImpl.java
index 99b1cbd..8a7b2a9 100644
--- a/consum-base/src/main/java/com/consum/base/service/FinSysTenantDepartmentServiceImpl.java
+++ b/consum-base/src/main/java/com/consum/base/service/impl/FinSysTenantDepartmentServiceImpl.java
@@ -1,19 +1,19 @@
-package com.consum.base.service;
+package com.consum.base.service.impl;
 
 import com.consum.base.Constants;
-import com.consum.base.pojo.FinSysTenantDepartmentParam;
 import com.consum.base.core.utils.IdUtil;
+import com.consum.base.pojo.FinSysTenantDepartmentParam;
+import com.consum.base.service.FinSysTenantDepartmentService;
 import com.consum.model.po.FinSysTenantDepartment;
 import com.consum.model.po.FinSysTenantUser;
 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.springframework.beans.BeanUtils;
-import org.springframework.stereotype.Service;
-
 import java.util.HashMap;
 import java.util.List;
+import org.springframework.beans.BeanUtils;
+import org.springframework.stereotype.Service;
 
 /**
  * @Description 閮ㄩ棬绠$悊
@@ -21,16 +21,17 @@
  * @Date 2023/10/26
  */
 @Service
-public class FinSysTenantDepartmentServiceImpl extends BaseServiceImpl {
+public class FinSysTenantDepartmentServiceImpl extends BaseServiceImpl implements FinSysTenantDepartmentService {
 
     private static final String QUERY_BY_CODE = "SELECT * FROM fin_sys_tenant_department WHERE CODE = ?";
 
     /**
-     * @Description  鏍规嵁 閮ㄩ棬鍚嶇О鍜屾満鏋刬d 鏌ヨ閮ㄩ棬
+     * @Description 鏍规嵁 閮ㄩ棬鍚嶇О鍜屾満鏋刬d 鏌ヨ閮ㄩ棬
      * @Author 鍗㈠簡闃�
      * @Date 2023/10/26
      */
-    public FinSysTenantDepartment getByNameAndTenantId(String name,Long tenantId) {
+    @Override
+    public FinSysTenantDepartment getByNameAndTenantId(String name, Long tenantId) {
         StringBuilder sql = new StringBuilder("SELECT * FROM fin_sys_tenant_department WHERE 1 = 1 ");
         HashMap<String, Object> paramts = new HashMap<>();
 
@@ -48,10 +49,11 @@
     }
 
     /**
-     * @Description  鏂板
+     * @Description 鏂板
      * @Author 鍗㈠簡闃�
      * @Date 2023/10/26
      */
+    @Override
     public int add(FinSysTenantDepartmentParam param, FinSysTenantUser sysInfo) {
         FinSysTenantDepartment department = new FinSysTenantDepartment();
         BeanUtils.copyProperties(param, department);
@@ -70,6 +72,7 @@
      * @Author 鍗㈠簡闃�
      * @Date 2023/10/26
      */
+    @Override
     public GenericPager<FinSysTenantDepartment> queryList(FinSysTenantDepartmentParam param) {
         StringBuilder sql = new StringBuilder("SELECT * FROM fin_sys_tenant_department WHERE 1 = 1 and is_delete = 0 ");
         HashMap<String, Object> paramts = new HashMap<>();
@@ -101,6 +104,7 @@
         return selectSplit(sql.toString(), paramts, new FinSysTenantDepartment());
     }
 
+    @Override
     public FinSysTenantDepartment selectByCode(String code) {
         List<FinSysTenantDepartment> select = this.select(QUERY_BY_CODE, new Object[]{code}, new FinSysTenantDepartment());
         if (StringUtils.isEmptyList(select)) {
@@ -115,6 +119,7 @@
      * @Author 鍗㈠簡闃�
      * @Date 2023/10/26
      */
+    @Override
     public int updateFinSysTenantDepartment(FinSysTenantDepartment department, FinSysTenantUser sysInfo) {
         department.setUpdateTime(DateUtils.getDateTimeNumber(System.currentTimeMillis()));
         department.setUpdateBy(sysInfo.getUserName());
@@ -123,20 +128,23 @@
 
     /**
      * 鏍规嵁閮ㄩ棬id鏌ヨ閮ㄩ棬璇︽儏
+     *
      * @author 鍗㈠簡闃�
      * @Date 2023/10/26
      */
+    @Override
     public FinSysTenantDepartment getById(Long id) {
         return this.get(new FinSysTenantDepartment(id));
     }
 
     /**
+     * @param department
+     * @param currentUser
      * @Description 鏍规嵁id鍒犻櫎閮ㄩ棬
      * @Author 鍗㈠簡闃�
      * @Date 2023/10/26
-     * @param department
-     * @param currentUser
      */
+    @Override
     public int updateById(FinSysTenantDepartment department, FinSysTenantUser currentUser) {
         department.setIsDelete(Constants.IS_DELETE_YES);
         //鍒犻櫎鏃堕棿
@@ -148,9 +156,11 @@
 
     /**
      * 鏍规嵁鏈烘瀯id鏌ヨ閮ㄩ棬
+     *
      * @param agencyId
      * @return
      */
+    @Override
     public List<FinSysTenantDepartment> getByTenantId(Long agencyId) {
         StringBuilder sql = new StringBuilder("SELECT * FROM fin_sys_tenant_department WHERE 1 = 1 and is_delete = 0 ");
         HashMap<String, Object> paramts = new HashMap<>();
diff --git a/consum-base/src/main/java/com/consum/base/service/LWhFormTransferServiceImpl.java b/consum-base/src/main/java/com/consum/base/service/impl/LWhFormTransferServiceImpl.java
similarity index 93%
rename from consum-base/src/main/java/com/consum/base/service/LWhFormTransferServiceImpl.java
rename to consum-base/src/main/java/com/consum/base/service/impl/LWhFormTransferServiceImpl.java
index 199896f..1df2daf 100644
--- a/consum-base/src/main/java/com/consum/base/service/LWhFormTransferServiceImpl.java
+++ b/consum-base/src/main/java/com/consum/base/service/impl/LWhFormTransferServiceImpl.java
@@ -1,4 +1,4 @@
-package com.consum.base.service;
+package com.consum.base.service.impl;
 
 import com.consum.base.core.CodeGeneratorEnum;
 import com.consum.base.core.CodeGeneratorService;
@@ -15,10 +15,32 @@
 import com.consum.base.pojo.response.FormTransferGoodsVO;
 import com.consum.base.pojo.response.GoodsModelVO;
 import com.consum.base.pojo.response.LWHFromTransferExtendVO;
-import com.consum.model.po.*;
+import com.consum.base.service.BaseGoodsModelsServiceImpl;
+import com.consum.base.service.BaseWarehouseManagerService;
+import com.consum.base.service.BaseWarehouseServiceImpl;
+import com.consum.base.service.FinSysTenantServiceImpl;
+import com.consum.base.service.LWhFormOutputServiceImpl;
+import com.consum.base.service.LWhFormTransferService;
+import com.consum.base.service.LWhGoodsService;
+import com.consum.base.service.LWhProcureModelService;
+import com.consum.base.service.LWhProcureModelUserRecordServiceImpl;
+import com.consum.base.service.LWhProcureModelUserServiceImpl;
+import com.consum.model.po.BaseWarehouse;
+import com.consum.model.po.BaseWarehouseManager;
+import com.consum.model.po.FinSysTenant;
+import com.consum.model.po.FinSysTenantUser;
+import com.consum.model.po.LWhFormTransfer;
+import com.consum.model.po.LWhProcureModel;
+import com.consum.model.po.LWhProcureModelUser;
+import com.consum.model.po.LWhProcureModelUserRecord;
 import com.walker.db.page.GenericPager;
 import com.walker.infrastructure.utils.StringUtils;
 import com.walker.jdbc.service.BaseServiceImpl;
+import java.util.ArrayList;
+import java.util.HashMap;
+import java.util.List;
+import java.util.Map;
+import java.util.Optional;
 import org.apache.commons.compress.utils.Lists;
 import org.springframework.beans.BeanUtils;
 import org.springframework.beans.factory.annotation.Autowired;
@@ -26,15 +48,13 @@
 import org.springframework.transaction.interceptor.TransactionAspectSupport;
 import org.springframework.util.CollectionUtils;
 
-import java.util.*;
-
 /**
  * @Description 璋冩嫧绠$悊
  * @Author 鍗㈠簡闃�
  * @Date 2023/10/30
  */
 @Service
-public class LWhFormTransferServiceImpl extends BaseServiceImpl {
+public class LWhFormTransferServiceImpl extends BaseServiceImpl implements LWhFormTransferService {
 
     @Autowired
     private BaseWarehouseServiceImpl baseWarehouseService;
@@ -47,11 +67,7 @@
     @Autowired
     private LWhProcureModelService lWhProcureModelService;
     @Autowired
-    private LWhFormOutputCoreService lWhFormOutputCoreService;
-    @Autowired
     private LWhFormOutputServiceImpl lWhFormOutputService;
-    @Autowired
-    private LWhGoodsRecordService lWhGoodsRecordService;
     @Autowired
     private BaseGoodsModelsServiceImpl baseGoodsModelsService;
     @Autowired
@@ -60,8 +76,6 @@
     private LWhProcureModelUserRecordServiceImpl lWhProcureModelUserRecordService;
     @Autowired
     private BaseWarehouseManagerService baseWarehouseManagerService;
-    @Autowired
-    private BaseGoodsTemplateServiceImpl baseGoodsTemplateService;
 
     private static String QUERY_FORM_TRANSFER_LIST = "SELECT ft.* FROM l_wh_form_transfer ft "
         + "left join L_WH_PROCURE_MODEL pm on pm.BUSINESS_ID = ft.id "
@@ -346,13 +360,16 @@
         List<FormTransferGoodsVO> formTransferGoods = Lists.newArrayList();
         for (Map<String, Object> map : procureModelList) {
             FormTransferGoodsVO procureTemplateInfoVO = MapUtils.convertMapToObj(map, FormTransferGoodsVO.class);
-
+            Long baseGoodsTemplateId = procureTemplateInfoVO.getId();
             // 鏌ヨ鍨嬪彿鏁伴噺
             List<GoodsModelVO> goodsModelVOList = Lists.newArrayList();
             String sql2 = "SELECT pm.id,pm.BASE_GOODS_MODELS_NAME,bgm.UNIT,COUNTS,total_amount "
                 + "FROM l_wh_procure_model pm LEFT JOIN base_goods_models bgm ON bgm.id = pm.BASE_GOODS_MODELS_ID "
-                + "LEFT JOIN base_goods_template bgt ON bgt.id = bgm.GOODS_TEMPLATES_ID " + "WHERE pm.BUSINESS_ID =:id";
-            List<Map<String, Object>> modelList = lWhFormOutputService.select(sql2, paramMap, new MapperUtil());
+                + "LEFT JOIN base_goods_template bgt ON bgt.id = bgm.GOODS_TEMPLATES_ID " + "WHERE pm.BUSINESS_ID =:id and bgt.id =:baseGoodsTemplateId";
+            Map<String, Object> goodsModelParamMap = new HashMap<>();
+            goodsModelParamMap.put("id", result.getId());
+            goodsModelParamMap.put("baseGoodsTemplateId", baseGoodsTemplateId);
+            List<Map<String, Object>> modelList = lWhFormOutputService.select(sql2, goodsModelParamMap, new MapperUtil());
             modelList.forEach(item -> {
                 GoodsModelVO goodsModelVO = MapUtils.convertMapToObj(item, GoodsModelVO.class);
                 Integer businessType = result.getBusinessType();
@@ -381,9 +398,8 @@
 
                 }
                 goodsModelVOList.add(goodsModelVO);
+                procureTemplateInfoVO.setModels(goodsModelVOList);
             });
-
-            procureTemplateInfoVO.setModels(goodsModelVOList);
             formTransferGoods.add(procureTemplateInfoVO);
         }
         result.setFormTransferGoods(formTransferGoods);
@@ -577,4 +593,11 @@
         return select;
 
     }
+
+    @Override
+    public LWhFormTransfer selectById(Long id) {
+        LWhFormTransfer lWhFormTransfer = new LWhFormTransfer();
+        lWhFormTransfer.setId(id);
+        return this.get(lWhFormTransfer);
+    }
 }
diff --git a/consum-base/src/main/java/com/consum/base/service/impl/UsingFormBackServiceImpl.java b/consum-base/src/main/java/com/consum/base/service/impl/UsingFormBackServiceImpl.java
index d4a2747..0015988 100644
--- a/consum-base/src/main/java/com/consum/base/service/impl/UsingFormBackServiceImpl.java
+++ b/consum-base/src/main/java/com/consum/base/service/impl/UsingFormBackServiceImpl.java
@@ -19,11 +19,15 @@
 import com.consum.base.pojo.response.UsingFormBackModelInfo;
 import com.consum.base.pojo.response.UsingFormBackVO;
 import com.consum.base.service.BaseCategoryServiceImpl;
+import com.consum.base.service.FinSysTenantDepartmentService;
+import com.consum.base.service.LWhFormTransferService;
 import com.consum.base.service.UsingFormBackGoodsService;
 import com.consum.base.service.UsingFormBackModelService;
 import com.consum.base.service.UsingFormBackService;
 import com.consum.model.po.BaseCategory;
+import com.consum.model.po.FinSysTenantDepartment;
 import com.consum.model.po.FinSysTenantUser;
+import com.consum.model.po.LWhFormTransfer;
 import com.consum.model.po.UsingFormBack;
 import com.consum.model.po.UsingFormBackGoods;
 import com.consum.model.po.UsingFormBackModel;
@@ -59,13 +63,20 @@
     private UsingFormBackModelService usingFormBackModelService;
     @Autowired
     private UsingFormBackGoodsService usingFormBackGoodsService;
-
+    @Autowired
+    private FinSysTenantDepartmentService finSysTenantDepartmentService;
+    @Autowired
+    private LWhFormTransferService lWhFormTransferService;
 
     @Override
     public void add(UsingFormBackParam usingFormBackParam, FinSysTenantUser sysInfo) {
 
         Long departmentId = usingFormBackParam.getDepartmentId();
-        String departmentName = usingFormBackParam.getDepartmentName();
+        FinSysTenantDepartment department = finSysTenantDepartmentService.getById(departmentId);
+        if (department == null) {
+            throw new RuntimeException("閮ㄩ棬涓嶅瓨鍦�");
+        }
+        String departmentName = department.getName();
         Long operatorId = usingFormBackParam.getOperatorId();
         String operatorName = usingFormBackParam.getOperatorName();
         Long backTime = usingFormBackParam.getDealTime();
@@ -93,8 +104,12 @@
             usingFormBackGoods.setClassification(classification);
             usingFormBackGoods.setTransBusinessId(transBusinessId);
             usingFormBackGoods.setBusinessFormCode(businessFormCode);
-//            usingFormBackGoods.setTransOutWarehouseType();
-//            usingFormBackGoods.setTransOutWarehouseId();
+
+            LWhFormTransfer lWhFormTransfer = lWhFormTransferService.selectById(transBusinessId);
+            Integer outWarehouseType = lWhFormTransfer.getOutWarehouseType();
+            Long outWarehouseId = lWhFormTransfer.getOutWarehouseId();
+            usingFormBackGoods.setTransOutWarehouseType(outWarehouseType);
+            usingFormBackGoods.setTransOutWarehouseId(outWarehouseId);
 
             usingFormBackModelService.insert(usingFormBackGoods);
             for (baseGoodModel model : backingGoodsInfo.getModels()) {
@@ -180,7 +195,7 @@
             map.put("agencyId", agencyId);
         }
         if (StringUtils.isNotEmpty(createName)) {
-            sql.append("AND ufb.CREATE_NAME = :createName ");
+            sql.append("AND ufb.OPERATOR_NAME = :createName ");
             map.put("createName", createName);
         }
         sql.append("ORDER BY ufb.CREATE_TIME DESC ");
@@ -194,7 +209,8 @@
             Long id = usingFormBackVO.getId();
             StringBuilder countSql = new StringBuilder("SELECT \n"
                 + "\tufbg.BASE_GOODS_TEMPLATE_NAME,\n"
-                + "\tsum(ufbm.COUNTS) count\n"
+                + "\tsum(ufbm.COUNTS) count,\n"
+                + "\tufbm.UNIT\n"
                 + "FROM\n"
                 + "\tusing_form_back_goods ufbg\n"
                 + "\tLEFT JOIN using_form_back_model ufbm ON ufbg.ID = ufbm.USING_FORM_BACK_GOODS_ID\n"
@@ -350,7 +366,7 @@
             map.put("agencyId", agencyId);
         }
         if (StringUtils.isNotEmpty(createName)) {
-            sql.append("AND ufb.CREATE_NAME = :createName ");
+            sql.append("AND ufb.OPERATOR_NAME = :createName ");
             map.put("createName", createName);
         }
         sql.append("ORDER BY ufb.CREATE_TIME DESC ");
@@ -373,9 +389,9 @@
         UsingFormBack usingFormBack = new UsingFormBack();
         usingFormBack.setId(IdUtil.generateId());
         usingFormBack.setBusinessFormCode(codeGeneratorService.createBusinessFormCode(CodeGeneratorEnum.GOBACK));
-//        usingFormBack.setOutWarehouseType();
-//        usingFormBack.setOutWarehouseId();
-//        usingFormBack.setOutWarehouseName();
+        usingFormBack.setOutWarehouseType(1);
+        usingFormBack.setOutWarehouseId(departmentId);
+        usingFormBack.setOutWarehouseName(departmentName);
 
         String tenantId = sysInfo.getTenantId();
         String tenantName = sysInfo.getTenantName();
@@ -384,9 +400,14 @@
         usingFormBack.setCreateTime(DateUtils.getDateTimeNumber(System.currentTimeMillis()));
         usingFormBack.setStates(1);
 
-        usingFormBack.setDepartmentId(departmentId);
-        usingFormBack.setDepartmentName(departmentName);
-        usingFormBack.setOperatorId(operatorId);
+        Long sysDeptId = sysInfo.getSysDeptId();
+        FinSysTenantDepartment department = finSysTenantDepartmentService.getById(sysDeptId);
+        if (department == null) {
+            throw new RuntimeException("閮ㄩ棬涓嶅瓨鍦�");
+        }
+        usingFormBack.setDepartmentId(department.getId());
+        usingFormBack.setDepartmentName(department.getName());
+        usingFormBack.setOperatorId(sysInfo.getId());
         usingFormBack.setOperatorName(operatorName);
         usingFormBack.setDealTime(backTime);
         usingFormBack.setProcureDoc(procureDoc);

--
Gitblit v1.9.1