On Tuesday, April 24, 2018 at 6:49:57 AM UTC-7, Ayron Rangel wrote:
>
> Guys,
>
> How can i print this in HTML (CUSTOM) DAL :
> def stock ():
> sum = db.input_inventory.input_price.sum()
> count = db.input_inventory.product.count()
> results = db(db.input_inventory).select(db.input_inventory.product,
> count, sum, groupby = db.product)
> return locals()
>
> HMTL:
> {{row in results:}}
> <td>{{}}</td>
>
>
You can fill in the table yourself using a for-loop:
<URL:http://web2py.com/books/default/chapter/29/05/the-views#for---in>
or you could use SQLTABLE. I have examples of both in my projects.
I think SQLFORM.grid can also be used, but you may have to set writable
FALSE for everything if you don't want it edited.
Then there's Datatables and similiar libraries if you want spreadsheet
behavior.
<URL:https://datatables.net>
<URL:https://groups.google.com/forum/#!topic/web2py/RRNmkDr5CDE>
/dps
--
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
