Odoo Help

Welcome!

This community 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.

4

[SOLVED] Call a report from a wizard (odoo 8)

By
dlsuarez
on 2/3/15, 5:12 AM 7,374 views

I need help to generate a report from a button in a wizard view.

I use qweb in odoo 8.0.

This is my code:

wizards/stats,py

@api.multi
    def compute_stats(self):
        stats = self._get_stats()
        leads = self._get_leads(
            stats.salesperson_ids.mapped("id"),
            stats.source_ids.mapped("id"),
            stats.stage_ids.mapped("id"),
            stats.reason_ids.mapped("id")
        )
        report_obj = self.env['report']
        report = report_obj._get_report_from_name('crm_ticket_platforms.crm_stats')
        docargs = {
            'doc_ids': self._ids,
            'doc_model': report.model,
            'docs': self,
        }
        return report_obj.render('crm_ticket_platforms.crm_stats', docargs)

report/crm_stats.xml

<?xml version="1.0" encoding="UTF-8"?>
<openerp>
    <data>
        <report
            id="crm_ticket_platforms_report_crm_stats"
            model="stats"
            string="CRM Stats"
            report_type="qweb-pdf"
            name="crm_ticket_platforms.crm_stats"
            file="crm_ticket_platforms.crm_stats"
            attachment_use="False"
            attachment="(object.filename+'.pdf')"
        />
        <template id="report_crm_stats_document">
            <t t-call="report.html_container">
                <t t-foreach="docs" t-as="doc">
                    <t t-call="report.external_layout">
                        <div class="page">
                            <p><h2>Id:</h2> <span t-field="doc.id"/></p>
                            <separator/>
                        </div>
                    </t>
                </t>
            </t>
        </template>
        <template id="crm_stats">
            <t t-call="report.html_container">
                <t t-foreach="doc_ids" t-as="doc_id">
                    <t t-raw="translate_doc(doc_id, doc_model, 'lang', 'crm_ticket_platforms.report_crm_stats_document')"/>
                </t>
            </t>
        </template>
    </data>
</openerp>

This apparently works but not show/save the 'pdf' report.

Thanks!

1

Vasanth

--Vasanth--
3458
| 5 3 8
Pondicherry, India
--Vasanth--
Vasanth
On 2/3/15, 6:27 AM

Hi,

You can use the folowing code in the xml view( report_session.xml ) and then call the report from the wizard button

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

        <template id="report_session">
            <t t-call="report.html_container">
                <t t-foreach="docs" t-as="doc">
                    <t t-call="report.external_layout">
                        <div class="page">
                            <div class="oe_structure" />
                            <div class="text-center"><h1><span t-esc="doc.name"></span></h1></div>
                        </div>
                    </t>
                </t>
            </t>
        </template>

 

        <report id="report_print"
                string="Report"
                model="res.partner"
                report_type="qweb-pdf"
                file="res_partner.report_session"
                name="res_partner.report_session" />

</data>

</openerp>

5

Ankit H Gandhi(AHG)

--Ankit H Gandhi(AHG)--
996
| 5 3 6
Rajkot, India
--Ankit H Gandhi(AHG)--

Learning Python..

Ankit H Gandhi(AHG)
On 2/4/15, 5:42 AM

Hello dlsuarez,
    
step 1 create report template using template tag
    
example like
    
<?xml version="1.0" encoding="utf-8"?>

<openerp> 
    <data>

        <template id="report_student_master_qweb">
            <t t-call="report.html_container"> 
                <t t-foreach="docs" t-as="o"> 
                    <t t-call="report.external_layout">
                        <div class="page">
                            <div class="oe_structure"/>
                            <div class="row">
                                <span class="text-center"><h1>Student Information</h1></span>
                                <table class="table table condensed">
                                    <tr>
                                        <td><h3><strong>GRN No:</strong></h3></td>
                                        <td><h3 t-field="o.code"/></td>
                                    </tr>
                                    <tr>
                                        <td><h3><strong>First Name:</strong></h3></td>
                                        <td><h3 t-field="o.fname"/></td>
                                    </tr>
                                    <tr>
                                        <td><h3><strong>Middle Name:</strong></h3></td>
                                        <td><h3 t-field="o.mname"/></td>
                                    </tr>
                                    <tr t-if="o.lname">
                                        <td><h3><strong>Last Name:</strong></h3></td>
                                        <td><h3 t-field="o.lname"/></td>
                                    </tr>
                                    <tr t-if="o.gender">
                                        <td><h3><strong>Gender:</strong></h3></td>
                                        <td><h3 t-field="o.gender"/></td>
                                    </tr>
                                    <tr t-if="o.dob">
                                        <td><h3><strong>Date of Birth:</strong></h3></td>
                                        <td><h3 t-field="o.dob"/></td>
                                    </tr>
                                    <tr t-if="o.join_date">
                                        <td><h3><strong>Joining Date:</strong></h3></td>
                                        <td><h3 t-field="o.join_date"/></td>
                                    </tr>
                                </table>
                            </div>
                        </div>
                    </t>
                </t>
            </t> 
        </template>

    </data>
</openerp>

step 2 registration that report using report tag
    
example like
    
<?xml version="1.0" encoding="utf-8"?>
<openerp> 
    <data>
        <report id="school_management_qweb_report"
                string="school Management Report Qweb"
                model="student.master"
                report_type = "qweb-pdf"
                file="school_management.report_student_master_qweb"
                name="school_management.report_student_master_qweb" />
    </data>
</openerp>
    
step 3 create py file of wizard.
    
example like
    
from openerp.osv import orm, fields
from openerp.tools.translate import _

class wiz_student_report(orm.TransientModel):
    _name = 'wiz.student.report'
    _columns = {
        'student_id': fields.many2one('student.master', 'Student Name'),
        'birth_sdate': fields.date('Start Date'),
        'birth_edate': fields.date('End Date'),
    }

    def student_report(self, cr, uid, ids, context=None):
        student_obj = self.pool.get('student.master')
        cur_obj = self.browse(cr, uid, ids, context=context)
        datas = {}
        if cur_obj.birth_sdate >= cur_obj.birth_edate:
            raise orm.except_orm(_('Warning!'),_('End date is %s must be greater then start date is %s') % (cur_obj.birth_edate,cur_obj.birth_sdate))
        student_ids = student_obj.search(cr, uid, [('fname', '=', cur_obj.student_id.fname),('dob','>=',cur_obj.birth_sdate),('dob','<=',cur_obj.birth_edate)], context=context)
        if student_ids:
            data = self.read(cr, uid, ids, context=context)[0]
            datas = {
            'ids': student_ids,
            'model': 'wiz.student.report', # wizard model name
            'form': data,
            'context':context
            }
            return {
                   'type': 'ir.actions.report.xml',
                   'report_name': 'school_management.report_student_master_qweb',#module name.report template name
                   'datas': datas,
               }
               
step 4 create xml file of wizard
    
example like
    
<?xml version="1.0" encoding="utf-8"?>
<openerp>
    <data>

        <record model="ir.ui.view" id="wiz_student_report_form">
            <field name="name">wiz.student.report.form</field>
            <field name="model">wiz.student.report</field>
            <field name="arch" type="xml">
                <form string="Student Report">
                    <group>
                        <group string="Student Name">
                            <field name="student_id" nolabel="1" options="{'no_create': True}" required="1"/>
                        </group>
                    </group>
                    <group string="Birth Date Between" col="4" colspan="4">
                        <field name="birth_sdate" required="1"/>
                        <field name="birth_edate" required="1"/>
                    </group>
                    <footer>
                        <button string="Report" name="student_report" type="object" class="oe_highlight"/>
                        or
                        <button string="Cancel" class="oe_link" special="cancel" />
                    </footer>
                </form>
            </field>
        </record>

        <record model="ir.actions.act_window" id="wiz_student_report_action">
            <field name="name">Student Wize Report</field>
            <field name="res_model">wiz.student.report</field>
            <field name="type">ir.actions.act_window</field>
            <field name="view_type">form</field>
            <field name="view_mode">form</field>
            <field name="target">new</field>
        </record>
        
    </data>
</openerp>

step 5 put this code in view xml file for pop up the wizard using button click.
    
example like
    
<button name="%(wiz_student_report_action)d" string="Student Wize Report" type="action"/>
    
if you find this answer helpful, please give me a thumbs up vote    

Regards,

Ankit H Gandhi
 

In the tag, why do you use "model="student.master"? What is this model?

Pascal Tremblay
on 2/18/16, 5:23 PM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 2/3/15, 5:12 AM
Seen: 7374 times
Last updated: 8/4/16, 4:42 AM