View Evaluation

SELECT usuarios.empNombreCompleto, t_eval.evalTipo, 
       evaluaciones.evalEncrypt, evaluaciones.evalID, evaluaciones.tipoEvalID
FROM tbl_dgo_evaluaciones evaluaciones
INNER JOIN cat_dgo_tipoeval t_eval ON evaluaciones.tipoEvalID = t_eval.tipoEvalID
INNER JOIN cat_dgo_empleados usuarios ON usuarios.empID = evaluaciones.empID
WHERE evaluaciones.evalID = ? AND evaluaciones.evalActivo = 1;

-- Personal Data
SELECT * FROM tbl_dgo_personalesperma 
WHERE evalID = ? AND personalesActivo = 1 
ORDER BY personalesCreado DESC LIMIT 1;

-- Family Data
SELECT * FROM tbl_dgo_familiares 
WHERE evalID = ? AND familiarActivo = 1 
ORDER BY familiarCreado DESC LIMIT 1;

-- Academic Data
SELECT * FROM tbl_dgo_academicos
WHERE evalID = ? AND academicoActivo = 1;

-- Work History (Permanencia)
SELECT * FROM tbl_dgo_trayectoria
WHERE evalID = ? AND trayectoriaActivo = 1 
ORDER BY trayectoriaCreado DESC LIMIT 1;

-- Work History (Nuevo Ingreso)
SELECT * FROM tbl_dgo_trayectoriani
WHERE evalID = ? AND trayectoriaActivo = 1 
ORDER BY trayectoriaCreado DESC LIMIT 1;

-- Economic Data
SELECT * FROM tbl_dgo_economicos
WHERE evalID = ? AND economicosActivo = 1 
ORDER BY economicosCreado DESC LIMIT 1;

-- References
SELECT * FROM tbl_dgo_referencias 
WHERE evalID = ? AND referenciasActivo = 1 
ORDER BY referenciasCreado DESC LIMIT 1;

SELECT * FROM tbl_dgo_uploads 
WHERE evalID = ? 
  AND documentoID = ? 
  AND uploadActivo = 1 
ORDER BY uploadCreado DESC 
LIMIT 1