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', autocommit=False)
try:
    with conn.cursor() as cur:
        # 1. Comprobar albarán 7459 antes de borrar
        cur.execute("SELECT id, serie, numero, id_pedido FROM ge_albaranes WHERE id = 7459")
        alb = cur.fetchone()
        print(f"Albarán a eliminar: {alb}")
        if not alb:
            print("El albarán 7459 ya no existe.")
            conn.rollback()
            exit(0)

        # 2. Borrar de ge_albaranes_bultos
        cur.execute("DELETE FROM ge_albaranes_bultos WHERE albaran_id = 7459")
        print(f"Bultos eliminados: {cur.rowcount}")

        # 3. Borrar de ge_albaranes_lineas
        cur.execute("DELETE FROM ge_albaranes_lineas WHERE albaran_id = 7459")
        print(f"Líneas de albarán eliminadas: {cur.rowcount}")

        # 4. Borrar de ge_envios_recogidas la recogida 222 vinculada al albarán 7459
        cur.execute("DELETE FROM ge_envios_recogidas WHERE albaran_id = 7459")
        print(f"Recogidas eliminadas en ge_envios_recogidas: {cur.rowcount}")

        # 5. Borrar de ge_envios si existiera alguna
        cur.execute("DELETE FROM ge_envios WHERE albaran_id = 7459")
        print(f"Envíos eliminados en ge_envios: {cur.rowcount}")

        # 6. Borrar la cabecera en ge_albaranes
        cur.execute("DELETE FROM ge_albaranes WHERE id = 7459")
        print(f"Cabecera ge_albaranes eliminada: {cur.rowcount}")

        # Confirmar transacción
        conn.commit()
        print(">>> TRANSACCION COMPLETADA CON EXITO: Albarán 26/670 (ID 7459) eliminado y registros huérfanos limpiados.")

except Exception as e:
    conn.rollback()
    print(f"ERROR: {e}")
    raise
finally:
    conn.close()
