pip install PyQt5 python-docx

import sys
from PyQt5.QtWidgets import QApplication, QWidget, QLabel, QLineEdit, QDateEdit, QPushButton, QVBoxLayout, QHBoxLayout, QFormLayout

class TestReportTool(QWidget):
    def __init__(self):
        super().__init__()
        self.setWindowTitle("測試報告一鍵生成工具")
        self.init_ui()

    def init_ui(self):
        # 表單布局
        form_layout = QFormLayout()

        # 輸入字段（積木模塊）
        self.system_url = QLineEdit()
        self.pm_name = QLineEdit()
        self.tm_name = QLineEdit()
        self.tl_name = QLineEdit()
        self.tester_name = QLineEdit()
        self.start_date = QDateEdit()
        self.end_date = QDateEdit()
        self.func_cases = QLineEdit()
        self.func_bugs = QLineEdit()
        self.regression_cases = QLineEdit()
        self.regression_bugs = QLineEdit()

        # 添加字段到表單
        form_layout.addRow("系統(tǒng)測試環(huán)境地址:", self.system_url)
        form_layout.addRow("項目經(jīng)理:", self.pm_name)
        form_layout.addRow("測試經(jīng)理:", self.tm_name)
        form_layout.addRow("測試組長:", self.tl_name)
        form_layout.addRow("測試人員:", self.tester_name)
        form_layout.addRow("測試起始時間:", self.start_date)
        form_layout.addRow("測試結(jié)束時間:", self.end_date)
        form_layout.addRow("功能測試用例數(shù):", self.func_cases)
        form_layout.addRow("功能測試Bug數(shù):", self.func_bugs)
        form_layout.addRow("回歸測試用例數(shù):", self.regression_cases)
        form_layout.addRow("回歸測試缺陷數(shù):", self.regression_bugs)

        # 生成按鈕
        self.generate_btn = QPushButton("生成測試報告")
        self.generate_btn.clicked.connect(self.generate_report)

        # 主布局
        main_layout = QVBoxLayout()
        main_layout.addLayout(form_layout)
        main_layout.addWidget(self.generate_btn)
        self.setLayout(main_layout)

    def generate_report(self):
        # 收集數(shù)據(jù)
        data = {
            "system_url": self.system_url.text(),
            "pm_name": self.pm_name.text(),
            "tm_name": self.tm_name.text(),
            "tl_name": self.tl_name.text(),
            "tester_name": self.testers_name.text(),
            "start_date": self.start_date.date().toString("yyyy-MM-dd"),
            "end_date": self.end_date.date().toString("yyyy-MM-dd"),
            "func_cases": self.func_cases.text(),
            "func_bugs": self.func_bugs.text(),
            "regression_cases": self.regression_cases.text(),
            "regression_bugs": self.regression_bugs.text(),
        }

        # 計算時間塊并添加到data
        time_blocks = calculate_time_blocks(data["start_date"], data["end_date"])
        for phase, dates in time_blocks.items():
            key = f"{phase}_time"
            data[key] = dates

        # 計算通過率
        func_pass_rate = round((1 - int(data["func_bugs"]) / int(data["func_cases"])) * 100, 2)
        data["func_pass_rate"] = f"{func_pass_rate}%"
        reg_pass_rate = round((1 - int(data["regression_bugs"]) / int(data["regression_cases"])) * 100, 2)
        data["reg_pass_rate"] = f"{reg_pass_rate}%"

        # 調(diào)用文檔生成函數(shù)
        from docx_generator import generate_docx
        generate_docx(data)
        print("測試報告生成成功！")

if __name__ == "__main__":
    app = QApplication(sys.argv)
    window = TestReportTool()
    window.show()
    sys.exit(app.exec_())

from docx import Document
from datetime import datetime, timedelta

def calculate_time_blocks(start_date_str, end_date_str):
    start_date = datetime.strptime(start_date_str, "%Y-%m-%d")
    end_date = datetime.strptime(end_date_str, "%Y-%m-%d")
    total_days = (end_date - start_date).days
    if total_days <= 0:
        return {}
    
    # 按比例劃分階段（時間蛋糕）
    phases = {
        "需求評審": 0.1,
        "用例設計": 0.2,
        "用例執(zhí)行": 0.3,
        "回歸測試": 0.2,
        "報告編寫": 0.2
    }
    time_blocks = {}
    current_date = start_date
    for phase, ratio in phases.items():
        days = int(total_days * ratio)
        end_phase = current_date + timedelta(days=days)
        time_blocks[phase] = f"{current_date.strftime('%Y-%m-%d')} - {end_phase.strftime('%Y-%m-%d')}"
        current_date = end_phase
    return time_blocks

def generate_docx(data):
    # 讀取模板文檔
    doc = Document('template.docx')  # 假設模板文件為 template.docx

    # 替換段落中的占位符
    for paragraph in doc.paragraphs:
        for key, value in data.items():
            if key in paragraph.text:
                paragraph.text = paragraph.text.replace(f'{{{key}}}', value)  # 使用雙大括號包裹

    # 替換表格中的占位符
    for table in doc.tables:
        for row in table.rows:
            for cell in row.cells:
                for key, value in data.items():
                    if key in cell.text:
                        cell.text = cell.text.replace(f'{{{key}}}', value)

    # 保存文檔
    doc.save("TestReport.docx")