Merge lp:~camptocamp/c2c-financial-addons/6.1-fix-counterpart-1016390 into lp:c2c-financial-addons/6.1

[Guewen Baconnier @ Camptocamp]

related to lp:1016390

I'm not sure that is a correction for the bug, but this query needed to be simplified anyway.

[Joël Grand-Guillaume @ camptocamp (jgrandguillaume-c2c)]

LGTM

review: Approve (code review, no tests)

Unmerged revisions

92. By Guewen Baconnier @ Camptocamp <email address hidden> on 2012-10-24

[FIX] account_financial_report_webkit: fix the query which build a list of accounts counterparts

=== modified file 'account_financial_report_webkit/report/common_reports.py'
--- account_financial_report_webkit/report/common_reports.py	2012-02-23 14:14:02 +0000
+++ account_financial_report_webkit/report/common_reports.py	2012-10-24 08:01:19 +0000
@@ -481,15 +481,12 @@
 SELECT account_move.id,
        array_to_string(
           ARRAY(SELECT DISTINCT a.code
-                FROM account_move_line m2
-                  LEFT JOIN account_account a ON (m2.account_id=a.id)
-                WHERE m2.move_id =account_move_line.move_id
-                  AND m2.account_id<>%s limit %s) , ', ')
-
+                FROM account_move_line ml
+                JOIN account_account a ON (ml.account_id = a.id)
+                WHERE ml.move_id = account_move.id
+                  AND ml.account_id != %s limit %s), ', ')
 FROM account_move
-        JOIN account_move_line on (account_move_line.move_id = account_move.id)
-        JOIN account_account on (account_move_line.account_id = account_account.id)
-WHERE move_id in %s"""
+WHERE id in %s"""
 
         try:
             self.cursor.execute(sql, (account_id, limit, tuple(move_ids)))