I have 3 table, Items, Client & Purchases, the Client table stores the
details of the customer, the items table has a list of sold items and
Purchases stores what the customer purchased on what day. I have a function
in the controller that allows the editing of Customer and Purchases details
in one view by clicking on the owner's name but i keep getting the *Object
not found *message caused an attempt at opening an edit for the Purchases
table, what am i doing wrong, is there a better way of doing this?
Regards
Mostwanted
*MODELS*
db.define_table('Customer',
Field('Name', requires=IS_NOT_EMPTY(), label=SPAN('First
Name', _style="font-weight: bold;")),
Field('Surname', requires=IS_NOT_EMPTY(), label=SPAN('Last
Name', _style="font-weight: bold;")),
Field('ID_Number', requirs=IS_NOT_EMPTY(), label=SPAN('Client
ID No', _style="font-weight: bold;")),
Field('Company', requirs=IS_NOT_EMPTY(), label=SPAN(
'Company', _style="font-weight: bold;")),format='%(Surname)s ),
db.define_table('Items',
Field('Item', requires=IS_NOT_EMPTY()),
format='%(Item)s')
db.define_table('Purchases',
Field('Client', 'reference Customer', label=SPAN('Client',
_style="font-weight: bold")),
Field('Item', 'reference Item', unique=True, label=SPAN('
Item Purchased', _style="font-weight: bold;")),
Field('Booking_Date', 'datetime', default=request.now,
writable=False, label=SPAN('Date of Registration', _style="font-weight:
bold;")),
Field('Serviced_By', 'reference auth_user',
default=auth.user_id, writable=False, label=SPAN('Serviced By',
_style="font-weight: bold;")))
*CONTROLLER*
def Client_Update():
client=db.Customer(request.args(0))
clientDetails=SQLFORM(db.Customer, client.id, deletable=True, showid=
False).process()
addRooms=SQLFORM(db.Purchases, client.id, deletable=True, showid=False).
process()
return locals()
*VIEW*
{{extend 'layout.html'}}
<div>
<span class="formTitle">VIEW & UPDATE CLIENT DETAILS</span>
{{=clientDetails}}
<hr />
<span class="formTitle">VIEW & UPDATE CLIENT PURCHASES</span>
{{=addRooms}}
</div>
{{pass}}
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
