« Return to Thread: autoincrementing invoices numbers

Re: autoincrementing invoices numbers

by Nathan Gray :: Rate this Message:

Reply to Author | View in Thread


On 4-May-09, at 3:15 AM, <cotanda@...> <cotanda@...>  
wrote:

> Hi, sorry for being so late, I was on holidays xD
>
>> A global variable would not persist or be available for everyone.
>> eGroupWare provides a table, egw_nextid, that lets you store the next
>> number in a particular sequence.
>
> I have a concern about the egw_nextid table. You should start from 0
> everytime you make a new installation or, if you want to have an  
> initial
> number, you should add a field on the ar (and ap, etc) site  
> configuration
> menu.

Starting from 0 is easy, but it's easy enough to make that configurable.

> Having a type field on the database would be not much space ...
>  The bad news on changing the database is that all the
> insert queries should be changed to add the new field

Not that hard, and a good idea.
Done in SVN r3434, new column is named 'class'.

> What do you think it would be more desirable? I would
> try with the egw_nextid while I wait for answer ^^

Adding the column was a good idea in general, so you have the option  
to do it whichever way works out best.

Nathan Gray
nathan at goarctic dot com


------------------------------------------------------------------------------
Register Now & Save for Velocity, the Web Performance & Operations
Conference from O'Reilly Media. Velocity features a full day of
expert-led, hands-on workshops and two days of sessions from industry
leaders in dedicated Performance & Operations tracks. Use code vel09scf
and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
_______________________________________________
Perp-developers mailing list
Perp-developers@...
https://lists.sourceforge.net/lists/listinfo/perp-developers

 « Return to Thread: autoincrementing invoices numbers