function show_supportlist($result, $offset, $set = 'open') { global $sys_datefmt, $group_id; /* Accepts a result set from the support table. Should include all columns from the table, and it should be joined to USER to get the user_name. */ $url = "/support/?group_id={$group_id}&set={$set}&order="; $title_arr = array(); $title_arr[] = 'Request ID'; $title_arr[] = 'Summary'; $title_arr[] = 'Date'; $title_arr[] = 'Assigned To'; $title_arr[] = 'Submitted By'; $links_arr = array(); $links_arr[] = $url . 'support_id'; $links_arr[] = $url . 'summary'; $links_arr[] = $url . 'date'; $links_arr[] = $url . 'assigned_to_user'; $links_arr[] = $url . 'submitted_by'; $IS_SUPPORT_ADMIN = user_ismember($group_id, 'S2'); echo ' <FORM ACTION="' . $PHP_SELF . '" METHOD="POST"> <INPUT TYPE="HIDDEN" NAME="group_id" VALUE="' . $group_id . '"> <INPUT TYPE="HIDDEN" NAME="func" VALUE="postmodsupport">'; echo html_build_list_table_top($title_arr, $links_arr); $then = time() - 1296000; $rows = db_numrows($result); for ($i = 0; $i < $rows; $i++) { echo ' <TR BGCOLOR="' . get_priority_color(db_result($result, $i, 'priority')) . '">' . '<TD NOWRAP>' . ($IS_SUPPORT_ADMIN ? '<INPUT TYPE="CHECKBOX" NAME="support_id[]" VALUE="' . db_result($result, $i, 'support_id') . '"> ' : '') . sprintf("%06d", db_result($result, $i, 'support_id')) . '</TD>' . '<TD><A HREF="' . $PHP_SELF . '?func=detailsupport&support_id=' . db_result($result, $i, 'support_id') . '&group_id=' . db_result($result, $i, 'group_id') . '">' . db_result($result, $i, 'summary') . '</A></TD>' . '<TD>' . ($set != 'closed' && db_result($result, $i, 'date') < $then ? '<B>* ' : ' ') . date($sys_datefmt, db_result($result, $i, 'date')) . '</TD>' . '<TD>' . db_result($result, $i, 'assigned_to_user') . '</TD>' . '<TD>' . db_result($result, $i, 'submitted_by') . '</TD></TR>'; } /* Show extra rows for <-- Prev / Next --> */ echo ' <TR><TD COLSPAN="2">'; if ($offset > 0) { echo '<A HREF="' . $PHP_SELF . '?func=browse&group_id=' . $group_id . '&set=' . $set . '&offset=' . ($offset - 50) . '"><B><-- Previous 50</B></A>'; } else { echo ' '; } echo '</TD><TD> </TD><TD COLSPAN="2">'; if ($rows >= 50) { echo '<A HREF="' . $PHP_SELF . '?func=browse&group_id=' . $group_id . '&set=' . $set . '&offset=' . ($offset + 50) . '"><B>Next 50 --></B></A>'; } else { echo ' '; } echo '</TD></TR>'; /* Mass Update Code */ if ($IS_SUPPORT_ADMIN) { echo '<TR><TD COLSPAN="5"> <FONT COLOR="#FF0000"><B>Support Admin:</B></FONT> If you wish to apply changes to all support tickets selected above, use these controls to change their properties and click once on "Mass Update". <TABLE WIDTH="100%" BORDER="0"> <TR><TD><B>Category:</B><BR>' . support_category_box($group_id, 'support_category_id', 'xyz', 'No Change') . '</TD> <TD><B>Priority:</B><BR>'; echo build_priority_select_box('priority', '5', true); echo '</TD></TR> <TR><TD><B>Assigned To:</B><BR>' . support_technician_box($group_id, 'assigned_to', 'xyz', 'No Change') . '</TD> <TD><B>Status:</B><BR>' . support_status_box('support_status_id', 'xyz', 'No Change') . '</TD></TR> <TR><TD COLSPAN="2"><B>Canned Response:</B><BR>' . support_canned_response_box($group_id, 'canned_response') . '</TD></TR> <TR><TD COLSPAN="3" ALIGN="MIDDLE"><INPUT TYPE="SUBMIT" name="submit" VALUE="Mass Update"></TD></TR> </TABLE> </FORM> </TD></TR>'; } echo '</TABLE>'; }
*/ build_priority_select_box('priority', db_result($result, 0, 'priority')); ?> </TD></TR> <TR><TD COLSPAN="2"><B>Summary:</B><BR> <INPUT TYPE="TEXT" NAME="summary" SIZE="45" VALUE="<?php echo db_result($result, 0, 'summary'); ?> " MAXLENGTH="60"> </TD></TR> <TR><TD COLSPAN="2"> <B>Use Canned Response:</B><BR> <?php echo support_canned_response_box($group_id, 'canned_response'); echo ' <P> <A HREF="/support/admin/index.php?group_id=' . $group_id . '&create_canned=1">Define Custom Responses</A>'; ?> <P> <B>OR Attach A Comment:</B><BR> <TEXTAREA NAME="details" ROWS="7" COLS="60" WRAP="HARD"></TEXTAREA> <P> <?php echo show_support_details($support_id); ?> </TD></TR> <TR><TD COLSPAN="2"> <?php