def resource_list(request, group_id, app_id=None, page_no=1):
"""
* Renders a list of all 'Resources' available within the database (except eBooks).
"""
print "inside resource_list of e-library "
is_video = request.GET.get('is_video', "")
try:
group_id = ObjectId(group_id)
except:
group_name, group_id = get_group_name_id(group_id)
print "group name and id", group_name, group_id
if app_id is None:
app_id = str(app[0].id)
# # Code for displaying user shelf
# shelves = []
# shelf_list = {}
# auth = node_collection.one({'_type': 'Author', 'name': unicode(request.user.username) })
# if auth:
# has_shelf_RT = node_collection.one({'_type': 'RelationType', 'name': u'has_shelf' })
# dbref_has_shelf = has_shelf_RT.get_dbref()
# shelf = collection_tr.Triple.find({'_type': 'GRelation', 'subject': ObjectId(auth._id), 'relation_type': dbref_has_shelf })
# shelf_list = {}
# if shelf:
# for each in shelf:
# shelf_name = node_collection.one({'_id': ObjectId(each.right_subject)})
# shelves.append(shelf_name)
# shelf_list[shelf_name.name] = []
# for ID in shelf_name.collection_set:
# shelf_item = node_collection.one({'_id': ObjectId(ID) })
# shelf_list[shelf_name.name].append(shelf_item.name)
# else:
# shelves = []
# # End of user shelf
# pandoravideoCollection = node_collection.find({'member_of':pandora_video_st._id, 'group_set': ObjectId(group_id) })
# if e_library_GST._id == ObjectId(app_id):
title = e_library_GST[0].name
file_id = GST_FILE[0].id
datavisual = []
no_of_objs_pp = 5
# filters = request.POST.get("filters", "")
# filters = json.loads(filters)
# filters = get_filter_querydict(filters)
# print "filters in E-Library : ", filters
# declaring empty (deliberately to avoid errors), query dict to be pass-on in query
query_dict = []
# query_dict = filters
selfilters = urllib.unquote(request.GET.get('selfilters', ''))
if selfilters:
print "post fetching filters", selfilters
selfilters = json.loads(selfilters)
print "post json loads :", selfilters
query_dict = get_filter_querydict(selfilters)
print "query dict", query_dict
lists = esearch.es_filters(query_dict)
print "post esearch", lists
strconcat1 = ""
for value in lists:
strconcat1 = strconcat1 + 'eval(str("' + value + '")),'
# query_dict.append({'attribute_set.educationaluse': {'$ne': 'eBooks'}})
# files = node_collection.find({
# 'member_of': ObjectId(GST_FILE._id),
# '_type': 'File',
# 'fs_file_ids': {'$ne': []},
# 'group_set': ObjectId(group_id),
# '$and': query_dict,
# '$or': [
# { 'access_policy': u"PUBLIC" },
# { '$and': [
# {'access_policy': u"PRIVATE"},
# {'created_by': request.user.id}
# ]
# }
# ]
# }).sort("last_update", -1)
q = Q('bool',
must=[
Q('terms', member_of=[GST_FILE[0].id, GST_JSMOL[0].id]),
Q('match', group_set=str(group_id)),
Q('match', access_policy='PUBLIC')
],
must_not=[Q('match', attribute_set__educationaluse='ebooks')])
allfiles1 = (Search(using=es, index=index,
doc_type=doc_type).query(q)).sort(
{"last_update": {
"order": "desc"
}})
allfiles2 = allfiles1.execute()
educationaluse_stats = {}
print "all_files:", allfiles1
q = Q('bool',
must=[
Q('terms', member_of=[GST_FILE[0].id, GST_JSMOL[0].id]),
Q('match', group_set=str(group_id)),
Q('match', access_policy='PUBLIC'),
Q('exists', field='collection_set')
])
collection_pages_cur = (Search(using=es, index=index,
doc_type=doc_type).query(q)).sort(
{"last_update": {
"order": "desc"
}})
if int(page_no) == 1:
collection_pages_cur = collection_pages_cur[0:5]
else:
temp = (int(page_no) - 1) * 5
collection_pages_cur = collection_pages_cur[temp:temp + 5]
paginator = Paginator(collection_pages_cur, 5)
coll_page_count = collection_pages_cur.count(
) if collection_pages_cur else 0
# collection_pages_cur = node_collection.find({
# 'member_of': {'$in': [GST_FILE[0].id, GST_PAGE[0].id ]},
# 'group_set': {'$all': [ObjectId(group_id)]},
# # '$and': query_dict,
# # '$or': [
# 'access_policy': u"PUBLIC",
# # {'$and': [
# # {'access_policy': u"PRIVATE"},
# # # {'created_by': request.user.id}
# # ]
# # }
# # ],
# 'collection_set': {'$exists': "true", '$not': {'$size': 0} }
# }).sort("last_update", -1)
q = Q('bool',
must=[
Q('terms',
member_of=[GST_FILE[0].id, GST_JSMOL[0].id, GST_PAGE[0].id]),
Q('match', group_set=str(group_id)),
Q('match', access_policy='PUBLIC'),
Q('match_phrase', if_file__mime_type='image')
])
allimages1 = (Search(using=es, index=index,
doc_type=doc_type).query(q)).sort(
{"last_update": {
"order": "desc"
}})
allimages2 = allimages1.execute()
q = Q('bool',
must=[
Q('terms',
member_of=[GST_FILE[0].id, GST_JSMOL[0].id, GST_PAGE[0].id]),
Q('match', group_set=str(group_id)),
Q('match', access_policy='PUBLIC'),
Q('match_phrase', if_file__mime_type='video')
])
allvideos1 = (Search(using=es, index=index,
doc_type=doc_type).query(q)).sort(
{"last_update": {
"order": "desc"
}})
allvideos2 = allvideos1.execute()
q = Q('bool',
must=[
Q('terms',
member_of=[GST_FILE[0].id, GST_JSMOL[0].id, GST_PAGE[0].id]),
Q('match', group_set=str(group_id)),
Q('match', access_policy='PUBLIC'),
Q('match_phrase', if_file__mime_type='audio')
])
allaudios1 = (Search(using=es, index=index,
doc_type=doc_type).query(q)).sort(
{"last_update": {
"order": "desc"
}})
allaudios2 = allaudios1.execute()
q = Q('bool',
must=[
Q('terms',
member_of=[GST_FILE[0].id, GST_JSMOL[0].id, GST_PAGE[0].id]),
Q('match', access_policy='PUBLIC'),
Q('match_phrase', name='Handbook'),
Q('match_phrase', if_file__mime_type='pdf')
])
alldocs1 = (Search(using=es, index=index,
doc_type=doc_type).query(q)).sort(
{"last_update": {
"order": "desc"
}})
alldocs2 = alldocs1.execute()
q = Q('bool',
must=[
Q('match', member_of=gst_module[0].id),
Q('match', status='PUBLISHED')
])
all_modules = (Search(using=es, index=index,
doc_type=doc_type).query(q)).sort(
{"last_update": {
"order": "desc"
}})
all_modules2 = all_modules.execute()
files_new = allfiles1[0:24]
if int(page_no) == 1:
files_new = allfiles1[0:24]
else:
temp = (int(page_no) - 1) * 24
files_new = allfiles1[temp:temp + 24]
if files_new:
eu_list = []
if set(eu_list):
if len(set(eu_list)) > 1:
educationaluse_stats = dict(
(x, eu_list.count(x)) for x in set(eu_list))
elif len(set(eu_list)) == 1:
educationaluse_stats = {eu_list[0]: eu_list.count(eu_list[0])}
educationaluse_stats["all"] = files.count()
paginator = Paginator(files_new, 24)
#page_no = request.GET.get('page_no')
try:
result_pages = paginator.page(page_no)
except PageNotAnInteger:
result_pages = paginator.page(1)
except EmptyPage:
result_pages = paginator.page(paginator.num_pages)
try:
results = paginator.page(page_no)
except PageNotAnInteger:
results = paginator.page(1)
except EmptyPage:
results = paginator.page(paginator.num_pages)
coll_page_count = collection_pages_cur.count(
) if collection_pages_cur else 0
print "coll_page_count", coll_page_count
# collection_pages = paginator.Paginator(collection_pages_cur, page_no, no_of_objs_pp)
print "result_pages:", result_pages
datavisual.append({"name": "Doc", "count": alldocs1.count()})
datavisual.append({
"name": "Page",
"count": educationaluse_stats.get("Pages", 0)
})
datavisual.append({"name": "Image", "count": allimages1.count()})
datavisual.append({"name": "Video", "count": allvideos1.count()})
datavisual.append({
"name": "Interactives",
"count": educationaluse_stats.get("Interactives", 0)
})
datavisual.append({"name": "Audios", "count": allaudios1.count()})
datavisual.append({
"name": "eBooks",
"count": educationaluse_stats.get("eBooks", 0)
})
if collection_pages_cur:
datavisual.append({"name": "Collections", "count": coll_page_count})
datavisual = json.dumps(datavisual)
print "educational stats:", educationaluse_stats
return render_to_response(
"ndf/resource_list.html",
{
'title': title,
'app': e_library_GST[0],
'appId': app[0].id,
"app_gst": app[0],
# 'already_uploaded': already_uploaded,'shelf_list': shelf_list,'shelves': shelves,
'files': files_new,
"detail_urlname": "file_detail",
'ebook_pages': educationaluse_stats.get("eBooks", 0),
# 'page_count': pageCollection.count(),
# 'page_nodes':pageCollection
'file_pages': result_pages,
'image_pages': allimages1.count(),
'interactive_pages': educationaluse_stats.get("Interactives", 0),
'educationaluse_stats': json.dumps(educationaluse_stats),
'doc_pages': alldocs1.count(),
'video_pages': allvideos1.count(),
'audio_pages': allaudios1.count(),
'collection_pages': results,
'collection': collection_pages_cur,
'collection_count': coll_page_count,
'groupid': group_id,
'group_id': group_id,
"datavisual": datavisual,
},
context_instance=RequestContext(request))
def elib_paged_file_objs(request, group_id, filetype, page_no):
'''
Method to implement pagination in File and E-Library app.
'''
if request.is_ajax() and request.method == "POST":
group_name, group_id = get_group_name_id(group_id)
no_of_objs_pp = 5
result_pages = None
filetype = filetype.lower()
filters = request.POST.get("filters", "")
filters = json.loads(filters)
filters = get_filter_querydict(filters)
query_dict = filters
selfilters = urllib.unquote(request.GET.get('selfilters', ''))
if selfilters:
selfilters = json.loads(selfilters)
query_dict = get_filter_querydict(selfilters)
# query_dict.append("Q('match',"+t+"=dict(query='"+value+"',type='phrase'))")
detail_urlname = "file_detail"
print "filetype:", filetype
if filetype != 'Module':
if filetype == 'document':
print "in Document elif"
q = Q('bool',
must=[
Q('terms',
member_of=[
GST_FILE[0].id, GST_JSMOL[0].id, GST_PAGE[0].id
]),
Q('match', access_policy='PUBLIC'),
Q('match_phrase', if_file__mime_type='pdf'),
Q('match_phrase', name='Handbook')
])
else:
q = Q('bool',
must=[
Q('terms',
member_of=[
GST_FILE[0].id, GST_JSMOL[0].id, GST_PAGE[0].id
]),
Q('match', group_set=str(group_id)),
Q('match', access_policy='PUBLIC'),
Q('match_phrase', if_file__mime_type=filetype)
])
else:
q = Q('bool',
must=[
Q('match', member_of=gst_module[0].id),
Q('match', status='PUBLISHED')
])
allfiletypes1 = (Search(using=es, index=index,
doc_type=doc_type).query(q)).sort(
{"last_update": {
"order": "desc"
}})
allfiletypes2 = allfiletypes1.execute()
educationaluse_stats = {}
if int(page_no) == 1:
files_new = allfiletypes1[0:5]
else:
temp = (int(page_no) - 1) * 5
files_new = allfiletypes1[temp:temp + 5]
# print "files_count: ", files.count()
# if filetype == "Pages":
# filter_result = "True" if (result_cur.count() > 0) else "False"
# else:
if files_new: # and not result_pages:
# print "=======", educationaluse_stats
eu_list = [] # count
collection_set_count = 0
# for each in files_new:
# eu_list += [i.get("educationaluse") for i in each.attribute_set if i.has_key("educationaluse")]
# collection_set_count += 1 if each.collection_set else 0
# files.rewind()
if set(eu_list):
if len(set(eu_list)) > 1:
educationaluse_stats = dict(
(x, eu_list.count(x)) for x in set(eu_list))
elif len(set(eu_list)) == 1:
educationaluse_stats = {
eu_list[0]: eu_list.count(eu_list[0])
}
educationaluse_stats["all"] = files.count()
educationaluse_stats["Collections"] = collection_set_count
paginator = Paginator(files_new, 5)
#page_no = request.GET.get('page_no')
try:
result_pages = paginator.page(page_no)
except PageNotAnInteger:
result_pages = paginator.page(1)
except EmptyPage:
result_pages = paginator.page(paginator.num_pages)
filter_result = "True" if (allfiletypes1.count() > 0) else "False"
if filetype == "Collections":
detail_urlname = "page_details"
q = Q('bool',
must=[
Q('terms', member_of=[GST_FILE[0].id, GST_JSMOL[0].id]),
Q('match', group_set=str(group_id)),
Q('match', access_policy='PUBLIC'),
Q('exists', field='collection_set')
])
collection_pages_cur = (Search(using=es,
index=index,
doc_type=doc_type).query(q)).sort({
"last_update": {
"order": "desc"
}
})
# result_cur = node_collection.find({
# 'member_of': {'$in': [GST_FILE._id, GST_PAGE._id]},
# 'group_set': {'$all': [ObjectId(group_id)]},
# '$and': query_dict,
# '$or': [
# {'access_policy': u"PUBLIC"},
# {'$and': [
# {'access_policy': u"PRIVATE"},
# {'created_by': request.user.id}
# ]
# }
# ],
# 'collection_set': {'$exists': "true", '$not': {'$size': 0} }
# }).sort("last_update", -1)
# print "=====================", result_cur.count()
# result_paginated_cur = result_cur
result_pages = paginator.Paginator(collection_pages_cur, page_no,
no_of_objs_pp)
# if filetype == "all":
# if files:
# result_paginated_cur = files
# result_pages = paginator.Paginator(result_paginated_cur, page_no, no_of_objs_pp)
# # else:
# elif filetype == "Documents":
# d_Collection = node_collection.find({'_type': "GAttribute", 'attribute_type': gattr._id,"subject": {'$in': coll} ,"object_value": "Documents"}).sort("last_update", -1)
# doc = []
# for e in d_Collection:
# doc.append(e.subject)
# result_paginated_cur = node_collection.find({ '$or':[{'_id': {'$in': doc}},
# {'member_of': {'$nin': [ObjectId(GST_IMAGE._id), ObjectId(GST_VIDEO._id),ObjectId(pandora_video_st._id)]},
# '_type': 'File', 'group_set': {'$all': [ObjectId(group_id)]},
# # 'mime_type': {'$not': re.compile("^audio.*")},
# '$or': [
# {'access_policy': u"PUBLIC"},
# {'$and': [{'access_policy': u"PRIVATE"}, {'created_by': request.user.id}]}
# ]
# }]
# }).sort("last_update", -1)
# result_pages = paginator.Paginator(result_paginated_cur, page_no, no_of_objs_pp)
# print "educationaluse_stats: ", educationaluse_stats
return render_to_response(
"ndf/file_list_tab.html", {
"filter_result": filter_result,
"group_id": group_id,
"group_name_tag": group_id,
"groupid": group_id,
'title': "E-Library",
"educationaluse_stats": json.dumps(educationaluse_stats),
"resource_type": allfiletypes1,
"detail_urlname": detail_urlname,
"filetype": filetype,
"res_type_name": "",
"page_info": result_pages
},
context_instance=RequestContext(request))
