function people_edit_skill_inventory($user_id) { global $PHP_SELF, $Language; $sql = "SELECT * FROM people_skill_inventory WHERE user_id='{$user_id}'"; $result = db_query($sql); $title_arr = array(); $title_arr[] = $Language->getText('people_utils', 'skill'); $title_arr[] = $Language->getText('people_utils', 'level'); $title_arr[] = $Language->getText('people_utils', 'experience'); $title_arr[] = $Language->getText('people_utils', 'action'); echo html_build_list_table_top($title_arr); $rows = db_numrows($result); if (!$result || $rows < 1) { echo ' <TR><TD COLSPAN="4"><H2>' . $Language->getText('people_utils', 'no_skill_inventory_setup_up') . '</H2></TD></TR>'; echo db_error(); } else { for ($i = 0; $i < $rows; $i++) { echo ' <FORM ACTION="' . $PHP_SELF . '" METHOD="POST"> <INPUT TYPE="HIDDEN" NAME="skill_inventory_id" VALUE="' . db_result($result, $i, 'skill_inventory_id') . '"> <TR class="' . util_get_alt_row_color($i) . '"> <TD><FONT SIZE="-1">' . people_get_skill_name(db_result($result, $i, 'skill_id')) . '</TD> <TD><FONT SIZE="-1">' . people_skill_level_box('skill_level_id', db_result($result, $i, 'skill_level_id')) . '</TD> <TD><FONT SIZE="-1">' . people_skill_year_box('skill_year_id', db_result($result, $i, 'skill_year_id')) . '</TD> <TD NOWRAP><FONT SIZE="-1"><INPUT TYPE="SUBMIT" NAME="update_skill_inventory" VALUE="' . $Language->getText('people_utils', 'update') . '"> <INPUT TYPE="SUBMIT" NAME="delete_from_skill_inventory" VALUE="' . $Language->getText('people_utils', 'delete') . '"></TD> </TR></FORM>'; } } //add a new skill $i++; //for row coloring echo ' <TR><TD COLSPAN="4"><H3>' . $Language->getText('people_utils', 'add_new_skill') . '</H3></TD></TR> <FORM ACTION="' . $PHP_SELF . '" METHOD="POST"> <TR class="' . util_get_alt_row_color($i) . '"> <TD><FONT SIZE="-1">' . people_skill_box('skill_id') . '</TD> <TD><FONT SIZE="-1">' . people_skill_level_box('skill_level_id') . '</TD> <TD><FONT SIZE="-1">' . people_skill_year_box('skill_year_id') . '</TD> <TD NOWRAP><FONT SIZE="-1"><INPUT TYPE="SUBMIT" NAME="add_to_skill_inventory" VALUE="' . $Language->getText('people_utils', 'add_skill') . '"></TD> </TR></FORM>'; echo ' </TABLE>'; }
function people_edit_job_inventory($job_id, $group_id) { global $PHP_SELF; $sql = "SELECT * FROM people_job_inventory WHERE job_id='{$job_id}'"; $result = db_query($sql); $title_arr = array(); $title_arr[] = 'Skill'; $title_arr[] = 'Level'; $title_arr[] = 'Experience'; $title_arr[] = 'Action'; echo html_build_list_table_top($title_arr); $rows = db_numrows($result); if (!$result || $rows < 1) { echo ' <TR><TD COLSPAN="4"><H2>No Skill Inventory Set Up</H2></TD></TR>'; echo db_error(); } else { for ($i = 0; $i < $rows; $i++) { echo ' <FORM ACTION="' . $PHP_SELF . '" METHOD="POST"> <INPUT TYPE="HIDDEN" NAME="job_inventory_id" VALUE="' . db_result($result, $i, 'job_inventory_id') . '"> <INPUT TYPE="HIDDEN" NAME="job_id" VALUE="' . db_result($result, $i, 'job_id') . '"> <INPUT TYPE="HIDDEN" NAME="group_id" VALUE="' . $group_id . '"> <TR BGCOLOR="' . html_get_alt_row_color($i) . '"> <TD><FONT SIZE="-1">' . people_get_skill_name(db_result($result, $i, 'skill_id')) . '</TD> <TD><FONT SIZE="-1">' . people_skill_level_box('skill_level_id', db_result($result, $i, 'skill_level_id')) . '</TD> <TD><FONT SIZE="-1">' . people_skill_year_box('skill_year_id', db_result($result, $i, 'skill_year_id')) . '</TD> <TD NOWRAP><FONT SIZE="-1"><INPUT TYPE="SUBMIT" NAME="update_job_inventory" VALUE="Update"> <INPUT TYPE="SUBMIT" NAME="delete_from_job_inventory" VALUE="Delete"></TD> </TR></FORM>'; } } //add a new skill $i++; //for row coloring echo ' <TR><TD COLSPAN="4"><H3>Add A New Skill</H3></TD></TR> <FORM ACTION="' . $PHP_SELF . '" METHOD="POST"> <INPUT TYPE="HIDDEN" NAME="job_id" VALUE="' . $job_id . '"> <INPUT TYPE="HIDDEN" NAME="group_id" VALUE="' . $group_id . '"> <TR BGCOLOR="' . html_get_alt_row_color($i) . '"> <TD><FONT SIZE="-1">' . people_skill_box('skill_id') . '</TD> <TD><FONT SIZE="-1">' . people_skill_level_box('skill_level_id') . '</TD> <TD><FONT SIZE="-1">' . people_skill_year_box('skill_year_id') . '</TD> <TD NOWRAP><FONT SIZE="-1"><INPUT TYPE="SUBMIT" NAME="add_to_job_inventory" VALUE="Add Skill"></TD> </TR></FORM>'; echo ' </TABLE>'; }
function people_edit_job_inventory($job_id, $group_id) { global $HTML; $sql = "SELECT * FROM people_job_inventory WHERE job_id='{$job_id}'"; $result = db_query($sql); $title_arr = array(); $title_arr[] = _('Skill') . utils_requiredField(); $title_arr[] = _('Level') . utils_requiredField(); $title_arr[] = _('Experience') . utils_requiredField(); $title_arr[] = _('Action'); echo $HTML->listTableTop($title_arr); $rows = db_numrows($result); if (!$result || $rows < 1) { echo ' <tr><td colspan="4"><h2>' . _('No Skill Inventory Set Up') . '</h2></td></tr>'; echo db_error(); } else { for ($i = 0; $i < $rows; $i++) { echo ' <tr ' . $HTML->boxGetAltRowStyle($i) . '> <form action="' . getStringFromServer('PHP_SELF') . '" method="post"> <input type="hidden" name="job_inventory_id" value="' . db_result($result, $i, 'job_inventory_id') . '" /> <input type="hidden" name="job_id" value="' . db_result($result, $i, 'job_id') . '" /> <input type="hidden" name="group_id" value="' . $group_id . '" /> <td width="25%">' . people_get_skill_name(db_result($result, $i, 'skill_id')) . '</td> <td width="25%">' . people_skill_level_box('skill_level_id', db_result($result, $i, 'skill_level_id')) . '</td> <td width="25%">' . people_skill_year_box('skill_year_id', db_result($result, $i, 'skill_year_id')) . '</td> <td width="25%" nowrap="nowrap"><input type="submit" name="update_job_inventory" value="' . _('Update') . '" /> <input type="submit" name="delete_from_job_inventory" value="' . _('Delete') . '" /></td> </form></tr>'; } } //add a new skill $i++; //for row coloring echo ' <tr><td colspan="4"><h3>' . _('Add a new skill') . '</h3></td></tr> <tr ' . $HTML->boxGetAltRowStyle($i) . '> <form action="' . getStringFromServer('PHP_SELF') . '" method="post"> <input type="hidden" name="job_id" value="' . $job_id . '" /> <input type="hidden" name="group_id" value="' . $group_id . '" /> <td width="25%">' . people_skill_box('skill_id') . '</td> <td width="25%">' . people_skill_level_box('skill_level_id') . '</td> <td width="25%">' . people_skill_year_box('skill_year_id') . '</td> <td width="25%" nowrap="nowrap"><input type="submit" name="add_to_job_inventory" value="' . _('Add Skill') . '" /></td> </form></tr>'; echo $HTML->listTableBottom(); }