# -*- coding: utf-8 -*-
from openerp.http import request as r

def get_res_users():
    query = '''
        SELECT
            users.id,
            users.company_id,
            users.store_id,
            partner.name
        FROM res_users AS users
        LEFT JOIN res_partner AS partner
        ON partner.id = users.partner_id
        WHERE users.active = true
    '''

    r.cr.execute(query)

    return [
        {
            'id': j[0],
            'company_id': j[1],
            'store_id': j[2],
            'name': j[3],

        } for j in r.cr.fetchall()
    ]