function divCableLine1($coors, $CableLineId, $nodeInfo, $tmpT = FALSE)
{
$OpenGIS = "(" . $coors[0]->lon . "," . $coors[0]->lat . ")";
$wr['id'] = $CableLineId;
$res = CableLine_SELECT(0, $wr, $tmpT);
$CableLine = $res['rows'][0];
unset($wr);
$wr['CableLine'] = $CableLineId;
$query = 'SELECT * FROM "' . tmpTable('CableLinePoint', $tmpT) . '"' . genWhere($wr) . 'ORDER BY "sequence"';
$res2 = PQuery($query);
$CableLinePoints = $res2['rows'];
for ($i = 0; $i < count($CableLinePoints); $i++) {
$point = $CableLinePoints[$i];
if ($point['OpenGIS'] == $OpenGIS) {
$name = $nodeInfo['name'];
$NetworkBoxId = $nodeInfo['NetworkBoxId'];
$note = $nodeInfo['note'];
$SettlementGeoSpatial = "NULL";
$building = $nodeInfo['building'];
$apartment = $nodeInfo['apartment'];
$res3 = NetworkNode_Add($name, $NetworkBoxId, $note, $OpenGIS, $SettlementGeoSpatial, $building, $apartment, $tmpT);
$NetworkNodeId = $res3['rows'][0]['id'];
$seq = $point['sequence'];
$wr['sequence'] = $seq;
$upd['OpenGIS'] = "NULL";
$upd['NetworkNode'] = $NetworkNodeId;
CableLinePoint_UPDATE($upd, $wr, $tmpT);
$wr1 = array('sequence' => array('val' => $seq, 'sign' => '>'));
error_log(genWhere($wr1));
$ins = array();
$ins['CableType'] = $CableLine['CableType'];
$ins['name'] = $CableLine['name'] . "_div";
$ins['comment'] = $CableLine['comment'];
$query = 'INSERT INTO "' . tmpTable('CableLine', $tmpT) . '"' . genInsert($ins) . ' RETURNING id';
error_log($query);
$res4 = PQuery($query);
$NCableLineId = $res4['rows'][0]['id'];
$ins = array();
foreach ($point as $key => $value) {
if ($key != "id" && $key != "sequence") {
if ($value != "") {
$ins[$key] = $value;
} else {
$ins[$key] = "NULL";
}
}
}
$ins['CableLine'] = $NCableLineId;
$ins['sequence'] = 1;
$ins['OpenGIS'] = 'NULL';
$ins['NetworkNode'] = $NetworkNodeId;
$query = 'INSERT INTO "' . tmpTable('CableLinePoint', $tmpT) . '"' . genInsert($ins);
error_log($query);
PQuery($query);
$query = 'UPDATE "' . tmpTable('CableLinePoint', $tmpT) . '" SET "CableLine" = ' . $NCableLineId . ', sequence = sequence + 1 - ' . $seq . ' WHERE "sequence" > ' . $seq . ' AND "CableLine" = ' . $CableLineId;
error_log($query);
PQuery($query);
break;
}
}
}
$message = 'Точки с таким ID не существует!<br />
<a href="CableLinePoint.php">Назад</a>';
showMessage($message, 0);
}
$rows = $res['rows'];
$smarty->assign("id", $rows[0]['id']);
$smarty->assign("OpenGIS", $rows[0]['OpenGIS']);
$cableLineId = $rows[0]['CableLine'];
$smarty->assign("cablelineid", $cableLineId);
$networkNodeId = $rows[0]['NetworkNode'];
if ($networkNodeId == '') {
$networkNodeId = 'NULL';
}
$smarty->assign("meterSign", $rows[0]['meterSign']);
$smarty->assign("note", $rows[0]['note']);
$res = CableLine_SELECT(0, array('id' => $cableLineId));
$rows = $res['rows'];
$smarty->assign("cableline", $rows[0]['name']);
$res = NetworkNode_SELECT(0, '', array('id' => $networkNodeId));
$rows = $res['rows'];
$i = -1;
while (++$i < $res['count']) {
$comboBox_NetworkNode_Values[] = $rows[$i]['id'];
$comboBox_NetworkNode_Text[] = $rows[$i]['name'];
}
$comboBox_NetworkNode_Values[] = 'NULL';
$comboBox_NetworkNode_Text[] = 'Нет';
$smarty->assign("combobox_networknode_values", $comboBox_NetworkNode_Values);
$smarty->assign("combobox_networknode_text", $comboBox_NetworkNode_Text);
$smarty->assign("combobox_networknode_selected", $networkNodeId);
} elseif ($_GET['mode'] == 'charac') {
function CableLine_Info($cableLineId)
{
$wr['id'] = $cableLineId;
$res = CableLine_SELECT(0, $wr);
$result['CableLine'] = $res;
$CableType = $result['CableLine']['rows'][0]['CableType'];
$wr['id'] = $CableType;
$res = CableType_SELECT(0, $wr);
$result['CableLine']['rows'][0]['CableTypeMarking'] = $res['rows'][0]['marking'];
$result['CableLine']['rows'][0]['CableTypeManufacturer'] = $res['rows'][0]['manufacturer'];
$result['CableLine']['rows'][0]['CableTypeId'] = $res['rows'][0]['id'];
$result['CableLinePoints'] = getCableLinePoint_NetworkNodeName($cableLineId);
return $result;
}
$message = '!!!';
showMessage($message, 0);
}
$smarty->assign("mode", "charac");
$wr['id'] = $_GET['cabletypeid'];
$res = CableType_SELECT(0, $wr);
if ($res['count'] < 1) {
$message = 'Типа кабеля с таким ID не существует!<br />
<a href="CableType.php">Назад</a>';
showMessage($message, 0);
}
$rows = $res['rows'];
$changeDelete = '<a href="CableType.php?mode=change&cabletypeid=' . $_GET['cabletypeid'] . '">Изменить</a>';
unset($wr);
$wr['CableType'] = $_GET['cabletypeid'];
$res2 = CableLine_SELECT('', $wr, '', '');
$changeDelete = '';
if ($res2['count'] == 0) {
$changeDelete .= '<a href="CableType.php?mode=delete&cabletypeid=' . $_GET['cabletypeid'] . '">Удалить</a>';
}
$smarty->assign("id", $rows[0]['id']);
$smarty->assign("marking", $rows[0]['marking']);
$smarty->assign("manufacturer", $rows[0]['manufacturer']);
$smarty->assign("tubeQuantity", $rows[0]['tubeQuantity']);
$smarty->assign("fiberPerTube", $rows[0]['fiberPerTube']);
$smarty->assign("tensileStrength", $rows[0]['tensileStrength']);
$smarty->assign("diameter", $rows[0]['diameter']);
$smarty->assign("comment", nl2br($rows[0]['comment']));
$smarty->assign("ChangeDelete", $changeDelete);
} elseif ($_GET['mode'] == 'add') {
$smarty->assign("id", '');
<?php
require_once 'backend/CableType.php';
print '<meta charset="UTF-8">';
if (isset($_GET['CableLine']) && ctype_digit($_GET['CableLine'])) {
$CableLine = $_GET['CableLine'];
$wr['id'] = $CableLine;
$cl = CableLine_SELECT(-1, $wr);
$CableType = $cl['rows'][0]['CableType'];
$wr['id'] = $CableType;
$ct = CableType_SELECT(-1, $wr);
$fibersCount = $ct['rows'][0]['tubeQuantity'] * $ct['rows'][0]['fiberPerTube'];
for ($i = 1; $i <= $fibersCount; $i++) {
print "Добавляем волокно #" . $i . "...<br/>";
$ins['CableLine'] = $CableLine;
$ins['fiber'] = $i;
$query = 'INSERT INTO "OpticalFiber"' . genInsert($ins);
PQuery($query);
}
print "Добавление волокон завершено!";
}
//$cableLine_arr[] = $rows2[$i]['SettlementGeoSpatial'];
$cableLine_arr[] = '<a href="CableLinePoint.php?mode=change&cablelinepointid=' . $rows2[$i]['id'] . '&cablelineid=' . $cableLineId . '">Изменить</a>';
$cableLine_arr[] = '<a href="CableLinePoint.php?mode=delete&cablelinepointid=' . $rows2[$i]['id'] . '">Удалить</a>';
}
}
$smarty->assign("data", $cableLine_arr);
} elseif ($_GET['mode'] == 'change' and isset($_GET['cablelineid'])) {
if ($_SESSION['class'] > 1) {
$message = '!!!';
showMessage($message, 0);
}
$smarty->assign("mode", "add_change");
$smarty->assign("mod", "1");
$smarty->assign("back", getenv("HTTP_REFERER"));
$wr['id'] = $_GET['cablelineid'];
$res = CableLine_SELECT('', $wr);
if ($res['count'] < 1) {
$message = 'Кабеля с таким ID не существует!<br />
<a href="CableType.php">Назад</a>';
showMessage($message, 0);
}
$rows = $res['rows'];
$smarty->assign("id", $rows[0]['id']);
$cableTypeId = $rows[0]['CableType'];
$smarty->assign("length", $rows[0]['length']);
$smarty->assign("comment", $rows[0]['comment']);
$smarty->assign("name", $rows[0]['name']);
$res = CableType_SELECT('', '');
$rows = $res['rows'];
$i = -1;
while (++$i < $res['count']) {
