package com.ishop.merchant.service;

import com.ishop.model.po.EbProductRule;
import com.walker.db.Sorts;
import com.walker.db.page.GenericPager;
import com.walker.infrastructure.utils.StringUtils;
import com.walker.jdbc.service.BaseServiceImpl;
import org.springframework.stereotype.Service;

@Service
public class ProductRuleServiceImpl extends BaseServiceImpl {

    private final Sorts.Sort idSort = Sorts.DESC().setField("id");

    /**
     * 查询是否存在对应商户的规格记录
     * @param merId 商户ID
     * @param ruleName 规格名称
     * @return
     * @date 2023-07-31
     */
    public boolean queryExistRuleName(int merId, String ruleName){
        long size = this.sqlMathQuery("select count(id) total from eb_product_rule where mer_id=? and rule_name=?", new Object[]{merId, ruleName}, Long.class);
        return size > 0;
    }

    /**
     * 分页返回商户端管理的：商品规格列表
     * @param merId
     * @param keywords
     * @return
     */
    public GenericPager<EbProductRule> queryPageRuleList(Integer merId, String keywords){
        EbProductRule param = new EbProductRule();
        if(merId != null){
            param.setMerId(merId);
        }
        if(StringUtils.isNotEmpty(keywords)){
            param.setRuleName(StringUtils.CHAR_PERCENT + keywords + StringUtils.CHAR_PERCENT);
        }
        return this.selectSplit(param, idSort);
    }
}