package cn.com.goldenwater.dcproj.dao;

import cn.com.goldenwater.core.persistence.CrudDao;
import cn.com.goldenwater.dcproj.dto.TacCountDto;
import cn.com.goldenwater.dcproj.model.TacPblmInfo;
import cn.com.goldenwater.dcproj.model.TacWorkerB;
import cn.com.goldenwater.dcproj.param.TacInspYearBatchAreaParam;
import cn.com.goldenwater.dcproj.param.TacPblmInfoParam;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.Collection;
import java.util.List;

@Repository
public interface TacPblmInfoDao extends CrudDao<TacPblmInfo, TacPblmInfoParam> {

    Integer getPblmCountByYear(TacPblmInfoParam pblmInfoParam);

    String getMaxSn(@Param("province") String province);

    List<TacCountDto> countPblmInfoByType(TacPblmInfoParam pblmInfoParam);

    List<TacCountDto> countPblmInfoBySub(TacPblmInfoParam pblmInfoParam);

    List<TacCountDto> countPblmInfoBySubNew(TacPblmInfoParam pblmInfoParam);

    List<TacCountDto> countPblmInfoByAdCode(TacPblmInfoParam pblmInfoParam);

    List<TacCountDto> countPblmInfoByAdCodeNew(TacPblmInfoParam pblmInfoParam);

    List<TacCountDto> countPblmInfoByObjTypeNew(TacPblmInfoParam pblmInfoParam);

    List<TacCountDto> countPblmInfoByStb(TacPblmInfoParam pblmInfoParam);

    List<TacCountDto> countPblmInfoByStbZjNew(TacPblmInfoParam pblmInfoParam);

    List<TacPblmInfo> findPblmList(TacPblmInfoParam pblmInfoParam);

    List<TacPblmInfo> findListBy(TacPblmInfoParam pblmInfoParam);

    List<TacCountDto> countPblmInfoByCase(TacPblmInfoParam pblmInfoParam);

    List<TacCountDto> countPblmInfoByQlttv(TacPblmInfoParam pblmInfoParam);

    List<TacPblmInfo> findPageInfoNew(TacPblmInfoParam pblmInfoParam);

    List<TacPblmInfo> findProvincePblmInfo(TacPblmInfoParam pblmInfoParam);

    List<TacPblmInfo> findPageInfoNew2(TacPblmInfoParam pblmInfoParam);

    List<TacPblmInfo> findPageInfoZLorTPY(TacPblmInfoParam pblmInfoParam);

    List<TacPblmInfo> findPageJieduanInfo(TacPblmInfoParam pblmInfoParam);

    List<TacPblmInfo> findPageJieduanZLorTPY(TacPblmInfoParam pblmInfoParam);


    List<TacPblmInfo> findListByYearBatch(@Param("state") String state,
                                          @Param("year") Long year,
                                          @Param("batch") Long batch,
                                          @Param("orgId") String orgId);

    Integer countIfCasePblm(TacPblmInfoParam pblmInfoParam);

    Integer countIfCasePblmNew(TacPblmInfoParam pblmInfoParam);

    List<TacCountDto> countPblmInfoByQt(TacPblmInfoParam pblmInfoParam);

    List<TacCountDto> countPblmInfoByQtNew(TacPblmInfoParam pblmInfoParam);

    List<TacCountDto> countPblmInfoObjByQt(TacPblmInfoParam pblmInfoParam);

    List<TacCountDto> countPblmInfoObjByQtNew(TacPblmInfoParam pblmInfoParam);

    List<TacCountDto> countAdNameByAdAdCade(TacInspYearBatchAreaParam batchAreaParam);

    List<TacCountDto> countPblmInfoByObj(TacPblmInfoParam pblmInfoParam);

    List<String> getLeaderId(@Param("id") String id);
}