2009-10-13 05:58:37 +00:00
# -*- coding: utf-8 -*-
2006-12-07 13:41:40 +00:00
##############################################################################
2009-11-30 10:24:22 +00:00
#
2009-10-14 11:15:34 +00:00
# OpenERP, Open Source Management Solution
2010-01-12 09:18:39 +00:00
# Copyright (C) 2004-2010 Tiny SPRL (<http://tiny.be>).
2006-12-07 13:41:40 +00:00
#
2008-11-03 19:18:56 +00:00
# This program is free software: you can redistribute it and/or modify
2009-10-14 11:15:34 +00:00
# it under the terms of the GNU Affero General Public License as
# published by the Free Software Foundation, either version 3 of the
# License, or (at your option) any later version.
2006-12-07 13:41:40 +00:00
#
2008-11-03 19:18:56 +00:00
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
2009-10-14 11:15:34 +00:00
# GNU Affero General Public License for more details.
2006-12-07 13:41:40 +00:00
#
2009-10-14 11:15:34 +00:00
# You should have received a copy of the GNU Affero General Public License
2009-11-30 10:24:22 +00:00
# along with this program. If not, see <http://www.gnu.org/licenses/>.
2006-12-07 13:41:40 +00:00
#
##############################################################################
2010-10-15 07:14:33 +00:00
2010-06-10 13:34:19 +00:00
from operator import itemgetter
2012-09-18 12:46:40 +00:00
import time
2006-12-07 13:41:40 +00:00
2012-12-06 14:56:32 +00:00
from openerp . osv import fields , osv
2014-07-06 14:44:26 +00:00
from openerp import api
2012-12-06 14:56:32 +00:00
2008-10-20 20:49:11 +00:00
class account_fiscal_position ( osv . osv ) :
_name = ' account.fiscal.position '
2010-10-09 16:01:43 +00:00
_description = ' Fiscal Position '
2014-06-29 21:31:16 +00:00
_order = ' sequence '
2008-10-20 20:49:11 +00:00
_columns = {
2014-06-29 21:31:16 +00:00
' sequence ' : fields . integer ( ' Sequence ' ) ,
2014-05-21 09:52:05 +00:00
' name ' : fields . char ( ' Fiscal Position ' , required = True ) ,
2011-08-24 21:19:43 +00:00
' active ' : fields . boolean ( ' Active ' , help = " By unchecking the active field, you may hide a fiscal position without deleting it. " ) ,
2008-10-20 20:49:11 +00:00
' company_id ' : fields . many2one ( ' res.company ' , ' Company ' ) ,
2014-07-06 14:44:26 +00:00
' account_ids ' : fields . one2many ( ' account.fiscal.position.account ' , ' position_id ' , ' Account Mapping ' , copy = True ) ,
' tax_ids ' : fields . one2many ( ' account.fiscal.position.tax ' , ' position_id ' , ' Tax Mapping ' , copy = True ) ,
2014-06-11 12:53:59 +00:00
' note ' : fields . text ( ' Notes ' ) ,
2015-01-26 10:21:28 +00:00
' auto_apply ' : fields . boolean ( ' Automatic ' , help = " Apply automatically this fiscal position if the conditions match. " ) ,
2014-06-29 21:31:16 +00:00
' vat_required ' : fields . boolean ( ' VAT required ' , help = " Apply only if partner has a VAT number. " ) ,
2015-01-26 10:21:28 +00:00
' country_id ' : fields . many2one ( ' res.country ' , ' Country ' , help = " Apply when the shipping or invoicing country matches. Takes precedence over positions matching on a country group. " ) ,
' country_group_id ' : fields . many2one ( ' res.country.group ' , ' Country Group ' , help = " Apply when the shipping or invoicing country is in this country group, and no position matches the country directly. " ) ,
2008-10-20 20:49:11 +00:00
}
2009-01-19 16:49:29 +00:00
2011-08-24 21:19:43 +00:00
_defaults = {
' active ' : True ,
}
2014-09-29 10:26:13 +00:00
def _check_country ( self , cr , uid , ids , context = None ) :
obj = self . browse ( cr , uid , ids [ 0 ] , context = context )
if obj . country_id and obj . country_group_id :
return False
return True
_constraints = [
( _check_country , ' You can not select a country and a group of countries ' , [ ' country_id ' , ' country_group_id ' ] ) ,
]
2014-07-06 14:44:26 +00:00
@api.v7
2010-11-19 13:48:01 +00:00
def map_tax ( self , cr , uid , fposition_id , taxes , context = None ) :
2009-01-26 15:39:56 +00:00
if not taxes :
return [ ]
2009-01-19 16:49:29 +00:00
if not fposition_id :
2008-10-21 16:28:19 +00:00
return map ( lambda x : x . id , taxes )
2012-07-25 06:51:39 +00:00
result = set ( )
2008-10-21 14:57:42 +00:00
for t in taxes :
ok = False
2009-01-19 16:49:29 +00:00
for tax in fposition_id . tax_ids :
if tax . tax_src_id . id == t . id :
2008-10-21 14:57:42 +00:00
if tax . tax_dest_id :
2012-07-25 06:51:39 +00:00
result . add ( tax . tax_dest_id . id )
2008-10-21 14:57:42 +00:00
ok = True
if not ok :
2012-07-25 06:51:39 +00:00
result . add ( t . id )
return list ( result )
2008-10-21 14:57:42 +00:00
2014-08-04 17:41:43 +00:00
@api.v8 # noqa
2014-07-06 14:44:26 +00:00
def map_tax ( self , taxes ) :
2014-08-05 07:30:14 +00:00
result = self . env [ ' account.tax ' ] . browse ( )
2014-07-06 14:44:26 +00:00
for tax in taxes :
2014-10-28 12:30:26 +00:00
tax_count = 0
2014-07-06 14:44:26 +00:00
for t in self . tax_ids :
if t . tax_src_id == tax :
2014-10-29 18:42:13 +00:00
tax_count + = 1
2014-08-04 17:41:43 +00:00
if t . tax_dest_id :
result | = t . tax_dest_id
2014-10-28 12:30:26 +00:00
if not tax_count :
2014-07-06 14:44:26 +00:00
result | = tax
return result
@api.v7
2010-11-19 13:48:01 +00:00
def map_account ( self , cr , uid , fposition_id , account_id , context = None ) :
2010-10-11 05:51:53 +00:00
if not fposition_id :
2008-10-20 20:49:11 +00:00
return account_id
2009-01-19 16:49:29 +00:00
for pos in fposition_id . account_ids :
2010-08-30 06:28:31 +00:00
if pos . account_src_id . id == account_id :
2008-10-20 20:49:11 +00:00
account_id = pos . account_dest_id . id
break
return account_id
2014-07-06 14:44:26 +00:00
@api.v8
def map_account ( self , account ) :
for pos in self . account_ids :
if pos . account_src_id == account :
return pos . account_dest_id
return account
2014-06-29 21:31:16 +00:00
def get_fiscal_position ( self , cr , uid , company_id , partner_id , delivery_id = None , context = None ) :
if not partner_id :
return False
# This can be easily overriden to apply more complex fiscal rules
part_obj = self . pool [ ' res.partner ' ]
partner = part_obj . browse ( cr , uid , partner_id , context = context )
# if no delivery use invocing
if delivery_id :
delivery = part_obj . browse ( cr , uid , delivery_id , context = context )
else :
delivery = partner
2015-06-19 12:31:41 +00:00
# partner manually set fiscal position always win
if delivery . property_account_position or partner . property_account_position :
2015-06-23 14:28:31 +00:00
return delivery . property_account_position . id or partner . property_account_position . id
2015-06-19 12:31:41 +00:00
2015-03-23 12:55:35 +00:00
domains = [ [ ( ' auto_apply ' , ' = ' , True ) , ( ' vat_required ' , ' = ' , partner . vat_subjected ) ] ]
if partner . vat_subjected :
# Possibly allow fallback to non-VAT positions, if no VAT-required position matches
domains + = [ [ ( ' auto_apply ' , ' = ' , True ) , ( ' vat_required ' , ' = ' , False ) ] ]
for domain in domains :
if delivery . country_id . id :
fiscal_position_ids = self . search ( cr , uid , domain + [ ( ' country_id ' , ' = ' , delivery . country_id . id ) ] , context = context , limit = 1 )
if fiscal_position_ids :
return fiscal_position_ids [ 0 ]
fiscal_position_ids = self . search ( cr , uid , domain + [ ( ' country_group_id.country_ids ' , ' = ' , delivery . country_id . id ) ] , context = context , limit = 1 )
if fiscal_position_ids :
return fiscal_position_ids [ 0 ]
fiscal_position_ids = self . search ( cr , uid , domain + [ ( ' country_id ' , ' = ' , None ) , ( ' country_group_id ' , ' = ' , None ) ] , context = context , limit = 1 )
2015-02-04 12:06:00 +00:00
if fiscal_position_ids :
return fiscal_position_ids [ 0 ]
2014-06-29 21:31:16 +00:00
return False
2008-10-20 20:49:11 +00:00
2008-10-21 14:57:42 +00:00
class account_fiscal_position_tax ( osv . osv ) :
_name = ' account.fiscal.position.tax '
2010-10-09 16:01:43 +00:00
_description = ' Taxes Fiscal Position '
2008-10-21 14:57:42 +00:00
_rec_name = ' position_id '
_columns = {
2010-10-09 16:01:43 +00:00
' position_id ' : fields . many2one ( ' account.fiscal.position ' , ' Fiscal Position ' , required = True , ondelete = ' cascade ' ) ,
2008-10-21 14:57:42 +00:00
' tax_src_id ' : fields . many2one ( ' account.tax ' , ' Tax Source ' , required = True ) ,
' tax_dest_id ' : fields . many2one ( ' account.tax ' , ' Replacement Tax ' )
}
2012-07-25 06:51:39 +00:00
_sql_constraints = [
( ' tax_src_dest_uniq ' ,
' unique (position_id,tax_src_id,tax_dest_id) ' ,
' A tax fiscal position could be defined only once time on same taxes. ' )
]
2008-10-21 14:57:42 +00:00
2008-10-20 20:49:11 +00:00
class account_fiscal_position_account ( osv . osv ) :
_name = ' account.fiscal.position.account '
2010-10-09 16:01:43 +00:00
_description = ' Accounts Fiscal Position '
2008-10-20 20:49:11 +00:00
_rec_name = ' position_id '
_columns = {
2010-10-09 16:01:43 +00:00
' position_id ' : fields . many2one ( ' account.fiscal.position ' , ' Fiscal Position ' , required = True , ondelete = ' cascade ' ) ,
2009-01-14 13:33:59 +00:00
' account_src_id ' : fields . many2one ( ' account.account ' , ' Account Source ' , domain = [ ( ' type ' , ' <> ' , ' view ' ) ] , required = True ) ,
' account_dest_id ' : fields . many2one ( ' account.account ' , ' Account Destination ' , domain = [ ( ' type ' , ' <> ' , ' view ' ) ] , required = True )
2008-10-20 20:49:11 +00:00
}
2010-10-15 07:14:33 +00:00
2012-07-25 06:51:39 +00:00
_sql_constraints = [
( ' account_src_dest_uniq ' ,
' unique (position_id,account_src_id,account_dest_id) ' ,
' An account fiscal position could be defined only once time on same accounts. ' )
]
2008-10-20 20:49:11 +00:00
2006-12-07 13:41:40 +00:00
class res_partner ( osv . osv ) :
2008-07-22 15:11:28 +00:00
_name = ' res.partner '
_inherit = ' res.partner '
_description = ' Partner '
2010-06-18 11:15:59 +00:00
2010-10-15 07:14:33 +00:00
def _credit_debit_get ( self , cr , uid , ids , field_names , arg , context = None ) :
2013-09-01 06:44:06 +00:00
ctx = context . copy ( )
ctx [ ' all_fiscalyear ' ] = True
query = self . pool . get ( ' account.move.line ' ) . _query_get ( cr , uid , context = ctx )
2010-06-10 13:34:19 +00:00
cr . execute ( """ SELECT l.partner_id, a.type, SUM(l.debit-l.credit)
FROM account_move_line l
LEFT JOIN account_account a ON ( l . account_id = a . id )
WHERE a . type IN ( ' receivable ' , ' payable ' )
2010-06-14 10:47:04 +00:00
AND l . partner_id IN % s
2010-06-10 13:34:19 +00:00
AND l . reconcile_id IS NULL
AND """ + query + """
GROUP BY l . partner_id , a . type
""" ,
( tuple ( ids ) , ) )
2008-09-07 23:24:39 +00:00
maps = { ' receivable ' : ' credit ' , ' payable ' : ' debit ' }
res = { }
for id in ids :
res [ id ] = { } . fromkeys ( field_names , 0 )
2008-08-18 21:08:08 +00:00
for pid , type , val in cr . fetchall ( ) :
2009-04-23 12:07:15 +00:00
if val is None : val = 0
2009-01-19 16:41:58 +00:00
res [ pid ] [ maps [ type ] ] = ( type == ' receivable ' ) and val or - val
2008-07-22 15:11:28 +00:00
return res
2010-06-18 11:15:59 +00:00
2010-06-10 13:34:19 +00:00
def _asset_difference_search ( self , cr , uid , obj , name , type , args , context = None ) :
2010-10-11 05:51:53 +00:00
if not args :
2010-06-16 11:51:39 +00:00
return [ ]
having_values = tuple ( map ( itemgetter ( 2 ) , args ) )
where = ' AND ' . join (
2012-12-06 11:03:15 +00:00
map ( lambda x : ' (SUM(bal2) %(operator)s %% s) ' % {
2010-06-16 11:51:39 +00:00
' operator ' : x [ 1 ] } , args ) )
query = self . pool . get ( ' account.move.line ' ) . _query_get ( cr , uid , context = context )
2012-12-06 11:03:15 +00:00
cr . execute ( ( ' SELECT pid AS partner_id, SUM(bal2) FROM ' \
' (SELECT CASE WHEN bal IS NOT NULL THEN bal ' \
' ELSE 0.0 END AS bal2, p.id as pid FROM ' \
' (SELECT (debit-credit) AS bal, partner_id ' \
' FROM account_move_line l ' \
' WHERE account_id IN ' \
' (SELECT id FROM account_account ' \
' WHERE type= %s AND active) ' \
' AND reconcile_id IS NULL ' \
' AND ' + query + ' ) AS l ' \
' RIGHT JOIN res_partner p ' \
' ON p.id = partner_id ) AS pl ' \
' GROUP BY pid HAVING ' + where ) ,
( type , ) + having_values )
2010-06-16 11:51:39 +00:00
res = cr . fetchall ( )
2010-10-11 05:51:53 +00:00
if not res :
2010-06-16 11:51:39 +00:00
return [ ( ' id ' , ' = ' , ' 0 ' ) ]
return [ ( ' id ' , ' in ' , map ( itemgetter ( 0 ) , res ) ) ]
2010-06-18 11:15:59 +00:00
2010-12-13 06:43:09 +00:00
def _credit_search ( self , cr , uid , obj , name , args , context = None ) :
2010-06-10 13:34:19 +00:00
return self . _asset_difference_search ( cr , uid , obj , name , ' receivable ' , args , context = context )
2006-12-07 13:41:40 +00:00
2010-12-13 06:43:09 +00:00
def _debit_search ( self , cr , uid , obj , name , args , context = None ) :
2010-06-10 13:34:19 +00:00
return self . _asset_difference_search ( cr , uid , obj , name , ' payable ' , args , context = context )
2006-12-07 13:41:40 +00:00
2014-04-18 09:37:56 +00:00
def _invoice_total ( self , cr , uid , ids , field_name , arg , context = None ) :
result = { }
account_invoice_report = self . pool . get ( ' account.invoice.report ' )
2015-06-10 15:47:04 +00:00
user = self . pool [ ' res.users ' ] . browse ( cr , uid , uid , context = context )
user_currency_id = user . company_id . currency_id . id
for partner_id in ids :
all_partner_ids = self . pool [ ' res.partner ' ] . search (
cr , uid , [ ( ' id ' , ' child_of ' , partner_id ) ] , context = context )
# searching account.invoice.report via the orm is comparatively expensive
# (generates queries "id in []" forcing to build the full table).
# In simple cases where all invoices are in the same currency than the user's company
# access directly these elements
# generate where clause to include multicompany rules
where_query = account_invoice_report . _where_calc ( cr , uid , [
( ' partner_id ' , ' in ' , all_partner_ids ) , ( ' state ' , ' not in ' , [ ' draft ' , ' cancel ' ] )
] , context = context )
account_invoice_report . _apply_ir_rules ( cr , uid , where_query , ' read ' , context = context )
from_clause , where_clause , where_clause_params = where_query . get_sql ( )
query = """ WITH currency_rate (currency_id, rate, date_start, date_end) AS (
SELECT r . currency_id , r . rate , r . name AS date_start ,
( SELECT name FROM res_currency_rate r2
WHERE r2 . name > r . name AND
r2 . currency_id = r . currency_id
ORDER BY r2 . name ASC
LIMIT 1 ) AS date_end
FROM res_currency_rate r
)
SELECT SUM ( price_total * cr . rate ) as total
FROM account_invoice_report account_invoice_report , currency_rate cr
WHERE % s
AND cr . currency_id = % % s
AND ( COALESCE ( account_invoice_report . date , NOW ( ) ) > = cr . date_start )
AND ( COALESCE ( account_invoice_report . date , NOW ( ) ) < cr . date_end OR cr . date_end IS NULL )
""" % where_clause
# price_total is in the currency with rate = 1
# total_invoice should be displayed in the current user's currency
2021-02-18 00:10:10 +00:00
# HACK: Avoid super expensive query taking 290s, see https://projects.sysmocom.de/issues/5379
#cr.execute(query, where_clause_params + [user_currency_id])
#result[partner_id] = cr.fetchone()[0]
result [ partner_id ] = 0
2015-06-10 15:47:04 +00:00
2014-04-18 09:37:56 +00:00
return result
def _journal_item_count ( self , cr , uid , ids , field_name , arg , context = None ) :
2014-05-07 12:13:10 +00:00
MoveLine = self . pool ( ' account.move.line ' )
AnalyticAccount = self . pool ( ' account.analytic.account ' )
2015-04-09 15:19:09 +00:00
results = { }
for partner_id in ids :
results [ partner_id ] = { }
if ' contracts_count ' in field_name :
results [ partner_id ] [ ' contracts_count ' ] = AnalyticAccount . search_count ( cr , uid , [ ( ' partner_id ' , ' = ' , partner_id ) ] , context = context )
if ' journal_item_count ' in field_name :
results [ partner_id ] [ ' journal_item_count ' ] = MoveLine . search_count ( cr , uid , [ ( ' partner_id ' , ' = ' , partner_id ) ] , context = context )
return results
2014-03-14 14:01:14 +00:00
2012-09-18 12:46:40 +00:00
def has_something_to_reconcile ( self , cr , uid , partner_id , context = None ) :
'''
at least a debit , a credit and a line older than the last reconciliation date of the partner
'''
cr . execute ( '''
SELECT l . partner_id , SUM ( l . debit ) AS debit , SUM ( l . credit ) AS credit
FROM account_move_line l
RIGHT JOIN account_account a ON ( a . id = l . account_id )
RIGHT JOIN res_partner p ON ( l . partner_id = p . id )
WHERE a . reconcile IS TRUE
AND p . id = % s
AND l . reconcile_id IS NULL
AND ( p . last_reconciliation_date IS NULL OR l . date > p . last_reconciliation_date )
AND l . state < > ' draft '
GROUP BY l . partner_id ''' , (partner_id,))
res = cr . dictfetchone ( )
if res :
return bool ( res [ ' debit ' ] and res [ ' credit ' ] )
return False
def mark_as_reconciled ( self , cr , uid , ids , context = None ) :
return self . write ( cr , uid , ids , { ' last_reconciliation_date ' : time . strftime ( ' % Y- % m- %d % H: % M: % S ' ) } , context = context )
2008-07-22 15:11:28 +00:00
_columns = {
2014-06-29 21:31:16 +00:00
' vat_subjected ' : fields . boolean ( ' VAT Legal Statement ' , help = " Check this box if the partner is subjected to the VAT. It will be used for the VAT legal statement. " ) ,
2009-03-23 20:57:37 +00:00
' credit ' : fields . function ( _credit_debit_get ,
2011-07-01 23:41:24 +00:00
fnct_search = _credit_search , string = ' Total Receivable ' , multi = ' dc ' , help = " Total amount this customer owes you. " ) ,
' debit ' : fields . function ( _credit_debit_get , fnct_search = _debit_search , string = ' Total Payable ' , multi = ' dc ' , help = " Total amount you have to pay to this supplier. " ) ,
2008-07-22 15:11:28 +00:00
' debit_limit ' : fields . float ( ' Payable Limit ' ) ,
2014-08-01 15:29:20 +00:00
' total_invoiced ' : fields . function ( _invoice_total , string = " Total Invoiced " , type = ' float ' , groups = ' account.group_account_invoice ' ) ,
2014-04-18 09:37:56 +00:00
' contracts_count ' : fields . function ( _journal_item_count , string = " Contracts " , type = ' integer ' , multi = " invoice_journal " ) ,
' journal_item_count ' : fields . function ( _journal_item_count , string = " Journal Items " , type = " integer " , multi = " invoice_journal " ) ,
2008-07-22 15:11:28 +00:00
' property_account_payable ' : fields . property (
type = ' many2one ' ,
relation = ' account.account ' ,
string = " Account Payable " ,
domain = " [( ' type ' , ' = ' , ' payable ' )] " ,
2009-01-27 11:15:46 +00:00
help = " This account will be used instead of the default one as the payable account for the current partner " ,
2008-07-22 15:11:28 +00:00
required = True ) ,
' property_account_receivable ' : fields . property (
type = ' many2one ' ,
relation = ' account.account ' ,
string = " Account Receivable " ,
domain = " [( ' type ' , ' = ' , ' receivable ' )] " ,
2009-01-27 11:15:46 +00:00
help = " This account will be used instead of the default one as the receivable account for the current partner " ,
2008-07-22 15:11:28 +00:00
required = True ) ,
2008-10-20 20:49:11 +00:00
' property_account_position ' : fields . property (
2008-07-22 15:11:28 +00:00
type = ' many2one ' ,
2008-10-20 20:49:11 +00:00
relation = ' account.fiscal.position ' ,
2010-10-09 16:01:43 +00:00
string = " Fiscal Position " ,
2012-10-23 12:01:42 +00:00
help = " The fiscal position will determine taxes and accounts used for the partner. " ,
2008-10-20 20:49:11 +00:00
) ,
2008-07-22 15:11:28 +00:00
' property_payment_term ' : fields . property (
type = ' many2one ' ,
relation = ' account.payment.term ' ,
2012-07-11 11:14:34 +00:00
string = ' Customer Payment Term ' ,
help = " This payment term will be used instead of the default one for sale orders and customer invoices " ) ,
' property_supplier_payment_term ' : fields . property (
type = ' many2one ' ,
relation = ' account.payment.term ' ,
string = ' Supplier Payment Term ' ,
help = " This payment term will be used instead of the default one for purchase orders and supplier invoices " ) ,
2008-07-22 15:11:28 +00:00
' ref_companies ' : fields . one2many ( ' res.company ' , ' partner_id ' ,
' Companies that refers to partner ' ) ,
2014-07-06 14:44:26 +00:00
' last_reconciliation_date ' : fields . datetime (
' Latest Full Reconciliation Date ' , copy = False ,
help = ' Date on which the partner accounting entries were fully reconciled last time. '
' It differs from the last date where a reconciliation has been made for this partner, '
' as here we depict the fact that nothing more was to be reconciled at this date. '
' This can be achieved in 2 different ways: either the last unreconciled debit/credit '
' entry of this partner was reconciled, either the user pressed the button '
' " Nothing more to reconcile " during the manual reconciliation process. ' )
2008-07-22 15:11:28 +00:00
}
2010-10-15 07:14:33 +00:00
2013-04-07 23:50:13 +00:00
def _commercial_fields ( self , cr , uid , context = None ) :
return super ( res_partner , self ) . _commercial_fields ( cr , uid , context = context ) + \
[ ' debit_limit ' , ' property_account_payable ' , ' property_account_receivable ' , ' property_account_position ' ,
' property_payment_term ' , ' property_supplier_payment_term ' , ' last_reconciliation_date ' ]
2006-12-07 13:41:40 +00:00
2011-01-11 10:55:11 +00:00
# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4: