report_report.py 672 B

12345678910111213141516171819202122232425262728
  1. # -*- coding: utf-8 -*-
  2. from openerp.http import request as r
  3. def get_report_report():
  4. query = '''
  5. SELECT
  6. report.id,
  7. report.name,
  8. report.name_template,
  9. report.description,
  10. report.icon_code,
  11. report.category_id
  12. FROM report_report AS report
  13. ORDER BY report.sequence
  14. '''
  15. r.cr.execute(query)
  16. return [
  17. {
  18. 'id': j[0],
  19. 'name': j[1],
  20. 'name_template': j[2],
  21. 'description': j[3],
  22. 'icon_code': j[4],
  23. 'category_id': j[5],
  24. } for j in r.cr.fetchall()
  25. ]