mwolff44 / pyfreebilling

    return {'companies': company_list}

@user_passes_test(lambda u: u.is_superuser)

@staff_member_required

def admin_report_view(request):

    # view code

    qs_d = DimCustomerDestination.objects.all()

    qs_h = DimCustomerHangupcause.objects.all()

#    qss_total_calls = qsstats.QuerySetStats(qs, 'date__date', aggregate=Sum('total_calls'))

#    qss_success_calls = qsstats.QuerySetStats(qs, 'date__date', aggregate=Sum('success_calls'))

#    qss_total_duration = qsstats.QuerySetStats(qs, 'date__date', aggregate=Sum('total_duration'))

#    qss_total_sell = qsstats.QuerySetStats(qs, 'date__date', aggregate=Sum('total_sell'))

#    qss_total_cost = qsstats.QuerySetStats(qs, 'date__date', aggregate=Sum('total_cost'))

    today = datetime.date.today()

    firstday = today - datetime.timedelta(days=7)

    ts_total_calls = time_series(

        qs_h, 'date__date', [firstday, today], func=Sum('total_calls'))

    ts_success_calls = time_series(

        qs_d, 'date__date', [firstday, today], func=Sum('success_calls'))

    ts_total_duration = time_series(

        qs_d, 'date__date', [firstday, today], func=Sum('total_duration'))

    ts_total_sell = time_series(

        qs_d, 'date__date', [firstday, today], func=Sum('total_sell'))

    ts_total_cost = time_series(

        qs_d, 'date__date', [firstday, today], func=Sum('total_cost'))

    ts_total_margin = _margin_series(ts_total_sell, ts_total_cost)

    return render(request, 'admin/admin_report.html', locals())

    return {'companies' : company_list}

@register.inclusion_tag('snippets/dashboard.html')

def total_stats():

    qs_d = DimCustomerDestination.objects.all()

    qs_h = DimCustomerHangupcause.objects.all()

    today = datetime.date.today()

    firstday = today - datetime.timedelta(days=30)

    ts_total_calls = time_series(qs_h, 'date__date', [firstday, today], func=Sum('total_calls'))

    ts_success_calls = time_series(qs_d, 'date__date', [firstday, today], func=Sum('success_calls'))

    ts_total_duration = time_series(qs_d, 'date__date', [firstday, today], func=Sum('total_duration'))

    ts_total_sell = time_series(qs_d, 'date__date', [firstday, today], func=Sum('total_sell'))

    ts_total_cost = time_series(qs_d, 'date__date', [firstday, today], func=Sum('total_cost'))

    return locals()

def get_num_user_orders(parser, token):