initial commit 2

2 files changed, 18 insertions, 0 deletions

diff --git a/addons/sale_margin/report/__init__.py b/addons/sale_margin/report/__init__.py
new file mode 100644
index 00000000..7b0761d5
--- /dev/null
+++ b/addons/sale_margin/report/__init__.py
@@ -0,0 +1,4 @@
+# -*- coding: utf-8 -*-
+# Part of Odoo. See LICENSE file for full copyright and licensing details.
+
+from . import sale_report
diff --git a/addons/sale_margin/report/sale_report.py b/addons/sale_margin/report/sale_report.py
new file mode 100644
index 00000000..1ac87891
--- /dev/null
+++ b/addons/sale_margin/report/sale_report.py
@@ -0,0 +1,14 @@
+# -*- coding: utf-8 -*-
+# Part of Odoo. See LICENSE file for full copyright and licensing details.
+
+from odoo import fields, models
+
+
+class SaleReport(models.Model):
+    _inherit = 'sale.report'
+
+    margin = fields.Float('Margin')
+
+    def _query(self, with_clause='', fields={}, groupby='', from_clause=''):
+        fields['margin'] = ", SUM(l.margin / CASE COALESCE(s.currency_rate, 0) WHEN 0 THEN 1.0 ELSE s.currency_rate END) AS margin"
+        return super(SaleReport, self)._query(with_clause, fields, groupby, from_clause)