1238

pending completion

Build # 1238

Build Type

Pull #310

travis-ci

Committed by

web-flow

Commit Message

<a href="https://github.com/OCA/account-financial-reporting/commit/<a class=hub.com/OCA/account-financial-reporting/commit/be2637eb2522ca3dc96ff2218c18b6230f0753ab">be2637eb2<a href="https://github.com/OCA/account-financial-reporting/commit/be2637eb2522ca3dc96ff2218c18b6230f0753ab">&quot;>Merge commit &#39;</a><a class="double-link" href="https://github.com/OCA/account-financial-reporting/commit/<a class="double-link" href="https://github.com/OCA/account-financial-reporting/commit/aefed9e189c2c19f42af10873f60915255f39fc9">aefed9e18</a>">aefed9e18</a><a href="https://github.com/OCA/account-financial-reporting/commit/be2637eb2522ca3dc96ff2218c18b6230f0753ab">' into account_standard_report

Pull Request Pull Request #310: [10][NEW] Account standard report

Run Details

524 of 524 new or added lines in 3 files covered. (100.0%)

2362 of 3229 relevant lines covered (73.15%)

1.46 hits per line

Source File
Press 'n' to go to next uncovered line, 'b' for previous

2.83

/account_standard_report/report/report_account_standard_excel.py

# -*- coding: utf-8 -*-
from datetime import datetime
from odoo.addons.report_xlsx.report.report_xlsx import ReportXlsx
from odoo.tools import DEFAULT_SERVER_DATE_FORMAT
from odoo import _


class AccountStandardExcel(ReportXlsx):

    def generate_xlsx_report(self, workbook, data, wizard):

        num_format = _('_ * #,##0.00_) ;_ * - #,##0.00_) ;_ * "-"??_) ;_ @_ ')
        bold = workbook.add_format({'bold': True})
        middle = workbook.add_format({'bold': True, 'top': 1})
        left = workbook.add_format({'left': 1, 'top': 1, 'bold': True})
        right = workbook.add_format({'right': 1, 'top': 1})
        top = workbook.add_format({'top': 1})
        currency_format = workbook.add_format({'num_format': _(num_format)})
        c_middle = workbook.add_format({'bold': True, 'top': 1, 'num_format': _(num_format)})
        report_format = workbook.add_format({'font_size': 24})
        rounding = self.env.user.company_id.currency_id.decimal_places or 2
        lang_code = self.env.user.lang or 'en_US'
        date_format = self.env['res.lang']._lang_get(lang_code).date_format

        report = wizard.report_id

        def _get_data_float(data):
            if data == None or data == False:
                return 0.0
            else:
                return wizard.company_currency_id.round(data) + 0.0

        def get_date_format(date):
            if date:
                date = datetime.strptime(date, DEFAULT_SERVER_DATE_FORMAT)
                date = date.strftime(date_format)
            return date

        def _header_sheet(sheet):
            sheet.write(0, 4, report.name, report_format)
            sheet.write(2, 0, _('Company:'), bold)
            sheet.write(3, 0, wizard.company_id.name,)
            sheet.write(4, 0, _('Print on %s') % report.print_time)

            sheet.write(2, 2, _('Start Date : %s ') % wizard.date_from if wizard.date_from else '')
            sheet.write(3, 2, _('End Date : %s ') % wizard.date_to if wizard.date_to else '')

            sheet.write(2, 4, _('Target Moves:'), bold)
            sheet.write(3, 4, _('All Entries') if wizard.target_move == 'all' else _('All Posted Entries'))

            sheet.write(2, 6, _('Only UnReconciled Entries') if wizard.reconciled is False else _('With Reconciled Entries'), bold)

        if wizard.type_ledger == 'aged':

            if wizard.summary:
                sheet = workbook.add_worksheet(report.name)
                _header_sheet(sheet)

                head = [
                    {'name': 'Code',
                     'larg': 10,
                     'col': {}},
                    {'name': 'Name',
                     'larg': 30,
                     'col': {}},
                    {'name': _('Not Due'),
                     'larg': 15,
                     'col': {'total_function': 'sum', 'format': currency_format}},
                    {'name': _('0-30'),
                     'larg': 15,
                     'col': {'total_function': 'sum', 'format': currency_format}},
                    {'name': _('30-60'),
                     'larg': 15,
                     'col': {'total_function': 'sum', 'format': currency_format}},
                    {'name': _('60-90'),
                     'larg': 15,
                     'col': {'total_function': 'sum', 'format': currency_format}},
                    {'name': _('90-120'),
                     'larg': 15,
                     'col': {'total_function': 'sum', 'format': currency_format}},
                    {'name': _('Older'),
                     'larg': 15,
                     'col': {'total_function': 'sum', 'format': currency_format}},
                    {'name': _('Total'),
                     'larg': 15,
                     'col': {'total_function': 'sum', 'format': currency_format}},
                ]

                all_lines = wizard.sql_get_line_for_report(type_l=('4_total',))
                # print(all_lines)
                if all_lines:

                    row = 6
                    row += 1
                    start_row = row
                    for i, line in enumerate(all_lines):
                        i += row
                        sheet.write(i, 0, line.get('code', ''))
                        sheet.write(i, 1, line.get('name', ''))
                        sheet.write(i, 2, _get_data_float(line.get('current')), currency_format)
                        sheet.write(i, 3, _get_data_float(line.get('age_30_days')), currency_format)
                        sheet.write(i, 4, _get_data_float(line.get('age_60_days')), currency_format)
                        sheet.write(i, 5, _get_data_float(line.get('age_90_days')), currency_format)
                        sheet.write(i, 6, _get_data_float(line.get('age_120_days')), currency_format)
                        sheet.write(i, 7, _get_data_float(line.get('older')), currency_format)
                        sheet.write(i, 8, _get_data_float(line.get('balance')), currency_format)
                    row = i

                    for j, h in enumerate(head):
                        sheet.set_column(j, j, h['larg'])

                    table = []
                    for h in head:
                        col = {}
                        col['header'] = h['name']
                        col.update(h['col'])
                        table.append(col)

                    sheet.add_table(start_row - 1, 0, row + 1, len(head) - 1,
                                    {'total_row': 1,
                                     'columns': table,
                                     'style': 'Table Style Light 9',
                                     })

            else:  # aged not summary
                head = [
                    {'name': _('Date'),
                     'larg': 10,
                     'col': {}},
                    {'name': _('JRNL'),
                     'larg': 10,
                     'col': {}},
                    {'name': _('Account'),
                     'larg': 10,
                     'col': {}},
                    {'name': _('Account Name'),
                     'larg': 15,
                     'col': {}},
                    {'name': _('Journal entries'),
                     'larg': 20,
                     'col': {}},
                    {'name': _('Ref'),
                     'larg': 40,
                     'col': {}},
                    {'name': _('Partner'),
                     'larg': 20,
                     'col': {}},
                    {'name': _('Due Date'),
                     'larg': 10,
                     'col': {}},
                    {'name': _('Not Due'),
                     'larg': 15,
                     'col': {'total_function': 'sum', 'format': currency_format}},
                    {'name': _('0-30'),
                     'larg': 15,
                     'col': {'total_function': 'sum', 'format': currency_format}},
                    {'name': _('30-60'),
                     'larg': 15,
                     'col': {'total_function': 'sum', 'format': currency_format}},
                    {'name': _('60-90'),
                     'larg': 15,
                     'col': {'total_function': 'sum', 'format': currency_format}},
                    {'name': _('90-120'),
                     'larg': 15,
                     'col': {'total_function': 'sum', 'format': currency_format}},
                    {'name': _('Older'),
                     'larg': 15,
                     'col': {'total_function': 'sum', 'format': currency_format}},
                    {'name': _('Total'),
                     'larg': 15,
                     'col': {'total_function': 'sum', 'format': currency_format}},
                    {'name': _('Match.'),
                     'larg': 10,
                     'col': {}},
                ]
                table = []
                for h in head:
                    col = {'header': h['name']}
                    col.update(h['col'])
                    table.append(col)

                def _set_line(line):
                    sheet.write(i, 0, get_date_format(line.get('date', '')))
                    sheet.write(i, 1, line.get('j_code', ''))
                    sheet.write(i, 2, line.get('a_code', ''))
                    sheet.write(i, 3, line.get('a_name', ''))
                    sheet.write(i, 4, line.get('move_name', ''))
                    sheet.write(i, 5, line.get('displayed_name', ''))
                    sheet.write(i, 6, line.get('partner_name', ''))
                    sheet.write(i, 7, get_date_format(line.get('date_maturity', '')))
                    sheet.write(i, 8, _get_data_float(line.get('current')), currency_format)
                    sheet.write(i, 9, _get_data_float(line.get('age_30_days')), currency_format)
                    sheet.write(i, 10, _get_data_float(line.get('age_60_days')), currency_format)
                    sheet.write(i, 11, _get_data_float(line.get('age_90_days')), currency_format)
                    sheet.write(i, 12, _get_data_float(line.get('age_120_days')), currency_format)
                    sheet.write(i, 13, _get_data_float(line.get('older')), currency_format)
                    sheet.write(i, 14, _get_data_float(line.get('balance')), currency_format)
                    sheet.write(i, 15, line.get('matching_number', ''))

                def _set_table(start_row, row):
                    sheet.add_table(start_row - 1, 0, row + 1, len(head) - 1,
                                    {'total_row': 1,
                                     'columns': table,
                                     'style': 'Table Style Light 9',
                                     })
                    #sheet.write(row + 1, 10, "=I%s-J%s" % (row + 2, row + 2), currency_format)

                # With total workbook
                sheet = workbook.add_worksheet(report.name + _(' Totals'))
                _header_sheet(sheet)

                row = 6
                all_lines = wizard.sql_get_line_for_report(type_l=('1_init_line', '2_line'))
                for obj in report.report_object_ids:

                    lines_obj = []
                    obj_id = obj.id
                    for line in all_lines:
                        if line.get('report_object_id') == obj_id:
                            lines_obj.append(line)
                    if lines_obj:
                        row += 1
                        sheet.write(row, 0, obj.partner_id.name, left)  # obj.partner_id.name
                        sheet.write(row, 1, '', top)
                        sheet.write(row, 2, '', top)
                        sheet.write(row, 3, '', top)
                        sheet.write(row, 4, '', top)
                        sheet.write(row, 5, '', top)
                        sheet.write(row, 6, '', c_middle)
                        sheet.write(row, 7, '', c_middle)
                        sheet.write(row, 8, '', c_middle)
                        sheet.write(row, 9, '', c_middle)
                        sheet.write(row, 10, '', c_middle)
                        sheet.write(row, 11, '', c_middle)
                        sheet.write(row, 12, '', c_middle)
                        sheet.write(row, 13, '', c_middle)
                        sheet.write(row, 14, '', c_middle)
                        sheet.write(row, 15, '', right)

                        row += 2
                        start_row = row
                        for i, line in enumerate(lines_obj):
                            i += row
                            _set_line(line)

                        row = i

                        for j, h in enumerate(head):
                            sheet.set_column(j, j, h['larg'])

                        _set_table(start_row, row)
                        row += 2

                # Pivot
                sheet = workbook.add_worksheet(report.name)
                _header_sheet(sheet)

                # for group_by in data['group_by_data']['ids']:
                #     for line in data['lines_group_by'][group_by]['new_lines']:
                #         if line['type_line'] != 'total':
                #             all_lines.append(line)
                # Head
                if all_lines:
                    row = 6
                    row += 1
                    start_row = row
                    for i, line in enumerate(all_lines):
                        i += row
                        _set_line(line)
                    row = i

                    for j, h in enumerate(head):
                        sheet.set_column(j, j, h['larg'])

                    _set_table(start_row, row)

        else:  # standard report

            if wizard.summary:
                sheet = workbook.add_worksheet(report.name)
                _header_sheet(sheet)

                all_lines = wizard.sql_get_line_for_report(type_l=('4_total',))
                # for group_by in data['group_by_data']['ids']:
                #     all_lines.append(data['lines_group_by'][group_by])
                if all_lines:
                    # Head
                    head = [
                        {'name': 'Code',
                         'larg': 10,
                         'col': {}},
                        {'name': 'Name',
                         'larg': 30,
                         'col': {}},
                        {'name': 'Debit',
                         'larg': 15,
                         'col': {'total_function': 'sum', 'format': currency_format}},
                        {'name': 'Credit',
                         'larg': 15,
                         'col': {'total_function': 'sum', 'format': currency_format}},
                        {'name': 'Balance',
                         'larg': 15,
                         'col': {'total_function': 'sum', 'format': currency_format}},
                    ]

                    row = 6
                    row += 1
                    start_row = row
                    for i, line in enumerate(all_lines):
                        i += row
                        sheet.write(i, 0, line.get('code', ''))
                        sheet.write(i, 1, line.get('name', ''))
                        sheet.write(i, 2, line.get('debit', ''), currency_format)
                        sheet.write(i, 3, line.get('credit', ''), currency_format)
                        sheet.write(i, 4, line.get('balance', ''), currency_format)
                    row = i

                    for j, h in enumerate(head):
                        sheet.set_column(j, j, h['larg'])

                    table = []
                    for h in head:
                        col = {}
                        col['header'] = h['name']
                        col.update(h['col'])
                        table.append(col)

                    sheet.add_table(start_row - 1, 0, row + 1, len(head) - 1,
                                    {'total_row': 1,
                                     'columns': table,
                                     'style': 'Table Style Light 9',
                                     })

            else:  # not summary

                head = [
                    {'name': _('Date'),
                     'larg': 10,
                     'col': {}},
                    {'name': _('JRNL'),
                     'larg': 10,
                     'col': {}},
                    {'name': _('Account'),
                     'larg': 10,
                     'col': {}},
                    {'name': _('Account Name'),
                     'larg': 15,
                     'col': {}},
                    {'name': _('Journal entries'),
                     'larg': 20,
                     'col': {}},
                    {'name': _('Ref'),
                     'larg': 40,
                     'col': {}},
                    {'name': _('Partner'),
                     'larg': 20,
                     'col': {}},
                    {'name': _('Due Date'),
                     'larg': 10,
                     'col': {}},
                    {'name': _('Debit'),
                     'larg': 15,
                     'col': {'total_function': 'sum', 'format': currency_format}},
                    {'name': _('Credit'),
                     'larg': 15,
                     'col': {'total_function': 'sum', 'format': currency_format}},
                    {'name': _('Balance'),
                     'larg': 15,
                     'col': {'format': currency_format}},
                    {'name': _('Match.'),
                     'larg': 10,
                     'col': {}},
                ]
                table = []
                for h in head:
                    col = {'header': h['name']}
                    col.update(h['col'])
                    table.append(col)

                def _set_line(line):
                    sheet.write(i, 0, get_date_format(line.get('date', '')) if line.get('type_view') != 'init' else 'INIT')
                    sheet.write(i, 1, line.get('j_code', ''))
                    sheet.write(i, 2, line.get('a_code', ''))
                    sheet.write(i, 3, line.get('a_name', ''))
                    sheet.write(i, 4, line.get('move_name', ''))
                    sheet.write(i, 5, line.get('displayed_name', ''))
                    sheet.write(i, 6, line.get('partner_name', ''))
                    sheet.write(i, 7, get_date_format(line.get('date_maturity', '')))
                    sheet.write(i, 8, _get_data_float(line.get('debit', '')), currency_format)
                    sheet.write(i, 9, _get_data_float(line.get('credit', '')), currency_format)
                    sheet.write(i, 10, _get_data_float(line.get('cumul_balance', '')), currency_format)
                    sheet.write(i, 11, line.get('matching_number', ''))

                def _set_table(start_row, row):
                    sheet.add_table(start_row - 1, 0, row + 1, len(head) - 1,
                                    {'total_row': 1,
                                     'columns': table,
                                     'style': 'Table Style Light 9',
                                     })
                    #sheet.write(row + 1, 10, "=I%s-J%s" % (row + 2, row + 2), currency_format)

                # With total workbook
                sheet = workbook.add_worksheet(report.name + _(' Totals'))
                _header_sheet(sheet)

                row = 6

                all_lines = wizard.sql_get_line_for_report(type_l=('0_init', '1_init_line', '2_line'))
                for obj in report.report_object_ids:
                    lines_obj = []
                    obj_id = obj.id
                    for line in all_lines:
                        if line.get('report_object_id') == obj_id:
                            lines_obj.append(line)
                    if lines_obj:
                        row += 1
                        name_view = ''
                        if wizard.type == 'account':
                            name_view = obj.account_id.display_name
                        if wizard.type == 'partner':
                            name_view = obj.partner_id.display_name
                        if wizard.type == 'journal':
                            name_view = obj.journal_id.display_name

                        sheet.write(row, 0, name_view, left)
                        sheet.write(row, 1, '', top)
                        sheet.write(row, 2, '', top)
                        sheet.write(row, 3, '', top)
                        sheet.write(row, 4, '', top)
                        sheet.write(row, 5, '', top)
                        sheet.write(row, 6, '', top)
                        sheet.write(row, 7, '', top)
                        sheet.write(row, 8, '', top)
                        sheet.write(row, 9, '', top)
                        sheet.write(row, 10, '', top)
                        sheet.write(row, 11, '', right)

                        row += 2
                        start_row = row
                        for i, line in enumerate(lines_obj):
                            i += row
                            _set_line(line)

                        row = i

                        for j, h in enumerate(head):
                            sheet.set_column(j, j, h['larg'])

                        _set_table(start_row, row)
                        row += 2

                # Pivot workbook
                sheet = workbook.add_worksheet(report.name)
                _header_sheet(sheet)

                # Head
                if all_lines:
                    row = 6
                    row += 1
                    start_row = row
                    for i, line in enumerate(all_lines):
                        i += row
                        _set_line(line)
                    row = i

                    for j, h in enumerate(head):
                        sheet.set_column(j, j, h['larg'])

                    _set_table(start_row, row)


AccountStandardExcel('report.account_standard_report.report_account_standard_excel', 'account.report.standard.ledger')

1	# -- coding: utf-8 --
2	from datetime import datetime	2✔
3	from odoo.addons.report_xlsx.report.report_xlsx import ReportXlsx	2✔
4	from odoo.tools import DEFAULT_SERVER_DATE_FORMAT	2✔
5	from odoo import _	2✔
6
7
8	class AccountStandardExcel(ReportXlsx):	2✔
9
10	def generate_xlsx_report(self, workbook, data, wizard):	2✔
11
12	num_format = _('_ * #,##0.00_) ;_ * - #,##0.00_) ;_ * "-"??_) ;_ @_ ')	×
13	bold = workbook.add_format({'bold': True})	×
14	middle = workbook.add_format({'bold': True, 'top': 1})	×
15	left = workbook.add_format({'left': 1, 'top': 1, 'bold': True})	×
16	right = workbook.add_format({'right': 1, 'top': 1})	×
17	top = workbook.add_format({'top': 1})	×
18	currency_format = workbook.add_format({'num_format': _(num_format)})	×
19	c_middle = workbook.add_format({'bold': True, 'top': 1, 'num_format': _(num_format)})	×
20	report_format = workbook.add_format({'font_size': 24})	×
21	rounding = self.env.user.company_id.currency_id.decimal_places or 2	×
22	lang_code = self.env.user.lang or 'en_US'	×
23	date_format = self.env['res.lang']._lang_get(lang_code).date_format	×
24
25	report = wizard.report_id	×
26
27	def _get_data_float(data):	×
28	if data == None or data == False:	×
29	return 0.0	×
30	else:
31	return wizard.company_currency_id.round(data) + 0.0	×
32
33	def get_date_format(date):	×
34	if date:	×
35	date = datetime.strptime(date, DEFAULT_SERVER_DATE_FORMAT)	×
36	date = date.strftime(date_format)	×
37	return date	×
38
39	def _header_sheet(sheet):	×
40	sheet.write(0, 4, report.name, report_format)	×
41	sheet.write(2, 0, _('Company:'), bold)	×
42	sheet.write(3, 0, wizard.company_id.name,)	×
43	sheet.write(4, 0, _('Print on %s') % report.print_time)	×
44
45	sheet.write(2, 2, _('Start Date : %s ') % wizard.date_from if wizard.date_from else '')	×
46	sheet.write(3, 2, _('End Date : %s ') % wizard.date_to if wizard.date_to else '')	×
47
48	sheet.write(2, 4, _('Target Moves:'), bold)	×
49	sheet.write(3, 4, _('All Entries') if wizard.target_move == 'all' else _('All Posted Entries'))	×
50
51	sheet.write(2, 6, _('Only UnReconciled Entries') if wizard.reconciled is False else _('With Reconciled Entries'), bold)	×
52
53	if wizard.type_ledger == 'aged':	×
54
55	if wizard.summary:	×
56	sheet = workbook.add_worksheet(report.name)	×
57	_header_sheet(sheet)	×
58
59	head = [	×
60	{'name': 'Code',
61	'larg': 10,
62	'col': {}},
63	{'name': 'Name',
64	'larg': 30,
65	'col': {}},
66	{'name': _('Not Due'),
67	'larg': 15,
68	'col': {'total_function': 'sum', 'format': currency_format}},
69	{'name': _('0-30'),
70	'larg': 15,
71	'col': {'total_function': 'sum', 'format': currency_format}},
72	{'name': _('30-60'),
73	'larg': 15,
74	'col': {'total_function': 'sum', 'format': currency_format}},
75	{'name': _('60-90'),
76	'larg': 15,
77	'col': {'total_function': 'sum', 'format': currency_format}},
78	{'name': _('90-120'),
79	'larg': 15,
80	'col': {'total_function': 'sum', 'format': currency_format}},
81	{'name': _('Older'),
82	'larg': 15,
83	'col': {'total_function': 'sum', 'format': currency_format}},
84	{'name': _('Total'),
85	'larg': 15,
86	'col': {'total_function': 'sum', 'format': currency_format}},
87	]
88
89	all_lines = wizard.sql_get_line_for_report(type_l=('4_total',))	×
90	# print(all_lines)
91	if all_lines:	×
92
93	row = 6	×
94	row += 1	×
95	start_row = row	×
96	for i, line in enumerate(all_lines):	×
97	i += row	×
98	sheet.write(i, 0, line.get('code', ''))	×
99	sheet.write(i, 1, line.get('name', ''))	×
100	sheet.write(i, 2, _get_data_float(line.get('current')), currency_format)	×
101	sheet.write(i, 3, _get_data_float(line.get('age_30_days')), currency_format)	×
102	sheet.write(i, 4, _get_data_float(line.get('age_60_days')), currency_format)	×
103	sheet.write(i, 5, _get_data_float(line.get('age_90_days')), currency_format)	×
104	sheet.write(i, 6, _get_data_float(line.get('age_120_days')), currency_format)	×
105	sheet.write(i, 7, _get_data_float(line.get('older')), currency_format)	×
106	sheet.write(i, 8, _get_data_float(line.get('balance')), currency_format)	×
107	row = i	×
108
109	for j, h in enumerate(head):	×
110	sheet.set_column(j, j, h['larg'])	×
111
112	table = []	×
113	for h in head:	×
114	col = {}	×
115	col['header'] = h['name']	×
116	col.update(h['col'])	×
117	table.append(col)	×
118
119	sheet.add_table(start_row - 1, 0, row + 1, len(head) - 1,	×
120	{'total_row': 1,
121	'columns': table,
122	'style': 'Table Style Light 9',
123	})
124
125	else: # aged not summary
126	head = [	×
127	{'name': _('Date'),
128	'larg': 10,
129	'col': {}},
130	{'name': _('JRNL'),
131	'larg': 10,
132	'col': {}},
133	{'name': _('Account'),
134	'larg': 10,
135	'col': {}},
136	{'name': _('Account Name'),
137	'larg': 15,
138	'col': {}},
139	{'name': _('Journal entries'),
140	'larg': 20,
141	'col': {}},
142	{'name': _('Ref'),
143	'larg': 40,
144	'col': {}},
145	{'name': _('Partner'),
146	'larg': 20,
147	'col': {}},
148	{'name': _('Due Date'),
149	'larg': 10,
150	'col': {}},
151	{'name': _('Not Due'),
152	'larg': 15,
153	'col': {'total_function': 'sum', 'format': currency_format}},
154	{'name': _('0-30'),
155	'larg': 15,
156	'col': {'total_function': 'sum', 'format': currency_format}},
157	{'name': _('30-60'),
158	'larg': 15,
159	'col': {'total_function': 'sum', 'format': currency_format}},
160	{'name': _('60-90'),
161	'larg': 15,
162	'col': {'total_function': 'sum', 'format': currency_format}},
163	{'name': _('90-120'),
164	'larg': 15,
165	'col': {'total_function': 'sum', 'format': currency_format}},
166	{'name': _('Older'),
167	'larg': 15,
168	'col': {'total_function': 'sum', 'format': currency_format}},
169	{'name': _('Total'),
170	'larg': 15,
171	'col': {'total_function': 'sum', 'format': currency_format}},
172	{'name': _('Match.'),
173	'larg': 10,
174	'col': {}},
175	]
176	table = []	×
177	for h in head:	×
178	col = {'header': h['name']}	×
179	col.update(h['col'])	×
180	table.append(col)	×
181
182	def _set_line(line):	×
183	sheet.write(i, 0, get_date_format(line.get('date', '')))	×
184	sheet.write(i, 1, line.get('j_code', ''))	×
185	sheet.write(i, 2, line.get('a_code', ''))	×
186	sheet.write(i, 3, line.get('a_name', ''))	×
187	sheet.write(i, 4, line.get('move_name', ''))	×
188	sheet.write(i, 5, line.get('displayed_name', ''))	×
189	sheet.write(i, 6, line.get('partner_name', ''))	×
190	sheet.write(i, 7, get_date_format(line.get('date_maturity', '')))	×
191	sheet.write(i, 8, _get_data_float(line.get('current')), currency_format)	×
192	sheet.write(i, 9, _get_data_float(line.get('age_30_days')), currency_format)	×
193	sheet.write(i, 10, _get_data_float(line.get('age_60_days')), currency_format)	×
194	sheet.write(i, 11, _get_data_float(line.get('age_90_days')), currency_format)	×
195	sheet.write(i, 12, _get_data_float(line.get('age_120_days')), currency_format)	×
196	sheet.write(i, 13, _get_data_float(line.get('older')), currency_format)	×
197	sheet.write(i, 14, _get_data_float(line.get('balance')), currency_format)	×
198	sheet.write(i, 15, line.get('matching_number', ''))	×
199
200	def _set_table(start_row, row):	×
201	sheet.add_table(start_row - 1, 0, row + 1, len(head) - 1,	×
202	{'total_row': 1,
203	'columns': table,
204	'style': 'Table Style Light 9',
205	})
206	#sheet.write(row + 1, 10, "=I%s-J%s" % (row + 2, row + 2), currency_format)
207
208	# With total workbook
209	sheet = workbook.add_worksheet(report.name + _(' Totals'))	×
210	_header_sheet(sheet)	×
211
212	row = 6	×
213	all_lines = wizard.sql_get_line_for_report(type_l=('1_init_line', '2_line'))	×
214	for obj in report.report_object_ids:	×
215
216	lines_obj = []	×
217	obj_id = obj.id	×
218	for line in all_lines:	×
219	if line.get('report_object_id') == obj_id:	×
220	lines_obj.append(line)	×
221	if lines_obj:	×
222	row += 1	×
223	sheet.write(row, 0, obj.partner_id.name, left) # obj.partner_id.name	×
224	sheet.write(row, 1, '', top)	×
225	sheet.write(row, 2, '', top)	×
226	sheet.write(row, 3, '', top)	×
227	sheet.write(row, 4, '', top)	×
228	sheet.write(row, 5, '', top)	×
229	sheet.write(row, 6, '', c_middle)	×
230	sheet.write(row, 7, '', c_middle)	×
231	sheet.write(row, 8, '', c_middle)	×
232	sheet.write(row, 9, '', c_middle)	×
233	sheet.write(row, 10, '', c_middle)	×
234	sheet.write(row, 11, '', c_middle)	×
235	sheet.write(row, 12, '', c_middle)	×
236	sheet.write(row, 13, '', c_middle)	×
237	sheet.write(row, 14, '', c_middle)	×
238	sheet.write(row, 15, '', right)	×
239
240	row += 2	×
241	start_row = row	×
242	for i, line in enumerate(lines_obj):	×
243	i += row	×
244	_set_line(line)	×
245
246	row = i	×
247
248	for j, h in enumerate(head):	×
249	sheet.set_column(j, j, h['larg'])	×
250
251	_set_table(start_row, row)	×
252	row += 2	×
253
254	# Pivot
255	sheet = workbook.add_worksheet(report.name)	×
256	_header_sheet(sheet)	×
257
258	# for group_by in data['group_by_data']['ids']:
259	# for line in data['lines_group_by'][group_by]['new_lines']:
260	# if line['type_line'] != 'total':
261	# all_lines.append(line)
262	# Head
263	if all_lines:	×
264	row = 6	×
265	row += 1	×
266	start_row = row	×
267	for i, line in enumerate(all_lines):	×
268	i += row	×
269	_set_line(line)	×
270	row = i	×
271
272	for j, h in enumerate(head):	×
273	sheet.set_column(j, j, h['larg'])	×
274
275	_set_table(start_row, row)	×
276
277	else: # standard report
278
279	if wizard.summary:	×
280	sheet = workbook.add_worksheet(report.name)	×
281	_header_sheet(sheet)	×
282
283	all_lines = wizard.sql_get_line_for_report(type_l=('4_total',))	×
284	# for group_by in data['group_by_data']['ids']:
285	# all_lines.append(data['lines_group_by'][group_by])
286	if all_lines:	×
287	# Head
288	head = [	×
289	{'name': 'Code',
290	'larg': 10,
291	'col': {}},
292	{'name': 'Name',
293	'larg': 30,
294	'col': {}},
295	{'name': 'Debit',
296	'larg': 15,
297	'col': {'total_function': 'sum', 'format': currency_format}},
298	{'name': 'Credit',
299	'larg': 15,
300	'col': {'total_function': 'sum', 'format': currency_format}},
301	{'name': 'Balance',
302	'larg': 15,
303	'col': {'total_function': 'sum', 'format': currency_format}},
304	]
305
306	row = 6	×
307	row += 1	×
308	start_row = row	×
309	for i, line in enumerate(all_lines):	×
310	i += row	×
311	sheet.write(i, 0, line.get('code', ''))	×
312	sheet.write(i, 1, line.get('name', ''))	×
313	sheet.write(i, 2, line.get('debit', ''), currency_format)	×
314	sheet.write(i, 3, line.get('credit', ''), currency_format)	×
315	sheet.write(i, 4, line.get('balance', ''), currency_format)	×
316	row = i	×
317
318	for j, h in enumerate(head):	×
319	sheet.set_column(j, j, h['larg'])	×
320
321	table = []	×
322	for h in head:	×
323	col = {}	×
324	col['header'] = h['name']	×
325	col.update(h['col'])	×
326	table.append(col)	×
327
328	sheet.add_table(start_row - 1, 0, row + 1, len(head) - 1,	×
329	{'total_row': 1,
330	'columns': table,
331	'style': 'Table Style Light 9',
332	})
333
334	else: # not summary
335
336	head = [	×
337	{'name': _('Date'),
338	'larg': 10,
339	'col': {}},
340	{'name': _('JRNL'),
341	'larg': 10,
342	'col': {}},
343	{'name': _('Account'),
344	'larg': 10,
345	'col': {}},
346	{'name': _('Account Name'),
347	'larg': 15,
348	'col': {}},
349	{'name': _('Journal entries'),
350	'larg': 20,
351	'col': {}},
352	{'name': _('Ref'),
353	'larg': 40,
354	'col': {}},
355	{'name': _('Partner'),
356	'larg': 20,
357	'col': {}},
358	{'name': _('Due Date'),
359	'larg': 10,
360	'col': {}},
361	{'name': _('Debit'),
362	'larg': 15,
363	'col': {'total_function': 'sum', 'format': currency_format}},
364	{'name': _('Credit'),
365	'larg': 15,
366	'col': {'total_function': 'sum', 'format': currency_format}},
367	{'name': _('Balance'),
368	'larg': 15,
369	'col': {'format': currency_format}},
370	{'name': _('Match.'),
371	'larg': 10,
372	'col': {}},
373	]
374	table = []	×
375	for h in head:	×
376	col = {'header': h['name']}	×
377	col.update(h['col'])	×
378	table.append(col)	×
379
380	def _set_line(line):	×
381	sheet.write(i, 0, get_date_format(line.get('date', '')) if line.get('type_view') != 'init' else 'INIT')	×
382	sheet.write(i, 1, line.get('j_code', ''))	×
383	sheet.write(i, 2, line.get('a_code', ''))	×
384	sheet.write(i, 3, line.get('a_name', ''))	×
385	sheet.write(i, 4, line.get('move_name', ''))	×
386	sheet.write(i, 5, line.get('displayed_name', ''))	×
387	sheet.write(i, 6, line.get('partner_name', ''))	×
388	sheet.write(i, 7, get_date_format(line.get('date_maturity', '')))	×
389	sheet.write(i, 8, _get_data_float(line.get('debit', '')), currency_format)	×
390	sheet.write(i, 9, _get_data_float(line.get('credit', '')), currency_format)	×
391	sheet.write(i, 10, _get_data_float(line.get('cumul_balance', '')), currency_format)	×
392	sheet.write(i, 11, line.get('matching_number', ''))	×
393
394	def _set_table(start_row, row):	×
395	sheet.add_table(start_row - 1, 0, row + 1, len(head) - 1,	×
396	{'total_row': 1,
397	'columns': table,
398	'style': 'Table Style Light 9',
399	})
400	#sheet.write(row + 1, 10, "=I%s-J%s" % (row + 2, row + 2), currency_format)
401
402	# With total workbook
403	sheet = workbook.add_worksheet(report.name + _(' Totals'))	×
404	_header_sheet(sheet)	×
405
406	row = 6	×
407
408	all_lines = wizard.sql_get_line_for_report(type_l=('0_init', '1_init_line', '2_line'))	×
409	for obj in report.report_object_ids:	×
410	lines_obj = []	×
411	obj_id = obj.id	×
412	for line in all_lines:	×
413	if line.get('report_object_id') == obj_id:	×
414	lines_obj.append(line)	×
415	if lines_obj:	×
416	row += 1	×
417	name_view = ''	×
418	if wizard.type == 'account':	×
419	name_view = obj.account_id.display_name	×
420	if wizard.type == 'partner':	×
421	name_view = obj.partner_id.display_name	×
422	if wizard.type == 'journal':	×
423	name_view = obj.journal_id.display_name	×
424
425	sheet.write(row, 0, name_view, left)	×
426	sheet.write(row, 1, '', top)	×
427	sheet.write(row, 2, '', top)	×
428	sheet.write(row, 3, '', top)	×
429	sheet.write(row, 4, '', top)	×
430	sheet.write(row, 5, '', top)	×
431	sheet.write(row, 6, '', top)	×
432	sheet.write(row, 7, '', top)	×
433	sheet.write(row, 8, '', top)	×
434	sheet.write(row, 9, '', top)	×
435	sheet.write(row, 10, '', top)	×
436	sheet.write(row, 11, '', right)	×
437
438	row += 2	×
439	start_row = row	×
440	for i, line in enumerate(lines_obj):	×
441	i += row	×
442	_set_line(line)	×
443
444	row = i	×
445
446	for j, h in enumerate(head):	×
447	sheet.set_column(j, j, h['larg'])	×
448
449	_set_table(start_row, row)	×
450	row += 2	×
451
452	# Pivot workbook
453	sheet = workbook.add_worksheet(report.name)	×
454	_header_sheet(sheet)	×
455
456	# Head
457	if all_lines:	×
458	row = 6	×
459	row += 1	×
460	start_row = row	×
461	for i, line in enumerate(all_lines):	×
462	i += row	×
463	_set_line(line)	×
464	row = i	×
465
466	for j, h in enumerate(head):	×
467	sheet.set_column(j, j, h['larg'])	×
468
469	_set_table(start_row, row)	×
470
471
472	AccountStandardExcel('report.account_standard_report.report_account_standard_excel', 'account.report.standard.ledger')	2✔

OCA / account-financial-reporting / 1238

Source File Press 'n' to go to next uncovered line, 'b' for previous

Source File
Press 'n' to go to next uncovered line, 'b' for previous