[MERGE] web: Re-implement the XLS grouped export

Purpose
=======

The commit 2849b5c introduces a new export mechanism of grouped
list views to xls files.

The issue with this development is mainly that the displayed records
are exported, instead of all the records that match the search
parameters.

To export all the records we cannot rely on the data from the web
client. This implies to revert 2849b5c, and implement it in a better
way.

Functional Spec
===============

Add the support of grouped exports.
Allow the user to export all records in one click from
the listview, without having to go through the export modal,
taking into account the domain, groupbys, and visible fields.

Technical Spec
==============

When exporting (whether it is from the modal or from the shortcut),
any groupby(s) set on the listview should be taken into account (all unfolded)
- UNLESS the export is import-compatible
- each subgroup header has an indentation compared to its parent
- the 'group headers' in the exported file should contain the
  same info (label, field aggregates) as it has in the listview.

New secondary button on the tree view with label 'EXPORT' (to be confirmed...)
- the export shortcut disregard the selected records, it exports all records
  according to the domain.
- the button is visible even if there is no selected records.
- essentially the export shortcut does the same thing as the following:
    - select all records
    - hit 'action' then 'export'
    - hit 'export'

Define a boolean attribute on <tree> to specify whether or not the export
shortcut should be displayed

Task 2072910

closes odoo/odoo#37087

Signed-off-by: Yannick Tivisse (yti) <yti@odoo.com>

1 files changed, 0 insertions, 98 deletions

diff --git a/addons/web/controllers/list_controller.py b/addons/web/controllers/list_controller.py
deleted file mode 100644
index 7ac98b79220..00000000000
--- a/addons/web/controllers/list_controller.py
+++ /dev/null
@@ -1,98 +0,0 @@
-# -*- coding: utf-8 -*-
-# Part of Odoo. See LICENSE file for full copyright and licensing details.
-
-import json
-from datetime import datetime
-
-from odoo import http
-from odoo.http import request
-from odoo.tools.misc import xlwt
-
-
-HEADER_BOLD = xlwt.easyxf("font: bold on; pattern: pattern solid, fore_colour gray25;")
-
-class TableListExporter(http.Controller):
-
-    def _write_group_header(self, worksheet, x, y, group, columns, group_depth=0):
-        aggregates = group.get('aggregateValues', {})
-        title = group.get('value')
-
-        if group.get('hideHeader'):
-            return x, y
-
-        title = '%s%s (%s)' % ('>' * group_depth, title, group.get('count', 0))
-        worksheet.write(x, y, title, HEADER_BOLD)
-        for column in columns[1:]: # No aggregates allowed in the first column
-            y += 1
-            worksheet.write(x, y, aggregates.get(column['field'], ''), HEADER_BOLD)
-        return x + 1, 0
-
-    def _write_record(self, worksheet, x, y, record, columns):
-        for column in columns:
-            worksheet.write(x, y, record[column['field']])
-            y += 1
-        return x + 1, 0
-
-    def _write_groups(self, worksheet, x, y, groups, columns, group_depth=0):
-        """
-        Write groups to the xls worksheet. Recursive if groups are nested (chained groupby)
-        :param worksheet:
-        :param x: start position where to write the group (vertical axis, pointing downward)
-        :param y: start position where to write the group (horizontal axis, pointing to the right)
-        :param groups:  list of groups. Each group is a dict containing either records' data
-                        or sub-groups. A group has the following structure:
-                            'data': list of records or list of sub-groups
-                            'isGrouped': True if data contains sub-groups
-                            'value': title of the group
-                            'count': number of records in the group
-                            'aggregateValues': dict container aggregated values of fields {field: aggregatedValue, ...}
-                            'hideHeader': self explanatory, used when the records are not grouped at all.
-        :param columns: list of displayed columns. Each column is a dict with the following keys:
-                            'field': field name
-                            'aggregateValue': aggregate for all records
-                            'string':
-        """
-        for group in groups:
-            x, y = self._write_group_header(worksheet, x, y, group, columns, group_depth)
-            if group['isGrouped']:
-                # Recursively write sub-groups
-                x, y = self._write_groups(worksheet, x, y, group['data'], columns, group_depth + 1)
-            else:
-                for record in group['data']:
-                    x, y = self._write_record(worksheet, x, y, record, columns)
-        return x, y
-
-    def _write_worksheet(self, worksheet, data):
-        bold = xlwt.easyxf("font: bold on;")
-
-        columns = data['columns']
-        groups = data['groups']
-
-        # Write main header
-        for y, field in enumerate(columns):
-            worksheet.write(0, y, field['string'], bold)
-
-        # Write data
-        x, y = 1, 0
-        x, y = self._write_groups(worksheet, x, y, groups, columns)
-
-        # Write column aggregates
-        for y, field in enumerate(columns):
-            worksheet.write(x, y, field.get('aggregateValue', ''), bold)
-
-    @http.route('/web/list/export_xls', type='http', auth="user")
-    def export_xls(self, data, token):
-        data = json.loads(data)
-        title = data.get('title', 'export')
-        workbook = xlwt.Workbook()
-        worksheet = workbook.add_sheet(title)
-
-        self._write_worksheet(worksheet, data)
-
-        response = request.make_response(None,
-            headers=[('Content-Type', 'application/vnd.ms-excel'),
-                    ('Content-Disposition', 'attachment; filename="%s - %s.xls"' % (title, datetime.now()))],
-            cookies={'fileToken': token})
-        workbook.save(response.stream)
-
-        return response