下面我们就来编写查询的Service方法
有人可能会问,我们不是有已经有查询方法了吗?前面几篇博客我也有写到一些查询方法,但是你要知道的是,前面的查询方法,比如商品分类的查询方法,品牌分类的查询方法,这些查询方法都是局部的查询方法,我们这是编写的查询方法是整个商品商城的查询方法,也就是你输入一个关键词,他会查询对应的商品信息
首先我们要引进这些客户端,把他们在service里面封装起来
下面可以看到我们的返回值是Goods,所以我们要new一个Goods,这个Goods我们之前在编写索引的时候写的,它是一个查询的实体类。因为我们查询最终要把所有商品信息返回出去,所以需要用到这个Goods。
因为我们接触到的参数是spu,所以我们需要把spu里面的全部信息一个个导入到goods里面去,
在这里你可以看到我们需要拼接一个all字段,为什么我们需要凭借这个字段呢?因为我们在搜索商品的时候,如我们要搜索苹果手机,那么具体是苹果多少的手机?我们可能只记得他是苹果这个品牌,也可能只记得他的分类名称,可能只记得他的介绍,所以在搜索的时候只会输入上面的一种信息,所以我们要做好这个准备,也就是把这三个分成三个字段,如果用户搜索到这里面的一个字段,就给他返回相关的信息。
因为代码量太多,下面直接写上代码和相对应的解释
package com.leyou.search.service;
import com.fasterxml.jackson.core.type.TypeReference;
import com.leyou.common.enums.ExceptionEnum;
import com.leyou.common.exception.LyException;
import com.leyou.common.utils.JsonUtils;
import com.leyou.common.utils.NumberUtils;
import com.leyou.common.vo.PageResult;
import com.leyou.item.pojo.*;
import com.leyou.search.client.BrandClient;
import com.leyou.search.client.CategoryClient;
import com.leyou.search.client.GoodsClient;
import com.leyou.search.client.SpecificationClient;
import com.leyou.search.pojo.Goods;
import com.leyou.search.pojo.SearchRequest;
import com.leyou.search.pojo.SearchResult;
import com.leyou.search.repository.GoodsRepository;
import lombok.extern.slf4j.Slf4j;
import org.apache.commons.lang.StringUtils;
import org.elasticsearch.index.query.BoolQueryBuilder;
import org.elasticsearch.index.query.QueryBuilder;
import org.elasticsearch.index.query.QueryBuilders;
import org.elasticsearch.search.aggregations.AggregationBuilders;
import org.elasticsearch.search.aggregations.Aggregations;
import org.elasticsearch.search.aggregations.bucket.terms.LongTerms;
import org.elasticsearch.search.aggregations.bucket.terms.StringTerms;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.data.domain.PageRequest;
import org.springframework.data.elasticsearch.core.ElasticsearchTemplate;
import org.springframework.data.elasticsearch.core.aggregation.AggregatedPage;
import org.springframework.data.elasticsearch.core.query.FetchSourceFilter;
import org.springframework.data.elasticsearch.core.query.NativeSearchQueryBuilder;
import org.springframework.stereotype.Service;
import org.springframework.util.CollectionUtils;
import java.util.*;
import java.util.stream.Collectors;
/**
* @Author Hwj
* @Date 2019/4/12 16:22
* @Version 1.0.0
**/
@Slf4j
@Service
public class SearchService {
@Autowired
private CategoryClient categoryClient;
@Autowired
private BrandClient brandClient;
@Autowired
private GoodsClient goodsClient;
@Autowired
private SpecificationClient specificationClient;
@Autowired
private ElasticsearchTemplate template;
@Autowired
private GoodsRepository repository;
public Goods buildGoods(Spu spu){
Long spuId = spu.getId();
//查询商品分类
List<Category> categories = categoryClient.queryCategoryByIds(Arrays.asList(spu.getCid1(), spu.getCid2(), spu.getCid3()));
if(CollectionUtils.isEmpty(categories)){
throw new LyException(ExceptionEnum.CATEGORY_NOT_FOUND);
}
List<String> names = categories.stream().map(Category::getName).collect(Collectors.toList());
//查询品牌
Brand brand = brandClient.queryBrandById(spu.getBrandId());
if(brand == null){
throw new LyException(ExceptionEnum.BRAND_NOT_FOUND);
}
//搜索字段
String all=spu.getTitle()+ StringUtils.join(names," ")+ brand.getName();
//查询sku
List<Sku> skuList = goodsClient.querySkuBySpuId(spu.getId());
if(CollectionUtils.isEmpty(skuList)){
throw new LyException(ExceptionEnum.GOODS_SKU_NOT_FOUND);
}
//对sku进行处理
List<Map<String,Object>> skus=new ArrayList<>();
//价格集合
Set<Long> priceList = new HashSet<>();
for (Sku sku : skuList) {
HashMap<String, Object> map = new HashMap<>();
map.put("id",sku.getId());
map.put("title",sku.getTitle());
map.put("price",sku.getPrice());
map.put("images",StringUtils.substringBefore(sku.getImages(),","));
skus.add(map);
//处理价格
priceList.add(sku.getPrice());
}
//查询规格参数
List<SpecParam> params = specificationClient.querySpecParamList(null, spu.getCid3(), true);
if(CollectionUtils.isEmpty(params)){
throw new LyException(ExceptionEnum.SPEC_PARAM_NOT_FOUND);
}
//查询商品详情
SpuDetail spuDetail = goodsClient.queryDetailById(spuId);
//获取通用规格参数
Map<Long, String> genericSpec = JsonUtils.toMap(spuDetail.getGenericSpec(), Long.class, String.class);
//获取特有规格参数
Map<Long, List<String>> specialSpec = JsonUtils
.nativeRead(spuDetail.getSpecialSpec(), new TypeReference<Map<Long, List<String>>>() {});
//规格参数,key是规格参数的名字,值是规格参数的值
HashMap<String, Object> specs = new HashMap<>();
for (SpecParam param : params) {
//规格名称
String key = param.getName();
Object value="";
//判断是否是通用规格
if(param.getGeneric()){
value = genericSpec.get(param.getId());
//判断是否是数值类型
if(param.getNumeric()){
//处理成段
value = chooseSegment(value.toString(),param);
}
}else{
value = specialSpec.get(param.getId());
}
//存入map
specs.put(key,value);
}
//构架goods对象
Goods goods = new Goods();
goods.setBrandId(spu.getBrandId());
goods.setCid1(spu.getCid1());
goods.setCid2(spu.getCid2());
goods.setCid3(spu.getCid3());
goods.setCreateTime(spu.getCreateTime());
goods.setId(spuId);
goods.setAll(all);// 搜索字段,包含标题,分类,品牌,规格等
goods.setPrice(priceList);// 所有sku的价格集合
goods.setSkus(JsonUtils.toString(skus));// 所有sku的集合的json格式
goods.setSpecs(specs);// 所有的可搜索的规格参数
goods.setSubTitle(spu.getSubTitle());
return goods;
}
private String chooseSegment(String value, SpecParam p) {
double val = NumberUtils.toDouble(value);
String result = "其它";
// 保存数值段
for (String segment : p.getSegments().split(",")) {
String[] segs = segment.split("-");
// 获取数值范围
double begin = NumberUtils.toDouble(segs[0]);
double end = Double.MAX_VALUE;
if (segs.length == 2) {
end = NumberUtils.toDouble(segs[1]);
}
// 判断是否在范围内
if (val >= begin && val < end) {
if (segs.length == 1) {
result = segs[0] + p.getUnit() + "以上";
} else if (begin == 0) {
result = segs[1] + p.getUnit() + "以下";
} else {
result = segment + p.getUnit();
}
break;
}
}
return result;
}
public PageResult<Goods> search(SearchRequest request) {
int page = request.getPage() - 1; // elasicsearch默认page是从0开始
int size = request.getSize();
// 创建查询构建器
NativeSearchQueryBuilder queryBuilder = new NativeSearchQueryBuilder();
// 0.结果过滤
queryBuilder.withSourceFilter(new FetchSourceFilter(new String[]{"id", "skus", "subTitle"}, null));
// 1.分页
queryBuilder.withPageable(PageRequest.of(page, size));
// 2.过滤
QueryBuilder basicQuery = bulidBasicQuery(request);
if(basicQuery!=null){
System.out.println();
}
queryBuilder.withQuery(basicQuery );
//3.聚合分类和品牌
String categoryAggName = "category_agg";
String brandAggName = "brand_agg";
//3.1 对商品分类进行聚合
queryBuilder.addAggregation(AggregationBuilders.terms(categoryAggName).field("cid3"));
//3.2 对品牌进行聚合
queryBuilder.addAggregation(AggregationBuilders.terms(brandAggName).field("brandId"));
// 4.查询
AggregatedPage<Goods> result = template.queryForPage(queryBuilder.build(), Goods.class);
// 5.解析结果
//5.1解析分页结果
long total= result.getTotalElements();
long totalPage = result.getTotalPages();
List<Goods> goodsList = result.getContent();
//5.2解析聚合结果
Aggregations aggs = result.getAggregations();
List<Category> categories = parseCategoryAgg(aggs.get(categoryAggName));
List<Brand> brands = parseBrandAgg(aggs.get(brandAggName));
// 6.完成规格参数聚合
// 判断商品分类数量,看是否需要对规格参数进行聚合
List<Map<String, Object>> specs = null;
if (categories != null && categories.size() == 1) {
// 商品分类存在且数量为1,可以聚合规格参数
specs = buildSpecficationAgg(categories.get(0).getId(), basicQuery);
}
// 返回结果
return new SearchResult(total,totalPage,goodsList,categories,brands,specs);
}
/**
* 基本查询
* @param request
* @return
*/
private QueryBuilder bulidBasicQuery(SearchRequest request) {
BoolQueryBuilder queryBuilder = QueryBuilders.boolQuery();
// 基本查询条件
queryBuilder.must(QueryBuilders.matchQuery("all", request.getKey()));
// 过滤条件构建器
BoolQueryBuilder filterQueryBuilder = QueryBuilders.boolQuery();
// 整理过滤条件
Map<String, String> filter = request.getFilter();
for (Map.Entry<String, String> entry : filter.entrySet()) {
String key = entry.getKey();
String value = entry.getValue();
// 商品分类和品牌要特殊处理
if (key != "cid3" && key != "brandId") {
key = "specs." + key + ".keyword";
}
// 字符串类型,进行term查询
filterQueryBuilder.must(QueryBuilders.termQuery(key, value));
}
// 添加过滤条件
queryBuilder.filter(filterQueryBuilder);
return queryBuilder;
}
private List<Map<String,Object>> buildSpecficationAgg(Long cid, QueryBuilder basicQuery) {
List<Map<String,Object>> specs = new ArrayList<>();
// 1.查询需要聚合的规格参数
List<SpecParam> params = specificationClient.querySpecParamList(null,cid,true);
//2.聚合
NativeSearchQueryBuilder queryBuilder = new NativeSearchQueryBuilder();
//2.1带上查询条件
queryBuilder.withQuery(basicQuery);
//2.2聚合
for (SpecParam param : params) {
String name = param.getName();
queryBuilder.addAggregation(AggregationBuilders.terms(name).field("specs." + name + ".keyword"));
}
//3.获取结果
AggregatedPage<Goods> result = template.queryForPage(queryBuilder.build(), Goods.class);
//4.解析结果
Aggregations aggs = result.getAggregations();
for (SpecParam param : params) {
//规格参数名称
String name= param.getName();
StringTerms terms= aggs.get(name);
//准备map
HashMap<String, Object> map = new HashMap<>();
map.put("k",name);
map.put("options",terms.getBuckets()
.stream().map(b -> b.getKeyAsString()).collect(Collectors.toList()));
specs.add(map);
}
return specs;
}
// 解析品牌聚合结果
private List<Brand> parseBrandAgg(LongTerms terms) {
try {
List<Long> ids = terms.getBuckets()
.stream().map(b -> b.getKeyAsNumber().longValue())
.collect(Collectors.toList());
List<Brand> brands = brandClient.queryBrandByIds(ids);
return brands;
} catch (Exception e) {
log.error("[搜索服务]查询品牌异常", e);
return null;
}
}
// 解析商品分类聚合结果
private List<Category> parseCategoryAgg(LongTerms terms) {
try {
List<Long> ids = terms.getBuckets().stream()
.map(b -> b.getKeyAsNumber().longValue())
.collect(Collectors.toList());
List<Category> categories = categoryClient.queryCategoryByIds(ids);
return categories;
} catch (Exception e) {
log.error("[搜索服务]查询分类异常", e);
return null;
}
}
/**
* 创建或更新索引
* @param spuId
*/
public void createOrUpdateIndex(Long spuId) {
//查询spu
Spu spu = goodsClient.querySpuById(spuId);
//如果商品存在则存入索引库
if(spu!=null){
//构建goods
Goods goods = buildGoods(spu);
//存入索引库
repository.save(goods);
}
}
/**
* 删除索引
* @param spuId
*/
public void deleteIndex(Long spuId) {
//从索引库中删除
repository.deleteById(spuId);
}
}