def get(self):
user = DBOHHOUser()
query = user.get_query()
total_count = user.get_count(query)
today_start = OHHODatetime.get_today_start()
utc_today_start = OHHODatetime.beijing2utc(today_start)
today_query = user.get_great_than_equal_created_at(
query, utc_today_start)
today_count = user.get_count(today_query)
return self.render(
STATISTICS_USER_HTML,
total_count=total_count,
today_count=today_count,
)
def get_exclude_user_list(self, user_id):
created_at = OHHODatetime.get_today_start()
created_at = OHHODatetime.beijing2utc(created_at)
one_day_before = OHHODatetime.get_some_hour_after(created_at, -24)
query = self.exclude.get_query()
query = self.exclude.get_great_than_equal_created_at(
query, one_day_before)
query1 = self.exclude.get_by_user(query, user_id)
query2 = self.exclude.get_by_exclude_user(query, user_id)
if self.exclude.is_empty(query1):
user1_list = list()
else:
user1_list = [exclude.exclude_user_id for exclude in query1]
if self.exclude.is_empty(query1):
user2_list = list()
else:
user2_list = [exclude.user_id for exclude in query2]
return list(set(user1_list + user2_list))
def get(self):
device = DBOHHODevice()
query = device.get_query()
total_count = device.get_count(query)
today_start = OHHODatetime.get_today_start()
utc_today_start = OHHODatetime.beijing2utc(today_start)
today_query = device.get_great_than_equal_changed_at(query, utc_today_start)
today_count = device.get_count(today_query)
relation = DBOHHOUserAndDeviceRelation()
relation_query = relation.get_query()
relation_query = relation.get_valid(relation_query)
total_bind_count = relation.get_count(relation_query)
today_bind_query = relation.get_great_than_equal_changed_at(relation_query, utc_today_start)
today_bind_count = relation.get_count(today_bind_query)
return self.render(STATISTICS_DEVICE_HTML,
total_count=total_count,
today_count=today_count,
today_bind_count=today_bind_count,
total_bind_count=total_bind_count,
)
