Merge lp:~domsense/web-addons/adding_web_export_view into lp:~webaddons-core-editors/web-addons/6.1

[Lorenzo Battistini]

web_export_view module.

After you installed it, you’ll find an additional link ‘Export current view’ right below the ‘Export’ one. By clicking on it you’ll get a XLS file contains the same data of the tree view you are looking at, headers included

[lp:~domsense/web-addons/adding_web_export_view]

7. By Lorenzo Battistini on 2013-01-20

[DEL] README.rst

[Alexandre Fayolle - camptocamp (alexandre-fayolle-c2c)]

Stefan Rijnhart is mentionned (without email) in the AUTHORS.txt but not in the headers of the added files. Is this intended?

apart from this, LGTM.

review: Approve

[Guewen Baconnier @ Camptocamp (gbaconnier-c2c)]

Looks fine to me

review: Approve (no test, code review)

[Nicolas Bessi - Camptocamp (nbessi-c2c-deactivatedaccount)]

Hello,

Would it not be cleaner to use the "dataset"/"Model" records, data, etc. properties of the view to get data to send to server instead of parsing HTML?

I'm not familiarized with the new WebClient API yet and maybe I missed some point of view_list.js but it seems possible to do it this way.

On the other hand, It is also True that the base API relies a lot on CSS selector.

Any opinions ??

Regards

Nicolas

review: Needs Information

[lp:~domsense/web-addons/adding_web_export_view]

8. By Lorenzo Battistini on 2013-01-28

[ADD] copyright header

[Lorenzo Battistini (elbati)]

On 01/21/2013 09:41 AM, Alexandre Fayolle @ camptocamp wrote:
>
> Stefan Rijnhart is mentionned (without email) in the AUTHORS.txt but not in the headers of the added files. Is this intended?

Added copyright header.

About email: Stefan, do you want to tell me the address to use? (I just
tested and manually copied this patch
<http://bazaar.launchpad.net/%7Etherp-nl/domsense-agilebg-web-addons/6.1-export_first_list__in_form_view/revision/18>.)

Thanks

[Stefan Rijnhart (Opener) (stefan-opener)]

Hi Lorenzo,

a pleasant surprise to see our small contribution merged spontaneously. Thanks for the attribution too. For the email address, you can almost always get the committers email from the source branch' log. In this case, get my address from

    bzr log -r -1 http://bazaar.launchpad.net/%7Etherp-nl/domsense-agilebg-web-addons/6.1-export_first_list__in_form_view

Cheers,
Stefan.

[lp:~domsense/web-addons/adding_web_export_view]

9. By Lorenzo Battistini on 2013-01-28

[FIX] authors

[Lorenzo Battistini (elbati)]

On 01/28/2013 06:28 PM, Stefan Rijnhart (Therp) wrote:
> Hi Lorenzo,
>
> a pleasant surprise to see our small contribution merged spontaneously. Thanks for the attribution too. For the email address, you can almost always get the committers email from the source branch' log. In this case, get my address from
>
> bzr log -r -1 http://bazaar.launchpad.net/%7Etherp-nl/domsense-agilebg-web-addons/6.1-export_first_list__in_form_view

Right, thanks :-)

=== added directory 'web_export_view'
=== added file 'web_export_view/AUTHORS.txt'
--- web_export_view/AUTHORS.txt	1970-01-01 00:00:00 +0000
+++ web_export_view/AUTHORS.txt	2013-01-28 18:37:22 +0000
@@ -0,0 +1,6 @@
+Authors
+=======
+
+Simone Orsi <[e-mail]> [simahawk]
+Lorenzo Battistini <[e-mail]>
+Stefan Rijnhart <[e-mail]>

=== added file 'web_export_view/__init__.py'
--- web_export_view/__init__.py	1970-01-01 00:00:00 +0000
+++ web_export_view/__init__.py	2013-01-28 18:37:22 +0000
@@ -0,0 +1,21 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#    
+#    Copyright (C) 2012 Agile Business Group sagl (<http://www.agilebg.com>)
+#    Copyright (C) 2012 Domsense srl (<http://www.domsense.com>)
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as published
+#    by the Free Software Foundation, either version 3 of the License, or
+#    (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+import controllers

=== added file 'web_export_view/__openerp__.py'
--- web_export_view/__openerp__.py	1970-01-01 00:00:00 +0000
+++ web_export_view/__openerp__.py	2013-01-28 18:37:22 +0000
@@ -0,0 +1,53 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#    
+#    Copyright (C) 2012 Domsense srl (<http://www.domsense.com>)
+#    Copyright (C) 2012-2013 Agile Business Group sagl
+#    (<http://www.agilebg.com>)
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as published
+#    by the Free Software Foundation, either version 3 of the License, or
+#    (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+{
+    'name': 'Export Current View',
+    'version': '1.0',
+    'category': 'Web',
+    'description': """
+WEB EXPORT VIEW
+===============
+
+One of the best OpenERP’s features is exporting custom data to CSV/XLS. You can do it by clicking on the export link in the sidebar. The export action allows use to configure what to be exported by selecting fields, etc, and allows you to save your export as a template so that you can export it once again without having to configure it again.
+
+That feature is as great and advanced as limited for an everyday-customer-experience. A lot of customers want simply to export the tree view they are looking to.
+
+If you miss this feature as us, probably you’ll find an answer into our web_export_view module.
+
+After you installed it, you’ll find an additional link ‘Export current view’ right below the ‘Export’ one. By clicking on it you’ll get a XLS file contains the same data of the tree view you are looking at, headers included.
+""",
+    'author': 'Agile Business Group',
+    'website': 'http://www.agilebg.com',
+    'license': 'AGPL-3',
+    'depends': ['web'],
+    'external_dependencies' : {
+        'python' : ['xlwt'],
+     },
+    'data': [],
+    'active': False,
+    'auto_install': False,
+    'js': [
+        'static/js/web_advanced_export.js',
+    ],
+}
+

=== added file 'web_export_view/controllers.py'
--- web_export_view/controllers.py	1970-01-01 00:00:00 +0000
+++ web_export_view/controllers.py	2013-01-28 18:37:22 +0000
@@ -0,0 +1,46 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#    
+#    Copyright (C) 2012 Agile Business Group sagl (<http://www.agilebg.com>)
+#    Copyright (C) 2012 Domsense srl (<http://www.domsense.com>)
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as published
+#    by the Free Software Foundation, either version 3 of the License, or
+#    (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+try:
+    import json
+except ImportError:
+    import simplejson as json
+
+import web.common.http as openerpweb
+
+from web.controllers.main import ExcelExport
+
+
+class ExcelExportView(ExcelExport):
+    _cp_path = '/web/export/xls_view'
+
+    @openerpweb.httprequest
+    def index(self, req, data, token):
+        data = json.loads(data)
+        model = data.get('model',[])
+        columns_headers = data.get('headers',[])
+        rows = data.get('rows',[])
+
+        context = req.session.eval_context(req.context)
+
+        return req.make_response(self.from_data(columns_headers, rows),
+            headers=[('Content-Disposition', 'attachment; filename="%s"' % self.filename(model)),
+                     ('Content-Type', self.content_type)],
+            cookies={'fileToken': int(token)})

=== added directory 'web_export_view/static'
=== added directory 'web_export_view/static/js'
=== added file 'web_export_view/static/js/web_advanced_export.js'
--- web_export_view/static/js/web_advanced_export.js	1970-01-01 00:00:00 +0000
+++ web_export_view/static/js/web_advanced_export.js	2013-01-28 18:37:22 +0000
@@ -0,0 +1,117 @@
+//  @@@ web_export_view custom JS @@@
+//#############################################################################
+//    
+//    Copyright (C) 2012 Agile Business Group sagl (<http://www.agilebg.com>)
+//    Copyright (C) 2012 Therp BV (<http://therp.nl>)
+//
+//    This program is free software: you can redistribute it and/or modify
+//    it under the terms of the GNU Affero General Public License as published
+//    by the Free Software Foundation, either version 3 of the License, or
+//    (at your option) any later version.
+//
+//    This program is distributed in the hope that it will be useful,
+//    but WITHOUT ANY WARRANTY; without even the implied warranty of
+//    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+//    GNU Affero General Public License for more details.
+//
+//    You should have received a copy of the GNU Affero General Public License
+//    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+//
+//#############################################################################
+
+openerp.web_export_view = function(openerp) {
+
+    _t = openerp.web._t;
+
+    openerp.web.Sidebar = openerp.web.Sidebar.extend({
+
+        add_default_sections: function() {
+            // IMHO sections should be registered objects
+            // as views and retrieved using a specific registry
+            // so that we don't have to override this
+            
+            var self = this,
+            view = this.widget_parent,
+            view_manager = view.widget_parent,
+            action = view_manager.action;
+            if (this.session.uid === 1) {
+                this.add_section(_t('Customize'), 'customize');
+                this.add_items('customize', [{
+                    label: _t("Translate"),
+                    callback: view.on_sidebar_translate,
+                    title: _t("Technical translation")
+                }]);
+            }
+
+            this.add_section(_t('Other Options'), 'other');
+            this.add_items('other', [
+                {
+                    label: _t("Import"),
+                    callback: view.on_sidebar_import
+                }, {
+                    label: _t("Export"),
+                    callback: view.on_sidebar_export
+                },
+                {
+                    label: _t("Export current view"),
+                    callback: this.on_sidebar_export_view
+                }
+            ]);
+        },
+
+        on_sidebar_export_view: function() {
+            // Select the first list of the current (form) view
+            // or assume the main view is a list view and use that
+            var self = this,
+            view = this.widget_parent; // valid for list view
+            if (view.widget_children) {
+                view.widget_children.every(function(child) {
+                    if (child.field && (
+                        child.field.type == 'many2many'
+                            || child.field.type == 'one2many')) {
+                        view = child.viewmanager.views.list.controller;
+                        return false; // break out of the loop
+                    }
+                    return true;
+                });
+            }
+            var columns = view.visible_columns;
+            export_columns_keys = [];
+            export_columns_names = [];
+            $.each(columns,function(){
+                if(this.tag=='field'){
+                    // non-fields like `_group` or buttons
+                    export_columns_keys.push(this.id);
+                    export_columns_names.push(this.string);
+                }
+            });
+            rows = view.$element.find('.ui-widget-content tr');
+            export_rows = [];
+            $.each(rows,function(){
+                $row = $(this);
+                // find only rows with data
+                if($row.attr('data-id')){
+                    export_row = [];
+                    $.each(export_columns_keys,function(){
+                        cell = $row.find('td[data-field="'+this+'"]').get(0);
+                        text = cell.text || cell.textContent || cell.innerHTML || "";
+                        export_row.push(text.trim());
+                    });
+                    export_rows.push(export_row);
+                }
+            });
+            $.blockUI();
+            view.session.get_file({
+                url: '/web/export/xls_view',
+                data: {data: JSON.stringify({
+                    model : view.model,
+                    headers : export_columns_names,
+                    rows : export_rows,
+                })},
+                complete: $.unblockUI
+            });
+        },
+
+    });
+
+}