$res_tech = pm_data_get_technicians($group_id); $tech_id_arr = util_result_column_to_array($res_tech, 0); $tech_id_arr[] = '0'; //this will be the 'any' row $tech_name_arr = util_result_column_to_array($res_tech, 1); $tech_name_arr[] = 'Any'; $tech_box = html_build_select_box_from_arrays($tech_id_arr, $tech_name_arr, '_assigned_to', $_assigned_to, true, 'Unassigned'); /* Show the new pop-up boxes to select assigned to and/or status */ echo '<H2>Browse Tasks by</H2> <TABLE BORDER="0" CELLPADDING="0" CELLSPACING="6"><FORM ACTION="' . $PHP_SELF . '" METHOD="GET"> <INPUT TYPE="HIDDEN" NAME="group_id" VALUE="' . $group_id . '"> <INPUT TYPE="HIDDEN" NAME="set" VALUE="custom"> <TR><TD><b>Subproject:</b></TD><TD><b>Assigned User:</b></TD><TD><b>Status:</b></TD></TR> <TR><TD>' . pm_show_subprojects_box('group_project_id', $group_id, $group_project_id) . '</TD>' . '<TD><FONT SIZE="-1">' . $tech_box . '</TD><TD><FONT SIZE="-1">' . pm_status_box('_status', $_status, 'Any') . '</TD>' . '<TD><FONT SIZE="-1"><INPUT TYPE="SUBMIT" NAME="SUBMIT" VALUE="Browse"></TD></TR></FORM></TABLE>'; if (db_numrows($result) < 1) { echo ' <H1>No Matching Tasks found</H1> <P> <B>Add tasks using the link above</B>'; echo db_error(); } else { //create a new $set string to be used for next/prev button if ($set == 'custom') { $set .= '&_assigned_to=' . $_assigned_to . '&_status=' . $_status; } /* Now display the tasks in a table with priority colors */ echo '
"> <INPUT TYPE="HIDDEN" NAME="group_project_id" VALUE="<?php echo $group_project_id; ?> "> <INPUT TYPE="HIDDEN" NAME="project_task_id" VALUE="<?php echo $project_task_id; ?> "> <TABLE BORDER="0" WIDTH="100%"> <TR> <TD><B>Subproject:</B> <BR> <?php echo pm_show_subprojects_box('new_group_project_id', $group_id, $group_project_id); ?> </TD> <TD><FONT SIZE="-1"> <INPUT TYPE="submit" value="Submit Changes" name="submit"></FONT> </TD> </TR> <TR> <TD><B>Percent Complete:</B> <BR> <?php echo pm_show_percent_complete_box('percent_complete', db_result($result, 0, 'percent_complete')); ?> </TD>