--- /dev/null
+# -*- 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 <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+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}