def editScoresKF(m):
[now,tomorrow]=getTiming()
form_R16 = GamesR16Form(request.form)
form_QF= GamesQFForm(request.form)
form_SF= GamesSFForm(request.form)
form_F= GamesFForm(request.form)
form=request.form
save=[None,m,[]] #later save[2] will be expanded with the games with integer errors
#later save[3] is the amount of saved games
saved_MD4=0
saved_MD5=0
saved_MD6=0
saved_MD7=0
user=User.query.filter_by(userName=session['userName']).first()
user_id=db.session.query(User).filter_by(userName=session['userName']).first().user_id
games=db.session.query(Games).filter_by(groep='N/A').all()
if request.method =='POST':
error=None
thisScores=[['','']]*len(list(games))
if user.activated==True:
for item in request.form:
if request.form[item]!='' and request.form[item]!=u'':
try:
int(request.form[item])
if int(request.form[item])<0:
save[0]=False
save[2].append(int(item[8:10]))
except:
save[0]=False
save[2].append(int(item[8:10]))
if save[0]!=False:
save[0]=True
save[2].sort()
if save[0]==True:
# #Update
try:
getScoresKF(form,user,user_id)
except:
"nooo"
scores=db.session.query(Scores).filter_by(userName=user.userName)\
.filter_by(groep='N/A').all()
[thisScores,saved_MD4,saved_MD5,saved_MD6,saved_MD7]=updateScoreFormsKP(scores,\
thisScores,saved_MD4,saved_MD5,saved_MD6,saved_MD7)
else: #IN THIS CASE THERE IS AN ERROR INPUT, A NON-INTEGER (however '' or u'' are not errored)
thisScores=[['','']]*len(list(games))
scores=db.session.query(Scores).filter_by(userName=user.userName)\
.filter_by(groep='N/A').all()
[saved_MD4,saved_MD5,saved_MD6,saved_MD7]=updateScoreFormsWithErrorKP(scores,\
saved_MD4,saved_MD5,saved_MD6,saved_MD7)
for item in request.form:
if str(item)[6]=='4':
if item[11] == 'l':
thisScores[int(item[8:10])-1]=[request.form[item],thisScores[int(item[8:10])-1][1]]
elif item[11] == 'r':
thisScores[int(item[8:10])-1]=[thisScores[int(item[8:10])-1][0],request.form[item]]
if str(item)[6]=='5':
if item[11] == 'l':
thisScores[int(item[8:10])-1+8]=[request.form[item],thisScores[int(item[8:10])-1+8][1]]
elif item[11] == 'r':
thisScores[int(item[8:10])-1+8]=[thisScores[int(item[8:10])-1+8][0],request.form[item]]
if str(item)[6]=='6':
if item[11] == 'l':
thisScores[int(item[8:10])-1+12]=[request.form[item],thisScores[int(item[8:10])-1+12][1]]
elif item[11] == 'r':
thisScores[int(item[8:10])-1+12]=[thisScores[int(item[8:10])-1+12][0],request.form[item]]
if str(item)[6]=='7':
if item[11] == 'l':
thisScores[int(item[8:10])-1+14]=[request.form[item],thisScores[int(item[8:10])-1+14][1]]
elif item[11] == 'r':
thisScores[int(item[8:10])-1+14]=[thisScores[int(item[8:10])-1+14][0],request.form[item]]
else: #NOT ACTIVATED YET
error=""" Your account is not yet activated. You can checkout the app, but your input won't be saved
since the payment is not yet confirmed."""
games_R16=db.session.query(Games).filter_by(fase='R16').all()
games_R16.sort(key=lambda x: (x.date,x.time))
games_QF=db.session.query(Games).filter_by(fase='QF').all()
games_QF.sort(key=lambda x: (x.date,x.time))
games_SF=db.session.query(Games).filter_by(fase='SF').all()
games_SF.sort(key=lambda x: (x.date,x.time))
games_F=db.session.query(Games).filter_by(fase='F').all()
games_F.sort(key=lambda x: (x.date,x.time))
for item in games:
if item.date <= now.date():
item.deadlinePassed=True
else:
item.deadlinePassed=False
item.date=datetime.datetime.strftime(item.date, "%A-%d %B %Y").split('-')
item.time=str(item.time)[0:5].replace(':','h')
return render_template('editScoresKF.html', form_R16=form_R16,form_QF=form_QF,form_SF=form_SF,\
form_F=form_F,save=save,scores=thisScores,\
saved_MD4=saved_MD4,saved_MD5=saved_MD5,saved_MD6=saved_MD6,saved_MD7=saved_MD7,\
games_R16=games_R16,games_QF=games_QF,games_SF=games_SF,games_F=games_F,error=error)
if request.method == 'GET':
error=None
scores=db.session.query(Scores).filter_by(userName=user.userName)\
.filter_by(groep='N/A').all()
thisScores=[['','']]*len(list(games))
[thisScores,saved_MD4,saved_MD5,saved_MD6,saved_MD7]=updateScoreFormsKP(scores,\
thisScores,saved_MD4,saved_MD5,saved_MD6,saved_MD7)
games_R16=db.session.query(Games).filter_by(fase='R16').all()
games_R16.sort(key=lambda x: (x.date,x.time))
games_QF=db.session.query(Games).filter_by(fase='QF').all()
games_QF.sort(key=lambda x: (x.date,x.time))
games_SF=db.session.query(Games).filter_by(fase='SF').all()
games_SF.sort(key=lambda x: (x.date,x.time))
games_F=db.session.query(Games).filter_by(fase='F').all()
games_F.sort(key=lambda x: (x.date,x.time))
for item in games:
if item.date <= now.date():
item.deadlinePassed=True
else:
item.deadlinePassed=False
item.date=datetime.datetime.strftime(item.date, "%A-%d %B %Y").split('-')
item.time=str(item.time)[0:5].replace(':','h')
return render_template('editScoresKF.html', form_R16=form_R16,form_QF=form_QF,form_SF=form_SF,\
form_F=form_F,save=save,scores=thisScores,\
saved_MD4=saved_MD4,saved_MD5=saved_MD5,saved_MD6=saved_MD6,saved_MD7=saved_MD7,\
games_R16=games_R16,games_QF=games_QF,games_SF=games_SF,games_F=games_F,error=error)
def enterScoresKP(m):
form_R16 = GamesR16Form(request.form)
form_QF= GamesQFForm(request.form)
form_SF= GamesSFForm(request.form)
form_F= GamesFForm(request.form)
form=request.form
save=[None,m,[]] #later save[2] will be expanded with the games with integer errors
#later save[3] is the amount of saved games
saved_MD4=0
saved_MD5=0
saved_MD6=0
saved_MD7=0
games=db.session.query(Games).filter_by(groep='N/A').all()
if request.method =='POST':
for item in request.form:
if request.form[item]!='' and request.form[item]!=u'':
try:
int(request.form[item])
except:
save[0]=False
save[2].append(int(item[8:10]))
if save[0]!=False:
save[0]=True
save[2].sort()
if save[0]==True:
# #Update
for i in range(len(games)):
if str(games[i].game)[2]==str(list(form)[0])[6]: #4/5/6 or 7
score_left = form['scoreM{0}_{1}_left'.format(str(list(form)[0])[6], str(games[i].game)[5:7])]
score_right = form['scoreM{0}_{1}_right'.format(str(list(form)[0])[6], str(games[i].game)[5:7])]
score=str(score_left)+'-'+str(score_right)
db.session.query(Games).filter_by(game=games[i].game).update({Games.score: score})
db.session.commit()
thisScores=[['','']]*len(list(games))
[thisScores,saved_MD4,saved_MD5,saved_MD6,saved_MD7]=updateScoreFormsKP(games,\
thisScores,saved_MD4,saved_MD5,saved_MD6,saved_MD7)
else: #IN THIS CASE THERE IS AN ERROR INPUT, A NON-INTEGER (however '' or u'' are not errored)
thisScores=[['','']]*len(list(games))
for item in request.form:
if item[11] == 'l':
thisScores[int(item[8:10])-1]=[request.form[item],thisScores[int(item[8:10])-1][1]]
elif item[11] == 'r':
thisScores[int(item[8:10])-1]=[thisScores[int(item[8:10])-1][0],request.form[item]]
games_R16=db.session.query(Games).filter_by(fase='R16').all()
games_QF=db.session.query(Games).filter_by(fase='QF').all()
games_SF=db.session.query(Games).filter_by(fase='SF').all()
games_F=db.session.query(Games).filter_by(fase='F').all()
for item in games:
item.date=datetime.datetime.strftime(item.date, "%A-%d %B %Y").split('-')
item.time=str(item.time)[0:5].replace(':','h')
return render_template('enterScoresKP.html', form_R16=form_R16,form_QF=form_QF,form_SF=form_SF,\
form_F=form_F,save=save,scores=thisScores,\
saved_MD4=saved_MD4,saved_MD5=saved_MD5,saved_MD6=saved_MD6,saved_MD7=saved_MD7,\
games_R16=games_R16,games_QF=games_QF,games_SF=games_SF,games_F=games_F)
if request.method == 'GET':
thisScores=[['','']]*len(list(games))
[thisScores,saved_MD4,saved_MD5,saved_MD6,saved_MD7]=updateScoreFormsKP(games,\
thisScores,saved_MD4,saved_MD5,saved_MD6,saved_MD7)
games_R16=db.session.query(Games).filter_by(fase='R16').all()
games_QF=db.session.query(Games).filter_by(fase='QF').all()
games_SF=db.session.query(Games).filter_by(fase='SF').all()
games_F=db.session.query(Games).filter_by(fase='F').all()
for item in games:
item.date=datetime.datetime.strftime(item.date, "%A-%d %B %Y").split('-')
item.time=str(item.time)[0:5].replace(':','h')
return render_template('enterScoresKP.html', form_R16=form_R16,form_QF=form_QF,form_SF=form_SF,\
form_F=form_F,save=save,scores=thisScores,\
saved_MD4=saved_MD4,saved_MD5=saved_MD5,saved_MD6=saved_MD6,saved_MD7=saved_MD7,\
games_R16=games_R16,games_QF=games_QF,games_SF=games_SF,games_F=games_F)
