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
|
#!/usr/bin/env python
# -*- coding: utf-8 -*-
##############################################################################
#
# OpenERP, Open Source Management Solution
# Copyright (C) 2011 TeMPO Consulting, MSF. All Rights Reserved
# Developer: Olivier DOSSMANN
#
# 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 osv import osv
from osv import fields
from time import strftime
from lxml import etree
from tools.translate import _
class account_analytic_line(osv.osv):
_name = 'account.analytic.line'
_inherit = 'account.analytic.line'
def _get_output(self, cr, uid, ids, field_name, arg, context=None):
"""
Get an amount regarding currency in context (from 'output' and 'output_currency_id' values)
"""
# Prepare some value
res = {}
# Some verifications
if isinstance(ids, (int, long)):
ids = [ids]
# Return nothing if no 'output_currency_id' in context
if not context or not context.get('output_currency_id', False):
for o_id in ids:
res[o_id] = {'output_currency': False, 'output_amount': 0.0, 'output_amount_debit': 0.0, 'output_amount_credit': 0.0}
return res
# Retrieve currency
currency_id = context.get('output_currency_id')
currency_obj = self.pool.get('res.currency')
rate = currency_obj.read(cr, uid, currency_id, ['rate'], context=context).get('rate', False)
# Do calculation
if not rate:
for out_id in ids:
res[out_id] = {'output_currency': currency_id, 'output_amount': 0.0, 'output_amount_debit': 0.0, 'output_amount_credit': 0.0}
return res
for ml in self.browse(cr, uid, ids, context=context):
res[ml.id] = {'output_currency': False, 'output_amount': 0.0, 'output_amount_debit': 0.0, 'output_amount_credit': 0.0}
# output_amount field
# Update with date
context.update({'date': ml.source_date or ml.date or strftime('%Y-%m-%d')})
mnt = self.pool.get('res.currency').compute(cr, uid, ml.currency_id.id, currency_id, ml.amount_currency, round=True, context=context)
res[ml.id]['output_amount'] = mnt or 0.0
if mnt < 0.0:
res[ml.id]['output_amount_debit'] = 0.0
res[ml.id]['output_amount_credit'] = abs(mnt) or 0.0
else:
res[ml.id]['output_amount_debit'] = abs(mnt) or 0.0
res[ml.id]['output_amount_credit'] = 0.0
# or output_currency field
res[ml.id]['output_currency'] = currency_id
return res
def _get_cheque_number(self, cr, uid, ids, name, args, context=None):
res = {}
if not ids:
return res
if isinstance(ids, (int, long)):
ids = [ids]
for self_br in self.browse(cr, uid, ids, context=context):
res[self_br.id] = self_br.move_id and \
self_br.move_id.cheque_number or ''
return res
def _search_cheque_number(self, cr, uid, ids, name, args, context=None):
if not len(args):
return []
if len(args) != 1:
msg = _("Domain %s not suported") % (str(args), )
raise osv.except_osv(_('Error'), msg)
if args[0][1] != 'ilike':
# g/l selector / analytical selector default operator not found
msg = _("Operator %s not suported") % (args[0][1], )
raise osv.except_osv(_('Error'), msg)
if not args[0][2]:
return []
m_ids = self.pool.get('account.move.line').search(cr, uid,
[('cheque_number', 'ilike', args[0][2])], context=context)
return [('move_id', 'in', m_ids)] if m_ids else [('id', 'in', [])]
_columns = {
'output_amount': fields.function(_get_output, string="Output amount", type='float', method=True, store=False, multi="analytic_output_currency"),
'output_amount_debit': fields.function(_get_output, string="Output debit", type='float', method=True, store=False, multi="analytic_output_currency"),
'output_amount_credit': fields.function(_get_output, string="Output credit", type='float', method=True, store=False, multi="analytic_output_currency"),
'output_currency': fields.function(_get_output, string="Output curr.", type='many2one', relation='res.currency', method=True, store=False,
multi="analytic_output_currency"),
'cheque_number': fields.function(_get_cheque_number, type='char',
method=True, string='Cheque Number',
fnct_search=_search_cheque_number) # BKLG-7: move cheque number
}
def fields_view_get(self, cr, uid, view_id=None, view_type='form', context=None, toolbar=False, submenu=False):
"""
Remove output_amount and output_currency field if context doesn't have 'output_currency_id'
"""
# Some verifications
view = super(account_analytic_line, self).fields_view_get(cr, uid, view_id, view_type, context, toolbar, submenu)
if view_type == 'tree' and (not context or not context.get('output_currency_id', False)):
tree = etree.fromstring(view['arch'])
for element in ['output_currency', 'output_amount']:
element_fields = tree.xpath('/tree/field[@name="' + element + '"]')
for field in element_fields:
tree.remove(field)
view['arch'] = etree.tostring(tree)
if view_type == 'tree' and \
context.get('selector_display_cheque_number', False):
# BKLG-7: cheque_number used in analytic selector: display it
view['fields']['cheque_number'] = {
'function': '_get_cheque_number',
'fnct_search': '_search_cheque_number',
'type': 'char',
'string': 'Cheque Number',
}
tree = etree.fromstring(view['arch'])
cheque_number_node = etree.Element('field', attrib={
'name': 'cheque_number',
})
# insert it after entry sequence
es_node = tree.find('.//field[@name="entry_sequence"]')
tree.insert(es_node.getparent().index(es_node) + 1,
cheque_number_node)
view['arch'] = etree.tostring(tree)
return view
def copy(self, cr, uid, id, default=None, context=None):
"""
"""
if default is None:
default = {}
default.update({
'output_currency': False,
'output_amount': 0.0,
})
return super(account_analytic_line, self).copy(cr, uid, id, default, context=context)
account_analytic_line()
# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
|