math_cms/app/Services/ExamPdfExportService.php

<?php

namespace App\Services;

use App\DTO\ExamAnalysisDataDto;
use App\DTO\ReportPayloadDto;
use App\Models\Paper;
use App\Models\PaperQuestion;
use App\Models\Student;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\File;
use Illuminate\Support\Facades\Http;
use Illuminate\Support\Facades\Log;
use Illuminate\Support\Facades\Storage;
use Illuminate\Support\Facades\URL;
use Symfony\Component\Process\Exception\ProcessSignaledException;
use Symfony\Component\Process\Exception\ProcessTimedOutException;
use Symfony\Component\Process\Process;

/**
 * PDF导出服务（重构版）
 * 负责生成试卷PDF、判卷PDF和学情报告PDF
 */
class ExamPdfExportService
{
    public function __construct(
        private readonly LearningAnalyticsService $learningAnalyticsService,
        private readonly QuestionBankService $questionBankService,
        private readonly QuestionServiceApi $questionServiceApi,
        private readonly PdfStorageService $pdfStorageService,
        private readonly MasteryCalculator $masteryCalculator,
        private readonly PdfMerger $pdfMerger
    ) {}

    /**
     * 生成试卷 PDF（不含答案）
     */
    public function generateExamPdf(string $paperId): ?string
    {
        Log::info('generateExamPdf 开始：', ['paper_id' => $paperId]);
        $url = $this->renderAndStoreExamPdf($paperId, includeAnswer: false, suffix: 'exam');
        Log::info('generateExamPdf url 生成结果：', ['paper_id' => $paperId, 'url' => $url]);
        // 如果生成成功，将 URL 写入数据库
        if ($url) {
            $this->savePdfUrlToDatabase($paperId, 'exam_pdf_url', $url);
        }

        return $url;
    }

    /**
     * 生成判卷 PDF（含答案与解析）
     */
    public function generateGradingPdf(string $paperId): ?string
    {
        Log::info('generateGradingPdf 开始：', ['paper_id' => $paperId]);
        $url = $this->renderAndStoreExamPdf($paperId, includeAnswer: true, suffix: 'grading', useGradingView: true);
        Log::info('generateGradingPdf url 生成结果：', ['paper_id' => $paperId, 'url' => $url]);
        // 如果生成成功，将 URL 写入数据库
        if ($url) {
            $this->savePdfUrlToDatabase($paperId, 'grading_pdf_url', $url);
        }

        return $url;
    }

    /**
     * 生成合并PDF（试卷 + 判卷）
     * 先分别生成两个PDF，然后合并
     */
    public function generateMergedPdf(string $paperId): ?string
    {
        Log::info('generateMergedPdf 开始：', ['paper_id' => $paperId]);

        $tempDir = storage_path("app/temp");
        if (!is_dir($tempDir)) {
            mkdir($tempDir, 0755, true);
        }

        $examPdfPath = null;
        $gradingPdfPath = null;
        $mergedPdfPath = null;

        try {
            // 先生成试卷PDF
            $examPdfUrl = $this->generateExamPdf($paperId);
            if (!$examPdfUrl) {
                Log::error('ExamPdfExportService: 生成试卷PDF失败', ['paper_id' => $paperId]);
                return null;
            }

            // 再生成判卷PDF
            $gradingPdfUrl = $this->generateGradingPdf($paperId);
            if (!$gradingPdfUrl) {
                Log::error('ExamPdfExportService: 生成判卷PDF失败', ['paper_id' => $paperId]);
                return null;
            }

            // 【修复】下载PDF文件到本地临时目录
            Log::info('开始下载PDF文件到本地', [
                'exam_url' => $examPdfUrl,
                'grading_url' => $gradingPdfUrl
            ]);

            $examPdfPath = $tempDir . "/{$paperId}_exam.pdf";
            $gradingPdfPath = $tempDir . "/{$paperId}_grading.pdf";

            // 下载试卷PDF
            $examContent = Http::get($examPdfUrl)->body();
            if (empty($examContent)) {
                Log::error('ExamPdfExportService: 下载试卷PDF失败', ['url' => $examPdfUrl]);
                return null;
            }
            file_put_contents($examPdfPath, $examContent);

            // 下载判卷PDF
            $gradingContent = Http::get($gradingPdfUrl)->body();
            if (empty($gradingContent)) {
                Log::error('ExamPdfExportService: 下载判卷PDF失败', ['url' => $gradingPdfUrl]);
                return null;
            }
            file_put_contents($gradingPdfPath, $gradingContent);

            Log::info('PDF文件下载完成', [
                'exam_size' => filesize($examPdfPath),
                'grading_size' => filesize($gradingPdfPath)
            ]);

            // 合并PDF文件
            $mergedPdfPath = $tempDir . "/{$paperId}_merged.pdf";
            $merged = $this->pdfMerger->merge([$examPdfPath, $gradingPdfPath], $mergedPdfPath);

            if (!$merged) {
                Log::error('ExamPdfExportService: PDF文件合并失败', [
                    'tool' => $this->pdfMerger->getMergeTool()
                ]);
                return null;
            }

            // 读取合并后的PDF内容并上传到云存储
            $mergedPdfContent = file_get_contents($mergedPdfPath);
            $path = "exams/{$paperId}_all.pdf";
            $mergedUrl = $this->pdfStorageService->put($path, $mergedPdfContent);

            if (!$mergedUrl) {
                Log::error('ExamPdfExportService: 保存合并PDF失败', ['path' => $path]);
                return null;
            }

            // 保存到数据库的all_pdf_url字段
            $this->saveAllPdfUrlToDatabase($paperId, $mergedUrl);

            Log::info('generateMergedPdf 完成：', [
                'paper_id' => $paperId,
                'url' => $mergedUrl,
                'tool' => $this->pdfMerger->getMergeTool()
            ]);
            return $mergedUrl;

        } catch (\Throwable $e) {
            Log::error('ExamPdfExportService: 生成合并PDF失败', [
                'paper_id' => $paperId,
                'error' => $e->getMessage(),
                'trace' => $e->getTraceAsString(),
            ]);
            return null;
        } finally {
            // 【修复】清理临时文件
            $tempFiles = [$examPdfPath, $gradingPdfPath, $mergedPdfPath];
            foreach ($tempFiles as $file) {
                if ($file && file_exists($file)) {
                    @unlink($file);
                }
            }
            Log::debug('清理临时文件完成');
        }
    }

    /**
     * 将URL转换为本地文件路径
     */
    private function convertUrlToPath(string $url): ?string
    {
        // 如果是本地存储，URL格式类似：/storage/exams/paper_id_exam.pdf
        // 需要转换为绝对路径
        if (strpos($url, '/storage/') === 0) {
            return public_path(ltrim($url, '/'));
        }

        // 如果是完整路径，直接返回
        if (strpos($url, '/') === 0 && file_exists($url)) {
            return $url;
        }

        // 如果是相对路径，转换为绝对路径
        $path = public_path($url);
        if (file_exists($path)) {
            return $path;
        }

        return null;
    }

    /**
     * 保存合并PDF URL到数据库
     */
    private function saveAllPdfUrlToDatabase(string $paperId, string $url): void
    {
        try {
            \App\Models\Paper::where('paper_id', $paperId)->update([
                'all_pdf_url' => $url
            ]);
            Log::debug('保存all_pdf_url成功', ['paper_id' => $paperId, 'url' => $url]);
        } catch (\Exception $e) {
            Log::error('保存all_pdf_url失败', [
                'paper_id' => $paperId,
                'url' => $url,
                'error' => $e->getMessage()
            ]);
            throw $e;
        }
    }


    /**
     * 生成学情分析 PDF
     */
    public function generateAnalysisReportPdf(string $paperId, string $studentId, ?string $recordId = null): ?string
    {
        if (function_exists('set_time_limit')) {
            @set_time_limit(240);
        }

        try {
            // 【调试】打印输入参数
            Log::info('ExamPdfExportService: 开始生成学情分析PDF', [
                'paper_id' => $paperId,
                'student_id' => $studentId,
                'record_id' => $recordId,
            ]);

            // 构建分析数据
            $analysisData = $this->buildAnalysisData($paperId, $studentId);
            if (!$analysisData) {
                Log::warning('ExamPdfExportService: buildAnalysisData返回空数据', [
                    'paper_id' => $paperId,
                    'student_id' => $studentId,
                ]);
                return null;
            }

            Log::info('ExamPdfExportService: buildAnalysisData返回数据', [
                'paper_id' => $paperId,
                'student_id' => $studentId,
                'analysisData_keys' => array_keys($analysisData),
                'mastery_count' => count($analysisData['mastery']['items'] ?? []),
                'questions_count' => count($analysisData['questions'] ?? []),
            ]);

            // 创建DTO
            $dto = ExamAnalysisDataDto::fromArray($analysisData);
            $payloadDto = ReportPayloadDto::fromExamAnalysisDataDto($dto);

            // 【调试】打印传给模板的数据
            $templateData = $payloadDto->toArray();
            Log::info('ExamPdfExportService: 传给模板的数据', [
                'paper' => $templateData['paper'] ?? null,
                'student' => $templateData['student'] ?? null,
                'mastery' => $templateData['mastery'] ?? null,
                'parent_mastery_levels' => $templateData['parent_mastery_levels'] ?? null, // 新增：检查父节点掌握度
                'questions_count' => count($templateData['questions'] ?? []),
                'insights_count' => count($templateData['question_insights'] ?? []),
                'recommendations_count' => count($templateData['recommendations'] ?? []),
            ]);

            // 渲染HTML
            $html = view('exam-analysis.pdf-report', $templateData)->render();
            if (!$html) {
                Log::error('ExamPdfExportService: 渲染HTML为空', ['paper_id' => $paperId]);
                return null;
            }

            // 生成PDF
            $pdfBinary = $this->buildPdf($html);
            if (!$pdfBinary) {
                return null;
            }

            // 保存PDF
            $version = time();
            $path = "analysis_reports/{$paperId}_{$studentId}_{$version}.pdf";
            $url = $this->pdfStorageService->put($path, $pdfBinary);
            if (!$url) {
                Log::error('ExamPdfExportService: 保存学情PDF失败', ['path' => $path]);
                return null;
            }

            // 保存URL到数据库
            $this->saveAnalysisPdfUrl($paperId, $studentId, $recordId, $url);

            return $url;

        } catch (\Throwable $e) {
            Log::error('ExamPdfExportService: 生成学情分析PDF失败', [
                'paper_id' => $paperId,
                'student_id' => $studentId,
                'record_id' => $recordId,
                'error' => $e->getMessage(),
                'exception' => get_class($e),
                'trace' => $e->getTraceAsString(),
            ]);
            return null;
        }
    }

    /**
     * 渲染并存储试卷PDF
     */
    private function renderAndStoreExamPdf(
        string $paperId,
        bool $includeAnswer,
        string $suffix,
        bool $useGradingView = false
    ): ?string {
        // 放宽脚本执行时间
        if (function_exists('set_time_limit')) {
            @set_time_limit(240);
        }

        try {
            $html = $this->renderExamHtml($paperId, $includeAnswer, $useGradingView);
            if (!$html) {
                Log::error('ExamPdfExportService: 渲染HTML为空', [
                    'paper_id' => $paperId,
                    'include_answer' => $includeAnswer,
                    'use_grading_view' => $useGradingView,
                ]);
                return null;
            }

            $pdfBinary = $this->buildPdf($html);
            if (!$pdfBinary) {
                Log::error('ExamPdfExportService: buildPdf为空', [
                    'paper_id' => $paperId,
                    'include_answer' => $includeAnswer,
                    'use_grading_view' => $useGradingView,
                ]);
                return null;
            }

            $path = "exams/{$paperId}_{$suffix}.pdf";
            $url = $this->pdfStorageService->put($path, $pdfBinary);
            if (!$url) {
                Log::error('ExamPdfExportService: 保存PDF失败', ['path' => $path]);
                return null;
            }

            return $url;

        } catch (\Throwable $e) {
            Log::error('ExamPdfExportService: 生成PDF失败', [
                'paper_id' => $paperId,
                'suffix' => $suffix,
                'error' => $e->getMessage(),
                'exception' => get_class($e),
                'trace' => $e->getTraceAsString(),
            ]);
            return null;
        }
    }

    /**
     * 渲染试卷HTML（重构版）
     */
    private function renderExamHtml(string $paperId, bool $includeAnswer, bool $useGradingView): ?string
    {
        // 直接构造请求URL，使用路由生成HTML
        $routeName = $useGradingView
            ? 'filament.admin.auth.intelligent-exam.grading'
            : 'filament.admin.auth.intelligent-exam.pdf';

        $url = route($routeName, ['paper_id' => $paperId, 'answer' => $includeAnswer ? 'true' : 'false']);

        // 使用HTTP客户端获取渲染后的HTML
        try {
            $response = Http::get($url);
            if ($response->successful()) {
                $html = $response->body();
                if (!empty(trim($html))) {
                    return $this->ensureUtf8Html($html);
                } else {
                    Log::warning('ExamPdfExportService: HTTP返回的HTML为空，使用备用方案', [
                        'paper_id' => $paperId,
                        'url' => $url,
                    ]);
                }
            }
        } catch (\Exception $e) {
            Log::warning('ExamPdfExportService: 通过HTTP获取HTML失败，使用备用方案', [
                'paper_id' => $paperId,
                'error' => $e->getMessage(),
            ]);
        }

        // 备用方案：直接渲染视图（如果路由不可用）
        try {
            $paper = Paper::with('questions')->find($paperId);
            if (!$paper) {
                Log::error('ExamPdfExportService: 试卷不存在，备用方案无法渲染', [
                    'paper_id' => $paperId,
                    'include_answer' => $includeAnswer,
                    'use_grading_view' => $useGradingView,
                ]);
                return null;
            }

            // 检查试卷是否有题目
            if ($paper->questions->isEmpty()) {
                Log::error('ExamPdfExportService: 试卷没有题目数据', [
                    'paper_id' => $paperId,
                    'question_count' => 0,
                ]);
                return null;
            }

            $viewName = $useGradingView ? 'exam-pdf.grading' : 'exam-pdf.student';
            $html = view($viewName, compact('paper'))->render();

            if (empty(trim($html))) {
                Log::error('ExamPdfExportService: 视图渲染结果为空', [
                    'paper_id' => $paperId,
                    'view_name' => $viewName,
                    'question_count' => $paper->questions->count(),
                ]);
                return null;
            }

            return $this->ensureUtf8Html($html);

        } catch (\Exception $e) {
            Log::error('ExamPdfExportService: 备用方案渲染失败', [
                'paper_id' => $paperId,
                'error' => $e->getMessage(),
                'trace' => $e->getTraceAsString(),
            ]);
            return null;
        }
    }

    /**
     * 构建分析数据（重构版）
     * 优先使用本地MySQL数据，减少API依赖
     */
    private function buildAnalysisData(string $paperId, string $studentId): ?array
    {
        // 【关键调试】确认方法被调用
        Log::warning('ExamPdfExportService: buildAnalysisData方法被调用了！', [
            'paper_id' => $paperId,
            'student_id' => $studentId,
            'timestamp' => now()->toISOString()
        ]);

        $paper = Paper::with(['questions' => function ($query) {
            $query->orderBy('question_number')->orderBy('id');
        }])->find($paperId);

        if (!$paper) {
            Log::warning('ExamPdfExportService: 未找到试卷，将尝试仅基于分析数据生成PDF', [
                'paper_id' => $paperId,
                'student_id' => $studentId,
            ]);

            // 【修复】即使试卷不存在，也尝试基于分析数据生成PDF
            $paper = new \stdClass();
            $paper->paper_id = $paperId;
            $paper->paper_name = "学情分析报告_{$studentId}_{$paperId}";
            $paper->question_count = 0;
            $paper->total_score = 0;
            $paper->created_at = now();
            $paper->questions = collect();
        }

        $student = Student::find($studentId);
        $studentInfo = [
            'id' => $student?->student_id ?? $studentId,
            'name' => $student?->name ?? $studentId,
            'grade' => $student?->grade ?? '未知年级',
            'class' => $student?->class_name ?? '未知班级',
        ];

        // 【修改】直接从本地数据库获取分析数据（不再调用API）
        $analysisData = [];

        // 首先尝试从paper->analysis_id获取
        if (!empty($paper->analysis_id)) {
            Log::info('ExamPdfExportService: 从本地数据库获取试卷分析数据', [
                'paper_id' => $paperId,
                'student_id' => $studentId,
                'analysis_id' => $paper->analysis_id
            ]);

            $analysisRecord = \DB::table('exam_analysis_results')
                ->where('id', $paper->analysis_id)
                ->where('student_id', $studentId)
                ->first();

            if ($analysisRecord && !empty($analysisRecord->analysis_data)) {
                $analysisData = json_decode($analysisRecord->analysis_data, true);
                Log::info('ExamPdfExportService: 成功获取本地分析数据（通过analysis_id）', [
                    'data_size' => strlen($analysisRecord->analysis_data)
                ]);
            } else {
                Log::warning('ExamPdfExportService: 未找到本地分析数据，将尝试其他方式', [
                    'paper_id' => $paperId,
                    'student_id' => $studentId,
                    'analysis_id' => $paper->analysis_id
                ]);
            }
        }

        // 如果没有analysis_id或未找到数据，直接从exam_analysis_results表查询
        if (empty($analysisData)) {
            Log::info('ExamPdfExportService: 直接从exam_analysis_results表查询分析数据', [
                'paper_id' => $paperId,
                'student_id' => $studentId
            ]);

            $analysisRecord = \DB::table('exam_analysis_results')
                ->where('paper_id', $paperId)
                ->where('student_id', $studentId)
                ->first();

            if ($analysisRecord && !empty($analysisRecord->analysis_data)) {
                $analysisData = json_decode($analysisRecord->analysis_data, true);
                Log::info('ExamPdfExportService: 成功获取本地分析数据（直接查询）', [
                    'data_size' => strlen($analysisRecord->analysis_data),
                    'question_count' => count($analysisData['question_analysis'] ?? [])
                ]);
            } else {
                Log::warning('ExamPdfExportService: 未找到任何分析数据，将使用空数据', [
                    'paper_id' => $paperId,
                    'student_id' => $studentId
                ]);
            }
        }

        // 【修复】优先使用analysisData中的knowledge_point_analysis数据
        $masteryData = [];
        $parentMasteryLevels = []; // 新增：父节点掌握度数据
        Log::info('ExamPdfExportService: 开始处理掌握度数据', [
            'student_id' => $studentId,
            'analysisData_keys' => array_keys($analysisData),
            'has_knowledge_point_analysis' => !empty($analysisData['knowledge_point_analysis']),
        ]);

        if (!empty($analysisData['knowledge_point_analysis'])) {
            // 将knowledge_point_analysis转换为buildMasterySummary期望的格式
            foreach ($analysisData['knowledge_point_analysis'] as $kp) {
                $masteryData[] = [
                    'kp_code' => $kp['kp_id'] ?? null,
                    'kp_name' => $kp['kp_id'] ?? '未知知识点',
                    'mastery_level' => $kp['mastery_level'] ?? 0,
                    'mastery_change' => $kp['change'] ?? null,
                ];
            }

            // 【修复】基于所有兄弟节点历史数据计算父节点掌握度，并获取掌握度变化
            try {
                // 获取本次考试涉及的知识点代码列表
                $examKpCodes = array_column($masteryData, 'kp_code');
                Log::info('ExamPdfExportService: 本次考试涉及的知识点', [
                    'count' => count($examKpCodes),
                    'kp_codes' => $examKpCodes
                ]);

                // 获取上一个快照的数据（用于计算变化）
                // 如果没有其他试卷的记录，使用同一试卷的上一次快照
                $lastSnapshot = DB::connection('mysql')
                    ->table('knowledge_point_mastery_snapshots')
                    ->where('student_id', $studentId)
                    ->where('paper_id', $paper->paper_id)
                    ->where('snapshot_id', '!=', "snap_{$paper->paper_id}_" . date('YmdHis'))
                    ->latest('snapshot_time')
                    ->first();

                $previousMasteryData = [];
                if ($lastSnapshot) {
                    $previousMasteryJson = json_decode($lastSnapshot->mastery_data, true);
                    foreach ($previousMasteryJson as $kpCode => $data) {
                        $previousMasteryData[$kpCode] = [
                            'current_mastery' => $data['current_mastery'] ?? 0,
                            'previous_mastery' => $data['previous_mastery'] ?? null,
                        ];
                    }
                    Log::info('ExamPdfExportService: 获取到上一次快照数据', [
                        'snapshot_time' => $lastSnapshot->snapshot_time,
                        'kp_count' => count($previousMasteryData)
                    ]);
                }

                // 为当前知识点添加变化数据
                foreach ($masteryData as &$item) {
                    $kpCode = $item['kp_code'];
                    if (isset($previousMasteryData[$kpCode])) {
                        $previous = floatval($previousMasteryData[$kpCode]['previous_mastery'] ?? 0);
                        $current = floatval($item['mastery_level']);
                        $item['mastery_change'] = $current - $previous;
                    }
                }
                unset($item); // 解除引用

                // 获取所有父节点掌握度
                $masteryOverview = $this->masteryCalculator->getStudentMasteryOverviewWithHierarchy($studentId);
                $allParentMasteryLevels = $masteryOverview['parent_mastery_levels'] ?? [];

                // 计算与本次考试相关的父节点掌握度（基于所有兄弟节点）
                $parentMasteryLevels = [];

                // 【修复】使用数据库查询正确匹配父子关系，而不是字符串前缀
                foreach ($allParentMasteryLevels as $parentKpCode => $parentMastery) {
                    // 查询这个父节点的所有子节点
                    $childNodes = DB::connection('mysql')
                        ->table('knowledge_points')
                        ->where('parent_kp_code', $parentKpCode)
                        ->pluck('kp_code')
                        ->toArray();

                    // 检查是否有子节点在本次考试中出现
                    $relevantChildren = array_intersect($examKpCodes, $childNodes);

                    if (!empty($relevantChildren)) {
                        // 【修复】计算父节点变化：基于所有子节点的平均变化
                        $childChanges = [];
                        foreach ($relevantChildren as $childKpCode) {
                            $previousChild = $previousMasteryData[$childKpCode]['previous_mastery'] ?? null;
                            $currentChild = null;
                            foreach ($masteryData as $item) {
                                if ($item['kp_code'] === $childKpCode) {
                                    $currentChild = $item['mastery_level'];
                                    break;
                                }
                            }
                            if ($previousChild !== null && $currentChild !== null) {
                                $childChanges[] = floatval($currentChild) - floatval($previousChild);
                            }
                        }
                        $avgChange = !empty($childChanges) ? array_sum($childChanges) / count($childChanges) : null;

                        // 获取父节点中文名称
                        $parentKpInfo = DB::connection('mysql')
                            ->table('knowledge_points')
                            ->where('kp_code', $parentKpCode)
                            ->first();

                        $parentMasteryLevels[$parentKpCode] = [
                            'kp_code' => $parentKpCode,
                            'kp_name' => $parentKpInfo->name ?? $parentKpCode,
                            'mastery_level' => $parentMastery,
                            'mastery_percentage' => round($parentMastery * 100, 1),
                            'mastery_change' => $avgChange,
                            'children' => $relevantChildren,
                        ];
                    }
                }

                Log::info('ExamPdfExportService: 过滤后的父节点掌握度', [
                    'all_parent_count' => count($allParentMasteryLevels),
                    'filtered_parent_count' => count($parentMasteryLevels),
                    'filtered_codes' => array_keys($parentMasteryLevels)
                ]);
            } catch (\Exception $e) {
                Log::warning('ExamPdfExportService: 获取父节点掌握度失败', [
                    'error' => $e->getMessage()
                ]);
            }

            Log::info('ExamPdfExportService: 使用analysisData中的掌握度数据', [
                'count' => count($masteryData),
                'masteryData_sample' => !empty($masteryData) ? array_slice($masteryData, 0, 2) : []
            ]);
        } else {
            // 如果没有knowledge_point_analysis，使用MasteryCalculator获取多层级掌握度概览
            try {
                Log::info('ExamPdfExportService: 获取学生多层级掌握度概览', [
                    'student_id' => $studentId
                ]);
                $masteryOverview = $this->masteryCalculator->getStudentMasteryOverviewWithHierarchy($studentId);
                $masteryData = $masteryOverview['details'] ?? [];
                $parentMasteryLevels = $masteryOverview['parent_mastery_levels'] ?? []; // 获取父节点掌握度

                // 【修复】将对象数组转换为关联数组（避免 stdClass 对象访问错误）
                if (!empty($masteryData) && is_array($masteryData)) {
                    $masteryData = array_map(function($item) {
                        if (is_object($item)) {
                            return [
                                'kp_code' => $item->kp_code ?? null,
                                'kp_name' => $item->kp_name ?? null,
                                'mastery_level' => floatval($item->mastery_level ?? 0),
                                'mastery_change' => $item->mastery_change !== null ? floatval($item->mastery_change) : null,
                            ];
                        }
                        return $item;
                    }, $masteryData);
                }

                // 【修复】获取快照数据以计算掌握度变化
                $lastSnapshot = DB::connection('mysql')
                    ->table('knowledge_point_mastery_snapshots')
                    ->where('student_id', $studentId)
                    ->latest('snapshot_time')
                    ->first();

                if ($lastSnapshot) {
                    $previousMasteryJson = json_decode($lastSnapshot->mastery_data, true);
                    foreach ($masteryData as &$item) {
                        $kpCode = $item['kp_code'];
                        if (isset($previousMasteryJson[$kpCode])) {
                            $previous = floatval($previousMasteryJson[$kpCode]['previous_mastery'] ?? 0);
                            $current = floatval($item['mastery_level']);
                            $item['mastery_change'] = $current - $previous;
                        }
                    }
                    unset($item);
                }

            Log::info('ExamPdfExportService: 成功获取多层级掌握度数据', [
                'count' => count($masteryData),
                'parent_count' => count($parentMasteryLevels)
            ]);
            } catch (\Exception $e) {
                Log::error('ExamPdfExportService: 获取掌握度数据失败', [
                    'student_id' => $studentId,
                    'error' => $e->getMessage()
                ]);
            }
        }

        // 【修改】使用本地方法获取学习路径推荐（替代API调用）
        $recommendations = [];
        try {
            Log::info('ExamPdfExportService: 获取学习路径推荐', [
                'student_id' => $studentId
            ]);
            $learningPaths = $this->learningAnalyticsService->recommendLearningPaths($studentId, 3);
            $recommendations = $learningPaths['recommendations'] ?? [];
            Log::info('ExamPdfExportService: 成功获取学习路径推荐', [
                'count' => count($recommendations)
            ]);
        } catch (\Exception $e) {
            Log::error('ExamPdfExportService: 获取学习路径推荐失败', [
                'student_id' => $studentId,
                'error' => $e->getMessage()
            ]);
        }

        // 获取知识点名称映射
        $kpNameMap = $this->buildKnowledgePointNameMap();
        Log::info('ExamPdfExportService: 获取知识点名称映射', [
            'kpNameMap_count' => count($kpNameMap),
            'kpNameMap_keys_sample' => !empty($kpNameMap) ? array_slice(array_keys($kpNameMap), 0, 5) : []
        ]);

        // 【修复】直接从MySQL数据库获取题目详情（不通过API）
        $questionDetails = $this->getQuestionDetailsFromMySQL($paper);

        // 处理题目数据
        $questions = $this->processQuestionsForReport($paper, $questionDetails, $kpNameMap);

        // 【关键调试】查看buildMasterySummary的返回结果
        $masterySummary = $this->buildMasterySummary($masteryData, $kpNameMap);
        Log::info('ExamPdfExportService: buildMasterySummary返回结果', [
            'masteryData_count' => count($masteryData),
            'kpNameMap_count' => count($kpNameMap),
            'masterySummary_keys' => array_keys($masterySummary),
            'masterySummary_items_count' => count($masterySummary['items'] ?? []),
            'masterySummary_items_sample' => !empty($masterySummary['items']) ? array_slice($masterySummary['items'], 0, 2) : []
        ]);

        // 【修复】处理父节点掌握度数据：过滤零值、转换名称、构建层级关系
        $examKpCodes = array_column($masteryData, 'kp_code'); // 本次考试涉及的知识点
        $processedParentMastery = $this->processParentMasteryLevels($parentMasteryLevels, $kpNameMap, $examKpCodes);

        Log::info('ExamPdfExportService: 处理后的父节点掌握度', [
            'raw_count' => count($parentMasteryLevels),
            'processed_count' => count($processedParentMastery),
            'processed_sample' => !empty($processedParentMastery) ? array_slice($processedParentMastery, 0, 3) : []
        ]);

        return [
            'paper' => [
                'id' => $paper->paper_id,
                'name' => $paper->paper_name,
                'total_questions' => $paper->question_count,
                'total_score' => $paper->total_score,
                'created_at' => $paper->created_at,
            ],
            'student' => $studentInfo,
            'questions' => $questions,
            'mastery' => $masterySummary,
            'parent_mastery_levels' => $processedParentMastery, // 【修复】使用处理后的父节点数据
            'insights' => $analysisData['question_analysis'] ?? [], // 使用question_analysis替代question_results
            'recommendations' => $recommendations,
            'analysis_data' => $analysisData,
        ];
    }

    /**
     * 【修复】直接从PaperQuestion表获取题目详情（不通过API）
     */
    private function getQuestionDetailsFromMySQL(Paper $paper): array
    {
        $details = [];

        Log::info('ExamPdfExportService: 从PaperQuestion表查询题目详情', [
            'paper_id' => $paper->paper_id,
            'question_count' => $paper->questions->count()
        ]);

        foreach ($paper->questions as $pq) {
            try {
                // 【关键修复】直接从PaperQuestion对象获取solution和correct_answer
                $detail = [
                    'id' => $pq->question_id,
                    'content' => $pq->question_text,
                    'question_type' => $pq->question_type,
                    'answer' => $pq->correct_answer ?? null,  // 【修复】从PaperQuestion获取正确答案
                    'solution' => $pq->solution ?? null,  // 【修复】从PaperQuestion获取解题思路
                ];
                $details[(string) ($pq->question_id ?? $pq->id)] = $detail;

                Log::debug('ExamPdfExportService: 成功获取题目详情', [
                    'paper_question_id' => $pq->id,
                    'question_id' => $pq->question_id,
                    'has_answer' => !empty($pq->correct_answer),
                    'has_solution' => !empty($pq->solution),
                    'answer_preview' => $pq->correct_answer ? substr($pq->correct_answer, 0, 50) : null
                ]);
            } catch (\Throwable $e) {
                Log::error('ExamPdfExportService: 获取题目详情失败', [
                    'paper_question_id' => $pq->id,
                    'error' => $e->getMessage(),
                ]);
            }
        }

        return $details;
    }

    /**
     * 处理题目数据（用于报告）
     */
    private function processQuestionsForReport($paper, array $questionDetails, array $kpNameMap): array
    {
        $grouped = [
            'choice' => [],
            'fill' => [],
            'answer' => [],
        ];

        // 【修复】处理空的试卷（questions可能不存在）
        $questions = $paper->questions ?? collect();
        if ($questions->isEmpty()) {
            Log::info('ExamPdfExportService: 试卷没有题目，返回空数组');
            return $grouped;
        }

        $sortedQuestions = $questions
            ->sortBy(function ($q, int $idx) {
                $number = $q->question_number ?? $idx + 1;
                return is_numeric($number) ? (float) $number : ($q->id ?? $idx);
            });

        foreach ($sortedQuestions as $idx => $question) {
            $kpCode = $question->knowledge_point ?? '';
            $kpName = $kpNameMap[$kpCode] ?? $kpCode ?: '未标注';

            // 【修复】直接从PaperQuestion对象获取solution和correct_answer
            $answer = $question->correct_answer ?? null;  // 直接从PaperQuestion获取
            $solution = $question->solution ?? null;  // 直接从PaperQuestion获取

            $detail = $questionDetails[(string) ($question->question_id ?? $question->id)] ?? [];
            $typeRaw = $question->question_type ?? ($detail['question_type'] ?? $detail['type'] ?? '');
            $normalizedType = $this->normalizeQuestionType($typeRaw);
            $number = $question->question_number ?? ($idx + 1);

            $payload = [
                'question_number' => $number,
                'question_text' => is_array($question->question_text)
                    ? json_encode($question->question_text, JSON_UNESCAPED_UNICODE)
                    : ($question->question_text ?? ''),
                'question_type' => $normalizedType,
                'knowledge_point' => $kpCode,
                'knowledge_point_name' => $kpName,
                'score' => $question->score,
                'answer' => $answer,  // 正确答案
                'solution' => $solution,  // 解题思路
                'student_answer' => $question->student_answer ?? null,  // 【新增】学生答案
                'correct_answer' => $answer,  // 【新增】正确答案
                'is_correct' => $question->is_correct ?? null,  // 【新增】判分结果
                'score_obtained' => $question->score_obtained ?? null,  // 【新增】得分
            ];

            $grouped[$normalizedType][] = $payload;

            // 【调试】记录题目数据
            Log::debug('ExamPdfExportService: 处理题目数据', [
                'paper_question_id' => $question->id,
                'question_id' => $question->question_id,
                'has_answer' => !empty($answer),
                'has_solution' => !empty($solution),
                'answer_preview' => $answer ? substr($answer, 0, 50) : null
            ]);
        }

        $ordered = array_merge($grouped['choice'], $grouped['fill'], $grouped['answer']);

        // 按卷面顺序重新编号
        foreach ($ordered as $i => &$q) {
            $q['display_number'] = $i + 1;
        }
        unset($q);

        return $ordered;
    }

    /**
     * 构建PDF
     */
    private function buildPdf(string $html): ?string
    {
        $tmpHtml = tempnam(sys_get_temp_dir(), 'exam_html_') . '.html';
        $utf8Html = $this->ensureUtf8Html($html);
        file_put_contents($tmpHtml, $utf8Html);

        // 仅使用Chrome渲染
        $chromePdf = $this->renderWithChrome($tmpHtml);
        @unlink($tmpHtml);
        return $chromePdf;
    }

    /**
     * 使用Chrome渲染PDF
     */
    private function renderWithChrome(string $htmlPath): ?string
    {
        $tmpPdf = tempnam(sys_get_temp_dir(), 'exam_pdf_') . '.pdf';
        $userDataDir = sys_get_temp_dir() . '/chrome-profile-' . uniqid();

        $chromeBinary = $this->findChromeBinary();
        if (!$chromeBinary) {
            Log::error('ExamPdfExportService: 未找到可用的Chrome/Chromium');
            return null;
        }

        // 设置运行时目录
        $runtimeHome = sys_get_temp_dir() . '/chrome-home';
        $runtimeXdg = sys_get_temp_dir() . '/chrome-xdg';
        if (!File::exists($runtimeHome)) {
            @File::makeDirectory($runtimeHome, 0755, true);
        }
        if (!File::exists($runtimeXdg)) {
            @File::makeDirectory($runtimeXdg, 0755, true);
        }

        $process = new Process([
            $chromeBinary,
            '--headless',
            '--disable-gpu',
            '--no-sandbox',
            '--disable-setuid-sandbox',
            '--disable-dev-shm-usage',
            '--no-zygote',
            '--disable-features=VizDisplayCompositor',
            '--disable-software-rasterizer',
            '--disable-extensions',
            '--disable-background-networking',
            '--disable-component-update',
            '--disable-client-side-phishing-detection',
            '--disable-default-apps',
            '--disable-domain-reliability',
            '--disable-sync',
            '--safebrowsing-disable-auto-update',
            '--no-first-run',
            '--no-default-browser-check',
            '--disable-crash-reporter',
            '--disable-print-preview',
            '--disable-features=PrintHeaderFooter',
            '--disable-features=TranslateUI',
            '--disable-features=OptimizationHints',
            '--disable-ipc-flooding-protection',
            '--disable-background-networking',
            '--disable-background-timer-throttling',
            '--disable-backgrounding-occluded-windows',
            '--disable-renderer-backgrounding',
            '--disable-features=AudioServiceOutOfProcess',
            '--user-data-dir=' . $userDataDir,
            '--print-to-pdf=' . $tmpPdf,
            '--print-to-pdf-no-header',
            '--allow-file-access-from-files',
            'file://' . $htmlPath,
        ], null, [
            'HOME' => $runtimeHome,
            'XDG_RUNTIME_DIR' => $runtimeXdg,
        ]);

        $process->setTimeout(60);
        $killSignal = \defined('SIGKILL') ? \SIGKILL : 9;

        try {
            $startedAt = microtime(true);
            $process->start();
            $pdfGenerated = false;

            // 轮询检测PDF是否生成
            $pollStart = microtime(true);
            $maxPollSeconds = 30;
            while ($process->isRunning() && (microtime(true) - $pollStart) < $maxPollSeconds) {
                if (file_exists($tmpPdf) && filesize($tmpPdf) > 0) {
                    $pdfGenerated = true;
                    $process->stop(5, $killSignal);
                    break;
                }
                usleep(200_000);
            }

            if ($process->isRunning()) {
                $process->stop(5, $killSignal);
            }

            $process->wait();

        } catch (ProcessTimedOutException|ProcessSignaledException $e) {
            if ($process->isRunning()) {
                $process->stop(5, $killSignal);
            }
            return $this->handleChromeProcessResult($tmpPdf, $userDataDir, $process, $startedAt);
        } catch (\Throwable $e) {
            if ($process->isRunning()) {
                $process->stop(5, $killSignal);
            }
            return $this->handleChromeProcessResult($tmpPdf, $userDataDir, $process, null);
        }

        return $this->handleChromeProcessResult($tmpPdf, $userDataDir, $process, null);
    }

    /**
     * 处理Chrome进程结果
     */
    private function handleChromeProcessResult(string $tmpPdf, string $userDataDir, Process $process, ?float $startedAt): ?string
    {
        $pdfExists = file_exists($tmpPdf);
        $pdfSize = $pdfExists ? filesize($tmpPdf) : null;

        if (!$process->isSuccessful()) {
            if ($pdfExists && $pdfSize > 0) {
                Log::warning('ExamPdfExportService: Chrome进程异常但生成了PDF', [
                    'exit_code' => $process->getExitCode(),
                    'tmp_pdf_size' => $pdfSize,
                ]);
            } else {
                Log::error('ExamPdfExportService: Chrome渲染失败', [
                    'exit_code' => $process->getExitCode(),
                    'error' => $process->getErrorOutput(),
                ]);
                @unlink($tmpPdf);
                File::deleteDirectory($userDataDir);
                return null;
            }
        }

        $pdfBinary = $pdfExists ? file_get_contents($tmpPdf) : null;
        @unlink($tmpPdf);
        File::deleteDirectory($userDataDir);
        return $pdfBinary ?: null;
    }

    /**
     * 查找Chrome二进制文件
     */
    private function findChromeBinary(): ?string
    {
        $candidates = [
            env('PDF_CHROME_BINARY'),
            '/Applications/Google Chrome.app/Contents/MacOS/Google Chrome',
            '/usr/bin/google-chrome-stable',
            '/usr/bin/google-chrome',
            '/usr/bin/chromium-browser',
            '/usr/bin/chromium',
        ];

        foreach ($candidates as $path) {
            if ($path && is_file($path) && is_executable($path)) {
                return $path;
            }
        }

        return null;
    }

    /**
     * 确保HTML为UTF-8编码
     */
    private function ensureUtf8Html(string $html): string
    {
        $meta = '<meta charset="UTF-8">';
        if (stripos($html, '<head>') !== false) {
            return preg_replace('/<head>/i', "<head>{$meta}", $html, 1);
        }
        return $meta . $html;
    }

    /**
     * 构建知识点名称映射
     */
    private function buildKnowledgePointNameMap(): array
    {
        try {
            $options = $this->questionServiceApi->getKnowledgePointOptions();
            return $options ?: [];
        } catch (\Throwable $e) {
            Log::warning('ExamPdfExportService: 获取知识点名称失败', [
                'error' => $e->getMessage(),
            ]);
            return [];
        }
    }

    /**
     * 构建掌握度摘要
     */
    private function buildMasterySummary(array $masteryData, array $kpNameMap): array
    {
        Log::info('ExamPdfExportService: buildMasterySummary开始处理', [
            'masteryData_count' => count($masteryData),
            'kpNameMap_count' => count($kpNameMap)
        ]);

        $items = [];
        $total = 0;
        $count = 0;

        foreach ($masteryData as $row) {
            $code = $row['kp_code'] ?? null;
            // 【修复】使用kpNameMap转换名称为友好显示名
            $name = $kpNameMap[$code] ?? $row['kp_name'] ?? $code ?: '未知知识点';
            $level = (float)($row['mastery_level'] ?? 0);
            $delta = $row['mastery_change'] ?? null;

            $items[] = [
                'kp_code' => $code,
                'kp_name' => $name,
                'mastery_level' => $level,
                'mastery_change' => $delta,
            ];

            $total += $level;
            $count++;
        }

        $average = $count > 0 ? round($total / $count, 2) : null;

        // 按掌握度从低到高排序
        if (!empty($items)) {
            usort($items, fn($a, $b) => ($a['mastery_level'] <=> $b['mastery_level']));
        }

        $result = [
            'items' => $items,
            'average' => $average,
            'weak_list' => array_slice($items, 0, 5),
        ];

        Log::info('ExamPdfExportService: buildMasterySummary完成', [
            'total_count' => $count,
            'items_count' => count($items)
        ]);

        return $result;
    }

    /**
     * 标准化题型
     */
    private function normalizeQuestionType(string $type): string
    {
        $t = strtolower(trim($type));
        return match (true) {
            str_contains($t, 'choice') || str_contains($t, '选择') => 'choice',
            str_contains($t, 'fill') || str_contains($t, 'blank') || str_contains($t, '填空') => 'fill',
            default => 'answer',
        };
    }

    /**
     * 保存PDF URL到数据库
     */
    private function savePdfUrlToDatabase(string $paperId, string $field, string $url): void
    {
        try {
            $paper = Paper::where('paper_id', $paperId)->first();
            if ($paper) {
                $paper->update([$field => $url]);
                Log::info('ExamPdfExportService: PDF URL已写入数据库', [
                    'paper_id' => $paperId,
                    'field' => $field,
                    'url' => $url,
                ]);
            }
        } catch (\Throwable $e) {
            Log::error('ExamPdfExportService: 写入PDF URL失败', [
                'paper_id' => $paperId,
                'field' => $field,
                'error' => $e->getMessage(),
            ]);
        }
    }

    /**
     * 保存学情分析PDF URL
     */
    private function saveAnalysisPdfUrl(string $paperId, string $studentId, ?string $recordId, string $url): void
    {
        try {
            if ($recordId) {
                // OCR记录
                $ocrRecord = \App\Models\OCRRecord::find($recordId);
                if ($ocrRecord) {
                    $ocrRecord->update(['analysis_pdf_url' => $url]);
                    Log::info('ExamPdfExportService: OCR记录学情分析PDF URL已写入数据库', [
                        'record_id' => $recordId,
                        'paper_id' => $paperId,
                        'student_id' => $studentId,
                        'url' => $url,
                    ]);
                }
            } else {
                // 【修复】同时更新 exam_analysis_results 表和分析报告表
                $updated = \DB::connection('mysql')->table('exam_analysis_results')
                    ->where('student_id', $studentId)
                    ->where('paper_id', $paperId)
                    ->update([
                        'analysis_pdf_url' => $url,
                        'updated_at' => now(),
                    ]);

                if ($updated) {
                    Log::info('ExamPdfExportService: 学情分析PDF URL已写入exam_analysis_results表', [
                        'student_id' => $studentId,
                        'paper_id' => $paperId,
                        'url' => $url,
                        'updated_rows' => $updated,
                    ]);
                } else {
                    Log::warning('ExamPdfExportService: 未找到要更新的学情分析记录', [
                        'student_id' => $studentId,
                        'paper_id' => $paperId,
                    ]);
                }

                // 学生记录 - 使用新的 student_reports 表（备用）
                \App\Models\StudentReport::updateOrCreate(
                    [
                        'student_id' => $studentId,
                        'report_type' => 'exam_analysis',
                        'paper_id' => $paperId,
                    ],
                    [
                        'pdf_url' => $url,
                        'generation_status' => 'completed',
                        'generated_at' => now(),
                        'updated_at' => now(),
                    ]
                );

                Log::info('ExamPdfExportService: 学生学情报告PDF URL已保存到student_reports表（备用）', [
                    'student_id' => $studentId,
                    'paper_id' => $paperId,
                    'url' => $url,
                ]);
            }
        } catch (\Throwable $e) {
            Log::error('ExamPdfExportService: 写入学情分析PDF URL失败', [
                'paper_id' => $paperId,
                'student_id' => $studentId,
                'record_id' => $recordId,
                'error' => $e->getMessage(),
            ]);
        }
    }

    /**
     * 【修复】处理父节点掌握度数据
     * 1. 过滤掉掌握度为0或null的父节点
     * 2. 将kp_code转换为友好的kp_name
     * 3. 构建父子层级关系（只显示本次考试相关的子节点）
     */
    private function processParentMasteryLevels(array $parentMasteryLevels, array $kpNameMap, array $examKpCodes = []): array
    {
        $processed = [];

        foreach ($parentMasteryLevels as $kpCode => $masteryData) {
            // 兼容不同数据结构：可能是数组或数字
            $masteryLevel = is_array($masteryData) ? ($masteryData['mastery_level'] ?? 0) : $masteryData;
            $masteryChange = is_array($masteryData) ? ($masteryData['mastery_change'] ?? null) : null;

            // 过滤零值和空值
            if ($masteryLevel === null || $masteryLevel === 0.0 || $masteryLevel <= 0.001) {
                continue;
            }

            // 获取友好名称
            $kpName = $kpNameMap[$kpCode] ?? $kpCode;

            // 构建父节点数据，包含子节点信息（只显示本次考试相关的）
            $processed[$kpCode] = [
                'kp_code' => $kpCode,
                'kp_name' => $kpName,
                'mastery_level' => round(floatval($masteryLevel), 4),
                'mastery_percentage' => round(floatval($masteryLevel) * 100, 2),
                'mastery_change' => $masteryChange !== null ? round(floatval($masteryChange), 4) : null,
                // 【修复】只获取本次考试涉及的子节点
                'children' => $this->getChildKnowledgePoints($kpCode, $kpNameMap, $examKpCodes),
                'level' => $this->calculateKnowledgePointLevel($kpCode),
            ];
        }

        // 按掌握度降序排序
        uasort($processed, function($a, $b) {
            return $b['mastery_level'] <=> $a['mastery_level'];
        });

        return $processed;
    }

    /**
     * 【修复】获取子知识点列表（只返回本次考试涉及的）
     */
    private function getChildKnowledgePoints(string $parentKpCode, array $kpNameMap, array $examKpCodes = []): array
    {
        $children = [];

        try {
            $childCodes = DB::connection('mysql')
                ->table('knowledge_points')
                ->where('parent_kp_code', $parentKpCode)
                ->pluck('kp_code')
                ->toArray();

            foreach ($childCodes as $childCode) {
                // 只包含本次考试涉及的知识点
                if (in_array($childCode, $examKpCodes)) {
                    $children[] = [
                        'kp_code' => $childCode,
                        'kp_name' => $kpNameMap[$childCode] ?? $childCode,
                    ];
                }
            }
        } catch (\Exception $e) {
            Log::warning('获取子知识点失败', [
                'parent_kp_code' => $parentKpCode,
                'error' => $e->getMessage(),
            ]);
        }

        return $children;
    }

    /**
     * 计算知识点层级深度
     */
    private function calculateKnowledgePointLevel(string $kpCode): int
    {
        // 根据kp_code前缀判断层级深度
        // 例如: M (1级) -> M01 (2级) -> M01A (3级)
        if (preg_match('/^[A-Z]+$/', $kpCode)) {
            return 1; // 一级分类，如 M, S, E, G
        } elseif (preg_match('/^[A-Z]+\d+$/', $kpCode)) {
            return 2; // 二级分类，如 M01, S02
        } elseif (preg_match('/^[A-Z]+\d+[A-Z]+$/', $kpCode)) {
            return 3; // 三级分类，如 M01A, S02B
        } elseif (preg_match('/^[A-Z]+\d+[A-Z]+\d+$/', $kpCode)) {
            return 4; // 四级分类，如 M01A1
        }

        return 1; // 默认一级
    }

    /**
     * 构建题目数据（用于PDF生成）
     */
    private function buildQuestionsData(Paper $paper): array
    {
        $paperQuestions = $paper->questions()->orderBy('question_number')->get();
        $questionsData = [];
        foreach ($paperQuestions as $pq) {
            $questionsData[] = [
                'id' => $pq->question_bank_id,
                'kp_code' => $pq->knowledge_point,
                'question_type' => $pq->question_type ?? 'answer',
                'stem' => $pq->question_text ?? '题目内容缺失',
                'solution' => $pq->solution ?? '',
                'answer' => $pq->correct_answer ?? '',
                'difficulty' => $pq->difficulty ?? 0.5,
                'score' => $pq->score ?? 5,
                'tags' => '',
                'content' => $pq->question_text ?? '',
            ];
        }

        // 获取完整题目详情
        if (!empty($questionsData)) {
            $questionIds = array_column($questionsData, 'id');
            $questionsResponse = $this->questionServiceApi->getQuestionsByIds($questionIds);
            $responseData = $questionsResponse['data'] ?? [];

            if (!empty($responseData)) {
                $responseDataMap = [];
                foreach ($responseData as $respQ) {
                    $responseDataMap[$respQ['id']] = $respQ;
                }

                $questionsData = array_map(function($q) use ($responseDataMap) {
                    if (isset($responseDataMap[$q['id']])) {
                        $apiData = $responseDataMap[$q['id']];
                        $q['stem'] = $apiData['stem'] ?? $q['stem'] ?? $q['content'] ?? '';
                        $q['content'] = $q['stem'];
                        $q['answer'] = $apiData['answer'] ?? $q['answer'] ?? '';
                        $q['solution'] = $apiData['solution'] ?? $q['solution'] ?? '';
                        $q['tags'] = $apiData['tags'] ?? $q['tags'] ?? '';
                        $q['options'] = $apiData['options'] ?? [];
                    }
                    return $q;
                }, $questionsData);
            }
        }

        // 按题型分类
        $classified = ['choice' => [], 'fill' => [], 'answer' => []];
        foreach ($questionsData as $q) {
            $type = $this->determineQuestionType($q);
            $classified[$type][] = (object) $q;
        }

        return $classified;
    }

    /**
     * 获取学生信息
     */
    private function getStudentInfo(?string $studentId): array
    {
        if (!$studentId) {
            return [
                'name' => '未知学生',
                'grade' => '未知年级',
                'class' => '未知班级'
            ];
        }

        try {
            $student = DB::table('students')
                ->where('student_id', $studentId)
                ->first();

            if ($student) {
                return [
                    'name' => $student->name ?? $studentId,
                    'grade' => $student->grade ?? '未知',
                    'class' => $student->class ?? '未知'
                ];
            }
        } catch (\Exception $e) {
            Log::warning('获取学生信息失败', [
                'student_id' => $studentId,
                'error' => $e->getMessage()
            ]);
        }

        return [
            'name' => $studentId,
            'grade' => '未知',
            'class' => '未知'
        ];
    }

    /**
     * 获取教师信息
     */
    private function getTeacherInfo(?string $teacherId): array
    {
        if (!$teacherId) {
            return [
                'name' => '未知老师',
                'subject' => '数学'
            ];
        }

        try {
            $teacher = DB::table('teachers')
                ->where('teacher_id', $teacherId)
                ->first();

            if ($teacher) {
                return [
                    'name' => $teacher->name ?? $teacherId,
                    'subject' => $teacher->subject ?? '数学'
                ];
            }
        } catch (\Exception $e) {
            Log::warning('获取教师信息失败', [
                'teacher_id' => $teacherId,
                'error' => $e->getMessage()
            ]);
        }

        return [
            'name' => $teacherId,
            'subject' => '数学'
        ];
    }

    /**
     * 判断题目类型
     */
    private function determineQuestionType(array $question): string
    {
        $stem = $question['stem'] ?? $question['content'] ?? '';
        $tags = $question['tags'] ?? '';

        // 根据题干内容判断选择题
        if (is_string($stem)) {
            $hasOptionA = preg_match('/\bA\s*[\.\、\:]/', $stem) || preg_match('/\(A\)/', $stem) || preg_match('/^A[\.\s]/', $stem);
            $hasOptionB = preg_match('/\bB\s*[\.\、\:]/', $stem) || preg_match('/\(B\)/', $stem) || preg_match('/^B[\.\s]/', $stem);
            $hasOptionC = preg_match('/\bC\s*[\.\、\:]/', $stem) || preg_match('/\(C\)/', $stem) || preg_match('/^C[\.\s]/', $stem);
            $hasOptionD = preg_match('/\bD\s*[\.\、\:]/', $stem) || preg_match('/\(D\)/', $stem) || preg_match('/^D[\.\s]/', $stem);

            $optionCount = ($hasOptionA ? 1 : 0) + ($hasOptionB ? 1 : 0) + ($hasOptionC ? 1 : 0) + ($hasOptionD ? 1 : 0);
            if ($optionCount >= 2) {
                return 'choice';
            }

            // 检查是否有填空标记
            if (preg_match('/（\s*）|\(\s*\)/', $stem)) {
                return 'fill';
            }
        }

        // 根据已有类型字段判断
        if (!empty($question['question_type'])) {
            $type = strtolower(trim($question['question_type']));
            if (in_array($type, ['choice', '选择题'])) return 'choice';
            if (in_array($type, ['fill', '填空题'])) return 'fill';
            if (in_array($type, ['answer', '解答题'])) return 'answer';
        }

        // 默认返回解答题
        return 'answer';
    }
}