def popular_recommendation():
data = json.loads(request.get_data("").decode("utf-8"))
past_time = ''
language = ''
category1 = ''
category2 = ''
C = Condition()
st = set_time()
today_time = st.today()
if "time" in data and data["time"]:
past_time = st.time_frame(C.where_time(data["time"]))
if "language" in data and data["language"]:
language = C.language(data["language"])
if "category1" in data:
category1 = data["category1"]
if "category2" in data:
category2 = data["category2"]
result = db_user_activity.sql_popular_recommendation(
today_time, past_time, language, category1, category2)
if not result[0]:
return jsonify({"status": -1, "message": "fail"})
for i in range(0, len(result[1])):
result[1][i][
"book_img_path"] = "http://47.96.139.19:6868/library/img/" + result[
1][i]["book_img_path"]
return jsonify({"status": 0, "message": "success", "data": result[1]})
def conditional_book_info():
data = json.loads(request.get_data("").decode("utf-8"))
book_id = ""
book_name = ""
book_publisher = ""
book_room = ""
book_state = ""
C = Condition()
if "book_id" in data:
book_id = data["book_id"]
if "book_name" in data:
book_name = data["book_name"]
if "book_publisher" in data:
book_publisher = data["book_publisher"]
if "book_room" in data:
book_room = data["book_room"]
if "book_state" in data:
book_state = C.state(data["book_state"])
result = db_manage.sql_conditional_book_info(book_id, book_name,
book_publisher, book_room,
book_state)
if not result[0]:
return jsonify({"status": -1, "message": "fail"})
for i in range(len(result[1])):
result[1][i]["book_state"] = C.state(result[1][i]["book_state"])
result[1][i]["book_language"] = C.language(
result[1][i]["book_language"])
return jsonify({"status": 0, "message": "success", "data": result[1]})
def book_info():
result = db_manage.sql_book_info()
if not result[0]:
return jsonify({"status": -1, "message": "fail"})
C = Condition()
for i in range(len(result[1])):
result[1][i]["book_state"] = C.state(result[1][i]["book_state"])
result[1][i]["book_language"] = C.language(
result[1][i]["book_language"])
return jsonify({"status": 0, "message": "success", "data": result[1]})
def popular_book_info():
data = json.loads(request.get_data("").decode("utf-8"))
book_name = data['book_name']
result = db_user_activity.sql_book_name_query(book_name)
result[1][0]["book_category"] = db_user_activity.sql_query_category(
result[1][0]["book_category"])
C = Condition()
result[1][0]["book_state"] = C.state(result[1][0]["book_state"])
result[1][0]["book_language"] = C.language(result[1][0]["book_language"])
if not result[0]:
return jsonify({"status": -1, "message": "fail"})
return jsonify({"status": 0, "message": "success", "data": result[1]})
def query_user_info():
data = json.loads(request.get_data("").decode("utf-8"))
user_account = data["user_account"]
tokens = data["tokens"]
if not token.certify_token(user_account, tokens):
return jsonify({"status": -1, "message": "not login", "data": ""})
user_id = sql_query_user_id(user_account)
result = db_user.sql_query_user_info(user_id)
C = Condition()
result[1][0]['user_sex'] = C.sex(result[1][0]['user_sex'])
if not result:
return jsonify({"status": -1, "message": "fail"})
return jsonify({"status": 0, "message": "success", "data": result[1]})
def query_book():
data = json.loads(request.get_data("").decode("utf-8"))
C = Condition()
txt = data["txt"]
query_mode = "book_name"
if "query_mode" in data and data["query_mode"]:
query_mode = C.books(data["query_mode"])
result = db_user_activity.sql_query_book(query_mode, txt)
if not result[0]:
return jsonify({"status": -1, "massage": "fail", "data": result[1]})
for i in range(len(result[1])):
result[1][i]["book_language"] = C.language(
result[1][i]["book_language"])
return jsonify({"status": "0", "massage": "success", "data": result[1]})
def get_feedback():
data = json.loads(request.get_data("").decode("utf-8"))
if not data["user_name"]:
return jsonify({"status": -1, "message": "fail"})
user_name = data["user_name"]
user_id = sql_query_user_id(user_name)
result = db_user.sql_get_feedback(user_id)
if not result[0]:
return jsonify({"status": -1, "message": "fail"})
C = Condition()
if result[1]:
for i in range(len(result[1])):
result[1][i]["state"] = C.feed(result[1][i]["state"])
return jsonify({"status": 0, "message": "success", "data": result[1]})
def query_book_info():
data = json.loads(request.get_data("").decode("utf-8"))
book_id = data["book_id"]
result = db_user_activity.sql_query_book_info(book_id)
result[1][0]["book_category"] = db_user_activity.sql_query_category(
result[1][0]["book_category"])
C = Condition()
result[1][0]["book_state"] = C.state(result[1][0]["book_state"])
result[1][0]["book_language"] = C.language(result[1][0]["book_language"])
if not result[0]:
return jsonify({"status": -1, "massage": "fail", "data": result[1]})
for i in range(len(result[1])):
result[1][i][
"book_img_path"] = 'http://47.96.139.19:6868/library/images/' + str(
result[1][i]["book_img_path"])
return jsonify({"status": 0, "massage": "success", "data": result[1]})
def class_lookup():
data = json.loads(request.get_data("").decode("utf-8"))
C = Condition()
category1 = ""
category2 = ""
language = ""
if "category1" in data:
category1 = data["category1"]
if "category2" in data:
category2 = data["category2"]
if "language" in data and data["language"]:
language = C.language(data["language"])
result = db_user_activity.sql_class_lookup(category1, category2, language)
if not result[0]:
jsonify({"status": -1, "message": result[1]})
for i in range(len(result[1])):
result[1][i][
"book_img_path"] = "http://47.96.139.19:6868/library/img/" + result[
1][i]["book_img_path"]
return jsonify({"status": 0, "message": "success", "data": result[1]})
def change_book_info():
data = json.loads(request.get_data("").decode("utf-8"))
category1 = data["category1"]
category2 = data["category2"]
C = Condition()
result = db_manage.sql_change_book_info(
book_code=data["book_code"],
book_name=data["book_name"],
book_auther=data["book_auther"],
book_category=db_book.sql_query_book_category(category1, category2)[1],
book_publisher=data["book_publisher"],
book_room=data["book_room"],
book_bookshelf=data["book_bookshelf"],
book_synopsis=data["book_synopsis"],
book_publication_date=data["book_publication_date"],
book_language=C.language(data["book_language"]),
book_id=data["book_id"])
if not result[0]:
return jsonify({"status": -1, "message": "fail"})
return jsonify({"status": 0, "message": "success"})