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')