123456789101112131415161718192021222324252627282930313233 |
- # # -*- coding: utf-8 -*-
- # from openerp.http import request as r
- #
- # def get_contract_line_inmobiliaria():
- # query = '''
- # SELECT
- # line.id,
- # line.move_id,
- # line.invoice_id,
- # move_line.date_maturity
- # FROM account_analytic_line AS line
- # LEFT JOIN account_move_line AS move_line
- # ON line.move_id = move_line.id
- # LEFT JOIN account_move AS move
- # ON move.id = move_line.move_id
- # '''
- #
- # r.cr.execute(query)
- #
- # return [
- # {
- # 'id': j[0],
- # 'analytic_account_id': j[1],
- # 'name': j[2],
- # 'quantity': j[3],
- # 'price_unit': j[4],
- # 't_manzana': j[5],
- # 't_lote': j[6],
- # 'move_line_id':j[7],
- # 'invoice_id':j[8],
- #
- # } for j in r.cr.fetchall()
- # ]
|