def get_context_data(self, **kwargs):
kwargs['form'] = ReportForm()
kwargs['payments_form'] = PaymentsReportForm()
kwargs['actions'] = {
'applications': reverse('wl_reports:applications_report'),
'licences': reverse('wl_reports:licences_report'),
'returns': reverse('wl_reports:returns_report'),
'payments': reverse('wl_payments:payments_report'),
}
return TemplateView.get_context_data(self, **kwargs)
def get(self, request, *args, **kwargs):
form = ReportForm(request.GET)
if form.is_valid():
from_date = form.cleaned_data.get('from_date')
to_date = form.cleaned_data.get('to_date')
statuses = ['submitted', 'accepted', 'declined']
qs = Return.objects.filter(lodgement_date__range=(from_date, to_date)).filter(status__in=statuses)
wb = ReportHelper.to_workbook('Returns', self.ALL_HEADERS, self.row_generator(qs))
filename = 'returns_{}-{}.xlsx'.format(from_date, to_date)
return excel.WorkbookResponse(wb, filename)
else:
messages.error(request, form.errors)
redirect('wl_reports:reports')
def get(self, request, *args, **kwargs):
form = ReportForm(request.GET)
if form.is_valid():
from_date = form.cleaned_data.get('from_date')
to_date = form.cleaned_data.get('to_date')
qs = Application.objects.filter(lodgement_date__range=(from_date, to_date)).exclude(
processing_status='draft')
wb = ReportHelper.to_workbook('Applications', self.ALL_HEADERS, self.row_generator(qs))
filename = 'applications_{}-{}.xlsx'.format(from_date, to_date)
return excel.WorkbookResponse(wb, filename)
else:
messages.error(request, form.errors)
redirect('wl_reports:reports')
def get(self, request, *args, **kwargs):
form = ReportForm(request.GET)
if form.is_valid():
from_date = form.cleaned_data.get('from_date')
to_date = form.cleaned_data.get('to_date')
qs = WildlifeLicence.objects.filter(issue_date__range=(from_date, to_date))
regions = form.cleaned_data.get('regions')
if regions:
qs = qs.filter(regions__in=regions)
wb = ReportHelper.to_workbook('Licences', self.ALL_HEADERS, self.row_generator(qs))
filename = 'licences_{}-{}.xlsx'.format(from_date, to_date)
return excel.WorkbookResponse(wb, filename)
else:
messages.error(request, form.errors)
redirect('wl_reports:reports')
