From e8cd57fc46fa84b0c095f7e93cb348c014d06eb4 Mon Sep 17 00:00:00 2001
From: puzhibing <393733352@qq.com>
Date: 星期六, 07 三月 2026 21:00:03 +0800
Subject: [PATCH] 新增管理后台接口，修改小程序流程bug及其他相关功能
---
xp-robotaxi-map-boot/src/main/java/com/xiaopeng/map/controller/XpPointManagementController.java | 178 +++++++++++++++++++++++++++++++++--------------------------
1 files changed, 100 insertions(+), 78 deletions(-)
diff --git a/xp-robotaxi-map-boot/src/main/java/com/xiaopeng/map/controller/XpPointManagementController.java b/xp-robotaxi-map-boot/src/main/java/com/xiaopeng/map/controller/XpPointManagementController.java
index 6d8109b..aec3ca1 100644
--- a/xp-robotaxi-map-boot/src/main/java/com/xiaopeng/map/controller/XpPointManagementController.java
+++ b/xp-robotaxi-map-boot/src/main/java/com/xiaopeng/map/controller/XpPointManagementController.java
@@ -1,34 +1,45 @@
package com.xiaopeng.map.controller;
+import cn.afterturn.easypoi.excel.ExcelExportUtil;
+import cn.afterturn.easypoi.excel.entity.ExportParams;
import com.xiaopeng.api.dto.operation.PointAddDto;
import com.xiaopeng.api.dto.operation.PointUpdateDto;
import com.xiaopeng.api.dto.operation.XpPointEnableDisableDto;
-import com.xiaopeng.api.model.operation.XpElectronicFence;
+import com.xiaopeng.api.feignClient.operation.XpPointClient;
import com.xiaopeng.api.model.operation.XpElectronicFenceArea;
import com.xiaopeng.api.model.operation.XpPoint;
import com.xiaopeng.api.query.operation.PointListQuery;
import com.xiaopeng.api.query.operation.PointPageListListQuery;
import com.xiaopeng.common.core.domain.R;
+import com.xiaopeng.common.core.utils.WebUtils;
import com.xiaopeng.common.core.web.controller.BaseController;
import com.xiaopeng.common.core.web.page.PageInfo;
+import com.xiaopeng.common.security.service.TokenService;
+import com.xiaopeng.map.exportExcel.XpPointExportExcel;
import com.xiaopeng.api.dto.map.XpPointExportExcelQuery;
-import com.xiaopeng.map.service.XpElectronicFenceAreaService;
-import com.xiaopeng.map.service.XpElectronicFenceService;
-import com.xiaopeng.map.service.XpPointService;
+import io.seata.spring.annotation.GlobalTransactional;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import lombok.extern.slf4j.Slf4j;
-import org.springframework.beans.BeanUtils;
+import org.apache.poi.ss.usermodel.Workbook;
+import org.apache.shardingsphere.transaction.annotation.ShardingSphereTransactionType;
+import org.apache.shardingsphere.transaction.core.TransactionType;
+import org.springframework.transaction.annotation.Transactional;
+import org.springframework.util.StringUtils;
import org.springframework.validation.annotation.Validated;
import org.springframework.web.bind.annotation.*;
import javax.annotation.Resource;
+import javax.servlet.ServletOutputStream;
+import javax.servlet.http.HttpServletResponse;
+import java.io.IOException;
+import java.net.URLEncoder;
+import java.time.format.DateTimeFormatter;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.List;
import java.util.stream.Collectors;
-
@Slf4j
@RestController
@@ -37,115 +48,126 @@
public class XpPointManagementController extends BaseController {
@Resource
- private XpPointService xpPointService;
+ private XpPointClient xpPointClient;
+
@Resource
- private XpElectronicFenceAreaService xpElectronicFenceAreaService;
- @Resource
- private XpElectronicFenceService xpElectronicFenceService;
+ private TokenService tokenService;
@ApiOperation(value = "获取所有运营中的区域", response = XpElectronicFenceArea.class)
@PostMapping("/listElectronicFenceArea")
public R<List<XpElectronicFenceArea>> listElectronicFenceArea() {
- // 获取所有启用的电子围栏
- List<XpElectronicFence> electronicFences = xpElectronicFenceService.lambdaQuery()
- .eq(XpElectronicFence::getStatus, 2).list();
- List<Long> electronicFenceIds = electronicFences.stream().map(XpElectronicFence::getId).collect(Collectors.toList());
- if (electronicFenceIds.isEmpty()) {
- return R.ok(new ArrayList<XpElectronicFenceArea>());
- }
- // 获取电子围栏下启用的运营区域
- List<XpElectronicFenceArea> electronicFenceAreaList = xpElectronicFenceAreaService.lambdaQuery().in(XpElectronicFenceArea::getElectronicId, electronicFenceIds)
- .eq(XpElectronicFenceArea::getAreaStatus, 1).list();
- return R.ok(electronicFenceAreaList);
- }
+ R<List<XpElectronicFenceArea>> listR = xpPointClient.listElectronicFenceArea();
- @ApiOperation(value = "点位管理列表", response = XpPoint.class)
- @PostMapping("/list")
- public R<List<XpPoint>> list(@RequestBody PointListQuery query) {
- List<XpPoint> pageList = xpPointService.listAll(query);
- return R.ok(pageList);
- }
+ return listR;
+ }
@ApiOperation(value = "点位管理分页列表", response = XpPoint.class)
@PostMapping("/pageList")
public R<PageInfo<XpPoint>> pageList(@RequestBody PointPageListListQuery query) {
- PageInfo<XpPoint> pageList = xpPointService.pageList(query);
- return R.ok(pageList);
+ return xpPointClient.pageList(query);
}
+ @ApiOperation(value = "点位导出")
+ @PostMapping(value = "/exportExcel")
+ public void exportExcel(@RequestBody XpPointExportExcelQuery query) {
+ List<XpPoint> exportList = xpPointClient.getByIds(query).getData();
+ List<XpPointExportExcel> xpPointExportExcels = new ArrayList<>();
+ for (XpPoint xpPoint : exportList) {
+ XpPointExportExcel xpPointExportExcel = new XpPointExportExcel();
+ xpPointExportExcel.setPointNumber(xpPoint.getPointNumber());
+ xpPointExportExcel.setPointName(xpPoint.getPointName());
+ xpPointExportExcel.setStatus(xpPoint.getOperationStatus());
+ xpPointExportExcel.setParkingTimeLimit(xpPoint.getParkingTimeLimit()+"分钟");
+ xpPointExportExcel.setPointLon(xpPoint.getPointLon());
+ xpPointExportExcel.setPointLat(xpPoint.getPointLat());
+ xpPointExportExcel.setCreateBy(xpPoint.getCreateBy());
+ xpPointExportExcel.setCreateTime(xpPoint.getCreateTime().format(DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss")));
+ xpPointExportExcels.add(xpPointExportExcel);
+ }
+ //1.获取excel模板
+ Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams(), XpPointExportExcel.class, xpPointExportExcels);
+ HttpServletResponse response = WebUtils.response();
+ response.setContentType("application/vnd.ms-excel");
+ response.setCharacterEncoding("utf-8");
+ ServletOutputStream outputStream = null;
+ try {
+ String fileName = URLEncoder.encode("点位列表.csv", "utf-8");
+ response.setHeader("Content-dispodition", "attachment;filename=" + fileName);
+ outputStream = response.getOutputStream();
+ workbook.write(outputStream);
+ } catch (IOException e) {
+ e.printStackTrace();
+ } finally {
+ try {
+ outputStream.close();
+ } catch (IOException e) {
+ e.printStackTrace();
+ }
+ }
- @PostMapping("/getByIds")
- public R<List<XpPoint>> getByIds(@RequestBody XpPointExportExcelQuery query) {
- List<XpPoint> list = xpPointService.lambdaQuery().in(XpPoint::getId, query.getPointIds()).list();
- return R.ok(list);
}
-
+ @ApiOperation(value = "点位管理列表", response = XpPoint.class)
+ @PostMapping("/list")
+ public R<List<XpPoint>> list(@RequestBody PointListQuery query) {
+ if (StringUtils.hasLength(query.getOperationStatus())){
+ List<Integer> operationStatusIds = Arrays.stream(query.getOperationStatus().split(",")).map(Integer::parseInt).collect(Collectors.toList());
+ query.setOperationStatusIds(operationStatusIds);
+ }
+ return xpPointClient.list( query);
+ }
/**
* 新增点位
*/
- @PostMapping("/add")
- @ResponseBody
- @ApiOperation(value = "新增点位")
-// @Transactional
-// @ShardingSphereTransactionType(TransactionType.BASE)
- public R<XpPoint> add(@Validated @RequestBody PointAddDto pointAddDto) {
- return R.ok(xpPointService.addPointWithGeneratedNumber(pointAddDto));
- }
+ @PostMapping("/add")
+ @ApiOperation(value = "新增点位")
+ @Transactional
+ @ShardingSphereTransactionType(TransactionType.BASE)
+ public R add(@Validated @RequestBody PointAddDto pointAddDto) {
+ xpPointClient.add(pointAddDto);
+ return R.ok();
+ }
+ /**
+ * 编辑点位
+ */
+ @PostMapping("/edit")
+ @Transactional
+ @ShardingSphereTransactionType(TransactionType.BASE)
+ @ApiOperation(value = "编辑点位")
+ public R edit(@Validated@RequestBody PointUpdateDto pointAddDto) {
+ xpPointClient.edit(pointAddDto);
+ return R.ok();
+ }
/**
* 批量删除点位
*/
@GetMapping("/deletePoint")
@ResponseBody
@ApiOperation(value = "删除点位")
-// @Transactional
-// @ShardingSphereTransactionType(TransactionType.BASE)
+ @Transactional
+ @ShardingSphereTransactionType(TransactionType.BASE)
public R deletePoint(@RequestParam("ids") String ids) {
- xpPointService.removeBatchByIds(Arrays.stream(ids.split(",")).map(Long::parseLong).collect(Collectors.toList()));
+ xpPointClient.deletePoint(ids);
return R.ok();
}
-
/**
* 编辑点位
*/
- @PostMapping("/edit")
- @ApiOperation(value = "编辑点位")
-// @Transactional
-// @ShardingSphereTransactionType(TransactionType.BASE)
- public R edit(@Validated @RequestBody PointUpdateDto pointAddDto) {
- XpPoint xpPoint = xpPointService.getById(pointAddDto.getId());
- //先删除原有的数据，因为会存在点位的从属区域变化的情况，所以先删除原有的数据后添加新的数据重新分片到新的库中
- xpPointService.removeById(pointAddDto.getId());
- BeanUtils.copyProperties(pointAddDto, xpPoint);
- xpPoint.setId(null);
- xpPointService.save(xpPoint);
- return R.ok();
- }
-
- /**
- * 点位详情
- */
- @GetMapping("/api/v1/point/queryById")
+ @GetMapping("/queryById")
+ @ResponseBody
@ApiOperation(value = "点位详情")
- public R<XpPoint> queryById(@RequestParam Long id) {
- return R.ok(xpPointService.getById(id));
+ public R queryById(@RequestParam Long id) {
+ return xpPointClient.queryById( id);
}
-
/**
* 启用/禁用
*/
@PostMapping("/enableDisable")
+ @ResponseBody
@ApiOperation(value = "启用/禁用")
-// @Transactional
-// @ShardingSphereTransactionType(TransactionType.BASE)
+ @Transactional
+ @ShardingSphereTransactionType(TransactionType.BASE)
public R enableDisable(@RequestBody XpPointEnableDisableDto dto) {
- XpPoint xpPoint = xpPointService.getById(dto.getId());
- xpPoint.setOperationStatus(dto.getOperationStatus());
- xpPoint.setVerificationStatus(dto.getVerificationStatus());
- xpPoint.setElectronicAreaId(null);
- xpPointService.updateById(xpPoint);
- return R.ok();
+ return xpPointClient.enableDisable(dto);
}
-
-
}
--
Gitblit v1.7.1