From 02a11da1ca0523e4f8e3d7273904da816f951ffc Mon Sep 17 00:00:00 2001
From: 李林 <z1292839451@163.com>
Date: 星期五, 22 三月 2024 01:54:36 +0800
Subject: [PATCH] 系统调整
---
data-server/src/main/java/com/yuanchu/mom/controller/DataReportingController.java | 101 +++++++++++++++++++++++++++++++++++++++-----------
1 files changed, 78 insertions(+), 23 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 2aa2035..c21f0fd 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
@@ -6,11 +6,9 @@
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.CharsetUtil;
import com.alibaba.fastjson.JSON;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.yuanchu.mom.annotation.ValueAuth;
-import com.yuanchu.mom.common.GetLook;
import com.yuanchu.mom.dto.*;
import com.yuanchu.mom.exception.ErrorException;
import com.yuanchu.mom.pojo.DataReporting;
@@ -23,17 +21,13 @@
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import lombok.AllArgsConstructor;
-import org.apache.tomcat.util.http.fileupload.FileUtils;
-import org.springframework.util.FileCopyUtils;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;
-import java.io.File;
+import javax.validation.constraints.NotBlank;
import java.io.IOException;
import java.io.InputStreamReader;
import java.math.BigDecimal;
-import java.nio.charset.StandardCharsets;
-import java.nio.file.Files;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.time.LocalDate;
@@ -138,7 +132,7 @@
@ApiOperation(value = "娣诲姞璐㈠姟涓婃姤淇℃伅")
@PostMapping("/addFinanceSubmit")
public Result<?> addFinanceSubmit(@RequestBody FinanceSubmit financeSubmit, String date) {
- return Result.success(financeSubmitService.addFinanceSubmit(financeSubmit, date));
+ return Result.success(financeSubmitService.addFinanceSubmit(financeSubmit, date, financeSubmit.getParam()));
}
@ValueAuth
@@ -150,7 +144,7 @@
@ApiOperation(value = "瀵煎叆鏁版嵁涓婃姤鍒楄〃")
@PostMapping("/inputCsv")
- public Result<?> inputCsv(@RequestParam("file") MultipartFile file) throws IOException {
+ public Result<?> inputCsv(@RequestParam("file") MultipartFile file, String param) throws IOException {
CsvReader reader = CsvUtil.getReader();
CsvData data = reader.read(new InputStreamReader(file.getInputStream(), "GB2312"));
List<CsvRow> rows = data.getRows();
@@ -162,40 +156,57 @@
e.printStackTrace();
throw new ErrorException("鏂囦欢涓棩鏈熷湪杞崲鏃跺嚭鐜伴敊璇�");
}
- for (int i = 6; i < rows.size(); i++) {
+ int fieldIndex = 5;
+ for (int i = 0; i < rows.size(); i++) {
+ if (JSON.toJSONString(rows.get(i)).contains("璐︽埛ID")) {
+ fieldIndex = i;
+ break;
+ }
+ }
+ for (int i = fieldIndex + 1; i < rows.size(); i++) {
DataReporting reporting = new DataReporting();
- for (int i1 = 0; i1 < rows.get(5).size(); i1++) {
+ for (int i1 = 0; i1 < rows.get(fieldIndex).size(); i1++) {
String str = rows.get(i).get(i1);
if (str == null) continue;
- switch (rows.get(5).get(i1)) {
+ switch (rows.get(fieldIndex).get(i1)) {
case "璐︽埛":
reporting.setName(str);
break;
case "澶囨敞":
String[] split = str.split("-");
- if (split.length == 4) {
+ if (split.length > 3) {
reporting.setName2(split[0]);
- reporting.setChannel(split[1]);
- reporting.setAgent(split[2]);
- reporting.setProduct(split[3]);
+ reporting.setChannel(split[2]);
+ reporting.setAgent(split[3]);
+ reporting.setProduct(split[1]);
break;
}
reporting.setProduct(str);
break;
case "灞曠幇閲�":
- reporting.setShowNum(Integer.parseInt(str));
+ try {
+ reporting.setShowNum(Integer.parseInt(str));
+ } catch (Exception e) {
+ }
break;
case "鐐瑰嚮閲�":
- reporting.setClick(Integer.parseInt(str));
+ try {
+ reporting.setClick(Integer.parseInt(str));
+ } catch (Exception e) {
+ }
break;
case "娑堣垂":
- reporting.setAccountConsumption(new BigDecimal(str));
+ try {
+ reporting.setAccountConsumption(new BigDecimal(str));
+ } catch (Exception e) {
+ }
break;
}
}
list.add(reporting);
}
- dataReportingService.addDataReporting(list, format);
+ deleteAllData(format);
+ dataReportingService.addDataReporting(list, format, param);
return Result.success();
}
@@ -204,7 +215,7 @@
public Result<?> addDataReporting(@RequestBody DataReporting dataReporting) {
ArrayList<DataReporting> list = new ArrayList<>();
list.add(dataReporting);
- dataReportingService.addDataReporting(list, null);
+ dataReportingService.addDataReporting(list, null,dataReporting.getVxCard());
return Result.success();
}
@@ -252,6 +263,7 @@
} catch (ParseException e) {
throw new ErrorException("鏂囦欢涓棩鏈熷湪杞崲鏃跺嚭鐜伴敊璇�");
}
+ deleteAllFans(LocalDate.parse(format).plusDays(1).format(DateTimeFormatter.ofPattern("yyyy-MM-dd")));
for (int i = 6; i < rows.size(); i++) {
FansSubmit fansSubmit = new FansSubmit();
for (int i1 = 0; i1 < rows.get(5).size(); i1++) {
@@ -296,7 +308,7 @@
@ApiOperation(value = "瀵煎叆璐㈠姟涓婃姤鍒楄〃")
@PostMapping("/inputFinanceSubmitCsv")
- public Result<?> inputFinanceSubmitCsv(@RequestParam("file") MultipartFile file) throws IOException {
+ public Result<?> inputFinanceSubmitCsv(@RequestParam("file") MultipartFile file, String param) throws IOException {
CsvReader reader = CsvUtil.getReader();
CsvData data = reader.read(new InputStreamReader(file.getInputStream(), "GB2312"));
List<CsvRow> rows = data.getRows();
@@ -306,6 +318,7 @@
} catch (ParseException e) {
throw new ErrorException("鏂囦欢涓棩鏈熷湪杞崲鏃跺嚭鐜伴敊璇�");
}
+ deleteAllFinance(LocalDate.parse(format).plusDays(1).format(DateTimeFormatter.ofPattern("yyyy-MM-dd")));
for (int i = 6; i < rows.size(); i++) {
FinanceSubmit financeSubmit = new FinanceSubmit();
for (int i1 = 0; i1 < rows.get(5).size(); i1++) {
@@ -350,8 +363,50 @@
break;
}
}
- financeSubmitService.addFinanceSubmit(financeSubmit, format);
+ financeSubmitService.addFinanceSubmit(financeSubmit, format, param);
}
return Result.success();
}
+
+ @ApiOperation(value = "涓�閿垹闄ゆ墍鏈夋暟鎹笂鎶ョ殑鏁版嵁")
+ @PostMapping("/deleteAllData")
+ public Result deleteAllData(String date) {
+ dataReportingService.deleteAllData(date);
+ return Result.success();
+ }
+
+ @ApiOperation(value = "鑾峰彇鏁版嵁涓婃姤鐨勭櫥璁颁汉绛涢�夐」")
+ @PostMapping("/selectDataReportingForCreateUserNames")
+ @ValueAuth
+ public Result selectDataReportingForCreateUserNames(String time) {
+ return Result.success(dataReportingService.selectDataReportingForCreateUserNames(time));
+ }
+
+ @ApiOperation(value = "鑾峰彇寰俊鍙峰垪琛�")
+ @GetMapping("/selectVxs")
+ @ValueAuth
+ public Result selectVxs(String time) {
+ return Result.success(fansSubmitService.vxs(time));
+ }
+
+ @ApiOperation(value = "鎵归噺淇敼寰俊鍙�")
+ @PostMapping("/updateVxCards")
+ public Result updateVxCards(String str){
+ List<DataReporting> list = JSON.parseArray(str, DataReporting.class);
+ return Result.success(dataReportingService.updateVxCards(list));
+ }
+
+ @ApiOperation(value = "涓�閿垹闄ゆ墍鏈夎繘绮変笂鎶ョ殑鏁版嵁")
+ @PostMapping("/deleteAllFans")
+ public Result deleteAllFans(String date) {
+ fansSubmitService.deleteAllFans(date);
+ return Result.success();
+ }
+
+ @ApiOperation(value = "涓�閿垹闄ゆ墍鏈夎储鍔′笂鎶ョ殑鏁版嵁")
+ @PostMapping("/deleteAllFinance")
+ public Result deleteAllFinance(String date) {
+ financeSubmitService.deleteAllFinance(date);
+ return Result.success();
+ }
}
--
Gitblit v1.9.3