package com.newfiber.api.pc.dao.RiverManage;

import com.newfiber.api.pc.model.River.RiverChief;
import com.newfiber.api.pc.model.UserManager.SysUserInfo;
import java.util.List;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

/**
 * @author wmj
 * @version 创建时间：2017/11/24
 * @description 河长基础信息接口
 */
@Repository
public interface RiverChiefDao {

    int addRiverChief(@Param("chiefUserNo") String chiefUserNo,
                      @Param("chiefGrade") Integer chiefGrade,
                      @Param("chiefGradeZn") String chiefGradeZn,
                      @Param("chiefDuty") String chiefDuty,
                      @Param("riverNo") String riverNo);

    int updateRiverChief(@Param("chiefUserNo") String chiefUserNo,
                         @Param("chiefGrade") Integer chiefGrade,
                         @Param("chiefGradeZn") String chiefGradeZn,
                         @Param("chiefDuty") String chiefDuty,
                         @Param("riverNo") String riverNo);

    int deleteRiverChief(@Param("riverNo") String riverNo);

    List<RiverChief> selectRiverChiefList(@Param("pageNo") Integer pageNo,
                                          @Param("pageSize") Integer pageSize,
                                          @Param("chiefGrade") Integer chiefGrade,
                                          @Param("chiefUserNo") String chiefUserNo);

    int countRiverChiefList(@Param("chiefGrade") Integer chiefGrade,
                            @Param("chiefUserNo") String chiefUserNo);

    int countRiverChiefTotal(@Param("chiefGrade") Integer chiefGrade);
    
    int countRiverChief(String divisionNo);

    RiverChief selectGradeByUserNo(@Param("chiefUserNo") String chiefUserNo);

    List<RiverChief> selectRiverNoByListUserNo(@Param("list") List<String> list,
                                               @Param("riverGrade") Integer riverGrade);

    List<RiverChief> selectRiverChiefByRiverNo(@Param("riverNo") String riverNo);
    //获取下级河长
    List<String> getSubRiverChief(@Param("userNo") String userNo);
    List<SysUserInfo> getSubRiverChiefObj(@Param("userNo") String userNo);

    /**
     * @Description: 按照当前河长用户查询其所在河道编号
     * @param chiefUserNo
     * @return: java.lang.String
     * @Author: Wmj
     * @Date: 2018/12/15 10:37
     */
    String queryRiverNoByChiefUserNo(@Param("chiefUserNo") String chiefUserNo);

}