1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.

db.define_table('fruit',
    Field('sortable','integer',default=0,writable=False,readable=False),
    Field('client',default=request.client,writable=False,readable=False),
    Field('name',requires=IS_NOT_EMPTY()))

my_fruits = db.fruit.client==request.client

if not db(my_fruits).count():
    db.fruit.client.default=request.client
    db.fruit.insert(name='Apple')
    db.fruit.insert(name='Melon')
    db.fruit.insert(name='Banana')
    db.fruit.insert(name='Strawberry')
    db.fruit.insert(name='Raspberry')

db.define_table('preference',
                Field('name'),
                Field('fruit',db.fruit))
db.preference.fruit.requires=IS_IN_DB(db(db.fruit.client==request.client),'fruit.id','%(name)s')

1.
2.
3.
4.
5.
6.

def index():
    fruits = db(my_fruits).select(orderby=db.fruit.sortable)
    return dict(fruits = fruits)

def sort():
    plugin_sortable_sort(db.fruit,query=my_fruits))

1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.

{{extend 'layout.html'}}
<style>
.sortable LI {
   width: 200px; background: orange; color: white;
   border: 2px solid white; padding: 5px 5px 5px 5px;
    -moz-border-radius: 5px; -webkit-border-radius: 5px;
    z-index: 2;
}
</style>

<h1>Plugin sortable demo</h1>
{{=plugin_sortable([(f.id,f.name) for f in fruits],callback=URL(r=request,f='sort'))}}