GOI CAP NHAT LOCKET GOLD - CPANEL (GIU DATABASE CU)

QUAN TRONG
- Goi nay KHONG kem config.php. Khong xoa/ghi de config.php dang chay tren hosting.
- KHONG import database.mysql.sql va KHONG import database.migrate-from-old.sql vao database hien tai.
- KHONG xoa bang, khong TRUNCATE, khong DROP DATABASE.

CAC BUOC CAP NHAT
1. Sao luu database hien tai bang phpMyAdmin > Export. Nen tai ca source dang chay ve may tinh.
2. Giai nen goi nay tren may tinh de xem cac file.
3. Trong cPanel > File Manager, vao thu muc website (thuong la public_html). Tai len va ghi de cac file source tu goi nay, giu nguyen config.php dang co. Neu hosting hoi ghi de config.php thi chon bo qua.
4. Mo phpMyAdmin, chon dung database hien tai (goaajrun_128 neu van dung database nay).
5. Kiem tra bang orders chua co cot paid_at va service_expires_at. Theo thong tin ban da gui truoc do, hai cot nay chua co. Neu dung, Import DUY NHAT file migrations/0004_order_service_dates.mysql.sql mot lan.
6. Khong chay lai migration 0004 neu hai cot da ton tai. Migration khong xoa du lieu, chi them cot va dien ngay thanh toan tam tinh cho cac don cu da thanh toan.
7. Kiem tra config.php tren hosting van co dung DB host/name/user/password, UPLOCKET_API_KEY, SEPAY_API_KEY, site_admin_token va thong tin ngan hang.
8. SePay webhook URL: https://TEN-MIEN-CUA-BAN/api/webhook/sepay. Header Authorization: Apikey <SEPAY_API_KEY>.
9. Dang nhap /admin/ va bam Lam moi o Don hang. Kiem tra /api/health.

CAC SUA DOI CHINH
- Sua JOIN don hang - CTV va cac subquery thong ke CTV de tranh loi khac collation.
- Webhook SePay khoa don trong transaction, chi ghi nhan thanh toan khi ma don, so tien va trang thai hop le; ghi paid_at ngay webhook xac nhan.
- Bao ve ghi nhan giao dich trung dua tren unique transaction_id cua bang payments va trang thai don.
- Trang admin hien thi ngay thanh toan va han su dung rieng. expires_at van giu vai tro han QR cua don pending.
- API verify-account doc service_expires_at/paid_at thay vi tinh tu created_at.
- Don cu duoc dien paid_at tam tinh bang created_at; han dich vu cu tinh lai tu moc nay. Hay doi soat cac don cu neu ngay tao don khac ngay thanh toan thuc te.

LUU Y GOI FOREVER
- He thong shop danh dau Forever la khong het han. Tuy nhien API nha cung cap hien tai van nhan durationDays=9999 trong lenh export; can xac nhan voi Uplocket co ho tro thoi han vo han thuc su hay khong.

BAO MAT
- Ban source goc gui len co chua file config.php voi thong tin truy cap va key. Goi cap nhat nay da loai bo file do. De an toan, hay doi mat khau MySQL, UPLOCKET_API_KEY, SEPAY_API_KEY va site_admin_token neu cac key cu con hieu luc; cap nhat lai config.php tren hosting va cau hinh webhook SePay tuong ung.
