From 11978f0ae51b13a6f2b06979ef0573fa78fc6459 Mon Sep 17 00:00:00 2001
From: liusheng <337615773@qq.com>
Date: 星期二, 12 三月 2024 16:27:51 +0800
Subject: [PATCH] 代码提交

---
 ruoyi-project/src/main/resources/mapper/project/SpstatExpenseMapper.xml                           |    2 
 ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceFunddetailController.java       |    1 
 ruoyi-project/src/main/resources/mapper/project/SpstatCaseMapper.xml                              |    3 +
 ruoyi-project/src/main/resources/mapper/project/ServiceDonorchargeorganMapper.xml                 |    2 
 ruoyi-project/src/main/java/com/ruoyi/project/mapper/SpstatCaseMapper.java                        |    2 
 ruoyi-project/src/main/java/com/ruoyi/project/mapper/SpstatExpenseMapper.java                     |    2 
 ruoyi-project/src/main/java/com/ruoyi/project/domain/SpStatBonus.java                             |    2 
 ruoyi-project/src/main/java/com/ruoyi/project/domain/SpStatExpenseReq.java                        |    2 
 ruoyi-project/src/main/java/com/ruoyi/project/mapper/SpStatBonusMapper.java                       |   27 +++++++++++++
 ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceDonorchargeorganController.java |    2 
 ruoyi-project/src/main/java/com/ruoyi/project/service/impl/ServiceFunddetailServiceImpl.java      |    6 ++
 ruoyi-project/src/main/resources/mapper/project/ServiceFunddetailMapper.xml                       |    2 
 ruoyi-project/src/main/java/com/ruoyi/project/domain/SpStatBonusReq.java                          |    4 +-
 ruoyi-project/src/main/java/com/ruoyi/project/domain/SpStatCaseReq.java                           |    2 
 ruoyi-project/src/main/java/com/ruoyi/project/domain/SpStatChange.java                            |    6 +-
 ruoyi-project/src/main/java/com/ruoyi/project/mapper/ServiceFunddetailMapper.java                 |    2 -
 ruoyi-project/src/main/resources/mapper/project/SpStatBonusMapper.xml                             |   13 ++++++
 17 files changed, 61 insertions(+), 19 deletions(-)

diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceDonorchargeorganController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceDonorchargeorganController.java
index 90918ba..63356ee 100644
--- a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceDonorchargeorganController.java
+++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceDonorchargeorganController.java
@@ -161,7 +161,7 @@
 
     @ApiOperation("鏀惰垂缁熻")
     @PostMapping("/getListBySpStatChange")
-    public TableDataInfo getListBySpStatChange(SpStatChangeReq spStatChangeReq) {
+    public TableDataInfo getListBySpStatChange(@RequestBody SpStatChangeReq spStatChangeReq) {
         return getDataTable(serviceDonorchargeorganService.getListBySpStatChange(spStatChangeReq));
     }
 }
diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceFunddetailController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceFunddetailController.java
index 9d600a5..88b364d 100644
--- a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceFunddetailController.java
+++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceFunddetailController.java
@@ -185,7 +185,6 @@
      * 鏌ヨ缁╂晥濂栭噾缁熻
      */
     @ApiOperation("鏌ヨ缁╂晥濂栭噾缁熻")
-    //@PreAuthorize("@ss.hasPermi('project:fund:list')")
     @PostMapping("/getListBySpStatBonus")
     public TableDataInfo getListBySpStatBonus(@RequestBody SpStatBonusReq spStatBonusReq) {
         startPage();
diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/domain/SpStatBonus.java b/ruoyi-project/src/main/java/com/ruoyi/project/domain/SpStatBonus.java
index 4aa9763..285b984 100644
--- a/ruoyi-project/src/main/java/com/ruoyi/project/domain/SpStatBonus.java
+++ b/ruoyi-project/src/main/java/com/ruoyi/project/domain/SpStatBonus.java
@@ -27,7 +27,7 @@
      * 缁╂晥鏃ユ湡
      */
     @ApiModelProperty("缁╂晥鏃ユ湡")
-    private String jxrq;
+    private String bonusmonth;
 
     /**
      * 閮ㄩ棬id
diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/domain/SpStatBonusReq.java b/ruoyi-project/src/main/java/com/ruoyi/project/domain/SpStatBonusReq.java
index 8bae7e4..2d9dc19 100644
--- a/ruoyi-project/src/main/java/com/ruoyi/project/domain/SpStatBonusReq.java
+++ b/ruoyi-project/src/main/java/com/ruoyi/project/domain/SpStatBonusReq.java
@@ -38,13 +38,13 @@
      * pauserno
      */
     @ApiModelProperty("pauserno")
-    private Integer pauserno;
+    private String pauserno;
 
     /**
      * pabonustype
      */
     @ApiModelProperty("pabonustype")
-    private String pabonustype;
+    private Integer pabonustype;
 
 }
 
diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/domain/SpStatCaseReq.java b/ruoyi-project/src/main/java/com/ruoyi/project/domain/SpStatCaseReq.java
index 0dada2d..ae9dac9 100644
--- a/ruoyi-project/src/main/java/com/ruoyi/project/domain/SpStatCaseReq.java
+++ b/ruoyi-project/src/main/java/com/ruoyi/project/domain/SpStatCaseReq.java
@@ -38,7 +38,7 @@
      * pauserno
      */
     @ApiModelProperty("pauserno")
-    private Integer pauserno;
+    private String pauserno;
 
     /**
      * pacasestate
diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/domain/SpStatChange.java b/ruoyi-project/src/main/java/com/ruoyi/project/domain/SpStatChange.java
index 3c7f39d..6edd4d5 100644
--- a/ruoyi-project/src/main/java/com/ruoyi/project/domain/SpStatChange.java
+++ b/ruoyi-project/src/main/java/com/ruoyi/project/domain/SpStatChange.java
@@ -28,9 +28,9 @@
     /**
      * 鎺ユ敹鏈堜唤
      */
-    @ApiModelProperty("鎺ユ敹鏈堜唤")
-    @JsonFormat(pattern = "yyyy-MM")
-    private Date receivemonth;
+//    @ApiModelProperty("鎺ユ敹鏈堜唤")
+//    @JsonFormat(pattern = "yyyy-MM")
+    private String receivemonth;
 
     /**
      * 鍣ㄥ畼瀹為檯鏀跺埌璐圭敤
diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/domain/SpStatExpenseReq.java b/ruoyi-project/src/main/java/com/ruoyi/project/domain/SpStatExpenseReq.java
index 5a9d939..ed4951f 100644
--- a/ruoyi-project/src/main/java/com/ruoyi/project/domain/SpStatExpenseReq.java
+++ b/ruoyi-project/src/main/java/com/ruoyi/project/domain/SpStatExpenseReq.java
@@ -37,7 +37,7 @@
      * pauserno
      */
     @ApiModelProperty("pauserno")
-    private Integer pauserno;
+    private String pauserno;
 
     /**
      * pacasestate
diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/mapper/ServiceFunddetailMapper.java b/ruoyi-project/src/main/java/com/ruoyi/project/mapper/ServiceFunddetailMapper.java
index 7827249..ee1c509 100644
--- a/ruoyi-project/src/main/java/com/ruoyi/project/mapper/ServiceFunddetailMapper.java
+++ b/ruoyi-project/src/main/java/com/ruoyi/project/mapper/ServiceFunddetailMapper.java
@@ -57,6 +57,4 @@
 
     List<ServiceFunddetail> totlaTax(List<Long> fundids);
 
-    List<SpStatBonus> getListBySpStatBonus(@Param("PABEGTIME ") String PABEGTIME, @Param("PAENDTIME") String PAENDTIME, @Param("PADEPTNO") String PADEPTNO, @Param("PAUSERNO") Integer PAUSERNO, @Param("PABONUSTYPE") String PABONUSTYPE);
-
 }
diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/mapper/SpStatBonusMapper.java b/ruoyi-project/src/main/java/com/ruoyi/project/mapper/SpStatBonusMapper.java
new file mode 100644
index 0000000..eb85e26
--- /dev/null
+++ b/ruoyi-project/src/main/java/com/ruoyi/project/mapper/SpStatBonusMapper.java
@@ -0,0 +1,27 @@
+package com.ruoyi.project.mapper;
+
+
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.ruoyi.project.domain.FunddetailReqVo;
+import com.ruoyi.project.domain.ServiceFunddetail;
+import com.ruoyi.project.domain.SpStatBonus;
+import com.ruoyi.project.domain.vo.TaxMoneyByItemEO;
+import com.ruoyi.project.domain.vo.TaxMoneySumEO;
+import com.ruoyi.project.domain.vo.TaxMoneyVO;
+import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
+
+import java.util.List;
+
+/**
+ * 璐圭敤鐢宠鏄庣粏Mapper鎺ュ彛
+ *
+ * @author ruoyi
+ * @date 2022-01-25
+ */
+@Mapper
+public interface SpStatBonusMapper extends BaseMapper<SpStatBonus> {
+
+    List<SpStatBonus> getListBySpStatBonus(@Param("PABEGTIME") String PABEGTIME, @Param("PAENDTIME") String PAENDTIME, @Param("PADEPTNO") String PADEPTNO, @Param("PAUSERNO") String PAUSERNO, @Param("PABONUSTYPE") Integer PABONUSTYPE);
+
+}
diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/mapper/SpstatCaseMapper.java b/ruoyi-project/src/main/java/com/ruoyi/project/mapper/SpstatCaseMapper.java
index c0636d3..0cec29e 100644
--- a/ruoyi-project/src/main/java/com/ruoyi/project/mapper/SpstatCaseMapper.java
+++ b/ruoyi-project/src/main/java/com/ruoyi/project/mapper/SpstatCaseMapper.java
@@ -17,6 +17,6 @@
 @Mapper
 public interface SpstatCaseMapper extends BaseMapper<SpStatCase> {
 
-    List<SpStatCase> getListBypower(@Param("PABEGTIME") String PABEGTIME, @Param("PAENDTIME") String PAENDTIME, @Param("PADEPTNO") String PADEPTNO, @Param("PAUSERNO") Integer PAUSERNO, @Param("PACASESTATE") String PACASESTATE);
+    List<SpStatCase> getListBypower(@Param("PABEGTIME") String PABEGTIME, @Param("PAENDTIME") String PAENDTIME, @Param("PADEPTNO") String PADEPTNO, @Param("PAUSERNO") String PAUSERNO, @Param("PACASESTATE") String PACASESTATE);
 
 }
diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/mapper/SpstatExpenseMapper.java b/ruoyi-project/src/main/java/com/ruoyi/project/mapper/SpstatExpenseMapper.java
index ed8df5e..b714d3d 100644
--- a/ruoyi-project/src/main/java/com/ruoyi/project/mapper/SpstatExpenseMapper.java
+++ b/ruoyi-project/src/main/java/com/ruoyi/project/mapper/SpstatExpenseMapper.java
@@ -18,6 +18,6 @@
 @Mapper
 public interface SpstatExpenseMapper extends BaseMapper<SpStatExpense> {
 
-    List<SpStatExpense> getListBySpstatExpense(@Param("PABEGTIME") String PABEGTIME, @Param("PAENDTIME") String PAENDTIME, @Param("PADEPTNO") String PADEPTNO, @Param("PAUSERNO") Integer PAUSERNO, @Param("PAEXPENSETYPE") String PAEXPENSETYPE);
+    List<SpStatExpense> getListBySpstatExpense(@Param("PABEGTIME") String PABEGTIME, @Param("PAENDTIME") String PAENDTIME, @Param("PADEPTNO") String PADEPTNO, @Param("PAUSERNO") String PAUSERNO, @Param("PAEXPENSETYPE") String PAEXPENSETYPE);
 
 }
diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/service/impl/ServiceFunddetailServiceImpl.java b/ruoyi-project/src/main/java/com/ruoyi/project/service/impl/ServiceFunddetailServiceImpl.java
index 7222d08..559ef72 100644
--- a/ruoyi-project/src/main/java/com/ruoyi/project/service/impl/ServiceFunddetailServiceImpl.java
+++ b/ruoyi-project/src/main/java/com/ruoyi/project/service/impl/ServiceFunddetailServiceImpl.java
@@ -16,6 +16,7 @@
 import com.ruoyi.project.domain.*;
 import com.ruoyi.project.domain.vo.*;
 import com.ruoyi.project.mapper.ServiceFundMapper;
+import com.ruoyi.project.mapper.SpStatBonusMapper;
 import lombok.extern.flogger.Flogger;
 import lombok.extern.slf4j.Slf4j;
 import org.apache.commons.collections4.CollectionUtils;
@@ -46,6 +47,9 @@
 
     @Autowired
     ServiceFundMapper serviceFundMapper;
+
+    @Autowired
+    SpStatBonusMapper spStatBonusMapper;
 
 
     /**
@@ -476,6 +480,6 @@
 
     @Override
     public List<SpStatBonus> getListBySpStatBonus(SpStatBonusReq spStatBonusReq) {
-        return serviceFunddetailMapper.getListBySpStatBonus(spStatBonusReq.getPabegtime(), spStatBonusReq.getPaendtime(), spStatBonusReq.getPadeptno(), spStatBonusReq.getPauserno(), spStatBonusReq.getPabonustype());
+        return spStatBonusMapper.getListBySpStatBonus(spStatBonusReq.getPabegtime(), spStatBonusReq.getPaendtime(), spStatBonusReq.getPadeptno(), spStatBonusReq.getPauserno(), spStatBonusReq.getPabonustype());
     }
 }
diff --git a/ruoyi-project/src/main/resources/mapper/project/ServiceDonorchargeorganMapper.xml b/ruoyi-project/src/main/resources/mapper/project/ServiceDonorchargeorganMapper.xml
index d32efbc..984852b 100644
--- a/ruoyi-project/src/main/resources/mapper/project/ServiceDonorchargeorganMapper.xml
+++ b/ruoyi-project/src/main/resources/mapper/project/ServiceDonorchargeorganMapper.xml
@@ -150,7 +150,7 @@
 
     <select id="getListBySpStatChange" statementType="CALLABLE"
             resultType="com.ruoyi.project.domain.SpStatChange">
-        call `SP_STAT_CHANGE`(#{PAHOSPITALNO,mode=IN,jdbcType=VARCHAR},#{PACHAGEFLAG,mode=IN,jdbcType=VARCHAR}
+        call `SP_STAT_CHANGE`(#{PAHOSPITALNO,mode=IN,jdbcType=VARCHAR},#{PACHAGEFLAG,mode=IN,jdbcType=VARCHAR})
     </select>
 
 </mapper>
\ No newline at end of file
diff --git a/ruoyi-project/src/main/resources/mapper/project/ServiceFunddetailMapper.xml b/ruoyi-project/src/main/resources/mapper/project/ServiceFunddetailMapper.xml
index fb124b3..9f09a61 100644
--- a/ruoyi-project/src/main/resources/mapper/project/ServiceFunddetailMapper.xml
+++ b/ruoyi-project/src/main/resources/mapper/project/ServiceFunddetailMapper.xml
@@ -300,7 +300,7 @@
 
     <select id="getListBySpStatBonus" statementType="CALLABLE"
             resultType="com.ruoyi.project.domain.SpStatBonus">
-        call `SP_STAT_BONUS`(#{PABEGTIME,mode=IN,jdbcType=VARCHAR},#{PAENDTIME,mode=IN,jdbcType=VARCHAR},#{PADEPTNO,mode=IN,jdbcType=VARCHAR},#{PAUSERNO,mode=IN,jdbcType=INTEGER},#{PABONUSTYPE,mode=IN,jdbcType=VARCHAR})
+        call `SP_STAT_BONUS`(#{PABEGTIME,mode=IN,jdbcType=VARCHAR},#{PAENDTIME,mode=IN,jdbcType=VARCHAR},#{PADEPTNO,mode=IN,jdbcType=VARCHAR},#{PAUSERNO,mode=IN,jdbcType=VARCHAR},#{PABONUSTYPE,mode=IN,jdbcType=VARCHAR})
     </select>
 
 </mapper>
\ No newline at end of file
diff --git a/ruoyi-project/src/main/resources/mapper/project/SpStatBonusMapper.xml b/ruoyi-project/src/main/resources/mapper/project/SpStatBonusMapper.xml
new file mode 100644
index 0000000..5f292bb
--- /dev/null
+++ b/ruoyi-project/src/main/resources/mapper/project/SpStatBonusMapper.xml
@@ -0,0 +1,13 @@
+<?xml version="1.0" encoding="UTF-8" ?>
+<!DOCTYPE mapper
+        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
+        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
+<mapper namespace="com.ruoyi.project.mapper.SpStatBonusMapper">
+
+
+    <select id="getListBySpStatBonus" statementType="CALLABLE"
+            resultType="com.ruoyi.project.domain.SpStatBonus">
+        call `SP_STAT_BONUS`(#{PABEGTIME,mode=IN,jdbcType=VARCHAR},#{PAENDTIME,mode=IN,jdbcType=VARCHAR},#{PADEPTNO,mode=IN,jdbcType=VARCHAR},#{PAUSERNO,mode=IN,jdbcType=VARCHAR},#{PABONUSTYPE,mode=IN,jdbcType=INTEGER})
+    </select>
+
+</mapper>
\ No newline at end of file
diff --git a/ruoyi-project/src/main/resources/mapper/project/SpstatCaseMapper.xml b/ruoyi-project/src/main/resources/mapper/project/SpstatCaseMapper.xml
index 6f027b9..1717785 100644
--- a/ruoyi-project/src/main/resources/mapper/project/SpstatCaseMapper.xml
+++ b/ruoyi-project/src/main/resources/mapper/project/SpstatCaseMapper.xml
@@ -7,6 +7,7 @@
 
     <select id="getListBypower" statementType="CALLABLE"
             resultType="com.ruoyi.project.domain.SpStatCase">
-        call `SP_STAT_CASE`(#{PABEGTIME,mode=IN,jdbcType=VARCHAR},#{PAENDTIME,mode=IN,jdbcType=VARCHAR},#{PADEPTNO,mode=IN,jdbcType=VARCHAR},#{PAUSERNO,mode=IN,jdbcType=INTEGER},#{PACASESTATE,mode=IN,jdbcType=VARCHAR})
+        call `SP_STAT_CASE`(#{PABEGTIME,mode=IN,jdbcType=VARCHAR},#{PAENDTIME,mode=IN,jdbcType=VARCHAR},#{PADEPTNO,mode=IN,jdbcType=VARCHAR},#{PAUSERNO,mode=IN,jdbcType=VARCHAR
+        },#{PACASESTATE,mode=IN,jdbcType=VARCHAR})
     </select>
 </mapper>
\ No newline at end of file
diff --git a/ruoyi-project/src/main/resources/mapper/project/SpstatExpenseMapper.xml b/ruoyi-project/src/main/resources/mapper/project/SpstatExpenseMapper.xml
index c3d0b6c..afac424 100644
--- a/ruoyi-project/src/main/resources/mapper/project/SpstatExpenseMapper.xml
+++ b/ruoyi-project/src/main/resources/mapper/project/SpstatExpenseMapper.xml
@@ -7,6 +7,6 @@
 
     <select id="getListBySpstatExpense" statementType="CALLABLE"
             resultType="com.ruoyi.project.domain.SpStatExpense">
-        call `SP_STAT_EXPENSE`(#{PABEGTIME,mode=IN,jdbcType=VARCHAR},#{PAENDTIME,mode=IN,jdbcType=VARCHAR},#{PADEPTNO,mode=IN,jdbcType=VARCHAR},#{PAUSERNO,mode=IN,jdbcType=INTEGER},#{PAEXPENSETYPE,mode=IN,jdbcType=VARCHAR})
+        call `SP_STAT_EXPENSE`(#{PABEGTIME,mode=IN,jdbcType=VARCHAR},#{PAENDTIME,mode=IN,jdbcType=VARCHAR},#{PADEPTNO,mode=IN,jdbcType=VARCHAR},#{PAUSERNO,mode=IN,jdbcType=VARCHAR},#{PAEXPENSETYPE,mode=IN,jdbcType=VARCHAR})
     </select>
 </mapper>
\ No newline at end of file

--
Gitblit v1.9.3