If you want the current price for the current customer/etc then you
should call the calculateProductPrice service for each product.
If you want the list price, and query conditions to get it, just look
at the code in the ProductSearch class that does sorting and filtering
by price. In other words, there are good examples there... I guess you
may have become to concerned with getting frustrated to sufficiently
open the scope of your search.
-David
On Dec 4, 2008, at 5:02 AM, madppiper wrote:
Alright,
this is driving me insane, and after searching all through the
available
ofbiz screens and beanshell files, I would really appreciate some
help on
this.
All I want to do is to retrieve a sample of four products (randomly
selected) that contains the description, title, price, listprice,
productId
and brandName, so that I can access the information via ftl later on
and
display 4 productboxes...
I got the first part together just fine:
/*Find Products*/
delegator = request.getAttribute("delegator");
products = delegator.findAll("Product");
productShowLimit=4;
//now slim it down to promoShowLimit
productArrayList = new ArrayList(products);
productPromos = null;
if (productArrayList.size() > productShowLimit) {
productPromos = new ArrayList(productShowLimit);
for (i = 0; i < productShowLimit; i++) {
randomIndex = Math.round(java.lang.Math.random() *
(productArrayList.size() - 1));
productPromos.add(productArrayList.get((int) randomIndex));
}
} else {
productPromos = productArray;
}
But I cannot get my head around on how to link this information to the
listPrice... getRelatedOne on ProductPrice retrieves all the prices
for a
certain product:
productPrices = null;
Iterator p = productPromos.iterator();
while(p.hasNext()){
GenericValue p = (GenericValue) p.next();
prices = p.getRelated("ProductPrice");
System.out.println("Out: "+ prices);
}
But i cannot combine that information with the previous resultMap
(productPromos )... Also, I've read on
http://www.opensourcestrategies.com/ofbiz/ofbiz_entity_cookbook.txt
that you shouldn't access the product data table directly (which makes
sense), and so I can't help but wonder on whether there are easier/
already
existing ways of what I am trying to accomplish...
--
View this message in context:
http://www.nabble.com/Cannot-Retrive-price-from-ProductPrice-tp10407489p20832124.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
