package com.alatus.mall.product.service.impl; import com.alatus.mall.product.service.CategoryBrandRelationService; import com.alatus.mall.product.vo.SubCatalogVo; import com.alibaba.fastjson.JSON; import com.alibaba.fastjson.TypeReference; import org.apache.commons.lang.StringUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.data.redis.core.StringRedisTemplate; import org.springframework.data.redis.core.script.DefaultRedisScript; import org.springframework.stereotype.Service; import java.util.*; import java.util.concurrent.TimeUnit; import java.util.stream.Collectors; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.alatus.common.utils.PageUtils; import com.alatus.common.utils.Query; import com.alatus.mall.product.dao.CategoryDao; import com.alatus.mall.product.entity.CategoryEntity; import com.alatus.mall.product.service.CategoryService; import org.springframework.transaction.annotation.Transactional; @Service("categoryService") public class CategoryServiceImpl extends ServiceImpl<CategoryDao, CategoryEntity> implements CategoryService { @Autowired private CategoryBrandRelationService categoryBrandRelationService; @Autowired private StringRedisTemplate redisTemplate; @Override public PageUtils queryPage(Map<String, Object> params) { IPage<CategoryEntity> page = this.page( new Query<CategoryEntity>().getPage(params), new QueryWrapper<CategoryEntity>() ); return new PageUtils(page); } @Override public List<CategoryEntity> listWithTree() { // 查出所有分类 List<CategoryEntity> entities = baseMapper.selectList(null); // 组装父子的树形结构 // 找到一级分类 List<CategoryEntity> levelMenuOne = entities.stream().filter(categoryEntity -> categoryEntity.getParentCid() == 0 ).map((menu) -> { menu.setChildren(getChildren(menu,entities)); return menu; }).sorted((menu1,menu2) -> { return (menu1.getSort()==null?0:menu1.getSort()) - (menu2.getSort()==null?0:menu2.getSort()); }).collect(Collectors.toList()); return levelMenuOne; } @Override public void removeMenuByIds(List<Long> list) { // 检查当前删除的菜单,是否被别的地方引用 baseMapper.deleteBatchIds(list); } @Override public Long[] findCatelogPath(Long catelogId) { List<Long> paths = new ArrayList<>(); List<Long> parentPath = findParent(catelogId, paths); Collections.reverse(parentPath); return (Long[])parentPath.toArray(new Long[parentPath.size()]); } // 级联更新所有数据 @Override @Transactional public void updateCascade(CategoryEntity category) { this.updateById(category); categoryBrandRelationService.updateCategory(category.getCatId(),category.getName()); } @Override public List<CategoryEntity> getLevelCategories(Integer catLevel) { return baseMapper.selectList(new QueryWrapper<CategoryEntity>().eq("cat_level", catLevel)); } private Map<String, List<SubCatalogVo>> getCatalogJsonFromDb(){ // 加入缓存机制 // 缓存中我们一律保存JSON字符串,因为JSON本身也是跨语言跨平台的 String catalogJSON = redisTemplate.opsForValue().get("catalogJSON"); if(StringUtils.isEmpty(catalogJSON)){ // 缓存中没有 List<CategoryEntity> categories = baseMapper.selectList(null); // 所有一级分类 List<CategoryEntity> levelCategories = getParentCid(categories,0L);; // 封装数据 Map<String, List<SubCatalogVo>> subCatalogVosMap = levelCategories.stream().collect(Collectors.toMap(k -> k.getCatId().toString(),v -> { List<CategoryEntity> entities = getParentCid(categories,v.getCatId()); List<SubCatalogVo> subCatalogVos = null; if(entities!=null&&!entities.isEmpty()){ subCatalogVos = entities.stream().map(item -> { // 找三级分类 List<CategoryEntity> inCategories = getParentCid(categories,item.getCatId()); SubCatalogVo subCatalogVo = new SubCatalogVo(v.getCatId().toString(),null, item.getCatId().toString(), item.getName()); if(inCategories!=null&&!inCategories.isEmpty()){ // 封装成指定格式 List<SubCatalogVo.InCatalogVo> inCatalogVos = inCategories.stream().map(inCategory -> { SubCatalogVo.InCatalogVo inCatalogVo = new SubCatalogVo.InCatalogVo(item.getCatId().toString(),inCategory.getCatId().toString(),inCategory.getName()); return inCatalogVo; }).collect(Collectors.toList()); subCatalogVo.setCatalog3List(inCatalogVos); } return subCatalogVo; }).collect(Collectors.toList()); } return subCatalogVos; })); // 查到的数据保存到缓存中先 String jsonString = JSON.toJSONString(subCatalogVosMap); // 查到的数据放入缓存,将这个对象我们转为JSON redisTemplate.opsForValue().set("catalogJSON",jsonString,1, TimeUnit.DAYS); return subCatalogVosMap; } return JSON.parseObject(catalogJSON,new TypeReference<Map<String, List<SubCatalogVo>>>(){}); } // TODO 堆外内存溢出,原因是lettuce使用了netty做网络通信,lettuce的bug导致了我们的堆外内存溢出 @Override public Map<String, List<SubCatalogVo>> getCatalogJson() { String uuid = UUID.randomUUID().toString(); //加锁采用setNX加过期时间的方式保证原子性 Boolean lock = redisTemplate.opsForValue().setIfAbsent("lock", uuid, 3000, TimeUnit.SECONDS); if(lock){ Map<String, List<SubCatalogVo>> catalogJsonFromDb = null; try{ catalogJsonFromDb = getCatalogJsonFromDb(); } finally { // LUA脚本解锁 String script = "if redis.call('get', KEYS[1]) == ARGV[1] then\n" + " return redis.call('del', KEYS[1])\n" + "else\n" + " return nil\n" + "end\n"; // 删除锁用LUA脚本保持原子性 redisTemplate.execute(new DefaultRedisScript<Long>(script, Long.class), Arrays.asList("lock"), uuid); } return catalogJsonFromDb; } else{ // TODO 加锁失败,休眠后再次尝试 try { Thread.sleep(333); } catch (InterruptedException e) { throw new RuntimeException(e); } return getCatalogJson(); } } private List<CategoryEntity> getParentCid(List<CategoryEntity> categories,Long catId) { return categories.stream().filter(item -> item.getParentCid() == catId).collect(Collectors.toList()); } private List<Long> findParent(Long catelogId,List<Long> paths){ // 查出当前分类的ID // 收集当前节点ID paths.add(catelogId); CategoryEntity id = this.getById(catelogId); if(id.getParentCid() != 0){ // 递归查找,每次都从父节点获取 findParent(id.getParentCid(),paths); } return paths; } // 递归查找所有菜单的子菜单 private List<CategoryEntity> getChildren(CategoryEntity root,List<CategoryEntity> all){ List<CategoryEntity> children = all.stream().filter(categoryEntity -> { return categoryEntity.getParentCid() == root.getCatId(); }).map(categoryEntity -> { categoryEntity.setChildren(getChildren(categoryEntity,all)); return categoryEntity; }).sorted((menu1,menu2) ->{ return (menu1.getSort()==null?0:menu1.getSort()) - (menu2.getSort()==null?0:menu2.getSort()); }).collect(Collectors.toList()); return children; } }
package com.alatus.mall.product.service.impl; import com.alatus.mall.product.service.CategoryBrandRelationService; import com.alatus.mall.product.vo.SubCatalogVo; import com.alibaba.fastjson.JSON; import com.alibaba.fastjson.TypeReference; import org.apache.commons.lang.StringUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.data.redis.core.StringRedisTemplate; import org.springframework.data.redis.core.script.DefaultRedisScript; import org.springframework.stereotype.Service; import java.util.*; import java.util.concurrent.TimeUnit; import java.util.stream.Collectors; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.alatus.common.utils.PageUtils; import com.alatus.common.utils.Query; import com.alatus.mall.product.dao.CategoryDao; import com.alatus.mall.product.entity.CategoryEntity; import com.alatus.mall.product.service.CategoryService; import org.springframework.transaction.annotation.Transactional; @Service("categoryService") public class CategoryServiceImpl extends ServiceImpl<CategoryDao, CategoryEntity> implements CategoryService { @Autowired private CategoryBrandRelationService categoryBrandRelationService; @Autowired private StringRedisTemplate redisTemplate; @Override public PageUtils queryPage(Map<String, Object> params) { IPage<CategoryEntity> page = this.page( new Query<CategoryEntity>().getPage(params), new QueryWrapper<CategoryEntity>() ); return new PageUtils(page); } @Override public List<CategoryEntity> listWithTree() { // 查出所有分类 List<CategoryEntity> entities = baseMapper.selectList(null); // 组装父子的树形结构 // 找到一级分类 List<CategoryEntity> levelMenuOne = entities.stream().filter(categoryEntity -> categoryEntity.getParentCid() == 0 ).map((menu) -> { menu.setChildren(getChildren(menu,entities)); return menu; }).sorted((menu1,menu2) -> { return (menu1.getSort()==null?0:menu1.getSort()) - (menu2.getSort()==null?0:menu2.getSort()); }).collect(Collectors.toList()); return levelMenuOne; } @Override public void removeMenuByIds(List<Long> list) { // 检查当前删除的菜单,是否被别的地方引用 baseMapper.deleteBatchIds(list); } @Override public Long[] findCatelogPath(Long catelogId) { List<Long> paths = new ArrayList<>(); List<Long> parentPath = findParent(catelogId, paths); Collections.reverse(parentPath); return (Long[])parentPath.toArray(new Long[parentPath.size()]); } // 级联更新所有数据 @Override @Transactional public void updateCascade(CategoryEntity category) { this.updateById(category); categoryBrandRelationService.updateCategory(category.getCatId(),category.getName()); } @Override public List<CategoryEntity> getLevelCategories(Integer catLevel) { return baseMapper.selectList(new QueryWrapper<CategoryEntity>().eq("cat_level", catLevel)); } private Map<String, List<SubCatalogVo>> getCatalogJsonFromDb(){ // 加入缓存机制 // 缓存中我们一律保存JSON字符串,因为JSON本身也是跨语言跨平台的 String catalogJSON = redisTemplate.opsForValue().get("catalogJSON"); if(StringUtils.isEmpty(catalogJSON)){ // 缓存中没有 List<CategoryEntity> categories = baseMapper.selectList(null); // 所有一级分类 List<CategoryEntity> levelCategories = getParentCid(categories,0L);; // 封装数据 Map<String, List<SubCatalogVo>> subCatalogVosMap = levelCategories.stream().collect(Collectors.toMap(k -> k.getCatId().toString(),v -> { List<CategoryEntity> entities = getParentCid(categories,v.getCatId()); List<SubCatalogVo> subCatalogVos = null; if(entities!=null&&!entities.isEmpty()){ subCatalogVos = entities.stream().map(item -> { // 找三级分类 List<CategoryEntity> inCategories = getParentCid(categories,item.getCatId()); SubCatalogVo subCatalogVo = new SubCatalogVo(v.getCatId().toString(),null, item.getCatId().toString(), item.getName()); if(inCategories!=null&&!inCategories.isEmpty()){ // 封装成指定格式 List<SubCatalogVo.InCatalogVo> inCatalogVos = inCategories.stream().map(inCategory -> { SubCatalogVo.InCatalogVo inCatalogVo = new SubCatalogVo.InCatalogVo(item.getCatId().toString(),inCategory.getCatId().toString(),inCategory.getName()); return inCatalogVo; }).collect(Collectors.toList()); subCatalogVo.setCatalog3List(inCatalogVos); } return subCatalogVo; }).collect(Collectors.toList()); } return subCatalogVos; })); // 查到的数据保存到缓存中先 String jsonString = JSON.toJSONString(subCatalogVosMap); // 查到的数据放入缓存,将这个对象我们转为JSON redisTemplate.opsForValue().set("catalogJSON",jsonString,1, TimeUnit.DAYS); return subCatalogVosMap; } return JSON.parseObject(catalogJSON,new TypeReference<Map<String, List<SubCatalogVo>>>(){}); } // TODO 堆外内存溢出,原因是lettuce使用了netty做网络通信,lettuce的bug导致了我们的堆外内存溢出 @Override public Map<String, List<SubCatalogVo>> getCatalogJson() { String uuid = UUID.randomUUID().toString(); //加锁采用setNX加过期时间的方式保证原子性 Boolean lock = redisTemplate.opsForValue().setIfAbsent("lock", uuid, 3000, TimeUnit.SECONDS); if(lock){ Map<String, List<SubCatalogVo>> catalogJsonFromDb = null; try{ catalogJsonFromDb = getCatalogJsonFromDb(); } finally { // LUA脚本解锁 String script = "if redis.call('get', KEYS[1]) == ARGV[1] then\n" + " return redis.call('del', KEYS[1])\n" + "else\n" + " return nil\n" + "end\n"; // 删除锁用LUA脚本保持原子性 redisTemplate.execute(new DefaultRedisScript<Long>(script, Long.class), Arrays.asList("lock"), uuid); } return catalogJsonFromDb; } else{ // TODO 加锁失败,休眠后再次尝试 try { Thread.sleep(333); } catch (InterruptedException e) { throw new RuntimeException(e); } return getCatalogJson(); } } private List<CategoryEntity> getParentCid(List<CategoryEntity> categories,Long catId) { return categories.stream().filter(item -> item.getParentCid() == catId).collect(Collectors.toList()); } private List<Long> findParent(Long catelogId,List<Long> paths){ // 查出当前分类的ID // 收集当前节点ID paths.add(catelogId); CategoryEntity id = this.getById(catelogId); if(id.getParentCid() != 0){ // 递归查找,每次都从父节点获取 findParent(id.getParentCid(),paths); } return paths; } // 递归查找所有菜单的子菜单 private List<CategoryEntity> getChildren(CategoryEntity root,List<CategoryEntity> all){ List<CategoryEntity> children = all.stream().filter(categoryEntity -> { return categoryEntity.getParentCid() == root.getCatId(); }).map(categoryEntity -> { categoryEntity.setChildren(getChildren(categoryEntity,all)); return categoryEntity; }).sorted((menu1,menu2) ->{ return (menu1.getSort()==null?0:menu1.getSort()) - (menu2.getSort()==null?0:menu2.getSort()); }).collect(Collectors.toList()); return children; } }
02-27
513
06-13
1467