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