def reg_student(name, password, cpassword, email):
#return 1 if passwords not equal error
if password != cpassword:
return 1
if '@' not in email:
return 2
for r in adb.view_student_t(): #students cant have same email
if email == r[4]:
return 4
else:
adb.add_student(name, password, email)
return False
def Add_client(self):
c = 1
d = 1
while c != 0:
fio = self.FIO_line.text()
c = database.try_get_fio(fio)
if c == 1:
self.FIO_line.clear()
break
passport = self.serial_line.text() + self.number_line.text()
address = self.addres_line.text()
phone = self.phone_line.text()
educ_form = self.FormBox.currentText()
sex = self.SexBox.currentText()
#hostel = self.hostel_line.text()
hostel = self.HostelNumber.currentText()
room = 'queue'
if c == 0:
database.add_student(fio, phone, passport, address, educ_form, sex,
hostel)
# if d == 0:
# database.add_student_buffer(key,fio, phone, passport, address, educ_form, sex,room,hostel)
# # from add_contract import Ui_add_contract
# # self.window = QtWidgets.QMainWindow()
# # self.ui = Ui_add_contract()
# # self.ui.setupUi(self.window)
# # self.window.show()
# else:
# from error_hostel import Ui_Error
# self.window = QtWidgets.QMainWindow()
# self.ui = Ui_Error()
# self.ui.setupUi(self.window)
# self.window.show()
else:
from error import Ui_Error
self.window = QtWidgets.QMainWindow()
self.ui = Ui_Error()
self.ui.setupUi(self.window)
self.window.show()
self.FIO_line.clear()
self.serial_line.clear()
self.number_line.clear()
self.addres_line.clear()
self.phone_line.clear()
self.HostelNumber.setCurrentIndex(0)
self.FormBox.setCurrentIndex(-1)
self.SexBox.setCurrentIndex(-1)
def register():
if session.has_key('user'):
session.pop('user')
if request.method=="GET":
return render_template("register.html", loggedout=True)
elif request.method=='POST':
if request.form['button']=='Register':
username=request.form['username']
password=request.form['password']
osis=request.form['osis']
digit=request.form['digit']
name=request.form['name']
email=request.form['email']
lunch=request.form['lunch']
exist=database.add_student(username,password)
if exist:
return render_template("register.html",loggedout=True,exists=exist)
database.set_osis(username,osis)
database.set_id(username,digit)
database.set_name(username,name)
database.set_email(username,email)
database.set_period(username,
int(lunch),
[str(lunch),
"Cafe",
"Chi Kun Wang",
"ZLN5",
"0"+str(lunch)])
return redirect(url_for("profile"))
return redirect(url_for("register"))
def reg_student(name, password, cpassword, email):
#return 1 if passwords not equal error
if password != cpassword:
return 1
if '@' not in email:
return 2
for r in adb.view_company_t(): #students cant have same email
if email == r[4]:
return 4
else:
adb.add_student(name, password, email)
return False
def add_student_pro():
# 파라미터 데이터 추출한다.
stu_name = request.form['stu_name']
stu_age = request.form['stu_age']
stu_addr = request.form['stu_addr']
# print(f'{stu_name} {stu_age} {stu_addr}')
# 저장한다.
idx = db.add_student(stu_name, stu_age, stu_addr)
result_dic = {'stu_idx': idx}
html = render_template('add_student_pro.html', data_dic=result_dic)
return html
def Add_client_contract(self):
c = 1
d = 1
while c != 0:
fio = self.FIO_line.text()
c = database.try_get_fio(fio)
if c == 1:
self.FIO_line.clear()
break
passport = self.serial_line.text() + self.number_line.text()
address = self.addres_line.text()
phone = self.phone_line.text()
educ_form = self.FormBox.currentText()
sex = self.SexBox.currentText()
while d != 0:
hostel = self.HostelNumber.currentText()
d = database.try_get_hostel(hostel)
if d == 1:
self.HostelNumber.setCurrentIndex(0)
break
room = 'queue'
if c == 0:
if d == 0:
if sex == "Мужской" or sex == "Женский":
key = database.add_student(fio, str(phone), str(passport),
str(address), str(educ_form),
str(sex), str(hostel))
database.add_student_buffer(key, fio, str(phone),
str(passport), str(address),
str(educ_form), str(sex),
str(room), str(hostel))
self.openAdd_contract()
#add_client.close()
# from add_contract import Ui_add_contract
# self.window = QtWidgets.QMainWindow()
# self.ui = Ui_add_contract()
# self.ui.setupUi(self.window)
# self.window.show()
self.FIO_line.clear()
self.serial_line.clear()
self.number_line.clear()
self.addres_line.clear()
self.phone_line.clear()
self.HostelNumber.setCurrentIndex(0)
self.FormBox.setCurrentIndex(-1)
self.SexBox.setCurrentIndex(-1)
else:
from error_add_sex import Ui_Error
self.window = QtWidgets.QMainWindow()
self.ui = Ui_Error()
self.ui.setupUi(self.window)
self.window.show()
else:
from error_hostel import Ui_Error
self.window = QtWidgets.QMainWindow()
self.ui = Ui_Error()
self.ui.setupUi(self.window)
self.window.show()
else:
from error import Ui_Error
self.window = QtWidgets.QMainWindow()
self.ui = Ui_Error()
self.ui.setupUi(self.window)
self.window.show()
def c_add_student():
usn = int(input("Enter the usn : "))
name = input("Enter the name : ")
sem = int(input("Enter the sem : "))
placed = int(input("Enter 1 for placed if not 0 "))
db.add_student(usn,name,sem,placed)
def c_add_student():
usn = int(input("Enter usn: "))
name = input("Enter name: ")
sem = int(input("Enter sem: "))
placed = int(input("Enter 1 if Placed otherwise 0: "))
db.add_student(usn, name, sem, placed)
def c_add_student(regno, name, sem, placed):
usn = input("enter the usn")
name = input("enter the name")
sem = input("enter the sem")
placed = input("enter the place")
db.add_student(usn, name, sem, placed)
def c_add_student():
usn = input("Enter student USN: ")
name = input("Enter student name: ")
sem = input("Enter student sem: ")
placed = input("Student placement status: ")
db.add_student(usn, name, sem, placed)
