If there is anything stupid here Anthony, please remember I am a novice at
this!
db.define_table('invoice',
Field( 'invoice_number' , 'integer' , writable=False),
Field( 'company' , writable=False),
Field( 'amount' , 'decimal(6,2)' , writable=False),
Field( 'issue_date' , 'datetime' , writable=False),
Field( 'status' ,
default='ISSUED',requires=IS_IN_SET(INVOICE_STATUS)),
Field( 'payment_ref' , writable=False),
Field( 'payment_amount' , 'double'),
Field( 'notes' , 'text',default=None ),
Field( 'created_by' , db.auth_user , default=me , readable=False ,
writable=False),
Field( 'created_on' , 'datetime' , default=request.now ,
readable=False , writable=False),
format='%(invoice_number)s - %(company)s - %(status)s - %(date)s')
db.define_table('task',
Field( 'task_type' , default='COUNSELLING' ,
requires=IS_IN_SET(TASK_TYPES) , comment="*" ),
Field( 'task_status' , default='CLIENT CONFIRMED' ,
requires=IS_IN_SET(TASK_STATUS) , comment="*"),
Field( 'start_time' , 'datetime' , default=request.now
,requires=IS_NOT_EMPTY() , comment="*"),
Field( 'duration' , default='1Hr' ),
Field( 'title' , default="Session ##" , requires=IS_NOT_EMPTY() ,
comment="*"),
Field( 'person' , 'reference person' , comment="*"),
Field( 'details' , 'text' ,default=None ),
Field( 'charge' , 'double' , default=0.0),
Field( 'charge_to' , default='COMPANY' ,
requires=IS_IN_SET(CHARGE_TO) , comment="* [COMPANY for Invoicing, CONTACT
for Receipting]"),
Field( 'payment_status' , default='BILLABLE' ,
requires=IS_IN_SET(PAYMENT_STATUS) , comment="* [BILLABLE for Invoicing &
Receipting]"),
Field( 'invoice_number' , 'integer' , default=None , writable=False ),
Field( 'payment_ref' , 'integer',default=None , writable=False ),
Field( 'created_by' , db.auth_user , default=me , writable=False ,
readable=False ),
Field( 'created_on' , 'datetime' , default=request.now , writable=False
, readable=False ),
format= '%(person)s / %(start_time)s / %(title)s / € %(charge)s')
--
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.
