Re: Ofbiz and Dojo

2007-09-15 Thread Al Byers
Guo, I agree that having ScreenWidgets easily use ajax is a good goal and I don't see any problem with moving ahead on that front. But I think there is much more that can be done with the DHTML capabilities of Dojo, but I am not sure I know what they all are. I would like to ask for help from the

Re: Static product page possible?

2007-09-15 Thread Phillip Rhodes
Thanks for the info. Just to be clear, do you mean to change the value of the Detail Screen on the product page to something like "component://ecommerce/widget/CatalogScreens.xml#staticproductdetail" ? Or did you mean something else? Thanks! - Original Message - From: "David E Jones"

Re: Ofbiz and Dojo

2007-09-15 Thread guo weizhan
That's greate, I would love to finish this with you, and what's your progress now? I just figure out how to start with this, and try to extend some screenWidget classes, like the HtmlFormRenderer, but it's just the begining. My purpose it's to make the ScreenWidget can use the ajax easily.It'll be

RE: Rich client: licensing and other features

2007-09-15 Thread [EMAIL PROTECTED]
Cameron "In term of the best value-for-money option, my (and my company's) money is on ZK. We bought commercial licenses, because our programmers receive salaries, and every hour they spend reinventing the wheel instead of using someone else's wheel, however fun it may be, is an additional cost."

Re: Ofbiz and Dojo

2007-09-15 Thread Al Byers
Guo, I have been using Dojo for 3 weeks and am also impressed. If you are thinking about integrating it with screen widgets, then we should collaborate, as I was also thinking of doing the same thing. I work on the original screen widget code so I have a pretty good feel on how things work. I thi

RE: Accessing database through bsh script.

2007-09-15 Thread [EMAIL PROTECTED]
In my testing, there is an approximate 20msec hit using the entity engine over raw jdbc, depending of course on the query, is there a seca involved, etc. Skip -Original Message- From: vijay Si [mailto:[EMAIL PROTECTED] Sent: Saturday, September 15, 2007 10:28 AM To: user@ofbiz.apache.org

RE: Accessing database through bsh script.

2007-09-15 Thread [EMAIL PROTECTED]
vijay The performance hit I think would be higher in a bash script. I think there is no question about that. But, if you insist List purchaseOrders = delegator.findByAnd("OrderHeader", UtilMisc.toMap("orderTypeId","PURCHASE_ORDER")); if(!UtilValidate.isEmpty(purchaseOrders)) { ...

Re: Accessing database through bsh script.

2007-09-15 Thread BJ Freeman
look at framework/webtools/webapp/webtools/WEB-INF/actions/entity/EntitySQLProcessor.bsh vijay Si sent the following on 9/15/2007 10:27 AM: > Jonathon > > It seems that other option left is to use a jdbc connection to database. Is > it also imperative then, that for very complex querries having >

Temporal Tables

2007-09-15 Thread Jose Diaz
Please, let me know some advice about this: I need work with temporal tables, it because I don't want to create a table for save data and next delete it. Create your entity, update the entitygroup, etc. I am updating the aging report , because the data in the future will be bigger. Then I am

Re: Accessing database through bsh script.

2007-09-15 Thread vijay Si
Jonathon It seems that other option left is to use a jdbc connection to database. Is it also imperative then, that for very complex querries having "groupby"..."having" and other clauses it is better to use jdbc method of connection. How does it affect the ofbiz philosophy of architecture if i us

Re: Ofbiz and Dojo

2007-09-15 Thread guo weizhan
I'm doing this for comple days, it's perfect to use dojo with Ofbiz. one of the screen capture url: http://www.open-agile.com/dojo.bmp I want to make all the widget form element use the dojo type, and have ajax function and look good:) But it just the begining now, it's long term to finish. 2

Rich client: licensing and other features

2007-09-15 Thread Cameron Smith
Following on from the discussion about ZK and other rich technologies: a. In terms of compatibility with OFBiz's Apache 2 license, ZK is definitely not compatible for inclusion in OFBiz itself (as it uses dual HPL-Commercial, like MySQL or Opentaps). This has been pointed out on this previously

Re: Accessing database through bsh script.

2007-09-15 Thread Jonathon -- Improov
There's no other (easy) way to query database, aside from using the Entity Engine (which was what I suggested). If you're worried about performance hit with a huge (and unconditional) cross-product, see http://www.nabble.com/forum/ViewPost.jtp?post=12590081&framed=y and https://issues.apache.o

Re: Accessing database through bsh script.

2007-09-15 Thread vijay Si
Hi Jonathon, i cannot use the view-entity for querrying, as it would cause a performance hit. Is there any other method to get the above querry. Do u know of any ways to do it through bsh script. Regards On 9/15/07, Jonathon -- Improov <[EMAIL PROTECTED]> wrote: > > Use the GenericDelegator an

Re: Accessing database through bsh script.

2007-09-15 Thread Jonathon -- Improov
Use the GenericDelegator and related classes, I think. Or maybe not. I can't recall the aggregate functions there. The entity definitions do have those, though. The ? Oh yes, the . Try using DynamicViewEntity to construct a . Jonathon vijay Si wrote: Is there any funtionality provided for u

Re: Users of the release4.0 branch?

2007-09-15 Thread Jonathon -- Improov
> You either manually manage it There's nothing for users or downloaders to manage. If there's a problem with doing a complete SVN checkout, there's nothing to manage in the first place! No OFBiz SVN workspace to begin with! It's also tough for someone who has somehow lost his OFBiz SVN worksp

Accessing database through bsh script.

2007-09-15 Thread vijay Si
Is there any funtionality provided for using aggregate functions (sum,min,max..) and count() for querrying to data base through bsh. for egg: how can we write following in BSH : Select sum(order_id),sum(grand_total) from order_header where order_type_id="PURCHASE_ORDER"; Regards

Re: Billing Accounts

2007-09-15 Thread Rashko Rejmer
Hi Jacopo, Yes, you are right. If you apply payment only to the billing account everything is OK. If you apply it to the invoice that is associated to the billing account the updatePaymenetApplication method will automatically apply this payment to the BA too. So the problem appear if you fill onl

Re: Users of the release4.0 branch?

2007-09-15 Thread Jacques Le Roux
I totally agree with David, really easier for us. Jacques De : "David E Jones" <[EMAIL PROTECTED]> > > > Jonathon -- Improov wrote: > > For some time now, I had been suggesting that we DO NOT include the > > 35+MB binaries in the SVN. SVN is used to track CHANGES to files. Since > > we cannot cha

Re: Users of the release4.0 branch?

2007-09-15 Thread Raj Saini
David, Maven 2 is the right solution to the problem. I know Maven has its own problem but as long as separating the jars from source is concerned Maven is a good choice. Almost all of the ASF projects use it. Thanks, Raj David E Jones wrote: Jonathon -- Improov wrote: For some time now,

Selecting values from multiple tables

2007-09-15 Thread Gurcharan Singh
Hello, I need to access data from multiple table and to display it in FTL template. What API is available which enable selecting values from multiple tables based on a condition. For Example - I need to select descriptions of all products which belongs to a particular supplier. Gurcharan

Re: Users of the release4.0 branch?

2007-09-15 Thread David E Jones
Jonathon -- Improov wrote: For some time now, I had been suggesting that we DO NOT include the 35+MB binaries in the SVN. SVN is used to track CHANGES to files. Since we cannot change binaries (only source codes), binaries have no business residing in SVN. In fact, a guy who claimed he knows

Re: OFBiz 4.0 Branch users

2007-09-15 Thread Cameron Smith
Hi, our products are built on top of the 4.0 branch. We do not use OFBiz frontend, but do heavily use the data model and services from Party and Accounts. We have in some cases extended OFbiz (generally the datamodel), but we have not found any bugs at the application level. At the framework

Re: Billing Accounts

2007-09-15 Thread Jacopo Cappellato
Rashko, is it possible that the error you are seeing, when applying a payment to a billing account using the generic screen, is happening only if you fill both the invoiceId and billingAccountId fields and submit the form? If you just fill the billingAccountId field it should work as expected.

Ofbiz and Dojo

2007-09-15 Thread [EMAIL PROTECTED]
Anyone have any comments on using Dojo with Ofbiz, especially the .9 release? I see that the .9 release is like half the size of the .4 release Skip