mirror of
https://github.com/fusionpbx/fusionpbx.git
synced 2025-12-30 09:03:49 +00:00
178f83d6be
* Missing open statement Missing open statement ``` $view['sql'] .= "); \n"; ``` * Double SELECT will break query Double SELECT break query * Forgot update version Forgot update version * No matching ( No matching opening ``` FROM v_contacts as c ); ```
50 lines
2.3 KiB
PHP
50 lines
2.3 KiB
PHP
<?php
|
|
|
|
$view['name'] = "view_contacts";
|
|
$view['version'] = "20250920";
|
|
$view['description'] = "Show the contacts with assigned addresses, phones, emails, urls, users, groups, settings, and relations";
|
|
|
|
$view['sql'] = "SELECT \n";
|
|
$view['sql'] .= " c.*, \n";
|
|
$view['sql'] .= " ( \n";
|
|
$view['sql'] .= " SELECT json_agg(a.*) \n";
|
|
$view['sql'] .= " FROM v_contact_addresses AS a \n";
|
|
$view['sql'] .= " WHERE a.contact_uuid = c.contact_uuid \n";
|
|
$view['sql'] .= " ) AS contact_addresses, \n";
|
|
$view['sql'] .= " ( \n";
|
|
$view['sql'] .= " SELECT json_agg(p.*) \n";
|
|
$view['sql'] .= " FROM v_contact_phones AS p \n";
|
|
$view['sql'] .= " WHERE p.contact_uuid = c.contact_uuid \n";
|
|
$view['sql'] .= " ) AS contact_phones, \n";
|
|
$view['sql'] .= " ( \n";
|
|
$view['sql'] .= " SELECT json_agg(e.*) \n";
|
|
$view['sql'] .= " FROM v_contact_emails AS e \n";
|
|
$view['sql'] .= " WHERE e.contact_uuid = c.contact_uuid \n";
|
|
$view['sql'] .= " ) AS contact_emails, \n";
|
|
$view['sql'] .= " ( \n";
|
|
$view['sql'] .= " SELECT json_agg(l.*) \n";
|
|
$view['sql'] .= " FROM v_contact_urls AS l \n";
|
|
$view['sql'] .= " WHERE l.contact_uuid = c.contact_uuid \n";
|
|
$view['sql'] .= " ) AS contact_urls, \n";
|
|
$view['sql'] .= " ( \n";
|
|
$view['sql'] .= " SELECT json_agg(u.*) \n";
|
|
$view['sql'] .= " FROM v_contact_users AS u \n";
|
|
$view['sql'] .= " WHERE u.contact_uuid = c.contact_uuid \n";
|
|
$view['sql'] .= " ) AS contact_users, \n";
|
|
$view['sql'] .= " ( \n";
|
|
$view['sql'] .= " SELECT json_agg(g.*) \n";
|
|
$view['sql'] .= " FROM v_contact_groups AS g \n";
|
|
$view['sql'] .= " WHERE g.contact_uuid = c.contact_uuid \n";
|
|
$view['sql'] .= " ) AS contact_groups, \n";
|
|
$view['sql'] .= " ( \n";
|
|
$view['sql'] .= " SELECT json_agg(s.*) \n";
|
|
$view['sql'] .= " FROM v_contact_settings AS s \n";
|
|
$view['sql'] .= " WHERE s.contact_uuid = c.contact_uuid \n";
|
|
$view['sql'] .= " ) AS contact_settings, \n";
|
|
$view['sql'] .= " ( \n";
|
|
$view['sql'] .= " SELECT json_agg(r.*) \n";
|
|
$view['sql'] .= " FROM v_contact_relations AS r \n";
|
|
$view['sql'] .= " WHERE r.contact_uuid = c.contact_uuid \n";
|
|
$view['sql'] .= " ) AS contact_relations \n";
|
|
$view['sql'] .= "FROM v_contacts AS c;\n";
|