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)