initial commit 2

4 files changed, 61 insertions, 0 deletions

diff --git a/addons/l10n_in_sale/report/__init__.py b/addons/l10n_in_sale/report/__init__.py
new file mode 100644
index 00000000..1d16e0da
--- /dev/null
+++ b/addons/l10n_in_sale/report/__init__.py
@@ -0,0 +1,6 @@
+# -*- coding: utf-8 -*-
+# Part of Odoo. See LICENSE file for full copyright and licensing details.
+
+from . import account_invoice_report
+from . import exempted_gst_report
+from . import hsn_gst_report
diff --git a/addons/l10n_in_sale/report/account_invoice_report.py b/addons/l10n_in_sale/report/account_invoice_report.py
new file mode 100644
index 00000000..1150be0c
--- /dev/null
+++ b/addons/l10n_in_sale/report/account_invoice_report.py
@@ -0,0 +1,25 @@
+# -*- coding: utf-8 -*-
+# Part of Odoo. See LICENSE file for full copyright and licensing details.
+
+from odoo import models
+
+
+class L10nInAccountInvoiceReport(models.Model):
+    _inherit = "l10n_in.account.invoice.report"
+
+    def _from(self):
+        from_str = super(L10nInAccountInvoiceReport, self)._from()
+        return from_str.replace(
+            "LEFT JOIN res_country_state ps ON ps.id = p.state_id",
+            """
+            LEFT JOIN res_partner dp ON dp.id = am.partner_shipping_id
+            LEFT JOIN res_country_state ps ON ps.id = dp.state_id
+            """
+        )
+
+    def _where(self):
+        where_str = super(L10nInAccountInvoiceReport, self)._where()
+        where_str += """ AND (aml.product_id IS NULL or aml.product_id != COALESCE(
+            (SELECT value from ir_config_parameter where key = 'sale.default_deposit_product_id'), '0')::int)
+            """
+        return where_str
diff --git a/addons/l10n_in_sale/report/exempted_gst_report.py b/addons/l10n_in_sale/report/exempted_gst_report.py
new file mode 100644
index 00000000..9664f12d
--- /dev/null
+++ b/addons/l10n_in_sale/report/exempted_gst_report.py
@@ -0,0 +1,15 @@
+# -*- coding: utf-8 -*-
+# Part of Odoo. See LICENSE file for full copyright and licensing details.
+
+from odoo import models
+
+
+class L10nInExemptedReport(models.Model):
+    _inherit = "l10n_in.exempted.report"
+
+    def _from(self):
+        from_str = super(L10nInExemptedReport, self)._from()
+        from_str += """ AND aml.product_id != COALESCE(
+            (SELECT value from ir_config_parameter where key = 'sale.default_deposit_product_id'), '0')::int
+            """
+        return from_str
diff --git a/addons/l10n_in_sale/report/hsn_gst_report.py b/addons/l10n_in_sale/report/hsn_gst_report.py
new file mode 100644
index 00000000..615eaef1
--- /dev/null
+++ b/addons/l10n_in_sale/report/hsn_gst_report.py
@@ -0,0 +1,15 @@
+# -*- coding: utf-8 -*-
+# Part of Odoo. See LICENSE file for full copyright and licensing details.
+
+from odoo import models
+
+
+class L10nInProductHsnReport(models.Model):
+    _inherit = "l10n_in.product.hsn.report"
+
+    def _from(self):
+        from_str = super(L10nInProductHsnReport, self)._from()
+        from_str += """ AND aml.product_id != COALESCE(
+            (SELECT value from ir_config_parameter where key = 'sale.default_deposit_product_id'), '0')::int
+            """
+        return from_str