From 0588d6be74335f41c79a8d8e32dbd1c3d3e47fa3 Mon Sep 17 00:00:00 2001
From: yujian <yujian@123.com>
Date: 星期三, 29 五月 2019 17:20:50 +0800
Subject: [PATCH] 精选库商品入库及更新调整 + 9k9类商品查询取消标签查询

---
 fanli/src/main/java/com/yeshi/fanli/controller/apph5/AppH5QualityGoodsController.java |  283 ++++++++++++++++++--------------------------------------
 1 files changed, 91 insertions(+), 192 deletions(-)

diff --git a/fanli/src/main/java/com/yeshi/fanli/controller/apph5/AppH5QualityGoodsController.java b/fanli/src/main/java/com/yeshi/fanli/controller/apph5/AppH5QualityGoodsController.java
index ef506a3..680fbe6 100644
--- a/fanli/src/main/java/com/yeshi/fanli/controller/apph5/AppH5QualityGoodsController.java
+++ b/fanli/src/main/java/com/yeshi/fanli/controller/apph5/AppH5QualityGoodsController.java
@@ -16,7 +16,6 @@
 import com.google.gson.Gson;
 import com.google.gson.GsonBuilder;
 import com.yeshi.fanli.entity.accept.AcceptData;
-import com.yeshi.fanli.entity.bus.lable.Label;
 import com.yeshi.fanli.entity.bus.lable.MergeClass;
 import com.yeshi.fanli.entity.bus.lable.QualityFactory;
 import com.yeshi.fanli.entity.goods.CollectionGoodsV2;
@@ -103,7 +102,8 @@
 	 */
 	@RequestMapping(value = "get9k9")
 	public void get9k9(String callback, Integer page, Long mcid, PrintWriter out) {
-		get9k9ClassGoods("9.9", callback, page, mcid, out);
+		get9k9ClassGoods(callback, out, page, 500, new BigDecimal(209.9), new BigDecimal(0), new BigDecimal(9.9), mcid);
+
 	}
 
 	/**
@@ -114,7 +114,8 @@
 	 */
 	@RequestMapping(value = "get19k9")
 	public void get19k9(String callback, Integer page, Long mcid, PrintWriter out) {
-		get9k9ClassGoods("19.9", callback, page, mcid, out);
+		get9k9ClassGoods(callback, out, page, 500, new BigDecimal(319.9), new BigDecimal(9.9), new BigDecimal(19.9), mcid);
+
 	}
 
 	/**
@@ -125,7 +126,8 @@
 	 */
 	@RequestMapping(value = "get29k9")
 	public void get29k9(String callback, Integer page, Long mcid, PrintWriter out) {
-		get9k9ClassGoods("29.9", callback, page, mcid, out);
+		get9k9ClassGoods(callback, out, page, 500, new BigDecimal(429.9), new BigDecimal(19.9), new BigDecimal(29.9), mcid);
+
 	}
 
 	/**
@@ -136,7 +138,7 @@
 	 */
 	@RequestMapping(value = "get49k9")
 	public void get49k9(String callback, Integer page, Long mcid, PrintWriter out) {
-		get9k9ClassGoods("49.9", callback, page, mcid, out);
+		get9k9ClassGoods(callback, out, page, 500, new BigDecimal(549.9), new BigDecimal(29.9), new BigDecimal(49.9), mcid);
 	}
 
 	/**
@@ -150,111 +152,60 @@
 	 *            瀵瑰簲绫荤洰id
 	 * @param out
 	 */
-	public void get9k9ClassGoods(String labName, String callback, Integer page, Long mcid, PrintWriter out) {
-
+	public void get9k9ClassGoods(String callback, PrintWriter out, Integer page, Integer biz30day, BigDecimal zkPrice,
+			BigDecimal minQuanPrice, BigDecimal maxQuanPrice,  Long mcid) {
 		try {
-
-			List<Label> labs = labelService.selectByTitleCache("labKey", labName);
-			if (labs == null || labs.size() == 0) {
-				JsonUtil.printMode(out, callback, JsonUtil.loadFalseResult("鏆傛棤鏁版嵁"));
-				return;
-			}
-
-			Long labId = labs.get(0).getId();
-
-			if (page == null)
+			if (page == null || page <= 0) {
 				page = 1;
+			}
 
 			int pageSize = Constant.PAGE_SIZE;
 
-			JSONObject jsonGoods = queryGoodsSmallAmount(page, pageSize, mcid, labId);
-			if (jsonGoods == null) {
+			String mergeCids = null;
+			if (mcid != null && (!mcid.equals(0) || mcid != 0)) {
+				MergeClass mergeClass = mergeClassService.selectByPrimaryKeyCache(mcid);
+				if (mergeClass != null) {
+					// 鍒嗙被id,闅斿紑
+					mergeCids = mergeClass.getMergeCids();
+				}
+			}
+
+			// 鏍规嵁鏍囩id 鏌ヨ鏁版嵁
+			List<QualityFactory> listQuery = qualityGoodsService.get9k9ClassGoods((page-1)*pageSize, pageSize, biz30day, zkPrice,
+					minQuanPrice, maxQuanPrice, mergeCids);
+			if (listQuery == null || listQuery.size() == 0) {
 				JsonUtil.printMode(out, callback, JsonUtil.loadFalseResult(2, "娌℃湁鏇村浜�"));
 				return;
 			}
 
-			JsonUtil.printMode(out, callback, JsonUtil.loadTrueResult(jsonGoods));
+			// 鎬绘潯鏁�
+			long count = qualityGoodsService.count9k9ClassGoods(biz30day, zkPrice, minQuanPrice, maxQuanPrice, mergeCids);
 
+			JSONArray array = new JSONArray();
+			Gson gson = JsonUtil.getConvertBigDecimalToStringSubZeroBuilder(new GsonBuilder())
+					.excludeFieldsWithoutExposeAnnotation().setDateFormat("yyyy-MM-dd").create();
+
+			BigDecimal proportion = hongBaoManageService.getFanLiRate();
+			/* 閬嶅巻鍒楄〃鏁版嵁 */
+			for (QualityFactory selectionGoods : listQuery) {
+				TaoBaoGoodsBrief goodsBrief = selectionGoods.getTaoBaoGoodsBrief();
+				if (goodsBrief == null) {
+					continue;
+				}
+				array.add(gson.toJson(TaoBaoUtil.getTaoBaoGoodsBriefExtra(goodsBrief, proportion.toString(), null)));
+			}
+
+			JSONObject data = new JSONObject();
+			data.put("count", count);
+			data.put("result_list", array);
+
+			JsonUtil.printMode(out, callback, JsonUtil.loadTrueResult(data));
 		} catch (Exception e) {
 			JsonUtil.printMode(out, callback, JsonUtil.loadFalseResult("鏌ヨ澶辫触"));
-			try {
-				LogHelper.errorDetailInfo(e);
-			} catch (Exception e1) {
-				e1.printStackTrace();
-			}
+			LogHelper.errorDetailInfo(e);
 		}
 	}
 
-	/**
-	 * 鑾峰彇鍟嗗搧
-	 * 
-	 * @param page
-	 * @param pageSize
-	 * @param labIds
-	 * @return
-	 * @throws Exception
-	 */
-	public JSONObject queryGoodsSmallAmount(int page, int pageSize, Long mcid, Long labId) throws Exception {
-
-		String mergeCids = null;
-		if (mcid != null && (!mcid.equals(0) || mcid != 0)) {
-
-			MergeClass mergeClass = mergeClassService.selectByPrimaryKeyCache(mcid);
-			if (mergeClass != null) {
-				// 鍒嗙被id,闅斿紑
-				mergeCids = mergeClass.getMergeCids();
-			}
-		}
-
-		// 鏍规嵁鏍囩id 鏌ヨ鏁版嵁
-		List<QualityFactory> listQuery = qualityGoodsService.listQuerySmallAmount((page - 1) * pageSize, pageSize, null,
-				labId, mergeCids);
-
-		// 鎬绘潯鏁�
-		long count = qualityGoodsService.countQuerySmallAmount(null, labId, mergeCids);
-		if (listQuery == null || listQuery.size() == 0) {
-			return null;
-		}
-
-		JSONArray array = new JSONArray();
-		Gson gson = JsonUtil.getConvertBigDecimalToStringSubZeroBuilder(new GsonBuilder())
-				.excludeFieldsWithoutExposeAnnotation().setDateFormat("yyyy-MM-dd").create();
-
-		BigDecimal proportion = hongBaoManageService.getFanLiRate();
-		/* 閬嶅巻鍒楄〃鏁版嵁 */
-		for (QualityFactory selectionGoods : listQuery) {
-
-			TaoBaoGoodsBrief taoBaoGoodsBrief = selectionGoods.getTaoBaoGoodsBrief();
-
-			if (taoBaoGoodsBrief == null) {
-				continue;
-			}
-
-			int biz30day = taoBaoGoodsBrief.getBiz30day();
-			if (biz30day >= 10000) {
-				double sales = biz30day;
-				String salesCountMidea = String.format("%.1f", sales / 10000);
-				taoBaoGoodsBrief.setSalesCount(salesCountMidea + "涓�");
-			} else {
-				taoBaoGoodsBrief.setSalesCount(biz30day + "");
-			}
-
-			// 鏀瑰彉鍥剧墖灏哄
-			String pictUrl = taoBaoGoodsBrief.getPictUrl();
-			if (!StringUtil.isNullOrEmpty(pictUrl) && !pictUrl.contains("320x320")) {
-				taoBaoGoodsBrief.setPictUrl(TbImgUtil.getTBSize320Img(pictUrl));
-			}
-
-			array.add(gson.toJson(TaoBaoUtil.getTaoBaoGoodsBriefExtra(taoBaoGoodsBrief, proportion.toString(), null)));
-		}
-
-		JSONObject data = new JSONObject();
-
-		data.put("count", count);
-		data.put("result_list", array);
-
-		return data;
-	}
 
 	/**
 	 * 9.9鍟嗗搧-姣忔棩蹇呮姠
@@ -264,7 +215,8 @@
 	 */
 	@RequestMapping(value = "get9k9EverydayRob")
 	public void get9k9EverydayRob(String callback, Integer page, Long mcid, PrintWriter out) {
-		get9k9ClassToDayRob("9.9", callback, page, mcid, out, 1.0, 50.0);
+		queryEverydayRob(callback, out, page, new BigDecimal(209.9), new BigDecimal(0), new BigDecimal(9.9));
+
 	}
 
 	/**
@@ -275,7 +227,7 @@
 	 */
 	@RequestMapping(value = "get19k9EverydayRob")
 	public void get19k9EverydayRob(String callback, Integer page, Long mcid, PrintWriter out) {
-		get9k9ClassToDayRob("19.9", callback, page, mcid, out, 1.0, 50.0);
+		queryEverydayRob(callback, out, page, new BigDecimal(319.9), new BigDecimal(9.9), new BigDecimal(19.9));
 	}
 
 	/**
@@ -286,7 +238,8 @@
 	 */
 	@RequestMapping(value = "get29k9EverydayRob")
 	public void get29k9EverydayRob(String callback, Integer page, Long mcid, PrintWriter out) {
-		get9k9ClassToDayRob("29.9", callback, page, mcid, out, 1.0, 50.0);
+		queryEverydayRob(callback, out, page, new BigDecimal(429.9), new BigDecimal(19.9), new BigDecimal(29.9));
+
 	}
 
 	/**
@@ -297,50 +250,10 @@
 	 */
 	@RequestMapping(value = "get49k9EverydayRob")
 	public void get49k9EverydayRob(String callback, Integer page, Long mcid, PrintWriter out) {
-		get9k9ClassToDayRob("49.9", callback, page, mcid, out, 1.0, 50.0);
+		queryEverydayRob(callback, out, page, new BigDecimal(549.9), new BigDecimal(29.9), new BigDecimal(49.9));
+
 	}
 
-	/**
-	 * 9k9绫诲瀷鍟嗗搧瀵瑰簲鐨勬瘡鏃ュ繀鎶�
-	 * 
-	 * @param labName
-	 * @param callback
-	 * @param page
-	 * @param mcid
-	 * @param out
-	 * @param startCouponAmount
-	 * @param endCouponAmount
-	 */
-	public void get9k9ClassToDayRob(String labName, String callback, Integer page, Long mcid, PrintWriter out,
-			Double startCouponAmount, Double endCouponAmount) {
-
-		try {
-
-			List<Label> labs = labelService.selectByTitleCache("labKey", labName);
-			if (labs == null || labs.size() == 0) {
-				JsonUtil.printMode(out, callback, JsonUtil.loadFalseResult("鏆傛棤鏁版嵁"));
-				return;
-			}
-
-			Long labId = labs.get(0).getId();
-			JSONObject jsonGoods = queryEverydayRob(page, labId, 2, startCouponAmount, endCouponAmount);
-
-			if (jsonGoods == null) {
-				JsonUtil.printMode(out, callback, JsonUtil.loadFalseResult(2, "娌℃湁鏇村浜�"));
-				return;
-			}
-
-			JsonUtil.printMode(out, callback, JsonUtil.loadTrueResult(jsonGoods));
-
-		} catch (Exception e) {
-			JsonUtil.printMode(out, callback, JsonUtil.loadFalseResult("鏌ヨ澶辫触"));
-			try {
-				LogHelper.errorDetailInfo(e);
-			} catch (Exception e1) {
-				e1.printStackTrace();
-			}
-		}
-	}
 
 	/**
 	 * 姣忔棩蹇呮姠
@@ -351,70 +264,56 @@
 	 * @return
 	 * @throws Exception
 	 */
-	public JSONObject queryEverydayRob(Integer page, Long labId, int sortField, Double startCouponAmount,
-			Double endCouponAmount) throws Exception {
+	public void queryEverydayRob(String callback, PrintWriter out, Integer page, BigDecimal zkPrice,
+			BigDecimal minQuanPrice, BigDecimal maxQuanPrice) {
 
 		if (page == null)
 			page = 1;
 
-		int pageSize = Constant.PAGE_SIZE;
-
+		// 20 鏉′竴椤佃姹傚埌3椤电粨鏉熶粖鏃ユ柊鍝�
 		if (page > 3) {
-			return null;// 20 鏉′竴椤佃姹傚埌3椤电粨鏉熶粖鏃ユ柊鍝�
+			JsonUtil.printMode(out, callback, JsonUtil.loadFalseResult(2, "娌℃湁鏇村浜�"));
+			return;
 		}
 
-		// 鏍规嵁鏍囩id 鏌ヨ鏁版嵁
-		List<QualityFactory> listQuery = qualityGoodsService.listQueryEverydayRob((page - 1) * pageSize, pageSize, null,
-				labId, sortField, startCouponAmount, endCouponAmount);
-
-		// 鍙彇鍓�50鏉℃暟
-		long count = 50;
-
-		// long count = qualityGoodsService.countQueryEverydayRob(null, labId,
-		// startCouponAmount, endCouponAmount);
-
-		if (listQuery == null || listQuery.size() == 0) {
-			return null;
-		}
-
-		JSONArray array = new JSONArray();
-		Gson gson = JsonUtil.getConvertBigDecimalToStringSubZeroBuilder(new GsonBuilder())
-				.excludeFieldsWithoutExposeAnnotation().setDateFormat("yyyy-MM-dd").create();
-
-		BigDecimal proportion = manageService.getFanLiRate();
-		/* 閬嶅巻鍒楄〃鏁版嵁 */
-		for (QualityFactory selectionGoods : listQuery) {
-
-			TaoBaoGoodsBrief taoBaoGoodsBrief = selectionGoods.getTaoBaoGoodsBrief();
-
-			if (taoBaoGoodsBrief == null) {
-				continue;
+		try {
+			int pageSize = Constant.PAGE_SIZE;
+			List<QualityFactory> listQuery = qualityGoodsService.listQueryEverydayRob((page - 1) * pageSize, pageSize,
+					zkPrice, minQuanPrice, maxQuanPrice);
+			if (listQuery == null || listQuery.size() == 0) {
+				JsonUtil.printMode(out, callback, JsonUtil.loadFalseResult(2, "娌℃湁鏇村浜�"));
+				return;
 			}
 
-			int biz30day = taoBaoGoodsBrief.getBiz30day();
-			if (biz30day >= 10000) {
-				double sales = biz30day;
-				String salesCountMidea = String.format("%.1f", sales / 10000);
-				taoBaoGoodsBrief.setSalesCount(salesCountMidea + "涓�");
+			JSONArray array = new JSONArray();
+			Gson gson = JsonUtil.getConvertBigDecimalToStringSubZeroBuilder(new GsonBuilder())
+					.excludeFieldsWithoutExposeAnnotation().setDateFormat("yyyy-MM-dd").create();
+
+			BigDecimal proportion = manageService.getFanLiRate();
+			for (QualityFactory selectionGoods : listQuery) {
+				TaoBaoGoodsBrief taoBaoGoodsBrief = selectionGoods.getTaoBaoGoodsBrief();
+				if (taoBaoGoodsBrief == null) {
+					continue;
+				}
+				array.add(gson
+						.toJson(TaoBaoUtil.getTaoBaoGoodsBriefExtra(taoBaoGoodsBrief, proportion.toString(), null)));
+			}
+
+			long count = qualityGoodsService.countQueryEverydayRob(zkPrice, minQuanPrice, maxQuanPrice);
+			if (count < 50) {
+				count = listQuery.size();
 			} else {
-				taoBaoGoodsBrief.setSalesCount(biz30day + "");
+				count = 50;
 			}
-
-			// 鏀瑰彉鍥剧墖灏哄
-			String pictUrl = taoBaoGoodsBrief.getPictUrl();
-			if (!StringUtil.isNullOrEmpty(pictUrl) && !pictUrl.contains("320x320")) {
-				taoBaoGoodsBrief.setPictUrl(TbImgUtil.getTBSize320Img(pictUrl));
-			}
-
-			array.add(gson.toJson(TaoBaoUtil.getTaoBaoGoodsBriefExtra(taoBaoGoodsBrief, proportion.toString(), null)));
+			
+			JSONObject data = new JSONObject();
+			data.put("count", count);
+			data.put("result_list", array);
+			JsonUtil.printMode(out, callback, JsonUtil.loadTrueResult(data));
+		} catch (Exception e) {
+			JsonUtil.printMode(out, callback, JsonUtil.loadFalseResult("鏌ヨ澶辫触"));
+			LogHelper.errorDetailInfo(e);
 		}
-
-		JSONObject data = new JSONObject();
-
-		data.put("count", count);
-		data.put("result_list", array);
-
-		return data;
 	}
 
 	/**

--
Gitblit v1.8.0