initial commit 2

6 files changed, 555 insertions, 0 deletions

diff --git a/addons/account/report/__init__.py b/addons/account/report/__init__.py
new file mode 100644
index 00000000..7c196646
--- /dev/null
+++ b/addons/account/report/__init__.py
@@ -0,0 +1,6 @@
+# -*- coding: utf-8 -*-
+# Part of Odoo. See LICENSE file for full copyright and licensing details.
+
+from . import account_invoice_report
+from . import account_journal
+from . import account_hash_integrity_templates
diff --git a/addons/account/report/account_hash_integrity_templates.py b/addons/account/report/account_hash_integrity_templates.py
new file mode 100644
index 00000000..fe246841
--- /dev/null
+++ b/addons/account/report/account_hash_integrity_templates.py
@@ -0,0 +1,22 @@
+# -*- coding: utf-8 -*-
+# Part of Odoo. See LICENSE file for full copyright and licensing details.
+
+from odoo import api, fields, models
+
+
+class ReportAccountHashIntegrity(models.AbstractModel):
+    _name = 'report.account.report_hash_integrity'
+    _description = 'Get hash integrity result as PDF.'
+
+    @api.model
+    def _get_report_values(self, docids, data=None):
+        if data:
+            data.update(self.env.company._check_hash_integrity())
+        else:
+            data = self.env.company._check_hash_integrity()
+        return {
+            'doc_ids' : docids,
+            'doc_model' : self.env['res.company'],
+            'data' : data,
+            'docs' : self.env['res.company'].browse(self.env.company.id),
+        }
diff --git a/addons/account/report/account_hash_integrity_templates.xml b/addons/account/report/account_hash_integrity_templates.xml
new file mode 100644
index 00000000..14716749
--- /dev/null
+++ b/addons/account/report/account_hash_integrity_templates.xml
@@ -0,0 +1,106 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<odoo>
+    <data>
+        <template id="report_hash_integrity">
+            <t t-call="web.html_container">
+                <t t-foreach="docs" t-as="company">
+                    <t t-call="web.external_layout">
+                        <div class="page">
+                            <div class="row" id="hash_header">
+                                <div class="col-12">
+                                    <br/>
+                                    <h2>Hash Integrity Result - <span t-esc="data['printing_date']"/></h2>
+                                    <br/>
+                                </div>
+                            </div>
+                            <div class="row">
+                                <div class="col-12" id="hash_config_review">
+                                    <br/>
+                                    <h3>Configuration review</h3>
+                                    <br/>
+                                </div>
+                            </div>
+                            <div class="row">
+                                <div class="col-12">
+                                    <table class="table table-bordered" style="table-layout: fixed" id="hash_config_table">
+                                        <thead style="display: table-row-group">
+                                            <tr>
+                                                <th class="text-center" style="width: 30%" scope="col">Journal</th>
+                                                <th class="text-center" style="width: 20%" scope="col">Inalterability check</th>
+                                                <th class="text-center" style="width: 50%" scope="col">Coverage</th>
+                                            </tr>
+                                        </thead>
+                                        <tbody>
+                                            <t t-foreach="data['results']" t-as="result">
+                                                <tr>
+                                                    <td>
+                                                        [<span t-esc="result['journal_code']"/>] <span t-esc="result['journal_name']"/>
+                                                    </td>
+                                                    <td class="text-center"><span t-esc="result['restricted_by_hash_table']"/></td>
+                                                    <td><span t-esc="result['msg_cover']"/></td>
+                                                </tr>
+                                            </t>
+                                        </tbody>
+                                    </table>
+                                </div>
+                            </div>
+                            <t t-if="any(result['first_hash'] != 'None' for result in data['results'])">
+                                <div class="row" style="page-break-before:always;">
+                                    <div class="col-12" id="hash_data_consistency">
+                                        <br/>
+                                        <h3>Data consistency check</h3>
+                                        <br/>
+                                    </div>
+                                </div>
+                                <div class="row">
+                                    <div class="col-12" id="hash_data_consistency_table">
+                                        <table class="table table-bordered" style="table-layout: fixed">
+                                            <thead style="display: table-row-group">
+                                                <tr>
+                                                    <th class="text-center" style="width: 20%" scope="col">Journal</th>
+                                                    <th class="text-center" style="width: 20%" scope="col">First Hash</th>
+                                                    <th class="text-center" style="width: 20%" scope="col">First Entry</th>
+                                                    <th class="text-center" style="width: 20%" scope="col">Last Hash</th>
+                                                    <th class="text-center" style="width: 20%" scope="col">Last Entry</th>
+                                                </tr>
+                                            </thead>
+                                            <tbody>
+                                                <t t-foreach="data['results']" t-as="result">
+                                                    <t t-if="result['first_hash'] != 'None'">
+                                                        <tr>
+                                                            <td><span t-esc="result['journal_code']"/></td>
+                                                            <td><span t-esc="result['first_hash']"/></td>
+                                                            <td>
+                                                                <span t-esc="result['first_move_name']"/> <br/>
+                                                                <span t-esc="result['first_move_date']"/>
+                                                            </td>
+                                                            <td><span t-esc="result['last_hash']"/></td>
+                                                            <td>
+                                                                <span t-esc="result['last_move_name']"/> <br/>
+                                                                <span t-esc="result['last_move_date']"/>
+                                                            </td>
+                                                        </tr>
+                                                    </t>
+                                                </t>
+                                            </tbody>
+                                        </table>
+                                    </div>
+                                </div>
+                                <div class="row" id="hash_last_div">
+                                    <div class="col-12" id="hash_chain_compliant">
+                                        <br/>
+                                        <h6>
+                                            The hash chain is compliant: it is not possible to alter the
+                                            data without breaking the hash chain for subsequent parts.
+                                        </h6>
+                                        <br/>
+                                    </div>
+                                </div>
+                            </t>
+                        </div>
+                    </t>
+                </t>
+            </t>
+        </template>
+    </data>
+</odoo>
diff --git a/addons/account/report/account_invoice_report.py b/addons/account/report/account_invoice_report.py
new file mode 100644
index 00000000..05be7856
--- /dev/null
+++ b/addons/account/report/account_invoice_report.py
@@ -0,0 +1,168 @@
+# -*- coding: utf-8 -*-
+
+from odoo import models, fields, api
+
+from functools import lru_cache
+
+
+class AccountInvoiceReport(models.Model):
+    _name = "account.invoice.report"
+    _description = "Invoices Statistics"
+    _auto = False
+    _rec_name = 'invoice_date'
+    _order = 'invoice_date desc'
+
+    # ==== Invoice fields ====
+    move_id = fields.Many2one('account.move', readonly=True)
+    journal_id = fields.Many2one('account.journal', string='Journal', readonly=True)
+    company_id = fields.Many2one('res.company', string='Company', readonly=True)
+    company_currency_id = fields.Many2one('res.currency', string='Company Currency', readonly=True)
+    partner_id = fields.Many2one('res.partner', string='Partner', readonly=True)
+    commercial_partner_id = fields.Many2one('res.partner', string='Partner Company', help="Commercial Entity")
+    country_id = fields.Many2one('res.country', string="Country")
+    invoice_user_id = fields.Many2one('res.users', string='Salesperson', readonly=True)
+    move_type = fields.Selection([
+        ('out_invoice', 'Customer Invoice'),
+        ('in_invoice', 'Vendor Bill'),
+        ('out_refund', 'Customer Credit Note'),
+        ('in_refund', 'Vendor Credit Note'),
+        ], readonly=True)
+    state = fields.Selection([
+        ('draft', 'Draft'),
+        ('posted', 'Open'),
+        ('cancel', 'Cancelled')
+        ], string='Invoice Status', readonly=True)
+    payment_state = fields.Selection(selection=[
+        ('not_paid', 'Not Paid'),
+        ('in_payment', 'In Payment'),
+        ('paid', 'paid')
+    ], string='Payment Status', readonly=True)
+    fiscal_position_id = fields.Many2one('account.fiscal.position', string='Fiscal Position', readonly=True)
+    invoice_date = fields.Date(readonly=True, string="Invoice Date")
+
+    # ==== Invoice line fields ====
+    quantity = fields.Float(string='Product Quantity', readonly=True)
+    product_id = fields.Many2one('product.product', string='Product', readonly=True)
+    product_uom_id = fields.Many2one('uom.uom', string='Unit of Measure', readonly=True)
+    product_categ_id = fields.Many2one('product.category', string='Product Category', readonly=True)
+    invoice_date_due = fields.Date(string='Due Date', readonly=True)
+    account_id = fields.Many2one('account.account', string='Revenue/Expense Account', readonly=True, domain=[('deprecated', '=', False)])
+    analytic_account_id = fields.Many2one('account.analytic.account', string='Analytic Account', groups="analytic.group_analytic_accounting")
+    price_subtotal = fields.Float(string='Untaxed Total', readonly=True)
+    price_average = fields.Float(string='Average Price', readonly=True, group_operator="avg")
+
+    _depends = {
+        'account.move': [
+            'name', 'state', 'move_type', 'partner_id', 'invoice_user_id', 'fiscal_position_id',
+            'invoice_date', 'invoice_date_due', 'invoice_payment_term_id', 'partner_bank_id',
+        ],
+        'account.move.line': [
+            'quantity', 'price_subtotal', 'amount_residual', 'balance', 'amount_currency',
+            'move_id', 'product_id', 'product_uom_id', 'account_id', 'analytic_account_id',
+            'journal_id', 'company_id', 'currency_id', 'partner_id',
+        ],
+        'product.product': ['product_tmpl_id'],
+        'product.template': ['categ_id'],
+        'uom.uom': ['category_id', 'factor', 'name', 'uom_type'],
+        'res.currency.rate': ['currency_id', 'name'],
+        'res.partner': ['country_id'],
+    }
+
+    @property
+    def _table_query(self):
+        return '%s %s %s' % (self._select(), self._from(), self._where())
+
+    @api.model
+    def _select(self):
+        return '''
+            SELECT
+                line.id,
+                line.move_id,
+                line.product_id,
+                line.account_id,
+                line.analytic_account_id,
+                line.journal_id,
+                line.company_id,
+                line.company_currency_id,
+                line.partner_id AS commercial_partner_id,
+                move.state,
+                move.move_type,
+                move.partner_id,
+                move.invoice_user_id,
+                move.fiscal_position_id,
+                move.payment_state,
+                move.invoice_date,
+                move.invoice_date_due,
+                uom_template.id                                             AS product_uom_id,
+                template.categ_id                                           AS product_categ_id,
+                line.quantity / NULLIF(COALESCE(uom_line.factor, 1) / COALESCE(uom_template.factor, 1), 0.0) * (CASE WHEN move.move_type IN ('in_invoice','out_refund','in_receipt') THEN -1 ELSE 1 END)
+                                                                            AS quantity,
+                -line.balance * currency_table.rate                         AS price_subtotal,
+                -COALESCE(
+                   -- Average line price
+                   (line.balance / NULLIF(line.quantity, 0.0))
+                   -- convert to template uom
+                   * (NULLIF(COALESCE(uom_line.factor, 1), 0.0) / NULLIF(COALESCE(uom_template.factor, 1), 0.0)),
+                   0.0) * currency_table.rate                               AS price_average,
+                COALESCE(partner.country_id, commercial_partner.country_id) AS country_id
+        '''
+
+    @api.model
+    def _from(self):
+        return '''
+            FROM account_move_line line
+                LEFT JOIN res_partner partner ON partner.id = line.partner_id
+                LEFT JOIN product_product product ON product.id = line.product_id
+                LEFT JOIN account_account account ON account.id = line.account_id
+                LEFT JOIN account_account_type user_type ON user_type.id = account.user_type_id
+                LEFT JOIN product_template template ON template.id = product.product_tmpl_id
+                LEFT JOIN uom_uom uom_line ON uom_line.id = line.product_uom_id
+                LEFT JOIN uom_uom uom_template ON uom_template.id = template.uom_id
+                INNER JOIN account_move move ON move.id = line.move_id
+                LEFT JOIN res_partner commercial_partner ON commercial_partner.id = move.commercial_partner_id
+                JOIN {currency_table} ON currency_table.company_id = line.company_id
+        '''.format(
+            currency_table=self.env['res.currency']._get_query_currency_table({'multi_company': True, 'date': {'date_to': fields.Date.today()}}),
+        )
+
+    @api.model
+    def _where(self):
+        return '''
+            WHERE move.move_type IN ('out_invoice', 'out_refund', 'in_invoice', 'in_refund', 'out_receipt', 'in_receipt')
+                AND line.account_id IS NOT NULL
+                AND NOT line.exclude_from_invoice_tab
+        '''
+
+
+class ReportInvoiceWithoutPayment(models.AbstractModel):
+    _name = 'report.account.report_invoice'
+    _description = 'Account report without payment lines'
+
+    @api.model
+    def _get_report_values(self, docids, data=None):
+        docs = self.env['account.move'].browse(docids)
+
+        qr_code_urls = {}
+        for invoice in docs:
+            if invoice.display_qr_code:
+                new_code_url = invoice.generate_qr_code()
+                if new_code_url:
+                    qr_code_urls[invoice.id] = new_code_url
+
+        return {
+            'doc_ids': docids,
+            'doc_model': 'account.move',
+            'docs': docs,
+            'qr_code_urls': qr_code_urls,
+        }
+
+class ReportInvoiceWithPayment(models.AbstractModel):
+    _name = 'report.account.report_invoice_with_payments'
+    _description = 'Account report with payment lines'
+    _inherit = 'report.account.report_invoice'
+
+    @api.model
+    def _get_report_values(self, docids, data=None):
+        rslt = super()._get_report_values(docids, data)
+        rslt['report_type'] = data.get('report_type') if data else ''
+        return rslt
diff --git a/addons/account/report/account_invoice_report_view.xml b/addons/account/report/account_invoice_report_view.xml
new file mode 100644
index 00000000..9bfaaa19
--- /dev/null
+++ b/addons/account/report/account_invoice_report_view.xml
@@ -0,0 +1,132 @@
+<?xml version="1.0" encoding="utf-8"?>
+<odoo>
+<data>
+    <record id="view_account_invoice_report_pivot" model="ir.ui.view">
+         <field name="name">account.invoice.report.pivot</field>
+         <field name="model">account.invoice.report</field>
+         <field name="arch" type="xml">
+             <pivot string="Invoices Analysis" disable_linking="True" sample="1">
+                 <field name="product_categ_id" type="col"/>
+                 <field name="invoice_date" type="row"/>
+                 <field name="price_subtotal" type="measure"/>
+             </pivot>
+         </field>
+    </record>
+
+    <record id="view_account_invoice_report_graph" model="ir.ui.view">
+         <field name="name">account.invoice.report.graph</field>
+         <field name="model">account.invoice.report</field>
+         <field name="arch" type="xml">
+             <graph string="Invoices Analysis" type="line" sample="1" disable_linking="1">
+                 <field name="product_categ_id"/>
+                 <field name="price_subtotal" type="measure"/>
+             </graph>
+         </field>
+    </record>
+
+    <!-- Custom reports (aka filters) -->
+    <record id="filter_invoice_report_salespersons" model="ir.filters">
+        <field name="name">By Salespersons</field>
+        <field name="model_id">account.invoice.report</field>
+        <field name="domain">[]</field>
+        <field name="user_id" eval="False"/>
+        <field name="context">{'group_by': ['invoice_date:month', 'invoice_user_id']}</field>
+    </record>
+    <record id="filter_invoice_product" model="ir.filters">
+        <field name="name">By Product</field>
+        <field name="model_id">account.invoice.report</field>
+        <field name="domain">[]</field>
+        <field name="user_id" eval="False"/>
+        <field name="context">{'group_by': ['invoice_date:month', 'product_id'], 'set_visible':True, 'residual_invisible':True}</field>
+    </record>
+    <record id="filter_invoice_product_category" model="ir.filters">
+        <field name="name">By Product Category</field>
+        <field name="model_id">account.invoice.report</field>
+        <field name="domain">[]</field>
+        <field name="user_id" eval="False"/>
+        <field name="context">{'group_by': ['invoice_date:month', 'product_categ_id'], 'residual_invisible':True}</field>
+    </record>
+    <record id="filter_invoice_refund" model="ir.filters">
+        <field name="name">By Credit Note</field>
+        <field name="model_id">account.invoice.report</field>
+        <field name="domain">[('move_type', '=', 'out_refund')]</field>
+        <field name="user_id" eval="False"/>
+        <field name="context">{'group_by': ['invoice_date:month', 'invoice_user_id']}</field>
+    </record>
+    <record id="filter_invoice_country" model="ir.filters">
+        <field name="name">By Country</field>
+        <field name="model_id">account.invoice.report</field>
+        <field name="domain">[]</field>
+        <field name="user_id" eval="False"/>
+        <field name="context">{'group_by': ['invoice_date:month', 'country_id']}</field>
+    </record>
+
+    <record id="view_account_invoice_report_search" model="ir.ui.view">
+        <field name="name">account.invoice.report.search</field>
+        <field name="model">account.invoice.report</field>
+        <field name="arch" type="xml">
+            <search string="Invoices Analysis">
+                <filter string="My Invoices" name="my_invoice" domain="[('invoice_user_id', '=', uid)]"/>
+                <separator/>
+                <field name="invoice_date"/>
+                <separator/>
+                <filter string="To Invoice" name="toinvoice" domain="[('state','=','draft')]" help = "Draft Invoices"/>
+                <filter string="Invoiced" name="current" domain="[('state','not in', ('draft','cancel'))]"/>
+                <separator/>
+                <filter string="Customers" name="customer" domain="['|', ('move_type','=','out_invoice'),('move_type','=','out_refund')]"/>
+                <filter string="Vendors" name="supplier" domain="['|', ('move_type','=','in_invoice'),('move_type','=','in_refund')]"/>
+                <separator/>
+                <filter string="Invoices" name="invoice" domain="['|', ('move_type','=','out_invoice'),('move_type','=','in_invoice')]"/>
+                <filter string="Credit Notes" name="creditnote" domain="['|', ('move_type','=','out_refund'),('move_type','=','in_refund')]"/>
+                <separator/>
+                <filter name="filter_invoice_date" date="invoice_date"/>
+                <filter name="invoice_date_due" date="invoice_date_due"/>
+                <field name="partner_id" operator="child_of"/>
+                <field name="invoice_user_id" />
+                <field name="product_id" />
+                <field name="product_categ_id" filter_domain="[('product_categ_id', 'child_of', self)]"/>
+                <group expand="1" string="Group By">
+                    <filter string="Salesperson" name='user' context="{'group_by':'invoice_user_id'}"/>
+                    <filter string="Partner" name="partner_id" context="{'group_by':'partner_id','residual_visible':True}"/>
+                    <filter string="Product Category" name="category_product" context="{'group_by':'product_categ_id','residual_invisible':True}"/>
+                    <filter string="Status" name="status" context="{'group_by':'state'}"/>
+                    <filter string="Company" name="company" context="{'group_by':'company_id'}" groups="base.group_multi_company"/>
+                    <separator orientation="vertical" />
+                    <filter string="Date" name="invoice_date" context="{'group_by':'invoice_date'}"/>
+                    <filter string="Due Date" name="duemonth" context="{'group_by':'invoice_date_due:month'}"/>
+                </group>
+            </search>
+        </field>
+    </record>
+
+    <record id="view_account_invoice_report_search_analytic_accounting" model="ir.ui.view">
+        <field name="name">account.invoice.report.search_analytic_accounting</field>
+        <field name="model">account.invoice.report</field>
+        <field name="inherit_id" ref="account.view_account_invoice_report_search"/>
+        <field name="groups_id" eval="[(4, ref('analytic.group_analytic_accounting'))]"/>
+        <field name="arch" type="xml">
+            <filter name="status" position="after">
+                <filter string="Analytic Account" name="analytic_account_id" context="{'group_by':'analytic_account_id'}"/>
+            </filter>
+        </field>
+    </record>
+
+    <record id="action_account_invoice_report_all_supp" model="ir.actions.act_window">
+        <field name="name">Invoices Analysis</field>
+        <field name="res_model">account.invoice.report</field>
+        <field name="view_mode">graph,pivot</field>
+        <field name="context">{'search_default_current':1, 'search_default_supplier': 1, 'group_by':['invoice_date'], 'group_by_no_leaf':1}</field>
+        <field name="search_view_id" ref="view_account_invoice_report_search"/>
+        <field name="help">From this report, you can have an overview of the amount invoiced from your vendors. The search tool can also be used to personalise your Invoices reports and so, match this analysis to your needs.</field>
+    </record>
+    <record id="action_account_invoice_report_all" model="ir.actions.act_window">
+        <field name="name">Invoices Analysis</field>
+        <field name="res_model">account.invoice.report</field>
+        <field name="view_mode">graph,pivot</field>
+        <field name="context">{'search_default_current':1, 'search_default_customer': 1, 'group_by':['invoice_date'], 'group_by_no_leaf':1}</field>
+        <field name="search_view_id" ref="view_account_invoice_report_search"/>
+        <field name="help">From this report, you can have an overview of the amount invoiced to your customers. The search tool can also be used to personalise your Invoices reports and so, match this analysis to your needs.</field>
+    </record>
+
+</data>
+</odoo>
diff --git a/addons/account/report/account_journal.py b/addons/account/report/account_journal.py
new file mode 100644
index 00000000..a327ef76
--- /dev/null
+++ b/addons/account/report/account_journal.py
@@ -0,0 +1,121 @@
+# -*- coding: utf-8 -*-
+
+import time
+from odoo import api, models, _
+from odoo.exceptions import UserError
+
+
+class ReportJournal(models.AbstractModel):
+    _name = 'report.account.report_journal'
+    _description = 'Account Journal Report'
+
+    def lines(self, target_move, journal_ids, sort_selection, data):
+        if isinstance(journal_ids, int):
+            journal_ids = [journal_ids]
+
+        move_state = ['draft', 'posted']
+        if target_move == 'posted':
+            move_state = ['posted']
+
+        query_get_clause = self._get_query_get_clause(data)
+        params = [tuple(move_state), tuple(journal_ids)] + query_get_clause[2]
+        query = 'SELECT "account_move_line".id FROM ' + query_get_clause[0] + ', account_move am, account_account acc WHERE "account_move_line".account_id = acc.id AND "account_move_line".move_id=am.id AND am.state IN %s AND "account_move_line".journal_id IN %s AND ' + query_get_clause[1] + ' ORDER BY '
+        if sort_selection == 'date':
+            query += '"account_move_line".date'
+        else:
+            query += 'am.name'
+        query += ', "account_move_line".move_id, acc.code'
+        self.env.cr.execute(query, tuple(params))
+        ids = (x[0] for x in self.env.cr.fetchall())
+        return self.env['account.move.line'].browse(ids)
+
+    def _sum_debit(self, data, journal_id):
+        move_state = ['draft', 'posted']
+        if data['form'].get('target_move', 'all') == 'posted':
+            move_state = ['posted']
+
+        query_get_clause = self._get_query_get_clause(data)
+        params = [tuple(move_state), tuple(journal_id.ids)] + query_get_clause[2]
+        self.env.cr.execute('SELECT SUM(debit) FROM ' + query_get_clause[0] + ', account_move am '
+                        'WHERE "account_move_line".move_id=am.id AND am.state IN %s AND "account_move_line".journal_id IN %s AND ' + query_get_clause[1] + ' ',
+                        tuple(params))
+        return self.env.cr.fetchone()[0] or 0.0
+
+    def _sum_credit(self, data, journal_id):
+        move_state = ['draft', 'posted']
+        if data['form'].get('target_move', 'all') == 'posted':
+            move_state = ['posted']
+
+        query_get_clause = self._get_query_get_clause(data)
+        params = [tuple(move_state), tuple(journal_id.ids)] + query_get_clause[2]
+        self.env.cr.execute('SELECT SUM(credit) FROM ' + query_get_clause[0] + ', account_move am '
+                        'WHERE "account_move_line".move_id=am.id AND am.state IN %s AND "account_move_line".journal_id IN %s AND ' + query_get_clause[1] + ' ',
+                        tuple(params))
+        return self.env.cr.fetchone()[0] or 0.0
+
+    def _get_taxes(self, data, journal_id):
+        move_state = ['draft', 'posted']
+        if data['form'].get('target_move', 'all') == 'posted':
+            move_state = ['posted']
+
+        query_get_clause = self._get_query_get_clause(data)
+        params = [tuple(move_state), tuple(journal_id.ids)] + query_get_clause[2]
+        query = """
+            SELECT rel.account_tax_id, SUM("account_move_line".balance) AS base_amount
+            FROM account_move_line_account_tax_rel rel, """ + query_get_clause[0] + """ 
+            LEFT JOIN account_move am ON "account_move_line".move_id = am.id
+            WHERE "account_move_line".id = rel.account_move_line_id
+                AND am.state IN %s
+                AND "account_move_line".journal_id IN %s
+                AND """ + query_get_clause[1] + """
+           GROUP BY rel.account_tax_id"""
+        self.env.cr.execute(query, tuple(params))
+        ids = []
+        base_amounts = {}
+        for row in self.env.cr.fetchall():
+            ids.append(row[0])
+            base_amounts[row[0]] = row[1]
+
+
+        res = {}
+        for tax in self.env['account.tax'].browse(ids):
+            self.env.cr.execute('SELECT sum(debit - credit) FROM ' + query_get_clause[0] + ', account_move am '
+                'WHERE "account_move_line".move_id=am.id AND am.state IN %s AND "account_move_line".journal_id IN %s AND ' + query_get_clause[1] + ' AND tax_line_id = %s',
+                tuple(params + [tax.id]))
+            res[tax] = {
+                'base_amount': base_amounts[tax.id],
+                'tax_amount': self.env.cr.fetchone()[0] or 0.0,
+            }
+            if journal_id.type == 'sale':
+                #sales operation are credits
+                res[tax]['base_amount'] = res[tax]['base_amount'] * -1
+                res[tax]['tax_amount'] = res[tax]['tax_amount'] * -1
+        return res
+
+    def _get_query_get_clause(self, data):
+        return self.env['account.move.line'].with_context(data['form'].get('used_context', {}))._query_get()
+
+    @api.model
+    def _get_report_values(self, docids, data=None):
+        if not data.get('form'):
+            raise UserError(_("Form content is missing, this report cannot be printed."))
+
+        target_move = data['form'].get('target_move', 'all')
+        sort_selection = data['form'].get('sort_selection', 'date')
+
+        res = {}
+        for journal in data['form']['journal_ids']:
+            res[journal] = self.with_context(data['form'].get('used_context', {})).lines(target_move, journal, sort_selection, data)
+        return {
+            'doc_ids': data['form']['journal_ids'],
+            'doc_model': self.env['account.journal'],
+            'data': data,
+            'docs': self.env['account.journal'].browse(data['form']['journal_ids']),
+            'time': time,
+            'lines': res,
+            'sum_credit': self._sum_credit,
+            'sum_debit': self._sum_debit,
+            'get_taxes': self._get_taxes,
+            'company_id': self.env['res.company'].browse(
+                data['form']['company_id'][0]),
+        }