def test_extract_period(self):
start, end = extract_period({
'start_period': '01/01/2018',
'end_period': '12/31/2018'
})
self.assertEqual(start, datetime.datetime(2018, 1, 1, 0, 0))
self.assertEqual(end, datetime.datetime(2018, 12, 31, 0, 0))
start, end = extract_period({'default_periods': '1'})
delta = datetime.date.today() - datetime.timedelta(days=7)
self.assertEqual(start, delta)
self.assertEqual(end, datetime.date.today())
def get_multipage_queryset(self):
j_no = self.request.GET['journal']
journal = models.Journal.objects.get(pk=j_no)
start, end = extract_period(self.request.GET)
return models.JournalEntry.objects.filter(journal=journal,
date__gte=start,
date__lte=end)
def get_context_data(self, *args, **kwargs):
context = super().get_context_data(*args, **kwargs)
kwargs = self.request.GET
start, end = extract_period(kwargs)
context['pdf_link'] = True
# sales
return ProfitAndLossReport.common_context(context, start, end)
def get_context_data(self, *args, **kwargs):
context = super().get_context_data(*args, **kwargs)
kwargs = self.request.GET
start, end = extract_period(kwargs)
context['pdf_link'] = True
return ServicePersonUtilizationReport.common_context(
context, start, end)
def get_context_data(self, **kwargs):
context = super().get_context_data(**kwargs)
start, end = extract_period(self.request.GET)
context.update({
'start': start,
'end': end,
})
return TimeLogReportView.common_context(context, start, end)
def get_multipage_queryset(self):
start, end = extract_period(self.request.GET)
return InvoiceLine.objects.filter(
Q(invoice__date__gte=start) & Q(invoice__date__lte=end)
& Q(invoice__draft=False)
& Q(invoice__status__in=['paid', 'invoice', 'paid-partially'])
& Q(service__isnull=False))
def get_context_data(self, **kwargs):
context = super().get_context_data(**kwargs)
start, end = encode_period(*extract_period(self.request.GET))
context.update({
'start': start,
'end': end,
'date': datetime.date.today()
})
return context
def get_context_data(self, *args, **kwargs):
context = super().get_context_data(*args, **kwargs)
kwargs = self.request.GET
start, end = extract_period(kwargs)
context['pdf_link'] = True
context['journal'] = kwargs['journal']
# sales
return JournalReport.common_context(context, start, end)
def get_context_data(self, **kwargs):
context = super().get_context_data(**kwargs)
start, end = extract_period(self.request.GET)
context.update({
'start': start.strftime("%d %B %Y"),
'end': end.strftime("%d %B %Y")
})
SalesByCustomerReportView.common_context(context, start, end)
return context
def get_context_data(self, *args, **kwargs):
context = super(CustomerStatement,
self).get_context_data(*args, **kwargs)
kwargs = self.request.GET
customer = models.Customer.objects.get(pk=kwargs['customer'])
start, end = extract_period(kwargs)
context['pdf_link'] = True
return CustomerStatement.common_context(context, customer, start, end)
def get_multipage_queryset(self):
acc_no = self.request.GET['account']
account = models.Account.objects.get(pk=acc_no)
start, end = extract_period(self.request.GET)
debits = models.Debit.objects.filter(account=account,
entry__date__gte=start,
entry__date__lte=end)
credits = models.Credit.objects.filter(account=account,
entry__date__gte=start,
entry__date__lte=end)
transactions = chain(debits, credits)
return sorted(transactions,
key=lambda transaction: transaction.entry.date)
def get_multipage_queryset(self):
kwargs = self.request.GET
customer = models.Customer.objects.get(pk=kwargs['customer'])
start, end = extract_period(kwargs)
credits = Credit.objects.filter(
Q(entry__date__gte=start) & Q(entry__date__lte=end)
& Q(account=customer.account)).order_by('pk')
debits = Debit.objects.filter(
Q(entry__date__gte=start) & Q(entry__date__lte=end)
& Q(account=customer.account)).order_by('pk')
return sorted(itertools.chain(debits, credits),
key=lambda t: t.entry.date)
def get_multipage_queryset(self):
start, end = extract_period(self.request.GET)
return ServiceWorkOrder.objects.filter(date__gte=start, date__lte=end)
def get_multipage_queryset(self):
start, end = extract_period(self.request.GET)
return models.Payment.objects.filter(date__gte=start, date__lte=end)
def get_context_data(self, **kwargs):
context = super().get_context_data(**kwargs)
kwargs = self.request.GET
context['pdf_link'] = True
start, end = extract_period(kwargs)
return SalesReportView.common_context(context, start, end)
def get_multipage_queryset(self):
start, end = extract_period(self.request.GET)
return self.__class__.common_multipage_queryset(start, end)
def get_context_data(self, *args, **kwargs):
context = super().get_context_data(*args, **kwargs)
start, end = extract_period(self.request.GET)
self.__class__.common_context(context, start, end)
return context
