1 # -*- coding: utf-8 -*-
2 ##############################################################################
4 # OpenERP, Open Source Management Solution
5 # Copyright (C) 2004-2009 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 dateutil.relativedelta import relativedelta
25 from os.path import join as opj
26 from operator import itemgetter
28 from tools.translate import _
29 from osv import fields, osv
33 class account_installer(osv.osv_memory):
34 _name = 'account.installer'
35 _inherit = 'res.config.installer'
37 def _get_charts(self, cr, uid, context=None):
38 modules = self.pool.get('ir.module.module')
39 ids = modules.search(cr, uid, [('category_id', '=', 'Account Charts')], context=context)
41 sorted(((m.name, m.shortdesc)
42 for m in modules.browse(cr, uid, ids, context=context)),
44 charts.insert(0, ('configurable', 'Generic Chart Of Account'))
49 'charts': fields.selection(_get_charts, 'Chart of Accounts',
51 help="Installs localized accounting charts to match as closely as "
52 "possible the accounting needs of your company based on your "
54 'date_start': fields.date('Start Date', required=True),
55 'date_stop': fields.date('End Date', required=True),
56 'period': fields.selection([('month', 'Monthly'), ('3months','3 Monthly')], 'Periods', required=True),
57 'sale_tax': fields.float('Sale Tax(%)'),
58 'purchase_tax': fields.float('Purchase Tax(%)'),
59 'company_id': fields.many2one('res.company', 'Company', required=True),
62 def _default_company(self, cr, uid, context=None):
63 user = self.pool.get('res.users').browse(cr, uid, uid, context=context)
64 return user.company_id and user.company_id.id or False
66 def _get_default_charts(self, cr, uid, context=None):
68 company_id = self._default_company(cr, uid, context=context)
69 company = self.pool.get('res.company').browse(cr, uid, company_id, context=context)
70 address_id = self.pool.get('res.partner').address_get(cr, uid, [company.partner_id.id])
71 if address_id['default']:
72 address = self.pool.get('res.partner.address').browse(cr, uid, address_id['default'], context=context)
73 code = address.country_id.code
74 module_name = (code and 'l10n_' + code.lower()) or False
76 module_id = self.pool.get('ir.module.module').search(cr, uid, [('name', '=', module_name)], context=context)
82 'date_start': lambda *a: time.strftime('%Y-01-01'),
83 'date_stop': lambda *a: time.strftime('%Y-12-31'),
87 'company_id': _default_company,
88 'charts': _get_default_charts
91 def fields_view_get(self, cr, uid, view_id=None, view_type='form', context=None, toolbar=False, submenu=False):
92 res = super(account_installer, self).fields_view_get(cr, uid, view_id=view_id, view_type=view_type, context=context, toolbar=toolbar,submenu=False)
96 company_ids = self.pool.get('res.company').search(cr, uid, [], context=context)
97 #display in the widget selection of companies, only the companies that haven't been configured yet (but don't care about the demo chart of accounts)
98 cr.execute("SELECT company_id FROM account_account WHERE active = 't' AND account_account.parent_id IS NULL AND name != %s", ("Chart For Automated Tests",))
99 configured_cmp = [r[0] for r in cr.fetchall()]
100 unconfigured_cmp = list(set(company_ids)-set(configured_cmp))
101 for field in res['fields']:
102 if field == 'company_id':
103 res['fields'][field]['domain'] = unconfigured_cmp
104 res['fields'][field]['selection'] = [('', '')]
106 cmp_select = [(line.id, line.name) for line in self.pool.get('res.company').browse(cr, uid, unconfigured_cmp)]
107 res['fields'][field]['selection'] = cmp_select
110 def on_change_tax(self, cr, uid, id, tax):
111 return {'value': {'purchase_tax': tax}}
113 def on_change_start_date(self, cr, uid, id, start_date=False):
115 start_date = datetime.datetime.strptime(start_date, "%Y-%m-%d")
116 end_date = (start_date + relativedelta(months=12)) - relativedelta(days=1)
117 return {'value': {'date_stop': end_date.strftime('%Y-%m-%d')}}
120 def execute(self, cr, uid, ids, context=None):
123 super(account_installer, self).execute(cr, uid, ids, context=context)
124 fy_obj = self.pool.get('account.fiscalyear')
125 mod_obj = self.pool.get('ir.model.data')
126 obj_acc_temp = self.pool.get('account.account.template')
127 obj_tax_code_temp = self.pool.get('account.tax.code.template')
128 obj_tax_temp = self.pool.get('account.tax.template')
129 obj_product = self.pool.get('product.product')
130 ir_values = self.pool.get('ir.values')
131 obj_acc_chart_temp = self.pool.get('account.chart.template')
132 record = self.browse(cr, uid, ids, context=context)[0]
133 company_id = record.company_id
134 for res in self.read(cr, uid, ids, context=context):
135 if record.charts == 'configurable':
136 fp = tools.file_open(opj('account', 'configurable_account_chart.xml'))
137 tools.convert_xml_import(cr, 'account', fp, {}, 'init', True, None)
139 s_tax = (res.get('sale_tax', 0.0))/100
140 p_tax = (res.get('purchase_tax', 0.0))/100
141 pur_temp_tax = mod_obj.get_object_reference(cr, uid, 'account', 'tax_code_base_purchases')
142 pur_temp_tax_id = pur_temp_tax and pur_temp_tax[1] or False
144 pur_temp_tax_paid = mod_obj.get_object_reference(cr, uid, 'account', 'tax_code_output')
145 pur_temp_tax_paid_id = pur_temp_tax_paid and pur_temp_tax_paid[1] or False
147 sale_temp_tax = mod_obj.get_object_reference(cr, uid, 'account', 'tax_code_base_sales')
148 sale_temp_tax_id = sale_temp_tax and sale_temp_tax[1] or False
150 sale_temp_tax_paid = mod_obj.get_object_reference(cr, uid, 'account', 'tax_code_input')
151 sale_temp_tax_paid_id = sale_temp_tax_paid and sale_temp_tax_paid[1] or False
153 chart_temp_ids = obj_acc_chart_temp.search(cr, uid, [('name','=','Configurable Account Chart Template')], context=context)
154 chart_temp_id = chart_temp_ids and chart_temp_ids[0] or False
155 if s_tax * 100 > 0.0:
156 tax_account_ids = obj_acc_temp.search(cr, uid, [('name', '=', 'Tax Received')], context=context)
157 sales_tax_account_id = tax_account_ids and tax_account_ids[0] or False
158 vals_tax_code_temp = {
159 'name': _('TAX %s%%') % (s_tax*100),
160 'code': _('TAX %s%%') % (s_tax*100),
161 'parent_id': sale_temp_tax_id
163 new_tax_code_temp = obj_tax_code_temp.create(cr, uid, vals_tax_code_temp, context=context)
164 vals_paid_tax_code_temp = {
165 'name': _('TAX Received %s%%') % (s_tax*100),
166 'code': _('TAX Received %s%%') % (s_tax*100),
167 'parent_id': sale_temp_tax_paid_id
169 new_paid_tax_code_temp = obj_tax_code_temp.create(cr, uid, vals_paid_tax_code_temp, context=context)
170 sales_tax_temp = obj_tax_temp.create(cr, uid, {
171 'name': _('TAX %s%%') % (s_tax*100),
173 'base_code_id': new_tax_code_temp,
174 'tax_code_id': new_paid_tax_code_temp,
175 'ref_base_code_id': new_tax_code_temp,
176 'ref_tax_code_id': new_paid_tax_code_temp,
177 'type_tax_use': 'sale',
180 'account_collected_id': sales_tax_account_id,
181 'account_paid_id': sales_tax_account_id,
182 'chart_template_id': chart_temp_id,
184 if p_tax * 100 > 0.0:
185 tax_account_ids = obj_acc_temp.search(cr, uid, [('name', '=', 'Tax Paid')], context=context)
186 purchase_tax_account_id = tax_account_ids and tax_account_ids[0] or False
187 vals_tax_code_temp = {
188 'name': _('TAX %s%%') % (p_tax*100),
189 'code': _('TAX %s%%') % (p_tax*100),
190 'parent_id': pur_temp_tax_id
192 new_tax_code_temp = obj_tax_code_temp.create(cr, uid, vals_tax_code_temp, context=context)
193 vals_paid_tax_code_temp = {
194 'name': _('TAX Paid %s%%') % (p_tax*100),
195 'code': _('TAX Paid %s%%') % (p_tax*100),
196 'parent_id': pur_temp_tax_paid_id
198 new_paid_tax_code_temp = obj_tax_code_temp.create(cr, uid, vals_paid_tax_code_temp, context=context)
199 purchase_tax_temp = obj_tax_temp.create(cr, uid, {
200 'name': _('TAX %s%%') % (p_tax*100),
201 'description': _('TAX %s%%') % (p_tax*100),
203 'base_code_id': new_tax_code_temp,
204 'tax_code_id': new_paid_tax_code_temp,
205 'ref_base_code_id': new_tax_code_temp,
206 'ref_tax_code_id': new_paid_tax_code_temp,
207 'type_tax_use': 'purchase',
210 'account_collected_id': purchase_tax_account_id,
211 'account_paid_id': purchase_tax_account_id,
212 'chart_template_id': chart_temp_id,
215 if 'date_start' in res and 'date_stop' in res:
216 f_ids = fy_obj.search(cr, uid, [('date_start', '<=', res['date_start']), ('date_stop', '>=', res['date_stop']), ('company_id', '=', res['company_id'])], context=context)
218 name = code = res['date_start'][:4]
219 if int(name) != int(res['date_stop'][:4]):
220 name = res['date_start'][:4] +'-'+ res['date_stop'][:4]
221 code = res['date_start'][2:4] +'-'+ res['date_stop'][2:4]
225 'date_start': res['date_start'],
226 'date_stop': res['date_stop'],
227 'company_id': res['company_id']
229 fiscal_id = fy_obj.create(cr, uid, vals, context=context)
230 if res['period'] == 'month':
231 fy_obj.create_period(cr, uid, [fiscal_id])
232 elif res['period'] == '3months':
233 fy_obj.create_period3(cr, uid, [fiscal_id])
235 def modules_to_install(self, cr, uid, ids, context=None):
236 modules = super(account_installer, self).modules_to_install(
237 cr, uid, ids, context=context)
238 chart = self.read(cr, uid, ids, ['charts'],
239 context=context)[0]['charts']
240 self.logger.notifyChannel(
241 'installer', netsvc.LOG_DEBUG,
242 'Installing chart of accounts %s'%chart)
243 return modules | set([chart])
247 class account_installer_modules(osv.osv_memory):
248 _name = 'account.installer.modules'
249 _inherit = 'res.config.installer'
251 'account_analytic_plans': fields.boolean('Multiple Analytic Plans',
252 help="Allows invoice lines to impact multiple analytic accounts "
254 'account_payment': fields.boolean('Suppliers Payment Management',
255 help="Streamlines invoice payment and creates hooks to plug "
256 "automated payment systems in."),
257 'account_followup': fields.boolean('Followups Management',
258 help="Helps you generate reminder letters for unpaid invoices, "
259 "including multiple levels of reminding and customized "
260 "per-partner policies."),
261 'account_voucher': fields.boolean('Voucher Management',
262 help="Account Voucher module includes all the basic requirements of "
263 "Voucher Entries for Bank, Cash, Sales, Purchase, Expenses, Contra, etc... "),
264 'account_anglo_saxon': fields.boolean('Anglo-Saxon Accounting',
265 help="This module will support the Anglo-Saxons accounting methodology by "
266 "changing the accounting logic with stock transactions."),
270 'account_voucher': True,
273 account_installer_modules()
275 # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4: