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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 find_group3():
user = get_current_user()
try:
if not user:
return redirect(url_for('home'))
except AttributeError:
return redirect(url_for('home'))
student = Student.query.filter_by(id=user.id).first()
groups = Groups.query.filter_by(id=student.group3)
for st in groups:
students = Student.query.filter(or_(Student.group1 == st.id, Student.group2 == st.id, Student.group3 == st.id))
return render_template('student/st group3.html', students=students, user=user, groups=groups)
return render_template('student/st group3.html', user=user, 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 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 student_english():
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'))
teachers = Teachers.query.filter_by(subject='eng')
show = Student.query.order_by('age').all()
return render_template(
'Xojakent new students/Xojakent_English New Students.html',
show=show,
user=user,
teachers=teachers)
def see_att(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'))
attendance = Attendance.query.filter_by(
student_id=id, teacher_id=teacher.id).order_by('id').all()
return render_template('Teacher/student_att.html',
user=user,
teacher=teacher,
attendance=attendance)
def all_groups2():
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.order_by('id').all()
for group in groups:
teacher = Teachers.query.filter_by(id=group.teacher_1).first()
return render_template('Groups/Groups2.html',
teacher_1=teacher,
groups=groups,
user=user)
return render_template('Groups/Groups2.html', groups=groups, user=user)
def teacher_salary():
teacher = get_current_teacher()
try:
if not teacher:
return redirect(url_for('home'))
except AttributeError:
return redirect(url_for('home'))
user = get_current_user()
teacher_info = Teachers.query.filter_by(id=teacher.id).first()
cash = Teacher_cash.query.filter_by(teacher_id=teacher.id)
return render_template('Teacher/teacher_salary.html',
teacher=teacher,
teacher_info=teacher_info,
cash=cash,
user=user)
def move_to_group(old_id, 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 = Student.query.filter_by(for_moved=True).first()
query_group = Groups.query.filter_by(id=group_id).all()
old_group = Groups.query.filter_by(id=old_id).first()
for i in query_group:
if query.group1 == old_group.id:
Student.query.filter_by(for_moved=True).update({
'group1': i.id,
'for_moved': False
})
db.session.commit()
elif query.group2 == old_group.id:
if query.group1 == i.id:
return 'Bu gruppa band'
else:
Student.query.filter_by(for_moved=True).update({
'group2':
i.id,
'for_moved':
False
})
db.session.commit()
elif query.group3 == old_group.id:
if query.group1 == i.id:
return 'Bu gruppa band'
elif query.group2 == i.id:
return 'Bu gruppa band'
else:
Student.query.filter_by(for_moved=True).update({
'group3':
i.id,
'for_moved':
False
})
db.session.commit()
print(old_group.id)
if old_group.location == 1:
return redirect(url_for('inside_of_group', id=old_id))
elif old_group.location == 2:
return redirect(url_for('inside_of_group2', id=old_id))
def find_attendance3():
user = get_current_user()
try:
if not user:
return redirect(url_for('home'))
except AttributeError:
return redirect(url_for('home'))
try:
student = Student.query.filter_by(id=user.id).first()
groups = Groups.query.filter_by(id=student.group3)
for st in groups:
attendance1 = Attendance.query.filter_by(group_id=st.id).order_by('id').all()
return render_template('student/my att3.html', user=user, attendance=attendance1, groups=groups)
return render_template('student/my att3.html', user=user, groups=groups)
except UndefinedError:
return "Sizda uchinchi guruh yo'q"
