From ad5754d503c59c6a7d78925bac7fab758c185d22 Mon Sep 17 00:00:00 2001
From: liujie <1793218484@qq.com>
Date: 星期四, 26 二月 2026 11:47:06 +0800
Subject: [PATCH] Merge branch 'master' of http://120.76.84.145:10101/gitblit/r/java/Robotaxi

---
 xp-robotaxi-map-boot/src/main/java/com/xiaopeng/map/controller/XpPointManagementController.java |   63 +++++++++++++++++++++++++++++--
 1 files changed, 59 insertions(+), 4 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 44f970b..e6af9e5 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,26 +1,37 @@
 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.feignClient.operation.XpPointClient;
-import com.xiaopeng.api.model.operation.XpElectronicFence;
 import com.xiaopeng.api.model.operation.XpElectronicFenceArea;
 import com.xiaopeng.api.model.operation.XpPoint;
-import com.xiaopeng.api.query.operation.PointPageListQuery;
+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 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.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;
@@ -45,9 +56,53 @@
 
         return xpPointClient.listElectronicFenceArea();
     }
+    @ApiOperation(value = "点位管理分页列表", response = XpPoint.class)
+    @PostMapping("/pageList")
+    public R<PageInfo<XpPoint>> pageList(@RequestBody PointPageListListQuery query) {
+        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();
+            }
+        }
+
+    }
     @ApiOperation(value = "点位管理列表", response = XpPoint.class)
     @PostMapping("/list")
-    public R<List<XpPoint>> list(@RequestBody PointPageListQuery query) {
+    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);

--
Gitblit v1.7.1