~vauxoo/addons-vauxoo/8.0-import_tax_tariff-dev-yani-rev-2

« back to all changes in this revision

Viewing changes to res_partner_btree/res_partner_btree.sql

  • Committer: Nhomar Hernandez
  • Date: 2013-04-19 20:33:12 UTC
  • mfrom: (542.1.314 addons-vauxoo)
  • Revision ID: nhomar@gmail.com-20130419203312-o35v7dn79l6vur0t
[MERGE - PEP8 AND V7-MIG] All migrated to V7 Just
improved osv.osv => osv.Model, osv.osv_memory => osv.TransientModel
import inside openerp.* enviroment
Erased class instansiation no necesarry anymore in V7
AUTOPEP8 run, Left PEP8 long lines manually.

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
1
SELECT tabla.parent_id, sum(debit) AS debit, sum(credit) AS credit
 
2
FROM
 
3
        (
 
4
        SELECT parent.id AS parent_id, node.id AS id,node.name
 
5
        FROM res_partner AS node,res_partner AS parent
 
6
        WHERE node.parent_left BETWEEN parent.parent_left AND parent.parent_right
 
7
        ORDER BY parent.parent_left
 
8
        )tabla
 
9
JOIN
 
10
        (SELECT * FROM account_move_line)tabla2 
 
11
ON tabla.id = tabla2.partner_id
 
12
GROUP BY tabla.parent_id