From d9865c5576c8ed413d2b69a36b3ec5f15bee015b Mon Sep 17 00:00:00 2001
From: value <z1292839451@163.com>
Date: 星期一, 22 四月 2024 00:33:36 +0800
Subject: [PATCH] 功能调整

---
 data-server/src/main/java/com/yuanchu/mom/service/impl/FansSubmitServiceImpl.java    |   13 ++++++++++++-
 system-run/src/main/resources/application-dev.yml                                    |    8 ++++----
 data-server/src/main/java/com/yuanchu/mom/service/impl/FinanceSubmitServiceImpl.java |   17 ++++++++++++++++-
 system-run/src/main/resources/application.yml                                        |    2 +-
 data-server/src/main/java/com/yuanchu/mom/controller/DataReportingController.java    |    2 --
 data-server/src/main/java/com/yuanchu/mom/dto/RegistrantCountDto.java                |    1 -
 data-server/src/main/resources/mapper/DataReportingMapper.xml                        |    2 +-
 7 files changed, 34 insertions(+), 11 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 e916fa2..a7c273c 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
@@ -270,7 +270,6 @@
         } 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++) {
@@ -325,7 +324,6 @@
         } 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++) {
diff --git a/data-server/src/main/java/com/yuanchu/mom/dto/RegistrantCountDto.java b/data-server/src/main/java/com/yuanchu/mom/dto/RegistrantCountDto.java
index 18c6d4f..1b54a9b 100644
--- a/data-server/src/main/java/com/yuanchu/mom/dto/RegistrantCountDto.java
+++ b/data-server/src/main/java/com/yuanchu/mom/dto/RegistrantCountDto.java
@@ -29,7 +29,6 @@
     @Size(max= 255,message="缂栫爜闀垮害涓嶈兘瓒呰繃255")
     @ApiModelProperty("鐧昏浜�")
     @Length(max= 255,message="缂栫爜闀垮害涓嶈兘瓒呰繃255")
-    @ValueTableShow(3)
     private String registrant;
 
     @ApiModelProperty("濮撳悕")
diff --git a/data-server/src/main/java/com/yuanchu/mom/service/impl/FansSubmitServiceImpl.java b/data-server/src/main/java/com/yuanchu/mom/service/impl/FansSubmitServiceImpl.java
index 70134e2..d468ac9 100644
--- a/data-server/src/main/java/com/yuanchu/mom/service/impl/FansSubmitServiceImpl.java
+++ b/data-server/src/main/java/com/yuanchu/mom/service/impl/FansSubmitServiceImpl.java
@@ -1,5 +1,6 @@
 package com.yuanchu.mom.service.impl;
 
+import cn.hutool.core.bean.BeanUtil;
 import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
 import com.baomidou.mybatisplus.core.metadata.IPage;
 import com.baomidou.mybatisplus.core.toolkit.Wrappers;
@@ -97,7 +98,17 @@
             date2 = LocalDateTime.parse(date + "T00:00:00").minusDays(1).format(DateTimeFormatter.ofPattern("yyyy-MM-dd"));
             fansSubmit.setCreateTime(LocalDateTime.parse(date + "T00:00:00"));
         }
-        fansSubmitMapper.insert(fansSubmit);
+        try {
+            FansSubmit fansSubmit1 = fansSubmitMapper.selectOne(Wrappers.<FansSubmit>lambdaQuery().eq(FansSubmit::getCustom, fansSubmit.getCustom()).eq(FansSubmit::getProduct, fansSubmit.getProduct()).eq(FansSubmit::getVx, fansSubmit.getVx()).last("limit 1"));
+            if(BeanUtil.isEmpty(fansSubmit1)){
+                fansSubmitMapper.insert(fansSubmit);
+            }else{
+                fansSubmit1.setFansAdd(fansSubmit.getFansAdd());
+                fansSubmitMapper.updateById(fansSubmit1);
+            }
+        }catch (Exception e){
+            e.printStackTrace();
+        }
         List<FansSubmit> fansSubmits = fansSubmitMapper.selectList(Wrappers.<FansSubmit>lambdaQuery().eq(FansSubmit::getProduct, fansSubmit.getProduct()).eq(FansSubmit::getVx, fansSubmit.getVx()).select(FansSubmit::getFansAdd).like(FansSubmit::getCreateTime, date));
         Integer sum = 0;
         for (FansSubmit fansSubmit2 : fansSubmits) {
diff --git a/data-server/src/main/java/com/yuanchu/mom/service/impl/FinanceSubmitServiceImpl.java b/data-server/src/main/java/com/yuanchu/mom/service/impl/FinanceSubmitServiceImpl.java
index c62702b..d42da6c 100644
--- a/data-server/src/main/java/com/yuanchu/mom/service/impl/FinanceSubmitServiceImpl.java
+++ b/data-server/src/main/java/com/yuanchu/mom/service/impl/FinanceSubmitServiceImpl.java
@@ -1,5 +1,6 @@
 package com.yuanchu.mom.service.impl;
 
+import cn.hutool.core.bean.BeanUtil;
 import cn.hutool.core.util.ObjectUtil;
 import com.baomidou.mybatisplus.core.metadata.IPage;
 import com.baomidou.mybatisplus.core.toolkit.Wrappers;
@@ -121,7 +122,21 @@
             date2 = LocalDateTime.parse(date + "T00:00:00").minusDays(1).format(DateTimeFormatter.ofPattern("yyyy-MM-dd"));
             financeSubmit.setCreateTime(LocalDateTime.parse(date + "T00:00:00"));
         }
-        financeSubmitMapper.insert(financeSubmit);
+        try {
+            FinanceSubmit financeSubmit1 = financeSubmitMapper.selectOne(Wrappers.<FinanceSubmit>lambdaQuery().eq(FinanceSubmit::getCompany, financeSubmit.getCompany()).eq(FinanceSubmit::getName, financeSubmit.getName()).last("limit 1"));
+            if(BeanUtil.isEmpty(financeSubmit1)){
+                financeSubmitMapper.insert(financeSubmit);
+            }else{
+                financeSubmit1.setConsumption(financeSubmit.getConsumption());
+                financeSubmit1.setAgentRebate(financeSubmit.getAgentRebate());
+                financeSubmit1.setMoney(financeSubmit.getMoney());
+                financeSubmit1.setEmployeeRebate(financeSubmit.getEmployeeRebate());
+                financeSubmit1.setEmployeeRebateMoney(financeSubmit.getEmployeeRebateMoney());
+                financeSubmitMapper.updateById(financeSubmit1);
+            }
+        }catch (Exception e){
+            e.printStackTrace();
+        }
         FinanceSubmit financeSubmit2 = financeSubmitMapper.selectOne(Wrappers.<FinanceSubmit>lambdaQuery().eq(FinanceSubmit::getCompany, financeSubmit.getCompany()).eq(FinanceSubmit::getName, financeSubmit.getName()).select(FinanceSubmit::getEmployeeRebate).like(FinanceSubmit::getCreateTime, date).orderByDesc(FinanceSubmit::getId).last("limit 1"));
         if(ObjectUtil.isEmpty(financeSubmit2))return 1;
         List<DataReporting> dataReportings = dataReportingMapper.selectList(Wrappers.<DataReporting>lambdaQuery().eq(DataReporting::getAgent, financeSubmit.getCompany()).eq(DataReporting::getName, financeSubmit.getName()).like(DataReporting::getCreateTime, date2));
diff --git a/data-server/src/main/resources/mapper/DataReportingMapper.xml b/data-server/src/main/resources/mapper/DataReportingMapper.xml
index 41bbdfe..c3aa0cd 100644
--- a/data-server/src/main/resources/mapper/DataReportingMapper.xml
+++ b/data-server/src/main/resources/mapper/DataReportingMapper.xml
@@ -79,7 +79,7 @@
         create_user
         from data_reporting
         where create_time &gt;= #{startTime} and create_time &lt;= #{endTime}
-        group by name2,product, date_format(create_time, '%Y-%m-%d')
+        group by department,product, date_format(create_time, '%Y-%m-%d')
         ) a
         <if test="ew.customSqlSegment != null and ew.customSqlSegment != ''">
             ${ew.customSqlSegment}
diff --git a/system-run/src/main/resources/application-dev.yml b/system-run/src/main/resources/application-dev.yml
index 6857656..3bef62d 100644
--- a/system-run/src/main/resources/application-dev.yml
+++ b/system-run/src/main/resources/application-dev.yml
@@ -5,20 +5,20 @@
 logging:
   config: classpath:logback-spring.xml
   # 鏃ュ織瀛樺偍璺緞+++++++++++++++++++++++++++杩愮淮闇�瑕侀厤缃�+++++++++++++++++++++++++++
-  file-location:
+  file-location: D:\椤圭洰鏂囦欢瀛樺偍\log
 
 # 鏁版嵁搴撳浠借矾寰�
 backup:
   # 鏁版嵁搴撳浠借矾寰�+++++++++++++++++++++++++++杩愮淮闇�瑕侀厤缃�+++++++++++++++++++++++++++
-  path: D:\楣撻洀鍏徃\frame-after
+  path: D:\椤圭洰鏂囦欢瀛樺偍\log
   # 鏁版嵁搴撳浠藉ぉ鏁�
   destiny: 7
   # 鏁版嵁搴撳浠藉伐鍏疯矾寰�+++++++++++++++++++++++++++杩愮淮闇�瑕侀厤缃�+++++++++++++++++++++++++++
-  mysqldump: E:\JavaCode\WMS\WMS_Admin\src\main\resources
+  mysqldump: D:\椤圭洰鏂囦欢瀛樺偍\log
 
 # 鐓х墖瀛樺偍璺緞+++++++++++++++++++++++++++杩愮淮闇�瑕侀厤缃�+++++++++++++++++++++++++++
 file:
-  path: D:/webapp/images
+  path: D:\椤圭洰鏂囦欢瀛樺偍\image
   # 涓婁紶鏂囦欢鍏佽鐨勬墿灞曞悕
   allowed: png,jpg,jpeg,gif
 
diff --git a/system-run/src/main/resources/application.yml b/system-run/src/main/resources/application.yml
index a43a119..cfbe348 100644
--- a/system-run/src/main/resources/application.yml
+++ b/system-run/src/main/resources/application.yml
@@ -26,4 +26,4 @@
   okhttp:
     enabled: true # 寮�鍚� okhttp
 
-outPath: D:/Download/
\ No newline at end of file
+outPath: D:\椤圭洰鏂囦欢瀛樺偍\image
\ No newline at end of file

--
Gitblit v1.9.3