odoo 响应下载文件

忘是亡心i 2021-12-15 12:59 269阅读 0赞

odoo中如何实现点击按钮下载文件报告、报表到页面左下角

models.py

# -*- coding: utf-8 -*-
    from openerp import models, fields, api
    import logging
    
    try:
        import xlwt
    except ImportError:
        xlwt = None
    
    import json
    import urllib2
    
    _logger = logging.getLogger(__name__)
    
    
    class test_module_template(models.Model):
        _name = 'test.module.template'
        _description = u'测试模块'
    
        def request_pdf_from(self, data, response):
            """ 从服务器请求pdf """
    
            server_url = "https://zhaichangyuan.jsreportonline.net/api/report"
            server_data = {
       
                "template": {"name": "template-main"},
                'Headers': 'Content-Type: application/json',
                # 'subject': '测试jsreport接口',
                # 'BODY': {
       
                #     # "name": "invoice-main",
                #     # "recipe": "html-to-xlsx",
                #     # "engine": "handlebars",
                #     # "content": "<h1>sample content</h1>",
                # },
                "data": {
       
                    "number": "FP201904120003",
                    "seller": {
       
                        "name": u"北京百星电子系统有限公司",
                        "road": u"北京·枢密院",
                        "country": u"中国.北京"
                    },
                    "buyer": {
       
                        "name": u"中国建筑研究设计院",
                        "road": u"北京市海淀区中关村创业大厦",
                        "country": u"中国.北京"
                    },
                    "items": [
                        {
       
                            "name": u"网页设计",
                            "price": 400.00,
                            "city": "Beijing"
                        },
                        {
       
                            "name": u"程序开发",
                            "price": 1500.00,
                            "city": "Shanghai"
                        },
                        {
       
                            "name": u"系统运维",
                            "price": 600.00,
                            "city": "Beijing"
                        },
                        {
       
                            "name": u"硬件维护",
                            "price": 700.00,
                            "city": "Shenzhen"
                        },
                        {
       
                            "name": u"AI智能",
                            "price": 300.00,
                            "city": "Shanghai"
                        },
                        {
       
                            "name": u"软件开发",
                            "price": 100.00,
                            "city": "Wuhan"
                        },
                        {
       
                            "name": u"程序测试",
                            "price": 800.00,
                            "city": "Shanghai"
                        }
                    ]
                },
                "options": {"timeout": 60000}
            }
    
            headers = {
       
                # "Accept": "application/pdf",
                "Content-Type": "application/json",
                "Authorization": "Basic d29ybWVyQHdvcm1lLmNuOklPUGlvcCooKTg5MA==",
            }
            request = urllib2.Request(server_url, data=json.dumps(server_data), headers=headers)
            res = urllib2.urlopen(request)
            #print res.read()
            # file_Handle = open('report_test111.xlsx', 'w')
            # file_Handle.write(response.read())
            # file_Handle.close()
            response.set_data(res.read())
            return response
    
        @api.multi
        def action_print(self):
            return {
       
                'type': 'ir_actions_jsreport_xls_download',
                'data': {
       
                    'model': '',
                    'options': '',
                    'report_name': ''
                }
            }
    
    controllers/mains.py

# -*- coding: utf-8 -*-
    
    import logging
    import simplejson
    from openerp import http
    from openerp.http import request, Response
    
    _logger = logging.getLogger(__name__)
    
    
    class JsreportPrint(http.Controller):
    
        @http.route('/jsreport/xls/download', type='http', auth='public', methods=['POST'], csrf=False)
        def jsreport_xls_download(self, action, token, **kw):
            _logger.info(action)
            data = simplejson.loads(action)
            options = data.get('data').get('options')
            report_name = u"jsreport_report"
            uid = request.session.uid
    
            response = request.make_response(None,
                                             headers=[('Content-Type', 'application/vnd.ms-excel'),
                                                      ('Content-Disposition', 'attachment; filename=' + report_name + '.xlsx;')],
                                             cookies={'fileToken': token})
    
            obj = request.env['test.module.template'].sudo(uid)
            return obj.request_pdf_from(options, response)
    
    static/src/js/jsreport_xls_print.js

openerp.test_module_template = function (instance) {
       
        instance.web.ActionManager = instance.web.ActionManager.extend({
       
            ir_actions_jsreport_xls_download: function (action, options) {
       
                var self = this;
                instance.web.blockUI();
                action = _.clone(action);
    
                var c = instance.webclient.crashmanager;
                console.log(action);
                return $.Deferred(function (d) {
       
                    self.session.get_file({
       
                        url: '/jsreport/xls/download',
                        data: {action: JSON.stringify(action)},
                        complete: instance.web.unblockUI,
                        success: function () {
       
                            if (!self.dialog) {
       
                                options.on_close();
                            }
                            self.dialog_stop();
                            d.resolve();
                        },
                        error: function () {
       
                            c.rpc_error.apply(c, arguments);
                            d.reject();
                        }
                    });
                });
            }
        })
    }
    
    views/template.xml

<?xml version="1.0" encoding="utf-8"?>
    
    <openerp>
        <data>
            <template id="jsreport_xls_print" name="jsreport_xls_print" inherit_id="web.assets_backend">
                <xpath expr="." position="inside">
                    <script type="text/javascript" src="/test_module_template/static/src/js/jsreport_xls_print.js"></script>
                </xpath>
            </template>
        </data>
    </openerp>
    
    views/views.xml

<?xml version="1.0" encoding="utf-8"?>
    <openerp>
        <data>
            <record id="test_module_template_form" model="ir.ui.view">
                <field name="name">test.module.template.form</field>
                <field name="model">test.module.template</field>
                <field name="type">form</field>
                <field name="arch" type="xml">
                    <form>
                        <header>
                            <button name="action_print" class="oe_highlight" string="打印" type="object"/>
                        </header>
                    </form>
                </field>
            </record>
    
            <record id="test_module_template_action" model="ir.actions.act_window">
                <field name="name">测试</field>
                <field name="type">ir.actions.act_window</field>
                <field name="res_model">test.module.template</field>
                <field name="view_type">form</field>
                <field name="view_mode">form</field>
                <field name="help" type="html">
                    <p class="oe_view_nocontent_create">测试单</p>
                </field>
            </record>
            <menuitem name="主测试按钮" id="test_module_template_1" sequence="10"/>
            <menuitem name="主测试按钮1" id="test_module_template_2" parent="test_module_template_1" sequence="10"/>
            <menuitem name="测试按钮" id="test_module_template" sequence="10" parent="test_module_template_2"
                      action="test_module_template_action"/>
        </data>
    </openerp>

转载于:https://www.cnblogs.com/zcy1103/p/10760950.html