From b3b566ebdfed4005aaa513da3d5d2fd3924903cc Mon Sep 17 00:00:00 2001
From: linwei <872216696@qq.com>
Date: Wed, 31 Jan 2024 16:17:54 +0800
Subject: [PATCH] 拿不到地址总表数据，不设置网格信息
---
src/main/java/org/springblade/modules/house/controller/HouseController.java | 98 +++++++++++++++++++++++++++++++++++++++++-------
1 files changed, 83 insertions(+), 15 deletions(-)
diff --git a/src/main/java/org/springblade/modules/house/controller/HouseController.java b/src/main/java/org/springblade/modules/house/controller/HouseController.java
index be0e434..b4351ac 100644
--- a/src/main/java/org/springblade/modules/house/controller/HouseController.java
+++ b/src/main/java/org/springblade/modules/house/controller/HouseController.java
@@ -16,36 +16,35 @@
*/
package org.springblade.modules.house.controller;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.github.xiaoymin.knife4j.annotations.ApiOperationSupport;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import io.swagger.annotations.ApiParam;
-import com.github.xiaoymin.knife4j.annotations.ApiOperationSupport;
import lombok.AllArgsConstructor;
-
-import javax.servlet.http.HttpServletResponse;
-import javax.validation.Valid;
-
+import org.springblade.core.boot.ctrl.BladeController;
import org.springblade.core.excel.util.ExcelUtil;
import org.springblade.core.mp.support.Condition;
import org.springblade.core.mp.support.Query;
import org.springblade.core.tool.api.R;
import org.springblade.core.tool.utils.DateUtil;
import org.springblade.core.tool.utils.Func;
-import org.springblade.modules.house.excel.HouseImporter;
-import org.springblade.modules.house.vo.HouseParam;
-import org.springblade.modules.house.excel.HouseExcel;
-import org.springblade.modules.system.excel.UserExcel;
-import org.springblade.modules.system.excel.UserImporter;
-import org.springframework.web.bind.annotation.*;
-import com.baomidou.mybatisplus.core.metadata.IPage;
import org.springblade.modules.house.entity.HouseEntity;
+import org.springblade.modules.house.excel.HouseAndHoldExcel;
+import org.springblade.modules.house.excel.HouseAndHoldImporter;
+import org.springblade.modules.house.excel.HouseExcel;
+import org.springblade.modules.house.excel.HouseImporter;
+import org.springblade.modules.house.service.IHouseService;
+import org.springblade.modules.house.vo.HouseParam;
import org.springblade.modules.house.vo.HouseVO;
import org.springblade.modules.house.wrapper.HouseWrapper;
-import org.springblade.modules.house.service.IHouseService;
-import org.springblade.core.boot.ctrl.BladeController;
+import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;
+import javax.servlet.http.HttpServletResponse;
+import javax.validation.Valid;
import java.util.List;
+import java.util.Map;
/**
* 房屋 控制器
@@ -103,6 +102,28 @@
@ApiOperation(value = "分页", notes = "传入house")
public R<IPage<HouseVO>> page(HouseVO house, Query query) {
IPage<HouseVO> pages = houseService.selectHousePage(Condition.getPage(query), house);
+ return R.data(pages);
+ }
+
+ /**
+ * 房屋标签统计
+ */
+ @GetMapping("/labelStatistics")
+ @ApiOperationSupport(order = 3)
+ @ApiOperation(value = "房屋标签统计")
+ public R labelStatistics(HouseVO house) {
+ List<Map<String, Object>> pages = houseService.labelStatistics( house);
+ return R.data(pages);
+ }
+
+ /**
+ * 房屋标签区域统计
+ */
+ @GetMapping("/labelCommunityStatistics")
+ @ApiOperationSupport(order = 3)
+ @ApiOperation(value = "房屋标签区域统计")
+ public R labelCommunityStatistics(HouseVO house) {
+ List<Map<String, Object>> pages = houseService.labelCommunityStatistics( house);
return R.data(pages);
}
@@ -172,7 +193,7 @@
/**
* 导入房屋
*/
- @GetMapping("import-house")
+ @PostMapping("import-house")
public R importHouse(MultipartFile file, Integer isCovered) {
HouseImporter houseImporter = new HouseImporter(houseService, isCovered == 1);
ExcelUtil.save(file, houseImporter, HouseExcel.class);
@@ -190,4 +211,51 @@
}
+ /**
+ * 导入房屋及住户/租户人员数据
+ */
+ @PostMapping("import-houseAndHold")
+ public R importHouseAndHold(MultipartFile file, Integer isCovered) {
+ HouseAndHoldImporter houseImporter = new HouseAndHoldImporter(houseService, isCovered == 1);
+ ExcelUtil.save(file, houseImporter, HouseAndHoldExcel.class);
+ return R.success("操作成功");
+ }
+
+
+ @GetMapping("getHouseStatistics")
+ public R getHouseStatistics(@RequestParam("code") String code,
+ @RequestParam("roleType") String roleType,
+ @RequestParam(value = "aoiCode", required = false) String aoiCode,
+ @RequestParam(value = "buildingCode", required = false) String buildingCode,
+ @RequestParam(value = "unitCode", required = false) String unitCode) {
+ Map<String, Object> result = houseService.getHouseStatistics(code, roleType, aoiCode, buildingCode, unitCode);
+ return R.data(result);
+ }
+
+ /**
+ * 通过小区id查询小区的栋
+ *
+ * @param districtCode
+ * @return
+ */
+ @GetMapping("/getHouseBuilding")
+ @ApiOperation(value = "通过小区id查询小区的栋", notes = "传入小区id")
+ public R<List<String>> getHouseBuilding(@RequestParam("districtCode") String districtCode) {
+ List<String> detail = houseService.getHouseBuilding(districtCode);
+ return R.data(detail);
+ }
+
+ /**
+ * 通过小区id查询小区的单元
+ *
+ * @param districtCode
+ * @return
+ */
+ @GetMapping("/getHouseUnit")
+ @ApiOperation(value = "通过小区id查询小区的单元", notes = "传入小区id")
+ public R<List<String>> getHouseUnit(@RequestParam("districtCode") String districtCode, @RequestParam("building") String building) {
+ List<String> detail = houseService.getHouseUnit(districtCode, building);
+ return R.data(detail);
+ }
+
}
--
Gitblit v1.9.3