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 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 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 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 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 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 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_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_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 select_carouselimage_info():
ApiResponse = api_response.ApiResponse()
imageId= request.form.get("imageId", type=int, default=None)
if imageId == None or imageId=="":
raise custom_error.CustomFlaskErr(status_code=500, message="参数imageId不能为空")
imageInfo = baseinfo_logic.select_carouselimage_info(imageId)
if imageInfo !=None and any(imageInfo):
ApiResponse.data=imageInfo
return api_response.response_return(ApiResponse)
raise custom_error.CustomFlaskErr(status_code=500, message="轮询不存在")
def select_service_area_info():
ApiResponse = api_response.ApiResponse()
areaId= request.form.get("areaId", type=int, default=None)
if areaId == None or areaId=="":
raise custom_error.CustomFlaskErr(status_code=500, message="参数areaId不能为空")
userinfo = service_area_logic.select_service_area_info(areaId)
if userinfo !=None and any(userinfo):
ApiResponse.data=userinfo
return api_response.response_return(ApiResponse)
raise custom_error.CustomFlaskErr(status_code=500, message="区域不存在")
def select_ms_dynamic_info():
ApiResponse = api_response.ApiResponse()
dynamicId= request.form.get("dynamicId", type=int, default=None)
if dynamicId == None or dynamicId=="":
raise custom_error.CustomFlaskErr(status_code=500, message="参数dynamicId不能为空")
fileInfo = dynamic_logic.select_dynamic_info(dynamicId)
if fileInfo !=None and any(fileInfo):
ApiResponse.data=fileInfo
return api_response.response_return(ApiResponse)
raise custom_error.CustomFlaskErr(status_code=500, message="资料不存在")
def select_planner_info():
ApiResponse = api_response.ApiResponse()
userid = request.form.get("userid", type=str, default=None)
if userid == None or userid == "":
raise custom_error.CustomFlaskErr(status_code=500,
message="参数userid不能为空")
userinfo = back_planner_logic.select_planner_info(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 select_lable_info():
ApiResponse = api_response.ApiResponse()
lableId = request.form.get("lableId", type=int, default=None)
if lableId == None or lableId == "":
raise custom_error.CustomFlaskErr(status_code=500,
message="参数lableId不能为空")
lableinfo = lable_logic.select_lable_info(lableId)
if lableinfo != None and any(lableinfo):
ApiResponse.data = lableinfo
return api_response.response_return(ApiResponse)
raise custom_error.CustomFlaskErr(status_code=500, message="标签不存在")
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 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 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 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 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 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 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 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 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 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)
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 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_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 replay_evaluate():
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="请选择需要评论的订单")
content = request.form.get("content", type=str, default=None)
if content == None or content=="":
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 = order_logic.replay_evaluate(orderId, user["Id"], content, sort)
ApiResponse.message = "成功"
ApiResponse.status = 200
ApiResponse.data = data
return api_response.response_return(ApiResponse)
def select_user_dynamic_list(userid,page,size):
if userid == None or userid=="":
raise custom_error.CustomFlaskErr(status_code=500, message="输入不正确，请刷新后重试")
if page<=0:
page=1
if size<=0:
size=10
return mysql.get_list(dynamic_sql.select_user_dynamic_list,(userid,(page-1)*size,size))
