#!/usr/bin/env python3
# -*- coding: utf-8 -*-
import glob
import json
import os

import openpyxl

# 1) 2025 订单文件逐 sheet 找艾德
for p in glob.glob('/Users/liuxinyuan/Desktop/hermas输入-工作台数据库/**/2025*.xlsx', recursive=True):
    wb = openpyxl.load_workbook(p, read_only=True, data_only=True)
    for ws in wb.worksheets:
        cnt = 0
        names = set()
        for r in ws.iter_rows(values_only=True):
            s = ' '.join(str(c) for c in r if c is not None)
            if '艾德' in s and '艾德范思' not in s:
                cnt += 1
                names.add(r[4] if len(r) > 4 else '')
        if cnt:
            print('2025文件', os.path.basename(p), '| sheet', ws.title, '| 行', cnt, '| 客户名', names)

# 2) 2026 测试订单明细
p = '/Users/liuxinyuan/Desktop/hermas输入-工作台数据库/销售订单_20260101-20261015.xlsx'
if os.path.exists(p):
    wb = openpyxl.load_workbook(p, read_only=True, data_only=True)
    ws = wb.active
    rows = ws.iter_rows(values_only=True)
    head = next(rows)
    print('\n列名:', list(head))
    lines = []
    for r in rows:
        s = ' '.join(str(c) for c in r if c is not None)
        if 'ZHBR260418005' in s:
            lines.append(r)
    print('订单行数', len(lines))
    for r in lines[:12]:
        print('  ', {head[i]: r[i] for i in range(min(len(head), 14))})

# 3) CRM 客户
d = json.load(open('/Users/liuxinyuan/Desktop/Hermes输出-工作类/数据/mcp_customers.json', encoding='utf-8'))
rows = d if isinstance(d, list) else (d.get('customers') or d.get('items') or [])
for x in rows:
    s = json.dumps(x, ensure_ascii=False)
    if '艾德' in s and '艾德范思' not in s:
        print('\nCRM:', s[:400])