def get_map_mons(self):
ne_lat, ne_lon, sw_lat, sw_lon, o_ne_lat, o_ne_lon, o_sw_lat, o_sw_lon = get_bound_params(
request)
timestamp = request.args.get("timestamp", None)
data = self._db.get_mons_in_rectangle(ne_lat=ne_lat,
ne_lon=ne_lon,
sw_lat=sw_lat,
sw_lon=sw_lon,
o_ne_lat=o_ne_lat,
o_ne_lon=o_ne_lon,
o_sw_lat=o_sw_lat,
o_sw_lon=o_sw_lon,
timestamp=timestamp)
mons_raw = {}
for index, _ in enumerate(data):
try:
mon_id = data[index]["mon_id"]
if str(mon_id) in mons_raw:
mon_raw = mons_raw[str(mon_id)]
else:
mon_raw = get_mon_name(mon_id)
mons_raw[str(mon_id)] = mon_raw
data[index]["encounter_id"] = str(data[index]["encounter_id"])
data[index]["name"] = mon_raw
except Exception:
pass
return jsonify(data)
def get_map_mons(self):
neLat, neLon, swLat, swLon, oNeLat, oNeLon, oSwLat, oSwLon = getBoundParameter(
request)
timestamp = request.args.get("timestamp", None)
data = self._db.get_mons_in_rectangle(neLat=neLat,
neLon=neLon,
swLat=swLat,
swLon=swLon,
oNeLat=oNeLat,
oNeLon=oNeLon,
oSwLat=oSwLat,
oSwLon=oSwLon,
timestamp=timestamp)
mons_raw = {}
for i, mon in enumerate(data):
try:
id = data[i]["mon_id"]
if str(id) in mons_raw:
mon_raw = mons_raw[str(id)]
else:
mon_raw = get_mon_name(id)
mons_raw[str(id)] = mon_raw
data[i]["encounter_id"] = str(data[i]["encounter_id"])
data[i]["name"] = mon_raw
except Exception:
pass
return jsonify(data)
def game_stats_mon(self):
minutes_spawn = request.args.get('minutes_spawn', 10)
# Spawn
iv = []
noniv = []
sumg = []
sumup = {}
data = self._db_stats_reader.get_pokemon_count(minutes_spawn)
for dat in data:
if dat[2] == 1:
iv.append([(self.utc2local(dat[0]) * 1000), dat[1]])
else:
noniv.append([(self.utc2local(dat[0]) * 1000), dat[1]])
if (self.utc2local(dat[0]) * 1000) in sumup:
sumup[(self.utc2local(dat[0]) * 1000)] += dat[1]
else:
sumup[(self.utc2local(dat[0]) * 1000)] = dat[1]
for dat in sumup:
sumg.append([dat, sumup[dat]])
spawn = {'iv': iv, 'noniv': noniv, 'sum': sumg}
# good_spawns avg
good_spawns = []
data = self._db_stats_reader.get_best_pokemon_spawns()
if data is not None:
for dat in data:
mon_img = self.generate_mon_icon_url(dat[1], dat[8], dat[9])
mon_name = get_mon_name(dat[1])
if self._args.db_method == "rm":
lvl = calculate_mon_level(dat[6])
else:
lvl = dat[6]
good_spawns.append({
'id':
dat[1],
'iv':
round(calculate_iv(dat[3], dat[4], dat[5]), 0),
'lvl':
lvl,
'cp':
dat[7],
'img':
mon_img,
'name':
mon_name,
'periode':
datetime.datetime.fromtimestamp(self.utc2local(
dat[2])).strftime(self._datetimeformat)
})
stats = {'spawn': spawn, 'good_spawns': good_spawns}
return jsonify(stats)
def game_stats_shiny_v2(self):
logger.debug2('game_stats_shiny_v2')
timestamp_from = request.args.get('from', None)
if (timestamp_from):
timestamp_from = self.local2utc(int(timestamp_from))
logger.debug2('using timestamp_from: {}', timestamp_from)
timestamp_to = request.args.get('to', None)
if (timestamp_to):
timestamp_to = self.local2utc(int(timestamp_to))
logger.debug2('using timestamp_to: {}', timestamp_to)
tmp_perworker_v2 = {}
data = self._db_stats_reader.get_shiny_stats_v2(
timestamp_from, timestamp_to)
found_shiny_mon_id = []
shiny_count = {}
mon_names = {}
tmp_perhour_v2 = {}
if data is None or len(data) == 0:
return jsonify({'empty': True})
shiny_stats_v2 = []
for dat in data:
mon = "%03d" % dat[0]
mon_img = self.generate_mon_icon_url(dat[0], dat[1])
mon_name = get_mon_name(dat[0])
mon_names[dat[0]] = mon_name
found_shiny_mon_id.append(
mon
) # append everything now, we will set() it later to remove duplicates
if dat[8] not in tmp_perworker_v2:
tmp_perworker_v2[dat[8]] = 0
tmp_perworker_v2[dat[8]] += 1
if dat[0] not in shiny_count:
shiny_count[dat[0]] = {}
if dat[1] not in shiny_count[dat[0]]:
shiny_count[dat[0]][dat[1]] = 0
shiny_count[dat[0]][dat[1]] += 1
# there is later strftime which converts to local time too, can't use utc2local - it will do double shift
timestamp = datetime.datetime.fromtimestamp(dat[7])
if timestamp.hour in tmp_perhour_v2:
tmp_perhour_v2[timestamp.hour] += 1
else:
tmp_perhour_v2[timestamp.hour] = 1
shiny_stats_v2.append({
'img':
mon_img,
'name':
mon_name,
'worker':
dat[8],
'lat':
dat[2],
'lat_5':
"{:.5f}".format(dat[2]),
'lng_5':
"{:.5f}".format(dat[3]),
'lng':
dat[3],
'timestamp':
timestamp.strftime(self._datetimeformat),
'form':
dat[1],
'mon_id':
dat[0],
'encounter_id':
str(dat[9])
})
global_shiny_stats_v2 = []
data = self._db_stats_reader.get_shiny_stats_global_v2(
set(found_shiny_mon_id), timestamp_from, timestamp_to)
for dat in data:
if dat[1] in shiny_count and dat[2] in shiny_count[dat[1]]:
odds = round(dat[0] / shiny_count[dat[1]][dat[2]], 0)
mon = "%03d" % dat[1]
mon_img = self.generate_mon_icon_url(dat[1], dat[2])
global_shiny_stats_v2.append({
'name':
mon_names[dat[1]],
'count':
dat[0],
'img':
mon_img,
'shiny':
shiny_count[dat[1]][dat[2]],
'odds':
odds,
'mon_id':
dat[1],
'form':
dat[2],
'gender':
dat[3],
'costume':
dat[4]
})
shiny_stats_perworker_v2 = []
for worker in tmp_perworker_v2:
shiny_stats_perworker_v2.append({
'name': worker,
'count': tmp_perworker_v2[worker]
})
shiny_stats_perhour_v2 = []
for hour in tmp_perhour_v2:
shiny_stats_perhour_v2.append([hour, tmp_perhour_v2[hour]])
stats = {
'empty': False,
'shiny_statistics': shiny_stats_v2,
'global_shiny_statistics': global_shiny_stats_v2,
'per_worker': shiny_stats_perworker_v2,
'per_hour': shiny_stats_perhour_v2
}
return jsonify(stats)
def shiny_stats_data(self):
# shiny hour
shiny_hour_temp = {}
shiny_hour_calc = {}
shiny_hour = []
data = self._db_stats_reader.get_shiny_stats_hour()
for dat in data:
if dat[1] not in shiny_hour_temp:
shiny_hour_temp[dat[1]] = dat[0]
for dat in shiny_hour_temp:
if shiny_hour_temp[dat] not in shiny_hour_calc:
shiny_hour_calc[shiny_hour_temp[dat]] = 0
shiny_hour_calc[shiny_hour_temp[dat]] += 1
for dat in sorted(shiny_hour_calc):
sht = ([
self.utc2local(dat * 60 * 60) * 1000, shiny_hour_calc[dat]
])
shiny_hour.append(sht)
shiny_stats = []
shiny_worker = {}
shiny_avg = {}
data = self._db_stats_reader.get_shiny_stats()
for dat in data:
form_suffix = "%02d" % form_mapper(dat[2], dat[5])
mon = "%03d" % dat[2]
mon_img = self.generate_mon_icon_url(dat[2], dat[8], dat[9])
mon_name = get_mon_name(dat[2])
diff: int = dat[0]
if diff == 0:
logger.warning(
'No deeper pokemon stats are possible - not enough data (check config.ini // '
'game_stats_raw)')
diff = 1
ratio = round(dat[1] * 100 / diff, 2)
if dat[3] not in shiny_worker:
shiny_worker[dat[3]] = 0
shiny_worker[dat[3]] += dat[1]
if dat[2] not in shiny_avg:
shiny_avg[dat[2]] = {}
if dat[5] not in shiny_avg[dat[2]]:
shiny_avg[dat[2]][dat[5]] = {}
shiny_avg[dat[2]][dat[5]]['total_shiny'] = []
shiny_avg[dat[2]][dat[5]]['total_nonshiny'] = []
shiny_avg[dat[2]][dat[5]]['total_shiny'].append(dat[1])
shiny_avg[dat[2]][dat[5]]['total_nonshiny'].append(diff)
shiny_stats.append({
'sum':
dat[0],
'shiny':
dat[1],
'img':
mon_img,
'name':
mon_name,
'ratio':
ratio,
'worker':
dat[3],
'encounterid':
dat[4],
'periode':
datetime.datetime.fromtimestamp(dat[6]).strftime(
self._datetimeformat)
})
shiny_stats_avg = []
for dat in shiny_avg:
for form_dat in shiny_avg[dat]:
form_suffix = "%02d" % form_mapper(dat, form_dat)
mon = "%03d" % dat
mon_img = 'asset/pokemon_icons/pokemon_icon_' + mon + '_' + form_suffix + '_shiny.png'
mon_name = get_mon_name(dat)
total_shiny_encounters = sum(
shiny_avg[dat][form_dat]['total_shiny'])
total_nonshiny_encounters = sum(
shiny_avg[dat][form_dat]['total_nonshiny'])
shiny_avg_click = round(
total_nonshiny_encounters / total_shiny_encounters, 0)
shiny_stats_avg.append({
'name': mon_name,
'img': mon_img,
'total_shiny_encounters': total_shiny_encounters,
'total_nonshiny_encounters': total_nonshiny_encounters,
'click_for_shiny': shiny_avg_click
})
shiny_stats_worker = []
for dat in shiny_worker:
shiny_stats_worker.append({
'sum': shiny_worker[dat],
'worker': dat
})
stats = {
'shiny': shiny_stats,
'shiny_worker': shiny_stats_worker,
'shiny_hour': shiny_hour,
'shiny_stats_avg': shiny_stats_avg
}
return jsonify(stats)
