}
print "</td>\n";
print "</tr>\n";
}
}
}
/* output followup navigation */
if ($ticket_type != "Staff Followup" && $ticket_type != "Client Followup" && $ticket_type != "Staff Comment") {
/* output followups */
print "<tr>\n";
print "<td align=\"left\" valign=\"top\"><strong>" . $AppUI->_('Followups') . "</strong></td>\n";
print "<td align=\"left\" valign=\"top\">\n";
/* grab followups */
$query = "SELECT ticket, type, timestamp, author FROM tickets WHERE parent = '{$ticket}' ORDER BY ticket " . $CONFIG["followup_order"];
$result = do_query($query);
if (number_rows($result)) {
/* print followups */
print "<table width=\"100%\" border=\"1\" cellspacing=\"5\" cellpadding=\"5\">\n";
while ($row = result2hash($result)) {
/* determine row color */
$color = @$number++ % 2 == 0 ? "#d3dce3" : "#dddddd";
/* start row */
print "<tr>\n";
/* do number/author */
print "<td bgcolor=\"{$color}\">\n";
print "<strong>{$number}</strong> : \n";
$row["author"] = preg_replace('/\\"/', '', $row["author"]);
$row["author"] = htmlspecialchars($row["author"]);
print $row["author"] . "\n";
print "</td>\n";
/* do type */
<?php
/* form query */
$select_fields = join(", ", $fields["columns"]);
$query = "SELECT {$select_fields} FROM {$dbprefix}tickets WHERE ";
if ($type == "My") {
$query .= "type = 'Open' AND (assignment = '{$AppUI->user_id}' OR assignment = '0') AND ";
} else {
if ($type != "All") {
$query .= "type = '{$type}' AND ";
}
}
$query .= "parent = '0' ORDER BY " . urlencode($column) . " {$direction} LIMIT {$offset}, {$limit}";
/* do query */
$result = do_query($query);
$parent_count = number_rows($result);
/* output tickets */
if ($parent_count) {
print "<tr>\n";
for ($loop = 0; $loop < count($fields["headings"]); $loop++) {
print "<th align=" . $fields["aligns"][$loop] . ">";
print "<a href=\"?m=ticketsmith&type={$type}";
print "&column=" . $fields["columns"][$loop];
if ($column != $fields["columns"][$loop]) {
$new_direction = "ASC";
} else {
if ($direction == "ASC") {
$new_direction = "DESC";
} else {
$new_direction == "ASC";
}
print "<p>\n";
print "<table width=\"95%\" border=\"1\" cellspacing=\"5\" cellpadding=\"5\">\n";
/* form search query */
$select_columns = join(", ", $fields["columns"]);
$search_pattern = "%" . escape_string($search_pattern) . "%";
$query = "SELECT {$select_columns} FROM tickets WHERE {$search_field} LIKE '{$search_pattern}'";
if ($search_depth == "Child") {
$query .= " AND parent != 0";
} elseif ($search_depth != "All") {
$query .= " AND type = '{$search_depth}'";
}
$query .= " ORDER BY {$sort_column} {$sort_direction}";
/* perform search */
$result = do_query($query);
/* display results */
$result_count = number_rows($result);
if ($result_count) {
print "<tr><td colspan=\"5\">" . $AppUI->_('There were') . " " . $result_count . " " . $AppUI->_('results') . " " . $AppUI->_('in the given search') . ".</td></tr>\n";
while ($row = result2hash($result)) {
print "<tr>";
for ($loop = 0; $loop < count($fields["columns"]); $loop++) {
print "<td align=\"" . $fields["aligns"][$loop] . "\">";
if ($loop == 4) {
print format_field($AppUI->_($row[$fields["columns"][$loop]]), $fields["types"][$loop]);
} else {
print format_field($row[$fields["columns"][$loop]], $fields["types"][$loop]);
}
print "</td>";
}
print "</tr>\n";
}
