def admin(request):
admin_member = retrieve_member(request)
if not request.user.profile.is_ldap_admin:
return render(request, 'access_denied.html')
users = admin_member.list_users()
if request.method == 'POST':
form = AdminForm(request.POST, request=request, users=users)
if form.is_valid():
new_password = form.cleaned_data['password1']
admin_member.admin_change_password(form.cleaned_data['username'], new_password)
member = MemberValues(form.cleaned_data['username'], new_password)
member.set('sambaLMPassword', smbpasswd.lmhash(new_password))
member.set('sambaNTPassword', smbpasswd.nthash(new_password))
member.save()
new_form = AdminForm(request=request, users=users)
return render(request, 'admin.html',
{'message': _('The password for %s was changed. Thank you!' % form.cleaned_data['username']),
'form': new_form})
else:
return render(request, 'admin.html',
{'form': form})
else:
form = AdminForm(request=request, users=users)
return render(request, 'admin.html',
{'form': form})
def create_admin_view(corporation_slug_to_id, **kwargs):
roles = RoleAccess(
corporation_id=corporation_slug_to_id).roles_available_to_create_admin()
roles_to_choose = [(i.id, i.name) for i in roles]
form = AdminForm(roles_to_choose, corporation_slug_to_id)
next_page = request.args.get('next')
if request.method == 'POST':
if form.submit_admin.data and form.validate_on_submit():
AdminAccess(corporation_id=corporation_slug_to_id,
email=form.email_admin.data.strip(),
role_id=form.role_admin.data.strip()).create_admin()
flash('Your admin is now live!')
if next_page:
return redirect(next_page)
form.email_admin.data = ''
form.role_admin.data = ''
elif form.cancel_admin.data:
if next_page:
return redirect(next_page)
form.email_admin.data = ''
form.role_admin.data = ''
return render_template('create_admin.html', form=form)
def edit_admin(request, pk):
admin_form = AdminForm(prefix="adm")
user_form = UserForm(prefix="usr")
user = get_object_or_404(User, pk=pk)
admin = get_object_or_404(Admin, user_id=user.pk)
if request.method == 'POST':
admin_form = AdminForm(request.POST, prefix="adm", instance=admin)
user_form = UserForm(request.POST, prefix="usr", instance=admin.user)
if user_form.is_valid() and admin_form.is_valid():
user = user_form.save()
admin = admin_form.save(commit=False)
admin.user = user
admin.pic = request.FILES['adm-pic']
admin.save()
#request.user = user
request.user.save()
return redirect('admin_details', matriculation=admin.matriculation)
else:
messages.error(request, "Error")
return render(request, 'locker_manager/register_admin.html',{'admin_form':admin_form, 'user_form':user_form})
else:
admin_form = AdminForm(prefix="adm", instance=admin)
user_form = UserForm(prefix="usr", instance=admin.user)
return render(request, 'locker_manager/register_admin.html',{'admin_form':admin_form, 'user_form':user_form})
def admin():
form=AdminForm(request.form)
users=User.query.all()
choices=[]
if request.method=="GET" or request.method=="POST":
tags=Tag.query.all()
for tag in tags:
choices.append((tag.tagname,tag.tagname))
form.tags.choices=choices
if form.validate_on_submit()==True:
if form.add_new_admins()==True:
flash("Users [" + str(form.newadmins.data) + "] added to admins!")
if form.remove_admins()==True:
flash("Users [" + str(form.oldadmins.data) + "] removed from admins!")
if form.remove_tags()==True:
flash("Tags [" + str(form.tags.data) + "] removed!")
#Nollataan kaikki submitin jalkeen:
form.oldadmins.data=""
form.newadmins.data=""
choices=[]
tags=Tag.query.all()
for tag in tags:
choices.append((tag.tagname,tag.tagname))
form.tags.choices=choices
return render_template('admin_page.html',title="Admin Options",form=form,users=users)
def admins():
if request.method == 'POST':
form = AdminForm(request.form)
if form.validate():
admin = Admin()
form.populate_obj(admin)
admin.pw_hash = bcrypt.generate_password_hash(form.password.data)
g.db.session.add(admin)
g.db.session.commit()
login_user(get_admin(g.db, admin.email))
flash('Welcome to xAPI Scavenger Hunt', 'success')
logger.info(
'Admin registration form was submitted successfully for %s',
admin.email)
return make_response(render_template(
'settings.html', form=SettingForm()))
logger.info(
'Admin registration form was submitted with'
' invalid information. Errors: %s', form.errors)
flash(
'There was an error creating your admin profile.'
' Please try again.', 'warning')
return render_template(
'homepage.html', form=form, display_login_link=True)
return login()
def admin_page():
form = AdminForm()
if request.method == 'GET':
with g.db as cur:
sql = """select user_id,user_name,user_type,id from usertable
"""
cur.execute(sql)
user_list = [
dict(user_id=row[0],
user_name=row[1],
user_type=row[2],
id=row[3]) for row in cur.fetchall()
]
return render_template('modify.html', form=form, user_list=user_list)
else:
if form.validate_on_submit():
with g.db as cur:
sql = """insert into usertable(user_id,user_name,user_type) values('{0}','{1}','{2}')
""".format(form.user_id.data, form.user_name.data,
form.user_type.data)
cur.execute(sql)
flash('You have add a user!')
else:
flash(form.errors)
return redirect(url_for('admin_page'))
def admins():
if request.method == 'POST':
form = AdminForm(request.form)
if form.validate():
admin = Admin()
form.populate_obj(admin)
admin.pw_hash = bcrypt.generate_password_hash(form.password.data)
g.db.session.add(admin)
g.db.session.commit()
login_user(get_admin(g.db, admin.email))
flash('Welcome to xAPI Scavenger Hunt', 'success')
logger.info(
'Admin registration form was submitted successfully for %s',
admin.email)
return make_response(
render_template('settings.html', form=SettingForm()))
logger.info(
'Admin registration form was submitted with'
' invalid information. Errors: %s', form.errors)
flash(
'There was an error creating your admin profile.'
' Please try again.', 'warning')
return render_template('homepage.html',
form=form,
display_login_link=True)
return login()
def ItOpt(request):
if CheckAccess(request,'3') != 'OK':
return render_to_response("ithelpdesk/notaccess/opt.html")
### --- Сохранение закладки ----
request.session['bookmark'] = 'itopt'
if request.method == 'POST':
form = AdminForm(request.POST)
if form.is_valid():
admin = form.cleaned_data['admin']
AddAdminUser(admin)
try:
delete_admin = request.GET['delete_admin']
DelAdminUser(delete_admin)
except:
pass
form = AdminForm(None)
### --- Получение списка ---
data = GetAdminList()
c = RequestContext(request,{'form':form,'data':data})
c.update(csrf(request))
return render_to_response("ithelpdesk/opt.html",c)
def login():
userf = UserForm()
admin = AdminForm()
if userf.validate_on_submit():
comand = userf.comand_name.data
username = userf.username.data
password = userf.password.data
db_sess = db_session.create_session()
team = db_sess.query(Teams).filter(Teams.name == comand).filter(
Teams.name != 'Admins').first()
if team and check_password_hash(team.password_hash, password):
users = db_sess.query(
User.username).filter(User.team == team.name).all()
users_names = [x[0] for x in users]
if username in users_names:
login_user(
db_sess.query(User).filter(User.team == team.name).filter(
User.username == username).first())
return redirect("/user")
else:
if len(users) < 6:
us = User()
us.username = username
us.team = comand
db_sess.add(us)
db_sess.commit()
login_user(us)
return redirect("/user")
else:
return render_template('login.html',
form=userf,
adm_form=admin)
return render_template('login.html', form=userf, adm_form=admin)
if admin.validate_on_submit():
name = admin.ad_username.data
password = admin.ad_password.data
db_sess = db_session.create_session()
admins = db_sess.query(User).filter(User.username == name).filter(
User.role == 1).first()
team = db_sess.query(Teams).filter(Teams.name == 'Admins').first()
if admins and check_password_hash(team.password_hash, password):
login_user(admins)
return redirect('/admin')
else:
return render_template('login.html', form=userf, adm_form=admin)
return render_template('login.html',
title='Авторизация',
form=userf,
adm_form=admin)
def admin_page():
if not session.get('admin'):
form = AdminForm()
if form.validate_on_submit():
session['admin'] = True
return redirect('/admin/control')
return render_template('form.html', form=form)
else:
return redirect(url_for('admin.control'))
def admin():
form = AdminForm()
if form.is_submitted():
if form.stats1.data:
stats1()
return redirect(url_for("admin"))
if form.stats2.data:
stats2()
return redirect(url_for("admin"))
if form.notify.data:
notify()
return redirect(url_for("admin"))
return redirect(url_for("addevent"))
oracle_connection_string = 'oracle+cx_oracle://{username}:{password}@{host}:{port}/{sid}'
engine = create_engine(oracle_connection_string.format(
username="******",
password="******",
sid="XE",
host="localhost",
port="1521",
database="XE",
), echo=True)
with engine.connect() as conn:
events_count = conn.execute("SELECT COUNT(event_name) FROM EVENTS").fetchone()
event_names = conn.execute("SELECT EVENT_NAME FROM EVENTS")
tickets_left = conn.execute("SELECT QUANTITY_TIC FROM EVENTS")
event_times = conn.execute("SELECT EVENT_TIME FROM EVENTS")
prices = conn.execute("SELECT PRICE FROM EVENTS")
dict_event_names = TupleToDictionary(event_names)
dict_tickets_left = TupleToDictionary(tickets_left)
dict_event_times = TupleToDictionary(event_times)
dict_prices = TupleToDictionary(prices)
event_forms = []
for i in range(0, events_count[0]):
event = EventForm()
event.name.data = dict_event_names[i]
event.tickets_left.data = dict_tickets_left[i]
event.time.data = dict_event_times[i]
event.price.data = dict_prices[i]
event_forms.append(event)
form.events = event_forms
return render_template("admin.html", form=form)
def admin_login():
form = AdminForm()
if form.validate_on_submit():
admin = Admin.query.filter_by(username=form.username.data).first()
if admin is None or not admin.password == form.password.data:
flash("Invalid User name or Password", "error")
return redirect(url_for('admin_login'))
return redirect(url_for('admin', name=form.username.data))
return render_template('admin_login.htm', form=form)
def admin():
form = AdminForm()
if request.method == 'POST':
if form.validate_on_submit():
flash(f'The password is accepted', 'success')
return render_template('admin.html', title='Admin', form=form), 200
else:
flash(f'The password is not accepted', 'danger')
return render_template('admin.html', title='Admin', form=form), 403
return render_template('admin.html', title='Admin', form=form), 200
def admin(request):
""" Set up default admin account. """
admin_form = AdminForm()
if request.method == "POST":
admin_form = AdminForm(request.POST)
if admin_form.is_valid():
user = User.objects.create_user(admin_form.cleaned_data['username'], admin_form.cleaned_data['email_address'], admin_form.cleaned_data['password'])
user.is_staff = True
user.save()
print user
return redirect("index")
return render(request, "wizard/admin.html", {"form": admin_form})
def index(self):
spform = SetPhaseForm()
pnform = PhaseNomForm()
pvform = PhaseVoteForm()
psform = PhaseStaticForm()
bform = BanForm()
aform = AdminForm()
nform = NomIDForm()
cform = ClearForm()
if ((spform.static.data or spform.nom.data or spform.vote.data) and
spform.validate_on_submit()):
self.set_phase(spform)
return self.check_full_index()
if ((pnform.pnon.data and pnform.validate_on_submit()) or
pnform.pnoff.data):
self.phase_sched(pnform, 1)
return self.check_full_index()
if ((pvform.pvon.data and pvform.validate_on_submit()) or
pvform.pvoff.data):
self.phase_sched(pvform, 2)
return self.check_full_index()
if ((psform.pson.data and psform.validate_on_submit()) or
psform.psoff.data):
self.phase_sched(psform, 0)
return self.check_full_index()
if (bform.ban.data or bform.unban.data) and bform.validate_on_submit():
if self.ban(bform):
return self.check_full_index()
if (aform.give.data or aform.take.data) and aform.validate_on_submit():
self.change_admin(aform)
return self.check_full_index()
if ((nform.rem.data or nform.rwarn.data or nform.rban.data) and
nform.validate_on_submit()):
self.remove_nom(nform.nomid.data, nform.rwarn.data, nform.rban.data)
return self.check_full_index()
if ((cform.cnoms.data or cform.cvotes.data) and
cform.validate_on_submit()):
self.clear(cform)
return self.check_full_index()
full = self.get_full()
s = State.query.first()
if s.dtnom is not None:
pnform.dtnom.data = s.dtnom
if s.dtvote is not None:
pvform.dtvote.data = s.dtvote
if s.dtstatic is not None:
psform.dtstatic.data = s.dtstatic
return self.render("admin/index.html", spform=spform, pnform=pnform,
pvform=pvform, psform=psform, aform=aform, bform=bform, nform=nform,
cform=cform, awards=list_awards(), full=full, phase=phase())
def admin():
form = AdminForm(request.form)
u = get_user()
if u.is_admin():
if request.method == 'POST':
if not form.validate():
return render_template('admin/admin.html', form=form, user=get_user())
else:
return render_template('admin/admin.html', form=form, user=get_user())
else:
return render_template("admin/admin.html", form=form, user=get_user())
else:
return redirect(url_for('index'))
def edit_admin(request, pk):
admin_form = AdminForm(prefix="adm")
user_form = UserForm(prefix="usr")
user = get_object_or_404(User, pk=pk)
admin = get_object_or_404(Admin, user_id=user.pk)
if request.method == 'POST':
admin_form = AdminForm(request.POST, prefix="adm", instance=admin)
user_form = UserForm(request.POST, prefix="usr", instance=admin.user)
if user_form.is_valid() and admin_form.is_valid():
user = user_form.save()
admin = admin_form.save(commit=False)
admin.user = user
admin.pic = request.FILES['adm-pic']
admin.save()
#request.user = user
request.user.save()
return redirect('admin_details', matriculation=admin.matriculation)
else:
messages.error(request, "Error")
return render(request, 'locker_manager/register_admin.html', {
'admin_form': admin_form,
'user_form': user_form
})
else:
admin_form = AdminForm(prefix="adm", instance=admin)
user_form = UserForm(prefix="usr", instance=admin.user)
return render(request, 'locker_manager/register_admin.html', {
'admin_form': admin_form,
'user_form': user_form
})
def admin(request):
""" Set up default admin account. """
admin_form = AdminForm()
if request.method == "POST":
admin_form = AdminForm(request.POST)
if admin_form.is_valid():
user = User.objects.create_user(
admin_form.cleaned_data['username'],
admin_form.cleaned_data['email_address'],
admin_form.cleaned_data['password'])
user.is_staff = True
user.save()
print user
return redirect("index")
return render(request, "wizard/admin.html", {"form": admin_form})
def admin(page):
# Successful form submission
if request.method == 'POST':
form = Admin()
if form.validate_on_submit():
data = form.data
# Remove 'csrf_token' and 'submit' before writing to disk
del data['csrf_token']
del data['submit']
data = json.dumps(data)
# write data to file
# Don't overwrite form if not validated
if request.method == 'GET' or form.validate_on_submit():
# Read data from file
json_data = json.loads()
form = AdminForm(**json_data)
return flask.render_template('form.html', form=form)
# Data in files will just be an array of key, value pairs; Maybe like this:
# [
# { "key-one": "value-one" },
# { "key-two": "value-two" }
# ]
def admin_login():
form = AdminForm()
if request.method == 'POST':
if form.validate_on_submit():
user = Admin.query.filter_by(username=request.form['username']).first()
if user:
if check_password_hash(user.password, request.form['password']):
login_user(user)
session['admin'] = True
flash('Welcome Admin')
return redirect(url_for('index'))
else:
flash('Username or Password Invalid')
else:
flash('Username or Password Invalid')
return render_template('admin-login.html', form=form)
def register():
form = AdminForm(
request.form
) #we are using data from the htnl template directlt and not the form
username = request.form.get(
'username') #form.username.data, alternatively use the form data
password = request.form.get('password') #form.password.data
password1 = request.form.get('password1') #form.password1.data
msg = ''
if request.method == 'POST':
account = Account()
#Query the database and retrieve an account with similar data and if it exists, display errors
qry = db.session.query(Account).filter(id == id).filter(
Account.username == username).filter(Account.password == password)
existing_account = qry.first()
#print(existing_account.username)
if existing_account:
msg = 'Account already exists'
# elif not re.match(r'[A-Za-z0-9]+', username):#Validate username to use only numbers and letters
# msg = 'User name must contain only letters and numbers'#Dont forget to check how to validate frontend fields with re.match
elif password != password1: #authenticate password validation
msg = 'Passwords didnt match'
else:
save_user(account, new=True)
msg = 'Successfully registered'
elif request.method == 'POST':
msg = 'Please Fill in the form'
return render_template(
'register2.html',
msg=msg) #Incase of form errors use the form again to register
def admin_add():
form = AdminForm()
if form.validate_on_submit():
data = form.data
admin_num = Admin.query.filter_by(name=data['name']).count()
if admin_num == 1:
flash("管理员名称已经存在！", "err")
return redirect(url_for("admin.admin_add"))
from werkzeug.security import generate_password_hash
admin = Admin(name=data['name'],
pwd=generate_password_hash(data['pwd']),
role_id=data['role'])
db.session.add(admin)
db.session.commit()
flash("添加管理员成功！", "ok")
return redirect(url_for("admin.admin_list", page=1))
return render_template("admin/admin_add.html", form=form)
def register_admin(request):
admin_form = AdminForm(prefix="adm")
user_form = UserForm(prefix="usr")
if request.method == 'POST':
admin_form = AdminForm(request.POST, prefix="adm")
user_form = UserForm(request.POST, prefix="usr")
if user_form.is_valid() and admin_form.is_valid():
user = user_form.save()
admin = admin_form.save(commit=False)
admin.user = user
admin.save()
return redirect('locker_manager.views.admin_details', matriculation=admin.matriculation)
else:
messages.error(request, "Error")
return render(request, 'locker_manager/register_admin.html',{'admin_form':admin_form, 'user_form':user_form})
else:
return render(request, 'locker_manager/register_admin.html',{'admin_form':admin_form, 'user_form':user_form})
def admin_edit(id=None):
form = AdminForm()
admin = Admin.query.get_or_404(id)
if request.method == "GET":
form.pwd.data = admin.pwd
form.role.data = admin.role_id
if form.validate_on_submit():
data = form.data
admin_num = Admin.query.filter_by(name=data["name"]).count()
if admin.name != data["name"] and admin_num == 1:
flash("管理员名称已经存在！", "err")
return redirect(url_for("admin.admin_edit", id=id))
from werkzeug.security import generate_password_hash
admin.name = data["name"]
admin.pwd = generate_password_hash(data["pwd"])
admin.role_id = data["role"]
db.session.add(admin)
db.session.commit()
flash("修改管理员成功！", "ok")
return redirect(url_for("admin.admin_list", page=1))
return render_template("admin/admin_edit.html", form=form, admin=admin)
def login():
adminForm = AdminForm()
if adminForm.login.data == True:
admin = Admin.query.filter_by(email=adminForm.email.data).first()
if admin and bcrypt.check_password_hash(admin.password,
adminForm.password.data):
login_user(admin)
return redirect(url_for('home'))
else:
flash('Login Unsuccessful. Please check email and password',
'danger')
return render_template('login.html', adminForm=adminForm)
def register_admin(request):
admin_form = AdminForm(prefix="adm")
user_form = UserForm(prefix="usr")
if request.method == 'POST':
admin_form = AdminForm(request.POST, prefix="adm")
user_form = UserForm(request.POST, prefix="usr")
if user_form.is_valid() and admin_form.is_valid():
user = user_form.save()
admin = admin_form.save(commit=False)
admin.user = user
admin.save()
return redirect('locker_manager.views.admin_details',
matriculation=admin.matriculation)
else:
messages.error(request, "Error")
return render(request, 'locker_manager/register_admin.html', {
'admin_form': admin_form,
'user_form': user_form
})
else:
return render(request, 'locker_manager/register_admin.html', {
'admin_form': admin_form,
'user_form': user_form
})
def admin(request):
admin_member = retrieve_member(request)
if not request.user.profile.is_ldap_admin:
return render(request, 'access_denied.html')
users = admin_member.list_users()
if request.method == 'POST':
form = AdminForm(request.POST, request=request, users=users)
if form.is_valid():
new_password = form.cleaned_data['password1']
admin_member.admin_change_password(form.cleaned_data['username'],
new_password)
member = MemberValues(form.cleaned_data['username'], new_password)
member.set('sambaLMPassword', smbpasswd.lmhash(new_password))
member.set('sambaNTPassword', smbpasswd.nthash(new_password))
member.save()
new_form = AdminForm(request=request, users=users)
return render(
request, 'admin.html', {
'message':
_('The password for %s was changed. Thank you!' %
form.cleaned_data['username']),
'form':
new_form
})
else:
return render(request, 'admin.html', {'form': form})
else:
form = AdminForm(request=request, users=users)
return render(request, 'admin.html', {'form': form})
def admin():
form = AdminForm()
if form.validate_on_submit():
username = form.username.data
password = form.password.data
#authenticate returns the username
admin = Admin.authenticate(username, password)
if admin:
do_login(admin)
return redirect(f'/{get_route()}/admin-home')
else:
return render_template('admin-login.html', form=form)
#if admin not logged in then show the login form
if not g.user:
return render_template('admin-login.html', form=form)
#if admin logged in the show admin home
else:
return redirect(f'{get_route()}/admin-home')
def popular_places():
try:
db = mysql.connect()
mycursor = db.cursor()
mycursor.execute("select distinct(city) from placedetails")
cities = []
for row in mycursor:
cities.append(row[0])
form = AdminForm()
form.city.choices = [(city, city) for city in cities]
if request.method == 'POST' and form.validate_on_submit():
cname = request.form['city']
subset = df_iplace[df_iplace['city'] == cname]
places = subset['placename'].value_counts().to_frame()
plot = bc.Bar(places.iloc[0:5, ],
label="index",
values="placename",
plot_width=1000,
plot_height=700,
legend="top_right",
bar_width=0.3,
min_border=30,
xlabel="Places",
ylabel="Count")
script, div = components(plot)
return render_template(
"admin.html",
form=form,
script=script,
title_text="Top 5 Places visited by people in ",
div=div,
bokeh_css=CDN.render_css(),
bokeh_js=CDN.render_js(),
city=cname)
return render_template("admin.html", form=form)
except:
print("Exception occured in admin")
finally:
db.close()
def admin():
form = AdminForm()
config_data = read_data()
for field in form:
field.data = config_data[field.name]
if request.method == 'POST':
request_data = request.form.to_dict()
json_object = json.dumps(request_data, indent=4)
f = open('ingenico_configuration.json', 'w')
f.write(json_object)
f.close()
flash('Success: Information has been updated.')
return redirect(url_for('admin'))
return render_template('admin.html', form=form, config_data=config_data)
def admin():
form = AdminForm()
if form.validate_on_submit():
if request.method == 'POST':
cu = conn.cursor()
admin_form = str(form.AdminID.data)
password_form = str(form.password.data)
select = ("SELECT AdminID,password "
"FROM AdminInfo1 "
"WHERE AdminID= ?")
cu.execute(select, [admin_form])
results = cu.fetchone()
print(results)
if admin_form and password_form in results:
flash('You have been logged in!', 'success')
print(results)
return redirect(url_for('adminhome'))
else:
flash('Login Unsuccessful. Please check username and password',
'danger')
return render_template('AdminLogin.html', title='Login', form=form)
def admin():
form = AdminForm()
info = []
info_friends = []
info_posts = []
info_comments = []
info_groups = []
len_post = 0
len_comment = 0
len_friends = 0
len_groups = 0
cur = mysql.connection.cursor()
cur.execute("select count(*) as count from User")
total_users = cur.fetchone()
cur.execute("select count(*) as count from Friends")
total_friends = cur.fetchone()
cur.execute("select count(*) as count from Posts")
total_posts = cur.fetchone()
cur.execute("select count(*) as count from Comment")
total_comments = cur.fetchone()
cur.execute("select count(*) as count from Groups")
total_groups = cur.fetchone()
cur.close()
total_users = total_users['count']
total_friends = total_friends['count']
total_posts = total_posts['count']
total_comments = total_comments['count']
total_groups = total_groups['count']
if form.validate_on_submit():
cur = mysql.connection.cursor()
cur.callproc("GETUSER_ADMIN_BY_USERNAME", [form.search.data])
user_info = cur.fetchone()
cur.close()
info.append(user_info)
cur = mysql.connection.cursor()
cur.callproc("GETFRIEND_ADMIN_BY_USERNAME", [form.search.data])
friends = cur.fetchall()
info_friends.append(friends)
cur.close()
cur = mysql.connection.cursor()
cur.callproc("GETPOST_ADMIN_BY_USERNAME", [form.search.data])
posts = cur.fetchall()
info_posts.append(posts)
cur.close()
cur = mysql.connection.cursor()
cur.callproc("GETCOMMENT_ADMIN_BY_USERNAME", [form.search.data])
comments = cur.fetchall()
info_comments.append(comments)
cur.close()
cur = mysql.connection.cursor()
cur.callproc("GETGROUP_ADMIN_BY_USERNAME", [form.search.data])
groups = cur.fetchall()
info_groups.append(groups)
cur.close()
print('info list: >>>>>>> ', info)
print('friend list: >>>>>> ', info_friends)
print('post list: >>>>>>> ', info_posts)
print('comment list: >>>>>>>> ', info_comments)
print('group list: >>>>>>>> ', info_groups)
len_post = len(info_posts[0])
len_comment = len(info_comments[0])
len_friends = len(info_friends[0])
len_groups = len(info_groups[0])
flash(f' User found', 'success')
# return redirect(url_for('admin'))
return render_template('admin.html',
title='Administrator',
form=form,
info=info,
info_friends=info_friends,
len_friends=len_friends,
info_posts=info_posts,
len_post=len_post,
len_comment=len_comment,
info_comments=info_comments,
ts=total_users,
tf=total_friends,
tp=total_posts,
tc=total_comments,
tg=total_groups,
len_c=len_comment,
len_p=len_post,
len_groups=len_groups,
info_groups=info_groups)
