def my_group3():
teacher = get_current_teacher()
try:
if not teacher:
return redirect(url_for('home'))
except AttributeError:
return redirect(url_for('home'))
user = get_current_user()
groups = Groups.query.filter_by(teacher_1=teacher.id).first()
teach = Teachers.query.filter_by(id=teacher.id).all()
for gr1 in teach:
group = Groups.query.filter_by(id=gr1.group3)
for gr in group:
query = Student.query.filter(
or_(Student.group1 == gr.id, Student.group2 == gr.id,
Student.group3 == gr.id)).order_by('id')
return render_template('Teacher/my group3.html',
groups=groups,
group=group,
teacher=teacher,
user=user,
query=query)
return render_template('Teacher/my group3.html',
groups=groups,
teacher=teacher,
user=user)
def overhead():
user = get_current_user()
try:
if not user.gazalkent_admin and not user.director and not user.xojakent_admin:
return redirect(url_for('home'))
except AttributeError:
return redirect(url_for('home'))
if request.method == 'POST':
reason = request.form.get('reason')
amount = request.form.get('amount')
sums = int(request.form.get('sum'))
now = datetime.now()
save = Overhead(reason=reason,
quantity=amount,
sum=sums,
payed_data=now)
db.session.add(save)
db.session.commit()
sum = All_overhead.query.filter_by(id=1).first()
total = sum.total_sum + sums
All_overhead.query.filter_by(id=1).update({'total_sum': total})
db.session.commit()
return redirect(url_for('overhead'))
over = Overhead.query.order_by('id').all()
all_over = All_overhead.query.order_by('id').all()
return render_template('payment/overhead.html',
user=user,
over=over,
all_over=all_over)
def teacher_search():
user = get_current_user()
try:
if not user.gazalkent_admin and not user.director and not user.xojakent_admin:
return redirect(url_for('home'))
except AttributeError:
return redirect(url_for('home'))
payment = request.form.get('teacher_payment')
name1 = request.form.get('teacher_payment').upper()
surname1 = request.form.get('teacher_payment').upper()
number1 = request.form.get('teacher_payment')
gmails = Teachers.query.filter_by(username=payment).all()
for gmail in gmails:
if gmail.username == payment:
return render_template('payment/payment_teacher.html',
gmails=gmails,
user=user)
names = Teachers.query.filter_by(name=name1).all()
for name in names:
if name.name == name1:
return render_template('payment/teacher_name.html',
user=user,
names=names)
surnames = Teachers.query.filter_by(surname=surname1).all()
for surname in surnames:
if surname.surname == surname1:
return render_template('payment/teacher_surname.html',
user=user,
surnames=surnames)
numbers = Teachers.query.filter_by(phone=number1).all()
for number in numbers:
if number.phone == number1:
return render_template('payment/teacher_phone.html',
user=user,
number=numbers)
def capital():
user = get_current_user()
try:
if not user.gazalkent_admin and not user.director and not user.xojakent_admin:
return redirect(url_for('home'))
except AttributeError:
return redirect(url_for('home'))
if request.method == 'POST':
name_item = request.form.get('name_item')
number_item = int(request.form.get('number_item'))
sums = int(request.form.get('amount_item'))
now = datetime.now()
save = Capital_expenditure(item=name_item,
number_items=number_item,
amount_item=sums,
bought_data=now)
db.session.add(save)
db.session.commit()
sum = All_Capital_Expenditure.query.filter_by(id=1).first()
total = sum.total_sum + sums
All_Capital_Expenditure.query.filter_by(id=1).update(
{'total_sum': total})
db.session.commit()
return redirect(url_for('capital'))
capitals = Capital_expenditure.query.order_by('id').all()
all_capitals = All_Capital_Expenditure.query.order_by('id').all()
return render_template('payment/capital.html',
user=user,
capitals=capitals,
all_capitals=all_capitals)
def homepage():
if request.method == 'GET':
if 'account' in session:
account = mongo.db.Accounts.find_one({'Email': session['account'][1]})
userFiles = orderFilesInfo(account['Files'])
userSpaceUsed = '0M'
if 'M' in size(account['SpaceUsed']):
userSpaceUsed = size(account['SpaceUsed'])
if request.args.get('nospaceleft') is None:
nospace = 0
else:
nospace = 1
return render_template('logged/home.html', nospace = nospace, userName = session['account'][0], userEmail = session['account'][1], userFiles = enumerate(userFiles), userSpaceUsed = userSpaceUsed, userSpaceLimit = size(account['SpaceLimit']))
else:
return redirect(url_for('loginpage'))
account = mongo.db.Accounts.find_one({'Email': request.form['userEmail']})
if account is not None:
if (account['Password'] == request.form['userPassword']):
userFiles = orderFilesInfo(account['Files'])
session['account'] = [account['FirstName'], account['Email'], userFiles, account['SpaceUsed'], account['SpaceLimit']]
userSpaceUsed = '0M'
if 'M' in size(account['SpaceUsed']):
userSpaceUsed = size(account['SpaceUsed'])
return render_template('logged/home.html', nospace=0, userName = account['FirstName'], userEmail = session['account'][1], userFiles = enumerate(userFiles), userSpaceUsed = userSpaceUsed, userSpaceLimit = size(account['SpaceLimit']))
return redirect(url_for('loginpage', invalid=1))
def calculate(id):
user = get_current_user()
try:
if not user.gazalkent_admin and not user.director and not user.xojakent_admin:
return redirect(url_for('home'))
except AttributeError:
return redirect(url_for('home'))
money = int(request.form.get('pay'))
old = Student.query.filter_by(id=id).all()
data = datetime.now()
for sum in old:
pul = sum.money
total = pul + money
Student.query.filter_by(id=id).update({"money": total})
qosh = Bank.cash + money
Bank.query.filter_by(id=1).update({'cash': qosh})
add = Student_cash(student_id=id,
debt=pul,
payment=money,
result=total,
payment_data=data,
username=sum.username,
student_name=sum.name,
student_surname=sum.surname)
add.add()
return redirect(url_for('payment'))
def manage(id):
user = get_current_user()
try:
if not user.gazalkent_admin and not user.director and not user.xojakent_admin:
return redirect(url_for('home'))
except AttributeError:
return redirect(url_for('home'))
teacher = get_current_teacher()
groups = Groups.query.filter_by(id=id).all()
experts = Teachers.query.filter_by(teacher=True).all()
for group in groups:
student = Student.query.filter(
or_(Student.group1 == group.id, Student.group2 == group.id,
Student.group3 == group.id))
if user.locations == 1:
return render_template('Groups/manage_group.html',
students=student,
groups=groups,
user=user,
teachers=experts)
elif user.locations == 2:
return render_template('Groups/manage_group2.html',
students=student,
groups=groups,
user=user,
teachers=experts)
return render_template('Groups/manage_group.html',
groups=groups,
user=user,
teachers=experts)
def addnewmed(ssn):
if (current_user.role != 'pharm'):
return render_template('auth/accessDenied.html')
if request.method == "POST":
medName = request.form['mname']
reqQuant = request.form['quantity']
requiredMed = Med.query.filter_by(mname=medName)[0]
patId = Patient.query.filter_by(ssnId=ssn)[0].id
# Checks medicine's availablility(if quantity is not zero)
if (int(requiredMed.quantity) - int(reqQuant)) >= 0:
medDict = {}
medDict['medId'] = requiredMed.mid
medDict['pid'] = patId
medDict['name'] = medName
medDict['quant'] = reqQuant
medDict['rate'] = requiredMed.Rate
medDict['amount'] = int(reqQuant) * int(requiredMed.Rate)
newMed.append(medDict)
print(medDict['name'])
return redirect(url_for('patientmedinfo', ssn=ssn))
else:
flash(
"Quantity not availaible. Available quantity of this medicine is {}"
.format(requiredMed.quantity), "danger")
return redirect(url_for('issuemedicine', ssn=ssn))
def create_portaluser():
fullname = request.form['fullname']
username = request.form['username']
email = request.form['email']
active = True
created_at = datetime.utcnow()
updated_at = datetime.utcnow()
isAvailable = PortalUser.query.filter((username == username)
| (email == email)).first()
if isAvailable:
return redirect(url_for('get_index_view'))
hashed_password = bcrypt.hashpw(default_password, bcrypt.gensalt())
portaluser = PortalUser(fullname, username, email, hashed_password, active,
created_at, updated_at)
print portaluser.fullname
db.session.add(portaluser)
db.session.commit()
return redirect(url_for('get_index_view'))
def salary_give(id):
user = get_current_user()
try:
if not user.gazalkent_admin and not user.director and not user.xojakent_admin:
return redirect(url_for('home'))
except AttributeError:
return redirect(url_for('home'))
salary = int(request.form.get('teacher_salary'))
teacher = Teachers.query.filter_by(id=id).first()
all = teacher.salary - salary
Teachers.query.filter_by(id=id).update({'salary': all})
Teachers.query.filter_by(id=id).update({'salary': all})
add = Teacher_cash(teacher_id=teacher.id,
teacher_name=teacher.name,
teacher_surname=teacher.surname,
username=teacher.username,
payment=salary,
payment_data=now,
salary=teacher.salary,
result=all)
db.session.add(add)
db.session.commit()
bank = Bank.query.filter_by(id=1).first()
total = bank.cash - salary
Bank.query.filter_by(id=1).update({'cash': total})
db.session.commit()
return redirect(url_for('teacher_result'))
def pay_result():
user = get_current_user()
try:
if not user.gazalkent_admin and not user.director and not user.xojakent_admin:
return redirect(url_for('home'))
except AttributeError:
return redirect(url_for('home'))
payment = request.form.get('payment')
name1 = request.form.get('payment').upper()
surname1 = request.form.get('payment').upper()
number1 = request.form.get('payment')
usernames = Student.query.filter_by(username=payment).all()
for username in usernames:
if username.username == payment:
return render_template('payment/pay result.html',
gmails=usernames,
user=user)
names = Student.query.filter_by(name=name1).all()
for name in names:
if name.name == name1:
return render_template('payment/pay_name.html',
user=user,
names=names)
surnames = Student.query.filter_by(surname=surname1).all()
for surname in surnames:
if surname.surname == surname1:
return render_template('payment/pay_surname.html',
user=user,
surnames=surnames)
numbers = Student.query.filter_by(phone=number1).all()
for number in numbers:
if number.phone == number1:
return render_template('payment/pay_phone.html',
user=user,
number=numbers)
def groups():
user = get_current_user()
try:
if not user.xojakent_admin and not user.director and not user.gazalkent_admin:
return redirect(url_for('home'))
except AttributeError:
return redirect(url_for('home'))
return render_template('Groups/create group.html')
def apset_days(student_id,group_id):
user = get_current_user()
try:
if not user:
return redirect(url_for('home'))
except AttributeError:
return redirect(url_for('home'))
apset_days = Attendance.query.filter_by(student_id=student_id,group_id=group_id).all()
return render_template('student/apset_days.html',apset_days=apset_days,user=user)
def _get_tour_step_back_link(service_id, template_id, step_index):
if step_index == 1:
return url_for('.begin_tour',
service_id=service_id,
template_id=template_id)
return url_for('.tour_step',
service_id=service_id,
template_id=template_id,
step_index=step_index - 1)
def css(self):
return [
tags.Link(rel="stylesheet", href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css",
integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm",
crossorigin="anonymous"),
tags.Link(rel="stylesheet", href=url_for('static', filename='css/flag-icon-css/css/flag-icon.min.css')),
tags.Link(href=url_for('static', filename='css/style.css'),
rel="stylesheet",
typ="text/css"),
]
def location1():
user = get_current_user()
try:
if not user.director and not user.xojakent_admin:
return redirect(url_for('home'))
except AttributeError:
return redirect(url_for('home'))
show = Student.query.order_by('age').all()
return render_template('Xojakent new students/xojakent.html',
show=show,
user=user)
def delete_page(id):
user = get_current_user()
try:
if not user.gazalkent_admin and not user.director and not user.xojakent_admin:
return redirect(url_for('home'))
except AttributeError:
return redirect(url_for('home'))
student = Student.query.filter_by(id=id).first()
return render_template('student/deleted_students.html',
user=user,
student_id=student)
def student_debts():
user = get_current_user()
try:
if not user.gazalkent_admin and not user.director and not user.xojakent_admin:
return redirect(url_for('home'))
except AttributeError:
return redirect(url_for('home'))
debts = Student.query.order_by('id').all()
return render_template('student/students_with_debts.html',
user=user,
debts=debts)
def group_without_teacher2():
user = get_current_user()
try:
if not user.gazalkent_admin and not user.director:
return redirect(url_for('home'))
except AttributeError:
return redirect(url_for('home'))
groups = Groups.query.filter_by(teacher_1=0).all()
return render_template('Groups/Without Teacher2.html',
user=user,
groups=groups)
def gazalkent_english():
user = get_current_user()
try:
if not user.director and not user.gazalkent_admin:
return redirect(url_for('home'))
except AttributeError:
return redirect(url_for('home'))
show = Student.query.order_by('age').all()
return render_template('Gazalkent new Students/gazalkent english.html',
show=show,
user=user)
def authenticate():
error = ''
if request.method == 'POST':
data = request.form
tid = data['id']
ret = retrieve()
if ret.check_cust(tid):
return redirect(url_for('success', tid=tid))
else:
error = "Invalid Tracking ID!"
return redirect(url_for('track', title='Track', error=error))
return redirect(url_for('track', title='Track', error=error))
def rename_group(id):
user = get_current_user()
try:
if not user.gazalkent_admin and not user.director and not user.xojakent_admin:
return redirect(url_for('home'))
except AttributeError:
return redirect(url_for('home'))
name = request.form.get('name')
Groups.query.filter_by(id=id).update({'name': name})
db.session.commit()
return redirect(url_for('manage', id=id))
def info_teacher():
teacher = get_current_teacher()
try:
if not teacher:
return redirect(url_for('home'))
except AttributeError:
return redirect(url_for('home'))
user = get_current_user()
users = Teachers.query.filter_by(id=teacher.id)
return render_template('Teacher/teacher_profile.html',
teacher=teacher,
users=users,
user=user)
def teacher_profile(id):
user = get_current_user()
try:
if not user.xojakent_admin and not user.director and not user.gazalkent_admin:
return redirect(url_for('home'))
except AttributeError:
return redirect(url_for('home'))
teacher = Teachers.query.filter_by(id=id)
groups = Groups.query.filter_by(teacher_1=id).all()
return render_template('Teacher/teacher_information.html',
user=user,
teacher=teacher,
groups=groups)
def gazalkent_xamshira():
user = get_current_user()
try:
if not user.director and not user.gazalkent_admin:
return redirect(url_for('home'))
except AttributeError:
return redirect(url_for('home'))
teachers = Teachers.query.filter_by(subject='eng')
show = Student.query.order_by('age').all()
return render_template('Gazalkent new Students/uy xamshiraligi.html',
show=show,
user=user,
teachers=teachers)
def teacher_result():
user = get_current_user()
try:
if not user.gazalkent_admin and not user.director and not user.xojakent_admin:
return redirect(url_for('home'))
except AttributeError:
return redirect(url_for('home'))
teacher = Teacher_cash.query.order_by('id').all()
bank = Bank.query.order_by('id').all()
return render_template('payment/teacher_result.html',
user=user,
teacher=teacher,
bank=bank)
def change_absent(id):
user = get_current_user()
teacher = get_current_teacher()
try:
if not teacher:
return redirect(url_for('home'))
except AttributeError:
return redirect(url_for('home'))
pres = Attendance.query.filter_by(id=id).first()
Attendance.query.filter_by(id=id).update({'present': pres.apset})
Attendance.query.filter_by(id=id).update({'apset': None})
db.session.commit()
return redirect(url_for('see_att', id=pres.student_id))
def teacher2():
user = get_current_user()
try:
if not user.xojakent_admin and not user.director and not user.gazalkent_admin:
return redirect(url_for('home'))
except AttributeError:
return redirect(url_for('home'))
teachers = Teachers.query.order_by('id').all()
user1 = Student.query.order_by('id').all()
return render_template('Teacher/teachers2.html',
user=user,
teachers=teachers,
user1=user1)
def submit():
if request.method == 'POST':
uid = request.form.get('id')
ret = retrieve()
if ret.check_password(uid, request.form.get('password')):
session['user'] = uid
session['super_user'] = ret.getsu(uid)
session['name'] = ret.getname(uid)
return redirect(url_for('register'))
else:
error = "Invalid credentials!"
return redirect(url_for('login', title='Track', error=error))
return redirect(url_for('login', title='Track', error="error"))
def del_name_group(id):
user = get_current_user()
try:
if not user.gazalkent_admin and not user.director and not user.xojakent_admin:
return redirect(url_for('home'))
except AttributeError:
return redirect(url_for('home'))
query = Groups.query.filter_by(id=id).first()
Groups.query.filter_by(id=id).update({'old_name': query.name, 'name': ''})
db.session.commit()
return redirect(url_for('manage', id=id))
def login():
error=none
if request=='POST':
if request.form['username'] !='admin' or request.form['password'] !='admin':
error= 'Please enter correct name or password'
else:
return redirect(url_for('home'))
def edit(OrmForm, model):
form = OrmForm(request.form, model)
if form.validate_on_submit():
form.populate_obj(model)
model.put()
flash("MyModel updated")
return redirect(url_for("index"))
return render_template("editor.html", form=form)
def test_register_and_login(self):
# register a new account
response = self.client.post(url_for('auth.register'), data={
'email': '*****@*****.**',
'username': '******',
'password' : 'test',
'password2' : 'test'
})
self.assertTrue(response.status_code == 302)
# login with the new account
response = self.client.post(url_for('auth.login'), data={
'email': '*****@*****.**',
'password': '******'
}, follow_redirects=True)
data = response.get_data(as_text=True)
self.assertTrue('You have not confirmed your account yet' in data)
# login with wrong credentials
response = self.client.post(url_for('auth.login'), data={
'email': '*****@*****.**',
'password': '******'
}, follow_redirects=True)
data = response.get_data(as_text=True)
self.assertTrue('Invalid username or password' in data)
# send a confirmation token
user = User.query.filter_by(email='*****@*****.**').first()
token = user.generate_confirmation_token()
response = self.client.get(url_for('auth.confirm', token=token),
follow_redirects=True)
data = response.get_data(as_text=True)
self.assertTrue('You have confirmed your account' in data)
# log out
response = self.client.get(url_for('auth.logout'),
follow_redirects=True)
data = response.get_data(as_text=True)
self.assertTrue('You have been logged out' in data)
def add_olympiad():
title = "Добавление олимпиады"
form = EditorOlympiad()
if form.validate_on_submit():
new_olympiad = Olympiad(name=form.name.data,
max_balls=form.max_balls.data,
description=form.description.data)
db.session.add(new_olympiad)
db.session.commit()
flash('Добавлена Олимпиада!')
return redirect(url_for("hierarchy"))
flash(flash_editor_errors(form))
return render_template("editor.html", form=form, action='/add/olympiad', title=title)
from app import app, url_for
app.config["SERVER_NAME"] = "server"
with app.app_context():
import urllib.parse
output = []
for rule in app.url_map.iter_rules():
options = {}
for arg in rule.arguments:
options[arg] = "[{0}]".format(arg)
methods = ','.join(rule.methods)
url = url_for(rule.endpoint, **options)
line = urllib.parse.unquote("{:50s} {:20s} {}".format(rule.endpoint, methods, url))
output.append(line)
for line in sorted(output):
print(line)
def test_home_page(self):
response = self.client.get(url_for('main.index'))
self.assertTrue('Dump Your Brain' in response.get_data(as_text=True))
