1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
|
# -*- coding: utf-8 -*-
#############################################################################
#
# Cybrosys Technologies Pvt. Ltd.
#
# Copyright (C) 2019-TODAY Cybrosys Technologies(<https://www.cybrosys.com>)
# Author: Cybrosys Techno Solutions(<https://www.cybrosys.com>)
#
# You can modify it under the terms of the GNU LESSER
# GENERAL PUBLIC LICENSE (LGPL v3), Version 3.
#
# 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 LESSER GENERAL PUBLIC LICENSE (LGPL v3) for more details.
#
# You should have received a copy of the GNU LESSER GENERAL PUBLIC LICENSE
# (LGPL v3) along with this program.
# If not, see <http://www.gnu.org/licenses/>.
#
#############################################################################
from odoo import api, fields, models
# ---------------------------------------------------------
# Account Financial Report
# ---------------------------------------------------------
class AccountFinancialReport(models.Model):
_name = "account.financial.report"
_description = "Account Report"
_rec_name = 'name'
@api.depends('parent_id', 'parent_id.level')
def _get_level(self):
"""Returns a dictionary with key=the ID of a record and
value = the level of this
record in the tree structure."""
for report in self:
level = 0
if report.parent_id:
level = report.parent_id.level + 1
report.level = level
def _get_children_by_order(self):
"""returns a recordset of all the children computed recursively,
and sorted by sequence. Ready for the printing"""
res = self
children = self.search([('parent_id', 'in', self.ids)],
order='sequence ASC')
if children:
for child in children:
res += child._get_children_by_order()
return res
name = fields.Char('Report Name', required=True, translate=True)
parent_id = fields.Many2one('account.financial.report', 'Parent')
children_ids = fields.One2many(
'account.financial.report',
'parent_id',
'Account Report')
sequence = fields.Integer('Sequence')
level = fields.Integer(compute='_get_level', string='Level', store=True)
type = fields.Selection(
[('sum', 'View'),
('accounts', 'Accounts'),
('account_type', 'Account Type'),
('account_report', 'Report Value')],
'Type',
default='sum')
account_ids = fields.Many2many(
'account.account',
'account_account_financial_report',
'report_line_id',
'account_id',
'Accounts')
account_report_id = fields.Many2one(
'account.financial.report',
'Report Value')
account_type_ids = fields.Many2many(
'account.account.type',
'account_account_financial_report_type',
'report_id', 'account_type_id',
'Account Types')
sign = fields.Selection(
[("-1", 'Reverse balance sign'), ("1", 'Preserve balance sign')],
'Sign on Reports', required=True, default="1",
help='For accounts that are typically more'
' debited than credited and that you'
' would like to print as negative'
' amounts in your reports, you should'
' reverse the sign of the balance;'
' e.g.: Expense account. The same applies'
' for accounts that are typically more'
' credited than debited and that you would'
' like to print as positive amounts in'
' your reports; e.g.: Income account.')
display_detail = fields.Selection(
[('no_detail', 'No detail'),
('detail_flat', 'Display children flat'),
('detail_with_hierarchy', 'Display children with hierarchy')],
'Display details',
default='detail_flat')
style_overwrite = fields.Selection(
[('0', 'Automatic formatting'),
('1', 'Main Title 1 (bold, underlined)'),
('2', 'Title 2 (bold)'),
('3', 'Title 3 (bold, smaller)'),
('4', 'Normal Text'),
('5', 'Italic Text (smaller)'),
('6', 'Smallest Text')],
'Financial Report Style',
default='0',
help="You can set up here the format you want this"
" record to be displayed. If you leave the"
" automatic formatting, it will be computed"
" based on the financial reports hierarchy "
"(auto-computed field 'level').")
|
