Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- from django.shortcuts import render
- from estudiante.models import Estudiante
- from caracterizacion.models import Tipo, Caracterizacion
- from .filters import EstudianteFilter
- # Create your views here.
- def principal(request):
- query = '''SELECT DISTINCT ON (e.id) e.id, e.nombre, e.apellido, e.estado, e.documento, c.nivelado, s.nombre AS semestre, t.nombre AS tipo
- FROM estudiante e
- JOIN caracterizacion c ON c.estudiante_id = e.id
- JOIN semestre s ON s.id=c.semestre_id
- JOIN tipo t ON t.id=c.tipo_id
- ORDER BY e.id, s.orden DESC'''
- estudiantes = Estudiante.objects.raw(query)
- estudiantes_filter = EstudianteFilter(request.GET, queryset=estudiantes)
- print(estudiantes_filter)
- contexto = {
- 'estudiantes': estudiantes,
- 'filter': estudiantes_filter,
- }
- return render(request, 'reporte/principal.html', contexto)
Add Comment
Please, Sign In to add comment