Merge lp:~anybox/aeroo/fix-upgrade into lp:aeroo

[Georges Racinet]

To test, take any customer project using an earlier version of aeroo (no restart_ooo_cmd column in oo_config table), and perform an upgrade with the upgrade script provided by the recipe.

A quicker test is to check if the server starts *without -u report_aeroo_ooo*

Note that I am also tempted by fixing the bare excepts once the fix itself is more mature.

I'm asking ccomb, but any comments are welcome, and especially further tests by the Anybox team on customer projects.

[lp:~anybox/aeroo/fix-upgrade]

38. By Georges Racinet <email address hidden> on 2014-04-17

Removed some bare excepts

This did not change the behaviour for me. But exception treatment is so
messy in aeroo that I could not see the warning in the except: block

I could see parts of the module that systematically wrap and reraise everything
as Exception

39. By Pierre Verkest on 2014-04-24

use exception message

40. By Pierre Verkest on 2014-04-24

[FIX]use Message instead message from uno exception

41. By Georges Racinet on 2014-04-25

[FIX] (temp) graceful instantiation of OOo service depended on bare except

put a big comment in check_deps indicating how a proper fix of this terrible
entanglement should look

Unmerged revisions

41. By Georges Racinet on 2014-04-25

[FIX] (temp) graceful instantiation of OOo service depended on bare except

put a big comment in check_deps indicating how a proper fix of this terrible
entanglement should look

40. By Pierre Verkest on 2014-04-24

[FIX]use Message instead message from uno exception

39. By Pierre Verkest on 2014-04-24

use exception message

38. By Georges Racinet <email address hidden> on 2014-04-17

Removed some bare excepts

This did not change the behaviour for me. But exception treatment is so
messy in aeroo that I could not see the warning in the except: block

I could see parts of the module that systematically wrap and reraise everything
as Exception

37. By Georges Racinet <email address hidden> on 2014-04-05

[FIX] made startup sequence more robust in upgrade situations

See explanations in OpenOffice_service docstring
This fixes in particular upgrades done with anybox.recipe.openerp's
standard upgrade scripts, which will act only after the database has been
loaded.

36. By fjouatte <email address hidden> on 2013-12-03

[FIX] Fix report visualization from openerp ui

35. By Mathieu Vatel - Julius Network Solutions on 2014-03-31

[FIX] - remove a cr.rollback() which leads to not computing parent_left parent_right in ir_ui_menu when OpenOfficeService is not working

34. By Mathieu Vatel - Julius Network Solutions on 2014-03-31

[IMP] simple code cleaning

33. By Mathieu Vatel - Julius Network Solutions on 2014-03-05

[FIX] - error on loading

32. By Mathieu Vatel - Julius Network Solutions on 2014-03-05

[IMP] - improve the last commit to get the last version of lp:aeroo

=== added directory 'report_aeroo'
=== renamed directory 'report_aeroo' => 'report_aeroo.moved'
=== added file 'report_aeroo/ExtraFunctions.py'
--- report_aeroo/ExtraFunctions.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ExtraFunctions.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,664 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+# Copyright (c) 2009-2013 Alistek Ltd (http://www.alistek.com) All Rights Reserved.
+#                    General contacts <[e-mail]>
+#
+# WARNING: This program as such is intended to be used by professional
+# programmers who take the whole responsability of assessing all potential
+# consequences resulting from its eventual inadequacies and bugs
+# End users who are looking for a ready-to-use solution with commercial
+# garantees and support are strongly adviced to contract a Free Software
+# Service Company
+#
+# 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 module is GPLv3 or newer and incompatible
+# with OpenERP SA "AGPL + Private Use License"!
+#
+# 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, write to the Free Software
+# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
+#
+##############################################################################
+
+from .barcode import barcode
+from openerp.tools import translate
+#from .currency_to_text import currency_to_text
+from .ctt_objects import supported_language
+import logging
+_logger = logging.getLogger(__name__)
+import base64
+import StringIO
+try:
+    from PIL import Image
+except:
+    _logger.warning("ERROR IMPORTING PIL, if not installed, please install it:"
+    " get it here: https://pypi.python.org/pypi/PIL")
+from openerp import pooler
+import time
+from openerp.osv import orm
+from openerp.report import report_sxw
+from openerp.tools.translate import _
+from openerp import netsvc
+from openerp.tools.safe_eval import safe_eval as eval
+from aeroolib.plugins.opendocument import _filter
+
+try:
+    from docutils.examples import html_parts # use python-docutils library
+except ImportError, e:
+    _logger.warning("ERROR IMPORTING docutils, if not installed, please install it:"
+    " e.g.: apt-get install python-docutils")
+    rest_ok = False
+else:
+    rest_ok = True
+
+try:
+    import nltk
+except:
+    _logger.warning("ERROR IMPORTING nltk, if not installed, please install it:"
+    " e.g.: apt-get install python-nltk")
+
+try:
+    import markdown
+    from markdown import Markdown # use python-markdown library
+    from markdown.inlinepatterns import AutomailPattern
+    
+    class AutomailPattern_mod (AutomailPattern, object):
+        def __init__(self, *args, **kwargs):
+            super(AutomailPattern_mod, self).__init__(*args, **kwargs)
+
+        def handleMatch(self, m):
+            el = super(AutomailPattern_mod, self).handleMatch(m)
+            href = ''.join([chr(int(a.replace(markdown.AMP_SUBSTITUTE+'#', ''))) for a in el.get('href').split(';') if a])
+            el.set('href', href)
+            return el
+    
+    markdown.inlinepatterns.AutomailPattern = AutomailPattern_mod # easy hack for correct displaying in Joomla
+ 
+except ImportError, e:
+    markdown_ok = False
+    _logger.warning("ERROR IMPORTING markdown, if not installed, please install it:"
+    " e.g.: apt-get install python-markdown")
+else:
+    markdown_ok = True
+
+try:
+    from mediawiki import wiki2html # use python-mediawiki library
+except ImportError, e:
+    wikitext_ok = False
+else:
+    wikitext_ok = True
+
+from .domain_parser import domain2statement
+
+class ExtraFunctions(object):
+    """ This class contains some extra functions which
+        can be called from the report's template.
+    """
+    def __init__(self, cr, uid, report_id, context):
+        self.cr = cr
+        self.uid = uid
+        self.pool = pooler.get_pool(self.cr.dbname)
+        self.report_id = report_id
+        self.context = context
+        self.functions = {
+            'report_context': self.context,
+            'asarray':self._asarray,
+            'asimage':self._asimage,
+            'html_embed_image':self._embed_image,
+            'get_attachments':self._get_attachments,
+            'get_name':self._get_name,
+            'get_label':self._get_label,
+            'getLang':self._get_lang,
+            'get_selection_item':self._get_selection_items('item'),
+            'safe':self._get_safe,
+            'countif':self._countif,
+            'count':self._count,
+            'sumif':self._sumif,
+            'sum_field':self._sum,
+            'max_field':self._max,
+            'min_field':self._min,
+            'average':self._average,
+            'large':self._large,
+            'small':self._small,
+            'count_blank':self._count_blank,
+            '_':self._translate_text,
+            'gettext':self._translate_text,
+            'currency_to_text':self._currency2text(context['company'].currency_id.name), #self._currency2text(context['company'].currency_id.code),
+            'barcode':barcode.make_barcode,
+            'debugit':self.debugit,
+            'dec_to_time':self._dec2time,
+            'chunks':self._chunks,
+            'browse':self._browse,
+            'search':self._search,
+            'search_ids':self._search_ids,
+            'field_size':self._field_size,
+            'field_accuracy':self._field_accuracy,
+            'bool_as_icon':self._bool_as_icon,
+            'time':time,
+            'report_xml': self._get_report_xml(),
+            'get_log': self._perm_read(self.cr, self.uid),
+            'get_selection_items': self._get_selection_items(),
+            'itemize': self._itemize,
+            'html_escape': self._html_escape,
+            'html_remove': self._html_remove,
+            'http_prettyuri': self._http_prettyuri,
+            'http_builduri': self._http_builduri,
+            'text_markdown': markdown_ok and self._text_markdown or \
+                self._text_plain('"markdown" format is not supported! Need to be installed "python-markdown" package.'),
+            'text_restruct': rest_ok and self._text_restruct or \
+                self._text_plain('"reStructuredText" format is not supported! Need to be installed "python-docutils" package.'),
+            'text_wiki': wikitext_ok and self._text_wiki or \
+                self._text_plain('"wikimarkup" format is not supported! Need to be installed "python-mediawiki" package.'),
+            'text_markup': self._text_markup,
+            '__filter': self.__filter, # Don't use in the report template!
+            'specific_lang': self._specific_lang,
+            'sort_by':self._sort_by,
+            'group_by':self._group_by,
+            'invoice_lines': self._invoice_lines,
+            'location_name': self._location,
+        }
+        
+    def __filter(self, val):
+        if isinstance(val, orm.browse_null):
+            return ''
+        elif isinstance(val, orm.browse_record):
+            return val.name_get({'lang':self._get_lang()})[0][1]
+        return _filter(val)
+
+    def _perm_read(self, cr, uid):
+        def get_log(obj, field=None):
+            if field:
+                return obj.perm_read(self.uid, [obj.id])[0][field]
+            else:
+                return obj.perm_read(self.uid, [obj.id])[0]
+        return get_log
+
+    def _get_report_xml(self):
+        return self.pool.get('ir.actions.report.xml').browse(self.cr, self.uid, self.report_id)
+
+    def _get_lang(self, source='current'):
+        if source=='current':
+            return self.context['lang'] or self.context['user_lang']
+        elif source=='company':
+            return self.context['user'].company_id.partner_id.lang
+        elif source=='user':
+            return self.context['user_lang']
+
+    def _bool_as_icon(self, val, kind=0):
+        if isinstance(kind, (list, tuple)):
+            if val==True:
+                return kind [0]
+            elif val==False:
+                return kind[1]
+            else:
+                return kind[2]
+        bool_kind = {0:{True:self._translate_text('True'), False:self._translate_text('False'), None:""},
+                     1:{True:self._translate_text('T'), False:self._translate_text('F'), None:""},
+                     2:{True:self._translate_text('Yes'), False:self._translate_text('No'), None:""},
+                     3:{True:self._translate_text('Y'), False:self._translate_text('N'), None:""},
+                     4:{True:'+', False:'-', None:""},
+                     5:{True:'[ + ]', False:'[ - ]', None:"[ ]"},
+                     6:{True:'[ x ]', False:'[ ]', None:"[ ]"},
+                     7:{True:'x', False:'', None:""},
+                    }
+        return bool_kind.get(kind, {}).get(val, val)
+
+    def _dec2time(self, dec, h_format, min_format):
+        if dec==0.0:
+            return None
+        elif int(dec)==0:
+            return min_format.replace('%M', str(int(round((dec-int(dec))*60))))
+        elif dec-int(dec)==0.0:
+            return h_format.replace('%H', str(int(dec)))
+        else:
+            return h_format.replace('%H', str(int(dec)))+min_format.replace('%M', str(int(round((dec-int(dec))*60))))
+
+    def _currency2text(self, currency):
+        def c_to_text(sum, currency=currency, language=None):
+            return unicode(supported_language.get(language or self._get_lang()).currency_to_text(sum, currency), "UTF-8")
+        return c_to_text
+
+    def _translate_text(self, source):
+        trans_obj = self.pool.get('ir.translation')
+        trans = trans_obj.search(self.cr,self.uid,[('res_id','=',self.report_id),('type','=','report'),('src','=',source),('lang','=',self.context['lang'] or self.context['user_lang'])])
+        if not trans:
+            #trans_obj.create(self.cr, self.uid, {'src':source,'type':'report','lang':self._get_lang(),'res_id':self.report_id,'name':('ir.actions.report.xml,%s' % source)[:128]})
+            trans_obj.create(self.cr, self.uid, {'src':source,'type':'report','lang':self._get_lang(),'res_id':self.report_id,'name':'ir.actions.report.xml'})
+        return translate(self.cr, 'ir.actions.report.xml', 'report', self._get_lang(), source) or source
+
+    def _countif(self, attr, domain):
+        statement = domain2statement(domain)
+        expr = "for o in objects:\n\tif%s:\n\t\tcount+=1" % statement
+        localspace = {'objects':attr, 'count':0}
+        exec expr in localspace
+        return localspace['count']
+
+    def _count_blank(self, attr, field):
+        expr = "for o in objects:\n\tif not o.%s:\n\t\tcount+=1" % field
+        localspace = {'objects':attr, 'count':0}
+        exec expr in localspace
+        return localspace['count']
+
+    def _count(self, attr):
+        return len(attr)
+
+    def _sumif(self, attr, sum_field, domain):
+        statement = domain2statement(domain)
+        expr = "for o in objects:\n\tif%s:\n\t\tsumm+=float(o.%s)" % (statement, sum_field)
+        localspace = {'objects':attr, 'summ':0}
+        exec expr in localspace
+        return localspace['summ']
+
+    def _sum(self, attr, sum_field):
+        expr = "for o in objects:\n\tsumm+=float(o.%s)" % sum_field
+        localspace = {'objects':attr, 'summ':0}
+        exec expr in localspace
+        return localspace['summ']
+
+    def _max(self, attr, field):
+        expr = "for o in objects:\n\tvalue_list.append(o.%s)" % field
+        localspace = {'objects':attr, 'value_list':[]}
+        exec expr in localspace
+        return max(localspace['value_list'])
+
+    def _min(self, attr, field):
+        expr = "for o in objects:\n\tvalue_list.append(o.%s)" % field
+        localspace = {'objects':attr, 'value_list':[]}
+        exec expr in localspace
+        return min(localspace['value_list'])
+
+    def _average(self, attr, field):
+        expr = "for o in objects:\n\tvalue_list.append(o.%s)" % field
+        localspace = {'objects':attr, 'value_list':[]}
+        exec expr in localspace
+        return float(sum(localspace['value_list']))/float(len(localspace['value_list']))
+
+    def _asarray(self, attr, field):
+        expr = "for o in objects:\n\tvalue_list.append(o.%s)" % field
+        localspace = {'objects':attr, 'value_list':[]}
+        exec expr in localspace
+        return localspace['value_list']
+
+    def _get_name(self, obj):
+        if obj.__class__== orm.browse_record:
+            return self.pool.get(obj._table_name).name_get(self.cr, self.uid, [obj.id], {'lang':self._get_lang()})[0][1]
+        elif type(obj)==str: # only for fields in root record
+            model = self.context['model']
+            field, rec_id = obj.split(',')
+            rec_id = int(rec_id)
+            if rec_id:
+                field_data = self.pool.get(model).fields_get(self.cr, self.uid, [field], context=self.context)
+                return self.pool.get(field_data[field]['relation']).name_get(self.cr, self.uid, [rec_id], {'lang':self._get_lang()})[0][1]
+            else:
+                return ''
+        return ''
+
+    def _get_label(self, obj, field):
+        if not obj:
+            return ''
+        try:
+            if isinstance(obj, report_sxw.browse_record_list):
+                obj = obj[0]
+            if isinstance(obj, (str,unicode)):
+                model = obj
+            else:
+                model = obj._table_name
+            if isinstance(obj, (str,unicode)) or hasattr(obj, field):
+                labels = self.pool.get(model).fields_get(self.cr, self.uid, allfields=[field], context=self.context)
+                return labels[field]['string']
+        except Exception, e:
+            return ''
+
+    def _field_size(self, obj, field):
+        try:
+            if isinstance(obj, report_sxw.browse_record_list):
+                obj = obj[0]
+            if isinstance(obj, (str,unicode)):
+                model = obj
+            else:
+                model = obj._table_name
+            if isinstance(obj, (str,unicode)) or hasattr(obj, field):
+                size = self.pool.get(model)._columns[field].size
+                return size
+        except Exception, e:
+            return ''
+
+    def _field_accuracy(self, obj, field):
+        try:
+            if isinstance(obj, report_sxw.browse_record_list):
+                obj = obj[0]
+            if isinstance(obj, (str,unicode)):
+                model = obj
+            else:
+                model = obj._table_name
+            if isinstance(obj, (str,unicode)) or hasattr(obj, field):
+                digits = self.pool.get(model)._columns[field].digits
+                return digits or [16,2]
+        except Exception:
+            return []
+
+    def _get_selection_items(self, kind='items'):
+        def get_selection_item(obj, field, value=None):
+            try:
+                if isinstance(obj, report_sxw.browse_record_list):
+                    obj = obj[0]
+                if isinstance(obj, (str,unicode)):
+                    model = obj
+                    field_val = value
+                else:
+                    model = obj._table_name
+                    field_val = getattr(obj, field)
+                if kind=='item':
+                    if field_val:
+                        return dict(self.pool.get(model).fields_get(self.cr, self.uid, allfields=[field], context=self.context)[field]['selection'])[field_val]
+                elif kind=='items':
+                    return self.pool.get(model).fields_get(self.cr, self.uid, allfields=[field], context=self.context)[field]['selection']
+                return ''
+            except Exception:
+                return ''
+        return get_selection_item
+
+    def _get_attachments(self, o, index=None, raw=False):
+        attach_obj = self.pool.get('ir.attachment')
+        srch_param = [('res_model','=',o._name),('res_id','=',o.id)]
+        if type(index)==str:
+            srch_param.append(('name','=',index))
+        attachments = attach_obj.search(self.cr,self.uid,srch_param)
+        res = [x['datas'] for x in attach_obj.read(self.cr,self.uid,attachments,['datas']) if x['datas']]
+        convert = raw and base64.decodestring or (lambda a: a)
+        if type(index)==int:
+            return convert(res[index])
+        return convert(len(res)==1 and res[0] or res)
+
+    def _asimage(self, field_value, rotate=None, size_x=None, size_y=None, uom='px', hold_ratio=False):
+        def size_by_uom(val, uom, dpi):
+            if uom=='px':
+                result=str(val/dpi)+'in'
+            elif uom=='cm':
+                result=str(val/2.54)+'in'
+            elif uom=='in':
+                result=str(val)+'in'
+            return result
+        ##############################################
+        if not field_value:
+            return StringIO.StringIO(), 'image/png'
+        field_value = base64.decodestring(field_value)
+        tf = StringIO.StringIO(field_value)
+        tf.seek(0)
+        try:
+            im=Image.open(tf)
+            format = im.format.lower()
+            dpi_x, dpi_y = map(float, im.info.get('dpi', (96, 96)))
+        except Exception, e:
+            raise orm.except_orm('Error', e)
+        try:
+            if rotate!=None:
+                im=im.rotate(int(rotate))
+                tf.seek(0)
+                im.save(tf, format)
+        except Exception, e:
+            raise orm.except_orm('Error', e)
+
+        if hold_ratio:
+            img_ratio = im.size[0] / float(im.size[1]) # width / height
+            if size_x and not size_y:
+                size_y = size_x / img_ratio
+            elif not size_x and size_y:
+                size_x = size_y * img_ratio
+            elif size_x and size_y:
+                size_y2 = size_x / img_ratio
+                size_x2 = size_y * img_ratio
+                if size_y2 > size_y:
+                    size_x = size_x2
+                elif size_x2 > size_x:
+                    size_y = size_y2
+
+        size_x = size_x and size_by_uom(size_x, uom, dpi_x) or str(im.size[0]/dpi_x)+'in'
+        size_y = size_y and size_by_uom(size_y, uom, dpi_y) or str(im.size[1]/dpi_y)+'in'
+        return tf, 'image/%s' % format, size_x, size_y
+
+    def _embed_image(self, extention, img, width=0, height=0, raw=False):
+        "Transform a DB image into an embeded HTML image"
+        if not img:
+            return ''
+        try:
+            if width :
+                width = ' width="%spx"'%(width)
+            else :
+                width = ''
+            if height :
+                height = 'height="%spx" '%(height)
+            else :
+                height = ''
+            if raw:
+                toreturn = 'data:image/%s;base64,%s' % (extention, ''.join(str(img).splitlines()))
+            else:
+                toreturn = '<img%s %ssrc="data:image/%s;base64,%s">' % (width, height, extention, str(img))
+            return toreturn
+        except Exception, exp:
+            return 'No image'
+
+    def _large(self, attr, field, n):
+        array=self._asarray(attr, field)
+        try:
+            n-=1
+            while(n):
+                array.remove(max(array))
+                n-=1
+            return max(array)
+        except ValueError, e:
+            return None
+
+    def _small(self, attr, field, n):
+        array=self._asarray(attr, field)
+        try:
+            n-=1
+            while(n):
+                array.remove(min(array))
+                n-=1
+            return min(array)
+        except ValueError, e:
+            return None
+
+    def _chunks(self, l, n):
+        """ Yield successive n-sized chunks from l.
+        """
+        for i in xrange(0, len(l), n):
+            yield l[i:i+n]
+
+    def _search_ids(self, model, domain):
+        obj = self.pool.get(model)
+        return obj.search(self.cr, self.uid, domain)
+
+    def _search(self, model, domain, context=None):
+        obj = self.pool.get(model)
+        ids = obj.search(self.cr, self.uid, domain)
+        if context is None:
+            context = {}
+        context['lang'] = self._get_lang()
+        return obj.browse(self.cr, self.uid, ids, context=context)
+
+    def _browse(self, *args):
+        if not args or (args and not args[0]):
+            return None
+        if len(args)==1:
+            model, id = args[0].split(',')
+            id = int(id)
+        elif len(args)==2:
+            model, id = args
+        else:
+            raise None
+        return self.pool.get(model).browse(self.cr, self.uid, id)
+
+    def _get_safe(self, expression, obj):
+        try:
+            return eval(expression, {'o':obj})
+        except Exception, e:
+            return None
+
+    def debugit(self, object):
+        """ Run the server from command line and 
+            call 'debugit' from the template to inspect variables.
+        """
+        import pdb;pdb.set_trace()
+        return
+
+    def _itemize(self, array, purefalse = False, base_num = 1):
+        it = iter(array)
+        falseval = purefalse and False or ''
+        e = it.next()
+        lind = 0
+        while True:
+            lind += 1
+            is_even = lind%2 == 0 or falseval
+            is_odd = not is_even or falseval
+            is_first = lind == 1 or falseval
+            try:
+                nxt = it.next()
+                yield (lind-1, lind+base_num-1, e, is_even, is_odd, is_first, falseval)
+                e = nxt
+            except StopIteration:
+                yield (lind-1, lind+base_num-1, e, is_even, is_odd, is_first, True)
+                break
+
+    def _html_escape(self, s):
+        toesc={ '<': '&lt;',
+                '>': '&gt;',
+                '&': '&amp;',
+                '"': '&quot;',
+                "'": '&apos;' }
+        
+        if type(s) is str:
+            s.decode()
+        try:
+            return ''.join(map(lambda a: toesc.get(a, a), s))
+        except TypeError:
+           return s
+       
+    def _html_remove(self, s):
+        def replace_specifics(s):
+            list_to_change = {
+                '&lt;': '<',
+                '&gt;': '>',
+                '&amp;': '&' ,
+                '&quot;': '"',
+                '&apos;': "'"
+            }
+            for key1 in list_to_change.keys():
+                s = s.replace(key1, list_to_change[key1])
+            return s
+        try:
+            return replace_specifics(nltk.clean_html(s))
+        except Exception, e:
+            raise orm.except_orm('Error', e)
+
+    def _http_prettyuri(self, s):
+        def do_filter(c):
+            # filter out reserved and "unsafe" characters
+            pos = '''<>$&+,/\:;=?@'"#%{}|^~[]()`'''.find(c)
+            if pos >= 0: return False
+            
+            # filter out ASCII Control characters and unhandled Non-ASCII characters
+            ordc = ord(c)
+            if (ordc >= 0 and ordc <= 31) or (ordc >= 127 and ordc <= 255): return False
+            return c
+
+        if type(s) is str: s.decode()
+        # tranlate specific latvian characters into latin and whitespace into dash
+        tt = dict(zip(map(ord, 'āčēģīķļņōŗšūžĀČĒĢĪĶĻŅŌŖŠŪŽ '.decode()), 'acegiklnorsuzACEGIKLNORSUZ-'.decode()))
+        try:
+            s = s.translate(tt)
+            return (filter(do_filter, s)).lower()
+        except TypeError:
+            return s
+
+    def _http_builduri(self, *dicts):
+        d = {}
+        for ind in dicts:
+            d.update(ind)
+        result = ''
+        for pair in d.iteritems():
+            result += '&%s=%s' % pair
+        return result
+
+    def _text_restruct(self, text):
+        output = html_parts(unicode(text), doctitle=False)
+        return output['body']
+
+    def _text_markdown(self, text):
+        md = Markdown()
+        return md.convert(text)
+
+    def _text_wiki(self, text):
+        return wiki2html(text, True)
+
+    def _text_plain(self, msg):
+        def text_plain(text):
+            _logger.info(msg)
+            return text
+        return text_plain
+
+    def _text_markup(self, text):
+        lines = text.splitlines()
+        first_line = lines.pop(0)
+        if first_line=='text/x-markdown':
+            return self._text_markdown('\n'.join(lines))
+        elif first_line=='text/x-wiki':
+            return self._text_wiki('\n'.join(lines))
+        elif first_line=='text/x-rst':
+            return self._text_rest('\n'.join(lines))
+        return text
+
+    def _specific_lang(self, model, id, lang=False):
+        context = self.context
+        context['lang'] = lang or self._get_lang()
+        obj = self.pool.get(model)
+        return obj.browse(self.cr, self.uid, id, context=context)
+    
+    def _invoice_lines(self, lines):
+        result = []
+        res = {}
+        for entry in lines:
+            flag = False
+            for res in result: 
+                if entry.product_id == res.product_id and entry.price_unit == res.price_unit \
+                    and entry.invoice_line_tax_id == res.invoice_line_tax_id and entry.discount == res.discount:
+                    res.quantity += entry.quantity
+                    res.price_subtotal += entry.price_subtotal
+                    flag = True
+            if flag == False:
+                result.append(entry)
+        return result
+    
+    def _location(self): 
+        if self.context is None:
+            self.context = {}
+        location_name = ''
+        if self.context.get('location'):
+            location_name = self.pool.get('stock.location').read(self.cr, self.uid,
+                self.context.get('location'), ['name'], context = self.context)['name']
+        return location_name
+
+    def _sort_by(self, attr, field):
+        expr = "for o in objects:\n\tdict_vals[o] = o.%s or ''" % field
+        localspace = {'objects':attr, 'dict_vals':{}}
+        exec expr in localspace
+        return [o for o, val in sorted(localspace['dict_vals'].items(), key=lambda x: x[1])]
+
+    def _group_by(self, attr, field):
+        expr = "for o in objects:\n\tdict_vals.setdefault(o.%s or '', [])\n\tdict_vals[o.%s or ''].append(o)" % (field, field)
+        localspace = {'objects':attr, 'dict_vals':{}}
+        exec expr in localspace
+        return sorted(localspace['dict_vals'].items(), key=lambda x: x[0])
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:

=== added file 'report_aeroo/__init__.py'
--- report_aeroo/__init__.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/__init__.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,52 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+# Copyright (c) 2009-2012 Alistek Ltd (http://www.alistek.com) All Rights Reserved.
+#                    General contacts <[e-mail]>
+#
+# WARNING: This program as such is intended to be used by professional
+# programmers who take the whole responsability of assessing all potential
+# consequences resulting from its eventual inadequacies and bugs
+# End users who are looking for a ready-to-use solution with commercial
+# garantees and support are strongly adviced to contract a Free Software
+# Service Company
+#
+# 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 module is GPLv3 or newer and incompatible
+# with OpenERP SA "AGPL + Private Use License"!
+#
+# 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, write to the Free Software
+# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
+#
+##############################################################################
+
+import aeroolib
+from genshi.template import NewTextTemplate
+
+check_list = [
+    'import aeroolib',
+    'import genshi',
+    'from genshi.template import NewTextTemplate',
+    'from xml.dom import minidom',
+]
+
+from check_deps import check_deps
+check_deps(check_list)
+
+import installer
+import translate
+import report_xml
+import report_aeroo
+import wizard
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:

=== added file 'report_aeroo/__openerp__.py'
--- report_aeroo/__openerp__.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/__openerp__.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,82 @@
+# -*- coding: utf-8 -*-
+########################################################################
+#                                                                       
+# Copyright (C) 2009  Domsense s.r.l.                                   
+# @authors: Simone Orsi																	       
+# Copyright (C) 2009-2013  Alistek Ltd                                  
+#                                                                       
+#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 module is GPLv3 or newer and incompatible
+# with OpenERP SA "AGPL + Private Use License"!
+#                                                                       
+#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 <http://www.gnu.org/licenses/>.  
+########################################################################
+
+{
+    'name': 'Aeroo Reports',
+    'version': '1.2',
+    'category': 'Generic Modules/Aeroo Reporting',
+    'description': """
+Aeroo Reports for OpenERP is a comprehensive reporting engine based on Aeroo Library.
+
+Report templates can be created directly in of following formats:
+=================================================================
+* Open Document Format (ODF) - .odt, .ods;
+* Other ASCII based formats, like HTML, CSV, etc.
+
+Output formats:
+=================================================================
+* Open Document Format (ODF) - .odt, .ods;
+* Other ASCII based formats, like HTML, CSV, etc. 
+* with report_aeroo_ooo [1] module - PDF, DOC, XLS, CSV.
+
+Reporting engine features:
+=================================================================
+* Add reports from UI "on the fly";
+* Install reports from module;
+* Dynamic template load/unload;
+* Extra Functions - set of functions for rapid template development;
+* Use templates stored on filesystem, database or elsewhere;
+* Same button - different templates;
+* Powerful stylesheet system for ODF templates;
+* Global or local stylesheets;
+* Template preloading for performance concerns;
+* User defined parsers;
+* Report deactivation;
+* Tunable format fallback;
+* Add/Remove print button wizards;
+* Test report on particular object ID, directly from Report form;
+* Translatable reports;
+* Translation export;
+* Number of copies;
+* Universal Report wizard;
+* Override report file extension (for direct printing, etc);
+* Separate input/output format selections;
+
+[1] For more information on available template -> output pairs and other features, see description of report_aeroo_ooo module.
+
+=> You need to install python-nltk on your machine
+""",
+    'author': 'Alistek Ltd, Simone Orsi - Domsense',
+    'website': 'http://www.alistek.com',
+    'complexity': "easy",
+    'depends': ['base'],
+    "init_xml" : [],
+    'update_xml': ["installer.xml", "report_view.xml", "data/report_aeroo_data.xml", "wizard/add_print_button_view.xml", "wizard/remove_print_button_view.xml", "security/ir.model.access.csv"],
+    "license" : "GPL-3 or any later version",
+    'installable': True,
+    'active': False,
+    'application': True,
+}
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:

=== added directory 'report_aeroo/barcode'
=== added file 'report_aeroo/barcode/EANBarCode.py'
--- report_aeroo/barcode/EANBarCode.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/barcode/EANBarCode.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,159 @@
+# Copyright (c) 2009-2011 Alistek Ltd (http://www.alistek.com) All Rights Reserved.
+#                    General contacts <[e-mail]>
+
+from openerp.tools import config, ustr
+fontsize = 15
+
+"""
+This class generate EAN bar code, it required PIL (python imaging library)
+installed.
+
+If the code has not checksum (12 digits), it added automatically.
+
+Create bar code sample :
+   from EANBarCode import EanBarCode
+   bar = EanBarCode()
+   bar.getImage("9782212110708",50,"gif")
+
+"""
+
+class EanBarCode:
+   """ Compute the EAN bar code """
+   def __init__(self):
+      A = {0 : "0001101", 1 : "0011001", 2 : "0010011", 3 : "0111101", 4 : "0100011", 
+           5 : "0110001", 6 : "0101111", 7 : "0111011", 8 : "0110111", 9 : "0001011"}
+      B = {0 : "0100111", 1 : "0110011", 2 : "0011011", 3 : "0100001", 4 : "0011101",
+           5 : "0111001", 6 : "0000101", 7 : "0010001", 8 : "0001001", 9 : "0010111"}
+      C = {0 : "1110010", 1 : "1100110", 2 : "1101100", 3 : "1000010", 4 : "1011100",
+           5 : "1001110", 6 : "1010000", 7 : "1000100", 8 : "1001000", 9 : "1110100"}
+      self.groupC = C
+
+      self.family = {0 : (A,A,A,A,A,A), 1 : (A,A,B,A,B,B), 2 : (A,A,B,B,A,B), 3 : (A,A,B,B,B,A), 4 : (A,B,A,A,B,B),
+                     5 : (A,B,B,A,A,B), 6 : (A,B,B,B,A,A), 7 : (A,B,A,B,A,B), 8 : (A,B,A,B,B,A), 9 : (A,B,B,A,B,A)}
+
+
+   def makeCode(self, code):
+      """ Create the binary code
+      return a string which contains "0" for white bar, "1" for black bar, "L" for long bar """
+      
+      # Convert code string in integer list
+      self.EAN13 = []
+      for digit in code:
+         self.EAN13.append(int(digit))
+         
+      # If the code has already a checksum
+      if len(self.EAN13) == 13:
+         # Verify checksum
+         self.verifyChecksum(self.EAN13)
+      # If the code has not yet checksum
+      elif len(self.EAN13) == 12:
+         # Add checksum value
+         self.EAN13.append(self.computeChecksum(self.EAN13))
+      
+      # Get the left codage class
+      left = self.family[self.EAN13[0]]
+      
+      # Add start separator
+      strCode = 'L0L'
+      
+      # Compute the left part of bar code
+      for i in range(0,6):
+         strCode += left[i][self.EAN13[i+1]]
+      
+      # Add middle separator 
+      strCode += '0L0L0'
+      
+      # Compute the right codage class
+      for i in range (7,13):
+         strCode += self.groupC[self.EAN13[i]]
+      
+      # Add stop separator
+      strCode += 'L0L'
+      
+      return strCode
+
+
+   def computeChecksum(self, arg):
+      """ Compute the checksum of bar code """
+      # UPCA/EAN13
+      weight=[1,3]*6
+      magic=10
+      sum = 0
+      
+      for i in range(12):         # checksum based on first 12 digits.
+         sum = sum + int(arg[i]) * weight[i]
+      z = ( magic - (sum % magic) ) % magic
+      if z < 0 or z >= magic:
+         return None
+      return z
+
+
+   def verifyChecksum(self, bits): 
+      """ Verify the checksum """
+      computedChecksum = self.computeChecksum(bits[:12])
+      codeBarChecksum = bits[12]
+      
+      if codeBarChecksum != computedChecksum:
+         raise Exception ("Bad checksum is %s and should be %s"%(codeBarChecksum, computedChecksum))
+
+
+   def getImage(self, value, height = 50, xw=1, rotate=None, extension = "PNG"):
+      """ Get an image with PIL library 
+      value code barre value
+      height height in pixel of the bar code
+      extension image file extension"""
+      from PIL import Image, ImageFont, ImageDraw
+      import os
+      from string import lower, upper
+      
+      # Get the bar code list
+      bits = self.makeCode(value)
+      
+      # Get thee bar code with the checksum added
+      code = ""
+      for digit in self.EAN13:
+         code += "%d"%digit
+      
+      # Create a new image
+      position = 8
+      im = Image.new("1",(len(bits)+position,height))
+      
+      # Load font
+      ad = os.path.abspath(os.path.join(ustr(config['root_path']), u'addons'))
+      mod_path_list = map(lambda m: os.path.abspath(ustr(m.strip())), config['addons_path'].split(','))
+      mod_path_list.append(ad)
+
+      for mod_path in mod_path_list:
+          font_file = mod_path+os.path.sep+ \
+                      "report_aeroo"+os.path.sep+"barcode"+os.path.sep+"FreeMonoBold.ttf"
+          if os.path.lexists(font_file):
+              font = ImageFont.truetype(font_file, fontsize)
+      
+      # Create drawer
+      draw = ImageDraw.Draw(im)
+      
+      # Erase image
+      draw.rectangle(((0,0),(im.size[0],im.size[1])),fill=256)
+      
+      # Draw first part of number
+      draw.text((0, height-9), code[0], font=font, fill=0)
+      
+      # Draw first part of number
+      draw.text((position+7, height-9), code[1:7], font=font, fill=0)
+         
+      # Draw second part of number
+      draw.text((len(bits)/2+6+position, height-9), code[7:], font=font, fill=0)
+      
+      # Draw the bar codes
+      for bit in range(len(bits)):
+         # Draw normal bar
+         if bits[bit] == '1':
+            draw.rectangle(((bit+position,0),(bit+position,height-10)),fill=0)
+         # Draw long bar
+         elif bits[bit] == 'L':
+            draw.rectangle(((bit+position,0),(bit+position,height-3)),fill=0)
+            
+      # Save the result image
+      return im
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:

=== added file 'report_aeroo/barcode/FreeMonoBold.ttf'
Binary files report_aeroo/barcode/FreeMonoBold.ttf	1970-01-01 00:00:00 +0000 and report_aeroo/barcode/FreeMonoBold.ttf	2014-04-05 13:18:49 +0000 differ
=== added file 'report_aeroo/barcode/__init__.py'
--- report_aeroo/barcode/__init__.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/barcode/__init__.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,34 @@
+##############################################################################
+#
+# Copyright (c) 2008-2011 Alistek Ltd (http://www.alistek.com) All Rights Reserved.
+#                    General contacts <[e-mail]>
+#
+# WARNING: This program as such is intended to be used by professional
+# programmers who take the whole responsability of assessing all potential
+# consequences resulting from its eventual inadequacies and bugs
+# End users who are looking for a ready-to-use solution with commercial
+# garantees and support are strongly adviced to contract a Free Software
+# Service Company
+#
+# 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 module is GPLv3 or newer and incompatible
+# with OpenERP SA "AGPL + Private Use License"!
+#
+# 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, write to the Free Software
+# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
+#
+##############################################################################
+
+import barcode
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:

=== added file 'report_aeroo/barcode/barcode.py'
--- report_aeroo/barcode/barcode.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/barcode/barcode.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,63 @@
+##############################################################################
+#
+# Copyright (c) 2008-2011 Alistek Ltd (http://www.alistek.com) All Rights Reserved.
+#                    General contacts <[e-mail]>
+#
+# WARNING: This program as such is intended to be used by professional
+# programmers who take the whole responsability of assessing all potential
+# consequences resulting from its eventual inadequacies and bugs
+# End users who are looking for a ready-to-use solution with commercial
+# garantees and support are strongly adviced to contract a Free Software
+# Service Company
+#
+# 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 module is GPLv3 or newer and incompatible
+# with OpenERP SA "AGPL + Private Use License"!
+#
+# 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, write to the Free Software
+# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
+#
+##############################################################################
+
+from .code128 import get_code
+from .code39 import create_c39
+from .EANBarCode import EanBarCode
+try:
+    from cStringIO import StringIO
+except ImportError:
+    from StringIO import StringIO
+
+def make_barcode(code, code_type='ean13', rotate=None, height=50, xw=1):
+    if code:
+        if code_type.lower()=='ean13':
+            bar=EanBarCode()
+            im = bar.getImage(code,height)
+        elif code_type.lower()=='code128':
+            im = get_code(code, xw, height)
+        elif code_type.lower()=='code39':
+            im = create_c39(height, xw, code)
+    else:
+        return StringIO(), 'image/png'
+
+    tf = StringIO()
+    try:
+        if rotate!=None:
+            im=im.rotate(int(rotate))
+    except Exception, e:
+        pass
+    im.save(tf, 'png')
+    size_x = str(im.size[0]/96.0)+'in'
+    size_y = str(im.size[1]/96.0)+'in'
+    return tf, 'image/png', size_x, size_y
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:

=== added file 'report_aeroo/barcode/code128.py'
--- report_aeroo/barcode/code128.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/barcode/code128.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,189 @@
+# Copyright (c) 2009-2011 Alistek Ltd (http://www.alistek.com) All Rights Reserved.
+#                    General contacts <[e-mail]>
+# This list was cut'n'pasted verbatim from the "Code 128 Specification Page"
+# at http://www.adams1.com/pub/russadam/128code.html
+
+codelist="""0 	SP 	SP 	00 	2 1 2 2 2 2
+1 	! 	! 	01 	2 2 2 1 2 2
+2 	" 	" 	02 	2 2 2 2 2 1
+3 	# 	# 	03 	1 2 1 2 2 3
+4 	$ 	$ 	04 	1 2 1 3 2 2
+5 	% 	% 	05 	1 3 1 2 2 2
+6 	& 	& 	06 	1 2 2 2 1 3
+7 	' 	' 	07 	1 2 2 3 1 2
+8 	( 	( 	08 	1 3 2 2 1 2
+9 	) 	) 	09 	2 2 1 2 1 3
+10 	* 	* 	10 	2 2 1 3 1 2
+11 	+ 	+ 	11 	2 3 1 2 1 2
+12 	, 	, 	12 	1 1 2 2 3 2
+13 	- 	- 	13 	1 2 2 1 3 2
+14 	. 	. 	14 	1 2 2 2 3 1
+15 	/ 	/ 	15 	1 1 3 2 2 2
[phone]
[phone]
[phone]
[phone]
[phone]
[phone]
[phone]
[phone]
[phone]
[phone]
+26 	: 	: 	26 	3 2 1 2 2 1
+27 	; 	; 	27 	3 1 2 2 1 2
+28 	< 	< 	28 	3 2 2 1 1 2
+29 	= 	= 	29 	3 2 2 2 1 1
+30 	> 	> 	30 	2 1 2 1 2 3
+31 	? 	? 	31 	2 1 2 3 2 1
+32 	@ 	@ 	32 	2 3 2 1 2 1
+33 	A 	A 	33 	1 1 1 3 2 3
+34 	B 	B 	34 	1 3 1 1 2 3
+35 	C 	C 	35 	1 3 1 3 2 1
+36 	D 	D 	36 	1 1 2 3 1 3
+37 	E 	E 	37 	1 3 2 1 1 3
+38 	F 	F 	38 	1 3 2 3 1 1
+39 	G 	G 	39 	2 1 1 3 1 3
+40 	H 	H 	40 	2 3 1 1 1 3
+41 	I 	I 	41 	2 3 1 3 1 1
+42 	J 	J 	42 	1 1 2 1 3 3
+43 	K 	K 	43 	1 1 2 3 3 1
+44 	L 	L 	44 	1 3 2 1 3 1
+45 	M 	M 	45 	1 1 3 1 2 3
+46 	N 	N 	46 	1 1 3 3 2 1
+47 	O 	O 	47 	1 3 3 1 2 1
+48 	P 	P 	48 	3 1 3 1 2 1
+49 	Q 	Q 	49 	2 1 1 3 3 1
+50 	R 	R 	50 	2 3 1 1 3 1
+51 	S 	S 	51 	2 1 3 1 1 3
+52 	T 	T 	52 	2 1 3 3 1 1
+53 	U 	U 	53 	2 1 3 1 3 1
+54 	V 	V 	54 	3 1 1 1 2 3
+55 	W 	W 	55 	3 1 1 3 2 1
+56 	X 	X 	56 	3 3 1 1 2 1
+57 	Y 	Y 	57 	3 1 2 1 1 3
+58 	Z 	Z 	58 	3 1 2 3 1 1
+59 	[ 	[ 	59 	3 3 2 1 1 1
+60 	\\ 	\\ 	60 	3 1 4 1 1 1
+61 	] 	] 	61 	2 2 1 4 1 1
+62 	^ 	^ 	62 	4 3 1 1 1 1
+63 	_ 	_ 	63 	1 1 1 2 2 4
+64 	NUL 	' 	64 	1 1 1 4 2 2
+65 	SOH 	a 	65 	1 2 1 1 2 4
+66 	STX 	b 	66 	1 2 1 4 2 1
+67 	ETX 	c 	67 	1 4 1 1 2 2
+68 	EOT 	d 	68 	1 4 1 2 2 1
+69 	ENQ 	e 	69 	1 1 2 2 1 4
+70 	ACK 	f 	70 	1 1 2 4 1 2
+71 	BEL 	g 	61 	1 2 2 1 1 4
+72 	BS 	h 	72 	1 2 2 4 1 1
+73 	HT 	i 	73 	1 4 2 1 1 2
+74 	LF 	j 	74 	1 4 2 2 1 1
+75 	VT 	k 	75 	2 4 1 2 1 1
+76 	FF 	l 	76 	2 2 1 1 1 4
+77 	CR 	m 	77 	4 1 3 1 1 1
+78 	SO 	n 	78 	2 4 1 1 1 2
+79 	SI 	o 	79 	1 3 4 1 1 1
+80 	DLE 	p 	80 	1 1 1 2 4 2
+81 	DC1 	q 	81 	1 2 1 1 4 2
+82 	DC2 	r 	82 	1 2 1 2 4 1
+83 	DC3 	s 	83 	1 1 4 2 1 2
+84 	DC4 	t 	84 	1 2 4 1 1 2
+85 	NAK 	u 	85 	1 2 4 2 1 1
+86 	SYN 	v 	86 	4 1 1 2 1 2
+87 	ETB 	w 	87 	4 2 1 1 1 2
+88 	CAN 	x 	88 	4 2 1 2 1 1
+89 	EM 	y 	89 	2 1 2 1 4 1
+90 	SUB 	z 	90 	2 1 4 1 2 1
+91 	ESC 	{ 	91 	4 1 2 1 2 1
+92 	FS 	| 	92 	1 1 1 1 4 3
+93 	GS 	} 	93 	1 1 1 3 4 1
+94 	RS 	~ 	94 	1 3 1 1 4 1
+95 (Hex 7F) 	US 	DEL 	95 	1 1 4 1 1 3
+96 (Hex 80) 	FNC 3 	FNC 3 	96 	1 1 4 3 1 1
+97 (Hex 81) 	FNC 2 	FNC 2 	97 	4 1 1 1 1 3
+98 (Hex 82) 	SHIFT 	SHIFT 	98 	4 1 1 3 1 1
+99 (Hex 83) 	CODE C 	CODE C 	99 	1 1 3 1 4 1
+100 (Hex 84) 	CODE B 	FNC 4 	CODE B 	1 1 4 1 3 1
+101 (Hex 85) 	FNC 4 	CODE A 	CODE A 	3 1 1 1 4 1
+102 (Hex 86) 	FNC 1 	FNC 1 	FNC 1 	4 1 1 1 3 1"""
+
+
+
+
+other="""103 (Hex 87) 	START (Code A) 	2 1 1 4 1 2
+104 (Hex 88) 	START (Code B) 	2 1 1 2 1 4
+105 (Hex 89) 	START (Code C) 	2 1 1 2 3 2
+106 	STOP 	2 3 3 1 1 1 2"""
+
+
+codes={}
+values={}
+for l in codelist.split('\n'):
+    l.strip()
+    num,a1,b1,c1,code=l.split('\t')
+    num=int(num.split(' ')[0])
+    values[num]=[int(x) for x in code.split()]
+    codes[b1.strip()]=num
+
+codes[' ']=codes['SP']
+
+for l in other.split('\n'):
+    l.strip()
+    num,name,code=l.split('\t')
+    num=int(num.split(' ')[0])
+    values[num]=[int(x) for x in code.split()]
+    codes[name.strip()]=num
+
+def encode_message(msg):
+    startnum=codes['START (Code B)']
+    message=values[startnum][:]
+    chksum=startnum
+    mult=1
+    for c in msg:
+        if not codes.has_key(c):
+            raise "No code for "+c
+        chksum=chksum+mult*codes[c]
+        mult=mult+1
+        message=message+values[codes[c]]
+
+    chksum=chksum%103
+
+    message=message+values[chksum]
+    message=message+values[codes['STOP']]
+
+    return message
+
+
+import os
+try:
+    from PIL import Image
+except:
+    _logger.warning("ERROR IMPORTING PIL, if not installed, please install it:"
+    " get it here: https://pypi.python.org/pypi/PIL")
+def get_code(message,xw=1,h=100,rotate=None):
+    """ message is message to code.
+        xw is horizontal multiplier (in pixels width of narrowest bar)
+        h is height in pixels.
+
+        Returns a Python Imaging Library object."""
+
+    widths=[xw*20]+encode_message(message)+[xw*20]
+
+    bits=[]
+    i=1
+    for w in widths:
+        bits=bits+[i]*w*xw
+        i=1-i
+
+    #print len(bits)
+    #print bits
+
+    i=Image.new('1',(len(bits),h),1)
+
+    for b in range(len(bits)):
+        for y in range(h):
+            i.putpixel((b,y),255*bits[b])
+
+    return i
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:

=== added file 'report_aeroo/barcode/code39.py'
--- report_aeroo/barcode/code39.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/barcode/code39.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,166 @@
+# Copyright (c) 2008 marscel.wordpress.com
+#
+# Copyright (c) 2011 Alistek Ltd (http://www.alistek.com) All Rights Reserved.
+#                    General contacts <[e-mail]>
+
+# Code39.py v1
+# Requires Python and Python Imaging Library (PIL), 
+# has been tested with Python v2.6 and PIL v1.1.6
+
+# Usage example:
+# code39.py 100 2 "Hello World" barcode.png
+#
+# This creates a PNG image "barcode.png" containing a barcode of the height of 100px
+# a min line width of 2px with "Hello World" encoded as "*HELLO WORLD*" in Code 39
+try:
+    from PIL import Image, ImageDraw, ImageFont
+except:
+    _logger.warning("ERROR IMPORTING PIL, if not installed, please install it:"
+    " get it here: https://pypi.python.org/pypi/PIL")
+from openerp.tools import config, ustr
+import os, sys
+
+marginx = 10
+marginy = 10
+fontsize = 15
+
+charmap = {
+'*':[0,3,0,1,2,1,2,1,0],
+'-':[0,3,0,1,0,1,2,1,2],
+'$':[0,3,0,3,0,3,0,1,0],
+'%':[0,1,0,3,0,3,0,3,0],
+' ':[0,3,2,1,0,1,2,1,0],
+'.':[2,3,0,1,0,1,2,1,0],
+'/':[0,3,0,3,0,1,0,3,0],
+'+':[0,3,0,1,0,3,0,3,0],
+'0':[0,1,0,3,2,1,2,1,0],
+'1':[2,1,0,3,0,1,0,1,2],
+'2':[0,1,2,3,0,1,0,1,2],
+'3':[2,1,2,3,0,1,0,1,0],
+'4':[0,1,0,3,2,1,0,1,2],
+'5':[2,1,0,3,2,1,0,1,0],
+'6':[0,1,2,3,2,1,0,1,0],
+'7':[0,1,0,3,0,1,2,1,2],
+'8':[2,1,0,3,0,1,2,1,0],
+'9':[0,1,2,3,0,1,2,1,0],
+'A':[2,1,0,1,0,3,0,1,2],
+'B':[0,1,2,1,0,3,0,1,2],
+'C':[2,1,2,1,0,3,0,1,0],
+'D':[0,1,0,1,2,3,0,1,2],
+'E':[2,1,0,1,2,3,0,1,0],
+'F':[0,1,2,1,2,3,0,1,0],
+'G':[0,1,0,1,0,3,2,1,2],
+'H':[2,1,0,1,0,3,2,1,0],
+'I':[0,1,2,1,0,3,2,1,0],
+'J':[0,1,0,1,2,3,2,1,0],
+'K':[2,1,0,1,0,1,0,3,2],
+'L':[0,1,2,1,0,1,0,3,2],
+'M':[2,1,2,1,0,1,0,3,0],
+'N':[0,1,0,1,2,1,0,3,2],
+'O':[2,1,0,1,2,1,0,3,0],
+'P':[0,1,2,1,2,1,0,3,0],
+'Q':[0,1,0,1,0,1,2,3,2],
+'R':[2,1,0,1,0,1,2,3,0],
+'S':[0,1,2,1,0,1,2,3,0],
+'T':[0,1,0,1,2,1,2,3,0],
+'U':[2,3,0,1,0,1,0,1,2],
+'V':[0,3,2,1,0,1,0,1,2],
+'W':[2,3,2,1,0,1,0,1,0],
+'X':[0,3,0,1,2,1,0,1,2],
+'Y':[2,3,0,1,2,1,0,1,0],
+'Z':[0,3,2,1,2,1,0,1,0]
+}
+
+def create_c39(height, smallest, text):
+    pixel_length = 0
+    i = 0
+    newtext = ""
+    machinetext = "*" + text + "*"
+    seglist = []
+    while i < len(machinetext):
+        char = machinetext[i].capitalize()
+        i = i + 1
+        try:
+            cmap = charmap[char]
+            if len(cmap) != 9:
+                continue
+            
+            j = 0
+            while j < 9:
+                seg = int(cmap[j])
+                
+                if seg == 0 or seg == 1:
+                    pixel_length = pixel_length + smallest
+                    seglist.append(seg)
+                elif seg == 2 or seg == 3:
+                    pixel_length = pixel_length + smallest * 3
+                    seglist.append(seg)
+                
+                j = j + 1
+            
+            newtext += char
+        except:
+            continue
+    
+    pixel_length = pixel_length + 2*marginx + len(newtext) * smallest
+    pixel_height = height + 2*marginy + fontsize
+    
+    barcode_img = Image.new('RGB', [pixel_length, pixel_height], "white")
+    
+    if len(seglist) == 0:
+        return barcode_img
+    
+    i = 0
+    draw = ImageDraw.Draw(barcode_img)
+    current_x = marginx
+    
+    while i < len(seglist):
+        seg = seglist[i]
+        color = (255, 255, 255)
+        wdth = smallest
+        
+        if seg == 0 or seg == 2:
+            color = 0
+            if seg == 0:
+                wdth = smallest
+            else:
+                wdth = smallest * 3
+        elif seg == 1 or seg == 3:
+            color = (255, 255, 255)
+            if seg == 1:
+                wdth = smallest
+            else:
+                wdth = smallest * 3
+        
+        j = 1
+        
+        while j <= wdth:
+            draw.line((current_x, marginy, current_x, marginy+height), fill=color)
+            current_x = current_x + 1            
+            j = j + 1
+        
+        if ((i+1) % 9) == 0:        
+            j = 1
+            while j <= smallest:
+                draw.line((current_x, marginy, current_x, marginy+height), fill=(255,255,255))
+                current_x = current_x + 1
+                j = j + 1            
+        i = i + 1
+
+    ad = os.path.abspath(os.path.join(ustr(config['root_path']), u'addons'))
+    mod_path_list = map(lambda m: os.path.abspath(ustr(m.strip())), config['addons_path'].split(','))
+    mod_path_list.append(ad)
+
+    for mod_path in mod_path_list:
+        font_file = mod_path+os.path.sep+ \
+                    "report_aeroo"+os.path.sep+"barcode"+os.path.sep+"FreeMonoBold.ttf"
+        if os.path.lexists(font_file):
+            font = ImageFont.truetype(font_file, fontsize)
+    
+    draw.text((pixel_length/2 - len(newtext)*(fontsize/2)/2-len(newtext), height+fontsize), newtext, font=font, fill=0)
+    
+    del draw
+    
+    return barcode_img
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:

=== added file 'report_aeroo/barcode/courB08.pbm'
Binary files report_aeroo/barcode/courB08.pbm	1970-01-01 00:00:00 +0000 and report_aeroo/barcode/courB08.pbm	2014-04-05 13:18:49 +0000 differ
=== added file 'report_aeroo/barcode/courB08.pil'
Binary files report_aeroo/barcode/courB08.pil	1970-01-01 00:00:00 +0000 and report_aeroo/barcode/courB08.pil	2014-04-05 13:18:49 +0000 differ
=== added file 'report_aeroo/check_deps.py'
--- report_aeroo/check_deps.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/check_deps.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,52 @@
+# -*- encoding: utf-8 -*-
+##############################################################################
+#
+# Copyright (c) 2009-2011 Alistek Ltd (http://www.alistek.com) All Rights Reserved.
+#                    General contacts <[e-mail]>
+#
+# WARNING: This program as such is intended to be used by professional
+# programmers who take the whole responsability of assessing all potential
+# consequences resulting from its eventual inadequacies and bugs
+# End users who are looking for a ready-to-use solution with commercial
+# garantees and support are strongly adviced to contract a Free Software
+# Service Company
+#
+# 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 module is GPLv3 or newer and incompatible
+# with OpenERP SA "AGPL + Private Use License"!
+#
+# 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, write to the Free Software
+# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
+#
+##############################################################################
+
+from openerp.osv import orm
+from openerp.tools.translate import _
+
+__all__ = [
+    'check_deps',
+]
+
+def check_deps(check_list):
+    error = False
+    import_errors = []
+    for imp in check_list:
+        try:
+            exec imp in {}
+        except ImportError,e:
+            error = True
+            import_errors.append(str(e))
+    if error:
+        raise orm.except_orm(_('Warning!')+' '+_('Unmet python dependencies!'), '\n'.join(import_errors))
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:

=== added directory 'report_aeroo/config_pixmaps'
=== added file 'report_aeroo/config_pixmaps/module_banner.png'
Binary files report_aeroo/config_pixmaps/module_banner.png	1970-01-01 00:00:00 +0000 and report_aeroo/config_pixmaps/module_banner.png	2014-04-05 13:18:49 +0000 differ
=== added directory 'report_aeroo/ctt_languages'
=== added file 'report_aeroo/ctt_languages/__init__.py'
--- report_aeroo/ctt_languages/__init__.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_languages/__init__.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,3 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+# Please do not edit this file!

=== added directory 'report_aeroo/ctt_languages/en_US'
=== added file 'report_aeroo/ctt_languages/en_US/__init__.py'
--- report_aeroo/ctt_languages/en_US/__init__.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_languages/en_US/__init__.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,91 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+# en_US
+
+from report_aeroo.ctt_objects import ctt_language
+
+class en_US(ctt_language):
+    def _init_lang(self):
+        # language name
+        self.name = 'en_US'
+        # digits - masculine, singular
+        self.digits_sng_msc = [u'zero', u'one', u'two', u'three', u'four',
+                               u'five', u'six', u'seven', u'eight', u'nine']
+        # tens - masculine, singular
+        self.tens_sng_msc = [u'', u'one', u'twen', u'thir', u'four', u'fif',
+                             u'six', u'seven', u'eigh', u'nine']
+        # teens - masculine
+        self.teens = [u'ten', u'eleven', u'twelve', u'thirteen', u'fourteen',
+                      u'fifteen', u'sixteen', u'seventeen', u'eighteen',
+                      u'nineteen']
+        # multiplier - masculine, singular
+        self.multi_sng_msc = [u' hundred', u' thousand', u' million',
+                              u' billion']
+        # multiplier - masculine, plural
+        self.multi_plr_msc = [u' hundreds', u' thousands', u' millions',
+                              u' billions']
+        
+        # next line is needed for correct loading of currencies 
+        import currencies
+        return currencies
+
+
+    def wordify(self, chunk, chunknr, gender):
+        if gender == 'm':
+            number = self.digits_sng_msc
+        elif gender == 'f':
+            number = self.digits_sng_fem
+        elif gender == 'n':
+            number = self.digits_sng_neu
+        words = u''
+        digit1 = u''
+        digit2 = u''
+        digit3 = u''
+        chunklength = len(chunk)
+        # placing digits in right places
+        if chunklength == 1:
+            digit3 = chunk[0 : 1]
+        if chunklength == 2:
+            digit2 = chunk[0 : 1]
+            digit3 = chunk[1 : 2]
+        if chunklength == 3:
+            digit1 = chunk[0 : 1]
+            digit2 = chunk[1 : 2]
+            digit3 = chunk[-1]
+        # processing zero
+        if chunklength == 1 and digit3  == '0' :
+            return number[0]
+        # processing hundreds
+        if chunklength == 3 :
+            if digit1 == '1' :
+                words += self.digits_sng_msc[int(digit1)] + self.multi_sng_msc[0]
+            else :
+                if int(digit1) >= 1 : words += self.digits_sng_msc[int(digit1)] + self.multi_plr_msc[0]
+        # processing tens
+        if chunklength > 1:
+            spacer = ''
+            if len(words) > 0 : spacer = u' '
+            if digit2 == '1':
+                words += spacer + self.teens[int(digit3)]
+            else:
+                if int(digit2) > 1 and int(digit2) > 0:
+                    words += spacer + self.tens_sng_msc[int(digit2)] + u'ty'
+
+        # processing ones
+        if chunklength > 0 and digit2 != '1' :
+            spacer = ''
+            if len(words) > 0: spacer = u' '
+            if int(digit3) > 0:
+                words += spacer + number[int(digit3)]
+        # end processing
+        if len(words) > 0 :
+            if digit3 == '1' and chunknr > 0:
+                return words + self.multi_sng_msc[chunknr]
+            elif digit3 != '1' and chunknr > 0:
+                return words + self.multi_sng_msc[chunknr]
+            else:
+                return words
+        else:
+            return ''
+
+en_US()

=== added directory 'report_aeroo/ctt_languages/en_US/currencies'
=== added file 'report_aeroo/ctt_languages/en_US/currencies/__init__.py'
--- report_aeroo/ctt_languages/en_US/currencies/__init__.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_languages/en_US/currencies/__init__.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,3 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+# Please do not edit this file!

=== added file 'report_aeroo/ctt_languages/en_US/currencies/eur.py'
--- report_aeroo/ctt_languages/en_US/currencies/eur.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_languages/en_US/currencies/eur.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,19 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+
+from report_aeroo.ctt_objects import ctt_currency
+
+class eur(ctt_currency):
+    def _init_currency(self):
+        self.language = u'en_US'
+        self.code = u'EUR'
+        self.fractions = 100
+        self.cur_singular = u' euro'
+        self.cur_plural = u' euro'
+        self.frc_singular = u' cent'
+        self.frc_plural = u' cents'
+        # grammatical genders: f - feminine, m - masculine, n -neuter
+        self.cur_gram_gender = 'm'
+        self.frc_gram_gender = 'm'
+    
+eur()

=== added file 'report_aeroo/ctt_languages/en_US/currencies/ltl.py'
--- report_aeroo/ctt_languages/en_US/currencies/ltl.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_languages/en_US/currencies/ltl.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,19 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+
+from report_aeroo.ctt_objects import ctt_currency
+
+class ltl(ctt_currency):
+    def _init_currency(self):
+        self.language = u'en_US'
+        self.code = u'LTL'
+        self.fractions = 100
+        self.cur_singular = u' Lithuanian litas'
+        self.cur_plural = u' Lithuanian litas'
+        self.frc_singular = u' cent'
+        self.frc_plural = u' cents'
+        # grammatical genders: f - feminine, m - masculine, n -neuter
+        self.cur_gram_gender = 'm'
+        self.frc_gram_gender = 'm'
+    
+ltl()

=== added file 'report_aeroo/ctt_languages/en_US/currencies/lvl.py'
--- report_aeroo/ctt_languages/en_US/currencies/lvl.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_languages/en_US/currencies/lvl.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,19 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+
+from report_aeroo.ctt_objects import ctt_currency
+
+class lvl(ctt_currency):
+    def _init_currency(self):
+        self.language = u'en_US'
+        self.code = u'LVL'
+        self.fractions = 100
+        self.cur_singular = u' lat'
+        self.cur_plural = u' lats'
+        self.frc_singular = u' santim'
+        self.frc_plural = u' santims'
+        # grammatical genders: f - feminine, m - masculine, n -neuter
+        self.cur_gram_gender = 'm'
+        self.frc_gram_gender = 'm'
+    
+lvl()

=== added file 'report_aeroo/ctt_languages/en_US/currencies/mxn.py'
--- report_aeroo/ctt_languages/en_US/currencies/mxn.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_languages/en_US/currencies/mxn.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,19 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+
+from report_aeroo.ctt_objects import ctt_currency
+
+class mxn(ctt_currency):
+    def _init_currency(self):
+        self.language = u'en_US'
+        self.code = u'MXN'
+        self.fractions = 100
+        self.cur_singular = u' Mexican peso'
+        self.cur_plural = u' Mexican pesos'
+        self.frc_singular = u' cent'
+        self.frc_plural = u' cents'
+        # grammatical genders: f - feminine, m - masculine, n -neuter
+        self.cur_gram_gender = 'm'
+        self.frc_gram_gender = 'm'
+    
+mxn()

=== added file 'report_aeroo/ctt_languages/en_US/currencies/trl.py'
--- report_aeroo/ctt_languages/en_US/currencies/trl.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_languages/en_US/currencies/trl.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,19 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+
+from report_aeroo.ctt_objects import ctt_currency
+
+class trl(ctt_currency):
+    def _init_currency(self):
+        self.language = u'en_US'
+        self.code = u'TRL'
+        self.fractions = 100
+        self.cur_singular = u' Turkish lira'
+        self.cur_plural = u' Turkish Liras'
+        self.frc_singular = u' kurus'
+        self.frc_plural = u' kuruss'
+        # grammatical genders: f - feminine, m - masculine, n -neuter
+        self.cur_gram_gender = 'm'
+        self.frc_gram_gender = 'm'
+    
+trl()

=== added file 'report_aeroo/ctt_languages/en_US/currencies/usd.py'
--- report_aeroo/ctt_languages/en_US/currencies/usd.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_languages/en_US/currencies/usd.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,19 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+
+from report_aeroo.ctt_objects import ctt_currency
+
+class usd(ctt_currency):
+    def _init_currency(self):
+        self.language = u'en_US'
+        self.code = u'USD'
+        self.fractions = 100
+        self.cur_singular = u' US dollar'
+        self.cur_plural = u' US dollars'
+        self.frc_singular = u' cent'
+        self.frc_plural = u' cents'
+        # grammatical genders: f - feminine, m - masculine, n -neuter
+        self.cur_gram_gender = 'm'
+        self.frc_gram_gender = 'm'
+    
+usd()

=== added directory 'report_aeroo/ctt_languages/es_ES'
=== added file 'report_aeroo/ctt_languages/es_ES/__init__.py'
--- report_aeroo/ctt_languages/es_ES/__init__.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_languages/es_ES/__init__.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,102 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+# es_ES
+################################################################################
+# Spanish language support assembled from contributions provided by:
+#       * mechiscogo
+#       * Christopher Ormaza - Ecuadorenlinea.net <[e-mail]>, 2011
+################################################################################
+
+from report_aeroo.ctt_objects import ctt_language
+
+class es_ES(ctt_language):
+    def _init_lang(self):
+        # language name
+        self.name = 'es_ES'
+        # digits - masculine, singular
+        self.digits_sng_msc = [u'cero', u'uno', u'dos', u'tres', u'cuatro',
+                               u'cinco', u'seis', u'siete', u'ocho', u'nueve']
+
+        # tens - masculine, singular
+        self.tens_sng_msc = [u'', u'', u'veint', u'treinta', u'cuarenta',
+                             u'cincuenta', u'sesenta', u'setenta', u'ochenta',
+                             u'noventa ']
+        
+        # teens - masculine
+        self.teens = [u'diez', u'once', u'doce', u'trece', u'catorce',
+                      u'quince', u'dieciséis', u'diecisiete', u'dieciocho',
+                      u'diecinueve']
+
+        # multiplier - masculine, singular
+        self.multi_sng_msc = [u'cien', u' mil', u' millón', u' billón']
+
+        # multiplier - masculine, plural
+        self.multi_plr_msc = [u'cientos', u' mil', u' millones', u' billones']
+        
+        # next line is needed for correct loading of currencies 
+        import currencies
+        return currencies
+
+
+    def wordify(self, chunk, chunknr, gender):
+        if gender == 'm':
+            number = self.digits_sng_msc
+        elif gender == 'f':
+            number = self.digits_sng_fem
+        elif gender == 'n':
+            number = self.digits_sng_neu
+        words = u''
+        digit1 = u''
+        digit2 = u''
+        digit3 = u''
+        chunklength = len(chunk)
+        # placing digits in right places
+        if chunklength == 1:
+            digit3 = chunk[0 : 1]
+        if chunklength == 2:
+            digit2 = chunk[0 : 1]
+            digit3 = chunk[1 : 2]
+        if chunklength == 3:
+            digit1 = chunk[0 : 1]
+            digit2 = chunk[1 : 2]
+            digit3 = chunk[-1]
+        # processing zero
+        if chunklength == 1 and digit3  == '0' :
+            return number[0]
+        # processing hundreds
+        if chunklength == 3 :
+            if digit1 == '1' :
+                words += self.multi_sng_msc[0]
+            else :
+                if int(digit1) >= 1 : words += self.digits_sng_msc[int(digit1)]\
+                                                         + self.multi_plr_msc[0]
+        # processing tens
+        if chunklength > 1:
+            spacer = ''
+            if len(words) > 0 : spacer = u' '
+            if digit2 == '1':
+                words += spacer + self.teens[int(digit3)]
+            else:
+                if int(digit2) > 1 and int(digit2) > 0:
+                    words += spacer + self.tens_sng_msc[int(digit2)]
+                if int(digit3) > 0:
+                    words += u' y'
+
+        # processing ones
+        if chunklength > 0 and digit2 != '1' :
+            spacer = ''
+            if len(words) > 0: spacer = u' '
+            if int(digit3) > 0:
+                words += spacer + number[int(digit3)]
+        # end processing
+        if len(words) > 0 :
+            if digit3 == '1' and chunknr > 0:
+                return words + self.multi_sng_msc[chunknr]
+            elif digit3 != '1' and chunknr > 0:
+                return words + self.multi_plr_msc[chunknr]
+            else:
+                return words
+        else:
+            return ''
+
+es_ES()

=== added directory 'report_aeroo/ctt_languages/es_ES/currencies'
=== added file 'report_aeroo/ctt_languages/es_ES/currencies/__init__.py'
--- report_aeroo/ctt_languages/es_ES/currencies/__init__.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_languages/es_ES/currencies/__init__.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,3 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+# Please do not edit this file!

=== added file 'report_aeroo/ctt_languages/es_ES/currencies/eur.py'
--- report_aeroo/ctt_languages/es_ES/currencies/eur.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_languages/es_ES/currencies/eur.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,19 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+
+from report_aeroo.ctt_objects import ctt_currency
+
+class eur(ctt_currency):
+    def _init_currency(self):
+        self.language = u'es_ES'
+        self.code = u'EUR'
+        self.fractions = 100
+        self.cur_singular = u' euro'
+        self.cur_plural = u' euros'
+        self.frc_singular = u' centavo'
+        self.frc_plural = u' centavos'
+        # grammatical genders: f - feminine, m - masculine, n -neuter
+        self.cur_gram_gender = 'm'
+        self.frc_gram_gender = 'm'
+    
+eur()

=== added file 'report_aeroo/ctt_languages/es_ES/currencies/mxn.py'
--- report_aeroo/ctt_languages/es_ES/currencies/mxn.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_languages/es_ES/currencies/mxn.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,19 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+
+from report_aeroo.ctt_objects import ctt_currency
+
+class mxn(ctt_currency):
+    def _init_currency(self):
+        self.language = u'es_ES'
+        self.code = u'MXN'
+        self.fractions = 100
+        self.cur_singular = u' peso'
+        self.cur_plural = u' pesos'
+        self.frc_singular = u' centavo'
+        self.frc_plural = u' centavos'
+        # grammatical genders: f - feminine, m - masculine, n -neuter
+        self.cur_gram_gender = 'm'
+        self.frc_gram_gender = 'm'
+    
+mxn()

=== added file 'report_aeroo/ctt_languages/es_ES/currencies/usd.py'
--- report_aeroo/ctt_languages/es_ES/currencies/usd.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_languages/es_ES/currencies/usd.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,19 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+
+from report_aeroo.ctt_objects import ctt_currency
+
+class usd(ctt_currency):
+    def _init_currency(self):
+        self.language = u'es_ES'
+        self.code = u'USD'
+        self.fractions = 100
+        self.cur_singular = u' dólar Américano'
+        self.cur_plural = u' dólares Américanos'
+        self.frc_singular = u' centavo'
+        self.frc_plural = u' centavos'
+        # grammatical genders: f - feminine, m - masculine, n -neuter
+        self.cur_gram_gender = 'm'
+        self.frc_gram_gender = 'm'
+    
+usd()

=== added directory 'report_aeroo/ctt_languages/lt_LT'
=== added file 'report_aeroo/ctt_languages/lt_LT/__init__.py'
--- report_aeroo/ctt_languages/lt_LT/__init__.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_languages/lt_LT/__init__.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,107 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+# lt_LT
+################################################################################
+#
+# Lithuanian language support assembled from contributions provided by:
+# Paulius Sladkevičius
+#
+################################################################################
+
+from report_aeroo.ctt_objects import ctt_language
+
+class lt_LT(ctt_language):
+    def _init_lang(self):
+        self.name = 'lt_LT'
+        # digits - masculine, singular
+        self.number_sng_msc = [u'nulis', u'vienas', u'du', u'trys', u'keturi',
+                               u'penkti', u'šeši', u'septyni', u'aštuoni',
+                               u'devyni']
+        # tens - masculine, singular
+        self.tens_sng_msc = [u'nulis', u'vienas', u'dvi', u'tris',
+                               u'keturias', u'penkias', u'šešias', u'septynias',
+                               u'aštuonias', u'devynias']
+        # teens - masculine
+        self.teens = [u'dešimt', u'vienuolika', u'dvylika', u'trylika',
+                      u'keturiolika', u'penkiolika', u'šešiolika',
+                      u'septyniolika', u'aštuonolika', u'devyniolika']
+        # multiplier - masculine, singular
+        self.multi_sng_msc = [u' šimtas', u' tūkstantis', u' milijonas',
+                              u' milijardas']
+        # multiplier - masculine, plural
+        self.multi_plr_msc = [u' šimtai', u' tūkstančiai', u' milijonai',
+                              u' milijardai']
+        # multiplier - masculine, plural (other form)
+        self.multi_plr_msc_2 = [u' šimtų', u' tūkstančių', u' milijonų',
+                              u' milijardų']
+        
+        # next line is needed for correct loading of currencies 
+        import currencies
+        return currencies
+
+
+    def wordify(self, chunk, chunknr, gender):
+        if gender == 'm':
+            number = self.number_sng_msc
+        elif gender == 'f':
+            number = self.number_sng_fem
+        elif gender == 'n':
+            number = self.number_sng_neu
+        words = u''
+        digit1 = u''
+        digit2 = u''
+        digit3 = u''
+        chunklength = len(chunk)
+        # placing digits in right places
+        if chunklength == 1:
+            digit3 = chunk[0 : 1]
+        if chunklength == 2:
+            digit2 = chunk[0 : 1]
+            digit3 = chunk[1 : 2]
+        if chunklength == 3:
+            digit1 = chunk[0 : 1]
+            digit2 = chunk[1 : 2]
+            digit3 = chunk[-1]
+        # processing zero
+        if chunklength == 1 and digit3  == '0' :
+            return number[0]
+        # processing hundreds
+        if chunklength == 3 :
+            if digit1 == '1' :
+                words += self.multi_sng_msc[0]
+            else :
+                if int(digit1) > 1 : words += number[int(digit1)] + \
+                                                 self.multi_plr_msc[0]
+        # processing tens
+        if chunklength > 1:
+            spacer = ''
+            if len(words) > 0 : spacer = ' '
+            if digit2 == '1':
+                words += spacer + self.number_teens[int(digit3)]
+            else:
+                if int(digit2) > 1 and int(digit2) > 0:
+                    words += spacer + self.tens_sng_msc[int(digit2)] + u'dešimt'
+
+        # processing ones
+        if chunklength > 0 and digit2 != '1' :
+            spacer = ''
+            if len(words) > 0: spacer = u' '
+            if int(digit3) > 0:
+                words += spacer + number[int(digit3)]
+        # end processing
+        if len(words) > 0 :
+            if digit3 == '1' and chunknr > 0:
+                return words + self.multi_sng_msc[chunknr]
+            elif digit3 != '1' and chunknr > 0:
+                if chunklength >= 2 and ((int(chunk) % 10) == 0 or (digit2 == \
+                                                     '1' and int(digit3) > 0)):
+                    return words + multi_plr_msc_2[chunknr]
+                else:
+                    return words + multi_plr_msc[chunknr]
+
+            else:
+                return words
+        else:
+            return ''
+
+lt_LT()

=== added directory 'report_aeroo/ctt_languages/lt_LT/currencies'
=== added file 'report_aeroo/ctt_languages/lt_LT/currencies/__init__.py'
--- report_aeroo/ctt_languages/lt_LT/currencies/__init__.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_languages/lt_LT/currencies/__init__.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,3 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+# Please do not edit this file!

=== added file 'report_aeroo/ctt_languages/lt_LT/currencies/eur.py'
--- report_aeroo/ctt_languages/lt_LT/currencies/eur.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_languages/lt_LT/currencies/eur.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,25 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+
+from report_aeroo.ctt_objects import ctt_currency
+
+class eur(ctt_currency):
+    def _init_currency(self):
+        self.language = u'lt_LT'
+        self.code = u'EUR'
+        self.fractions = 100
+        self.cur_singular = u' euras'
+        # default plural form for currency
+        self.cur_plural = u' eurų'
+        # betwean 1 and 10 yields different plural form, if defined
+        self.cur_plural_2to10 = u' eurai'
+        self.frc_singular = u' centas'
+        # default plural form for fractions
+        self.frc_plural = u' centų'
+        # betwean 1 and 10 yields different plural form, if defined
+        self.frc_plural_2to10 = u' centai'
+        # grammatical genders: f - feminine, m - masculine, n -neuter
+        self.cur_gram_gender = 'm'
+        self.frc_gram_gender = 'm'
+    
+eur()

=== added file 'report_aeroo/ctt_languages/lt_LT/currencies/ltl.py'
--- report_aeroo/ctt_languages/lt_LT/currencies/ltl.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_languages/lt_LT/currencies/ltl.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,25 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+
+from report_aeroo.ctt_objects import ctt_currency
+
+class ltl(ctt_currency):
+    def _init_currency(self):
+        self.language = u'lt_LT'
+        self.code = u'LTL'
+        self.fractions = 100
+        self.cur_singular = u' litas'
+        # default plural form for currency
+        self.cur_plural = u' litų'
+        # betwean 1 and 10 yields different plural form, if defined
+        self.cur_plural_2to10 = u' litai'
+        self.frc_singular = u' centas'
+        # default plural form for fractions
+        self.frc_plural = u' centų'
+        # betwean 1 and 10 yields different plural form, if defined
+        self.frc_plural_2to10 = u' centai'
+        # grammatical genders: f - feminine, m - masculine, n -neuter
+        self.cur_gram_gender = 'm'
+        self.frc_gram_gender = 'm'
+    
+ltl()

=== added file 'report_aeroo/ctt_languages/lt_LT/currencies/lvl.py'
--- report_aeroo/ctt_languages/lt_LT/currencies/lvl.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_languages/lt_LT/currencies/lvl.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,25 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+
+from report_aeroo.ctt_objects import ctt_currency
+
+class lvl(ctt_currency):
+    def _init_currency(self):
+        self.language = u'lt_LT'
+        self.code = u'LVL'
+        self.fractions = 100
+        self.cur_singular = u' latas'
+        # default plural form for currency
+        self.cur_plural = u' latų'
+        # betwean 1 and 10 yields different plural form, if defined
+        self.cur_plural_2to10 = u' latai'
+        self.frc_singular = u' santimas'
+        # default plural form for fractions
+        self.frc_plural = u' santimų'
+        # betwean 1 and 10 yields different plural form, if defined
+        self.frc_plural_2to10 = u' santimai'
+        # grammatical genders: f - feminine, m - masculine, n -neuter
+        self.cur_gram_gender = 'm'
+        self.frc_gram_gender = 'm'
+    
+lvl()

=== added file 'report_aeroo/ctt_languages/lt_LT/currencies/uah.py'
--- report_aeroo/ctt_languages/lt_LT/currencies/uah.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_languages/lt_LT/currencies/uah.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,25 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+
+from report_aeroo.ctt_objects import ctt_currency
+
+class uah(ctt_currency):
+    def _init_currency(self):
+        self.language = u'lt_LT'
+        self.code = u'UAH'
+        self.fractions = 100
+        self.cur_singular = u' grivna'
+        # default plural form for currency
+        self.cur_plural = u' grivnų'
+        # betwean 1 and 10 yields different plural form, if defined
+        self.cur_plural_2to10 = u' grivnai'
+        self.frc_singular = u' kapeika'
+        # default plural form for fractions
+        self.frc_plural = u' kapeikų'
+        # betwean 1 and 10 yields different plural form, if defined
+        self.frc_plural_2to10 = u' kapeikos'
+        # grammatical genders: f - feminine, m - masculine, n -neuter
+        self.cur_gram_gender = 'm'
+        self.frc_gram_gender = 'm'
+    
+uah()

=== added file 'report_aeroo/ctt_languages/lt_LT/currencies/usd.py'
--- report_aeroo/ctt_languages/lt_LT/currencies/usd.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_languages/lt_LT/currencies/usd.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,25 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+
+from report_aeroo.ctt_objects import ctt_currency
+
+class usd(ctt_currency):
+    def _init_currency(self):
+        self.language = u'lt_LT'
+        self.code = u'USD'
+        self.fractions = 100
+        self.cur_singular = u' doleris'
+        # default plural form for currency
+        self.cur_plural = u' dolerių'
+        # betwean 1 and 10 yields different plural form, if defined
+        self.cur_plural_2to10 = u' doleriai'
+        self.frc_singular = u' centas'
+        # default plural form for fractions
+        self.frc_plural = u' centų'
+        # betwean 1 and 10 yields different plural form, if defined
+        self.frc_plural_2to10 = u' centai'
+        # grammatical genders: f - feminine, m - masculine, n -neuter
+        self.cur_gram_gender = 'm'
+        self.frc_gram_gender = 'm'
+    
+usd()

=== added directory 'report_aeroo/ctt_languages/lv_LV'
=== added file 'report_aeroo/ctt_languages/lv_LV/__init__.py'
--- report_aeroo/ctt_languages/lv_LV/__init__.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_languages/lv_LV/__init__.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,101 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+# lv_LV
+
+from report_aeroo.ctt_objects import ctt_language
+
+class lv_LV(ctt_language):
+    def _init_lang(self):
+        self.name = 'lv_LV'
+        # digits - masculine, singular
+        self.number_sng_msc = [u'nulle', u'viens', u'divi',
+                               u'trīs', u'četri', u'pieci',
+                               u'seši', u'septiņi', u'astoņi',
+                               u'deviņi']
+        # digits - feminine, singular
+        self.number_sng_fem = [u'nulle', u'viena', u'divas',
+                               u'trīs', u'četras', u'piecas',
+                               u'sešas', u'septiņas', u'astoņas',
+                               u'deviņas']
+        # tens - masculine, singular
+        self.tens_sng_msc = [u'nulle', u'vien', u'div',
+                             u'trīs', u'četr', u'piec',
+                             u'seš', u'septiņ', u'astoņ',
+                             u'deviņ']
+        # teens - masculine
+        self.teens = [u'desmit', u'vienpadsmit', u'divpadsmit',
+                      u'trīspadsmit', u'četrpadsmit', u'piecpadsmit',
+                      u'sešpadsmit', u'septiņpadsmit', u'astoņpadsmit',
+                      u'deviņpadsmit']
+        # multiplier - masculine, singular                      
+        self.multi_sng_msc = [u'simts', u' tūkstotis', u' miljons',
+                              u' miljards']
+        # multiplier - masculine, plural
+        self.multi_plr_msc = [u' simti', u' tūkstoši', u' miljoni',
+                              u' miljardi']
+        
+        # next line is needed for correct loading of currencies 
+        import currencies
+        return currencies
+
+
+    def wordify(self, chunk, chunknr, gender):
+        if gender == 'm':
+            number = self.number_sng_msc
+        elif gender == 'f':
+            number = self.number_sng_fem
+        elif gender == 'n':
+            number = self.number_sng_neu
+        words = u''
+        digit1 = u''
+        digit2 = u''
+        digit3 = u''
+        chunklength = len(chunk)
+        # placing digits in right places
+        if chunklength == 1:
+            digit3 = chunk[0 : 1]
+        if chunklength == 2:
+            digit2 = chunk[0 : 1]
+            digit3 = chunk[1 : 2]
+        if chunklength == 3:
+            digit1 = chunk[0 : 1]
+            digit2 = chunk[1 : 2]
+            digit3 = chunk[-1]
+        # processing zero
+        if chunklength == 1 and digit3  == '0' :
+            return number[0]
+        # processing hundreds
+        if chunklength == 3 :
+            if digit1 == '1' :
+                words += self.multi_sng_msc[0]
+            else :
+                if int(digit1) > 1 : words += number[int(digit1)] + \
+                                                self.multi_plr_msc[0]
+        # processing tens
+        if chunklength > 1:
+            spacer = ''
+            if len(words) > 0 : spacer = ' '
+            if digit2 == '1':
+                words += spacer + self.teens[int(digit3)]
+            else:
+                if int(digit2) > 1 and int(digit2) > 0:
+                    words += spacer + self.tens_sng_msc[int(digit2)] + u'desmit'
+
+        # processing ones
+        if chunklength > 0 and digit2 != '1' :
+            spacer = ''
+            if len(words) > 0: spacer = u' '
+            if int(digit3) > 0:
+                words += spacer + number[int(digit3)]
+        # end processing
+        if len(words) > 0 :
+            if digit3 == '1' and chunknr > 0:
+                return words + self.multi_sng_msc[chunknr]
+            elif digit3 != '1' and chunknr > 0:
+                return words + self.multi_plr_msc[chunknr]
+            else:
+                return words
+        else:
+            return ''
+
+lv_LV()

=== added directory 'report_aeroo/ctt_languages/lv_LV/currencies'
=== added file 'report_aeroo/ctt_languages/lv_LV/currencies/__init__.py'
--- report_aeroo/ctt_languages/lv_LV/currencies/__init__.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_languages/lv_LV/currencies/__init__.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,3 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+# Please do not edit this file!

=== added file 'report_aeroo/ctt_languages/lv_LV/currencies/eur.py'
--- report_aeroo/ctt_languages/lv_LV/currencies/eur.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_languages/lv_LV/currencies/eur.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,22 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+
+from report_aeroo.ctt_objects import ctt_currency
+
+class eur(ctt_currency):
+    def _init_currency(self):
+        self.language = u'lv_LV'
+        self.code = u'EUR'
+        self.fractions = 100
+        self.cur_singular = u' eiro'
+        self.cur_plural = u' eiro'
+        self.frc_singular = u' cents'
+        # default plural form for fractions
+        self.frc_plural = u' centu'
+        # betwean 1 and 10 yields different plural form, if defined
+        self.frc_plural_2to10 = u' centi'
+        # grammatical genders: f - feminine, m - masculine, n -neuter
+        self.cur_gram_gender = 'm'
+        self.frc_gram_gender = 'm'
+    
+eur()

=== added file 'report_aeroo/ctt_languages/lv_LV/currencies/ltl.py'
--- report_aeroo/ctt_languages/lv_LV/currencies/ltl.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_languages/lv_LV/currencies/ltl.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,25 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+
+from report_aeroo.ctt_objects import ctt_currency
+
+class ltl(ctt_currency):
+    def _init_currency(self):
+        self.language = u'lv_LV'
+        self.code = u'LTL'
+        self.fractions = 100
+        self.cur_singular = u' lits'
+        # default plural form for currency
+        self.cur_plural = u' litu'
+        # betwean 1 and 10 yields different plural form, if defined
+        self.cur_plural_2to10 = u' liti'
+        self.frc_singular = u' cents'
+        # default plural form for fractions
+        self.frc_plural = u' centu'
+        # betwean 1 and 10 yields different plural form, if defined
+        self.frc_plural_2to10 = u' centi'
+        # grammatical genders: f - feminine, m - masculine, n -neuter
+        self.cur_gram_gender = 'm'
+        self.frc_gram_gender = 'm'
+    
+ltl()

=== added file 'report_aeroo/ctt_languages/lv_LV/currencies/lvl.py'
--- report_aeroo/ctt_languages/lv_LV/currencies/lvl.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_languages/lv_LV/currencies/lvl.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,25 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+
+from report_aeroo.ctt_objects import ctt_currency
+
+class lvl(ctt_currency):
+    def _init_currency(self):
+        self.language = u'lv_LV'
+        self.code = u'LVL'
+        self.fractions = 100
+        self.cur_singular = u' lats'
+        # default plural form for currency
+        self.cur_plural = u' latu'
+        # betwean 1 and 10 yields different plural form, if defined
+        self.cur_plural_2to10 = u' lati'
+        self.frc_singular = u' santīms'
+        # default plural form for fractions
+        self.frc_plural = u' santīmi'
+        # betwean 1 and 10 yields different plural form, if defined
+        self.frc_plural_2to10 = u' santīmu'
+        # grammatical genders: f - feminine, m - masculine, n -neuter
+        self.cur_gram_gender = 'm'
+        self.frc_gram_gender = 'm'
+    
+lvl()

=== added file 'report_aeroo/ctt_languages/lv_LV/currencies/mxn.py'
--- report_aeroo/ctt_languages/lv_LV/currencies/mxn.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_languages/lv_LV/currencies/mxn.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,22 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+
+from report_aeroo.ctt_objects import ctt_currency
+
+class mxn(ctt_currency):
+    def _init_currency(self):
+        self.language = u'lv_LV'
+        self.code = u'MXN'
+        self.fractions = 100
+        self.cur_singular = u' Meksikas peso'
+        self.cur_plural = self.cur_singular
+        self.frc_singular = u' cents'
+        # default plural form for fractions
+        self.frc_plural = u' centu'
+        # betwean 1 and 10 yields different plural form, if defined
+        self.frc_plural_2to10 = u' centi'
+        # grammatical genders: f - feminine, m - masculine, n -neuter
+        self.cur_gram_gender = 'm'
+        self.frc_gram_gender = 'm'
+    
+mxn()

=== added file 'report_aeroo/ctt_languages/lv_LV/currencies/rub.py'
--- report_aeroo/ctt_languages/lv_LV/currencies/rub.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_languages/lv_LV/currencies/rub.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,25 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+
+from report_aeroo.ctt_objects import ctt_currency
+
+class rub(ctt_currency):
+    def _init_currency(self):
+        self.language = u'lv_LV'
+        self.code = u'RUB'
+        self.fractions = 100
+        self.cur_singular = u' rublis'
+        # default plural form for currency
+        self.cur_plural = u' rubļu'
+        # betwean 1 and 10 yields different plural form, if defined
+        self.cur_plural_2to10 = u' rubļi'
+        self.frc_singular = u' kapeika'
+        # default plural form for fractions
+        self.frc_plural = u' kapeiku'
+        # betwean 1 and 10 yields different plural form, if defined
+        self.frc_plural_2to10 = u' kapeikas'
+        # grammatical genders: f - feminine, m - masculine, n -neuter
+        self.cur_gram_gender = 'm'
+        self.frc_gram_gender = 'f'
+    
+rub()

=== added file 'report_aeroo/ctt_languages/lv_LV/currencies/trl.py'
--- report_aeroo/ctt_languages/lv_LV/currencies/trl.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_languages/lv_LV/currencies/trl.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,25 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+
+from report_aeroo.ctt_objects import ctt_currency
+
+class trl(ctt_currency):
+    def _init_currency(self):
+        self.language = u'lv_LV'
+        self.code = u'TRL'
+        self.fractions = 100
+        self.cur_singular = u' Turku lira'
+        # default plural form for currency
+        self.cur_plural = u' Turku liru'
+        # betwean 1 and 10 yields different plural form, if defined
+        self.cur_plural_2to10 = u' Turku liras'
+        self.frc_singular = u' kurušs'
+        # default plural form for fractions
+        self.frc_plural = u' kurušu'
+        # betwean 1 and 10 yields different plural form, if defined
+        self.frc_plural_2to10 = u' kuruši'
+        # grammatical genders: f - feminine, m - masculine, n -neuter
+        self.cur_gram_gender = 'f'
+        self.frc_gram_gender = 'm'
+    
+trl()

=== added file 'report_aeroo/ctt_languages/lv_LV/currencies/uah.py'
--- report_aeroo/ctt_languages/lv_LV/currencies/uah.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_languages/lv_LV/currencies/uah.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,24 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+
+from report_aeroo.ctt_objects import ctt_currency
+
+class uah(ctt_currency):
+    def _init_currency(self):
+        self.language = u'lv_LV'
+        self.code = u'UAH'
+        self.fractions = 100
+        self.cur_singular = u' grivna'
+        # default plural form for currency
+        self.cur_plural = u' grivnu'
+        # betwean 1 and 10 yields different plural form, if defined
+        self.cur_plural_2to10 = u' grivnas'
+        self.frc_singular = u' kapeika'
+        # default plural form for fractions
+        self.frc_plural = u' kapeiku'
+        # betwean 1 and 10 yields different plural form, if defined
+        self.frc_plural_2to10 = u' kapeikas'
+        # grammatical genders: f - feminine, m - masculine, n -neuter
+        self.cur_gram_gender = 'f'
+        self.frc_gram_gender = 'f'
+uah()

=== added file 'report_aeroo/ctt_languages/lv_LV/currencies/usd.py'
--- report_aeroo/ctt_languages/lv_LV/currencies/usd.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_languages/lv_LV/currencies/usd.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,25 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+
+from report_aeroo.ctt_objects import ctt_currency
+
+class usd(ctt_currency):
+    def _init_currency(self):
+        self.language = u'lv_LV'
+        self.code = u'USD'
+        self.fractions = 100
+        self.cur_singular = u' ASV dolārs'
+        # default plural form for currency
+        self.cur_plural = u' ASV dolāru'
+        # betwean 1 and 10 yields different plural form, if defined
+        self.cur_plural_2to10 = u' ASV dolāri'
+        self.frc_singular = u' cents'
+        # default plural form for fractions
+        self.frc_plural = u' centu'
+        # betwean 1 and 10 yields different plural form, if defined
+        self.frc_plural_2to10 = u' centi'
+        # grammatical genders: f - feminine, m - masculine, n -neuter
+        self.cur_gram_gender = 'm'
+        self.frc_gram_gender = 'm'
+    
+usd()

=== added directory 'report_aeroo/ctt_languages/ru_RU'
=== added file 'report_aeroo/ctt_languages/ru_RU/__init__.py'
--- report_aeroo/ctt_languages/ru_RU/__init__.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_languages/ru_RU/__init__.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,110 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+# ru_RU
+
+from report_aeroo.ctt_objects import ctt_language
+
+class ru_RU(ctt_language):
+    def _init_lang(self):
+        # language name
+        self.name = 'ru_RU'
+        # digits - masculine, singular
+        self.number_sng_msc = [u'ноль', u'один', u'два', u'три', u'четыре',
+                               u'пять', u'шесть', u'семь', u'восемь', u'девять']
+        # tens - masculine, singular
+        self.number_sng_fem = [u'ноль', u'одна', u'две', u'три', u'четыре',
+                               u'пять', u'шесть', u'семь', u'восемь', u'девять']
+        # tens - masculine, plural
+        self.number_plr_msc = [u'', u'один', u'двa', u'три', u'четыре', u'пять',
+                               u'шесть', u'семь', u'восемь', u'девять']
+        # teens - masculine
+        self.number_teens = [u'десять', u'одиннадцать', u'двенадцать',
+                             u'тринадцать', u'четырнадцать', u'пятнадцать',
+                             u'шестнадцать', u'семнадцать', u'восемнадцать',
+                             u'девятнадцать']
+        # multiplier - masculine, singular                      
+        self.multi_sng_msc = [u'стo', u' тысяча', u' миллион', u' миллиард']
+        # multiplier - masculine, plural
+        self.multi_plr_msc = [u'сoт', u' тысяч', u' миллионов', u' миллиардов']
+        
+        # next line is needed for correct loading of currencies 
+        import currencies
+        return currencies
+
+
+    def wordify(self, chunk, chunknr, gender):
+        if gender == 'm':
+            number = self.number_sng_msc
+        elif gender == 'f':
+            number = self.number_sng_fem
+        elif gender == 'n':
+            number = self.number_sng_neu
+        words = u''
+        digit1 = u''
+        digit2 = u''
+        digit3 = u''
+        chunklength = len(chunk)
+        # placing digits in right places
+        if chunklength == 1:
+            digit3 = chunk[0 : 1]
+        if chunklength == 2:
+            digit2 = chunk[0 : 1]
+            digit3 = chunk[1 : 2]
+        if chunklength == 3:
+            digit1 = chunk[0 : 1]
+            digit2 = chunk[1 : 2]
+            digit3 = chunk[-1]
+        # processing zero
+        if chunklength == 1 and digit3  == '0' :
+            return number[0]
+        # processing hundreds
+        if chunklength == 3 :
+            if int(digit1) == 1 :
+                words += self.multi_sng_msc[0]
+            elif int(digit1) == 2 :
+                words += u'двести'
+            elif int(digit1) == 3 :
+                words += u'триста'
+            elif int(digit1) == 4 :
+                words += u'четыреста'
+            elif int(digit1) >= 5 :
+                words += self.number_sng_msc[int(digit1)] + self.multi_plr_msc[0]
+        # processing tens
+        if chunklength > 1:
+            spacer = ''
+            if len(words) > 0 : spacer = ' '
+            if digit2 == '1':
+                words += spacer + self.number_teens[int(digit3)]
+            else:
+                if int(digit2) > 1 and int(digit2) < 4:
+                    words += spacer + self.number_plr_msc[int(digit2)] + u'дцать'
+                elif digit2 == '4':
+                    words += spacer + u'сорок'
+                elif int(digit2) >= 5 and int(digit2) != 9:
+                    words += spacer + self.number_plr_msc[int(digit2)] + u'десят'
+                elif digit2 == '9':
+                    words += spacer + u'девяносто'
+
+        # processing ones
+        if chunklength > 0 and digit2 != '1' :
+            spacer = ''
+            if len(words) > 0: spacer = u' '
+            if chunknr == 1:
+                if int(digit3) == 1 or int(digit3) == 2:
+                    words += spacer + self.number_sng_fem[int(digit3)]
+                elif int(digit3) >= 3 and int(digit3) != 0: 
+                    words += spacer + self.number_sng_msc[int(digit3)]
+            else:
+                if int(digit3) > 0: words += spacer + self.number_sng_msc[int(digit3)]
+        # end processing
+        if len(words) > 0 :
+            if digit3 == '1' and chunknr > 0:
+                return words + self.multi_sng_msc[chunknr]
+            elif digit3 != '1' and chunknr > 0:
+                return words + self.multi_plr_msc[chunknr]
+            else:
+                return words
+        else:
+            return ''
+
+ru_RU()

=== added directory 'report_aeroo/ctt_languages/ru_RU/currencies'
=== added file 'report_aeroo/ctt_languages/ru_RU/currencies/__init__.py'
--- report_aeroo/ctt_languages/ru_RU/currencies/__init__.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_languages/ru_RU/currencies/__init__.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,3 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+# Please do not edit this file!

=== added file 'report_aeroo/ctt_languages/ru_RU/currencies/eur.py'
--- report_aeroo/ctt_languages/ru_RU/currencies/eur.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_languages/ru_RU/currencies/eur.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,22 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+
+from report_aeroo.ctt_objects import ctt_currency
+
+class eur(ctt_currency):
+    def _init_currency(self):
+        self.language = u'ru_RU'
+        self.code = u'EUR'
+        self.fractions = 100
+        self.cur_singular = u' евро'
+        self.cur_plural = u' евро'
+        self.frc_singular = u' цент'
+        # default plural form for fractions
+        self.frc_plural = u' центов'
+        self.frc_plural_2_to4 = u' цента'
+        
+        # grammatical genders: f - feminine, m - masculine, n -neuter
+        self.cur_gram_gender = 'm'
+        self.frc_gram_gender = 'm'
+    
+eur()

=== added file 'report_aeroo/ctt_languages/ru_RU/currencies/ltl.py'
--- report_aeroo/ctt_languages/ru_RU/currencies/ltl.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_languages/ru_RU/currencies/ltl.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,23 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+
+from report_aeroo.ctt_objects import ctt_currency
+
+class ltl(ctt_currency):
+    def _init_currency(self):
+        self.language = u'ru_RU'
+        self.code = u'LTL'
+        self.fractions = 100
+        self.cur_singular = u' лит'
+        # default plural form for currency
+        self.cur_plural = u' литов'
+        self.cur_plural_2to4 = u' лита'
+        self.frc_singular = u' цент'
+        # default plural form for fractions
+        self.frc_plural = u' центов'
+        self.frc_plural_2to4 = u' цента'
+        # grammatical genders: f - feminine, m - masculine, n -neuter
+        self.cur_gram_gender = 'm'
+        self.frc_gram_gender = 'm'
+    
+ltl()

=== added file 'report_aeroo/ctt_languages/ru_RU/currencies/lvl.py'
--- report_aeroo/ctt_languages/ru_RU/currencies/lvl.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_languages/ru_RU/currencies/lvl.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,23 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+
+from report_aeroo.ctt_objects import ctt_currency
+
+class lvl(ctt_currency):
+    def _init_currency(self):
+        self.language = u'ru_RU'
+        self.code = u'LVL'
+        self.fractions = 100
+        self.cur_singular = u' лат'
+        # default plural form for currency
+        self.cur_plural = u' латов'
+        self.cur_plural_2to4 = u' лата'
+        self.frc_singular = u' сантим'
+        # default plural form for fractions
+        self.frc_plural = u' сантимов'
+        self.frc_plural_2to4 = u' сантима'
+        # grammatical genders: f - feminine, m - masculine, n -neuter
+        self.cur_gram_gender = 'm'
+        self.frc_gram_gender = 'm'
+    
+lvl()

=== added file 'report_aeroo/ctt_languages/ru_RU/currencies/rub.py'
--- report_aeroo/ctt_languages/ru_RU/currencies/rub.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_languages/ru_RU/currencies/rub.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,23 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+
+from report_aeroo.ctt_objects import ctt_currency
+
+class rub(ctt_currency):
+    def _init_currency(self):
+        self.language = u'ru_RU'
+        self.code = u'RUB'
+        self.fractions = 100
+        self.cur_singular = u' рубль'
+        # default plural form for currency        
+        self.cur_plural = u' рублей' 
+        self.cur_plural_2to4 = u' рубля' 
+        self.frc_singular = u' копейка'
+        # default plural form for fractions
+        self.frc_plural = u' копеек'
+        self.frc_plural_2to4 = u' копейки'
+        # grammatical genders: f - feminine, m - masculine, n -neuter
+        self.cur_gram_gender = 'm'
+        self.frc_gram_gender = 'f'
+
+rub()

=== added file 'report_aeroo/ctt_languages/ru_RU/currencies/uah.py'
--- report_aeroo/ctt_languages/ru_RU/currencies/uah.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_languages/ru_RU/currencies/uah.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,23 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+
+from report_aeroo.ctt_objects import ctt_currency
+
+class uah(ctt_currency):
+    def _init_currency(self):
+        self.language = u'ru_RU'
+        self.code = u'UAH'
+        self.fractions = 100
+        self.cur_singular = u' гривна'
+        # default plural form for currency
+        self.cur_plural = u' гривен'
+        self.cur_plural_2to4 = u' гривны'
+        self.frc_singular = u' копeйка'
+        # default plural form for fractions
+        self.frc_plural = u' копeек'
+        self.frc_plural_2to4 = u' копeйки'
+        # grammatical genders: f - feminine, m - masculine, n -neuter
+        self.cur_gram_gender = 'f'
+        self.frc_gram_gender = 'f'
+
+uah()

=== added file 'report_aeroo/ctt_languages/ru_RU/currencies/usd.py'
--- report_aeroo/ctt_languages/ru_RU/currencies/usd.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_languages/ru_RU/currencies/usd.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,23 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+
+from report_aeroo.ctt_objects import ctt_currency
+
+class usd(ctt_currency):
+    def _init_currency(self):
+        self.language = u'ru_RU'
+        self.code = u'USD'
+        self.fractions = 100
+        self.cur_singular = u' доллара США'
+        # default plural form for currency
+        self.cur_plural = u' долларов США'
+        self.cur_frc_plural_2to4 = u' доллара США'
+        self.frc_singular = u' цент'
+        # default plural form for fractions
+        self.frc_plural = u' центов'
+        self.frc_plural_2to4 = u' цента'
+        # grammatical genders: f - feminine, m - masculine, n -neuter
+        self.cur_gram_gender = 'm'
+        self.frc_gram_gender = 'm'
+    
+usd()

=== added directory 'report_aeroo/ctt_languages/tr_TR'
=== added file 'report_aeroo/ctt_languages/tr_TR/__init__.py'
--- report_aeroo/ctt_languages/tr_TR/__init__.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_languages/tr_TR/__init__.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,93 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+# tr_TR
+################################################################################
+#
+# Turkish language support assembled from contributions provided by:
+# Ahmet Altınışık
+#
+################################################################################
+from report_aeroo.ctt_objects import ctt_language
+
+class tr_TR(ctt_language):
+    def _init_lang(self):
+        self.name = 'tr_TR'
+        # digits - masculine, singular
+        self.number_sng_msc = [u'', u'bir', u'iki', u'üç', u'dört', u'beş',
+                               u'alti', u'yedi', u'sekiz', u'dokuz']
+        # tens - masculine, singular
+        self.tens_sng_msc = [u'on', u'on bir', u'on iki', u'on üç', u'on dört',
+                             u'on beş', u'on alti', u'on yedi', u'on sekiz',
+                             u'on dokuz']
+        # teens - masculine
+        self.teens = [u'on', u'on bir', u'on iki', u'on üç', u'on dört',
+                      u'on beş', u'on alti', u'on yedi', u'on sekiz',
+                      u'on dokuz']
+        # multiplier - masculine, singular                      
+        self.multi_sng_msc = [u'yüz', u' bin', u' milyon', u' milyar']
+        
+        # next line is needed for correct loading of currencies 
+        import currencies
+        return currencies
+
+
+    def wordify(self, chunk, chunknr, gender):
+        if gender == 'm':
+            number = self.number_sng_msc
+        elif gender == 'f':
+            number = self.number_sng_fem
+        elif gender == 'n':
+            number = self.number_sng_neu
+        words = u''
+        digit1 = u''
+        digit2 = u''
+        digit3 = u''
+        chunklength = len(chunk)
+        # placing digits in right places
+        if chunklength == 1:
+            digit3 = chunk[0 : 1]
+        if chunklength == 2:
+            digit2 = chunk[0 : 1]
+            digit3 = chunk[1 : 2]
+        if chunklength == 3:
+            digit1 = chunk[0 : 1]
+            digit2 = chunk[1 : 2]
+            digit3 = chunk[-1]
+        # processing zero
+        if chunklength == 1 and digit3  == '0' :
+            return number[0]
+        # processing hundreds
+        if chunklength == 3 :
+            if digit1 == '1' :
+                words += self.multi_sng_msc[0]
+            else :
+                if int(digit1) > 1 : words += number[int(digit1)] + \
+                                                self.multi_plr_msc[0]
+        # processing tens
+        if chunklength > 1:
+            spacer = ''
+            if len(words) > 0 : spacer = ' '
+            if digit2 == '1':
+                words += spacer + self.teens[int(digit3)]
+            else:
+                if int(digit2) > 1 and int(digit2) > 0:
+                    words += spacer + self.tens_sng_msc[int(digit2)]
+
+        # processing ones
+        if chunklength > 0 and digit2 != '1' :
+            spacer = ''
+            if len(words) > 0: spacer = u' '
+            if int(digit3) > 0:
+                words += spacer + number[int(digit3)]
+        # end processing
+        if len(words) > 0 :
+            if digit3 == '1' and chunknr > 0:
+                return words + self.multi_sng_msc[chunknr]
+            elif digit3 != '1' and chunknr > 0:
+                return words + self.multi_plr_msc[chunknr]
+            else:
+                return words
+        else:
+            return ''
+
+tr_TR()

=== added directory 'report_aeroo/ctt_languages/tr_TR/currencies'
=== added file 'report_aeroo/ctt_languages/tr_TR/currencies/__init__.py'
--- report_aeroo/ctt_languages/tr_TR/currencies/__init__.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_languages/tr_TR/currencies/__init__.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,3 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+# Please do not edit this file!

=== added file 'report_aeroo/ctt_languages/tr_TR/currencies/eur.py'
--- report_aeroo/ctt_languages/tr_TR/currencies/eur.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_languages/tr_TR/currencies/eur.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,21 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+
+from report_aeroo.ctt_objects import ctt_currency
+
+class eur(ctt_currency):
+    def _init_currency(self):
+        self.language = u'tr_TR'
+        self.code = u'EUR'
+        self.fractions = 100
+        self.cur_singular = u' Euro'
+        # default plural form for currency
+        self.cur_plural = u' Euro'
+        self.frc_singular = u' sent'
+        # default plural form for fractions
+        self.frc_plural = u' sent'
+        # grammatical genders: f - feminine, m - masculine, n -neuter
+        self.cur_gram_gender = 'm'
+        self.frc_gram_gender = 'm'
+    
+eur()

=== added file 'report_aeroo/ctt_languages/tr_TR/currencies/lvl.py'
--- report_aeroo/ctt_languages/tr_TR/currencies/lvl.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_languages/tr_TR/currencies/lvl.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,21 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+
+from report_aeroo.ctt_objects import ctt_currency
+
+class lvl(ctt_currency):
+    def _init_currency(self):
+        self.language = u'tr_TR'
+        self.code = u'LVL'
+        self.fractions = 100
+        self.cur_singular = u' Litvanya Liatası'
+        # default plural form for currency
+        self.cur_plural = u' Litvanya Liatası'
+        self.frc_singular = u' santim'
+        # default plural form for fractions
+        self.frc_plural = u' santims'
+        # grammatical genders: f - feminine, m - masculine, n -neuter
+        self.cur_gram_gender = 'm'
+        self.frc_gram_gender = 'm'
+    
+lvl()

=== added file 'report_aeroo/ctt_languages/tr_TR/currencies/trl.py'
--- report_aeroo/ctt_languages/tr_TR/currencies/trl.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_languages/tr_TR/currencies/trl.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,21 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+
+from report_aeroo.ctt_objects import ctt_currency
+
+class trl(ctt_currency):
+    def _init_currency(self):
+        self.language = u'tr_TR'
+        self.code = u'TRL'
+        self.fractions = 100
+        self.cur_singular = u' Lira'
+        # default plural form for currency
+        self.cur_plural = u' Lira'
+        self.frc_singular = u' kuruş'
+        # default plural form for fractions
+        self.frc_plural = u' kuruş'
+        # grammatical genders: f - feminine, m - masculine, n -neuter
+        self.cur_gram_gender = 'm'
+        self.frc_gram_gender = 'm'
+    
+trl()

=== added file 'report_aeroo/ctt_languages/tr_TR/currencies/usd.py'
--- report_aeroo/ctt_languages/tr_TR/currencies/usd.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_languages/tr_TR/currencies/usd.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,21 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+
+from report_aeroo.ctt_objects import ctt_currency
+
+class usd(ctt_currency):
+    def _init_currency(self):
+        self.language = u'tr_TR'
+        self.code = u'USD'
+        self.fractions = 100
+        self.cur_singular = u' USD'
+        # default plural form for currency
+        self.cur_plural = u' USD'
+        self.frc_singular = u' sent'
+        # default plural form for fractions
+        self.frc_plural = u' sent'
+        # grammatical genders: f - feminine, m - masculine, n -neuter
+        self.cur_gram_gender = 'm'
+        self.frc_gram_gender = 'm'
+    
+usd()

=== added directory 'report_aeroo/ctt_languages/uk_UA'
=== added file 'report_aeroo/ctt_languages/uk_UA/__init__.py'
--- report_aeroo/ctt_languages/uk_UA/__init__.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_languages/uk_UA/__init__.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,112 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+# uk_UA
+
+from report_aeroo.ctt_objects import ctt_language
+
+class uk_UA(ctt_language):
+    def _init_lang(self):
+        # language name
+        self.name = 'uk_UA'
+        # digits - masculine, singular
+        self.number_sng_msc = [u'ноль', u'один', u'два', u'три', u'чотири',
+                               u'п\'ять', u'шість', u'сім', u'вісім',
+                               u'дев\'ять']
+        # tens - masculine, singular
+        self.number_sng_fem = [u'ноль', u'одна', u'дві', u'три', u'чотири', 
+                               u'п\'ять', u'шість', u'сім', u'вісім',
+                               u'дев\'ять']
+        # tens - masculine, plural
+        self.number_plr_msc = [u'', u'один', u'двa', u'три', u'четыре', u'пять',
+                               u'шесть', u'семь', u'восемь', u'девять']
+        # teens - masculine
+        self.number_teens = [u'десять', u'одинадцять', u'дванадцять',
+                             u'тринадцять', u'чотирнадцять', u'п\'ятнадцять',
+                             u'шістнадцять', u'сімнадцять', u'вісімнадцять',
+                             u'дев\'ятнадцять']
+        # multiplier - masculine, singular                      
+        self.multi_sng_msc = [u'стo', u' тисяча', u' мiллiон', u' мiллiард']
+        # multiplier - masculine, plural
+        self.multi_plr_msc = [u'сoт', u' тисяч', u' мiллiонiв', u' мiллiардов']
+        
+        # next line is needed for correct loading of currencies 
+        import currencies
+        return currencies
+
+
+    def wordify(self, chunk, chunknr, gender):
+        if gender == 'm':
+            number = self.number_sng_msc
+        elif gender == 'f':
+            number = self.number_sng_fem
+        elif gender == 'n':
+            number = self.number_sng_neu
+        words = u''
+        digit1 = u''
+        digit2 = u''
+        digit3 = u''
+        chunklength = len(chunk)
+        # placing digits in right places
+        if chunklength == 1:
+            digit3 = chunk[0 : 1]
+        if chunklength == 2:
+            digit2 = chunk[0 : 1]
+            digit3 = chunk[1 : 2]
+        if chunklength == 3:
+            digit1 = chunk[0 : 1]
+            digit2 = chunk[1 : 2]
+            digit3 = chunk[-1]
+        # processing zero
+        if chunklength == 1 and digit3  == '0' :
+            return number[0]
+        # processing hundreds
+        if chunklength == 3 :
+            if int(digit1) == 1 :
+                words += self.multi_sng_msc[0]
+            elif int(digit1) == 2 :
+                words += u'двісті'
+            elif int(digit1) == 3 :
+                words += u'триста'
+            elif int(digit1) == 4 :
+                words += u'чотириста'
+            elif int(digit1) >= 5 :
+                words += self.number_sng_msc[int(digit1)] + self.multi_plr_msc[0]
+        # processing tens
+        if chunklength > 1:
+            spacer = ''
+            if len(words) > 0 : spacer = ' '
+            if digit2 == '1':
+                words += spacer + self.number_teens[int(digit3)]
+            else:
+		        if int(digit2) > 1 and int(digit2) < 4:
+		            words += spacer + skaitlix[int(digit2)] + u'дцять'
+		        elif digit2 == '4':
+		            words += spacer + u'сорок'
+		        elif int(digit2) >= 5 and int(digit2) != 9:
+		            words += spacer + skaitlix[int(digit2)] + u'десят'
+		        elif digit2 == '9':
+		            words += spacer + u'дев\'яносто'
+
+        # processing ones
+        if chunklength > 0 and digit2 != '1' :
+            spacer = ''
+            if len(words) > 0: spacer = u' '
+            if chunknr == 1:
+                if int(digit3) == 1 or int(digit3) == 2:
+                    words += spacer + self.number_sng_fem[int(digit3)]
+                elif int(digit3) >= 3 and int(digit3) != 0: 
+                    words += spacer + self.number_sng_msc[int(digit3)]
+            else:
+                if int(digit3) > 0: words += spacer + self.number_sng_msc[int(digit3)]
+        # end processing
+        if len(words) > 0 :
+            if digit3 == '1' and chunknr > 0:
+                return words + self.multi_sng_msc[chunknr]
+            elif digit3 != '1' and chunknr > 0:
+                return words + self.multi_plr_msc[chunknr]
+            else:
+                return words
+        else:
+            return ''
+
+uk_UA()

=== added directory 'report_aeroo/ctt_languages/uk_UA/currencies'
=== added file 'report_aeroo/ctt_languages/uk_UA/currencies/__init__.py'
--- report_aeroo/ctt_languages/uk_UA/currencies/__init__.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_languages/uk_UA/currencies/__init__.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,3 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+# Please do not edit this file!

=== added file 'report_aeroo/ctt_languages/uk_UA/currencies/eur.py'
--- report_aeroo/ctt_languages/uk_UA/currencies/eur.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_languages/uk_UA/currencies/eur.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,21 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+
+from report_aeroo.ctt_objects import ctt_currency
+
+class eur(ctt_currency):
+    def _init_currency(self):
+        self.language = u'uk_UA'
+        self.code = u'EUR'
+        self.fractions = 100
+        self.cur_singular = u' евро'
+        self.cur_plural = u' евро'
+        self.frc_singular = u' цент'
+        # default plural form for fractions
+        self.frc_plural = u' центов'
+        self.frc_plural_2to4 = u' цента'
+        # grammatical genders: f - feminine, m - masculine, n -neuter
+        self.cur_gram_gender = 'm'
+        self.frc_gram_gender = 'm'
+    
+eur()

=== added file 'report_aeroo/ctt_languages/uk_UA/currencies/ltl.py'
--- report_aeroo/ctt_languages/uk_UA/currencies/ltl.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_languages/uk_UA/currencies/ltl.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,23 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+
+from report_aeroo.ctt_objects import ctt_currency
+
+class ltl(ctt_currency):
+    def _init_currency(self):
+        self.language = u'uk_UA'
+        self.code = u'LTL'
+        self.fractions = 100
+        self.cur_singular = u' лит'
+        # default plural form for currency
+        self.cur_plural = u' литов'
+        self.cur_plural_2to4 = u' лита'
+        self.frc_singular = u' цент'
+        # default plural form for fractions
+        self.frc_plural = u' центов'
+        self.frc_plural_2to4 = u' цента'
+        # grammatical genders: f - feminine, m - masculine, n -neuter
+        self.cur_gram_gender = 'm'
+        self.frc_gram_gender = 'm'
+    
+ltl()

=== added file 'report_aeroo/ctt_languages/uk_UA/currencies/lvl.py'
--- report_aeroo/ctt_languages/uk_UA/currencies/lvl.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_languages/uk_UA/currencies/lvl.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,23 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+
+from report_aeroo.ctt_objects import ctt_currency
+
+class lvl(ctt_currency):
+    def _init_currency(self):
+        self.language = u'uk_UA'
+        self.code = u'LVL'
+        self.fractions = 100
+        self.cur_singular = u' лат'
+        # default plural form for currency
+        self.cur_plural = u' латов'
+        self.cur_plural_2to3 = u' лата'
+        self.frc_singular = u' сантим'
+        # default plural form for fractions
+        self.frc_plural = u' сантимов'
+        self.frc_plural_2to3 = u' сантима'
+        # grammatical genders: f - feminine, m - masculine, n -neuter
+        self.cur_gram_gender = 'm'
+        self.frc_gram_gender = 'm'
+        
+lvl()

=== added file 'report_aeroo/ctt_languages/uk_UA/currencies/rub.py'
--- report_aeroo/ctt_languages/uk_UA/currencies/rub.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_languages/uk_UA/currencies/rub.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,23 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+
+from report_aeroo.ctt_objects import ctt_currency
+
+class rub(ctt_currency):
+    def _init_currency(self):
+        self.language = u'uk_UA'
+        self.code = u'RUB'
+        self.fractions = 100
+        self.cur_singular = u' рубль'
+        # default plural form for currency
+        self.cur_plural = u' рублiв'
+        self.cur_plural_2to4 = u' рубля' 
+        self.frc_singular = u' копійка'
+        # default plural form for fractions
+        self.frc_plural = u' копійок'
+        self.frc_plural_2to4 = u' копійки'
+        # grammatical genders: f - feminine, m - masculine, n -neuter
+        self.cur_gram_gender = 'm'
+        self.frc_gram_gender = 'f'
+
+rub()

=== added file 'report_aeroo/ctt_languages/uk_UA/currencies/uah.py'
--- report_aeroo/ctt_languages/uk_UA/currencies/uah.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_languages/uk_UA/currencies/uah.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,23 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+
+from report_aeroo.ctt_objects import ctt_currency
+
+class uah(ctt_currency):
+    def _init_currency(self):
+        self.language = u'uk_UA'
+        self.code = u'UAH'
+        self.fractions = 100
+        self.cur_singular = u' гривня'
+        # default plural form for currency
+        self.cur_plural = u' гривень'
+        self.cur_plural_2to4 = u' гривні'
+        self.frc_singular = u' копійка'
+        # default plural form for fractions
+        self.frc_plural = u' копійок'
+        self.frc_plural_2to4 = u' копійки'
+        # grammatical genders: f - feminine, m - masculine, n -neuter
+        self.cur_gram_gender = 'f'
+        self.frc_gram_gender = 'f'
+
+uah()

=== added file 'report_aeroo/ctt_languages/uk_UA/currencies/usd.py'
--- report_aeroo/ctt_languages/uk_UA/currencies/usd.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_languages/uk_UA/currencies/usd.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,23 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+
+from report_aeroo.ctt_objects import ctt_currency
+
+class usd(ctt_currency):
+    def _init_currency(self):
+        self.language = u'uk_UA'
+        self.code = u'USD'
+        self.fractions = 100
+        self.cur_singular = u' доллара США'
+        # default plural form for currency
+        self.cur_plural = u' долларов США'
+        self.cur_plural_2to4 = u' доллара США'
+        self.frc_singular = u' цент'
+        # default plural form for fractions
+        self.frc_plural = u' центов'
+        self.frc_plural_2to4 = u' цента'
+        # grammatical genders: f - feminine, m - masculine, n -neuter
+        self.cur_gram_gender = 'm'
+        self.frc_gram_gender = 'm'
+    
+usd()

=== added file 'report_aeroo/ctt_objects.py'
--- report_aeroo/ctt_objects.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/ctt_objects.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,161 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+################################################################################
+# Developed by Kaspars Vilkens - Alistek Ltd (c) 2011
+#
+# Supported sum: 0 ... 999999999999.99
+# Supported languages: for more reference see languages forlder
+# Supported currencies: see particular language for reference
+################################################################################
+
+import os
+supported_language = {}
+
+if __name__ == '__main__':
+    from sys import exit
+    error = '''This code is part of Report Aeroo package!
+    Not to be used separately...'''
+    exit(error)
+    
+def currency_to_text(sum, currency_code, language_code):
+    if language_code not in supported_language:
+        raise Exception('Not supported or no language: %s' % language_code)
+    else:
+        suppl = supported_language[language_code]
+        return suppl.currency_to_text(sum, currency_code)
+
+class ctt_language(object):
+    def _init_lang(self):
+        pass
+
+    def __repr__(self):
+        return self.name
+
+    def __init__(self):
+        self.supported_currency = {}
+        self.minbound = 0
+        self.maxbound = 999999999999.99
+        currencies = self._init_lang()
+        supported_language.update({self.name : self})
+        import_submodules('currency', currencies, 0)
+
+    def check_sum(self):
+        if sum < self.minbound or sum > self.maxbound : 
+            raise Exception(\
+                """Sum out of bounds: must be from %s to %s""" % \
+                (str(self.minbound), str(self.maxbound)))
+
+    def check_currency(self):
+        if currency not in supported_currency: 
+            raise Exception(\
+                """Unsupported or no currency: must be one of (%s)""" % \
+                ', '.join(self.supported_currency))
+
+    def dtowords(self, sum_integers, gender):
+        diginwords = u''
+        if sum_integers == 0:
+            return self.wordify('0', 0, gender)
+        elif sum_integers > 0:
+            lengthx = len(str(sum_integers))
+            nrchunks = (lengthx / 3)
+        if nrchunks < (float(lengthx) / 3) :
+            nrchunks+=1
+        inc = 1
+        while inc <= nrchunks:
+            startpos = (lengthx - inc * 3)
+            chunklength = 3
+            if startpos < 0:
+                chunklength += startpos
+                startpos = 0
+            chunk = str(sum_integers)[startpos : startpos + chunklength]
+            #print str(startpos)+' '+str(chunklength)+' '+ chunk
+            if inc == 1:
+                wordified = self.wordify(chunk, inc-1, gender)
+            else:
+                wordified = self.wordify(chunk, inc-1, 'm')
+            inc += 1
+            spacer = ''
+            if len(diginwords) > 0 and wordified:
+                spacer = ' '
+            diginwords = wordified + spacer + diginwords
+        return diginwords
+
+
+    def currency_to_text(self, sum, currency):
+        #--------------for currencies with 100 fractions
+        sum = float(sum)
+        sum = round(sum, 2)
+        # find out digits before floating point - currency
+        sum_cur = int(sum)
+        # find out digits after floating point - fractions
+        sum_frc = int(round((sum - sum_cur) * 100,0))
+        curr = self.supported_currency.get(currency)
+        cur_in_words = self.dtowords(sum_cur, curr.cur_gram_gender)
+        frc_in_words = self.dtowords(sum_frc, curr.frc_gram_gender)
+        #------------------------------------
+
+        return (cur_in_words + curr.cur_to_text(sum_cur) + ' ' + frc_in_words +\
+                             curr.frc_to_text(sum_frc)).strip().encode('utf-8')
+
+
+class ctt_currency(object):
+    def _init_currency(self):
+        pass
+
+    def __repr__(self):
+        return self.code
+
+    def __init__(self):
+        self._init_currency()
+        suppl = supported_language.get(self.language)
+        suppl.supported_currency.update({self.code : self})
+
+    def cur_to_text(self, sum_cur):
+        # is the currency sum one
+        if sum_cur == 1 or (str(sum_cur)[-1] == '1' and str(sum_cur)[-2] !='1'):
+            return self.cur_singular
+        # 2,3 and 4 yields different plural form, if defined
+        elif ((sum_cur in [2, 3, 4]) or (str(sum_cur)[-1] in ['2', '3', '4'] \
+              and str(sum_cur)[-2] != '1')) and hasattr(self, 'cur_plural_2to4'):
+            return self.cur_plural_2to4
+        # betwean 1 and 10 yields different plural form, if defined
+        elif (sum_cur > 1 and sum_cur < 10 or (int(str(sum_cur)[-1]) > 1 \
+             and str(sum_cur)[-2] != '1')) and hasattr(self, 'cur_plural_2to10'):
+            return self.cur_plural_2to10
+        # starting from 10 yields uses default plural form
+        else:
+            return self.cur_plural
+
+    def frc_to_text(self, sum_frc):
+        # is the fraction sum one
+        if sum_frc == 1 or (str(sum_frc)[-1] == '1' and str(sum_frc)[-2] !='1'):
+            return self.frc_singular
+        # 2,3 and 4 yields different plural form, if defined
+        elif ((sum_frc in [2, 3, 4]) or (str(sum_frc)[-1] in ['2', '3', '4'] \
+              and str(sum_frc)[-2] != '1')) and hasattr(self, 'frc_plural_2to4'):
+            return self.frc_plural_2to4
+        # betwean 1 and 10 yields different plural form, if defined
+        elif (sum_frc > 1 and sum_frc < 10 or (int(str(sum_frc)[-1]) > 1 \
+             and str(sum_frc)[-2] != '1')) and hasattr(self, 'frc_plural_2to10'):
+            return self.frc_plural_2to10
+        # starting from 10 yields uses default plural form
+        else:
+            return self.frc_plural
+
+def __filter_names(to_import, package):
+    folder = os.path.split(package.__file__)[0]
+    for name in os.listdir(folder):
+        if to_import == 'currency':
+            if name.endswith(".py") and not name.startswith("__"):
+                yield name[:-3]
+        if to_import == 'language':
+            if len(name) == 5 and not name.startswith("__"):
+                yield name
+
+def import_submodules(to_import, package, level=-1):
+    names = list(__filter_names(to_import, package))
+    m = __import__(package.__name__, globals(), locals(), names, level)
+    return dict((name, getattr(m, name)) for name in names)
+
+import ctt_languages
+import_submodules('language', ctt_languages, 0)

=== added file 'report_aeroo/currency_to_text.py'
--- report_aeroo/currency_to_text.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/currency_to_text.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,491 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+
+###########################################################
+# Developed by Kaspars Vilkens - Alistek Ltd (c) 2011
+#     pep-8, unicode and doctests by Paul Stevens, [e-mail], 2010
+#
+# Supported currencies: LVL, EUR, USD, UAH
+# Supported sum: 0 ... 999999999999.99
+# Supported languages: lv_LV, en_US, ru_RU, uk_UA
+###########################################################
+import string
+
+supported_currency = ['LVL','EUR','USD', 'UAH']
+supported_language = ['lv_LV','en_US','ru_RU', 'uk_UA']
+
+def currency_to_text(sum, currency, language):
+    """
+    
+    first some simple tests
+
+    >>> currency_to_text(123, 'EUR', 'en_US')
+    'one hundred twenty three euros zero cents'
+
+    >>> currency_to_text(1.11, 'EUR', 'en_US')
+    'one euro eleven cents'
+
+    >>> currency_to_text(1.10, 'USD', 'en_US')
+    'one US dollar ten cents'
+
+    >>> currency_to_text(1.01, 'USD', 'en_US')
+    'one US dollar one cent'
+
+    >>> currency_to_text(1.01, 'LVL', 'lv_LV') == 'viens lats viens santīms'
+    True
+
+    >>> currency_to_text(123.12, 'LVL', 'ru_RU') == 'стo двaдцать три лата двенадцать сантимов'
+    True
+
+    >>> currency_to_text(123.12, 'USD', 'ru_RU') == 'стo двaдцать три доллара США двенадцать центов'
+    True
+
+
+    """
+    if sum < 0 or sum > 999999999999.99 : 
+        raise Exception('Sum out of bounds: must be from 0 to 999999999999.99')
+    if currency not in supported_currency: 
+        raise Exception("""Unsupported or no currency: must be one of (%s)""" % \
+            string.join(supported_currency,','))
+    if language not in supported_language: 
+        raise Exception("""Unsupported or no language: must be one of (%s)""" % \
+            string.join(supported_language,','))
+#--------------for currencies with 100 fractions
+    sum = float(sum)
+    sum = round(sum, 2)
+    # find out digits before floating point - currency
+    sum_cur = int(sum)
+    # find out digits after floating point - fractions
+    sum_frc = int(round((sum - sum_cur) * 100,0))
+    cur_in_words = dtowords(sum_cur, language)
+    #print cur_in_words
+    frc_in_words = dtowords(sum_frc, language)
+    #print frc_in_words
+    #------------------------------------
+    if language == 'lv_LV' :
+        if sum_cur == 1 or (str(sum_cur)[-1] == '1' and str(sum_cur)[-2] != '1'): # is the currency sum one
+            if currency == 'LVL':
+                cur_in_words += u' lats'
+            elif currency == 'EUR':
+                cur_in_words += u' eiro'
+            elif currency == 'USD':
+                cur_in_words += u' dolārs'
+            elif currency == 'UAH':
+                cur_in_words += u' grivna'
+        else:
+            if currency == 'LVL':
+                cur_in_words += u' lati'
+            elif currency == 'EUR':
+                cur_in_words += u' eiro'
+            elif currency == 'USD':
+                cur_in_words += u' dolāri'
+            elif currency == 'UAH':
+                cur_in_words += u' grivnas'
+	
+        if sum_frc == 1 or (str(sum_frc)[-1] == '1' and str(sum_frc)[-2] != '1'): # is the fraction sum one
+            if currency == 'LVL':
+                frc_in_words += u' santīms'
+            elif currency == 'EUR' or currency == 'USD' :
+                frc_in_words += u' cents'
+	    elif currency == 'UAH':
+                frc_in_words += u' kapeika'
+        else:
+            if currency == 'LVL':
+                frc_in_words += u' santīmi'
+            elif currency == 'EUR' or currency == 'USD':
+                frc_in_words += u' centi'
+	    elif currency == 'UAH':
+                frc_in_words += u' kapeikas'
+    #------------------------------------
+    if language == 'en_US' :
+        if sum_cur == 1 or (str(sum_cur)[-1] == '1' and str(sum_cur)[-2] != '1'): # is the currency sum one
+            if currency == 'LVL':
+                cur_in_words += u' Latvian lats'
+            elif currency == 'EUR':
+                cur_in_words += u' euro'
+            elif currency == 'USD':
+                cur_in_words += u' US dollar'
+        else:
+            if currency == 'LVL':
+                cur_in_words += u' Latvian lats'
+            elif currency == 'EUR':
+                cur_in_words += u' euros'
+            elif currency == 'USD':
+                cur_in_words += u' dollars'
+        if sum_frc == 1 or (str(sum_frc)[-1] == '1' and str(sum_frc)[-2] != '1'): # is the fraction sum one
+            if currency == 'LVL':
+                frc_in_words += u' santim'
+            elif currency == 'EUR' or currency == 'USD':
+                frc_in_words += u' cent'
+        else:
+            if currency == 'LVL':
+                frc_in_words += u' santims'
+            elif currency == 'EUR' or currency == 'USD' :
+                frc_in_words += u' cents'
+    #------------------------------------
+    if language == 'ru_RU' :
+        if sum_cur == 1 or (str(sum_cur)[-1] == '1' and str(sum_cur)[-2] != '1'): # is the currency sum one
+            if currency == 'LVL':
+                cur_in_words += u' лат'
+            elif currency == 'EUR':
+                cur_in_words += u' евро'
+            elif currency == 'USD':
+                cur_in_words += u' доллар США'
+        elif (sum_cur in [2, 3, 4]) or (str(sum_cur)[-1] in ['2', '3', '4'] and str(sum_cur)[-2] != '1'):
+            if currency == 'LVL':
+                cur_in_words += u' лата'
+            elif currency == 'EUR' :
+                cur_in_words += u' евро'
+            elif currency == 'USD' :
+                cur_in_words += u' доллара США'
+        elif (sum_cur >= 5 and sum_cur <= 20) or str(sum_cur)[-1] not in [2, 3, 4]:
+            if currency == 'LVL' :
+                cur_in_words += u' латов'
+            elif currency == 'EUR' :
+                cur_in_words += u' евро'
+            elif currency == 'USD' :
+                cur_in_words += u' долларов США'
+	
+        if sum_frc == 1 or (str(sum_frc)[-1] == '1' and str(sum_frc)[-2] != '1') : # is the fraction one
+            if currency == 'LVL' :
+                frc_in_words += u' сантим'
+            elif currency == 'EUR' or currency == 'USD' :
+                frc_in_words += u' цент'
+        elif (sum_frc in [2, 3, 4]) or (str(sum_frc)[-1] in ['2', '3', '4'] and str(sum_frc)[-2] != '1') :
+            if currency == 'LVL' :
+                frc_in_words += u' сантима'
+            elif currency == 'EUR' or currency == 'USD' :
+                frc_in_words += u' цента'
+        elif (sum_frc >= 5 and sum_frc <= 20) or str(sum_frc)[-1] not in [2, 3, 4] :
+            if currency == 'LVL' :
+                frc_in_words += u' сантимов'
+            elif currency == 'EUR' or currency == 'USD' :
+                frc_in_words += u' центов'
+    #------------------------------------
+    if language == 'uk_UA' :
+	if sum_cur == 1 or (str(sum_cur)[-1] == '1' and str(sum_cur)[-2] != '1') : # is the currency sum one
+	    if currency == 'LVL' :
+		cur_in_words += u' лат'
+	    elif currency == 'EUR' :
+		cur_in_words += u' евро'
+	    elif currency == 'USD' :
+		cur_in_words += u' доллар США'
+	    elif currency == 'UAH' :
+		cur_in_words += u' гривня'
+	elif (sum_cur in [2, 3, 4]) or (str(sum_cur)[-1] in ['2', '3', '4'] and str(sum_cur)[-2] != '1') :
+	    if currency == 'LVL' :
+		cur_in_words += u' лата'
+	    elif currency == 'EUR' :
+		cur_in_words += u' евро'
+	    elif currency == 'USD' :
+		cur_in_words += u' доллара США'
+	    elif currency == 'UAH' :
+		cur_in_words += u' гривні'
+	elif (sum_cur >= 5 and sum_cur <= 20) or str(sum_cur)[-1] not in [2, 3, 4] :
+	    if currency == 'LVL' :
+		cur_in_words += u' латов'
+	    elif currency == 'EUR' :
+		cur_in_words += u' евро'
+	    elif currency == 'USD' :
+		cur_in_words += u' долларов США'
+	    elif currency == 'UAH' :
+		cur_in_words += u' гривень'
+			
+	if sum_frc == 1 or (str(sum_frc)[-1] == '1' and str(sum_frc)[-2] != '1') : # is the fraction one
+	    if currency == 'LVL' :
+		frc_in_words += u' сантим'
+	    elif currency == 'EUR' or currency == 'USD' :
+		frc_in_words += u' цент'
+	    elif currency == 'UAH' :
+		frc_in_words += u' копійка'
+	elif (sum_frc in [2, 3, 4]) or (str(sum_frc)[-1] in ['2', '3', '4'] and str(sum_frc)[-2] != '1') :
+	    if currency == 'LVL' :
+		frc_in_words += u' сантима'
+	    elif currency == 'EUR' or currency == 'USD' :
+		frc_in_words += u' цента'
+	    elif currency == 'UAH' :
+		frc_in_words += u' копійки'
+	elif (sum_frc >= 5 and sum_frc <= 20) or str(sum_frc)[-1] not in [2, 3, 4] :
+	    if currency == 'LVL' :
+		frc_in_words += u' сантимов'
+	    elif currency == 'EUR' or currency == 'USD' :
+		frc_in_words += u' центов'
+	    elif currency == 'UAH' :
+		frc_in_words += u' копійок'
+	frc_in_words = str(sum_frc) + u' коп.'
+
+    return (cur_in_words + ' ' + frc_in_words).strip().encode('utf-8')
+
+
+def dtowords(sum_integers, language):
+    """
+    >>> dtowords(0, 'en_US')
+    u'zero'
+
+    >>> dtowords(1, 'en_US')
+    u'one'
+
+    >>> dtowords(11, 'en_US')
+    u'eleven'
+
+    >>> dtowords(169, 'en_US')
+    u'one hundred sixty nine'
+
+    >>> dtowords(12345, 'en_US')
+    u'twelve thousand three hundred fourty five'
+
+    >>> dtowords(123456, 'en_US')
+    u'one hundred twenty three thousand four hundred fifty six'
+
+    >>> dtowords(0, 'lv_LV')
+    u'nulle'
+
+    >>> dtowords(1, 'lv_LV')
+    u'viens'
+
+    >>> dtowords(11, 'lv_LV')
+    u'vienpadsmit'
+
+    >>> dtowords(169, 'lv_LV').encode('utf-8') == 'simts sešdesmit deviņi'
+    True
+
+    >>> dtowords(12345, 'lv_LV').encode('utf-8') == 'divpadsmit tūkstoši trīs simti četrdesmit pieci'
+    True
+
+    >>> dtowords(123456, 'lv_LV').encode('utf-8') == 'simts divdesmit trīs tūkstoši četri simti piecdesmit seši'
+    True
+
+    >>> dtowords(0, 'ru_RU').encode('utf-8') == 'ноль'
+    True
+
+    >>> dtowords(1, 'ru_RU').encode('utf-8') == 'один'
+    True
+
+    >>> dtowords(11, 'ru_RU').encode('utf-8') == 'одиннадцать'
+    True
+
+    >>> dtowords(169, 'ru_RU').encode('utf-8') == 'стo шестьдесят девять'
+    True
+
+    >>> dtowords(12345, 'ru_RU').encode('utf-8') == 'двенадцать тысяч триста сорок пять'
+    True
+
+    >>> dtowords(123456, 'ru_RU').encode('utf-8') == 'стo двaдцать три тысячи четыреста пятьдесят шесть'
+    True
+
+
+    """
+    diginwords = u''
+    if sum_integers == 0:
+        return wordify('0', 0, language)
+    elif sum_integers > 0:
+        lengthx = len(str(sum_integers))
+        nrchunks = (lengthx / 3)
+    if nrchunks < (float(lengthx) / 3) :
+        nrchunks+=1
+    inc = 1
+    while inc <= nrchunks:
+        startpos = (lengthx - inc * 3)
+        chunklength = 3
+        if startpos < 0:
+            chunklength += startpos
+            startpos = 0
+        chunk = str(sum_integers)[startpos : startpos + chunklength]
+        #print str(startpos)+' '+str(chunklength)+' '+ chunk
+        wordified = wordify(chunk, inc-1, language)
+        inc += 1
+        spacer = ''
+        if len(diginwords) > 0 :
+            spacer = ' '
+        diginwords = wordified + spacer + diginwords
+    return diginwords
+
+def wordify(chunk, chunknr, language):
+    #print 'chunk '+str(chunk)
+    #print 'cunknr '+str(chunknr)
+    words = u''
+
+    if language == 'lv_LV':
+        skaitli = [u'nulle', u'viens', u'divi', u'trīs', u'četri', u'pieci',
+                   u'seši', u'septiņi', u'astoņi', u'deviņi']
+        skaitlix = [u'nulle', u'vien', u'div', u'trīs', u'četr', u'piec', u'seš',
+                    u'septiņ', u'astoņ', u'deviņ']
+        skaitli_teens = [u'desmit', u'vienpadsmit', u'divpadsmit', u'trīspadsmit',
+                         u'četrpadsmit', u'piecpadsmit', u'sešpadsmit',
+                         u'septiņpadsmit', u'astoņpadsmit', u'deviņpadsmit']
+        daudzums = [u'simts', u' tūkstotis', u' miljons', u' miljards']
+        daudzumsx = [u' simti', u' tūkstoši', u' miljoni', u' miljardi']
+
+    elif language == 'en_US':
+        skaitli = [u'zero', u'one', u'two', u'three', u'four', u'five', u'six',
+                   u'seven', u'eight', u'nine']
+        skaitlix = [u'zero', u'one', u'twen', u'thir', u'four', u'fif', u'six',
+                    u'seven', u'eigh', u'nine']
+        skaitli_teens = [u'ten', u'eleven', u'twelve', u'thirteen', u'fourteen',
+                         u'fifteen', u'sixteen', u'seventeen', u'eighteen', u'nineteen']
+        daudzums = [u' hundred', u' thousand', u' million', u' billion']
+        daudzumsx = daudzums
+
+    elif language == 'ru_RU':
+        skaitli = [u'ноль', u'один', u'два', u'три', u'четыре', u'пять', u'шесть',
+                   u'семь', u'восемь', u'девять']
+        skaitlix = [u'', u'один', u'двa', u'три', u'четыре', u'пять', u'шесть',
+                    u'семь', u'восемь', u'девять']
+        skaitli_teens = [u'десять', u'одиннадцать', u'двенадцать', u'тринадцать',
+                         u'четырнадцать', u'пятнадцать', u'шестнадцать', u'семнадцать',
+                         u'восемнадцать', u'девятнадцать']
+        daudzums = [u'стo', u' тысяча', u' миллион', u' миллиард']
+        daudzumsx = [u'сoт', u' тысяч', u' миллионов', u' миллиардов']
+
+    elif language == 'uk_UA' :
+	skaitli = [u'ноль', u'один', u'два', u'три', u'чотири', u'п\'ять', u'шість',
+		    u'сім', u'вісім', u'дев\'ять']
+	skaitlix = [u'', u'один', u'двa', u'три', u'чотири', u'п\'ять', u'шість',
+		    u'сім', u'вісім', u'дев\'ять']
+	skaitli_teens = [u'десять', u'одинадцять', u'дванадцять', u'тринадцять',
+			u'чотирнадцять', u'п\'ятнадцять', u'шістнадцять', u'сімнадцять',
+			u'вісімнадцять', u'дев\'ятнадцять']
+	daudzums = [u'стo', u' тисяча', u' мiллiон', u' мiллiард']
+	daudzumsx = [u'сoт', u' тисяч', u' мiллiонiв', u' мiллiардов']
+    digit1 = u''
+    digit2 = u''
+    digit3 = u''
+    chunklength = len(chunk)
+    # placing digits in right places
+    if chunklength == 1:
+        digit3 = chunk[0 : 1]
+    if chunklength == 2:
+        digit2 = chunk[0 : 1]
+        digit3 = chunk[1 : 2]
+    if chunklength == 3:
+        digit1 = chunk[0 : 1]
+        digit2 = chunk[1 : 2]
+        digit3 = chunk[-1]
+    # processing zero
+    if chunklength == 1 and digit3  == '0' :
+        return skaitli[0]
+    # processing hundreds
+    if chunklength == 3 :
+        if digit1 == '1' :
+            if language == 'lv_LV' or language == 'ru_RU' or language == 'uk_UA':
+                words += daudzums[0]
+            elif language == 'en_US' :
+                words += skaitli[int(digit1)] + daudzumsx[0]
+        else :
+            if language == 'lv_LV' :
+                if int(digit1) > 1 : words += skaitli[int(digit1)] + daudzumsx[0]
+            elif language == 'en_US' :
+                if int(digit1) > 1 : words += skaitli[int(digit1)] + daudzumsx[0]
+            elif language == 'ru_RU' :
+                if int(digit1) == 2 :
+                    words += u'двести'
+                elif int(digit1) == 3 :
+                    words += u'триста'
+                elif int(digit1) == 4 :
+                    words += u'четыреста'
+                elif int(digit1) >= 5 :
+                    words += skaitli[int(digit1)] + daudzumsx[0]
+	    elif language == 'uk_UA' :
+		if int(digit1) == 2 :
+		    words += u'двісті'
+		elif int(digit1) == 3 :
+		    words += u'триста'
+		elif int(digit1) == 4 :
+		    words += u'чотириста'
+		elif int(digit1) >= 5 :
+		    words += skaitli[int(digit1)] + daudzumsx[0]
+    # processing tens
+    if chunklength > 1:
+        spacer = ''
+        if len(words) > 0 : spacer = ' '
+        if digit2 == '1':
+	    if language == 'lv_LV' or language == 'en_US' or language == 'ru_RU' or language == 'uk_UA':
+                words += spacer + skaitli_teens[int(digit3)]
+        else:
+            if language == 'lv_LV':
+                if int(digit2) > 1 and int(digit2) > 0:
+                    words += spacer + skaitlix[int(digit2)] + u'desmit'
+            elif language == 'en_US':
+                if int(digit2) > 1 and int(digit2) > 0:
+                    words += spacer + skaitlix[int(digit2)] + u'ty'
+	    elif language == 'ru_RU':
+                if int(digit2) > 1 and int(digit2) < 4:
+                    words += spacer + skaitlix[int(digit2)] + u'дцать'
+                elif digit2 == '4':
+                    words += spacer + u'сорок'
+                elif int(digit2) >= 5 and int(digit2) != 9:
+                    words += spacer + skaitlix[int(digit2)] + u'десят'
+                elif digit2 == '9':
+                    words += spacer + u'девяносто'
+	    elif language == 'uk_UA' :
+		if int(digit2) > 1 and int(digit2) < 4:
+		    words += spacer + skaitlix[int(digit2)] + u'дцять'
+		elif digit2 == '4':
+		    words += spacer + u'сорок'
+		elif int(digit2) >= 5 and int(digit2) != 9:
+		    words += spacer + skaitlix[int(digit2)] + u'десят'
+		elif digit2 == '9':
+		    words += spacer + u'дев\'яносто'
+    # processing ones
+    if chunklength > 0 and digit2 != '1' :
+        spacer = ''
+        if len(words) > 0: spacer = u' '
+        if language == 'lv_LV' or language == 'en_US':
+	    if int(digit3) > 0:
+                words += spacer + skaitli[int(digit3)]
+	elif language == 'ru_RU':
+            if chunknr == 1:
+                if int(digit3) == 1:
+                    words += spacer + u'одна'
+                elif int(digit3) == 2: 
+                    words += spacer + u'две'
+                elif int(digit3) >= 3 and int(digit3) != 0: 
+                    words += spacer + skaitli[int(digit3)]
+            else:
+                if int(digit3) > 0: words += spacer + skaitli[int(digit3)]
+	elif language == 'uk_UA' :
+	    if chunknr == 1 :
+		if int(digit3) == 1 : words += spacer + u'одна'
+		elif int(digit3) == 2 : words += spacer + u'дві'
+		elif int(digit3) >= 3 and int(digit3) != 0: words += spacer + skaitli[int(digit3)]
+	    else:
+		if int(digit3) > 0 : words += spacer + skaitli[int(digit3)]
+    # end processing
+    if len(words) > 0 :
+        
+        if digit3 == '1' and chunknr > 0:
+	    return words + daudzums[chunknr]
+        elif digit3 != '1' and chunknr > 0:
+	    if language == 'lv_LV' or language == 'en_US' :
+		return words + daudzumsx[chunknr]
+	    elif language == 'ru_RU' :
+		if (int(digit3) == 2 or int(digit3) == 3 or int(digit3) == 4) and digit2 != '1' :
+	    	    if chunknr == 1 :
+			return words + u' тысячи'
+	    	    elif chunknr == 2 :
+			return words + u' миллионa'
+	    	    elif chunknr == 3 :
+			return words + u' миллиардa'
+		else:
+	    	    return words + daudzumsx[chunknr]
+	    elif language == 'uk_UA' :
+		if (int(digit3) == 2 or int(digit3) == 3 or int(digit3) == 4) and digit2 != '1' :
+		    if chunknr == 1 :
+			return words + u' тисячі'
+		    elif chunknr == 2 :
+			return words + u' мілліонa'
+		    elif chunknr == 3 :
+			return words + u' мілліардa'
+		else:
+		    return words + daudzumsx[chunknr]
+	else:
+	    return words
+    else:
+	return ''
+
+
+if __name__ == '__main__':
+    import doctest
+    doctest.testmod()
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:

=== added directory 'report_aeroo/data'
=== added file 'report_aeroo/data/report_aeroo_data.xml'
--- report_aeroo/data/report_aeroo_data.xml	1970-01-01 00:00:00 +0000
+++ report_aeroo/data/report_aeroo_data.xml	2014-04-05 13:18:49 +0000
@@ -0,0 +1,25 @@
+<?xml version="1.0"?>
+<openerp>
+    <data noupdate="1">
+
+	    <record model="report.mimetypes" id="report_mimetypes_odt_odt" >
+		    <field name="name">ODF Text Document (.odt)</field>
+		    <field name="code">oo-odt</field>
+		    <field name="compatible_types">oo-odt</field>
+	    </record>
+
+	    <record model="report.mimetypes" id="report_mimetypes_ods_ods" >
+		    <field name="name">ODF Spreadsheet (.ods)</field>
+		    <field name="code">oo-ods</field>
+		    <field name="compatible_types">oo-ods</field>
+	    </record>
+
+	    <record model="report.mimetypes" id="report_mimetypes_raw" >
+		    <field name="name">Generic</field>
+		    <field name="code">genshi-raw</field>
+		    <field name="compatible_types">genshi-raw</field>
+	    </record>
+
+    </data>
+</openerp>
+

=== added file 'report_aeroo/domain_parser.py'
--- report_aeroo/domain_parser.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/domain_parser.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,49 @@
+##############################################################################
+#
+# Copyright (c) 2009-2011 Alistek Ltd (http://www.alistek.com) All Rights Reserved.
+#                    General contacts <[e-mail]>
+#
+# WARNING: This program as such is intended to be used by professional
+# programmers who take the whole responsability of assessing all potential
+# consequences resulting from its eventual inadequacies and bugs
+# End users who are looking for a ready-to-use solution with commercial
+# garantees and support are strongly adviced to contract a Free Software
+# Service Company
+#
+# 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 module is GPLv3 or newer and incompatible
+# with OpenERP SA "AGPL + Private Use License"!
+#
+# 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, write to the Free Software
+# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
+#
+##############################################################################
+
+def domain2statement(domain):
+    statement=''
+    operator=False
+    for d in domain:
+        if not operator:
+            if type(d)==str:
+                if d=='|':
+                    operator=' or'
+                continue
+            else:
+                operator=False
+        statement+=' o.'+str(d[0])+' '+(d[1]=='=' and '==' or d[1])+' '+(isinstance(d[2], str) and '\''+d[2]+'\'' or str(d[2]))
+        if d!=domain[-1]:
+             statement+=operator or ' and'
+        operator=False
+    return statement
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:

=== added file 'report_aeroo/installer.py'
--- report_aeroo/installer.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/installer.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,79 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+# Copyright (c) 2008-2013 Alistek Ltd (http://www.alistek.com) All Rights Reserved.
+#                    General contacts <[e-mail]>
+#
+# WARNING: This program as such is intended to be used by professional
+# programmers who take the whole responsability of assessing all potential
+# consequences resulting from its eventual inadequacies and bugs
+# End users who are looking for a ready-to-use solution with commercial
+# garantees and support are strongly adviced to contract a Free Software
+# Service Company
+#
+# 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 module is GPLv3 or newer and incompatible
+# with OpenERP SA "AGPL + Private Use License"!
+#
+# 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, write to the Free Software
+# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
+#
+##############################################################################
+from openerp.osv import orm, fields
+from openerp import netsvc
+from openerp import tools
+import os, base64
+import urllib2
+
+_url = 'http://www.alistek.com/aeroo_banner/v7_0_report_aeroo.png'
+
+class report_aeroo_installer(orm.TransientModel):
+    _name = 'report.aeroo.installer'
+    _inherit = 'res.config.installer'
+    _logo_image = None
+
+    def _get_image(self, cr, uid, context=None):
+        if self._logo_image:
+            return self._logo_image
+        try:
+            im = urllib2.urlopen(_url.encode("UTF-8"))
+            if im.headers.maintype!='image':
+                raise TypeError(im.headers.maintype)
+        except Exception, e:
+            path = os.path.join('report_aeroo','config_pixmaps','module_banner.png')
+            image_file = file_data = tools.file_open(path,'rb')
+            try:
+                file_data = image_file.read()
+                self._logo_image = base64.encodestring(file_data)
+                return self._logo_image
+            finally:
+                image_file.close()
+        else:
+            self._logo_image = base64.encodestring(im.read())
+            return self._logo_image
+
+    def _get_image_fn(self, cr, uid, ids, name, args, context=None):
+        image = self._get_image(cr, uid, context)
+        return dict.fromkeys(ids, image) # ok to use .fromkeys() as the image is same for all 
+
+    _columns = {
+        'link':fields.char('Original developer', size=128, readonly=True),
+        'config_logo': fields.function(_get_image_fn, string='Image', type='binary', method=True),
+    }
+
+    _defaults = {
+        'config_logo': _get_image,
+        'link':'http://www.alistek.com',
+    }
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:

=== added file 'report_aeroo/installer.xml'
--- report_aeroo/installer.xml	1970-01-01 00:00:00 +0000
+++ report_aeroo/installer.xml	2014-04-05 13:18:49 +0000
@@ -0,0 +1,56 @@
+<openerp>
+  <data>
+
+    <record id="view_report_aeroo_installer" model="ir.ui.view">
+      <field name="name">report.aeroo.installer.view</field>
+      <field name="model">report.aeroo.installer</field>
+      <field name="type">form</field>
+      <field name="inherit_id" ref="base.res_config_installer"/>
+      <field name="arch" type="xml">
+          <data>
+                <form position="attributes" version="7.0">
+                  <attribute name="string">Aeroo Reports Installation</attribute>
+                </form>
+                <footer position="replace">
+                    <footer>
+                        <button name="action_next" type="object" string="Continue" invisible="context.get('menu',False)" class="oe_highlight"/>
+                        or
+                        <button special="cancel" string="Close" class="oe_link"/>
+                    </footer>
+                </footer>
+                <separator string="title" position="replace">
+                    <p class="oe_grey">
+                        Aeroo Reports for OpenERP is a comprehensive reporting engine based on Aeroo Library.
+                    </p>
+                    <group>
+                        <group width="25%%">
+                          <field name="config_logo" widget="image" nolabel="1" colspan="2"/>
+                        </group>
+                        <group width="75%%">
+                          <field name="link" widget="url"/>
+                        </group>
+                    </group>
+                </separator>
+          </data>
+      </field>
+    </record>
+
+    <record id="action_report_aeroo_installer" model="ir.actions.act_window">
+      <field name="name">Aeroo Reports Installation</field>
+      <field name="type">ir.actions.act_window</field>
+      <field name="res_model">report.aeroo.installer</field>
+      <field name="view_id" ref="view_report_aeroo_installer"/>
+      <field name="view_type">form</field>
+      <field name="view_mode">form</field>
+      <field name="target">new</field>
+    </record>
+
+    <record id="report_aeroo_installer_todo" model="ir.actions.todo">
+        <field name="action_id" ref="action_report_aeroo_installer"/>
+        <field name="restart">always</field>
+        <field name="sequence">3</field>
+        <field name="type">automatic</field>
+    </record>
+
+  </data>
+</openerp>

=== added file 'report_aeroo/report_aeroo.py'
--- report_aeroo/report_aeroo.py	1970-01-01 00:00:00 +0000
+++ report_aeroo/report_aeroo.py	2014-04-05 13:18:49 +0000
@@ -0,0 +1,859 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+# Copyright (c) 2009-2013 Alistek Ltd (http://www.alistek.com) All Rights Reserved.
+#                    General contacts <[e-mail]>
+# Copyright (C) 2009  Domsense s.r.l.
+#
+# WARNING: This program as such is intended to be used by professional
+# programmers who take the whole responsability of assessing all potential
+# consequences resulting from its eventual inadequacies and bugs
+# End users who are looking for a ready-to-use solution with commercial
+# garantees and support are strongly adviced to contract a Free Software
+# Service Company
+#
+# 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 module is GPLv3 or newer and incompatible
+# with OpenERP SA "AGPL + Private Use License"!
+#
+# 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, write to the Free Software
+# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
+#
+##############################################################################
+
+import os, sys, traceback
+from tempfile import NamedTemporaryFile
+from openerp import report
+from report.report_sxw import report_sxw, report_rml, browse_record_list, _fields_process
+from report.pyPdf import PdfFileWriter, PdfFileReader
+#import zipfile
+try:
+    from cStringIO import StringIO
+except ImportError:
+    from StringIO import StringIO
+from xml.dom import minidom
+import base64
+from openerp.osv import orm
+from openerp import tools
+from tools.translate import _
+import time
+import re
+import copy
+import threading
+from random import randint
+try:
+    from addons import load_information_from_description_file # for OpenERP 6.0.x
+except ImportError:
+    from openerp.modules import load_information_from_description_file # for OpenERP 6.1 or 7.0
+from openerp import release
+
+import aeroolib
+from aeroolib.plugins.opendocument import Template, OOSerializer
+from genshi.template import NewTextTemplate
+from genshi import __version__ as genshi_version
+from openerp import pooler
+from openerp import netsvc
+from lxml import etree
+import logging
+
+logger = logging.getLogger(__name__)
+
+from .ExtraFunctions import ExtraFunctions
+
+try:
+    aeroo_lock = threading.Lock()
+    msg = "Aeroo lock instantiated."
+    logger.log(logging.INFO, msg)
+except Exception:
+    err_msg = "Could not instantiate Aeroo lock!!!"
+    logger.log(logging.CRITICAL, err_msg)
+
+from openerp import SUPERUSER_ID
+
+def _aeroo_ooo_test(cr):
+    '''
+    Detect report_aeroo_ooo module
+    '''
+    aeroo_ooo = False
+    cr.execute("SELECT id, state FROM ir_module_module WHERE name='report_aeroo_ooo'")
+    helper_module = cr.dictfetchone()
+    if helper_module and helper_module['state'] in ('installed', 'to upgrade'):
+        aeroo_ooo = True
+    return aeroo_ooo
+
+class Counter(object):
+    def __init__(self, name, start=0, interval=1):
+        self.name = name
+        self._number = start
+        self._interval = interval
+
+    def next(self, increment=True):
+        if increment:
+            self._number += self._interval
+            return self._number
+        else:
+            return self._number + self._interval
+
+    def get_inc(self):
+        return self._number
+
+    def prev(self, decrement=True):
+        if decrement:
+            self._number -= self._interval
+            return self._number
+        else:
+            return self._number-self._interval
+
+class AerooPrint(object):
+    print_ids = [] # static property
+    def __init__(self):
+        print_id = False
+        while(not print_id or print_id in self.print_ids):
+            print_id = randint(1, 99999)
+        self.print_ids.append(print_id)
+        self.id = print_id
+        self.subreports = []
+        self.epl_images = []
+        self.counters = {}
+        self.start_time = 0
+        self.start_total_time = 0
+
+class Aeroo_report(report_sxw):
+
+    _logger = logging.getLogger(__name__)
+
+    def __init__(self, cr, name, table, rml=False, parser=False, header=True, store=False):
+        super(Aeroo_report, self).__init__(name, table, rml, parser, header, store)
+        self._logger.info("registering %s (%s)" % (name, table))
+        self.active_prints = {}
+        self.oo_subreports = []
+        self.epl_images = []
+        self.counters = {}
+        self.start_time = 0
+
+        pool = pooler.get_pool(cr.dbname)
+        ir_obj = pool.get('ir.actions.report.xml')
+        name = name.startswith('report.') and name[7:] or name
+        try:
+            report_xml_ids = ir_obj.search(cr, SUPERUSER_ID, [('report_name', '=', name)])
+            if report_xml_ids:
+                report_xml = ir_obj.browse(cr, SUPERUSER_ID, report_xml_ids[0])
+            else:
+                report_xml = False
+
+            if report_xml and report_xml.preload_mode == 'preload':
+                file_data = report_xml.report_sxw_content
+                if not file_data:
+                    self._logger.warning("template is not defined in %s (%s) !" % (name, table))
+                    template_io = None
+                else:
+                    template_io = StringIO()
+                    template_io.write(base64.decodestring(file_data))
+                    style_io=self.get_styles_file(cr, SUPERUSER_ID, report_xml)
+                if template_io:
+                    self.serializer = OOSerializer(template_io, oo_styles=style_io)
+        except Exception, e:
+            print e
+
+    def getObjects_mod(self, cr, uid, ids, rep_type, context):
+        table_obj = pooler.get_pool(cr.dbname).get(self.table)
+        if rep_type=='aeroo':
+            return table_obj.browse(cr, uid, ids, list_class=browse_record_list, context=context)
+        return table_obj.browse(cr, uid, ids, list_class=browse_record_list, context=context)
+
+    ##### Counter functions #####
+    def _def_inc(self, aeroo_print):
+        def def_inc(name, start=0, interval=1):
+            aeroo_print.counters[name] = Counter(name, start, interval)
+        return def_inc
+
+    def _get_inc(self, aeroo_print):
+        def get_inc(name):
+            return aeroo_print.counters[name].get_inc()
+        return get_inc
+
+    def _prev(self, aeroo_print):
+        def prev(name):
+            return aeroo_print.counters[name].prev()
+        return prev
+
+    def _next(self, aeroo_print):
+        def next(name):
+            return aeroo_print.counters[name].next()
+        return next
+    #############################
+
+    def _epl_asimage(self, data, aeroo_print):
+        from PIL import Image
+        from math import ceil
+        if not data:
+            return ''
+        img = Image.open(StringIO(base64.decodestring(data)))
+        if img.format!='BMP':
+            return ''
+        data = base64.decodestring(data)[62:]
+        line_len = int(ceil(img.size[0]/32.0)*4)
+        temp_data = ''
+        for n in range(img.size[1]):
+            curr_pos = n*line_len
+            temp_data = data[curr_pos:curr_pos+line_len][:int(img.size[0]/8)] + temp_data
+
+        new_data = ''
+        for d in temp_data:
+            new_data += chr(ord(d)^255)
+        aeroo_print.epl_images.append(new_data)
+        return img.size
+
+    def _epl2_gw(self, aeroo_print):
+        def epl2_gw(start_x, start_y, data):
+            if not data:
+                return None
+            size_x, size_y = self._epl_asimage(data, aeroo_print)
+            return 'GW'+str(start_x)+','+str(start_y)+','+str(int(size_x/8))+','+str(size_y)+',<binary_data>'
+        return epl2_gw
+
+    def _include_document(self, print_id, aeroo_ooo=False):
+        def include_document(data, silent=False):
+            if not aeroo_ooo:
+                return _("Error! Include document not available!")
+            import binascii, urllib2
+            temp_file = NamedTemporaryFile(suffix='.odt', prefix='aeroo-report-', delete=False)
+            if os.path.isfile(data):
+                fd = file(data, 'rb')
+                data = fd.read()
+            else:
+                error = False
+                try:
+                    url_file = urllib2.urlopen(data)
+                    data = url_file.read()
+                except urllib2.HTTPError, e:
+                    os.unlink(temp_file.name)
+                    error = _('HTTP Error %s! File not found:') % e.getcode() + ' %s' % data
+                except urllib2.URLError, e:
+                    os.unlink(temp_file.name)
+                    error = _('Error!')+' %s' % e
+                except IOError, e:
+                    os.unlink(temp_file.name)
+                    error = _('Error!')+' %s' % e
+                except Exception, e:
+                    try:
+                        data = base64.decodestring(data)
+                    except binascii.Error:
+                        os.unlink(temp_file.name)
+                        error = _('Error! File not found:')+' %s' % data
+                if error:
+                    if not silent:
+                        return error
+                    else:
+                        return None
+            try:
+                temp_file.write(data)
+            finally:
+                temp_file.close()
+            #self.oo_subreports[print_id].append(temp_file.name)
+            self.active_prints[print_id].subreports.append(temp_file.name)
+            return "<insert_doc('%s')>" % temp_file.name
+        return include_document
+
+    def _subreport(self, cr, uid, aeroo_print, output='odt', aeroo_ooo=False, context={}):
+        pool = pooler.get_pool(cr.dbname)
+        ir_obj = pool.get('ir.actions.report.xml')
+        #### for odt documents ####
+        def odt_subreport(name=None, obj=None):
+            if not aeroo_ooo:
+                return _("Error! Subreports not available!")
+            report_xml_ids = ir_obj.search(cr, uid, [('report_name', '=', name)], context=context)
+            if report_xml_ids:
+                service = netsvc.Service._services['report.%s' % name]
+                report_xml = ir_obj.browse(cr, uid, report_xml_ids[0], context=context)
+                data = {'model': obj._table_name, 'id': obj.id, 'report_type': 'aeroo', 'in_format': 'oo-odt'}
+                ### Get new printing object ###
+                sub_aeroo_print = AerooPrint()
+                service.active_prints[sub_aeroo_print.id] = sub_aeroo_print
+                context['print_id'] = sub_aeroo_print.id
+                ###############################
+                sub_aeroo_print.start_time = time.time()
+                report, output = service.create_aeroo_report(cr, uid, \
+                                            [obj.id], data, report_xml, context=context, output='odt') # change for OpenERP 6.0 - Service class usage
+
+                ### Delete printing object ###
+                AerooPrint.print_ids.remove(sub_aeroo_print.id)
+                del service.active_prints[sub_aeroo_print.id]
+                ##############################
+                with NamedTemporaryFile(suffix='.odt', prefix='aeroo-report-', delete=False) as temp_file:
+                    temp_file.write(report)
+
+                #self.oo_subreports[print_id].append(temp_file.name)
+                aeroo_print.subreports.append(temp_file.name)
+
+                return "<insert_doc('%s')>" % temp_file.name
+            return None
+        #### for text documents ####
+        def raw_subreport(name=None, obj=None):
+            report_xml_ids = ir_obj.search(cr, uid, [('report_name', '=', name)], context=context)
+            if report_xml_ids:
+                report_xml = ir_obj.browse(cr, uid, report_xml_ids[0], context=context)
+                data = {'model': obj._table_name, 'id': obj.id, 'report_type': 'aeroo', 'in_format': 'genshi-raw'}
+                report, output = netsvc.Service._services['report.%s' % name].create_genshi_raw_report(cr, uid, \
+                                            [obj.id], data, report_xml, context=context, output=output) # change for OpenERP 6.0 - Service class usage
+                return report
+            return None
+
+        if output=='odt':
+            return odt_subreport
+        elif output=='raw':
+            return raw_subreport
+
+    def set_xml_data_fields(self, objects, parser):
+        xml_data_fields = parser.localcontext.get('xml_data_fields', False)
+        if xml_data_fields:
+            for field in xml_data_fields:
+                for o in objects:
+                    if getattr(o, field):
+                        xml_data = base64.decodestring(getattr(o, field))
+                        xmldoc = minidom.parseString(xml_data)
+                        setattr(o, field, xmldoc.firstChild)
+        return objects
+
+    def get_other_template(self, cr, uid, data, parser):
+        if hasattr(parser, 'get_template'):
+            pool = pooler.get_pool(cr.dbname)
+            record = pool.get(data['model']).browse(cr, uid, data['id'], {})
+            template = parser.get_template(cr, uid, record)
+            return template
+        else:
+            return False
+
+    def get_styles_file(self, cr, uid, report_xml, company=None, context=None):
+        pool = pooler.get_pool(cr.dbname)
+        style_io=None
+        if report_xml.styles_mode!='default':
+            if report_xml.styles_mode=='global':
+                company_id = company or pool.get('res.users')._get_company(cr, uid, context=context)
+                style_content = pool.get('res.company').browse(cr, uid, company_id, context=context).stylesheet_id
+                style_content = style_content and style_content.report_styles or False
+            elif report_xml.styles_mode=='specified':
+                style_content = report_xml.stylesheet_id
+                style_content = style_content and style_content.report_styles or False
+            if style_content:
+                style_io = StringIO()
+                style_io.write(base64.decodestring(style_content))
+        return style_io
+
+    def create_genshi_raw_report(self, cr, uid, ids, data, report_xml, context=None, output='raw', tmpl=False):
+        def preprocess(data, aeroo_print):
+            aeroo_print.epl_images.reverse()
+            while aeroo_print.epl_images:
+                img = aeroo_print.epl_images.pop()
+                data = data.replace('<binary_data>', img, 1)
+            return data.replace('\n', '\r\n')
+
+        print_id = context.get('print_id', False)
+        aeroo_print = self.active_prints[print_id] # Aeroo print object
+        if not aeroo_print.start_time:
+            aeroo_print.start_time = time.time()
+        if not context:
+            context={}
+        context = context.copy()
+        objects = self.getObjects_mod(cr, uid, ids, report_xml.report_type, context)
+        oo_parser = self.parser(cr, uid, self.name2, context=context)
+        oo_parser.localcontext.update(context)
+        oo_parser.set_context(objects, data, ids, report_xml.report_type)
+        self.set_xml_data_fields(oo_parser.objects, oo_parser) # Get/Set XML
+        oo_parser.localcontext['data'] = data
+        oo_parser.localcontext['user_lang'] = context.get('lang', False)
+        if len(objects)>0:
+            oo_parser.localcontext['o'] = objects[0]
+        xfunc = ExtraFunctions(cr, uid, report_xml.id, oo_parser.localcontext)
+        oo_parser.localcontext.update(xfunc.functions)
+        file_data = tmpl or self.get_other_template(cr, uid, data, oo_parser) or report_xml.report_sxw_content # Get other Tamplate
+        if not file_data or file_data=='False':
+            raise orm.except_orm(_('Error!'), _('No template found!'))
+        ################################################
+        if not file_data:
+            self._logger.info("End process %s (%s), elapsed time: %s" % (self.name, self.table, time.time() - aeroo_print.start_time)) # debug mode
+            return False, output
+
+        print_id = context.get('print_id', False)
+        aeroo_print = self.active_prints[print_id]
+
+        oo_parser.localcontext['include_subreport'] = self._subreport(cr, uid, aeroo_print, output='raw', aeroo_ooo=False, context=context)
+        oo_parser.localcontext['epl2_gw'] = self._epl2_gw(aeroo_print)
+        deferred = context.get('deferred_process')
+        oo_parser.localcontext['progress_update'] = deferred and deferred.progress_update or (lambda:True)
+
+        aeroo_print.epl_images = []
+        basic = NewTextTemplate(source=base64.decodestring(file_data))
+        if genshi_version<='0.6':
+            data = preprocess(basic.generate(**oo_parser.localcontext).render().decode('utf8').encode(report_xml.charset), aeroo_print)
+        else:
+            data = preprocess(basic.generate(**oo_parser.localcontext).render().encode(report_xml.charset), aeroo_print)
+
+        if report_xml.content_fname:
+            output = report_xml.content_fname
+        self._logger.info("End process %s (%s), elapsed time: %s" % (self.name, self.table, time.time() - aeroo_print.start_time)) # debug mode
+        return data, output
+
+    def _generate_doc(self, DC, data, report_xml, print_id):
+        with aeroo_lock:
+            DC.putDocument(data)
+            #subreports = self.oo_subreports.get(print_id)
+            aeroo_print = self.active_prints.get(print_id, False)
+            if aeroo_print:
+                DC.insertSubreports(aeroo_print.subreports)
+                #self.oo_subreports = []
+                #del self.oo_subreports[print_id]
+            if report_xml.out_format.code=='oo-dbf':
+                data = DC.saveByStream(report_xml.out_format.filter_name, "78")
+            else:
+                data = DC.saveByStream(report_xml.out_format.filter_name)
+            DC.closeDocument()
+        return data
+
+    def _raise_exception(self, e, print_id):
+        tb_s = reduce(lambda x, y: x+y, traceback.format_exception(sys.exc_type, sys.exc_value, sys.exc_traceback))
+        self._logger.error(_("Report generation error!")+'\n'+tb_s)
+        #subreports = self.oo_subreports.get(print_id, [])
+        aeroo_print = self.active_prints.get(print_id, [])
+        if aeroo_print:
+            for sub_report in aeroo_print.subreports:
+                if os.path.isfile(sub_report):
+                    os.unlink(sub_report)
+        raise Exception(_("Aeroo Reports: Error while generating the report."), e, str(e), _("For more reference inspect error logs."))
+
+    def create_aeroo_report(self, cr, uid, ids, data, report_xml, context=None, output='odt'):
+        """ Returns an aeroo report generated with aeroolib
+        """
+        pool = pooler.get_pool(cr.dbname)
+        if not context:
+            context={}
+        context = context.copy()
+        if self.name=='report.printscreen.list':
+            context['model'] = data['model']
+            context['ids'] = ids
+
+        print_id = context.get('print_id', False)
+        aeroo_print = self.active_prints[print_id] # Aeroo print object
+        aeroo_print.subreports = []
+        #self.oo_subreports[print_id] = []
+        objects = self.getObjects_mod(cr, uid, ids, report_xml.report_type, context) or []
+        oo_parser = self.parser(cr, uid, self.name2, context=context)
+        oo_parser.localcontext.update(context)
+        oo_parser.set_context(objects, data, ids, report_xml.report_type)
+        self.set_xml_data_fields(objects, oo_parser) # Get/Set XML
+
+        oo_parser.localcontext['data'] = data
+        oo_parser.localcontext['user_lang'] = context.get('lang', False)
+        if len(objects)>0:
+            oo_parser.localcontext['o'] = objects[0]
+        xfunc = ExtraFunctions(cr, uid, report_xml.id, oo_parser.localcontext)
+        oo_parser.localcontext.update(xfunc.functions)
+
+        #company_id = objects and 'company_id' in objects[0]._table._columns.keys() and \
+        #                        objects[0].company_id and objects[0].company_id.id or False # for object company usage
+        company_id = False
+        style_io=self.get_styles_file(cr, uid, report_xml, company=company_id, context=context)
+
+        if report_xml.tml_source in ('file', 'database'):
+            if not report_xml.report_sxw_content or report_xml.report_sxw_content=='False':
+                raise orm.except_orm(_('Error!'), _('No template found!'))
+            file_data = base64.decodestring(report_xml.report_sxw_content)
+        else:
+            file_data = self.get_other_template(cr, uid, data, oo_parser)
+        if not file_data and not report_xml.report_sxw_content:
+            self._logger.info("End process %s (%s), elapsed time: %s" % (self.name, self.table, time.time() - aeroo_print.start_time)) # debug mode
+            return False, output
+        #elif file_data:
+        #    template_io = StringIO()
+        #    template_io.write(file_data or report_xml.report_sxw_content)
+        #    basic = Template(source=template_io, styles=style_io)
+        else:
+            if report_xml.preload_mode == 'preload' and hasattr(self, 'serializer'):
+                serializer = copy.copy(self.serializer)
+                serializer.apply_style(style_io)
+                template_io = serializer.template
+            else:
+                template_io = StringIO()
+                template_io.write(file_data or base64.decodestring(report_xml.report_sxw_content) )
+                serializer = OOSerializer(template_io, oo_styles=style_io)
+            try:
+                basic = Template(source=template_io, serializer=serializer)
+            except Exception, e:
+                self._raise_exception(e, print_id)
+
+        #if not file_data:
+        #    return False, output
+
+        #basic = Template(source=template_io, serializer=serializer)
+
+        aeroo_ooo = context.get('aeroo_ooo', False)
+        oo_parser.localcontext['include_subreport'] = self._subreport(cr, uid, aeroo_print, output='odt', aeroo_ooo=aeroo_ooo, context=context)
+        oo_parser.localcontext['include_document'] = self._include_document(aeroo_ooo, print_id)
+        deferred = context.get('deferred_process')
+        oo_parser.localcontext['progress_update'] = deferred and deferred.progress_update or (lambda:True)
+        ####### Add counter functons to localcontext #######
+        oo_parser.localcontext.update({'def_inc':self._def_inc(aeroo_print),
+                                      'get_inc':self._get_inc(aeroo_print),
+                                      'prev':self._prev(aeroo_print),
+                                      'next':self._next(aeroo_print)})
+
+        user_name = pool.get('res.users').browse(cr, uid, uid, {}).name
+        model_id = pool.get('ir.model').search(cr, uid, [('model','=',context.get('active_model', data['model']) or data['model'])])[0]
+        model_name = pool.get('ir.model').browse(cr, uid, model_id).name
+
+        #basic = Template(source=None, filepath=odt_path)
+
+        basic.Serializer.add_title(model_name)
+        basic.Serializer.add_creation_user(user_name)
+        module_info = load_information_from_description_file('report_aeroo')
+        version = module_info['version']
+        basic.Serializer.add_generator_info('Aeroo Lib/%s Aeroo Reports/%s' % (aeroolib.__version__, version))
+        basic.Serializer.add_custom_property('Aeroo Reports %s' % version, 'Generator')
+        basic.Serializer.add_custom_property('OpenERP %s' % release.version, 'Software')
+        basic.Serializer.add_custom_property(module_info['website'], 'URL')
+        basic.Serializer.add_creation_date(time.strftime('%Y-%m-%dT%H:%M:%S'))
+
+        try:
+            data = basic.generate(**oo_parser.localcontext).render().getvalue()
+        except orm.except_orm, e:
+            raise
+        except Exception, e:
+            self._raise_exception(e, print_id)
+
+        ######### OpenOffice extras #########
+        DC = netsvc.Service._services.get('openoffice')
+        if output!=report_xml.in_format[3:] or aeroo_print.subreports:
+            if aeroo_ooo and DC:
+                try:
+                    data = self._generate_doc(DC, data, report_xml, print_id)
+                except Exception, e:
+                    self._logger.error(_("OpenOffice.org related error!")+'\n'+str(e))
+                    if DC._restart_ooo():
+                        # We try again
+                        try:
+                            data = self._generate_doc(DC, data, report_xml, print_id)
+                        except Exception, e:
+                            self._logger.error(_("OpenOffice.org related error!")+'\n'+str(e))
+                            if not report_xml.fallback_false:
+                                output=report_xml.in_format[3:]
+                    elif not report_xml.fallback_false:
+                        output=report_xml.in_format[3:]
+                    aeroo_print.subreports = []
+            else:
+                if report_xml.fallback_false:
+                    if not aeroo_ooo:
+                        raise orm.except_orm(_('OpenOffice.org related error!'), _('Module "report_aeroo_ooo" not installed.'))
+                    elif not DC:
+                        raise orm.except_orm(_('OpenOffice.org related error!'), _('Can not connect to OpenOffice.org.'))
+                else:
+                    self._logger.warning("PDF generator temporarily offline, please wait a minute")
+                    output=report_xml.in_format[3:]
+        elif output in ('pdf', 'doc', 'xls'):
+            output=report_xml.in_format[3:]
+        #####################################
+
+        if report_xml.content_fname:
+            output = report_xml.content_fname
+        self._logger.info("End process %s (%s), elapsed time: %s" % (self.name, self.table, time.time() - aeroo_print.start_time))
+        return data, output
+
+    # override needed to keep the attachments' storing procedure
+    def create_single_pdf(self, cr, uid, ids, data, report_xml, context=None):
+        if not context:
+            context={}
+        if report_xml.report_type == 'aeroo':
+            if report_xml.out_format.code.startswith('oo-'):
+                output = report_xml.out_format.code[3:]
+                return self.create_aeroo_report(cr, uid, ids, data, report_xml, context=context, output=output)
+            elif report_xml.out_format.code =='genshi-raw':
+                return self.create_genshi_raw_report(cr, uid, ids, data, report_xml, context=context, output='raw')
+        logo = None
+        context = context.copy()
+        title = report_xml.name
+        rml = report_xml.report_rml_content
+        oo_parser = self.parser(cr, uid, self.name2, context=context)
+        objs = self.getObjects_mod(cr, uid, ids, report_xml.report_type, context)
+        oo_parser.set_context(objs, data, ids, report_xml.report_type)
+        processed_rml = self.preprocess_rml(etree.XML(rml),report_xml.report_type)
+        if report_xml.header:
+            oo_parser._add_header(processed_rml)
+        if oo_parser.logo:
+            logo = base64.decodestring(oo_parser.logo)
+        create_doc = self.generators[report_xml.report_type]
+        pdf = create_doc(etree.tostring(processed_rml),oo_parser.localcontext,logo,title.encode('utf8'))
+        return (pdf, report_xml.report_type)
+
+    def _get_attachment_create_vals(self, cr, uid, report_xml, vals, context=None):
+        if context is None:
+            context = {}
+        pool = pooler.get_pool(cr.dbname)
+        report_obj = pool.get('ir.actions.report.xml')
+        vals = report_obj._get_attachment_create_vals(cr, uid, report_xml, vals, context=context)
+        return vals
+
+    def create_source_pdf(self, cr, uid, ids, data, report_xml, context=None):
+        if not context:
+            context={}
+        pool = pooler.get_pool(cr.dbname)
+        attach = report_xml.attachment
+        aeroo_ooo = _aeroo_ooo_test(cr) # Detect report_aeroo_ooo module
+        context['aeroo_ooo'] = aeroo_ooo
+        print_id = context.get('print_id', False)
+        aeroo_print = self.active_prints[print_id] # Aeroo print object
+        if attach or aeroo_ooo and report_xml.process_sep:
+            objs = self.getObjects_mod(cr, uid, ids, report_xml.report_type, context)
+            deferred = context.get('deferred_process')
+            results = []
+            for obj in objs:
+                aeroo_print.start_time = time.time()
+                if deferred:
+                    deferred.progress_update()
+                aname = attach and eval(attach, {'object':obj, 'time':time}) or False
+                result = False
+                if report_xml.attachment_use and aname and context.get('attachment_use', True):
+                    #aids = pool.get('ir.attachment').search(cr, uid, [('datas_fname','=',aname+'.pdf'),('res_model','=',self.table),('res_id','=',obj.id)])
+                    #if aids:
+                    #    brow_rec = pool.get('ir.attachment').browse(cr, uid, aids[0])
+                    #    if not brow_rec.datas:
+                    #        continue
+                    #    d = base64.decodestring(brow_rec.datas)
+                    #    results.append((d,'pdf'))
+                    #    continue
+                    cr.execute("SELECT id, datas_fname FROM ir_attachment WHERE datas_fname ilike %s and res_model=%s and res_id=%s LIMIT 1", (aname+'.%',self.table,obj.id))
+                    search_res = cr.dictfetchone()
+                    if search_res:
+                        brow_rec = pool.get('ir.attachment').browse(cr, uid, search_res['id'])
+                        if not brow_rec.datas:
+                            continue
+                        d = base64.decodestring(brow_rec.datas)
+                        extension = search_res['datas_fname'].split('.')[1]
+                        results.append((d,extension))
+                        continue
+                result = self.create_single_pdf(cr, uid, [obj.id], data, report_xml, context)
+                if not result:
+                    return False
+                try:
+                    if attach and aname:
+                        name = aname+'.'+result[1]
+                        datas = base64.encodestring(result[0])
+                        ctx = dict(context)
+                        ctx.pop('default_type', None)
+                        vals = {
+                            'name': aname,
+                            'datas': datas,
+                            'file_size': len(datas),
+                            'datas_fname': name,
+                            'res_model': self.table,
+                            'res_id': obj.id,
+                            'type': 'binary',
+                            }
+                        attachment_vals = self._get_attachment_create_vals(
+                            cr, uid, report_xml, vals, context=ctx)
+                        pool.get('ir.attachment').create(cr, uid, attachment_vals, context=ctx)
+                        cr.commit()
+                except Exception,e:
+                    tb_s = reduce(lambda x, y: x+y, traceback.format_exception(sys.exc_type, sys.exc_value, sys.exc_traceback))
+                    self._logger.error(str(e))
+                results.append(result)
+            if results and len(results)==1:
+                return results[0]
+            if results:
+                not_pdf = filter(lambda r: r[1]!='pdf', results)
+                if not_pdf:
+                    raise orm.except_orm(_('Error!'), _('Unsupported combination of formats!'))
+                #if results[0][1]=='pdf':
+                output = PdfFileWriter()
+                for r in results:
+                    reader = PdfFileReader(StringIO(r[0]))
+                    for page in range(reader.getNumPages()):
+                        output.addPage(reader.getPage(page))
+                s = StringIO()
+                output.write(s)
+                return s.getvalue(), results[0][1]
+        return self.create_single_pdf(cr, uid, ids, data, report_xml, context)
+
+    def create_source_odt(self, cr, uid, ids, data, report_xml, context=None):
+        if not context:
+            context={}
+        pool = pooler.get_pool(cr.dbname)
+        results = []
+        attach = report_xml.attachment
+        aeroo_ooo = _aeroo_ooo_test(cr) # Detect report_aeroo_ooo module
+        context['aeroo_ooo'] = aeroo_ooo
+        print_id = context.get('print_id', False)
+        aeroo_print = self.active_prints[print_id] # Aeroo print object
+        if attach or aeroo_ooo and report_xml.process_sep:
+            objs = self.getObjects_mod(cr, uid, ids, report_xml.report_type, context)
+            deferred = context.get('deferred_process')
+            for obj in objs:
+                aeroo_print.start_time = time.time()
+                if deferred:
+                    deferred.progress_update()
+                aname = attach and eval(attach, {'object':obj, 'time':time}) or False
+                result = False
+                if report_xml.attachment_use and aname and context.get('attachment_use', True):
+                    #aids = pool.get('ir.attachment').search(cr, uid, [('datas_fname','=',aname+'.odt'),('res_model','=',self.table),('res_id','=',obj.id)])
+                    #if aids:
+                    #    brow_rec = pool.get('ir.attachment').browse(cr, uid, aids[0])
+                    #    if not brow_rec.datas:
+                    #        continue
+                    #    d = base64.decodestring(brow_rec.datas)
+                    #    results.append((d,'odt'))
+                    #    continue
+                    cr.execute("SELECT id, datas_fname FROM ir_attachment WHERE datas_fname ilike %s and res_model=%s and res_id=%s LIMIT 1", (aname+'.%',self.table,obj.id))
+                    search_res = cr.dictfetchone()
+                    if search_res:
+                        brow_rec = pool.get('ir.attachment').browse(cr, uid, search_res['id'])
+                        if not brow_rec.datas:
+                            continue
+                        d = base64.decodestring(brow_rec.datas)
+                        extension = search_res['datas_fname'].split('.')[1]