{
  "拆除知识类": [
    {
      "title": "装修拆除，怎么更省钱？",
      "media_id": "soundrecording_f285ee6c0edbe64bf6692f0a1d5fb1d9_2a147eeb1f14bc8bbd11c6a0c40e14ba7455037093599654",
      "date": "2026-05-27"
    },
    {
      "title": "装修垃圾清运避坑，搞懂 3 种模式避开 4 种套路",
      "media_id": "wechatarticle_f285ee6c0edbe64bf6692f0a1d5fb1d9_7b249385d5da12eee128a536b362ef877455037093599654",
      "date": "2026-05-27"
    },
    {
      "title": "二手房拆旧避坑：这 5 处结构别乱动，安全比美观更重要",
      "media_id": "wechatarticle_f285ee6c0edbe64bf6692f0a1d5fb1d9_ede1d7649171c8b57eb54f485c5f15c87455037093599654",
      "date": "2026-05-15"
    },
    {
      "title": "装修先拆除后水电，顺序不能错",
      "media_id": "wechatarticle_f285ee6c0edbe64bf6692f0a1d5fb1d9_d816fc36d369567157db6f4ee47831c97455037093599654",
      "date": "2026-04-29"
    },
    {
      "title": "装修先拆除后水电，顺序不能错8.17",
      "media_id": "wechatarticle_f285ee6c0edbe64bf6692f0a1d5fb1d9_17cba0b70329b2c2d7ab1dd9019f0dda7455037093599654",
      "date": "2026-04-29"
    },
    {
      "title": "自己装修开头难，拆除水电牢记重点10.17",
      "media_id": "wechatarticle_f285ee6c0edbe64bf6692f0a1d5fb1d9_b3b41a4a9fef8a324def03aa617690ce7455037093599654",
      "date": "2026-04-29"
    },
    {
      "title": "拆除进场，业主与装修机构有哪些矛盾？1.4",
      "media_id": "wechatarticle_f285ee6c0edbe64bf6692f0a1d5fb1d9_4f89cf3e78887161522a0f3c9955c8ca7455037093599654",
      "date": "2026-04-29"
    },
    {
      "title": "旧房重新装修，拆除怎么做更省钱？6.25",
      "media_id": "wechatarticle_f285ee6c0edbe64bf6692f0a1d5fb1d9_4a482d76082a90173a66d911c330127d7455037093599654",
      "date": "2026-04-29"
    },
    {
      "title": "客厅阳台墙体全部拆除，放洗衣机怎么遮挡？1.8",
      "media_id": "wechatarticle_f285ee6c0edbe64bf6692f0a1d5fb1d9_af1687873deabfa1c7ad3f136fa64b4d7455037093599654",
      "date": "2026-04-29"
    },
    {
      "title": "精装修改造，阳台必须拆除重新做吗？4.20",
      "media_id": "wechatarticle_f285ee6c0edbe64bf6692f0a1d5fb1d9_b9d7be89a0187c9b0442cf0adcaaa0c27455037093599654",
      "date": "2026-04-29"
    },
    {
      "title": "拆除环节的“价格刺客”！20个隐形消费防不胜防，装修老手都未必全知道！",
      "media_id": "wechatarticle_f285ee6c0edbe64bf6692f0a1d5fb1d9_a7bab72a924db4f8e01e8f4d768a42f37455037093599654",
      "date": "2026-04-29"
    }
  ],
  "水电改造类": [
    {
      "title": "做了20年装修：这10 种水电做法不建议做",
      "media_id": "wechatarticle_f285ee6c0edbe64bf6692f0a1d5fb1d9_e224354aa6038ede976b4f1d937244d37455037093599654",
      "date": "2026-06-09"
    },
    {
      "title": "装修水电改造，怎么做更省钱？",
      "media_id": "soundrecording_f285ee6c0edbe64bf6692f0a1d5fb1d9_bd7a393eb1f10e1f1a84fa89d21da0707455037093599654",
      "date": "2026-06-02"
    },
    {
      "title": "家装水电，如何验收？",
      "media_id": "wechatarticle_f285ee6c0edbe64bf6692f0a1d5fb1d9_1872e5ba85d64fde373e0f927a57ab817455037093599654",
      "date": "2026-04-29"
    },
    {
      "title": "水电改造两个绝招，照着做，想被坑都难！",
      "media_id": "wechatarticle_f285ee6c0edbe64bf6692f0a1d5fb1d9_491cafeed1aa596c6ff2d4feef34a47a7455037093599654",
      "date": "2026-04-29"
    },
    {
      "title": "装修水电改造最难，也是最简单的1.25",
      "media_id": "wechatarticle_f285ee6c0edbe64bf6692f0a1d5fb1d9_b61ccee5dfd937185797a523efc87bee7455037093599654",
      "date": "2026-04-29"
    },
    {
      "title": "水电改造各种计费方法，哪种更好？",
      "media_id": "wechatarticle_f285ee6c0edbe64bf6692f0a1d5fb1d9_37b6cdb770c5c059605ccdab0c52ef5b7455037093599654",
      "date": "2026-04-29"
    },
    {
      "title": "水电改造各种计费方法，哪种更好？12.15",
      "media_id": "wechatarticle_f285ee6c0edbe64bf6692f0a1d5fb1d9_fcb6d62a9fb1808e9a994bf4bc2a7eda7455037093599654",
      "date": "2026-04-29"
    },
    {
      "title": "自己买水电料，水电就能省钱？7.22",
      "media_id": "wechatarticle_f285ee6c0edbe64bf6692f0a1d5fb1d9_1659f0451bf5e2996f95c58928f268f77455037093599654",
      "date": "2026-04-29"
    },
    {
      "title": "水电改造翻车，装修第一步就入坑6.27",
      "media_id": "wechatarticle_f285ee6c0edbe64bf6692f0a1d5fb1d9_6517db68803731f95747d2e426a9fd227455037093599654",
      "date": "2026-04-29"
    }
  ],
  "费用难度类": [
    {
      "title": "旧房老房装修，怎么做更省钱10.13",
      "media_id": "wechatarticle_f285ee6c0edbe64bf6692f0a1d5fb1d9_f958f503b08b2156b6eda01e819fefe17455037093599654",
      "date": "2026-04-29"
    },
    {
      "title": "新房装修难，旧房改造更可怕12.29",
      "media_id": "wechatarticle_f285ee6c0edbe64bf6692f0a1d5fb1d9_a622d9192ba99043f6f7cb533e71185b7455037093599654",
      "date": "2026-04-29"
    },
    {
      "title": "旧房装修肯定比新房贵，这是常识！9.17",
      "media_id": "wechatarticle_f285ee6c0edbe64bf6692f0a1d5fb1d9_eb38a580560a9a1f7d2adcbae742db197455037093599654",
      "date": "2026-04-29"
    },
    {
      "title": "旧房装修比新房还贵？并不仅仅如此8.26",
      "media_id": "wechatarticle_f285ee6c0edbe64bf6692f0a1d5fb1d9_f7acae586e5518de88dadceb81f7e7187455037093599654",
      "date": "2026-04-29"
    },
    {
      "title": "旧房装修咋比新房还贵？11.6",
      "media_id": "wechatarticle_f285ee6c0edbe64bf6692f0a1d5fb1d9_d7865ccb68b3b88a420c5e4e6fb325f47455037093599654",
      "date": "2026-04-29"
    },
    {
      "title": "85m²老房变身现代网红家，值得效仿",
      "media_id": "wechatarticle_f285ee6c0edbe64bf6692f0a1d5fb1d9_cfb91d63793db60be8b6b9f6ec8548ef7455037093599654",
      "date": "2026-04-29"
    },
    {
      "title": "80㎡两室老房，最少的费用改造北欧日式混搭家",
      "media_id": "wechatarticle_f285ee6c0edbe64bf6692f0a1d5fb1d9_1312dd26ffb0338e1f21a788d25e739a7455037093599654",
      "date": "2026-04-29"
    }
  ],
  "厨卫翻新类": [],
  "精装房改造类": [
    {
      "title": "精装房=精装坑？网友血泪吐槽太扎心：劝你别买是真为你好！",
      "media_id": "wechatarticle_f285ee6c0edbe64bf6692f0a1d5fb1d9_712af15b65f1da5061fcdde6d947e8517455037093599654",
      "date": "2026-04-29"
    },
    {
      "title": "精装修，阳台微改有几种做法？9.21",
      "media_id": "wechatarticle_f285ee6c0edbe64bf6692f0a1d5fb1d9_ed4f081b5288b4c74b5445af13a656bf7455037093599654",
      "date": "2026-04-29"
    },
    {
      "title": "精装修微改，全屋定制有窍门2.25",
      "media_id": "wechatarticle_f285ee6c0edbe64bf6692f0a1d5fb1d9_a7fda24781f1e38f9daa8a807afcf09b7455037093599654",
      "date": "2026-04-29"
    },
    {
      "title": "精装修三室局改加全屋定制 ，6万全部搞定",
      "media_id": "wechatarticle_f285ee6c0edbe64bf6692f0a1d5fb1d9_484af85472bb4cd771361c4b86fc7a877455037093599654",
      "date": "2026-04-29"
    }
  ],
  "二手房避坑类": [
    {
      "title": "住了十年老房才明白：改造时最该避开的4个隐形坑",
      "media_id": "wechatarticle_f285ee6c0edbe64bf6692f0a1d5fb1d9_d9fb2daa5da8531ca4363a25f1ccc2117455037093599654",
      "date": "2026-06-07"
    },
    {
      "title": "装修必读，36条避坑法则（四）",
      "media_id": "soundrecording_f285ee6c0edbe64bf6692f0a1d5fb1d9_e1894b1efb21eefbb17ca649627bf2887455037093599654",
      "date": "2026-04-29"
    },
    {
      "title": "装修避坑，切勿盲目“听话”",
      "media_id": "soundrecording_f285ee6c0edbe64bf6692f0a1d5fb1d9_98d730d6b86c987f3ae0768ae1106fd87455037093599654",
      "date": "2026-04-29"
    },
    {
      "title": "血泪警告！超龄二手房6大致命点，谨慎入手",
      "media_id": "wechatarticle_f285ee6c0edbe64bf6692f0a1d5fb1d9_799fc34fcec075118c92844fdd1d40e47455037093599654",
      "date": "2026-04-29"
    },
    {
      "title": "二手房血泪教训！20万打水漂",
      "media_id": "wechatarticle_f285ee6c0edbe64bf6692f0a1d5fb1d9_a9c0c4a8a7674ec1998c6c852dfaa5477455037093599654",
      "date": "2026-04-29"
    },
    {
      "title": "拆铲施工，新房和旧房都必须经历6.13",
      "media_id": "wechatarticle_f285ee6c0edbe64bf6692f0a1d5fb1d9_02854f7e56ada88960fa5ce048d4a0767455037093599654",
      "date": "2026-04-29"
    },
    {
      "title": "老旧房改造，需要有足够的经验和预知风险的能力5.18",
      "media_id": "wechatarticle_f285ee6c0edbe64bf6692f0a1d5fb1d9_bafe3e247dbff7e67d66202a862a20f57455037093599654",
      "date": "2026-04-29"
    },
    {
      "title": "老房逆袭or消亡？4种结局揭秘",
      "media_id": "wechatarticle_f285ee6c0edbe64bf6692f0a1d5fb1d9_de5f27a3abbbae51e7775b70900d4c1e7455037093599654",
      "date": "2026-04-29"
    },
    {
      "title": "地暖砸瓷砖+老房换暖气，一定重视11.24",
      "media_id": "wechatarticle_f285ee6c0edbe64bf6692f0a1d5fb1d9_7b04c609e1abcf0f225faeed96430b4a7455037093599654",
      "date": "2026-04-29"
    },
    {
      "title": "旧房二手房装修，一定要知道的6件事7.27",
      "media_id": "wechatarticle_f285ee6c0edbe64bf6692f0a1d5fb1d9_c0f86ebff9fd81c449975c27442da06f7455037093599654",
      "date": "2026-04-29"
    },
    {
      "title": "从旧到新！90㎡二手房如何变身为现代原木简约风格？",
      "media_id": "wechatarticle_f285ee6c0edbe64bf6692f0a1d5fb1d9_f9f6a7ee0cfb8065446f8a8e0f222eb87455037093599654",
      "date": "2026-04-29"
    },
    {
      "title": "08-🛠️旧房老房二手房装修经验",
      "media_id": "folder_7455037378803683",
      "date": "2026-04-29"
    }
  ],
  "买房避坑类": [
    {
      "title": "高层住宅PK老破小，谁是智商税？真实住户哭诉血泪史",
      "media_id": "wechatarticle_f285ee6c0edbe64bf6692f0a1d5fb1d9_bd6ca54830625afb45de1e3bfbc74adf7455037093599654",
      "date": "2026-04-29"
    },
    {
      "title": "住了10年老破小，我终于知道什么叫“毁掉一个家”",
      "media_id": "wechatarticle_f285ee6c0edbe64bf6692f0a1d5fb1d9_af3bd44a53b0dc1a0742c323e0e773217455037093599654",
      "date": "2026-04-29"
    },
    {
      "title": "老破小装修避坑指南：从破败到宜居，一篇搞定所有装修雷区！",
      "media_id": "wechatarticle_f285ee6c0edbe64bf6692f0a1d5fb1d9_fefb6086978f77235753b978772dcc977455037093599654",
      "date": "2026-04-29"
    },
    {
      "title": "为娃上学购买50㎡老破小，这届父母太拼了",
      "media_id": "wechatarticle_f285ee6c0edbe64bf6692f0a1d5fb1d9_fa220ec3b28b0f7d36d3386bbc6ef02e7455037093599654",
      "date": "2026-04-29"
    },
    {
      "title": "从33楼到老破小：高层业主的换房抉择与感悟",
      "media_id": "wechatarticle_f285ee6c0edbe64bf6692f0a1d5fb1d9_a4dc97abffa3ea2756818ee6e22cbdfb7455037093599654",
      "date": "2026-04-29"
    },
    {
      "title": "从老破小到独居美宅：45㎡顶楼蜕变揭秘",
      "media_id": "wechatarticle_f285ee6c0edbe64bf6692f0a1d5fb1d9_43be8713c8271158840c458f438cc1057455037093599654",
      "date": "2026-04-29"
    }
  ]
}

import json
import os
import re
from datetime import datetime

# Directory containing all search result files
results_dir = r"C:\Users\Administrator\.workbuddy\projects\e-workspaces-2026-06-21-09-43-05\c0145562-e8ef-41f7-a2ad-46d6da460828\tool-results"

all_articles = {}  # media_id -> article info

# Read all files in the directory
for filename in os.listdir(results_dir):
    filepath = os.path.join(results_dir, filename)
    if not os.path.isfile(filepath):
        continue
    try:
        with open(filepath, 'r', encoding='utf-8') as f:
            content = f.read()
        data = json.loads(content)
        knowledge_list = data.get("searched_knowledge_list", [])
        for item in knowledge_list:
            knowledge = item.get("knowledge", {})
            media_id = knowledge.get("media_id", "")
            title = knowledge.get("title", "")
            create_time = knowledge.get("create_time", "0")
            introduction = knowledge.get("introduction", "")
            
            if media_id and media_id not in all_articles:
                all_articles[media_id] = {
                    "media_id": media_id,
                    "title": title,
                    "create_time": int(create_time) if create_time else 0,
                    "introduction": introduction[:500]
                }
    except:
        pass

# Helper: is this a case study (project showcase)?
def is_case_study(title):
    # Starts with area number + has style/showcase keywords = case study
    starts_with_area = bool(re.match(r'^\d+㎡', title) or re.match(r'^\d+平', title) or re.match(r'^\d+m²', title) or re.match(r'^\d+m2', title))
    
    showcase_keywords = ['前后对比', '变身', '完工', '速变', '逆袭', '前后效果', '对比', '惊艳',
                         '风', '日式', '北欧', '现代', '简约', '原木', '清新', '暖居', '轻奢', 
                         '复古', '美式', '混搭', '婚房', '奶油', '法式', '极简', '黑白',
                         '三口之家', '一人住', '独居', '养老房', '民宿', '单身',
                         '打造', '成就', '满足', '三室', '两室', '一室',
                         '翻新', '改造', '新装', '重装', '焕新', '换新颜']
    
    knowledge_keywords = ['怎么', '如何', '为什么', '能不能', '要不要', '需要吗', '避坑', '注意',
                          '肯定', '坑', '省钱', '贵', '费用', '难度', '值得', '顺序', '流程',
                          '经验', '常识', '警告', '血泪', '教训', '要点', '重点', '知识',
                          '绝招', '计费', '验收', '必须', '别', '千万', '一定', '牢记',
                          '策略', '方案', '指南', '清单', '揭秘', '真相']
    
    if starts_with_area:
        # If it starts with area, it's likely a case study
        # But keep if it has strong knowledge keywords
        if any(kw in title for kw in knowledge_keywords):
            return False
        return True
    
    # Check for case study patterns without area prefix
    case_patterns = [
        r'(老房|旧房|二手房).*(逆袭|变身|完工|速变|前后对比|惊艳|换新颜|焕新|新装|重装|翻新)',
        r'(精装|精装房).*(改造|变身|逆袭|对比)',
    ]
    for pattern in case_patterns:
        if re.search(pattern, title):
            # But keep if has knowledge keywords
            if any(kw in title for kw in knowledge_keywords):
                return False
            return True
    
    return False

# Helper: does title have old house keywords?
def has_old_house_kw(title, intro=""):
    text = title + " " + intro
    return any(kw in text for kw in ['老房', '旧房', '二手房', '精装房', '精装修', '老破小', '老破大'])

# Helper: does title have knowledge/educational value?
def has_knowledge_value(title):
    knowledge_keywords = ['怎么', '如何', '为什么', '能不能', '要不要', '需要吗', '避坑', '注意',
                          '肯定', '坑', '省钱', '贵', '费用', '难度', '值得', '顺序', '流程',
                          '经验', '常识', '警告', '血泪', '教训', '要点', '重点', '知识',
                          '绝招', '计费', '验收', '必须', '别', '千万', '一定', '牢记',
                          '策略', '方案', '指南', '清单', '揭秘', '真相', '不建议', '不能',
                          '误', '错', '套路', '隐形', '价格刺客', '艰难', '可怕', '难',
                          '之间', '矛盾', '冲突', '问题']
    return any(kw in title for kw in knowledge_keywords)

# ============================
# STEP 1: Build category-specific article lists
# ============================

categories = {
    "拆除知识类": [],
    "水电改造类": [],
    "费用难度类": [],
    "厨卫翻新类": [],
    "精装房改造类": [],
    "二手房避坑类": [],
    "买房避坑类": []
}

assigned_ids = set()

# --- 拆除知识类 ---
# Include articles about 拆除/砸墙/承重墙/垃圾 that are knowledge-type
for media_id, article in all_articles.items():
    if media_id in assigned_ids:
        continue
    title = article["title"]
    if any(kw in title for kw in ['拆除', '砸墙', '承重墙', '垃圾清运', '垃圾外运', '拆旧', '非承重']):
        if not is_case_study(title):
            # Keep knowledge articles + a few representative case articles with knowledge value
            if has_knowledge_value(title) or any(kw in title for kw in ['旧房', '老房', '二手房', '精装']):
                categories["拆除知识类"].append(article)
                assigned_ids.add(media_id)

# --- 水电改造类 ---
# Include water/electricity articles that are relevant to old house renovation
for media_id, article in all_articles.items():
    if media_id in assigned_ids:
        continue
    title = article["title"]
    intro = article.get("introduction", "")
    
    # Articles with 水电 in title that are knowledge-type
    if any(kw in title for kw in ['水电', '水管', '电路改造', '水路', '线管']):
        if not is_case_study(title) and has_knowledge_value(title):
            categories["水电改造类"].append(article)
            assigned_ids.add(media_id)
    
    # Articles about 水电全换/插座/开关 that relate to old house
    elif any(kw in title for kw in ['插座', '开关', '漏电', '电线']):
        if not is_case_study(title) and (has_knowledge_value(title) or has_old_house_kw(title, intro)):
            # Only include if it has old house context
            if has_old_house_kw(title, intro):
                categories["水电改造类"].append(article)
                assigned_ids.add(media_id)
    
    # Specific old house water/electricity articles
    elif '水电' in title and any(kw in title for kw in ['全换', '没有必要', '省钱', '计费', '验收', '翻车', '不建议', '最难']):
        if not is_case_study(title):
            categories["水电改造类"].append(article)
            assigned_ids.add(media_id)

# --- 精装房改造类 ---
# Only knowledge articles about 精装房/精装修
for media_id, article in all_articles.items():
    if media_id in assigned_ids:
        continue
    title = article["title"]
    if any(kw in title for kw in ['精装房', '精装修', '开发商']):
        if not is_case_study(title):
            # Keep knowledge articles and articles about精装房 pitfalls
            if has_knowledge_value(title) or any(kw in title for kw in ['坑', '艰难', '必须', '需要', '改', '微改', '局部', '阳台', '厨房', '门厅', '吊顶']):
                categories["精装房改造类"].append(article)
                assigned_ids.add(media_id)

# --- 费用难度类 ---
# Old house cost/difficulty articles
for media_id, article in all_articles.items():
    if media_id in assigned_ids:
        continue
    title = article["title"]
    if any(kw in title for kw in ['旧房', '老房']) and any(kw in title for kw in ['省钱', '贵', '费用', '成本', '预算', '难度', '值得', '难']):
        if not is_case_study(title):
            categories["费用难度类"].append(article)
            assigned_ids.add(media_id)
    elif '翻新' in title and any(kw in title for kw in ['省钱', '贵', '费用', '成本']):
        if not is_case_study(title):
            categories["费用难度类"].append(article)
            assigned_ids.add(media_id)
    elif any(kw in title for kw in ['旧房.*贵', '老房.*贵']) and not is_case_study(title):
        categories["费用难度类"].append(article)
        assigned_ids.add(media_id)

# --- 厨卫翻新类 ---
# Old house kitchen/bathroom renovation knowledge
for media_id, article in all_articles.items():
    if media_id in assigned_ids:
        continue
    title = article["title"]
    if any(kw in title for kw in ['老房', '旧房', '二手房']) and any(kw in title for kw in ['厨卫', '厨房', '卫生间', '防水', '马桶', '浴室']):
        if not is_case_study(title):
            categories["厨卫翻新类"].append(article)
            assigned_ids.add(media_id)
    elif '卫生间' in title and any(kw in title for kw in ['翻新', '不砸', '不动', '局部']):
        if not is_case_study(title):
            categories["厨卫翻新类"].append(article)
            assigned_ids.add(media_id)

# --- 买房避坑类 ---
# Articles about buying old houses, 老破小 decision-making (knowledge only)
for media_id, article in all_articles.items():
    if media_id in assigned_ids:
        continue
    title = article["title"]
    # Only knowledge articles about buying decisions
    if any(kw in title for kw in ['老破小', '老破大', '高层.*老破小']):
        if has_knowledge_value(title) and not is_case_study(title):
            categories["买房避坑类"].append(article)
            assigned_ids.add(media_id)
        elif any(kw in title for kw in ['智商税', '毁掉', '避坑指南', '抉择', '感悟', '买']):
            if not is_case_study(title):
                categories["买房避坑类"].append(article)
                assigned_ids.add(media_id)
    elif any(kw in title for kw in ['买房', '选房', '学区房', '购房']) and has_old_house_kw(title, article.get("introduction", "")):
        if not is_case_study(title):
            categories["买房避坑类"].append(article)
            assigned_ids.add(media_id)

# --- 二手房避坑类 ---
# Remaining old house knowledge articles
for media_id, article in all_articles.items():
    if media_id in assigned_ids:
        continue
    title = article["title"]
    intro = article.get("introduction", "")
    
    # Knowledge articles about old house renovation
    if has_old_house_kw(title, intro):
        if not is_case_study(title) and has_knowledge_value(title):
            categories["二手房避坑类"].append(article)
            assigned_ids.add(media_id)
        # Also include articles with strong knowledge indicators even without standard keywords
        elif not is_case_study(title) and any(kw in title for kw in ['旧房', '老房', '二手房']) and any(kw in title for kw in ['经验', '常识', '警告', '血泪', '教训', '避坑', '注意', '知道', '必须', '一定']):
            categories["二手房避坑类"].append(article)
            assigned_ids.add(media_id)

# ============================
# STEP 2: Sort and print
# ============================

# Sort each category by create_time descending
for cat in categories:
    categories[cat].sort(key=lambda x: x["create_time"], reverse=True)

# Convert create_time to readable date
for cat in categories:
    for article in categories[cat]:
        ts = article["create_time"]
        if ts > 0:
            dt = datetime.fromtimestamp(ts / 1000)
            article["date_str"] = dt.strftime("%Y-%m-%d")
        else:
            article["date_str"] = "unknown"

print("="*80)
print("FINAL CATEGORIZED ARTICLES (KNOWLEDGE ONLY)")
print("="*80)

total = 0
for category, articles in categories.items():
    print(f"\n## {category} ({len(articles)}篇)")
    for i, a in enumerate(articles, 1):
        print(f"  {i}. [{a['date_str']}] {a['title']}")
        print(f"     media_id: {a['media_id']}")
    total += len(articles)

print(f"\n{'='*80}")
print(f"Total: {total}")

# Save to JSON
output_path = r"E:\workspaces\2026-06-21-09-43-05\.workbuddy\skills\老房改造不踩雷\article_list.json"
output = {cat: [{"title": a["title"], "media_id": a["media_id"], "date": a["date_str"]} for a in articles] for cat, articles in categories.items()}
with open(output_path, 'w', encoding='utf-8') as f:
    json.dump(output, f, ensure_ascii=False, indent=2)
print(f"\nSaved to: {output_path}")

# Print all media_ids grouped by category for batch fetching
print("\n\n=== MEDIA IDS BY CATEGORY ===")
for cat, articles in categories.items():
    print(f"\n# {cat} ({len(articles)})")
    for a in articles:
        print(f"{a['media_id']}")

---
skill_id: 2062
name: 老房改造不踩雷
identifier: laofang-gaizao-bucailei
slug: laofang-gaizao-bucailei
description: 【老房改造业主必看】你家的房子是老房、旧房、二手房吗？担心拆除被坑、水电要不要全换、承重墙不敢动、费用比新房贵太多？这个Skill内置装修课堂知识库，直接回答你的问题——问拆除、问水电、问费用、问结构安全、问厨卫翻新、问精装房怎么改，全部覆盖。适合正在考虑老房翻新、二手房装修、精装房改造的业主。
version: 1.0.1
tags:
  - 老房改造
  - 旧房翻新
  - 二手房装修
  - 装修避坑
  - 水电改造
trigger:
  - 老房改造
  - 旧房翻新
  - 二手房装修
  - 老房水电改造
  - 承重墙
  - 拆除费用
  - 老房翻新费用
  - 精装房改造
  - 厨卫翻新
  - 老房避坑
  - 老房装修
  - 二手房翻新
  - 旧房装修
  - 老房拆除
  - 老房水电
  - 老房防水
  - 老房翻新多少钱
  - 二手房要不要全拆
  - 老房水电要不要全换
  - 承重墙怎么辨别
  - 精装房怎么改造
  - 老房翻新比新房贵多少
---

# 老房改造不踩雷

## 角色设定

你是一位有20年实战经验的装修专家，专精老房、旧房、二手房翻新改造领域。你的回答风格直接、实在、不说废话，像老师傅跟业主面对面聊天一样——该夸的夸，该骂的骂，该提醒的提醒。

你的核心原则：
- **说人话**：不用行业黑话，用业主听得懂的语言
- **有立场**：不骑墙，好就是好，坑就是坑，明确表态
- **给方案**：不只说"别这样做"，还要说"应该怎么做"
- **讲逻辑**：每个建议都有理由，不是拍脑袋

## 知识来源

本Skill内置从学到装｜装修课堂知识库，以下文件位于 `references/` 目录：

1. `拆除知识类.md` — 老房拆除流程、拆除费用、承重墙辨别、垃圾外运、拆除避坑
2. `水电改造类.md` — 老房水电要不要全换、水路改造、电路升级、线管排查
3. `费用难度类.md` — 老房翻新比新房贵在哪、费用明细、省钱策略、改造难度
4. `厨卫翻新类.md` — 厨卫局部改造的坑、防水重做、瓷砖处理
5. `精装房改造类.md` — 精装房微改策略、哪些该留哪些该换、精装房避坑
6. `二手房避坑类.md` — 二手房装修注意事项、验房要点、常见陷阱
7. `买房避坑类.md` — 买老房前的注意事项、房型选择、学区房避坑

## 回答规则

### 1. 回答前先读知识库

收到用户问题后，先根据问题类型读取对应的reference文件：
- 问拆除/砸墙/垃圾 → 读 `拆除知识类.md`
- 问水电/线路/水管 → 读 `水电改造类.md`
- 问费用/预算/贵不贵/省钱 → 读 `费用难度类.md`
- 问厨房/卫生间/防水 → 读 `厨卫翻新类.md`
- 问精装房/开发商装修 → 读 `精装房改造类.md`
- 问二手房/验房/买二手房 → 读 `二手房避坑类.md`
- 问买房/选房/学区房 → 读 `买房避坑类.md`

如果问题跨多个领域，读取多个对应文件。

### 2. 回答结构

每个回答按以下结构组织：

**【直接回答】**
先给出最核心的结论，3-5句话说明白，不绕弯子。

**【详细分析】**
展开说明为什么这样建议，包括：
- 问题背后的套路/逻辑
- 具体数据或对比
- 常见误区纠正

**【实操建议】**
给出业主可以直接执行的动作：
- 该找谁确认什么
- 该在合同里写什么
- 该注意什么细节

**【避坑提醒】**
列出这个场景下最容易踩的1-3个坑，简明扼要。

### 3. 回答风格

- 像跟朋友聊天，不说教
- 可以用"你"来称呼用户
- 关键信息用加粗或列表突出
- 涉及价格时给区间参考，不写死数字
- 如果用户的问题信息不够，追问关键信息（房龄、面积、城市等）

### 4. 特殊情况

- 如果用户问的内容不在知识库范围内，诚实说"这个问题我知识库里没有现成答案"，然后基于经验给建议
- 涉及承重墙、结构安全的问题，建议找专业鉴定机构，不做主观判断
- 如果用户只是发泄情绪（被坑了很气），先共情，再给解决方案

## 禁止事项

- 不引导到任何外部平台
- 不提"订阅""关注""会员""付费"等词
- 不说"更多信息请查看"之类的话
- 不输出无关的客套话
- 回答完毕即结束，不加任何引导性结尾