| New file |
| | |
|---|
| | | package com.panzhihua.service_community.dao; |
|---|
| | | |
|---|
| | | import java.util.List; |
|---|
| | | |
|---|
| | | import org.apache.ibatis.annotations.Mapper; |
|---|
| | | import org.apache.ibatis.annotations.Options; |
|---|
| | | import org.apache.ibatis.annotations.Select; |
|---|
| | | import org.apache.ibatis.mapping.StatementType; |
|---|
| | | |
|---|
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
|---|
| | | import com.panzhihua.common.model.dtos.community.ExcelHouseDTO; |
|---|
| | | import com.panzhihua.service_community.model.dos.ComMngStructHouseDO; |
|---|
| | | |
|---|
| | | /** |
|---|
| | | * @program: springcloud_k8s_panzhihuazhihuishequ |
|---|
| | | * @description: 房屋 |
|---|
| | | * @author: huang.hongfa weixin hhf9596 qq 959656820 |
|---|
| | | * @create: 2020-12-14 17:09 |
|---|
| | | **/ |
|---|
| | | @Mapper |
|---|
| | | public interface ComMngStructHouseDAO extends BaseMapper<ComMngStructHouseDO> { |
|---|
| | | @Select("{call smart_life.removeByParentCode(#{areaCode,jdbcType=VARCHAR,mode=IN})}") |
|---|
| | | @Options(statementType = StatementType.CALLABLE) |
|---|
| | | int batchDeleteHouse(String areaCode); |
|---|
| | | |
|---|
| | | @Select("<script> " + " SELECT REPLACE " + " ( h3.house_name, h4.house_name, '' ) build, " |
|---|
| | | + " REPLACE ( h2.house_name, h3.house_name, '' ) unit, " |
|---|
| | | + " REPLACE ( h1.house_name, h2.house_name, '' ) floor, " |
|---|
| | | + " REPLACE ( h.house_name, h1.house_name, '' ) room, " + " h.square, " + "CASE " + " h.state " |
|---|
| | | + " WHEN 1 THEN " + " '自住' " + " WHEN 2 THEN " + " '租住' " + " WHEN 3 THEN " + " '商用' ELSE '未知' " |
|---|
| | | + " END AS state, " + " su.NAME username, " + " su.phone " + "FROM " + " com_mng_struct_house h " |
|---|
| | | + " LEFT JOIN com_mng_struct_house h1 ON h.parent_code = h1.house_code " |
|---|
| | | + " LEFT JOIN com_mng_struct_house h2 ON h1.parent_code = h2.house_code " |
|---|
| | | + " LEFT JOIN com_mng_struct_house h3 ON h2.parent_code = h3.house_code " |
|---|
| | | + " LEFT JOIN com_mng_struct_house h4 ON h3.parent_code = h4.house_code " |
|---|
| | | + " LEFT JOIN com_mng_struct_house_user hu ON h.house_code = hu.house_code " |
|---|
| | | + " LEFT JOIN sys_user su ON hu.user_id = su.user_id " + "WHERE " |
|---|
| | | + " h.house_code LIKE concat(#{houseCode},'%') " + " AND h.type = 5" + " ORDER BY h.house_code ASC " |
|---|
| | | + "</script> ") |
|---|
| | | List<ExcelHouseDTO> houseExport(String houseCode); |
|---|
| | | } |
|---|
