Merge lp:~s-momin-serpentcs/account-fstr/account-fstr into lp:account-fstr/6.0

[Serpent Consulting Services]

[lp:~s-momin-serpentcs/account-fstr/account-fstr]

2. By sirajahmad on 2013-04-02

[IMP] account_fstr: Added a state field in form view, added a constraints on parent_node field

Unmerged revisions

2. By sirajahmad on 2013-04-02

[IMP] account_fstr: Added a state field in form view, added a constraints on parent_node field

1. By sirajahmad on 2013-03-13

[mod]modify module account_fstr from 6.1 to 7.0

=== added directory 'account_fstr'
=== renamed directory 'account_fstr' => 'account_fstr.moved'
=== added file 'account_fstr/__init__.py'
--- account_fstr/__init__.py	1970-01-01 00:00:00 +0000
+++ account_fstr/__init__.py	2013-04-02 11:54:22 +0000
@@ -0,0 +1,26 @@
+# -*- encoding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    Copyright (C)
+#    2010 Colin MacMillan - Publicus Solutions Ltd.
+#    All Rights Reserved
+#
+#    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_fstr_category
+import wizard
+import reports
+import account_account
 
=== added file 'account_fstr/__openerp__.py'
--- account_fstr/__openerp__.py	1970-01-01 00:00:00 +0000
+++ account_fstr/__openerp__.py	2013-04-02 11:54:22 +0000
@@ -0,0 +1,49 @@
+# -*- encoding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    Copyright (C)
+#    2011 Colin MacMillan - Enapps Ltd.
+#    All Rights Reserved
+#
+#    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/>.
+#
+##############################################################################
+
+{
+    'name' : 'Financial Statement Template reporting module',
+    'version' : '1.1',
+    'depends' : ['base', 'account'],
+    'author' : 'Enapps Ltd.',
+    'description': '''This module provides functionality to create customised financial statements.  Examples of a financial statement would be a trial balance, balance sheet, profit and loss, etc.  Any report that is produced by organising sets of accounts can be created using this module.
+
+User documentation can be found here - www.publicus-solutions.com/blog/post1
+
+Compatible with OpenERP v. 6.0,6.1 and 7.0
+
+''',
+    'website' : 'http://www.enapps.co.uk/',
+    "category": 'Accounting & Finance',
+    'demo' : [],
+    'data' :  [
+        'security/ir.model.access.csv',
+        'account_fstr_wizard_view.xml',
+        'account_fstr_view.xml',
+        'account_fstr_menu.xml',
+        'account_account_view.xml',
+    ],
+    'active': False,
+    'installable': True,
+    'images': ['images/fstr_form.png',],
+}
 
=== added file 'account_fstr/account_account.py'
--- account_fstr/account_account.py	1970-01-01 00:00:00 +0000
+++ account_fstr/account_account.py	2013-04-02 11:54:22 +0000
@@ -0,0 +1,63 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    Copyright (C) 2011 Enapps LTD (<http://www.enapps.co.uk>).
+#
+#    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 openerp.osv import fields, osv
+from openerp.tools.translate import _
+from openerp import netsvc
+import time
+from openerp.addons.decimal_precision import decimal_precision as dp
+
+class account_account(osv.osv):
+    _name = "account.account"
+    _inherit = "account.account"
+
+    _columns = {
+        'category_ids': fields.many2many('account_fstr.category', 'account_fstr_category_account', 'category_id', 'account_id', 'Categories'),
+    }
+
+    def test_category_list(self, cr, uid, ids, category_ids, context={}):
+        category_ids = category_ids[0][2]
+        warning = {}
+        warning_category_names = []
+        category_pool = self.pool.get('account_fstr.category')
+        for account in self.browse(cr, uid, ids, context=context):
+            progenitors = [ctgry.progenitor_id.id for ctgry in account.category_ids]
+            current_category_ids = [ctgry.id for ctgry in account.category_ids]
+            new_categories = list(set(category_ids) - set(current_category_ids))
+            new_categories_objs = category_pool.browse(cr, uid, new_categories, context=context)
+            if len(new_categories_objs) > len(set([ctgry.progenitor_id.id for ctgry in new_categories_objs])):
+                warning.update({
+                    'title': 'Alert',
+                    'message': "You cant add one account to more than one category within the same repoting template",
+                })
+                return {'value': {'category_ids': current_category_ids}, 'warning': warning}
+            for category in new_categories_objs:
+                if category.progenitor_id.id in progenitors:
+                    warning_category_names.append("%s / %s " % (category.progenitor_id.name, category.name))
+                    category_ids.remove(category.id)
+        if warning_category_names:
+            warning.update({
+                'title': 'Alert',
+                'message': "Categories %s already exist for current account" % (", ".join(warning_category_names)),
+            })
+        return {'value': {'category_ids': category_ids}, 'warning': warning}
+
+account_account()
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
 
=== added file 'account_fstr/account_account_view.xml'
--- account_fstr/account_account_view.xml	1970-01-01 00:00:00 +0000
+++ account_fstr/account_account_view.xml	2013-04-02 11:54:22 +0000
@@ -0,0 +1,23 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+	<data>
+
+		<record id="view_account_form" model="ir.ui.view">
+			<field name="name">account.account.form</field>
+			<field name="model">account.account</field>
+			<field name="inherit_id" ref="account.view_account_form" />
+			<field name="arch" type="xml">
+				<xpath expr='//group[@groups="base.group_multi_currency"]'
+					position="after">
+					<group>
+						<field name="category_ids" colspan="6" nolabel="1"
+							domain="[('state', '=', 'normal')]" attrs="{'invisible': [('type', '=', 'view')]}"
+							on_change="test_category_list(category_ids)" />
+					</group>
+
+				</xpath>
+			</field>
+		</record>
+
+	</data>
+</openerp>
 
=== added file 'account_fstr/account_fstr_category.py'
--- account_fstr/account_fstr_category.py	1970-01-01 00:00:00 +0000
+++ account_fstr/account_fstr_category.py	2013-04-02 11:54:22 +0000
@@ -0,0 +1,178 @@
+# -*- encoding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    Copyright (C)
+#    2010 Colin MacMillan - Enapps Ltd.
+#    All Rights Reserved
+#
+#    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 openerp.osv import fields, osv
+from openerp.addons.decimal_precision import decimal_precision as dp
+from wizard import account_fstr_wizard
+from openerp.tools.translate import _
+
+class account_fstr_category(osv.osv):
+    _name = "account_fstr.category"
+    _description = "Financial Statement template category"
+    _order = "sequence, id"
+
+
+    def __compute(self, cr, uid, ids, field_names, arg=None, context=None,
+                  query='', query_params=()):
+        res = {}
+        for category_obj in  self.browse(cr, uid, ids, context=context):
+            res.update({category_obj.id: self.__compute_balance_for_caregory(cr, uid, category_obj, context=context)})
+        return res
+
+    def __compute_balance_for_caregory(self, cr, uid, category_obj, context={}):
+        result = 0
+        if category_obj.state == 'normal':
+            for account_obj in category_obj.account_ids:
+                result += account_obj.balance
+        else:
+            for child_category_obj in category_obj.child_id:
+                result += self.__compute_balance_for_caregory(cr, uid, child_category_obj, context=context)
+        return result
+
+    def _get_progenitor_id(self, cr, uid, ids, field_names, arg=None, context={}):
+        res = {}
+        for category_obj in self.browse(cr, uid, ids, context=context):
+            res.update({category_obj.id: self._get_progenitor_id_in_recurse(cr, uid, category_obj, context=context) })
+        return res
+
+    def _get_progenitor_id_in_recurse(self, cr, uid, category_obj, context={}):
+        result = None
+        if not (category_obj.parent_id and category_obj.parent_id.id):
+            result = category_obj.id
+        else:
+            result = self._get_progenitor_id_in_recurse(cr, uid, category_obj.parent_id, context=context)
+        return result
+
+    def _get_childs(self, cr, uid, ids, context={}):
+        return self.search(cr, uid, [('id', 'child_of', ids)], context=context)
+
+    _columns = {
+        'name': fields.char('Category Title name', size=32, required=True, select=True),
+        'digits_round': fields.integer('Digits round', required=True),
+        'company_id': fields.many2one('res.company', 'Company', ondelete='set null'),
+        'name_end': fields.char('Category End/Total name', size=128,),
+        'display_total': fields.boolean('Display End/Total'),
+        'parent_id': fields.many2one('account_fstr.category', 'Parent node', ondelete='cascade', select=True),
+        'sequence': fields.integer('Sequence'),
+        'consolidate_total': fields.boolean('Consolidate total', help="Selecting Consolidate total will print this category total as a single summed figure and will not list out each individual account"),
+        'display_heading': fields.boolean('Display title'),
+        'bold_title': fields.boolean('Bold'),
+        'italic_title': fields.boolean('Italic'),
+        'underline_title': fields.boolean('Unnderline'),
+        'bold_end': fields.boolean('Bold'),
+        'italic_end': fields.boolean('Italic'),
+        'underline_end': fields.boolean('Unnderline'),
+        'inversed_sign': fields.boolean('Inversed sign'),
+        'child_id': fields.one2many('account_fstr.category', 'parent_id', 'Consolidated Children', select=True),
+        'account_ids': fields.many2many('account.account', 'account_fstr_category_account', 'account_id', 'category_id', 'Accounts', select=True),
+        'indent_title': fields.integer('Indent Title, (pt)'),
+        'indent_end': fields.integer('Indent End, (pt)'),
+        'top_spacing_title': fields.integer('Top spacing Title, (pt)'),
+        'top_spacing_end': fields.integer('Top spacing End, (pt)'),
+        'bottom_spacing_title': fields.integer('Bottom spacing Title, (pt)'),
+        'bottom_spacing_end': fields.integer('Bottom spacing End, (pt)'),
+        'state': fields.selection([('view','View'),('root','Root'),('normal','Normal')], 'Type', select=True,),
+        'balance': fields.function(__compute, digits_compute=dp.get_precision('Account'), method=True, string='Balance', store=False, type='float'),
+        'printable': fields.boolean('Printable', help="Select to allow category to display in print list"),
+        'progenitor_id': fields.function(_get_progenitor_id, method=True,
+                                         string='Root', type='many2one',
+                                         obj='account_fstr.category',
+                                         store={ 'account_fstr.category': (_get_childs, ['parent_id'], 1)}, select=True),
+
+
+    }
+
+    _defaults = {
+        'state': 'normal',
+        'indent_title': 10,
+        'indent_end': 10,
+        'top_spacing_title': 0,
+        'digits_round': 0,
+    }
+    
+    def _check_recursion(self, cr, uid, ids, context=None):
+        level = 100
+        while len(ids):
+            cr.execute('select distinct parent_id from account_fstr_category where id IN %s',(tuple(ids),))
+            ids = filter(None, map(lambda x:x[0], cr.fetchall()))
+            if not level:
+                return False
+            level -= 1
+        return True
+    
+    _constraints = [
+        (_check_recursion, 'Error ! You cannot create recursive.', ['parent_id']),
+    ]
+    
+    def print_template(self, cr, uid, ids, context={}):
+        return account_fstr_wizard.account_fstr_wizard.print_template(cr, uid, ids, context={})
+
+
+    def _get_selected_accounts(self, cr, uid, progenitor_id, current_category_id, context={}):
+        result = []
+        category_ids = self.search(cr, uid, [('progenitor_id', '=', progenitor_id)], context=context)
+        for category_obj in self.browse(cr, uid, category_ids, context=context):
+            if category_obj.id != current_category_id:
+                result.extend([category.id for category in category_obj.account_ids])
+        return result
+
+    def test_account_list(self, cr, uid, ids, progenitor_id, account_ids):
+        warning = {}
+        warning_account_names = []
+        current_account_ids = []
+        all_account_ids_for_template = self._get_selected_accounts(cr, uid,
+                                                                   progenitor_id,
+                                                                   ids)
+        updated_account_ids = account_ids[0][2]
+        for account_obj in self.pool.get('account.account').browse(cr, uid, updated_account_ids):
+            if not (account_obj.id in all_account_ids_for_template):
+                current_account_ids.append(account_obj.id)
+            else:
+                warning_account_names.append(account_obj.name)
+        if warning_account_names:
+            warning.update({
+                'title': 'Alert',
+                'message': "Accounts %s already exist in current template" % (", ".join(warning_account_names)),
+            })
+        return {'value': {'account_ids': current_account_ids,}, 'warning': warning}
+
+    def view_exception_accounts(self, cr, uid, ids, context={}):
+        account_list = self._get_selected_accounts(cr, uid, ids[0], ids, context=context)
+        model_data_pool = self.pool.get('ir.model.data')
+        model_data_ids = model_data_pool.search(cr, uid,[('model','=','ir.ui.view'),('name','=','view_account_list')], context=context)
+        resource_id = model_data_pool.read(cr, uid, model_data_ids, fields=['res_id'], context=context)[0]['res_id']
+        return {
+            'name': "Exception Accounts",
+            'view_mode': 'form',
+            'view_type': 'form',
+            'views': [(resource_id, 'tree'),],
+            'res_model': 'account.account',
+            'type': 'ir.actions.act_window',
+            'nodestroy': True,
+            'domain': [('type', '!=', 'view'), ('id', 'not in', account_list)]
+        }
+
+
+account_fstr_category()
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
 
=== added file 'account_fstr/account_fstr_menu.xml'
--- account_fstr/account_fstr_menu.xml	1970-01-01 00:00:00 +0000
+++ account_fstr/account_fstr_menu.xml	2013-04-02 11:54:22 +0000
@@ -0,0 +1,31 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+    <data>
+
+        <menuitem icon="terp-stock_format-default"
+            id="parent_menu_account_fstr"
+            name="Financial Statement template reporting"
+            parent="account.menu_finance" 
+            sequence="10"/>
+
+        <menuitem action="action_account_fstr_category_form"
+            id="menu_account_fstr_category_form"
+            icon="STOCK_PREFERENCES"
+            name="Financial Statement categories form"
+            parent="parent_menu_account_fstr" />
+
+        <menuitem action="action_account_fstr_category_tree"
+            id="menu_account_fstr_category_tree"
+            icon="STOCK_PREFERENCES"
+            name="Financial Statement categories tree"
+            parent="parent_menu_account_fstr" />
+
+        <menuitem action="action_account_fstr_wizard"
+            id="menu_account_fstr_wizard_form"
+            icon="STOCK_PRINT"
+            name="Print/Preview financial statements"
+            parent="parent_menu_account_fstr" />
+
+    </data>
+</openerp>
+
 
=== added file 'account_fstr/account_fstr_report.xml'
--- account_fstr/account_fstr_report.xml	1970-01-01 00:00:00 +0000
+++ account_fstr/account_fstr_report.xml	2013-04-02 11:54:22 +0000
@@ -0,0 +1,15 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+    <data>
+        <report
+            id="report_account_fstr"
+            string="Aged reval report"
+            model="account_fstr.category"
+            name="account_fstr.report"
+            rml="account_fstr/reports/account_fstr_report.rml"
+            header="True"
+            multi="True"
+            /> 
+
+    </data>
+</openerp>
 
=== added file 'account_fstr/account_fstr_view.xml'
--- account_fstr/account_fstr_view.xml	1970-01-01 00:00:00 +0000
+++ account_fstr/account_fstr_view.xml	2013-04-02 11:54:22 +0000
@@ -0,0 +1,154 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+	<data>
+
+		<!--Category -->
+
+		<record id="view_account_fstr_category_search" model="ir.ui.view">
+			<field name="name">view.account_fstr.category.search</field>
+			<field name="model">account_fstr.category</field>
+			<field name="arch" type="xml">
+				<search string="Search Categories">
+					<group col="10" colspan="4">
+						<field name="name" />
+						<field name="parent_id" />
+						<field name="progenitor_id" select="1" />
+					</group>
+					<group expand="1" string="Group By...">
+						<filter string="Parent" name="fparent" icon="terp-personal"
+							domain="[]" context="{'group_by':'parent_id'}" />
+						<filter string="Temlate" name="ftemplate" icon="terp-personal"
+							domain="[]" context="{'group_by':'progenitor_id'}" />
+					</group>
+				</search>
+			</field>
+		</record>
+
+		<record id="view_account_fstr_category_form" model="ir.ui.view">
+			<field name="name">account_fstr.category.form</field>
+			<field name="model">account_fstr.category</field>
+			<field name="arch" type="xml">
+				<form string="Financial Statement category" version="7.0">
+					<header>
+						<!--<field name="state" widget="statusbar" nolabel="1"
+							statusbar_visible="view,root,normal"
+							statusbar_colors="{&quot;proforma&quot;:&quot;blue&quot;,&quot;proforma2&quot;:&quot;blue&quot;}" /> -->
+						<button icon="gtk-print" string="Print/Preview"
+							name="%(action_account_fstr_wizard)d" type="action" states="normal" />
+						<button icon="gtk-find" string="Exception accounts" name="view_exception_accounts"
+							type="object" states="normal" />
+					</header>
+					<sheet>
+						<notebook>
+							<page string="Configurations">
+								<label string="Category Title name" />
+								<field name="name" colspan="2" style="width: 30em" />
+								<group colspan="2" col="4">
+									<group string="Category Title" colspan="1" col="2">
+										<field name="display_heading" />
+										<field name="bold_title" />
+										<field name="italic_title" />
+										<field name="underline_title" />
+									</group>
+									<group string="Spacing" colspan="1" col="2">
+										<field name="indent_title" />
+										<field name="top_spacing_title" />
+										<field name="bottom_spacing_title" />
+									</group>
+								</group>
+								<label string="Category End/Total name" />
+								<field name="name_end" colspan="2" style="width: 30em" />
+								<group colspan="2" col="4">
+									<group string="Category End/Total" colspan="1" col="2">
+										<field name="display_total" />
+										<field name="bold_end" />
+										<field name="italic_end" />
+										<field name="underline_end" />
+										<field name="consolidate_total" />
+									</group>
+									<group string="Spacing" colspan="1" col="2">
+										<field name="indent_end" />
+										<field name="top_spacing_end" />
+										<field name="bottom_spacing_end" />
+									</group>
+								</group>
+								<separator string="Settings" colspan="4" />
+								<group>
+									<field name="company_id" style="width: 30em" />
+									<field name="parent_id" style="width: 30em" />
+									<field name="state" style="width: 30em" />
+								</group>
+								<group>
+									<field name="progenitor_id" colspan="2" invisible="True" />
+									<field name="digits_round" colspan="2" style="width: 30em" />
+									<field name="sequence" style="width: 10em" />
+									<field name="inversed_sign" colspan="1" />
+								</group>
+								<group colspan="2" string="Print Options">
+									<field name="printable" />
+								</group>
+							</page>
+							<page string="Accounts">
+								<separator colspan="4" />
+								<field name="account_ids" colspan="4"
+									attrs="{'invisible':[('state','!=','normal')]}" domain="[('type', '!=', 'view')]"
+									on_change="test_account_list(progenitor_id, account_ids)"
+									nolabel="1" />
+							</page>
+						</notebook>
+					</sheet>
+				</form>
+			</field>
+		</record>
+
+		<record id="view_account_fstr_category_tree" model="ir.ui.view">
+			<field name="name">account_fstr.category.tree</field>
+			<field name="model">account_fstr.category</field>
+			<field name="field_parent">child_id</field>
+			<field name="arch" type="xml">
+				<tree colors="ForestGreen:state=='root';blue:state=='view'"
+					string="Financial Statement category">
+					<field name="name" select="1" />
+					<field name="company_id" />
+					<field name="name_end" />
+					<field name="balance" />
+					<field name="display_total" />
+					<field name="progenitor_id" select="1" />
+					<field name="parent_id" select="1" />
+					<field name="digits_round" select="1" />
+					<field name="sequence" />
+					<field name="indent_title" />
+					<field name="top_spacing_title" />
+					<field name="consolidate_total" />
+					<field name="display_heading" />
+					<field name="bold_title" />
+					<field name="italic_title" colspan="1" />
+					<field name="underline_title" colspan="1" />
+					<field name="inversed_sign" />
+					<field name="state" />
+					<field name="account_ids" />
+				</tree>
+			</field>
+		</record>
+
+		<record id="action_account_fstr_category_tree" model="ir.actions.act_window">
+			<field name="name">Financial Statement category</field>
+			<field name="type">ir.actions.act_window</field>
+			<field name="res_model">account_fstr.category</field>
+			<field name="view_mode">tree</field>
+			<field name="view_type">tree</field>
+			<field name="view_id" ref="view_account_fstr_category_tree" />
+			<field name="domain">[('parent_id','=',False)]</field>
+		</record>
+
+		<record id="action_account_fstr_category_form" model="ir.actions.act_window">
+			<field name="name">Financial Statement category</field>
+			<field name="type">ir.actions.act_window</field>
+			<field name="res_model">account_fstr.category</field>
+			<field name="view_mode">tree,form</field>
+			<field name="view_type">form</field>
+			<field name="view_id" ref="view_account_fstr_category_tree" />
+			<field name="search_view_id" ref="view_account_fstr_category_search" />
+		</record>
+	</data>
+</openerp>
 
=== added file 'account_fstr/account_fstr_wizard_view.xml'
--- account_fstr/account_fstr_wizard_view.xml	1970-01-01 00:00:00 +0000
+++ account_fstr/account_fstr_wizard_view.xml	2013-04-02 11:54:22 +0000
@@ -0,0 +1,42 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+    <data>
+        <record id="view_account_fstr_wizard_form" model="ir.ui.view">
+            <field name="name">account_fstr.wizard.form</field>
+            <field name="model">account_fstr.wizard</field>
+            <field name="arch" type="xml">
+                <form string="Account charts">
+                    <group colspan="4">
+                        <field name="fiscalyear" on_change="onchange_fiscalyear(fiscalyear)" widget="selection"/>
+                        <field name="target_move"/>
+                        <label align="0.7" colspan="4" string="(If you do not select Fiscal year it will take all open fiscal years)"/>
+                        <separator string="Periods" colspan="4"/>
+                        <field name="period_from" widget="selection"/>
+                        <field name="period_to" widget="selection"/>
+                        <separator colspan="4"/>
+                        <field name="root_node" domain="[('printable','=','1')]"/>
+                        <field name="hide_zero"/>
+                    </group>
+                    <separator string="" colspan="4"/>
+                    <group colspan="4" col="6">
+                        <button icon="gtk-cancel" special="cancel" string="Cancel"/>
+                        <button icon="terp-gtk-go-back-rtl" string="Preview" name="open_window" type="object"/>
+                        <button icon="gtk-print" string="Print" name="print_template" type="object"/>
+                    </group>
+                </form>
+            </field>
+        </record>
+
+        <record id="action_account_fstr_wizard" model="ir.actions.act_window">
+            <field name="name">Temlate Print/Preview</field>
+            <field name="view_id" ref="view_account_fstr_wizard_form"/>
+            <field name="view_type">form</field>
+            <field name="view_mode">form</field>
+            <field name="res_model">account_fstr.wizard</field>
+            <field name="target">new</field>
+        </record>
+
+        <report id="account_fstr_report" string="Print Template" model="account_fstr.category" name="account_fstr.report" rml="account_fstr/reports/account_fstr_report.rml"/>
+
+    </data>
+</openerp>
 
=== added directory 'account_fstr/images'
=== added file 'account_fstr/images/fstr_form.png'
 Binary files account_fstr/images/fstr_form.png	1970-01-01 00:00:00 +0000 and account_fstr/images/fstr_form.png	2013-04-02 11:54:22 +0000 differ
=== added directory 'account_fstr/reports'
=== added file 'account_fstr/reports/__init__.py'
--- account_fstr/reports/__init__.py	1970-01-01 00:00:00 +0000
+++ account_fstr/reports/__init__.py	2013-04-02 11:54:22 +0000
@@ -0,0 +1,20 @@
+##############################################################################
+#
+#    Copyright (C) 2011 Enapps LTD (<http://www.enapps.co.uk>).
+#    All Rights Reserved
+#
+#    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_fstr_report
 
=== added file 'account_fstr/reports/account_fstr_report.py'
--- account_fstr/reports/account_fstr_report.py	1970-01-01 00:00:00 +0000
+++ account_fstr/reports/account_fstr_report.py	2013-04-02 11:54:22 +0000
@@ -0,0 +1,171 @@
+# -*- encoding: utf-8 -*-
+##############################################################################
+#
+#    Copyright (C) 2011 Enapps LTD (<http://www.enapps.co.uk>).
+#    All Rights Reserved
+#
+#    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.report import report_sxw
+from openerp import pooler
+from account.report.common_report_header import common_report_header
+from sm_kit import groupe_digits
+
+
+class account_fstr_report(report_sxw.rml_parse, common_report_header):
+
+    _name = 'account_fstr.category.report'
+
+    date_end = None
+    root_node_obj = None
+
+    def __init__(self, cr, uid, name, context):
+        super(account_fstr_report, self).__init__(cr, uid, name, context)
+        category_id = context.get('active_id')
+        if context.get('active_model') == 'account_fstr.wizard':
+            category_id = context.get('account_fstr_root_node')[0]
+        self.root_node_obj = pooler.get_pool(cr.dbname).get('account_fstr.category').browse(cr, uid, category_id, context=context)
+        self.category_pool = pooler.get_pool(cr.dbname).get('account_fstr.category')
+        ids = context['active_ids']
+        self.localcontext.update({
+            'time': time,
+            'template_data':  self._get_template_data(cr, uid, ids, [], self.root_node_obj, context=context),
+            'date_end': '',
+            'digits_round': '0' * (self.root_node_obj.digits_round - 2)
+        })
+
+    def _get_root_id(self):
+        if self.root_node_obj:
+            return self.root_node_obj
+        else:
+            return None
+
+    def _get_template_data(self, cr, uid, ids, statements, category_id, context={}):
+        category_obj = self.category_pool.browse(cr, uid, category_id, context=context)
+        name = category_obj.name
+        result = [self._get_statement(cr, uid, ids, [], self._get_root_id(), -1, context=context), self._get_root_id().balance]
+        result = self._digits_rounding(cr, uid, ids, result, context=context)
+        return {
+            'name': name,
+            'statements': result,
+            'lang': context['lang'],
+        }
+    def _digits_rounding(self, cr, uid, ids, statements, context={}):
+        digits_round = self.root_node_obj.digits_round
+        statements[1] = self._account_round(statements[1], digits_round)
+        for statement_id in range(len(statements[0])):
+            statements[0][statement_id]['total_amount'] = self._account_round(statements[0][statement_id]['total_amount'], digits_round)
+        return statements
+
+    def _account_round(self, number, digits_round):
+        if number == ' ':
+            return number
+        if number == None:
+            return ' '
+        number = (round(float(number), 2 - digits_round))
+        if digits_round <= 2:
+            format_string = "%%.%if" % (2 - digits_round,)
+        elif digits_round > 2:
+            number = int(number / (10 ** (digits_round - 2)))
+            format_string = "%i"
+        result = groupe_digits(format_string % number)
+        if result == "-0":
+            result = "0"
+        return result
+
+    def _get_statement(self, cr, uid, ids, statements_list, category_obj, parent_indent, context={}):
+        indent = category_obj.indent_title + parent_indent
+        font_name_title = 'Helvetica'
+        font_name_end = 'Helvetica'
+
+        # Category Name - bold/italic
+        if category_obj.bold_title or category_obj.italic_title:
+            font_name_title += '-'
+        if category_obj.bold_title:
+            font_name_title += 'Bold'
+        if category_obj.italic_title:
+            font_name_title += 'Oblique'
+
+        # Category End Name - bold/italic
+        if category_obj.bold_end or category_obj.italic_end:
+            font_name_end += '-'
+        if category_obj.bold_end:
+            font_name_end += 'Bold'
+        if category_obj.italic_end:
+            font_name_end += 'Oblique'
+
+        total_amount = 0
+        internal_statements = []
+        
+        if category_obj.state == 'normal':
+            for account_statement_obj in category_obj.account_ids:
+                account_total_amount = account_statement_obj.balance
+
+                # skip iterations where amount = 0 and hide_zero box ticked
+                if 'hide_zero' in context:
+                    hide_zero = int(context['hide_zero'])
+                    if hide_zero == 1 and account_total_amount == 0.0:
+                        continue
+
+                if category_obj.inversed_sign:
+                    account_total_amount = -account_total_amount
+                internal_statements.append({
+                    'name': "%s\t%s" % (account_statement_obj.code, account_statement_obj.name,),
+                    'indent': indent + 10,
+                    'top_spacing': None,
+                    'bottom_spacing': None,
+                    'font_name': 'Helvetica',
+                    'underline': False,
+                    'total_amount': account_total_amount,
+                })
+                total_amount += account_total_amount
+            internal_statements = sorted(internal_statements, key=lambda statement: statement['name'])
+
+        elif category_obj.state != 'normal':
+            for child_category in sorted(category_obj.child_id, key=lambda child_obj: child_obj.sequence):
+                internal_statements = self._get_statement(cr, uid, ids, internal_statements, child_category, indent, context=context)
+            total_amount = category_obj.balance
+            if category_obj.inversed_sign:
+                total_amount = -total_amount
+        # Categroy Title
+        if category_obj.display_heading:
+            statements_list.append({
+                'name': category_obj.name,
+                'indent': category_obj.indent_title + category_obj.top_spacing_title,
+                'top_spacing': category_obj.top_spacing_title,
+                'bottom_spacing': category_obj.bottom_spacing_title,
+                'font_name': font_name_title,
+                'underline': category_obj.underline_title,
+                'total_amount': total_amount if category_obj.consolidate_total else ' ',
+            })
+        if not category_obj.consolidate_total:
+            statements_list.extend(internal_statements)
+        # Category End Name
+        if category_obj.display_total:
+            statements_list.append({
+                'name': category_obj.name_end,
+                'indent': category_obj.indent_end,
+                'top_spacing': category_obj.top_spacing_end,
+                'bottom_spacing': category_obj.bottom_spacing_end,
+                'font_name': font_name_end,
+                'underline': category_obj.underline_end,
+                'total_amount': total_amount,
+            })
+        return statements_list
+
+report_sxw.report_sxw('report.account_fstr.report', 'account_fstr.category',
+                      'addons/account_fstr/reports/account_fstr_report.rml', parser=account_fstr_report, header="True")
 
=== added file 'account_fstr/reports/account_fstr_report.rml'
--- account_fstr/reports/account_fstr_report.rml	1970-01-01 00:00:00 +0000
+++ account_fstr/reports/account_fstr_report.rml	2013-04-02 11:54:22 +0000
@@ -0,0 +1,134 @@
+<?xml version="1.0"?>
+<document filename="test.pdf">
+  <template pageSize="(595.0,842.0)" title="Account Statements report" author="Publicus Solutions Ltd." allowSplitting="20">
+    <pageTemplate id="first">
+      <frame id="first" x1="42.0" y1="42.0" width="511" height="758"/>
+    </pageTemplate>
+  </template>
+  <stylesheet>
+    <blockTableStyle id="Standard_Outline">
+      <blockAlignment value="LEFT"/>
+      <blockValign value="TOP"/>
+    </blockTableStyle>
+    <blockTableStyle id="Table7">
+      <blockAlignment value="LEFT"/>
+      <blockValign value="TOP"/>
+      <lineStyle kind="LINEBEFORE" colorName="#000000" start="0,0" stop="0,-1"/>
+      <lineStyle kind="LINEAFTER" colorName="#000000" start="0,0" stop="0,-1"/>
+      <lineStyle kind="LINEAFTER" colorName="#000000" start="-1,0" stop="-1,-1"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="0,0" stop="-1,0"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="0,-1" stop="0,-1"/>
+      <lineStyle kind="LINEBEFORE" colorName="#000000" start="0,1" stop="0,-1"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="0,-1" stop="0,-1"/>
+      <lineStyle kind="LINEBEFORE" colorName="#000000" start="1,1" stop="1,-1"/>
+      <lineStyle kind="LINEAFTER" colorName="#000000" start="1,1" stop="1,-1"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="1,-1" stop="1,-1"/>
+    </blockTableStyle>
+    <blockTableStyle id="Table_title">
+      <blockAlignment value="LEFT"/>
+      <blockValign value="TOP"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="0,0" stop="-1,0"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="0,-1" stop="-1,-1"/>
+    </blockTableStyle>
+    <blockTableStyle id="Table_futter">
+      <blockAlignment value="LEFT"/>
+      <blockValign value="TOP"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="0,0" stop="-1,0"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="0,0" stop="-1,0"/>
+    </blockTableStyle>
+    <initialize>
+      <paraStyle name="all" alignment="justify"/>
+    </initialize>
+    <paraStyle name="P1" fontName="Helvetica"/>
+    <paraStyle name="P2" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
+    <paraStyle name="P3" fontName="Helvetica-Bold" fontSize="10.0" leading="13" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
+    <paraStyle name="P4" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="P4c" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="P4l" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="P5" fontName="Helvetica" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="P5l" fontName="Helvetica" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="P5lb" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="P5rb" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="P5c" fontName="Helvetica" fontSize="9.0" leading="11" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="P7" fontName="Helvetica-Bold" fontSize="15.0" leading="19" alignment="CENTER" spaceBefore="12.0" spaceAfter="6.0"/>
+    <paraStyle name="Standard" fontName="Helvetica"/>
+    <paraStyle name="Text body" fontName="Helvetica" spaceBefore="0.0" spaceAfter="6.0"/>
+    <paraStyle name="Heading" fontName="Helvetica" fontSize="12.0" leading="15" spaceBefore="12.0" spaceAfter="6.0"/>
+    <paraStyle name="List" fontName="Helvetica" spaceBefore="0.0" spaceAfter="6.0"/>
+    <paraStyle name="Table Contents" fontName="Helvetica" spaceBefore="0.0" spaceAfter="6.0"/>
+    <paraStyle name="Table Heading" fontName="Helvetica" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
+    <paraStyle name="Caption" fontName="Helvetica" fontSize="12.0" leading="15" spaceBefore="6.0" spaceAfter="6.0"/>
+    <paraStyle name="Index" fontName="Helvetica"/>
+    <paraStyle name="Footer" fontName="Helvetica"/>
+    <paraStyle name="Horizontal Line" fontName="Helvetica" fontSize="6.0" leading="8" spaceBefore="0.0" spaceAfter="14.0"/>
+    <paraStyle name="terp_header" fontName="Helvetica-Bold" fontSize="15.0" leading="19" alignment="LEFT" spaceBefore="12.0" spaceAfter="6.0"/>
+    <paraStyle name="Heading 9" fontName="Helvetica-Bold" fontSize="75%" leading="NaN" spaceBefore="12.0" spaceAfter="6.0"/>
+    <paraStyle name="terp_tblheader_General" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="6.0" spaceAfter="6.0"/>
+    <paraStyle name="terp_tblheader_Details" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="terp_default_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="terp_default_Bold_8" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="terp_tblheader_General_Centre" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="CENTER" spaceBefore="6.0" spaceAfter="6.0"/>
+    <paraStyle name="terp_tblheader_General_Right" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="6.0" spaceAfter="6.0"/>
+    <paraStyle name="terp_tblheader_Details_Centre" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="terp_tblheader_Details_Right" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="terp_default_Right_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="terp_default_Centre_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="terp_header_Right" fontName="Helvetica-Bold" fontSize="15.0" leading="19" alignment="LEFT" spaceBefore="12.0" spaceAfter="6.0"/>
+    <paraStyle name="terp_header_Centre" fontName="Helvetica-Bold" fontSize="12.0" leading="15" alignment="CENTER" spaceBefore="12.0" spaceAfter="6.0"/>
+    <paraStyle name="terp_default_address" fontName="Helvetica" fontSize="10.0" leading="13" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="terp_default_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="terp_default_Bold_9" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="terp_default_Centre_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="terp_default_Right_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="terp_default_2" fontName="Helvetica" fontSize="2.0" leading="3" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
+    <images/>
+  </stylesheet>
+  <story>
+    <para style="P7"> [[ setLang([[ template_data['lang']) ]] [[ template_data['name'] ]]</para>
+    <blockTable colWidths="255.0,255.0" repeatRows="1">
+      <tr>
+        <td>
+            <para style="P4l">[[ not data['fiscalyear'] and removeParentNode('para')]][[ data['fiscalyear'] ]]</para>
+        </td>
+        <td>
+            <para style="P4">[[ not (data['period_from'] and data['period_to']) and removeParentNode('para')]]Periods: from [[ data['period_from'] ]] to [[ data['period_to'] ]]</para>
+        </td>
+      </tr>
+    </blockTable>
+    <blockTable colWidths="413.0,97.0" repeatRows="1">
+      <tr>
+        <td>
+          <para style="P4l"></para>
+        </td>
+        <td>
+          <para style="P4">[[ user.company_id.currency_id.name ]] [[ digits_round ]]</para>
+        </td>
+      </tr>
+      <tr>
+        <td>
+          <para style="P4">
+            <font face="Helvetica">[[ repeatIn(template_data['statements'][0], 'o') ]]</font>
+          </para>
+          <para style="P5l">
+              [[ setTag('para', 'para', {'spaceBefore': "%s" % (o['top_spacing'],), 'leftIndent': "%s" % (o['indent'],), 'fontName': o['font_name'],}) ]]
+              <u>[[ not (o['underline']) and (setTag('u', 'font', {})) ]] [[ o['name'] ]]</u>
+          </para>
+          <para style="P5l">
+              [[ setTag('para', 'para', {'spaceAfter': "%s" % (o['bottom_spacing'],),}) ]]
+          </para>
+        </td>
+        <td>
+          <para style="P5">
+              [[ setTag('para', 'para', {'leftIndent': "%s" % (o['indent'],), 'fontName': o['font_name'],}) ]]
+              [[ o['total_amount'] ]]
+          </para>
+          <para style="P5l">
+              [[ setTag('para', 'para', {'spaceAfter': "%s" % (o['bottom_spacing'],),}) ]]
+          </para>
+        </td>
+      </tr>
+    </blockTable>
+    
+  </story>
+</document>
+
 
=== added file 'account_fstr/reports/sm_kit.py'
--- account_fstr/reports/sm_kit.py	1970-01-01 00:00:00 +0000
+++ account_fstr/reports/sm_kit.py	2013-04-02 11:54:22 +0000
@@ -0,0 +1,10 @@
+import re
+
+def groupe_digits(digite, separator=','):
+    digite = str(digite)
+    if '.' in digite:
+        re_obj = re.compile(r'(?<=\d)(?=(?:\d\d\d)+\.)')
+    else:
+        re_obj = re.compile(r'(?<=\d)(?=(?:\d\d\d)+$)')
+    result = re_obj.sub(separator, digite)
+    return result
 
=== added directory 'account_fstr/security'
=== added file 'account_fstr/security/ir.model.access.csv'
--- account_fstr/security/ir.model.access.csv	1970-01-01 00:00:00 +0000
+++ account_fstr/security/ir.model.access.csv	2013-04-02 11:54:22 +0000
@@ -0,0 +1,2 @@
+"id","name","model_id:id","group_id:id","perm_read","perm_write","perm_create","perm_unlink"
+"access_account_fstr_category","account_fstr.category","model_account_fstr_category","account.group_account_manager",1,1,1,1
 
=== added directory 'account_fstr/wizard'
=== added file 'account_fstr/wizard/__init__.py'
--- account_fstr/wizard/__init__.py	1970-01-01 00:00:00 +0000
+++ account_fstr/wizard/__init__.py	2013-04-02 11:54:22 +0000
@@ -0,0 +1,20 @@
+##############################################################################
+#
+#    Copyright (C) 2011 Enapps LTD (<http://www.enapps.co.uk>).
+#    All Rights Reserved
+#
+#    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_fstr_wizard
 
=== added file 'account_fstr/wizard/account_fstr_wizard.py'
--- account_fstr/wizard/account_fstr_wizard.py	1970-01-01 00:00:00 +0000
+++ account_fstr/wizard/account_fstr_wizard.py	2013-04-02 11:54:22 +0000
@@ -0,0 +1,126 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    Copyright (C) 2011 Enapps LTD (<http://www.enapps.co.uk>).
+#
+#    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 openerp.osv import fields, osv
+
+class account_fstr_wizard(osv.osv_memory):
+
+    _name = 'account_fstr.wizard'
+    _description = "Template Print/Preview"
+    _columns = {
+        'fiscalyear': fields.many2one('account.fiscalyear', \
+                                    'Fiscal year',  \
+                                    help = 'Keep empty for all open fiscal years'),
+        'period_from': fields.many2one('account.period', 'Start period'),
+        'period_to': fields.many2one('account.period', 'End period'),
+        'target_move': fields.selection([('posted', 'All Posted Entries'),
+                                         ('all', 'All Entries'),
+                                        ], 'Target Moves', required = True),
+        'root_node': fields.many2one('account_fstr.category', 'Root node', required=True,),
+        'hide_zero': fields.boolean('Hide accounts with a zero balance'),
+    }
+
+    def default_get(self, cr, uid, fields, context={}):
+        result = super(osv.osv_memory, self).default_get(cr, uid, fields, context=context)
+        result['root_node']=  context.get('active_id', None)
+        return result
+
+    def onchange_fiscalyear(self, cr, uid, ids, fiscalyear_id=False, context=None):
+        res = {}
+        res['value'] = {}
+        if 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
+                               ORDER BY p.date_start ASC
+                               LIMIT 1) AS period_start
+                UNION
+                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()
+                               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 and len(periods) > 1:
+                start_period = periods[0]
+                end_period = periods[1]
+            res['value'] = {'period_from': start_period, 'period_to': end_period}
+        return res
+
+    def open_window(self, cr, uid, ids, context=None):
+        """
+        Opens chart of Accounts
+        @param cr: the current row, from the database cursor,
+        @param uid: the current user’s ID for security checks,
+        @param ids: List of account chart’s IDs
+        @return: dictionary of Open account chart window on given fiscalyear and all Entries or posted entries
+        """
+        mod_obj = self.pool.get('ir.model.data')
+        act_obj = self.pool.get('ir.actions.act_window')
+        period_obj = self.pool.get('account.period')
+        fy_obj = self.pool.get('account.fiscalyear')
+        if context is None:
+            context = {}
+        data = self.read(cr, uid, ids, [], context=context)[0]
+        result = mod_obj.get_object_reference(cr, uid, 'account_fstr', 'action_account_fstr_category_tree')
+        id = result and result[1] or False
+        result = act_obj.read(cr, uid, [id], context=context)[0]
+        result['periods'] = []
+        if data['period_from'] and data['period_to']:
+            result['periods'] = period_obj.build_ctx_periods(cr, uid, data['period_from'][0], data['period_to'][0])
+        result['context'] = str({'fiscalyear': data['fiscalyear'][0], 'periods': result['periods'], 'state': data['target_move']})
+        if data['fiscalyear']:
+            result['name'] += ':' + fy_obj.read(cr, uid, [data['fiscalyear'][0]], context=context)[0]['code']
+        result['domain'] = [('id', '=', data['root_node'][0])]
+        return result
+
+    def print_template(self, cr, uid, ids, context={}):
+        period_obj = self.pool.get('account.period')
+        data = self.read(cr, uid, ids, [], context=context)[0]
+        data_obj = self.browse(cr, uid, ids, context=context)[0]
+        datas = {'periods': [], 'ids': ids}
+        if data['period_from'] and data['period_to']:
+            context['periods'] = period_obj.build_ctx_periods(cr, uid, data['period_from'][0], data['period_to'][0])
+        datas['context'] = str({'fiscalyear': data['fiscalyear'], 'periods': datas['periods'], \
+                                    'state': data['target_move']})
+        datas['period_from'] = data_obj.period_from.name
+        datas['period_to'] = data_obj.period_to.name
+        datas['fiscalyear'] = data_obj.fiscalyear.name
+        context['account_fstr_root_node'] = data['root_node']
+        context['hide_zero'] = data['hide_zero']
+        return {
+            'type': 'ir.actions.report.xml',
+            'report_name': 'account_fstr.report',
+            'datas': datas,
+            'context': context,
+        }
+
+    _defaults = {
+        'target_move': 'posted'
+    }
+
+account_fstr_wizard()
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4: