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 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 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 group_without_teacher():
user = get_current_user()
try:
if not user.xojakent_admin and not user.director:
return redirect(url_for('home'))
except AttributeError:
return redirect(url_for('home'))
teacher = get_current_teacher()
groups = Groups.query.filter_by(teacher_1=0).all()
return render_template('Groups/Without Teacher.html',
teacher=teacher,
user=user,
groups=groups)
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 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 due_days1():
user = get_current_user()
try:
if not user:
return redirect(url_for('home'))
except AttributeError:
return redirect(url_for('home'))
teacher = get_current_teacher()
reason = request.form.get('reason')
form = PhotoForm(meta={'csrf': False})
get = Attendance.query.filter_by(for_sabab=True).first()
if form.validate_on_submit():
filename = images.save(form.image.data)
image_url = images.url(filename)
add = reason_apset_days(student_id=user.id,
img_due_days=image_url,reason_due=reason,
date_abset=get.apset,group_id=get.group_id)
db.session.add(add)
db.session.commit()
return render_template('student/Sababli_kun.html', user=user, teacher=teacher,form=form, get=get)
def show_group(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'))
teacher = get_current_teacher()
query_groups = Groups.query.order_by('id').all()
query_students = Student.query.filter_by(
for_moved=True).order_by('id').all()
if user.locations == 1:
return render_template('Groups/Show_group.html',
groups=query_groups,
old_id=group_id,
students=query_students,
user=user)
elif user.locations == 2:
return render_template('Groups/Show_group2.html',
groups=query_groups,
old_id=group_id,
students=query_students,
user=user)
def create_group():
teacher = get_current_teacher()
user = get_current_user()
try:
if not user.xojakent_admin and not user.gazalkent_admin and not user.director:
return redirect(url_for('home'))
except AttributeError:
return redirect(url_for('home'))
if request.method == 'POST':
name = request.form.get("name")
teachers = request.form.get("teacher")
group_location = request.form.get('location')
type_of_course = request.form.get('type_of_course')
cost = request.form.get('cost')
if group_location == "xojakent":
group_location = 1
num = 1
groups_num = All_groups.all_groups + num
All_groups.query.filter_by(id=1).update({'all_groups': groups_num})
db.session.commit()
teach = Teachers.query.filter_by(id=teachers).first()
total = teach.number_groups + num
Teachers.query.filter_by(id=teachers).update(
{'number_groups': total})
db.session.commit()
elif group_location == "gazalkent":
group_location = 2
num = 1
groups_num = All_groups.all_groups + num
All_groups.query.filter_by(id=1).update({'all_groups': groups_num})
db.session.commit()
teach = Teachers.query.filter_by(id=teachers).first()
total = teach.number_groups + num
Teachers.query.filter_by(id=teachers).update(
{'number_groups': total})
db.session.commit()
teacher_id = Teachers.query.filter_by(id=teachers).first()
teacher_name = Teachers.query.filter_by(id=teachers).first()
teacher_surname = Teachers.query.filter_by(id=teachers).first()
if user.director:
add = Groups(name=name,
teacher_1=teacher_id.id,
location=group_location,
subject=teacher_id.subject,
cost=cost,
teacher_name=teacher_name.name,
teacher_surname=teacher_surname.surname,
type_of_course=type_of_course)
db.session.add(add)
else:
add = Groups(name=name,
teacher_1=teacher_id.id,
location=user.locations,
subject=teacher_id.subject,
cost=cost,
teacher_name=teacher_name.name,
teacher_surname=teacher_surname.surname,
type_of_course=type_of_course)
db.session.add(add)
show = Groups.query.filter_by(name=name).all()
teachers1 = Teachers.query.filter_by(id=teachers).all()
query_teacher = Teachers.query.filter_by(id=teachers).first()
for i in show:
if query_teacher.group1 is None and query_teacher.group2 is None and query_teacher.group3 is None and \
query_teacher.group4 is None and query_teacher.group5 is None and \
query_teacher.group6 is None and query_teacher.group7 is None and \
query_teacher.group8 is None and query_teacher.group9 is None and query_teacher.group10 is None:
Teachers.query.filter_by(id=teachers).update({'group1': i.id})
elif query_teacher.group1 is not None and query_teacher.group2 is None and query_teacher.group3 is None \
and query_teacher.group4 is None and query_teacher.group5 is None and \
query_teacher.group6 is None and query_teacher.group7 is None and \
query_teacher.group8 is None and query_teacher.group9 is None and query_teacher.group10 is None:
if query_teacher.group1 == i.id:
return 'Bu grda ustoz uje bor'
else:
Teachers.query.filter_by(id=teachers).update(
{'group2': i.id})
elif query_teacher.group1 is not None and query_teacher.group2 is not None and query_teacher.group3 is None \
and query_teacher.group4 is None and query_teacher.group5 is None and \
query_teacher.group6 is None and query_teacher.group7 is None and \
query_teacher.group8 is None and query_teacher.group9 is None and query_teacher.group10 is None:
if query_teacher.group1 == i.id:
return 'Bu grda ustoz uje bor'
elif query_teacher.group2 == i.id:
return 'Bu grda ustoz uje bor'
else:
Teachers.query.filter_by(id=teachers).update(
{'group3': i.id})
elif query_teacher.group1 is not None and query_teacher.group2 is not None and query_teacher.group3 is not None \
and query_teacher.group4 is None and query_teacher.group5 is None and \
query_teacher.group6 is None and query_teacher.group7 is None and \
query_teacher.group8 is None and query_teacher.group9 is None and query_teacher.group10 is None:
if query_teacher.group1 == i.id:
return 'Bu grda ustoz uje bor'
elif query_teacher.group2 == i.id:
return 'Bu grda ustoz uje bor'
elif query_teacher.group3 == i.id:
return 'Bu grda ustoz uje bor'
else:
Teachers.query.filter_by(id=teachers).update(
{'group4': i.id})
elif query_teacher.group1 is not None and query_teacher.group2 is not None and query_teacher.group3 is not None \
and query_teacher.group4 is not None and query_teacher.group5 is None and \
query_teacher.group6 is None and query_teacher.group7 is None and \
query_teacher.group8 is None and query_teacher.group9 is None and query_teacher.group10 is None:
if query_teacher.group1 == i.id:
return 'Bu grda ustoz uje bor'
elif query_teacher.group2 == i.id:
return 'Bu grda ustoz uje bor'
elif query_teacher.group3 == i.id:
return 'Bu grda ustoz uje bor'
elif query_teacher.group4 == i.id:
return 'Bu grda ustoz uje bor'
else:
Teachers.query.filter_by(id=teachers).update(
{'group5': i.id})
elif query_teacher.group1 is not None and query_teacher.group2 is not None and query_teacher.group3 is not None \
and query_teacher.group4 is not None and query_teacher.group5 is not None and \
query_teacher.group6 is None and query_teacher.group7 is None and \
query_teacher.group8 is None and query_teacher.group9 is None and query_teacher.group10 is None:
if query_teacher.group1 == i.id:
return 'Bu grda ustoz uje bor'
elif query_teacher.group2 == i.id:
return 'Bu grda ustoz uje bor'
elif query_teacher.group3 == i.id:
return 'Bu grda ustoz uje bor'
elif query_teacher.group4 == i.id:
return 'Bu grda ustoz uje bor'
elif query_teacher.group5 == i.id:
return 'Bu grda ustoz uje bor'
else:
Teachers.query.filter_by(id=teachers).update(
{'group6': i.id})
elif query_teacher.group1 is not None and query_teacher.group2 is not None and query_teacher.group3 is not None \
and query_teacher.group4 is not None and query_teacher.group5 is not None and \
query_teacher.group6 is not None and query_teacher.group7 is None and \
query_teacher.group8 is None and query_teacher.group9 is None and query_teacher.group10 is None:
if query_teacher.group1 == i.id:
return 'Bu grda ustoz uje bor'
elif query_teacher.group2 == i.id:
return 'Bu grda ustoz uje bor'
elif query_teacher.group3 == i.id:
return 'Bu grda ustoz uje bor'
elif query_teacher.group4 == i.id:
return 'Bu grda ustoz uje bor'
elif query_teacher.group5 == i.id:
return 'Bu grda ustoz uje bor'
elif query_teacher.group6 == i.id:
return 'Bu grda ustoz uje bor'
else:
Teachers.query.filter_by(id=teachers).update(
{'group7': i.id})
elif query_teacher.group1 is not None and query_teacher.group2 is not None and query_teacher.group3 is not None \
and query_teacher.group4 is not None and query_teacher.group5 is not None and \
query_teacher.group6 is not None and query_teacher.group7 is not None and \
query_teacher.group8 is None and query_teacher.group9 is None and query_teacher.group10 is None:
if query_teacher.group1 == i.id:
return 'Bu grda ustoz uje bor'
elif query_teacher.group2 == i.id:
return 'Bu grda ustoz uje bor'
elif query_teacher.group3 == i.id:
return 'Bu grda ustoz uje bor'
elif query_teacher.group4 == i.id:
return 'Bu grda ustoz uje bor'
elif query_teacher.group5 == i.id:
return 'Bu grda ustoz uje bor'
elif query_teacher.group6 == i.id:
return 'Bu grda ustoz uje bor'
elif query_teacher.group7 == i.id:
return 'Bu grda ustoz uje bor'
else:
Teachers.query.filter_by(id=teachers).update(
{'group8': i.id})
elif query_teacher.group1 is not None and query_teacher.group2 is not None and query_teacher.group3 is not None \
and query_teacher.group4 is not None and query_teacher.group5 is not None and \
query_teacher.group6 is not None and query_teacher.group7 is not None and \
query_teacher.group8 is not None and query_teacher.group9 is None and query_teacher.group10 is None:
if query_teacher.group1 == i.id:
return 'Bu grda ustoz uje bor'
elif query_teacher.group2 == i.id:
return 'Bu grda ustoz uje bor'
elif query_teacher.group3 == i.id:
return 'Bu grda ustoz uje bor'
elif query_teacher.group4 == i.id:
return 'Bu grda ustoz uje bor'
elif query_teacher.group5 == i.id:
return 'Bu grda ustoz uje bor'
elif query_teacher.group6 == i.id:
return 'Bu grda ustoz uje bor'
elif query_teacher.group7 == i.id:
return 'Bu grda ustoz uje bor'
elif query_teacher.group8 == i.id:
return 'Bu grda ustoz uje bor'
else:
Teachers.query.filter_by(id=teachers).update(
{'group9': i.id})
elif query_teacher.group1 is not None and query_teacher.group2 is not None and query_teacher.group3 is not None \
and query_teacher.group4 is not None and query_teacher.group5 is not None and \
query_teacher.group6 is not None and query_teacher.group7 is not None and \
query_teacher.group8 is not None and query_teacher.group9 is not None and query_teacher.group10 is None:
if query_teacher.group1 == i.id:
return 'Bu grda ustoz uje bor'
elif query_teacher.group2 == i.id:
return 'Bu grda ustoz uje bor'
elif query_teacher.group3 == i.id:
return 'Bu grda ustoz uje bor'
elif query_teacher.group4 == i.id:
return 'Bu grda ustoz uje bor'
elif query_teacher.group5 == i.id:
return 'Bu grda ustoz uje bor'
elif query_teacher.group6 == i.id:
return 'Bu grda ustoz uje bor'
elif query_teacher.group7 == i.id:
return 'Bu grda ustoz uje bor'
elif query_teacher.group8 == i.id:
return 'Bu grda ustoz uje bor'
elif query_teacher.group9 == i.id:
return 'Bu grda ustoz uje bor'
else:
Teachers.query.filter_by(id=teachers).update(
{'group10': i.id})
calc = Student.query.filter_by(for_group=True).all()
calculate = len(calc)
Groups.query.filter_by(name=name).update(
{'number_students': calculate})
query = Student.query.filter_by(for_group=True).first()
for q in teachers1:
for i in show:
if query.group1 is None and query.group2 is None and query.group3 is None:
if q.subject == query.subject_1:
Student.query.filter_by(for_group=True).update({
'group1':
i.id,
'for_group':
False,
'subject_1':
None
})
elif q.subject == query.subject_2:
Student.query.filter_by(for_group=True).update({
'group1':
i.id,
'for_group':
False,
'subject_2':
None
})
elif q.subject == query.subject_3:
Student.query.filter_by(for_group=True).update({
'group1':
i.id,
'for_group':
False,
'subject_3':
None
})
elif query.group1 is not None and query.group2 is None and query.group3 is None:
if query.group1 == i.id:
return 'Bu gruppa band'
else:
if q.subject == query.subject_1:
Student.query.filter_by(for_group=True).update({
'group2':
i.id,
'for_group':
False,
'subject_1':
None
})
elif q.subject == query.subject_2:
Student.query.filter_by(for_group=True).update({
'group2':
i.id,
'for_group':
False,
'subject_2':
None
})
elif q.subject == query.subject_3:
Student.query.filter_by(for_group=True).update({
'group2':
i.id,
'for_group':
False,
'subject_3':
None
})
elif query.group1 is not None and query.group2 is not None and query.group3 is None:
if query.group1 == i.id:
return 'Bu gruppa band'
elif query.group2 == i.id:
return 'Bu gruppa band'
else:
if q.subject == query.subject_1:
Student.query.filter_by(for_group=True).update({
'group3':
i.id,
'for_group':
False,
'subject_1':
None
})
elif q.subject == query.subject_2:
Student.query.filter_by(for_group=True).update({
'group3':
i.id,
'for_group':
False,
'subject_2':
None
})
elif q.subject == query.subject_3:
Student.query.filter_by(for_group=True).update({
'group3':
i.id,
'for_group':
False,
'subject_3':
None
})
experts = Teachers.query.filter_by(teacher=True).all()
student1 = Student.query.filter_by(for_group=True).all()
student = Student.query.filter_by(for_group=True).first()
db.session.commit()
return render_template('Groups/create group.html',
user=user,
teachers=experts,
student1=student1,
teacher=teacher,
student=student)
def add_group():
teacher = get_current_teacher()
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'))
if request.method == 'POST':
name = request.form.get('group')
calc = Student.query.filter_by(for_group=True).all()
calculate = len(calc)
all = Groups.number_students + calculate
Groups.query.filter_by(name=name).update({'number_students': all})
db.session.commit()
query = Student.query.filter_by(for_group=True).first()
show = Groups.query.filter_by(name=name).all()
for i in show:
if query.group1 is None and query.group2 is None and query.group3 is None:
if i.subject == query.subject_1:
Student.query.filter_by(for_group=True).update({
'group1':
i.id,
'for_group':
False,
'subject_1':
None
})
db.session.commit()
elif i.subject == query.subject_2:
Student.query.filter_by(for_group=True).update({
'group1':
i.id,
'for_group':
False,
'subject_2':
None
})
db.session.commit()
elif i.subject == query.subject_3:
Student.query.filter_by(for_group=True).update({
'group1':
i.id,
'for_group':
False,
'subject_3':
None
})
db.session.commit()
elif query.group1 is not None and query.group2 is None and query.group3 is None:
if query.group1 == i.id:
return 'Bu gruppa band'
else:
if i.subject == query.subject_1:
Student.query.filter_by(for_group=True).update({
'group2':
i.id,
'for_group':
False,
'subject_1':
None
})
db.session.commit()
elif i.subject == query.subject_2:
Student.query.filter_by(for_group=True).update({
'group2':
i.id,
'for_group':
False,
'subject_2':
None
})
db.session.commit()
elif i.subject == query.subject_3:
Student.query.filter_by(for_group=True).update({
'group2':
i.id,
'for_group':
False,
'subject_3':
None
})
db.session.commit()
elif query.group1 is not None and query.group2 is not None and query.group3 is None:
if query.group1 == i.id:
return 'Bu gruppa band'
elif query.group2 == i.id:
return 'Bu gruppa band'
else:
if i.subject == query.subject_1:
Student.query.filter_by(for_group=True).update({
'group3':
i.id,
'for_group':
False,
'subject_1':
None
})
db.session.commit()
elif i.subject == query.subject_2:
Student.query.filter_by(for_group=True).update({
'group3':
i.id,
'for_group':
False,
'subject_2':
None
})
db.session.commit()
elif i.subject == query.subject_3:
Student.query.filter_by(for_group=True).update({
'group3':
i.id,
'for_group':
False,
'subject_3':
None
})
db.session.commit()
experts = Teachers.query.filter_by(teacher=True).all()
student = Student.query.filter_by(director=False,
xojakent_admin=False,
gazalkent_admin=False,
for_group=True)
groups = Groups.query.order_by("id").all()
students = Student.query.order_by('id').all()
return render_template('Groups/add_group.html',
user=user,
teachers=experts,
student=student,
groups=groups,
students=students,
teacher=teacher)
def register_teacher():
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 = get_current_teacher()
if request.method == 'POST':
teacher_name = request.form.get('name').upper()
teacher_surname = request.form.get('surname').upper()
teacher_age = request.form.get('age')
teacher_location = request.form.get('location')
teacher_username = request.form.get('username')
teacher_hashed_password = request.form.get('password')
confirm_password = request.form.get('confirm_password')
teacher_phone = request.form.get('phone')
otasining_ismi = request.form.get('father_name')
teacher_subject = request.form.get('subject_1')
if Teachers.query.filter_by(username=teacher_username).first():
return "This username is already token"
if teacher_name == "":
abort(422)
elif teacher_surname == "":
abort(422)
elif teacher_age == "":
abort(422)
if teacher_hashed_password != confirm_password:
return "Parolingiz bir biriga to'g'ri kelmadi"
hash = generate_password_hash(confirm_password, method='sha256')
if teacher_location == "xojakent":
teacher_location = 1
num = 1
total = All_teachers.teachers + num
All_teachers.query.filter_by(id=1).update({'teachers': total})
elif teacher_location == "gazalkent":
teacher_location = 2
num = 1
total = All_teachers.teachers + num
All_teachers.query.filter_by(id=1).update({'teachers': total})
if teacher_subject == "Ingliz tili":
teacher_subject = 'Ingliz tili'
elif teacher_subject == "Rus tili":
teacher_subject = 'Rus tili'
elif teacher_subject == "Matematika":
teacher_subject = 'Matematika'
elif teacher_subject == "Tarix":
teacher_subject = 'Tarix'
elif teacher_subject == "Kimyo":
teacher_subject = 'Kimyo'
elif teacher_subject == "Fizika":
teacher_subject = 'Fizika'
elif teacher_subject == "Ona tili va Adabiyot":
teacher_subject = 'Ona tili va Adabiyot'
elif teacher_subject == "Biologiya":
teacher_subject = 'Biologiya'
elif teacher_subject == "Uy xamshiraligi":
teacher_subject = "Uy xamshiraligi"
add = Teachers(name=teacher_name,
surname=teacher_surname,
age=teacher_age,
locations=teacher_location,
username=teacher_username,
password=hash,
subject=teacher_subject,
phone=teacher_phone,
teacher=True,
number_groups=0,
otasining_ismi=otasining_ismi)
add.add_teacher()
return render_template('base template/Register_teacher.html',
user=user,
teacher=teacher)
def attendance_3(student_id, group_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'))
if request.method == 'POST':
query2 = Groups.query.filter_by(id=group_id).first()
query = Student.query.filter_by(id=student_id).first()
group = Groups.query.filter(
or_(Groups.id == query.group1, Groups.id == query.group2,
Groups.id == query.group3)).first()
query_teacher1 = Teachers.query.filter_by(id=teacher.id).first()
query_teacher = Teachers.query.filter_by(id=group.teacher_1).first()
slesh = group.cost / 13
boluv = slesh / 2
salery = query_teacher.salary + boluv
plus = query.money - slesh + query.charity
get_date = datetime.now()
Student.query.filter_by(id=student_id).update({'money': plus})
Teachers.query.filter_by(id=group.teacher_1).update({'salary': salery})
db.session.commit()
add = Attendance(group_id=group.id,
student_id=student_id,
teacher_id=teacher.id,
present=None,
apset=get_date)
db.session.add(add)
db.session.commit()
query_charity = All_Charity_Sums.query.order_by('id').first()
plus_charity = query_charity.bank_charity + query.charity
All_Charity_Sums.query.update({'bank_charity': plus_charity})
db.session.commit()
if query2.id == query_teacher1.group1:
return redirect(url_for('my_group1'))
elif query2.id == query_teacher1.group1:
return redirect(url_for('my_group2'))
elif query2.id == query_teacher1.group1:
return redirect(url_for('my_group3'))
elif query2.id == query_teacher1.group1:
return redirect(url_for('my_group4'))
elif query2.id == query_teacher1.group1:
return redirect(url_for('my_group5'))
elif query2.id == query_teacher1.group1:
return redirect(url_for('my_group6'))
elif query2.id == query_teacher1.group1:
return redirect(url_for('my_group7'))
elif query2.id == query_teacher1.group1:
return redirect(url_for('my_group8'))
elif query2.id == query_teacher1.group1:
return redirect(url_for('my_group9'))
elif query2.id == query_teacher1.group1:
return redirect(url_for('my_group10'))
groups = Groups.query.filter_by(teacher_1=teacher.id).all()
for i in groups:
student = Student.query.filter(
or_(Student.group1 == i.id, Student.group2 == i.id,
Student.group3 == i.id))
return render_template('Teacher/my groups.html',
user=user,
teacher=teacher,
groups=groups,
students=student)
return render_template('Teacher/my groups.html',
user=user,
teacher=teacher,
groups=groups)
def attendance_1(student_id, group_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'))
if request.method == 'POST':
query = Student.query.filter_by(attendance=True).first()
query2 = Groups.query.filter_by(id=group_id).first()
group = Groups.query.filter(
or_(Groups.id == query.group1, Groups.id == query.group2,
Groups.id == query.group3)).first()
query_teacher = Teachers.query.filter_by(id=group.teacher_1).first()
query_teacher1 = Teachers.query.filter_by(id=teacher.id).first()
slesh = group.cost / 13 + query.charity
boluv = slesh / 2
if query_teacher.salary is None:
salery = boluv
else:
salery = query_teacher.salary + boluv
if query.money is None:
plus2 = -slesh
else:
plus2 = query.money - slesh
get_date = datetime.now()
if teacher.subject == 'Ingliz tili' or teacher.subject == 'Rus tili':
get_homework = int(request.form.get('homework'))
get_dictonary = int(request.form.get('dictionary'))
get_class_activity = int(request.form.get('active'))
plus1 = get_homework + get_dictonary + get_class_activity
boluv2 = plus1 / 3
add = Attendance(group_id=group_id,
student_id=student_id,
teacher_id=teacher.id,
darsga_tayyorgarligi=get_homework,
lugat=get_dictonary,
darsda_qatnashishi=get_class_activity,
ortacha_baho=boluv2,
present=get_date,
fan=group.subject,
apset=None)
db.session.add(add)
db.session.commit()
print(teacher.subject)
elif teacher.subject == 'Matematika' or teacher.subject == 'Tarix' or \
teacher.subject == 'Fizika' or teacher.subject == 'Ona tili va Adabiyot' \
or teacher.subject == 'Biologiya':
get_homework2 = int(request.form.get('homework'))
get_class_activity2 = int(request.form.get('active'))
plus3 = get_homework2 + get_class_activity2
boluv3 = plus3 / 2
add2 = Attendance(group_id=group_id,
student_id=student_id,
teacher_id=teacher.id,
darsga_tayyorgarligi=get_homework2,
darsda_qatnashishi=get_class_activity2,
ortacha_baho=boluv3,
lugat=0,
present=get_date,
fan=group.subject,
apset=None)
db.session.add(add2)
db.session.commit()
print(teacher.subject)
Student.query.filter_by(attendance=True).update({
'money': plus2,
'attendance': False
})
Teachers.query.filter_by(id=group.teacher_1).update({'salary': salery})
db.session.commit()
query_charity = All_Charity_Sums.query.order_by('bank_charity').first()
plus_charity = query_charity.bank_charity + query.charity
All_Charity_Sums.query.update({'bank_charity': plus_charity})
db.session.commit()
if query2.id == query_teacher1.group1:
return redirect(url_for('my_group1'))
elif query2.id == query_teacher1.group1:
return redirect(url_for('my_group2'))
elif query2.id == query_teacher1.group1:
return redirect(url_for('my_group3'))
elif query2.id == query_teacher1.group1:
return redirect(url_for('my_group4'))
elif query2.id == query_teacher1.group1:
return redirect(url_for('my_group5'))
elif query2.id == query_teacher1.group1:
return redirect(url_for('my_group6'))
elif query2.id == query_teacher1.group1:
return redirect(url_for('my_group7'))
elif query2.id == query_teacher1.group1:
return redirect(url_for('my_group8'))
elif query2.id == query_teacher1.group1:
return redirect(url_for('my_group9'))
elif query2.id == query_teacher1.group1:
return redirect(url_for('my_group10'))
groups = Groups.query.filter_by(teacher_1=teacher.id).all()
for i in groups:
student = Student.query.filter(
or_(Student.group1 == i.id, Student.group2 == i.id,
Student.group3 == i.id))
return render_template('Teacher/my groups.html',
user=user,
teacher=teacher,
groups=groups,
students=student)
return render_template('Teacher/my groups.html',
user=user,
teacher=teacher,
groups=groups)
