web-erp-developers — Discussion on development of webERP

Re: [Web-erp-developers] Gettextification

[skaill <sk...@ro...>]

Here's Locations...

Note that the printf line in this file was definitely incorrect before I
started.  It really needs to be fixed by someone who knows this code.

Steve

----- Original Message ----- 
From: "Phil Daintree" <we...@pa...>
To: <web...@li...>
Sent: Tuesday, September 21, 2004 6:52 AM
Subject: [Web-erp-developers] Gettextification


> Thanks Jake - I found GLJournal.php too and have them all 6 safely
> committed to CVS.
>
> Steve - you have only a couple left
>
> COGSGLPostings.php Steve
> CompanyPreferences.php Steve
>
> I think your 20 script target is abitious and a potential OOS problem!!
> However, in case you get fired up here's a couple more ....
>
>
> Locations.php Steve
> Logout.php Steve
> MailInventoryValuation.php Steve - this has an include for the page
> header I think too.
> MailSalesReport.php Steve
>
>
> Actually some of these scripts are pretty small - I think we have takled
> the toughies up front!!
>
> Phil
>
>
>
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
> Project Admins to receive an Apple iPod Mini FREE for your judgement on
> who ports your project to Linux PPC the best. Sponsored by IBM.
> Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: [Web-erp-developers] Gettextification

[skaill <sk...@ro...>]

Here's MailSalesReport...

What about MailSalesReport_csv?

Also, I don't have to now include LanguageSetup.php at the top of each
script do I?  I mean it is still called in config, isn't it?

Steve

----- Original Message ----- 
From: "Phil Daintree" <we...@pa...>
To: <web...@li...>
Sent: Tuesday, September 21, 2004 6:52 AM
Subject: [Web-erp-developers] Gettextification


> Thanks Jake - I found GLJournal.php too and have them all 6 safely
> committed to CVS.
>
> Steve - you have only a couple left
>
> COGSGLPostings.php Steve
> CompanyPreferences.php Steve
>
> I think your 20 script target is abitious and a potential OOS problem!!
> However, in case you get fired up here's a couple more ....
>
>
> Locations.php Steve
> Logout.php Steve
> MailInventoryValuation.php Steve - this has an include for the page
> header I think too.
> MailSalesReport.php Steve
>
>
> Actually some of these scripts are pretty small - I think we have takled
> the toughies up front!!
>
> Phil
>
>
>
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
> Project Admins to receive an Apple iPod Mini FREE for your judgement on
> who ports your project to Linux PPC the best. Sponsored by IBM.
> Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Fw: [Web-erp-developers] Gettextification

[skaill <sk...@ro...>]

Again, use this one instead...

----- Original Message ----- 
From: "skaill" <sk...@ro...>
To: <web...@li...>
Sent: Tuesday, September 21, 2004 10:06 AM
Subject: Re: [Web-erp-developers] Gettextification


> Here's MailInventoryValuation...
>
> A bit foggy about whether I should have changed the mail->setFrom at near
> the end. I believe it's just the name that appears in email so that
> 'Postmaster' should be translated...
>
> Steve
>
> ----- Original Message ----- 
> From: "Phil Daintree" <we...@pa...>
> To: <web...@li...>
> Sent: Tuesday, September 21, 2004 6:52 AM
> Subject: [Web-erp-developers] Gettextification
>
>
> > Thanks Jake - I found GLJournal.php too and have them all 6 safely
> > committed to CVS.
> >
> > Steve - you have only a couple left
> >
> > COGSGLPostings.php Steve
> > CompanyPreferences.php Steve
> >
> > I think your 20 script target is abitious and a potential OOS problem!!
> > However, in case you get fired up here's a couple more ....
> >
> >
> > Locations.php Steve
> > Logout.php Steve
> > MailInventoryValuation.php Steve - this has an include for the page
> > header I think too.
> > MailSalesReport.php Steve
> >
> >
> > Actually some of these scripts are pretty small - I think we have takled
> > the toughies up front!!
> >
> > Phil
> >
> >
> >
> >
> >
> >
> > -------------------------------------------------------
> > This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
> > Project Admins to receive an Apple iPod Mini FREE for your judgement on
> > who ports your project to Linux PPC the best. Sponsored by IBM.
> > Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php
> > _______________________________________________
> > Web-erp-developers mailing list
> > Web...@li...
> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

Re: [Web-erp-developers] Gettextification

[skaill <sk...@ro...>]

Here's MailInventoryValuation...

A bit foggy about whether I should have changed the mail->setFrom at near
the end. I believe it's just the name that appears in email so that
'Postmaster' should be translated...

Steve

----- Original Message ----- 
From: "Phil Daintree" <we...@pa...>
To: <web...@li...>
Sent: Tuesday, September 21, 2004 6:52 AM
Subject: [Web-erp-developers] Gettextification


> Thanks Jake - I found GLJournal.php too and have them all 6 safely
> committed to CVS.
>
> Steve - you have only a couple left
>
> COGSGLPostings.php Steve
> CompanyPreferences.php Steve
>
> I think your 20 script target is abitious and a potential OOS problem!!
> However, in case you get fired up here's a couple more ....
>
>
> Locations.php Steve
> Logout.php Steve
> MailInventoryValuation.php Steve - this has an include for the page
> header I think too.
> MailSalesReport.php Steve
>
>
> Actually some of these scripts are pretty small - I think we have takled
> the toughies up front!!
>
> Phil
>
>
>
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
> Project Admins to receive an Apple iPod Mini FREE for your judgement on
> who ports your project to Linux PPC the best. Sponsored by IBM.
> Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: [Web-erp-developers] wegs-erp

[Stins, D. <DR...@Zi...>]

sounds allright.
----- Original Message -----
From: "Jake Stride" <ns...@us...>
To: <web...@li...>
Sent: Tuesday, September 21, 2004 2:18 PM
Subject: Re: [Web-erp-developers] wegs-erp


> oh right, but they are not all stored with in a single table?
>
> EGS concept of branches are slightly different, there are complete
> company entities in themselves, but are attached to parent companies in
> a tree structure.
>
> Jake
>
> Phil Daintree wrote:
> > Almost - there is one billing address - but there can be any number of
> > branch delivery addresses.
> >
> > The same is mirrored with suppliers one head office/admin but many
> > contacts.
> >
> > On Tue, 2004-09-21 at 21:33, Jake Stride wrote:
> >
> >>I have been looking through the weberp database this morning and one of
> >>the main differences that I have come across between weberp and EGS is
> >>the representation of contact details (ie address/phone/fax/email/etc).
> >>
> >>In weberp am I right in saying that a company has one address, whereas
> >>in EGS a company can have as many 'contacts' as you like since they are
> >>stored in a different table. Along with each 'contact' the type of
> >>'contact' can be set, so for example, when you add a company with an
> >>address, the address is automatically set as the default for
> >>billing/shipping/payment/technical/main, then when you add more
> >>addresses you can change which is assigned for each, so a company can
> >>easily have a different address for billling and shipping, and this can
> >>be pulled from the DB without the user having to select it for the
company.
> >>
> >>What are peoples opinions on this method of address/contact handling?
> >>
> >>Thanks
> >>
> >>Jake
> >>
> >>
> >>-------------------------------------------------------
> >>This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
> >>Project Admins to receive an Apple iPod Mini FREE for your judgement on
> >>who ports your project to Linux PPC the best. Sponsored by IBM.
> >>Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php
> >>_______________________________________________
> >>Web-erp-developers mailing list
> >>Web...@li...
> >>https://lists.sourceforge.net/lists/listinfo/web-erp-developers
> >>
> >
> >
> >
> >
> > -------------------------------------------------------
> > This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
> > Project Admins to receive an Apple iPod Mini FREE for your judgement on
> > who ports your project to Linux PPC the best. Sponsored by IBM.
> > Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php
> > _______________________________________________
> > Web-erp-developers mailing list
> > Web...@li...
> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
> Project Admins to receive an Apple iPod Mini FREE for your judgement on
> who ports your project to Linux PPC the best. Sponsored by IBM.
> Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers

[Web-erp-developers] Multilanguage

[skaill <sk...@ro...>]

Jake, make sure when changing scripts for Multilanguage that you =
separate leading and trailing blanks and punctuation so that the string =
to be translated is "pure".  Also, we must separate the variables out of =
strings so that they become string pieces concatenated with variables.  =
Try to make the pure strings single quoted. e.g.

"Thank you, $userid, for using webERP"

becomes

'Thank you' . ', ' . $userid . ', ' . 'for using webERP'

Steve

Re: [Web-erp-developers] Gettextification

[skaill <sk...@ro...>]

Here's Logout with diff...

Steve

----- Original Message ----- 
From: "Phil Daintree" <we...@pa...>
To: <web...@li...>
Sent: Tuesday, September 21, 2004 6:52 AM
Subject: [Web-erp-developers] Gettextification


> Thanks Jake - I found GLJournal.php too and have them all 6 safely
> committed to CVS.
> 
> Steve - you have only a couple left
> 
> COGSGLPostings.php Steve
> CompanyPreferences.php Steve
> 
> I think your 20 script target is abitious and a potential OOS problem!!
> However, in case you get fired up here's a couple more ....
> 
> 
> Locations.php Steve
> Logout.php Steve
> MailInventoryValuation.php Steve - this has an include for the page
> header I think too.
> MailSalesReport.php Steve
> 
> 
> Actually some of these scripts are pretty small - I think we have takled
> the toughies up front!!
> 
> Phil
> 
> 
> 
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
> Project Admins to receive an Apple iPod Mini FREE for your judgement on
> who ports your project to Linux PPC the best. Sponsored by IBM.
> Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers

[Web-erp-developers] Fw: Issue with admin

[skaill <sk...@ro...>]

I checked the demo and it's fine but others who already have it =
installed may have this issue...just use your favorite database tool to =
entire a valid style such as "professional" into the user record in the =
Theme field.

Steve

----- Original Message -----=20
From: skaill=20
To: web...@li...=20
Sent: Tuesday, September 21, 2004 9:00 AM
Subject: Issue with admin


Phil,

When I log into my own copy of webERP as admin I don't get a style.  I =
can't set a style either because for some reason the userid does not get =
displayed when logged in as admin (css related?!).  This is due to my =
admin userid not having a valid style selected.  It would be nice in the =
code if it checked for a blank/valid style and if not defaulted to the =
one set in the config.

Steve

[Web-erp-developers] Release 3.0

[Chris B. <cb...@en...>]

When is the 3.0 Release coming out???
 
Chris

[Web-erp-developers] Multilanguage

[skaill <sk...@ro...>]

Another point when changing the code for Multilanguage...

Don't change any of the sql strings!!!

Steve

Re: [Web-erp-developers] Gettextification

[skaill <sk...@ro...>]

Could get RTS (Repetitive Translation Syndrome)!

----- Original Message ----- 
From: "Phil Daintree" <we...@pa...>
To: <web...@li...>
Sent: Tuesday, September 21, 2004 6:52 AM
Subject: [Web-erp-developers] Gettextification


> Thanks Jake - I found GLJournal.php too and have them all 6 safely
> committed to CVS.
> 
> Steve - you have only a couple left
> 
> COGSGLPostings.php Steve
> CompanyPreferences.php Steve
> 
> I think your 20 script target is abitious and a potential OOS problem!!
> However, in case you get fired up here's a couple more ....
> 
> 
> Locations.php Steve
> Logout.php Steve
> MailInventoryValuation.php Steve - this has an include for the page
> header I think too.
> MailSalesReport.php Steve
> 
> 
> Actually some of these scripts are pretty small - I think we have takled
> the toughies up front!!
> 
> Phil
> 
> 
> 
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
> Project Admins to receive an Apple iPod Mini FREE for your judgement on
> who ports your project to Linux PPC the best. Sponsored by IBM.
> Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers

[Web-erp-developers] Issue with admin

[skaill <sk...@ro...>]

Phil,

When I log into my own copy of webERP as admin I don't get a style.  I =
can't set a style either because for some reason the userid does not get =
displayed when logged in as admin (css related?!).  This is due to my =
admin userid not having a valid style selected.  It would be nice in the =
code if it checked for a blank/valid style and if not defaulted to the =
one set in the config.

Steve

Re: EGS/Postgresql - Was Re: [Web-erp-developers] Cheap

[skaill <sk...@ro...>]

Awesome.  It's in alpha now but I'll bet they will be stable soon.

----- Original Message ----- 
From: "Jesse Peterson" <je...@st...>
To: <web...@li...>
Sent: Monday, September 20, 2004 9:21 PM
Subject: Re: EGS/Postgresql - Was Re: [Web-erp-developers] Cheap


> eh, hem...
> http://pecl.php.net/package-search.php?pkg_name=pdo&bool=AND&submit=Search
> http://pecl.php.net/package/PDO_MYSQL
> http://pecl.php.net/package/PDO_PGSQL
>
> skaill wrote:
>
> >Good stuff.  I wonder if and when their plan is for mysql and postgresql.
> >Sounds like they're moving pretty fast.
> >
> >----- Original Message ----- 
> >From: "Stins, Dick" <DR...@Zi...>
> >To: <web...@li...>
> >Sent: Monday, September 20, 2004 5:52 PM
> >Subject: Re: EGS/Postgresql - Was Re: [Web-erp-developers] Cheap
> >
> >
> >
> >
> >>Hoi,
> >>
> >>I think you all wouldn't miss this article:
> >>
> >>
> >>
> >>
>
>http://www.oracle.com/technology/pub/articles/php_experts/otn_pdo_oracle5.h
t
> >
> >
> >>ml
> >>
> >>With best regards,
> >>
> >>Dick Stins
> >>
> >>
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
> Project Admins to receive an Apple iPod Mini FREE for your judgement on
> who ports your project to Linux PPC the best. Sponsored by IBM.
> Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: [Web-erp-developers] wegs-erp

[skaill <sk...@ro...>]

I believe one central pool of contact info is the way to handle all contacts
including potential (for sales), customer/client and supplier/vendor.

I think I read

Debtors Master - contains customer main/billing address.  Actually I would
separate main from billing even though they're almost always the same.

CustBranch - customer branch delivery addresses.  I'm assuming this means an
order can be made out at the branch level or at least address-wise.  Haven't
tried though.

Suppliers - vendor/supplier address.  You are buying from them so no need
for a bunch of contacts or shipping addresses.

My approach is also usually to have one pool of addresses and they are
connected wherever needed.  Same as what you have for EGS.  In this way if a
supplier was also a vendor then only one address is needed for both and
updating one updates the other automatically.  Also you could add other
types of addresses without building more address tables and functions for
them.  For instance if you bought huge equipment from a supplier and needed
to have their service department contacts it would be easy under this
design.

The main challenges besides locating where all contact info is in webERP
will be pooling that contact info and finding and modifying anywhere they
are used which will likely mainly be orders and reports.

Users, banks and even the company itself have addresses that should all
probably pull from the central addresses area.

At the same time another approach would be the low impact one that Phil
suggested where contact info from webERP is fired into EGS.  EGS would need
to fire back as well and that could be accomplished by having a weberp type
code fired along with the contact info from webERP and EGS stores that in a
table so that if the contact is updated in EGS then EGS knows which
area/record in webERP needs updating.  In this way there could be an
automated procedure to update the webERP side. This is seriously not the
best of methods though.  It is interfacing and interfacing fails in many
ways.  For instance if the technology that updates webERP is not functioning
and someone updates EGS then you are out of synch.  We're doing this
currently with a client because they refuse to give up on their old Lotus
system even though they have had a powerful all inclusive ERP system for a
few years now!

Steve

----- Original Message ----- 
From: "Jake Stride" <ns...@us...>
To: <web...@li...>
Sent: Tuesday, September 21, 2004 5:33 AM
Subject: Re: [Web-erp-developers] wegs-erp


> I have been looking through the weberp database this morning and one of
> the main differences that I have come across between weberp and EGS is
> the representation of contact details (ie address/phone/fax/email/etc).
>
> In weberp am I right in saying that a company has one address, whereas
> in EGS a company can have as many 'contacts' as you like since they are
> stored in a different table. Along with each 'contact' the type of
> 'contact' can be set, so for example, when you add a company with an
> address, the address is automatically set as the default for
> billing/shipping/payment/technical/main, then when you add more
> addresses you can change which is assigned for each, so a company can
> easily have a different address for billling and shipping, and this can
> be pulled from the DB without the user having to select it for the
company.
>
> What are peoples opinions on this method of address/contact handling?
>
> Thanks
>
> Jake
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
> Project Admins to receive an Apple iPod Mini FREE for your judgement on
> who ports your project to Linux PPC the best. Sponsored by IBM.
> Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: [Web-erp-developers] wegs-erp

[Jake S. <ns...@us...>]

oh right, but they are not all stored with in a single table?

EGS concept of branches are slightly different, there are complete 
company entities in themselves, but are attached to parent companies in 
a tree structure.

Jake

Phil Daintree wrote:
> Almost - there is one billing address - but there can be any number of
> branch delivery addresses.
> 
> The same is mirrored with suppliers one head office/admin but many
> contacts.
> 
> On Tue, 2004-09-21 at 21:33, Jake Stride wrote:
> 
>>I have been looking through the weberp database this morning and one of 
>>the main differences that I have come across between weberp and EGS is 
>>the representation of contact details (ie address/phone/fax/email/etc).
>>
>>In weberp am I right in saying that a company has one address, whereas 
>>in EGS a company can have as many 'contacts' as you like since they are 
>>stored in a different table. Along with each 'contact' the type of 
>>'contact' can be set, so for example, when you add a company with an 
>>address, the address is automatically set as the default for 
>>billing/shipping/payment/technical/main, then when you add more 
>>addresses you can change which is assigned for each, so a company can 
>>easily have a different address for billling and shipping, and this can 
>>be pulled from the DB without the user having to select it for the company.
>>
>>What are peoples opinions on this method of address/contact handling?
>>
>>Thanks
>>
>>Jake
>>
>>
>>-------------------------------------------------------
>>This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
>>Project Admins to receive an Apple iPod Mini FREE for your judgement on
>>who ports your project to Linux PPC the best. Sponsored by IBM.
>>Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php
>>_______________________________________________
>>Web-erp-developers mailing list
>>Web...@li...
>>https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
> 
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
> Project Admins to receive an Apple iPod Mini FREE for your judgement on
> who ports your project to Linux PPC the best. Sponsored by IBM.
> Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers

[Web-erp-developers] Gettextification

[Phil D. <we...@pa...>]

Thanks Jake - I found GLJournal.php too and have them all 6 safely
committed to CVS.

Steve - you have only a couple left

COGSGLPostings.php				Steve
CompanyPreferences.php				Steve

I think your 20 script target is abitious and a potential OOS problem!!
However, in case you get fired up here's a couple more ....


Locations.php					Steve
Logout.php					Steve
MailInventoryValuation.php			Steve - this has an include for the page
header I think too.
MailSalesReport.php				Steve


Actually some of these scripts are pretty small - I think we have takled
the toughies up front!!

Phil

Re: [Web-erp-developers] wegs-erp

[Phil D. <we...@pa...>]

Almost - there is one billing address - but there can be any number of
branch delivery addresses.

The same is mirrored with suppliers one head office/admin but many
contacts.

On Tue, 2004-09-21 at 21:33, Jake Stride wrote:
> I have been looking through the weberp database this morning and one of 
> the main differences that I have come across between weberp and EGS is 
> the representation of contact details (ie address/phone/fax/email/etc).
> 
> In weberp am I right in saying that a company has one address, whereas 
> in EGS a company can have as many 'contacts' as you like since they are 
> stored in a different table. Along with each 'contact' the type of 
> 'contact' can be set, so for example, when you add a company with an 
> address, the address is automatically set as the default for 
> billing/shipping/payment/technical/main, then when you add more 
> addresses you can change which is assigned for each, so a company can 
> easily have a different address for billling and shipping, and this can 
> be pulled from the DB without the user having to select it for the company.
> 
> What are peoples opinions on this method of address/contact handling?
> 
> Thanks
> 
> Jake
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
> Project Admins to receive an Apple iPod Mini FREE for your judgement on
> who ports your project to Linux PPC the best. Sponsored by IBM.
> Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
> 

Re: [Web-erp-developers] wegs-erp

[Jake S. <ns...@us...>]

I have been looking through the weberp database this morning and one of 
the main differences that I have come across between weberp and EGS is 
the representation of contact details (ie address/phone/fax/email/etc).

In weberp am I right in saying that a company has one address, whereas 
in EGS a company can have as many 'contacts' as you like since they are 
stored in a different table. Along with each 'contact' the type of 
'contact' can be set, so for example, when you add a company with an 
address, the address is automatically set as the default for 
billing/shipping/payment/technical/main, then when you add more 
addresses you can change which is assigned for each, so a company can 
easily have a different address for billling and shipping, and this can 
be pulled from the DB without the user having to select it for the company.

What are peoples opinions on this method of address/contact handling?

Thanks

Jake

Re: [Web-erp-developers] Session Bug

[Daintrees <p.d...@pa...>]

Thats a nuisance ....
Thanks Jake.

Phil

----- Original Message ----- 
From: "Jake Stride" <ns...@us...>
To: <web...@li...>
Sent: Tuesday, September 21, 2004 6:17 PM
Subject: [Web-erp-developers] Session Bug


> If you run web-erp on a server without cookies enabled (I do to test for 
> exactly the condition below), it fails because there is no ampersand 
> between the end of the session value and any other variables you may 
> append to the url.
> 
> With out going through each script and adjusting urls etc, I have given 
> the following patch some testing and it seems to work. It just appends 
> an ampersand to the end of the SID constant in session.inc:
> 
> 16,17d15
> <
> <     define("SID",SID."&amp;");
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
> Project Admins to receive an Apple iPod Mini FREE for your judgement on
> who ports your project to Linux PPC the best. Sponsored by IBM.
> Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
> 

[Web-erp-developers] Session Bug

[Jake S. <ns...@us...>]

If you run web-erp on a server without cookies enabled (I do to test for 
exactly the condition below), it fails because there is no ampersand 
between the end of the session value and any other variables you may 
append to the url.

With out going through each script and adjusting urls etc, I have given 
the following patch some testing and it seems to work. It just appends 
an ampersand to the end of the SID constant in session.inc:

16,17d15
<
<     define("SID",SID."&amp;");

Re: EGS/Postgresql - Was Re: [Web-erp-developers] Cheap

[Jesse P. <je...@st...>]

eh, hem...
http://pecl.php.net/package-search.php?pkg_name=pdo&bool=AND&submit=Search
http://pecl.php.net/package/PDO_MYSQL
http://pecl.php.net/package/PDO_PGSQL

skaill wrote:

>Good stuff.  I wonder if and when their plan is for mysql and postgresql.
>Sounds like they're moving pretty fast.
>
>----- Original Message ----- 
>From: "Stins, Dick" <DR...@Zi...>
>To: <web...@li...>
>Sent: Monday, September 20, 2004 5:52 PM
>Subject: Re: EGS/Postgresql - Was Re: [Web-erp-developers] Cheap
>
>
>  
>
>>Hoi,
>>
>>I think you all wouldn't miss this article:
>>
>>
>>    
>>
>http://www.oracle.com/technology/pub/articles/php_experts/otn_pdo_oracle5.ht
>  
>
>>ml
>>
>>With best regards,
>>
>>Dick Stins
>>    
>>

Re: [Web-erp-developers] wegs-erp

[Phil D. <we...@pa...>]

Hi Jake,

Thanks so much - practical help is much appreciated.

GLAccountInquiry.php
GLBalanceSheet.php
GLCodesInquiry.php
GLJournal.php
GLProfit_Loss.php

If you could send me a diff with the files that would be particularly
awesome!

Regards

Phil


On Tue, 2004-09-21 at 08:59, Jake Stride wrote:
> I can help do some scripts, if it is simply a case of putting _() around 
> echo statements, then I am sure if you send me a batch of scripts (ie 
> there names) to do I could find some time this week to convert some.
> 
> Jake
> 
> skaill wrote:
> 
> >We need everyone including myself to dive back into getting the
> >Multilanguage done.  I could do at least 20 scripts in a day but I might be
> >crazy by the end of it!
> >
> >Steve
> >

Re: EGS/Postgresql - Was Re: [Web-erp-developers] Cheap

[skaill <sk...@ro...>]

Good stuff.  I wonder if and when their plan is for mysql and postgresql.
Sounds like they're moving pretty fast.

----- Original Message ----- 
From: "Stins, Dick" <DR...@Zi...>
To: <web...@li...>
Sent: Monday, September 20, 2004 5:52 PM
Subject: Re: EGS/Postgresql - Was Re: [Web-erp-developers] Cheap


> Hoi,
>
> I think you all wouldn't miss this article:
>
>
http://www.oracle.com/technology/pub/articles/php_experts/otn_pdo_oracle5.ht
> ml
>
> With best regards,
>
> Dick Stins
> ----- Original Message -----
> From: "Jake Stride" <ns...@us...>
> To: <web...@li...>
> Sent: Monday, September 20, 2004 9:40 AM
> Subject: Re: EGS/Postgresql - Was Re: [Web-erp-developers] Cheap
>
>
> > Daintrees wrote:
> >
> > >You'll have to excuse my naievety (and poor spelling) since most of the
> > >native functions are similar in function but different in name for
> differing
> > >DBs why does one need such a lavish abstraction layer why won't a
> > >ConnectDB.inc calling the native C calls to connect directly for other
> DBs
> > >do the trick? This way we have ultimate performance minimum overhead!
> > >
> > >
> >
> > I think the reason for it is that this works in principle but not in
> > pratice.
> >
> >
> > Take for example inserting booleans into a database, postgres represents
> > them as 't' and 'f' whilst I believe mysql represents them as '1' and
> > '0', so already you would have to wirte a function to deal with this,
> > and on it goes until you have your own abstraction layer.
> >
> > If you are using auto_incrementing/serial fields for ids a database
> > abstraction layer can use the native functions for those dbs that
> > support it but implement its own functionality for those that don't,
> > therefore using a database abstraction layer you can simply call
> > $db->nextId('tablename')
> >
> > I think it is 6 of one half a dozen of the other, if you do not plan on
> > using to many advanced db features then the ConnectDB method is fine, on
> > the other hand you can let somebody else deal with the abstraction  who
> > has access to several DBs and a developer community that is working
> > solely on the task of database abstraction and not have to worry about
> > new features bugs etc yourself, simple upgrade the abstraction layer as
> > and when.
> >
> > I have taken some of my examples from
> > http://creole.phpdb.org/wiki/index.php?node=8 there point about quoting
> > is a good one too.
> >
> > Jake
> >
> > >I really don't understand why such lengths are necessary - the function
> > >calls are virtually one to one and even most of the parameters are the
> same.
> > >
> > >MS SQL Server
> > >
> > >mssql_connect
> > >mssql_fetch_array
> > >mssql_fetch_row
> > >mssql_data_seek
> > >
> > >
> > >MySql
> > >
> > >mysql_connect
> > >mysql_query
> > >mysql_fetch_array
> > >mysql_fetch_row
> > >mysql_data_seek
> > >
> > >Postgres
> > >
> > >pg_connect
> > >pg_query
> > >pg_fetch_array
> > >pg_fetch_row
> > >pg_data_seek
> > >
> > >
> > >Firebird/interbase
> > >
> > >ibase_connect
> > >ibase_query
> > >ibase_fetch_assoc
> > >ibase_fetch_row
> > >
> > >whoops there is no
> > >ibase_data_seek
> > >
> > >maybe I'm answering my own question!
> > >
> > >
> > >Phil
> > >
> > >
> > >----- Original Message -----
> > >From: "Jake Stride" <ns...@us...>
> > >To: <web...@li...>
> > >Sent: Monday, September 20, 2004 5:58 PM
> > >Subject: Re: EGS/Postgresql - Was Re: [Web-erp-developers] Cheap
> > >
> > >
> > >
> > >
> > >>Stins, Dick wrote:
> > >>
> > >>
> > >>
> > >>>Jake,
> > >>>
> > >>>Thanks for your comments.
> > >>>
> > >>>I am not a fan of pear:db. I prefer to use standard sql. That is
> already
> > >>>
> > >>>
> > >a
> > >
> > >
> > >>>big step for portability + the clean and mean weberp script
> > >>>
> > >>>
> > >ConnectDB.inc.
> > >
> > >
> > >>>So it should not be too hard to port web-erp to another db engine.
> > >>>
> > >>>
> > >>>
> > >>>
> > >>No to be honest neither am I, for reasons I won't bore you with it was
> > >>chosen at the start of the project and has persited through. Have you
> > >>had a look at
> > >>
> > >>http://creole.phpdb.org/
> > >>http://propel.phpdb.org/wiki/
> > >>
> > >>
> > >>
> > >>>Smarty might be interesting, but I am already glad when css is
optimal
> > >>>
> > >>>
> > >used.
> > >
> > >
> > >>>
> > >>>
> > >>This is the case with EGS, it just allows all of the presentation
logic
> > >>to be removed from the code base and allows people to be a lot more
> > >>flexible with the layout without having to trawl through the PHP code.
> > >>
> > >>
> > >>
> > >>>Multiple company support is interesting.
> > >>>
> > >>>
> > >>>
> > >>>
> > >>Yes this was one of the distinctions that was used to justify it over
> > >>simply contributing to an exisitng project since non of the others do
> > >>it. For this reason I am not sure if one of the Application Frameworks
> > >>would have worked due to its authentication system.
> > >>
> > >>Have you looked at http://www.binarycloud.com/
> > >>
> > >>
> > >>
> > >>>Does it also support ldap (nds)?
> > >>>
> > >>>
> > >>>
> > >>>
> > >>Not at present. My knowledge of ldap consists of the following:
> > >>
> > >>It exists
> > >>It is adirectory server
> > >>
> > >>I have always thought that it would be good to have it working with
ldap
> > >>but unfortunately I have not had the time to look into it. However
with
> > >>the present system I believe you can use PEAR:DB to connect to ldap so
> > >>may be possible.
> > >>
> > >>Thanks
> > >>
> > >>Jake
> > >>
> > >>
> > >>
> > >>>with best regards,
> > >>>
> > >>>Dick Stins
> > >>>
> > >>>----- Original Message -----
> > >>>From: "Jake Stride" <ns...@us...>
> > >>>To: <web...@li...>
> > >>>Sent: Sunday, September 19, 2004 7:41 PM
> > >>>Subject: Re: EGS/Postgresql - Was Re: [Web-erp-developers] Cheap
> > >>>
> > >>>
> > >>>
> > >>>
> > >>>
> > >>>
> > >>>>Stins, Dick wrote:
> > >>>>
> > >>>>
> > >>>>
> > >>>>
> > >>>>
> > >>>>>Jake,
> > >>>>>
> > >>>>>I think that common functions which are needed in weberp and in
your
> > >>>>>
> > >>>>>
> > >crm
> > >
> > >
> > >>>>>software should be encapsulated in classes, so you do not need to
> know
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>where
> > >>>
> > >>>
> > >>>
> > >>>
> > >>>>>the information is comming from (postgres or mysql).
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>At the moment it kind of should be in that it uses PEAR:DB for
> > >>>>
> > >>>>
> > >>>>
> > >>>>
> > >>>abstraction.
> > >>>
> > >>>
> > >>>
> > >>>
> > >>>>>When you want to
> > >>>>>integrate web-erp and your crm software, you still need to
integrate
> > >>>>>
> > >>>>>
> > >the
> > >
> > >
> > >>>>>authentication and the address books processing and ....
> > >>>>>The design of these issues should be loosely connected or we should
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>create
> > >>>
> > >>>
> > >>>
> > >>>
> > >>>>>one big project (wegs-erp?).
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>That could be interesting and worthwhile, is it something people may
> be
> > >>>>interested in?
> > >>>>
> > >>>>
> > >>>>
> > >>>>
> > >>>>
> > >>>>>The same for all your code which needs views. Those should be
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>encapsulated
> > >>>
> > >>>
> > >>>
> > >>>
> > >>>>>in classes, so it's easy to write an alternative for mysql
> > >>>>>(allthough when you are able to run mysql  with maxdb, then
probably
> > >>>>>
> > >>>>>
> > >you
> > >
> > >
> > >>>>>
> > >>>>>
> > >>>can
> > >>>
> > >>>
> > >>>
> > >>>
> > >>>>>use views).
> > >>>>>
> > >>>>>I even recommend to develop an architecture with:
> > >>>>>- front end layer
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>Smarty for templating
> > >>>>
> > >>>>
> > >>>>
> > >>>>
> > >>>>
> > >>>>>- business rule layer
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>System is written as classes
> > >>>>
> > >>>>
> > >>>>
> > >>>>
> > >>>>
> > >>>>>- database trigger layer
> > >>>>>- database layer
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>PEAR
> > >>>>
> > >>>>
> > >>>>
> > >>>>
> > >>>>
> > >>>>>This helps to be in control of you own code, reuse of code,
increase
> > >>>>>portability for you code (like porting to other databases: sql
> server,
> > >>>>>firebird, oracle).
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>EGS should work in oracle without much trouble because of PEAR:DB
> > >>>>
> > >>>>
> > >>>>
> > >>>>
> > >>>>
> > >>>>>An example of an architecture like this is:
> > >>>>>http://sourceforge.net/projects/seagull/
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>I did have a look at these, the problem is that EGS authentication
is
> > >>>>more complicated that this. It is written as an ASP application so
> that
> > >>>>several companies can use the same server/DB etc.
> > >>>>
> > >>>>IE in egs one company can login and create there own users and
groups
> > >>>>and insert data etc that another company cannot see.
> > >>>>
> > >>>>Jake
> > >>>>
> > >>>>
> > >>>>
> > >>>>
> > >>>>
> > >>>>>With best regards,
> > >>>>>
> > >>>>>Dick Stins
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>
> > >>>
> > >>>
> > >>>-------------------------------------------------------
> > >>>This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
> > >>>Project Admins to receive an Apple iPod Mini FREE for your judgement
on
> > >>>who ports your project to Linux PPC the best. Sponsored by IBM.
> > >>>Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php
> > >>>_______________________________________________
> > >>>Web-erp-developers mailing list
> > >>>Web...@li...
> > >>>https://lists.sourceforge.net/lists/listinfo/web-erp-developers
> > >>>
> > >>>
> > >>>
> > >>>
> > >>
> > >>-------------------------------------------------------
> > >>This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
> > >>Project Admins to receive an Apple iPod Mini FREE for your judgement
on
> > >>who ports your project to Linux PPC the best. Sponsored by IBM.
> > >>Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php
> > >>_______________________________________________
> > >>Web-erp-developers mailing list
> > >>Web...@li...
> > >>https://lists.sourceforge.net/lists/listinfo/web-erp-developers
> > >>
> > >>
> > >>
> > >
> > >
> > >
> > >-------------------------------------------------------
> > >This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
> > >Project Admins to receive an Apple iPod Mini FREE for your judgement on
> > >who ports your project to Linux PPC the best. Sponsored by IBM.
> > >Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php
> > >_______________________________________________
> > >Web-erp-developers mailing list
> > >Web...@li...
> > >https://lists.sourceforge.net/lists/listinfo/web-erp-developers
> > >
> > >
> >
> >
> >
> > -------------------------------------------------------
> > This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
> > Project Admins to receive an Apple iPod Mini FREE for your judgement on
> > who ports your project to Linux PPC the best. Sponsored by IBM.
> > Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php
> > _______________________________________________
> > Web-erp-developers mailing list
> > Web...@li...
> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
> Project Admins to receive an Apple iPod Mini FREE for your judgement on
> who ports your project to Linux PPC the best. Sponsored by IBM.
> Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: [Web-erp-developers] Translation

[skaill <sk...@ro...>]

Here is another about what to do with submits.  Basically translate the
value and not the name.  Also we have been eliminating the testing of a
certain value in the submit and just seeing if it is set instead.  This
works as long as there is only one value possible for the submit and
everywhere I have seen so far that is the case.

Steve

----- Original Message ----- 
From: "skaill" <sk...@ro...>
To: <web...@li...>
Sent: Thursday, September 02, 2004 7:22 AM
Subject: Re: [Web-erp-developers] Translation


> Sure, I think I can do those pages but I can only superficially test them
as
> I'm honestly not that familiar with those areas and may not know if I've
> introduced an error.  Unfortunately you may need to do some extended
testing
> if you want to have good confidence in all the translation code changes.
>
> After we do each section we should get someone who is using webERP and
wants
> translation to use it for a week or two to make sure there are no errors
> with what we've done.  After that, proceed to the next set.
>
> The types of changes we are making theoretically should not get us into
much
> trouble though.
>
> Although the value gets changed in the Submit (and other inputs) the name
> should remain the same to keep the code all in one language (English).
>
> One tricky circumstance is if 'Y' and 'N' have been used for boolean.
> These values get stored as data.  The data cannot be translated from Y or
N
> as stored or the logic test of if TestFlag == "Y" wouldn't work when you
> changed languages.  It would work if you changed the right half but only
for
> one language!  The best solution is to translate when displayed.
>
> It all has to do with display time as opposed to code logic.
>
> Steve
>
>
> ----- Original Message ----- 
> From: "Phil Daintree" <we...@pa...>
> To: <web...@li...>
> Sent: Thursday, September 02, 2004 6:28 AM
> Subject: [Web-erp-developers] Translation
>
>
> > Gentlemen,
> >
> > I have been having a play with gettext and have it working - it needs to
> > be enabled on your server.... if its not the system will product only
> > english. The CVS has a couple of strings in the italian messages.po for
> > the purposes I certainly would not vouch for the accuracy of the
> > translations !! However, clearly shows that it is going to work
> > brilliantly.... IF WE have the determination and staying power to
> > convert every string assigment/print statement and echo statement in the
> > whole system.
> >
> > Frankly, I am seriously daunted by the propsect and will not be able to
> > do it on my own.
> >
> > A few points about the conversion ...
> >
> > Page $title = _('Page Title'); should also be encapsulated in the get
> > text function.
> >
> > Single quotes ' are faster than double quotes " - PHP has to parse the
> > contents of double quotes for variable substitutions but doesn't for
> > single quotes. Strings that have variables in the middle and spaces or
> > html tags need to be broken up ideally eg.
> >
> > echo "<P>A long string full of $NumberOfCharacters characters";
> >
> > would need to be re-written as:
> >
> > echo '<P>' . _('A long string full of') . ' ' . $NumberOfCharacters . '
> > ' . _('characters');
> >
> > I think it would be better to avoid having html or trailing spaces in
> > the translation strings.
> >
> > Jessie Peterson made a modification to the DB_query function such that
> > the repetitive use of
> >
> > if (DB_error_no($db) !=0) { .....
> >
> > is no longer necessary - all you need to do is send DB_query the error
> > message as the 3rd parameter, the 4th parameter is the Debug message and
> > the 5th is whether the query is inside a transaction that should
> > rollback. This might be a good opportunity to tidy up calls to DB_query
> > to use these extra parameters too? This would take quite a bit of code
> > out of the scripts.
> >
> > Some submit buttons have their value checked - clearly the value of a
> > submit button - what is displayed on the face of it - will need to be
> > inside a gettext function call - so too must the comparison string eg.
> >
> > say a submit button named 'Search' is tested to see if it is hit - the
> > value of the button will need to be changed to the local language -
> > assuming the button is to have a local language label....
> >
> > if ($_POST['Search'] == _('Search Now')){
> >
> > Steve's approach to "eating the elephant" seemed good - lets break it
> > down to bite sized chunks ....
> >
> > I'll kick off with:
> >
> > AccountGroups.php
> > AgedDebtors.php
> > AgedSuppliers.php
> > Areas.php
> > BOMInquiry.php
> > BOMListing.php
> >
> > Steve - would you have a go at:
> >
> > BOMs.php
> > BankAccounts.php
> > BankMatching.php
> > BankReconciliation.php
> > COGSGLPostings.php
> > CompanyPreferences.php
> >
> > Luca - would you have a go at:
> >
> > ConfirmDispatchControlled_Invoice.php
> > ConfirmDispatch_Invoice.php
> > CreditItemsControlled.php
> > CreditStatus.php
> > Credit_Invoice.php
> > Currencies.php
> >
> > Rom - would you have a go at:
> >
> > CustEDISetup.php
> > CustWhereAlloc.php
> > CustomerBranches.php
> > CustomerInquiry.php
> > CustomerReceipt.php
> > CustomerTransInquiry.php
> >
> >
> > The major worry here is introducing new bugs so please test the scripts
> > individually and thoroughly before emailing me with them.
> >
> > Any other offers to help would be fantastic.
> >
> > Let me know if there are any other ideas or areas of ambiguity.
> >
> > If you need to see how to convert a script look at index.php or
> > UserSettings.php
> >
> > Phil
> >
> >
> >
> > -------------------------------------------------------
> > This SF.Net email is sponsored by BEA Weblogic Workshop
> > FREE Java Enterprise J2EE developer tools!
> > Get your free copy of BEA WebLogic Workshop 8.1 today.
> > http://ads.osdn.com/?ad_id=5047&alloc_id=10808&op=click
> > _______________________________________________
> > Web-erp-developers mailing list
> > Web...@li...
> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by BEA Weblogic Workshop
> FREE Java Enterprise J2EE developer tools!
> Get your free copy of BEA WebLogic Workshop 8.1 today.
> http://ads.osdn.com/?ad_id=5047&alloc_id=10808&op=click
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: EGS/Postgresql - Was Re: [Web-erp-developers] Cheap

[Stins, D. <DR...@Zi...>]

Hoi,

I think you all wouldn't miss this article:

http://www.oracle.com/technology/pub/articles/php_experts/otn_pdo_oracle5.ht
ml

With best regards,

Dick Stins
----- Original Message -----
From: "Jake Stride" <ns...@us...>
To: <web...@li...>
Sent: Monday, September 20, 2004 9:40 AM
Subject: Re: EGS/Postgresql - Was Re: [Web-erp-developers] Cheap


> Daintrees wrote:
>
> >You'll have to excuse my naievety (and poor spelling) since most of the
> >native functions are similar in function but different in name for
differing
> >DBs why does one need such a lavish abstraction layer why won't a
> >ConnectDB.inc calling the native C calls to connect directly for other
DBs
> >do the trick? This way we have ultimate performance minimum overhead!
> >
> >
>
> I think the reason for it is that this works in principle but not in
> pratice.
>
>
> Take for example inserting booleans into a database, postgres represents
> them as 't' and 'f' whilst I believe mysql represents them as '1' and
> '0', so already you would have to wirte a function to deal with this,
> and on it goes until you have your own abstraction layer.
>
> If you are using auto_incrementing/serial fields for ids a database
> abstraction layer can use the native functions for those dbs that
> support it but implement its own functionality for those that don't,
> therefore using a database abstraction layer you can simply call
> $db->nextId('tablename')
>
> I think it is 6 of one half a dozen of the other, if you do not plan on
> using to many advanced db features then the ConnectDB method is fine, on
> the other hand you can let somebody else deal with the abstraction  who
> has access to several DBs and a developer community that is working
> solely on the task of database abstraction and not have to worry about
> new features bugs etc yourself, simple upgrade the abstraction layer as
> and when.
>
> I have taken some of my examples from
> http://creole.phpdb.org/wiki/index.php?node=8 there point about quoting
> is a good one too.
>
> Jake
>
> >I really don't understand why such lengths are necessary - the function
> >calls are virtually one to one and even most of the parameters are the
same.
> >
> >MS SQL Server
> >
> >mssql_connect
> >mssql_fetch_array
> >mssql_fetch_row
> >mssql_data_seek
> >
> >
> >MySql
> >
> >mysql_connect
> >mysql_query
> >mysql_fetch_array
> >mysql_fetch_row
> >mysql_data_seek
> >
> >Postgres
> >
> >pg_connect
> >pg_query
> >pg_fetch_array
> >pg_fetch_row
> >pg_data_seek
> >
> >
> >Firebird/interbase
> >
> >ibase_connect
> >ibase_query
> >ibase_fetch_assoc
> >ibase_fetch_row
> >
> >whoops there is no
> >ibase_data_seek
> >
> >maybe I'm answering my own question!
> >
> >
> >Phil
> >
> >
> >----- Original Message -----
> >From: "Jake Stride" <ns...@us...>
> >To: <web...@li...>
> >Sent: Monday, September 20, 2004 5:58 PM
> >Subject: Re: EGS/Postgresql - Was Re: [Web-erp-developers] Cheap
> >
> >
> >
> >
> >>Stins, Dick wrote:
> >>
> >>
> >>
> >>>Jake,
> >>>
> >>>Thanks for your comments.
> >>>
> >>>I am not a fan of pear:db. I prefer to use standard sql. That is
already
> >>>
> >>>
> >a
> >
> >
> >>>big step for portability + the clean and mean weberp script
> >>>
> >>>
> >ConnectDB.inc.
> >
> >
> >>>So it should not be too hard to port web-erp to another db engine.
> >>>
> >>>
> >>>
> >>>
> >>No to be honest neither am I, for reasons I won't bore you with it was
> >>chosen at the start of the project and has persited through. Have you
> >>had a look at
> >>
> >>http://creole.phpdb.org/
> >>http://propel.phpdb.org/wiki/
> >>
> >>
> >>
> >>>Smarty might be interesting, but I am already glad when css is optimal
> >>>
> >>>
> >used.
> >
> >
> >>>
> >>>
> >>This is the case with EGS, it just allows all of the presentation logic
> >>to be removed from the code base and allows people to be a lot more
> >>flexible with the layout without having to trawl through the PHP code.
> >>
> >>
> >>
> >>>Multiple company support is interesting.
> >>>
> >>>
> >>>
> >>>
> >>Yes this was one of the distinctions that was used to justify it over
> >>simply contributing to an exisitng project since non of the others do
> >>it. For this reason I am not sure if one of the Application Frameworks
> >>would have worked due to its authentication system.
> >>
> >>Have you looked at http://www.binarycloud.com/
> >>
> >>
> >>
> >>>Does it also support ldap (nds)?
> >>>
> >>>
> >>>
> >>>
> >>Not at present. My knowledge of ldap consists of the following:
> >>
> >>It exists
> >>It is adirectory server
> >>
> >>I have always thought that it would be good to have it working with ldap
> >>but unfortunately I have not had the time to look into it. However with
> >>the present system I believe you can use PEAR:DB to connect to ldap so
> >>may be possible.
> >>
> >>Thanks
> >>
> >>Jake
> >>
> >>
> >>
> >>>with best regards,
> >>>
> >>>Dick Stins
> >>>
> >>>----- Original Message -----
> >>>From: "Jake Stride" <ns...@us...>
> >>>To: <web...@li...>
> >>>Sent: Sunday, September 19, 2004 7:41 PM
> >>>Subject: Re: EGS/Postgresql - Was Re: [Web-erp-developers] Cheap
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>>Stins, Dick wrote:
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>>Jake,
> >>>>>
> >>>>>I think that common functions which are needed in weberp and in your
> >>>>>
> >>>>>
> >crm
> >
> >
> >>>>>software should be encapsulated in classes, so you do not need to
know
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>where
> >>>
> >>>
> >>>
> >>>
> >>>>>the information is comming from (postgres or mysql).
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>At the moment it kind of should be in that it uses PEAR:DB for
> >>>>
> >>>>
> >>>>
> >>>>
> >>>abstraction.
> >>>
> >>>
> >>>
> >>>
> >>>>>When you want to
> >>>>>integrate web-erp and your crm software, you still need to integrate
> >>>>>
> >>>>>
> >the
> >
> >
> >>>>>authentication and the address books processing and ....
> >>>>>The design of these issues should be loosely connected or we should
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>create
> >>>
> >>>
> >>>
> >>>
> >>>>>one big project (wegs-erp?).
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>That could be interesting and worthwhile, is it something people may
be
> >>>>interested in?
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>>The same for all your code which needs views. Those should be
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>encapsulated
> >>>
> >>>
> >>>
> >>>
> >>>>>in classes, so it's easy to write an alternative for mysql
> >>>>>(allthough when you are able to run mysql  with maxdb, then probably
> >>>>>
> >>>>>
> >you
> >
> >
> >>>>>
> >>>>>
> >>>can
> >>>
> >>>
> >>>
> >>>
> >>>>>use views).
> >>>>>
> >>>>>I even recommend to develop an architecture with:
> >>>>>- front end layer
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>Smarty for templating
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>>- business rule layer
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>System is written as classes
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>>- database trigger layer
> >>>>>- database layer
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>PEAR
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>>This helps to be in control of you own code, reuse of code, increase
> >>>>>portability for you code (like porting to other databases: sql
server,
> >>>>>firebird, oracle).
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>EGS should work in oracle without much trouble because of PEAR:DB
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>>An example of an architecture like this is:
> >>>>>http://sourceforge.net/projects/seagull/
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>I did have a look at these, the problem is that EGS authentication is
> >>>>more complicated that this. It is written as an ASP application so
that
> >>>>several companies can use the same server/DB etc.
> >>>>
> >>>>IE in egs one company can login and create there own users and groups
> >>>>and insert data etc that another company cannot see.
> >>>>
> >>>>Jake
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>>With best regards,
> >>>>>
> >>>>>Dick Stins
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>
> >>>
> >>>
> >>>-------------------------------------------------------
> >>>This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
> >>>Project Admins to receive an Apple iPod Mini FREE for your judgement on
> >>>who ports your project to Linux PPC the best. Sponsored by IBM.
> >>>Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php
> >>>_______________________________________________
> >>>Web-erp-developers mailing list
> >>>Web...@li...
> >>>https://lists.sourceforge.net/lists/listinfo/web-erp-developers
> >>>
> >>>
> >>>
> >>>
> >>
> >>-------------------------------------------------------
> >>This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
> >>Project Admins to receive an Apple iPod Mini FREE for your judgement on
> >>who ports your project to Linux PPC the best. Sponsored by IBM.
> >>Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php
> >>_______________________________________________
> >>Web-erp-developers mailing list
> >>Web...@li...
> >>https://lists.sourceforge.net/lists/listinfo/web-erp-developers
> >>
> >>
> >>
> >
> >
> >
> >-------------------------------------------------------
> >This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
> >Project Admins to receive an Apple iPod Mini FREE for your judgement on
> >who ports your project to Linux PPC the best. Sponsored by IBM.
> >Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php
> >_______________________________________________
> >Web-erp-developers mailing list
> >Web...@li...
> >https://lists.sourceforge.net/lists/listinfo/web-erp-developers
> >
> >
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
> Project Admins to receive an Apple iPod Mini FREE for your judgement on
> who ports your project to Linux PPC the best. Sponsored by IBM.
> Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers