#!/usr/bin/env python3 """ MOPS 重大訊息靜態報告生成器 =========================== 從 SQLite 資料庫生成靜態 HTML 報告，可直接在瀏覽器開啟。使用方式： python generate_report.py # 生成 report.html python generate_report.py --open # 生成並開啟 """ import sys sys.stdout.reconfigure(encoding='utf-8') import sqlite3 import json from pathlib import Path from datetime import datetime import argparse import webbrowser # ===== 設定 ===== BASE_DIR = Path(__file__).parent DB_PATH = BASE_DIR / "data" / "mops_announcements.db" OUTPUT_PATH = BASE_DIR / "report.html" def load_data(): """從資料庫載入資料""" if not DB_PATH.exists(): print(f"錯誤: 資料庫不存在 {DB_PATH}") sys.exit(1) conn = sqlite3.connect(DB_PATH) conn.row_factory = sqlite3.Row # 載入公告 cursor = conn.execute(""" SELECT id, publish_date, announce_date, announce_time, stock_code, company_name, subject, content, has_appraiser_info, is_real_estate_related FROM announcements ORDER BY announce_date DESC, announce_time DESC """) announcements = [dict(row) for row in cursor.fetchall()] # 載入估價師記錄 cursor = conn.execute(""" SELECT r.*, a.stock_code, a.company_name, a.announce_date FROM appraiser_records r JOIN announcements a ON r.announcement_id = a.id """) appraiser_records = [dict(row) for row in cursor.fetchall()] # 統計 cursor = conn.execute("SELECT COUNT(*) FROM announcements") total_count = cursor.fetchone()[0] cursor = conn.execute("SELECT COUNT(*) FROM announcements WHERE has_appraiser_info = 1") appraiser_count = cursor.fetchone()[0] cursor = conn.execute("SELECT COUNT(*) FROM announcements WHERE is_real_estate_related = 1") real_estate_count = cursor.fetchone()[0] cursor = conn.execute("SELECT MIN(announce_date), MAX(announce_date) FROM announcements") date_range = cursor.fetchone() # 每日統計 cursor = conn.execute(""" SELECT announce_date, COUNT(*) as total, SUM(has_appraiser_info) as appraiser, SUM(is_real_estate_related) as real_estate FROM announcements GROUP BY announce_date ORDER BY announce_date """) daily_stats = [dict(row) for row in cursor.fetchall()] conn.close() return { 'announcements': announcements, 'appraiser_records': appraiser_records, 'stats': { 'total': total_count, 'appraiser': appraiser_count, 'real_estate': real_estate_count, 'date_min': date_range[0], 'date_max': date_range[1], }, 'daily_stats': daily_stats, 'generated_at': datetime.now().isoformat(), } def generate_html(data): """生成 HTML 內容""" html_template = ''' MOPS 重大訊息瀏覽器

📊 MOPS 重大訊息瀏覽器

總公告數

估價師相關

不動產相關

資料範圍

日期	代號	公司	主旨	類型

1 / 1

🏛 估價師事務所統計

詳細記錄

📈 每日公告趨勢

📊 公告類型分佈

此頁面顯示未經處理的原始公告內容，方便檢視資料品質。點擊任一公告查看完整內容。

''' return html_template def main(): parser = argparse.ArgumentParser(description='生成 MOPS 靜態報告') parser.add_argument('--open', action='store_true', help='生成後自動開啟') args = parser.parse_args() print("載入資料...") data = load_data() print(f"公告數: {data['stats']['total']}") print(f"估價師相關: {data['stats']['appraiser']}") print("生成 HTML...") html = generate_html(data) print(f"寫入檔案: {OUTPUT_PATH}") OUTPUT_PATH.write_text(html, encoding='utf-8') print("✅ 完成！") if args.open: print("開啟瀏覽器...") webbrowser.open(OUTPUT_PATH.as_uri()) if __name__ == "__main__": main()

🏛 估價師事務所統計

詳細記錄

📈 每日公告趨勢

📊 公告類型分佈

公告詳情