From 05ca3b14bc7511c1d04f65d82378ae144461e43c Mon Sep 17 00:00:00 2001
From: yujian <yujian@123.com>
Date: 星期一, 14 十月 2019 18:05:58 +0800
Subject: [PATCH] 验证 推荐中的所有商品是否已下架

---
 fanli/src/main/java/com/yeshi/fanli/controller/admin/ExtractAdminController.java |  135 ++++++++++++++++++++++++++++++++++-----------
 1 files changed, 102 insertions(+), 33 deletions(-)

diff --git a/fanli/src/main/java/com/yeshi/fanli/controller/admin/ExtractAdminController.java b/fanli/src/main/java/com/yeshi/fanli/controller/admin/ExtractAdminController.java
index 9847e79..7e003a8 100644
--- a/fanli/src/main/java/com/yeshi/fanli/controller/admin/ExtractAdminController.java
+++ b/fanli/src/main/java/com/yeshi/fanli/controller/admin/ExtractAdminController.java
@@ -1,8 +1,16 @@
 package com.yeshi.fanli.controller.admin;
 
+import java.io.BufferedReader;
+import java.io.File;
+import java.io.FileOutputStream;
+import java.io.FileReader;
+import java.io.IOException;
+import java.io.InputStream;
+import java.io.OutputStream;
 import java.io.PrintWriter;
 import java.math.BigDecimal;
 import java.net.URLDecoder;
+import java.net.URLEncoder;
 import java.text.ParseException;
 import java.text.SimpleDateFormat;
 import java.util.ArrayList;
@@ -13,17 +21,25 @@
 
 import javax.annotation.Resource;
 import javax.servlet.http.HttpServletRequest;
+import javax.servlet.http.HttpServletResponse;
 
 import org.springframework.stereotype.Controller;
 import org.springframework.web.bind.annotation.RequestMapping;
+import org.springframework.web.bind.annotation.RequestMethod;
+import org.springframework.web.bind.annotation.RequestParam;
+import org.springframework.web.multipart.commons.CommonsMultipartFile;
+import org.yeshi.utils.CsvUtil;
 import org.yeshi.utils.DateUtil;
 import org.yeshi.utils.IPUtil;
 import org.yeshi.utils.JsonUtil;
+import org.yeshi.utils.entity.wx.RedPackRecord;
+import org.yeshi.utils.wx.WXUtil;
 
 import com.google.gson.Gson;
 import com.google.gson.GsonBuilder;
 import com.google.gson.reflect.TypeToken;
 import com.yeshi.fanli.controller.admin.utils.AdminUtils;
+import com.yeshi.fanli.dto.ChartTDO;
 import com.yeshi.fanli.entity.bus.user.Extract;
 import com.yeshi.fanli.entity.bus.user.ExtractAuditRecord;
 import com.yeshi.fanli.entity.bus.user.HongBaoV2;
@@ -35,16 +51,17 @@
 import com.yeshi.fanli.log.LogHelper;
 import com.yeshi.fanli.service.AdminUserService;
 import com.yeshi.fanli.service.inter.config.ConfigService;
-import com.yeshi.fanli.service.inter.count.ExtractCountService;
 import com.yeshi.fanli.service.inter.count.HongBaoV2CountService;
 import com.yeshi.fanli.service.inter.count.UserInfoCountService;
+import com.yeshi.fanli.service.inter.money.extract.ExtractAuditRecordService;
+import com.yeshi.fanli.service.inter.money.extract.ExtractCountService;
+import com.yeshi.fanli.service.inter.money.extract.ExtractService;
+import com.yeshi.fanli.service.inter.order.tb.TaoBaoOrderService;
+import com.yeshi.fanli.service.inter.order.tb.TaoBaoWeiQuanOrderService;
 import com.yeshi.fanli.service.inter.push.PushRecordService;
-import com.yeshi.fanli.service.inter.taobao.TaoBaoOrderService;
-import com.yeshi.fanli.service.inter.taobao.TaoBaoWeiQuanOrderService;
-import com.yeshi.fanli.service.inter.user.ExtractAuditRecordService;
-import com.yeshi.fanli.service.inter.user.ExtractService;
 import com.yeshi.fanli.tag.PageEntity;
 import com.yeshi.fanli.util.Constant;
+import com.yeshi.fanli.util.FileUtil;
 import com.yeshi.fanli.util.RedisManager;
 import com.yeshi.fanli.util.StringUtil;
 import com.yeshi.fanli.util.TimeUtil;
@@ -390,25 +407,35 @@
 					if (extractState != null && extractState == Extract.STATE_NOT_PROCESS) {
 						UserInfo userInfo = extract.getUserInfo();
 						if (userInfo != null) {
-							BigDecimal countTodayMoney = extractService.sumTodayApplyMoney(userInfo.getId());
+							BigDecimal countTodayMoney = extractService.sumTodayApplyMoney(userInfo.getId(),
+									TimeUtil.getGernalTime(extract.getExtractTime()));
 							if (countTodayMoney.compareTo(new BigDecimal(100)) > 0) {
 								warnLevel = 1;
 							}
 						}
 					}
-
 				}
 
 				if (record.getExtraInfo() != null) {
-					if (record.getExtraInfo().getOrderCount50More() > 0
-							|| record.getExtraInfo().getWeiQuanOrderCount() > 0
-							|| record.getExtraInfo().getWeiQuanOrderFanAmount().compareTo(new BigDecimal(0)) > 0)
-						warnLevel = 2;
 					StringBuffer desc = new StringBuffer();
-					desc.append("澶т簬50鍏冭鍗�:" + record.getExtraInfo().getOrderCount50More() + "\n#");
-					desc.append("缁存潈璁㈠崟鏁�:" + record.getExtraInfo().getWeiQuanOrderCount() + "\n#");
-					desc.append("缁存潈璁㈠崟閫�鍥為噾棰�:" + record.getExtraInfo().getWeiQuanOrderFanAmount() + "\n#");
-					desc.append("180澶╁畨鍏ㄨ鍗曟暟:" + record.getExtraInfo().getSafeOrderCount());
+					if (System.currentTimeMillis() > TimeUtil.convertToTimeTemp("2019-06-21", "yyyy-MM-dd")) {
+						desc.append("澶х瑪璁㈠崟鏁�:" + record.getExtraInfo().getOrderCount50More() + "\n#");
+						desc.append("缁存潈璁㈠崟鏁�:" + record.getExtraInfo().getWeiQuanOrderCount() + "\n#");
+						desc.append("缁存潈璁㈠崟浣i噾:" + record.getExtraInfo().getWeiQuanOrderFanAmount() + "\n#");
+						if (record.getExtraInfo().getOrderCount50More() > 0
+								|| record.getExtraInfo().getWeiQuanOrderCount() > 1
+								|| record.getExtraInfo().getWeiQuanOrderFanAmount().compareTo(new BigDecimal(10)) >= 0)
+							warnLevel = 2;
+					} else {
+						if (record.getExtraInfo().getOrderCount50More() > 0
+								|| record.getExtraInfo().getWeiQuanOrderCount() > 0
+								|| record.getExtraInfo().getWeiQuanOrderFanAmount().compareTo(new BigDecimal(0)) > 0)
+							warnLevel = 2;
+						desc.append("澶т簬50鍏冭鍗�:" + record.getExtraInfo().getOrderCount50More() + "\n#");
+						desc.append("缁存潈璁㈠崟鏁�:" + record.getExtraInfo().getWeiQuanOrderCount() + "\n#");
+						desc.append("缁存潈璁㈠崟閫�鍥為噾棰�:" + record.getExtraInfo().getWeiQuanOrderFanAmount() + "\n#");
+						desc.append("180澶╁畨鍏ㄨ鍗曟暟:" + record.getExtraInfo().getSafeOrderCount());
+					}
 					record.setExtraInfoStr(desc.toString());
 				}
 				record.setWarnLevel(warnLevel);
@@ -420,6 +447,8 @@
 
 			GsonBuilder gsonBuilder = new GsonBuilder();
 			gsonBuilder.serializeNulls();
+			gsonBuilder.setDateFormat("yyyy-MM-dd HH:mm:ss");
+			
 			Gson gson = gsonBuilder.create();
 
 			JSONObject data = new JSONObject();
@@ -809,9 +838,8 @@
 					innerList.put("name", "椹冲洖鏁�");
 				}
 
-				List<Map<String, Object>> list = extractAuditRecordService.countAuditTotal(state, dateType, year,
+				List<ChartTDO> list = extractAuditRecordService.countAuditTotal(state, dateType, year,
 						startTime, endTime);
-
 				if (dateType != 3) {
 					innerList.put("data", gson.toJson(AdminUtils.dayOrMonthDataFactory(dateType, dateList, list)));
 				} else {
@@ -823,7 +851,6 @@
 					}
 					innerList.put("data", gson.toJson(map.get("value")));
 				}
-
 				line_list.add(innerList);
 			}
 
@@ -835,9 +862,7 @@
 			}
 
 			data.put("line_list", line_list);
-
 			JsonUtil.printMode(out, callback, JsonUtil.loadTrueResult(data));
-
 		} catch (Exception e) {
 			JsonUtil.printMode(out, callback, JsonUtil.loadFalseResult("鎿嶄綔寮傚父"));
 			e.printStackTrace();
@@ -863,7 +888,6 @@
 	@RequestMapping(value = "getExtractApplyMoney")
 	public void getExtractApplyMoney(String callback, Integer dateType, String year, String startTime, String endTime,
 			PrintWriter out) {
-
 		String validateMsg = AdminUtils.validateParams(dateType, startTime, endTime);
 		if (validateMsg != null) {
 			JsonUtil.printMode(out, callback, JsonUtil.loadFalseResult(validateMsg));
@@ -896,12 +920,10 @@
 			List<String> dateList = AdminUtils.getDateList(dateType, startTime, endTime, year);
 
 			Gson gson = new Gson();
-			JSONArray line_list = new JSONArray();
-
 			JSONObject innerList = new JSONObject();
 			innerList.put("name", "鎬昏");
 
-			List<Map<String, Object>> list = extractAuditRecordService.countExtractApplyMoney(null, dateType, year,
+			List<ChartTDO> list = extractAuditRecordService.countExtractApplyMoney(null, dateType, year,
 					startTime, endTime);
 
 			if (dateType != 3) {
@@ -916,6 +938,7 @@
 				innerList.put("data", gson.toJson(map.get("value")));
 			}
 
+			JSONArray line_list = new JSONArray();
 			line_list.add(innerList);
 
 			JSONObject data = new JSONObject();
@@ -926,9 +949,7 @@
 			}
 
 			data.put("line_list", line_list);
-
 			JsonUtil.printMode(out, callback, JsonUtil.loadTrueResult(data));
-
 		} catch (Exception e) {
 			JsonUtil.printMode(out, callback, JsonUtil.loadFalseResult("鎿嶄綔寮傚父"));
 			e.printStackTrace();
@@ -956,7 +977,6 @@
 	@RequestMapping(value = "getExtractApplyNumber")
 	public void getExtractApplyNumber(String callback, Integer state, Integer dateType, String year, String startTime,
 			String endTime, PrintWriter out) {
-
 		String validateMsg = AdminUtils.validateParams(dateType, startTime, endTime);
 		if (validateMsg != null) {
 			JsonUtil.printMode(out, callback, JsonUtil.loadFalseResult(validateMsg));
@@ -984,17 +1004,15 @@
 		}
 
 		try {
-
 			Object objectDate = null;
+			Gson gson = new Gson();
 			List<String> dateList = AdminUtils.getDateList(dateType, startTime, endTime, year);
 
-			Gson gson = new Gson();
-			JSONArray line_list = new JSONArray();
 
 			JSONObject innerList = new JSONObject();
 			innerList.put("name", "鎬昏");
 
-			List<Map<String, Object>> list = extractAuditRecordService.countExtractApplyNumber(null, dateType, year,
+			List<ChartTDO> list = extractAuditRecordService.countExtractApplyNumber(null, dateType, year,
 					startTime, endTime);
 
 			if (dateType != 3) {
@@ -1009,6 +1027,7 @@
 				innerList.put("data", gson.toJson(map.get("value")));
 			}
 
+			JSONArray line_list = new JSONArray();
 			line_list.add(innerList);
 
 			JSONObject data = new JSONObject();
@@ -1019,13 +1038,63 @@
 			}
 
 			data.put("line_list", line_list);
-
 			JsonUtil.printMode(out, callback, JsonUtil.loadTrueResult(data));
-
 		} catch (Exception e) {
 			JsonUtil.printMode(out, callback, JsonUtil.loadFalseResult("鎿嶄綔寮傚父"));
 			e.printStackTrace();
 		}
 	}
+	
+	@RequestMapping(value = "downAutoExtractTxt")
+	public void downAutoExtractTxt(String callback, HttpServletResponse response, PrintWriter out) {
+		try {
+			List<String> list = extractService.getAutoExtractOpenIds();
+			if (list == null || list.size() <= 1) {
+				JsonUtil.printMode(out, callback, JsonUtil.loadFalseResult("鏆傛棤鐢ㄦ埛婊¤冻鑷姩鎻愮幇鏉′欢"));
+				return;
+			}
+			
+			String filepath = "鑷姩鎻愮幇OpenId "+ java.lang.System.currentTimeMillis() + ".txt";
+			response.reset();
+		    response.setContentType("application/octet-stream");
+		    String fileName= URLDecoder.decode(filepath,"utf-8");
+		    response.addHeader("Content-Disposition","attachment;"+ "filename=\"" +URLEncoder.encode(fileName, "utf-8") + "\"");
+			
+			StringBuilder sb = new StringBuilder();
+			for(String t:list){
+				sb.append(t+"\r\n");
+			}
+			
+		    OutputStream os = response.getOutputStream();
+            byte[] byt = sb.toString().getBytes();
+            os.write(byt);
+            os.flush();
+	    	os.close();
+		} catch (Exception e) {
+			JsonUtil.printMode(out, callback, JsonUtil.loadFalseResult("鎿嶄綔寮傚父"));
+			e.printStackTrace();
+		}
+	}
+	
+	
+	@RequestMapping(value = "uploadExcel", method = RequestMethod.POST)
+	public void uploadExcel(@RequestParam("file") CommonsMultipartFile file, PrintWriter out) {
+		if (file == null) {
+			out.print(JsonUtil.loadFalseResult("涓婁紶鏂囦欢涓嶈兘涓虹┖锛�"));
+			return;
+		}
+
+		try {
+			List<RedPackRecord> list = CsvUtil.getCsvData(file, RedPackRecord.class);
+			extractService.updateManualExtractRecord(list);
+			out.print(JsonUtil.loadTrueResult("涓婁紶鎴愬姛"));
+		} catch (ExtractException e) {
+			out.print(JsonUtil.loadFalseResult(e.getMsg()));
+		} catch (Exception e) {
+			e.printStackTrace();
+			out.print(JsonUtil.loadFalseResult("涓婁紶澶辫触"));
+		}
+	}
+	
 
 }

--
Gitblit v1.8.0