From e5b661a2f8afde7423c5e9e6b0b0e295832776d0 Mon Sep 17 00:00:00 2001
From: sinake <sinake1@qq.com>
Date: 星期四, 21 五月 2026 11:28:35 +0800
Subject: [PATCH] 捐献完成表新增亲属关系 新开发短信接口

---
 ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceEthicalreviewopinionsController.java |  112 ++++++++++++++++++++++++++++++++++++++++++--------------
 1 files changed, 84 insertions(+), 28 deletions(-)

diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceEthicalreviewopinionsController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceEthicalreviewopinionsController.java
index 555d9fc..41c248d 100644
--- a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceEthicalreviewopinionsController.java
+++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceEthicalreviewopinionsController.java
@@ -31,12 +31,16 @@
 import io.swagger.annotations.ApiImplicitParams;
 import io.swagger.annotations.ApiOperation;
 import org.apache.commons.lang3.ObjectUtils;
+import org.apache.poi.ss.formula.functions.Now;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.web.bind.annotation.*;
 
 import java.io.*;
+import java.net.HttpURLConnection;
+import java.net.URL;
 import java.nio.charset.StandardCharsets;
 import java.nio.file.Files;
+import java.nio.file.Path;
 import java.nio.file.Paths;
 import java.util.*;
 
@@ -196,24 +200,80 @@
         if(list.size()==0){
             return Result.error("浼︾悊瀹℃煡id鏃犵浉鍏虫暟鎹�");
         }
+        EthicalreviewopinionsStateTotalVO  stateTotalVO=serviceEthicalreviewopinionsService.stateTotalAll(nitiateId);
         String filePath = getClass().getResource("/template/").getPath();
         if(filePath.substring(0,1).equals("/"))
             filePath=filePath.substring(1);
         String content ="";
         Template t = null;
         try {
-            content = Files.readString(Paths.get(filePath+"閬椾綋鍣ㄥ畼鑾峰彇浼︾悊瀹℃煡琛ㄩ椤�.xml"), StandardCharsets.UTF_8);
+//            content = Files.readString(Paths.get(filePath+"閬椾綋鍣ㄥ畼鑾峰彇浼︾悊瀹℃煡琛ㄩ椤�.xml"), StandardCharsets.UTF_8);
+            Path path = Paths.get(filePath + "閬椾綋鍣ㄥ畼鑾峰彇浼︾悊瀹℃煡琛ㄩ椤�.xml");
+            byte[] bytes = Files.readAllBytes(path);
+            content = new String(bytes, StandardCharsets.UTF_8);
             String name=list.get(0).getName()+"锛堜綇闄㈠彿锛�"+list.get(0).getInpatientno()+"锛�";
             content=content.replace("$name",name);//椤圭洰鍚嶇О
-            content=content.replace("$inCount","16");//鍒颁細濮斿憳
+
+            content=content.replace("$inCount",stateTotalVO.getInCount());//鍒颁細濮斿憳
             content=content.replace("$avoidCount","0");//鍥為伩濮斿憳
-            content=content.replace("$agreeCount","15");//鍚屾剰
-            content=content.replace("$updateAgreeCount","2");//淇敼鍚庡悓鎰�
-            content=content.replace("$disagreeCount","3");//涓嶅悓鎰�
-            content=content.replace("$abstentionCount","4");//寮冩潈
+            content=content.replace("$agreeCount",stateTotalVO.getAgreeCount());//鍚屾剰
+            content=content.replace("$updateAgreeCount",stateTotalVO.getRejectCount());//淇敼鍚庡悓鎰�
+            content=content.replace("$disagreeCount",stateTotalVO.getDisagreeCount());//涓嶅悓鎰�
+            content=content.replace("$abstentionCount",stateTotalVO.getWaiveCount());//寮冩潈
             String committeeOpinion="";
             for (EthicalReviewVO row:list) {
                 String State="",sgin="",id=row.getId()+"",expName=row.getExpertname();
+                if(ObjectUtils.isNotEmpty(row.getSigin())){
+//                    byte[] imageBytes = Files.readAllBytes(Paths.get(row.getSigin()));
+//                    sgin=Base64.getEncoder().encodeToString(imageBytes);
+                    HttpURLConnection connection = null;
+                    InputStream inputStream = null;
+                    ByteArrayOutputStream outputStream = null;
+                    try {
+                        URL url = new URL(row.getSigin());
+                        connection = (HttpURLConnection) url.openConnection();
+                        connection.setRequestMethod("GET");
+                        connection.setConnectTimeout(5000);
+                        connection.setReadTimeout(5000);
+
+                        if (connection.getResponseCode() != HttpURLConnection.HTTP_OK) {
+                            sgin="";
+                        }
+
+                        inputStream = connection.getInputStream();
+                        outputStream = new ByteArrayOutputStream();
+
+                        byte[] buffer = new byte[1024];
+                        int bytesRead;
+                        while ((bytesRead = inputStream.read(buffer)) != -1) {
+                            outputStream.write(buffer, 0, bytesRead);
+                        }
+
+                        byte[] imageBytes = outputStream.toByteArray();
+                        sgin= Base64.getEncoder().encodeToString(imageBytes);
+                    }catch (Exception e){
+                        sgin="";
+                    }finally {
+                        if (inputStream != null) {
+                            try {
+                                inputStream.close();
+                            } catch (IOException e) {
+
+                            }
+                        }
+                        if (outputStream != null) {
+                            try {
+                                outputStream.close();
+                            } catch (IOException e) {
+
+                            }
+                        }
+                        if (connection != null) {
+                            connection.disconnect();
+                        }
+                    }
+
+                }
                 if(expName.length()==2) expName=expName.substring(0,1)+"  "+expName.substring(1);
                 if(row.getReceiveStatus().equals("1"))State="宸插悓鎰�";
                 else if(row.getReceiveStatus().equals("2")) State="涓嶅悓鎰�";
@@ -227,40 +287,29 @@
                         "            <w:tc><w:tcPr></w:tcPr>\n" +
                         "                <w:p wsp:rsidR=\"00425E28\" wsp:rsidRPr=\"00CB3FB5\" wsp:rsidRDefault=\"00AC7CCA\" wsp:rsidP=\"00CB3FB5\">\n" +
                         "                    <w:r wsp:rsidRPr=\"00737357\">\n" +
-                        "                        <w:t>銆愬鍛樺鎵广��"+expName+"  "+State+" </w:t></w:r>\n" +
+                        "                        <w:spacing w:line=\"480\" w:line-rule=\"auto\"/><w:t>銆愬鍛樺鎵广��"+expName+"  "+State+" </w:t></w:r>\n" +
                         "                   </w:p>\n" +
                         "            </w:tc>\n" +
                         "            <w:tc><w:tcPr></w:tcPr>\n" +
                         "                <w:p wsp:rsidR=\"00425E28\" wsp:rsidRPr=\"00CB3FB5\" wsp:rsidRDefault=\"00AC7CCA\" wsp:rsidP=\"00CB3FB5\">\n" +
                         "                    <w:r wsp:rsidRPr=\"00737357\">\n" +
                         "                        <w:t>绛惧悕锛�</w:t></w:r>\n" +
-                        "                    <w:r wsp:rsidR=\"00421BE1\">\n" +
-                        "                        <w:pict>\n" +
-                        "                        <w:binData w:name=\"wordml://03000001.png\" xml:space=\"preserve\"> </w:binData>\n" +
-                        "                            <v:shape style=\"width:50pt;height:20pt\"><v:imagedata src=\"wordml://03000001.png\" o:title=\"my绛惧瓧\"/></v:shape>\n" +
-                        "                        </w:pict>\n" +
-                        "                    </w:r>\n" +
+                        "                    <w:r wsp:rsidR=\"00421BE1\">\n" ;
+                        if(sgin.length()>10) {
+                            committeeOpinion +="<w:pict><w:binData w:name=\"wordml://03000001.png\" xml:space=\"preserve\">\n" + sgin + "\n" +
+                                    "</w:binData><v:shape  style=\"width:50pt;height:20pt\"><v:imagedata src=\"wordml://03000001.png\" o:title=\"\"/></v:shape></w:pict>\n" ;
+                        }
+                committeeOpinion += "                    </w:r>\n" +
                         "                </w:p>\n" +
                         "            </w:tc>\n" +
                         "            <w:tc><w:tcPr></w:tcPr>\n" +
                         "                <w:p wsp:rsidR=\"00425E28\" wsp:rsidRPr=\"00CB3FB5\" wsp:rsidRDefault=\"00AC7CCA\" wsp:rsidP=\"00CB3FB5\">\n" +
-                        "                    <w:r wsp:rsidRPr=\"00737357\"><w:t>2026-05-18 15:36:01</w:t></w:r></w:p>\n" +
+                        "                    <w:spacing w:line=\"480\" w:line-rule=\"auto\"/><w:r wsp:rsidRPr=\"00737357\"><w:t>"+DateUtils.parseDateToStr("yyyy-MM-dd HH:mm:ss",row.getConclusiontime())+"</w:t></w:r></w:p>\n" +
                         "            </w:tc>\n" +
                         "        </w:tr>";
-                 committeeOpinion += "      <w:p wsp:rsidR=\"00EE26D5\" wsp:rsidRPr=\"00737357\" wsp:rsidRDefault=\"0030540D\" wsp:rsidP=\"00EE26D5\"><w:pPr><w:rPr><w:rFonts w:ascii=\"瀹嬩綋\" w:h-ansi=\"瀹嬩綋\" w:cs=\"瀹嬩綋\"/><wx:font\n" +
-                        "                        wx:val=\"瀹嬩綋\"/><w:sz-cs w:val=\"21\"/></w:rPr></w:pPr>\n" +
-                        "                    <w:r wsp:rsidR=\"00EE26D5\" wsp:rsidRPr=\"00737357\" >\n" +
-                        "                       <v:shape style=\"width:500pt;\"> <w:t>銆愬鍛樺鎵广��"+expName+"  "+State+" </w:t></v:shape></w:r>\n" +
-                         "                    <w:r wsp:rsidR=\"00EE26D5\" wsp:rsidRPr=\"00737357\">\n" +
-                         "                        <w:t>   绛惧悕锛�</w:t></w:r>\n" +
-                        "                    <w:r wsp:rsidR=\"00EE26D5\" wsp:rsidRPr=\"00737357\">\n" +
-                        "                        <w:pict>\n" +
-                        "                            <w:binData w:name=\"wordml://img"+id+".png\" xml:space=\"preserve\">"+sgin+" </w:binData>\n" +
-                        "                            <v:shape id=\"_x0000_"+id+"\" type=\"#_x0000_t75\" style=\"width:50pt;height:20pt\"><v:imagedata src=\"wordml://_x0000_"+id+".png\" o:title=\"绛惧瓧\"/></v:shape></w:pict></w:r>\n" +
-                        "                    <w:r wsp:rsidR=\"00737357\" wsp:rsidRPr=\"00737357\">\n" +
-                        "                        <w:t>    "+ DateUtils.parseDateToStr("yyyy-MM-dd HH:mm:ss",row.getConclusiontime())+"</w:t></w:r></w:p>";
-            }
+               }
             content=content.replace("$committeeOpinion",committeeOpinion);//濮斿憳浼氭剰瑙�
+            content=content.replace("$dateContent",DateUtils.parseDateToStr("yyyy骞碝M鏈坉d鏃�",new Date()));//鏃ユ湡
 
         } catch (Exception e) {
             e.printStackTrace();
@@ -274,12 +323,19 @@
         if (!folderPath.exists()) {
             folderPath.mkdirs();
         }
-
+/*
         try {
             Files.writeString(Paths.get(filePathData+ "/" + name + ".doc"),content);
         } catch (Exception e1) {
             e1.printStackTrace();
         }
+*/
+        try {
+            Path path = Paths.get(filePathData + "/" + name + ".doc");
+            Files.write(path, content.getBytes(StandardCharsets.UTF_8));
+        } catch (Exception e1) {
+            e1.printStackTrace();
+        }
 
         Map<String, Object> map = new HashMap<>();
         map.put("downloadUrl", "/download/wordtemplate/" + name + ".doc");

--
Gitblit v1.9.3