def get_qna_answers(request): qnaquestion = get_or_none(QnAQuestion,id=int(request.GET.get("qid",0))) limit = request.GET.get("limit",None) if limit : limit = limit.split(":") answers = QnAAnswer.objects.filter(question=qnaquestion).order_by('is_selected','-id') if limit : questions = answers[limit[0]:limit[1]] arr = [] for answer in answers : arr.append({ 'id':answer.id ,'user_src':answer.user.profile.get_src() ,'username':answer.user.first_name ,'user_id':answer.user.id ,'src':answer.get_srcs() ,'contents':answer.contents ,'is_selected':int(answer.is_selected) ,'date_created':unixtime(answer.date_created) }) return HttpResponse(json.dumps(arr, default=date_handler), content_type="application/json")
def get_qna_questions(request): user = get_or_none(User,id=int(request.GET.get("uid",0))) mode_qna = int(request.GET.get("mode_qna",0)) limit = request.GET.get("limit",None) if limit : limit = limit.split(":") questions = QnAQuestion.objects.filter(user=user).order_by('-id') if mode_qna == 1 : arr_groups = [] unionuser = UnionUser.objects.filter(user=user) groups = Group.objects.filter(unionuser=unionuser) for group in groups: arr_groups.append(group) groupusers = GroupUser.objects.filter(unionuser=unionuser) for groupuser in groupusers: arr_groups.append(groupuser.group) arr_groups = list(set(arr_groups)) arr_users = [] for group in arr_groups: arr_users.append(group.unionuser.user) groupusers = GroupUser.objects.filter(group__in=arr_groups) for groupuser in groupusers: arr_users.append(groupuser.unionuser.user) arr_users = list(set(arr_users)) questions = QnAQuestion.objects.filter(user__in=arr_users).order_by('-id') elif mode_qna == 2 : questions = QnAQuestion.objects.all().order_by('-id') if limit : questions = questions[limit[0]:limit[1]] arr = [] for question in questions : arr.append({ 'id':question.id ,'user_src':question.user.profile.get_src() ,'username':question.user.first_name ,'user_id':question.user.id ,'unit1':question.unit.unit.title ,'unit2':question.unit.title ,'src':question.get_srcs() ,'contents':question.contents ,'date_created':unixtime(question.date_created) }) return HttpResponse(json.dumps(arr, default=date_handler), content_type="application/json")