# # -*- 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()
#     ]