blob: 1150be0c13a39da7008020385132d575691f8320 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
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
|
