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.