|
|
|
|
|
================================================================================ |
|
|
=============================== INFO basica ================================ |
|
|
================================================================================ |
|
|
|
|
|
MEMORIA 1.54 Mb |
|
|
|
|
|
-------------------------------------- |
|
|
CRONOMETRO |
|
|
-------------------------------------- |
|
|
pre-cache 0.000 seg |
|
|
post-cache 0.000 seg |
|
|
pre conexion 0.001 seg |
|
|
conexion 0.004 seg |
|
|
pos conexion 0.021 seg |
|
|
pre-cache 0.000 seg |
|
|
post-cache 0.000 seg |
|
|
pre-cache 0.000 seg |
|
|
post-cache 0.000 seg |
|
|
pre-cache 0.000 seg |
|
|
post-cache 0.000 seg |
|
|
pre-consulta 0.000 seg |
|
|
post-consulta 0.004 seg |
|
|
post-guardar_cache 0.000 seg |
|
|
pre-consulta 0.002 seg |
|
|
post-consulta 0.024 seg |
|
|
pre-consulta 0.000 seg |
|
|
post-consulta 0.001 seg |
|
|
pre-consulta 0.000 seg |
|
|
post-consulta 0.000 seg |
|
|
pre-cache 0.000 seg |
|
|
post-cache 0.000 seg |
|
|
pre-consulta 0.000 seg |
|
|
post-consulta 0.009 seg |
|
|
pre-consulta 0.038 seg |
|
|
post-consulta 0.007 seg |
|
|
pre-consulta 0.000 seg |
|
|
post-consulta 0.082 seg |
|
|
pre-consulta 0.000 seg |
|
|
post-consulta 0.008 seg |
|
|
pre-consulta 0.000 seg |
|
|
post-consulta 0.014 seg |
|
|
pre-consulta 0.000 seg |
|
|
post-consulta 0.007 seg |
|
|
pre-consulta 0.000 seg |
|
|
post-consulta 0.006 seg |
|
|
pre-consulta 0.000 seg |
|
|
post-consulta 0.006 seg |
|
|
pre-consulta 0.000 seg |
|
|
post-consulta 0.006 seg |
|
|
pre-consulta 0.000 seg |
|
|
post-consulta 0.006 seg |
|
|
pre-consulta 0.000 seg |
|
|
post-consulta 0.006 seg |
|
|
pre-consulta 0.000 seg |
|
|
post-consulta 0.006 seg |
|
|
pre-consulta 0.000 seg |
|
|
post-consulta 0.006 seg |
|
|
pre-consulta 0.000 seg |
|
|
post-consulta 0.006 seg |
|
|
pre-consulta 0.000 seg |
|
|
post-consulta 0.006 seg |
|
|
pre-consulta 0.000 seg |
|
|
post-consulta 0.006 seg |
|
|
pre-consulta 0.000 seg |
|
|
post-consulta 0.006 seg |
|
|
pre-consulta 0.000 seg |
|
|
post-consulta 0.006 seg |
|
|
pre-consulta 0.000 seg |
|
|
post-consulta 0.006 seg |
|
|
pre-consulta 0.000 seg |
|
|
post-consulta 0.006 seg |
|
|
pre-consulta 0.000 seg |
|
|
post-consulta 0.006 seg |
|
|
pre-consulta 0.000 seg |
|
|
post-consulta 0.006 seg |
|
|
pre-consulta 0.000 seg |
|
|
post-consulta 0.006 seg |
|
|
pre-consulta 0.000 seg |
|
|
post-consulta 0.006 seg |
|
|
fin request 0.001 seg |
|
|
fin response 0.000 seg |
|
|
-------------------------------------- |
|
|
TOTAL 0.331 seg |
|
|
-------------------------------------- |
|
|
|
|
|
================================================================================ |
|
|
================================ nivel INFO ================================ |
|
|
================================================================================ |
|
|
|
|
|
|
|
|
-- La acción 'fa2e3e66946802e65ebb4d95a37b3f' no existe Se redirige a 'index' con parámetro 'fa2e3e66946802e65ebb4d95a37b3f' |
|
|
|
|
|
|
|
|
|
|
|
-- EJECUTANDO ACCION 'siu\operaciones\asistencias\controlador::accion__index' |
|
|
|
|
|
|
|
|
|
|
|
================================================================================ |
|
|
================================== DEBUG =================================== |
|
|
================================================================================ |
|
|
|
|
|
|
|
|
-- ALIAS --------------------------------------------------------------------- |
|
|
|
|
|
/colegio |
|
|
|
|
|
-- ACTIVAR CACHE ------------------------------------------------------------- |
|
|
|
|
|
|
|
|
|
|
|
-- CATALOGO: sistema/version_base_g3 | cache [true] - tipo [memoria] --------- |
|
|
|
|
|
Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
) |
|
|
|
|
|
[metadata] => Array |
|
|
( |
|
|
[cache] => memoria |
|
|
[filas] => 1 |
|
|
) |
|
|
|
|
|
[force_cache] => Array |
|
|
( |
|
|
) |
|
|
|
|
|
) |
|
|
|
|
|
|
|
|
-- ADMIN CACHE --------------------------------------------------------------- |
|
|
|
|
|
: instanciando: MemoriaApc |
|
|
|
|
|
-- CATALOGO CACHE DATOS ------------------------------------------------------ |
|
|
|
|
|
3.22.0 |
|
|
|
|
|
-- === session_name === ------------------------------------------------------ |
|
|
|
|
|
siu_sess__colegio_des01 |
|
|
|
|
|
-- Autenticacion ------------------------------------------------------------- |
|
|
|
|
|
Usuario autenticado con la sesion |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
SET CLIENT_ENCODING TO 'iso-8859-1'; |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
SET search_path TO negocio |
|
|
|
|
|
-- CONECTAR DB --------------------------------------------------------------- |
|
|
|
|
|
Array |
|
|
( |
|
|
[vendor] => pgsql |
|
|
[dbname] => toba_3_3 |
|
|
[schema] => negocio |
|
|
[schema_toba] => desarrollo |
|
|
[host] => guarani_escuelas_base_1 |
|
|
[port] => 5432 |
|
|
[pdo_user] => postgres |
|
|
) |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
SELECT EXISTS(SELECT 1 FROM pg_namespace WHERE nspname = 'negocio_auditoria') |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
CREATE TEMP TABLE tt_usuario (usuario VARCHAR(60), id_solicitud INTEGER);GRANT SELECT, INSERT ON tt_usuario TO postgres;INSERT INTO tt_usuario (usuario) VALUES ('26858882'); |
|
|
|
|
|
-- CATALOGO: persona/datos_basicos | cache [true] - tipo [sesion] ------------ |
|
|
|
|
|
Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[persona] => '8' |
|
|
) |
|
|
|
|
|
[metadata] => Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[0] => persona |
|
|
) |
|
|
|
|
|
[cache] => sesion |
|
|
[filas] => 1 |
|
|
) |
|
|
|
|
|
[force_cache] => Array |
|
|
( |
|
|
) |
|
|
|
|
|
) |
|
|
|
|
|
|
|
|
-- ADMIN CACHE --------------------------------------------------------------- |
|
|
|
|
|
: instanciando: Sesion |
|
|
|
|
|
-- CACHE SESION buscar ------------------------------------------------------- |
|
|
|
|
|
catalogo____des01__persona__datos_basicos__Jzgn |
|
|
|
|
|
-- CATALOGO CACHE DATOS ------------------------------------------------------ |
|
|
|
|
|
Array |
|
|
( |
|
|
[persona] => 8 |
|
|
[tipo_documento] => 0 |
|
|
[tipo_documento_desc] => Documento Nacional de Identidad |
|
|
[tipo_documento_desc_abreviada] => DNI |
|
|
[nro_documento] => 26858882 |
|
|
[apellido] => HARTMANN |
|
|
[nombres] => LORENA MARICEL |
|
|
[nombre_mostrar] => LORENA MARICEL |
|
|
[apellido_mostrar] => HARTMANN |
|
|
[inicial_apellido] => H |
|
|
[fecha_nacimiento] => 1979-08-29 |
|
|
[fecha_nacimiento_visual] => 29/08/1979 |
|
|
[id_imagen] => |
|
|
[perfil_inicial] => Docente |
|
|
[identificacion] => 26858882 |
|
|
[arai_identificador_sso] => |
|
|
[arai_uuid] => |
|
|
[legajo_docente] => 26858882 |
|
|
[docente] => 1 |
|
|
[orden] => 0 |
|
|
) |
|
|
|
|
|
|
|
|
-- CATALOGO: persona/perfiles | cache [true] - tipo [sesion] ----------------- |
|
|
|
|
|
Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[persona] => 8 |
|
|
) |
|
|
|
|
|
[metadata] => Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[0] => persona |
|
|
) |
|
|
|
|
|
[no_quote] => persona |
|
|
[cache] => sesion |
|
|
[filas] => n |
|
|
) |
|
|
|
|
|
[force_cache] => Array |
|
|
( |
|
|
) |
|
|
|
|
|
) |
|
|
|
|
|
|
|
|
-- CACHE SESION buscar ------------------------------------------------------- |
|
|
|
|
|
catalogo____des01__persona__perfiles__OA__ |
|
|
|
|
|
-- CATALOGO CACHE DATOS ------------------------------------------------------ |
|
|
|
|
|
Array |
|
|
( |
|
|
[Docente] => Docente |
|
|
[Preinscripcion] => Preinscripcion |
|
|
) |
|
|
|
|
|
|
|
|
-- CATALOGO: persona/carreras | cache [true] - tipo [sesion] ----------------- |
|
|
|
|
|
Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[persona] => '8' |
|
|
) |
|
|
|
|
|
[metadata] => Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[0] => persona |
|
|
) |
|
|
|
|
|
[cache] => sesion |
|
|
[filas] => n |
|
|
) |
|
|
|
|
|
[force_cache] => Array |
|
|
( |
|
|
) |
|
|
|
|
|
) |
|
|
|
|
|
|
|
|
-- CACHE SESION buscar ------------------------------------------------------- |
|
|
|
|
|
catalogo____des01__persona__carreras__Jzgn |
|
|
|
|
|
-- CATALOGO CACHE DATOS ------------------------------------------------------ |
|
|
|
|
|
ARRAY VACIO |
|
|
|
|
|
-- CATALOGO: persona/configuracion | cache [true] - tipo [memoria] ----------- |
|
|
|
|
|
Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[persona] => '8' |
|
|
) |
|
|
|
|
|
[metadata] => Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[0] => persona |
|
|
) |
|
|
|
|
|
[cache] => memoria |
|
|
[cache_expiracion] => 600 |
|
|
[filas] => n |
|
|
) |
|
|
|
|
|
[force_cache] => Array |
|
|
( |
|
|
) |
|
|
|
|
|
) |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
SELECT email, recibe_mail_mensajes, email_temporal FROM f_configuracion_email_persona ('8') |
|
|
|
|
|
-- DATOS --------------------------------------------------------------------- |
|
|
|
|
|
Array |
|
|
( |
|
|
[email] => hartmann.lorena@uader.edu.ar |
|
|
[recibe_mail_mensajes] => 0 |
|
|
[email_temporal] => |
|
|
) |
|
|
|
|
|
|
|
|
-- CATALOGO CACHE - guardar -------------------------------------------------- |
|
|
|
|
|
persona/configuracion. MEDIO: memoria |
|
|
|
|
|
-- cargar PERSONA ------------------------------------------------------------ |
|
|
|
|
|
8 |
|
|
|
|
|
-- === pre_accion - perfil === ----------------------------------------------- |
|
|
|
|
|
Docente |
|
|
|
|
|
-- === pre_accion - operacion === -------------------------------------------- |
|
|
|
|
|
asistencias |
|
|
|
|
|
-- Recordset - recuperar - 8_fa2e3e66946802e65ebb4d95a37b3f860f15e0f1 ------- |
|
|
|
|
|
Array |
|
|
( |
|
|
[0] => docente |
|
|
[1] => lista_comisiones |
|
|
[2] => Array |
|
|
( |
|
|
[anio_academico] => |
|
|
[docente] => 1 |
|
|
[periodo_lectivo] => Array |
|
|
( |
|
|
[0] => 13 |
|
|
[1] => 12 |
|
|
) |
|
|
|
|
|
[actividad] => |
|
|
[ubicacion] => |
|
|
[comisiones_activas] => |
|
|
) |
|
|
|
|
|
[3] => id |
|
|
[4] => Array |
|
|
( |
|
|
[comision] => Array |
|
|
( |
|
|
[0] => comision |
|
|
) |
|
|
|
|
|
) |
|
|
|
|
|
[tipo_] => siu\modelo\entidades\rs_consulta |
|
|
[accion_destino__] => index |
|
|
[controlador_destino__] => asistencias |
|
|
) |
|
|
|
|
|
|
|
|
-- CATALOGO: docente/lista_comisiones | cache [false] - tipo [no] ------------ |
|
|
|
|
|
Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[anio_academico] => |
|
|
[docente] => 1 |
|
|
[periodo_lectivo] => Array |
|
|
( |
|
|
[0] => 13 |
|
|
[1] => 12 |
|
|
) |
|
|
|
|
|
[actividad] => |
|
|
[ubicacion] => |
|
|
[comisiones_activas] => |
|
|
) |
|
|
|
|
|
[metadata] => Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[0] => anio_academico |
|
|
[1] => docente |
|
|
[2] => periodo_lectivo |
|
|
[3] => actividad |
|
|
[4] => ubicacion |
|
|
) |
|
|
|
|
|
[param_null] => Array |
|
|
( |
|
|
[0] => anio_academico |
|
|
[1] => docente |
|
|
[2] => periodo_lectivo |
|
|
[3] => actividad |
|
|
[4] => ubicacion |
|
|
) |
|
|
|
|
|
[no_quote] => Array |
|
|
( |
|
|
[0] => anio_academico |
|
|
[1] => docente |
|
|
[2] => periodo_lectivo |
|
|
[3] => actividad |
|
|
[4] => ubicacion |
|
|
) |
|
|
|
|
|
[cache] => no |
|
|
[cache_expiracion] => 600 |
|
|
[filas] => n |
|
|
) |
|
|
|
|
|
[force_cache] => Array |
|
|
( |
|
|
) |
|
|
|
|
|
) |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
-- Comisiones sin subcomisiones |
|
|
SELECT |
|
|
cast(sga_comisiones.comision as text) as id, |
|
|
sga_periodos.anio_academico as anio_academico, |
|
|
sga_periodos.nombre as periodo_lectivo_nombre, |
|
|
sga_periodos.anio_academico || ' - ' || sga_periodos.nombre as periodo_lectivo_nombre_full, |
|
|
sga_periodos.fecha_inicio as periodo_fecha_inicio, |
|
|
sga_comisiones.periodo_lectivo as periodo_lectivo, |
|
|
vw_actividades.nombre || ' (' || vw_actividades.codigo || ')' as actividad_orden, |
|
|
sga_comisiones.elemento as actividad, |
|
|
vw_actividades.codigo as actividad_codigo, |
|
|
vw_actividades.nombre as actividad_nombre, |
|
|
vw_actividades.nombre_abreviado as actividad_nombre_abreviado, |
|
|
sga_comisiones.comision as comision, |
|
|
sga_comisiones.nombre as comision_nombre, |
|
|
sga_comisiones.turno as turno, |
|
|
sga_turnos_cursadas.nombre as turno_nombre, |
|
|
f_instancias_comision (sga_comisiones.comision) as instancias, |
|
|
sga_comisiones.catedra as catedra, |
|
|
sga_catedras.nombre as catedra_nombre, |
|
|
sga_ubicaciones.ubicacion as ubicacion, |
|
|
sga_ubicaciones.nombre as ubicacion_nombre, |
|
|
sga_comisiones_cupo.cupo as cupo_comision, |
|
|
(SELECT COUNT(1) FROM sga_insc_cursada WHERE comision = sga_comisiones.comision) as cant_inscriptos_comision, |
|
|
--f_horario_comision(sga_comisiones.comision) as horario_comision, |
|
|
f_bandas_horarias_comision(sga_comisiones.comision, true, true, true) as horario_comision, |
|
|
-- subcomisiones |
|
|
cast(null as integer) as subcomision, |
|
|
cast(null as varchar(100)) as subcomision_nombre, |
|
|
cast(null as varchar(50)) as tipo_clase, |
|
|
0 as cupo_subcomision, |
|
|
0 as cant_inscriptos_subcomision, |
|
|
cast(null as varchar(200)) as horario_subcomision, |
|
|
0 as es_subcomision, |
|
|
sga_comisiones.entidad, |
|
|
sga_docentes_responsabilidades.nombre as resp_docente |
|
|
FROM sga_comisiones |
|
|
JOIN sga_comisiones_cupo ON sga_comisiones_cupo.comision = sga_comisiones.comision |
|
|
JOIN sga_docentes_comision ON (sga_docentes_comision.docente = 1 AND sga_docentes_comision.comision = sga_comisiones.comision) |
|
|
JOIN sga_docentes_responsabilidades ON sga_docentes_comision.responsabilidad = sga_docentes_responsabilidades.responsabilidad |
|
|
|
|
|
JOIN sga_ubicaciones ON sga_ubicaciones.ubicacion = sga_comisiones.ubicacion |
|
|
JOIN vw_actividades ON vw_actividades.elemento = sga_comisiones.elemento |
|
|
JOIN sga_periodos_lectivos ON sga_periodos_lectivos.periodo_lectivo = sga_comisiones.periodo_lectivo |
|
|
JOIN sga_periodos ON sga_periodos.periodo = sga_periodos_lectivos.periodo |
|
|
LEFT JOIN sga_catedras ON sga_catedras.catedra = sga_comisiones.catedra |
|
|
LEFT JOIN sga_turnos_cursadas ON sga_turnos_cursadas.turno = sga_comisiones.turno |
|
|
WHERE sga_comisiones.estado = 'A' |
|
|
AND COALESCE(sga_periodos_lectivos.fecha_publicacion_comisiones_docente,CURRENT_DATE) <= CURRENT_DATE |
|
|
AND NOT EXISTS (SELECT 1 FROM sga_subcomisiones WHERE comision = sga_comisiones.comision) |
|
|
|
|
|
AND sga_comisiones.periodo_lectivo IN (13,12) |
|
|
|
|
|
|
|
|
|
|
|
UNION ALL |
|
|
|
|
|
-- Comisiones con subcomisiones. |
|
|
SELECT |
|
|
cast(sga_comisiones.comision as text) || '_' || cast(sga_subcomisiones.subcomision as text) as id, |
|
|
sga_periodos.anio_academico as anio_academico, |
|
|
sga_periodos.nombre as periodo_lectivo_nombre, |
|
|
sga_periodos.anio_academico || ' - ' || sga_periodos.nombre as periodo_lectivo_nombre_full, |
|
|
sga_periodos.fecha_inicio as periodo_fecha_inicio, |
|
|
sga_comisiones.periodo_lectivo as periodo_lectivo, |
|
|
vw_actividades.nombre || ' (' || vw_actividades.codigo || ')' as actividad_orden, |
|
|
sga_comisiones.elemento as actividad, |
|
|
vw_actividades.codigo as actividad_codigo, |
|
|
vw_actividades.nombre as actividad_nombre, |
|
|
vw_actividades.nombre_abreviado as actividad_nombre_abreviado, |
|
|
sga_comisiones.comision as comision, |
|
|
sga_comisiones.nombre as comision_nombre, |
|
|
sga_comisiones.turno as turno, |
|
|
sga_turnos_cursadas.nombre as turno_nombre, |
|
|
f_instancias_comision (sga_comisiones.comision) as instancias, |
|
|
sga_comisiones.catedra as catedra, |
|
|
sga_catedras.nombre as catedra_nombre, |
|
|
sga_ubicaciones.ubicacion as ubicacion, |
|
|
sga_ubicaciones.nombre as ubicacion_nombre, |
|
|
0 as cupo_comision, |
|
|
0 as cant_inscriptos_comision, |
|
|
cast(null as varchar(200)) as horario_comision, |
|
|
-- Subcomisiones |
|
|
sga_subcomisiones.subcomision as subcomision, |
|
|
sga_subcomisiones.nombre as subcomision_nombre, |
|
|
sga_clases_tipos.nombre as tipo_clase, |
|
|
sga_subcomisiones_cupo.cupo as cupo_subcomision, |
|
|
(SELECT COUNT(1) FROM sga_insc_subcomision WHERE subcomision = sga_subcomisiones.subcomision) as cant_inscriptos_subcomision, |
|
|
f_horario_subcomision(sga_subcomisiones.subcomision) as horario_subcomision, |
|
|
1 as es_subcomision, |
|
|
sga_comisiones.entidad, |
|
|
sga_docentes_responsabilidades.nombre as resp_docente |
|
|
FROM |
|
|
sga_comisiones |
|
|
JOIN sga_subcomisiones ON sga_subcomisiones.comision = sga_comisiones.comision |
|
|
JOIN sga_docentes_subcomision ON (sga_docentes_subcomision.docente = 1 AND sga_docentes_subcomision.subcomision = sga_subcomisiones.subcomision) |
|
|
JOIN sga_docentes_comision ON (sga_docentes_comision.comision = sga_comisiones.comision AND sga_docentes_comision.docente = sga_docentes_subcomision.docente) |
|
|
JOIN sga_docentes_responsabilidades ON sga_docentes_responsabilidades.responsabilidad = sga_docentes_comision.responsabilidad |
|
|
|
|
|
JOIN sga_clases_tipos ON sga_clases_tipos.tipo_clase = sga_subcomisiones.tipo_clase |
|
|
JOIN sga_subcomisiones_cupo ON sga_subcomisiones_cupo.subcomision = sga_subcomisiones.subcomision |
|
|
JOIN sga_ubicaciones ON sga_ubicaciones.ubicacion = sga_comisiones.ubicacion |
|
|
JOIN vw_actividades ON vw_actividades.elemento = sga_comisiones.elemento |
|
|
JOIN sga_periodos_lectivos ON sga_periodos_lectivos.periodo_lectivo = sga_comisiones.periodo_lectivo |
|
|
JOIN sga_periodos ON sga_periodos.periodo = sga_periodos_lectivos.periodo |
|
|
LEFT JOIN sga_catedras ON sga_catedras.catedra = sga_comisiones.catedra |
|
|
LEFT JOIN sga_turnos_cursadas ON sga_turnos_cursadas.turno = sga_comisiones.turno |
|
|
|
|
|
WHERE sga_comisiones.estado = 'A' |
|
|
AND COALESCE(sga_periodos_lectivos.fecha_publicacion_comisiones_docente,CURRENT_DATE) <= CURRENT_DATE |
|
|
|
|
|
AND sga_comisiones.periodo_lectivo IN (13,12) |
|
|
|
|
|
|
|
|
|
|
|
ORDER BY periodo_lectivo_nombre_full desc, |
|
|
actividad_orden, |
|
|
comision_nombre |
|
|
|
|
|
|
|
|
-- DATOS --------------------------------------------------------------------- |
|
|
|
|
|
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
|
|
| id |anio_academico| periodo_lectivo_nombre | periodo_lectivo_nombre_full |periodo_fecha_inicio|periodo_lectivo| actividad_orden |actividad|actividad_codigo| actividad_nombre |actividad_nombre_abreviado |comision|comision_nombre|turno|turno_nombre|instancias|catedra|catedra_nombre|ubicacion| ubicacion_nombre |cupo_comision|cant_inscriptos_comision| horario_comision |subcomision|subcomision_nombre|tipo_clase|cupo_subcomision|cant_inscriptos_subcomision|horario_subcomision|es_subcomision|entidad|resp_docente| comision_id | subcomision_id | |
|
|
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
|
|
|1029| 2025 |FCYT - Periodo Lectivo 2025 Nivel Secundario|2025 - FCYT - Periodo Lectivo 2025 Nivel Secundario| 2025-02-24 | 12 | Artes Visuales (fcyt-CB102) | 8 | fcyt-CB102 | Artes Visuales | Artes Visuales | 1029 | 1ero 1era TM | 1 | Ma<EFBFBD>ana | Promoci<EFBFBD>n | | | 4 |COL. SUP. DEL URUGUAY "J. J. DE URQUIZA" - TM| 0 | 22 | Mar 07:45 a 09:05 (Te<EFBFBD>rico-Pr<EFBFBD>ctica) | | | | 0 | 0 | | 0 | 1610 | Titular |8d01f50462cec59395c2ce634770e9048b8fca1c|9c2f9821578f859b84447e8b72d99e5bf109082a| |
|
|
|1058| 2025 |FCYT - Periodo Lectivo 2025 Nivel Secundario|2025 - FCYT - Periodo Lectivo 2025 Nivel Secundario| 2025-02-24 | 12 | Formaci<EFBFBD>n <EFBFBD>tica y Ciudadana (fcyt-CB105) | 11 | fcyt-CB105 | Formaci<EFBFBD>n <EFBFBD>tica y Ciudadana | Formaci<EFBFBD>n <EFBFBD>tica y Ciudadana | 1058 | 1ero 2da TM | 1 | Ma<EFBFBD>ana | Promoci<EFBFBD>n | | | 4 |COL. SUP. DEL URUGUAY "J. J. DE URQUIZA" - TM| 0 | 23 | Mie 12:05 a 12:35 (Te<EFBFBD>rico-Pr<EFBFBD>ctica) - Vie 12:05 a 12:35 (Te<EFBFBD>rico-Pr<EFBFBD>ctica) | | | | 0 | 0 | | 0 | 1639 | Titular |0f31bf581279a49d1347d8fcda3c85f0937d5f5d|9c2f9821578f859b84447e8b72d99e5bf109082a| |
|
|
|1078| 2025 |FCYT - Periodo Lectivo 2025 Nivel Secundario|2025 - FCYT - Periodo Lectivo 2025 Nivel Secundario| 2025-02-24 | 12 | Lengua y Literatura (fcyt-CB104) | 10 | fcyt-CB104 | Lengua y Literatura | Lengua y Literatura | 1078 | 1ero 2da TM | 1 | Ma<EFBFBD>ana | Promoci<EFBFBD>n | | | 4 |COL. SUP. DEL URUGUAY "J. J. DE URQUIZA" - TM| 0 | 23 | Lun 09:55 a 12:05 (Te<EFBFBD>rico-Pr<EFBFBD>ctica) - Mie 10:45 a 12:05 (Te<EFBFBD>rico-Pr<EFBFBD>ctica) | | | | 0 | 0 | | 0 | 1659 |Preceptor/a |f0d8b94b367c6f79b0fef4ebd8138ef0c6f8e71d|9c2f9821578f859b84447e8b72d99e5bf109082a| |
|
|
|1081| 2025 |FCYT - Periodo Lectivo 2025 Nivel Secundario|2025 - FCYT - Periodo Lectivo 2025 Nivel Secundario| 2025-02-24 | 12 | Matem<EFBFBD>tica (fcyt-CB103) | 9 | fcyt-CB103 | Matem<EFBFBD>tica | Matem<EFBFBD>tica | 1081 | 1ero 1era TM | 1 | Ma<EFBFBD>ana | Promoci<EFBFBD>n | | | 4 |COL. SUP. DEL URUGUAY "J. J. DE URQUIZA" - TM| 0 | 22 | Mar 10:45 a 12:05 (Te<EFBFBD>rico-Pr<EFBFBD>ctica) - Jue 09:55 a 12:05 (Te<EFBFBD>rico-Pr<EFBFBD>ctica) | | | | 0 | 0 | | 0 | 1662 | Titular |ab446d1fe37234016270b7b831d775e378f138ed|9c2f9821578f859b84447e8b72d99e5bf109082a| |
|
|
|1082| 2025 |FCYT - Periodo Lectivo 2025 Nivel Secundario|2025 - FCYT - Periodo Lectivo 2025 Nivel Secundario| 2025-02-24 | 12 | Matem<EFBFBD>tica (fcyt-CB103) | 9 | fcyt-CB103 | Matem<EFBFBD>tica | Matem<EFBFBD>tica | 1082 | 1ero 2da TM | 1 | Ma<EFBFBD>ana | Promoci<EFBFBD>n | | | 4 |COL. SUP. DEL URUGUAY "J. J. DE URQUIZA" - TM| 0 | 23 | Mar 07:45 a 09:05 (Te<EFBFBD>rico-Pr<EFBFBD>ctica) - Jue 07:45 a 09:55 (Te<EFBFBD>rico-Pr<EFBFBD>ctica) | | | | 0 | 0 | | 0 | 1663 | Titular |4d49be8606cb8147a8bd3478d94de7f7b8053fec|9c2f9821578f859b84447e8b72d99e5bf109082a| |
|
|
|1085| 2025 |FCYT - Periodo Lectivo 2025 Nivel Secundario|2025 - FCYT - Periodo Lectivo 2025 Nivel Secundario| 2025-02-24 | 12 | M<EFBFBD>sica (fcyt-CB101) | 7 | fcyt-CB101 | M<EFBFBD>sica | M<EFBFBD>sica | 1085 | 1ero 1era TM | 1 | Ma<EFBFBD>ana | Promoci<EFBFBD>n | | | 4 |COL. SUP. DEL URUGUAY "J. J. DE URQUIZA" - TM| 0 | 22 | Mar 09:15 a 10:35 (Te<EFBFBD>rico-Pr<EFBFBD>ctica) | | | | 0 | 0 | | 0 | 1666 | Titular |34a79effd13e8632f6d321edcd662eb25f460e89|9c2f9821578f859b84447e8b72d99e5bf109082a| |
|
|
| 32 | 2024 |FCYT - Periodo Lectivo 2024 Nivel Secundario|2024 - FCYT - Periodo Lectivo 2024 Nivel Secundario| 2024-02-15 | 13 | M<EFBFBD>sica (fcyt-CB101) | 7 | fcyt-CB101 | M<EFBFBD>sica | M<EFBFBD>sica | 32 | 1ero 3era TM | 1 | Ma<EFBFBD>ana | Promoci<EFBFBD>n | | | 4 |COL. SUP. DEL URUGUAY "J. J. DE URQUIZA" - TM| 0 | 0 | Mie 12:05 a 12:35 (Te<EFBFBD>rico-Pr<EFBFBD>ctica) - Jue 12:05 a 12:35 (Te<EFBFBD>rico-Pr<EFBFBD>ctica) | | | | 0 | 0 | | 0 | 598 | Titular |b04931eb38b0a620b3cdc23e7dfda00608257858|9c2f9821578f859b84447e8b72d99e5bf109082a| |
|
|
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
|
|
|
|
|
|
|
|
-- Derechos - derechos accion ------------------------------------------------ |
|
|
|
|
|
Array |
|
|
( |
|
|
[0] => Array |
|
|
( |
|
|
[0] => asistencia_editar |
|
|
[1] => comision |
|
|
) |
|
|
|
|
|
) |
|
|
|
|
|
|
|
|
-- Derechos - entidades ------------------------------------------------------ |
|
|
|
|
|
Array |
|
|
( |
|
|
[comision] => Array |
|
|
( |
|
|
[0] => comision |
|
|
) |
|
|
|
|
|
) |
|
|
|
|
|
|
|
|
-- CATALOGO: derecho_entidades/tiene_derecho_comisiones | cache [false] - tipo [no] |
|
|
|
|
|
Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[persona] => '8' |
|
|
[derecho] => 'asistencia_editar' |
|
|
[comisiones] => 1029 |
|
|
) |
|
|
|
|
|
[metadata] => Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[0] => persona |
|
|
[1] => derecho |
|
|
[2] => comisiones |
|
|
) |
|
|
|
|
|
[cache] => no |
|
|
[no_quote] => comisiones |
|
|
[filas] => n |
|
|
) |
|
|
|
|
|
[force_cache] => Array |
|
|
( |
|
|
) |
|
|
|
|
|
) |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
SELECT --1 as tiene_derecho, |
|
|
sga_comisiones.comision |
|
|
--gdu_derechos.derecho as derecho, |
|
|
--gdu_derechos.nombre as nombre |
|
|
FROM sga_comisiones, |
|
|
gdu_derechos_personas, |
|
|
gdu_derechos |
|
|
WHERE sga_comisiones.comision IN (1029) |
|
|
AND gdu_derechos_personas.persona = '8' |
|
|
AND gdu_derechos_personas.derecho = 'asistencia_editar' |
|
|
|
|
|
AND gdu_derechos_personas.entidad = sga_comisiones.entidad |
|
|
AND gdu_derechos.derecho = gdu_derechos_personas.derecho |
|
|
AND gdu_derechos.derecho_para = 'C' |
|
|
|
|
|
-- DATOS --------------------------------------------------------------------- |
|
|
|
|
|
Array |
|
|
( |
|
|
[1029] => 1 |
|
|
) |
|
|
|
|
|
|
|
|
-- Adaptador Modelo - Recuperar datos para 'Array |
|
|
( |
|
|
[0] => index |
|
|
) |
|
|
' - fa2e3e66946802e65ebb4d95a37b3f860f15e0f135ee444540d535d6d94c81d0a9bf6d7d398e78ef |
|
|
|
|
|
Array |
|
|
( |
|
|
[id] => 1029 |
|
|
[anio_academico] => 2025 |
|
|
[periodo_lectivo_nombre] => FCYT - Periodo Lectivo 2025 Nivel Secundario |
|
|
[periodo_lectivo_nombre_full] => 2025 - FCYT - Periodo Lectivo 2025 Nivel Secundario |
|
|
[periodo_fecha_inicio] => 2025-02-24 |
|
|
[periodo_lectivo] => 12 |
|
|
[actividad_orden] => Artes Visuales (fcyt-CB102) |
|
|
[actividad] => 8 |
|
|
[actividad_codigo] => fcyt-CB102 |
|
|
[actividad_nombre] => Artes Visuales |
|
|
[actividad_nombre_abreviado] => Artes Visuales |
|
|
[comision] => 1029 |
|
|
[comision_nombre] => 1ero 1era TM |
|
|
[turno] => 1 |
|
|
[turno_nombre] => Ma<EFBFBD>ana |
|
|
[instancias] => Promoci<EFBFBD>n |
|
|
[catedra] => |
|
|
[catedra_nombre] => |
|
|
[ubicacion] => 4 |
|
|
[ubicacion_nombre] => COL. SUP. DEL URUGUAY "J. J. DE URQUIZA" - TM |
|
|
[cupo_comision] => 0 |
|
|
[cant_inscriptos_comision] => 22 |
|
|
[horario_comision] => Mar 07:45 a 09:05 (Te<EFBFBD>rico-Pr<EFBFBD>ctica) |
|
|
[subcomision] => |
|
|
[subcomision_nombre] => |
|
|
[tipo_clase] => |
|
|
[cupo_subcomision] => 0 |
|
|
[cant_inscriptos_subcomision] => 0 |
|
|
[horario_subcomision] => |
|
|
[es_subcomision] => 0 |
|
|
[entidad] => 1610 |
|
|
[resp_docente] => Titular |
|
|
[comision_id] => 8d01f50462cec59395c2ce634770e9048b8fca1c |
|
|
[subcomision_id] => 9c2f9821578f859b84447e8b72d99e5bf109082a |
|
|
[__ID__] => fa2e3e66946802e65ebb4d95a37b3f860f15e0f135ee444540d535d6d94c81d0a9bf6d7d398e78ef |
|
|
) |
|
|
|
|
|
|
|
|
-- CATALOGO: zona_clases/get_propuesta | cache [false] - tipo [no] ----------- |
|
|
|
|
|
Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[comision] => '1029' |
|
|
) |
|
|
|
|
|
[metadata] => Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[0] => comision |
|
|
) |
|
|
|
|
|
[cache] => no |
|
|
[filas] => n |
|
|
) |
|
|
|
|
|
[force_cache] => Array |
|
|
( |
|
|
) |
|
|
|
|
|
) |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
SELECT propuesta |
|
|
FROM sga_comisiones_propuestas |
|
|
WHERE comision = '1029' |
|
|
|
|
|
|
|
|
-- DATOS --------------------------------------------------------------------- |
|
|
|
|
|
----------- |
|
|
|propuesta| |
|
|
----------- |
|
|
| 1 | |
|
|
----------- |
|
|
|
|
|
|
|
|
-- CATALOGO: carga_asistencias/tipo_asistencia | cache [true] - tipo [memoria] |
|
|
|
|
|
Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[comision] => '1029' |
|
|
) |
|
|
|
|
|
[metadata] => Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[0] => comision |
|
|
) |
|
|
|
|
|
[cache] => memoria |
|
|
[filas] => 1 |
|
|
) |
|
|
|
|
|
[force_cache] => Array |
|
|
( |
|
|
) |
|
|
|
|
|
) |
|
|
|
|
|
|
|
|
-- CATALOGO CACHE DATOS ------------------------------------------------------ |
|
|
|
|
|
Array |
|
|
( |
|
|
[asistencia_por_horas] => N |
|
|
[asistencia_cantidad_inasist] => S |
|
|
) |
|
|
|
|
|
|
|
|
-- CATALOGO: carga_asistencias/clase_cabecera | cache [false] - tipo [no] ---- |
|
|
|
|
|
Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[clase] => '9718' |
|
|
) |
|
|
|
|
|
[metadata] => Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[0] => clase |
|
|
) |
|
|
|
|
|
[cache] => no |
|
|
[filas] => 1 |
|
|
) |
|
|
|
|
|
[force_cache] => Array |
|
|
( |
|
|
) |
|
|
|
|
|
) |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
SELECT |
|
|
vw_clases.clase, |
|
|
to_char(vw_clases.fecha, 'DD/MM/YYYY') as fecha_formateada, |
|
|
vw_clases.cantidad_horas_dictadas, |
|
|
vw_clases.tipo_clase_nombre as tipo_clase, |
|
|
to_char(vw_clases.hora_inicio, 'HH24:MI') AS hora_inicio_formateada, |
|
|
to_char(vw_clases.hora_finalizacion, 'HH24:MI') AS hora_finalizacion_formateada, |
|
|
vw_clases.comision_nombre, |
|
|
vw_clases.comision, |
|
|
vw_clases.dia_semana, |
|
|
vw_comisiones.elemento_nombre as actividad_nombre, |
|
|
vw_comisiones.elemento_codigo as actividad_codigo |
|
|
FROM |
|
|
vw_clases, |
|
|
vw_comisiones |
|
|
WHERE |
|
|
vw_clases.comision = vw_comisiones.comision |
|
|
AND vw_clases.clase = '9718' |
|
|
|
|
|
-- DATOS --------------------------------------------------------------------- |
|
|
|
|
|
Array |
|
|
( |
|
|
[clase] => 9718 |
|
|
[fecha_formateada] => 25/02/2025 |
|
|
[cantidad_horas_dictadas] => 1.00 |
|
|
[tipo_clase] => Te<EFBFBD>rico-Pr<EFBFBD>ctica |
|
|
[hora_inicio_formateada] => 07:45 |
|
|
[hora_finalizacion_formateada] => 09:05 |
|
|
[comision_nombre] => 1ero 1era TM |
|
|
[comision] => 1029 |
|
|
[dia_semana] => Martes |
|
|
[actividad_nombre] => Artes Visuales |
|
|
[actividad_codigo] => fcyt-CB102 |
|
|
) |
|
|
|
|
|
|
|
|
-- CLASE --------------------------------------------------------------------- |
|
|
|
|
|
9718 |
|
|
|
|
|
-- ALUMNOS ------------------------------------------------------------------- |
|
|
|
|
|
Array |
|
|
( |
|
|
[b755865f7411a4d9a3c1ba66cf68b72131b27574] => Array |
|
|
( |
|
|
[PRESENTE] => 0.50 |
|
|
) |
|
|
|
|
|
[a6e74a6b21dd6e79e7d6280d946f20b58e425515] => Array |
|
|
( |
|
|
[PRESENTE] => 0 |
|
|
) |
|
|
|
|
|
[854ac58a314e043b58ac90c7958347bde4689b52] => Array |
|
|
( |
|
|
[PRESENTE] => 1 |
|
|
) |
|
|
|
|
|
[e60cec94fa3cf7e78826be3c58e43035d0413547] => Array |
|
|
( |
|
|
[PRESENTE] => 0 |
|
|
) |
|
|
|
|
|
[3defcdbb656e370c988b71691ccb99f867f23219] => Array |
|
|
( |
|
|
[PRESENTE] => 0 |
|
|
) |
|
|
|
|
|
[6ec0710b76cd407d678de10ebe164bd53fe01c3c] => Array |
|
|
( |
|
|
[PRESENTE] => 0 |
|
|
) |
|
|
|
|
|
[af2a7d233db92f7902a677a9a7852d9103bf02ac] => Array |
|
|
( |
|
|
[PRESENTE] => 0 |
|
|
) |
|
|
|
|
|
[a0db992c01f448737e44b824c3de3cfb2d0e6287] => Array |
|
|
( |
|
|
[PRESENTE] => 0 |
|
|
) |
|
|
|
|
|
[3a05f264f8f85c0eb871342fed9dccb68da69fca] => Array |
|
|
( |
|
|
[PRESENTE] => 0 |
|
|
) |
|
|
|
|
|
[1f6b4fdc3e8d847c72882d5b4ff27c7e8a6e212b] => Array |
|
|
( |
|
|
[PRESENTE] => 0 |
|
|
) |
|
|
|
|
|
[46e401888e3c2cd1838a910296e93661e022ff4f] => Array |
|
|
( |
|
|
[PRESENTE] => 0 |
|
|
) |
|
|
|
|
|
[3ff0e0aa021db353d7538f568e8a87af2f3d5c8e] => Array |
|
|
( |
|
|
[PRESENTE] => 0 |
|
|
) |
|
|
|
|
|
[759ddd5618c4b1e6f0ad373cce67b3e1ce746676] => Array |
|
|
( |
|
|
[PRESENTE] => 0 |
|
|
) |
|
|
|
|
|
[b7f57ab57a906ff56ba568a324f2eb4ae828d59b] => Array |
|
|
( |
|
|
[PRESENTE] => 0 |
|
|
) |
|
|
|
|
|
[5bddb08a06e40b0acbaa797bf736d9d2a0b98d0f] => Array |
|
|
( |
|
|
[PRESENTE] => 0 |
|
|
) |
|
|
|
|
|
[d3b32264621da36d11168a3546a7a8d9c3885632] => Array |
|
|
( |
|
|
[PRESENTE] => 0 |
|
|
) |
|
|
|
|
|
[2c3666d373af149ac8edf443c16f038309a948a9] => Array |
|
|
( |
|
|
[PRESENTE] => 0 |
|
|
) |
|
|
|
|
|
[817883b2c71db63b4f6d6ec6d07e3e114a434834] => Array |
|
|
( |
|
|
[PRESENTE] => 0 |
|
|
) |
|
|
|
|
|
[c1ee67e9cf41699f358b9b6da2ee9693ecfaad11] => Array |
|
|
( |
|
|
[PRESENTE] => 0 |
|
|
) |
|
|
|
|
|
[193fff90242fac71e339f9178b109f0834d9f02d] => Array |
|
|
( |
|
|
[PRESENTE] => 0 |
|
|
) |
|
|
|
|
|
[e13acc52a3025c7705240e8458f756b2ce939d52] => Array |
|
|
( |
|
|
[PRESENTE] => 0 |
|
|
) |
|
|
|
|
|
[81e803fade8204740437a38b9fc9ec9b0a310c5a] => Array |
|
|
( |
|
|
[PRESENTE] => 0 |
|
|
) |
|
|
|
|
|
) |
|
|
|
|
|
|
|
|
-- CATALOGO: carga_asistencias/clase_detalle | cache [false] - tipo [no] ----- |
|
|
|
|
|
Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[comision] => '1029' |
|
|
[clase] => '9718' |
|
|
[subcomision] => |
|
|
) |
|
|
|
|
|
[metadata] => Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[0] => comision |
|
|
[1] => clase |
|
|
[2] => subcomision |
|
|
) |
|
|
|
|
|
[param_null] => Array |
|
|
( |
|
|
[0] => subcomision |
|
|
) |
|
|
|
|
|
[cache] => no |
|
|
[filas] => n |
|
|
) |
|
|
|
|
|
[force_cache] => Array |
|
|
( |
|
|
) |
|
|
|
|
|
) |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
SELECT |
|
|
sga_insc_cursada.alumno, |
|
|
sga_alumnos.legajo, |
|
|
vw_personas.apellido_nombres AS apellido_y_nombres, |
|
|
vw_personas.apellido_nombres_elegido AS apellido_y_nombres_elegido, |
|
|
vw_personas.tipo_nro_documento AS documento_principal, |
|
|
sga_insc_cursada.comision, |
|
|
COALESCE(sga_clases_asistencia.cant_inasistencias, -1) as cant_inasistencias, |
|
|
vw_personas.id_imagen as id_imagen, |
|
|
COALESCE(sga_clases_asistencia_acum.libre,0) as libre, |
|
|
sga_clases_asistencia.cant_justificadas as cant_justificadas, |
|
|
sga_clases_asistencia.motivo_ausencia as motivo_ausencia, |
|
|
sga_motivos_ausencias.nombre as motivo_ausencia_nombre, |
|
|
sga_motivos_ausencias.descripcion as motivo_ausencia_descripcion, |
|
|
sga_clases_asistencia.estado_justificacion as estado_justificacion, |
|
|
sga_clases_asistencia.observaciones as observaciones, |
|
|
coalesce((with pepepe as |
|
|
(select distinct alumno, fecha, cant_justificadas |
|
|
from vw_inasistencias_unca |
|
|
where anio_academico = (extract (year from (select fecha from sga_clases where clase = '9718'))) and cant_justificadas > 0 and alumno = sga_alumnos.alumno |
|
|
order by alumno, fecha |
|
|
) select sum(cant_justificadas) |
|
|
from pepepe),0) as justificadas, |
|
|
coalesce((with pepepe as |
|
|
(select distinct alumno, fecha, cant_inasistencias |
|
|
from vw_inasistencias_unca |
|
|
where anio_academico = (extract (year from (select fecha from sga_clases where clase = '9718'))) and cant_inasistencias > 0 and alumno = sga_alumnos.alumno |
|
|
order by alumno, fecha |
|
|
) select sum(cant_inasistencias) |
|
|
from pepepe),0) as inasistencias |
|
|
|
|
|
FROM sga_insc_cursada |
|
|
JOIN sga_alumnos ON sga_alumnos.alumno = sga_insc_cursada.alumno |
|
|
JOIN vw_personas ON vw_personas.persona = sga_alumnos.persona |
|
|
|
|
|
LEFT JOIN sga_clases_asistencia_acum ON (sga_clases_asistencia_acum.alumno = sga_insc_cursada.alumno AND sga_clases_asistencia_acum.comision = sga_insc_cursada.comision) |
|
|
LEFT JOIN sga_clases_asistencia ON (sga_clases_asistencia.clase = '9718' AND sga_clases_asistencia.alumno = sga_insc_cursada.alumno) |
|
|
LEFT JOIN sga_motivos_ausencias ON (sga_motivos_ausencias.motivo_ausencia = sga_clases_asistencia.motivo_ausencia) |
|
|
WHERE sga_insc_cursada.comision = '1029' |
|
|
AND sga_alumnos.calidad <> 'P' |
|
|
ORDER BY vw_personas.apellido_nombres_elegido |
|
|
|
|
|
|
|
|
-- DATOS --------------------------------------------------------------------- |
|
|
|
|
|
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
|
|
|alumno|legajo| apellido_y_nombres | apellido_y_nombres_elegido |documento_principal|comision|cant_inasistencias|id_imagen|libre|cant_justificadas|motivo_ausencia|motivo_ausencia_nombre|motivo_ausencia_descripcion|estado_justificacion|observaciones|justificadas|inasistencias| __ID__ | url_imagen | url_imagen_mediana | url_imagen_grande | |
|
|
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
|
|
| 21 | | ALLOIS, Joaqu<EFBFBD>n | ALLOIS, Joaqu<EFBFBD>n | DNI 53250901 | 1029 | -1 | | 0 | | | | | | | 0 | 0 |b755865f7411a4d9a3c1ba66cf68b72131b27574|/colegio/img/iconos/mm.png|/colegio/img/iconos/mm_grande.png|/colegio/img/iconos/mm_grande.png| |
|
|
| 52 | | BERNASCONI, Maycol Jes<EFBFBD>s | BERNASCONI, Maycol Jes<EFBFBD>s | DNI 53007068 | 1029 | -1 | | 0 | | | | | | | 0 | 0 |a6e74a6b21dd6e79e7d6280d946f20b58e425515|/colegio/img/iconos/mm.png|/colegio/img/iconos/mm_grande.png|/colegio/img/iconos/mm_grande.png| |
|
|
| 128 | | CARABALLO, Tiago H<EFBFBD>ctor | CARABALLO, Tiago H<EFBFBD>ctor | DNI 51286039 | 1029 | -1 | | 0 | | | | | | | 0 | 0 |854ac58a314e043b58ac90c7958347bde4689b52|/colegio/img/iconos/mm.png|/colegio/img/iconos/mm_grande.png|/colegio/img/iconos/mm_grande.png| |
|
|
| 53 | |CARBONETTO ANUZIS, Camilo Daniel |CARBONETTO ANUZIS, Camilo Daniel | DNI 53063839 | 1029 | -1 | | 0 | | | | | | | 0 | 0 |e60cec94fa3cf7e78826be3c58e43035d0413547|/colegio/img/iconos/mm.png|/colegio/img/iconos/mm_grande.png|/colegio/img/iconos/mm_grande.png| |
|
|
| 54 | | DIAZ, Iris Nicol | DIAZ, Iris Nicol | DNI 52496448 | 1029 | -1 | | 0 | | | | | | | 0 | 0 |3defcdbb656e370c988b71691ccb99f867f23219|/colegio/img/iconos/mm.png|/colegio/img/iconos/mm_grande.png|/colegio/img/iconos/mm_grande.png| |
|
|
| 55 | | ESTREMERO, Ludmila Abigail | ESTREMERO, Ludmila Abigail | DNI 53006327 | 1029 | -1 | | 0 | | | | | | | 0 | 0 |6ec0710b76cd407d678de10ebe164bd53fe01c3c|/colegio/img/iconos/mm.png|/colegio/img/iconos/mm_grande.png|/colegio/img/iconos/mm_grande.png| |
|
|
| 56 | | FLEITAS, Uriel Santiago | FLEITAS, Uriel Santiago | DNI 52731121 | 1029 | -1 | | 0 | | | | | | | 0 | 0 |af2a7d233db92f7902a677a9a7852d9103bf02ac|/colegio/img/iconos/mm.png|/colegio/img/iconos/mm_grande.png|/colegio/img/iconos/mm_grande.png| |
|
|
| 57 | | FRANCOVIG, William Aaron | FRANCOVIG, William Aaron | DNI 53250994 | 1029 | -1 | | 0 | | | | | | | 0 | 0 |a0db992c01f448737e44b824c3de3cfb2d0e6287|/colegio/img/iconos/mm.png|/colegio/img/iconos/mm_grande.png|/colegio/img/iconos/mm_grande.png| |
|
|
| 58 | | GHIRARDI,, Mateo Antonio | GHIRARDI,, Mateo Antonio | DNI 52731338 | 1029 | -1 | | 0 | | | | | | | 0 | 0 |3a05f264f8f85c0eb871342fed9dccb68da69fca|/colegio/img/iconos/mm.png|/colegio/img/iconos/mm_grande.png|/colegio/img/iconos/mm_grande.png| |
|
|
| 59 | | GOMEZ, Brenda Ailin | GOMEZ, Brenda Ailin | DNI 53004007 | 1029 | -1 | | 0 | | | | | | | 0 | 0 |1f6b4fdc3e8d847c72882d5b4ff27c7e8a6e212b|/colegio/img/iconos/mm.png|/colegio/img/iconos/mm_grande.png|/colegio/img/iconos/mm_grande.png| |
|
|
| 60 | | GONZALEZ GABBI, CAMILA | GONZALEZ GABBI, CAMILA | DNI 53273457 | 1029 | -1 | | 0 | | | | | | | 0 | 0 |46e401888e3c2cd1838a910296e93661e022ff4f|/colegio/img/iconos/mm.png|/colegio/img/iconos/mm_grande.png|/colegio/img/iconos/mm_grande.png| |
|
|
| 61 | | GONZ<EFBFBD>LEZ, Jon<EFBFBD>s Benjam<EFBFBD>n | GONZ<EFBFBD>LEZ, Jon<EFBFBD>s Benjam<EFBFBD>n | DNI 53004086 | 1029 | -1 | | 0 | | | | | | | 0 | 0 |3ff0e0aa021db353d7538f568e8a87af2f3d5c8e|/colegio/img/iconos/mm.png|/colegio/img/iconos/mm_grande.png|/colegio/img/iconos/mm_grande.png| |
|
|
| 213 | | ISLA, Thiago Benjam<EFBFBD>n | ISLA, Thiago Benjam<EFBFBD>n | DNI 52496498 | 1029 | -1 | | 0 | | | | | | | 0 | 0 |759ddd5618c4b1e6f0ad373cce67b3e1ce746676|/colegio/img/iconos/mm.png|/colegio/img/iconos/mm_grande.png|/colegio/img/iconos/mm_grande.png| |
|
|
| 208 | | MARQUEZ, Dylan Nahuel | MARQUEZ, Dylan Nahuel | DNI 52261797 | 1029 | -1 | | 0 | | | | | | | 0 | 0 |b7f57ab57a906ff56ba568a324f2eb4ae828d59b|/colegio/img/iconos/mm.png|/colegio/img/iconos/mm_grande.png|/colegio/img/iconos/mm_grande.png| |
|
|
| 209 | | MOR<EFBFBD>A, Luna Malena | MOR<EFBFBD>A, Luna Malena | DNI 52492489 | 1029 | -1 | | 0 | | | | | | | 0 | 0 |5bddb08a06e40b0acbaa797bf736d9d2a0b98d0f|/colegio/img/iconos/mm.png|/colegio/img/iconos/mm_grande.png|/colegio/img/iconos/mm_grande.png| |
|
|
| 210 | | MUSICCO, Juan Mart<EFBFBD>n | MUSICCO, Juan Mart<EFBFBD>n | DNI 52821967 | 1029 | -1 | | 0 | | | | | | | 0 | 0 |d3b32264621da36d11168a3546a7a8d9c3885632|/colegio/img/iconos/mm.png|/colegio/img/iconos/mm_grande.png|/colegio/img/iconos/mm_grande.png| |
|
|
| 211 | | PAREJAS, Augusto Benicio | PAREJAS, Augusto Benicio | DNI 53007865 | 1029 | -1 | | 0 | | | | | | | 0 | 0 |2c3666d373af149ac8edf443c16f038309a948a9|/colegio/img/iconos/mm.png|/colegio/img/iconos/mm_grande.png|/colegio/img/iconos/mm_grande.png| |
|
|
| 212 | | PESCE, Nayla | PESCE, Nayla | DNI 53004055 | 1029 | -1 | | 0 | | | | | | | 0 | 0 |817883b2c71db63b4f6d6ec6d07e3e114a434834|/colegio/img/iconos/mm.png|/colegio/img/iconos/mm_grande.png|/colegio/img/iconos/mm_grande.png| |
|
|
| 129 | | RAM<EFBFBD>REZ, H<EFBFBD>ctor Daniel | RAM<EFBFBD>REZ, H<EFBFBD>ctor Daniel | DNI 52255011 | 1029 | -1 | | 0 | | | | | | | 0 | 0 |c1ee67e9cf41699f358b9b6da2ee9693ecfaad11|/colegio/img/iconos/mm.png|/colegio/img/iconos/mm_grande.png|/colegio/img/iconos/mm_grande.png| |
|
|
| 62 | |RODRIGUEZ MARTINEZ, Eluney Danisa|RODRIGUEZ MARTINEZ, Eluney Danisa| DNI 52255008 | 1029 | -1 | | 0 | | | | | | | 0 | 0 |193fff90242fac71e339f9178b109f0834d9f02d|/colegio/img/iconos/mm.png|/colegio/img/iconos/mm_grande.png|/colegio/img/iconos/mm_grande.png| |
|
|
| 63 | | STEGEMAN, Angie Nicole | STEGEMAN, Angie Nicole | DNI 52496447 | 1029 | -1 | | 0 | | | | | | | 0 | 0 |e13acc52a3025c7705240e8458f756b2ce939d52|/colegio/img/iconos/mm.png|/colegio/img/iconos/mm_grande.png|/colegio/img/iconos/mm_grande.png| |
|
|
| 64 | | TRAVERSO, Gino Timoteo | TRAVERSO, Gino Timoteo | DNI 53250971 | 1029 | -1 | | 0 | | | | | | | 0 | 0 |81e803fade8204740437a38b9fc9ec9b0a310c5a|/colegio/img/iconos/mm.png|/colegio/img/iconos/mm_grande.png|/colegio/img/iconos/mm_grande.png| |
|
|
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
|
|
|
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
BEGIN WORK |
|
|
|
|
|
-- ABRIR transaccion --------------------------------------------------------- |
|
|
|
|
|
base: toba_3_3 |
|
|
|
|
|
-- CATALOGO: carga_asistencias/guardar | cache [false] - tipo [no] ----------- |
|
|
|
|
|
Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[alumno] => '21' |
|
|
[clase] => '9718' |
|
|
[motivo] => |
|
|
[cantidad] => '0.50' |
|
|
) |
|
|
|
|
|
[metadata] => Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[0] => alumno |
|
|
[1] => clase |
|
|
[2] => cantidad |
|
|
[3] => motivo |
|
|
) |
|
|
|
|
|
[param_null] => Array |
|
|
( |
|
|
[0] => motivo |
|
|
) |
|
|
|
|
|
[cache] => no |
|
|
[filas] => 1 |
|
|
) |
|
|
|
|
|
[force_cache] => Array |
|
|
( |
|
|
) |
|
|
|
|
|
) |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
|
|
|
SELECT cant_inasistencias, motivo_ausencia |
|
|
FROM sga_clases_asistencia |
|
|
WHERE clase = '9718' |
|
|
AND alumno = '21' |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select clase from sga_clases where banda_horaria in ( |
|
|
select banda_horaria from sga_comisiones_bh where comision in ( |
|
|
select sc.comision |
|
|
from sga_comisiones sc |
|
|
join sga_periodos_lectivos spl ON sc.periodo_lectivo = spl.periodo_lectivo |
|
|
left join sga_comisiones_excep_perlect scep ON sc.comision = scep.comision |
|
|
where (sc.division is null or sc.division in ( |
|
|
select division from sga_alumnos sa where alumno = '21' |
|
|
)) |
|
|
and (select fecha from sga_clases where clase = '9718') between coalesce(scep.fecha_inicio_dictado, spl.fecha_inicio_dictado) and coalesce(scep.fecha_fin_dictado, spl.fecha_fin_dictado) |
|
|
and (sc.turno is null or sc.turno = (select turno |
|
|
from sga_comisiones sc |
|
|
join sga_comisiones_bh scb ON sc.comision = scb.comision |
|
|
join sga_clases scl ON scb.banda_horaria = scl.banda_horaria and clase= '9718')) |
|
|
and exists (select '' from sga_insc_cursada sic where sic.comision =sc.comision and alumno = '21' ) |
|
|
) |
|
|
) |
|
|
and fecha = (select fecha from sga_clases where clase = '9718') |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 9718 and alumno = '21' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 9718, '21', '0.50', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 12670 and alumno = '21' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 12670, '21', '0.50', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 13039 and alumno = '21' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 13039, '21', '0.50', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 17180 and alumno = '21' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 17180, '21', '0.50', null, 'A') |
|
|
|
|
|
-- DATOS --------------------------------------------------------------------- |
|
|
|
|
|
1 |
|
|
|
|
|
-- CATALOGO: carga_asistencias/guardar | cache [false] - tipo [no] ----------- |
|
|
|
|
|
Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[alumno] => '52' |
|
|
[clase] => '9718' |
|
|
[motivo] => |
|
|
[cantidad] => '0' |
|
|
) |
|
|
|
|
|
[metadata] => Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[0] => alumno |
|
|
[1] => clase |
|
|
[2] => cantidad |
|
|
[3] => motivo |
|
|
) |
|
|
|
|
|
[param_null] => Array |
|
|
( |
|
|
[0] => motivo |
|
|
) |
|
|
|
|
|
[cache] => no |
|
|
[filas] => 1 |
|
|
) |
|
|
|
|
|
[force_cache] => Array |
|
|
( |
|
|
) |
|
|
|
|
|
) |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
|
|
|
SELECT cant_inasistencias, motivo_ausencia |
|
|
FROM sga_clases_asistencia |
|
|
WHERE clase = '9718' |
|
|
AND alumno = '52' |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select clase from sga_clases where banda_horaria in ( |
|
|
select banda_horaria from sga_comisiones_bh where comision in ( |
|
|
select sc.comision |
|
|
from sga_comisiones sc |
|
|
join sga_periodos_lectivos spl ON sc.periodo_lectivo = spl.periodo_lectivo |
|
|
left join sga_comisiones_excep_perlect scep ON sc.comision = scep.comision |
|
|
where (sc.division is null or sc.division in ( |
|
|
select division from sga_alumnos sa where alumno = '52' |
|
|
)) |
|
|
and (select fecha from sga_clases where clase = '9718') between coalesce(scep.fecha_inicio_dictado, spl.fecha_inicio_dictado) and coalesce(scep.fecha_fin_dictado, spl.fecha_fin_dictado) |
|
|
and (sc.turno is null or sc.turno = (select turno |
|
|
from sga_comisiones sc |
|
|
join sga_comisiones_bh scb ON sc.comision = scb.comision |
|
|
join sga_clases scl ON scb.banda_horaria = scl.banda_horaria and clase= '9718')) |
|
|
and exists (select '' from sga_insc_cursada sic where sic.comision =sc.comision and alumno = '52' ) |
|
|
) |
|
|
) |
|
|
and fecha = (select fecha from sga_clases where clase = '9718') |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 9718 and alumno = '52' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 9718, '52', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 10087 and alumno = '52' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 10087, '52', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 12670 and alumno = '52' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 12670, '52', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 13039 and alumno = '52' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 13039, '52', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 17180 and alumno = '52' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 17180, '52', '0', null, 'A') |
|
|
|
|
|
-- DATOS --------------------------------------------------------------------- |
|
|
|
|
|
1 |
|
|
|
|
|
-- CATALOGO: carga_asistencias/guardar | cache [false] - tipo [no] ----------- |
|
|
|
|
|
Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[alumno] => '128' |
|
|
[clase] => '9718' |
|
|
[motivo] => |
|
|
[cantidad] => '1' |
|
|
) |
|
|
|
|
|
[metadata] => Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[0] => alumno |
|
|
[1] => clase |
|
|
[2] => cantidad |
|
|
[3] => motivo |
|
|
) |
|
|
|
|
|
[param_null] => Array |
|
|
( |
|
|
[0] => motivo |
|
|
) |
|
|
|
|
|
[cache] => no |
|
|
[filas] => 1 |
|
|
) |
|
|
|
|
|
[force_cache] => Array |
|
|
( |
|
|
) |
|
|
|
|
|
) |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
|
|
|
SELECT cant_inasistencias, motivo_ausencia |
|
|
FROM sga_clases_asistencia |
|
|
WHERE clase = '9718' |
|
|
AND alumno = '128' |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select clase from sga_clases where banda_horaria in ( |
|
|
select banda_horaria from sga_comisiones_bh where comision in ( |
|
|
select sc.comision |
|
|
from sga_comisiones sc |
|
|
join sga_periodos_lectivos spl ON sc.periodo_lectivo = spl.periodo_lectivo |
|
|
left join sga_comisiones_excep_perlect scep ON sc.comision = scep.comision |
|
|
where (sc.division is null or sc.division in ( |
|
|
select division from sga_alumnos sa where alumno = '128' |
|
|
)) |
|
|
and (select fecha from sga_clases where clase = '9718') between coalesce(scep.fecha_inicio_dictado, spl.fecha_inicio_dictado) and coalesce(scep.fecha_fin_dictado, spl.fecha_fin_dictado) |
|
|
and (sc.turno is null or sc.turno = (select turno |
|
|
from sga_comisiones sc |
|
|
join sga_comisiones_bh scb ON sc.comision = scb.comision |
|
|
join sga_clases scl ON scb.banda_horaria = scl.banda_horaria and clase= '9718')) |
|
|
and exists (select '' from sga_insc_cursada sic where sic.comision =sc.comision and alumno = '128' ) |
|
|
) |
|
|
) |
|
|
and fecha = (select fecha from sga_clases where clase = '9718') |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 9718 and alumno = '128' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 9718, '128', '1', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 10087 and alumno = '128' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 10087, '128', '1', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 12670 and alumno = '128' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 12670, '128', '1', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 13039 and alumno = '128' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 13039, '128', '1', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 17180 and alumno = '128' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 17180, '128', '1', null, 'A') |
|
|
|
|
|
-- DATOS --------------------------------------------------------------------- |
|
|
|
|
|
1 |
|
|
|
|
|
-- CATALOGO: carga_asistencias/guardar | cache [false] - tipo [no] ----------- |
|
|
|
|
|
Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[alumno] => '53' |
|
|
[clase] => '9718' |
|
|
[motivo] => |
|
|
[cantidad] => '0' |
|
|
) |
|
|
|
|
|
[metadata] => Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[0] => alumno |
|
|
[1] => clase |
|
|
[2] => cantidad |
|
|
[3] => motivo |
|
|
) |
|
|
|
|
|
[param_null] => Array |
|
|
( |
|
|
[0] => motivo |
|
|
) |
|
|
|
|
|
[cache] => no |
|
|
[filas] => 1 |
|
|
) |
|
|
|
|
|
[force_cache] => Array |
|
|
( |
|
|
) |
|
|
|
|
|
) |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
|
|
|
SELECT cant_inasistencias, motivo_ausencia |
|
|
FROM sga_clases_asistencia |
|
|
WHERE clase = '9718' |
|
|
AND alumno = '53' |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select clase from sga_clases where banda_horaria in ( |
|
|
select banda_horaria from sga_comisiones_bh where comision in ( |
|
|
select sc.comision |
|
|
from sga_comisiones sc |
|
|
join sga_periodos_lectivos spl ON sc.periodo_lectivo = spl.periodo_lectivo |
|
|
left join sga_comisiones_excep_perlect scep ON sc.comision = scep.comision |
|
|
where (sc.division is null or sc.division in ( |
|
|
select division from sga_alumnos sa where alumno = '53' |
|
|
)) |
|
|
and (select fecha from sga_clases where clase = '9718') between coalesce(scep.fecha_inicio_dictado, spl.fecha_inicio_dictado) and coalesce(scep.fecha_fin_dictado, spl.fecha_fin_dictado) |
|
|
and (sc.turno is null or sc.turno = (select turno |
|
|
from sga_comisiones sc |
|
|
join sga_comisiones_bh scb ON sc.comision = scb.comision |
|
|
join sga_clases scl ON scb.banda_horaria = scl.banda_horaria and clase= '9718')) |
|
|
and exists (select '' from sga_insc_cursada sic where sic.comision =sc.comision and alumno = '53' ) |
|
|
) |
|
|
) |
|
|
and fecha = (select fecha from sga_clases where clase = '9718') |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 9718 and alumno = '53' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 9718, '53', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 10087 and alumno = '53' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 10087, '53', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 12670 and alumno = '53' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 12670, '53', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 13039 and alumno = '53' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 13039, '53', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 17180 and alumno = '53' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 17180, '53', '0', null, 'A') |
|
|
|
|
|
-- DATOS --------------------------------------------------------------------- |
|
|
|
|
|
1 |
|
|
|
|
|
-- CATALOGO: carga_asistencias/guardar | cache [false] - tipo [no] ----------- |
|
|
|
|
|
Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[alumno] => '54' |
|
|
[clase] => '9718' |
|
|
[motivo] => |
|
|
[cantidad] => '0' |
|
|
) |
|
|
|
|
|
[metadata] => Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[0] => alumno |
|
|
[1] => clase |
|
|
[2] => cantidad |
|
|
[3] => motivo |
|
|
) |
|
|
|
|
|
[param_null] => Array |
|
|
( |
|
|
[0] => motivo |
|
|
) |
|
|
|
|
|
[cache] => no |
|
|
[filas] => 1 |
|
|
) |
|
|
|
|
|
[force_cache] => Array |
|
|
( |
|
|
) |
|
|
|
|
|
) |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
|
|
|
SELECT cant_inasistencias, motivo_ausencia |
|
|
FROM sga_clases_asistencia |
|
|
WHERE clase = '9718' |
|
|
AND alumno = '54' |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select clase from sga_clases where banda_horaria in ( |
|
|
select banda_horaria from sga_comisiones_bh where comision in ( |
|
|
select sc.comision |
|
|
from sga_comisiones sc |
|
|
join sga_periodos_lectivos spl ON sc.periodo_lectivo = spl.periodo_lectivo |
|
|
left join sga_comisiones_excep_perlect scep ON sc.comision = scep.comision |
|
|
where (sc.division is null or sc.division in ( |
|
|
select division from sga_alumnos sa where alumno = '54' |
|
|
)) |
|
|
and (select fecha from sga_clases where clase = '9718') between coalesce(scep.fecha_inicio_dictado, spl.fecha_inicio_dictado) and coalesce(scep.fecha_fin_dictado, spl.fecha_fin_dictado) |
|
|
and (sc.turno is null or sc.turno = (select turno |
|
|
from sga_comisiones sc |
|
|
join sga_comisiones_bh scb ON sc.comision = scb.comision |
|
|
join sga_clases scl ON scb.banda_horaria = scl.banda_horaria and clase= '9718')) |
|
|
and exists (select '' from sga_insc_cursada sic where sic.comision =sc.comision and alumno = '54' ) |
|
|
) |
|
|
) |
|
|
and fecha = (select fecha from sga_clases where clase = '9718') |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 9718 and alumno = '54' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 9718, '54', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 10087 and alumno = '54' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 10087, '54', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 12670 and alumno = '54' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 12670, '54', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 13039 and alumno = '54' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 13039, '54', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 17180 and alumno = '54' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 17180, '54', '0', null, 'A') |
|
|
|
|
|
-- DATOS --------------------------------------------------------------------- |
|
|
|
|
|
1 |
|
|
|
|
|
-- CATALOGO: carga_asistencias/guardar | cache [false] - tipo [no] ----------- |
|
|
|
|
|
Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[alumno] => '55' |
|
|
[clase] => '9718' |
|
|
[motivo] => |
|
|
[cantidad] => '0' |
|
|
) |
|
|
|
|
|
[metadata] => Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[0] => alumno |
|
|
[1] => clase |
|
|
[2] => cantidad |
|
|
[3] => motivo |
|
|
) |
|
|
|
|
|
[param_null] => Array |
|
|
( |
|
|
[0] => motivo |
|
|
) |
|
|
|
|
|
[cache] => no |
|
|
[filas] => 1 |
|
|
) |
|
|
|
|
|
[force_cache] => Array |
|
|
( |
|
|
) |
|
|
|
|
|
) |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
|
|
|
SELECT cant_inasistencias, motivo_ausencia |
|
|
FROM sga_clases_asistencia |
|
|
WHERE clase = '9718' |
|
|
AND alumno = '55' |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select clase from sga_clases where banda_horaria in ( |
|
|
select banda_horaria from sga_comisiones_bh where comision in ( |
|
|
select sc.comision |
|
|
from sga_comisiones sc |
|
|
join sga_periodos_lectivos spl ON sc.periodo_lectivo = spl.periodo_lectivo |
|
|
left join sga_comisiones_excep_perlect scep ON sc.comision = scep.comision |
|
|
where (sc.division is null or sc.division in ( |
|
|
select division from sga_alumnos sa where alumno = '55' |
|
|
)) |
|
|
and (select fecha from sga_clases where clase = '9718') between coalesce(scep.fecha_inicio_dictado, spl.fecha_inicio_dictado) and coalesce(scep.fecha_fin_dictado, spl.fecha_fin_dictado) |
|
|
and (sc.turno is null or sc.turno = (select turno |
|
|
from sga_comisiones sc |
|
|
join sga_comisiones_bh scb ON sc.comision = scb.comision |
|
|
join sga_clases scl ON scb.banda_horaria = scl.banda_horaria and clase= '9718')) |
|
|
and exists (select '' from sga_insc_cursada sic where sic.comision =sc.comision and alumno = '55' ) |
|
|
) |
|
|
) |
|
|
and fecha = (select fecha from sga_clases where clase = '9718') |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 9718 and alumno = '55' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 9718, '55', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 10087 and alumno = '55' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 10087, '55', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 12670 and alumno = '55' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 12670, '55', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 13039 and alumno = '55' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 13039, '55', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 17180 and alumno = '55' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 17180, '55', '0', null, 'A') |
|
|
|
|
|
-- DATOS --------------------------------------------------------------------- |
|
|
|
|
|
1 |
|
|
|
|
|
-- CATALOGO: carga_asistencias/guardar | cache [false] - tipo [no] ----------- |
|
|
|
|
|
Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[alumno] => '56' |
|
|
[clase] => '9718' |
|
|
[motivo] => |
|
|
[cantidad] => '0' |
|
|
) |
|
|
|
|
|
[metadata] => Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[0] => alumno |
|
|
[1] => clase |
|
|
[2] => cantidad |
|
|
[3] => motivo |
|
|
) |
|
|
|
|
|
[param_null] => Array |
|
|
( |
|
|
[0] => motivo |
|
|
) |
|
|
|
|
|
[cache] => no |
|
|
[filas] => 1 |
|
|
) |
|
|
|
|
|
[force_cache] => Array |
|
|
( |
|
|
) |
|
|
|
|
|
) |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
|
|
|
SELECT cant_inasistencias, motivo_ausencia |
|
|
FROM sga_clases_asistencia |
|
|
WHERE clase = '9718' |
|
|
AND alumno = '56' |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select clase from sga_clases where banda_horaria in ( |
|
|
select banda_horaria from sga_comisiones_bh where comision in ( |
|
|
select sc.comision |
|
|
from sga_comisiones sc |
|
|
join sga_periodos_lectivos spl ON sc.periodo_lectivo = spl.periodo_lectivo |
|
|
left join sga_comisiones_excep_perlect scep ON sc.comision = scep.comision |
|
|
where (sc.division is null or sc.division in ( |
|
|
select division from sga_alumnos sa where alumno = '56' |
|
|
)) |
|
|
and (select fecha from sga_clases where clase = '9718') between coalesce(scep.fecha_inicio_dictado, spl.fecha_inicio_dictado) and coalesce(scep.fecha_fin_dictado, spl.fecha_fin_dictado) |
|
|
and (sc.turno is null or sc.turno = (select turno |
|
|
from sga_comisiones sc |
|
|
join sga_comisiones_bh scb ON sc.comision = scb.comision |
|
|
join sga_clases scl ON scb.banda_horaria = scl.banda_horaria and clase= '9718')) |
|
|
and exists (select '' from sga_insc_cursada sic where sic.comision =sc.comision and alumno = '56' ) |
|
|
) |
|
|
) |
|
|
and fecha = (select fecha from sga_clases where clase = '9718') |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 9718 and alumno = '56' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 9718, '56', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 10087 and alumno = '56' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 10087, '56', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 12670 and alumno = '56' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 12670, '56', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 13039 and alumno = '56' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 13039, '56', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 17180 and alumno = '56' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 17180, '56', '0', null, 'A') |
|
|
|
|
|
-- DATOS --------------------------------------------------------------------- |
|
|
|
|
|
1 |
|
|
|
|
|
-- CATALOGO: carga_asistencias/guardar | cache [false] - tipo [no] ----------- |
|
|
|
|
|
Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[alumno] => '57' |
|
|
[clase] => '9718' |
|
|
[motivo] => |
|
|
[cantidad] => '0' |
|
|
) |
|
|
|
|
|
[metadata] => Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[0] => alumno |
|
|
[1] => clase |
|
|
[2] => cantidad |
|
|
[3] => motivo |
|
|
) |
|
|
|
|
|
[param_null] => Array |
|
|
( |
|
|
[0] => motivo |
|
|
) |
|
|
|
|
|
[cache] => no |
|
|
[filas] => 1 |
|
|
) |
|
|
|
|
|
[force_cache] => Array |
|
|
( |
|
|
) |
|
|
|
|
|
) |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
|
|
|
SELECT cant_inasistencias, motivo_ausencia |
|
|
FROM sga_clases_asistencia |
|
|
WHERE clase = '9718' |
|
|
AND alumno = '57' |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select clase from sga_clases where banda_horaria in ( |
|
|
select banda_horaria from sga_comisiones_bh where comision in ( |
|
|
select sc.comision |
|
|
from sga_comisiones sc |
|
|
join sga_periodos_lectivos spl ON sc.periodo_lectivo = spl.periodo_lectivo |
|
|
left join sga_comisiones_excep_perlect scep ON sc.comision = scep.comision |
|
|
where (sc.division is null or sc.division in ( |
|
|
select division from sga_alumnos sa where alumno = '57' |
|
|
)) |
|
|
and (select fecha from sga_clases where clase = '9718') between coalesce(scep.fecha_inicio_dictado, spl.fecha_inicio_dictado) and coalesce(scep.fecha_fin_dictado, spl.fecha_fin_dictado) |
|
|
and (sc.turno is null or sc.turno = (select turno |
|
|
from sga_comisiones sc |
|
|
join sga_comisiones_bh scb ON sc.comision = scb.comision |
|
|
join sga_clases scl ON scb.banda_horaria = scl.banda_horaria and clase= '9718')) |
|
|
and exists (select '' from sga_insc_cursada sic where sic.comision =sc.comision and alumno = '57' ) |
|
|
) |
|
|
) |
|
|
and fecha = (select fecha from sga_clases where clase = '9718') |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 9718 and alumno = '57' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 9718, '57', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 10087 and alumno = '57' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 10087, '57', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 12670 and alumno = '57' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 12670, '57', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 13039 and alumno = '57' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 13039, '57', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 17180 and alumno = '57' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 17180, '57', '0', null, 'A') |
|
|
|
|
|
-- DATOS --------------------------------------------------------------------- |
|
|
|
|
|
1 |
|
|
|
|
|
-- CATALOGO: carga_asistencias/guardar | cache [false] - tipo [no] ----------- |
|
|
|
|
|
Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[alumno] => '58' |
|
|
[clase] => '9718' |
|
|
[motivo] => |
|
|
[cantidad] => '0' |
|
|
) |
|
|
|
|
|
[metadata] => Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[0] => alumno |
|
|
[1] => clase |
|
|
[2] => cantidad |
|
|
[3] => motivo |
|
|
) |
|
|
|
|
|
[param_null] => Array |
|
|
( |
|
|
[0] => motivo |
|
|
) |
|
|
|
|
|
[cache] => no |
|
|
[filas] => 1 |
|
|
) |
|
|
|
|
|
[force_cache] => Array |
|
|
( |
|
|
) |
|
|
|
|
|
) |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
|
|
|
SELECT cant_inasistencias, motivo_ausencia |
|
|
FROM sga_clases_asistencia |
|
|
WHERE clase = '9718' |
|
|
AND alumno = '58' |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select clase from sga_clases where banda_horaria in ( |
|
|
select banda_horaria from sga_comisiones_bh where comision in ( |
|
|
select sc.comision |
|
|
from sga_comisiones sc |
|
|
join sga_periodos_lectivos spl ON sc.periodo_lectivo = spl.periodo_lectivo |
|
|
left join sga_comisiones_excep_perlect scep ON sc.comision = scep.comision |
|
|
where (sc.division is null or sc.division in ( |
|
|
select division from sga_alumnos sa where alumno = '58' |
|
|
)) |
|
|
and (select fecha from sga_clases where clase = '9718') between coalesce(scep.fecha_inicio_dictado, spl.fecha_inicio_dictado) and coalesce(scep.fecha_fin_dictado, spl.fecha_fin_dictado) |
|
|
and (sc.turno is null or sc.turno = (select turno |
|
|
from sga_comisiones sc |
|
|
join sga_comisiones_bh scb ON sc.comision = scb.comision |
|
|
join sga_clases scl ON scb.banda_horaria = scl.banda_horaria and clase= '9718')) |
|
|
and exists (select '' from sga_insc_cursada sic where sic.comision =sc.comision and alumno = '58' ) |
|
|
) |
|
|
) |
|
|
and fecha = (select fecha from sga_clases where clase = '9718') |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 9718 and alumno = '58' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 9718, '58', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 10087 and alumno = '58' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 10087, '58', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 12670 and alumno = '58' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 12670, '58', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 13039 and alumno = '58' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 13039, '58', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 17180 and alumno = '58' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 17180, '58', '0', null, 'A') |
|
|
|
|
|
-- DATOS --------------------------------------------------------------------- |
|
|
|
|
|
1 |
|
|
|
|
|
-- CATALOGO: carga_asistencias/guardar | cache [false] - tipo [no] ----------- |
|
|
|
|
|
Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[alumno] => '59' |
|
|
[clase] => '9718' |
|
|
[motivo] => |
|
|
[cantidad] => '0' |
|
|
) |
|
|
|
|
|
[metadata] => Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[0] => alumno |
|
|
[1] => clase |
|
|
[2] => cantidad |
|
|
[3] => motivo |
|
|
) |
|
|
|
|
|
[param_null] => Array |
|
|
( |
|
|
[0] => motivo |
|
|
) |
|
|
|
|
|
[cache] => no |
|
|
[filas] => 1 |
|
|
) |
|
|
|
|
|
[force_cache] => Array |
|
|
( |
|
|
) |
|
|
|
|
|
) |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
|
|
|
SELECT cant_inasistencias, motivo_ausencia |
|
|
FROM sga_clases_asistencia |
|
|
WHERE clase = '9718' |
|
|
AND alumno = '59' |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select clase from sga_clases where banda_horaria in ( |
|
|
select banda_horaria from sga_comisiones_bh where comision in ( |
|
|
select sc.comision |
|
|
from sga_comisiones sc |
|
|
join sga_periodos_lectivos spl ON sc.periodo_lectivo = spl.periodo_lectivo |
|
|
left join sga_comisiones_excep_perlect scep ON sc.comision = scep.comision |
|
|
where (sc.division is null or sc.division in ( |
|
|
select division from sga_alumnos sa where alumno = '59' |
|
|
)) |
|
|
and (select fecha from sga_clases where clase = '9718') between coalesce(scep.fecha_inicio_dictado, spl.fecha_inicio_dictado) and coalesce(scep.fecha_fin_dictado, spl.fecha_fin_dictado) |
|
|
and (sc.turno is null or sc.turno = (select turno |
|
|
from sga_comisiones sc |
|
|
join sga_comisiones_bh scb ON sc.comision = scb.comision |
|
|
join sga_clases scl ON scb.banda_horaria = scl.banda_horaria and clase= '9718')) |
|
|
and exists (select '' from sga_insc_cursada sic where sic.comision =sc.comision and alumno = '59' ) |
|
|
) |
|
|
) |
|
|
and fecha = (select fecha from sga_clases where clase = '9718') |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 9718 and alumno = '59' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 9718, '59', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 10087 and alumno = '59' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 10087, '59', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 12670 and alumno = '59' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 12670, '59', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 13039 and alumno = '59' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 13039, '59', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 17180 and alumno = '59' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 17180, '59', '0', null, 'A') |
|
|
|
|
|
-- DATOS --------------------------------------------------------------------- |
|
|
|
|
|
1 |
|
|
|
|
|
-- CATALOGO: carga_asistencias/guardar | cache [false] - tipo [no] ----------- |
|
|
|
|
|
Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[alumno] => '60' |
|
|
[clase] => '9718' |
|
|
[motivo] => |
|
|
[cantidad] => '0' |
|
|
) |
|
|
|
|
|
[metadata] => Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[0] => alumno |
|
|
[1] => clase |
|
|
[2] => cantidad |
|
|
[3] => motivo |
|
|
) |
|
|
|
|
|
[param_null] => Array |
|
|
( |
|
|
[0] => motivo |
|
|
) |
|
|
|
|
|
[cache] => no |
|
|
[filas] => 1 |
|
|
) |
|
|
|
|
|
[force_cache] => Array |
|
|
( |
|
|
) |
|
|
|
|
|
) |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
|
|
|
SELECT cant_inasistencias, motivo_ausencia |
|
|
FROM sga_clases_asistencia |
|
|
WHERE clase = '9718' |
|
|
AND alumno = '60' |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select clase from sga_clases where banda_horaria in ( |
|
|
select banda_horaria from sga_comisiones_bh where comision in ( |
|
|
select sc.comision |
|
|
from sga_comisiones sc |
|
|
join sga_periodos_lectivos spl ON sc.periodo_lectivo = spl.periodo_lectivo |
|
|
left join sga_comisiones_excep_perlect scep ON sc.comision = scep.comision |
|
|
where (sc.division is null or sc.division in ( |
|
|
select division from sga_alumnos sa where alumno = '60' |
|
|
)) |
|
|
and (select fecha from sga_clases where clase = '9718') between coalesce(scep.fecha_inicio_dictado, spl.fecha_inicio_dictado) and coalesce(scep.fecha_fin_dictado, spl.fecha_fin_dictado) |
|
|
and (sc.turno is null or sc.turno = (select turno |
|
|
from sga_comisiones sc |
|
|
join sga_comisiones_bh scb ON sc.comision = scb.comision |
|
|
join sga_clases scl ON scb.banda_horaria = scl.banda_horaria and clase= '9718')) |
|
|
and exists (select '' from sga_insc_cursada sic where sic.comision =sc.comision and alumno = '60' ) |
|
|
) |
|
|
) |
|
|
and fecha = (select fecha from sga_clases where clase = '9718') |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 9718 and alumno = '60' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 9718, '60', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 10087 and alumno = '60' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 10087, '60', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 12670 and alumno = '60' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 12670, '60', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 13039 and alumno = '60' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 13039, '60', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 17180 and alumno = '60' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 17180, '60', '0', null, 'A') |
|
|
|
|
|
-- DATOS --------------------------------------------------------------------- |
|
|
|
|
|
1 |
|
|
|
|
|
-- CATALOGO: carga_asistencias/guardar | cache [false] - tipo [no] ----------- |
|
|
|
|
|
Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[alumno] => '61' |
|
|
[clase] => '9718' |
|
|
[motivo] => |
|
|
[cantidad] => '0' |
|
|
) |
|
|
|
|
|
[metadata] => Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[0] => alumno |
|
|
[1] => clase |
|
|
[2] => cantidad |
|
|
[3] => motivo |
|
|
) |
|
|
|
|
|
[param_null] => Array |
|
|
( |
|
|
[0] => motivo |
|
|
) |
|
|
|
|
|
[cache] => no |
|
|
[filas] => 1 |
|
|
) |
|
|
|
|
|
[force_cache] => Array |
|
|
( |
|
|
) |
|
|
|
|
|
) |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
|
|
|
SELECT cant_inasistencias, motivo_ausencia |
|
|
FROM sga_clases_asistencia |
|
|
WHERE clase = '9718' |
|
|
AND alumno = '61' |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select clase from sga_clases where banda_horaria in ( |
|
|
select banda_horaria from sga_comisiones_bh where comision in ( |
|
|
select sc.comision |
|
|
from sga_comisiones sc |
|
|
join sga_periodos_lectivos spl ON sc.periodo_lectivo = spl.periodo_lectivo |
|
|
left join sga_comisiones_excep_perlect scep ON sc.comision = scep.comision |
|
|
where (sc.division is null or sc.division in ( |
|
|
select division from sga_alumnos sa where alumno = '61' |
|
|
)) |
|
|
and (select fecha from sga_clases where clase = '9718') between coalesce(scep.fecha_inicio_dictado, spl.fecha_inicio_dictado) and coalesce(scep.fecha_fin_dictado, spl.fecha_fin_dictado) |
|
|
and (sc.turno is null or sc.turno = (select turno |
|
|
from sga_comisiones sc |
|
|
join sga_comisiones_bh scb ON sc.comision = scb.comision |
|
|
join sga_clases scl ON scb.banda_horaria = scl.banda_horaria and clase= '9718')) |
|
|
and exists (select '' from sga_insc_cursada sic where sic.comision =sc.comision and alumno = '61' ) |
|
|
) |
|
|
) |
|
|
and fecha = (select fecha from sga_clases where clase = '9718') |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 9718 and alumno = '61' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 9718, '61', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 10087 and alumno = '61' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 10087, '61', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 12670 and alumno = '61' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 12670, '61', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 13039 and alumno = '61' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 13039, '61', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 17180 and alumno = '61' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 17180, '61', '0', null, 'A') |
|
|
|
|
|
-- DATOS --------------------------------------------------------------------- |
|
|
|
|
|
1 |
|
|
|
|
|
-- CATALOGO: carga_asistencias/guardar | cache [false] - tipo [no] ----------- |
|
|
|
|
|
Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[alumno] => '213' |
|
|
[clase] => '9718' |
|
|
[motivo] => |
|
|
[cantidad] => '0' |
|
|
) |
|
|
|
|
|
[metadata] => Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[0] => alumno |
|
|
[1] => clase |
|
|
[2] => cantidad |
|
|
[3] => motivo |
|
|
) |
|
|
|
|
|
[param_null] => Array |
|
|
( |
|
|
[0] => motivo |
|
|
) |
|
|
|
|
|
[cache] => no |
|
|
[filas] => 1 |
|
|
) |
|
|
|
|
|
[force_cache] => Array |
|
|
( |
|
|
) |
|
|
|
|
|
) |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
|
|
|
SELECT cant_inasistencias, motivo_ausencia |
|
|
FROM sga_clases_asistencia |
|
|
WHERE clase = '9718' |
|
|
AND alumno = '213' |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select clase from sga_clases where banda_horaria in ( |
|
|
select banda_horaria from sga_comisiones_bh where comision in ( |
|
|
select sc.comision |
|
|
from sga_comisiones sc |
|
|
join sga_periodos_lectivos spl ON sc.periodo_lectivo = spl.periodo_lectivo |
|
|
left join sga_comisiones_excep_perlect scep ON sc.comision = scep.comision |
|
|
where (sc.division is null or sc.division in ( |
|
|
select division from sga_alumnos sa where alumno = '213' |
|
|
)) |
|
|
and (select fecha from sga_clases where clase = '9718') between coalesce(scep.fecha_inicio_dictado, spl.fecha_inicio_dictado) and coalesce(scep.fecha_fin_dictado, spl.fecha_fin_dictado) |
|
|
and (sc.turno is null or sc.turno = (select turno |
|
|
from sga_comisiones sc |
|
|
join sga_comisiones_bh scb ON sc.comision = scb.comision |
|
|
join sga_clases scl ON scb.banda_horaria = scl.banda_horaria and clase= '9718')) |
|
|
and exists (select '' from sga_insc_cursada sic where sic.comision =sc.comision and alumno = '213' ) |
|
|
) |
|
|
) |
|
|
and fecha = (select fecha from sga_clases where clase = '9718') |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 9718 and alumno = '213' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 9718, '213', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 10087 and alumno = '213' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 10087, '213', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 12670 and alumno = '213' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 12670, '213', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 13039 and alumno = '213' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 13039, '213', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 17180 and alumno = '213' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 17180, '213', '0', null, 'A') |
|
|
|
|
|
-- DATOS --------------------------------------------------------------------- |
|
|
|
|
|
1 |
|
|
|
|
|
-- CATALOGO: carga_asistencias/guardar | cache [false] - tipo [no] ----------- |
|
|
|
|
|
Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[alumno] => '208' |
|
|
[clase] => '9718' |
|
|
[motivo] => |
|
|
[cantidad] => '0' |
|
|
) |
|
|
|
|
|
[metadata] => Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[0] => alumno |
|
|
[1] => clase |
|
|
[2] => cantidad |
|
|
[3] => motivo |
|
|
) |
|
|
|
|
|
[param_null] => Array |
|
|
( |
|
|
[0] => motivo |
|
|
) |
|
|
|
|
|
[cache] => no |
|
|
[filas] => 1 |
|
|
) |
|
|
|
|
|
[force_cache] => Array |
|
|
( |
|
|
) |
|
|
|
|
|
) |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
|
|
|
SELECT cant_inasistencias, motivo_ausencia |
|
|
FROM sga_clases_asistencia |
|
|
WHERE clase = '9718' |
|
|
AND alumno = '208' |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select clase from sga_clases where banda_horaria in ( |
|
|
select banda_horaria from sga_comisiones_bh where comision in ( |
|
|
select sc.comision |
|
|
from sga_comisiones sc |
|
|
join sga_periodos_lectivos spl ON sc.periodo_lectivo = spl.periodo_lectivo |
|
|
left join sga_comisiones_excep_perlect scep ON sc.comision = scep.comision |
|
|
where (sc.division is null or sc.division in ( |
|
|
select division from sga_alumnos sa where alumno = '208' |
|
|
)) |
|
|
and (select fecha from sga_clases where clase = '9718') between coalesce(scep.fecha_inicio_dictado, spl.fecha_inicio_dictado) and coalesce(scep.fecha_fin_dictado, spl.fecha_fin_dictado) |
|
|
and (sc.turno is null or sc.turno = (select turno |
|
|
from sga_comisiones sc |
|
|
join sga_comisiones_bh scb ON sc.comision = scb.comision |
|
|
join sga_clases scl ON scb.banda_horaria = scl.banda_horaria and clase= '9718')) |
|
|
and exists (select '' from sga_insc_cursada sic where sic.comision =sc.comision and alumno = '208' ) |
|
|
) |
|
|
) |
|
|
and fecha = (select fecha from sga_clases where clase = '9718') |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 9718 and alumno = '208' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 9718, '208', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 10087 and alumno = '208' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 10087, '208', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 12670 and alumno = '208' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 12670, '208', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 13039 and alumno = '208' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 13039, '208', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 17180 and alumno = '208' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 17180, '208', '0', null, 'A') |
|
|
|
|
|
-- DATOS --------------------------------------------------------------------- |
|
|
|
|
|
1 |
|
|
|
|
|
-- CATALOGO: carga_asistencias/guardar | cache [false] - tipo [no] ----------- |
|
|
|
|
|
Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[alumno] => '209' |
|
|
[clase] => '9718' |
|
|
[motivo] => |
|
|
[cantidad] => '0' |
|
|
) |
|
|
|
|
|
[metadata] => Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[0] => alumno |
|
|
[1] => clase |
|
|
[2] => cantidad |
|
|
[3] => motivo |
|
|
) |
|
|
|
|
|
[param_null] => Array |
|
|
( |
|
|
[0] => motivo |
|
|
) |
|
|
|
|
|
[cache] => no |
|
|
[filas] => 1 |
|
|
) |
|
|
|
|
|
[force_cache] => Array |
|
|
( |
|
|
) |
|
|
|
|
|
) |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
|
|
|
SELECT cant_inasistencias, motivo_ausencia |
|
|
FROM sga_clases_asistencia |
|
|
WHERE clase = '9718' |
|
|
AND alumno = '209' |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select clase from sga_clases where banda_horaria in ( |
|
|
select banda_horaria from sga_comisiones_bh where comision in ( |
|
|
select sc.comision |
|
|
from sga_comisiones sc |
|
|
join sga_periodos_lectivos spl ON sc.periodo_lectivo = spl.periodo_lectivo |
|
|
left join sga_comisiones_excep_perlect scep ON sc.comision = scep.comision |
|
|
where (sc.division is null or sc.division in ( |
|
|
select division from sga_alumnos sa where alumno = '209' |
|
|
)) |
|
|
and (select fecha from sga_clases where clase = '9718') between coalesce(scep.fecha_inicio_dictado, spl.fecha_inicio_dictado) and coalesce(scep.fecha_fin_dictado, spl.fecha_fin_dictado) |
|
|
and (sc.turno is null or sc.turno = (select turno |
|
|
from sga_comisiones sc |
|
|
join sga_comisiones_bh scb ON sc.comision = scb.comision |
|
|
join sga_clases scl ON scb.banda_horaria = scl.banda_horaria and clase= '9718')) |
|
|
and exists (select '' from sga_insc_cursada sic where sic.comision =sc.comision and alumno = '209' ) |
|
|
) |
|
|
) |
|
|
and fecha = (select fecha from sga_clases where clase = '9718') |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 9718 and alumno = '209' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 9718, '209', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 10087 and alumno = '209' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 10087, '209', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 12670 and alumno = '209' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 12670, '209', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 13039 and alumno = '209' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 13039, '209', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 17180 and alumno = '209' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 17180, '209', '0', null, 'A') |
|
|
|
|
|
-- DATOS --------------------------------------------------------------------- |
|
|
|
|
|
1 |
|
|
|
|
|
-- CATALOGO: carga_asistencias/guardar | cache [false] - tipo [no] ----------- |
|
|
|
|
|
Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[alumno] => '210' |
|
|
[clase] => '9718' |
|
|
[motivo] => |
|
|
[cantidad] => '0' |
|
|
) |
|
|
|
|
|
[metadata] => Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[0] => alumno |
|
|
[1] => clase |
|
|
[2] => cantidad |
|
|
[3] => motivo |
|
|
) |
|
|
|
|
|
[param_null] => Array |
|
|
( |
|
|
[0] => motivo |
|
|
) |
|
|
|
|
|
[cache] => no |
|
|
[filas] => 1 |
|
|
) |
|
|
|
|
|
[force_cache] => Array |
|
|
( |
|
|
) |
|
|
|
|
|
) |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
|
|
|
SELECT cant_inasistencias, motivo_ausencia |
|
|
FROM sga_clases_asistencia |
|
|
WHERE clase = '9718' |
|
|
AND alumno = '210' |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select clase from sga_clases where banda_horaria in ( |
|
|
select banda_horaria from sga_comisiones_bh where comision in ( |
|
|
select sc.comision |
|
|
from sga_comisiones sc |
|
|
join sga_periodos_lectivos spl ON sc.periodo_lectivo = spl.periodo_lectivo |
|
|
left join sga_comisiones_excep_perlect scep ON sc.comision = scep.comision |
|
|
where (sc.division is null or sc.division in ( |
|
|
select division from sga_alumnos sa where alumno = '210' |
|
|
)) |
|
|
and (select fecha from sga_clases where clase = '9718') between coalesce(scep.fecha_inicio_dictado, spl.fecha_inicio_dictado) and coalesce(scep.fecha_fin_dictado, spl.fecha_fin_dictado) |
|
|
and (sc.turno is null or sc.turno = (select turno |
|
|
from sga_comisiones sc |
|
|
join sga_comisiones_bh scb ON sc.comision = scb.comision |
|
|
join sga_clases scl ON scb.banda_horaria = scl.banda_horaria and clase= '9718')) |
|
|
and exists (select '' from sga_insc_cursada sic where sic.comision =sc.comision and alumno = '210' ) |
|
|
) |
|
|
) |
|
|
and fecha = (select fecha from sga_clases where clase = '9718') |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 9718 and alumno = '210' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 9718, '210', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 10087 and alumno = '210' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 10087, '210', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 12670 and alumno = '210' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 12670, '210', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 13039 and alumno = '210' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 13039, '210', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 17180 and alumno = '210' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 17180, '210', '0', null, 'A') |
|
|
|
|
|
-- DATOS --------------------------------------------------------------------- |
|
|
|
|
|
1 |
|
|
|
|
|
-- CATALOGO: carga_asistencias/guardar | cache [false] - tipo [no] ----------- |
|
|
|
|
|
Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[alumno] => '211' |
|
|
[clase] => '9718' |
|
|
[motivo] => |
|
|
[cantidad] => '0' |
|
|
) |
|
|
|
|
|
[metadata] => Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[0] => alumno |
|
|
[1] => clase |
|
|
[2] => cantidad |
|
|
[3] => motivo |
|
|
) |
|
|
|
|
|
[param_null] => Array |
|
|
( |
|
|
[0] => motivo |
|
|
) |
|
|
|
|
|
[cache] => no |
|
|
[filas] => 1 |
|
|
) |
|
|
|
|
|
[force_cache] => Array |
|
|
( |
|
|
) |
|
|
|
|
|
) |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
|
|
|
SELECT cant_inasistencias, motivo_ausencia |
|
|
FROM sga_clases_asistencia |
|
|
WHERE clase = '9718' |
|
|
AND alumno = '211' |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select clase from sga_clases where banda_horaria in ( |
|
|
select banda_horaria from sga_comisiones_bh where comision in ( |
|
|
select sc.comision |
|
|
from sga_comisiones sc |
|
|
join sga_periodos_lectivos spl ON sc.periodo_lectivo = spl.periodo_lectivo |
|
|
left join sga_comisiones_excep_perlect scep ON sc.comision = scep.comision |
|
|
where (sc.division is null or sc.division in ( |
|
|
select division from sga_alumnos sa where alumno = '211' |
|
|
)) |
|
|
and (select fecha from sga_clases where clase = '9718') between coalesce(scep.fecha_inicio_dictado, spl.fecha_inicio_dictado) and coalesce(scep.fecha_fin_dictado, spl.fecha_fin_dictado) |
|
|
and (sc.turno is null or sc.turno = (select turno |
|
|
from sga_comisiones sc |
|
|
join sga_comisiones_bh scb ON sc.comision = scb.comision |
|
|
join sga_clases scl ON scb.banda_horaria = scl.banda_horaria and clase= '9718')) |
|
|
and exists (select '' from sga_insc_cursada sic where sic.comision =sc.comision and alumno = '211' ) |
|
|
) |
|
|
) |
|
|
and fecha = (select fecha from sga_clases where clase = '9718') |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 9718 and alumno = '211' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 9718, '211', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 10087 and alumno = '211' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 10087, '211', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 12670 and alumno = '211' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 12670, '211', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 13039 and alumno = '211' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 13039, '211', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 17180 and alumno = '211' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 17180, '211', '0', null, 'A') |
|
|
|
|
|
-- DATOS --------------------------------------------------------------------- |
|
|
|
|
|
1 |
|
|
|
|
|
-- CATALOGO: carga_asistencias/guardar | cache [false] - tipo [no] ----------- |
|
|
|
|
|
Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[alumno] => '212' |
|
|
[clase] => '9718' |
|
|
[motivo] => |
|
|
[cantidad] => '0' |
|
|
) |
|
|
|
|
|
[metadata] => Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[0] => alumno |
|
|
[1] => clase |
|
|
[2] => cantidad |
|
|
[3] => motivo |
|
|
) |
|
|
|
|
|
[param_null] => Array |
|
|
( |
|
|
[0] => motivo |
|
|
) |
|
|
|
|
|
[cache] => no |
|
|
[filas] => 1 |
|
|
) |
|
|
|
|
|
[force_cache] => Array |
|
|
( |
|
|
) |
|
|
|
|
|
) |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
|
|
|
SELECT cant_inasistencias, motivo_ausencia |
|
|
FROM sga_clases_asistencia |
|
|
WHERE clase = '9718' |
|
|
AND alumno = '212' |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select clase from sga_clases where banda_horaria in ( |
|
|
select banda_horaria from sga_comisiones_bh where comision in ( |
|
|
select sc.comision |
|
|
from sga_comisiones sc |
|
|
join sga_periodos_lectivos spl ON sc.periodo_lectivo = spl.periodo_lectivo |
|
|
left join sga_comisiones_excep_perlect scep ON sc.comision = scep.comision |
|
|
where (sc.division is null or sc.division in ( |
|
|
select division from sga_alumnos sa where alumno = '212' |
|
|
)) |
|
|
and (select fecha from sga_clases where clase = '9718') between coalesce(scep.fecha_inicio_dictado, spl.fecha_inicio_dictado) and coalesce(scep.fecha_fin_dictado, spl.fecha_fin_dictado) |
|
|
and (sc.turno is null or sc.turno = (select turno |
|
|
from sga_comisiones sc |
|
|
join sga_comisiones_bh scb ON sc.comision = scb.comision |
|
|
join sga_clases scl ON scb.banda_horaria = scl.banda_horaria and clase= '9718')) |
|
|
and exists (select '' from sga_insc_cursada sic where sic.comision =sc.comision and alumno = '212' ) |
|
|
) |
|
|
) |
|
|
and fecha = (select fecha from sga_clases where clase = '9718') |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 9718 and alumno = '212' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 9718, '212', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 10087 and alumno = '212' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 10087, '212', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 12670 and alumno = '212' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 12670, '212', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 13039 and alumno = '212' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 13039, '212', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 17180 and alumno = '212' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 17180, '212', '0', null, 'A') |
|
|
|
|
|
-- DATOS --------------------------------------------------------------------- |
|
|
|
|
|
1 |
|
|
|
|
|
-- CATALOGO: carga_asistencias/guardar | cache [false] - tipo [no] ----------- |
|
|
|
|
|
Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[alumno] => '129' |
|
|
[clase] => '9718' |
|
|
[motivo] => |
|
|
[cantidad] => '0' |
|
|
) |
|
|
|
|
|
[metadata] => Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[0] => alumno |
|
|
[1] => clase |
|
|
[2] => cantidad |
|
|
[3] => motivo |
|
|
) |
|
|
|
|
|
[param_null] => Array |
|
|
( |
|
|
[0] => motivo |
|
|
) |
|
|
|
|
|
[cache] => no |
|
|
[filas] => 1 |
|
|
) |
|
|
|
|
|
[force_cache] => Array |
|
|
( |
|
|
) |
|
|
|
|
|
) |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
|
|
|
SELECT cant_inasistencias, motivo_ausencia |
|
|
FROM sga_clases_asistencia |
|
|
WHERE clase = '9718' |
|
|
AND alumno = '129' |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select clase from sga_clases where banda_horaria in ( |
|
|
select banda_horaria from sga_comisiones_bh where comision in ( |
|
|
select sc.comision |
|
|
from sga_comisiones sc |
|
|
join sga_periodos_lectivos spl ON sc.periodo_lectivo = spl.periodo_lectivo |
|
|
left join sga_comisiones_excep_perlect scep ON sc.comision = scep.comision |
|
|
where (sc.division is null or sc.division in ( |
|
|
select division from sga_alumnos sa where alumno = '129' |
|
|
)) |
|
|
and (select fecha from sga_clases where clase = '9718') between coalesce(scep.fecha_inicio_dictado, spl.fecha_inicio_dictado) and coalesce(scep.fecha_fin_dictado, spl.fecha_fin_dictado) |
|
|
and (sc.turno is null or sc.turno = (select turno |
|
|
from sga_comisiones sc |
|
|
join sga_comisiones_bh scb ON sc.comision = scb.comision |
|
|
join sga_clases scl ON scb.banda_horaria = scl.banda_horaria and clase= '9718')) |
|
|
and exists (select '' from sga_insc_cursada sic where sic.comision =sc.comision and alumno = '129' ) |
|
|
) |
|
|
) |
|
|
and fecha = (select fecha from sga_clases where clase = '9718') |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 9718 and alumno = '129' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 9718, '129', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 10087 and alumno = '129' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 10087, '129', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 12670 and alumno = '129' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 12670, '129', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 13039 and alumno = '129' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 13039, '129', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 17180 and alumno = '129' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 17180, '129', '0', null, 'A') |
|
|
|
|
|
-- DATOS --------------------------------------------------------------------- |
|
|
|
|
|
1 |
|
|
|
|
|
-- CATALOGO: carga_asistencias/guardar | cache [false] - tipo [no] ----------- |
|
|
|
|
|
Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[alumno] => '62' |
|
|
[clase] => '9718' |
|
|
[motivo] => |
|
|
[cantidad] => '0' |
|
|
) |
|
|
|
|
|
[metadata] => Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[0] => alumno |
|
|
[1] => clase |
|
|
[2] => cantidad |
|
|
[3] => motivo |
|
|
) |
|
|
|
|
|
[param_null] => Array |
|
|
( |
|
|
[0] => motivo |
|
|
) |
|
|
|
|
|
[cache] => no |
|
|
[filas] => 1 |
|
|
) |
|
|
|
|
|
[force_cache] => Array |
|
|
( |
|
|
) |
|
|
|
|
|
) |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
|
|
|
SELECT cant_inasistencias, motivo_ausencia |
|
|
FROM sga_clases_asistencia |
|
|
WHERE clase = '9718' |
|
|
AND alumno = '62' |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select clase from sga_clases where banda_horaria in ( |
|
|
select banda_horaria from sga_comisiones_bh where comision in ( |
|
|
select sc.comision |
|
|
from sga_comisiones sc |
|
|
join sga_periodos_lectivos spl ON sc.periodo_lectivo = spl.periodo_lectivo |
|
|
left join sga_comisiones_excep_perlect scep ON sc.comision = scep.comision |
|
|
where (sc.division is null or sc.division in ( |
|
|
select division from sga_alumnos sa where alumno = '62' |
|
|
)) |
|
|
and (select fecha from sga_clases where clase = '9718') between coalesce(scep.fecha_inicio_dictado, spl.fecha_inicio_dictado) and coalesce(scep.fecha_fin_dictado, spl.fecha_fin_dictado) |
|
|
and (sc.turno is null or sc.turno = (select turno |
|
|
from sga_comisiones sc |
|
|
join sga_comisiones_bh scb ON sc.comision = scb.comision |
|
|
join sga_clases scl ON scb.banda_horaria = scl.banda_horaria and clase= '9718')) |
|
|
and exists (select '' from sga_insc_cursada sic where sic.comision =sc.comision and alumno = '62' ) |
|
|
) |
|
|
) |
|
|
and fecha = (select fecha from sga_clases where clase = '9718') |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 9718 and alumno = '62' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 9718, '62', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 10087 and alumno = '62' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 10087, '62', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 12670 and alumno = '62' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 12670, '62', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 13039 and alumno = '62' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 13039, '62', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 17180 and alumno = '62' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 17180, '62', '0', null, 'A') |
|
|
|
|
|
-- DATOS --------------------------------------------------------------------- |
|
|
|
|
|
1 |
|
|
|
|
|
-- CATALOGO: carga_asistencias/guardar | cache [false] - tipo [no] ----------- |
|
|
|
|
|
Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[alumno] => '63' |
|
|
[clase] => '9718' |
|
|
[motivo] => |
|
|
[cantidad] => '0' |
|
|
) |
|
|
|
|
|
[metadata] => Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[0] => alumno |
|
|
[1] => clase |
|
|
[2] => cantidad |
|
|
[3] => motivo |
|
|
) |
|
|
|
|
|
[param_null] => Array |
|
|
( |
|
|
[0] => motivo |
|
|
) |
|
|
|
|
|
[cache] => no |
|
|
[filas] => 1 |
|
|
) |
|
|
|
|
|
[force_cache] => Array |
|
|
( |
|
|
) |
|
|
|
|
|
) |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
|
|
|
SELECT cant_inasistencias, motivo_ausencia |
|
|
FROM sga_clases_asistencia |
|
|
WHERE clase = '9718' |
|
|
AND alumno = '63' |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select clase from sga_clases where banda_horaria in ( |
|
|
select banda_horaria from sga_comisiones_bh where comision in ( |
|
|
select sc.comision |
|
|
from sga_comisiones sc |
|
|
join sga_periodos_lectivos spl ON sc.periodo_lectivo = spl.periodo_lectivo |
|
|
left join sga_comisiones_excep_perlect scep ON sc.comision = scep.comision |
|
|
where (sc.division is null or sc.division in ( |
|
|
select division from sga_alumnos sa where alumno = '63' |
|
|
)) |
|
|
and (select fecha from sga_clases where clase = '9718') between coalesce(scep.fecha_inicio_dictado, spl.fecha_inicio_dictado) and coalesce(scep.fecha_fin_dictado, spl.fecha_fin_dictado) |
|
|
and (sc.turno is null or sc.turno = (select turno |
|
|
from sga_comisiones sc |
|
|
join sga_comisiones_bh scb ON sc.comision = scb.comision |
|
|
join sga_clases scl ON scb.banda_horaria = scl.banda_horaria and clase= '9718')) |
|
|
and exists (select '' from sga_insc_cursada sic where sic.comision =sc.comision and alumno = '63' ) |
|
|
) |
|
|
) |
|
|
and fecha = (select fecha from sga_clases where clase = '9718') |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 9718 and alumno = '63' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 9718, '63', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 10087 and alumno = '63' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 10087, '63', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 12670 and alumno = '63' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 12670, '63', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 13039 and alumno = '63' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 13039, '63', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 17180 and alumno = '63' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 17180, '63', '0', null, 'A') |
|
|
|
|
|
-- DATOS --------------------------------------------------------------------- |
|
|
|
|
|
1 |
|
|
|
|
|
-- CATALOGO: carga_asistencias/guardar | cache [false] - tipo [no] ----------- |
|
|
|
|
|
Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[alumno] => '64' |
|
|
[clase] => '9718' |
|
|
[motivo] => |
|
|
[cantidad] => '0' |
|
|
) |
|
|
|
|
|
[metadata] => Array |
|
|
( |
|
|
[parametros] => Array |
|
|
( |
|
|
[0] => alumno |
|
|
[1] => clase |
|
|
[2] => cantidad |
|
|
[3] => motivo |
|
|
) |
|
|
|
|
|
[param_null] => Array |
|
|
( |
|
|
[0] => motivo |
|
|
) |
|
|
|
|
|
[cache] => no |
|
|
[filas] => 1 |
|
|
) |
|
|
|
|
|
[force_cache] => Array |
|
|
( |
|
|
) |
|
|
|
|
|
) |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
|
|
|
SELECT cant_inasistencias, motivo_ausencia |
|
|
FROM sga_clases_asistencia |
|
|
WHERE clase = '9718' |
|
|
AND alumno = '64' |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select clase from sga_clases where banda_horaria in ( |
|
|
select banda_horaria from sga_comisiones_bh where comision in ( |
|
|
select sc.comision |
|
|
from sga_comisiones sc |
|
|
join sga_periodos_lectivos spl ON sc.periodo_lectivo = spl.periodo_lectivo |
|
|
left join sga_comisiones_excep_perlect scep ON sc.comision = scep.comision |
|
|
where (sc.division is null or sc.division in ( |
|
|
select division from sga_alumnos sa where alumno = '64' |
|
|
)) |
|
|
and (select fecha from sga_clases where clase = '9718') between coalesce(scep.fecha_inicio_dictado, spl.fecha_inicio_dictado) and coalesce(scep.fecha_fin_dictado, spl.fecha_fin_dictado) |
|
|
and (sc.turno is null or sc.turno = (select turno |
|
|
from sga_comisiones sc |
|
|
join sga_comisiones_bh scb ON sc.comision = scb.comision |
|
|
join sga_clases scl ON scb.banda_horaria = scl.banda_horaria and clase= '9718')) |
|
|
and exists (select '' from sga_insc_cursada sic where sic.comision =sc.comision and alumno = '64' ) |
|
|
) |
|
|
) |
|
|
and fecha = (select fecha from sga_clases where clase = '9718') |
|
|
|
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 9718 and alumno = '64' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 9718, '64', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 10087 and alumno = '64' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 10087, '64', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 12670 and alumno = '64' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 12670, '64', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 13039 and alumno = '64' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 13039, '64', '0', null, 'A') |
|
|
|
|
|
-- SQL ----------------------------------------------------------------------- |
|
|
|
|
|
select 1 from sga_clases_asistencia where clase = 17180 and alumno = '64' |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
INSERT INTO sga_clases_asistencia (clase, alumno, cant_inasistencias, motivo_ausencia, estado) |
|
|
values ( 17180, '64', '0', null, 'A') |
|
|
|
|
|
-- DATOS --------------------------------------------------------------------- |
|
|
|
|
|
1 |
|
|
|
|
|
-- sql ----------------------------------------------------------------------- |
|
|
|
|
|
COMMIT WORK |
|
|
|
|
|
-- CERRAR transaccion -------------------------------------------------------- |
|
|
|
|
|
base: toba_3_3 |
|
|
|
|
|
--F<1>:E<0>:W<0>:T<0.331 s>:M<1.54 Mb>-- |
|
|
--REXCAT_C<sistema>MET<version_base_g3>MED<memoria>A<leer>T<0.000>-- |
|
|
--REXCAT_C<persona>MET<datos_basicos>MED<sesion>A<leer>T<0.000>-- |
|
|
--REXCAT_C<persona>MET<perfiles>MED<sesion>A<leer>T<0.000>-- |
|
|
--REXCAT_C<persona>MET<carreras>MED<sesion>A<leer>T<0.000>-- |
|
|
--REXCAT_C<persona>MET<configuracion>MED<db>A<leer>T<0.004>-- |
|
|
--REXCAT_C<persona>MET<configuracion>MED<memoria>A<guardar>T<0.000>-- |
|
|
--REXCAT_C<docente>MET<lista_comisiones>MED<db>A<leer>T<0.024>-- |
|
|
--REXCAT_C<derecho_entidades>MET<tiene_derecho_comisiones>MED<db>A<leer>T<0.001>-- |
|
|
--REXCAT_C<zona_clases>MET<get_propuesta>MED<db>A<leer>T<0.000>-- |
|
|
--REXCAT_C<carga_asistencias>MET<tipo_asistencia>MED<memoria>A<leer>T<0.000>-- |
|
|
--REXCAT_C<carga_asistencias>MET<clase_cabecera>MED<db>A<leer>T<0.009>-- |
|
|
--REXCAT_C<carga_asistencias>MET<clase_detalle>MED<db>A<leer>T<0.007>-- |
|
|
--REXCAT_C<carga_asistencias>MET<guardar>MED<db>A<leer>T<0.082>-- |
|
|
--REXCAT_C<carga_asistencias>MET<guardar>MED<db>A<leer>T<0.008>-- |
|
|
--REXCAT_C<carga_asistencias>MET<guardar>MED<db>A<leer>T<0.014>-- |
|
|
--REXCAT_C<carga_asistencias>MET<guardar>MED<db>A<leer>T<0.007>-- |
|
|
--REXCAT_C<carga_asistencias>MET<guardar>MED<db>A<leer>T<0.006>-- |
|
|
--REXCAT_C<carga_asistencias>MET<guardar>MED<db>A<leer>T<0.006>-- |
|
|
--REXCAT_C<carga_asistencias>MET<guardar>MED<db>A<leer>T<0.006>-- |
|
|
--REXCAT_C<carga_asistencias>MET<guardar>MED<db>A<leer>T<0.006>-- |
|
|
--REXCAT_C<carga_asistencias>MET<guardar>MED<db>A<leer>T<0.006>-- |
|
|
--REXCAT_C<carga_asistencias>MET<guardar>MED<db>A<leer>T<0.006>-- |
|
|
--REXCAT_C<carga_asistencias>MET<guardar>MED<db>A<leer>T<0.006>-- |
|
|
--REXCAT_C<carga_asistencias>MET<guardar>MED<db>A<leer>T<0.006>-- |
|
|
--REXCAT_C<carga_asistencias>MET<guardar>MED<db>A<leer>T<0.006>-- |
|
|
--REXCAT_C<carga_asistencias>MET<guardar>MED<db>A<leer>T<0.006>-- |
|
|
--REXCAT_C<carga_asistencias>MET<guardar>MED<db>A<leer>T<0.006>-- |
|
|
--REXCAT_C<carga_asistencias>MET<guardar>MED<db>A<leer>T<0.006>-- |
|
|
--REXCAT_C<carga_asistencias>MET<guardar>MED<db>A<leer>T<0.006>-- |
|
|
--REXCAT_C<carga_asistencias>MET<guardar>MED<db>A<leer>T<0.006>-- |
|
|
--REXCAT_C<carga_asistencias>MET<guardar>MED<db>A<leer>T<0.006>-- |
|
|
--REXCAT_C<carga_asistencias>MET<guardar>MED<db>A<leer>T<0.006>-- |
|
|
--REXCAT_C<carga_asistencias>MET<guardar>MED<db>A<leer>T<0.006>-- |
|
|
--REXCAT_C<carga_asistencias>MET<guardar>MED<db>A<leer>T<0.006>-- |
|
|
|
|
|
== FIN =============================================
|
|
|
|
