def searchUser():
# check login status
session_id = request.cookies.get('SESSION_ID', '')
user = databaseq.get_user_by_session_id(session_id)
if not user:
return {'code': 'no user'}
current_uid = user[0]
# keyword = request.form['searchContent']
data_recv = request.get_data(as_text=True)
data_recv_json = json.loads(data_recv)
keyword = data_recv_json['Searchkeyword']
users = databaseq.search_user(keyword)
databaseq.get_user_by_name("asd")
data = {'code': 'ok'}
user_names = {}
user_isfriend = {}
frontend_action = {}
index = 0
for idx, user in enumerate(users):
user_name = user[1]
if user[0] != current_uid:
user_names[index] = user_name
isfriend = databaseq.check_friend(current_uid, user[0])
if isfriend:
user_isfriend[index] = "已关注"
frontend_action[index] = "/NoFocusFriend"
else:
user_isfriend[index] = "未关注"
frontend_action[index] = "/FocusFriend"
index = index + 1
data['data'] = user_names
data['isfriend'] = user_isfriend
data['action'] = frontend_action
return json.dumps(data)
def GoToExercise():
session_id = request.cookies.get('SESSION_ID', '')
user = databaseq.get_user_by_session_id(session_id)
if not user:
return render_template("sign.html", error='please login')
return render_template("map.html")
def backToLearn():
session_id = request.cookies.get('SESSION_ID', '')
user = databaseq.get_user_by_session_id(session_id)
if not user:
return render_template("sign.html", error='please login')
#暂时返回home，日后修改
resp = redirect(url_for('home'))
return resp
def home():
# check login status
session_id = request.cookies.get('SESSION_ID', '')
user = databaseq.get_user_by_session_id(session_id)
if not user:
return render_template("sign.html", error='please login')
current_hid = user[4]
helper = databaseq.get_helper(current_hid)
model_id = helper[1]
costume_id = helper[2]
return render_template("home.html", mode=model_id, cos=costume_id, show_button = "")
def GetRelation():
session_id = request.cookies.get('SESSION_ID', '')
user = databaseq.get_user_by_session_id(session_id)
if not user:
return {'code': 'no user'}
data = {'code': 'ok'}
current_uid = user[0]
current_hid = user[4]
current_relate = databaseq.get_user_helper_relation(current_uid,current_hid)
data['data'] = current_relate
return json.dumps(data)
def RemoveFromToDo():
session_id = request.cookies.get('SESSION_ID', '')
user = databaseq.get_user_by_session_id(session_id)
if not user:
return render_template("sign.html", error='please login')
data = {'code': 'ok'}
current_uid = user[0]
data_recv = request.get_data(as_text=True)
data_recv_json = json.loads(data_recv)
event = data_recv_json['event']
databaseq.del_todo(current_uid, event)
return json.dumps(data)
def RemoveFromCollect():
session_id = request.cookies.get('SESSION_ID', '')
user = databaseq.get_user_by_session_id(session_id)
if not user:
return {'code': 'no user'}
data = {'code': 'ok'}
current_uid = user[0]
data_recv = request.get_data(as_text=True)
data_recv_json = json.loads(data_recv)
word = data_recv_json['word']
databaseq.del_collect(current_uid, word)
return json.dumps(data)
def GetAllCollectWords():
session_id = request.cookies.get('SESSION_ID', '')
user = databaseq.get_user_by_session_id(session_id)
if not user:
return {'code': 'no user'}
data = {'code': 'ok'}
current_uid = user[0]
collect_words = databaseq.get_collect(current_uid)
collectlist = {}
for idx, word in enumerate(collect_words):
collectlist[idx] = word[0]
data['data'] = collectlist
return json.dumps(data)
def NoFocusFriend():
session_id = request.cookies.get('SESSION_ID', '')
user = databaseq.get_user_by_session_id(session_id)
if not user:
return render_template("sign.html", error='please login')
current_uid = user[0]
fname = request.form['uid']
friend = databaseq.get_user_by_name(fname)
fid = friend[0]
databaseq.del_friend(current_uid, fid)
resp = redirect(url_for('friendlist'))
return resp
def ShowToDoList():
session_id = request.cookies.get('SESSION_ID', '')
user = databaseq.get_user_by_session_id(session_id)
if not user:
return render_template("sign.html", error='please login')
current_uid = user[0]
data = {'code': 'ok'}
user_todos = databaseq.get_user_todo(current_uid)
todolist = {}
for idx, todo in enumerate(user_todos):
todolist[idx] = todo[0]
data['data'] = todolist
return json.dumps(data)
def recordSchedule():
# check login status
session_id = request.cookies.get('SESSION_ID', '')
user = databaseq.get_user_by_session_id(session_id)
if not user:
return render_template("sign.html", error='please login')
uid = user[0]
sid = request.form['subjectID']
chapter = request.form['chapter']
databaseq.update_progress(uid, sid, chapter)
resp = redirect(url_for('home'))
return resp
def Totalchapter():
# check login status
session_id = request.cookies.get('SESSION_ID', '')
user = databaseq.get_user_by_session_id(session_id)
if not user:
return {'code': 'no user'}
data_recv = request.get_data(as_text=True)
data_recv_json = json.loads(data_recv)
sid = data_recv_json['subjectID']
subject = databaseq.get_subject(sid)
chapter_no = subject[2]
data = {'code': 'ok', "data": chapter_no}
return json.dumps(data)
def friendlist():
# check login status
session_id = request.cookies.get('SESSION_ID', '')
user = databaseq.get_user_by_session_id(session_id)
if not user:
return render_template("sign.html", error='please login')
uid = user[0]
friends_id = databaseq.get_all_friends(uid)
friends_name = []
for friend_id in friends_id:
friend = databaseq.get_user_by_uid(friend_id)
friend_name = friend[1]
friends_name.append(friend_name)
return render_template("friendlistK.html", uid=uid, Friends=friends_name)
def GoTolearn():
# check login status
session_id = request.cookies.get('SESSION_ID', '')
user = databaseq.get_user_by_session_id(session_id)
if not user:
return render_template("sign.html", error='please login')
uid = user[0]
#sid = request.form['subjectID'] 为测试暂时先用1：english代替
sid = 1
progress = databaseq.get_progress(uid, sid)
alert_str = ""
if progress != 0:
alert_str = "记录到上次学习至" + progress + "章节, 是否继续学习？"
return render_template('learn.html', chapter=progress, alertinfo=alert_str)
def get_all_friends():
# check login status
session_id = request.cookies.get('SESSION_ID', '')
user = databaseq.get_user_by_session_id(session_id)
if not user:
return {'code': 'no user'}
uid = user[0]
friends_id = databaseq.get_all_friends(uid)
data = {'code': 'ok'}
friends_name = {}
for idx, friend_id in enumerate(friends_id):
friend = databaseq.get_user_by_uid(friend_id)
friend_name = friend[1]
friends_name[idx] = friend_name
data['data'] = friends_name
return json.dumps(data)
def GoForFriend():
# check login status
session_id = request.cookies.get('SESSION_ID', '')
user = databaseq.get_user_by_session_id(session_id)
if not user:
return render_template("sign.html", error='please login')
fname = request.form['fname']
print(fname)
user = databaseq.get_user_by_name(fname)
current_hid = user[4]
helper = databaseq.get_helper(current_hid)
model_id = helper[1]
costume_id = helper[2]
return render_template("home.html",
mode=model_id,
cos=costume_id,
show_button="display:none;")
def learn():
# check login status
session_id = request.cookies.get('SESSION_ID', '')
user = databaseq.get_user_by_session_id(session_id)
if not user:
return {'code': 'no user'}
#sid = request.form['subjectID'] 为测试暂时用1替代
sid = 1
current_uid = user[0]
data_recv = request.get_data(as_text=True)
data_recv_json = json.loads(data_recv)
chapter = data_recv_json['chapter']
subject = databaseq.get_subject(sid)
data = {'code': 'ok'}
if chapter < 0 or chapter > subject[2] - 1:
return {'code': 'illegal parameter'}
stored_path = subject[3]
filename = "table" + str(chapter) + ".csv"
path = os.path.join(stored_path, filename)
words = {}
chineses = {}
iscollects = {}
with open(path) as csvfile:
spamreader = csv.reader(csvfile)
for idx, row in enumerate(spamreader, 1):
words[idx] = row[0]
chineses[idx] = row[1]
iscollect = databaseq.check_collect(current_uid, row[0])
if iscollect:
iscollects[idx] = 1
else:
iscollects[idx] = 0
if idx > 11:
break
data['word'] = words
data['chinese'] = chineses
data['iscollect'] = iscollects
print(data)
return json.dumps(data)
