Odoo Help

0

How to run report from code

By
arcull
on 1/27/16, 1:15 AM 4,046 views

Hi there.

I'm trying to make a custom model extending account.invoice, which will add a button on sales invoice form, to print my new custom report. So far, the button, does trigger my function in custom model (I've put there a warning to test), so now the only thing left seems to run my new custom report somehow. The content of imortant file is:

models.py:

# -*- coding: utf-8 -*-

from openerp import models, fields, api, _

from openerp.exceptions import Warning

class Inv(models.Model):

_inherit = 'account.invoice'

_name = 'account.invoice'

#_name = 'my.inv'

#_name = 'account.invoice'

name = fields.Char(string="Title", required=False)

description = fields.Text()

#comment = fields.Text()

@api.multi

def print_invoice_my(self):

#raise Warning( _("do something here") )

#assert len(self) == 1

#self.sent = True

#return self.env['report'].get_action(self, 'account.invoice.report_invoice_my')

return self.env['report'].get_action(self, 'my.report_invoice_my')

#report_obj = self.env['report']

#report = report_obj._get_report_from_name('my.report_invoice_my')

my.xml:

<openerp>
   <data>
	<record id="invoice_form_my" model="ir.ui.view">
            <field name="name">account.invoice.form.my</field>
            <field name="model">account.invoice</field>
	    <field name="inherit_id" ref="account.invoice_form"/>
            <field name="arch" type="xml">
              <button name="invoice_print" position="after">
  	        <button type="object" name="print_invoice_my" string="my Invoice"/>
		<!--<button name="%(report_invoice_my)d" string="my Invoice" type="action"/>-->
              </button>
            </field>      
        </record>   
   </data>
</openerp>

my_report.xml:

<?xml version="1.0" encoding="utf-8"?>
<openerp>
    <data>
      <report 
        id="id_report_invoice_my"
        #model="account.invoice"
        model="my"
        string="my Invoice"
        report_type="qweb-pdf"
        name="my.report_invoice_my"
        attachment_use="False"
        file="my.report_invoice_my"
      />
    </data>
</openerp>


report_invoice_my.xml

<?xml version="1.0" encoding="utf-8"?>
<openerp>
<data>
<template id="report_invoice_my">
    <t t-call="report.external_layout">
        <div class="page">
            <div class="row">
                <h3>Title</h3>
            </div>
        </div>
    </t>
</template>
</data>
</openerp>


I've tried to folow this tutorial

http://www.odoo.yenthevg.com/creating-custom-reports-odoo-8/


However, when trying to hit my button, I get error: "Bad Report Reference" This report is not loaded into the database: my.report_invoice_my.


Posts related to this one are:

https://www.odoo.com/forum/help-1/question/how-to-add-new-button-in-sales-invoice-form-95995

https://www.odoo.com/forum/help-1/question/how-to-connect-button-with-function-96285

https://www.odoo.com/forum/help-1/question/cant-inherit-account-invoice-96458


Can you please suggest how can I fix this, much thanks in advance, best regards.



0
Temur
On 1/29/16, 4:32 AM

does your my_report.xml is exactly same as it is posted here? If so, then you miss <openerp> and <data> tags in it. it should be:

my_report.xml:

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


<report
id="report_invoice_my"
model="account.invoice"
string="my Invoice"
report_type="qweb-pdf"
name="my.report_invoice_my"
attachment_use="False"
file="my.report_invoice_my"
/>

 </data> </openerp>

otherwise it will not be loaded into a database.


Thanks Temur,my_report.xml has openerp and data tags as required, I just haven't copied entire file. Do you hava any other suggestion maybe? Why doesn't the invoice.account module which I extended and added print_invoice_my have it now?

arcull
on 1/29/16, 7:20 AM

What is the current error you get actually?

Temur
on 1/29/16, 7:33 AM
0
arcull
On 1/28/16, 2:11 AM

This is my current, but now working solution.

The model looks like:

# -*- coding: utf-8 -*-
from openerp import models, fields, api, _
from openerp.exceptions import Warning
from openerp.report import report_sxw
class Inv(models.Model):
     _inherit = 'account.invoice'
     _name = 'account.invoice'
     name = fields.Char(string="Title", required=False)
     description = fields.Text()
     # previous try to run report     
     @api.multi
     def print_invoice_my_old(self,data=None):
        report_obj = self.env['report']
        report = report_obj._get_report_from_name('my.report_invoice_my')
        docargs = {
            'doc_ids': self._ids,
            'doc_model': report.model,
            'docs': self,
        }
        return report_obj.render('my.report_invoice_my', docargs)
class myinv(report_sxw.rml_parse):
    def __init__(self, cr, uid, name, context):
        super(example_report_parser, self).__init__(cr, uid, name, context=context)
        self.localcontext.update({
            'next_seq': self._get_next_seq,
            'select_value': self._selection_value,
        })
    @api.multi
    def print_invoice_my(self,data=None):
       report_obj = self.env['report']
       report = report_obj._get_report_from_name('my.report_invoice_my')
       docargs = {
           'doc_ids': self._ids,
           'doc_model': report.model,
           'docs': self,
       }
       return report_obj.render('my.report_invoice_my', docargs)
class myinv_parser(models.AbstractModel):
    _name = 'report.my.report_invoice_my'
    _inherit = 'report.abstract_report'
    _template = 'report.my.report_invoice_my'
    _wrapped_report_class = myinv

The button in xml looks like:

            <field name="arch" type="xml">
              <button name="invoice_print" position="after">
 <button type="object" name="print_invoice_my" string="MY Invoice"/>
              </button>
            </field>  

The error I'm obviously getting is:

AttributeError: 'account.invoice' object has no attribute 'print_invoice_my'.

How can I make this work? I guess  I'm missing something here, thanks for your help.

do you have "account" or "account_accountant" in a dependency list?

Temur
on 1/29/16, 7:42 AM
0
Axel Mendoza
On 1/27/16, 4:18 PM

Check this another resource

https://www.odoo.com/es_ES/forum/help-1/question/how-to-define-a-custom-methods-functions-to-be-used-in-a-qweb-report-how-to-define-and-use-a-report-parser-92244

Thanks Axel your tutorial looks usefull. However I can not apply it to my case. The prblem is that I'm iheriting (extending) account.invoice module and the button on invoice form calls function in this same model. Please see my current (not working) solution bellow. If you know how to fix please suggest, many thanks.

arcull
on 1/28/16, 2:05 AM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

Register

Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

3 follower(s)

Stats

Asked: 1/27/16, 1:15 AM
Seen: 4046 times
Last updated: 2/9/17, 8:36 AM