package api.dao;

import api.bean.LampEntity;
import api.bean.SinglelampDataEntity;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * @author van
 * @version 1.0
 * msg：
 * @date 2021/12/16 15:56
 */

@Mapper
@Repository
public interface SinglelampDataDao {
    /**超级管理员查找全部*/
    List<SinglelampDataEntity> selectAll();
    /**普通管理员按公司查找*/
    List<SinglelampDataEntity> selectByCompany(@Param("page") Integer page, @Param("size") Integer size,@Param("userId") Long userId);
    /**用户查找*/
    //List<SinglelampDataEntity> selectByUserId(Long userId);
    /**单个灯杆数据*/
    List<SinglelampDataEntity> selectByStreetlightId(String mac);

    @Select("select count(*) from pole_streetlight ps where ps.streetlight_id in(select pus.streetlight_id from pole_user_streetlight pus where pus.company_id in(select suc.company_id from sys_user_company suc where suc.user_id=#{userId}))")
    Integer countByCompany(@Param("userId") Long userId);
}