class account_analytic_account(osv.osv):
_name = 'account.analytic.account'
+ _inherit = ['mail.thread']
_description = 'Analytic Account'
def _compute_level_tree(self, cr, uid, ids, child_ids, res, field_names, context=None):
- def recursive_computation(account_id, res):
- currency_obj = self.pool.get('res.currency')
- account = self.browse(cr, uid, account_id)
+ currency_obj = self.pool.get('res.currency')
+ recres = {}
+ def recursive_computation(account):
+ result2 = res[account.id].copy()
for son in account.child_ids:
- res = recursive_computation(son.id, res)
+ result = recursive_computation(son)
for field in field_names:
- if account.currency_id.id == son.currency_id.id or field=='quantity':
- res[account.id][field] += res[son.id][field]
- else:
- res[account.id][field] += currency_obj.compute(cr, uid, son.currency_id.id, account.currency_id.id, res[son.id][field], context=context)
- return res
+ if (account.currency_id.id != son.currency_id.id) and (field!='quantity'):
+ result[field] = currency_obj.compute(cr, uid, son.currency_id.id, account.currency_id.id, result[field], context=context)
+ result2[field] += result[field]
+ return result2
for account in self.browse(cr, uid, ids, context=context):
if account.id not in child_ids:
continue
- res = recursive_computation(account.id, res)
- return res
+ recres[account.id] = recursive_computation(account)
+ return recres
- def _debit_credit_bal_qtty(self, cr, uid, ids, name, arg, context=None):
+ def _debit_credit_bal_qtty(self, cr, uid, ids, fields, arg, context=None):
res = {}
if context is None:
context = {}
child_ids = tuple(self.search(cr, uid, [('parent_id', 'child_of', ids)]))
for i in child_ids:
res[i] = {}
- for n in name:
+ for n in fields:
res[i][n] = 0.0
if not child_ids:
WHERE a.id IN %s
""" + where_date + """
GROUP BY a.id""", where_clause_args)
- for ac_id, debit, credit, balance, quantity in cr.fetchall():
- res[ac_id] = {'debit': debit, 'credit': credit, 'balance': balance, 'quantity': quantity}
- return self._compute_level_tree(cr, uid, ids, child_ids, res, ['debit', 'credit', 'balance', 'quantity'], context)
+ for row in cr.dictfetchall():
+ res[row['id']] = {}
+ for field in fields:
+ res[row['id']][field] = row[field]
+ return self._compute_level_tree(cr, uid, ids, child_ids, res, fields, context)
def name_get(self, cr, uid, ids, context=None):
+ if isinstance(ids, (int, long)):
+ ids=[ids]
if not ids:
return []
res = []
return result
- def _get_company_currency(self, cr, uid, ids, context=None):
+ def _get_analytic_account(self, cr, uid, ids, context=None):
company_obj = self.pool.get('res.company')
analytic_obj = self.pool.get('account.analytic.account')
accounts = []
return accounts
def _set_company_currency(self, cr, uid, ids, name, value, arg, context=None):
- if type(ids) != type([]):
+ if isinstance(ids, (int, long)):
ids=[ids]
for account in self.browse(cr, uid, ids, context=context):
- if not value:
- cr.execute("""update account_analytic_account set
- currency_id=NULL where id=%s""", (account.id, ))
- elif account.company_id.currency_id.id == value:
- cr.execute("""update account_analytic_account set
- currency_id=%s where id=%s""", (value, account.id, ))
- else:
- raise osv.except_osv(_('Error !'), _('The currency has to be the same as the currency of the selected company.'))
- return True
+ if account.company_id:
+ if account.company_id.currency_id.id != value:
+ 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."))
+ return cr.execute("""update account_analytic_account set currency_id=%s where id=%s""", (value, account.id, ))
def _currency(self, cr, uid, ids, field_name, arg, context=None):
result = {}
for rec in self.browse(cr, uid, ids, context=context):
- if not rec.currency_id.id:
- result[rec.id] = False
- else:
+ if rec.company_id:
result[rec.id] = rec.company_id.currency_id.id
+ else:
+ result[rec.id] = rec.currency_id.id
return result
_columns = {
'name': fields.char('Account Name', size=128, required=True),
- 'complete_name': fields.function(_complete_name_calc, method=True, type='char', string='Full Account Name'),
- 'code': fields.char('Account Code', size=24),
- 'type': fields.selection([('view','View'), ('normal','Normal')], 'Account Type', help='If you select the View Type, it means you won\'t allow to create journal entries using that account.'),
+ 'complete_name': fields.function(_complete_name_calc, type='char', string='Full Account Name'),
+ 'code': fields.char('Code/Reference', size=24, select=True),
+ 'type': fields.selection([('view','Analytic View'), ('normal','Analytic Account'),('contract','Contract or Project'),('template','Template of Project')], 'Type of Account', required=True,
+ help="If you select the View Type, it means you won\'t allow to create journal entries using that account.\n"\
+ "The type 'Analytic account' stands for usual accounts that you only want to use in accounting.\n"\
+ "If you select Contract or Project, it offers you the possibility to manage the validity and the invoicing options for this account.\n"\
+ "The special type 'Template of Project' allows you to define a template with default data that you can reuse easily."),
+ 'template_id': fields.many2one('account.analytic.account', 'Template of Contract'),
'description': fields.text('Description'),
'parent_id': fields.many2one('account.analytic.account', 'Parent Analytic Account', select=2),
'child_ids': fields.one2many('account.analytic.account', 'parent_id', 'Child Accounts'),
- 'child_complete_ids': fields.function(_child_compute, relation='account.analytic.account', method=True, string="Account Hierarchy", type='many2many'),
+ 'child_complete_ids': fields.function(_child_compute, relation='account.analytic.account', string="Account Hierarchy", type='many2many'),
'line_ids': fields.one2many('account.analytic.line', 'account_id', 'Analytic Entries'),
- 'balance': fields.function(_debit_credit_bal_qtty, method=True, type='float', string='Balance', multi='debit_credit_bal_qtty', digits_compute=dp.get_precision('Account')),
- 'debit': fields.function(_debit_credit_bal_qtty, method=True, type='float', string='Debit', multi='debit_credit_bal_qtty', digits_compute=dp.get_precision('Account')),
- 'credit': fields.function(_debit_credit_bal_qtty, method=True, type='float', string='Credit', multi='debit_credit_bal_qtty', digits_compute=dp.get_precision('Account')),
- 'quantity': fields.function(_debit_credit_bal_qtty, method=True, type='float', string='Quantity', multi='debit_credit_bal_qtty'),
- 'quantity_max': fields.float('Maximum Quantity', help='Sets the higher limit of quantity of hours.'),
- 'partner_id': fields.many2one('res.partner', 'Partner'),
- 'contact_id': fields.many2one('res.partner.address', 'Contact'),
- 'user_id': fields.many2one('res.users', 'Account Manager'),
+ 'balance': fields.function(_debit_credit_bal_qtty, type='float', string='Balance', multi='debit_credit_bal_qtty', digits_compute=dp.get_precision('Account')),
+ 'debit': fields.function(_debit_credit_bal_qtty, type='float', string='Debit', multi='debit_credit_bal_qtty', digits_compute=dp.get_precision('Account')),
+ 'credit': fields.function(_debit_credit_bal_qtty, type='float', string='Credit', multi='debit_credit_bal_qtty', digits_compute=dp.get_precision('Account')),
+ 'quantity': fields.function(_debit_credit_bal_qtty, type='float', string='Quantity', multi='debit_credit_bal_qtty'),
+ 'quantity_max': fields.float('Maximum Time', help='Sets the higher limit of time to work on the contract.'),
+ 'partner_id': fields.many2one('res.partner', 'Customer'),
+ 'user_id': fields.many2one('res.users', 'Project Manager'),
+ 'manager_id': fields.many2one('res.users', 'Account Manager'),
'date_start': fields.date('Date Start'),
'date': fields.date('Date End', select=True),
'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.
- 'state': fields.selection([('draft','Draft'),('open','Open'), ('pending','Pending'),('cancelled', 'Cancelled'),('close','Closed'),('template', 'Template')], 'State', required=True,
- help='* When an account is created its in \'Draft\' state.\
- \n* If any associated partner is there, it can be in \'Open\' state.\
- \n* If any pending balance is there it can be in \'Pending\'. \
- \n* And finally when all the transactions are over, it can be in \'Close\' state. \
- \n* The project can be in either if the states \'Template\' and \'Running\'.\n If it is template then we can make projects based on the template projects. If its in \'Running\' state it is a normal project.\
- \n If it is to be reviewed then the state is \'Pending\'.\n When the project is completed the state is set to \'Done\'.'),
- #'currency_id': fields.many2one('res.currency', 'Account currency', required=True),
- 'currency_id': fields.function(_currency, fnct_inv=_set_company_currency, method=True,
+ 'state': fields.selection([('template', 'Template'),('draft','New'),('open','In Progress'), ('cancelled', 'Cancelled'),('pending','To Renew'),('close','Closed')], 'Status', required=True,),
+ 'currency_id': fields.function(_currency, fnct_inv=_set_company_currency,
store = {
- 'res.company': (_get_company_currency, ['currency_id'], 10),
+ 'res.company': (_get_analytic_account, ['currency_id'], 10),
}, string='Currency', type='many2one', relation='res.currency'),
}
+
+ def on_change_template(self, cr, uid, ids, template_id, context=None):
+ if not template_id:
+ return {}
+ res = {'value':{}}
+ template = self.browse(cr, uid, template_id, context=context)
+ res['value']['date_start'] = template.date_start
+ res['value']['date'] = template.date
+ res['value']['quantity_max'] = template.quantity_max
+ res['value']['description'] = template.description
+ return res
+
+ def on_change_partner_id(self, cr, uid, ids,partner_id, name, context={}):
+ res={}
+ if partner_id:
+ partner = self.pool.get('res.partner').browse(cr, uid, partner_id, context=context)
+ if partner.user_id:
+ res['manager_id'] = partner.user_id.id
+ if not name:
+ res['name'] = _('Contract: ') + partner.name
+ return {'value': res}
def _default_company(self, cr, uid, context=None):
user = self.pool.get('res.users').browse(cr, uid, uid, context=context)
_defaults = {
'type': 'normal',
'company_id': _default_company,
+ 'code' : lambda obj, cr, uid, context: obj.pool.get('ir.sequence').get(cr, uid, 'account.analytic.account'),
'state': 'open',
'user_id': lambda self, cr, uid, ctx: uid,
'partner_id': lambda self, cr, uid, ctx: ctx.get('partner_id', False),
- 'contact_id': lambda self, cr, uid, ctx: ctx.get('contact_id', False),
'date_start': lambda *a: time.strftime('%Y-%m-%d'),
'currency_id': _get_default_currency,
}
-# def check_currency(self, cr, uid, ids, context=None):
-# obj = self.browse(cr, uid, ids[0], context=context)
-# if obj.company_id:
-# if obj.currency_id.id != self.pool.get('res.company').browse(cr, uid, obj.company_id.id, context=context).currency_id.id:
-# return False
-# return True
+ def check_recursion(self, cr, uid, ids, context=None, parent=None):
+ return super(account_analytic_account, self)._check_recursion(cr, uid, ids, context=context, parent=parent)
- def check_recursion(self, cr, uid, ids, parent=None):
- return super(account_analytic_account, self)._check_recursion(cr, uid, ids, parent=parent)
-
- _order = 'date_start desc,parent_id desc,code'
+ _order = 'name asc'
_constraints = [
(check_recursion, 'Error! You can not create recursive analytic accounts.', ['parent_id']),
-# (check_currency, 'Error! The currency has to be the same as the currency of the selected company', ['currency_id', 'company_id']),
]
def copy(self, cr, uid, id, default=None, context=None):
cr.execute("select analytic_account_id from project_project")
project_ids = [x[0] for x in cr.fetchall()]
return self.name_get(cr, uid, project_ids, context=context)
- account = self.search(cr, uid, [('code', '=', name)] + args, limit=limit, context=context)
- if not account:
- account = self.search(cr, uid, [('name', 'ilike', '%%%s%%' % name)] + args, limit=limit, context=context)
- newacc = account
- while newacc:
- newacc = self.search(cr, uid, [('parent_id', 'in', newacc)]+args, limit=limit, context=context)
- account += newacc
+ if name:
+ account = self.search(cr, uid, [('code', '=', name)] + args, limit=limit, context=context)
+ if not account:
+ names=map(lambda i : i.strip(),name.split('/'))
+ for i in range(len(names)):
+ dom=[('name', operator, names[i])]
+ if i>0:
+ dom+=[('id','child_of',account)]
+ account = self.search(cr, uid, dom, limit=limit, context=context)
+ newacc = account
+ while newacc:
+ newacc = self.search(cr, uid, [('parent_id', 'in', newacc)], limit=limit, context=context)
+ account += newacc
+ if args:
+ account = self.search(cr, uid, [('id', 'in', account)] + args, limit=limit, context=context)
+ else:
+ account = self.search(cr, uid, args, limit=limit, context=context)
return self.name_get(cr, uid, account, context=context)
+ def create(self, cr, uid, vals, context=None):
+ contract = super(account_analytic_account, self).create(cr, uid, vals, context=context)
+ if contract:
+ self.create_send_note(cr, uid, [contract], context=context)
+ return contract
+
+ def create_send_note(self, cr, uid, ids, context=None):
+ for obj in self.browse(cr, uid, ids, context=context):
+ self.message_subscribe(cr, uid, [obj.id], [obj.user_id.id], context=context)
+ 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)
+
account_analytic_account()
_order = 'date desc'
+ def _check_no_view(self, cr, uid, ids, context=None):
+ analytic_lines = self.browse(cr, uid, ids, context=context)
+ for line in analytic_lines:
+ if line.account_id.type == 'view':
+ return False
+ return True
+
+ _constraints = [
+ (_check_no_view, 'You can not create analytic line on view account.', ['account_id']),
+ ]
+
account_analytic_line()
# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
projects / odoo / odoo.git / blobdiff