From 02d038387df02b1e4dcf140c3e78c6f95719155e Mon Sep 17 00:00:00 2001
From: 许鹏程 <1821349743@qq.com>
Date: 星期二, 11 二月 2025 10:50:53 +0800
Subject: [PATCH] excel文件预览app端特殊处理

---
 src/main/java/com/product/file/service/FileManagerService.java |   57 ++++++++++++++++++++++++++++++++++-----------------------
 1 files changed, 34 insertions(+), 23 deletions(-)

diff --git a/src/main/java/com/product/file/service/FileManagerService.java b/src/main/java/com/product/file/service/FileManagerService.java
index 7a77f08..e8d3efe 100644
--- a/src/main/java/com/product/file/service/FileManagerService.java
+++ b/src/main/java/com/product/file/service/FileManagerService.java
@@ -1,9 +1,11 @@
 package com.product.file.service;
 
+import cn.hutool.core.date.DateUtil;
 import com.alibaba.fastjson.JSONObject;
 import com.google.common.collect.Lists;
 import com.google.common.collect.Maps;
 import com.product.common.lang.StringUtils;
+import com.product.core.config.CoreConst;
 import com.product.core.config.Global;
 import com.product.core.connection.ConnectionManager;
 import com.product.core.dao.BaseDao;
@@ -21,14 +23,10 @@
 import com.product.file.util.FileUtils;
 import com.product.module.sys.entity.SystemUser;
 import com.product.util.BaseUtil;
-
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.stereotype.Service;
-import org.springframework.web.context.request.RequestContextHolder;
-import org.springframework.web.context.request.ServletRequestAttributes;
 
 import javax.servlet.ServletOutputStream;
-import javax.servlet.http.HttpServletRequest;
 import javax.servlet.http.HttpServletResponse;
 import java.io.*;
 import java.net.URLEncoder;
@@ -321,7 +319,7 @@
 		String uuids = "";
 		for (Map.Entry<Object, Object> entry : map.entrySet()) {
 			fieldFse = fieldMetaEntity.getFieldMeta(fieldName);
-			if (fieldFse == null || !CmnConst.ATTACHMENT_TYPE.equals(fieldFse.getString(CmnConst.FIELD_TYPE))) {
+			if (fieldFse == null || (!CmnConst.ATTACHMENT_TYPE.equals(fieldFse.getString(CmnConst.FIELD_TYPE)) && !"file-image".equals(fieldFse.getString(CmnConst.FIELD_TYPE)))) {
 				fse.setValue(entry.getKey().toString(), null);
 				continue;
 			}
@@ -419,7 +417,7 @@
 		}
 		return fse;
 	}
-	
+
 	/**
 	 * 	鏍规嵁闄勪欢琛ㄦ暟鎹敓鎴愭枃妗g储寮�
 	 */
@@ -427,17 +425,17 @@
 		// 閬嶅巻闄勪欢琛�
 		DataTableEntity dtAttachment = baseDao.listTable(CmnConst.PRODUCT_SYS_ATTACHMENTS);
 		if (BaseUtil.dataTableIsEmpty(dtAttachment)) {
-			return ;
+			return;
 		}
 		for (int i = 0; i < dtAttachment.getRows(); i++) {
 			// 鑾峰彇闄勪欢淇℃伅锛屽苟鍒ゆ柇鏄惁鏈夎〃鍜屽瓧娈�
 			FieldSetEntity fseAttachment = dtAttachment.getFieldSetEntity(i);
-			if(BaseUtil.strIsNull(fseAttachment.getString("attachment_data_field")) || BaseUtil.strIsNull(fseAttachment.getString("attachment_data_field"))) {
+			if (BaseUtil.strIsNull(fseAttachment.getString("attachment_data_field")) || BaseUtil.strIsNull(fseAttachment.getString("attachment_data_field"))) {
 				continue;
 			}
 			// 鏌ヨ鍘熸暟鎹紝鏈夊師鏁版嵁鍐嶇敓鎴愭枃妗f绱�
-			FieldSetEntity fseRecord = baseDao.getFieldSetEntityByFilter(fseAttachment.getString("attachment_data_table"), fseAttachment.getString("attachment_data_field") + " LIKE ?", new Object[] {"%"+fseAttachment.getUUID()+"%"}, false);
-			if(fseRecord != null) {
+			FieldSetEntity fseRecord = baseDao.getFieldSetEntityByFilter(fseAttachment.getString("attachment_data_table"), fseAttachment.getString("attachment_data_field") + " LIKE ?", new Object[]{"%" + fseAttachment.getUUID() + "%"}, false);
+			if (fseRecord != null) {
 				// 鐢熸垚鏂囨。妫�绱俊鎭�
 				FieldSetEntity fseIndex = new FieldSetEntity();
 				fseIndex.setTableName("fseIndex");
@@ -469,9 +467,17 @@
 		String viewOnlineSign = attachmentFse.getString(CmnConst.VIEW_ONLINE_SIGN);
 		boolean encrptSignFlag = "1".equals(attachmentFse.getString(CmnConst.ENCRPT_SIGN));
 		boolean needOnlineViewFlag = "1".equals(fse.getString(CmnConst.NEED_ONLINE_VIEW)) && "1".equals(viewOnlineSign);
-		if (needOnlineViewFlag && !realFileName.endsWith(".xlsx") && !realFileName.endsWith(".xls")) {
-			// 闇�瑕佸湪绾块瑙堜笖杞崲涔嬪悗鎵嶈兘鍦ㄧ嚎棰勮 excel 鏂囦欢涓嶉渶瑕佽浆鎹㈢洿鎺ヨ緭鍑洪瑙�
-			dir += File.separator + CmnConst.TRANSFER_DIR_NAME;
+		String clientType = SpringMVCContextHolder.getCurrentUser().getClientType();
+
+		String contentType = "multipart/form-data";
+		boolean isExcel = realFileName.endsWith(".xlsx") || realFileName.endsWith(".xls");
+		if (needOnlineViewFlag) {
+			//鐗规畩澶勭悊锛� 濡傛灉瀹㈡埛绔笉鏄疉pp 浣嗛瑙堢殑鏂囦欢鏄疎xcel 鐩存帴杩斿洖excel婧愭枃浠� content澶存爣璇嗘槸excel cheng 2025骞�2鏈�11鏃�10:41:41
+			if (isExcel && !CoreConst.CLIENT_TYPE_APP.equals(clientType)) {
+				contentType = "application/vnd.ms-excel";
+			} else {
+				dir += File.separator + CmnConst.TRANSFER_DIR_NAME;
+			}
 		}
 
 		String path = dir + File.separator + fileName;
@@ -480,11 +486,8 @@
 			FTPService ftpService = new FTPService();
 			logger.info("闇�瑕佷粠闄勪欢鏈嶅姟鍣ㄤ笂鍙栨枃浠�...");
 			response.setHeader("Access-Control-Expose-Headers", "*");
-			if (realFileName.endsWith(".xlsx") || realFileName.endsWith(".xls")) {
-				response.setContentType("application/vnd.ms-excel");
-			} else {
-				response.setContentType("multipart/form-data");
-			}
+
+			response.setContentType(contentType);
 			response.setHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode(realFileName, "UTF-8"));
 			//璁剧疆澶翠腑鐨勬枃浠剁被鍨�
 			if (!needOnlineViewFlag && !encrptSignFlag) {
@@ -535,6 +538,17 @@
 			String localBasePath = Global.getSystemConfig("local.dir", "");
 			path = localBasePath + File.separator + path;
 			File file = new File(path);
+			if (needOnlineViewFlag && file.exists() && CoreConst.CLIENT_TYPE_APP.equals(clientType)) {
+				//鐗规畩澶勭悊锛� 鏄疉pp 浣嗛瑙堢殑鏂囦欢鏄疎xcel 闇�瑕佸皢涔嬪墠宸茶浆鎹负鐨勬枃浠跺垹闄ゆ帀閲嶆柊杞崲锛堝洜杞崲鍚庣殑鏍煎紡涓嶆槸pdf)
+				String changeTime = "2025-02-11 23:59:59";
+				Date changeDate = DateUtil.parse(changeTime, "yyyy-MM-dd HH:mm:ss");
+				long fileTime = file.lastModified();
+				//濡傛灉鏃堕棿鏄� 2025骞�2鏈�10鏃�23:59:59锛岄偅涔堝氨閲嶆柊杞崲
+				//鍒犻櫎鏂囦欢
+				if (fileTime <= changeDate.getTime()) {
+					file.delete();
+				}
+			}
 			if (needOnlineViewFlag && !file.exists()) {
 				// 鑻ユ槸棰勮锛屼絾鏄浆鎹㈠悗鐨勬枃浠朵笉瀛樺湪锛岄偅涔堥噸鏂版墽琛岃浆鎹㈡搷浣�
 				File sourceFile = fileUtils.getFile(false, attachmentFse.getString(CmnConst.ATTACHMENT_URL), fileName, encrptSignFlag);
@@ -547,11 +561,8 @@
 			byte[] b = new byte[1024];
 			InputStream is = new FileInputStream(file);
 			response.setHeader("Access-Control-Expose-Headers", "*");
-			if (realFileName.endsWith(".xlsx") || realFileName.endsWith(".xls")) {
-				response.setContentType("application/vnd.ms-excel");
-			} else {
-				response.setContentType("multipart/form-data");
-			}
+
+			response.setContentType(contentType);
 			response.setHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode(realFileName, "UTF-8"));
 			response.setContentLengthLong(file.length());
 			try (ServletOutputStream os = response.getOutputStream()) {

--
Gitblit v1.9.2