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