package com.mzl.flower.mapper.configParam;

import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.mzl.flower.dto.request.configParam.QueryConfigParamDTO;
import com.mzl.flower.dto.response.configParam.ConfigParamVO;
import com.mzl.flower.entity.configParam.ConfigParamDO;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.mzl.flower.entity.configParam.ConfigParamGroupDO;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author @TaoJie
 * @since 2024-12-02
 */
public interface ConfigParamMapper extends BaseMapper<ConfigParamDO> {


    @Select("select param_value from t_config_param where param_group = #{paramGroup} and param_key =#{paramKey} and deleted = '0'  ")
    String getBaseString(String paramGroup, String paramKey);

    List<ConfigParamVO> queryPage(QueryConfigParamDTO dto, Page page);


    @Select("select * from t_config_param_group where param_group = #{paramGroup} and deleted = '0' limit 1")
    ConfigParamGroupDO getByParamGroup(@Param("paramGroup") String paramGroup);


    @Select("select * from t_config_param_group where param_group_name = #{paramGroupName} and deleted = '0' limit 1")
    ConfigParamGroupDO getByParamGroupName(@Param("paramGroupName")String paramGroupName);
}