// удаление порта
if (isset($_POST['act']) && $_POST['act'] == 'd_port' && @is_numeric($_POST['port_id'])) {
if (@pg_result(pg_query("SELECT id FROM " . $table_cruz_conn . " WHERE id=" . clean($_POST['port_id']) . " AND fiber_id IS NULL"), 0)) {
$data_old = pg_fetch_assoc(pg_query("SELECT * FROM " . $table_cruz_conn . " WHERE id = " . clean($_POST['port_id'])));
$result = serialize($data_old);
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");
$content .= '<td class="m5 color" ' . ($group_access['fiber_edit'] ? 'id="color_fib_' . $fiber_id . '" rel_id="' . $fiber_id . '" rel_type="fib" ' : '') . 'style="background-color: #' . $fiber_fib_color . ';" title="Цвет волокна: ' . ($row_fib['fib_name'] ? $row_fib['fib_name'] : 'не задан') . '">' . ($row_fib['fib_stroke'] ? '/' : ' ') . '</td>';
$content .= '<input type="hidden" id="pq_id_' . $fiber_id . '" value="' . $pq_id_ . '">';
$content .= '<input type="hidden" id="to_node_' . $fiber_id . '" value="' . $to_node . '">';
// селект (выбор кросса/муфты)
//$group_access['cable_edit'] = 1;
//$group_access['port_conn'] = 0;
if ($pq_type != 1) {
$content .= '<td class="input-control text m0">' . get_pq_select($fiber_id, $node_id, $pq_id_, $pq_type, $pq_num, ($group_access['cable_edit'] || $group_access['port_conn']) && empty($to_fiber_id) ? false : true) . '
</td>';
}
// селект (выбор кабеля)
$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>';
