index.php 4.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114
  1. <?php
  2. require_once ($_SERVER['DOCUMENT_ROOT']."/inc/auth.php");
  3. require_once ($_SERVER['DOCUMENT_ROOT']."/inc/languages/" . $language . ".php");
  4. if (isset($_POST["create"])) {
  5. $fname = $_POST["newswitches"];
  6. if ($fname) {
  7. global $snmp_default_version;
  8. global $snmp_default_community;
  9. $new[device_name] = $fname;
  10. $new[community] = $snmp_default_community;
  11. $new[snmp_version] = $snmp_default_version;
  12. insert_record($db_link, "devices", $new);
  13. $sSQL = "Select id from devices where device_name='$fname' order by id DESC";
  14. list ($new_id) = mysqli_fetch_array(mysqli_query($db_link, $sSQL));
  15. LOG_INFO($db_link, "Created new device device_name=$fname");
  16. unset($_POST);
  17. header("location: editswitches.php?id=$new_id");
  18. }
  19. }
  20. if (isset($_POST["building_id"])) {
  21. $f_building_id = $_POST["building_id"] * 1;
  22. } else {
  23. $f_building_id = 0;
  24. }
  25. if (isset($_POST["remove"])) {
  26. $fid = $_POST["fid"];
  27. while (list ($key, $val) = @each($fid)) {
  28. if ($val) {
  29. LOG_INFO($db_link, "Delete device id: $val");
  30. unbind_ports($db_link, $val);
  31. delete_record($db_link, "connections", "device_id=$val");
  32. delete_record($db_link, "device_ports", "device_id=$val");
  33. $new[deleted] = 1;
  34. update_record($db_link, "devices", "id='$val'", $new);
  35. }
  36. }
  37. header("Location: " . $_SERVER["REQUEST_URI"]);
  38. }
  39. unset($_POST);
  40. require_once ($_SERVER['DOCUMENT_ROOT']."/inc/header.php");
  41. print_device_submenu($page_url);
  42. ?>
  43. <div id="cont">
  44. <br>
  45. <form name="def" action="index.php" method="post">
  46. <table class="data">
  47. <tr class="info" align="center">
  48. <td class="info" colspan=5>Показать оборудование из</td>
  49. <td class="info" colspan=5> <?php print_building_select($db_link, "building_id", $f_building_id); ?> <input type="submit" name="apply" value="Apply"></td>
  50. </tr>
  51. <tr align="center">
  52. <td><input type="checkbox" onClick="checkAll(this.checked);"></td>
  53. <td><b>id</b></td>
  54. <td><b>Название</b></td>
  55. <td><b>IP</b></td>
  56. <td><b>Модель</b></td>
  57. <td><b>Расположен</b></td>
  58. <td><b>Портов</b></td>
  59. <td><b>Nagios</b></td>
  60. <td><b>Router</b></td>
  61. <td><b>Discavery</b></td>
  62. </tr>
  63. <?
  64. $filter = '';
  65. if ($f_building_id > 0) { $filter = ' and building_id=' . $f_building_id; }
  66. $switches = get_records($db_link,'devices','deleted=0 '.$filter.' ORDER BY ip');
  67. foreach ($switches as $row) {
  68. print "<tr align=center>\n";
  69. $cl = "data";
  70. if (isset($row['nagios_status'])) {
  71. if ($row['nagios_status'] == 'DOWN') { $cl = 'shutdown'; }
  72. if ($row['nagios_status'] == 'UP') { $cl = 'up'; }
  73. }
  74. print "<td class=\"$cl\" style='padding:0'><input type=checkbox name=fid[] value=".$row['id']."></td>\n";
  75. print "<td class=\"$cl\"><input type=hidden name=\"id\" value=".$row['id'].">".$row['id']."</td>\n";
  76. print "<td class=\"$cl\" align=left><a href=editswitches.php?id=".$row['id'].">" . $row['device_name'] . "</a></td>\n";
  77. if (isset($row['user_id']) and $row['user_id']>0) {
  78. print "<td class=\"$cl\"><a href=/admin/users/edituser.php?id=".$row['user_id'].">".$row['ip']."</a></td>\n";
  79. } else {
  80. print "<td class=\"$cl\">".$row['ip']."</td>\n";
  81. }
  82. print "<td class=\"$cl\">" . get_vendor_name($db_link, $row['vendor_id']) . " " . $row['device_model'] . "</td>\n";
  83. print "<td class=\"$cl\">" . get_building($db_link, $row['building_id']) . "(" . $row['comment'] . ")</td>\n";
  84. print "<td class=\"$cl\">".$row['port_count']."</td>\n";
  85. print "<td class=\"$cl\">" . get_qa($row['nagios']) . "</td>\n";
  86. print "<td class=\"$cl\">" . get_qa($row['is_router']) . "</td>\n";
  87. print "<td class=\"$cl\">" . get_qa($row['discovery']) . "</td>\n";
  88. }
  89. ?>
  90. </table>
  91. <table class="data">
  92. <tr align=left>
  93. <td>Название <input type=text name=newswitches value="Unknown"></td>
  94. <td><input type="submit" name="create" value="Добавить"></td>
  95. <td align="right"><input type="submit" name="remove" value="Удалить"></td>
  96. </tr>
  97. </table>
  98. </form>
  99. <table class="data">
  100. <tr>
  101. <td>Device status</td>
  102. </tr>
  103. <tr>
  104. <td class="shutdown">Down</td>
  105. <td class="up">Online</td>
  106. <tr>
  107. </table>
  108. <?
  109. require_once ($_SERVER['DOCUMENT_ROOT']."/inc/footer.php");
  110. ?>