Merge lp:~mechiscogo/aeroo/mx into lp:aeroo/trunk

[Prabhu]

Unmerged revisions

2. By mechiscogo <mechiscogo@openerp> on 2011-02-19

Adds MXN (Mexican peso) and Spanish translations to currency_to_text. All the translations for Spanish have the Mexican format: <amount in words> <cents>/100 <currency>

1. By mechiscogo <mechiscogo@openerp> on 2011-02-19

Agrega moneda MXN y traducciones al español en currency_to_text. Todas las traducciones llevan formato para México <importe con letra> <centavos>/100 <moneda>

=== added file 'ExtraFunctions.py'
--- ExtraFunctions.py	1970-01-01 00:00:00 +0000
+++ ExtraFunctions.py	2012-07-05 12:25:24 +0000
@@ -0,0 +1,367 @@
+##############################################################################
+#
+# Copyright (c) 2008-2009 SIA "KN dati". (http://kndati.lv) 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 2
+# of the License, or (at your option) any later version.
+#
+# This program is distributed in the hope that it will be useful,
+# but WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+# GNU General Public License for more details.
+#
+# You should have received a copy of the GNU General Public License
+# along with this program; if not, write to the Free Software
+# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
+#
+##############################################################################
+
+from barcode import barcode
+from tools import translate
+from domain_parser import domain2statement
+from currency_to_text import currency_to_text
+import base64
+import StringIO
+from PIL import Image
+import pooler
+import time
+import osv
+from report import report_sxw
+from tools.translate import _
+import netsvc
+
+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 = {
+            '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':self._sum,
+            'max':self._max,
+            'min':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,
+            'field_size':self._field_size,
+            '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(),
+        }
+
+    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:"[ ]"},
+                    }
+        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(currency_to_text(sum, currency, language or self._get_lang()), "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]})
+        return translate(self.cr, False, '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__==osv.orm.browse_record:
+            return self.pool.get(obj._table_name).name_get(self.cr, self.uid, [obj.id], {'lang':self._get_lang()})[0][1]
+        return ''
+
+    #def _get_label(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):
+    #            label = self.pool.get(model)._columns[field].string
+    #            return translate(self.cr, False, 'field', self._get_lang(), label) or label
+    #    except Exception, e:
+    #        return ''
+
+    def _get_label(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):
+                labels = self.pool.get(model).fields_get(self.cr, self.uid, fields=[field], context=self.context)
+                return labels[field]['string']
+        except Exception, e:
+            return ''
+
+    def _field_size(self, obj, field):
+        try:
+            if getattr(obj, field):
+                size = self.pool.get(obj._table_name)._columns[field].size
+                return size
+        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, fields=[field], context=self.context)[field]['selection'])[field_val]
+                elif kind=='items':
+                    return self.pool.get(model).fields_get(self.cr, self.uid, fields=[field], context=self.context)[field]['selection']
+                    #selection = self.pool.get(model)._columns[field].selection
+                    #if selection.__class__==list:
+                    #    val_dict = dict(selection)
+                    #else:
+                    #    val_dict = dict(selection(self.pool.get(model), self.cr, self.uid, {'lang':self._get_lang()}))
+                    #return val_dict[field_val]
+                return ''
+            except Exception:
+                return ''
+        return get_selection_item
+
+    def _get_attachments(self, o, index=None):
+        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']]
+        if type(index)==int:
+            return res[index]
+        return len(res)==1 and res[0] or res
+
+    def _asimage(self, field_value, rotate=None):
+        if not field_value:
+            return StringIO.StringIO(), 'image/png'
+        field_value = base64.decodestring(field_value)
+        tf = StringIO.StringIO(field_value)
+        tf.seek(0)
+        im=Image.open(tf)
+        try:
+            if rotate!=None:
+                im=im.rotate(int(rotate))
+                tf.seek(0)
+                im.save(tf, im.format.lower())
+        except Exception, e:
+            pass
+        size_x = str(im.size[0]/96.0)+'in'
+        size_y = str(im.size[1]/96.0)+'in'
+        return tf, 'image/%s' % im.format.lower(), size_x, size_y
+
+    def _embed_image(self, extention, img, width=0, height=0) :
+        "Transform a DB image into an embeded HTML image"
+        try:
+            if width :
+                width = 'width="%spx"'%(width)
+            else :
+                width = ' '
+            if height :
+                height = 'width="%spx"'%(height)
+            else :
+                height = ' '
+            toreturn = '<img %s %s src="data:image/%s;base64,%s">' % (width, height, extention, str(img))
+            return toreturn
+        except Exception, exp:
+            print 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 _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
+

=== added file '__init__.py'
--- __init__.py	1970-01-01 00:00:00 +0000
+++ __init__.py	2012-07-05 12:25:24 +0000
@@ -0,0 +1,31 @@
+##############################################################################
+#
+# Copyright (c) 2008-2009 SIA "KN dati". (http://kndati.lv) 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 2
+# of the License, or (at your option) any later version.
+#
+# This program is distributed in the hope that it will be useful,
+# but WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+# GNU General Public License for more details.
+#
+# You should have received a copy of the GNU General Public License
+# along with this program; if not, write to the Free Software
+# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
+#
+##############################################################################
+
+import report_xml
+import report_aeroo
+import wizard

=== added file '__openerp__.py'
--- __openerp__.py	1970-01-01 00:00:00 +0000
+++ __openerp__.py	2012-07-05 12:25:24 +0000
@@ -0,0 +1,37 @@
+# -*- encoding: utf-8 -*-
+
+#########################################################################
+#                                                                       #
+# Copyright (C) 2009  Domsense s.r.l.                                   #
+# @authors: Simone Orsi													#				       
+# Copyright (C) 2009-2010  KN dati, 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 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.0',
+    'category': 'Generic Modules/Aeroo Reporting',
+    'description': """ Make possible to easily create complicated reports with OOo.
+                    Requires "relatorio", "openoffice.org", "openoffice-python" to be installed.
+                    """,
+    'author': 'KN dati Ltd, Simone Orsi - Domsense',
+    'website': 'http://www.alistek.com',
+    'depends': ['base'],
+    "init_xml" : [],
+    'update_xml': ["report_view.xml", "data/report_aeroo_data.xml", "security/ir.model.access.csv"],
+    'installable': True,
+    'active': False,
+}

=== added directory 'barcode'
=== added file 'barcode/EANBarCode.py'
--- barcode/EANBarCode.py	1970-01-01 00:00:00 +0000
+++ barcode/EANBarCode.py	2012-07-05 12:25:24 +0000
@@ -0,0 +1,148 @@
+# Copyright (c) 2009-2010 SIA "KN dati". (http://kndati.lv) All Rights Reserved.
+#                    General contacts <[e-mail]>
+
+from tools import config
+
+"""
+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"""
+      import Image, ImageFont, ImageDraw, 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
+      font = ImageFont.load(config['addons_path']+"/report_aeroo/barcode/courB08.pil")
+      
+      # 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
+

=== added file 'barcode/FreeMonoBold.ttf'
Binary files barcode/FreeMonoBold.ttf	1970-01-01 00:00:00 +0000 and barcode/FreeMonoBold.ttf	2012-07-05 12:25:24 +0000 differ
=== added file 'barcode/__init__.py'
--- barcode/__init__.py	1970-01-01 00:00:00 +0000
+++ barcode/__init__.py	2012-07-05 12:25:24 +0000
@@ -0,0 +1,30 @@
+##############################################################################
+#
+# Copyright (c) 2008-2009 SIA "KN dati". (http://kndati.lv) 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 2
+# of the License, or (at your option) any later version.
+#
+# This program is distributed in the hope that it will be useful,
+# but WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+# GNU General Public License for more details.
+#
+# You should have received a copy of the GNU General Public License
+# along with this program; if not, write to the Free Software
+# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
+#
+##############################################################################
+
+import barcode
+

=== added file 'barcode/barcode.py'
--- barcode/barcode.py	1970-01-01 00:00:00 +0000
+++ barcode/barcode.py	2012-07-05 12:25:24 +0000
@@ -0,0 +1,59 @@
+##############################################################################
+#
+# Copyright (c) 2008-2009 SIA "KN dati". (http://kndati.lv) 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 2
+# of the License, or (at your option) any later version.
+#
+# This program is distributed in the hope that it will be useful,
+# but WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+# GNU General Public License for more details.
+#
+# You should have received a copy of the GNU General Public License
+# along with this program; if not, 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
+

=== added file 'barcode/code128.py'
--- barcode/code128.py	1970-01-01 00:00:00 +0000
+++ barcode/code128.py	2012-07-05 12:25:24 +0000
@@ -0,0 +1,184 @@
+# Copyright (c) 2009-2010 SIA "KN dati". (http://kndati.lv) 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 Image, os
+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
+
+

=== added file 'barcode/code39.py'
--- barcode/code39.py	1970-01-01 00:00:00 +0000
+++ barcode/code39.py	2012-07-05 12:25:24 +0000
@@ -0,0 +1,153 @@
+# Copyright (c) 2008 marscel.wordpress.com
+#
+# Copyright (c) 2010 SIA "KN dati". (http://kndati.lv) 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
+
+import Image, ImageDraw, ImageFont, sys
+from tools import config
+
+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:
+            map = charmap[char]
+            if len(map) != 9:
+                continue
+            
+            j = 0
+            while j < 9:
+                seg = int(map[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
+
+    font = ImageFont.truetype(config['addons_path']+"/report_aeroo/barcode/FreeMonoBold.ttf", 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
+

=== added file 'barcode/courB08.pbm'
Binary files barcode/courB08.pbm	1970-01-01 00:00:00 +0000 and barcode/courB08.pbm	2012-07-05 12:25:24 +0000 differ
=== added file 'barcode/courB08.pil'
Binary files barcode/courB08.pil	1970-01-01 00:00:00 +0000 and barcode/courB08.pil	2012-07-05 12:25:24 +0000 differ
=== added file 'currency_to_text.py'
--- currency_to_text.py	1970-01-01 00:00:00 +0000
+++ currency_to_text.py	2012-07-05 12:25:24 +0000
@@ -0,0 +1,490 @@
+#!/usr/bin/python
+# -*- coding: utf8 -*-
+
+###########################################################
+# Developed by Kaspars Vilkens - KN dati Ltd. (c) 2009
+#     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()
+

=== added directory 'data'
=== added file 'data/report_aeroo_data.xml'
--- data/report_aeroo_data.xml	1970-01-01 00:00:00 +0000
+++ data/report_aeroo_data.xml	2012-07-05 12:25:24 +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 'domain_parser.py'
--- domain_parser.py	1970-01-01 00:00:00 +0000
+++ domain_parser.py	2012-07-05 12:25:24 +0000
@@ -0,0 +1,45 @@
+##############################################################################
+#
+# Copyright (c) 2009 SIA "KN dati". (http://kndati.lv) 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 2
+# of the License, or (at your option) any later version.
+#
+# This program is distributed in the hope that it will be useful,
+# but WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+# GNU General Public License for more details.
+#
+# You should have received a copy of the GNU General Public License
+# along with this program; if not, 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
+

=== added file 'report_aeroo.py'
--- report_aeroo.py	1970-01-01 00:00:00 +0000
+++ report_aeroo.py	2012-07-05 12:25:24 +0000
@@ -0,0 +1,636 @@
+# -*- encoding: utf-8 -*-
+
+##############################################################################
+#
+# Copyright (c) 2009-2010 KN dati, SIA. (http://kndati.lv) 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 2
+# of the License, or (at your option) any later version.
+#
+# This program is distributed in the hope that it will be useful,
+# but WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+# GNU General Public License for more details.
+#
+# You should have received a copy of the GNU General Public License
+# along with this program; if not, write to the Free Software
+# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
+#
+##############################################################################
+
+import os, sys, traceback
+import tempfile
+import report
+from report.report_sxw import *
+#import zipfile
+try:
+    from cStringIO import StringIO
+except ImportError:
+    from StringIO import StringIO
+from xml.dom import minidom
+import base64
+from osv import osv
+from tools.translate import _
+import time
+import re
+import copy
+
+from addons import load_information_from_description_file
+import release
+
+import aeroolib
+from aeroolib.plugins.opendocument import Template, OOSerializer
+from genshi.template import NewTextTemplate
+import pooler
+import netsvc
+logger = netsvc.Logger()
+
+from ExtraFunctions import ExtraFunctions
+
+class Counter(object):
+    def __init__(self, name, start=0, interval=1):
+        self.name = name
+        self._number = start
+        self._interval = interval
+
+    def next(self):
+        curr_number = self._number
+        self._number += self._interval
+        return curr_number
+
+    def get_inc(self):
+        return self._number
+
+    def prev(self):
+        return self._number-self._interval
+
+class Aeroo_report(report_sxw):
+
+    def logger(self, message, level=netsvc.LOG_DEBUG):
+        netsvc.Logger().notifyChannel('report_aeroo', level, message)
+
+    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("registering %s (%s)" % (name, table), netsvc.LOG_INFO)
+        self.oo_subreports = []
+        self.epl_images = []
+        self.counters = {}
+
+        pool = pooler.get_pool(cr.dbname)
+        ir_obj = pool.get('ir.actions.report.xml')
+        report_xml_ids = ir_obj.search(cr, 1, [('report_name', '=', name[7:])])
+        if report_xml_ids:
+            report_xml = ir_obj.browse(cr, 1, report_xml_ids[0])
+
+        if report_xml.preload_mode == 'preload':
+            file_data = report_xml.report_sxw_content
+            if not file_data:
+                self.logger("template is not defined in %s (%s) !" % (name, table), netsvc.LOG_WARNING)
+                template_io = None
+            else:
+                template_io = StringIO()
+                template_io.write(base64.decodestring(file_data))
+                style_io=self.get_styles_file(cr, 1, report_xml)
+            if template_io:
+                self.serializer = OOSerializer(template_io, oo_styles=style_io)
+
+    ##### Counter functions #####
+    def _def_inc(self, name, start=0, interval=1):
+        self.counters[name] = Counter(name, start, interval)
+
+    def _get_inc(self, name):
+        return self.counters[name].get_inc()
+
+    def _prev(self, name):
+        return self.counters[name].prev()
+
+    def _next(self, name):
+        return self.counters[name].next()
+    #############################
+
+    def _epl_asimage(self, data):
+        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)
+        self.epl_images.append(new_data)
+        return img.size
+
+    def _epl2_gw(self, start_x, start_y, data):
+        if not data:
+            return None
+        size_x, size_y = self._epl_asimage(data)
+        return 'GW'+str(start_x)+','+str(start_y)+','+str(int(size_x/8))+','+str(size_y)+',<binary_data>'
+
+    def _include_document(self, aeroo_ooo=False):
+        def include_document(data, silent=False):
+            if not aeroo_ooo:
+                return _("Error! Include document not available!")
+            import binascii, urllib2
+            dummy_fd, temp_file_name = tempfile.mkstemp(suffix='.odt', prefix='aeroo-report-')
+            temp_file = open(temp_file_name, 'wb')
+            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:
+                    os.unlink(temp_file_name)
+                    error = _('HTTP Error 404! Not file found:')+' %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! Not file 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.append(temp_file_name)
+            return "<insert_doc('%s')>" % temp_file_name
+        return include_document
+
+    def _subreport(self, cr, uid, 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:
+                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'}
+                report, output = netsvc.Service._services['report.%s' % name].create_aeroo_report(cr, uid, \
+                                            [obj.id], data, report_xml, context=context, output='odt') # change for OpenERP 6.0 - Service class usage
+
+                dummy_fd, temp_file_name = tempfile.mkstemp(suffix='.odt', prefix='aeroo-report-')
+                temp_file = open(temp_file_name, 'wb')
+                try:
+                    temp_file.write(report)
+                finally:
+                    temp_file.close()
+
+                self.oo_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, 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 = 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'):
+        def preprocess(data):
+            self.epl_images.reverse()
+            while self.epl_images:
+                img = self.epl_images.pop()
+                data = data.replace('<binary_data>', img, 1)
+            return data.replace('\n', '\r\n')
+
+        if not context:
+            context={}
+        context = context.copy()
+        objects = self.getObjects(cr, uid, ids, context)
+        oo_parser = self.parser(cr, uid, self.name2, context=context)
+        oo_parser.objects = objects
+        self.set_xml_data_fields(objects, oo_parser) # Get/Set XML
+        file_data = self.get_other_template(cr, uid, data, oo_parser) or report_xml.report_sxw_content # Get other Tamplate
+        ################################################
+        if not file_data:
+            return False, output
+
+        oo_parser.localcontext['objects'] = objects
+        oo_parser.localcontext['data'] = data
+        oo_parser.localcontext['user_lang'] = context['lang']
+        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)
+        oo_parser.localcontext['include_subreport'] = self._subreport(cr, uid, output='raw', aeroo_ooo=False, context=context)
+        oo_parser.localcontext['epl2_gw'] = self._epl2_gw
+
+        self.epl_images = []
+        basic = NewTextTemplate(source=file_data)
+        #try:
+        data = preprocess(basic.generate(**oo_parser.localcontext).render().decode('utf8').encode(report_xml.charset))
+        #except Exception, e:
+        #    self.logger(str(e), netsvc.LOG_ERROR)
+        #    return False, output
+
+        if report_xml.content_fname:
+            output = report_xml.content_fname
+        return data, output
+
+    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
+        
+        objects = not context.get('no_objects', False) and self.getObjects(cr, uid, ids, context) or []
+        oo_parser = self.parser(cr, uid, self.name2, context=context)
+
+        oo_parser.objects = objects
+        self.set_xml_data_fields(objects, oo_parser) # Get/Set XML
+
+        style_io=self.get_styles_file(cr, uid, report_xml, context)
+        if report_xml.tml_source in ('file', 'database'):
+            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:
+            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)
+            basic = Template(source=template_io, serializer=serializer)
+
+        #if not file_data:
+        #    return False, output
+
+        #basic = Template(source=template_io, serializer=serializer)
+
+        oo_parser.localcontext['objects'] = objects
+        oo_parser.localcontext['data'] = data
+        oo_parser.localcontext['user_lang'] = context['lang']
+        if len(objects)==1:
+            oo_parser.localcontext['o'] = objects[0]
+        xfunc = ExtraFunctions(cr, uid, report_xml.id, oo_parser.localcontext)
+        oo_parser.localcontext.update(xfunc.functions)
+
+        ###### 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['state'] in ('installed', 'to upgrade'):
+            aeroo_ooo = True
+        ############################################
+
+        oo_parser.localcontext['include_subreport'] = self._subreport(cr, uid, output='odt', aeroo_ooo=aeroo_ooo, context=context)
+        oo_parser.localcontext['include_document'] = self._include_document(aeroo_ooo)
+
+        ####### Add counter functons to localcontext #######
+        oo_parser.localcontext.update({'def_inc':self._def_inc,
+                                      'get_inc':self._get_inc,
+                                      'prev':self._prev,
+                                      'next':self._next})
+
+        user_name = pool.get('res.users').browse(cr, uid, uid, {}).name
+        model_id = pool.get('ir.model').search(cr, uid, [('model','=',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)
+        version = load_information_from_description_file('report_aeroo')['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('http://www.alistek.com/', 'URL')
+        basic.Serializer.add_creation_date(time.strftime('%Y-%m-%dT%H:%M:%S'))
+
+        try:
+            data = basic.generate(**oo_parser.localcontext).render().getvalue()
+        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(tb_s, netsvc.LOG_ERROR)
+            for sub_report in self.oo_subreports:
+                os.unlink(sub_report)
+            raise Exception(_("Aeroo Reports: Error while generating the report."), e, str(e), _("For more reference inspect error logs."))
+            #return False, output
+
+        ######### OpenOffice extras #########
+        DC = netsvc.Service._services.get('openoffice')
+        if (output!=report_xml.in_format[3:] or self.oo_subreports):
+            if aeroo_ooo and DC:
+                try:
+                    DC.putDocument(data)
+                    if self.oo_subreports:
+                        DC.insertSubreports(self.oo_subreports)
+                        self.oo_subreports = []
+                    data = DC.saveByStream(report_xml.out_format.filter_name)
+                    DC.closeDocument()
+                    #del DC
+                except Exception, e:
+                    self.logger(str(e), netsvc.LOG_ERROR)
+                    output=report_xml.in_format[3:]
+                    self.oo_subreports = []
+            else:
+                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
+        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(cr, uid, ids, 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 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
+        if attach:
+            objs = self.getObjects(cr, uid, ids, context)
+            for obj in objs:
+                aname = eval(attach, {'object':obj, 'time':time})
+                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
+                result = self.create_single_pdf(cr, uid, [obj.id], data, report_xml, context)
+                try:
+                    if aname:
+                        name = aname+'.'+result[1]
+                        pool.get('ir.attachment').create(cr, uid, {
+                            'name': aname,
+                            'datas': base64.encodestring(result[0]),
+                            'datas_fname': name,
+                            'res_model': self.table,
+                            'res_id': obj.id,
+                            }, context=context
+                        )
+                        cr.commit()
+                except Exception,e:
+                     self.logger(str(e), netsvc.LOG_ERROR)
+                results.append(result)
+
+        return results and len(results)==1 and results[0] or self.create_single_pdf(cr, uid, ids, data, report_xml, context)
+
+    # override needed to intercept the call to the proper 'create' method
+    def create(self, cr, uid, ids, data, context=None):
+        pool = pooler.get_pool(cr.dbname)
+        ir_obj = pool.get('ir.actions.report.xml')
+        report_xml_ids = ir_obj.search(cr, uid,
+                [('report_name', '=', self.name[7:])], context=context)
+        if report_xml_ids:
+            report_xml = ir_obj.browse(cr, uid, report_xml_ids[0], context=context)
+            report_xml.report_rml = None
+            report_xml.report_rml_content = None
+            report_xml.report_sxw_content_data = None
+            report_rml.report_sxw_content = None
+            report_rml.report_sxw = None
+        else:
+            title = ''
+            rml = tools.file_open(self.tmpl, subdir=None).read()
+            report_type= data.get('report_type', 'pdf')
+            class a(object):
+                def __init__(self, *args, **argv):
+                    for key,arg in argv.items():
+                        setattr(self, key, arg)
+            report_xml = a(title=title, report_type=report_type, report_rml_content=rml, name=title, attachment=False, header=self.header)
+
+        report_type = report_xml.report_type
+        if report_type in ['sxw','odt']:
+            fnct = self.create_source_odt
+        elif report_type in ['pdf','raw','txt','html']:
+            fnct = self.create_source_pdf
+        elif report_type=='html2html':
+            fnct = self.create_source_html2html
+        elif report_type=='mako2html':
+            fnct = self.create_source_mako2html
+        elif report_type=='aeroo':
+            if report_xml.out_format.code in ['oo-pdf']:
+                fnct = self.create_source_pdf
+            elif report_xml.out_format.code in ['oo-odt','oo-ods','oo-doc','oo-xls','genshi-raw']:
+                fnct = self.create_source_odt
+            else:
+                return super(Aeroo_report, self).create(cr, uid, ids, data, context)
+        else:
+            raise 'Unknown Report Type'
+        return fnct(cr, uid, ids, data, report_xml, context)
+
+class ReportTypeException(Exception):
+    def __init__(self, value):
+      self.parameter = value
+    def __str__(self):
+      return repr(self.parameter)
+
+#########################################################################
+
+#import imp, sys
+#from tools.config import config
+
+#def load_from_file(path, dbname, key):
+#    class_inst = None
+#    expected_class = 'Parser'
+
+#    try:
+#        if path.find(config['addons_path'])==-1:
+#            filepath=config['addons_path']+os.path.sep+path
+#        filepath = os.path.normpath(filepath)
+#        if not os.path.lexists(filepath):
+#            filepath = os.path.normpath(config['root_path']+os.path.sep+path)
+#        sys.path.append(os.path.dirname(filepath))
+#        mod_name,file_ext = os.path.splitext(os.path.split(filepath)[-1])
+#        mod_name = '%s_%s_%s' % (dbname,mod_name,key)
+
+#        if file_ext.lower() == '.py':
+#            py_mod = imp.load_source(mod_name, filepath)
+
+#        elif file_ext.lower() == '.pyc':
+#            py_mod = imp.load_compiled(mod_name, filepath)
+
+#        if expected_class in dir(py_mod):
+#            class_inst = py_mod.Parser
+#        return class_inst
+#    except Exception, e:
+#        return None
+
+#def load_from_source(source):
+#    expected_class = 'Parser'
+#    context = {'Parser':None}
+#    try:
+#        exec source in context
+#        return context['Parser']
+#    except Exception, e:
+#        return None
+
+#def delete_report_service(name):
+#    name = 'report.%s' % name
+#    if netsvc.Service.exists( name ):  # change for OpenERP 6.0 - Service class usage
+#        netsvc.Service.remove( name ) # change for OpenERP 6.0 - Service class usage
+
+#def register_report(cr, name, model, tmpl_path, parser):
+#    name = 'report.%s' % name
+#    if netsvc.Service.exists( name ):  # change for OpenERP 6.0 - Service class usage
+#        netsvc.Service.remove( name ) # change for OpenERP 6.0 - Service class usage
+#    Aeroo_report(cr, name, model, tmpl_path, parser=parser)
+
+#old_register_all = report.interface.register_all
+#def new_register_all(db):
+#    value = old_register_all(db)
+
+#    cr = db.cursor()
+
+    ########### Run OpenOffice service ###########
+#    try:
+#        from report_aeroo_ooo.report import OpenOffice_service
+#    except Exception, e:
+#        OpenOffice_service = False
+
+#    if OpenOffice_service:
+#        cr.execute("SELECT id, state FROM ir_module_module WHERE name='report_aeroo_ooo'")
+#        helper_module = cr.dictfetchone()
+#        helper_installed = helper_module['state']=='installed'
+
+#    if OpenOffice_service and helper_installed:
+#        cr.execute("SELECT host, port FROM oo_config")
+#        host, port = cr.fetchone()
+#        try:
+#            OpenOffice_service(cr, host, port)
+#            netsvc.Logger().notifyChannel('report_aeroo', netsvc.LOG_INFO, "OpenOffice connection successfully established")
+#        except DocumentConversionException, e:
+#            netsvc.Logger().notifyChannel('report_aeroo', netsvc.LOG_WARNING, e)
+    ##############################################
+
+#    cr.execute("SELECT * FROM ir_act_report_xml WHERE report_type = 'aeroo' ORDER BY id") # change for OpenERP 6.0
+#    records = cr.dictfetchall()
+#    for record in records:
+#        parser=rml_parse
+#        if record['parser_state']=='loc' and record['parser_loc']:
+#            parser=load_from_file(record['parser_loc'], db.dbname, record['id']) or parser
+#        elif record['parser_state']=='def' and record['parser_def']:
+#            parser=load_from_source("from report import report_sxw\n"+record['parser_def']) or parser
+#        register_report(cr, record['report_name'], record['model'], record['report_rml'], parser)
+#    cr.close()
+#    return value
+
+#report.interface.register_all = new_register_all
+

=== added file 'report_view.xml'
--- report_view.xml	1970-01-01 00:00:00 +0000
+++ report_view.xml	2012-07-05 12:25:24 +0000
@@ -0,0 +1,224 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+    <data>
+
+		<record model="ir.ui.view" id="act_report_xml_view1">
+			<field name="name">ir.actions.report.xml.aeroo.form</field>
+			<field name="model">ir.actions.report.xml</field>
+            <field name="priority">14</field>
+			<field name="type">form</field>
+			<field name="arch" type="xml">
+                <form string="Aeroo Report">
+                    <group col="6" colspan="4">
+                        <field name="name" select="1"/>
+                        <field name="model" select="1"/>
+                        <field name="type" select="1" invisible="1"/>
+
+                        <field name="report_name" select="1"/>
+                        <field name="usage"/>
+                        <field name="report_type" invisible="1"/>
+                    </group>
+                    <group col="6" colspan="4">
+                        <field name="in_format" required="1" on_change="change_input_format(in_format)"/>
+                        <field name="out_format" required="1" domain="[('compatible_types','=',in_format)]"/>
+                        <field name="content_fname"/>
+                    </group>
+
+                    <notebook colspan="4">
+                        <page string="Other Configuration">
+                            <separator string="Template" colspan="4"/>
+                            <group colspan="4" col="8">
+                                <field name="tml_source" colspan="2" required="1"/>
+                                <group colspan="6">
+                                    <field name="report_sxw_content_data" string="Template Content" attrs="{'invisible': [('tml_source','&lt;&gt;','database')],'required': [('tml_source','=','database')]}"/>
+                                    <field name="report_rml" string="Template path" attrs="{'invisible': [('tml_source','&lt;&gt;','file')],'required': [('tml_source','=','file')]}"/>
+                                </group>
+                            </group>
+                            <group attrs="{'invisible': [('in_format','=','genshi-raw')]}" colspan="4">
+                                <separator string="Stylesheet" colspan="4"/>
+                                <group colspan="4" col="8">
+                                    <field name="styles_mode" colspan="2"/>
+                                    <group colspan="6">
+                                        <field name="stylesheet_id" attrs="{'invisible': [('styles_mode','&lt;&gt;','specified')]}"/>
+                                    </group>
+                                </group>
+                            </group>
+                            <group attrs="{'invisible': [('in_format','&lt;&gt;','genshi-raw')]}" colspan="4" col="8">
+                                <field name="charset" colspan="2"/>
+                                <separator colspan="2"/>
+                            </group>
+                            <group col="2" colspan="2">
+                                <separator string="Attachments" colspan="2"/>
+                                <group colspan="2">
+                                    <group colspan="2">
+                                        <field name="attachment"/>
+                                    </group>
+                                </group>
+                                <field name="attachment_use" colspan="2"/>
+                            </group>
+                            <group col="2" colspan="2">
+                                <separator string="Miscellaneous" colspan="2"/>
+                                <field name="preload_mode" attrs="{'invisible': [('in_format','=','genshi-raw'),('tml_source','=','parser')]}"/>
+                                <field name="multi" colspan="2"/>
+                            </group>
+                        </page>
+                        <page string="Parser">
+                            <group colspan="2">
+			                    <field name="parser_state"/>
+                            </group>
+                            <group attrs="{'invisible': [('parser_state','&lt;&gt;','def')]}" colspan="4" expand="1">
+                                <separator string="Parser Definition" colspan="4"/>
+		                        <field name="parser_def" nolabel="1"/>
+                            </group>
+	                        <field name="parser_loc" attrs="{'invisible': [('parser_state','&lt;&gt;','loc')],'required': [('parser_state','=','loc')]}"/>
+                        </page>
+                        <page string="Security">
+                            <separator string="Groups" colspan="4"/>
+                            <field colspan="4" name="groups_id" nolabel="1"/>
+                        </page>
+                    </notebook>
+
+                </form>
+			</field>
+		</record>
+
+        <record id="act_aeroo_report_xml_view_tree" model="ir.ui.view">
+            <field name="name">ir.actions.report.xml.tree</field>
+            <field name="model">ir.actions.report.xml</field>
+            <field name="type">tree</field>
+            <field name="arch" type="xml">
+                <tree string="Report xml">
+                    <field name="name"/>
+                    <field name="model"/>
+                    <field name="report_name"/>
+                    <field name="in_format"/>
+                    <field name="out_format"/>
+                    <field name="tml_source"/>
+                </tree>
+            </field>
+        </record>
+
+        <record id="act_aeroo_report_xml_search_view" model="ir.ui.view">
+            <field name="name">ir.actions.report.xml.search</field>
+            <field name="model">ir.actions.report.xml</field>
+            <field name="type">search</field>
+            <field name="arch" type="xml">
+                <search string="Report xml">
+                    <group col="10" colspan="4">
+                        <field name="name"/>
+                        <field name="model"/>
+                        <field name="type"/>
+                        <field name="in_format"/>
+                        <field name="out_format"/>
+                    </group>
+                    <newline/>
+                    <group expand="0" string="Group By" colspan="4">
+                        <filter string="Template Mime-type" icon="terp-stock_symbol-selection" domain="[]" context="{'group_by':'in_format'}"/>
+                        <filter string="Output Mime-type" icon="terp-stock_symbol-selection" domain="[]" context="{'group_by':'out_format'}"/>
+                        <separator orientation="vertical"/>
+                        <filter string="Template Source" icon="gtk-copy" domain="[]" context="{'group_by':'tml_source'}"/>
+                    </group>
+                </search>
+            </field>
+        </record>
+
+        <record id="view_company_form1" model="ir.ui.view">
+            <field name="name">res.company.form</field>
+            <field name="model">res.company</field>
+            <field name="type">form</field>
+			<field name="inherit_id" ref="base.view_company_form"/>
+            <field name="arch" type="xml">
+                <field name="rml_footer2" position="after">
+                    <field name="stylesheet_id"/>
+                </field>
+            </field>
+        </record>
+
+        <record id="view_report_stylesheets_form" model="ir.ui.view">
+            <field name="name">report.stylesheets.form</field>
+            <field name="model">report.stylesheets</field>
+            <field name="type">form</field>
+            <field name="arch" type="xml">
+                <form string="Report Stylesheet">
+                    <field name="name" select="1" colspan="4"/>
+                    <field name="report_styles"/>
+                </form>
+            </field>
+        </record>
+
+        <record id="view_report_stylesheets_tree" model="ir.ui.view">
+            <field name="name">report.stylesheets.tree</field>
+            <field name="model">report.stylesheets</field>
+            <field name="type">tree</field>
+            <field name="arch" type="xml">
+                <tree string="Report Stylesheets">
+                    <field name="name"/>
+                </tree>
+            </field>
+        </record>
+
+		<record model="ir.actions.act_window" id="action_report_stylesheets">
+			<field name="name">Report Stylesheets</field>
+			<field name="res_model">report.stylesheets</field>
+			<field name="view_type">form</field>
+			<field name="view_mode">tree,form</field>
+		</record>
+
+	<act_window name="Translations"
+		domain="[('type', '=', 'report'),('res_id', '=', active_id)]"
+		view_type="form"
+		res_model="ir.translation"
+		src_model="ir.actions.report.xml"
+		id="act_translations"/>
+
+    <!-- For the original views -->
+    <record model="ir.actions.act_window.view" id="act_report_xml_tree_view">
+        <field name="sequence" eval="1"/>
+        <field name="view_mode">tree</field>
+        <field name="view_id" ref="base.act_report_xml_view_tree"/>
+        <field name="act_window_id" ref="base.ir_action_report_xml"/>
+    </record>
+
+    <record model="ir.actions.act_window.view" id="act_report_xml_form_view">
+        <field name="sequence" eval="1"/>
+        <field name="view_mode">form</field>
+        <field name="view_id" ref="base.act_report_xml_view"/>
+        <field name="act_window_id" ref="base.ir_action_report_xml"/>
+    </record>
+    <!--========================-->
+
+    <wizard string="Add Print Button" model="ir.actions.report.xml" name="aeroo.report_actions" menu="True" id="wizard_oo_report_actions" />
+    <wizard string="Remove Print Button" model="ir.actions.report.xml" name="aeroo.report_actions_remove" menu="True" id="wizard_oo_report_actions_remove" />
+
+    <menuitem name="Aeroo Reports" id="menu_ir_action_aeroo_reports_xml" parent="base.menu_custom"/>
+
+    <record id="action_aeroo_report_xml_tree" model="ir.actions.act_window">
+        <field name="name">Reports</field>
+        <field name="type">ir.actions.act_window</field>
+        <field name="res_model">ir.actions.report.xml</field>
+        <field name="view_type">form</field>
+        <field name="view_mode">tree,form</field>
+        <field name="domain">[('report_type','=','aeroo')]</field>
+        <field name="view_id" ref="act_aeroo_report_xml_view_tree"/>
+        <field name="search_view_id" ref="act_aeroo_report_xml_search_view"/>
+    </record>
+
+    <record model="ir.actions.act_window.view" id="act_aeroo_report_xml_tree_view">
+        <field name="sequence" eval="1"/>
+        <field name="view_mode">tree</field>
+        <field name="view_id" ref="act_aeroo_report_xml_view_tree"/>
+        <field name="act_window_id" ref="action_aeroo_report_xml_tree"/>
+    </record>
+
+    <record model="ir.actions.act_window.view" id="act_aeroo_report_xml_form_view">
+        <field name="sequence" eval="1"/>
+        <field name="view_mode">form</field>
+        <field name="view_id" ref="act_report_xml_view1"/>
+        <field name="act_window_id" ref="action_aeroo_report_xml_tree"/>
+    </record>
+
+    <menuitem action="action_aeroo_report_xml_tree" id="menu_ir_action_aeroo_report_xml" parent="menu_ir_action_aeroo_reports_xml"/>
+	<menuitem action="action_report_stylesheets" parent="menu_ir_action_aeroo_reports_xml" id="menu_report_stylesheets"/>
+
+    </data>
+</openerp>

=== added file 'report_xml.py'
--- report_xml.py	1970-01-01 00:00:00 +0000
+++ report_xml.py	2012-07-05 12:25:24 +0000
@@ -0,0 +1,365 @@
+##############################################################################
+#
+# Copyright (c) 2009-2010 SIA "KN dati". (http://kndati.lv) 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 2
+# of the License, or (at your option) any later version.
+#
+# This program is distributed in the hope that it will be useful,
+# but WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+# GNU General Public License for more details.
+#
+# You should have received a copy of the GNU General Public License
+# along with this program; if not, write to the Free Software
+# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
+#
+##############################################################################
+
+from osv import osv,fields
+import netsvc
+from report_aeroo import Aeroo_report
+from report.report_sxw import rml_parse
+import base64, binascii
+import tools
+import encodings
+from tools.translate import _
+
+import imp, sys, os
+from tools.config import config
+
+class report_stylesheets(osv.osv):
+    '''
+    Open ERP Model
+    '''
+    _name = 'report.stylesheets'
+    _description = 'Report Stylesheets'
+    
+    _columns = {
+        'name':fields.char('Name', size=64, required=True),
+        'report_styles' : fields.binary('Template Stylesheet', help='OpenOffice.org stylesheet (.odt)'),
+        
+    }
+
+report_stylesheets()
+
+class res_company(osv.osv):
+    _name = 'res.company'
+    _inherit = 'res.company'
+
+    _columns = {
+        #'report_styles' : fields.binary('Report Styles', help='OpenOffice stylesheet (.odt)'),
+        'stylesheet_id':fields.many2one('report.stylesheets', 'Aeroo Global Stylesheet'),
+    }
+
+res_company()
+
+class report_mimetypes(osv.osv):
+    '''
+    Aeroo Report Mime-Type
+    '''
+    _name = 'report.mimetypes'
+    _description = 'Report Mime-Types'
+    
+    _columns = {
+        'name':fields.char('Name', size=64, required=True, readonly=True),
+        'code':fields.char('Code', size=16, required=True, readonly=True),
+        'compatible_types':fields.char('Compatible Mime-Types', size=128, readonly=True),
+        'filter_name':fields.char('Filter Name', size=128, readonly=True),
+        
+    }
+
+report_mimetypes()
+
+class report_xml(osv.osv):
+    _name = 'ir.actions.report.xml'
+    _inherit = 'ir.actions.report.xml'
+
+    def load_from_file(self, path, dbname, key):
+        class_inst = None
+        expected_class = 'Parser'
+
+        try:
+            if path.find(config['addons_path'])==-1:
+                filepath=config['addons_path']+os.path.sep+path
+            filepath = os.path.normpath(filepath)
+            if not os.path.lexists(filepath):
+                filepath = os.path.normpath(config['root_path']+os.path.sep+path)
+            sys.path.append(os.path.dirname(filepath))
+            mod_name,file_ext = os.path.splitext(os.path.split(filepath)[-1])
+            mod_name = '%s_%s_%s' % (dbname,mod_name,key)
+
+            if file_ext.lower() == '.py':
+                py_mod = imp.load_source(mod_name, filepath)
+
+            elif file_ext.lower() == '.pyc':
+                py_mod = imp.load_compiled(mod_name, filepath)
+
+            if expected_class in dir(py_mod):
+                class_inst = py_mod.Parser
+            return class_inst
+        except Exception, e:
+            return None
+
+    def load_from_source(self, source):
+        expected_class = 'Parser'
+        context = {'Parser':None}
+        try:
+            exec source in context
+            return context['Parser']
+        except Exception, e:
+            return None
+
+    def delete_report_service(self, name):
+        name = 'report.%s' % name
+        if netsvc.Service.exists( name ):  # change for OpenERP 6.0 - Service class usage
+            netsvc.Service.remove( name ) # change for OpenERP 6.0 - Service class usage
+
+    def register_report(self, cr, name, model, tmpl_path, parser):
+        name = 'report.%s' % name
+        if netsvc.Service.exists( name ):  # change for OpenERP 6.0 - Service class usage
+            netsvc.Service.remove( name ) # change for OpenERP 6.0 - Service class usage
+        Aeroo_report(cr, name, model, tmpl_path, parser=parser)
+
+    def register_all(self, cr):
+        ########### Run OpenOffice service ###########
+        try:
+            from report_aeroo_ooo.report import OpenOffice_service
+        except Exception, e:
+            OpenOffice_service = False
+
+        if OpenOffice_service:
+            cr.execute("SELECT id, state FROM ir_module_module WHERE name='report_aeroo_ooo'")
+            helper_module = cr.dictfetchone()
+            helper_installed = helper_module['state']=='installed'
+
+        if OpenOffice_service and helper_installed:
+            cr.execute("SELECT host, port FROM oo_config")
+            host, port = cr.fetchone()
+            try:
+                OpenOffice_service(cr, host, port)
+                netsvc.Logger().notifyChannel('report_aeroo', netsvc.LOG_INFO, "OpenOffice.org connection successfully established")
+            except Exception, e:
+                netsvc.Logger().notifyChannel('report_aeroo', netsvc.LOG_WARNING, e)
+        ##############################################
+
+        cr.execute("SELECT * FROM ir_act_report_xml WHERE report_type = 'aeroo' ORDER BY id") # change for OpenERP 6.0
+        records = cr.dictfetchall()
+        for record in records:
+            parser=rml_parse
+            if record['parser_state']=='loc' and record['parser_loc']:
+                parser=self.load_from_file(record['parser_loc'], cr.dbname, record['id']) or parser
+            elif record['parser_state']=='def' and record['parser_def']:
+                parser=self.load_from_source("from report import report_sxw\n"+record['parser_def']) or parser
+            self.register_report(cr, record['report_name'], record['model'], record['report_rml'], parser)
+
+
+    def _report_content(self, cursor, user, ids, name, arg, context=None):
+        res = {}
+        for report in self.browse(cursor, user, ids, context=context):
+            data = report[name + '_data']# and base64.decodestring(report[name + '_data'])
+            if not data and report[name[:-8]]:
+                try:
+                    fp = tools.file_open(report[name[:-8]], mode='rb')
+                    data = base64.encodestring(fp.read())
+                except:
+                    data = ''
+            res[report.id] = data
+        return res
+
+    def _get_encodings(self, cursor, user, context={}):
+        l = list(set(encodings._aliases.values()))
+        l.sort()
+        return zip(l, l)
+
+    def _report_content_inv(self, cursor, user, id, name, value, arg, context=None):
+        if value:
+            self.write(cursor, user, id, {name+'_data': value}, context=context)
+
+    def change_input_format(self, cr, uid, ids, in_format):
+        out_format = self.pool.get('report.mimetypes').search(cr, uid, [('code','=',in_format)])
+        return {
+            'value':{'out_format': out_format and out_format[0] or False}
+        }
+
+    def _get_in_mimetypes(self, cr, uid, context={}):
+        obj = self.pool.get('report.mimetypes')
+        ids = obj.search(cr, uid, [('filter_name','=',False)], context=context)
+        res = obj.read(cr, uid, ids, ['code', 'name'], context)
+        return [(r['code'], r['name']) for r in res] + [('','')]
+
+    _columns = {
+        'charset':fields.selection(_get_encodings, string='Charset', required=True),
+        'content_fname': fields.char('Override Extension',size=64, help='Here you can override output file extension'),
+        'styles_mode': fields.selection([
+            ('default','Not used'),
+            ('global', 'Global'),
+            ('specified', 'Specified'),
+            ], string='Stylesheet'),
+        #'report_styles' : fields.binary('Template Styles', help='OpenOffice stylesheet (.odt)'),
+        'stylesheet_id':fields.many2one('report.stylesheets', 'Template Stylesheet'),
+        'preload_mode':fields.selection([
+            ('static',_('Static')),
+            ('preload',_('Preload')),
+        ],'Preload Mode'),
+        'tml_source':fields.selection([
+            ('database','Database'),
+            ('file','File'),
+            ('parser','Parser'),
+        ],'Template source', select=True),
+        'parser_def': fields.text('Parser Definition'),
+        'parser_loc':fields.char('Parser location', size=128),
+        'parser_state':fields.selection([
+            ('default',_('Default')),
+            ('def',_('Definition')),
+            ('loc',_('Location')),
+        ],'State of Parser', select=True),
+        'in_format': fields.selection(_get_in_mimetypes, 'Template Mime-type'),
+        'out_format':fields.many2one('report.mimetypes', 'Output Mime-type'),
+        'report_sxw_content': fields.function(_report_content,
+            fnct_inv=_report_content_inv, method=True,
+            type='binary', string='SXW content',),
+    }
+
+    def unlink(self, cr, uid, ids, context=None):
+        #TODO: process before delete resource
+        trans_obj = self.pool.get('ir.translation')
+        trans_ids = trans_obj.search(cr, uid, [('type','=','report'),('res_id','in',ids)])
+        trans_obj.unlink(cr, uid, trans_ids)
+        ####################################
+        reports = self.read(cr, uid, ids, ['report_name','model'])
+        for r in reports:
+            ir_value_ids = self.pool.get('ir.values').search(cr, uid, [('name','=',r['report_name']), 
+                                                                            ('value','=','ir.actions.report.xml,%s' % r['id']),
+                                                                            ('model','=',r['model'])
+                                                                            ])
+            if ir_value_ids:
+                self.pool.get('ir.values').unlink(cr, uid, ir_value_ids)
+        self.pool.get('ir.model.data')._unlink(cr, uid, 'ir.actions.report.xml', ids)
+        ####################################
+        res = super(report_xml, self).unlink(cr, uid, ids, context)
+        return res
+
+    def create(self, cr, user, vals, context={}):
+        #if context and not self.pool.get('ir.model').search(cr, user, [('model','=',vals['model'])]):
+        #    raise osv.except_osv(_('Object model is not correct !'),_('Please check "Object" field !') )
+        if 'report_type' in vals and vals['report_type'] == 'aeroo':
+            parser=rml_parse
+            if vals['parser_state']=='loc' and vals['parser_loc']:
+                parser=self.load_from_file(vals['parser_loc'], cr.dbname, vals['name'].lower().replace(' ','_')) or parser
+            elif vals['parser_state']=='def' and vals['parser_def']:
+                parser=self.load_from_source("from report import report_sxw\n"+vals['parser_def']) or parser
+
+            res_id = super(report_xml, self).create(cr, user, vals, context)
+            try:
+                self.register_report(cr, vals['report_name'], vals['model'], vals.get('report_rml', False), parser)
+            except Exception, e:
+                raise osv.except_osv(_('Report registration error !'), _('Report was not registered in system !'))
+            return res_id
+
+        res_id = super(report_xml, self).create(cr, user, vals, context)
+        return res_id
+
+    def write(self, cr, user, ids, vals, context=None):
+        if 'report_sxw_content_data' in vals:
+            if vals['report_sxw_content_data']:
+                try:
+                    base64.decodestring(vals['report_sxw_content_data'])
+                except binascii.Error:
+                    vals['report_sxw_content_data'] = False
+        if type(ids)==list:
+            ids = ids[0]
+        record = self.read(cr, user, ids)
+        #if context and 'model' in vals and not self.pool.get('ir.model').search(cr, user, [('model','=',vals['model'])]):
+        #    raise osv.except_osv(_('Object model is not correct !'),_('Please check "Object" field !') )
+        if vals.get('report_type', record['report_type']) == 'aeroo':
+            parser=rml_parse
+            if vals.get('parser_state', False)=='loc':
+                parser = self.load_from_file(vals.get('parser_loc', False) or record['parser_loc'], cr.dbname, record['id']) or parser
+            elif vals.get('parser_state', False)=='def':
+                parser = self.load_from_source("from report import report_sxw\n"+(vals.get('parser_loc', False) or record['parser_def'] or '')) or parser
+            elif vals.get('parser_state', False)=='default':
+                parser = rml_parse
+            elif record['parser_state']=='loc':
+                parser = self.load_from_file(record['parser_loc'], cr.dbname, record['id']) or parser
+            elif record['parser_state']=='def':
+                parser = self.load_from_source("from report import report_sxw\n"+record['parser_def']) or parser
+            elif record['parser_state']=='default':
+                parser = rml_parse
+
+            if vals.get('parser_loc', False):
+                parser=self.load_from_file(vals['parser_loc'], cr.dbname, record['id']) or parser
+            elif vals.get('parser_def', False):
+                parser=self.load_from_source("from report import report_sxw\n"+vals['parser_def']) or parser
+            if vals.get('report_name', False) and vals['report_name']!=record['report_name']:
+                self.delete_report_service(record['report_name'])
+                report_name = vals['report_name']
+            else:
+                self.delete_report_service(record['report_name'])
+                report_name = record['report_name']
+
+            res = super(report_xml, self).write(cr, user, ids, vals, context)
+            try:
+                self.register_report(cr, report_name, vals.get('model', record['model']), vals.get('report_rml', record['report_rml']), parser)
+            except Exception, e:
+                raise osv.except_osv(_('Report registration error !'), _('Report was not registered in system !'))
+            return res
+
+        res = super(report_xml, self).write(cr, user, ids, vals, context)
+        return res
+
+    def _get_default_outformat(self, cr, uid, context):
+        obj = self.pool.get('report.mimetypes')
+        res = obj.search(cr, uid, [('code','=','oo-odt')])
+        return res and res[0] or False
+
+    _defaults = {
+        #'report_type' : lambda*a: 'oo-odt',
+        'tml_source': lambda*a: 'database',
+        'in_format' : lambda*a: 'oo-odt',
+        'out_format' : _get_default_outformat,
+        'charset': lambda*a: 'ascii',
+        'styles_mode' : lambda*a: 'default',
+        'preload_mode': lambda*a: 'static',
+        'parser_state': lambda*a: 'default',
+        'parser_def':lambda*a: """class Parser(report_sxw.rml_parse):
+    def __init__(self, cr, uid, name, context):
+        super(Parser, self).__init__(cr, uid, name, context)
+        self.localcontext.update({})"""
+    }
+
+    #def _object_check(self, cr, uid, ids):
+    #    for r in self.browse(cr, uid, ids, {}):
+    #        if not self.pool.get('ir.model').search(cr, uid, [('model','=',r.model)]):
+    #            return False
+    #    return True
+
+    #_constraints = [
+    #        (_object_check, _('Object model is not correct')+' !\n'+_('Please check "Object" field')+' !', ['model'])
+    #    ]
+
+report_xml()
+
+class ir_translation(osv.osv):
+    _name = 'ir.translation'
+    _inherit = 'ir.translation'
+
+    def __init__(self, pool, cr):
+        super(ir_translation, self).__init__(pool, cr)
+        if ('report', 'Report') not in self._columns['type'].selection:
+            self._columns['type'].selection.append(
+                        ('report', 'Report'),
+                    )
+
+ir_translation()
+

=== added directory 'wizard'
=== added file 'wizard/__init__.py'
--- wizard/__init__.py	1970-01-01 00:00:00 +0000
+++ wizard/__init__.py	2012-07-05 12:25:24 +0000
@@ -0,0 +1,30 @@
+##############################################################################
+#
+# Copyright (c) 2008-2009 SIA "KN dati". (http://kndati.lv) 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 2
+# of the License, or (at your option) any later version.
+#
+# This program is distributed in the hope that it will be useful,
+# but WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+# GNU General Public License for more details.
+#
+# You should have received a copy of the GNU General Public License
+# along with this program; if not, write to the Free Software
+# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
+#
+##############################################################################
+
+import report_actions
+import report_actions_remove

=== added file 'wizard/report_actions.py'
--- wizard/report_actions.py	1970-01-01 00:00:00 +0000
+++ wizard/report_actions.py	2012-07-05 12:25:24 +0000
@@ -0,0 +1,118 @@
+##############################################################################
+#
+# Copyright (c) 2008-2010 SIA "KN dati". (http://kndati.lv) 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 2
+# of the License, or (at your option) any later version.
+#
+# This program is distributed in the hope that it will be useful,
+# but WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+# GNU General Public License for more details.
+#
+# You should have received a copy of the GNU General Public License
+# along with this program; if not, write to the Free Software
+# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
+#
+##############################################################################
+
+import wizard
+import pooler
+import ir
+from tools.translate import _
+
+class report_actions_wizard(wizard.interface):
+    '''
+    Add Print Button
+    '''
+    form = '''<?xml version="1.0"?>
+    <form string="Add Print Button">
+        <!--<field name="print_button"/>-->
+        <field name="open_action"/>
+    </form>'''
+
+    ex_form = '''<?xml version="1.0"?>
+    <form string="Add Print Button">
+        <label string="Report Action already exist for this report."/>
+    </form>'''
+
+    done_form = '''<?xml version="1.0"?>
+    <form string="Remove print button">
+        <label string="The print button is successfully added"/>
+    </form>'''
+
+    fields = {
+        #'print_button': {'string': 'Add print button', 'type': 'boolean', 'default': True, 'help':'Add action to menu context in print button.'},
+        'open_action': {'string': 'Open added action', 'type': 'boolean', 'default': False},
+    }
+
+    def _do_action(self, cr, uid, data, context):
+        pool = pooler.get_pool(cr.dbname)
+        report = pool.get(data['model']).browse(cr, uid, data['id'], context=context)
+        #if data['form']['print_button']:
+        res = ir.ir_set(cr, uid, 'action', 'client_print_multi', report.report_name, [report.model], 'ir.actions.report.xml,%d' % data['id'], isobject=True)
+        #else:
+	    #    res = ir.ir_set(cr, uid, 'action', 'client_print_multi', report.report_name, [report.model,0], 'ir.actions.report.xml,%d' % data['id'], isobject=True)
+        return {'value_id':res[0]}
+
+    def _check(self, cr, uid, data, context):
+        pool = pooler.get_pool(cr.dbname)
+        report = pool.get(data['model']).browse(cr, uid, data['id'], context=context)
+        ids = pool.get('ir.values').search(cr, uid, [('value','=',report.type+','+str(data['id']))])
+        if not ids:
+	        return 'add'
+        else:
+	        return 'exist'
+
+    def _action_open_window(self, cr, uid, data, context):
+        form=data['form']
+        if not form['open_action']:
+            return {}
+        return {
+            'domain':"[('id','=',%d)]" % (form['value_id']),
+            'name': _('Client Actions Connections'),
+            'view_type': 'form',
+            'view_mode': 'tree,form',
+            'res_model': 'ir.values',
+            'view_id': False,
+            'type': 'ir.actions.act_window',
+        }
+    
+    states = {
+        'init': {
+			'actions': [],
+			'result': {'type':'choice','next_state':_check}
+        },
+        'add': {
+            'actions': [],
+            'result': {'type': 'form', 'arch': form, 'fields': fields, 'state': (('end', _('_Cancel')), ('process', _('_Ok')))},
+        },
+        'exist': {
+            'actions': [],
+            'result': {'type': 'form', 'arch': ex_form, 'fields': {}, 'state': (('end', _('_Close')),)},
+        },
+        'process': {
+            'actions': [_do_action],
+            'result': {'type': 'state', 'state': 'done'},
+        },
+        'done': {
+            'actions': [],
+            'result': {'type': 'form', 'arch': done_form, 'fields': {}, 'state': (('exit', _('_Close')),)},
+        },
+        'exit': {
+            'actions': [],
+            'result': {'type': 'action', 'action': _action_open_window, 'state': 'end'},
+        },
+    }
+report_actions_wizard('aeroo.report_actions')
+

=== added file 'wizard/report_actions_remove.py'
--- wizard/report_actions_remove.py	1970-01-01 00:00:00 +0000
+++ wizard/report_actions_remove.py	2012-07-05 12:25:24 +0000
@@ -0,0 +1,97 @@
+##############################################################################
+#
+# Copyright (c) 2008-2010 SIA "KN dati". (http://kndati.lv) 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 2
+# of the License, or (at your option) any later version.
+#
+# This program is distributed in the hope that it will be useful,
+# but WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+# GNU General Public License for more details.
+#
+# You should have received a copy of the GNU General Public License
+# along with this program; if not, write to the Free Software
+# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
+#
+##############################################################################
+
+import wizard
+import pooler
+import ir
+from tools.translate import _
+
+class report_actions_remove_wizard(wizard.interface):
+    '''
+    Remove print button
+    '''
+    form = '''<?xml version="1.0"?>
+    <form string="Remove print button">
+        <label string="Or you want to remove print button for this report?"/>
+    </form>'''
+
+    ex_form = '''<?xml version="1.0"?>
+    <form string="Remove print button">
+        <label string="No Report Action to delete for this report"/>
+    </form>'''
+
+    done_form = '''<?xml version="1.0"?>
+    <form string="Remove print button">
+        <label string="The print button is successfully removed"/>
+    </form>'''
+
+    def _do_action(self, cr, uid, data, context):
+        pool = pooler.get_pool(cr.dbname)
+        report = pool.get(data['model']).browse(cr, uid, data['id'], context=context)
+        res = ir.ir_get(cr, uid, 'action', 'client_print_multi', [report.model])
+        id = res[0][0]
+        res = ir.ir_del(cr, uid, id)
+        return {}
+
+    def _check(self, cr, uid, data, context):
+        pool = pooler.get_pool(cr.dbname)
+        report = pool.get(data['model']).browse(cr, uid, data['id'], context=context)
+        ids = pool.get('ir.values').search(cr, uid, [('value','=',report.type+','+str(data['id']))])
+        if not ids:
+	        return 'no_exist'
+        else:
+	        return 'remove'
+
+    states = {
+        'init': {
+			'actions': [],
+			'result': {'type':'choice','next_state':_check}
+        },
+        'remove': {
+            'actions': [],
+            'result': {'type': 'form', 'arch': form, 'fields': {}, 'state': (('end', _('_No')), ('process', _('_Yes')))},
+        },
+        'no_exist': {
+            'actions': [],
+            'result': {'type': 'form', 'arch': ex_form, 'fields': {}, 'state': (('end', _('_Close')),)},
+        },
+        'process': {
+            'actions': [_do_action],
+            'result': {'type': 'state', 'state': 'done'},
+        },
+        'done': {
+            'actions': [],
+            'result': {'type': 'form', 'arch': done_form, 'fields': {}, 'state': (('exit', _('_Close')),)},
+        },
+        'exit': {
+            'actions': [],
+            'result': {'type': 'state', 'state': 'end'},
+        },
+    }
+report_actions_remove_wizard('aeroo.report_actions_remove')
+