def post_addstumsg():
if request.method == 'POST':
param = request.form.to_dict()
goto_id = param.get('num[goto_id]')
goto_name = param.get('num[goto_name]')
goto_phone = param.get('num[goto_phone]')
goto_reason = param.get('num[goto_reason]')
goto_leavetime = param.get('num[goto_leavetime]')
goto_backtime = param.get('num[goto_backtime]')
goto_dormitory = param.get('num[goto_dormitory]')
goto_dormitory_id = param.get('num[goto_dormitory_id]')
if not all([
goto_id, goto_name, goto_phone, goto_dormitory,
goto_dormitory_id
]):
return jsonify(format_false(False, None, "必要信息有空的"))
else:
try:
num = InsertgotomsgTB(goto_id, goto_name, goto_phone,
goto_dormitory_id, goto_dormitory,
goto_leavetime, goto_backtime,
goto_reason).insertgotomsg()
if num == ():
content = jsonify(format(True, num, "增加成功"))
else:
content = jsonify(format_false(False, None, '增加失败'))
except:
content = jsonify(format_false(False, None, '增加成功失败，重复提交'))
else:
content = jsonify(format_false(False, None, "101"))
return content
def edit_editgotonum_commit():
if request.method == 'POST':
param = request.form.to_dict()
goto_id = param.get('num[goto_id]')
goto_name = param.get('num[goto_name]')
goto_phone = param.get('num[goto_phone]')
goto_reason = param.get('num[goto_reason]')
goto_leavetime = param.get('num[goto_leavetime]')
goto_backtime = param.get('num[goto_backtime]')
goto_dormitory = param.get('num[goto_dormitory]')
goto_dormitory_id = param.get('num[goto_dormitory_id]')
if not all([
goto_id, goto_name, goto_phone, goto_dormitory,
goto_dormitory_id
]):
return jsonify(format_false(False, None, "必要信息有空的"))
else:
try:
num_n = UpdategotomsgTB(goto_id, goto_name, goto_phone,
goto_dormitory, goto_dormitory_id,
goto_leavetime, goto_backtime,
goto_reason).updatgotomsg()
if num_n == ():
content = jsonify(format(True, num_n, "外出信息更新成功"))
else:
content = jsonify(format_false(False, None, '外出信息更新失败'))
except:
content = jsonify(format_false(False, None, '外出信息--更新失败，重复提交'))
else:
content = jsonify(format_false(False, None, "101"))
return content
def post_addmsg():
if request.method == 'POST':
param = request.form.to_dict()
dormitory_id = param.get('num[dormitory_id]')
ceng_num = param.get('num[ceng_num]')
bed_pid = param.get('num[bed_pid]')
price = param.get('num[price]')
floor_id = 'C' + param.get('num[floor_id]')
if not all([dormitory_id, ceng_num, bed_pid, price, floor_id]):
return jsonify(format_false(False, None, "表单有空的"))
else:
try:
num_n = selectdormitorymsgTB(
dormitory_id, floor_id).selectdormitory()
if num_n == ():
num_n1 = InsertdormitorymsgTB(
dormitory_id, ceng_num, bed_pid, price, floor_id).insertdormitory()
content = jsonify(format(True, num_n1, "增加成功"))
else:
content = jsonify(format_false(False, None, '增加失败'))
except:
content = jsonify(format_false(False, None, '增加成功失败，重复提交'))
else:
content = jsonify(format_false(False, None, "101"))
return content
def login():
if request.method == 'POST':
# request.form获得所有post参数放在一个类似dict类中,to_dict()是字典化
param = request.form.to_dict()
username = param.get('username')
password = param.get('password')
radio = param.get('radio')
if not all([username, password]):
return jsonify(format_false(False, None, "密码或者账号为空"))
else:
if username != None and password != None: # 判断二者不为空
user = UserTB(username, password, radio).selectUser() # 传3个参数
if user == None: # 如果用户名为空
content = jsonify(format_false(False, None, "用户名不存在"))
else: # 如果用户名不为空
userPwd = UserTB(username, password,
radio).selectUserPwd() # 查账号和密码
if userPwd == None:
content = jsonify(format_false(False, None, "用户名密码不正确"))
else:
content = jsonify(format(True, userPwd, "登录成功"))
else:
content = jsonify(format_false(False, None, "101"))
return content
def edit_editnum_commit():
if request.method == 'POST':
param = request.form.to_dict()
dormitory_id = param.get('num[dormitory_id]')
ceng_num = param.get('num[ceng_num]')
bed_pid = param.get('num[bed_pid]')
price = param.get('num[price]')
floor_id = param.get('num[floor_id]')
if not all([dormitory_id, ceng_num, bed_pid, price, floor_id]):
return jsonify(format_false(False, None, "表单有空的"))
else:
try:
bed_pid = int(bed_pid)
bed = selectdormitorymsgTB(
dormitory_id, floor_id).selectdormitory_edit() # 实际人数
# print(type(bed_pid))
# print(type(bed))
if bed <= bed_pid: # 实际人数要小于等于你选择的床位数目
content = jsonify(format_full(
False, None, '人多床少')) # 状态码202
num_n = UpdatedormitorymsgTB(
ceng_num, bed_pid, price, dormitory_id, floor_id).updatedormitory()
updatestateTB(dormitory_id, floor_id,
'0').updatestate() # 默认是床多，状态为宿舍不满人
if bed == bed_pid: # 如果床位于人数相等就改状态为宿舍满人
state = updatestateTB(
dormitory_id, floor_id, '1').updatestate()
if state == ():
content = jsonify(
format(True, state, '更新状态功能-宿舍是否满人状态更新成功'))
if num_n == ():
updatepeopleTB(dormitory_id, floor_id,
bed).updatepeople()
content = jsonify(format(True, bed, "<-当前人数-宿舍更新成功"))
else:
content = jsonify(format_false(False, None, '宿舍更新失败'))
else:
content = jsonify(format_full(False, None, '人多床少'))
except:
content = jsonify(format_false(False, None, '宿舍更新--成功失败，重复提交'))
else:
content = jsonify(format_false(False, None, "101"))
return content
def get_gotomessage():
if request.method == 'GET':
try:
menulist = LeaveTB.select_leavemsg()
if menulist == ():
content = jsonify(format_false(False, None, "外出信息请求失败"))
else:
content = jsonify(format(True, menulist, '外出信息请求成功'))
except:
content = jsonify(format_false(False, None, '可能是代码错误'))
else:
content = jsonify(format_false(False, None, '101'))
return content
def getstudent():
if request.method == 'GET':
try:
studentlist = StudentTB.selectstudent()
if studentlist == ():
content = jsonify(format_false(False, None, "学生息请求失败"))
else:
content = jsonify(format(True, studentlist, "学生信息请求成功"))
except:
content = jsonify(format_false(False, None, '可能是代码错误'))
else:
content = jsonify(format_false(False, None, '101'))
return content
def getmenu():
if request.method == 'GET':
try:
menulist = MenuTB.selectmenu() # 查左侧菜单
if menulist == ():
content = jsonify(format_false(False, None, "菜单请求失败"))
else:
content = jsonify(format(True,menulist,'菜单请求成功'))
except:
content = jsonify(format_false(False,None, '可能是代码错误'))
else:
content = jsonify(format_false(False, None, '101'))
return content
def get_addnum():
if request.method == 'GET':
try:
houselist = MessageTB.selecthouse()
if houselist == ():
content = jsonify(format_false(False, None, "楼的数量信息请求失败"))
else:
content = jsonify(format(True, houselist, "楼的数量信息请求成功"))
except:
content = jsonify(format_false(False, None, '楼的数量信息-可能是代码错误'))
else:
content = jsonify(format_false(False, None, '101'))
return content
def getmessage_update():
if request.method == 'GET':
try:
countlist = selectdormitorymsgTB.selectcount()
if countlist == ():
content = jsonify(format_false(False, None, "更新宿舍表的人数信息请求失败"))
else:
content = jsonify(format(True, countlist, "更新宿舍表的人数信息请求成功"))
except:
content = jsonify(format_false(False, None, '更新宿舍表的人数-可能是代码错误'))
else:
content = jsonify(format_false(False, None, '101'))
return content
def get_stumsg():
if request.method == 'GET':
try:
houselist = MessageTB.selectstumsg() # 查左侧菜单
if houselist == ():
content = jsonify(format_false(False, None, "楼层和学生信息请求失败"))
else:
content = jsonify(format(True, houselist, "学生信息和楼层信息请求成功"))
except:
content = jsonify(format_false(False, None, '可能是代码错误'))
else:
content = jsonify(format_false(False, None, '101'))
return content
def getmessaged_all():
param = request.form.to_dict()
num = param.get('num')
if request.method == 'POST':
if num == None:
return jsonify(format_false(False, None, "num为空"))
else:
messagelist = selectgotomsgTB(num).selectgotomessage_btn()
if messagelist == ():
content = jsonify(format_false(False, None, "任意查询——外出信息请求失败"))
else:
content = jsonify(format(True, messagelist, "任意查询——外出信息请求成功"))
else:
content = jsonify(format_false(False, None, '101'))
return content
def getstumessage_all():
if request.method == 'POST':
param = request.form.to_dict()
num = param.get('num')
if num == None:
return jsonify(format_false(False, None, "学生num为空"))
else:
messagelis = SelectmsgTB(num).selectstudent_btn()
if messagelis == ():
content = jsonify(format_false(False, None, "任意查询——学生信息请求失败"))
else:
content = jsonify(format(True, messagelis, "任意查询——学生信息请求成功"))
else:
content = jsonify(format_false(False, None, '101'))
return content
def edit_editnum(num):
if request.method == 'POST':
if num == None:
return jsonify(format_false(False, None, "num为空"))
else:
try:
num_n = SelectmsgTB(num).select_dormitory()
if num_n == ():
content = jsonify(format_false(False, num_n, "编辑-信息获取失败"))
else:
content = jsonify(format(True, num_n, '编辑-信息获取成功'))
except:
content = jsonify(format_false(False, None, '编辑-可能是代码错误'))
else:
content = jsonify(format_false(False, None, "101"))
return content
def getmessage(num):
if request.method == 'POST':
if num == None:
return jsonify(format_false(False, None, "num为空"))
else:
try:
messagelist = SelectmsgTB(
num).selectdormitory_parameter()
if messagelist == ():
content = jsonify(format_false(False, None, "楼宇按钮楼信息请求失败"))
else:
content = jsonify(format(True, messagelist, "楼宇按钮楼信息请求成功"))
except:
content = jsonify(format_false(False, None, '可能是代码错误'))
else:
content = jsonify(format_false(False, None, '101'))
return content
def delete_num(num):
if request.method == 'PUT':
if num == None:
return jsonify(format_false(False, None, "num为空"))
else:
try:
DeletemsgTB(num).delete_dormitory()
num_n = SelectmsgTB(num).check_dormitory()
if num_n == ():
content = jsonify(format(True, num_n, '删除成功'))
else:
content = jsonify(format_false(False, num_n, "删除失败"))
except:
content = jsonify(format_false(False, None, '可能是代码错误'))
else:
content = jsonify(format_false(False, None, "101"))
return content
def edit_gotomessage(num):
if request.method == 'POST':
if num == None:
return jsonify(format_false(False, None, "num为空"))
else:
try:
num_n = selectgotomsgTB(num).select_gotomsg()
if num_n == ():
content = jsonify(format_false(False, num_n,
"编辑-学生信息获取失败"))
else:
content = jsonify(format(True, num_n, '编辑-学生信息获取成功'))
except:
content = jsonify(format_false(False, None, '编辑-可能是代码错误'))
else:
content = jsonify(format_false(False, None, "101"))
return content
def getstud_message_all():
if request.method == 'POST':
param = request.form.to_dict()
num = param.get('num')
if num == None:
return jsonify(format_false(False, None, "联合查询-num为空"))
else:
messagelist = SelectmsgTB(num).select_student_dormitory()
if messagelist == ():
content = jsonify(
format_false(False, None, "联合查询-学生信息和宿舍信息请求失败"))
else:
content = jsonify(
format(True, messagelist, "联合查询-学生信息和宿舍信息请求成功"))
else:
content = jsonify(format_false(False, None, '101'))
return content
def get_gotomessage1(goto_id, goto_islate):
if request.method == 'PUT':
if not all([goto_id, goto_islate]):
return jsonify(format_false(False, None, "某一项为空"))
else:
try:
num_n = updatestateTB(goto_id, goto_islate).updatestate()
if num_n == ():
content = jsonify(format(True, num_n, '更新状态功能-晚归状态更新成功'))
else:
content = jsonify(
format_false(False, num_n, "更新状态功能-晚归状态更新失败"))
except:
content = jsonify(format_false(False, None, '更新状态功能-可能是代码错误'))
else:
content = jsonify(format_false(False, None, "101"))
return content
def post_addnum():
if request.method == 'POST':
param = request.form.to_dict()
num = param.get('num')
if num == None:
return jsonify(format_false(False, None, "num为空"))
else:
try:
num_n = InsertmsgTB(num).inserthouse()
if num_n == ():
content = jsonify(format(True, num_n, "增加成功"))
else:
content = jsonify(format_false(False, None, '增加失败'))
except:
content = jsonify(format_false(False, None, '增加成功失败，重复提交'))
else:
content = jsonify(format_false(False, None, "101"))
return content
def delete_addnum(num):
if request.method == 'PUT':
if num == None:
return jsonify(format_false(False, None, "num为空"))
else:
try:
DeletemsgTB(num).deletehouse()
DeletemsgTB(num).delete_floor_id()
num_n = SelectmsgTB(num).selecthouse_parameter()
if num_n == ():
content = jsonify(format(True, num_n, '删除成功'))
else:
content = jsonify(format_false(False, num_n, "删除失败"))
except:
content = jsonify(format_false(False, None, '可能是代码错误'))
else:
content = jsonify(format_false(False, None, "101"))
return content
def delete_gotomessage(id):
if request.method == 'PUT':
if id == None:
return jsonify(format_false(False, None, "num为空"))
else:
try:
DeletegotomsgTB(id).delete_gotomessage()
num_n = selectgotomsgTB(id).select_gotomessage()
if num_n == ():
content = jsonify(format(True, num_n, '外出删除功能-外出删除成功'))
else:
content = jsonify(
format_false(False, num_n, "外出删除功能-外出删除失败"))
except:
content = jsonify(format_false(False, None, '外出删除功能-可能是代码错误'))
else:
content = jsonify(format_false(False, None, "101"))
return content
def edit_student(num):
if request.method == 'POST':
if num == None:
return jsonify(format_false(False, None, "num为空"))
else:
try:
global results
num_n = SelectmsgTB(num).select_studentmsg()
results = num_n
if num_n == ():
content = jsonify(format_false(False, num_n,
"编辑-学生信息获取失败"))
else:
content = jsonify(format(True, num_n, '编辑-学生信息获取成功'))
except:
content = jsonify(format_false(False, None, '编辑-可能是代码错误'))
else:
content = jsonify(format_false(False, None, "101"))
return content
def delete_student(num):
if request.method == 'PUT':
if num == None:
return jsonify(format_false(False, None, "num为空"))
else:
try:
DeletemsgTB(num).delete_student_msg()
DeletemsgTB(num).delete_student()
num_n = SelectmsgTB(num).select_student()
if num_n == ():
content = jsonify(format(True, num_n, '学生删除功能-学生删除成功'))
else:
content = jsonify(
format_false(False, num_n, "学生删除功能-学生删除失败"))
except:
content = jsonify(format_false(False, None, '学生删除功能-可能是代码错误'))
else:
content = jsonify(format_false(False, None, "101"))
return content
def hello():
return jsonify(format(True, {}, '这是首页'),)
def post_addstumsg():
if request.method == 'POST':
param = request.form.to_dict()
stu_id = param.get('num[stu_id]')
stu_name = param.get('num[stu_name]')
stu_gender = param.get('num[stu_gender]')
stu_age = param.get('num[stu_age]')
stu_depart = param.get('num[stu_depart]')
stu_grade = param.get('num[stu_grade]')
stu_phone = param.get('num[stu_phone]')
stu_dormitory = param.get('num[stu_dormitory]')
stu_dormitory_id = param.get('num[stu_dormitory_id]')
if not all([
stu_id, stu_name, stu_gender, stu_age, stu_depart, stu_grade,
stu_phone, stu_dormitory, stu_dormitory_id
]):
return jsonify(format_false(False, None, "表单有空的"))
else:
# 先判断学生的id是否存在
isnull = SelectmsgTB(stu_id).select_student()
if isnull == ():
count = InsertstudentmsgTB(stu_id, stu_name, stu_gender,
stu_age, stu_depart, stu_grade,
stu_phone, stu_dormitory,
stu_dormitory_id).selectstudent()
bed = selectdormitorymsgTB(
stu_dormitory, stu_dormitory_id).selectdormitorylist()
# count是从0开始的, count<4 0,1,2,3
if count < bed:
num = InsertstudentmsgTB(stu_id, stu_name, stu_gender,
stu_age, stu_depart, stu_grade,
stu_phone, stu_dormitory,
stu_dormitory_id).insertstudent()
count = InsertstudentmsgTB(
stu_id, stu_name, stu_gender, stu_age, stu_depart,
stu_grade, stu_phone, stu_dormitory,
stu_dormitory_id).selectstudent()
bed = selectdormitorymsgTB(
stu_dormitory, stu_dormitory_id).selectdormitorylist()
if count == bed:
state = updatestateTB(stu_dormitory, stu_dormitory_id,
'1').updatestate()
if state == ():
content = jsonify(
format(True, state, '更新状态功能--宿舍是否满人状态更新成功'))
if num == ():
updatepeopleTB(stu_dormitory, stu_dormitory_id,
count).updatepeople()
content = jsonify(
format(True, count, "<-当前人数-添加-学生信息成功"))
else:
content = jsonify(format_false(False, num,
'添加-学生信息失败'))
else:
# 更改状态
content = jsonify(format_full(False, None,
'宿舍成员已经满了')) # 状态码202
else:
content = jsonify(
format_iscunzai(False, isnull, "学生添加功能-学生id已经存在"))
else:
content = jsonify(format_false(False, None, "101"))
return content
def edit_student_editnum_commit():
if request.method == 'POST':
param = request.form.to_dict()
stu_id = param.get('num[stu_id]')
stu_name = param.get('num[stu_name]')
stu_gender = param.get('num[stu_gender]')
stu_age = param.get('num[stu_age]')
stu_depart = param.get('num[stu_depart]')
stu_grade = param.get('num[stu_grade]')
stu_phone = param.get('num[stu_phone]')
stu_dormitory = param.get('num[stu_dormitory]')
stu_dormitory_id = param.get('num[stu_dormitory_id]')
if not all([
stu_id, stu_name, stu_gender, stu_age, stu_depart, stu_grade,
stu_phone, stu_dormitory, stu_dormitory_id
]):
return jsonify(format_false(False, None, "表单有空的"))
else:
cunzai = selectdormitorymsgTB(stu_dormitory,
stu_dormitory_id).selectdormitory()
if cunzai == ():
content = jsonify(format_nofind(False, None, "学生信息更新失败"))
else:
bed = selectdormitorymsgTB(
stu_dormitory, stu_dormitory_id).selectdormitorylist()
count = InsertstudentmsgTB(stu_id, stu_name, stu_gender,
stu_age, stu_depart, stu_grade,
stu_phone, stu_dormitory,
stu_dormitory_id).selectstudent()
# try:
dict1 = results[0]
# print(dict1['stu_dormitory_id'], dict1['stu_dormitory'])
# count是从0开始的, count<4 0,1,2,3
# print(count,bed)
if count <= bed:
num_n = UpdatastudentTB(stu_id, stu_name, stu_gender,
stu_age, stu_depart, stu_grade,
stu_phone, stu_dormitory,
stu_dormitory_id).updatestudent()
selectdormitorymsgTB(
dict1['stu_dormitory'],
dict1['stu_dormitory_id']).updatecount()
bed = selectdormitorymsgTB(
stu_dormitory, stu_dormitory_id).selectdormitorylist()
count = InsertstudentmsgTB(
stu_id, stu_name, stu_gender, stu_age, stu_depart,
stu_grade, stu_phone, stu_dormitory,
stu_dormitory_id).selectstudent()
if count > bed:
num_n = UpdatastudentTB(
dict1['stu_id'], dict1['stu_name'],
dict1['stu_gender'], dict1['stu_age'],
dict1['stu_depart'], dict1['stu_grade'],
dict1['stu_phone'], dict1['stu_dormitory'],
dict1['stu_dormitory_id']).updatestudent()
content = jsonify(format_false(False, None,
"学生信息更新失败"))
else:
content = jsonify(format(True, num_n, "学生信息更新成功"))
else:
content = jsonify(format_full(False, None,
'宿舍成员已经满了')) # 状态码202
# except:
# content = jsonify(format_false(False, None, '宿舍更新--成功失败，重复提交'))
else:
content = jsonify(format_false(False, None, "101"))
return content
