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
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
|
# -*- encoding: utf-8 -*-
###############################################################################
# #
# sale_quick_payment for OpenERP #
# Copyright (C) 2011 Akretion Sébastien BEAU <sebastien.beau@akretion.com> #
# #
# This program is free software: you can redistribute it and/or modify #
# 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. #
# #
# 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 #
# GNU Affero General Public License for more details. #
# #
# You should have received a copy of the GNU Affero General Public License #
# along with this program. If not, see <http://www.gnu.org/licenses/>. #
# #
###############################################################################
from openerp.osv.orm import Model
from openerp.osv import fields
from openerp.osv.osv import except_osv
import netsvc
from collections import Iterable
from openerp.tools.translate import _
class sale_order(Model):
_inherit = "sale.order"
_columns = {
'payment_id': fields.many2one('account.voucher', 'Payment'),
'payment_method_id': fields.many2one('payment.method', 'Payment Method'),
}
def copy(self, cr, uid, id, default=None, context=None):
if not default:
default = {}
default.update({
'payment_id': False,
})
return super(sale_order, self).copy(cr, uid, id, default, context=context)
def pay_sale_order(self, cr, uid, sale_id, journal_id, amount, date, context=None):
"""
Generate a voucher for the payment
It will try to match with the invoice of the order by
matching the payment ref and the invoice origin.
The invoice does not necessarily exists at this point, so if yes,
it will be matched in the voucher, otherwise, the voucher won't
have any invoice lines and the payment lines will be reconciled
later with "auto-reconcile" if the option is used.
"""
if isinstance(sale_id, Iterable):
sale_id = sale_id[0]
voucher_obj = self.pool.get('account.voucher')
voucher_line_obj = self.pool.get('account.voucher.line')
move_line_obj = self.pool.get('account.move.line')
sale = self.browse(cr, uid, sale_id, context=context)
journal = self.pool.get('account.journal').browse(
cr, uid, journal_id, context=context)
voucher_vals = {'reference': sale.name,
'journal_id': journal_id,
'period_id': self.pool.get('account.period').find(cr, uid, dt=date,
context=context)[0],
'amount': amount,
'date': date,
'partner_id': sale.partner_id.id,
'account_id': journal.default_credit_account_id.id,
'currency_id': journal.company_id.currency_id.id,
'company_id': journal.company_id.id,
'type': 'receipt', }
# Set the payment rate if currency are different
if journal.currency.id and journal.company_id.currency_id.id != journal.currency.id:
currency_id = journal.company_id.currency_id.id
payment_rate_currency_id = journal.currency.id
currency_obj = self.pool.get('res.currency')
ctx= context.copy()
ctx.update({'date': date})
tmp = currency_obj.browse(cr, uid, payment_rate_currency_id, context=ctx).rate
payment_rate = tmp / currency_obj.browse(cr, uid, currency_id, context=ctx).rate
voucher_vals.update({
'payment_rate_currency_id': payment_rate_currency_id,
'payment_rate': payment_rate,
})
voucher_id = voucher_obj.create(cr, uid, voucher_vals, context=context)
# call on change to search the invoice lines
onchange_voucher = voucher_obj.onchange_partner_id(
cr, uid, [],
partner_id=sale.partner_id.id,
journal_id=journal.id,
amount=amount,
currency_id=journal.company_id.currency_id.id,
ttype='receipt',
date=date,
context=context)['value']
# keep in the voucher only the move line of the
# invoice (eventually) created for this order
matching_line = {}
if onchange_voucher.get('line_cr_ids'):
voucher_lines = onchange_voucher['line_cr_ids']
line_ids = [line['move_line_id'] for line in voucher_lines]
matching_ids = [line.id for line
in move_line_obj.browse(
cr, uid, line_ids, context=context)
if line.ref == sale.name]
matching_lines = [line for line
in voucher_lines
if line['move_line_id'] in matching_ids]
if matching_lines:
matching_line = matching_lines[0]
matching_line.update({
'amount': amount,
'voucher_id': voucher_id,
})
if matching_line:
voucher_line_obj.create(cr, uid, matching_line, context=context)
wf_service = netsvc.LocalService("workflow")
wf_service.trg_validate(
uid, 'account.voucher', voucher_id, 'proforma_voucher', cr)
sale.write({'payment_id': voucher_id}, context=context)
return True
def button_order_confirm(self, cr, uid, ids, context=None):
for order in self.browse(cr, uid, ids, context=context):
if order.company_id.sale_order_must_be_paid and not order.payment_id:
raise except_osv(_('User Error!'),
_('The sale Order %s Must be paid before validation') % (order.name))
return super(sale_order, self).button_order_confirm(cr, uid, ids, context=context)
|