Have you looked into:
http://www.vimeo.com/5432441
Wouldn't that be a better way to handle tabulated data with
dependencies?
I was planning to post an example of how to use that.
Massimo
On Jul 11, 7:29 am, "Francois (Jersey)"
<francois.ches...@googlemail.com> wrote:
> Reviewed chapter 7 Forms and validators.
>
> The chapter deals with multiple forms per page, however a more complex
> example would be useful.
>
> Let me explain the limitation of the current presentation. The example
> presented page 178 has a validation button for each form, but it is
> not possible to validate all forms simulateously through a single
> button.
>
> I would suggest creating a chapter 7.8 Case study
>
> Cse study would create a mini application taking advantages of all the
> material developed in chapter 7.
>
> The application would be the fondation for accounting which is a
> transaction which group together a number of accounting entries.
>
> an examples would be:
> Dr purchase 20
> Cr Cash 20
> date 01/01.2009
> comment: purchase of cream
>
> A transaction (called transac in our model) has at least 2 accounting
> entries (called transaction_line in our model), but can have more than
> 2. For example adding value sale tax at 20% would give the following
> entries
>
> Dr Cash 1,200
> Cr sale 1,000
> Cr creditor sale tax collected 1,200
> date:01/01/2009
> comment: sale of ice creams including sale tax at 20%
>
> The simplified model is:
>
> db.define_table('transac',
> SQLField('description', length=100),
> SQLField('date','date',default=now)
> )
>
> db.define_table('transaction_line',
> SQLField('transac', db.transac),
> SQLField('account',length=25),
> SQLField('amount_transaction', 'integer'),
> )
>
> db.transaction_line.transac.requires=IS_IN_DB
> (db,'transac.id','transac.description')
> db.transaction_line.amount_transaction.requires=IS_NOT_EMPTY()
>
> Please note the usual accounting convention that if amount_transaction
> is positive then it is a debit, and
>
> Then creation of the form becomes more tricky as some elements are
> related to the table transac and some other elements are linked to
> multiple entries in the table transaction_line.
>
> A visual example of form could be
>
> Date: [ ]
> Description:[ ]
>
> account amount
> [ ] [ ]
> [ ] [ ]
> [ ] [ ]
> [ ] [ ]
> [ ] [ ]
> [ ] [ ]
>
> The controller would be
> 1) if a line is empty (meaning all cells of the line are empty), then
> the line is ignored completely
> 2) if for a given line any cell has a value, then both account and
> amount should have a value else there is an error message
> 3) amount for any line should be different from 0
> 4) the sum of all amount (amount_transaction) for a given transaction
> should be equal to zero.
>
> Does the suggestion above sound a good idea to any of you?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
