add_log($table_cruz_conn, clean($_POST['port_id']), $result, $user_id); pg_query("DELETE FROM " . $table_cruz_conn . " WHERE id = " . clean($_POST['port_id'])); die; } echo "exist"; die; } // вывод списка кабелей на узле if (isset($_POST['act']) && $_POST['act'] == 's_cable_list' && @is_numeric($_POST['pq_id']) && @is_numeric($_POST['cable_id']) && @is_numeric($_POST['fiber_id'])) { //echo get_cable_select(clean($_POST['fiber_id']),clean($_POST['pq_id']),clean($_POST['cable_id']),clean($_POST['enable'])); echo get_cable_select(clean($_POST['fiber_id']), clean($_POST['pq_id']), clean($_POST['cable_id'])); die; } // вывод не подключенных волокон в кабеле if (isset($_POST['act']) && $_POST['act'] == 's_fiber_list' && @is_numeric($_POST['node_id']) && @is_numeric($_POST['pq_id']) && @is_numeric($_POST['cable_id']) && @is_numeric($_POST['to_fiber_id']) && @is_numeric($_POST['fiber_id'])) { echo get_fiber_select(clean($_POST['fiber_id']), clean($_POST['node_id']), clean($_POST['pq_id']), @clean($_POST['cable_id']), @clean($_POST['to_fiber_id']), @clean($_POST['port_id']), clean($_POST['enable'])); die; } // ввод нового соединения волокон if (isset($_POST['act']) && $_POST['act'] == 'n_fiber_conn' && @is_numeric($_POST['fiber_id']) && @is_numeric($_POST['to_fiber_id']) && @is_numeric($_POST['node_id'])) { if (!@pg_result(pg_query("SELECT id FROM " . $table_fiber_conn . " WHERE fiber_id_1=" . clean($_POST['fiber_id']) . " AND fiber_id_2=" . clean($_POST['to_fiber_id']) . " AND node_id=" . clean($_POST['node_id']) . ";"), 0)) { pg_query("INSERT INTO " . $table_fiber_conn . " (fiber_id_1,fiber_id_2,node_id,user_id) VALUES (" . clean($_POST['fiber_id']) . ", " . clean($_POST['to_fiber_id']) . ", " . clean($_POST['node_id']) . "," . $user_id . ")"); // установить галки занятоски портов pg_query("UPDATE " . $table_cruz_conn . " SET used = true WHERE id = (SELECT cc1.id FROM " . $table_pq . " AS pq1, " . $table_cruz_conn . " AS cc1 WHERE pq1.node = " . clean($_POST['node_id']) . " AND pq1.id = cc1.pq_id AND cc1.fiber_id = " . clean($_POST['fiber_id']) . ");"); pg_query("UPDATE " . $table_cruz_conn . " SET used = true WHERE id = (SELECT cc1.id FROM " . $table_pq . " AS pq1, " . $table_cruz_conn . " AS cc1 WHERE pq1.node = " . clean($_POST['node_id']) . " AND pq1.id = cc1.pq_id AND cc1.fiber_id = " . clean($_POST['to_fiber_id']) . ");"); /*$result = pg_query("SELECT cc1.id FROM fibers.cruz_conn AS cc1, fibers.pq AS pq1, fibers.fiber_conn AS fc1 WHERE ((cc1.fiber_id = fc1.fiber_id_1 OR cc1.fiber_id = fc1.fiber_id_2) AND fc1.node_id = pq1.node ) AND cc1.pq_id = pq1.id AND cc1.fiber_id IS NOT NULL AND cc1.used IS NULL"); if (pg_num_rows($result)) { while ($row = pg_fetch_assoc($result)) { echo $row['id'].' '; pg_query("UPDATE ".$table_cruz_conn." SET used = true WHERE id = ".$row['id'].";");
} // селект (выбор кабеля) $content .= '<input type="hidden" value="' . $cable_id . '">'; if (array_key_exists($pq_id . '_' . $cable_id, $cable_array)) { $select = $cable_array[$pq_id . '_' . $cable_id]; } else { $select = get_cable_select($fiber_id, $pq_id_, $cable_id); $cable_array[$pq_id . '_' . $cable_id] = $select; } $content .= ' <td class="text-left input-control text m0"> <select class="cable" id="cable_id_' . $fiber_id . '"' . (($group_access['cable_edit'] || $group_access['port_conn'] && !empty($port_id)) && empty($to_fiber_id) ? '' : ' disabled') . '>' . $select . '</select> </td>'; $content .= '<input type="hidden" value="' . $to_fiber_id . '">'; $content .= ' <td class="text-left input-control text m0">' . get_fiber_select($fiber_id, $node_id, $pq_id_, $cable_id, $to_fiber_id, $port_id, ($group_access['cable_edit'] || $group_access['port_conn']) && empty($to_fiber_id) ? false : true) . '</td>'; $content .= '<td class="toolbar m0">'; if ($group_access['cable_edit'] || $group_access['port_conn'] && !empty($port_id)) { if ($to_fiber_id) { $content .= '<button class="icon-cancel-2 m0" id="del_fib_conn_' . $fiber_id . '" title="Удалить"></button>'; } else { $content .= '<button class="icon-checkmark m0" id="new_fib_conn_' . $fiber_id . '" title="Ok"></button>'; } } else { $content .= '<button class="m0"></button>'; } // будет всегда выводить кнопки $content .= ' <button class="icon-share-2 m0" id="find_fib_conn_' . $fiber_id . '" title="Отследить ОВ"></button>'; $content .= '<button class="icon-cancel m0" id="f_fiber_clean_' . $fiber_id . '" title="Очистить" style="display:none" ></button>'; $content .= ' <button class="icon-earth m0" id="show_fib_map_' . $fiber_id . '" rel="lat=' . $y . '&lon=' . $x . '" title="Показать на карте"></button>'; $content .= '</td>';