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