package com.siwei.apply.mapper;

import com.siwei.apply.domain.res.TdgyStatisticsRes;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

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

@Mapper
public interface GjShouchuJihuaMapper {

    Map<String, Object> getPlanSummaryByYear(@Param("year") String year);

    List<Map<String, Object>> getPlanStatsByLandUse(@Param("year") String year);

    List<Map<String, Object>> getPlanStatsByMethod(@Param("year") String year);

    List<TdgyStatisticsRes> getPlanListByYear(@Param("year") String year,@Param("startYear") String startYear,@Param("endYear") String endYear, @Param("keyWord") String keyWord);

    Map<String, Object> getPlanProject(@Param("gid") String gid);


    int insertTableData(@Param("tableName") String tableName, @Param("data") Map<String, Object> data, @Param("shpDbSRID") Integer shpDbSRID);

    int deleteByTable(@Param("tableName") String tableName, @Param("gid") String gid,@Param("sourceType") String sourceType);

    int insertTableActualData(@Param("tableName") String tableName, @Param("data") Map<String, Object> data, @Param("shpDbSRID") Integer shpDbSRID);

    List<Map<String, Object>> actualList(@Param("tableName") String tableName,@Param("sourceType") String sourceType,@Param("year") String year,@Param("nf") String nf);

    int deleteByTableYear(@Param("tableName") String tableName,@Param("type") String type, @Param("year") String year);

}