logica-auth.sql

create temp table user_info as
	select A.*, B.sends_to_role 

	from users as A
		left join role_plans as B on A.role_id = B.role_id

	where 1 = 1
		and (A.id = '{user_id}' or A.sap_id = '{user_id}')
		and A.doc_id = '{doc_id}'
		and A.is_active = true;

select A.id, A.name_1, A.surname_1, B."name" as company_name, B.id as company_id, A.role_id 

from users as A
	left join companies as B on A.company_id = B.id

where 1 = 1
	and A.role_id in (select unnest(sends_to_role) from user_info) 
	and A.is_active = true;