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
