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