f_authorize_user_role_policy_salesman

--Adrian, Nov 21, 2017

CREATE OR REPLACE FUNCTION f_authorize_user_role_policy_salesman(bigint, bigint, bigint, bigint)
  RETURNS integer AS
$BODY$
DECLARE

    pTenantId              alias for $1;
    pUserId                alias for $2;
    pRoleId                alias for $3;
    pSalesmanId            alias for $4;

    vResult                 integer;
    vSalesmanId             bigint;
    vUserRoleId             bigint;

BEGIN

    vResult := 1;

    SELECT C.user_role_id, C.salesman_id INTO vUserRoleId, vSalesmanId
    FROM t_user A, t_user_role B, m_policy_salesman C
    WHERE A.tenant_id = pTenantId AND
        A.user_id = pUserId AND
        A.user_id = B.user_id AND
        B.role_id = pRoleId AND
        B.user_role_id = C.user_role_id AND
        C.salesman_id = pSalesmanId;

    IF NOT FOUND THEN
        vResult := 0;
    END IF;

    return vResult;

END;
$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100;
/