def get_carts_by_uid(self): args = request.args.to_dict() print(self.title.format("args")) print(args) print(self.title.format("args")) if "token" not in args or "AAid" not in args: return PARAMS_MISS token = args.get("token") uid = token_to_usid(token) ASid = args.get("ASid") is_user = self.susers.get_user_by_usid(uid) print(self.title.format("is_user")) print(is_user) print(self.title.format("is_user")) if not is_user: return import_status("ERROR_MESSAGE_NONE_USER", "LOVEBREAKFAST_ERROR", "ERROR_CODE_NONE_USER") cart_info_list = [] cart_list = self.scart.get_carts_by_Uid(uid) print(self.title.format("cartlist")) print(cart_list) print(self.title.format("cartlist")) aaid_list = self.sadd.get_addabo_by_asid(ASid) for cart in cart_list: if cart.CAstatus != 1: continue PRid = cart.PRid address_list = [i.AAid for i in self.smach.get_aaid_by_prid(PRid)] print(self.title.format("address_list")) print(address_list) print(self.title.format("address_list")) if not address_list: return SYSTEM_ERROR if not set(address_list).intersection(aaid_list): continue cart_service_info = self.spro.get_all_pro_fro_carts(PRid) print(self.title.format("cart_service_info")) print(cart_service_info) print(self.title.format("cart_service_info")) if not cart_service_info: return SYSTEM_ERROR cart_info = {} cart_info["PRid"] = cart_service_info.PRid cart_info["PRimage"] = cart_service_info.PRimage cart_info["PRname"] = cart_service_info.PRname cart_info["PRstatus"] = cart_service_info.PRstatus cart_info["PRsalesvolume"] = cart_service_info.PRsalesvolume cart_info["PRprice"] = cart_service_info.PRprice cart_info["PRscore"] = cart_service_info.PRscore cart_info["CAnumber"] = cart.CAnumber cart_info_list.append(cart_info) back_response = import_status("SUCCESS_GET_MESSAGE", "OK") back_response["data"] = cart_info_list return back_response
def get_order_user(self): args = request.args.to_dict() if "token" not in args: return PARAMS_MISS print(self.title.format("args")) print(args) print(self.title.format("args")) token = args.get("token") Uid = token_to_usid(token) users_info = self.susers.get_all_users_info(Uid) if not users_info: return SYSTEM_ERROR response_user_info = {} Utel = users_info.UStelphone response_user_info["Utel"] = Utel if users_info.USname not in ["", None]: Uname = users_info.USname response_user_info["Uname"] = Uname else: response_user_info["Uname"] = None if users_info.USsex not in ["", None]: Usex = users_info.USsex response_user_info["Usex"] = Usex else: response_user_info["Usex"] = None response_of_get_all = import_status("messages_get_item_ok", "OK") response_of_get_all["data"] = response_user_info return response_of_get_all
def all_info(self): args = request.args.to_dict() print(self.title.format("args")) print(args) print(self.title.format("args")) if "token" not in args: return PARAMS_MISS token = args.get("token") Uid = token_to_usid(token) users_info = get_model_return_dict(self.susers.get_all_users_info(Uid)) print(self.title.format("users_info")) print(users_info) print(self.title.format("users_info")) if not users_info: return SYSTEM_ERROR if users_info.get("USsex") not in["", None]: Usex = users_info.get("USsex") if Usex == 101: users_info["USsex"] = "男" elif Usex == 102: users_info["USsex"] = "女" else: users_info["USsex"] = "未知性别" else: users_info["USsex"] = None back_response = import_status("SUCCESS_GET_MESSAGE", "OK") back_response["data"] = users_info return back_response
def add_cardpackage(self): args = request.args.to_dict() data = json.loads(request.data) if "token" not in args: return PARAMS_MISS token = args.get("token") uid = token_to_usid(token) couid = data.get("COid") try: cart_pkg = self.scoupons.get_card_by_uid_couid(uid, couid) cend = get_db_time_str() # 后期补充优惠券截止日期计算方法 if cart_pkg: if cart_pkg.CAstatus == 2: return import_status("error_coupons_used", "LOVEBREAKFAST_ERROR", "error_coupons_used") self.scoupons.update_carbackage(cart_pkg.CAid) else: self.scoupons.add_cardpackage(**{ "CAid": str(uuid.uuid4()), "USid": uid, "CAstatus": 1, "CAstart": get_db_time_str(), "CAend": cend, "COid": couid }) except dberror: return SYSTEM_ERROR except Exception as e: print(e.message) return SYSTEM_ERROR return import_status("messages_add_coupons_success", "OK")
def get_order_abo(self): args = request.args.to_dict() if "token" not in args or "OMid" not in args: return PARAMS_MISS print(self.title.format("args")) print(args) print(self.title.format("args")) Oid = args["OMid"] token = args.get("token") Uid = token_to_usid(token) order_abo = get_model_return_dict( self.sorders.get_order_abo_by_oid(Oid)) print(self.title.format("order_abo")) print(order_abo) print(self.title.format("order_abo")) order_abo["OMtime"] = timeformate.get_web_time_str( order_abo.get("OMtime")) order_abo["is_index"] = 701 if self.checktime() or order_abo.get("OMstatus") > 21 or order_abo.get( "OMstatus") == 0: order_abo["is_index"] = 702 order_abo["OMstatus"] = self.get_status_name_by_status( order_abo.get("OMstatus")) order_abo["OMdate"] = timeformate.get_web_time_str( order_abo.get("OMdate")) users = get_model_return_dict(self.susers.get_uname_utel_by_uid(Uid)) print(self.title.format("users")) print(users) print(self.title.format("users")) order_abo.update(users) order_items = get_model_return_list( self.sorders.get_order_item_by_oid(Oid)) print(self.title.format("order_items")) print(order_items) print(self.title.format("order_items")) order_abo["Orderitems"] = order_items addabo = get_model_return_dict( self.sadd.get_addabo_by_addid(order_abo.get("AAid"))) print(self.title.format("addabo")) print(addabo) print(self.title.format("addabo")) order_abo.update(addabo) for row in order_items: product = get_model_return_dict( self.sproduct.get_product_all_by_pid(row.get("PRid"))) print(self.title.format("product")) print(product) print(self.title.format("product")) row.update(product) response_make_main_order = import_status("messages_get_item_ok", "OK") response_make_main_order["data"] = order_abo return response_make_main_order
def get_order_list(self): args = request.args.to_dict() if "token" not in args: return PARAMS_MISS print(self.title.format("args")) print(args) print(self.title.format("args")) token = args.get("token") Uid = token_to_usid(token) # 暂时不处理过滤 order_list = get_model_return_list( self.sorders.get_all_order_by_uid(Uid)) print(self.title.format("order_list")) print(order_list) print(self.title.format("order_list")) data = [] if order_list: for row in order_list: status = row.get("OMstatus") row["OMtime"] = timeformate.get_web_time_str( str(row.get("OMtime"))) if status > 21 or status == 0 or self.checktime(): row["is_index"] = 702 else: row["is_index"] = 701 row["OMstatus"] = self.get_status_name_by_status(status) row["Orderitems"] = [] order_items = get_model_return_list( self.sorders.get_order_item_by_oid(row.get("OMid"))) print(self.title.format("order_items")) print(order_items) print(self.title.format("order_items")) for raw in order_items: Pid = raw.get("PRid") PRnumber = raw.get("PRnumber") product = get_model_return_dict( self.sproduct.get_product_all_by_pid(Pid)) product["PRid"] = Pid product["PRnumber"] = PRnumber print(self.title.format("product")) print(product) print(self.title.format("product")) row["Orderitems"].append(product) data.append(row) response_make_main_order = import_status("messages_get_item_ok", "OK") from LoveBreakfast.config.urlconfig import product_url_list response_make_main_order["sowing"] = product_url_list response_make_main_order["data"] = data return response_make_main_order
def add_or_update_cart(self): args = request.args.to_dict() print(self.title.format("args")) print(args) print(self.title.format("args")) data = json.loads(request.data) print(self.title.format("data")) print(data) print(self.title.format("data")) if "token" not in args: return PARAMS_MISS token = args.get("token") uid = token_to_usid(token) pid = data.get("PRid") CAnumber = data.get("CAnumber") if CAnumber <= 0: PBnumber = self.scart.get_pbnumber_by_pbid_and_usid(pid, uid) pnum = int(CAnumber) + int(PBnumber) if pnum <= 0: return self.del_cart(uid, pid) try: if not self.sproduct.get_pro_info_by_pid(pid): return import_status("ERROR_MESSAGE_NONE_PRODUCT", "SHARPGOODS_ERROR", "ERROR_NONE_PRODUCT") cart = self.scart.get_cart_by_uid_pid(uid, pid) print(self.title.format("cart")) print(cart) print(self.title.format("cart")) if cart: PBnumber = self.scart.get_pbnumber_by_pbid_and_usid(pid, uid) pnum = int(CAnumber) + int(PBnumber) self.scart.update_num_cart(pnum, cart.CAid) else: add_model( "Cart", **{ "CAid": str(uuid.uuid1()), "CAnumber": CAnumber, "USid": uid, "CAstatus": 1, "PRid": pid }) except dberror: return SYSTEM_ERROR except Exception as e: print(e.message) return SYSTEM_ERROR return import_status("SUCCESS_MESSAGE_UPDATE_CART", "OK")
def update_info(self): args = request.args.to_dict() print(self.title.format("args")) print(args) print(self.title.format("args")) if "token" not in args: return PARAMS_MISS token = args.get("token") Uid = token_to_usid(token) is_user = self.susers.get_user_by_usid(Uid) print(self.title.format("is_user")) print(is_user) print(self.title.format("is_user")) if not is_user: return import_status("ERROR_MESSAGE_NONE_USER", "LOVEBREAKFAST_ERROR", "ERROR_CODE_NONE_USER") data = request.data data = json.loads(data) print(self.title.format("data")) print(data) print(self.title.format("data")) if "USname" not in data and "USsex" not in data: return PARAMS_MISS users = {} if "USname" in data: users["USname"] = data["USname"] if "USsex" in data: Usex = data["USsex"] if Usex == "男": Usex = 101 else: Usex = 102 users["USsex"] = Usex update_info = self.susers.update_users_by_uid(Uid, users) print(self.title.format("update_info")) print(update_info) print(self.title.format("update_info")) if not update_info: return SYSTEM_ERROR back_response = import_status("SUCCESS_MESSAGE_UPDATE_INFO", "OK") return back_response
def del_product(self): args = request.args.to_dict() print(self.title.format("args")) print(args) print(self.title.format("args")) if "token" not in args: return PARAMS_MISS data = json.loads(request.data) print(self.title.format("data")) print(data) print(self.title.format("data")) if "PRid" not in data: return PARAMS_MISS token = args.get("token") uid = token_to_usid(token) return self.del_cart(uid, data.get("PRid"))
def get_review(self): args = request.args.to_dict() print(self.title.format("args")) print(args) print(self.title.format("args")) if "OMid" not in args.keys() or "token" not in args.keys(): return PARAMS_MISS token = args.get("token") USid = token_to_usid(token) # TODO USid的作用? OMid = get_str(args, "OMid") all_review = get_model_return_list( self.service_review.get_review(OMid)) print(self.title.format("all_review")) print(all_review) print(self.title.format("all_review")) if not all_review: return SYSTEM_ERROR for row in all_review: product = get_model_return_dict( self.service_product.get_product_all_by_pid(row.get("PRid"))) print(self.title.format("product")) print(product) print(self.title.format("product")) if not product: return SYSTEM_ERROR row.update(product) back_response = import_status("SUCCESS_MESSAGE_ADD_REVIEW", "OK") back_response["data"] = all_review return back_response
def make_main_order(self): return TIME_ERROR args = request.args.to_dict() data = request.data data = json.loads(data) print(self.title.format("args")) print(args) print(self.title.format("args")) print(self.title.format("data")) print(data) print(self.title.format("data")) if "token" not in args: return PARAMS_MISS params_list = ["Order_items", "OMtime", "OMdate", "OMtotal", "AAid"] for params in params_list: if params not in data: return PARAMS_MISS token = args.get("token") Uid = token_to_usid(token) OMtime = timeformate.get_db_time_str(data["OMtime"]) if self.checktime(): return import_status("error_make_ordermain_time", "LOVEBREAKFAST_ERROR", "error_make_ordermain_time") OMdate = timeformate.get_db_time_str(data["OMdate"]) if not self.check_order_date(OMdate): return import_status("") order_item = data["Order_items"] OMcode = self.make_code() import uuid aaid = get_str(data, "AAid") OMid = str(uuid.uuid1()) try: for op in order_item: prostatus = self.sproduct.get_product_status_by_prid( op.get("PRid")) print(self.title.format("prostatus")) print(prostatus.PRstatus) print(self.title.format("prostatus")) if prostatus.PRstatus != 1: return import_status("error_no_pro", "LOVEBREAKFAST_ERROR", "error_no_pro") mach = self.smach.get_maid_by_aaid_prid( get_str(data, "AAid"), op.get("PRid")) print(self.title.format("mach")) print(mach) print(self.title.format("mach")) if not mach: return SYSTEM_ERROR self.sorders.add_model( "Orderpart", **{ "OPid": str(uuid.uuid1()), "OMid": OMid, "PRid": op.get("PRid"), "PRnumber": op.get("PRnumber") }) cart = get_model_return_dict( self.scart.get_cart_by_uid_pid(Uid, get_str(op, "PRid"))) print(self.title.format("cartt")) print(cart) print(self.title.format("cartt")) self.scart.del_carts(cart.get("CAid")) print(self.title.format("success add orderpart")) self.sorders.add_model( "Ordermain", **{ "OMid": OMid, "OMtime": OMtime, "OMdate": OMdate, "OMstatus": 7, "USid": Uid, "AAid": aaid, "OMcode": OMcode, "OMabo": get_str(data, "OMabo"), "OMtotal": data.get("OMtotal") }) self.scoupons.update_carbackage(get_str(data, "CAid")) response_make_main_order = import_status( "messages_add_main_order_success", "OK") response_make_main_order["data"] = {} response_make_main_order["data"]["OMid"] = OMid return response_make_main_order except Exception as e: print(self.title.format("error")) print(e.message) print(self.title.format("error")) return SYSTEM_ERROR
def create_review(self): args = request.args.to_dict() print(self.title.format("args")) print(args) print(self.title.format("args")) if "token" not in args.keys() or "OMid" not in args.keys(): return PARAMS_MISS token = args.get("token") USid = token_to_usid(token) OMid = get_str(args, "OMid") OMstatus = self.service_order.get_omstatus_by_omid(OMid) if OMstatus >= 49: return import_status("ERROR_MESSAGE_WRONG_OMSTATUS", "LOVEBREAKFAST_ERROR", "ERROR_CODE_WRONG_OMSTATUS") data = request.data data = json.loads(data) print(self.title.format("data")) print(data) print(self.title.format("data")) for row in data: print(self.title.format("data_item")) print(row) print(self.title.format("data_item")) if "PRid" not in row or "REscore" not in row: return PARAMS_MISS if "REcontent" in row: REcontent = row["REcontent"] else: REcontent = None PRid = row["PRid"] REscore = row["REscore"] print(self.title.format("REscore")) print(REscore) print(self.title.format("REscore")) try: add_model( "Review", **{ "REid": str(uuid.uuid1()), "OMid": OMid, "PRid": PRid, "USid": USid, "REscore": REscore, "REcontent": REcontent, "REstatus": 1 }) except Exception as e: print(self.title.format("add_review")) print(e.message) print(self.title.format("add_review")) return SYSTEM_ERROR product_volue = self.service_product.get_product_volume_by_prid( PRid) product_score = self.service_product.get_product_score_by_prid( PRid) score = (product_score * product_volue + REscore) / product_volue product = {"PRscore": score} update_product = self.service_product.update_product_by_prid( PRid, product) print(self.title.format("update_product")) print(update_product) print(self.title.format("update_product")) if not update_product: return SYSTEM_ERROR order = {"OMstatus": 49} update_order = self.service_order.update_ordermain_by_omid( OMid, order) print(self.title.format("update_order")) print(update_order) print(self.title.format("update_order")) if not update_order: return SYSTEM_ERROR back_response = import_status("SUCCESS_MESSAGE_ADD_REVIEW", "OK") return back_response
def get_cart_pkg(self): args = request.args.to_dict() if "token" not in args: return PARAMS_MISS token = args.get("token") uid = token_to_usid(token) try: cart_list = [] cart_pkgs = self.scoupons.get_cardpackage_by_uid(uid) print(self.title.format("cart_pkgs")) print(cart_pkgs) print(self.title.format("cart_pkgs")) for cart_pkg in cart_pkgs: if cart_pkg.CAstatus == 2: continue coupon = self.scoupons.get_coupons_by_couid(cart_pkg.COid) print(self.title.format("coupon")) print(coupon) print(self.title.format("coupon")) cart = {} COtype = coupon.COtype print(self.title.format("COtype")) print(COtype) print(self.title.format("COtype")) cart["CAid"] = cart_pkg.CAid cart["COid"] = cart_pkg.COid if COtype == 801: COfilter = coupon.COfilter cart["COuse"] = "满{0}元可用".format(COfilter) COcut = coupon.COamount cart["COcut"] = str(COcut) + "元" COstart = coupon.COstart cart["COstart"] = get_web_time_str(COstart, format_forweb_no_HMS) COend = coupon.COend cart["COend"] = get_web_time_str(COend, format_forweb_no_HMS) elif COtype == 802: COfilter = coupon.COfilter cart["COuse"] = "满{0}元可用".format(COfilter) cart["COcut"] = str(coupon.COdiscount * 10) + "折" COstart = coupon.COstart cart["COstart"] = get_web_time_str(COstart, format_forweb_no_HMS) COend = coupon.COend cart["COend"] = get_web_time_str(COend, format_forweb_no_HMS) elif COtype == 803: CObrand = coupon.CObrand.encode("utf8") cart["COuse"] = "限{0}商品可用".format(str(CObrand)) cart["COcut"] = str(coupon.COamount) + "元" COstart = coupon.COstart cart["COstart"] = get_web_time_str(COstart, format_forweb_no_HMS) COend = coupon.COend cart["COend"] = get_web_time_str(COend, format_forweb_no_HMS) elif COtype == 804: cart["COuse"] = "无限制" cart["COcut"] = str(coupon.COamount) + "元" COstart = coupon.COstart cart["COstart"] = get_web_time_str(COstart, format_forweb_no_HMS) COend = coupon.COend cart["COend"] = get_web_time_str(COend, format_forweb_no_HMS) else: return cart_list.append(cart) except Exception as e: print("ERROR: " + e.message) return SYSTEM_ERROR result = import_status("messages_get_carpkg_success", "OK") result["data"] = cart_list return result