Commit | Line | Data |
---|---|---|
b325120a | 1 | <?php |
e673ee24 DO |
2 | /* |
3 | * | |
4 | * This file is a library of computational functions for RackTables. | |
5 | * | |
6 | */ | |
7 | ||
8 | $loclist[0] = 'front'; | |
9 | $loclist[1] = 'interior'; | |
10 | $loclist[2] = 'rear'; | |
11 | $loclist['front'] = 0; | |
12 | $loclist['interior'] = 1; | |
13 | $loclist['rear'] = 2; | |
14 | $template[0] = array (TRUE, TRUE, TRUE); | |
15 | $template[1] = array (TRUE, TRUE, FALSE); | |
16 | $template[2] = array (FALSE, TRUE, TRUE); | |
17 | $template[3] = array (TRUE, FALSE, FALSE); | |
18 | $template[4] = array (FALSE, TRUE, FALSE); | |
19 | $template[5] = array (FALSE, FALSE, TRUE); | |
20 | $templateWidth[0] = 3; | |
21 | $templateWidth[1] = 2; | |
22 | $templateWidth[2] = 2; | |
23 | $templateWidth[3] = 1; | |
24 | $templateWidth[4] = 1; | |
25 | $templateWidth[5] = 1; | |
26 | ||
27 | // Objects of some types should be explicitly shown as | |
28 | // anonymous (labelless). This function is a single place where the | |
29 | // decision about displayed name is made. | |
30 | function displayedName ($objectData) | |
31 | { | |
32 | if ($objectData['name'] != '') | |
33 | return $objectData['name']; | |
9c0b0016 | 34 | elseif (in_array ($objectData['objtype_id'], explode (',', getConfigVar ('NAMEFUL_OBJTYPES')))) |
a0ec6295 | 35 | return "ANONYMOUS " . $objectData['objtype_name']; |
e673ee24 | 36 | else |
a0ec6295 | 37 | return "[${objectData['objtype_name']}]"; |
e673ee24 DO |
38 | } |
39 | ||
40 | // This function finds height of solid rectangle of atoms, which are all | |
41 | // assigned to the same object. Rectangle base is defined by specified | |
42 | // template. | |
43 | function rectHeight ($rackData, $startRow, $template_idx) | |
44 | { | |
45 | $height = 0; | |
46 | // The first met object_id is used to match all the folowing IDs. | |
47 | $object_id = 0; | |
48 | global $template; | |
49 | do | |
50 | { | |
51 | for ($locidx = 0; $locidx < 3; $locidx++) | |
52 | { | |
53 | // At least one value in template is TRUE, but the following block | |
54 | // can meet 'skipped' atoms. Let's ensure we have something after processing | |
55 | // the first row. | |
56 | if ($template[$template_idx][$locidx]) | |
57 | { | |
58 | if (isset ($rackData[$startRow - $height][$locidx]['skipped'])) | |
59 | break 2; | |
93e02204 DO |
60 | if (isset ($rackData[$startRow - $height][$locidx]['rowspan'])) |
61 | break 2; | |
62 | if (isset ($rackData[$startRow - $height][$locidx]['colspan'])) | |
63 | break 2; | |
e673ee24 DO |
64 | if ($rackData[$startRow - $height][$locidx]['state'] != 'T') |
65 | break 2; | |
66 | if ($object_id == 0) | |
67 | $object_id = $rackData[$startRow - $height][$locidx]['object_id']; | |
68 | if ($object_id != $rackData[$startRow - $height][$locidx]['object_id']) | |
69 | break 2; | |
70 | } | |
71 | } | |
72 | // If the first row can't offer anything, bail out. | |
73 | if ($height == 0 and $object_id == 0) | |
74 | break; | |
75 | $height++; | |
76 | } | |
77 | while ($startRow - $height > 0); | |
93e02204 DO |
78 | # echo "for startRow==${startRow} and template==(" . ($template[$template_idx][0] ? 'T' : 'F'); |
79 | # echo ', ' . ($template[$template_idx][1] ? 'T' : 'F') . ', ' . ($template[$template_idx][2] ? 'T' : 'F'); | |
80 | # echo ") height==${height}<br>\n"; | |
e673ee24 DO |
81 | return $height; |
82 | } | |
83 | ||
84 | // This function marks atoms to be avoided by rectHeight() and assigns rowspan/colspan | |
85 | // attributes. | |
86 | function markSpan (&$rackData, $startRow, $maxheight, $template_idx) | |
87 | { | |
88 | global $template, $templateWidth; | |
89 | $colspan = 0; | |
90 | for ($height = 0; $height < $maxheight; $height++) | |
91 | { | |
92 | for ($locidx = 0; $locidx < 3; $locidx++) | |
93 | { | |
94 | if ($template[$template_idx][$locidx]) | |
95 | { | |
96 | // Add colspan/rowspan to the first row met and mark the following ones to skip. | |
93e02204 DO |
97 | // Explicitly show even single-cell spanned atoms, because rectHeight() |
98 | // is expeciting this data for correct calculation. | |
e673ee24 DO |
99 | if ($colspan != 0) |
100 | $rackData[$startRow - $height][$locidx]['skipped'] = TRUE; | |
101 | else | |
102 | { | |
103 | $colspan = $templateWidth[$template_idx]; | |
93e02204 | 104 | if ($colspan >= 1) |
e673ee24 | 105 | $rackData[$startRow - $height][$locidx]['colspan'] = $colspan; |
93e02204 | 106 | if ($maxheight >= 1) |
e673ee24 DO |
107 | $rackData[$startRow - $height][$locidx]['rowspan'] = $maxheight; |
108 | } | |
109 | } | |
110 | } | |
111 | } | |
112 | return; | |
113 | } | |
114 | ||
93e02204 DO |
115 | // This function sets rowspan/solspan/skipped atom attributes for renderRack() |
116 | // What we actually have to do is to find _all_ possible rectangles for each unit | |
117 | // and then select the widest of those with the maximal square. | |
e673ee24 DO |
118 | function markAllSpans (&$rackData = NULL) |
119 | { | |
120 | if ($rackData == NULL) | |
121 | { | |
61e269b5 | 122 | showError ('Invalid rackData', __FUNCTION__); |
e673ee24 DO |
123 | return; |
124 | } | |
125 | for ($i = $rackData['height']; $i > 0; $i--) | |
93e02204 DO |
126 | while (markBestSpan ($rackData, $i)); |
127 | } | |
128 | ||
129 | // Calculate height of 6 possible span templates (array is presorted by width | |
130 | // descending) and mark the best (if any). | |
131 | function markBestSpan (&$rackData, $i) | |
132 | { | |
133 | global $template, $templateWidth; | |
134 | for ($j = 0; $j < 6; $j++) | |
e673ee24 | 135 | { |
93e02204 DO |
136 | $height[$j] = rectHeight ($rackData, $i, $j); |
137 | $square[$j] = $height[$j] * $templateWidth[$j]; | |
138 | } | |
139 | // find the widest rectangle of those with maximal height | |
140 | $maxsquare = max ($square); | |
141 | if (!$maxsquare) | |
142 | return FALSE; | |
143 | $best_template_index = 0; | |
144 | for ($j = 0; $j < 6; $j++) | |
145 | if ($square[$j] == $maxsquare) | |
e673ee24 | 146 | { |
93e02204 DO |
147 | $best_template_index = $j; |
148 | $bestheight = $height[$j]; | |
149 | break; | |
e673ee24 | 150 | } |
93e02204 DO |
151 | // distribute span marks |
152 | markSpan ($rackData, $i, $bestheight, $best_template_index); | |
153 | return TRUE; | |
e673ee24 DO |
154 | } |
155 | ||
156 | function delRow ($row_id = 0) | |
157 | { | |
158 | if ($row_id == 0) | |
159 | { | |
61e269b5 | 160 | showError ('Not all required args are present.', __FUNCTION__); |
e673ee24 DO |
161 | return; |
162 | } | |
163 | if (!isset ($_REQUEST['confirmed']) || $_REQUEST['confirmed'] != 'true') | |
164 | { | |
165 | echo "Press <a href='?op=del_row&row_id=${row_id}&confirmed=true'>here</a> to confirm rack row deletion."; | |
166 | return; | |
167 | } | |
168 | global $dbxlink; | |
169 | echo 'Deleting rack row information: '; | |
170 | $result = $dbxlink->query ("update RackRow set deleted = 'yes' where id=${row_id} limit 1"); | |
171 | if ($result->rowCount() != 1) | |
172 | { | |
61e269b5 | 173 | showError ('Marked ' . $result.rowCount() . ' rows as deleted, but expected 1', __FUNCTION__); |
e673ee24 DO |
174 | return; |
175 | } | |
176 | echo 'OK<br>'; | |
177 | recordHistory ('RackRow', "id = ${row_id}"); | |
178 | echo "Information was deleted. You may return to <a href='?op=list_rows&editmode=on'>rack row list</a>."; | |
179 | } | |
180 | ||
181 | function delRack ($rack_id = 0) | |
182 | { | |
183 | if ($rack_id == 0) | |
184 | { | |
61e269b5 | 185 | showError ('Not all required args are present.', __FUNCTION__); |
e673ee24 DO |
186 | return; |
187 | } | |
188 | if (!isset ($_REQUEST['confirmed']) || $_REQUEST['confirmed'] != 'true') | |
189 | { | |
190 | echo "Press <a href='?op=del_rack&rack_id=${rack_id}&confirmed=true'>here</a> to confirm rack deletion."; | |
191 | return; | |
192 | } | |
193 | global $dbxlink; | |
194 | echo 'Deleting rack information: '; | |
195 | $result = $dbxlink->query ("update Rack set deleted = 'yes' where id=${rack_id} limit 1"); | |
196 | if ($result->rowCount() != 1) | |
197 | { | |
61e269b5 | 198 | showError ('Marked ' . $result.rowCount() . ' rows as deleted, but expected 1', __FUNCTION__); |
e673ee24 DO |
199 | return; |
200 | } | |
201 | echo 'OK<br>'; | |
202 | recordHistory ('Rack', "id = ${rack_id}"); | |
203 | echo "Information was deleted. You may return to <a href='?op=list_racks&editmode=on'>rack list</a>."; | |
204 | } | |
205 | ||
206 | function delObject ($object_id = 0) | |
207 | { | |
208 | if ($object_id == 0) | |
209 | { | |
61e269b5 | 210 | showError ('Not all required args are present.', __FUNCTION__); |
e673ee24 DO |
211 | return; |
212 | } | |
213 | if (!isset ($_REQUEST['confirmed']) || $_REQUEST['confirmed'] != 'true') | |
214 | { | |
215 | echo "Press <a href='?op=del_object&object_id=${object_id}&confirmed=true'>here</a> to confirm object deletion."; | |
216 | return; | |
217 | } | |
218 | global $dbxlink; | |
219 | echo 'Deleting object information: '; | |
220 | $result = $dbxlink->query ("update RackObject set deleted = 'yes' where id=${object_id} limit 1"); | |
221 | if ($result->rowCount() != 1) | |
222 | { | |
61e269b5 | 223 | showError ('Marked ' . $result.rowCount() . ' rows as deleted, but expected 1', __FUNCTION__); |
e673ee24 DO |
224 | return; |
225 | } | |
226 | echo 'OK<br>'; | |
227 | recordHistory ('RackObject', "id = ${object_id}"); | |
228 | echo "Information was deleted. You may return to <a href='?op=list_objects&editmode=on'>object list</a>."; | |
229 | } | |
230 | ||
231 | // We can mount 'F' atoms and unmount our own 'T' atoms. | |
232 | function applyObjectMountMask (&$rackData, $object_id) | |
233 | { | |
234 | for ($unit_no = $rackData['height']; $unit_no > 0; $unit_no--) | |
235 | for ($locidx = 0; $locidx < 3; $locidx++) | |
236 | switch ($rackData[$unit_no][$locidx]['state']) | |
237 | { | |
238 | case 'F': | |
239 | $rackData[$unit_no][$locidx]['enabled'] = TRUE; | |
240 | break; | |
241 | case 'T': | |
242 | $rackData[$unit_no][$locidx]['enabled'] = ($rackData[$unit_no][$locidx]['object_id'] == $object_id); | |
243 | break; | |
244 | default: | |
245 | $rackData[$unit_no][$locidx]['enabled'] = FALSE; | |
246 | } | |
247 | } | |
248 | ||
249 | // Design change means transition between 'F' and 'A' and back. | |
250 | function applyRackDesignMask (&$rackData) | |
251 | { | |
252 | for ($unit_no = $rackData['height']; $unit_no > 0; $unit_no--) | |
253 | for ($locidx = 0; $locidx < 3; $locidx++) | |
254 | switch ($rackData[$unit_no][$locidx]['state']) | |
255 | { | |
256 | case 'F': | |
257 | case 'A': | |
258 | $rackData[$unit_no][$locidx]['enabled'] = TRUE; | |
259 | break; | |
260 | default: | |
261 | $rackData[$unit_no][$locidx]['enabled'] = FALSE; | |
262 | } | |
263 | } | |
264 | ||
265 | // The same for 'F' and 'U'. | |
266 | function applyRackProblemMask (&$rackData) | |
267 | { | |
268 | for ($unit_no = $rackData['height']; $unit_no > 0; $unit_no--) | |
269 | for ($locidx = 0; $locidx < 3; $locidx++) | |
270 | switch ($rackData[$unit_no][$locidx]['state']) | |
271 | { | |
272 | case 'F': | |
273 | case 'U': | |
274 | $rackData[$unit_no][$locidx]['enabled'] = TRUE; | |
275 | break; | |
276 | default: | |
277 | $rackData[$unit_no][$locidx]['enabled'] = FALSE; | |
278 | } | |
279 | } | |
280 | ||
281 | // This mask should allow toggling 'T' and 'W' on object's rackspace. | |
282 | function applyObjectProblemMask (&$rackData) | |
283 | { | |
284 | for ($unit_no = $rackData['height']; $unit_no > 0; $unit_no--) | |
285 | for ($locidx = 0; $locidx < 3; $locidx++) | |
286 | switch ($rackData[$unit_no][$locidx]['state']) | |
287 | { | |
288 | case 'T': | |
289 | case 'W': | |
290 | $rackData[$unit_no][$locidx]['enabled'] = ($rackData[$unit_no][$locidx]['object_id'] == $object_id); | |
291 | break; | |
292 | default: | |
293 | $rackData[$unit_no][$locidx]['enabled'] = FALSE; | |
294 | } | |
295 | } | |
296 | ||
297 | // This function highlights specified object (and removes previous highlight). | |
298 | function highlightObject (&$rackData, $object_id) | |
299 | { | |
300 | for ($unit_no = $rackData['height']; $unit_no > 0; $unit_no--) | |
301 | for ($locidx = 0; $locidx < 3; $locidx++) | |
302 | if | |
303 | ( | |
304 | $rackData[$unit_no][$locidx]['state'] == 'T' and | |
305 | $rackData[$unit_no][$locidx]['object_id'] == $object_id | |
306 | ) | |
307 | $rackData[$unit_no][$locidx]['hl'] = 'h'; | |
308 | else | |
309 | unset ($rackData[$unit_no][$locidx]['hl']); | |
310 | } | |
311 | ||
312 | // This function marks atoms to selected or not depending on their current state. | |
313 | function markupAtomGrid (&$data, $checked_state) | |
314 | { | |
315 | for ($unit_no = $data['height']; $unit_no > 0; $unit_no--) | |
316 | for ($locidx = 0; $locidx < 3; $locidx++) | |
317 | { | |
318 | if (!($data[$unit_no][$locidx]['enabled'] === TRUE)) | |
319 | continue; | |
320 | if ($data[$unit_no][$locidx]['state'] == $checked_state) | |
321 | $data[$unit_no][$locidx]['checked'] = ' checked'; | |
322 | else | |
323 | $data[$unit_no][$locidx]['checked'] = ''; | |
324 | } | |
325 | } | |
326 | ||
327 | // This function is almost a clone of processGridForm(), but doesn't save anything to database | |
328 | // Return value is the changed rack data. | |
329 | // Here we assume that correct filter has already been applied, so we just | |
330 | // set or unset checkbox inputs w/o changing atom state. | |
331 | function mergeGridFormToRack (&$rackData) | |
332 | { | |
333 | $rack_id = $rackData['id']; | |
334 | for ($unit_no = $rackData['height']; $unit_no > 0; $unit_no--) | |
335 | for ($locidx = 0; $locidx < 3; $locidx++) | |
336 | { | |
337 | if ($rackData[$unit_no][$locidx]['enabled'] != TRUE) | |
338 | continue; | |
339 | $inputname = "atom_${rack_id}_${unit_no}_${locidx}"; | |
340 | if (isset ($_REQUEST[$inputname]) and $_REQUEST[$inputname] == 'on') | |
341 | $rackData[$unit_no][$locidx]['checked'] = ' checked'; | |
342 | else | |
343 | $rackData[$unit_no][$locidx]['checked'] = ''; | |
344 | } | |
345 | } | |
346 | ||
347 | function binMaskFromDec ($maskL) | |
348 | { | |
349 | $binmask=0; | |
350 | for ($i=0; $i<$maskL; $i++) | |
351 | { | |
352 | $binmask*=2; | |
353 | $binmask+=1; | |
354 | } | |
355 | for ($i=$maskL; $i<32; $i++) | |
356 | { | |
357 | $binmask*=2; | |
358 | } | |
359 | return $binmask; | |
360 | } | |
361 | ||
362 | function binInvMaskFromDec ($maskL) | |
363 | { | |
364 | $binmask=0; | |
365 | for ($i=0; $i<$maskL; $i++) | |
366 | { | |
367 | $binmask*=2; | |
368 | } | |
369 | for ($i=$maskL; $i<32; $i++) | |
370 | { | |
371 | $binmask*=2; | |
372 | $binmask+=1; | |
373 | } | |
374 | return $binmask; | |
375 | } | |
376 | ||
2dee289e | 377 | function addRange ($range='', $name='', $is_bcast = FALSE) |
e673ee24 | 378 | { |
2a201216 DY |
379 | // $range is in x.x.x.x/x format, split into ip/mask vars |
380 | $rangeArray = explode('/', $range); | |
6e8868cc DO |
381 | if (count ($rangeArray) != 2) |
382 | return "Invalid IP subnet '${range}'"; | |
2a201216 DY |
383 | $ip = $rangeArray[0]; |
384 | $mask = $rangeArray[1]; | |
385 | ||
c87fd3fe DO |
386 | if (empty ($ip) or empty ($mask)) |
387 | return "Invalid IP subnet '${range}'"; | |
e673ee24 DO |
388 | $ipL = ip2long($ip); |
389 | $maskL = ip2long($mask); | |
390 | if ($ipL == -1 || $ipL === FALSE) | |
391 | return 'Bad ip address'; | |
392 | if ($mask < 32 && $mask > 0) | |
393 | $maskL = $mask; | |
394 | else | |
395 | { | |
396 | $maskB = decbin($maskL); | |
397 | if (strlen($maskB)!=32) | |
398 | return 'Bad mask'; | |
399 | $ones=0; | |
400 | $zeroes=FALSE; | |
401 | foreach( str_split ($maskB) as $digit) | |
402 | { | |
403 | if ($digit == '0') | |
404 | $zeroes = TRUE; | |
405 | if ($digit == '1') | |
406 | { | |
407 | $ones++; | |
408 | if ($zeroes == TRUE) | |
409 | return 'Bad mask'; | |
410 | } | |
411 | } | |
412 | $maskL = $ones; | |
413 | } | |
414 | $binmask = binMaskFromDec($maskL); | |
415 | $ipL = $ipL & $binmask; | |
416 | ||
417 | $query = | |
418 | "select ". | |
419 | "id, ip, mask, name ". | |
420 | "from IPRanges "; | |
421 | ||
422 | ||
423 | global $dbxlink; | |
424 | ||
425 | $result = $dbxlink->query ($query); | |
426 | ||
427 | while ($row = $result->fetch (PDO::FETCH_ASSOC)) | |
428 | { | |
429 | $otherip = $row['ip']; | |
430 | $othermask = binMaskFromDec($row['mask']); | |
431 | // echo "checking $otherip & $othermask ".($otherip & $othermask)." == $ipL & $othermask ".($ipL & $othermask)." ".decbin($otherip)." ".decbin($othermask)." ".decbin($otherip & $othermask)." ".decbin($ipL)." ".decbin($othermask)." ".decbin($ipL & $othermask)."\n"; | |
432 | // echo "checking $otherip & $binmask ".($otherip & $binmask)." == $ipL & $binmask ".($ipL & $binmask)." ".decbin($otherip)." ".decbin($binmask)." ".decbin($otherip & $binmask)." ".decbin($ipL)." ".decbin($binmask)." ".decbin($ipL & $binmask)."\n"; | |
433 | // echo "\n"; | |
434 | // flush(); | |
435 | if (($otherip & $othermask) == ($ipL & $othermask)) | |
436 | return "This subnet intersects with ".long2ip($row['ip'])."/${row['mask']}"; | |
437 | if (($otherip & $binmask) == ($ipL & $binmask)) | |
438 | return "This subnet intersects with ".long2ip($row['ip'])."/${row['mask']}"; | |
439 | } | |
440 | $result->closeCursor(); | |
441 | $query = | |
442 | "insert into IPRanges set ip=".sprintf('%u', $ipL).", mask='$maskL', name='$name'"; | |
443 | $result = $dbxlink->exec ($query); | |
2dee289e DO |
444 | |
445 | if ($is_bcast and $maskL < 31) | |
446 | { | |
447 | $network_addr = long2ip ($ipL); | |
448 | $broadcast_addr = long2ip ($ipL | binInvMaskFromDec ($maskL)); | |
449 | updateAddress ($network_addr, 'network', 'yes'); | |
450 | updateAddress ($broadcast_addr, 'broadcast', 'yes'); | |
451 | } | |
e673ee24 DO |
452 | return ''; |
453 | } | |
454 | ||
455 | function getIPRange ($id = 0) | |
456 | { | |
457 | global $dbxlink; | |
458 | $query = | |
459 | "select ". | |
460 | "id as IPRanges_id, ". | |
461 | "INET_NTOA(ip) as IPRanges_ip, ". | |
e673ee24 DO |
462 | "mask as IPRanges_mask, ". |
463 | "name as IPRanges_name ". | |
464 | "from IPRanges ". | |
465 | "where id = '$id'"; | |
466 | $result = $dbxlink->query ($query); | |
467 | if ($result == NULL) | |
e673ee24 | 468 | return NULL; |
5c43a978 | 469 | $ret = array(); |
55cc3e4e DO |
470 | $row = $result->fetch (PDO::FETCH_ASSOC); |
471 | if ($row == NULL) | |
472 | return $ret; | |
473 | $ret['id'] = $row['IPRanges_id']; | |
474 | $ret['ip'] = $row['IPRanges_ip']; | |
7e039e88 | 475 | $ret['ip_bin'] = ip2long ($row['IPRanges_ip']); |
55cc3e4e DO |
476 | $ret['mask_bin'] = binMaskFromDec($row['IPRanges_mask']); |
477 | $ret['mask_bin_inv'] = binInvMaskFromDec($row['IPRanges_mask']); | |
478 | $ret['name'] = $row['IPRanges_name']; | |
479 | $ret['mask'] = $row['IPRanges_mask']; | |
480 | $ret['addrlist'] = array(); | |
55cc3e4e | 481 | $result->closeCursor(); |
7e039e88 DO |
482 | // We risk losing some significant bits in an unsigned 32bit integer, |
483 | // unless it is converted to a string. | |
484 | $db_first = "'" . sprintf ('%u', 0x00000000 + $ret['ip_bin'] & $ret['mask_bin']) . "'"; | |
485 | $db_last = "'" . sprintf ('%u', 0x00000000 + $ret['ip_bin'] | ($ret['mask_bin_inv'])) . "'"; | |
5c43a978 DO |
486 | |
487 | // Don't try to build up the whole structure in a single pass. Request | |
488 | // the list of user comments and reservations and merge allocations in | |
489 | // at a latter point. | |
55cc3e4e | 490 | $query = |
7e039e88 DO |
491 | "select INET_NTOA(ip) as ip, name, reserved from IPAddress " . |
492 | "where ip between ${db_first} and ${db_last} " . | |
5c43a978 DO |
493 | "and (reserved = 'yes' or name != '')"; |
494 | $ipa_res = $dbxlink->query ($query); | |
495 | if ($ipa_res == NULL) | |
55cc3e4e | 496 | return $ret; |
5c43a978 | 497 | while ($row = $ipa_res->fetch (PDO::FETCH_ASSOC)) |
55cc3e4e | 498 | { |
7e039e88 DO |
499 | $ip_bin = ip2long ($row['ip']); |
500 | $ret['addrlist'][$ip_bin] = $row; | |
5c43a978 DO |
501 | $tmp = array(); |
502 | foreach (array ('ip', 'name', 'reserved') as $cname) | |
503 | $tmp[$cname] = $row[$cname]; | |
504 | $tmp['references'] = array(); | |
7e039e88 | 505 | $ret['addrlist'][$ip_bin] = $tmp; |
5c43a978 DO |
506 | } |
507 | $ipa_res->closeCursor(); | |
e673ee24 | 508 | |
5c43a978 | 509 | $query = |
dda31a62 DO |
510 | "select INET_NTOA(ipb.ip) as ip, ro.id as object_id, " . |
511 | "ro.name as object_name, ipb.name, ipb.type, objtype_id, " . | |
512 | "dict_value as objtype_name from " . | |
5c43a978 | 513 | "IPBonds as ipb inner join RackObject as ro on ipb.object_id = ro.id " . |
dda31a62 | 514 | "left join Dictionary on objtype_id=dict_key natural join Chapter " . |
7e039e88 | 515 | "where ip between ${db_first} and ${db_last} " . |
dda31a62 | 516 | "and chapter_name = 'RackObjectType'" . |
5c43a978 DO |
517 | "order by ipb.type, object_name"; |
518 | $ipb_res = $dbxlink->query ($query); | |
519 | while ($row = $ipb_res->fetch (PDO::FETCH_ASSOC)) | |
520 | { | |
7e039e88 DO |
521 | $ip_bin = ip2long ($row['ip']); |
522 | if (!isset ($ret['addrlist'][$ip_bin])) | |
55cc3e4e | 523 | { |
7e039e88 DO |
524 | $ret['addrlist'][$ip_bin] = array(); |
525 | $ret['addrlist'][$ip_bin]['ip'] = $row['ip']; | |
526 | $ret['addrlist'][$ip_bin]['name'] = ''; | |
527 | $ret['addrlist'][$ip_bin]['reserved'] = 'no'; | |
528 | $ret['addrlist'][$ip_bin]['references'] = array(); | |
e673ee24 | 529 | } |
5c43a978 | 530 | $tmp = array(); |
dda31a62 | 531 | foreach (array ('object_id', 'type', 'name') as $cname) |
5c43a978 | 532 | $tmp[$cname] = $row[$cname]; |
dda31a62 DO |
533 | $quasiobject['name'] = $row['object_name']; |
534 | $quasiobject['objtype_id'] = $row['objtype_id']; | |
535 | $quasiobject['objtype_name'] = $row['objtype_name']; | |
536 | $tmp['object_name'] = displayedName ($quasiobject); | |
7e039e88 | 537 | $ret['addrlist'][$ip_bin]['references'][] = $tmp; |
e673ee24 | 538 | } |
5c43a978 DO |
539 | $ipb_res->closeCursor(); |
540 | ||
e673ee24 DO |
541 | return $ret; |
542 | } | |
543 | ||
dda31a62 DO |
544 | // Don't require any records in IPAddress, but if there is one, |
545 | // merge the data between getting allocation list. Collect enough data | |
546 | // to call displayedName() ourselves. | |
e673ee24 DO |
547 | function getIPAddress ($ip=0) |
548 | { | |
549 | $ret = array(); | |
e673ee24 | 550 | $ret['bonds'] = array(); |
59bebe2b | 551 | // FIXME: below two aren't neither filled in with data nor rendered (ticket:23) |
e673ee24 DO |
552 | $ret['outpf'] = array(); |
553 | $ret['inpf'] = array(); | |
59bebe2b DO |
554 | $ret['vslist'] = array(); |
555 | $ret['rslist'] = array(); | |
e673ee24 | 556 | $ret['exists'] = 0; |
dda31a62 | 557 | $ret['name'] = ''; |
e673ee24 DO |
558 | $ret['reserved'] = 'no'; |
559 | global $dbxlink; | |
59bebe2b | 560 | $query = |
e673ee24 | 561 | "select ". |
dda31a62 | 562 | "name, reserved ". |
e673ee24 | 563 | "from IPAddress ". |
dda31a62 | 564 | "where ip = INET_ATON('$ip') and (reserved = 'yes' or name != '')"; |
59bebe2b DO |
565 | $result = $dbxlink->query ($query); |
566 | if ($result == NULL) | |
567 | { | |
568 | showError ('Query #1 failed', __FUNCTION__); | |
e673ee24 | 569 | return NULL; |
59bebe2b DO |
570 | } |
571 | if ($row = $result->fetch (PDO::FETCH_ASSOC)) | |
e673ee24 | 572 | { |
959c4f4c | 573 | $ret['exists'] = 1; |
959c4f4c DO |
574 | $ret['name'] = $row['name']; |
575 | $ret['reserved'] = $row['reserved']; | |
e673ee24 | 576 | } |
59bebe2b DO |
577 | $result->closeCursor(); |
578 | unset ($result); | |
e673ee24 | 579 | |
59bebe2b | 580 | $query = |
dda31a62 DO |
581 | "select ". |
582 | "IPBonds.object_id as object_id, ". | |
583 | "IPBonds.name as name, ". | |
584 | "IPBonds.type as type, ". | |
585 | "objtype_id, dict_value as objtype_name, " . | |
586 | "RackObject.name as object_name ". | |
587 | "from IPBonds join RackObject on IPBonds.object_id=RackObject.id ". | |
588 | "left join Dictionary on objtype_id=dict_key natural join Chapter " . | |
589 | "where IPBonds.ip=INET_ATON('$ip') ". | |
590 | "and chapter_name = 'RackObjectType' " . | |
591 | "order by RackObject.id, IPBonds.name"; | |
59bebe2b | 592 | $result = $dbxlink->query ($query); |
dda31a62 | 593 | $count=0; |
59bebe2b | 594 | while ($row = $result->fetch (PDO::FETCH_ASSOC)) |
e673ee24 | 595 | { |
dda31a62 DO |
596 | $ret['bonds'][$count]['object_id'] = $row['object_id']; |
597 | $ret['bonds'][$count]['name'] = $row['name']; | |
598 | $ret['bonds'][$count]['type'] = $row['type']; | |
599 | $qo = array(); | |
600 | $qo['name'] = $row['object_name']; | |
601 | $qo['objtype_id'] = $row['objtype_id']; | |
602 | $qo['objtype_name'] = $row['objtype_name']; | |
603 | $ret['bonds'][$count]['object_name'] = displayedName ($qo); | |
604 | $count++; | |
605 | $ret['exists'] = 1; | |
e673ee24 | 606 | } |
59bebe2b DO |
607 | $result->closeCursor(); |
608 | unset ($result); | |
609 | ||
5fe1ed76 | 610 | $query = "select id, vport, proto, name from IPVirtualService where vip = inet_aton('${ip}')"; |
59bebe2b DO |
611 | $result = $dbxlink->query ($query); |
612 | while ($row = $result->fetch (PDO::FETCH_ASSOC)) | |
5fe1ed76 DO |
613 | { |
614 | $new = $row; | |
615 | $new['vip'] = $ip; | |
616 | $ret['vslist'][] = $new; | |
617 | } | |
618 | $result->closeCursor(); | |
619 | unset ($result); | |
620 | ||
621 | $query = "select inservice, rsport, IPRSPool.id as pool_id, IPRSPool.name as poolname from " . | |
622 | "IPRealServer inner join IPRSPool on rspool_id = IPRSPool.id " . | |
623 | "where rsip = inet_aton('${ip}')"; | |
624 | $result = $dbxlink->query ($query); | |
625 | while ($row = $result->fetch (PDO::FETCH_ASSOC)) | |
626 | { | |
627 | $new = $row; | |
628 | $new['rsip'] = $ip; | |
629 | $ret['rslist'][] = $new; | |
630 | } | |
59bebe2b DO |
631 | $result->closeCursor(); |
632 | unset ($result); | |
e673ee24 DO |
633 | |
634 | return $ret; | |
635 | } | |
636 | ||
637 | function bindIpToObject ($ip='', $object_id=0, $name='', $type='') | |
638 | { | |
639 | global $dbxlink; | |
640 | ||
641 | $range = getRangeByIp($ip); | |
e673ee24 DO |
642 | if (!$range) |
643 | return 'Non-existant ip address. Try adding IP range first'; | |
644 | ||
20a92aa2 DO |
645 | $result = useInsertBlade |
646 | ( | |
647 | 'IPBonds', | |
648 | array | |
649 | ( | |
dda31a62 | 650 | 'ip' => "INET_ATON('$ip')", |
20a92aa2 DO |
651 | 'object_id' => "'${object_id}'", |
652 | 'name' => "'${name}'", | |
653 | 'type' => "'${type}'" | |
654 | ) | |
655 | ); | |
656 | return $result ? '' : 'useInsertBlade() failed in bindIpToObject()'; | |
e673ee24 DO |
657 | } |
658 | ||
659 | // This function looks up 'has_problems' flag for 'T' atoms | |
660 | // and modifies 'hl' key. May be, this should be better done | |
661 | // in getRackData(). We don't honour 'skipped' key, because | |
662 | // the function is also used for thumb creation. | |
663 | function markupObjectProblems (&$rackData) | |
664 | { | |
665 | for ($i = $rackData['height']; $i > 0; $i--) | |
666 | for ($locidx = 0; $locidx < 3; $locidx++) | |
667 | if ($rackData[$i][$locidx]['state'] == 'T') | |
668 | { | |
669 | $object = getObjectInfo ($rackData[$i][$locidx]['object_id']); | |
670 | if ($object['has_problems'] == 'yes') | |
671 | { | |
672 | // Object can be already highlighted. | |
673 | if (isset ($rackData[$i][$locidx]['hl'])) | |
674 | $rackData[$i][$locidx]['hl'] = $rackData[$i][$locidx]['hl'] . 'w'; | |
675 | else | |
676 | $rackData[$i][$locidx]['hl'] = 'w'; | |
677 | } | |
678 | } | |
679 | } | |
680 | ||
681 | function search_cmpObj ($a, $b) | |
682 | { | |
683 | return ($a['score'] > $b['score'] ? -1 : 1); | |
684 | } | |
685 | ||
686 | // This function performs search and then calculates score for each result. | |
687 | // Given previous search results in $objects argument, it adds new results | |
688 | // to the array and updates score for existing results, if it is greater than | |
689 | // existing score. | |
690 | function mergeSearchResults (&$objects, $terms, $fieldname) | |
691 | { | |
692 | global $dbxlink; | |
693 | $query = | |
694 | "select name, label, asset_no, barcode, ro.id, dict_key as objtype_id, " . | |
695 | "dict_value as objtype_name, asset_no from RackObject as ro inner join Dictionary " . | |
696 | "on objtype_id = dict_key natural join Chapter where chapter_name = 'RackObjectType' and "; | |
697 | $count = 0; | |
698 | foreach (explode (' ', $terms) as $term) | |
699 | { | |
700 | if ($count) $query .= ' or '; | |
701 | $query .= "${fieldname} like '%$term%'"; | |
702 | $count++; | |
703 | } | |
704 | $query .= ""; | |
705 | $result = $dbxlink->query($query); | |
706 | if ($result == NULL) | |
707 | { | |
61e269b5 | 708 | showError ("SQL query failed", __FUNCTION__); |
e673ee24 DO |
709 | return NULL; |
710 | } | |
711 | // FIXME: this dead call was executed 4 times per 1 object search! | |
712 | // $typeList = getObjectTypeList(); | |
713 | $clist = array ('id', 'name', 'label', 'asset_no', 'barcode', 'objtype_id', 'objtype_name'); | |
714 | while ($row = $result->fetch(PDO::FETCH_ASSOC)) | |
715 | { | |
716 | foreach ($clist as $cname) | |
717 | $object[$cname] = $row[$cname]; | |
718 | $object['score'] = 0; | |
719 | $object['dname'] = displayedName ($object); | |
720 | unset ($object['objtype_id']); | |
721 | foreach (explode (' ', $terms) as $term) | |
722 | if (strstr ($object['name'], $term)) | |
723 | $object['score'] += 1; | |
724 | unset ($object['name']); | |
725 | if (!isset ($objects[$row['id']])) | |
726 | $objects[$row['id']] = $object; | |
727 | elseif ($objects[$row['id']]['score'] < $object['score']) | |
728 | $objects[$row['id']]['score'] = $object['score']; | |
729 | } | |
730 | return $objects; | |
731 | } | |
732 | ||
733 | function getSearchResults ($terms) | |
734 | { | |
735 | $objects = array(); | |
736 | mergeSearchResults ($objects, $terms, 'name'); | |
737 | mergeSearchResults ($objects, $terms, 'label'); | |
738 | mergeSearchResults ($objects, $terms, 'asset_no'); | |
739 | mergeSearchResults ($objects, $terms, 'barcode'); | |
740 | if (count ($objects) == 1) | |
741 | usort ($objects, 'search_cmpObj'); | |
742 | return $objects; | |
743 | } | |
744 | ||
745 | // This function removes all colons and dots from a string. | |
746 | function l2addressForDatabase ($string) | |
747 | { | |
748 | if (empty ($string)) | |
749 | return 'NULL'; | |
750 | $pieces = explode (':', $string); | |
751 | // This workaround is for SunOS ifconfig. | |
752 | foreach ($pieces as &$byte) | |
753 | if (strlen ($byte) == 1) | |
754 | $byte = '0' . $byte; | |
755 | // And this workaround is for PHP. | |
756 | unset ($byte); | |
757 | $string = implode ('', $pieces); | |
758 | $pieces = explode ('.', $string); | |
759 | $string = implode ('', $pieces); | |
760 | $string = strtoupper ($string); | |
761 | return "'$string'"; | |
762 | } | |
763 | ||
764 | function l2addressFromDatabase ($string) | |
765 | { | |
766 | switch (strlen ($string)) | |
767 | { | |
768 | case 12: // Ethernet | |
769 | case 16: // FireWire | |
770 | $ret = implode (':', str_split ($string, 2)); | |
771 | break; | |
772 | default: | |
773 | $ret = $string; | |
774 | break; | |
775 | } | |
776 | return $ret; | |
777 | } | |
778 | ||
779 | // The following 2 functions return previous and next rack IDs for | |
780 | // a given rack ID. The order of racks is the same as in renderRackspace() | |
781 | // or renderRow(). | |
782 | function getPrevIDforRack ($row_id = 0, $rack_id = 0) | |
783 | { | |
784 | if ($row_id <= 0 or $rack_id <= 0) | |
785 | { | |
61e269b5 | 786 | showError ('Invalid arguments passed', __FUNCTION__); |
e673ee24 DO |
787 | return NULL; |
788 | } | |
789 | $rackList = getRacksForRow ($row_id); | |
790 | doubleLink ($rackList); | |
791 | if (isset ($rackList[$rack_id]['prev_key'])) | |
792 | return $rackList[$rack_id]['prev_key']; | |
793 | return NULL; | |
794 | } | |
795 | ||
796 | function getNextIDforRack ($row_id = 0, $rack_id = 0) | |
797 | { | |
798 | if ($row_id <= 0 or $rack_id <= 0) | |
799 | { | |
61e269b5 | 800 | showError ('Invalid arguments passed', __FUNCTION__); |
e673ee24 DO |
801 | return NULL; |
802 | } | |
803 | $rackList = getRacksForRow ($row_id); | |
804 | doubleLink ($rackList); | |
805 | if (isset ($rackList[$rack_id]['next_key'])) | |
806 | return $rackList[$rack_id]['next_key']; | |
807 | return NULL; | |
808 | } | |
809 | ||
810 | // This function finds previous and next array keys for each array key and | |
811 | // modifies its argument accordingly. | |
812 | function doubleLink (&$array) | |
813 | { | |
814 | $prev_key = NULL; | |
815 | foreach (array_keys ($array) as $key) | |
816 | { | |
817 | if ($prev_key) | |
818 | { | |
819 | $array[$key]['prev_key'] = $prev_key; | |
820 | $array[$prev_key]['next_key'] = $key; | |
821 | } | |
822 | $prev_key = $key; | |
823 | } | |
824 | } | |
825 | ||
826 | // After applying usort() to a rack list we will lose original array keys. | |
827 | // This function restores the keys so they are equal to rack IDs. | |
828 | function restoreRackIDs ($racks) | |
829 | { | |
830 | $ret = array(); | |
831 | foreach ($racks as $rack) | |
832 | $ret[$rack['id']] = $rack; | |
833 | return $ret; | |
834 | } | |
835 | ||
836 | function sortTokenize ($a, $b) | |
837 | { | |
838 | $aold=''; | |
839 | while ($a != $aold) | |
840 | { | |
841 | $aold=$a; | |
842 | $a = ereg_replace('[^a-zA-Z0-9]',' ',$a); | |
843 | $a = ereg_replace('([0-9])([a-zA-Z])','\\1 \\2',$a); | |
844 | $a = ereg_replace('([a-zA-Z])([0-9])','\\1 \\2',$a); | |
845 | } | |
846 | ||
847 | $bold=''; | |
848 | while ($b != $bold) | |
849 | { | |
850 | $bold=$b; | |
851 | $b = ereg_replace('[^a-zA-Z0-9]',' ',$b); | |
852 | $b = ereg_replace('([0-9])([a-zA-Z])','\\1 \\2',$b); | |
853 | $b = ereg_replace('([a-zA-Z])([0-9])','\\1 \\2',$b); | |
854 | } | |
855 | ||
856 | ||
857 | ||
858 | $ar = explode(' ', $a); | |
859 | $br = explode(' ', $b); | |
860 | for ($i=0; $i<count($ar) && $i<count($br); $i++) | |
861 | { | |
862 | $ret = 0; | |
863 | if (is_numeric($ar[$i]) and is_numeric($br[$i])) | |
864 | $ret = ($ar[$i]==$br[$i])?0:($ar[$i]<$br[$i]?-1:1); | |
865 | else | |
866 | $ret = strcasecmp($ar[$i], $br[$i]); | |
867 | if ($ret != 0) | |
868 | return $ret; | |
869 | } | |
870 | if ($i<count($ar)) | |
871 | return 1; | |
872 | if ($i<count($br)) | |
873 | return -1; | |
874 | return 0; | |
875 | } | |
876 | ||
877 | function sortByName ($a, $b) | |
878 | { | |
879 | return sortTokenize($a['name'], $b['name']); | |
880 | } | |
881 | ||
6a3a37b2 DO |
882 | function sortRacks ($a, $b) |
883 | { | |
884 | return sortTokenize($a['row_name'] . ': ' . $a['name'], $b['row_name'] . ': ' . $b['name']); | |
885 | } | |
886 | ||
e673ee24 DO |
887 | function eq ($a, $b) |
888 | { | |
889 | return $a==$b; | |
890 | } | |
891 | ||
892 | function neq ($a, $b) | |
893 | { | |
894 | return $a!=$b; | |
895 | } | |
896 | ||
897 | function countRefsOfType ($refs, $type, $eq) | |
898 | { | |
899 | $count=0; | |
900 | foreach ($refs as $ref) | |
901 | { | |
902 | if ($eq($ref['type'], $type)) | |
903 | $count++; | |
904 | } | |
905 | return $count; | |
906 | } | |
907 | ||
908 | function sortEmptyPorts ($a, $b) | |
909 | { | |
910 | $objname_cmp = sortTokenize($a['Object_name'], $b['Object_name']); | |
911 | if ($objname_cmp == 0) | |
912 | { | |
913 | return sortTokenize($a['Port_name'], $b['Port_name']); | |
914 | } | |
915 | return $objname_cmp; | |
916 | } | |
917 | ||
918 | function sortObjectAddressesAndNames ($a, $b) | |
919 | { | |
920 | $objname_cmp = sortTokenize($a['object_name'], $b['object_name']); | |
921 | if ($objname_cmp == 0) | |
922 | { | |
79f22c3d DO |
923 | $name_a = (isset ($a['port_name'])) ? $a['port_name'] : ''; |
924 | $name_b = (isset ($b['port_name'])) ? $b['port_name'] : ''; | |
925 | $objname_cmp = sortTokenize($name_a, $name_b); | |
e673ee24 | 926 | if ($objname_cmp == 0) |
e673ee24 | 927 | sortTokenize($a['ip'], $b['ip']); |
e673ee24 DO |
928 | return $objname_cmp; |
929 | } | |
930 | return $objname_cmp; | |
931 | } | |
932 | ||
933 | ||
934 | ||
935 | function sortAddresses ($a, $b) | |
936 | { | |
937 | $name_cmp = sortTokenize($a['name'], $b['name']); | |
938 | if ($name_cmp == 0) | |
939 | { | |
940 | return sortTokenize($a['ip'], $b['ip']); | |
941 | } | |
942 | return $name_cmp; | |
943 | } | |
944 | ||
945 | // This function expands port compat list into a matrix. | |
946 | function buildPortCompatMatrixFromList ($portTypeList, $portCompatList) | |
947 | { | |
948 | $matrix = array(); | |
949 | // Create type matrix and markup compatible types. | |
950 | foreach (array_keys ($portTypeList) as $type1) | |
951 | foreach (array_keys ($portTypeList) as $type2) | |
952 | $matrix[$type1][$type2] = FALSE; | |
953 | foreach ($portCompatList as $pair) | |
954 | $matrix[$pair['type1']][$pair['type2']] = TRUE; | |
955 | return $matrix; | |
956 | } | |
957 | ||
958 | function newPortForwarding($object_id, $localip, $localport, $remoteip, $remoteport, $proto, $description) | |
959 | { | |
960 | global $dbxlink; | |
961 | ||
962 | $range = getRangeByIp($localip); | |
963 | if (!$range) | |
964 | return "$localip: Non existant ip"; | |
965 | ||
966 | $range = getRangeByIp($remoteip); | |
967 | if (!$range) | |
968 | return "$remoteip: Non existant ip"; | |
969 | ||
970 | if ( ($localport <= 0) or ($localport >= 65536) ) | |
971 | return "$localport: invaild port"; | |
972 | ||
973 | if ( ($remoteport <= 0) or ($remoteport >= 65536) ) | |
974 | return "$remoteport: invaild port"; | |
975 | ||
976 | $query = | |
977 | "insert into PortForwarding set object_id='$object_id', localip=INET_ATON('$localip'), remoteip=INET_ATON('$remoteip'), localport='$localport', remoteport='$remoteport', proto='$proto', description='$description'"; | |
978 | $result = $dbxlink->exec ($query); | |
979 | ||
980 | return ''; | |
981 | } | |
982 | ||
983 | function deletePortForwarding($object_id, $localip, $localport, $remoteip, $remoteport, $proto) | |
984 | { | |
985 | global $dbxlink; | |
986 | ||
987 | $query = | |
988 | "delete from PortForwarding where object_id='$object_id' and localip=INET_ATON('$localip') and remoteip=INET_ATON('$remoteip') and localport='$localport' and remoteport='$remoteport' and proto='$proto'"; | |
989 | $result = $dbxlink->exec ($query); | |
990 | return ''; | |
991 | } | |
992 | ||
993 | function updatePortForwarding($object_id, $localip, $localport, $remoteip, $remoteport, $proto, $description) | |
994 | { | |
995 | global $dbxlink; | |
996 | ||
997 | $query = | |
998 | "update PortForwarding set description='$description' where object_id='$object_id' and localip=INET_ATON('$localip') and remoteip=INET_ATON('$remoteip') and localport='$localport' and remoteport='$remoteport' and proto='$proto'"; | |
999 | $result = $dbxlink->exec ($query); | |
1000 | return ''; | |
1001 | } | |
1002 | ||
1003 | function getObjectForwards($object_id) | |
1004 | { | |
1005 | global $dbxlink; | |
1006 | ||
1007 | $ret = array(); | |
1008 | $ret['out'] = array(); | |
1009 | $ret['in'] = array(); | |
1010 | $query = | |
1011 | "select ". | |
1012 | "dict_value as proto, ". | |
1013 | "proto as proto_bin, ". | |
1014 | "INET_NTOA(localip) as localip, ". | |
1015 | "localport, ". | |
1016 | "INET_NTOA(remoteip) as remoteip, ". | |
1017 | "remoteport, ". | |
f28fbe8b DO |
1018 | "ipa1.name as local_addr_name, " . |
1019 | "ipa2.name as remote_addr_name, " . | |
e673ee24 DO |
1020 | "description ". |
1021 | "from PortForwarding inner join Dictionary on proto = dict_key natural join Chapter ". | |
f28fbe8b DO |
1022 | "left join IPAddress as ipa1 on PortForwarding.localip = ipa1.ip " . |
1023 | "left join IPAddress as ipa2 on PortForwarding.remoteip = ipa2.ip " . | |
e673ee24 DO |
1024 | "where object_id='$object_id' and chapter_name = 'Protocols' ". |
1025 | "order by localip, localport, proto, remoteip, remoteport"; | |
1026 | $result2 = $dbxlink->query ($query); | |
1027 | $count=0; | |
1028 | while ($row = $result2->fetch (PDO::FETCH_ASSOC)) | |
1029 | { | |
f28fbe8b DO |
1030 | foreach (array ('proto', 'proto_bin', 'localport', 'localip', 'remoteport', 'remoteip', 'description', 'local_addr_name', 'remote_addr_name') as $cname) |
1031 | $ret['out'][$count][$cname] = $row[$cname]; | |
e673ee24 DO |
1032 | $count++; |
1033 | } | |
1034 | $result2->closeCursor(); | |
1035 | ||
1036 | $query = | |
1037 | "select ". | |
1038 | "dict_value as proto, ". | |
1039 | "proto as proto_bin, ". | |
1040 | "INET_NTOA(localip) as localip, ". | |
1041 | "localport, ". | |
1042 | "INET_NTOA(remoteip) as remoteip, ". | |
1043 | "remoteport, ". | |
1044 | "PortForwarding.object_id as object_id, ". | |
1045 | "RackObject.name as object_name, ". | |
1046 | "description ". | |
f28fbe8b | 1047 | "from ((PortForwarding join IPBonds on remoteip=IPBonds.ip) join RackObject on PortForwarding.object_id=RackObject.id) inner join Dictionary on proto = dict_key natural join Chapter ". |
e673ee24 DO |
1048 | "where IPBonds.object_id='$object_id' and chapter_name = 'Protocols' ". |
1049 | "order by remoteip, remoteport, proto, localip, localport"; | |
1050 | $result3 = $dbxlink->query ($query); | |
1051 | $count=0; | |
1052 | while ($row = $result3->fetch (PDO::FETCH_ASSOC)) | |
1053 | { | |
603ad85f | 1054 | foreach (array ('proto', 'proto_bin', 'localport', 'localip', 'remoteport', 'remoteip', 'object_id', 'object_name', 'description') as $cname) |
f28fbe8b | 1055 | $ret['in'][$count][$cname] = $row[$cname]; |
e673ee24 DO |
1056 | $count++; |
1057 | } | |
1058 | $result3->closeCursor(); | |
1059 | ||
1060 | return $ret; | |
1061 | } | |
1062 | ||
c31cd72c | 1063 | // This function returns an array of single element of object's FQDN attribute, |
f321b50a DO |
1064 | // if FQDN is set. The next choice is object's common name, if it looks like a |
1065 | // hostname. Otherwise an array of all 'regular' IP addresses of the | |
c31cd72c | 1066 | // object is returned (which may appear 0 and more elements long). |
f321b50a | 1067 | function findAllEndpoints ($object_id, $fallback = '') |
c31cd72c DO |
1068 | { |
1069 | $values = getAttrValues ($object_id); | |
1070 | foreach ($values as $record) | |
f321b50a | 1071 | if ($record['name'] == 'FQDN' && !empty ($record['value'])) |
c31cd72c DO |
1072 | return array ($record['value']); |
1073 | $addresses = getObjectAddresses ($object_id); | |
1074 | $regular = array(); | |
1075 | foreach ($addresses as $idx => $address) | |
1076 | if ($address['type'] == 'regular') | |
fa8112d1 | 1077 | $regular[] = $address['ip']; |
f321b50a DO |
1078 | if (!count ($regular) && !empty ($fallback)) |
1079 | return array ($fallback); | |
c31cd72c DO |
1080 | return $regular; |
1081 | } | |
1082 | ||
83ba6670 DO |
1083 | // Some records in the dictionary may be written as plain text or as Wiki |
1084 | // link in the following syntax: | |
1085 | // 1. word | |
1086 | // 2. [[word URL]] // FIXME: this isn't working | |
1087 | // 3. [[word word word | URL]] | |
1088 | // This function parses the line and returns text suitable for either A | |
1089 | // (rendering <A HREF>) or O (for <OPTION>). | |
1090 | function parseWikiLink ($line, $which) | |
1091 | { | |
010231c2 | 1092 | if (preg_match ('/^\[\[.+\]\]$/', $line) == 0) |
83ba6670 | 1093 | return $line; |
010231c2 DO |
1094 | $line = preg_replace ('/^\[\[(.+)\]\]$/', '$1', $line); |
1095 | $s = explode ('|', $line); | |
83ba6670 DO |
1096 | $o_value = trim ($s[0]); |
1097 | $a_value = trim ($s[1]); | |
1098 | if ($which == 'a') | |
010231c2 | 1099 | return "<a href='${a_value}'>${o_value}</a>"; |
83ba6670 DO |
1100 | if ($which == 'o') |
1101 | return $o_value; | |
1102 | } | |
1103 | ||
2de490b7 DO |
1104 | function buildVServiceName ($vsinfo = NULL) |
1105 | { | |
1106 | if ($vsinfo == NULL) | |
1107 | { | |
1108 | showError ('NULL argument', __FUNCTION__); | |
1109 | return NULL; | |
1110 | } | |
8d790216 | 1111 | return $vsinfo['vip'] . ':' . $vsinfo['vport'] . '/' . $vsinfo['proto']; |
2de490b7 DO |
1112 | } |
1113 | ||
177b1e9b DO |
1114 | // rackspace usage for a single rack |
1115 | // (T + W + U) / (height * 3 - A) | |
11df133a | 1116 | function getRSUforRack ($data = NULL) |
177b1e9b | 1117 | { |
11df133a | 1118 | if ($data == NULL) |
177b1e9b DO |
1119 | { |
1120 | showError ('Invalid argument', __FUNCTION__); | |
1121 | return NULL; | |
1122 | } | |
6ffba290 | 1123 | $counter = array ('A' => 0, 'U' => 0, 'T' => 0, 'W' => 0, 'F' => 0); |
9e60f7df DO |
1124 | for ($unit_no = $data['height']; $unit_no > 0; $unit_no--) |
1125 | for ($locidx = 0; $locidx < 3; $locidx++) | |
1126 | $counter[$data[$unit_no][$locidx]['state']]++; | |
dfa3c075 | 1127 | return ($counter['T'] + $counter['W'] + $counter['U']) / ($counter['T'] + $counter['W'] + $counter['U'] + $counter['F']); |
177b1e9b DO |
1128 | } |
1129 | ||
11df133a DO |
1130 | // Same for row. |
1131 | function getRSUforRackRow ($rowData = NULL) | |
1132 | { | |
bb26a59e | 1133 | if ($rowData === NULL) |
11df133a DO |
1134 | { |
1135 | showError ('Invalid argument', __FUNCTION__); | |
1136 | return NULL; | |
1137 | } | |
bb26a59e DO |
1138 | if (!count ($rowData)) |
1139 | return 0; | |
11df133a | 1140 | $counter = array ('A' => 0, 'U' => 0, 'T' => 0, 'W' => 0, 'F' => 0); |
f81a2012 | 1141 | $total_height = 0; |
dfa3c075 DO |
1142 | foreach (array_keys ($rowData) as $rack_id) |
1143 | { | |
1144 | $data = getRackData ($rack_id); | |
1145 | $total_height += $data['height']; | |
11df133a DO |
1146 | for ($unit_no = $data['height']; $unit_no > 0; $unit_no--) |
1147 | for ($locidx = 0; $locidx < 3; $locidx++) | |
1148 | $counter[$data[$unit_no][$locidx]['state']]++; | |
dfa3c075 DO |
1149 | } |
1150 | return ($counter['T'] + $counter['W'] + $counter['U']) / ($counter['T'] + $counter['W'] + $counter['U'] + $counter['F']); | |
11df133a DO |
1151 | } |
1152 | ||
f1a0477d DO |
1153 | function getObjectCount ($rackData) |
1154 | { | |
1155 | $objects = array(); | |
1156 | for ($i = $rackData['height']; $i > 0; $i--) | |
1157 | for ($locidx = 0; $locidx < 3; $locidx++) | |
1158 | if | |
1159 | ( | |
1160 | $rackData[$i][$locidx]['state'] == 'T' and | |
1161 | !in_array ($rackData[$i][$locidx]['object_id'], $objects) | |
1162 | ) | |
1163 | $objects[] = $rackData[$i][$locidx]['object_id']; | |
1164 | return count ($objects); | |
1165 | } | |
1166 | ||
9af110b4 DO |
1167 | // Perform substitutions and return resulting string |
1168 | function apply_macros ($macros, $subject) | |
1169 | { | |
1170 | $ret = $subject; | |
1171 | foreach ($macros as $search => $replace) | |
1172 | $ret = str_replace ($search, $replace, $ret); | |
1173 | return $ret; | |
1174 | } | |
1175 | ||
1176 | // Make sure the string is always wrapped with LF characters | |
1177 | function lf_wrap ($str) | |
1178 | { | |
1179 | $ret = trim ($str, "\r\n"); | |
1180 | if (!empty ($ret)) | |
1181 | $ret .= "\n"; | |
1182 | return $ret; | |
1183 | } | |
1184 | ||
e6e7d8b3 DO |
1185 | // Adopted from Mantis BTS code. |
1186 | function string_insert_hrefs ($s) | |
1187 | { | |
1188 | if (getConfigVar ('DETECT_URLS') != 'yes') | |
1189 | return $s; | |
1190 | # Find any URL in a string and replace it by a clickable link | |
1191 | $s = preg_replace( '/(([[:alpha:]][-+.[:alnum:]]*):\/\/(%[[:digit:]A-Fa-f]{2}|[-_.!~*\';\/?%^\\\\:@&={\|}+$#\(\),\[\][:alnum:]])+)/se', | |
1192 | "'<a href=\"'.rtrim('\\1','.').'\">\\1</a> [<a href=\"'.rtrim('\\1','.').'\" target=\"_blank\">^</a>]'", | |
1193 | $s); | |
1194 | $s = preg_replace( '/\b' . email_regex_simple() . '\b/i', | |
1195 | '<a href="mailto:\0">\0</a>', | |
1196 | $s); | |
1197 | return $s; | |
1198 | } | |
1199 | ||
1200 | // Idem. | |
1201 | function email_regex_simple () | |
1202 | { | |
1203 | return "(([a-z0-9!#*+\/=?^_{|}~-]+(?:\.[a-z0-9!#*+\/=?^_{|}~-]+)*)" . # recipient | |
1204 | "\@((?:[a-z0-9](?:[a-z0-9-]*[a-z0-9])?\.)+[a-z0-9](?:[a-z0-9-]*[a-z0-9])?))"; # @domain | |
1205 | } | |
1206 | ||
118e4c38 DO |
1207 | // Parse AUTOPORTS_CONFIG and return a list of generated pairs (port_type, port_name) |
1208 | // for the requested object_type_id. | |
1209 | function getAutoPorts ($type_id) | |
1210 | { | |
1211 | $ret = array(); | |
1212 | $typemap = explode (';', str_replace (' ', '', getConfigVar ('AUTOPORTS_CONFIG'))); | |
1213 | foreach ($typemap as $equation) | |
1214 | { | |
1215 | $tmp = explode ('=', $equation); | |
1216 | if (count ($tmp) != 2) | |
1217 | continue; | |
1218 | $objtype_id = $tmp[0]; | |
1219 | if ($objtype_id != $type_id) | |
1220 | continue; | |
1221 | $portlist = $tmp[1]; | |
1222 | foreach (explode ('+', $portlist) as $product) | |
1223 | { | |
1224 | $tmp = explode ('*', $product); | |
1225 | if (count ($tmp) != 3) | |
1226 | continue; | |
1227 | $nports = $tmp[0]; | |
1228 | $port_type = $tmp[1]; | |
1229 | $format = $tmp[2]; | |
1230 | for ($i = 0; $i < $nports; $i++) | |
1231 | $ret[] = array ('type' => $port_type, 'name' => @sprintf ($format, $i)); | |
1232 | } | |
1233 | } | |
1234 | return $ret; | |
1235 | } | |
1236 | ||
9dfd4cc9 DO |
1237 | // Find if a particular tag id exists on the tree, then attach the |
1238 | // given child tag to it. If the parent tag doesn't exist, return FALSE. | |
1239 | function attachChildTag (&$tree, $parent_id, $child_id, $child_info) | |
1240 | { | |
1241 | foreach ($tree as $tagid => $taginfo) | |
1242 | { | |
1243 | if ($tagid == $parent_id) | |
1244 | { | |
1245 | $tree[$tagid]['kids'][$child_id] = $child_info; | |
1246 | return TRUE; | |
1247 | } | |
1248 | elseif (attachChildTag ($tree[$tagid]['kids'], $parent_id, $child_id, $child_info)) | |
1249 | return TRUE; | |
1250 | } | |
1251 | return FALSE; | |
1252 | } | |
1253 | ||
1254 | // Build a tree from the tag list and return it. | |
1255 | function getTagTree () | |
1256 | { | |
1257 | $tagtree = array(); | |
1258 | $taglist = getTagList(); | |
1259 | while (count ($taglist) > 0) | |
1260 | { | |
1261 | $picked = FALSE; | |
1262 | foreach ($taglist as $tagid => $taginfo) | |
1263 | { | |
1264 | $taginfo['kids'] = array(); | |
1265 | if ($taginfo['parent_id'] == NULL) | |
1266 | { | |
1267 | $tagtree[$tagid] = $taginfo; | |
1268 | $picked = TRUE; | |
1269 | unset ($taglist[$tagid]); | |
1270 | } | |
1271 | elseif (attachChildTag ($tagtree, $taginfo['parent_id'], $tagid, $taginfo)) | |
1272 | { | |
1273 | $picked = TRUE; | |
1274 | unset ($taglist[$tagid]); | |
1275 | } | |
1276 | } | |
1277 | if (!$picked) // Only orphaned items on the list. | |
1278 | break; | |
1279 | } | |
1280 | return $tagtree; | |
1281 | } | |
1282 | ||
e673ee24 | 1283 | ?> |