Hello, I have an xml file to generate a report a my.model: My report Report my.model qweb-pdf my_app.my_template my_app.my_template <field name="binding_model_id" ref="model_

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

CRM
e-Commerce
Kế toán
Tồn kho
PoS
Dự án
MRP

All apps

Tất cả bài viết Người Huy hiệu

Thẻ (Xem tất cả)

odoo accounting v14 pos v15

Về diễn đàn này

Hỗ trợ

Custom module: Can I generate and store a PDF report in a binary field - Odoo 18

reports Binary v18

2 Trả lời

184 Lượt xem

Boris Giordanengo

Hello,

I have an xml file to generate a report a my.model:

<odoo>
    <template id="my_template">
        <t t-call="web.html_container">
            <t t-foreach="docs" t-as="o">
               My report
            </t>
        </t>
    </template>

    <report id="my_report" model="ir.actions.report">
        <field name="name">Report</field>
        <field name="model">my.model</field>
        <field name="report_type">qweb-pdf</field>
        <field name="report_name">my_app.my_template</field>
        <field name="report_file">my_app.my_template</field>
        <field name="binding_model_id" ref="model_my_model"/>
        <field name="binding_type">report</field>
    </report>
</odoo>

This code is working file.
I also know how to generate the pdf report via a button, but I don't know how to generate this pdf report as a binary field of my.model (report_id = fields.Binary('pdf report')).

Thanks,

Boris

Cybrosys Techno Solutions Pvt.Ltd

Hi,

You can generate a QWeb PDF report programmatically and store it in a Binary field on your model.The correct approach is to call the report action from Python, render the PDF in memory, and then write the resulting bytes to a binary field. You do not need to trigger a download or rely on a button action that returns a report.

First, define the binary field on your model:

from odoo import models, fields

class MyModel(models.Model):

_name = 'my.model'

report_pdf = fields.Binary(string="PDF Report", attachment=True)

report_pdf_name = fields.Char(string="PDF Filename")

Then, generate and store the PDF using ir.actions.report. In Odoo 18, the supported API is _render_qweb_pdf:

from odoo import models, api

import base64

class MyModel(models.Model):

_name = 'my.model'

def action_generate_pdf(self):

report = self.env.ref('my_app.my_report')

pdf_content, _ = report._render_qweb_pdf(self.id)

self.write({

'report_pdf': base64.b64encode(pdf_content),

'report_pdf_name': f'Report_{self.id}.pdf',

})

This method renders the same PDF as your XML report definition, but instead of returning it to the browser, it stores it directly in the database.

Setting attachment=True on the binary field ensures the file is stored efficiently in ir.attachment and can be downloaded later. You can then expose this field in a form view to allow users to download the stored PDF.

Hope it helps

Jainesh Shah(Aktiv Software)

Hello Boris Giordanengo ,

Yes, you can generate a PDF report and store it in a Binary field in Odoo 18 using a custom module. You can achieve this by following the steps below

1) Add New Fields to Your Model

class MyModel(models.Model):

_name = 'my.model'

report_id = fields.Binary(

string='PDF Report',

attachment=True

)

report_filename = fields.Char(string='Report Filename')

2) Add Button and Fields to Your Form View

<button name="action_generate_pdf_report"

type="object"

string="Generate PDF"

class="btn-primary"/>

3) Create the Button Action:

Define a Python method that generates the PDF report and stores it in the Binary field

4) Generate and Store the PDF:

When you click the Generate PDF button, the report will be generated and automatically stored in the Binary field as an attachment

This solution allows you to generate a PDF report and store it directly in a Binary field using standard Odoo functionality.

If you have any questions, feel free to reach out.

Hope this helps!

Thanks and Regards,

Email: odoo@aktivsoftware.com

Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!

Tạo tài khoản ngay hôm nay để tận hưởng các tính năng độc đáo và tham gia cộng đồng tuyệt vời của chúng tôi!

Đăng ký

Bài viết liên quan	Trả lời	Lượt xem
Where is the PDF Partner Ledger QWeb Report and View in Odoo Online? v18	1 thg 12 25	3352
Change Sign & Pay Button on Quotation E-mails v18	3 thg 11 25	595
Problem including JS asset in v18 v18	3 thg 11 25	8986
Code for page number in Body of Pdf report reports	2 thg 10 25	3407
How to increase the width of a column on odoo quotation PDF? reports	1 thg 10 25	1253

Câu hỏi này đã bị gắn cờ

Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!