☰

Export Patent Info

Export patent information to Excel format with enhanced debugging

// ==UserScript==
// @name         Export Patent Info
// @namespace    http://your.site.com
// @version      0.6
// @description  Export patent information to Excel format with enhanced debugging
// @author       Your Name
// @match        *://*.cpquery.cponline.cnipa.gov.cn/chinesepatent/index
// @license      MIT
// @grant        none
// @require      https://cdn.jsdelivr.net/npm/[email protected]/dist/xlsx.full.min.js
// ==/UserScript==

(function() {
    'use strict';

    // 创建导出按钮
    const exportButton = document.createElement('button');
    exportButton.textContent = '导出专利信息';
    exportButton.style.position = 'fixed';
    exportButton.style.top = '120px';
    exportButton.style.right = '20px';
    exportButton.style.zIndex = '9999';
    exportButton.style.padding = '10px 20px';
    exportButton.style.fontSize = '16px';
    exportButton.style.backgroundColor = '#3498db';
    exportButton.style.color = 'white';
    exportButton.style.border = 'none';
    exportButton.style.borderRadius = '5px';
    exportButton.style.boxShadow = '2px 2px 8px rgba(0,0,0,0.2)';
    exportButton.style.cursor = 'pointer';
    exportButton.addEventListener('click', exportPatentInfo);
    document.body.appendChild(exportButton);

    // 创建调试按钮
    const debugButton = document.createElement('button');
    debugButton.textContent = '导出Span调试信息';
    debugButton.style.position = 'fixed';
    debugButton.style.top = '170px';
    debugButton.style.right = '20px';
    debugButton.style.zIndex = '9999';
    debugButton.style.padding = '10px 20px';
    debugButton.style.fontSize = '16px';
    debugButton.style.backgroundColor = '#e74c3c';
    debugButton.style.color = 'white';
    debugButton.style.border = 'none';
    debugButton.style.borderRadius = '5px';
    debugButton.style.boxShadow = '2px 2px 8px rgba(0,0,0,0.2)';
    debugButton.style.cursor = 'pointer';
    debugButton.addEventListener('click', exportDebugInfo);
    document.body.appendChild(debugButton);

    // 创建调试面板
    const debugPanel = document.createElement('div');
    debugPanel.style.position = 'fixed';
    debugPanel.style.top = '220px';
    debugPanel.style.right = '20px';
    debugPanel.style.zIndex = '9998';
    debugPanel.style.width = '400px';
    debugPanel.style.maxHeight = '400px';
    debugPanel.style.backgroundColor = '#f8f9fa';
    debugPanel.style.border = '1px solid #ddd';
    debugPanel.style.borderRadius = '5px';
    debugPanel.style.boxShadow = '0 4px 12px rgba(0,0,0,0.15)';
    debugPanel.style.overflow = 'auto';
    debugPanel.style.padding = '15px';
    debugPanel.style.display = 'none';

    const debugHeader = document.createElement('div');
    debugHeader.textContent = 'Span元素调试信息';
    debugHeader.style.fontSize = '18px';
    debugHeader.style.fontWeight = 'bold';
    debugHeader.style.color = '#e74c3c';
    debugHeader.style.marginBottom = '10px';
    debugHeader.style.paddingBottom = '5px';
    debugHeader.style.borderBottom = '2px solid #eaecef';
    debugPanel.appendChild(debugHeader);

    const debugContent = document.createElement('div');
    debugContent.id = 'tmDebugContent';
    debugContent.style.fontFamily = 'Consolas, Courier New, monospace';
    debugContent.style.fontSize = '14px';
    debugContent.style.lineHeight = '1.5';
    debugPanel.appendChild(debugContent);
    document.body.appendChild(debugPanel);

    // 切换调试面板显示
    debugButton.addEventListener('mouseover', function() {
        debugPanel.style.display = 'block';
        updateDebugInfo();
    });

    debugButton.addEventListener('mouseout', function() {
        debugPanel.style.display = 'none';
    });

    // 导出专利信息
    function exportPatentInfo() {
        let patentsData = [];

        document.querySelectorAll('.table_info').forEach(function(patent) {
            const spans = patent.querySelectorAll('span');
            let Application_OR_Patent_Number = 'CN' + patent.querySelector('.hover_active').textContent.trim();
            Application_OR_Patent_Number = Application_OR_Patent_Number.slice(0, -1) + '.' + Application_OR_Patent_Number.slice(-1);
            const title = patent.querySelector('span span').textContent.trim();

            // 使用调试信息来确定正确的索引
            let Applicant = spans[6].textContent.trim().replace("申请人：", "");
            let PatentType = spans[8].textContent.trim().replace("专利类型：", "");
            let ApplicationDate = spans[10].textContent.trim().replace("申请日：", "");
            let AuthorizationAnnouncementNumber = spans[14].textContent.trim().replace("授权公告号：", "");
            let legalStatus = spans[16].textContent.trim().replace("案件状态：", "");
            let CaseStatus = spans[18].textContent.trim().replace("授权公告日：", "");
            let AuthorizationAnnouncementDate = spans[20].textContent.trim().replace("主分类号：", "");

            patentsData.push({
                '申请号': Application_OR_Patent_Number,
                '发明名称': title,
                '申请（专利权）人': Applicant,
                '专利类型': PatentType,
                '申请日': ApplicationDate,
                '授权公告号': AuthorizationAnnouncementNumber,
                '案件状态': legalStatus,
                '授权公告日': CaseStatus,
                '主分类号': AuthorizationAnnouncementDate
            });
        });

        if (patentsData.length > 0) {
            exportToExcel(patentsData);
        } else {
            alert('没有可导出的专利信息！');
        }
    }

    // 更新调试信息
    function updateDebugInfo() {
        const debugContent = document.getElementById('tmDebugContent');
        debugContent.innerHTML = '';

        document.querySelectorAll('.table_info').forEach(function(patent, index) {
            const patentHeader = document.createElement('div');
            patentHeader.textContent = `专利 ${index + 1} 的Span元素:`;
            patentHeader.style.fontWeight = 'bold';
            patentHeader.style.margin = '10px 0 5px';
            patentHeader.style.color = '#2c3e50';
            debugContent.appendChild(patentHeader);

            const spans = patent.querySelectorAll('span');
            spans.forEach((span, i) => {
                const spanItem = document.createElement('div');
                spanItem.style.display = 'flex';
                spanItem.style.marginBottom = '5px';
                spanItem.style.padding = '5px';
                spanItem.style.backgroundColor = i % 2 === 0 ? '#f8f9fa' : '#ffffff';

                const indexSpan = document.createElement('span');
                indexSpan.textContent = `${i}:`;
                indexSpan.style.fontWeight = 'bold';
                indexSpan.style.minWidth = '40px';
                indexSpan.style.color = '#3498db';
                spanItem.appendChild(indexSpan);

                const contentSpan = document.createElement('span');
                contentSpan.textContent = span.textContent.trim();
                contentSpan.style.flex = '1';
                contentSpan.style.wordBreak = 'break-word';
                spanItem.appendChild(contentSpan);

                debugContent.appendChild(spanItem);
            });
        });
    }

    // 导出调试信息
    function exportDebugInfo() {
        let debugData = [];

        document.querySelectorAll('.table_info').forEach(function(patent) {
            const spans = patent.querySelectorAll('span');
            spans.forEach((span, index) => {
                debugData.push({
                    index: index,
                    content: span.textContent.trim()
                });
            });
        });

        if (debugData.length > 0) {
            let textContent = "Span元素调试信息\n\n";
            textContent += "索引\t内容\n";
            textContent += "--------------------------------\n";

            debugData.forEach(item => {
                textContent += `${item.index}\t${item.content}\n`;
            });

            const blob = new Blob([textContent], { type: 'text/plain;charset=utf-8' });
            const url = URL.createObjectURL(blob);

            const a = document.createElement('a');
            a.href = url;
            a.download = 'span_debug_info.txt';
            a.click();
        } else {
            alert('没有找到Span元素！');
        }
    }

    // 导出数据到 Excel 表格 (使用 SheetJS)
    function exportToExcel(data) {
        // 创建工作簿
        const wb = XLSX.utils.book_new();

        // 将数据转换为工作表
        const ws = XLSX.utils.json_to_sheet(data);

        // 将工作表添加到工作簿
        XLSX.utils.book_append_sheet(wb, ws, "专利信息");

        // 生成Excel文件并下载
        XLSX.writeFile(wb, 'patent_info.xlsx');
    }
})();