--- a/src/jocondelab/views/ajax.py Thu Oct 10 14:58:25 2013 +0200
+++ b/src/jocondelab/views/ajax.py Thu Oct 10 15:03:55 2013 +0200
@@ -54,7 +54,7 @@
"dbpedia_uri": y["term__dbpedia_uri"]
} for y in qs]
- return HttpResponse(content=json.dumps(results), mimetype='application/json',term__nb_illustrated_notice__gt=0)
+ return HttpResponse(content=json.dumps(results), mimetype='application/json')
def geo_coords(request):
@@ -65,7 +65,7 @@
max_lng = request.GET.get('max_lng', None)
count = request.GET.get('count', 20)
- qs = DbpediaGeo.objects.filter(term__dbpedia_fields__language_code=lang)
+ qs = DbpediaGeo.objects.filter(term__dbpedia_fields__language_code=lang,term__nb_illustrated_notice__gt=0)
if min_lat:
qs = qs.filter(latitude__gt=min_lat)
@@ -97,7 +97,7 @@
q = request.GET.get('term', None)
count = request.GET.get('count', 20)
- qs = DbpediaGeo.objects.filter(term__dbpedia_fields__language_code=lang, term__dbpedia_fields__label__icontains=q)
+ qs = DbpediaGeo.objects.filter(term__dbpedia_fields__language_code=lang, term__dbpedia_fields__label__icontains=q, term__nb_illustrated_notice__gt=0)
qs = qs.values('latitude','longitude','term__dbpedia_fields__label','term__dbpedia_uri')
qs = qs.annotate(sum_notices=Sum('term__nb_illustrated_notice')).order_by('-sum_notices')[:count]