From a1f2eefe4641764955c846ad58ebdbcedd96699d Mon Sep 17 00:00:00 2001
From: yxh <172933527@qq.com>
Date: 星期三, 28 十月 2026 17:31:58 +0800
Subject: [PATCH] 修改了统计
---
ruoyi-project/src/main/java/com/ruoyi/project/domain/SpStatCaseDept.java | 39 ++++
ruoyi-project/src/main/java/com/ruoyi/project/domain/SpStatBonusDept.java | 55 ++++++
ruoyi-project/src/main/java/com/ruoyi/project/domain/SpStatExpenseDept.java | 69 ++++++++
ruoyi-project/src/main/resources/mapper/project/ServiceExternalpersonMapper.xml | 2
ruoyi-project/src/main/java/com/ruoyi/project/domain/ServiceExternalperson.java | 7
ruoyi-project/src/main/java/com/ruoyi/project/domain/CasePanorama.java | 222 +++++++++++++++++++++++++++
ruoyi-project/src/main/java/com/ruoyi/project/domain/CasePanoramaReq.java | 48 ++++++
7 files changed, 442 insertions(+), 0 deletions(-)
diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/domain/CasePanorama.java b/ruoyi-project/src/main/java/com/ruoyi/project/domain/CasePanorama.java
new file mode 100644
index 0000000..baa6345
--- /dev/null
+++ b/ruoyi-project/src/main/java/com/ruoyi/project/domain/CasePanorama.java
@@ -0,0 +1,222 @@
+package com.ruoyi.project.domain;
+
+import com.ruoyi.common.annotation.Excel;
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+
+import java.math.BigDecimal;
+
+/**
+ * 妗堜緥鍏ㄦ櫙锛坴_donationfeestat锛�
+ *
+ * @author ruoyi
+ * @date 2026-10-28
+ */
+@Data
+@ApiModel("妗堜緥鍏ㄦ櫙")
+public class CasePanorama {
+ private static final long serialVersionUID = 1L;
+
+ /**
+ * 妗堜緥ID
+ */
+ @ApiModelProperty("妗堜緥ID")
+ private Long id;
+
+ /**
+ * 鎹愮尞鑰呭鍚�
+ */
+ @ApiModelProperty("鎹愮尞鑰呭鍚�")
+ @Excel(name = "鎹愮尞鑰呭鍚�", sort = 1, width = 12)
+ private String donorName;
+
+ /**
+ * 鎹愮尞鏃ユ湡
+ */
+ @ApiModelProperty("鎹愮尞鏃ユ湡")
+ @Excel(name = "鎹愮尞鏃ユ湡", sort = 2, width = 12)
+ private String donateTime;
+
+ /**
+ * 涓婃姤鏃ユ湡
+ */
+ @ApiModelProperty("涓婃姤鏃ユ湡")
+ @Excel(name = "涓婃姤鏃ユ湡", sort = 3, width = 12)
+ private String reportTime;
+
+ /**
+ * 涓氬姟缁�
+ */
+ @ApiModelProperty("涓氬姟缁�")
+ @Excel(name = "涓氬姟缁�", sort = 4, width = 16)
+ private String deptName;
+
+ /**
+ * 涓氬姟浜哄憳
+ */
+ @ApiModelProperty("涓氬姟浜哄憳")
+ @Excel(name = "涓氬姟浜哄憳", sort = 5, width = 12)
+ private String reporterName;
+
+ /**
+ * 鏄惁缁堟
+ */
+ @ApiModelProperty("鏄惁缁堟")
+ @Excel(name = "妗堜緥缁堟", sort = 6, width = 10)
+ private String terminationFlag;
+
+ /**
+ * 鎹愮尞涓氬姟鑺傜偣锛堝師濮嬪�硷紝椤甸潰鐢ㄥ瓧鍏告樉绀猴級
+ */
+ @ApiModelProperty("鎹愮尞涓氬姟鑺傜偣")
+ private String workflow;
+
+ /**
+ * 鎹愮尞涓氬姟鑺傜偣鍚嶇О锛堝鍑虹敤锛�
+ */
+ @ApiModelProperty("鎹愮尞涓氬姟鑺傜偣鍚嶇О")
+ @Excel(name = "褰撳墠鐘舵��", sort = 7, width = 14)
+ private String workflowName;
+
+ /**
+ * 鎹愮尞鍖婚櫌
+ */
+ @ApiModelProperty("鎹愮尞鍖婚櫌")
+ @Excel(name = "鎹愮尞鍖婚櫌", sort = 8, width = 30)
+ private String donationHospital;
+
+ /**
+ * 鎹愮尞鍣ㄥ畼
+ */
+ @ApiModelProperty("鎹愮尞鍣ㄥ畼")
+ @Excel(name = "鎹愮尞鍣ㄥ畼", sort = 9, width = 25)
+ private String organName;
+
+ /**
+ * 鍣ㄥ畼鑾峰彇
+ */
+ @ApiModelProperty("鍣ㄥ畼鑾峰彇")
+ @Excel(name = "鑾峰彇鍣ㄥ畼", sort = 10, width = 40)
+ private String organProcurement;
+
+ /**
+ * 鍣ㄥ畼绉绘
+ */
+ @ApiModelProperty("鍣ㄥ畼绉绘")
+ @Excel(name = "绉绘鍣ㄥ畼", sort = 11, width = 40)
+ private String organTransplantation;
+
+ /**
+ * 鎴愭湰鍚堣
+ */
+ @ApiModelProperty("鎴愭湰鍚堣")
+ @Excel(name = "鎴愭湰鍚堣", sort = 12, width = 14, cellType = Excel.ColumnType.NUMERIC, scale = 2)
+ private BigDecimal totalCost;
+
+ /**
+ * 瀹跺睘璐圭敤
+ */
+ @ApiModelProperty("瀹跺睘璐圭敤")
+ @Excel(name = "瀹跺睘璐圭敤", sort = 13, width = 14, cellType = Excel.ColumnType.NUMERIC, scale = 2)
+ private BigDecimal donorFamilyCost;
+
+ /**
+ * 鍖诲鎴愭湰鍚堣
+ */
+ @ApiModelProperty("鍖诲鎴愭湰鍚堣")
+ @Excel(name = "鍖诲鎴愭湰灏忚", sort = 14, width = 14, cellType = Excel.ColumnType.NUMERIC, scale = 2)
+ private BigDecimal medCost;
+
+ /**
+ * 涓撳鎴愭湰鍚堣
+ */
+ @ApiModelProperty("涓撳鎴愭湰鍚堣")
+ @Excel(name = "涓撳鎴愭湰灏忚", sort = 15, width = 14, cellType = Excel.ColumnType.NUMERIC, scale = 2)
+ private BigDecimal expertCost;
+
+ /**
+ * 鍏朵粬鎴愭湰灏忚锛圛temCode 3/4/24/26/28/29/30/31/52/67锛�
+ */
+ @ApiModelProperty("鍏朵粬鎴愭湰灏忚")
+ @Excel(name = "鍏朵粬鎴愭湰灏忚", sort = 16, width = 14, cellType = Excel.ColumnType.NUMERIC, scale = 2)
+ private BigDecimal itemCode34;
+
+ /**
+ * 鎵嬫湳瀹や娇鐢ㄨ垂
+ */
+ @ApiModelProperty("鎵嬫湳瀹や娇鐢ㄨ垂")
+ @Excel(name = "鎵嬫湳瀹や娇鐢ㄨ垂", sort = 17, width = 14, cellType = Excel.ColumnType.NUMERIC, scale = 2)
+ private BigDecimal itemCode42;
+
+ /**
+ * 鍣ㄥ畼淇濆瓨銆佺亴娉ㄥ強鐩稿簲娑蹭綋
+ */
+ @ApiModelProperty("鍣ㄥ畼淇濆瓨銆佺亴娉ㄥ強鐩稿簲娑蹭綋")
+ @Excel(name = "鍣ㄥ畼淇濆瓨鐏屾敞", sort = 18, width = 14, cellType = Excel.ColumnType.NUMERIC, scale = 2)
+ private BigDecimal itemCode46;
+
+ /**
+ * 鐢ㄤ簬淇濆瓨鍣ㄥ畼鐨勮澶�
+ */
+ @ApiModelProperty("鐢ㄤ簬淇濆瓨鍣ㄥ畼鐨勮澶�")
+ @Excel(name = "鍣ㄥ畼淇濆瓨璁惧", sort = 19, width = 14, cellType = Excel.ColumnType.NUMERIC, scale = 2)
+ private BigDecimal itemCode50;
+
+ /**
+ * 鑲濊剰涓夌淮閲嶅缓
+ */
+ @ApiModelProperty("鑲濊剰涓夌淮閲嶅缓")
+ @Excel(name = "鑲濊剰涓夌淮閲嶅缓", sort = 20, width = 14, cellType = Excel.ColumnType.NUMERIC, scale = 2)
+ private BigDecimal itemCode44;
+
+ /**
+ * 鐥呯悊绌垮埡娲绘
+ */
+ @ApiModelProperty("鐥呯悊绌垮埡娲绘")
+ @Excel(name = "鐥呯悊绌垮埡娲绘", sort = 21, width = 14, cellType = Excel.ColumnType.NUMERIC, scale = 2)
+ private BigDecimal itemCode47;
+
+ /**
+ * HLA閰嶅瀷
+ */
+ @ApiModelProperty("HLA閰嶅瀷")
+ @Excel(name = "HLA閰嶅瀷", sort = 22, width = 12, cellType = Excel.ColumnType.NUMERIC, scale = 2)
+ private BigDecimal itemCode48;
+
+ /**
+ * 鐣欏瓨鏍囨湰鎴愭湰
+ */
+ @ApiModelProperty("鐣欏瓨鏍囨湰鎴愭湰")
+ @Excel(name = "鐣欏瓨鏍囨湰鎴愭湰", sort = 23, width = 14, cellType = Excel.ColumnType.NUMERIC, scale = 2)
+ private BigDecimal itemCode21;
+
+ /**
+ * 鏍囨湰杩愯緭璐�
+ */
+ @ApiModelProperty("鏍囨湰杩愯緭璐�")
+ @Excel(name = "鏍囨湰杩愯緭璐�", sort = 24, width = 12, cellType = Excel.ColumnType.NUMERIC, scale = 2)
+ private BigDecimal itemCode12;
+
+ /**
+ * 杞繍杞﹁垂
+ */
+ @ApiModelProperty("杞繍杞﹁垂")
+ @Excel(name = "杞繍杞﹁垂", sort = 25, width = 12, cellType = Excel.ColumnType.NUMERIC, scale = 2)
+ private BigDecimal itemCode17;
+
+ /**
+ * 閬椾綋杩愯緭
+ */
+ @ApiModelProperty("閬椾綋杩愯緭")
+ @Excel(name = "閬椾綋杩愯緭", sort = 26, width = 12, cellType = Excel.ColumnType.NUMERIC, scale = 2)
+ private BigDecimal itemCode23;
+
+ /**
+ * 灏告
+ */
+ @ApiModelProperty("灏告")
+ @Excel(name = "灏告", sort = 27, width = 10, cellType = Excel.ColumnType.NUMERIC, scale = 2)
+ private BigDecimal itemCode25;
+
+}
diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/domain/CasePanoramaReq.java b/ruoyi-project/src/main/java/com/ruoyi/project/domain/CasePanoramaReq.java
new file mode 100644
index 0000000..3d7f7d3
--- /dev/null
+++ b/ruoyi-project/src/main/java/com/ruoyi/project/domain/CasePanoramaReq.java
@@ -0,0 +1,48 @@
+package com.ruoyi.project.domain;
+
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+
+/**
+ * 妗堜緥鍏ㄦ櫙鏌ヨ鏉′欢
+ *
+ * @author ruoyi
+ * @date 2026-10-28
+ */
+@Data
+@ApiModel("妗堜緥鍏ㄦ櫙鏌ヨ鏉′欢")
+public class CasePanoramaReq {
+ private static final long serialVersionUID = 1L;
+
+ /**
+ * 鎹愮尞鑰呭鍚�
+ */
+ @ApiModelProperty("鎹愮尞鑰呭鍚�")
+ private String donorName;
+
+ /**
+ * 鎹愮尞鏃ユ湡寮�濮嬶紙yyyy-MM-dd锛�
+ */
+ @ApiModelProperty("鎹愮尞鏃ユ湡寮�濮�")
+ private String donateTimeBegin;
+
+ /**
+ * 鎹愮尞鏃ユ湡缁撴潫锛坹yyy-MM-dd锛�
+ */
+ @ApiModelProperty("鎹愮尞鏃ユ湡缁撴潫")
+ private String donateTimeEnd;
+
+ /**
+ * 涓氬姟缁�
+ */
+ @ApiModelProperty("涓氬姟缁�")
+ private String deptName;
+
+ /**
+ * 涓氬姟浜哄憳
+ */
+ @ApiModelProperty("涓氬姟浜哄憳")
+ private String reporterName;
+
+}
diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/domain/ServiceExternalperson.java b/ruoyi-project/src/main/java/com/ruoyi/project/domain/ServiceExternalperson.java
index 9555e08..65df631 100644
--- a/ruoyi-project/src/main/java/com/ruoyi/project/domain/ServiceExternalperson.java
+++ b/ruoyi-project/src/main/java/com/ruoyi/project/domain/ServiceExternalperson.java
@@ -103,7 +103,14 @@
@ApiModelProperty("鍏徃绋庡彿")
private String unitTaxNo;
+ /** 缁╂晥绉戝ID */
+ @ApiModelProperty("缁╂晥绉戝ID")
+ private Long deptId;
+ /** 缁╂晥绉戝鍚嶇О */
+ @ApiModelProperty("缁╂晥绉戝")
+ @Excel(name = "缁╂晥绉戝")
+ private String deptName;
}
diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/domain/SpStatBonusDept.java b/ruoyi-project/src/main/java/com/ruoyi/project/domain/SpStatBonusDept.java
new file mode 100644
index 0000000..e30e203
--- /dev/null
+++ b/ruoyi-project/src/main/java/com/ruoyi/project/domain/SpStatBonusDept.java
@@ -0,0 +1,55 @@
+package com.ruoyi.project.domain;
+
+import com.ruoyi.common.annotation.Excel;
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+
+import java.math.BigDecimal;
+
+/**
+ * 缁╂晥缁熻锛堟寜涓氬姟缁勶級
+ *
+ * @author ruoyi
+ * @date 2026-10-28
+ */
+@Data
+@ApiModel("缁╂晥缁熻锛堟寜涓氬姟缁勶級")
+public class SpStatBonusDept {
+ private static final long serialVersionUID = 1L;
+
+ /**
+ * 涓氬姟缁�
+ */
+ @ApiModelProperty("涓氬姟缁�")
+ @Excel(name = "涓氬姟缁�", sort = 1)
+ private String deptname;
+
+ /**
+ * 缁╂晥閲戦
+ */
+ @ApiModelProperty("缁╂晥閲戦")
+ @Excel(name = "缁╂晥閲戦", sort = 2, scale = 2)
+ private BigDecimal amount;
+
+ /**
+ * 鏈堝害缁╂晥閲戦
+ */
+ @ApiModelProperty("鏈堝害缁╂晥閲戦")
+ @Excel(name = "鏈堝害缁╂晥", sort = 3, scale = 2)
+ private BigDecimal mamount;
+
+ /**
+ * 瀛ｅ害缁╂晥閲戦
+ */
+ @ApiModelProperty("瀛ｅ害缁╂晥閲戦")
+ @Excel(name = "瀛ｅ害缁╂晥", sort = 4, scale = 2)
+ private BigDecimal samount;
+
+ /**
+ * 骞村害缁╂晥閲戦
+ */
+ @ApiModelProperty("骞村害缁╂晥閲戦")
+ @Excel(name = "骞村害缁╂晥", sort = 5, scale = 2)
+ private BigDecimal yamount;
+}
diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/domain/SpStatCaseDept.java b/ruoyi-project/src/main/java/com/ruoyi/project/domain/SpStatCaseDept.java
new file mode 100644
index 0000000..38c431a
--- /dev/null
+++ b/ruoyi-project/src/main/java/com/ruoyi/project/domain/SpStatCaseDept.java
@@ -0,0 +1,39 @@
+package com.ruoyi.project.domain;
+
+import com.ruoyi.common.annotation.Excel;
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+
+/**
+ * 妗堜緥缁熻锛堟寜涓氬姟缁勶級
+ *
+ * @author ruoyi
+ * @date 2026-10-27
+ */
+@Data
+@ApiModel("妗堜緥缁熻锛堟寜涓氬姟缁勶級")
+public class SpStatCaseDept {
+ private static final long serialVersionUID = 1L;
+
+ /**
+ * 涓氬姟缁�
+ */
+ @ApiModelProperty("涓氬姟缁�")
+ @Excel(name = "涓氬姟缁�", sort = 1)
+ private String deptname;
+
+ /**
+ * 绱妗堜緥锛埼� workflowsum锛�
+ */
+ @ApiModelProperty("绱妗堜緥")
+ @Excel(name = "绱妗堜緥", sort = 2, cellType = Excel.ColumnType.NUMERIC)
+ private Integer caseTotal;
+
+ /**
+ * 缁堟妗堜緥锛埼� terminationcase锛�
+ */
+ @ApiModelProperty("缁堟妗堜緥")
+ @Excel(name = "缁堟妗堜緥", sort = 3, cellType = Excel.ColumnType.NUMERIC)
+ private Integer terminationTotal;
+}
diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/domain/SpStatExpenseDept.java b/ruoyi-project/src/main/java/com/ruoyi/project/domain/SpStatExpenseDept.java
new file mode 100644
index 0000000..52dfa77
--- /dev/null
+++ b/ruoyi-project/src/main/java/com/ruoyi/project/domain/SpStatExpenseDept.java
@@ -0,0 +1,69 @@
+package com.ruoyi.project.domain;
+
+import com.ruoyi.common.annotation.Excel;
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+
+import java.math.BigDecimal;
+
+/**
+ * 璐圭敤缁熻锛堟寜涓氬姟缁勶級
+ *
+ * @author ruoyi
+ * @date 2026-10-28
+ */
+@Data
+@ApiModel("璐圭敤缁熻锛堟寜涓氬姟缁勶級")
+public class SpStatExpenseDept {
+ private static final long serialVersionUID = 1L;
+
+ /**
+ * 涓氬姟缁�
+ */
+ @ApiModelProperty("涓氬姟缁�")
+ @Excel(name = "涓氬姟缁�", sort = 1)
+ private String deptname;
+
+ /**
+ * 鎶ラ攢鎬婚噾棰�
+ */
+ @ApiModelProperty("鎶ラ攢鎬婚噾棰�")
+ @Excel(name = "鎶ラ攢鎬婚噾棰�", sort = 2, scale = 2)
+ private BigDecimal amount;
+
+ /**
+ * 涓撳璐�
+ */
+ @ApiModelProperty("涓撳璐�")
+ @Excel(name = "涓撳璐�", sort = 3, scale = 2)
+ private BigDecimal expertfee;
+
+ /**
+ * 浼︾悊涓撳璐�
+ */
+ @ApiModelProperty("浼︾悊涓撳璐�")
+ @Excel(name = "浼︾悊涓撳璐�", sort = 4, scale = 2)
+ private BigDecimal ethicalistfee;
+
+ /**
+ * 鍖诲鎴愭湰
+ */
+ @ApiModelProperty("鍖诲鎴愭湰")
+ @Excel(name = "鍖诲鎴愭湰", sort = 5, scale = 2)
+ private BigDecimal medicalcost;
+
+ /**
+ * 鍔炲叕璐�
+ */
+ @ApiModelProperty("鍔炲叕璐�")
+ @Excel(name = "鍔炲叕璐�", sort = 6, scale = 2)
+ private BigDecimal officecost;
+
+ /**
+ * 宸梾璐�
+ */
+ @ApiModelProperty("宸梾璐�")
+ @Excel(name = "宸梾璐�", sort = 7, scale = 2)
+ private BigDecimal reimcost;
+}
diff --git a/ruoyi-project/src/main/resources/mapper/project/ServiceExternalpersonMapper.xml b/ruoyi-project/src/main/resources/mapper/project/ServiceExternalpersonMapper.xml
index 93c1a1e..727bce0 100644
--- a/ruoyi-project/src/main/resources/mapper/project/ServiceExternalpersonMapper.xml
+++ b/ruoyi-project/src/main/resources/mapper/project/ServiceExternalpersonMapper.xml
@@ -29,6 +29,8 @@
<result property="pym" column="PYM"/>
<result property="wbm" column="WBM"/>
<result property="unitTaxNo" column="unit_tax_no"/>
+ <result property="deptId" column="dept_id"/>
+ <result property="deptName" column="dept_name"/>
</resultMap>
<sql id="selectServiceExternalpersonVo">
--
Gitblit v1.9.3