def delete_book_page():
if request.method == 'GET':
return render_template('delete_book.html', login_flag=is_auth_in())
isbn = request.form['isbn']
book = Book.query.get(isbn)
book.delete_flag = 0
db.session.commit()
flash("删除成功")
return render_template('delete_book.html', login_flag=is_auth_in())
def member_modify_page():
if request.method == 'GET':
return render_template('modify_member.html', login_flag=is_auth_in())
new_name = request.form['name']
new_phone = request.form['phone']
email = request.form['email']
new_level = request.form['level']
new_email = request.form['new_email']
member = Member.query.filter(Member.email == email).first()
if member is None:
return render_template('membermanager.html', msg="用户不存在")
if new_name != "":
member.name = new_name
if new_phone != "":
member.phone = new_phone
if new_email != "":
member.email = new_email
if new_level != "":
member.level = new_level
db.session.commit()
flash('修改完成！')
return redirect(url_for('member_manager'))
def add_member_page():
if request.method == 'GET':
return render_template('add_member.html', login_flag=is_auth_in())
name = request.form['name']
phone = request.form['phone']
email = request.form['email']
level = request.form['level']
check_member = Member.query.filter(Member.email == email).first()
if check_member is not None:
return render_template('membermanager.html', login_flag=is_auth_in(), msg='会员已存在！')
member = Member(name, phone, email, level, True)
db.session.add(member)
db.session.commit()
flash("添加成功！")
return redirect(url_for("member_manager"))
def delete_member_page():
if request.method == 'GET':
return render_template('delete_member.html', login_flag=is_auth_in())
email = request.form['email']
if email is None:
return render_template('membermanager.html', login_flag=is_auth_in(), msg="邮箱不存在")
member = Member.query.filter(Member.email == email).first()
if member is None:
return render_template('membermanager.html', login_flag=is_auth_in(), msg="用户不存在")
if member.delete_flag == False:
return render_template('membermanager.html', login_flag=is_auth_in(), msg='用户已删除！')
member.delete_flag = False
db.session.commit()
flash('删除成功！')
return redirect(url_for('member_manager'))
def add_book_page():
if request.method == 'GET':
return render_template("addbook.html", login_flag=is_auth_in())
book_name = request.form['name']
book_isbn = request.form['isbn']
book_price = request.form['price']
book_author = request.form['author']
book_press = request.form['press']
book_purchase_price = request.form['purchase_price']
# book_supplier = request.form['id']
# book_warehouse = request.form['warehouse']
# book_amount = request.form['amount']
check_book = Book.query.get(book_isbn)
# check_supplier = Supplier.query.get(book_supplier)
# check_warehouse = Warehouse.query.get(book_warehouse)
if check_book is not None:
return render_template('addbook.html', msg='书籍已存在！')
# if check_supplier is None:
# return render_template('addbook.html', msg="供应商不存在！")
#
# if check_warehouse is None:
# return render_template('addbook.html', msg="无此仓库")
# if book_amount is None:
# book_amount = 0
book = Book(book_isbn, book_name, book_price, book_author, book_press,
book_purchase_price, True)
db.session.add(book)
db.session.commit()
# book_stock = BookStock(book_isbn, id, book_amount)
# db.session.add(book_stock)
# # supplier = SupplierBook(book_isbn, book_supplier)
# # db.session.add(supplier)
# db.session.commit()
flash('添加成功！')
return redirect(url_for('add_book_page'))
def warehouse_page():
return render_template('warehouse_manager.html', login_flag=is_auth_in())
def member_manager():
return render_template("membermanager.html", login_flag=is_auth_in())