You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Aytha Rajesh <ay...@gmail.com> on 2013/02/22 04:12:51 UTC

My Task is To add all the products to gether

Task Explanation

We Have Product, ProductAssoc and ProductPrice Tables

Using these tables i need the get a productId from Product table and ProductIdTo 
from ProductAssoc table Based on the ProductId

and From the Product Price Table we need to grab Price Column value and insert 
into Invoice item

we need to create a invoiceitem 
and the modification files to be done are 

Application\Accounting\script\org\ofbiz\accounting\invoice\InvoiceServices.xml
Application\Accounting\servicedef\Services_invoice.xml

       AddPackage(ProductId)-----CheckAssociations(based on ProductId in 
ProductAssociation table)------get Price(from ProductPrice)if yes----insert into 
invoiceitem---if no goto end------end






Re: My Task is To add all the products to gether

Posted by Paul Foxworthy <pa...@cohsoft.com.au>.
Hi Aytha,

OFBiz already supports aggregated products. See for example the code at 

https://fisheye6.atlassian.com/browse/ofbiz/trunk/applications/order/src/org/ofbiz/order/shoppingcart/ShoppingCartServices.java?hb=true#to449

On the demo site, you will see there are some configurable products where
the price is built from the components that are included.

I wonder if OFBiz already does everything you want. Please explore a bit and
get back to us with more specific questions if you need to.

Cheers

Paul Foxworthy


Aytha Rajesh wrote
> Task Explanation
> 
> We Have Product, ProductAssoc and ProductPrice Tables
> 
> Using these tables i need the get a productId from Product table and
> ProductIdTo 
> from ProductAssoc table Based on the ProductId
> 
> and From the Product Price Table we need to grab Price Column value and
> insert 
> into Invoice item
> 
> we need to create a invoiceitem 
> and the modification files to be done are 
> 
> Application\Accounting\script\org\ofbiz\accounting\invoice\InvoiceServices.xml
> Application\Accounting\servicedef\Services_invoice.xml
> 
>        AddPackage(ProductId)-----CheckAssociations(based on ProductId in 
> ProductAssociation table)------get Price(from ProductPrice)if
> yes----insert into 
> invoiceitem---if no goto end------end





-----
--
Coherent Software Australia Pty Ltd
http://www.coherentsoftware.com.au/

Bonsai ERP, the all-inclusive ERP system
http://www.bonsaierp.com.au/

--
View this message in context: http://ofbiz.135035.n4.nabble.com/My-Task-is-To-add-all-the-products-to-gether-tp4639521p4639793.html
Sent from the OFBiz - User mailing list archive at Nabble.com.