def update_demand_status(): userId = request_back_helper.current_user_mush_login()["UserId"] ApiResponse = api_response.ApiResponse() id = request.form.get("id", type=str, default=None) IsUndertake = request.form.get("IsUndertake", type=int, default=-1) IsTop = request.form.get("IsTop", type=int, default=-1) if id is None: raise custom_error.CustomFlaskErr(status_code=500, message="参数不正确") if IsUndertake == -1: raise custom_error.CustomFlaskErr(status_code=500, message="参数不正确") if IsTop==-1 : raise custom_error.CustomFlaskErr(status_code=500, message="参数不正确") if IsUndertake==2: sql_list = [demand_service_sql.update_demand_status, demand_service_sql.update_demand_undertake_status] args_list = [(IsTop, IsUndertake, userId,id), ( userId,id),] mysql.operate__many(sql_list,args_list) else : mysql.operate_object(demand_service_sql.update_demand_status,(IsTop, IsUndertake, userId,id)) ApiResponse = api_response.ApiResponse() ApiResponse.message = "成功" ApiResponse.status = 200 return api_response.response_return(ApiResponse)
def update_user_password(): ApiResponse = api_response.ApiResponse() Phone = request.form.get("Phone", type=str, default=None) NewPassword = request.form.get("NewPassword", type=str, default=None) VCode = request.form.get("VCode", type=str, default=None) if Phone == None or Phone == "": raise custom_error.CustomFlaskErr(status_code=500, message="手机号码不能为空") if NewPassword == None or NewPassword == "": raise custom_error.CustomFlaskErr(status_code=500, message="新密码不能为空") if VCode == None or VCode == "": raise custom_error.CustomFlaskErr(status_code=500, message="验证码不能为空") vocde_exists = mysql.get_object( verification_code_sql.select_verification_lastcode, (Phone, 2)) 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"])) data_exce = mysql.operate_object(user_sql.update_user_password, (NewPassword, Phone)) if data_exce > 0: ApiResponse.message = "修改成功" ApiResponse.status = 200 return api_response.response_return(ApiResponse) raise custom_error.CustomFlaskErr(status_code=500, message="修改失败")
def update_system_notice_status(): userId = request_helper.current_user_mush_login()["Id"] ApiResponse = api_response.ApiResponse() noticeId = request.form.get("Id", type=str, default=None) if noticeId is None or noticeId == '': raise custom_error.CustomFlaskErr(status_code=500, message="消息id不能为空") mysql.operate_object(system_notice_sql.update_system_notice_status, (userId, noticeId)) 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 delete_dynamic(dynamicId, current_user_id): if dynamicId == None or dynamicId == "" or current_user_id == None or current_user_id == "": raise custom_error.CustomFlaskErr(status_code=500, message="参数不正确,请刷新后重试") data_register = mysql.operate_object(dynamic_sql.delete_dynamic, (current_user_id, dynamicId)) return data_register > 0
def get_vcode(): Phone = request.form.get("Phone", type=str, default=None) if Phone == None or Phone == "": raise custom_error.CustomFlaskErr(status_code=500, message="手机号码不能为空") CodeType = request.form.get("CodeType", type=int, default=None) if CodeType == None or CodeType == "": raise custom_error.CustomFlaskErr(status_code=500, message="短信类型不能为空") vcode = str(random.randint(0, 9)) vcode += str(random.randint(0, 9)) vcode += str(random.randint(0, 9)) vcode += str(random.randint(0, 9)) ApiResponse = api_response.ApiResponse() data = mysql.operate_object( verification_code_sql.insert_verification_codel, (Phone, vcode, CodeType)) if data != None and data > 0: params = {"vcode": vcode} send_result = aliyun_sms.AliyunSMS().send_single( phone=Phone, sign="龟划海外", template='SMS_85970044', params=params) ApiResponse.message = "成功" ApiResponse.data = data return api_response.response_return(ApiResponse)
def delete_team_member(teamid, userid, current_user_id): if teamid == None or teamid == "" or userid == None or userid == "" or current_user_id == None or current_user_id == "": raise custom_error.CustomFlaskErr(status_code=500, message="参数不正确,请刷新后重试") data_register = mysql.operate_object( team_sql.delete_team_member, (current_user_id, userid, teamid, userid)) return data_register > 0
def home_login(): print("home_login") ApiResponse = api_response.ApiResponse() UserName = request.form.get("UserName", type=str, default=None) Password = request.form.get("Password", type=str, default=None) if UserName == None: raise custom_error.CustomFlaskErr(status_code=500, message="账号不能为空") if Password == None: raise custom_error.CustomFlaskErr(status_code=500, message="密码不能为空") guid = str(uuid.uuid1()) ip = request.remote_addr count = mysql.operate_object(home_sql.update_sysuser_token, (guid, ip, UserName, Password)) if count <= 0: raise custom_error.CustomFlaskErr(status_code=500, message="账号或密码不正确") #写token # date = time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()) user = mysql.get_object(home_sql.select_sysuser_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)
def insert_sys_role(name, remark, current_user_id): if name == None or name == "" or current_user_id == None or current_user_id == "": raise custom_error.CustomFlaskErr(status_code=500, message="参数不正确,请刷新后重试") data_register = mysql.operate_object(sys_role_sql.insert_sys_role, (name, remark)) return data_register > 0
def delete_sys_role(role_id, current_user_id): if role_id == None or role_id == "" or current_user_id == None or current_user_id == "": raise custom_error.CustomFlaskErr(status_code=500, message="参数不正确,请刷新后重试") data_register = mysql.operate_object(sys_role_sql.delete_sys_role, (role_id, role_id)) return data_register > 0
def update_browse_service(): ApiResponse = api_response.ApiResponse() Id = request.form.get("Id", type=str, default=None) if Id == None or Id == "": raise custom_error.CustomFlaskErr(status_code=500, message="请选择需要修改的需求") Name = request.form.get("Name", type=str, default=None) if Name == None or Name == "": raise custom_error.CustomFlaskErr(status_code=500, message="名称不能为空") TimeStart = request.form.get("TimeStart", type=str, default=None) TimeEnd = request.form.get("TimeEnd", type=str, default=None) if TimeStart == None or TimeStart == "" or TimeEnd == None or TimeEnd == "": raise custom_error.CustomFlaskErr(status_code=500, message="起止时间不能为空") PriceStart = request.form.get("PriceStart", type=float, default=0.0) PriceEnd = request.form.get("PriceEnd", type=float, default=0.0) Description = request.form.get("Description", type=str, default=None) if Description == None or Description == "": raise custom_error.CustomFlaskErr(status_code=500, message="需求描述不能为空") ServiceTypeId = request.form.get("ServiceId", type=int, default=0) ServiceAreaId = request.form.get("ServiceAreaId", type=int, default=0) if ServiceAreaId == 0: raise custom_error.CustomFlaskErr(status_code=500, message="服务区域不能为空") user = request_helper.current_user_mush_login() data = mysql.operate_object( demand_service_sql.update_browse_service, (Name, ServiceAreaId, ServiceTypeId, PriceStart, PriceEnd, TimeStart, TimeEnd, Description, user["Id"], Id, user["Id"])) ApiResponse.message = "成功" ApiResponse.status = 200 ApiResponse.data = data return api_response.response_return(ApiResponse)
def update_sys_file_info(name, fileUrl, isTop, sort, current_user_id, fileId): if name == None or name == "" or fileId == None or fileId == "" or current_user_id == None or current_user_id == "": raise custom_error.CustomFlaskErr(status_code=500, message="参数不正确,请刷新后重试") data_register = mysql.operate_object( sys_file_sql.update_sys_file_info, (name, fileUrl, isTop, sort, current_user_id, fileId)) return data_register > 0
def delete_service_area(areaId, current_user_id): if areaId == None or areaId == "" or current_user_id == None or current_user_id == "": raise custom_error.CustomFlaskErr(status_code=500, message="参数不正确,请刷新后重试") data_register = mysql.operate_object( service_area_sql.delete_service_area, (current_user_id, areaId, current_user_id, areaId)) return data_register > 0
def insert_service_area(name, description, isTop, sort, current_user_id): if name == None or name == "" or current_user_id == None or current_user_id == "": raise custom_error.CustomFlaskErr(status_code=500, message="参数不正确,请刷新后重试") data_register = mysql.operate_object( service_area_sql.insert_service_area, (name, description, isTop, sort, current_user_id, current_user_id)) return data_register > 0
def insert_team(teamId, userid, name, serviceAreaId, serviceDescription): if teamId == None or teamId == "" or userid == None or userid == "" or name == None or name == "": raise custom_error.CustomFlaskErr(status_code=500, message="输入不正确,请刷新后重试") return mysql.operate_object( team_sql.insert_team, (teamId, userid, name, serviceAreaId, serviceDescription, userid, userid, teamId, userid, userid, userid, teamId, userid, userid))
def insert_chat(): SendUserId = request_helper.current_user_mush_login()["Id"] ApiResponse = api_response.ApiResponse() ReceiveUserId = request.form.get("ReceiveUserId", type=str, default=None) Content = request.form.get("Content", type=str, default=None) if ReceiveUserId is None or ReceiveUserId == '': raise custom_error.CustomFlaskErr(status_code=500, message="接收者id不能为空") if Content is None or Content == '': raise custom_error.CustomFlaskErr(status_code=500, message="消息内容不能为空") user_info = mysql.get_object(chat_notice_sql.select_user_info, (SendUserId)) if user_info is None: raise custom_error.CustomFlaskErr(status_code=500, message="该用户不存在") chat_main = mysql.get_object( chat_notice_sql.select_chat_main, (SendUserId, ReceiveUserId, ReceiveUserId, SendUserId)) guid = str(uuid.uuid1()) if chat_main == None: mysql.operate_object( chat_notice_sql.insert_chat_main, (guid, SendUserId, ReceiveUserId, Content, SendUserId)) else: guid = chat_main["Id"] mysql.operate_object(chat_notice_sql.update_chat_main, (Content, SendUserId, guid)) system_content = user_info["Name"] + " 发来一条消息" mysql.operate_object(chat_notice_sql.insert_chat_content, (guid, SendUserId, Content, SendUserId)) existx_chat = mysql.get_object(chat_notice_sql.existx_chat_notice, (guid, ReceiveUserId)) if existx_chat["total"] == 0: mysql.operate_object( chat_notice_sql.insert_chat_notice, (ReceiveUserId, system_content, SendUserId, guid, SendUserId)) else: mysql.operate_object(chat_notice_sql.update_chat_notice, (system_content, SendUserId, guid, ReceiveUserId)) ApiResponse.message = "成功" ApiResponse.status = 200 return api_response.response_return(ApiResponse)
def insert_dynamic(content, imageUrl, isTop, sort, readCount, current_user_id): if content == None or content == "" or current_user_id == None or current_user_id == "": raise custom_error.CustomFlaskErr(status_code=500, message="参数不正确,请刷新后重试") data_register = mysql.operate_object( dynamic_sql.insert_dynamic, (current_user_id, content, imageUrl, isTop, sort, readCount, current_user_id, current_user_id)) return data_register > 0
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 unfollow(): ApiResponse = api_response.ApiResponse() user = request_helper.current_user_mush_login() plannerId = request.form.get("plannerId", type=str, default=None) if any(user) and plannerId != None: count = mysql.operate_object(planner_sql.planner_unfollw, (user["Id"], plannerId)) ApiResponse.message = "成功" ApiResponse.status = 200 return api_response.response_return(ApiResponse)
def delete_base_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不能为空") if mysql.operate_object(config_sql.delete_config, (Key)) <= 0: raise custom_error.CustomFlaskErr(status_code=500, message="删除失败") ApiResponse.message = "成功" ApiResponse.status = 200 return api_response.response_return(ApiResponse)
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 updateheadimage(): ApiResponse = api_response.ApiResponse() headimage = request.form.get("headimage", type=str, default=None) user = request_helper.current_user_mush_login() data_register = mysql.operate_object(user_info_sql.update_user_headimage, (headimage, user["Id"], user["Id"])) if data_register > 0: ApiResponse.message = "修改成功" ApiResponse.status = 200 return api_response.response_return(ApiResponse) raise custom_error.CustomFlaskErr(status_code=500, message="修改失败")
def browse(): ApiResponse = api_response.ApiResponse() user = request_helper.current_user_mush_login() demandServiceId = request.form.get("demandServiceId", type=str, default=None) if any(user) and demandServiceId != None and demandServiceId != "": count = mysql.operate_object(demand_service_sql.demand_service_browse, (user["Id"], demandServiceId)) ApiResponse.message = "成功" ApiResponse.status = 200 return api_response.response_return(ApiResponse)
def insert_browse_service(): ApiResponse = api_response.ApiResponse() Name = request.form.get("Name", type=str, default=None) if Name == None or Name == "": raise custom_error.CustomFlaskErr(status_code=500, message="名称不能为空") TimeStart = request.form.get("TimeStart", type=str, default=None) TimeEnd = request.form.get("TimeEnd", type=str, default=None) if TimeStart == None or TimeStart == "" or TimeEnd == None or TimeEnd == "": raise custom_error.CustomFlaskErr(status_code=500, message="起止时间不能为空") PriceStart = request.form.get("PriceStart", type=float, default=0.0) PriceEnd = request.form.get("PriceEnd", type=float, default=0.0) Description = request.form.get("Description", type=str, default=None) if Description == None or Description == "": raise custom_error.CustomFlaskErr(status_code=500, message="需求描述不能为空") ServiceTypeId = request.form.get("ServiceId", type=int, default=0) ServiceAreaId = request.form.get("ServiceAreaId", type=int, default=0) if ServiceAreaId == 0: raise custom_error.CustomFlaskErr(status_code=500, message="服务区域不能为空") user = request_helper.current_user_mush_login() Type = 2 if user["UserType"] == 1: Type = 1 guid = str(uuid.uuid1()) data = mysql.operate_object( demand_service_sql.insert_demand_service, (guid, user["Id"], Name, Type, ServiceAreaId, ServiceTypeId, PriceStart, PriceEnd, TimeStart, TimeEnd, Description, user["Id"], user["Id"])) plannerId = request.form.get("plannerId", type=str, default=None) ContractId = request.form.get("ContractId", type=int, default=0) if plannerId != None and plannerId != "" and Type == 1: #新增承接 mysql.operate_object( demand_undertake.insert_demand_undertake, (guid, plannerId, user["Id"], enum.IsUser.yes, ContractId)) ApiResponse.message = "成功" ApiResponse.status = 200 ApiResponse.data = data return api_response.response_return(ApiResponse)
def delete_album(): ApiResponse = api_response.ApiResponse() Id = request.form.get("Id", type=int, default=0) if Id <= 0: raise custom_error.CustomFlaskErr(status_code=500, message="请选择需要删除的照片") user = request_helper.current_user_mush_login() data = mysql.operate_object(planner_sql.delete_album, (user["Id"], Id, user["Id"])) ApiResponse.message = "成功" ApiResponse.status = 200 ApiResponse.data = data return api_response.response_return(ApiResponse)
def delete_society(): ApiResponse = api_response.ApiResponse() Id = request.form.get("Id", type=str, default=None) if Id == None or Id == "": raise custom_error.CustomFlaskErr(status_code=500, message="请选择需要修改的社会背景") user = request_helper.current_user_mush_login() data = mysql.operate_object(planner_sql.delete_society, (user["Id"], Id, user["Id"])) ApiResponse.message = "成功" ApiResponse.status = 200 ApiResponse.data = data return api_response.response_return(ApiResponse)
def insert_base_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不能为空") Value = request.form.get("Value", type=str, default=None) Remark = request.form.get("Remark", type=str, default=None) imageUrl = request.form.get("imageUrl", type=str, default=None) if mysql.operate_object(config_sql.insert_config, (Key, Value, Remark, imageUrl)) <= 0: raise custom_error.CustomFlaskErr(status_code=500, message="新增失败") ApiResponse.message = "成功" ApiResponse.status = 200 return api_response.response_return(ApiResponse)
def update_BigV(): ApiResponse = api_response.ApiResponse() UserId = request.form.get("UserId", type=str, default=None) BigV = request.form.get("BigV", type=int, default=0) if UserId == None or UserId == "": raise custom_error.CustomFlaskErr(status_code=500, message="请选择需要修改的规划师") user = request_back_helper.current_user_mush_login() data = mysql.operate_object(planner_sql.update_BigV, (BigV, user["UserId"], UserId)) #data = back_planner_logic.update_BigV,(BigV,UserId,user["UserId"]) ApiResponse.message = "成功" ApiResponse.status = 200 ApiResponse.data = data return api_response.response_return(ApiResponse)
def insert_evaluate(orderId, userId, content, sort, synthesis, quality, efficiency, lable): if synthesis <= 0 or synthesis > 5: synthesis = 5 if quality <= 0 or quality > 5: quality = 5 if efficiency <= 0 or efficiency > 5: efficiency = 5 return mysql.operate_object( order_sql.insert_evaluate, (content, synthesis, quality, efficiency, lable, orderId, userId, orderId, orderId, userId, orderId, orderId, userId, content, sort, userId, userId, orderId, userId, orderId, userId, orderId, userId, lable, lable, userId, userId, orderId, userId, lable))
def insert_album(): ApiResponse = api_response.ApiResponse() PhotoName = request.form.get("PhotoName", type=str, default=None) if PhotoName == None or PhotoName == "": raise custom_error.CustomFlaskErr(status_code=500, message="照片名称不能为空") Url = request.form.get("Url", type=str, default=None) if Url == None or Url == "": raise custom_error.CustomFlaskErr(status_code=500, message="照片地址不能为空") Sort = request.form.get("Sort", type=int, default=0) user = request_helper.current_user_mush_login() data = mysql.operate_object( planner_sql.insert_album, (user["Id"], PhotoName, Url, Sort, user["Id"], user["Id"])) ApiResponse.message = "成功" ApiResponse.status = 200 ApiResponse.data = data return api_response.response_return(ApiResponse)