from django.db import models
from django.conf import settings


# https://pingcap.feishu.cn/docs/doccnJAdCWIrSn7oZZtFfBewoxf#GXeltw
class UserDailyActivity(models.Model):

    user = models.ForeignKey(
        settings.AUTH_USER_MODEL, on_delete=models.DO_NOTHING
    )
    day = models.DateField()
    community_score = models.IntegerField(default=0, help_text='分数')
    pageview_distinct_count = models.IntegerField(default=0, help_text='浏览页面次数(去重)')
    pageview_count = models.IntegerField(default=0, help_text='浏览页面次数')
    asktug_blogs_count = models.IntegerField(
        default=0, help_text='发表的技术文章数')
    asktug_likes_count = models.IntegerField(default=0, help_text='点赞数')
    asktug_bookmark_count = models.IntegerField(default=0, help_text='收藏数')
    asktug_topics_count = models.IntegerField(
        default=0, help_text='创建的新问题(除技术文章)')
    asktug_reply_my_topic_count = models.IntegerField(default=0, help_text='回复自己的问题次数')
    asktug_reply_other_topic_count = models.IntegerField(default=0, help_text='回复他人问题次数')
    asktug_mark_solved_count = models.IntegerField(default=0, help_text='标记解决方案次数')
    asktug_search_count = models.IntegerField(default=0, help_text='搜索次数')
    asktug_search_click_count = models.IntegerField(default=0, help_text='搜索后点击答案次数')
    login_count = models.IntegerField(default=0, help_text='登录次数')
    daily_checkin_count = models.IntegerField(default=0, help_text='签到次数')
    redeem_product_count = models.IntegerField(default=0, help_text='兑换商品次数')
    apply_join_tug_count = models.IntegerField(default=0, help_text='申请加入 TUG 的次数')
    apply_new_org_count = models.IntegerField(default=0, help_text='申请创建团队的次数')
    invite_user_to_org_count = models.IntegerField(default=0, help_text='邀请用户加入团队的次数')
    accept_org_invitation_count = models.IntegerField(default=0, help_text='接受团队邀请的次数')
    refuse_org_invitation_count = models.IntegerField(default=0, help_text='拒绝团队邀请的次数')
    urge_topic_count = models.IntegerField(default=0, help_text='加急帖子的次数')
    update_profile_count = models.IntegerField(default=0, help_text='更新个人信息的次数')
    update_account_settings_count = models.IntegerField(default=0, help_text='更新账户设置的次数')
    submit_form_count = models.IntegerField(default=0, help_text='提交表单的次数')
    track_events_count = models.IntegerField(default=0, help_text='总事件数')
    created_at = models.DateTimeField(auto_now_add=True)

    class Meta:
        db_table = 'pingcap_user_daily_activities'
        unique_together = ('user', 'day')