Пример #1
0
def CSVReport(request, year, month):
    response = HttpResponse(mimetype='text/csv')
    response['Content-Disposition'] = 'attachment; filename="report.csv"'
    writer = csv.writer(response)
    writer.writerow(['Username', 'Full name', 'Account type', 'Time used', 'Daypasses used'])

    users = HiveUser.objects.all()
    for user in users:
        credit_month = user.credit_set.filter(datetime__year=year,
                                              datetime__month=month,
                                              units__lte=0)
        m_set = credit_month.filter(unit_type='M').aggregate(total=Sum('units'))
        d_set = credit_month.filter(unit_type='D').aggregate(total=Sum('units'))
        if m_set['total']:
            m_used = int(m_set['total'] * -1)
        else:
            m_used = 0
        if d_set['total']:
            d_used = int(d_set['total'] * -1)
        else:
            d_used = 0

        writer.writerow([user, user.get_display_name(), user.account, min_to_hours(m_used), d_used])

    return response
Пример #2
0
 def format_credit_minutes(self):
     return min_to_hours(self.get_credit_minutes())