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
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
|
# -*- coding: utf-8 -*-
##############################################################################
#
# Copyright (C) 2004-2011
# Pexego Sistemas Informáticos. (http://pexego.es) All Rights Reserved
#
# 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/>.
#
##############################################################################
__author__ = "Luis Manuel Angueira Blanco (Pexego), Omar Castiñeira Saavedra (omar@pexego.es)"
from tools.translate import _
from osv import osv, fields
OPERATION_KEY = [
('Nothing', ''),
('E', 'E - Intra-Community supplies'),
('A', 'A - Intra-Community acquisition'),
('T', 'T - Triangular operations'),
('S', 'S - Intra-Community services'),
('I', 'I - Intra-Community services acquisitions'),
('M', 'M - Intra-Community supplies without taxes'),
('H', 'H - Intra-Community supplies without taxes delivered by legal representative')
]
MONTH_DATES_MAPPING = {
'01' : {'date_start' : '%s-01-01', 'date_stop' : '%s-01-31'},
'02' : {'date_start' : '%s-02-01', 'date_stop' : '%s-02-28'},
'03' : {'date_start' : '%s-03-01', 'date_stop' : '%s-03-31'},
'04' : {'date_start' : '%s-04-01', 'date_stop' : '%s-04-30'},
'05' : {'date_start' : '%s-05-01', 'date_stop' : '%s-05-31'},
'06' : {'date_start' : '%s-06-01', 'date_stop' : '%s-06-30'},
'07' : {'date_start' : '%s-07-01', 'date_stop' : '%s-07-31'},
'08' : {'date_start' : '%s-08-01', 'date_stop' : '%s-08-31'},
'09' : {'date_start' : '%s-09-01', 'date_stop' : '%s-09-30'},
'10' : {'date_start' : '%s-10-01', 'date_stop' : '%s-10-31'},
'11' : {'date_start' : '%s-11-01', 'date_stop' : '%s-11-30'},
'12' : {'date_start' : '%s-12-01', 'date_stop' : '%s-12-31'},
}
class account_invoice(osv.osv):
"""
Inheritance of account invoce to add some fields
- operation_key: Operation key of invoice
"""
_inherit = 'account.invoice'
#################
### FUNCTIONS ###
#################
def _get_invoices_by_type(self, cr, uid, partner_id, operation_key,
fiscalyear_id=None, period_id=None, month=None, period_selection=None):
"""
Returns invoices ids by type (supplier/customer) for a fiscalyear/period/month
"""
assert period_selection, 'There is no period selected'
## Set type of invoice
type = ['in_invoice', 'out_invoice', 'in_refund', 'out_refund']
fiscalyear_obj = self.pool.get('account.fiscalyear').browse(cr, uid, fiscalyear_id)
search_dict = [
('partner_id', '=', partner_id),
('state', 'in', ['open', 'paid']),
('type', 'in', type),
('operation_key', '=', operation_key)]
##
## Invoices by fiscalyear (Annual)
if period_selection == '0A':
if not fiscalyear_id:
raise osv.except_osv(_('Error'), _('Cannot get invoices.\nThere is no fiscalyear selected'))
search_dict.append(('period_id', 'in', [period.id for period in fiscalyear_obj.period_ids if not period.special]))
##
## Invoices by period
elif period_selection in ['1T', '2T', '3T', '4T']:
if not period_id:
raise osv.except_osv(_('Error'), _('Cannot get invoices.\nThere is no period selected'))
search_dict.append(('period_id', 'in', period_id))
##
## Invoices by month
else:
year = fiscalyear_obj.code[:4]
if not month and not fiscalyear_id:
raise osv.except_osv(_('Error'), _('Cannot get invoices.\nThere is no month and/or fiscalyear selected'))
search_dict.append(('date_invoice', '>=', MONTH_DATES_MAPPING[month]['date_start'] % year))
if month == '02':
#checks if year is leap to can search by last February date in database
if int(year) % 4 == 0 and (int(year) % 100 != 0 or int(year) % 400 == 0):
search_dict.append(('date_invoice', '<=', "%s-02-29" % year))
else:
search_dict.append(('date_invoice', '<=', MONTH_DATES_MAPPING[month]['date_stop'] % year))
else:
search_dict.append(('date_invoice', '<=', MONTH_DATES_MAPPING[month]['date_stop'] % year))
return self.search(cr, uid, search_dict)
def clean_refund_invoices(self, cr, uid, ids, partner_id, fiscalyear_id=None, period_id=None, month=None, period_selection=None):
"""separates restitution invoices"""
invoice_lines = []
restitution_lines = []
fiscalyear_obj = self.pool.get('account.fiscalyear').browse(cr, uid, fiscalyear_id)
for refund in self.browse(cr, uid, ids):
if refund.type in ['in_refund', 'out_refund']:
if not refund.origin_invoices_ids:
invoice_lines.append(refund.id)
continue
for origin_line in refund.origin_invoices_ids:
if origin_line.state in ['open', 'paid'] and origin_line.partner_id.id == partner_id:
if period_selection == '0A':
if origin_line.period_id.id not in [period.id for period in fiscalyear_obj.period_ids if not period.special]:
restitution_lines.append(refund.id)
break
else:
invoice_lines.append(refund.id)
break
elif period_selection in ['1T', '2T', '3T', '4T']:
if origin_line.period_id.id != period_id:
restitution_lines.append(refund.id)
break
else:
invoice_lines.append(refund.id)
break
else:
if origin_line.date_invoice < MONTH_DATES_MAPPING[month]['date_start'] % fiscalyear_obj.code[:4]:
restitution_lines.append(refund.id)
break
else:
invoice_lines.append(refund.id)
break
else:
invoice_lines.append(refund.id)
return invoice_lines, restitution_lines
def on_change_fiscal_position(self, cr, uid, ids, fiscal_position, type, context=None):
"""
Suggest an operation key when fiscal position changes
"""
if context is None:
context = {}
res = {'value' : {'operation_key' : 'Nothing'}}
if fiscal_position and type:
if self.pool.get('account.fiscal.position').browse(cr, uid, fiscal_position).intracommunity_operations:
if type == 'out_invoice':
res = {'value' : {'operation_key' : 'E'}} ## Set to supplies when type is 'out_invoice' (Customer invoice)
else:
res = {'value' : {'operation_key' : 'A'}} ## Set to acquisition when type is 'in_invoice' (Supplier invoice)
return res
def onchange_partner_id(self, cr, uid, ids, type, partner_id,
date_invoice=False, payment_term=False, partner_bank_id=False, company_id=False):
"""
Inheritance to extend method and return operation key
"""
##
## Get original data from onchange method
res = super(account_invoice, self).onchange_partner_id(cr, uid, ids, type, partner_id,
date_invoice=date_invoice, payment_term=payment_term, partner_bank_id=partner_bank_id, company_id=company_id)
##
## Get operation key for current record
operation_key_dict = self.on_change_fiscal_position(cr, uid, ids,
fiscal_position=res['value']['fiscal_position'], type=type)
##
## Add operation key to result
if operation_key_dict['value'] and \
operation_key_dict['value']['operation_key']:
res['value']['operation_key'] = operation_key_dict['value']['operation_key']
else:
res['value']['operation_key'] = False
return res
def create(self, cr, uid, vals, context=None):
"""Writes operation key value, if invoice is created in backgroud with intracommunity fiscal position defined"""
if context is None:
context = {}
if vals.get('fiscal_position') and vals.get('type') and not vals.get('operation_key'):
if self.pool.get('account.fiscal.position').browse(cr, uid, vals.get('fiscal_position')).intracommunity_operations:
if vals.get('type') == 'out_invoice':
vals['operation_key'] = 'E'
else:
vals['operation_key'] = 'A'
return super(account_invoice, self).create(cr, uid, vals, context)
_columns = {
'operation_key' : fields.selection(OPERATION_KEY, 'Operation key')
}
account_invoice()
|