1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
#!/usr/bin/env python
# -*- coding: utf-8 -*-
from django.conf import settings
from django.db import models
from django.utils import timezone
import logging
import traceback
from django.utils.functional import cached_property
from gm_serializer import fields
from gm_types.gaia import VIDEO_CODE_STATUS
from gm_types.mimas import (
TRACTATE_STATUS,
TRACTATE_PLATFORM,
TRACTATE_CONTENT_LEVEL,
SOFT_ARTICLE_TYPE,
SOFT_ARTICLE_RELATION_TYPE,
SOFT_ARTICLE_ORDER,
)
from gm_upload import ImgUrlField, IMG_TYPE
from talos.cache.base import soft_article_pv_cache, soft_article_favor_count_cache, soft_article_vote_count_cache
class SoftArticle(models.Model):
"""
软文（新帖子类型）---医生后台专用 对用户来说（tractate、softarticle）没有区别
"""
class Meta:
verbose_name = u'软文章'
db_table = 'api_doctor_softarticle'
app_label = 'talos'
doctor_id = models.CharField(verbose_name="医生id", db_index=True, max_length=64)
merchant_id = models.CharField(verbose_name="商户id", db_index=True, max_length=64)
content = models.TextField(verbose_name=u'正文描述', default="")
title = models.CharField(verbose_name=u'标题', default="", max_length=32)
is_online = models.BooleanField(verbose_name=u"是否在线", default=True)
status = models.CharField(verbose_name=u"审核状态", max_length=12,
choices=TRACTATE_STATUS, default=TRACTATE_STATUS.UNAUDITED)
platform = models.CharField(verbose_name=u"数据来源", max_length=12, choices=TRACTATE_PLATFORM)
content_level = models.CharField(verbose_name=u"内容等级", max_length=12,
choices=TRACTATE_CONTENT_LEVEL, default=TRACTATE_CONTENT_LEVEL.NULL)
article_type = models.IntegerField(verbose_name=u'帖子类型', choices=SOFT_ARTICLE_TYPE, default=0)
hera_is_online = models.BooleanField(verbose_name=u"最终是否上下线", default=False)
create_time = models.DateTimeField(verbose_name="创建时间", default=timezone.now)
online_time = models.DateTimeField(verbose_name=u'医生操作上下线时间', default=timezone.now)
show_order = models.IntegerField(verbose_name=u'展示顺序', choices=SOFT_ARTICLE_ORDER, default=SOFT_ARTICLE_ORDER.UNSET)
last_modified = models.DateTimeField(verbose_name=u'最后修改时间', auto_now=True)
audit_time = models.DateTimeField(verbose_name=u'最近一次的审核时间', null=True, default=None)
@property
def get_tag_list_sort_article(self):
"""
帖子关联标签
:return:
"""
try:
tag_id_list = list(
SoftArticleRelation.objects.filter(softarticle_id=self.id, relation_type=1).values_list("relation_id",
flat=True))
return tag_id_list
except:
logging.error("catch exception,err_msg:%s" % traceback.format_exc())
return []
@property
def get_is_video(self):
"""
判断该帖子是否有视频
:return:
"""
try:
bol = SoftArticleVideo.objects.filter(softarticle_id=self.id, is_online=True)
if len(bol):
return True
else:
return False
except:
logging.error("catch exception,err_msg:%s" % traceback.format_exc())
@property
def view_amount(self):
"""
浏览量
:return:
"""
return int(soft_article_pv_cache.get(str(self.id)) or 0)
@property
def vote_amount(self):
"""
点赞数
:return:
"""
return int(soft_article_vote_count_cache.get(str(self.id)) or 0)
@cached_property
def reply_amount(self):
"""
评论数
:return:
"""
try:
extra = SoftArticleExtra.objects.get(softarticle_id=self.id)
except SoftArticleExtra.DoesNotExist:
return 0
return extra.reply_count
@property
def favor_amount(self):
"""
收藏数
:return:
"""
return int(soft_article_favor_count_cache.get(str(self.id)) or 0)
class SoftArticleExtra(models.Model):
"""
新帖子 数据相关
"""
class Meta:
verbose_name = u'新帖子(软文)其他数据表'
db_table = 'api_doctor_softarticle_extra'
app_label = 'talos'
softarticle_id = models.IntegerField(verbose_name="软文id", unique=True)
reply_count = models.IntegerField(verbose_name="所有评论数", default=0)
vote_count = models.IntegerField(verbose_name="点赞数", default=0)
favor_count = models.IntegerField(verbose_name="收藏数", default=0)
class SoftArticleImages(models.Model):
"""
新帖子(软文) 图片相关
默认第一张图片为封面图，故未设置 is_cover 字段
"""
class Meta:
verbose_name = u'新帖子(软文) 图片相关'
db_table = 'api_softarticle_images'
app_label = 'talos'
softarticle_id = models.IntegerField(verbose_name="软文id", db_index=True)
image_url = ImgUrlField(img_type=IMG_TYPE.TOPICIMAGE, max_length=300, verbose_name=u'图片地址')
width = models.IntegerField(verbose_name="图片宽度", default=0)
height = models.IntegerField(verbose_name="图片高度", default=0)
create_time = models.DateTimeField(verbose_name=u'创建时间', default=timezone.now)
update_time = models.DateTimeField(verbose_name=u'更新时间', auto_now=True)
class SoftArticleVideo(models.Model):
"""
新帖子(软文) 视频相关
"""
class Meta:
verbose_name = u'新帖子(软文) 视频相关'
db_table = 'api_doctor_softarticle_video'
app_label = 'talos'
softarticle_id = models.IntegerField(verbose_name="软文id", db_index=True)
video_cover_url = models.CharField(max_length=300, verbose_name="视频封面图地址", default="")
width = models.IntegerField(verbose_name="视频封面图片宽度", default=0)
height = models.IntegerField(verbose_name="视频封面图片高度", default=0)
upload_img_cover = ImgUrlField(img_type=IMG_TYPE.TOPICIMAGE, max_length=300, verbose_name=u'上传的列表图片地址')
raw_video_url = models.CharField(max_length=128, verbose_name=u"视频地址")
water_video_url = models.CharField(max_length=128, verbose_name=u"带图片水印的视频地址", default="")
persistent_id = models.CharField(max_length=128, verbose_name=u'七牛视频处理id', default="")
persistent_status = models.IntegerField(verbose_name=u"七牛状态",
choices=VIDEO_CODE_STATUS, default=VIDEO_CODE_STATUS.NOSTART)
is_online = models.BooleanField(verbose_name=u"是否在线", default=True)
create_time = models.DateTimeField(verbose_name=u'创建时间', default=timezone.now)
update_time = models.DateTimeField(verbose_name=u'更新时间', auto_now=True)
@classmethod
def cleaned_video_url(cls, video_url):
return video_url.replace(settings.VIDEO_HOST, '')
class SoftArticleRelation(models.Model):
"""
医生后台的帖子(软文) 关联项
"""
class Meta:
verbose_name = u'医生新帖子(软文) 视频相关: Tag 美购 日记'
db_table = 'api_doctor_softarticle_relation'
app_label = 'talos'
softarticle_id = models.IntegerField(verbose_name="软文id")
relation_id = models.IntegerField(verbose_name="关联ID")
relation_type = models.IntegerField(verbose_name="关联类型", choices=SOFT_ARTICLE_RELATION_TYPE)
class Group(models.Model):
class Meta:
verbose_name = '内容聚合'
db_table = 'api_group'
name = models.CharField('标题', max_length=32)
introduction = models.TextField('描述简介')
header_image = ImgUrlField(img_type=IMG_TYPE.POLYMER, max_length=255, verbose_name=u'背景图')
bg_image = ImgUrlField(img_type=IMG_TYPE.POLYMER, max_length=255, verbose_name=u'背景图')
is_online = models.BooleanField('是否上线', default=True)
create_time = models.DateTimeField(auto_now_add=True)
update_time = models.DateTimeField(verbose_name=u'更新时间', auto_now=True)
class PageGoodClick(models.Model):
class Meta:
db_table = 'al_community_detail_page_goodclick_v2'
app_label = 'doris'
page_name = models.CharField(max_length=50)
business_id = models.CharField(max_length=50)
detail_uv = models.IntegerField()
detail_gc = models.IntegerField()
detail_new_gc = models.FloatField()
avg_new_gc = models.FloatField()
detail_pv = models.IntegerField()
create_date = models.CharField(max_length=50)
class GoodClickCom(models.Model):
class Meta:
db_table = 'al_community_detail_page_goodclick_daily_check'
app_label = 'doris'
page_name = models.CharField(max_length=50)
business_id = models.CharField(max_length=50)
event_num_30 = models.IntegerField()
goodclick_pv_30 = models.IntegerField()
detail_pv_30 = models.IntegerField()
goodclick_rate_30 = models.FloatField()
goodclick_score_30 = models.FloatField()
create_date = models.CharField(max_length=50)