FusionPBX
118 lines
5.4 KiB
PHP
118 lines
5.4 KiB
PHP
<?php
|
|
|
|
$view['name'] = "view_stream_map";
|
|
$view['version'] = "20260303";
|
|
$view['description'] = "Show all the stream locations throughougt the system where they are being used.";
|
|
$view['sql'] = "select \n";
|
|
$view['sql'] .= " 'extensions' as application, \n";
|
|
$view['sql'] .= " 'hold_music' as type, \n";
|
|
$view['sql'] .= " e.extension_uuid as uuid, \n";
|
|
$view['sql'] .= " e.domain_uuid, \n";
|
|
$view['sql'] .= " d.domain_name, \n";
|
|
$view['sql'] .= " e.effective_caller_id_name as name, \n";
|
|
$view['sql'] .= " e.extension as number, \n";
|
|
$view['sql'] .= " e.hold_music as music, \n";
|
|
$view['sql'] .= " e.description \n";
|
|
$view['sql'] .= "from v_extensions as e, v_domains as d \n";
|
|
$view['sql'] .= "where hold_music like '%shout%' \n";
|
|
$view['sql'] .= "and e.domain_uuid = d.domain_uuid \n";
|
|
$view['sql'] .= "union \n";
|
|
$view['sql'] .= "select \n";
|
|
$view['sql'] .= " 'ring_groups' as application, \n";
|
|
$view['sql'] .= " 'ringback' as type, \n";
|
|
$view['sql'] .= " r.ring_group_uuid as uuid, \n";
|
|
$view['sql'] .= " r.domain_uuid, \n";
|
|
$view['sql'] .= " d.domain_name, \n";
|
|
$view['sql'] .= " r.ring_group_name as name, \n";
|
|
$view['sql'] .= " r.ring_group_extension as number, \n";
|
|
$view['sql'] .= " r.ring_group_ringback as music, \n";
|
|
$view['sql'] .= " r.ring_group_description as description \n";
|
|
$view['sql'] .= "from v_ring_groups as r, v_domains as d \n";
|
|
$view['sql'] .= "where ring_group_ringback like '%shout%' \n";
|
|
$view['sql'] .= "and r.domain_uuid = d.domain_uuid \n";
|
|
$view['sql'] .= "union \n";
|
|
$view['sql'] .= "select \n";
|
|
$view['sql'] .= " 'ivr_menus' as application, \n";
|
|
$view['sql'] .= " 'ringback' as type, \n";
|
|
$view['sql'] .= " i.ivr_menu_uuid as uuid, \n";
|
|
$view['sql'] .= " i.domain_uuid, \n";
|
|
$view['sql'] .= " d.domain_name, \n";
|
|
$view['sql'] .= " i.ivr_menu_name as name, \n";
|
|
$view['sql'] .= " i.ivr_menu_extension as number, \n";
|
|
$view['sql'] .= " i.ivr_menu_ringback as music, \n";
|
|
$view['sql'] .= " i.ivr_menu_description as description \n";
|
|
$view['sql'] .= "from v_ivr_menus as i, v_domains as d \n";
|
|
$view['sql'] .= "where ivr_menu_ringback like '%shout%' \n";
|
|
$view['sql'] .= "and i.domain_uuid = d.domain_uuid \n";
|
|
$view['sql'] .= "union \n";
|
|
$view['sql'] .= "select \n";
|
|
$view['sql'] .= " 'call_center_queues' as application, \n";
|
|
$view['sql'] .= " 'hold_music' as type, \n";
|
|
$view['sql'] .= " q.call_center_queue_uuid as uuid, \n";
|
|
$view['sql'] .= " q.domain_uuid, \n";
|
|
$view['sql'] .= " d.domain_name, \n";
|
|
$view['sql'] .= " q.queue_name as name, \n";
|
|
$view['sql'] .= " q.queue_extension as number, \n";
|
|
$view['sql'] .= " q.queue_moh_sound as music, \n";
|
|
$view['sql'] .= " q.queue_description as description \n";
|
|
$view['sql'] .= "from v_call_center_queues as q, v_domains as d \n";
|
|
$view['sql'] .= "where queue_moh_sound like '%shout%' \n";
|
|
$view['sql'] .= "and q.domain_uuid = d.domain_uuid \n";
|
|
$view['sql'] .= "union \n";
|
|
$view['sql'] .= "select \n";
|
|
$view['sql'] .= " 'fifo' as application, \n";
|
|
$view['sql'] .= " 'hold_music' as type, \n";
|
|
$view['sql'] .= " f.fifo_uuid as uuid, \n";
|
|
$view['sql'] .= " f.domain_uuid, \n";
|
|
$view['sql'] .= " d.domain_name, \n";
|
|
$view['sql'] .= " f.fifo_name as name, \n";
|
|
$view['sql'] .= " f.fifo_extension as number, \n";
|
|
$view['sql'] .= " f.fifo_music as music, \n";
|
|
$view['sql'] .= " f.fifo_description as description \n";
|
|
$view['sql'] .= "from v_fifo as f, v_domains as d \n";
|
|
$view['sql'] .= "where fifo_music like '%shout%' \n";
|
|
$view['sql'] .= "and f.domain_uuid = d.domain_uuid \n";
|
|
$view['sql'] .= "union \n";
|
|
$view['sql'] .= "select \n";
|
|
$view['sql'] .= " 'destinations' as application, \n";
|
|
$view['sql'] .= " 'hold_music' as type, \n";
|
|
$view['sql'] .= " e.destination_uuid as uuid, \n";
|
|
$view['sql'] .= " e.domain_uuid, \n";
|
|
$view['sql'] .= " d.domain_name, \n";
|
|
$view['sql'] .= " '' as name, \n";
|
|
$view['sql'] .= " e.destination_number as number, \n";
|
|
$view['sql'] .= " e.destination_hold_music as music, \n";
|
|
$view['sql'] .= " e.destination_description as description \n";
|
|
$view['sql'] .= "from v_destinations as e, v_domains as d \n";
|
|
$view['sql'] .= "where destination_hold_music like '%shout%' \n";
|
|
$view['sql'] .= "and e.domain_uuid = d.domain_uuid \n";
|
|
$view['sql'] .= "union \n";
|
|
$view['sql'] .= "select \n";
|
|
$view['sql'] .= " 'destinations' as application, \n";
|
|
$view['sql'] .= " 'ringback' as type, \n";
|
|
$view['sql'] .= " e.destination_uuid as uuid, \n";
|
|
$view['sql'] .= " e.domain_uuid, \n";
|
|
$view['sql'] .= " d.domain_name, \n";
|
|
$view['sql'] .= " '' as name, \n";
|
|
$view['sql'] .= " e.destination_number as number, \n";
|
|
$view['sql'] .= " e.destination_ringback as music, \n";
|
|
$view['sql'] .= " e.destination_description as description \n";
|
|
$view['sql'] .= "from v_destinations as e, v_domains as d \n";
|
|
$view['sql'] .= "where destination_ringback like '%shout%' \n";
|
|
$view['sql'] .= "and e.domain_uuid = d.domain_uuid \n";
|
|
$view['sql'] .= "union \n";
|
|
$view['sql'] .= "select \n";
|
|
$view['sql'] .= " 'dialplans' as application, \n";
|
|
$view['sql'] .= " 'unknown' as type, \n";
|
|
$view['sql'] .= " dl.dialplan_uuid as uuid, \n";
|
|
$view['sql'] .= " dl.domain_uuid, \n";
|
|
$view['sql'] .= " d.domain_name, \n";
|
|
$view['sql'] .= " dl.dialplan_name as name, \n";
|
|
$view['sql'] .= " dl.dialplan_number as number, \n";
|
|
$view['sql'] .= " de.dialplan_detail_data as music, \n";
|
|
$view['sql'] .= " dl.dialplan_description as description \n";
|
|
$view['sql'] .= "from v_dialplan_details as de, v_domains as d, v_dialplans as dl \n";
|
|
$view['sql'] .= "where dialplan_detail_data like '%shout%' \n";
|
|
$view['sql'] .= "and de.domain_uuid = d.domain_uuid \n";
|
|
$view['sql'] .= "and dl.dialplan_uuid = de.dialplan_uuid \n";
|