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']) {