def question_create(user, params):
question_id = utils.safe_id(params.get("question_id"))
answer = params.get("answer")
if not question_id or not answer:
return {"error_code": 80002, "msg": "no enough parameters"}
question = Question.select().where(Question.id == question_id).first()
if not question:
return {"error_code": 20242, "msg": "protect question not exists"}
uq = UserQuestion.select().where(UserQuestion.user == user).first()
if uq:
return {"error_code": 20243, "msg": "password question already exists"}
u = UserQuestion()
u.user = user
u.question = question
u.answer = answer
u.save()
queue.to_queue({
"type":
"user_question_create",
"user_id":
user.id,
"team_id":
user.identify[1:] if user.identify[0] != "f" else None
})
return {"error_code": 0, "msg": "ok"}
def other_create(user, params):
amount = utils.decimal_two(params.get("amount", ""))
location = utils.safe_id(params.get("location", ""))
address = params.get("address", "")
postcode = params.get("postcode", "")
if not location or not amount:
return {"error_code": 80002, "msg": "not enough parameters"}
add = Address.select().where(Address.id == location).first()
if not add or add and add.level != 3:
return {"error_code": 20167, "msg": "location invalid"}
if postcode and len(postcode) > 20 or len(address) > 100:
return {"error_code": 20162, "msg": "too long"}
if not amount:
return {"error_code": 20163, "msg": "hourly invalid"}
with database.atomic() as txn:
try:
user.reg_step = "other"
user.status = "active"
user.save()
# 任务加分字断
columns = ["hourly", "location", "address"]
profile = user.profile.first()
profile.hourly = amount
profile.location = location
profile.address = address
if postcode:
profile.postcode = postcode
columns.append("postcode")
profile.save()
queue.to_queue({
"type": "user_completeness",
"user_id": user.id,
"columns": columns
})
except:
return {"error_code": 20164, "msg": "save error"}
return {"error_code": 0, "msg": "ok"}
def other_create(user, params):
amount = utils.decimal_two(params.get("amount", ""))
location = utils.safe_id(params.get("location", ""))
address = params.get("address", "")
postcode = params.get("postcode", "")
if not location or not amount:
return {"error_code": 80002, "msg": "not enough parameters"}
add = Address.select().where(Address.id == location).first()
if not add or add and add.level != 3:
return {"error_code": 20167, "msg": "location invalid"}
if postcode and len(postcode) > 20 or len(address) > 100:
return {"error_code": 20162, "msg": "too long"}
if not amount:
return {"error_code": 20163, "msg": "hourly invalid"}
with database.atomic() as txn:
try:
user.reg_step = "other"
user.status = "active"
user.save()
# 任务加分字断
columns = ["hourly", "location", "address"]
profile = user.profile.first()
profile.hourly = amount
profile.location = location
profile.address = address
if postcode:
profile.postcode = postcode
columns.append("postcode")
profile.save()
queue.to_queue({"type": "user_completeness", "user_id": user.id, "columns": columns})
except:
return {"error_code":20164, "msg":"save error"}
return {"error_code": 0, "msg": "ok"}
def question_create(user, params):
question_id = utils.safe_id(params.get("question_id"))
answer = params.get("answer")
if not question_id or not answer:
return {"error_code": 80002, "msg": "no enough parameters"}
question = Question.select().where(Question.id == question_id).first()
if not question:
return {"error_code": 20242, "msg": "protect question not exists"}
uq = UserQuestion.select().where(UserQuestion.user == user).first()
if uq:
return {"error_code": 20243, "msg": "password question already exists"}
u = UserQuestion()
u.user = user
u.question = question
u.answer = answer
u.save()
queue.to_queue({"type":"user_question_create", "user_id":user.id,
"team_id": user.identify[1:] if user.identify[0] != "f" else None})
return {"error_code": 0, "msg": "ok"}
def question_update(user, params):
question_id = utils.safe_id(params.get('question_id'))
answer_old = params.get('answer_old')
answer = params.get('answer')
if not question_id or not answer_old or not answer:
return {"error_code": 80002, "msg": "no enough parameters"}
question = Question.select().where(Question.id == question_id).first()
if not question:
return {"error_code": 20242, "msg": "protect question not exists"}
uq = UserQuestion.select().where(UserQuestion.user == user).first()
if not uq:
return {"error_code": 20241, "msg": "user protect question not exists"}
if uq.answer != answer_old:
return {"error_code": 20244, "msg": "error answer"}
uq.question = question_id
uq.answer = answer
uq.create_at = utils.now()
uq.save()
return {"error_code": 0, "msg": "ok"}
def question_update(user, params):
question_id = utils.safe_id(params.get('question_id'))
answer_old = params.get('answer_old')
answer = params.get('answer')
if not question_id or not answer_old or not answer:
return {"error_code": 80002, "msg": "no enough parameters"}
question = Question.select().where(Question.id == question_id).first()
if not question:
return {"error_code": 20242, "msg": "protect question not exists"}
uq = UserQuestion.select().where(UserQuestion.user == user).first()
if not uq:
return {"error_code": 20241, "msg": "user protect question not exists"}
if uq.answer != answer_old:
return {"error_code": 20244, "msg": "error answer"}
uq.question = question_id
uq.answer = answer
uq.create_at = utils.now()
uq.save()
return {"error_code": 0, "msg": "ok"}
def user_profile_update(user, params):
if len(params) == 0:
return {"error_code": 0, "msg": "ok"}
email = params.get("email")
name = params.get("name")
location = utils.safe_id(params.get('location'))
address = params.get("address")
postcode = params.get("postcode")
available = params.get("available")
workload = params.get("workload")
title = params.get("title")
overview = params.get("overview")
hourly = params.get("hourly")
skills = params.get("skills")
english = params.get("english")
other = params.get("other", "").strip()
level = params.get("level")
# 更新分值字断名称
columns = list()
profile = user.profile.first()
if email is not None:
if not validate.is_email(email):
return {"error_code": 202710, "msg": "email invalid"}
u = User.select().where(User.email == email).first()
if u and u.id != user.id:
return {"error_code": 202711, "msg": "email is exists"}
user.email = email
user.save()
columns.append("email")
if level is not None:
if level not in ("entry", "middle", "expert"):
return {"error_code": 202712, "msg": "level invalid"}
if profile.level != level:
profile.level = level
columns.append("level")
if name is not None:
if name.strip() != profile.name:
if profile.id_number:
return {"error_code": 20271, "msg": "already verify user, not allow modify name"}
profile.name = name
if location:
add = Address.select().where(Address.id == location).first()
if not add or add and add.level != 3:
return {"error_code": 20272, "msg": "location invalid"}
profile.location = location
columns.append("location")
if address is not None:
if len(address) > 100:
return {"error_code": 20273, "msg": "address too long"}
profile.address = address
columns.append("address")
if postcode is not None:
if len(postcode) > 20:
return {"error_code": 20274, "msg": "postcode too long"}
profile.postcode = postcode
columns.append("postcode")
if available is not None:
if available == "true":
profile.available = True
elif available == "false":
profile.available = False
if workload is not None:
if not (workload.isdigit() and 1 <= int(workload) <= 3):
return {"error_code": 202713, "msg": "workload invalid"}
profile.workload = workload
columns.append("workload")
if title is not None:
if len(title) > 29:
return {"error_code": 20275, "msg": "title too long"}
profile.title = title
columns.append("title")
if overview is not None:
if len(overview) > 1024 * 1024 * 4:
return {"error_code": 20276, "msg": "overview too long"}
profile.overview = overview
columns.append("overview")
if hourly is not None:
try:
hourly = float(hourly)
except:
return {"error_code": 20277, "msg": "hourly invalid"}
profile.hourly = hourly
columns.append("hourly")
if english is not None:
if english not in ("1", "2", "3", "4"):
return {"error_code": 20278, "msg": "english level invalid"}
profile.english = english
columns.append("english")
other_lan = None
if other:
try:
other_lan = utils.loads(other)
for y in other_lan:
if y not in all_languages or str(other_lan[y]) not in ("1", "2", "3", "4"):
other_lan.pop(y)
except:
return {"error_code":20128, "msg":"other language invalid"}
if other_lan != None:
_user_lang = UserLanguage.select().where(UserLanguage.user==user)
for x in _user_lang:
if x.name not in other_lan:
x.delete_instance()
else:
if x.level != other_lan[x.name]:
x.level = other_lan[x.name]
x.save()
other_lan.pop(x.name)
else:
other_lan.pop(x.name)
for y in other_lan:
UserLanguage.create(user=user, name=y, level=other_lan[y])
columns.append("other_language")
if skills is not None:
s = None
try:
s = [x for x in skills.split(",") if x in all_skills]
except:
return {"error_code": 20279, "msg": "skills invalid"}
if s:
profile.skills = utils.dumps(s)
columns.append("skills")
profile.save()
queue.to_queue({"type": "user_completeness", "user_id": user.id, "columns": columns})
return {"error_code": 0, "msg": "ok"}
def user_profile_update(user, params):
if len(params) == 0:
return {"error_code": 0, "msg": "ok"}
email = params.get("email")
name = params.get("name")
location = utils.safe_id(params.get('location'))
address = params.get("address")
postcode = params.get("postcode")
available = params.get("available")
workload = params.get("workload")
title = params.get("title")
overview = params.get("overview")
hourly = params.get("hourly")
skills = params.get("skills")
english = params.get("english")
other = params.get("other", "").strip()
level = params.get("level")
# 更新分值字断名称
columns = list()
profile = user.profile.first()
if email is not None:
if not validate.is_email(email):
return {"error_code": 202710, "msg": "email invalid"}
u = User.select().where(User.email == email).first()
if u and u.id != user.id:
return {"error_code": 202711, "msg": "email is exists"}
user.email = email
user.save()
columns.append("email")
if level is not None:
if level not in ("entry", "middle", "expert"):
return {"error_code": 202712, "msg": "level invalid"}
if profile.level != level:
profile.level = level
columns.append("level")
if name is not None:
if name.strip() != profile.name:
if profile.id_number:
return {
"error_code": 20271,
"msg": "already verify user, not allow modify name"
}
profile.name = name
if location:
add = Address.select().where(Address.id == location).first()
if not add or add and add.level != 3:
return {"error_code": 20272, "msg": "location invalid"}
profile.location = location
columns.append("location")
if address is not None:
if len(address) > 100:
return {"error_code": 20273, "msg": "address too long"}
profile.address = address
columns.append("address")
if postcode is not None:
if len(postcode) > 20:
return {"error_code": 20274, "msg": "postcode too long"}
profile.postcode = postcode
columns.append("postcode")
if available is not None:
if available == "true":
profile.available = True
elif available == "false":
profile.available = False
if workload is not None:
if not (workload.isdigit() and 1 <= int(workload) <= 3):
return {"error_code": 202713, "msg": "workload invalid"}
profile.workload = workload
columns.append("workload")
if title is not None:
if len(title) > 29:
return {"error_code": 20275, "msg": "title too long"}
profile.title = title
columns.append("title")
if overview is not None:
if len(overview) > 1024 * 1024 * 4:
return {"error_code": 20276, "msg": "overview too long"}
profile.overview = overview
columns.append("overview")
if hourly is not None:
try:
hourly = float(hourly)
except:
return {"error_code": 20277, "msg": "hourly invalid"}
profile.hourly = hourly
columns.append("hourly")
if english is not None:
if english not in ("1", "2", "3", "4"):
return {"error_code": 20278, "msg": "english level invalid"}
profile.english = english
columns.append("english")
other_lan = None
if other:
try:
other_lan = utils.loads(other)
for y in other_lan:
if y not in all_languages or str(
other_lan[y]) not in ("1", "2", "3", "4"):
other_lan.pop(y)
except:
return {"error_code": 20128, "msg": "other language invalid"}
if other_lan != None:
_user_lang = UserLanguage.select().where(UserLanguage.user == user)
for x in _user_lang:
if x.name not in other_lan:
x.delete_instance()
else:
if x.level != other_lan[x.name]:
x.level = other_lan[x.name]
x.save()
other_lan.pop(x.name)
else:
other_lan.pop(x.name)
for y in other_lan:
UserLanguage.create(user=user, name=y, level=other_lan[y])
columns.append("other_language")
if skills is not None:
s = None
try:
s = [x for x in skills.split(",") if x in all_skills]
except:
return {"error_code": 20279, "msg": "skills invalid"}
if s:
profile.skills = utils.dumps(s)
columns.append("skills")
profile.save()
queue.to_queue({
"type": "user_completeness",
"user_id": user.id,
"columns": columns
})
return {"error_code": 0, "msg": "ok"}