Skip to Content
คุณต้องลงทะเบียนเพื่อโต้ตอบกับคอมมูนิตี้
All Posts คน เหรียญรางวัล
แท็ก (View all)
odoo accounting v14 pos v15
เกี่ยวกับฟอรั่มนี้
คำถามนี้ถูกตั้งค่าสถานะ
4 ตอบกลับ
16736 มุมมอง
อวตาร
arcull

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.



อวตาร
ละทิ้ง
อวตาร
Temur
คำตอบที่ดีที่สุด

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.


อวตาร
ละทิ้ง
arcull
ผู้เขียน

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?

Temur

What is the current error you get actually?

อวตาร
arcull
ผู้เขียน คำตอบที่ดีที่สุด

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.

อวตาร
ละทิ้ง
Temur

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

อวตาร
Axel Mendoza
คำตอบที่ดีที่สุด

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

อวตาร
ละทิ้ง
arcull
ผู้เขียน

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.