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 ##############################################################################
23 from datetime import datetime
25 from openerp.osv import fields, osv
26 from openerp import tools
27 from openerp.tools.translate import _
28 import openerp.addons.decimal_precision as dp
30 class account_analytic_account(osv.osv):
31 _name = 'account.analytic.account'
32 _inherit = ['mail.thread']
33 _description = 'Analytic Account'
36 'analytic.mt_account_pending': lambda self, cr, uid, obj, ctx=None: obj.state == 'pending',
37 'analytic.mt_account_closed': lambda self, cr, uid, obj, ctx=None: obj.state == 'close',
38 'analytic.mt_account_opened': lambda self, cr, uid, obj, ctx=None: obj.state == 'open',
42 def _compute_level_tree(self, cr, uid, ids, child_ids, res, field_names, context=None):
43 currency_obj = self.pool.get('res.currency')
45 def recursive_computation(account):
46 result2 = res[account.id].copy()
47 for son in account.child_ids:
48 result = recursive_computation(son)
49 for field in field_names:
50 if (account.currency_id.id != son.currency_id.id) and (field!='quantity'):
51 result[field] = currency_obj.compute(cr, uid, son.currency_id.id, account.currency_id.id, result[field], context=context)
52 result2[field] += result[field]
54 for account in self.browse(cr, uid, ids, context=context):
55 if account.id not in child_ids:
57 recres[account.id] = recursive_computation(account)
60 def _debit_credit_bal_qtty(self, cr, uid, ids, fields, arg, context=None):
64 child_ids = tuple(self.search(cr, uid, [('parent_id', 'child_of', ids)]))
74 where_clause_args = [tuple(child_ids)]
75 if context.get('from_date', False):
76 where_date += " AND l.date >= %s"
77 where_clause_args += [context['from_date']]
78 if context.get('to_date', False):
79 where_date += " AND l.date <= %s"
80 where_clause_args += [context['to_date']]
84 CASE WHEN l.amount > 0
90 CASE WHEN l.amount < 0
95 COALESCE(SUM(l.amount),0) AS balance,
96 COALESCE(SUM(l.unit_amount),0) AS quantity
97 FROM account_analytic_account a
98 LEFT JOIN account_analytic_line l ON (a.id = l.account_id)
100 """ + where_date + """
101 GROUP BY a.id""", where_clause_args)
102 for row in cr.dictfetchall():
105 res[row['id']][field] = row[field]
106 return self._compute_level_tree(cr, uid, ids, child_ids, res, fields, context)
108 def name_get(self, cr, uid, ids, context=None):
112 if isinstance(ids, (int, long)):
115 elmt = self.browse(cr, uid, id, context=context)
116 res.append((id, self._get_one_full_name(elmt)))
119 def _get_full_name(self, cr, uid, ids, name=None, args=None, context=None):
123 for elmt in self.browse(cr, uid, ids, context=context):
124 res[elmt.id] = self._get_one_full_name(elmt)
127 def _get_one_full_name(self, elmt, level=6):
130 if elmt.parent_id and not elmt.type == 'template':
131 parent_path = self._get_one_full_name(elmt.parent_id, level-1) + " / "
134 return parent_path + elmt.name
136 def _child_compute(self, cr, uid, ids, name, arg, context=None):
141 for account in self.browse(cr, uid, ids, context=context):
142 result[account.id] = map(lambda x: x.id, [child for child in account.child_ids if child.state != 'template'])
146 def _get_analytic_account(self, cr, uid, ids, context=None):
147 company_obj = self.pool.get('res.company')
148 analytic_obj = self.pool.get('account.analytic.account')
150 for company in company_obj.browse(cr, uid, ids, context=context):
151 accounts += analytic_obj.search(cr, uid, [('company_id', '=', company.id)])
154 def _set_company_currency(self, cr, uid, ids, name, value, arg, context=None):
155 if isinstance(ids, (int, long)):
157 for account in self.browse(cr, uid, ids, context=context):
158 if account.company_id:
159 if account.company_id.currency_id.id != value:
160 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 useful for consolidation purposes of several companies charts with different currencies, for example."))
162 cr.execute("""update account_analytic_account set currency_id=%s where id=%s""", (value, account.id))
163 self.invalidate_cache(cr, uid, ['currency_id'], [account.id], context=context)
165 def _currency(self, cr, uid, ids, field_name, arg, context=None):
167 for rec in self.browse(cr, uid, ids, context=context):
169 result[rec.id] = rec.company_id.currency_id.id
171 result[rec.id] = rec.currency_id.id
175 'name': fields.char('Account/Contract Name', required=True, track_visibility='onchange'),
176 'complete_name': fields.function(_get_full_name, type='char', string='Full Name'),
177 'code': fields.char('Reference', select=True, track_visibility='onchange', copy=False),
178 'type': fields.selection([('view','Analytic View'), ('normal','Analytic Account'),('contract','Contract or Project'),('template','Template of Contract')], 'Type of Account', required=True,
179 help="If you select the View Type, it means you won\'t allow to create journal entries using that account.\n"\
180 "The type 'Analytic account' stands for usual accounts that you only want to use in accounting.\n"\
181 "If you select Contract or Project, it offers you the possibility to manage the validity and the invoicing options for this account.\n"\
182 "The special type 'Template of Contract' allows you to define a template with default data that you can reuse easily."),
183 'template_id': fields.many2one('account.analytic.account', 'Template of Contract'),
184 'description': fields.text('Description'),
185 'parent_id': fields.many2one('account.analytic.account', 'Parent Analytic Account', select=2),
186 'child_ids': fields.one2many('account.analytic.account', 'parent_id', 'Child Accounts'),
187 'child_complete_ids': fields.function(_child_compute, relation='account.analytic.account', string="Account Hierarchy", type='many2many'),
188 'line_ids': fields.one2many('account.analytic.line', 'account_id', 'Analytic Entries'),
189 'balance': fields.function(_debit_credit_bal_qtty, type='float', string='Balance', multi='debit_credit_bal_qtty', digits_compute=dp.get_precision('Account')),
190 'debit': fields.function(_debit_credit_bal_qtty, type='float', string='Debit', multi='debit_credit_bal_qtty', digits_compute=dp.get_precision('Account')),
191 'credit': fields.function(_debit_credit_bal_qtty, type='float', string='Credit', multi='debit_credit_bal_qtty', digits_compute=dp.get_precision('Account')),
192 'quantity': fields.function(_debit_credit_bal_qtty, type='float', string='Quantity', multi='debit_credit_bal_qtty'),
193 'quantity_max': fields.float('Prepaid Service Units', help='Sets the higher limit of time to work on the contract, based on the timesheet. (for instance, number of hours in a limited support contract.)'),
194 'partner_id': fields.many2one('res.partner', 'Customer'),
195 'user_id': fields.many2one('res.users', 'Project Manager', track_visibility='onchange'),
196 'manager_id': fields.many2one('res.users', 'Account Manager', track_visibility='onchange'),
197 'date_start': fields.date('Start Date'),
198 'date': fields.date('Expiration Date', select=True, track_visibility='onchange'),
199 '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.
200 'state': fields.selection([('template', 'Template'),
202 ('open','In Progress'),
203 ('pending','To Renew'),
205 ('cancelled', 'Cancelled')],
206 'Status', required=True,
207 track_visibility='onchange', copy=False),
208 'currency_id': fields.function(_currency, fnct_inv=_set_company_currency, #the currency_id field is readonly except if it's a view account and if there is no company
210 'res.company': (_get_analytic_account, ['currency_id'], 10),
211 }, string='Currency', type='many2one', relation='res.currency'),
214 def on_change_template(self, cr, uid, ids, template_id, date_start=False, context=None):
218 template = self.browse(cr, uid, template_id, context=context)
219 if template.date_start and template.date:
220 from_dt = datetime.strptime(template.date_start, tools.DEFAULT_SERVER_DATE_FORMAT)
221 to_dt = datetime.strptime(template.date, tools.DEFAULT_SERVER_DATE_FORMAT)
222 timedelta = to_dt - from_dt
223 res['value']['date'] = datetime.strftime(datetime.now() + timedelta, tools.DEFAULT_SERVER_DATE_FORMAT)
225 res['value']['date_start'] = fields.date.today()
226 res['value']['quantity_max'] = template.quantity_max
227 res['value']['parent_id'] = template.parent_id and template.parent_id.id or False
228 res['value']['description'] = template.description
231 def on_change_partner_id(self, cr, uid, ids,partner_id, name, context=None):
234 partner = self.pool.get('res.partner').browse(cr, uid, partner_id, context=context)
236 res['manager_id'] = partner.user_id.id
238 res['name'] = _('Contract: ') + partner.name
239 return {'value': res}
241 def _default_company(self, cr, uid, context=None):
242 user = self.pool.get('res.users').browse(cr, uid, uid, context=context)
244 return user.company_id.id
245 return self.pool.get('res.company').search(cr, uid, [('parent_id', '=', False)])[0]
247 def _get_default_currency(self, cr, uid, context=None):
248 user = self.pool.get('res.users').browse(cr, uid, uid, context=context)
249 return user.company_id.currency_id.id
253 'company_id': _default_company,
254 'code' : lambda obj, cr, uid, context: obj.pool.get('ir.sequence').get(cr, uid, 'account.analytic.account'),
256 'user_id': lambda self, cr, uid, ctx: uid,
257 'partner_id': lambda self, cr, uid, ctx: ctx.get('partner_id', False),
258 'manager_id': lambda self, cr, uid, ctx: ctx.get('manager_id', False),
259 'date_start': lambda *a: time.strftime('%Y-%m-%d'),
260 'currency_id': _get_default_currency,
263 def check_recursion(self, cr, uid, ids, context=None, parent=None):
264 return super(account_analytic_account, self)._check_recursion(cr, uid, ids, context=context, parent=parent)
266 _order = 'code, name asc'
268 (check_recursion, 'Error! You cannot create recursive analytic accounts.', ['parent_id']),
271 def name_create(self, cr, uid, name, context=None):
272 raise osv.except_osv(_('Warning'), _("Quick account creation disallowed."))
274 def copy(self, cr, uid, id, default=None, context=None):
277 analytic = self.browse(cr, uid, id, context=context)
278 default['name'] = _("%s (copy)") % analytic['name']
279 return super(account_analytic_account, self).copy(cr, uid, id, default, context=context)
281 def on_change_company(self, cr, uid, id, company_id):
284 currency = self.pool.get('res.company').read(cr, uid, [company_id], ['currency_id'])[0]['currency_id']
285 return {'value': {'currency_id': currency}}
287 def on_change_parent(self, cr, uid, id, parent_id):
290 parent = self.read(cr, uid, [parent_id], ['partner_id','code'])[0]
291 if parent['partner_id']:
292 partner = parent['partner_id'][0]
297 res['value']['partner_id'] = partner
300 def name_search(self, cr, uid, name, args=None, operator='ilike', context=None, limit=100):
306 account_ids = self.search(cr, uid, [('code', '=', name)] + args, limit=limit, context=context)
309 for name2 in name.split('/'):
311 account_ids = self.search(cr, uid, dom + [('name', operator, name)] + args, limit=limit, context=context)
312 if not account_ids: break
313 dom = [('parent_id','in',account_ids)]
315 account_ids = self.search(cr, uid, args, limit=limit, context=context)
316 return self.name_get(cr, uid, account_ids, context=context)
318 class account_analytic_line(osv.osv):
319 _name = 'account.analytic.line'
320 _description = 'Analytic Line'
323 'name': fields.char('Description', required=True),
324 'date': fields.date('Date', required=True, select=True),
325 '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')),
326 'unit_amount': fields.float('Quantity', help='Specifies the amount of quantity to count.'),
327 'account_id': fields.many2one('account.analytic.account', 'Analytic Account', required=True, ondelete='restrict', select=True, domain=[('type','<>','view')]),
328 'user_id': fields.many2one('res.users', 'User'),
329 'company_id': fields.related('account_id', 'company_id', type='many2one', relation='res.company', string='Company', store=True, readonly=True),
330 'journal_id': fields.many2one('account.analytic.journal', 'Analytic Journal', required=True, ondelete='restrict', select=True),
334 def _get_default_date(self, cr, uid, context=None):
335 return fields.date.context_today(self, cr, uid, context=context)
337 def __get_default_date(self, cr, uid, context=None):
338 return self._get_default_date(cr, uid, context=context)
341 'date': __get_default_date,
342 'company_id': lambda self,cr,uid,c: self.pool.get('res.company')._company_default_get(cr, uid, 'account.analytic.line', context=c),
348 def _check_no_view(self, cr, uid, ids, context=None):
349 analytic_lines = self.browse(cr, uid, ids, context=context)
350 for line in analytic_lines:
351 if line.account_id.type == 'view':
356 (_check_no_view, 'You cannot create analytic line on view account.', ['account_id']),
360 class account_analytic_journal(osv.osv):
361 _name = 'account.analytic.journal'
362 _description = 'Analytic Journal'
364 'name': fields.char('Journal Name', required=True),
365 'code': fields.char('Journal Code', size=8),
366 'active': fields.boolean('Active', help="If the active field is set to False, it will allow you to hide the analytic journal without removing it."),
367 'type': fields.selection(
368 [('sale', 'Sale'), ('purchase', 'Purchase'), ('cash', 'Cash'),
369 ('general', 'General'), ('situation', 'Situation')],
370 'Type', required=True, help="Gives the type of the analytic journal. When it needs for a document (eg: an invoice) to create analytic entries, Odoo will look for a matching journal of the same type."),
371 'line_ids': fields.one2many('account.analytic.line', 'journal_id', 'Lines'),
372 'company_id': fields.many2one('res.company', 'Company', required=True),
377 'company_id': lambda self, cr, uid, c=None: self.pool.get('res.users').browse(cr, uid, uid, c).company_id.id,