Example #1
0
def commission_levels(context, levels=None):
    request = context['request']
    bp = request.user.get_business_profile()
    current_level, perc = commission_level(bp)

    if levels is None:
        levels = settings.COMMISSION_LEVELS

    commission_levels = list()
    for i, level in enumerate(levels):
        min, perc = level
        if i < len(levels) - 1:
            max, next_perc = levels[i + 1]
        else:
            max = '~'

        commission_levels.append({
            'percent': '%.2g' % (perc * 100),
            'min': min,
            'max': max,
            'level': i,
        })

    return {
        'current_level': current_level,
        'commission_levels': commission_levels
    }
Example #2
0
def agent_accounts_dashboard(context):
    request = context['request']
    bp = request.user.get_business_profile()
    data, created = AgentDataCache.objects.get_or_create(businessprofile__pk=bp.pk)

    commission_levels = settings.AGENT_COMMISSION_LEVELS
    deal_price_eur__sum = deal_agent_price_sum(bp)
    current_level_i, perc = commission_level(deal_price_eur__sum=deal_price_eur__sum, levels=commission_levels)

    current_commission_level, next_commission_level = level_progress(commission_levels, current_level_i,
                                                                     deal_price_eur__sum)

    return {
        'request': request,
        'num_recruited': data.num_recruited,
        'num_sold_products': data.num_sold_products,
        'num_interested': data.num_interested,
        'num_active': data.num_active,
        'num_completed': data.num_completed,
        'num_canceled': data.num_canceled,
        'next_commission_level': next_commission_level,
        'current_commission_level': current_commission_level
    }
Example #3
0
def accounts_dashboard(context):
    request = context['request']
    bp = request.user.get_business_profile()
    data, created = ProfileDataCache.objects.get_or_create(businessprofile__pk=bp.pk)

    commission_levels = settings.COMMISSION_LEVELS
    current_level_i, perc = commission_level(bp)
    deal_price_eur__sum = deal_price_sum(bp)

    current_commission_level, next_commission_level = level_progress(commission_levels, current_level_i,
                                                                     deal_price_eur__sum)

    if bp.commission_override:
        current_commission_level['perc'] = '%.2g' % (bp.commission_override * 100)

    return {
        'request': request,
        'total_views': data.num_ads_views,
        'total_active_ads': data.num_ads,
        'total_sold_products': data.num_sold_products,
        'next_commission_level': next_commission_level,
        'current_commission_level': current_commission_level
    }
Example #4
0
def update_profile_data():
    profiles = BusinessProfile.objects.all()
    profiles = profiles.select_related('profile_data_cache', 'agent_data_cache')
    profiles = profiles.annotate(agg_num_ads=Count('ad__pk'))

    for business_profile in profiles:
        need_save = False

        agent_data = None
        profile_data = business_profile.profile_data_cache
        if not profile_data:
            profile_data = ProfileDataCache()
            need_save = True

        deals = Deal.objects.filter(state='completed', ad__owner=business_profile).aggregate(
            agg_total_price_sold=Sum('price_eur'),
            agg_total_sold=Count('pk'),
        )

        num_bought_products = Deal.objects.filter(state='completed', owner=business_profile).count()

        # calculate commission
        level, perc = commission_level(deal_price_eur__sum=deals['agg_total_price_sold'] or 0)
        if profile_data.current_commission_perc != perc:
            profile_data.current_commission_perc = perc
            need_save = True

        #num ads
        if profile_data.num_ads != business_profile.agg_num_ads:
            profile_data.num_ads = business_profile.agg_num_ads or 0
            need_save = True

        # num views on all ads
        ads = Ad.objects.filter(active=True, owner=business_profile).aggregate(
            agg_num_views=Sum('num_views')
        )
        if profile_data.num_ads_views != ads['agg_num_views']:
            profile_data.num_ads_views = ads['agg_num_views'] or 0
            need_save = True

        if profile_data.num_bought_products != num_bought_products:
            profile_data.num_bought_products = num_bought_products or 0
            need_save = True

        # sold ads
        if profile_data.num_sold_products != deals['agg_total_sold']:
            profile_data.num_sold_products = deals['agg_total_sold'] or 0
            need_save = True

        if business_profile.is_agent:
            agent_data = business_profile.agent_data_cache
            if not agent_data:
                agent_data = AgentDataCache()
                need_save = True

            agent_deals = {
                'interested': Deal.objects.filter(state='interested', ad__owner__agent=business_profile).count(),
                'active': Deal.objects.filter(state='active', ad__owner__agent=business_profile).count(),
                'completed': Deal.objects.filter(state='completed', ad__owner__agent=business_profile).count(),
                'canceled': Deal.objects.filter(state='canceled', ad__owner__agent=business_profile).count(),
            }

            if agent_data.num_sold_products != agent_deals['completed']:
                agent_data.num_sold_products = agent_deals['completed']
                need_save = True

            if agent_data.num_interested != agent_deals['interested']:
                agent_data.num_interested = agent_deals['interested']
                need_save = True

            if agent_data.num_active != agent_deals['active']:
                agent_data.num_active = agent_deals['active']
                need_save = True

            if agent_data.num_completed != agent_deals['completed']:
                agent_data.num_completed = agent_deals['completed']
                need_save = True

            if agent_data.num_canceled != agent_deals['canceled']:
                agent_data.num_canceled = agent_deals['canceled']
                need_save = True

            num_recruited = BusinessProfile.objects.filter(agent=business_profile).count()
            if agent_data.num_recruited != num_recruited:
                agent_data.num_recruited = num_recruited
                need_save = True

        if need_save:
            if agent_data:
                agent_data.save()
                business_profile.agent_data_cache = agent_data

            if profile_data:
                profile_data.save()
                business_profile.profile_data_cache = profile_data

            business_profile.save()