# -*- coding: utf-8 -*-
"""So voi tuan truoc (T39) de biet quy uoc: Stt + cach dem nha may."""
import glob, os, unicodedata
from collections import Counter
import openpyxl

BASE = r'C:\Claw 2\Bao cao - Hanh chinh\Bao cao lam mau'
SACH = os.path.join(BASE, 'da lam sach')


def rows_of(path, sheet=None):
    wb = openpyxl.load_workbook(path, read_only=True, data_only=True)
    ws = wb[sheet] if sheet else wb[wb.sheetnames[0]]
    rr = [r for r in ws.iter_rows(values_only=True) if any(c is not None and str(c).strip() != '' for c in r)]
    wb.close()
    return rr


def norm(s):
    return unicodedata.normalize('NFC', str(s).strip()).upper()


for f in sorted(glob.glob(os.path.join(SACH, 'Tuan_39*.xlsx'))):
    m = rows_of(f)
    body = m[1:]
    stt = [str(r[0]).strip() for r in body if str(r[0] or '').strip()]
    names = set(norm(r[1]) for r in body if str(r[1] or '').strip())
    print('===', os.path.basename(f), '| dong:', len(body))
    print('   so dong co Stt:', len(stt), '| max Stt:', max((int(float(x)) for x in stt if x.replace('.0','').isdigit()), default=None))
    print('   nha may khac nhau:', len(names))
    print('   15 ten dau:', sorted(names)[:15])
print()
print('=== Bao_cao_lam_sach_Tuan39.md (phan thong ke) ===')
p = os.path.join(SACH, 'Bao_cao_lam_sach_Tuan39.md')
t = open(p, encoding='utf-8').read()
for ln in t.split('\n'):
    if any(k in ln for k in ('Nhà máy', 'Tổng số', 'Số lượng mẫu', 'đơn hàng', 'Mẫu Mới', 'Đã Ký')):
        print('  ', ln.strip())