def update_manager_by_matel(self): args = request.args.to_dict() log.info("args", args) if "token" not in args: return PARAMS_MISS data = json.loads(request.data) log.info("data", data) if "MAtelphone" not in data: return PARAMS_MISS maid = token_to_usid(args.get("token")) manager = self.smanager.get_manager_by_maid(maid) if manager.MAidentity > 101: return get_response("ERROR_MESSAGE_NO_PERMISSION", "MANAGERSYSTEMERROR", "ERROR_CODE_NO_PERMISSION") try: from ManagerSystem.models.model import Manager mng = { "MAstatus": conversion_MAstatus_resverse.get(get_str(data, "MAstatus")) } update_result = self.smanager.update_users_by_matel( data.get("MAtelphone"), mng) if not update_result: return get_response("ERROR_MESSAGE_DB_ERROR", "MANAGERSYSTEMERROR", "ERROR_CODE_DB_ERROR") return get_response("SUCCESS_MESSAGE_UPDATE_DATA", "OK") except Exception as e: log.error("update users", e.message) return SYSTEM_ERROR
def update_order_main(self): args = request.args.to_dict() log.info("args", args) if "token" not in args: return PARAMS_MISS maid = token_to_usid(args.get("token")) if not maid: return TOKEN_ERROR data = json.loads(request.data) log.info("data", data) if "OMstatus" not in data or "OMid" not in data: return PARAMS_MISS try: omstatus = cvs.conversion_OMstatus_reverse.get( get_str(data, "OMstatus")) update_result = self.sorder.update_order(get_str(data, "OMid"), {"OMstatus": omstatus}) log.info("update_result", update_result) if not update_result: return get_response("ERROR_MESSAGE_DB_ERROR", "MANAGERSYSTEMERROR", "ERROR_CODE_DB_ERROR") return get_response("SUCCESS_MESSAGE_UPDATE_ORDER", "OK") except Exception as e: log.error("update order", e.message) return SYSTEM_ERROR
def update_permission(self): args = request.args.to_dict() log.info("args", args) data = json.loads(request.data) log.info("data", data) if "token" not in args: return PARAMS_MISS maid = token_to_usid(args.get("token")) manager = self.smanager.get_manager_by_maid(maid) if manager.MAidentity != 100: return get_response("ERROR_MESSAGE_NO_PERMISSION", "MANAGERSYSTEMERROR", "ERROR_CODE_NO_PERMISSION") if "PEid" not in data: return PARAMS_MISS permission = { "PEtype": data.get("PEtype"), "PEsubLevel": data.get("PEsubLevel"), } try: update_result = self.sapproval.update_permission(data.get("PEid"), permission) if not update_result: return get_response("ERROR_MESSAGE_DB_ERROR", "MANAGERSYSTEMERROR", "ERROR_CODE_DB_ERROR") return get_response("SUCCESS_MESSAGE_UPDATE_DATA", "OK") except Exception as e: log.error("update permission", e.message) return SYSTEM_ERROR
def update_manager(self): args = request.args.to_dict() log.info("args", args) if "token" not in args: return PARAMS_MISS data = json.loads(request.data) log.info("data", data) if "MAidentity" not in data or "MAstatus" not in data: return PARAMS_MISS manager = {"MAcreatTime": TimeManager.get_db_time_str()} if data.get("MAidentity"): manager["MAidentity"] = conversion_MAidentity_reverse.get( data.get("MAidentity", "卖家")) if data.get("MAstatus"): manager["MAstatus"] = conversion_MAstatus_resverse.get( data.get("MAstatus"), "可用") maid = token_to_usid(args.get("token")) try: self.smanager.update_manager(maid, manager) return get_response("SUCCESS_MESSAGE_GET_INFO", "OK") except Exception as e: log.error("UPDATEERROR", e.message) return SYSTEM_ERROR
def add_approval(self): args = request.args.to_dict() log.info("args", args) if "token" not in args: return PARAMS_MISS data = json.loads(request.data) log.info("data", data) if "PEtype" not in data or "APcontent" not in data: return PARAMS_MISS petype = conversion_PEtype_resverse.get(get_str(data, "PEtype")) apreceive_list =[apreceive.MAid for apreceive in self.sapproval.get_permission_by_petype_pesublevel(petype, 1)] if not apreceive_list: return get_response("ERROR_MESSAGE_DB_ERROR", "MANAGERSYSTEMERROR", "ERROR_CODE_DB_ERROR") apstart = token_to_usid(args.get("token")) try: apname = get_str(data, "PEtype") + str(uuid.uuid1()) for apreceive in apreceive_list: self.sapproval.add_model("Approval", **{ "APid": str(uuid.uuid1()), "APname": apname, "APstart": apstart, "APstatus": 445, "APreceive": apreceive, "PEtype": petype, "APremark": "", "APcontent": data.get("APcontent"), "APtime": TimeManager.get_db_time_str() }) return get_response("SUCCESS_MESSAGE_ADD_DATA", "OK") except Exception as e: log.error("add approval", e.message) return SYSTEM_ERROR
def add_category(self): args = request.args.to_dict() log.info("args", args) data = json.loads(request.data) if "token" not in args: return PARAMS_MISS # todo 权限审核 try: maid = token_to_usid(args.get("token")) except: return TOKEN_ERROR ctfromid = "0" if "CTid" in data: ctfromid = get_str(data, "CTid") try: ctid = str(uuid.uuid1()) cateary = { "CTid": ctid, "CTfromid": ctfromid, "MAid": maid, "CTname": data.get("CTname") } self.scategory.add_model("Category", **cateary) except Exception as e: log.error("add category", e.message) return SYSTEM_ERROR
def update_stock_product(self): args = request.args.to_dict() log.info("args", args) if "token" not in args: return PARAMS_MISS data = json.loads(request.data) log.info("data", data) if "SPid" not in data: return PARAMS_MISS spid = data.get("SPid") sp = {} for key in self.stock_product_key_list: if key not in data: return PARAMS_MISS sp[key] = data.get(key) try: log.info("sp", sp) update_result = self.sstocks.update_stock_product(spid, sp) log.info("update result", update_result) if not update_result: return get_response("ERROR_MESSAGE_DB_ERROR", "MANAGERSYSTEMERROR", "ERROR_CODE_DB_ERROR") return get_response("SUCCESS_MESSAGE_UPDATE_DATA", "OK") except Exception as e: log.error("add stock product error", e.message) return SYSTEM_ERROR
def get_child(self): args = request.args.to_dict() log.info("args", args) if "token" not in args: return PARAMS_MISS ctid = get_str(args, "CTid", "0") if not ctid: ctid = "0" try: category_filter = {Category.CTfromid == ctid} if "category_filter" in args: category_filter.add( Category.CTname.like("%{0}%".format( get_str(args, "category_filter")))) ct_list = tolist( self.scategory.get_category_by_and_filter(category_filter)) log.info("ct_list", ct_list) response = get_response("SUCCESS_MESSAGE_GET_INFO", "OK") response["data"] = ct_list return response except Exception as e: log.error("get child", e.message) return SYSTEM_ERROR
def get_users(self): args = request.args.to_dict() log.info("args", args) if "token" not in args: return PARAMS_MISS maid = token_to_usid(args.get("token")) try: manager = self.smanager.get_manager_by_maid(maid) if not manager: return SYSTEM_ERROR if manager.MAidentity > 101: return get_response("ERROR_MESSAGE_NO_PERMISSION", "MANAGERSYSTEMERROR", "ERROR_CODE_NO_PERMISSION") page_size = int(args.get("page_size")) page_num = int(args.get("page_num")) or_filter = set() if args.get("USfilter"): from ManagerSystem.models.model import Users or_filter.add( Users.USname.like("%{0}%".format(get_str(args, "USfilter")))) or_filter.add( Users.UStelphone.like("%{0}%".format( get_str(args, "USfilter")))) from ManagerSystem.config.conversion import conversion_USsex pn, count = self.check_page_value(page_num, page_size, "model.Users.USid", set(), or_filter) start_num = (pn - 1) * page_size users = tolist( self.smanager.get_users(start_num, page_size, or_filter)) for user in users: user["USsex"] = conversion_USsex.get(user.get("USsex")) user["UScreateTime"] = TimeManager.get_web_time_str( user.get("UScreateTime")) user["USloginTime"] = TimeManager.get_web_time_str( user.get("USloginTime")) user["USstatus"] = conversion_MAstatus.get( user.get("USstatus")) response = get_response("SUCCESS_MESSAGE_GET_INFO", "OK") response["data"] = { "count": count, "page_num": pn, "page_size": page_size, "USers": users } return response except Exception as e: log.error("get users", e.message) return SYSTEM_ERROR
def get_stock_all(self): args = request.args.to_dict() log.info("args", args) if "token" not in args: return PARAMS_MISS maid = token_to_usid(args.get("token")) try: if "PBid" not in args: prid_list = [ product.PRid for product in self.sproduct.get_product_by_maid(maid) ] log.info("prid list", prid_list) pbid_list = [] for prid in prid_list: pbid_list.extend([ productbrand.PBid for productbrand in self.sproduct.get_productbrand_by_prid(prid) ]) log.info("pbid list", pbid_list) stocks_list = [] for pbid in pbid_list: stock_product_list = tolist( self.sstocks.get_stocks_by_PBid(pbid)) log.info("stock_product_list", stock_product_list) for stock_product in stock_product_list: stock = todict( self.sstocks.get_stock_by_stid( stock_product.get("STid"))) log.info("stock", stock) stock_product.update(stock) stocks_list.extend(stock_product_list) else: stocks_list = tolist( self.sstocks.get_stocks_by_PBid(args.get("PBid"))) for stock_product in stocks_list: stock = todict( self.sstocks.get_stock_by_stid( stock_product.get("STid"))) stock_product.update(stock) response = get_response("SUCCESS_MESSAGE_GET_INFO", "OK") response["data"] = stocks_list return response except Exception as e: log.error("get error", e.message) return SYSTEM_ERROR
def get_managers(self): args = request.args.to_dict() log.info("args", args) if "token" not in args: return PARAMS_MISS page_size = int(args.get("page_size")) page_num = int(args.get("page_num")) or_filter = set() if "MAfilter" in args: from ManagerSystem.models.model import Manager or_filter.add( Manager.MAnicname.like("%{0}%".format(get_str( args, "MAfilter")))) or_filter.add( Manager.MAemail.like("%{0}%".format(get_str(args, "MAfilter")))) maid = token_to_usid(args.get("token")) try: pn, count = self.check_page_value(page_num, page_size, "model.Manager.MAid", set(), or_filter) start_num = (pn - 1) * page_size manager = self.smanager.get_manager_by_maid(maid) if not manager: return SYSTEM_ERROR manager_list = tolist( self.smanager.get_managers(start_num, page_size, or_filter)) for manager in manager_list: manager["MAidentity"] = conversion_MAidentity.get( manager.get("MAidentity")) manager["MAstatus"] = conversion_MAstatus.get( manager.get("MAstatus")) manager["MAloginTime"] = TimeManager.get_web_time_str( manager.get("MAloginTime")) manager["MAcreatTime"] = TimeManager.get_web_time_str( manager.get("MAcreatTime")) response = get_response("SUCCESS_MESSAGE_GET_INFO", "OK") response["data"] = { "count": count, "page_num": pn, "page_size": page_size, "Managers": manager_list } return response except Exception as e: log.error("get managers", e.message) return SYSTEM_ERROR
def get_manager(self): args = request.args.to_dict() log.info("args", args) if "token" not in args: return PARAMS_MISS maid = token_to_usid(args.get("token")) try: manager = todict(self.smanager.get_manager_by_maid(maid)) manager["MAstatus"] = conversion_MAstatus.get( manager.get("MAstatus")) manager["MAidentity"] = conversion_MAidentity.get( manager.get("MAidentity")) return manager except Exception as e: log.error("ERROR", e.message) return SYSTEM_ERROR
def update_pro_info(self): args = request.args.to_dict() log.info("args", args) data = json.loads(request.data, encoding="utf8") log.info("data", data) if "token" not in args: return PARAMS_MISS if "PRid" not in data: return PARAMS_MISS prid = data.get("PRid") product = { "PRimage": json.dumps(data.get("PRimage", [])), "PRvideo": data.get("PRvideo", ""), "PRfranking": data.get("PRfranking", 0), "PRPoint": data.get("PRPoint", ""), "PRtime": TimeManager.get_db_time_str(), } if data.get("PRbrand"): product["PRbrand"] = json.dumps(data.get("PRbrand")) try: update_result = self.sproduct.update_product(prid, product) log.info("update result", update_result) if not update_result: return get_response("ERROR_MESSAGE_DB_ERROR", "MANAGERSYSTEMERROR", "ERROR_CODE_DB_ERROR") # brid_list = [br.BRid for br in self.sproduct.get_brid_by_prid(prid)] # while True: # fromid_list = [] # if not brid_list: # break # for brid in brid_list: # fromid = self.sproduct.get_brfromid_by_brid(brid) # if fromid != "0": # fromid_list.append(fromid) # self.sproduct.del_brand(brid) # brid_list = {}.fromkeys(fromid_list).keys() delete_result = self.sproduct.delete_pb(prid) log.info("delete result", delete_result) self.add_brands(prid, data.get("brands"), data.get("brands_key")) return get_response("SUCCESS_MESSAGE_UPDATE_DATA", "OK") except Exception as e: log.error("update product", e.message) return SYSTEM_ERROR
def forget_password(self): data = json.loads(request.data) log.info("data", data) params_key_list = [ "MApasswordnew", "MApasswordnewrepeat", "MAtelphone", "MAcode" ] for key in params_key_list: if key not in data: return PARAMS_MISS Utel = data["MAtelphone"] try: manager = self.smanager.get_manager_by_matelphone(Utel) log.info("manager", manager) if not manager: return get_response("ERROR_MESSAGE_NONE_TELPHONE", "MANAGERSYSTEMERROR", "ERROR_CODE_NONE_TELPHONE") code_in_db = self.smanager.get_code_by_utel(Utel) if not code_in_db: return get_response("ERROR_MESSAGE_WRONG_TELCODE", "MANAGERSYSTEMERROR", "ERROR_CODE_WRONG_TELCODE") if code_in_db.ICcode != data["MAcode"]: return get_response("ERROR_MESSAGE_WRONG_TELCODE", "MANAGERSYSTEMERROR", "ERROR_CODE_WRONG_TELCODE") if data["MApasswordnew"] != data["MApasswordnewrepeat"]: return get_response("ERROR_MESSAGE_WRONG_REPEAT_PASSWORD", "MANAGERSYSTEMERROR", "ERROR_CODE_WRONG_REPEAT_PASSWORD") users = {} Upwd = data["MApasswordnew"] users["MApassword"] = Upwd update_info = self.smanager.update_users_by_matel(Utel, users) log.info("update info", update_info) if not update_info: return SYSTEM_ERROR return get_response("SUCCESS_MESSAGE_UPDATE_PASSWORD", "OK") except Exception as e: log.error("forget pwd error", e.message) return SYSTEM_ERROR
def get_first(self): args = request.args.to_dict() log.info("args", args) if "token" not in args: return PARAMS_MISS category_filter = {Category.CTfromid == "0"} try: cate_list = tolist( self.scategory.get_category_by_or_filter(category_filter)) log.info("cate list", cate_list) response = get_response("SUCCESS_MESSAGE_GET_INFO", "OK") response["data"] = cate_list return response except Exception as e: log.error("get first", e.message) return SYSTEM_ERROR
def get_approval(self): args = request.args.to_dict() log.info("args", args) if "token" not in args: return PARAMS_MISS try: maid = token_to_usid(args.get("token")) except: return TOKEN_ERROR page_size = int(args.get("page_size")) page_num = int(args.get("page_num")) approval_filter = { Approval.APreceive == maid, } if args.get("APname"): approval_filter.add(Approval.APname.like("%{0}%".format(get_str(args, "APname")))) if args.get("APstart"): apstart = [ma.MAid for ma in self.smanager.get_manager_by_name(args.get("APstart"))] approval_filter.add(Approval.APstart.in_(apstart)) pn, count = self.check_page_value(page_num, page_size, "model.Approval.APid", approval_filter, set()) start_num = (pn - 1) * page_size try: approval_list = tolist(self.sapproval.get_approval_by_and_filter(start_num, page_size, approval_filter)) log.info("approval", approval_list) for approval in approval_list: approval["APstatus"] = conversion_APstatus.get(approval.get("APstatus", 441)) approval["PEtype"] = conversion_PEtype.get(approval.get("PEtype", 304)) manager = self.smanager.get_manager_by_maid(approval.get("APstart")) log.info("manager", manager) approval["APstart"] = manager.MAname approval["APtime"] = TimeManager.get_web_time_str(approval.get("APtime")) response = get_response("SUCCESS_MESSAGE_GET_INFO", "OK") response["data"] = { "approvals": approval_list, "count": count, "page_size": page_size, "page_num": page_num } return response except Exception as e: log.error("get approval", e.message) return SYSTEM_ERROR
def apply_manager(self): data = json.loads(request.data) log.info("data", data) param_keys = ["MAtelphone"] for params in param_keys: if params not in data: return PARAMS_MISS manager_key = [ "MAname", "MAtelphone", "MAemail", "MAidentity", "MApassword", "MAstatus", "MAcreatTime", "MAendTime", "MAidNumber", "MAidImageFront", "MAidImageReverse", "MAbusinessLicense", "MAcredit" ] manager = {} for key in manager_key: if key in data: manager[key] = data.get(key) MAid = str(uuid.uuid1()) manager["MAid"] = MAid maname = "商家{0}".format(data.get( "MAtelphone")) if not data.get("MAname") else data.get("MAname") manager["MAname"] = maname manager["MApassword"] = self.create_password() manager["MAidentity"] = conversion_MAidentity_reverse.get( data.get("MAidentity", "卖家")) manager["MAcreatTime"] = TimeManager.get_db_time_str() manager["MAendTime"] = TimeManager.get_db_time_str( data.get("MAendTime")) manager["MAstatus"] = conversion_MAstatus_resverse.get( data.get("MAstatus", "可用")) try: self.smanager.add_model("Manager", **manager) except Exception as e: log.error("add manager error", e.message) return SYSTEM_ERROR response = get_response("SUCCESS_MESSAGE_REGISTER", "OK") response["data"] = { "MAname": maname, "MApassword": manager["MApassword"] } return response
def get_acabo(self): args = request.args.to_dict() log.info("args", args) if "token" not in args or "COid" not in args: return PARAMS_MISS try: maid = token_to_usid(args.get("token")) except: return TOKEN_ERROR manager = self.smanager.get_manager_by_maid(maid) if not manager: return TOKEN_ERROR coid = args.get("COid") try: co = tolist( self.sactive.get_actives_by_filter( {CouponsActives.COid == coid}, set())) log.info("co", co) if not co: return get_response("ERROR_MESSAGE_DB_ERROR", "MANAGERSYSTEMERROR", "ERROR_CODE_DB_ERROR") co = co[0] co["COstatus"] = conversion_COstatus.get(co["COstatus"]) co["COtype"] = conversion_COtype.get(co["COtype"]) co["COstart"] = TimeManager.get_web_time_str(co["COstart"]) co["COend"] = TimeManager.get_web_time_str(co["COend"]) co["COunit"] = conversion_PBunit.get(co["COunit"]) co["COgenre"] = conversion_COgenre.get(co["COgenre"]) co["COimage"] = json.loads(co["COimage"]) cm_list = self.sactive.get_cm_by_filter( {CouponsManager.COid == coid}, set()) prid = [] for cm in cm_list: if cm.PRid: prid.append(cm.PRid) co["PRids"] = prid response = get_response("SUCCESS_MESSAGE_GET_INFO", "OK") response["data"] = co return response except Exception as e: log.error("get abo", e.message) return SYSTEM_ERROR
def add_stock_product(self): args = request.args.to_dict() log.info("args", args) if "token" not in args: return PARAMS_MISS data = json.loads(request.data) log.info("data", data) sp = {"SPid": str(uuid.uuid1())} for key in self.stock_product_key_list: if key not in data: return PARAMS_MISS sp[key] = data.get(key) try: self.sstocks.add_model("StocksProducts", **sp) return get_response("SUCCESS_MESSAGE_ADD_DATA", "OK") except Exception as e: log.error("add stock product error", e.message) return SYSTEM_ERROR
def add_permission(self): args = request.args.to_dict() log.info("args", args) data = json.loads(request.data) log.info("data", data) if "token" not in args: return PARAMS_MISS try: maid = token_to_usid(args.get("token")) except: return TOKEN_ERROR params_list = ["MAtelphone", "PEtype"] for k in params_list: if k not in data: return PARAMS_MISS manager = self.smanager.get_manager_by_maid(maid) if not manager: return TOKEN_ERROR petype = conversion_PEtype_resverse.get(get_str(data, "PEtype"), 304) try: permissioner = self.smanager.get_manager_by_matelphone(data.get("MAtelphone")) log.info("permissioner", permissioner) if manager.MAidentity != 100: return get_response("ERROR_MESSAGE_NO_PERMISSION", "MANAGERSYSTEMERROR", "ERROR_CODE_NO_PERMISSION") permission = self.sapproval.get_permission_by_maid_petype(permissioner.MAid, petype) log.info("permission", permission) if not permission: self.sapproval.add_model("Permission", **{ "PEid": str(uuid.uuid1()), "PEname": data.get("PEname", ""), "MAid": permissioner.MAid, "PEtype": petype, "PEsubLevel": data.get("PEsubLevel", 1) }) else: self.sapproval.update_permission(permission.PEid, {"PEsubLevel": data.get("PEsubLevel", 1)}) return get_response("SUCCESS_MESSAGE_ADD_DATA", "OK") except Exception as e: log.error("add permission", e.message) return SYSTEM_ERROR
def get_categorybrands(self): args = request.args.to_dict() log.info("args", args) if "token" not in args or "CTid" not in args: return PARAMS_MISS ctid = get_str(args, "CTid") try: category_filter = {CategoryBrand.CTid == ctid} cb_list = tolist( self.scategory.get_categorybrands_by_filter(category_filter)) log.info("cb list", cb_list) response = get_response("SUCCESS_MESSAGE_GET_INFO", "OK") for cb in cb_list: if cb.get("CBvalue"): cb["CBvalue"] = str.split(get_str(cb, "CBvalue"), ",") response["data"] = cb_list return response except Exception as e: log.error("get categprybrands", e.message) return SYSTEM_ERROR
def update_password(self): args = request.args.to_dict() if "token" not in args: return PARAMS_MISS log.info("args", args) maid = token_to_usid(args.get("token")) data = json.loads(request.data) log.info("data", data) params_key = ["MApasswordNew", "MApasswordRepeat", "MApasswordOld"] for key in params_key: if key not in data: return PARAMS_MISS new_pwd = data.get("MApasswordNew") repeat_pwd = data.get("MApasswordRepeat") old_pwd = data.get("MApasswordOld") if new_pwd and repeat_pwd and new_pwd != repeat_pwd: return get_response("ERROR_MESSAGE_WRONG_PARAMS", "MANAGERSYSTEMERROR", "ERROR_CODE_WRONG_PARAMS") try: password = self.smanager.get_manager_by_maid(maid).MApassword log.info("password", password) if password != old_pwd: return get_response("ERROR_MESSAGE_WRONG_PASSWORD", "MANAGERSYSTEMERROR", "ERROR_WRONG_PASSWORD") except Exception as e: log.error("DBERROR", e.message) return SYSTEM_ERROR try: result = self.smanager.update_manager(maid, {"MApassword": new_pwd}) log.info("update result", result) if result == 1: return get_response("SUCCESS_MESSAGE_UPDATE_PASSWORD", "OK") except Exception as e: log.error("UPDATEERROR", e.message) return SYSTEM_ERROR
def update_active_status(self): args = request.args.to_dict() log.info("args", args) if "token" not in args: return PARAMS_MISS data = json.loads(request.data) log.info("data", data) try: maid = token_to_usid(args.get("token")) except: return TOKEN_ERROR manager = self.smanager.get_manager_by_maid(maid) if not manager: return TOKEN_ERROR coid = data.get("COid") log.info("coid", coid) log.info("maid", maid) costatus = conversion_COstatus_resverse.get(get_str(data, "COstatus")) try: cmlist = self.sactive.get_cm_by_filter( {CouponsManager.MAid == maid, CouponsManager.COid == coid}, set()) log.info("cmlist", cmlist) if not cmlist: return SYSTEM_ERROR update_result = self.sactive.update_actives( coid, {"COstatus": costatus}) log.info("update result", update_result) if not update_result: return get_response("ERROR_MESSAGE_DB_ERROR", "MANAGERSYSTEMERROR", "ERROR_CODE_DB_ERROR") return get_response("SUCCESS_MESSAGE_UPDATE_ORDER", "OK") except Exception as e: log.error("update actiave status", e.message) return SYSTEM_ERROR
def get_order_abo(self): try: args = request.args.to_dict() log.info("args", args) if "token" not in args or "OMid" not in args: return PARAMS_MISS maid = token_to_usid(args.get("token")) if not maid: return TOKEN_ERROR order_main = todict( self.sorder.get_order_main_by_om_id(get_str(args, "OMid"))) order_main.pop("USid") self._get_order_abo_by_order_main(order_main) log.info("order main", order_main) data = get_response("SUCCESS_MESSAGE_GET_INFO", "OK") data["data"] = order_main return data except Exception as e: log.error("get order abo", e.message) return SYSTEM_ERROR
def login(self): data = json.loads(request.data) log.info("data", data) param_keys = ["MAname", "MApassword"] for key in param_keys: if key not in data: return PARAMS_MISS name = get_str(data, "MAname") password = data.get("MApassword") if not name or not password: return get_response("ERROR_MESSAGE_WRONG_PARAMS", "MANAGERSYSTEMERROR", "ERROR_CODE_WRONG_PARAMS") try: manager = self.smanager.get_manager_by_maname_mapassword( name, password) if not manager: return get_response("ERROR_MESSAGE_WRONG_PASSWORD", "MANAGERSYSTEMERROR", "ERROR_WRONG_PASSWORD") maid = manager.MAid self.smanager.update_manager( maid, {"MAloginTime": TimeManager.get_db_time_str()}) response = get_response("SUCCESS_MESSAGE_LOGIN", "OK") response["data"] = { "side": self.get_interface(maid), "token": usid_to_token(maid), "MAidentity": conversion_MAidentity.get(manager.MAidentity) } return response except Exception as e: log.error("LOGINERROR", e.message) return SYSTEM_ERROR
def update_approval(self): args = request.args.to_dict() log.info("args", args ) if "token" not in args: return PARAMS_MISS data = json.loads(request.data) log.info("data", data) params = ["APid", "APaction", 'APremark'] for key in params: if key not in data: return PARAMS_MISS try: maid = token_to_usid(args.get("token")) except: return TOKEN_ERROR try: approval = todict(self.sapproval.get_approval_by_apid(data.get("APid"))) log.info("approval", approval) petype = approval.get("PEtype") apaction = get_str(data, "APaction") pemaxlevel = self.sapproval.get_max_level(petype) log.info("max level", pemaxlevel) permission = self.sapproval.gert_pemission_by_maid_petype(maid, petype) log.info("permission", permission) manager = todict(self.smanager.get_manager_by_maid(maid)) apremark = get_str(approval, "APremark", "") + "\n" + get_str(manager, "MAname") + ":\n" + get_str(data, "APremark", "") log.info("apremark", apremark) update_approval = { "APid": str(uuid.uuid1()), "APname": approval.get("APname"), "APremark": apremark, "APstart": approval.get("APstart"), "APtime": approval.get("APtime"), "APcontent": approval.get("APcontent"), "PEtype": approval.get("PEtype") } recevie_list = [] if apaction == "同意": if pemaxlevel == permission.PEsubLevel: update_approval["APstatus"] = 445 self.dealapproval(petype, data.get("APcontent")) self.sapproval.update_approval_by_name(approval.get("APname"), {"APstatus": 445, "APremark": apremark}) else: update_approval["APstatus"] = 443 self.sapproval.update_approval_by_name(approval.get("APname"), {"APstatus": 442, "APremark": apremark}) recevie_list = self.sapproval.get_permission_by_petype_pesublevel(petype, permission.PEsubLevel + 1) else: update_approval["APstatus"] = 444 update_approval["APreceive"] = approval.get("APstart") self.sapproval.update_approval_by_name(approval.get("APname"), {"APstatus": 444, "APremark": apremark}) if recevie_list: for recevie in recevie_list: update_approval["APreceive"] = recevie.MAid self.sapproval.add_model("Approval", **update_approval) else: self.sapproval.add_model("Approval", **update_approval) return get_response("SUCCESS_MESSAGE_UPDATE_DATA", "OK") except Exception as e: log.error("update approval", e.message) return SYSTEM_ERROR
def get_order_list(self): try: args = request.args.to_dict() log.info("args", args) if "token" not in args or "page_size" not in args or "page_num" not in args: return PARAMS_MISS page_size = int(args.get("page_size")) page_num = int(args.get("page_num")) maid = token_to_usid(args.get("token")) from ManagerSystem.models.model import Products product_filter = {Products.MAid == maid} if args.get("PRname"): product_filter.add( Products.PRname.like("%{0}%".format(get_str( args, "PRname")))) product_list = tolist( self.sproduct.get_product_by_filter(product_filter)) log.info("product list ", product_list) pb_list = [] for product in product_list: product["PBunit"] = cvs.conversion_PBunit.get( product.get("PBunit", "其他币种")) product["PRbrand"] = cvs.conversion_PRbrand.get( product.get("PRbrand"), "其他") product["PRtype"] = cvs.conversion_PRtype.get( product.get("PRtype")) for pb in tolist( self.sproduct.get_pball_by_prid(product.get("PRid"))): pb.update(product) pb_list.append(pb) log.info("pb_list", pb_list) om_list = [] om_id_dict = {} from ManagerSystem.models.model import OrderMain omfilter = set() if args.get("OMstatus"): omstatus = cvs.conversion_OMstatus_reverse.get( get_str(args, "OMstatus")) omfilter.add(OrderMain.OMstatus == omstatus) if args.get("OMlogisticsName"): omfilter.add(OrderMain.OMlogisticsName == get_str( args, "OMlogisticsName")) if args.get("OMstartTime"): omfilter.add(OrderMain.OMtime >= TimeManager.get_db_time_str( args.get("OMstartTime"))) if args.get("OMendTime"): omfilter.add(OrderMain.OMtime <= TimeManager.get_db_time_str( args.get("OMendTime"))) for pb in pb_list: op_pb_list = tolist( self.sorder.get_order_part_list_by_pbid(pb.get("PBid"))) for op_pb in op_pb_list: op_pb.update(pb) if op_pb.get("OMid") in om_id_dict: om_id_dict[op_pb.get("OMid")].append(op_pb) else: om_id_dict[op_pb.get("OMid")] = [op_pb] log.info("om_id_dict", om_id_dict) om_count = {k: 0 for k in cvs.conversion_OMstatus} for om_id in om_id_dict: if args.get("OMid") and args.get("OMid") not in om_id: continue omfilter_tmp = omfilter.copy() omfilter_tmp.add(OrderMain.OMid == om_id) om_dict = tolist(self.sorder.get_om_by_filter(omfilter_tmp)) if not om_dict: continue om_dict = om_dict[0] om_dict.update({"order_item": om_id_dict.get(om_id)}) location = todict( self.sorder.get_location_by_usid(om_dict.pop("USid"))) log.info("location", location) om_count[om_dict.get("OMstatus")] += 1 om_dict.update(location) om_dict["OMcointype"] = cvs.conversion_PBunit.get( om_dict.get("OMcointype"), "其他币种") om_dict["OMstatus"] = cvs.conversion_OMstatus.get( om_dict.get("OMstatus"), 0) om_dict["OMtime"] = TimeManager.get_web_time_str( om_dict.get("OMtime")) om_list.append(om_dict) log.info("omlist", om_list) count = len(om_list) if page_size * page_num > count: page_num = count / page_size + 1 page_num = page_num if page_num > 0 else 1 om_list = om_list[(page_num - 1) * page_size:page_num * page_size] data = get_response("SUCCESS_MESSAGE_GET_INFO", "OK") data["data"] = { "count": count, "page_num": page_num, "page_size": page_size, "OrderMains": om_list, "OMcount": om_count } return data except Exception as e: log.error("get order list", e.message) import traceback print(traceback.format_exc()) return SYSTEM_ERROR
def get_situation(self): args = request.args.to_dict() log.info("args", args) if "token" not in args: return PARAMS_MISS maid = token_to_usid(args.get("token")) try: manager = self.smanager.get_manager_by_maid(maid) if not manager: return SYSTEM_ERROR dealing_sum = 0 approvaling_sum = 0 deliver_sum = 0 ordered_sum = 0 paid_num = 0 ordered_price_sum = 0 payed_price_sum = 0 active_sum = 0 couponse_sum = 0 today_omprice = 0 today_vistor = 0 today_order = 0 today_payed = 0 yesterday_omprice = 0 yesterday_vistor = 0 yesterday_order = 0 yesterday_payed = 0 time_filter_week = TimeManager.get_forward_time(days=-7) time_filter_yesterday = TimeManager.get_forward_time( days=-1)[:8] + "000000" time_filter_today = TimeManager.get_db_time_str()[:8] + "000000" from ManagerSystem.service.SApproval import SApproval sapproval = SApproval() approval = [ apr.APname for apr in sapproval.get_approval_by_maid(maid) ] approval = {}.fromkeys(approval).keys() approvaling_sum = len(approval) from ManagerSystem.service.SOrder import SOrder from ManagerSystem.service.SProducts import SProducts from ManagerSystem.config.conversion import conversion_OMstatus, conversion_OMstatus_reverse sorder = SOrder() sproduct = SProducts() prid_list = [ product.PRid for product in sproduct.get_product_by_maid(maid) ] pbid_list = [] for prid in prid_list: pbid_list.extend( [pb.PBid for pb in sproduct.get_pbid_by_prid(prid)]) omid_list = [] for pbid in pbid_list: omid_list.extend([ op.OMid for op in sorder.get_order_part_list_by_pbid(pbid) ]) omid_list = {}.fromkeys(omid_list).keys() om_count = {k: 0 for k in conversion_OMstatus} for omid in omid_list: om = sorder.get_order_main_by_om_id(omid) om_count[om.OMstatus] += 1 if om.OMtime > time_filter_week: if om.OMstatus >= 21: paid_num += 1 payed_price_sum += om.OMprice if om.OMstatus >= 7: ordered_sum += 1 ordered_price_sum += om.OMprice if om.OMtime[:8] == time_filter_today[:8]: if om.OMstatus >= 21: today_omprice += om.OMprice today_payed += 1 if om.OMstatus >= 7: today_order += 1 elif om.OMtime[:8] == time_filter_yesterday[:8]: if om.OMstatus >= 21: yesterday_payed += 1 yesterday_omprice += om.OMprice if om.OMstatus >= 7: yesterday_order += 1 # om_count_result = {} # for status in om_count: # om_count_result[conversion_OMstatus.get(status)] = om_count.get(status, 0) deliver_sum = om_count.get(21) dealing_sum = deliver_sum + approvaling_sum from ManagerSystem.service.SActive import SActive from ManagerSystem.models.model import CouponsManager from ManagerSystem.models.model import CouponsActives sactive = SActive() cmlist = [ cm.COid for cm in sactive.get_cm_by_filter( {CouponsManager.MAid == maid}, set()) ] cmlist = {}.fromkeys(cmlist).keys() for coid in cmlist: ca = sactive.get_actives_by_filter( { CouponsActives.COid == coid, CouponsActives.COstatus == 551 }, set()) if ca: ca = ca[0] if ca.COgenre == 561: couponse_sum += 1 elif ca.COgenre == 562: active_sum += 1 visitors_sum = len( self.smanager.get_visitors_by_maid(maid, time_filter_week)) today_vistor = len( self.smanager.get_visitors_by_maid(maid, time_filter_today)) yesterday_vistor = len( self.smanager.get_visitors_by_maid(maid, time_filter_yesterday)) from decimal import Decimal vto = (Decimal(ordered_sum) / (Decimal(visitors_sum))).quantize( Decimal('0.00')) if visitors_sum != 0 else 0 vtp = (Decimal(paid_num) / (Decimal(visitors_sum))).quantize( Decimal('0.00')) if visitors_sum != 0 else 0 otp = (Decimal(paid_num) / (Decimal(ordered_sum))).quantize( Decimal('0.00')) if ordered_sum != 0 else 0 pct = (Decimal(payed_price_sum) / (Decimal(paid_num))).quantize( Decimal("0.00")) if paid_num != 0 else 0 response = get_response("SUCCESS_MESSAGE_GET_INFO", "OK") response["data"] = { "deliver_sum": deliver_sum, "approvaling_sum": approvaling_sum, "dealing_sum": dealing_sum, "om_count": om_count, "active_sum": active_sum, "couponse_sum": couponse_sum, "vtp": float(vtp), "vto": float(vto), "otp": float(otp), "today_vistor": today_vistor, "today_omprice": today_omprice, "today_order": today_order, "today_payed": today_payed, "yesterday_omprice": yesterday_omprice, "yesterday_vistor": yesterday_vistor, "yesterday_order": yesterday_order, "yesterday_payed": yesterday_payed, "paid_num": paid_num, "ordered_sum": ordered_sum, "visitors_sum": visitors_sum, "payed_price_sum": payed_price_sum, "ordered_price_sum": ordered_price_sum, "pct": float(pct), } return response except Exception as e: log.error("get situation", e.message) return SYSTEM_ERROR
def add_active(self): args = request.args.to_dict() log.info("args", args) if "token" not in args: return PARAMS_MISS data = json.loads(request.data) log.info("data", data) try: maid = token_to_usid(args.get("token")) except: return TOKEN_ERROR manager = self.smanager.get_manager_by_maid(maid) if not manager: return TOKEN_ERROR params_list = ["COname", "COabo", "COtype", "COstart", "COend"] for key in params_list: if key not in data: return PARAMS_MISS acstart = TimeManager.get_db_time_str(get_str(data, "COstart")) acend = TimeManager.get_db_time_str(get_str(data, "COend")) if acstart >= acend: return get_response("ERROR_MESSAGE_TIME_ERROR", "MANAGERSYSTEMERROR", "ERROR_CODE_TIME_ERROR") coid = str(uuid.uuid1()) CA = { "COid": coid, "COabo": get_str(data, "COabo"), "COimage": json.dumps(data.get("COimage")), "COname": get_str(data, "COname"), "COstatus": conversion_COstatus_resverse.get(get_str(data, "COstatus"), 550), "COstart": acstart, "COend": acend, "COfilter": data.get("COfilter", 0), "COother": get_str(data, "COother"), "COdiscount": data.get("COdiscount", 1), "COamount": data.get("COamount", 0), "COtype": conversion_COtype_resverse.get(get_str(data, "COtype")), "COnumber": data.get("COnumber", 0), "COgenre": conversion_COgenre_resverse.get(get_str(data, "COgenre")), "COunit": conversion_PBunit_reverse.get(get_str(data, "COunit"), 402), "COtime": TimeManager.get_db_time_str(), "COuserfilter": data.get("COuserfilter", 0), "COotherType": data.get("COotherType", "0") } log.info("CA", CA) try: self.sactive.add_model("CouponsActives", **CA) except Exception as e: log.error("add CA", e.message) return SYSTEM_ERROR try: prid_list = data.get("PRids") if prid_list: for prid in prid_list: self.sactive.add_model( "CouponsManager", **{ "CMid": str(uuid.uuid1()), "COid": coid, "MAid": maid, "PRid": prid, "CMprobability": data.get("CMprobability", 1) }) else: self.sactive.add_model( "CouponsManager", **{ "CMid": str(uuid.uuid1()), "COid": coid, "MAid": maid, "PRid": "", "CMprobability": data.get("CMprobability", 1) }) response = get_response("SUCCESS_MESSAGE_ADD_DATA", "OK") response["data"] = coid return response except Exception as e: log.error("add CM", e.message) return SYSTEM_ERROR
def get_situation(self): args = request.args.to_dict() log.info("args", args) if "token" not in args: return PARAMS_MISS try: maid = token_to_usid(args.get("token")) except: return TOKEN_ERROR manager = self.smanager.get_manager_by_maid(maid) if not manager: return TOKEN_ERROR # start_time = int(args.get("days", 1)) end_time = TimeManager.get_db_time_str(args.get("end_time")) start_time = TimeManager.get_db_time_str(args.get("start_time")) try: cm_list = self.sactive.get_cm_by_filter( {CouponsManager.MAid == maid}, set()) log.info("cm list", cm_list) coid_list_all = {}.fromkeys([cm.COid for cm in cm_list]).keys() # timefilter = TimeManager.get_forward_time_web(days=-days) cogenre = conversion_COgenre_resverse.get(get_str(args, "COgenre")) log.info("COgenre", cogenre) # 筛选优惠券/活动 coid_list_filter = [] for coid in coid_list_all: ca = self.sactive.get_actives_by_filter( {CouponsActives.COid == coid}, set()) log.info("ca", ca) if ca: ca = ca[0] if ca.COgenre != cogenre: continue coid_list_filter.append(ca.COid) om_list = self.sorder.get_om_by_filter(set()) used_sum = 0 for om in om_list: if om.COid in coid_list_filter and end_time > om.OMtime > start_time: used_sum += 1 cp_list = self.sactive.get_cp_by_filter(set(), set()) get_num = 0 for cp in cp_list: if cp.COid in coid_list_filter and end_time > cp.CPtime > start_time: get_num += 1 data_dict = {} days = TimeManager.get_delta_days(start_time, end_time) log.info("days", days + 1) for i in range(0, days + 1): sub_time_filter_start = TimeManager.get_forward_time_web( days=-(i + 1)) sub_time_filter_end = TimeManager.get_forward_time_web(days=-i) sub_om_num = 0 for om in om_list: if om.COid in coid_list_filter and sub_time_filter_end < om.OMtime < sub_time_filter_start: sub_om_num += 1 sub_cp_num = 0 for cp in cp_list: sub_cp_num += 1 if cp.COid in coid_list_filter and sub_time_filter_end < cp.CPtime < sub_time_filter_start: sub_cp_num += 1 data_dict[sub_time_filter_start] = [sub_om_num, sub_cp_num] response = get_response("SUCCESS_MESSAGE_GET_INFO", "OK") params = [ { "name": "领取张数", "value": get_num }, { "name": "使用张数", "value": used_sum }, ] response["data"] = {"params": params, "data": data_dict} return response except Exception as e: log.error("get situation", e.message) return SYSTEM_ERROR