Lizandro GuarnizoandClaude Sonnet 4.6
e32214fef7
Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
68 lines
1.9 KiB
Python
68 lines
1.9 KiB
Python
import sqlite3
|
|
|
|
Q5 = """SELECT
|
|
r.IDRECEPCION,
|
|
r.PREFIJO,
|
|
r.NUM_FACTURA,
|
|
r.FECHA_RECEPCION,
|
|
r.COD_PACIENTE,
|
|
r.NIT_EMPRESA,
|
|
r.DIAG_PPAL,
|
|
r.TIPOUSU,
|
|
r.TIPOUSUSISPRO,
|
|
r.AUTORIZACION,
|
|
r.CLASEPROC,
|
|
r.HORAINICIORECEPCION,
|
|
r.VALORTOTAL,
|
|
rel.COD_EXAMEN,
|
|
COALESCE(NULLIF(TRIM(ex.NUM_ISS), ''), TRIM(rel.COD_EXAMEN)) AS CUPS,
|
|
rel.PRECIO,
|
|
rel.FECHA_REPORTADO,
|
|
m.COD_ESPECIALIDAD,
|
|
COALESCE(NULLIF(TRIM(m.CODIGO), ''), NULLIF(TRIM(r.USUARIO), ''), '') AS profesional,
|
|
e.CODCONTRATO,
|
|
TRIM(m.DOCIDMEDICO) AS DOCIDMEDICO
|
|
FROM RECEPCION r
|
|
JOIN RELACION rel ON rel.IDRECEPCION = r.IDRECEPCION
|
|
LEFT JOIN EXAMEN ex ON TRIM(ex.CODIGO) = TRIM(rel.COD_EXAMEN)
|
|
LEFT JOIN MEDICO m ON m.CODIGO = r.COD_MEDICO
|
|
LEFT JOIN EMPRESA e ON e.NIT = r.NIT_EMPRESA
|
|
WHERE r.NUM_FACTURA = :num_factura"""
|
|
|
|
Q6 = """SELECT
|
|
r.IDRECEPCION,
|
|
r.PREFIJO,
|
|
r.NUM_FACTURA,
|
|
r.FECHA_RECEPCION,
|
|
r.COD_PACIENTE,
|
|
r.NIT_EMPRESA,
|
|
r.DIAG_PPAL,
|
|
r.TIPOUSU,
|
|
r.TIPOUSUSISPRO,
|
|
r.AUTORIZACION,
|
|
r.CLASEPROC,
|
|
r.HORAINICIORECEPCION,
|
|
r.VALORTOTAL,
|
|
rel.COD_EXAMEN,
|
|
COALESCE(NULLIF(TRIM(ex.NUM_ISS), ''), TRIM(rel.COD_EXAMEN)) AS CUPS,
|
|
rel.PRECIO,
|
|
rel.FECHA_REPORTADO,
|
|
m.COD_ESPECIALIDAD,
|
|
COALESCE(NULLIF(TRIM(m.CODIGO), ''), NULLIF(TRIM(r.USUARIO), ''), '') AS profesional,
|
|
e.CODCONTRATO,
|
|
TRIM(m.DOCIDMEDICO) AS DOCIDMEDICO
|
|
FROM RECEPCION r
|
|
JOIN RELACION rel ON rel.IDRECEPCION = r.IDRECEPCION
|
|
LEFT JOIN EXAMEN ex ON TRIM(ex.CODIGO) = TRIM(rel.COD_EXAMEN)
|
|
LEFT JOIN MEDICO m ON m.CODIGO = r.COD_MEDICO
|
|
LEFT JOIN EMPRESA e ON e.NIT = r.NIT_EMPRESA
|
|
WHERE r.FECHA_RECEPCION BETWEEN :fecha_ini AND :fecha_fin
|
|
ORDER BY r.IDRECEPCION"""
|
|
|
|
conn = sqlite3.connect("rips_manager.db")
|
|
conn.execute("UPDATE queries SET query_text=? WHERE id=5", (Q5,))
|
|
conn.execute("UPDATE queries SET query_text=? WHERE id=6", (Q6,))
|
|
conn.commit()
|
|
conn.close()
|
|
print("Queries actualizados OK")
|