From 9978298937fb8a34faf8af9af6c893fcb5ddeb27 Mon Sep 17 00:00:00 2001
From: liusheng <337615773@qq.com>
Date: 星期三, 26 十一月 2025 16:07:26 +0800
Subject: [PATCH] 查询预约时间SQL修改
---
jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/controller/admin/freemark/TemplateCreateController.java | 128 +++++++++++++++++++++++++++++-------------
1 files changed, 87 insertions(+), 41 deletions(-)
diff --git a/jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/controller/admin/freemark/TemplateCreateController.java b/jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/controller/admin/freemark/TemplateCreateController.java
index 60f50c0..c899595 100644
--- a/jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/controller/admin/freemark/TemplateCreateController.java
+++ b/jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/controller/admin/freemark/TemplateCreateController.java
@@ -2,6 +2,7 @@
import cn.lihu.jh.module.ecg.dal.dataobject.appointment.AppointmentDO;
import cn.lihu.jh.module.ecg.service.appointment.AppointmentService;
+import cn.lihu.jh.module.infra.service.config.ConfigService;
import freemarker.template.Configuration;
import freemarker.template.Template;
import io.swagger.v3.oas.annotations.Operation;
@@ -14,12 +15,12 @@
import org.springframework.web.bind.annotation.RestController;
import javax.annotation.Resource;
-import javax.servlet.http.HttpServletResponse;
-import java.io.*;
-import java.net.URLEncoder;
+import java.io.BufferedWriter;
+import java.io.File;
+import java.io.StringWriter;
+import java.io.Writer;
import java.time.LocalDate;
import java.time.Period;
-import java.util.Calendar;
import java.util.HashMap;
import java.util.Map;
@@ -32,6 +33,8 @@
@Resource
private AppointmentService appointmentService;
+ @Resource
+ private ConfigService configService;
private static Configuration configuration = null;
@@ -40,9 +43,10 @@
configuration.setDefaultEncoding("utf-8");
}
+
@Operation(summary = "鐭ユ儏鍚屾剰杩愬姩璇曢獙")
@GetMapping(value = "/download/{id}")
- public void downloadInfo(@PathVariable("id") Long id, HttpServletResponse response) {
+ public Map<String, Object> downloadInfo(@PathVariable("id") Long id) {
log.info("鐭ユ儏鍚屾剰杩愬姩璇曢獙锛歿}", id);
try {
@@ -52,36 +56,48 @@
String filePath = getClass().getResource("/template/").getPath();
configuration.setDirectoryForTemplateLoading(new File(filePath));
+
+ // 纭繚妯℃澘鏄疻ord XML鏍煎紡
Template t = configuration.getTemplate("鐭ユ儏鍚屾剰杩愬姩璇曢獙.ftl");
- String timestamp = String.valueOf(System.currentTimeMillis());
- String fileName = "鐭ユ儏鍚屾剰杩愬姩璇曢獙-" + appointment.getPatName() + "-" + timestamp + ".doc";
+ String time = String.valueOf(System.currentTimeMillis());
+ String fileName = "骞虫澘杩愬姩蹇冪數鍥剧煡鎯呭悓鎰忎功-" + appointment.getPatName() + "-" + time + ".doc";
- // 璁剧疆鍝嶅簲澶达紝鍛婅瘔娴忚鍣ㄨ繘琛屼笅杞�
- response.setCharacterEncoding("UTF-8");
- response.setContentType("application/msword"); // Word鏂囨。绫诲瀷
- response.setHeader("Content-Disposition", "attachment; filename=" + URLEncoder.encode(fileName, "UTF-8"));
+ // 灏嗘ā鏉挎覆鏌撶粨鏋滃啓鍏tringWriter
+ StringWriter stringWriter = new StringWriter();
+ try (Writer out = new BufferedWriter(stringWriter)) {
+ t.process(dataMap, out);
+ }
- // 鐩存帴杈撳嚭鍒皉esponse鐨勮緭鍑烘祦
- Writer out = new BufferedWriter(new OutputStreamWriter(response.getOutputStream(), "UTF-8"));
- t.process(dataMap, out);
- out.flush();
- out.close();
+ String xmlContent = stringWriter.toString();
+
+ // 杩斿洖缁撴灉
+ Map<String, Object> result = new HashMap<>();
+ Map<String, Object> result1 = new HashMap<>();
+ result.put("success", true);
+ result.put("fileName", fileName);
+ result.put("fileContent", xmlContent);
+ result.put("fileType", "application/msword");
+ result1.put("code", 200);
+ result1.put("data", result);
+ result1.put("msg", "success");
+
+ log.info("Word XML鍐呭鐢熸垚鎴愬姛");
+ return result1;
} catch (Exception e) {
- log.error("涓嬭浇鐭ユ儏鍚屾剰杩愬姩璇曢獙鏂囨。澶辫触", e);
- try {
- response.sendError(HttpServletResponse.SC_INTERNAL_SERVER_ERROR, "鏂囨。鐢熸垚澶辫触");
- } catch (IOException ex) {
- log.error("鍙戦�侀敊璇搷搴斿け璐�", ex);
- }
+ log.error("鐢熸垚骞虫澘杩愬姩蹇冪數鍥剧煡鎯呭悓鎰忎功澶辫触", e);
+ Map<String, Object> result = new HashMap<>();
+ result.put("code", 500);
+ result.put("data", null);
+ result.put("msg", "鏂囨。鐢熸垚澶辫触: " + e.getMessage());
+ return result;
}
}
-
@Operation(summary = "椋熺蹇冭剰鐢电敓鐞嗙煡鎯呭悓鎰忎功")
@GetMapping(value = "/downloadesophagus/{id}")
- public void downloadEsophagusInfo(@PathVariable("id") Long id, HttpServletResponse response) {
+ public Map<String, Object> downloadEsophagusInfo(@PathVariable("id") Long id) {
log.info("椋熺蹇冭剰鐢电敓鐞嗙煡鎯呭悓鎰忎功锛歿}", id);
try {
@@ -91,29 +107,43 @@
String filePath = getClass().getResource("/template/").getPath();
configuration.setDirectoryForTemplateLoading(new File(filePath));
+
+ // 纭繚妯℃澘鏄疻ord XML鏍煎紡
Template t = configuration.getTemplate("椋熺蹇冭剰鐢电敓鐞嗙煡鎯呭悓鎰忎功.ftl");
- String timestamp = String.valueOf(System.currentTimeMillis());
- String fileName = "椋熺蹇冭剰鐢电敓鐞嗙煡鎯呭悓鎰忎功-" + appointment.getPatName() + "-" + timestamp + ".doc";
+ String time = String.valueOf(System.currentTimeMillis());
+ String fileName = "椋熺蹇冭剰鐢电敓鐞嗙煡鎯呭悓鎰忎功-" + appointment.getPatName() + "-" + time + ".doc";
- // 璁剧疆鍝嶅簲澶达紝鍛婅瘔娴忚鍣ㄨ繘琛屼笅杞�
- response.setCharacterEncoding("UTF-8");
- response.setContentType("application/msword"); // Word鏂囨。绫诲瀷
- response.setHeader("Content-Disposition", "attachment; filename=" + URLEncoder.encode(fileName, "UTF-8"));
+ // 灏嗘ā鏉挎覆鏌撶粨鏋滃啓鍏tringWriter
+ StringWriter stringWriter = new StringWriter();
+ try (Writer out = new BufferedWriter(stringWriter)) {
+ t.process(dataMap, out);
+ }
- // 鐩存帴杈撳嚭鍒皉esponse鐨勮緭鍑烘祦
- Writer out = new BufferedWriter(new OutputStreamWriter(response.getOutputStream(), "UTF-8"));
- t.process(dataMap, out);
- out.flush();
- out.close();
+ String xmlContent = stringWriter.toString();
+
+ // 杩斿洖缁撴灉
+ Map<String, Object> result1 = new HashMap<>();
+ Map<String, Object> result = new HashMap<>();
+ result.put("success", true);
+ result.put("fileName", fileName);
+ result.put("fileContent", xmlContent);
+ result.put("fileType", "application/msword");
+
+ result1.put("code", 200);
+ result1.put("data", result);
+ result1.put("msg", "success");
+
+ log.info("椋熺蹇冭剰鐢电敓鐞嗙煡鎯呭悓鎰忎功Word XML鍐呭鐢熸垚鎴愬姛");
+ return result1;
} catch (Exception e) {
- log.error("涓嬭浇椋熺蹇冭剰鐢电敓鐞嗙煡鎯呭悓鎰忎功鏂囨。澶辫触", e);
- try {
- response.sendError(HttpServletResponse.SC_INTERNAL_SERVER_ERROR, "鏂囨。鐢熸垚澶辫触");
- } catch (IOException ex) {
- log.error("鍙戦�侀敊璇搷搴斿け璐�", ex);
- }
+ log.error("鐢熸垚椋熺蹇冭剰鐢电敓鐞嗙煡鎯呭悓鎰忎功澶辫触", e);
+ Map<String, Object> result = new HashMap<>();
+ result.put("code", 500);
+ result.put("data", null);
+ result.put("msg", "鏂囨。鐢熸垚澶辫触: " + e.getMessage());
+ return result;
}
}
@@ -135,4 +165,20 @@
return Period.between(birthdayStr, LocalDate.now()).getYears();
}
+ public void createPath(String uploadPath) {
+ // 纭繚璺緞浠ユ枩鏉犵粨灏�
+ if (!uploadPath.endsWith("/") && !uploadPath.endsWith("\\")) {
+ uploadPath += "/";
+ }
+
+ // 鍒涘缓鐩綍锛堝鏋滀笉瀛樺湪锛�
+ File uploadDir = new File(uploadPath);
+ if (!uploadDir.exists()) {
+ boolean created = uploadDir.mkdirs();
+ if (created) {
+ log.info("鍒涘缓鐩綍鎴愬姛: {}", uploadPath);
+ }
+ }
+ }
+
}
--
Gitblit v1.9.3