2010-01-06 15:24:08 +00:00
# -*- coding: utf-8 -*-
##############################################################################
#
# OpenERP, Open Source Management Solution
# Copyright (C) 2004-2009 Tiny SPRL (<http://tiny.be>).
#
# 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/>.
#
##############################################################################
2010-08-13 04:12:51 +00:00
2010-04-30 06:13:14 +00:00
import datetime
from dateutil . relativedelta import relativedelta
2012-12-06 14:56:32 +00:00
import logging
2010-04-30 06:13:14 +00:00
from operator import itemgetter
2012-12-06 14:56:32 +00:00
import time
2013-01-24 19:00:39 +00:00
import urllib2
import urlparse
2012-12-06 14:56:32 +00:00
2013-01-24 19:00:39 +00:00
try :
import simplejson as json
except ImportError :
import json # noqa
from openerp . release import serie
2012-12-06 14:56:32 +00:00
from openerp . tools . translate import _
from openerp . osv import fields , osv
2010-08-13 04:12:51 +00:00
2012-06-22 06:48:54 +00:00
_logger = logging . getLogger ( __name__ )
2010-01-06 15:24:08 +00:00
class account_installer ( osv . osv_memory ) :
_name = ' account.installer '
_inherit = ' res.config.installer '
[imp] account, base_setup: move chart of accounts selection from base_setup installer to account's
Also remove it from account's config item as it's redundant
Rationale: account can be installed due to dependency chains, not just
direct installation from base_setup: project, stock, purchase and
profile_auction all depend on account, mrp depends on stock which
depends on account, so from base_setup's installer alone there are 5
different ways to end up with account installed and need to configure
charts of accounts.
Therefore having chart of accounts config in base_setup's installer is
dumb (as we need a second one anyway), and since it's (in a way) a
problem of module installation, the most coherent way is to move it to
account/installer.py, and remove it from the config screen where it
was (which becomes redundant).
Made it required, because it was required in the config item, not sure
it's actually mandatory to install a chart of accounts but whatever.
bzr revid: xmo@tinyerp.com-20100126140830-h4c7hlvmzzos69ls
2010-01-26 14:08:30 +00:00
def _get_charts ( self , cr , uid , context = None ) :
modules = self . pool . get ( ' ir.module.module ' )
2013-01-24 19:00:39 +00:00
# try get the list on apps server
try :
2013-07-18 12:35:26 +00:00
apps_server = self . pool . get ( ' ir.module.module ' ) . get_apps_server ( cr , uid , context = context )
2013-01-24 19:00:39 +00:00
up = urlparse . urlparse ( apps_server )
url = ' {0.scheme} :// {0.netloc} /apps/charts?serie= {1} ' . format ( up , serie )
j = urllib2 . urlopen ( url , timeout = 3 ) . read ( )
apps_charts = json . loads ( j )
charts = dict ( apps_charts )
except Exception :
charts = dict ( )
2011-11-03 14:40:39 +00:00
# Looking for the module with the 'Account Charts' category
category_name , category_id = self . pool . get ( ' ir.model.data ' ) . get_object_reference ( cr , uid , ' base ' , ' module_category_localization_account_charts ' )
ids = modules . search ( cr , uid , [ ( ' category_id ' , ' = ' , category_id ) ] , context = context )
2013-01-24 19:00:39 +00:00
if ids :
charts . update ( ( m . name , m . shortdesc ) for m in modules . browse ( cr , uid , ids , context = context ) )
charts = sorted ( charts . items ( ) , key = itemgetter ( 1 ) )
2012-09-12 17:16:36 +00:00
charts . insert ( 0 , ( ' configurable ' , _ ( ' Custom ' ) ) )
2010-04-30 06:13:14 +00:00
return charts
[imp] account, base_setup: move chart of accounts selection from base_setup installer to account's
Also remove it from account's config item as it's redundant
Rationale: account can be installed due to dependency chains, not just
direct installation from base_setup: project, stock, purchase and
profile_auction all depend on account, mrp depends on stock which
depends on account, so from base_setup's installer alone there are 5
different ways to end up with account installed and need to configure
charts of accounts.
Therefore having chart of accounts config in base_setup's installer is
dumb (as we need a second one anyway), and since it's (in a way) a
problem of module installation, the most coherent way is to move it to
account/installer.py, and remove it from the config screen where it
was (which becomes redundant).
Made it required, because it was required in the config item, not sure
it's actually mandatory to install a chart of accounts but whatever.
bzr revid: xmo@tinyerp.com-20100126140830-h4c7hlvmzzos69ls
2010-01-26 14:08:30 +00:00
2010-01-06 15:24:08 +00:00
_columns = {
# Accounting
2012-09-12 17:16:36 +00:00
' charts ' : fields . selection ( _get_charts , ' Accounting Package ' ,
2010-09-01 12:26:56 +00:00
required = True ,
[imp] account, base_setup: move chart of accounts selection from base_setup installer to account's
Also remove it from account's config item as it's redundant
Rationale: account can be installed due to dependency chains, not just
direct installation from base_setup: project, stock, purchase and
profile_auction all depend on account, mrp depends on stock which
depends on account, so from base_setup's installer alone there are 5
different ways to end up with account installed and need to configure
charts of accounts.
Therefore having chart of accounts config in base_setup's installer is
dumb (as we need a second one anyway), and since it's (in a way) a
problem of module installation, the most coherent way is to move it to
account/installer.py, and remove it from the config screen where it
was (which becomes redundant).
Made it required, because it was required in the config item, not sure
it's actually mandatory to install a chart of accounts but whatever.
bzr revid: xmo@tinyerp.com-20100126140830-h4c7hlvmzzos69ls
2010-01-26 14:08:30 +00:00
help = " Installs localized accounting charts to match as closely as "
" possible the accounting needs of your company based on your "
" country. " ) ,
2010-04-30 06:13:14 +00:00
' date_start ' : fields . date ( ' Start Date ' , required = True ) ,
' date_stop ' : fields . date ( ' End Date ' , required = True ) ,
2013-04-18 10:39:07 +00:00
' period ' : fields . selection ( [ ( ' month ' , ' Monthly ' ) , ( ' 3months ' , ' 3 Monthly ' ) ] , ' Periods ' , required = True ) ,
2010-12-23 15:16:39 +00:00
' company_id ' : fields . many2one ( ' res.company ' , ' Company ' , required = True ) ,
2013-04-18 10:39:07 +00:00
' has_default_company ' : fields . boolean ( ' Has Default Company ' , readonly = True ) ,
2010-07-30 13:17:47 +00:00
}
2010-08-20 06:58:03 +00:00
2010-09-23 05:47:31 +00:00
def _default_company ( self , cr , uid , context = None ) :
2010-08-20 06:58:03 +00:00
user = self . pool . get ( ' res.users ' ) . browse ( cr , uid , uid , context = context )
2010-10-21 12:24:24 +00:00
return user . company_id and user . company_id . id or False
2010-08-20 06:58:03 +00:00
2011-10-26 14:56:43 +00:00
def _default_has_default_company ( self , cr , uid , context = None ) :
count = self . pool . get ( ' res.company ' ) . search_count ( cr , uid , [ ] , context = context )
return bool ( count == 1 )
2010-09-14 05:57:48 +00:00
2010-01-06 15:24:08 +00:00
_defaults = {
2010-11-04 12:42:42 +00:00
' date_start ' : lambda * a : time . strftime ( ' % Y-01-01 ' ) ,
' date_stop ' : lambda * a : time . strftime ( ' % Y-12-31 ' ) ,
2010-10-18 15:13:12 +00:00
' period ' : ' month ' ,
2010-08-20 06:58:03 +00:00
' company_id ' : _default_company ,
2011-10-26 14:56:43 +00:00
' has_default_company ' : _default_has_default_company ,
2011-09-26 23:31:59 +00:00
' charts ' : ' configurable '
2010-07-30 13:17:47 +00:00
}
2013-04-18 10:39:07 +00:00
2012-02-13 15:03:22 +00:00
def get_unconfigured_cmp ( self , cr , uid , context = None ) :
2012-02-13 15:21:21 +00:00
""" get the list of companies that have not been configured yet
but don ' t care about the demo chart of accounts " " "
2010-12-10 09:40:23 +00:00
company_ids = self . pool . get ( ' res.company ' ) . search ( cr , uid , [ ] , context = context )
2010-12-23 15:16:39 +00:00
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 " , ) )
configured_cmp = [ r [ 0 ] for r in cr . fetchall ( ) ]
2012-02-13 15:21:52 +00:00
return list ( set ( company_ids ) - set ( configured_cmp ) )
2013-04-18 10:39:07 +00:00
2012-02-13 15:03:22 +00:00
def check_unconfigured_cmp ( self , cr , uid , context = None ) :
2012-02-13 15:21:21 +00:00
""" check if there are still unconfigured companies """
2012-02-13 15:03:22 +00:00
if not self . get_unconfigured_cmp ( cr , uid , context = context ) :
2013-04-30 07:25:47 +00:00
raise osv . except_osv ( _ ( ' No Unconfigured Company! ' ) , _ ( " There is currently no company without chart of account. The wizard will therefore not be executed. " ) )
2013-04-18 10:39:07 +00:00
2012-02-13 15:03:22 +00:00
def fields_view_get ( self , cr , uid , view_id = None , view_type = ' form ' , context = None , toolbar = False , submenu = False ) :
2013-04-18 10:39:07 +00:00
if context is None : context = { }
res = super ( account_installer , self ) . fields_view_get ( cr , uid , view_id = view_id , view_type = view_type , context = context , toolbar = toolbar , submenu = False )
2012-02-13 15:03:22 +00:00
cmp_select = [ ]
2012-02-13 15:21:21 +00:00
# display in the widget selection only the companies that haven't been configured yet
2012-02-13 15:03:22 +00:00
unconfigured_cmp = self . get_unconfigured_cmp ( cr , uid , context = context )
2010-12-24 12:59:47 +00:00
for field in res [ ' fields ' ] :
2011-04-29 08:49:48 +00:00
if field == ' company_id ' :
2013-04-18 10:39:07 +00:00
res [ ' fields ' ] [ field ] [ ' domain ' ] = [ ( ' id ' , ' in ' , unconfigured_cmp ) ]
2011-04-29 08:49:48 +00:00
res [ ' fields ' ] [ field ] [ ' selection ' ] = [ ( ' ' , ' ' ) ]
if unconfigured_cmp :
cmp_select = [ ( line . id , line . name ) for line in self . pool . get ( ' res.company ' ) . browse ( cr , uid , unconfigured_cmp ) ]
res [ ' fields ' ] [ field ] [ ' selection ' ] = cmp_select
2010-12-10 09:40:23 +00:00
return res
[imp] account, base_setup: move chart of accounts selection from base_setup installer to account's
Also remove it from account's config item as it's redundant
Rationale: account can be installed due to dependency chains, not just
direct installation from base_setup: project, stock, purchase and
profile_auction all depend on account, mrp depends on stock which
depends on account, so from base_setup's installer alone there are 5
different ways to end up with account installed and need to configure
charts of accounts.
Therefore having chart of accounts config in base_setup's installer is
dumb (as we need a second one anyway), and since it's (in a way) a
problem of module installation, the most coherent way is to move it to
account/installer.py, and remove it from the config screen where it
was (which becomes redundant).
Made it required, because it was required in the config item, not sure
it's actually mandatory to install a chart of accounts but whatever.
bzr revid: xmo@tinyerp.com-20100126140830-h4c7hlvmzzos69ls
2010-01-26 14:08:30 +00:00
2010-09-23 05:47:31 +00:00
def on_change_start_date ( self , cr , uid , id , start_date = False ) :
2010-04-30 06:13:14 +00:00
if start_date :
start_date = datetime . datetime . strptime ( start_date , " % Y- % m- %d " )
end_date = ( start_date + relativedelta ( months = 12 ) ) - relativedelta ( days = 1 )
2010-10-20 05:13:53 +00:00
return { ' value ' : { ' date_stop ' : end_date . strftime ( ' % Y- % m- %d ' ) } }
2010-04-30 06:13:14 +00:00
return { }
def execute ( self , cr , uid , ids , context = None ) :
2011-11-23 14:16:16 +00:00
self . execute_simple ( cr , uid , ids , context )
2013-04-12 15:44:22 +00:00
return super ( account_installer , self ) . execute ( cr , uid , ids , context = context )
2011-11-23 14:16:16 +00:00
def execute_simple ( self , cr , uid , ids , context = None ) :
2010-08-13 04:12:51 +00:00
if context is None :
context = { }
2010-09-08 08:03:49 +00:00
fy_obj = self . pool . get ( ' account.fiscalyear ' )
2010-10-21 09:19:25 +00:00
for res in self . read ( cr , uid , ids , context = context ) :
2010-05-03 10:28:01 +00:00
if ' date_start ' in res and ' date_stop ' in res :
2011-03-16 09:48:46 +00:00
f_ids = fy_obj . search ( cr , uid , [ ( ' date_start ' , ' <= ' , res [ ' date_start ' ] ) , ( ' date_stop ' , ' >= ' , res [ ' date_stop ' ] ) , ( ' company_id ' , ' = ' , res [ ' company_id ' ] [ 0 ] ) ] , context = context )
2010-09-08 09:32:25 +00:00
if not f_ids :
name = code = res [ ' date_start ' ] [ : 4 ]
if int ( name ) != int ( res [ ' date_stop ' ] [ : 4 ] ) :
2013-04-18 10:39:07 +00:00
name = res [ ' date_start ' ] [ : 4 ] + ' - ' + res [ ' date_stop ' ] [ : 4 ]
code = res [ ' date_start ' ] [ 2 : 4 ] + ' - ' + res [ ' date_stop ' ] [ 2 : 4 ]
2010-10-21 09:19:25 +00:00
vals = {
' name ' : name ,
' code ' : code ,
' date_start ' : res [ ' date_start ' ] ,
' date_stop ' : res [ ' date_stop ' ] ,
2011-03-16 09:48:46 +00:00
' company_id ' : res [ ' company_id ' ] [ 0 ]
2010-10-21 09:19:25 +00:00
}
2010-09-08 10:43:18 +00:00
fiscal_id = fy_obj . create ( cr , uid , vals , context = context )
2010-09-08 09:32:25 +00:00
if res [ ' period ' ] == ' month ' :
2010-09-08 10:43:18 +00:00
fy_obj . create_period ( cr , uid , [ fiscal_id ] )
2010-09-08 09:32:25 +00:00
elif res [ ' period ' ] == ' 3months ' :
2010-09-08 10:43:18 +00:00
fy_obj . create_period3 ( cr , uid , [ fiscal_id ] )
2010-08-20 06:58:03 +00:00
[imp] account, base_setup: move chart of accounts selection from base_setup installer to account's
Also remove it from account's config item as it's redundant
Rationale: account can be installed due to dependency chains, not just
direct installation from base_setup: project, stock, purchase and
profile_auction all depend on account, mrp depends on stock which
depends on account, so from base_setup's installer alone there are 5
different ways to end up with account installed and need to configure
charts of accounts.
Therefore having chart of accounts config in base_setup's installer is
dumb (as we need a second one anyway), and since it's (in a way) a
problem of module installation, the most coherent way is to move it to
account/installer.py, and remove it from the config screen where it
was (which becomes redundant).
Made it required, because it was required in the config item, not sure
it's actually mandatory to install a chart of accounts but whatever.
bzr revid: xmo@tinyerp.com-20100126140830-h4c7hlvmzzos69ls
2010-01-26 14:08:30 +00:00
def modules_to_install ( self , cr , uid , ids , context = None ) :
modules = super ( account_installer , self ) . modules_to_install (
cr , uid , ids , context = context )
chart = self . read ( cr , uid , ids , [ ' charts ' ] ,
context = context ) [ 0 ] [ ' charts ' ]
2012-06-22 06:57:56 +00:00
_logger . debug ( ' Installing chart of accounts %s ' , chart )
2013-04-17 14:58:29 +00:00
return ( modules | set ( [ chart ] ) ) - set ( [ ' has_default_company ' , ' configurable ' ] )
[imp] account, base_setup: move chart of accounts selection from base_setup installer to account's
Also remove it from account's config item as it's redundant
Rationale: account can be installed due to dependency chains, not just
direct installation from base_setup: project, stock, purchase and
profile_auction all depend on account, mrp depends on stock which
depends on account, so from base_setup's installer alone there are 5
different ways to end up with account installed and need to configure
charts of accounts.
Therefore having chart of accounts config in base_setup's installer is
dumb (as we need a second one anyway), and since it's (in a way) a
problem of module installation, the most coherent way is to move it to
account/installer.py, and remove it from the config screen where it
was (which becomes redundant).
Made it required, because it was required in the config item, not sure
it's actually mandatory to install a chart of accounts but whatever.
bzr revid: xmo@tinyerp.com-20100126140830-h4c7hlvmzzos69ls
2010-01-26 14:08:30 +00:00
2010-05-05 04:53:49 +00:00
2010-11-04 12:08:52 +00:00
# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4: