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