web-erp-developers — Discussion on development of webERP

Re: [Web-erp-developers] PostgreSQL

[Phil D. <ph...@du...>]

Jake,

The situation was that a new ConnectDB.inc needed to be written to use the
converted Postgres DB. I thought Danie had done this because he had a little
fun with the LastInsertID function. I sent you the files he submitted I
think. He was up to testing the Postgres DB against the SQL used in the
scripts - which should be pretty generic. However, extensive testing is
required of every function on every page under Postgres.

Danie has gone pretty quiet - haven't heard from him for a while - hope
everythings ok in South Africa for him.

Phil
----- Original Message -----
From: "Jake Stride" <jak...@se...>
To: <web...@li...>
Sent: Thursday, June 24, 2004 3:22 AM
Subject: [Web-erp-developers] PostgreSQL


> Hi I sent a message to the list a few weeks back regarding the status
> of the port to postgresql
> (http://sourceforge.net/mailarchive/
> forum.php?thread_id=4774751&forum_id=34088) and I was wondering if any
> progress has been made or if anybody could give me any pointers.
>
> I have tried to contact Danie, but have not received any feedback.
>
> Thanks
>
> Jake
>
>
>
> -------------------------------------------------------
> This SF.Net email sponsored by Black Hat Briefings & Training.
> Attend Black Hat Briefings & Training, Las Vegas July 24-29 -
> digital self defense, top technical experts, no vendor pitches,
> unmatched networking opportunities. Visit www.blackhat.com
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

[Web-erp-developers] PostgreSQL

[Jake S. <jak...@se...>]

Hi I sent a message to the list a few weeks back regarding the status  
of the port to postgresql  
(http://sourceforge.net/mailarchive/ 
forum.php?thread_id=4774751&forum_id=34088) and I was wondering if any  
progress has been made or if anybody could give me any pointers.

I have tried to contact Danie, but have not received any feedback.

Thanks

Jake

[Web-erp-developers] Service Industry Modifications

[Olwen W. <ol...@ha...>]

I'm starting work on this in earnest.

I'll send through changes as I make them.

I'll make the changes as uninvasive as possible, and will create a job 
record (same key as the sales order) to hold the additional data 
required for jobs.

There's several lookup tables to be created as well.

RE: [Web-erp-developers] Serial Stuff

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

Phil, many apologies in being no help the past few weeks since you =
started putting your serial work back out. I just got some help here, =
which should free me up to get some of this work done that both you & I =
are in need of.

jesse

> -----Original Message-----
> From: Phil Daintree [mailto:ph...@du...]
> Sent: Monday, June 07, 2004 04:42
> To: web...@li...
> Subject: [Web-erp-developers] Serial Stuff
>=20
>=20
> I have pretty well done this now except for ...
>=20
> ReverseGRN.php and the stock check functionality creating=20
> stock adjustments=20
> for  counted items. I am not sure how to progress with this.
>=20
> Any help with testing would be most appreciated.
>=20
> Phil
>=20
>=20
> -------------------------------------------------------
> This SF.Net email is sponsored by the new InstallShield X.
> From Windows to Linux, servers to mobile, InstallShield X is the one
> installation-authoring solution that does it all. Learn more and
> evaluate today! http://www.installshield.com/Dev2Dev/0504
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>=20

[Web-erp-developers] Serial Stuff

[Phil D. <ph...@du...>]

I have pretty well done this now except for ...

ReverseGRN.php and the stock check functionality creating stock adjustments 
for  counted items. I am not sure how to progress with this.

Any help with testing would be most appreciated.

Phil

Re: [Web-erp-developers] Service Industry work

[Olwen W. <ol...@ha...>]

I've been sitting and thinking about the requirements and was starting 
to think along similar lines.

I have to spec and quote the first stage.  I'll spend some time today 
looking at the contract area.

Theres several new tables to be created.  Steve wants to partially 
validate product (for repair) info to get better reporting, and because 
many repairs are third party warranty repairs.



Phil Daintree wrote:
> Olwen,
> 
> Been thinking about the requirments of the service company. I thought that in 
> fact when a customer calls them, they are not so much placing an order as 
> initiating a job. The tables for jobs already exist - albeit that some 
> alterations may be required and they are called "Contracts" not jobs. The 
> thinking here is that the details of the job are taken and the person for the 
> job allocated. The service-person doing the job would add the materials etc 
> that are required or have been consumed on the job together with a dummy part 
> for her time at whatever chargeout rate, once the job is fully defined and 
> the work is done it is converted to a sales order and invoiced.
> 
> I am thinking that creating a sales order without a part on it may not be 
> exactly what they are after - I think the scenario above might suit them 
> better - clearly Steve is the one to decide that.
> 
> Currently, a job (contract) requires a customer and branch to be selected and 
> in many cases the set up of a new customer would be required first. It 
> doesn't currently have a person responsible for follow up - this would need 
> to be added. Thought initially this might go together with work centres but 
> think maybe this is a separate table now?
> 
> It might be better to default some of the customer/branch input in a special 
> customer initiation screen that leads on to the (yet to be created) job set 
> up screen, to populate the job details (contracts table).
> 
> 
> Phil
> 
> 

[Web-erp-developers] Service Industry work

[Phil D. <ph...@du...>]

Olwen,

Been thinking about the requirments of the service company. I thought that in 
fact when a customer calls them, they are not so much placing an order as 
initiating a job. The tables for jobs already exist - albeit that some 
alterations may be required and they are called "Contracts" not jobs. The 
thinking here is that the details of the job are taken and the person for the 
job allocated. The service-person doing the job would add the materials etc 
that are required or have been consumed on the job together with a dummy part 
for her time at whatever chargeout rate, once the job is fully defined and 
the work is done it is converted to a sales order and invoiced.

I am thinking that creating a sales order without a part on it may not be 
exactly what they are after - I think the scenario above might suit them 
better - clearly Steve is the one to decide that.

Currently, a job (contract) requires a customer and branch to be selected and 
in many cases the set up of a new customer would be required first. It 
doesn't currently have a person responsible for follow up - this would need 
to be added. Thought initially this might go together with work centres but 
think maybe this is a separate table now?

It might be better to default some of the customer/branch input in a special 
customer initiation screen that leads on to the (yet to be created) job set 
up screen, to populate the job details (contracts table).


Phil

[Web-erp-developers] Serial stuff

[Phil D. <ph...@du...>]

Committed new scripts to cvs for StockAdjustmentsControlled.php and 
StockTransferControlled.php together with necessary changes in 
StockTransfers.php and StockAdjustments.php to effect serial and lot control 
on these transactions. Used two include scripts

Now have:

ReverseGRN
SelectCreditItems
CreditInvoice
Stock Check
Bulk stock transfers

Inquiry mods/new scripts to drill down from stock movements inquiry and stock 
status inquiry to see lots/serial nos involved / in stock.

All still to do. This is a misson and a half!! 

Are you happy with what we have here now Jesse? Anything I missed? 
Please would you mend the file upload stuff ?

Phil

[Web-erp-developers] Re: WebERP

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

Hi Nicolaus,

I have not explored the raft of differing standards. I only have a basic
knowledge that they exist. My company uses UN/EDIFACT standard messages.

UN/EDIFACT is the super-set on which EANCOM is based EANCOM covers 99.9% of
all potential data transfer requirements. My focus really has been on
pulling out the useful stuff from the other stuff which whilst cool does not
add significant value for most businesses. Larger businesses where volumes
of shipping advises and other more obscure EDI messages are in significant
enough volume to justify the pain, can pay for this stuff to be developed
specifically for them. However, all businesses need to be able to send and
receive orders and invoices so these have been my focus.

The company I work for is a member of EAN - the global body that administers
the unique company prefixes for barcodes. I obtained a copy of their EANCOM
EDI standard from the local EAN office on CD - they have them worldwide. I
also asked them if they were ok with me using their standard - I had no
reply. Their standard is widely used down-under as a more pragmatic sub-set
of the massive UN/EDIFACT standard which caters for more than the vast
majority of data requirements - it is still very extensive. Since EANCOM is
a subs-set of UN/EDIFACT, my code is therefore UN/EDIFACT compliant. The
documentation on EANCOM is massive the order message docs are over 100
pages.

What do you mean by an EDI server solution. If you mean like a VAN set up
that converts between all the various standards.... definitely not keen! I
am working to avoid VANs althogether, (I hate intermediaries with a passion)
I want to break the barriers to businesses talking directly to each other
this is why I have put such a lot of effort into EDI. It is a major mission
to code up these things. Several businesses with web-erp or other EANCOM EDI
software can send and receive orders electronically and send and receive
invoices automatically without the need for VANs. If you mean develop
web-erp further to make EDI available to the masses then yeap - lets go. I
have sending invoices sorted ... I think. I am 50% through receiving
purchase orders to create a sales order. I am yet to send purchase orders
and receive sales invoices - converting to purchase invoices, I don't think
I will attempt this one either unless someone desparately wants it.

I looked a long time - the longer the look the more daunting the prospect -
before embarking on this. In the end I just dived in. There is some other
open-source project which purports to do edi conversions. However, it is
complex - a packaged solution with all the complexity under the hood is what
is required in my view, just coding up the EDI messages in isolation from
the rest of the business logic is only half the story, the integration to
the back end of the business software will always be a mission.

Good luck with your project.

Phil

----- Original Message ----- 
From: "Nicolaus Sommer" <nic...@je...>
To: "'Daintrees'" <p.d...@pa...>
Sent: Friday, May 28, 2004 2:20 PM
Subject: RE: WebERP


> Dear Phil,
> I would love to, but I'm confused about all these EDI "standarts"
>
> EANCOM
> UN/CEFACT
> EDIFACT
> ASC X12
> ASC X12/XML
> HIPAA
> VICS
> UCS
>
> .... Some are related - others not - I have a hard time to find up to date
> specs.
>
> I'm a software developer and just start pre planning on EDI ...
> Would you be interested in (co)-developing a PHP/mySQL based EDI
processing
> server solution?
>
> Best regards,
> Nicolaus Sommer
>
>
> -----Original Message-----
> From: Daintrees [mailto:p.d...@pa...]
> Sent: Thursday, May 27, 2004 18:03
> To: nic...@je...
> Cc: web...@li...
> Subject: Re: WebERP
>
>
> > Q: To what standart is the EDI export/import programmed - do you have
> > any documentation for the implemented EDI interface?
>
> EANCOM
>
> There is some stuff in the latest manual - on CVS. Currently only invoices
> can be sent to customers using EDI - and I was looking for a beta tester
> (have I found one) to work with me to get EANCOM orders received going.
>
>
> Phil
>
>
>
>

[Web-erp-developers] Re: WebERP

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

> Q: To what standart is the EDI export/import programmed - do you have any
> documentation for the implemented EDI interface?

EANCOM

There is some stuff in the latest manual - on CVS. Currently only invoices
can be sent to customers using EDI - and I was looking for a beta tester
(have I found one) to work with me to get EANCOM orders received going.


Phil

RE: [Web-erp-developers] Serial Stuff

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

That sounds like about everything, though I'd have to double-check =
against my notes.

I know there is a ton of common code between all those things... =
abstraction and/or splitting sections out to included files was my =
answer to ease the pains of dealing with it all and ensuring =
functionality was the same across the board.=20

I believe some of those, like StockCheck and StockCounts may not be =
necessary to enable at a serial level... maybe so to get details, but I =
believe the initial info you want from them can be obtained from =
StockMoves.


jesse

> -----Original Message-----
> From: Phil Daintree [mailto:ph...@du...]
> Sent: Tuesday, May 25, 2004 06:55
> To: web...@li...
> Subject: [Web-erp-developers] Serial Stuff
>=20
>=20
> Commited the ConfirmDispatch_Inovoice.php script with the sql=20
> updates in it to=20
> effect the serial items movements and update to StockSerialItems.
>=20
> There's a disturbing number of other places to have=20
> batch/serial number=20
> selection facilities for:
>=20
> StockAdjustments
> StockTransfers
> The new StockLocTransferReceive
> CreditInvoice and SelectCreditItems
> ReverseGRN
>=20
> There is a lot of common code here too !
>=20
> Then there's the StockCheck functionality, StockCounts and =20
> comparison=20
> scripts...
>=20
> Have I missed anything Jesse?
>=20
> Phil
>=20
>=20
> -------------------------------------------------------
> This SF.Net email is sponsored by: Oracle 10g
> Get certified on the hottest thing ever to hit the market...=20
> Oracle 10g.=20
> Take an Oracle 10g class now, and we'll give you the exam FREE.
> http://ads.osdn.com/?ad_id=3D3149&alloc_id=3D8166&op=3Dclick
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>=20

[Web-erp-developers] Serial Stuff

[Phil D. <ph...@du...>]

Commited the ConfirmDispatch_Inovoice.php script with the sql updates in it to 
effect the serial items movements and update to StockSerialItems.

There's a disturbing number of other places to have batch/serial number 
selection facilities for:

StockAdjustments
StockTransfers
The new StockLocTransferReceive
CreditInvoice and SelectCreditItems
ReverseGRN

There is a lot of common code here too !

Then there's the StockCheck functionality, StockCounts and  comparison 
scripts...

Have I missed anything Jesse?

Phil

Re: [Web-erp-developers] Porting to postgres

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

Thanks for the files, I am have hit a couple of issues so far.

Firstly, how have people gotten around the issue of quoting strings? I
cannot even connect at present since the query:

SELECT FullAccess, CustomerID, LastVisitDate, PageSize, DefaultLocation,
BranchCode, ModulesAllowed, Blocked FROM WWW_Users WHERE UserID="demo" AND
Password="weberp"

Should be:

 SELECT FullAccess, CustomerID, LastVisitDate, PageSize, DefaultLocation,
BranchCode, ModulesAllowed, Blocked FROM WWW_Users WHERE UserID='demo' AND
Password='weberp'

For postgresql and so fails.

I also believe there is a bug in the connect file which means that if you
use a username/password to connect to postgres then it will not work:

The code starting at line 12-18 should read (notice the 'db' added so that
$user becomes $dbuser as in the config.php file):

if ( isset( $dbuser ) && ($dbuser != "") ) {
// if we have a user we need to use password if supplied
        $PgConnStr .= " user=".$dbuser;
        if ( isset( $dbpassword ) && ($dbpassword != "") ) {
                $PgConnStr .= " password=".$dbpassword;
        }
}

Thanks

Jake

On 24/5/04 11:58, "Phil Daintree" <ph...@du...> wrote:

> Jake,
> 
> These are the files that Danie has submitted (sent to your sourceforge email
> address) - the issue is there may be some areas that don't quite work yet!!
> Danie was working through them.
> 
> The script MYSQL2PGSQL.py is a python script to convert the current Mysql db
> dump to a pg sql dump. web-erp.psql is the output of a previous version 2.8 I
> think db. The script ConnectDB.pg.inc should replace the
> includes/ConnectDB.inc script for the pg db calls.
> 
> Phil
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: Oracle 10g
> Get certified on the hottest thing ever to hit the market... Oracle 10g.
> Take an Oracle 10g class now, and we'll give you the exam FREE.
> http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
> 

Re: [Web-erp-developers] Porting to postgres

[Phil D. <ph...@du...>]

Jake,

These are the files that Danie has submitted (sent to your sourceforge email 
address) - the issue is there may be some areas that don't quite work yet!! 
Danie was working through them.

The script MYSQL2PGSQL.py is a python script to convert the current Mysql db 
dump to a pg sql dump. web-erp.psql is the output of a previous version 2.8 I 
think db. The script ConnectDB.pg.inc should replace the 
includes/ConnectDB.inc script for the pg db calls.

Phil

[Web-erp-developers] Serial Stuff

[Phil D. <ph...@du...>]

Jesse,

I committed ...

ConfirmDispatchControlled_Invoice.php
ConfirmDispatch_Invoice.php;
DeliveryDetails.php;
includes/DefineCartClass.php;
includes/DefineSerialItems.php;

to cvs tonight ... these contain the mods to effect serial (and batch) item 
control and specifying the serial numbers/ batches and quantity from each 
dispatched on an invoice. Not done the sql updates and inserts for invoices 
yet.

I stuffed the file input stuff - dont understand this - need your help.

Phil

[Web-erp-developers] Porting to postgres

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

HI,

I am one of the lead developers working for a groupware/CRM system called
Enterprise Groupware System (EGS) - http://egs.sourceforge.net. We have come
across web-erp and are very interesting in porting/including it in our GPL'd
system.

I have emailed Phil already and he has pointed me in the direction of Danie
who is working on a port to postgresql. I was interested in the progress of
the port and would interested in helping out if there is still work to be
done.

Many Thanks

Jake

Re: [Web-erp-developers] Re: Serial Stuff

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

I have done a little work on DefineCartClass.inc and
ConfirmDispatchControlled_Invoice.php which is not in CVS - everything else
is.

Phil

----- Original Message ----- 
From: "Jesse Peterson" <je...@st...>
To: <web...@li...>
Sent: Monday, May 24, 2004 3:50 AM
Subject: Re: [Web-erp-developers] Re: Serial Stuff


> yeah, but I really liked the StockModules. Anywho, where is this code?
> cvs? not quite in cvs?
>
>
> Daintrees wrote:
>
> >Jesse,
> >
> >I've probably given you worst case up front. It will be quite refereshing
> >for you to see that most of your mods including DB_query, and
DefinePOClass,
> >DefineCartClass etc are all still in tact and it is definitely Jesse's
work
> >in there just verbosed out for the hard of programming!
> >
> >Very relieved your still with me on this!
> >
> >Phil
> >
> >
> >
> >-------------------------------------------------------
> >This SF.Net email is sponsored by: Oracle 10g
> >Get certified on the hottest thing ever to hit the market... Oracle 10g.
> >Take an Oracle 10g class now, and we'll give you the exam FREE.
> >http://ads.osdn.com/?ad_id=3149&alloc_id=8166&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: Oracle 10g
> Get certified on the hottest thing ever to hit the market... Oracle 10g.
> Take an Oracle 10g class now, and we'll give you the exam FREE.
> http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

Re: [Web-erp-developers] Re: Serial Stuff

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

yeah, but I really liked the StockModules. Anywho, where is this code? 
cvs? not quite in cvs?


Daintrees wrote:

>Jesse,
>
>I've probably given you worst case up front. It will be quite refereshing
>for you to see that most of your mods including DB_query, and DefinePOClass,
>DefineCartClass etc are all still in tact and it is definitely Jesse's work
>in there just verbosed out for the hard of programming!
>
>Very relieved your still with me on this!
>
>Phil
>
>
>
>-------------------------------------------------------
>This SF.Net email is sponsored by: Oracle 10g
>Get certified on the hottest thing ever to hit the market... Oracle 10g. 
>Take an Oracle 10g class now, and we'll give you the exam FREE.
>http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click
>_______________________________________________
>Web-erp-developers mailing list
>Web...@li...
>https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>  
>

[Web-erp-developers] Re: Serial Stuff

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

Jesse,

I've probably given you worst case up front. It will be quite refereshing
for you to see that most of your mods including DB_query, and DefinePOClass,
DefineCartClass etc are all still in tact and it is definitely Jesse's work
in there just verbosed out for the hard of programming!

Very relieved your still with me on this!

Phil

Re: [Web-erp-developers] Serial Stuff

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

That's almost amusing since I had the same feeling when I started into 
the code...
I'm still going to have to look at it and see if I can manage - I'm not 
certain that I can get myself into the habit of writing code as 
verbosely as you would like it, especially since I know I won't and 
don't want to with any other projects I have going...
We'll see how this works out....

jesse

Daintrees wrote:

>Jesse,
>
>Thanks for your response....
>
>your comment
>
>'that works, isn't in my way, and I can work around it'
>
>is an aspect I did chew away on for a while. I have not made these changes
>lightly. Its like I felt I had a nice tidy room, then someone came and
>pulled all the toys out and left them lying around the room. I just couldn't
>live with it. The work is just not consistent with a mountain of code which
>already exists and I can't face re-writing it all consistently with your
>approach. I have to have it consistent throughout the application. I know I
>am wrong according to acedemia.
>
>Thanks so much for your understanding!
>
>Phil
>
>
>
>-------------------------------------------------------
>This SF.Net email is sponsored by: Oracle 10g
>Get certified on the hottest thing ever to hit the market... Oracle 10g. 
>Take an Oracle 10g class now, and we'll give you the exam FREE.
>http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click
>_______________________________________________
>Web-erp-developers mailing list
>Web...@li...
>https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>  
>

Re: [Web-erp-developers] Serial Stuff

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

Jesse,

Thanks for your response....

your comment

'that works, isn't in my way, and I can work around it'

is an aspect I did chew away on for a while. I have not made these changes
lightly. Its like I felt I had a nice tidy room, then someone came and
pulled all the toys out and left them lying around the room. I just couldn't
live with it. The work is just not consistent with a mountain of code which
already exists and I can't face re-writing it all consistently with your
approach. I have to have it consistent throughout the application. I know I
am wrong according to acedemia.

Thanks so much for your understanding!

Phil

RE: [Web-erp-developers] Serial Stuff

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

It sounds like we're back at the time I picked up WebERP except that it =
actually had some beginnings of Serialised support. I will have to look =
at how much it has changed since it sounds like you've taken my changes =
and basically rewritten them to better suit your views without much =
change in functionality before I can levy an opinion on it. Is this all =
in current CVS?

Remember that I was originially trying to give you a preview of where I =
was going with my work - it was not and is not a finished piece. The =
abstractions were done to simplify perusing the code in the various =
files and breakout functional pieces - I believe I mentioned that I =
found it quite cumbersome to wade through all the code, especially as =
horribly important code became intermingled with, say, HTML sections. =
They also were not completed.

I have to say that Dick made some quite valid points. I don't know PEAR, =
but following some recognized standard may help in readability. I think =
the problem arising between your and my coding is not something PEAR =
covers - it's more of a 'coding philosophy' thing, with my approach =
being mostly backed by recent computer science training. To that end, =
and in trying to not completely overwhelm you with changes, much of what =
I did was intended more for you to take at face value, as in 'that =
works, isn't in my way, and I can work around it'. I believe Dick more =
subtly hinted at that statement.

bottom line=20
	A) I need to see the changes.
	B) Either way, we must define how Serialised & Controlled stock must =
work to come close to staying on the same page. Your knowledge and =
apparent need/desire/ability to do this was one of the things that =
really attracted me to WE.
	C) I still like, have a great need for, and see great potential in this =
project, so I sincerly doubt you will see me just drop off.


jesse


> -----Original Message-----
> From: Stins, Dick [mailto:DR...@Zi...]
> Sent: Saturday, May 22, 2004 04:41
> To: web...@li...
> Subject: Re: [Web-erp-developers] Serial Stuff
>=20
>=20
> V
> ----- Original Message -----
> From: "Phil Daintree" <ph...@du...>
> To: <web...@li...>
> Sent: Saturday, May 22, 2004 6:28 AM
> Subject: [Web-erp-developers] Serial Stuff
>=20
> > Jesse,
> >
> > Your gonna be mad!
> >
> > I have done a fair bit on this and have GoodsReceived.php and
> > GoodsReceivedControlled.php going ok - with keyed input only at this
> stage.
> > The changed scripts are:
> >
> > GoodsReceived.php
> > Locations.php;
> > PO_Header.php;
> > PO_Items.php;
> > Stocks.php;
> > config.php;
> > doc/Change.log;
> > includes/ConnectDB.inc;
> > includes/DefinePOClass.php;
> > includes/PO_ReadInOrder.inc;
> > sql/upgrade2.8-2.9.sql;
> > sql/web-erp-demo.sql;
> > sql/web-erp-new.sql;
> > GoodsReceivedControlled.php;
> > includes/DefineSerialItems.php;
> >
> > I am a worried that you may not like what I have done to your serial
> stuff. I
> > really need help with this and if you bail on me now cos=20
> you dont agree
> with
> > my direction, I am in trouble. So, I am writing some pre-emptive
> explanations
> > ....
> >
> > web-erp has adopted a bunch of conventions which I am keen=20
> to ensure go
> right
> > through. I don't think other methods are wrong, just they are not
> consistent
> > with the style used here. Having adapted to those conventions it is
> > confusing, at least for me, to look at code written without=20
> using those
> > conventions. Consistency of application of these=20
> conventions throughout
> are
> > important to me. I have spelled these conventions out=20
> elsewhere in the
> > developers list. Perhaps for a younger mind this is=20
> probably a non-issue.
> >
> > I have worked through the GoodsReceivedControlled Code and=20
> notice that
> much of
> > the code for PO items received is actually in the=20
> StockModules - since it
> > will only ever be used from the goods received script I=20
> prefer all code
> > relating to that function to be in that one place so the=20
> reader doesn't
> have
> > to conceptualise through several stages of abstraction. I know the
> computer
> > scientists would choke on this, but if the code is not=20
> re-used or re-used
> > only once then the cost in terms of abstraction is too much=20
> (for me). I
> > concede that this is wrong and contrary to accepted wisdom=20
> - but I just
> can't
> > see it.
> Phil,
> When you use good names for intuitive=20
> functions/classes/method, then it
> should improve readability. Having not all code in the same=20
> script will
> improve quality, because only the changed code can raise new=20
> errors. So by
> splitting scripts, you will have a big advantage for the=20
> maintance, since
> you reduce the creation of errors and this will also reduce=20
> the testing
> effors.
> You allready accepted the concept of splitting scripts for=20
> readability,
> since you use include files, several scripts instead of one=20
> and only one
> script for web-erp.
> When you want an overall controlling coding standard, then=20
> please use the
> PEAR standards. I do also not like every detail in this standard, but
> adopting this standard will prevent discussions like this and=20
> might attract
> high qualified PEAR developers and prevents you and =20
> developers redoing
> coding.
> Since web-erp will be growing and growing, you finally will end with a
> system which can't be controlled by one person like you do=20
> now. To keep
> control over this project, you need a higher abstraction level and
> concentrate at business functions and component based=20
> development instead of
> bothering about coding details.
> Setting up new ideas for anarchitecture with a data ayer,=20
> business rule
> validations, ... might a much better improvement.
> Setting up development procedures might be effective:
> - functional/technical design/development conform standards (PEAR)
> - testing
> - releasing/configuration management (CVS)
>=20
> I am personnally more worried about bugs in WEB-ERP then=20
> different coding
> layout styles.
>=20
> with best regards,
> Dick
> >
> > The StockModules Stuff .....
> >
> > I see what you are doing allowing for alternative=20
> validation and separate
> > treatment of other types of stock - I so see the value in this
> approach....
> >
> > Information specific to the type of stock is stored in my=20
> stockcategory
> table
> > and perhaps the parameters for validation would be better=20
> held together
> with
> > other like information in that table, rather than hard=20
> coded and adding
> > another level of abstraction for those of us who suffer=20
> with them. I have
> not
> > coded up this but see no problem in doing so. Where=20
> specific additional
> > inserts for new tables peculiar to the business are=20
> required this will
> always
> > require modification of the code - I like to keep the code=20
> nice and simple
> so
> > other folks can grasp it and add their flourishes to it.
> >
> > When I took out the purchase order receive stuff from the
> GenericStockModule,
> > there really wasn't enough left to justify its existence.
> >
> > It was on this basis that I dumped the StockModules stuff. Instead I
> created a
> > DefineSerialItem.php object that just defines the data in=20
> the SerialItems
> > array and validates it before adding it - just as I did=20
> with the other
> > scripts using arrays of multiple variables.
> >
> > I have the GoodsReceivedControlled.php working for manual=20
> input/bar code -
> I
> > defaulted to manual input mode and lost the choices before input was
> > possible. I felt that from a users perspective this could be tedious
> having
> > to select an input method - before diving in with the input=20
> of serial nos.
> I
> > don't have the file input stuff going, this again looks a=20
> bit tough for
> me.
> > I've left it in - just commented it out - it needs some TLC=20
> from you - I
> > think I've broken it :-(
> >
> > The GoodsReceivedControlled.php screen is labelled=20
> specifically for either
> a
> > serialised item or a controlled (and not serialised) item.=20
> The links for
> > entry on the GoodsReceived.php script are also labelled=20
> appropriately. The
> > not serialiased option refers to a batch qty which is=20
> defaulted to 1 for
> > serialiased items. The quantites are accumulated=20
> automatically from the
> > inputs made directly into the GoodsReceived.php=20
> $_SESSION['PO']->LineItems
> > variable.
> >
> > I'd like to think that the foundations for Serial and batch=20
> control are
> now
> > firmly in place and we can code up the other scripts.
> >
> > I REALLY hope you are still behind me on this and can live=20
> with my mods!
> >
> > Phil
> >
> >
> > -------------------------------------------------------
> > This SF.Net email is sponsored by: Oracle 10g
> > Get certified on the hottest thing ever to hit the=20
> market... Oracle 10g.
> > Take an Oracle 10g class now, and we'll give you the exam FREE.
> > http://ads.osdn.com/?ad_id=3D3149&alloc_id=3D8166&op=3Dclick
> > _______________________________________________
> > Web-erp-developers mailing list
> > Web...@li...
> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>=20
>=20
>=20
>=20
> -------------------------------------------------------
> This SF.Net email is sponsored by: Oracle 10g
> Get certified on the hottest thing ever to hit the market...=20
> Oracle 10g.=20
> Take an Oracle 10g class now, and we'll give you the exam FREE.
> http://ads.osdn.com/?ad_id=3D3149&alloc_id=3D8166&op=3Dclick
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>=20

[Web-erp-developers] FASD project: Online survey launched

[<ben...@id...>]

Dear Open Source developer

I am doing a research project on "Fun and Software Development" in which I kindly invite you to participate.
You will find the online survey under http://fasd.ethz.ch/qsf/. The questionnaire consists of 53 questions and you will need about 15 minutes to complete it.

With the FASD project (Fun and Software Development) we want to define the motivational significance of fun when software developers decide to engage in Open Source projects. What is special about our research project is that a similar survey is planned with software developers in commercial firms. This procedure allows the immediate comparison between the involved individuals and the conditions of production of these two development models. Thus we hope to obtain substantial new insights to the phenomenon of Open Source Development.


With many thanks for your participation,
Benno Luthiger


PS:
The results of the survey will be published under http://www.isu.unizh.ch/fuehrung/blprojects/FASD/.
We have set up the mailing list fa...@we... for this study. Please see http://fasd.ethz.ch/qsf/mailinglist_en.html for registration to this mailing list.

_______________________________________________________________________

Benno Luthiger
Swiss Federal Institute of Technology Zurich
8092 Zurich

Mail: benno.luthiger(at)id.ethz.ch
_______________________________________________________________________

Re: [Web-erp-developers] Serial Stuff

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

V
----- Original Message -----
From: "Phil Daintree" <ph...@du...>
To: <web...@li...>
Sent: Saturday, May 22, 2004 6:28 AM
Subject: [Web-erp-developers] Serial Stuff

> Jesse,
>
> Your gonna be mad!
>
> I have done a fair bit on this and have GoodsReceived.php and
> GoodsReceivedControlled.php going ok - with keyed input only at this
stage.
> The changed scripts are:
>
> GoodsReceived.php
> Locations.php;
> PO_Header.php;
> PO_Items.php;
> Stocks.php;
> config.php;
> doc/Change.log;
> includes/ConnectDB.inc;
> includes/DefinePOClass.php;
> includes/PO_ReadInOrder.inc;
> sql/upgrade2.8-2.9.sql;
> sql/web-erp-demo.sql;
> sql/web-erp-new.sql;
> GoodsReceivedControlled.php;
> includes/DefineSerialItems.php;
>
> I am a worried that you may not like what I have done to your serial
stuff. I
> really need help with this and if you bail on me now cos you dont agree
with
> my direction, I am in trouble. So, I am writing some pre-emptive
explanations
> ....
>
> web-erp has adopted a bunch of conventions which I am keen to ensure go
right
> through. I don't think other methods are wrong, just they are not
consistent
> with the style used here. Having adapted to those conventions it is
> confusing, at least for me, to look at code written without using those
> conventions. Consistency of application of these conventions throughout
are
> important to me. I have spelled these conventions out elsewhere in the
> developers list. Perhaps for a younger mind this is probably a non-issue.
>
> I have worked through the GoodsReceivedControlled Code and notice that
much of
> the code for PO items received is actually in the StockModules - since it
> will only ever be used from the goods received script I prefer all code
> relating to that function to be in that one place so the reader doesn't
have
> to conceptualise through several stages of abstraction. I know the
computer
> scientists would choke on this, but if the code is not re-used or re-used
> only once then the cost in terms of abstraction is too much (for me). I
> concede that this is wrong and contrary to accepted wisdom - but I just
can't
> see it.
Phil,
When you use good names for intuitive functions/classes/method, then it
should improve readability. Having not all code in the same script will
improve quality, because only the changed code can raise new errors. So by
splitting scripts, you will have a big advantage for the maintance, since
you reduce the creation of errors and this will also reduce the testing
effors.
You allready accepted the concept of splitting scripts for readability,
since you use include files, several scripts instead of one and only one
script for web-erp.
When you want an overall controlling coding standard, then please use the
PEAR standards. I do also not like every detail in this standard, but
adopting this standard will prevent discussions like this and might attract
high qualified PEAR developers and prevents you and  developers redoing
coding.
Since web-erp will be growing and growing, you finally will end with a
system which can't be controlled by one person like you do now. To keep
control over this project, you need a higher abstraction level and
concentrate at business functions and component based development instead of
bothering about coding details.
Setting up new ideas for anarchitecture with a data ayer, business rule
validations, ... might a much better improvement.
Setting up development procedures might be effective:
- functional/technical design/development conform standards (PEAR)
- testing
- releasing/configuration management (CVS)

I am personnally more worried about bugs in WEB-ERP then different coding
layout styles.

with best regards,
Dick
>
> The StockModules Stuff .....
>
> I see what you are doing allowing for alternative validation and separate
> treatment of other types of stock - I so see the value in this
approach....
>
> Information specific to the type of stock is stored in my stockcategory
table
> and perhaps the parameters for validation would be better held together
with
> other like information in that table, rather than hard coded and adding
> another level of abstraction for those of us who suffer with them. I have
not
> coded up this but see no problem in doing so. Where specific additional
> inserts for new tables peculiar to the business are required this will
always
> require modification of the code - I like to keep the code nice and simple
so
> other folks can grasp it and add their flourishes to it.
>
> When I took out the purchase order receive stuff from the
GenericStockModule,
> there really wasn't enough left to justify its existence.
>
> It was on this basis that I dumped the StockModules stuff. Instead I
created a
> DefineSerialItem.php object that just defines the data in the SerialItems
> array and validates it before adding it - just as I did with the other
> scripts using arrays of multiple variables.
>
> I have the GoodsReceivedControlled.php working for manual input/bar code -
I
> defaulted to manual input mode and lost the choices before input was
> possible. I felt that from a users perspective this could be tedious
having
> to select an input method - before diving in with the input of serial nos.
I
> don't have the file input stuff going, this again looks a bit tough for
me.
> I've left it in - just commented it out - it needs some TLC from you - I
> think I've broken it :-(
>
> The GoodsReceivedControlled.php screen is labelled specifically for either
a
> serialised item or a controlled (and not serialised) item. The links for
> entry on the GoodsReceived.php script are also labelled appropriately. The
> not serialiased option refers to a batch qty which is defaulted to 1 for
> serialiased items. The quantites are accumulated automatically from the
> inputs made directly into the GoodsReceived.php $_SESSION['PO']->LineItems
> variable.
>
> I'd like to think that the foundations for Serial and batch control are
now
> firmly in place and we can code up the other scripts.
>
> I REALLY hope you are still behind me on this and can live with my mods!
>
> Phil
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: Oracle 10g
> Get certified on the hottest thing ever to hit the market... Oracle 10g.
> Take an Oracle 10g class now, and we'll give you the exam FREE.
> http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers

[Web-erp-developers] Serial Stuff

[Phil D. <ph...@du...>]

Jesse,

Your gonna be mad!

I have done a fair bit on this and have GoodsReceived.php and 
GoodsReceivedControlled.php going ok - with keyed input only at this stage. 
The changed scripts are:

GoodsReceived.php
Locations.php;
PO_Header.php;
PO_Items.php;
Stocks.php;
config.php;
doc/Change.log;
includes/ConnectDB.inc;
includes/DefinePOClass.php;
includes/PO_ReadInOrder.inc;
sql/upgrade2.8-2.9.sql;
sql/web-erp-demo.sql;
sql/web-erp-new.sql;
GoodsReceivedControlled.php;
includes/DefineSerialItems.php;

I am a worried that you may not like what I have done to your serial stuff. I 
really need help with this and if you bail on me now cos you dont agree with 
my direction, I am in trouble. So, I am writing some pre-emptive explanations 
....

web-erp has adopted a bunch of conventions which I am keen to ensure go right 
through. I don't think other methods are wrong, just they are not consistent 
with the style used here. Having adapted to those conventions it is 
confusing, at least for me, to look at code written without using those 
conventions. Consistency of application of these conventions throughout are 
important to me. I have spelled these conventions out elsewhere in the 
developers list. Perhaps for a younger mind this is probably a non-issue.

I have worked through the GoodsReceivedControlled Code and notice that much of 
the code for PO items received is actually in the StockModules - since it 
will only ever be used from the goods received script I prefer all code 
relating to that function to be in that one place so the reader doesn't have 
to conceptualise through several stages of abstraction. I know the computer 
scientists would choke on this, but if the code is not re-used or re-used 
only once then the cost in terms of abstraction is too much (for me). I 
concede that this is wrong and contrary to accepted wisdom - but I just can't 
see it.

The StockModules Stuff .....

I see what you are doing allowing for alternative validation and separate 
treatment of other types of stock - I so see the value in this approach....

Information specific to the type of stock is stored in my stockcategory table 
and perhaps the parameters for validation would be better held together with 
other like information in that table, rather than hard coded and adding 
another level of abstraction for those of us who suffer with them. I have not 
coded up this but see no problem in doing so. Where specific additional 
inserts for new tables peculiar to the business are required this will always 
require modification of the code - I like to keep the code nice and simple so 
other folks can grasp it and add their flourishes to it. 

When I took out the purchase order receive stuff from the GenericStockModule, 
there really wasn't enough left to justify its existence.

It was on this basis that I dumped the StockModules stuff. Instead I created a 
DefineSerialItem.php object that just defines the data in the SerialItems 
array and validates it before adding it - just as I did with the other 
scripts using arrays of multiple variables.

I have the GoodsReceivedControlled.php working for manual input/bar code - I 
defaulted to manual input mode and lost the choices before input was 
possible. I felt that from a users perspective this could be tedious having 
to select an input method - before diving in with the input of serial nos. I 
don't have the file input stuff going, this again looks a bit tough for me. 
I've left it in - just commented it out - it needs some TLC from you - I 
think I've broken it :-(

The GoodsReceivedControlled.php screen is labelled specifically for either a 
serialised item or a controlled (and not serialised) item. The links for 
entry on the GoodsReceived.php script are also labelled appropriately. The 
not serialiased option refers to a batch qty which is defaulted to 1 for 
serialiased items. The quantites are accumulated automatically from the 
inputs made directly into the GoodsReceived.php $_SESSION['PO']->LineItems 
variable.

I'd like to think that the foundations for Serial and batch control are now 
firmly in place and we can code up the other scripts.

I REALLY hope you are still behind me on this and can live with my mods!

Phil