$value) { switch ($var) { case "policy_name": case "object_name": $sql .= generate_query_values_and($value, $var); break; case "group": case "group_id": $values = get_group_entities($value); $sql .= generate_query_values_and($values, 'cbqos_id'); break; case 'device_group_id': case 'device_group': $values = get_group_entities($value, 'device'); $sql .= generate_query_values_and($values, 'ports_cbqos.device_id'); break; case "device": case "device_id": $sql .= generate_query_values_and($value, 'ports_cbqos.device_id'); break; } } switch ($vars['sort_order']) { case 'desc': $sort_order = 'DESC'; $sort_neg = 'ASC'; break; case 'reset': unset($vars['sort'], $vars['sort_order']); // no break here default: $sort_order = 'ASC'; $sort_neg = 'DESC'; } switch ($vars['sort']) { case 'policy_name': case 'object_name': case 'PrePolicyByte_rate': case 'PostPolicyByte_rate': case 'DropByte_rate': $sql .= ' ORDER BY ' . $vars['sort'] . ' ' . $sort_order; break; default: $sql .= ' ORDER BY `hostname` ' . $sort_order . ', `port_label_short` ' . $sort_order; } return $sql; } function print_cbqos_table_header($vars) { echo(''); $cols[] = ['', 'class="state-marker"']; if (!isset($vars['device_id'])) { $cols['hostname'] = ['Device', 'style="width: 200px;"']; } if (!isset($vars['device_id'])) { $cols['port_label'] = ['Port', 'style="width: 200px;"']; } $cols['policy_name'] = ['Policy', 'style="width: 150px;"']; $cols['object_name'] = ['Object', 'style="width: 200px;"']; $cols['PrePolicyByte_rate'] = ['Traffic']; $cols['DropByte_rate'] = ['Dropped']; $cols[] = []; echo get_table_header($cols, $vars); echo '' . PHP_EOL; } function print_cbqos_table($vars) { global $config; $sql = build_cbqos_query($vars); $entries = dbFetchRows($sql); if (!safe_empty($entries)) { echo generate_box_open(); print_cbqos_table_header($vars); foreach ($entries as $cbqos_id => $entry) { $perc_drop = float_div($entry['DropByte_rate'], $entry['PrePolicyByte_rate']) * 100; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; if (get_var_true($vars['graphs'])) { $vars['graph'] = "graph"; } if ($vars['graph']) { $graph_array = []; $graph_title = $entry['oid_descr']; $graph_array['type'] = "cbqos_" . $vars['graph']; $graph_array['id'] = $entry['cbqos_id']; echo ''; echo ' '; echo ' '; echo ''; } } echo '

	' . generate_device_link($entry) . '	' . generate_port_link($entry) . '	' . $entry['policy_name'] . '	' . $entry['object_name'] . '	' . format_number($entry['PrePolicyByte_rate']) . 'bps / ' . format_number($entry['PostPolicyByte_rate']) . 'bps	' . format_number($entry['DropByte_rate']) . 'bps (' . $perc_drop . '%)
	'; print_graph_row($graph_array); echo '

' . PHP_EOL; echo generate_box_close(); } } // EOF