class CompanyRegisitServiceAllContent(Base):
__tablename__ = 'CompanyRegisitServiceAllContent'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
company_all_service_content = db.Column(db.String(255))
grade = db.Column(db.Integer, default=0)
class CompanyRegisitKind(Base):
__tablename__ = 'CompanyRegisitKind'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
company_all_kind = db.Column(db.String(255))
grade = db.Column(db.Integer, default=0)
class CompanyProviderSonContent(Base):
__tablename__ = 'CompanyProviderSonContent'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
provider_regisit_id = db.Column(
db.String(255), ForeignKey("CompanyProviderInfo.main_id")) # 服务商Id
provider_son_service_content = db.Column(db.String(255)) # 服务商自定义内容
class CompanyProviderAllContent(Base):
__tablename__ = 'CompanyRegisitProviderAllContent'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
provider_all_service_content = db.Column(db.String(255)) # 服务商服务内容
grade = db.Column(db.Integer, default=0)
class CompanyProviderContent(Base):
__tablename__ = 'CompanyProviderContent' # 数据库名称
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
provider_regisit_id = db.Column(
db.String(255), ForeignKey("CompanyProviderInfo.main_id")) # 服务商id
provider_regisit_info = db.Column(db.String(255)) # 服务商可注册内容
class CompanyRegisitSonLegalPerson(Base):
__tablename__ = 'CompanyRegisitSonLegalPerson'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
company_regisit_id = db.Column(db.String(255),
ForeignKey("CompanyRegisitInfo.main_id"))
company_son_legal_name = db.Column(db.String(255))
class Marketing_Articles_Info(Base):
__tablename__ = 'Marketing_Articles_Info'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
ma_update_time = db.Column(db.DateTime) #文章更新时间
ma_content = db.Column(db.Text) #文章内容
ma_img = db.Column(db.String(255)) # 文章首图
ma_img_min = db.Column(db.String(255)) # 文章首图缩略图
ma_title = db.Column(db.String(255)) # 文章标题
ma_browser_count = db.Column(db.Integer, default=0) # 用户浏览量
ma_nice = db.Column(db.Integer) #文章是否精品 1是 0否
ma_original = db.Column(db.Integer) #文章是否原创 1是 0否
ma_article_top = db.Column(db.Integer) #用户置顶等级
ma_user_id = db.Column(db.String(255),
ForeignKey("user_and_oa.user_id")) #作者Id （引用用户表信息）
ma_article_good_count = db.Column(db.Integer, default=0) #文章点赞量
last_user_id = db.Column(db.String(255)) # 上次作品拥有者
check_status = db.Column(db.Integer, default=0) # 审核状态0 未审核， 1 审核
source = db.Column(db.String(255)) # 来源
random_read_count = db.Column(db.Integer,
default=random.randint(101, 201)) # 随机阅读数量
def to_json(self):
json_data = {
'main_id': self.main_id,
'ma_update_time': str(self.ma_update_time),
'ma_content': self.ma_content,
'ma_img': self.ma_img,
'ma_img_min': self.ma_img_min,
'ma_title': self.ma_title,
'ma_browser_count': self.ma_browser_count,
'ma_article_top': self.ma_article_top,
'ma_user_id': self.ma_user_id,
'ma_original': self.ma_original,
'ma_article_good_count': self.ma_article_good_count
}
return json_data
@staticmethod
def Write(mydirt):
marketing_Articles_Info = Marketing_Articles_Info()
marketing_Articles_Info.set_attrs(mydirt)
db.session.add(marketing_Articles_Info)
db.session.commit()
@staticmethod
def Read(main_id):
marketing_Articles_Info = Marketing_Articles_Info.query.filter(
Marketing_Articles_Info.main_id == main_id).first()
return marketing_Articles_Info
@staticmethod
def Delete(marketing_Articles):
db.session.delete(marketing_Articles)
db.session.commit()
@staticmethod
def Update(marketing_Articles, mydirt):
marketing_Articles.set_attrs(mydirt)
db.session.commit()
@staticmethod
def ReadAll():
marketing_Articles = Marketing_Article_Labels.query.all()
return marketing_Articles
@staticmethod
def getMarketingAllData(user_id, search, putong_page, page_num, kind):
allData = db.session.query(
Marketing_Articles_Info.main_id,
Marketing_Articles_Info.ma_update_time,
Marketing_Articles_Info.ma_img, Marketing_Articles_Info.ma_img_min,
Marketing_Articles_Info.ma_title,
Marketing_Articles_Info.ma_browser_count,
Marketing_Articles_Info.ma_article_top,
Marketing_Articles_Info.ma_article_good_count,
Marketing_Articles_Info.ma_nice,
Marketing_Articles_Info.ma_original,
Marketing_Articles_Info.check_status, UserAndOA.username,
Marketing_Articles_Info.ma_user_id).filter(
Marketing_Articles_Info.ma_user_id == UserAndOA.user_id,
Marketing_Articles_Info.ma_nice == kind).filter(
or_(
Marketing_Articles_Info.ma_title.like(
'%{}%'.format(search)),
UserAndOA.username.like('%{}%'.format(search)))
).order_by(
Marketing_Articles_Info.ma_update_time.desc()).paginate(
putong_page, page_num, False).items
putongInfo = []
for item in allData:
isgood = Marketing_and_GoodCnt.query.filter(
Marketing_and_GoodCnt.mg_article_id == item.main_id,
Marketing_and_GoodCnt.mg_user_Id == user_id).first()
marketing_and_ArticleLabels = Marketing_and_ArticleLabel.query.filter(
Marketing_and_ArticleLabel.mar_article_id ==
item.main_id).all()
labels = []
for t in marketing_and_ArticleLabels:
temp = Marketing_Article_Labels.query.filter(
Marketing_Article_Labels.main_id ==
t.mar_article_Label_Id).first()
mydirt = temp.serialize
mydirt['label'] = mydirt['mal_article_label_name']
labels.append(mydirt)
# 查找一篇文章的所有总板块
marketing_and_AdvancedLabels = Marketing_and_AdvancedLabel.query.filter(
Marketing_and_AdvancedLabel.mad_article_id ==
item.main_id).all()
for t in marketing_and_AdvancedLabels:
temp = AdvancedLabel.query.filter(
AdvancedLabel.al_uid == t.mad_advanced_id).first()
mydirt = temp.serialize
mydirt['label'] = mydirt['al_label']
labels.append(mydirt)
Comment = Marketing_Comment_Info.ReadAll(item.main_id)
GoodCnt = Marketing_and_GoodCnt.ReadAll(item.main_id)
marketing_and_Collection = Marketing_and_Collection.query.filter(
Marketing_and_Collection.mc_article_id == item.main_id,
Marketing_and_Collection.mc_user_Id == user_id).first()
data = {
'main_id': item.main_id,
'ma_update_time': str(item.ma_update_time),
'ma_img': item.ma_img,
'ma_img_min': item.ma_img_min,
'ma_title': item.ma_title,
'ma_browser_count': item.ma_browser_count,
'ma_article_top': item.ma_article_top,
'ma_article_good_count': len(GoodCnt),
'username': item.username,
'ma_nice': item.ma_nice,
'ma_original': item.ma_original,
'comment_cnt': len(Comment),
'delete_status': 1 if item.ma_user_id == user_id else 0,
'good': 1 if isgood else 0,
'collection_status': 1 if marketing_and_Collection else 0,
'labels': labels,
'check_status': item.check_status
}
putongInfo.append(data)
return putongInfo
@staticmethod
def getMarketingSonData(user_id, search, putong_page, page_num, kind,
label_id):
allData = db.session.query(
Marketing_Articles_Info.main_id,
Marketing_Articles_Info.ma_update_time,
Marketing_Articles_Info.ma_img, Marketing_Articles_Info.ma_img_min,
Marketing_Articles_Info.ma_title,
Marketing_Articles_Info.ma_browser_count,
Marketing_Articles_Info.ma_article_top,
Marketing_Articles_Info.ma_article_good_count,
Marketing_Articles_Info.ma_nice,
Marketing_Articles_Info.ma_original,
Marketing_Articles_Info.check_status, UserAndOA.username,
Marketing_Articles_Info.ma_user_id).filter(
Marketing_Articles_Info.ma_user_id == UserAndOA.user_id,
Marketing_Articles_Info.ma_nice == kind,
Marketing_and_ArticleLabel.mar_article_id ==
Marketing_Articles_Info.main_id,
Marketing_and_ArticleLabel.mar_article_Label_Id ==
label_id).filter(
or_(
Marketing_Articles_Info.ma_title.like(
'%{}%'.format(search)),
UserAndOA.username.like('%{}%'.format(search)))
).order_by(
Marketing_Articles_Info.ma_update_time.desc()).paginate(
putong_page, page_num, False).items
putongInfo = []
for item in allData:
isgood = Marketing_and_GoodCnt.query.filter(
Marketing_and_GoodCnt.mg_article_id == item.main_id,
Marketing_and_GoodCnt.mg_user_Id == user_id).first()
marketing_and_ArticleLabels = Marketing_and_ArticleLabel.query.filter(
Marketing_and_ArticleLabel.mar_article_id ==
item.main_id).all()
labels = []
for t in marketing_and_ArticleLabels:
temp = Marketing_Article_Labels.query.filter(
Marketing_Article_Labels.main_id ==
t.mar_article_Label_Id).first()
mydirt = temp.serialize
mydirt['label'] = mydirt['mal_article_label_name']
labels.append(mydirt)
# 查找一篇文章的所有总板块
marketing_and_AdvancedLabels = Marketing_and_AdvancedLabel.query.filter(
Marketing_and_AdvancedLabel.mad_article_id ==
item.main_id).all()
for t in marketing_and_AdvancedLabels:
temp = AdvancedLabel.query.filter(
AdvancedLabel.al_uid == t.mad_advanced_id).first()
mydirt = temp.serialize
mydirt['label'] = mydirt['al_label']
labels.append(mydirt)
Comment = Marketing_Comment_Info.ReadAll(item.main_id)
GoodCnt = Marketing_and_GoodCnt.ReadAll(item.main_id)
marketing_and_Collection = Marketing_and_Collection.query.filter(
Marketing_and_Collection.mc_article_id == item.main_id,
Marketing_and_Collection.mc_user_Id == user_id).first()
data = {
'main_id': item.main_id,
'ma_update_time': str(item.ma_update_time),
'ma_img': item.ma_img,
'ma_img_min': item.ma_img_min,
'ma_title': item.ma_title,
'ma_browser_count': item.ma_browser_count,
'ma_article_top': item.ma_article_top,
'ma_article_good_count': len(GoodCnt),
'username': item.username,
'ma_nice': item.ma_nice,
'ma_original': item.ma_original,
'comment_cnt': len(Comment),
'delete_status': 1 if item.ma_user_id == user_id else 0,
'good': 1 if isgood else 0,
'collection_status': 1 if marketing_and_Collection else 0,
'labels': labels,
'check_status': item.check_status
}
putongInfo.append(data)
return putongInfo
@staticmethod
def getVideoAdvData(user_id, search, putong_page, page_num, kind,
label_id):
allData = db.session.query(
Marketing_Articles_Info.main_id,
Marketing_Articles_Info.ma_update_time,
Marketing_Articles_Info.ma_img, Marketing_Articles_Info.ma_img_min,
Marketing_Articles_Info.ma_title,
Marketing_Articles_Info.ma_browser_count,
Marketing_Articles_Info.ma_article_top,
Marketing_Articles_Info.ma_article_good_count,
Marketing_Articles_Info.ma_nice,
Marketing_Articles_Info.ma_original, UserAndOA.username,
Marketing_Articles_Info.ma_user_id).filter(
Marketing_Articles_Info.ma_user_id == UserAndOA.user_id,
Marketing_Articles_Info.ma_nice == kind,
Marketing_Articles_Info.main_id ==
Marketing_and_AdvancedLabel.mad_article_id,
Marketing_and_AdvancedLabel.mad_advanced_id ==
label_id).filter(
or_(
Marketing_Articles_Info.ma_title.like(
'%{}%'.format(search)),
UserAndOA.username.like('%{}%'.format(search)))
).order_by(
Marketing_Articles_Info.ma_update_time.desc()).paginate(
putong_page, page_num, False).items
putongInfo = []
for item in allData:
isgood = Marketing_and_GoodCnt.query.filter(
Marketing_and_GoodCnt.mg_article_id == item.main_id,
Marketing_and_GoodCnt.mg_user_Id == user_id).first()
marketing_and_ArticleLabels = Marketing_and_ArticleLabel.query.filter(
Marketing_and_ArticleLabel.mar_article_id ==
item.main_id).all()
labels = []
for t in marketing_and_ArticleLabels:
temp = Marketing_Article_Labels.query.filter(
Marketing_Article_Labels.main_id ==
t.mar_article_Label_Id).first()
mydirt = temp.serialize
mydirt['label'] = mydirt['mal_article_label_name']
labels.append(mydirt)
# 查找一篇文章的所有总板块
marketing_and_AdvancedLabels = Marketing_and_AdvancedLabel.query.filter(
Marketing_and_AdvancedLabel.mad_article_id ==
item.main_id).all()
for t in marketing_and_AdvancedLabels:
temp = AdvancedLabel.query.filter(
AdvancedLabel.al_uid == t.mad_advanced_id).first()
mydirt = temp.serialize
mydirt['label'] = mydirt['al_label']
labels.append(mydirt)
Comment = Marketing_Comment_Info.ReadAll(item.main_id)
GoodCnt = Marketing_and_GoodCnt.ReadAll(item.main_id)
marketing_and_Collection = Marketing_and_Collection.query.filter(
Marketing_and_Collection.mc_article_id == item.main_id,
Marketing_and_Collection.mc_user_Id == user_id).first()
data = {
'main_id': item.main_id,
'ma_update_time': str(item.ma_update_time),
'ma_img': item.ma_img,
'ma_img_min': item.ma_img_min,
'ma_title': item.ma_title,
'ma_browser_count': item.ma_browser_count,
'ma_article_top': item.ma_article_top,
'ma_article_good_count': len(GoodCnt),
'username': item.username,
'ma_nice': item.ma_nice,
'ma_original': item.ma_original,
'comment_cnt': len(Comment),
'delete_status': 1 if item.ma_user_id == user_id else 0,
'good': 1 if isgood else 0,
'collection_status': 1 if marketing_and_Collection else 0,
'labels': labels
}
putongInfo.append(data)
return putongInfo