import pymysql, configparser

def decrypt(s):
    if not s or not s.startswith('ENC:'): return s
    hex_str = s[4:]
    key = 0xA5C3
    res = []
    for i in range(0, len(hex_str), 4):
        val = int(hex_str[i:i+4], 16)
        res.append(chr(val ^ key))
    return ''.join(res)

cfg = configparser.ConfigParser()
cfg.read('C:/GESTIGEST/db_config.ini')
server = decrypt(cfg['Database'].get('Server'))
port = int(decrypt(cfg['Database'].get('Port')))
db = decrypt(cfg['Database'].get('Database'))
user = decrypt(cfg['Database'].get('User_Name'))
pwd = decrypt(cfg['Database'].get('Password'))

conn = pymysql.connect(host=server, port=port, user=user, password=pwd, database=db, charset='utf8mb4')
with conn.cursor() as cur:
    for alb_id, num in [(7459, '26/670'), (7464, '26/671')]:
        print(f"\n==================== ALBARAN {num} (ID {alb_id}) ====================")
        cur.execute("SELECT * FROM ge_albaranes WHERE id = %s", (alb_id,))
        print("ge_albaranes:", cur.fetchone())

        cur.execute("SELECT id, articulo_codigo, descripcion, cantidad, total FROM ge_albaranes_lineas WHERE albaran_id = %s", (alb_id,))
        lineas = cur.fetchall()
        print(f"ge_albaranes_lineas ({len(lineas)}):", lineas)

        cur.execute("SELECT id, numero_bulto, sscc FROM ge_albaranes_bultos WHERE albaran_id = %s", (alb_id,))
        bultos = cur.fetchall()
        print(f"ge_albaranes_bultos ({len(bultos)}):", bultos)

        cur.execute("SELECT id, albaran_transportista, guid_transportista, estado_codigo, estado_descripcion, anulado, created_at FROM ge_envios WHERE albaran_id = %s", (alb_id,))
        envios = cur.fetchall()
        print(f"ge_envios ({len(envios)}):", envios)

        cur.execute("SELECT id, cod_recogida, guid_transportista, estado_codigo, estado_descripcion, anulado, created_at FROM ge_envios_recogidas WHERE albaran_id = %s", (alb_id,))
        recogidas = cur.fetchall()
        print(f"ge_envios_recogidas ({len(recogidas)}):", recogidas)

    print("\n==================== OTRAS TABLAS CON COLUMNA albaran_id ====================")
    cur.execute("""
        SELECT table_name, column_name 
        FROM information_schema.columns 
        WHERE table_schema = %s 
          AND column_name LIKE '%albaran%'
    """, (db,))
    for t, c in cur.fetchall():
        try:
            cur.execute(f"SELECT COUNT(*) FROM {t} WHERE {c} IN (7459, 7464)")
            cnt = cur.fetchone()[0]
            if cnt > 0:
                print(f"  Tabla {t}.{c}: {cnt} registros encontrados")
        except Exception as e:
            pass
