From 3af951146aabb69d7857daf11a4bdef21c7ef77e Mon Sep 17 00:00:00 2001
From: value <z1292839451@163.com>
Date: 星期三, 22 五月 2024 09:54:29 +0800
Subject: [PATCH] 功能调整
---
data-server/src/main/java/com/yuanchu/mom/controller/DataReportingController.java | 102 ++++++++++++++++++++++++++++++++++++++++++++------
1 files changed, 89 insertions(+), 13 deletions(-)
diff --git a/data-server/src/main/java/com/yuanchu/mom/controller/DataReportingController.java b/data-server/src/main/java/com/yuanchu/mom/controller/DataReportingController.java
index a7c273c..d45ce6e 100644
--- a/data-server/src/main/java/com/yuanchu/mom/controller/DataReportingController.java
+++ b/data-server/src/main/java/com/yuanchu/mom/controller/DataReportingController.java
@@ -1,18 +1,19 @@
package com.yuanchu.mom.controller;
-import cn.hutool.core.io.FileUtil;
-import cn.hutool.core.io.resource.ResourceUtil;
+import cn.hutool.core.lang.Console;
import cn.hutool.core.text.csv.CsvData;
import cn.hutool.core.text.csv.CsvReader;
import cn.hutool.core.text.csv.CsvRow;
import cn.hutool.core.text.csv.CsvUtil;
import cn.hutool.core.util.ObjectUtil;
-import cn.hutool.core.util.StrUtil;
+import cn.hutool.poi.excel.ExcelUtil;
import com.alibaba.fastjson.JSON;
+import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.yuanchu.mom.annotation.ValueAuth;
import com.yuanchu.mom.dto.*;
import com.yuanchu.mom.exception.ErrorException;
+import com.yuanchu.mom.mapper.FansSubmitMapper;
import com.yuanchu.mom.pojo.DataReporting;
import com.yuanchu.mom.pojo.FansSubmit;
import com.yuanchu.mom.pojo.FinanceSubmit;
@@ -23,19 +24,22 @@
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import lombok.AllArgsConstructor;
+import org.springframework.transaction.annotation.Transactional;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;
-import javax.validation.constraints.NotBlank;
import java.io.IOException;
import java.io.InputStreamReader;
import java.math.BigDecimal;
import java.text.ParseException;
import java.text.SimpleDateFormat;
-import java.time.LocalDate;
import java.time.LocalDateTime;
import java.time.format.DateTimeFormatter;
import java.util.*;
+import java.util.concurrent.atomic.AtomicReference;
+import java.util.regex.Matcher;
+import java.util.regex.Pattern;
+import java.util.stream.Collectors;
@RequestMapping("/dataReporting")
@RestController
@@ -48,6 +52,8 @@
private FansSubmitService fansSubmitService;
private FinanceSubmitService financeSubmitService;
+
+ private FansSubmitMapper fansSubmitMapper;
@ApiOperation(value = "鑾峰彇鏁版嵁涓婃姤鍒楄〃")
@PostMapping("/selectDataReportingList")
@@ -90,10 +96,17 @@
public Result selectFansSubmitList(@RequestBody Map<String, Object> data) {
Page page = JSON.parseObject(JSON.toJSONString(data.get("page")), Page.class);
FansSubmit fansSubmit = JSON.parseObject(JSON.toJSONString(data.get("entity")), FansSubmit.class);
- if (ObjectUtil.isNotEmpty(fansSubmit.getCreateTime())){
+ if (ObjectUtil.isNotEmpty(fansSubmit.getCreateTime())) {
fansSubmit.setCreateTime(fansSubmit.getCreateTime().plusDays(1));
}
return Result.success(fansSubmitService.selectFansSubmitList(page, fansSubmit));
+ }
+
+ @ApiOperation(value = "鑾峰彇杩涚矇涓婃姤鎬绘暟")
+ @PostMapping("/countFansSubmitList")
+ @ValueAuth
+ public Result countFansSubmitList(@RequestBody FansSubmit fansSubmit) {
+ return Result.success(fansSubmitService.countFansSubmitList(fansSubmit));
}
@ApiOperation(value = "鍒犻櫎杩涚矇涓婃姤鍒楄〃")
@@ -119,7 +132,7 @@
public Result selectFinanceSubmitList(@RequestBody Map<String, Object> data) {
Page page = JSON.parseObject(JSON.toJSONString(data.get("page")), Page.class);
FinanceSubmit financeSubmit = JSON.parseObject(JSON.toJSONString(data.get("entity")), FinanceSubmit.class);
- if (ObjectUtil.isNotEmpty(financeSubmit.getCreateTime())){
+ if (ObjectUtil.isNotEmpty(financeSubmit.getCreateTime())) {
financeSubmit.setCreateTime(financeSubmit.getCreateTime().plusDays(1));
}
return Result.success(financeSubmitService.selectFinanceSubmitList(page, financeSubmit));
@@ -211,7 +224,7 @@
break;
}
}
- if(reporting.getAccountConsumption().compareTo(BigDecimal.ZERO) > 0) list.add(reporting);
+ if (reporting.getAccountConsumption().compareTo(BigDecimal.ZERO) > 0) list.add(reporting);
}
dataReportingService.addDataReporting(list, format, param);
return Result.success();
@@ -222,7 +235,7 @@
public Result<?> addDataReporting(@RequestBody DataReporting dataReporting) {
ArrayList<DataReporting> list = new ArrayList<>();
list.add(dataReporting);
- dataReportingService.addDataReporting(list, null,dataReporting.getVxCard());
+ dataReportingService.addDataReporting(list, null, dataReporting.getVxCard());
return Result.success();
}
@@ -260,8 +273,43 @@
@ApiOperation(value = "瀵煎叆杩涚矇涓婃姤鍒楄〃")
@PostMapping("/inputFansSubmitCsv")
+ @Transactional(rollbackFor = Exception.class)
public Result<?> inputFansSubmitCsv(@RequestParam("file") MultipartFile file) throws IOException {
- CsvReader reader = CsvUtil.getReader();
+ List<FansSubmit> fansSubmitLists = new ArrayList<>();
+ List<FansSubmit> fansSubmitList = new ArrayList<>();
+ List<String> dates = new ArrayList<>();
+ AtomicReference<String> product = new AtomicReference<>();
+ ExcelUtil.readBySax(file.getInputStream(), 0, (i, l, list) -> {
+ LocalDateTime date = null;
+ try {
+ date = LocalDateTime.parse((list.get(0) + "").replace(" ", "T")).plusDays(1);
+ dates.add(date.format(DateTimeFormatter.ofPattern("yyyy-MM-dd"))+" 00:00:00");
+ } catch (Exception e) {
+ if(!(l == 0 || l == 1 || l == 2)){
+ return;
+ }
+ }
+ if (l == 0 || l == 1 || l == 2
+ || date.compareTo(LocalDateTime.now()) < 1) {
+ for (int i1 = 1; i1 < list.size(); i1++) {
+ try {
+ FansSubmit fansSubmit = fansSubmitList.get(i1 - 1);
+ fansSubmit.setId(null);
+ product.set(getFansSubmit(l, list.get(i1), date, fansSubmit, product.get()));
+ } catch (IndexOutOfBoundsException e) {
+ FansSubmit fansSubmit = new FansSubmit();
+ product.set(getFansSubmit(l, list.get(i1), date, fansSubmit, product.get()));
+ fansSubmitList.add(fansSubmit);
+ }
+ }
+ if(l>2){
+ fansSubmitLists.addAll(JSON.parseArray(JSON.toJSONString(fansSubmitList.stream().filter(a -> !Objects.equals(a.getCustom(), "鍚堣")).collect(Collectors.toList())), FansSubmit.class));
+ }
+ }
+ });
+ fansSubmitMapper.delete(Wrappers.<FansSubmit>lambdaUpdate().in(FansSubmit::getCreateTime, dates));
+ fansSubmitService.saveBatch(fansSubmitLists);
+ /*CsvReader reader = CsvUtil.getReader();
CsvData data = reader.read(new InputStreamReader(file.getInputStream(), "GB2312"));
List<CsvRow> rows = data.getRows();
String format;
@@ -286,13 +334,41 @@
fansSubmit.setVx(str);
break;
case "杩涚矇":
- fansSubmit.setFansAdd(Integer.parseInt(str));
+ try {
+ fansSubmit.setFansAdd(Integer.parseInt(str));
+ }catch (Exception e){
+ fansSubmit.setFansAdd(0);
+ }
break;
}
}
fansSubmitService.addFansSubmit(fansSubmit, format);
- }
+ }*/
return Result.success();
+ }
+
+ public String getFansSubmit(long l, Object thing, LocalDateTime date, FansSubmit fansSubmit, String product) {
+ String str = (thing == null ? null : thing + "");
+ if(l==0){
+ if (str != null) product = str;
+ fansSubmit.setProduct(product);
+ }else if(l==1){
+ Pattern pattern = Pattern.compile("[\u4E00-\u9FA5]");
+ Matcher matcher = pattern.matcher(str == null ? "" : str);
+ if (matcher.find()) {
+ fansSubmit.setCustom(str);
+ } else {
+ fansSubmit.setVx(str);
+ }
+ }else if(l==2){
+ if (fansSubmit.getVx() == null) {
+ fansSubmit.setVx(str);
+ }
+ }else{
+ fansSubmit.setCreateTime(date);
+ fansSubmit.setFansAdd((str == null || str.equals("")) ? 0 : Integer.parseInt(str));
+ }
+ return product;
}
@ApiOperation(value = "鑾峰彇鏁版嵁瀵规瘮鍒楄〃")
@@ -403,7 +479,7 @@
@ApiOperation(value = "鎵归噺淇敼寰俊鍙�")
@PostMapping("/updateVxCards")
- public Result updateVxCards(String str){
+ public Result updateVxCards(String str) {
List<DataReporting> list = JSON.parseArray(str, DataReporting.class);
return Result.success(dataReportingService.updateVxCards(list));
}
--
Gitblit v1.9.3