from datetime import datetime, date, timedelta from math import ceil from django.shortcuts import render from django.contrib.auth.decorators import login_required from django.db.models import Sum from isoweek import Week from sales.models import UserPlan, StatAdvertiser from dashboard.settings import REGIONAL_DATA from admin.models import Account, AuthUser # Create your views here. regions = REGIONAL_DATA.keys() @login_required def sales_commission(request): users = AuthUser.objects.all accounts = Account.objects.values('region').distinct() groups = Account.objects.values('business_unit').distinct() regions = [r['region'] for r in accounts] groups = [r['business_unit'] for r in groups] m = date.today().month c = int(ceil(m / 3.0)) params = { 'user': int(request.GET.get('user', request.user.id)), 'region': request.GET.get('region', 'all'),