def index(request):
context = RequestContext(request, {})
export_form = DataExportForm(request.POST)
if export_form.is_valid():
context = RequestContext(request, {'form': export_form})
return render_to_response('libraryuse/home.html', context)
def export(request):
context = RequestContext(request, {})
export_form = None
if request.method == 'POST':
export_form = DataExportForm(request.POST)
#i suspect because the dates are not actaully coming through
if export_form.is_valid():
response = HttpResponse(content_type='text/csv')
response['Content-Disposition'] = 'attachment; filename="libraryuse.csv"'
writer = csv.writer(response)
start_date = export_form.cleaned_data['start_date']
end_date = export_form.cleaned_data['end_date']
#visits = LibraryVisit.objects.all()
visits = LibraryVisit.objects.filter(visit_time__range=[start_date, end_date])
writer.writerow(['visit_time', 'term_number', 'location', 'prsn_c_type', \
'prsn_e_type', 'emjo_c_clsf', 'dprt_c', \
'edprt_n', 'dvsn_i', 'dvsn_n', \
'empe_c_fclt_rank', 'prsn_c_type_hc', \
'prsn_e_type_hc', 'emjo8hc_c_clsf', 'dprt8hc_c', \
'dprt8hc_n', 'dvsn8hc_i', 'dvsn8hc_n', \
'acca_i', 'acpr_n', 'acpl_n', \
'stdn_e_clas', 'stdn_f_ungr', 'stdn_f_cmps_on'])
for v in visits:
writer.writerow([v.visit_time, v.term_number, v.location, \
v.prsn_c_type, v.prsn_e_type, v.emjo_c_clsf, \
v.dprt_c, v.dprt_n, v.dvsn_i, v.dvsn_n, \
v.empe_c_fclt_rank, v.prsn_c_type_hc, \
v.prsn_e_type_hc, v.emjo8hc_c_clsf, v.dprt8hc_c, \
v.dprt8hc_n, v.dvsn8hc_i, v.dvsn8hc_n, v.acca_i, \
v.acpr_n, v.acpl_n, v.stdn_e_clas, v.stdn_f_ungr, \
v.stdn_f_cmps_on])
return response
else:
export_form = DataExportForm()
return render_to_response('libraryuse/export.html', context)