package com.yeshi.fanli.service.impl.lable;
|
|
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 com.google.gson.Gson;
|
import com.google.gson.GsonBuilder;
|
import com.yeshi.fanli.dao.mybatis.TaoBaoClassRelationMapper;
|
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.QualityFactory;
|
import com.yeshi.fanli.entity.taobao.TaoBaoGoodsBrief;
|
import com.yeshi.fanli.service.inter.goods.TaoBaoGoodsBriefService;
|
import com.yeshi.fanli.service.inter.lable.LabelService;
|
import com.yeshi.fanli.service.inter.lable.QualityGoodsService;
|
import com.yeshi.fanli.service.inter.taobao.TaoBaoUnionConfigService;
|
import com.yeshi.fanli.util.RedisManager;
|
import com.yeshi.fanli.util.StringUtil;
|
import com.yeshi.fanli.util.taobao.TaoBaoUtil;
|
import org.yeshi.utils.JsonUtil;
|
import org.yeshi.utils.taobao.TbImgUtil;
|
|
@Service
|
public class QualityGoodsServiceImpl implements QualityGoodsService {
|
|
@Resource
|
private RedisManager redisManager;
|
@Resource
|
private QualityFactoryMapper qualityFactoryMapper;
|
@Resource
|
private TaoBaoGoodsBriefService taoBaoGoodsBriefService;
|
@Resource
|
private LabelGoodsMapper labelGoodsMapper;
|
@Resource
|
private LabelService labelService;
|
@Resource
|
private TaoBaoGoodsBriefMapper taoBaoGoodsBriefMapper;
|
@Resource
|
private TaoBaoUnionConfigService taoBaoUnionConfigService;
|
|
@Resource
|
private TaoBaoGoodsBriefRecordMapper taoBaoGoodsBriefRecordMapper;
|
|
@Resource
|
private TaoBaoClassRelationMapper taoBaoClassRelationMapper;
|
|
|
|
@Override
|
@Cacheable(value = "qualityCache",key="'listQueryByCouponAmount-'+#start+'-'+#key+'-'+#endAmount+'-'+#startPropor")
|
public List<QualityFactory> listQueryByCouponAmount(long start, int count, Integer key,
|
Integer endAmount, Integer startPropor){
|
return qualityFactoryMapper.listQueryByCouponAmount(start, count, key, endAmount, startPropor);
|
}
|
|
@Override
|
@Cacheable(value = "qualityCache",key="'countQueryByCouponAmount-'+#key+'-'+#endAmount+'-'+#startPropor")
|
public long countQueryByCouponAmount(Integer key, Integer endAmount, Integer startPropor){
|
return qualityFactoryMapper.countQueryByCouponAmount(key, endAmount, startPropor);
|
}
|
|
|
@Override
|
@Cacheable(value = "qualityCache",key="'listQueryByFlashSale-'+#start")
|
public List<QualityFactory> listQueryByFlashSale(long start, int count) {
|
return qualityFactoryMapper.listQueryByFlashSale(start, count);
|
}
|
|
@Override
|
//@Cacheable(value = "qualityCache",key="'countQueryByFlashSale-'")
|
public long countQueryByFlashSale() {
|
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);
|
}
|
|
@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
|
*
|
* @param start
|
* @param count
|
* @param key
|
* @param classId
|
* 分类id
|
* @param labId
|
* 标签id
|
* @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);
|
}
|
|
/**
|
* 对应小金额查询：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);
|
}
|
|
/**
|
* 查询标签
|
*
|
* @param start
|
* @param count
|
* @param key
|
* @param labId
|
* @return
|
*/
|
public List<QualityFactory> listQueryByKeyAndlabIDs(long start, int count,String key, List<Long> listId, Integer sort,
|
Long systemCid, Integer hasQuan, Integer userType, Integer biz30day,Integer startprice, Integer endprice) {
|
return qualityFactoryMapper.listQueryByKeyAndlabIDs(start, count, key, listId, sort,systemCid, hasQuan, userType,
|
biz30day, startprice, endprice);
|
}
|
|
|
public long countQueryKeyAndlabIDs(String key, List<Long> listId, Long systemCid, Integer hasQuan, Integer userType,
|
Integer biz30day,Integer startprice, Integer endprice) {
|
return qualityFactoryMapper.countQueryKeyAndlabIDs(key, listId,systemCid, hasQuan, userType, biz30day,
|
startprice, endprice);
|
}
|
|
/**
|
* 关键词搜索
|
*
|
* @param start
|
* @param count
|
* @param key
|
* @param labId
|
* @return
|
*/
|
@Override
|
public List<QualityFactory> listQueryByKey(long start, int count, String key, Integer sort,Long systemCid,
|
Integer hasQuan, Integer userType, Integer biz30day,Integer startprice, Integer endprice) {
|
return qualityFactoryMapper.listQueryByKey(start, count, key, sort, systemCid,hasQuan, userType, biz30day,
|
startprice, endprice);
|
}
|
|
public long countQueryByKey(String key, Long systemCid,Integer hasQuan, Integer userType,
|
Integer biz30day,Integer startprice, Integer endprice) {
|
|
return qualityFactoryMapper.countQueryByKey(key, systemCid,hasQuan, userType, biz30day,
|
startprice, endprice);
|
}
|
|
/**
|
* 一级分类查询精选库数据
|
*
|
* @param start
|
* @param count
|
* @param key
|
* @param labId
|
* @return
|
*/
|
@Override
|
@Cacheable(value = "qualityCache",key="'listQueryByClassId-'+#start+'-'+#cid")
|
public List<QualityFactory> listQueryByClassId(long start, int count, Long cid) {
|
return qualityFactoryMapper.listQuery(start, count, null, cid, null, null, 1);
|
}
|
|
@Override
|
@Cacheable(value = "qualityCache",key="'countQueryClassId-'+#cid")
|
public long countQueryClassId(Long cid) {
|
return qualityFactoryMapper.countQuery(null, cid, null, null, 1);
|
}
|
|
|
@Override
|
@Cacheable(value = "qualityCache",key="'listQueryByRebateAmount-'+#start+'-'+#proportion+'-'+#endAmount+'-'+#endAmount+'-'+#tkRate")
|
public List<QualityFactory> listQueryByRebateAmount(long start, int count,String proportion,
|
Integer startAmount, Integer endAmount, double tkRate){
|
return qualityFactoryMapper.listQueryByRebateAmount(start, count, proportion, startAmount, endAmount, tkRate);
|
}
|
|
@Override
|
@Cacheable(value = "qualityCache",key="'countQueryByRebateAmount-'+#proportion+'-'+#endAmount+'-'+#endAmount+'-'+#tkRate")
|
public long countQueryByRebateAmount(String proportion, Integer startAmount, Integer endAmount, double tkRate){
|
return qualityFactoryMapper.countQueryByRebateAmount(proportion, startAmount, endAmount, tkRate);
|
}
|
|
|
|
@Override
|
//@Cacheable(value = "qualityCache",key="'queryToCouponColumn-'+#start")
|
@Cacheable(value = "taoBaoCouponCache", key = "'queryToCouponColumn'+#start")
|
public List<QualityFactory> queryToCouponColumn(long start, int count){
|
return qualityFactoryMapper.queryToCouponColumn(start, count);
|
}
|
|
@Override
|
//@Cacheable(value = "qualityCache",key="'countQueryToCouponColumn'")
|
@Cacheable(value = "taoBaoCouponCache", key = "'countQueryToCouponColumn'")
|
public long countQueryToCouponColumn(){
|
return qualityFactoryMapper.countQueryToCouponColumn();
|
}
|
|
|
/**
|
* 首页最底部@商品信息流
|
*/
|
@Override
|
public List<QualityFactory> listRecommend(long start, int count, Double proportion, Integer commision, Integer couponAmount,
|
double tkRate, Double couponRatio) {
|
return qualityFactoryMapper.listRecommendToIndex(start, count, proportion, commision, couponAmount, tkRate, couponRatio);
|
}
|
|
@Override
|
public long countRecommend(Double proportion, Integer commision, Integer couponAmount, double tkRate, Double couponRatio) {
|
return qualityFactoryMapper.countRecommendToIndex(proportion, commision, couponAmount, tkRate, couponRatio);
|
}
|
|
@Override
|
public List<QualityFactory> listRecommendBykey(long start, int count, String key) {
|
return qualityFactoryMapper.listRecommendBykey(start, count, key);
|
}
|
|
@Override
|
public long countRecommendBykey(String key) {
|
return qualityFactoryMapper.countRecommendBykey(key);
|
}
|
|
|
/**
|
* 首页最底部@商品信息流
|
*/
|
@Override
|
@Cacheable(value = "qualityCache",key="'listQueryToRecommend-'+#start+'-'+#proportion+'-'+#fcRate")
|
public JSONArray getRecommendToIndex(long start, int count, String proportion, String fcRate) {
|
|
// 返利金额2元以上；
|
Integer commision = 2;
|
// 优惠券面额高于5元以上
|
Integer couponAmount = 5;
|
// 佣金比例高的:5%以上；
|
double tkRate = 5.0;
|
// 优惠率高于10%以上（优惠率=优惠券面额/商品在售价*100%）
|
Double couponRatio = 10.0;
|
|
Double pop = 50.0;
|
if (!StringUtil.isNullOrEmpty(proportion)) {
|
pop = Double.parseDouble(proportion);
|
}
|
|
List<QualityFactory> listQuery =
|
listRecommend(start, count, pop, commision, couponAmount, tkRate, couponRatio);
|
|
if (listQuery == null || listQuery.size() == 0) {
|
return null;
|
}
|
|
|
JSONArray array = new JSONArray();
|
Gson gson = JsonUtil.getConvertBigDecimalToStringSubZeroBuilder(new GsonBuilder()).create();
|
//遍历列表数据
|
for (QualityFactory quality : listQuery) {
|
|
TaoBaoGoodsBrief taoBaoGoodsBrief = quality.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(count + "");
|
}
|
|
// 改变图片尺寸
|
String pictUrl = taoBaoGoodsBrief.getPictUrl();
|
if (!StringUtil.isNullOrEmpty(pictUrl) && !pictUrl.contains("320x320")) {
|
taoBaoGoodsBrief.setPictUrl(TbImgUtil.getTBSize320Img(pictUrl));
|
}
|
|
array.add(gson.toJson(TaoBaoUtil.getTaoBaoGoodsBriefExtra(taoBaoGoodsBrief, proportion, fcRate, null)));
|
}
|
|
return array;
|
}
|
|
@Override
|
@Cacheable(value = "qualityCache",key="'countRecommendToIndex-'+#proportion")
|
public long countRecommendToIndex(String proportion) {
|
|
// 返利金额2元以上；
|
Integer commision = 2;
|
// 优惠券面额高于5元以上
|
Integer couponAmount = 5;
|
// 佣金比例高的:5%以上；
|
double tkRate = 5.0;
|
// 优惠率高于10%以上（优惠率=优惠券面额/商品在售价*100%）
|
Double couponRatio = 10.0;
|
|
Double pop = 50.0;
|
if (!StringUtil.isNullOrEmpty(proportion)) {
|
pop = Double.parseDouble(proportion);
|
}
|
|
return countRecommend(pop, commision, couponAmount, tkRate, couponRatio);
|
}
|
|
|
}
|
