YEU CAU: BAO CAO MUA HANG THANG 10/2026 — KY "TU 1->10 THANG 10/2026" File du lieu moi: "mua hang thang 10- 26 - 2.xlsx" (nam ngay trong thu muc nay, vua nhan 10/10/2026). DAY LA BAN CAP NHAT cua ky thang 10: ky nay la "Từ 1->10 Tháng 10" = 10 NGAY, tong 347.102 Kg (dong "Tổng cộng" cot 13). Ban ky "1->3 thang 10" (3 ngay, 116.584 Kg) da lam truoc do — ky nay THAY THE ban do. Trong thu muc nay DA CO cac quy uoc cua ky truoc: SKILL\Skill.txt, skill.md, SKILL\clean_purchase_reports.py, process_all.py, generate_docx_report.py, Bao_cao\build_muahang_t9_portal.py, File-lam-sach\... , NHAT_KY_agy_T9_26.md va NHAT_KY_agy_T10_ky03.md, YEU_CAU_T10_ky03.txt. HAY DOC cac file skill + script do TRUOC de lam dung quy uoc dang co, roi thuc hien 5 buoc sau: 1) LAM SACH (theo SKILL\Skill.txt): - Giu 1 sheet "FILE GỐC" (xoa cac sheet phu "QN- T 10" va "MUA HÀNG T- 10"). - Header dong 4: them " (Khối lượng Kg)" vao cac cot thang 01..09/2026; cot cuoi (cot 13) dat tieu de "Từ 1->10 Tháng 10 2026". - Giu nguyen du lieu + dong "Tổng cộng" cuoi bang (dong 195: Tong 347.102 Kg cho cot ky moi). So nguyen (int). Do rong cot theo skill. - Luu: File-lam-sach\MUA_HANG_10T10-26_DA-LAM-SACH.xlsx 2) SO SANH + BAO CAO DOCX (theo skill.md): - Tinh TB/ngay (Kg/ngay) tung thang: T1..T9 dung so ngay 31/28/31/30/31/30/31/31/30; ky T10 = 10 ngay. - So sanh ky T10 (10 ngay) voi T9 (30 ngay): chenh lech Kg/ngay va %. - Tao DOCX co 2 bang: (a) bang tom tat toan cong ty theo tung thang (Tong Kg, so ngay, TB/ngay, so sanh voi thang truoc); (b) bang chi tiet 191 KH (STT, Ma KH, Ten KH, TB/ngay T1..T9, TB/ngay T10, chenh lech Kg/ngay, chenh lech %). - Dinh dang theo skill.md (Tieu de 16pt in dam can giua; heading 13-14pt; noi dung 11-12pt; so nguyen; phan tram 1 chu so thap phan co dau +/-). - Luu: Bao_cao\BAO_CAO_SO_SANH_MUA_HANG_T10_ky10.docx 3) PORTAL HTML: - Dung Bao_cao\build_muahang_t9_portal.py lam mau, doc tu file Excel DA LAM SACH (theo quy tac chot 14/09/2026: nguon = bang tinh Excel da lam sach, KHONG qua DOCX trung gian; phai co cot "Nhà máy" join tu nha_may_alias). - Luu: Bao_cao\Baocaomuahang_thang10_ky01-10-10-2026.html 4) XUAT DU LIEU DE NAP CSDL (quan trong): - Tao file JSON: Bao_cao\capnhat_csdl_T10_ky10.json voi cau truc: {"ky": "T10", "so_ngay": 10, "tong_kg": , "tb_ngay": , "so_sanh": "", "khach_hang": [{"ma_kh": "KH1090", "ten": "XI NGHIEP THANG LOI", "tong_kg": , "kg_ngay": , "so_sanh": "", "nha_may": ""}, ...]} - Trong do: kg_ngay = tong_kg/10 (lam tron 0 chu so thap phan), so_sanh so voi T9 dang "+X (+Y%)" hoac "-X (-Y%)". - Phai co du 191 khach hang (bo dong "Tổng cộng"). Ky ghi la "T10". 5) NHAT KY: ghi dan tien do vao file NHAT_KY_agy_T10_ky10.md (moi buoc xong ghi 1-2 dong, co so lieu). Dong cuoi ghi "HOAN TAT". LUU Y: BAT BUOC ghi file that (khong chi in ra chat). So lieu phai dung, khong duoc bia. Neu 1 buoc loi thi ghi ro loi vao nhat ky va tiep tuc buoc khac. Khong duoc sua file goc "mua hang thang 10- 26 - 2.xlsx".