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

package com.bofeng.dao;

import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.bofeng.entity.UptownUnit;
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;

@Mapper
@Repository
public interface UptownUnitMapper extends BaseMapper<UptownUnit> {

    @Select("select * from sys_uptown_unit where status = 1 and uptown_id = #{uptownId}")
    List<UptownUnit> getUptownUnitData(@Param("uptownId") Long uptownId);


    List<UptownUnit> queryDongList(@Param("uptownId") Long uptownId);

    List<UptownUnit> queryDanYuanList(@Param("uptownId") Long uptownId, @Param("ridgepole") Long ridgepole);

    List<UptownUnit> queryMenPaiList(@Param("uptownId") Long uptownId, @Param("ridgepole") Long ridgepole, @Param("unitId") Long unitId, @Param("reportDate") String reportDate);

    List<UptownUnit> queryXiaoQuList2(@Param("uptownId") Long uptownId, @Param("ridgepole") Long ridgepole, @Param("unitId") Long unitId);

    List<UptownUnit> queryYiBaoList2(@Param("uptownId") Long uptownId, @Param("ridgepole") Long ridgepole, @Param("unitId") Long unitId, @Param("reportDate") String reportDate);

    List<UptownUnit> queryYiChangList2(@Param("uptownId") Long uptownId, @Param("ridgepole") Long ridgepole, @Param("unitId") Long unitId, @Param("reportDate") String reportDate);

    List<UptownUnit> queryXiaoQuList(@Param("uptownId") Long uptownId);

    List<UptownUnit> queryYiBaoList(@Param("uptownId") Long uptownId, @Param("reportDate") String reportDate);

    List<UptownUnit> queryYiChangList(@Param("uptownId") Long uptownId, @Param("reportDate") String reportDate);

    @Select("SELECT u.uptown_id,u.uptown_name as uptownName,uu.ridgepole,uu.unit,uu.unit_id,uh.doorplate FROM sys_user_role ur INNER JOIN sys_uptown_house uh " +
            "ON uh.house_id = ur.property_id INNER JOIN sys_uptown_unit uu ON uh.unit_id = uu.unit_id INNER JOIN " +
            "sys_uptown u ON u.uptown_id = uu.uptown_id WHERE ur.user_id = #{userId} AND ur.role_id = 1")
    UptownUnit getUptownUnitByUser(@Param("userId") Long userId);

    @Select("select * from sys_uptown_unit where status = 1 and uptown_id = 1238790987234")
    List<UptownUnit> getUptownUnitLY();
}