12345678910111213141516171819202122232425262728293031323334353637383940414243 |
- # -*- coding: utf-8 -*-
- from openerp.http import request as r
- def get_contracts_inmobiliaria():
- query = '''
- SELECT
- contract.id,
- contract.code,
- contract.partner_id,
- contract.state,
- contract.date,
- contract.description,
- contract.name,
- contract.recurring_next_date,
- contract.recurring_rule_type,
- contract.nro_cuotas,
- contract.cuota_total,
- partner.name,
- contract.date_start
- FROM account_analytic_account AS contract
- LEFT JOIN res_partner AS partner
- ON partner.id = contract.partner_id
- '''
- r.cr.execute(query)
- return [
- {
- 'id': j[0],
- 'code': j[1],
- 'partner_id': j[2],
- 'state': j[3],
- 'date': j[4],
- 'description': j[5],
- 'name': j[6],
- 'recurring_next_date': j[7],
- 'recurring_rule_type': j[8],
- 'nro_cuotas': j[9],
- 'cuota_total': j[10],
- 'partner_name': j[11],
- 'date_start':j[12],
- } for j in r.cr.fetchall()
- ]
|