门牌详情查询

guoshilong

2023-11-03 f56957785bc3fc4babad6b1d9c8ca69c95518e28

门牌详情查询

 src/main/java/org/springblade/modules/doorplateAddress/controller/DoorplateAddressController.java

@@ -168,4 +168,14 @@
        return R.data(list);
    }

    /**
     * 根据参数获取地址详情
     * @return
     */
    @GetMapping("/getDoorplateAddressDetail")
    public R getDoorplateAddressDetail(DoorplateAddressVO doorplateAddressVO){
        DoorplateAddressVO detail = doorplateAddressService.getDoorplateAddressDetail(doorplateAddressVO);
        return R.data(detail);
    }

}

 src/main/java/org/springblade/modules/doorplateAddress/mapper/DoorplateAddressMapper.java

@@ -18,6 +18,7 @@

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import liquibase.pro.packaged.P;
import org.apache.ibatis.annotations.Param;
import org.springblade.common.node.TreeNode;
import org.springblade.modules.doorplateAddress.entity.DoorplateAddressEntity;
@@ -115,4 +116,6 @@
     * @return
     */
    List<FuncNode> getDoorplateNameList(@Param("name") String name,@Param("code") String code);

    DoorplateAddressVO getDoorplateAddressDetail(@Param("vo") DoorplateAddressVO doorplateAddressVO);
}

 src/main/java/org/springblade/modules/doorplateAddress/mapper/DoorplateAddressMapper.xml

@@ -175,5 +175,17 @@
        and nei_code = #{name}
        and aoi_code is null
    </select>
    <select id="getDoorplateAddressDetail"
            resultType="org.springblade.modules.doorplateAddress.vo.DoorplateAddressVO">

    SELECT * FROM jczz_doorplate_address
    WHERE 1=1
    <if test="vo.stdId != null and vo.stdId != ''">
        AND address_code = #{vo.stdId}
    </if>
    <if test="vo.buildingCode != null and vo.buildingCode !='' ">
        AND building_code = #{vo.buildingCode}
    </if>
    </select>

</mapper>

 src/main/java/org/springblade/modules/doorplateAddress/service/IDoorplateAddressService.java

@@ -65,4 +65,6 @@
    Object getHouseRentInfo(String code);

    List<DoorplateAddressVOTree> getDoorplateAddressList(String code, String type);

    DoorplateAddressVO getDoorplateAddressDetail(DoorplateAddressVO doorplateAddressVO);
}

 src/main/java/org/springblade/modules/doorplateAddress/service/impl/DoorplateAddressServiceImpl.java

@@ -304,4 +304,12 @@

        return list;
    }

    @Override
    public DoorplateAddressVO getDoorplateAddressDetail(DoorplateAddressVO doorplateAddressVO) {

        DoorplateAddressVO detail = baseMapper.getDoorplateAddressDetail(doorplateAddressVO);

        return detail;
    }
}

 src/main/java/org/springblade/modules/doorplateAddress/vo/DoorplateAddressVO.java

@@ -24,4 +24,8 @@

    private List<HouseholdVO> householdList = new ArrayList<>();

    //对应address_code 或者 doorplate_address_code
    private String stdId;


}