def addCourse(request):
try:
if request.method == "POST":
data = json.loads(request.body.decode('utf-8'))
course_id = int(data['cid'])
token = data['headers']['token']
# 解析token
res = toto.openToken(token)
#
if res:
result = user_models.AddCourse.objects.filter(course_id=course_id, user_id=res['user_id']).values()
addnum = models.Course.objects.filter(id=course_id).values('useraddcount')[0]['useraddcount']
if result:
user_models.AddCourse.objects.filter(course_id=course_id, user_id=res['user_id']).delete()
res = addnum - 1
models.Course.objects.filter(id=course_id).update(useraddcount =res)
return JsonResponse({"code": "410"})
else:
addcourse = {
'course_id': course_id,
'user_id': res['user_id']
}
user_models.AddCourse.objects.create(**addcourse)
# addnum = models.Course.objects.filter(id=course_id).values('useraddcount')[0]['useraddcount']
res = addnum + 1
models.Course.objects.filter(id=course_id).update(useraddcount=res)
return JsonResponse({"code": "210"})
except Exception as ex:
print(ex)
return JsonResponse({"code": "404"})
def replyComment(request):
try:
# 需要 评论id 评论内容 token
if request.method == "POST":
data = json.loads(request.body.decode('utf-8'))
content = data['content']
comment_id = int(data['comment_id'])
token = data['headers']['token']
res = toto.openToken(token)
# result=models.AddCourse.objects.filter(course_id=course_id,user_id=res['user_id']).values()
if res:
addcomment = {
'comment_id': comment_id,
'user_id': res['user_id'],
'content': content,
'time':datetime.utcnow()
}
print(addcomment)
models.CourseCommentReply.objects.create(**addcomment)
# print(res['user_id'])
return JsonResponse({"code": "210"})
else:
return JsonResponse({"code": "没登陆"})
except Exception as ex:
print(ex)
return JsonResponse({"code": "404"})
def UpUser(request):
try:
if request.method == "POST":
r = json.loads(request.body)
token = r['headers']['token']
res = toto.openToken(token)
if res:
user_id = res['user_id']
ss = {
"name": r['name'],
"height": r['height'],
"width": r['width'],
"birth": r['birth'],
"sex_id": r['sex'],
"user_id": user_id,
"qinming": r['qianming']
}
# 先判断用户有没有基本信息，有就替换，没有用就直接添加
res = models.UserInfo.objects.filter(user_id=user_id).values()
if res:
models.UserInfo.objects.filter(user_id=user_id).update(
**ss)
else:
models.UserInfo.objects.create(**ss)
else:
return JsonResponse({"code": "411"})
return JsonResponse({"code": "201"})
except Exception as ex:
print('this is UpUser')
print(ex)
return JsonResponse({"code": "500"})
def delCourseComment(request):
try:
# 需要 评论id token
if request.method == "POST":
data = json.loads(request.body.decode('utf-8'))
# content = data['content']
comment_id = int(data['commentid'])
token = data['headers']['token']
res = toto.openToken(token)
if res:
models.CourseComment.objects.filter(id=comment_id).delete()
return JsonResponse({"code": "210"})
else:
return JsonResponse({"code": "没登陆"})
except Exception as ex:
print(ex)
return JsonResponse({"code": "404"})
def delCourseReply(request):
try:
# 需要 回复id token
if request.method == "POST":
data = json.loads(request.body.decode('utf-8'))
# content = data['content']
replyid = int(data['replyid'])
token = data['headers']['token']
res = toto.openToken(token)
# result=models.AddCourse.objects.filter(course_id=course_id,user_id=res['user_id']).values()
if res:
models.CourseCommentReply.objects.filter(id=replyid).delete()
# print(res['user_id'])
return JsonResponse({"code": "210"})
else:
return JsonResponse({"code": "没登陆"})
except Exception as ex:
print(ex)
return JsonResponse({"code": "404"})
def likeComment(request):
try:
# if request.method=="POST":
data = json.loads(request.body.decode('utf-8'))
commentid = int(data['commentid'])
data = data['headers']
token = data['token']
res = toto.openToken(token)
if res:
result = course_models.CourseCommentLike.objects.filter(
comment_id=commentid, user_id=res['user_id']).values()
if result:
course_models.CourseCommentLike.objects.filter(
comment_id=commentid, user_id=res['user_id']).delete()
likenum = course_models.CourseComment.objects.filter(
id=commentid).values('likes')[0]['likes']
res = likenum - 1
course_models.CourseComment.objects.filter(
id=commentid).update(likes=res)
return JsonResponse({"code": "410"})
else:
addcomment = {
'comment_id': commentid,
'user_id': res['user_id'],
}
course_models.CourseCommentLike.objects.create(**addcomment)
likenum = course_models.CourseComment.objects.filter(
id=commentid).values('likes')[0]['likes']
res = likenum + 1
course_models.CourseComment.objects.filter(
id=commentid).update(likes=res)
return JsonResponse({"code": "210"})
else:
return JsonResponse({"code": "411"})
except Exception as ex:
print('this is likeComment')
print(ex)
return JsonResponse({"code": "500"})
def getCourseInfoById(request):
# 获取类型为tid的全部对象
try:
data = json.loads(request.body.decode('utf-8'))
print(data)
cid = int(data['cid'])
courses = models.Course.objects.filter(id=cid)
course_list = []
for course in courses:
course_dict = model_to_dict(course)
course_dict["picture"] = courses.values('picture__url')[0]['picture__url']
course_dict["level"] = courses.values('level__level')[0]['level__level']
course_dict["picture"] = courses.values('picture__url')[0]['picture__url']
course_dict["machine"] = courses.values('machine__name')[0]['machine__name']
course_dict['type_name'] = courses.values('type__type_name')[0]['type__type_name']
course_dict["add_flag"] = False
if data['headers']['token']:
token = data['headers']['token']
res = toto.openToken(token)
if res:
result = AddCourse.objects.filter(course_id=cid, user_id=res['user_id'])
if result:
course_dict["add_flag"] = True
course_dict["useradd"] = AddCourse.objects.filter(course_id=cid).count()
parts = models.CourseTrainPart.objects.filter(course_id=cid).values('bodypart__bodypart')
bodys = []
for part in parts:
bodys.append(part['bodypart__bodypart'])
course_dict["trainbody"] = bodys
course_list.append(course_dict)
# print(course_list)
return HttpResponse(json.dumps(course_list, ensure_ascii=False))
except Exception as ex:
print(ex)
def getHotCourseComment(request):
try:
if request.method == "POST":
# 获取课程类型全部queryset对象
data = json.loads(request.body.decode('utf-8'))
cid = data['cid']
token = data['headers']['token']
res = toto.openToken(token)
# 解析token
# 判断是否登录
# models.CourseCommentLike.objects.filter('comment_id').count()
comments = models.CourseComment.objects.order_by('-likes').filter(course_id=cid)
# 新建list对数据封装
comment_list = []
# 遍历每个对象
for c in comments:
# 将每个对象转换为字典类型
c_dict = model_to_dict(c)
c_dict['id'] = models.CourseComment.objects.filter(id=c.id).values('id')[0]['id']
c_dict['time'] = models.CourseComment.objects.filter(id=c.id).values('time').values('time')[0][
'time'].strftime('%Y-%m-%d %H:%I:%S')
c_dict['like'] = models.CourseCommentLike.objects.filter(comment_id=c.id).count()
c_dict['replynum'] = models.CourseCommentReply.objects.filter(comment_id=c.id).count()
c_dict['deletecomment_flag'] = False
c_dict['like_flag'] = False
if res:
flag = models.CourseComment.objects.filter(id=c.id, user_id=res['user_id']).count()
flag1 = models.CourseCommentLike.objects.filter(comment_id=c.id, user_id=res['user_id']).count()
if flag1:
c_dict['like_flag'] = True
if flag:
c_dict['deletecomment_flag'] = True
c_dict['username'] = UserInfo.objects.filter(user_id=c.user_id).values('name')[0]['name']
c_dict['icon'] = UserInfo.objects.filter(user_id=c.user_id).values('icon__icon_url')[0][
'icon__icon_url']
reply_list = []
reply = models.CourseCommentReply.objects.order_by('-time').filter(comment_id=c.id)
for r in reply:
r_dict = model_to_dict(r)
r_dict['time'] = models.CourseCommentReply.objects.filter(id=r.id).values('time').values('time')[0][
'time'].strftime('%Y-%m-%d %H:%I:%S')
r_dict['username'] = UserInfo.objects.filter(user_id=r.user_id).values('name')[0]['name']
r_dict['icon'] = UserInfo.objects.filter(user_id=r.user_id).values('icon__icon_url')[0][
'icon__icon_url']
r_dict['content'] = models.CourseCommentReply.objects.filter(id=r.id).values('content')[0][
'content']
c_dict['reply_flag'] = False
r_dict['deletereply_flag'] = False
if res:
flag = models.CourseCommentReply.objects.filter(comment_id=c.id, user_id=res['user_id']).count()
flag1 = models.CourseCommentReply.objects.filter(id=r.id, comment_id=r.comment_id,
user_id=res['user_id']).count()
if flag:
c_dict['reply_flag'] = True
if flag1:
r_dict['deletereply_flag'] = True
reply_list.append(r_dict)
c_dict['commnetreply'] = reply_list
comment_list.append(c_dict)
return HttpResponse(json.dumps(comment_list[0:3], ensure_ascii=False))
except Exception as ex:
print(ex)
return JsonResponse({"code": "404"})
