def donationindex(request, event=None):
    event = viewutil.get_event(event)
    orderdict = {
        'amount': ('amount', ),
        'time': ('timereceived', ),
    }
    page = request.GET.get('page', 1)
    sort = request.GET.get('sort', 'time')

    try:
        order = int(request.GET.get('order', -1))
    except ValueError:
        order = -1

    donations = Donation.objects.filter(transactionstate='COMPLETED')

    if event.id:
        donations = donations.filter(event=event)
    donations = views_common.fixorder(donations, orderdict, sort, order)

    agg = donations.aggregate(amount=Sum('amount'), count=Count(
        'amount'), max=Max('amount'), avg=Avg('amount'))
    donations = donations.select_related('donor')
    pages = paginator.Paginator(donations, 50)
    try:
        pageinfo = pages.page(page)
    except paginator.PageNotAnInteger:
        pageinfo = pages.page(1)
    except paginator.EmptyPage:
        pageinfo = pages.page(pages.num_pages)
        page = pages.num_pages
    donations = pageinfo.object_list

    return views_common.tracker_response(request, 'tracker/donationindex.html', {'donations': donations, 'pageinfo':  pageinfo, 'page': page, 'agg': agg, 'sort': sort, 'order': order, 'event': event})

def password_reset(request):
  return auth_views.password_reset(request, 
    template_name='tracker/password_reset.html', 
    email_template_name='password_reset_template',
    password_reset_form=PostOfficePasswordResetForm,
    from_email=settings.EMAIL_FROM_USER, 
    extra_context={'event': viewutil.get_event(None), 'csrftoken': get_csrf_token(request)})

def donate(request, event):
    event = viewutil.get_event(event)
    if event.locked:
        raise Http404
    commentform, bidsform, prizesform = process_form(request, event)
    if not bidsform:  # redirect
        return commentform

    def bid_parent_info(bid):
        if bid != None:
            return {'name': bid.name, 'description': bid.description, 'parent': bid_parent_info(bid.parent)}
        else:
            return None

    def bid_info(bid):
        result = {
            'id': bid.id,
            'name': bid.name,
            'description': bid.description,
            'label': bid.full_label(not bid.allowuseroptions),
            'count': bid.count,
            'amount': bid.total,
            'goal': Decimal(bid.goal or '0.00'),
            'parent': bid_parent_info(bid.parent)
        }
        if bid.speedrun:
            result['runname'] = bid.speedrun.name
        if bid.suggestions.exists():
            result['suggested'] = list(
                map(lambda x: x.name, bid.suggestions.all()))
        if bid.allowuseroptions:
            result['custom'] = ['custom']
            result['label'] += ' (select and add a name next to "New Option Name")'
        return result

    bids = filters.run_model_query('bidtarget', {'state': 'OPENED', 'event': event.id}, user=request.user).distinct(
    ).select_related('parent').prefetch_related('suggestions')

    allPrizes = filters.run_model_query(
        'prize', {'feed': 'current', 'event': event.id})

    prizes = allPrizes.filter(ticketdraw=False)

    dumpArray = [bid_info(o) for o in bids]

    bidsJson = json.dumps(dumpArray, ensure_ascii=False,
                          cls=serializers.json.DjangoJSONEncoder)

    ticketPrizes = allPrizes.filter(ticketdraw=True)

    def prize_info(prize):
        result = {'id': prize.id, 'name': prize.name, 'description': prize.description,
                  'minimumbid': prize.minimumbid, 'maximumbid': prize.maximumbid, 'sumdonations': prize.sumdonations}
        return result

    dumpArray = [prize_info(o) for o in ticketPrizes.all()]
    ticketPrizesJson = json.dumps(
        dumpArray, ensure_ascii=False, cls=serializers.json.DjangoJSONEncoder)

    return views_common.tracker_response(request, "tracker/donate.html", {'event': event, 'bidsform': bidsform, 'prizesform': prizesform, 'commentform': commentform, 'hasBids': bids.count() > 0, 'bidsJson': bidsJson, 'hasTicketPrizes': ticketPrizes.count() > 0, 'ticketPrizesJson': ticketPrizesJson, 'prizes': prizes})

def tracker_response(request=None, template='tracker/index.html', qdict=None, status=200):
  starttime = datetime.datetime.now()
  language = translation.get_language_from_request(request)
  translation.activate(language)
  request.LANGUAGE_CODE = translation.get_language()
  profile = None
  qdict = qdict or {}
  qdict.update({
    'djangoversion' : dv(),
    'pythonversion' : pv(),
    'user' : request.user,
    'profile' : profile,
    'next' : request.POST.get('next', request.GET.get('next', request.path)),
    'starttime' : starttime,
    'events': tracker.models.Event.objects.all(),
    })
  qdict.setdefault('event',viewutil.get_event(None))
  try:
    resp = render(request, template, dictionary=qdict, status=status)
    if 'queries' in request.GET and request.user.has_perm('tracker.view_queries'):
      return HttpResponse(json.dumps(connection.queries, ensure_ascii=False, indent=1),content_type='application/json;charset=utf-8')
    return resp
  except Exception,e:
    if request.user.is_staff and not settings.DEBUG:
      return HttpResponse(unicode(type(e)) + '\n\n' + unicode(e), mimetype='text/plain', status=500)
    raise

def password_reset(request):
  return djauth_views.password_reset(request,
    template_name='tracker/password_reset.html',
    email_template_name='password_reset_template',
    password_reset_form=forms.PostOfficePasswordResetForm,
    from_email=viewutil.get_default_email_from_user(),
    extra_context={'event': viewutil.get_event(None), 'csrftoken': get_csrf_token(request)})

def bidindex(request, event=None):
  event = viewutil.get_event(event)
  searchForm = BidSearchForm(request.GET)
  
  if not searchForm.is_valid():
    return HttpResponse('Invalid filter form', status=400)
    
  searchParams = {}
  searchParams.update(request.GET)
  searchParams.update(searchForm.cleaned_data)
  
  if event.id:
    searchParams['event'] = event.id
  else:
    return HttpResponseRedirect(reverse('tracker.views.bidindex', args=(Event.objects.latest().id,)))
    
  bids = filters.run_model_query('bid', searchParams, user=request.user)
  bids = bids.filter(parent=None)
  total = bids.aggregate(Sum('total'))['total__sum'] or Decimal('0.00')
  choiceTotal = bids.filter(goal=None).aggregate(Sum('total'))['total__sum'] or Decimal('0.00')
  challengeTotal = bids.exclude(goal=None).aggregate(Sum('total'))['total__sum'] or Decimal('0.00')
  bids = viewutil.get_tree_queryset_descendants(Bid, bids, include_self=True).prefetch_related('options')
  bids = bids.filter(parent=None)
  
  if event.id:
    bidNameSpan = 2
  else:
    bidNameSpan = 1
    
  return views_common.tracker_response(request, 'tracker/bidindex.html', { 'searchForm': searchForm, 'bids': bids, 'total': total, 'event': event, 'bidNameSpan' : bidNameSpan, 'choiceTotal': choiceTotal, 'challengeTotal': challengeTotal })

def password_reset_confirm(request):
  uidb64 = request.GET['uidb64']
  token = request.GET['token']
  return djauth_views.password_reset_confirm(request,
    uidb64,
    token,
    template_name='tracker/password_reset_confirm.html',
    extra_context={'event': viewutil.get_event(None), 'csrftoken': get_csrf_token(request)})

 def handle(self, *args, **options):
     event = viewutil.get_event(options['event'])
     prizes = prizemail.prizes_with_submission_email_pending(event)
     emailTemplate = options['template'] or event.prizecontributoremailtemplate
     
     if emailTemplate == None:
         print("No default prize accept/deny email template specified on event {0}, cannot send e-mails.".format(event.short))
     else:
         prizemail.automail_prize_contributors(event, prizes, emailTemplate)

def donorindex(request, event=None):
    event = viewutil.get_event(event)
    orderdict = {
        "name": ("donor__lastname", "donor__firstname"),
        "total": ("donation_total",),
        "max": ("donation_max",),
        "avg": ("donation_avg",),
    }
    page = request.GET.get("page", 1)
    sort = request.GET.get("sort", "name")

    if sort not in orderdict:
        sort = "name"

    try:
        order = int(request.GET.get("order", 1))
    except ValueError:
        order = 1

    donors = DonorCache.objects.filter(event=event.id if event.id else None).order_by(*orderdict[sort])
    if order == -1:
        donors = donors.reverse()

    fulllist = request.user.has_perm("tracker.view_full_list") and page == "full"
    pages = paginator.Paginator(donors, 50)

    if fulllist:
        pageinfo = {
            "paginator": pages,
            "has_previous": False,
            "has_next": False,
            "paginator.num_pages": pages.num_pages,
        }
        page = 0
    else:
        try:
            pageinfo = pages.page(page)
        except paginator.PageNotAnInteger:
            pageinfo = pages.page(1)
        except paginator.EmptyPage:
            pageinfo = pages.page(pages.num_pages)
            page = pages.num_pages
        donors = pageinfo.object_list

    return views_common.tracker_response(
        request,
        "tracker/donorindex.html",
        {
            "donors": donors,
            "event": event,
            "pageinfo": pageinfo,
            "page": page,
            "fulllist": fulllist,
            "sort": sort,
            "order": order,
        },
    )

 def handle(self, *args, **options):
     event = viewutil.get_event(options['event'])
     prizeWinners = prizemail.prizes_with_winner_accept_email_pending(event)
     emailTemplate = options['template'] or event.prizewinneracceptemailtemplate
     
     if emailTemplate == None:
         print("No default prize winner accepted email template specified on event {0}, cannot send e-mails.".format(event.short))
     else:
         prizemail.automail_winner_accepted_prize(event, prizeWinners, emailTemplate)

def donor(request,id,event=None):
  try:
    event = viewutil.get_event(event)
    donor = DonorCache.objects.get(donor=id,event=event.id if event.id else None)
    donations = donor.donation_set.filter(transactionstate='COMPLETED')
    if event.id:
      donations = donations.filter(event=event)
    comments = 'comments' in request.GET
    return tracker_response(request, 'tracker/donor.html', { 'donor' : donor, 'donations' : donations, 'comments' : comments, 'event' : event })
  except DonorCache.DoesNotExist:
    return tracker_response(request, template='tracker/badobject.html', status=404)

def donor(request,id,event=None):
  try:
    event = viewutil.get_event(event)
    donor = Donor.objects.get(pk=id)
    donations = donor.donation_set.filter(transactionstate='COMPLETED');
    if event.id:
      donations = donations.filter(event=event)
    comments = 'comments' in request.GET
    agg = donations.aggregate(amount=Sum('amount'), count=Count('amount'), max=Max('amount'), avg=Avg('amount'))
    return tracker_response(request, 'tracker/donor.html', { 'donor' : donor, 'donations' : donations, 'agg' : agg, 'comments' : comments, 'event' : event })
  except Donor.DoesNotExist:
    return tracker_response(request, template='tracker/badobject.html', status=404)

    def handle(self, *args, **options):
        super(Command, self).handle(*args, **options)

        event = viewutil.get_event(options['event'])
        prizeWinners = prizemail.prizes_with_winner_accept_email_pending(event)
        emailTemplate = options['template'] or event.prizewinneracceptemailtemplate
        dryRun = options['dry_run']

        if emailTemplate == None:
            self.message("No default prize winner accepted email template specified on event {0}, cannot send e-mails.".format(event.short))
        else:
            prizemail.automail_winner_accepted_prize(event, prizeWinners, emailTemplate, verbosity=self.verbosity, dry_run=dryRun)

def runindex(request,event=None):
  event = viewutil.get_event(event)
  searchForm = RunSearchForm(request.GET)
  if not searchForm.is_valid():
    return HttpResponse('Invalid Search Data', status=400)
  searchParams = {}
  searchParams.update(request.GET)
  searchParams.update(searchForm.cleaned_data)
  if event.id:
    searchParams['event'] = event.id
  runs = filters.run_model_query('run', searchParams, user=request.user)
  runs = runs.select_related('runners').annotate(hasbids=Sum('bids'))
  return tracker_response(request, 'tracker/runindex.html', { 'searchForm': searchForm, 'runs' : runs, 'event': event })

def prizeindex(request,event=None):
  event = viewutil.get_event(event)
  searchForm = PrizeSearchForm(request.GET)
  if not searchForm.is_valid():
    return HttpResponse('Invalid Search Data', status=400)
  searchParams = {}
  searchParams.update(request.GET)
  searchParams.update(searchForm.cleaned_data)
  if event.id:
    searchParams['event'] = event.id
  prizes = filters.run_model_query('prize', searchParams, user=request.user)
  prizes = prizes.select_related('startrun','endrun','category').prefetch_related('prizewinner_set')
  return tracker_response(request, 'tracker/prizeindex.html', { 'searchForm': searchForm, 'prizes' : prizes, 'event': event })

def donationindex(request,event=None):
  event = viewutil.get_event(event)
  orderdict = {
    'name'   : ('donor__lastname', 'donor__firstname'),
    'amount' : ('amount', ),
    'time'   : ('timereceived', ),
  }
  page = request.GET.get('page', 1)
  sort = request.GET.get('sort', 'time')
  
  if sort not in orderdict:
    sort = 'time'
    
  try:
    order = int(request.GET.get('order', -1))
  except ValueError:
    order = -1
    
  searchForm = DonationSearchForm(request.GET)
  
  if not searchForm.is_valid():
    return HttpResponse('Invalid Search Data', status=400)
    
  searchParams = {}
  searchParams.update(request.GET)
  searchParams.update(searchForm.cleaned_data)
  
  if event.id:
    searchParams['event'] = event.id
    
  donations = filters.run_model_query('donation', searchParams, user=request.user)
  donations = views_common.fixorder(donations, orderdict, sort, order)
  fulllist = request.user.has_perm('tracker.view_full_list') and page == 'full'
  agg = donations.aggregate(amount=Sum('amount'), count=Count('amount'), max=Max('amount'), avg=Avg('amount'))
  pages = paginator.Paginator(donations,50)
  if fulllist:
    pageinfo = { 'paginator' : pages, 'has_previous' : False, 'has_next' : False, 'paginator.num_pages' : pages.num_pages }
    page = 0
  else:
    try:
      pageinfo = pages.page(page)
    except paginator.PageNotAnInteger:
      pageinfo = pages.page(1)
    except paginator.EmptyPage:
      pageinfo = pages.page(paginator.num_pages)
      page = pages.num_pages
    donations = pageinfo.object_list
    
  return views_common.tracker_response(request, 'tracker/donationindex.html', { 'searchForm': searchForm, 'donations' : donations, 'pageinfo' :  pageinfo, 'page' : page, 'fulllist' : fulllist, 'agg' : agg, 'sort' : sort, 'order' : order, 'event': event })

    def handle(self, *args, **options):
        hasPrize = 'prize' in options
        hasEvent = 'event' in options

        if hasPrize and hasEvent:
            print("Error, cannot specify both a single prize and event.")
        if not hasPrize and not hasEvent:
            print("Error, must specify either a prize or an event.")

        if hasPrize:
            prizeId = int(options['prize'])
            prize = models.Prize(pk=prizeId)
            self.draw_prize(prize)
        elif hasEvent:
            event = viewutil.get_event(options['event'])
            for prize in models.Prize.objects.filter(event=event, state='ACCEPTED'):
                self.draw_prize(prize)

    def handle(self, *args, **options):
        super(Command, self).handle(*args, **options)

        hasPrize = options['prize'] != None
        hasEvent = options['event'] != None
        dryRun = options['dry_run']

        prizeSet = None

        if hasPrize:
            prizeId = int(options['prize'])
            prizeSet = models.Prize.objects.filter(pk=prizeId)
            if not prizeSet.exists():
                self.message("No prize with id {0} found.".format(prizeId))
                sys.exit(1)
            elif prizeSet[0].state != 'ACCEPTED':
                self.message(
                    "Prize {0} is not in an accepted state".format(prizeId))
                sys.exit(1)
        elif hasEvent:
            event = viewutil.get_event(options['event'])
            prizeSet = models.Prize.objects.filter(
                event=event, state='ACCEPTED')

        seed = options['seed']

        if seed:
            self.message("Using supplied seed {0}".format(seed))

        self.rand = random.Random(seed)

        if not prizeSet.exists():
            self.message("No prizes match the given query.")
        else:
            try:
                with transaction.atomic():
                    for prize in prizeSet:
                        self.draw_prize(prize)
                    if dryRun:
                        self.message("Rolling back operations...")
                        raise Exception("Cancelled due to dry run.")
            except:
                self.message("Rollback complete.")

        self.message("Completed.")

def donor(request, id, event=None):
    try:
        event = viewutil.get_event(event)
        donor = DonorCache.objects.get(donor=id, event=event.id if event.id else None)
        donations = donor.donation_set.filter(transactionstate="COMPLETED")

        if event.id:
            donations = donations.filter(event=event)

        comments = "comments" in request.GET

        return views_common.tracker_response(
            request,
            "tracker/donor.html",
            {"donor": donor, "donations": donations, "comments": comments, "event": event},
        )
    except DonorCache.DoesNotExist:
        return views_common.tracker_response(request, template="tracker/badobject.html", status=404)

    def handle(self, *args, **options):
        super(Command, self).handle(*args, **options)

        event = viewutil.get_event(options["event"])
        prizes = prizemail.prizes_with_submission_email_pending(event)
        emailTemplate = options["template"] or event.prizecontributoremailtemplate
        dryRun = options["dry_run"]

        if emailTemplate == None:
            self.message(
                "No default prize accept/deny email template specified on event {0}, cannot send e-mails.".format(
                    event.short
                )
            )
        else:
            prizemail.automail_prize_contributors(
                event, prizes, emailTemplate, verbosity=self.verbosity, dry_run=dryRun
            )