1 # -*- coding: utf-8 -*-
2 ##############################################################################
4 # OpenERP, Open Source Management Solution
5 # Copyright (C) 2004-2010 Tiny SPRL (<http://tiny.be>).
7 # This program is free software: you can redistribute it and/or modify
8 # it under the terms of the GNU Affero General Public License as
9 # published by the Free Software Foundation, either version 3 of the
10 # License, or (at your option) any later version.
12 # This program is distributed in the hope that it will be useful,
13 # but WITHOUT ANY WARRANTY; without even the implied warranty of
14 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15 # GNU Affero General Public License for more details.
17 # You should have received a copy of the GNU Affero General Public License
18 # along with this program. If not, see <http://www.gnu.org/licenses/>.
20 ##############################################################################
22 from datetime import datetime
23 from openerp.tools.translate import _
24 from openerp.osv import fields, osv
26 class Invoice(osv.osv):
27 _inherit = 'account.invoice'
29 # Forbid to cancel an invoice if the related move lines have already been
30 # used in a payment order. The risk is that importing the payment line
31 # in the bank statement will result in a crash cause no more move will
32 # be found in the payment line
33 def action_cancel(self, cr, uid, ids, context=None):
34 payment_line_obj = self.pool.get('payment.line')
35 for inv in self.browse(cr, uid, ids, context=context):
37 if inv.move_id and inv.move_id.line_id:
38 inv_mv_lines = [x.id for x in inv.move_id.line_id]
39 pl_line_ids = payment_line_obj.search(cr, uid, [('move_line_id','in',inv_mv_lines)], context=context)
41 pay_line = payment_line_obj.browse(cr, uid, pl_line_ids, context=context)
42 payment_order_name = ','.join(map(lambda x: x.order_id.reference, pay_line))
43 raise osv.except_osv(_('Error!'), _("You cannot cancel an invoice which has already been imported in a payment order. Remove it from the following payment order : %s."%(payment_order_name)))
44 return super(Invoice, self).action_cancel(cr, uid, ids, context=context)
46 def _amount_to_pay(self, cursor, user, ids, name, args, context=None):
47 '''Return the amount still to pay regarding all the payment orders'''
51 for invoice in self.browse(cursor, user, ids, context=context):
54 for line in invoice.move_id.line_id:
55 if not line.date_maturity or \
56 datetime.strptime(line.date_maturity, '%Y-%m-%d') \
58 res[invoice.id] += line.amount_to_pay
62 'amount_to_pay': fields.function(_amount_to_pay,
63 type='float', string='Amount to be paid',
64 help='The amount which should be paid at the current date\n' \
65 'minus the amount which is already in payment order'),
70 # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4: