# -*- coding: utf-8 -*-
"""Luu W40.xlsx vao du an + kiem chung ca 3 file T40 (moc doi chieu de giao agy)."""
import glob, os, shutil, zipfile, time

DEST = r'C:\Claw 2\Bao cao - Hanh chinh\Bao cao lam mau'
DL = os.path.join(os.path.expanduser('~'), 'Downloads')

# 1. luu W40
tmp = max(glob.glob(os.path.join(DL, '*.tmp')), key=os.path.getmtime)
print('tmp:', os.path.basename(tmp), os.path.getsize(tmp), 'byte | header:', open(tmp, 'rb').read(4))
dst = os.path.join(DEST, 'W40.xlsx')
if os.path.exists(dst):
    print('DA CO (khong ghi de):', dst, os.path.getsize(dst))
else:
    shutil.copy2(tmp, dst)
    print('da luu: W40.xlsx', os.path.getsize(dst), 'byte')
os.remove(tmp)
print('da xoa .tmp')

# 2. backup thu muc da lam sach (truoc khi giao agy)
src = os.path.join(DEST, 'da lam sach')
bak = os.path.join(DEST, '_backup_da_lam_sach_truoc_T40')
if os.path.isdir(bak):
    print('backup da co:', bak)
else:
    shutil.copytree(src, bak)
    print('backup moi:', bak, len(os.listdir(bak)), 'file')

# 3. kiem chung 3 file T40
import openpyxl
for name in ['TUẦN 40 (28.09-04.10).xlsx', 'KẾT QUẢ MẪU TUẦN 40.xlsx', 'W40.xlsx']:
    p = os.path.join(DEST, name)
    print()
    print('===', name, os.path.getsize(p) if os.path.exists(p) else 'KHONG CO', 'byte | zip:', zipfile.is_zipfile(p))
    if not os.path.exists(p):
        continue
    wb = openpyxl.load_workbook(p, read_only=True, data_only=True)
    print('  sheets (%d):' % len(wb.sheetnames), wb.sheetnames)
    for sn in wb.sheetnames:
        ws = wb[sn]
        n = last = 0
        for i, row in enumerate(ws.iter_rows(values_only=True), start=1):
            if any(c is not None and str(c).strip() != '' for c in row):
                n += 1
                last = i
            if i >= 8000:
                break
        if n:
            print('   - %-42s dong co du lieu: %5d | dong cuoi: %5d' % (sn, n, last))
    wb.close()