Re: [Openledger-developer] Impl. of "general ledger transaction"

[Tony F. <to...@sy...>]

On Wed, 2005-03-02 at 10:48, Klavs Klavsen wrote:
> Also I can't see why his post_transaction funtion does so many selects,
> when posting a transaction (AFAIK) only touches two tables - gl and
> acc_trans.

Umm... Am I missing somthing? post_transaction() only does 1 SELECT.

> I must be missing something.

Maybe you missed the start of the all_transactions() function. There's
lots of selects in there.

> In my head, you'd just insert in the gl table - get the assigned ID, and
> use that when posting the transactionlines (that'll be another object
> just as InvoiceLines I guess ;)

Yup, that's what post_transaction() does.

> I'd be very happy if you could tell me what I'm missing?
> It does ofcourse save the employee ID of the user who posted it.
> 
> What should we do with that - just let it be parameter to the
> postTransaction function? Or should we build a login scheme of some sort
> for the API (seems a bit hmm.. to me)?

For now I think you could ignore it but the API seems like the right
place for security to me. There's no sense reinventing the wheel every
time you integrate a new application or create a new GUI.

-- 
Tony Fraser
to...@sy...
Sybaspace Internet Solutions                        System Administrator
phone: (250) 246-5368                                fax: (250) 246-5398