From bf321083251d5a14f4043ab0d70295b7af8610e6 Mon Sep 17 00:00:00 2001
From: cy <1664593601@qq.com>
Date: 星期六, 02 十二月 2023 11:19:24 +0800
Subject: [PATCH] feat: id生成方法替换
---
consum-base/src/main/java/com/consum/base/core/WarehouseCoreService.java | 332 +++++++++++++++++++++++++++++++++++++++++++++++--------
1 files changed, 284 insertions(+), 48 deletions(-)
diff --git a/consum-base/src/main/java/com/consum/base/core/WarehouseCoreService.java b/consum-base/src/main/java/com/consum/base/core/WarehouseCoreService.java
index e21dd52..265d3ad 100644
--- a/consum-base/src/main/java/com/consum/base/core/WarehouseCoreService.java
+++ b/consum-base/src/main/java/com/consum/base/core/WarehouseCoreService.java
@@ -1,14 +1,20 @@
package com.consum.base.core;
-import com.consum.base.core.tools.SqlParameter;
+import com.consum.base.core.param.BaseWarehouseParam;
+import com.consum.base.core.utils.DateUtil;
+import com.consum.base.core.utils.IdUtil;
+import com.consum.base.core.utils.SqlParameter;
import com.consum.model.po.*;
import com.walker.infrastructure.utils.NumberGenerator;
import com.walker.jdbc.service.BaseServiceImpl;
import lombok.extern.slf4j.Slf4j;
+import org.springframework.beans.BeanUtils;
import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Propagation;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.util.Assert;
+import java.util.ArrayList;
import java.util.List;
@@ -17,8 +23,8 @@
*/
@Service
@Slf4j
+@Transactional(rollbackFor = Exception.class, propagation = Propagation.REQUIRED)
public class WarehouseCoreService extends BaseServiceImpl {
-
public static void main(String[] args) {
WhGoods goods = new WhGoods();
@@ -31,23 +37,31 @@
System.out.println(mapper.getInsertSql_().getSql());
}
+
+
/**
* 缁熶竴鍑哄叆搴�
*/
- public CheckWarehouseResult unifyCheck(CheckWarehouseParam param) {
+ public List<CheckUsingResult> unifyUsingCheck(CheckUsingParam param) {
// TODO: 10/10/2023 姝ゅ鍔犱簡鍞竴閿侊紝浼氬奖鍝嶆�ц兘锛屾�濊�冩槸鍚︽湁鏇村悎閫傜殑鍔炴硶
try {
- Assert.notNull(param, "wareHouse param can not null !");
- Assert.notNull(param.getWarehouseId(), "wareHouse id can not null");
- CheckWarehouseResult result;
- synchronized (param.getWarehouseId()) {
+
+ List<CheckUsingResult> results;
+
+
+ String key = param.getLending_id().toString();
+
+ /**
+ * 姝ゅ灏嗗悓涓�涓粨搴撲笅鐨勫悓涓�涓瀷鍙蜂笂閿侊紝涓嶅悓浠撳簱銆佷笉鍚屽瀷鍙蜂笉鍙楀奖鍝嶃��
+ */
+ synchronized (key) {
if (param.getIsCheckIn()) {
- result = checkin(param);
+ results = checkUsingIn(param);
} else {
- result = checkout(param);
+ results = checkUsingOut(param);
}
}
- return result;
+ return results;
} catch (Exception e) {
log.error(e.getMessage());
throw new RuntimeException(e.getMessage());
@@ -56,37 +70,263 @@
}
/**
+ * 缁熶竴鍑哄叆搴�
+ */
+ public List<CheckWarehouseResult> unifyCheck(BaseWarehouseParam param) {
+ // TODO: 10/10/2023 姝ゅ鍔犱簡鍞竴閿侊紝浼氬奖鍝嶆�ц兘锛屾�濊�冩槸鍚︽湁鏇村悎閫傜殑鍔炴硶
+ try {
+ Assert.notNull(param, "wareHouse param can not null !");
+ Assert.notNull(param.getWarehouseId(), "wareHouse id can not null");
+ List<CheckWarehouseResult> results;
+
+ String key = param.getWarehouseId().toString() + param.getModelId().toString();
+
+ /**
+ * 姝ゅ灏嗗悓涓�涓粨搴撲笅鐨勫悓涓�涓瀷鍙蜂笂閿侊紝涓嶅悓浠撳簱銆佷笉鍚屽瀷鍙蜂笉鍙楀奖鍝嶃��
+ */
+ synchronized (key) {
+ if (param.getIsCheckIn()) {
+ results = new ArrayList<>();
+ results.add(checkin(param));
+ } else {
+ results = checkout(param);
+ }
+ }
+ return results;
+ } catch (Exception e) {
+ log.error(e.getMessage());
+ throw new RuntimeException(e.getMessage());
+ }
+
+ }
+
+ /**
+ * 鍦ㄧ敤鐗╁搧鍑哄簱
+ * @param param
+ * @return
+ */
+ private List<CheckUsingResult> checkUsingOut(CheckUsingParam param){
+
+ String sql = "SELECT\n" +
+ " * \n" +
+ "FROM\n" +
+ " DEP_FORM_LENDING_MODEL a \n" +
+ "WHERE\n" +
+ " a.BASE_GOODS_MODELS_ID =:MODEL_ID \n" +
+ " AND DEP_FORM_LENDING_ID =:LENDING_ID \n" +
+ " AND USING_COUNT > 0\n" +
+ "ORDER BY\n" +
+ " PROCURE_DATE ASC PRICE DESC";
+
+ List<DepFormLendingModel> modelsList = this.select(sql,new SqlParameter("MODEL_ID", param.getModel_id())
+ .put("LENDING_ID",param.getLending_id()),new DepFormLendingModel());
+
+ List<CheckUsingResult> resultList = new ArrayList<>();
+
+ int shengyu = param.getOutputCount();
+ for (DepFormLendingModel model : modelsList) {
+
+ CheckUsingResult result = new CheckUsingResult();
+
+ DepFormLendingGoods goods = get(new DepFormLendingGoods(),"id=?",new Object[]{model.getDepFormLendingGoodsId()});
+
+ //濡傛灉鏄疉绫荤墿鍝侊紝鍒欓渶瑕佷笌鎸佹湁浜虹瓑鍚�
+ if (goods.getClassification() == "A" && (goods.getGoodsUserName().equals(param.getUser_name()))) {
+ continue;
+ }
+
+ //濡傛灉褰撳墠鎸佹湁浜烘寔鏈夌墿鍝佹暟閲忓ぇ浜庡嚭搴撴暟閲忥紝鍒欑洿鎺ュ噺鎺夋暟閲忓嵆鍙��
+ if (model.getUsingCount() > shengyu){
+ result.setInitial_count(model.getUsingCount());
+ result.setLendingModel(model);
+ model.setUsingCount(model.getCounts() - param.getOutputCount());
+ result.setEnd_count(model.getUsingCount());
+ update(model);
+ resultList.add(result);
+
+ goods.setUsingCount(goods.getUsingCount() - param.getOutputCount());
+ update(goods);
+
+ return resultList;
+ }
+
+ shengyu = shengyu - model.getUsingCount();
+ goods.setUsingCount(goods.getUsingCount() - model.getUsingCount());
+
+ result.setInitial_count(model.getUsingCount());
+ result.setLendingModel(model);
+ model.setUsingCount(0);
+ result.setEnd_count(0);
+ update(model);
+ resultList.add(result);
+
+ update(goods);
+ }
+ return resultList;
+ }
+
+ /**
+ * 鍦ㄧ敤鐗╁搧鍏�
+ * @param param
+ * @return
+ */
+ private List<CheckUsingResult> checkUsingIn(CheckUsingParam param){
+
+ DepFormLending lending = get(new DepFormLending(),"id=?",new Object[]{param.getLending_id()});
+
+ String sql = "SELECT\n" +
+ " * \n" +
+ "FROM\n" +
+ " DEP_FORM_LENDING_GOODS A \n" +
+ "WHERE\n" +
+ " A.DEP_FORM_LENDING_ID = :LENDING_ID";
+
+ List<DepFormLendingGoods> goodsList = this.select(sql,new SqlParameter()
+ .put("LENDING_ID",lending.getId()),new DepFormLendingGoods());
+
+ List<CheckUsingResult> resultList = new ArrayList<>();
+
+ for (DepFormLendingGoods goods : goodsList) {
+ for (CheckWarehouseResult output : param.getOutputList()) {
+ //濡傛灉鍑哄簱鐨勫瀷鍙蜂笌鍒嗗彂鍗曢噷鐨勫瀷鍙风浉鍚�
+ if (goods.getBaseGoodsModelsId().longValue() == output.getWhGoods().getBaseGoodsModelsId().longValue()){
+ DepFormLendingModel model = new DepFormLendingModel();
+ model.setId(IdUtil.generateId());
+ model.setCounts(goods.getCounts());
+ model.setDepFormLendingGoodsId(goods.getId());
+ model.setDepFormLendingId(goods.getDepFormLendingId());
+ model.setWhGoodsDetailsId(output.getWh_goods_detail_id());
+ model.setNowUserName(goods.getGoodsUserName());
+ model.setNowUserPhone(goods.getGoodsUserPhone());
+ model.setWhGoodsId(output.getWhGoods().getId());
+ //褰撳墠鍙娇鐢ㄦ暟閲�
+ model.setUsingCount(model.getCounts());
+ model.setWarehouseId(output.getWhGoods().getWarehouseId());
+ model.setWarehouseName(output.getWhGoods().getWarehouseName());
+ model.setAgencyId(lending.getAgencyId());
+ model.setAgencyName(lending.getAgencyName());
+ model.setDepartmentId(lending.getDepartmentId());
+ model.setDepartmentName(lending.getDepartmentName());
+ insert(model);
+
+ CheckUsingResult result = new CheckUsingResult();
+ result.setLendingModel(model);
+ result.setInitial_count(0);
+ result.setEnd_count(output.getInitial_count()-output.getEnd_count());
+ resultList.add(result);
+ }
+ }
+ }
+
+ return resultList;
+ }
+
+ /**
* 鍑哄簱
*/
- private CheckWarehouseResult checkout(CheckWarehouseParam param) {
- return new CheckWarehouseResult();
+ private List<CheckWarehouseResult> checkout(BaseWarehouseParam param) {
+ //鏌ヨ鍑烘寚瀹氫粨搴撱�佹寚瀹氬瀷鍙凤紝鐘舵�佷负姝ｅ父鐨勭殑搴撳瓨鐗╁搧锛屾寜鐓ч噰璐椂闂村�掑彊銆佷环鏍煎�掑彊鎺掑垪
+ String sql = "SELECT\n" +
+ " * \n" +
+ "FROM\n" +
+ " WH_GOODS \n" +
+ "WHERE\n" +
+ " WAREHOUSE_ID =:WAREHOUSE_ID \n" +
+ " AND BASE_GOODS_MODELS_ID =:BASE_GOODS_MODELS_ID \n" +
+ " AND STATES =1 \n" +
+ " AND WH_COUNT > 0 \n" +
+ " order by PROCURE_DATE asc PRICE DESC";
+ SqlParameter parameter = new SqlParameter();
+ parameter.add("WAREHOUSE_ID",param.getWarehouseId())
+ .add("BASE_GOODS_MODELS_ID",param.getModelId());
+ List<WhGoods> goodsList = select(sql,parameter,new WhGoods());
+ List<CheckWarehouseResult> resultList = new ArrayList<>();
+
+ int shengyu = param.getCount();
+
+ for (WhGoods goods : goodsList){
+ if (shengyu <= 0 ) break;
+
+ //濡傛灉搴撳瓨鏁伴噺澶т簬鍑哄簱鏁伴噺锛岀洿鎺ュ噺搴撳瓨
+ if (shengyu <= goods.getWhCount()){
+ shengyu = 0;
+
+ CheckWarehouseResult result = new CheckWarehouseResult();
+ result.setWhGoods(goods);
+ result.setInitial_count(goods.getWhCount());
+ goods.setWhCount(goods.getWhCount() - param.getCount());
+ result.setEnd_count(goods.getWhCount());
+ resultList.add(result);
+
+ //濡傛灉鍑忓簱瀛樺悗锛屽簱瀛樻暟涓�0锛屽垯鍙樻洿鐘舵�佷负宸插垹闄�
+ if (goods.getWhCount() == 0){
+ goods.setStates(0);
+ }
+ update(goods);
+
+ //濡傛灉鏄皟鎷ㄥ嚭搴� 2:璋冩嫧锛�3锛氭姤搴�
+ if (param.getOutput_type() == 2 || param.getOutput_type() == 3){
+ WhGoods nGoods = new WhGoods();
+ BeanUtils.copyProperties(goods,nGoods);
+ //鍙樻洿鐘舵�佷负璋冩嫧
+ nGoods.setStates(param.getOutput_type());
+ nGoods.setWhCount(param.getCount());
+ nGoods.setId(IdUtil.generateId());
+ insert(nGoods);
+
+ CheckWarehouseResult nresult = new CheckWarehouseResult();
+ nresult.setWhGoods(nGoods);
+ nresult.setInitial_count(0);
+ nresult.setEnd_count(nresult.getEnd_count());
+ resultList.add(nresult);
+ }
+
+ return resultList;
+
+ }
+
+ //濡傛灉搴撳瓨鏁伴噺灏忎簬鍑哄簱鏁伴噺锛屽垯闇�瑕佸嚑涓簱瀛樼墿鍝佷竴璧峰嚭搴撱��
+
+ CheckWarehouseResult result = new CheckWarehouseResult();
+ result.setInitial_count(goods.getWhCount());
+ result.setEnd_count(0);
+ result.setWhGoods(goods);
+ resultList.add(result);
+
+ shengyu = param.getCount() - goods.getWhCount();
+ if (shengyu < 0){
+ throw new RuntimeException("鍑哄簱鏃讹紝璁＄畻閿欒");
+ }
+ goods.setWhCount(0);
+ goods.setStates(0);
+ update(goods);
+ }
+
+ throw new RuntimeException("鍑哄簱鏃讹紝璁＄畻閿欒");
}
private BaseWarehouse getWarehouse(long id){
- BaseWarehouse w = get(new BaseWarehouse(),"ID=:ID",new Object[]{id});
+ BaseWarehouse w = get(new BaseWarehouse(),"ID=?",new Object[]{id});
return w;
}
/**
* 鍏ュ簱
*/
- private CheckWarehouseResult checkin(CheckWarehouseParam param) {
+ private CheckWarehouseResult checkin(BaseWarehouseParam param) throws RuntimeException {
//濡傛灉鏄噰璐叆搴�
if (param.getFirst_input_type() ==1){
- WhFormProcureModel procureModel = get(new WhFormProcureModel(),"ID=:ID",new Object[]{param.getFirstInputCode()});
- WhFormProcure procure = get(new WhFormProcure(),"ID=:ID",new Object[]{procureModel.getWhFormProcureId()});
-
+ WhFormProcureModel procureModel = get(new WhFormProcureModel(),"ID=?",new Object[]{param.getFirstInputCode()});
+ WhFormProcure procure = get(new WhFormProcure(),"ID=?",new Object[]{procureModel.getWhFormProcureId()});
WhGoods goods = new WhGoods();
- goods.setId(NumberGenerator.getLongSequenceNumber());
+ goods.setId(IdUtil.generateId());
goods.setBaseGoodsTemplateId(procureModel.getBaseGoodsTemplateId());
goods.setGoodsTemplateName(procureModel.getGoodsTemplateName());
goods.setBaseGoodsModelsId(procureModel.getBaseGoodsModelsId());
goods.setBaseGoodsModelsName(procureModel.getBaseGoodsModelsName());
goods.setWhCount(procureModel.getCounts());
- goods.setTransferCount(0);
- goods.setAllCount(procureModel.getCounts());
goods.setFirstInputCode(param.getFirstInputCode());
goods.setFirstInputType(param.getFirst_input_type());
goods.setFirstInputHisId(NumberGenerator.getLongSequenceNumber());
@@ -101,10 +341,15 @@
insert(goods);
CheckWarehouseResult result = new CheckWarehouseResult();
- result.setGoods(goods);
+ result.setWhGoods(goods);
result.setInitial_count(0);
- result.setEnd_count(goods.getAllCount());
+ result.setEnd_count(goods.getWhCount());
return result;
+ //闆舵槦鍏ュ簱
+ } else if (param.getFirst_input_type() ==2){
+
+ return null;
+
}
String sql = "SELECT\n" +
@@ -114,7 +359,8 @@
"WHERE\n" +
" WAREHOUSE_ID =:WAREHOUSE_ID \n" +
" AND FIRST_INPUT_CODE =:FIRST_INPUT_CODE \n" +
- " AND BASE_GOODS_MODELS_ID =:BASE_GOODS_MODELS_ID";
+ " AND BASE_GOODS_MODELS_ID =:BASE_GOODS_MODELS_ID" +
+ " order by PROCURE_DATE desc PRICE asc";
SqlParameter parameter = new SqlParameter();
parameter.add("WAREHOUSE_ID",param.getWarehouseId())
.add("FIRST_INPUT_CODE",param.getFirstInputCode())
@@ -122,35 +368,25 @@
List<WhGoods> goodsList = select(sql,parameter,new WhGoods());
- //绗竴娆″叆搴擄細閲囪喘鍏ュ簱鎴栬�呴浂鏄熷叆搴�
if (goodsList == null || goodsList.size() == 0){
- BaseGoodsModels m = new BaseGoodsModels();
- m.setId(param.getModelId());
- BaseGoodsModels models = get(m);
+ new RuntimeException("鏌ヤ笉鍒板巻鍙插簱瀛�");
+ return null;
+ }
- BaseGoodsTemplate t = new BaseGoodsTemplate();
- t.setId(models.getGoodsTemplatesId());
- BaseGoodsTemplate template = get(t);
+ for (WhGoods goods : goodsList){
+ CheckWarehouseResult result = new CheckWarehouseResult();
+ result.setWhGoods(goods);
+ result.setInitial_count(goods.getWhCount());
+ result.setEnd_count(goods.getWhCount() + param.getCount());
- BaseWarehouse w = new BaseWarehouse();
- w.setId(param.getWarehouseId());
- BaseWarehouse warehouse = get(w);
+ WhGoods newGoods = new WhGoods();
+ newGoods.setId(goods.getId());
+ newGoods.setWhCount(result.getEnd_count());
+ newGoods.setStates(1);
+ newGoods.setBackDate(DateUtil.getCurrentDateFor14());
+ this.update(newGoods);
- WhGoods goods = new WhGoods();
- goods.setId(NumberGenerator.getLongSequenceNumber());
- goods.setBaseGoodsTemplateId(template.getId());
- goods.setGoodsTemplateName(template.getGoodsName());
- goods.setBaseGoodsModelsId(models.getId());
- goods.setBaseGoodsModelsName(models.getModelName());
- goods.setWhCount(param.getCount());
- goods.setTransferCount(0);
- goods.setAllCount(param.getCount());
- goods.setFirstInputCode(param.getFirstInputCode());
-// goods.setFirstInputType(); 杩欎釜鍊煎湪涓氬姟浠ｇ爜灞傞潰娣诲姞
-// goods.setFirstInputHisId();杩欎釜鍊煎湪涓氬姟浠ｇ爜灞傞潰娣诲姞
- goods.setWarehouseId(param.getWarehouseId());
- goods.setWarehouseName(warehouse.getWarehouseName());
-
+ return result;
}
--
Gitblit v1.9.1