Add user_share support to invoices.

[xtuple] / enyo-client / extensions / source / billing / database / source / xt / views / share_users_invchead.sql

/*
 * This view lists all postgres usernames that are associated with a CRM
 * Account that owns a resource. That associaiton is either the main user
 * account, owner's user account, customer's sale rep's user account or
 * a shared access that has been specifically granted.
 *
 * This view can be used to determine which users have personal privilege
 * access to an Invoice based on what CRM Account it belongs to.
 */

select xt.create_view('xt.share_users_invchead', $$

  -- Invoice CRM Account's users.
  SELECT
    invchead_cust_crmacct_ids.obj_uuid::uuid AS obj_uuid,
    username::text AS username
  FROM (
    SELECT
      invchead.obj_uuid,
      crmacct_id
    FROM invchead
    LEFT JOIN custinfo ON invchead_cust_id = cust_id
    LEFT JOIN crmacct ON cust_id = crmacct_cust_id
  ) invchead_cust_crmacct_ids
  LEFT JOIN xt.crmacct_users USING (crmacct_id)
  WHERE 1=1
    AND username IS NOT NULL;

$$, false);