Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Księgowość
Zapasy
PoS
Projekt
MRP

All apps

Wszystkie posty Osoby Odznaki

Tagi (Zobacz wszystko)

odoo accounting v14 pos v15

O tym forum

Pomoc

ir.attachment res_*-fields NULL on save

ir.attachment custommodule odoo12

1 Odpowiedz

7048 Widoki

Christoph Farnleitner

model (relevant part):

class AcmeSapPricelist(models.Model):
    _name = "acme.sap.pricelist"
    _inherit = 'portal.mixin'
    _description = "Some Model"
    _order = 'date desc, id desc'
    partner_id = fields.Many2one('res.partner', string='Partner', required=True)
    company_id = fields.Many2one('res.company', string='Company', required=True, default=lambda self: self.env.user.company_id)
    name = fields.Char(string='Document name')
    origin = fields.Char(string='Document origin/source')
    date = fields.Datetime(string='Document creation date')
    note = fields.Char(string='Note')
    file = fields.Many2one(comodel_name="ir.attachment", string="SAP file")
    pricelist_lines = fields.One2many('acme.sap.pricelist.line', compute='_pricelist_lines', store=False)
    @api.multi
    def _pricelist_lines(self):
        self.pricelist_lines = request.env['acme.sap.pricelist.line'].search([('sap_pricelist_id', '=', 1)])

view (relevant part):

        <record id="view_acme_sap_pricelist_form" model="ir.ui.view">
            <field name="name">acme.sap.pricelist.form</field>
            <field name="model">acme.sap.pricelist</field>
            <field name="priority" eval="8" />
            <field name="arch" type="xml"> 
                <form string="Pricelist">
                    <sheet>
                        <div class="oe_title">
                            <h1>
                                <field name="name"/>
                            </h1>
                        </div>
                        <group>
                            <group>
                                <field name="date"/>
                                <field name="id"/>
                            </group>
                            <group>
                                <field name="partner_id"/>
                                <field name="csv"/>
                            </group>
                        </group>
                        <group>
                            <group>
                                <field name="origin"/>
                                <field name="note"/>
                            </group>
                        </group>
                    </sheet>
                </form>
            </field>
        </record>

Above (file = fields.Many2one(comodel_name="ir.attachment", string="SAP file")) is writing a record to ir.attachment table, however I'm unable to figure how to get the columns

res_model
res_model_name
res_field
res_id

filled too. All of them are set to NULL when uploading an file making it impossible to process the record further.

Based on some testing, at least res_model (=>res.partner in this case) and res_id (=>the partners Id) would be required (i.e. for allowing a website user to access the attachment via /web/content/id). How can I tell my module to pass on these two?

Christoph Farnleitner

Autor Najlepsza odpowiedź

My approach now looks the following - seems like that's how you're supposed to do it:

model:

    @api.onchange('partner_id')
    def onchange_partner_id(self):
        if(self.csv):
            if(self.partner_id):
                self.csv.write({'res_model': 'res.partner', 'res_field': 'woa_sappricelist', 'res_id': self.partner_id})

view:

    <field attrs="{'invisible':[('partner_id', '==', False)]}" name="csv" context="{'default_res_model': 'res.partner', 'default_res_id': partner_id}"  />

attrs .. invisible is just do hide the field as long as no partner is selected, which just helps to make sure there is a partner selected before uploading a file.

Podoba Ci się ta dyskusja? Dołącz do niej!

Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!

Zarejestruj się

Powiązane posty	Odpowiedzi	Widoki
Creating Attachments For account.invoice in odoo 12? Rozwiązane attachments ir.attachment odoo12	1 sty 23	10304
[odoo12]How to update data inside a custom module Rozwiązane update sql custommodule odoo12	2 lip 20	4601
psycopg2.ProgrammingError When deleting record Rozwiązane delete psycopg2 custommodule odoo12	5 gru 19	6227
Odoo Mail Sending Limit Rozwiązane odoo12	2 gru 23	16493
(Document type: Invoice, Operation: write) - (Records: [], User: 2) odoo12	0 paź 23	33

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!