Portions created by the Initial Developer are Copyright (C) 2008-2019 the Initial Developer. All Rights Reserved. Contributor(s): Mark J Crane */ //includes require_once "root.php"; require_once "resources/require.php"; require_once "resources/check_auth.php"; require_once "resources/paging.php"; //check permissions if (permission_exists('call_center_active_view')) { //access granted } else { echo "access denied"; exit; } //add multi-lingual support $language = new text; $text = $language->get(); //get the variables $order_by = $_GET["order_by"]; $order = $_GET["order"]; //add the search term $search = strtolower($_GET["search"]); if (strlen($search) > 0) { $sql_search = " ("; $sql_search .= "lower(queue_name) like :search "; $sql_search .= "or lower(queue_description) like :search "; $sql_search .= ") "; $parameters['search'] = '%'.$search.'%'; } //get the call center queue count $sql = "select count(*) from v_call_center_queues "; $sql .= "where domain_uuid = :domain_uuid "; if (isset($sql_search)) { $sql .= "and ".$sql_search; } $parameters['domain_uuid'] = $_SESSION['domain_uuid']; $database = new database; $num_rows = $database->select($sql, $parameters, 'column'); //paging the records $rows_per_page = ($_SESSION['domain']['paging']['numeric'] != '') ? $_SESSION['domain']['paging']['numeric'] : 50; $param = "&search=".$search; $page = is_numeric($_GET['page']) ? $_GET['page'] : 0; list($paging_controls, $rows_per_page) = paging($num_rows, $param, $rows_per_page); list($paging_controls_mini, $rows_per_page) = paging($num_rows, $param, $rows_per_page, true); $offset = $rows_per_page * $page; //get the call center queues $sql = str_replace('count(*)', '*', $sql); $sql .= order_by($order_by, $order); $sql .= limit_offset($rows_per_page, $offset); $database = new database; $call_center_queues = $database->select($sql, $parameters, 'all'); unset($sql, $parameters); //include header $document['title'] = $text['title-active_call_center']; require_once "resources/header.php"; //show the content echo "
\n"; echo "
".$text['header-active_call_center']." (".$num_rows.")
\n"; echo "
\n"; echo "\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo $text['description-active_call_center']."\n"; echo "

\n"; echo "\n"; echo "\n"; echo th_order_by('queue_name', $text['label-queue_name'], $order_by, $order); echo th_order_by('queue_extension', $text['label-extension'], $order_by, $order); echo th_order_by('queue_strategy', $text['label-strategy'], $order_by, $order); //echo th_order_by('queue_moh_sound', $text['label-music_on_hold'], $order_by, $order); //echo th_order_by('queue_record_template', $text['label-record_template'], $order_by, $order); //echo th_order_by('queue_time_base_score', $text['label-time_base_score'], $order_by, $order); //echo th_order_by('queue_max_wait_time', $text['label-max_wait_time'], $order_by, $order); //echo th_order_by('queue_max_wait_time_with_no_agent', $text['label-max_wait_time_with_no_agent'], $order_by, $order); //echo th_order_by('queue_tier_rules_apply', $text['label-tier_rules_apply'], $order_by, $order); //echo th_order_by('queue_tier_rule_wait_second', $text['label-tier_rule_wait_second'], $order_by, $order); //echo th_order_by('queue_tier_rule_no_agent_no_wait', $text['label-tier_rule_no_agent_no_wait'], $order_by, $order); //echo th_order_by('queue_discard_abandoned_after', $text['label-discard_abandoned_after'], $order_by, $order); //echo th_order_by('queue_abandoned_resume_allowed', $text['label-abandoned_resume_allowed'], $order_by, $order); //echo th_order_by('queue_tier_rule_wait_multiply_level', $text['label-tier_rule_wait_multiply_level'], $order_by, $order); echo th_order_by('queue_description', $text['label-description'], $order_by, $order); echo "\n"; if (is_array($call_center_queues)) { $x = 0; foreach($call_center_queues as $row) { $list_row_url = PROJECT_PATH."/app/call_center_active/call_center_active.php?queue_name=".escape($row['call_center_queue_uuid'])."&name=".urlencode(escape($row['queue_name'])); echo "\n"; echo " \n"; echo " \n"; echo " \n"; //echo " \n"; //echo " \n"; //echo " \n"; //echo " \n"; //echo " \n"; //echo " \n"; //echo " \n"; //echo " \n"; //echo " \n"; //echo " \n"; //echo " \n"; echo " \n"; echo "\n"; $x++; } unset($call_center_queues); } echo "
".escape($row['queue_name'])."".escape($row['queue_extension'])."".escape($row['queue_strategy'])."".escape($row[queue_moh_sound])."".escape($row[queue_record_template])."".escape($row[queue_time_base_score])."".escape($row[queue_max_wait_time])."".escape($row[queue_max_wait_time_with_no_agent])."".escape($row[queue_tier_rules_apply])."".escape($row[queue_tier_rule_wait_second])."".escape($row[queue_tier_rule_no_agent_no_wait])."".escape($row[queue_discard_abandoned_after])."".escape($row[queue_abandoned_resume_allowed])."".escape($row[queue_tier_rule_wait_multiply_level])."".escape($row['queue_description'])."
\n"; echo "
\n"; echo "
".$paging_controls."
\n"; //show the footer require_once "resources/footer.php"; ?>