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