[web2py] powertable problem

2011-02-03 Thread ceriox 
hi all,
i'm testing powertable plugin but i can't make it work correctly (i
don't have the green plus icon for expand the row of a table item)
where is the problem?

this is my code:

def index():

Test powerTable

table = plugins.powerTable
table.datasource = db.auth_user
table.dtfeatures['sScrollY'] = '100%'
table.dtfeatures['sPaginationType'] = 'full_numbers'
table.headers = 'labels'
table.keycolumn = 'auth_user.id'
table.columns =
['auth_user.username','auth_user.first_name','auth_user.last_name']
table.showkeycolumn = False
table.uitheme = 'redmond'
table.extra = dict(
 
details={'detailscallback':URL('myfunction.load')}
   )

table = table.create()

return locals()

def myfunction():

return a custom object to be inserted in detail for table

obj = DIV()
obj.append(H1('Title for my details'))
obj.append(SQLFORM(db.auth_user))
obj.append(SQLTABLE(db(db.auth_user).select()))

return locals()

Re: [web2py] powertable problem

2011-02-03 Thread Kenneth Lundström 
Too me it sounds like you have a problem with getting the data that 
should be shown in details. If powertable never gets data that should be 
displayed it doen´t show the  green plus.


Why are you calling URL('myfunction.load') and not URL('myfunction')?


Kenneth


hi all,
i'm testing powertable plugin but i can't make it work correctly (i
don't have the green plus icon for expand the row of a table item)
where is the problem?

this is my code:

def index():
 
 Test powerTable
 
 table = plugins.powerTable
 table.datasource = db.auth_user
 table.dtfeatures['sScrollY'] = '100%'
 table.dtfeatures['sPaginationType'] = 'full_numbers'
 table.headers = 'labels'
 table.keycolumn = 'auth_user.id'
 table.columns =
['auth_user.username','auth_user.first_name','auth_user.last_name']
 table.showkeycolumn = False
 table.uitheme = 'redmond'
 table.extra = dict(

details={'detailscallback':URL('myfunction.load')}
)

 table = table.create()

 return locals()

def myfunction():
 
 return a custom object to be inserted in detail for table
 
 obj = DIV()
 obj.append(H1('Title for my details'))
 obj.append(SQLFORM(db.auth_user))
 obj.append(SQLTABLE(db(db.auth_user).select()))

 return locals()

Re: [web2py] powertable problem

2011-02-03 Thread Bruno Rocha 
Do you have the latest version of the plugin?

Demo app and newest plugin version in: https://bitbucket.org/rochacbruno/
powertable/downloads



Hi,

I could not reproduce your model, but here it is my example app running.

MODEL
db.define_table('category',
Field('name'),
)

db.define_table('product',
Field('category_id',db.category,
represent=lambda r:r.name,
requires=IS_IN_DB(db,db.category.id,'%(name)s')),
Field('name'),
Field('description'),
Field('price','double'),
Field('quantity','integer')
)
/MODEL

CONTROLLER
def index():

Test powerTable

table = plugins.powerTable
table.datasource = db.product

table.keycolumn = 'product.id'
table.showkeycolumn = False
table.extra = dict(
   details={'detailscallback':URL('*myfunction*.load')}
   )

table = table.create()

return locals()


def *myfunction*():

return a custom object to be inserted in detail for table

obj = DIV()
obj.append(H1('Title for my details'))
obj.append(SQLFORM(db.product))
obj.append(SQLTABLE(db(db.category).select()))
obj.append(A('powertable',_href='http://bitbucket.org/rochacbruno/
powertable'))

# return locals(), which has only one object 'obj'
return locals()
/CONTROLLER

*Screenshots*:

Table: http://awesomescreenshot.com/05d6rcxbc

Expanded details: http://awesomescreenshot.com/0706rcv8b

AjaxCallback: http://awesomescreenshot.com/08a6rd793



Demo app and newest plugin version in: https://bitbucket.org/rochacbruno/
powertable/downloads

*Note*: powerTable plugin is an alpha version, too much work in progress, I
am working to fix many issues people reported, any suggestion or help are
apreciated.

Thanks

--
Bruno Rocha
http://about.me/rochacbruno/bio


2011/2/3 ceriox cer...@gmail.com

 hi all,
 i'm testing powertable plugin but i can't make it work correctly (i
 don't have the green plus icon for expand the row of a table item)
 where is the problem?

 this is my code:

 def index():

Test powerTable

table = plugins.powerTable
table.datasource = db.auth_user
table.dtfeatures['sScrollY'] = '100%'
table.dtfeatures['sPaginationType'] = 'full_numbers'
table.headers = 'labels'
table.keycolumn = 'auth_user.id'
table.columns =
 ['auth_user.username','auth_user.first_name','auth_user.last_name']
table.showkeycolumn = False
table.uitheme = 'redmond'
table.extra = dict(

 details={'detailscallback':URL('myfunction.load')}
   )

table = table.create()

return locals()

 def myfunction():

return a custom object to be inserted in detail for table

obj = DIV()
obj.append(H1('Title for my details'))
obj.append(SQLFORM(db.auth_user))
obj.append(SQLTABLE(db(db.auth_user).select()))

return locals()