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>';
