package com.ishop.merchant.service;

import com.ishop.merchant.CouponConstants;
import com.ishop.merchant.util.VoUtils;
import com.ishop.model.po.EbCoupon;
import com.ishop.model.po.EbCouponUser;
import com.ishop.model.vo.CouponFrontVo;
import com.walker.db.page.GenericPager;
import com.walker.db.page.ListPageContext;
import com.walker.db.page.PageSearch;
import com.walker.infrastructure.utils.DateUtils;
import com.walker.infrastructure.utils.StringUtils;
import com.walker.jdbc.service.BaseServiceImpl;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

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

@Service
public class CouponServiceImpl extends BaseServiceImpl {

    private CouponUserServiceImpl couponUserService;

    @Autowired
    public CouponServiceImpl(CouponUserServiceImpl couponUserService){
        this.couponUserService = couponUserService;
    }

    /**
     * 移动端优惠券列表
     * @param userId 当前用户ID，如果0表示无用户
     * @param category 分类
     * @param merId 商户ID
     * @param productId 商品ID
     * @return
     * @date 2023-07-09
     */
    public GenericPager<CouponFrontVo> queryPageH5CouponList(long userId, Integer category, Integer merId, Long productId){
        if((merId == null || merId.intValue() <=0) && (productId == null || productId.longValue() <= 0)){
            throw new IllegalArgumentException("商户ID与商品ID不能都为空");
        }

        List<CouponFrontVo> couponFrontVoList = new ArrayList<>();

        PageSearch pageSearch = ListPageContext.getPageSearch();
        GenericPager<EbCoupon> pager = this.queryH5CouponList(category, merId, productId, pageSearch);
        List<EbCoupon> list = pager.getDatas();
        if(StringUtils.isEmptyList(list)){
            return ListPageContext.createGenericPager(couponFrontVoList, 1, 0);
        }

        //获取用户当前已领取的优惠券
        Map<Integer, EbCouponUser> couponUserMap = this.couponUserService.queryCouponIdAndValue(userId);

        CouponFrontVo couponFrontVo = null;
        for (EbCoupon coupon : list) {
            couponFrontVo = VoUtils.acquireCouponFrontVo(coupon);
            if(userId > 0 && couponUserMap != null && couponUserMap.containsKey(coupon.getId())){
                couponFrontVo.setIsUse(true);
            }
            // 更改使用时间格式，去掉时分秒
            couponFrontVo.setUseStartTimeStr(DateUtils.toShowDate((int)(coupon.getUseStartTime()/1000000)));
            couponFrontVo.setUseEndTimeStr(DateUtils.toShowDate((int)(coupon.getUseEndTime()/1000000)));
            couponFrontVoList.add(couponFrontVo);
        }
        return ListPageContext.createGenericPager(couponFrontVoList, pager.getPageIndex(), pager.getPageSize());
    }

    /**
     * 根据条件查询优惠券集合，前端使用。
     * @param category
     * @param merId
     * @param productId
     * @return
     * @date 2023-07-09
     */
    private GenericPager<EbCoupon> queryH5CouponList(Integer category, Integer merId, Long productId, PageSearch pageSearch){
        Map<String, Object> param = new HashMap<>(4);
        StringBuilder sql = new StringBuilder("select c.* from eb_coupon as c where c.is_del = 0 and c.status = 1 and receive_type = 1");
        sql.append(" and (last_total > 0 or is_limited = 0)");
        sql.append(" and (is_time_receive = 0 or (receive_start_time <= :date and receive_end_time >= :date))");
        sql.append(" and (is_fixed_time = 0 or use_end_time >= :date)");
        param.put("date", DateUtils.getDateTimeNumber());   // 格式如：20230709204010
        if(category != null){
            sql.append(" and category = :category");
            param.put("category", category);
        }
        if(merId != null){
            sql.append(" and mer_id = :merId");
            param.put("merId", merId);
        }
        if(productId != null){
            sql.append(" and :productId in (select pid from eb_coupon_product where cid = c.id)");
            param.put("productId", productId);
        }
        sql.append(" order by c.sort,c.id desc");
        return this.selectSplit(sql.toString(), param, pageSearch.getPageIndex(), pageSearch.getPageSize(), new EbCoupon());
    }

    /**
     * 商品可用优惠券列表（商品创建时选择使用）
     * @param merId
     * @return
     * @date 2023-06-21
     */
    public List<EbCoupon> queryProductUsableList(int merId){
        EbCoupon coupon = new EbCoupon();
        coupon.setIsDel(0);
        coupon.setMerId(merId);
        coupon.setReceiveType(CouponConstants.COUPON_RECEIVE_TYPE_PAY_PRODUCT);
        coupon.setStatus(1);
        return this.select(coupon);
    }
}