def cinematics(request): from statistics.reports import Report r = Report() data = r.all() try: year,month = strftime("%Y-%m", gmtime()).split('-') except: pass stations_list = Station.objects.all() for s in stations_list: p = data[s.name] evs = [] evs1 = [] evs2 = [] evs3 = [] for c in Choice.objects.all(): evs1.append(len(Evaluation.objects.filter( date__year=year, date__month=month, choice=c, station=s )) ) evs2.append(len(Evaluation.objects.filter( date__year=year, choice=c, station=s )) ) evs3.append(len(Evaluation.objects.filter( choice=c, station=s )) ) evs.append(evs1) evs.append(evs2) evs.append(evs3) data[s.name] = ([s.latitude,s.longitude],p,evs) gKey = settings.EASY_MAPS_GOOGLE_KEY return render_to_response('cinematics.html',locals())