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_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]})