function Users_DELETE($wr)
{
$query = 'DELETE FROM "Users"';
$query .= genWhere($wr);
$result = PQuery($query);
return $result;
}
function addOpticalFiberJoin($CableLine, $fiber, $OpticalFiberSplice)
{
$query = 'INSERT INTO "OpticalFiberJoin"(
"OpticalFiber", "OpticalFiberSplice")
VALUES ((SELECT id FROM "OpticalFiber" WHERE "fiber"=' . pg_escape_string($fiber) . ' AND "CableLine"=' . pg_escape_string($CableLine) . '), ' . pg_escape_string($OpticalFiberSplice) . ')';
$result = PQuery($query);
return $result;
}
function OpticalFiber_DELETE($wr, $sign = '=')
{
$query = 'DELETE FROM "OpticalFiber"';
$query .= genWhere($wr, $sign);
$result = PQuery($query);
loggingIs(3, 'OpticalFiber', '', $wr['id']);
return $result;
}
function loggingIs_SELECT($linesPerPage = -1, $skip = -1)
{
$query = 'SELECT "laa".id, "laa"."table", "laa"."record", to_char("laa"."time", \'yyyy-mm-dd HH24:MI:SS\') AS "time", "laa"."action", "laa"."description", "laa"."admin", "u"."username", "ltl"."name" FROM "LogAdminActions" AS "laa" LEFT JOIN "Users" AS "u" ON "u".id="laa"."admin" LEFT JOIN "LogTableList" AS "ltl" ON "ltl".id="laa"."table" ORDER BY "time" DESC';
if ($linesPerPage > 0 && $skip >= 0) {
$query .= ' LIMIT ' . $linesPerPage . ' OFFSET ' . $skip;
}
$result = PQuery($query);
$query = 'SELECT COUNT(*) AS "count" FROM "LogAdminActions"';
$res = PQuery($query);
$result['allPages'] = $res['rows'][0]['count'];
return $result;
}
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;
}
function rollbackTransaction()
{
global $inTransaction;
if (!$inTransaction) {
return false;
}
$res = PQuery("ROLLBACK WORK;");
if (isset($res['error'])) {
return false;
}
$inTransaction = false;
return true;
}
function saveTmpData()
{
$query = 'BEGIN; LOCK "MapSettings";';
$tables = getTables();
$tbl_del = "";
$ins = "";
for ($i = 0; $i < count($tables); $i++) {
$table = $tables[$i];
$tmpT = tmpTable($table, TRUE);
if (strlen($tbl_del) > 0) {
$tbl_del .= ', ';
}
$tbl_del .= '"' . $table . '"';
$ins .= ' INSERT INTO "' . $table . '" SELECT * FROM "' . $tmpT . '";';
}
$query .= ' TRUNCATE ' . $tbl_del . ' CASCADE;' . $ins;
$query .= ' COMMIT;';
$res = PQuery($query);
if (!isset($res['error'])) {
$res = setMapLastEdit();
}
if (!isset($res['error'])) {
$res = CheckData();
}
return $res;
}
if (isset($_POST['login']) && $_POST['login'] == 'login') {
require_once "backend/functions.php";
require_once "design_func.php";
require_once "smarty.php";
$passwordHash = md5($_POST['password']);
$login = $_POST['user'];
if (!preg_match("/^\\w{3,}\$/", $login)) {
$message = 'Неверный логин!';
$error = 1;
showMessage($message, $error);
}
$res = PQuery('SELECT id, "class" FROM "Users" WHERE "username"=\'' . $login . '\' AND "password"=\'' . $passwordHash . '\'');
if ($res['count'] < 1) {
$message = 'Такого пользователя не существует!';
$error = 1;
showMessage($message, $error);
}
session_start();
$token = md5(time() . $login);
if ($_POST['remember']) {
setcookie('token', $token, time() + 60 * 60 * 24 * 14);
}
PQuery('UPDATE "Users" SET "token"=\'' . $token . '\' WHERE "username"=\'' . $login . '\'');
$_SESSION['user'] = $login;
$_SESSION['class'] = $res['rows'][0]['class'];
header("Location: " . getenv("HTTP_REFERER"));
} else {
require_once "auth.php";
header("Location: " . str_replace(strrchr(__FILE__, '/'), "", $_SERVER['REQUEST_URI']));
}
<?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 "Добавление волокон завершено!";
}
function getNetworkBoxList($sort, $wr, $linesPerPage = -1, $skip = -1)
{
$query = 'SELECT "NB".id, "NB"."NetworkBoxType", "NB"."inventoryNumber", "NBT"."marking", "NN"."name" AS "NNname", "NN".id AS "NNid" FROM "NetworkBox" AS "NB"';
$query .= ' LEFT JOIN "NetworkBoxType" AS "NBT" ON "NBT".id="NB"."NetworkBoxType"';
$query .= ' LEFT JOIN "NetworkNode" AS "NN" ON "NN"."NetworkBox"="NB".id';
$where = '';
if ($wr != '') {
$where = genWhere($wr);
}
$query .= $where . ' ORDER BY "inventoryNumber"';
if ($sort == 1) {
$query .= ' ORDER BY "NB"."inventoryNumber" ';
}
if ($linesPerPage > 0 and $skip >= 0) {
$query .= ' LIMIT ' . $linesPerPage . ' OFFSET ' . $skip;
}
$result = PQuery($query);
$query = 'SELECT COUNT(*) AS "count" FROM "NetworkBox"' . $where;
$res = PQuery($query);
$result['allPages'] = $res['rows'][0]['count'];
return $result;
}
function getFiberSpliceOrganizerInfo($linesPerPage = -1, $skip = -1, $networkNode = -1, $free = 1)
{
/* $query = 'SELECT DISTINCT "fso".id,
"fso"."FiberSpliceOrganizationType" AS "FiberSpliceOrganizationTypeId",
"fsot"."marking" AS "FiberSpliceOrganizationTypeMarking",
"fsot"."manufacturer" AS "FiberSpliceOrganizationTypeManufacturer",
"nn".id AS "NetworkNodeId", "nn"."name" AS "NetworkNodeName",
COUNT(DISTINCT "fs".id) AS "FiberSpliceCount"
FROM "FiberSpliceOrganizer" AS "fso"
LEFT JOIN "FiberSplice" AS "fs" ON "fs"."FiberSpliceOrganizer"="fso".id
LEFT JOIN "CableLinePoint" AS "clp" ON "clp".id="fs"."CableLinePointA" OR "clp".id="fs"."CableLinePointB"
LEFT JOIN "NetworkNode" AS "nn" ON "nn".id="clp"."NetworkNode"
LEFT JOIN "FiberSpliceOrganizerType" AS "fsot" ON "fsot".id="fso"."FiberSpliceOrganizationType"
WHERE "fs"."FiberSpliceOrganizer"="fso".id'; */
$query = 'SELECT DISTINCT ON ("fso".id) "fso".id,
"fso"."FiberSpliceOrganizationType" AS "FiberSpliceOrganizationTypeId",
"fsot"."marking" AS "FiberSpliceOrganizationTypeMarking",
"fsot"."manufacturer" AS "FiberSpliceOrganizationTypeManufacturer",
"nn".id AS "NetworkNodeId", "nn"."name" AS "NetworkNodeName",
COUNT("ofs".id) AS "FiberSpliceCount"
FROM "FiberSpliceOrganizer" AS "fso"
LEFT JOIN "OpticalFiberSplice" AS "ofs" ON "ofs"."FiberSpliceOrganizer"="fso".id
LEFT JOIN "NetworkNode" AS "nn" ON "nn".id="ofs"."NetworkNode"
LEFT JOIN "FiberSpliceOrganizerType" AS "fsot" ON "fsot".id="fso"."FiberSpliceOrganizationType"';
if ($networkNode != -1) {
if (strpos("WHERE", $query) >= 0) {
$query .= " WHERE ";
}
$query .= ' "nn".id=' . $networkNode;
}
if ($free == 1) {
if (strpos("WHERE", $query) >= 0) {
$query .= ' OR "nn".id IS NULL';
} else {
$query .= ' WHERE "nn".id IS NULL';
}
}
$query .= ' GROUP BY "fso".id, "fsot"."marking", "fsot"."manufacturer", "nn".id,
"fso"."FiberSpliceOrganizationType", "nn"."name"';
if ($linesPerPage > 0 and $skip >= 0) {
$query .= ' LIMIT ' . $linesPerPage . ' OFFSET ' . $skip;
}
$result = PQuery($query);
$query = 'SELECT COUNT(*) AS "count" FROM "FiberSpliceOrganizer"';
$res = PQuery($query);
$result['allPages'] = $res['rows'][0]['count'];
return $result;
}
function deleteSplice($OFJ_id)
{
$wr['id'] = $OFJ_id;
$res = OpticalFiberJoin_SELECT(1, $wr);
$OFS_id = $res['rows'][0]['OpticalFiberSplice'];
$query = 'DELETE FROM "OpticalFiberJoin" WHERE "OpticalFiberSplice"=' . $OFS_id;
$res = PQuery($query);
$query = 'DELETE FROM "OpticalFiberSplice" WHERE id=' . $OFS_id;
$res = PQuery($query);
return $res;
}
function getCableLinePoints($cableLine, $onlyFree = FALSE, $tmpT = FALSE)
{
$wr['CableLine'] = $cableLine;
$query = 'SELECT "clp".id, "clp"."OpenGIS", "clp"."meterSign", "clp"."note", "clp"."sequence",
"NN"."OpenGIS" AS "NNOpenGIS"
FROM "' . tmpTable('CableLinePoint', $tmpT) . '" AS "clp"
LEFT JOIN "' . tmpTable('NetworkNode', $tmpT) . '" AS "NN" ON "NN".id = "clp"."NetworkNode"' . genWhere($wr);
if ($onlyFree) {
$query .= ' AND "clp"."OpenGIS" IS NOT NULL';
}
$query .= ' ORDER BY "sequence"';
$result = PQuery($query);
return $result;
}
<?php
session_start();
require_once "backend/functions.php";
require_once "smarty.php";
if (isset($_COOKIE['token']) && !isset($_SESSION['user'])) {
$token = htmlspecialchars($_COOKIE['token']);
$res = PQuery('SELECT "username", "class" FROM "Users" WHERE "token"=\'' . $token . '\'');
if ($res['count'] < 1) {
setcookie('token', '');
} else {
$_SESSION['user'] = $res['rows'][0]['username'];
$_SESSION['class'] = $res['rows'][0]['class'];
}
}
if (!isset($_SESSION['user'])) {
$smarty->assign('warning', '<center><font color="red"><b>Нужно авторизоватся!</b></font></center>');
$smarty->display('login.tpl');
die;
}
