正式数据库修改

admin

2019-03-13 69bee82b81626b82b7f39f0e459e4f56b1699b51

 fanli/src/main/java/com/yeshi/fanli/service/impl/goods/GoodsClassServiceImpl.java

@@ -9,6 +9,7 @@
import java.util.ArrayList;

import java.util.Collection;

import java.util.HashMap;

import java.util.Iterator;

import java.util.List;

import java.util.Map;

import java.util.Properties;

@@ -27,17 +28,21 @@
import org.springframework.web.multipart.MultipartFile;

import org.yeshi.utils.tencentcloud.COSManager;



import com.google.gson.Gson;

import com.google.gson.GsonBuilder;

import com.yeshi.fanli.dao.goods.GoodsClassDao;

import com.yeshi.fanli.dao.mybatis.GoodsClassMapper;

import com.yeshi.fanli.dao.mybatis.lable.LabelClassMapper;

import com.yeshi.fanli.entity.admin.GoodsClassAdmin;

import com.yeshi.fanli.entity.bus.clazz.GoodsClass;

import com.yeshi.fanli.entity.bus.clazz.GoodsSubClass;

import com.yeshi.fanli.entity.bus.su.clazz.SuperGoodsClass;

import com.yeshi.fanli.entity.system.System;

import com.yeshi.fanli.service.inter.config.SystemService;

import com.yeshi.fanli.service.inter.goods.ClassRecommendGoodsService;

import com.yeshi.fanli.service.inter.goods.GoodsClassService;

import com.yeshi.fanli.service.inter.goods.GoodsSecondClassService;

import com.yeshi.fanli.service.inter.goods.GoodsSubClassService;

import com.yeshi.fanli.service.inter.goods.SuperGoodsClassService;

import com.yeshi.fanli.util.Constant;

import com.yeshi.fanli.util.StringUtil;

@@ -66,6 +71,10 @@
   

   @Resource

   private LabelClassMapper labelClassMapper;

	
	
   @Resource

   private GoodsSubClassService goodsSubClassService;

   



   public GoodsClass getGoodsClass(long gcid) {

@@ -555,15 +564,76 @@
      }

      

      deleteFile = COSManager.getInstance().deleteFile(fileUrl);

		
      if (deleteFile) {

         record.setPicture(null);

         // 更新数据库

          updateGoodsClass(record);

      } 

		
      return;

   }



   @Override

   @Cacheable(value="classCache",key="'getListClassCache-'+#systemId")

   public List<GoodsClass> getListClassCache(Long systemId) throws Exception {

      List<SuperGoodsClass> superGoodsClassList = superGoodsClassService.getSuperGoodsClassBySystemId(systemId);

		
      if (superGoodsClassList == null || superGoodsClassList.size() == 0) {

         return null;

      }

		
      List<GoodsClass> goodsClassList = new ArrayList<GoodsClass>();

      for (SuperGoodsClass superGoodsClass : superGoodsClassList) {

         GoodsClass goodsClass = superGoodsClass.getGoodsClass();

         goodsClassList.add(goodsClass);

      }

		
      return goodsClassList;

   }

	
	
   @Override

   @Cacheable(value="classCache",key="'getClassListAllCache-'+#systemId")

   public List<Map<String, Object>> getClassListAllCache(Long systemId) throws Exception {



      List<GoodsClass> goodsClassList = goodsClassMapper.listGoodsClassBySystemId(systemId);

      if (goodsClassList == null || goodsClassList.size() == 0) {

         return null;

      }



      List<Long> listID = new ArrayList<Long>();

      for (GoodsClass coodsClass : goodsClassList) {

         listID.add(coodsClass.getId());

      }

	
      List<GoodsSubClass> listSub = goodsSubClassService.queryByListCid(listID);

		
      Gson gson = new GsonBuilder().create();



      List<Map<String, Object>> list = new ArrayList<Map<String, Object>>();

      for (GoodsClass goodsClass : goodsClassList) {



         List<GoodsSubClass> subClassList = new ArrayList<GoodsSubClass>();

			
         if (listSub != null && listSub.size() > 0) {

            Iterator<GoodsSubClass> iterator = listSub.iterator();

            while (iterator.hasNext()) {

               GoodsSubClass goodsSubClass = iterator.next();

               GoodsClass goodsClassInner = goodsSubClass.getRootClass();

               if (goodsClass.getId() == goodsClassInner.getId()) {

                  // 对应下子分类

                  subClassList.add(goodsSubClass);

                  iterator.remove();

               }

            }

         }



         Map<String, Object> map = new HashMap<String, Object>();

         map.put("gclass", goodsClass);

         map.put("subList", gson.toJson(subClassList));



         list.add(map);

      }



      return list;

   }

   

}