From b6b0cb226fcf184525ee7b36af3a09471e9c0057 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期一, 25 三月 2024 11:29:33 +0800
Subject: [PATCH] 修改数据统计的查询条件
---
src/main/java/com/lf/server/helper/WebHelper.java | 297 +++++++++++++++++++++++++++++++++++++++++++++++++++++------
1 files changed, 265 insertions(+), 32 deletions(-)
diff --git a/src/main/java/com/lf/server/helper/WebHelper.java b/src/main/java/com/lf/server/helper/WebHelper.java
index a49924e..2d4c289 100644
--- a/src/main/java/com/lf/server/helper/WebHelper.java
+++ b/src/main/java/com/lf/server/helper/WebHelper.java
@@ -1,13 +1,25 @@
package com.lf.server.helper;
+import com.alibaba.fastjson.JSON;
+import com.lf.server.entity.all.HttpStatus;
+import com.lf.server.entity.all.ResponseMsg;
+import com.lf.server.entity.all.SettingData;
import com.lf.server.entity.all.StaticData;
+import org.apache.commons.logging.Log;
+import org.apache.commons.logging.LogFactory;
+import org.springframework.web.context.request.RequestContextHolder;
+import org.springframework.web.context.request.ServletRequestAttributes;
+import javax.servlet.ServletContext;
+import javax.servlet.ServletOutputStream;
import javax.servlet.http.Cookie;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
+import javax.servlet.http.HttpSession;
+import java.io.*;
+import java.net.URLEncoder;
import java.sql.Timestamp;
-import java.util.Calendar;
-import java.util.UUID;
+import java.util.*;
/**
* Web甯姪绫�
@@ -18,6 +30,8 @@
private final static String COMMA = ",";
+ private final static Log log = LogFactory.getLog(WebHelper.class);
+
/**
* 鑾峰彇GUID
*/
@@ -27,9 +41,6 @@
/**
* 鑾峰彇鐢ㄦ埛ip
- *
- * @param request
- * @return
*/
public static String getIpAddress(HttpServletRequest request) {
String ip = request.getHeader("X-Forwarded-For");
@@ -82,9 +93,6 @@
/**
* 鑾峰彇褰撳墠鏃堕棿鎸囧畾鍒嗛挓鏁板悗鐨凾imestamp
- *
- * @param min 鍒嗛挓鏁�
- * @return
*/
public static Timestamp getTimestamp(int min) {
Calendar now = Calendar.getInstance();
@@ -95,9 +103,6 @@
/**
* 浠嶤ookie涓幏鍙杢oken
- *
- * @param request
- * @return
*/
public static String getTokenFromCookie(HttpServletRequest request) {
Cookie[] cookies = request.getCookies();
@@ -119,14 +124,10 @@
/**
* 鍚慍ookie涓坊鍔爐oken
- *
- * @param token
- * @param request
- * @param response
*/
public static void saveToken2Cookie(String token, HttpServletRequest request, HttpServletResponse response) {
// 鍏堝垹闄�
- deleteCookie(StaticData.TOKEN_COOKIE_KEY, request);
+ deleteCookies(request, response);
// 鍐嶄繚瀛�
saveCookie(StaticData.TOKEN_COOKIE_KEY, token, response);
@@ -134,18 +135,14 @@
/**
* 淇濆瓨Cookie
- *
- * @param cookieKey
- * @param value
- * @param response
*/
- public static void saveCookie(String cookieKey, String value, HttpServletResponse response) {
- Cookie cookie = new Cookie(cookieKey, value);
+ public static void saveCookie(String key, String value, HttpServletResponse response) {
+ Cookie cookie = new Cookie(key, value);
// 璁剧疆cookie澶辨晥鏃堕棿锛屽崟浣嶄负绉�
- cookie.setMaxAge(240 * 60);
+ cookie.setMaxAge(SettingData.COOKIE_MAX_AGE);
cookie.setHttpOnly(false);
cookie.setPath("/");
- // cookie.setDomain("")
+ //cookie.setDomain("*")
response.setHeader("P3P", "CP=CAO PSA OUR");
response.addCookie(cookie);
@@ -153,27 +150,54 @@
/**
* 鍒犻櫎cookie涓殑鍊�
- *
- * @param cookieKey
- * @param request
*/
- public static void deleteCookie(String cookieKey, HttpServletRequest request) {
+ public static void deleteCookie(String cookieKey, HttpServletRequest request, HttpServletResponse response) {
Cookie[] cookies = request.getCookies();
if (cookies != null && cookies.length > 0) {
for (Cookie c : cookies) {
if (cookieKey.equalsIgnoreCase(c.getName())) {
c.setMaxAge(0);
- break;
+ c.setPath("/");
+ response.addCookie(c);
}
}
}
}
/**
+ * 鍒犻櫎鎵�鏈塁ookie
+ */
+ public static void deleteCookies(HttpServletRequest request, HttpServletResponse response) {
+ Cookie[] cookies = request.getCookies();
+ if (cookies != null && cookies.length > 0) {
+ for (Cookie c : cookies) {
+ c.setMaxAge(0);
+ c.setPath("/");
+ response.addCookie(c);
+ }
+ }
+ }
+
+ /**
+ * 鏍规嵁閿幏鍙朇ookie鍊�
+ */
+ public static String getCookieByKey(String key, HttpServletRequest request) {
+ Cookie[] cookies = request.getCookies();
+ if (cookies == null || cookies.length == 0) {
+ return null;
+ }
+
+ for (Cookie c : cookies) {
+ if (key.equals(c.getName())) {
+ return c.getValue();
+ }
+ }
+
+ return null;
+ }
+
+ /**
* 鑾峰彇Token
- *
- * @param request
- * @return
*/
public static String getToken(HttpServletRequest request) {
// 1.浠巙rl鍙傛暟涓紝鑾峰彇token
@@ -191,4 +215,213 @@
return token;
}
+
+ /**
+ * 鑾峰彇Request
+ */
+ public static HttpServletRequest getRequest() {
+ ServletRequestAttributes servletRequestAttributes = (ServletRequestAttributes) RequestContextHolder.getRequestAttributes();
+
+ return servletRequestAttributes.getRequest();
+ }
+
+ /**
+ * 鑾峰彇Response
+ */
+ public static HttpServletResponse getResponse() {
+ ServletRequestAttributes servletRequestAttributes = (ServletRequestAttributes) RequestContextHolder.getRequestAttributes();
+
+ return servletRequestAttributes.getResponse();
+ }
+
+ /**
+ * 鑾峰彇Session
+ */
+ public static HttpSession getSession() {
+ return getRequest().getSession();
+ }
+
+ /**
+ * 鑾峰彇鐪熷疄璺緞
+ */
+ public static String getRealPath(String path) {
+ HttpServletRequest req = getRequest();
+ ServletContext ctx = req.getSession().getServletContext();
+
+ return ctx.getRealPath("/" + path);
+ }
+
+ /**
+ * 杈撳嚭str鑷冲墠绔�
+ */
+ public static boolean writeStr2Page(HttpServletResponse res, String str) {
+ try {
+ res.setContentType("application/json;charset=UTF-8");
+ res.setHeader("Cache-Control", "no-cache");
+ res.setHeader("Pragma", "No-cache");
+ res.setDateHeader("Expires", 0);
+
+ PrintWriter out = res.getWriter();
+ out.print(str);
+
+ out.flush();
+ out.close();
+ } catch (Exception ex) {
+ log.error(ex.getMessage(), ex);
+ }
+
+ return false;
+ }
+
+ /**
+ * 杈撳嚭json鑷冲墠绔�
+ */
+ public static void writeJson2Page(HttpServletResponse res, String str) {
+ String json = JSON.toJSONString(new ResponseMsg<>(HttpStatus.ERROR, str));
+ writeStr2Page(res, json);
+ }
+
+ /**
+ * 鑾峰彇閿欒JSON
+ */
+ public static String getErrJson(HttpStatus status, String msg) {
+ return JSON.toJSONString(new ResponseMsg<String>(status, msg));
+ }
+
+ /**
+ * 鍐欏搷搴斾俊鎭�
+ */
+ public static void writeInfo(HttpStatus status, String info, HttpServletResponse res) {
+ WebHelper.writeStr2Page(res, WebHelper.getErrJson(status, info));
+ }
+
+ /**
+ * 鑾峰彇闅忔満鏁存暟
+ */
+ public static int getRandomInt(int min, int max) {
+ return new Random().nextInt(max) % (max - min + 1) + min;
+ }
+
+ /**
+ * 涓嬭浇鏂囦欢
+ */
+ public static void download(String file, String fileName, HttpServletResponse res) throws Exception {
+ download(file, fileName, false, res);
+ }
+
+ /**
+ * 涓嬭浇鏂囦欢
+ *
+ * @param file 鏂囦欢
+ * @param fileName 鏂囦欢鍚�
+ * @param res 鍝嶅簲
+ * @throws Exception 寮傚父
+ */
+ public static void download(String file, String fileName, boolean inline, HttpServletResponse res) throws Exception {
+ if (StringHelper.isEmpty(fileName)) {
+ fileName = StringHelper.YMDHMS2_FORMAT.format(new Date());
+ }
+ fileName = URLEncoder.encode(fileName, "UTF-8").replace("+", "%20");
+ String dispose = inline ? "inline" : "attachment";
+
+ // 璁剧疆鍝嶅簲澶翠腑鏂囦欢鐨勪笅杞芥柟寮忎负闄勪欢鏂瑰紡锛屼互鍙婅缃枃浠跺悕
+ res.setHeader("Content-Disposition", dispose + "; filename*=UTF-8''" + fileName);
+ // 璁剧疆鍝嶅簲澶寸殑缂栫爜鏍煎紡涓� UTF-8
+ res.setCharacterEncoding("UTF-8");
+
+ // 閫氳繃response瀵硅薄璁剧疆鍝嶅簲鏁版嵁鏍煎紡(濡傦細"text/plain; charset=utf-8")
+ String ext = FileHelper.getExtension(file);
+ String mime = FileHelper.getMime(ext);
+ res.setContentType(mime);
+
+ // 閫氳繃response瀵硅薄锛岃幏鍙栧埌杈撳嚭娴�
+ ServletOutputStream outputStream = res.getOutputStream();
+ // 瀹氫箟杈撳叆娴侊紝閫氳繃杈撳叆娴佽鍙栨枃浠跺唴瀹�
+ FileInputStream fileInputStream = new FileInputStream(file);
+
+ int len = 0;
+ byte[] bytes = new byte[1024];
+ while ((len = fileInputStream.read(bytes)) != -1) {
+ // 閫氳繃杈撳叆娴佽鍙栨枃浠舵暟鎹紝鐒跺悗閫氳繃涓婅堪鐨勮緭鍑烘祦鍐欏洖娴忚鍣�
+ outputStream.write(bytes, 0, len);
+ outputStream.flush();
+ }
+
+ // 鍏抽棴璧勬簮
+ fileInputStream.close();
+ outputStream.close();
+ }
+
+ /**
+ * 鎵ц鍛戒护
+ *
+ * @param cmd 鍛戒护
+ */
+ public static void exec(String cmd) {
+ try {
+ Runtime.getRuntime().exec(cmd);
+ } catch (Exception ex) {
+ log.error(ex.getMessage(), ex);
+ }
+ }
+
+ /**
+ * 鎵ц鍛戒护
+ *
+ * @param cmd 鍛戒护
+ */
+ public static String exec2(String cmd) {
+ try {
+ StringBuilder sb = new StringBuilder();
+ Process process = Runtime.getRuntime().exec(cmd);
+ BufferedReader reader = new BufferedReader(new InputStreamReader(process.getInputStream()));
+
+ String line;
+ while ((line = reader.readLine()) != null) {
+ sb.append(line).append("\n");
+ }
+ reader.close();
+
+ return sb.toString();
+ } catch (Exception ex) {
+ log.error(ex.getMessage(), ex);
+ return null;
+ }
+ }
+
+ /**
+ * 鑾峰彇璇锋眰鐨勫弬鏁板��
+ *
+ * @param req 璇锋眰
+ * @param key 鍙傛暟鍚�
+ * @return 鍙傛暟鍊�
+ */
+ public static String getReqParamVal(HttpServletRequest req, String key) {
+ Map<String, String[]> maps = req.getParameterMap();
+ for (Map.Entry<String, String[]> entry : maps.entrySet()) {
+ if (entry.getKey().equalsIgnoreCase(key)) {
+ return null == entry.getValue() || 0 == entry.getValue().length ? null : entry.getValue()[0];
+ }
+ }
+
+ return null;
+ }
+
+ /**
+ * 鑾峰彇璇锋眰鐨勫弬鏁板��
+ *
+ * @param req 璇锋眰
+ * @param key 鍙傛暟鍚�
+ * @return 鍙傛暟鍊�
+ */
+ public static String[] getReqParamVals(HttpServletRequest req, String key) {
+ Map<String, String[]> maps = req.getParameterMap();
+ for (Map.Entry<String, String[]> entry : maps.entrySet()) {
+ if (entry.getKey().equalsIgnoreCase(key)) {
+ return entry.getValue();
+ }
+ }
+
+ return null;
+ }
}
--
Gitblit v1.9.3