~vauxoo/addons-vauxoo/6.0-trunk

« back to all changes in this revision

Viewing changes to account_aged_partner_balance_vw/balance.py

• browse files at revision 211.1.5
• compare with another revision
• download diff
• download tarball
• view history from revision 211.1.5

• reverse the comparison (211.1.5 to 543.174.1)
• stop comparing with revision 543.174.1

Show diffs side-by-side

added

removed

account_aged_partner_balance_vw/balance.py

1

 

query_template = "SELECT %s FROM account_account"

2

 

columns = range(1, 5)

3

 

for i in columns:

4

 

    # sum_colums = '0 AS col%s'%(columns)

5

 

    # print map(lambda x: x, columns)

6

 

    cols_query = ', '.join(map(lambda x: i == x and 'SUM(debit+credit) AS col%s' % (

7

 

        x,) or '0 AS col%s' % (x,), columns))

8

 

    dates_query = ' '

9

 

    dates_query += ' BETWEEN %s AND %s)'

10

 

    # query_full = query_template%(sum_colums)

11

 

# print query_full

12

 

 

13

 

# cfd_data_invoices_str = '\n'.join( map(lambda x: '|'.join(x) + '|',

14

 

# cfd_data_invoices) )

15

 

 

16

 

for i in range(5)[::-1]:

17

 

    print i

• Older »

Loggerhead is a web-based interface for Breezy
Version: 2.0.1