=== removed directory 'account_balance_reporting' === removed file 'account_balance_reporting/__init__.py' --- account_balance_reporting/__init__.py 2012-12-11 10:06:23 +0000 +++ account_balance_reporting/__init__.py 1970-01-01 00:00:00 +0000 @@ -1,34 +0,0 @@ -# -*- coding: utf-8 -*- -# -*- encoding: utf-8 -*- -############################################################################## -# -# OpenERP - Account balance reporting engine -# Copyright (C) 2009 Pexego Sistemas Informáticos. All Rights Reserved -# AvanzOSC, Avanzed Open Source Consulting -# Copyright (C) 2011-2012 Iker Coranti (www.avanzosc.com). All Rights Reserved -# $Id$ -# -# This program is free software: you can redistribute it and/or modify -# it under the terms of the GNU 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 General Public License for more details. -# -# You should have received a copy of the GNU General Public License -# along with this program. If not, see . -# -############################################################################## - -""" -Account balance reporting engine -""" -__author__ = "Borja López Soilán (Pexego) - borjals@pexego.es" - -import account_balance_reporting_template -import account_balance_reporting -import report -import wizard === removed file 'account_balance_reporting/__openerp__.py' --- account_balance_reporting/__openerp__.py 2012-12-11 10:06:23 +0000 +++ account_balance_reporting/__openerp__.py 1970-01-01 00:00:00 +0000 @@ -1,70 +0,0 @@ -# -*- coding: utf-8 -*- -# -*- encoding: utf-8 -*- -############################################################################## -# -# OpenERP - Account balance reporting engine -# Copyright (C) 2009 Pexego Sistemas Informáticos. All Rights Reserved -# AvanzOSC, Avanzed Open Source Consulting -# Copyright (C) 2011-2012 Iker Coranti (www.avanzosc.com). All Rights Reserved -# $Id$ -# -# This program is free software: you can redistribute it and/or modify -# it under the terms of the GNU 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 General Public License for more details. -# -# You should have received a copy of the GNU General Public License -# along with this program. If not, see . -# -############################################################################## - -{ - "name" : "Account balance reporting engine", - "version" : "0.2", - "author" : "Pexego", - "website" : "http://www.pexego.es", - "category" : "Enterprise Specific Modules", - "description": """ -The module allows the user to create account balance reports and templates, -comparing the values of 'accounting concepts' between two fiscal years -or a set of fiscal periods. - -Accounting concepts values can be calculated as the sum of some account balances, -the sum of its children, other account concepts or constant values. - -Generated reports are stored as objects on the server, -so you can check them anytime later or edit them -(to add notes for example) before printing. - -The module lets the user add new templates of the reports concepts, -and associate them a specific "XML reports" (OpenERP RML files for example) -with the design used when printing. -So it is very easy to add predefined country-specific official reports. - -The user interface has been designed to be as much user-friendly as it can be. - -Note: It has been designed to meet Spanish/Spain localization needs, -but it might be used as a generic accounting report engine. - """, - "depends" : [ - 'base', - 'account', - ], - "init_xml" : [ - ], - "demo_xml" : [ ], - "update_xml" : [ - 'security/ir.model.access.csv', - 'account_balance_reporting_wizard.xml', - 'account_balance_reporting_template_view.xml', - 'account_balance_reporting_view.xml', - 'account_balance_reporting_workflow.xml', - 'account_balance_reporting_reports.xml', - ], - "installable": True -} === removed file 'account_balance_reporting/account_balance_reporting.py' --- account_balance_reporting/account_balance_reporting.py 2012-12-11 10:06:23 +0000 +++ account_balance_reporting/account_balance_reporting.py 1970-01-01 00:00:00 +0000 @@ -1,565 +0,0 @@ -# -*- coding: utf-8 -*- -# -*- encoding: utf-8 -*- -############################################################################## -# -# OpenERP - Account balance reporting engine -# Copyright (C) 2009 Pexego Sistemas Informáticos. All Rights Reserved -# $Id$ -# -# This program is free software: you can redistribute it and/or modify -# it under the terms of the GNU 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 General Public License for more details. -# -# You should have received a copy of the GNU General Public License -# along with this program. If not, see . -# -############################################################################## - -""" -Account balance report objects - -Generic account balance report document (with header and detail lines). -Designed following the needs of the -Spanish/Spain localization. -""" -__author__ = "Borja López Soilán (Pexego)" - - -from osv import fields, osv -import re -import time -from tools.translate import _ -import netsvc - -################################################################################ -# CSS classes for the account line templates -################################################################################ - -CSS_CLASSES = [('default','Default'),('l1', 'Level 1'), ('l2', 'Level 2'), - ('l3', 'Level 3'), ('l4', 'Level 4'), ('l5', 'Level 5')] - -################################################################################ -# Account balance report (document / header) -################################################################################ - -class account_balance_reporting(osv.osv): - """ - Account balance report. - It stores the configuration/header fields of an account balance report, - and the linked lines of detail with the values of the accounting concepts - (values generated from the selected template lines of detail formulas). - """ - - #_inherit = "account.common.account.report" - _name = "account.balance.reporting" - - _columns = { - # Name of this report - 'name': fields.char('Name', size=64, required=True, select=True), - # Template used to calculate this report - 'template_id': fields.many2one('account.balance.reporting.template', 'Template', ondelete='set null', required=True, select=True, - states = {'calc_done': [('readonly', True)], 'done': [('readonly', True)]}), - # Date of the last calculation - 'calc_date': fields.datetime("Calculation date"), - # State of the report - 'state': fields.selection([('draft','Draft'),('calc','Processing'),('calc_done','Processed'),('done','Done'),('canceled','Canceled')], 'State'), - # Company - 'company_id': fields.many2one('res.company', 'Company', ondelete='cascade', readonly=True, required=True), - # - # Current fiscal year and it's (selected) periods - # - 'current_fiscalyear_id': fields.many2one('account.fiscalyear','Fiscal year 1', select=True, required=True, - states = {'calc_done': [('readonly', True)], 'done': [('readonly', True)]}), - 'current_period_ids': fields.many2many('account.period', 'account_balance_reporting_account_period_current_rel', 'account_balance_reporting_id', 'period_id', 'Fiscal year 1 periods', - states = {'calc_done': [('readonly', True)], 'done': [('readonly', True)]}), - # - # Previous fiscal year and it's (selected) periods - # - 'previous_fiscalyear_id': fields.many2one('account.fiscalyear','Fiscal year 2', select=True, - states = {'calc_done': [('readonly', True)], 'done': [('readonly', True)]}), - 'previous_period_ids': fields.many2many('account.period', 'account_balance_reporting_account_period_previous_rel', 'account_balance_reporting_id', 'period_id', 'Fiscal year 2 periods', - states = {'calc_done': [('readonly', True)], 'done': [('readonly', True)]}), - } - - _defaults = { - # Current company by default: - 'company_id': lambda self, cr, uid, context: self.pool.get('res.users').browse(cr, uid, uid, context).company_id.id, - # Draft state by default: - 'state': lambda *a: 'draft', - } - - # - # Actions ################################################################## - # - - def action_calculate(self, cr, uid, ids, context=None): - """ - Called when the user presses the Calculate button. - It will use the report template to generate lines of detail for the - report with calculated values. - """ - report_line_facade = self.pool.get('account.balance.reporting.line') - - # Set the state to 'calculating' - self.write(cr, uid, ids, { - 'state': 'calc', - 'calc_date': time.strftime('%Y-%m-%d %H:%M:%S') - }) - - # - # Replace the lines of detail of the report with new lines from its template - # - - reports = self.browse(cr, uid, ids, context) - for report in reports: - # Clear the report data (unlink the lines of detail) - report_line_facade.unlink(cr, uid, [line.id for line in report.line_ids]) - - # - # Fill the report with a 'copy' of the lines of its template (if it has one) - # - if report.template_id: - for template_line in report.template_id.line_ids: - report_line_facade.create(cr, uid, { - 'code': template_line.code, - 'name': template_line.name, - 'report_id': report.id, - 'template_line_id': template_line.id, - 'parent_id': None, - 'current_value': None, - 'previous_value': None, - 'sequence': template_line.sequence, - 'css_class': template_line.css_class, - }, context) - - # - # Set the parents of the lines in the report - # Note: We reload the reports objects to refresh the lines of detail. - # - reports = self.browse(cr, uid, ids, context) - for report in reports: - if report.template_id: - # - # Establecemos los padres de las líneas (ahora que ya están creados) - # - for line in report.line_ids: - if line.template_line_id and line.template_line_id.parent_id: - parent_line_id = report_line_facade.search(cr, uid, [('report_id', '=', report.id), ('code', '=', line.template_line_id.parent_id.code)]) - report_line_facade.write(cr, uid, line.id, { - 'parent_id': len(parent_line_id) and parent_line_id[0] or None, - }, context) - - # - # Calculate the values of the lines - # Note: We reload the reports objects to refresh the lines of detail. - # - reports = self.browse(cr, uid, ids, context) - for report in reports: - if report.template_id: - # Refresh the report's lines values - for line in report.line_ids: - line.refresh_values() - - # Set the report as calculated - self.write(cr, uid, [report.id], { - 'state': 'calc_done' - }) - else: - # Ouch! no template: Going back to draft state. - self.write(cr, uid, [report.id], {'state': 'draft'}) - return True - - - def action_confirm(self, cr, uid, ids, context=None): - """ - Called when the user clicks the confirm button. - """ - self.write(cr, uid, ids, {'state': 'done'}) - return True - - - def action_cancel(self, cr, uid, ids, context=None): - """ - Called when the user clicks the cancel button. - """ - self.write(cr, uid, ids, {'state': 'canceled'}) - return True - - def action_recover(self, cr, uid, ids, context=None): - """ - Called when the user clicks the draft button to create - a new workflow instance. - """ - self.write(cr, uid, ids, {'state': 'draft', 'calc_date': None}) - wf_service = netsvc.LocalService("workflow") - for item_id in ids: - wf_service.trg_create(uid, 'account.balance.reporting', item_id, cr) - return True - - def calculate_action(self, cr, uid, ids, context): - """ - Calculate the selected balance report data. - """ - report_id = None - #if data.get('model') == 'account.balance.reporting': - #report_id = data.get('id') - report_id = ids - if report_id[0]: - # - # Send the calculate signal to the balance report - # to trigger action_calculate. - # - wf_service = netsvc.LocalService('workflow') - wf_service.trg_validate(uid, 'account.balance.reporting', report_id[0], 'calculate', cr) - return 'close' - -account_balance_reporting() - - - -################################################################################ -# Account balance report line of detail (accounting concept) -################################################################################ - -class account_balance_reporting_line(osv.osv): - """ - Account balance report line / Accounting concept - One line of detail of the balance report representing an accounting - concept with its values. - The accounting concepts follow a parent-children hierarchy. - Its values (current and previous) are calculated based on the 'value' - formula of the linked template line. - """ - - _name = "account.balance.reporting.line" - - _columns = { - # Parent report of this line - 'report_id': fields.many2one('account.balance.reporting', 'Report', ondelete='cascade'), - - # Concept official code (as specified by normalized models, will be used when printing) - 'code': fields.char('Code', size=64, required=True, select=True), - # Concept official name (will be used when printing) - 'name': fields.char('Name', size=256, required=True, select=True), - # Notes value (references to the notes) - 'notes': fields.text('Notes'), - # Concept value in this fiscal year - 'current_value': fields.float('Fiscal year 1', digits=(16,2)), - # Concept value on the previous fiscal year - 'previous_value': fields.float('Fiscal year 2', digits=(16,2)), - # Date of the last calculation - 'calc_date': fields.datetime("Calculation date"), - # Order sequence, it's also used for grouping into sections, that's why it is a char - 'sequence': fields.char('Sequence', size=32, required=False), - # CSS class, used when printing to set the style of the line - 'css_class': fields.selection(CSS_CLASSES, 'CSS Class', required=False), - # Linked template line used to calculate this line values - 'template_line_id': fields.many2one('account.balance.reporting.template.line', 'Line template', ondelete='set null'), - # Parent accounting concept - 'parent_id': fields.many2one('account.balance.reporting.line', 'Parent', ondelete='cascade'), - # Children accounting concepts - 'child_ids': fields.one2many('account.balance.reporting.line', 'parent_id', 'Children'), - } - - _defaults = { - # Use context report_id as the the parent report - 'report_id': lambda self, cr, uid, context: context.get('report_id', None), - # Default css class (so we always have a class) - 'css_class': lambda *a: 'default', - } - - # Lines are sorted by its sequence and code - _order = "sequence, code" - - # Don't let the user repeat codes in the report (the codes will be used to look up accounting concepts) - _sql_constraints = [ - ('report_code_uniq', 'unique (report_id,code)', _("The code must be unique for this report!")) - ] - - - - def name_get(self, cr, uid, ids, context=None): - """ - Redefine the name_get method to show the code in the name ("[code] name"). - """ - if not len(ids): - return [] - res=[] - for item in self.browse(cr,uid,ids): - res.append((item.id, "[%s] %s" % (item.code, item.name))) - return res - - - def name_search(self, cr, uid, name, args=[], operator='ilike', context={}, limit=80): - """ - Redefine the name_search method to allow searching by code. - """ - ids = [] - if name: - ids = self.search(cr, uid, [('code','ilike',name)]+ args, limit=limit) - if not ids: - ids = self.search(cr, uid, [('name',operator,name)]+ args, limit=limit) - return self.name_get(cr, uid, ids, context=context) - - - def refresh_values(self, cr, uid, ids, context=None): - """ - Recalculates the values of this report line using the - linked line template values formulas: - - Depending on this formula the final value is calculated as follows: - - Empy template value: sum of (this concept) children values. - - Number with decimal point ("10.2"): that value (constant). - - Account numbers separated by commas ("430,431,(437)"): Sum of the account balances. - (The sign of the balance depends on the balance mode) - - Concept codes separated by "+" ("11000+12000"): Sum of those concepts values. - """ - for line in self.browse(cr, uid, ids): - current_value = 0.0 - previous_value = 0.0 - - # - # We use the same code to calculate both fiscal year values, - # just iterating over them. - # - for fyear in ('current', 'previous'): - value = 0 - if fyear == 'current': - template_value = line.template_line_id.current_value - elif fyear == 'previous': - template_value = line.template_line_id.previous_value - - # Remove characters after a ";" (we use ; for comments) - if template_value and len(template_value): - template_value = template_value.split(';')[0] - - if (fyear == 'current' and not line.report_id.current_fiscalyear_id) \ - or (fyear == 'previous' and not line.report_id.previous_fiscalyear_id): - value = 0 - else: - # - # Calculate the value - # - if not template_value or not len(template_value): - # - # Empy template value => sum of the children, of this concept, values. - # - for child in line.child_ids: - if child.calc_date != child.report_id.calc_date: - # Tell the child to refresh its values - child.refresh_values() - # Reload the child data - child = self.browse(cr, uid, [child.id])[0] - if fyear == 'current': - value += float(child.current_value) - elif fyear == 'previous': - value += float(child.previous_value) - - elif re.match(r'^\-?[0-9]*\.[0-9]*$', template_value): - # - # Number with decimal points => that number value (constant). - # - value = float(template_value) - - elif re.match(r'^[0-9a-zA-Z,\(\)\*_]*$', template_value): - # - # Account numbers separated by commas => sum of the account balances. - # - # We will use the context to filter the accounts by fiscalyear - # and periods. - # - if fyear == 'current': - ctx = { - 'fiscalyear': line.report_id.current_fiscalyear_id.id, - 'periods': [p.id for p in line.report_id.current_period_ids], - } - elif fyear == 'previous': - ctx = { - 'fiscalyear': line.report_id.previous_fiscalyear_id.id, - 'periods': [p.id for p in line.report_id.previous_period_ids], - } - - # Get the mode of balance calculation from the template - balance_mode = line.template_line_id.report_id.balance_mode - - # Get the balance - value = line._get_account_balance(template_value, balance_mode, ctx) - - elif re.match(r'^[\+\-0-9a-zA-Z_\*]*$', template_value): - # - # Account concept codes separated by "+" => sum of the concept (report lines) values. - # - for line_code in re.findall(r'(-?\(?[0-9a-zA-Z_]*\)?)', template_value): - # Check the sign of the code (substraction) - if line_code.startswith('-') or line_code.startswith('('): - sign = -1.0 - else: - sign = 1.0 - line_code = line_code.strip('-()*') - - # Check if the code is valid (findall might return empty strings) - if len(line_code) > 0: - # Search for the line (perfect match) - line_ids = self.search(cr, uid, [ - ('report_id','=', line.report_id.id), - ('code', '=', line_code), - ]) - for child in self.browse(cr, uid, line_ids): - if child.calc_date != child.report_id.calc_date: - # Tell the child to refresh its values - child.refresh_values() - # Reload the child data - child = self.browse(cr, uid, [child.id])[0] - if fyear == 'current': - value += float(child.current_value) * sign - elif fyear == 'previous': - value += float(child.previous_value) * sign - - # - # Negate the value if needed - # - if line.template_line_id.negate: - value = -value - - if fyear == 'current': - current_value = value - elif fyear == 'previous': - previous_value = value - - # Write the values - self.write(cr, uid, [line.id], { - 'current_value': current_value, - 'previous_value': previous_value, - 'calc_date': line.report_id.calc_date - }) - return True - - - def _get_account_balance(self, cr, uid, ids, code, balance_mode=0, context=None): - """ - It returns the (debit, credit, balance*) tuple for a account with the - given code, or the sum of those values for a set of accounts - when the code is in the form "400,300,(323)" - - Depending on the balance_mode, the balance is calculated as follows: - Mode 0: debit-credit for all accounts (default); - Mode 1: debit-credit, credit-debit for accounts in brackets; - Mode 2: credit-debit for all accounts; - Mode 3: credit-debit, debit-credit for accounts in brackets. - - Also the user may specify to use only the debit or credit of the account - instead of the balance writing "debit(551)" or "credit(551)". - """ - acc_facade = self.pool.get('account.account') - res = 0.0 - line = self.browse(cr, uid, ids)[0] - - assert balance_mode in ('0','1','2','3'), "balance_mode should be in [0..3]" - - # We iterate over the accounts listed in "code", so code can be - # a string like "430+431+432-438"; accounts split by "+" will be added, - # accounts split by "-" will be substracted. - # - # We also take in consideration the balance_mode: - # Mode 0: credit-debit for all accounts - # Mode 1: debit-credit, credit-debit for accounts in brackets - # Mode 2: credit-debit, debit-credit for accounts in brackets - # Mode 3: credit-debit, debit-credit for accounts in brackets. - # - # And let the user get just the credit or debit if he specifies so. - # - for account_code in re.findall('(-?\w*\(?[0-9a-zA-Z_]*\)?)', code): - # Check if the code is valid (findall might return empty strings) - if len(account_code) > 0: - # - # Check the sign of the code (substraction) - # - if account_code.startswith('-'): - sign = -1.0 - account_code = account_code[1:] # Strip the sign - else: - sign = 1.0 - - - if re.match(r'^debit\(.*\)$', account_code): - # Use debit instead of balance - mode = 'debit' - account_code = account_code[6:-1] # Strip debit() - elif re.match(r'^credit\(.*\)$', account_code): - # Use credit instead of balance - mode = 'credit' - account_code = account_code[7:-1] # Strip credit() - else: - mode = 'balance' - # - # Calculate the balance, as given by the balance mode - # - if balance_mode == '1': - # We use debit-credit as default balance, - # but for accounts in brackets we use credit-debit - if account_code.startswith('(') and account_code.endswith(')'): - sign = -1.0 * sign - elif balance_mode == '2': - # We use credit-debit as the balance, - sign = -1.0 * sign - elif balance_mode == '3': - # We use credit-debit as default balance, - # but for accounts in brackets we use debit-credit - if not account_code.startswith('(') and account_code.endswith(')'): - sign = -1.0 * sign - # Strip the brackets (if there are brackets) - if account_code.startswith('(') and account_code.endswith(')'): - account_code = account_code[1:-1] - - # Search for the account (perfect match) - account_ids = acc_facade.search(cr, uid, [ - ('code', '=', account_code), - ('company_id','=', line.report_id.company_id.id) - ], context=context) - if not account_ids: - # We didn't find the account, search for a subaccount ending with '0' - account_ids = acc_facade.search(cr, uid, [ - ('code', '=like', '%s%%0' % account_code), - ('company_id','=', line.report_id.company_id.id) - ], context=context) - - if len(account_ids) > 0: - if mode == 'debit': - res += acc_facade.browse(cr, uid, account_ids, context)[0].debit - elif mode == 'credit': - res += acc_facade.browse(cr, uid, account_ids, context)[0].credit - else: - res += acc_facade.browse(cr, uid, account_ids, context)[0].balance * sign - else: - netsvc.Logger().notifyChannel('account_balance_reporting', netsvc.LOG_WARNING, "Account with code '%s' not found!" % account_code) - - return res - - -account_balance_reporting_line() - - -class account_balance_reporting_withlines(osv.osv): - """ - Extend the 'account balance report' to add a link to its - lines of detail. - """ - - _inherit = "account.balance.reporting" - - _columns = { - 'line_ids': fields.one2many('account.balance.reporting.line', 'report_id', 'Lines', - states = {'done': [('readonly', True)]}), - } - -account_balance_reporting_withlines() - - - - === removed file 'account_balance_reporting/account_balance_reporting_reports.xml' --- account_balance_reporting/account_balance_reporting_reports.xml 2012-12-11 10:06:23 +0000 +++ account_balance_reporting/account_balance_reporting_reports.xml 1970-01-01 00:00:00 +0000 @@ -1,52 +0,0 @@ - - - - - - - - - - - - - - - === removed file 'account_balance_reporting/account_balance_reporting_template.py' --- account_balance_reporting/account_balance_reporting_template.py 2012-12-11 10:06:23 +0000 +++ account_balance_reporting/account_balance_reporting_template.py 1970-01-01 00:00:00 +0000 @@ -1,263 +0,0 @@ -# -*- coding: utf-8 -*- -# -*- encoding: utf-8 -*- -############################################################################## -# -# OpenERP - Account balance reporting engine -# Copyright (C) 2009 Pexego Sistemas Informáticos. All Rights Reserved -# $Id$ -# -# This program is free software: you can redistribute it and/or modify -# it under the terms of the GNU 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 General Public License for more details. -# -# You should have received a copy of the GNU General Public License -# along with this program. If not, see . -# -############################################################################## - -""" -Account balance report templates - -Generic account balance report template that will be used to define -accounting concepts with formulas to calculate its values/balance. -Designed following the needs of the Spanish/Spain localization. -""" -__author__ = "Borja López Soilán (Pexego) - borjals@pexego.es" - - -from osv import fields, osv -import re -import time -from tools.translate import _ - -_BALANCE_MODE_HELP = """Formula calculation mode: Depending on it, the balance is calculated as follows: - Mode 0: debit-credit (default); - Mode 1: debit-credit, credit-debit for accounts in brackets; - Mode 2: credit-debit; - Mode 3: credit-debit, debit-credit for accounts in brackets.""" - -_VALUE_FORMULA_HELP = """Value calculation formula: Depending on this formula the final value is calculated as follows: - Empy template value: sum of (this concept) children values. - Number with decimal point ("10.2"): that value (constant). - Account numbers separated by commas ("430,431,(437)"): Sum of the account balances - (the sign of the balance depends on the balance mode). - Concept codes separated by "+" ("11000+12000"): Sum of those concepts values. -""" - -################################################################################ -# CSS classes for the account lines -################################################################################ - -CSS_CLASSES = [('default','Default'), - ('l1', 'Level 1'), - ('l2', 'Level 2'), - ('l3', 'Level 3'), - ('l4', 'Level 4'), - ('l5', 'Level 5')] - -################################################################################ -# Account balance report template (document/header) -################################################################################ - -class account_balance_reporting_template(osv.osv): - """ - Account balance report template. - It stores the header fields of an account balance report template, - and the linked lines of detail with the formulas to calculate - the accounting concepts of the report. - """ - - _name = "account.balance.reporting.template" - - _columns = { - # Report template name - 'name': fields.char('Name', size=64, required=True, select=True), - # Type (system = not editable by the user [updated from XML files]) - 'type': fields.selection([('system','System'),('user','User')], 'Type'), - # Report design - 'report_xml_id': fields.many2one('ir.actions.report.xml', 'Report design', ondelete='set null'), - # Description - 'description': fields.text('Description'), - # Balance mode - 'balance_mode': fields.selection([('0','Debit-Credit'),('1','Debit-Credit, reversed with brakets'),('2','Credit-Debit'),('3','Credit-Debit, reversed with brakets')], 'Balance mode', help=_BALANCE_MODE_HELP), - } - - _defaults = { - # New templates are 'user' editable by default - 'type': lambda *a: 'user', - # Use mode 0 by default - 'balance_mode': lambda *a: '0', - } - - def copy(self, cr, uid, id, default=None, context=None): - """ - Redefine the copy method to perform it correctly as the line - structure is a graph. - """ - line_facade = self.pool.get('account.balance.reporting.template.line') - - # Read the current item data: - template = self.browse(cr, uid, id) - - # Create the template - new_id = self.create(cr, uid, { - 'name': '%s*' % template.name, # We change the name to identify the copy - 'type': 'user', # Copies are always user templates - 'report_xml_id': template.report_xml_id.id, - 'description': template.description, - 'balance_mode': template.balance_mode, - 'line_ids': None, - }, context) - - # - # Now create the lines (without parents) - # - for line in template.line_ids: - line_facade.create(cr, uid, { - 'report_id': new_id, - 'sequence': line.sequence, - 'css_class': line.css_class, - 'code': line.code, - 'name': line.name, - 'current_value': line.current_value, - 'previous_value': line.previous_value, - 'negate': line.negate, - 'parent_id': None, - 'child_ids': None, - }, context) - - # - # Now set the (lines) parents - # - for line in template.line_ids: - if line.parent_id: - # Search for the copied line - new_line_id = line_facade.search(cr, uid, [ - ('report_id', '=', new_id), - ('code', '=', line.code), - ])[0] - # Search for the copied parent line - new_parent_id = line_facade.search(cr, uid, [ - ('report_id', '=', new_id), - ('code', '=', line.parent_id.code), - ])[0] - # Set the parent - line_facade.write(cr, uid, new_line_id, { - 'parent_id': new_parent_id, - }) - - return new_id - -account_balance_reporting_template() - - - -################################################################################ -# Account balance report template line of detail (accounting concept template) -################################################################################ - -class account_balance_reporting_template_line(osv.osv): - """ - Account balance report template line / Accounting concept template - One line of detail of the balance report representing an accounting - concept with the formulas to calculate its values. - The accounting concepts follow a parent-children hierarchy. - """ - - _name = "account.balance.reporting.template.line" - - _columns = { - # Parent report of this line - 'report_id': fields.many2one('account.balance.reporting.template', 'Template', ondelete='cascade'), - - # Order sequence, it's also used for grouping into sections, that's why it is a char - 'sequence': fields.char('Sequence', size=32, required=False, help="Lines will be sorted/grouped by this field"), - # CSS class, used when printing to set the style of the line - 'css_class': fields.selection(CSS_CLASSES, 'CSS Class', required=False, help="Style-sheet class"), - - # Concept official code (as specified by normalized models, will be used when printing) - 'code': fields.char('Code', size=64, required=True, select=True, help="Concept code, may be used on formulas to reference this line"), - # Concept official name (will be used when printing) - 'name': fields.char('Name', size=256, required=True, select=True, help="Concept name/description"), - # Concept value formula in this fiscal year - 'current_value': fields.text('Fiscal year 1 formula', help=_VALUE_FORMULA_HELP), - # Concept value on the previous fiscal year - 'previous_value': fields.text('Fiscal year 2 formula', help=_VALUE_FORMULA_HELP), - # Negate the value? - 'negate': fields.boolean('Negate', help="Negate the value (change the sign of the balance)"), - - # Parent accounting concept - 'parent_id': fields.many2one('account.balance.reporting.template.line', 'Parent', ondelete='cascade'), - # Children accounting concepts - 'child_ids': fields.one2many('account.balance.reporting.template.line', 'parent_id', 'Children'), - } - - _defaults = { - # Use context report_id as the the parent report - 'report_id': lambda self, cr, uid, context: context.get('report_id', None), - # Don't negate by default - 'negate': lambda *a: False, - # Default css class (so we always have a class) - 'css_class': lambda *a: 'default', - } - - # Lines are sorted by its sequence and code - _order = "sequence, code" - - # Don't let the user repeat codes in the report (the codes will be used to look up accounting concepts) - _sql_constraints = [ - ('report_code_uniq', 'unique (report_id,code)', _("The code must be unique for this report!")) - ] - - - - def name_get(self, cr, uid, ids, context=None): - """ - Redefine the name_get method to show the code in the name ("[code] name"). - """ - if not len(ids): - return [] - res=[] - for item in self.browse(cr,uid,ids): - res.append((item.id, "[%s] %s" % (item.code, item.name))) - return res - - - def name_search(self, cr, uid, name, args=[], operator='ilike', context={}, limit=80): - """ - Redefine the name_search method to allow searching by code. - """ - ids = [] - if name: - ids = self.search(cr, uid, [('code','ilike',name)]+ args, limit=limit) - if not ids: - ids = self.search(cr, uid, [('name',operator,name)]+ args, limit=limit) - return self.name_get(cr, uid, ids, context=context) - - -account_balance_reporting_template_line() - - -class account_balance_reporting_template_withlines(osv.osv): - """ - Extend the 'account balance report template' to add a link to its - lines of detail. - """ - - _inherit = "account.balance.reporting.template" - - _columns = { - 'line_ids': fields.one2many('account.balance.reporting.template.line', 'report_id', 'Lines'), - } - -account_balance_reporting_template_withlines() - - - - === removed file 'account_balance_reporting/account_balance_reporting_template_view.xml' --- account_balance_reporting/account_balance_reporting_template_view.xml 2012-12-11 10:06:23 +0000 +++ account_balance_reporting/account_balance_reporting_template_view.xml 1970-01-01 00:00:00 +0000 @@ -1,170 +0,0 @@ - - - - - - - - - - - account.balance.reporting.template.form - account.balance.reporting.template - form - -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - account.balance.reporting.template.tree - account.balance.reporting.template - tree - - - - - - - - - - - - - - account.balance.reporting.template.line.form - account.balance.reporting.template.line - form - -
- - - - - - - - - - - - - - - - -
- - - - - - account.balance.reporting.template.line.tree - account.balance.reporting.template.line - tree - - - - - - - - - - - - - - - - - Account balance templates - ir.actions.act_window - account.balance.reporting.template - form - tree,form - - - - - - - - === removed file 'account_balance_reporting/account_balance_reporting_view.xml' --- account_balance_reporting/account_balance_reporting_view.xml 2012-12-11 10:06:23 +0000 +++ account_balance_reporting/account_balance_reporting_view.xml 1970-01-01 00:00:00 +0000 @@ -1,201 +0,0 @@ - - - - - - - - - - - - account.balance.reporting.form - account.balance.reporting - form - -
- - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - sale.order.invoicing.search.inh - sale.order - search - - - - - - - - - - - - - - - - - === removed directory 'account_invoice_analytics/wizard' === removed file 'account_invoice_analytics/wizard/__init__.py' --- account_invoice_analytics/wizard/__init__.py 2012-12-11 10:06:23 +0000 +++ account_invoice_analytics/wizard/__init__.py 1970-01-01 00:00:00 +0000 @@ -1,22 +0,0 @@ -# -*- encoding: utf-8 -*- -############################################################################## -# -# Avanzosc - Avanced Open Source Consulting -# Copyright (C) 2011 - 2012 Avanzosc -# -# 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 account_find_analytic_entries === removed file 'account_invoice_analytics/wizard/account_find_analytic_entries.py' --- account_invoice_analytics/wizard/account_find_analytic_entries.py 2012-12-11 10:06:23 +0000 +++ account_invoice_analytics/wizard/account_find_analytic_entries.py 1970-01-01 00:00:00 +0000 @@ -1,56 +0,0 @@ -# -*- encoding: utf-8 -*- -############################################################################## -# -# Avanzosc - Avanced Open Source Consulting -# Copyright (C) 2010 - 2011 Avanzosc -# -# 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/. -# -############################################################################## - -from osv import osv -from osv import fields - -class account_find_analytic_entries(osv.osv_memory): - _name = 'account.find.analytic.entries' - _description = 'Find Analytic Entries' - - def _get_default_invoice_type(self, cr, uid, context=None): - factor = self.pool.get('hr_timesheet_invoice.factor') - return factor.search(cr, uid, [])[0] - - _columns = { - 'start_date': fields.date('Start Date', required=True), - 'finish_date': fields.date('Finish Date', required=True), - 'invoice_type': fields.many2one('hr_timesheet_invoice.factor','Invoice Type', required=True), - } - - _defaults = { - 'invoice_type': lambda self, cr, uid, context: self._get_default_invoice_type(cr, uid, context), - } - - def action_find(self, cr, uid, ids, context=None): - for entri in self.browse(cr, uid, ids): - wizard = { - 'type': 'ir.actions.act_window', - 'res_model': 'account.analytic.line', - 'view_type': 'form', - 'view_mode': 'tree,form', - 'domain': [('date', '>=', entri.start_date), ('date', '<=', entri.finish_date), ('to_invoice', '=', entri.invoice_type.id), ('invoice_id', '=', False)], - 'context':context - } - return wizard - return False - -account_find_analytic_entries() \ No newline at end of file === removed file 'account_invoice_analytics/wizard/account_invoice_wiz.xml' --- account_invoice_analytics/wizard/account_invoice_wiz.xml 2012-12-11 10:06:23 +0000 +++ account_invoice_analytics/wizard/account_invoice_wiz.xml 1970-01-01 00:00:00 +0000 @@ -1,40 +0,0 @@ - - - - - - account.find.analytic.entries.form - account.find.analytic.entries - form - -
- -
- - - - - payment.order.form.ext1 - payment.order - form - - - - - - - - payment.order.form.ext2 - payment.order - form - - - - - - - - - - - - - - payment.order.form.cancel - payment.order - form - - - - - - - - payment.line.ext1 - payment.line - form - - - - - - - - - - - - - - - - - Pay. payment order - payment.order - form - tree,form - [('type','=','payable')] - {'type':'payable'} - - - - - Rec. payment order - payment.order - form - tree,form - [('type','=','receivable')] - {'type':'receivable'} - - - - - - Payments - account.move.line - partner_id - tree - - - - - - - - - - - - - - - - - - - - - - Invoice Payments Select - account.move.line - search - - - - - - - - - - - - - - - - - - - - - - - - - Invoice payments - account.move.line - form - - - [('account_id.type','in',['receivable','payable']),('invoice','<>',False)] - - - - - - Done payments - account.move.line - form - - - [('account_id.type','in',['receivable','payable']),('invoice','=',False)] - - - - - === removed file 'account_payment_extension/payment_wizard.xml' --- account_payment_extension/payment_wizard.xml 2012-12-11 10:06:23 +0000 +++ account_payment_extension/payment_wizard.xml 1970-01-01 00:00:00 +0000 @@ -1,7 +0,0 @@ - - - - - - - === removed directory 'account_payment_extension/security' === removed file 'account_payment_extension/security/ir.model.access.csv' --- account_payment_extension/security/ir.model.access.csv 2012-12-11 10:06:23 +0000 +++ account_payment_extension/security/ir.model.access.csv 1970-01-01 00:00:00 +0000 @@ -1,4 +0,0 @@ -"id","name","model_id:id","group_id:id","perm_read","perm_write","perm_create","perm_unlink" -"access_payment_type","payment.type","model_payment_type","account_payment.group_account_payment",1,1,1,1 -"access_payment_type_user","payment.type.user","model_payment_type","base.group_user",1,0,0,0 - === removed directory 'account_payment_extension/wizard' === removed file 'account_payment_extension/wizard/__init__.py' --- account_payment_extension/wizard/__init__.py 2012-12-11 10:06:23 +0000 +++ account_payment_extension/wizard/__init__.py 1970-01-01 00:00:00 +0000 @@ -1,30 +0,0 @@ -# -*- encoding: utf-8 -*- -############################################################################## -# -# OpenERP, Open Source Management Solution -# Copyright (c) 2008 Zikzakmedia S.L. (http://zikzakmedia.com) All Rights Reserved. -# Jordi Esteve -# AvanzOSC, Avanzed Open Source Consulting -# Copyright (C) 2011-2012 Iker Coranti (www.avanzosc.com). All Rights Reserved -# $Id$ -# -# 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 wizard_payment_order -import wizard_populate_statement - -# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4: - === removed file 'account_payment_extension/wizard/wizard_payment_order.py' --- account_payment_extension/wizard/wizard_payment_order.py 2012-12-11 10:06:23 +0000 +++ account_payment_extension/wizard/wizard_payment_order.py 1970-01-01 00:00:00 +0000 @@ -1,240 +0,0 @@ -# -*- encoding: utf-8 -*- -############################################################################## -# -# OpenERP, Open Source Management Solution -# Copyright (C) 2004-2008 Tiny SPRL (). All Rights Reserved -# AvanzOSC, Avanzed Open Source Consulting -# Copyright (C) 2011-2012 Iker Coranti (www.avanzosc.com). All Rights Reserved -# $Id$ -# -# 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 . -# -############################################################################## -from osv import osv, fields -import wizard -import pooler -from tools.misc import UpdateableStr -import time - - -class wizard_line_list(osv.osv_memory): - _name = 'wizard.line.list' - - _columns={ - 'entries':fields.many2many('account.move.line','rel_move_lines','payment_id','line_id','Entries'), - 'communication2':fields.char ('Communication 2',size = 64, help ='The successor message of payment communication.'), - } - - def create_payment(self, cr, uid, ids, context): - ########################################################### - # OBJETOS - ########################################################### - order_obj = self.pool.get('payment.order') - line_obj = self.pool.get('account.move.line') - payment_line_obj = self.pool.get('payment.line') - currency_obj = self.pool.get('res.currency') - ########################################################### - line_ids =[] - if not isinstance(ids,list): - ids=[ids] - line_ids_o= self.browse(cr,uid,ids[0]).entries - for line_o in line_ids_o: - line_ids.append(line_o.id) - if not line_ids: return {} - - pool= pooler.get_pool(cr.dbname) - order_id = context['payment_order'] - payment = order_obj.browse(cr, uid, order_id,context=context) - t = payment.mode and payment.mode.type.id or None - line2bank = line_obj.line2bank(cr, uid, line_ids, t, context) - - ## Finally populate the current payment with new lines: - for line in line_obj.browse(cr, uid, line_ids, context=context): - if payment.date_prefered == "now": - #no payment date => immediate payment - date_to_pay = False - elif payment.date_prefered == 'due': - date_to_pay = line.date_maturity - elif payment.date_prefered == 'fixed': - date_to_pay = payment.date_scheduled - - if payment.type == 'payable': - amount_to_pay = line.amount_to_pay - else: - amount_to_pay = -line.amount_to_pay - val ={ - 'move_line_id': line.id, - 'amount_currency': amount_to_pay, - 'bank_id': line2bank.get(line.id), - 'order_id': payment.id, - 'partner_id': line.partner_id and line.partner_id.id or False, - 'communication': (line.ref and line.name!='/' and line.ref+'. '+line.name) or line.ref or line.name or '/', - 'communication2': self.browse(cr,uid,ids[0]).communication2, - 'date': date_to_pay, - 'currency':currency_obj.search(cr,uid,[])[0], - 'account_id': line.account_id.id, - 'type':payment.type, - - } - if line.invoice: - if line.invoice.currency_id: - val.update({ 'currency':line.invoice.currency_id.id}) - payment_line_obj.create(cr,uid,val, context=context) - return {'type': 'ir.actions.act_window_close'} - - def cerrar(self, cr, uid, ids, context): - return {'type': 'ir.actions.act_window_close'} - -wizard_line_list() -class wizard_payment_order(osv.osv_memory): - """ - Create a payment object with lines corresponding to the account move line - to pay according to the date provided by the user and the mode-type payment of the order. - Hypothesis: - - Small number of non-reconcilied move line , payment mode and bank account type, - - Big number of partner and bank account. - - If a type is given, unsuitable account move lines are ignored. - """ - _name = 'wizard.payment.order' - _description = 'Para crear nominas' - - _columns={ - 'duedate': fields.date ('Due Date',required = True), - 'amount':fields.float ('Amount', help ='Next step will automatically select payments up to this amount as long as account moves have bank account if that is required by the selected payment mode.'), - 'show_refunds':fields.boolean('Show Refunds', help = 'Indicates if search should include refunds.'), - } - - _defaults={ - 'duedate':lambda *a: time.strftime('%Y-%m-%d'), - 'show_refunds': lambda *a: False - - } - - -############################################################################################# - - def search_entries(self, cr, uid, ids, context): - - ###################################################### - # OBJETOS - ###################################################### - pool = pooler.get_pool(cr.dbname) - order_obj = self.pool.get('payment.order') - line_obj = self.pool.get('account.move.line') - ###################################################### - - #search_due_date = data['form']['duedate'] - #show_refunds = data['form']['show_refunds'] - - search_due_date = self.browse(cr, uid, ids[0], context).duedate - show_refunds = self.browse(cr, uid, ids[0], context).show_refunds - - payment = order_obj.browse(cr, uid, context.get('active_id'), context=context) - ctx = '' - if payment.mode: - ctx = '''context="{'journal_id': %d}"''' % payment.mode.journal.id - - # Search for move line to pay: - domain = [('reconcile_id', '=', False),('account_id.type', '=', payment.type),('amount_to_pay', '<>', 0)] - - if payment.type =='payable' and not show_refunds: - domain += [ ('credit','>',0) ] - - elif not show_refunds: - domain += [ ('debit','>',0) ] - - if payment.mode: - domain += [ ('payment_type','=',payment.mode.type.id) ] - - domain += ['|',('date_maturity','<',search_due_date),('date_maturity','=',False)] - line_ids = line_obj.search(cr, uid, domain, order='date_maturity', context=context) - - - # FORM.string = ''' - #
- # - # - # - #''' % (','.join([str(x) for x in line_ids]), ctx) - - selected_ids = [] - - - # if payment.mode.require_bank_account and not line.partner_bank_id: - # continue - # if payment.mode.require_same_bank_account: - # if not line.partner_bank_id: - # continue - # mode_account = payment.mode.bank_id.acc_number or payment.mode.bank_id.iban - # line_account = line.partner_bank_id.acc_number or line.partner_bank_id.iban - # if mode_account != line_account: - # continue - # if payment.mode.require_received_check: - # if not line.received_check: - # continue - - #amount = data['form']['amount'] - amount = self.browse(cr, uid, ids[0], context).amount - if amount: - if payment.mode and payment.mode.require_bank_account: - line2bank = line_obj.line2bank(cr, uid, line_ids, payment.mode.id, context) - else: - line2bank = None - # If user specified an amount, search what moves match the criteria taking into account - # if payment mode allows bank account to be null. - for line in line_obj.browse(cr, uid, line_ids, context): - if abs(line.amount_to_pay) <= amount: - amount -= abs(line.amount_to_pay) - selected_ids.append( line.id ) - - - wiz_id = self.pool.get('wizard.line.list').create(cr,uid,{'entries':[(6,0,selected_ids)]}) - context.update({'payment_order':payment.id}) - mod_obj = self.pool.get('ir.model.data') - form_res1 = mod_obj.get_object_reference(cr, uid, 'account_payment_extension', 'wizard_line_list_py_form_view') - form_id1 = form_res1 and form_res1[1] or False - form_res2 = mod_obj.get_object_reference(cr, uid, 'account_payment_extension', 'wizard_line_list_re_form_view') - form_id2 = form_res2 and form_res2[1] or False - if payment.type == 'payable': - wizard = { - 'type': 'ir.actions.act_window', - 'res_model': 'wizard.line.list', - 'view_type': 'form', - 'view_mode': 'form', - 'views': [(form_id1, 'form')], - 'res_id':wiz_id, - 'target': 'new', - 'context': context - } - else: - wizard = { - 'type': 'ir.actions.act_window', - 'res_model': 'wizard.line.list', - 'view_type': 'form', - 'view_mode': 'form', - 'views': [(form_id2, 'form')], - 'res_id':wiz_id, - 'target': 'new', - 'context': context - } - return wizard - - - def cerrar(self, cr, uid, ids, context): - return {'type': 'ir.actions.act_window_close'} - -wizard_payment_order() - -# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4: === removed file 'account_payment_extension/wizard/wizard_payment_order_view.xml' --- account_payment_extension/wizard/wizard_payment_order_view.xml 2012-12-11 10:06:23 +0000 +++ account_payment_extension/wizard/wizard_payment_order_view.xml 1970-01-01 00:00:00 +0000 @@ -1,93 +0,0 @@ - - - - - - - - - wizard.payment.order.form.view - wizard.payment.order - form - -
- - - - - - -