<properties>
    <java.version>17</java.version>
    <spring-boot.version>3.5.11</spring-boot.version>
    <mybatis-plus.version>3.5.9</mybatis-plus.version>
    <poi-tl.version>1.12.2</poi-tl.version> <!-- 最新穩(wěn)定版 -->
</properties>

<dependencies>
    <!-- Spring Boot Web -->
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-web</artifactId>
    </dependency>

    <!-- MyBatis-Plus -->
    <dependency>
        <groupId>com.baomidou</groupId>
        <artifactId>mybatis-plus-spring-boot3-starter</artifactId>
        <version>${mybatis-plus.version}</version>
    </dependency>

    <!-- MySQL驅(qū)動(dòng) -->
    <dependency>
        <groupId>com.mysql</groupId>
        <artifactId>mysql-connector-j</artifactId>
        <scope>runtime</scope>
    </dependency>

    <!-- POI-TL (Word模板引擎) -->
    <dependency>
        <groupId>com.deepoove</groupId>
        <artifactId>poi-tl</artifactId>
        <version>${poi-tl.version}</version>
    </dependency>

    <!-- Apache POI (用于PPT導(dǎo)出) -->
    <dependency>
        <groupId>org.apache.poi</groupId>
        <artifactId>poi-ooxml</artifactId>
        <version>5.3.0</version>
    </dependency>

    <!-- 工具類(lèi) -->
    <dependency>
        <groupId>org.projectlombok</groupId>
        <artifactId>lombok</artifactId>
        <optional>true</optional>
    </dependency>
</dependencies>

server:
  port: 8080

spring:
  datasource:
    url: jdbc:mysql://localhost:3306/car_report_db?useUnicode=true&characterEncoding=utf8&serverTimezone=Asia/Shanghai
    username: root
    password: yourpassword
    driver-class-name: com.mysql.cj.jdbc.Driver

mybatis-plus:
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl # 開(kāi)發(fā)時(shí)打印SQL
  global-config:
    db-config:
      id-type: auto

CREATE DATABASE IF NOT EXISTS car_report_db DEFAULT CHARACTER SET utf8mb4;

USE car_report_db;

CREATE TABLE `car` (
    `id` BIGINT AUTO_INCREMENT COMMENT '主鍵ID',
    `brand` VARCHAR(50) NOT NULL COMMENT '品牌',
    `model` VARCHAR(50) NOT NULL COMMENT '車(chē)型',
    `price` DECIMAL(10,2) COMMENT '指導(dǎo)價(jià)(萬(wàn)元)',
    `engine` VARCHAR(100) COMMENT '發(fā)動(dòng)機(jī)',
    `max_power` INT COMMENT '最大功率(kW)',
    `max_torque` INT COMMENT '最大扭矩(N·m)',
    `acceleration` DECIMAL(3,1) COMMENT '百公里加速(s)',
    `fuel_consumption` DECIMAL(4,1) COMMENT '綜合油耗(L/100km)',
    `image_url` VARCHAR(255) COMMENT '圖片URL(用于PPT插入圖片)',
    `description` TEXT COMMENT '車(chē)型描述',
    `create_time` DATETIME DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='汽車(chē)信息表';

-- 插入測(cè)試數(shù)據(jù)
INSERT INTO `car` (`brand`, `model`, `price`, `engine`, `max_power`, `max_torque`, `acceleration`, `fuel_consumption`, `image_url`, `description`) VALUES
('寶馬', 'X5 xDrive40i', 75.99, '3.0T L6', 250, 450, 5.5, 9.1, 'https://cdn.simpleicons.org/bmw', '豪華中大型SUV，操控與舒適兼?zhèn)洹?),
('特斯拉', 'Model Y 長(zhǎng)續(xù)航版', 34.99, '純電動(dòng)', 331, 559, 5.0, 0.0, 'https://cdn.simpleicons.org/tesla', '純電動(dòng)SUV，續(xù)航持久，智能科技。'),
('奔馳', 'A6L 45 TFSI', 45.89, '2.0T L4', 180, 370, 7.5, 7.5, 'https://cdn.simpleicons.org/mercedes', '商務(wù)轎車(chē)典范，空間寬敞，科技感強(qiáng)。');

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.Data;

import java.math.BigDecimal;

@Data
@TableName("car")
public class Car {
    @TableId(type = IdType.AUTO)
    private Long id;
    private String brand;
    private String model;
    private BigDecimal price;
    private String engine;
    private Integer maxPower;
    private Integer maxTorque;
    private BigDecimal acceleration;
    private BigDecimal fuelConsumption;
    private String imageUrl;
    private String description;
}

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;

@Mapper
public interface CarMapper extends BaseMapper<Car> {
}

import jakarta.servlet.http.HttpServletResponse;

public interface ReportService {
    /**
     * 導(dǎo)出Word報(bào)告
     * @param carId 汽車(chē)ID
     * @param response HttpServletResponse用于輸出文件
     */
    void exportWord(Long carId, HttpServletResponse response);

    /**
     * 導(dǎo)出PPT報(bào)告
     * @param carId 汽車(chē)ID
     * @param response HttpServletResponse用于輸出文件
     */
    void exportPpt(Long carId, HttpServletResponse response);
}

import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.deepoove.poi.XWPFTemplate;
import com.deepoove.poi.data.PictureType;
import com.deepoove.poi.data.Pictures;
import com.deepoove.poi.data.Texts;
import com.deepoove.poi.data.style.Style;
import lombok.RequiredArgsConstructor;
import lombok.extern.slf4j.Slf4j;
import org.apache.poi.sl.usermodel.PictureData;
import org.apache.poi.xslf.usermodel.*;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.core.io.ClassPathResource;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import jakarta.servlet.http.HttpServletResponse;
import java.awt.*;
import java.io.*;
import java.net.URLEncoder;
import java.nio.charset.StandardCharsets;
import java.util.HashMap;
import java.util.Map;

@Slf4j
@Service
@RequiredArgsConstructor
public class ReportServiceImpl implements ReportService {

    private final CarMapper carMapper;

    @Value("${file.template-path:templates/}") // 模板存放路徑
    private String templatePath;

    @Override
    @Transactional(readOnly = true) // 只讀事務(wù)，提高數(shù)據(jù)庫(kù)性能
    public void exportWord(Long carId, HttpServletResponse response) {
        // 1. 查詢(xún)數(shù)據(jù)
        Car car = carMapper.selectById(carId);
        if (car == null) {
            throw new RuntimeException("汽車(chē)不存在");
        }

        // 2. 構(gòu)建數(shù)據(jù)模型（POI-TL要求的數(shù)據(jù)結(jié)構(gòu)）
        Map<String, Object> data = new HashMap<>();
        data.put("brand", car.getBrand());
        data.put("model", car.getModel());
        data.put("price", car.getPrice() + "萬(wàn)元");
        data.put("engine", car.getEngine());
        data.put("maxPower", car.getMaxPower() + "kW");
        data.put("maxTorque", car.getMaxTorque() + "N·m");
        data.put("acceleration", car.getAcceleration() + "秒");
        data.put("fuelConsumption", car.getFuelConsumption() + "L/100km");
        data.put("description", Texts.of(car.getDescription()).create());

        // 如果有圖片，處理圖片占位符 {{@image}} （假設(shè)圖片存在本地或網(wǎng)絡(luò)）
        if (car.getImageUrl() != null && !car.getImageUrl().isEmpty()) {
            try {
                // 這里簡(jiǎn)單地從類(lèi)路徑讀取圖片（實(shí)際生產(chǎn)應(yīng)從文件服務(wù)器或URL獲?。?
                InputStream imageStream = new ClassPathResource("static" + car.getImageUrl()).getInputStream();
                data.put("image", Pictures.ofStream(imageStream, PictureType.PNG)
                        .size(200, 150).create()); // 設(shè)置圖片寬高
            } catch (IOException e) {
                log.warn("圖片讀取失敗: {}", car.getImageUrl(), e);
                data.put("image", null);
            }
        }

        // 3. 加載模板并渲染
        try (InputStream templateStream = new ClassPathResource(templatePath + "car_report_template.docx").getInputStream();
             XWPFTemplate template = XWPFTemplate.compile(templateStream).render(data);
             OutputStream out = response.getOutputStream()) {

            // 4. 設(shè)置響應(yīng)頭
            setResponseHeader(response, "car_report_" + carId + ".docx");

            // 5. 寫(xiě)入輸出流
            template.write(out);
            out.flush();
        } catch (IOException e) {
            log.error("導(dǎo)出Word失敗，carId: {}", carId, e);
            throw new RuntimeException("導(dǎo)出Word失敗", e);
        }
    }

    @Override
    @Transactional(readOnly = true)
    public void exportPpt(Long carId, HttpServletResponse response) {
        // 1. 查詢(xún)數(shù)據(jù)
        Car car = carMapper.selectById(carId);
        if (car == null) {
            throw new RuntimeException("汽車(chē)不存在");
        }

        // 2. 加載PPT模板 (使用Apache POI)
        try (InputStream templateStream = new ClassPathResource(templatePath + "car_report_template.pptx").getInputStream();
             XMLSlideShow ppt = new XMLSlideShow(templateStream);
             OutputStream out = response.getOutputStream()) {

            // 3. 遍歷幻燈片，替換占位符
            for (XSLFSlide slide : ppt.getSlides()) {
                // 替換文本框內(nèi)容
                for (XSLFShape shape : slide.getShapes()) {
                    if (shape instanceof XSLFTextShape) {
                        XSLFTextShape textShape = (XSLFTextShape) shape;
                        String text = textShape.getText();
                        if (text != null) {
                            text = text.replace("{{brand}}", car.getBrand())
                                    .replace("{{model}}", car.getModel())
                                    .replace("{{price}}", car.getPrice() + "萬(wàn)元")
                                    .replace("{{engine}}", car.getEngine())
                                    .replace("{{maxPower}}", car.getMaxPower() + "kW")
                                    .replace("{{maxTorque}}", car.getMaxTorque() + "N·m")
                                    .replace("{{acceleration}}", car.getAcceleration() + "秒")
                                    .replace("{{fuelConsumption}}", car.getFuelConsumption() + "L/100km")
                                    .replace("{{description}}", car.getDescription());
                            textShape.setText(text);
                        }
                    }
                    // 如果是圖片占位符，插入圖片 (需要預(yù)先在模板中放置一個(gè)圖片，并識(shí)別它)
                    if (shape instanceof XSLFPictureShape) {
                        // 通常我們通過(guò)形狀名稱(chēng)來(lái)標(biāo)記占位圖片
                        if ("imagePlaceholder".equals(shape.getShapeName())) {
                            // 移除原圖片，添加新圖片（略復(fù)雜，此處僅演示思路）
                            // 實(shí)際應(yīng)用中建議用文本框占位，然后新建圖片
                        }
                    }
                }
            }

            // 4. 設(shè)置響應(yīng)頭
            setResponseHeader(response, "car_report_" + carId + ".pptx");

            // 5. 寫(xiě)入輸出流
            ppt.write(out);
            out.flush();
        } catch (IOException e) {
            log.error("導(dǎo)出PPT失敗，carId: {}", carId, e);
            throw new RuntimeException("導(dǎo)出PPT失敗", e);
        }
    }

    /**
     * 設(shè)置下載響應(yīng)頭
     */
    private void setResponseHeader(HttpServletResponse response, String filename) {
        response.setContentType("application/octet-stream");
        response.setCharacterEncoding(StandardCharsets.UTF_8.name());
        String encodedFilename = URLEncoder.encode(filename, StandardCharsets.UTF_8).replace("+", "%20");
        response.setHeader("Content-Disposition", "attachment; filename*=UTF-8''" + encodedFilename);
    }
}

import lombok.RequiredArgsConstructor;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import jakarta.servlet.http.HttpServletResponse;

@RestController
@RequestMapping("/api/report")
@RequiredArgsConstructor
public class ReportController {

    private final ReportService reportService;

    @GetMapping("/word/{carId}")
    public void exportWord(@PathVariable Long carId, HttpServletResponse response) {
        reportService.exportWord(carId, response);
    }

    @GetMapping("/ppt/{carId}")
    public void exportPpt(@PathVariable Long carId, HttpServletResponse response) {
        reportService.exportPpt(carId, response);
    }
}