def get(self, request, *args, **kwargs): #pylint: disable=unused-argument organization = self.get_organization() at_date = datetime_or_now(request.DATA.get('at', None)) return Response([{ 'key': Transaction.INCOME, 'values': monthly_balances( organization, Transaction.INCOME, at_date) }])
def get(self, request, *args, **kwargs): #pylint: disable=unused-argument self.cache_fields(request) response = HttpResponse(content_type='text/csv') response['Content-Disposition'] = ('attachment; filename="%s.csv"' % self.queryname) writer = csv.writer(response) # column headers values = ['name'] for end_period in month_periods(from_date=self.ends_at): values += [end_period] writer.writerow(values) # rows for key in Transaction.objects.distinct_accounts(): values = [key] + [item[1] for item in monthly_balances( self.organization, key, self.ends_at)] writer.writerow(values) return response
def get(self, request, *args, **kwargs): #pylint: disable=unused-argument organization = self.get_organization() start_at = request.GET.get('start_at', None) if start_at: start_at = parse_datetime(start_at) start_at = datetime_or_now(start_at) ends_at = request.GET.get('ends_at', None) if ends_at: ends_at = parse_datetime(ends_at) ends_at = datetime_or_now(ends_at) result = [] for key in Transaction.objects.distinct_accounts(): result += [{ 'key': key, 'values': monthly_balances(organization, key, ends_at) }] return Response(result)
def get(self, request, *args, **kwargs): #pylint: disable=unused-argument self.cache_fields(request) response = HttpResponse(content_type='text/csv') response['Content-Disposition'] = ('attachment; filename="%s.csv"' % self.queryname) writer = csv.writer(response) # column headers values = ['name'] for end_period in month_periods(from_date=self.ends_at): values += [end_period] writer.writerow(values) # rows for key in Transaction.objects.distinct_accounts(): values = [key] + [ item[1] for item in monthly_balances(self.organization, key, self.ends_at) ] writer.writerow(values) return response
def get(self, request, *args, **kwargs): #pylint: disable=unused-argument organization = self.get_organization() start_at = request.GET.get('start_at', None) if start_at: start_at = parse_datetime(start_at) start_at = datetime_or_now(start_at) ends_at = request.GET.get('ends_at', None) if ends_at: ends_at = parse_datetime(ends_at) ends_at = datetime_or_now(ends_at) result = [] for key in [Transaction.INCOME, Transaction.BACKLOG, Transaction.RECEIVABLE]: result += [{ 'key': key, 'values': monthly_balances(organization, key, ends_at) }] return Response({'title': "Balances", 'unit': "$", 'scale': 0.01, 'table': result})
def get(self, request, *args, **kwargs): #pylint: disable=unused-argument organization = self.get_organization() start_at = request.GET.get('start_at', None) if start_at: start_at = parse_datetime(start_at) start_at = datetime_or_now(start_at) ends_at = request.GET.get('ends_at', None) if ends_at: ends_at = parse_datetime(ends_at) ends_at = datetime_or_now(ends_at) result = [] for key in [ Transaction.INCOME, Transaction.BACKLOG, Transaction.RECEIVABLE ]: result += [{ 'key': key, 'values': monthly_balances(organization, key, ends_at) }] return Response({ 'title': "Balances", 'unit': "$", 'scale': 0.01, 'table': result })
def queryrow_to_columns(self, account): return [account] + [item[1] for item in monthly_balances( self.organization, account, self.ends_at)]
def queryrow_to_columns(self, account): return [account] + [item[1] for item in monthly_balances( self.organization, account, self.ends_at.date())]