From c007868c62c7da5c9ce1bf0e77d9e5f8619826e4 Mon Sep 17 00:00:00 2001 From: yujian <yujian@123.com> Date: 星期三, 12 六月 2019 12:24:09 +0800 Subject: [PATCH] 查询默认有效调整 --- fanli/src/main/java/com/yeshi/fanli/service/impl/lable/QualityGoodsServiceImpl.java | 92 +++++++++++++++++++++++++++------------------ 1 files changed, 55 insertions(+), 37 deletions(-) diff --git a/fanli/src/main/java/com/yeshi/fanli/service/impl/lable/QualityGoodsServiceImpl.java b/fanli/src/main/java/com/yeshi/fanli/service/impl/lable/QualityGoodsServiceImpl.java index 34f1eee..3728429 100644 --- a/fanli/src/main/java/com/yeshi/fanli/service/impl/lable/QualityGoodsServiceImpl.java +++ b/fanli/src/main/java/com/yeshi/fanli/service/impl/lable/QualityGoodsServiceImpl.java @@ -1,14 +1,15 @@ package com.yeshi.fanli.service.impl.lable; +import java.math.BigDecimal; import java.util.ArrayList; import java.util.List; import javax.annotation.Resource; -import net.sf.json.JSONArray; - import org.springframework.cache.annotation.Cacheable; import org.springframework.stereotype.Service; +import org.yeshi.utils.JsonUtil; +import org.yeshi.utils.taobao.TbImgUtil; import com.google.gson.Gson; import com.google.gson.GsonBuilder; @@ -16,7 +17,6 @@ import com.yeshi.fanli.dao.mybatis.lable.LabelGoodsMapper; import com.yeshi.fanli.dao.mybatis.lable.QualityFactoryMapper; import com.yeshi.fanli.dao.mybatis.taobao.TaoBaoGoodsBriefMapper; -import com.yeshi.fanli.dao.mybatis.taobao.TaoBaoGoodsBriefRecordMapper; import com.yeshi.fanli.entity.bus.lable.Label; import com.yeshi.fanli.entity.bus.lable.LabelGoods; import com.yeshi.fanli.entity.bus.lable.QualityFactory; @@ -29,8 +29,7 @@ import com.yeshi.fanli.util.StringUtil; import com.yeshi.fanli.util.taobao.TaoBaoUtil; -import org.yeshi.utils.JsonUtil; -import org.yeshi.utils.taobao.TbImgUtil; +import net.sf.json.JSONArray; @Service public class QualityGoodsServiceImpl implements QualityGoodsService { @@ -49,9 +48,6 @@ private TaoBaoGoodsBriefMapper taoBaoGoodsBriefMapper; @Resource private TaoBaoUnionConfigService taoBaoUnionConfigService; - - @Resource - private TaoBaoGoodsBriefRecordMapper taoBaoGoodsBriefRecordMapper; @Resource private TaoBaoClassRelationMapper taoBaoClassRelationMapper; @@ -84,24 +80,13 @@ return qualityFactoryMapper.countQueryByFlashSale(); } - /** - * 浠婃棩蹇呮姠 - 9k9 - * @param start - * @param count - * @param systemCid - * @param labId - * @param sortField - * @return - */ @Override - public List<QualityFactory> listQueryEverydayRob(long start, int count, Long cid, Long labId, Integer sortField,Double startCouponAmount,Double endCouponAmount) { - return qualityFactoryMapper.listQueryEverydayRob(start, count, cid, labId, sortField,startCouponAmount,endCouponAmount); + public List<QualityFactory> listFlashSaleRandGoods() { + return qualityFactoryMapper.listFlashSaleRandGoods(); } - - @Override - public long countQueryEverydayRob(Long cid, Long labId, Double startCouponAmount,Double endCouponAmount) { - return qualityFactoryMapper.countQueryEverydayRob(cid, labId,startCouponAmount,endCouponAmount); - } + + + /** * 灏忛噾棰濇煡璇細9.9/19.9/29.9/49.9 @@ -116,18 +101,20 @@ * @return */ @Override - @Cacheable(value = "quality9K9Cache",key="'listQuerySmallAmount-'+#start+'-'+#key+'-'+#labId+'-'+#cids") - public List<QualityFactory> listQuerySmallAmount(long start, int count, String key, Long labId, String cids) { - return qualityFactoryMapper.listQuery(start, count, key, null, labId, cids,1); + @Cacheable(value = "quality9K9Cache",key="'get9k9ClassGoods-'+#start+'-'+#biz30day+'-'+#zkPrice+'-'+#minQuanPrice+'-'+#maxQuanPrice+'-'+#cids") + public List<QualityFactory> get9k9ClassGoods(long start, int count, Integer biz30day, BigDecimal zkPrice, + BigDecimal minQuanPrice, BigDecimal maxQuanPrice, String cids) { + return qualityFactoryMapper.get9k9ClassGoods(start, count, biz30day, zkPrice, minQuanPrice, maxQuanPrice, cids); } /** * 瀵瑰簲灏忛噾棰濇煡璇細9.9/19.9/29.9/49.9 */ @Override - @Cacheable(value = "quality9K9Cache",key="'countQuerySmallAmount-'+#key+'-'+#labId+'-'+#cids") - public long countQuerySmallAmount(String key, Long labId, String cids) { - return qualityFactoryMapper.countQuery(key, null, labId, cids,1); + @Cacheable(value = "quality9K9Cache",key="'count9k9ClassGoods-'+#biz30day+'-'+#zkPrice+'-'+#minQuanPrice+'-'+#maxQuanPrice+'-'+#cids") + public long count9k9ClassGoods(Integer biz30day, BigDecimal zkPrice, BigDecimal minQuanPrice, + BigDecimal maxQuanPrice, String cids) { + return qualityFactoryMapper.count9k9ClassGoods(biz30day, zkPrice, minQuanPrice, maxQuanPrice, cids); } /** @@ -244,15 +231,15 @@ @Override public List<QualityFactory> listRecommendBykey(long start, int count, String key, Integer hasQuan, - Integer userType, Double startprice, Double endprice, Integer sort) { + Integer userType, Double startprice, Double endprice, Double startTkRate, Double endTkRate, Integer sort) { return qualityFactoryMapper.listRecommendBykey(start, count, key, hasQuan, userType, - startprice, endprice, sort); + startprice, endprice, startTkRate, endTkRate, sort); } @Override public long countRecommendBykey(String key, Integer hasQuan, Integer userType, - Double startprice, Double endprice) { - return qualityFactoryMapper.countRecommendBykey(key, hasQuan, userType, startprice, endprice); + Double startprice, Double endprice, Double startTkRate, Double endTkRate) { + return qualityFactoryMapper.countRecommendBykey(key, hasQuan, userType, startprice, endprice, startTkRate, endTkRate); } @@ -260,8 +247,8 @@ * 棣栭〉鏈�搴曢儴@鍟嗗搧淇℃伅娴� */ @Override - @Cacheable(value = "qualityCache",key="'listQueryToRecommend-'+#start+'-'+#proportion+'-'+#fcRate") - public JSONArray getRecommendToIndex(long start, int count, String proportion, String fcRate) { + @Cacheable(value = "qualityCache",key="'listQueryToRecommend-'+#start+'-'+#proportion") + public JSONArray getRecommendToIndex(long start, int count, String proportion) { // 杩斿埄閲戦2鍏冧互涓婏紱 Integer commision = 2; @@ -311,7 +298,7 @@ taoBaoGoodsBrief.setPictUrl(TbImgUtil.getTBSize320Img(pictUrl)); } - array.add(gson.toJson(TaoBaoUtil.getTaoBaoGoodsBriefExtra(taoBaoGoodsBrief, proportion, fcRate, null))); + array.add(gson.toJson(TaoBaoUtil.getTaoBaoGoodsBriefExtra(taoBaoGoodsBrief, proportion, null))); } return array; @@ -376,4 +363,35 @@ return qualityFactoryMapper.listQueryBylabIDs(0, 10, listId, goodsBrief.getId(),qualityFactory.getSystemCid()); } + + @Override + public List<QualityFactory> listFreeGoods(long start, int count) { + return qualityFactoryMapper.listFreeGoods(start, count); + } + + @Override + public long countFreeGoods() { + return qualityFactoryMapper.countFreeGoods(); + } + + @Override + public List<QualityFactory> listByShopId(long start, int count, Long shopId) { + return qualityFactoryMapper.listByShopId(start, count, shopId); + } + + @Override + public long countByShopId(Long shopId) { + return qualityFactoryMapper.countByShopId(shopId); + } + + @Override + public List<QualityFactory> listQueryEverydayRob(long start, int count, BigDecimal zkPrice, + BigDecimal minQuanPrice, BigDecimal maxQuanPrice) { + return qualityFactoryMapper.listQueryEverydayRob(start, count, zkPrice, minQuanPrice, maxQuanPrice); + } + + @Override + public long countQueryEverydayRob(BigDecimal zkPrice, BigDecimal minQuanPrice, BigDecimal maxQuanPrice) { + return qualityFactoryMapper.countQueryEverydayRob(zkPrice, minQuanPrice, maxQuanPrice); + } } -- Gitblit v1.8.0