Newer
Older
huludao / src / main / java / com / newfiber / api / pc / dao / RiverManage / ProblemLongTermErrMapper.java
package com.newfiber.api.pc.dao.RiverManage;

import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.newfiber.api.pc.model.River.PipeNetworkCount;
import com.newfiber.api.pc.model.River.ProblemLongTermErr;
import com.newfiber.api.pc.model.River.RiverCount;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * problemLongTermErr model层
 * 
 * @author luzhan
 */
@Repository
public interface ProblemLongTermErrMapper extends BaseMapper<ProblemLongTermErr> {

    /**
     * 通过报警id修改数据
     * @param errId
     * @param problemId
     * @param userNo
     * @param userName
     * @return
     */
    Integer updateErr(@Param("errId") Long errId,@Param("problemId") Long problemId,@Param("userNo")String userNo,@Param("userName")String userName);

    /**
     * 通过problemid修改状态
     * @param state
     * @param stateDesc
     * @param problemIds
     * @return
     */
    Integer updateState(@Param("state")int state, @Param("stateDesc")String stateDesc, @Param("problemIds")List<Long> problemIds);

    /**
     * 通过类型查找历史报警
     * @param type
     * @return
     */
    List<ProblemLongTermErr> selectListByType(@Param("type") String type);

    /**
     * 按分类统计管网的数量
     * @return
     */
    PipeNetworkCount pipeCount();

    /**
     * 查询正在报警黑臭水体的数量
     * @return
     */
    RiverCount noPassCount();

    /**
     * 查询所有黑臭水体数
     * @return
     */
    RiverCount allCount();
}