Odoo18-Base/addons/website_sale/report/sale_report.py
2025-01-06 10:57:38 +07:00

34 lines
1.1 KiB
Python

# coding: utf-8
# Part of Odoo. See LICENSE file for full copyright and licensing details.
from odoo import api, fields, models
class SaleReport(models.Model):
_inherit = 'sale.report'
website_id = fields.Many2one('website', readonly=True)
is_abandoned_cart = fields.Boolean(string="Abandoned Cart", readonly=True)
def _select_additional_fields(self):
res = super()._select_additional_fields()
res['website_id'] = "s.website_id"
res['is_abandoned_cart'] = """
s.date_order <= (timezone('utc', now()) - ((COALESCE(w.cart_abandoned_delay, '1.0') || ' hour')::INTERVAL))
AND s.website_id IS NOT NULL
AND s.state = 'draft'
AND s.partner_id != %s""" % self.env.ref('base.public_partner').id
return res
def _from_sale(self):
res = super()._from_sale()
res += """
LEFT JOIN website w ON w.id = s.website_id"""
return res
def _group_by_sale(self):
res = super()._group_by_sale()
res += """,
s.website_id,
w.cart_abandoned_delay"""
return res