| 123456789101112131415161718192021222324252627 |
- # -*- coding: utf-8 -*-
- from openerp.http import request as r
- def get_journals_widget():
- user_store = r.env.user.store_id.id
- query = '''
- SELECT aj.id, aj.name, aj.code, aj.type, rs.store_id
- FROM account_journal AS aj
- LEFT JOIN res_store_journal_rel AS rs
- ON aj.id = rs.journal_id
- WHERE aj.active = true
- AND aj.type in ('sale', 'purchase', 'sale_refund', 'purchase_refund')
- AND rs.store_id = ''' + str(user_store) + '''
- ORDER BY aj.id
- '''
- r.cr.execute(query)
- return [
- {
- 'id': j[0],
- 'name': j[1],
- 'code': j[2],
- 'type': j[3],
- 'store_id': j[4]
- } for j in r.cr.fetchall()
- ]
|
