package com.ishop.mobile.service;

import com.iplatform.model.vo.SystemGroupVo;
import com.ishop.merchant.ProductConstants;
import com.ishop.model.po.EbMerchant;
import com.ishop.model.po.EbProduct;
import com.ishop.model.po.EbSeckillProduct;
import com.walker.db.page.GenericPager;
import com.walker.infrastructure.utils.StringUtils;
import com.walker.jdbc.service.BaseServiceImpl;
import org.springframework.stereotype.Service;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

@Service
public class IndexServiceImpl extends BaseServiceImpl {

    /**
     * 首页商品列表
//     * @param cid 一级商品分类id，全部传0
     * @param categoryIdList 第三级商品分类id集合
     * @return
     * @date 2023-06-23
     */
    public GenericPager<EbProduct> queryIndexProductList(List<Integer> categoryIdList){
        Map<String, Object> parameter = new HashMap<>(4);
        StringBuilder sql = new StringBuilder("select * from eb_product where is_del=0 and is_recycle=0 and is_show=1");
        sql.append(" and (audit_status=").append(ProductConstants.AUDIT_STATUS_SUCCESS)
                .append(" or audit_status=").append(ProductConstants.AUDIT_STATUS_EXEMPTION).append(")");
        sql.append(" and stock>0");
        if (!StringUtils.isEmptyList(categoryIdList)) {
//            System.out.println("请实现商品分类查询代码!");
            sql.append(" and category_id in (:categoryIdList)");
            parameter.put("categoryIdList", categoryIdList);
        }
        sql.append(" order by id desc");
        // 查询活动边框配置信息, 并赋值给商品response 重复添加的商品数据会根据数据添加持续覆盖后的为准
//        productList = activityStyleService.makeActivityBorderStyle(productList);
        return this.selectSplit(sql.toString(), parameter, new EbProduct());
    }

    /**
     * 返回首页推荐的商家集合
     * @param limit 限制几条
     * @return
     * @date 2023-06-23
     */
    public List<EbMerchant> queryIndexMerchantList(int limit){
        return this.select("select id,name,rectangle_logo,cover_image,category_id,type_id from eb_merchant where is_switch=1 and is_del=0 order by is_recommend desc, sort desc limit ?"
                , new Object[]{limit}, new EbMerchant());
    }

    /**
     * 获取APP首页秒杀活动集合。暂时没实现。
     * @return
     * @date 2023-06-23
     */
    public List<EbSeckillProduct> queryIndexSecKillList(){
        return new ArrayList<>(1);
    }
}