BBS论坛（三十一）

class HighLight(db.Model): __tablename__='highlight_post' id = db.Column(db.Integer, primary_key=True, autoincrement=True) post_id=db.Column(db.Integer,db.ForeignKey('post.id')) create_time=db.Column(db.DateTime,default=datetime.now) post=db.relationship('PostModel',backref='highlight')

@bp.route('/posts/') @login_required @permission_required(CMSPermission.POSTER) def posts(): context = { 'posts': PostModel.query.all() } return render_template('cms/cms_posts.html',**context) @bp.route('/hpost/',methods=['POST']) @login_required @permission_required(CMSPermission.POSTER) def hpost(): post_id=request.form.get('post_id') if not post_id: return restful.params_error(message='请传入帖子id') post=PostModel.query.get(post_id) if not post: return restful.params_error(message='没有这篇帖子') highlight=HighLight() highlight.post=post db.session.add(highlight) db.session.commit() return restful.success() @bp.route('/uhpost/',methods=['POST']) @login_required @permission_required(CMSPermission.POSTER) def uhpost(): post_id = request.form.get('post_id') if not post_id: return restful.params_error(message='请传入帖子id') post = PostModel.query.get(post_id) if not post: return restful.params_error(message='没有这篇帖子') print(post_id) highlight=HighLight.query.filter_by(post_id=post_id).first() print(highlight) db.session.delete(highlight) db.session.commit() return restful.success()

{% extends 'cms/cms_base.html' %} {% from 'common/_macros.html' import static %} {% block title %} 帖子管理 {% endblock %} {% block head %} <script src="{{ static('cms/js/posts.js') }}"></script> {% endblock %} {% block page_title %} {{ self.title() }} {% endblock %} {% block main_content %} <table class="table table-bordered"> <thead> <tr> <th>标题</th> <th>发布时间</th> <th>版块</th> <th>作者</th> <th>操作</th> </tr> </thead> <tbody> {% for post in posts %} <tr data-id={{ post.id }} data-highlight={{ 1 if post.highlight else 0 }}> <td><a target="_blank" href="{{ url_for('front.post_detail',post_id=post.id) }}">{{ post.title }}</a> </td> <td>{{ post.create_time }}</td> <td>{{ post.board.name }}</td> <td>{{ post.author.username }}</td> <td> {% if post.highlight %} <button class="btn btn-info btn-xs highlight-btn">取消加精</button> {% else %} <button class="btn btn-danger btn-xs highlight-btn">加精</button> {% endif %} &nbsp;&nbsp;&nbsp;<button class="btn btn-default btn-xs">移除</button> </td> </tr> {% endfor %} </tbody> </table> {% endblock %}

$(function(){ $('.highlight-btn').on('click',function(){ var $this=$(this); var tr=$this.parent().parent(); var post_id=tr.attr('data-id'); var highlight=parseInt(tr.attr('data-highlight')); var url=''; if(highlight){ url='/cms/uhpost/' }else{ url='/cms/hpost/' } zlajax.post({ 'url':url, 'data':{ 'post_id':post_id }, 'success':function(data){ if(data['code']==200){ zlalert.alertSuccessToast('操作成功'); setTimeout(function(){ window.location.reload(); },500); }else{ zlalert.alertInfo(data['message']); } } }) }); });