# HG changeset patch # User veltr # Date 1381410235 -7200 # Node ID 85dd4590e014e89b4e673f5ba16fb9393dcea0c1 # Parent b5ce341745e3c8ca216a218a0fa4b7a16ccab33c Oops-fix diff -r b5ce341745e3 -r 85dd4590e014 src/jocondelab/views/ajax.py --- 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]