$order = 'port'; //Order by hostname break; case 1: $order = 'service'; //Order by IP break; default: $order = 'port'; } $torder = strtoupper($torder) == 'ASC' ? 'ASC' : 'DESC'; try { $db = new Ossim_db(); $conn = $db->connect(TRUE); $params = array('backlog_id' => $backlog_id, 'ip' => $asset_ip, 'source' => $source, 'limit' => "{$from}, {$maxrows}", 'order_by' => "{$order} {$torder}"); list($port_total, $port_list) = Alarm::get_alarm_port_by_ip($conn, $params); } catch (Exception $e) { $db->close(); Util::response_bad_request($e->getMessage()); } $data = array(); foreach ($port_list as $p_data) { $service = empty($p_data['service']) ? '-' : $p_data['service']; $data[] = array($p_data['port'], $service); } $response['sEcho'] = $sec; $response['iTotalRecords'] = $port_total; $response['iTotalDisplayRecords'] = $port_total; $response['aaData'] = $data; echo json_encode($response); $db->close();