4 * Skills support functions.
6 * Copyright 2002 (c) Silicon and Software Systems (S3)
12 function displayUserSkills($user_id, $allowEdit) {
14 $sql = "SELECT * FROM skills_data_types ORDER BY type_id ASC";
15 $result=db_query($sql);
16 $rows = db_numrows($result);
18 /* obtain the types keywords... */
19 for($i = 0; $i < $rows; $i++) {
20 $typesDescs[$i] = db_result($result, $i, 'type_name');
24 $sql="SELECT * FROM skills_data WHERE user_id='$user_id' ORDER BY finish DESC, start ASC, skills_data_id DESC";
25 $result=db_query($sql);
26 $rows = db_numrows($result);
27 if (!$result || $rows < 1) {
29 $feedback = 'No skills listed ';
30 echo '<tr><td>This user has not entered any skills.</td></tr>';
33 echo '<tr class="tableheading">'; /* headings for the columns */
35 echo '<td>'._('Edit').'</td>'.
36 '<td>'._('Delete').'</td>';
38 echo '<td>'._('Type').'</td>'.
39 '<td>'._('Title').'</td>'.
40 '<td>'._('Start Date').'</td>'.
41 '<td>'._('End Date').'</td>'.
42 '<td>'._('Keywords').'</td>'.
45 for ($i = 0; $i < $rows; $i++) /* for each entry in the database */ {
46 /* set up some variables to make things easier.... */
47 $typeID = db_result($result, $i, 'type');
48 $start = db_result($result, $i, 'start');
49 $finish = db_result($result, $i, 'finish');
51 $startY = substr($start, 0, 4);
52 $startM = substr($start, 4, 2);
54 $finishY = substr($finish, 0, 4);
55 $finishM = substr($finish, 4, 2);
57 if($startM > 0 && $startM < 13) {
58 $startStr = date ("M Y", mktime(0,0,0,$startM,1,$startY));
62 if (!(isset($finishtM))){
65 if($finishM > 0 && $finishtM < 13) {
66 $finishStr = date ("M Y", mktime(0,0,0,$finishM,1,$finishY));
68 $finishStr = $finishY;
71 /* now print out the row, formatted nicely */
72 echo '<tr '. $HTML->boxGetAltRowStyle($i+1) . '>';
74 echo '<td><input type="checkbox" name="skill_edit[]" value="'.db_result($result, $i, 'skills_data_id').'" /></td>';
75 echo '<td><input type="checkbox" name="skill_delete[]" value="'.db_result($result, $i, 'skills_data_id').'" /></td>';
77 if($typesDescs[$typeID]) {
78 echo '<td>'.$typesDescs[$typeID]."</td>\n";
80 echo '<td>'.$typeID ."</td>\n";
83 echo '<td>'.db_result($result, $i, 'title') ."</td>\n";
84 echo '<td>'.$startStr."</td>\n";
85 echo '<td>'.$finishStr."</td>\n";
86 echo '<td>'.db_result($result, $i, 'keywords') ."</td>\n";
93 echo '<td><input type="submit" name="MultiEdit" value="'._('Edit').'" /></td>';
94 echo '<td><input type="submit" name="MultiDelete" value="'._('Delete').'" /></td>';
101 function handle_multi_edit($skill_ids) {
103 $numSkills = count($skill_ids);
104 $SQL = "select * from skills_data where skills_data_id in(".$skill_ids[0];
105 for($i = 1; $i < $numSkills; $i++) {
106 $SQL .= ", ".$skill_ids[$i];
110 $result=db_query($SQL);
111 $rows = db_numrows($result);
112 if (!$result || $rows < 1) {
115 $sql="SELECT * FROM skills_data_types WHERE type_id > 0";
116 $skills=db_query($sql);
117 if (!$skills || db_numrows($skills) < 1) {
119 $feedback .= _('User fetch FAILED');
120 echo '<h2>'._('No Such User').'<h2>';
123 $yearArray = array();
124 for($years = date("Y"); $years >= 1980; $years--) {
125 array_push($yearArray,$years);
128 $monthArray = array();
129 $monthArrayVals = array();
130 for($i = 1; $i <= 12; $i++) {
131 array_push($monthArrayVals,($i<10?"0".$i:$i));
132 array_push($monthArray,date("M", mktime(0,0,0,$i,1,1980)));
137 for($i = 0; $i < $rows; $i++) {
138 $start = db_result($result, $i, 'start');
139 $finish = db_result($result, $i, 'finish');
141 $startY = substr($start, 0, 4);
142 $startM = substr($start, 4, 2);
144 $finishY = substr($finish, 0, 4);
145 $finishM = substr($finish, 4, 2);
147 echo '<table border="0">'.
148 '<tr '.$HTML->boxGetAltRowStyle($i+1).'>'.
149 '<td><h3>'.db_result($result, $i,'title').'</h3></td></tr>'.
151 '<table border="0" >'.
152 '<tr class="tableheading">'.
153 '<td >'._('Type').'</td>'.
154 '<td >'._('Start Date').'</td>'.
155 '<td >'._('End Date').'</td>'.
157 echo '<tr '.$HTML->boxGetAltRowStyle($i+1).'>'.
158 '<td>'.html_build_select_box($skills, 'type[]',db_result($result, $i,'type') , false, '').'</td>'.
159 '<td>'.html_build_select_box_from_arrays($monthArrayVals,$monthArray, 'startM[]', $startM, false, '').
160 html_build_select_box_from_arrays($yearArray,$yearArray, 'startY[]', $startY, false, '').'</td>'.
161 '<td>'.html_build_select_box_from_arrays($monthArrayVals,$monthArray, 'endM[]', $finishM, false, '').
162 html_build_select_box_from_arrays($yearArray,$yearArray, 'endY[]', $finishY, false, '').'</td>'.
167 '<tr '.$HTML->boxGetAltRowStyle($i+1).'><td>'.
168 '<table border="0">'.
169 '<tr class="tableheading">'.
170 '<td>'._('Title (max 100 characters)').'</td>'.
173 '<td><input type="hidden" name="skill_edit[]" value="'.db_result($result, $i,'skills_data_id').'" />'.
174 '<input type="text" name="title[]" size="100" value="'.db_result($result, $i,'title').'" /></td>'.
177 '<td class="tableheading">'._('Keywords (max 255 characters)').'</td>'.
180 '<td><textarea name="keywords[]" rows="3" cols="85" wrap="soft">'.db_result($result, $i,'keywords').'</textarea></td>'.
185 echo '</table><br />';
192 // c-file-style: "bsd"