Web2py下拉菜单过滤-Web2pyDropdownmenuthatfilters

0  

Here is a solution that shows the power and simplicity of Web2py. I also added a form to enter new posts. Tested.

这是一个显示Web2py功能和简单性的解决方案。我还添加了一个表单来输入新帖子。测试。

IN MODEL (models/posts.py):

IN MODEL(models / posts.py):

post_categories = ['Computer', 'Electronics', 'Cars', 'Video Games']

db.define_table('posts',
    Field('title', requires=IS_NOT_EMPTY()),  
    Field('interests'),  
    Field('category', requires=IS_IN_SET(post_categories)),
    Field('body', "text")
    )

IN VIEW (views/default/posts.html):

在视图中(views / default / posts.html):

{{include 'web2py_ajax.html'}}


   
    (Select Category)

    {{for item in post_categories:}}

    {{=item}}

    {{pass}}

 


{{=form}}

{{=LOAD('default','posts_load', vars=dict(category=item_selected), target='posts-ajax', ajax=True)}}

IN VIEW (views/default/posts_load.html):

在视图中(views / default / posts_load.html):

{{for post in post_rows:}}

  Title: 
{{=post.title}}
  Post:  
{{=post.body}}

{{pass}}

IN CONTROLLER (controllers/default.py):

IN CONTROLLER(controllers / default.py):

"""
Usage:

http:/localhost/default/posts
-- or --
http:/localhost/default/posts?category=Computer
"""
def posts():

    # if category is specified in the url vars, use it otherwise use 'Computer'
    item_selected = request.vars.get('category', 'Computer')

    # or you could use the first one in the list:
    #item_selected = request.vars.get('category', post_categories[0])

    """
    creates the form
    processes new posts; posts() function called again on form submit via ajax
    the response.js refreshes form after ajax post
    """
    form=SQLFORM(db.posts).process()
    response.js = "jQuery('#posts-ajax').get(0).reload();"

    """
    you don't need to pass "post_categories = post_categories" in the dict
    because the view can see the variables defined in the models it runs
    """
    return dict(
                form = form,
                item_selected = item_selected
                )

def posts_load():

    category = request.vars.get('category', '')

    if category:

        post_rows = db(db.posts.category==category).select()

    else:

        post_rows = db(db.posts).select()

    return post_rows