Exemple #1
0
    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")

            wb = Workbook()

            # get default sheet and rename
            ws = excel.get_or_create_sheet(wb, "Sheet")
            ws.title = "Applications"

            excel.write_values(ws, 1, 1, APPLICATIONS_HEADER_FIELDS, direction="right", font=COLUMN_HEADER_FONT)

            row = 2
            for application in Application.objects.filter(lodgement_date__range=(from_date, to_date)).exclude(
                processing_status="draft"
            ):
                row_values = (
                    application.licence_type.name,
                    "{}-{}".format(application.lodgement_number, application.lodgement_sequence),
                    application.lodgement_date,
                    application.applicant_profile.user.get_full_name(),
                    application.applicant_profile.name,
                )
                excel.write_values(ws, row, 1, row_values, direction="right", font=None)
                row += 1

            filename = "applications_{}-{}.xlsx".format(from_date, to_date)
            return excel.WorkbookResponse(wb, filename)
        else:
            messages.error(request, form.errors)
            redirect("wl_reports:reports")
Exemple #2
0
    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")

            wb = Workbook()

            # get default sheet and rename
            ws = excel.get_or_create_sheet(wb, "Sheet")
            ws.title = "Licences"

            excel.write_values(ws, 1, 1, LICENCES_HEADER_FIELDS, direction="right", font=COLUMN_HEADER_FONT)

            row = 2
            for licence in WildlifeLicence.objects.filter(issue_date__range=(from_date, to_date)):
                row_values = (
                    licence.licence_type.name,
                    licence.licence_type.code,
                    "{}-{}".format(licence.licence_number, licence.sequence_number),
                    licence.holder.get_full_name(),
                    licence.issue_date,
                    licence.issuer.get_full_name(),
                    licence.start_date,
                    licence.end_date,
                )
                excel.write_values(ws, row, 1, row_values, direction="right", font=None)
                row += 1

            filename = "licences_{}-{}.xlsx".format(from_date, to_date)
            return excel.WorkbookResponse(wb, filename)
        else:
            messages.error(request, form.errors)
            redirect("wl_reports:reports")
Exemple #3
0
    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")

            wb = Workbook()

            # get default sheet and rename
            ws = excel.get_or_create_sheet(wb, "Sheet")
            ws.title = "Returns"

            excel.write_values(ws, 1, 1, RETURNS_HEADER_FIELDS, direction="right", font=COLUMN_HEADER_FONT)

            row = 2
            for ret in Return.objects.filter(lodgement_date__range=(from_date, to_date)):
                row_values = (
                    ret.licence.licence_type.name,
                    ret.lodgement_number,
                    ret.lodgement_date,
                    ret.licence.holder.get_full_name(),
                    ret.due_date,
                    ret.status,
                )
                excel.write_values(ws, row, 1, row_values, direction="right", font=None)
                row += 1

            filename = "returns_{}-{}.xlsx".format(from_date, to_date)
            return excel.WorkbookResponse(wb, filename)
        else:
            messages.error(request, form.errors)
            redirect("wl_reports:reports")
Exemple #4
0
    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')
Exemple #5
0
    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')
Exemple #6
0
    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')
Exemple #7
0
    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)