Menu
▾
▴
Re: [WebERP-developers] FormDesigner.php
|
From: Phil D. <ph...@lo...> - 2013-11-15 07:23:45
|
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 |
