| 1234567891011121314151617181920212223242526 |
- # -*- coding: utf-8 -*-
- from openerp.http import request as r
- def get_report_category():
- query = '''
- SELECT
- category.id,
- category.name,
- category.name_template,
- category.description,
- category.icon_code
- FROM report_category AS category
- ORDER BY category.sequence
- '''
- r.cr.execute(query)
- return [
- {
- 'id': j[0],
- 'name': j[1],
- 'name_template': j[2],
- 'description': j[3],
- 'icon_code': j[4],
- } for j in r.cr.fetchall()
- ]
|
