def get_config(): ApiResponse = api_response.ApiResponse() Key = request.form.get("Key", type=str, default=None) if Key is None or Key == "": raise custom_error.CustomFlaskErr(status_code=500, message="key不能为空") data = mysql.get_object(basic_sql.get_config, (Key)) ApiResponse.message = "成功" ApiResponse.data = data return api_response.response_return(ApiResponse)
def register(): ApiResponse = api_response.ApiResponse() Account = request.form.get("Account", type=str, default=None) Password = request.form.get("Password", type=str, default=None) VCode = request.form.get("VCode", type=str, default=None) if Account == None: raise custom_error.CustomFlaskErr(status_code=500, message="账号不能为空") if Password == None: raise custom_error.CustomFlaskErr(status_code=500, message="密码不能为空") if VCode == None: raise custom_error.CustomFlaskErr(status_code=500, message="验证码不能为空") data_exists = mysql.get_list(user_sql.select_exists_user, (Account)) if len(data_exists): raise custom_error.CustomFlaskErr(status_code=500, message="账号已经存在") vocde_exists = mysql.get_object(verification_code_sql.select_verification_lastcode, (Account, 1)) if vocde_exists == None: raise custom_error.CustomFlaskErr(status_code=500, message="验证码已失效") if vocde_exists["VCode"] != VCode: raise custom_error.CustomFlaskErr(status_code=500, message="验证码不正确") # 设置验证码已读 mysql.operate_object(verification_code_sql.update_verificatioin_vcode, (vocde_exists["Id"])) guid = str(uuid.uuid1()) sql_list = [user_sql.insert_user, user_sql.insert_userinfo] args_list = [(guid, Account, Password, Account), (guid)] data_register = mysql.operate__many(sql_list, args_list) if data_register > 0: # region 设置登陆信息,直接跳转到首页 guid = str(uuid.uuid1()) ip = request.remote_addr count = mysql.operate_object(user_sql.update_user_token, (guid, ip, Account, Password)) user = mysql.get_object(user_sql.select_user_login_info, (guid)) session["user"] = user data = {"token": guid, "datetime": time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()), "user": user} ApiResponse.message = "注册成功" ApiResponse.status = 200 ApiResponse.data = data return api_response.response_return(ApiResponse) # date = time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()) raise custom_error.CustomFlaskErr(status_code=500, message="注册失败")
def select_user_list(name,page=1,size=10): if page<=0: page=1 if size<=0: size=10 sear="%"+ name +"%" listCount = mysql.get_object(user_sql.select_user_list_count,(name,name,sear,sear)) data= mysql.get_list(user_sql.select_user_list,(name,name,sear,sear,(page-1)*size,size)) return data,listCount
def get_base_config_by_id(): ApiResponse = api_response.ApiResponse() Id = request.form.get("Id", type=int, default=0) if Id <= 0: raise custom_error.CustomFlaskErr(status_code=500, message="Id不能为空") ApiResponse.data = mysql.get_object(config_sql.get_base_config_by_id, (Id)) ApiResponse.message = "成功" ApiResponse.status = 200 return api_response.response_return(ApiResponse)
def current_user(): user = session.get("user", None) #if user != None and any(user): # return user token = get_token() if token == None: return None #本地缓存中不存在去数据库拿 user = mysql.get_object(user_sql.select_user_login_info, (token)) session["user"] = user return user
def update_upgrade_user(): UserId = request_back_helper.current_user_mush_login()["UserId"] Id = request.form.get("Id", type=str, default=None) Status = request.form.get("Status", type=int, default=-1) if Id is None or Id == "": raise custom_error.CustomFlaskErr(status_code=500, message="参数id不能为空") if Status == -1: raise custom_error.CustomFlaskErr(status_code=500, message="参数状态不能为空") #查询规划师升级数据 upgradeInfo = mysql.get_object(upgrade_user_sql.get_upgrade_info_by_id, (Id)) if upgradeInfo is None: raise custom_error.CustomFlaskErr(status_code=500, message="该审核数据不存在") if upgradeInfo["Status"] != 0: raise custom_error.CustomFlaskErr(status_code=500, message="该审核数据已处理,请勿重复操作") # 审核不通过 if Status == 2: success = mysql.operate_object(upgrade_user_sql.update_upgrade_status, (Status, UserId, Id)) if success <= 0: raise custom_error.CustomFlaskErr(status_code=500, message="审核失败") # 审核通过 if Status == 1: idCard = " " #判断IDCard是否不存在 if 'IDCard' in upgradeInfo and upgradeInfo["IDCard"] is not None: idCard = upgradeInfo["IDCard"] sql_list = [ upgrade_user_sql.update_upgrade_status, upgrade_user_sql.update_user_type, upgrade_user_sql.update_user_info, upgrade_user_sql.insert_planner_statistics ] args_list = [ (Status, UserId, Id), (UserId, upgradeInfo["UserId"]), (upgradeInfo["Name"], upgradeInfo["Sex"], upgradeInfo["Address"], upgradeInfo["Experience"], upgradeInfo["Email"], idCard, upgradeInfo["IDCardPic"], upgradeInfo["IDCardBackPic"], upgradeInfo["ServiceAreaId"], upgradeInfo["ServiceId"], UserId, upgradeInfo["UserId"]), (upgradeInfo["UserId"], UserId, UserId, upgradeInfo["UserId"], upgradeInfo["UserId"]) ] success = mysql.operate__many(sql_list, args_list) if success <= 0: raise custom_error.CustomFlaskErr(status_code=500, message="审核失败") ApiResponse = api_response.ApiResponse() ApiResponse.message = "成功" ApiResponse.status = 200 return api_response.response_return(ApiResponse)
def get_upgrade_apply_detail(): request_back_helper.current_user_mush_login() ApiResponse = api_response.ApiResponse() Id = request.form.get("Id", type=str, default=None) if Id is None or Id == "": raise custom_error.CustomFlaskErr(status_code=500, message="参数id不能为空") ApiResponse.data = mysql.get_object( upgrade_user_sql.get_upgrade_apply_detail, (Id)) ApiResponse.message = "成功" ApiResponse.status = 200 return api_response.response_return(ApiResponse)
def get_order_detail(): ApiResponse = api_response.ApiResponse() OrderId = request.form.get("OrderId", type=str, default=None) if OrderId == None or OrderId == "": raise custom_error.CustomFlaskErr(status_code=500, message="订单id不能为空") ApiResponse.data = mysql.get_object(order_sql.select_planner_order_detail, (OrderId)) flowList = [] if ApiResponse.data != None: order_flow_list = mysql.get_list(order_sql.get_order_status, (OrderId)) if len(order_flow_list) > 0: for item in order_flow_list: if item["StartStatus"] == 6: flowList.append({ "StatusStr": "服务完成", "IsDo": "1", "ChangeTime": item["ChangeTime"] }) flowList.append({ "StatusStr": "付款确认", "IsDo": "1", "ChangeTime": item["ChangeTime"] }) if item["StartStatus"] == 5: flowList.append({ "StatusStr": "平台审查", "IsDo": "1", "ChangeTime": item["ChangeTime"] }) if item["StartStatus"] == 4: flowList.append({ "StatusStr": "线下签约", "IsDo": "1", "ChangeTime": item["ChangeTime"] }) if item["StartStatus"] == 3: flowList.append({ "StatusStr": "拟定合同", "IsDo": "1", "ChangeTime": item["ChangeTime"] }) if item["StartStatus"] == 2: flowList.append({ "StatusStr": "客服回访", "IsDo": "1", "ChangeTime": item["ChangeTime"] }) ApiResponse.data["OrderFlowing"] = flowList ApiResponse.message = "成功" ApiResponse.status = 200 return api_response.response_return(ApiResponse)
def insert_userinfo(userId,account,phone,password,userType,name,realName,sex,age,education,address,email,headImage,IDCard,IDCardJust,IDCardBack,current_user_id): if userId == None or userId=="" or current_user_id == None or current_user_id=="": raise custom_error.CustomFlaskErr(status_code=500, message="参数不正确,请刷新后重试") if account == None or account=="" or name == None or name==""or realName == None or realName=="": raise custom_error.CustomFlaskErr(status_code=500, message="帐号姓名不能为空") a_userid = mysql.get_object(user_sql.select_userid_by_account, (account)) if a_userid!=None and a_userid!="" : raise custom_error.CustomFlaskErr(status_code=500, message="账号已经存在") data_register = mysql.operate_object(user_sql.insert_user,(userId,account,phone,password,userType,current_user_id,current_user_id ,userId,name,realName,sex,age,education,address,email,headImage,IDCard,IDCardJust,IDCardBack,current_user_id,current_user_id)) if userType==2 or userType ==3: mysql.operate_object(upgrade_user_sql.insert_planner_statistics,(userId,current_user_id,current_user_id,userId,userId)) return data_register > 0
def insert_undertake(): ApiResponse = api_response.ApiResponse() DemandId = request.form.get("DemandId", type=str, default=None) if DemandId == None or DemandId == "": raise custom_error.CustomFlaskErr(status_code=500, message="需求id不能为空") ContractId = request.form.get("ContractId", type=int, default=0) if ContractId == None or ContractId == 0: raise custom_error.CustomFlaskErr(status_code=500, message="合同id不能为空") userId = request_helper.current_user_mush_login()["Id"] userInfo = mysql.get_object(user_info_sql.select_userinfo_by_id, (userId)) if userInfo == None or userInfo["UserType"] == 1: raise custom_error.CustomFlaskErr(status_code=500, message="你还不是规划师") service_exists = mysql.get_object(demand_undertake.select_exists_demand, (DemandId)) if service_exists == None or service_exists["IsUndertake"] == 1: raise custom_error.CustomFlaskErr(status_code=500, message="该需求不存在或者已被承接") data_exists = mysql.get_object( demand_undertake.select_exists_demand_service, (DemandId, userId)) if data_exists["total"] > 0: raise custom_error.CustomFlaskErr(status_code=500, message="你已经存在承接该需求的记录") insertResult = mysql.operate_object( demand_undertake.insert_demand_undertake, (DemandId, userId, userId, enum.IsUser.no, ContractId)) if insertResult > 0: ApiResponse.message = "申请成功" ApiResponse.status = 200 return api_response.response_return(ApiResponse) raise custom_error.CustomFlaskErr(status_code=500, message="申请失败")
def get_user_info(): ApiResponse = api_response.ApiResponse() userid = request.form.get("userid", type=str, default=None) if userid == None or userid == "": userid = request_helper.current_user_mush_login()["Id"] if userid == None or userid == "": raise custom_error.CustomFlaskErr(status_code=500, message="参数userid不能为空") userinfo = mysql.get_object(user_info_sql.select_userinfo_by_id, (userid)) if userinfo != None and any(userinfo): ApiResponse.data = userinfo return api_response.response_return(ApiResponse) raise custom_error.CustomFlaskErr(status_code=500, message="用户不存在")
def join_team(): ApiResponse = api_response.ApiResponse() userId = request_helper.current_user_mush_login()["Id"] user_info = mysql.get_object(user_sql.select_user_by_id, (userId)) if user_info is None or user_info["UserType"] == 1: raise custom_error.CustomFlaskErr(status_code=500, message="你还不是规划师") TeamId = request.form.get("TeamId", type=str, default=None) if TeamId is None or TeamId == '': raise custom_error.CustomFlaskErr(status_code=500, message="团队id不能为空") exists_team = mysql.get_object(team_sql.exists_team_peoper, (userId)) if exists_team is not None and exists_team["Status"] == 1: raise custom_error.CustomFlaskErr(status_code=500, message="您已经申请过加入该团队,请耐心等待审核") if exists_team is not None and exists_team["Status"] == 2: raise custom_error.CustomFlaskErr(status_code=500, message="您已经是团队成员") team_detail = mysql.get_object(team_sql.select_team_adminid, (TeamId)) if team_detail is None: raise custom_error.CustomFlaskErr(status_code=500, message="您所申请的团队不存在") guid = str(uuid.uuid1()) sql_list = [team_sql.insert_team_notice, team_sql.insert_team_notice] args_list = [(userId, TeamId, "您正在申请加入 " + team_detail["Name"] + " 团队", 1, 2, userId, guid), (team_detail["AdminUserId"], TeamId, "用户 " + request_helper.current_user_mush_login()["Name"] + " 正在申请加入团队", 1, 1, userId, guid)] data_register = mysql.operate__many(sql_list, args_list) ApiResponse.message = "成功" ApiResponse.status = 200 return api_response.response_return(ApiResponse)
def select_demand_list(): ApiResponse = api_response.ApiResponse() size = request.form.get("size", type=int, default=10) name = request.form.get("name", type=str, default="") page = request.form.get("page", type=int, default=1) type = request.form.get("type", type=int, default=1) if page <= 0: page = 1 if size <= 0: size = 10 data = mysql.get_list(demand_service_sql.select_demand_list, (type,(page - 1) * size, size)) listCount = mysql.get_object(demand_service_sql.select_demand_count, (type)) if listCount is not None: ApiResponse.data = data ApiResponse.listCount = listCount["count"] ApiResponse.message = "成功" ApiResponse.status = 200 return api_response.response_return(ApiResponse)
def get_upgrade_apply_list(): ApiResponse = api_response.ApiResponse() size = request.form.get("size", type=int, default=10) name = request.form.get("name", type=str, default="") page = request.form.get("page", type=int, default=1) if page <= 0: page = 1 if size <= 0: size = 10 sear = "%" + name + "%" data = mysql.get_list(upgrade_user_sql.get_upgrade_apply_list, (name, name, sear, (page - 1) * size, size)) listCount = mysql.get_object(upgrade_user_sql.get_upgrade_apply_count, (name, name, sear)) ApiResponse.message = "成功" ApiResponse.status = 200 if listCount is not None: ApiResponse.data = data ApiResponse.listCount = listCount["count"] return api_response.response_return(ApiResponse)
def update_team_name(): ApiResponse = api_response.ApiResponse() userId = request_helper.current_user_mush_login()["Id"] TeamId = request.form.get("TeamId", type=str, default=None) if TeamId is None or TeamId == '': raise custom_error.CustomFlaskErr(status_code=500, message="团队id不能为空") TeamName = request.form.get("TeamName", type=str, default=None) if TeamName is None or TeamName == '': raise custom_error.CustomFlaskErr(status_code=500, message="团队名称不能为空") team_info = mysql.get_object(team_sql.get_team_info, (TeamId)) if team_info is None: raise custom_error.CustomFlaskErr(status_code=500, message="没有该团队") if team_info["AdminUserId"] != userId: raise custom_error.CustomFlaskErr(status_code=500, message="您不是队长") update_count = mysql.operate_object(team_sql.update_team_name, (TeamName, TeamId, userId)) if update_count <= 0: raise custom_error.CustomFlaskErr(status_code=500, message="修改失败") ApiResponse.message = "成功" ApiResponse.status = 200 return api_response.response_return(ApiResponse)
def select_carouselimage_info(imageId): return mysql.get_object(baseinfo_sql.select_carouselimage_info, (imageId))
def select_service_type_info(typeId): return mysql.get_object(service_type_sql.select_service_type_info, (typeId))
def set_session_login(): token = get_token() session["user"] = mysql.get_object(user_sql.select_user_login_info, (token))
def select_service_area_info(areaId): return mysql.get_object(service_area_sql.select_service_area_info, (areaId))
def select_user_team(userid): if userid == None or userid == "": raise custom_error.CustomFlaskErr(status_code=500, message="输入不正确,请刷新后重试") return mysql.get_object(team_sql.select_user_team, (userid))
def select_platforminfo(): return mysql.get_object(baseinfo_sql.select_platforminfo, ())
def get_whether_follw(userid, plannerId): return mysql.get_object(planner_sql.get_whether_follw, (plannerId, userid))
def select_planner_info(userid): return mysql.get_object(planner_sql.select_planner_info, (userid))
def select_user_role_list(user_id, current_user_id): if user_id == None or user_id == "" or current_user_id == None or current_user_id == "": raise custom_error.CustomFlaskErr(status_code=500, message="参数不正确,请刷新后重试") return mysql.get_object(sys_role_sql.select_user_role_list, (user_id))
def select_user_info(userId): return mysql.get_object(user_sql.select_user_info, (userId))
def select_dynamic_info(dynamicId): if dynamicId == None or dynamicId=="": raise custom_error.CustomFlaskErr(status_code=500, message="输入不正确,请刷新后重试") mysql.operate_object(dynamic_sql.update_dynamic_readcount, (dynamicId)) return mysql.get_object(dynamic_sql.select_dynamic_info,(dynamicId))
def select_resour_info(id): return mysql.get_object(planner_sql.select_resour_info, (id))
def select_society_info(id): return mysql.get_object(planner_sql.select_society_info, (id))
def select_education_info(id): return mysql.get_object(planner_sql.select_education_info, (id))
def select_sys_role_info(role_id): if role_id == None or role_id == "": raise custom_error.CustomFlaskErr(status_code=500, message="参数role_id不能为空") return mysql.get_object(sys_role_sql.select_sys_role_info, (role_id))