My Task is To add all the products to gether

[Aytha Rajesh]

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

[Paul Foxworthy]

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