[web2py] smartgrid - still not resolving a problem

2011-12-15 Thread Adi 
I'm still trying to resolve my problem, and desperately need someone's help 
:)

When I try to add a new sku to a purchase order, I would like to 
prepopulate CPU field with the value from db.sku.cpu (determined by a 
dropdown).
http://127.0.0.1:8000/test/default/list_purchase_orders/purchase_order/po_sku.po_id/1/new/po_sku

Is it possible to do this through smartgrid, and how would I do it? Bellow 
is a short version of my code for this... I'm stuck... :(

#db.py
db.define_table('sku',
Field('sku_number', 'string', label=T('SKU #')),
Field('description', 'string', label=T('Description')),
Field('cpu', 'double'),
Field('note', 'text'), 
format='%(sku_number)s - %(description)s',
)

db.define_table('purchase_order',
Field('po_number', 'string'),
)

db.define_table('po_sku',
Field('sku_id', db.sku, label=T('SKU #')),
Field('po_id', db.purchase_order, label=T('Purchase Order 
#')),
Field('qty', 'integer'),
Field('cpu', 'double'),
)

# default.py
def list_purchase_orders():
db.purchase_order.id.readable = False

db.purchase_order['_plural'] = 'Purchase Orders'

grid=SQLFORM.smartgrid(db.purchase_order, details=True, 
links_in_grid=True, 
maxtextlengths={'purchase_order.po_number':15},
maxtextlength=20,
paginate=20, 
csv=False,
ui='jquery-ui',
user_signature=False, oncreate = auth.archive, 
onupdate=auth.archive)
return dict(grid=grid)

Re: [web2py] smartgrid - still not resolving a problem

2011-12-15 Thread Nik Go 
Try this:
db.po_sku.default=lambda v,r: db.sku[r.sku_id].cpu

On Friday, December 16, 2011, Adi wrote:

 I'm still trying to resolve my problem, and desperately need someone's
 help :)

 When I try to add a new sku to a purchase order, I would like to
 prepopulate CPU field with the value from db.sku.cpu (determined by a
 dropdown).

 http://127.0.0.1:8000/test/default/list_purchase_orders/purchase_order/po_sku.po_id/1/new/po_sku

 Is it possible to do this through smartgrid, and how would I do it? Bellow
 is a short version of my code for this... I'm stuck... :(

 #db.py
 db.define_table('sku',
 Field('sku_number', 'string', label=T('SKU #')),
 Field('description', 'string', label=T('Description')),
 Field('cpu', 'double'),
 Field('note', 'text'),
 format='%(sku_number)s - %(description)s',
 )

 db.define_table('purchase_order',
 Field('po_number', 'string'),
 )

 db.define_table('po_sku',
 Field('sku_id', db.sku, label=T('SKU #')),
 Field('po_id', db.purchase_order, label=T('Purchase Order
 #')),
 Field('qty', 'integer'),
 Field('cpu', 'double'),
 )

 # default.py
 def list_purchase_orders():
 db.purchase_order.id.readable = False

 db.purchase_order['_plural'] = 'Purchase Orders'

 grid=SQLFORM.smartgrid(db.purchase_order, details=True,
 links_in_grid=True,
 maxtextlengths={'purchase_order.po_number':15},
 maxtextlength=20,
 paginate=20,
 csv=False,
 ui='jquery-ui',
 user_signature=False, oncreate = auth.archive,
 onupdate=auth.archive)
 return dict(grid=grid)

Re: [web2py] smartgrid - still not resolving a problem

2011-12-15 Thread Adi 
i put it as suggested, but it didn't work... 

another problem is onchange', when a different value gets selected in 
dropdown how to pass the accompanying db.sku.cpu to db.po_sku.cpu field.

Re: [web2py] smartgrid - still not resolving a problem

2011-12-15 Thread Nik Go 
Ah .. so you want it processed as soon as the drop-down is selected? That
would need some Ajax magic.

On Friday, December 16, 2011, Adi wrote:

 i put it as suggested, but it didn't work...

 another problem is onchange', when a different value gets selected in
 dropdown how to pass the accompanying db.sku.cpu to db.po_sku.cpu field.