Přejít na obsah
You need to be registered to interact with the community.
All Posts Lidé Odznaky
Štítky (View all)
odoo accounting v14 pos v15
O tomto fóru
This question has been flagged
4 Odpovědi
10938 Zobrazení
Avatar
James Ford

I have a report on the account.invoice model and want to show how many products in the invoice line. Below will show a picture of what I want to do.


Image: http://es.zimagez.com/zimage/progorma.php


The idea is to count how many products there are on the invoice and return the number of the quantity of products.

Maybe it may be simple, but really do not know everything about Odoo.

Thanks for your advice and help.

Avatar
Zrušit
Jignesh Mehta

Can You post your code ?

Avatar
Kazim Mirza | Founder at TechUltra Solutions
Nejlepší odpověď

Hi James,

You can run counter.

Before your for loop: 

<t t-set="counter" t-value="0"/>
in for loop : 

<t  t-set="counter" t-value="counter + 1"/>
After for loop you can print it like:

<t t-esc="counter"/> 

Hope this helps.

Thanks

Avatar
Zrušit
joyanto

its works for me thanks

Sakthi Priya

Is it possible to break a table when count of product equals 7 and to print the rest records in second page of qweb? (like printing 7 products per page)

Avatar
Mustafa J. Kadhem
Nejlepší odpověď

There a good modules implement what you want on v8.0 but on sales order you can find it on

https://www.odoo.com/apps/modules/8.0/sale_printout_sequence/

And for picking 

https://www.odoo.com/apps/modules/8.0/stock_picking_sequence/

Hope that's help you

Regards

Avatar
Zrušit
Avatar
CatsandDogs
Nejlepší odpověď

I try to query into report, it's working...


class customer_report(models.Model):

  _name = "customer.report"

 _description = "Orders Statistics"

 _auto = False

 name = fields.Many2one('res.partner', readonly=True)

 p_id = fields.Many2one('preorder.config','PreOrder Ref')

 tot_product = fields.Integer('# of Unique Product')

 tot_piece = fields.Integer('# of Piece')

 

 def init(self, cr):

 """Initialize the sql view for the event registration """

 tools.drop_view_if_exists(cr, 'customer_report')


 # TOFIX this request won't select events that have no registration

 cr.execute(""" CREATE VIEW customer_report AS (

 select

 poc.id::varchar || '/' || coalesce(poc.id::varchar,'') AS id,

 poui.customer AS p_id,

 poui.partner_id AS name,

 count(pl.product_id) AS tot_product,

 count(poc.id) AS tot_piece

 from

 preorder_config poc

 left join preorder_user_input poui on (poui.preorder_id = poc.id)

 left join preorder_product_rel ppr on (ppr.preorder_id = poc.id)

 left join preorder_user_input_product_line pl on (pl.user_input_id = poui.id)

 group by

 poc.id, poui.preorder_id, poui.partner_id

 )

 """)

Avatar
Zrušit