Example #1
0
def group_edit(request):
    if request.user.is_authenticated and request.user.id!=None:
        group_id = request.GET['group_id']
        user = User.objects.get(id=request.user.id)
        now = dt.now()
        try:
            group = Group.objects.get(id=group_id)
            if group.owners.filter(id=user.id).exists():
                all_members = list(group.members.all()) + list(group.owners.all())
                for member in all_members:
                    rank = UserRanking.objects.filter(owner__id=member.id, group__id=group.id)
                    if not rank.exists():
                        rank = UserRanking()
                        rank.owner = member
                        rank.group = group
                        rank.overall_score = 0
                        rank.rank = None
                        rank.save()
                    else:
                        rank = rank[0]
                all_users = list(group.members.values_list('id', flat=True)) + list(group.owners.values_list('id', flat=True))
                all_matchs = group.event.matchs.all().values_list('id', flat=True)
                betted_amounts = {}
                for user_id in all_users:
                    betted_amounts[user_id] = Bet.objects.filter(owner__id=user_id, match__id__in=all_matchs).aggregate(Sum('amount'))['amount__sum']
                locked_amounts = {}
                for user_id in all_users:
                    locked_amounts[user_id] = Bet.objects.filter(owner__id=user_id, match__id__in=all_matchs, match__when__lte=now).aggregate(Sum('amount'))['amount__sum']
                    
                ranking = UserRanking.objects.filter(owner__id__in=all_users, group__id=group.id)
                your_rank = UserRanking.objects.get(owner__id=user.id, group__id=group.id)
                allow_amount = request.user.groups.filter(name='allow_amount')
                winner_setup = WinnerSetup.objects.filter(group__id=group.id)
                if winner_setup.exists():
                    winner_setup = winner_setup[0]
                else:
                    winner_setup = None
                
                context = {'group': group, 'ranking':ranking, 'yours': your_rank, 'betted_amounts':betted_amounts, 'allow_amount':allow_amount,'locked_amounts':locked_amounts, 'winner_setup': winner_setup}
                return render(request,'group_edit.html', context)
            else:
                raise PermissionDenied()
        except:
            traceback.print_exc()
            return HttpResponseBadRequest()
    else:
        raise PermissionDenied()
def compute_group_ranking(group_id=None):
    today = dates.AddDay(datetime.date.today(),-1)
    if group_id==None:
        all_groups = Group.objects.filter(event__end_date__gte=today)
    else:
        all_groups = Group.objects.filter(id=group_id)
    for group in all_groups:
        if not group.owners.all()[0].groups.filter(name='allow_amount').exists():
            LOGGER.info("Working on group " + str(group.name))
            for user in list(group.members.all()) + list(group.owners.all()):
                LOGGER.info("\tWorking on user " + str(user.username))
                ranking = UserRanking.objects.filter(owner__id=user.id, group__id=group.id)
                if not ranking.exists():
                    ranking = UserRanking()
                    ranking.owner = user
                    ranking.group = group
                    ranking.overall_score = 0
                    ranking.rank = None
                    ranking.save()
                else:
                    ranking = ranking[0]
                event_rank = EventRanking.objects.filter(event__id=group.event.id, owner__id=user.id)
                if event_rank.exists():
                    event_rank = event_rank[0]
                    ranking.overall_score = event_rank.overall_score
                    ranking.save()
                else:
                    LOGGER.warn("User [" + str(user.id) +"] has no rank in event:" + str(group.event.name))
        else:
            LOGGER.info("Working on group with event and amount: " + unicode(group.event.name))
            events_ranking = {}
            for user in list(group.members.all()) + list(group.owners.all()):
                LOGGER.info("\tWorking on user " + unicode(user.username))
                for match in group.event.matchs.filter(result__isnull=False):
                    LOGGER.info("\t\tWorking on match " + unicode(match.name))
                    bet = Bet.objects.filter(match__id=match.id, owner__id=user.id)
                    winner = match.get_winner()
                    LOGGER.info("\t\tWinner is " + unicode(winner))
                    if bet.exists():
                        bet = bet[0]
                        if bet.amount!=None and bet.amount!=0:
                            score = bet.get_score()
                            if not events_ranking.has_key(group.event.id):
                                events_ranking[group.event.id] = {}
                            if not events_ranking[group.event.id].has_key(user.id):
                                rank = EventRanking()
                                rank.event = group.event
                                rank.owner = user
                                rank.overall_score = 0
                                rank.rank = None
                                events_ranking[group.event.id][user.id] = rank
                                LOGGER.info("\t\tResult: FINAL CREATION = " + str(events_ranking[group.event.id][user.id].overall_score))
                            events_ranking[group.event.id][user.id].overall_score += score
                            LOGGER.info("\t\tResult: FINAL score = " + str(events_ranking[group.event.id][user.id].overall_score))
                ranking = UserRanking.objects.filter(owner__id=user.id, group__id=group.id)
                if not ranking.exists():
                    ranking = UserRanking()
                    ranking.owner = user
                    ranking.group = group
                    ranking.overall_score = 0
                    ranking.rank = None
                    ranking.save()
                else:
                    ranking = ranking[0]
                if events_ranking[group.event.id].has_key(user.id):
                    ranking.overall_score = events_ranking[group.event.id][user.id].overall_score
                else:
                    ranking.overall_score = 0                    
                ranking.save()
        winner_setups = WinnerSetup.objects.filter(group__id=group.id)
        event_meta = get_event_meta(group.event)
        for a_setup in winner_setups:
            for per_type in a_setup.setup.all():
                LOGGER.info("Adding winner bets results for " + per_type.category.identifier)
                if per_type.category.identifier!='MATCH_WINNER':
                    data = [team['id'] for team in event_meta[per_type.category.identifier]['teams']]
                else:
                    last_match = group.event.matchs.filter(result__isnull=False, type__identifier='MATCH_FINAL')
                    if last_match.exists():
                        data = [last_match.first.id if last_match.result.first>last_match.result.second else last_match.second.id]
                    else:
                        data = []
                print data
                for user in list(group.members.all()) + list(group.owners.all()):
                    ranking = UserRanking.objects.get(owner__id=user.id, group__id=group.id)
                    winner = Winner.objects.filter(owner__id=user.id, event__id=group.event.id, category__identifier=per_type.category.identifier)
                    if winner.exists():
                        winner = winner[0]
                        found = len(winner.participants.filter(id__in=data))
                        if per_type.use_quotes:
                            LOGGER.info("User " + user.username + " found " + str(found) + " teams, adding " + str(found * per_type.points) + " points")
                            ranking.overall_score = ranking.overall_score + (found * per_type.points)
                        else:
                            LOGGER.info("User " + user.username + " found " + str(found) + " teams, adding " + str(POINTS_PER_TYPE[per_type.category.identifier][found]) + " points")
                            ranking.overall_score = ranking.overall_score + POINTS_PER_TYPE[per_type.category.identifier][found]
                        ranking.save()
        ranks = [UserRanking.objects.get(owner__id=user.id, group__id=group.id) for user in list(group.members.all()) + list(group.owners.all())]
        rank_list(ranks)
Example #3
0
def index(request):
    now = datetime.datetime.today()
    begin = dt.combine(datetime.date.today(), dt.min.time())
    end = dt.combine(dates.AddDay(begin, 14), dt.max.time())
    all_dates = Match.objects.filter(when__gte=begin, when__lte=end).order_by('when').dates('when','day')
    all_dates = [a_date.strftime('%Y-%m-%d') for a_date in all_dates]
    active_events = BettableEvent.objects.filter(end_date__gte=datetime.date.today).order_by('name')
    if request.user.is_authenticated and request.user.id!=None:
        user = User.objects.get(id=request.user.id)
        if get_user_meta(user)==None:
            initialize_user_meta(user)
        rankings = UserRanking.objects.filter(owner__id=user.id)
        if not rankings.exists():
            initial_ranking = UserRanking()
            initial_ranking.owner = user
            initial_ranking.group = None
            initial_ranking.overall_score = 0
            initial_ranking.rank = None
            initial_ranking.save()
            rankings = UserRanking.objects.filter(owner__id=user.id)
        global_ranking = UserRanking.objects.filter(owner__id=user.id, group=None)
        if global_ranking.exists():
            global_ranking = global_ranking[0]
        else:
            global_ranking = None

        admin_groups = Group.objects.filter(Q(owners__id__exact=request.user.id)).distinct().order_by('name')
        member_groups = Group.objects.filter(Q(members__id__exact=request.user.id) | Q(owners__id__exact=request.user.id)).distinct().order_by('name')

        winner_setups = []
        for group in list(admin_groups) + list(member_groups):
            setup = WinnerSetup.objects.filter(group__id=group.id, group__event__end_date__gte=now)
            if setup.exists():
                setup = setup[0]
                all_steps = setup.setup.all()
                if all_steps.exists():
                    if not group.event.id in winner_setups:
                        winner_setups.append(group.event.id)

        all_matches = Match.objects.filter(when__gte=begin, when__lte=end).order_by('when')
        all_bets = {}
        for match in all_matches:
            bet = Bet.objects.filter(owner__id=request.user.id, match__id=match.id)
            if bet.exists():
                bet = bet[0]
            else:
                bet = Bet()
                bet.clean()
                bet.owner = user
                bet.match = match
                bet.when = datetime.datetime.now()
                bet.winner = None
                score = Score()
                score.name = match.name
                score.first = 0
                score.second = 0
                score.save()
                bet.result = score
                bet.save()
            all_bets[bet.match.id] = {'id': bet.id, 'score': {'first':bet.result.first, 'second':bet.result.second}, 'enabled':str(bet.match.when + datetime.timedelta(minutes=10)>=now).lower(), 'amount': bet.amount if bet.amount!=None else 0}
        allow_amount = request.user.groups.filter(name='allow_amount')

        context = {'winner_setups': winner_setups, 'admin_groups': admin_groups,'member_groups': member_groups, 'all_dates': all_dates, 'all_bets': all_bets, 'rankings': rankings, 'global_rank':global_ranking, 'events': active_events, 'allow_amount': allow_amount, 'events': active_events}
    else:
        context = {'all_dates': all_dates, 'events': active_events, 'all_bets': []}
    return render(request,'index.html', context)
Example #4
0
def group_view(request):
    if request.user.is_authenticated and request.user.id != None:
        group_id = request.GET['group_id']
        user = User.objects.get(id=request.user.id)
        now = dt.now()
        try:
            group = Group.objects.get(id=group_id)
            if group.members.filter(
                    id=user.id).exists() or group.owners.filter(
                        id=user.id).exists():
                all_members = list(group.members.all()) + list(
                    group.owners.all())
                for member in all_members:
                    rank = UserRanking.objects.filter(owner__id=member.id,
                                                      group__id=group.id)
                    if not rank.exists():
                        rank = UserRanking()
                        rank.owner = member
                        rank.group = group
                        rank.overall_score = 0
                        rank.rank = None
                        rank.save()
                    else:
                        rank = rank[0]
                all_users = list(group.members.values_list(
                    'id', flat=True)) + list(
                        group.owners.values_list('id', flat=True))
                all_matchs = group.event.matchs.all().values_list('id',
                                                                  flat=True)

                betted_amounts = {}
                for user_id in all_users:
                    betted_amounts[user_id] = Bet.objects.filter(
                        owner__id=user_id, match__id__in=all_matchs).aggregate(
                            Sum('amount'))['amount__sum']
                locked_amounts = {}
                for user_id in all_users:
                    locked_amounts[user_id] = Bet.objects.filter(
                        owner__id=user_id,
                        match__id__in=all_matchs,
                        match__when__lte=now).aggregate(
                            Sum('amount'))['amount__sum']

                ranking = UserRanking.objects.filter(owner__id__in=all_users,
                                                     group__id=group.id)
                your_rank = UserRanking.objects.filter(owner__id=user.id,
                                                       group__id=group.id)
                if your_rank.exists():
                    your_rank = your_rank[0]
                allow_amount = request.user.groups.filter(name='allow_amount')
                context = {
                    'group': group,
                    'ranking': ranking,
                    'yours': your_rank,
                    'betted_amounts': betted_amounts,
                    'allow_amount': allow_amount,
                    'locked_amounts': locked_amounts
                }
                return render(request, 'group_view.html', context)
            else:
                raise PermissionDenied()
        except:
            traceback.print_exc()
            return HttpResponseBadRequest()
    else:
        raise PermissionDenied()
Example #5
0
def index(request):
    now = datetime.datetime.today()
    begin = dt.combine(datetime.date.today(), dt.min.time())
    end = dt.combine(dates.AddDay(begin, 14), dt.max.time())
    all_dates = Match.objects.filter(when__gte=begin,
                                     when__lte=end).order_by('when').dates(
                                         'when', 'day')
    all_dates = [a_date.strftime('%Y-%m-%d') for a_date in all_dates]
    active_events = BettableEvent.objects.filter(
        end_date__gte=datetime.date.today).order_by('name')
    if request.user.is_authenticated and request.user.id != None:
        user = User.objects.get(id=request.user.id)
        if get_user_meta(user) == None:
            initialize_user_meta(user)
        rankings = UserRanking.objects.filter(owner__id=user.id)
        if not rankings.exists():
            initial_ranking = UserRanking()
            initial_ranking.owner = user
            initial_ranking.group = None
            initial_ranking.overall_score = 0
            initial_ranking.rank = None
            initial_ranking.save()
            rankings = UserRanking.objects.filter(owner__id=user.id)
        global_ranking = UserRanking.objects.filter(owner__id=user.id,
                                                    group=None)
        if global_ranking.exists():
            global_ranking = global_ranking[0]
        else:
            global_ranking = None

        admin_groups = Group.objects.filter(
            Q(owners__id__exact=request.user.id)).distinct().order_by('name')
        member_groups = Group.objects.filter(
            Q(members__id__exact=request.user.id)
            | Q(owners__id__exact=request.user.id)).distinct().order_by('name')

        winner_setups = []
        for group in list(admin_groups) + list(member_groups):
            setup = WinnerSetup.objects.filter(group__id=group.id,
                                               group__event__end_date__gte=now)
            if setup.exists():
                setup = setup[0]
                all_steps = setup.setup.all()
                if all_steps.exists():
                    if not group.event.id in winner_setups:
                        winner_setups.append(group.event.id)

        all_matches = Match.objects.filter(when__gte=begin,
                                           when__lte=end).order_by('when')
        all_bets = {}
        for match in all_matches:
            bet = Bet.objects.filter(owner__id=request.user.id,
                                     match__id=match.id)
            if bet.exists():
                bet = bet[0]
            else:
                bet = Bet()
                bet.clean()
                bet.owner = user
                bet.match = match
                bet.when = datetime.datetime.now()
                bet.winner = None
                score = Score()
                score.name = match.name
                score.first = 0
                score.second = 0
                score.save()
                bet.result = score
                bet.save()
            all_bets[bet.match.id] = {
                'id':
                bet.id,
                'score': {
                    'first': bet.result.first,
                    'second': bet.result.second
                },
                'enabled':
                str(bet.match.when +
                    datetime.timedelta(minutes=10) >= now).lower(),
                'amount':
                bet.amount if bet.amount != None else 0
            }
        allow_amount = request.user.groups.filter(name='allow_amount')

        context = {
            'winner_setups': winner_setups,
            'admin_groups': admin_groups,
            'member_groups': member_groups,
            'all_dates': all_dates,
            'all_bets': all_bets,
            'rankings': rankings,
            'global_rank': global_ranking,
            'events': active_events,
            'allow_amount': allow_amount,
            'events': active_events
        }
    else:
        context = {
            'all_dates': all_dates,
            'events': active_events,
            'all_bets': []
        }
    return render(request, 'index.html', context)
def compute_group_ranking(group_id=None):
    today = dates.AddDay(datetime.date.today(), -1)
    if group_id == None:
        all_groups = Group.objects.filter(event__end_date__gte=today)
    else:
        all_groups = Group.objects.filter(id=group_id)
    for group in all_groups:
        if not group.owners.all()[0].groups.filter(
                name='allow_amount').exists():
            LOGGER.info("Working on group " + str(group.name))
            for user in list(group.members.all()) + list(group.owners.all()):
                LOGGER.info("\tWorking on user " + str(user.username))
                ranking = UserRanking.objects.filter(owner__id=user.id,
                                                     group__id=group.id)
                if not ranking.exists():
                    ranking = UserRanking()
                    ranking.owner = user
                    ranking.group = group
                    ranking.overall_score = 0
                    ranking.rank = None
                    ranking.save()
                else:
                    ranking = ranking[0]
                event_rank = EventRanking.objects.filter(
                    event__id=group.event.id, owner__id=user.id)
                if event_rank.exists():
                    event_rank = event_rank[0]
                    ranking.overall_score = event_rank.overall_score
                    ranking.save()
                else:
                    LOGGER.warn("User [" + str(user.id) +
                                "] has no rank in event:" +
                                str(group.event.name))
        else:
            LOGGER.info("Working on group with event and amount: " +
                        unicode(group.event.name))
            events_ranking = {}
            for user in list(group.members.all()) + list(group.owners.all()):
                LOGGER.info("\tWorking on user " + unicode(user.username))
                for match in group.event.matchs.filter(result__isnull=False):
                    LOGGER.info("\t\tWorking on match " + unicode(match.name))
                    bet = Bet.objects.filter(match__id=match.id,
                                             owner__id=user.id)
                    winner = match.get_winner()
                    LOGGER.info("\t\tWinner is " + unicode(winner))
                    if bet.exists():
                        bet = bet[0]
                        if bet.amount != None and bet.amount != 0:
                            score = bet.get_score()
                            if not events_ranking.has_key(group.event.id):
                                events_ranking[group.event.id] = {}
                            if not events_ranking[group.event.id].has_key(
                                    user.id):
                                rank = EventRanking()
                                rank.event = group.event
                                rank.owner = user
                                rank.overall_score = 0
                                rank.rank = None
                                events_ranking[group.event.id][user.id] = rank
                                LOGGER.info("\t\tResult: FINAL CREATION = " +
                                            str(events_ranking[group.event.id][
                                                user.id].overall_score))
                            events_ranking[group.event.id][
                                user.id].overall_score += score
                            LOGGER.info("\t\tResult: FINAL score = " +
                                        str(events_ranking[group.event.id][
                                            user.id].overall_score))
                ranking = UserRanking.objects.filter(owner__id=user.id,
                                                     group__id=group.id)
                if not ranking.exists():
                    ranking = UserRanking()
                    ranking.owner = user
                    ranking.group = group
                    ranking.overall_score = 0
                    ranking.rank = None
                    ranking.save()
                else:
                    ranking = ranking[0]
                if events_ranking[group.event.id].has_key(user.id):
                    ranking.overall_score = events_ranking[group.event.id][
                        user.id].overall_score
                else:
                    ranking.overall_score = 0
                ranking.save()
        winner_setups = WinnerSetup.objects.filter(group__id=group.id)
        event_meta = get_event_meta(group.event)
        for a_setup in winner_setups:
            for per_type in a_setup.setup.all():
                LOGGER.info("Adding winner bets results for " +
                            per_type.category.identifier)
                if per_type.category.identifier != 'MATCH_WINNER':
                    data = [
                        team['id'] for team in event_meta[
                            per_type.category.identifier]['teams']
                    ]
                else:
                    last_match = group.event.matchs.filter(
                        result__isnull=False, type__identifier='MATCH_FINAL')
                    if last_match.exists():
                        data = [
                            last_match.first.id if
                            last_match.result.first > last_match.result.second
                            else last_match.second.id
                        ]
                    else:
                        data = []
                print data
                for user in list(group.members.all()) + list(
                        group.owners.all()):
                    ranking = UserRanking.objects.get(owner__id=user.id,
                                                      group__id=group.id)
                    winner = Winner.objects.filter(
                        owner__id=user.id,
                        event__id=group.event.id,
                        category__identifier=per_type.category.identifier)
                    if winner.exists():
                        winner = winner[0]
                        found = len(winner.participants.filter(id__in=data))
                        if per_type.use_quotes:
                            LOGGER.info("User " + user.username + " found " +
                                        str(found) + " teams, adding " +
                                        str(found * per_type.points) +
                                        " points")
                            ranking.overall_score = ranking.overall_score + (
                                found * per_type.points)
                        else:
                            LOGGER.info(
                                "User " + user.username + " found " +
                                str(found) + " teams, adding " +
                                str(POINTS_PER_TYPE[
                                    per_type.category.identifier][found]) +
                                " points")
                            ranking.overall_score = ranking.overall_score + POINTS_PER_TYPE[
                                per_type.category.identifier][found]
                        ranking.save()
        ranks = [
            UserRanking.objects.get(owner__id=user.id, group__id=group.id)
            for user in list(group.members.all()) + list(group.owners.all())
        ]
        rank_list(ranks)