pass variable data to qweb report

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

CRM
e-Commerce
Accounting
Inventory
PoS
Project management
MRP

Take the tour

Posts People Badges

Tags View all

odoo accounting v7 pos invoice

About this forum

Help

pass variable data to qweb report

1 Reply

15872 Views

GiancaFTx

Goodnight,

I have a sql query that returns data from a (self.env.cr.dictfetchall ()), the data is returned correctly, but I don't know how to pass the data to a qweb report. I'm trying:

pass it as if it were a variable but it seems that it must be a model field, what type should the fields be? or if there is another way to pass the data to it.

odoo11

Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/odoo/addons/base/ir/ir_qweb/qweb.py", line 345, in _compiled_fn
    return compiled(self, append, new, options, log)
  File "<template>", line 1, in template_1206_74
  File "<template>", line 2, in body_call_content_73
  File "<template>", line 3, in foreach_72
  File "<template>", line 4, in body_call_content_71
AttributeError: 'wizard.comprobantes.detalle.formato' object has no attribute 'all_lines'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/odoo/addons/web/controllers/main.py", line 1620, in report_download
    response = self.report_routes(reportname, docids=docids, converter='pdf')
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 515, in response_wrap
    response = f(*args, **kw)
  File "/mnt/extra-addons/report_xlsx/controllers/main.py", line 43, in report_routes
    reportname, docids, converter, **data
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 515, in response_wrap
    response = f(*args, **kw)
  File "/usr/lib/python3/dist-packages/odoo/addons/web/controllers/main.py", line 1569, in report_routes
    pdf = report.with_context(context).render_qweb_pdf(docids, data=data)[0]
  File "/usr/lib/python3/dist-packages/odoo/addons/base/ir/ir_actions_report.py", line 637, in render_qweb_pdf
    html = self.with_context(context).render_qweb_html(res_ids, data=data)[0]
  File "/usr/lib/python3/dist-packages/odoo/addons/base/ir/ir_actions_report.py", line 675, in render_qweb_html
    return self.render_template(self.report_name, data), 'html'
  File "/usr/lib/python3/dist-packages/odoo/addons/base/ir/ir_actions_report.py", line 479, in render_template
    return view_obj.render_template(template, values)
  File "/usr/lib/python3/dist-packages/odoo/addons/base/ir/ir_ui_view.py", line 1211, in render_template
    return self.browse(self.get_view_id(template)).render(values, engine)
  File "/usr/lib/python3/dist-packages/odoo/addons/web_editor/models/ir_ui_view.py", line 27, in render
    return super(IrUiView, self).render(values=values, engine=engine)
  File "/usr/lib/python3/dist-packages/odoo/addons/base/ir/ir_ui_view.py", line 1220, in render
    return self.env[engine].render(self.id, qcontext)
  File "/usr/lib/python3/dist-packages/odoo/addons/base/ir/ir_qweb/ir_qweb.py", line 57, in render
    return super(IrQWeb, self).render(id_or_xml_id, values=values, **context)
  File "/usr/lib/python3/dist-packages/odoo/addons/base/ir/ir_qweb/qweb.py", line 274, in render
    self.compile(template, options)(self, body.append, values or {})
  File "/usr/lib/python3/dist-packages/odoo/addons/base/ir/ir_qweb/qweb.py", line 352, in _compiled_fn
    raise QWebException("Error to render compiling AST", e, path, node and etree.tostring(node[0], encoding='unicode'), name)
odoo.addons.base.ir.ir_qweb.qweb.QWebException: 'wizard.comprobantes.detalle.formato' object has no attribute 'all_lines'
Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/odoo/addons/base/ir/ir_qweb/qweb.py", line 345, in _compiled_fn
    return compiled(self, append, new, options, log)
  File "<template>", line 1, in template_1206_74
  File "<template>", line 2, in body_call_content_73
  File "<template>", line 3, in foreach_72
  File "<template>", line 4, in body_call_content_71
AttributeError: 'wizard.comprobantes.detalle.formato' object has no attribute 'all_lines'

Error to render compiling AST
AttributeError: 'wizard.comprobantes.detalle.formato' object has no attribute 'all_lines'
Template: 1206
Path: /templates/t/t/t/t/div/table/tbody/t
Node: <t t-foreach="doc.all_lines" t-as="det">
                                                <tr style="border:solid grey 4px">
                                                    <td><span t-esc="det.number"/></td>
                                                    <td><span t-esc="det.product_id"/></td>
                                                    <td><span t-esc="det.price_total"/></td>
                                                   

                                                </tr>
                                            </t>

class WizardInvoiceLineReport(models.TransientModel):

_name = 'wizard.comprobantes.detalle.formato'

fecha_inicio = fields.Date("Fecha de Inicio")

fecha_fin = fields.Date("Fecha Fin")

company_currency_id = fields.Many2one('res.currency')

company_id = fields.Many2one('res.company', string='Company', readonly=True, default=lambda self: self.env.user.company_id)

def imprimir(self):

all_lines=self._sql_get_line_for_report(self.fecha_inicio,self.fecha_fin)

return self.env.ref('report_comprobantes_efact.linea_report_formato_pdf').report_action(self)

report.xml

<?xml version="1.0" encoding="utf-8"?>

<odoo>

<data>

<h1>FORMATO</h1>

<table>

<td><strong>Moneda</strong></td>

<td>

</td>

</tr>

<td>

</td>

</tr>

<td><strong>APELLIDOS Y NOMBRES, DENOMINACION O RAZON SOCIAL</strong></td>

<td>

</td>

</tr>

</table>

</div>

<thead>

<tr>

<th>FECHA EMISION</th>

<th>GLOSA</th>

</tr>

</thead>

<tbody>

</tr>

</t>

</tbody>

</table>

</div>

</t>

</template>

</data>

</odoo>

Niyas Raphy (Walnut IT)

Best Answer

Hi,

You can pass the values to the report like this,

@api.multi
def print_report(self):
    self.ensure_one()
    [data] = self.read()
    data['emp'] = self.env.context.get('active_ids', [])
    employees = self.env['hr.employee'].browse(data['emp'])
    datas = {
        'ids': [],
        'model': 'hr.employee',
        'form': data
    }
    return self.env.ref('hr_holidays.action_report_holidayssummary').report_action(employees, data=datas)

here in the above code datas is dictionary of datas that we will pass to the report, if you need to pass more details like you can add it to the datas dictionary, suppose if i need to pass more details,

datas = {
    'ids': [],
    'model': 'hr.employee',
    'form': data,
    'test': [1, 2, 3, 4]
}

In the above code you can see i have added a list to the datas dictionary this will be available in the template.

Also there are option to do the same using the render_html function, which will get executed while creating PDF report, see this: How To Call A Python Function While Printing PDF Report in Odoo

Odoo QWEB Tutorials: Odoo PDF Reporting Tutorials

Thanks

GiancaFTx

Author

thanks and in the template, as I refer??, what would be the name of the variable.

This question has been flagged