From 72b971c98c46531064d74b68fc8fe8864ed0b544 Mon Sep 17 00:00:00 2001
From: guoshilong <123456>
Date: Tue, 08 Nov 2022 09:04:56 +0800
Subject: [PATCH] 大屏溯源统计次数sql修改
---
src/main/java/org/springblade/modules/InventoryLoss/controller/InventoryController.java | 33 ++++++++++++++++++++++++++-------
1 files changed, 26 insertions(+), 7 deletions(-)
diff --git a/src/main/java/org/springblade/modules/InventoryLoss/controller/InventoryController.java b/src/main/java/org/springblade/modules/InventoryLoss/controller/InventoryController.java
index ebd86c8..920438d 100644
--- a/src/main/java/org/springblade/modules/InventoryLoss/controller/InventoryController.java
+++ b/src/main/java/org/springblade/modules/InventoryLoss/controller/InventoryController.java
@@ -28,6 +28,7 @@
import org.springblade.core.tool.api.R;
import org.springblade.core.tool.utils.Func;
import org.springblade.core.tool.utils.StringUtil;
+import org.springblade.modules.farmplant.entity.FarmProductStock;
import org.springblade.modules.farmplant.service.FarmProductStockService;
import org.springblade.modules.InventoryLoss.entity.Inventory;
import org.springblade.modules.InventoryLoss.service.InventoryService;
@@ -35,6 +36,8 @@
import org.springblade.modules.process.service.IProcessService;
import org.springblade.modules.processInv.entity.ProcessInv;
import org.springblade.modules.processInv.service.IProcessInvService;
+import org.springblade.modules.processInv.vo.ProcessInvVO;
+import org.springblade.modules.sale.entity.Sale;
import org.springframework.web.bind.annotation.*;
import javax.validation.Valid;
@@ -61,7 +64,7 @@
*/
@GetMapping("/detail")
@ApiOperationSupport(order = 1)
- @ApiOperation(value = "详情", notes = "传入sale")
+ @ApiOperation(value = "详情", notes = "传入inventory")
public R<Inventory> detail(Inventory inventory) {
Inventory detail = inventoryService.getOne(Condition.getQueryWrapper(inventory));
return R.data(detail);
@@ -72,7 +75,7 @@
*/
@GetMapping("/list")
@ApiOperationSupport(order = 2)
- @ApiOperation(value = "分页", notes = "传入sale")
+ @ApiOperation(value = "分页", notes = "传入inventory")
public R<IPage<Inventory>> list(Inventory inventory, Query query) {
IPage<Inventory> pages = inventoryService.page(Condition.getPage(query), Condition.getQueryWrapper(inventory));
return R.data(pages);
@@ -83,7 +86,7 @@
*/
@GetMapping("/page")
@ApiOperationSupport(order = 3)
- @ApiOperation(value = "分页", notes = "传入sale")
+ @ApiOperation(value = "分页", notes = "传入inventory")
public R<IPage<InventoryVO>> page(InventoryVO inventory, Query query) {
IPage<InventoryVO> pages = inventoryService.selectSalePage(Condition.getPage(query), inventory);
return R.data(pages);
@@ -94,7 +97,7 @@
*/
@PostMapping("/save")
@ApiOperationSupport(order = 4)
- @ApiOperation(value = "新增", notes = "传入sale")
+ @ApiOperation(value = "新增", notes = "传入inventory")
public R save(@Valid @RequestBody Inventory inventory) {
return R.status(inventoryService.save(inventory));
}
@@ -104,7 +107,7 @@
*/
@PostMapping("/update")
@ApiOperationSupport(order = 5)
- @ApiOperation(value = "修改", notes = "传入sale")
+ @ApiOperation(value = "修改", notes = "传入inventory")
public R update(@Valid @RequestBody Inventory inventory) {
return R.status(inventoryService.updateById(inventory));
}
@@ -114,7 +117,7 @@
*/
@PostMapping("/submit")
@ApiOperationSupport(order = 6)
- @ApiOperation(value = "新增或修改", notes = "传入sale")
+ @ApiOperation(value = "新增或修改", notes = "传入inventory")
public R submit(@Valid @RequestBody InventoryVO inventory) {
boolean res = farmProductStockService.stockCompare(inventory.getSaleNum(),inventory.getProid());
if (!res){
@@ -123,6 +126,7 @@
//库存充足，减去相应库存
farmProductStockService.stockReduce(inventory.getSaleNum(),inventory.getProid());
}
+ inventory.setProdId(inventory.getProid());
return R.status(inventoryService.saveOrUpdate(inventory));
}
@@ -131,7 +135,7 @@
*/
@PostMapping("/submitProcess")
@ApiOperationSupport(order = 8)
- @ApiOperation(value = "新增或修改", notes = "传入sale")
+ @ApiOperation(value = "新增或修改", notes = "传入inventory")
public R submitProcess(@Valid @RequestBody InventoryVO inventory) {
// boolean res = processService.stockCompare(inventory.getSaleNum(),inventory.getProid());
// if (!res){
@@ -152,8 +156,11 @@
processInv.setUpdateUser(inventory.getCreateUser());
processInv.setUpdateTime(new Date());
processInv.setId(Long.parseLong(inventory.getProid()));
+ ProcessInvVO processInvVO = processInvService.getLand(processInv);
+ inventory.setLandId(processInvVO.getLandId());
processInvService.updateById(processInv);
}
+ inventory.setProdId(inventory.getProid());
return R.status(inventoryService.saveOrUpdate(inventory));
}
@@ -164,6 +171,18 @@
@ApiOperationSupport(order = 7)
@ApiOperation(value = "逻辑删除", notes = "传入ids")
public R remove(@ApiParam(value = "主键集合", required = true) @RequestParam String ids) {
+ Inventory inventory = inventoryService.getById(Long.parseLong(ids));
+ if (inventory.getType() == 0){
+ FarmProductStock farmProductStock = farmProductStockService.getById(inventory.getProdId());
+ Double weight = Double.parseDouble(farmProductStock.getWeight())+inventory.getSaleNum();
+ farmProductStock.setWeight(weight.toString());
+ farmProductStockService.updateById(farmProductStock);
+ }else {
+ ProcessInv inv = processInvService.findById(inventory.getProdId());
+ Double weight = inv.getProductInventoryNum()+inventory.getSaleNum();
+ inv.setProductInventoryNum(weight);
+ processInvService.updateById(inv);
+ }
return R.status(inventoryService.deleteLogic(Func.toLongList(ids)));
}
--
Gitblit v1.9.3