package cn.cetc54.platform.zhyl.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import cn.cetc54.platform.zhyl.entity.SubsidyPersonStatics;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

/**
 * 测试数据处理层
 * @author 
 */
public interface SubsidyPersonStaticsMapper extends BaseMapper<SubsidyPersonStatics> {
    /**
     * 获取每月新增和退出的历史数据
     * @param type
     * @return
     */
    @Select("<script>" +
            "select month,SUM(month_add) as mAdd,SUM(month_out) as mOut,SUM(check_num) as checkNum,SUM(total_num) as totalNum " +
            "FROM t_yl_subsidy_person_statics " +
            " <where> " +
            "area_id = #{areaId} " +
            " <if test='type!= null'>" +
            " and subsidy_type = #{type}" +
            " </if>" +
            " </where>" +
            "GROUP BY month ORDER BY month DESC LIMIT 12" +
            " </script>")
    List<Map<String,Object>> getMonthAddOut(@Param("areaId") String areaId,@Param("type") Integer type);
}