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"