def editTeam(team_id):
if 'username' not in login_session:
return redirect('/login')
team = session.query(Team).filter_by(id=team_id).one()
if team.created_by != login_session['user_id']:
return "<script>function myFunction() {alert('You are not authorized to edit this team. Please create your own team in order to edit.');}</script><body onload='myFunction()''>"
if request.method == "POST":
team.name = request.form['name']
team.locallity = request.form['locallity']
team.game_id = request.form['game_id']
team.is_active = '1' if request.form['status'] == 'Active' else '0'
team.name = request.form['name']
if team.logo != request.files['logo']:
file = request.files['logo']
if file and helper.allowed_file(file.filename):
extension = file.filename.rsplit('.', 1)
filename = secure_filename(file.filename)
filename = helper.hash_filename(filename) + "." + extension[1]
team.logo = filename
# saves file in file system
file.save(os.path.join(app.config['UPLOAD_FOLDER'], filename))
session.add(team)
session.commit()
flash('Team Successfully Edited %s' % team.name)
return redirect(url_for('showTeams'))
else:
games = session.query(Game)
return render_template('teams/editteam.html', team=team, games=games)
def newTeam():
if 'username' not in login_session:
return redirect('/login')
games = session.query(Game)
if request.method == "POST":
file = request.files['logo']
if file and helper.allowed_file(file.filename):
extension = file.filename.rsplit('.', 1)
filename = secure_filename(file.filename)
filename = helper.hash_filename(filename) + "." + extension[1]
# saves file in file system
file.save(os.path.join(app.config['UPLOAD_FOLDER'], filename))
else:
filename = 'no_logo.jpg'
strdate = request.form['start_year'].rsplit('/', 1)
dateObj = datetime.datetime.strptime(strdate[1], "%Y").date()
newTeam = Team(
name=request.form['name'],
locallity=request.form['locallity'],
logo=filename,
start_year=dateObj,
game_id=request.form['game_id'],
created_on=datetime.datetime.strptime(
strftime("%Y-%m-%d %H:%M:%S", localtime()),
"%Y-%m-%d %H:%M:%S"),
created_by=login_session['user_id'],
is_active='1' if request.form['status'] == 'Active' else '0',
is_delete='0',
)
session.add(newTeam)
session.commit()
flash('New Team %s Successfully Created' % newTeam.name)
return redirect(url_for('showTeams'))
else:
return render_template('teams/newteam.html', games=games)
def editPlayer(team_id, player_id):
if 'username' not in login_session:
return redirect('/login')
player = session.query(Player).filter_by(team_id=team_id, is_delete='0', id=player_id).one()
if player.created_by != login_session['user_id']:
return "<script>function myFunction() {alert('You are not authorized to edit this player. Please create your own player in order to edit.');}</script><body onload='myFunction()''>"
team = session.query(Team).filter_by(id=team_id).one()
skill_levels = ['Beginner', 'Intermediate', 'Advanced']
if request.method == "POST":
player.name=request.form['name']
player.email=request.form['email']
player.phone=request.form['phone']
player.skill_level=request.form['skill_level']
player.summary=request.form['summary']
player.is_active='1' if request.form['status'] == 'Active' else '0'
player.share_contact=request.form['share_contact']
if player.picture != request.files['picture']:
file = request.files['picture']
if file and helper.allowed_file(file.filename):
extension = file.filename.rsplit('.' ,1)
filename = secure_filename(file.filename)
filename = helper.hash_filename(filename)+"."+extension[1]
player.picture = filename
# saves file in file system
file.save(os.path.join(app.config['UPLOAD_FOLDER'], filename))
session.add(player)
session.commit()
flash('Player %s Edited Successfully' % player.name)
return redirect(url_for('showPlayers', team_id=team_id))
return render_template('players/editplayer.html', skill_levels=skill_levels, player=player,team=team)
def newPlayer(team_id):
if 'username' not in login_session:
return redirect('/login')
if request.method == "POST":
file = request.files['picture']
if file and helper.allowed_file(file.filename):
extension = file.filename.rsplit('.' ,1)
filename = secure_filename(file.filename)
filename = helper.hash_filename(filename)+"."+extension[1]
# saves file in file system
file.save(os.path.join(app.config['UPLOAD_FOLDER'], filename))
else:
filename = 'no_picture.jpg'
newPlayer = Player(
name=request.form['name'],
email=request.form['email'],
phone=request.form['phone'],
skill_level=request.form['skill_level'],
picture=filename,
summary=request.form['summary'],
team_id=team_id,
share_contact=request.form['share_contact'],
created_on=datetime.datetime.strptime(strftime("%Y-%m-%d %H:%M:%S", localtime()), "%Y-%m-%d %H:%M:%S"),
created_by=login_session['user_id'],
is_active='1' if request.form['status'] == 'Active' else '0',
is_delete='0',
)
session.add(newPlayer)
session.commit()
flash('New Player %s Successfully Created' % newPlayer.name)
return redirect(url_for('showPlayers', team_id=team_id))
else:
skill_levels = ['Beginner', 'Intermediate', 'Advanced']
return render_template('players/newplayer.html', skill_levels=skill_levels)
def editTeam(team_id):
if 'username' not in login_session:
return redirect('/login')
team = session.query(Team).filter_by(id=team_id).one()
if team.created_by != login_session['user_id']:
return "<script>function myFunction() {alert('You are not authorized to edit this team. Please create your own team in order to edit.');}</script><body onload='myFunction()''>"
if request.method=="POST":
team.name=request.form['name']
team.locallity=request.form['locallity']
team.game_id=request.form['game_id']
team.is_active='1' if request.form['status'] == 'Active' else '0'
team.name=request.form['name']
if team.logo != request.files['logo']:
file = request.files['logo']
if file and helper.allowed_file(file.filename):
extension = file.filename.rsplit('.' ,1)
filename = secure_filename(file.filename)
filename = helper.hash_filename(filename)+"."+extension[1]
team.logo = filename
# saves file in file system
file.save(os.path.join(app.config['UPLOAD_FOLDER'], filename))
session.add(team)
session.commit()
flash('Team Successfully Edited %s' % team.name)
return redirect(url_for('showTeams'))
else:
games= session.query(Game)
return render_template('teams/editteam.html', team=team, games=games)
def newTeam():
if 'username' not in login_session:
return redirect('/login')
games = session.query(Game)
if request.method == "POST":
file = request.files['logo']
if file and helper.allowed_file(file.filename):
extension = file.filename.rsplit('.' ,1)
filename = secure_filename(file.filename)
filename = helper.hash_filename(filename)+"."+extension[1]
# saves file in file system
file.save(os.path.join(app.config['UPLOAD_FOLDER'], filename))
else:
filename = 'no_logo.jpg'
strdate = request.form['start_year'].rsplit('/', 1)
dateObj = datetime.datetime.strptime(strdate[1], "%Y").date()
newTeam = Team(
name=request.form['name'],
locallity=request.form['locallity'],
logo=filename,
start_year=dateObj,
game_id=request.form['game_id'],
created_on=datetime.datetime.strptime(strftime("%Y-%m-%d %H:%M:%S", localtime()), "%Y-%m-%d %H:%M:%S"),
created_by=login_session['user_id'],
is_active='1' if request.form['status'] == 'Active' else '0',
is_delete='0',
)
session.add(newTeam)
session.commit()
flash('New Team %s Successfully Created' % newTeam.name)
return redirect(url_for('showTeams'))
else:
return render_template('teams/newteam.html', games=games)
def newPlayer(team_id):
if 'username' not in login_session:
return redirect('/login')
if request.method == "POST":
file = request.files['picture']
if file and helper.allowed_file(file.filename):
extension = file.filename.rsplit('.', 1)
filename = secure_filename(file.filename)
filename = helper.hash_filename(filename) + "." + extension[1]
# saves file in file system
file.save(os.path.join(app.config['UPLOAD_FOLDER'], filename))
else:
filename = 'no_picture.jpg'
newPlayer = Player(
name=request.form['name'],
email=request.form['email'],
phone=request.form['phone'],
skill_level=request.form['skill_level'],
picture=filename,
summary=request.form['summary'],
team_id=team_id,
share_contact=request.form['share_contact'],
created_on=datetime.datetime.strptime(
strftime("%Y-%m-%d %H:%M:%S", localtime()),
"%Y-%m-%d %H:%M:%S"),
created_by=login_session['user_id'],
is_active='1' if request.form['status'] == 'Active' else '0',
is_delete='0',
)
session.add(newPlayer)
session.commit()
flash('New Player %s Successfully Created' % newPlayer.name)
return redirect(url_for('showPlayers', team_id=team_id))
else:
skill_levels = ['Beginner', 'Intermediate', 'Advanced']
return render_template('players/newplayer.html',
skill_levels=skill_levels)
def editPlayer(team_id, player_id):
if 'username' not in login_session:
return redirect('/login')
player = session.query(Player).filter_by(team_id=team_id,
is_delete='0',
id=player_id).one()
if player.created_by != login_session['user_id']:
return "<script>function myFunction() {alert('You are not authorized to edit this player. Please create your own player in order to edit.');}</script><body onload='myFunction()''>"
team = session.query(Team).filter_by(id=team_id).one()
skill_levels = ['Beginner', 'Intermediate', 'Advanced']
if request.method == "POST":
player.name = request.form['name']
player.email = request.form['email']
player.phone = request.form['phone']
player.skill_level = request.form['skill_level']
player.summary = request.form['summary']
player.is_active = '1' if request.form['status'] == 'Active' else '0'
player.share_contact = request.form['share_contact']
if player.picture != request.files['picture']:
file = request.files['picture']
if file and helper.allowed_file(file.filename):
extension = file.filename.rsplit('.', 1)
filename = secure_filename(file.filename)
filename = helper.hash_filename(filename) + "." + extension[1]
player.picture = filename
# saves file in file system
file.save(os.path.join(app.config['UPLOAD_FOLDER'], filename))
session.add(player)
session.commit()
flash('Player %s Edited Successfully' % player.name)
return redirect(url_for('showPlayers', team_id=team_id))
return render_template('players/editplayer.html',
skill_levels=skill_levels,
player=player,
team=team)
