def index(request):
# get all schools
cursor = connection.cursor()
cursor.execute("""
SELECT DISTINCT(owning_school_clevel)
FROM %s
ORDER BY owning_school_clevel ASC
""" % GradeResults._meta.db_table)
schools = []
for row in cursor.fetchall():
schools.append(row[0])
# get query date
query_date = None
rs = TableStatus.objects.all().filter(table=GradeResults._meta.db_table)
for r in rs:
query_date = r.timestamp
break
# configure template
template = loader.get_template('al/index.html')
context = applist.template_context('al')
context['schools'] = schools
context['query_date'] = query_date
context['last_school'] = read_last_parameter(request.user, 'al.school', "")
context['last_cutoff'] = read_last_parameter(request.user, 'al.cutoff', "")
context['last_min_age'] = read_last_parameter(request.user, 'al.min_age',
MIN_AGE)
context['last_min_gpa'] = read_last_parameter(request.user, 'al.min_gpa',
"")
context['last_min_points'] = read_last_parameter(request.user,
'al.min_points',
MIN_CREDITS)
return HttpResponse(template.render(context, request))
def search_by_faculty(request):
# get parameters
response, schools = get_variable_with_error(request, 'supervisors', 'school', as_list=True)
if response is not None:
return response
# get year from earliest start date
max_years = get_max_years()
# configure template
template = loader.get_template('supervisors/search_by_faculty.html')
context = applist.template_context('supervisors')
context['schools'] = schools
context['departments'] = get_departments(schools)
context['max_years'] = int(max_years) if max_years is not None else YEARS_BACK
context['scholarships'] = get_scholarships()
context['last_programs'] = read_last_parameter(request.user, 'supervisors.search_by_paper.programs', PROGRAM_TYPES)
context['last_supervisor_type'] = read_last_parameter(request.user, 'supervisors.search_by_paper.supervisor_type', SUPERVISOR_TYPES)
context['last_study_type'] = read_last_parameter(request.user, 'supervisors.search_by_paper.study_type', STUDY_TYPES)
context['last_only_current'] = read_last_parameter(request.user, 'supervisors.search_by_paper.only_current', True)
context['last_min_months'] = read_last_parameter(request.user, 'supervisors.search_by_paper.min_months', -1)
context['last_scholarship'] = read_last_parameter(request.user, 'supervisors.search_by_paper.scholarship', DEFAULT_SCHOLARSHIP)
context['last_sort_column'] = read_last_parameter(request.user, 'supervisors.search_by_paper.sort_column', "supervisor")
context['last_sort_order'] = read_last_parameter(request.user, 'supervisors.search_by_paper.sort_order', "asc")
return HttpResponse(template.render(context, request))
def database_bulk(request):
template = loader.get_template('dbbackend/import_bulk.html')
context = applist.template_context()
context['title'] = 'Bulk import'
context['email_notification'] = read_last_parameter(
request.user, 'dbbackend.database_bulk.email', '')
return HttpResponse(template.render(context, request))
def index(request):
# configure template
template = loader.get_template('hyperlinkgrades/index.html')
context = applist.template_context('hyperlinkgrades')
context['last_expression'] = read_last_parameter(
request.user,
'hyperlinkgrades.expression',
def_value=DEFAULT_EXPRESSION)
context['last_casesensitive_matching'] = bool(
read_last_parameter(request.user,
'hyperlinkgrades.casesensitive_matching',
def_value='False'))
context['last_exclude_completions'] = bool(
read_last_parameter(request.user,
'hyperlinkgrades.exclude_completions',
def_value='True'))
return HttpResponse(template.render(context, request))
def database_associatedrole(request):
template = loader.get_template('dbbackend/import_associatedrole.html')
tablestatus = dbimport.get_tablestatus(AssociatedRole._meta.db_table)
context = applist.template_context()
context['title'] = 'Import associated role'
context['active_import'] = tablestatus is not None
context['email_notification'] = read_last_parameter(
request.user, 'dbbackend.database_associatedrole.email', '')
return HttpResponse(template.render(context, request))
def database_studentdates(request):
template = loader.get_template('dbbackend/update_studentdates.html')
tablestatus = dbimport.get_tablestatus(StudentDates._meta.db_table)
context = applist.template_context()
context['title'] = 'Update student dates'
context['active_import'] = tablestatus is not None
context['email_notification'] = read_last_parameter(
request.user, 'dbbackend.database_studentdates.email', '')
return HttpResponse(template.render(context, request))
def database_coursedefs(request):
years = []
for year in range(2003, date.today().year + 1):
years.append(year)
years.reverse()
tablestatus = dbimport.get_tablestatus(CourseDefs._meta.db_table)
template = loader.get_template('dbbackend/import_coursedefs.html')
context = applist.template_context()
context['title'] = 'Import course definitions'
context['years'] = years
context['active_import'] = tablestatus is not None
context['email_notification'] = read_last_parameter(
request.user, 'dbbackend.database_coursedefs.email', '')
return HttpResponse(template.render(context, request))
def index(request):
# get all years
cursor = connection.cursor()
cursor.execute("""
SELECT DISTINCT(year)
FROM %s
ORDER BY year DESC
""" % GradeResults._meta.db_table)
years = []
for row in cursor.fetchall():
years.append(str(row[0]))
# get all schools
cursor = connection.cursor()
cursor.execute("""
SELECT DISTINCT(owning_school_clevel)
FROM %s
ORDER BY owning_school_clevel ASC
""" % GradeResults._meta.db_table)
schools = []
for row in cursor.fetchall():
schools.append(row[0])
# get query date
query_date = None
rs = TableStatus.objects.all().filter(table=GradeResults._meta.db_table)
for r in rs:
query_date = r.timestamp
break
# configure template
template = loader.get_template('lpp/index.html')
context = applist.template_context('lpp')
context['years'] = years
context['schools'] = schools
context['query_date'] = query_date
context['last_year'] = read_last_parameter(request.user, 'lpp.year', str(years[0]))
context['last_schools'] = read_last_parameter(request.user, 'lpp.schools', schools)
context['last_paper'] = read_last_parameter(request.user, 'lpp.paper', "")
context['last_type'] = read_last_parameter(request.user, 'lpp.type', DEFAULT_TYPE)
context['last_columns'] = read_last_parameter(request.user, 'lpp.columns', DEFAULT_COLUMNS)
context['last_filter1'] = read_last_parameter(request.user, 'lpp.filter1', "")
context['last_operator1'] = read_last_parameter(request.user, 'lpp.operator1', "lt")
context['last_value1'] = read_last_parameter(request.user, 'lpp.value1', "")
return HttpResponse(template.render(context, request))
def search_by_supervisor(request):
# get parameters
response, name = get_variable_with_error(request, 'supervisors', 'name')
if response is not None:
return response
if len(name) == 0:
return create_error_response(request, 'supervisors', 'No supervisor name provided!')
# get year from earliest start date
max_years = get_max_years()
sql = """
select distinct(a.person)
from %s sd, %s a
where lower(a.person) like '%%%s%%'
and a.active = True
order by a.person
""" % (StudentDates._meta.db_table, AssociatedRole._meta.db_table, escape_quotes(name.lower()))
cursor = connection.cursor()
cursor.execute(sql)
results = list()
for row in cursor.fetchall():
data = dict()
data['supervisor'] = row[0]
results.append(data)
# configure template
template = loader.get_template('supervisors/search_by_supervisor.html')
context = applist.template_context('supervisors')
context['results'] = results
context['max_years'] = max_years
context['scholarships'] = get_scholarships()
context['last_programs'] = read_last_parameter(request.user, 'search_by_supervisor.programs', PROGRAM_TYPES)
context['last_supervisor_type'] = read_last_parameter(request.user, 'search_by_supervisor.supervisor_type', SUPERVISOR_TYPES)
context['last_study_type'] = read_last_parameter(request.user, 'search_by_supervisor.study_type', STUDY_TYPES)
context['last_only_current'] = read_last_parameter(request.user, 'search_by_supervisor.only_current', True)
context['last_min_months'] = read_last_parameter(request.user, 'search_by_supervisor.min_months', -1)
context['last_scholarship'] = read_last_parameter(request.user, 'search_by_supervisor.scholarship', DEFAULT_SCHOLARSHIP)
context['last_sort_column'] = read_last_parameter(request.user, 'search_by_supervisor.sort_column', "supervisor")
context['last_sort_order'] = read_last_parameter(request.user, 'search_by_supervisor.sort_order', "asc")
return HttpResponse(template.render(context, request))