From: Rafael C. <raf...@gm...> - 2013-11-14 15:36:02
|
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...> > 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...> 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 > > _______________________________________________ > > 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/ > > > ------------------------------------------------------------------------------ > 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 > |