initial commit 2

3 files changed, 70 insertions, 0 deletions

diff --git a/addons/l10n_ar/report/__init__.py b/addons/l10n_ar/report/__init__.py
new file mode 100644
index 00000000..a622bd9b
--- /dev/null
+++ b/addons/l10n_ar/report/__init__.py
@@ -0,0 +1,3 @@
+# Part of Odoo. See LICENSE file for full copyright and licensing details.
+
+from . import invoice_report
diff --git a/addons/l10n_ar/report/invoice_report.py b/addons/l10n_ar/report/invoice_report.py
new file mode 100644
index 00000000..ed2be05b
--- /dev/null
+++ b/addons/l10n_ar/report/invoice_report.py
@@ -0,0 +1,21 @@
+# Part of Odoo. See LICENSE file for full copyright and licensing details.
+from odoo import models, fields
+
+
+class AccountInvoiceReport(models.Model):
+
+    _inherit = 'account.invoice.report'
+
+    l10n_ar_state_id = fields.Many2one('res.country.state', 'State', readonly=True)
+    date = fields.Date(readonly=True, string="Accounting Date")
+
+    _depends = {
+        'account.move': ['partner_id', 'date'],
+        'res.partner': ['state_id'],
+    }
+
+    def _select(self):
+        return super()._select() + ", contact_partner.state_id as l10n_ar_state_id, move.date"
+
+    def _from(self):
+        return super()._from() + " LEFT JOIN res_partner contact_partner ON contact_partner.id = move.partner_id"
diff --git a/addons/l10n_ar/report/invoice_report_view.xml b/addons/l10n_ar/report/invoice_report_view.xml
new file mode 100644
index 00000000..1f760c0b
--- /dev/null
+++ b/addons/l10n_ar/report/invoice_report_view.xml
@@ -0,0 +1,46 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<odoo>
+
+    <record model="ir.ui.view" id="view_account_invoice_report_search_inherit">
+        <field name="name">account.invoice.report.search</field>
+        <field name="model">account.invoice.report</field>
+        <field name="inherit_id" ref="account.view_account_invoice_report_search" />
+        <field name="arch" type="xml">
+            <search>
+                <field name="l10n_ar_state_id"/>
+                <filter name="with_document" string="With Document" domain="[('l10n_latam_document_type_id', '!=', False)]"/>
+            </search>
+            <filter name="user" position="after">
+                <filter string="State" name="groupby_l10n_ar_state_id" context="{'group_by': 'l10n_ar_state_id'}"/>
+                <filter string="Account" name="groupby_account_id" context="{'group_by':'account_id'}" groups="account.group_account_readonly" />
+            </filter>
+        </field>
+    </record>
+
+    <record id="action_iibb_sales_by_state_and_account_pivot" model="ir.actions.act_window">
+        <field name="name">IIBB - Sales by jurisdiction</field>
+        <field name="res_model">account.invoice.report</field>
+        <field name="view_mode">pivot</field>
+        <field name="context">{'search_default_current': 1, 'search_default_customer': 1, 'search_default_with_document': 1, 'search_default_company': 1, 'search_default_groupby_l10n_ar_state_id': 2, 'search_default_groupby_account_id': 3, 'time_ranges': {'field': 'date', 'range': 'this_year'}}</field>
+    </record>
+
+    <menuitem
+        id="menu_iibb_sales_by_state_and_account"
+        action="action_iibb_sales_by_state_and_account_pivot"
+        parent="l10n_ar.account_reports_ar_statements_menu"
+        sequence="30"/>
+
+    <record id="action_iibb_purchases_by_state_and_account_pivot" model="ir.actions.act_window">
+        <field name="name">IIBB - Purchases by jurisdiction</field>
+        <field name="res_model">account.invoice.report</field>
+        <field name="view_mode">pivot</field>
+        <field name="context">{'search_default_current': 1, 'search_default_supplier': 1, 'search_default_with_document': 1, 'search_default_company': 1, 'search_default_groupby_l10n_ar_state_id': 2, 'search_default_groupby_account_id': 3, 'time_ranges': {'field': 'date', 'range': 'this_year'}}</field>
+    </record>
+
+    <menuitem
+        id="menu_iibb_purchases_by_state_and_account"
+        action="action_iibb_purchases_by_state_and_account_pivot"
+        parent="l10n_ar.account_reports_ar_statements_menu"
+        sequence="40"/>
+
+</odoo>