# -*- coding: utf-8 -*-
"""Tra hồ sơ KPH liên quan cho mục QC Trí 08/10/2026 (chỉ để liên kết)."""
import sqlite3

KW = ['MP 764', '764', 'Minh Phát', 'AQ 455', 'AQ455', 'WALMART', 'Walmart', 'BLACK', 'TCL3', 'TC13',
      'TCh3', 'T2012', 'mẫu gốc', 'Bình Thạnh', 'Plantia']

print('===== ho_so_kph (C:\\Claw\\Khieu Nai KHach Hang\\btchem_kph.db) =====')
con = sqlite3.connect(r'C:\Claw\Khieu Nai KHach Hang\btchem_kph.db')
c = con.cursor()
cot = [r[1] for r in c.execute('PRAGMA table_info(ho_so_kph)')]
truong = ['san_pham_raw', 'hien_tuong_raw', 'mo_ta', 'nguyen_nhan', 'phuong_an', 'cong_viec_tiep', 'chi_dao', 'ghi_chu']
for kw in KW:
    dk = ' OR '.join(['%s LIKE ?' % x for x in truong])
    rs = c.execute('SELECT id,nguon,ma_hs,ngay_nhan,san_pham_raw,hien_tuong_raw,mo_ta,phuong_an,cong_viec_tiep FROM ho_so_kph WHERE %s' % dk,
                   tuple(['%%%s%%' % kw] * len(truong))).fetchall()
    print('\n  [%s] %d dòng' % (kw, len(rs)))
    for r in rs[:4]:
        print('     id %s | mã %s | ngày %s' % (r[0], r[2], r[3]))
        for nhan, v in (('sp', r[4]), ('hiện tượng', r[5]), ('mô tả', r[6]), ('xử lý', r[7]), ('việc tiếp', r[8])):
            if v:
                print('        %-11s: %s' % (nhan, str(v).replace('\n', ' ')[:220]))
con.close()

print('\n===== su_co_kph (btchem.db) =====')
con2 = sqlite3.connect(r'C:\c\deepseek-harness\claw2-db\btchem.db')
c2 = con2.cursor()
truong2 = ['ten_vu_viec', 'san_pham_mau', 'mo_ta_su_co', 'nguyen_nhan', 'phuong_an_xu_ly', 'ket_qua']
for kw in KW:
    dk = ' OR '.join(['%s LIKE ?' % x for x in truong2])
    rs = c2.execute('SELECT id,ngay_tao,ten_vu_viec,san_pham_mau,mo_ta_su_co,phuong_an_xu_ly,trang_thai FROM su_co_kph WHERE %s' % dk,
                    tuple(['%%%s%%' % kw] * len(truong2))).fetchall()
    if not rs:
        continue
    print('\n  [%s] %d dòng' % (kw, len(rs)))
    for r in rs[:4]:
        print('     id %s | %s | %s | %s' % (r[0], str(r[1])[:10], str(r[2])[:70], str(r[6])[:14]))
        for nhan, v in (('sp/màu', r[3]), ('mô tả', r[4]), ('xử lý', r[5])):
            if v:
                print('        %-8s: %s' % (nhan, str(v).replace('\n', ' ')[:200]))
con2.close()