Menu
▾
▴
Re: [WebERP-developers] FormDesigner.php
|
From: Tim S. <tim...@gm...> - 2013-11-15 08:16:38
|
Hi Phil, as you know I have always shared the goal of simplicity, and I am sure you will agree that in general I have followed that principle even closer than you in the past. If there is a less intrusive solution for the scripts (and there almost certainly is, as there is no such thing as a perfect solution) then great, lets move to it, but I maintain that as well as making the scripts easy to change, webERP should also be available to non-programmers who wouldn't want to learn PHP in order to print documents off. It is easy to knock a current solution, but not constructive if it is not combined with a suggestion for an improvement. Thanks Tim On 15 November 2013 07:23, Phil Daintree <ph...@lo...> wrote: > Guys > > The key point I was trying to convey was that IMHO the complexity of the > scripts necessary to use the form designer and run reports defeats a > major purpose of webERP (code should be readable and easily modifiable > by businesses). For this reason I am not keen on it ... at all. > > There are some great things about it but ultimately it makes the scripts > more complex/difficult and therefore more difficult to customise for > businesses. This is also a reason I have avoided templating engines and > all kinds of other abstractions. > > I also accept that many do not share this goal for webERP - fair enough > too. However, it is a goal that I hold dear and I have had this > published clearly since the inception of the project. > > http://www.weberp.org/ > > http://www.weberp.org/wiki/ProjectGoals > > However, I accept that modified scripts also create their own problems > for upgrading and that a generic solution that eased the upgrade process > perhaps by using an over-ride directory by company for customised > scripts for the company would solve a multitude of problems including > this customised report problem. > > Phil > > Phil Daintree > Logic Works Ltd - +64 (0)275 567890 > http://www.logicworks.co.nz > > On 15/11/13 04:35, Rafael Chacón wrote: >> HI, >> >> Thanks everybody for you comments and suggestions. What I have made >> clear so far is: >> >> 1. WebERP updates and upgrades should not affect users settings >> (customizations). It is unwanted to maintaining separate files (scripts) >> for each client to avoid maintenance/upgrades become more and more >> laborious. >> >> 2. There are some methods to do that. One of them is FormDesigner.php. >> >> 3. FormDesigner.php as it stands now is very limited, but it can be >> improved. >> >> imho: >> It needs a converter from millimetres to dot-per-inch (and vice-versa). >> I explain myself: for positioning a field you should (a) measure from >> the lower-left-corner of the sheet to the the top-left-corner of the >> field in millimetres, (b) convert mm in dpi (unit used in >> PHP_Pdf_Creation) with formula DPI = MM * (72dpi / 25,4mm), and (c) >> store this data in the xml file through FormDesigner.php. >> I think it also need other functions such as 'SelectYesNo' (to turn >> on/off the printing of a field), 'SelectAlignment' (to select left, >> center, right or justified alignment of a field), etc. >> >> 4. It seems that the best is a base code for the form that is/generate a >> template that the user is free to modify. >> >> 5. It would be nice to have a pure WYSIWYG solution that allow the the >> user to modify the form. >> >> imho: This additional tier/layer over the FormDesigner.php xml-file >> seems to me interesting, but complicated. Or not? >> >> 6. FormDesigner.php allows to one customer to have different >> form-formats for each of this companies with the same standard scripts >> (code) for all companies. >> >> 7. Although the database is the preferred place to store data, to store >> form customizations is very complex. It is less complex to store form >> customizations in xml files. >> >> 8. It seems the best to have form customizations in a separate folder >> outside of core webERP files. >> >> Regards, Rafael Chacon. >> >> >> 2013/11/14 Tim Schofield <tim...@gm... >> <mailto:tim...@gm...>> >> >> Hi Exson, the problem with putting the data into mysql is how to >> structure the data within the database, rather than how to move it >> into there. >> >> Thanks >> Tim >> >> On 14 November 2013 13:03, ExsonQu <hex...@gm... >> <mailto:hex...@gm...>> wrote: >> > *Dear all:* >> > >> > I think I have no right to comment on this case since >> I have not >> > understood how to use the form designer. I've tried it before, >> but did not >> > master it. So I think the arguments come from how much benefit we >> can get >> > from form designer. If there are more evidence about the >> advantage of it we >> > can reach an agreement. >> > >> > For point 4, I believe it's very convenient to store >> xml to >> > mysql. Just use LOAD xml INFILE. You can get more information here: >> > https://dev.mysql.com/doc/refman/5.5/en/load-xml.html >> > <https://dev.mysql.com/doc/refman/5.5/en/load-xml.html> >> > >> > Maybe a tutorial is necessary for the form designer? >> > >> > Thanks and best regards! >> > >> > Exson >> > >> > >> > >> > >> > >> > -- >> > View this message in context: >> http://weberp-accounting.1478800.n4.nabble.com/FormDesigner-php-tp4656864p4656875.html >> > Sent from the web-ERP-developers mailing list archive at Nabble.com. >> > >> > >> ------------------------------------------------------------------------------ >> > DreamFactory - Open Source REST & JSON Services for HTML5 & >> Native Apps >> > OAuth, Users, Roles, SQL, NoSQL, BLOB Storage and External API Access >> > Free app hosting. Or install the open source package on any LAMP >> server. >> > Sign up and see examples for AngularJS, jQuery, Sencha Touch and >> Native! >> > >> http://pubads.g.doubleclick.net/gampad/clk?id=63469471&iu=/4140/ostg.clktrk >> <http://pubads.g.doubleclick.net/gampad/clk?id=63469471&iu=/4140/ostg.clktrk> >> > _______________________________________________ >> > Web-erp-developers mailing list >> > Web...@li... >> <mailto:Web...@li...> >> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers >> >> >> >> -- >> Course View Towers, >> Plot 21 Yusuf Lule Road, >> Kampala >> T +256 (0) 312 314 418 <tel:%2B256%20%280%29%20312%20314%20418> >> M +256 (0) 752 963 325 <tel:%2B256%20%280%29%20752%20963%20325> >> www.weberpafrica.com <http://www.weberpafrica.com> >> Twitter: @TimSchofield2 >> Blog: http://weberpafrica.blogspot.co.uk/ >> >> ------------------------------------------------------------------------------ >> DreamFactory - Open Source REST & JSON Services for HTML5 & Native Apps >> OAuth, Users, Roles, SQL, NoSQL, BLOB Storage and External API Access >> Free app hosting. Or install the open source package on any LAMP server. >> Sign up and see examples for AngularJS, jQuery, Sencha Touch and Native! >> http://pubads.g.doubleclick.net/gampad/clk?id=63469471&iu=/4140/ostg.clktrk >> <http://pubads.g.doubleclick.net/gampad/clk?id=63469471&iu=/4140/ostg.clktrk> >> _______________________________________________ >> Web-erp-developers mailing list >> Web...@li... >> <mailto:Web...@li...> >> https://lists.sourceforge.net/lists/listinfo/web-erp-developers >> >> >> >> >> ------------------------------------------------------------------------------ >> DreamFactory - Open Source REST& JSON Services for HTML5& Native Apps >> OAuth, Users, Roles, SQL, NoSQL, BLOB Storage and External API Access >> Free app hosting. Or install the open source package on any LAMP server. >> Sign up and see examples for AngularJS, jQuery, Sencha Touch and Native! >> http://pubads.g.doubleclick.net/gampad/clk?id=63469471&iu=/4140/ostg.clktrk >> >> >> >> _______________________________________________ >> Web-erp-developers mailing list >> Web...@li... >> https://lists.sourceforge.net/lists/listinfo/web-erp-developers > > ------------------------------------------------------------------------------ > DreamFactory - Open Source REST & JSON Services for HTML5 & Native Apps > OAuth, Users, Roles, SQL, NoSQL, BLOB Storage and External API Access > Free app hosting. Or install the open source package on any LAMP server. > Sign up and see examples for AngularJS, jQuery, Sencha Touch and Native! > http://pubads.g.doubleclick.net/gampad/clk?id=63469471&iu=/4140/ostg.clktrk > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers -- Course View Towers, Plot 21 Yusuf Lule Road, Kampala T +256 (0) 312 314 418 M +256 (0) 752 963 325 www.weberpafrica.com Twitter: @TimSchofield2 Blog: http://weberpafrica.blogspot.co.uk/ |
