package com.consum.base.service;

import com.consum.model.po.BaseCategory;
import com.walker.jdbc.service.BaseServiceImpl;
import org.springframework.stereotype.Service;

import java.util.HashMap;
import java.util.List;

/**
 * @Description 物品模板
 * @Author 卢庆阳
 * @Date 2023/10/23
 */
@Service
public class BaseGoodsTemplateServiceImpl extends BaseServiceImpl {

    /**
     * @Description  根据分类id和状态查询物品模版
     * @Author 卢庆阳
     * @Date 2023/10/23
     * @return
     */
    public List<BaseCategory> getByCategoryId(Long categoryId) {
        StringBuilder sql = new StringBuilder("SELECT * FROM base_goods_template WHERE 1 = 1 ");
        HashMap<String, Object> paramts = new HashMap<>();

        //分类id
        if (categoryId != null) {
            sql.append(" and category_id =:category_id ");
            paramts.put("category_id", categoryId);
        }
        sql.append(" and states =1 ");

        return this.select(sql.toString(), paramts, new BaseCategory());
    }
}