"""User Document Queries."""

USER_INFO_SQL = """
SELECT
    c.contact_first_name, c.contact_last_name,
    c.contact_email, vc.vendor_id, vc.id as user_id,
    (case when(vc.active = 'Y') THEN 1 ELSE 0 END) as is_active,
    s.subaccount_name as subaccount, vc.master,
    GROUP_CONCAT(r.`role`) as permissions, vc.subaccount_id
FROM
    vend_contact vc
LEFT JOIN contact c
    ON vc.contact_id = c.contact_id
LEFT JOIN subaccount s
    ON vc.subaccount_id = s.subaccount_id
LEFT JOIN vend_contact_roles vr
    ON vc.id = vr.vend_contact_id
LEFT JOIN vendor_roles r
    ON vr.role_id = r.id
WHERE
    1 {user} {contact} {subaccount}
GROUP BY
    vc.id;
"""