1 files changed, 119 insertions, 0 deletions
diff --git a/base_accounting_kit/report/report_financial.py b/base_accounting_kit/report/report_financial.py
new file mode 100644
index 0000000..bdf5801
--- /dev/null
+++ b/base_accounting_kit/report/report_financial.py
@@ -0,0 +1,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').")