def comment_list(page):
per_page_data = 10
if page is None:
page = 1
next_page = page + 1
pre_page = page - 1
data = Comment.comment_query(id=None,
per_page=page,
page_count=per_page_data) #每页100条数据
if int(Comment.query.count() / per_page_data) == 0:
last_page = int(Comment.query.count() / per_page_data)
else:
last_page = int(Comment.query.count() / per_page_data) + 1
comment = []
for v in data:
comment.append({
'id': v[0],
'user_name': v[1],
'movie_title': v[2],
'content': v[3],
'addtime': v[4],
'face': v[5]
})
return render_template('admin/comment_list.html',
comment=comment,
last_page=last_page,
page=page,
next_page=next_page,
pre_page=pre_page)
def play(id,page):
movie=Movie.query.filter_by(id=id).first()
if movie:
movie.playnum=int(movie.playnum)+1
Movie.add_comment_or_play(movie)
form=AddComment()
if form.validate_on_submit():
if not session['user_id']:
return redirect(url_for('home.login'))
data=form.data
if data['content']:
comment=Comment(
user_id=session['user_id'],
movie_id=id,
addtime=datetime.datetime.now(),
content=data['content']
)
if Comment.addcomment(comment):
flash("添加评论成功！",'ok')
movie.commentnum=int(movie.commentnum)+1
Movie.add_comment_or_play(movie)
return redirect(url_for('home.play',id=id,page=page))
shoucang=AddMoviecol()
if shoucang.validate_on_submit():
if not Moviecol.query.filter_by(user_id=session['user_id'],movie_id=id).count():
if Moviecol.moviecol_add(session['user_id'],id):
flash("收藏成功！",'ok')
return redirect(url_for('home.play',id=id,page=page))
else:
if Moviecol.moviecol_del_by_user(session['user_id'],id):
flash("取消收藏！",'err')
return redirect(url_for('home.play',id=id,page=page))
pre_page_date=20 #每页20条数据
comment_count=Comment.query.filter_by(movie_id=id).count() #评论总数
page_data=Movie.query.filter_by(id=id).first_or_404()
tag=Tag.query.filter_by(id=page_data.tag_id).first_or_404()
tag_name=tag.name
if page is None:
page=1
next_page=page+1
pre_page=page-1
data=Comment.comment_query(id=id,per_page=page,page_count=pre_page_date)
if int(comment_count/pre_page_date)==0:
last_page=int(comment_count/pre_page_date)
else:
last_page=int(comment_count/pre_page_date)+1
comment=[]
for v in data:
comment.append({
'id':v[0],
'user_name':v[1],
'movie_title':v[2],
'content':v[3],
'addtime':v[4],
'face':v[5]
})
return render_template('home/play.html',shoucang=shoucang,id=id,form=form,page_data=page_data,tag_name=tag_name,comment=comment,last_page=last_page,page=page,next_page=next_page,pre_page=pre_page,comment_count=comment_count)
