rand_total=sum((item.promotion_price or item.unit_price)*session.order[item.id] for item in *db(db.product.id.belongs(*session.order.keys())).select(db.product.id,db.product.promotion_price,db.product.unit_price))
On Sunday, 28 April 2013 23:37:37 UTC-5, 黄祥 wrote: > > pardon me, for not tell obviously about the code that i want to achieve > my objective : > i want to have a grand total of items (sum) that have been in shopping > cart's session, check is the item have a promotion price or not, if have > a promotion price (promotion_price > 0) use promotion price of item * > quantity, if don't have promotion price (promotion_price = 0) use unit > price of item * quantity > > in pseudo code : > grand_total = sum(for id, qty in session.order.items(): > if db.product(id).promotion_price: > db.product(id).promotion_price*qty > else: > db.product(id).unit_price*qty > ) > any idea or suggestion how to achieve pseudo code above in python or > web2py way? > thank you so much > -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
