package com.ruoyi.web.modules.prosperity.mapper;

import java.util.List;
import org.apache.ibatis.annotations.Param;
import com.ruoyi.web.modules.prosperity.domain.BizCommonProsperityAchievement;

/**
 * 共同富裕成果 Mapper
 */
public interface BizCommonProsperityAchievementMapper
{
    BizCommonProsperityAchievement selectBizCommonProsperityAchievementById(Long id);

    List<BizCommonProsperityAchievement> selectBizCommonProsperityAchievementList(
            BizCommonProsperityAchievement query);

    int countByStatPeriod(@Param("statPeriod") String statPeriod, @Param("excludeId") Long excludeId);

    int insertBizCommonProsperityAchievement(BizCommonProsperityAchievement row);

    int updateBizCommonProsperityAchievement(BizCommonProsperityAchievement row);

    int deleteBizCommonProsperityAchievementByIds(Long[] ids);

    List<BizCommonProsperityAchievement> selectByStatYear(@Param("statYear") String statYear);

    List<BizCommonProsperityAchievement> selectByStatPeriodBetween(
            @Param("periodStart") String periodStart,
            @Param("periodEnd") String periodEnd);

    List<String> selectDistinctStatYears();
}
