def posts(page=False): numbers = Post.count_by_status(page) if not request.args.get('filter'): query = Post.filter( Post.status << ['draft', 'published'], Post.type == ('page' if page else 'post')).order_by(Post.created) else: query = Post.filter( Post.status == request.args.get('filter'), Post.type == ('page' if page else 'post')).order_by(Post.created) if page: title = gettext('Page') else: title = gettext('Posts') paginator = Paginator(query=query, page=request.args.get('page')) if page: urls = 'admin.pages' else: urls = 'admin.posts' return render_template('admin/posts.html', pages=paginator.links, title=title, posts=paginator.items, numbers=numbers, filter=request.args.get('filter'), page=page, urls=urls)
def posts(page=False): numbers = Post.count_by_status(page) if not request.args.get('filter'): if page: query = Post.query.where(' _table_.post_status IN ("draft", "published") AND _table_.post_type="page"').order_by('created') else: query = Post.query.where(' _table_.post_status IN ("draft", "published") AND _table_.post_type="post"').order_by('created') else: if page: query = Post.query.filter(status=request.args.get('filter'), type='page').order_by('created') else: query = Post.query.filter(status=request.args.get('filter'), type='post').order_by('created') if page: title = gettext('Page') else: title = gettext('Posts') paginator = Paginator( query = query, page = request.args.get('page') ) if page: urls = 'admin.pages' else: urls = 'admin.posts' return render_template('admin/posts.html', pages=paginator.links, title=title, posts=paginator.items, numbers=numbers, filter=request.args.get('filter'), page=page, urls=urls)
def posts(page=False): numbers = Post.count_by_status(page) if not request.args.get('filter'): query = Post.filter(Post.status << ['draft', 'published'], Post.type == ('page' if page else 'post')).order_by(Post.created) else: query = Post.filter(Post.status == request.args.get('filter'), Post.type == ('page' if page else 'post')).order_by(Post.created) if page: title = gettext('Page') else: title = gettext('Posts') paginator = Paginator( query=query, page=request.args.get('page') ) if page: urls = 'admin.pages' else: urls = 'admin.posts' return render_template('admin/posts.html', pages=paginator.links, title=title, posts=paginator.items, numbers=numbers, filter=request.args.get('filter'), page=page, urls=urls)