for id in ids: detail = db(db.rent_detail.id == id).select().first() dvd = db(db.dvd.id == detail.dvd).select().first() total_price = dvd.acquisition_price * detail.quantity grand_total += total_price
can be done as follows: expr = (db.dvd.acquisition_price * db.rent_detail.quantity).sum() # you can build any expression! grand_total = db(db.rent_detail.id.belongs(itds))(db.dvd.id == db.rent_<http://db.rent_detail.id/> detail.dvd).select(expr).first()[expr] n Thursday, 5 December 2013 21:07:17 UTC-6, 黄祥 wrote: > i know i can do it manually like : > for id in ids: > detail = db(db.rent_detail.id == id).select().first() > dvd = db(db.dvd.id == detail.dvd).select().first() > total_price = dvd.acquisition_price * detail.quantity > grand_total += total_price > > but i want to make it simple like on pos appliance. > any other idea how to achieve it? > > thanks and best regards, > stifan > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
