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"})