from django import forms
from django.contrib.admin.widgets import AdminDateWidget
import glob

class CsvForm(forms.Form):
    file = forms.FileField(label='CSV File')
    # comment = forms.CharField(required=False)

class TimeTeamForm(forms.Form):
    resulturl = forms.URLField()
    startorder = forms.IntegerField(initial=1,label='First result to process')

columns = ['Rank 1','Rank2','Score 1', 'Score 2','Positions Climbed','Score Increase']
choices = [
    ('Rank1','Rank 1'),
    ('Rank2','Rank 2'),
    ('PositionsClimbed','Positions Climbed'),
    ('ScoreIncrease','Score Increase')
]


class DatesForm(forms.Form):
    filenameslist = glob.glob('media/boatmovers_*.csv')
    filenameslist.sort()
    datechoices = [
        (a[17:-4],a[17:-4]) for a in filenameslist
    ]
    date1 = forms.ChoiceField(choices=datechoices)
    date2 = forms.ChoiceField(choices=datechoices)
    sort_by = forms.ChoiceField(choices=choices)
    ascending = forms.BooleanField(initial=True,required=False)
    limit_to_first = forms.IntegerField(initial=100)
    gender = forms.ChoiceField(choices=(('all','all'),('f','f'),('m','m')))