function getNetworkNodeInfo($networkNodeId) { $res = getNetworkNode_NetworkBoxName($networkNodeId); $result['NetworkNode'] = $res; $query = 'SELECT "clp".id, "clp"."CableLine", "clp"."meterSign", "clp"."NetworkNode", "clp"."note", "clp"."Apartment", "clp"."Building", "clp"."SettlementGeoSpatial", "cl"."name" AS "clname", COUNT("OFJ"."OpticalFiberSplice") AS "fiberSpliceCount" FROM "CableLinePoint" AS "clp" LEFT JOIN "CableLine" AS "cl" ON "cl".id="clp"."CableLine" LEFT JOIN "OpticalFiber" AS "OF" ON "OF"."CableLine" = "cl".id LEFT JOIN "OpticalFiberJoin" AS "OFJ" ON "OFJ"."OpticalFiber" = "OF".id WHERE "clp"."NetworkNode"=' . pg_escape_string($networkNodeId) . ' GROUP BY "clp".id, "cl"."name", "clp"."CableLine", "clp"."meterSign", "clp"."NetworkNode", "clp"."note", "clp"."Apartment", "clp"."Building", "clp"."SettlementGeoSpatial"'; $res2 = PQuery($query); $result['NetworkNode']['CableLinePoints'] = $res2; unset($wr); $res = getFiberSpliceOrganizerInfo(-1, -1, $networkNodeId, 0); $result['NetworkNode']['FSO'] = $res; return $result; }
} elseif ($res == 1) { header("Refresh: 3; url=" . $back); $message = 'Кассета добавлена!'; $error = 0; } else { $message = 'Неверно заполнены поля!'; $error = 1; } } showMessage($message, $error); } else { $FSOT_Values = array(); $FSOT_Text = array(); if (!isset($_GET['mode'])) { $page = isset($_GET['page']) ? $_GET['page'] : 1; $res = getFiberSpliceOrganizerInfo($config['LinesPerPage'], ($page - 1) * $config['LinesPerPage'], -1, -1); $pages = genPages('FSO.php?', ceil($res['allPages'] / $config['LinesPerPage']), $page); $rows = $res['rows']; $i = -1; $FSO = array(); while (++$i < $res['count']) { $FSO[] = $rows[$i]['id']; $FSO[] = $rows[$i]['FiberSpliceOrganizationTypeMarking']; $FSO[] = $rows[$i]['FiberSpliceOrganizationTypeManufacturer']; $FSO[] = '<a href="NetworkNodes.php?mode=charac&nodeid=' . $rows[$i]['NetworkNodeId'] . '">' . $rows[$i]['NetworkNodeName'] . '</a>'; $FSO[] = $rows[$i]['FiberSpliceCount']; $FSO[] = '<a href="FSO.php?mode=change&fsoid=' . $rows[$i]['id'] . '">Изменить</a>'; if ($rows[$i]['NetworkNodeName'] == '') { $FSO[] = '<a href="FSO.php?mode=delete&fsoid=' . $rows[$i]['id'] . '">Удалить</a>'; } else { $FSO[] = '';
$smarty->assign("ComboBox_Fibers_values", $fibers); $smarty->assign("ComboBox_Fibers_text", $fibers); if ($_GET['mode'] == 'change') { $OFJ_id = $_GET['spliceid']; $smarty->assign("SpliceId", $OFJ_id); $res = getNodeFibers($networkNodeId, $OFJ_id); $fso = $res['rows'][0]['FiberSpliceOrganizer']; $smarty->assign("attenuation", $res['rows'][0]['attenuation']); $smarty->assign("note", $res['rows'][0]['note']); } else { $smarty->assign("attenuation", ''); $smarty->assign("note", ''); $smarty->assign("SpliceId", ''); $fso = ''; } $res = getFiberSpliceOrganizerInfo(-1, -1, $networkNodeId); $ComboBox_FibersSpliceOrganizer_Values = array(); $ComboBox_FibersSpliceOrganizer_Text = array(); for ($i = 0; $i < $res['count']; $i++) { $ComboBox_FibersSpliceOrganizer_Values[] = $res['rows'][$i]['id']; $ComboBox_FibersSpliceOrganizer_Text[] = $res['rows'][$i]['id'] . " (" . $res['rows'][$i]['FiberSpliceOrganizationTypeMarking'] . ")"; } $smarty->assign("ComboBox_FibersSpliceOrganizer_values", $ComboBox_FibersSpliceOrganizer_Values); $smarty->assign("ComboBox_FibersSpliceOrganizer_text", $ComboBox_FibersSpliceOrganizer_Text); $smarty->assign("Combobox_FibersSpliceOrganizer_selected", $fso); } elseif (isset($_GET['networknodeid'])) { $networkNodeId = $_GET['networknodeid']; $wr['id'] = $networkNodeId; $res = NetworkNode_SELECT('', '', $wr); $networkNodeName = $res['rows'][0]['name']; $res = getFiberTable($networkNodeId);