hust-epi/whepi-web/src/main/java/com/bofeng/dao/UptownDoorMapper.java

package com.bofeng.dao;

import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.bofeng.entity.UptownDoor;
import com.yvan.PageDb;
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;
import java.util.Map;

@Mapper
@Repository
public interface UptownDoorMapper extends BaseMapper<UptownDoor> {

    @Select("SELECT ud.door_id,u.uptown_id,u.uptown_name,ud.door_name FROM sys_uptown_door ud INNER JOIN " +
            "sys_uptown u ON u.uptown_id = ud.uptown_id WHERE ud.door_id = #{doorId} AND ud.STATUS = 1")
    UptownDoor getUptownDoorById(@Param("doorId") Long doorId);

    List<UptownDoor> getAllUptownDoor(PageDb pagination, Map<String, Object> map);

}