developing my first app

developement

1 Vastaa

4354 Näkymät

Wombat, Wombat

Hi,

I thought id challenge myself by creating an app to pull the previous sales quantities into the product template list view. After many, many hours, unfortunately it seems I cannot work out how to do it.

I have successfully put a float field on the product.template.

Here is my model:

from odoo import api, models, fields

class ProductsSold(models.Model):
    _inherit = "product.template" # database table name.

    sold = fields.Float(compute='_compute_avail', string="Avail")

    def _compute_avail(self):
        #sold = self.env['stock.quant'].search_count([])
        # records_sum = sum(self.env["stock.quant"].search([]).mapped('inventory_quantity'))
        records_sum = sum(self.env["sale.sale_order_line"].search([]).mapped('product_uom_qty'))
        self.sold = records_sum

If anyone can offer any hints, I'd be grateful.

Wombat, Wombat

Tekijä

Thank you for your response. Awesome!! It works perfectly.

Next challenge: I would then like to set some filters on this field to sum up the sales in the past month - which I think I can probably achieve now.

Although, I am curious about your mention of uom. Is there something here I am overlooking?

Ray Carnes (ray)

If you ANSWER a question, the OP is notified, but nobody else. I can't convert your answer into a comment that @Fazle can see, so if you'd like to ping him, please comment on HIS answer.

Fazle Rabbi Ferdaus

Hi wombat, may I know which approach you followed?

Wombat, Wombat

Tekijä

Hi Fazle, I when with the first version. I think the word "available" caused some confusion as I was looking for the quantity sold.
Thank you Ray. I am new to forums and their etiquette. I imagine from your response I must have hit answer instead of comment. Not sure what an OP is - or this karma thing that keeps popping up. I'll see what google can tell me.

Fazle Rabbi Ferdaus

wombat, I still advise you to go forward with the second approach

Fazle Rabbi Ferdaus

Hi Wombat, this should find the qty sold for a product. Also you have to add it to the view. Again I think you should also consider uom. Another thing is there is already a field in the product template form to show the sale qty. The field is called 'sales_count'. So this funtion or a new field should be redundent.

from odoo import api, models, fields

class ProductsSold(models.Model):
    _inherit = "product.product" # database table name.

    def _compute_avail(self):
        records_sum = sum(self.env["sale.order.line"].search([('product_id', '=', self.id), ('state', '=', 'sale')]).mapped('product_uom_qty'))
        self.sold = records_sum    sold = fields.Float(compute='_compute_avail', string="Avail")
instead this below should do want you want to achive. and no need to create any field or method. in words you need to inherit the tree view and just add the sales_count field. **Code section in comment does not let me include closing tags**

    product_template_inherit_treefield>
    product.templatefield>
    
    

        
            
        xpath>

    field>
record>

Nautitko keskustelusta? Älä vain lue, vaan osallistu!

Luo tili jo tänään nauttiaksesi yksinoikeusominaisuuksista ja osallistuaksesi mahtavaan yhteisöömme!

Rekisteröidy

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
UI All over the place developement	3 kesäk. 23	3879
How to set my test period account in my local odoo developement	1 syysk. 22	4388
How to read a record for each row developement	0 huhtik. 22	5151
How to disable the existing data suggestions when entering new one developement	1 tammik. 22	6252
Begenning in odoo developement developement	2 lokak. 16	4957

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!