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_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 get_current_login_user(): ApiResponse = api_response.ApiResponse() user = request_back_helper.current_user_mush_login() ApiResponse.message = "获取成功" ApiResponse.status = 200 ApiResponse.data = user return api_response.response_return(ApiResponse)
def updateuserinfobyupgrade(): 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="真实姓名不能为空") Address = request.form.get("Address", type=str, default=None) IDCard = request.form.get("IDCard", type=str, default=None) if IDCard == None or IDCard == "": raise custom_error.CustomFlaskErr(status_code=500, message="个人证件不能为空") IDCardJust = request.form.get("IDCardJust", type=str, default=None) IDCardBack = request.form.get("IDCardBack", type=str, default=None) ChatNo = request.form.get("ChatNo", type=str, default=None) user = request_helper.current_user_mush_login() nicheng = user['Name'] if nicheng is None: nicheng = Name sql_list = [user_info_sql.update_user_info_by_upgrade] args_list = [(Name, Address, IDCard, IDCardJust, IDCardBack, user["Id"], ChatNo, nicheng, user["Id"])] data_result = mysql.operate__many(sql_list, args_list) if data_result != None and data_result > 0: ApiResponse.message = "修改成功" ApiResponse.status = 200 return api_response.response_return(ApiResponse) raise custom_error.CustomFlaskErr(status_code=500, message="修改失败")
def service_list(): ApiResponse = api_response.ApiResponse() data = mysql.get_list(service_sql.select_service_list, ()) ApiResponse.message = "成功" ApiResponse.status = 200 ApiResponse.data = data return api_response.response_return(ApiResponse)
def new_contract(): ApiResponse = api_response.ApiResponse() data = mysql.get_object(user_info_sql.select_new_contract, ()) ApiResponse.message = "成功" ApiResponse.status = 200 ApiResponse.data = data 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 back_insert_userinfo(): ApiResponse = api_response.ApiResponse() account = request.form.get("Account", type=str, default=None) phone = request.form.get("Phone", type=str, default=None) password = request.form.get("Password", type=str, default=None) userType = request.form.get("UserType", type=int, default=0) name = request.form.get("Name", type=str, default=None) realName = request.form.get("RealName", type=str, default=None) sex = request.form.get("Sex", type=int, default=0) age = request.form.get("Age", type=int, default=0) education = request.form.get("Education", type=str, default=None) address = request.form.get("Address", type=str, default=None) email = request.form.get("Email", type=str, default=None) headImage = request.form.get("HeadImage", type=str, default=None) if headImage is None or headImage == '': headImage = "files/person.jpg" IDCard = request.form.get("IDCard", type=str, default=None) IDCardJust = request.form.get("IDCardJust", type=str, default=None) IDCardBack = request.form.get("IDCardBack", type=str, default=None) user = request_back_helper.current_user_mush_login() guid = str(uuid.uuid1()) password = hashlib.md5(password.encode(encoding='gb2312')).hexdigest() data_register = user_logic.insert_userinfo(guid, account, phone, password, userType, name, realName, sex, age, education, address, email, headImage, IDCard, IDCardJust, IDCardBack, user["UserId"]) if data_register: ApiResponse.message = "修改成功" ApiResponse.status = 200 return api_response.response_return(ApiResponse) raise custom_error.CustomFlaskErr(status_code=500, message="修改失败")
def select_platforminfo(): ApiResponse = api_response.ApiResponse() platforminfo = baseinfo_logic.select_platforminfo() Contract = baseinfo_logic.select_contract() ApiResponse.data={"platforminfo":platforminfo,"Contract":Contract} return api_response.response_return(ApiResponse)
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 back_updateplanner(): ApiResponse = api_response.ApiResponse() userid = request.form.get("UserId", type=str, default=None) account = request.form.get("Account", type=str, default=None) phone = request.form.get("Phone", type=str, default=None) userType = request.form.get("UserType", type=int, default=0) name = request.form.get("Name", type=str, default=None) realName = request.form.get("RealName", type=str, default=None) sex = request.form.get("Sex", type=int, default=0) age = request.form.get("Age", type=int, default=0) education = request.form.get("Education", type=str, default=None) address = request.form.get("Address", type=str, default=None) email = request.form.get("Email", type=str, default=None) headImage = request.form.get("HeadImage", type=str, default=None) IDCard = request.form.get("IDCard", type=str, default=None) IDCardJust = request.form.get("IDCardJust", type=str, default=None) IDCardBack = request.form.get("IDCardBack", type=str, default=None) ServiceAreaId = request.form.get("ServiceAreaId", type=str, default=None) ServiceTypeId = request.form.get("ServiceTypeId", type=str, default=None) Sort = request.form.get("Sort", type=int, default=0) user = request_back_helper.current_user_mush_login() data_register = back_planner_logic.update_planner( account, phone, userType, name, realName, sex, age, education, address, email, headImage, IDCard, IDCardJust, IDCardBack, ServiceAreaId, ServiceTypeId, userid, Sort, user["UserId"]) if data_register: ApiResponse.message = "修改成功" ApiResponse.status = 200 return api_response.response_return(ApiResponse) raise custom_error.CustomFlaskErr(status_code=500, message="修改失败")
def back_update_education(): 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="请选择需要修改的学历") TimeStart = request.form.get("TimeStart", type=str, default="") TimeEnd = request.form.get("TimeEnd", type=str, default="") #if TimeStart == None or TimeStart=="" or TimeEnd==None or TimeEnd=="": # raise custom_error.CustomFlaskErr(status_code=500, message="起止时间不能为空") University = request.form.get("University", type=str, default=None) if University == None or University == "": raise custom_error.CustomFlaskErr(status_code=500, message="毕业学校不能为空") Degree = request.form.get("Degree", type=str, default=None) if Degree == None or Degree == "": raise custom_error.CustomFlaskErr(status_code=500, message="学位不能为空") Sort = request.form.get("Sort", type=int, default=0) user = request_back_helper.current_user_mush_login() data = back_planner_logic.update_education(TimeStart, TimeEnd, University, Degree, Sort, Id, user["UserId"]) ApiResponse.message = "成功" ApiResponse.status = 200 ApiResponse.data = data return api_response.response_return(ApiResponse)
def agree_join_team(): ApiResponse = api_response.ApiResponse() userId = request_helper.current_user_mush_login()["Id"] NoticeId = request.form.get("NoticeId", type=str, default=None) if NoticeId is None or NoticeId == '': raise custom_error.CustomFlaskErr(status_code=500, message="团队通知id不能为空") exists_team = mysql.get_object(team_sql.exists_team_peoper_bynoticeid, (NoticeId)) if exists_team is not None and exists_team["IsAdmin"] != 1: raise custom_error.CustomFlaskErr(status_code=500, message="您不是团队管理员") if exists_team is None or exists_team["Status"] != 1: raise custom_error.CustomFlaskErr(status_code=500, message="您没有需要审核的团队消息") sql_list = [ team_sql.insert_team_member, team_sql.update_team_admin_notice, team_sql.update_team_notice, team_sql.update_planner_statistics ] args_list = [(exists_team["TeamId"], exists_team["duUserId"], userId), (userId, NoticeId), (userId, exists_team["UnionId"]), (exists_team["TeamId"], userId, exists_team["duUserId"])] resultInt = mysql.operate__many(sql_list, args_list) if resultInt <= 0: raise custom_error.CustomFlaskErr(status_code=500, message="审批失败") ApiResponse.message = "成功" ApiResponse.status = 200 return api_response.response_return(ApiResponse)
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 quit_team(): 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不能为空") is_team_admin = mysql.get_object(team_sql.is_team_admin, (TeamId, userId)) if (is_team_admin["total"] > 0): # 是团队管理员,解散团队 sql_list = [ team_sql.disband_team1, team_sql.disband_team2, team_sql.update_planner_statistics_null, team_sql.delete_team_notice_admin ] args_list = [(userId, TeamId, userId), (userId, TeamId), (userId), (TeamId)] resultInt = mysql.operate__many(sql_list, args_list) else: sql_list = [ team_sql.quit_team, team_sql.update_planner_statistics_null, team_sql.delete_team_notice ] args_list = [(userId, TeamId, userId), (userId), (userId, TeamId)] resultInt = mysql.operate__many(sql_list, args_list) if resultInt <= 0: raise custom_error.CustomFlaskErr(status_code=500, message="退出团队失败") ApiResponse.message = "成功" ApiResponse.status = 200 return api_response.response_return(ApiResponse)
def demand_service_info(): ApiResponse = api_response.ApiResponse() demandServiceId = request.form.get("demandServiceId", type=str, default=None) if demandServiceId == None and demandServiceId == "": raise custom_error.CustomFlaskErr(status_code=500, message="需求或者服务不存在") data = mysql.get_object(demand_service_sql.select_demand_service_info, (demandServiceId)) collection_count = 0 undertake_count = 0 user = request_helper.current_user() if user != None and any( user) and data != None: #and user["Id"]!=data["UserId"]: obj = demand_service_logic.get_whether_collection( user["Id"], demandServiceId) collection_count = obj["collection_count"] data_exists = mysql.get_object( demand_undertake.select_exists_demand_service, (demandServiceId, user["Id"])) undertake_count = data_exists["total"] data["collection_count"] = collection_count data["isfllow"] = collection_count data["undertake_count"] = undertake_count ApiResponse.message = "成功" ApiResponse.status = 200 ApiResponse.data = data return api_response.response_return(ApiResponse)
def upgrade_user(): ApiResponse = api_response.ApiResponse() Sex = request.form.get("Sex", type=int, default=0) if Sex == 0: raise custom_error.CustomFlaskErr(status_code=500, message="性别不能为空") Name = request.form.get("Name", type=str, default=None) if Name == None: raise custom_error.CustomFlaskErr(status_code=500, message="真实姓名不能为空") Address = request.form.get("Address", type=str, default=None) if Address == None: raise custom_error.CustomFlaskErr(status_code=500, message="地址不能为空") ServiceId = request.form.get("ServiceId", type=str, default=None) if ServiceId == None or ServiceId == "": raise custom_error.CustomFlaskErr(status_code=500, message="服务不能为空") ServiceAreaId = request.form.get("ServiceAreaId", type=str, default=None) if ServiceAreaId == None or ServiceAreaId == "": raise custom_error.CustomFlaskErr(status_code=500, message="服务区域不能为空") Email = request.form.get("Email", type=str, default=None) if Email == None: raise custom_error.CustomFlaskErr(status_code=500, message="邮箱不能为空") Experience = request.form.get("Experience", type=str, default=None) if Experience == None: raise custom_error.CustomFlaskErr(status_code=500, message="资历不能为空") IDCard = request.form.get("IDCard", type=str, default=None) if IDCard == None: raise custom_error.CustomFlaskErr(status_code=500, message="身份证不能为空") IDCardPic = request.form.get("IDCardPic", type=str, default=None) if IDCardPic == None: raise custom_error.CustomFlaskErr(status_code=500, message="身份证正面不能为空") IDCardBackPic = request.form.get("IDCardBackPic", type=str, default=None) if IDCardBackPic == None: raise custom_error.CustomFlaskErr(status_code=500, message="身份证反面不能为空") userId = request_helper.current_user_mush_login()["Id"] nicheng = request_helper.current_user_mush_login()["Name"] if nicheng is None: nicheng = Name data_exists = mysql.get_list(user_upgrade.select_exists_upgrade, (userId)) if len(data_exists): raise custom_error.CustomFlaskErr(status_code=500, message="你已经存在申请过注册规划师") argData = [(userId, Sex, Name, Address, ServiceId, ServiceAreaId, Email, Experience, IDCardPic, userId, IDCardBackPic, IDCard), (nicheng, userId)] argSql = (user_upgrade.insert_upgrade_user, user_upgrade.update_user_info_name) data_register = mysql.operate__many(argSql, argData) if data_register > 0: ApiResponse.message = "申请成功" ApiResponse.status = 200 return api_response.response_return(ApiResponse) raise custom_error.CustomFlaskErr(status_code=500, message="申请失败")
def select_permission_list(): ApiResponse = api_response.ApiResponse() user = request_back_helper.current_user_mush_login() data = sys_role_logic.select_permission_list(user["UserId"]) ApiResponse.message = "成功" ApiResponse.status = 200 ApiResponse.data = data return api_response.response_return(ApiResponse)
def select_dynamic_info(): ApiResponse = api_response.ApiResponse() dynamicId = request.form.get("dynamicId", type=int, default=None) dynamic = dynamic_logic.select_dynamic_info(dynamicId) ApiResponse.message = "成功" ApiResponse.status = 200 ApiResponse.data = dynamic return api_response.response_return(ApiResponse)
def service(): ApiResponse = api_response.ApiResponse() count = request.form.get("count", type=int, default=5) data = mysql.get_list(service_sql.select_top_service, (count)) ApiResponse.message = "成功" ApiResponse.status = 200 ApiResponse.data = data return api_response.response_return(ApiResponse)
def delete_sys_user(): ApiResponse = api_response.ApiResponse() user_id= request.form.get("user_id", type=str, default=None) user = request_back_helper.current_user_mush_login() data_register = sys_user_logic.delete_sys_user(user_id, user["UserId"]) ApiResponse.message = "删除成功" ApiResponse.status = 200 return api_response.response_return(ApiResponse)
def system_error(error): # 部署时需要去掉error.args[1] message = "" if len(error.args) > 1: message = error.args[1] else: message = error.args[0] ApiResponse = api_response.ApiResponse(message, 500, "系统错误") return api_response.response_return(ApiResponse)
def insert_dynanic(): ApiResponse = api_response.ApiResponse() content = request.form.get("content", type=str, default=None) imageUrl = request.form.get("imageUrl", type=str, default=None) user = request_helper.current_user_mush_login() data = dynamic_logic.insert_dynanic(user["Id"], content, imageUrl) ApiResponse.message = "成功" ApiResponse.status = 200 return api_response.response_return(ApiResponse)
def select_dynamic_list(): ApiResponse = api_response.ApiResponse() size = request.form.get("size", type=int, default=10) page = request.form.get("page", type=int, default=1) data = dynamic_logic.select_dynamic_list(page, size) ApiResponse.message = "成功" ApiResponse.status = 200 ApiResponse.data = data return api_response.response_return(ApiResponse)
def cooperation(): ApiResponse = api_response.ApiResponse() size = request.form.get("size", type=int, default=10) page = request.form.get("page", type=int, default=1) data = mysql.get_list(platform_sql.select_platform_cooperation, ((page-1)*size,size)) ApiResponse.message = "成功" ApiResponse.status = 200 ApiResponse.data = data return api_response.response_return(ApiResponse)
def get_config_list(): 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_list, (Key)) ApiResponse.message = "成功" ApiResponse.data = data return api_response.response_return(ApiResponse)
def select_user_role_list(): ApiResponse = api_response.ApiResponse() user_id = request.form.get("user_id", type=str, default=None) user = request_back_helper.current_user_mush_login() data = sys_role_logic.select_user_role_list(user_id, user["UserId"]) ApiResponse.message = "成功" ApiResponse.status = 200 ApiResponse.data = data return api_response.response_return(ApiResponse)
def select_sys_role_info(): ApiResponse = api_response.ApiResponse() role_id = request.form.get("role_id", type=int, default=None) user = request_back_helper.current_user_mush_login() roleinfo = sys_role_logic.select_sys_role_info(role_id) if roleinfo != None and any(roleinfo): ApiResponse.data = roleinfo return api_response.response_return(ApiResponse) raise custom_error.CustomFlaskErr(status_code=500, message="角色不存在")
def select_sys_user_info(): ApiResponse = api_response.ApiResponse() user_id = request.form.get("user_id", type=str, default="") user = request_back_helper.current_user_mush_login() userinfo = sys_user_logic.select_sys_user_info(user_id) if userinfo !=None and any(userinfo): ApiResponse.data=userinfo return api_response.response_return(ApiResponse) raise custom_error.CustomFlaskErr(status_code=500, message="用户不存在")
def get_login_user(): ApiResponse = api_response.ApiResponse() user = request_helper.current_user_mush_login() if any(user): ApiResponse.message = "成功" ApiResponse.status = 200 ApiResponse.data = user return api_response.response_return(ApiResponse) raise custom_error.CustomFlaskErr(status_code=600, message="请先登录")