def json_get_ctr(**kwargs):
try:
fm = convert.to_datetime(request.args.get('from') + ':00')
to = convert.to_datetime(request.args.get('to') + ':00')
if fm > to: raise ValueError
except:
return u'Неверно указан интервал', 400
try:
group = request.args.get('group')
if group not in ('hour', 'day', 'month', 'year'): raise ValueError
except:
return u'Неверно указана группировка', 400
if group == 'hour':
replacer = times.begin_of_hour
formatter = lambda d: d.strftime('%d.%m.%y') if d.hour == 0 else d.strftime('%H:00')
freq = times.HOURLY
elif group == 'day':
replacer = times.begin_of_day
formatter = lambda d: d.strftime('%d.%m.%y')
freq = times.DAILY
elif group == 'month':
replacer = times.begin_of_month
formatter = lambda d: d.strftime('%m.%Y')
freq = times.MONTHLY
elif group == 'year':
replacer = times.begin_of_year
formatter = lambda d: d.strftime('%Y')
freq = times.YEARLY
#fm = replacer(fm)
#to = replacer(to)
stats = actions.stats.get_stats_ctr(fm, to, group, **kwargs)
keys = times.datetime_range(freq, dtstart=replacer(fm), until=replacer(to))
values = dict([(key, (0, 0, 0.0)) for key in keys]) # if len(stats) != len (keys) else dict()
for stat in stats:
values[replacer(stat.time)] = (stat.shows, stat.actions, round(stat.ctr, 4))
result = [dict(time=formatter(key), shows=value[0], clicks=value[1], ctr=value[2]) \
for key, value in sorted(values.items(), key=lambda item: item[0])]
return jsonify(values=result)
def json_get_audience(**kwargs):
try:
fm = convert.to_datetime(request.args.get('from') + ':00')
to = convert.to_datetime(request.args.get('to') + ':00')
if fm > to: raise ValueError
except:
return u'Неверно указан интервал', 400
stats_gender = actions.stats.get_stats_audience_by_genders(fm=fm, to=to, **kwargs)
stats_city = actions.stats.get_stats_audience_by_cities(fm=fm, to=to, **kwargs)
stats_year = actions.stats.get_stats_audience_by_years(fm=fm, to=to, **kwargs)
genders = { True : u'мужчины', False : u'женщины', None : u'не указан' }
result_gender = [dict(gender=genders[s.gender], count=s.performers) for s in stats_gender]
top = 8
others = dict(city=u'другие', count=0)
result_city = []
for s in stats_city:
if s.city is None:
result_city.append(dict(city=u'не указан', count=s.performers))
elif len(result_city) < top:
result_city.append(dict(city=s.city, count=s.performers))
else:
others['count'] += s.performers
if others['count'] > 0:
result_city.append(others)
this_year = datetime.now().year
all_count = 0
none_count = 0
result_year = []
for s in stats_year:
all_count += s.performers
if s.year is not None:
result_year.append(dict(year=this_year-s.year, count=s.performers))
else:
none_count = s.performers
year_percent = round(float(all_count - none_count) / all_count * 100, 2) if all_count > 0 else 0
result = dict(genders=result_gender, cities=result_city, years=result_year, year_percent=year_percent)
return jsonify(result)
