def practice_form(request, id):
"""
need athlete, practice id,
"""
session_elements = list(
PracticeSection.objects.values(
'section__form__name', 'section__timer__id', 'section__name',
'section__description',
'id').filter(practice__id=id).order_by('order'))
athlete = get_user(request)
if request.session.get('practice_session') == None:
request.session['practice_session'] = session_elements
session_attributes = request.session.get('practice_session')[0]
elif len(request.session['practice_session']) >= 1:
session_attributes = request.session.get('practice_session')[0]
else:
request.session['practice_session'] = None
return redirect('practice_home')
if request.method == 'POST':
form = Form.objects.get(
name=session_attributes['section__form__name']).get_form(forms)(
request.POST)
if form.is_valid():
practice_section = form.save(commit=False)
debugging(DATE, athlete)
practice_section.session, created = Session.objects.get_or_create(
sessionDate=DATE, athlete=athlete)
practice_section.routine = Protocol.objects.get(
id=session_attributes['id'])
practice_section.save()
eval_form = []
request.session['practice_session'] = list(
request.session['practice_session'][1:])
return redirect('practice', '1')
else:
form = Form.objects.get(
name=session_attributes['section__form__name']).get_form(forms)()
description = session_attributes['section__description']
timer = Timer.objects.get(id=session_attributes['section__timer__id'])
section = session_attributes['section__name']
return render(
request, 'schedule/practice.html', {
'athlete': athlete,
'date': DATE,
'form': form,
'description': description,
'timer': mark_safe(timer.get_timer()),
'section': section
})
def practice_home(request):
athlete = get_user(request)
sessions = AssignedPractice.objects.filter(athlete=athlete)[:3]
test = 1
return render(request, 'schedule/home.html', {
'athlete': athlete,
'sessions': sessions,
'date': DATE
})
def create_post(request, protocol):
athlete = get_user(request)
protocol_object = Protocol.objects.get(name=protocol)
if request.method == 'POST':
form = protocol_object.form.get_form(forms)(request.POST)
print('Sanity')
if form.is_valid():
print('form')
protocol_data = form.save(commit=False)
debugging(DATE, athlete)
protocol_data.session, created = Session.objects.get_or_create(
sessionDate=DATE, athlete=athlete)
protocol_data.routine = protocol_object
protocol_data.save()
return JsonResponse({'success': True})
else:
return JsonResponse({'success': 'false', 'error': form.errors})
else:
return JsonResponse({'That': 'is this happening'})
def protocol_summary(request):
'''
Relies on django_highcharts for serializing data. Makes multiple chart
rendering on a page more simple, however it doesn't appear to allow much
in they way of customization.
define a range, avg, diplay max and min
'''
athlete = get_user(request)
data = BoulderingRoutineMetrics.objects.filter(session__athlete=athlete)
test = BoulderingRoutineMetrics.objects.values(
'min', 'max').filter(session__athlete=athlete)
df = read_frame(data, verbose=False)
df['avg'] = df['total_points'] / df['total_climbs']
df['range'] = df['max'] - df['min']
df = df.drop(['id', 'total_climbs', 'total_points'],
axis=1).set_index('session')
dataset = BoulderingRoutineMetrics.objects \
.values('session__sessionDate', 'min','max', 'total_points', 'total_climbs') \
.filter(session__athlete = athlete)
df2 = read_frame(dataset, verbose=False).rename(
columns={
'session__sessionDate': 'session date',
'min': 'min value',
'max': 'max value'
})
df3 = read_frame(dataset, fieldnames=['min','max'])\
.rename(columns={'session__sessionDate':'Session Date'})
# .drop(['total_points', 'total_climbs'])
df4 = df2.merge(df3, how='left', left_index=True, right_index=True)
df4['avg'] = df4['total_points'] / df4['total_climbs']
df4['range'] = df4['max value'] - df4['min value']
chart = serialize(df4,
render_to='my-chart',
kind="bar",
output_type='json')
return render(request, 'schedule/protocol_summary.html', {'chart': chart})
def protocol(request, protocol):
athlete = get_user(request)
protocol_object = Protocol.objects.get(name=protocol)
formset = protocol_object.form.formset
if request.method == "POST":
form = protocol_object.form.get_form(forms)(request.POST)
# if formset:
# if form.is_valid():
# for set in form:
# protocol_data = set.save(commit=False)
# debugging(DATE, athlete)
# protocol_data.session, created = Session.objects.get_or_create(sessionDate=DATE,
# athlete=athlete)
# protocol_data.routine = protocol_object
# try:
# protocol_data.save()
# except:
# continue
#
# return redirect('home')
if form.is_valid():
protocol_data = form.save(commit=False)
debugging(DATE, athlete)
protocol_data.session, created = Session.objects.get_or_create(
sessionDate=DATE, athlete=athlete)
protocol_data.routine = protocol_object
protocol_data.save()
return redirect('home')
else:
# if formset:
# form = protocol_object.form.get_form(forms)()
# else:
form = protocol_object.form.get_form(forms)()
grade = protocol_object.get_grade_level(athlete)
timer = protocol_object.timer
description = protocol_object.description
goal = protocol_object.goal
table = create_metric_data_table(protocol_object, athlete,
protocol_object.name)
if timer:
return render(
request, 'schedule/practice_ajax.html', {
'athlete': athlete,
'date': DATE,
'form': form,
'description': description,
'timer': mark_safe(timer.get_timer()),
'section': protocol_object,
'table': table,
'grade': grade
})
return render(
request, 'schedule/practice_ajax.html', {
'athlete': athlete,
'date': DATE,
'form': form,
'goal': goal,
'description': description,
'section': protocol_object,
"table": table,
'grade': grade
})
def chart_data(request):
"""
Uses Ajax call for dynamic rendering and allows access to all highchart features.
Appears to be more challenging to apply multiple charts to one page
"""
############ some day put in the time for asynchronous drilldown: https://www.highcharts.com/docs/chart-concepts/drilldown
athlete = get_user(request)
dataset = BoulderingRoutineMetrics.objects \
.values('session__sessionDate', 'min','max', 'total_points', 'total_climbs') \
.filter(session__athlete = athlete).order_by('session__sessionDate').reverse()[:5]
df = read_frame(dataset, verbose=False)
df['avg'] = (df['total_points'] / df['total_climbs']).round(1)
df['range'] = df['max'] - df['min']
categories = list(df['session__sessionDate'])
df = df.drop(columns=['session__sessionDate'])
columns = df.columns
lst = []
for item in columns:
lst.append({'name': item, 'data': df.loc[:, item].tolist()})
chart = {
'chart': {
'type': 'column'
},
'title': {
'text': 'Super Sick Chart'
},
# 'xAxis': {'categories': categories},
'series': [{
'name':
'Things',
'colorByPoint':
'true',
'data': [{
'name': 'Animals',
'y': 5,
'drilldown': 'animals'
}, {
'name': 'Fruits',
'y': 2,
'drilldown': 'fruits'
}, {
'name': 'Cars',
'y': 4,
'drilldown': 'cars'
}]
}],
'drilldown': {
'series': [{
'id':
'animals',
'data': [['Cats', 4], ['Dogs', 2], ['Cows', 1], ['Sheep', 2],
['Pigs', 1]]
}, {
'id': 'fruits',
'data': [['Apples', 4], ['Oranges', 2]]
}, {
'id': 'cars',
'data': [['Toyota', 4], ['Opel', 2], ['Volkswagen', 2]]
}]
},
# 'series': lst,
'plotOptions': {
'column': {
'dataLabels': {
'enabled': 'true'
}
}
}
}
return JsonResponse(chart)