account_analytic_line.py 834 B

123456789101112131415161718192021222324252627282930313233
  1. # # -*- coding: utf-8 -*-
  2. # from openerp.http import request as r
  3. #
  4. # def get_contract_line_inmobiliaria():
  5. # query = '''
  6. # SELECT
  7. # line.id,
  8. # line.move_id,
  9. # line.invoice_id,
  10. # move_line.date_maturity
  11. # FROM account_analytic_line AS line
  12. # LEFT JOIN account_move_line AS move_line
  13. # ON line.move_id = move_line.id
  14. # LEFT JOIN account_move AS move
  15. # ON move.id = move_line.move_id
  16. # '''
  17. #
  18. # r.cr.execute(query)
  19. #
  20. # return [
  21. # {
  22. # 'id': j[0],
  23. # 'analytic_account_id': j[1],
  24. # 'name': j[2],
  25. # 'quantity': j[3],
  26. # 'price_unit': j[4],
  27. # 't_manzana': j[5],
  28. # 't_lote': j[6],
  29. # 'move_line_id':j[7],
  30. # 'invoice_id':j[8],
  31. #
  32. # } for j in r.cr.fetchall()
  33. # ]