def get_user_in_university():
if request.method == "POST":
data = request.form
#return jsonify(status="success")
#data = json.loads(request.data)
user_id = session.get("user_id")
user = User.get_user_info(g.db, user_id)
user_type = -1
if user:
user_type = user.type
university_id = data.get("universityid")
faculty_id = data.get("facultyid")
major_id = data.get("majorid")
GPA_to = data.get("GPA[to]", 0.0, float)
GPA_form = data.get("GPA[from]", 1000, float)
TOEFL_to = request.form.get("TOEFL[to]", 0.0, float)
TOEFL_form = request.form.get("TOEFL[from]", 10000, float)
IELTS_to = request.form.get("IELTS[to]", 0.0, float)
IELTS_form = request.form.get("IELTS[from]", 10000, float)
if TOEFL_to != 0.0 and TOEFL_form != 10000:
IELTS_to = 0.0
IELTS_form = 0.0
elif IELTS_to != 0.0 and IELTS_form != 10000:
TOEFL_to = 0.0
TOEFL_form = 0.0
GRE_to = request.form.get("GRE[to]", 0.0, float)
GRE_form = request.form.get("GRE[from]", 10000, float)
GMAT_to = request.form.get("GMAT[to]", 0.0, float)
GMAT_form = request.form.get("GMAT[from]", 10000, float)
if GRE_to != 0.0 and GRE_form != 10000:
GMAT_to = 0.0
GMAT_form = 0.0
elif GMAT_to != 0.0 and GMAT_form != 10000:
GRE_to = 0.0
GRE_form = 0.0
grade = request.form.get("grade")
print grade
page = data.get("page", 0, int)
compares = {}
compare_list = []
page_list = []
print faculty_id, major_id, university_id
if faculty_id is not None:
student_list = []
if major_id is None:
major_list = dict()
info = list()
for row_major in Major.get_major_from_faculty(
g.db, university_id, faculty_id):
student_list = list()
student = dict()
for row in Offer.get_user_id_from_university(
g.db, university_id, row_major.id, user_type,
grade):
user = User.get_not_mobile_user(g.db, row.user_id)
if user:
if get_compare_score(GPA_to,GPA_form,user.GPA) and \
get_compare_score(TOEFL_to,TOEFL_form,user.TOEFL) and \
get_compare_score(IELTS_to,IELTS_form,user.IELTS) and \
get_compare_score(GRE_to,GRE_form,user.GRE) and \
get_compare_score(GMAT_to,GMAT_form,user.GMAT):
if row.user_id not in student_list:
student_list.append(row.user_id)
student["studentlist"] = student_list
student["majorid"] = row_major.id
student["majorname"] = row_major.name
user_page = len(student_list) / 15
student["more"] = ""
if user_page > page:
student["more"] = "true"
for row in range(user_page):
if row == page:
student["studentlist"] = student_list[page *
16:]
if len(student.get("studentlist")) > 0:
info.append(student)
major_list["majorlist"] = info
major_list["status"] = "success"
return json.dumps(major_list)
elif major_id is not None:
for row in Offer.get_user_id_from_university(
g.db, university_id, major_id, user_type, grade):
user = User.get_not_mobile_user(g.db, row.user_id)
if user:
if get_compare_score(GPA_to,GPA_form,user.GPA) and \
get_compare_score(TOEFL_to,TOEFL_form,user.TOEFL) and \
get_compare_score(IELTS_to,IELTS_form,user.IELTS) and \
get_compare_score(GRE_to,GRE_form,user.GRE) and \
get_compare_score(GMAT_to,GMAT_form,user.GMAT):
if row.user_id not in student_list:
student_list.append(row.user_id)
student = dict()
student["studentlist"] = list(set(student_list))
page = len(student_list) / 15
student["more"] = ""
if int(page) > 1:
student["more"] = "true"
student["status"] = "success"
return json.dumps(student)
else:
student_list = []
for row in Offer.get_user_id_from_university(
g.db, university_id, major_id, user_type, grade):
user = User.get_not_mobile_user(g.db, row.user_id)
if user:
if get_compare_score(GPA_to,GPA_form,user.GPA) and \
get_compare_score(TOEFL_to,TOEFL_form,user.TOEFL) and \
get_compare_score(IELTS_to,IELTS_form,user.IELTS) and \
get_compare_score(GRE_to,GRE_form,user.GRE) and \
get_compare_score(GMAT_to,GMAT_form,user.GMAT):
if row.user_id not in student_list:
student_list.append(row.user_id)
student = dict()
user_page = len(student_list) / 16
user_page_last = len(student_list) % 16
student["more"] = ""
if len(student_list) < 16:
student["status"] = "success"
student["studentlist"] = student_list
return json.dumps(student)
if user_page > page:
for row in range(user_page):
if row == page:
student["studentlist"] = student_list[page *
16:(page + 1) *
16]
student["more"] = "true"
break
elif user_page < page:
student["studentlist"] = student_list[-user_page_last:]
student["status"] = "success"
return json.dumps(student)
return jsonify(status="success")
def set_offer():
if request.method == "POST":
data = request.form
user_id = session["user_id"]
user = User.get_user_info(g.db, user_id)
user_type = None
if user:
user_type = user.type
num = 0
user = User.get_user_info(g.db, user_id)
while True:
offer_major_id = data.get("offers[" + str(num) + "][majorid]")
offer_grade = data.get("offers[" + str(num) + "][grade]",
"Bachelor")
offer_university_id = data.get("offers[" + str(num) +
"][universityid]")
offer_major_name = data.get("offers[" + str(num) + "][major_name]")
offer_type = data.get("offers[" + str(num) + "][offertype]")
scholarship_type = data.get("offers[" + str(num) +
"][scholarship][type]")
scholarship_money = data.get("offers[" + str(num) +
"][scholarship][money]")
if offer_university_id is None:
break
num += 1
if num == 6:
break
id_major = None
offer_status = 1
if offer_major_name and offer_major_id is None:
major_key = Major.get_major_exit(g.db, offer_major_name)
school1_id = 7
main_major = "NotMatched"
major_user_type = 2
offer_status = 2
if major_key:
major_info = Major.get_major_info_by_mame(
g.db, offer_major_name)
if major_info:
school1_id = major_info.faculty_id
major_user_type = 1
main_major = major_info.main_major
offer_status = 1
id_major = Major.add_major(g.db,
name=offer_major_name,
main_major=main_major,
university_id=offer_university_id,
major_type=user.type,
faculty_id=school1_id,
major_user_type=major_user_type)
User.update_user_grade(g.db, user_id=user_id, grade=offer_grade)
Offer.del_same_offer(g.db,
university_id=offer_university_id,
major_id=offer_major_id,
user_id=user_id)
if id_major:
major_id = Major.get_major_info_by_id_scalar(g.db, id_major)
offer_major_id = id_major
else:
major_id = Major.get_major_info_by_id_scalar(
g.db, offer_major_id)
school1_id = 0
school2_id = 0
school3_id = 0
if major_id:
school1_id = major_id.faculty_id
school2_id = major_id.School2_ID
school3_id = major_id.School3_ID
offer_num = Offer.get_offer_num(g.db, offer_university_id,
user_type)
num_wechat = 1
if offer_num:
if offer_num < 100:
num_wechat = 1
elif 100 <= offer_num < 200:
num_wechat = 2
elif 200 <= offer_num < 300:
num_wechat = 3
wechat = set_university_offer_wechat(
University.get_university_from_id(
g.db, int(offer_university_id)).short_name, user_type,
num_wechat)
Offer.set_offer(g.db,
user_id=user_id,
university_id=offer_university_id,
major_id=offer_major_id,
school1_id=school1_id,
school2_id=school2_id,
school3_id=school3_id,
user_type=user_type,
result=1,
wechat=wechat,
offer_type=offer_type,
grade=offer_grade,
scholarship=scholarship_money,
scholarship_type=scholarship_type,
offer_status=offer_status)
un = University.get_university_from_id(g.db, offer_university_id)
if un:
state_id = un.state_id
state_offer_0 = 0
state_offer_1 = 0
state_offer = 0
for row_un in University.get_state_university(g.db, state_id):
offer_0 = Offer.get_offer_num(g.db, row_un.id, 0)
offer_1 = Offer.get_offer_num(g.db, row_un.id, 1)
offer = Offer.get_offer_num(g.db, row_un.id)
state_offer_0 += offer_0
state_offer_1 += offer_1
state_offer += offer
State.set_offer_num(g.db, state_id, state_offer, state_offer_0,
state_offer_1)
# 大学分数的计算
offer_GPA = 0
offer_GPA_0 = 0
offer_GPA_1 = 0
offer_TOEFL = 0
offer_IELTS = 0
offer_num = 0
GPA_0_num = 0
GPA_1_num = 0
offer_user_list = list()
for offer_user in Offer.get_user_id_from_university(
g.db, offer_university_id):
of_user = User.get_not_mobile_user(g.db, offer_user.user_id)
if of_user is not None and of_user.id not in offer_user_list:
if of_user.GPA is not None:
offer_GPA += of_user.GPA
if of_user.TOEFL is not None:
offer_TOEFL += of_user.TOEFL
if of_user.IELTS is not None:
offer_IELTS += of_user.IELTS
if of_user:
try:
if of_user.type == 0:
offer_GPA_0 += of_user.GPA
GPA_0_num += 1
else:
offer_GPA_1 += of_user.GPA
GPA_1_num += 1
except TypeError:
print "123"
offer_num += 1
offer_user_list.append(of_user.id)
if offer_num == 0 or GPA_0_num == 0 or GPA_1_num == 0:
offer_num == 1
GPA_0_num == 1
GPA_1_num == 1
try:
GPA = offer_GPA / float(offer_num)
except ZeroDivisionError:
GPA = 0
try:
GPA_0 = offer_GPA_0 / float(GPA_0_num)
except ZeroDivisionError:
GPA_0 = 0
try:
GPA_1 = offer_GPA_1 / float(GPA_1_num)
except ZeroDivisionError:
GPA_1 = 0
try:
TOEFL = offer_TOEFL / float(offer_num)
except ZeroDivisionError:
TOEFL = 0
try:
IELTS = offer_IELTS / float(offer_num)
except ZeroDivisionError:
IELTS = 0
GPA = float("%0.2f" % GPA)
GPA_0 = float("%0.2f" % GPA_0)
GPA_1 = float("%0.2f" % GPA_1)
TOEFL == float("%0.2f" % TOEFL)
IELTS = float("%0.2f" % IELTS)
University.set_GPA_TOEFL_IELTS(g.db, offer_university_id, GPA,
GPA_0, GPA_1, TOEFL, IELTS)
offer_list = list()
checkList = list()
for row_user in Offer.get_offer_student_info(g.db, user_id):
offer_dict = dict()
offer_dict["universityid"] = row_user.university_id
university_name = University.get_university_from_id(
g.db, row_user.university_id)
if university_name:
offer_dict["universityname"] = university_name.chiname
offer_dict["twodim"] = row_user.wechat
if row_user.university_id not in checkList:
offer_list.append(offer_dict)
checkList.append(row_user.university_id)
return jsonify(status="success",
offerlist=offer_list,
description=User.get_user_info(g.db,
user_id).description)
