105 lines
3.6 KiB
Python
Executable File
105 lines
3.6 KiB
Python
Executable File
# This file is part of Tryton. The COPYRIGHT file at the top level of
|
|
# this repository contains the full copyright notices and license terms.
|
|
from trytond.model import DeactivableMixin, ModelSQL, ModelView, Unique, fields
|
|
from trytond.pool import Pool
|
|
from trytond.pyson import Eval
|
|
from trytond.rpc import RPC
|
|
from trytond.transaction import Transaction
|
|
|
|
|
|
class Journal(DeactivableMixin, ModelSQL, ModelView):
|
|
'Statement Journal'
|
|
__name__ = 'account.statement.journal'
|
|
name = fields.Char('Name', required=True)
|
|
journal = fields.Many2One(
|
|
'account.journal', 'Journal', required=True,
|
|
domain=[('type', '=', 'statement')],
|
|
context={
|
|
'company': Eval('company', -1),
|
|
},
|
|
depends={'company'})
|
|
currency = fields.Many2One('currency.currency', 'Currency', required=True)
|
|
company = fields.Many2One('company.company', "Company", required=True)
|
|
company_party = fields.Function(
|
|
fields.Many2One(
|
|
'party.party', "Company Party",
|
|
context={
|
|
'company': Eval('company', -1),
|
|
},
|
|
depends={'company'}),
|
|
'on_change_with_company_party')
|
|
validation = fields.Selection([
|
|
('balance', 'Balance'),
|
|
('amount', 'Amount'),
|
|
('number_of_lines', 'Number of Lines'),
|
|
], 'Validation Type', required=True)
|
|
bank_account = fields.Many2One(
|
|
'bank.account', "Bank Account",
|
|
domain=[
|
|
('owners.id', '=', Eval('company_party', -1)),
|
|
['OR',
|
|
('currency', '=', Eval('currency', -1)),
|
|
('currency', '=', None),
|
|
],
|
|
])
|
|
account = fields.Many2One('account.account', "Account", required=True,
|
|
domain=[
|
|
('type', '!=', None),
|
|
('closed', '!=', True),
|
|
('company', '=', Eval('company')),
|
|
('party_required', '=', False),
|
|
])
|
|
|
|
@classmethod
|
|
def __setup__(cls):
|
|
super(Journal, cls).__setup__()
|
|
cls._order.insert(0, ('name', 'ASC'))
|
|
t = cls.__table__()
|
|
cls._sql_constraints = [
|
|
('bank_account_unique',
|
|
Unique(t, t.bank_account, t.company),
|
|
'account_statement.msg_journal_bank_account_unique'),
|
|
]
|
|
cls.__rpc__.update(
|
|
get_by_bank_account=RPC(
|
|
result=lambda r: int(r) if r is not None else None),
|
|
)
|
|
|
|
@staticmethod
|
|
def default_currency():
|
|
if Transaction().context.get('company'):
|
|
Company = Pool().get('company.company')
|
|
company = Company(Transaction().context['company'])
|
|
return company.currency.id
|
|
|
|
@staticmethod
|
|
def default_company():
|
|
return Transaction().context.get('company')
|
|
|
|
@fields.depends('company')
|
|
def on_change_with_company_party(self, name=None):
|
|
return self.company.party if self.company else None
|
|
|
|
@staticmethod
|
|
def default_validation():
|
|
return 'balance'
|
|
|
|
@classmethod
|
|
def get_by_bank_account(cls, company, number, currency=None):
|
|
domain = [
|
|
('company', '=', company),
|
|
['OR',
|
|
('bank_account.numbers.number', '=', number),
|
|
('bank_account.numbers.number_compact', '=', number),
|
|
],
|
|
]
|
|
if currency:
|
|
domain.append(['OR',
|
|
('currency.code', '=', currency),
|
|
('currency.numeric_code', '=', currency),
|
|
])
|
|
journals = cls.search(domain)
|
|
if journals:
|
|
journal, = journals
|
|
return journal
|