[WebERP-developers] Re: Final address changes

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

[WebERP-developers] Re: Final address changes

weberp

I've committed these address changes to CVS the code changes look sensible...
I just use kdiff to review the code changes - I have not tested on the
assumption that you have. eg Are the formats of reports ok and spaces allowed
for fields ok? Just makes me a little nervous since there are a lot of
scripts changed here.  I've not done the db "upgrade" yet - will crack into
tomorrow.

When you say form re-design do you mean creation of user defined reports? We
need to think about webERP's role in a business there are other tools for
reporting Jasper Reports I understand is good. MS Access is good too.

Or modifying the screens - a VB background perhaps ;-) We will never please
everyone there is nothing surer - that's why the canny prefer a smarty
template type thing so the users can muck about with form design till 'their
heart's content'. We've avoided the additional abstraction required till now.
My only concern is that I'm keen to keep the code as simple as possible.

Phil


On Wed, 28 Sep 2005 05:11, you wrote:

> Phil,
>
> Here are the final changes for the address upgrades, I have made most of
> the changes to the PDF headers but there may still be a few that I missed.
> I corrected the companies fields to match the other fields. Also, I have
> updated the weberp-new.sql, weberp-demo.sql and upgrade scripts with the
> changes so you don't have to merge them yourself.
>
> Dave
>
> Next, on to form redesign and enhancement! wahoo.

--
Phil Daintree
webERP Project Admin


-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
_______________________________________________
Web-erp-developers mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/web-erp-developers
Reply | Threaded
Open this post in threaded view
|

RE: [WebERP-developers] Re: Final address changes

Dave-34
Phil,

By re-design I mean that the current reports are separate files for each
report. If a change needs to be made to a different paper size (letter for
example), each file needs to be modified. If I want to print portrait
instead of landscape, this too requires diving into the code. Also, if I
wanted more fields, like addresses, more code changes. The growth of files
and maintenance hassles will continue to grow. I am working on a reports
manager (admin and user) that will standardize the forms and create a
database style reports system. My current plan is to create 'default'
reports that cannot be changed by the users. These default reports may be
customized by the user and saved as a separate report to meet their
particular needs. All in a database. I will create a few templates that will
display the reports and allow for several options to change the look and
data content. The goal here is that every user has their own demand for
certain information and order. The goal is not to recreate a report
generation application to create pretty charts and graphs. Just to extract
the desired information and handed off to jpgraph or other graphing program
to pretty up. I have laid out the framework and am working on a prototype
that everyone can look at when I get close. If it looks good to the
development team, I will integrate it into webERP. I think everyone will
like it. Not trying to get too fancy but trying to allow for improved
flexibility. Every country, company, accountant has their particulars when
looking at the reporting. I agree, we'll never meet everyone's needs but
right now, the current reporting would need significant modification to meet
the needs of my individual departments and my accountant.

Note: Have you given any thought about creating a deeper structure for the
scripts, i.e. /modules directory with /gl /ap & /ar subdirectories.
Everything now is at the root level but as this application continues to
evolve with the addition of a POS, cart interface, and more features, file
management will become increasingly complex.

PS What are you looking for in the VB background?

Dave

-----Original Message-----
From: [hidden email]
[mailto:[hidden email]]On Behalf Of Phil
Daintree
Sent: Wednesday, September 28, 2005 4:56 AM
To: PPS Customer Service
Cc: [hidden email]
Subject: [WebERP-developers] Re: Final address changes



I've committed these address changes to CVS the code changes look
sensible...
I just use kdiff to review the code changes - I have not tested on the
assumption that you have. eg Are the formats of reports ok and spaces
allowed
for fields ok? Just makes me a little nervous since there are a lot of
scripts changed here.  I've not done the db "upgrade" yet - will crack into
tomorrow.

When you say form re-design do you mean creation of user defined reports? We
need to think about webERP's role in a business there are other tools for
reporting Jasper Reports I understand is good. MS Access is good too.

Or modifying the screens - a VB background perhaps ;-) We will never please
everyone there is nothing surer - that's why the canny prefer a smarty
template type thing so the users can muck about with form design till 'their
heart's content'. We've avoided the additional abstraction required till
now.
My only concern is that I'm keen to keep the code as simple as possible.

Phil


On Wed, 28 Sep 2005 05:11, you wrote:

> Phil,
>
> Here are the final changes for the address upgrades, I have made most of
> the changes to the PDF headers but there may still be a few that I missed.
> I corrected the companies fields to match the other fields. Also, I have
> updated the weberp-new.sql, weberp-demo.sql and upgrade scripts with the
> changes so you don't have to merge them yourself.
>
> Dave
>
> Next, on to form redesign and enhancement! wahoo.

--
Phil Daintree
webERP Project Admin


-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
_______________________________________________
Web-erp-developers mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/web-erp-developers




-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
_______________________________________________
Web-erp-developers mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/web-erp-developers
Reply | Threaded
Open this post in threaded view
|

Re: [WebERP-developers] Re: Final address changes

weberp

OK ... seems like a worthy plan - have you seen the sales analysis user
defined reporting options - with parameters stored in the db?

>
> Note: Have you given any thought about creating a deeper structure for the
> scripts, i.e. /modules directory with /gl /ap & /ar subdirectories.
> Everything now is at the root level but as this application continues to
> evolve with the addition of a POS, cart interface, and more features, file
> management will become increasingly complex.
>

Yes I have been giving this some thought ... there are getting to be quite a
few scripts there now. There are pros in the layout as we have it ... one
always knows where the find the file. But there is some strength in your
argument if things get much bigger. Maybe we need to group new functionality
such as POS, cart etc into separate directories from now on.

Phil


-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
_______________________________________________
Web-erp-developers mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/web-erp-developers
Reply | Threaded
Open this post in threaded view
|

RE: [WebERP-developers] Re: Final address changes

Dave-34
Yes, I've seen the sales reports but again it is a special script targeted
just for sales. When the inventory section matures, you'll see a huge need
for field selection and arrangement. I have over 200 products in my catalog
and I track inventory carefully. Depending on what I'm trying to do, I only
want to look at certain fields.

RE: structure
I started development of the reports in a new subdirectory. I found many of
the include(filenamehere) are relative and are broken once the originating
script leaves the root directory. I have made changes to session.inc,
connectdb.inc, connect_db.inc and header.inc so far to just get my testing
to proceed. Mostly the changes to the code will be add an absolute path to
the include files. That way they can be reached from anywhere. Start with a
$_SERVER['DOCUMENT_ROOT'] directive and add the subdirectory of the webERP
home directory (if any) in front of all of the include and require
statements.  Probably best to make it a define() constant early in
session.inc so it can be used throughout the application. Once this is done,
includes (including locale stuff) are easily added to any script.

-----Original Message-----
From: [hidden email]
[mailto:[hidden email]]On Behalf Of Phil
Daintree
Sent: Thursday, September 29, 2005 2:24 PM
To: [hidden email]
Subject: Re: [WebERP-developers] Re: Final address changes



OK ... seems like a worthy plan - have you seen the sales analysis user
defined reporting options - with parameters stored in the db?

>
> Note: Have you given any thought about creating a deeper structure for the
> scripts, i.e. /modules directory with /gl /ap & /ar subdirectories.
> Everything now is at the root level but as this application continues to
> evolve with the addition of a POS, cart interface, and more features, file
> management will become increasingly complex.
>

Yes I have been giving this some thought ... there are getting to be quite a
few scripts there now. There are pros in the layout as we have it ... one
always knows where the find the file. But there is some strength in your
argument if things get much bigger. Maybe we need to group new functionality
such as POS, cart etc into separate directories from now on.

Phil


-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
_______________________________________________
Web-erp-developers mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/web-erp-developers




-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
_______________________________________________
Web-erp-developers mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/web-erp-developers
Reply | Threaded
Open this post in threaded view
|

Re: [WebERP-developers] Re: Final address changes

Scott Rosa
In reply to this post by weberp
I do like the idea of creating subdirectories by function, even if it is
only one level below root.  if someone is looking to add some
functionality or research the way some existing functionality works,
sure does save some time trying to find the scripts that you need if
they are grouped by function.

Phil Daintree wrote:

>OK ... seems like a worthy plan - have you seen the sales analysis user
>defined reporting options - with parameters stored in the db?
>
>  
>
>>Note: Have you given any thought about creating a deeper structure for the
>>scripts, i.e. /modules directory with /gl /ap & /ar subdirectories.
>>Everything now is at the root level but as this application continues to
>>evolve with the addition of a POS, cart interface, and more features, file
>>management will become increasingly complex.
>>
>>    
>>
>
>Yes I have been giving this some thought ... there are getting to be quite a
>few scripts there now. There are pros in the layout as we have it ... one
>always knows where the find the file. But there is some strength in your
>argument if things get much bigger. Maybe we need to group new functionality
>such as POS, cart etc into separate directories from now on.
>
>Phil
>
>
>-------------------------------------------------------
>This SF.Net email is sponsored by:
>Power Architecture Resource Center: Free content, downloads, discussions,
>and more. http://solutions.newsforge.com/ibmarch.tmpl
>_______________________________________________
>Web-erp-developers mailing list
>[hidden email]
>https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>  
>


-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
_______________________________________________
Web-erp-developers mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/web-erp-developers