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/recovery/controller/RecoveryController.java | 37 ++++++++++++++++++++++++++++++++-----
1 files changed, 32 insertions(+), 5 deletions(-)
diff --git a/src/main/java/org/springblade/modules/recovery/controller/RecoveryController.java b/src/main/java/org/springblade/modules/recovery/controller/RecoveryController.java
index b502f55..4c0fcb5 100644
--- a/src/main/java/org/springblade/modules/recovery/controller/RecoveryController.java
+++ b/src/main/java/org/springblade/modules/recovery/controller/RecoveryController.java
@@ -21,6 +21,7 @@
import org.springblade.modules.recovery.entity.Recovery;
import org.springblade.modules.recovery.service.RecoveryService;
import org.springblade.modules.recovery.vo.RecoveryVO;
+import org.springblade.modules.stock.vo.StocksVO;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.web.bind.annotation.*;
@@ -29,6 +30,7 @@
import java.text.DecimalFormat;
import java.text.SimpleDateFormat;
import java.util.Date;
+import java.util.List;
/**
* 农事记录控制器
@@ -103,7 +105,8 @@
record.setType("12");
record.setLandId(recovery.getLandId());
record.setDeptId(recovery.getDeptId());
- record.setStrainId(recovery.getStrainId());
+ record.setTenantId(recovery.getTenantId());
+ record.setStrainId(Integer.parseInt(recovery.getStrainId()));
record.setOperator(recovery.getOperator());
Strain strain = strainService.getById(recovery.getStrainId());
record.setContent("品种: " + strain.getStrainName() + ", 重量：" + recovery.getWeight());
@@ -111,10 +114,10 @@
farmingRecordService.save(record);
//库存
- //先查询是否有该农产品的库存
+ //先查询是否有该农产品的库存(根据地块，农产品)
FarmProductStock stock = new FarmProductStock();
- stock.setFarmPlantId(recovery.getFarmPlantId());
- stock.setStrainId(recovery.getStrainId());
+ stock.setStrainId(Integer.parseInt(recovery.getStrainId()));
+ stock.setLandId(recovery.getLandId());
FarmProductStock stock1 = farmProductStockService.getOne(new QueryWrapper<>(stock));
if (null != stock1) {
//更新库存
@@ -123,6 +126,11 @@
double now = Double.parseDouble(recovery.getWeight());
double addNum = add(old, now);
stock1.setWeight(String.valueOf(addNum));
+
+ //总采收
+ double olds = Double.parseDouble(stock1.getRecovery());
+ double addNums = add(olds, now);
+ stock1.setRecovery(String.valueOf(addNums));
//更新
farmProductStockService.updateById(stock1);
} else {
@@ -132,11 +140,13 @@
productStock.setLeaves(recovery.getLeaves());
productStock.setOperator(recovery.getOperator());
productStock.setTime(recovery.getTime());
- productStock.setStrainId(recovery.getStrainId());
+ productStock.setStrainId(Integer.parseInt(recovery.getStrainId()));
productStock.setWeight(recovery.getWeight());
+ productStock.setRecovery(recovery.getWeight());
productStock.setFarmPlantId(recovery.getFarmPlantId());
productStock.setTenantId(recovery.getTenantId());
productStock.setDeptId(recovery.getDeptId());
+ productStock.setLandId(recovery.getLandId());
//新增操作
farmProductStockService.save(productStock);
}
@@ -191,6 +201,23 @@
return R.status(recoveryService.removeByIds(Func.toLongList(ids)));
}
+ /**
+ * 数据统计采收详情
+ */
+ @PostMapping("/recoveryStatistics")
+ public R<IPage<RecoveryVO>> recoveryStatistics(RecoveryVO recoveryVO, Query query){
+ IPage<RecoveryVO> pages = recoveryService.recoveryStatistics(Condition.getPage(query), recoveryVO);
+ return R.data(pages);
+ }
+
+ /**
+ * xcx数据统计采收详情
+ */
+ @GetMapping("/recoveryStatisticsx")
+ public R recoveryStatisticsx( RecoveryVO recoveryVO, Query query){
+ IPage<RecoveryVO> pages = recoveryService.recoveryStatisticsx(Condition.getPage(query), recoveryVO);
+ return R.data(pages);
+ }
/**
* 小程序采收详情列表自定义分页
--
Gitblit v1.9.3