1
# -*- encoding: utf-8 -*-
2
##############################################################################
4
# Copyright (c) 2004-2006 TINY SPRL. (http://tiny.be) All Rights Reserved.
6
# $Id: account.py 1005 2005-07-25 08:41:42Z nicoe $
8
# WARNING: This program as such is intended to be used by professional
9
# programmers who take the whole responsability of assessing all potential
10
# consequences resulting from its eventual inadequacies and bugs
11
# End users who are looking for a ready-to-use solution with commercial
12
# garantees and support are strongly adviced to contract a Free Software
15
# This program is Free Software; you can redistribute it and/or
16
# modify it under the terms of the GNU General Public License
17
# as published by the Free Software Foundation; either version 2
18
# of the License, or (at your option) any later version.
20
# This program is distributed in the hope that it will be useful,
21
# but WITHOUT ANY WARRANTY; without even the implied warranty of
22
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
23
# GNU General Public License for more details.
25
# You should have received a copy of the GNU General Public License
26
# along with this program; if not, write to the Free Software
27
# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
29
##############################################################################
33
from osv import fields, osv
36
class account_invoice(osv.osv):
37
def _amount_untaxed(self, cr, uid, ids, prop, unknow_none,unknow_dict):
39
for inv in self.read(cr, uid, ids, ['price_type']):
40
if inv['price_type']=='tax_included':
42
id_set=",".join(map(str,ids))
43
cr.execute("SELECT s.id,COALESCE(SUM(l.price_unit*l.quantity*(100.0-l.discount))/100.0,0)::decimal(16,2) AS amount FROM account_invoice s LEFT OUTER JOIN account_invoice_line l ON (s.id=l.invoice_id) WHERE s.id IN ("+id_set+") GROUP BY s.id ")
44
res=dict(cr.fetchall())
46
tax = self._amount_tax(cr, uid, ti, prop, unknow_none,unknow_dict)
48
res[id] = res[id] - tax.get(id,0.0)
51
def _amount_total(self, cr, uid, ids, prop, unknow_none,unknow_dict):
53
for inv in self.read(cr, uid, ids, ['price_type']):
54
if inv['price_type']=='tax_excluded':
56
id_set=",".join(map(str,ids))
57
cr.execute("SELECT s.id,COALESCE(SUM(l.price_unit*l.quantity*(100.0-l.discount))/100.0,0)::decimal(16,2) AS amount FROM account_invoice s LEFT OUTER JOIN account_invoice_line l ON (s.id=l.invoice_id) WHERE s.id IN ("+id_set+") GROUP BY s.id ")
58
res=dict(cr.fetchall())
60
tax = self._amount_tax(cr, uid, ti, prop, unknow_none,unknow_dict)
62
res[id] = res[id] + tax.get(id,0.0)
65
_inherit = "account.invoice"
67
'price_type': fields.selection([
68
('tax_included','Tax included'),
69
('tax_excluded','Tax excluded')
70
], 'Price method', required=True),
71
'amount_untaxed': fields.function(_amount_untaxed, method=True, string='Untaxed Amount'),
72
'amount_total': fields.function(_amount_total, method=True, string='Total'),
75
'price_type': lambda *a: 'tax_excluded',
79
class account_invoice_line(osv.osv):
80
_inherit = "account.invoice.line"
83
# Compute with VAT invluded in the price
85
def move_line_get(self, cr, uid, invoice_id, context={}):
86
inv = self.pool.get('account.invoice').browse(cr, uid, invoice_id)
87
if inv.price_type=='tax_excluded':
88
return super(account_invoice_line,self).move_line_get(cr, uid, invoice_id)
92
tax_obj = self.pool.get('account.tax')
93
for line in inv.invoice_line:
97
'price_unit':line.price_unit,
98
'quantity':line.quantity,
99
'price':round(line.quantity*line.price_unit * (1.0- (line.discount or 0.0)/100.0),2),
100
'account_id':line.account_id.id,
103
for tax2 in line.invoice_line_tax_id:
104
for tax in tax_obj.compute_inv(cr, uid, [tax2.id], line.price_unit, line.quantity, inv.address_invoice_id.id):
105
tax['amount'] = round(tax['amount']*(1.0- (line['discount'] or 0.0)/100.0),2)
106
tax['sequence'] = tax2.sequence
108
res[-1]['tax_amount'] += (line['price_unit'] * line['quantity'] * (1.0- (line['discount'] or 0.0)/100.0) * tax2.base_sign)
110
# Setting the tax account and amount for the line
112
if inv.type in ('out_invoice','in_refund'):
113
res[-1]['tax_code_id'] = tax2.base_code_id.id
115
res[-1]['tax_code_id'] = tax2.ref_base_code_id.id
117
if inv.type in ('out_invoice','in_refund'):
118
tax['account_id'] = tax['account_collected_id'] or line.account_id.id
120
tax['account_id'] = tax['account_paid_id'] or line.account_id.id
122
# Revoir la cl�: tax.id ?
124
key = (tax['id'], tax['account_id'])
126
res[-1]['price'] -= tax['amount']
127
res[-1]['tax_amount'] -= (tax['amount']* tax2.base_sign)
128
if not key in tax_grouped:
129
tax_grouped[key] = tax
130
tax_grouped[key]['base'] = res[-1]['price']
132
tax_grouped[key]['amount'] += tax['amount']
133
tax_grouped[key]['base'] += res[-1]['price']
134
# delete automatic tax lines for this invoice
135
cr.execute("DELETE FROM account_invoice_tax WHERE NOT manual AND invoice_id=%d", (invoice_id,))
136
self.move_line_tax_create(cr, uid, inv, tax_grouped, context)
138
account_invoice_line()