X-Git-Url: https://git.cyclocoop.org/%28%28?a=blobdiff_plain;f=wizard%2Fgeneral_ledger_wizard.py;fp=wizard%2Fgeneral_ledger_wizard.py;h=79766563dfb3c69fa4cd69c8a6b076eb2c7d3bdd;hb=cddef38e342c880228694525c45df3f7dd8c2148;hp=0000000000000000000000000000000000000000;hpb=bffd331c220385010fe9abad9e228fc2004a293a;p=burette%2Faccount_financial_report_webkit.git diff --git a/wizard/general_ledger_wizard.py b/wizard/general_ledger_wizard.py new file mode 100644 index 0000000..7976656 --- /dev/null +++ b/wizard/general_ledger_wizard.py @@ -0,0 +1,136 @@ +# -*- encoding: utf-8 -*- +############################################################################## +# +# Author: Nicolas Bessi, Guewen Baconnier +# Copyright Camptocamp SA 2011 +# +# 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 . +# +############################################################################## + +import time + +from openerp.osv import fields, orm + + +class AccountReportGeneralLedgerWizard(orm.TransientModel): + """Will launch general ledger report and pass required args""" + + _inherit = "account.common.account.report" + _name = "general.ledger.webkit" + _description = "General Ledger Report" + + def _get_account_ids(self, cr, uid, context=None): + res = False + if context.get('active_model', False) == 'account.account' and context.get('active_ids', False): + res = context['active_ids'] + return res + + _columns = { + 'amount_currency': fields.boolean("With Currency", + help="It adds the currency column"), + + 'display_account': fields.selection([('bal_all', 'All'), + ('bal_mix', 'With transactions or non zero balance')], + 'Display accounts', + required=True), + 'account_ids': fields.many2many('account.account', string='Filter on accounts', + help="""Only selected accounts will be printed. Leave empty to print all accounts."""), + 'centralize': fields.boolean('Activate Centralization', help='Uncheck to display all the details of centralized accounts.') + } + _defaults = { + 'amount_currency': False, + 'display_account': 'bal_mix', + 'account_ids': _get_account_ids, + 'centralize': True, + } + + def _check_fiscalyear(self, cr, uid, ids, context=None): + obj = self.read(cr, uid, ids[0], ['fiscalyear_id', 'filter'], context=context) + if not obj['fiscalyear_id'] and obj['filter'] == 'filter_no': + return False + return True + + _constraints = [ + (_check_fiscalyear, 'When no Fiscal year is selected, you must choose to filter by periods or by date.', ['filter']), + ] + + def pre_print_report(self, cr, uid, ids, data, context=None): + data = super(AccountReportGeneralLedgerWizard, self).pre_print_report(cr, uid, ids, data, context) + # will be used to attach the report on the main account + data['ids'] = [data['form']['chart_account_id']] + vals = self.read(cr, uid, ids, + ['amount_currency', + 'display_account', + 'account_ids', + 'centralize'], + context=context)[0] + data['form'].update(vals) + return data + + def onchange_filter(self, cr, uid, ids, filter='filter_no', fiscalyear_id=False, context=None): + res = {} + if filter == 'filter_no': + res['value'] = { + 'period_from': False, + 'period_to': False, + 'date_from': False, + 'date_to': False, + } + if filter == 'filter_date': + if fiscalyear_id: + fyear = self.pool.get('account.fiscalyear').browse(cr, uid, fiscalyear_id, context=context) + date_from = fyear.date_start + date_to = fyear.date_stop > time.strftime('%Y-%m-%d') and time.strftime('%Y-%m-%d') or fyear.date_stop + else: + date_from, date_to = time.strftime('%Y-01-01'), time.strftime('%Y-%m-%d') + res['value'] = { + 'period_from': False, + 'period_to': False, + 'date_from': date_from, + 'date_to': date_to + } + if filter == 'filter_period' and fiscalyear_id: + start_period = end_period = False + cr.execute(''' + SELECT * FROM (SELECT p.id + FROM account_period p + LEFT JOIN account_fiscalyear f ON (p.fiscalyear_id = f.id) + WHERE f.id = %s + AND COALESCE(p.special, FALSE) = FALSE + ORDER BY p.date_start ASC + LIMIT 1) AS period_start + UNION ALL + SELECT * FROM (SELECT p.id + FROM account_period p + LEFT JOIN account_fiscalyear f ON (p.fiscalyear_id = f.id) + WHERE f.id = %s + AND p.date_start < NOW() + AND COALESCE(p.special, FALSE) = FALSE + ORDER BY p.date_stop DESC + LIMIT 1) AS period_stop''', (fiscalyear_id, fiscalyear_id)) + periods = [i[0] for i in cr.fetchall()] + if periods: + start_period = end_period = periods[0] + if len(periods) > 1: + end_period = periods[1] + res['value'] = {'period_from': start_period, 'period_to': end_period, 'date_from': False, 'date_to': False} + return res + + def _print_report(self, cursor, uid, ids, data, context=None): + # we update form with display account value + data = self.pre_print_report(cursor, uid, ids, data, context=context) + return {'type': 'ir.actions.report.xml', + 'report_name': 'account.account_report_general_ledger_webkit', + 'datas': data}