def update_user_info():
U"""用户更新资料"""
if request.method == "POST":
user_id = session.get("user_id")
phone = request.form.get("phonenum")
username = request.form.get("engname")
email = request.form.get("email")
pic = request.form.get("pic")
print request.form
phone = request.form.get("phonenum")
check_num = request.form.get("checknum")
user = User.get_user_info(g.db, user_id)
if check_num or check_num == "":
print user.checknum, check_num, checknum_timeout(
user.checknum_time)
if check_num == "":
return jsonify(status="checknum_error")
if user.checknum == int(check_num) and checknum_timeout(
user.checknum_time):
User.update_user_phone(
g.db,
user.id,
phone,
user.phone_old,
)
else:
return jsonify(status="checknum_error")
if request.form.get("passwordold"):
password = request.form.get("password")
passwordold = request.form.get("passwordold")
if not User.change_password_old(g.db, user_id,
set_password_salt(password),
set_password_salt(passwordold)):
return jsonify(status="false")
if pic is not None:
User.update_user_pic(g.db, user_id, pic)
Stasub.del_sub(g.db, user_id)
if request.form.get("GRE[sub][0][id]"):
num = 0
while True:
if request.form.get("GRE[sub][" + str(num) + "][id]"):
sub_id = request.form.get("GRE[sub][" + str(num) + "][id]",
0, int)
grade = request.form.get(
"GRE[sub][" + str(num) + "][grade]", 0, int)
sub_type = 0
if sub_id > 10:
sub_type = 1
Stasub.set_sub(g.db,
sub_id=sub_id,
grade=grade,
sub_type=sub_type,
user_id=user_id)
num += 1
else:
break
# Stasub.del_sub(g.db,user_id)
if request.form.get("SAT[sub][0][grade]"):
num = 0
while True:
if request.form.get("SAT[sub][" + str(num) + "][id]"):
sub_id = request.form.get("SAT[sub][" + str(num) + "][id]",
0, int)
grade = request.form.get(
"SAT[sub][" + str(num) + "][grade]", 0, int)
sub_type = 0
if sub_id > 10:
sub_type = 1
Stasub.set_sub(g.db,
sub_id=sub_id,
grade=grade,
sub_type=sub_type,
user_id=user_id)
num += 1
else:
break
prevmajor = request.form.get("majorid")
prevuniversity = request.form.get("universityid")
User.update_user_info(g.db,
user_id=user_id,
username=username,
email=email,
prevuniversity=prevuniversity,
prevmajor=prevmajor)
if request.form.get("IELTS[R]") is not None:
LELTSmoreR = request.form.get("IELTS[R]", float)
LELTSmoreL = request.form.get("IELTS[L]", float)
LELTSmoreS = request.form.get("IELTS[S]", float)
LELTSmoreW = request.form.get("IELTS[W]", float)
sub_TELTS = request.form.get("IELTS[total]", float)
if request.form.get("GRE[V]") is not None:
GREmoreV = request.form.get("GRE[V]", int)
GREmoreQ = request.form.get("GRE[Q]", int)
GREmoreAW = request.form.get("GRE[AW]", float)
sub_GRE = request.form.get("GRE[total]", int)
User.update_user_score(g.db,
user_id,
gre=sub_GRE,
lelts=sub_TELTS)
Score.set_user_info(connection=g.db,
user_id=user_id,
IELTS_r=LELTSmoreR,
IELTS_l=LELTSmoreL,
IELTS_s=LELTSmoreS,
IELTS_w=LELTSmoreW,
GRE_v=GREmoreV,
GRE_q=GREmoreQ,
GRE_aw=GREmoreAW)
elif request.form.get("SAT[M]"):
sat_m = request.form.get("SAT[M]", int)
sat_cr = request.form.get("SAT[CR]", int)
sat_w = request.form.get("SAT[W]", int)
sub_sat = request.form.get("SAT[total]", int)
User.update_user_score(g.db,
user_id=user_id,
lelts=sub_TELTS,
sat=sub_sat)
Score.set_user_info(connection=g.db,
user_id=user_id,
IELTS_r=LELTSmoreR,
IELTS_l=LELTSmoreL,
IELTS_s=LELTSmoreS,
IELTS_w=LELTSmoreW,
SAT_m=sat_m,
SAT_w=sat_w,
SAT_cr=sat_cr)
else:
GMATmoreV = request.form.get("GMAT[V]", int)
GMATmoreQ = request.form.get("GMAT[Q]", int)
GMATmoreAW = request.form.get("GMAT[AW]", float)
GMATmoreIR = request.form.get("GMAT[IR]", int)
sub_GMAT = request.form.get("GMAT[total]", int)
User.update_user_score(g.db,
user_id=user_id,
lelts=sub_TELTS,
GMAT=sub_GMAT)
Score.set_user_info(connection=g.db,
user_id=user_id,
IELTS_r=LELTSmoreR,
IELTS_l=LELTSmoreL,
IELTS_s=LELTSmoreS,
IELTS_w=LELTSmoreW,
GMAT_v=GMATmoreV,
GMAT_q=GMATmoreQ,
GMAT_aw=GMATmoreAW,
GMAT_ir=GMATmoreIR)
elif request.form.get("TOEFL[R]") is not None:
TOEFLmoreR = request.form.get("TOEFL[R]", int)
TOEFLmoreL = request.form.get("TOEFL[L]", int)
TOEFLmoreS = request.form.get("TOEFL[S]", int)
TOEFLmoreW = request.form.get("TOEFL[W]", int)
sub_TOEFL = request.form.get("TOEFL[total]", int)
if request.form.get("GRE[V]") is not None:
GREmoreV = request.form.get("GRE[V]", int)
GREmoreQ = request.form.get("GRE[Q]", int)
GREmoreAW = request.form.get("GRE[AW]", float)
sub_GRE = request.form.get("GRE[total]", int)
User.update_user_score(g.db,
user_id=user_id,
gre=sub_GRE,
toefl=sub_TOEFL)
Score.set_user_info(connection=g.db,
user_id=user_id,
TOEFL_r=TOEFLmoreR,
TOEFL_l=TOEFLmoreL,
TOEFL_s=TOEFLmoreS,
TOEFL_w=TOEFLmoreW,
GRE_v=GREmoreV,
GRE_q=GREmoreQ,
GRE_aw=GREmoreAW)
elif request.form.get("SAT[M]"):
sat_m = request.form.get("SAT[M]", 0, int)
sat_cr = request.form.get("SAT[CR]", 0, int)
sat_w = request.form.get("SAT[W]", 0, int)
sub_sat = request.form.get("SAT[total]", 0, int)
User.update_user_score(g.db,
user_id=user_id,
toefl=sub_TOEFL,
sat=sub_sat)
Score.set_user_info(connection=g.db,
user_id=user_id,
TOEFL_r=TOEFLmoreR,
TOEFL_l=TOEFLmoreL,
TOEFL_s=TOEFLmoreS,
TOEFL_w=TOEFLmoreW,
SAT_m=sat_m,
SAT_w=sat_w,
SAT_cr=sat_cr)
else:
GMATmoreV = request.form.get("GMAT[V]", int)
GMATmoreQ = request.form.get("GMAT[Q]", int)
GMATmoreAW = request.form.get("GMAT[AW]", float)
GMATmoreIR = request.form.get("GMAT[IR]", int)
sub_GMAT = request.form.get("GMAT[total]", int)
User.update_user_score(g.db,
user_id=user_id,
toefl=sub_TOEFL,
GMAT=sub_GMAT)
Score.set_user_info(connection=g.db,
user_id=user_id,
TOEFL_r=TOEFLmoreR,
TOEFL_l=TOEFLmoreL,
TOEFL_s=TOEFLmoreS,
TOEFL_w=TOEFLmoreW,
GMAT_v=GMATmoreV,
GMAT_q=GMATmoreQ,
GMAT_aw=GMATmoreAW,
GMAT_ir=GMATmoreIR)
User.set_user_active(g.db, user_id)
Offer.set_user_offer_result(g.db, user_id)
return jsonify(status="success")
return jsonify(status="false")
def set_user_score():
if request.method == "POST":
user_id = session.get("user_id")
if request.form.get("bginf") is not None:
bginf = request.form.get("bginf")
User.update_user_bginf(g.db, user_id, bginf)
Stasub.del_sub(g.db, user_id)
if request.form.get("GREmore[sub][0][id]"):
num = 0
while True:
if request.form.get("GREmore[sub][" + str(num) + "][id]"):
sub_id = request.form.get(
"GREmore[sub][" + str(num) + "][id]", 0, int)
grade = request.form.get(
"GREmore[sub][" + str(num) + "][grade]", 0, int)
sub_type = 0
if sub_id > 10:
sub_type = 1
Stasub.set_sub(g.db,
sub_id=sub_id,
grade=grade,
sub_type=sub_type,
user_id=user_id)
num += 1
else:
break
if request.form.get("SATmore[sub][0][grade]"):
num = 0
while True:
if request.form.get("SATmore[sub][" + str(num) + "][id]"):
sub_id = request.form.get(
"SATmore[sub][" + str(num) + "][id]", 0, int)
grade = request.form.get(
"SATmore[sub][" + str(num) + "][grade]", 0, int)
sub_type = 0
if sub_id > 10:
sub_type = 1
Stasub.set_sub(g.db,
sub_id=sub_id,
grade=grade,
sub_type=sub_type,
user_id=user_id)
num += 1
else:
break
if request.form.get("IELTSmore[R]") is not None:
LELTSmoreR = request.form.get("IELTSmore[R]", float)
LELTSmoreL = request.form.get("IELTSmore[L]", float)
LELTSmoreS = request.form.get("IELTSmore[S]", float)
LELTSmoreW = request.form.get("IELTSmore[W]", float)
sub_TELTS = request.form.get("IELTSmore[total]", float)
#sub_TELTS = get_TELTS(LELTSmoreS, LELTSmoreL, LELTSmoreR,
# LELTSmoreW)
if request.form.get("GREmore[V]") is not None:
GREmoreV = request.form.get("GREmore[V]", int)
GREmoreQ = request.form.get("GREmore[Q]", int)
GREmoreAW = request.form.get("GREmore[AW]", float)
sub_GRE = request.form.get("GREmore[total]", int)
User.update_user_score(g.db,
user_id,
gre=sub_GRE,
lelts=sub_TELTS)
Score.set_user_info(connection=g.db,
user_id=user_id,
IELTS_r=LELTSmoreR,
IELTS_l=LELTSmoreL,
IELTS_s=LELTSmoreS,
IELTS_w=LELTSmoreW,
GRE_v=GREmoreV,
GRE_q=GREmoreQ,
GRE_aw=GREmoreAW)
elif request.form.get("SATmore[M]") is not None:
sat_m = request.form.get("SATmore[M]", int)
sat_cr = request.form.get("SATmore[CR]", int)
sat_w = request.form.get("SATmore[W]", int)
sub_sat = request.form.get("SATmore[total]", int)
#sub_sat = get_SAT(sat_cr,sat_w,sat_m)
User.update_user_score(g.db,
user_id=user_id,
lelts=sub_TELTS,
sat=sub_sat)
Score.set_user_info(connection=g.db,
user_id=user_id,
IELTS_r=LELTSmoreR,
IELTS_l=LELTSmoreL,
IELTS_s=LELTSmoreS,
IELTS_w=LELTSmoreW,
SAT_m=sat_m,
SAT_w=sat_w,
SAT_cr=sat_cr)
elif request.form.get("GMATmore[V]") is not None:
GMATmoreV = request.form.get("GMATmore[V]", int)
GMATmoreQ = request.form.get("GMATmore[Q]", int)
GMATmoreAW = request.form.get("GMATmore[AW]", float)
GMATmoreIR = request.form.get("GMATmore[IR]", int)
sub_GMAT = request.form.get("GMATmore[total]", int)
User.update_user_score(g.db,
user_id=user_id,
lelts=sub_TELTS,
GMAT=sub_GMAT)
Score.set_user_info(connection=g.db,
user_id=user_id,
IELTS_r=LELTSmoreR,
IELTS_l=LELTSmoreL,
IELTS_s=LELTSmoreS,
IELTS_w=LELTSmoreW,
GMAT_v=GMATmoreV,
GMAT_q=GMATmoreQ,
GMAT_aw=GMATmoreAW,
GMAT_ir=GMATmoreIR)
elif request.form.get("TOEFLmore[R]") is not None:
TOEFLmoreR = request.form.get("TOEFLmore[R]", int)
TOEFLmoreL = request.form.get("TOEFLmore[L]", int)
TOEFLmoreS = request.form.get("TOEFLmore[S]", int)
TOEFLmoreW = request.form.get("TOEFLmore[W]", int)
sub_TOEFL = request.form.get("TOEFLmore[total]", int)
#sub_TOEFL = get_Total(TOEFLmoreL, TOEFLmoreR, TOEFLmoreS,
# TOEFLmoreW)
if request.form.get("GREmore[V]") is not None:
GREmoreV = request.form.get("GREmore[V]", int)
GREmoreQ = request.form.get("GREmore[Q]", int)
GREmoreAW = request.form.get("GREmore[AW]", float)
sub_GRE = request.form.get("GREmore[total]", int)
#sub_GRE = get_gre(GREmoreV, GREmoreQ)
User.update_user_score(g.db,
user_id=user_id,
gre=sub_GRE,
toefl=sub_TOEFL)
Score.set_user_info(connection=g.db,
user_id=user_id,
TOEFL_r=TOEFLmoreR,
TOEFL_l=TOEFLmoreL,
TOEFL_s=TOEFLmoreS,
TOEFL_w=TOEFLmoreW,
GRE_v=GREmoreV,
GRE_q=GREmoreQ,
GRE_aw=GREmoreAW)
elif request.form.get("SATmore[M]") is not None:
sat_m = request.form.get("SATmore[M]", int)
sat_cr = request.form.get("SATmore[CR]", int)
sat_w = request.form.get("SATmore[W]", int)
sub_sat = request.form.get("SATmore[total]", int)
User.update_user_score(g.db,
user_id=user_id,
toefl=sub_TOEFL,
sat=sub_sat)
Score.set_user_info(connection=g.db,
user_id=user_id,
TOEFL_r=TOEFLmoreR,
TOEFL_l=TOEFLmoreL,
TOEFL_s=TOEFLmoreS,
TOEFL_w=TOEFLmoreW,
SAT_m=sat_m,
SAT_w=sat_w,
SAT_cr=sat_cr)
else:
GMATmoreV = request.form.get("GMATmore[V]", int)
GMATmoreQ = request.form.get("GMATmore[Q]", int)
GMATmoreAW = request.form.get("GMATmore[AW]", float)
GMATmoreIR = request.form.get("GMATmore[IR]", int)
sub_GMAT = request.form.get("GMATmore[total]", int)
User.update_user_score(g.db,
user_id=user_id,
toefl=sub_TOEFL,
GMAT=sub_GMAT)
Score.set_user_info(connection=g.db,
user_id=user_id,
TOEFL_r=TOEFLmoreR,
TOEFL_l=TOEFLmoreL,
TOEFL_s=TOEFLmoreS,
TOEFL_w=TOEFLmoreW,
GMAT_v=GMATmoreV,
GMAT_q=GMATmoreQ,
GMAT_aw=GMATmoreAW,
GMAT_ir=GMATmoreIR)
User.set_user_active(g.db, user_id)
Offer.set_user_offer_result(g.db, user_id)
return jsonify(status="success")
