package cn.com.goldenwater.dcproj.dao;

import cn.com.goldenwater.dcproj.dto.*;
import cn.com.goldenwater.dcproj.model.BriefReport;
import cn.com.goldenwater.dcproj.model.RiverNode;
import cn.com.goldenwater.dcproj.param.BriefReportParam;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import javax.swing.text.MaskFormatter;
import java.util.List;
import java.util.Map;


@Repository
public interface BriefReportDao{

    int getGroupCountByType(@Param("type") String type,@Param("orgId") String orgId,@Param("province") String province);

    int getPersCountByType(@Param("type") String type,@Param("orgId") String orgId,@Param("province") String province);

    int getProCount(@Param("province") String province);

    int getPblmCount(Map<String, Object> map);

    int getVillProCount(@Param("province") String province);
    int getVillCtCount(@Param("province") String province);
    int getVillVillCount(@Param("province") String province);
    int getVillPersCount(@Param("province") String province);
    int getRsvrProCount(@Param("province") String province);
    int getRectProCount(@Param("province") String province);
    int getRsvrCountByType(@Param("eng_scal") String eng_scal,@Param("province") String province);
    List<Map<String, Object>> getPblmList(Map<String, Object> map);
    List<BriefReport> getGroupCountListByType(Map<String, Object> map);
    List<BriefReport> getPersCountListByType(Map<String, Object> map);
    List<BriefReport> getRectProCountList(@Param("orgName") String orgName,@Param("sttm") String sttm,@Param("entm") String entm,
                                          @Param("state") String state,@Param("province") String province);
    List<BriefReport> getRectCtCountList(@Param("orgName") String orgName,@Param("sttm") String sttm,@Param("entm") String entm,
                                         @Param("state") String state,@Param("province") String province);
    List<BriefReport> getRectCountList(@Param("orgName") String orgName,@Param("sttm") String sttm,@Param("entm") String entm ,
                                       @Param("state") String state,@Param("province") String province);
    List<BriefReport> getRsvrProCountList(@Param("orgName") String orgName,@Param("sttm") String sttm,@Param("entm") String entm,
                                          @Param("state") String state,@Param("province") String province);
    List<BriefReport> getRsvrCtCountList(@Param("orgName") String orgName,@Param("sttm") String sttm,@Param("entm") String entm,
                                         @Param("state") String state,@Param("province") String province);
    List<BriefReport> getRsvrCountListByType(@Param("orgName") String orgName,@Param("eng_scal") String eng_scal,@Param("sttm") String sttm,
                                             @Param("entm") String entm, @Param("state") String state,@Param("province") String province);
    List<BriefReport> getVillProCountList(@Param("orgName") String orgName,@Param("sttm") String sttm,@Param("entm") String entm,@Param("province") String province);
    List<BriefReport> getVillCtCountList(@Param("orgName") String orgName,@Param("sttm") String sttm,@Param("entm") String entm,@Param("province") String province);
    List<BriefReport> getVillVillCountList(@Param("orgName") String orgName,@Param("sttm") String sttm,@Param("entm") String entm,
                                           @Param("state") String state,@Param("province") String province);
    List<BriefReport> getVillPersCountList(@Param("orgName") String orgName,@Param("sttm") String sttm,@Param("entm") String entm,
                                           @Param("state") String state,@Param("province") String province);
    List<BriefReport> getVillCwsCountList(@Param("orgName") String orgName,@Param("sttm") String sttm,@Param("entm") String entm,
                                          @Param("state") String state,@Param("province") String province);
    List<BriefReport> getVillWaterCountList(@Param("orgName") String orgName,@Param("sttm") String sttm,@Param("entm") String entm,
                                            @Param("state") String state,@Param("province") String province);
    List<BriefReport> getPblmCountList(Map<String, Object> map);
    //省加单位-组
    List<BriefReport> getOrgProGroupList(@Param("type") String prtpe,@Param("adName") String adName,@Param("orgName") String orgName,
                                         @Param("sttm") String sttm,@Param("entm") String entm,@Param("province") String province,
                                         @Param("length") String length,@Param("zero") String zero);
    //省加单位-人
    List<BriefReport> getOrgProPersList(@Param("type") String prtpe,@Param("adName") String adName,@Param("orgName") String orgName,
                                        @Param("sttm") String sttm,@Param("entm") String entm,@Param("province") String province,
                                        @Param("length") String length,@Param("zero") String zero);
    //省加单位-小水库-县
    List<BriefReport> getOrgProCountryList(@Param("adName") String adName,@Param("orgName") String orgName,@Param("sttm") String sttm,
                                           @Param("entm") String entm, @Param("state") String state,@Param("province") String province,
                                           @Param("length") String length,@Param("zero") String zero);
    //省加单位-小水库-水库
    List<BriefReport> getOrgProRsvrList(@Param("eng_scal") String prtpe,@Param("adName") String adName,@Param("orgName") String orgName,
                                        @Param("sttm") String sttm,@Param("entm") String entm,
                                        @Param("state") String state,@Param("province") String province,
                                        @Param("length") String length,@Param("zero") String zero);
    //省加单位-问题列表
    List<BriefReport> getOrgProPblmList(Map<String, Object> map);
    //省加单位-水毁-县
    List<BriefReport> getOrgProRectCountryList(@Param("adName") String adName,@Param("orgName") String orgName,@Param("sttm") String sttm,
                                               @Param("entm") String entm, @Param("state") String state,@Param("province") String province);
    //省加单位-水毁-水毁
    List<BriefReport> getOrgProRectList(@Param("adName") String adName,@Param("orgName") String orgName,@Param("sttm") String sttm,
                                        @Param("entm") String entm, @Param("state") String state,@Param("province") String province);
    //省加单位-农饮-县
    List<BriefReport> getOrgProVillCountryList(@Param("adName") String adName,@Param("orgName") String orgName,@Param("sttm") String sttm,
                                               @Param("entm") String entm, @Param("state") String state,@Param("province") String province);
    //省加单位-农饮-村
    List<BriefReport> getOrgProVillVillList(@Param("adName") String adName,@Param("orgName") String orgName,@Param("sttm") String sttm,
                                            @Param("entm") String entm, @Param("state") String state,@Param("province") String province);
    //省加单位-农饮-用水户
    List<BriefReport> getOrgProVillPersList(@Param("adName") String adName,@Param("orgName") String orgName,@Param("sttm") String sttm,
                                            @Param("entm") String entm, @Param("state") String state,@Param("province") String province);
    //省加单位-农饮-工程
    List<BriefReport> getOrgProVillCwsList(@Param("adName") String adName,@Param("orgName") String orgName,@Param("sttm") String sttm,
                                           @Param("entm") String entm, @Param("state") String state,@Param("province") String province);
    //省加单位-农饮-水源地
    List<BriefReport> getOrgProVillWaterList(@Param("adName") String adName,@Param("orgName") String orgName,@Param("sttm") String sttm,
                                             @Param("entm") String entm, @Param("state") String state,@Param("province") String province);


    List<RiverSupervisionCwsCount> getRiverSupervisionCwsCount(BriefReportParam briefReportParam);


    int getPersCount(@Param("groupId") String groupId,@Param("province") String province);

    int getVillageCount(@Param("type") String type,@Param("groupId") String groupId,@Param("sttm") String sttm,@Param("entm") String entm,
                        @Param("state") String state,@Param("province") String province);

    int getAllProCount(@Param("type") String type,@Param("groupId") String groupId,@Param("pblmType") String pblmType,@Param("sttm") String sttm,
                       @Param("entm") String entm, @Param("state") String state,@Param("province") String province);

    int getRsCount(@Param("engScal") String engScal,@Param("groupId") String groupId, @Param("state") String state,@Param("province") String province);

    int getWtdCount(@Param("groupId") String groupId, @Param("state") String state,@Param("province") String province);

    List<RiverSupervisionRivCount> getRiverSupervisionRivCount(BriefReportParam briefReportParam);

    List<RiverSupervisionWtdCount> getRiverSupervisionWtdCount(BriefReportParam briefReportParam);

    List<AdNameDto> getCwsAdNameDtoList(@Param("groupId") String groupId,@Param("province") String province);

    List<AdNameDto> getRivAdNameDtoList(@Param("groupId") String groupId,@Param("province") String province);

    List<AdNameDto> getWtdAdNameDtoList(@Param("groupId") String groupId,@Param("province") String province);

    int getCwsCountyCount(@Param("groupId") String groupId,@Param("province") String province);

    int getRivCountyCount(@Param("groupId") String groupId,@Param("province") String province);

    int getWtdCountyCount(@Param("groupId") String groupId, @Param("state") String state,@Param("province") String province);

    List<RiverNode> getRiverNode(@Param("type") String type,@Param("orgId") String orgId,@Param("province") String province);

    List<ObjectNameDto> getNmByPersid(@Param("persid") String persid,@Param("province") String province);


    ObjectNameDto getOrgName(@Param("substring") String substring);

    List<RiverSupervisionEmpwtCount> getRiverSupervisionEmpwtConCount(BriefReportParam briefReportParam);

    int getEmpwtCount(@Param("groupId") String groupId, @Param("state") String state,@Param("province") String province);

    List<RiverSupervisionEmpwtCount> getRiverSupervisionEmpwtRunCount(BriefReportParam briefReportParam);

    List<RiverSupervisionWagaCount> getRiverSupervisionWagaCount(BriefReportParam briefReportParam);

    int getWagaCount(@Param("engScal") String engScal,@Param("groupId") String groupId, @Param("state") String state,@Param("province") String province);


    List<AdNameDto> getWagaAdNameDtoList(@Param("groupId") String groupId);


    List<AdNameDto> getEmpwtAdNameDtoList(@Param("groupId") String groupId,@Param("type") String type,@Param("province") String province);


    List<BriefReport> getOrgProEmpwtCountryList(@Param("engSta") String engSta, @Param("adName") String adName,@Param("orgName") String orgName,
                                                @Param("sttm") String sttm,@Param("entm") String entm, @Param("state") String state,@Param("province") String province);

    List<BriefReport> getOrgProEmpwtList(@Param("engSta") String engSta, @Param("adName") String adName,@Param("orgName") String orgName,
                                         @Param("sttm") String sttm,@Param("entm") String entm,
                                         @Param("state") String state,@Param("province") String province);

    List<BriefReport> getOrgProWagaCountryList(@Param("adName") String adName,@Param("orgName") String orgName,@Param("sttm") String sttm,
                                               @Param("entm") String entm, @Param("state") String state,@Param("province") String province);

    List<BriefReport> getOrgProWagaList(@Param("engScal") String engScal, @Param("adName") String adName,@Param("orgName") String orgName,
                                        @Param("sttm") String sttm,@Param("entm") String entm, @Param("state") String state,@Param("province") String province);

    List<BriefReport> getEmpwtProCountList(@Param("engSta") String engSta, @Param("orgName") String orgName,@Param("sttm") String sttm,
                                           @Param("entm") String entm, @Param("state") String state,@Param("province") String province);

    List<BriefReport> getEmpwtCtCountList(@Param("engSta") String engSta, @Param("orgName") String orgName,@Param("sttm") String sttm,
                                          @Param("entm") String entm, @Param("state") String state,@Param("province") String provicne);

    List<BriefReport> getEmpwtCountListByType(@Param("engSta") String engSta, @Param("orgName") String orgName,@Param("sttm") String sttm,
                                              @Param("entm") String entm, @Param("state") String state,@Param("province") String province);

    List<BriefReport> getWagaProCountList(@Param("orgName") String orgName,@Param("sttm") String sttm,@Param("entm") String entm,
                                          @Param("state") String state,@Param("province") String province);

    List<BriefReport> getWagaCtCountList(@Param("orgName") String orgName,@Param("sttm") String sttm,@Param("entm") String entm,
                                         @Param("state") String state,@Param("province")String province);

    List<BriefReport> getWagaCountListByType(@Param("orgName") String orgName,@Param("engScal") String engScal,@Param("sttm") String sttm,
                                             @Param("entm") String entm, @Param("state") String state,@Param("province") String province);

    List<BriefReport> getAdCodeByType(@Param("type") String type,@Param("adName") String adName,@Param("orgName") String orgName,
                                      @Param("province") String province,@Param("length") String length,@Param("zero") String zero);

    List<RiverSupervisionRivCount> getRiverPersSupervisionInfo(BriefReportParam briefReportParam);

    List<AdNameDto> getPersAdFullNameDtoList(@Param("persId") String persId,@Param("province") String province);

    int getPersRsCount(@Param("engScal") String engScal,@Param("persId") String persId,@Param("sttm") String sttm,@Param("entm") String entm,
                       @Param("state") String state,@Param("province") String province);

    int getPersAllProCount(@Param("type") String type,@Param("persId") String persId,@Param("s") String s,@Param("sttm") String sttm,
                           @Param("entm") String entm, @Param("state") String state,@Param("province") String province);

    List<RiverSupervisionCwsCount> getRiverPersSupervisionCwsInfo(BriefReportParam briefReportParam);

    int getPersVillageCount(@Param("type") String type,@Param("persId") String persId,@Param("sttm") String sttm,@Param("entm") String entm, @Param("state") String state);

    List<RiverSupervisionWtdCount> getPersRiverSupervisionWtdInfo(BriefReportParam briefReportParam);

    int getPersWtdCount(@Param("persId") String persId,@Param("sttm") String sttm,@Param("entm") String entm, @Param("state") String state);

    List<RiverSupervisionEmpwtCount> getPersRiverSupervisionEmpwtConCount(BriefReportParam briefReportParam);

    int getPersEmpwtCount(@Param("engSta") String engSta,@Param("persId") String persId,@Param("sttm") String sttm,@Param("entm") String entm, @Param("state") String state,@Param("province") String province);

    List<RiverSupervisionEmpwtCount> getPersRiverSupervisionEmpwtRunCount(BriefReportParam briefReportParam);

    List<RiverSupervisionWagaCount> getPersRiverSupervisionWagaCount(BriefReportParam briefReportParam);

    int getPersWagaCount(@Param("engScal") String engScal,@Param("persId") String persId,@Param("sttm") String sttm,@Param("entm") String entm,
                         @Param("state")String state,@Param("province") String province);
    List<ObjectNameDto> getbigNmByPersid(@Param("persid") String persid,@Param("province") String province);

    List<AdNameDto> getCwsAdNameDtoListByGroupIds(@Param("groupId") String groupId);

    List<PersCountDto> getCwsCountyCountById(@Param("groupId")String groupId);

    List<PersCountDto> getVillageCountByGroupId(@Param("groupId")String groupId,@Param("sttm") String sttm, @Param("entm") String entm, @Param("state") String state);


    /**
     * list obj group by adCode
     * @param briefReportParam
     * @return
     */
    List<BriefReport> getOrgProList(BriefReportParam briefReportParam);

    /**
     * list pblm group by adCode
     * @param briefReportParam
     * @return
     */
    List<BriefReport> getOrgPblmList(BriefReportParam briefReportParam);

    /**
     * list pro count group by orgCode
     * @param briefReportParam
     * @return
     */
    List<BriefReport> getOrgWorkProCountList(BriefReportParam briefReportParam);

    /**
     * list country count group by orgCode
     * @param briefReportParam
     * @return
     */
    List<BriefReport> getOrgWorkCtCountList(BriefReportParam briefReportParam);

    /**
     * list obj count group by orgCode
     * @param briefReportParam
     * @return
     */
    List<BriefReport> getOrgWorkObjCountListByType(BriefReportParam briefReportParam);

    /**
     * list pblm count group by orgCode
     * @param briefReportParam
     * @return
     */
    List<BriefReport> getPblmCountListByType(BriefReportParam briefReportParam);

    /**
     * list group count by river
     * @param briefReportParam
     * @return
     */
    List<RiverSupervisionRivCount> getRiverSupervisionCount(BriefReportParam briefReportParam);

    /**
     * list adNameDtoList by groupId and objType
     * @param map
     * @return
     */
    List<AdNameDto> getAdNameDtoListByGroupIds(Map<String, Object> map);

    /**
     * list countryDtos by gourpId and objType
     * @param map
     * @return
     */
    List<PersCountDto> getGroupCountyCountById(Map<String, Object> map);

    /**
     * list obj dto by groupId and objType
     * @param map
     * @return
     */
    List<PersCountDto> getGroupCountByGroupId(Map<String, Object> map);

    /**
     * list fsc or other DC pblm count
     * @param briefReportParam
     * @return
     */
    List<PersCountDto> getFscOrOthProCountByGroupId(BriefReportParam briefReportParam);

    /**
     * list pers work
     * @param briefReportParam
     * @return
     */
    List<RiverSupervisionRivCount> getPersWorkSupervisionInfo(BriefReportParam briefReportParam);

    /**
     * list pers rgstr count by persIds
     * @param briefReportParam
     * @return
     */
    List<PersCountDto> getPersCountByPersIds(BriefReportParam briefReportParam);

    /**
     * list pers pro count by persIds
     * @param briefReportParam
     * @return
     */
    List<PersCountDto> getPersFscOrOthProCountByPersIds(BriefReportParam briefReportParam);

    List<PersCountDto> getPersCountById(@Param("groupId") String groupId);

    List<PersCountDto> getAllProCountByGroupId(@Param("type") String type,@Param("groupId") String groupId,
                                              @Param("s1") String s1,@Param("sttm") String sttm,@Param("entm") String entm,@Param("state") String state);

    List<AdNameDto> getRivAdNameDtoListByGroupIds(@Param("groupId") String groupId);

    List<PersCountDto> getRivCountyCountById(@Param("groupId") String groupId);

    List<PersCountDto> getRsCountByGroupId(@Param("groupId") String groupId,@Param("state") String state);

    List<AdNameDto> getPersAdFullNameDtoListByPersIds(@Param("persIds") String persIds);

    List<PersCountDto> getPersAllProCountByPersIds(@Param("objType") String objType,@Param("persIds") String persIds,
                                                   @Param("sttm") String sttm,@Param("entm") String entm,@Param("state") String state);
}