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 ##############################################################################
24 from osv import fields, osv
25 from tools.translate import _
26 import decimal_precision as dp
28 class account_analytic_account(osv.osv):
29 _name = 'account.analytic.account'
30 _inherit = ['mail.thread']
31 _description = 'Analytic Account'
33 def _compute_level_tree(self, cr, uid, ids, child_ids, res, field_names, context=None):
34 currency_obj = self.pool.get('res.currency')
36 def recursive_computation(account):
37 result2 = res[account.id].copy()
38 for son in account.child_ids:
39 result = recursive_computation(son)
40 for field in field_names:
41 if (account.currency_id.id != son.currency_id.id) and (field!='quantity'):
42 result[field] = currency_obj.compute(cr, uid, son.currency_id.id, account.currency_id.id, result[field], context=context)
43 result2[field] += result[field]
45 for account in self.browse(cr, uid, ids, context=context):
46 if account.id not in child_ids:
48 recres[account.id] = recursive_computation(account)
51 def _debit_credit_bal_qtty(self, cr, uid, ids, fields, arg, context=None):
55 child_ids = tuple(self.search(cr, uid, [('parent_id', 'child_of', ids)]))
65 where_clause_args = [tuple(child_ids)]
66 if context.get('from_date', False):
67 where_date += " AND l.date >= %s"
68 where_clause_args += [context['from_date']]
69 if context.get('to_date', False):
70 where_date += " AND l.date <= %s"
71 where_clause_args += [context['to_date']]
75 CASE WHEN l.amount > 0
81 CASE WHEN l.amount < 0
86 COALESCE(SUM(l.amount),0) AS balance,
87 COALESCE(SUM(l.unit_amount),0) AS quantity
88 FROM account_analytic_account a
89 LEFT JOIN account_analytic_line l ON (a.id = l.account_id)
91 """ + where_date + """
92 GROUP BY a.id""", where_clause_args)
93 for row in cr.dictfetchall():
96 res[row['id']][field] = row[field]
97 return self._compute_level_tree(cr, uid, ids, child_ids, res, fields, context)
99 def name_get(self, cr, uid, ids, context=None):
100 if isinstance(ids, (int, long)):
105 for account in self.browse(cr, uid, ids, context=context):
109 data.insert(0, acc.name)
111 data = ' / '.join(data)
112 res.append((account.id, data))
115 def _complete_name_calc(self, cr, uid, ids, prop, unknow_none, unknow_dict):
116 res = self.name_get(cr, uid, ids)
119 def _child_compute(self, cr, uid, ids, name, arg, context=None):
124 for account in self.browse(cr, uid, ids, context=context):
125 result[account.id] = map(lambda x: x.id, [child for child in account.child_ids if child.state != 'template'])
129 def _get_analytic_account(self, cr, uid, ids, context=None):
130 company_obj = self.pool.get('res.company')
131 analytic_obj = self.pool.get('account.analytic.account')
133 for company in company_obj.browse(cr, uid, ids, context=context):
134 accounts += analytic_obj.search(cr, uid, [('company_id', '=', company.id)])
137 def _set_company_currency(self, cr, uid, ids, name, value, arg, context=None):
138 if isinstance(ids, (int, long)):
140 for account in self.browse(cr, uid, ids, context=context):
141 if account.company_id:
142 if account.company_id.currency_id.id != value:
143 raise osv.except_osv(_('Error !'), _("If you set a company, the currency selected has to be the same as it's currency. \nYou can remove the company belonging, and thus change the currency, only on analytic account of type 'view'. This can be really usefull for consolidation purposes of several companies charts with different currencies, for example."))
144 return cr.execute("""update account_analytic_account set currency_id=%s where id=%s""", (value, account.id, ))
146 def _currency(self, cr, uid, ids, field_name, arg, context=None):
148 for rec in self.browse(cr, uid, ids, context=context):
150 result[rec.id] = rec.company_id.currency_id.id
152 result[rec.id] = rec.currency_id.id
156 'name': fields.char('Account Name', size=128, required=True),
157 'complete_name': fields.function(_complete_name_calc, type='char', string='Full Account Name'),
158 'code': fields.char('Code/Reference', size=24, select=True),
159 'type': fields.selection([('view','Analytic View'), ('normal','Analytic Account'),('contract','Contract or Project'),('template','Template of Project')], 'Type of Account', required=True,
160 help="If you select the View Type, it means you won\'t allow to create journal entries using that account.\n"\
161 "The type 'Analytic account' stands for usual accounts that you only want to use in accounting.\n"\
162 "If you select Contract or Project, it offers you the possibility to manage the validity and the invoicing options for this account.\n"\
163 "The special type 'Template of Project' allows you to define a template with default data that you can reuse easily."),
164 'description': fields.text('Description'),
165 'parent_id': fields.many2one('account.analytic.account', 'Parent Analytic Account', select=2),
166 'child_ids': fields.one2many('account.analytic.account', 'parent_id', 'Child Accounts'),
167 'child_complete_ids': fields.function(_child_compute, relation='account.analytic.account', string="Account Hierarchy", type='many2many'),
168 'line_ids': fields.one2many('account.analytic.line', 'account_id', 'Analytic Entries'),
169 'balance': fields.function(_debit_credit_bal_qtty, type='float', string='Balance', multi='debit_credit_bal_qtty', digits_compute=dp.get_precision('Account')),
170 'debit': fields.function(_debit_credit_bal_qtty, type='float', string='Debit', multi='debit_credit_bal_qtty', digits_compute=dp.get_precision('Account')),
171 'credit': fields.function(_debit_credit_bal_qtty, type='float', string='Credit', multi='debit_credit_bal_qtty', digits_compute=dp.get_precision('Account')),
172 'quantity': fields.function(_debit_credit_bal_qtty, type='float', string='Quantity', multi='debit_credit_bal_qtty'),
173 'quantity_max': fields.float('Maximum Time', help='Sets the higher limit of time to work on the contract.'),
174 'partner_id': fields.many2one('res.partner', 'Customer'),
175 'user_id': fields.many2one('res.users', 'Project Manager'),
176 'manager_id': fields.many2one('res.users', 'Account Manager'),
177 'date_start': fields.date('Date Start'),
178 'date': fields.date('Date End', select=True),
179 'company_id': fields.many2one('res.company', 'Company', required=False), #not required because we want to allow different companies to use the same chart of account, except for leaf accounts.
180 'state': fields.selection([('template', 'Template'),('draft','New'),('open','In Progress'), ('cancelled', 'Cancelled'),('pending','To Renew'),('close','Closed')], 'Status', required=True,),
181 'currency_id': fields.function(_currency, fnct_inv=_set_company_currency,
183 'res.company': (_get_analytic_account, ['currency_id'], 10),
184 }, string='Currency', type='many2one', relation='res.currency'),
187 def on_change_partner_id(self, cr, uid, ids,partner_id, name, context={}):
190 partner = self.pool.get('res.partner').browse(cr, uid, partner_id, context=context)
192 res['manager_id'] = partner.user_id.id
194 res['name'] = _('Contract: ') + partner.name
195 return {'value': res}
197 def _default_company(self, cr, uid, context=None):
198 user = self.pool.get('res.users').browse(cr, uid, uid, context=context)
200 return user.company_id.id
201 return self.pool.get('res.company').search(cr, uid, [('parent_id', '=', False)])[0]
203 def _get_default_currency(self, cr, uid, context=None):
204 user = self.pool.get('res.users').browse(cr, uid, uid, context=context)
205 return user.company_id.currency_id.id
209 'company_id': _default_company,
210 'code' : lambda obj, cr, uid, context: obj.pool.get('ir.sequence').get(cr, uid, 'account.analytic.account'),
212 'user_id': lambda self, cr, uid, ctx: uid,
213 'partner_id': lambda self, cr, uid, ctx: ctx.get('partner_id', False),
214 'date_start': lambda *a: time.strftime('%Y-%m-%d'),
215 'currency_id': _get_default_currency,
218 def check_recursion(self, cr, uid, ids, context=None, parent=None):
219 return super(account_analytic_account, self)._check_recursion(cr, uid, ids, context=context, parent=parent)
223 (check_recursion, 'Error! You can not create recursive analytic accounts.', ['parent_id']),
226 def copy(self, cr, uid, id, default=None, context=None):
229 default['code'] = False
230 default['line_ids'] = []
231 return super(account_analytic_account, self).copy(cr, uid, id, default, context=context)
233 def on_change_company(self, cr, uid, id, company_id):
236 currency = self.pool.get('res.company').read(cr, uid, [company_id], ['currency_id'])[0]['currency_id']
237 return {'value': {'currency_id': currency}}
239 def on_change_parent(self, cr, uid, id, parent_id):
242 parent = self.read(cr, uid, [parent_id], ['partner_id','code'])[0]
243 if parent['partner_id']:
244 partner = parent['partner_id'][0]
249 res['value']['partner_id'] = partner
252 def name_search(self, cr, uid, name, args=None, operator='ilike', context=None, limit=100):
257 if context.get('current_model') == 'project.project':
258 cr.execute("select analytic_account_id from project_project")
259 project_ids = [x[0] for x in cr.fetchall()]
260 return self.name_get(cr, uid, project_ids, context=context)
262 account = self.search(cr, uid, [('code', '=', name)] + args, limit=limit, context=context)
264 names=map(lambda i : i.strip(),name.split('/'))
265 for i in range(len(names)):
266 dom=[('name', operator, names[i])]
268 dom+=[('id','child_of',account)]
269 account = self.search(cr, uid, dom, limit=limit, context=context)
272 newacc = self.search(cr, uid, [('parent_id', 'in', newacc)], limit=limit, context=context)
275 account = self.search(cr, uid, [('id', 'in', account)] + args, limit=limit, context=context)
277 account = self.search(cr, uid, args, limit=limit, context=context)
278 return self.name_get(cr, uid, account, context=context)
280 def create(self, cr, uid, vals, context=None):
281 contract = super(account_analytic_account, self).create(cr, uid, vals, context=context)
283 self.create_send_note(cr, uid, [contract], context=context)
286 def create_send_note(self, cr, uid, ids, context=None):
287 for obj in self.browse(cr, uid, ids, context=context):
288 self.message_subscribe(cr, uid, [obj.id], [obj.user_id.id], context=context)
289 self.message_append_note(cr, uid, [obj.id], body=_("Contract for <em>%s</em> has been <b>created</b>.") % (obj.partner_id.name), context=context)
291 account_analytic_account()
294 class account_analytic_line(osv.osv):
295 _name = 'account.analytic.line'
296 _description = 'Analytic Line'
299 'name': fields.char('Description', size=256, required=True),
300 'date': fields.date('Date', required=True, select=True),
301 'amount': fields.float('Amount', required=True, help='Calculated by multiplying the quantity and the price given in the Product\'s cost price. Always expressed in the company main currency.', digits_compute=dp.get_precision('Account')),
302 'unit_amount': fields.float('Quantity', help='Specifies the amount of quantity to count.'),
303 'account_id': fields.many2one('account.analytic.account', 'Analytic Account', required=True, ondelete='cascade', select=True, domain=[('type','<>','view')]),
304 'user_id': fields.many2one('res.users', 'User'),
305 'company_id': fields.related('account_id', 'company_id', type='many2one', relation='res.company', string='Company', store=True, readonly=True),
309 'date': lambda *a: time.strftime('%Y-%m-%d'),
310 'company_id': lambda self,cr,uid,c: self.pool.get('res.company')._company_default_get(cr, uid, 'account.analytic.line', context=c),
316 def _check_no_view(self, cr, uid, ids, context=None):
317 analytic_lines = self.browse(cr, uid, ids, context=context)
318 for line in analytic_lines:
319 if line.account_id.type == 'view':
324 (_check_no_view, 'You can not create analytic line on view account.', ['account_id']),
327 account_analytic_line()
329 # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4: