2018.07.12 19.05.09 [seguridad/login] select p.idpersona, p.documentonro, u.password, u.primeracceso from usuarios u inner join personas p on p.idpersona=u.idpersona where u.usuario='desa' AND u.estado=1 AND p.estado=1
2018.07.12 19.05.09 [seguridad/login] SELECT p.idpersona, p.apellido, p.nombre, p.estado, u.usuario,  u.email, u.estado, u.primeracceso FROM personas p inner join usuarios u on p.idpersona=u.idpersona where p.idpersona=3031
2018.07.12 19.05.09 [seguridad/login] select r.idrol, r.nombre from personarol pr inner join roles r on pr.idrol=r.idrol where pr.idpersona=3031 order by 1
2018.07.12 19.05.10 [seguridad/login] insert into usuarioaccesos (idpersona,fecha,usuario,contraseña,ip,navegador,estado) select  3031,CURRENT_TIMESTAMP,'desa','desa','190.189.55.232','Mozilla/5.0 (Windows NT 10.0; Win64; x64','Acceso concedido'
2018.07.12 19.05.10 [seguridad/login] select r.idrol, r.nombre from personarol pr inner join roles r on pr.idrol=r.idrol where pr.idpersona=3031
2018.07.12 19.05.10 [seguridad/pickrole] select r.idrol, r.nombre from personarol pr inner join roles r on pr.idrol=r.idrol where pr.idpersona=3031
2018.07.12 19.05.12 [seguridad/pickrole] select pr.idrol, r.nombre from personarol pr inner join roles r on pr.idrol=r.idrol where pr.idpersona=3031 and pr.idrol=3
2018.07.12 19.05.12 [seguridad/pickrole] select p.idpermiso,p.nombre as nombre from permisosroles pr inner join permisos p on pr.idpermiso=p.idpermiso where pr.idRol=3 union all select p.idpermiso,pe.nombre as nombre from personapermisos p inner join permisos pe on p.idpermiso=pe.idpermiso where p.idpersona= 3031 order by nombre 
2018.07.12 19.05.12 [seguridad/pickrole] select parametro,valor from configuracion order by orden
2018.07.12 19.05.13 [home/menu]  select distinct m.idMenu,m.nombre, m.accion as formulario from menu m inner join menupermisos mp on m.idMenu=mp.idMenu  where mp.idpermiso in (  select idpermiso from personapermisos where idpersona=3031 union all select idpermiso from permisosroles where idrol=3 ) and m.activo=1 order by m.nombre asc
2018.07.12 19.05.13 [AlumnoCarreraModel/getFobasCompletas/3031] Select ac1.idpersona, ac1.idcarrera, ac1.idarea, ac1.idinstrumento, i.nombre as instrumento, c.nombre as carrera
            from alumnocarrera ac1 
            INNER JOIN carreras c on (ac1.idcarrera = c.idcarrera)
            inner join instrumentos i on (ac1.idinstrumento = i.idinstrumento)
            where ac1.idcarrera in (1,5) 
            and ac1.estado in (2,3)
            and ac1.idpersona=:idpersona
            and ac1.idpersona not in (
                select ac2.idpersona 
                from alumnocarrera ac2 
                where ac2.idcarrera in (2, 3, 4) 
                and ac2.idinstrumento=ac1.idinstrumento 
                and ac2.estado in (1, 3)
                )
2018.07.12 19.05.13 [AlumnoCarreraModel/getAvanzadas2anio/3031] SELECT ac.idpersona, ac.idnivel, cn.descripcion as nnombre, c.nombre as cnombre,
                c.descripcion as cdescripcion, i.idinstrumento, i.nombre as inombre,
                c.idcarrera
                FROM alumnocarrera ac
                INNER JOIN carreras c ON (ac.idcarrera = c.idcarrera)
                INNER JOIN instrumentos i ON (ac.idinstrumento = i.idinstrumento)
                INNER JOIN carreraniveles cn ON (cn.id = ac.idnivel)
                WHERE ac.idpersona = :idpersona
                AND ac.idcarrera IN (2,3)
                AND ac.estado in (1,3)
                AND ac.idarea=0
                AND Exists(
                    select am.idalumnomateria 
                    from alumnomateria am 
                    where am.idpersona = ac.idpersona
                    and am.idmateria in (7,9,8,4,3,2,1,5,6,36,32,33,34,35) 
                    and am.idestadoalumnomateria in (3,4,5) 
                    and am.idcarrera = ac.idcarrera
                )
2018.07.12 19.05.52 [ReporteDinamicoModel/getMenuReportes] select * from reportes where activo = 1 order by nombre
2018.07.12 19.05.52 [Aplicacion/getMenu]  select distinct m.idMenu,m.nombre, m.accion as formulario from menu m inner join menupermisos mp on m.idMenu=mp.idMenu  where mp.idpermiso in (  select idpermiso from personapermisos where idpersona=3031 union all select idpermiso from permisosroles where idrol=3 ) and m.activo=1 order by m.nombre asc
2018.07.12 19.05.56 [ReporteDinamicoModel/getMenuReportes] select * from reportes where activo = 1 order by nombre
2018.07.12 19.05.56 [ReporteDinamicoModel/getEncabezados] select p.apellido,p.nombre,p.documentonro,m.materiacompleta,c.descripcion as carrera,am.aniocursada, 
                eam.descripcion as estado,
                (case when condicional=1 then 'SI' else 'NO' end) as condicional,
                (case when condicionalregla6=1 then 'SI' else 'NO' end) as condicionalsimultaneo
                from alumnomateria am inner join alumnomateria_condicionalidades amc on
                am.idalumnomateria=amc.idalumnomateria
                inner join alumnocarrera ac on am.idalumnocarrera=ac.idalumnocarrera
                inner join personas p on am.idpersona=p.idpersona
                inner join carreras c on ac.idcarrera=c.idcarrera
                inner join viewmaterias m on am.idmateria=m.idmateria and ac.idcarrera=m.idcarrera
                inner join estadoalumnomateria eam on am.idestadoalumnomateria=eam.idestadoalumnomateria
                where am.aniocursada=2018 limit 1
2018.07.12 19.05.56 [Aplicacion/getMenu]  select distinct m.idMenu,m.nombre, m.accion as formulario from menu m inner join menupermisos mp on m.idMenu=mp.idMenu  where mp.idpermiso in (  select idpermiso from personapermisos where idpersona=3031 union all select idpermiso from permisosroles where idrol=3 ) and m.activo=1 order by m.nombre asc
2018.07.12 19.06.02 [ReporteDinamicoModel/getMenuReportes] select * from reportes where activo = 1 order by nombre
2018.07.12 19.06.02 [ReporteDinamicoModel/getEncabezados] select 
            vm.materiaCompleta as Materia,c.nombre as Comision,
            sum(case when p.sexo='MASCULINO' then 1 else 0 end) as Masculino,
            sum(case when p.sexo='MASCULINO' then 0 else 1 end) as Femenino
            from alumnomateria am
            inner join alumnocarrera ac on am.idalumnocarrera=ac.idalumnocarrera
            inner join viewmaterias vm on am.idmateria=vm.idmateria and vm.idcarrera=ac.idcarrera
            inner join comisiones c on am.idcomision=c.idcomision
            inner join personas p on am.idpersona=p.idpersona
            where am.aniocursada=2018 and am.idestadoalumnomateria=2
            group by vm.materiacompleta,c.nombre,am.idestadoalumnomateria
            order by am.idmateria,am.idcomision limit 1
2018.07.12 19.06.02 [ReporteDinamicoModel/getAlumnosCondicionales] select p.apellido,p.nombre,p.documentonro,m.materiacompleta,c.descripcion as carrera,am.aniocursada, 
                eam.descripcion as estado,
                (case when condicional=1 then 'SI' else 'NO' end) as condicional,
                (case when condicionalregla6=1 then 'SI' else 'NO' end) as condicionalsimultaneo
                from alumnomateria am inner join alumnomateria_condicionalidades amc on
                am.idalumnomateria=amc.idalumnomateria
                inner join alumnocarrera ac on am.idalumnocarrera=ac.idalumnocarrera
                inner join personas p on am.idpersona=p.idpersona
                inner join carreras c on ac.idcarrera=c.idcarrera
                inner join viewmaterias m on am.idmateria=m.idmateria and ac.idcarrera=m.idcarrera
                inner join estadoalumnomateria eam on am.idestadoalumnomateria=eam.idestadoalumnomateria
                where am.aniocursada=2018
2018.07.12 19.06.04 [home/menu]  select distinct m.idMenu,m.nombre, m.accion as formulario from menu m inner join menupermisos mp on m.idMenu=mp.idMenu  where mp.idpermiso in (  select idpermiso from personapermisos where idpersona=3031 union all select idpermiso from permisosroles where idrol=3 ) and m.activo=1 order by m.nombre asc
2018.07.12 19.06.04 [AlumnoCarreraModel/getFobasCompletas/3031] Select ac1.idpersona, ac1.idcarrera, ac1.idarea, ac1.idinstrumento, i.nombre as instrumento, c.nombre as carrera
            from alumnocarrera ac1 
            INNER JOIN carreras c on (ac1.idcarrera = c.idcarrera)
            inner join instrumentos i on (ac1.idinstrumento = i.idinstrumento)
            where ac1.idcarrera in (1,5) 
            and ac1.estado in (2,3)
            and ac1.idpersona=:idpersona
            and ac1.idpersona not in (
                select ac2.idpersona 
                from alumnocarrera ac2 
                where ac2.idcarrera in (2, 3, 4) 
                and ac2.idinstrumento=ac1.idinstrumento 
                and ac2.estado in (1, 3)
                )
2018.07.12 19.06.04 [AlumnoCarreraModel/getAvanzadas2anio/3031] SELECT ac.idpersona, ac.idnivel, cn.descripcion as nnombre, c.nombre as cnombre,
                c.descripcion as cdescripcion, i.idinstrumento, i.nombre as inombre,
                c.idcarrera
                FROM alumnocarrera ac
                INNER JOIN carreras c ON (ac.idcarrera = c.idcarrera)
                INNER JOIN instrumentos i ON (ac.idinstrumento = i.idinstrumento)
                INNER JOIN carreraniveles cn ON (cn.id = ac.idnivel)
                WHERE ac.idpersona = :idpersona
                AND ac.idcarrera IN (2,3)
                AND ac.estado in (1,3)
                AND ac.idarea=0
                AND Exists(
                    select am.idalumnomateria 
                    from alumnomateria am 
                    where am.idpersona = ac.idpersona
                    and am.idmateria in (7,9,8,4,3,2,1,5,6,36,32,33,34,35) 
                    and am.idestadoalumnomateria in (3,4,5) 
                    and am.idcarrera = ac.idcarrera
                )
2018.07.12 19.06.08 [ReporteDinamicoModel/getMenuReportes] select * from reportes where activo = 1 order by nombre
2018.07.12 19.06.08 [Aplicacion/getMenu]  select distinct m.idMenu,m.nombre, m.accion as formulario from menu m inner join menupermisos mp on m.idMenu=mp.idMenu  where mp.idpermiso in (  select idpermiso from personapermisos where idpersona=3031 union all select idpermiso from permisosroles where idrol=3 ) and m.activo=1 order by m.nombre asc
2018.07.12 19.06.11 [ReporteDinamicoModel/getMenuReportes] select * from reportes where activo = 1 order by nombre
2018.07.12 19.06.11 [ReporteDinamicoModel/getEncabezados] SELECT* FROM alumnomateria limit 1
2018.07.12 19.06.11 [Aplicacion/getMenu]  select distinct m.idMenu,m.nombre, m.accion as formulario from menu m inner join menupermisos mp on m.idMenu=mp.idMenu  where mp.idpermiso in (  select idpermiso from personapermisos where idpersona=3031 union all select idpermiso from permisosroles where idrol=3 ) and m.activo=1 order by m.nombre asc
2018.07.12 19.06.16 [ReporteDinamicoModel/getAlumnoMateria] SELECT* FROM alumnomateria
2018.07.12 19.06.17 [ReporteDinamicoModel/getMenuReportes] select * from reportes where activo = 1 order by nombre
2018.07.12 19.06.17 [ReporteDinamicoModel/getEncabezados] select am.idalumnomateria,p.apellido as Apellido,p.nombre as Nombre,p.documentonro as Documento,p.sexo as Sexo,
        c.nombre as Carrera,vm.materiacompleta as Materia,co.nombre as Comision,am.aniocursada as Año,
        eam.descripcion as Estado,am.fechaaprobacion as FechaAprobacion,am.usucrea as Usucrea,date_format(am.fechacrea,'%d/%m/%Y') as Fechacrea from alumnomateria am
        inner join viewmaterias vm on (am.idmateria=vm.idmateria and am.idcarrera=vm.idcarrera)
        left join comisiones co on am.idcomision=co.idcomision
        left join estadoalumnomateria eam on am.idestadoalumnomateria=eam.idestadoalumnomateria
        left join carreras c on am.idcarrera=c.idcarrera
        left join personas p on am.idpersona=p.idpersona where am.aniocursada=2018 order by am.fechacrea asc limit 1
2018.07.12 19.06.21 [home/menu]  select distinct m.idMenu,m.nombre, m.accion as formulario from menu m inner join menupermisos mp on m.idMenu=mp.idMenu  where mp.idpermiso in (  select idpermiso from personapermisos where idpersona=3031 union all select idpermiso from permisosroles where idrol=3 ) and m.activo=1 order by m.nombre asc
2018.07.12 19.06.21 [AlumnoCarreraModel/getFobasCompletas/3031] Select ac1.idpersona, ac1.idcarrera, ac1.idarea, ac1.idinstrumento, i.nombre as instrumento, c.nombre as carrera
            from alumnocarrera ac1 
            INNER JOIN carreras c on (ac1.idcarrera = c.idcarrera)
            inner join instrumentos i on (ac1.idinstrumento = i.idinstrumento)
            where ac1.idcarrera in (1,5) 
            and ac1.estado in (2,3)
            and ac1.idpersona=:idpersona
            and ac1.idpersona not in (
                select ac2.idpersona 
                from alumnocarrera ac2 
                where ac2.idcarrera in (2, 3, 4) 
                and ac2.idinstrumento=ac1.idinstrumento 
                and ac2.estado in (1, 3)
                )
2018.07.12 19.06.21 [AlumnoCarreraModel/getAvanzadas2anio/3031] SELECT ac.idpersona, ac.idnivel, cn.descripcion as nnombre, c.nombre as cnombre,
                c.descripcion as cdescripcion, i.idinstrumento, i.nombre as inombre,
                c.idcarrera
                FROM alumnocarrera ac
                INNER JOIN carreras c ON (ac.idcarrera = c.idcarrera)
                INNER JOIN instrumentos i ON (ac.idinstrumento = i.idinstrumento)
                INNER JOIN carreraniveles cn ON (cn.id = ac.idnivel)
                WHERE ac.idpersona = :idpersona
                AND ac.idcarrera IN (2,3)
                AND ac.estado in (1,3)
                AND ac.idarea=0
                AND Exists(
                    select am.idalumnomateria 
                    from alumnomateria am 
                    where am.idpersona = ac.idpersona
                    and am.idmateria in (7,9,8,4,3,2,1,5,6,36,32,33,34,35) 
                    and am.idestadoalumnomateria in (3,4,5) 
                    and am.idcarrera = ac.idcarrera
                )
2018.07.12 19.06.25 [ReporteDinamicoModel/getMenuReportes] select * from reportes where activo = 1 order by nombre
2018.07.12 19.06.25 [Aplicacion/getMenu]  select distinct m.idMenu,m.nombre, m.accion as formulario from menu m inner join menupermisos mp on m.idMenu=mp.idMenu  where mp.idpermiso in (  select idpermiso from personapermisos where idpersona=3031 union all select idpermiso from permisosroles where idrol=3 ) and m.activo=1 order by m.nombre asc
2018.07.12 19.06.27 [ReporteDinamicoModel/getMenuReportes] select * from reportes where activo = 1 order by nombre
2018.07.12 19.06.27 [ReporteDinamicoModel/getEncabezados] SELECT* FROM alumnomateria limit 1
2018.07.12 19.06.27 [Aplicacion/getMenu]  select distinct m.idMenu,m.nombre, m.accion as formulario from menu m inner join menupermisos mp on m.idMenu=mp.idMenu  where mp.idpermiso in (  select idpermiso from personapermisos where idpersona=3031 union all select idpermiso from permisosroles where idrol=3 ) and m.activo=1 order by m.nombre asc
2018.07.12 19.06.28 [ReporteDinamicoModel/getAlumnoMateria] SELECT* FROM alumnomateria
2018.07.12 19.26.29 [ReporteDinamicoModel/getMenuReportes] select * from reportes where activo = 1 order by nombre
2018.07.12 19.26.29 [ReporteDinamicoModel/getEncabezados] SELECT* FROM alumnomateria limit 1
2018.07.12 19.26.29 [Aplicacion/getMenu]  select distinct m.idMenu,m.nombre, m.accion as formulario from menu m inner join menupermisos mp on m.idMenu=mp.idMenu  where mp.idpermiso in (  select idpermiso from personapermisos where idpersona=0 union all select idpermiso from permisosroles where idrol=0 ) and m.activo=1 order by m.nombre asc